tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36dbd1e5-ff7a-40d5-9162-1b08faf42173
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
 | 5671.0 Lending Finance, Australia
 | TABLE 43. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (VIC), Original (Number, $000)
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
1. . . [NAME] ; |  |  | Original | A2413792J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413793K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413794L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413795R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413796T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413797V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413798W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413799X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413800W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413801X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413802A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: phillip_m_love__30668__200003_OA
Sheet: ARUBA-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 15578321 | 41740995
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 25594555 | 71534733
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 2916287
 | Total Sales: |  | 41172876 | 116192015
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -9905967 | -25817305 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -31542981 | -86688382
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 277862 | 758375
 | Total Purchases: |  | -41171086 | -111747312
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -1790 | -4667.425
 |  |  | 0 | 0
23 | Fuel: |  | -277862 | -758375
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -134078
25 |  | Demand | 0 | -2916287
 | Total Transport Expense: |  | 0 | -3050365
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -1948054
31 |  | Prior Month Book Balance | 0 | -10742902
 |  | Total MTM Income | 0 | -12690956
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 11758324
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 13249
 |  | TOTAL INTRA-MTH
Spreadsheet: 771738d1646827040-what-function-to-use-to-show-a-value-based-on-drop-down-list-test
Sheet: Sheet1

USD Rate: | 22.02
Hour Rate: | 22
ManDay Rate
CAPEX category | Item | Unit type | no. of units | Price per unint | Cost
 |  | Hrs | 0
 |  | MD | 0
 |  | Pcs | 0
Spreadsheet: 0b02bf2a-82d0-4873-ba98-e479cbb977d3
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
 | 8501.0 Retail Trade, Australia
 | TABLE 14. Retail Turnover; Completely Enumerated (large) and Sample (small), By Industry Group
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total Sample Sector ;  Total (State) ;  Food retailing ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Food retailing ; |  |  | Original | A3350086L | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350186W | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350102A | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350182L | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350190L | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Department stores ; |  |  | Original | A3350104F | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Other retailing ; |  |  | Original | A3350187X | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Other retailing ; |  |  | Original | A3350128X | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350074C | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350097V | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350099X | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350113J | 1994-04-01 00:00:00 | 2013-10-01 00:00:00 | 235 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -1960 | -1613 | -1385 | -2000
2 | -2106 | -1613 | -811 | -2000
3 | -2069 | -1613 | -2341 | -2000
4 | -2166 | -1613 | -2354 | -2000
5 | -2259 | -1613 | -2518 | -2000
6 | -2152 | -1613 | -2440 | -2000
7 | -2005 | -1613 | -2470 | -2000
8 | -933 | -1613 | -2314 | -2000
9 | -1857 | -1613 | -787 | -2000
10 | -2242 | -1613 | -2568 | -2000
11 | -2215 | -1613 | -2555 | -2000
12 | -2377 | -1613 | -2610 | -2000
13 | -2305 | -1613 | -2633 | -2000
14 | -2219 | -1613 | -2604 | -2000
15 | -2197 | -1613 | -2274 | -2000
16 | -2239 | -1613 | -701 | -2000
17 | -1978 | -1613 | -2517 | -2000
18 | -1841 | -1613 | -2613 | -2000
19 | -1545 | -1613 | -2628 | -2000
20 | -2325 | -1613 | -2493 | -2000
21 | -2098 | -1613 | -2294 | -2000
22 | -2163 | -3613 | -188 | -2000
23 | -2184 | -3613 | -164 | -2000
24 | -2053 | -3613 | -171 | -2000
25 | -848 | -3613 | -605 | -2000
26 | -1978 | -3613 | -2535 | -2000
27 | -2306 | -1613 | -2624 | -2000
28 | -2165 | -1613 | -2362 | -2000
29 | -2277 | -1613 | -588 | -2000
30
31
index
2001-11-30 00:00:00
2001-12-29 00:00:00
CBS Volume
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 8 - Table 2

