tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 789870d1659421490-help-rearranging-data-into-rows-from-2-columns-example
Sheet: 3 Person How It Should Look

 | Access Consideration(s): Wheelchair user (powered)(within [NAME] dimensions) |  | Arrive | Pax Leg Origin: Poulton-le-Fylde | Pax Leg Destination: Preston (Lancs) | Headcode at Destination: 2C06 | Coach: | Station Assistance: Use of ramp, [NAME] wheelchair space | On Train Assistance: Use of ramp, [NAME] wheelchair space | Meeting Point: Platform | Contact Details: | Booking Ref: | Journey Origin: Poulton-le-Fylde |  |  |  |  |  | ARR Time: 02/08 08:28 | [NAME]: | Seat: |  |  |  |  | Seat Reservation reference: | Journey Destination: Preston (Lancs)
Passenger Name: Passenger B | Access Consideration(s): Wheelchair user (powered)(within [NAME] dimensions) |  | [NAME] | Pax Leg Origin: Preston (Lancs) | Pax Leg Destination: Accrington | Headcode at Destination: 1B20 | Coach: | Station Assistance: Arriving at station by Pedestrian/other, Help with luggage, Use of ramp, Request wheelchair space, Assistance for Transferring trains, Assistance for Boarding | On Train Assistance: Use of ramp, [NAME] wheelchair space | Meeting Point: | Contact Details: | Booking Ref: | Journey Origin: Preston (Lancs) |  |  |  |  | DEP Time: 02/08 08:45 | ARR Time: 02/08 09:10 | [NAME]: | Seat: |  |  |  |  | Seat Reservation reference: | Journey Destination: Accrington
Passenger Name: Passenger B | Access Consideration(s): Asthma. Walks slowly Elderly, Other mobility impairment |  | [NAME] | Pax Leg Origin: Preston (Lancs) | Pax Leg Destination: [NAME] | Headcode at Destination: 1M08 | Coach: | Station Assistance: Please assist passenger onto the train and to their seat K07, Assistance for Boarding | On Train Assistance: | Meeting Point: Ticket Office | Contact Details: | Booking Ref: | Journey Origin: Preston (Lancs) |  |  |  |  | DEP Time: 02/08 10:00 | ARR Time: 02/08 12:10 | [NAME]: | Seat: |  |  |  |  | Seat Reservation reference: | Journey Destination: [NAME]
Spreadsheet: 4e1a0951-75bc-42fc-8e83-df3a873f9cab
Sheet: Sheet1

Time and Leave Document - Exempt | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
 |  |  |  |  |  | Name |  |  |  |  | Employee ID |  |  |  |  |  | Pay Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-11 00:00:00 |  |  |  | to | 2014-05-24 00:00:00
 |  |  |  |  |  | Dept Name |  |  |  |  | Dept Number |  |  |  |  |  | FTE
Earn Code | Earnings                          Type |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | 1st  Week      Total |  | Sun | Mon | Tue | Wed |  | Thu |  | Fri | Sat | 2nd        Week    Total | Totals
 |  |  |  | 2014-05-11 00:00:00 | 2014-05-12 00:00:00 | 2014-05-13 00:00:00 | 2014-05-14 00:00:00 | 2014-05-15 00:00:00 | 2014-05-16 00:00:00 | 2014-05-17 00:00:00 |  |  |  | 2014-05-18 00:00:00 | 2014-05-19 00:00:00 | 2014-05-20 00:00:00 | 2014-05-21 00:00:00 |  | 2014-05-22 00:00:00 |  | 2014-05-23 00:00:00 | 2014-05-24 00:00:00
VAC | Vacation |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
SCK | Sick |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
DDY | Discretionary |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
AVE | Advance Leave |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
HDC | Holiday |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
HCF | Holiday Worked Comp |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
HCT | Holiday Comp Taken |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
JRY | Jury Duty |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
FNL | Funeral Leave |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
IWN | Inclement Weather |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
SHL | Shared Leave |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
DON | Donor Leave |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
LWP | Leave Without Pay |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0
Total Leave Time Claimed |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All times listed on this report reflect actual time and funding groups charged, including leave time, and are true and correct to the best of my knowledge
Employees' Signature/Date |  |  |  |  |  |  |  |  | 2014-08-18 09:35:47.660000 |  |  | Manager's Signature/Date
Spreadsheet: 770287d1645978264-formula-not-copying-down-when-moving-to-next-line-set-up-your-table-correctly-aligw
Sheet: Table

