tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79270d1279556757-convert-data-from-columns-to-rows-sample
Sheet: Sheet4

Count of Customer | type | Product
 | prod1 |  |  |  | prod2 |  |  |  | prod3 |  |  |  | prod4 |  |  |  |  | referenced left | are you sure you want these? |  | vlookups |  |  |  |  | products
Customer | Cable | [NAME] | Pipe | Rope | Cable | [NAME] | Pipe | Rope | Cable | [NAME] | Pipe | Rope | Cable | [NAME] | Pipe | Rope |  | Customer | Product | type | address | city | state | zip | Fax# | prod1 | prod2 | prod3 | prod4
[NAME]'s Plumbing |  |  | 1 |  | 1 |  |  |  |  | 1 |  |  |  |  |  | 1
[NAME]'s Irrigation |  | 1
Joes's Mechanical | 1 |  |  |  |  |  | 1 |  |  | 1
Spreadsheet: 122212d1316664459-if-then-function-with-drop-down-lists-interactive-proposal-tool
Sheet: Proposal Tool

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Door Contact |  | Window Contact |  | Motion Detector |  | Glass Break Detector | Smoke Detector | Heat Detector | [NAME] | Keypad | Control Panel | [NAME] | Panic Button | Cellular Backup | Indoor Camera | Outdoor Camera | Digital Video Recorder | Location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | curtain | 70 | Contact1 | 5 | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Breakfast Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | overhead | 23 | Contact2 | 10 | motion2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Den
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | recessed brown | 4 | Contact3 | 11 | [NAME] | 3 |  |  |  |  |  |  |  |  |  |  |  |  | Dining Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | recessed white | 4 | Contact4 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Family Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4 | Contact5 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Foyer
 |  |  |  | Name: |  |  |  |  |  |  |  |  |  |  |  |  |  | standard white | 4 | Contact6 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guest Bathroom
 |  |  |  | Address: |  |  |  |  |  |  |  |  |  |  |  |  |  | wireless | 85 | Contact7 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | City: |  |  |  | Zip: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hall
 |  |  |  | Home: |  |  |  | Cell: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kitchen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laundry Room
Qty | Category | Equipment |  | Location |  |  |  |  |  | Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master [NAME]
5 | Door Contact | standard white |  | Breakfast Room |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master [NAME]
2 | Window Contact | Contact4 |  | Den |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office
4 | Motion Detector | [NAME] |  | Family Room |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside
 | [NAME].
 | Smoke Detector
 | Heat Detector
 | [NAME]
 | Keypad
 | Control Panel
 | [NAME]
 | Panic Button
 | Cellular Backup
 | Indoor Camera
 | Outdoor Camera
 | DVR
