tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: shelley_corman__38710__INGAA Data Template
Sheet: TW Capacity Release

Location | Location | Location | Releasing Shipper | Releasing Shipper | Affil | [NAME] | Replacement Shipper | Replacement Shipper | Affil | Rep Shipper | Recallable | Capacity | Begin | Expiration
POI | DRN | Name | Name | ID (DUNS) | (Y/N) | Type | Name | ID (DUNS) | (Y/N) | Type | (Y/N) | (MDth/d) | Date | Date
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | ACN Power, Inc. | 059091384 | N | Marketer | N | 0.595 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Amoco Energy Trading Corporation | 625275755 | N | Marketer | N | 0.01 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Enron Energy Marketing Corp. | 941565582 | Y | Marketer | N |  | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Enron Energy Services, Inc. | 004328568 | Y | Marketer | N |  | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Enron Energy Services, Inc. | 004328568 | Y | Marketer | N |  | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Kimball Energy Corporation | 151561370 | N | Producer | N | 0.116 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Scana Energy Trading, LLC | 026169206 | N | Marketer | N | 0.073 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Scana Energy Trading, LLC | 026169206 | N | Marketer | N | 0.586 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Sempra Energy Solutions, LLC | 837545052 | N | Marketer | N | 1.651 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | TXU Energy Trading Company | 606252393 | N | Broker | N | 0.586 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | TXU Energy Trading Company | 606252393 | N | Broker | N | 0.492 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
10487 | 208 | Socal Needles | Southern California Gas Company | 006908826 | N | LDC | Unicom Energy, Inc. | 061416504 | N | Marketer | N | 2.71 | 2000-11-01 00:00:00 | 2000-11-30 00:00:00
 | - | Gallup Compressor Station | Citizens Utilities Company | 006918296 | N | LDC | Enron North America | 791182710 | Y | Broker | Y | 25 | 1998-11-01 00:00:00 | 2001-10-31 00:00:00
Spreadsheet: 65217d1265914874-if-statement-with-words-winning
Sheet: Sheet1

 |  | [NAME] | [NAME] | 100
 |  | [NAME] | [NAME] | 160
 |  | Greg | [NAME] | 140
 |  | [NAME] | Greg | 70
 |  | [NAME] |  | 130
 |  | [NAME] |  | 50
 |  | [NAME] |  | 80
 |  | Greg |  | 105
 |  | [NAME] |  | 70
 |  | [NAME] |  | 35
Spreadsheet: 648038d1572856011-column-search-with-various-formats-of-names-office-problem
Sheet: Example Sheet

Target to search ( each of the cell below) - Date format DD/MM/YY | Search against this Coloumn | Record 1D | Date
Tanya, Surname_25/12/18 | Names 1 |  | 2018-12-25 00:00:00
[NAME] | Names 2 Surname |  | 2012-12-11 00:00:00
Surname kenny_10/08/12 | Surname Name 3 |  | 2012-08-10 00:00:00
Surname, Thomas_12/06/19 | Name_Surname4 |  | 2018-04-12 00:00:00
[NAME] ven desol_12/04/18 | Tanya, Surname_25/12/18 |  | 2018-04-12 00:00:00
[NAME] | [NAME] Jones|_10/11/13 | Surname Name 4 |  | 2013-11-10 00:00:00
Vince_Surname | Surname Name 5 |  | 2016-06-15 00:00:00
[NAME] | Surname Name 6 |  | 2018-10-23 00:00:00
[NAME] | Surname Name 6 |  | 2016-10-13 00:00:00
 | [NAME]
 | [NAME] ven desol_12/04/18
 | Surname kenny_10/08/12
 | [NAME]
 | [NAME] ven desol_12/04/18
 | [NAME] | [NAME] Jones|_10/11/13
 | Vince_Surname
Spreadsheet: 23887d1213722760-multi-lookup-nms2130sampledata
Sheet: Sheet1

 | COLOR | CODE
NICK | RED | 98
TOM | RED | 98
[NAME] | BLUE | 78
[NAME] | BLUE | 78
JOE | RED | 98
MARK | BLUE | 78
MAX | GREEN | 28
JACK | GREEN | 28
DAN | RED | 98
HARRY | YELLOW | 58
 | RESULT
 | RED
 | NICK
 | TOM
 | JOE
 | DAN
Spreadsheet: 2b6a9f6d-5c41-43b1-a1c5-34009a4c38ac
Sheet: Sheet1

