tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861190d1709137019-taking-weekly-data-and-converting-to-monthly-formula-query-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | 2024-02-04 00:00:00 | 50
 |  |  |  |  |  | 2024-02-11 00:00:00 | 12
 |  |  |  |  |  | 2024-02-18 00:00:00 | 300
 |  |  |  |  |  | 2024-02-25 00:00:00 | 66
 |  |  |  |  |  | 2024-03-03 00:00:00 | 74
 |  |  |  |  |  | 2024-03-10 00:00:00 | 1
 |  |  |  |  |  | 2024-03-17 00:00:00 | 50
 |  |  |  |  |  | 2024-03-24 00:00:00 | 20
 |  |  |  |  |  | 2024-03-31 00:00:00 | 30
 |  |  |  |  |  | 2024-04-07 00:00:00 | 50
Spreadsheet: 866812d1713731971-false-result-from-deeply-nested-if-formula-financial-chart-example
Sheet: Proj A

PoP Start | PoP End |  | Proj A
2022-08-10 00:00:00 | 2023-12-31 00:00:00
Delete those dates that do not align to any data |  |  | Placeholder, change formula when ready | Placeholder, change formula when ready | fix top formula by deleting +REF! | fix top formula by deleting +REF! | fix by choosing last cell visible in top formula | Placeholder, change formula when ready | Placeholder, change formula when ready
Month | FY Date of Occurrence | Qtr / FY Date of Occurrence | Contracted / Obligated | Expenditures | Obligated | Expended | Unexpended | APPN | APPN FY | APPN Life | Period of Availability | APPN Status
2022-08-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2022-09-30 00:00:00 |  |  |  | 0
2022-10-31 00:00:00 |  |  |  | 0
2022-11-30 00:00:00 |  |  |  | 0
2022-12-31 00:00:00 |  |  |  | 0 |  |  |  | RDT&E
2023-01-31 00:00:00 |  |  |  | 0
2023-02-28 00:00:00 |  |  |  | 0
2023-03-31 00:00:00 |  |  |  | 0
2023-04-30 00:00:00 |  |  |  | 1137451.26
2023-05-31 00:00:00 |  |  |  | 1137451.25 |  |  |  | RDT&E
2023-06-30 00:00:00 |  |  |  | 0
2023-07-31 00:00:00 |  |  |  | 0 |  |  |  | O&M
2023-08-31 00:00:00 |  |  |  | 1549976.48 |  |  |  | RDT&E
2023-09-30 00:00:00 |  |  |  | 774988.24 |  |  |  | RDT&E
2023-10-31 00:00:00 |  |  |  | 853594.67
2023-11-30 00:00:00 |  |  |  | 869410.28 |  |  |  | RDT&E
2023-12-31 00:00:00 |  |  |  |  |  |  |  | RDT&E
2024-01-31 00:00:00 |  |  |  | 1707189.33
2024-02-29 00:00:00
2024-03-31 00:00:00
2024-04-30 00:00:00
2024-05-31 00:00:00
2024-06-30 00:00:00
2024-07-31 00:00:00
2024-08-31 00:00:00
2024-09-30 00:00:00
2024-10-31 00:00:00
2024-11-30 00:00:00
2024-12-31 00:00:00
Spreadsheet: 749717d1632982035-ranking-without-duplicates-using-3-criteria-ranking-problem-all-data-included
Sheet: Tab1

 | 2nd | 3rd | 4th | 1st
