tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 819995d1677807991-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717
Sheet: Event Log

Event Number | Event Name | Event Start Date | Column5 | Event End Date | Column6 | Primary Contact | Organisation | Contact Email | Event Location | Online | Contact Phone | Event Sectors | Column1 | Column2 | Approved by Committee | Website | [NAME] | Column3 | Column4
2023-001 | Event 1 ya | 2023-09-28 00:00:00 |  | 2023-02-10 00:00:00 |  |  |  |  | Online
2023-002 | Event 2 tootle | 2023-09-30 00:00:00 |  | 2023-01-10 00:00:00 |  |  |  |  | Venue TBC
2023-003 | Event 3 babi | 2023-01-10 00:00:00
2023-004 | Event 4 yernow | 2023-10-02 00:00:00 |  | 2023-10-04 00:00:00
2023-005 | Event 5 something | 2023-10-02 00:00:00
2023-006
2023-007
2023-008
2023-009
Spreadsheet: 831172d1685460921-index-match-on-multiple-results-try1
Sheet: Discount % Approved

[NAME] | Discount Type | % | Customer Name | Date Approved
Spreadsheet: 814678d1674545096-detection-the-letters-and-write-same-trial
Sheet: Sheet1

ELMA
ARMUT
ARMUT
ARMUT
ARMUT
ELMA
ELMA
KARPUZ
ELMA
ELMA
ELMA
ELMA
KARPUZ
KARPUZ
KARPUZ
KARPUZ
KARPUZ
KARPUZ
Spreadsheet: 549856d1511963191-vlookup-for-repetitive-values-test
Sheet: Interpretation_Rev1

Data |  |  | Expected Output
KP | Speed Calc (20min avg) |  | KP | Speed
70.505 | -0.06828095693816975 |  | 70.505 | 91.1
70.505 | 91.0588235051952 |  | 70.506 | 95
70.506 | 94.99159666357532 |  | 70.507 | 97.1
70.507 | 96.80672266330545 |  | 70.508 | 98.6
70.507 | 95.29411762168392 |  | 70.509 | 100.1
70.507 | 97.10924372293839 |  | 70.51
70.508 | 95.8991596890105 |  | 70.511
70.508 | 97.71428568826117 |  | 70.512
70.508 | 98.62184871321692 |  | 70.513
70.509 | 100.1344538077366 |  | 70.514
70.509 | 99.83193279928686 |  | 70.515
70.51 | 100.7394957715043 |  | 70.516
70.51 | 101.0420168332147 |  | 70.5170000000001
70.51 | 100.739495824722 |  | 70.5180000000001
70.511 | 102.5546218214587 |  | 70.5190000000001
70.511 | 103.1596638380815 |  | 70.5200000000001
70.512 | 105.2773109519409 |  | 70.5210000000001
70.512 | 105.2773109519838 |  | 70.5220000000001
70.512 | 105.8823529129917 |  | 70.5230000000001
70.513 | 106.7899159943615 |  | 70.5240000000001
70.513 | 107.0924370028542 |  | 70.5250000000001
70.514 | 107.3949579546132 |  | 70.5260000000001
70.514 | 108.6050419879019 |  | 70.5270000000001
70.514 | 109.8151260792027 |  | 70.5280000000001
70.515 | 111.3277311216233 |  | 70.5290000000001
70.515 | 111.327731062812 |  | 70.5300000000001
70.515 | 111.9327730794778 |  | 70.5310000000001
70.516 | 111.9327731385657 |  | 70.5320000000001
Spreadsheet: 742548d1627885958-2-columns-2-drop-down-lists-make-certain-cells-in-2nd-drop-down-list-populate-dv-sample-drop-down-list-problem-aligw
Sheet: Sheet1

