tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: IND

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 60 | 00:01:27.249000 | 1 |  | 1 |  | 00:01:24.178000
2 | [NAME] |  |  | 18 | 60 | 00:01:27.967000 | 4 |  | 2 |  | 00:01:24.950000
3 | [NAME] |  |  | 15 | 60 | 00:01:27.953000 | 3 |  | 3 |  | 00:01:24.519000
4 | [NAME] |  |  | 12 | 60 | 00:01:27.520000 | 2 |  | 4 |  | 00:01:24.508000
5 | [NAME] |  |  | 10 | 60 | 00:01:28.549000 | 11 |  | 5 |  | 00:01:26.337000
6 | [NAME] |  |  | 8 | 60 | 00:01:28.600000 | 7 |  | 6 |  | 00:01:25.451000
7 | [NAME] |  |  | 6 | 60 | 00:01:28.721000 | 5 |  | 7 |  | 00:01:24.474000
8 | [NAME] |  |  | 4 | 59 | 00:01:29.239000 | 10 |  | 8 |  | 00:01:26.319000
9 | [NAME] |  |  | 2 | 59 | 00:01:29.289000 | 8 |  | 9 |  | 00:01:26.140000
10 | [NAME] |  |  | 1 | 59 | 00:01:29.345000 | 20 |  | 10 |  | 00:01:27.562000
11 | [NAME] |  |  | 0 | 59 | 00:01:29.289000 | 16 |  | 11 |  | 00:01:26.319000
12 | [NAME] |  |  | 0 | 59 | 00:01:29.310000 | 14 |  | 12 |  | 00:01:26.651000
13 | [NAME] |  |  | 0 | 59 | 00:01:28.679000 | 12 |  | 13 |  | 00:01:26.503000
14 | [NAME] |  |  | 0 | 58 | 00:01:30.294000 | 18 |  | 14 |  | 00:01:28.565000
15 | [NAME] |  |  | 0 | 58 | 00:01:28.635000 | 15 |  | 15 |  | 00:01:27.247000
16 | [NAME] |  |  | 0 | 57 | 00:01:31.990000 | 21 |  | 16 |  | 00:01:30.866000
17 | Narain Karthikeyan |  |  | 0 | 57 | 00:01:31.998000 | 24 |  | 17 |  | 00:01:30.238000
18 | [NAME] |  |  | 0 | 57 | 00:01:31.674000 | 23 |  | 18 |  | 00:01:30.216000
19 | Jarno [NAME] |  |  | 0 | 55 | 00:01:31.691000 | 19 |  | 19 |  | 00:01:28.752000
20 | [NAME] |  |  | - | 32 | 00:01:30.243000 | 6 |  | RET |  | 00:01:25.122000
21 | Sebastien Buemi |  |  | - | 24 | 00:01:30.956000 | 9 |  | RET |  | 00:01:26.161000
22 | Pastor Maldonado |  |  | - | 12 | 00:01:33.573000 | 13 |  | RET |  | 00:01:26.537000
23 | [NAME] |  |  | - | 2 | 00:02:09.008000 | 22 |  | RET |  | 00:01:34.046000
24 | [NAME] |  |  | - | 0 |  | 17 |  | RET |  | 00:01:27.876000
Spreadsheet: 868416d1715162058-calculating-summary-sheet-using-indirect-function-for-multiple-months-yiyi2-payroll-example
Sheet: Apr-2024

