tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 197917d1354613176-scrolling-within-a-spreadsheet-help-me
Sheet: help

 |  | PLAN
 |  | SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER
 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Spreadsheet: 115985d1311444403-if-then-change_example
Sheet: Sheet1

Overview |  |  |  |  |  |  | Surplus | Revenue
Revenue | -100 |  |  |  |  |  | 600 | 500
Surplus | 1700 |  |  |  |  |  | 500 | 200
 |  |  |  |  |  |  | 200 | 600
 |  |  |  |  |  |  | 400 | 300
 |  |  |  |  |  |  |  | -500
 |  |  |  |  |  |  |  | -200
 |  |  |  |  |  |  |  | -600
 |  |  |  |  |  |  |  | -400
When the "Revenu" drops below 0, I'd like for the "Surplus" to transfer funds into Revenue to bring Revenue to 0
How would I get the macro to function in this worksheet?
Spreadsheet: 172150d1344007481-split-a-line-of-words-each-word-in-a-separate-cell-example
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
!BERLIN, !LONDON, !MADRID, !PARIS, !ROME, !ATHENS | !BERLIN | !LONDON | !MADRID | !PARIS | !ROME | !ATHENS
!UK, !FRANCE, !GERMANY, ![NAME], !SPAIN | !UK | !FRANCE | !GERMANY | ![NAME] | !SPAIN
!ONE, !TWO, !THREE, !FOUR | !ONE | !TWO | !THREE | !FOUR
Spreadsheet: 123654d1317779115-excel-2007-lookup-to-find-where-integer-falls-within-a-table-of-starting-and-ending-values-book1_true_jedimaster
Sheet: Sheet1

Return Value | Starting | Ending
Value | [NAME] | [NAME] |  | Lookup value |  | Expected Returned Value from formula
A | 1 | 10 |  | 5 |  | A
B | 855 | 897 |  | 244 |  | D
C | 151 | 156 |  | 880 |  | B
D | 243 | 312
E | 313 | 323
F | 1224 | 1244
G | 157 | 242
H | 1189 | 1191
I | 965 | 1017
J | 1181 | 1188
K | 64 | 116
L | 324 | 348
M | 1192 | 1208
N | 349 | 359
O | 1018 | 1038
P | 898 | 964
Q | 117 | 139
R | 360 | 448
S | 1128 | 1180
T | 449 | 715
U | 11 | 63
V | 1039 | 1127
W | 140 | 150
X | 769 | 854
Y | 1209 | 1223
Z | 716 | 768
Spreadsheet: 267216d1380015354-need-help-to-compare-multiple-columns-stock
Sheet: Sheet1

SYSTEM |  |  | PHYSICAL |  |  | RESULT
batch no | slice no | qty | batch no | slice no | qty | batch no | slice no | qty
abc | 1 | 11000 | abc | 1 | 11000 | abc | 1
abc | 2 | 22000 | abc | 3 | 22000 | abc | 2 |  | Physical stock does not exists
abc | 3 | 23000 | abc | 4 | 52000 | abc | 3 |  | Physical stock qty less than system
abc | 4 | 52000 | bcd | 1 | 11000 | abc | 4
bcd | 1 | 11000 | bcd | 6 | 45000 | bcd | 1
bcd | 2 | 11000 | bcd | 5 | 24000 | bcd | 2 |  | Physical stock does not exists
bcd | 3 | 23000 |  |  |  | bcd | 3 |  | Physical stock does not exists
bcd | 5 | 22000 |  |  |  | bcd | 5 |  | Physical stock qty more than system
 |  |  |  |  |  | bcd | 6 |  | System stock does not exists
Spreadsheet: 193825d1352966462-is-there-a-faster-and-beter-way-to-use-my-info-on-this-worksheet-netbackup-errors-11-2012
Sheet: error_code

