tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841001d1693246715-create-a-sum-in-a-cell-based-off-of-the-contents-of-another-workbooks-cells-project-workbook
Sheet: CAP INV RCVD

Period | Location | PO Number | Amount | Vendor | Delivery Date | Items Received | Items Outstanding | Note | SFF | MFF | 22 | 24 | 27 | 32 | 5440 | 7440 | Docks | Server | ThinClient | [NAME]
1 | ANC | 0 | 8976 | Connections | 2023-08-01 00:00:00 |  |  |  |  | 2 |  |  |  |  | 2
1 | PHX | 1 | 44567 | Connections | 2023-08-01 00:00:00 |  |  |  | 1 | 2 |  |  |  |  | 2 | 2
1 | ML | 2 | 3345 | Connections | 2023-08-01 00:00:00 |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1
1 | SPAN | 3 | 3500 | Connections | 2023-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 3 | 2
1 | HON | 4 | 618 | Connections | 2023-08-03 00:00:00 |  |  |  |  |  |  |  |  |  | 1
2 | ML | 5 | 39087 | Connections | 2023-08-05 00:00:00 |  |  |  |  |  |  | 32 |  |  | 3
2 | GUM | 6 | 44456 | Connections | 2023-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | 20
2 | NZ | 7 | 2355 | Connections | 2023-09-04 00:00:00 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
Spreadsheet: 588184d1535535301-formula-for-vlookup-for-next-n-days-book1
Sheet: Events

Date | Info1 | Info2
2018-01-01 00:00:00 |  | New Year
2018-01-06 00:00:00 |  | Day 2 in Jan
2018-01-08 00:00:00 |  | abc
2018-01-09 00:00:00 |  | xyz
2018-01-11 00:00:00 |  | info1
2018-01-15 00:00:00 |  | pqr
2018-01-16 00:00:00 |  | xyaaa
2018-01-17 00:00:00 |  | some info
2018-01-26 00:00:00 |  | more info
2018-03-10 00:00:00 |  | dfd
2018-03-15 00:00:00 |  | dfdfdfdfd
Spreadsheet: 274468d1383129623-finding-values-in-table-a-and-transfering-them-to-table-b-example
Sheet: Sheet1

Company | Sale |  | Company | Sales installation
10000 cccccccccccc | 301432 |  | 10000 cccccccccccc
Utstyr | 0 |  | 10200 xxx
Skjermer | 0 |  | 10300 ssssss
Playere | 0 |  | 10400 Jvvvvvvvvv
Annet utstyr | 0
Konsulent | 0
Kundetilpasning | 0
Kreativt | 0
[NAME] | 0
[NAME] / drift | 301432
[NAME] | 301432
[NAME] | 0
Arbeid | 0
Frakt | 0
Frakt | 0
10200 xxx | 1064566
Utstyr | 43691
Skjermer | 7900
Playere | 26400
Annet utstyr | 9391
Konsulent | 184200
Prosjektledelse | 42000
Kundetilpasning | 141000
[NAME] | 0
Rådgivning | 0
Annet konsulent | 1200
Kreativt | 0
Kreativt Reklame | 0
[NAME] / drift | 795625
[NAME] | 790000
Drift | 5625
[NAME] | 40675
Arbeid | 39475
Reise | 1200
Materiell | 0
Frakt | 375
Frakt | 375
10300 ssssss | 586971
Utstyr | 6500
Skjermer | 0
Playere | 6500
Konvertere | 0
Annet utstyr | 0
Konsulent | 0
Prosjektledelse | 0
Kundetilpasning | 0
[NAME] | 0
Annet konsulent | 0
Kreativt | 0
[NAME] | 0
Kreativt Reklame | 0
[NAME] | 0
[NAME] / drift | 567771
[NAME] | 524400
Drift | 43371
[NAME] | 12700
Arbeid | 4300
Reise | 8400
Frakt | 0
Frakt | 0
10400 Jvvvvvvvvv | 160640
Utstyr | 49850
Skjermer | 8050
Playere | 19500
Lyd | 15200
Annet utstyr | 7100
Konsulent | 86500
Prosjektledelse | 8000
Kundetilpasning | 71000
[NAME] | 0
Annet konsulent | 7500
Kreativt | 1000
[NAME] | 1000
Kreativt Reklame | 0
[NAME] / drift | 9000
[NAME] | 9000
Drift | 0
[NAME] | 14000
Arbeid | 14000
Frakt | 290
Frakt | 290
Spreadsheet: 846564d1697721396-lookup-formula-help-to-extract-multiple-values-based-on-one-reference-lookup_samrat_v1-aligw
Sheet: Costing

