tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5966cdf1-8509-42b7-b733-96d40d5f11e0
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: |  |  | 2013-07-25 15:17:43.410000
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.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 101.591 | 101.466 | 101.341 | 100.966
4.5 | 100.765 | 100.64 | 100.515 | 100.14 |  | Note: | Refer To Price [NAME]
4.375 | 99.896 | 99.771 | 99.646 | 99.271 |  |  | For all Price Adjs
4.25 | 99.338 | 99.213 | 99.088 | 98.463
4.125 | 98.603 | 98.478 | 98.353 | 97.728
4 | 97.694 | 97.569 | 97.444 | 96.819
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.925 | 101.8 | 101.675 | 101.3
3.75 | 101.338 | 101.213 | 101.088 | 100.713
3.625 | 101.001 | 100.876 | 100.751 | 100.376
3.5 | 100.512 | 100.387 | 100.262 | 99.637
3.375 | 99.768 | 99.643 | 99.518 | 98.893
3.25 | 99.046 | 98.921 | 98.796 | 98.171 |  | Minimum loan amount:
3.125 | 98.149 | 98.024 | 97.899 | 97.274 |  | 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 | 2013-08-08 15:17:43.410000
30 DAY | 2013-08-23 15:17:43.410000
45 DAY | 2013-09-07 15:17:43.410000
60 DAY | 2013-09-22 15:17:43.410000
90 DAY | 2013-10-22 15:17:43.410000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 763529d1642226081-sumifs-index-match-formula-not-working-formula-formating-help
Sheet: Formula

 |  | Year
 |  | Month
 |  | Volume
 | PAINT D | Dollar
 |  | Volume
 |  | Dollar |  |  |  | I want to add Cell C2 as a criteria when looking up in cell A6:A10 of Dollar tab - It's not working for me!!!!
Spreadsheet: 92538d1292096854-comparing-item-numbers-in-2-price-lists-sample-2011
Sheet: Sheet1

Our item number | Suppliers item number | Price
 | TJE16700 | 23.8
 | TJE16701 | 23.8
 | TJE16702 | 32.1
 | TJE16710 | 23.8
 | TJE16711 | 23.8
 | TJE16715 | 23.8
 | TJE16716 | 23.8
 | TJE16735 | 23.8
 | TJE16736 | 23.8
 | TJE16760 | 23.8
Spreadsheet: 770051d1645794350-dropdown-list-from-multiple-sheets-example-3-
Sheet: Summary2

[NAME]
Quarterly Financials Summary File
Period | Q1 2021
Updated per: | 31/12/2021 | Revenues | Gross Income | EBITDA | Cash & Cash Equivalents
 | Company 1
 | Company 2
 | Company 3
 | Company 4
 | Company 5
 | Company 6
 | Company 7
 | Company 8
 | Company 9
 | Company 10
 | Company 11
 | Company 12
Q1 2021
Q2 2021
Q3 2021
Q4 2021
FY 2021
Q1 2022
Q2 2022
Q3 2022
[NAME]
FY 2022
Q1 2023
Q2 2023
Q3 2023
Q4 2023
FY 2023
Spreadsheet: 61917d1262815623-total-for-similiar-dates-date-example
Sheet: ATL