CWSP 2012- 2013 Budget Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Project Name:
Activity/ Expense | CWSP Funds | Matching Funds, Goods and Services | Source of Match | Comments | Totals
Materials and Supplies | $ | $ | (source)
Plants |  |  |  |  | 0
Mulch |  |  |  |  | 0
Rentals |  |  |  |  | 0
Tools |  |  |  |  | 0
Erosion Control |  |  |  |  | 0
[NAME] and Disposal |  |  |  |  | 0
Other (specify) |  |  |  |  | 0
Refreshments ($200 [NAME])
Work Party Snacks |  |  |  |  | 0
Staff/Professional Services | $3,000 maximum on services, fees, and compensation. Youth compensation may comprise some or all of the $3,000 Services, Fees, and Compensation Limit. An additional $2,000 beyond that limit may be spent on youth participant compensation.
Project Coordinator |  |  |  |  | 0
Contracted Services |  |  |  |  | 0
Administrative Fees |  |  |  |  | 0
Insurance |  |  |  |  | 0
Permits |  |  |  |  | 0
Other (specify) |  |  |  |  | 0
[NAME]
[NAME] |  |  |  |  | 0
Total for Grant Project | CWSP Total | Matching Total |  |  | Project Total
 | 0 | 0 |  |  | 0
Note: Suggested line items are provided here.  These may be amended for your particular project, but please retain the blue category labels. Total CWSP budget may not exceed $10,000.
Spreadsheet: 731919d1620674915-lookups-based-on-multiple-values-ppa-per-zip-pricing-chart-workbook
Sheet: Sheet2

Zip Code | Acreage Range | PPA
12345 | 0 | 35000
12345 | 2 | 20000
12345 | 8 | 12000
12345 | 20 | 6000
23456 | 0 | 100000
23456 | 1 | 40000
23456 | 10 | 25000
34567 | 0 | 60000
34567 | 0.5 | 30000
34567 | 7 | 23000
34567 | 50 | 15000
45678 | 0 | 80000
45678 | 1.5 | 50000
45678 | 10 | 35000
45678 | 25 | 10000
45678 | 70 | 8000
56789 | 0 | 15000
56789 | 5 | 75000
56789 | 30 | 3000
Spreadsheet: 114175d1309986274-summarizing-data-adding-codes
Sheet: Invoice

 |  |  |  |  |  | [NAME]
Code | Hour Type (click drop-down box for "Regular" or "OT 1-1/2") | Hours Worked | Billable Hourly Rate | Billable Amount |  | Code | Hours | Amount
000001 | Regular | 40 | 15 |  |  | 000001
000001 | OT 1-1/2 | 5 | 22.5 |  |  | 000003
000003 | Regular | 40 | 30 |  |  | 000004
000004 | Regular | 35 | 32
000003 | Regular | 35 | 32
000001 | Regular | 25 | 18
555555 | Regular | 30 | 10
666666 | Regular | 25 | 10
77777 | Regular | 33 | 20
Total Hours |  |  | Total Amount
 | Regular
 | OT 1-1/2
Spreadsheet: 266158d1379514600-count-of-inquiries-based-on-year-they-inquired-on-what-formula-inquiry-statistics
Sheet: Sheet1