Name | Games Correct | Margin Points | Margin Difference | Log points | Log Position | Actual Ranking
Player 1 | 6 | 0.5 | 92 | 6.5 |  | 27
Player 2 | 6 | 2 | 76 | 9 |  | 7
Player 3 | 3 | 1.5 | 123 | 4.5 |  | 35
Player 4 | 5 | 1.5 | 86 | 7.5 |  | 20
Player 5 | 6 | 2 | 81 | 8 |  | 14
Player 6 | 6 | 2 | 94 | 9 |  | 8
Player 7 | 6 | 1 | 74 | 7 |  | 23
Player 8 | 6 | 1.5 | 94 | 8.5 |  | 10
Player 9 | 6 | 2 | 82 | 8 |  | 15
Player 10 | 5 | 1.5 | 91 | 7.5 |  | 21
Player 11 | 5 | 0.5 | 137 | 5.5 |  | 32
Player 12 | 7 | 2.5 | 62 | 10.5 |  | 2
Player 13 | 7 | 2 | 74 | 9 |  | 6
Player 14 | 7 | 2 | 42 | 10 |  | 3
Player 15 | 8 | 1 | 53 | 11 |  | 1
Player 16 | 4 | 1.5 | 96 | 5.5 |  | 33
Player 17 | 6 | 1 | 89 | 8 |  | 18
Player 18 | 3 | 0 | 116 | 3 |  | 36
Player 19 | 6 | 1.5 | 99 | 8.5 |  | 11
Player 20 | 6 | 1.5 | 52 | 8.5 |  | 9
Player 21 | 6 | 1 | 74 | 7 |  | 23
Player 22 | 4 | 1.5 | 114 | 5.5 |  | 34
Player 23 | 7 | 1 | 80 | 8 |  | 12
Player 24 | 6 | 2 | 61 | 8 |  | 13
Player 25 | 6 | 1 | 99 | 7 |  | 25
Player 26 | 5 | 1 | 85 | 6 |  | 30
Player 27 | 3 | 1 | 114 | 6 |  | 31
Player 28 | 5 | 2 | 98 | 7 |  | 26
Player 29 | 6 | 1.5 | 81 | 7.5 |  | 19
Player 30 | 7 | 1.5 | 79 | 9.5 |  | 5
Player 31 | 5 | 1.5 | 93 | 7.5 |  | 22
Player 32 | 5 | 1.5 | 74 | 6.5 |  | 28
Player 33 | 7 | 2 | 65 | 10 |  | 4
Player 34 | 6 | 1 | 75 | 8 |  | 17
Player 35 | 5 | 1.5 | 85 | 6.5 |  | 29
Player 36 | 3 | 0 | 163 | 3 |  | 37
Player 37 | 6 | 2 | 83 | 8 |  | 16
Spreadsheet: 75188d1275705392-showing-account-balances-nearest-to-the-end-of-a-month-book3
Sheet: Sheet1

Date | Account 1 | Account 2 | Acct1 | Acc2
2010-05-04 00:00:00 | 200 | 435
2010-05-05 00:00:00 |  | 435345
2010-05-07 00:00:00 | 432
2010-05-08 00:00:00 | 43534 | 4534
2010-05-09 00:00:00 |  | 345 | 43534 | 345
2010-06-12 00:00:00 | 43114
2010-06-16 00:00:00 | 3453 | 534
2010-06-19 00:00:00
2010-06-21 00:00:00 | 6343 | 54 | 6343 | 54
Spreadsheet: 819645d1677609354-return-dates-of-off-days-bid-demo
Sheet: Bid

 | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00 | 2023-05-06 00:00:00 | 2023-05-07 00:00:00 | 2023-05-08 00:00:00 | 2023-05-09 00:00:00 | 2023-05-10 00:00:00 | 2023-05-11 00:00:00 | 2023-05-12 00:00:00 | 2023-05-13 00:00:00 | 2023-05-14 00:00:00
1 | x | x | DG1 | DG1 | DG1 | DG1 | DG1 | B | x | x | DG2 | DG2 | DG2 | DG2
2 | DG2 | DG2 | DG2 | x | x | x | DG3 | DG3 | DG3 | DG3 | DG3 | x | x | x
3 | DG4 | DG4 | x | x | x | x | x | x | DG1 | DG1 | DG1 | DG1 | DG1 | x
4 | DG1 | x | x | x | DG2 | DG2 | DG2 | DG2 | DG2 | x | x | x | DG3 | DG3
5 | DG3 | DG3 | DG3 | DG3 | DG3 | x | x | x | x | x | x | DG4 | DG4 | DG4
6 | x | x | x | DG4 | DG4 | DG4 | DG4 | DG4 | x | x | x | x | x | x
7 | x | x | x | x | x | DS3 | DS3 | DS3 | DS3 | DS3 | x | x | x | DS4
8 | x | DS4 | DS4 | DS4 | DS4 | DS4 | x | x | x | DS1 | DS1 | DS1 | DS1 | DS1
Spreadsheet: 800793d1665881746-how-to-have-a-chart-showing-no-flat-area-book11
Sheet: Sheet1

Deposit # | Balance |  | Deposit # | Balance
1 | 10
2 | 12
3 | 13
4 | 14.5
5 | 14.75
6 | 21
7 | 53
8 | 60
9 | 60
10 | 60
11 | 60
12 | 60
13 | 60
 |  |  | This table is on a
 |  |  | different worksheet
