tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859419d1707821109-if-function-not-working-book-2
Sheet: Sheet1

 |  |  |  |  |  |  |  | A | B | A-B
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1 | 2
 |  |  |  |  |  |  |  | 1 | 2
 |  |  |  |  |  |  |  | 4 | 2
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 1
Spreadsheet: 0d9bbace-49f8-4af4-8c60-ef4ac63e09b1
Sheet: Sheet1

Table 3--Cash feed grain prices, 2/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/ | Corn, No. 2 yellow,  Central IL (dollars per bushel) |  |  | Corn, No. 2 yellow,  Gulf ports, LA  (dollars per bushel) |  |  | Sorghum, No. 2 yellow,  Plainview to [NAME], TX  (dollars per cwt) |  | Sorghum, No. 2 yellow,  Gulf ports, LA  (dollars per cwt)
 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2012/13
Sep | 4.51 | 6.77 | 7.7 | 5.225 | 7.5 | 8.145 | 7.7383 | 11.4793 | 9.79 | 12.88 | 12.965
Oct | 5.19 | 6.23 | 7.48 | 5.985 | 6.975 | 8.155000000000001 | 8.5355 | 10.73 | 10.395 | 12.08 | 13.2
Nov | 5.33 | 6.26 | 7.39 | 6.05 | 6.97 | 8.175 | 8.7792 | 10.96 | 10.745 | 12.44 | 13.095
Dec | 5.65 | 5.96 | 7.23 | 6.36 | 6.57 | 7.845 | 9.6203 | 10.5 | 11.1 | 11.82 | 13.14
Jan | 6.1 | 6.25 | 7.14 | 6.73 | 6.935 | 7.69 | 10.455 |  | 11.905 | 12.2 | 13.1
Feb | 6.69 | 6.41 |  | 7.435 | 7.1 |  | 11.42 |  | 12.625 | 12.09
Mar | 6.59 | 6.46 |  | 7.375 | 7.13 |  | 11.45 |  | 12.64 | 12.035
Apr | 7.33 | 6.34 |  | 8.11 | 6.96 |  | 12.775 |  | 13.675 | 11.94
May | 7.08 | 6.27 |  | 7.82 | 6.84 |  | 12.22
Jun | 7.17 | 6.3 |  | 7.89 | 6.785 |  | 12.21
Jul | 6.96 | 7.85 |  | 7.64 | 8.455 |  | 10.69 |  | 12.65
Aug | 7.3 | 8.15 |  | 7.88 | 8.435 |  | 11.47 |  | 13.71 | 13.47
Mkt year | 6.324999999999999 | 6.604166666666665 |  | 7.041666666666667 | 7.22125 |  | 10.61360833333333 | 10.917325 | 11.9235 | 12.32833333333333
 | Barley, No. 2 feed,  Minneapolis, MN  (dollars per bushel) |  |  | Barley, No. 3 malting,  Minneapolis, MN  (dollars per bushel) |  |  | Oats, No. 2 white heavy,  Minneapolis, MN  (dollars per bushel)
 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13