Inquiry | Date of service |  |  | M / Y inquiry | Service same year | Service next year | Total inquiries
2013-01-23 00:00:00 | 2013-06-01 00:00:00 |  |  | 2013-01-01 00:00:00
2013-01-23 00:00:00 | 2013-06-01 00:00:00 |  |  | 2013-02-01 00:00:00
2013-01-23 00:00:00 | 2013-06-15 00:00:00 |  |  | 2013-03-01 00:00:00
2013-01-24 00:00:00 | 2013-08-03 00:00:00 |  |  | 2013-04-01 00:00:00
2013-01-24 00:00:00 | 2013-06-08 00:00:00 |  |  | 2013-05-01 00:00:00
2013-01-26 00:00:00 | 2014-06-07 00:00:00 |  |  | 2013-06-01 00:00:00
2013-01-27 00:00:00 | 2013-08-31 00:00:00 |  |  | 2013-07-01 00:00:00
2013-01-27 00:00:00 | 2013-09-28 00:00:00 |  |  | 2013-08-01 00:00:00
2013-01-28 00:00:00 | 2013-09-14 00:00:00
2013-01-28 00:00:00 | 2013-10-05 00:00:00
2013-02-04 00:00:00 | 2013-07-20 00:00:00
2013-02-07 00:00:00 | 2013-03-16 00:00:00
2013-02-13 00:00:00 | 2013-04-06 00:00:00
2013-02-13 00:00:00 | 2014-06-14 00:00:00
2013-02-16 00:00:00 | 2013-06-01 00:00:00
2013-02-16 00:00:00 | 2014-06-28 00:00:00
2013-02-18 00:00:00 | 2014-09-06 00:00:00
2013-02-19 00:00:00 | 2013-08-03 00:00:00
2013-02-23 00:00:00 | 2013-09-07 00:00:00
2013-02-24 00:00:00 | 2013-06-22 00:00:00
2013-02-28 00:00:00 | 2013-05-18 00:00:00
2013-03-03 00:00:00 | 2013-08-24 00:00:00
2013-03-05 00:00:00 | 2013-06-22 00:00:00
2013-03-06 00:00:00 | 2013-06-29 00:00:00
2013-03-06 00:00:00 | 2013-09-28 00:00:00
2013-03-07 00:00:00 | 2013-06-01 00:00:00
2013-03-10 00:00:00 | 2014-08-23 00:00:00
2013-03-12 00:00:00 | 2014-04-26 00:00:00
2013-03-16 00:00:00 | 2013-08-31 00:00:00
2013-03-18 00:00:00 | 2013-08-17 00:00:00
Spreadsheet: 77718d1278150883-collate-and-index-info-example2-adeassessor2
Sheet: Unit 2

Entry | Unit 2 Criteria 1 | Unit 2 Criteria 2 | Unit 2 Criteria 3 | Unit 2 Criteria 4 | Unit 2 Criteria 5
This is the summary sheet for Unit 2
Spreadsheet: 136793d1326825459-how-can-i-use-an-if-statement-to-calculate-a-cell-value-in-another-cell-test
Sheet: Sheet1

Test Sheet
SEQ # | BADGE # | BADGE TYPE | LAST NAME | FIRST NAME | ADDRESS | CITY | STATE | ZIP | Example
1 | 21 | A | Smith | [NAME] | Any | Any | NE | 13654 | 1A | IF C8=S then I want 1 in J8 |  |  | IF C8=A then I want 1A in J8
2 | 25 | S | Doe | [NAME] | Any | Any | MN | 31654 | 1 | IF C9=S then I want 2 in J9 |  |  | IFC9=A then I want 2A in J9
3 | 69 | S | [NAME] | [NAME] | Any | Any | KS | 32183 | 2
4 | 88 | A | [NAME] | Juan | Any | Any | MO | 53254 | 2A
5 | 65 | A | Ericsson | [NAME] | Any | Any | IL | 56946 | 3A
6 | 37 | S | Brandl | [NAME] | Any | Any | AK | 68465 | 3
7 | 22 | A | Oswalt | [NAME] | Any | Any | AR | 39482 | 4A
Spreadsheet: 1ee0fff0-d959-43df-a9f4-573da7defc79
Sheet: Sheet1

Sex Offense Offenders | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Sexual Assault with an Object
Sex and Race
by Age, 2011
Age | Total Offenders1 | Sex |  |  | Race
 |  | Male | Female | Unknown | White | Black | American Indian/ Alaskan Native | Asian/Pacific Islander | Unknown
Total | 2855 | 2524 | 282 | 49 | 2114 | 558 | 11 | 17 | 155
15 and under | 387 | 318 | 69 | 0 | 283 | 83 | 2 | 2 | 17
16 – 20 | 470 | 422 | 47 | 1 | 338 | 114 | 1 | 2 | 15
21 – 25 | 331 | 300 | 30 | 1 | 242 | 81 | 2 | 1 | 5
26 – 30 | 326 | 297 | 29 | 0 | 257 | 58 | 1 | 0 | 10
31 – 35 | 263 | 241 | 22 | 0 | 215 | 41 | 0 | 2 | 5
36 – 40 | 247 | 221 | 26 | 0 | 199 | 39 | 2 | 3 | 4
41 – 45 | 184 | 171 | 13 | 0 | 150 | 30 | 1 | 1 | 2
46 – 50 | 144 | 132 | 11 | 1 | 111 | 24 | 0 | 5 | 4
51 – 55 | 107 | 101 | 6 | 0 | 84 | 21 | 1 | 0 | 1
56 – 60 | 66 | 62 | 4 | 0 | 54 | 9 | 0 | 0 | 3
61 – 65 | 50 | 48 | 2 | 0 | 41 | 6 | 1 | 0 | 2
66 and over | 58 | 57 | 1 | 0 | 55 | 3 | 0 | 0 | 0
Unknown Age | 222 | 154 | 22 | 46 | 85 | 49 | 0 | 1 | 87
1Does not include 181 incidents with Unknown Offenders.
Spreadsheet: 84529d1284577184-delete-rows-without-the-highest-value-sample
Sheet: Sheet1

