tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 090e2ff5-230a-4758-af6d-e5f00cd1ce64
Sheet: Capital Leases

WASHTENAW  COUNTY  CAPITAL  LEASE |  | IT Equipment
Payment Schedule
2012-12-31 00:00:00
 | ATT Phone System |  | Computer Equipment |  | Total
 | Principal | Interest | Principal | Interest | Principal | Interest
2013 | 23539.12 | 2246 | 312724 | 39752.68
2014 | 24830.12 | 955 | 325450.31 | 27026.69
2015 | 4268.52 | 29 | 338694.18 | 13782.82
Balance at 12-31-12
EMC #12926-11 computer equipment |  |  | Repayment Source:
Issuance Date | 2011-08-01 00:00:00 |  | Ad valorem property taxes
Issuance Amount | 1302837
12/31/12 Balance | 976868
ATT Phone System
Issuance Date | 2012-03-01 00:00:00 |  | Ad valorem property taxes
Issuance Amount | 71316.24
12/31/12 Balance | 52637.64
Spreadsheet: 46520d1245352017-pulling-detailed-data-from-one-sheet-to-another-sample-variance-tracking
Sheet: Employee Search

Employee: | Employee #6
Total NET:
Total ABS:
# of Variances:
Date | [NAME] | Comments
 |  | The comment would show up here.
Spreadsheet: 798923d1664814795-averaging-scores-in-2-tables-according-to-years-test-2
Sheet: Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores | Year
 |  |  |  |  |  |  |  |  |  | Scores | Year | Autumn | Summer |  |  | Score 1 | 2017-2018
 |  |  |  |  |  |  |  |  |  | Score 1 | 2017-2018 |  |  |  |  | Score 2 | 2018-2019
 |  |  |  |  |  |  |  |  |  | Score 2 | 2018-2019 |  |  |  |  |  | 2019-2020
 |  |  |  |  |  |  |  |  |  | Score 1 | 2019-2020 |  |  |  |  |  | 2020-2021
 |  |  |  |  |  |  |  |  |  | Score 2 | 2020-2021 |  |  |  |  |  | 2021-2022
 |  |  |  |  |  |  |  |  |  | Score 1 | 2021-2022 |  |  |  |  |  | 2022-2023
 |  |  |  |  |  |  |  |  |  | Score 2 | 2022-2023
Spreadsheet: 749840d1633041349-extract-or-filter-data-filter-cathrine-paul-
Sheet: Sheet1

Group no | Names | Quantity | filter data |  |  | Group no | Names | Quantity |  | Group No | Group Name | For Drop Downs |  |  |  |  |  |  |  | Group no | Names | Quantity | Result
045/001 | bakery | 1500 | 001_Bakery |  |  |  |  |  |  | 001 | Bakery |  |  |  |  |  |  |  |  | 045/001 | bakery | 1500
045/001001 | cakes | 120 | 002_vegetables and fruits |  |  |  |  |  |  | 002 | vegetables and fruits |  |  |  |  |  |  |  |  | 045/001001 | cakes | 120
045/001001001 | Dry fruits cake | 10 |  |  |  |  |  |  |  | 005 | Ice cream |  |  |  |  |  |  |  |  | 045/001001001 | Dry fruits cake | 10
045/001001002 | Fresh cakes | 14 |  |  |  |  |  |  |  | 008 | Milk |  |  |  |  |  |  |  |  | 045/001001002 | Fresh cakes | 14
045/001002 | Sweets | 1750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002 | Sweets | 1750
045/001002001 | Hand made | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002001 | Hand made | 20
045/001002004 | Sugar free | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002004 | Sugar free | 13
045/002 | vegetables and fruits | 4111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008 | Milk | 555
045/002001 | Veg | 12 |  |  |  |  |  |  |  |  | D2 = | Dropdown Data Validation List |  |  |  |  |  |  |  | 045/008001 | Cow | 710
045/002001004 | Capsicum | 17 |  |  |  |  |  |  |  |  | D2 = | Grou Number with GroupName |  |  |  |  |  |  |  | 045/008001003 | Bottle | 200
045/002001007 | Tomatto | 14 |  |  |  |  |  |  |  |  | D2 Example | 001_Bakery |  |  |  |  |  |  |  | 045/008001004 | cover | 476
045/002005 | fruits | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008003 | Goat | 320
045/002005001 | Apple | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008003002 | Bottle | 220
045/002005004 | Orange | 145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008005004 | cover | 11
045/005 | Ice cream | 125
045/005007 | bar | 10
045/005007002 | choco bar | 20
045/008 | Milk | 555
045/008001 | Cow | 710
045/008001003 | Bottle | 200
045/008001004 | cover | 476
045/008003 | Goat | 320
045/008003002 | Bottle | 220
045/008005004 | cover | 11
Spreadsheet: 692236d1598205873-if-formulas-with-multiple-criterias-and-vlookup-2020-08-23-oeldere-guigoz-692231d1598201770-if-formulas-with-multiple-criterias-and-vlookup-t
Sheet: table

