tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__215__DYNEGY-ICE VOL May25
Sheet: Historical Volumes

ICE
Historical Volumes
DATE | TOTAL POWER (MWH) | TOTAL GAS (MMBTU) | PHY GAS | FIN GAS | TOTAL CRUDE PRODUCTS (BBL)
2001-04-16 00:00:00 | 3734400 | 55195000 | 6667500 | 48527500
2001-04-17 00:00:00 | 3230400 | 79525000 | 4052500 | 75472500
2001-04-18 00:00:00 | 4234200 | 88787500 | 7405000 | 81382500
2001-04-19 00:00:00 | 4261600 | 78415000 | 6287500 | 72127500
2001-04-20 00:00:00 | 3789225 | 106785000 | 30285000 | 76500000
2001-04-23 00:00:00 | 5221400 | 81477500 | 8845000 | 72632500
2001-04-24 00:00:00 | 4635200 | 141132500 | 31765000 | 109367500
2001-04-25 00:00:00 | 3381200 | 67232500 | 15657500 | 51575000
2001-04-26 00:00:00 | 4088400 | 99285000 | 8002500 | 91282500
2001-04-27 00:00:00 | 2755800 | 73267500 | 15375000 | 57892500
2001-04-30 00:00:00 | 3824800 | 91940000 | 18080000 | 73860000 | 7156000
2001-05-01 00:00:00 | 2898400 | 50050000 | 16697500 | 33352500 | 3150000
2001-05-02 00:00:00 | 6100200 | 122405000 | 50730000 | 71675000 | 5836000
2001-05-03 00:00:00 | 4544000 | 138990000 | 31740000 | 107250000 | 7490000
2001-05-04 00:00:00 | 2296400 | 72107500 | 14362500 | 57745000 | 4973000
2001-05-07 00:00:00 | 5578400 | 212747500 | 93077500 | 119670000 | 810000
2001-05-08 00:00:00 | 5753600 | 284415000 | 129925000 | 154490000 | 12587000
2001-05-09 00:00:00 | 6257800 | 315477500 | 208852500 | 106625000 | 6083000
2001-05-10 00:00:00 | 2959600 | 234157500 | 99510000 | 134647500 | 8784000
2001-05-11 00:00:00 | 8300400 | 360852500 | 216390000 | 144462500 | 6610000
2001-05-14 00:00:00 | 5596800 | 231145000 | 96370000 | 134775000 | 3240000
2001-05-15 00:00:00 | 8357600 | 257700000 | 33457500 | 224242500 | 11014000
2001-05-16 00:00:00 | 7342400 | 240665000 | 27540000 | 213125000 | 10827000
2001-05-17 00:00:00 | 4808400 | 142877500 | 15405000 | 127472500 | 8806000
2001-05-18 00:00:00 | 3836400 | 151650000 | 10970000 | 140680000 | 6475000
2001-05-21 00:00:00 | 3655650 | 158930000 | 14977500 | 143952500 | 10125000
2001-05-22 00:00:00 | 5180400 | 183680000 | 32710000 | 150970000 | 13748000
2001-05-23 00:00:00 | 5684800 | 164747500 | 13107500 | 151640000 | 8192000
2001-05-24 00:00:00 | 3870400 | 247477500 | 43422500 | 204055000 | 8916000
2001-05-25 00:00:00 | 1721000 | 169170000 | 34990000 | 134180000 | 6303000
Spreadsheet: 778380d1651042505-fetching-cell-value-with-multiple-criteria-book3
Sheet: Format Auto

 | Pulse | in | Season | Rabi |  | Pulse | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Cereal | in | Season | Rabi |  | Cereal | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Oilseeds | in | Season | Rabi |  | Oilseeds | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Spices | in | Season | Rabi |  | Spices | in | Season | Kharif
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) |  | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha)
 | Other Crops
 | Crop | Area (Hectare) | Production (Tonnes) | Yield (T / Ha) | Season
