tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767475d1644493830-document-reconciliation-between-databases-with-excel-and-complications-reconciliation-including-warts
Sheet: DB2

File name B | File Description B | Request URN | It should show
my file 678901 | this file contains info on 678901 and nothing else |  | 45602
this file 234567 | this file contains info on 234567 and nothing else |  | 45603
their file 123456 | this file contains info on 123456 and nothing else |  | 45601
The file 456192 | this file contains info on 456192 and nothing else |  | 45604
my file | this file contains info on 678901 and nothing else |  | 45602
this file | this file contains info on 234567 and nothing else |  | 45603
their file | this file contains info on 123456 and nothing else |  | 45601
The file | this file contains info on 456192 and nothing else |  | 45604
my file678901 | this file contains info on things and stuff and nothing else |  | 45602
this file | this file contains info on234567 and nothing else |  | 45603
their file | this file contains info on 123456and nothing else |  | 45601
The file | this file contains info on456192and nothing else |  | 45604
Spreadsheet: 64553d1265377907-problem-with-choices-disappearing-in-forms-combobox-when-selected-problem
Sheet: Sheet1

PROJECT:
PROJECT DIRECTOR:
PERIOD: | YEAR 1
STAFF: | C | J | R | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DAYS: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FULL TIME EQUIVALENT: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACTIVITY 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACTIVITY 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACTIVITY 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACTIVITY 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACTIVITY 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 143990d1330657651-using-indirect-and-vlookup-to-return-values-across-multiple-workbooks-sample-workbook-11
Sheet: Sheet1

Week 1 | CAR | OAK
 | Offense Game Stats
 |  | G | Pts/G | TotPts | Scrm [NAME] | Yds/G | Yds/P | 1st/G | [NAME] | 3rd Att | 3rd Pct | [NAME] | 4th Att | 4th Pct | Pen | Pen Yds | ToP/G | FUM | Lost | TO
 | Team
 | Opponent
 | Final Result
 |  |  | use this as first vlookup to get the numbers
 |  |  |  | table
 |  |  | Ari | 4 |  |  |  | then this number be vlookup from another worksheet
 |  |  | ATL | 5
 |  |  | BAL | 6 |  |  |  |  |  |  | VLOOKUP($J$10,'[Sample | [NAME] | 2.xlsx]Sheet1'!$A$4:$U$35,3,FALSE)
 |  |  | BUF | 7 |  |  |  |  |  |  |  |  |  |  |  |  | look at number 3 it will vary down
 |  |  | CAR | 8
 |  |  | CHI | 9
 |  |  | CIN | 10
 |  |  | CLE | 11
 |  |  | DAL | 12
 |  |  | DEN | 13
 |  |  | DET | 14
 |  |  | GB | 15
 |  |  | HOU | 16
Spreadsheet: 39418d1237564401-find-specific-trailing-letters-and-return-message-forum-question
Sheet: Sheet1