Batch Number | 27666 | If I enter any batch number here (which is in records in "Production Consumption" sheet), then below table shall be populated (from the actual data as recorded in "Production Sheet")as shown below
 |  | If I change the batch number then, below data shall be changed accordingly
Date | Product Code | Product Name | Customer | RM Code | RM Name | [NAME] | [NAME] | Standard Qty (in Kg) | Actual Qty Used in [NAME] (in Kg)
 | 123 | N.C SANDING SEALER | x | RTU TH. | a | 0.5 | 1000 | 500 | 600
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KS-017 | b | 0.01 | 1000 | 10 | 10
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KAS-041 | c | 0.055 | 1000 | 55 | 55
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KM-23 | d | 0.02 | 1000 | 20 | 20
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR4-014 | e | 0.05 | 1000 | 50 | 50
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | KR3-014 | f | 0.06 | 1000 | 60 | 60
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | [NAME] | g | 0.18 | 1000 | 180 | 180
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | PA-52 | h | 0.001 | 1000 | 1 | 1
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | EA | i | 0.085 | 1000 | 85 | 85
2023-10-10 00:00:00 | 123 | N.C SANDING SEALER | x | BA | j | 0.05 | 1000 | 50 | 50
Spreadsheet: 134587d1325495822-how-to-associate-cell-contents-with-other-cells-sample-8-
Sheet: Lookups

ID | Group | Collected | Tank
SB19 | SB | 2011-05-12 00:00:00 | 7
SB20 | SB | 2011-05-12 00:00:00 | 7
SB21 | SB | 2011-05-12 00:00:00 | 7
SB24 | SB | 2011-05-12 00:00:00 | 6
SB25 | SB | 2011-05-12 00:00:00 | 6
SB27 | SB | 2011-05-12 00:00:00 | 6
SH11 | S1 | 2011-05-12 00:00:00 | 7
SH6 | S1 | 2011-05-12 00:00:00 | 7
SH9 | S1 | 2011-05-12 00:00:00 | 7
Spreadsheet: 165049d1340997351-excel-2007-sorting-numerically-and-alphabetically-ignoring-preceding-text-book1_shayladawn
Sheet: Sheet1

 |  |  |  |  |  | Original List