1 | The requested operation was partially successful
2 | None of the requested files were backed up
6 | The backup failed to back up the requested files
23 | Socket read failed
24 | Socket write failed
25 | Cannot connect on socket
28 | Failed trying to fork a process
40 | Network connection broken
48 | Client hostname could not be found
50 | Client process aborted
58 | Can't connect to client
59 | Access to the client was not allowed
71 | None of the files in the file list exist
89 | Problems encountered during setup of shared memory
96 | Unable to allocate new media for backup, storage unit has none available
129 | Disk storage unit is full
150 | Termination requested by administrator
191 | No images were successfully processed
196 | Client backup was not attempted because backup window closed
229 | Events out of sequence - image inconsistency
233 | Premature eof encountered
811 | Failed to communicate with resource requester
Spreadsheet: 220901d1363296220-need-help-two-columns-and-a-table-of-actions-test1
Sheet: Sheet1

Name | Past Due 20-31 days | Past Due  > 31 days | Action | In theory assuming first offense |  |  | Actions:
[NAME] | 0 | 0 |  | [NAME] |  |  | 0 | [NAME] | Has to be 0 in both Columns
[NAME] | 5 | 2 |  | Past Due >31: $0 |  |  | 1 | Past Due (20-31) | Can only have data in Col B
[NAME] | 1 | 0 |  | Past Due (20-31) |  |  | 2 | Past Due >31: $0 | If there is data only in column c or in both b & c, use column c, after the fourth offense > 31 days every offense after is $15.
 |  |  |  |  |  |  | 3 | Past Due >31 : $5
 |  |  |  |  |  |  | 4 | Past Due > 31: $10
 |  |  |  |  |  |  | 5 | Past Due>31: $15
Spreadsheet: 0050710e-be3b-45d7-8838-6c960e8dfec1
Sheet: Enclosure A

Advertising and Integrated Marketing Solutions (AIMS )         Solicitation 7FCB-H2-07-0541-B              Page 3 of 4
ENCLOSURE A
Instructions - Direct Labor or Task entries:
Note: Order entries in the Pricing for Direct Labor as they appear on the Commercial Price list or Market Rate Sheet (Market Prices), to facilitate sequential review.
SIN(s) Proposed:
Enter SIN, SIN(s), or ‘All’ applicable to the labor or task element entry.  NOTE: ODC SIN(s) 541-1000 and/or 541-2000 should not be included in this section.
Service Proposed:
Enter fully burdened direct labor Title or Task name.
Commercial Price List (CPL) or Market Prices: Enter the fully burdened/undiscounted direct labor or task element commercial pricing (Commercial Price List rate) (dollar amount).
Unit of Issue:
Enter unit of issue for the labor or task element (Example: Hourly).
Most Favored Customer (MFC):
Enter the MFC name corresponding to the direct labor or task entry (i.e.: Company name or Category of Customers). The MFC is the company or category of customers that receives the most favorable discount, if any, from commercial pricing (Commercial Price List rates). If no discount is offered to any commercial customer from the Commercial Price List rates, the MFC is ‘All Commercial Customers’. The MFC discount is "0%" if no firm obtains a discount from the Commercial Price List rates.
Discount offered to MFC (%):
Enter the discount (X%) from the commercial pricing (Commercial Price List rates) offered to the MFC for the direct labor or task element entry.
[NAME]:
Enter the fully burdened direct labor or task element commercial pricing (Commercial Price List rate) discounted by the MFC discount percentage (X%) (dollar amount).
Discount Offered to GSA (excluding IFF):
Enter the discount (X%) from commercial pricing (Commercial Price List rates) offered to GSA for the direct labor or task element entry.
Price Offered to GSA (excluding  IFF):
Commercial Price (dollar amount) discounted by the GSA discount percentage (X%).
Price Offered to GSA (including IFF):
Discounted GSA price (dollar amount) (Price Offered to GSA (excluding IFF)) / .9925 (This formula incorporates the 0.75% Industrial Funding Fee). The price inclusive of IFF is referred to as the GSA Net Price.
Supporting Invoice Number:
Place the invoice or supplier quotation number in the Invoice column for each direct labor or task element entry. Order supporting invoices or quotes sequentially, as entries appear in your Pricing file, to facilitate review.
Spreadsheet: benjamin_rogers__1055__GenCo Breakeven
Sheet: Sheet1

