tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 674135d1587672999-multiple-reference-on-workbook-project-assignments-2020
Sheet: Project Allocations

 | TIMEFRAME
 | WEEK OF
 | Job Name | A100 | B101 | D102 | G103 | H104 | L105 | S106 | V107 | Total Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Time Allocation
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A100 Administrative Duties - Emails, RFI'S & Pricing Changes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B101 BIM Coordination - BIM Meetings & Coordination of Systems
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D102 Design - Layout of Sprinkler Systems, Detailing & Final Construction Documentation
 |  |  |  |  |  |  |  |  |  |  |  |  |  | G103 General Office - In House Meetings & Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  | H104 Holiday - Paid Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | L105 Listing - Project Listing, Checking Fabrication Reports & Fabrication Drawings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | S106 Site Survey - Site Visits & Site Surveys
 |  |  |  |  |  |  |  |  |  |  |  |  |  | V107 Vacation/Sick/Personal Time
 | TOTAL
Spreadsheet: 122580d1316985550-excel-2007-linking-data-from-multiple-workbooks-to-one-workbook-example-3-linking
Sheet: OCT

 |  | 2011-10-03 00:00:00 |  | 2011-10-04 00:00:00 |  | 2011-10-05 00:00:00 |  | 2011-10-06 00:00:00 |  | 2011-10-07 00:00:00 |  | 2011-10-10 00:00:00 |  | 2011-10-11 00:00:00 |  | 2011-10-12 00:00:00 |  | 2011-10-13 00:00:00 |  | 2011-10-14 00:00:00 |  | 2011-10-18 00:00:00 |  | 2011-10-19 00:00:00 |  | 2011-10-20 00:00:00 |  | 2011-10-21 00:00:00 |  | 2011-10-24 00:00:00 |  | 2011-10-25 00:00:00 |  | 2011-10-26 00:00:00 |  | 2011-10-27 00:00:00 |  | 2011-10-28 00:00:00 |  | 2011-10-31 00:00:00 |  | Breakfast | Lunch
Manager | Dept | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L | B | L
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
 | 5XXX
 | 3XXX
 | 1XXX
Total 5XXX
Total 3XXX
Total 1XXX
Total Meals
Spreadsheet: kate_symes__18686__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-09 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-08 00:00:00 |  | 175.42 | 14400 | 142.48 | 5160
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
 | 2001-02-03 00:00:00 |  | 181.02 | 12256 | 156.16 | 8432
 | 2001-02-02 00:00:00 |  | 179.62 | 13336 | 156.19 | 7512
 | 2001-02-01 00:00:00 |  | 219.11 | 13984 | 176.57 | 4368
 | 2001-01-31 00:00:00 |  | 238.8 | 20288 | 184.92 | 4640
 | 2001-01-30 00:00:00 |  | 222.41 | 19968 | 176.45 | 6240
 | 2001-01-29 00:00:00 |  | 227.4 | 21840 | 181.89 | 4440
 | 2001-01-28 00:00:00 |  |  |  |  |  | 181.89 | 13320
 | 2001-01-27 00:00:00 |  | 211.11 | 21472 | 172.47 | 4456
 | 2001-01-26 00:00:00 |  | 211.11 | 21392 | 172.47 | 4456
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800
 | 2001-01-22 00:00:00 |  | 267.54 | 15440 | 185.36 | 2800
Spreadsheet: andy_zipper__182__DYNEGY-ICE VOL May14
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
Power | [NAME] | 1 | 24000 |  | Power | [NAME] | 3 | 5600 |  | (blank) | No Activity | 1 | 0
Power Total |  | 1 | 24000 |  | Power Total |  | 3 | 5600 |  | (blank) Total |  | 1 | 0
US Natural Gas | [NAME] | 2 | 10000 |  | Grand Total |  | 3 | 5600 |  | Grand Total |  | 1 | 0
 | [NAME] | 9 | 36000
 | [NAME] | 1 | 5000
