tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153220d1335807877-basic-question-pivot-table-div-0-issue-excel-2010-example_pivot
Sheet: Data

User ID | Event
132234 | Purchase Item 2
132234 | Purchase Item 1
143597 | Purchase Item 2
143597 | Purchase Item 1
144327 | Purchase Item 3
145233 | Purchase Item 2
145233 | Purchase Item 1
147964 | Purchase Item 2
147964 | Purchase Item 1
154791 | Purchase Item 2
154791 | Purchase Item 1
161493 | Purchase Item 3
164645 | Purchase Item 1
164645 | Purchase Item 2
164645 | Purchase Item 1
164869 | Purchase Item 2
164869 | Purchase Item 1
169380 | Purchase Item 2
169380 | Purchase Item 1
196711 | Purchase Item 3
202096 | Purchase Item 1
202096 | Purchase Item 3
207159 | Purchase Item 3
230447 | Purchase Item 3
232592 | Purchase Item 2
232592 | Purchase Item 1
245051 | Purchase Item 3
248191 | Purchase Item 2
248191 | Purchase Item 1
249369 | Purchase Item 3
250486 | Purchase Item 3
263761 | Purchase Item 1
263761 | Purchase Item 3
274111 | Purchase Item 1
274111 | Purchase Item 3
278655 | Purchase Item 2
278655 | Purchase Item 1
282928 | Purchase Item 2
282928 | Purchase Item 1
285264 | Purchase Item 2
285264 | Purchase Item 1
292522 | Purchase Item 3
309062 | Purchase Item 1
309062 | Purchase Item 2
309062 | Purchase Item 1
347426 | Purchase Item 1
347426 | Purchase Item 2
347426 | Purchase Item 1
347690 | Purchase Item 3
348551 | Purchase Item 2
348551 | Purchase Item 1
355570 | Purchase Item 2
355570 | Purchase Item 1
355786 | Purchase Item 1
355786 | Purchase Item 2
355786 | Purchase Item 1
360590 | Purchase Item 3
362670 | Purchase Item 1
362670 | Purchase Item 2
362670 | Purchase Item 1
367911 | Purchase Item 1
367911 | Purchase Item 2
367911 | Purchase Item 1
380615 | Purchase Item 3
383174 | Purchase Item 3
389549 | Purchase Item 3
395665 | Purchase Item 1
395665 | Purchase Item 3
407737 | Purchase Item 2
407737 | Purchase Item 1
Spreadsheet: 700727d1603306110-unique-alphabetical-order-order-4
Sheet: Foglio1

ID | Stato | Anno | YES | 2020
Fami.1 | YES | 2017
Fami.2 | YES | 2017
Fami.3 | YES | 2017
Fami.3 | YES | 2017
Fami.1 | YES | 2017
Fami.1 | YES | 2017
Fami.4 | YES | 2017
Fami.2 | YES | 2017
Fami.1 | YES | 2017
Fami.6 | YES | 2018
Fami.4 | YES | 2018
Fami.6 | NO | 2018
Fami.6 | YES | 2018
!Altro | YES | 2018
Fami.2 | NO | 2018
Fami.1 | YES | 2018
Fami.3 | NO | 2018
Fami.6 | YES | 2018
Fami.7 | YES | 2018
Fami.7 | YES | 2018
Fami.7 | YES | 2018
Fami.5 | YES | 2018
Fami.5 | YES | 2019
Fami.5 | YES | 2019
Fami.5 | YES | 2019
Fami.5 | YES | 2019
[NAME] | YES | 2019
Fami.2 | YES | 2019
[NAME] | YES | 2019
Fami.9 | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
Fami.6 | YES | 2019
Fami.6 | YES | 2019
Fami.6 | YES | 2019
Fami.2 | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
Fami.7,2 | YES | 2020
Fami.4 | NO | 2020
Fami.7,2 | NO | 2020
[NAME] | NO | 2020
[NAME] | YES | 2020
Fami.9 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
[NAME] | YES | 2020
[NAME] | NO | 2020
Fami.7,2 | NO | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
Fami.10 | BO | 2020
Fami.10 | YES | 2020
Fami.2 | YES | 2020
Fami.3 | YES | 2020
[NAME] | YES | 2020
Fami.4 | NO | 2020
Fami.7 | YES | 2020
Fami.10 | YES | 2020
Fami.10 | YES | 2020
Fami.10 | NO | 2020
Fami.4 | YES | 2020
Fami.2 | YES | 2020
Fami.4 | YES | 2020
Fami.7,2 | YES | 2020
Spreadsheet: 138548d1327704962-help-with-nested-ifs-mgd_finals
Sheet: Round 4

 | Team | Bowler | Game 10 | Game 11 | Game 12 | Series
 | 2 | Damon Peratt
 |  | [NAME]
 |  | Team Total