GenCo Breakeven Analysis
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Fixed O&M | 9650.906969171428
Owner's Expense | 2301.59062
Property Taxes | 2138.76 | 2485.407 | 2675.493 | 2752.735 | 2800.401 | 3000.837 | 3133.239 | 3204.112 | 3150.18 | 3985.138 | 3774.313 | 3371.88 | 3464.7 | 3464.7 | 3953.498301179623 | 3397.532312203215 | 3421.13495844728 | 3445.209657616225 | 3469.76585076855 | 3485.555162296597
Franchise Tax | 1509.581831865516 | 1464.88902920642 | 1419.526285547098 | 1317.548366082319 | 1253.956645044449 | 1193.871585118724 | 1135.369352310593 | 1077.007608680482 | 1018.96022288424 | 959.1642009275049 | 902.2579978742149 | 845.1170847106499 | 787.3108581010013 | 728.7268720235588 | 670.0416487308762 | 624.468872316349 | 589.979926623367 | 556.3313648674022 | 522.7364056010233 | 489.2165683093129 | 461.0899904463989 | 434.5804967820283 | 409.5951161300891 | 386.0462225063183 | 363.8512278160678 | 342.9322922104057 | 323.2160510947429 | 304.6333578325801 | 287.1190412420153 | 270.6116770345284
Total Fixed Expense
Debt Service | 99906.60056314187 | 97871.68589220132 | 95654.54005669893 | 93601.40226930217 | 91220.24838569414 | 89003.10255019173 | 86785.95671468932 | 84708.52143868434 | 82351.66504368454 | 80134.51920818214 | 77917.37337267975 | 75815.64060806652 | 73483.08170167496 | 71265.93586617257 | 69048.79003067018 | 66922.7597774487 | 64614.49835966539 | 62397.352524163 | 60180.20668866061 | 58029.8789468309 | 55745.91501765584 | 53528.76918215345 | 51311.62334665106 | 49136.9981162131 | 46877.33167564627 | 44660.18584014388 | 42443.04000464149 | 40244.11728559528 | 38008.74833363671 | 35791.60249813432
Total Fixed Charges
Total Summer Capacity (MWs) | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883 | 2883
Annual Breakeven Prices ($/kW - year)
Monthly Breakeven Prices ($/kW - month)
Average Monthly Breakeven Prices ($/kW - month)
GenCo Breakeven Analysis | 1023998.967018649
($/kW - month) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
Fixed O&M
Owner's Expense
Property Taxes
Franchise Tax
Total Fixed Expenses
Debt Service(1)
Total Breakeven Price
 | Average Breakeven Price
 | Note:
 | (1) Assumes (a) 6.5% Interest Rate on total 1999 & 2000 Peaker Project Cost; and (b) 30-year straight-line amortization
 | (2) GenCo model only has 20 year projection for Property Tax. For 2021 to 2030, this analysis assumes the same Property Tax as 2020
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: NB

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building8

Building8
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 86770d1286746744-how-to-combine-2-series-on-one-line-graph-msw
Sheet: Sheet1

1. Create a pivot from the source data with function code as a row and start and end as data items (this will not work if you have multiple starts/ends for each function)
func code | Data | Total |  | 2. Reference the table as per the below
1 | Sum of start | 1
 | Sum of end | 5
2 | Sum of start | 7
 | Sum of end | 10
3 | Sum of start | 10
 | Sum of end | 15
4 | Sum of start | 15
 | Sum of end | 25
5 | Sum of start | 35
 | Sum of end | 45
3. Create a scatter graph and define the series with you x and y from the appropriate data columns
4. If you want the labels you'd need to add them as x,y charts need the y values to be values (not labels)
Spreadsheet: eric_saibi__9867__101701
Sheet: Big Stone 01

Owner Name |  | Otter Tail Power Company
Station Name |  | Big Stone Power Station
Unit Name |  | Big Stone 01
NERC Region |  | MAPP
State |  | SD
Fuel Type |  | Coal
Capacity |  | 475 MW
Start Date |  | 2001-10-17 00:00:00
End Date |  | 2001-10-23 00:00:00
Comments |  | HP Boiler Wash and Steam Tie-in to Ethanol Plant.
SIC |  | 4911
Plant ID |  | 1014376
Unit ID |  | 1007246
Outage ID |  | 18669
Spreadsheet: 861657d1709546513-groupby-does-not-sum-the-entire-array-provided-groupby-function-horizontal-sum_solved
Sheet: 1

