tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1495f262-749b-4bf3-83aa-9ed9c0005a84
Sheet: B

Car Make/Model/Year | Volume Number
Bailey
[NAME]
1911 | 23 no. 13
1912 | 23 no. 12
1912 | 23 no. 14
1913 | 23 no. 15
1913 | 23 no. 16
Baker Electrics.
Baker Motor Vehicle Co.
190? | 22 no. 1
1914---repair manual | 23 no. 2
1914 | 23 no. 4
1909 | 207 no. 4
1905 | 124 no. 2
Ballot
(France), 1929 | 249 no. 8
Barley M
Barley Motor Car Co.
1921 | 224 no. 8
Bauer, 1929 | 214 no. 21
Beaver
1920 | 53 no. 11
1920 | 54 no. 8
Bell, 1922 | 67 no. 5
Belsize
(British)
1912 | 45 (+) no. 4
1913 | 45 (+) no. 5
[NAME]
(French)
1930 | 238 (+) no. 6
Bentley
(British), 1929 | 241 (+) no. 12
1936 | 311 (+) no. 2
Bergdoll | 45 (+) no. 15
Berliet
(French)
191? | 53 no. 2
1912 | 55 no. 1
1931 | 221 no. 4
Beverley
(British), 1929 | 245(+) no. 6
Bianchi
(Italian,) 1912 | 45 (+) no. 7
Biddle, 1922 | 67 no. 1
Blackhawk, Stutz Motor Co., 1930 | 245 (+) no. 3
Brennan
1905 | 11 no. 5
1906 | 11 no. 3
Brewster, Brewster & Co.
1917 | 50 no. 1
1917 | 50 no. 4
1919---repair manual | 68 no. 1
1919 | 68 no. 2
1919 | 50 no. 3
1922 | 50 no. 2
Brictson, The, 1909 | 12 no. 9
Briscoe
1905 | 68 no. 6
1912 | 68 no. 5
1915 | 68 no. 3
1919---repair manual | 68 no. 4
1920 | 66 (+) no. 4
Bristol
(British) 1932 | 235 (+) no. 16
[NAME]---toy -1905
The [NAME]
1911 | 55 no. 16
The Buckmobile, Black Diamond Auto Co. 1905 | 68 no. 7
Buick
1914 | 50 no. 7
1915 | 3 no. 15
1916---parts list | 3 no. 16
1917---parts list | 4 (+) no. 15
1918 | 66 (+) no. 3
1919 | 55 no. 11
1919---repair manual | 68 no. 10
1920 | 227 no. 6
1920 | 317 no. 1
1921 | 68 no. 12
1922 | 66 (+) no. 5
1922---repair manual | 68 no. 9
1922---repair manual | 181 no. 13
1922 | 227 no. 7
1923 | 66 (+) no. 1
1924 | 68 no. 8
1925 | 20 no. 2
1925---repair manual | 68 no. 11
1926 | 242 (+) no. 3
1928 | 244 (+) no. 7
1929 | 240 (+) no. 6
1929 | 243 (+) no. 11
1929 | 245 (+) no. 11
1930 | 217 no. 6
1930 | 252 no. 8
1930 | 227 no. 10
1930 | 245 (+) no. 11
1930 | 235 (+) no. 43
1931 | 230 no. 2
1932 | 252 no. 12
1932 | 253 no. 12
1933---owner’s manual | 329 no. 10
1934---owner’s manual | 329 no. 11
1924 | 317 no. 4
1924 | 329 no. 9
Spreadsheet: 97993d1297099805-help-with-how-to-remove-n-a-that-is-displayed-from-formula-results-fte-calculator2
Sheet: Service Activity Info

Service Activity | [NAME] | Benchmark Hours | Coverage Number | Number Expected for Year | Percent Expected to Cover | Total Hours Required for Activity |  | Benchmark Hours Chart |  |  |  | Populate First
Restaurant Inspection | PHI |  | 400 | 300 |  |  |  | Activity | Benchmark
Prenatal Screening | PHN |  | 600 | 550 |  |  |  |  | Hours
 |  |  |  |  |  |  |  | Restaurant Inspection | 2.5
 |  |  |  |  |  |  |  | Prenatal Screening | 1.5
 |  |  |  |  |  |  |  | Drive Home | 3
 |  |  |  |  |  |  |  | Do Dishes | 0.5
 | Total Hours by |  |  |  | Total Hours
 | Activity |  |  |  | By [NAME]
 |  |  |  |  |  |  |  | Total Service Activity Hours by
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Total
Spreadsheet: 118543d1313753977-help-with-moving-data-on-criteria-tlgltest
Sheet: TMEETING

