tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 025a3251-ae6a-48a4-9bd6-fdd9a7f709b2
Sheet: b. Fringe

Detailed Budget Justification
[NAME] Benefits
Please Read!!!  Fill out the table below by labor type (add additional rows if necessary).  If all employees receive the same fringe benefits, you can show "Total Personnel" in the Labor Type column instead of listing out all personnel separately.  If necessary, you can use the box below to provide additional explanation regarding your fringe rate calculation.    The rates and how they are applied should not be averaged to get one fringe cost percentage.    The fringe benefit rate should be applied to both the Federal Share and Recipient Cost Share.  Add rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer.  Please enter formulas as shown in the example.
Labor Type | Budget Period 1 |  |  | Budget Period 2 |  |  | Budget Period 3 |  |  | Total Project Fringe Benefit Costs
 | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total
EXAMPLE ONLY: Sr. Engineer | 170000 | 0.2 |  | 10000 | 0.2 |  | 10000 | 0.2
Total Personnel
Total:
A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by DOE for estimating purposes is required if reimbursement for fringe benefits is requested.  Please check (X) one of the options below and provide the requested information.  Calculate the fringe rate and the Total should calculate automatically (if adding rows, ensure the formulas are updated).
______ A fringe benefit rate has been negotiated with, or approved by, a federal government agency.  A  copy of the latest rate agreement is included with this application,                and will be provided electronically to the Contracting Officer for this project.  ______ There is not a current, federally approved rate agreement negotiated and available*.    *When this option is checked, the entity preparing this form shall submit a rate proposal in the format provided at the following website, or a format that provides the same level of information; and the rate proposal must support the rates being proposed for use in performance of the proposed project.  Go to https://www.eere-pmc.energy.gov/forms.aspx and select Sample Rate Proposal.
Additional Explanation/Comments (as necessary)
Please use this box (or an attachment) to further explain how your total fringe benefits costs were calculated.  Your calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).
Spreadsheet: 780883d1652852873-sortby-and-filter-formula-trouble-sortby-and-filter-test-aligw
Sheet: Sheet1

 |  | 04040 | 04170 |  |  | 04040 | 04170
 | CIA |  |  |  | CIA
 |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  |  |  | [NAME]
 |  | [NAME] |  |  |  | [NAME]
 | VIP |  |  |  | VIP
 |  | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 |  |  | [NAME] |  |  |  | [NAME]
Spreadsheet: 190236d1351578912-reference-cell-date-in-worksheet-based-on-a-group-of-dates-in-another-worksheet-sample
Sheet: Overtime

Employee Overtime Form
Employee: | [NAME]
Time Frame:
Submitted On: | October, 30 2012
DATE | [NAME] | Hours  Worked
 |  | 0
 | TOTAL | 0
 | [NAME]: | 0
 | CLAIMED AMOUNT: | 0
NEED
APPROVAL
FOR: | 3 | Hours
APPROVED BY: | Manager's Signature
DATE:
TIME IN LIEU: | 0 | Hours
APPROVED
AMOUNT: |  | Hours
NOTE: If you are not approving all the hours listed, please initial beside the
hours you are approving.  Please submit to payroll once this form is approved.
Spreadsheet: 771532d1646713950-trying-to-sum-without-including-numbers-that-have-n-a-in-the-column-next-to-them-excel-forum-help-2-2-1-
Sheet: Sheet2

A5512 | 72.66
A6530 | 122.54
A6533 | 66.94
A6539 | 46.85
 | 438.435 | N/A
 | 34.678 | N/A
 | 30.113 | N/A
 | 456.12
 | 349.54
 | 349.97
 | 0.2937 | N/A
 | 39.32
Total
Spreadsheet: 109a2a8d-35db-4e7c-af2c-855576bc0970
Sheet: Sheet1

Unnamed: 0 | Deutsche Jugendfeuerwehr | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Teilnehmermeldung für den [NAME]
zum: | Bundesentscheid im [NAME] |  |  | am: | 2003-01-01 00:00:00
in: | Musterstadt
JF: | Musterdorf |  |  |  | St-Nr: |  |  |  |  | 1 | 1
aus: | Musterland
 |  | mögliche Jahrgänge | von | bis
 |  | Bundeswettbewerb | 1985 | Eintritt entsp. Bundesland |  |  | BWB
 |  | Int. [NAME] | 1987 | 1991 | INT
 | Name | Vorname | Geburtsdatum | m / w | Alter |  | Alter