2009-04-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-04-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-04-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-04-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -79
2009-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -223.17
2009-04-16 00:00:00
2009-04-27 00:00:00
2009-04-28 00:00:00
2009-04-29 00:00:00
2009-05-01 00:00:00
2009-05-02 00:00:00
2009-05-03 00:00:00
2009-05-04 00:00:00
2009-05-05 00:00:00
2009-05-15 00:00:00
2009-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 401.47
2009-05-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 86.5
2009-05-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -91
2009-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -141
2009-05-21 00:00:00
2009-05-22 00:00:00
2009-05-23 00:00:00
2009-05-24 00:00:00
2009-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -282
2009-06-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -716
2009-06-05 00:00:00
2009-06-06 00:00:00
2009-06-07 00:00:00
2009-06-08 00:00:00
2009-06-09 00:00:00
2009-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2496
2009-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -83.5
2009-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -133.5
2009-06-23 00:00:00
2009-06-24 00:00:00
2009-06-25 00:00:00
2009-06-26 00:00:00
2009-06-27 00:00:00
2009-06-28 00:00:00
2009-06-30 00:00:00
2009-07-01 00:00:00
2009-07-02 00:00:00
2009-07-16 00:00:00
2009-07-17 00:00:00
2009-07-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -272.34
2009-07-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -539.69
2009-07-20 00:00:00
2009-07-21 00:00:00
2009-07-22 00:00:00
2009-07-23 00:00:00
2009-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -1866.67
2009-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2946.05
2009-08-02 00:00:00
2009-08-11 00:00:00
2009-08-12 00:00:00
2009-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -63.5
2009-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 122.09
2009-08-16 00:00:00
2009-08-17 00:00:00
2009-08-21 00:00:00
2009-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 50
2009-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 50
2009-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -125
2009-08-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 247.5
2009-08-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 50
2009-09-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 87
2009-09-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 135.5
2009-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 88
2009-09-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | -50
2009-09-16 00:00:00
2009-09-17 00:00:00
2009-09-18 00:00:00
2009-09-19 00:00:00
2009-09-20 00:00:00
2009-09-28 00:00:00
2009-09-29 00:00:00
2009-09-30 00:00:00
2009-10-01 00:00:00
2009-10-02 00:00:00
2009-10-03 00:00:00
2009-10-04 00:00:00
Spreadsheet: 813586d1673869642-calculate-in-a-dynamic-table-number-of-occurrences-each-cell-calculate_occurences
Sheet: Feuil1

 | initial table
 |  | B |  |  |  |  |  | D |  |  | AZ |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  |  | D |  |  | AZ |  | FF
 | A | C |  |  |  |  |  | D |  |  | AZ |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C |  |  |  |  |  | D |  |  | AZ |  | FF
 | A | B |  |  |  |  | A | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | RE |  | FF
 | A | C |  |  |  |  |  | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | C |  |  |  |  |  | D |  |  | RE |  | FF
 | A | B |  |  |  |  | A | D |  |  | RE |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | RE |  | FF
 | A | B |  |  |  |  | A | D |  |  | TU |  | FF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B |  |  |  |  | A | D |  |  | TU |  | FF
 | expected result
 | 6 | 4 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 1 |  | 6
 | fluff - with COUNTIFS
 |  | 4 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 1 |  | 6
 | glenn
 |  | 6 |  |  |  |  |  | 6 |  |  | 6 |  | 6
 | 6 | 6 |  |  |  |  |  | 6 |  |  | 6 |  | 6
 | 6 | 6 |  |  |  |  | 6 | 6 |  |  | 6 |  | 6
 | 6 | 6 |  |  |  |  |  | 6 |  |  | 6 |  | 6
 | 6 | 6 |  |  |  |  | 6 | 6 |  |  | 6 |  | 6
 | 6 | 6 |  |  |  |  | 6 | 6 |  |  | 6 |  | 6
 | proposal without COUNTIF/COUNTIFS
 |  | 4 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 2 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 2 |  |  |  |  |  | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 3 |  | 6
 | 6 | 4 |  |  |  |  | 3 | 6 |  |  | 1 |  | 6
Spreadsheet: 07941fda-b4d8-4eb3-982d-bd005c775ab0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 13. LENDING FINANCE SEASONAL FACTORS, BY PURPOSE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial finance for fixed loan facilities ; |  |  | Original | A2433160J | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Commercial finance for revolving credit facilities ; |  |  | Original | A2433161K | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Total lease finance commitments ; |  |  | Original | A2433163R | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Personal finance for fixed loan facilities ; |  |  | Original | A2433157V | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Personal finance for revolving credit facilities ; |  |  | Original | A2433158W | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Investment housing, Construction of dwellings for rent and resale ; |  |  | Original | A2434908R | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by individuals ; |  |  | Original | A2434909T | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by others ; |  |  | Original | A2434910A | 1985-01-01 00:00:00 | 2013-10-01 00:00:00 | 346 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 96024d1295505047-simplifying-gap-and-repetitive-items-analysis-inputerrors
Sheet: Sheet1

