tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734072d1621965726-transform-list-into-grid-2d-table-pp-sample
Sheet: Sheet1

[NAME] | Text1
[NAME] | Text2
[NAME] | Text3
[NAME] | Text4
[NAME] | Text5
[NAME] 3 | Text6
[NAME] 3 | Text7
[NAME] 3 | Text8
[NAME] 4 | Text9
[NAME] 4 | Text10
[NAME] 4 | Text11
[NAME] 5 | [NAME]
[NAME] 5 | Text13
[NAME] 5 | Text14
Category_C Sub-Cat 6 | Text15
Category_C Sub-Cat 6 | Text16
Category_C Sub-Cat 6 | Text17
Spreadsheet: 328610d1403974225-vlookup-not-working-in-certain-column-but-works-in-others-test-invoice
Sheet: Invoice test sheet

 |  |  |  |  |  |  |  | INVOICE
Lawn and Landscape
43565 S 15th St
Iowa
Sold to:
[NAME] |  |  | < lookup value
 |  |  | < address from list
 |  |  | <city state zip from list
 |  |  | <phone number
Type | Quantity | Description |  |  |  |  | Price |  | Extended
Subtotal
Service Type | Quantity | Service Description |  |  |  |  | Price |  | Extended
 |  |  |  | Tech hours/hour: |  | 70
 |  |  |  | Laborer hours/hour: |  | 60
Make checks payable to: |  |  |  |  |  |  | Subtotal
Lawn & Landscape |  |  |  |  | Tax Rate: | 0.05 | Tax
 |  |  |  |  |  |  | Total
Spreadsheet: 121255d1315947991-column-and-row-match-example
Sheet: Sheet1

Name | 2011-08-30 00:00:00 | 2011-09-01 00:00:00 | 2011-09-06 00:00:00 | 2011-09-08 00:00:00 | 2011-09-12 00:00:00 | 2011-09-13 00:00:00 | 2011-09-15 00:00:00 | 2011-09-19 00:00:00
[NAME] | yes
[NAME] |  |  | yes
Christy |  |  |  |  | yes
Michelle |  | yes
[NAME]
Name | 2011-09-06 00:00:00 | 2011-09-08 00:00:00 | 2011-09-12 00:00:00 | 2011-09-13 00:00:00 | 2011-09-15 00:00:00 | 2011-09-19 00:00:00 | 2011-09-20 00:00:00 | 2011-09-22 00:00:00
Christy
[NAME]
Michelle
[NAME]
[NAME]
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 59 | 67 | 126
Cap/Floor | 0 | 81 | 81
Debt Option | 0 | 0 | 0
Exotic | 0 | 0 | 0
Fixed-Fixed | 0 | 15 | 15
Fixed-Float | 16990 | 1936 | 18926
FRA | 1874 | 100 | 1974
Inflation | 0 | 153 | 153
OIS | 157 | 118 | 275
Swaption | 0 | 907 | 907
TOTAL | 19080 | 3377 | 22457
Spreadsheet: diana_scholtes__8586__Dec08_Purch
Sheet: Sheet1

Account | Price | Grand Total | 12-08-2000 | 12-09-2000
Fr BPA-EPMI (PGE IR) | 781.7900000000001 | -96 | -96
 |  | 75051.84 | -75051.84
Fr BPA-EPMI(PGE SYS) | 449.75 | -505 | -505
 |  | 227123.75 | -227123.75
 | 781.7900000000001 | -1018 | -1018
 |  | 795862.2200000001 | -795862.2200000001
Fr BPA-EPMI(PUD PTP) | 449.75 | -40 | -40
 |  | 17990 | -17990
 | 778.7900000000001 | -400 | -400
 |  | 311516 | -311516
[NAME] | 449.75 | -32 | -32
 |  | 14392 | -14392
 | 781.7900000000001 | -464 | -464
 |  | 362750.56 | -362750.56
[NAME] | 449.75 | -400 | -400
 |  | 179900 | -179900
EPMI Totals |  | -2955 | -2955
 |  | 1984586.37 | -1984586.37
