tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742401d1627716287-display-the-value-based-on-todays-date-edgetrading
Sheet: Trading

 |  |  |  |  |  |  |  | day end closing price |  |  |  |  |  |  |  |  |  | Profit/Loss
 |  |  |  | LOT SIZE |  | BUY/SELL Price |  | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-09 00:00:00 | 2021-08-10 00:00:00 | 2021-08-11 00:00:00
NATURALGAS AUG |  | BUY |  | 2500 |  | 302.7 |  | 301.9 | 289.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NATURALGAS SEP |  | SELL |  | 2500 |  | 303.3 |  | 302.6 | 291.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
ADANIENT AUG |  | BUY |  | 1000 |  | 1399 |  | 1403.7 | 1427.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ADANIENT SEP |  | SELL |  | 1000 |  | 1398.95 |  | 1410.55 | 1433.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
CANBK AUG |  | BUY |  | 5400 |  | 148.9 |  | 150 | 152.2 | 44410 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CANBK SEP |  | SELL |  | 5400 |  | 149.7 |  | 150.55 | 152.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
SBIN AUG |  | SELL |  | 1500 |  | 443.2 |  | 443.5 | 432.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SBIN SEP |  | BUY |  | 1500 |  | 445 |  | 445.15 | 434.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
TATAMOTORS AUG |  | BUY |  | 2850 |  | 296.5 |  | 294.3 | 295.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TATAMOTORS SEP |  | SELL |  | 2850 |  | 295.7 |  | 295.7 | 296.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
TECHM AUG |  | SELL |  | 600 |  | 1125 |  | 1132.8 | 1211.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TECHM SEP |  | BUY |  | 600 |  | 1130 |  | 1137.95 | 1216.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
ADANIPORTS AUG |  | BUY |  | 2500 |  | 687 |  |  | 677.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ADANIPORTS SEP |  | SELL |  | 1250 |  | 681.6 |  |  | 680.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Profit/Loss
Spreadsheet: jane_tholt__13055__June 12 With SOH Upgrade But No EOC Advantage
Sheet: Assign to East Contracts

East End Contracts
 | Shipper | K N Marketing, L.P. (9KEE) | WTG (9L6T) | Phillips Petroleum Company (9JPJ) | KN Marketing, L.P. (9L32) | Richardson Products II, Ltd. (9LAR) | Tenaska Marketing Ventures (9L9J) | Tenaska Marketing Ventures (9L9B) | Total East End CD & BD
 | R/S | FT1 | FT1 | FT1 | FT1 | FT1 | FT1 | FT1
 | Begin Date | 1999-05-01 00:00:00 | 2000-01-01 00:00:00 | 1998-09-01 00:00:00 | 2000-05-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00
 | End Date | 2002-04-30 00:00:00 | 2001-12-31 00:00:00 | 2003-08-31 00:00:00 | 2000-08-31 00:00:00 | 2001-03-31 00:00:00 | 2000-07-31 00:00:00 | 2000-07-31 00:00:00
 | Receipt | Anadarko | Permian | Permian | Permian | Permian | Permian | Permian
 | [NAME]. | IWTGAMER | IWTG DAL | IPHHUTCH | NN Sprayberry | [NAME] | Felmac | INNDUMAS
 | Dth Entitlements | 10500 | 5333 | 5000 | 12760 | 9375 | 10000 | 20000
 | Mcf/d Entitlements
 | Receipt Rights By Basin
 | San Juan
 | Permian
 | Anadarko
 | CD/BD By Delivery Point Location
 | ITOPOCK
 | North System
 | South System
 | West Flow On S. Line
 | Notes | in &  out Anadarko | N thru Plains | N thru Plains | N to Plains | N thru Plains | N thru Plains | N thru Plains
Assign Receipt Rights Proportionally Among Permian Pooling Areas
Plains Pooling Area
[NAME]
Waha Pooling Area | 0
Assign Anadarko Receipt Rights to Appropriate Shippers
Anadarko Pooling Area
 | Total Receipt Rights Assigned
Keystone and Waha Flowing North Through Plains
Spreadsheet: 55609d1255708164-hyperlinks-are-breaking-working-links
Sheet: Query Summary

