tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720711d1614265343-formula-to-identify-consecutive-month-of-gp-write-down-testbook
Sheet: Dashboard

Financially Challenge Project
 |  |  |  |  |  | Company | 17 |  |  |  |  |  |  |  | Company | 10
# | Contract # | Project Name | Last Month/Year of GP Write Down | Total GP Write Down |  |  |  |  | # | Contract # | Project Name | Last Month/Year of GP Write Down | Total GP Write Down
1 | 1718088 | Project A | October 2020 |  |  |  |  |  | 1 | 1017013 | Project B | January 2021 | -430164.16
2 | 1718130 | Project D | December 2020 | -5294.5 |  |  |  |  | 2 | 1016030 | Project C | December 2020 | -3922.19
3 |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  | 5
 | Using the GP History tab, looking for multiple GP reductions within the last 6 months.
 | Would need to reference column H for the company number.
 | Would then just sum the total GP write down (Column K) during the last 6 months.
 | Should list the largest GP write down first.
Spreadsheet: 134627d1325523634-totalling-values-in-column-b-depending-on-criteria-in-column-a-book1
Sheet: Ledger 1st month

1 | AA1 | ASTRAL !! | 5000 |  | 0 | 106.92 | 154.01 | 0 | 0 | 260.93
1 | AA2 | ALPHA | 5000 |  | 0 | 255.93 | 0 | 0 | 0 | 255.93
1 | AA3 | ARUNDEL !! | 2000 |  | 0 | 1169.7 | 830.88 | 453.41 | 0 | 2453.99
2 | AA4 | ANDORA | 6000 |  | 0 | 494.14 | 280.26 | 0 | 0 | 774.4
1 | AA5 | THE !! | 10000 |  | 0 | 172.14 | 0 | 0 | 371.78 | 543.92
2 | AA6 | AQUA | 5000 |  | 0 | 2521.64 | 0 | 0 | 0 | 2521.64
1 | AA7 | AC | 2000 |  | 0 | 167.83 | 0 | 0 | 0 | 167.83
1 | AA8 | AD | 2000 |  | 0 | 237.23 | 1985.49 | 0 | 0 | 2222.72
Spreadsheet: 108523d1305579189-look-for-corresponding-values-in-multiple-workbooks-campaign-work-bs1534a-day92
Sheet: Master

Asset # | Business Unit | Location | Work Order # | RET | Analysis Reports | Task Status | Date Completed | [NAME] | Additional Comments
9322 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details |  |  |  |  |  |  |  |  | Sample 1
9327 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details |  |  |  |  |  |  |  |  | Sample 2
9332 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details |  |  |  |  |  |  |  |  | Sample 3
9333 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details
9334 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9335 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9339 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9342 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9345 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9347 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9354 | 990 | Somewhere | 282154 | 2hrs. | Campaign Details
Spreadsheet: 85678d1285746324-check-existence-using-two-worksheet-with-one-criteria-given-condition-1-and-0-store-test
Sheet: A using count if

Worksheet 2a
Criteria | Check
 | [NAME] | apple | grapes | kiwi
Store A
Store B
Store C
Store D
Total
this table is inputted using count if manually; you can see in sheet "check using count if"
Spreadsheet: 864832d1711975422-formula-to-work-out-the-invoice-due-date-sample-data-etaf
Sheet: Payment Terms

BP Code | BP Name | Payment Terms Code | days
S100134 | AA | 90 days EOM
S101445 | CC | 75 Days
S102866 | DD | 28 Days
S104867 | EE | 120 Days EOM
S105099 | MM | 30 Days
S105655 | FF | 30 Days
S106244 | GG | 60 Days EOM
S106623 | HH | 30 days EOM
S106655 | TT | 60 Days
S107877 | JJ | 60 Days
Spreadsheet: 776193d1649585870-if-cell-a3-equals-any-value-of-another-sheet-column-retrieve-value-of-corresponding-row-testb
Sheet: CLIENTS