Patient ID | Score | Region | Date | PID | PICUD
90409673 | 1 | 6 | 2009-07-21 00:00:00 | 14 | 73
 | 3 | 5
 | 2 | 5
 | 2 | 3
 | 2 | 5
 | 2 | 5
90408832 | 1 | 6 | 2009-07-04 00:00:00 | 12 | 44
 | 2 | 1
 | 1 | 6
 | 2 | 3
 | 2 | 4
90409269 | 2 | 1 | 2009-07-13 00:00:00 | 34 | 25
 | 3 | 1
 | 4 | 3
 | 3 | 3
 | 3 | 4
 | 2 | 5
 | 2 | 5
 | 3 | 5
 | 2 | 5
 | 1 | 6
 | 1 | 6
90409152 | 1 | 6 | 2009-07-11 00:00:00 | 38 | 29
 | 5 | 1
 | 2 | 5
 | 2 | 2
 | 3 | 3
 | 2 | 5
 | 1 | 6
 | 2 | 5
 | 2 | 5
 | 2 | 5
90408956 | 2 | 5 | 2009-07-05 00:00:00 | 16 | 50
 | 4 | 5
90409699 | 1 | 6 | 2009-07-21 00:00:00 | 21 | 23
 | 1 | 6
 | 4 | 1
 | 3 | 1
 | 1 | 5
 | 2 | 5
90409665 | 1 | 6 | 2009-07-21 00:00:00 | 10 | 81
 | 3 | 1
 | 3 | 1
90410028 |  |  | 2009-08-05 00:00:00 | 0 | 20
90411919 | 1 | 6 | 2009-08-05 00:00:00 | 1 | 42
90410051 | 1 | 6 | 2009-08-05 00:00:00 | 1 | 37
90408295 |  |  | 2009-06-26 00:00:00 | 0 | 51
90407065 |  |  | 2009-06-26 00:00:00 | 0 | 44
90407800 |  |  | 2009-06-15 00:00:00 | 0 | 25
Spreadsheet: 134654d1325548003-userform-rate1
Sheet: Sheet1

 | A80A | PPSP | [NAME] | SEMI | MTHLY
Attained Age Under 65 | 2978.92 | 256.6807036 | 782.9665 | 1535.1438 | 274.0699422495188
65 | 1179.48 | 102.2347684 | 310.6135 | 608.4322000000001 | 109.119900999175
66 | 1222.57 | 105.9331831 | 321.924625 | 630.62355 | 113.0698505820882
67 | 1275.04 | 110.4366832 | 335.698 | 657.6456 | 117.8796406636722
68 | 1329.26 | 115.0903858 | 349.93075 | 685.5689 | 122.8498487487396
69 | 1384.9 | 119.865967 | 364.53625 | 714.2235000000001 | 127.9502245852049
70 | 1442.17 | 124.7814511 | 379.569625 | 743.7175500000001 | 133.2000183334861
71 | 1501.3 | 129.856579 | 395.09125 | 774.1695 | 138.6203135026125
72 | 1562.06 | 135.0716098 | 411.04075 | 805.4609 | 144.1900265835548
Spreadsheet: 764256d1642666858-get-frequency-and-ignor-last-8-entires-index-frequency-aligw
Sheet: Sheet1

Numbers |  |  |  |  | [NAME]
1
1
2
2
3
3
3
18
3
2
2
14
14
14 |  | Always Exclude last 8 rows
14
2
2
1
18
Spreadsheet: 584974d1533561123-formula-that-counts-characters-in-multiple-cells-and-returns-only-the-wrong-cells-qqq
Sheet: em