Last Name | First Name | Occp | Dept | Team | Shift | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 |  |  |  |  |  | benefits
Babler | [NAME] | T203 | 5001 | 1201 | 1 |  |  |  |  |  | committeeman
Barger | [NAME] | T703 | 8302 | 2002 | 2 |  |  | 100 | 100 | 100
[NAME] | [NAME] | T203 | 5002 | 4202 | 2 |  |  |  |  |  | retired 2.1.11
Spreadsheet: 797347d1663838375-formula-that-links-trajectnummer-depending-on-the-date-with-the-correct-line-2022-09-22-oeldere-patko-excel-problem
Sheet: Tabel1

BSN | Trajectnummer | Reden | Datum
1111 | 100 | Opnamedatum | 2022-01-01 00:00:00
1111 | 100 | Ontslagdatum | 2022-01-02 00:00:00
1111 | 101 | Opnamedatum | 2022-01-03 00:00:00 |  |  |  |  |  | Aantal [NAME] | Kolomlabels
1111 | 101 | Ontslagdatum | 2022-01-04 00:00:00 |  |  |  |  |  | Rijlabels | 100 | 101 | Eindtotaal
 |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 1 |  | 1
 |  |  |  |  |  |  |  |  | 2022-01-02 00:00:00 | 1 |  | 1
 |  |  |  |  |  |  |  |  | 2022-01-03 00:00:00 |  | 1 | 1
 |  |  |  |  |  |  |  |  | 2022-01-04 00:00:00 |  | 1 | 1
 |  |  |  |  |  |  |  |  | Eindtotaal | 2 | 2 | 4
Spreadsheet: 330939d1404909242-difference-between-price-volume-variance-at-summary-total-level-variance-2
Sheet: Sheet1

 |  |  | Current volume | Mix | Prior volume | Mix | current price | last year price | total current | total prior | price variance | volume variance | mix variance
 |  | Product A | 5 |  | 8 |  | 1300 | 1300
 |  | Product B | 968 |  | 1273 |  | 425 | 428
 |  | Product C | 1800 |  | 2154 |  | 300 | 207
 |  | Total |  |  |  |  |  | 291.45 | 957900
 |  |  |  |  |  |  |  |  |  | Summary Level
 |  |  |  |  |  |  |  |  | Total Variance
 |  |  |  |  |  |  |  |  |  | Total Level
Spreadsheet: 801517d1666240723-lookup-and-return-1st-cell-with-value-demo_sheet_1-ans2
Sheet: Monthly Avg

 | Agent Name |  | Zopen1
 |  | QA | ACW | [NAME] | ASR | OS
 | YTD Growth
 | YTD Average
 | Starting Pojnt
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec
Spreadsheet: jonathan_mckay__16900__Area Managers
Sheet: Centennial

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | South West Arena Society-Calgary Centennial Arenas |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 999
 | February | 837
 | March | 734
 | April | 678
 | May | 288
 | June | 218
 | July | 111
 | August | 97
 | September | 296
 | October | 435
 | November | 663
 | December | 852
 | TOTAL:
Spreadsheet: 80523d1280762194-updating-monthly-total-test1-1
Sheet: 2010

Sum of Value | Column
Row | Requested
A | 2
B | 4
C | 6
D | 8
E | 10
F | 12
G | 14
H | 16
I | 18
Spreadsheet: 45a60706-0d92-419a-a72e-ff68c3e7a654
Sheet: Sheet1

V. Distribution and Processing | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
3. Fishery Processing Plants
(1) Statistics  by Sea Region
(d) Number of Plants by Share of Domestic Products among Raw Materials
 |  |  |  |  |  |  |  |  | Unit: Plant