DENOMINATION | CID | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
[NAME] | 9
Drinkland | 8
Air & Chaleur | 7
[NAME] | 6
A.A. [NAME] | 5
[NAME] | 4
J-R Bat | 3
Gremibel | 2
DRL Express | 1
Spreadsheet: 37521d1235559017-vlookup-common-values
Sheet: Sheet1

List 1 | List 2 | Common values:
AA | GG | GG
BB | HH | HH
CC | II | II
DD | JJ | JJ
EE | KK
FF | LL
GG | MM
HH | NN
II | OO
JJ | PP
Spreadsheet: 787702d1657972733-how-to-solve-cash-on-hand-based-on-days-held-scraped-information
Sheet: Historical price movement check

Ticker | asx:bhp | asx:cba
 |  | 5 Days | 10 Days | 15 Days | 20 Days | 25 Days | 30 Days | Trade or no trade
Spreadsheet: 730493d1619718282-formula-to-find-entries-with-duplicate-value-in-one-column-and-differing-value-in-another-salesperson-contact-sheet-updated
Sheet: Sheet1

Date | Salesperson Name | Company | Contact First Name | Contact Last Name | Method of Contact | [NAME]
2021-01-01 00:00:00 | [NAME] | Disney | Sleepy | Dwarf | [NAME]
2021-01-02 00:00:00 | [NAME] | Disney | Happy | Dwarf | Magic Mirror
2021-01-03 00:00:00 | [NAME] | Disney | Doppy | Dwarf | [NAME]
2021-01-04 00:00:00 | [NAME] | Disney | Sleepy | Dwarf | Magic Mirror
2021-01-05 00:00:00 | [NAME] | Disney | Grumpy | Dwarf | [NAME]
2021-01-06 00:00:00 | [NAME] | Disney | Happy | Dwarf | [NAME]
2021-01-07 00:00:00 | [NAME] | Disney | Sneezy | Dwarf | [NAME]
2021-01-08 00:00:00 | [NAME] | Disney | Snow | White | Poisoned apple
2021-01-09 00:00:00 | [NAME] | Disney | Bashful | Dwarf | Magic Mirror
2021-01-10 00:00:00 | [NAME] | Disney | Doc | Dwarf | Magic Mirror |  | <-- not duplicates
2021-01-11 00:00:00 | [NAME] | Disney | Doc | Dwarf | Magic Mirror |  | <-- not duplicates
*[NAME] and [NAME] both contacted "Sleepy Dwarf", and [NAME] and [NAME] both contacted "Happy Dwarf". What formulas can I use to determine this on a large scale?
**I also want to ignore when [NAME] calls "Doc Dwarf" twice, as this is not a salesperson overlap
Spreadsheet: 217866d1362235835-please-help-with-counting-averages-counting-averages
Sheet: Sheet1

Data | Date | Month | Year | Week |  | Month |  |  | Year |  |  | Week
1900-05-02 00:00:00 | 2012-01-01 00:00:00 |  |  |  |  | Jan |  |  | 2012 |  |  | 1
1900-11-19 00:00:00 | 2013-01-01 00:00:00 |  |  |  |  | Feb |  |  | 2013 |  |  | 2
1900-01-04 00:00:00 | 2011-02-01 00:00:00 |  |  |  |  | Mar |  |  | 2011 |  |  | 3
1900-01-05 00:00:00 | 2011-01-02 00:00:00 |  |  |  |  | Apr |  |  |  |  |  | 4
 |  |  |  |  |  | May |  |  |  |  |  | 5
 |  |  |  |  |  | Jun |  |  |  |  |  | 6
 |  |  |  |  |  | Jul |  |  |  |  |  | 7
 |  |  |  |  |  | Aug |  |  |  |  |  | 8
 |  |  |  |  |  | Sep |  |  |  |  |  | 9
 |  |  |  |  |  | Oct |  |  |  |  |  | 10
 |  |  |  |  |  | Nov |  |  |  |  |  | 11
 |  |  |  |  |  | Dec |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 31165d1226963664-flagging-lowest-price-relative-example