Spreadsheet: 63868d1264724821-automatically-divide-list-into-even-segments-example
Sheet: Import

 | [NAME] |  |  | Del. Date |  |  |  |  |  |  |  |  |  |  | Workload
 | 350A | N | 1 | '01/29/2010 |  | 21 | 21 | 0 | 0 | 0 | 21 | 0 | 0 | 0 | 415
 | 351A | N | 1 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 473
 | 352A | N | 3 | '01/29/2010 |  | 20 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 452
 | 353A | N | 1 | '01/29/2010 |  | 20 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 420
 | 356A | N | 7 | '01/29/2010 |  | 20 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 440
 | 357A | N | 99 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 359
 | 358A | N | 2 | '01/29/2010 |  | 17 | 17 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 312
 | 359A | N | 2 | '01/29/2010 |  | 17 | 17 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 344
 | 361A | N | 13 | '01/29/2010 |  | 20 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 401
 | 363A | N | 14 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 406
 | 364A | N | 9 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 380
 | 366A | N | 11 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 388
 | 367A | N | 25 | '01/29/2010 |  | 16 | 16 | 0 | 0 | 0 | 16 | 0 | 0 | 0 | 407
 | 368A | N | 19 | '01/29/2010 |  | 19 | 19 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 547
Spreadsheet: 857777d1706693369-sum-of-values-corresponding-to-a-range-of-cells-sum-of-values-ans2
Sheet: Sheet1

 |  | Price | Total
 | a | 100
 | b | 200
 | c | 300
 |  | 400
 | d | 500
 |  | 600
 | e | 700
 | f | 800
 |  | 900
 |  | 1000
 |  | 1100
 |  | 1200
 |  | 1300
 | g | 1400
 | h | 1500
 |  | 1600
Spreadsheet: 12b71ba6-6873-4039-aaf5-5d95115dc237
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2012-11-06 00:00:00 | State Senate District 16
 | [NAME], r | [NAME], d | [NAME], [NAME] | [NAME]
Bow | 2212 | 2161 | 114 | 1
Candia | 1355 | 855 | 73
Dunbarton | 920 | 665 | 53 | 1
[NAME] | 3793 | 2891 | 212 | 17
[NAME] | 2293 | 2574 | 117
[NAME] | 1793 | 2435 | 183 | 3
[NAME] 12 | 1510 | 1899 | 169 | 9
Totals | 13876 | 13480 | 921 | 31
 | State Senate District 17
 | [NAME], r | [NAME], d | [NAME]
Allenstown | 1014 | 992
Chichester | 723 | 686 | 2
[NAME] | 1400 | 1044 | 11
[NAME] | 1241 | 1113
Loudon | 1477 | 1213 | 3
Northwood | 1177 | 1079
[NAME] | 1369 | 1211 | 8
Pembroke | 1667 | 1884
Pittsfield | 926 | 864
[NAME] | 2575 | 1938 | 5
[NAME] | 1103 | 1114 | 3
Totals | 14672 | 13138 | 32
 | State Senate District 18
 | [NAME], r | [NAME], d | [NAME], i | [NAME]
Litchfield | 1911 | 1762 | 593
[NAME] | 659 | 1741 | 275 | 3
[NAME] 6 | 1876 | 2364 | 523 | 8
[NAME] | 988 | 1919 | 525 | 5
[NAME] 8 | 1538 | 2295 | 718 | 5
[NAME] 9 | 1052 | 2058 | 744 | 6
Totals | 8024 | 12139 | 3378 | 27
Spreadsheet: 687439d1595214000-populate-a-spread-sheet-based-on-data-that-is-structured-differently-example-workbook-updated
Sheet: Raw Data 

FRESH PRODUCE ASSESSMENT FORM
Product:
105919-Apple Pink [NAME]
Vendor:
Grower:
NINE MI
blue
Delivery Date:
Total Ordered:
2020-07-18 00:00:00
72
Type / Variety:
P.O. Number:
1013
Total Received:
0
Class:
ONE
Packed On:
Use By:
2020-07-16 00:00:00
Harvest Date:
Best Before:
Total Rejected:
Receival Temp:
72
9.1 °C
QUALITY CRITERIA
ACTION
DEFECT
[NAME]
DEFECT CRITERIA
MAJOR
MINOR
DEFECT
[NAME]
Unit of Measurement
KG
Foreign Material
4.59
0
Insects
NIL tolerance per consignment (0%) of contamination of live/prominent insects/pests (i.e. [NAME], grubs, slugs/snails, beetles, spiders etc).
No. Products With Defects
Total Units Assessed
4.6
0
72
No Cartons used for Assessment
3
Total % Out of Spec
0.063
0
Quantity Rejected
72
Use X to Designate
Accept
Reject
X
Digital Image
Yes
X
No
Comments:
ASSESSED BY
[NAME] 1946
ASSESSMENT DATE
2020-07-18 00:00:00
QCRF 006
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 13

Name | lbs | oz | Oz (total) | Points
 | 2 | 1
 | 1 | 2
 | 2 | 12
 | 4 | 7
 | 4 | 9
 | 8 | 12
 | 5 | 0
 | 6 | 1
 | 4 | 8
 | 2 | 7
 | 3 | 5
 | 1 | 9
 | 8 | 11
 | 8 | 10
 | 6 | 1
 | 2 | 12
 | 0 | 15
 | 5 | 8
 | 1 | 5
Spreadsheet: 718256d1613060522-creating-annual-series-from-decade-data-more-efficient-suggestion-thank-you-index-aggregate-and-index-match-bns1992-
Sheet: Sheet1

 | 5-yearly data |  |  |  | Converting into an annual series (linear)
Example 1:  year not as date, as a number '2010'
 | Year | 2010 | 2015 | 2020 |  | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | Data: | 0 | 50 | 200
 |  |  |  |  |  | F6  formula  =$[NAME]) |  |  |  |  |  |  | P6 formula =$B5+((($D5-$B5)/($D3-$B3))*P4)
Example 2: year, as a date, '1/1/2010'
Year |  | 2010-01-01 00:00:00 | 2015-01-01 00:00:00 | 2020-01-01 00:00:00
Data: |  | 0 | 50 | 100
Spreadsheet: 708554d1607929373-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: PORTUGAL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 112937d1308901396-conditional-formatting-on-a-line-of-data-sample-data
Sheet: MMO - PO

CourseName | Course Code | StartDate | Completion Date | EndDate | MaxDelegates | Trainer1 | VenueName | Address | Postcode | Course Status
A course on something | ABC 123 | 2011-07-18 00:00:00 | 2011-07-11 00:00:00 | 2011-07-20 00:00:00 | 16 | [NAME] | A Building | A Town | AB1 23C
Cancelled
Despatched
In Production
Spreadsheet: 677332d1589307641-vlookup-with-wildcard-not-working-formula
Sheet: SHEET1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-30 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 200
2020-03-20 00:00:00 | CARD PAYMENT TO WILKO RETAIL LIMITED,1.50 GBP, RATE 1.00/GBP ON 18-03-2020 |  | 1.5
2020-03-19 00:00:00 | CARD PAYMENT TO SELCO TRADING CTR,64.56 GBP, RATE 1.00/GBP ON 17-03-2020 |  | 50
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO THAMES WATER REF 123456789, MANDATE NO 0080 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO MORTGAGES 999999A, MANDATE NO 0085 |  | 150
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO BG SERVICES REF 987654159D, MANDATE NO 0079 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO REF GHTY7415, MANDATE NO 0059 |  | 300
2020-03-11 00:00:00 | ARRANGED OVERDRAFT USAGE FEE |  | 20
2020-02-19 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 3000
2020-02-19 00:00:00 | MAINTAINING THE ACCOUNT - MONTHLY FEE |  | 5
Spreadsheet: daren_farmer__6357__Devon STX
Sheet: Sheet1

[NAME] (PennzEnergy) South Texas Properties
 |  |  | January Volumes
Pipeline | Location | [NAME] | Base | Swing | Total | Comments
[NAME] | [NAME] | Gulf Plains Plant | 8156 | 429
 | [NAME] | Gulf Plains Plant | 3166 | 167
