tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: JAN2000

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 1 month ended January 31, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions
Other, net |  |  |  |  |  | 0 |  |  | 5 | 56 | -75 | -16745 |  | -1117 | -13
Funds Flow
Changes in components of working capital
Receivables |  |  |  | -3903 | -48 |  | -20 | 2 | -227 | 52 | 8 |  |  | -1021 | -38
A/R, A/P - Intercompany |  |  |  | 2513 | 647 |  |  | -2 | 2686 | -192 | 67 | -17 |  | -4208 | 41
Inventories |  |  |  | 2 | 2
Prepayments |  |  |  | -983 | -140
Payables |  |  |  | -8794 | -1400 |  | -128 |  | -504 | -3 |  |  |  | -659 | -49
Exchange Rec/Payable |  |  |  | 3491 | -84
Accrued taxes |  |  |  | 926 | 234 |  |  |  | -2 | -2 |  | 17 |  | 0
Accrued interest |  |  |  | 2875 | -3138
Other working capital |  |  |  | -1238 | 195 |  | 448 |  |  |  |  |  |  | 159
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments |  |  |  | 1828
Capital Expenditures |  |  |  | -651 | -347
Underground Storage,Salvage & Removal Costs
EOTT Advances
Interest on GP Work Cap Loan(23Q)
Other investing activities - intercompany
Other investing activities, net |  |  |  | -1861
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt |  |  |  | 7 | -100000
Repayment of long-term debt
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations |  |  |  | -7 | 100000 | 0 | 0 | 135 | -420 | 284 | 0 | 0 |  | 0 | 0
Change in total obligations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 145
Spreadsheet: 787567d1657875392-copy-values-based-on-non-blank-cells-in-another-column-test1
Sheet: Div2

No | Description | Quantity | U of M | Subcontract |  | TOTAL COST
 |  |  |  | $/Item/Unit | Total
022000 | Assessment |  |  |  |  | 0
 | Subtrade 1 |  |  |  | 1200
 | Subtrade 2 |  |  |  | 1300 | 1300
 | Subtrade 3 |  |  |  | 1400
023000 | Subsurface Investigation
 | Subtrade 4 |  |  |  | 2200
 | Subtrade 5 |  |  |  | 2300 | 2300
 | Subtrade 6 |  |  |  | 2400
024000 | Demolition & Structure Moving
 | Subtrade 7 |  |  |  | 3200
 | Subtrade 8 |  |  |  | 3300 | 3300
 | Subtrade 9 |  |  |  | 3400
Spreadsheet: 790314d1659638182-move-every-2nd-row-to-a-column-rows-to-columns
Sheet: Sheet1

name |  |  | Name | Address | City | St | Zip
address
city st zip
name
address
city st zip
name
address
city st zip
name
address
city st zip
name
address
city st zip
name
address
city st zip
name
address
city st zip
Spreadsheet: ff705b92-a9d2-430e-8df5-04265e9c632b
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
FPBLG | Test | FPBLG | Pepper Black IgG | Pepper Black IgG | Enzyme Immunoassay (FEIA) |  |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPBLG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPBLG | Result | FPBLG | Pepper Black IgG | Pepper Black IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 711324d1609612751-list-data-from-pivot-table-ignoring-blanks-and-incorporating-associated-columns-temp
Sheet: Mutual & Auto Aid

City of Rochester
Fire Department
Mutual and Auto-Aid
 |  |  |  |  |  |  |  |  |  |  |  | Automatic Aid |  |  |  |  |  | Mutual Aid
 |  |  |  |  |  |  |  |  |  |  |  | Given |  |  | Received |  |  | Given |  |  | Received
 |  |  |  |  |  |  |  | Byron |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | [NAME] |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Dover |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Elgin |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Eyota
 |  |  |  |  |  |  |  | Oronoco |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Pine Island |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Stewartville |  |  |  | - |  |  | -
 |  |  |  |  |  |  |  | Totals:
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.16.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-16 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 3 | 4 | 1 | 1 | 0 | 2 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 3 | 1 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 14 | 1 | 4 | 0 | 0 | 0 | 1 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 |  | 0 |  | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-16 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 0 | 1 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 15 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 |  | 0 |  | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 5 | 0 | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 3 4tf fl/2 MED
 | Total House Census