0 | 0 |  |  | Shipment confirmed | 1
138 | 1 |  |  | Finance Approval | 0
139 | 0 |  |  | Logistic Picking | 0
289 | 1 |  |  | Legalization | 0
290 | 0 |  |  | Rejected | 1a
If the client is equal to 138 or 289 AND if the Status (column E) is not Rejected or Shipment confirmed then the result should be the QTY in column H (i have the formula for this scenario in my file column C)
Spreadsheet: 1a7feb7d-8a64-40c6-af52-34e8bb988a72
Sheet: Sheet1

SNP | Gene/Region | GAIN P-value | TGEN P-value | GAIN + TGEN P-value | Study
rs1006737 | CACNA1C | 0.236 | 0.878 | 0.447 | [3]
rs10994336* | ANK3 | 0.01 | 0.783 | 0.021 | [3]
rs1938526 | ANK3 | 0.036 | 0.978 | 0.107 | [3]
rs9804190 | ANK3 | 0.018 | 0.467 | 0.021 | [4]
rs2172835 | 15q14 | 0.057 | 0.558 | 0.255 | [3]
rs5907577 | Xq27.1 | 1.6 x 10-6 | 0.83 | 6.3 x 10-5 | [1]
rs10193871 | NAP5 | 9.8 x 10-6 | 0.611 | 0.001 | [1]
Spreadsheet: 799845d1665347895-counting-the-emails-that-match-another-column-while-so-matching-a-condition-in-another-example-question-etaf-
Sheet: Sheet1

email | source | date
[EMAIL] | mobile | 2020-05-05 00:00:00 |  |  | 2020-05-06 00:00:00 | 2020-05-07 00:00:00
[EMAIL] | computer | 2020-05-05 00:00:00
[EMAIL] | computer | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-07 00:00:00
[EMAIL] | computer | 2020-05-07 00:00:00
Spreadsheet: ecad6768-90a6-4021-aead-139f4cf882ee
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4097 | 7532 | Sinuhe | [NAME] | MEX | 0 | 00:08:00 | 00:00:28 | 00:14:45 | 00:00:36 | 00:09:39 | 1 | 00:33:28
4097 | 25034 | Tiago | Borges | BRA | 0 | 00:08:58 | 00:00:41 | 00:16:32 | [NAME] | [NAME] | 2 | 00:37:32
4097 | 17241 | [NAME] | Vargas | MEX | 0 | 00:08:23 | 00:00:31 | 00:19:13 | 00:00:48 | 00:11:04 | 3 | 00:39:59
4097 | 25187 | Ollin Tonatiuh | Caraza | MEX | 0 | 00:09:01 | 00:00:36 | 00:20:03 | 00:00:45 | 00:12:02 | 4 | 00:42:27
4097 | 25188 | Arturo | Herrera | MEX | 0 | 00:12:21 | 00:00:47 | 00:28:51 | 00:01:23 | 00:14:28 | 5 | 00:57:50
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: M200EQP

EQUIPMENT CALCULATIONS - M-200 GROWTH ADJUSTMENTS
SCHOOL WEIGHTED |  | 1992 |  | 1993 |  | 1994 | 1995 |  | 1996 |  | 1998 |  | 1999 | 2010 |  | 2012 |  |  | 2013
ENROLLMENTS |  | Actual |  | Actual |  | Actual | Actual |  | Actual |  | Actual |  | Actual | Actual |  | Projected |  |  | Projected
 |  | 204207 |  | 214997 |  | 227302 | 227302 |  | 255215.4 |  | 285990 |  | 300115.4
