tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135889d1326295180-how-do-i-hide-the-div0-statement-in-a-cell-summary-1-
Sheet: UserDetails

SALESPERSONID | Department
C03 | Corporate
C08 | Corporate
C09 | Corporate
[NAME] | Direct
D20 | Direct
D28 | Direct
D45 | Direct
D46 | Direct
D54 | Direct
D58 | Direct
D59 | Direct
D60 | Direct
D64 | Direct
D65 | Direct
D67 | Direct
D70 | Direct
D71 | Direct
D73 | Direct
[NAME] | Direct
D77 | Direct
D98 | Direct
E05
F04 | Field
F19 | Field
F21 | Field
F26 | Field
F30 | Field
F52 | Field
F55 | Field
F64 | Field
F67 | Field
F68 | Field
F69 | Field
[NAME] | Field
F71 | Field
F72 | Field
F79 | Field
F80 | Field
F85 | Field
[NAME] | Field
FA2 | Field
FA3 | Field
FA4 | Field
FA6 | Field
FA0 | Field
FB1 | Field
FB2 | Field
FB6 | Field
FB8 | Field
FC1 | Field
FC4 | Field
FC5 | Field
FC7 | Field
FC8 | Field
FD2 | Field
FD3 | Field
FD4 | Field
FD5 | Field
FD6 | Field
FD7 | Field
FD8 | Field
FD0 | Field
FE1 | Field
FE2 | Field
FE3 | Field
FE4 | Field
FE6 | Field
FE7 | Field
FE8 | Field
FE0 | Field
FF1 | Field
FF3 | Field
FF5 | Field
FF6 | Field
FF7 | Field
J03
P02 | Portfolio
P03 | Portfolio
P07 | Portfolio
P09 | Portfolio
P10 | Portfolio
P12 | Portfolio
P14 | Portfolio
P16 | Portfolio
P17 | Portfolio
P18 | Portfolio
P19 | Portfolio
R05 | Relationship
[NAME] | Relationship
R10 | Relationship
R12 | Relationship
R13 | Relationship
R14 | Relationship
S04 | PaymentSense
S05 | Ums
S06 | Chip & Pin Solutions
S07 | Glorydale
S10 | XLN
S11 | Fidelity
S12 | S12
BOS | BOS
Spreadsheet: 689802d1596660965-formula-to-calculate-time-neryoneil
Sheet: Sheet1

Name | Date | IN | Out-lunch | In-from-lunch | OUT | [NAME] time | Overtime | Total
 | Mon | 02:00:00 | 11:30:00 | 12:30:00 | 21:00:00
 | Tue | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Wed | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Thu | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 | Fri | 06:00:00 | 11:30:00 | 12:30:00 | 17:00:00
 |  |  |  |  | TOTALs:
Spreadsheet: 888212d1738685600-total-costs-per-year-yearly-total-example
Sheet: Sheet1

item | costs | last purchased | Price with increase for inflation
1 | 1.05 | 2017-01-01 00:00:00
2 | 1.1 | 2018-02-01 00:00:00
3 | 1.15 | 2019-03-01 00:00:00 |  |  |  |  | Year | Totals |  | Year | Inflation
4 | 1.2 | 2020-04-01 00:00:00 |  |  |  |  | 2017 |  |  | 2017 | 0.6
5 | 1.25 | 2021-05-01 00:00:00 |  |  |  |  | 2018 |  |  | 2018 | 0.525
6 | 1.3 | 2022-06-01 00:00:00 |  |  |  |  | 2019 |  |  | 2019 | 0.45
7 | 1.35 | 2023-07-01 00:00:00 |  |  |  |  | 2020 |  |  | 2020 | 0.375
8 | 1.4 | 2024-08-01 00:00:00 |  |  |  |  | 2021 |  |  | 2021 | 0.3
9 | 1.45 | 2017-09-01 00:00:00 |  |  |  |  | 2022 |  |  | 2022 | 0.225
10 | 1.5 | 2018-10-01 00:00:00 |  |  |  |  | 2023 |  |  | 2023 | 0.15
11 | 1.55 | 2019-11-01 00:00:00 |  |  |  |  | 2024 |  |  | 2024 | 0.075
12 | 1.6 | 2020-12-01 00:00:00
13 | 1.65 | 2021-01-02 00:00:00
14 | 1.7 | 2022-02-03 00:00:00
15 | 1.75 | 2023-02-04 00:00:00
16 | 1.8 | 2024-02-05 00:00:00
17 | 1.85 | 2017-02-06 00:00:00
18 | 1.9 | 2018-03-07 00:00:00
19 | 1.95 | 2019-04-11 00:00:00
20 | 2 | 2020-05-27 00:00:00
21 | 2.05 | 2021-06-30 00:00:00
22 | 2.1 | 2022-12-25 00:00:00
23 | 2.15 | 2023-01-26 00:00:00
24 | 2.2 | 2024-02-09 00:00:00
Spreadsheet: 76497d1277056434-overall-score-formula-book3
Sheet: Sheet1