PO Number | [NAME] | Supplier Invoice Number | Invoice Text
PO18294 | ABC | 18930 | 18930 |  | Pivot Table of your data to the left.  Does this help?
PO18294 | ABC | 18930-1 | 18930-1
PO18295 | ABC | 19874 | 19874 |  | [NAME] | PO Number | Invoice Text
PO18298 | ABC | 198_74 | 198_74 |  | ABC | PO18294 | 18930
PO18303 | ABC | 19955 | 19955 |  |  |  | 18930-1
PO18297 | LMN | GK5520 | GK5520 |  |  | PO18295 | 19874
PO18304 | LMN | GK5522 | GK5522 |  |  | PO18298 | 198_74
PO18304 | LMN | GK5577 | GK5577 |  |  | PO18303 | 19955
PO18839 | LMN | GK5580 | GK5580 |  | LMN | PO18297 | GK5520
PO19834 | LMN | GK5524 | GK5524 |  |  | PO18304 | GK5522
PO18299 | PQR | TK4120 | TK4120 |  |  |  | GK5577
PO18300 | PQR | TK4121 | TK4121 |  |  | PO18839 | GK5580
PO183001 | PQR | TK5001 | TK5001 |  |  | PO19834 | GK5524
PO18296 | XYZ | 295 | 295 |  | PQR | PO18299 | TK4120
PO19836 | XYZ | 297 | 297 |  |  | PO18300 | TK4121
PO19838 | XYZ | 298 | 298 |  |  | PO183001 | TK5001
 |  |  |  |  | XYZ | PO18296 | 295
 |  |  |  |  |  | PO19836 | 297
 |  |  | I made all you invoice |  |  | PO19838 | 298
 |  |  | numbers Text See Above |  | Grand Total
 |  |  | So they would group and
 |  |  | look better in the |  | The Pivot table above doesn't have values.  It simply
 |  |  | Pivot Table. |  | Sorts and groups.  See if this helps on your large
 |  |  |  |  | dataset.
Spreadsheet: fe3511a0-452f-4813-a37a-3cb56cc16fac
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MBL | Test | MBL | Mannose-Binding Lectin, Serum | Mannose-Binding Lectin, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.4 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | > or =7.8 ng/mL This reference range applies only to adults. See Cautions for further information regarding the reference range and clinical interpretation. | Tuesday; 9 a.m. | 1 day | 8 days | 1 | 83520 |  |  |  |  | Rochester
MBL | [NAME] | SERUM | Serum |  |  |  | Frozen | 7 days
MBL | Result | MANBL | Mannose-Binding Lectin, S | Mannose-Binding Lectin, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 30152-3 | Mannose-binding protein:MCnc:Pt:Ser:Qn:
Spreadsheet: 837932d1690537647-help-formula-with-dropdown-list-combobox-dummy-data-5-aligw
Sheet: data

