tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796606d1663397280-adding-years-and-months-in-decimal-format-2022-09-17-oeldere2-goodboy-adding-years-and-months-in-decimal-format-1-
Sheet: Sheet1

1.1 | 2.11 | 4 | Kolom1 | Yellow column is the answer |  |  |  |  |  | 1
3.6 | 14.3 | 17.9 | 4 years |  |  |  |  |  |  | 2
2.5 | 2.8 | 5.1 | 17 years 9 months |  |  |  |  |  |  | 3
 |  |  | 5 years 1 month |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  | 20 |  |  | 4 | years
 |  |  |  |  |  |  |  |  |  | 21 |  |  | 17 | years | 9 | months
 |  |  |  |  |  |  |  |  |  | 22 |  |  | 5 | years | 1 | month
 |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  | 69
Spreadsheet: 839128d1691680236-formula-needed-to-sum-cells-based-on-content-of-another-cell-wc-certification-hours-tracking-etaf
Sheet: Emp 1

Class/Course Name | Course Date | Instructor / Certified Instructor Name(s) | In Person or Virtual | Curriculum Description | Hours Earned | State |  | State | Total Hours Earned
 |  |  |  |  | 1 | ca |  | CA |  | 120 Hours required for initial certification
 |  |  |  |  | 10 | al |  | AL
 |  |  |  |  | 100 | vt |  | VT
 |  |  |  |  | 1000 | [NAME] |  | AZ
 |  |  |  |  | 2 | ca
 |  |  |  |  | 20 | al
 |  |  |  |  | 200 | vt |  |  | I am needing a formula for cell J2 that will sum any values entered into column F if the state listed in I2 matches the state listed in column G. Thanks!
 |  |  |  |  | 2000 | [NAME]
 |  |  |  | TOTAL HOURS COMPLETED -
Spreadsheet: mary_fischer__25637__31T
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 31T
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 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 |  | -100
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -8461306
RE - Beg Bal |  | 0920 |  | -6366848
RE - Net Income |  | 0930 |  | -3724281 |  |  |  | 1815059
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
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
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 136862d1326852721-how-to-calculate-unknown-x-values-dnacalculate
Sheet: Plate

Plate | Repeat | End time | Start temp. | End temp. | BarCode
1 | 1 | 15:23:03 PM | 22.6 | 22.7 | N/A
485/535exc/emYui (Counts)
8038
1620 | 9859 | 30848
1869 | 13634 | 47621
1927 | 5995 | 9205
3226 | 3715 | 4594
16146 | 3574 | 3306
112921
1097635
Spreadsheet: louise_kitchen__22553__Hot List Update 07-17-01 - Management
Sheet: E-Commerce 50+

Deal Description Sheet - 7/17/01
[NAME]
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Andex | [NAME] | Andex | ATS accounting services and software. | 20000 | 2001-07-12 00:00:00 | 0.5 | 2001-07-01 00:00:00 | Andex has elected to pursue other options for their production management, however, [NAME] is interested in several ATS products.
Preston | [NAME] | Preston Energy | Sale of ATS software and/or ASP.  Enron commision from ATS. | 40000 | 2001-06-19 00:00:00 | 0.8 | 2001-09-01 00:00:00 | Preston is expected to purchase several of the ATS products.
Columbia Natural Resources | ?? |  | Application Service Provider, gas and liquids, E&P accounting, forecasting. | *$250,000 | 2001-04-16 00:00:00 | 0.5 | 2001-09-30 00:00:00 | ENA missed the supply deal, but is working on the outsourcing.  Lost to AEP who hid 3 1/4 for the pool gas.  ENA bid 1/4. CMR will start trading this summer.
VR84 | Nelson Ferries | Continental Land & Fur (CL&F) | ATS E&P accounting services and commodity management services | *$10,000 | 2001-07-13 00:00:00 | 0.9 | 2001-10-01 00:00:00 | ATS is currently providing E&P accounting services on VR 84.  CL&F has an additinoal 300 wells producing 100 mmcfd that they could take in kind.
Mariner | [NAME] | Mariner | Integrated outsourcing products. | *$100,000 | 2001-01-17 00:00:00 | 0.5 | 2001-10-01 00:00:00 | Follow up meeting in July, 2001.
Project Deep Blue Sea | [NAME] | Ocean Energy | Integrated outsourcing products and operations. | *$500,000 | 2001-06-11 00:00:00 | 0.5 | 2001-11-01 00:00:00 | Met with manager of operations on June 13th.  Met with Sr. Production Engineer regarding Harve Pipeline System and Field outsourcing on June 15th.  Additional data on pipeline and field will be made available in early July.
 |  |  |  |  |  |  |  | * Accrual