Total MWHs |  | -2955
Total Dollars |  | 1984586.37
Spreadsheet: 690912d1597356321-formulas-to-calculate-points-on-sloped-graph-curve
Sheet: Sheet2

Days | 0 | 30 | 60 | 91 | 122 | 151 | 182 | 212 | 243 | 273 | 304 | 335 | 365 | 396 | 426 | 457 | 488 | 516 | 547
Y Line
[NAME] | 0 | 0.04382320798207407 | 0.08782727489631564 | 0.1283990033191984 | 0.1686705204348027 | 0.2130675018334137 | 0.2785168204330189 | 0.348680731625212 | 0.421263199561278 | 0.5016939460158837 | 0.5836467813491553 | 0.661567296419567 | 0.7292727476096271 | 0.7889440092885297 | 0.8527060612242855 | 0.9161425782402671 | 0.9625067070654266 | 0.989864836461465 | 0.9999999999514864
Earned % |  | 0.053 | 0.08779999999999999 | 0.1283 | 0.1569 | 0.1692 | 0.2159 | 0.2142 | 0.2433 | 0.2842999999999999 | 0.3342999999999999 | 0.35
Line
A
B
Spreadsheet: 32374d1228488489-linking-cells-and-conditional-updates-sample-resource-model
Sheet: Sheet1

SAMPLE RESOURCE MODEL |  |  |  |  |  |  |  | DPM | 13.83 | 18.83 | 18.83 | 18.83 | 18.83 | 18.83 | 18.83
Workstream | Team | Perm | Name | Rate | Allocation | Start Date | End Date | Month | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
[NAME] | [NAME] | [NAME] | AK | 100 | 0.8 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 1106.4 | 1506.4 | 1506.4 | 1506.4 | 1506.4 | 1506.4 | 1506.4
[NAME] | [NAME] | [NAME] | AB | 150 | 1 | 2008-12-01 00:00:00 | Fri 27-Feb-09 |  | 2074.5 | 2824.5 | 2824.5
[NAME] | [NAME] | [NAME] | JH | 200 | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 2766 | 3766 | 3766 | 3766 | 3766 | 3766 | 3766
[NAME] | [NAME] | [NAME] | AM | 250 | 1 | 2008-12-01 00:00:00 | Tue 31-Mac-09 |  | 3457.5 | 4707.5 | 4707.5 | 4707.5
[NAME] | [NAME] | [NAME] | HG | 300 | 1 | 2008-12-01 00:00:00 | 2009-06-30 00:00:00 |  | 4149 | 5648.999999999999 | 5648.999999999999 | 5648.999999999999 | 5648.999999999999 | 5648.999999999999 | 5648.999999999999
DPM = Days per month
Spreadsheet: 483426d1475657875-i-need-to-find-a-formula-that-calculates-how-much-time-falls-into-a-certain-criteria-sampel-work-cal
Sheet: Ark1

 |  | Rates of pay per H
 |  | Base Pay | 00-24 | 13.74
 |  | Mon-fri | 18-24 | 0.75
 |  | Sat | 14-24 | 2.05
 |  | Nights | 24-06 | 1.5
 |  | Sunday | 00-24 | 2.35
 | Hours of work
 | Day | Start time | end time | HH:MM | hours |  |  |  |  |  | Sum
 | sat | 2016-10-15 20:30:00 | 2016-10-16 07:15:00
 | [NAME] | 2016-10-16 22:30:00 | 2016-10-17 07:15:00
 | Mon | 2016-10-17 22:30:00 | 2016-10-18 07:15:00
 | tue | 2016-10-18 22:30:00 | 2016-10-19 06:15:00
 | thu | 2016-10-20 07:30:00 | 2016-10-20 18:15:00
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36637 | 36726
2 | 36900 | 37000
3 | 45813 | 35879
4 | 35939 | 35982
5 | 33821 | 33935 | 21029 | 20000
6 | 34083 | 34059 | 21614 | 20000
7 | 33492 | 33556 | 20202 | 20000
8 | 312 | 33402 | 1450
9 | 40205 | 33482
10 | 33501 | 33483
11 | 34803 | 35000
12 | 34882 | 35000
13 | 36001 | 36469
14 | 36841 | 37000
15 | 36363 | 36483
16 | 37262 | 37398
17 | 37890 | 38036
18 | 37532 | 37672
19 | 38743 | 38875
20 | 36438 | 36559
21 | 38511 | 38652
22 | 36491 | 37870 | 1
23 | 35541 | 36037 | 4353 | 5000
24 | 36366 | 35949 | 4
25 | 36849 | 37000
26 | 36858 | 37000 | 31737 | 30000
27 | 36860 | 37000 | 30426 | 30000
28 | 34385 | 34528 | 39356 | 30000
29 | 36606 | 36761 | 30273 | 30000
30 | 36869 | 37000 | 2281
31 | 36876 | 37000
2001-04-30 00:00:00
2001-05-31 00:00:00
Spreadsheet: 836856d1689685410-custom-conditional-format-with-if-statement-lift_station_data_sheets
Sheet: Lift_Station_CC#1