PNW 027.625 Nor | 27.625 | Nor |  |  |  | PNW 027.625 Nor
PNW 133.1 Mun v. 2 | 133.1 | [NAME] |  |  |  | PNW 133.1 Mun v. 2
PNW 248 Smi | 248 | Smi |  |  |  | PNW 248 Smi
PNW 266 Dry | 266 | Dry |  |  |  | PNW 266 Dry
PNW 289.6 Bee | 289.6 | Bee |  |  |  | PNW 289.6 Bee
PNW 305.22 Swe | 305.22 | Swe |  |  |  | PNW 305.22 Swe
PNW 305.244 Herric | 305.244 | Herric |  |  |  | PNW 305.244 Herric
077.3 Pre | 77.3 | Pre |  |  |  | 077.3 Pre
178.3 Sul | 178.3 | Sul |  |  |  | 178.3 Sul
179.3 Wiehl | 179.3 | Wiehl |  |  |  | 179.3 Wiehl
180.7 Armstr | 180.7 | Armstr |  |  |  | 180.7 Armstr
182.7 Chapma | 182.7 | Chapma |  |  |  | 182.7 Chapma
200.7 [NAME] | 200.7 | [NAME] |  |  |  | 200.7 [NAME]
270 Alv | 270 | Alv |  |  |  | 270 Alv
279.1 Holtha | 279.1 | Holtha |  |  |  | 279.1 Holtha
279.20973 Edelma | 279.20973 | Edelma |  |  |  | 279.20973 Edelma
O 077.3 Pre | 77.3 | Pre |  |  |  | O 077.3 Pre
O 178.3 Sul | 178.3 | Sul |  |  |  | O 178.3 Sul
O 179.3 Wiehl | 179.3 | Wiehl |  |  |  | O 179.3 Wiehl
O 180.7 Armstr | 180.7 | Armstr |  |  |  | O 180.7 Armstr
O 182.7 Chapma | 182.7 | Chapma |  |  |  | O 182.7 Chapma
O 200.7 [NAME] | 200.7 | [NAME] |  |  |  | O 200.7 [NAME]
O 270 Alv | 270 | Alv |  |  |  | O 270 Alv
Spreadsheet: 58895d1259174433-sumproduct-dummy
Sheet: YTD TOTALS

2009 Year to Date Total
 | January | February | March | April | May | June | July | August | September | October | November | December
Total Loans Processed:
Total Loans Approved:
Total Loans Declined:
Total $ Amount Closed:
Total of Cross-Sells:
Total Mortgages Processed:
Total Manufactureds Processed:
Total HELOC's/2nd's Processed:
Total Auto's Processed:
Lending Team Loan Goals:
 | End of Year $ [NAME] |  | $ [NAME] Closed |  | % of Goal Met
Mortgages: |  |  |  |  | #N/A
Manufactureds: |  |  |  |  | #N/A
HELOC's/2nd's: |  |  |  |  | #N/A
Autos: |  |  |  |  | #N/A
Spreadsheet: 138232d1327579519-help-with-min-max-formula-vsum-min-max
Sheet: Sheet2

Budget line | Max PO Value | Min PO Value | Mode |  |  | SUMIF…………..
1005 | 1711742.56 | 0 | 0 |  |  | 1005 | 0
1006 | 0 | 0 | 0 |  |  | 1006 | 0
1010 | 4623612.23 | 0 | 0 |  |  | 1010 | 4743249.390000001
1018 | 0 | 0 | 0 |  |  | 1018 | 0
1022 | 699983.81 | 0 | 0 |  |  | 1022 | 1680852.87
1028 | 0 | 0 | 0 |  |  | 1028 | 0
1034 | 253711.54 | 0 | 0 |  |  | 1034 | 291652.38
1042 | 0 | 0 | 0 |  |  | 1042 | 0
Spreadsheet: 743362d1628442602-copying-rows-on-one-sheet-to-another-sheet-based-on-criteria-from-one-column-testjackpot
Sheet: 10 Results