Spreadsheet: andy_zipper__171__DYNEGY-ICE VOL Apr18
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
US Natural Gas | [NAME] | 1 | 10000 |  | Power | [NAME] | 6 | 268800 |  | (blank) | No Activity | 1 | 0
 | [NAME] | 5 | 25000 |  |  | [NAME] | 1 | 800 |  | (blank) Total |  | 1 | 0
 | [NAME] | 5 | 25000 |  |  | [NAME] | 1 | 800 |  | Grand Total |  | 1 | 0
US Natural Gas Total |  | 11 | 60000 |  |  | [NAME] | 2 | 1350
Grand Total |  | 11 | 60000 |  | Power Total |  | 10 | 271750
 |  |  |  |  | Grand Total |  | 10 | 271750
Spreadsheet: 128841d1321304920-finding-lowest-cost-from-a-list-with-wildcard-lowestpricesexcludingshanghai
Sheet: Raw data

Part Code | Supplier | Supplier Location | Cost
AAA1 | ALP | Xiamen | 5.5
AAA1 | DSB | Xiamen | 5.3
AAA1 | STA | Shenzhen | 5.4
AAA1 | AOS | Shanghai | 4.1
BBB1 | ALP | Xiamen | 9.8
BBB1 | DSB | Xiamen | 10.5
BBB1 | AOS | Shanghai | 10.2
BBB1 | STA | Shenzhen | 7.5
CCC1 | ALP | Xiamen | 4.5
CCC1 | DSB | Xiamen | 6.4
CCC1 | AOS | Shanghai | 3.55
CCC1 | STA | Shenzhen | 5.33
CCC1 | LUC | Guangdong | 3.44
AAA2 | ALP | Xiamen | 5.5
AAA3 | DSB | Xiamen | 5.3
AAA4 | STA | Shenzhen | 5.4
AAA5 | AOS | Shanghai | 4.1
BBB3 | ALP | Xiamen | 9.8
BBB5 | DSB | Xiamen | 10.5
BBB10 | AOS | Shanghai | 10.32
BBB10 | STA | Shenzhen | 7.5
CB-CCC1 | ALP | Xiamen | 4.5
AB-CCC2-BS | DSB | Xiamen | 6.4
[NAME] | AOS | Shanghai | 3.55
Spreadsheet: 0be97df6-281d-4373-bab8-ff983cd128cb
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2011-11-10 00:00:00 | Maintenance | National MPG | [NAME] (Swindon) Limited | 147738 | 27125
DCMS | NMSI | 2011-11-10 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 147824 | 63625
DCMS | NMSI | 2011-11-10 00:00:00 | Build Construction | ScM Major projects | TMP | 147866 | 29005
DCMS | NMSI | 2011-11-15 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 147867 | 48614.75
DCMS | NMSI | 2011-11-15 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 147868 | 48614.75
DCMS | NMSI | 2011-11-10 00:00:00 | General Marketing | ScM Major projects | Total Media Limited | 148104 | 28746.05
DCMS | NMSI | 2011-11-10 00:00:00 | Build Construction | York Major project | [NAME] | 148388 | 26202.88
DCMS | NMSI | 2011-11-10 00:00:00 | Equipment/Materials | NRM Collections | West Coast Railways | 148389 | 32000
DCMS | NMSI | 2011-11-24 00:00:00 | Build Construction | ScM Major projects | DBR (London) Ltd | 148478 | 123482.97
DCMS | NMSI | 2011-11-24 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 148479 | 28744.89
DCMS | NMSI | 2011-11-10 00:00:00 | Build Construction | National Estates | Fairhurst Ward Abbotts Ltd | 148495 | 40000
DCMS | NMSI | 2011-11-24 00:00:00 | Stock Purchases | NRM RETAIL | Bachmann Industries Europe Ltd | 107095 | 35730
DCMS | NMSI | 2011-11-24 00:00:00 | Stock Purchases | NRM RETAIL | Bachmann Industries Europe Ltd | 107096 | 35730
Spreadsheet: 764989d1643109800-highlight-a-range-with-a-list-by-selecting-start-and-end-rang-colored-ans
Sheet: Sheet1

 |  |  | Start | A9 | 102
 |  |  | End | A4 | 106
 | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12