1 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
2 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
3 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
4 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
5 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
6 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
7 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
8 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
9 |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
E |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 1 | 0
Diese Tabelle bitte per Mail an die vom                                 Veranstalter vorgegebene Adresse einsenden! |  |  | Gesamtalter 1-9 |  | 0 |  | 0
 |  |  | Durchschnittsalter
 |  |  | Vorgabepunkte |  |  |  | 1000
 | Für die [NAME] gez.: |  | [NAME] in s
Spreadsheet: 537404d1505055267-2-filters-at-different-rows-in-one-table-doc1
Sheet: Filter A

Main Header | Index | Name | Date | Type |  | 1 | 2 | 3 | 4
Header A | Index | Name | Date | A |  | Volume
 |  |  |  | A
 |  |  |  | A |  | Net | Gross
Header B | Index | Name | Date | B |  | Dimension (mm) |  |  | Diameter
 |  |  |  | B |  | Length | [NAME] | Height
 |  |  |  | B
[NAME] | Index | Name | Date | C |  | Material Name |  | Weight (kg)
 |  |  |  | C
 |  |  |  | C
Main Data | 1 | Bottle |  | A |  | 15 L | N/A
 | 2 | Rod 1 |  | B |  | 10 | 17 | 4 | 2
 | 3 | Rod 2 |  | B |  | 10 | 17 | 7 | 1.5
 | 4 | Barble |  | C |  | Stainless Steel |  | 190
Spreadsheet: 676589d1588876730-swapping-some-column-headers-with-values-in-another-column-example1
Sheet: Sheet2

Department | Project | AD | AC | CI | CO | CD | BC
HR | Project1 | 2000
HR | Project2 | 5000
Accounting | Project1 |  |  |  | 3000 | 1000 | 2000
Accounting | Project3 |  | 3000 |  | 2000 |  | 1000
IT | Project2 | 1000 |  | 2000
IT | Project3 | 2000 |  | 2000
Spreadsheet: jason_wolfe__13349__Matrix032701
Sheet: NORTHEAST REGION

Pipeline | Logistics | Ext. | Logistics |  | Deal Validation | Ext. | Vol. Control | Ext. | Economics | Ext. | Trade Capture | Ext. | Operation | Operational Analysis
Lead or [NAME] | [NAME],Mgr | 35858 | Secondary Contact |  | [NAME] | 37077 | [NAME] | 33322 | [NAME] | 36446 | [NAME] | 39932
Alabama Tennessee | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 39197 | [NAME] | 34231
Algonquin | [NAME] | 37519 | [NAME] | 37865 | [NAME] | 33465 | [NAME] | 39197
Columbia Gas of Kentucky | [NAME] | 31901 | [NAME] | 34221 | [NAME] | 33465 | [NAME] | 31582
Columbia Gas Transmission | [NAME] | 31901 | [NAME] | 34221 | [NAME] | 33465 | [NAME] | 31582
Columbia Gulf | [NAME] | 37086 | [NAME] | 31901 | [NAME] | 33465 | [NAME] | 31582
Consolidated Natural Gas | [NAME] | 33005 | [NAME] | 37865 | [NAME] | 33465 | Chantelle James | 57928
East Ohio Gas | [NAME] | 31901 | [NAME] | 34221 | [NAME] | 33465 | [NAME] | 31582
East Tennessee | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 34780
EGSI (Exxon) | Beverly Beaty | 36357 | [NAME] | 37322 | [NAME] | 33465 | [NAME] | 31582
Equitran | [NAME] | 37519 | [NAME] | 37865 | [NAME] | 33465 | [NAME] | 33965
[NAME] | [NAME] | 3719 | [NAME] | 37519 | TBA |  | Chantelle James | 57928
High Island Offshore System (HIOS) | [NAME] | 37086 | [NAME] | 31901 | [NAME] | 33465 | [NAME] | 34780
Iroquois | [NAME] | 33005 | [NAME] | 37865 | [NAME] | 33465 | [NAME] | 33965
Leviathan Gas | Beverly Beaty | 36357 | [NAME] | 34249 | [NAME] | 33465 | [NAME] | 39197
Midwestern Gas | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 34780
National Fuel | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 31582
Olympic Pipeline | [NAME] | 31901 | [NAME] | 34221 | [NAME] | 33465 | [NAME] | 39197
Tennessee Gas | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 34780
Tennessee River Intrastate | [NAME] | 37179 | [NAME] | 37519 | [NAME] | 33465 | [NAME] | 34780
Texas Eastern | [NAME] | 37519 | [NAME] | 37865 | [NAME] | 33465 | [NAME] | 31582
Transco | Beverly Beaty | 36357 | [NAME] | 37322 | [NAME] | 33465 | [NAME] | 39197
Transco Louisiana Intrastate | Beverly Beaty | 36357 | [NAME] | 37322 | [NAME] | 33465 | [NAME] | 39197
Venice Gas Gathering System | [NAME] | 37086 | [NAME] | 31901 | [NAME] | 33465 | [NAME] | 33965
U-T Offshore (UTOS) | [NAME] | 37086 | [NAME] | 31901 | [NAME] | 33465 | [NAME] | 34780
Firm Trade |  |  |  |  | TBA - To Be Assigned
[NAME] x39932
Spreadsheet: 201465d1356004509-reducing-balance-asset-get-back-to-purchase-date-reducing-bal-assets
Sheet: Sheet1