Spreadsheet: 1b9b73d9-eb79-43ea-94a2-e479b4dce790
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GENPK | Test | GENPK | Gentamicin, [NAME], Serum | Gentamicin, Peak, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top  Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 2 hours of draw. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | 5.0-12.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80170 |  |  |  |  | Rochester
GENPK | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
GENPK | Result | 6775 | Gentamicin, Peak, S | Gentamicin, Peak, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3663-2
Spreadsheet: 686291d1594477468-please-help-with-vloock-up-or-iferror-plano-de-manutencao-de-viaturas-2020
Sheet: Manutencao-Dezembro

 | Plano de Manutenção de Viaturas-Mina
 | [NAME]: Outubro/Novembro-Dezembro
 | Item | Viatura | [NAME] | Tag | Matricula | Data da ultima Manutenção | Km da ultima Manutenção | Motorista | Mecânico | Status
 | 1 | TOYOTA | COASTER 3.40M | L002 | [NAME] | 2019-11-25 00:00:00 | 145000 | [NAME] | Leasing | Concluido
 | 2 | ISUZU | KB250D-3,05M | V018 | AEM-965-MP | 2019-11-13 00:00:00 | 195000 | Mustak | [NAME] | Concluido
 | 3 | TOYOTA | HIACE | V048 | [NAME] | 2019-09-25 00:00:00 | 100000 | [NAME] | [NAME] | Concluido
 | 4 | TOYOTA | D4D | V049 | ADH-907-MC | 2019-10-09 00:00:00 | 70000 | Naldo | [NAME] | Concluido
 | 5 | ISUZU | KB250D-3,05M | V019 | AEM-918-MP | 2019-11-13 00:00:00 | 210000 | Eurico | [NAME] | Concluido
 | 6 | ISUZU | KB250D-3,05M | V023 | AFQ-163-MP | 2019-10-09 00:00:00 | 100000 | [NAME] | Entreposto | Concluido
 | 7 | TATA | BASCULANTE | V034 | AEG-156-MC | 2019-10-23 00:00:00 | 80000 | Matias | [NAME] | Concluido
 | 8 | TOYOTA | COASTER 3.40M | V044 | AHD-297-MC | 2019-10-13 00:00:00 | 200000 | [NAME] | [NAME] | Concluido
 | 9 | TOYOTA | COASTER 3.10M | L001 | AGS-297-MC | 2019-11-02 00:00:00 | 190000 | Matias | Leasing | Concluido
 | 10 | TOYOTA | COASTER 3.40M | V046 | AHF-323-MC | 2019-12-01 00:00:00 | 320000 | Mariano | [NAME] | Concluido
 | 11 | TOYOTA | COASTER 3.30M | V038 | AGS-760-MC | 2019-12-21 00:00:00 | 100000 | Celso Chin | [NAME] | Concluido
 | 12 | TOYOTA | DINA | V053 | AGS-387-MP | 2019-12-21 00:00:00 | 360000 | Queiros | [NAME] | Concluido
 | 13 | ISUZU | KB250D-3,05M | V040 | AGH-689-MP | 2019-12-09 00:00:00 | 50000 | Alcidio | Entreposto | Concluido
 | 14 | HINO | RANGER | V042 | AFD-574-MP | 2019-11-07 00:00:00 | 270000 | Celso Armando | [NAME] | Concluido
 | 15 | NISSAN | UD350-4,00M | V039 | AGK-366-MP | 2019-08-10 00:00:00 | 555000 | Hubo | [NAME] | Concluido
Spreadsheet: 130538d1322428115-count-formula-book2
Sheet: Sheet1

1 | 23 | 34 | 45 | [NAME] | [NAME] | 45 | 00:30:00
2 | 13 | 13 | 34 | 45 | 45 | 55 | 03:30:00
3 | 13 | dddd | 34 | 56 | 45 | X | 1900-01-01 00:00:00
4 | x | 34 | 5 | vvv | 76 | 78 | 01:00:00
5 | y | 34 | 5 | vvv | bbb | 78 | 00:30:00
Spreadsheet: 161455d1339524178-need-to-find-the-minimum-of-three-columns-igore-zeros-unless-all-three-are-zeros-find-minimum
Sheet: Sheet1

Column A | Column B | Column C | MIN
500/10,000 | 1,000 | 1,000
500/10,000 | 1,000 | 1,000
0 | 0 | 0
0 | 0 | 5,000
0 | 0 | 1,000
0 | 0 | 1,000
0 | 0 | 100
0 | 0 | 100
0 | 0 | 5,000
500/10,000 | 100 | 100
0 | 0 | 100
0 | 0 | 0
0 | 0 | 1,000
0 | 0 | 10
0 | 0 | 0
0 | 0 | 100
0 | 0 | 5,000
0 | 0 | 1
0 | 0 | 10
0 | 0 | 5,000
0 | 0 | 5,000
0 | 0 | 1,000
10,000 | 1 | 1
10,000 | 100 | 100
0 | 0 | 0
0 | 0 | 100
0 | 0 | 0
0 | 0 | 5,000
0 | 0 | 10
0 | 0 | 0
0 | 0 | 100
0 | 0 | 0
0 | 0 | 0
0 | 0 | 5,000
0 | 0 | 5,000
500 | 500 | 0
0 | 0 | 100
0 | 0 | 10
0 | 0 | 10
0 | 0 | 1,000
0 | 0 | 10
1,000 | 100 | 100
1,000 | 100 | 100
1,000 | 5,000 | 5,000
0 | 0 | 1,000
500 | 100 | 100
10,000 | 10 | 10
1,000 | 10 | 10
Spreadsheet: 223320d1364162606-file-size-swells-after-macro-function-fileforsubtotals
Sheet: Mayor