Beer Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 59913.59633474197 | 0 | 0 | -92.43161662550847 | 59821.16471811647 | -0.001542748595979582 | -0.001542748595979546
Net revenue | 9868.716 | 0 | 0 | 917.4679999999989 | 10786.184 | 0.0929673120596437 | 0.09296731205964372
Net revenue/hl | 164.7158008152725 | 0 | 0 | 15.59135386527606 | 180.3071546805486 | 0.09465609120743457 | 0.09465609120743458
[NAME] | -2851.419000000001 | -55.745 | 0 | -233.2669999999997 | -3140.431 | 0.1013572540549108 | 0.08180733873204872
[NAME]/hl | -47.59218565463669 | -0.9304231995780796 | 0 | -3.974379708245316 | -52.49698856246008 | 0.1030589967734659 | 0.08350908145060384
Gross profit | 7017.297 | -55.745 | 0 | 684.2009999999992 | 7645.752999999999 | 0.08955813043113303 | 0.09750207237915101
Gross margin | 0.7110648436939516 | 0 | 0 | 0 | 0.7088468915419948 | -20 | 30
SG&A excl. deprec.&amort. | -2786.638 | 0 | 0 | -151.4659999999994 | -2938.104 | 0.05435438689919514 | 0.05435438689919517
SG&A deprec.&amort. | -237.054 | -17.304 | 0 | 32.50199999999998 | -221.856 | -0.0641119744868257 | -0.1371080007086992
SG&A total | -3023.692 | -17.304 | 0 | -118.9639999999996 | -3159.96 | 0.04506675944507554 | 0.03934395434455611
Other operating income | 301.651 | 0 | 0 | 63.58799999999991 | 365.2389999999999 | 0.2107998978952494 | 0.2107998978952495
Normalized EBIT | 4295.255999999999 | -73.04899999999999 | 0 | 628.8249999999996 | 4851.031999999998 | 0.1293929861223635 | 0.1463998886213068
Normalized EBIT margin | 0.4352395995588483 | 0 | 0 | 0 | 0.4497449700468673 | 150 | 210
Normalized EBITDA | 4777.057000000001 | 0 | 0 | 606.5339999999987 | 5383.590999999999 | 0.126968131215516 | 0.1269681312155159
Normalized EBITDA margin | 0.4840606417288734 | 0 | 0 | 0 | 0.4991191509434662 | 150 | 150
Spreadsheet: dutch_quigley__9231__AIG
Sheet: NG-EXOTICS

Fixed |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
AIGENETRA | QZ3864.1 | F | NXB2 | 2001-12-01 00:00:00 | -180000 | -179822.4906 | 0.999013836856174 | 2.676 | 5.56 | 0 | 518608.063
AIGENETRA | V93216.1 | F | NX1 | 2001-12-01 00:00:00 | -310000 | -309694.2894 | 0.999013836856174 | 2.676 | 4.715 | 0 | 631466.6561
AIGENETRA | VK0526.1 | F | NXB2 | 2001-12-01 00:00:00 | 150000 | 149852.0755 | 0.999013836856174 | 2.676 | 4.04 | 0 | -204398.231
AIGENETRA | VK3195.3 | F | NXB2 | 2001-12-01 00:00:00 | 680000 | 679329.4091 | 0.999013836856174 | 2.676 | 4.04 | 0 | -926605.314
AIGENETRA | VK3761.1 | F | NXB2 | 2001-12-01 00:00:00 | -270000 | -269733.736 | 0.999013836856174 | 2.676 | 4.01 | 0 | 359824.8038
AIGENETRA | VL9266.1 | F | NX1 | 2001-12-01 00:00:00 | 155000 | 154847.1447 | 0.999013836856174 | 2.676 | 3.855 | 0 | -182564.7836
Spreadsheet: 70808d1271501465-printing-cell-contents-as-a-header-on-all-pages-stmaster_apr10
Sheet: Logos 2

Logo Options 2
Embroidery |  | Test, who ever that is
Logo Position |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Stitch No | Hoop |  |  |  |  | Notes
[NAME] | Wings Logo |  |  |  |  |  |  |  |  | Test
Right Breast |  |  |  | 20000 |  |  |  |  |  | Test
Back |  |  |  |  |  |  |  |  |  | Test
Left Sleeve |  |  |  | 0 |  |  |  |  |  | Test
Right Sleeve |  |  |  | 0 |  |  |  |  |  | Test
[NAME] |  |  |  | 0
 |  |  | Total | 20000
Printing
Logo Position
 |  |  |  | Cost £ | Notes
Front | Test |  |  | 2 | Test
Right Breast | Test |  |  | 0 | Test
Back | Crown thing |  |  | 0 | Test
Lower back | SA2010 |  |  | 0 | Test
Right Sleeve | [PHONE] |  |  | 0 | Test
[NAME] | TE |  |  | 0 | Test
 |  |  | Total | 2
Spreadsheet: 97015d1296231343-excel-2007-turn-back-2-last-flight-dates-forum-help-1-
Sheet: Daily Aircraft Registrations

 | Last
 | Previous
 |  | FLIGHTS OF DAY
 |  | AIRCRAFT #1 | AIRCRAFT #2 | AIRCRAFT #3 | AIRCRAFT #4 | AIRCRAFT #5 | AIRCRAFT #6 | AIRCRAFT #7 | AIRCRAFT #8 | AIRCRAFT #9 | AIRCRAFT #10 | AIRCRAFT #11 | AIRCRAFT #12