Amount | Event Date | Cash | Cheque | Bank Credit | Total
0 | 2022-01-10 00:00:00 | 0 | 429 | 0
0 | 2022-01-13 00:00:00 | 0 | 217 | 0
0 | 2022-01-20 00:00:00 | 0 | 206 | 0
0 | 2021-12-24 00:00:00 | 1 | 1 | 1
0 | 2021-12-25 00:00:00 | 1 | 1 | 1
0
Spreadsheet: barry_tycholiz__847__2002 Plan Worksheet CC107321
Sheet: Income Statement

Income Statement - ($000s)
West Gas Origination (107321)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ |  | $ |  | $
Trading
FV-Investments
Accrual
Operating Expenses
Other
Total Margin |  | $ |  | $ |  | $
Capital Charge
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Employee Expense
Travel/Entertainment
Consulting
Office
Controllable Infrastructure
System Development
Insurance
Analyst Associates (includes Comp, Taxes & Benefits and Allocation)
Other Expense
Outside Legal
Outside Tax
Depreciation & Amortization
Total Direct Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 1 |  | 1
Director |  |  | 1 |  | 2
Manager |  |  | 2 |  | 3
Analyst and Associates |  |  | 2
Support Departments |  |  | 1 |  | 1
Total Headcount
2002 Plan (in thousands) |  |  | Team |  |  |  | ENA Total
Direct Expense (People + Office)/Headcount Ratio |  | $ |  |  |  | $
Productivity [NAME] |  | $ |  |  |  | $
ROCE
Spreadsheet: 133310d1324328432-need-help-with-data-referencing-copy-of-temp-1
Sheet: Sheet3

Tech | Employee Number | Productivity | Bonus
[NAME] | 645
[NAME] | 628
[NAME] | 673
[NAME] | 647
[NAME] | 635
[NAME] | 640
[NAME] | 675
[NAME] | 660
[NAME] | 672
[NAME] | 6215
[NAME] | 6347
[NAME] | 625
Spreadsheet: d1c09f74-e40d-4e1d-87ad-eb2ec0de63fd
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
FRASP | Test | FRASP | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  |  |  | 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
FRASP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FRASP | Result | FRASP | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 19

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap transaction volumes, month ending December 31, by product, participant type, and cleared status (in number of transactions).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 582827d1532073274-use-countif-for-non-contiguous-cells-20-july-2018
Sheet: Sheet1

22 | 55 | 0 | 0 |  |  | 10 |  |  |  |  | 1 |  |  |  | 6
2 |  |  |  |  |  | 20 |  |  |  |  | 2 |  | 66
 |  |  |  | 2 |  | 30 |  |  |  |  | 3
 |  | 2 |  |  |  | 40 | 12 |  |  |  | 4 |  |  |  | 4
 |  |  |  |  | 2 | 50 |  |  | 2 | 55 | 5
 | 0 |  |  | 66 |  | 60 |  |  |  |  | 6
 |  |  |  |  |  | 70 |  |  |  |  | 7
 |  |  |  |  |  | 80 |  |  |  | 2 | 8 |  | 6
 |  |  |  |  | 12 | 90 |  |  |  |  | 9 |  |  |  | 2
 |  |  |  | 2 |  | 100 |  | 2 | 0 |  | 10
 |  |  |  |  |  | 110 |  |  |  |  | 11 |  |  | 2
 |  |  |  |  |  | 120 |  |  |  |  | 12
 |  | 5 |  |  |  | 130 |  |  |  |  | 13
 |  |  |  |  | 2 | 140 |  |  |  |  | 14
 |  |  |  |  |  | 150 |  |  |  |  | 15 |  | 0
0 |  |  |  | 11 | 0 | 160 |  | 1 |  |  | 16 |  |  | 2
Spreadsheet: 849383d1699894446-how-do-i-extract-data-from-a-table-where-it-meets-certain-criteria-test-quals-spreadsheet-v2
Sheet: Training Needs

 |  | TODAY |  |  | Required/Planned
 |  | 30 DAYS or EXPIRED
 |  | 60 DAYS
 | Employee Information |  |  | Role Specific Training EXPIRY Dates |  |  |  |  |  |  |  |  |  |  |  |  | Additional Training
 | Name | Band | Attends Construction Sites? | Qual 1 | Qual2 | Qual3 | Qual4 | Qual5 | Qual6 | Qual7 | Qual8 | [NAME] | Qual10 | Qual11 | Qual12 | Qual13 | Qual14 | Qual15
 | [NAME] | Assistant Manager | N | 2024-05-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | 2026-07-10 00:00:00 | N/A | 2024-08-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-05-15 00:00:00 | 2024-05-15 00:00:00 | N/A | 2024-08-05 00:00:00 | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2019-09-30 00:00:00 | N/A |  |  | 2023-02-28 00:00:00 |  |  | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | [NAME] | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2023-12-01 00:00:00 | N/A | 2028-01-31 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-17 00:00:00 | 2026-07-10 00:00:00 | N/A | 2023-12-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | Y | 2024-10-29 00:00:00 | N/A | 2027-12-28 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-16 00:00:00 | 2026-07-10 00:00:00 | N/A | 2024-08-24 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | 04:18:00
 | Training Needs