Functional Location | title 1 | characteristic 1 | title 2 | characteristic 2 | title 2 | characteristic 2 | ERRORS |  | t1 | c1 | t2 | c2 | t3 | c3
Turbine_engine | input | 12V | ac/dc | 161KV | high | 35F | title 1= -1 , title 2= -1 , characteristic 2= -1
Turbine_liquid | output | ABCD/6V | ac | 40db | low | 3F | title 1= -2 , characteristic 1= -3
Turbine_blower | current | Z/5A | dc | E1KIRUR | medium | 15F-25F | title 1= -3 characteristic 2= -3 title 3= -2 , characteristic 3= -3
and so on…
 |  |  |  |  |  |  | The number of characters allowed in each cell is up to 4 (inclusive). Any number above is considered an ERROR and should be displayed in the header table of errors. |  |  |  | Reference Table.
 |  |  |  |  |  |  | Notes: * Show only errors * Display the number of incorrect characters
 |  |  |  |  |  |  | For example:
 |  |  |  |  |  |  | B2 = "input" = 5 characters and the [NAME] characters that allowed are 4, therefore it will display -1.
 |  |  |  |  |  |  | G4 = "15F-25F" = 7 characters and the [NAME] characters that allowed are 4, therefore it will display -3.
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: netLibrary

NetLibrary
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | Price for 2005-2006 | Price per search
NetLibrary
Accesses | 25 | 15 | 85 | 116 | 172 | 97 | 58 | 116 | 121 | 134 | 76 | 74 |  | 0 | N/A
Turnaways | 7 | 15 | 140 | 8 | 52 | 22 | 4 | 31 | 10 | 3 | 8 | 2
Note: We have 4,478 shared titles
Spreadsheet: 90405d1290120885-excel-2007-vlookup-in-multiple-sheets-vlookupproblem-1
Sheet: Sheet6

ITEM | QTY | TOTAL PIECES |  | ITEM | QTY | TOTAL PIECES
A1 | 3 | 181.5 |  | B4 | 2 | 302.5
A6 | 3 | 551.25 |  | B9 | 4 | 1050
A4 | 2 | 170 |  | B6 | 1 | 119
B4 | 2 | 302.5 |  | B5 | 3 | 198
B9 | 4 | 1050 |  | C4 | 3 | 453.75
B6 | 1 | 119 |  | C7 | 4 | 840
B5 | 3 | 198 |  | C5 | 1 | 102
C4 | 3 | 453.75 |  | C1 | 1 | 22
C7 | 4 | 840 |  | C10 | 3 | 33
C5 | 1 | 102 |  | D1 | 9 | 544.5
C1 | 1 | 22 |  | D3 | 5 | 525
C10 | 3 | 33 |  | D2 | 6 | 306
D1 | 9 | 544.5 |  | D6 | 7 | 539
D3 | 5 | 525
D2 | 6 | 306
D6 | 7 | 539
Spreadsheet: 691356d1597659431-trouble-combining-nested-if-and-or-function-excel-query
Sheet: EXCEL QUERY

Activity Reference | Activity Name | Resourced Activity Type Name | Assignment: Account Name | Start Date | Forecast P1 End Date | Probability Code | Forecast P3 Usage | Total Actual Usage | Remaining Usage | Scheduled Time (h) | Resource Type: Is Generic | Resource Type: Has Members | Activity Business Unit | Delivery Stage | Forecast Status | Resource Name | Resource Type | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
DYN-00000138.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-07-01 00:00:00 | 2020-09-04 00:00:00 | Firm | 5 | 0 | 5 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 1
DYN-00000114.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | Firm | 1 | 0 | 1 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 2
DYN-00000140.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | Firm | 1 | 0 | 1 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 4
DYN-00000102.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-06-29 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 5
DYN-00000142.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-06-29 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 20
DYN-00000021.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 19
DYN-00000144.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-06-29 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 1
DYN-00000140.03 | CUSTOMER NAME1 | Delivery Element | ACTIVITY | 2020-07-06 00:00:00 | 2021-01-29 00:00:00 | Firm | 12 | 0 | 12 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 2
DYN00001.03 | [NAME] | Delivery Element | ACTIVITY | 2020-08-10 00:00:00 | 2020-10-16 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 4
DYN00001 | [NAME] | Delivery Element | ACTIVITY | 2020-06-29 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 5
DYN00001.04.03 | CUSTOMER NAME3 | Delivery Element | ACTIVITY | 2020-06-29 00:00:00 | 2020-12-31 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 20
DYN00001.04.03 | CUSTOMER NAME3 | Delivery Element | ACTIVITY | 2020-08-10 00:00:00 | 2020-10-26 00:00:00 | Firm | 0 | 0 | 0 | 0 | 1 | 0 | EXAMPLE BU | Live | Closed Won 100% | Resource 19
Spreadsheet: louise_kitchen__23957__Activity for 10 29 01
Sheet: Sheet1

