tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 51061d1250627689-sum-help-for-help
Sheet: Sheet1

 |  |  |  |  | DAY 1 -
 |  |  | HDR
name |  |  | daily entry | cumlative total
[NAME] |  |  | 4 | 4 |  | [NAME] has 4 entries today, the first day for a cumlative of 4, but then tomorrow ) the 2nd day) I need to enter that [NAME] had 3 for that day to bring his cumlative to 7, then repeat each day and for each person the same way.
MARY |  |  | 6 | 6 |  | mary same as able
[NAME] |  |  | 8 | 8 |  | [NAME] same as above
[NAME] |  |  | 10 | 10 |  | [NAME] same as ablove
 |  |  |  |  |  | I need the cumlative to always update with each new daily entry but only for the row (person) im working on.
 |  |  |  |  | DAY 2 | Thanks a bunch.
 |  |  | HDR
name |  |  | daily entry | cumlative total
[NAME] |  |  | 1 | 5
MARY |  |  | 14 | 20
[NAME] |  |  | 2 | 10
[NAME] |  |  | 50 | 60
 |  |  |  |  | DAY 3
 |  |  | HDR
name |  |  | daily entry | cumlative total
[NAME] |  |  | 5 | 10
MARY |  |  | 5 | 25
[NAME] |  |  | 30 | 40
[NAME] |  |  | 30 | 90
Spreadsheet: 268708d1380746653-help-to-amend-sumproduct-formula-to-minus-depending-on-entry-in-another-column-test-page
Sheet: April 13 

Depot | Jobs | Job_Sub_Type | Job_Id | District_Name | Time_On_Site | Time | Date | Cancelled | RP Job | Issues
Argyll & West | PP1 | 16 | 1234 | OBAN | 2013-04-01 14:15:00 | 14:15 | April | Yes
Argyll & West | PP1 | 16 | 1235 | OBAN | 2013-04-01 10:20:00 | 10:20 | April | N o
Argyll & West | PP2 | 18 | 1236 | FORT WILLIAM | 2013-04-01 11:45:00 | 11:45 | April | Yes
Argyll & West | PP2 | 18 | 1237 | FORT WILLIAM | 2013-04-01 11:45:00 | 11:45 | April | Yes
Central Belt West | PP1 | 16 | 1238 | AYR | 2013-04-01 11:10:00 | 11:10 | April | No
Argyll & West | PP2 | 18 | 1239 | FORT WILLIAM | 2013-04-01 12:00:00 | 12:00 | April | No
Highland | PP2 | 18 | 1240 | WICK | 2013-04-01 12:58:00 | 12:58 | April | No
Tayside & Central | Other | 14 | 1241 | PERTH | 2013-04-01 19:00:00 | 19:00 | April | No
North East | SNS | 1 | 1242 | ELGIN/HUNTLY | 2013-04-01 13:35:00 | 13:35 | April | No
North East | SNS | 1 | 1243 | ELGIN/HUNTLY | 2013-04-01 13:35:00 | 13:35 | April | No
North East | SNS | 1 | 1244 | ELGIN/HUNTLY | 2013-04-01 13:35:00 | 13:35 | April | No
North East | SNS | 1 | 1245 | ELGIN/HUNTLY | 2013-04-01 13:35:00 | 13:35 | April | No
Highland | PP2 | 18 | 1246 | DINGWALL | 2013-04-01 18:28:00 | 18:28 | April | No
Argyll & West | PP1 | 16 | 1247 | OBAN | 2013-04-01 14:15:00 | 14:15 | April | No
North East | PP2 | 18 | 1248 | ABERDEEN | 2013-04-01 16:00:00 | 16:00 | April | No
Tayside & Central | PP3 | 36 | 1249 | DUNDEE | 2013-04-01 17:30:00 | 17:30 | April | No
Tayside & Central | PP4 | 36 | 1250 | DUNDEE | 2013-04-01 17:30:00 | 17:30 | April | Yes
Tayside & Central | PP2 | 36 | 1251 | DUNDEE | 2013-04-01 17:30:00 | 17:30 | April | No
Tayside & Central | PP1 | 36 | 1252 | DUNDEE | 2013-04-01 17:30:00 | 17:30 | April | No
Tayside & Central | PP2 | 18 | 1253 | DUNBLANE | 2013-04-01 17:10:00 | 17:10 | April | No
North East | PP4 | 1 | 1245 | ELGIN/HUNTLY | 2013-05-01 13:35:00 | 13:35 | May | No
Highland | PP2 | 18 | 1246 | DINGWALL | 2013-05-02 13:35:00 | 13:35 | May | No
Argyll & West | PP1 | 16 | 1247 | OBAN | 2013-05-03 13:35:00 | 13:35 | May | No
North East | PP2 | 18 | 1248 | ABERDEEN | 2013-05-04 13:35:00 | 13:35 | May | No
Tayside & Central | PP3 | 36 | 1249 | DUNDEE | 2013-05-05 13:35:00 | 13:35 | May | No
Tayside & Central | PP5 | 36 | 1250 | DUNDEE | 2013-05-06 13:35:00 | 13:35 | May | Yes
Tayside & Central | PP5 | 36 | 1251 | DUNDEE | 2013-05-07 13:35:00 | 13:35 | May | No
Tayside & Central | PP2 | 36 | 1252 | DUNDEE | 2013-05-08 13:35:00 | 13:35 | May | No
Tayside & Central | PP2 | 18 | 1253 | DUNBLANE | 2013-05-09 13:35:00 | 13:35 | May | No
Spreadsheet: 204933d1357682377-cell-result-is-based-on-the-drop-down-selected-sample
Sheet: Sheet1

 | Volume | Author
 | 1 | [NAME]
 | 5 | Eddie