Week # | Over 38 hrs work? | Y/N (User to complete) | Submitted timesheet? (User to complete)
Week1 | >38 hrs? | Yes | Yes
Week2 | >38 hrs? | No
Week3 | >38 hrs? | No
Week4 | >38 hrs? | Yes
Week5 | >38 hrs? | No
Week6 | >38 hrs?
Week7 | >38 hrs?
Week8 | >38 hrs?
Week9 | >38 hrs?
Week10 | >38 hrs?
Week11 | >38 hrs?
[NAME] | >38 hrs?
Week13 | >38 hrs?
Week14 | >38 hrs?
Week15 | >38 hrs?
Week16 | >38 hrs?
Week17 | >38 hrs?
Week18 | >38 hrs?
Week19 | >38 hrs?
Week20 | >38 hrs?
Week21 | >38 hrs?
Week22 | >38 hrs?
Week23 | >38 hrs?
Week24 | >38 hrs?
Week25 | >38 hrs?
Week26 | >38 hrs?
Week27 | >38 hrs?
Week28 | >38 hrs?
Week29 | >38 hrs?
Week30 | >38 hrs?
Spreadsheet: 46899d1245829583-confirming-if-multiple-rows-of-numbers-run-in-sequence-book1
Sheet: Sheet1

10 | 12 | 14 | 16 | 18 |  |  |  |  |  |  |  |  |  |  |  |  | Correct
1 |  | 3 | 4 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | Correct
234 | 312 | 459 | 421 | 419 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong
9 | 10 | 10 | 17 | 100 |  |  |  |  |  |  |  |  |  |  |  |  | Correct
6 | 2 | 7 | 9 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong
1 | 2 | 3 | 4 | 1 |  | 7 | 8 | 8 |  |  |  |  |  |  |  |  | Wrong
Spreadsheet: 593888d1539371531-dynamic-chart-with-three-arrays-ex_dynamic_chart
Sheet: Sheet1

Environment |  |  | Social |  |  | Governance
Total GHG CO2 Emissions Intensity per Sales | 0.5010813111985537 |  | Women Management to Employees Ratio | 0.001349898031630093 |  | % Non Executive Directors on Comp Committee | 0.6695133524945656
Climate Change Policy | 1 |  | % Women in Workforce | 0.9328585374986005 |  | Clawback Provision for Executive Compensation | 0
Energy Intensity per Sales | 0.4995860075279294 |  | Employee Turnover % | 0.2960297844491792 |  | Percentage Insider Shares Outstanding | 0.715955657644438
Water Intensity per Sales | 0.5001582014276983 |  | Equal Opportunity Policy | 1 |  | Free Float Percent | 0.7732855143008187
Waste Generated per Sales | 0.500015707768547 |  | Anti-Bribery Ethics Policy | 1 |  | ISS QualityScore | 0.001349898031630093
% Water Recycled | 0.3260687389164109 |  | Employee Protection / Whistle Blower Policy | 1 |  | Num of Directors Attending less than 75 % of Mtg | 0.001349898031630093
Biodiversity Policy | 0 |  | ARD Ref Salaries Wages and Employee Benefits | 0.8700332648772244 |  | CEO Duality | 1
Water Policy | 1 |  | Training Spending per Employee | 0.2653466911121291 |  | % Non Exec Directors on Board | 0.9666743507903368
SOx Emissions per Sales | 0.001349898031630093 |  | Lost Time Incident Rate | 0.04821869305732782 |  | % Independent Directors | 0.2712649693852619
NOx Emissions per Sales | 0.001349898031630093 |  | Total Recordable Incident Rate | 0.09914758117504889 |  | Independent Chairperson | 0
 |  |  | Fatalities per 1000 employees | 0.5 |  | Independent Lead Director | 0
 |  |  | Health and Safety Policy | 1 |  | Former CEO or its Equivalent on Board | 1
 |  |  | Human Rights Policy | 1 |  | Board [NAME] | 0.9781989151796765
 |  |  | Policy Against Child Labor | 1 |  | Pct of Independent Directors on Audit Committee | 0.001349898031630093
 |  |  |  |  |  | % Non Executive Directors on Audit Committee | 0.5744796055148004
 |  |  |  |  |  | % Audit Committee Members on 3+ Boards | 0.8129870436897083
 |  |  |  |  |  | Audit Committee Meeting Attendance Percentage | 0.001349898031630093
 |  |  |  |  |  | Independent Audit Committee Chairperson | 0
 |  |  |  |  |  | Years Auditor Employed | 0.001349898031630093
 |  |  |  |  |  | Classified Board System | 1
 |  |  |  |  |  | Board Average Age | 3.733297141026873e-15
 |  |  |  |  |  | Board Age Range | 0.6559188707960306
 |  |  |  |  |  | Percent of Executives that are Women | 0.2924113376315973
 |  |  |  |  |  | Percent of Board Members that are Women | 0.001349898031630093
 |  |  |  |  |  | # Board Members Serving > 10 Years | 0.001349898031630093
 |  |  |  |  |  | Average Board Tenure | 0.001349898031630093
 |  |  |  |  |  | Average Exec Tenure | 0.7648837440393877
 |  |  |  |  |  | % Non Executive Directors on 3+ Boards | 0.8456480315694903
 |  |  |  |  |  | % of Executive Directors on 2+ Boards | 0.001349898031630093
 |  |  |  |  |  | # Board Positions CEO Holds | 0.5900984232838085
 |  |  |  |  |  | # Board Positions Chair Holds | 0.6550126284225557
Spreadsheet: 1433cdba-1ea6-4f7a-9604-77b25301162d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38731499 | 2013-11-27 16:54:09 | AXIS | 1 | 6 | 2 | 480910 | rogalik | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
38819256 | 2013-12-03 20:02:13 | AXIS | 0 | 0 | 6 | 923434 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
Spreadsheet: 862277d1710024934-summarizing-no-of-orders-from-the-different-sheets-to-a-table-master-plan-202403-rev-2-ben9108-
Sheet: Summary

 | Quantity of Orders
 | Trade | Work Type | 2024
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Jan
 | MVAC | PM |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | CM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | A+A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | [NAME] | PM |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | CM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | A+A
 | UPS | PM |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  | CM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | A+A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Elect | PM
 |  | CM |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | A+A
 |  | PITC |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | BA | PM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | CM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | A+A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 33f4aa11-75df-465d-8e74-87c41bcdb730
Sheet: PPI 001

Permit No.: |  | WQ0028552 |  | Facility Name: |  | Briar Chapel Development |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 70300 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Grab | Composite | Composite | Grab | Composite | Composite | Recorder
Monthly Limit: |  |  | 329548 | 10 |  |  | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  | 25 | 6 |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | 2 x Month | 3 x Year | 5 x Week | 2 x Month | 2 x Month | 2 x Month | 5 x Week | 3 x Year | 2 x Month | [NAME]
Spreadsheet: 060f1e81-82d9-4615-b934-8fcbe6763616
Sheet: ETL1

Winter 2008 | TRA1000
Surname | GivenName | StudentNumber | Status | Faculty | [NAME] | ETL1 (34) | ETL1 (20) | %
Surname1 | GivenName1 | 12345 |  | Arts | [EMAIL] | 30
Surname2 | GivenName2 | 23456 |  | Arts | [EMAIL]
Surname3 | GivenName3 | 34567 |  | Arts | [EMAIL]
Surname4 | GivenName4 | 45678 |  | Arts | [EMAIL]
Surname5 | GivenName5 | 56789 |  | Arts | [EMAIL]
Average
Spreadsheet: 92683d1292256371-sumproduct-using-date-range-on-time-test
Sheet: All Depts - Answer

 |  | 2011-01-01 00:00:00 | 2011-01-16 00:00:00
 |  | 2011-01-15 00:00:00 | 2011-01-31 00:00:00
 | Jan
Dept | # Due | # Overdue  (1-15) | # Overdue (16-31) | Total Overdue | Monthly On Time %
Total | 81 | 9 | 10 | 19 | 0.7654320987654321
100 | 12 | 5 | 2 | 7 | 0.4166666666666667
101 | 1 | 0 | 0 | 0 | 1
102 | 4 | 0 | 1 | 1 | 0.75
103 | 8 | 0 | 1 | 1 | 0.875
104 | 17 | 0 | 3 | 3 | 0.8235294117647058
105 | 2 | 1 | 1 | 2 | 0
106 | 8 | 1 | 0 | 1 | 0.875
107 | 7 | 0 | 1 | 1 | 0.8571428571428571
108 | 6 | 1 | 0 | 1 | 0.8333333333333334
109 | 2 | 0 | 1 | 1 | 0.5
110 | 14 | 1 | 0 | 1 | 0.9285714285714286
Spreadsheet: 716633d1612289590-index-match-combination-issues-supplylistef-dexter2-
Sheet: Data

 |  |  | YEAR: |  | 2021 | Inventory Ledger |  |  | Office
 |  |  |  |  |  |  |  | Years | First
 |  |  |  | Item # |  |  |  |  | Purchase
 |  |  | 1 | 1001 | Pen's | [NAME]. |  |  | 2009-01-01 00:00:00 |  | 150
 |  |  | 2 | 2001 | Pencil's | General Pencil Co. |  |  | 2006-01-01 00:00:00 |  | 150
 |  |  | 3 | 314 | Crayon's | Crayola |  |  | 2008-01-01 00:00:00 |  | 150
 |  |  | 4 | 4001 | Marker's | Sharpie |  |  | 2009-01-01 00:00:00 |  | 150
 |  |  | 5 | 5001 | Paper's | HP |  |  | 2008-01-01 00:00:00 |  | 100
 |  |  | 6 | 6001 | Folders | Staples |  |  | 2021-01-01 00:00:00 |  | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
Spreadsheet: 865434d1712500216-make-rule-when-passing-date-samplefile-formula-date
Sheet: Ark1

 | Kontroll | Annet arbeid | Arbeid utført | [NAME] kontroll | Varsel neste kontroll | Varsel sendt
 | Årlig |  | 2023-03-02 00:00:00 |  |  | OK
 | Periodisk |  | 2023-03-05 00:00:00
 | Årlig | Ruteskruing
 |  | I need to set a rule that makes the cells in collumn F turn red when passing the date when the cells in collumn G is empty. If cells in collumn G says OK, the collor turnes back to white
Spreadsheet: 163159d1340208011-auto-extract-problem-0ef112_epdm-1-
Sheet: CR Sheet

90769615
90769616
90769617
90769618
90769619
90769620
90769621
90769622
90769623
90769624
90769625
90769626
90769627
90769628
90769629
90769630
90769631
90769632
90769633
90769634
90769635
90769636
90769637
90769638
90769639
90769640
90769641
90769642
90769643
90769644
90769646
90769647
90772999
90775452
90775453
90775454
90775455
90775456
90775457
90775458
90775459
90775460
90775461
90776800
90777043
90777044
90777045
90777046
90777048
90777052
90777053
90777054
90778921
Spreadsheet: 77922d1278420230-copy-selective-data-book2-1-
Sheet: Sheet4

products ordered | (All)
 | Data
Consumers | Sum of cost per unit | Sum of Units ordered | Sum of TAX | Sum of Total Cost
Consumer 1 | 300 | 5 | 0.1 | 150
Consumer 10 | 350 | 11 | 0.2 | 180
Consumer 11 | 110 | 13 | 0.2 | 72
Consumer 12 | 60 | 7 | 0.1 | 42
Consumer 2 | 50 | 6 | 0.1 | 30
Consumer 3 | 60 | 7 | 0.1 | 42
Consumer 4 | 5 | 100 | 0.1 | 50
Consumer 5 | 305 | 105 | 0.2 | 200
Consumer 6 | 350 | 11 | 0.2 | 180
Consumer 7 | 110 | 13 | 0.2 | 72
Consumer 8 | 65 | 107 | 0.2 | 92
Consumer 9 | 305 | 105 | 0.2 | 200
(blank) | 2070 | 490 | 1.900000000000001 | 1310
Grand Total | 4140 | 980 | 3.8 | 2620
Spreadsheet: 739350d1625657591-exponential-increase-between-two-fixed-numbers-exp_between-values
Sheet: Blad1

SIZE | PG 1 | PG 2 | PG 3 | PG 4 | PG 5 | PG 6 | PG 7 | PG 8 |  | Diff
100x596 | 3.799999999999999 |  |  |  |  |  |  | 16.21
1213x296 | 9.4 |  |  |  |  |  |  | 102.8
1213x496 | 9.4 |  |  |  |  |  |  | 137.6
 | PG 1 | PG 2 | PG 3 | PG 4 | PG 5 | PG 6 | PG 7 | PG 8 |  | EXP.
100x596 | 3.8 |  |  |  |  |  |  |  |  | 1.1107965 | (manually calculated)
1213x296 | 9.4 |  |  |  |  |  |  |  |  | 1.1093414 | (manually calculated)
1213x496 | 9.4 |  |  |  |  |  |  |  |  | 1.11905625 | (manually calculated)
Spreadsheet: 544375d1508872172-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: Summary

 | Totals From Below
Year = | Check |  |  |  |  |  |  | [NAME] where sumrange is sheets A:Z column E, criteria 1 is sheets A:Z column C where it equals Sell, criteria 2 is sheets A:Z column J equals cell $a$3 on the current worksheet | Same as previous except sumrange is sheets A:Z column G | These use unmentioned columns but I think once I have an example
2016 | Difference |  |  |  |  |  |  |  |  | I should be able to figure them out by substituing in the appropriate
 |  |  |  |  |  |  |  |  |  | colomuns as it is all done using sumifs
Tab# | Stock Name | Units Sold | Proceeds | Basis | Gain/Loss | Ending Units |  | So it would take the values 3256,3256,2845,2844 and add them
1 | Stock 1 | 0 | 0 | 0 |  | 2500 |  | As those are units sold in 2016 across the 3 numbered sheets
2 | Stock 2 | -6512 | 22562 | 18962 |  | 4506
3 | Stock 3 | -5689 | 20496 | 20685 |  | 652
etc going down as far as needed. | Only shows a name when the tab # exists between A and Z | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name | Shows as 0 when no name in stock name | Uses a formula to calc using multiple indirects shows 0 when no name in stock name
Spreadsheet: diana_scholtes__8545__Financial Power Terminated
Sheet: As of 1-2

Financial Power Transactions Terminated
 | Counterparty Name | Trades Terminated | Early Termination Date
 | AES Eastern Energy LP | 775220, 814567, 821656, 821666, 842776, [NAME], 857752 | 2001-12-11 00:00:00
 | AIG [NAME], LLC | Deal # 616996.01 | 2001-12-06 00:00:00
 | Allegheny Energy Supply Company, LLC | All trades | 2001-12-03 00:00:00
 | American Electric Power Service Corporation | All trades | 2001-12-03 00:00:00
 | Aquila Risk Management Corporation | All trades | 2001-11-29 00:00:00
 | BP Corporation North America Inc. | All trades | 5:00 p.m. 12/3/2001
 | Calpine Energy Services L.P. | All trades | 2001-12-10 00:00:00
 | Cargill, Incorporated | Deal # 813178.01 | 2001-12-03 00:00:00
 | Consolidated Edison Energy, Inc. | All trades | 2001-12-05 00:00:00
 | Coral Energy Holding, L.P. | All trades | 2001-12-05 00:00:00
 | Duke Energy Trading and Marketing, L.L.C. | All trades | 2001-12-04 00:00:00
 | Dynegy Marketing and Trade | All trades | 2001-12-20 00:00:00
 | El Paso Merchant Energy, L.P. | All trades | 2001-12-03 00:00:00
 | Engage Energy America LLC | All trades | 2001-12-03 00:00:00
 | Engage Energy Canada, L.P. | 633424.01, 633418.01 | 2001-12-03 00:00:00
 | Entergy-Koch Trading, LP | All trades | 2001-12-03 00:00:00
 | Exelon Generation Company, LLC | All trades | 4:00 p.m. 12/5/2001
X | Knauf Fiber Glass Gmbh | All trades | 2001-12-02 00:00:00
 | Maclaren Energy Inc. | All trades | 2001-11-30 00:00:00
 | Mirant Americas Energy Marketing, LP | All trades | 2001-11-28 00:00:00
 | New Power Company, The | All trades | 2001-12-03 00:00:00
 | NRG Power Marketing, Inc. | All trades | 2001-12-03 00:00:00
 | PPL EnergyPlus, LLC | All trades | 2001-12-04 00:00:00
 | Tractebel Energy Marketing, Inc. | All trades | 2001-12-03 00:00:00
 | Williams Energy Marketing & Trading Company | All trades | 2001-12-03 00:00:00
Spreadsheet: 715580d1611769173-reference-data-table-and-return-closest-date-after-on-today-excel-forums-test-v2
Sheet: Go-Lives dates

Area | Project | Title | Start Date
A | Project 1 | AAA | 2020-12-01 00:00:00 |  |  | Dates that should be detected by the formula
A | Project 1 | BBB | 2020-02-06 00:00:00
A | Project 1 | CCC | 2020-02-16 00:00:00
A | Project 2 | DDD | 2020-12-28 00:00:00
A | Project 2 | EEE | 2021-01-29 00:00:00
A | Project 2 | FFF | 2021-02-01 00:00:00
A | Project 3 | GGG | 2021-01-30 00:00:00
A | Project 3 | HHH | 2021-01-31 00:00:00
A | Project 3 | III | 2021-02-01 00:00:00
A | Project 4 | JJJ | 2021-02-02 00:00:00
A | Project 4 | KKK | 2021-02-03 00:00:00
A | Project 4 | LLL | 2021-01-04 00:00:00
Spreadsheet: louise_kitchen__23973__Schedule C_627
Sheet: Forecast

Earnings Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of:
Third Quarter 2000
 |  | Earnings Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  | DPR/MPR |  |  |  |  | Total |  |  |  |  |  |  |  | Bonus Accrual: |  |  | Actual | Plan
 |  |  | Actuals |  | Hot List |  |  | Forecast |  |  | Plan |  | [NAME] |  |  | 1st Quarter |  |  | 23 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd Quarter |  |  | 40 | 10
Gas Trading |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD Accrual
Power Trading |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd Quarter |  |  | 40 | 10
Other Trading |  |  | -3.3 |  |  |  |  |  |  |  |  |  |  |  |  | 4th Quarter |  |  |  | 50
Drift |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000 Total
Total Trading |  |  |  |  |  |  |  |  |  |  | 165.9
East Origination |  |  | 0.4 |  | 20 |  |  |  |  |  |  |  |  |  |  | Potential Deal Earnings:
West Origination |  |  | 9.3 |  | 3 |  |  |  |  |  |  |  |  |  |  | Wind Deal |  |  |  | 10
Industrial |  |  | 6.5 |  | 18 |  |  |  |  |  |  |  |  |  |  | Garden State |  |  |  | 14
Generation Invest |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GE Reval |  |  |  | 10
Mexico |  |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  | Total Potential Deal Earnings
Principal Investing
ECR
Upstream Origination |  |  | 14.3 |  | 70 |  |  |  |  |  |  |  |  |  |  | Potential Reserves/Accruals:
HPL/LRC |  |  | 14.9 |  | 3 |  |  |  |  |  |  |  |  |  |  | LTIP Accrual (New Plan) |  |  |  | 30
Canada |  |  | 0 |  | 10 |  |  |  |  |  |  |  |  |  |  | Buildout Writedown |  |  |  | 30
Portfolio Management |  |  | 1.2 |  |  |  |  |  |  |  |  |  |  |  |  | Turbine Impairment |  |  |  | ??
Total Origination |  |  |  |  |  |  |  |  |  |  | 131.5 |  |  |  |  | CES Strategic Value |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset Reserves (HPL) |  |  |  | 10
MPR |  |  | 40.9 |  |  |  |  |  |  |  |  |  |  |  |  | Total Potential Reserves/Accruals:
MPR Changes |  |  | 0
Total Investing |  |  |  |  |  |  |  |  |  |  | 34.3
Office of the Chair |  |  | 0
Interest Related Charges |  |  | -13
Total Other |  |  |  |  |  |  |  |  |  |  | 28.1
Total Margin
Expenses |  |  |  |  |  |  |  | -216.3 |  |  | -181.9
EBIT
Spreadsheet: darron_c_giron__8050__2000
Sheet: Nov 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 34.263 | 4.52 | 4.5 | 4.41 | 4.46
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Vastar | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update: