tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_zufferli__16724__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 84555d1284597912-excel-2007-find-unique-item-count-and-percentage-w-pivot-table-pivot_example
Sheet: Sheet2

Sum of 09/13 | Column Labels
Row Labels | [NAME] | [NAME] | [NAME] | [NAME] | Sue | Grand Total
AD |  |  | 8 |  | 4 | 12
Designer
[NAME] |  | 13 |  |  |  | 13
Grand Total |  | 13 | 8 |  | 4 | 25
Spreadsheet: 154687d1336510958-formula-to-return-where-available-multiple-values-based-on-reference-cell-sample-2
Sheet: Sheet1

 |  |  |  |  |  | Course
A | [NAME] |  |  |  |  | A | [NAME] | Kirstie
A | Kirstie |  |  |  |  | B | Ana
B | Ana |  |  |  |  | C | [NAME]
C | [NAME] |  |  |  |  | D | [NAME]
D | [NAME] |  |  |  |  | E
F | [NAME] |  |  |  |  | F | [NAME]
I | Rich |  |  |  |  | G
M | Soofyaan |  |  |  |  | H
M | Betty |  |  |  |  | I | Rich
M | [NAME] |  |  |  |  | J
M | Dillon |  |  |  |  | K
M | Kirit |  |  |  |  | L
N | Vit |  |  |  |  | M | Soofyaan | Betty | [NAME] | Dillon | Kirit
N | Monika1 |  |  |  |  | N | Vit | Monika1 | Sanjay | Rod
N | Sanjay |  |  |  |  | O | Marta | [NAME] | Vit | Monika2
N | Rod |  |  |  |  | P
O | Marta |  |  |  |  | Q
O | [NAME]
O | Vit
O | Monika2
Spreadsheet: 136327d1326542177-cell-sum-according-to-criteria-apa
Sheet: Week 1 

 | [NAME] |  | Monday APA League 2012 |  | 2012-01-02 00:00:00
 | VS.
 | Team | Player Name | Games Must win | 8-Break | 8-B & Run | Safty | Won | Lost
 |  | [NAME] |  |  |  |  | W
 |  | Kaleena |  |  |  |  |  | L
 |  | [NAME] |  |  |  |  |  | L
 |  | Billy |  |  |  |  | W
 |  | Team Played |  | Wins |  | Loss
Spreadsheet: 3a3b4eb3-0933-4899-b4d9-5182bb07641b
Sheet: Sheet1

The information contained on this page is current as of the time it is posted and is subject to change up to and including the day of the event due to public safety, weather, and other factors. If you have any specific questions about an event, please contact the event organizers associated with the event. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Name of Event | Date | Road Closure Times | Location | Event Contact Person
St. Paul JCC Dreidel Dash | 2013-12-08 00:00:00 | 12am-2:30pm | Start at 616 S Mississippi River Blvd. South to Worcester, Cleveland, St. Paul Ave. End at 1375 St. Paul Ave | Aviva [NAME] -   [PHONE]
Jumping [NAME] | 2013-12-21 00:00:00 | 2pm-6:30pm | Harriet Island - Lilydale Road | [NAME]
Polar Dash | 2014-01-01 00:00:00 | 9am-12:30pm | Mississippi River Blvd between Shriner's Hospital & Ford Plant | [NAME][PHONE]
Winter Carnival - Moon Glow Parade | 2014-01-23 00:00:00 | 6pm-7pm | 5th/Robert to Rice Park | [NAME]
Winter Carnival - Autonomous Snowplow Competition | 1/23/2014 - 1/26/2014 | All Day | 4th Street between Market & Washington | [NAME]
Winter Carnival - Securian Run | 2014-01-25 00:00:00 | 9am-12:30pm | Start & Finish at 6th/Jackson, run downtown & Shepard | [NAME]
Winter Carnival - Grand Day Parade | 2014-01-25 00:00:00 | 2pm-3:30pm | 7th Street between Smith Bridge & Rice Park | [NAME]
Winter Carnival - Torchlight Parade | 2014-02-01 00:00:00 | 5:30pm-8:30pm | Staging in Union Depot Lot - Parade on 5th Street between Wacouta & Washington | [NAME]
Spreadsheet: theresa_staab__39626__Gas Avails Restricted flows - Sept 2001
Sheet: Sheet1

Gas Avails. - Powder River
2001-09-01 00:00:00
Final
 | Mcf |  |  |  | Mmbtu | MMBtu |  |  | Allocated | Allocated | Allocated
 | Wellhead |  |  |  | Wellhead | Less fuel |  |  | mmBtu  at | mmBtu  at | mmcf  at
 | Nomination | Firm Capacity | IT | Btu Factor | Confirmation | to Glennrock |  |  | Glennrock | Wellhead | Wellhead
[NAME]/So. Kitty/Maverick
Kennedy #1 | 3100 |  |  | 0.956
Kennedy #2 | 3500 |  |  | 0.954
Kennedy #3 | 3500 |  |  | 0.958
Kennedy #4 | 4100 |  |  | 0.957
Kennedy Box Draw Total
S. Kitty #1 | 4700 |  |  | 0.957
S. Kitty #2 | 10000 |  |  | 0.955
S. Kitty #4 | 9800 |  |  | 0.945
S. Kitty #5 | 3200 |  |  | 0.953
Kennedy S. Kitty Total
Kennedy Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000
Wellstar #1 | 1100 |  |  | 0.939
Wellstar #2 | 1500 |  |  | 0.93
Wellstar Box Draw Total
Box Draw Total
[NAME]
Clydesdale
Clydesdale #1 | 5800 |  |  | 0.944
Clydesdale #2 | 2400 |  |  | 0.952
Clydesdale #3 | 3200 |  |  | 0.946
Phillips Clydesdale Total
Caballo
MTG | 800 |  |  | 0.945
[NAME] | 1060 |  |  | 0.952 |  |  |  |  | 0 | 0 | 0
Palomino #1 | 1500 |  |  | 0.937
Palomino #2 | 2500 |  |  | 0.945
Phillips Palomino Total
Quantum | 980 |  |  | 0.971
Independent | 18000 |  |  | 0.939
Caballo Total
TOTAL ENA |  |  |  |  |  |  |  | Fixed Volume at Glennrock | 49053
Phillips Total Production
[NAME]
Wellstar
Independent Actual Flow | 14275
Spreadsheet: 875246d1721830861-formula-that-compares-relative-position-of-numbers-from-tables-stock-comparison-33
Sheet: Sheet1

table 1 | 1e0t2l14l3 | 1er1t20t4l2 | t2r1t3l1 | t3r1 | ?? | t3r3 |  | ? | t10l1 |  |  | t120 |  | t12r2
 | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 1 | 4 | 3 | 4 | 4
2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 1 | 4 | 3 | 5 | 4
3 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 2 | 2 | 5 | 5 | 8 | 6
4 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 1 | 4 | 3 | 5 | 8 | 7 | 13 | 9
5 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | 1 | 5 | 6 | 7 | 11 | 11 | 18 | 14
6 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | 3 | 6 | 7 | 11 | 14 | 14 | 22 | 20
7 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | 3 | 6 | 7 | 11 | 14 | 14 | 22 | 20
table 2
 | 1e0bt4l3 |  | [NAME] | 1er3 | t6?l1 | t2r4 |  |  | t5r4 |  |  | t10r2
 | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 4 | 5
2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 4 | 5
3 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 3 | 4 | 4 | 5 | 7 | 8
4 | 0 | 1 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 3 | 4 | 5 | 7 | 10 | 11
5 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 8 | 6 | 12 | 14 | 14
6 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 9 | 9 | 16 | 18 | 17
7 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 9 | 9 | 16 | 19 | 18
comparison |  | no??(2/3b) |  |  |  |  | 123..12..1245t |  |  |  |  |  | a ..b t2=3,t6=3,
table
a ..b t2=3,t6=3, | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 4 | 5 | 4 | 6 | 9 | 9
2 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 4 | 5 | 4 | 6 | 9 | 9
3 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 1 | 2 | 5 | 6 | 5 | 7 | 11 | 11
4 | 0 | 0 | 1 | 0 | 3 | 2 | 2 | 1 | 4 | 6 | 9 | 8 | 13 | 16 | 18
5 | 0 | 0 | 1 | 0 | 3 | 2 | 2 | 2 | 5 | 8 | 11 | 9 | 16 | 17 | 22
6 | 0 | 0 | 1 | 0 | 3 | 2 | 3 | 2 | 5 | 9 | 11 | 9 | 17 | 19 | 24
7 | 0 | 0 | 1 | 0 | 3 | 2 | 3 | 2 | 5 | 9 | 11 | 9 | 17 | 19 | 24
Spreadsheet: 872012d1718372228-extract-specific-text-from-a-string-against-a-list-sample-data-40-aligw
Sheet: Sheet1

Feedback | Keywords |  |  | Positive |  | 2019+ | 365
People are more than friendly  they are experts and very polite. | friendly, very polite |  |  | Excellent
Experienced staff and always helpful if you have any problems | experienced, helpful |  |  | Experienced |  |  | Experienced, Helpful
Everything was excellent all round. Go above | everything, excellent, go above |  |  | Friendly |  |  | Excellent, Go above, everything
 |  |  |  | Go above
 |  |  |  | Good
 |  |  |  | Helpful
 |  |  |  | Very Polite
 |  |  |  | everything
Spreadsheet: 681432d1591568461-conditional-format-if-value-entered-without-dates-conditional-format-hours-with-no-date
Sheet: External Master

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End |  |  |  |  |  |  |  |  |  |  |  | Hours Jan 20 | Hours Feb 20 | Hours Mar 20 | Hours Apr 20 | Hours May 20 | Hours Jun 20 | Hours Jul 20 | Hours Aug 20 | Hours Sep 20 | Hours Oct 20 | Hours Nov 20 | Hours Dec 20 | Hours FY 20 | Hours Jan 21 | Hours Feb 21 | Hours Mar 21 | Hours Apr 21 | Hours May 21 | [NAME] 21 | Hours Jul 21 | Hours Aug 21 | Hours Sep 21 | Hours Oct 21 | Hours Nov 21 | Hours Dec 21 | Hours FY 21 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 40 | 80 | 90 | 3 | 5 | 6 | 7 | 8 | 9 | 3 | 2 | 900 |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 |  |  | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cells currently highlighted in yellow would be highlighted in red with working conditional format
Spreadsheet: 123181d1317391386-comparing-2-excel-files-and-culling-the-different-data-sample3
Sheet: Sheet1

name | address | city | state | zip
bob | 111 street | dallas | tx | 75052
lilly | 222 street | arlington | tx | 76013
[NAME] | 333 way | fort worth | tx | 75112
[NAME] | 444 blvd | dallas | tx | 76102
jane | 555 street | dallas | tx | 76525
bad name | 666 court | arlington | tx | 76017
Spreadsheet: 597655d1541986458-excel-formula-to-calculate-wages-for-certain-months-with-some-tricky-variables-wage-calculator-sample
Sheet: Wages

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]. Pay increase | 0.03 |  |  |  |  |  |  |  | 2018-07-01 00:00:00 | 2018-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effective Date | 2018-12-01 00:00:00 |  |  |  |  |  |  |  | 2018-11-30 00:00:00 | 2019-06-30 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2018-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | #days | #days | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2
CORPORATEWAGES |  |  |  |  |  |  |  |  |  |  | 2019-06-30 00:00:00 |  |  |  |  |  |  | 0.175 | 0.095 | 0.032 | 0.049 |  |  |  |  |  | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30
Division | Business Unit | Position | Name | Location | Status | hrs/wk | % wage to be outsourced /client coded | Level | Start Date | Finish Date | No. of days employed this FY | **Annual [NAME] (excl. on-costs) | **HOURLY RATE | HRS PA | BASE | [NAME] position | Wage Increase for period from Effective Date | LEAVE LOADING | SUPER | WORKCOVER | PAYROLL TAX | Wage Subsidy | Outsourced Wages excl. on-costs | TOTAL Yearly Cost | Jul-Nov TOTAL incl. Outsourced Wages BUT excl. on-costs & wage subsidy | Dec-Jun TOTAL incl. Outsourced Wages BUT excl. on-costs & wage subsidy | 2018-07-31 00:00:00 | 2018-08-31 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | TOTAL (EXCL. on-costs & subsidies) | check
Corporate | Administrative | Administration Officer | [NAME] | Bundaberg | Full-Time | 38 |  | Trainee | 2018-10-01 00:00:00 |  |  | 0 | 16.18 |  |  |  |  |  |  |  |  | -4500
Corporate | Executive [NAME] | CEO | [NAME] | Bundaberg | [NAME] | 38 |  | 8.1 |  |  |  | 150000 |  |  |  |  | 0
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0201

02/01/2011  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 24 | 44 | 22 |  |  |  |  | 356 |  |  | 10.25 | 34.73170731707317
 | Dustin | 13 | 30 | 12 |  |  |  |  | 212 | 3 | Trending | 7.25 | 29.24137931034483
 | Sharron | 6 | 10 | 4 |  | 14 | 16 |  | 230 |  |  | 10.5 | 21.90476190476191
 | Roxy | 1 | 16 | 17 |  |  |  |  | 186 |  |  | 8.5 | 21.88235294117647
 | [NAME] | 3 |  | 3 |  |  | 11 | 2 | 134 |  |  | 9.25 | 14.48648648648649
 | Ana |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Maria | 17 | 42 | 1 |  |  |  |  | 168 |  |  | 12.25 | 13.71428571428571
 | [NAME] | 20 | 27 | 17 |  |  |  |  | 257 |  |  | 10.25 | 25.07317073170732
 | Petra |  |  | 2 |  |  | 2 | 6 | 80 | 5.5 | [NAME] | 6 | 13.33333333333333
 | Regina |  |  |  |  | 2 | 19 |  | 156 | 1 | SWT | 8.75 | 17.82857142857143
 | Noy | 4 | 2 |  |  | 4 | 13 | 1 | 134 | 2.25 | SWT | 8.25 | 16.24242424242424
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Michelle | 37 |  |  |  |  |  |  | 74 |  |  | 1.75 | 42.28571428571428
 | Keisha |  | 17 | 6 |  |  |  |  | 99 |  |  | 9 | 11
 | [NAME] |  | 58 | 10 |  |  |  |  | 254 |  |  | 12.5 | 20.32
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 264.7241876958792
 | TASK VOLUME: | 125 | 246 | 94 | 0 | 20 | 61 | 9 | 2340 | 11.75 |  | 114.53 | 20.43132803632236
 | Pts Earned: | 250 | 738 | 752 | 0 | 40 | 488 | 72
 |  |  |  |  |  |  |  | Average PTS | 146.251875 |  | Total Task Volume |  | 555
 | MID-DAY PPH  17.06
 | 21.15
