tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 277631d1384373849-merging-two-tables-with-different-column-number-both-tables-have-some-column-common-name-test
Sheet: Sheet1

ID | Age | Name | Length | Height |  |  |  |  |  | ID | Age | Height
1 | 23 | Man1 | 167 | 65 |  |  |  |  |  | 1 | 45 | 124
2 | 44 | Man2 | 160 | 78 |  |  |  |  |  | 2 | 46 | 126
3 | 45 | Man3 | 153 | 91 |  |  |  |  |  | 3 | 47 | 128
4 | 46 | Man4 | 146 | 104 |  |  |  |  |  | 4 | 48 | 130
5 | 34 | Man5 | 139 | 117 |  |  |  |  |  | 5 | 49 | 132
6 | 23 | Man6 | 132 | 130 |  |  |  |  |  | 6 | 50 | 134
 |  |  |  |  |  | I want the result to be updated automatically without I Do it manually like this
 |  |  |  |  |  |  |  | ID | Age | Name | Length | Height
 |  |  |  |  |  |  |  | 1 | 23 | Man1 | 167 | 65
 |  |  |  |  |  |  |  | 2 | 44 | Man2 | 160 | 78
 |  |  |  |  |  |  |  | 3 | 45 | Man3 | 153 | 91
 |  |  |  |  |  |  |  | 4 | 46 | Man4 | 146 | 104
 |  |  |  |  |  |  |  | 5 | 34 | Man5 | 139 | 117
 |  |  |  |  |  |  |  | 6 | 23 | Man6 | 132 | 130
 |  |  |  |  |  |  |  | 1 | 45 |  |  | 124
 |  |  |  |  |  |  |  | 2 | 46 |  |  | 126
 |  |  |  |  |  |  |  | 3 | 47 |  |  | 128
 |  |  |  |  |  |  |  | 4 | 48 |  |  | 130
 |  |  |  |  |  |  |  | 5 | 49 |  |  | 132
 |  |  |  |  |  |  |  | 6 | 50 |  |  | 134
Spreadsheet: 696692d1600951730-identify-if-a-date-falls-between-one-or-more-intervals-in-an-array-and-highlight-cell-so-arrayfunction
Sheet: Sheet3

 | 2020-08-20 00:00:00
 | 2020-08-18 00:00:00
 | 2020-08-28 00:00:00 |  | -
 | 2020-08-27 00:00:00 |  | -
 | 2020-08-13 00:00:00 |  | MATCH!
 | 2020-08-07 00:00:00 |  | -
 | 2020-08-27 00:00:00 |  | -
 | 2020-08-27 00:00:00 |  | -
Spreadsheet: 860309d1708449022-whats-is-wrong-with-my-formula-copy-of-dec23-design
Sheet: DSA