Spreadsheet: 266478d1379623850-data-interpolation-and-formulas-data-20interpolation-20-20excel-20forum-jp-
Sheet: Sheet3

 | 0 | 0
 | 6.35 | 0.7542776503792556
 | 12.7 | 0.8872817075321927
 | 19.05 | 0.9398482977597461
 | 25.4 | 0.9657787969659553
 | 31.75 | 0.9798906332686541
 | 38.1 | 0.9895925207267596
 | 44.45 | 0.9931204798024343
 | 50.8 | 0.9964720409243253
 | 57.15 | 0.997354030693244
 | 63.5 | 0.9989416122772976
 | 69.85 | 0.9991180102310814
 | 76.2 | 0.9994708061386488
 | 82.55 | 0.9998236020462162
 | 88.9 | 0.9998236020462162
 | 95.25 | 1
 | 101.6 | 1
Spreadsheet: 161653d1339589442-excel-2007-help-needed-for-a-data-mining-formula-0-datamining1
Sheet: 2

 | 2010-02-01 00:00:00
 | Date | Ticker | Buy | B.Time | Sell | s.Time | Expenses | Result
2010-02-01 00:00:00
2010-02-02 00:00:00
2010-02-03 00:00:00
2010-02-04 00:00:00
2010-02-05 00:00:00
2010-02-06 00:00:00
2010-02-07 00:00:00
2010-02-08 00:00:00
2010-02-09 00:00:00
2010-02-10 00:00:00
2010-02-11 00:00:00
2010-02-12 00:00:00
2010-02-13 00:00:00
2010-02-14 00:00:00
2010-02-15 00:00:00
2010-02-16 00:00:00
2010-02-17 00:00:00
2010-02-18 00:00:00
2010-02-19 00:00:00
2010-02-20 00:00:00
2010-02-21 00:00:00
2010-02-22 00:00:00
2010-02-23 00:00:00
2010-02-24 00:00:00
2010-02-25 00:00:00
2010-02-26 00:00:00
2010-02-27 00:00:00
2010-02-28 00:00:00
2010-03-01 00:00:00
2010-03-02 00:00:00
2010-03-03 00:00:00
Spreadsheet: 718449d1613143332-comparing-time-values-when-formatted-as-text-10-00-00-vs-9-00-00-comparing-times-sample
Sheet: Sheet3

Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important |  |  | ORIGINAL METHOD:  USING Less Than.  Everything works perfectly until you compare 9 Minutes to 10 minutes or 20 minutes to 19:00
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important |  |  | <--This should not be getting 'a' notation. Since 10:15 is not less than 9:10
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important |  |  | METHOD 2:  USING SUBTRACTION
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important
Not Important | Not Important | Not Important | Not Important | Not Important |  |  | <--Now the times have the right results, but the measurements are getting a value error for some reason
Not Important | Not Important | Not Important | Not Important | Not Important
Spreadsheet: 154820d1336573873-quartile-average-median-in-array-with-missing-data-points-sample-copy
Sheet: Array

Group | Numbers |  | Average, Group 1 |  |  |  | Quartile 1, Group 1 |  |  |  | Quartile 3, Group 1
0 | 351771.192225989
0
0
1
0 | 18270.68136696254
0
0 | 82585.39729100562
1
0
0 | 23182.64818057286
0
0
1
0 | 30322.89989853854
1
1
1
0 | 758648.8772058869
0 | 27301.23174135872
1
1
0 | 94601.15291694147
1
0
1
1
0
1
1
0
1
0
1
0
1
1
1
1
1
0
0
1
1
1
1
0
1
1
1
0
1
1
1
0 | 112226.7836873599
0 | 76001.96802800719
0 | 45432.47820185788
1
0 | 24060.1805213506
0 | 92057.44081724627
0
1
1
1
0
1
0
0
1
0
0 | 92007.51119709571
0
1
1
0
1
0 | 45059.58479133995
0
0
1
0
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
3
1
3
1
1
1
1
1
1
3
3
1
3
3
3
1
1
3
3
3
3
3
3
0
3
3
1
3
3
1
1
3
1
3
3
1
3
3
3
3
3
3
3
1
3
3
1
1
3
1
3
3
3
3
3
3
3
3
3
3
0
3
0
0
3
3
3
3
3
1
0
3
1 | 157256.0986224781
3
3
3
1
3
1
1
0
1
1
1
0 | 374897.3129873071
0
1
1
1
0
1
0
0
1
0
0 | 67749.08291607263
0 | 22448.29244672124
1
1
0
1
0 | 20398.67750296496
1
1
1
1
1
1
1
1
1
1
1
1 | 52880.33550554057
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2 | 161115.2328259985
2
2
2
2
1
1
2
2
2
2
2
2
2
2
2
2
0 | 424059.9986937507
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
3
2
2
2
2
2
2
2
2
2
2
2
3
2
2
2
2
2
3
2
2
2
2
2
2
2
2
3
3
3
2
2
2
2
2
3
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3 | 205505.4167687137
3
3
3
3
0
0
0
0
Spreadsheet: 825361d1681278787-filter-rows-in-power-query-delete-rows
Sheet: Table2