Spreadsheet: 9265e7e2-b044-40cf-b6df-21542c5f47f3
Sheet: Sheet1

 |  |  |  |  | [NAME]
 |  |  |  |  | 2011-2012
 | Day |  | Date |  |  | Time |  | Opponent | Location
 | TR |  | 2011-11-03 00:00:00 |  |  |  |  | Lincoln Co | Home
 |  |  |  |  |  |  |  | Scrimmage
 | Sat |  | 2011-11-12 00:00:00 |  |  |  |  |  | Paris HS
 |  |  |  |  |  |  |  | Scrimmage
 | [NAME] |  | 2011-11-29 00:00:00 |  |  | 6/7:30 |  | [NAME] | Away
 | Sat |  | 2011-12-03 00:00:00 |  |  | 6/7:30 |  | TC | Away
 | [NAME] |  | 2011-12-06 00:00:00 |  |  | 6/7:30 |  | Frankilin Co. | Away
 | Sat |  | 2011-12-10 00:00:00 |  |  |  |  | [NAME] | BS
 | [NAME] |  | 2011-12-13 00:00:00 |  |  | 6/7:30 |  | LCA | Away
 | Fri |  | 2011-12-16 00:00:00 |  |  | 5:15/6:30 |  | HC | Home
 | Mon-TR |  | Dec 19th-22nd |  |  | TBA |  | I-HIGH  Tournament | TBA
 | Wed-Fri |  | Dec 28th-30th |  |  | TBA |  | Bourbon Co. Tourn. | Bourbon
 | [NAME] |  | 2011-01-03 00:00:00 |  |  | 6:30/8 |  | Dunbar | Away
 | TR |  | 2011-01-05 00:00:00 |  |  | 6:30/8 |  | BS | Away
 | Sat |  | 2011-01-07 00:00:00 |  |  |  |  | MLK | Dunbar
 | [NAME] |  | 2011-01-10 00:00:00 |  |  | 6/7:30 |  | LC | Away
 | Sat |  | 2011-01-21 00:00:00 |  |  |  |  | Coaches vs Cancer | [NAME]
 | [NAME] |  | 2011-01-24 00:00:00 |  |  | 5:15/6:30 |  | Dunbar | Home
 |  |  |  |  |  |  |  | B/G Double Header
 | Fri |  | 2011-01-27 00:00:00 |  |  | 6:30/8 |  | BS | Home
 | Sat |  | 2011-01-28 00:00:00 |  |  | 03:15:00 |  | Garrad Co. | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 | Mon |  | 2011-01-30 00:00:00 |  |  | 6/7:30 |  | Woodford Co. | Away
 | TR |  | 2011-02-02 00:00:00 |  |  | 6/7:30 |  | LC | Home
 | Sat |  | 2011-02-04 00:00:00 |  |  | 1/2:30 |  | TC | Home
 | Mon |  | 2011-02-06 00:00:00 |  |  | 6/7:30 |  | Madison Central | Home
 | Fri |  | 2011-02-10 00:00:00 |  |  | 6/7:30 |  | LCA | Home
 | Wed |  | 2011-02-15 00:00:00 |  |  | 6:30/8 |  | HC | Away
 | Fri |  | 2011-02-17 00:00:00 |  |  | 6/7:30 |  | Western Hills | Home
Spreadsheet: darrell_schoolcraft__7862__Sid Rich Fuel
Sheet: Sid Rich Fuel

Transwestern  Interconnect  Information
Revision Number |  | POI Date:
 |  | Current Date:
Legal Entity Number |  | Interconnect Name: |  | [NAME]
Physical Operator: | [NAME] | County: |  | Ward
Business Operator: |  | State: |  | Texas
[NAME]: | [NAME] | Individual Contact |  | [NAME]
Location: | Sec. 31, Blk 16, [NAME]. Land | Contact Phone |  | [PHONE]
FNL/FEL |  | ACTION REQUESTED
I/D Date: | 2001-09-04 00:00:00 | FAS |  | 311 Facilities
Area: |  | Valid for Transport | Y | Physical Indicator
Dedicated Ownership: |  | Receipt or Delivery | D | LDC to lay line
Dedicated Interest: |  | Survey |  | LDC to install meter
[NAME] Vol(Mmcf/d): | 2 mmcfd | TW - Tap w/Valve | Y | EFM | Y
Est. Pressure (S.I.P.) | 950-1000 | TW - Meter | N | Use existing tap & meter
Zone |  | Instruments | Y | Survey
Remarks:
 | On the Oasis Lat 24"
 | next to Delhi Ward poi 9276
 | 2470 w/EFM Radio
By:
FACILITIES |  | Meas. Section/Segment
Est. Tie-in Date: | 2001-09-04 00:00:00 | Tie Into: |  | TWBW1P2J
Size of Gathering Line: | 2" | Capacity |  | 2 MMCFD
Length of Gathering Line: | .25 mi. | POI Type |  | Fuel Del.
Operating Pressure: | 950-1000 | Elevation |  | 2450
[NAME]: | WT-2 | Lat. Name & Number |  | Oasis 24" lateral
Field Contact: |  | [NAME] Number |  | Align.  IG-1 (Closed)
Remarks:
 | Sta  110 + 41.8
By:
 | TW Costs |  |  | Reimbursable
Total Estimated Costs:
Remarks:
CONNECT REQUEST
Station Name |  | Basis of Measurements
Station Number | 84296 | Pressure Base |  | 14.73
POI Number |  | Temperature Base |  | 60 deg. F
Work Order No. |  | Barometric Pressure |  | 13.42
Remarks:
Contract Terms:
Contract No.
Spreadsheet: 63368d1264280965-convert-text-entries-to-valid-date-format-kt-01
Sheet: 2009

 | Received | [NAME] | Functional Group | Owner | State | Open Date
 | 1/21/2008 0:00 | YES | Electrical | rhawkins | Complete | 1/21/2008 0:00
 | 1/23/2008 0:00 | YES | Mechanical | gbull | Complete | 1/23/2008 0:00
 | 1/23/2008 0:00 | YES | Misc | rhawkins | Complete | 1/23/2008 0:00
 | 2009-12-01 00:00:00 | YES | Mechanical | adensey | Complete | Dec-09
 | 1/23/2008 0:00 | YES | DUMMY | DATA | SHOWN | 1/23/2008 0:00
 | 1/24/2008 0:00 | YES | Mechanical | gbull | Complete | 1/24/2008 0:00
 | 1/29/2008 0:00 | YES | Mechanical | mrichards | Complete | 1/29/2008 0:00
 | 1/31/2008 0:00 | YES | Electrical | rhawkins | Complete | 1/31/2008 0:00
 | 1/31/2008 0:00 | YES | Mechanical | gbull | Complete | 1/31/2008 0:00
 | 1/16/2009 10:41 | YES | Mechanical | nbruce | Complete | 1/16/2009 10:41
 | 2008-04-02 00:00:00 | YES | Misc | rhawkins | Complete | Apr-08
 | 2008-06-02 00:00:00 | YES | Production | rhawkins | Complete | Jun-08
 | 2008-07-02 00:00:00 | YES | Mechanical | rhawkins | Complete | Jul-08
 | 2008-07-02 00:00:00 | YES | Electrical | rhawkins | Complete | Jul-08
 | 2008-08-02 00:00:00 | YES | Support | pwiney | Complete | Aug-08
 | 2008-08-02 00:00:00 | YES | Support | pwiney | Complete | Aug-08
 | 1/21/2009 13:28 | YES | Mechanical | adensey | Complete | 1/21/2009 13:28
 | 2008-08-02 00:00:00 | YES | Engines | mrichards | Complete | Aug-08
 | 2007-12-11 00:00:00 | YES | Mechanical | gbull | Complete | Dec-07
 | 1/22/2009 14:10 | YES | Electrical | [NAME] | Complete | 1/22/2009 14:10
 | 2/18/2008 0:00 | YES | Mechanical | gbull | Complete | 2/18/2008 0:00
 | I have copied B2:B22 down to B28 and applied GENERAL formatting to B28:B48 to see what the source data
 | actually was. It is pretty obvious that some of the source data seems to be plain text and other data came in
 | as actual date data (those in red boxes).
 | Unfortunately the source data is beyond our control so it needs fixing in the spreadsheet.
 | 1/21/2008 0:00 |  | The results achieved in G2:G22 are based on what is contained in B2:B22
 | 1/23/2008 0:00 |  | The correct outcome are shown in the blue boxes.
 | 1/23/2008 0:00
 | 40148
 | 1/23/2008 0:00
 | 1/24/2008 0:00
 | 1/29/2008 0:00
 | 1/31/2008 0:00
 | 1/31/2008 0:00
 | 1/16/2009 10:41
 | 39540
 | 39601
 | 39631
 | 39631
 | 39662
 | 39662
 | 1/21/2009 13:28
 | 39662
 | 39427
 | 1/22/2009 14:10
 | 2/18/2008 0:00
Spreadsheet: 36069d1233831809-vlookup-for-same-name-in-same-column-joe-punt
Sheet: Sheet1