2008 Product # | 2008 Serial | 2008 Code |  | Product #'s | Codes
258MX | 170-1067 | 1181.2 |  | 103 | 2775
137MX | 35-1072A | 48C5.20 |  | 104 | 2775
251MX | 163-1058 | 4570.2 |  | 116 | 2652
274MX | 33-1070 | 2772 |  | 117 | 2641
297MX | 22-1014C | 4466.2 |  | 121 | 265H.01
139MX | 35-1076B | 48C5.20 |  | 123 | 2641
209MX | 74-1073C | 3526 |  | 124 | 2657.01
 |  |  |  | 125 | 2665.01
 | #N/A |  |  | 126 | 2665.01
 |  |  |  | 129 | 4145.2
 |  |  |  | 130 | 18P5.2
 |  |  |  | 131 | 2110
 |  |  |  | 132 | 2110
 |  |  |  | 136 | 4975.2
 |  |  |  | 137 | 48C5.20
 |  |  |  | 139 | 48C5.20
 |  |  |  | 144 | 1155.2
 |  |  |  | 151 | 2674
 |  |  |  | 152 | 4145.2
 |  |  |  | 165 | 2648.53
 |  |  |  | 166 | 7890
 |  |  |  | 168 | 7890
 |  |  |  | 171 | 2821
 |  |  |  | 179 | 2840.01
 |  |  |  | 186 | 2659
 |  |  |  | 209 | 3526
 |  |  |  | 211 | 3526
 |  |  |  | 214 | 3391
 |  |  |  | 229 | 7150
 |  |  |  | 246 | 7890.01
 |  |  |  | 247 | 7890.01
 |  |  |  | 248 | 1935.2
 |  |  |  | 249 | 1935.2
 |  |  |  | 250 | 1181.2
 |  |  |  | 251 | 4570.2
 |  |  |  | 252 | 4570.2
 |  |  |  | 255 | 7054.01
 |  |  |  | 258 | 1181.2
 |  |  |  | 274 | 2772
 |  |  |  | 275 | 2772
 |  |  |  | 294 | 4466.2
 |  |  |  | 297 | 4466.2
 |  |  |  | 300 | 6221
 |  |  |  | 302 | 44D7.20
 |  |  |  | 304 | 44D7.20
 |  |  |  | 305 | 6211
 |  |  |  | 307 | 44B6.20
 |  |  |  | 312 | 44B6.20
 |  |  |  | 334 | 7410.01
 |  |  |  | 335 | 7410.01
 |  |  |  | 336 | 7410.01
 |  |  |  | 338 | 1205.21
 |  |  |  | 340 | 44M5.2
 |  |  |  | 341 | 2556
 |  |  |  | 342 | 2556
 |  |  |  | 350 | 44M5.2
 |  |  |  | 355 | 2775.01
 |  |  |  | 356 | 2775.01
 |  |  |  | 359 | 2556
 |  |  |  | 360 | 19A5.22
 |  |  |  | 361 | 19A5.22
 |  |  |  | 363 | 8081
 |  |  |  | 364 | 8081
 |  |  |  | 366 | 2863.05
 |  |  |  | 367 | 2863.05
 |  |  |  | 370 | 4465.2
 |  |  |  | 371 | 4465.2
 |  |  |  | 378 | 44B5.20
 |  |  |  | 379 | 44B5.20
 |  |  |  | 381 | 44M5.22
 |  |  |  | 382 | 44M5.22
 |  |  |  | 383 | 1185.2
 |  |  |  | 384 | 1185.2
 |  |  |  | 385 | 44C5.20
 |  |  |  | 386 | 44C5.20
 |  |  |  | 390 | 8081.01
 |  |  |  | 402 | 3526.03
 |  |  |  | 403 | 2665.07
 |  |  |  | 404 | 2863.07
 |  |  |  | 409 | 6212.01
 |  |  |  | 410 | 6212.01
 |  |  |  | 411 | 19A5.22
Spreadsheet: 759711d1639673183-sum-column-based-on-mutiple-criteria-of-other-coulmns-sample-excel-before-and-after-copy-tms
Sheet: Sheet1