FULL results (includes incentive AND non-incentive)
30 |  | [NAME] | [NAME] | 26.26 | 8.66 |  | 100
25 |  | [NAME] | [NAME] | 16.62 | 17.77 |  | 100
98 | * | Colby McCabe | [NAME] | 10.02 | 23.47 |  | 100
88 |  | [NAME] | Kurt F | 13.11 | 16.9 |  | 100
64 |  | [NAME] | Marshall Banks | 16.39 | 10.33 |  | 100
134 |  | Troy Hermelbracht | Elmer [NAME] | 9.2 | 16.85 |  | 100
104 |  | [NAME] | [NAME] | 11.81 | 13.38 |  | 100
111 |  | [NAME] | [NAME] | 12.34 | 12.44 |  | 100
132 |  | [NAME] | [NAME] | 10.12 | 14.6 |  | 100
78 |  | [NAME] | [NAME] | 8.36 | 15.56 |  | 100
4 | * | Shannon L | [NAME] | 12.41 | 10.05 |  | 100
9 |  | [NAME] | [NAME] | 14.96 | 7.3 |  | 100
79 |  | Colby McCabe | [NAME] | 11.56 | 8.49 |  | 100
72 | * | Colby McCabe | [NAME] | 9.12 | 10.85 |  | 100
48 |  | [NAME] | [NAME] | 8.49 | 11.35 |  | 100
66 | * | [NAME] | [NAME] | 10.64 | 7.67 |  | 100
23 | * | Jaeger [NAME] | [NAME] | 8.78 | 7.72 |  | 100
22 |  | [NAME] | [NAME] | 15.95 | 16.15 |  | 15.63
80 | * | [NAME] | [NAME] | 14.8 | 23.67 |  | 7.32
90 | * | Colby McCabe | Marshall Banks | 9 | 24.21 |  | 9.03
124 | * | [NAME] | [NAME] | 13.04 | 9.82 |  | 18.74
24 |  | [NAME] | [NAME] | 14.04 | 12.28 |  | 8.75
68 |  | Colby McCabe | [NAME] | 14.04 | 10.09 |  | 10
70 |  | [NAME] | [NAME] | 9.29 | 7.41 |  | 13.79
131 | * | [NAME] | [NAME] | 9.04 | 11.27 |  | 9.4
6 |  | [NAME] | [NAME] | 8.08 | 8.3 |  | 11.8
Spreadsheet: 1e9f757c-d961-4f72-ba25-7fab2b31809e
Sheet: Sheet1

Step 1 Kingpin Torque | Unnamed: 1 | Unnamed: 2 | English/Metric converstions | Unnamed: 4 | Unnamed: 5 | Cells in Blue are calculated cells in Black must be entered, Calculations are guidelines only and must be verified by the manufacturer | Unnamed: 7
 |  |  | lbs | Newtons
W | 15000 |  | 3500 | 15575
E | 310 |  | inches | [NAME]
B | 455 |  | 12 | 304.8
f | 0.1703110151211224
E/B= | 0.6813186813186813 |  | ft*lbs | nM
T | 892.2262023988683 |  | 481.1029411764705 | 654.3
 |  |  | in^3 | cc
Step 2 Force required |  |  | 7.326007326007327 | 120
steer angle | 55
r [NAME] | 195
r min [NAME] | 172.9671124697532 |  | 6.80972883739186 | inches
Stroke mm | 180.0819591616632 |  | 7.089840911876506 | inches
F newtons | 5158.357503105638 |  | 1159.181461372053 | lbs
Step 3 Cylinder Area
System Pressure Desired | 175 |  | 2537.5 | [NAME]
Pressure Derating | 0.8
Total cylinder area required | 36.15840111527855 |  | 5.604563381994939 | inches^2
Step 4 Steering valve displacement
Desired Turns lock to lock | 3.5
Q-amp ratio | 1
Steering displacement in CC calculated | 186.0421632283609 |  | 11.35788542297685 | inches^3, cid
Actual Performance |  |  | Pump Flow Required
Nearest Catalog displacement | 185 |  | Steering RPM | 120
Actual Cylinder Area cm^2 | 38 |  | Non Q-amp or manual Steering Q-Amp | 22.2 | ltr/min | 5.867148724291582 | gpm
Actual turns lock to lock | 3.698980782780109 |  | Non Manual steering [NAME] | 22.2 | ltr/min | 5.867148724291582 | gpm
Actual system pressure required bar | 166.5189525045723 |  | 2414.524811316298 | [NAME]
Calculated Cylinders |  |  | Actual Cylinders
Single differential cylinder |  |  | or enter your cylinder here |  |  | inches | [NAME]
[NAME] | 42 |  | [NAME] | 45 |  | 1 | 25.4
bore mm | 79.79868806839413 |  | bore mm | 85 |  | 1 | 25.4
Stroke used [NAME] | 180.0819591616632 |  | area cm^2 | 40.84070449666731
Cross connected cylinders |  |  | or enter your cylinder here
[NAME] | 42 |  | [NAME] | 42 |  | 1 | 25.4
bore mm | 56.42619346295152 |  | bore mm | 58 |  | 1 | 25.4
Stroke used [NAME] | 180.0819591616632 |  | area cm^2 | 38.98716483104933
[NAME] |  |  | or enter your cylinder here
[NAME] | 42 |  | [NAME] | 42 |  | 1 | 25.4
bore mm | 109.1983723627167 |  | bore mm | 112 |  | 1 | 25.4
Stroke used [NAME] | 180.0819591616632 |  | area cm^2 | 84.66592201424491
Spreadsheet: 841149d1693394618-mid-name-and-surname-the-end-with_th-mid-data-name-and-surname-the-end-with-_th
Sheet: Sheet1