Sheet: Sheet1

 | supplier 1 | supplier 2 | supplier 3 | supplier 4 | supplier 5 | supplier 6 | supplier 7 | supplier 8 | supplier 9 | supplier 10
Year end % | 2 | 0 | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 0
Example | 25 | 32 | 27 | 25 | 26 | 33
Price after Y/E %
Cost relative to average
 | Best price
Spreadsheet: jonathan_mckay__17206__HarvardMalin-Sumas8-01
Sheet: Deal Sheet for Printing (2)

 |  | NEW YORK |  |  |  |  |  |  |  |  |  |  |  | PURCHASE BEHIND  PLANT |  |  |  |  |  | DEDICATED RESERVES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME PLANT:________________ |  |  |  |  |  | FIRST PURCHASER
Enron Captial & Trade Resources Corp.
 |  |  |  |  |  |  |  | Executed Deal Ticket |  |  |  |  |  | DEAL NUMBER |  |  |  |  | Deal | #________________
COUNTERPARTY/CUSTOMER |  |  | CONTACT |  |  |  |  | ORIGINATOR |  |  | DEAL DATE |  |  | TRANSACTION TYPE(SWAP, CAP, INDEX, ETC.)
Harvard |  |  | [NAME] |  |  |  |  | ABRAMO/ZIVIC |  |  | 2001-08-01 00:00:00 |  |  | Basis Spread Swap
ECTR COUNTERPARTY |  |  |  |  |  |  |  |  |  |  | IFGMR, NGI, NGW, GAS DAILY INDEX |  |  |  | PHYSICAL DELIVERY POINT/PIPELINE |  |  |  |  | COMMODITY
ENA |  |  |  |  |  | ENA buys and sells |  |  |  |  | IFGMR NGI-MALIN, IF-NTHWST/CANBR |  |  |  |  |  |  |  |  | NG
UNIT OF MEASURE |  |  | MW |  |  |  | CURRENCY |  | BROKER |  | FEE |  |  | DEAL STATUS |  |  |  | SETTLEMENT
 |  |  | RISK MANAGER INITIALS:
PHYSICAL  NOTIONAL DEL  START DATE | PHYSICAL  NOTIONAL DEL  END DATE | REFERENCE  CODE (e.g. NX3) | FINANCIAL  REFERENCE  START DATE |  | FINANCIAL REFERENCE END  DATE |  | FIRM  QUANTITY  (A) | OPTION/OMICRON  QUANTITY (B) |  | TOTAL MAXIMUM  QUANTITY (A+B) | FIXED  PRICE | BASIS | C PHYSICAL  PREMIUM | C ADMIN/ OTHER | C TRANSPORT  PRICE |  | C OMICRON  PRICE | CONTRACT  PRICE/ STRIKE | C OPTION  PREMIUM |  | ORIGINATION
 |  |  |  |  |  |  |  |  |  |  |  | EFP
ENA Buys Sumas |  | NX1 | 2001-11-01 00:00:00 |  | 2002-03-31 00:00:00 |  | 10,000 mmBtu/day |  |  |  |  |  |  |  |  |  |  | 0.6
[NAME] Malin |  | NX1 | 2001-11-01 00:00:00 |  | 2002-03-31 00:00:00 |  | 10,000 mmBtu/day |  |  |  |  |  |  |  |  |  |  | 0.7 |  |  | 0.015
[NAME]: | ***  TUDOR SOLD 50 NOV 3.50 CALLS AT 51 CENTS- NY SOLD TO MAGGI AT 51.25 CENTS
Spreadsheet: daren_farmer__6596__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 122218 | 120265 | 122216 | 96023739 | Deficiency | 10/1/99-9/30/00 | 1418
Air Liquide America | 131605 | 131603 |  | 9600847 | Buyback | 12/1/99-1/31/00 | 8001
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Bayer Corporation | 144062 | 143637 |  | 96018711 | Buyback | January | 1550/8056 | Fred
Bayer Corporation | 155328 | 155322 |  | 96018711 | Buyback | February | 1550/8056 | Fred
Beaumont Methanol Limited Partnership |  | 93199 |  | 96019675 | Deficiency | 1/1/00-6/30/00 | 1428 | [NAME]
[NAME] | 140200 | 123440 | 140197 | 96022409 | Buyback | 11/1/99-3/31/00 | 1505
[NAME] | 140200 | 123445 | 140197 | 96022409 | Buyback | 4/1/00-9/30/00 | 1505
Chevron Chemical Co | 138614 | 116494 | 119166 | 96022420 | Deficiency | 1/1/00-3/31/00 | 1024 | Fred
[NAME] | 139070 | 139066 | 139068 | 96018826 | Buyback | 1/1/00-12/31/00 | 8216 | Fred
Enron Methanol Co | 139058 | 139055 | 139057 | 96018827 | Buyback | 1/1/00-12/31/00 | 8291 | Fred
Equistar Chemicals LP | 92860 | 92864 |  | 96000240 | Buyback | 7/1/99 - 1/31/00 | 1373/1384/1552/1553 | [NAME]
Equistar Chemicals LP | 156342 | 156337 |  | 96000240 | Buyback | 2/1/00 - 1/31/01 | 1373/1384/1552/1553 | [NAME]
Formosa Hydrocarbons | 92881 | 92872 | 92876 | 96000517 | Buyback | 7/1/99-7/31/00 | 1000/1383 | [NAME]
Global Octanes Corp | 137991 | 92886 | 92887 | 96019673 | Deficiency | 1/1/00-8/31/00 | 1528 | Thu
Lyondell-Citgo | 147729 | 140205 |  | 96008792 | Buyback | January | 1063
Lyondell-Citgo | 147729 | 147092 |  | 96008792 | Buyback | 2/1/00-12/31/00 | 1063
Marathon-Ashland | 93371 | 119068 |  | 96019644 | Buyback | 12/1/99-9/30/00 | 1431
Petrofina Gas Pipeline | 131356 | 131348 |  | 96019331 | Buyback | 12/1/99-3/31/00 | 1484
Rohm & Haas | 144247 | 144244 |  | 96019546 | Buyback | January | 1506 | Thu
Rohm & Haas | 156867 | 156826 |  | 96019546 | Buyback | February | 1506 | Thu
Shell Oil Co. | 138086 | 130133 | 93180 | 96019720 | Buyback | 1/1/00-7/31/00 | 1060/1061/1095/1581 | [NAME]
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred
Valero Marketing & Supply | 127304 | 119065 |  |  | Buyback | 11/1/99-9/30/00 | 8018/1394/1233/591-353
Spreadsheet: 737487d1624441841-calculating-4threads-my-excel-sheet-is-not-calculating-correctly-working-excel-example
Sheet: Eikon Transformed

 | 1 | 2 | 10 | 38