Policy Number | Status | Pay Status | Premium | Payor Name
00123456 | NA | 5 | 40 | [NAME]
00123457 | NI | 7 | 21.99 | [NAME]
00123458 | NA | 5 | 32 | [NAME]
00123459 | AP | 5 | 47.86 | [NAME]
00123460 | NA | 5 | 44.44 | [NAME]
00123461 | AP | 7 | 23.12 | [NAME]
00123462 | AP | 5 | 80.67 | [NAME]
00123463 | AP | 5 | 34.87 | [NAME]
00123464 | NA | 5 | 88.79 | [NAME]
00123465 | NI | 7 | 99.2 | [NAME]
00123466 | NA | 5 | 25.99 | [NAME]
00123467 | NA | 5 | 7.98 | [NAME]
00123468 | NA | 7 | 6.55 | [NAME]
00123469 | NA | 0 | 8.77 | [NAME]
00123470 | NI | 7 | 7.98 | [NAME]
00123471 | NA | 5 | 7.98 | April Ludgate
00123472 | NA | 5 | 8 | April Ludgate
00123473 | AP | 5 | 45.77 | [NAME]
00123474 | AP | 5 | 77.32 | [NAME]
00123475 | AP | 5 | 67.98 | [NAME]
00123476 | AP | 5 | 91.01 | [NAME]
00123477 | AP | 5 | 44.56 | [NAME]
00123478 | NI | 0 | 39.9 | [NAME]
00123479 | AP | 5 | 70.93 | [NAME]
00123480 | AP | 5 | 61.31 | [NAME]
00123481 | AP | 5 | 7.36 | [NAME]
00123482 | NA | 5 | 55.9 | [NAME]
Spreadsheet: 08a8bbcf-a45b-4044-befe-8f61801839f5
Sheet: Sheet1

Table 9--U.S. cotton textile exports, by destination | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Sep. | Oct. | Nov. |  | Nov.
Region/country | 2013 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
North America | 132579.751 | 128843.303 | 122847.239 |  | 112835.016
Bahamas | 151.794 | 125.128 | 484.947 |  | 161.439
Canada | 11607.457 | 12954.834 | 11597.249 |  | 9367.475
Costa Rica | 202.266 | 324.933 | 304.892 |  | 367.286
Dominican Republic | 23782.233 | 20492.657 | 18150.662 |  | 17776.751
El Salvador | 8509.476 | 9757.49 | 10355.078 |  | 10480.039
Guatemala | 2501.833 | 2589.328 | 2140.82 |  | 2136.458
Haiti | 875.72 | 579.934 | 847.375 |  | 613.142
Honduras | 52639.611 | 47155.603 | 46398.196 |  | 44932.29
Jamaica | 105.098 | 60.742 | 128.451 |  | 128.301
Mexico | 29636.06 | 31715.688 | 29379.928 |  | 24194.962
Nicaragua | 1752.182 | 2225.184 | 2344.211 |  | 2095.935
Panama | 262.318 | 463.484 | 321.245 |  | 153.012
South America | 5903.372 | 5540.839 | 4840.87 |  | 3206.975
Brazil | 437.094 | 470.088 | 226.844 |  | 425.806
Chile | 129.543 | 118.22 | 276.74 |  | 210.527
Colombia | 3153.92 | 3116.217 | 2990.883 |  | 1234.797
Peru | 1504.373 | 1009.161 | 782.132 |  | 498.989
Venezuela | 381.548 | 452.256 | 115.088 |  | 544.51
Europe | 3118.307 | 3245.261 | 3237.645 |  | 2883.105
Belgium | 297.998 | 397.836 | 217.432 |  | 353.987
France | 138.974 | 136.808 | 174.266 |  | 96.021
Germany | 498.581 | 536.937 | 506.012 |  | 286.109
Italy | 169.102 | 169.616 | 231.237 |  | 178.84
Netherlands | 314.988 | 324.276 | 272.415 |  | 354.607
Russia | 130.727 | 63.012 | 57.797 |  | 52.627
Turkey | 79.665 | 35.821 | 117.779 |  | 83.662
United Kingdom | 994.841 | 1092.067 | 1055.492 |  | 1029.687
Asia | 7207.24 | 11539.13 | 11471.325 |  | 10109.917
China | 4040.965 | 7837.558 | 8026.881 |  | 7442.319
Hong Kong | 357.966 | 610.052 | 463.232 |  | 439.15
India | 127.51 | 160.456 | 88.573 |  | 130.338
Israel | 61.758 | 85.614 | 131.836 |  | 79.427
Japan | 1056.38 | 846.947 | 868.409 |  | 717.875
Pakistan | 29.564 | 5 | 31.742 |  | 5.27
Saudi Arabia | 76.142 | 118.807 | 115.252 |  | 96.528
Singapore | 104.539 | 208.522 | 240.573 |  | 158.496
South Korea | 469.794 | 491.741 | 483.554 |  | 306.026
Taiwan | 123.679 | 132.454 | 128.065 |  | 85.89
United Arab Emirates | 316.256 | 189.961 | 237.548 |  | 282.496
Oceania | 763.753 | 725.302 | 689.977 |  | 729.303
Australia | 603.396 | 515.133 | 503.008 |  | 584.553
Africa | 406.906 | 367.42 | 431.398 |  | 243.207
South Africa | 67.455 | 94.738 | 27.778 |  | 76.589
World 2/ | 149979.329 | 150261.255 | 143518.454 |  | 130007.524
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 1/14/14.
Spreadsheet: 9b6ba973-146b-4cdd-bdc3-89cdfdb40e9a
Sheet: Sheet1