Jun | 2.2275 | 5.06 | 5.15 | 3.2 | 7.395 | 7.03 | 2.3875 | 3.675 | 3.37
Jul | 2.06 | 5.18 | 5.52 |  | 7.72 | 6.89 | 2.58 | 3.68 | 3.95
Aug | 2.5425 | 5.25 | 5.78 |  | 7.83 | 6.95 | 2.6875 | 3.69 | 3.985
Sep | 2.9925 | 5.14 | 5.58 |  | 7.76 | 6.99 | 3.135 | 3.72 | 3.885
Oct | 3.32 | 5.16 | 5.51 |  | 7.64 | 7.11 | 3.5625 | 3.51 | 3.98
Nov | 3.57 | 5.29 | 5.49 | 4.7 | 7.6 | 7.23 | 3.5375 | 3.36 | 3.85
Dec | 3.888 | 5.17 | 5.29 | 5.1595 | 7.32 | 7.22 | 3.88 | 3.3 | 3.94
Jan | 4.15 | 6.24 | 5.07 | 5.58 | 7.2 | 7.1 | 3.93 | 3.16 | 3.78
Feb | 4.62 | 6.26 |  | 5.91 | 7.07 |  | 4.075 | 3.46
Mar | 4.74 | 5.37 |  | 5.92 | 7.05 |  | 3.55 | 3.475
Apr | 5.05 | 5.18 |  | 6.2 | 7.03 |  | 3.83 | 3.55
May | 4.83 | 5.21 |  | 6.43 | 7 |  | 3.55 | 3.5
Mkt year | 3.665874999999999 | 5.375833333333333 |  | 5.3874375 | 7.384583333333333 |  | 3.392083333333332 | 3.506666666666666
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Simple average of monthly prices for the marketing year. Source: USDA, Agricultural Marketing Service, http://marketnews.usda.gov/portal/lg.
Data run: 2/11/2013
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: Apr 21 & 22, 2001 

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-04-21 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with the process
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 802696d1666973612-employee-costing-model-labour-model-query
Sheet: Lookups

January | 2023-01-01 00:00:00
February | 2023-02-01 00:00:00
March | 2023-03-01 00:00:00
April | 2023-04-01 00:00:00
May | 2023-05-01 00:00:00
June | 2023-06-01 00:00:00
July | 2023-07-01 00:00:00
August | 2023-08-01 00:00:00
September | 2023-09-01 00:00:00
October | 2023-10-01 00:00:00
November | 2023-11-01 00:00:00
December | 2023-12-01 00:00:00
Spreadsheet: aa0beb89-b284-4b83-af96-cefd757619db
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2750 | 15499 | Monika | Kadlecova | SVK | 92 | 00:18:20 | 00:00:00 | 00:26:11 | 00:00:00 | 00:22:07 | 1 | 01:06:38
2750 | 11121 | Angelika | Perfler | AUT | 91 | 00:17:42 | 00:00:00 | 00:26:59 | 00:00:00 | 00:23:54 | 2 | [NAME]
2750 | 15478 | Beatrice | Wondratschek | GER | 93 | 00:18:17 | 00:00:00 | 00:28:32 | 00:00:00 | 00:24:52 | 3 | 01:11:43
Spreadsheet: mary_fischer__25432__totals
Sheet: Sheet1

GEWE
To: [NAME]
From: [NAME]
Date: 6/18/02
Subject: [NAME] from [NAME]
[NAME]: After our conversation a while back about substation meter readings, I asked the site
personnel at [NAME] to log readings from the substation for a couple of weeks and send them
to me. I did not do it at Trent Mesa since the meters are at a large interchange that feeds the
site that we do not have access to. I hope this is what you were looking for, if not please call
and I can get you what you need. The readings are in MWh.
 | 138kV |  | 69kV
 | Production | Consumption | Production | Consumption
2002-05-19 00:00:00 | 19602 | 15 | 61543 | 169
2002-05-20 00:00:00 | 21012 | 15 | 62788 | 169
2002-05-21 00:00:00 | 22232 | 15 | 63787 | 169
2002-05-22 00:00:00 | 23253 | 15 | 64802 | 169
2002-05-23 00:00:00 | 24184 | 15 | 65673 | 169
2002-05-24 00:00:00 | 25034 | 15 | 66509 | 169
2002-05-25 00:00:00 | 25933 | 15 | 67337 | 169
2002-05-26 00:00:00 | 26436 | 16 | 67773 | 170
2002-05-28 00:00:00 | 27568 | 16 | 68815 | 170
2002-05-29 00:00:00 | 28978 | 16 | 70289 | 170
2002-05-30 00:00:00 | 29285 | 19 | 70588 | 172
2002-05-31 00:00:00 | 29692 | 19 | 70891 | 173
2002-06-03 00:00:00 | 31940 | 19 | 73050 | 173
2002-06-04 00:00:00 | 32516 | 19 | 73602 | 173
2002-06-05 00:00:00 | 33219 | 20 | 74276 | 174
2002-06-06 00:00:00 | 33268 | 21 | 74315 | 175
2002-06-07 00:00:00 | 33371 | 23 | 74417 | 177
2002-06-10 00:00:00 | 35946 | 24 | 76752 | 177
Russ
Spreadsheet: 89800d1289529326-multiple-lookups-enquiry-enrolment
Sheet: enrolments