Nationwide, sea region |  |  | Total | All imported items | Less than 30% | 30 to 50% | 50 to 70% | More than 70％ | All domestic products
Japan |  | １ | 10097 | 453 | 994 | 463 | 801 | 1949 | 5437
Hokkaido Pacific Ocean, North |  | ２ | 570 | 10 | 37 | 21 | 36 | 118 | 348
Pacific Ocean, North |  | ３ | 985 | 82 | 133 | 41 | 76 | 217 | 436
Pacific Ocean, Middle |  | ４ | 2090 | 68 | 186 | 97 | 179 | 446 | 1114
Pacific Ocean, South |  | ５ | 702 | 8 | 27 | 17 | 27 | 93 | 530
Hokkaido Japan Sea, North |  | ６ | 503 | 19 | 64 | 13 | 27 | 98 | 282
Japan Sea, North |  | ７ | 377 | 10 | 46 | 28 | 39 | 75 | 179
Japan Sea, West |  | ８ | 686 | 18 | 77 | 49 | 58 | 141 | 343
East China Sea |  | ９ | 1864 | 89 | 176 | 80 | 140 | 327 | 1052
Seto Inland Sea |  | 10 | 1172 | 84 | 121 | 53 | 97 | 191 | 626
Not coastal |  | 11 | 1148 | 65 | 127 | 64 | 122 | 243 | 527
Spreadsheet: 94860d1294620766-make-a-calendar-with-noted-birthdays-etc-my2011-2021-1-
Sheet: Dates

 | Birthdays |  | Date Number | Year | Table1 | Month | Table2 | Day
 | [NAME] | 1976-01-05 00:00:00 |  |  | [NAME] |  | [NAME] |  | Birthday
 | [NAME] | 1996-01-05 00:00:00 |  |  | [NAME] |  | [NAME] |  | Anniversary
 | [NAME] | 1981-01-23 00:00:00 |  |  | [NAME] |  | [NAME] |  | ABC
 | [NAME] | 1966-02-15 00:00:00 |  |  | [NAME] |  | [NAME] |  | DEF
Spreadsheet: 2cc2fc95-8856-4f17-82f1-bb55b65e8660
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2072 | 7518 | Rosi | Suter | SUI |  | [NAME] | [NAME] | 02:11:26 | 00:02:31 | 01:08:58 | 1 | [NAME]
Spreadsheet: 673972d1587614938-extract-numbers-from-cell-to-result-in-one-cell-or-3-cells-excel-question-1
Sheet: Sheet1

Description
21-7-14 Turf Royale Turf & Ornamental Yara Wes
Landscaper's BioNutrition 3-0-3 (20lb)
Cal-Tec 9% 6-0-0 Growth Products (2.5gal)
Bonus 0-0-7 w/ .86% Pendi (50lb)
or
21-7-14 Turf Royale Turf & Ornamental Yara Wes
Landscaper's BioNutrition 3-0-3 (20lb)
Cal-Tec 9% 6-0-0 Growth Products (2.5gal)
Bonus 0-0-7 w/ .86% Pendi (50lb)
Spreadsheet: 75819d1276404531-balance-lottery-sales-732448-lottery-tcket-sales
Sheet: Sheet1

$ | T/R | NAME | 2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 |  | Check |  | Value | Tickets / Roll
30 | 30 | Cash Spectacular | 10 | 9 | 8 |  | 30 |  | 30 | 30
30 | 30 | Cash Jackass | 29 | 28 | 28 |  | 30 |  | 20 | 30
20 | 30 | [NAME] | 20 | 19 | 18 |  | 20 |  | 10 | 60
20 | 30 | [NAME] | 12 | 12 | 11 |  | 0 |  | 5 | 120
10 | 60 | Set for Life | 31 | 31 | 29 |  | 0 |  | 3 | 100
10 | 60 | Gold Rush Jackpot | 54 | 52 | 52 |  | 20 |  | 2 | 150
10 | 60 | [NAME] | 30 | 29 | 28 |  | 10 |  | 1 | 300
10 | 60 | 250 Million Club | 14 | 11 | 9 |  | 30
10 | 60 | Super Cash | 7 | 6 | 6 |  | 10
5 | 120 | Silver 7s | 20 | 14 | 11 |  | 30
5 | 120 | Holiday Ornament | 23 | 22 | 22 |  | 5
5 | 120 | Snow Globe | 75 | 75 | 75 |  | 0
5 | 120 | Precious Pearls | 45 | 45 | 44 |  | 0
5 | 120 | Crossword | 47 | 40 | 34 |  | 35
5 | 120 | [NAME] | 111 | 109 | 109 |  | 10
5 | 120 | 8's | 112 | 112 | 111 |  | 0
5 | 120 | Cash Invasion | 84 | 84 | 84 |  | 0
5 | 120 | Slots of Money | 75 | 75 | 75 |  | 0
5 | 120 | tax | 69 | 69 | 69 |  | 0
3 | 100 | Crossword $3 | 93 | 87 | 65 |  | 18
2 | 150 | Beat the Heat | 36 | 35 | 35 |  | 2
2 | 150 | Sizzling 7 | 135 | 135 | 135 |  | 0
2 | 150 | Win 4 Life | 115 | 106 | 95 |  | 18
2 | 150 | Hot Tomale | 98 | 92 | 91 |  | 12
2 | 150 | Float the Money | 40 | 39 | 39 |  | 2
2 | 150 | Red ribon | 60 | 59 | 59 |  | 2
2 | 150 | Cure This | 136 | 132 | 132 |  | 8
2 | 150 | Double Time | 35 | 35 | 33 |  | 0
1 | 300 | License to Win | -1 | 283 | 278 |  | 16
1 | 300 | Totally | 162 | 159 | 157 |  | 3
1 | 300 | Pet Talk | 46 | 43 | 42 |  | 3
1 | 300 | [NAME] | 112 | 109 | 109 |  | 3
1 | 300 |  | 42 | 35 | 31 |  | 7
1 | 300 | Chimp Change | 126 | 124 | 124 |  | 2
1 | 300 | cheesecake | 128 | 123 | 118 |  | 5
1 | 300 | 7-11-21 | 78 | 67 | 57 |  | 11
2 | 150 | Triple Your Money | 23 | 23 | 23 |  | 0
1 | 300 | Numerous 9 | -1 | -1 | -1 |  | 0
5 | 120 | Doubler | -1 | -1 | -1 |  | 0
5 | 120 | Double 5's | -1 | -1 | -1 |  | 0
10 | 60 | Wild 10 | -1 | -1 | -1 |  | 0
5 | 120 | Bingo $5 | 118 | 113 | 113 |  | 25
3 | 100 | Bingo $3 | 40 | 39 | 37 |  | 3
2 | 150 | Bingo | 123 | 116 | 112 |  | 14
 |  | Total Sold |  | 384 | 310 |  | 384