Spreadsheet: 757768d1638450813-filter-formula-over-multiple-sheets-permit-register-example-2-12-2021
Sheet: Ready to Lodge

ABC Job Number | Address | Description | Client | Permit  Number | BP | OP | Inspection Status | Job Notes
 | Address 10 | Description 10 | Client 10 | 001/001/010 | ADMT READY | READY | 10/1/21 - Waterproofing | 0
ABC-21011 | Address 11 | Description 11 | Client 11 | 001/001/011 | READY | READY | 18/1/21 - Final | 0
ABC-21013 | Address 13 | Description 13 | Client 13 | 001/001/013 | ADMT READY | 0 | 20/1/21 - Shed | 0
Spreadsheet: dana_davis__4594__stock options
Sheet: 50

 | 50 options
 | Market Price
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 67.5
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 70.25
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 73
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 75.75
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 78.5
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 82
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
 | Market Price | 85
 | Option Price | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06 | -0.06
 | Cash/Share
Spreadsheet: louise_kitchen__23106__Natural Gas Netco Budget1_TexasOrig
Sheet: Natural Gas Trading

 | Natural Gas Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000
 | A&A Headcount |  |  |  |  |  |  | MD | 220000
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 798266d1664386831-formula-to-calculate-amount-based-on-set-rules-excelhelp-smxyc-
Sheet: Sheet1

% Achieved | Basic Salary | Variable Earnings |  | 0 | 0
0.2 | 4950 |  |  | 0.25 | 0.5
0.25 | 4950 |  |  | 0.5 | 1
0.5 | 4950 |  |  | 0.75 | 2
1 | 4950 |  |  | 1 | 3
1.25 | 4950 |  |  | 1.25 | 5
1.5 | 4950 |  |  | 1.5 | 6
1.75 | 4950
Spreadsheet: 105770d1303056234-how-to-extract-numerals-from-a-date-book1_djh100
Sheet: Sheet1

Date & Time | year | month | day | hour | min | sec
2011-04-17 17:02:34 | 2011 | 4 | 17 | 17 | 2 | 34
2011-03-20 02:38:26 | 2011 | 3 | 20 | 2 | 38 | 26
2011-02-19 12:14:17 | 2011 | 2 | 19 | 12 | 14 | 17
2011-01-21 21:50:08 | 2011 | 1 | 21 | 21 | 50 | 8
2010-12-24 07:26:00 | 2010 | 12 | 24 | 7 | 26 | 0
2010-11-25 17:01:51 | 2010 | 11 | 25 | 17 | 1 | 51
2010-10-28 02:37:42 | 2010 | 10 | 28 | 2 | 37 | 42
2010-09-29 12:13:34 | 2010 | 9 | 29 | 12 | 13 | 34
2010-08-31 21:49:25 | 2010 | 8 | 31 | 21 | 49 | 25
2010-08-03 07:25:16 | 2010 | 8 | 3 | 7 | 25 | 16
2010-07-05 17:01:08 | 2010 | 7 | 5 | 17 | 1 | 8
2010-06-07 02:36:59 | 2010 | 6 | 7 | 2 | 36 | 59
2010-05-09 12:12:51 | 2010 | 5 | 9 | 12 | 12 | 51
2010-04-10 21:48:42 | 2010 | 4 | 10 | 21 | 48 | 42
2010-03-13 07:24:33 | 2010 | 3 | 13 | 7 | 24 | 33
2010-02-12 17:00:25 | 2010 | 2 | 12 | 17 | 0 | 25
2010-01-15 02:36:16 | 2010 | 1 | 15 | 2 | 36 | 16
2009-12-17 12:12:07 | 2009 | 12 | 17 | 12 | 12 | 7
2009-11-18 21:47:59 | 2009 | 11 | 18 | 21 | 47 | 59
2009-10-21 07:23:50 | 2009 | 10 | 21 | 7 | 23 | 50
2009-09-22 16:59:41 | 2009 | 9 | 22 | 16 | 59 | 41
2009-08-25 02:35:33 | 2009 | 8 | 25 | 2 | 35 | 33
2009-07-27 12:11:24 | 2009 | 7 | 27 | 12 | 11 | 24
Spreadsheet: lindy_donoho__22134__NYMEX-TK
Sheet: Month End