Match 10 |  | Bonus
 |  | Total w/Bonus
 | 4 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 9 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 3 | CR Black
 |  | [NAME]
 |  | Team Total
Match 11 |  | Bonus
 |  | Total w/Bonus
 | 5 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 7 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 1 | [NAME]
 |  | [NAME]
 |  | Team Total
Match 12 |  | Bonus
 |  | Total w/Bonus
 | 6 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 8 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
Spreadsheet: 240698d1370397876-trying-to-clear-contents-of-a-range-of-contiguous-cells-taking-a-very-long-time-example-of-slow-clear-contents5
Sheet: Source link sheet

 | EQUIPMENT IDENTIFY HOURS BY EQUIP TYPE AND MOB. SET |  |  |  |  |  |  |  |  |  |  |  | 0 | 23 | 277 | KJ
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIOD | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LENGTH | Month
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | PERIOD NAME | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR | 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 7x7*12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCTIVITY | 1
 |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  | CALENDAR HOURS | 744
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HALF | H1 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QTR | Q1 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Equipment Types | Equipment Type Count | Mobil Search Group | Row number | Mobil Column number | Equipment Life for Replacement (Operating Hours) | Demob Search Group | Demob Column number | Number of units | Start row within array | Demob column ID | AFTER Demob column ID | Number of units to demob in period |  |  |  |  | _______ | 1
Spreadsheet: 826289d1681914967-hide-null-or-zero-values-2023-discard-report-tms
Sheet: RBC Outdates

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total from Discards Report for RBC plus WB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J21 | F | M | A | M | J | J | A | S | O | N | D | J22 | F | M | A | M | J | J | A | S | O | N | D | J23 | F | M | A | M | J | J | A | S | O | N | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 11 | 3 | 1 | 3 | 0 | 6 | 31 | 18 | 33 | 5 | 9 | 6 | 4 | 9 | 16 | 24 | 14 | 3 | 6 | 14 | 2 | 1 | 35 | 6 | 8 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | F | M | A | M | J | J | A | S | O | N | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1637 | 1437 | 1899
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dnrMonths | ='RBC Outdates'!$P$7:INDEX('RBC Outdates'!$7:$7,COUNTA('RBC Outdates'!$P$8:$AZ$8)+COLUMN('RBC Outdates'!$O$8))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dnrValues | ='RBC Outdates'!$P$8:INDEX('RBC Outdates'!$8:$8,COUNTA('RBC Outdates'!$P$8:$AZ$8)+COLUMN('RBC Outdates'!$O$8))
 |  | J | F | M | A | M | J | J | A | S | O | N | D
# of RBC Outdates
Total # [NAME] Collected
Monthly % RBC Outdate
Quarterly % RBC Outdate
Yearly % RBC Outdate
Spreadsheet: e212f8b4-f8cb-4dcb-91e7-f87173ec7084
Sheet: Sheet1