[NAME] |  | Description
GET_IVD_CASES | 0 | in progress
GET_ORDER_CASES | 1
GET_IVD_CASE_CHILD_CASES | 2
GET_LINE_1A1B_2A2B_CASES | 3
GET_LINE_C13_CASES | 4
GET_LINE_2C_CASES | 5
GET_LINE_E21_CASES | 6
GET_LINE_E22_CASES | 7
GET_LINE_E23_CASES | 8
GET_LINE_D14_CASES | 9
GET_LINE_D16_CASES | 10
GET_LINE_D17_CASES | 11
GET_LINE_D18_CASES | 12
GET_LINE_D18A_CASES | 13
GET_LINE_D19_D20_CASES | 14
GET_LINE_I37_CASES | 15
GET_LINE_I38_CASES | 16
GET_LINE_F24_CASES | 17
GET_LINE_F25_CASES | 18
GET_LINE_F26_CASES | 19
GET_LINE_F27_CASES | 20
GET_LINE_F28_CASES | 21
GET_LINE_F29_CASES1 | 22
GET_LINE_F29_CASES2 | 23
GET_LINE_F29_CASES3 | 24
GET_LINE_2E_CASES | 25
GET_LINE_E21A_CASES1 | 26
GET_LINE_E21A_CASES2 | 27
GET_LINE_E21A_CASES3 | 28
GET_LINE_E21A_CASES4 | 29
GET_LINE_2E_CASES1 | 30
GET_LINE_1D_1E_CASES | 31
GET_LINE_1F_1G_CASES | 32
GET_LINE_H33_CASES | 33
GET_LINE_H34_CASES | 34
GET_LINE_H35_CASES | 35
GET_LINE_H36_CASES | 36
Spreadsheet: 164163d1340666546-trouble-in-separating-data-sample-data-9irsananwar-oeldere-
Sheet: Sheet1

name | pickup date
alice | 2012-01-03 00:00:00 |  |  | Aantal van pickup date | pickup date
barney | 2012-01-03 00:00:00 |  |  | name | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | Eindtotaal
hector | 2012-01-04 00:00:00 |  |  | alice | 1 |  | 1 |  |  |  | 1 |  | 3
alice | 2012-01-05 00:00:00 |  |  | barney | 1 |  |  |  | 1 |  |  | 1 | 3
[NAME] | 2012-01-06 00:00:00 |  |  | dean |  |  |  |  |  |  |  | 1 | 1
eugene | 2012-01-07 00:00:00 |  |  | eugene |  |  |  |  | 1 |  |  | 1 | 2
barney | 2012-01-07 00:00:00 |  |  | hector |  | 1 |  |  |  |  |  |  | 1
ian | 2012-01-09 00:00:00 |  |  | ian |  |  |  |  |  | 1 |  |  | 1
alice | 2012-01-10 00:00:00 |  |  | [NAME] |  |  |  | 1 |  |  |  |  | 1
eugene | 2012-01-11 00:00:00 |  |  | Eindtotaal | 2 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 12
dean | 2012-01-11 00:00:00
barney | 2012-01-11 00:00:00
Spreadsheet: 51133d1250690140-conditional-formatting-using-different-sheets-mearsy
Sheet: Sheet1

Plant | Customer Service Measure
Barking | 0.9157734204793029
Ipswich | 0.8996061643835617
[NAME] | 0.8879028436018958
Aberdeen | 0.8856862745098039
Wolves | 0.8688521882741536
Brinsworth | 0.8544619105199516
CLS | 0.8507983193277311
Crawley | 0.781469465648855
Totton | 0.8692936802973977
Bristol | 0.7800200400801603
Plymouth | 0.8262549800796813
Spreadsheet: 841474d1693643516-extract-records-based-on-2-criteria-02092023-sample-file-for-excelforum-aligw
Sheet: Sheet1

 |  |  |  |  |  | RESULT | Criteria 1 : Limit <=100 Criteria 2 : Summation of Limit for same customer no. <=100