Spreadsheet: 226546d1365437721-i-have-a-spreadsheet-with-multiple-tabs-i-need-one-of-those-tabs-uploaded-to-outlook-cal-credentials-and-reappointment-data-spreadsheet
Sheet: Credential

Doctors | TMB | DEA | DPS | Board Certificate | TDI 11 | TDI 12 | Liability TMLT | Drivers License | Delineation of Priviliges | [NAME] | ACLS | Other
[NAME] | 2014-08-31 00:00:00 | 2015-07-31 00:00:00 | 2014-01-31 00:00:00 | X | X | X | X | 2014-05-22 00:00:00 |  |  | 2013-09-01 00:00:00
Beato | 2015-02-28 00:00:00 | 2015-07-31 00:00:00 | 2014-01-31 00:00:00 | No Recent | X | X | X | XXXX |  |  | 2010-03-01 00:00:00 | New York License : No License found
Choucair | 2013-11-30 00:00:00 | 2015-08-31 00:00:00 | 2014-02-28 00:00:00 | X | X | X | X | 2015-05-20 00:00:00 |  |  | XXXX
Coutin | 2013-08-31 00:00:00 | 2014-08-31 00:00:00 | 2014-02-28 00:00:00 | X |  |  | X | 2015-03-12 00:00:00 |  |  | 2013-09-01 00:00:00
[NAME] | 2014-08-31 00:00:00 | 2014-01-31 00:00:00 | 2013-06-30 00:00:00 | X | X | X | X | XXXX |  |  | 2013-09-01 00:00:00 | North Carolina :6/27/2013
Martinez | 2014-02-28 00:00:00 | 2014-01-31 00:00:00 | 2013-06-30 00:00:00 | No Recent | X | X | X | XXXX |  |  | 2013-09-01 00:00:00 | California License: 6/30/2014
McKinstry | 2015-05-31 00:00:00 | 2013-06-30 00:00:00 | 2014-01-31 00:00:00 | X |  |  | X | 2013-03-15 00:00:00 |  |  | 2013-09-01 00:00:00
Ormand | 2014-02-28 00:00:00 | 2015-12-31 00:00:00 | 2013-07-31 00:00:00 | X |  |  | X | 2013-10-23 00:00:00 |  |  | 2013-09-01 00:00:00
Pappas | 2014-02-28 00:00:00 | 2015-03-31 00:00:00 | 2013-07-31 00:00:00 | X |  |  | X | 2016-06-23 00:00:00 |  |  | 2013-09-01 00:00:00
Rodriguez | 2013-11-30 00:00:00 | 2015-04-30 00:00:00 | 2013-08-31 00:00:00 | X |  |  | X | 2016-10-20 00:00:00 |  |  | 2013-09-01 00:00:00 | California License:10/31/2014
[NAME] | 2013-11-30 00:00:00 | 2015-02-28 00:00:00 | 2013-09-30 00:00:00 | X |  |  | X | XXXX |  |  | 2013-09-01 00:00:00
Toth | 2014-08-31 00:00:00 | 2015-11-30 00:00:00 | 2013-10-31 00:00:00 | X | X | X | X | 2017-03-18 00:00:00 |  |  | 2013-09-01 00:00:00
Upmanyu | 2013-11-30 00:00:00 | 2014-05-31 00:00:00 | 2013-10-31 00:00:00 |  |  |  | X |  |  |  | 2013-09-01 00:00:00 | Michigan License: 1/31/2014
Missing = Not in PDF
Other Licenses
Spreadsheet: 103218d1300992504-how-to-make-a-scale-like-plot-of-job-positions-job-positions
Sheet: Sheet3

 | position | timein | timeout | level | months | months cumulative |  |  |  | month | level
