tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 23c53d21-fda2-4a4c-9be2-1b4e2ae4e87e
Sheet: Feuil1

 |  | Test | Figure | Scale | Dataset | Samples size (number of species)
 |  |  |  |  | Reef fish | 633
 |  | Distinctivness vs. Commonness | 1 | Local | Alpine plants | 2535
 |  |  |  |  | Tropical trees | 659
 |  |  |  |  | Reef fish | 846
 |  | Distinctivness vs. Commonness | 1 | Regional | Alpine plants | 2979
 |  |  |  |  | Tropical trees | 662
 |  |  |  |  | Reef fish | 633
 |  | Vulnerability vs. Commonness | 2 | Local | Alpine plants | 2535
 |  |  |  |  | Tropical trees | 659
 |  |  |  |  | Reef fish | 846
 |  | Vulnerability vs. Commonness | 2 | Regional | Alpine plants | 2979
 |  |  |  |  | Tropical trees | 662
 |  |  |  |  | Reef fish | 32 | 126 | 159 | 316
 |  | Vulnerability vs. Rarity | 3A | Local | Alpine plants | 127 | 507 | 634 | 1267
 |  |  |  |  | Tropical trees | 33 | 131 | 165 | 330
 |  |  |  |  | Reef fish | 42 | 169 | 212 | 423
 |  | Vulnerability vs. Rarity | 3B | Regional | Alpine plants | 149 | 596 | 744 | 1490
 |  |  |  |  | Tropical trees | 33 | 132 | 166 | 331
Spreadsheet: 108671d1305686695-excel-2007-sumproduct-question-sumproduct
Sheet: JAN

ID | Bought | Sold | % Sold
8178541110001 | 90 | 48
3531670110003 | 42 | 40
7855760111824 | 75 | 32
8262480013000 | 40 | 31
8385850010003 | 39 | 25
7199790210003 | 100 | 24
7686200510003 | 101 | 24
8263830010002 | 33 | 21
8389450210000 | 31 | 17
Spreadsheet: 855705d1705219556-average-if-of-unique-values-with-conditions-question
Sheet: Sheet1

Origin | Destination | Ticket | Fare | OD_Ticket |  | Merged | Average
Pontefract | Woodlesford | ADVANCE | 5.1 |  |  | Pontefract_Woodlesford_ADVANCE | 5.1
Leeds | Bradford | ADVANCE | 3.5 |  |  | Leeds_Bradford_ADVANCE | 5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Leeds_Bradford_SINGLE | 7.5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Castleford_Pontefract_ADVANCE | 3.5
Leeds | Bradford | ADVANCE | 6
Leeds | Bradford | SINGLE | 7.5
[NAME] | Pontefract | ADVANCE | 3
[NAME] | Pontefract | ADVANCE | 4
 |  |  |  |  |  | Unique OD_tickets | Fare (average of unique fares if duplicate)
 |  |  |  |  |  | Pontefract - Woodlesford_ADVANCE | 5.1
 |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  | Leeds - Bradford_SINGLE | 7.5
 |  |  |  |  |  | Castleford - Pontefract_ADVANCE | 3.5
Spreadsheet: 818915d1677123229-search-cells-for-given-text-and-return-closest-date-in-row-below-next-sample-available-example
Sheet: example

Products |  | Lot No. | 1 | 2 | 3 | 4 | 5
Product A |  | STATUS | [NAME] | [NAME] | UNDER TEST | UNDER TEST | NOT SAMPLED
 |  | Sampled | 2022-11-15 00:00:00 | 2022-11-15 00:00:00 | 2023-01-29 00:00:00 | 2023-02-20 00:00:00
 |  | ETA
Next Lot Available
Spreadsheet: 390347d1429606916-using-if-and-or-in-a-complex-formula-to-find-blank-cells-ladycx2-reply
Sheet: Sheet1

Qtr | inv1 | inv2 | inv3 | inv4
Q1 | 10 | 10 | 10 | 10
Q2 | 11 | 0 |  | 10
Q3 | 0 | 12 | 12 | 0
Q4 |  | 0 | 0 | 13
Spreadsheet: 219526d1362774441-match-multiple-criteria-then-select-the-smallest-value-the-lookup-value-multimatchlookupsampledata
Sheet: Sheet1