Emp Code | [NAME] | Date | Roster Schedule | Roster Location | Start Time | End Time | Roster TTL excl Lunch | FT Official Hour | Place | Clock In | Clock Out | Lunch | Lateness | Early Leave | Overtime | Total Hours | Compare
147 | [NAME] | 2024-03-01 00:00:00 | 10:15-19:15 |  |  |  |  |  | OP | 10:10:00 | 19:15:00 | 1
147 | [NAME] | 2024-03-02 00:00:00 | 09:15-15:30 |  |  |  |  |  | OP | 09:31:00 | 15:32:00 | 1
147 | [NAME] | 2024-03-03 00:00:00 | Off-1
147 | [NAME] | 2024-03-04 00:00:00 | 09:30-19:00 |  |  |  |  |  | OP | 10:19:00 | 19:00:00 | 1
147 | [NAME] | 2024-03-05 00:00:00 | Off-6
147 | [NAME] | 2024-03-06 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:16:00 | 19:11:00 | 1
147 | [NAME] | 2024-03-07 00:00:00 | 11:45-21:00 |  |  |  |  |  | OW | 12:19:00 | 21:01:00 | 1
147 | [NAME] | 2024-03-08 00:00:00 | 09:30-18:30 |  |  |  |  |  | OP | 10:21:00 | 19:00:00 | 1
147 | [NAME] | 2024-03-09 00:00:00 | 11:45-21:00 |  |  |  |  |  | OW | 12:20:00 | 22:00:00 | 1
147 | [NAME] | 2024-03-10 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 10:07:00 | 19:36:00 | 1
147 | [NAME] | 2024-03-11 00:00:00 | 11:45-21:00 |  |  |  |  |  | OW | 12:25:00 | 21:03:00 | 1
147 | [NAME] | 2024-03-12 00:00:00 | Off-7
147 | [NAME] | 2024-03-13 00:00:00 | 11:45-21:00 |  |  |  |  |  | OW | 12:20:00 | 21:00:00 | 1
147 | [NAME] | 2024-03-14 00:00:00 | Off-1
147 | [NAME] | 2024-03-15 00:00:00 | Off-4
147 | [NAME] | 2024-03-16 00:00:00 | 11:45-22:00 |  |  |  |  |  | OW | 12:18:00 | 22:08:00 | 1
147 | [NAME] | 2024-03-17 00:00:00 | 11:45-22:00 |  |  |  |  |  | OP | 09:40:00 | 17:34:00 | 1
147 | [NAME] | 2024-03-18 00:00:00 | 09:30-19:15 |  |  |  |  |  | OP | 09:58:00 | 19:24:00 | 1
147 | [NAME] | 2024-03-19 00:00:00 | Off-5
147 | [NAME] | 2024-03-20 00:00:00 | 09:30-19:15 |  |  |  |  |  | OP | 10:07:00 | 19:18:00 | 1
147 | [NAME] | 2024-03-21 00:00:00 | 10:15-19:15 |  |  |  |  |  | OP | 10:51:00 | 19:22:00 | 0.5
147 | [NAME] | 2024-03-22 00:00:00 | 09:30-18:30 |  |  |  |  |  | OP | 10:04:00 | 18:38:00 | 0.75
147 | [NAME] | 2024-03-23 00:00:00 | 09:30-19:00 |  |  |  |  |  | OP | 09:47:00 | 16:16:00 | 1
147 | [NAME] | 2024-03-24 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:17:00 | 19:15:00 | 1
147 | [NAME] | 2024-03-25 00:00:00 | 11:45-21:00 |  |  |  |  |  | OW | 12:12:00 | 21:23:00 | 1
147 | [NAME] | 2024-03-26 00:00:00 | Off-4
147 | [NAME] | 2024-03-27 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:16:00 | 19:19:00 | 1
147 | [NAME] | 2024-03-28 00:00:00 | 09:15-19:15 |  |  |  |  |  | OP | 09:07:00 | 19:16:00 | 1
147 | [NAME] | 2024-03-29 00:00:00 | 09:30-19:00 |  |  |  |  |  | OP | 09:56:00 | 19:03:00 | 1
147 | [NAME] | 2024-03-30 00:00:00 | Off-1
147 | [NAME] | 2024-03-31 00:00:00 | SL-1
Total
 |  |  |  |  |  |  |  |  |  |  |  |  | EG
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 8.3
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.04027777777777778
Spreadsheet: 122060d1316593826-return-column-numbers-based-on-values-example-16-
Sheet: Sheet1