Spreadsheet: 90115d1289879053-option-besides-using-nested-if-statements-chart-trial
Sheet: ER monthly chart

Nov
 |  | Fingers | Mis-stamp | Misfeed | Press Set-up | Press Issues | Die not written up | Human error | Stamping Misc | [NAME] | O/L Burr | Marks on part | Misassemble | Scrap Issue | [NAME] | Gauld | Splits | Breakage | Deformation | Pulled Hole | Out of Spec | [NAME]
Jan |  | 12 | 12 | 2 | 7 | 2 | 0 | 7 | 7 | 11 | 33 | 10 | 1 | 39 | 2 | 14 | 3 | 13 | 1 | 4 | 2 | 26
Feb |  | 24 | 12 | 4 | 10 | 10 | 1 | 8 | 8 | 4 | 21 | 5 | 1 | 42 | 0 | 11 | 1 | 14 | 3 | 2 | 6 | 24
Mar |  | 21 | 3 | 16 | 15 | 12 | 3 | 13 | 6 | 16 | 31 | 10 | 1 | 50 | 1 | 6 | 3 | 14 | 3 | 3 | 2 | 36
Apr |  | 16 | 7 | 15 | 16 | 16 | 4 | 11 | 3 | 13 | 20 | 10 | 0 | 50 | 0 | 7 | 5 | 9 | 4 | 3 | 9 | 22
May |  | 32 | 10 | 10 | 4 | 28 | 4 | 18 | 11 | 14 | 19 | 12 | 1 | 40 | 0 | 12 | 1 | 13 | 4 | 2 | 2 | 30
Jun |  | 35 | 4 | 4 | 12 | 16 | 1 | 17 | 17 | 11 | 29 | 21 | 2 | 56 | 0 | 22 | 3 | 14 | 2 | 2 | 1 | 32
Jul |  | 17 | 6 | 5 | 6 | 3 | 3 | 11 | 12 | 5 | 17 | 14 | 1 | 49 | 0 | 4 | 2 | 19 | 5 | 0 | 2 | 12
Aug |  | 29 | 5 | 19 | 13 | 22 | 3 | 24 | 9 | 5 | 19 | 21 | 0 | 72 | 0 | 8 | 3 | 23 | 1 | 0 | 3 | 25
Sep |  | 26 | 7 | 12 | 12 | 20 | 0 | 12 | 9 | 7 | 23 | 20 | 0 | 59 | 0 | 8 | 4 | 12 | 3 | 2 | 2 | 27
Oct |  | 31 | 8 | 10 | 10 | 13 | 2 | 22 | 1 | 8 | 16 | 11 | 0 | 53 | 0 | 8 | 2 | 16 | 1 | 1 | 1 | 16
Nov |  | 20 | 8 | 8 | 0 | 9 | 0 | 12 | 0 | 5 | 8 | 4 | 0 | 21 | 0 | 5 | 1 | 8 | 2 | 1 | 1 | 8
Dec |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 776941d1650011575-conditional-formatting-based-on-two-cells-example-projectmanagement-1-etaf
Sheet: Sheet1

 | Planning
 | Nr | Topic | Action | Description | Date | Status | Preparer | Reviewer | Involved (client, specialist, other)
 | 1 | Teamplanning | Team opbouw | Meeting within the team | 2022-04-15 00:00:00 | Completed | JO | N/a | N/A
 |  |  | Hours per period | Contact with planning | 2022-04-15 00:00:00 | Completed | JO / DS | N/a | Planning department
 | 2 | Fee schedule | Review internally | Plan time for review |  |  |  |  | Joost
 |  |  | Review externally | Plan time for review |  |  |  |  | Jan
 |  |  | Due date | Date of SB meeting | 2022-03-27 00:00:00
 |  |  | I want to create a format that when column D is filled (for a specific row), the other columns (in that row) have a yellow format when their cell is not filled. When someone enters text in column E onwards, the yellow format should disappear.