Ex 1
0.3 | 0.2 | 0.1 | 0.2 | 0.1 | 0.1 | 1
Score | Score | Score | Score | Score | Score | Overall
3 | 3 | 3 | 3 | No Data | 2.5 | #N/A
Ex 2
0.3 | 0.2 | 0.1 | 0.2 | 0.1 | 0.1 | 1
Score | Score | Score | Score | Score | Score | Overall
3 | 3 | 3 | 3 |  | 2.5 | 2.65
Supposed to be
0.3 | 0.2 | 0.1 | 0.2 | 0.1 | 0.1 | 1
Score | Score | Score | Score | Score | Score | Overall
3 | 3 | 3 | 3 | No Data | 2.5 | #N/A
Spreadsheet: 192478d1352416718-finding-the-last-occurrence-of-a-value-in-a-list-121109-lookup-last-occurrence
Sheet: Sheet1

INPUT |  |  |  | DESIRED RESULT |  |  |  | VLOOKUP |  |  |  | LOOKUP |  |  |  |  | SUGGESTED SOLUTION - CALCUL8ORS.COM.AU
Time | Item | Action |  | Item | Last Action | Last Time |  | Item | Last Action | Last Time |  | Item | Last Action | Last Time
1 | A | Download |  | A | Install | 3 |  | A | Download |  |  | A | Download | 1 |  |  | A | Install
2 | B | Download |  | B | Download | 2 |  | B | Download |  |  | B | Download | 2 |  |  | B | Download
3 | A | Install |  | C | Inventory | 4 |  | C | Inventory |  |  | C | Inventory | 4 |  |  | C | Inventory
4 | C | Inventory
Spreadsheet: 79690d1279893418-inventory-management-inventory_example
Sheet: Daily Sales

Date | Product ID | Description | Quantity Sold
2010-07-23 00:00:00 | AA123 | [NAME] bearings | 8
2010-07-23 00:00:00 | [NAME] | Waffle Makers | 3
2010-07-23 00:00:00 | AA123 | [NAME] bearings | 2 |  |  | AA123
2010-07-23 00:00:00 | [NAME] | Waffle Makers | 2 |  |  | 10
Spreadsheet: 473994d1470566944-formula-for-top-5-values-with-countif-sample-3-prc
Sheet: PIVOT

FullDate | 2016-03-01 00:00:00
Count of Problem Area | Region
Problem Area | Midwest | North East | South | West | Grand Total
Complaints on Employees | 2 |  | 53 |  | 55
NA | 5 | 1 | 45 |  | 51
Ingenico Payment Terminal | 2 |  | 41 |  | 43
None | 1 | 1 | 35 |  | 37
STOREnet PC | 2 |  | 29 |  | 31
Store Manager | 2 |  | 21 |  | 23
MC3090 |  |  | 23 |  | 23
Complaints on Store Conditions | 1 |  | 13 |  | 14
Prepaid |  |  | 11 |  | 11
UHHT | 4 |  | 7 |  | 11
Software |  |  | 10 |  | 10
POS Scanners | 1 |  | 7 | 2 | 10
Desired Behaviors Analysis |  |  | 7 |  | 7
Cash Register Printer |  |  | 6 |  | 6
Complaint |  |  | 6 |  | 6
IBM 742 |  |  | 5 |  | 5
Networking |  |  | 5 |  | 5
IBM 743 |  |  | 4 |  | 4
Applicant |  |  | 4 |  | 4
POS Procedures |  |  | 4 |  | 4
Shipping Inquiry |  |  | 3 |  | 3
Applicants |  |  | 3 |  | 3
test |  |  | 2 |  | 2
Armed Robbery |  |  | 2 |  | 2
Procedural |  |  | 2 |  | 2
General Employee Complaints |  |  | 2 |  | 2
Did Not Receive Check |  |  | 2 |  | 2
Maintenance |  |  | 2 |  | 2
Temporary Price Reductions |  |  | 2 |  | 2
Coupon |  |  | 2 |  | 2
W-2 Forms |  |  | 2 |  | 2
District Manager | 1 |  | 1 |  | 2
Food/Beverage/Pet Supplies |  |  | 2 |  | 2
Medical |  |  | 1 |  | 1
Facilities/Power Outage |  |  | 1 |  | 1
Termination Dispute |  |  | 1 |  | 1
Cash Management |  |  | 1 |  | 1
Fixtures and Supplies |  |  | 1 |  | 1
Planograms |  |  | 1 |  | 1
Tax Department |  |  | 1 |  | 1
PLU |  |  | 1 |  | 1
Direct Deposit |  |  | 1 |  | 1
IBM 745 |  |  | 1 |  | 1
Complaints on DM |  |  | 1 |  | 1
Wage and Hour |  |  | 1 |  | 1
Stop Sale |  |  | 1 |  | 1
Credit / Debit Cards |  |  | 1 |  | 1
Claim of Harassment |  |  | 1 |  | 1
Former Employee Complaints |  |  | 1 |  | 1
Miscellaneous |  |  | 1 |  | 1
Refund Exchange Policy |  |  | 1 |  | 1
Burglary |  |  | 1 |  | 1
Reports |  |  | 1 |  | 1
UPS |  |  | 1 |  | 1
Security Cameras |  |  | 1 |  | 1
No choice |  |  | 1 |  | 1
Sensitive HR issues |  |  | 1 |  | 1
Coupon Policy |  |  | 1 |  | 1
Spreadsheet: 166862d1341835810-excel-2007-matching-case-with-a-date-figure-case
Sheet: Sheet1