Cross Creek Lift Station #1 Data
Date | Time | Name | Pump#1 ETM | Pump#1 Hours | Pump#2 ETM | Pump#2 Hours | Pump#1 Amps | Pump#2 Amps | Notes
2023-06-19 00:00:00 | 08:00:00 | Erick | 7340.51 |  | 5490.36 |  | 18 | 20.2 | Pump#2 VFD Overload
2023-07-06 00:00:00 | 07:20:00 | Erick | 7354.68 |  | 5503.02 |  | 18.4 | 16.7
2023-07-11 00:00:00 | 10:05:00 | Erick | 7358.92 |  | 5506.87 |  | 17.2 | 18
2023-07-14 00:00:00 | 07:15:00 | Erick | 7361.07 |  | 5508.81 |  | 17.4 | 18.6
2023-07-18 00:00:00 | 07:15:00 | Erick | 7364.41 |  | 5511.76 |  | 17.5 | 18.7
Spreadsheet: 834599d1687936741-find-first-and-last-sales-dates-first-and-last-sales-date
Sheet: Sheet1

 | Product | 2018-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1st Sale Date | Last Sale Date
 | A1000 | 0 | 0 | 915 | 466 | 164 | 431 | 603 | 414 | 700 | 584 | 144 | 763 |  |  |  | 2018-03-01 00:00:00 | 2018-12-01 00:00:00
 | A1100 | 354 | 193 | 161 | 160 | 436 | 718 | 432 | 332 | 427 | 0 | 0 | 0 |  |  |  | 2018-01-01 00:00:00 | 2018-09-01 00:00:00
 | A1200 | 159 | 312 | 0 | 0 | 226 | 463 | 123 | 731 | 654 | 772 | 262 | 0 |  |  |  | 2018-01-01 00:00:00 | 2018-11-01 00:00:00
 | A1300 | 0 | 0 | 554 | 394 | 391 | 661 | 370 | 929 | 524 | 0 | 0 | 0 |  |  |  | 2018-03-01 00:00:00 | 2018-09-01 00:00:00
 | A1400 | 466 | 615 | 456 | 0 | 0 | 0 | 349 | 430 | 332 | 245 | 758 | 133 |  |  |  | 2018-01-01 00:00:00 | 2018-12-01 00:00:00
 | A1500 | 606 | 312 | 0 | 0 | 0 | 552 | 623 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2018-01-01 00:00:00 | 2018-07-01 00:00:00
 | A1600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 162 |  |  |  | 2018-12-01 00:00:00 | 2018-12-01 00:00:00
 | A1700 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2018-01-01 00:00:00 | 2018-01-01 00:00:00
 | A1800 | 734 | 310 | 919 | 930 | 753 | 280 | 903 | 745 | 874 | 998 | 998 | 447 |  |  |  | 2018-01-01 00:00:00 | 2018-12-01 00:00:00
 | A1900 | 0 | 0 | 0 | 0 | 0 | 0 | 487 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2018-07-01 00:00:00 | 2018-07-01 00:00:00
 | [NAME] | 0 | 0 | 0 | 683 | 105 | 985 | 0 | 0 | 0 | 0 | 780 | 0 |  |  |  | 2018-04-01 00:00:00 | 2018-11-01 00:00:00