Break-even Analysis | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Enter your company name here
Cost Description | Fixed Costs ($) |  | Variable Costs (%)
Variable Costs
Inventory/products | 0 |  | 0
Raw materials | 0 |  | 0
Supplies | 0 |  | 0
Direct labor (includes payroll taxes) | 0 |  | 0
Other variable expense (specify) | 0 |  | 0
Other vaiable expense (specify) | 0 |  | 0
Fixed Costs
Salaries (includes payroll taxes) | 0 |  | 0
Supplies | 0 |  | 0
Repairs & maintenance | 0 |  | 0
Advertising | 0 |  | 0
Car, delivery and travel | 0 |  | 0
Accounting and legal | 0 |  | 0
Rent | 0 |  | 0
Telephone | 0 |  | 0
Utilities | 0 |  | 0
Insurance | 0 |  | 0
Taxes (Real estate, etc.) | 0 |  | 0
Interest | 0 |  | 0
Depreciation | 0 |  | 0
Miscellaneous expenses | 0 |  | 0
Other fixed expense (specify) | 0 |  | 0
Other fixed expense (specify) | 0 |  | 0
Principal portion of debt (optional) | 0 |  | 0
Owner's draw | 0 |  | 0
Total Fixed Expenses | 0
Total Variable Expenses |  |  | 0
Break-even Sales level   = | 0
Spreadsheet: 694901d1599866161-count-unique-values-if-consecutive-condition-registru1
Sheet: Foaie1

 | Name | Month | Score
 | aa | 2020-01-01 00:00:00 | 5
 | bb |  | 2
 | cc |  | 0
 | aa |  | 6
 | bb |  | 4
 | cc |  | 0 |  | count unique value if 6 months consecutive scored 0
 | aa |  | 3
 | bb |  | 0
 | cc |  | 0
 | aa |  | 2
 | bb |  | 6
 | cc |  | 0
 | aa |  | 6
 | bb |  | 8
 | cc |  | 0
 | aa |  | 3
 | bb |  | 5
 | cc |  | 0
 | aa |  | 2
 | bb |  | 7
 | cc |  | 1