US Natural Gas Total |  | 12 | 51000
Grand Total |  | 13 | 75000
Spreadsheet: 116341d1311768420-rank-if-rankif
Sheet: Sheet1

Name | Value | Rank |  | Helper column
A | 1 | 1 |  | 1
A | 2 | 3 |  | 1
A | 3 | 5 |  | 2
A | 4 | 7 |  | 2
A | 5 | 8 |  | 3
B | 6 |  |  | 3
B | 7 |  |  | 4
B | 8 |  |  | 5
B | 9
A | 3 | 6
A | 2 | 4
A | 1 | 2
Spreadsheet: 757460d1638278103-how-to-combine-data-from-mutiple-sheets-and-generate-a-report-natraj-yarn-stock-fresh-copy
Sheet: YARN REPORT

DATE | MOVEMENT | INVOICE NO./CHALLAN NO. | PARTY NAME | YARN CODE | YARN | WEFT IN | WARP IN | WEFT OUT | WARP OUT | TYPE | YARN UQC | PO NO.
Spreadsheet: 147391d1332780281-formula-for-criteria-in-multiple-columns-excelforum-821510-fault-pivot
Sheet: Summary

 | Count of Status | Status
 | Time Period | At Fault | Not at Fault | Grand Total
 | 06:01 - 09:00 | 0.5 | 0.5 | 1
 | 09:01 - 11:00 | 0 | 1 | 1
 | 11:01 - 14:00 | 1 | 0 | 1
 | 14:01 - 17:00 | 1 | 0 | 1
 | After 17:01 | 1 | 0 | 1
 | Before 06:00 | 0.8333333333333334 | 0.1666666666666667 | 1
 | Grand Total | 0.7222222222222222 | 0.2777777777777778 | 1
Spreadsheet: 072b0aa5-95b9-433a-b807-f16c65fd48e4
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
TLRU | Test | TLRU | Thallium, Random, [NAME] | Thallium, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 1 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 1 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-1 mcg/L Reference values apply to all ages. | Tuesday, Friday; 3 p.m. | 1 day | 5 days | 1 | 83018 |  |  |  |  | Rochester
TLRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
TLRU | Result | 60324 | Thallium, Random, U | Thallium, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5745-5 | Thallium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 807767d1670034146-apply-different-penalty-rates-over-a-24-hr-period-pay-calculator_rev-08c
Sheet: Penalty Rate Calculator

CALCULATOR # 1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!!
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES PRO-RATA ON AN HOURLY BASIS STARTING BEFORE 6.59AM AND FINISHING AFTER 7:00AM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM |  |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | FINISHING AFTER 8:00PM
 |  | 1st. HALF |  |  |  |  |  |  |  | ROUNDED |  | 2nd. HALF |  |  |  |  |  |  |  | ROUNDED
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
CALCULATOR # 2.
EARLY/LATE PENALTY CALCULATOR FOR SHIFT WORK TIMES THAT START BEFORE 5:00PM AND FINISH AFTER 8:00PM
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS
 |  | 1st. HALF |  |  |  |  |  |  |  |  |  | 2nd. HALF
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  |  |  |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINISH OFF !!!
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
Spreadsheet: 218645d1362520071-formulae-to-count-multiple-tab-date-house-keeping-audit
Sheet: Week 13

 | Day Shift |  | Team Leader |  |  |  |  | WEEK
 |  | MONDAY |  |  |  |  | TUESDAY |  |  |  |  | WEDNESDAY |  |  |  |  | THURSDAY |  |  |  | Friday
 |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  | LINE | TO | SCORE
 |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 2
 |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
 |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
 |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  | 5
 |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
 |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  | 7
 |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  | 8
 |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  | 9
 |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  | LINE | LIFT OFF | SCORE
 |  | 2 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | 1
 |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 2
 |  | 4 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
 |  | 5 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
 |  | 6 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  | 5
 |  | 7 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
 |  | 8 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  | 7
 |  | 9 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  | 8
 | Night Shift |  | Team Leader |  |  |  |  | WEEK
 |  | MONDAY |  |  |  |  | TUESDAY |  |  |  |  | WEDNESDAY |  |  |  |  | THURSDAY |  |  |  | FRIDAY
 |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  |  | LINE | TO | SCORE |  | LINE | TO | SCORE
 |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 2
 |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
 |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
 |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  | 5
 |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
 |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  | 7
 |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  | 8
 |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  | 9
 |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  |  | LINE | LIFT OFF | SCORE |  | LINE | LIFT OFF | SCORE
 |  | 2 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | 1
 |  | 3 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  | 2
 |  | 4 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  | 3
 |  | 5 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  | 4
 |  | 6 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  | 5
 |  | 7 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  | 6
 |  | 8 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  | 7
 |  | 9 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  | 8
