tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 757932d1638540294-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 2 & QAF (John)

[NAME] |  |  |  |  |  |  |  |  |  |  | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Learning | Openings Sign Off | Openings Sign Off | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | Middles Learning | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Closures Sign Off | Closures Sign Off |  | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF | QAF
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date TPP Commenced | TUD Date | Cohort | Expected TPP Week | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | [NAME] | Expected QAF Milestone 1 (Week 10) | Actual Milestone 1 Completion | Formula 2 | Expected QAF Milestone 2 (Week 22) | Actual [NAME] | Formula 5 | Expected QAF Milestone 3 (Week 38) | Actual [NAME] | [NAME] | Expected QAF Milestone 4 (Week 52) | Actual [NAME] | Forumula 9 | Expected QAF Milestone 5 (Week 69) | Actual [NAME] | [NAME] 10 | Expected QAF Milestone 6 (Week 78) | Actual [NAME] | [NAME] | Expected QAF Completion (18 months) | Actual QAF Completion | [NAME] 12 | Exceptions
Spreadsheet: john_lavorato__16496__OGC Cheques - 2000
Sheet: Shannon Goritz

Order of [NAME]
Donations for deputy | [NAME]
CompanyName | FirstName | Initial | LastName | As it appears in the Brochure… | Address 1 | Address2 | City | Province | PostalCode | Donation | Category | Tax Receipt to Individual? | notes | Deputy | website address
Investors Group - Calgary Centre Office | Guy |  | Rivard | Investors Group - Calgary Centre Office | 100, 1333 - 8 St SW |  | Calgary | AB | T2R 1M6 | 1000 | [NAME] | Company |  | [NAME] | www.investorsgroup.com
Spreadsheet: 538709d1505784532-how-can-i-calculate-based-on-two-variables-example
Sheet: Sheet1

Country | Year | Units | Local Currency | USD | Out Come that I need |  |  | Exchange Rate
Argentina | 2016-06-01 00:00:00 | 20 | 53000 | x |  |  |  | Country | Date | Currency
Argentina | 2016-07-01 00:00:00 | 25 | 43000 | x |  |  |  | Argentina | 2016-06-01 00:00:00 | 18.7
Peru | 2016-06-01 00:00:00 | 10 | 20000 | x |  |  |  | Argentina | 2016-07-01 00:00:00 | 19.1
Ecuador | 2016-08-01 00:00:00 | 15 | 15000 | x |  |  |  | Argentina | 2016-08-01 00:00:00 | 17.5
 |  |  |  |  |  |  |  | Peru | 2016-06-01 00:00:00 | 15.5
 |  |  |  |  |  |  |  | Peru | 2016-07-01 00:00:00 | 15.7
 |  |  |  |  |  |  |  | Peru | 2016-08-01 00:00:00 | 15.9
I need to calculate the Local Currency / Exchange Rate (based on year and country) |  |  |  |  |  |  |  | Ecuador | 2016-06-01 00:00:00 | 17.1
in a whole formula |  |  |  |  |  |  |  | Ecuador | 2016-07-01 00:00:00 | 17.2
 |  |  |  |  |  |  |  | Ecuador | 2016-08-01 00:00:00 | 17.5
Spreadsheet: mary_fischer__25613__32H
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER CURRENT LIABILITIES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-00 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Accrued insurance W/C |  |  |  |  |  |  |  | -160976
Accrued Construction Reserve |  | -700000 |  | 700000
Billings in excess of costs |  | 11542629 |  | -6739094 |  |  |  | 1537336
Accrued Coins Variance (Remapped to 0860) |  | -29013 |  | 29013
Deferred Service Revenue (Remapped to 0860) |  | -173053 |  | 173053
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 62583 | 62583
Cross_Currency Fixed-Fixed | 0 | 4030 | 4030
Cross_Currency Fixed-Float | 0 | 7764 | 7764
TOTAL | 0 | 74377 | 74377
Spreadsheet: 559c4ca0-8023-4489-947c-75f8c9ebeeaf
Sheet: Sheet1

THE UNIVERSITY OF TULSA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
COLLEGE OF ARTS AND SCIENCES | Name_____________________________ | ID#______________________
Area of Concentration Requirements | Major:  Anthropology (BA)
 |  | HR | GR | SM