1 | job1 | 1970-09-01 00:00:00 | 1975-05-31 00:00:00 | 0 |  |  |  |  |  | 0 | 10
 | job2 | 1976-01-01 00:00:00 | 1977-12-31 00:00:00 | 10 |  |  |  |  |  | 95 | 10
 | job3 | 1978-01-01 00:00:00 | 1984-01-01 00:00:00 | 10 |  |  |  |  |  | 95 | 12
 | job4 | 1984-01-02 00:00:00 | 1985-01-01 00:00:00 | 12 |  |  |  |  |  | 106 | 12
 | job5 | 1985-01-01 00:00:00 | 1989-01-01 00:00:00 | 13 |  |  |  |  |  | 106 | 13
 | job6 | 1989-01-01 00:00:00 | 1991-08-20 00:00:00 | 13 |  |  |  |  |  | 200 | 13
 | job7 | 1990-03-01 00:00:00 | 1990-05-01 00:00:00 | 13 |  |  |  |  |  | 200 | 14
 | job8 | 1990-05-01 00:00:00 | 1991-06-12 00:00:00 | 13 |  |  |  |  |  | 232 | 14
 | [NAME] | 1991-06-12 00:00:00 | 1994-03-01 00:00:00 | 14 |  |  |  |  |  | 232 | 15
 | job10 | 1994-03-01 00:00:00 | 1996-08-01 00:00:00 | 15 |  |  |  |  |  | 261 | 15
 | job11 | 1996-08-01 00:00:00 | 1997-03-26 00:00:00 | 16 |  |  |  |  |  | 261 | 16
 | job12 | 1997-03-26 00:00:00 | 1998-05-25 00:00:00 | 17 |  |  |  |  |  | 268 | 16
 | job13 | 1998-05-25 00:00:00 | 1998-07-25 00:00:00 | 18 |  |  |  |  |  | 268 | 17
 | [NAME] | 1998-07-25 00:00:00 | 1999-08-09 00:00:00 | 19 |  |  |  |  |  | 281 | 17
 | job15 | 1999-08-09 00:00:00 | 2000-05-07 00:00:00 | 20 |  |  |  |  |  | 281 | 18
 | job16 | 1999-12-31 00:00:00 | 2008-05-07 00:00:00 | 21 |  |  |  |  |  | 283 | 18
 | job17 | 2008-05-08 00:00:00 | 2011-03-24 00:00:00 | 20 |  |  |  |  |  | 283 | 19
 |  |  |  |  |  |  |  |  |  | 295 | 19
 |  |  |  |  |  |  |  |  |  | 295 | 20
 |  |  |  |  |  |  |  |  |  | 303 | 20
 |  |  |  |  |  |  |  |  |  | 303 | 21
 |  |  |  |  |  |  |  |  |  | 403 | 21
 |  |  |  |  |  |  |  |  |  | 403 | 20
 |  |  |  |  |  |  |  |  |  | 437 | 20
Spreadsheet: 22842d1212001628-variation-to-pulldown-lists-and-populating-data-example1
Sheet: Sheet1

FRUIT | CODE
Apples | 10145
Oranges | 10146
Bananas | 10147
Pears | 10148
Cherries | 10149
ORDERS
NAME | DATE | FRUIT | CODE
[NAME] | 2008-05-25 00:00:00
[NAME] | 2008-05-26 00:00:00
Spreadsheet: 889562d1740413736-field-concatenation-with-space-and-hypen-removal-concatenatewithnospacesorhyphens
Sheet: Sheet1

Id | Last Name | First Name | Middle Initial | Needed Concatenation | Conactenated
1234578 | Sanchez Dominguez | [NAME] | G | SanchezDominguezMaryRoseG-1234578 | Sanchez DominguezMary RoseG-1234578
7854321 | [NAME] | Jessica |  | HartmanSmithJessica-7854321 | [NAME]
5556845 | Freedman-Murry | [NAME] | H L | FreedmanMurryJacobHL-5556845 | FreedmanMurryJacobH L-5556845
Spreadsheet: 880589d1728402100-filtering-worksheet-issues-teamtasks_v1
Sheet: Main_dataset