Data
Account no. | customer no. | Name | Limit |  |  | Account no. | customer no. | Name | Limit
25 | 55 | Sanjay | 53 |  |  | 25 | 55 | Sanjay | 53
38 | 62 | Amit | 48 |  |  | 54 | 55 | Sanjay | 38
 | 68 | Raj | 48 |  |  | 118 | 55 | Sanjay | 6
 | 55 | Sanjay | 38 |  |  | 41 | 68 | Raj | 48
 | 105 | Mit | 99 |  |  | 73 | 68 | Raj | 16
 | 118 | Snop | 28 |  |  | 57 | 105 | Mit | 99
 | 68 | Raj | 16 |  |  | 70 | 118 | Snop | 28
 | 118 | Snop | 68 |  |  | 86 | 118 | Snop | 68
 | 84 | [NAME] | 18 |  |  | 89 | 84 | [NAME] | 18
 | 92 | Alexa | 105
 | 62 | Amit | 64
 | 55 | Sanjay | 6 |  |  |  | 105 | Mit | 99
 |  |  |  |  |  | 41 | 68 | Raj | 48
 |  |  |  |  |  | 73 | 68 | Raj | 16
 |  |  |  |  |  | 25 | 55 | Sanjay | 53
 |  |  |  |  |  | 54 | 55 | Sanjay | 38
 |  |  |  |  |  | 118 | 55 | Sanjay | 6
 |  |  |  |  |  | 70 | 118 | Snop | 28
 |  |  |  |  |  | 86 | 118 | Snop | 68
 |  |  |  |  |  | 89 | 84 | [NAME] | 18
Spreadsheet: 680513d1591066905-is-it-possible-to-use-imported-queries-in-normal-formula-bar-without-load-to-worksheet-ef-master
Sheet: Satuan

SATUAN
BATANG
BUAH
BULAN
CM
HARI
JAM
KALI
KG
LEMBAR
LITER
LUMPSUM
M1
M2
M3
ORANG
ORANG BULAN
ORANG HARI
ORANG JAM
PASANG
PERSEN
SET
SETEL
TAHUN
TITIK
TUBE
UNIT
UNIT BULAN
UNIT HARI
DOS
IKAT
Spreadsheet: 539820d1506380787-hour-difference-between-names-sample_madeup_numbers
Sheet: Sheet1

ID | DOB | Birth Time | Curr Date | Curr Time | HOL
1 | 2017-08-07 00:00:00 | 0830 | 2017-08-07 00:00:00 | 0900 | 0
1 | 2017-08-07 00:00:00 | 0830 | 2017-08-08 00:00:00 | 2025 | 35
2 | 2017-08-08 00:00:00 | 2044 | 2017-08-09 00:00:00 | 0100 | 4
2 | 2017-08-08 00:00:00 | 2044 | 2017-08-09 00:00:00 | 0230 | 5
3 | 2017-08-11 00:00:00 | 0120 | 2017-08-11 00:00:00 | 0240 | 1
4 | 2017-08-11 00:00:00 | 0500 | 2017-08-13 00:00:00 | 0720 | 48
Spreadsheet: 71816d1272530675-creating-a-pivot-table-and-a-chart-727180
Sheet: pivot

 |  |  |  |  |  |  | How can I make Chart like this one, with this pivot table? I also don't know how to add "Difference" below "Income" and "Outgoing"
Sum of Cost | Column Labels
Row Labels | Income | Outgoing | Difference
1 | 1650000 | 920900 | 729100
2 | 1750000 | 272500 | 1477500
3 | 1345000 | 708500 | 636500
4 | 1290000 | 1410900 | -120900
5 | 1382000 | 1432000 | -50000
6 | 1798500 | 302000 | 1496500
Spreadsheet: larry_campbell__21032__SPRABERpte
Sheet: Summary

NORTHERN NATURAL GAS COMPANY
SPRABERRY PLANT
TNRCC ACCOUNT NO. ML-0022-W
Summary of Emissions
Unit | POTENTIAL TO EMIT
ID | SO2 | NOx | CO | VOC | PM | Formaldehyde | Total HAP
SAE101
SCE101 | - | - | - | - | - | - | -
SCE102 | - | - | - | - | - | - | -
SCE103 | - | - | - | - | - | - | -
SCE104
SCE105
SCE106
[NAME]
SCE108
SCE109
SCE110
SCE111
SCE112
TK-1 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-2 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-3 | 0 | 0 | 0 |  | 0 | 0 | 0
TK-4 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TK-9 | 0 | 0 | 0 | 0 | 0 | 0 | 0
F-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LOAD | 0 | 0 | 0 |  | 0 | 0 | 0
TOTAL
Note:
1. Tank emissions include breathing and working losses only.
Spreadsheet: 466704d1466409919-report-formula-query-profitability-may-2016
Sheet: January 2016

 | January 2016 Projects Profitability
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % | Overservicing %
5 | 0 | 0 | 0 | 0 | 0 | 1
 | Project | Value based on Cost Values | Value Based on Chargeability Values | Invoiced | Profitability % CH | Overservicing %