Student ID | Class
1001 | Art
1001 | History
1001 | Painting
1002 | History
1003 | English
1003 | Art
1003 | Communications
1004 | History
1004 | Painting
1004 | English
1005 | Pottery
1006 | Science
1006 | English
1006 | Art
1007 | Art
1008 | Science
Spreadsheet: 793096d1661307084-formulas-to-create-table-via-match-help-08
Sheet: Sheet1

 | COACHING STAGE |  |  |  |  | Site Wide | Gantry | Roof | SGA1 | Infra | Core
 | Team | Assigned Coach | Date assigned |  |  | [NAME]
 | SGA1 | [NAME] |  |  |  |  |  | PETER
 | Site Wide | benny |  |  |  |  |  |  | [NAME]
 | Gantry |  |  |  |  |  |  | ALEX
 | Roof |  |  |  |  | benny
 |  |  |  |  |  |  | Yo
 | After select Column B dropdown |  |  |  |  |  |  |  |  | Hello
 | Column C dropdown will base on column b selection to select coach |  |  |  |  |  | HELI
 | When gantry, roof, SGA1, Infra or Core is selected (column-b), |  |  |  |  |  |  |  |  |  | Bye
 | the assigned coach (column-c) drop-down will include coaches from Site-Wide team |  |  |  |  |  |  |  |  |  | Thailand
 |  |  |  |  |  |  |  |  |  | Cute
Spreadsheet: 859842d1708081267-convert-irregular-data-to-monthly-power_consumption
Sheet: Data

Date | Amount | Units (KWh) | Price (Ex Tax) | Price/KWh |  | Days |  | Allocation(Days) |  |  |  |  | Allocation(Units) |  |  |  |  |  | Allocation(Amounts)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | M |  | M
2022-07-21 00:00:00 | 500 | 22.87 | 288.17
2022-08-12 00:00:00 | 2000 | 91.47 | 1152.54
2022-08-22 00:00:00 | 2500 | 114.33 | 1440.65
2022-09-28 00:00:00 | 4000 | 158.71 | 1999.76
2022-10-01 00:00:00 | 0 | 0 | 0 | 0
2022-11-04 00:00:00 | 2499 | 97.37 | 1226.88
2022-11-18 00:00:00 | 2500 | 101.04 | 1273.08
2022-12-03 00:00:00 | 3000 | 121.4 | 1527.69
2022-12-29 00:00:00 | 2000 | 76.08 | 958.63
2023-01-20 00:00:00 | 1000 | 37.89 | 477.44
2023-01-29 00:00:00 | 3000 | 113.67 | 1432.28
2023-02-19 00:00:00 | 1500 | 58.53 | 737.47
2023-03-08 00:00:00 | 2500 | 97.55 | 1229.1
2023-03-27 00:00:00 | 2000 | 71.62 | 902.5
2023-04-12 00:00:00 | 2500 | 78.74 | 1651.25
2023-04-30 00:00:00 | 4000 | 125.99 | 2642.01
2023-05-27 00:00:00 | 5000 | 155.37 | 3258.13
2023-06-28 00:00:00 | 4000 | 119.28 | 2501.3
2023-07-17 00:00:00 | 1500 | 47.41 | 975.82
2023-07-23 00:00:00 | 5000 | 158.05 | 3252.63
2023-07-25 00:00:00 | 250 | 7.9 | 162.66
2023-07-27 00:00:00 | 500 | 15.8 | 325.29
2023-08-17 00:00:00 | 3000 | 93.44 | 1922.93
2023-09-07 00:00:00 | 4000 | 124.58 | 2563.9
2023-10-05 00:00:00 | 4000 | 127.26 | 2619.1
2023-11-07 00:00:00 | 4000 | 121.18 | 2493.93
2023-12-01 00:00:00 | 4000 | 122.39 | 2518.88
2023-12-24 00:00:00 | 4500 | 136.31 | 2805.27
2024-01-01 00:00:00 | 0 | 0 | 0 | 0
2024-02-01 00:00:00 | 0 | 0 | 0 | 0
2024-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4
Spreadsheet: 846593d1697742347-2-sets-of-data-into-one-table-example
Sheet: Sheet1

 | Cost | London | [NAME] |  | Show days | Travel days | Equipment recharge