IsPro? | Price Schedule | Tier | Break Even Txns | Helper Column
Basic | ERP1 | 1000000 | 10000000
Basic | ERP1 | 750000 | 854062.5
Basic | ERP1 | 500000 | 588500
Basic | ERP1 | 300000 | 387538.4615384615
Basic | ERP1 | 144000 | 226343.75
Basic | ERP1 | 96000 | 116086.2068965517
Basic | ERP1 | 48000 | 63657.89473684211
Basic | ERP1 | 24000 | 35428.57142857143
Basic | ERP1 | 14400 | 19187.23404255319
Basic | ERP1 | 7200 | 12755.55555555555
Basic | ERP1 | 3300 | 5607.058823529412
Basic | ERP1 | 1440 | 2461.978021978022
Basic | ERP1 | 720 | 1056.842105263158
Pro | ERP1 | 1000000 | 10000000
Pro | ERP1 | 750000 | 835769.2307692308
Pro | ERP1 | 500000 | 570000
Pro | ERP1 | 300000 | 355434.7826086957
Pro | ERP1 | 144000 | 181364.8648648649
Pro | ERP1 | 96000 | 115860
Pro | ERP1 | 48000 | 67957.62711864407
Pro | ERP1 | 24000 | 33444.44444444445
Pro | ERP1 | 14400 | 19634.375
Pro | ERP1 | 7200 | 12101.96078431373
Pro | ERP1 | 3300 | 5540.853658536585
Pro | ERP1 | 1440 | 2463.529411764706
Pro | ERP1 | 720 | 1114.444444444444
Basic | ERP2 | 1000000 | X
Basic | ERP2 | 750000 | X
Basic | ERP2 | 500000 | X
Basic | ERP2 | 300000 | X
Basic | ERP2 | 144000 | X
Basic | ERP2 | 96000 | X
Basic | ERP2 | 48000 | X
Basic | ERP2 | 24000 | X
Basic | ERP2 | 14400 | X
Basic | ERP2 | 7200 | X
Basic | ERP2 | 3300 | X
Pro | ERP2 | 1000000 | 10000000
Pro | ERP2 | 750000 | 845000
Pro | ERP2 | 500000 | 569473.6842105263
Pro | ERP2 | 300000 | 353695.652173913
Pro | ERP2 | 144000 | 180283.7837837838
Pro | ERP2 | 96000 | 120260
Pro | ERP2 | 48000 | 72533.89830508475
Pro | ERP2 | 24000 | 34666.66666666666
Pro | ERP2 | 14400 | 20988.54166666667
Pro | ERP2 | 7200 | 13572.54901960784
Pro | ERP2 | 3300 | 5906.707317073171
Basic | SDK | 1500000 | 10000000
Basic | SDK | 1000000 | 1067000
Basic | SDK | 750000 | 866071.4285714285
Basic | SDK | 500000 | 616562.5
Basic | SDK | 300000 | 375611.1111111111
Basic | SDK | 144000 | 215000
Basic | SDK | 96000 | 120791.6666666667
Basic | SDK | 48000 | 60500
Basic | SDK | 24000 | 35785.71428571428
Basic | SDK | 14400 | 21573.91304347826
Basic | SDK | 7200 | 12894.44444444445
Basic | SDK | 3300 | 4519.512195121952
Basic | SDK | 1440 | 2440
Basic | SDK | 720 | 1740.689655172414
Basic | SDK | 360 | 559.047619047619
Basic | SDK | 180 | 270.1639344262295
Pro | SDK | 1500000 | 10000000
Pro | SDK | 1000000 | 1187142.857142857
Pro | SDK | 750000 | 843125
Pro | SDK | 500000 | 604772.7272727273
Pro | SDK | 300000 | 363392.8571428572
Pro | SDK | 144000 | 181000
Pro | SDK | 96000 | 111196.4285714286
Pro | SDK | 48000 | 65068.96551724138
Pro | SDK | 24000 | 33516.12903225806
Pro | SDK | 14400 | 22275
Pro | SDK | 7200 | 13137.5
Pro | SDK | 3300 | 5759.677419354839
Pro | SDK | 1440 | 2208.656716417911
Pro | SDK | 720 | 1382.337662337662
Pro | SDK | 360 | 724.516129032258
Pro | SDK | 180 | 380
Lookup Values:
Basic | SDK | 19304
It should return 14400
Spreadsheet: 684007d1593096396-return-on-investment-formula-simplification-roi-example
Sheet: ROI