Jan | Feb | Mar | Apr | Mai | Jun | Jul | Aug
 |  | 2775000 |  |  |  |  | 4625000 |  |  |  | 3 | 0 | 0 | 0 | 0 | 8
 |  | 1230000 |  |  | 2050000 |  | 2050000 |  |  |  | 3 | 0 | 0 | 6 | 0 | 8
 |  |  | 347433.6 |  | 579056 | 579056 |  |  |  |  | 0 | 4 | 0 | 6 | 7 | 0
 |  |  |  | 1865736 | 3109560 | 3109560 |  |  |  |  | 0 | 0 | 5 | 6 | 7 | 0
 |  |  |  | 575000 | 575000 | 575000 |  |  |  |  | 0 | 0 | 5 | 6 | 7 | 0
 |  |  |  | 120000 |  |  |  |  |  |  | 0 | 0 | 5 | 0 | 0 | 0
 |  |  | 660000 |  |  |  |  |  |  |  | 0 | 4 | 0 | 0 | 0 | 0
 |  |  |  | 550000 |  | 2475000 |  |  |  |  | 0 | 0 | 5 | 0 | 7 | 0
 |  |  |  |  |  |  |  |  |  |  | 3 | 8
 |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 8
 |  |  |  |  |  |  |  |  |  |  | 4 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5 | 7
Spreadsheet: 761232d1640745099-help-with-multiple-formulas-in-spreadsheet-for-stock-trades-dads-stocks_tda-new_wash-upload
Sheet: Portfolio Performance

Overall Performace |  |  |  | Realized Gains / Losses  (Inc Fees) |  |  |  | Net Realized Gains / Losses |  |  |  | [NAME]
 |  | Cost of Current Positions
 |  | Unrealized Value of Current Positions
 |  | [NAME] |  |  | Statement Balancing Tool
 |  | Realized Gains / Losses (Inc Fees) |  |  | Start Date | End Date
 |  | Taxes |  |  | 2019-01-01 00:00:00 | 2021-04-30 00:00:00
 |  | Net Realized Gains / Losses
 |  | Withdrawals
 |  | Available Capital
 |  | Account Value:
Deposits |  |  |  |  |  |  | Withdrawals / Fees
Comments |  |  |  | Date | Amount |  | Comments |  |  |  | Date | Amount
Starting Balance |  |  |  | 2019-05-01 00:00:00 | 1501.32
Interest |  |  |  | 2019-05-31 00:00:00 | 0.09
Interest |  |  |  | 2019-06-25 00:00:00 | 0.02
Deposit |  |  |  | 2021-03-19 00:00:00 | 5000
Interest |  |  |  | 2021-03-31 00:00:00 | 0.01
Rounding Error? |  |  |  | 2021-03-31 00:00:00 | 0.02
Interest |  |  |  | 2021-04-28 00:00:00 | 0.01
 |  |  |  | Total |  |  |  |  |  |  | Total
Spreadsheet: joe_parks__14578__EES Nymex & Basis Mar 21
Sheet: Central Basis

Central Basis positions
Year | Index | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | TOTAL
2002 | IF-NGPL/MIDCON | - - | - - | - - | 84508 | 61533 | 41183 | 38490 | 38495 | 62382 | - - | - - | - - | 326592
 | NGI/CHI. GATE | - - | - - | - - | -213950 | -144114 | -108572 | -99072 | -98512 | -131443 | -95927 | -152005 | -215172 | -1258768
2003 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -228844 | -182754 | -149542 | -104409 | -65880 | -56102 | -49707 | -52093 | -57922 | -66333 | -92508 | -112297 | -1218391
2004 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -112829 | -88227 | -77421 | -53387 | -43114 | -23879 | -20499 | -20325 | -19957 | -22184 | -27139 | -33287 | -542248
2005 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -32428 | -26138 | -21303 | -16273 | -11695 | -9884 | -8551 | -9862 | -9630 | -12605 | -15454 | -22579 | -196402
2006 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -22218 | -17014 | -13008 | -8918 | -6319 | -4239 | -3768 | -5040 | -4059 | -3930 | -3689 | -4905 | -97106
2007 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -4618 | -3198 | -2641 | -1112 | -572 | -501 | -485 | -505 | -527 | -519 | -582 | -790 | -16049
2008 | IF-NGPL/MIDCON | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | - - | 0
 | NGI/CHI. GATE | -751 | -516 | -166 | -154 | -136 | -127 | -125 | -114 | - - | - - | - - | - - | -2087