ACTIVITY | ASSIGNEE | DATE | COMMENTS
[NAME]
Buy apples | [NAME] | complete | pink lady
Buy bananas | [NAME] | canceled
Buy melons | [NAME] | 2024-10-12 00:00:00 | green preferred, orange if no green
Buy oranges | [NAME] | 2024-10-13 00:00:00
Return glass bottles | [NAME] | 2024-10-13 00:00:00 | 100 bottles
Post Office
Buy stamps | [NAME] | canceled - already had | $100 worth
Pick up mailing boxes | [NAME] | 2024-10-15 00:00:00
Mail packages | [NAME] | 2024-10-17 00:00:00 | send first-class
October Needs
Pay phone bill | [NAME] | completed
Pay bank statement | Alex/Jill | 2024-10-10 00:00:00
Pay utilities | [NAME] | 2024-10-12 00:00:00
Pay rent | [NAME] | 2024-10-14 00:00:00
Spreadsheet: 0b906d70-46b5-4ac4-9e1a-552ce85c7f5a
Sheet: Sheet 2

 |  |  |  | 97 Tournament
Group A |  |  | Group B |  |  | Group C
1 | IL |  | 5 | IA |  | 9 | MI
2 | OS |  | 6 | NE/KS |  | 10 | ON
3 | WI |  | 7 | MN |  | 11 | ND/SD
4 | MO |  | 8 | KY |  | 12 | IN
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: September

 |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
 |  | 2010-09-01 00:00:00 |  | 2010-09-02 00:00:00 |  | 2010-09-03 00:00:00 |  | 2010-09-04 00:00:00 |  | 2010-09-06 00:00:00 |  | 2010-09-07 00:00:00 |  | 2010-09-08 00:00:00 |  | 2010-09-09 00:00:00 |  | 2010-09-10 00:00:00 |  | 2010-09-11 00:00:00 |  | 2010-09-13 00:00:00 |  | 2010-09-14 00:00:00 |  | 2010-09-15 00:00:00 |  | 2010-09-16 00:00:00 |  | 2010-09-17 00:00:00 |  | 2010-09-18 00:00:00 |  | 2010-09-20 00:00:00 |  | 2010-09-21 00:00:00 |  | 2010-09-22 00:00:00 |  | 2010-09-23 00:00:00 |  | 2010-09-24 00:00:00 |  | 2010-09-25 00:00:00 |  | 2010-09-27 00:00:00 |  | 2010-09-28 00:00:00 |  | 2010-09-29 00:00:00 |  | 2010-09-30 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultant | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Lehlohonolo | 0 |  | 0 | 0 |  | -
Matshidiso | 0 |  | 0 | 0 |  | -
Rachel | 0 |  | 0 | 0 |  | -
Naledi G | 0 |  | 0 | 0 |  | -
Innocentia | 0 |  | 0 | 0 |  | -
Glyndine | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: 185096d1349476750-goal-log-setup-personal-goal-tracking
Sheet: Sheet2

 | [NAME] |  | Count the date >>>
 | Current streak |  | or Y,n and o which way you choose
Spreadsheet: 837467d1690199539-turning-formula-results-to-text-strat-calculations
Sheet: Sheet2

 | W# | HBP# | HIT# | D | T | HR
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
 | WALK
* RESULT FROM SHEET 1, CELL O4 IS 15. THEREFORE, I NEED THE LABEL "WALK" TO BE LISTED 15 TIMES AS SHOWN ABOVE. ANY RESULT THAT EQUAL "0" OR A NEGATIVE NUMBER IS TO REMAIN BLANK.
Spreadsheet: 771745d1646829312-countif-and-vlookup-help-mycasedemodata
Sheet: Lookup