AAA BBB-IN, AAA BBB-TH, AAA FFF-MY
JJJ SSS-TH
CCC YYY-CN
BBB BELGIUM ACCOUNT BUCKET-BE, KKK PPP-TH
[NAME], SSS SSSS-CN, VVVV WWW-TH, YYY PPP-SG
[NAME], FFF TTT-SG, KKK FFFKAN-MY, KKK PPP-TH, RRR CCC-BR
[NAME], DDD MMMMY, KKK AAA-TH, [NAME], RRR KKK-AU, TTT LLL-SG
[NAME], JJJ PPP-BR, JJJ CCC MMM CCC-ES, [NAME], RRR JJJ-IN, SSS DDD-AU, VVV WWW-TH
[NAME], DDD VVV-SG, DDD VVV-AU, KKK AAA-TH, [NAME], DDD VVV-CA, [NAME], DDD VVV-JP
[NAME], GGG ACCOUNT BUCKET-DE, [NAME], [NAME], KKK AAA-TH, [NAME], [NAME], DDD VVV-SG, DDD VVV-MY
[NAME], [NAME], DDD VVV-CN, [NAME], FFF ACCOUNT BUCKET-FR, [NAME], [NAME], [NAME], KKK PPP-TH, [NAME]
[NAME], [NAME], [NAME], [NAME], DDD VVV-MY, DDD VVV-CR, [NAME], [NAME], NNN ACCOUNT BUCKET-NL, SSS CCC-TH, [NAME]
[NAME], [NAME], DDD VVV-NZ, [NAME], [NAME], [NAME], DDD VVV-IT, DDD VVV-CN, UUU ACCOUNT BUCKET-AE, [NAME], [NAME], [NAME]
[NAME], [NAME], DDD VVV-FI, [NAME], [NAME], [NAME], DDD VVV-SG, DDD VVV-AU, VVV WWW-TH, [NAME], [NAME], [NAME], DDD VVV-NL
-
Spreadsheet: 0eb76dc4-6453-4ce0-a89b-3f4c79d3606f
Sheet: Table I.21

Table I.21 الجدول
Pilot Assets Accounts, Egypt, 2009 (MCM)
[NAME]، مصر، 2009 (مليون متر مكعب)
 |  | EA.131 Surface water |  |  |  | [NAME] | EA.133 Soil water | Total
 |  | EA.1311 [NAME] | EA.1312 Lakes | EA.1313 Rivers | EA.1314
 |  |  |  |  | Snow, Ice and [NAME]
1. Opening Stocks |  | 1500 | 2700 | 5000 | - | 100000 | 500 | 109700
Increases in stocks
 | 2. Returns from the economy | 300 | - | 53 |  | 15 | - | 230
 | 3. Precipitation | 275 | 430 | 230 | - | - | 22500 | 23435
 | 4. Inflows | 1054 | 339 | 20890 |  | 237 | - | 22520
 | 4.a. from upstream territories |  |  | 17650 |  |  |  | 17650
 | 4.b. from other resources in the territory | 1054 | 339 | 3240 | - | 237 | - | 4870