Test | Organism
BACTERIA IDENTIFIED - PRELIMINARY | Detected
BACTERIA IDENTIFIED - PRELIMINARY | Cauris
BACTERIA IDENTIFIED - PRELIMINARY | PBAB
BACTERIA IDENTIFIED - FINAL | CPPA
Fungus | Positive
Fungus | CRE
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | VIM
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | Detected
MICROORGANISM IDENTIFIED CX NOM (UNSP SPEC) - FINAL | KPC
Spreadsheet: daren_farmer__5686__HPLN0124
Sheet: Sheet1

HPLN0124.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - January 24, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-24 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 536919d1504748959-sorting-and-copying-to-a-new-sheet-based-on-values-example
Sheet: Sheet4

 | A | B | C | D | 0 | 0.5 | F | F.5 | 1 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5
 |  |  |  |  |  |  |  |  | BEL0008
Spreadsheet: 827015d1682432815-if-formula-returning-false-budget-template
Sheet: Sheet1

[NAME] |  |  |  |  | INCOME | COSTS |  |  |  | PROFIT |  |  | INCOME 2023/24
Project | Project Ref | Start Date | End Date | Time | Income | Materials | Equip hire | Subcontract | Total costs | Profit £ | Profit % |  | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-02 00:00:00 | 2023-11-02 00:00:00 | 2023-12-02 00:00:00 | 2024-01-02 00:00:00 | 2024-02-02 00:00:00 | 2024-03-02 00:00:00 | 2024-04-02 00:00:00 | 2024-05-02 00:00:00 | 2024-06-02 00:00:00 | 2024-07-02 00:00:00 | 2024-08-02 00:00:00 | 2024-09-02 00:00:00 | TOTAL
Project | Project Ref
 |  | 2024-01-01 00:00:00 | 2024-09-30 00:00:00 |  | 1672410 | 1018140 | 22600 | 320602
Spreadsheet: 68181d1268741092-summerize-formula-with-3-ifs-and-3-part-sums-excel-forum-template-100316
Sheet: BOM sheet