1 |  |  |  |  | 0 | 1
2 |  |  |  |  | 0 | 1
3 |  |  |  |  | 0 | 1
4 |  |  |  |  | 0 | 1
5 |  |  |  |  | 0 | 1
6 |  |  |  |  | 0 | 1
7 |  |  |  |  | 0 | 1
8 |  |  |  |  | 0 | 1
9 |  |  |  |  | 0 | 1
10 |  |  |  |  | 0 | 1
11 |  |  |  |  | 0 | 1
12 |  |  |  |  | 0 | 1
13 |  |  |  |  | 0 | 1
14 |  |  |  |  | 0 | 1
15 |  |  |  |  | 0 | 1
16 |  |  |  |  | 0 | 1
17 |  |  |  |  | 0 | 1
18 |  |  |  |  | 0 | 1
19 |  |  |  |  | 0 | 1
20 |  |  |  |  | 0 | 1
21 |  |  |  |  | 0 | 1
22 |  |  |  |  | 0 | 1
23 |  |  |  |  | 0 | 1
24 |  |  |  |  | 0 | 1
25 |  |  |  |  | 0 | 1
26 |  |  |  |  | 0 | 1
27 |  |  |  |  | 0 | 1
28 |  |  |  |  | 0 | 1
29 |  |  |  |  | 0 | 1
30 |  |  |  |  | 0 | 1
31 |  |  |  |  | 0 | 1
32 |  |  |  |  | 0 | 1
33 |  |  |  |  | 0 | 1
34 |  |  |  |  | 0 | 1
35 |  |  |  |  | 0 | 1
36 |  |  |  |  | 0 | 1
37 |  |  |  |  | 0 | 1
38 |  |  |  |  | 0 | 0
Spreadsheet: 876022d1722661212-sorting-between-brackets-rafael1024-detect-characters-in-name-tms-aligw
Sheet: My Testing Sorted Data

Extracted Zones | Sorted Zones | Filtered Zones
 | DA.1 | FA.11
 | FA.11 | QA.21
 | QA.21 | RA.1
 | RA.1 | ZA.1
 | ZA.1
Spreadsheet: 822335d1679278601-merge-tables-and-sum-in-different-sheets-book1
Sheet: Jan

PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
A | 1 |  | 1 |  | 1 | 1
B | 1 | 1 | 1 | 1 | 1
C |  | 1 | 1 |  |  | 1
D | 1 |  | 1 | 1 | 1
E |  |  |  |  |  | 1
F | 1 | 1 | 1 | 1 | 1
G | 1 |  |  | 1 | 1 | 1
Spreadsheet: 754721d1636466283-xlookup-return-maximum-value-for-multiple-criteria-dog_cat
Sheet: Sheet1

Type | Breed | DoB | Price | Age |  |  |  |  |  | Type | Breed | [NAME]
Cat | Persian | 2021-01-03 00:00:00 | 1500 | 3 |  | Husky |  |  |  | Cat | Persian | 1500
Dog | Labrador | 2021-06-02 00:00:00 | 1000 | 1 |  |  |  |  |  | Dog | Labrador | 1000
Cat | Siberian | 2021-08-31 00:00:00 | 2000 | 12 |  | Siberian |  |  |  | Cat | Siberian | 2000
Dog | Husky | 2021-12-29 00:00:00 | 2500 | 4 |  |  |  |  |  | Dog | Husky | 2500
Dog | Husky |  | 2000 | 4
Cat | Siberian |  | 1500 | 12
Spreadsheet: 698470d1601994900-conditional-prorata-formula-conditional-prorata
Sheet: Sheet1 (2)

 | Total Inventory |  |  | 5500
 | Buyer | Nomination | Restriction | Allocated |  |  | * Col. E do simple prorata  based on the available total qty and individual qty.
 | A | 2700
 | B | 4500
 | Total Inventory |  |  | 5500
 |  |  |  |  | Left Out |  | * Col. D introduces an restriction upto which pro rata will be done
 | Buyer | Nomination | Restriction | Allocated | Diff. |  | *Col. F shows the delta between the normal prorata and restriction based prorata
 | A | 2700 | 2000
 | B | 4500 | 5000
 | Total Inventory |  |  | 5500
 |  |  |  |  |  |  | * I want a formula in cell E20 which can pro rate upto the restriction and will distribute (in this case 62.5) on pro rata basis to other items upto there restricted amount (Array formula might be helpful, but I have no idea how it works)
 | Buyer | Nomination | Restriction | Allocated | Left Out
 | A | 2700 | 2000 |  | 0
 | B | 4500 | 5000 |  | 0 |  | Note (there are many items each with there individual restriction)