Decreases in stocks
 | 5. Abstraction | 300 | - | 141 |  | 1 | - | 266
 | 6. Evaporation/Actual evapotranspiration | 346 | 520 | 333 | - | - | 20125 | 21324
 | 7. Outflows | 1000 | 100 | 20773 | - | 87 | 2340 | 24300
 | 7.a to downstream territories |  |  | 9430 |  |  |  | 9430
 | 7.b to the sea | - | - | 10000 | - | - | - | 10000
 | 7.c to other resources in the territory | 1000 | 100 | 1343 | - | 87 | 2340 | 4870
8. Other changes in  volume |  |  |  |  |  |  |  | -
9. Closing Stocks |  | 1483 | 2849 | 4926 | - | 100164 | 535 | 109957
Source: | Technical Mission Report to Egypt, April 2010, ESCWA.
Spreadsheet: 780249d1652360762-return-blank-when-the-dates-from-to-are-not-within-those-dates-range-source
Sheet: Sheet1

 | From Date | To Date | Result
Missing Comp Plan Query | 2022-04-27 00:00:00 | 2022-05-06 00:00:00 | [NAME]
Payroll Wed through Maint Friday |  |  | [NAME] |  | 5/9 and 5/10 is not listed here, so I want the other spreadsheet to return the value of blank or n/a
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
Spreadsheet: scott_neal__37880__STOR9799
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9799
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-09-29 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 584 | 609
(TX, LA, OK, KS, MS)
Market Area - East |  | 1449 | 1499
Market Area - West |  | 369 | 372
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 271616d1382001568-first-planned-date-starting-from-today-firstplanneddatefromtoday-ans
Sheet: Sheet1

Today |  |  |  |  | 2013-10-15 00:00:00 |  |  |  | 2013-10-16 00:00:00 |  |  |  | 2013-10-17 00:00:00 |  |  |  | 2013-10-18 00:00:00 |  |  |  | 2013-10-19 00:00:00
Item | First planned qty date starting from today | Actual hours | Planned hours | Actual qty | Planned qty | Actual hours | Planned hours | Actual qty | Planned qty | Actual hours | Planned hours | Actual qty | Planned qty | Actual hours | Planned hours | Actual qty | Planned qty | Actual hours | Planned hours | Actual qty | Planned qty
A |  |  |  | 3 | 1
B |  |  |  | 5 | 5 |  |  |  |  |  |  |  | 1 |  |  |  | 2 |  |  |  | 4
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
D |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 1
 |  |  |  |  | [NAME] is used.
Spreadsheet: 3c7f8c52-bdb5-4d41-b50f-435f0e08c4ba
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
FEWHG | Test | FEWHG | Egg Whole IgG | Egg Whole IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FEWHG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FEWHG | Result | FEWHG | Egg Whole IgG | Egg Whole IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 558135d1516927839-keeping-certain-rows-sample_worksheet
Sheet: Sample

Student | Program | End Date
38723.78738117187 | ENGL | (blank)
 |  | 2012-05-25 00:00:00
 |  | 2012-05-29 00:00:00
 |  | 2013-05-31 00:00:00
 |  | 2013-12-19 00:00:00
 |  | 2014-04-11 00:00:00
 |  | 2014-05-30 00:00:00
 |  | 2014-12-04 00:00:00
 |  | 2015-01-23 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2016-12-16 00:00:00
 |  | 2017-04-28 00:00:00