Upstate NY Chapter of US Lacrosse | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Hall of Fame Application
The Upstate NY Chapter of US Lacrosse is accepting nominations for individuals or teams who represent the very best in Men's & Women's Lacrosse.  The categories and criteria for induction are listed below.
Nominee: |  |  |  |  |  | Category:
Your Name: |  |  |  |  |  | Your Address:
Your Email:
Your Phone #:
A list of the current Inductees into the Upstate NY Chapter Hall of Fame can be found by copying and pasting the following link into an internet search engine; http://apps.uslacrosse.org/museum/halloffame/chapter_details.php?chap_id=17
Criteria: Nominees must have Played, Officiated or performed service for the sport of Lacrosse within the Upstate Chapter boundaries for a minimum of four years.
A Truly Great Player:
A Truly Great Coach:
A Truly Great Official:
A truly great Contributor to the game. An individual who has demonstrated long, dedicated and exceptional service and contribution to the game:
Please list any other other contribution or experience that makes the nominated individual or team worthy of this award:
Please list the names of two additional individuals who would be willing to submit a letter of support for the nominee name in this application.
Name of Nominator: |  |  |  |  |  |  |  |  | Date:
Please note that this form can be filled out electronically using Microsoft Excel
This form can be submitted electronically through the website, emailed to the President of the Upstate NY Chapter or mailed to; Upstate NY Chapter, 107 Stonehedge Road, Camillus, NY 13031
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, January 25 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 678055d1589693590-create-mail-labels-from-cell-string-example1704
Sheet: Sheet1 (3)

Original Data
114  Petworth RdDurranFalkirkKW14 7NB
40  Carriers RoadCrickardarnDundeeLD2 5NS
100  Circle WayCaergwrleWrexhamLL12 2EL
29  Newgate StreetJack HillMontroseLS22 3RE
25  Nith StreetGlascorieGlasgowAM351FZ
Spreadsheet: 582441d1531884238-how-to-populate-names-from-one-tab-into-another-tab-rsvp-tracker
Sheet: RSVP Bride

Last Name | First Name 1 | First Name 2 | Child Name 1 | Child Name 2 | Child Name 3 | # Adults Invited Sangeet | # Adults Attending Sangeet | # Adults Invited Wedding | # Adults Attending Wedding | # Adults Invited Reception | # Adults Attending Reception | # of Kids Invited Sangeet | # of Kids Attending Sangeet | # of Kids Invited Wedding | # of Kids Attending Wedding | # of Kids Invited Reception | # of Kids Attending Reception | Contact Email | Contact Phone Number | Contact Address 1 | Contact Address 2 | City | State | Zip | Table # |  |  |  | HELPER COLUMNS
Smith | [NAME] | [NAME] | Duke | Camden |  | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | [EMAIL] | [PHONE] | 1234 Main Street | #4 | [NAME] | TX | 78729 | 1
[NAME] | Amit | Seetha |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | [EMAIL] | [PHONE] | 2 Crossroads |  | Lansing | MI | 20000 | 2
Desai | Varun |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Tarulatta | Veneet | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Rigsby | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] | [NAME] | [NAME] | [NAME] | Hadley | Shane |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 586652d1534499049-fuel-use-and-optimal-re-fueling-stints-race-track-calculations-pw_strat
Sheet: Baend

 |  |  |  |  |  | TRACK 01 |  |  | NOTES & INFO
 |  |  |  |  | Total Laps | 62 |  |  |  |  | instances
 |  |  |  |  | Fuel Range (per lap/litres max & min) | 2.9 | 5.3 |  |  | >>
 |  |  |  |  | [NAME] (l) | 200 |  |  |  | https://superuser.com/questions/362349/find-combination-of-values-with-sum-closest-to-number/362350
 |  |  |  |  |  |  |  |  |  | Number combinations
 |  |  |  |  | Avg. fuel required (Tank / Laps)
 |  |  |  |  | Total Pitstop Time (s) | 25
 |  | DRIVING INTENSITY
 |  | Save | Easy | Nrml | Push | Risk
ENGINE MODE | 1 | 2.9 | 2.8 | 2.9 | 3 | 3.1
 | 2 | 3.7 | 3.7 | 3.9 | 3.9 | 4
 | 3 | 4.3 | 4.4 | 4.5 | 4.7 | 4.7 | Fuel Use (per lap/litres)
 | 4 | 4.6 | 4.7 | 4.8 | 4.9 | 5
 | 5 | 5 | 5.1 | 5.2 | 5.3 | 5.3
 |  | Stint (5 laps) |  | Stint Time (s) |  | Avg. Lap Time (s) |  | Fuel Used (lap)