Spreadsheet: 363ac5ec-a23f-4efb-a333-a62c9c50e337
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35852545 | 2013-05-08 22:19:37 | AXIS | 0 | 5 | 6 | 752090 | lespieuch | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
35852914 | 2013-05-08 22:44:21 | ALLIES | 0 | 4 | 6 | 752090 | lespieuch | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
35874971 | 2013-05-10 11:57:36 | ALLIES | 1 | 7 | 6 | 1323701 | player1323701 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
35875163 | 2013-05-10 12:27:28 | AXIS | 1 | 7 | 4 | 1323701 | player1323701 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
35921310 | 2013-05-13 09:22:33 | AXIS | 1 | 5 | 2 | 1320425 | player1320425 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
35924850 | 2013-05-13 16:50:52 | AXIS | 1 | 6 | 4 | 208140 | albanrey | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
35925271 | 2013-05-13 17:18:04 | ALLIES | 0 | 4 | 6 | 208140 | albanrey | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
35979472 | 2013-05-17 10:22:54 | AXIS | 1 | 6 | 4 | 1249879 | player1249879 | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
35979580 | 2013-05-17 10:45:32 | ALLIES | 1 | 6 | 2 | 1249879 | player1249879 | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
35987952 | 2013-05-17 23:52:56 | ALLIES | 1 | 6 | 4 | 29893 | Marsupilami 44 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
35988494 | 2013-05-18 00:15:17 | AXIS | 0 | 2 | 6 | 29893 | Marsupilami 44 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
Spreadsheet: 723712d1615846938-vlookup-on-top-of-the-vlookup-with-if-statement-help-example-data
Sheet: Sheet1

Name | Quantity Tier | Rate
Shop1 | 10 | 1
Shop1 | 20 | 2
Shop1 | 30 | 3
Shop2 | 1 | 0.1
Shop2 | 5 | 0.05
Shop2 | 10 | 100
Shop2 | 20 | 50
Shop3 | 100 | 30
Example output
Name | Quantity | Total Amount | Expected Outcome
Shop1 | 14 |  | 14*1=14
Shop2 | 7 |  | 7*0.05=0.35
Shop2 | 18 |  | 18*100=1800
Shop3 | 80 |  | 80*30=2400
Spreadsheet: 873149d1719581210-overlapping-schedule-conditional-formatting-issue-sync_tool_final_draft_fna
Sheet: Hourly Plan_new_edit

 | Starting Date |  | 2024-03-01 00:00:00
 |  |  | 0
ID | Measurement Station | Start Date & Time | End Date & Time | Start Date & Time Gamry1 | End Date & Time Gamry1 | Start Date & Time Gamry2 | End Date & Time Gamry2 | Start Date & Time Gamry3 | End Date & Time Gamry3 | Start Date & Time Gamry4 | End Date & Time Gamry4 | Start Date & Time Gamry5 | End Date & Time Gamry5 | Start Date & Time Gamry6 | End Date & Time Gamry6 | Start Date & Time Gamry7 | End Date & Time Gamry7 | Start Date & Time Gamry8 | End Date & Time Gamry8 | Start Date & Time Gamry9 | End Date & Time Gamry9 | Start Date & Time Gamry10 | End Date & Time Gamry10
1 | MS1 | 2024-03-01 08:00:00 | 2024-03-03 11:00:00
2 | MS2 | 2024-03-01 15:00:00 | 2024-03-03 15:00:00
3 | MS3
4 | MS4
5 | [NAME]
6 | MS6
7 | MS7
8 | MS8
Credit: ExcelAir
Spreadsheet: 135a8740-0742-4c26-9b0d-f0e2828fadac
Sheet: Sheet1

Product Additions | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
SIN | Part Number | Product Name | Commercial List Price | [NAME] | Discount to GSA | Relationship | Proposed GSA Price | Proposed GSA Price including IFF | Delivery | FOB Point | COO
398-59 | 105978 | [NAME] | 200 | 0.05 | 0.1 | 0.05 | 180 | 181.360201511335 | 30 days | Destination | USA
Spreadsheet: 732480d1620986361-if-or-long-thread-or-sumproduct-or-other-help-book-1-
Sheet: Sheet1

select from datalist | Group |  |  |  | groups | list
apple |  |  |  |  | pets | dog
 |  |  |  |  | pets | cat
 |  |  |  |  | pets | parrot
 |  |  |  |  | fruit | apple
 |  |  |  |  | fruit | pear
 |  |  |  |  | sports | tennis
 |  |  |  |  | sports | soccor