TOTAL |  | -401687 | -317846 | -264080 | -313694 | -210297 | -162121 | -143717 | -147956 | -161156 | -201498 | -291377 | -389030 | -3004460
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ | 1.98
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG | 2.04
 |  |  |  |  |  | NTXPH | 2.07
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Duke Energy Field Service SW |  |  | 2001-11-30 00:00:00 | Dollar Valued | [NAME]
Duke Energy Trading &Mktg |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Vol/$value | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
Mojave Pipeline |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Dominion Gas Ventures |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DEFS,LP | 23995 | -1023166 | Hobbs plant
[NAME] |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 22051 | -527215 | Artesia plant
Amarillo Nat Gas |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 22864 | -58339.66 | inactive
El Paso Field Services |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 20379 | -51695.87 | inactive
Agave |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 26357 | 44144.84 | inactive
Calpine |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 21544 | 61340.16 | inactive
Citizens-Griffith |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DEFS,LP | 24532 | -956477
Northwest |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DEFSSW | 24268 | 1481856.66
[NAME] |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DE T&M | 24693 | 275313.72
CIG |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DE T&M | 24361 | 811179.69
Continental |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  | DE T&M | 21665 | 73449
Lonestar |  |  |  | Volumetric | [NAME] |  |  |  |  |  | DE T&M | 22664 | 23612
TransColorado |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Duke Energy Field Services LP |  |  | 2001-11-30 00:00:00 | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Crosstex Energy Serv |  |  |  | Dollar Valued | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
El Paso |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME]
WTG Gas Marketing |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 117621d1312913703-counting-dates-and-dollar-ranges-sample
Sheet: Monthly Summary

Month | # [NAME] | # Accidents <= $5000
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
Spreadsheet: 25629d1217009283-inserting-a-numerical-1-or-0-into-a-cell-depending-on-the-values-of-two-other-cells-book18
Sheet: Sheet1

 | TEST 1: |  |  |  | Condition 1: | Condition 2: |  |  |  | Condition 1: | Condition 2:
 |  |  |  |  | 2 | 5 |  |  |  | 1 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  | 2 | 7 | 8 | 9
 |  |  | [NAME] | Alt. 1: | 0 | 0 |  |  |  | 3 | 9 | 10 | 11
 |  |  |  | Alt. 2: | 0 | 0 |  |  |  | 4 | 9 | 10 | 11
 |  |  |  | Delimiter in Europe: Row=;   Column=\
 |  |  |  | Delimiter in English: Row=,   Column=;
 |  |  |  | Decimal separator: Europe=, |  |  | Thousand separator: Europe=Blank
 |  |  |  | Decimal separator: English=. |  |  | Thousand separator: English=,
 | TEST 2: |  |  |  | Condition 1: | Condition 2: |  |  |  | Condition 1: | Condition 2:
 |  |  |  |  | 7 | 2 |  |  |  | 1 | 3 | 8 | 0
 |  |  |  |  |  |  |  |  |  | 2 | 2 | 8 | 1
 |  |  |  |  |  |  |  |  |  | 3 | 2 | 9 | 1
 |  |  | [NAME] | Alt. 1: | 0 |  |  |  |  | 4 | 1 | 7 | 1
 |  |  |  |  |  |  |  |  |  | 5 | 1 | 9 | 0
 |  |  |  |  |  |  |  |  |  | 6 | 1 | 7 | 1
 |  |  |  |  |  |  |  |  |  | 7 | 4 | 11 | 1
Spreadsheet: 814773d1674581890-please-help-in-if-formulae-book1
Sheet: Sheet1

My Formulae | Output Required | Key | Exp
 | 0 | 421 | 28
 | 0 | 422 | 67
 | 1 | 422 | -63
 | 2 | 422 | 60
 | 3 | 422 | 55
 | 4 | 422 | 50
 | 5 | 422 | 45
 | 6 | 422 | -41
 | 1 | 423 | -80
 | 2 | 423 | -70
 | 3 | 423 | -60
 | 4 | 423 | 50
 | 0 | 424 | 60
 | 0 | 424 | 50
 | 1 | 424 | -6