Date | Names | Weekly Price | Names | Total Price
2009-01-02 00:00:00 | Joel | 25 | Joel | 106
2009-01-02 00:00:00 | Cassy | 32.12 | Cassy | 167.12
2009-01-02 00:00:00 | [NAME] | 45 | [NAME] | 109.36
2009-01-02 00:00:00 | [NAME] | 11 | [NAME] | 58
2009-01-02 00:00:00 | [NAME] | 41 | [NAME] | 117
7/001/09 | Joel | 21 | Total
7/001/09 | Cassy | 23
7/001/09 | [NAME] | 11
7/001/09 | [NAME] | 5
7/001/09 | [NAME] | 42
2009-01-14 00:00:00 | Joel | 36
2009-01-14 00:00:00 | Cassy | 60
2009-01-14 00:00:00 | [NAME] | 12.36
2009-01-14 00:00:00 | [NAME] | 11
2009-01-14 00:00:00 | [NAME] | 12
2009-01-21 00:00:00 | Joel | 24
2009-01-21 00:00:00 | Cassy | 52
2009-01-21 00:00:00 | [NAME] | 41
2009-01-21 00:00:00 | [NAME] | 31
2009-01-21 00:00:00 | [NAME] | 22
Spreadsheet: 887585d1737825155-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Jul

 |  |  | 2025-06-30 00:00:00 | 2025-07-01 00:00:00 | 2025-07-02 00:00:00 | 2025-07-03 00:00:00 | 2025-07-04 00:00:00 | 2025-07-05 00:00:00
 |  |  | 2025-07-07 00:00:00 | 2025-07-08 00:00:00 | 2025-07-09 00:00:00 | 2025-07-10 00:00:00 | 2025-07-11 00:00:00 | 2025-07-12 00:00:00
 |  |  | 2025-07-14 00:00:00 | 2025-07-15 00:00:00 | 2025-07-16 00:00:00 | 2025-07-17 00:00:00 | 2025-07-18 00:00:00 | 2025-07-19 00:00:00
 |  |  | 2025-07-21 00:00:00 | 2025-07-22 00:00:00 | 2025-07-23 00:00:00 | 2025-07-24 00:00:00 | 2025-07-25 00:00:00 | 2025-07-26 00:00:00
 |  |  | 2025-07-28 00:00:00 | 2025-07-29 00:00:00 | 2025-07-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-01 00:00:00 | 2025-08-02 00:00:00
 |  |  | 2025-08-04 00:00:00 | Notes
Spreadsheet: 678753d1590050260-sum-range-across-worksheet-with-transposition-test-sum-range-across-worksheet
Sheet: Sheet4

 | 440 | 425 | 424 | 20 | 109 | 273 | 286 | 403 | 79 | 541 | 521
 | 828 | 728 | 947 | 79 | 834 | 272 | 91 | 998 | 35 | 339 | 39
 | 705 | 239 | 514 | 854 | 752 | 598 | 160 | 811 | 47 | 925 | 75
 | 759 | 855 | 87 | 312 | 485 | 685 | 247 | 444 | 446 | 587 | 618
 | 67 | 521 | 29 | 499 | 165 | 254 | 721 | 770 | 166 | 949 | 440
 | 7 | 181 | 644 | 394 | 916 | 14 | 313 | 315 | 935 | 908 | 298
 | 163 | 409 | 608 | 72 | 473 | 608 | 343 | 913 | 564 | 173 | 445
 | 117 | 844 | 61 | 839 | 735 | 686 | 593 | 698 | 318 | 514 | 770
 | 208 | 63 | 24 | 914 | 309 | 183 | 293 | 391 | 816 | 236 | 124
 | 170 | 192 | 787 | 300 | 612 | 403 | 362 | 252 | 504 | 182 | 586
 | 68 | 984 | 353 | 571 | 622 | 195 | 468 | 257 | 191 | 338 | 216
 | 204 | 159 | 342 | 117 | 999 | 715 | 902 | 212 | 695 | 247 | 674
 | 973 | 506 | 686 | 434 | 496 | 798 | 671 | 169 | 362 | 948 | 849