COMBINATION  (ENGINE + INTENSITY) |  | Nrml / 2 |  | 450 |  | 90
 |  | Nrml / 3 |  | 400 |  | 80
 |  | Nrml / 4 |  | 350 |  | 70
 |  | Nrml / 5 |  | 250 |  | 50
 |  | Push / 2 |  | 400 |  | 80
 |  | Push / 3 |  | 350 |  | 70
 |  | Push / 4 |  | 250 |  | 50
 |  | Push / 5 |  | 200 |  | 40
 |  | *Total of 25 combination pairs, but this example selects just 8 pairs shown in yellow with indicative lap times)
Stops | 1
Stints | 2
Split
Stint
IN (Lap)
Stops | 2
Stints | 3
Split
Stint
IN (Lap)
Stops | 3
Stints | 4
Split
Stint |  |  | 16
IN (Lap)
 | 4
Stints | 5
Split
Stint
IN (Lap)
 |  |  |  |  |  | MODE | Save | Easy | Nrml | Push | Risk
 |  |  |  |  |  | 1 | 2.9 | 2.8 | 2.9 | 3 | 3.1
 |  |  |  |  |  | 2 | 3.7 | 3.7 | 3.9 | 3.9 | 4
 |  |  |  |  |  | 3 | 4.3 | 4.4 | 4.5 | 4.7 | 4.7
 |  |  |  |  |  | 4 | 4.6 | 4.7 | 4.8 | 4.9 | 5
 |  |  |  |  |  | 5 | 5 | 5.1 | 5.2 | 5.3 | 5.3
Spreadsheet: 647760d1572613388-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample-gk-final
Sheet: Sheet1

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 119 |  |  | Cont1 | 450 | 305 | 430
2 | 400 | 300 | 220 |  |  | Cont2 | 800 | 500 | 135
3 | 200 | 150 | 420 |  |  | Cont3 | 600 | 402 | 250
 |  |  |  |  |  | Cont4 | 250 | 200 | 175
 |  | DON'T KNOW HOW TO GET WORKING
 | MOCKUP: | For ID 1
 | Length 600 matches: |  | Cont2 |  | CLOSEST MATCH |  |  | ANSWER:
 |  |  | Cont3 |  | Cont3 |  |  | Cont3
 | [NAME] 400 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont3
 | Depth 119 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont2
Spreadsheet: 174857d1345216237-stoked-bar-excel-q-2010
Sheet: Sheet2

יעח
0
3
5
1
5
0
9
0 |  |  | [NAME] | 42
0 |  |  | תלונה 1 | 31
0 |  |  | בין 2-3 תלונות | 45
3 |  |  | בין 4-5 תלונות | 17
5 |  |  | מעל 5 תלונות | 12
3
2
3
3
4
7
2
7
4
0 |  |  | בין 4-5 תלונות
7
10
8
3
2
6
4
0 |  |  | מעל 5 תלונות
0
1
0
8
2
0
1
3
5
1
2
3
1
4
5
1
0
0
2
1
1
0
3
6
3
0
1
1
0
0
3
8
4
5
1
0
0
0
6
8
2
1
0
0
0
2
0
0
10
7
10
10
0
0
0
0
0
0
0
0
0
10
9
8
6
3
2
9
2
8
0
5
5
3
5
3
3
0
1
2
1
2
1
2
1
1
3
0
0
2
0
2
3
2
4
2
3
9
2
5
4
0
3
3
0
3
3
1
2
2
2
Spreadsheet: 700952d1603429483-index-and-match-with-array-index-match
Sheet: Sheet1