$B$23 | [NAME]: [NAME][NAME]: CuadroBotones / CopiaCeldas / CompletaAsnto |  |  |  | 6797.549999999999 | 6797.549999999999
Fecha | Asnto | C | Cuenta | [NAME] | Debe | [NAME]
2013-02-01 00:00:00 | 41 | 11800 | 11800 Aportación a Prvcia | Aportación a la Provincia | 4000
 |  | Total 11800 |  |  | 4000 | 0
2013-02-11 00:00:00 | 44 | 57000 | 57000 Caja | De banco a Caja Michaël | 150
 |  | Total 57000 |  |  | 150 | 0
2013-02-01 00:00:00 | 37 | 57201 | 57201 Banco-1 | [NAME] | 778.32
2013-02-01 00:00:00 | 38 | 57201 | 57201 Banco-1 | [NAME] | 722.13
2013-02-01 00:00:00 | 39 | 57201 | 57201 Banco-1 | [NAME] | 722.13
2013-02-01 00:00:00 | 40 | 57201 | 57201 Banco-1 | Estipendios del Obispado mes de Enero | 300
2013-02-01 00:00:00 | 41 | 57201 | 57201 Banco-1 | Aportación a la Provincia |  | 4000
2013-02-05 00:00:00 | 42 | 57201 | 57201 Banco-1 | [NAME] |  | 103.57
2013-02-09 00:00:00 | 43 | 57201 | 57201 Banco-1 | [NAME] |  | 4.9
2013-02-11 00:00:00 | 44 | 57201 | 57201 Banco-1 | De banco a Caja Michaël |  | 150
2013-02-11 00:00:00 | 45 | 57201 | 57201 Banco-1 | Medicinas Michaël |  | 16.5
 |  | Total 57201 |  |  | 2522.58 | 4274.969999999999
2013-02-05 00:00:00 | 42 | 60101 | [NAME] | [NAME] | 103.57
2013-02-09 00:00:00 | 43 | 60101 | [NAME] | [NAME] | 4.9
 |  | Total 60101 |  |  | 108.47 | 0
2013-02-11 00:00:00 | 45 | 60251 | [NAME], [NAME]. | Medicinas Michaël | 16.5
 |  | Total 60251 |  |  | 16.5 | 0
2013-02-01 00:00:00 | 37 | 70500 | 70500 Sueldos Percibidos | [NAME] |  | 778.32
2013-02-01 00:00:00 | 38 | 70500 | 70500 Sueldos Percibidos | [NAME] |  | 722.13
2013-02-01 00:00:00 | 39 | 70500 | 70500 Sueldos Percibidos | [NAME] |  | 722.13
 |  | Total 70500 |  |  | 0 | 2222.58
2013-02-01 00:00:00 | 40 | 70505 | 70505 Estipendios y [NAME] | Estipendios del Obispado mes de Enero |  | 300
 |  | Total 70505 |  |  | 0 | 300
 |  | Total general |  |  | 6797.549999999999 | 6797.549999999999
Spreadsheet: bill_williams_iii__1389__EES July Dailies
Sheet: Blank