CIK | CUSIP | Name | IPO Year | Total Assets
1451809 |  |  | 2019
1729427 |  |  |  |  |  |  | Data should be pulled from "Compustat" Sheet based on two criteria: CIK Match and IPO Year Match, so that for the CIK 1451809 and year 2019 the value would be 123.391
1673772
1706431
1734517
1703647
1781983
1650648
1639825
1561550
1274737
1757073
1758021
1775625
Spreadsheet: matt_motley__26416__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-17 00:00:00 | 20 | 22.75 | 17 | 17.75
Mid-Columbia | 2002-01-17 00:00:00 | 20 | 22.75 | 17 | 17.75
COB | 2002-01-17 00:00:00 | 23.75 | 25.25 | 17.5 | 18
N. California | 2002-01-17 00:00:00 | 26.75 | 30.5 | 19 | 19.5
Midway/Sylmar | 2002-01-17 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-17 00:00:00 | 28 | 30 | 18 | 19.75
Mead | 2002-01-17 00:00:00 | 27.75 | 30 | 18 | 19.5
Palo Verde | 2002-01-17 00:00:00 | 26 | 30.5 | 16 | 19.5
Inland SW | 2002-01-17 00:00:00 | 26 | 30.5 | 16 | 19.5
4-Corners | 2002-01-17 00:00:00 | 26 | 29 | 16.25 | 17.5
Central Rockies | 2002-01-17 00:00:00 | 26 | 27.5 | 15.75 | 17.5
NW/N. Rockies | 2002-01-18 00:00:00 | 20 | 22.75 | 17 | 17.75
Mid-Columbia | 2002-01-18 00:00:00 | 20 | 22.75 | 17 | 17.75
COB | 2002-01-18 00:00:00 | 23.75 | 25.25 | 17.5 | 18
N. California | 2002-01-18 00:00:00 | 26.75 | 30.5 | 19 | 19.5
Midway/Sylmar | 2002-01-18 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-18 00:00:00 | 28 | 30 | 18 | 19.75
Mead | 2002-01-18 00:00:00 | 27.75 | 30 | 18 | 19.5
Palo Verde | 2002-01-18 00:00:00 | 26 | 30.5 | 16 | 19.5
Inland SW | 2002-01-18 00:00:00 | 26 | 30.5 | 16 | 19.5
4-Corners | 2002-01-18 00:00:00 | 26 | 29 | 16.25 | 17.5
Central Rockies | 2002-01-18 00:00:00 | 26 | 27.5 | 15.75 | 17.5
Spreadsheet: 04ddbf15-b444-4dba-a359-ec4227e88171
Sheet: Title Sheet

PROJECT'S COST ESTIMATE
TITLE SHEET
 |  |  |  |  | FILE NO:
PROJECT NAME:
OWNER'S NAME:
ADDRESS:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
ENGINEERING FIRM:
ADDRESS:
CONTACT PERSON:
PHONE #: |  |  | (            )
FAX #: |  |  | (            )
E-MAIL ADDRESS:
FOR SEAL
 |  |  | ENGINEER'S SIGNATURE |  |  |  | DATE
 |  |  | PRINT NAME |  | RCE |  | EXP.
Grading Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Grading Plan Total Estimate w/ 15% Contingency
Erosion Control Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Erosion Control Estimate w/ 15% Contingency
Improvement Plan Number:
No. of Sheets:
 |  |  |  |  |  |  |  |  | Improvement Plan Estimate w/ 15% Contingency
Earthwork and Drainage
(From Grading Plan Cost Estimate ) |  |  |  |  |  |  |  |  | Total From Sections 1 & 2
APPROVED BY |  |  |  | DATE
Spreadsheet: 755880d1637161662-problem-with-ifand-function-example-list
Sheet: Sheet3

KoM | PDR | CDR | LUAR | FFAR | CFAR | FAI | Program |  | Overall List of Tasks
Spreadsheet: 17d24baf-7b6b-45a5-b59d-fa7229adf7bb
Sheet: Sheet1