Input | Input | Output
Division | City | All Cities
Dhaka | D1 | D1, D2, D3, D4, D5
[NAME] | R1 | R1, R2, R3, R4, R5, R6, R7
Chittagong | C1 | C1, C2, [NAME], C4, C5
Khulna | K1 | K1, K2, K3, K4, K5
Dhaka | D2 | D1, D2, D3, D4, D5
Chittagong | C2 | C1, C2, [NAME], C4, C5
[NAME] | R2 | R1, R2, R3, R4, R5, R6, R7
Khulna | K2 | K1, K2, K3, K4, K5
Chittagong | [NAME] | C1, C2, [NAME], C4, C5
Khulna | K3 | K1, K2, K3, K4, K5
Dhaka | D3 | D1, D2, D3, D4, D5
[NAME] | R4 | R1, R2, R3, R4, R5, R6, R7
Dhaka | D4 | D1, D2, D3, D4, D5
[NAME] | R5 | R1, R2, R3, R4, R5, R6, R7
[NAME] | R6 | R1, R2, R3, R4, R5, R6, R7
Chittagong | C4 | C1, C2, [NAME], C4, C5
Khulna | K4 | K1, K2, K3, K4, K5
Dhaka | D5 | D1, D2, D3, D4, D5
[NAME] | R7 | R1, R2, R3, R4, R5, R6, R7
Chittagong | C5 | C1, C2, [NAME], C4, C5
Khulna | K5 | K1, K2, K3, K4, K5
Spreadsheet: 885348d1734855479-all-rows-matching-column-including-blanks-true-if-not-false-and-link-to-empty-cell-excel_validation
Sheet: Sheet2

1 | 2 | 3 | 4 | 5 | 6
777999 | A99SV1115555 | A99SV1115555 | A99SV1115555
536489 | [NAME] |  | [NAME]
1549976 | A99SV555997 | A99SV555997 | A99SV555997
33366497 | A99SV679137 |  | A99SV679137
33366497 |  | A99SV445998
22224499 | A99SV22256 | A99SV22256
Spreadsheet: 376538d1423635202-assistance-in-linking-cells-into-several-worksheet-full-price-list-sample
Sheet: BERGEN

Address : 60 Benoi Road F2 #02-11, SINGAPORE (629906)
Telephone : (65) 6265 8662            Fax : (65) 6265 7616
E-mail : [EMAIL]                 GST Reg No. 200708233N
No | IMPA No | ITEM | [NAME] | UNIT | BERGEN | Remark
Spreadsheet: 735600d1623088902-trouble-with-countifs-hlookup-formula-teaching-evaluation-sample
Sheet: Summary

 | The Teacher outlined learning objectives |  |  |  | The teacher provided support completing assignments |  |  |  | The instructor makes every effort to answer questions adequately