Spreadsheet: 125051d1318851036-excel-2007-moving-values-between-sheets-by-using-number-commands-afhendingase-lar-and-loadinfo
Sheet: Load Information

Date | Flight Number | A/C Registration |  | Departure Time |  | Routing
2011-10-13 00:00:00 | BBD 6809 | TF-BBH |  | 19:55z |  | KEF-CGN
# | ULD Number | ULD WT | Payload | Total Wt. | Dest | Contents | Remarks
 |  | (KG) | (KG) | (KG)
1 | PAJ 0063 BF | 120 | 584 | 704
2 | PAJ 0076 BF | 120 | 918 | 1038
3 |  |  | 0 | 0
4 |  |  | 0 | 0
5 |  |  | 0 | 0
6 |  |  | 0 | 0
7 |  |  | 0 | 0
8 |  |  | 0 | 0
9 |  |  | 0 | 0
10 |  |  | 0 | 0
Hold 1 |  |  | 0 | 0
Hold 2 |  |  | 0 | 0
Hold 3 |  |  | 0 | 0
Hold 4 |  |  | 0 | 0
 | Total Weight : |  | 1502 | 1742
 | POS | [NAME] |  | [NAME]
 | 1 | 2540 |  | 2540
 | Hold 1 | 1150 |  | 1245
 | 2 | 2540 |  | 2540
 | Hold 2 | 1118 |  | 2540
 | 3 | 2540 |  | 2059
 | 4 | 4082 |  | 2540
 | 5 | 3288 |  | 4082
 | 6 | 2268 |  | 3310
 | 7 | 2268 |  | 2268
 | Hold 3 | 2336 |  | 3062
 | 8 | 2132 |  | 2268
 | Hold 4 | 1132 |  | 1125
 | 9 | 907 |  | 2132
 | 10 | N/A |  | 1360
Spreadsheet: 675652d1588403969-formula-to-fetch-details-based-on-criteria-grid
Sheet: Grid

Group Size | Eligible Loan | Emi
7-10 | 50000 | 13000
11-15 | 50000 | 19110
16-20 | 50000 | 24970
21-25 | 50000 | 30589
26-30 | 50000 | 35972
31-35 | 50000 | 41128
36-40 | 50000 | 46064
41-45 | 50000 | 50785
46-50 | 50000 | 55300
7-10 | 100000 | 18571
11-15 | 100000 | 27300
16-20 | 100000 | 35672
21-25 | 100000 | 43698
26-30 | 100000 | 51389
31-35 | 100000 | 58755
36-40 | 100000 | 65805
41-45 | 100000 | 72550
46-50 | 100000 | 78999
Spreadsheet: 821045d1678406896-complex-conditional-formatting-for-visual-automatic-calendar-event-dashboard-2023
Sheet: Event Log

Event Number | Approved by Committee | Event Name | Event Start Date | Event End Date | Primary Contact | Organisation | Contact Email | Event Location | Online | Contact Phone | Industry | Public | Education | Website
 | Y | Event 1 | 2023-10-06 00:00:00 | 2023-10-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Y | Event 2 | 2023-10-01 00:00:00 | 2023-10-03 00:00:00
 | Y | Event 3 | 2023-10-04 00:00:00
 |  | Event 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 | Y | Event 5 | 2023-10-01 00:00:00
 | Y | Event 6 | 2023-10-05 00:00:00
 | Y | Event 7 | 2023-10-03 00:00:00
 | Y | Event 8 | 2023-10-02 00:00:00 |  | Contact | Contact org | contact email
 | Y | Event 9 | 2023-09-30 00:00:00 | 2023-10-01 00:00:00
 | N | Event 10
 | N | Event 11
 |  | Event 12
 |  | Event 13
