tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740247d1626254646-need-to-calculate-pay-amount-using-left-function-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Per hour Pay Amount |  | 400
 |  |  |  | Start [NAME] | End Time | Total Time | Substract Timing from total timings | Total Pay amount
 |  |  | 2021-07-07 00:00:00 | 8:00:00 | 9:14:00 |  | 0:00:00
 |  |  | 2021-07-05 00:00:00 | 11:15:00 | 9:04:00 |  | 19:49:00
 |  |  | 2021-07-05 00:00:00 | 9:05:00 | 11:17:00 |  | 1:12:00
 |  |  | 2021-07-08 00:00:00 | 10:00:00 | 12:00:00 |  | 0:00:00
 |  |  | 2021-07-07 00:00:00 | 15:30:00 | 19:35:00 |  | 1:05:00
 |  |  | 2021-07-06 00:00:00 | 10:30:00 | 15:30:00 |  | 0:00:00
 |  |  | 2021-07-09 00:00:00 | 9:05:00 | 10:05:00 |  | 0:00:00
Spreadsheet: 785361d1656356641-xlookup-that-returns-only-one-value-payment-type
Sheet: Summary

Invoice Date | Completion Date | Invoice # | Project Number | Invoice Business Unit | Job Type | Customer Name | Assigned Technicians | Splits | Invoice Status | Total | Balance | Payments | Payment Type | Estimate | Opportunity | Recall | Age of Equipment | Job Tags | Tech Report
 |  |  |  |  |  | Customer 1 |  |  |  |  |  | 0
 |  |  |  |  |  | Customer 2 |  |  |  |  |  | -99.65 |  |  |  |  |  | Job Tags
 |  |  |  |  |  | Customer 3 |  |  |  |  |  | 345
 |  |  |  |  |  | Customer 4 |  |  |  |  |  | 0 |  |  |  |  |  | Job Tags
 |  |  |  |  |  | Customer 5 |  |  |  |  |  | 0
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Human Ser - Direct Support Work

HUMAN SERVICES
Certificate
Students Name:
ID #
Direct Support Work | Semester | Grade
___ HMS 102 (3) Values of Human Services in a Contemporary Society
___ HMS 265 (3) Working with Disabilities in Human Services
___ MNA 100 (3) Medicaid Nurse Aide
OR ___ NAA 100 (3) Nursing Assistant Skills I
___ SWK 275 (3) The Family
OR ___ FAM 252 Introduction to Family Science
Electives - Choose one course from the following list:
___ HMS/SWK 235/250 (3)Teaching Persons with Mental Retardation
___ SWK 180 (3) Introduction to Gerontology
___ PSY 230 (3) Psychosocial Aspects of Death and Dying
___ HMS/SWK 200 (3) Dynamics of Human Behavior
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 71291d1271960994-if-then-726408-if-then
Sheet: Sheet1

 | Inspector |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Certification #: |  |  |  |  | 21-10282
 |  |  |  |  | INSPECTORS |  |  |  |  |  |  |  |  |  |  |  |  |  | Certification #
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
 | Inspector / Tester |  |  |  |  |  |  |  | Signed |  |  |  |  |  |  |  |  |  | AWWA Certification #
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-10282
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L-17-9010
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K-450-0006
Spreadsheet: 871718d1718136496-counting-days-counting-days
Sheet: Sheet1

 |  |  | Example