Lobbying Entities Quarterly Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
For Quarter Ending 9/30/13                                                                                                                                                                                                                                                                                                                           (As of 10/29/13)
Name of Lobbying Entity | Under 8 Exempt | Expenditure Amount | Est | Limited Expenditure | Officials Benefitted | Address | City, State Zip
BOMA | yes | 0 | no | no | no | 200 SW Market, Suite 1710 | Portland, OR 97201
CenturyLink | no | 0 | no | yes | no | 310 SW Park Ave. | Portland, OR 97205
City Club of Portland | no | 0 | no | yes | no | 901 SW Washington St. | Portland, OR 97205
Columbia Corridor Association | yes | 0 | no | yes | no | PO Box 55651 | Portland OR 97238
Family Forward Oregon | no | 1352.95 | yes | no | no | PO Box 15146 | Portland, OR 97293
[NAME] | yes | 0 | no | no | no | 833 SW 11th Ave. | Portland, OR 97205
[NAME] | yes | 0 | no | yes | no | 200 SW Market Street, Suite 1777 | Portland, OR 97201
League of Women Voters of Portland | no | 0 | no | yes | no | 310 SW 4th Ave. #520 | Portland, OR 97204
Northwest Strategies, Inc. | yes | 0 | no | no | no | 805 SW Broadway | Portland, OR 97205
NW Natural | yes | 0 | no | no | no | 220 NW Second Ave. | Portland, OR 97209
Oregon Health & Science University | yes | 0 | no | no | no | Mail Code: L101 | Portland, OR 97239
Oregon Opportunity Network | yes | 0 | no | yes | no | 847 NE 19th Ave., [NAME] 150 | Portland, OR,  97232
Pacific NW Regional Council of Carpenters | yes | 0 | no | no | no | 1636 E Burnside | Portland, OR  97214
Port of Portland | no | 1200 | yes | no | no | PO Box 3529 | Portland, OR  97208
Portland Business Alliance | no | 1730.55 | yes | no | no | 200 SW Market Street, Suite 150 | Portland, OR  97201
Portland General Electric Company | yes | 0 | no | no | no | 121 SW Salmon Street | Portland, OR  97204
Portland Metropolitan Association of Realtors | yes | 0 | no | yes | no | 825 NE Multnomah Street | Portland, OR  97232
Portland State University | yes | 0 | no | no | no | PO Box 751 | Portland, OR  97207
SYNQ Consulting | no | 0 | no | no | no | 6119 SW Corbett Ave. | Portland, OR  97239
The Bicycle Transportation Alliance | yes | 0 | no | no | no | 618 NW Glisan Suite 401 | Portland, OR  97209
[NAME] | yes | 0 | no | no | no | 610 SW Alder Street, [NAME] 800 | Portland, OR  97205
Veolia Water North America | yes | 0 | no | no | no | 200 [NAME] | Chicago, IL  60601
Spreadsheet: cara_semperger__1465__EPE_FEB_02
Sheet: FEB(3)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-02-03 00:00:00
HR ENDING | HR ENDING |  | FOUR CORNERS | FOUR CORNERS |  | EDDY | EDDY | EDDY | EDDY
Pacific | Mountain |  | SALE | SALE |  | SALE | SALE | SALE | SALE
Standard | Standard |  | EPMI | EPMI |  | BUY | BUY | BUY | BUY
Time | Time |  | 22.25 | 22.25
 |  |  | CARRY OVER FROM 2/2 | GOOD THRU 2/4 |  | CARRY OVER FROM 2/2 | CARRY OVER FROM 2/2 | FOR THE DAY | FOR THE DAY
 |  |  | 2002-02-01 00:00:00 | 2002-02-02 00:00:00 |  | 2002-02-01 00:00:00 | 2002-02-01 00:00:00 | 2002-02-02 00:00:00 | 2002-02-02 00:00:00
 |  |  | EPMI TAGS# 40565, 68, 69 | EPMI TAGS# 40565, 68, 69 |  | SPS TAG | SPS TAG | SPS TAG | SPS TAG |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST |  | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL
2400 | 0100 |  | 25 | 0 |  | -50 | -50 | 0 | 0
0100 | 0200 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0200 | 0300 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0300 | 0400 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0400 | 0500 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0500 | 0600 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0600 | 0700 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0700 | 0800 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0800 | 0900 |  | 0 | 25 |  | 0 | 0 | -50 | -50
0900 | 1000 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1000 | 1100 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1100 | 1200 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1200 | 1300 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1300 | 1400 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1400 | 1500 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1500 | 1600 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1600 | 1700 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1700 | 1800 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1800 | 1900 |  | 0 | 25 |  | 0 | 0 | -50 | -50
1900 | 2000 |  | 0 | 25 |  | 0 | 0 | -50 | -50
2000 | 2100 |  | 0 | 25 |  | 0 | 0 | -50 | -50
2100 | 2200 |  | 0 | 25 |  | 0 | 0 | -50 | -50
2200 | 2300 |  | 0 | 25 |  | 0 | 0 | -50 | -50
2300 | 2400 |  | 0 | 25 |  | 0 | 0 | -50 | -50
2400 | 0100 |  | 0 | 25 |  | 0 | 0 | -50 | -50
 | MST Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  | TOTAL SALES |  |  |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  |  | EPE(G)4C | EPE(G)4C |  | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE
 |  |  | EPMI | EPMI |  | PSCO | PSCO | PSCO | PSCO
 |  |  | AZPS(T)FC3/PPD2 | AZPS(T)FC3/PPD2 |  | EPMI | EPMI | EPMI | EPMI
 |  |  | WALC(T)PPD2/COOLIDGE | WALC(T)PPD2/COOLIDGE |  | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE
 |  |  | CRSP(L)COOLIDGE | CRSP(L)COOLIDGE
Spreadsheet: 546971d1510271057-fill-summary-sheet-from-multiple-tabs-with-different-names-workers-comp-tracking-sheet
Sheet: KINGSTON, Matthew

NAME | [NAME] |  | INJURY | [NAME] |  | CAPACITY | Suitable |  | PIAWE
PHONE |  |  | DATE OF INJURY |  |  | NEXT REVIEW |  |  | ROSTER
[NAME] |  |  | SITE | HENTY |  | COC EXPIRY |  |  | FINAL
INSURER |  |  | CASE MANAGER |  |  | REHAB PROVIDER |  |  | DOCTOR
UPDATES
Spreadsheet: richard_sanders__31733__FERC Request - Question _4
Sheet: c) Contracts > 365 Days

Deal ID | Delivery Start Date | Delivery End Date | Deal Start Date | Deal End Date | Deal Length | Pipeline | [NAME] | Point | Buyer Identification | Buyer Type | Quantity | Unit_Price
672809 | 04/01/2001 | 04/30/2001 | 04/01/2001 | 12/31/2002 |  | Socal | 3200322SB | SB-Socal (Topock) | a | Energy Marketer | 260155 | 12.6
672810 | 04/01/2001 | 04/30/2001 | 04/01/2001 | 12/31/2002 |  | Pacific Gas & Electric | CG0202N | Citygate - Normal Pool | a | Energy Marketer | 791617 | 9.45
672809 | 04/01/2001 | 04/30/2001 | 04/01/2001 | 12/31/2002 |  | Socal | DSCALEHRSB | SB-EPNG/SCAL ([NAME]) | a | Energy Marketer | 303621 | 12.6
397974 | 04/01/2001 | 04/30/2001 | 10/01/2000 | 09/30/2002 |  | PG&E Gas Transmission, NW | MALI | Malin | c | Energy Marketer | 105000 | 5.679
540952 | 04/01/2001 | 04/30/2001 | 01/01/2001 | [NAME] |  | Pacific Gas & Electric | CG0202N | Citygate - Normal Pool | a | Energy Marketer | 290000 | 9.4925
540956 | 04/01/2001 | 04/30/2001 | 01/01/2001 | [NAME] |  | Socal | DSCALEHR | [NAME] | a | Energy Marketer | 550567 | 12.6425
211458 | 04/01/2001 | 04/30/2001 | 03/01/2000 | 10/31/2008 |  | PG&E Gas Transmission, NW | MALI | Malin | b | Energy Marketer | 900000 | 7.4
77356 | 04/01/2001 | 04/30/2001 | 05/01/1999 | 04/30/2011 |  | PG&E Gas Transmission, NW | MALI | Malin | l | Energy Marketer | 450000 | 0
77350 | 04/01/2001 | 04/30/2001 | 05/01/1999 | 04/30/2011 |  | Socal | S0202D | PG&E/SOCAL Kern River Station | l | Energy Marketer | 89979 | 0