Carthage | American Central | Tailgate | 62055 | 6895
 | [NAME] | Tailgate | 0 | 500
 | Ruby-Lacy | Tailgate | 0 | 250
 | [NAME] | Tailgate | 11199 | 1244 |  | Gathering nomination on [NAME] gathering system as Pennzoil's agent
Corpus Christi Gas Gath. | Virginia | 3358 | 837 | 63
Delhi | Volpe | LL-1-0027 | 731 | 64
 | [NAME] | LL-1-0027 | 52 | 5
 | Comitas C.P. | LL-1-0030 | 268 | 23
 |  |  |  |  |  | Termed up with Delhi (evergreen)
Gulf Energy | [NAME] | 19-1043-00 | 403 | 45 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 1061 | 92
 | Tejas Plant | 29320 | 106 | 9
 | Jennings 63 Plant | 440-565 | 4646 | 404
 | Haynes Plant | 440-557 | 386 | 34 |  | Termed up with Tejas thru 3/00
 | Haynes 17, 18 | 23-603-01 | 1887 | 164 |  | Termed up with Tejas thru 3/00
 | [NAME] | 31-504-04 | 4869 | 423
 | Garza Plant | 440-552 | 0 | 0 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 71
Lone Star | Sandtrap | 178477 | 3641 | 405 |  | Termed up with TXU Energy thru 11/00
Midcon Texas | [NAME] / TOC | 5553 | 304 | 23
 | Hall Plant | 5576 | 611 | 53
 | Hankamer | 5905 | 207 | 23
 | Jennings Ranch | 446 | 2172 | 189
Spreadsheet: 25958d1217687877-inserting-a-line-into-a-column-graph-addlinetocolumnchart
Sheet: By Series

 | Value
2008-08-07 00:00:00 | 15
2008-08-06 00:00:00 | 16
2008-08-05 00:00:00 | 16
2008-08-04 00:00:00 | 10
2008-08-03 00:00:00 | 14
2008-08-02 00:00:00 | 9
2008-08-01 00:00:00 | 10
2008-07-31 00:00:00 | 8
2008-07-30 00:00:00 | 6
2008-07-29 00:00:00 | 4
2008-07-28 00:00:00 | 3
2008-07-27 00:00:00 | 3
 |  | Average | [NAME]
 | 0 | 7.5 | 15
 | 1 | 7.5 | 15
 | Data |  |  | Chart the Dated Values (Blue) |  |  |  |  |  |  |  | Add Horizontal Line Data (Red) |  |  |  |  |  |  |  | [NAME] "Average" to XY Scatter Series |  |  |  |  |  |  |  | Secondary Axes: Scale X 0 to 1, |  |  |  |  |  |  |  | Embellish Chart
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide Ticks & Labels; [NAME]
Spreadsheet: kate_symes__18318__DJ Index 4-20_4-21
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-20 00:00:00
Flow Date: | 4/20/01-4/21/01
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 235 | 400
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 170 | 400
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 232.8159340659341 | 5824
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 175 | 400
 | Firm Trades Purchases | 175 | 200
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 152.3175542406312 | 8112
 | Firm Trades Purchases | 157.9545454545454 | 1760
[NAME] | Firm Trades Sales | 73.38545454545456 | 2200
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 185 | 112
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 82.34042553191489 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 200.8846153846154 | 10400
 | Firm Trades Purchases | 191.5 | 800
[NAME] | Firm Trades Sales | 176.3529411764706 | 3400
 | Firm Trades Purchases | 168.5714285714286 | 1400
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 170.75 | 3200
 | Firm Trades Purchases | 168.2 | 4000
[NAME] | Firm Trades Sales | 95.35042735042734 | 3744
 | Firm Trades Purchases | 92.71428571428572 | 1400
Spreadsheet: 113247d1309203988-help-with-line-chart-book1
Sheet: Sheet1