Spreadsheet: 120138d1315002977-sorting-daily-ot-data-otcalculate
Sheet: Sheet1

Weekend | Client | SSN | Name | Hour Type | Rate | MONTOTAL | MONST | [NAME] | TUEST | TUEOT | WEDST | WEDOT | THUST | THUOT | FRIST | FRIOT | SATST | SATOT | SUNST | SUNOT | [NAME] | Trans1 | Csupport | EqpCloth | Others | Tot Hrs | [NAME] | Oth Hrs
 |  |  | emp1 |  |  | 0 | 0 | 0 | 0 |  | 0 |  | 9.83 |  | 10.33 |  | 0 |  | 0 |  |  |  |  |  |  | 20.16 | 20.16 | 0
2011-08-28 00:00:00 |  |  | emp2 |  |  | 3.11611 | 3.11611 | 0 | 12.103333 |  | 21.106944 |  | 2.606944 |  | 12.685556 |  | 12.539721 |  | 0 |  |  |  |  |  |  | 64.158608 | 40 | 24.158608
 |  |  | emp3 |  |  | 0 | 0 | 0 | 0 |  | 0 |  | 10.5 |  | 10.15 |  | 4.213333 |  | 0 |  |  |  |  |  |  | 24.863333 | 24.863333 | 0
 |  |  | emp4 |  |  | 11 | 8 | 3 | 11.039721 |  | 11.003054 |  | 13.154722 |  | 9.887499 |  | 0 |  | 0 |  |  |  |  |  |  | 56.084996 | 40 | 16.084996
 |  |  | emp5 |  |  | 0 | 0 | 0 | 11.324166 |  | 9.236388 |  | 10.402498 |  | 8.52 |  | 0 |  | 0 |  |  |  |  |  |  | 39.483052 | 39.483052 | 0
 |  |  | emp6 |  |  | 11.6 | 8 | 3.6 | 10.803609 |  | 11.098333 |  | 12.405832 |  | 10.1 |  | 4.120555 |  | 10.542499 |  |  |  |  |  |  | 70.670828 | 40 | 30.670828
 |  |  | emp7 |  |  | 11.030277 | 8 | 3.030277000000002 | 11.005832 |  | 6.11 |  | 15.531388 |  | 10.192776 |  | 0 |  | 0 |  |  |  |  |  |  | 53.870273 | 40 | 13.870273
 |  |  | [NAME] |  |  | 3.120277 | 3.120277 | 0 | 12.064445 |  | 12.262778 |  | 6.0975 |  | 11.855555 |  | 8.55 |  | 0 |  |  |  |  |  |  | 53.950555 | 40 | 13.950555
 |  |  | emp9 |  |  | 10.88 | 8 | 2.880000000000001 | 8.405554 |  | 11.993887 |  | 0 |  | 10.08722 |  | 0 |  | 0 |  |  |  |  |  |  | 41.366661 | 40 | 1.366661
 |  |  | emp10 |  |  | 11 | 8 | 3 | 11.230554 | 0 | 11.959443 | 0 | 5.81 | 5.86 | 0 | 10.1 | 0 | 0 | 0 | 0 |  |  |  |  |  | 55.954437 | 40 | 15.954437
 |  |  | emp11 |  |  | 0 | 0 | 0 | 8.193054 |  | 8.226109000000001 |  | 8.284999000000001 |  | 8.233332 |  | 5.234999 |  | 8.140276 |  |  |  |  |  |  | 46.312769 | 40 | 6.312768999999999
 |  |  | emp12 |  |  | 0 | 0 | 0 | 3.074444 |  | 12.009722 |  | 7.7975 |  | 10.740278 |  | 6.055277999999999 |  | 0 |  |  |  |  |  |  | 39.677222 | 39.677222 | 0
 |  |  | emp13 |  |  | 3.198888 | 3.198888 | 0 | 12.000277 |  | 12.057222 |  | 11.934166 |  | 12.7975 |  | 11.894445 |  | 0 |  |  |  |  |  |  | 63.882498 | 40 | 23.882498
 |  |  | emp14 |  |  | 8.009722 | 8 | 0.009722000000000008 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 8.009722 | 8.009722 | 0
 |  |  | emp15 |  |  | 0 | 0 | 0 | 0 |  | 0 |  | 11 |  | 10.1 |  | 4.106943999999999 |  | 10.221944 |  |  |  |  |  |  | 35.428888 | 35.428888 | 0
 |  |  | emp16 |  |  | 10.65 | 8 | 2.65 | 11.448333 |  | 12.840833 |  | 8.660555 |  | 10.244999 |  | 4.062777 |  | 0 |  |  |  |  |  |  | 57.90749700000001 | 40 | 17.907497
 |  |  | emp17 |  |  | 11.133055 | 8 | 3.133054999999999 | 11.344998 |  | 11.292498 |  | 11.227499 |  | 11.15111 |  | 0 |  | 0 |  |  |  |  |  |  | 56.14916 | 40 | 16.14916