Spreadsheet: 94322d1294166308-how-to-round-up-to-closest-match-in-vlookup-example-excel-help
Sheet: Sheet1

weight | Low Ship | High Ship
0 | 1.41 | 1.41 |  | Row Labels | Average of Weight | Low Ship | High Ship
0.0625 | 1.41 | 1.41 |  | widget 1 | 0.4800000000000003
0.125 | 1.58 | 1.58 |  | widget 2 | 0.75
0.1875 | 1.75 | 1.75 |  | widget 3 | 1.879999999999999
0.25 | 1.92 | 1.92 |  | widget 4 | 0.7047368421052627
0.3125 | 2.09 | 2.09 |  | widget 5 | 0.711964285714285
0.375 | 2.26 | 2.26 |  | widget 6 | 0.6385714285714285
0.4375 | 2.43 | 2.43 |  | widget 7 | 0.53
0.5 | 2.6 | 2.6 |  | widget 8 | 0.6356896551724137
0.5625 | 2.77 | 2.77 |  | widget 9 | 0.5985714285714286
0.625 | 2.94 | 2.94 |  | widget 10 | 0.5985714285714288
0.6875 | 3.11 | 3.11 |  | widget 11 | 1.23
0.75 | 3.28 | 3.28 |  | widget 12 | 2.5
0.8125 | 3.45 | 3.45 |  | widget 13 | 2.5
1 | 5.1 | 5.75 |  | widget 14 | 2.58
2 | 5.1 | 8.29
3 | 5.65 | 10.12
4 | 6.25 | 11.77
5 | 7 | 12.54
6 | 7.7 | 13.23
7 | 8.45 | 14.35
8 | 8.76 | 15.23
9 | 9.07 | 16.1
Spreadsheet: mary_fischer__25606__31Z
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 32790d1228946461-nested-if-functions-roman-2
Sheet: Sheet5

2020 |  | 0 | 751 | 1001 | 1251 | 1501 | 1751 | 2001 | 2251 | 2501 | 2751 | 3001 | 3251 | 3501 | 3751
 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5
Profile 2116 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5
Hex Bar 2111 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5
Gear 2049 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Tape Spool 2032 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
Tape Centralizer 3056 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
Tape Ring 3073 |  | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 8
Bracket 3630 |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5
Screw 18R |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5
End Cover 2131 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Clip 2059 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Bead Chain 4845 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
2120
 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
