tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 22771d1211932286-updating-contents-of-one-worksheet-based-on-criteria-in-another-worksheet-book2
Sheet: Sheet1

Salutation | Customer ID | Forename | Surname | 1st Address
 | 275290 | [NAME] | [NAME] | 29 Royal Road
 | 9564 | [NAME] | Arne-Rise | 65 Halton Road
 | 3335 | [NAME] | Batt | 90 Hollyoaks
 | 338546 | [NAME] | Beale | 10 Moor Lane
 | 45334 | [NAME] | Bell | 23 Main Street
 | 643 | y | Cleves | 332 Low Road
 | 23452 | Will | Keating | 2 The Copse
 | 75345 | A. | Kenwright | 207 East Avenue
 | 23489 | [NAME] | Littleton | 4 Long Marsh
 | 6675 | Leanne | Moore | 49 Kiln Road
 | 87877 |  | [NAME] | 43 Bryony Close
 | 765335 | [NAME] | Norton | 10 The Birches
 | 555 | [NAME] | Shostakova | 18 Crossley Drive
 | 12 | Kath | Sparrow | 99 Telford Rise
 | 67456 | Carol | [NAME] | 101 Central Drive
Spreadsheet: mary_fischer__25617__37D
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY: Sonya City
EXTENSION: 39690
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 45574cb6-f77c-4fbf-ae39-c6845d177841
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CMVG | Test | CMVG | Cytomegalovirus (CMV) Antibodies, IgG, Serum | [NAME], IgG, S | [NAME] (MFI) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.40 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | Negative (reported as positive, negative, or equivocal) | Monday through Saturday; 9 a.m. | Same day/1 day | 3 days | 1 | 86644 |  |  |  |  | Rochester
CMVG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CMVG | Result | CMVG | [NAME], IgG, S | [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 687165d1595003084-changing-list-based-on-multiple-variables-sample
Sheet: Sheet2

 | Region | Function
 | Europe | Committee |  |  |  | Europe | Committee |  | Committee EU |  | Production EU |  | Testing EU
 |  |  |  |  |  | US | Production |  | Stef |  | Hans |  | [NAME]
 |  |  |  |  |  | Asia | Testing |  | [NAME] |  | Wolfang |  | [NAME]
Members
Testing |  |  |  |  |  |  |  |  | Committee US |  | Prouction US |  | Testing US
Production |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | Mark
Committee |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | Lance
 |  |  |  |  |  |  |  |  | Committee AS |  | Production AS |  | Testing AS
 |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | Sue |  | Mick |  | Trev
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 26

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 12 Nov Glucose mmol/L
 |  |  |  |  | 6
Mon 13 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 14 Nov Glucose mmol/L
Wed 15 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 5.5
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 16 Nov Glucose mmol/L
Fri 17 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 5.7
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 18 Nov Glucose mmol/L
 |  |  |  |  |  | 6.1
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sun 19 Nov Glucose mmol/L
Spreadsheet: 11a5fd0f-7f2b-4156-8487-c92800e88dfb
Sheet: $ backfiles

One-Time Purchases of Back Files FY09
Backfile name | Amount (Capital fee only) | Year purchased | Year posted
Springer Online Journal Archives (OJA) [Entire Collection] | 109468 | 2008-2009 | FY09
BIOSIS archive 1985-1989 | 11215 | 2008-2009 | FY09
Web of Science Backfile 1965-1997 | 123432 | 2008-2009 | FY09
NRC Research Press Backfile Collection | 18000 | 2007-2008 | FY09
American Society of Agronomy Journals | 1012 | 2007-2008 | FY09
Geology Archives C-W Geological Society of America Bulletin Archives | 1112 | 2007-2008 | FY09
TOTAL
Spreadsheet: 03848e7c-115a-46f0-83ea-3770d5dd6666
Sheet: Sheet1

SCHEDULE AND CASTING ALWAYS SUBJECT TO CHANGE!
 | Fri | Sat Mat | [NAME] |  | Thurs | Fri | Sat | Sun Mat
 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-05 00:00:00 |  | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00 |  | 19:30:00 | 19:30:00 | 19:30:00 | 13:00:00
DIVERTIMENTO FROM "LE BAISER DE LA FEE"
Principal Couple | NAKAMURA | NAKAMURA | FOSTER |  | NAKAMURA | RESHEF | FOSTER | BIASUCCI
 | PORRETTA | PORRETTA | GRIFFITHS |  | PORRETTA | RENKO | GRIFFITHS | DAVIS
Solo women
1 | ANSPACH | CLARK | ANSPACH |  | ANSPACH | CLARK | ANSPACH | CLARK
2 | REID | SAMUELSON | REID |  | REID | SAMUELSON | REID | SAMUELSON
Intermission
AFTERNOON OF A FAUN
 | KORBES | FOSTER | RAUSCH |  | RAUSCH | FOSTER | KORBES | [NAME]
 | [NAME] | MOORE | ORZA |  | ORZA | MOORE | [NAME] | [NAME]
Pause
ROMEO ET JULIETTE BALCONY PAS DE DEUX
 | NAKAMURA | KORBES | KORBES |  | KORBES | RAUSCH | NAKAMURA | NAKAMURA
 | MOORE | POSTLEWAITE | POSTLEWAITE |  | POSTLEWAITE | [NAME] | MOORE | MOORE
Pause
BLACK SWAN PAS DE DEUX
 | IMLER | DEC | GILBREATH |  | GILBREATH | DEC | IMLER | IMLER
 | POSTLEWAITE | [NAME] | CRUZ |  | CRUZ | [NAME] | POSTLEWAITE | POSTLEWAITE
Intermission
AURORA'S WEDDING
[NAME] | RAUSCH | RICARD | CHAPMAN |  | RAUSCH | CHAPMAN | RICARD | CHAPMAN
Prince Florimund | [NAME] | CRUZ | ORZA |  | [NAME] | ORZA | CRUZ | CRUZ
Lilac Fairy | DEVRIES | OTTLEY | DEVRIES |  | DEVRIES | OTTLEY | DEVRIES | OTTLEY
King Florestan | MCCALL | MCCALL | MCCALL |  | MCCALL | MCCALL | MCCALL | MCCALL
Queen | TILSON | SCHILLER | TILSON |  | TILSON | SCHILLER | TILSON | SCHILLER
Catalabutte | LOCH | LOCH | LOCH |  | LOCH | LOCH | LOCH | LOCH
Silver | DEC | MURPHY | IMLER |  | IMLER | IMLER | DEC | MURPHY
Gold (right) | ORZA | DAVIS | POSTLEWAITE |  | POSTLEWAITE | POSTLEWAITE | ORZA | DAVIS
Gold (left) | LIN-YEE | HIPOLITO | [NAME] |  | [NAME] | [NAME] | LIN-YEE | HIPOLITO
White Cat | RICARD | SAMUELSON | [NAME] |  | [NAME] | RICARD | [NAME] | SAMUELSON
Puss in Boots | THOMSON | CARDEA | ROLLOFSON |  | ROLLOFSON | THOMSON | ROLLOFSON | CARDEA
Princess Florine | FOSTER | CLARK | FOSTER |  | RESHEF | SAMUELSON | FOSTER | CLARK
Bluebird | GRIFFITHS | [NAME] | PORRETTA |  | GRIFFITHS | HIPOLITO | PORRETTA | [NAME]
Red Riding Hood | SAMUELSON | RELIC | BIASUCCI |  | BIASUCCI | RELIC | SAMUELSON | RELIC
[NAME] | HIPOLITO | LIN-YEE | RENKO |  | RENKO | LIN-YEE | HIPOLITO | LIN-YEE
 |  |  |  | [NAME]
 |  |  |  | Media Relations Manager
 |  |  |  | Pacific Northwest Ballet
 |  |  |  | [PHONE]
 |  |  |  | Up Next:
 |  |  |  | LOVE STORIES
 |  |  |  | November 4-13
 |  |  |  | And then…
 |  |  |  | NUTCRACKER
 |  |  |  | November 25 – December 27
 |  |  |  | [PHONE] or www.pnb.org
 |  |  |  | Click here for a sneak peek at what's coming in 2012.
Spreadsheet: 143755d1330549258-filter-a-rollup-workbook-by-month-with-data-from-other-workbook-tu-tracking
Sheet: Store 2

Date [NAME] | Month | Week | Prospect # | First Name | Last Name | Lead Source | Appt Status | Appt Date | T/U Status |  |  | SSA paid
2012-01-31 00:00:00 |  |  |  | Hal | [NAME] | SSA | Booked | 2012-01-31 00:00:00 | Completed | 228 |  | x
2012-02-01 00:00:00 |  |  |  | [NAME] | [NAME] | SSA | Booked | 2012-02-01 00:00:00 | Completed | 500 |  | x
2012-02-02 00:00:00 |  |  |  | [NAME] | Okamoto | SSA | Booked | 2012-02-02 00:00:00 | Cust. Cancelled | 600
2012-02-02 00:00:00 |  |  |  | [NAME] | Tressel | SSA | Booked | 2012-02-02 00:00:00 | Completed | 273.24
2012-02-02 00:00:00 |  |  |  | [NAME] | Cooper | SSA | Booked | 2012-02-02 00:00:00 | Completed | 39 | 5000
2012-02-02 00:00:00 |  |  |  | Maninda | [NAME] | SSA | Booked | 2012-02-02 00:00:00 | Completed | 39
2012-03-01 00:00:00 |  |  |  | [NAME] | Cox | SSA | Booked | 2012-03-01 00:00:00 | Completed | 174
2012-03-02 00:00:00 |  |  |  | [NAME] | Suffield | SSA | Not Interested | 2012-03-02 00:00:00 | Cust. Cancelled
2012-03-03 00:00:00 |  |  |  | [NAME] | Gladieux | SSA | Not Interested | 2012-03-03 00:00:00 | Cust. Cancelled
2012-03-04 00:00:00 |  |  |  | [NAME] | Bowe | SSA | Will Call Back | 2012-03-04 00:00:00 | Completed | 225
2012-03-05 00:00:00 |  |  |  | [NAME] | Kelly | SSA | Booked | 2012-03-05 00:00:00 | Cust. Cancelled | 200
2012-03-06 00:00:00 |  |  |  | [NAME] | Pennie | SSA | Booked | 2012-03-06 00:00:00 | Completed | 39
Spreadsheet: kate_symes__18624__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-12 00:00:00 |  | 287.5 | 2400 | 277.5 | 0
 | 2001-02-11 00:00:00 |  |  |  |  |  |  |  | 398.34 | 5105 |  | 250 | 0
 | 2001-02-10 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.49 | 9007 | 373.04 | 3310
 | 2001-02-09 00:00:00 |  | 255.63 | 3200 | 217.5 | 400 | 385.64 | 9525 | 391.75 | 2705
 | 2001-02-08 00:00:00 |  | 360.63 | 3200 | 300 | 48 | 407.79 | 7436 | 402.59 | 2830
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 200108d1355417252-date-formats-not-changing-dates-2
Sheet: RELIFING REPORT 21

Date purchased
7/31/2006
7/19/2006
2/2/2007
2/2/2007
8/9/2007
2/7/2008
11/27/2008
10/16/2001
3/7/2003
2/15/2004
3/15/2004
12/15/2004
9/28/2005
11/21/2005
Spreadsheet: 167509d1342014624-excel-2008-help-needed-sum-values-of-one-column-based-on-a-changing-critiera-in-another-column-example
Sheet: Sheet2

A | B | E | G | E
800000132 | 20 | 2000002238 | 0 | 100
800000132 | 900001 | 2000002238 | 5
800000132 | 900002 | 2000002238 | 5
800000132 | 900003 | 2000002238 | 5
800000132 | 900004 | 2000002238 | 5
800000132 | 900005 | 2000002238 | 5
800000132 | 900006 | 2000002238 | 5
800000132 | 900007 | 2000002238 | 5
800000132 | 900008 | 2000002238 | 5
800000132 | 900009 | 2000002238 | 5
800000132 | 900010 | 2000002238 | 5
800000132 | 900011 | 2000002238 | 5
800000132 | 900012 | 2000002238 | 5
800000132 | 900013 | 2000002238 | 5
800000132 | 900014 | 2000002238 | 5
800000132 | 900015 | 2000002238 | 5
800000132 | 900016 | 2000002238 | 5
800000132 | 900017 | 2000002238 | 5
800000132 | 900018 | 2000002238 | 5
800000132 | 900019 | 2000002238 | 5
800000132 | 900020 | 2000002238 | 5
800000150 | 10 | 2000002634 | 0 | 216
800000150 | 50 | 2000002923 | 0
800000150 | 900001 | 2000002923 | 24
800000150 | 900002 | 2000002923 | 24
800000150 | 900003 | 2000002923 | 24
800000150 | 900004 | 2000002923 | 24
800000150 | 900005 | 2000002923 | 24
800000150 | 900006 | 2000002923 | 24
800000150 | 900007 | 2000002923 | 24
800000150 | 900008 | 2000002923 | 24
800000150 | 900009 | 2000002923 | 24
Spreadsheet: michelle_lokay__27474__shipsummary
Sheet: Sheet4

TRANSWESTERN  PIPELINE |  |  |  |  |  |  |  |  | 11/13  avg index
Shipper imbalances
 | 2001-08-31 00:00:00 | 9/2001 | 9/2001 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 10/2001 | 2001-10-31 00:00:00 | 2001-11-13 00:00:00 | 2001-11-01 00:00:00 | 2001-11-04 00:00:00
Shipper | Balance | activity | payments | Balance | activity | payments | Balance | activity | payments | Balance | comments
BP Energy Company |  |  |  | 362637.31 |  |  |  |  |  |  | will begin to receive 5,000/day in payback beginning 10/31
Duke Energy Trading & Marketing |  |  |  |  |  |  |  |  |  |  | has agreed verbally to dollars and will probably cash out
Williams Energy Marketing |  |  | -46764.71 | 3821.28 | 0
Mirant Americas |  |  |  | 2803.88
Enserco Energy | 16048.18 |  |  |  |  |  |  |  |  |  | ill cash out $14,200 (San Juan deliveries)
Phillips Petroleum | 7264 |  |  |  |  |  |  |  |  |  | will receive volume payback in Nov - 2001
Red Cedar Gathering | 6732
Aurora Natural Gas | 2362.1 |  |  | 2362.1 |  |  |  |  |  |  | invoiced   - in backruptcy
PGE Electric | 3412 |  |  |  |  |  |  |  |  |  | invoiced 8/31/01
ENA |  |  |  | 4268.02
Astra Power | -5.54 |  |  | 246.38 | 0
Richardson Products | -180
EES |  |  |  | -1910.98
SMUD | -608 | -158
Tenaska Marketing Ventures | -3718
El Paso Energy Marketing | -8120
PGE Energy Trading
SoCal |  |  |  | -25290.62
Enserch Gas | -29760
Sempra Energy Trading |  |  |  | -92551.75
PPL Energyplus
TXU Energy Trading | 0 | -346
USGT | 26251 |  |  | 26251.25 |  | -26251
Utilicorp | 113 |  |  |  |  | -113
Texaco Natural Gas, Inc |  |  |  |  |  | -134233
Arizona Public Service | 1610.08 |  | -1610
Dynegy Gas Transportation |  |  |  |  |  | -6531
Burlington Resources Trading |  |  | -125393
Reliant Energy Services |  |  | -73576
Balance at 8/31/01
Cashed received
Change due to scheduling
Balance at 11/11/01
Spreadsheet: 792640d1661026000-i-want-to-use-sumproduct-with-subtotal-for-long-range-of-cells-sample-file
Sheet: Sheet1

 |  |  | FORMULA TO USE SUMPRODUCT WITH SUBTOTAL
 |  |  | ABC |  |  | 0 |  | to sum the active cell with date only
 |  |  | RUI |  |  | 15
 |  |  | DESCRIP | AMOUNT |  | DATE
 |  | good | ABC | 50 |  | 2022-08-20 00:00:00
 |  |  | DAF | 60
 |  |  | RUI | 30 |  | 2022-08-21 00:00:00
 |  |  | ARO | 24
 |  |  | FDS | 87
 |  | bad | RUI | 15 |  | 2022-08-20 00:00:00
 |  | good | ABC | 50 |  | 2022-07-15 00:00:00
 |  | bad | ABC | 10
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: ENA #QA4309.1-Expired

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
Enron North America
Deal #QA4309.1
Prod. | Contract | Contract | ENA |  | Notional | NNG |  | (Gains) and Losses
Date | Number | Name | Fixed |  | Quantity | Floating |  | (Gains) and Losses
 |  |  | Price |  |  | Price |  | Total | Realized | Unrealized
 |  |  |  |  |  | GD-Others-Midpoint
 |  |  |  |  |  | NNG(Demarc) | Spread | (4) | (4) | (4)
2000-11-18 00:00:00 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
 |  | NNG | 5.885 |  | -9615
2000-11-18 00:00:00 |  | ENA |  |  | 9615 | 5.675
 |  | ENA |  |  | 9615 | 5.675
 |  | ENA |  |  | 9615 | 5.675
 |  | ENA |  |  | 9615 | 6.28
 |  | ENA |  |  | 9615 | 6.395
 |  | ENA |  |  | 9615 | 6.255
 |  | ENA |  |  | 9615 | 6.255
 |  | ENA |  |  | 9615 | 6.255
 |  | ENA |  |  | 9615 | 6.255
 |  | ENA |  |  | 9615 | 6.255
 |  | ENA |  |  | 9615 | 6.23
 |  | ENA |  |  | 9615 | 5.895
 |  | ENA |  |  | 9615 | 5.955
Spreadsheet: 876958d1723659716-determining-date-sequences-in-a-column-datesequence
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Result:
 |  |  |  |  |  |  |  |  | Date | Sequence
 |  |  |  |  |  |  |  |  | 2024-02-06 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-02-12 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-02-27 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-03-05 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-05-20 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-05-21 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-05-25 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-06-04 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-06-05 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-06-14 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-06-27 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-07-08 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-09 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-10 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-11 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-12 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-16 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-07-22 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-23 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-24 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-07-29 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-08-03 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-08-04 00:00:00 | 1
 |  |  |  |  |  |  |  |  | 2024-08-06 00:00:00 | 0
 |  |  |  |  |  |  |  |  | 2024-08-09 00:00:00 | 0
Spreadsheet: 537730d1505235942-pivottable-count-non-zeros-oeldere-537713d1505233413-pivottable-count-non-zeros-count-months-of-activity
Sheet: Sheet1

 | CITY | NAME | DEP | year | MONTH | AMOUNT | unique
 | NY | TOM | FINANCE | 2017 | JAN | 100 |  |  |  |  |  | Count of AMOUNT |  |  |  | MONTH
 | NY | TOM | FINANCE | 2017 | FEB | 150 |  |  |  |  |  | CITY | NAME | DEP | year | JAN | FEB | MAR | APR | MAY | JUN | (leeg) | Eindtotaal
 | NY | TOM | FINANCE | 2017 | MAR | 200 |  |  |  |  |  | NY | TOM | FINANCE | 2017 | 2 | 2 | 1 | 1 | 1 | 1 |  | 8
 | NY | TOM | FINANCE | 2017 | APR | 0 |  |  |  |  |  | (leeg) | (leeg) | (leeg) | (leeg)
 | NY | TOM | FINANCE | 2017 | MAY | 0 |  |  |  |  |  | Eindtotaal |  |  |  | 2 | 2 | 1 | 1 | 1 | 1 |  | 8
 | NY | TOM | FINANCE | 2017 | JUN | 0
 | NY | TOM | FINANCE | 2017 | JAN | 500
 | NY | TOM | FINANCE | 2017 | FEB | 600
 |  |  |  |  |  |  |  |  |  |  | unique | 1
 |  |  |  |  |  |  |  |  |  |  | Aantal van unique |  |  | MONTH
 |  |  |  |  |  |  |  |  |  |  | CITY | NAME | DEP | JAN | FEB | APR | JUN | MAR | MAY | Eindtotaal
 |  |  |  |  |  |  |  |  |  |  | NY | TOM | FINANCE | 1 | 1 | 1 | 1 | 1 | 1 | 6
Spreadsheet: 81510d1281647102-validation-list-and-if-vlookup-formula-approval-portal
Sheet: PR

Country | Cost Centre | Approver 1 | Deputy 1 | Approver 2 | Deputy 2
Belgium | 303011010 | [NAME] | Anna | Sabine | [NAME]
Belgium | 303011020 | [NAME] | [NAME] | Anna | [NAME]
Ireland | 312011000 | [NAME] | Owain | [NAME] | Stephen
Ireland | 312032000 | [NAME] | Owain | [NAME] | Stephen
Ireland | 312043000 | [NAME] | Stephen | [NAME] | Siobhan
Italy | 307011100 | [NAME] | [NAME] | [NAME] | Enrico
Italy | 307011200 | [NAME] | Enrico | [NAME] | [NAME]
Netherlands | 309011010 | Arjan | [NAME] | Anna | [NAME]
Netherlands | 309011020 | Arjan | [NAME] | Anna | [NAME]
Netherlands | 309012010 | Arjan | [NAME] | Sabine | [NAME]
Portugal | 310011100 | [NAME] | Christiano | [NAME] | Ricardo
Portugal | 310011200 | [NAME] | Christiano | [NAME] | Ricardo
Portugal | 310011300 | [NAME] | Ricardo | Iva | [NAME]
Spain | 308012210 | Costas | [NAME] | Francesc | Palmira
Spain | 308012220 | Costas | [NAME] | Francesc | Palmira
UK | 330120010 | [NAME] | [NAME] | [NAME] | [NAME]
UK | 330120010 | [NAME] | [NAME] | [NAME] | [NAME]