Saturday | 2010-01-01 00:00:00 | AIR 21
Sunday | 2010-01-02 00:00:00
Monday | 2010-01-03 00:00:00 | AIR 1 |  |  |  |  |  | AIRR3
Tuesday | 2010-01-04 00:00:00 |  |  |  |  |  |  | AIR4
Wednesday | 2010-01-05 00:00:00
Thursday | 2010-01-06 00:00:00 |  | AAIR 1
Friday | 2010-01-07 00:00:00 |  | AIR2
Saturday | 2010-01-08 00:00:00 |  | AIRR3
Sunday | 2010-01-09 00:00:00 |  | AIR4
Monday | 2010-01-10 00:00:00 |  | FLYHI1
Tuesday | 2010-01-11 00:00:00
Wednesday | 2010-01-12 00:00:00
Thursday | 2010-01-13 00:00:00 |  |  |  |  | AAIR 1
Friday | 2010-01-14 00:00:00 |  |  | AIRR3 |  | AIR2
Saturday | 2010-01-15 00:00:00 |  |  | AIR4
Sunday | 2010-01-16 00:00:00
Monday | 2010-01-17 00:00:00 | AIRR3
Tuesday | 2010-01-18 00:00:00 | AIR4
Wednesday | 2010-01-19 00:00:00 |  |  |  | AAIR 1
Thursday | 2010-01-20 00:00:00 |  |  |  | AIR2
Friday | 2010-01-21 00:00:00
Saturday | 2010-01-22 00:00:00
Sunday | 2010-01-23 00:00:00
Monday | 2010-01-24 00:00:00
Tuesday | 2010-01-25 00:00:00
Wednesday | 2010-01-26 00:00:00
Thursday | 2010-01-27 00:00:00
Friday | 2010-01-28 00:00:00
Saturday | 2010-01-29 00:00:00
Sunday | 2010-01-30 00:00:00
Monday | 2010-01-31 00:00:00
Spreadsheet: 803709d1667633675-formula-help-for-countif-for-data-on-paricular-date-excel-doubt-aligw
Sheet: Sheet1

 | Inputs |  |  | Required Result using [NAME]
 | INVOICE DATE | STATUS |  | STATUS : NO. OF INVOICES | ON 03-Nov-22 |  | Date
 | 2022-11-01 00:00:00 | On Time Completed |  | On Time Completed |  |  | 2022-11-03 00:00:00
 | 2022-11-02 00:00:00 | Delay more than one day |  | Delay more than one day
 | 2022-11-03 00:00:00 | Not Outward |  | Not Outward
 | 2022-11-01 00:00:00 | On Time Completed |  | Grand Total
 | 2022-11-02 00:00:00 | Delay more than one day
 | 2022-11-03 00:00:00 | Not Outward
 | 2022-11-01 00:00:00 | On Time Completed
 | 2022-11-02 00:00:00 | Delay more than one day
 | 2022-11-03 00:00:00 | Not Outward
Spreadsheet: kate_symes__18587__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-06 00:00:00 |  | 211.58 | 3800 | 200 | 600
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: vkaminski__40755__Spike
Sheet: average monthly prices

Month | WTI | NY Harbor Resid | [NAME] | NY Citygate
1998-12-01 00:00:00
1999-01-01 00:00:00
1999-02-01 00:00:00
1999-03-01 00:00:00
1999-04-01 00:00:00
1999-05-01 00:00:00
1999-06-01 00:00:00
1999-07-01 00:00:00
1999-08-01 00:00:00
1999-09-01 00:00:00
1999-10-01 00:00:00
1999-11-01 00:00:00
1999-12-01 00:00:00
2000-01-01 00:00:00
2000-02-01 00:00:00
2000-03-01 00:00:00
Spreadsheet: drew_fossum__8655__Pueblo Econ
Sheet: 140 MW

 |  | Pueblo 140 MW CC
 |  | Project Economics
 |  | Version 1
Percent Debt Financing | 70 |  | Project Life (Yrs) | 10
Annual Debt Interest Rate (%) | 10 |  | Income Tax Rate (%) | 35
Debt Life (Yrs) | 10 |  | Before-Tax Equity Return (%)
After-Tax Equity Return (%) | 20
 | Debt Life | Remainder
