tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 46865d1245786879-if-and-pull-down-lists-example
Sheet: Sheet1

 | VLOOKUP Cell | Drop Down Cell |  |  |  |  |  |  | [NAME]
B | [NAME] | Answer A |  |  |  |  |  |  | List2
Table
A | DEPENDS ON SHIPPING LOCATION
B | [NAME]
C | DEPENDS ON SHIPPING LOCATION
D | Chicago
E | New York
F | DEPENDS ON SHIPPING LOCATION
G | Paris
H | San Francisco
I
Spreadsheet: mary_fischer__25638__31U
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 983898 |  | 117459
Gross PP & E
Accumulated DD & A |  | -639372 |  |  |  |  |  | -56989 |  |  |  | -21180 |  | 28180
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
Amortization of Franchise Agrmts |  | 1417 |  | 21180 |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  | Research for 3Q |  |  |  |  |  | 28180 |  | 28180
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: f29690fa-6c99-4a34-bd8a-ae5a3783bfed
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Under Construction: United States
 |  | Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: November 25, 2014 (6:34 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008 | 592 | 578 | 563 | 552 | 532 | 511 | 489 | 479 | 456 | 437 | 417 | 397
2009 | 383 | 366 | 344 | 327 | 316 | 314 | 316 | 311 | 314 | 308 | 301 | 300
2010 | 299 | 302 | 306 | 307 | 301 | 282 | 277 | 273 | 270 | 266 | 266 | 262
2011 | 260 | 253 | 253 | 249 | 246 | 246 | 242 | 238 | 237 | 235 | 236 | 236
2012 | 241 | 245 | 246 | 246 | 253 | 257 | 262 | 265 | 271 | 275 | 279 | 284
Spreadsheet: lindy_donoho__22113__2002 Summary for Presentation_Rev
Sheet: Summary_Rev

Transwestern Pipeline Company
Commercial Group
2002 Operating Plan
Commercial Contribution
(Millions)
 |  |  |  |  |  |  | 2002 Plan
 |  |  | Plan | 3rd CE | Total |  |  |  |  | Total
 | Margins |  | 2001 | 2001 | 2002 |  | Contracted | Un-Contracted | Stretch | 2002
 | Demand & Commodity Margins |  | 151.6 | 176.1 | 170.7 |  | 157.9 | 9 | 3.8
 | Fuel |  | 32.9 | 38.2 |  |  | 21.7 | 4.8 | 4.7
 | Negotiated Rate |  | 0 | -10.4 | 0
 | Other Revenues |  | 10.1 | 0.1 | -0.2 |  | -0.2 |  |  | -0.2
 | Total Margin
 | Expenses:
 | [NAME]. Expense/Reg Assets |  | -8.8 | -8.4 | -7.6
 | Direct O&M |  | -2.9 | -2.8 | -2.8
 | UAF |  | -1.8 | -1.1 | -1.1
 | Total Expenses
 | Net Commercial Contribution
 | Target Adjustment |  | -4
 | Adjusted Net Commercial Contribution
Spreadsheet: 844930d1696527129-excel-pivot-with-averages-edit-deidentified-workbook-for-forum-admissions
Sheet: Appoints per day by month

CountAs | Column Labels
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Grand Total
Row Labels
Mon | 61 | 53 | 64 | 67 | 69 | 56 | 64 | 68 | 92 | 594
Fri | 59 | 53 | 66 | 63 | 60 | 53 | 55 | 48 | 49 | 506
Sat | 23 | 18 | 15 | 16 | 17 | 7 | 23 | 13 | 15 | 147
Thu | 62 | 54 | 77 | 64 | 51 | 51 | 62 | 53 | 45 | 519
Tue | 72 | 60 | 59 | 65 | 75 | 55 | 51 | 61 | 87 | 585
Wed | 62 | 55 | 71 | 67 | 72 | 53 | 49 | 39 | 49 | 517
Grand Total | 339 | 293 | 352 | 342 | 344 | 275 | 304 | 282 | 337 | 2868
Spreadsheet: tracy_geaccone__40271__AEL 06 01
Sheet: Balance Sheet

Azurix Europe Ltd
Balance Sheet
June 2001
(US GAAP & USD thousands)
Actual exchange rate |  |  | 1.4077 |  | 1.4175 |  | 1.4955
 |  |  | Current |  | Prior |  | December
 |  |  | Month |  | Month |  | 2000
Current Assets:
 | Cash and cash equivalents |  | 578 |  | 126 |  | 1607
 | Restricted cash and cash equivalents |  | 122469 |  | 113400 |  | 104685
 | Third party trade receivables |  | 47739 |  | 51833 |  | 58180
 | Allowance for doubtful accounts |  | -7753 |  | -7702 |  | -8154
 | Accounts receivable - affiliates |  | 200769 |  | 190951 |  | 159273
 | Marketable securities |  | 2696 |  | 2433 |  | 2560
 | Inventory & WIP |  | 6531 |  | 7591 |  | 6694
 | Unbilled receivables |  | 25355 |  | 24728 |  | 27065
 | Prepaid items |  | 32257 |  | 36151 |  | 48008
 | Other current assets |  | 0 |  | 0 |  | 0
Total current assets
Property, plant and equipment, at cost |  |  | 2391492 |  | 2402203 |  | 2470519
Accumulated depreciation |  |  | -176996 |  | -170607 |  | -164146
 | Property, plant and equipment - net
Investments in unconsolidated affiliates |  |  | 519 |  | 523 |  | 552
Goodwill |  |  | 748695 |  | 753907 |  | 795392
Accumulated amortization, goodwill |  |  | -51442 |  | -50230 |  | -44709
Concession rights |  |  | 0 |  | 0 |  | 0
Accumulated amortization, concession rights |  |  | 0 |  | 0 |  | 0
Other intangible assets |  |  | 0 |  | 0 |  | 0
Accumulated amortization, other intangible assets |  |  | 0 |  | 0
 | Intangibles, net
Deferred financing fees |  |  | 1102 |  | 1220 |  | 1873
Deferred tax asset |  |  | 0 |  | 0 |  | 0
Other long-term assets |  |  | 23919 |  | 24097 |  | 12648
 | Other assets
Total Assets
Current Liabilities:
 | Accounts payable - trade |  | -4061 |  | -1296 |  | -1212
 | Accrued taxes |  | -11674 |  | -10750 |  | -24855
 | Restructuring provision |  | 0 |  | 0 |  | 0
 | Capital creditors |  | -33674 |  | -42737 |  | -47914
 | Accounts payable--affiliates |  | -691 |  | -696 |  | -734
 | Deferred income |  | -31944 |  | -30630 |  | -43199
 | Short-term debt - third party |  | -388311 |  | -392582 |  | -338457
 | Short-term debt - affiliates |  | -102762 |  | -103477 |  | -109171
 | Current maturities of long-term debt |  | -73469 |  | -73981 |  | -76019
 | Other current liabilities |  | -47743 |  | -53044 |  | -76058
Total current liabilities
Long-term debt (excluding current maturities) |  |  | -696257 |  | -686350 |  | -689489
Long-term debt--affiliates |  |  | 0 |  | 0 |  | 0
Customer deposits |  |  | -5563 |  | -5602 |  | -3644
Deferred taxes |  |  | -429889 |  | -431190 |  | -450281
Other long-term liabilities |  |  | -353 |  | -728 |  | -2436
Total liabilities
Minority Interest |  |  | 0 |  | 0 |  | 0
Stockholders' equity:
 | Common stock |  | -70 |  | -71 |  | -75
 | Additional paid-in capital |  | -1327612 |  | -1336854 |  | -1410416
 | Retained earnings |  | -215813 |  | -212788 |  | -200018
 | Gain/loss on held for sale securities |  | 1071 |  | 1275 |  | 1350
 | Cumulative FX translation adjustment |  | 885 |  | 877 |  | 581
Total stockholders' equity
Total Liabilities and Stockholders' Equity
Spreadsheet: 163064d1340181726-need-help-whit-a-graph-839566
Sheet: Sheet1

 |  |  | moored | steaming | dp standby | dp operation
 |  | a | 9 | 5 | 19 | 21
 |  | b | 7 | 12 | 12 | 8
 |  | c | 19 | 11 | 23 | 24
 |  | d | 23 | 16 | 23 | 19
moored |  | e | 11 | 19 | 8 | 20
 |  | f | 14 | 6 | 20 | 10
 |  | g | 11 | 25 | 20 | 13
Spreadsheet: 790589d1659852759-search-table-given-dates-and-numbers-as-criteria-help_please_2-aligw
Sheet: Sheet1

VOLUME DISCOUNT PER ITEM TABLE BASED ON INVOICE DATE
VOLUME PER ITEM: |  |  | 5000 | <<-- GIVEN | CHANNEL: |  | EU | <<-- GIVEN
INVOICE DATE: |  |  | 2022-01-15 00:00:00 | <<-- GIVEN | VOLUME DISCOUNT: |  |  | <<<--- C/O JohnTopley
 |  |  |  |  | VOLUME DISCOUNT: |  |  | <<<--- c/o AliGW |  |  | <<< Reward AliGW
 |  |  |  |  | EXCEL 365 FORMULA: |  |  | <<<--- my version
Thanks to JphnToply for the LOOKUP function recommendation and to AliGW for the SUMPRODUCT recommendation. I am able to get the Volume Discount based on given DATE, VOLUME and CHANNEL EU/DL/DR/RB/PL/RM.
SORT DATE THEN VOL ASCENDING
VOL | REWARD | FR_DATE | TO_DATE | EU | DL | DR | TB | PL | RM
0 | NONE | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.03 | 0 | 0 | 0 | 0 | 0
5000 | 5K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.06 | 0 | 0 | 0 | 0 | 0
10000 | 10K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.09 | 0 | 0 | 0.03 | 0.03 | 0
15000 | 15K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.12 | 0 | 0 | 0.06 | 0.06 | 0
20000 | 20K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.09 | 0.09 | 0
25000 | 25K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.12 | 0.12 | 0
30000 | 30K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
999999999 | 30K MARK | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
0 | NONE | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
1600 | [NAME] | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
4000 | 4K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
8000 | 8K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
12000 | 12K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
16000 | 16K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
20000 | 20K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
24000 | 24K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 24K MARK | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
PREVIOUS TASK: EXTRACT DISCOUNT BASED ON GIVEN DATE, VOLUME (NUMBER) AND CHANNEL (HEADERS).
NEXT TASK: EXTRACT THE VALUE UNDER COLUMN REWARD BASED ON GIVEN DATE & VOLUME (NUMBER) USING THE SAME TABLE.
 | Altering JohnTopley's recommendation: LOOKUP Function
 | Modifying AliGW's recommendation: SUMPRODUCT Function
HELP HERE -->
 | Modifying my Excel 365 Formula
HELP: | @ [NAME] cell. I cannot seem to use SUMPRODUCT since I am extracting a column with TEXT value. Other than LOOKUP, can I use INDEX MATCH or [NAME] with this?
Spreadsheet: 749432d1632797055-grab-numbers-meeting-criteria-from-list-sample-8-
Sheet: List

List
4.08
4.33
4.78
4.82
4.26
3.63
5.6
5.39
4.58
4.66
3.56
3.26
3.27
3.25
3.81
3.29
2.97
2.88
3.97
2.57
2.56
2.56
2.5
2.49
Spreadsheet: 2b276128-4df4-4106-8a10-4e79a1bb8ac2
Sheet: Sheet1

CUCM 5.0 Release | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27
Legend
 | Supported: passed testing.
 | Unsupported: vendor s/w doesn't support, failed testing, or MIB doesn't provide useful information.
 | Only supported when upgrade to 5.1 (Cisco defect: req'd files not installed for fresh install).
 | Unsupported: supported by another MIB or not available.
 | Not Applicable: MIB doesn't apply to server configuration or is satisfied by another MIB.
 |  | IBM MIBs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SNMP Research & CUCM Serviceability MIBs
[NAME] | CPU Speed | UMSHEALTH | UMSMEMORY | UMSNIC | UMSPROCESSOR | UMSASSETID | UMSLMSENSOR | UMSPOWER | UMSEVENT | IBM-SERVERAID |  | IBM-SYSTEM-HEALTH | IBM-SYSTEM-MEMORY | IBM-SYSTEM-NETWORK | IBM-SYSTEM-PROCESSOR | IBM-SYSTEM-ASSETID | IBM-SYSTEM-LMSENSOR | IBM-SYSTEM-POWER | IBM-SYSTEM-TRAP | IBM-SYSTEM-RAID |  | HOST-RESOURCES | [NAME] | SYSAPPL | CISCO-CCM | CISCO-SYSLOG | CISCO-CDP
MCS-7815-I1-IPC1 | 3.06GHz
MCS-7815-I2-IPC1 | 2.8GHz
MCS-7825I-3.0-IPC1 | 3.06GHz
MCS-7825-I1-IPC1 | 3.4GHz
MCS-7825-I2-IPC1 | 2.8GHz
MCS-7835I-2.4-EVV1 | 2.4GHz
MCS-7835I-3.0-IPC1 | 3.06GHz
MCS-7835-I1-IPC1 | 3.4GHz
MCS-7845I-3.0-IPC1 | 3.06GHz
[NAME] | 3.4GHz
 |  | HP MIBs
 |  | CPQHLTH | [NAME] | CPQNIC | CPQSINFO | CPQSTDEQ | CPQTHRSH | CPQSM2 | CPQIDE | CPQIDA | [NAME] | CPQSCSI
MCS-7825H-2.2-EVV1 | 2.26GHz
MCS-7825H-3.0-IPC1 | 3.06GHz
MCS-7825-H1-IPC1 | 3.4GHz
MCS-7825-H2-IPC1 | 2.8GHz
MCS-7835H-2.4-EVV1 | 2.4GHz
MCS-7835H-3.0-IPC1 | 3.06GHz
MCS-7835-H1-IPC1 | 3.4GHz
MCS-7845H-2.4-EVV1 | 2.4GHz
MCS-7845H-3.0-IPC1 | 3.06GHz
[NAME] | 3.4GHz
Total | 20
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: SITHE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SITHE
 |  |  | Total |  | Reclasses |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  | 117762.31
2 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 168920
3 |  | Interdesk |  |  |  |  |  |  |  |  | 494900 | 1816135
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  | 0
7 |  | Liquidations |  |  |  |  |  |  |  |  |  | -168920
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  | 23229 | 70198.07
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  | 393304 | 1188564.69
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  | -518129 | -1565785.84 |  |  | -393304 | -1188564.69
23 | Fuel: |  |  |  |  |  |  |  |  |  | -23229 | -70198.04
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  | -34422 | -8647.49 | -2250 | -6.22 | -940492.25 | -21996.84
25 |  | Demand |  |  |  |  |  |  |  |  |  | 8200 |  |  |  | -8200
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: 155510d1336908429-calculating-3-from-5-cells-testing-results
Sheet: Sheet1

Name | race 1 | race 2 | race 3 | race 4 | race 5 | best 3 from 5
[NAME] | 2 | 1 | 4 | 2 | 3
[NAME] | 1 | 7 | 2 | 4 | 1
Fred | 4 | 2 | 1 | 5 | 5
Spreadsheet: benjamin_rogers__1191__Rochester model version1
Sheet: Notes

NOTES
1 | The model shows only an example of the economics for a LM6000 project. Please modify the model for the specific transaction
 | you are trying to model (Please see the contact list below)
2 | Please double check the model/pages before sending out to clients as certain information/comment cells/notes etc. may be too detailed to be disclosed
3 | All yellow shaded cells are required input cells
4 | Turbine carrying cost are based on assumptions on the WestLB Structure, the numbers may change after 03/15/00
5 | The dispatch template is attached. Please check with [NAME] for the required inputs
SOURCES
 |  |  |  |  |  |  |  | Source
1 | Federal Tax, Franchise Tax, Sales & Used Tax, NOL |  |  |  |  |  |  | [NAME]
 | calculations
2 | 15 year MACRS |  |  |  |  |  |  | [NAME]
3 | Book Depreciation |  |  |  |  |  |  | Use GenCo assumption as per [NAME]
4 | [NAME] |  |  |  |  |  |  | [NAME]'s cost model, calculated by [NAME]
5 | No Capacity Degradation for LM [NAME] model |  |  |  |  |  |  | [NAME]
6 | Spread Option Model |  |  |  |  |  |  | [NAME]
7 | Estimated drawdown schedule |  |  |  |  |  |  | [NAME]
8 | Property Tax, State Tax |  |  |  |  |  |  | [NAME]
9 | Heat Rate Degradation |  |  |  |  |  |  | [NAME]
CONTACTS
 | Subjects |  |  | Contacts |  |  | Extension
 | Model |  |  | [NAME] |  |  | x 3-9446
 |  |  |  | [NAME] |  |  | x 3-7998
 | Turbine/Technical Info |  |  | [NAME] |  |  | x 3-6337
 | Engineers |  |  | [NAME] |  |  | x 6-6385
 |  |  |  | [NAME] |  |  | x 6-6063
 |  |  |  | [NAME] |  |  | x 6-7089
 | O&M |  |  | [NAME] |  |  | x 6-8371
 | Spread Option Model |  |  | [NAME] |  |  | x 3-7202
 | Accounting |  |  | [NAME] |  |  | x 5-7405
 | Federal Tax, [NAME]. Tax |  |  | [NAME] |  |  | x 3-7022
 |  |  |  | [NAME] |  |  | x 3-3979
 |  |  |  | [NAME] |  |  | x 3-6174
 | State/Property Tax |  |  | [NAME] |  |  | x 3-0689
 |  |  |  | [NAME] |  |  | x 3-6367
Spreadsheet: 193793d1352950743-track-high-score-and-transfer-info-scoresummary-max-rev2
Sheet: Mike

Scores
11 | Glendale
12 | Tucson
13 | Phoenix
14 | Peoria
15 | Scottsdale
1 | Surprise
2 | [NAME]
3 | Prescott
4 | Flagstaff
5 | [NAME]
6 | Tempe
Spreadsheet: 829394d1684178468-formula-to-sum-based-condition-and-range-of-account-numbers-sample-for-forum-etaf
Sheet: Data

 | Pay Period Range | Expense Category
 | 51100 | Wages
 | 59110 | Wages
 | 59110 | Benefits
 | 59120 | Benefits
 | 59130 | Benefits
 | 59140 | Benefits
 | 59150 | Benefits
 | 59160 | Benefits
 | 59170 | Benefits
 | 59180 | Benefits
 | 59190 | Benefits
 | 59200 | Benefits
 | 59210 | Benefits
 | 59220 | Benefits
 | 59230 | Benefits
 | 59240 | Benefits
 | 59250 | Benefits
 | 59260 | Benefits
 | 60100 | Patient Care
 | 60110 | Patient Care
 | 60120 | Patient Care
 | 60130 | Patient Care
 | 60140 | Patient Care
 | 60150 | Patient Care
 | 60160 | Patient Care
 | 60170 | Patient Care
 | 60180 | Patient Care
 | 60190 | Patient Care
 | 60200 | Patient Care
 | 60210 | Patient Care
 | 60220 | Patient Care
 | 60230 | Patient Care
 | 60235 | Patient Care
 | 60240 | Patient Care
 | 60250 | Patient Care
 | 60260 | Patient Care
 | 60265 | Patient Care
 | 60270 | Patient Care
 | 60280 | Patient Care
 | 60300 | Patient Care
 | 60310 | Patient Care
 | 60320 | Patient Care
 | 60400 | Patient Care
 | 62100 | Plant Operations
 | 62110 | Plant Operations
 | 62120 | Plant Operations
 | 62130 | Plant Operations
 | 62140 | Plant Operations
 | 62200 | Plant Operations
 | 62210 | Plant Operations
 | 62220 | Plant Operations
 | 62230 | Plant Operations
 | 62240 | Plant Operations
 | 62250 | Plant Operations
 | 62260 | Plant Operations
 | 62300 | Plant Operations
 | 62310 | Plant Operations
 | 62320 | Plant Operations
 | 62330 | Plant Operations
 | 62400 | Plant Operations
 | 62410 | Plant Operations
 | 62500 | Plant Operations
 | 62503 | Plant Operations
 | 62505 | Plant Operations
 | 62510 | Plant Operations
 | 62520 | Plant Operations
 | 64100 | General & Administrative
 | 64110 | General & Administrative
 | 64120 | General & Administrative
 | 64130 | General & Administrative
 | 64140 | General & Administrative
 | 64141 | General & Administrative
 | 64150 | General & Administrative
 | 64160 | General & Administrative
 | 64170 | General & Administrative
 | 64180 | General & Administrative
 | 64190 | General & Administrative
 | 64200 | General & Administrative
 | 64210 | General & Administrative
 | 64220 | General & Administrative
 | 64230 | General & Administrative
 | 64400 | General & Administrative
 | 64410 | General & Administrative
 | 64420 | General & Administrative
 | 64430 | General & Administrative
 | 64600 | General & Administrative
 | 64610 | General & Administrative
 | 67100 | Equipment Related
 | 67110 | Equipment Related
 | 67120 | Equipment Related
 | 67140 | Equipment Related
 | 67150 | Equipment Related
 | 68100 | Interest Expense
 | 68210 | Depreciation/Amortization
 | 68220 | Depreciation/Amortization
 | 68300 | Miscellaneous
 | 68320 | Miscellaneous
 | 68500 | Assessment
 | 70125 | Miscellaneous
Spreadsheet: 111192-enter-correct-values-in-non-contiguous-cells-depending-on-frequency-budget
Sheet: December Budget

 |  |  | Daily amount
 |  |  | Cumulative
 | Unlock password = cashflow
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | [NAME] DETAILS
 | Description | Value | Day of month/ day of week | 2011-09-01 00:00:00
 | Income
 | Marcus Fortnightly | 3525 | 14
 | Michelle Director SOM | 9000 | 3
 | Michelle Director [NAME] | 2000 | 19
 | Michelle Dividend | 3750 | 19
 | Expenses
 | Direct debits
 | Variable loan | 2402 | 5
 | [NAME] and trish loan | 1000 | 5
 | [NAME] | 3254.17 | 5
 | [NAME] | 900 | 5
 | Swimming | 142 | 7
 | St [NAME] | 1113.66 | 9
 | Melaleuca | 120 | 10
 | Petsure | 63.03 | 10
 | RAC | 142.57 | 10
 | HBF Health | 271.05 | 11
 | MLC | 19.27 | 11
 | HBF contents and building | 86.55 | 11
 | Foxtel | 105 | 13
 | Telstra | 80 | 13
 | Alinta | 160 | 18
 | Synergy | 600 | 19
 | Fixed Loan | 3389 | 20
 | [NAME] | 1043.34 | 27
 | ATO | 800 | 27
 | ATO | 800 | 27
 | ALI | 7.03 | 27
 | ATO | 450 | 28
 | Amnet | 59 | 28
 | Newspapers | 48 | 28
 | Expenses
 | Manual / variable
 | Fuel | 150 | Wed
 | Groceries | 150 | Fri
 | Fruit and Veg | 70 | Sun
 | TOTALS