ENRON CORP - UNITED STATES
Counterparty Activity for 10/29/01
/- - - - - - - - - - - - - - -  TRADING   - - - - - - - - - - - - - - -/ |  | /- - - - - - -  10/30 CASH ACTIVITY   - - - - - - -/ |  |  | /- - - - - - - - - -  10/30 L/C ACTIVITY   - - - - - - - - - -/
COUNTERPARTIES WHO HAVE CUT OFF TRADING |  | OUTGOING CASH |  |  | OUTGOING LETTERS OF CREDIT
AEP |  | Sempra Energy Trading Corp |  |  | Sempra Energy Trading Corp | -8000000
Bank of Montreal |  | exchange L/C for cash | -50000000
Chase - Equity Trades Only |  | margin | -6500000
Citibank |  | Total Sempra Energy Trading Corp.
[NAME]
Coral - Real Time Power Only |  | Mahonia | -28000000
Equiva |  | AEP Energy Services, Inc. | -19750000
Goldman Sachs |  | Reliant | -8000000
[NAME] - won't ring out trades |  | Louis Dreyfus Corporation | -7400000
Phibro |  | New Power | -6000000
TransAlta |  | Duke | -5100000
TransCanada |  | PMI Trading LTD | -4500000
Wisconsin Gas |  | Deutsche Bank | -2500000
 |  | El Paso | -1300000
COUNTERPARTIES WHO HAVE CALLED WITH CONCERNS |  | PSEG | -700000
Avista |  | Cinergy Marketing & Trading, LLC | -250000
BP - wants Master Netting Agreement in US |  | Cornerstone Propane, L.P. | -250000
Cargill - wants reduction of ISDA lines
Cinergy - did not pay margin of $2.25MM on 10/29 as confirmed |  | TOTAL CASH OUTGOING FOR 10/30 |  |  | TOTAL OUTGOING L/Cs
ConAgra - crude ring trades or L/C; wants early pymt of OCT crude
Coral Energy
Deutsche Bank |  | INCOMING CASH |  |  | INCOMING LETTERS OF CREDIT
[NAME] - will cut off without $6MM L/C |  | Mirant | 19000000 |  | J [NAME] - reduction of existing L/C | 18500000
Dominion Resources |  | Duke | 12750000 |  | Mirant - cancelled | 55000000
DTE |  | El Paso | 8750000
[NAME] dependent |  | [NAME] | 7500000
FPL - wants Master Netting Agreement |  | BP Capital Energy Fund LP | 7250000
[NAME] - wants ISDA, Master Netting, & Novation; did not pay $5.5MM margin 10/26 OR $2MM 10/29 |  | [NAME] | 1750000
[NAME] |  | Merrill Lynch Capital | 400000
[NAME] |  | Vitol Capital | 350000
Mirant
Morgan Stanley - limit lowered from $15MM to $10MM |  | TOTAL CASH INCOMING FOR 10/30 |  |  | TOTAL INCOMING L/Cs
Natural Gas Exchange (Canada) - buy physical
NRG Power Trading |  | NET OUTGOING CASH FOR 10/30
NYMEX
Pacificorp
SEMPRA - closing out positions; wants contract in UK; working ring trades
Tractabel
XCEL Energy - wants ECC added to guaranty
 |  | MONDAY, 10/29 CASH SUMMARY
 |  | OUTGOING TOTAL | -197540000
 |  | INCOMING TOTAL | 135050000
COUNTERPARTIES "GOOD" WITH ENRON |  | NET TOTAL
Constellation
Duke - 2 Master Firm Agreements, ECC Assignments, & Collateral Agreements
Dynegy - wants Guaranty & Master Netting
Engage
Entergy-Koch
PG&E
Powerex
Reliant
TXU
[NAME]
RISK REDUCING TRADES ONLY
[NAME]
[NAME]
MORE INFORMATION REQUESTED
Citibank
Harvard
Spreadsheet: 48797d1248103819-need-to-delete-gaps-in-cells-postcodes-radio-stations
Sheet: Metro