Month | Region | Branch | Model | OS | SI | ST | CI
Apr | North | CHA | DMC-FZ2500GA | 2 | 2 | 2 | 1
Apr | North | DEL | DC-FZ10002GW | 2 | 2 | 2 | 1
Apr | North | GUR | DC-S1HGW-K | 1 | 1 | 1 | 1
Apr | North | JAI | DC-S5KGW-K | 1 | 1 | 1 | 1
Apr | North | DEL | DC-S5GW-K | 1 | 1 | 1 | 1
Apr | South | BAN | DC-S5M2WGW | 1 | 1 | 1 | 1
Apr | South | COI | DC-S5M2KGW | 2 | 2 | 2 | 1
Apr | South | CHE | DC-S5M2GW | 2 | 2 | 2 | 28
Apr | South | COC | DC-S5M2XWGW | 2 | 1 | 1 | 12
May | South | HYD | DMC-FZ2500GA | 2 | 2 | 2 | 1
May | South | VIJ | DC-FZ10002GW | 2 | 2 | 2 | 1
May | East | BHU | DC-S1HGW-K | 1 | 1 | 1 | 1
May | East | GUW | DC-S5KGW-K | 1 | 1 | 1 | 1
May | East | KOL | DC-S5GW-K | 1 | 1 | 1 | 1
May | East | PAT | DC-S5M2WGW | 1 | 1 | 1 | 1
May | East | RAN | DC-S5M2KGW | 2 | 2 | 2 | 1
May | North | DEL | DC-S5M2GW | 2 | 2 | 2 | 28
May | North | DEL | DC-S5M2XWGW | 2 | 1 | 1 | 12
Apr | North | CHA | DMC-FZ2500GA | 2 | 2 | 2 | 1
Apr | North | DEL | DC-FZ10002GW | 2 | 2 | 2 | 1
Apr | North | GUR | DC-S1HGW-K | 1 | 1 | 1 | 1
Apr | North | JAI | DC-S5KGW-K | 1 | 1 | 1 | 1
Apr | North | DEL | DC-S5GW-K | 1 | 1 | 1 | 1
Apr | South | BAN | DC-S5M2WGW | 1 | 1 | 1 | 1
Apr | South | COI | DC-S5M2KGW | 2 | 2 | 2 | 1
Apr | South | CHE | DC-S5M2GW | 2 | 2 | 2 | 28
Apr | South | COC | DC-S5M2XWGW | 2 | 1 | 1 | 12
May | South | HYD | DMC-FZ2500GA | 2 | 2 | 2 | 1
May | South | VIJ | DC-FZ10002GW | 2 | 2 | 2 | 1
Jun | West-1 | MUM | DC-S1HGW-K | 1 | 1 | 1 | 1
Jun | West-1 | NAG | DC-S5KGW-K | 1 | 1 | 1 | 1
Jun | West-1 | PUN | DC-S5GW-K | 1 | 1 | 1 | 1
Jun | West-2 | AHM | DC-S5M2WGW | 1 | 1 | 1 | 1
Jun | West-2 | IND | DC-S5M2KGW | 2 | 2 | 2 | 1
Jun | West-2 | RAI | DC-S5M2GW | 2 | 2 | 2 | 28
Jun | West-1 | PUN | DC-S5M2XWGW | 2 | 1 | 1 | 12
Spreadsheet: 11d41b2a-9ec7-4aca-9d78-7d2424de2438
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2010-07-01 00:00:00 | 101 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: Duke

Duke Energy Field Services
Contract  24268
2002-01-31 00:00:00 |  | 1529476.6
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-02-19 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 1898
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -1
500267
Duke Energy Trading and Marketing
Contract  24693
2002-01-31 00:00:00 |  | 275313.72
2002-02-17 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 377700 | 117857 | 193435
2002-01-31 00:00:00 |  | 855876.1
2002-02-19 00:00:00
500241
500391 | 1180
500392 | 1742
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
24268
24693
24361
21665
22664
23995
22051
20379
26357
21544
24532
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: IT EOL

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  | 0 |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  | [NAME] | 49200 | 0
ENARENT | Rent |  |  |  |  | 0 |  |  | [NAME] | 57600 | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 2
ENATRANS | Transportation |  |  |  |  | 0 |  |  | Specialist | 78000 | 15
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 8
ENATAXES | Taxes Other than Income |  |  |  |  | 0 |  |  | Analyst | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Associate | 0 | 0
 |  |  |  |  |  |  |  |  | Manager | 144000 | 6
 | Headcount |  |  | 0 | 40 |  |  |  | Director | 168000 | 6
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 3
 | A&A Headcount |  |  |  |  |  |  |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  | 0
ENACORIT | Controllable Infrastructure |  |  | 0 |  |  |  |  | Consulatant | 192000 | 1
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.