1 | 2 | [NAME] |  | 1 | [NAME]
2 |  |  |  | 2 | [NAME]
3 |  |  |  | 3,4 | [NAME]
4 |  |  |  | 5 | Eddie
5
Spreadsheet: 141146d1329130054-problem-counting-text-in-excel-example
Sheet: Sheet5

Count of Sale | Sale
Name | No | Yes | Grand Total
Adam |  | 4 | 4
[NAME] |  | 4 | 4
[NAME] |  | 3 | 3
[NAME] | 1 | 4 | 5
[NAME] | 3 | 4 | 7
Sue | 1 | 2 | 3
[NAME] |  | 3 | 3
Grand Total | 5 | 24 | 29
Spreadsheet: 878585d1725686627-excel-sorts-hyperlink-display-name-but-not-the-hyperlinks-themselves-ohioruss-test-excel-4-sort-2013-aligw
Sheet: Sheet1

A | litvak | https://www.litvaksig.org
A | litvak | https://www.litvaksig.org
A | litvak | https://www.litvaksig.org
A | litvak | https://www.litvaksig.org
A | litvak | https://www.litvaksig.org
B | litvak | https://www.litvaksig.org
B | litvak | https://www.litvaksig.org
B | litvak | https://www.litvaksig.org
B | litvak | https://www.litvaksig.org
B | litvak | https://www.litvaksig.org
A | nytimes | https://nytimes.com
A | nytimes | https://nytimes.com
A | nytimes | https://nytimes.com
A | nytimes | https://nytimes.com
A | nytimes | https://nytimes.com
B | nytimes | https://nytimes.com
B | nytimes | https://nytimes.com
B | nytimes | https://nytimes.com
B | nytimes | https://nytimes.com
B | nytimes | https://nytimes.com
Spreadsheet: mary_fischer__25740__E-20R
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 20R
Enron Energy Services
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 12 MONTHS ENDED 12-31-2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 98 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | 0 |  |  |  | 0
Paid in Capital |  | 0910 |  | 0
Contribution Received from Parent |  | 0915 |  | 0
RE - Beg Bal |  | 0920 |  | 11955495
RE - Net Income |  | 0930 |  | -23510491.08
RE - Net Income (Fair Value Adjustment) |  | 0931 |  | 0
Dividends Decl - Preferred Stock |  | 0935 |  | 0
Dividends Decl - Common Stock |  | 0941 |  | 0
Invest in Subs Plug Account |  | 0942 |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215 |  | 0
Investment in PIC (contrib by parent) |  | 0216 |  | 0
Investment in Equity earnings of sub |  | 0217 |  | 1005553
Total Investment in Consol Sub |  |  |  | 1005553
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent) |  |  |  | -11955496.16
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: 13 Camping Support

13 | District/council camping support: Conduct camp promotion contacts to district troops and teams.
 |  | Complete contacts to at least 75% of units or 3% increase |  |  | [NAME] | 75
 |  | Complete contacts to at least 80% of units or 3% increase over 75% |  |  | Silver | 100
 |  | Complete contacts to at least 85% of units or 3% increase over 80% |  |  | Gold | 200
 | What constitutes an acceptable contact under this category is determined by the Scout Executive or the council’s camping committee if delegated by the Scout Executive.
 | Set the Goal | Who determined "acceptable contact"?  The Scout Executive or the council's camping committee?
 |  | When was the determination made?
 |  | How does the Scout Executive or council's camping committee define "acceptable contact" for purposes of this item?
 | [NAME]
 | Evaluate Success
 |  | How can the chapter better serve the district in promoting camping next year?
 | Plan for Next Year
Spreadsheet: 147676d1332924921-organizing-and-subtracting-lists-problemlists-2-
Sheet: Sheet1

 |  |  | helper 1 | helper 2 | formula in e2  is
 | a | 432 |  |  | =IF(ISERROR(MATCH($D$2:$D$13,$D$15:$D$26,0)),ROW(),"")
 | b | 423 |  |  | note arrays must be same size so  d2:d13 is same size as d15:d26 |  |  |  |  |  |  |  |  | list 1- organized list 2
 | a | 2
 | e | 6
 | d | 3
 | a | 2
 | d | 5
 | b | 76
 | e | 21
 | e | 1
 | a | 23
 | b | 34
 | a
 | a |  |  |  |  |  |  |  |  |  |  |  |  | organized list 2
 | a
 | d
 | d
 | e
Spreadsheet: 26144d1218052928-grouping-question-sample-grouping
Sheet: Sheet1

 | The sub-groups that I have setup for the light-blue and gray are perfect. I'd like the orange part to be easily hidden and unhidden.
 | Grouping columns wouldn't work because it would hide columns from the main report (such as P.O.# and PRICE). Any ideas?
 | LOT # | PART # | [NAME] | COLOR | SUPPLIER | DATE | PRICE | P.O. # | WEIGHT
 | 221 | 9879 | pbt unfilled r/g | BLACK | 12334-T | 2008-06-08 00:00:00 | 0.45 | 225 | 45300
 |  | B/P # | WEIGHT | [NAME] | COLOR | [NAME] | HIDDEN2 | HIDDEN3
 |  | 25 | 1454 | Row 6 | black | 0 | 0 | 0
 |  | 26 | 1452 | Row 6 | black | 0 | 0 | 0
 |  | 27 | 1555 | Row 6 | black | 0 | 0 | 0
 |  | 28 | 1539 | Row 6 | black | 0 | 0 | 0
 |  | 29 | 1544 | Row 6 | black | 0 | 0 | 0
 | 227 | 9777 | pbt unfilled r/g | white (go black) | 12334-T | 2008-06-08 00:00:00 | 0.45 | 225 | 45300
 |  | B/P # | WEIGHT | [NAME] | COLOR | [NAME] | HIDDEN2 | HIDDEN3
 |  | 9 | 1610 | Row 7 |  | 0 | 0 | 0
 |  | 22 | 1575 | Row 7 |  | 0 | 0 | 0
 |  | 26 | 1015 | Row 7 | black/white | 0 | 0 | 0
 |  | 28 | 795 | Row 7 | mix color | 0 | 0 | 0
 |  | 29 | 1590 | Row 7 | black/white | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -41815 | -41797
2 | -36544 | -36093
3 | -35547 | -35000
4 | -50308 | -49522
5 | -40937 | -42451
6 | -37277 | -37076
7 | -46378 | -45798
8 | -39077 | -41888
9 | -40231 | -45000
10 | -35607 | -37607
11 | -40133 | -39474
12 | -41999 | -41904
13 | -41383 | -40511
14 | -51938 | -49873
15 | -35328 | -34932
16 | -31944 | -31192
17 | -38883 | -37933
18 | -35984 | -35687
19 | -35851 | -34298
20 | -36616 | -35615
21 | -34999 | -35000
22 | -34709 | -33577
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 133095
2001-07-22 00:00:00
Spreadsheet: 740635d1626432918-how-you-link-a-drop-down-to-populate-information-from-other-sheets-quotation-type-of-fo-drawing-calc-1-
Sheet: Data