Profile 2211 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
Hex Bar 2111 |  | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | 2.5 | 2.75 | 3 | 3.25 | 3.5 | 3.75 | 4
Gear 2049 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Tape Spool 2081 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
Tape Centralizer 3056 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
Tape Ring 3073 |  | 3 | 4 | 4 | 4 | 6 | 6 | 7 | 8 | 8 | 9 | 10 | 11 | 12 | 13
Bracket 3630 |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
Screw 18R |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8
End Cover 2179 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Clip 2059 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Bead Chain 4845 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 677824d1589544103-lookup-a-value-and-return-column-that-has-non-blank-value-trucksummary
Sheet: Truckplan

 |  | DATA |  |  |  |  |  |  |  | RESULTS
 |  | Date | Truck1 |  |  |  |  |  |  |  | Truck1
 |  |  | Zone A | Zone B | Zone C | Zone D | Zone E |  |  | Date | Zone | Planned Nr of Trips
 |  |  | Nr of trips
 |  | 2020-04-06 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-06 00:00:00 | Zone A | 4
 |  | 2020-04-07 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-07 00:00:00 | Zone A | 4
 |  | 2020-04-08 00:00:00 |  | 4 |  |  |  |  |  | 2020-04-08 00:00:00 | Zone B | 4
 |  | 2020-04-09 00:00:00 |  | 4 |  |  |  |  |  | 2020-04-09 00:00:00 | Zone B | 4
 |  | 2020-04-10 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-10 00:00:00 | Zone C | 3
 |  | 2020-04-11 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-11 00:00:00 | Zone C | 3
 |  | 2020-04-12 00:00:00 |  |  | 0 |  |  |  |  | 2020-04-12 00:00:00 | Maitenance | 0
 |  | 2020-04-13 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-13 00:00:00 | Zone C | 3
 |  | 2020-04-14 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-14 00:00:00 | Zone C | 3
 |  | 2020-04-15 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-15 00:00:00 | Zone C | 3
 |  | 2020-04-16 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-16 00:00:00 | Zone D | 2
 |  | 2020-04-17 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-17 00:00:00 | Zone D | 2
 |  | 2020-04-18 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-18 00:00:00 | Zone A | 4
 |  | 2020-04-19 00:00:00 | 0 |  |  |  |  |  |  | 2020-04-19 00:00:00 | Maitenance | 0
Spreadsheet: 66cf29ac-59d6-4999-9730-ff09533b13c7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5273 | 31382 | Wayne | Smith | RSA | 0 | 00:09:13 | 00:00:00 | 00:21:59 | 00:00:00 | 00:09:32 | 1 | [NAME]
5273 | 31380 | Chad | Hosken | RSA | 0 | 00:09:14 | 00:00:00 | 00:24:20 | 00:00:00 | 00:10:25 | 2 | 00:44:00
Spreadsheet: 860099d1708328349-repetitive-result-case-excel
Sheet: Hasil

A | B | C
Spreadsheet: 30710d1226405830-incrementing-hlookup-row-index-book1
Sheet: Sheet1

Part Number | List | ACC1 | [NAME] | ACC3 | ACC4 | ACC5 | ACC6 | ACC7 | [NAME] | ACC9 | ACC10 | 1 |  | 2
AB1 | 100 | 100 | 100 | 70 | 100 | 100 | 60 | 50 | 100 | 100 | 100
AB2 | 110 | 110 | 110 | 80 | 110 | 110 | 70 | 60 | 110 | 110 | 110
AB3 | 120 | 120 | 120 | 90 | 120 | 120 | 80 | 70 | 120 | 120 | 120
AB4 | 130 | 130 | 130 | 100 | 130 | 130 | 90 | 80 | 130 | 130 | 130
AB5 | 140 | 140 | 140 | 110 | 140 | 140 | 100 | 90 | 140 | 140 | 140
AB6 | 150 | 150 | 150 | 120 | 150 | 150 | 110 | 100 | 150 | 150 | 150
AB7 | 160 | 160 | 160 | 130 | 160 | 160 | 120 | 110 | 160 | 160 | 160
AB8 | 170 | 170 | 170 | 140 | 170 | 170 | 130 | 120 | 170 | 170 | 170
AB9 | 180 | 180 | 180 | 150 | 180 | 180 | 140 | 130 | 180 | 180 | 180
AB10 | 190 | 190 | 190 | 160 | 190 | 190 | 150 | 140 | 190 | 190 | 190
 | List | ACC1 | [NAME] | ACC3 | ACC4 | ACC5 | ACC6 | ACC7 | [NAME] | ACC9 | ACC10
Spreadsheet: 725218d1616591364-function-sumproduct-search-left-duvida
Sheet: Sheet1

C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | C8 | C9 | C10 | C11 | C12 | C13 | C14 | C15 | C16 | C17 | C18 | C19 | C20 | C21 | C22 | A | B | C
1A | 1B | 1A+1B+2C |  | 33A | 31A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1A
 | 1B | 1A+1B+2C |  | 33A | 31A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1A
 | 1B | 1A+1B+2C |  |  | 31A+31B |  |  |  |  |  |  |  |  |  |  |  |  |  | 1A |  |  | 32 | 33