Supplier to enter information in these columns, and only these columns |  |  |  |  |  |  | CPL | Non-CPL |  |  |  |  |  | 9 |  |  |  | 13
Main FPC assembky information |  |  | BOM component information |  |  |  | 1 | 2 | 3 | 4 | 1 | 5 | 6 |  | 7 | 8 | 9 |  | 10 | 11 | 12
Project Name | FPC Name | FPC Part Number | Sub component part number | CPL or Non-CPL | Quantity | SUPPLIER_NAME | PRICE Q1-10 | CURRENCY Q1-10 | [NAME] | PRICE Q2-10 | CURRENCY Q2-10 | CURRENCY Q2-10 | [NAME] | CURRENCY Q1-10 | PRICE Q3-10 | CURRENCY Q3-10 | [NAME] | [NAME] | PRICE Q4-10 | CURRENCY Q4-10 | SPLIT Q4-10
Robyn | SIM | 1229-1390 | RJC4643026/1 | CPL | 1 |  | 0.00118 | USD | 100 | 0.00117 | 0.00118 | USD | 100 |  | 0.00117 | USD | 100 | SONY ERICSSON MOBILE COMMUNICATIONS INTERNATIONAL AB | 0.00116 | USD | 100
Robyn | SIM | 1229-1390 | RJC4962026/1 | CPL | 1 |  | 0.00089 | USD | 100 | 0.00086 | 0.00089 | USD | 100 |  | 0.00086 | USD | 100 | SONY ERICSSON MOBILE COMMUNICATIONS INTERNATIONAL AB | 0.00084 | USD | 100
Robyn | SIM | 1229-1390 | [NAME] | CPL | 4 |  | 0.00095 | USD | 100 | 0.00085 | 0.00095 | USD | 100 |  | 0.00085 | USD | 100 | SONY ERICSSON MOBILE COMMUNICATIONS INTERNATIONAL AB | 0.00078 | USD | 100
Robyn | SIM | 1229-1390 | RJC5163015/1 | CPL | 1 |  | 0.00093 | USD | 100 | 0.00084 | 0.00093 | USD | 100 |  | 0.00084 | USD | 100 | SONY ERICSSON MOBILE COMMUNICATIONS INTERNATIONAL AB | 0.00078 | USD | 100
Robyn | SIM | 1229-1390 | RJC5163016/1 | CPL | 1 |  | 0.00119 | USD | 100 | 0.00107 | 0.00119 | USD | 100 |  | 0.00107 | USD | 100 | SONY ERICSSON MOBILE COMMUNICATIONS INTERNATIONAL AB | 0.00099 | USD | 100
Robyn | SIM | 1229-1390 | 1212-4981 | Non-CPL | 3 |  | 0.139 | USD | 100 | 0.139 | 0.139 | USD | 100 |  | 0.139 | USD | 100 | FOXCONN PRECISION COMPONENT (BEIJING) CO., LTD. | 0.139 | USD | 100
Robyn | SIM | 1229-1390 | 1200-5195 | Non-CPL | 1 |  | 9.8 | [NAME] | 100 | 9.8 | 9.8 | [NAME] | 100 |  | 9.8 | [NAME] | 100 | HIROSE ELECTRIC CO., LTD. | 9.8 | [NAME] | 100
Robyn | SIM | 1229-1390 | 1201-4842 | Non-CPL | 1 |  | 0.02405 | USD | 100 | 0.02405 | 0.02405 | USD | 100 |  | 0.02381 | USD | 100 | SANYO SEIMITSU CO.,LTD | 0.02357 | USD | 100
Robyn | SIM | 1229-1390 | 1211-1747 | Non-CPL | 2 |  | 1.8542 | CNY | 50 | 1.8171 | 1.8542 | CNY | 50 |  | 1.8171 | CNY | 50 | BALDA AG | 1.8171 | CNY | 50
Spreadsheet: 73527d1274193287-conditional-formatting-for-expiration-dates-h-and-s-data-sheet-test
Sheet: Sheet1

Employee Name | Number | MSHA |  | RAD |  |  | OSHA |  |  |  |  |  | CRP/First Aid
 |  | 30 Hour Part 48 (annual) | Part 48 (refresher) | RAD Safety for Nuclear Density Gauge | RAD Safety Officer [NAME](3 years) | 40 Hour Helath Physucs Tech Level I | OSHA 40 Hr Hazwoper (one time) | OSHA Hazwoper Supervisor | OSHA Hazwoper 8 Hr Annual [NAME] | Competent Person Trenching & Excavations | 10 Hr OSHA Construction Worker | 30 Hr OSHA Construction Safety | CPR Annual 4 HR | First Aid- 4 HR   (3 years)
1 | 89397 |  |  |  |  |  |  |  | 2009-05-14 00:00:00
2
3 | 77163 |  | 2008-06-05 00:00:00
4 | 49974 |  |  |  |  |  | 2003-04-11 00:00:00
5 | 51455 | 2009-07-16 00:00:00 |  | 2008-04-02 00:00:00 | 2009-01-21 00:00:00 |  | 2009-11-20 00:00:00 |  |  |  | 2008-01-28 00:00:00 | Need | Expired | Expired
6 | 28066
7 | 89069
8 | 11351
9 | 65815 |  |  |  |  |  | 1991-07-20 00:00:00 | 2010-04-28 00:00:00 | 2010-01-28 00:00:00 | 2007-03-23 00:00:00 | 2006-09-28 00:00:00 | Need | Expired | Expired
10 | 69166 | 2005-11-10 00:00:00
Spreadsheet: 210479d1359473702-multiplying-column-header-with-the-row-items-trial-revised
Sheet: Columnarview