Teacher | Strongly Disagree | Moderately Disagree | Moderately Agree | Strongly Agree | Strongly Disagree | Moderately Disagree | Moderately Agree | Strongly Agree | Strongly Disagree | Moderately Disagree | Moderately Agree | Strongly Agree
[NAME] | [NAME] to ount total number of "Strongly Disagree" For A.Miller for the creiteria "The Teacher Outlined learning objectives" on the "Data" tab
[NAME]
[NAME]
Spreadsheet: 800294d1665583832-formula-to-count-if-one-or-more-criteria-are-met-test-fop
Sheet: SAMPLE (4)

 |  |  |  |  | Test Date: |  | 2022-10-02 00:00:00
 | Contractor: |  |  |  | Operator Name:
 | Instrument Mfg. |  |  |  | CEI:
 | Model: | 3640 |  |  | CEI Name:
 | Serial # | 188778QEDV |  |  | Station: |  | 240005 |  |  | Direction: |  |  | SB
 | Calibration Date: | 2018-10-31 00:00:00 |  |  | Device: |  | CCTV
 | Test Conditions
 |  | Soil Condition: |  |  | Moist |  | Dry |  | Temperature |  | F
 |  |  |  |  | Clay |  | Limestone |  | Sand & Gravel
 |  | Soil Type: |  |  | Granite |  | Shale |  | Sandstone
 |  | (choose one) |  |  | [NAME] |  | Slate |  | Other | SOD/Dirt
 |  |  |  |  | Single Rod |  | [NAME] | 20
 |  | Grounding System: |  |  | [NAME] (Grid)
 |  |  |  |  | Longest Diagonal Distance
 | Z Electrode
 | Minimum Distance: |  | 320
 | Y Electrode Distance |  | Measured Resistance | Percentage Difference
 | % | Feet | Ohms
 | 10 |  | 0
 | 20
 | 30
 | 40
 | 52 |  | 5.6
 | 62 |  | 5.7
 | 72 |  | 5.8
 | 80
 | 90 |  | 15
 |  |  |  |  | Effective Grounding Electrode Resistance: |  |  | Ohms
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 7. HCV

 |  | HCV test results |  |  |  |  | HCV test results | 0
 |  |  |  |  |  |  | NAT only positives*****
 |  | HCV test results |  |  |  |  | Donations from first time tested donors**, number | 0
 |  |  |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | NAT only positives during the indicated year***** |  |  |  |  | Total number of donations tested by NAT since its introduction† | 0
 |  | Donations from first time tested donors**, number |  |  |  |  | NAT only positives***** since introduction of NAT testing†
 |  |  |  |  |  |  | Donations from first time tested donors**, number† | 0
 |  | Donations from repeat tested donors***, number |  |  |  |  | Donations from repeat tested donors***, number† | 0
 |  | Total number of donations tested by NAT since its introduction†
 |  | NAT only positives***** since introduction of NAT testing†
 |  | Donations from first time tested donors**, number†
 |  | Donations from repeat tested donors***, number†
 |  | **         Donations from first time tested donors: From a person who was tested for the first time
 |  | without report of prior serological testing in the blood establishment.
 |  | ***       Donations from repeat tested donors:
 |  | From a donor who has been subjected to previous serological testing in a given blood establishment.
 |  | *****   NAT only positives: Positive in a NAT assay not found seropositive for that virus in serological screening
 |  | plus shown to be true positive by separate PCR or later serology.
 |  | †           Please provide data also for all previous years in which HCV NAT has been performed.
 |  |  |  | Page 20 of 34
Spreadsheet: 726932d1617613283-match-codes-from-file-master-code-list-with-added-weeks
Sheet: Wk11 before Sweep saving

 | 555933 SPM | WASH
 | 050001 T02505 | WASH
 | 554761 SPM | WASH
 | 050001 T03912 | WASH
 | 585309 1SPM | WASH
 | 585309 10SPM | WASH
 | 513063 3CB | WASH
 | 513158 CB | WASH
 | 513155 CB | WASH
 | 589798 8CB | WASH
 | 513153 CB | WASH
 | 555656 CB | WASH
 | 513111 CBK | WASH
 | 513111 CB | WASH
 | 050001 34616996 | WASH
 | 534199 65SPM | WASH
 | 534199 2SPM | WASH
 | 534199 SPM | WASH
 | 522631 SPMK | WASH
 | 050001 T12533 | WASH
 | 510404 SPM | WASH
 | 508053 SPM | WASH
 | 589411 CB | WASH
 | 522870 CB | WASH
 | 589399 CB | WASH
 | 548168 CB | WASH
 | 589372 CBT | WASH
 | 588261 CB | WASH
 | 579375 CB | WASH
 | 513310 CB | WASH
 | 555567 CB | WASH
 | 554818 CB | WASH
 | 589559 CB | WASH
 | 585270 10SPM | WASH
 | 871022 SPM | WASH
 | 513287 1CB | WASH
 | 521556 CB | WASH
 | 589122 SPM | WASH
 | 513609 CB | WASH
 | 554251 2CB | WASH
Spreadsheet: 848479d1699211508-i-am-trying-to-grant-tickets-for-certain-criteria-met-sample
Sheet: TOTAL