PLANT & EQUIPMENT
 | Original Cost | Reducing Balance Depreciation | NBV at year end | Currrent Date
Cabinet | 1257 | 0.225 | 76 | 2012-12-31 00:00:00
Water Pump | 40768 | 0.2 | 16421 | 2012-12-31 00:00:00
Work back to original purchase date of asset
 | Original Cost | Reducing [NAME] | NBV at year end | Date
Cabinet | 1257 |  |  | 2002-12-31 00:00:00
 |  |  |  | 2003-12-31 00:00:00
 |  |  |  | 2004-12-31 00:00:00
 |  |  |  | 2005-12-31 00:00:00
 |  |  |  | 2006-12-31 00:00:00
 |  |  |  | 2007-12-31 00:00:00
 |  |  |  | 2008-12-31 00:00:00
 |  |  |  | 2009-12-31 00:00:00
 |  |  |  | 2010-12-31 00:00:00
 |  |  |  | 2011-12-31 00:00:00
 |  |  |  | 2012-12-31 00:00:00
 | Original Cost | Reducing [NAME] | NBV at year end | Date
Water Pump |  |  |  | 2009-12-31 00:00:00
 |  |  |  | 2010-12-31 00:00:00
 |  |  |  | 2011-12-31 00:00:00
 |  |  |  | 2012-12-31 00:00:00
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
 |  |  |  | NA
Spreadsheet: 93642d1293301297-last-data-range-cell-update-example-mahju
Sheet: Sheet1

 |  |  |  |  |  |  | 2 | 5