# of Days |  |  | 3 | 7 | 10
Sunday |  |  | 1 | 1 | 2
Monday |  |  | 1 | 1 | 2
Tuesday |  |  | 1 | 1 | 2
Wednesday |  |  |  | 1 | 1
Thursday |  |  |  | 1 | 1
Friday |  |  |  | 1 | 1
Saturday |  |  |  | 1 | 1
Spreadsheet: 794400d1662035639-multiple-closest-matches-with-multiple-criteria-book1-tool_fairy-
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4 |  |  |  |  |  |  |  |  |  |  |  |  | << 14:04 till 14:13
Staff 5
Staff 6
Staff 7
Staff 8
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 12:00:00 | 12:14:00 | 14 | 9.000000000000128 | 13:45:00 | 13:51:00 | 6 | 30 | 16:00:00 | 16:15:00 | 15 | 8.999999999999968
Staff 2 | 12:15:00 | 12:16:00 | 1 | 10.99999999999996 | 14:15:00 | 14:19:00 | 4 | 30 | 15:45:00 | 15:50:00 | 5 | 11.00000000000012
Staff 3 | 11:15:00 | 11:16:00 | 1 | 10.00000000000004 | 13:45:00 | 13:47:00 | 2 | 30 | 15:15:00 | 15:21:00 | 6 | 9.999999999999964
Staff 4 | 10:15:00 | 10:21:00 | 6 | 9.999999999999964 | 12:15:00 | 12:22:00 | 7 | 31 | 14:15:00 | 14:04:00 | -11 | 10
Staff 5 | 10:00:00 | 10:01:00 | 1 | 9.999999999999964 | 11:45:00 | 11:46:00 | 1 | 30 | 14:00:00 | 14:01:00 | 1 | 9.999999999999964
Staff 6 | 12:00:00 | 12:02:00 | 2 | 9.999999999999964 | 13:45:00 | 13:45:00 | 0 | 29 | 16:00:00 | 15:57:00 | -3 | 10.00000000000012
Staff 7 | 11:45:00 | 12:09:00 | 24 | 10.00000000000012 | 14:00:00 | 14:10:00 | 10 | 29 | 15:45:00 | 15:55:00 | 10 | 9.000000000000128
Staff 8 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 848788d1699430099-i-want-to-pull-out-extract-data-through-excel-formula-excel-solution-request
Sheet: Sheet1

S.No. | Customer Name | Investment Date | Currency | Investment Amount | Issue Date | Maturity Date | Coupon Date | Tenor | Certificate # | GL Number | Status | BANK A/C Number | Classification
1 | [NAME] | 2020-10-26 00:00:00 | GBP | 1000000 | 2021-10-10 00:00:00 |  |  | 1-Year | 373000-002 | S-00101-000003440 |  | 3341413000000493 | NON-RESIDENT
 | Sophia | 2020-10-26 00:00:00 | EUR | 500000 | 2022-01-25 00:00:00 |  |  | 3-Months | 371000-002 | S-00101-000003439 |  | 3387413000000550 | NON-RESIDENT
 | [NAME] | 2020-10-26 00:00:00 | AED | 100000 | 2020-11-10 00:00:00 |  |  | 5-Years | 375000-002 | S-00101-000003278 |  | 3228413000000835 | NON-RESIDENT
 | [NAME] | 2020-10-26 00:00:00 | USD | 5000 | 2021-10-05 00:00:00 |  |  | 1-Year | 393000-002 | S-00101-000003644 |  | 3098414000003822 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | SAR | 100000 | 2023-02-14 00:00:00 |  |  | 3-Years | 375000-003 | S-00101-000003406 |  | 3228413000001400 | NON-RESIDENT
 | Emma | 2020-10-27 00:00:00 | USD | 100000 | 2023-05-02 00:00:00 |  |  | 3-Months | 371000-003 | S-00101-000003451 |  | 8341413000000009 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | USD | 500000 | 2023-08-17 00:00:00 |  |  | 3-Months | 371000-003 | S-00101-000003452 |  | 3387413000000513 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | USD | 5000 | 2020-10-21 00:00:00 |  |  | 5-Years | 395000-003 | S-00101-000003703 |  | 3228414000000834 | NON-RESIDENT
 | Olivia | 2020-10-27 00:00:00 | USD | 5000 | 2022-06-07 00:00:00 |  |  | 3-Years | 395000-003 | S-00101-000003648 |  | 3228414000001108 | NON-RESIDENT
 | [NAME] | 2020-10-28 00:00:00 | EUR | 500000 | 2023-03-28 00:00:00 |  |  | 6-Months | 372000-004 | S-00101-000003444 |  | 3228413000001328 | NON-RESIDENT
 | STATUS |  |  |  | REQUIRED
 | Outstanding | Hold by Customer till Maturity date |  |  | BLANK
 | Matured | Matured at the date of Maturity |  |  | MATURED
 | Pre-Matured | Pre-Matured by Customer before Maturity date |  |  | Pre-Matured
 | CLASSIFICATION
 | Resident
 | Non-Resident
 | Resident & Non-Resident
 | CURRENCY
 | USD |  |  | I have a portfolio of almost 20,000 Customers as mentioned in Excel Sheet. I want to pull out/extract data through [NAME] for the followings:
 | EUR
 | GBP |  |  | 1). How to [NAME] of each customer in Excel Sheet as "Matured", "Pre-Matured" or Blank "Outstanding" with the help of [NAME].
 | AED |  |  | 2). How to [NAME] if any Customer want to avail Pre-Maturity option in the excel sheet with the help of [NAME].
 | SAR |  |  | 3). How to Pull out data of Customers those have become eligible for 6 month Coupon (in the case of 3 years & 5 Years only) with the help of [NAME].
 | TENORS
 | 3-Months | No Coupon
 | 6-Months | No Coupon
 | 1-Year | No Coupon
 | 3-Years | 6 Monthly Coupon
 | 5-Years | 6 Monthly Coupon