Area: Radio Station - Metro Radio
Postcode
DH 1 1
DH 1 2
DH 1 3
DH 1 4
DH 1 5
DH 2 1
DH 2 2
DH 2 3
DH 3 1
DH 3 2
DH 3 3
DH 3 4
DH 4 4
DH 4 5
DH 4 6
DH 4 7
DH 5 0
DH 5 8
DH 5 9
DH 6 1
DH 6 2
DH 6 3
DH 6 4
DH 6 5
DH 7 0
DH 7 6
DH 7 7
DH 7 9
DH 8 0
DH 8 5
DH 8 6
DH 8 7
DH 8 8
DH 8 9
DH 9 0
DH 9 6
DH 9 7
DH 9 8
DH 9 9
DL 13 4
DL 16 6
DL 16 7
NE 1 1
NE 1 2
NE 1 3
NE 1 4
NE 1 5
NE 1 6
NE 1 7
NE 1 8
NE 2 1
NE 2 2
NE 2 3
NE 2 4
NE 3 1
NE 3 2
NE 3 3
NE 3 4
NE 3 5
NE 4 5
NE 4 6
NE 4 7
NE 4 8
NE 4 9
NE 5 1
NE 5 2
NE 5 3
NE 5 4
NE 5 5
NE 6 1
NE 6 2
NE 6 3
NE 6 4
NE 6 5
NE 7 7
NE 8 1
NE 8 2
NE 8 3
NE 8 4
NE 9 5
NE 9 6
NE 9 7
NE 10 0
NE 10 8
NE 10 9
NE 11 0
NE 11 9
NE 12 5
NE 12 6
NE 12 7
NE 12 8
NE 12 9
NE 13 6
NE 13 7
NE 13 8
NE 13 9
NE 15 0
NE 15 6
NE 15 7
NE 15 8
NE 15 9
NE 16 3
NE 16 4
NE 16 5
NE 16 6
NE 17 7
NE 18 0
NE 19 2
NE 20 0
NE 20 9
NE 21 4
NE 21 5
NE 21 6
NE 22 5
NE 22 6
NE 22 7
NE 23 1
NE 23 2
NE 23 3
NE 23 6
NE 23 7
NE 23 8
NE 24 1
NE 24 2
NE 24 3
NE 24 4
NE 24 5
NE 25 0
NE 25 8
NE 25 9
NE 26 1
NE 26 2
NE 26 3
NE 26 4
NE 27 0
NE 28 0
NE 28 6
NE 28 7
NE 28 8
NE 28 9
NE 29 0
NE 29 6
NE 29 7
NE 29 8
NE 29 9
NE 30 1
NE 30 2
NE 30 3
NE 30 4
NE 31 1
NE 31 2
NE 32 3
NE 32 4
NE 32 5
NE 33 1
NE 33 2
NE 33 3
NE 33 4
NE 33 5
NE 34 0
NE 34 6
NE 34 7
NE 34 8
NE 34 9
NE 35 9
NE 36 0
NE 37 1
NE 37 2
NE 37 3
NE 38 0
NE 38 7
NE 38 8
NE 38 9
NE 39 1
NE 39 2
NE 40 3
NE 40 4
NE 41 8
NE 42 5
NE 42 6
NE 43 7
NE 44 6
NE 45 5
NE 46 1
NE 46 2
NE 46 3
NE 46 4
NE 47 0
NE 47 5
NE 47 6
NE 61 1
NE 61 2
NE 61 3
NE 61 4
NE 61 5
NE 61 6
NE 62 5
NE 63 0
NE 63 8
NE 63 9
NE 64 6
NE 65 0
NE 65 7
NE 65 8
NE 65 9
NE 66 1
NE 66 2
NE 66 3
NE 66 4
NE 66 5
NE 67 5
NE 68 7
SR 1 1
SR 1 2
SR 1 3
SR 2 0
SR 2 7
SR 2 8
SR 2 9
SR 3 1
SR 3 2
SR 3 3
SR 3 4
SR 4 0
SR 4 6
SR 4 7
SR 4 8
SR 4 9
SR 5 1
SR 5 2
SR 5 3
SR 5 4
SR 5 5
SR 6 0
SR 6 7
SR 6 8
SR 6 9
SR 7 0
SR 7 7
SR 7 8
SR 7 9
SR 8 1
SR 8 2
SR 8 3
SR 8 4
SR 8 5
Households & Population: 2001 Census, Small Area Statistics (Crown Copyright)