45 | 2 |  |  |  |  |  | group "2" | group "5"
67 | 2 |  |  |  |  |  | 45 | 87
87 | 5 |  |  |  |  |  | 67 | 43
43 | 5 |  |  |  |  |  | 124 | 98
98 | 5 |  |  |  |  |  | 879 | 453
124 | 2 |  |  |  |  |  | 908 | 236
453 | 5 |  |  |  |  |  | 435
879 | 2
908 | 2
236 | 5
435 | 2
Spreadsheet: 1f569736-bfba-40c5-a596-9cf02e4acddf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Length of Service in Years | Number of Staff | LSL Liability June 2000 |  | Length of Service in Years | Number of Staff | LSL Liability June 2001 |  | Length of Service in Years | Number of Staff | LSL Liability June 2002
< 5 | 67 | 116428.51 |  | < 5 | 89 | 130240.25 |  | < 5 | 126 | 186065.47
> 5 - 10 | 79 | 614681.45 |  | > 5 - 10 | 67 | 518759.25 |  | > 5 - 10 | 60 | 498444.66
> 10 - 15 | 33 | 454863.4 |  | > 10 - 15 | 41 | 585391.06 |  | > 10 - 15 | 50 | 701807.24
> 15 -  20 | 37 | 533246.9 |  | > 15 -  20 | 36 | 648375.96 |  | > 15 -  20 | 28 | 572488.94
> 20 - 25 | 29 | 555325.48 |  | > 20 - 25 | 24 | 416210.71 |  | > 20 - 25 | 31 | 561687.11
> 25 - 30 | 14 | 370394.89 |  | > 25 - 30 | 17 | 381076.37 |  | > 25 - 30 | 16 | 414728.46
> 30 - 35 | 11 | 261884.02 |  | > 30 - 35 | 13 | 426705.34 |  | > 30 - 35 | 12 | 428029.49
> 35 - 40 | 4 | 126241.7 |  | > 35 - 40 | 5 | 165593.05 |  | > 35 - 40 | 3 | 121346.69
> 40 | 3 | 101268.34 |  | > 40 | 3 | 119010.48 |  | > 40 | 3 | 96207.99
Totals | 277 | 3134334.69 |  | Totals | 295 | 3391362.47 |  | Totals | 329 | 3580806.05
Spreadsheet: 848544d1699278908-complex-problem-on-how-to-analyze-sales-data-sales-data
Sheet: Pivot

Sum of Value | Column Labels
 | 2022 |  |  |  | 2023 |  |  |  | Grand Total
Row Labels | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
BE
1001 | 0 | 4 | 4 | 5 | 4 | 1 | 1 | 2 | 21
1002 | 4 | 7 | 4 | 0 |  |  |  |  | 15
1003 | 2 | 5 | 8 | 2 | 7 | 2 | 5 | 3 | 34
1004 | 3 | 0 | 5 | 3 | 0 | 4 | 1 | 6 | 22
1005 |  |  |  |  | 1 | 7 | 7 | 5 | 20
1006 |  |  |  |  | 7 | 0 | 1 | 2 | 10
DE
1001 | 1 | 2 | 1 | 4 | 1 | 8 | 2 | 5 | 24
1002 | 0 | 5 | 2 | 4 |  |  |  |  | 11
1003 | 5 | 3 | 6 | 4 | 4 | 8 | 3 | 3 | 36
1006 |  |  |  |  | 1 | 3 | 2 | 5 | 11
FR
1001 | 0 | 5 | 0 | 9 | 5 | 0 | 1 | 6 | 26
1002 | 5 | 2 | 4 | 5 |  |  |  |  | 16
1003 | 3 | 7 | 8 | 1 | 0 | 5 | 7 | 3 | 34
1004 | 0 | 1 | 1 | 0 | 5 | 2 | 2 | 5 | 16
1006 |  |  |  |  | 9 | 4 | 1 | 7 | 21
NL
1001 | 4 | 6 | 7 | 6 | 2 | 0 | 1 | 0 | 26
1002 | 2 | 0 | 1 | 0 |  |  |  |  | 3
1003 | 0 | 1 | 5 | 1 | 3 | 3 | 2 | 1 | 16
1004 | 1 | 4 | 2 | 2 | 5 | 5 | 6 | 3 | 28
1005 |  |  |  |  | 3 | 3 | 0 | 3 | 9
1006 |  |  |  |  | 5 | 5 | 3 | 7 | 20
PL
1001 |  |  |  |  | 2 | 5 | 3 | 0 | 10
1003 |  |  |  |  | 1 | 7 | 4 | 2 | 14
1006 |  |  |  |  | 0 | 0 | 0 | 7 | 7
Grand Total | 30 | 52 | 58 | 46 | 65 | 72 | 52 | 75 | 450
Spreadsheet: 728141d1618334179-index-match-not-working-if-lookup-column-contains-formulas-test-sheet
Sheet: Sheet1

VERSION 1  NOT WORKING |  |  |  |  |  |  |  |  | VERSION 1  WORKING!
 | HELPER COLUMN WITH FORMULA |  |  | NOT WORKING FORMULA |  |  |  |  |  | HELPER COLUMN VALUES |  |  | WORKING FORMULA
 | q |  |  | q |  |  |  |  |  | q |  |  | q