POSITIVE [NAME] = LONG POSITION
NEGATIVE VARIANCE = SHORT POSITION
NP15 | 2001-06-01 00:00:00 | Flow Day |  |  |  |  | SP15 |  |  |  |  |  |  |  |  | ZP26
Fixed Peak Long |  | Fixed Off Peak Long |  |  |  |  | Fixed Peak Long |  |  |  | Fixed Off Peak Long |  |  |  |  | Fixed Peak Long |  |  | Fixed Off Peak Long
Fixed Peak Short Pos |  | Fixed Off Peak Short |  |  |  |  | Fixed Peak Short |  |  |  | Fixed Off Peak Short |  |  |  |  | Fixed Peak Short |  |  | Fixed Off Peak Short
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Transmission from SP | Other EnPower | Load | var |  | HE | Fixed | Transmission to NP/ZP | Other Deals | Other EnPower | Load | var |  |  | HE | Fixed | Transmission from SP | Other EnPower | Load | var
1 |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  |  | 1 | 0 |  | 0
2 |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | 2 | 0 |  | 0
3 |  |  |  |  |  |  | 3 | 0 |  |  |  |  |  |  |  | 3 | 0 |  | 0
4 |  |  |  |  |  |  | 4 | 0 |  |  |  |  |  |  |  | 4 | 0 |  | 0
5 |  |  |  |  |  |  | 5 | 0 |  |  |  |  |  |  |  | 5 | 0 |  | 0
6 |  |  |  |  |  |  | 6 | 0 |  |  |  |  |  |  |  | 6 | 0 |  | 0
7 |  |  |  |  |  |  | 7 | 0 |  |  |  |  |  |  |  | 7 | 0 |  | 0
8 |  |  |  |  |  |  | 8 | 0 |  |  |  |  |  |  |  | 8 | 0 |  | 0
9 |  |  |  |  |  |  | 9 | 0 |  |  |  |  |  |  |  | 9 | 0 |  | 0
10 |  |  |  |  |  |  | 10 | 0 |  |  |  |  |  |  |  | 10 | 0 |  | 0
11 |  |  |  |  |  |  | 11 | 0 |  |  |  |  |  |  |  | 11 | 0 |  | 0
12 |  |  |  |  |  |  | 12 | 0 |  |  |  |  |  |  |  | 12 | 0 |  | 0
13 |  |  |  |  |  |  | 13 | 0 |  |  |  |  |  |  |  | 13 | 0 |  | 0
14 |  |  |  |  |  |  | 14 | 0 |  |  |  |  |  |  |  | 14 | 0 |  | 0
15 |  |  |  |  |  |  | 15 | 0 |  |  |  |  |  |  |  | 15 | 0 |  | 0
16 |  |  |  |  |  |  | 16 | 0 |  |  |  |  |  |  |  | 16 | 0 |  | 0
17 |  |  |  |  |  |  | 17 | 0 |  |  |  |  |  |  |  | 17 | 0 |  | 0
18 |  |  |  |  |  |  | 18 | 0 |  |  |  |  |  |  |  | 18 | 0 |  | 0
19 |  |  |  |  |  |  | 19 | 0 |  |  |  |  |  |  |  | 19 | 0 |  | 0
20 |  |  |  |  |  |  | 20 | 0 |  |  |  |  |  |  |  | 20 | 0 |  | 0
21 |  |  |  |  |  |  | 21 | 0 |  |  |  |  |  |  |  | 21 | 0 |  | 0
22 |  |  |  |  |  |  | 22 | 0 |  |  |  |  |  |  |  | 22 | 0 |  | 0
23 |  |  |  |  |  |  | 23 | 0 |  |  |  |  |  |  |  | 23 | 0 |  | 0
24 |  |  |  |  |  |  | 24 | 0 |  |  |  |  |  |  |  | 24 | 0 |  | 0
Spreadsheet: 689899d1596730641-postcode-appears-in-two-areas-data-sample
Sheet: Pivot

Postcode | Area
CH 1 4EF | Garden Quarter
CH 1 4EF | Newton
CH 1 4EG | Newton
CH 1 4EH | Chester City
CH 1 4EJ | Chester City
CH 1 4EL | Garden Quarter
CH 1 4EN | Chester City
CH 1 4EN | Garden Quarter
Spreadsheet: 865515d1712590003-date-wise-data-output-in-index-function-new-inward-and-outward-ramesh-h-and-m-1-
Sheet: OUTPUT DATA