Spreadsheet: tracy_geaccone__40311__EREC IC 0907
Sheet: IT Infrastructure

 | Total cost per Business Unit
 | Service Category | Service | Service Options | EREC
 | Customer Support | Resolution Center |  | 0
 |  | Desktop support | General | 0
 |  |  | Traders | 0
 |  |  | Executive | 0
 |  |  | Remote | 0
 |  | Desktop Hardware Support |  | 0
 |  | Printer Management Support |  | 0
 | Subtotal 2002
 | Subtotal 2001
 | Production Operations Services | Production Operations Management |  | 0
 |  | Enterprise Command Center |  | 0
 |  | Change & Configuration Management |  | 0
 |  | [NAME] (Future Service) |  | 0
 |  | Security Administration |  | 0
 |  | Data Center Operations |  | 0
 |  | IT Security Policy, Monitoring, and Investigation |  | 1071.614697120159
 |  | Software - Desktop Maintenance & Support |  | 97953.15518938318
 |  | Software - Server Maintenance & Support |  | 0
 |  | Application Storage Support |  | 0
 |  | User & Data Volume Support |  | 0
 |  | Remote Infrastructure Operation & Support |  | 0
 |  | Remote Trading Management |  | 0
 |  | UNIX Application Infrastructure |  | 0
 |  | General UNIX Infrastructure |  | 0
 |  | NT Application Infrastructure |  | 0
 |  | General NT Infrastructure |  | 0
 |  | Remedy |  | 0
 |  | Email Administration |  | 0
 |  | Market Data Admin. Support |  | 0
 |  | Disk Space Allocations (E-mail) |  | 0
 |  | Messaging Operations (Exchange) |  | 0
 |  | Web Operations |  | 0
 |  | Terminal Server Operations |  | 402.5602174744898
 |  | Distributed Applications Management |  | 0
 |  | EDI |  | 0
 | Subtotal 2002
 | Subtotal 2001 |  |  | 4
 | Data Communications Support | LAN Support |  | 0
 |  | [NAME] |  | 0
 |  | DMZ Security |  | 93062.47626473084
 |  | 24x7 Support |  | 63317.97627425214
 | Subtotal 2002
 | Subtotal 2001
 | Voice Communications Support | Telephony support |  | 0
 |  | Communication Trading Support |  | 0
 | Subtotal 2002
 | Subtotal 2001 |  |  | 85
 | Special Services Support | Business Administration Project Management |  | 0
 |  | Technical Architecture Oversight |  | 0
 | Subtotal 2002
 | Depreciation |  |  | 128825
 | ENW Internal Allocations |  |  | 16165
 | Other Compensation |  |  | 10425
 | Total
Spreadsheet: 157051d1337606365-convert-mutiple-values-in-one-colums-to-single-row-result
Sheet: Sheet1

ID | Login | Groups | Disabled | Never connected | Description | Last Login Time | Owner | Creation Date
9823 | de1 | Everyone  | DE_Corporate | 0 | 0 |  | 2012-02-23 14:14:01.531000 | Administrator | 2010-11-09 10:01:10.083000
9890 | ee1 | Everyone | RHO_APAC_Corporate | RHO_APAC_Designer | 0 | 0 |  | 2012-03-06 12:51:32.294000 | Administrator | 2010-11-09 10:25:50.673000
9899 | sg1 | Everyone | SG_Corporate | SG_DESIGNER | 0 | 0 |  | 2011-05-13 15:23:55.973000 | Administrator | 2010-11-09 10:27:07.457000
9911 | .hk1 | Everyone | HK_Corporate | HK_DESIGNER | HK_Corporate1 | 0 | 0 |  | 2011-06-22 11:09:15.580000 | Administrator | 2010-11-09 10:28:14.725000
Spreadsheet: 848992d1699563684-stuck-on-index-match-is-there-a-better-way-without-vba-sampleindex
Sheet: Sheet1

 | CASE REPLIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inbound Calls |  | Case Replies | Case Replies | Customers Helped / Cases Solved |  | ABC |  | Claims |  | XYZ