Project | Epic | Issue | Sub-task | User | Key | Logged | 01/Dec/23 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 05/Dec/23 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 08/Dec/23 | 2023-12-09 00:00:00 | 2023-12-10 00:00:00 | 11/Dec/23 | 12/Dec/23 | 13/Dec/23 | 14/Dec/23 | 15/Dec/23 | 2023-12-16 00:00:00 | 2023-12-17 00:00:00 | 18/Dec/23 | 19/Dec/23 | 20/Dec/23 | 2023-12-21 00:00:00 | 2023-12-22 00:00:00 | 2023-12-23 00:00:00 | 2023-12-24 00:00:00 | 2023-12-25 00:00:00 | 2023-12-26 00:00:00 | 2023-12-27 00:00:00 | 2023-12-28 00:00:00 | 2023-12-29 00:00:00 | 2023-12-30 00:00:00 | 2023-12-31 00:00:00
[Design] Digital Sales Agreement 2 |  |  |  |  | DDSA2 | 27 | 1 |  |  |  | 4 |  |  | 2 |  |  | 5 | 1 | 1 | 6 | 1 |  |  | 2 | 2 | 2
[Design] Digital Sales Agreement 2 | No Epic |  |  |  |  | 27 | 1 |  |  |  | 4 |  |  | 2 |  |  | 5 | 1 | 1 | 6 | 1 |  |  | 2 | 2 | 2
[Design] Digital Sales Agreement 2 | No Epic | [Additional Mocks] Myinfo Holding Page |  |  | DDSA2-19 | 2 |  |  |  |  | 2
[Design] Digital Sales Agreement 2 | No Epic | [Additional Mocks] Myinfo Holding Page | No Sub-task |  |  | 2 |  |  |  |  | 2
[Design] Digital Sales Agreement 2 | No Epic | [Additional Mocks] Myinfo Holding Page | No Sub-task | [NAME] |  | 2 |  |  |  |  | 2
[Design] Digital Sales Agreement 2 | No Epic | [Design Review + Discussion] Lynda |  |  | DDSA2-21 | 8 |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4
[Design] Digital Sales Agreement 2 | No Epic | [Design Review + Discussion] Lynda | No Sub-task |  |  | 8 |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4
[Design] Digital Sales Agreement 2 | No Epic | [Design Review + Discussion] Lynda | No Sub-task | [NAME] |  | 8 |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4
[Design] Digital Sales Agreement 2 | No Epic | [DSA] Stage 1,2,3 - Latest Comments |  |  | DDSA2-18 | 17 | 1 |  |  |  | 2 |  |  | 2 |  |  | 1 | 1 | 1 | 2 | 1 |  |  | 2 | 2 | 2
[Design] Digital Sales Agreement 2 | No Epic | [DSA] Stage 1,2,3 - Latest Comments | No Sub-task |  |  | 17 | 1 |  |  |  | 2 |  |  | 2 |  |  | 1 | 1 | 1 | 2 | 1 |  |  | 2 | 2 | 2
[Design] Digital Sales Agreement 2 | No Epic | [DSA] Stage 1,2,3 - Latest Comments | No Sub-task | [NAME] |  | 17 | 1 |  |  |  | 2 |  |  | 2 |  |  | 1 | 1 | 1 | 2 | 1 |  |  | 2 | 2 | 2
 |  |  |  |  |  | 27 | 1 |  |  |  | 4 |  |  | 2 |  |  | 5 | 1 | 1 | 6 | 1 |  |  | 2 | 2 | 2
Spreadsheet: 861613d1709505564-formula-help-to-reflect-value-in-table-1-from-table-2-in-same-row-matching-criteria-demo-030324-dj
Sheet: Statement

 |  | Table 1 |  |  | Table 2
 |  | Fruits | Month |  | Fruits | MONTHS
 |  |  | 2023-04-30 00:00:00 | <----Criteria |  | 2023-04-30 00:00:00 |  | 2023-06-30 00:00:00
 | Criteria---> | Water melon |  | <----Corrsponding value of same row from table 2 ( Cell G6) | Water melon | 550.739308999999 | 553.4624294999909 | 642.3954794000001 | Target value G6
 |  | Apple |  | <----Corrsponding value of same row from table 2 ( Cell G7) | Apple | 544.7793536999989 | 620.4713416000011 | 614.8303793000002 | Target value G7
 |  | Orange |  | <----Corrsponding value of same row from table 2 ( Cell G8) | Orange | 141.816426999999 | 148.993615 | 149.979060000001 | Target value G8
 |  | Mango |  |  | Mango | 1 | 1 | 1
 |  | Blackberry |  |  | Blackberry | 2.5 | 0.08499999999999996 | 17.835
 |  | Water melon |  | This values is repeating again whereas need 375.74 | Water melon | 375.739308999999 | 378.4624294999909 | 467.3954794000001
 |  | Apple |  |  | Apple | 369.7793536999989 | 445.4713416000011 | 439.8303793000002
 |  | Orange |  |  | Orange | 33.183573000001 | 26.006385 | 25.020939999999
 |  | Mango |  |  | Mango | 174 | 174 | 174
 |  | Blackberry |  |  | Blackberry | 172.5 | 174.915 | 157.165
 |  | Need your help on to reflect the cell value of same row matching with month as criteria in first table in cell no. D5 against table 2. In give data set if I select month Apr 23 in table 1 ( D5), corresponding data in table 2 of April23 (column G)  should capture in D column against each fruit in same line. Hope I could explain my query.
Spreadsheet: tracy_geaccone__40397__2002 Lay Presentation_Tracy
Sheet: Schedule 1

 |  |  |  |  | Commercial
 |  |  | Net Margin |  | Contribution
 |  |  | $Millions |  | $Millions
 | 2001 Estimate |  | 204 |  | 191.8
 | Shared Cost Surcharge |  | -9.8 |  | -9.8
 | Market Conditions in California |  | -11.5 |  | -11.5
 | Normalized 2001 Estimate
 | 2002 Plan w/ Red Rock |  | 202.7 |  | 191.2
 | 2002 Plan w/o Red Rock |  | 191.9 |  | 180.4
 | Growth w/ Red Rock
 | Growth w/o Red Rock
 | Percentage Growth w/ Red Rock
 | Percentage Growth w/o Red Rock
 | 2002 Actuals |  | 182.2 |  | 169.8