Date | Time | [NAME] (ms) | [NAME] ([NAME]) | Upload ([NAME])
2011-06-26 00:00:00 | 09:00:00 | 10 | 4.55 | 3.62
2011-06-26 00:00:00 | 12:00:00 | 11 | 3.79 | 2.73
2011-06-26 00:00:00 | 16:00:00 | 10 | 2.82 | 3.54
2011-06-27 00:00:00 | 09:00:00 | 12 | 3.21 | 3.59
2011-06-27 00:00:00 | 12:00:00 | 11 | 2.98 | 3.62
2011-06-27 00:00:00 | 16:00:00 | 10 | 4.24 | 3.53
2011-06-28 00:00:00 | 09:00:00 | 10 | 3.85 | 3.21
2011-06-28 00:00:00 | 12:00:00 | 13 | 3.77 | 3.59
2011-06-28 00:00:00 | 16:00:00 | 10 | 3.83 | 3.76
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: September

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 104
Name 105
Name 106 |  |  |  |  |  |  |  |  | Done Totals
Name 107 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 108
Name 109
Name 110 |  |  |  |  | dd
Name 111
Name 112
Name 113
Name 114
Name 115
Spreadsheet: 777230d1650270920-date-formatting-issue-errors-again-aligw
Sheet: Sheet1

Open Time | AliGW
2022-04-01 00:05:15
2022-04-01 00:13:04
2022-04-03 11:10:20
2022-04-03 12:42:30
2022-04-04 10:05:39
2022-04-04 11:44:49
2022-04-05 09:52:46
2022-04-05 16:08:44
2022-04-05 16:13:51
2022-04-06 10:53:09
2022-04-06 12:02:40
2022-04-06 14:58:21
2022-04-07 13:02:21
2022-04-07 15:13:20
2022-10-04 11:26:00
2022-10-04 12:47:20
2022-10-04 14:32:51
2022-10-04 14:39:00
2022-11-04 10:51:27
2022-11-04 11:12:46
2022-11-04 11:22:21
2022-11-04 13:08:34
2022-11-04 13:34:07
2022-11-04 14:05:34
2022-12-04 11:33:25
2022-12-04 13:26:49
2022-12-04 14:22:19
14/04/2022 10:56:41
14/04/2022 13:11:50
14/04/2022 13:23:45
14/04/2022 13:43:08
14/04/2022 14:41:06
Spreadsheet: 197864d1354584476-veritical-to-horizontal-data-horizontal-data
Sheet: Sheet1

5431135712 | [PHONE];
5431143072 | [PHONE];[PHONE];
5431052856 | [PHONE];[PHONE];[PHONE];
5431137830 | [PHONE];[PHONE];[PHONE];[PHONE];
5431052858 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431142489 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431051978 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431143073 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052864 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431135710 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052857 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052865 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431137829 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052866 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052849 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431142814 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431140325 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052863 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
9990070857 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052851 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
5431052855 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];
 | [PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE];[PHONE]
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: Bâtisse C

 | Bâtisse C