Crew member A | 2800 | 1500 | 1300 |  | 800 | 800 | 1200
Band member A | 4000 | 2200 | 1800 |  | 1200 | 1200 | 1600
 | 6800 | 3700 | 3100 |  | 2000 | 2000 | 2800
Show P&L | Total | London | [NAME]
Income | 18000 | 10000 | 8000
Costs;
Show days | 2000 | 1000 | 1000
Travel days | 2000 | 1000 | 1000
Equipment | 2800 | 1400 | 1400
Spreadsheet: 456205d1460678933-help-adapting-an-index-formula-customer-db-and-invoices
Sheet: Sales_Data

Date | Customer # | Invoice # | Description | Quantity | Price | Total
2014-09-04 00:00:00 | 1 | 1 | Item1 | 1 | 50
 | 1 | 1 | Item2 | 2 | 55
 | 1 | 1 | Item3 | 3 | 60
 | 1 | 1 | Item4 | 2 | 50
2014-09-07 00:00:00 | 2 | 2 | Item1 | 4 | 55
 | 2 | 2 | Item2 | 1 | 25
 | 2 | 2 | Item3 | 1 | 25
 | 2 | 2 | Item4 | 2 | 50
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 05 FRIDAY

DAY: |  | FRIDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D |  |  |  |  |  |  |  |  |  |  | 1000 | 2 | 1008 | 1 | 1003 | 3 | 1007 | 11 | 1004 | 3 | 1001 | 5
10 | D |  |  |  |  |  |  |  |  |  |  | 1002 | 3 | 1001 | 9 | 1004 | 7 | 1005 | 11 | 1002 | 3 | 1007 | 3
47 | D |  |  |  |  |  |  |  |  |  |  | 1006 | 5 | 1005 | 10 | 1007 | 7 | 1000 | 3 | 1008 | 9 | 1004 | 4
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 828445d1683496944-moved-from-libreoffice-to-excel-365-i-dont-know-why-formula-broke-oekonomi-marstal-ophold-help-me-v2
Sheet: Offdays Automatic

Offday Calculator
Start |  |  |  | Salery Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacationdays spend |  | Paid Offdays |  | Result
Start date | 2022-12-21 00:00:00 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Balance | 78.58 |  |  | To
Vacation days |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Total | 42
Spend |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0
Result |  |  |  | To
Rates
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0
Hjemme | -1 |  |  | To
Mønstring | 0.82
[NAME] | 0.82 |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 80
Sygdom | 0 |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 0
 | From | To |  | To
Mønstring | 2023-01-11 00:00:00 | 2023-03-12 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Mønstring | 2023-04-04 00:00:00 | 2023-05-20 00:00:00 |  | To
Mønstring | 2023-06-27 00:00:00 | 2023-08-08 00:00:00
Mønstring | 2023-09-19 00:00:00 | 2023-10-17 00:00:00 |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
Mønstring | 2023-11-16 00:00:00 | 2023-12-18 00:00:00 |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | To
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME] | Keystone - to be cashed out in 7/01
Red Cedar |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME] | 6,000/day planned makeup during 7/01
[NAME] |  |  |  | Volumetric | [NAME] | Milagro, [NAME], Valverde, [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
NGPL |  |  |  | Volumetric | [NAME] | 5,000/DAY scheduled for makeup
Mewborne |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
EOG |  |  |  | Dollar Valued | [NAME]
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Oasis |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 196805d1354113057-syllabus-prereqs-spreadsheet-best-technique-syllabus1
Sheet: Sheet1

AL-101 |  |  |  | Yellow events CAN be accomplished, red events CANNOT be accomplished until the prerequisite events are accomplished.  Here, AL-101 and PB-101 are the only events that can be accomplished.
AL-102 | AL-101
AL-103 | AL-102
PB-101
TR-A | AL-103 | PB-101
TR-B | TR-A
TR-1 | TR-B
AL-101 |  |  |  | Here, AL-101 was accomplished on 28 Nov 12. This date was manually inputted in cell A17. Cell B18 automatically duplicates the date into B19, turns Cells B18 and B19 green, and turns Cells A18 and A19 yellow, denoting that AL-102 can now be accomplished.
2012-11-28 00:00:00
AL-102 | AL-101
 | 2012-11-28 00:00:00
AL-103 | AL-102
PB-101
TR-A | AL-103 | PB-101
TR-B | TR-A
TR-1 | TR-B
Spreadsheet: 739466d1625730249-how-to-display-entire-list-by-choosing-list-title-from-a-drop-down-book2
Sheet: Sheet1

A | B | C
25013 | 54127 | 92484
68502 | 98432 | 40199
62113 | 16996 | 84377
80021 | 90901 | 95054
25358 | 20049 | 47014
15649 | 41701 | 18133
97484 | 29897 | 31353
78513 | 92768 | 17929
24229 | 44792 | 25909
82127 | 11934 | 78833
73081 | 97144 | 52978
84469 | 33093 | 64394
96396 | 49993 | 22691
53466 | 52504 | 88002
Spreadsheet: daren_farmer__6329__Spinnaker11958SU
Sheet: Sheet1

SPINNAKER VOLUME
OCTOBER 2000
 | ACTUAL DAILY VOLUMES |  |  |  |  | PAID TO SPINNAKER
DAY | 9862 | CONVERT | DAILY | TOTAL |  | 9862 | CONVERT | DAILY | TOTAL
 | MCF | MMBTU | PRICE | DOLLARS |  | MCF | MMBTU | PRICE | DOLLARS
1 | 0 |  | 4.895 |  |  | 5795 |  | 4.895
2 | 0 |  | 4.895 |  |  | 5795 |  | 4.895
3 | 0 |  | 5.045 |  |  | 5796 |  | 5.045
4 | 0 |  | 5.05 |  |  | 5795 |  | 5.05
5 | 0 |  | 5.03 |  |  | 5796 |  | 5.03
6 | 0 |  | 5.01 |  |  | 5795 |  | 5.01
7 | 0 |  | 4.815 |  |  | 5796 |  | 4.815
8 | 0 |  | 4.815 |  |  | 5795 |  | 4.815
9 | 0 |  | 4.815 |  |  | 5796 |  | 4.815
10 | 0 |  | 4.845 |  |  | 5795 |  | 4.845
11 | 0 |  | 4.87 |  |  | 5795 |  | 4.87
12 | 0 |  | 4.945 |  |  | 5796 |  | 4.945
13 | 0 |  | 5.33 |  |  | 5795 |  | 5.33
14 | 0 |  | 5.18 |  |  | 5796 |  | 5.18
15 | 0 |  | 5.18 |  |  | 5795 |  | 5.18
16 | 28 |  | 5.18 |  |  | 5796 |  | 5.18
17 | 8654 |  | 5.1 |  |  | 5795 |  | 5.1
18 | 22705 |  | 5.05 |  |  | 5796 |  | 5.05
19 | 20777 |  | 5.135 |  |  | 5795 |  | 5.135
20 | 14719 |  | 4.815 |  |  | 5796 |  | 4.815
21 | 16400 |  | 4.605 |  |  | 5795 |  | 4.605
22 | 19498 |  | 4.605 |  |  | 5795 |  | 4.605
23 | 14095 |  | 4.605 |  |  | 5796 |  | 4.605
24 | 14232 |  | 4.58 |  |  | 5795 |  | 4.58
25 | 14037 |  | 4.625 |  |  | 5796 |  | 4.625
26 | 14158 |  | 4.44 |  |  | 5795 |  | 4.44
27 | 13244 |  | 4.395 |  |  | 5796 |  | 4.395
28 | 15474 |  | 4.24 |  |  | 5795 |  | 4.24
29 | 13681 |  | 4.24 |  |  | 5796 |  | 4.24
30 | 14664 |  | 4.24 |  |  | 5795 |  | 4.24
31 | 13670 |  | 4.275 |  |  | 5796 |  | 4.275
Total/mnth
We owe Spinnaker
Spreadsheet: 160470d1339090003-vlookup-if-formula-together-mock-excel-1
Sheet: Sheet2

 |  |  |  | Type | Date | Num | Memo | Name | Item | Qty | Sales Price | Amount | Balance
 | Inventory
 |  | part a
 |  |  |  | Invoice | 2011-06-30 00:00:00 | 6911 |  |  |  | 576 | 2 | 1152 | 1152
 |  | part a |  |  |  |  |  |  |  | 576 |  | 1152 | 1152
 |  | part a
 |  |  |  | Invoice | 2011-06-30 00:00:00 | 6911 |  |  |  | 240 | 30 | 7200 | 7200
 |  |  |  | Invoice | 2011-06-30 00:00:00 | 6911 |  |  |  | 336 | 30 | 10080 | 17280
 |  | part b |  |  |  |  |  |  |  | 576 |  | 17280 | 17280
 |  | part b
 |  |  |  | Invoice | 2011-07-14 00:00:00 | 7001 |  |  |  | 1 | 50 | 50 | 50
 |  |  |  | Invoice | 2011-09-29 00:00:00 | 7626 |  |  |  | 1 | 50 | 50 | 100
 |  |  |  | Invoice | 2011-10-14 00:00:00 | 7730 |  |  |  | 1 | 50 | 50 | 150
 |  |  |  |  |  |  |  |  |  | 3 |  | 150 | 150
Spreadsheet: 130993d1322680208-sum-two-sheets-with-vlookup-and-match-sample
Sheet: Sheet2

# to lookup |  | NOV | DEC | JAN | FEB | MAR | APR | MAY | [NAME] | JULY | AUG | SEP | OCT
12345
Spreadsheet: 46050d1244827308-index-formula-in-a-helper-table-datahelpertable
Sheet: Schools Dashboard

 | Direction: Click on School's Name, then click on arrow key to select a school on the list
 |  |  |  |  | School 4
 | 2005 to 2009 School Grade Performance
 | Year | School Grade | % Meeting High Standards |  |  |  |  |  | % Making Learning Gains |  |  |  | % of Lowest 25% Making Learning Gains |  |  | Total Points*
 |  |  | Reading | Math |  | Writing | Science |  | Reading |  | Math |  | Reading | Math | Math
 | 2009*
 | 2008*
 | 2007*
 | 2006*
 | 2005*
 | *School Grade Scaling |  | 2007-2009:  F=0-394, D=395-434, C=435-494, B=495-524, A = 525-800
 |  |  | 2005-2006:  F=0-279, D=280-319, C=320-379, B=380-409, A = 410-600
 | *2009 Projected School Grade
 |  | Reading |  |  |  |  | Math |  |  |  |  |  | Science |  |  |  |  | Writing
 |  | 2009    Dirty Score | 2009 Clean Score | 2008 Clean  Score | Difference      + / - |  | 2009    Dirty Score | 2009 Clean Score | 2008 Score | Difference      + / - |  |  | 2009   Dirty Score | 2009 Clean Score | 2008 Score | Difference      + / - |  | 2009   Dirty Score | 2009 Clean Score | 2008 Score | Difference      + / -