DATE | [NAME] | VDATE | AMOUNT
2012-05-05 00:00:00 | Cheque Deposit CHQ000041 CHQ1215604136-36460 AT- | 2012-07-05 00:00:00 | 50000
DATE | [NAME] | VDATE | C/DATE | AMOUNT
2012-08-05 00:00:00 | 000041 | 2012-09-05 00:00:00 |  | 50000
[NAME]
HOW DO WE MATCH CELL B7 TO B3 WITH A FORMULA AND WHEN IT HAS MATCHED IT THE VDATE IN C3 SHOULD BE
DISPLAYED ON THE COLUMN D7 AUTOMATICALLY.
Spreadsheet: 622f9b15-1bdc-47d4-9494-d2cb760dc898
Sheet: Sheet1

[NAME] | M | T | W | Th | Fr |  | PGY-1/2 | M | T | W | Th | Fr
Byrd | Onc OR | Onc OR | Onc OR | Onc OR | Onc OR |  | Bretschneider | L&D | L&D | L&D | L&D | Cont Clinic
 | Onc OR | Onc OR | Conference | Onc OR | Onc OR |  |  | L&D | L&D | Conference | L&D | L&D
[NAME] | Gyn OR | Gyn OR | Consults | Gyn OR | Interview |  | [NAME] | L&D | L&D | Cont Clinic | L&D | L&D
 | Gyn OR | Gyn OR | Conference | Interview | Interview |  |  | L&D | L&D | Conference | L&D | Cont Clinic
Grace | L&D | L&D | L&D | L&D | L&D |  | [NAME] | HROB | Cont Clinic | Dysplasia | Consults | Consults
 | L&D | L&D | Conference | L&D | L&D |  |  | Pain Clinic | Consults | Conference | Consults | Cont Clinic
Herrera | Nights | Nights | Nights | Nights | Nights |  | Roedner | Wake | Wake | Wake | Wake | Wake
 | Nights | Nights | Nights | Nights | Nights |  |  | Wake | Wake | Wake | Wake | Wake
Horton | Urogyn OR | Urogyn OR | Urogyn OR | HROB | Connolly clinic |  | White | Onc Floor | Cont Clinic | Dysplasia | Onc Floor | Onc Floor
 | Urogyn OR | Urogyn OR | Conference | Preop Clinic | Resident Urogyn |  |  | Onc Floor | Onc Floor | Conference | Onc Floor | Onc Floor
[NAME] | Wake | Wake | Wake | Wake | Wake |  | Ricks | Nights | Nights | Nights | Nights | Nights
 | Wake | Wake | Wake | Wake | Wake |  |  | Nights | Nights | Nights | Nights | Nights
Waltner-Toews | Onc OR | Onc OR | Onc OR | Onc OR | Onc OR |  | Pierce | Wake | Wake | Wake | Wake | Wake
 | Onc OR | Onc OR | Conference | Onc OR | Onc OR |  |  | Wake | Wake | Wake | Wake | Wake