Spreadsheet: 864899d1712047986-cannot-see-the-error-example-196-aligw
Sheet: Sheet1

[NAME] | 13 | 1 |  | 1
[NAME] | 20 | 5 |  | 2
Sal | 17 | 2 |  | 3
Garry | 18 | 3 |  | 4
[NAME] | 23 | 6 |  | 5
[NAME] | 19 | 4 |  | 6
Spreadsheet: 129820d1321905829-calculating-values-e-g-0-05-0-06-1-03-sample
Sheet: Sheet1

0.02, 0.06 and 0.05 are showing the quantity in pieces.
If any cell that is equal to 0.08, it means 1 Pack because a pack is consist of 8 pieces.
1 | 2 | 3 | 4 | 5 | SUM
0.02 | 0.06 | 0.05 | 0.04 | 0.07 |  | (I want 3.00 instead of 0.24)
0.07 | 0.05 | 0.01 | 0.05 | 0 |  | (I want 2.02instead of 0.18)
0.03 | 0.07 | 0.04 | 0.06 | 0.05 |  | (I want 3.01 instead of 0.25)
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-05-31 00:00:00 |  | 748349.6
2001-06-16 00:00:00
60874 | 2516
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-05-31 00:00:00 |  | 275313.72
2001-06-16 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-05-31 00:00:00 |  | 663620.69
2001-06-16 00:00:00
500241
500391 | 5739
500392 | 1159
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: larry_campbell__21022__PCB Graphs
Sheet: 63.26B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 2000-03-22 00:00:00 |  |  | 27 |  | Sherwood
63.26 B Side |  |  | 2000-04-05 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 7 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-12 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-26 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-23 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-09-06 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 14 |  | Sherwood
 |  |  | 2000-11-08 00:00:00 |  |  | 16 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 9 |  | Sherwood
 |  |  | 2001-03-14 00:00:00 |  |  | 6 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-06-12 00:00:00 |  |  | 2 |  | Sherwood
 |  |  | 2001-07-11 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-08-09 00:00:00 |  |  | 2 |  | Sherwood
 |  |  | 2001-10-17 00:00:00 |  |  | 2 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 117485d1312823023-how-to-calc-thousands-of-estimates-using-pivot-table-bm_sample
Sheet: Sheet1