STUDENT | 1992 Actual | 1992 Cost | 1993 Actual | 1993 Cost | 1994 Actual | 1994 Cost | 1995 Actual | 1995 Cost | 1996 Cost | 1997 Actual | 1998 Cost | 1999 Cost | 2000 Cost |  |  | 2012 Annual |  |  | 2013 Annual
DRIVEN COST | Cost | Per Student | Cost | Per Student | Cost | Per Student | Cost | Per Student | Per Student | Cost | Per Student | Per Student | Per Student | Cost | Per Student | Cost | Cost | Per Student | Cost | Per Student
 | 16593615 | 81.25879622148115 | 7419491 | 34.50974199639995 | 10716595 | 47.14694547342302 | 13883778 | 61.08075599862737 | 34.08 | 13361131 | 71.78 | 17.25 | 50.6
 | 5287542 | 25.89304969956956 | 4255465 | 19.79313664841835 | 5639972 | 24.81268092669664 | 3729039 | 16.40565855117861 | 18.04 | 4282191 | 14.68 | 14.77 | 12.53
 |  |  |  |  |  | n/a | 1861383 | 8.189030452877669 | -1.01 | 3181182 | 6.91 | 6.6 | 9.54
 | 6419036 | 31.43396651437022 | 2974502 | 13.83508607096843 | 3302847 | 14.53065525160359 | 3124921 | 13.74788167284054 | 63.55 | 7077262 | 18.15 | 14.24 | 36.52
 | 28300193 |  | 14649458 |  | 19659414 |  | 22599121 |  |  | 27901766 | 111.52 | 52.86 | 109.19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net |  | Net
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary |  | Cost | Adj | Diff | Adj | Diff
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pupil Transportation
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructional Equip
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructional Hardware
 |  |  |  |  |  |  |  |  |  |  |  |  |  | All Other Equip
 |  |  |  |  |  |  |  | EX BUD RECOMMENDS
 |  |  |  |  |  |  |  | NET CHANGE
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg17

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Drip Zone 7 (S) |  | Field Name: |  | Drip Zone 8 (S) |  | Field Name: |  | Drip Zone 9 (S) |  | Field Name: |  | Drip Zone 10 (S)
 |  |  |  |  |  | Area (acres): |  | 12.3 |  | Area (acres): |  | 20.24 |  | Area (acres): |  | 16.04 |  | Area (acres): |  | 25.76
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 41.7 |  | Annual Rate (in): |  | 67.2 |  | Annual Rate (in): |  | 62.6 |  | Annual Rate (in): |  | 77.5
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 266673d1379695056-software-that-copies-sheets-efficiently-book2
Sheet: Raw Data

Employee | Sales | Profit
1 | 25 | 45
2 | 30 | 26
3 | 16 | 43
4 | 25 | 24
5 | 20.5 | 23
6 | 19.1 | 18.4
7 | 17.7 | 13.8
8 | 16.3 | 9.2
9 | 14.9 | 4.6
10 | 13.5 | 0
11 | 12.1 | -4.6
12 | 10.7 | -9.2
13 | 9.3 | -13.8
14 | 7.9 | -18.4
15 | 6.5 | -23
16 | 5.1 | -27.6
17 | 3.7 | -32.2
18 | 2.3 | -36.8
19 | 0.900000000000002 | -41.4
20 | -0.5 | -46
21 | -1.9 | -50.6
22 | -3.3 | -55.2
23 | -4.7 | -59.8
24 | -6.1 | -64.4
25 | -7.5 | -69
Spreadsheet: 207028d1358350132-need-help-consolidate-data-from-multi-workbooks-with-multi-worksheets-consolidate_printer
Sheet: Overall