SKuID | ItemName | Cust 1 | Cust 2 | Cust 3 | Cust 4 | Cust 5 | Cust 6 | Cust 7 | Cust 8 | Cust 9 | Cust 10
11682 | Item 1 | 312.56 | 411.27 | 411.27 | 411.27 | 329.02 | 296.11 | 267.33 | 246.76 | 226.2 | 226.2
11683 | Item 2 | 304.34 | 427.72 | 427.72 | 427.72 | 342.18 | 307.96 | 278.02 | 256.63 | 235.25 | 235.25
11684 | Item 3 | 41.13 | 53.46 | 53.46 | 53.46 | 42.77 | 38.49 | 34.75 | 32.08 | 29.4 | 29.4
11685 | Item 4 | 57.58 | 74.03 | 74.03 | 74.03 | 59.22 | 53.3 | 48.12 | 44.42 | 40.72 | 40.72
11686 | Item 5 | 32.9 | 41.13 | 41.13 | 41.13 | 32.9 | 29.61 | 26.73 | 24.68 | 22.62 | 22.62
11687 | Item 6 | 24.68 | 32.9 | 32.9 | 32.9 | 26.32 | 23.69 | 21.39 | 19.74 | 18.1 | 18.1
11688 | Item 7 | 28.79 | 37.01 | 37.01 | 37.01 | 29.61 | 26.65 | 24.06 | 22.21 | 20.36 | 20.36
10251 | Item 8 | 37.01 | 53.46 | 53.46 | 53.46 | 42.77 | 38.49 | 34.75 | 32.08 | 29.4 | 29.4
the above format needs to be converted to the below format
SKuID | ItemName
11682 | Item 1 | Cust 1 | 312.56
11682 | Item 1 | Cust 2 | 411.27
11682 | Item 1 | Cust 3 | 411.27
Spreadsheet: 31b21a1d-e6f6-40eb-9f9d-b425efdc0815
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
AGA | Test | AGA | Alpha-Galactosidase, Leukocytes | Alpha-Galactosidase, Leukocytes | Fluorometric | Yellow-Top (ACD) Tube: ACD |  |  | 7 | mL | [NAME] must arrive within 72 hours of draw to be stabilized. [NAME] received after 72 hours could have falsely normal results. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 7 mL  Collection Instructions: Do not transfer blood to other containers. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 6 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =23.1 nmol/hour/mg protein An interpretative report will be provided. Note: Results from this assay do not reflect carrier status because of individual variation of alpha-galactosidase enzyme levels. | Specimens are processed Monday through Sunday. Assay is performed on Friday. | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
AGA | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 72 hours
AGA | Result | 32302 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
AGA | Result | 32303 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
AGA | Result | 8785 | Alpha-Galactosidase, Leukocytes | Alpha-Galactosidase, Leukocytes | Numeric |  |  |  |  | nmol/h/mg |  |  |  |  |  |  |  |  |  | 24049-9
Spreadsheet: sally_beck__33832__global standards daily reporting phase 1
Sheet: C 01

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards C
Report C 01:
Purpose: | To capture what brokers were not confirmed with on the same day (or exceptions to your standard - please indicate standard)
Trade Date | Commodity | Broker | Quantity of transations | Total Volume of transactions | Reason not confirmed | Key contact
2000-10-25 00:00:00 | Gas | Morgan Stanley | 5 | 10000 mmbtu | Last five trades done near end of trading day.  Confirm dept did not receive notification of trade until 10/26 | [NAME]
Spreadsheet: 759067d1639281479-conditional-formatting-for-sun-fully-automated-attendance-sheet-in-excel
Sheet: attendance-Dec

MONTH | JUN |  |  |  | TO
YEAR | 2021
S NOS | NAME
1 | [NAME]
 | student2
 | student3
 | student4
 | [NAME]
 | student6
 | student7
 | student8
 | student9
 | student10
 | student11
 | student12
 | student13
 | student14
15 | student15
 | student16
S NOS | student17
 | student18
 | student19
 | student20
 | student21
 | student22
 | student23
 | student24
 | [NAME]
 | student26
 | student27
 | student28
 | student29
 | student30
 | student31
 | student32
 | student33
16 | student34
Spreadsheet: f93a00a7-bce2-41b7-b156-232fb853b6fa
Sheet: Sheet1