freeroll | Card Number | Name | 2023-10-21 00:00:00 | 2023-10-22 00:00:00 | 2023-10-23 00:00:00 | 2023-10-24 00:00:00 | 2023-10-25 00:00:00 | 2023-10-26 00:00:00 | 2023-10-27 00:00:00 | 2023-10-28 00:00:00 | 2023-10-29 00:00:00 | 2023-10-30 00:00:00 |  | TOTAL TH |  |  | TOTAL PLO |  |  | PLO*1
 |  |  |  | 4:00:00 | 7:30:00 |  |  | 2:15:00 | 1:30:00
 |  |  |  | 1:00:00 | 6:30:00 | 5:00:00 |  | 10:00:00 | 9:30:00 | 2:00:00
 |  |  |  |  |  |  |  | 4:30:00 |  | 2:00:00 | 5:00:00
 |  |  | 2:00:00 | 3:00:00 |  |  |  | 5:00:00 | 5:00:00 | 1:00:00 | 2:45:00
 |  |  | 2:00:00 |  |  |  | 2:00:00
 |  |  | 2:00:00 |  |  |  | 2:00:00 |  |  | 1:30:00
 |  |  | 2:00:00 | 4:00:00 | 10:30:00 |  |  | 2:00:00 | 9:30:00 | 7:00:00
yes |  |  |  | 2:00:00 | 1:30:00 |  |  | 10:00:00 | 4:00:00
 |  |  |  | 3:00:00
 |  |  | 2:00:00
 |  |  | 2:00:00 |  |  | 7:00:00 | 7:00:00 | 9:00:00 |  | 2:30:00 | 20:00:00
 |  |  | 2:00:00 |  | 6:00:00 | 7:00:00 | 7:00:00 | 10:00:00 |  | 7:00:00 | 4:30:00
 |  |  |  | 1:00:00
 |  |  |  | 2:00:00
 |  |  | 2:00:00 |  | 1:00:00 |  |  | 9:00:00 |  | 8:00:00 | 20:00:00
 |  |  |  |  | 6:00:00 |  | 0:30:00 | 2:30:00 |  |  | 1:00:00
 |  |  |  |  | 6:00:00
 |  |  |  |  | 6:00:00 |  |  | 2:30:00 |  |  | 1:00:00
 |  |  |  |  | 9:30:00 | 7:00:00 | 7:00:00 |  |  | 2:00:00
 |  |  |  |  | 6:00:00 |  |  |  | 9:30:00 | 8:00:00 | 3:30:00
 |  |  |  |  | 10:30:00 | 7:00:00 | 7:00:00 | 10:00:00 |  |  | 21:30:00
 |  |  |  |  | 9:30:00 | 7:00:00 | 7:00:00 | 10:00:00 | 9:30:00 | 6:30:00 | 3:00:00
 |  |  |  |  | 5:00:00 |  | 0:00:00
 |  |  |  |  | 3:00:00 |  |  |  | 1:30:00
 |  |  |  |  |  |  | 7:00:00 | 2:00:00 | 9:30:00 |  | 4:00:00
 |  |  |  |  |  |  | 7:00:00 |  | 9:30:00 |  | 20:00:00
 |  |  |  |  |  |  | 3:30:00
 |  |  |  |  |  |  |  | 10:00:00 |  |  | 21:00:00
 |  |  |  |  |  |  |  |  | 9:30:00 | 4:00:00 | 21:30:00
 |  |  |  |  |  |  |  |  |  | 6:00:00 | 3:00:00
 |  |  |  |  |  |  |  |  |  | 5:00:00
 |  |  |  |  |  |  |  |  |  | 8:00:00 | 20:00:00
 |  |  |  |  |  |  |  |  |  |  | 4:30:00
 |  |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  |  | 21:30:00
 |  |  |  |  |  |  |  |  |  |  | 1:30:00
Spreadsheet: 214755d1361109490-ref-error-for-no-apparent-reason-test-book1
Sheet: ctrange

range1 | range2 | Ct
0.26 | 0.35 | 1/3
0.36 | 0.44 | 2/5
0.45 | 0.57 | 1/2
0.58 | 0.67 | 5/8
0.68 | 0.79 | 3/4
0.8 | 0.94 | 7/8
0.95 | 1.1 | 1(0.95-1.10)
1.11 | 1.19 | 1 1/16
1.2 | 1.29 | 1 1/4
1.3 | 1.44 | 1 1/3
1.45 | 1.55 | 1 1/2
1.55 | 1.66 | 1 3/5
1.67 | 1.89 | 1 3/4
1.9 | 1.94 | 1 7/8
1.95 | 2.1 | 2
2.11 | 100