Spreadsheet: 692153d1598126203-combine-payments-to-specific-payment-days-but-split-at-crossover-point-between-2-months-month-end-v3
Sheet: Holidays

Holiday | Country | Date
Holiday 1 | AT | 2020-08-24 00:00:00
Holiday 2 | US | 2020-08-24 00:00:00
Holiday 3 | SG | 2020-09-18 00:00:00
Holiday 4 | BE | 2020-08-14 00:00:00
Holiday 5 | UK | 2020-09-15 00:00:00
Holiday 6 | NL | 2020-09-15 00:00:00
Holiday 7 | UK | 2020-09-18 00:00:00
Holiday 8 | AT | 2020-08-14 00:00:00
Holiday 9 | AT | 2020-08-21 00:00:00
Holiday 10 | US | 2020-08-21 00:00:00
Holiday 11 | US | 2020-08-31 00:00:00
Holiday 12 | UK | 2020-12-31 00:00:00
Holiday 13 | AT | 2020-12-31 00:00:00
Holiday 14 | DE | 2021-03-31 00:00:00
Holiday 15 | BE | 2021-06-30 00:00:00
Spreadsheet: 703404d1604983503-calculate-cumulative-sums-and-obtain-highest-value-based-on-it-tats-glenn
Sheet: Output

Select year
2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This table should show the highest volumes processed for each month, of the selected year
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  | I was able to complete most of this table, except for the highlighted cells:
 | Data1: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T10 should show the highest total volumes processed by any single agent, for the entire selected year
 | Agent: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T11 should show the agent that achieved T10
 | Highest volumes processed in any single year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This table should show the highest volumes processed for each month, for any single year
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Highest |  | I was able to complete most of this table too, except for the highlighted cells:
 | Data1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] should show the highest total volumes processed by any single agent, for any single year
 | Agent: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T21 should show the agent that achieved [NAME]
 | Year: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T22 should show the year of T20 achievement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This table should show the highest cumulative volumes processed over subsequent months, of the selected year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e.g. Cumulative highest as at each month
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  | e.g. Apr should show the highest Data1 value, after the corresponding Jan+Feb+Mar+Apr is added
 | Data1
 | Agent:
 | Cumulative highest volumes processed in all years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This table should show the highest cumulative volumes processed over subsequent months, for all years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e.g. Cumulative highest as at each month (i.e. Highest up to all Aprils)
 |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  | e.g. Apr should show the highest Data1 value, after the corresponding Jan+Feb+Mar+Apr is added of all years
 | Data1
 | Agent:
 | Year:
Spreadsheet: 877792d1724709776-how-to-list-column-without-duplicates-by-formula-list-all-sn-without-duplicates
Sheet: Sheet1

 | 203217303051017418151142 |  |  |  | in this way I do not know why not all SN added there are 3 not exist |  | this way it is working to add all but if there is duplicate values it is removing all of it I want to keep just 1
 | 202917303051017417549365
 | 190802203051017408043796
 | 190802203051017408042864
 | 320612455
 | 320693287
 | 332303365
 | 202967303051017417658014
 | 190802203051017408043425
 | 190802203051017408043681
 | 211417303061211220933148
 | 190552203051017407962314
 | CND1202BT5
 | 211437303061211220954484
 | 202917303051017417549365
 | 202967303051017417658014
 | 202917303051017417549365
Spreadsheet: 680482d1591041648-how-to-enlist-specific-information-in-a-tab-referring-to-another-tab-how-to-enlist-specific-information-in-a-tab-referring-to-another-tab-v3-daniel-1973-
Sheet: Blad2

 | (WC = World Championship)
Disired situation tab 2
Name |  |  | Finish | WC | WC
Spreadsheet: 70113d1270774855-pulling-info-out-of-an-old-layout-oct-08-example
Sheet: 10-27-08 1st