FIRST CONGRESSIONAL DISTRICT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | [NAME], r | Flood, d | [NAME]
Albany | 124 | 51
Alton | 1016 | 290
Auburn | 938 | 309
[NAME] | 1208 | 684 | 2
Barnstead | 679 | 301 | 1
[NAME] | 635 | 287 |  |  | 1
Bedford | 4366 | 1262 | 2
Belmont | 977 | 337 | 4
Brentwood | 495 | 257
[NAME] | 167 | 55
Candia | 909 | 291 | 1
Center Harbor | 241 | 131
Chatham | 61 | 21
Chester | 730 | 246
Conway | 1418 | 673 | 2
Danville | 582 | 204
[NAME] | 823 | 339 | 7
[NAME] | 3713 | 1757 | 3
[NAME] | 797 | 433
[NAME] | 421 | 384 | 2
[NAME] | 913 | 591
[NAME] | 760 | 462
[NAME] | 536 | 420
[NAME] 6 | 676 | 408
[NAME] | 1065 | 1144 | 1
East Kingston | 392 | 150 | 1
Eaton | 76 | 52
[NAME] | 246 | 117
Epping | 818 | 356
[NAME] | 772 | 337 | 2
Exeter | 2334 | 1517 | 4
Farmington | 696 | 375 | 1
Freedom | 366 | 138 | 1
Fremont | 493 | 146 | 3
Gilford | 1502 | 521 | 2
Gilmanton | 569 | 270 | 1
Goffstown | 3064 | 1208 | 1
Greenland | 719 | 294
Hale's Location | 23 | 4
Hampstead | 1439 | 564 | 3
Hampton | 2845 | 1719 | 1
[NAME] | 549 | 191
Hart's Location | 13 | 5
[NAME] | 1919 | 727 | 4
[NAME] | 266 | 142
Kensington | 316 | 232 | 1
Kingston | 1002 | 413 | 2
[NAME] | 656 | 223 | 1
[NAME] | 462 | 173 | 1
[NAME] 3 | 433 | 187 | 1
[NAME] | 427 | 157 | 1
[NAME] | 367 | 177
[NAME] 6 | 424 | 172 | 1
[NAME] | 608 | 582 | 1
[NAME] | 3662 | 1449 | 10
Madbury | 300 | 238
[NAME] | 431 | 203
[NAME] | 2160 | 1075
[NAME] | 1610 | 853
[NAME] 3 | 1002 | 667
[NAME] | 1109 | 611
[NAME] | 894 | 493
[NAME] 6 | 1904 | 897 | 3
[NAME] | 1255 | 581
[NAME] 8 | 1869 | 785
[NAME] 9 | 1520 | 667
[NAME] 10 | 1573 | 719
[NAME] 11 | 1080 | 468
[NAME] 12 | 1466 | 596
Meredith | 1280 | 483 | 2
Merrimack | 3895 | 2460 | 18
[NAME] | 195 | 107 | 1
Milton | 530 | 281
Moultonborough | 1180 | 331
New Castle | 383 | 163
New Durham | 388 | 173 | 2
New Hampton | 383 | 194
Newfields | 310 | 182 | 1
Newington | 239 | 89
Newmarket | 1062 | 839
Newton | 473 | 305 | 7
[NAME] | 1002 | 474
Northwood | 555 | 269 | 2
[NAME] | 595 | 427 | 1
Ossipee | 740 | 283
Pittsfield | 572 | 260 | 2
Plaistow | 1071 | 464
Portsmouth Ward 1 | 414 | 460 | 5
Portsmouth Ward 2 | 576 | 846 | 6
Portsmouth Ward 3 | 414 | 326 | 2
Portsmouth Ward 4 | 905 | 664 | 2
Portsmouth Ward 5 | 661 | 697 | 8
[NAME] | 1243 | 505 | 1
Rye | 1367 | 731 | 8
Rochester Ward 1 | 842 | 444 | 6
[NAME] | 919 | 421 | 1
[NAME] 3 | 936 | 446 | 1
Rochester Ward 4 | 873 | 488
Rochester Ward 5 | 765 | 386 | 1
[NAME] | 491 | 335
Sandown | 736 | 308
Sandwich | 334 | 289
Seabrook | 1015 | 626 | 1
[NAME] | 401 | 218 | 1
[NAME] | 306 | 176 | 1
[NAME] 3 | 287 | 216
[NAME] | 348 | 230
[NAME] 5 | 227 | 164 | 1
[NAME] | 160 | 114
[NAME] | 510 | 254 | 2
Stratham | 1416 | 617 | 2
Tamworth | 517 | 278
Tuftonboro | 580 | 168
Wakefield | 804 | 301
Wolfeboro | 1649 | 503
Totals | 104430 | 51783 | 156