1.        You must have a minimum GPA of 2.2 | Core Requirements:
in your area of concentration and a minimum of | Anth 2023 Foundations of Linguistics | _____ | _____ | _____
2.0 TU GPA in order to graduate. | Anth 2033 Human Development | _____ | _____ | _____
 | Anth 2043 Patterns in Culture:  Cultural Anthro | _____ | _____ | _____
2.        No Pass/D/F or CLEP credit may be | [NAME] Cultures Before History:  Archaeology | _____ | _____ | _____
applied toward your Area of Concentration.
 | Electives:  12 hours required including at least 3 hours in archaeology/physical anthropology
3.    Courses applied to meet Core and General | and 3 hours in cultural anthropology/linguistics.
Curriculum requirements may not also apply in | Archaeology/Physical Anthropology Area:  Anth 2114, Anth 2233, Anth 3133, Anth 4033, Anth 4043,
your Area of Concentration. | Anth 4113-6, Anth 4223, Anth 4503, Anth 4513.
4.   Two thirds of the course work in your | Cultural Anthropology/Linguistics Area:  Anth 1063, Anth 3103, Anth 3123, Anth 3163, Anth 3173,
Major [NAME] must be at the 3000 or 4000 level. | Anth 3443, Anth 4013, Anth 4083, Anth 4213-6, Anth 4403, Anth 4633.
 | ___________________________________ | _____ | _____ | _____
5.     Subjects in your Minor Field must be | ___________________________________ | _____ | _____ | _____
selected in conjunction with your [NAME] | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
6.  No more than 55 hours may be earned in the
Area of Concentration, and no more than 39 of | Research Methods:  3 hours required | _____ | _____ | _____
these may be earned in the major subject. | Anth 4053 Archaeological Issures OR | _____ | _____ | _____
These totals may be exceeded only by the | Anth 4063 Qualitative Research Methods | _____ | _____ | _____
number of hours beyond the 124 required for | ___________________________________ | _____ | _____ | _____
graduation.
 | Theory:  3 hours required
 | Anth 4763 History of Anthropological Theory | _____ | _____ | _____
[NAME]:  __________________________
 | [NAME] Senior Seminar
 | Senior Project:  3 hourse required
 | Anth 4003, Senior  Seminar in Anthropology | _____ | _____ | _____
 | Minor - 12 hours with 6 hours 3000-4000 level.
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
Spreadsheet: 87809d1287669963-changing-value-from-series-of-data-ma1ma2
Sheet: Sheet1