Daily Problem Report |  |  |  |  |  | 1st shift |  | Date |  | 2008-10-27 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 4 |  | 8.5 |  | 3.7
PR |  | 4 |  |  |  | 2.3
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 5-2 | 48733/4-08010-00 |  | Problem: O/L burr |  |  | Station:prog |  | Ran:200            of       400 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Chip in lower cutter |  |  | 6:55-7:10
CM: |  |  |  |  | Explain: | This die was pulled to the shop for repairs. |  |  |  |  | [NAME]
Stamping T/L: [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 5-1 | 48514-0C010-T1 |  | Problem: Hole burr |  |  | Station:5/5 |  | [NAME]          of     640 | 0
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Mislocated part |  |  | 11:40-11:45
CM: |  |  |  |  | Explain: | The part was removed and another was stamped.There was a bad hole burr because punch and |  |  |  |  | [NAME]
 |  |  |  |  | button were sheared.This die was pulled to the shop for repairs.
Stamping T/L: [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 676549d1588864476-who-supplies-what-fruits
Sheet: Sheet3

Apples | Bananas | Strawberries | Blackberries | Pineapples
Spreadsheet: 89261d1289000442-how-to-duplicate-cells-while-increasing-their-number-content-increment103
Sheet: Sheet1

 |  | xxxxx-xxxx | 10 | xxxxx-xx10CP
 |  | enter pattern ^^^^^^^ | 10 | xxxxx-xx10CV
 |  | DRAG THESE DOWN TOGETHER | 10 | xxxxx-xx10OP
 |  |  | 10 | xxxxx-xx10OV
 |  |  | 11 | xxxxx-xx11CP
 |  |  | 11 | xxxxx-xx11CV
 |  |  | 11 | xxxxx-xx11OP
 |  |  | 11 | xxxxx-xx11OV
 |  |  | 12 | xxxxx-xx12CP
 |  |  | 12 | xxxxx-xx12CV
 |  |  | 12 | xxxxx-xx12OP
 |  |  | 12 | xxxxx-xx12OV
 |  |  | 13 | xxxxx-xx13CP
 |  |  | 13 | xxxxx-xx13CV
 |  |  | 13 | xxxxx-xx13OP
 |  |  | 13 | xxxxx-xx13OV
 |  |  | 14 | xxxxx-xx14CP
 |  |  | 14 | xxxxx-xx14CV
 |  |  | 14 | xxxxx-xx14OP
 |  |  | 14 | xxxxx-xx14OV
 |  |  | 15 | xxxxx-xx15CP
 |  |  | 15 | xxxxx-xx15CV
 |  |  | 15 | xxxxx-xx15OP
 |  |  | 15 | xxxxx-xx15OV
 |  |  | 16 | xxxxx-xx16CP
 |  |  | 16 | xxxxx-xx16CV
 |  |  | 16 | xxxxx-xx16OP
 |  |  | 16 | xxxxx-xx16OV
 |  |  | 17 | xxxxx-xx17CP
 |  |  | 17 | xxxxx-xx17CV
 |  |  | 17 | xxxxx-xx17OP
Spreadsheet: 64559d1265379821-my-sheet-is-gone-ppt_basisgegevens
Sheet: Kilo 2010

2010 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Op afroep
Gebracht
Containerpark
[NAME]
Overige
[NAME]
Meubelen
Textiel
Huisraad
[NAME]
Diverse
Beernem |  | 150000
Blankenberge
Brugge
[NAME]
[NAME]
Jabbeke
[NAME]
Oostkamp
Zedelgem
[NAME]
Andere
Totaal
[NAME]/inwoner
Beernem | 14806
Blankenberge | 18450
Brugge | 117073
[NAME] | 10875
[NAME] | 12243
Jabbeke | 13675
[NAME] | 34026
Oostkamp | 22111
Zedelgem | 22060
[NAME] | 2768
Totaal | 268087
Spreadsheet: 132169d1323565107-how-to-access-information-from-a-table-excel-example
Sheet: Water Piping

 |  | Water Piping
Material |  | L Hard
Qty |  | Description |  | Mat. Price
0
2 |  | 4"
1 |  | 3"
5 |  | 2 1/2"
3 |  | 2"
6 |  | 1 1/2"
7 |  | 1 1/4"
2 |  | 1"
1 |  | 3/4"
2 |  | 1/2"