Spreadsheet: a6f1cd45-943f-46e2-9cfd-f8a7a8979c83
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Housing Opportunity Index: 3rd Quarter 2013
 |  | Areas with Population of 500,000 or more in 2012
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Indianapolis-Carmel, IN |  |  | 1 | San Francisco-San Mateo-Redwood City, CA ^^^
 | 1 | Syracuse, NY |  |  | 2 | Los Angeles-Long Beach-Glendale, CA ^^^
 | 3 | Youngstown-Warren-Boardman, OH-PA |  |  | 3 | Santa Ana-Anaheim-Irvine, CA ^^^
 | 4 | Harrisburg-Carlisle, PA |  |  | 4 | New York-White Plains-Wayne, NY-NJ ^^^
 | 5 | Buffalo-Niagara Falls, NY |  |  | 5 | San Jose-Sunnyvale-Santa Clara, CA
 | 6 | Lakeland-Winter Haven, FL |  |  | 6 | San Diego-Carlsbad-San Marcos, CA
 | 7 | Scranton--Wilkes-Barre, PA |  |  | 7 | Oxnard-Thousand Oaks-Ventura, CA
 | 8 | Wichita, KS |  |  | 8 | Oakland-Fremont-Hayward, CA ^^^
 | 9 | Toledo, OH |  |  | 9 | Bridgeport-Stamford-Norwalk, CT
 | 10 | Cincinnati-Middletown, OH-KY-IN |  |  | 10 | Honolulu, HI
 |  | Areas with Population under 500,000 in 2012
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Kokomo, IN |  |  | 1 | Santa Cruz-Watsonville, CA
 | 2 | Vineland-Millville-Bridgeton, NJ |  |  | 2 | [NAME], CA
 | 3 | Davenport-Moline-Rock Island, IA-IL |  |  | 3 | [NAME], CA
 | 4 | Bay City, MI |  |  | 4 | Napa, CA
 | 5 | Springfield, OH |  |  | 5 | Salinas, CA
 | 6 | Dover, DE |  |  | 6 | Santa Barbara-Santa Maria-Goleta, CA
 | 7 | Monroe, MI |  |  | 7 | Laredo, TX
 | 8 | Salisbury, MD |  |  | 8 | Barnstable Town, MA
 | 9 | Cumberland, MD-WV |  |  | 9 | Ocean City, NJ
 | 10 | Fairbanks, AK |  |  | 10 | Bend, OR
 |  | Sales Transaction Data:  Core Logic
 |  | Interest Rates: Federal Housing Finance Agency
 |  | Median Household Income: Housing & Urban Development Department (HUD)
 |  | Property Taxes & Insurance:  Bureau of the Census
 |  | Population:  Bureau of the Census
 |  | ^^^  Indicate Metropolitan Divisions.  All others are Metropolitan Statistical Areas.