PGY-2/3 | M | T | W | Th | Fr |  | Buddy week | M | T | W | Th | Fri
[NAME] | ACC OR | OR | Cont Clinic | OR/consult | OR/Consult |  | Tara
 | Pain Clinic | OR | Conference | OR/consult | OR/Consult
[NAME] | Wake | Wake | Wake | Wake | Wake |  | [NAME]
 | Wake | Wake | Wake | Wake | Wake
Letourneau | Nights | Nights | Nights | Nights | Nights |  | [NAME]
 | Nights | Nights | Nights | Nights | Nights
Mosby | HROB | L&D | L&D | HROB | L&D |  | [NAME]
 | L&D | Cont clinic | Conference | L&D | L&D
Hacker | HROB | TA clinic | Dysplasia | HROB | Cont clinic |  | [NAME]
 | FP clinic | TA clinic | Conference | Cont Clinic | Consult
Till | Wake | Wake | Wake | Wake | Wake |  | [NAME]
 | Wake | Wake | Wake | Wake | Wake
[NAME] | HSGs | Consults | Briar Creek | ACC/Cov | Attd REI clinic |  | [NAME]
 | Cont Clinic | Cont clinic | Conference | ACC/Cov | Attd REI clinic
Rounding | Ante | Onc | Gyn
2013-06-15 00:00:00 | Grace | Byrd | [NAME]
2013-06-16 00:00:00 | Grace | Byrd | [NAME]
2013-06-22 00:00:00 | [NAME] | RWT | Till
2013-06-23 00:00:00 | [NAME] | RWT | Hacker
Nights team: | Christina | [NAME] | Nitasha
OB team: | Grace | [NAME] | Emi | Emily
Onc team: | RWT | Byrd | White
Gyn team: | [NAME] | [NAME] | [NAME]
Wake team: | [NAME] | Till | [NAME] | Stuart | Chantel
Spreadsheet: 132352d1323709803-many-condition-need-to-match-and-return-a-unit-price-urgent-assignment-test-formulaexxx
Sheet: Sheet1

YY/MM/DD | [NAME] | Description | PO. No. | Supplier Inv No. | Qty | Unit Price
2010-12-01 00:00:00 | KAM YUEN PETROCHEMICAL (H.K.)LTD. | PP-BJ550 | PD003052 | JT101117BB | 34000 | 1.63
2010-11-29 00:00:00 | KAM YUEN PETROCHEMICAL (H.K.)LTD. | PP-BJ550 | PD003052 | JT101118BB | 34000
2010-12-04 00:00:00 | P-AUDIO SYSTEM CO., LTD | ASSY XDCR DRIVER | PD002633 | 20100432 | 1440 | 7.5
2010-12-04 00:00:00 | P-AUDIO SYSTEM CO., LTD | DRIVER CONE[LC03 0803(S)-4] | PD002753 | 20100432 | 800
2010-12-04 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME] LN12 3002-8 | PD002633 | 20100432 | 1287
2010-12-04 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002512 | 20100432 | 336
2010-12-04 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME] LN15 3001-4 | PD002872 | 20100432 | 48
2010-12-02 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME] LN10 2001-12 | PD002512 | 20100427 | 260
2010-12-02 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME] LN12 3002-8 | PD002633 | 20100427 | 936
2010-12-02 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002633 | 20100427 | 528
2010-12-02 00:00:00 | P-AUDIO SYSTEM CO., LTD | ADAPTER/THREADED/HORN-DRIVER[305-50127-20] | PD002995 | 20100427 | 1.5
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | ADAPTER/HORN-DRIVER[PC-3825] | PD002633 | 20100454 | 1440 | 7.5
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME] | PD002753 | 20100454 | 1296 | 14.7
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | DRIVER UNIT | PD002902 | 20100454 | 432 | 14.7
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | DRIVER UNIT | PD002902 | 20100454 | 400 | 14.7
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | LF-SRM450V2 | PD002753 | 20100454 | 702 | 38
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002902 | 20100454 | 162
2010-12-24 00:00:00 | P-AUDIO SYSTEM CO., LTD | [NAME]] | PD002633 | 20100454 | 288 | 20
Spreadsheet: larry_campbell__21316__LFC0700V1
Sheet: PGW

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
PGW | E | 2000 |  | GENERAL CABLE |  | dth | 10 |  |  |  |  | GENERAL CABLE
PGW | E | 2000 |  | SPRING INDUSTRIES |  | dth | 10 |  |  |  |  | SPRING INDUSTRIES
Spreadsheet: sara_shackleton__36838__enron_appendix
Sheet: Power Swap Final