OUTPUT DATA |  |  |  |  |  |  |  |  |  |  | OUTPUT DATA
246 EMB PANEL | JAI VISHNU |  | UNIT 1 |  | 246 EMB PANEL | SRI FASHION |  | UNIT 1 |  |  | AAA | [NAME] |  | YYY |  | CCC | ZZZ |  | [NAME]
DATE | DC NO | SENT | RECEIVED |  | DATE | DC NO | SENT | RECEIVED |  |  | DATE | DC NO | SENT | RECEIVED |  | DATE | DC NO | SENT | RECEIVED
 |  |  |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00 | TBC | 720 |  |  | 2024-02-28 00:00:00 | TBC | 820
 |  |  |  |  |  |  |  |  |  |  | 2024-02-23 00:00:00 | 3017 |  | 220 |  | 2024-02-28 00:00:00 | 3624 |  | 121
 |  |  |  |  |  |  |  |  |  |  | 2024-02-24 00:00:00 | TBC | 720
 |  |  |  |  |  |  |  |  |  |  | 24.02.2024 | 3018 |  | 220
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 220 | 720 |  |  | 1 | 220 | SUBTOTAL(109,ReportTable13[RECEIVED])
 | Balance |  |  |  |  | Balance |  |  |  |  |  | Balance | -500 |  |  |  | Balance | #[NAME]!
Spreadsheet: 130041d1322042701-using-a-range-in-formula-distance
Sheet: Reference Locations

Latitude (WGS84) | Longitude (WGS84) | Location Name
54.1777777777777 | -3.18888888888888 | AAA
54.1333333333333 | -3.12222222222222 | BBB
53.8777777777777 | -3.14444444444444 | CCC
53.9444444444444 | -3.122222222 | DDD
53.6777777777777 | -3.44444444444444 | EEE
53.6955555555555 | -2.16666666666666 | FFF
Spreadsheet: 93200d1292801240-how-do-i-sum-up-all-cells-in-different-sheets-to-a-cell-in-sheet1-timesheet
Sheet: Sheet1

Job Number | Job Name |  | [NAME] | [NAME] | Total
00Gen | General
00Holiday | Holiday/Vacation
00Sick | Sickness
9037 | [NAME]
9038 | Suny Radioactive
9046 | [NAME]
10010 | Public Theater
10025 | Project Trio
10033 | Aeropostale
10039 | Harbor Point
10045 | Lodewick/Spadaro
10048 | 44 West 18th St
10052 | Barclay's Capital
Spreadsheet: 35867d1233595209-conditional-sums-using-multiple-criteria-multiple_criteria_sums-test
Sheet: Sheet1