57259.36172788506 | ENGL | (blank)
 |  | 2009-12-18 00:00:00
 |  | 2010-04-30 00:00:00
 |  | 2010-05-28 00:00:00
 |  | 2011-12-20 00:00:00
 |  | 2012-04-14 00:00:00
 |  | 2012-05-30 00:00:00
 |  | 2012-05-31 00:00:00
 |  | 2013-05-02 00:00:00
 |  | 2013-12-20 00:00:00
 |  | 2014-05-29 00:00:00
 |  | 2015-05-26 00:00:00
 |  | 2015-12-31 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2018-04-27 00:00:00
21639.51088136631 | ENGL | (blank)
 |  | 2011-10-05 00:00:00
 |  | 2012-05-31 00:00:00
 |  | 2013-05-31 00:00:00
 |  | 2014-04-11 00:00:00
 |  | 2015-05-29 00:00:00
 |  | 2015-12-18 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2017-04-28 00:00:00
 |  | 2017-12-15 00:00:00
 |  | 2018-04-13 00:00:00
29445.18754844943 | ENGL | (blank)
 |  | 2016-12-16 00:00:00
 |  | 2017-04-28 00:00:00
 |  | 2018-04-27 00:00:00
59025.70526420221 | ENGL | (blank)
 |  | 2010-04-30 00:00:00
 |  | 2011-05-27 00:00:00
 |  | 2011-12-17 00:00:00
 |  | 2012-12-20 00:00:00
 |  | 2013-05-02 00:00:00
 |  | 2013-05-31 00:00:00
 |  | 2013-12-20 00:00:00
 |  | 2014-05-29 00:00:00
 |  | 2014-10-23 00:00:00
 |  | 2014-12-19 00:00:00
 |  | 2015-05-23 00:00:00
 |  | 2015-12-18 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2017-04-28 00:00:00
 |  | 2017-12-22 00:00:00
23709.4832420479 | ENGL | (blank)
 |  | 2017-04-28 00:00:00
 |  | 2018-04-27 00:00:00
48612.38862284134 | ENGL | (blank)
 |  | 2013-05-02 00:00:00
 |  | 2014-05-29 00:00:00
 |  | 2015-05-26 00:00:00
 |  | 2016-01-07 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2016-11-02 00:00:00
 |  | 2017-12-22 00:00:00
70960.040603415 | ENGL | (blank)
 |  | 2009-09-25 00:00:00
 |  | 2010-04-30 00:00:00
 |  | 2011-12-20 00:00:00
 |  | 2013-05-02 00:00:00
 |  | 2014-02-12 00:00:00
 |  | 2014-05-29 00:00:00
 |  | 2014-09-19 00:00:00
 |  | 2014-10-23 00:00:00
 |  | 2015-05-26 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2016-12-16 00:00:00
 |  | 2017-12-22 00:00:00
 |  | 2018-04-27 00:00:00
58342.21411323348 | ENGL | (blank)
 |  | 2009-12-18 00:00:00
 |  | 2010-04-30 00:00:00
 |  | 2010-05-28 00:00:00
 |  | 2010-12-17 00:00:00
 |  | 2011-05-27 00:00:00
 |  | 2011-05-28 00:00:00
 |  | 2011-12-21 00:00:00
 |  | 2011-12-22 00:00:00
 |  | 2012-04-13 00:00:00
 |  | 2012-05-25 00:00:00
 |  | 2012-05-28 00:00:00
 |  | 2012-05-30 00:00:00
 |  | 2012-05-31 00:00:00
 |  | 2012-12-21 00:00:00
 |  | 2013-05-31 00:00:00
 |  | 2013-12-19 00:00:00
 |  | 2014-04-11 00:00:00
 |  | 2014-05-30 00:00:00
 |  | 2014-11-06 00:00:00
 |  | 2015-05-29 00:00:00
 |  | 2015-08-31 00:00:00
 |  | 2015-12-18 00:00:00
 |  | 2016-04-22 00:00:00
 |  | 2017-04-28 00:00:00
 |  | 2017-12-15 00:00:00
 |  | 2018-04-06 00:00:00
 |  | 2018-04-13 00:00:00