VALUE | COUNT | Region | Biomass | Percent_Area | Weighted_BM |  | Sum of COUNT |  |  | Sum of Weighted_BM
1 | 9403 | 1 | 180 | 0.002731756237747334 | 0.4917161227945201 |  | Region | Total |  | Country | Total
2 | 2380 | 1 | 80 | 0.0006914367591022711 | 0.05531494072818169 |  | 1 | 3442108 |  | 1 | 84.2152067860741
3 | 234014 | 1 | 50 | 0.06798566459855414 | 3.399283229927707 |  | 2 | 20364 |  | 2 | 73.98079945000981
4 | 345060 | 1 | 120 | 0.100246709283962 | 12.02960511407544 |  | 3 | 4104111 |  | 3 | 213.0890151362865
5 | 2340202 | 1 | 80 | 0.6798746582036357 | 54.38997265629085 |  | 5 | 142357 |  | 5 | 92.45597336274295
6 | 505020 | 1 | 94 | 0.146718231967155 | 13.79151380491257 |  | 6 | 879999 |  | 6 | 80.9413499333522
7 | 6029 | 1 | 33 | 0.001751542949843526 | 0.05780091734483636 |  | 7 | 972 |  | 7 | 57
8 | 20341 | 2 | 74 | 0.9988705558829306 | 73.91642113533686 |  | 8 | 5326336 |  | 8 | 67.56113940239594
9 | 23 | 2 | 57 | 0.001129444117069338 | 0.06437831467295227 |  | Grand Total | 13916247 |  | Grand Total | 669.2434840708615
10 | 70640 | 3 | 65 | 0.01721201010401522 | 1.118780656760989
11 | 79583 | 3 | 69 | 0.01939104473538849 | 1.337982086741806
12 | 685649 | 3 | 34 | 0.1670639512430341 | 5.68017434226316
13 | 345986 | 3 | 62 | 0.08430230079059753 | 5.226742649017047
14 | 459655 | 3 | 58 | 0.1119986764490532 | 6.495923234045083
15 | 234 | 3 | 108 | 5.701600176018631e-05 | 0.006157728190100122
16 | 3459 | 3 | 201 | 0.0008428134619166002 | 0.1694055058452366
17 | 34958 | 3 | 298 | 0.008517800809968347 | 2.538304641370567
18 | 2389349 | 3 | 323 | 0.5821843025200829 | 188.0455297139868
19 | 34598 | 3 | 293 | 0.008430083884183445 | 2.470014578065749
20 | 5968 | 5 | 49 | 0.04192277162345371 | 2.054215809549232
21 | 349 | 5 | 195 | 0.002451582992055185 | 0.4780586834507611
22 | 30495 | 5 | 78 | 0.2142149665980598 | 16.70876739464866
23 | 6 | 5 | 57 | 4.214755860266794e-05 | 0.002402410840352072
24 | 5091 | 5 | 94 | 0.03576220347436375 | 3.361647126590193
25 | 10589 | 5 | 65 | 0.07438341634060847 | 4.83492206213955
26 | 89859 | 5 | 103 | 0.6312229114128564 | 65.0159598755242
27 | 876590 | 6 | 80 | 0.9961261319615136 | 79.69009055692109
28 | 3409 | 6 | 323 | 0.003873868038486408 | 1.25125937643111
29 | 972 | 7 | 57 | 1 | 57
30 | 89011 | 8 | 79 | 0.01671148797221955 | 1.320207549805345
31 | 902 | 8 | 114 | 0.0001693471835047582 | 0.01930557891954244
32 | 4866777 | 8 | 65 | 0.9137194874675575 | 59.39176668539124
33 | 234987 | 8 | 90 | 0.04411794524416034 | 3.97061507197443
34 | 12398 | 8 | 62 | 0.002327678914736134 | 0.1443160927136403
35 | 92874 | 8 | 94 | 0.01743675201864847 | 1.639054689752956
36 | 29387 | 8 | 195 | 0.005517301199173315 | 1.075873733838796
Spreadsheet: 784801d1655963457-how-to-create-pivot-table-based-the-financial-year-and-not-for-the-calendar-year-pivot-query-
Sheet: Data

Date | ACTIVITY | Unit | Site 1 | Site 2 | Site 3
2019-04-01 00:00:00 | [NAME] | KWH | 630 | 325 | 515
2019-05-01 00:00:00 | [NAME] | KWH | 165 | 326 | 516
2019-06-01 00:00:00 | [NAME] | KWH | 412 | 327 | 517
2019-07-01 00:00:00 | [NAME] | KWH | 425 | 328 | 518
2019-08-01 00:00:00 | [NAME] | KWH | 895 | 329 | 519
2019-09-01 00:00:00 | [NAME] | KWH | 126 | 330 | 520
2019-10-01 00:00:00 | [NAME] | KWH | 138 | 331 | 521
2019-11-01 00:00:00 | [NAME] | KWH | 879 | 332 | 522
2019-12-01 00:00:00 | [NAME] | KWH | 789 | 333 | 523
2020-01-01 00:00:00 | [NAME] | KWH | 168 | 334 | 524
2020-02-01 00:00:00 | [NAME] | KWH | 169 | 335 | 525
2020-03-01 00:00:00 | [NAME] | KWH | 170 | 336 | 526
2020-04-01 00:00:00 | [NAME] | KWH | 171 | 337 | 527
2020-05-01 00:00:00 | [NAME] | KWH | 172 | 338 | 528
2020-06-01 00:00:00 | [NAME] | KWH | 173 | 339 | 529
2020-07-01 00:00:00 | [NAME] | KWH | 174 | 340 | 530
2020-08-01 00:00:00 | [NAME] | KWH | 175 | 341 | 531
2020-09-01 00:00:00 | [NAME] | KWH | 176 | 342 | 532
2020-10-01 00:00:00 | [NAME] | KWH | 177 | 343 | 533
2020-11-01 00:00:00 | [NAME] | KWH | 178 | 344 | 534
2020-12-01 00:00:00 | [NAME] | KWH | 179 | 345 | 535
2021-01-01 00:00:00 | [NAME] | KWH | 180 | 346 | 536
2021-02-01 00:00:00 | [NAME] | KWH | 181 | 347 | 537
2021-03-01 00:00:00 | [NAME] | KWH | 182 | 348 | 538
2021-04-01 00:00:00 | [NAME] | KWH | 183 | 349 | 539
2021-05-01 00:00:00 | [NAME] | KWH | 184 | 350 | 540
2021-06-01 00:00:00 | [NAME] | KWH | 185 | 351 | 541
2021-07-01 00:00:00 | [NAME] | KWH | 186 | 352 | 542
2021-08-01 00:00:00 | [NAME] | KWH | 187 | 353 | 543
2021-09-01 00:00:00 | [NAME] | KWH | 188 | 354 | 544
2021-10-01 00:00:00 | [NAME] | KWH | 189 | 355 | 545
2021-11-01 00:00:00 | [NAME] | KWH | 190 | 356 | 546
2021-12-01 00:00:00 | [NAME] | KWH | 191 | 357 | 547
2022-01-01 00:00:00 | [NAME] | KWH | 192 | 358 | 548
2022-02-01 00:00:00 | [NAME] | KWH | 193 | 359 | 549
2022-03-01 00:00:00 | [NAME] | KWH | 194 | 360 | 550
2022-04-01 00:00:00 | [NAME] | KWH
Spreadsheet: 540366d1506659587-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #19. 15 September 2017

Paychecks Dated 15 September 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  | [NAME]-first week |  |  |  |  | [NAME]-second week
 |  | Total Hours | Total Hours | Regular Hours | Overtime Hours | Total Hours | Total Hours |  | Overtime Hours |  | Overtime Hours |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 2017-08-28 00:00:00 | 2017-08-29 00:00:00 | 2017-08-30 00:00:00 | 2017-08-31 00:00:00 | 2017-09-01 00:00:00 | 2017-09-05 00:00:00 | 2017-09-06 00:00:00 | 2017-09-07 00:00:00 | 2017-09-08 00:00:00 | 2017-09-08 00:00:00 | 2017-09-08 00:00:00
Job |  |  |  |  |  |  |  | > | 40 | > | 40
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  | x' | x | x | x | x
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x | x | x |  | x | x
3 | customer #3 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.75 | 10 | 9.75 | 11 | 8.5
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11.5 | 10 | 10.25
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.5
 | Hours-Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Hours-Overtime
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 8.5 | 9.75 | 9.5 | 8
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25 | 8.5 | 9 |  | 8.5 | 3.5
 | Hours-Regular
 | Hours-Overtime
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail
 | Subtotal-detail
 | all must equal zero.
 | Regular Hours: all must equal zero.
 | Overtime Hours: all must equal zero.
 | Total Hours less Total Job Hours: must equal zero.
Sales |  | 0
 | n/a | 0
Employee-Office/Overhead |  | regular | overtime | total
Sales/Officer Salary |  | total
 | [NAME] | 0 |  | 0
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 85
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
 |  | regular | Overtime | Total
 | grand total hours
 | check
Spreadsheet: 201198d1355913184-counting-the-no-of-filled-columns-according-to-another-column-counting-number-of-filled-cells
Sheet: Sheet1

id | B | C | earning members
1 | 180000 | 40000
1
1
1
2 | 170000
2
2
2
3 | 170000
3
3
4 | 200000
4
4
5 | 180000 | 300000
5 | 200000
5
5
6 | 180000 | 300000
6 | 600000
6
7 | 150000 | 300000
7 | 500000
7
7
8 | 150000
8 | 0
8
8
9 | 150000
9
9
10 | 120000
10
10
10
Spreadsheet: 17b45d52-34fe-4407-9c22-f4ccfd194626
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2010-12-01 00:00:00 | 204 | Number | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: kevin_hyatt__19752__Sun Devil Fuel011108
Sheet: Station Flow

 |  |  |  |  | Sun Devil Project
 |  |  |  |  | Station Flow & Pressure
 |  | 100 % Load |  |  | 100 % Load
 |  | Red Rock Base |  |  | Sun Devil
 |  | 1210 MMcf/d | Ps |  | 1520 MMcf/d |  | Ps
 |  |  |  |  |  | W/O Fuel