DEBTS |  |  | PAYMENTS PER MONTH |  |  |  |  |  | DEBTS |  |  | PAYMENTS PER MONTH
READJUSTMENT DATE |  | RENT AMOUNT | RENT PER MONTH |  | PAYMENTS |  | BALANCE |  | READJUSTMENT DATE |  | RENT AMOUNT | RENT PER MONTH |  | PAYMENTS |  | BALANCE
 |  |  | MONTH | AMOUNT | DATE | AMOUNT |  |  |  |  |  | MONTH | AMOUNT | DATE | AMOUNT
2017-02-01 00:00:00 |  | 300 | 2017-02-01 00:00:00 |  |  |  |  |  | 2017-02-01 00:00:00 | 2017-02-01 00:00:00 | 300 | 2017-02-01 00:00:00 |  | 2017-02-05 00:00:00 | 300
2018-08-01 00:00:00 |  | 310 |  |  |  |  |  |  | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 310 |  |  | 2017-03-05 00:00:00 | 300
2019-01-01 00:00:00 |  | 320 |  |  |  |  |  |  | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 320 |  |  | 2017-04-05 00:00:00 | 300
 |  | 300 |  |  | NOT WORKING |  |  |  |  | 2020-01-01 00:00:00 | 300 |  |  | 2017-05-05 00:00:00 | 300
 |  | 310 |  |  | FORMULA |  |  |  |  | 2021-01-01 00:00:00 | 310 |  |  | 2017-08-01 00:00:00 | 900
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-09-10 00:00:00 | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-20 00:00:00 | 2400
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-07-10 00:00:00 | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-08-05 00:00:00 | 320
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-05 00:00:00 | 310
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-05 00:00:00 | 310
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-12-05 00:00:00 | 310
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-01-10 00:00:00 | 3500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-10 00:00:00 | 3500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-01-10 00:00:00 | 1500
Spreadsheet: daren_farmer__6653__CES - April
Sheet: Prebid Info

 | Supply |  |  | Market | Net |  | Comments
 | [NAME] | Other
BDOL | 0 | 208 |  | 208 |  |  | Spinnaker sale to Dow
CCNG | 0 | 1097 |  | 1097 |  |  | [NAME] to CCNG
CSGT | 0 | 1233 |  | 1233 |  |  | Spinnaker sale to Dow
DEFS | 0 | 0 |  | 0 |  |  | Expired
ETXG |  |  |  | 0
GEMC | 15602 | 1124
GPPP | 12474 |  |  |  |  |  | [NAME] Pdn to HPL / Tenn Zn 0
KMID | 2012 | 322 |  | 2334 |  |  | [NAME] sale to Delhi (KMID)
LONE | 4446 | 702 |  | 5148 |  |  | [NAME] sale to TXU Energy
MTPC | 2480 | 0 |  | 2480 |  |  | [NAME] sale to MTPL
TOMC | 2027 | 0 |  | 0 |  |  | Kerr McGee to HPL
Spreadsheet: 880353d1727984730-need-a-column-to-list-values-related-to-another-column-realtrac_report
Sheet: Sheet1

 |  | SCRAP |  | column B intended output
 |  |  |  | Hopp, Autumn
 |  |  |  | Dickinson, [NAME]
 |  |  |  | Stange, Darrel
 |  |  |  | Dickinson, [NAME]
 |  |  |  | Hopp, Autumn
 |  |  |  | Hopp, Autumn, Dickinson, [NAME],Stange, Darrel
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -117083 | -290437.21
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1124784 | 2348164.6
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -248558 | -761457
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 221716 | 679226.97
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: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1151626 | 3528006.25 | -1007701 | -3087092.01
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 248558 | 761457.43
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1995500 | -15.32
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
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: louise_kitchen__22565__Canada  Projects
Sheet: Sheet1