Spreadsheet: 827162d1682516997-conditional-formatting-on-cell-containing-formula-samplebook-aligw
Sheet: Sheet1

11.01 |  |  |  |  |  | workbook
number id | amount | Verifier column |  |  |  | manual entry | result
12345 | 10 |  |  |  |  | 12345 | 10
12346 | 20
12347 | 30
12348 | 40
12349 | 50
[NAME] on column C is looking for a match in column G.
Spreadsheet: 355267d1414636391-index-mach-or-lookup-formula-help-booksem
Sheet: Sheet2

LIST |  |  |  |  |  |  |  | RESULT
01 05 09 14 17 | 02 03 05 09 18 | 04 05 06 09 12 | 05 07 09 16 19 | 05 08 09 10 11 | 05 09 13 15 20 |  | 13 15 19 | 5,6
01 04 05 16 19 | 02 05 08 09 16 | 03 05 12 16 20 | 05 06 15 16 18 | 05 07 13 14 16 | 05 10 11 16 17 |  | 03 08 09 | 4,15
01 05 07 11 12 | 02 05 11 14 16 | 03 05 11 15 20 | 04 05 10 11 19 | 05 06 08 09 11 | 05 11 13 17 18 |  | 01 04 16 | 2,7,12
01 02 03 16 20 | 03 04 05 14 16 | 03 06 10 13 16 | 03 07 15 16 18 | 03 08 09 12 16 | 03 11 16 17 19 |  | 11 15 19 | 5,6,10
01 11 13 15 19 | 02 05 13 14 15 | 03 06 07 13 15 | 04 13 15 16 18 | 08 12 13 15 20 | 09 10 13 15 17 |  | 09 10 13 | 5,6
01 08 14 15 19 | 02 03 05 15 19 | 04 06 07 15 19 | 09 10 13 15 19 | 11 12 15 17 19 | 15 16 18 19 20 |  | 06 10 14 | 11,13
01 04 05 13 16 | 02 06 13 16 20 | 03 07 09 13 16 | 08 10 12 13 16 | 11 13 15 16 17 | 13 14 16 18 19 |  | 01 09 14 | 1,8,13,14
01 02 03 10 16 | 01 03 04 15 20 | 01 03 05 12 19 | 01 03 06 08 13 | 01 03 07 17 18 | 01 03 09 11 14 |  | 09 10 15 | 5,6,11,15
01 03 08 12 15 | 02 04 05 08 12 | 06 08 12 14 20 | 07 08 10 12 19 | 08 09 12 16 17 | 08 11 12 13 18
01 07 11 15 19 | 02 03 07 11 16 | 04 07 08 11 18 | 05 06 07 11 12 | 07 09 11 17 20 | 07 10 11 13 14
01 02 04 10 13 | 01 03 08 10 20 | 01 05 10 18 19 | 01 06 10 11 14 | 01 07 10 12 17 | 01 09 10 15 16
01 04 16 19 20 | 02 04 09 14 19 | 03 04 06 08 19 | 04 05 11 17 19 | 04 07 13 18 19 | 04 10 12 15 19
01 06 09 14 18 | 02 06 08 12 14 | 03 05 06 07 14 | 04 06 10 14 15 | 06 11 14 17 20 | 06 13 14 16 19
01 05 09 14 15 | 02 06 09 12 14 | 03 09 11 14 18 | 04 09 10 14 20 | 07 09 13 14 17 | 08 09 14 16 19
01 03 09 10 15 | 02 03 09 12 18 | 03 04 09 11 16 | 03 05 09 13 17 | 03 06 07 09 20 | 03 08 09 14 19
01 02 05 15 16 | 01 03 05 09 20 | 01 04 05 10 17 | 01 05 06 11 13 | 01 05 07 08 18 | 01 05 12 14 19
Spreadsheet: e815e4d2-e02e-442c-926f-cae5b2dd0bff
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
BREG | Test | BREG | Beef Neutral-Regular Insulin, IgE | Beef Neutral-Regular Insulin, 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
BREG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BREG | Result | BREG | Beef Neutral-Regular Insulin, IgE | Beef Neutral-Regular Insulin, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6147-3 | Insulin bovine Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 847704d1698562823-look-up-and-return-row-sample-4-1-
Sheet: result

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
2023-10-27 00:00:00 | FRI | 0.2083333333333333 | 2023-10-27 00:00:00 | 14339.5 | 63.5
2023-10-27 00:00:00 | FRI | 0.406574074074074 | 2023-10-27 00:00:00 | 14357 | 55
2023-10-27 00:00:00 | FRI | 0.4093171296296296 | 2023-10-27 00:00:00 | 14292 | -65
2023-10-27 00:00:00 | FRI | 0.4217592592592592 | 2023-10-27 00:00:00 | 14358.25 | 64.5
2023-10-27 00:00:00 | FRI | 0.4233333333333333 | 2023-10-27 00:00:00 | 14293.75 | -64.5
2023-10-27 00:00:00 | FRI | 0.4265625 | 2023-10-27 00:00:00 | 14369.5 | 75.75
2023-10-27 00:00:00 | FRI | 0.4302430555555556 | 2023-10-27 00:00:00 | 14308.5 | -61
2023-10-27 00:00:00 | FRI | 0.4351273148148149 | 2023-10-27 00:00:00 | 14359 | 50.5
2023-10-27 00:00:00 | FRI | 0.4462615740740741 | 2023-10-27 00:00:00 | 14274 | -77.75
2023-10-27 00:00:00 | FRI | 0.4583333333333333 | 2023-10-27 00:00:00 | 14336.75 | 62.75
2023-10-27 00:00:00 | FRI | 0.4703125 | 2023-10-27 00:00:00 | 14404.75 | 68
2023-10-27 00:00:00 | FRI | 0.4822337962962963 | 2023-10-27 00:00:00 | 14351.25 | -56.5
2023-10-27 00:00:00 | FRI | 0.5191435185185186 | 2023-10-27 00:00:00 | 14314 | -58.5
2023-10-27 00:00:00 | FRI | 0.5416666666666666 | 2023-10-27 00:00:00 | 14304 | -51.75
2023-10-27 00:00:00 | FRI | 0.5545486111111111 | 2023-10-27 00:00:00 | 14236.75 | -67.25
2023-10-27 00:00:00 | FRI | 0.5951736111111111 | 2023-10-27 00:00:00 | 14267.5 | 55.25
2023-10-27 00:00:00 | FRI | 0.6004166666666667 | 2023-10-27 00:00:00 | 14215.75 | -51.75
2023-10-27 00:00:00 | FRI | 0.6149652777777778 | 2023-10-27 00:00:00 | 14284.75 | 69
2023-10-27 00:00:00 | FRI | 0.6241319444444444 | 2023-10-27 00:00:00 | 14214 | -70.75
2023-10-27 00:00:00 | FRI | 0.6529513888888888 | 2023-10-27 00:00:00 | 14209.75 | -58
2023-10-27 00:00:00 | FRI | 0.6666666666666666 | 2023-10-27 00:00:00 | 14265.75 | 56
Spreadsheet: 822687d1679487266-match-person-based-on-date-postcode-to-a-location-date-postcode-muck-about
Sheet: Raw data