Town | Case1 | Case 2 | Case 3 |  |  | Result Table
Lae | Covid | Covid | Covid |  |  | Town | Covid | TB | Malaria | AIDS | Total
EHP | Covid | Covid | Covid |  |  | Lae
Wabag | TB | TB | TB |  |  | EHP
Lae | AIDS | Malaria | Malaria |  |  | Wabag
Mt Hagen | Covid | Covid | Covid |  |  | Mt Hagen
Madang | Covid | Covid | Covid |  |  | Manus
Manus | Malaria | AIDS | Malaria |  |  | NCD
Lae | Covid | Covid | Covid |  |  | Madang
NCD | Covid | Covid | Covid |  |  | Tari
NCD | TB | AIDS | Covid |  |  | AROB
Tari | AIDS | Covid | Malaria |  |  | [NAME]
AROB | AIDS | TB | TB |  |  | Daru
[NAME] | AIDS | Covid | TB |  |  | Oro
Daru | TB | Covid | TB
Oro | TB | Malaria | Covid
Daru | TB | Malaria | Covid
Lae | AIDS | TB | TB
Madang | Covid | AIDS | AIDS
Spreadsheet: 713633d1610842978-using-averageif-statement-with-or-roundavgifor-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | PACE | FINAL
 |  | RACE # | F | Distance | Conditions |  | PACE # | FINAL # | PACE PAR | FINAL PAR | DIFFERENCE | DIFFERENCE
 |  | 1 | f | 6f | 20K |  | 99 | 98 | 96 | 96 | 3 | 2
 |  | 2 | f | 6f | 16KN3L |  | 98 | 92 | 100 | 100 | -2 | -8
 |  | 3 | f | 6f | sMSW |  | 92 | 101 | 102 | 102 | -10 | -1
 |  | 4 | 0 | 5.5 | 6250 |  | 101 | 103 | 98 | 98 | 3 | 5
 |  | 5 | 0 | 1m | [NAME] |  | 103 | 112 | 96 | 96 | 7 | 16
 |  | 6 | 0 | 1.0625 | AO502X |  | 112 | 108 | 101 | 101 | 11 | 7
 |  | 7 | f | 1.0625 | MSW |  | 108 | 106 | 106 | 106 | 2 | 0
 |  | 8 | 0 | 5.5 | Als10 |  | 106 | 107 | 101 | 101 | 5 | 6
 |  | 9 | 0 | 1m | 8000 |  | 107 | 97 | 102 | 102 | 5 | -5
 |  | 10
 |  | 11
 |  | 12
 |  |  |  |  |  |  |  |  |  | SPRINT PACE VARIANT | -3
 |  |  |  |  |  |  |  |  |  | SPRINT FINAL VARIANT | -2
 |  |  |  |  |  |  |  |  |  | ROUTE PACE VARIANT
 |  |  |  |  |  |  |  |  |  | ROUTE FINAL VARIANT
Spreadsheet: 168650d1342535082-vlookup-using-multiple-table_array-vlookup400
Sheet: Sheet2

15336 | vege singara | 786 | surf excel
3781 | [NAME] | 1731 | green chilli
1731 | green chilli | 3781 | [NAME]
786 | surf excel | 8080 | GF sugar
8080 | GF sugar | 15336 | vege singara
Spreadsheet: 100825d1299062486-if-formula-help-little-bit-complicated-test2
Sheet: Sheet1

 |  |  |  |  |  | AAA |  |  | BBB |  |  | CCC |  |  | DDD
 |  |  |  |  |  | Req by | 2011-03-15 00:00:00 |  | Req by | 2011-03-15 00:00:00 |  | Req by | 2011-03-15 00:00:00 |  | Req by | 2011-03-15 00:00:00
 |  |  |  | STATUS | Stock | Required  QTY | Promise Date | [NAME] | Required  QTY | Promise Date | [NAME] | Required  QTY | Promise Date | [NAME] | Required  QTY | Promise Date | [NAME]
 |  |  |  | A | 500 | 100 | 2011-03-10 00:00:00 |  | 100 |  |  | 100 |  |  | 100
 |  |  |  | B | 500 | 50 | 2011-03-10 00:00:00 |  | 50 |  |  | 50 |  |  | 50
 |  |  |  | C | 500 | 50 | 2011-03-10 00:00:00 |  | 50 |  |  | 50 |  |  | 50
 |  |  |  | D | 500 | 200 | 2011-03-20 00:00:00 |  | 200 |  |  | 200 |  |  | 200
 |  |  |  | E | 500 | 200 | 2011-03-20 00:00:00 |  | 200 |  |  | 200 |  |  | 200
 |  |  |  | A | 500 | 200 | 2011-03-20 00:00:00 |  | 200 |  |  | 200 |  |  | 200
 |  |  |  | B | 500 | 20 | 2011-03-20 00:00:00 |  | 20 |  |  | 20 |  |  | 20
 |  |  |  | A | 500 | 50 | 2011-03-20 00:00:00 |  | 50 |  |  | 50 |  |  | 50
 |  |  |  | B | 500 | 50 | 2011-03-10 00:00:00 |  | 50 |  |  | 50 |  |  | 50
 |  |  |  | C | 500 | 250 | 2011-03-10 00:00:00 |  | 250 |  |  | 250 |  |  | 250
 |  |  |  | A | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 50 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 100 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | A | 200 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 200 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 2000 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | A | 200 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 50 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | A | 100 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | A | 2000 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 50 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | A | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | B | 50 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 200 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | D | 50 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | E | 100 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | C | 200 | 0 | 2011-03-20 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | D | 200 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | E | 2000 | 0 | 2011-03-10 00:00:00 |  | 0 |  |  | 0 |  |  | 0
Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: InterestExpense