ResourceName | Iteration | WorkOptimum |  | Total Project Recources
[NAME] | 0 | 30 |  | 42 | [NAME]
[NAME] | 1 | 10 |  | 22 | [NAME]
TechPub_OSPResource1 | 2 | 11.5 |  | 80 | TechPub_OSPResource1
TechPub_CBPResource1 | 3 | 4.5 |  | 12.5 | TechPub_CBPResource1
[NAME] | 4 | 6 |  | 13 | [NAME]
[NAME] | 1 | 6 |  | 169.5 | PROJECT TOTAL
[NAME] | 1 | 6
[NAME] | 2 | 6
[NAME] | 2 | 6
TechPub_OSPResource1 | 3 | 6 |  | Resource Total by Iteration
TechPub_OSPResource1 | 3 | 10 |  |  | Iteration 1
TechPub_OSPResource1 | 3 | 11 |  | 0 | [NAME]
TechPub_OSPResource1 | 3 | 1 |  | 0 | [NAME]
TechPub_OSPResource1 | 3 | 12.5 |  | 0 | TechPub_OSPResource1
TechPub_OSPResource1 | 3 | 23 |  | 0 | TechPub_CBPResource1
TechPub_OSPResource1 | 3 | 5 |  | 0 | [NAME]
[NAME] | 0 | 7 |  | 0 | TOTAL ITERATION 1
TechPub_CBPResource1 | 0 | 8
 |  | 169.5 |  | Conditional SUM NOT working for Iteration 1 toal???
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: CAN

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 70 | 00:01:16.956000 | 7 |  | 1 |  | 00:01:13.838000
2 | [NAME] |  |  | 18 | 70 | 00:01:17.217000 | 1 |  | 2 |  | 00:01:13.014000
3 | [NAME] |  |  | 15 | 70 | 00:01:19.572000 | 4 |  | 3 |  | 00:01:13.429000
4 | [NAME] |  |  | 12 | 70 | 00:01:19.138000 | 8 |  | 4 |  | 00:01:13.864000
5 | [NAME] |  |  | 10 | 70 | 00:01:19.054000 | 10 |  | 5 |  | 00:01:14.085000
6 | [NAME] |  |  | 8 | 70 | 00:01:19.148000 | 3 |  | 6 |  | 00:01:13.217000
7 | [NAME] |  |  | 6 | 70 | 00:01:20.213000 | 13 |  | 7 |  | 00:01:15.285000
8 | [NAME] |  |  | 4 | 70 | 00:01:20.371000 | 24 |  | 8 |  | 00:01:16.294000
9 | [NAME] |  |  | 2 | 70 | 00:01:20.316000 | 16 |  | 9 |  | 00:01:15.361000
10 | Sebastien Buemi |  |  | 1 | 70 | 00:01:19.507000 | 15 |  | 10 |  | 00:01:15.334000
11 | [NAME] |  |  | 0 | 70 | 00:01:20.071000 | 6 |  | 11 |  | 00:01:13.814000
12 | [NAME] |  |  | 0 | 70 | 00:01:20.369000 | 17 |  | 12 |  | 00:01:15.587000
13 | [NAME] |  |  | 0 | 69 | 00:01:23.419000 | 20 |  | 13 |  | 00:01:18.424000
14 | [NAME] |  |  | 0 | 69 | 00:01:22.495000 | 23 |  | 14 |  | 00:01:19.414000
15 | [NAME] |  |  | 0 | 69 | 00:01:24.590000 | 21 |  | 15 |  | 00:01:18.537000
16 | Jarno [NAME] |  |  | 0 | 69 | 00:01:22.233000 | 18 |  | 16 |  | 00:01:16.745000
17 | Narain Karthikeyan |  |  | 0 | 69 | 00:01:23.116000 | 22 |  | 17 |  | 00:01:18.574000
18 | [NAME] |  |  | 0 | 67 | 00:01:19.395000 | 11 |  | 18 |  | 00:01:14.752000
19 | Pastor Maldonado |  |  | - | 61 | 00:01:24.265000 | 12 |  | RET |  | 00:01:15.043000
20 | [NAME] |  |  | - | 55 | 00:01:25.135000 | 9 |  | RET |  | 00:01:14.062000
21 | [NAME] |  |  | - | 49 | 00:01:30.171000 | 14 |  | RET |  | 00:01:15.287000
22 | [NAME] |  |  | - | 36 | 00:01:34.223000 | 2 |  | RET |  | 00:01:13.199000
23 | [NAME] |  |  | - | 28 | 00:01:38.460000 | 19 |  | RET |  | 00:01:16.786000
24 | [NAME] |  |  | - | 7 | 00:01:37.761000 | 5 |  | RET |  | 00:01:13.565000
Spreadsheet: 775713d1649265276-auto-summing-number-of-purchase-orders-based-on-customers-first-initial-example
Sheet: Sheet1