Date | MA1 | MA2 | Action
2010-04-21 00:00:00 | 2477 | 2480 | S
2010-04-22 00:00:00 | 2473 | 2479 | S
2010-04-23 00:00:00 | 2477 | 2479 | S
2010-04-26 00:00:00 | 2493 | 2483 | B
2010-04-27 00:00:00 | 2485 | 2482 | B
2010-04-28 00:00:00 | 2478 | 2481 | S
2010-04-29 00:00:00 | 2489 | 2483 | B
2010-04-30 00:00:00 | 2491 | 2484 | B
2010-05-03 00:00:00 | 2480 | 2482 | S
2010-05-04 00:00:00 | 2468 | 2479 | S
2010-05-05 00:00:00 | 2457 | 2475 | S
2010-05-06 00:00:00 | 2437 | 2468 | S
2010-05-07 00:00:00 | 2409 | 2457 | S
2010-05-10 00:00:00 | 2424 | 2455 | S
2010-05-11 00:00:00 | 2412 | 2448 | S
2010-05-12 00:00:00 | 2393 | 2438 | S
2010-05-13 00:00:00 | 2387 | 2431 | S
2010-05-14 00:00:00 | 2373 | 2422 | S
2010-05-17 00:00:00 | 2346 | 2409 | S
2010-05-18 00:00:00 | 2338 | 2399 | S
2010-05-19 00:00:00 | 2315 | 2386 | S
2010-05-20 00:00:00 | 2307 | 2375 | S
2010-05-21 00:00:00 | 2298 | 2364 | S
2010-05-24 00:00:00 | 2300 | 2356 | S
2010-05-25 00:00:00 | 2281 | 2345 | S
2010-05-26 00:00:00 | 2268 | 2334 | S
2010-05-27 00:00:00 | 2282 | 2329 | S
2010-05-28 00:00:00 | 2301 | 2328 | S
2010-05-31 00:00:00 | 2327 | 2331 | S
2010-06-01 00:00:00 | 2321 | 2329 | S
2010-06-02 00:00:00 | 2321 | 2328 | S
2010-06-03 00:00:00 | 2332 | 2330 | B
2010-06-04 00:00:00 | 2332 | 2330 | B
2010-06-07 00:00:00 | 2301 | 2323 | S
2010-06-08 00:00:00 | 2289 | 2317 | S
2010-06-09 00:00:00 | 2291 | 2314 | S
2010-06-10 00:00:00 | 2308 | 2315 | S
2010-06-11 00:00:00 | 2350 | 2325 | B
2010-06-14 00:00:00 | 2365 | 2332 | B
2010-06-15 00:00:00 | 2384 | 2341 | B
2010-06-16 00:00:00 | 2388 | 2347 | B
2010-06-17 00:00:00 | 2385 | 2352 | B
2010-06-18 00:00:00 | 2401 | 2360 | B
2010-06-21 00:00:00 | 2431 | 2372 | B
2010-06-22 00:00:00 | 2433 | 2380 | B
2010-06-23 00:00:00 | 2434 | 2387 | B
2010-06-24 00:00:00 | 2444 | 2395 | B
2010-06-25 00:00:00 | 2448 | 2402 | B
2010-06-28 00:00:00 | 2463 | 2412 | B
2010-06-29 00:00:00 | 2451 | 2415 | B
2010-06-30 00:00:00 | 2455 | 2421 | B
2010-07-01 00:00:00 | 2442 | 2422 | B
2010-07-02 00:00:00 | 2417 | 2418 | S
2010-07-05 00:00:00 | 2388 | 2411 | S
2010-07-06 00:00:00 | 2379 | 2406 | S
2010-07-07 00:00:00 | 2375 | 2401 | S
2010-07-08 00:00:00 | 2381 | 2400 | S
2010-07-09 00:00:00 | 2387 | 2399 | S
2010-07-12 00:00:00 | 2416 | 2404 | B
2010-07-13 00:00:00 | 2443 | 2413 | B
2010-07-14 00:00:00 | 2455 | 2420 | B
2010-07-15 00:00:00 | 2447 | 2422 | B
2010-07-16 00:00:00 | 2442 | 2424 | B
2010-07-19 00:00:00 | 2429 | 2423 | B
2010-07-20 00:00:00 | 2421 | 2422 | S
2010-07-21 00:00:00 | 2414 | 2420 | S
2010-07-22 00:00:00 | 2416 | 2419 | S
2010-07-23 00:00:00 | 2438 | 2425 | B
2010-07-26 00:00:00 | 2455 | 2430 | B
2010-07-27 00:00:00 | 2452 | 2433 | B
Spreadsheet: e6cb7eac-6cef-4f89-b115-f71e0a7d2293
Sheet: Tabelle1

[NAME]
Aktuelles Datum: |  |  |  |  |  | Summe offene [NAME]:
[NAME] | Kunden- nummer | Name des Kunden | [NAME] betrag | [NAME] datum | [NAME] in Tagen | Fälligkeits- datum | Zahlungs- eingang (Datum) | [NAME] (Euro) | [NAME]? | 1. Mahnung? | 2. Mahnung?
120 | 1 | Mustermann | 1000 | 2011-05-01 00:00:00 | 30 |  | 2011-05-30 00:00:00 | 1000 |  |  |  |  | Zahlungserinnerung |  | 1 | Tage nach Fälligkeit
121 | 2 | [NAME] | 5800 | 2011-05-01 00:00:00 | 30 |  | 2011-05-20 00:00:00 | 800 |  |  |  |  | 1. Mahnung nach |  | 14 | Tage nach Zahlungserinnerung
122 | 3 | Frau Meyer | 2000 | 2011-05-01 00:00:00 | 30 |  |  | 0 |  |  |  |  | 2. Mahnung nach |  | 30 | Tage nach Fälligkeit
 |  |  | 1800 | 2011-06-01 00:00:00 | 30 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: [NAME] anpassen, wie viele Tage
 |  |  |  |  |  |  |  |  |  |  |  |  | nach [NAME] eine [NAME] bzw.
 |  |  |  |  |  |  |  |  |  |  |  |  | eine Mahnung verschicken wollen. [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | gilt dann für alle offenen Posten
Copyright: handwerk.com 2011 (jw)
Spreadsheet: 181254d1347976281-get-info-from-three-other-tabs-into-a-fourth-tab-for-one-single-entry-without-vba-solutiontest
Sheet: Addrss

Loan Number | Other Data | Other Data 2 | Other data 3 | other data 4 | Pcity | Pstate | Pzip
7321 | 6464654 | [NAME] | 654564 | srth | HOLTSVILLE | NY | 00501
7123 | 654654654 | sgjhsfghst | 6546 | thshs | HOLTSVILLE | NY | 00544
7654 | 654654654 | sfjsftgjhsf | 4354 | rthw | Wesley Chapel | FL | 33543
7456 | 6879687987 | [NAME] | 64634 | rh | Tampa | FL | 33617
7987 | 654654654 | hsrtjhsrtjhhsr | 84654 | wrt | AGUADILLA | PR | 00603
7789 | 687486789 | ftjhsfjs | 6865 | hwrtjhwrtj | AGUADILLA | PR | 00604
8123 | 654654 | fgjhsrjsd | 8535 | wrjhrthwrtuwr | AGUADILLA | PR | 00605
8321 | 9687894 | rjsdrj | 8684 | tujrjrtjrj | MARICAO | PR | 00606
8456 | 684684968 | erje | 685 | [NAME] | ANASCO | PR | 00610
Spreadsheet: 133315d1324329578-using-conditional-formatting-to-highlight-celss-vacationrecord2011_example_hsb
Sheet: 1

VACATION RECORD 2011 (YTD)
Name | ID | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Days |  | Start | End
PHILIP |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3, 10, 18, 26, 30 | 5, 15, 22, 27, 31
EVANGELINE |  | January
LEA |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5, 11 | 7, 17
DEXTER |  | February
[NAME] |  | March
MARILOU |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 29
MARIA |  | April
ARNULFO |  | May
[NAME] |  | May
FRANCISCO |  | May
ARNULFO |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15,24 | 21,29
MARIA |  | July
DEXTER |  | August
[NAME] |  | September
FRANCISCO |  | October
MARIA |  | November
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: BS

BALANCE SHEET
 |  | 0
('000 $) |  | Close
Assets
Cash |  | 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
Accounts Receivable |  | 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
Inventories |  | 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
Other Current Assets |  | 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
Debt Service Reserve |  | 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
Total Current Assets
Gross PP&E
Accumulated Depreciation |  | 0
Net PP&E
Land
Other Assets |  | 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
Total Assets
Liabilities
Accounts Payable |  | 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
Accrued Expenses |  | 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
Deferred Tax Liability |  | 0
Working Capital Revolver |  | 0
Long Term Debt
Other Non-Current Liabilities |  | 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
Total Long-term Liabilities
Stockholders' Equity
Paid-In-Capital
Retained earnings
Total stockholders' equity
Total Liabilities & Equity
Proof
Spreadsheet: eric_saibi__9716__010702
Sheet: Colstrip 03

Owner Name |  | PPL Montana LLC
Station Name |  | Colstrip Power Station
Unit Name |  | Colstrip 03
NERC Region |  | WSCC
State |  | MT
Fuel Type |  | Coal
Capacity |  | 778 MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-12 00:00:00
Comments |  | Unit is down with a generator ground fault problem.
SIC |  | 4931
Plant ID |  | 1015370
Unit ID |  | 1007494
Outage ID |  | 19382
Spreadsheet: 124974d1318781429-replacing-html-entity-codes-with-actual-characters-html-replace
Sheet: Data

&quot; | " | quotation mark
&apos; | ' | apostrophe
&amp; | & | ampersand
&lt; | < | less-than
&gt; | > | greater-than
&nbsp; |  | non-breaking space
&iexcl; | ¡ | inverted exclamation mark
&cent; | ¢ | cent
&pound; | £ | pound
&curren; | ¤ | currency
&yen; | ¥ | yen
&brvbar; | [NAME] | broken vertical bar
&sect; | § | section
&uml; | ¨ | spacing diaeresis
&copy; | © | copyright
&ordf; | ª | feminine ordinal indicator
&laquo; | « | angle quotation mark (left)
&not; | ¬ | negation
&shy; |  | soft hyphen
&reg; | ® | registered trademark
&macr; | ¯ | spacing macron
&deg; | ° | degree
&plusmn; | ± | plus-or-minus
&sup2; | ² | superscript 2
&sup3; | ³ | superscript 3
&acute; | ´ | spacing acute
&micro; | µ | micro
&para; | ¶ | paragraph
&middot; | · | middle dot
&cedil; | ¸ | spacing cedilla
&sup1; | ¹ | superscript 1
&ordm; | º | masculine ordinal indicator
&raquo; | » | angle quotation mark (right)
&frac14; | [NAME] | fraction 1/4
&frac12; | ½ | fraction 1/2
&frac34; | ¾ | fraction 3/4
&iquest; | ¿ | inverted question mark
&times; | × | multiplication
&divide; | ÷ | division
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: Mgmt Summary

ENRON GLOBAL MARKETS
3RD QUARTER 2000 EARNINGS ESTIMATE
Results based on activity through September 14, 2000
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Liquids |  | 20000 | 14096 | 5904 |  | 14561 | 0 | 0 | 14561 |  | 0 | 8800 | 5296 | 465 |  | -5439 |  | 0 | 0 | 0 | -5439
Coal |  | 12747 | 4881.7 | 7865.3 |  | -5915.184999999999 | 0 | 0 | -5915.184999999999 |  | 665 | 3491.292 | 2476 | -12547.477 |  | -18662.185 |  | 118 | -1034.492 | -834 | -20413
Emissions |  | 750 | 340.5 | 409.5 |  | 2380 | 0 | 0 | 2380 |  | 0 | 178.61 | 236.4 | 1964.99 |  | 1630 |  | 0 | -74.51 | 0 | 1555
Weather |  | 3215 | 1655.8 | 1559.2 |  | 3721.8 | 0 | 0 | 3721.8 |  | 0 | 882.6 | 773.2 | 2066 |  | 506.8 |  | 0 | 0 | 0 | 507
Global Risk Markets |  | 7712 | 1618.2 | 6093.8 |  | 0 | 0 | 0 | 0 |  | 0 | 1582.2 | 446 | -2028.2 |  | -7712 |  | 0 | 0 | -410 | -8122
Financial Trading |  | 8947 | 3377.4 | 5569.6 |  | 13848.419 | 0 | 0 | 13848.419 |  | 0 | 1768.513 | 1822.594 | 10257.312 |  | 4901.419 |  | 0 | -213.8129999999999 | 0 | 4688
Agricultural Trading |  | 0 | 0 | 0 |  | -47.714 | 0 | 0 | -47.714 |  | 0 | 101.936 | 0 | -149.65 |  | -47.714 |  | 0 | -101.936 | 0 | -150
Overview |  | 6786 | 0 | 6786 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | -6786 |  | 0 | 0 | 0 | -6786
Office of the Chairman |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 350 | 0 | -350 |  | 0 |  | 0 | -350 | 0 | -350
Total Commercial |  | 60157 | 25969.6 | 34187.4 |  | 28548.32 | 0 | 0 | 28548.32 | 0 | 665 | 17155.151 | 11050.194 | -322.0250000000018 | 0 | -31608.68 | 0 | 118 | -1774.751 | -1244 | -34510
Group |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  | 0 | 11050.194 | -11050.194 | 0 |  | 0 |  | 0 | 0 | 0 | 0
Other Interest Related Charges |  | -538.419 | 0 | -538.419 |  | -538.419 | 0 | 0 | -538.419 |  | 0 | 0 | 0 | -538.419 |  | 0 |  | 0 | 0 | 0 | 0
Capital Charge Offset |  | 0 | -783 | 783 |  | 0 | 0 | 0 | 0 |  | -665 | 0 | 0 | 665 |  | 0 |  | -118 | 0 | 0 | -118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Global Markets EBIT |  | 59618.581 | 25186.6 | 34431.98099999999 |  | 28009.901 | 0 | 0 | 28009.901 | 0 | 0 | 28205.345 | 0 | -195.4440000000031 |  | -31608.68 | 0 | 0 | -1774.751 | -1244 | -34628
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  | 0 | -1336 | 1336 |  | 0 | 0 | 0 | 0 |  | 0 | -1336 | 0 | 1336 |  | 0 |  | 0 | 0 | 0 | 0
Global Markets Pre-tax Income |  | 59618.581 | 23850.6 | 35767.98099999999 |  | 28009.901 | 0 | 0 | 28009.901 | 0 | 0 | 26869.345 | 0 | 1140.555999999997 |  | -31608.68 | 0 | 0 | -1774.751 | -1244 | -34628
 |  |  |  | MPR Change: |  | 0
(1) Includes capital charge, direct, and allocated expenses
Spreadsheet: 86397d1286384637-trendlines-in-two-separate-intervals-scratch
Sheet: Sheet1

temp | elong |  | a | b
33 |  |  |  | -7022.900500000001
34
35
36
37
 |  |  | c | d
38 |  |  |  | -14575.44754285714
39
40 |  |  | x | y
41
42
43
Spreadsheet: 45989d1244755352-conditional-formatting-conditiona-format-2
Sheet: Sheet1

 | Overall Estimate - Detail |  |  | Estimate Values |  |  | Event   Estimate | [NAME] | Actual Invoice (USD) | Actual Invoice (CAD) | Actual Billable - Recoverable |  |  | Non Billable Amounts
 | Mobile Unit | Steps |  | 1 |  | Billable | 1 |  |  |  | 0 |  |  | 0 | Expected result
 |  | Steps |  |  |  | Billable | 0 |  | 1 |  | 1 |  |  | 0 | Expected result
 | Mobile Unit | Steps |  | 1 |  | Billable | 1 |  |  | 1 | 1 |  |  | 0 | Expected result
 | Mobile Unit | Steps |  | 1 |  | Billable | 1 |  | 1 |  | 1 |  |  | 0
 |  | Steps |  |  |  | Billable | 0 |  |  | 1 | 1 |  |  | 0 | Expected that cell I10 would have turned yellow
 |  | Steps |  |  |  | Billable | 0 |  |  |  | 0 |  |  | 0
Spreadsheet: 455498d1460376280-sum-if-with-index-and-match-sample-1-
Sheet: Sheet4

City | Customer | Size | Sum of Order Quantity
Goa | Gupta-1 | 100-299 | 3000
 | Gupta-2 | 100-299 | 6000
 | Sharma-1 | 100-299 | 19203
 |  | 300-499 | 33900
 | Sharma-2 | 300-499 | 30600
 | Sharma-3 | 100-299 | 35240
 | Sharma-4 | 100-299 | 5054
 |  | 300-499 | 1926
 | Sharma-5 | 300-499 | 7704
Goa Total |  |  | 142627
Kerala | Peter-1 | 300-499 | 20000
 | Peter-12 | 100-299 | 9224
 |  | 300-499 | 0
 | Peter-15 | 100-299 | 12
 | Robot-1 | 100-299 | 42
 |  | 300-499 | 3006
 | Robot-3 | 100-299 | 11
 | Robot-4 | 100-299 | 5.5
 |  | 300-499 | 3012
 | Robot-5 | 300-499 | 30
 | Thomas-4 | 100-299 | 12
 | Thomas-45 | 100-299 | 126
Kerala Total |  |  | 35480.5
MP | Nayar-91 | 100-299 | 891
 | Nayar-97 | 100-299 | 9552
 | Nayar-99 | 100-299 | 6000
 | Rana-01 | 100-299 | 1140
MP Total |  |  | 17583
UP | Kumar-11 | 100-299 | 12
 |  | 300-499 | 2122
 | Kumar-13 | 100-299 | 11498
 |  | 300-499 | 7929.5
 | Kumar-15 | 100-299 | 18460
 | Madhav-10 | 100-299 | 1800
 | Madhav-7 | 100-299 | 2721
 |  | 300-499 | 702
 | Madhav-8 | 100-299 | 11910
 | Madhav-9 | 300-499 | 2400
 | Tripati-5 | 100-299 | 7920
 | Tripati-6 | 100-299 | 4081
 |  | 300-499 | 3487
 | Tripati-7 | 100-299 | 5672
 | Tripati-8 | 100-299 | 7480
 |  | 300-499 | 44396
UP Total |  |  | 132590.5
Grand Total |  |  | 328281
Spreadsheet: mary_fischer__25632__31N
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
[NAME] |  | 1162
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 3f8c682a-51b9-4368-a9c0-84324a9cdcba
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7225 | 26840 | [NAME] | Walsh | USA | 296 | 00:28:52 | 00:02:41 | 00:48:46 | 00:04:19 | 00:14:30 | 1 | 01:39:08