Sta. # | 9 | 344 | 775 |  | 353 |  | 775
Sta. # | 8
Sta. # | 7
Sta. # | 6
Sta. # | 5 | 343 | 719 |  | 352 |  | 719
Sta. # | 4 |  |  |  | 2044
Sta. # | 3 |  |  |  | 2040
Sta. # | 2 |  |  |  | 2029
Sta. # | 1.5 |  |  |  | 2027
Sta. # | 1 |  |  |  | 1522
 | Kingman | 1210 |  |  | 1300
 | Bloomfield | 885 |  |  | 1697 | 1630
 | Bisti | 885 |  |  | 1697 | 1630
 | Gallup | 885 |  |  | 1697 | 1630
 |  | 100 % Load |  |  |  |  | 90 % Load
 |  |  |  |  |  |  | 1368
 |  | Red Rock Base |  |  | Sun Devil
 |  | 1210 MMcf/d | Ps |  | 1368 MMcf/d |  | Ps
Sta. # | 9 | 344 | 775 |  | 330 |  | 775
Sta. # | 8
Sta. # | 7
Sta. # | 6
Sta. # | 5 | 343 | 719 |  | 329 |  | 729
Sta. # | 4 |  |  |  | 1905
Sta. # | 3 |  |  |  | 1901
Sta. # | 2 |  |  |  | 1890
Sta. # | 1.5 |  |  |  | 1890
Sta. # | 1 |  |  |  | 1386
 | Kingman | 1210 |  |  | 1166
 | Bloomfield | 885 |  |  | 1579 | 1517
 | Bisti | 885 |  |  | 1579 | 1517
 | Gallup | 885 |  |  | 1579 | 1517
 |  |  |  |  | Sun Devil Project
 |  |  |  |  | Station Flow & Pressure
 |  | 100 % Load |  |  |  |  | 80 % Load
 |  |  |  |  |  |  | 1216
 |  | Red Rock Base |  |  | Sun Devil
 |  | 1210 MMcf/d | Ps |  | 1216 MMcf/d |  | Ps
Sta. # | 9 | 344 | 775 |  | 273 |  | 775
Sta. # | 8
Sta. # | 7
Sta. # | 6
Sta. # | 5 | 343 | 719 |  | 272 |  | 787
Sta. # | 4 |  |  |  | 1731
Sta. # | 3 |  |  |  | 1729
Sta. # | 2 |  |  |  | 1719
Sta. # | 1.5 |  |  |  | 1719
Sta. # | 1 |  |  |  | 1216
 | Kingman | 1210 |  |  | 996
 | Bloomfield | 885 |  |  | 1462 | 1404
 | Bisti | 885 |  |  | 1462 | 1404
 | Gallup | 885 |  |  | 1462 | 1404
 |  | 100 % Load |  |  |  |  | 70 % Load
 |  |  |  |  |  |  | 1064
 |  | Red Rock Base |  |  | Sun Devil
 |  | 1210 MMcf/d | Ps |  | 1064 MMcf/d |  | Ps
Sta. # | 9 | 344 | 775 |  | 236 |  | 775
Sta. # | 8
Sta. # | 7
Sta. # | 6
Sta. # | 5 | 343 | 719 |  | 235 |  | 829
Sta. # | 4 |  |  |  | 1577
Sta. # | 3 |  |  |  | 1575
Sta. # | 2 |  |  |  | 1568
Sta. # | 1.5 |  |  |  | 1568
Sta. # | 1 |  |  |  | 1068
 | Kingman | 1210 |  |  | 844
 | Bloomfield | 885 |  |  | 1344 | 1291
 | Bisti | 885 |  |  | 1344 | 1291
 | Gallup | 885 |  |  | 1344 | 1291
 |  |  |  |  | Sun Devil Project
 |  |  |  |  | Fuel Anaylsis
 |  | 100 % Load |  |  |  |  | 60 % Load
 |  |  |  |  |  |  | 912
 |  | Red Rock Base |  |  | Sun Devil
 |  | 1210 MMcf/d | Ps |  | 912 MMcf/d |  | Ps
Sta. # | 9 | 344 | 775 |  | 198 |  | 775
Sta. # | 8
Sta. # | 7
Sta. # | 6
Sta. # | 5 | 343 | 719 |  | 197 |  | 856
Sta. # | 4 |  |  |  | 1421
Sta. # | 3 |  |  |  | 1421
Sta. # | 2 |  |  |  | 1414
Sta. # | 1.5 |  |  |  | 1414
Sta. # | 1 |  |  |  | 914
 | Kingman | 1210 |  |  | 692
 | Bloomfield | 885 |  |  | 1226 | 1178
 | Bisti | 885 |  |  | 1226 | 1178
 | Gallup | 885 |  |  | 1226 | 1178