ESTIMATED PROJECT COSTINGS | Internal Cost | 75000
 | External Cost | 688420
 | Total Development Cost | 763420
ESTIMATED RETURN ON INVESTMENT | Estimated Revenue | 2161868.8 | 4539924.48 | 7155785.728000001
 | Estimated GP | 1469775.216 | 3086527.953600001 | 4864955.964960001
 | Return on Investment in Months
 | What if - 20% Revenue
 | What If - 20% Profit
 | ROI Recalculation -20%
 | What if - 40% Revenue
 | What If - 40% Profit
 | ROI Recalculation -40%
 | What if + 20% Revenue
 | What If + 20% Profit
 | ROI Recalculation +20%
 | What If - Loss Per month late Revenue
 | What If - Loss Per month late Profit
 | What If - Loss Per Quarter late Revenue
 | What If - Loss Per Quarter late Profit
Spreadsheet: 32514d1228738194-find-a-grup-assigned-book1a
Sheet: quality average

 | monitor 1 | monitor 2 | monitor 3 | monitor 3 | monitor 4 | additional 1 | additional 2 | additional 3 | additional 4
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t2 | [NAME] | t2
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t2 | [NAME] | t1
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t2 | [NAME] | col
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t2 | [NAME] | col
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t2 | Bev Poad | t2
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t1
Asif Mahmood |  |  |  |  |  |  |  |  |  |  | Asif Mahmood | [NAME] | t1
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | t1
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | #N/A
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Nikki Mount |  |  |  |  |  |  |  |  |  |  | Nikki Mount | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Carys Jones |  |  |  |  |  |  |  |  |  |  | Carys Jones | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] howard |  |  |  |  |  |  |  |  |  |  | [NAME] howard | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Tawanda Toro |  |  |  |  |  |  |  |  |  |  | Tawanda Toro | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Bev Poad
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Bev Poad
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Bev Poad
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Bev Poad
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Bev Poad
Spreadsheet: 123974d1317972177-keying-a-dynamic-chart-off-of-an-entered-date-795452
Sheet: Sheet1

Month | 2011-07-18 00:00:00 | 2011-07-25 00:00:00 | 2011-08-01 00:00:00 | 2011-08-08 00:00:00 | 2011-08-15 00:00:00 | 2011-08-22 00:00:00 | 2011-08-29 00:00:00 | 2011-09-05 00:00:00 | 2011-09-12 00:00:00 | 2011-09-19 00:00:00 | 2011-09-26 00:00:00 | 2011-10-03 00:00:00 | 2011-10-10 00:00:00
Value | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Names defined: | chtCats
 |  |  |  |  |  |  |  |  |  |  |  | chtLen
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Length
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 40756 | Nearest date
 |  |  |  |  |  |  |  |  |  |  |  | 3 | Position
 |  |  |  |  |  |  |  |  |  |  |  | 6 | Length
 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-01 00:00:00 | Select date
Spreadsheet: 690406d1597083073-using-sum-and-count-function-in-a-pivot-table-summary-consolidated-sheet
Sheet: 08082020

 | [NAME] | [NAME] | JO/20/193 HRS | JO/20/193 OT | [NAME] | [NAME] | [NAME] | JO/20/204 OT | JO/20/096 HRS | JO/20/096 OT | JO/20/144 HRS | JO/20/144 OT | [NAME] | [NAME] | JO/20/197 HRS | JO/20/197 OT | JO/20/185 HRS | JO/20/185 OT | JO/20/120-B HRS | JO/20/120-B OT | [NAME] | [NAME] | JO/20/083 HRS | JO/20/083 OT | CPC HRS | CPC OT | YARD1 CLEANING HRS | YARD1 CLEANING OT | YARD2 CLEANING  HRS | [NAME] | ADMIN WORKS  HRS | ADMIN WORKS  OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
KESHVAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
SIVADAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
ANSARI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4
RAGESH |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2.3
MUKUNDA | 6 |  | 2
ABBASI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
UPENDRA
MARTIN
SAMUEL |  |  | 1 |  | 5 |  |  |  |  |  |  |  |  |  | 2
FELIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
DIPAK |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
SATHYA
RAJEEV | 6 |  | 2
[NAME] | 6 |  |  |  | 2
[NAME] |  |  |  |  |  |  | 8
FLORENCIO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
VINOTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
RAJA
[NAME]
SON |  |  |  |  |  |  |  |  | 2 |  | 6 | 3
MANSA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
SIMHA
MALIK |  |  |  |  |  |  | 4 |  | 1 |  |  |  | 2 |  |  |  | 1
SIVA |  |  |  |  |  |  |  |  | 1 |  |  | 2 | 7
GEORGE
SUDHI |  |  |  |  |  |  |  |  | 2 |  | 6 | 3
RAVI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
HEMA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 791056d1660138340-conditional-formatting-from-various-criteria-selection-revised-inspection-schedule-excel-forum-
Sheet: 抹油 Schedule

Item No. | Group | Period | No. of days | Last inspection Date | Next 1 | Next 2 | Next 3 | Next 4 |  |  | 2022-08-01 00:00:00
[NAME] | A | BW | 1900-01-14 00:00:00 | 2022-08-09 00:00:00
LS002 | A | BW | 1900-01-14 00:00:00 | 2022-07-25 00:00:00
LS003 | A | M | 1900-01-28 00:00:00 | 2022-08-03 00:00:00
LS004 | B | M | 1900-01-28 00:00:00 | 2022-08-01 00:00:00
LS006 | B | M | 1900-01-28 00:00:00 | 2022-07-20 00:00:00
LS007 | A | M | 1900-01-28 00:00:00 | 2022-07-23 00:00:00
[NAME] | B | M | 1900-01-28 00:00:00 | 2022-07-20 00:00:00
LS009 | B | M | 1900-01-28 00:00:00 | 2022-07-20 00:00:00
[NAME] | B | M | 1900-01-28 00:00:00 | 2022-08-05 00:00:00
LS011 | B | M | 1900-01-28 00:00:00 | 2022-08-02 00:00:00
LS012 | B | M | 1900-01-28 00:00:00 | 2022-07-18 00:00:00
[NAME] | A | BW | 1900-01-14 00:00:00 | 2022-08-05 00:00:00
[NAME] | B | M | 1900-01-28 00:00:00 | 2022-08-02 00:00:00
LS017 | B | BW | 1900-01-14 00:00:00 | 2022-07-23 00:00:00
LS018 | B | M | 1900-01-28 00:00:00 | 2022-07-18 00:00:00
[NAME] | B | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
LS020 | B | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
LS021 | B | M | 1900-01-28 00:00:00 | 2022-07-20 00:00:00
LS022 | B | M | 1900-01-28 00:00:00 | 2022-07-18 00:00:00
[NAME] | B | M | 1900-01-28 00:00:00 | 2022-08-06 00:00:00 |  |  |  |  |  |  | Group A (14 days) |  |  |  | Group A (28 days) |  |  |  | Group B (14 days) |  |  |  | Group B (28 days)
LS025 | A | M | 1900-01-28 00:00:00 | 2022-08-08 00:00:00
LS026 | B | M | 1900-01-28 00:00:00 | 2022-08-09 00:00:00
[NAME] | A | M | 1900-01-28 00:00:00 | 2022-08-02 00:00:00
LS028 | A | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
LS029 | A | M | 1900-01-28 00:00:00 | 2022-07-16 00:00:00
[NAME] | A | M | 1900-01-28 00:00:00 | 2022-08-01 00:00:00
LS031 | A | M | 1900-01-28 00:00:00 | 2022-08-03 00:00:00
LS032 | B | M | 1900-01-28 00:00:00 | 2022-07-18 00:00:00
LS033 | B | M | 1900-01-28 00:00:00 | 2022-07-18 00:00:00
LS034 | B | M | 1900-01-28 00:00:00 | 2022-08-03 00:00:00
LS035 | B | M | 1900-01-28 00:00:00 | 2022-08-03 00:00:00
LS036 | B | BW | 1900-01-14 00:00:00 | 2022-08-09 00:00:00
LS037 | B | BW | 1900-01-14 00:00:00 | 2022-07-31 00:00:00
LS038 | B | BW | 1900-01-14 00:00:00 | 2022-07-31 00:00:00
[NAME] | B | BW | 1900-01-14 00:00:00 | 2022-07-31 00:00:00
LS040 | B | BW | 1900-01-14 00:00:00 | 2022-08-06 00:00:00
LS041 | B | BW | 1900-01-14 00:00:00 | 2022-08-06 00:00:00
LS042 | A | BW | 1900-01-14 00:00:00 | 2022-08-08 00:00:00
LS043 | A | BW | 1900-01-14 00:00:00 | 2022-08-08 00:00:00
[NAME] | A | M | 1900-01-28 00:00:00 | 2022-08-04 00:00:00
LS045 | A | M | 1900-01-28 00:00:00 | 2022-08-04 00:00:00
[NAME] | A | M | 1900-01-28 00:00:00 | 2022-08-04 00:00:00
LS047 | A | M | 1900-01-28 00:00:00 | 2022-08-04 00:00:00
LS048 | A | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
LS049 | A | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
LS050 | A | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
[NAME] | A | M | 1900-01-28 00:00:00 | 2022-07-13 00:00:00
Spreadsheet: 849408d1699902885-combine-3-sheets-data-into-1-final-sheet-book1-2-1-
Sheet: Sheet4

 | Score 1 | Score 2 | Score 3 | Total | Class