Spreadsheet: louise_kitchen__23075__NETCO_HR
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
Neil Davies
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tana Cashion
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Reserve List
[NAME]
[NAME]
[NAME].
Spreadsheet: 119822d1314776858-data-processing-questions-example-excel-help
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 |  | 2 | "=COUNTIF(A1:E6;1)"
6 | 7 | 8 | 9 | 10 |  | Yes | "=IF(OR(A1=1;B1=1;C1=1;D1=1;E1=1);IF(OR(A1=2;B1=2;C1=2;D1=2;E1=2);"Yes";"NO"))"
4 | 6 | 8 | 10 | 13 |  | False
1 | 6 | 5 | 7 | 3
2 | 4 | 8 | 6 | 3
4 | 6 | 2 | 3 | 9
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: Canada Gas

Canada Gas
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Canada |  | 334057
Sangwine |  | Gas |  | Canada |  | 227075
Le Dain |  | Gas |  | Canada |  | 129997
[NAME] |  | Gas |  | Canada |  | 78971
Hrap |  | Gas |  | Canada |  | 56305
Oh |  | Gas |  | Canada |  | 50042
Burnham |  | Gas |  | Canada |  | 26409
Laporte |  | Gas |  | Canada |  | 4021
Total
Spreadsheet: 98cbcf3a-0a3f-4400-a6b8-ef0581b854b7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
265444 | 80299 | Dougles | Carver | MRI | 47 | 00:11:47 | 00:00:22 | 00:34:41 | 00:00:15 | 00:20:10 | 1 | 01:07:15 | Junior Men
265444 | 72634 | Gregory | Ernest | MRI | 11 | 00:10:49 | 00:00:23 | 00:38:21 | 00:00:25 | 00:22:02 | 2 | [NAME] | Junior Men
265444 | 80300 | Giovani | [NAME] | MRI | 50 | 00:09:50 | 00:00:14 | 00:41:38 | [NAME] | 00:23:39 | 3 | 01:15:39 | Junior Men
265445 | 55419 | [NAME] | [NAME] | MRI | 43 | 00:12:41 | 00:00:25 | 00:44:48 | 00:00:25 | [NAME] | 1 | 01:25:58 | Junior Women
265445 | 55420 | Georgia | Zheemba | MRI | 44 | [NAME] | [NAME] | 01:00:55 | [NAME] | [NAME] | 2 | 01:43:52 | Junior Women
Spreadsheet: 694241d1599473960-condensing-down-like-items-in-a-material-list-2020-09-05-oeldere2-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-e
Sheet: PT3

Som [NAME] |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type
Group | Color | Size | Material Type | Totaal |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
[NAME] | black | 1" | Alloy Steel | 61 |  |  |  |  |  | Inside Bolt1 / Inside Bolt3 /  Inside Bolt4 | 36 | 1" | green | Stainless Steel
Inside Bolt1 / Inside Bolt3 /  Inside Bolt4 | green | 1" | Stainless Steel | 36 |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
Inside Bolt2 | red | 1" | Stainless Steel | 4 |  |  |  |  |  | Middle Bolt / Undermount Bolt1 | 20 | 1-1/2" | red | Stainless Steel
Middle Bolt / Undermount Bolt1 | red | 1-1/2" | Stainless Steel | 20 |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
Right Bolt | red | 2" | Zinc Plated | 12 |  |  |  |  |  | Top Bolt / Outside Bolt | 0 | 1-3/4" | black | Stainless Steel
Top Bolt / Outside Bolt | black | 1-3/4" | Stainless Steel | 69 |  |  |  |  |  | Undermount Bolt2 / Undermount Bolt3 /  Undermount Bolt4 | 28 | 1" | silver | Stainless Steel
Undermount Bolt2 / Undermount Bolt3 /  Undermount Bolt4 | silver | 1" | Stainless Steel | 28
UNKNOWN | green | 1" | Alloy Steel | 0
Spreadsheet: 849552d1699982577-sum-output-per-year-excel-example
Sheet: Sheet1