Customer Name | # of Pos
ABC Shop | 300
ABC Go | 250
AB company | 100
Busy Store | 100
[NAME] | 500
Business Us | 600
Company Store | 200
CBU Store | 200
CDI | 200
Spreadsheet: 887535d1737755664-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Apr

 |  |  | 2026-03-30 00:00:00 | 2026-03-31 00:00:00 | 2026-04-01 00:00:00 | 2026-04-02 00:00:00 | 2026-04-03 00:00:00 | 2026-04-04 00:00:00
 |  |  | 2026-04-06 00:00:00 | 2026-04-07 00:00:00 | 2026-04-08 00:00:00 | 2026-04-09 00:00:00 | 2026-04-10 00:00:00 | 2026-04-11 00:00:00
 |  |  | 2026-04-13 00:00:00 | 2026-04-14 00:00:00 | 2026-04-15 00:00:00 | 2026-04-16 00:00:00 | 2026-04-17 00:00:00 | 2026-04-18 00:00:00
 |  |  | 2026-04-20 00:00:00 | 2026-04-21 00:00:00 | 2026-04-22 00:00:00 | 2026-04-23 00:00:00 | 2026-04-24 00:00:00 | 2026-04-25 00:00:00
 |  |  | 2026-04-27 00:00:00 | 2026-04-28 00:00:00 | 2026-04-29 00:00:00 | 2026-04-30 00:00:00 | 2026-05-01 00:00:00 | 2026-05-02 00:00:00
 |  |  | 2026-05-04 00:00:00 | Notes
Spreadsheet: 40066d1238398084-running-totals-in-column-utility-billing
Sheet: GAS

Imperial to Metric Conversion Factor |  |  | 2.83 |  |  |  | Billing |  |  |  | Monthly Readings
Correction Factor |  |  | 1.02264 |  |  |  | Date | Usage | Total |  | Date | Reading | Usage
Calorific Value |  |  | 40 |  |  |  | 2009-02-27 00:00:00 | 325 | 352.464528066 |  | 2009-02-27 00:00:00 | 627
kWh Conversion Factor |  |  | 3.6 |  |  |  |  |  |  |  | 2009-03-30 00:00:00 |  | -627
Tariff Costs
Standard Energy |  | 0.0437
Discounted Energy |  | 0.033
Direct Debit Discount |  | 0.06
VAT |  | 0.05
 |  | Last Reading | This Reading | Units
Date | 2009-02-27 00:00:00 | 302 | 627 | 325
 |  | Total Metric Units Used |  | 940.57314 | m3
 |  | Total kWh |  | 10450.81266666667 | kWh
 |  |  | Units | Cost
Standard Energy |  |  | 1143 | 49.9491
Discounted Energy |  |  | 9307.812666666667 | 307.157818
Monthly DD Discount |  |  |  | 21.42641508
Sub Total |  |  |  | 335.68050292
VAT |  |  |  | 16.784025146
Total |  |  |  | 352.464528066
Spreadsheet: andy_zipper__182__DYNEGY-ICE VOL May14
Sheet: Historical Volumes

ICE
3 Week Historical Volumes
DATE | TOTAL POWER (MWH) | TOTAL GAS (MMBTU) | FIN GAS | PHY GAS | TOTAL CRUDE PRODUCTS (BBL)
2001-04-16 00:00:00 |  |  | 48527500 | 6667500
2001-04-17 00:00:00 |  |  | 75472500 | 4052500
2001-04-18 00:00:00 |  |  | 81382500 | 7405000
2001-04-19 00:00:00 |  |  | 72127500 | 6287500
2001-04-20 00:00:00 |  |  | 76500000 | 30285000
2001-04-23 00:00:00 |  |  | 72632500 | 8845000
2001-04-24 00:00:00 |  |  | 109367500 | 31765000
2001-04-25 00:00:00 |  |  | 51575000 | 15657500
2001-04-26 00:00:00 |  |  | 91282500 | 8002500
2001-04-27 00:00:00 |  |  | 57892500 | 15375000
2001-04-30 00:00:00 |  |  | 73860000 | 18080000
2001-05-01 00:00:00 |  |  | 33352500 | 16697500
2001-05-02 00:00:00 |  |  | 71675000 | 50730000
2001-05-03 00:00:00 |  |  | 107250000 | 31740000
2001-05-04 00:00:00 |  |  | 57745000 | 14362500 |  |  |  | Originally Reported
2001-05-07 00:00:00 |  |  | 119670000 | 93077500 |  |  | RESTATED | 6417500
2001-05-08 00:00:00 |  |  | 154490000 | 129925000 |  |  | RESTATED | 51045000
2001-05-09 00:00:00 |  |  | 106625000 | 208852500 |  |  | RESTATED | 73037500
2001-05-10 00:00:00 |  |  | 134647500 | 99510000 |  |  | RESTATED | 75180000
2001-05-11 00:00:00 |  |  | 144462500 | 216390000 |  |  | RESTATED | 46105000
2001-05-14 00:00:00 | 5596800 | 231145000 | 96370000 | 134775000 | 3240000
Spreadsheet: 722417d1615242447-search-last-value-in-several-worksheets-test
Sheet: Marchal