INTEREST EXPENSE & TOTAL DEBT
(Millions of Dollars)
 |  | 2001-12-31 00:00:00 |  | 2002-01-30 00:00:00 |  | 2002-02-28 00:00:00 |  | 2002-03-30 00:00:00 |  | 2002-04-30 00:00:00 |  | 2002-05-30 00:00:00 |  | 2002-06-30 00:00:00 |  | 2002-07-30 00:00:00 |  | 2002-08-30 00:00:00 |  | 2002-09-30 00:00:00 |  | 2002-10-30 00:00:00 |  | 2002-11-30 00:00:00 |  | 2002-12-30 00:00:00 |  | 2002 FY
BALANCE SHEET DEBT (All 3rd Party)
 | Short-Term Debt
 | Long-Term Debt
 | Debt Discount
 | Total Debt
INTEREST EXPENSE
 | L/T Debt (Financing) |  |  | 2.9 |  | 2.9 |  | 2.8 |  | 2.9 |  | 2.9 |  | 2.8 |  | 2.9 |  | 2.9 |  | 2.8 |  | 2.9 |  | 2.9 |  | 2.9
 | S/T Debt (Financing) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other (Financing) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Interest Rate Swaps (Fin) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Interest Expense  - Trade (Surcharge) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.1 |  | 0
 | Interest Income - ETS Intercompany (Fed. Funds Rate) |  |  | -1 |  | -1 |  | -1.1 |  | -1.1 |  | -1.2 |  | -1.1 |  | -1.1 |  | -1.1 |  | -1 |  | -1 |  | -0.9 |  | -0.9
 | - Other |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Consolidating Subs (Fin) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Other - Cons Sub |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Amort of Debt Discount (Fin) |  |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0.1 |  | 0 |  | 0 |  | 0.1
 | Discount AR (Fin) |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Interest Capitalized |  |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | -0.1 |  | -0.1 |  | -0.1
 | Total Interest Expense
 | Check # (line 51)
ETS INTERCO. INTEREST ITEMS (Income Statement Impact)
 | Interest Income - ETS Intercompany (Fed. Funds Rate)
 | Income Before Income Taxes
 | Income Taxes
 | Current Payable
 | Payment Deferred |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total
 | Net Income After Financing Costs
Spreadsheet: eric_saibi__9926__102901R
Sheet: Three Mile Island 01

Owner Name |  | AmerGen Energy Company
Station Name |  | Three Mile Island Nuclear Power Station
Unit Name |  | Three Mile Island 01
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Nuclear
Capacity |  | 872 MW
Start Date |  | 2001-10-08 00:00:00
End Date |  | 2001-11-11 00:00:00
Prv. Start Date |  | 2001-10-08 00:00:00
Prv. End Date |  | 2001-11-04 00:00:00
Comments |  | Refuel
SIC |  | 4931
Plant ID |  | 1019884
Unit ID |  | 1004233
Outage ID |  | 7838