Delivery Plan |  |  |  |  |  |  |  |  |  |  |  | Summary - Output
Tranche 1 | Quantity 1 | Tranche 2 | Quantity 2 | Tranche 3 | Quantity3 | Tranche 4 | Quantity 4 | Tranche 5 | Quantity 5 | Tranche 6 | Quantity 6 | 2022 | 2023 | 2024 | 2025
2023-01-01 00:00:00 | 50
2023-11-01 00:00:00 | 10
2024-10-01 00:00:00 | 5
2025-08-01 00:00:00 | 70
2023-07-01 00:00:00 | 25
2022-01-01 00:00:00 | 6
2024-02-01 00:00:00 | 3
Spreadsheet: 758644d1638979729-extracting-same-cell-data-from-multiple-worksheets-variation-tracker-rev-2-
Sheet: 1

NCE Reference:
Description of work | Test
Date:
QTY | Scope of Work Reference | Qty | Unit | Rate | Cost
 | STAFF
1 | Project Manager | 10 | Hours | 30
 | Staff Sub-Total | 0
 | Mark up Percentage | 0.16
 | Staff Total
 | LABOUR
1 | Project Manager | 10 | Hours | 30
 | Labour Sub-Total | 0
 | Mark up Percentage | 0.16
 | Labour Total
 | PLANT
1 | Project Manager | 10 | Hours | 30
 | Plant Sub-Total | 0
 | Mark up Percentage | 0.16
 | Plant Total
 | PERMANENT MATERIALS
1 | Project Manager | 10 | Hours | 30
 | Perm Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Perm Materials Total
 | TEMPORARY MATERIALS
1 | Project Manager | 10 | Hours | 30
 | Temp Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Temp Materials Total
 | SUBCONTRACTOR
1 | Project Manager | 10 | Hours | 30
 | [NAME] | 0
 | Mark up Percentage | 0.16
 | Subcontractor Total
 | OH/P
 | GRAND TOTAL
 | EOT |  |  | 2 | Days
Spreadsheet: 217176d1361998383-find-add-and-return-values-from-multiple-worksheets-time-spent-on-course
Sheet: Totals

Name | English | French | Geography | History | Maths | Science | 0 | 0 | 0 | 0 | 0
Adam | 4 | 0 | 0 | 0 | 5 | 7 | 0 | 0 | 0 | 0 | 0
Eve | 3 | 3 | 1 | 2 | 5 | 2 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 5 | 2 | 6 | 2 | 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 | 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
Spreadsheet: 107873d1305022207-how-to-best-use-sumif-and-if-function-book2
Sheet: Sheet1

 | stock