101
102
103
104
105
106
107
 |  | Please, without VBA
 |  |  | Please, with conditional formatting
 |  |  | I need a red colored range
=OR(AND(MATCH(B$5,$B$5:$M$5,0)>=MATCH($E$2,$B$5:$M$5,0),$A6=$F$2),AND(MATCH(B$5,$B$5:$M$5,0)<=MATCH($E$3,$B$5:$M$5,0),$A6=$F$3),AND($A6>$F$2,$A6<$F$3))
Spreadsheet: 779737d1652078022-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw
Sheet: AP

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  | [NAME] | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.02.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-02 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 0 | 0 | 1 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-02 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 0 | 4 | 0 | 2 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 6 | 0 | 3 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 69447d1269966319-merge-sheets-sample
Sheet: Merged

City | Main | Price30Kg | Price40Kg | Price50Kg | Price60Kg | AddQ1 | Add30Kg | Add40Kg | Add50Kg
LONDON | DE | 344 | 4334 | 4343 | 44 | 55 | 55 | 0 | 0
SWEDEN | DE | 66 | 66 | 66 | 66 | 55 | 55 | 0 | 0
[NAME] | DE | 77 | 77 | 77 | 77 | 22 | 55 | 0 | 0
LONDON | as | 2121 | 3 | 44 | 55 | 3 | 0 | 0 | 0
SWEDEN | 66 | 1221 | 66 | 66 | 55 | 3 | 0 | 0 | 0
[NAME] | 77 | 77 | 77 | 77 | 22 | 3 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 14b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | - | - | - | -
Index | 366 | 302 | 256 | 924
Other | - | - | 18 | 18
TOTAL | 366 | 302 | 274 | 942
Spreadsheet: joe_parks__14712__POSTION05_02
Sheet: JUN_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 142 | 3.735 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  | 15 | 3.67 |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  | 15 | 3.65 |  |  |  |  | NEW DEALS
 | 15 | 3.627
 |  |  |  |  | 10 | 3.605 |  |  |  |  | TOTAL  P&L
 | 10 | 3.64 |  |  | 10 | 3.61
 | 15 | 3.65 |  |  | 20 | 3.615
 | 20 | 3.66 |  |  |  |  |  |  |  |  | POSTION
 | 15 | 3.615 |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  | 20 | 3.58 |  |  |  |  | NET POSTION
 | 30 | 3.62 |  |  | 17 | 3.605
 | 20 | 3.695 |  |  | 13 | 3.61
 |  |  |  |  | 30 | 3.685 |  |  | Position |  |  | 50000
 | 5 | 3.71
 | 10 | 3.71
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 31 | 3.15
 |  |  |  |  |  |  |  |  |  |  | 15.5 | 3.115
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 851770d1701904386-add-the-lowest-of-the-rows-addlowestofrows
Sheet: Sheet1

 |  |  | Supllier 1 | Supplier 2 | Supplier 3 | Supplier 4
 |  | Item 1
 |  | Item 2
 |  | Item 3
 |  | Item 4
 |  | Item 5
 |  | Item 6
 |  | Item 7
 |  | Item 8
 |  | Item 9
 |  | Item 10
 |  | Item 11
 |  | Item 12
 |  | Item 13 |  |  |  | 6.5
 |  | Item 14 |  |  |  | 40.3
 |  | Item 15 |  |  |  | 4.32
 |  | Item 16
 |  | Item 17
 |  | Item 18
 |  | Item 19
 |  | Item 20
 |  | Sum Of Lowest | add up the greens | add up the greens | add up the greens | add up the greens