Spreadsheet: 164491d1340794441-count-return-from-cycle-week-to-week
Sheet: Cavanagh

 |  | Name: | [NAME]
 |  | Delivery Week: | 4
 |  | Weeks to Next Delivery:
 |  | Stock Line | Current Stock | Qtr Usage | Flat Cover | FC Cover | Pick
 | SWP | Majors |  |  |  | 6
 | SWP | Minors |  |  |  | 6
 | CRANE | £1 PZ |  |  |  | 6
 | CRANE | £2 PZ |  |  |  | 6
 | CRANE | [NAME] |  |  |  | 6
 | DISCAPA | Discapa |  |  |  | 6
 | GLOW | [NAME] |  |  |  | 6
 | TOY | [NAME] |  |  |  | 6
 | TOY | Toys |  |  |  | 6
 | TOY | 20p Bouncy Balls |  |  |  | 6
 | TOY | 50p Bouncy Balls |  |  |  | 6
 | [NAME] | Minstrels |  |  |  | 6
 | [NAME] | Skittles |  |  |  | 6
 | [NAME] | Mentos |  |  |  | 6
 | [NAME] | Mini Eggs |  |  |  | 6
 | [NAME] | Runts |  |  |  | 6
 | [NAME] | Gobstoppers |  |  |  | 6
 | [NAME] | [NAME] |  |  |  | 6
 | [NAME] | Silver Colas |  |  |  | 6
 | WR | [NAME] |  |  |  | 6
 | WR | [NAME] |  |  |  | 6
 | WR | Stim Ring |  |  |  | 6
 | WR | Condoms |  |  |  | 6
 | WR | Sani Packs |  |  |  | 6
 | WR | Mints |  |  |  | 6
 | GLOW | [NAME] |  |  |  | 6
 | CRANE | £1 King Mix |  |  |  | 6
 | SWP | KM - [NAME] |  |  |  | 6
 | SWP | KM-A (Sat Nav) |  |  |  | 6
 | SWP | KM-B (Gold) |  |  |  | 6
 | SWP | KM-C (MP3 Player/Speaker) |  |  |  | 6
 | SWP | KM-E (Headphones) |  |  |  | 6
 | SWP | KM-F (Perfume) |  |  |  | 6
 | SWP | KM-G (Video Cam) |  |  |  | 6
 | SWP | KM-H (T-Shirt) |  |  |  | 6
 | SWP | KM-J (Watch) |  |  |  | 6
 | SWP | KM-K (Angry Bird) |  |  |  | 6
 | SWP | KM-O ([NAME],[NAME],[NAME]) |  |  |  | 6
 | WR | Miscellaneous Old Product |  |  |  | 6
 | SNACK | Pop Corn |  |  |  | 6
 | SWP | SW Perfume |  |  |  | 6
 | SWP | SW Plush |  |  |  | 6
 | SWP | SW Watch |  |  |  | 6
 | SNACK | [NAME] |  |  |  | 6
 | SNACK | [NAME] |  |  |  | 6
 | SNACK | Tubz Fruitie Fizz |  |  |  | 6
 | SNACK | Tubz Jelly Mix |  |  |  | 6
 | SNACK | [NAME] |  |  |  | 6
 | SNACK | [NAME] |  |  |  | 6
 | SNACK | Tubz Rowntree Fruit Pastiles |  |  |  | 6
 | SNACK | [NAME] Pencils |  |  |  | 6
Spreadsheet: 807888d1670134853-calling-data-from-main-sheet-g6-ver-256
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 | sd\
Spreadsheet: 905ff3c2-b669-48fa-b7b5-4e02f69866bc
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
LEN | Test | LEN | Lentil, IgE | Lentil, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
LEN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LEN | Result | LEN | Lentil, IgE | Lentil, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7458-3
Spreadsheet: 169672d1343021773-conditional-formatting-based-on-distance-from-median-value-excel-2010-conditional-format-2003
Sheet: sheet1