Côté Univerco | Local 20 |  | Local 19 |  | Local 18 |  | Local 17 |  | Local 16 |  | Local 15 |  | Local 14 |  | Local 13 |  | Local 12 |  | Local 11
 | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10 |  | 10 x 10
 | [NAME] |  | [NAME] |  | [NAME] |  | 0 |  | 0 |  | 0 |  | [NAME] |  | 0 |  | 0 |  | [NAME]
 | [PHONE] |  | [PHONE] |  | [PHONE] |  | 0 |  | 0 |  | 0 |  | [PHONE] |  | 0 |  | 0
 | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  |  |  |  |  |  |  | Paiement dû le:
 | 2013-03-23 00:00:00 |  | 2013-03-13 00:00:00 |  | 2013-03-15 00:00:00 |  |  |  |  |  |  |  | 2013-03-15 00:00:00
 | Local 1 |  | Local 2 |  | Local 3 |  | Local 4 |  | Local 5 |  | Local 6 |  | Local 7 |  | Local 8 |  | Local 9
 | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | 10 x 15 |  | Local 10
 | Alain Bisaillon |  | [NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  | [NAME] |  | [NAME] |  | 0 |  | 10 x 10
 | 0 |  | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 |  | [PHONE] |  | [PHONE] |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Paiement dû le: |  |  |  |  |  |  |  |  |  | Paiement dû le: |  | Paiement dû le: |  |  |  |  |  | 0
 |  |  | 2013-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-02-24 00:00:00 |  | 2013-03-09 00:00:00 |  |  |  |  |  | 0
Côté Douglas
LÉGENDE |  |  |  | TARIFS/mois
LOCAL VIDE |  |  |  | 10 x 10 |  | 75
À JOUR |  |  |  | 10 x 15 |  | 100
PASSÉ DÛ
RÉSERVÉ |  |  |  | Total mensuel (sans tx)
 |  |  |  | 600
Spreadsheet: 96526d1295908474-time-window-parsing-assistance-test
Sheet: Sheet1

Entry | Number | x | Start | End | Prime | x | x | Group | Entry | Start Date | Start Time | End Date | End Time | Entry | Start Date | Start Time | End Date | End Time
Test1 |  |  | 1101250600 | 1101260559 | 150 |  |  |  | Test1 | 110125 | 0600 | 110126 | 0559 | Test1
Test2 |  |  | 1101250600 | 1101250900 | 140 |  |  |  | Test2 | 110125 | 0600 | 110125 | 0900 | Test2
Test2 |  |  | 1101251100 | 1101260200 | 140 |  |  |  |  | 110125 | 1100 | 110126 | 0200
Test2 |  |  | 1101260300 | 1101260559 | 140 |  |  |  |  | 110126 | 0300 | 110126 | 0559
Test3 |  |  | 1101250600 | 1101251400 | 90 |  |  |  | Test3 | 110125 | 0600 | 110125 | 1400 | Test3
Test3 |  |  | 1101260000 | 1101260559 | 90 |  |  |  |  | 110126 | 0000 | 110126 | 0559
Test3 |  |  | 1101252300 | 1101260559 | 90 |  |  |  |  | 110125 | 2300 | 110126 | 0559
Original Data |  |  |  |  |  |  |  |  | This Section Splits the Date/Time from 1 cell format |  |  |  |  | Parsed Data
 |  |  | O2:S8 Expected Output
 |  |  | Test1 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-26 00:00:00 | 05:59:00
 |  |  | Test2 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-25 00:00:00 | 09:00:00
 |  |  |  | 2011-01-25 00:00:00 | 11:00:00 | 2011-01-26 00:00:00 | 02:00:00 |  | As you can see, data from row 7 is removed because the time window is during the time window in row 8.
 |  |  |  | 2011-01-26 00:00:00 | 03:00:00 | 2011-01-26 00:00:00 | 05:59:00
 |  |  | Test3 | 2011-01-25 00:00:00 | 06:00:00 | 2011-01-25 00:00:00 | 14:00:00
 |  |  |  | 2011-01-25 00:00:00 | 23:00:00 | 2011-01-26 00:00:00 | 05:59:00
Spreadsheet: 04b451fc-c174-40e5-b134-e146adc12fb0
Sheet: Sheet1

Unnamed: 0 | College of Agriculture | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2011-11-07 00:00:00 | Budget Data for Fiscal Year 2011
file:c\2011\budget_data
 |  | Amount | Percent |  | FTE's
College of Agriculture
State Appropriations |  | 10072055 | 0.8715 |  | 94.4295
Grants,Contract, Other Funds |  | 1484699 | 0.1285 |  | 8.67011
Total College of Agriculture |  | 11556754 | 1 |  | 103.09961
Budget by Classification
General-Use State Funds
Faculty & Adminstrative Salaries & Benefits |  | 8061932 | 0.8004 |  | 77.03
Classified & Student Salaries & Benefits |  | 1099627 | 0.1092 |  | 19.3995
Operating Expenditures |  | 910496 | 0.0904 |  | 0
Total General-Use State |  | 10072055 | 1 |  | 96.4295