Project Name |  |  | Estimated Completion Month | Estimated Completion Year | [NAME] | Purpose |  |  | EA LOB Served | System | Status | EA % | EA $ | EA $ [NAME] | EA $ Indirect Expense | EA $ Direct Project Expense
ENA Canada- Energy Ops and Enron Direct |  |  | 12 | 2002 | McKeel | New Business or change in business |  |  | Trading Support Power- Canada | Intranet | In Progress | 1 | 202435 | 176152 | 10572 | 15710
Spreadsheet: 121789d1316418278-excel-2007-calculation-on-the-basis-of-if-calculation_if
Sheet: Sheet1

 | PPI | 800 | 25 | KGS |  | 20240
 | PPI | 800 | 50 | LBS |  | 18400
 | RTC | 800 | 25 | KGS |  | 20240
 | RTC | 800 | 50 | LBS |  | 18358
 | IPI | 800 | 25 | KGS |  | 20240 |  |  |  | RTC/IPI | 1 KG | 2.205 LB
 | IPI | 800 | 50 | LBS |  | 18358 |  |  |  | OTHERS | 1 KG | 2.2 LB
 | SOM | 800 | 25 | KGS |  | 20240 |  |  |  | TARE WEIGHT OF AN "LB" BAG | 0.6 LB
 | BNS | 800 | 25 | KGS |  | 20240 |  |  |  | TARE WEIGHT OF A "KG" BAG | 0.3 KG
 | BNS | 800 | 50 | LBS |  | 18400
 | Calculation of G1
 | No. of [NAME] |  |  |  | 800
 | Weight per Bag |  |  |  | 50 | LBS
 | Net Weight |  |  |  |  | LBS
 | Tare Weight |  |  |  |  | LBS | (No. of Bags x 0.6 - since it is in LBS)
 | Gross Weight |  |  |  |  | KGS | (Is always in KGS | (Net Weight + Tare Weight)/2.2 - Divided by "2.2" since in LBS and Code is PPI)
 | Calculation of G2
 | No. of [NAME] |  |  |  | 800
 | Weight per Bag |  |  |  | 25 | KGS
 | Net Weight |  |  |  |  | KGS
 | Tare Weight |  |  |  |  | KGS | (No. of Bags x 0.3 - since it is in KGS)
 | Gross Weight |  |  |  |  | KGS | (Is always in KGS | (Net Weight + Tare Weight))
 | Calculation of G4
 | No. of [NAME] |  |  |  | 800
 | Weight per Bag |  |  |  | 50 | LBS
 | Net Weight |  |  |  |  | LBS
 | Tare Weight |  |  |  |  | LBS | (No. of Bags x 0.6 - since it is in LBS)
 | Gross Weight |  |  |  |  | KGS | (Is always in KGS | (Net Weight + Tare Weight)/2.205 - Divided by "2.205" since it is in LBS and Code is RTC)
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 06-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 1662873
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  | Unbilled Revenue - Work in Progress (ofset to Accounts Receivable) |  |  |  |  |  |  |  | -425306.73
 |  |  |  |  |  |  |  | Pre-Paid Expenses |  |  |  |  |  |  |  | 9152
 |  |  |  |  |  |  |  | Work in Process transferred from 015A to 1473 - to be handled in the third quarter |  |  |  |  |  |  |  | 2079027
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 64912d1265731208-look-up-and-match-several-values-to-include-entry-sample_worksheet-1-
Sheet: Sheet1

Company | Quarter | Year | Industry | Lookup | Concatenated Data
Company B | Q1 | 2009 | Administration | NOT_OK | Company B_Q1_Administration
Company D | Q2 | 2009 | Transportation and logistics | NOT_OK | Company D_Q2_Transportation and logistics
Company C | Q3 | 2009 | Production | NOT_OK | Company C_Q3_Production
Company A | Q1 | 2009 | Administration | OK | Company A_Q1_Administration
Company A | Q2 | 2009 | Administration | OK | Company A_Q2_Administration
Company A | Q3 | 2009 | Administration | OK | Company A_Q3_Administration
Company A | Q4 | 2009 | Administration | OK | Company A_Q4_Administration
Company B | Q2 | 2010 | Construction | NOT_OK | Company B_Q2_Construction
Company C | Q4 | 2010 | Health | NOT_OK | Company C_Q4_Health
Only valid entries in the above list are:
Company A | Q1 | 2009 | Administration | OK
Company A | Q2 | 2009 | Administration | OK
Company A | Q3 | 2009 | Administration | OK
Company A | Q4 | 2009 | Administration | OK