Spreadsheet: 221401d1363540548-vlookup-ofsted-data-changes
Sheet: KS5

Prior Data |  |  | Targets |  | Data Collection Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Distance from EOY Target |  |  |  |  |  |  |  |  |  | Half-Termly Progress Year 12 |  |  |  | Half-Termly Progress Year 13
[NAME] | [NAME] | GCSE Average Point Score | EOY 12 Target | EOY 13 Target | [NAME] | [NAME] EOCP12 | [NAME] | [NAME] EOCP12 | Y12 Spring 1 CWG | Y12 Spring 1 EOCP12 | Y12 Spring 2 CWG | [NAME] EOCP12 | Y12 Efinal Result | Y13 Autumn 1 CWG | Y13 Autumn 1 EOCP13 | Y13 Autumn 2 CWG | [NAME] 2 EOCP13 | Y13 Spring 1 CWG | Y13 Spring 1 EOCP13 | Y13 Spring 2 CWG | Y13 Spring 2 EOCP13 | [NAME] | [NAME] from Y12 EOY Target at Aut 1 | [NAME] from Y12 EOY Target at Aut 2 | [NAME] from Y12 EOY Target at Spr 1 | [NAME] from Y12 EOY Target at Spr 2 | [NAME] from Y12 EOY Target at Y12 Final Result | Y13 Distance from Y13 EOY Target at Aut 1 | Y13 Distance from Y13 EOY Target at Aut 2 | Y13 Distance from Y13 EOY Target at Spr 1 | Y13 Distance from Y13 EOY Target at Spr 2 | Y13 Distance from Y13 EOY Target at Y13 Final Result | Y12 Progress Aut 1 CWG - Aut 2 CWG | Y12 Progress Aut 2 CWG  - Spr 1 CWG | Y12 Progress Spr 1 CWG - Spr 2 CWG | [NAME] Spr 2 CWG - Y12 Final Result | [NAME] 1 CWG - Aut 2 CWG | [NAME] 2 CWG  - Spr 1 CWG | [NAME] Spr 1 CWG - Spr 2 CWG | [NAME] Spr 2 CWG - Y13 Final Result
Spreadsheet: 758625d1638974561-excel-fprmula-for-monthly-and-year-to-date-profit-and-loss-profit-and-loss
Sheet: Sheet1