Name | ID | Product | JAN | FEB | MAR | APR | MAY | JUN
Company A | 3 | A | 1133000 | 1053000 | 1133000 | 259000 | 0 | 40000
Company Z | 26 | B | 259000 | 385000 | 1053000 | 385000 | 1000 | 42000
Company B | 2 | C | 0 | 1000 | 1133000 | 1053000 | 1133000 | 1053000
Company C | 3 | A | 40000 | 42000 | 259000 | 385000 | 259000 | 385000
Company A | 1 | C | 149000 | 231000 | 0 | 1000 | 0 | 1000
Company D | 4 | C | 29000 | 18000 | 40000 | 42000 | 40000 | 42000
Company F | 6 | D | 204000 | 224000 | 149000 | 231000 | 149000 | 231000
Company G | 7 | C | 23000 | 79000 | 29000 | 18000 | 29000 | 18000
Company C | 3 | E | 1270000 | 983000 | 204000 | 224000 | 204000 | 224000
Company Z | 26 | C | -8000 | 1000 | 23000 | 79000 | 23000 | 79000
 |  | Company | Q1
 |  |  | 380000
 |  | 2 | 1134000
 |  | 3 | 6117000
Spreadsheet: 34700d06-c5c0-4afe-bd69-30a98a3fc4bf
Sheet: 1 ONDA

SQUAT JUGGERNAUT |  |  |  |  |  |  |  |  | PRIMA ONDA DA 10
Massimale assoluto |  |  | [NAME] | 151 |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  | [NAME] effettivo                       (90% del max assoluto) |  |  |  | [NAME]
 |  |  |  |  |  | % del max effettivo da utilizzare
 | Data |  |  |  |  |  |  |  | [NAME] | serie | ripetizioni
1 SETTIMANA ACCUMULO |  |  |  |  |  | 0.6 |  |  |  | 5 | 10
2 SETTIMANA INTENSIFICAZIONE |  |  |  |  |  | 0.55 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.625 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.675 |  |  |  | 3 | 10
3 SETTIMANA REALIZZAZIONE |  |  |  |  |  | 0.5 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.6 |  |  |  | 1 | 3
 |  |  |  |  |  | 0.7 |  |  |  | 1 | 1
 |  |  |  |  |  | 0.75 |  |  |  | MAR*
4 SETTIMANA SCARICO |  |  |  |  |  | 0.4 |  |  |  | 1 | 5 |  | Commenti:
 |  |  |  |  |  | 0.5 |  |  |  | 1 | 5
 |  |  |  |  |  | 0.6 |  |  |  | 1 | 5
* MAR =NUMERO MASSIMO ASSOLUTO DI RIPETIZIONI
 |  |  |  |  |  |  | 0