Anthracite | 1 | Ceramic Coating | Invoice | 0.05 | Not Won
Black | 2 | Composites | Quotation | 0.1 | Awaiting Start
Blue | 3 | Flocking |  | 0.15 | In Progress
High Gloss | 4 | Injector Diagnostics |  | 0.2 | [NAME]
Light Grey | 5 | Powdercoating |  | 0.25 | Completed
Red |  | Site Services |  | 0.3
 |  |  |  | 0.35
 |  |  |  | 0.4
 |  |  |  | 0.45
 |  |  |  | 0.5
 |  |  |  | 0.55
 |  |  |  | 0.6
 |  |  |  | 0.65
 |  |  |  | 0.7
 |  |  |  | 0.75
 |  |  |  | 0.8
 |  |  |  | 0.85
 |  |  |  | 0.9
 |  |  |  | 0.95
 |  |  |  | 1
Spreadsheet: 785750d1656675306-create-a-list-of-words-based-on-conditional-rule-oak-2122-56-termly-cew-analysis-sheet-updated
Sheet: Pupil Analysis

Jessica |  |  | Summer 2 Misspelled Word List
Term | Score
Autumn 1 2021 |  |  |  | Autumn 1 Misspelled Word List
Autumn 2 2021 |  |  |  | Autumn 2 Misspelled Word List
Spring 1 2022 |  |  |  | Spring 1 Misspelled Word List
Spring 2 2022 |  |  |  | Spring 2 Misspelled Word List
Summer 1 2022 |  |  |  | Summer 1 Misspelled Word List
Summer 2 2022 |  |  |  | Summer 2 Misspelled Word List
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Sear

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: eric_saibi__9698__Market briefs
Sheet: Sheet1

Market Brief | Wednesday, January 2 (Changes from 12/28)
Stocks | Close | Change | % Change
DJIA | 10073.4 | -63.59000000000015 | -0.006273065278746466
DJ 15 Util. | 297.74 | 3.240000000000009 | 0.0110016977928693
NASDAQ | 1979.25 | -8.019999999999982 | -0.004035687148701476
S&P 500 | 1148.08 | -12.93000000000006 | -0.01113685497971599
Market Vols | Close | Change | % Change
AMEX (000) | 130955 | 28748 | 0.2812723198998112
NASDAQ (000) | 1512183 | 189403 | 0.1431855637369782
NYSE (000) | 1179897 | 274803 | 0.303618187724148
Commodities | Close | Change | % Change
Crude Oil (Feb) | 21.1 | 0.6900000000000013 | 0.03380695737383642
Heating Oil (Jan) | 0.5507 | -0.01580000000000004 | -0.02789055604589592
Nat. Gas (Henry) | 2.555 | 0 | 0
Propane (Jan) | 32.6 | -1.4 | -0.04117647058823525
Palo Verde (Feb) | 24.75 | 0 | 0
COB (Feb) | 24.75 | 0 | 0
PJM (Feb) | 30 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.942 | -0.01700000000000013 | -0.008677896886166476
Canada $ | 1.598 | 0.005000000000000115 | 0.003138731952291347
Germany Dmark | 2.165 | -0.04800000000000004 | -0.02169001355625849
Euro | 0.9036 | 0.01989999999999992 | 0.02251895439628824
Japan ¥en | 132.2 | 1.199999999999989 | 0.009160305343511364
Mexico NP | 9.1 | -0.08000000000000007 | -0.008714596949891075
[NAME] | 0.6923 | 0.00230000000000008 | 0.003333333333333449
Foreign Indices | Close | Change | % Change
Arg MerVal | 323.69 | 28.3 | 0.09580554521141546
[NAME]. | 3383.1 | 19.29999999999973 | 0.005737558713359809
[NAME] | 13872.09 | 294.52 | 0.02169165763829613
Can TSE 300 | 7646.79 | -28.21 | -0.003675570032573295
Germany DAX | 5167.88 | 7.779999999999745 | 0.001507722718551917
[NAME] | 11350.85 | -80.73999999999978 | -0.007062884515627291
Japan Nikkei 225 | 10542.62 | 0 | 0
[NAME] | 6410.05 | 6371.84 | -0.008820041162253805
UK FTSE 100 | 5218.3 | 29.2 | 0.0056
Source:  Yahoo!, TradingDay.com and NYMEX.com
Spreadsheet: c6ab705f-6300-44ef-988e-c76bba4ec5a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-23 15:15:26.430000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.659 | 102.534 | 102.409 | 102.034
4.5 | 102.501 | 102.376 | 102.251 | 101.876 |  | Note: | Refer To Price [NAME]
4.375 | 101.867 | 101.742 | 101.617 | 101.242 |  |  | For all Price Adjs
4.25 | 101.261 | 101.136 | 101.011 | 100.386
4.125 | 100.414 | 100.289 | 100.164 | 99.539
4 | 99.412 | 99.287 | 99.162 | 98.537
3.875 | 98.369 | 98.244 | 98.119 | 97.494
3.75 | 97.494 | 97.369 | 97.244 | 96.619
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.483 | 102.358 | 102.233 | 101.858
3.625 | 102.089 | 101.964 | 101.839 | 101.464
3.5 | 101.536 | 101.411 | 101.286 | 100.911
3.375 | 100.817 | 100.692 | 100.567 | 100.192
3.25 | 100.18 | 100.055 | 99.93 | 99.305
3.125 | 99.744 | 99.619 | 99.494 | 98.869
3 | 98.994 | 98.869 | 98.744 | 98.119 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-07-07 15:15:26.430000
30 DAY | 2014-07-22 15:15:26.430000
45 DAY | 2014-08-06 15:15:26.430000
60 DAY | 2014-08-21 15:15:26.430000
90 DAY | 2014-09-20 15:15:26.430000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: darrell_schoolcraft__7232__saledoc01_6TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power LLC
Deal Date: |  |  | 2002-01-08 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/09/01 |  |  | FAX Number:
Total Quantity |  |  | 10133 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.09
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/09/02 | 2002-01-09 00:00:00 | 10133 |  | 10133 |  | 10133
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10133 |  | 27505 |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 04bbbcc9-c7b1-48fa-b5a9-7be635d16fa5
Sheet: Sheet1