A | B | C | D | E
2021-01-01 00:00:00 | 1
2021-01-02 00:00:00 |  | 2
2021-01-03 00:00:00 |  | 3
2021-01-04 00:00:00 | 12
Spreadsheet: 157297d1337693973-help-with-adding-up-referenced-data-entries-sample
Sheet: Sheet1

 | Table 1
 | Product REF | Item REF |  | Packing | Weight | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Product A
 | 1 | 1 | 8 pieces | 24 | 100 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 | 2 | 16 pieces | 24 | 200 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 | 3 | 24 pieces | 12 | 300 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 | 1 | 2x8 pieces | 12 | 200 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 | 2 | 2x16 pieces | 12 | 400 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 1 | 3 | 2x24 pieces | 6 | 600 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | Product B
 | 2 | 1 | 100g | 24 | 100 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 2 | 2 | 200g | 24 | 200 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 2 | 3 | 300g | 12 | 300 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 2 | 1 | 2x100g | 12 | 200 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 2 | 2 | 2x200g | 12 | 400 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 2 | 3 | 2x300g | 6 | 600 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | Table 2 | on another sheet
 | Product REF | Item REF |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Product A
 | 1 | 1 | 8 pieces | a
 | 1 | 2 | 16 pieces | b
 | 1 | 3 | 24 pieces | c
 | Product B
 | 2 | 1 | 100g
 | 2 | 2 | 200g
 | 2 | 3 | 300g
Spreadsheet: 851051d1701310717-adding-minutes-and-seconds-sample61
Sheet: Sheet1

 |  |  | Mins:Secs |  | Running Total Mins:Secs
 |  |  | 01:35:00 |  | 00:01:35 | 00:01:35 | 00:01:35
 |  |  | 05:37:00 |  | 00:07:12 | 00:07:12 | 00:07:12
 |  |  | 04:12:00 |  | 00:11:24 | 00:11:24 | 00:11:24
 |  |  | 04:01:00 |  | 00:15:25 | 00:15:25 | 00:15:25
 |  |  | 03:57:00 |  | 00:19:22 | 00:19:22 | 00:19:22
 |  |  | 03:35:00 |  | 00:22:57 | 00:22:57 | 00:22:57
 |  |  | 03:41:00 |  | 00:26:38 | 00:26:38 | 00:26:38
 |  |  | 03:32:00 |  | 00:30:10 | 00:30:10 | 00:30:10
 |  |  | 04:00:00 |  | 00:34:10 | 00:34:10 | 00:34:10
 |  |  | 02:34:00 |  | 00:36:44 | 00:36:44 | 00:36:44
 |  |  | 04:57:00 |  | 00:41:41 | 00:41:41 | 00:41:41
 |  |  | 04:10:00 |  | 00:45:51 | 00:45:51 | 00:45:51
 |  |  | 05:46:00 |  | 00:51:37 | 00:51:37 | 00:51:37
 |  |  | 05:05:00 |  | 00:56:42 | 00:56:42 | 00:56:42
 |  |  | 04:06:00 |  | 01:00:48 | 01:00:48 | 01:00:48
 |  |  | 03:17:00 |  | 01:04:05 | 01:04:05 | 01:04:05
 |  |  | 03:41:00 |  | 01:07:46 | 01:07:46 | 01:07:46
 |  |  | 05:20:00 |  | 01:13:06 | 01:13:06 | 01:13:06