tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 721832d1614881582-formula-average-that-automatically-calculates-and-updates-example-3
Sheet: Sheet2

 |  |  | Service Type |  |  |  |  |  | Average for Total Services By Day
Day | Date | Shift | Delivery | Pickup | Return | Cancel |  |  |  | Delivery | Pickup | Return | Cancel | Total Svs
Monday | 2021-02-01 00:00:00 | Day | 1 | 1 | 0 | 0 |  |  | Monday
Monday | 2021-02-01 00:00:00 | Day | 0 | 2 | 0 | 0 |  |  | Tuesday
Monday | 2021-02-01 00:00:00 | Swing | 0 | 0 | 0 | 1 |  |  | Wednesday
Tuesday | 2021-02-02 00:00:00 | Swing | 3 | 2 | 0 | 0 |  |  | Thursday
Tuesday | 2021-02-02 00:00:00 | Night | 0 | 2 | 1 | 0 |  |  | Friday
Tuesday | 2021-02-02 00:00:00 | Night | 1 | 0 | 0 | 0 |  |  | Saturday
Wednesday | 2021-02-03 00:00:00 | Day | 0 | 1 | 0 | 0
Wednesday | 2021-02-03 00:00:00 | Day | 0 | 3 | 1 | 0
Wednesday | 2021-02-03 00:00:00 | Swing | 3 | 1 | 0 | 1
Thursday | 2021-02-04 00:00:00 | Swing | 0 | 3 | 0 | 0
Thursday | 2021-02-04 00:00:00 | Night | 0 | 4 | 1 | 0
Thursday | 2021-02-04 00:00:00 | Day | 2 | 2 | 0 | 0
Friday | 2021-02-05 00:00:00 | Day | 0 | 0 | 0 | 0
Friday | 2021-02-05 00:00:00 | Swing | 2 | 3 | 2 | 1
Friday | 2021-02-05 00:00:00 | Swing | 2 | 0 | 0 | 0
Saturday | 2021-02-06 00:00:00 | Night | 1 | 0 | 3 | 0
Saturday | 2021-02-06 00:00:00 | Day | 2 | 3 | 0 | 0
Saturday | 2021-02-06 00:00:00 | Day | 0 | 2 | 0 | 0
Sunday | 2021-02-07 00:00:00 | Swing | 1 | 2 | 1 | 0
Sunday | 2021-02-07 00:00:00 | Swing | 3 | 4 | 0 | 1
Sunday | 2021-02-07 00:00:00 | Night | 3 | 0 | 1 | 0
Monday | 2021-02-08 00:00:00 | Day | 5 | 1 | 2 | 0
Monday | 2021-02-08 00:00:00 | Day | 6 | 1 | 2 | 0
Monday | 2021-02-08 00:00:00 | Swing | 1 | 5 | 1 | 0
Tuesday | 2021-02-09 00:00:00 | Swing | 1 | 5 | 0 | 1
Tuesday | 2021-02-09 00:00:00 | Night | 0 | 0 | 0 | 0
Tuesday | 2021-02-09 00:00:00 | Night | 3 | 1 | 1 | 0
Wednesday | 2021-02-10 00:00:00 | Day | 1 | 0 | 1 | 1
Wednesday | 2021-02-10 00:00:00 | Day | 1 | 1 | 0 | 0
Wednesday | 2021-02-10 00:00:00 | Swing | 1 | 3 | 1 | 1
Thursday | 2021-02-11 00:00:00 | Swing | 1 | 2 | 2 | 1
Thursday | 2021-02-11 00:00:00 | Night | 2 | 1 | 0 | 0
Thursday | 2021-02-11 00:00:00 | Day | 4 | 1 | 0 | 0
Friday | 2021-02-12 00:00:00 | Day | 3 | 0 | 3 | 1
Friday | 2021-02-12 00:00:00 | Swing | 10 | 2 | 0 | 1
Friday | 2021-02-12 00:00:00 | Swing | 9 | 1 | 1 | 0
Saturday | 2021-02-13 00:00:00 | Night | 1 | 0 | 2 | 0
Saturday | 2021-02-13 00:00:00 | Day | 2 | 1 | 2 | 1
Saturday | 2021-02-13 00:00:00 | Day | 2 | 0 | 0 | 1
Sunday | 2021-02-14 00:00:00 | Swing | 7 | 3 | 1 | 0
Sunday | 2021-02-14 00:00:00 | Swing | 7 | 3 | 0 | 1
Sunday | 2021-02-14 00:00:00 | Night | 1 | 1 | 1 | 0
Spreadsheet: 272889d1382541661-find-the-last-letter-in-a-column-and-return-a-value-in-the-same-row-but-a-different-column-example-data
Sheet: Sheet1