DIRECT | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | Weekly Total
 | 0.6956 | 0.8811 | 0.865 | 0.9637 | 0.8594 | 1 | 0.9863 | 0.8568
 | 0.4619 | 0.8321 | 0.6803 | 0.9386 | 0.6488 | 0.9105 | 0.8755 | 0.7134
 | 0.5 | 1 | 1 | 1 | 1 |  | 0.5 | 0.7778
 | 0.8 | 0.5714 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.72
 | 0.6739 | 0.8205 | 0.8587 | 0.9302 | 0.8906 | 0.963 | 1 | 0.8443
 | 0.4575 | 0.8015 | 0.7332 | 0.9461 | 0.6862 | 0.965 | 0.928 | 0.7459
 | 0.5 | 0.9 | 0.8148 | 1 | 0.7647 | 1 | 1 | 0.84
 | 0.4236 | 0.7802 | 0.6076 | 0.9286 | 0.6529 | 1 | 0.9524 | 0.6866
 | 0.4218 | 0.8002 | 0.6155 | 0.9566 | 0.6514 | 0.985 | 0.9648 | 0.6974
 | 0.7048 |  | 0.7986 | 0.9744 | 0.8819 | 0.9737 | 0.9048 | 0.83
 | 0.4369 | 0.8365 | 0.6612 | 0.9228 | 0.4801 | 0.8434 | 0.8986 | 0.6777
 | 0.4565 | 0.7895 | 0.675 | 0.9737 | 0.6279 | 1 | 1 | 0.7112
 | 0.3529 | 0.95 | 0.8 | 0.9583 | 0.8889 | 1 |  | 0.8173
Median | 0.4619 | 0.8263 | 0.75 | 0.9566 | 0.7647 | 0.9924999999999999 | 0.9402
 |  | 0.9763000000000001
Spreadsheet: 673159d1587221906-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 01 MONDAY

DAY: |  | MONDAY |  | DATE: | 2020-04-01 00:00:00
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | JOBS | Hr | GR | Hr | WS | Hr | CHECK
0 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
37 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 | JOB1 | 2 | JOB3 | 4
27 | W
53 | W
54 | W
50 | W
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P
26 | P
6 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1234 | 3 |  |  | BBB BBB | 2 | AAA AAA | 12 | CCC CCC | 9
10 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12345 | 5
47 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 123456 | 12
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS |  |  |  |  |  |  |  |  | JOBS BREAKDOWN |  |  |  |  |  | SHEET ENGINE
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  |  |  |  |  |  | [NAME] |  |  |  |  |  | F/L | JOBS | REPAIRS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | DR | PT |  | JOBS | No. | No.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS |  |  |  |  |  |  | [NAME] | BBB BBB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | DR | PT
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
HOURS CALCULATOR |  |  |  |  | TOTAL 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
 |  |  |  |  | TOTAL 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | DR | PT
Spreadsheet: 20b1e283-384e-424f-ac82-b0480861f6cf
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
CHUB | Test | CHUB | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CHUB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CHUB | Result | CHUB | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10925-6 | Scomber japonicus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 842596d1694619688-sum-total-amount-from-multiple-key-values-to-single-value-test-data-set-sum-amount
Sheet: Sheet1

 |  |  |  |  |  |  |  | Key
Test Data | Amount | Date Created | [NAME] |  |  |  |  | Rep | Quarter Start | Quarter End
 | 10.25 | 2023-01-10 00:00:00 | [NAME] |  |  |  |  | [NAME] | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | 20 | 2023-01-13 00:00:00 | [NAME] |  |  |  |  | [NAME] | 2023-04-01 00:00:00 | 2023-06-30 00:00:00
 | 15 | 2023-01-28 00:00:00 | [NAME] |  |  |  |  | [NAME] | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
 | 9 | 2023-01-31 00:00:00 | [NAME] |  |  |  |  |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
 | 11 | 2023-02-15 00:00:00 | [NAME]
 | 12 | 2023-02-28 00:00:00 | [NAME]
 | 25 | 2023-03-22 00:00:00 | [NAME]
 | 13.25 | 2023-05-10 00:00:00 | [NAME]
 | 9.33 | 2023-05-28 00:00:00 | [NAME]
 | 11.01 | 2023-06-01 00:00:00 | [NAME]
 | 12 | 2023-06-10 00:00:00 | [NAME]
 | 13 | 2023-06-29 00:00:00 | [NAME]
 | Q1 # of Sales | Q1 Total Amount