[NAME] (MAR) di ripetizioni effettuate
[EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ver. 1.0
Spreadsheet: 679310d1590329195-how-to-find-subtotals-in-variable-positions-testfile2
Sheet: Sheet1

Better Data Base Structure
Raw Data
Data | Category
42 | 1 |  |  |  |  |  | 42 |  |  |  | The position of the gaps (hence totals) can alter
53 | 1 |  |  |  |  |  | 53
54 | 1 |  |  |  |  |  | 54 |  |  |  | We will always want to sum from gap to gap
91 | 1 |  |  |  |  |  | 91 |  |  |  | or from gap to start
49 | 1 |  |  |  |  |  | 49 |  |  |  | or from end to gap
82 | 2
57 | 2 |  |  |  |  |  | 82 |  |  |  | the number of gaps will stay constant ,  2 + end in this example
59 | 2 |  |  |  |  |  | 57
93 | 2 |  |  |  |  |  | 59
15 | 2 |  |  |  |  |  | 93
40 | 2 |  |  |  |  |  | 15
49 | 2 |  |  |  |  |  | 40
4 | 2 |  |  |  |  |  | 49
4 | 2 |  |  |  |  |  | 4
70 | 3 |  |  |  |  |  | 4
2 | 3
78 | 3 |  |  |  |  |  | 70
10 | 3 |  |  |  |  |  | 2
 |  |  |  |  |  |  | 78
Subtotals |  |  |  |  |  |  | 10
Sum | Category
 | 1 |  |  |  |  |  |  | is this correct and should be not instead be 160?
 | 2
 | 3
Check
Spreadsheet: 198719d1354877518-compare-2-worksheets-show-differences-cmpare-jsts
Sheet: Jsts1

[NAME] 'U'
SKU | LABEL | MATERIAL | LENGTH | QTY REQ'D
[NAME] | Text | JSI 2000 2.5" X 14" | 2-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 2
J21409 | Text | JSI 2000 2.5" X 14" | 9-0-0 | 1
J21416 | Text | JSI 2000 2.5" X 14" | 16-0-0 | 1
J21405 | Text | JSI 2000 2.5" X 14" | 5-0-0 | 1
J21406 | Text | JSI 2000 2.5" X 14" | 6-0-0 | 3
J21407 | Text | JSI 2000 2.5" X 14" | 7-0-0 | 6 |  | <=[NAME] is 7
J21409 | Text | JSI 2000 2.5" X 14" | 9-0-0 | 6
J31409 | Text | JSI 3000 2.5" X 14" | 9-0-0 | 1 |  | <=This is not in Jsts2
J21413 | Text | JSI 2000 2.5" X 14" | 13-0-0 | 5
J21415 | Text | JSI 2000 2.5" X 14" | 15-0-0 | 3
J21416 | Text | JSI 2000 2.5" X 14" | 16-0-0 | 5
J21417 | Text | JSI 2000 2.5" X 14" | 17-0-0 | 7
[NAME] |  | JSI 2000 2.5" X 14" | 2008-01-02 00:00:00 | 4 |  | These total 14 on Jsts2
[NAME] |  | JSI 2000 2.5" X 14" | 2004-01-07 00:00:00 | 7
[NAME] |  | JSI 2000 2.5" X 14" | 2004-01-08 00:00:00 | 1 |  | These have no text in column B
[NAME] |  | JSI 2000 2.5" X 14" | 2008-01-09 00:00:00 | 1
[NAME] |  | JSI 2000 2.5" X 14" | 2006-01-11 00:00:00 | 2
J21403 |  | JSI 2000 2.5" X 14" | 2004-02-03 00:00:00 | 1 |  | <=These total 6 in Jsts2
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: Requirements

 |  |  |  |  |  |  |  |  | OIF
 |  |  |  |  |  |  |  |  | Provider | REQ | ASGN | % Fill | 90-Day Loss
 |  |  |  |  |  |  |  |  | BAE | 45
 |  |  |  |  |  |  |  |  | BAE-TVS | 73
 |  |  |  |  |  |  |  |  | CROWS
 |  |  |  |  |  |  |  |  | C2OTM (ESP) | 8
 |  |  |  |  |  |  |  |  | Digital Backbone | 3
 |  |  |  |  |  |  |  |  | EMA | 17
 |  |  |  |  |  |  |  |  | FPI | 12
 |  |  |  |  |  |  |  |  | GDLS
 |  |  |  |  |  |  |  |  | Honeywell | 5
 |  |  |  |  |  |  |  |  | Jacobs | 1
 |  |  |  |  |  |  |  |  | JLI | 91
 |  |  |  |  |  |  |  |  | LOGCOM
 |  |  |  |  |  |  |  |  | Mantech
 |  |  |  |  |  |  |  |  | [NAME] | 92
 |  |  |  |  |  |  |  |  | OSHKOSH | 2
JPO MRAP THEATER MANNING ANALYSIS |  |  |  |  |  |  |  |  | PM | 8
 |  |  |  |  |  |  |  |  | Rangerland | 4
 |  |  |  |  |  |  |  |  | RG33 | 99
 |  |  |  |  |  |  |  |  | RRAD | 212
 |  |  |  |  |  |  |  |  | SPAWAR
 |  |  |  |  |  |  |  |  | Stanley
2010-07-31 00:00:00 |  |  |  |  |  |  |  |  | TJFIG | 32
 |  |  |  |  |  |  |  |  | VSE
 |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  |  | OIF Totals
1. Enter the required number of personnel from each [NAME] in the yellow box.  Update as required.
2. When you add a new person from a different organization to the data pages, that organization will show on this document.  Once it does, you will be able to enter the requirement.
OIF
Spreadsheet: vkaminski__40790__CASH_Elba_04112000wML
Sheet: PF3

SUMMARY OF NET INCOME AND CASH FLOW ($000) |  |  |  |  | ELBA ISLAND WITH HOEGH GALLEON
 |  |  |  |  | Option 3: Acquire Spot Cargoes after Year 5 (60% Probability)
 | ECONOMICS AT 17% DISC RT ($[NAME]): |  |  |  | ASSUMPTIONS:
 |  |  |  |  | Elba Fixed COS: |  |  | MM/Yr
 |  |  |  |  | Variable Cost / MMBtu: |  |  | + Fuel Costs
 |  |  |  |  | ENE Marketing Costs: |  | 1 | MM/Yr
 |  |  |  |  | SPOT | # of Cargoes | [NAME] | # of Cargoes | [NAME]
 |  |  |  |  | [NAME] | [NAME] | [NAME] | Yrs 6-20 | Yrs 6-20
 |  |  |  |  | Algeria
 |  |  |  |  | Middle East
 |  |  |  |  | Total
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-17 AVG
Elba Island Months of Operation |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 0
Elba Island Contract Year
Algeria Spot LNG Throughput (TBTU/Yr)
Abu Dhabi Spot LNG Throughput (TBTU/Yr)
Total Spot LNG Throughput (TBTU/Yr)
REVENUES
LESS: TERMINALING & MKTG COSTS
PROJECT PRE-TAX INCOME AND CASH FLOW ($000)
Spreadsheet: andy_zipper__747__Global_Prod 10-26-01 EM
Sheet: Not Available 10-26-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
For Curr Exch    Forward                 29Oct01         JPY/USD
For Curr Exch    Forward                 29Oct01         USD/EUR
For Curr Exch    Forward                 29Oct01         USD/GBP
For Curr LME     LME (Spot)              29Oct01         JPY/USD
For Curr LME     LME (Spot)              29Oct01         USD/EUR
For Curr LME     LME (Spot)              29Oct01         USD/GBP
Foreign Currency Reuters BOFC            25Oct01         CAD/USD
GO 0.2% Phy EFP  FOB ARA IPE             16-31Dec01      USD/mt
SG E-W GO Diff   Platts/IPE              Dec01           USD/mt
SG Gasoil Swap   Platts AP               Nov01           USD/bbl
Tkr Freight Swap IITRA                   Dec01           WS/mt
Tkr Freight Swap IITRA                   Jan02           WS/mt
Tkr Freight Swap IITRA                   Nov01           WS/mt
Tkr Freight Swap IITRA                   Oct01           WS/mt
[NAME]                  Dec01           WS/mt
[NAME]                  Jan02           WS/mt
[NAME]                  Nov01           WS/mt
US Coal Phy      Nymex Spec              Apr-Jun02       USD/ST-b
US Coal Phy      Nymex Spec              Jan-Mar02       USD/ST-b
US Coal Phy      Nymex Spec              Jul-Sep02       USD/ST-b
US Coal Phy      Nymex Spec              Oct-Dec02       USD/ST-b
US Crude Fin Opt NYMEX WTI    EP22.5     Dec01           USD/bl/m
US Prop FOB Phy  [NAME]                 Nov01           c/Gl-b
US Prop FOB Phy  CONWY                   Nov01           c/Gl-b
US ResidOil Spd  NYH 1% Crack Spread     Jan-Dec02       USD/bl/m
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: BGC_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  Boston Gas
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 3740000 |  | -3740000
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | 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)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | 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 |  |  |  |  |  |  |  | 0
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
 |  | TOTAL