Good Data | RefDist | Dist | Start | End
 | 3.323 | 0 | 0 | 0.02
G | 3.343 | 0.02 | 0.02 | 0.04
G | 3.363 | 0.04 | 0.04 | 0.06
G | 3.383 | 0.06 | 0.06 | 0.08
G | 3.403 | 0.08 | 0.08 | 0.1
 | 3.423 | 0.1 | 0.1 | 0.12
 | 3.443 | 0.12 | 0.12 | 0.127
Spreadsheet: 796463d1663288635-if-multiple-query-if-query-cells-to-right
Sheet: Sheet1

Outcome | A | B | C | D | E | F
x | x
v |  |  |  | v
z |  | z
t |  |  | t
u |  |  |  |  | u
2022-12-06 00:00:00 |  | 2022-12-06 00:00:00
k |  |  |  |  |  | k
m |  |  | m
s |  |  |  | s
r | r
Not Checked
Spreadsheet: 138532d1327698969-show-names-of-ppl-once-from-a-list-of-duplicates-sample_names_issue
Sheet: Calculations

 | Calculations
 | NAE/NCCE Name
1 | Vu Nguyen
2 | [NAME]
3 | Inactive
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME] (LA)
8 | [NAME]
9 | [NAME]
10 | Washington Branch
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | New York Branch
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME] (New York)
19 | Cincinnati Branch
20 | [NAME]
21 | [NAME]
22 | [NAME]
23 | Los Angeles Branch
24 | Boston Branch
25 | Newark Branch
26 | [NAME]
27 | [NAME] Easdale
28 | Portland Branch
29 | [NAME]
30 | Chicago Branch
31 | San Antonio Branch
32
33 | Miami Branch
34 | [NAME]
35 | TBD
36 | [NAME] (Miami)
37 | Salt Lake City Branch
38 | [NAME] (Concord)
39 | [NAME] (San Fran)
40 | Salt Lake City DSM
41 | [NAME]
42 | Marketing Dept
43 | Tampa Branch
44 | [NAME]
45 | San Diego Branch
46 | [NAME]
47 | [NAME]
48 | [NAME] (Columbus)
49 | [NAME]
Spreadsheet: 472264d1469522463-converting-data-between-tabs-department-performance-current
Sheet: Team

 | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00
2016-07-10 00:00:00
2016-07-17 00:00:00
2016-07-24 00:00:00
2016-07-31 00:00:00
2016-08-07 00:00:00
2016-08-14 00:00:00
2016-08-21 00:00:00
2016-08-28 00:00:00
2016-09-04 00:00:00
2016-09-11 00:00:00
2016-09-18 00:00:00
2016-09-25 00:00:00
2016-10-02 00:00:00
2016-10-09 00:00:00
2016-10-16 00:00:00
2016-10-23 00:00:00
2016-10-30 00:00:00
2016-11-06 00:00:00
2016-11-13 00:00:00
2016-11-20 00:00:00
2016-11-27 00:00:00
2016-12-04 00:00:00
2016-12-11 00:00:00
2016-12-18 00:00:00
2016-12-25 00:00:00
Spreadsheet: 471545d1469074160-add-new-row-in-another-excel-sheet-add-new-row-in-another-excel-sheet
Sheet: 02 Chair

02 Chair
Asset |  |  |  | Quantity | Date | Price per Unit | Total Price in Purchased Date | Depreciation Percentage | Depreciation Expense | Total Price
Asset | Brand | Gen. | Code
Spreadsheet: larry_campbell__20992__PCB Graphs
Sheet: 63.26B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-03-22 00:00:00 |  |  | 27 |  | Sherwood
63.26 B Side |  |  | 2000-04-05 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 7 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-12 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 6 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 50996d1250601424-combo-box-totaling-combobox-1-
Sheet: Sheet1

 | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Office Supply | 65
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 46181 | 46125
2 | 45310 | 45501
3 | 45365 | 45393
4 | 45289 | 45501
5 | 29956 | 32422
6 | 44104 | 43943
7 | 28135 | 28260
8 | 40218 | 40777
9 | 54635 | 54792
10 | 55177 | 54792
11 | 54989 | 54792
12 | 26436 | 25267
13 | 43593 | 42531
14 | 46670 | 45534
15 | 36529 | 35569
16 | 38425 | 40811
17 | 39068 | 40811
18 | 38120 | 40811
19 | 41152 | 40811
20 | 27084 | 25132
21 | 45127 | 45397
22 | 36224 | 35937
23 | 42838 | 42872
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 1526.04
2002-02-23 00:00:00
CBS Volume
 |  |  | 549
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: si

Sweeney. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 768737d1645104648-v-look-up-monthly-data-v-look-up
Sheet: Sheet1

Month | Sales |  |  |  |  | Month | January | February | March
2022-01-01 00:00:00 | 10 |  |  |  |  | Sales | 10 | 11 | 12
2022-01-02 00:00:00 | 10
2022-01-03 00:00:00 | 10
2022-01-02 00:00:00 | 11
2022-02-02 00:00:00 | 11
2022-01-03 00:00:00 | 12
Spreadsheet: 526071d1499101480-extract-number-from-cell-contain-text-and-count-of-non-empty-cell-trials
Sheet: Sheet1

Location | Name | Number | Date | Type | [NAME] | Extracted  Number | Correct count of non empty cell | Incorrect Of Non empty cell | Incorrect formua
C-24   R | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 24 | 33 | https://exceljet.net/excel-functions/excel-countifs-function
C-24  Bd | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 39
C-39  R1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 54
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 30
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 31
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 34
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 53
C-39   washing | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 41
C-39   cooling | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW |  | 40
C-54  corner | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
control | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-30  B.d | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-31  R | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-31  corner | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-34   R1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-34   R2 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-34  B.d 1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-34  B.d 2 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-34  corner | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-53  R1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-53  R2 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-53  B.d | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-23  B.d | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-41  R1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-41  R2 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] hh | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-40  R1 | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
[NAME] | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
B-40  B.d | AWEEEEEE | 10023 | 2017-01-10 00:00:00 | SAW
Spreadsheet: 740674d1626449164-can-you-keep-tree-map-hierarchy-the-same-example-workbook-3-ans
Sheet: Sheet1

Group | Unit Number | No. | %
Group 1 | Unit 1 | 3
Group 1 | Unit 2 | 4
Group 1 | Unit 3 | 1
Group 1 | Unit 4 | 4
Group 1 | Unit 5 | 2
Group 1 | Unit 6 | 1
Group 1 | Unit 7 | 1
Group 1 | Unit 8 | 2
Group 1 | Unit 9 | 1
Group 1 | Unit 10 | 1
Group 1 | Unit 11 | 1
Group 2 | Unit 1 | 3
Group 2 | Unit 2 | 4
Group 2 | Unit 3 | 2
Group 2 | Unit 4 | 4
Group 2 | Unit 5 | 3
Group 2 | Unit 6 | 2
Group 2 | Unit 7 | 2
Group 3 | Unit 1 | 2
Group 3 | Unit 2 | 2
Group 3 | Unit 3 | 3
Group 3 | Unit 4 | 2
Group 3 | Unit 5 | 2
Group 3 | Unit 6 | 1
Group 3 | Unit 7 | 2
Group 3 | Unit 8 | 1
Group 3 | Unit 9 | 1
Group 3 | Unit 10 | 2 | 0.3
 |  |  |  |  |  |  |  | Second chart
Group 1 | Unit 1 | 0.8
Group 1 | Unit 2 | 1
Group 1 | Unit 3 | 0.25
Group 1 | Unit 4 | 1
Group 1 | Unit 5 | 0.5
Group 1 | Unit 6 | 0.25
Group 1 | Unit 7 | 0.25
Group 1 | Unit 8 | 0.5
Group 1 | Unit 9 | 0.25
Group 1 | Unit 10 | 0.25
Group 1 | Unit 11 | 0.9
Group 2 | Unit 1 | 1
Group 2 | Unit 2 | 0.4
Group 2 | Unit 3 | 0.5
Group 2 | Unit 4 | 1
Group 2 | Unit 5 | 1
Group 2 | Unit 6 | 1
Group 2 | Unit 7 | 1
Group 3 | Unit 1 | 0.75
Group 3 | Unit 2 | 0.6666666666666666
Group 3 | Unit 3 | 0.25
Group 3 | Unit 4 | 0.6666666666666666
Group 3 | Unit 5 | 0.6666666666666666
Group 3 | Unit 6 | 0.3333333333333333
Group 3 | Unit 7 | 0.6666666666666666
Group 3 | Unit 8 | 0.3333333333333333
Group 3 | Unit 9 | 0.3333333333333333
Group 3 | Unit 10 | 0.6666666666666666
Group 1 | Unit 1 | 0.8 |  |  |  |  |  | third chart
Group 1 | Unit 2 | 1
Group 1 | Unit 3 | 0.25
Group 1 | Unit 4 | 0.1
Group 1 | Unit 5 | 0.5
Group 1 | Unit 6 | 0.25
Group 1 | Unit 7 | 0.25
Group 1 | Unit 8 | 0.5
Group 1 | Unit 9 | 0.25
Group 1 | Unit 10 | 0.25
Group 1 | Unit 11 | 0.9
Group 2 | Unit 1 | 1
Group 2 | Unit 2 | 0.4
Group 2 | Unit 3 | 0.5
Group 2 | Unit 4 | 1
Group 2 | Unit 5 | 0.2
Group 2 | Unit 6 | 1
Group 2 | Unit 7 | 1
Group 3 | Unit 1 | 0.75
Group 3 | Unit 2 | 0.6666666666666666
Group 3 | Unit 3 | 0.25
Group 3 | Unit 4 | 0.6666666666666666
Group 3 | Unit 5 | 0.6666666666666666
Group 3 | Unit 6 | 0.3333333333333333
Group 3 | Unit 7 | 0.6666666666666666
Group 3 | Unit 8 | 0.3333333333333333
Group 3 | Unit 9 | 0.3333333333333333
Group 3 | Unit 10 | 0.6666666666666666
Spreadsheet: 80356d1280518483-excel-2007-if-column-c-is-14-days-of-todays-date-turn-red-if-not-turn-yellow-drewsb
Sheet: Sheet1

2010-07-06 00:00:00 |  |  |  |  |  |  | 2010-07-30 00:00:00
2010-07-07 00:00:00 |  |  |  |  |  |  | 2010-07-31 00:00:00
2010-07-08 00:00:00 |  |  |  |  |  |  | 2010-08-01 00:00:00
2010-07-09 00:00:00 |  |  |  |  |  |  | 2010-08-02 00:00:00
2010-07-10 00:00:00 |  |  |  |  |  |  | 2010-08-03 00:00:00
2010-07-11 00:00:00 |  |  |  |  |  |  | 2010-08-04 00:00:00
2010-07-12 00:00:00 |  |  |  |  |  |  | 2010-08-05 00:00:00
2010-07-13 00:00:00 |  |  |  |  |  |  | 2010-08-06 00:00:00
2010-07-14 00:00:00 |  |  |  |  |  |  | 2010-08-07 00:00:00
2010-07-15 00:00:00 |  |  |  |  |  |  | 2010-08-08 00:00:00
2010-07-16 00:00:00 |  |  |  |  |  |  | 2010-08-09 00:00:00
2010-07-17 00:00:00 |  |  |  |  |  |  | 2010-08-10 00:00:00
2010-07-18 00:00:00 |  |  |  |  |  |  | 2010-08-11 00:00:00
2010-07-19 00:00:00 |  |  |  |  |  |  | 2010-08-12 00:00:00
2010-07-20 00:00:00 |  |  |  |  |  |  | 2010-08-13 00:00:00
2010-07-21 00:00:00 |  |  |  |  |  |  | 2010-08-14 00:00:00
2010-07-22 00:00:00 |  |  |  |  |  |  | 2010-08-15 00:00:00
 |  |  |  |  |  |  | 2010-08-16 00:00:00
 |  |  |  |  |  |  | 2010-08-17 00:00:00
 |  |  |  |  |  |  | 2010-08-18 00:00:00
 |  |  |  |  |  |  | 2010-08-19 00:00:00
 |  |  |  |  |  |  | 2010-08-20 00:00:00
 |  |  |  |  |  |  | 2010-08-21 00:00:00