a | 10 |  | 4 | 14 | qq
b | 5 |  |  | 5 | ww
c | 5 | 3 |  | 8 | ee
D |  | 5 |  | 5
E |  |  | 6 | 6
L |  | 3 | 3 | 6
Spreadsheet: 275983d1383707223-populate-cells-if-there-is-a-min-and-max-value-leave01
Sheet: Sheet2

Staff Member | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-10 00:00:00 | 2014-01-11 00:00:00 | 2014-01-12 00:00:00 | 2014-01-13 00:00:00 | 2014-01-14 00:00:00 | 2014-01-15 00:00:00 | 2014-01-16 00:00:00
[NAME] |  |  |  | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave | On Leave
Spreadsheet: 824430d1680592448-if-cell-blank-return-the-value-to-on-or-another-cell-template-gc-copie
Sheet: PRIX SELON % SOLVANT

 |  | (€/kg) | € | € | € | € | €
 |  |  | 0.1 | 0.01 | 0,1% | 0,01% | 50%
RM
Solvant | DEP
Solvant | DPG | 3.4
Solvant | MIP
Spreadsheet: 799113d1664934205-sick-time-tracker-with-cap-on-maximum-accrued-plus-sick-time-used-sampleworkbook
Sheet: Janitorial sick time

Hours worked | Hours Accrued | SD hours used | Balance
1000 |  | 5
1000
100 |  | 24
500
500 |  | 10
500
500
500
40 |  | 27.4
40
40
40
40
Spreadsheet: f285718b-601e-4097-ad7f-3084e21ef18c
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
CROT | Test | CROT | Carrot, IgE | Carrot, 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
CROT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CROT | Result | CROT | Carrot, IgE | Carrot, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6061-6 | [NAME] carota [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 534706d1503404031-formula-to-find-variances-between-planned-and-actual-dates-sample
Sheet: Sheet1

 | Ticket # | Planned Date | Actual Completion Date | [NAME] | Variance in %
 | A83733 | 2017-04-30 00:00:00 | 2017-04-25 00:00:00 |  | 0.95
 | A81209 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 |  | 1
 | A83701 | 2017-04-30 00:00:00 | 2017-05-25 00:00:00 |  | 1.25
 | A82300 | 2017-04-30 00:00:00 | 2017-04-25 00:00:00 |  | 0.95
Spreadsheet: 759422d1639528934-countif-for-dow-staff-by-interval-shiftsample
Sheet: ShiftCount

start | stop | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | Staff
08:00:00 | 16:30:00 | M | T | W | R | = | = | S |  |  |  | M | T | W | R | F | Y | S
09:30:00 | 18:00:00 | M | T | W | R | F | = | = |  | 00:00:00
11:30:00 | 22:00:00 | M | = | = | R | F | Y | = |  | 00:30:00
15:00:00 | 1900-01-01 01:30:00 | M | T | W | R | = | = | S |  | 01:00:00
08:00:00 | 16:30:00 | = | T | W | R | F | Y | = |  | 01:30:00
09:30:00 | 18:00:00 | M | T | W | R | F | = | = |  | 02:00:00
11:30:00 | 20:00:00 | M | T | W | R | F | = | = |  | 02:30:00
13:30:00 | 22:00:00 | = | T | W | R | F | Y | = |  | 03:00:00
22:00:00 | 08:30:00 | M | T | W | = | = | = | S |  | 03:30:00
23:00:00 | 1900-01-01 09:30:00 | M | T | W | = | = | = | S |  | 04:00:00
22:00:00 | 08:30:00 | = | = | W | R | F | Y | = |  | 04:30:00
22:00:00 | 08:30:00 | = | = | W | R | F | Y | = |  | 05:00:00
 |  |  |  |  |  |  |  |  |  | 05:30:00
 |  |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  |  | 06:30:00
 |  |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  |  | 08:30:00
 |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  |  | 10:30:00
 |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  | 18:30:00
 |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  | 19:30:00
 |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  | 20:30:00
 |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  | 22:30:00
 |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  | 23:30:00
Spreadsheet: 821909d1678983525-compare-number-list-and-range-number-3-
Sheet: Sheet1

numbers | matches | num list
1 |  | 1
2 |  | 2
3 |  | 10
4 |  | 11
5 |  | 12
6 |  | 13
7 |  | 14-15
8 |  | 16
9 |  | 17
10 |  | 18-19
11 |  | 20-22
12 |  | 31-32
13 |  | 35-37
14 |  | 39-41
15 |  | 51
16 |  | 53
17 |  | 58
18 |  | 65
19 |  | 69-73
20 |  | 75
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Spreadsheet: 700741d1603311151-result-of-if-function-in-sumproduct-sample
Sheet: Sheet1

 |  |  |  | 3
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
CBHRC Billed |  |  |  | 1000 | 1750 | 2000 | 10000 | 20000
CBHRC Paid
CBHRC Paid Date
PMB Billed |  |  |  | 200 | 600
PMB Paid
PMB Paid Date
Spreadsheet: 41227d1239726214-producing-a-list-on-the-basis-of-a-value-test_sheet
Sheet: Sheet1

Number | Region | District | [NAME] | Cost | Sale | Difference
1 | 1 | N | 2 | 5 | 7
2 | 2 | N |  | 3 | 3
3 | 1 | N | 4 | 4 | 5
4 | 1 | N |  | 5 | 3
5 | 3 | S | 1 | 5 | 4
6 | 4 | S |  | 7 | 5
7 | 4 | S | 2 | 8 | 6
8 | 4 | S |  | 9 | 5
9 | 4 | S | 3 | 2 | 4
10 | 2 | N | 1 | 3 | 3
11 | 2 | N |  | 4 | 4
12 | 2 | N | 1 | 1 | 5
13 | 2 | N | 1 | 2 | 2
14 | 1 | N |  | 3 | 3
15 | 3 | S |  | 4 | 5
16 | 3 | S |  | 3
17 | 2 | N | 1 | 1 | 2
18 | 3 | S |  | 4 | 4
19 | 3 | S | 1 | 2 | 4
20 | 3 | S | 1 | 3 | 4
21 | 1 | N | 1 | 4 | 1
22 | 1 | N | 1 | 5 | 2
23 | 2 | N | 3 | 7 | 3
24 | 2 | N |  | 2 | 2
Spreadsheet: a6754e27-05f0-4abd-911f-1d4eafc70261
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
2D6DB | Test | 2D6DB | CYP2D6 [NAME] B, B ([NAME] Only) | CYP2D6 [NAME] B, B |  |  |  |  |  |  | This test is for billing purposes only. This is not an orderable test. |  |  | This test is for billing purposes only. This is not an orderable test. |  |  |  | 1 | 81479 |  |  |  |  | Rochester