Date | Location | Person | Postcode | [NAME] | l1
2023-04-22 00:00:00 | Ashton |  | OL
2023-04-27 00:00:00 | Ashton |  | OL
2023-04-29 00:00:00 | Ashton |  | OL
2023-05-02 00:00:00 | Ashton |  | OL
2023-05-03 00:00:00 | Ashton |  | OL
2023-03-31 00:00:00 | Tettenhall |  | WV
2023-03-31 00:00:00 | Wednesfield |  | WV
2023-04-06 00:00:00 | Wednesfield |  | WV
2023-04-19 00:00:00 | Wednesfield |  | WV
2023-04-21 00:00:00 | Wednesfield |  | WV
2023-04-21 00:00:00 | Wednesfield |  | WV
2023-04-22 00:00:00 | Wednesfield |  | WV
2023-04-23 00:00:00 | Wednesfield |  | WV
2023-04-24 00:00:00 | Wednesfield |  | WV
2023-04-26 00:00:00 | Wednesfield |  | WV
2023-04-28 00:00:00 | Wednesfield |  | WV
2023-04-29 00:00:00 | Wednesfield |  | WV
2023-05-02 00:00:00 | Wednesfield |  | WV
2023-05-02 00:00:00 | Wednesfield |  | WV
2023-05-03 00:00:00 | Wednesfield |  | WV
2023-05-03 00:00:00 | Wednesfield |  | WV
2023-05-04 00:00:00 | Wednesfield |  | WV
2023-05-04 00:00:00 | Wednesfield |  | WV
2023-05-05 00:00:00 | Wednesfield |  | WV
2023-05-05 00:00:00 | Wednesfield |  | WV
2023-05-06 00:00:00 | Wednesfield |  | WV
2023-05-08 00:00:00 | Wednesfield |  | WV
2023-05-09 00:00:00 | Wednesfield |  | WV
2023-05-09 00:00:00 | Wolverhampton 9 |  | WV
2023-05-09 00:00:00 | Wednesfield |  | WV
2023-05-10 00:00:00 | Wednesfield |  | WV
2023-05-10 00:00:00 | Wednesfield |  | WV
2023-03-25 00:00:00 | Westbury |  | ST
2023-03-27 00:00:00 | Willenhall |  | WV
2023-04-04 00:00:00 | Willenhall |  | WV
2023-04-06 00:00:00 | Willenhall |  | WV
2023-04-11 00:00:00 | Willenhall |  | WV
2023-04-18 00:00:00 | Willenhall |  | WV
2023-04-24 00:00:00 | Willenhall |  | WV
2023-04-29 00:00:00 |  | [NAME] | OL
2023-07-05 00:00:00 | Plymouth |  | PL
2023-07-06 00:00:00 | Plymouth |  | PL
2023-04-29 00:00:00 |  | [NAME] | WV
2023-04-30 00:00:00 |  | [NAME] | WV
2023-05-01 00:00:00 |  | [NAME] | WV
2023-05-02 00:00:00 |  | [NAME] | WV
2023-05-03 00:00:00 |  | [NAME] | WV
2023-05-04 00:00:00 |  | [NAME] | WV
2023-05-05 00:00:00 |  | [NAME] | WV
2023-05-06 00:00:00 |  | [NAME] | WV
2023-05-07 00:00:00 |  | [NAME] | WV
2023-05-08 00:00:00 |  | [NAME] | WV
2023-05-09 00:00:00 |  | [NAME] | WV
2023-03-25 00:00:00 |  | [NAME] | ST
Spreadsheet: 179063d1347018340-help-needed-to-correct-a-formula-showing-a-false-result-pilotlog-and-techlogtest
Sheet: Tech Log

G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Running Total
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 1:15:00 | Remarks |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | 34.15
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks