tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 735285d1622814650-looking-up-start-date-of-month-calendar-
Sheet: Sheet1

Month Date | Year | Month |  | Month No | Start Date | End Date | Days
 | 2018 | Jan |  | 1 | 2017-12-30 00:00:00 | 2018-01-27 00:00:00 | 19 |  |  | 2018-05-14 00:00:00
 | 2018 | Feb |  | 2 |  | 2018-02-23 00:00:00 | 19
 | 2018 | Mar |  | 3 |  | 2018-03-30 00:00:00 | 24
 | 2018 | Apr |  | 4 |  | 2018-04-27 00:00:00 | 20
 | 2018 | May |  | 5 |  | 2018-05-25 00:00:00 | 19
 | 2018 | Jun |  | 6 |  | 2018-06-29 00:00:00 | 25
 | 2018 | Jul |  | 7 |  | 2018-07-27 00:00:00 | 19
 | 2018 | Aug |  | 8 |  | 2018-08-24 00:00:00 | 19
 | 2018 | Sep |  | 9 |  | 2018-09-28 00:00:00 | 24
 | 2018 | Oct |  | 10 |  | 2018-10-26 00:00:00 | 19
 | 2018 | Nov |  | 11 |  | 2018-11-23 00:00:00 | 19
 | 2018 | Dec |  | 12 |  | 2018-12-28 00:00:00 | 23
 | 2019 | Jan |  | 1 | 2018-12-31 00:00:00 | 2019-01-25 00:00:00 | 19
 | 2019 | Feb |  | 2 |  | 2019-02-22 00:00:00 | 19
 | 2019 | Mar |  | 3 |  | 2019-03-29 00:00:00 | 25
 | 2019 | Apr |  | 4 |  | 2019-04-26 00:00:00 | 19
 | 2019 | May |  | 5 |  | 2019-05-24 00:00:00 | 19
 | 2019 | Jun |  | 6 |  | 2019-06-28 00:00:00 | 25
 | 2019 | Jul |  | 7 |  | 2019-07-26 00:00:00 | 19
 | 2019 | Aug |  | 8 |  | 2019-08-23 00:00:00 | 19
 | 2019 | Sep |  | 9 |  | 2019-09-27 00:00:00 | 24
 | 2019 | Oct |  | 10 |  | 2019-10-25 00:00:00 | 19
 | 2019 | Nov |  | 11 |  | 2019-11-22 00:00:00 | 20
 | 2019 | Dec |  | 12 |  | 2019-12-27 00:00:00 | 23
 | 2020 | Jan |  | 1 | 2019-12-30 00:00:00 | 2020-01-31 00:00:00 | 24
 | 2020 | Feb |  | 2 |  | 2020-02-28 00:00:00 | 19
 | 2020 | Mar |  | 3 |  | 2020-04-03 00:00:00 | 25
 | 2020 | Apr |  | 4 |  | 2020-05-01 00:00:00 | 19
 | 2020 | May |  | 5 |  | 2020-05-29 00:00:00 | 19
 | 2020 | Jun |  | 6 |  | 2020-07-03 00:00:00 | 24
 | 2020 | Jul |  | 7 |  | 2020-07-31 00:00:00 | 20
 | 2020 | Aug |  | 8 |  | 2020-08-28 00:00:00 | 19
 | 2020 | Sep |  | 9 |  | 2020-10-02 00:00:00 | 24
 | 2020 | Oct |  | 10 |  | 2020-10-30 00:00:00 | 19
 | 2020 | Nov |  | 11 |  | 2020-11-27 00:00:00 | 20
 | 2020 | Dec |  | 12 |  | 2021-01-01 00:00:00 | 22
 | 2021 | Jan |  | 1 | 2021-01-02 00:00:00 | 2020-01-29 00:00:00 | 20
 | 2021 | Feb |  | 2 | 2021-01-30 00:00:00 | 2020-02-26 00:00:00 | 19
 | 2021 | Mar |  | 3 | 2021-02-27 00:00:00 | 2020-04-02 00:00:00 | 24
 | 2021 | Apr |  | 4 | 2021-04-03 00:00:00 | 2020-04-30 00:00:00 | 20
 | 2021 | May |  | 5 | 2021-05-01 00:00:00 | 2020-05-28 00:00:00 | 19
 | 2021 | Jun |  | 6 | 2021-05-29 00:00:00 | 2020-07-02 00:00:00 | 24
 | 2021 | Jul |  | 7 | 2021-07-03 00:00:00 | 2020-07-30 00:00:00 | 20
 | 2021 | Aug |  | 8 | 2021-07-31 00:00:00 | 2020-08-27 00:00:00 | 19
 | 2021 | Sep |  | 9 | 2021-08-28 00:00:00 | 2020-10-01 00:00:00 | 24
 | 2021 | Oct |  | 10 | 2021-10-02 00:00:00 | 2020-10-29 00:00:00 | 19
 | 2021 | Nov |  | 11 | 2021-10-30 00:00:00 | 2020-11-26 00:00:00 | 20
 | 2021 | Dec |  | 12 | 2021-11-27 00:00:00 | 2020-12-31 00:00:00 | 23
Spreadsheet: 720008d1613975873-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep-update-1-ans3
Sheet: Pre

ID | NAME | DATE1 | PT | COMMON |  |  |  |  |  |  | # 1 | # 2 | # 3 | SUM1 | SUM2 | TYPE 2 | ALL PO |  | AR | AF
1226572 |  |  | Post 100% | AAA |  |  |  |  |  |  | 1 |  |  |  |  |  | 249975 |  |  |  | Expected Value: "Pre Calc" | Scenario 2 (1st logic upate) |  |  | -249975
1226191 |  |  | Net Down | BB of B |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | Expected Value: "Pre Calc" | Scenario 2 (1st logic upate) |  |  | -
1224113 |  |  | Post 100% | FDFDE |  |  |  |  |  |  | 1 |  |  |  |  |  | 21428 |  |  |  | Expected Value: '-' | Scenario 2 (2nd logic update) |  |  | 1
1172600 |  |  | Post 100% | EREFE |  |  |  |  |  |  | 1 |  |  |  |  |  | 50039 |  |  |  |  |  |  |  | -50039
1163603 |  |  | Net Down | ODJEO |  |  |  |  |  |  | 1 |  |  |  |  |  | 23221891 |  |  |  |  |  |  |  | 279182706
1179778 |  |  | Post 100% | EREERE |  |  |  |  |  |  | 1 |  |  |  |  |  | 1180674 |  |  |  |  |  |  |  | -1180674
Spreadsheet: 758119d1638658356-countif-then-minus-if-cell-left-of-it-equals-text-countif_minus_if_cell_left_equals
Sheet: Sheet1

Order | Player
1 | [NAME] |  |  | Countif = [NAME] in column B minus [NAME] in column B if the cell left of his name (column A) equals Batter-1 or Batt-2
2 | [NAME] |  |  | Should equal to 2, not 4
3 | Lucas Clarke
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | Freddie Schneidereit
9 | [NAME]
10 | [NAME]
11 | [NAME]
12
13
14
15
Batter-1 | [NAME]
Batter-2 | [NAME]
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | Lucas Clarke
7 | [NAME]
8 | Freddie Schneidereit
9 | [NAME]
10 | [NAME]
11 | [NAME]
12
13
14
15
 | 1st Wicket Partnership
Batters: | Dylan Thompson & Barnaby Hodgson
Partnership: | 27
Fall of Wicket: | 27
Batter-1 | [NAME]
Batter-2 | [NAME]
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.05.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-05 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 1 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 30 | 0 | 5 | 1 | 2 | 0 | 0 | 3 | 0
 | 5TH FL | 34 | 20 | 24 | 1 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 23 | 0 | 6 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-05 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 10 | 2 | 2 | 1 | 0 | 1 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 26 | 0 | 5 | 1 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 1 | 4 | 1 | 2 | 0 | 0 | 2 | 0 | (in house transfer
 | ABC | 27 | 18 | 20 | 0 | 6 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 | GHI | N/A | N/A | 5 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 0db63400-6e6a-495e-9206-e5701ae98590
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Rotary Rig Count | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | 02/15/2013
 |  |  |  | Week |  | Year
Location |  | Week | +/- | Ago | +/- | Ago
Land |  | 1691 | 3 | 1688 | -247 | 1938
Inland Waters |  | 16 | 0 | 16 | 1 | 15
Offshore |  | 55 | 0 | 55 | 14 | 41
United States Total |  | 1762 | 3 | 1759 | -232 | 1994
Gulf Of Mexico |  | 53 | 0 | 53 | 12 | 41
Canada |  | 651 | 20 | 631 | -54 | 705
North America |  | 2413 | 23 | 2390 | -286 | 2699
U.S. Breakout Information |  | This Week | +/- | Last Week | +/- | Year Ago
Oil |  | 1337 | 7 | 1330 | 65 | 1272
Gas |  | 421 | -4 | 425 | -295 | 716
Miscellaneous |  | 4 | 0 | 4 | -2 | 6
Directional |  | 194 | 9 | 185 | -20 | 214
Horizontal |  | 1139 | -4 | 1143 | -24 | 1163
Vertical |  | 429 | -2 | 431 | -188 | 617
Canada Breakout Information |  | This Week | +/- | Last Week | +/- | Year Ago
Oil |  | 500 | 20 | 480 | -16 | 516
Gas |  | 151 | 0 | 151 | -38 | 189
Miscellaneous |  | 0 | 0 | 0 | 0 | 0
Major State Variances |  | This Week | +/- | Last Week | +/- | Year Ago
Alaska |  | 8 | 0 | 8 | -2 | 10
Arkansas |  | 15 | -1 | 16 | -14 | 29
California |  | 34 | 0 | 34 | -9 | 43
Colorado |  | 56 | 0 | 56 | -13 | 69
Louisiana |  | 110 | -1 | 111 | -28 | 138
New Mexico |  | 76 | 0 | 76 | -7 | 83
North Dakota |  | 177 | -1 | 178 | -8 | 185
Oklahoma |  | 194 | -2 | 196 | -14 | 208
Pennsylvania |  | 66 | -5 | 71 | -42 | 108
Texas |  | 838 | 14 | 824 | -76 | 914
West Virginia |  | 22 | -1 | 23 | -7 | 29
Wyoming |  | 47 | 1 | 46 | -2 | 49
Spreadsheet: 27921d1221652020-return-cell-depending-on-date-flight-sched
Sheet: SEP 08

 | 2008-10-01 00:00:00 | 31
 |  | 30 | 30 |  | 2008-09-01 00:00:00
 | Name | Last Location | Last Job | Changes / Comments | 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
 |  |  |  |  | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job # | D/T/A | City | Time | Flight # | Job #
 | Rich | 0 | 0 |  | Dpt | [NAME] | 2215 | OC815 | AUS812 | Arr | AKL | 0230 | OC815 | AUS812 | Dpt | AKL | 1330 | BA126 | NH | Trn | AKL |  | BA126 | NH | Arr | LHR | 0855 | BA126 | NH |  |  |  |  |  | [NAME] | EMA - ROM | 0920 - 1405 | EJ922 | ITA846 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST |  |  | TEST2
Spreadsheet: 701360d1603723003-link-cell-data-to-venn-diagram-venn-1
Sheet: Venn

A | B | C
Project 1 | Project 2 | Project 4
Project 2 | Project 5 | Project 5
Project 3 | Project 6 | Project 8 |  |  |  |  | A |  |  |  |  | B
Project 4 | Project 7 | Project 9
Project 7 | Project 9 | Project 10
Project 8 |  | Project 11
 |  | Project 2
 |  |  |  |  |  |  |  |  | C
Spreadsheet: 35941d1233668553-cell-referencing-issues-to-other-worksheets-sample-workbook
Sheet: Sheet2

week 1 |  |  | week 2 |  |  | week 3 |  |  | week 4
% | Reps | WT | % | Reps | WT | % | Reps | WT | % | Reps | WT
0.65 | 10 | 0.65 | 0.68 | 15 | 0.68 | 0.71 | 10 | 0.71 | 0.65 | 13 | 0.65
0.65 | 10 | 0.65 | 0.68 | 15 | 0.68 | 0.71 | 10 | 0.71 | 0.65 | 13 | 0.65
0.65 | 10 | 0.65 | 0.68 | 15 | 0.68 | 0.71 | 10 | 0.71 | 0.65 | 13 | 0.65
 |  |  | 0.68 | 15 | 0.68 |  |  |  | 0.65 | 13 | 0.65
 |  |  | 0.68 | 15 | 0.68 |  |  |  | 0.65 | 13 | 0.65
 |  |  | 0.68 | 15 | 0.68 |  |  |  | 0.65 | 13 | 0.65
 |  |  | 0.68 | 15 | 0.68 |  |  |  | 0.65 | 13 | 0.65
 |  |  | 0.68 | 15 | 0.68
Spreadsheet: 684563d1593444283-creating-flexible-rent-roll-example-rent-roll
Sheet: Sheet1

 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00
Revenue
Tenant 1
Rent Start | 2019-07-12 00:00:00 | 500
Increase | 2019-10-05 00:00:00 | 700
[NAME]
Rent Start | 2019-08-20 00:00:00 | 300
Inxrease | 2019-12-08 00:00:00 | 650
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 4

[NAME] |  | Total Number | [NAME]
[NAME] |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 681 | 5 | 24 | 22 | 34 | 9 | 7
2011 |  | 643 | 7 | 27 | 23 | 29 | 9 | 5
2012 | All Students | 653 | 7 | 25 | 26 | 28 | 9 | 4
 | Black or African American | 39 | 10 | 33 | 18 | 31 | 8
 | Hispanic or Latino | 232 | 7 | 25 | 27 | 28 | 8 | 4
 | White | 332 | 6 | 23 | 27 | 27 | 11 | 5
 | Two or more races | 26 | 12 | 27 | 19 | 27 | 12 | 4
 | Minority | 321 | 9 | 26 | 24 | 30 | 8 | 3
 | English Learners | 121 | 8 | 23 | 30 | 26 | 7 | 5
 | Free/Reduced Lunch | 353 | 7 | 21 | 27 | 31 | 11 | 4
 | Female | 240 | 9 | 23 | 28 | 27 | 9 | 5
 | Male | 411 | 6 | 26 | 25 | 29 | 10 | 4
Spreadsheet: 770797d1646255112-working-time-directive-calculations-timesheet2
Sheet: 21-2-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | N Tylor / W Donaldson
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | D Paris
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 14 | 4 |  |  | 1/2 AL | 0 |  |  | AL | 7.5 |  |  | TR | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] | 18 | 7.5 | -5.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 15.5 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 0 | 0 |  |  | AL | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 7
 | [NAME] | 25 | 7.5 |  |  | TR | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 22 | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] | 26 | 7.5 |  |  |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 8 |  | 8
 | Vacant Post | 8.5 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 093ddced-5d9d-4fd0-b59b-390db080fda3
Sheet: Table VII.2

Table VII.2 الجدول
Access to Improved Drinking Water Sources (urban) (%)1
السكان الذين [NAME] مياه الشرب من مصادر محسّنة ([NAME]) (بالنسبة المئوية)
 | 1990 | 2000 | 2005 | 2008
Bahrain | 100 | 100 | 100 | 100 | البحرين
Egypt | 96 | 99 | 100 | 100 | مصر
Iraq | 97 | 95 | 93 | 91 | العراق
Jordan | 99 | 98 | 98 | 98 | الأردن
Kuwait | 99 | 99 | 99 | 99 | الكويت
Lebanon | 100 | 100 | 100 | 100 | لبنان
Oman | 84 | 87 | 90 | 92 | عمان
Palestine | … | … | 97* | 96* | فلسطين
Qatar | 100 | 100 | 100 | 100 | قطر
Saudi Arabia | 97 | 97 | 97 | 97 | المملكة العربية السعودية
The Sudan | 85 | 73 | 68 | 64 | السودان
The Syrian Arab Republic | 96 | 95 | 95 | 94 | الجمهورية العربية السورية
The United Arab Emirates | 100 | 100 | 100 | 100 | الإمارات العربية المتحدة
Yemen | ... | 82 | 75 | 72 | اليمن
ESCWA2 | 913 | 924 | 93 | … | [NAME]
GCC2 | 97 | 97 | 97 | … | دول مجلس التعاون الخليجي
Source: | MDG Database, accessed on 19 April 2011.
 | * | PCBS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
Notes: | 1 | All values are estimated by their sources.
 | 2 | ESCWA calculation weighted average by the population.  If data for more than two countries are missing, no average is calculated.  Urban population figures are based on the World Urbanization Prospects: The 2009 Revision, UNSD.
 | 3 | Excluding Palestine and Yemen.
 | 4 | Excluding Palestine.
Spreadsheet: 782605d1654157428-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-sample
Sheet: Sheet1

 |  |  |  |  |  | Column1 | Column2 | Column3 | Column4 |  | Try to calculate Two separate steps | Example data expected answers
 |  |  |  |  | start | 5 | 5 | 5 | 5
 |  |  |  |  |  | 10 | 10 | 10 | 10 |  |  | collumn 1 | collumn 2 | collumn 3 | collumn 4
 |  |  |  |  |  | 20 | 10 | 10 | 10 |  | 1. Count how long it takes to reach "90.5" or higher (First reading above 90.5) from start | 10 | 11 | 12 | 13
 |  |  |  |  |  | 30 | 20 | 20 | 10
 |  |  |  |  |  | 40 | 30 | 30 | 20
 |  |  |  |  |  | 50 | 40 | 40 | 30
 |  |  |  |  |  | 60 | 50 | 50 | 40
 |  |  |  |  |  | 70 | 60 | 60 | 50
 |  |  |  |  |  | 80 | 70 | 70 | 60
 |  |  |  |  |  | 92 | 80 | 80 | 70
 |  |  |  |  |  | 90.5 | 92 | 80 | 80
 |  |  |  |  |  | 90 | 90.5 | 92 | 80
 |  |  |  |  |  | 90 | 90 | 90.5 | 92
 |  |  |  |  |  | 80 | 90 | 90 | 90.5
 |  |  |  |  |  | 70 | 80 | 80 | 90
 |  |  |  |  |  | 60 | 70 | 70 | 80
 |  |  |  |  |  | 50 | 60 | 60 | 70 |  | 2. Count how long it takes to reach "4.5" or lower (first reading below 4.5). This will need to calculate after reaching [NAME] temperature | 22 | 23 | 24 | 25
 |  |  |  |  |  | 40 | 50 | 50 | 60
 |  |  |  |  |  | 30 | 40 | 40 | 50
 |  |  |  |  |  | 20 | 30 | 30 | 40 |  | Notes: I will need to scale this up for my data range and the table will include some blank cells. In addition, the purpose for both of theses steps is to identify which collumn achieves the given values first.
 |  |  |  |  |  | 10 | 20 | 20 | 30
 |  |  |  |  |  | 3 | 10 | 10 | 20
 |  |  |  |  |  | 4.5 | 3 | 10 | 10
 |  |  |  |  |  | 0 | 4.5 | 3 | 10
 |  |  |  |  |  | 0 | 0 | 4.5 | 3
 |  |  |  |  |  | 0 | 0 | 0 | 4.5
Spreadsheet: 73518d1274188135-excel-2007-auto-select-and-copy-rows-containing-a-cell-with-a-specific-value-db-aprobari
Sheet: Query

Actionfigures
Adidas | Choose Brand | [NAME]
[NAME]
Altex
Piperita  Trading Srl
Asia
[NAME]
[NAME]
Benissimo
Benvenuti
[NAME]
Bigstar
Bio Balance
Bjornson
[NAME]
Brise
Burger King
Cache-Cache
Casino
Champion
Christian Tour
[NAME]
Clate
Costa Coffe
Cropp Town
Cup&Cino
D&P
Diverta
Elisse
Forever 18
Fox
Hervis
House of Art
Ilotti
Inmedio
Jolidon
Kameea
[NAME]
[NAME]
Kidslandia
Lacoste
[NAME]
[NAME]
Liberty Center
Light Cinema
Lussile
Magic Aventura
Mark & Spencer
[NAME]
MC DONALD`S
MC [NAME]'S
Migato
Miniblu
Moda Miss
Mondex
Napoleoni
Next
No Name
Office Shoes
O'neill +The North Face
Orange Shop
Orlov
Orsay
Pizza Hut
Plafar
Playersroom
Poupee
[NAME]
[NAME]
Radar
Reserved
Say
[NAME]
Sephora
Sprider
Starbucks
Steilmann
Teriyaki
The Vesper
[NAME]
Triumph
[NAME]
Vodafone
Vodafone Arsis
[NAME]
Spreadsheet: 165690d1341320902-function-abc
Sheet: Sheet1

ITEM | QTY SOLD | SELL THRU %
A | 100 |  |  | HOW TO FIND WHICH ITEM ARE DRIVEN 80% SALES IN THIS TABLE.
B | 300
C | 20
D | 1
E | 30
F | 4
G | 5
H | 600
I | 500
TOTAL
Spreadsheet: 158601d1338315903-linking-spreadsheets-and-editing-database-may-2012-working-copy-2
Sheet: Main

Title | Forename | Surname | Company | Address 1 | Address 2 | Address 3 | City/Town | County | Postcode | Country | DX | [NAME] | Telephone | Fax/Business | Employment Briefing | Newsletter | Top Clients | Christmas Card /E Card | Business Type | Department per Business Plan | Partner (if diff from fee-earner) | Fee Earner (if known)
Mr | [NAME] | Johnstone | McClure Naismith | 292 St Vincent Street |  |  | [NAME] |  | G2 5TQ | Scotland |  | [EMAIL] | [PHONE] |  |  | E | X | Yes |  | I, CP, E, B
Mr | [NAME] | [NAME] | Instinct Technology Ltd | 4 Dunolly Drive | Newtonmearns |  | [NAME] |  | G77 5NT | Scotland |  | [EMAIL] | [PHONE] |  |  | P |  |  |  |  |  | TMcM
Ms | Leigh | [NAME] | Skanska UK Plc | Maple Cross House | [NAME] | Maple Cross | Rickmansworth | Hertfordshire | WD3 9SW | England |  | [EMAIL] | [PHONE] |  |  | E
Mr | [NAME] | Sharp | Skanska UK Plc | Maple Cross House | [NAME] | Maple Cross | Rickmansworth | Hertfordshire | WD3 9SW | England |  | [EMAIL] | [PHONE] |  |  | P |  |  |  |  |  | MMcC
Spreadsheet: 87345d1287155708-finding-the-value-from-the-list-parts-and-insert-extra-part-in-the-list-book1
Sheet: CND

 |  |  | List No. | List's Part | Amount
1750002A950 |  | 402.57 | 1 | 1750002A950 | 402.57
1750002B950 |  | 402.57 | 2 | 50100KSTA30 | 193.16
17500KST860ZA |  | 402.57 | 3 | 6110002A940 | 32.94
17500KST860ZB |  | 402.57
17500KST860ZC |  | 402.57
17500KST860ZD |  | 402.57
17500KST860ZE |  | 402.57
17500KST900US |  | 402.57
17500KST900ZA |  | 402.57 |  | 17500KWA900
17500KST900ZB |  | 402.57 |  | 50100KWA930
17500KST900ZC |  | 402.57 |  | 61100KST920
17500KST900ZD |  | 402.57
17500KST900ZE |  | 402.57
17500KST900ZF |  | 402.57
17500KST920ZA |  | 402.57
17500KST920ZB |  | 402.57
17500KST920ZC |  | 402.57
17500KST920ZD |  | 402.57
17500KST920ZE |  | 402.57
17500KST920ZF |  | 402.57
17500KST920ZG |  | 402.57
17500KST930ZA |  | 402.57
17500KST930ZB |  | 402.57
17500KST930ZC |  | 402.57
17500KST930ZD |  | 402.57
17500KST930ZE |  | 402.57
17500KST950ZA |  | 402.57
17500KST950ZB |  | 402.57
17500KST950ZC |  | 402.57
17500KST950ZD |  | 402.57
17500KST950ZE |  | 402.57
17500KSTA10ZA |  | 402.57
17500KSTA10ZB |  | 402.57
17500KSTA10ZC |  | 402.57
17500KSTA10ZD |  | 402.57
17500KSTA10ZE |  | 402.57
17500KSTA20ZA |  | 402.57
17500KSTA20ZB |  | 402.57
17500KSTA20ZC |  | 402.57
17500KSTA20ZD |  | 402.57
17500KSTA20ZE |  | 402.57
50100KST860 |  | 193.16
50100KST870 |  | 193.16
50100KST900 |  | 193.16
50100KST930 |  | 193.16
50100KST950 |  | 193.16
50100KSTA10 |  | 193.16
50100KSTA20 |  | 193.16
50100KSTA30 |  | 193.16
6110002A940 |  | 32.94
61100KST930ZA |  | 32.94
61100KST940ZA |  | 32.94
61100KST940ZC |  | 32.94
61100KST940ZD |  | 32.94
61100KST940ZE |  | 32.94
Spreadsheet: d7218469-faf6-4e2a-b089-d4d45dca4134
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Fervent For-Sale Merch | 679143055743 | [NAME] | [NAME] If We'Re Honest Juniors Xlarge | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055736 | [NAME] | [NAME] If We'Re Honest Juniors Large | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055729 | [NAME] | [NAME] If We'Re Honest Juniors Medium | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055712 | [NAME] | [NAME] If We'Re Honest Juniors Small | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055705 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Xlarge Juniors | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055699 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Large Juniors | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055682 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Medium Juniors | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055675 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Small Juniors | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055231 | [NAME] | [NAME] If We'Re Honest Xlarge Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055224 | [NAME] | [NAME] If We'Re Honest Large Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055217 | [NAME] | [NAME] If We'Re Honest Medium Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055200 | [NAME] | [NAME] If [NAME] Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055170 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Xlarge Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055163 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Large Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055156 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Medium Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available
Fervent For-Sale Merch | 679143055149 | [NAME] | Heather Grey Free To Be Me 'Heart To Be' Small Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | N | Available