week | Cover | sales | stock
1 | 12 | 10 | xxxxx
2 | 10 | 10
3 | 10 | 10
4 | 10 | 10
5 | 10 | 10
6 | 10 | 10
7 | 10 | 10
8 | 10 | 10
9 | 10 | 10
10 | 10 | 10
11 | 10 | 10
12 | 10 | 10
13 | 10 | 10
14 | 10 | 10
15 | 10 | 10
16 | 10 | 10
17 | 10 | 10
18 | 10
 | Stock is based on summing column c by the stock cover column. So in week one I have 12
 | weeks of stock required. This based on sales of 10 each week this would give me 120 in D6
 | In week 2 this would be 100 (summing 10 weeks forward on the sales column from c7 to c16
Spreadsheet: 668509d1584885173-how-to-extract-specific-hourly-rows-based-on-the-maximum-daily-value-in-a-column-index-match-from-maxif-table
Sheet: sheet1

DAY | HOUR | Counter A | Counter B | Counter C | Counter D | Flag |  |  |  |  |  |  | Flag | x
2020-03-09 00:00:00 | 00:00:00 | 28 | 18 | 45 | 34
 | 01:00:00 | 21 | 45 | 25 | 21 |  |  | [NAME] | [NAME] |  |  |  |  |  | Valori
 | 02:00:00 | 41 | 31 | 31 | 10 |  |  | 2020-03-09 00:00:00 | 50 |  |  |  | DAY | HOUR | Somma di Counter A | Somma di Counter B | Somma di Counter C | Somma di Counter C2
 | 03:00:00 | 46 | 44 | 38 | 50 |  |  | 2020-03-10 00:00:00 | 47 |  |  |  | 2020-03-09 00:00:00 | 14:00:00 | 24 | 15 | 50 | 35
 | 04:00:00 | 30 | 11 | 30 | 34 |  |  | Totale complessivo | 50 |  |  |  | 2020-03-10 00:00:00 | 07:00:00 | 29 | 25 | 47 | 14
 | 05:00:00 | 47 | 19 | 24 | 24
 | 06:00:00 | 20 | 35 | 36 | 49
 | 07:00:00 | 24 | 35 | 32 | 26
 | 08:00:00 | 11 | 44 | 43 | 24
 | 09:00:00 | 50 | 21 | 41 | 26
 | 10:00:00 | 27 | 14 | 26 | 40
 | 11:00:00 | 21 | 46 | 18 | 31
 | 12:00:00 | 24 | 10 | 34 | 41
 | 13:00:00 | 37 | 40 | 40 | 11
 | 14:00:00 | 24 | 15 | 50 | 35 |  |  |  |  |  |  |  | 2020-03-09 00:00:00
 | 15:00:00 | 42 | 18 | 21 | 38 |  |  |  |  |  |  |  | 2020-03-10 00:00:00
 | 16:00:00 | 50 | 17 | 11 | 37
 | 17:00:00 | 40 | 32 | 17 | 49 |  |  |  |  |  |  |  | Fill in Dates Manually Above
 | 18:00:00 | 11 | 37 | 40 | 12 |  |  |  |  |  |  |  | Drag yellow formula across and down.  Make sure cells are formatted correctly.
 | 19:00:00 | 30 | 32 | 28 | 15
 | 20:00:00 | 38 | 21 | 20 | 32
 | 21:00:00 | 22 | 23 | 43 | 30
 | 22:00:00 | 43 | 15 | 24 | 46
 | 23:00:00 | 34 | 33 | 17 | 46
2020-03-10 00:00:00 | 00:00:00 | 13 | 43 | 23 | 28
 | 01:00:00 | 16 | 27 | 20 | 18
 | 02:00:00 | 30 | 36 | 31 | 11
 | 03:00:00 | 46 | 17 | 10 | 16
 | 04:00:00 | 44 | 26 | 41 | 27
 | 05:00:00 | 34 | 35 | 15 | 30
 | 06:00:00 | 42 | 25 | 40 | 41
 | 07:00:00 | 29 | 25 | 47 | 14
 | 08:00:00 | 46 | 36 | 24 | 31
 | 09:00:00 | 14 | 14 | 15 | 15
 | 10:00:00 | 28 | 21 | 18 | 22
 | 11:00:00 | 32 | 41 | 30 | 23
 | 12:00:00 | 15 | 39 | 13 | 17
 | 13:00:00 | 31 | 17 | 27 | 45
 | 14:00:00 | 31 | 21 | 21 | 35
 | 15:00:00 | 45 | 11 | 14 | 14
 | 16:00:00 | 15 | 14 | 14 | 44
 | 17:00:00 | 16 | 23 | 34 | 46
 | 18:00:00 | 34 | 43 | 14 | 30
 | 19:00:00 | 32 | 21 | 22 | 49
 | 20:00:00 | 23 | 46 | 28 | 46
 | 21:00:00 | 45 | 38 | 10 | 47
 | 22:00:00 | 36 | 10 | 27 | 48
 | 23:00:00 | 22 | 36 | 33 | 42