tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853796d1703770799-lookup-to-return-x-results-and-punctuation-within-a-statement-book1
Sheet: Sheet1

Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place
Anna |  |  |  | School 1 |  |  | 146 | Qualified |  | Anna |  |  |  | School 1 |  |  | 146 | Qualified |  | Anna |  |  |  | School 1 |  |  | 146 | Qualified
[NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6
[NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9
[NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123 | Qualified
[NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121 | Qualified
Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60
George |  |  |  | School 7 |  |  | 140 |  |  | George |  |  |  | School 7 |  |  | 140 | Qualified |  | George |  |  |  | School 7 |  |  | 140 | Qualified
[NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135 | Qualified
[NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52
[NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12
[NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6
[NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9
Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10
Qualifying Places: 1 |  |  |  |  |  |  |  |  |  | Qualifying Places: 2 |  |  |  |  |  |  |  |  |  | Qualifying Places: 5
And I can confirm that [NAME] has qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME] and [NAME] have qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME], [NAME], [NAME], [NAME] and [NAME] have qualified to the next round.
Spreadsheet: 752917d1635099911-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-1
Sheet: Master sheet (with load)

Site details |  |  |  |  |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-11-02 00:00:00 |  |  |  | 2021-11-03 00:00:00 |  |  |  | 2021-11-04 00:00:00 |  |  |  | 2021-11-05 00:00:00
Route | Route order | Status | Company | Code | Site | Address | Postcode | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit
Text | Text | Text | Text | Text | Site 2 | Text | Text | Partial, Access Issue |  |  |  | Full, Access Issue |  |  |  | Full |  |  |  | None |  |  |  | Full
Text | Text | Text | Text | Text | Site 1 | Text | Text | Full, Access Issue |  |  |  | Full |  |  |  | Partial, Access Issue |  |  |  | Full |  |  |  | None
Text | Text | Text | Text | Text | Site 4 | Text | Text | Full, Access Issue |  |  |  | None |  |  |  | Partial, Access Issue |  |  |  | Full |  |  |  | Full
Text | Text | Text | Text | Text | Site 5 | Text | Text | Full |  |  |  | None |  |  |  | Full |  |  |  | Partial, Access Issue |  |  |  | Full, Access Issue
Text | Text | Text | Text | Text | Site 3 | Text | Text | Full |  |  |  | Full |  |  |  | None |  |  |  | Full, Access Issue |  |  |  | Partial, Access Issue
 |  | This is then the same sheet with the data pasted into the cell which relates to the correct date and site despite the site order being different.
Spreadsheet: 765877d1643647853-solved-holiday-calendar-by-province-timesheet-template-final-version
Sheet: Linda

 |  | Time Tracker
 | Nov-Dec
 |  | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | Total
[NAME] | Ally
CPSP.8601.02.06 | Kineret
CPSP.8612.02.06 | Navigate
CPSP.8603.02.06 | NordiCare
CPSP.8609.02.06 | NN Hemophil
CPSP.8613.02.06 | EasyStart
CPSP.3579.02.06 | OnCare
 | Total
 | V
 | P
 | S
 | L
 | B
 | R
Spreadsheet: 3fd01d6f-8e17-4709-92fa-e3338a5341b3
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | MARCH 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | [NAME] | 2014
Spreadsheet: f30d90f7-ecfb-4282-8492-fac9e8a0cb64
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
FFTLB | Test | FFTLB | Toluene, Occupational Exposure, Blood | Toluene, Blood | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 2 | Varies | Draw blood in 2 green top (sodium heparin) tubes. [NAME] should be filled to prevent loss of volatile compound into  headspace. Send 20 mL of sodium heparin whole blood refrigerated. | 2.5 mL NOTE: Submission of the m | Specimens other than	Whole blood Anticoagulants other than	Sodium heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Normal (unexposed population):  None detected   Exposed: Biological Exposure Index (BEI):  0.05 mg/L (prior to last shift of workweek) Biological Tolerance Value (BAT): 1.0 mg/L (end of exposure or end of shift)     Toxic:  Blood levels between 50 and 79 mg/L were found in people who died of acute toluene inhalation.   Test Performed By Medtox Laboratories, Inc. 402 W County Road D St. Paul, MN 55112 | Monday through Sunday | 7 days | 9-11 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc
FFTLB | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated
FFTLB | Result | Z1203 | Toluene | Toluene | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 123146d1317377547-finding-last-used-price-per-product-in-list-of-invoices-highest-price
Sheet: Pivot

Row Labels | Sum of Quantity | Sum of Revenue against latest price | Sum of Weighted Average price
apple | 172936 | 73200.94877220591 | 0.4232834619293028
banana | 264780 | 305468.5440134114 | 1.153669249994
melon | 100314 | 109565.4357782395 | 1.09222477199832
orange | 23356 | 7306.442966406908 | 0.3128293785925205
Grand Total | 561386 | 495541.3715302637 | 0.8827105975750441
Spreadsheet: 828938d1683801962-how-to-find-the-value-count-between-two-time-slots-sample-sheet_find-the-time-slot
Sheet: Output sheet

Start Time | 08:00:00
End Time | 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
2022-05-01 00:00:00
2022-05-02 00:00:00
2022-05-03 00:00:00
2022-05-04 00:00:00
2022-05-05 00:00:00
2022-05-06 00:00:00
2022-05-07 00:00:00
2022-05-08 00:00:00
2022-05-09 00:00:00
2022-05-10 00:00:00
2022-05-11 00:00:00
2022-05-12 00:00:00
Spreadsheet: 29726d1224791864-bin-location-counting-for-inventory-copy-of-example
Sheet: Inv. Oct - 08

 | [NAME] |  |  |  |  |  | Month: | 2008-10-01 00:00:00
 | Model | Description | Supply  Number | Starting Quantity | Quantity Ordered | Distributed | Physical Counts | [NAME] | Totals
 | WorkCentre 5655 | Toner | 6R1046 |  | 0 | 1 |  | 1 | -1
 | WorkCentre 5655 | Fuser | 544P24143/109R00752 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 5655 | [NAME] Transfer Unit | 113R672 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 5655 | [NAME] | 113R718 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 5655 | Staples | 108R00493 |  | 0 | 1 |  | 1 | -1
 | WorkCentre 7345 | Waste Toner | 8R12903 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 7345 | [NAME] | 13R00624 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 7345 | Black Toner | 6R1175 |  | 2 | 0 |  | -2 | 2
 | WorkCentre 7345 | [NAME] | 6R1176 |  | 2 | 0 |  | -2 | 2
 | WorkCentre 7345 | [NAME] | 6R1177 |  | 2 | 0 |  | -2 | 2
 | WorkCentre 7345 | [NAME] | 6R1178 |  | 2 | 0 |  | -2 | 2
 | WorkCentre 7345 | Staples | 8R12915 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 7345 | Pro Finisher Staples | 8R12941 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 4150 | Toner | 6R01274 |  | 0 | 1 |  | 1 | -1
 | WorkCentre 4150 | [NAME] | 13R00623 |  | 0 | 0 |  | 0 | 0
 | Nuvera  120EA | Toner | 6R1261 |  | 0 | 0 |  | 0 | 0
 | Nuvera  120EA | Staple Cartridge 50/Sheet Capacity | 8R12919 |  | 0 | 0 |  | 0 | 0
 | Nuvera  120EA | Staple Refill 50/Sheet Capacity | 8R12920 |  | 0 | 0 |  | 0 | 0
 | Nuvera  120EA | Staple Refill 100/Sheet Capacity | 8R12898 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 4112 | Toner | 6R1237 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 4112 | Booklet Staples | 8R12925 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 4112 | Staples | 8R13041 |  | 0 | 0 |  | 0 | 0
 | WorkCentre 4112 | Waste Toner | 8R13036 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Black Toner | 6R1219 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | [NAME] | 6R1220 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | [NAME] | 6R1221 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | [NAME] | 6R1222 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Black Drum Cartridge | 13R602 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Yellow/Magenta/Cyan Drum Cartridge | 13R603 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Staples | 8R12941 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Booklet Staples | 8R12925 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Waste Toner Bottles | 8R12990 |  | 0 | 0 |  | 0 | 0
 | DocuColor 242 | Charge Cortron | 13R630 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | 42" Photo Paper Gloss | 23R02111 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | 42" Poster Presentation Paper | 23R02177 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | Black Toner | 8R12994 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | [NAME] | 8R12993 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | [NAME] | 8R12992 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | [NAME] | 8R12991 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | Light Cyan | 8R12995 |  | 0 | 0 |  | 0 | 0
 | 8412 CLR Wide Format | Light Magenta | 8R12996 |  | 0 | 0 |  | 0 | 0
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: JAN_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Summary - CSL

Shipments waiting to be collected
Shipment Status | (Multiple Items) |  |  |  |  |  | Shipment Status | (Multiple Items)
No of Shipments |  |  |  |  |  |  | No of Shipments
 | [NAME] | [NAME] | [NAME] | Riaan | Grand Total |  |  | Total
Duvha |  |  |  | 1 | 1 |  | [NAME] | 3
Koeberg |  | 9 |  |  | 9 |  | [NAME] | 9
[NAME] |  |  | 2 |  | 2 |  | [NAME] | 2
Lethabo |  |  |  | 1 | 1 |  | Riaan | 6
[NAME] |  |  |  | 2 | 2 |  | Grand Total | 20
Matimba | 3 |  |  |  | 3
Tutuka |  |  |  | 2 | 2
Grand Total | 3 | 9 | 2 | 6 | 20
Shipment Status | (Multiple Items) |  |  |  |  |  | Shipment Status | (Multiple Items)
Sum of Shipment Value (USD) |  |  |  |  |  |  | Sum of Shipment Value (USD)
 | [NAME] | [NAME] | [NAME] | Riaan | Grand Total |  |  | Total
Duvha |  |  |  | 95471.996 | 95471.996 |  | [NAME] | 0.0812204653314994
Koeberg |  | 285784.15 |  |  | 285784.15 |  | [NAME] | 0.2878599148234275
[NAME] |  |  | 147030.9232 |  | 147030.9232 |  | [NAME] | 0.5500517816184538
Lethabo |  |  |  | 196151.2 | 196151.2 |  | Riaan | 0.08086783822661921
[NAME] |  |  |  | 93932.85759999999 | 93932.85759999999 |  | Grand Total | 1
Matimba | 38257.56480000001 |  |  |  | 38257.56480000001
Tutuka |  |  |  | 51604.8244 | 51604.8244
Grand Total | 38257.56480000001 | 285784.15 | 147030.9232 | 437160.878 | 908233.5160000001
Spreadsheet: 760890d1640513721-ms-excel-365-if-sumif-conditional-etc-formula-needed-excel-formula
Sheet: GANTT CHART

Task ID | Task Name | Start Date | End Date | Duration (In Days) | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00
T01 | Contract Signing | 2020-05-02 00:00:00 | 2020-05-02 00:00:00
T02 | Design / Planning | 2020-05-03 00:00:00 | 2020-05-04 00:00:00
[NAME] | Mobilization | 2020-05-04 00:00:00 | 2020-05-05 00:00:00
T04 | Grading / Seeding | 2020-05-06 00:00:00 | 2020-05-11 00:00:00
T05 | Soil Preparation | 2020-05-10 00:00:00 | 2020-05-13 00:00:00
T06 | Planting | 2020-05-13 00:00:00 | 2020-05-16 00:00:00
T07 | Mulching | 2020-05-17 00:00:00 | 2020-05-19 00:00:00
T08 | Edges / Borders | 2020-05-20 00:00:00 | 2020-05-20 00:00:00
T09 | Trimming / Pruning | 2020-05-21 00:00:00 | 2020-05-21 00:00:00
T10 | Fertilizing | 2020-05-22 00:00:00 | 2020-05-22 00:00:00
T11 | Irrigation | 2020-05-22 00:00:00 | 2020-05-24 00:00:00
T12 | Walkway | 2020-05-25 00:00:00 | 2020-05-25 00:00:00
T13 | Pond Installation | 2020-05-25 00:00:00 | 2020-05-26 00:00:00
T14 | Acceptance | 2020-05-27 00:00:00 | 2020-05-27 00:00:00
© Templatelab
Spreadsheet: 859643d1707959494-multiple-dropdown-selections-and-showing-data-testbook
Sheet: Data

Site | Red |  |  |  |  | Upon selection of B1 only, when B2 and B3 are empty it should show top 5 bylines of the site selected in B1, for all the years and quarters
Year | 2020 |  |  |  |  | If B1 and B2 are selected, and B3 is empty, then it should show top 5 bylines of the site and year selected only
Quarter |  |  |  |  |  | If B1, B2, B3 all are selected, then it should show top 5 bylines of the site, year and quarter selected
 |  |  |  |  |  | B1, B2, B3 have dropdowns
Top 5 Bylines
 | 400
Ibrahim | 350
Musa | 300
[NAME] | 100
[NAME] | 90
Spreadsheet: 683269d1592580856-sumproduct-index-match-sumif
Sheet: Sheet1

Date | Hours Worked
2020-06-16 00:00:00 | 1.25
2020-06-16 00:00:00 | 1.25
2020-06-16 00:00:00 | 3.5
2020-06-16 00:00:00 | 0.75
2020-06-16 00:00:00 | 1.25
2020-06-16 00:00:00 | 3.25
2020-06-16 00:00:00 | 1.5
2020-06-16 00:00:00 | 1.25
2020-06-17 00:00:00 | 0.75
2020-06-17 00:00:00 | 0.75
2020-06-17 00:00:00 | 2.25
2020-06-17 00:00:00 | 0.75
2020-06-17 00:00:00 | 0.75
2020-06-17 00:00:00 | 4.5
2020-06-17 00:00:00 | 2.5
Spreadsheet: 774680d1648615288-create-a-proper-table-for-dashboard-based-on-multiple-tabs-book1
Sheet: 01-2022

 |  |  | REVENUE USD
 |  | TOTAL | Booking.com | Expedia | Agoda | Traveloka | Hotelscombined
 | UNIT 1 |  | 10519.91112615385 | 2215.733247692307 |  | 933.0112600000001
 | UNIT 2 |  | 403.4058333333333 | 53.88333333333333 | 255.8438333333333
 | UNIT 3 |  | 58.23333333333333 |  | 131.55
 | UNIT 4 |  | 0 | 0 | 0 | 0 | 0
 | UNIT 5 |  | 3115.602660944206 | 17.26227467811159 | 4229.621974248927 | 2322.784034334764
 | UNIT 6 |  | 381.8235483870968 |  | 899.8390322580644
 | UNIT 7 |  | 54.17064516129032 | 0 | 97.10677419354839 | 0 | 0
 | UNIT 8 |  | 475.3793333333333 | 173.53
 | UNIT 9 |  | 4690.557419354839 | 559.0167741935484 | 5841.510322580645 | 1226.954838709677
 | UNIT 10 |  | 481.5777419354839 | 515.0638709677419 | 3201.24129032258 | 57.08838709677419
Spreadsheet: 675518d1588339917-this-formula-makes-my-workbook-chug-can-it-be-optimized-forumexample
Sheet: Sheet1

Card type | Name | Account | Swimlane | Start | End | Time Bad | Time Good | Carryover?
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-01-23 07:00:00 | 2020-01-23 08:00:00 | 1:00 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-01-27 10:00:00 | 2020-01-27 11:30:00 | 1:30 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-02-19 15:00:00 | 2020-02-19 15:45:00 | 45 min
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-03-23 02:00:00 | 2020-03-23 03:30:00 | 1:30 hrs
SubAssy OL | 1217546 - Life Fitness - DB 4Pk | TC-Planning | Assembly | 2020-04-09 22:00:00 | 2020-04-10 23:30:00 | 1:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-03-11 22:00:00 | 2020-03-12 07:30:00 | 9:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-04-16 15:30:00 | 2020-04-16 19:00:00 | 3:30 hrs
SubAssy OL | 1219874 - Landscape - Large | TC-Planning | Assembly | 2020-04-16 19:30:00 | 2020-04-16 23:00:00 | 3:30 hrs
SubAssy OL | 1219875 - Landscape - Small | 8600 Project Management | Assembly | 2020-02-26 22:00:00 | 2020-02-27 04:00:00 | 6:00 hrs
SubAssy OL | 1219875 - Landscape - Small | TC-Planning | Assembly | 2020-04-01 22:30:00 | 2020-04-02 06:30:00 | 8:00 hrs
SubAssy OL | 1219875 - Landscape - Small | TC-Planning | Assembly | 2020-04-17 16:00:00 | 2020-04-17 22:15:00 | 6:15 hrs
Spreadsheet: 134482d1325325378-help-to-update-next-column-using-formula-picking-text-based-on-conditions
Sheet: Sheet2

 |  |  |  |  |  |  | Reference
 | 2010 |  | 2011
 | Jawatan | gred | jawatan | gred |  |  | 2010 |  | 2011
 | Guru | M12 |  |  |  |  | Jawatan | Gred | Jawatan | Gred
 | [NAME] | F12 |  |  |  |  | Guru | M12 | [NAME] | M-2-3
 | Jurulatih | K12 |  |  |  |  | [NAME] | F12 | Chef | NN-2-3
 | Pelajar | G12 |  |  |  |  | Jurulatih | K12 | Jurulatih | KK-2-3
 | Guru | [NAME] |  |  |  |  | Pelajar | G12 | Pelajar | M-1-2
 | [NAME] | F13
 | Jurulatih | K13
 | Pelajar | G13
 | Guru | M14
 | [NAME] | F14
 | Jurulatih | K14
 | Pelajar | G14
 | Guru | M15
 | [NAME] | F15
 | Jurulatih | K15
 | Pelajar | [NAME]
 | Guru | M16
 |  |  | Where there is #N/As, either the Jawatan or [NAME] is missing as combination in the table.
 |  |  | -DILIPandey
Spreadsheet: 734531d1622217381-return-data-to-show-which-has-the-longest-date-range-eh_longest
Sheet: Other

 |  |  |  |  |  |  |  |  |  |  | Central Team Use |  | !
 | Task | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ticket closed on |  | Longest task
 | 1 | 2021-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-30 00:00:00
 | 2 | 2021-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-30 00:00:00
 | 3 | 2021-05-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-31 00:00:00
 | 4 | 2021-05-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-30 00:00:00
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14 |  |  |  |  |  | Customer |  | GB
 | 15 |  |  |  |  |  | Customer |  | GB
 | 16 |  |  |  |  |  | Customer |  | GB
 | 17 |  |  |  |  |  | Customer |  | GB
 | 18 |  |  |  |  |  | Customer |  | GB
 | 19 |  |  |  |  |  | Customer |  | GB
 | 20 |  |  |  |  |  | Customer |  | GB
 | 21 |  |  |  |  |  | Customer |  | GB
 | 22 |  |  |  |  |  | Customer |  | GB
 | 23 |  |  |  |  |  | Customer |  | GB
 | 24 |  |  |  |  |  | Customer |  | GB
 | 25 |  |  |  |  |  | Customer |  | GB
 | 26 |  |  |  |  |  | Customer |  | GB
 | 27 |  |  |  |  |  | Customer |  | GB
 | 28 |  |  |  |  |  | Customer |  | GB
 | 29 |  |  |  |  |  | Customer |  | GB
 | 30 |  |  |  |  |  | Customer |  | GB
Spreadsheet: f33ca298-4d35-4624-80a2-2eb3484b0b08
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
PR3 | Test | PR3 | Proteinase 3 Antibodies, IgG, Serum | Proteinase 3 Ab (PR3), S | [NAME] | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <0.4 U (negative) 0.4-0.9 U (equivocal) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 3 days | 1 | 83516 |  |  |  |  | Rochester
PR3 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
PR3 | Result | PR3 | Proteinase 3 Ab (PR3), S | Proteinase 3 Ab (PR3), S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 6968-2
Spreadsheet: 103417d1301154039-double-lookup-rank-test
Sheet: Staffing

GL | First Name | Original Hire Date | Today's Date | Years of Service |  |  |  |  |  | GL | Tenure | Name
1618 | [NAME] | 2010-07-26 00:00:00 |  |  |  |  |  |  |  | 1619 |  |  | Most Tenured
1618 | Tami | 2010-04-12 00:00:00
1618 | [NAME] | 2005-01-17 00:00:00
1619 | Michelle | 2003-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | Least Tenured
1619 | Sandra | 2007-04-28 00:00:00
1619 | [NAME] | 2010-10-11 00:00:00
1624 | [NAME] | 2010-09-07 00:00:00
1624 | [NAME] | 2009-05-26 00:00:00
1624 | [NAME] | 2009-03-04 00:00:00
1628 | [NAME] | 2010-10-11 00:00:00
1628 | Emma | 1999-04-27 00:00:00
1628 | Lorena | 2006-10-11 00:00:00
1628 | Maria | 2010-06-28 00:00:00
1629 | [NAME] | 2009-05-27 00:00:00
1629 | [NAME] | 2009-10-26 00:00:00
1629 | [NAME] | 2011-03-21 00:00:00
1640 | Teresa | 2010-09-07 00:00:00
1640 | [NAME] | 2004-08-21 00:00:00
1640 | Helen | 2010-05-17 00:00:00
1645 | [NAME] | 2008-01-07 00:00:00
1645 | Andreal | 2010-04-12 00:00:00
1645 | Gloria | 2006-08-07 00:00:00
1649 | Troy | 2010-10-15 00:00:00
1649 | Charo | 2007-08-06 00:00:00
1649 | Nicole | 2010-07-26 00:00:00
1874 | Chrystal | 2011-03-14 00:00:00
1874 | Amber | 2010-03-08 00:00:00
1874 | Stacy | 2010-04-26 00:00:00
1879 | [NAME] | 2008-02-25 00:00:00
1879 | [NAME] | 2003-10-06 00:00:00
1879 | [NAME] | 1998-08-24 00:00:00
1879 | [NAME] | 2010-10-04 00:00:00
1954 | [NAME] | 1997-11-24 00:00:00
Spreadsheet: 679054d1590164983-formula-to-get-value-based-on-data-in-specfic-column-test
Sheet: Sheet1

Name | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Result |  |  |  |  |  |  |  |  | Select >> | Field 1
A | 1 | 3 | 4 | 2 | 2
S | 6 | Blank | 2 | 4 | Blank
F | 3 | 3 | Blank | Blank | 9
B | Blank | 6 | 8 | 3 | 6
Y | 9 | 7 | 4 | Blank | 4
M | 5 | 2 | Blank | 5 | Blank
H | 2 | Blank | 2 | 2 | 7
L | Blank | 2 | Blank | 4 | 2
C | 3 | 5 | 4 | 5 | 3
D | Blank | 7 | 5 | 8 | 7
R | 6 | 4 | 6 | 9 | 4