Transact | Trade Date | Counterparty | B/S | Beg Date | End Date | Vol | Location | Block | Price
107394 | Aug 28 2000 12:00AM | ENRO | SELL | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 56.5
107831 | Sep  6 2000 12:00AM | ENRO | SELL | 2003-01-01 00:00:00 | 2005-12-31 00:00:00 | 100 | NYIS/ZONE J | 5x16 | 58.25
113089 | Dec  4 2000 12:00AM | ENRO | BUY | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 81
114324 | Jan  5 2001 12:00AM | ENRO | BUY | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 60
115036 | Jan 22 2001  4:20PM | ENRO | BUY | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 62.5
116032 | Feb  5 2001  3:57PM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 131.5
116207 | Feb  6 2001  4:53PM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 132.25
116429 | Feb  8 2001  5:11PM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 74.75
116431 | Feb  8 2001 12:00AM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 133.5
117292 | Feb 26 2001  6:10PM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 74.5
117293 | Feb 26 2001 12:00AM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE A | 5x16 | 73
117296 | Feb 27 2001 12:00AM | ENRO | SELL | 2001-07-01 00:00:00 | 2001-08-31 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 132.5
117795 | Mar  6 2001  6:21PM | ENRO | BUY | 2001-06-01 00:00:00 | 2001-06-30 00:00:00 | 50 | NYIS/ZONE J | 5x16 | 86.25
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | May |  | June |  | July |  | August |  | September |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | ENTER MONTH |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  | -2111386.63 | 6883 | 22265.25 | -51280 | -9968.6
2 |  | Liquidations |  |  |  |  |  |  |  | -19125
3 |  | Interdesk |  |  |  |  |  |  |  |  | -32211 | -96633
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  | 16937 |  | -3024.4
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  | 18588 | 382894.7 | 50172 | 296928
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  | 104950
8 |  | Interdesk |  |  |  |  |  |  |  |  | -6541713 | -23505288
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  | -293650 | -875664 | -25 | -74.55
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  | 97341 | 290270.86 | 254 | 757.1 | 786 | 2343.85
14 |  | Cash Out |  |  |  |  |  |  |  |  | -41613 | -144478.38 | -869 | -3355.21 | -19 | -63.18
15 |  | Cash In |  |  |  |  |  |  |  |  | 33722 | 120534.88
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  | -2 | 1977318.9
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  | -1057 | -3151.97
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  | 6625443 | 19757071.03 | -24831 | -74046.04 | 341 | 1016.86
23 | Fuel: |  |  |  |  |  |  |  |  |  | 293650 | 875664.3 | 25 | 74.55
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  | 34350 | 33582.46 | 64883 | 188.81 | -13145331 | 849.09
25 |  | Demand |  |  |  |  |  |  |  |  |  | 58727.12 |  | -3212.47 |  | 10080
 | 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 |  |  |  |  |  |  |  |  |  | -174347 |  | -131667.49
34 |  | Originations
35 |  | Broker Fees |  |  |  |  |  |  |  |  |  | -150
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: mary_fischer__25812__Raptor DFITDSIT2 9-31-01
Sheet: Sheet1

Project Raptor Entities
Deferred Tax Liability Balances
at September 31, 2001
DR/ (CR)
 |  |  |  |  |  | Deferred Tax Liability Balances
 |  |  |  |  |  | Federal | State |  | Total
Harrier |  |  |  |  |  | -220150518 | -19453654
Grizzly |  |  |  |  |  | -48027772 | -4243986
Roadrunner |  |  |  |  |  | -13204386 | -1166809
 | Total NIBT / Deferred Taxes for Entities Supported by ENE Stock
Pronghorn (Supported by TNPC Warrants) |  |  |  |  |  | -86962001 | -7684418
 | Total NIBT / Deferred Taxes for All Raptor Entities