User | Device | Department
May | Printer | Technology
[NAME] | Printer | Marketing
[NAME] | Printer | Technology
[NAME] | Printer | Marketing
[NAME] | Printer | Logistic
[NAME] | Printer | Technology |  |  | Pull data from all xls with worksheet (file1.xls, file2.xls, file3.xls, etc...) this consolidate file will just contain all information of printer (device)
Spreadsheet: lynn_blair__24414__NNGWKednotes
Sheet: August 18 & 19, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-08-18 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  | No difficulties with this process
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  | No difficulties with this process
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  | No difficulties with this process
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  | EDI was slow sending ping back to Northern Border, Called Help
 | 5:00 P.M. Intraday 2: |  |  | Desk
 |  |  |  | [NAME]
 | Gas Day: | SUN
 | 11:30 A.M. Timely
 | Gas Day: | SUN
 | 6:00 P.M. Evening |  |  | Desk.
 |  |  |  | [NAME]
 | Other Comments:
 | On Call Reps. |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT
 | 8:00 AM Final Storage
 | Gas Day: | SUN
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON
 | 11:30 A.M. Timely
 | Gas Day: | MON
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: 73677d1274290437-excel-2007-upper-or-lower-function-dummy-for-forum
Sheet: Sheet1

 |  |  | Update for | I went to bed around 1:00 am.  When I got up at 3:30 to use the bathroom, I was surprised
 |  |  | 4/27/10 | to find that was in pain.  I thought is was gone before I went to bed but now it was back or was it new?
 |  |  |  | It kept me awake until 4:30 and though it was gone I could not get back to sleep until at least
 |  |  |  | 6:00 am ( that was the last time I saw the clock)
 |  |  |  | I was under a lot of stress these next two days. (Kidney cancer)
 |  |  | 2010-05-03 00:00:00 | ATE TOAST AND ORANGE JUICE AT 11;30. While power washing deck I began to feel discomfort around 4:30.
 |  |  |  | By 6:15 I was in a lot of pain.  I laid down with heating pad and pain appeared to go away by around
 |  |  |  | 9:00 pm.  I went to sleep at 1:00 and woke at 4:40 and was surprised I was having pain.  Pain gone by 9:00 a.m.
 |  |  | 2010-05-04 00:00:00 | Ate spaghetti and meatballs at 6:00.  [NAME] something in next half hour - not pain or real discomfort just a feeling that something was about to happen.  Some pain later that night but not much.
 |  |  |  | that something was about to happen.  Some very light pain later ( I didn't note when it started)
 |  |  | 2010-05-06 00:00:00 | Worked very hard doing heavy duty cleaning of bathroom.  Finished at 7:40 p.m.
 |  |  |  | [NAME] very tired and had pain in back and knees.  Ate the rest of spaghetti and meatball and went to  lie down. |  |  |  |  |  |  |  |  | LIE DOWN | AS
 |  |  |  | I think I felt some pain coming on but fell asleep.  When I woke I had mild discomfort in stomach that lasted
 |  |  |  | a long time (at least until 12:30 - as I write this) and is still going on
 |  |  | 2010-05-08 00:00:00 | ate pizza and 2 chicken wings at 9:15. -  Pain started at 10:40 -  relatively mild it seems
 |  |  | 2010-05-14 00:00:00 | On ferry to NY ate french fries at 3:15 -  No problem
 |  |  | 2010-05-15 00:00:00 | On ferry back to CT - ate french fries at about 1:10 -  In pain by 3:05
 |  |  | 2010-05-18 00:00:00 | Ate ham sandwich on toast at 6:30.  At 11:40 I began to feel some discomfort
Spreadsheet: darrell_schoolcraft__7364__imball0201
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 30077 | 30013
2 | 30198 | 30013
3 | 30012 | 30013
4 | 28849 | 30013
5 | 29803 | 32012
6 | 29404 | 32012
7 | 29513 | 32012
8 | 29387 | 31955
9 | 31999 | 32012
10 | 33291 | 32013
11 | 35895 | 32013
12 | 33881 | 32013
13 | 34615 | 32013
14 | 33685 | 32013
15 | 25246 | 32013
16 | 37058 | 31127
17 | 36319 | 31127
18 | 32175 | 31127
19 | 30143 | 28727
20 | 27997 | 28727
21 | 27641 | 28727
22 | 27457 | 28727
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 85001.93
2002-01-22 00:00:00
CBS Volume
 |  |  | 54581
Spreadsheet: 60bc1196-be01-478e-b8f9-411d6756c69f
Sheet: BCMP GPA Calc

Hours | Grade | Qual Pts |  |  |  |  | Hours | Grade | Qual Pts |  |  |  |  | Cumulative BCMP GPA | Hours | Pts | GPA |  | Grades
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A- | 3.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B- | 2.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C+ | 2.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C- | 1.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D- | 0.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | 0
Spreadsheet: eric_saibi__9780__013102R
Sheet: Northside 01 

Owner Name |  | Jacsonville Electric Authority
Station Name |  | Northside [NAME]
Unit Name |  | Northside 01
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Coke
Capacity |  | 289 MW
Start Date |  | 2001-05-12 00:00:00
End Date |  | 2002-02-27 00:00:00
Prv. Start Date |  | 2001-05-12 00:00:00
Prv. End Date |  | 2002-03-07 00:00:00
Comments |  | Rebuild unit to change fuel supply  from fuel oil to coke.
SIC |  | 4911
Plant ID |  | 1021650
Unit ID |  | 1007149
Outage ID |  | 8044
Spreadsheet: ee55fa53-bcdc-4067-bdae-32696033fb43
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
FCELG | Test | FCELG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum 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
FCELG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCELG | Result | FCELG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Nov2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
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
2021-11-06 00:00:00
2021-11-07 00:00:00
2021-11-08 00:00:00
2021-11-09 00:00:00
2021-11-10 00:00:00
2021-11-11 00:00:00
2021-11-12 00:00:00
2021-11-13 00:00:00
2021-11-14 00:00:00
2021-11-15 00:00:00
2021-11-16 00:00:00
2021-11-17 00:00:00
2021-11-18 00:00:00
2021-11-19 00:00:00
2021-11-20 00:00:00
2021-11-21 00:00:00
2021-11-22 00:00:00
2021-11-23 00:00:00
2021-11-24 00:00:00
2021-11-25 00:00:00
2021-11-26 00:00:00
2021-11-27 00:00:00
2021-11-28 00:00:00
2021-11-29 00:00:00
2021-11-30 00:00:00
Totals:
Spreadsheet: 268650d1380724475-function-to-flag-non-alphanumeric-characters-in-a-text-string-958682b
Sheet: Sheet1

Test é
Test ü |  |  |  |  |  |  |  |  | _x0002__x0003__x0004__x0005__x0006__x0007__x0008__x000B__x000C__x000E__x000F__x0010__x0011__x0012__x0013__x0014__x0015__x0016__x0017__x0018__x0019__x001A__x001B_!"#$%'()*+,-./:;<=>?@[\]^`{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ¡¢£¤¥[NAME]©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ
Test etc a
characters like a,
test <>/|;:'.,
clean text
z
False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | True | False | False | False | False | False | False | False | False | False | False | True | False | False | False | False | False | False | False | False | False | True | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False
Spreadsheet: 818545d1676906623-or-function-in-table-format-doesnt-work-example-with-scenario3-final-ans2
Sheet: Sheet1

 | (Worked) Scenario1: Indicator =1
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Worked) Scenario2: Indicator =1 or Indicator [NAME]
 |  |  |  |  |  | Expected: |  |  |  | [NAME] (Worked and THANK YOU!)
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | -1 |  | 11111 | 123456 | -1 |  |  | 123456 | -1
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | Scenario3:
 |  |  |  |  |  |  |  |  |  | [NAME] (Worked!)
 |  | Transit | GL | Indicator |  |  |  |  |  | Transit | GL | Indicator
 |  | 11111 | 123456 | 0 |  |  |  |  |  |  | 12123123
 |  | 22222 | 2222214 | 0 |  |  |  |  |  | 44444 | 16822598
 |  | 33333 | 12123123
 |  | 44444 | 16822598
 |  |  |  |  |  |  |  |  |  | If nothing
 |  |  |  |  |  |  |  |  |  | If has 1 or -1
 |  |  |  |  |  |  |  |  |  | If 0 (previously 2)