Date | Close | High | Low | Open
2001-09-03 00:00:00 | 2.244 | 2.53 | 1.76 | 2.27
2001-08-01 00:00:00 | 2.38 | 3.6 | 2.25 | 3.245
2001-07-02 00:00:00 | 3.296 | 3.44 | 2.91 | 3.06
2001-06-01 00:00:00 | 3.096 | 4.44 | 3.055 | 3.885
2001-05-01 00:00:00 | 3.914 | 4.695 | 3.67 | 4.58
2001-04-02 00:00:00 | 4.695 | 5.62 | 4.68 | 4.95
2001-03-01 00:00:00 | 5.025 | 5.71 | 4.87 | 5.22
2001-02-01 00:00:00 | 5.236 | 6.97 | 4.95 | 5.87
2001-01-01 00:00:00 | 5.707 | 9.87 | 5.65 | 8.65
2000-12-01 00:00:00 | 9.775 | 10.1 | 6.58 | 6.8
Spreadsheet: 108177d1305232288-worksheet-text-consolidation-invitee-list-sample-day92
Sheet: John Wilson

Last Name | First Name | Title (VP,SVP, DIR, MGR) | Functional Area | Location City | Location State
[NAME] | [NAME] | VP/Regional Controller | Janitorial Northeast Region | New York | New York
Suerth | Ray | VP/Regional Controller | [NAME] | Chicago | Illinois
[NAME] | [NAME] | VP/Regional Controller | Janitorial South Central  Region | Houston | Texas
Bates | Amanda | VP/Regional Controller | [NAME] | Sacramento | California
Heberlein | [NAME] | Regional Controller | [NAME] and Landscape Regions | Tampa | Florida
Reese | [NAME] | Director Accounting | Janitorial HQ | Philadelphia | Pennsylvania
Nice | [NAME] | Director Planning | Janitorial HQ | Houston | Texas
Szczech | Greg | Director [NAME] | Janitorial HQ | Los Angeles | California
Spreadsheet: jim_schwieger__14490__working capital
Sheet: workingcapital

Exhibit A
Enron's Working Capital Calculation Statement
as provided in
Purchase and Sale Agreement
between
Enron Corp. "Seller"
and
AEP Energy Services Gas Holding Company "Buyer"
dated as of December 27, 2000
Article 2.4 (b)
 | Texas General Land Office |  | See attached Schedule I
 | Cannon |  | See attached Schedule I
 | Lyondell Citgo Adjustment |  | See attached [NAME]
 | Centana Ad Valorem Tax Proration |  | See attached [NAME]
 | Gas Lift Deposits |  |  |  | 25000
 | [NAME] |  |  |  | 91000
 | SAP to PeopleSoft Conversion
Final Working Capital Due Seller
Spreadsheet: 21778d1209694113-lookup-and-if-help-resi-weekly-update
Sheet: Friday

 |  |  | Friday
 |  |  | Contract Number | Comments |  |  |  |  |  | TVP done
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
Back to worksheet |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 | Total | 0 |  |  |  |  |  |  |  |  | 0 | Total
Spreadsheet: 847106d1698184626-how-can-compile-data-in-a-desired-format-test1
Sheet: Sheet1

What I have
 |  |  | ! | @ | # | $
 | 1 | A | 0.01 | 1.3 | 0.25 | 0.21
 |  | B | 0.32 | 0.55 | 0.2 | 1.2
 |  | C | 3 | 0.22 | 1.2 | 1.6
 |  | D
 |  | E
 | 2 | A | 0.33 | 2 | 1 | 0.39
 |  | B | 0.52 | 0.41 | 0.69 | 0.22
 |  | C | 2.3 | 0.66 | 0.88 | 3.2
 |  | D
 |  | E
 | 3 | A | 0.52 | 0.66 | 0.85 | 0.22
 |  | B | 2 | 2.4 | 0.35 | 0.89
 |  | C | 0.74 | 0.12 | 0.78 | 0.65
 |  | D
 |  | E
What I need
 |  | A |  |  |  | B |  |  |  | C
 |  | ! | @ | # | $ | ! | @ | # | $ | ! | @ | # | $
 | 1 | 0.01 | 1.3 | 0.25 | 0.21 | 0.32 | 0.55 | 0.2 | 1.2 | 3 | 0.22 | 1.2 | 1.6
 | 2 | 0.33 | 2 | 1 | 0.39 | 0.52 | 0.41 | 0.69 | 0.22 | 2.3 | 0.66 | 0.88 | 3.2