Appendix table 4--Regional shares of operations with milk cows, selected years1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Region | 1975 | 1980 | 1985 | 1990 | 1995 | 1997 | 1998 | 1999 | 2000
 | Percent
Northeast | 14.10473163364216 | 16.29062182057574 | 18.04125627206839 | 18.8778158413786 | 19.77518436314169 | 20.79223928860145 | 21.52244410308926 | 21.94594594594595 | 22.22327790973872
Lake States | 22.31689997971191 | 24.38805434197139 | 26.94666418881248 | 29.066749714523 | 32.00400945084843 | 32.09377526273241 | 31.31933777095067 | 31.35135135135135 | 31.35391923990499
Corn Belt | 16.97436937850815 | 16.57789215392902 | 17.20869726816577 | 16.71338108585072 | 16.82537409608362 | 16.81487469684721 | 17.15309779825909 | 17.2972972972973 | 17.48218527315915
Northern Plains | 7.236085750997498 | 6.852594410198097 | 6.392863779966548 | 5.865254853109104 | 5.226605570272786 | 5.092966855295069 | 4.949650110940434 | 4.954954954954955 | 4.845605700712589
Appalachian | 15.64437230901017 | 12.77754503560955 | 10.74149786285077 | 9.083359285788434 | 7.875707023698718 | 7.679870654810024 | 7.765830346475508 | 7.567567567567568 | 7.410926365795724
Southeast | 4.26049908703591 | 3.890119097492369 | 2.601746887195688 | 2.647150420429773 | 1.976086489582587 | 1.980598221503638 | 1.945724526369688 | 1.801801801801802 | 1.786223277909739
Delta States | 5.522869186898402 | 4.039739062780537 | 2.936257201263706 | 2.906674971452299 | 2.577504116846853 | 2.303961196443007 | 2.218808670421573 | 2.117117117117117 | 2.07125890736342
Southern Plains | 5.184734338720949 | 5.296546771201149 | 4.757480022300688 | 4.723346828609987 | 4.582229541061072 | 4.607922392886015 | 4.522956135859362 | 4.324324324324325 | 4.180522565320665
Mountain | 5.157683550866753 | 5.655634687892752 | 5.705259245493402 | 5.071109726980173 | 4.439034867902914 | 4.284559417946645 | 4.266939750810718 | 4.333333333333334 | 4.342042755344418
Pacific | 3.597754784608102 | 4.231252618349393 | 4.66827727188255 | 5.04515727187792 | 4.646667143982244 | 4.349232012934519 | 4.33521078682369 | 4.306306306306306 | 4.304038004750594
United States | 100 | 100 | 100 | 100 | 100.0284026634209 | 100 | 100 | 100 | 100
1 Operations with one or more milk cows, excluding cows used to nurse calves, on hand any time during
the year.
Source:  Compiled by Economic Research Service from U.S. Department of Agriculture, National
Agricultural Statistics Service, Final Estimates, various years, except for 1998, 1999, and 2000.   Data for 1998,
1999, and 2000 are from Milk Production, February 2000 and 2001.
Spreadsheet: 164633d1340823800-counting-cells-with-multiple-conditions-sl-no-3-
Sheet: Sheet1