Kindly asking for excel formula to produce monthly and year to date profit and loss as shown in the desired outcome.
Date | Name | Revenue | Expenses | Financial Category |  | Desired outcome
2021-01-11 00:00:00 | OK | 3000 |  | Sales |  | Statement of Profit and Loss
2021-01-21 00:00:00 | [NAME] |  | 1500 | Rentals |  |  |  | 2021-04-01 00:00:00 | YTD
2021-01-25 00:00:00 | TV | 4000 |  | Sales |  | Revenue
2021-01-30 00:00:00 | Fawcetty |  | 2000 | Security |  | Sales |  | 11000 | 36000
2021-01-30 00:00:00 | TM |  | 200 | Purchases |  | Expenses
2021-02-01 00:00:00 | OK | 5000 |  | Sales |  | Rentals |  | 2000
2021-02-02 00:00:00 | [NAME] |  | 2000 | Rentals |  | Security |  | 2500
2021-02-25 00:00:00 | TV | 6000 |  | Sales |  | Purchases |  | 3000
2021-02-25 00:00:00 | Fawcetty |  | 2500 | Security |  | Total Expenses
2021-02-28 00:00:00 | TM |  | 3000 | Purchases |  | Profit
2021-03-11 00:00:00 | OK | 3000 |  | Sales
2021-03-21 00:00:00 | [NAME] |  | 1500 | Rentals
2021-03-25 00:00:00 | TV | 4000 |  | Sales
2021-03-30 00:00:00 | Fawcetty |  | 2000 | Security
2021-03-30 00:00:00 | TM |  | 200 | Purchases
2021-04-01 00:00:00 | OK | 5000 |  | Sales
2021-04-02 00:00:00 | [NAME] |  | 2000 | Rentals
2021-04-25 00:00:00 | TV | 6000 |  | Sales
2021-04-25 00:00:00 | Fawcetty |  | 2500 | Security
2021-04-30 00:00:00 | TM |  | 3000 | Purchases
Spreadsheet: 53687d1253622505-excel-2007-axis-labels-sample
Sheet: Sheet2

 | a | 1 | 16
 | b | 2 | 5
 | c | 3 | 1
 | d | 4 | 3
 |  | 5 | 1
 |  | 6 | 2
 |  | 7 | 1
 |  | 8 | 3
 | e | 9 | 8
 |  | 10 | 7
 |  | 11 | 2
 | f | 12 | 2
 |  | 13 | 1
 | g | 14 | 1
 |  | 15 | 2
 |  | 16 | 1
 |  | 17 | 2
 | h | 18 | 1
 |  | 19 | 5
 |  | 20 | 1
 |  | 21 | 2
 |  | 22 | 1
 |  | 23 | 1
 | i | 24 | 3
 |  | 25 | 1
 | j | 26 | 7
 |  | 27 | 2
 |  | 28 | 1
 |  | 29 | 4
 |  | 30 | 2
 |  | 31 | 2
 |  | 32 | 7
Spreadsheet: 877679d1724491041-conditional-formatting-northernrunner-cf-365-aligw-tms
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  | 1, 11, 21, 31, 41, 51
 |  |  | 2, 12, 22, 32, 42, 52 |  |  |  |  |  |  |  |  |  |  |  |  | True |  |  | True
 |  |  | 3, 13, 23, 33, 43 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 4, 14, 24, 34, 44 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 5, 15, 25, 35, 45 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 6, 16, 26, 36, 46 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 7, 17, 27, 37, 47 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 8, 18, 28, 38, 48 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 9, 19, 29, 39, 49 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
 |  |  | 10, 20, 30, 40, 50 |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  | #[NAME]!
Spreadsheet: 769182d1645373202-control-of-2-names-with-the-same-data-aa10
Sheet: Foglio1

 |  |  |  |  |  | A |  |  |  |  | AA4
 |  |  |  |  |  |  |  |  |  |  | AA7
AA1 | Y | A
AA2 | Y | A
AA3 | M | N | M | N
AA4 | A | A | A | A
AA5 | Y | Y | N | Y
AA6
AA7 | A | A | A | A
AA8 | A | A
AA9 | C | N
AA10 | A | N
Spreadsheet: 79716d1279901545-tax-calculator-g-n-pay1
Sheet: Sheet1

 |  | Employee Name:
Filing Status: |  | Married Filed Jointly
Employee Status: |  | Non-Exempt
Number of Allowances:
Payroll Frequency: |  | monthly
Hours:
 | Regular | 25
 | OT | 200
Hourly Rates:
 | Regular | 10
 | OT Rate |  |  | Employee |  | Employer |  | [NAME]:
[NAME]. Pre-Tax Deductions:
1)
2)
3)
4)
5) |  |  |  |  |  |  |  | Net Pre-Tax Subtotal:
Medicare Tax Rate: |  | 0.0145
Social Security Tax Rate: |  | 0.062
SUTA Rate: |  | 0.058
FUTA Rate: |  | 0.008
State Income Tax Rate:
Federal Income Tax Rate:
Misc. Post-Tax Deductions:
1)
2)
3)
4)
5) |  |  |  |  |  |  |  | Employee Net Pay Total:
 |  |  |  |  |  |  |  | Employer Net Pay Total:
Married Filed Jointly |  | Exempt
Married Filed Separately |  | Non-Exempt
Single
Head of House |  | bi-weekly
 |  | semi-monthly
 |  | weekly
 |  | monthly
Spreadsheet: 799495d1665121560-date-condition-with-weekdays-test-20-1-
Sheet: Sheet1

Store | Week day | Date | [NAME]
METRO Constanta | Mon to Fri | 2022-10-01 00:00:00 |  |  |  | Holidays
METRO Constanta | Mon to Fri | 2022-09-30 00:00:00 |  |  |  | 2022-10-04 00:00:00
METRO CONSTANTA2 | Mon to Fri | 2022-10-01 00:00:00 |  |  |  | 2022-12-25 00:00:00
METRO Ploiesti | Mon to Fri | 2022-10-01 00:00:00
METRO Craiova | Mon to Fri | 2022-10-01 00:00:00
METRO BRASOV 2 | Mon to Fri | 2022-10-02 00:00:00
METRO Iasi | Tue to Sat | 2022-10-02 00:00:00
METRO Brasov | Mon to Fri | 2022-10-01 00:00:00
METRO Galati | Mon to Fri | 2022-10-01 00:00:00
METRO PITESTI | Mon to Fri | 2022-10-01 00:00:00
METRO Sibiu | Tue to Sat | 2022-10-03 00:00:00
METRO Oradea | Tue to Sat | 2022-10-03 00:00:00
METRO Punct Satu Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Baia Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Timisoara | Tue to Sat | 2022-10-03 00:00:00
METRO TIMISOARA 2 | Tue to Sat | 2022-10-03 00:00:00
METRO Cluj | Tue to Sat | 2022-10-02 00:00:00
METRO Punct Turda | Tue to Sat | 2022-10-02 00:00:00
METRO Punct Turda | Tue to Sat | 2022-10-04 00:00:00
Spreadsheet: 169197d1342723381-split-the-events-and-paste-it-with-same-information-split
Sheet: Sheet1

What data I have
event | event id | event date | event city | etc | etc | etc
play: madonna, justin, aerosmith - kate & taylor swift | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
celtic vs saiders, red sox vs thunders & WWE | 43219 | 2012-02-28 00:00:00 | new york | etc | etc | etc
what data I actually want
event | event id | event date | event city | etc | etc | etc
play: madonna, justin, aerosmith - kate & taylor swift | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
play | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
madonna | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
justin | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
[NAME] | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
kate | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
[NAME] swift | 12345 | 2012-06-12 00:00:00 | chicago | etc | etc | etc
celtic vs saiders | 43219 | 2012-02-28 00:00:00 | new york | etc | etc | etc
red sox vs thunders | 43219 | 2012-02-28 00:00:00 | new york | etc | etc | etc
wwe | 43219 | 2012-02-28 00:00:00 | new york | etc | etc | etc
I want to split the events on the baises of "," "&" " - " or some thing else if reuired
I want to split these events copying exactily the same cells  with it
I hope you can understand what I want to do ??
Spreadsheet: stacey_white__38840__West Limits Fax
Sheet: Limits

 | NA WEST POWER VaR
 |  |  |  |  | Increase/ | Average Daily
 | Portfolio | Portfolio | Trader | VaR | (Decrease) | VaR Limits | VaR Limit | Violation
 | Name | Name | Name | ($) | in VaR | ($) | ($)
 | ALL REGIONS
 | NA WEST POWER | POWER-WEST-TOTL | [NAME] | 9467599.864480497 | -2261139.765144385 | 4900000 | 10000000
 | WEST-LT | POWER-WEST-LT | [NAME] | 7151941.059798478 | -1665151.43710064 | 3800000 | 7900000
 | WEST-LT | POWER-WEST-LT | [NAME] | 7151941.059798478 | -1665151.43710064 | 3800000 | 7900000
 | WEST-ST | POWER-WEST-ST1 | [NAME] | 2768059.572575467 | -690435.6316770911 | 1700000 | 3300000
 | CANADA | FT-CAND-PWR-1 | [NAME] | 21264596.44161182 | 92827.88195037842 |  |  | VIOLATION
 | TOTAL WEST POWER |  | [NAME] | 27681955.68061082 | -3403602.005500533
 | WEST POWER LONG TERM
 | MANAGEMENT | POWER-WM-LT | [NAME] | 2514941.451436513 | -48832.70423258934 | 1300000 | 2400000 | VIOLATION
 | CALIFORNIA | POWER-CA-LT | [NAME] | 924057.0681860705 | 13579.64194734092 | 1300000 | 2400000
 | NORTHWEST REGION | POWER-NW-LT | [NAME] | 4493845.370889612 | -2462007.863562151 | 3100000 | 6100000
 | SOUTHWEST REGION | POWER-SW-LT | [NAME] | 4784340.810883751 | -183269.2452977011 | 1300000 | 2800000 | VIOLATION
 | WEST-LT | POWER-WEST-LT |  | 7151941.059798478 | -1665151.43710064 | 3800000 | 7900000
 | WEST POWER SHORT TERM
 | CA-ST | POWER-CA-ST | [NAME] Richter | 1138239.412177728 | -32854.13871559128 | 1000000 | 3000000
 | NW-ST | POWER-NW-ST | [NAME] | 1276655.532659344 | -279614.5275753057 | 1000000 | 1400000
 | SW-ST | POWER-SW-ST | [NAME]/[NAME] | 789565.3230878304 | -312626.6775861281 | 1000000 | 1300000
 | WEST-ST | POWER-WEST-ST1 | [NAME] | 2768059.572575467 | -690435.6316770911 | 1700000 | 3300000
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 76612 | 59707 | 142717 | <1,000 |  |  |  | <1,000 |  | 279036
FRA |  |  | 482686 | 144176 |  | 322162 |  | 911386 |  | 1860410
IRS- [NAME] | 2121642 | 2183375 | 1331275 | 100688 |  | 254820 | 457100 | 892707 | 395767 | 7737374
OIS |  | 233462 | 76926 |  |  |  |  |  |  | 310388
VNS
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2198254 | 2476544 | 2033604 | 244864 |  | 576983 | 457100 | 1804093 | 395767 | 10187209
Estimated gross notional amount outstanding, February 15 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 currency 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: 15eeee22-a2d2-49c5-a6e3-95cf22d74731
Sheet: Summary Cesar

PRESUPUESTO ENTIDADES EJECUTORAS
CESAR
Nombre Entidad Ejecutora:
Detalle | Presupuesto  Total | Tope Presupuestal
[NAME]
Monitoreo y Evaluación
[NAME] y [NAME]
Total Rubros de Funcionamiento
[NAME]
Total Destinación Específica
PRESUPUESTO TOTAL
XXXXXX
REPRESENTANTE LEGAL
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9702

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
FEBRUARY, 1997
IFGMR (TRKL/TX) |  |  | 2.7 |  |  | No. of Days: | 28
IFGMR (TRKL/LA) |  |  | 2.76
IFGMR (PEPL/TX/OK) |  |  | 2.77
IFGMR (ANR/LA) |  |  | 2.81
IFGMR (HENRY HUB) |  |  | 2.96
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-302
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.71 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 36583d1234456201-excel-trunc-overflow-math-table
Sheet: Sheet1

 | n
x | 1
Spreadsheet: joe_parks__14882__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-08 00:00:00
From the Waha Area | 200000
East of Waha to | 50000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: CC Appendices 2002 Plan

2002 Plan | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Headcount
2001 actual / CE2 | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Headcount | 19
[NAME] | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Headcount Variance
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 | -87770 | -89330
2 | -88047 | -88502
3 | -87233 | -80452
4 | -85416 | -89090
5 | -79179 | -79090
6 | -79663 | -79090
7 | -110402 | -111234
8 | -84439 | -82502
9 | -116535 | -118726
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-07-31 00:00:00 |  |  |  |  | 469765.91
2001-08-09 00:00:00
CBS Volume
 |  |  | 29027