Week | Team Total | Goal # | Goal (%) | Actual (#) | Goal (%) Actual | % of Quota (#) | % of Quota (%) | Higher % of Quota |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal % | Goal # | Goal %
2023-10-16 00:00:00 | 167 |  |  | 12 | 0.0718562874251497 | 0.0718562874251497 | 1.026518391787853 | 1.026518391787853 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-16 00:00:00 | 5 | 7 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12
2023-10-23 00:00:00 | 169 |  |  | 13 | 0.07692307692307693 | 0.07692307692307693 | 0.9615384615384616 | 0.9615384615384616 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-23 00:00:00 | 6 | 8 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13
2023-10-30 00:00:00 | 171 |  |  | 14 | 0.08187134502923976 | 0.08187134502923976 | 0.9096816114359974 | 0.9096816114359974 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-30 00:00:00 | 7 | 9 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14
2023-11-06 00:00:00 | 173 |  |  | 15 | 0.08670520231213873 | 0.08670520231213873 | 0.8670520231213872 | 0.8670520231213872 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-06 00:00:00 | 8 | 10 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15
2023-11-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-13 00:00:00 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15 | 14 | 16
2023-11-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-13 00:00:00 | 9 | 11 | 10 | 12 | 11 | 13 | 12 | 14 | 13 | 15
2023-11-27 00:00:00
2023-12-04 00:00:00
2023-12-11 00:00:00
2023-12-18 00:00:00
2023-12-25 00:00:00
Spreadsheet: 36436d1234313771-countif-help-please-golf
Sheet: Sheet1

 | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7
Par | 3 | 5 | 4 | 4 | 5 | 3 | 4
Score | 4 | 7 | 3 | 4 | 6 | 5 | 4
Difference | 1 | 2 | -1 | 0 | 1 | 2 | 0
Your Result | [NAME] | Double Bogey | [NAME] | Par | [NAME] | Double Bogey | Par
Spreadsheet: 6342034e-de93-4484-87ad-e497f902f2d8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SANA | Test | SANA | Anaerobe Suscep per Agent ([NAME] Only) | Anaerobe Suscep per agent |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87181 |  |  |  |  | Rochester
SANA | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 116311d1311743083-excel-2007-countifs-to-gather-data-from-multiple-sheets-based-on-multiple-criteria-ratings-of-surveys
Sheet: ANALYSIS

 | HR POC NUMBER | [NAME] |  |  | Total Number of Respondents | 300
 | SURVEY NAME | Recruitment Feedback Survey
 | DATE FROM | 2011-02-25 00:00:00
 | DATE TO | 2011-03-03 00:00:00
Q1 | FREQUENCIES OF RESPONSES | No Rating | [NAME] | Somewhat Disagree | Somewhat Agree | Somewhat Agree | Total
 | QUESTION NUMBER | 0 | 1 | 2 | 3 | 4
 | [NAME] |  |  | 20
 | [NAME] |  | 2
 | [NAME] |  | 2 |  |  | 4
 | [NAME] |  | 2 |  |  | 4
 | TOTAL PER RATING
 | Percentage
Q2 | FREQUENCIES OF RESPONSES | No Rating | [NAME] | Somewhat Disagree | Somewhat Agree | Somewhat Agree | Total
 | QUESTION NUMBER | 0 | 1 | 2 | 3 | 4 |  | Continuation/Non-continuation of employment
 | [NAME] |  |  | 20
 | [NAME] |  | 2
 | [NAME] |  | 2 |  |  | 4
 | [NAME] |  | 2 |  |  | 4
 | TOTAL PER RATING
 | Percentage
Q3 | FREQUENCIES OF RESPONSES | No Rating | [NAME] | Somewhat Disagree | Somewhat Agree | Somewhat Agree | Total
 | QUESTION NUMBER | 0 | 1 | 2 | 3 | 4
 | [NAME] |  |  | 20
 | [NAME] |  | 2
 | [NAME] |  | 2 |  |  | 4
 | [NAME] |  | 2 |  |  | 4
 | TOTAL PER RATING
 | Percentage
Q4 | FREQUENCIES OF RESPONSES | No Rating | [NAME] | Somewhat Disagree | Somewhat Agree | Somewhat Agree | Total
 | QUESTION NUMBER | 0 | 1 | 2 | 3 | 4
 | [NAME] |  |  | 20
 | [NAME] |  | 2
 | [NAME] |  | 2 |  |  | 4
 | [NAME] |  | 2 |  |  | 4
 | TOTAL PER RATING
 | Percentage