Normal Sl No | Status Confirmation |  | Req Sl No |  | Job | Job Phase | [NAME]
 |  |  |  |  |  | SS07950111 | Yes
 |  |  |  |  |  | SS07950112 | No
 |  |  |  |  |  | SS07960111 | Yes
 |  |  |  |  |  | SS07960112 | No
 |  |  |  |  |  | SS07960113 | No
 |  |  |  |  |  | SS07960114 | No
 |  |  |  |  |  | SS07970111 | Yes
 |  |  |  |  |  | SS07970112 | No
 |  |  |  |  |  | SS07990112 | No
 |  |  |  |  |  | SS07990113 | No
 |  |  |  |  |  | SS07990114 | No
 |  |  |  |  |  | SS07990115 | No
 |  |  |  |  | SS0780 | SS07990116 | No
Spreadsheet: sara_shackleton__36783__Allegheny Energy Supply_revised031401
Sheet: Master

POWER MASTER AGREEMENT INFORMATION SHEET
 |  | LEGAL CONTACT: | [NAME], x36389
DATE: |  | EPMI CONTACT: | [NAME]
COUNTERPARTY: | Allegheny Energy Supply Company, LLC | CONTACT: | [NAME]
ADDRESS: | Roseytown Road | TITLE: | Credit Risk Manager
 | RR12, Box 1000 | PHONE: | [PHONE]
 | Greensburg, PA 15601 | FAX: | [PHONE]
 |  | S&P RATING: | BBB+
ENTITY TYPE: | Delaware LLC | MOODY'S RATING: | Baa1
 |  | FITCH RATING:
TYPE OF AGREEMENT:
Bilateral (Purch & Sale) | X | Power Marketing
Unilateral - EPMI Purch only |  | Industrial Producer - EPMI Purch only
Unilateral - EPMI Sale only |  | SO2 Allowances
Transaction Specific
TRANSACTION TENOR LIMITS | open
COVER PROVISIONS
(Failure to Deliver/Receive) | X
STANDARD TRIGGER EVENTS
Non-Payment | X
Representations | X
Other Covenants | X
Bankruptcy | X
TERMS SPECIFIC TO: | COUNTERPARTY | EPMI
COLLATERAL THRESHOLD | see matrix on sheet 2 | see matrix on sheet 2
Applies to [NAME] to Market only
Applies to MTM and [NAME] | X | X
Collateral Multiple | 250000 | 250000
COLLATERAL THRESHOLD TYPE
In a form acceptable... |  |  | [NAME] also to be in a form
Cash | X | X | mutually acceptable to both parties.
US Treasuries |  |  | (this will enable us to negotiate other collateral
Letter of Credit | X | X | terms if needed.)
ADDITIONAL TRIGGER EVENTS
Cross Default 3rd Party Debt: |  | Enron Corp.
-Counterparty | 50000000
-Guarantor |  | 100000000
Material Adverse Change:
-Counterparty | X
-Guarantor |  | X
Non-Specific
-Bilateral
-Unilateral
Debt Ratings Change | X | X
-Below S&P or Moody's | BBB- or Baa3 | BBB- or Baa3 | Or is not rated by S&P or Moody's to apply to both
-Type of debt | Senior Unsecured | Senior Unsecured | CP and Enron Corp.
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth
-Fixed Charge Coverage
-Interest Coverage
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
Ownership Change
-Less than 51% owned by:
COLLATERAL TYPE
In a form and amount acceptable
to non-defaulting party | X | X
Other
GUARANTOR BREACH | X | X
GUARANTOR (RATING) | n/a | Enron Corp.  (BBB+)
$ LIMIT |  | 35000000 | amount to stay the same
Incorporation State: |  | OR
FINANCIAL STATEMENTS
-Counterparty | X
-Guarantor | X | X
-Parent
OTHER COMMENTS:
ENRON WILL AGREE TO THE CANCELLATION/TERMINATION OF THE ALLEGHENY ENERGY, INC. GUARANTY IN FAVOR OF EPMI.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | 3-0554