Spreadsheet: richard_shapiro__32220__2000contributions
Sheet: Sheet1

JKS Political Contributions - 2000
Beneficiary | Date | Election Year | Federal | State | Other |  | Notes
RMIC | 2000-05-14 00:00:00 | 2000 |  |  | 25000 |  | New PAC/T. DeLay
American Dream PAC | 2000-05-16 00:00:00 | 2000 |  |  | 1000
Friends of [NAME] | 2000-06-07 00:00:00 | 2000 | 1000 |  |  |  | 2000 primary
Republican National State Elections Comm | 2000-06-22 00:00:00 | 2000 |  |  | 50000
[NAME] 2000 | 2000-08-08 00:00:00 | 2000 | 1000 |  |  |  | NY Primary
[NAME] | 2000-10-31 00:00:00 | 2000 | 1000 |  |  |  | Annual dues
Presidential Inaugural Committee | 2000-12-26 00:00:00 | 2000 |  |  | 100000 |  | Presidential Inaugural Committee
Totals
Spreadsheet: 817012d1675949909-power-query-extracting-text-instead-of-web-link-copy
Sheet: POWER QUERY

SITE | TEAM LEADER | Work Coach | STATUS (JAN & FEB) | Date If Completed (JAN & FEB) | ACE Scan link (JAN & FEB) | STATUS ([NAME]) | Date If Completed ([NAME]) | ACE Scan link ([NAME]) | STATUS (APRIL) | Date If Completed (APRIL) | ACE Scan link (APRIL) | STATUS (MAY) | Date If Completed (MAY) | ACE Scan link (MAY)
ACTON | dee | Amer
ACTON |  | Troy
ACTON |  | Priya
ACTON |  | Hayley | Completed | 44951 | [NAME]
ACTON |  | [NAME]
ACTON |  | [NAME]
ACTON |  | Julian
ACTON |  | Rene
ACTON |  | Hafsa
ACTON |  | Danielle | Completed | 44951 | D_01022023140626.PDF
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON | raj | Hussain - 25+
ACTON |  | f Ahmed - 25+
ACTON |  | Power - 25+
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON | TEAM LEADER (NAME) | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON | TEAM LEADER (NAME) | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON | TEAM LEADER (NAME) | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
ACTON |  | WC (NAME)
Spreadsheet: 31c3a5ec-53d1-4c56-a99c-852fa1e4756f
Sheet: Sheet1

2013-07-03 00:00:00 | Antarctica 2012-2013 Number of Visitors per Site/per Vessel (Continental Sites Only)                                                                                                                                                                                                                                         (landed and nonlanded visits sorted alphabetically) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
(landed and nonlanded visits sorted alphabetically) | Total | BREMEN | EW-78779 | Orion | Ortelius | Spirit of Enderby | UP17601
Cape Adare | 7 | 0 | 0 | 0 | 7 | 0 | 0
Cape Bird | 97 | 0 | 0 | 0 | 0 | 97 | 0
Cape Evans | 614 | 125 | 0 | 104 | 269 | 116 | 0
[NAME] | 72 | 0 | 0 | 0 | 72 | 0 | 0
Cape Royds | 358 | 111 | 0 | 0 | 131 | 116 | 0
Commonwealth Bay | 103 | 0 | 0 | 0 | 0 | 0 | 0
Coulman Island | 103 | 103 | 0 | 0 | 0 | 0 | 0
Franklin Island | 132 | 76 | 0 | 0 | 0 | 56 | 0
Inexpressible Island | 55 | 0 | 0 | 0 | 0 | 55 | 0
McMurdo Ice Channel | 82 | 0 | 0 | 0 | 82 | 0 | 0
[NAME] | 91 | 0 | 0 | 0 | 60 | 31 | 0
Mount Erebus Summit | 62 | 0 | 0 | 0 | 62 | 0 | 0
[NAME] | 127 | 0 | 127 | 0 | 0 | 0 | 0
Ross Ice Shelf | 222 | 0 | 0 | 0 | 108 | 114 | 0
[NAME] | 246 | 116 | 0 | 0 | 74 | 56 | 0
Scott Island | 4 | 0 | 0 | 0 | 4 | 0 | 0
Taylor Valley/Canada Glacier | 129 | 0 | 0 | 0 | 129 | 0 | 0
Union Glacier | 682 | 0 | 0 | 0 | 0 | 0 | 682
Total | 3186 | 531 | 127 | 104 | 998 | 641 | 682
Spreadsheet: 266479d1379623927-returning-special-characters-specialc
Sheet: Sheet1

Names | Return |  |  | _x0001_
A.Malhotra | 1 |  |  | _x0002_
A .Mani | 1 |  |  | _x0003_
A A Aa Deo |  |  |  | _x0004_
A A Altha%f | 1 |  |  | _x0005_
A A Att#ar |  |  |  | _x0006_
A A Bo^hra | 1 |  |  | _x0007_
A A Chaudhary |  |  |  | _x0008_
AADeepti
A A G S Sha@rma | 1
 |  |  |  | _x000B_
 |  |  |  | _x000C_
 |  |  |  | _x000D_
 |  |  |  | _x000E_
 |  |  |  | _x000F_
 |  |  |  | _x0010_
 |  |  |  | _x0011_
 |  |  |  | _x0012_
 |  |  |  | _x0013_
 |  |  |  | _x0014_
 |  |  |  | _x0015_
 |  |  |  | _x0016_
 |  |  |  | _x0017_
 |  |  |  | _x0018_
 |  |  |  | _x0019_
 |  |  |  | _[NAME]_
 |  |  |  | _x001B_
 |  |  |  | _[NAME]_
 |  |  |  | _x001D_
 |  |  |  | _x001E_
 |  |  |  | _[NAME]_
 |  |  |  | !
 |  |  |  | "
 |  |  |  | #
 |  |  |  | $
 |  |  |  | %
 |  |  |  | &
 |  |  |  | '
 |  |  |  | (
 |  |  |  | )
 |  |  |  | *
 |  |  |  | +
 |  |  |  | ,
 |  |  |  | -
 |  |  |  | .
 |  |  |  | /
 |  |  |  | 0
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | :
 |  |  |  | ;
 |  |  |  | <
 |  |  |  | =
 |  |  |  | >
 |  |  |  | ?
 |  |  |  | @
 |  |  |  | [
 |  |  |  | \
 |  |  |  | ]
 |  |  |  | ^
 |  |  |  | _
 |  |  |  | `
 |  |  |  | {
 |  |  |  | }
 |  |  |  | ~
 |  |  |  | 
 |  |  |  | €
 |  |  |  | 
 |  |  |  | [NAME]
 |  |  |  | ƒ
 |  |  |  | „
 |  |  |  | …
 |  |  |  | †
 |  |  |  | ‡
 |  |  |  | ˆ
 |  |  |  | ‰
 |  |  |  | Š
 |  |  |  | ‹
 |  |  |  | Œ
 |  |  |  | 
 |  |  |  | Ž
 |  |  |  | 
 |  |  |  | 
 |  |  |  | ‘
 |  |  |  | ’
 |  |  |  | “
 |  |  |  | ”
 |  |  |  | •
 |  |  |  | –
 |  |  |  | —
 |  |  |  | ˜
 |  |  |  | ™
 |  |  |  | š
 |  |  |  | ›
 |  |  |  | œ
 |  |  |  | 
 |  |  |  | ž
 |  |  |  | Ÿ
 |  |  |  | ¡
 |  |  |  | ¢
 |  |  |  | £
 |  |  |  | ¤
 |  |  |  | ¥
 |  |  |  | [NAME]
 |  |  |  | §
 |  |  |  | ¨
 |  |  |  | ©
 |  |  |  | ª
 |  |  |  | «
 |  |  |  | ¬
 |  |  |  | ­
 |  |  |  | ®
 |  |  |  | ¯
 |  |  |  | °
 |  |  |  | ±
 |  |  |  | ²
 |  |  |  | ³
 |  |  |  | ´
 |  |  |  | µ
 |  |  |  | ¶
 |  |  |  | ·
 |  |  |  | ¸
 |  |  |  | ¹
 |  |  |  | º
 |  |  |  | »
 |  |  |  | [NAME]
 |  |  |  | ½
 |  |  |  | ¾
 |  |  |  | ¿
 |  |  |  | À
 |  |  |  | Á
 |  |  |  | Â
 |  |  |  | Ã
 |  |  |  | Ä
 |  |  |  | Å
 |  |  |  | Æ
 |  |  |  | Ç
 |  |  |  | È
 |  |  |  | É
 |  |  |  | Ê
 |  |  |  | Ë
 |  |  |  | Ì
 |  |  |  | Í
 |  |  |  | Î
 |  |  |  | Ï
 |  |  |  | Ð
 |  |  |  | Ñ
 |  |  |  | Ò
 |  |  |  | Ó
 |  |  |  | Ô
 |  |  |  | Õ
 |  |  |  | Ö
 |  |  |  | ×
 |  |  |  | Ø
 |  |  |  | Ù
 |  |  |  | Ú
 |  |  |  | Û
 |  |  |  | Ü
 |  |  |  | Ý
 |  |  |  | Þ
 |  |  |  | ß
 |  |  |  | à
 |  |  |  | á
 |  |  |  | â
 |  |  |  | ã
 |  |  |  | ä
 |  |  |  | å
 |  |  |  | æ
 |  |  |  | ç
 |  |  |  | è
 |  |  |  | é
 |  |  |  | ê
 |  |  |  | ë
 |  |  |  | ì
 |  |  |  | í
 |  |  |  | î
 |  |  |  | ï
 |  |  |  | ð
 |  |  |  | ñ
 |  |  |  | ò
 |  |  |  | ó
 |  |  |  | ô
 |  |  |  | õ
 |  |  |  | ö
 |  |  |  | ÷
 |  |  |  | ø
 |  |  |  | ù
 |  |  |  | ú
 |  |  |  | û
 |  |  |  | ü
 |  |  |  | ý
 |  |  |  | þ
 |  |  |  | ÿ
Spreadsheet: 737540d1624459749-how-do-i-find-a-common-answer-when-a-cell-n-a-or-0-test7
Sheet: Sheet1

 |  | Length1 | Prod No | Ref1 | Test | I GET | I WANT |  |  |  |  |  |  |  |  |  |  | Length | Ref1
 |  | 200 | 1 | 7 |  |  | 200 |  |  |  |  |  |  |  |  |  |  | 0 | 6
 |  | 23 | 2 | 32 |  |  | 23 |  |  |  |  |  |  |  |  |  |  | 0 | 2
 |  | 56 | 3 | 15 |  |  | 56 |  |  |  |  |  |  |  |  |  |  | 0 | 7
 |  | 200 | 4 | 12 |  |  | 200 |  |  |  |  |  |  |  |  |  |  | 0 | 34
 |  | 37 | 5 | 45 |  |  | 200 |  |  |  |  |  |  |  |  |  |  | 0 | 15
 |  | 100 | 6 | 27 |  |  | 200 |  |  |  |  |  |  |  |  |  |  | 100 | 27
 |  | 66 | 7 | 22 |  |  | 66 |  |  |  |  |  |  |  |  |  |  | 200 | 45
 |  | 45 | 8 | 45 |  |  | 200 |  |  |  |  |  |  |  |  |  |  | 66 | 31
 |  | 22 | 9 | 14 |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 66 | 29
 |  | 150 | 10 | 27 |  |  | 100 |  |  |  |  |  |  |  |  |  |  | 10 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 45