Spreadsheet: 686107d1594365852-count-department-per-month-for-the-year-hd1080-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Range Start | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  | Range End
Department | Start Date | End Date | Name | Salary |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June
Department 1 | 2017-04-01 00:00:00 | 2019-04-08 00:00:00 | [NAME] | 20000 |  |  |  | Department 1
Department 1 | 2018-02-14 00:00:00 |  | [NAME] | 25000 |  |  |  | Department 2
Department 1 | 2018-02-15 00:00:00 |  | [NAME] | 30000 |  |  |  | Department 3
Department 2 | 2018-02-16 00:00:00 | 2019-07-08 00:00:00 | [NAME] | 45000 |  |  |  | Department 4
Department 2 | 2018-05-17 00:00:00 |  | [NAME] | 27000 |  |  |  | Department 5
Department 2 | 2018-04-18 00:00:00 |  | [NAME] | 27000
Department 1 | 2018-02-19 00:00:00 |  | [NAME] | 27000
Department 1 | 2018-02-20 00:00:00 | 2019-08-02 00:00:00 | [NAME] | 27000
Department 1 | 2019-02-21 00:00:00 |  | [NAME] | 27000
Department 1 | 2019-02-22 00:00:00 |  | [NAME] | 27000 |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June
Department 3 | 2019-02-23 00:00:00 |  | [NAME] | 27000
Department 3 | 2018-02-24 00:00:00 | 2019-04-06 00:00:00 | Julia Doe | 27000
Department 1 | 2018-02-25 00:00:00 |  | [NAME] | 27000
Department 1 | 2018-02-26 00:00:00 |  | [NAME] | 27000
Department 4 | 2018-02-27 00:00:00 |  | [NAME] | 27000
Department 5 | 2018-02-28 00:00:00 | 2020-04-08 00:00:00 | Jasper Doe | 27000
Department 1 | 2018-03-01 00:00:00 | 2020-04-08 00:00:00 | [NAME] | 27000
updated to | 2020-06-30 00:00:00
 |  |  |  |  |  |  |  |  | last finacial year
 | Start | end
last month
last 3 months
last 6 months |  |  |  |  |  |  |  | Department 1
last finacial year |  |  |  |  |  |  |  | Department 2
last calendar year |  |  |  |  |  |  |  | Department 3
 |  |  |  |  |  |  |  | Department 4
 |  |  |  |  |  |  |  | Department 5
Spreadsheet: barry_tycholiz__824__PGT LC Shippers and Calcs
Sheet: Sheet1

 |  |  | PGT Shippers Listing - ENA Capacity Obligations
Structure | Market | Volume/day | Expiration | Shipper of Record |  |  |  | Proposed | Potential
 |  |  |  |  | Tariff/Demand Charge | L/C Requst by PGT | Assignment Discussions | Assignment Date | Adjusted L/C Amount
(1) | AEC | 30000 | 2008-10-31 00:00:00 | ENA | 0.3194 |  | Yes | 2001-12-01 00:00:00
 | CNRL | 15000 | 2008-10-31 00:00:00 | ENA/CNRL | 0.3194 |  | Yes | 2001-12-01 00:00:00
 | Conoco/Crestar | 5000 | 2008-10-31 00:00:00 | ENA | 0.3194 |  | Yes | 2001-12-01 00:00:00
 | Rio Alto | 2500 | 2008-10-31 00:00:00 | ENA | 0.3194 |  | Yes | 2001-12-01 00:00:00
 | Talisman | 10000 | 2008-10-31 00:00:00 | ENA | 0.3194 |  | Yes | 2001-12-01 00:00:00
 | ECC/Beau | 5000 | 2008-10-31 00:00:00 | ENA | 0.3194 |  | No | n/a
(2) | CNRL/Chevron | 10000 | 2003-10-31 00:00:00 | ENA | 0.2548 | 930020 | Yes
(3) | Humble | 10000 | 2005-10-31 00:00:00 | ENA | 0.2548 | 930020 | No | n/a
(4) | Shell/SPPC | 10099 | 2002-10-31 00:00:00 | ENA | 0.3194 | 1177352 | No | n/a
(5) | ENA | 628 | Expires Dec 31/01 | ENA | 0.2628 | 10067 | No | n/a
(6) | ENA/EES | 5387 | Monthly Renewal | ENA | 0.2548 | 41178 | No | n/a
 | COMMENTS
 | PGT wants L/C for demand charges on capacity obligations of actual tariff up to 1year or less.
 | ENA and PGT volumes match
 | ENA will shed items 5 at year end, item 4, oct 31, 2002 and item 6 will be a monthly charge ( EES customers)
 | ENA sold 37,500 / day at Malin until 2008 and MMI pricing with Calpine holding the rights to drop the molecules off upstream of Malin ( PNW/ Hermiston)
 | ENA and ECC will be appointed as Agent for billing and nominations as part of assignment.
Spreadsheet: 582482d1531909087-issue-with-excel-graph-labels-sample
Sheet: Sample

 |  | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00
 | Data1 | 5 | 2 | 6 | 1 | 4 | 5 | 3 | 5 | 3 | 1 | 2 | 4 | 6 | 5 | 3 | 8 | 9 | 9
 | Data2 | 7 | 3 | 4 | 4 | 8 | 18 | 13 | 9 | 11 | 8 | 8 | 7 | 6 | 6 | 6 | 8 | 9 | 7
 | Data3 | 10 | 10 | 12 | 8 | 9 | 3 | 1 | 6 | 5 | 5 | 16 | 4 | 9 | 5 | 5 | 3 | 2 | 2
 | Data4 | 28 | 30 | 26 | 17 | 23 | 35 | 11 | 20 | 18 | 22 | 20 | 21 | 27 | 27 | 29 | 19 | 18 | 24
Spreadsheet: 725868d1616935211-need-help-to-simplify-the-formula-eosb-computation
Sheet: EOSB Computation 

 | Nature of Leaving | Basic Salary | Joining Date | Leaving Date | Years of Service | Calculated EOSB
 | Termination | 5000 | 2012-11-01 00:00:00
 |  |  |  |  | Service | Entitlement | [NAME] | Term
Row # | Nature of Leaving | Year of Service | Entitlement |  | 1 | 0 | 1 | 0
A9 | Termination | upto 1 Year | No end of service benefits |  | 3 | 21 | 1 | 0.3333333333333333
A10 | Termination | 1 to 5 Years | 21 days of salary for every completed years of service |  | 5 | 21 | 1 | 0.6666666666666666
A11 | Termination | 5 years and above | 31 days of salary for every completed years of service |  | 99 | 31 | 1 | 1
A12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resignation
A13 | Resignation | upto 1 Year | No end of service benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termination
A14 | Resignation | 1 to 3 Years | One third of total entitlement computed as per above slabs ([NAME] and A11)
A15 | Resignation | 3 to 5 Years | Two third of total entitlement computed as per above slabs (Rows 9,10 and 11)
A16 | Resignation | 5 years and above | Full entitlement as per the computation done in accordance with above slabs ([NAME] and A11)
Spreadsheet: sally_beck__35039__0417
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 2ND QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-06-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
[NAME] | Gas Trading
[NAME] | Power Trading |  | 7642
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
CANADA | Canada |  | 186
COAL | Coal |  | 615
WEATHER | GRM -  Weather
SO2 | Emissions
INSURANCE | GRM - New Products
 | Total Trading & Risk Mgmt
E_ORG | East Midstream
W_ORIG | West Midstream |  | 943 |  |  | Big Horn, Cactus
DWNSTRM_IND_ORIG | Industrial Downstream |  |  |  |  | Merlin (City Forest, Oconto Falls)
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments |  | 6052
ASST_ORIG | Gas Assets |  | 12467
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  | 704 |  |  | Condor (Quanta)
PROD_FIN | Energy Investments |  | 2880
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  | 3841
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
 | Capital Charge Offset
 | Total Commercial
GROUP | Group
 | Total