Prop. of Equity Return in Period | 1
Capital Recovery (%)
Equity Portion
Debt Portion
Total Capital Recovery (%)
EPC Price ($[NAME]) | 108.6 |  | Capex | $[NAME]/yr
Construction Period (Months) | 24 |  | EPC Price
Annual Hours of Operation | 8500 |  | IDC
Average Output (MW) | 143.7 |  | Construction Insurance
Avg. HHV Heat Rate (Btu/kWh) | 7900 |  | Spare Parts
Fuel Cost ($/MMBtu) | 4.4 |  | O&M Mobilization
Steam Sales (klb/hr) | 0 |  | Working Capital
Steam Energy (Btu/lb) | 0 |  | Owner's Engineer | 1
Steam Generation Efficiency (%) | 0 |  | Legal Costs | 0.5
Steam Price Calculated ($/klb) |  |  | Development Costs & Fees | 0
Steam Price Specified ($/klb) | 0 |  | Land | 0
 |  |  | Subtotal
Revenue Requirement | $[NAME]/yr |  | Financing Costs
Capital Recovery |  |  | Total Capex
Fuel
O&M Expense
Insurance & Taxes
Land Lease | 1 |  | O&M Expenses | $[NAME]/yr
Subtotal |  |  | Payroll | 1.1
Less: Steam Sales |  |  | Administration | 0.2
Power Sales |  |  | Chemicals | 0.2
 |  |  | [NAME] | 0.5
Power Sales (MWh/yr) |  |  | Major [NAME] | 2.3
 |  |  | Fee
Power Price ($/MWh) |  |  | Total O&M Expenses
Spreadsheet: 120804d1315523056-how-to-count-matching-cells-in-two-columns-example
Sheet: Sheet1

A | B | C
46 | 73 | 46 |  | 0 | 1
90 | 89 | 87 |  | 0 | 0
85 | 85 | 99 |  | 1 | 0
50 | 55 | 50 |  | 0 | 1
 | 1 | 2
Spreadsheet: 131056d1322708207-activity-planning-sample
Sheet: Sample Timephasing

Activity. No. | Description | Remaining Hours | Planned Hours | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-26 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2011-12-29 00:00:00 | 2011-12-30 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
1 | Activity 1 | 40 |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  | Vacation |  |  |  |  |  |  |  |  |  | Christmas |  |  |  |  | New Year's Day
2 | Activity 2 | 40 |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8
3 | Activity 3 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8
 | Subtotal
Spreadsheet: 161105d1339417978-cross-point-of-two-function-in-chart-book1
Sheet: Sheet1

 |  | 4.193967720408163 | 1302.781268713551 |  |  | 0.8748591536880213 | 1278.054841140758
 |  | 3.672827827721669 | 1354.586991482415 |  |  | 0.9289675429969491 | 1171.077052020268
 |  | 3.255132062558342 | 1363.195164993982 |  |  | 0.987390734449082 | 1088.020228698586
 |  | 2.91286089923527 | 1345.921356334112 |  |  | 1.050666385232726 | 1022.444460230285
 |  | 2.627276199883197 | 1312.705788962237 |  |  | 1.119425351889706 | 970.1535951184567
 |  | 2.385372082880447 | 1269.376428101632 |  |  | 1.194412799471031 | 928.128986527904
 |  | 2.177838680677068 | 1219.016052996837 |  |  | 1.276515320252397 | 894.2487808363031
 |  | 1.997836311307962 | 1164.236266042309 |  |  | 1.366796157437255 | 866.9568183447366
 |  | 1.840227174474974 | 1106.86325192698 |  |  | 1.466541508065025 | 845.087382123724
 |  | 1.701077013546527 | 1048.160690662112 |  |  | 1.577322195689623 | 827.7537240475283
 |  | 1.577322195689623 | 988.9593076018607 |  |  | 1.701077013546527 | 814.2667048041757
 |  | 1.466541508065025 | 929.8293478372755 |  |  | 1.840227174474974 | 804.0797923700916
 |  | 1.366796157437255 | 871.21533586149 |  |  | 1.997836311307962 | 796.7616884886063
 |  | 1.276515320252397 | 813.4274001402409 |  |  | 2.177838680677068 | 791.9665305162345
 |  | 1.194412799471031 | 756.6791913062608 |  |  | 2.385372082880447 | 789.4811511787559
 |  | 1.119425351889706 | 701.114863637405 |  |  | 2.627276199883197 | 788.9811657297073
 |  | 1.050666385232726 | 646.8325308812005 |  |  | 2.91286089923527 | 790.3203441843705
 |  | 0.987390734449082 | 593.9458039073407 |  |  | 3.255132062558342 | 793.3474767044296
 |  | 0.9289675429969491 | 542.4787725836311 |  |  | 3.672827827721669 | 797.9391814839627
 |  | 0.8748591536880213 | 492.4142299345804 |  |  | 4.193967720408163 | 803.9582010853717