Note:  No taxes are recorded on the Raptor GAAP deconsolidated entities (Talon, [NAME], Bobcat and Porcupine)
Estimated Deferred Tax Liability Balances by Income Category
(Dr) / CR
 |  |  |  | Harrier | Grizzly | Roadrunner | Total |  | Pronghorn |  | Raptor Total
 | Mark to Market Income
 |  | Y-T-D   12/31/00 |  |  | 0 | 0 |  |  | 196686016
 |  | Y-T-D   09/31/01 |  | 200734628 | 41817537 | 0 |  |  | 222034027
 |  | Total Mark to Mkt
 |  | Tax Rate
 |  | Deferred Taxes - Mark to Mkt
 | Other Operating Income
 |  | Y-T-D   12/31/00 |  | 0 | 0 | 0 | 0 |  | 0
 |  | Y-T-D   09/31/01 |  | 30637566 | 11278183 | 0 |  |  | 0
 |  | Total Other Operating
 |  | Tax Rate
 |  | Deferred Taxes - Other Operating Income
 | Interest and Other Income
 |  | Y-T-D   12/31/00 |  |  | 14418797 | 7281944
 |  | Y-T-D   09/31/01 |  | 22685935 | 35796528 | 31531580 |  |  | 303445
 |  | Total Interest & Other
 |  | Tax Rate
 |  | Deferred Taxes - Interest & Other Income
 |  | 12/31/00 NIBT
 |  | 09/31/01 NIBT |  | 252058129
 |  | Life to Date NIBT |  | 567186469
 |  | Tax Rate |  | 0.3695 | 0.3695 | 0.3695 | 0.3695 |  | 0.3695 |  | 0.3695
 |  | Total Deferred Tax
 |  | Adjustment-Actual Current Taxes |  | -29634 | 4143234 | -29597 |  |  | -1601071
 |  | Actual Deferred Taxes
 |  | Deferred Tax Variance |  | -30058406 | -9955093 | 59195 | -40072693 |  | 58576565
Spreadsheet: 3ed4dee3-c56b-4e4a-9783-179b06c50e4c
Sheet: Sheet1

Endeavor! Awards 2014-2015
Construction of an Inexpensive Educational Absorption Spectrophtometer
[NAME]
Documentation of Traditional Medicinal Plant Knowledge and Use in Lowland [NAME]
ASME Human-Powered Vehicle
Influence of Various Seawater Salts on Biofilm Formation by Vibrio fischeri
The Perceived Key Concepts in Biology, Geology, and Chemistry Across Educational Levels
Conservation and Wild Resource Use in Peru
Great Moments in Amateur Eschatology
Fabricating Jewlery Designs Utilizing the Hydraulic Press, [NAME], and Hammers
[NAME] in the Peruvian Amazon: [NAME] in the Tamshiyacu-Tahuayo Communal Reserve
Structural Control of Fluvial Geomorpology and Valley Fill Stratigraphy from an Underfit Stream Valley in Southwestern IN: Preliminary Results
Long-Term Groundwater Monitoring of the Inglefield Sandstone Aquifer in Southern Indiana
Acceptance and understanding of Evolution: A Survey of Introductory Geology Students
[NAME] in the White River of Manistee National Forest, Michigan
Characterizing Groundwater Seepage in the Headwaters of the White River, Manistee National Forest, Michigan
[NAME] for Youth
National Student Advertising Competition Campaign
A Breakdown in Honors
What's It Take to be a Professional Radio Producer?
Peruvian Crafts: How Artisan Crafts Have Affected Women Socially and Economically
Effects of Eating Breakfast on Mood and Class Participation
Effect of Meal Composition on Postprandial Blood Glucose Levels in Middle-Aged and Young Adults
[NAME]
The Pizza Guide
Tracking Changes in Body Fat and Blood Lipid, Glucose, and [NAME] in the Final Cohort of USI Students
Changes in Sterotypes and [NAME] People with Mental Illnesses in American and Japanese Undergraduate Nursing Students
Conformational Analysi of Dithianes and Dioxanes Using VT-NMR and Excel Simulations
Geostrations: A Geological Structures Game for Introductory Geology Students
Analysis of Outer Membrane Proteins of Escherichia coli in High Osmolarity
[NAME]' [NAME] with the Men in the Family
Implementing a New Design for a Paper Glider and Release Mechanism in the Future HAB Flight
Synthesis of Selenoglycosides Using Rongalite
Analysis of 25Al Gamma-ray Transition Intensities and Doppler Broadening of Gamma-Ray Lines from 26P(β+pγ)25Al Gamma-ray Spectrum
Development of a Method to Rear Two Local Butterfly Species: [NAME]: Lycaenidae in the Laboratory
Monitoring Host-Guest Events via UV Absorption by Increasing Conugation of Dithiepins
[NAME] of [NAME] of the Wabash Riber of Posey County, IN
[NAME] and Polarizability Through UV Absorption Induced by EWG and EDG
ASCE Concrete Canoe Presentation