tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815741d1675177474-partial-matche-example-booklet-ans-1-
Sheet: Sheet1

Table Array | Lookup Value | Multiple Returns | Helper |  | [NAME] result |  |  |  | Final Result Required:
123-789-789 | 123-123 | 123-123-123, 123-123-456, 123-123-789 |  |  |  |  |  |  | 123-123 | 123-123-123
123-123-456 | 123-456 | 123-456-123 | 1 |  |  | 123-123-456 |  |  | 123-123 | 123-123-456
123-456-123 | 123-789 | 123-789-123, 123-789-456 | 2 |  |  | 123-123-789 |  |  | 123-123 | 123-123-789
000-123-123 | 000-123 | 000-123-123, 000-123-456, 000-123-789, 000-123-000 | 4 |  |  | 123-456-123 |  |  | 123-456 | 123-456-123
123-789-123 |  |  | 0 |  |  | 123-789-123 |  |  | 123-789 | 123-789-123
123-789-456 |  |  | 0 |  |  | 123-789-456 |  |  | 123-789 | 123-789-456
000-123-456 |  |  | 0 |  |  | 000-123-123 |  |  | 000-123 | 000-123-123
123-123-123 |  |  | 0 |  |  | 000-123-456 |  |  | 000-123 | 000-123-456
000-123-789 |  |  | 0 |  |  | 000-123-789 |  |  | 000-123 | 000-123-789
000-123-000 |  |  | 0 |  |  | 000-123-000 |  |  | 000-123 | 000-123-000
Spreadsheet: jeff_dasovich__14245__BF Good Exhibits
Sheet: Exhibit 1

 | NPV of Payments Garunteed by BFGoodrich
 |  | 0.12
 |  | Payments to Morgan | Receipts from Morgan | Payments to Bond Holders |  | BF Goodrich Cash Flows
 | 1983 | 125 |  | -50000 |  | 50000-125
 | 1984 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1985 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1986 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1987 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1988 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1989 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1990 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[25,000(x+.5)]
 | 1991 | 5500 + a | 50,000 (LIBOR-x)/2 | 50,000 (LIBOR +.5%)/2 |  | -[5,500 + 25,000(-x+.5) +a]
 |  |  |  | 50000 |  | -50000
a = annual fee to Morgan
Discount Rate | 0.12
 | NPV stream
 | Fee Payments to Morgan |  | =-[125+ (a/.12)*(1-(1/(1.12^8))] = |  | -[$125 + 4.967(a)]
 | Spread Payments on Libor |  | =-[(50,000*(x+.5)/2)/.0583 * (1-(1/(1.0583)^16)]= |  | -[255,624(x) + 1,278.1]
 | NPV of face bond |  | =50,000 - (50,000)/(1.12)^8
 | Setting cash flows equal to zero (NPV of issuing own 12% coupon 8 year bond)
 | By adding a get the following combination equation
 | With a F(x,a) such that    255,624 (x) + 4.967 (a) <= 1,080.7
 | Limiting ends
 | a= 0     x = | 0.00423 | x = 0                  a = 217.576
Spreadsheet: 816763d1675820503-index-match-to-skip-ignore-blanks-in-row-index-match-ignoring-blanks
Sheet: Sheet1

 | FORECAST
 | PROBLEM | WORK PACKAGE |  |  | 2023-02-20 00:00:00
 |  | TITLE | Start Date | End Date
 |  | Task 1
 |  | Task 2
 | EXPECTED RESULTS | WORK PACKAGE |  |  | 2023-02-20 00:00:00
 |  | TITLE | Start Date | End Date
 |  | Task 1 | $E$11:$E$13 | $F$11:$F$13 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Task 2 | $J$11:$J$13 | $K$11:$K$13 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 376230d1423524478-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | DW4
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | AQ1
1005 | 23 | 22 | C1 | SS2
 |  | Excel Question:
 |  | For each row in year 2, How do I find the value that doesn’t match year 1 values and bring back the column heading?
 |  | Here the values that are different to year 1 are highlighted in red
Spreadsheet: 677310d1589300767-replicating-a-time-as-a-single-digit-excel-help-time
Sheet: Sheet1

2020-05-12 00:00:00 | Start | Stop | 2020-05-12 08:00:00 | 08:15:00 | 08:30:00 | 2020-05-09 08:45:00 | 2020-05-08 09:00:00 | 2020-05-07 09:15:00 | 2020-05-06 09:30:00 | 2020-05-05 09:45:00 | 2020-05-04 10:00:00 | 2020-05-03 10:15:00 | 2020-05-02 10:30:00 | 2020-05-01 10:45:00 | 2020-04-30 11:00:00 | 2020-04-29 11:15:00 | 2020-04-28 11:30:00 | 2020-04-27 11:45:00 | 2020-04-26 12:00:00 | 2020-04-25 12:15:00 | 2020-04-24 12:30:00 | 2020-04-23 12:45:00 | 2020-04-22 13:00:00 | 2020-04-21 13:15:00 | 2020-04-20 13:30:00 | 2020-04-19 13:45:00 | 2020-04-18 14:00:00 | 2020-04-17 14:15:00 | 2020-04-16 14:30:00 | 2020-04-15 14:45:00 | 2020-04-14 15:00:00 | 2020-04-13 15:15:00 | 2020-04-12 15:30:00 | 2020-04-11 15:45:00 | 2020-04-10 16:00:00 | 2020-04-09 16:15:00 | 2020-04-08 16:30:00 | 2020-04-07 16:45:00 | 2020-04-06 17:00:00 | 2020-04-05 17:15:00 | 2020-04-04 17:30:00 | 2020-04-03 17:45:00 | 2020-04-02 18:00:00 | 2020-04-01 18:15:00 | 2020-03-31 18:30:00 | 2020-03-30 18:45:00 | 2020-03-29 19:00:00 | 2020-03-28 19:15:00 | 2020-03-27 19:30:00 | 2020-03-26 19:45:00
[NAME] | 08:00:00 | 16:15:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Minni | 09:00:00 | 17:15:00 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 128506d1321016288-numerical-sorting-800428-numerical-sorting-brelu
Sheet: Rank JB

 |  |  |  |  |  |  |  | MEMBERS SCORE CARDS (RANKED)
1 | 13 | 10 | 13 | 9 | 15 | 15 | 13 | 13 | 12 | 12 | 15 | 14 | 15 | 12 | 15 | 9 | 10 | 0 | 0 | 1st
2 | 14 | 11 | 11 | 8 | 12 | 10 | 13 | 13 | 13 | 13 | 14 | 15 | 14 | 14 | 15 | 10 | 8 | 0 | 0 | 2nd
3 | 12 | 10 | 15 | 11 | 13 | 12 | 12 | 10 | 10 | 10 | 10 | 12 | 13 | 14 | 15 | 12 | 15 | 0 | 0 | 3rd
4 | 14 | 12 | 11 | 15 | 11 | 11 | 12 | 11 | 11 | 10 | 10 | 12 | 12 | 10 | 15 | 11 | 10 | 0 | 0 | 4th
5 | 13 | 10 | 12 | 9 | 11 | 14 | 12 | 12 | 15 | 9 | 14 | 11 | 13 | 9 | 12 | 11 | 9 | 0 | 0 | 5th
6 | 14 | 9 | 12 | 9 | 13 | 11 | 10 | 12 | 13 | 12 | 13 | 14 | 13 | 11 | 9 | 11 | 9 | 0 | 0 | 6th
7 | 12 | 10 | 12 | 10 | 11 | 12 | 11 | 8 | 10 | 11 | 11 | 14 | 12 | 10 | 14 | 11 | 11 | 0 | 0 | 7th
8 | 12 | 8 | 12 | 7 | 11 | 8 | 13 | 6 | 10 | 11 | 12 | 15 | 13 | 9 | 14 | 11 | 12 | 0 | 0 | 8th
9 | 13 | 10 | 11 | 7 | 11 | 13 | 11 | 7 | 10 | 13 | 15 | 12 | 15 | 10 | 9 | 9 | 8 | 0 | 0 | 9th
10 | 12 | 8 | 9 | 9 | 11 | 9 | 11 | 11 | 9 | 10 | 12 | 14 | 9 | 9 | 15 | 11 | 12 | 0 | 0 | 10th
11 | 12 | 10 | 10 | 8 | 11 | 9 | 9 | 8 | 10 | 15 | 13 | 14 | 12 | 11 | 10 | 10 | 8 | 0 | 0 | 11th
12 | 10 | 9 | 12 | 9 | 11 | 11 | 10 | 10 | 11 | 9 | 12 | 11 | 9 | 12 | 10 | 8 | 11 | 0 | 0 | 12th
13 | 13 | 8 | 7 | 7 | 10 | 11 | 9 | 7 | 9 | 11 | 11 | 15 | 10 | 10 | 12 | 15 | 8 | 0 | 0 | 13th
14 | 12 | 9 | 10 | 8 | 11 | 15 | 12 | 9 | 10 | 10 | 11 | 11 | 9 | 8 | 8 | 8 | 11 | 0 | 0 | 14th
15 | 10 | 9 | 9 | 7 | 8 | 14 | 11 | 8 | 10 | 8 | 13 | 10 | 12 | 8 | 11 | 8 | 15 | 0 | 0 | 15th
16 | 10 | 7 | 9 | 6 | 11 | 8 | 12 | 10 | 10 | 9 | 12 | 13 | 11 | 9 | 7 | 10 | 8 | 0 | 0 | 16th
17 | 13 | 9 | 8 | 6 | 9 | 9 | 10 | 11 | 11 | 9 | 10 | 8 | 10 | 9 | 12 | 9 | 9 | 0 | 0 | 17th
18 | 10 | 7 | 9 | 4 | 8 | 10 | 9 | 7 | 8 | 9 | 9 | 15 | 8 | 8 | 13 | 12 | 8 | 0 | 0 | 18th
Spreadsheet: 834580d1687928418-randomly-but-equally-distribute-workload-among-a-list-of-workers-equal-random-distribution-1-
Sheet: Sheet1

0
List of People | Number of Jobs Assigned |  |  | Job Description | Job Assignee
Person A |  |  |  | Job 1
Person B |  |  |  | Job 2
Person C |  |  |  | Job 3
Person D |  |  |  | Job 4
Person E |  |  |  | Job 5
Person F |  |  |  | Job 6
Person G |  |  |  | Job 7
Person H |  |  |  | Job 8
Person I |  |  |  | Job 9
Person J
Person K
Person L
Spreadsheet: 696189d1600695794-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 1

Supplier 1 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product A | 2000 | 1 | -3 | 2020-10-01 00:00:00 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7500 | 0 | 22500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-02-01 00:00:00 | Product A |  | 2 | -3 | 2020-11-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-03-01 00:00:00 | Product A |  | 3 | -3 | 2020-12-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-04-01 00:00:00 | Product A |  | 4 | -3 | 2021-01-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 270645d1381565817-formula-for-multiple-matches-to-sum-result-from-another-column-into-another-sheet-sum-multiple-lookup-example
Sheet: LY Jul Data

GL Code |  | Selected Period | Budgeted | $ [NAME] | % Difference
6-1274 |  | 4950.8 | 800 | 4150.8 | 5.189
6-1275 |  | 31.53 | 0 | 31.53 | NA
6-1276 |  | 3358.37 | 1666.67 | 1691.7 | 1.015
6-2231 |  | 9803.7 | 10000 | -196.3 | -0.02
6-2232 |  | 3650.08 | 4218.33 | -568.25 | -0.135
6-2233 |  | 25769.22 | 31250 | -5480.78 | -0.175
6-2234 |  | 17307.7 | 13333.33 | 3974.37 | 0.298
6-2235 |  | 2769.24 | 3000 | -230.76 | -0.077
6-2273 |  | 1237.5 | 1560 | -322.5 | -0.207
6-2500
6-2505 |  | 3092.04 | 2612.87 | 479.17 | 0.183
6-2520 |  | 0 | 700 | -700 | -1
6-2525 |  | 1358.21 | 1200 | 158.21 | 0.132
6-2530 |  | 0 | 673.64 | -673.64 | -1
6-2540 |  | 5551.4 | 5562.15 | -10.75 | -0.002
6-2550 |  | 7801.7 | 1236.03 | 6565.67 | 5.312
6-2560 |  | 0 | 500 | -500 | -1
6-2565 |  | 509.95 | 700 | -190.05 | -0.272
6-2570 |  | 275.53 | 0 | 275.53 | NA
6-2598 |  | -1634.01 | 0 | -1634.01 | NA
6-2599 |  | -7375.57 | 0 | -7375.57 | NA
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Mnth 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
2001 Actual / CE2 | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
[NAME] | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
Spreadsheet: 114734d1310470065-total-from-multiple-spreadsheets-music2011sales
Sheet: Mar

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2011-03 | 1 | 1 | 1 | USD | [NAME] | [NAME] | iTunes U.S. | US
2011-03 | 13 | 0.71 | 9.23 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | GB
2011-03 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Meat | iTunes UK/European Union | GB
2011-03 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | It's a Penis | iTunes UK/European Union | GB
2011-03 | 213 | 0.92 | 195.96 | EUR | [NAME] | [NAME] | iTunes UK/European Union | GB
2011-03 | 1 | 0.71 | 0.71 | EUR | The Triple Coiler | Found Some Poo | iTunes UK/European Union | GB
2011-03 | 1 | 0.7 | 0.7 | CAD | Touching The Winky | Boobs | iTunes Canada | CA
2011-03 | 1 | 0.99 | 0.99 | AUD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes Australia/N.Z. | NZ
2011-03 | 6 | 0.99 | 5.94 | AUD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes Australia/N.Z. | AU
2011-03 | 2 | 1.29 | 2.58 | AUD | [NAME] | [NAME] | iTunes Australia/N.Z. | AU
2011-03 | 1 | 0.7 | 0.7 | USD | The Triple Coiler | Heads Shoulders Knees and Toes | iTunes U.S. | US
2011-03 | 1 | 5.4 | 5.4 | EUR | Touching The Winky |  | iTunes UK/European Union | GB
Spreadsheet: andy_zipper__221__Global_Prod 5-30-01 EM
Sheet: Not Available on 5-29-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
Credit Dflt Swap AT & T                  5 Years         bpa/USDm
Credit Dflt Swap BMW AG                  5 Years         bpa/USDm
Credit Dflt Swap DaimlerChrysler         5 Years         bpa/USDm
Credit Dflt Swap Fiat SpA                5 Years         bpa/USDm
Credit Dflt Swap Ford Credit             3 Years         bpa/USDm
Credit Dflt Swap Ford Credit             5 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           3 Years         bpa/USDm
Credit Dflt Swap GM Acceptance           5 Years         bpa/USDm
Credit Dflt Swap Volkswagen              3 Years         bpa/USDm
Credit Dflt Swap Volkswagen              5 Years         bpa/USDm
Credit Dflt Swap Volvo                   5 Years         bpa/USDm
Credit Dflt Swap Worldcom                5 Years         bpa/USDm
For Curr Exch    Forward                 31May01         JPY/USD
For Curr Exch    Forward                 31May01         USD/EUR
For Curr Exch    Forward                 31May01         USD/GBP
For Curr LME     LME (Spot)              31May01         JPY/USD
For Curr LME     LME (Spot)              31May01         USD/EUR
For Curr LME     LME (Spot)              31May01         USD/GBP
Foreign Currency Reuters BOFC            29May01         CAD/USD
Gasoil CIF Med   Platts Hi               Jun01           USD/mt
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG Gasoil Swap   Platts AP               Jun01           USD/bbl
[NAME]           WS/mt
US Crude Fin Opt NYMEX WTI    EC32.5     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC33.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP26.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.0     Jul01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP30.5     Jul01           USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q1 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q2 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q3 2002         USD/bl/m
US HeatOil2 Swap NYMEX HO CrkSpd         Q4 2002         USD/bl/m
US PL CapNNG [NAME] R+C      Jun01           USD/MM
US Wthr CDD Swap SAC 100/20K             May01           USD/CDD
US WTI Swap      Nymex                   Jan-Dec02       USD/bl/m
Spreadsheet: 149870d1334168311-advanced-filtering-by-using-functions-only-nighteg_test_11apr12_01
Sheet: Sheet1

 |  |  | /hungary |  |  | /hungary
 |  |  |  |  |  | /europe
 |  |  | /europe |  |  | /united-states
 |  |  | /united-states |  |  | /denmark
 |  |  |  | ???? |  | /france
 |  |  |  |  |  | /austria
 |  |  | /denmark |  |  | /asia-pacific
 |  |  | /france |  |  | /americas
 |  |  | /austria |  |  | /spain
 |  |  | /asia-pacific |  |  | /netherlands
 |  |  | /americas
 |  |  | /spain
 |  |  | /netherlands
 |  |  | /australia
 |  |  | /singapore
 |  |  | /portugal
 |  |  | /south-africa
Spreadsheet: james_steffes__12835__PX Values
Sheet: Notes

Advice Letter 2085-E
cost based pricing for URG
requested to be effective Dec 28, 2000
from D01-01-061 order# 11
 | URG pricing to be used in acctng proc. (TRA, TCBA, gen memo accts) from Dec 28 to Jan 31/01)
 | And in CPA
 | revised [NAME] for Dec 28 to Jan 31/01
 | to provide for use of "net costs assoc. [NAME]"
 | => implem PX change on Mar 5/01
 | PG&E stopped bidding URG into PX on Dec 28/00
 | PG&E filed calc of retained gen on Feb 23
 | URG = hydro, fossil, [NAME]
 | [NAME] pricing = ICIP during freeze, benefit-sharing after freeze
 | TCBA = revenues from URG, power purchase agreements and QF contracts
 | TRA (transition revenue acct) = revenues from customers
 |  | positive CTC amounts go from TRA to TCBA
 | for Dec 28 to Jan 31/01, cost based URG pricing used to record
 | costs and revenues into TCBA and TRA
 | All the submitted tariff sheets show is a change in the "development of hourly forward market costs. These costs equal:
 | "the sum of the cost in the day-ahead market in each zone, plus the costs of the hour ahead market in each zone,
 | plus the net gain or loss on transactions in the block forward market,
 | plus the net costs associated with PG&E's retained generation, all divided by the kWh purchased in all zones in all forward energy market for that hour.
Advice Letter 2101-E
billing method for CDWR
requested to be effective on May 21, 2001 (filed April 11)
will implement billing within 30 days following CPUC approval
from D01-03-081
 | submits new schedule E-GEN
 | 2 parts
 | 1) charges for power provided by CDWR
 |  | = %sales served by CDWR x gen charges for each rate schedule
 | 2) other gen. charges
 |  | QF's, purchased power agreements (PPA's), URG
 |  | also any charges from ISO relating to real time energy purchase costs
 |  | = sales x system avg rate each month
 |  | system avg rate det. By CPUC in A00-11-056 and 2085-E
D01-03-081
 | generation-rel. component is
 | total bundled electric rate, including one cent
 | less non-gen
 |  | T&D
 |  | PPP, ND and FTA
 | company wide rates
 |  | 7.277 cents for SCE
 |  | 6.471 cents for PG&E
 | the CPA rate = CPA revenues divided by all kWh sales, including DA sales
 | CPA revenue = generation-related revenue less
 |  | I) [NAME]
 |  | ii) QF contracts (est. at $80)
 |  | iii) existing bilateral conracts
 |  | iv) ancillary services
 | D01-04-005 sets the CPA rate, but does not allocate between DWR and the utilities
D01-05-064 May 15
 | orders utilities to switch to more precise method of segregating funds for CDWR
 | use method of calc number of CDWR supplied kWh in D01 03 081.
Advice Letter 2119-E
to be effective June 1
Spreadsheet: hunter_shively__12668__Nov_01 Volume Changes
Sheet: Nov 3-5

Pipeline | Producer | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed | Comments
[NAME] | Forest | [NAME] | 0 | 207 |  |  | 207
NGPL | Orion | LA | 100 | 0 |  |  | -100
NGPL | Orion | TXOK | 500 | 0 |  |  | -500
SNAT | Forest | Z0 | 0 | 207 | 207 |  | 207
STINGRAY | Min Mgmt | Holly Beach | 65410 | 66139 | 271 |  | 271
STINGRAY | Flextrend | Holly Beach | 2500 | 1608 |  | -392 | -500 |  | Will be back up on 11/6 to 2500
TENN | Torch | ZN 0, 100 | 0 | 50 |  |  | 50
TENN | Cabot | ZL, 500 | 18000 | 16000 |  | -1000 | -1000
TETCO | W&T | WLA | 2600 | 2382 |  | -218
TRUNKLINE | Forest | ELA | 14164 | 15250 |  |  | 1086
 |  |  |  |  | Day Total
 |  |  |  |  | MTD Total | -15384 | 548
Spreadsheet: 883824d1732548525-array-formula-to-exclude-aggregate-if-value-in-col-g-is-one-of-two-values-array-formula
Sheet: Register

 |  |  | DATA SUBJECT REQUEST REGISTER
 |  |  |  |  |  | Ensure Email Cell is [NAME]
Ref# | Date Request Received | Type of Request | Request | Data Subject Name | Data Subject Address/Email Address | Data Subject Location
52 | 2024-11-24 00:00:00 | Access |  | Person 1 |  | Location One
51 | 2024-11-20 00:00:00 | Access |  | Person 2 |  | Location One
50 | 2024-11-12 00:00:00 | Access |  | Person 3 |  | Location Two
49 | 2024-11-01 00:00:00 | Access |  | Person 4 |  | Location Three
48 | 2024-10-30 00:00:00 | Access |  | Person 5 |  | External
47 | 2024-10-29 00:00:00 | Access |  | Person 6 |  | Location Four
46 | 2024-10-28 00:00:00 | Access |  | Person 7 |  | External
45 | 2024-10-26 00:00:00 | Access |  | Person 8 |  | Location Five
44 | 2024-10-18 00:00:00 | Access |  | Person 9 |  | Location Three
43 | 2024-10-11 00:00:00 | Access |  | Person 10 |  | Partner
42 | 2024-10-04 00:00:00 | Access |  | Person 11 |  | Location One
41 | 2024-10-02 00:00:00 | Access |  | Person 12 |  | External
40 | 2024-10-01 00:00:00 | Erasure |  | Person 13 |  | External
39 | 2024-09-30 00:00:00 | Access |  | Person 14 |  | Location Six
38 | 2024-09-23 00:00:00 | Access |  | Person 15 |  | Partner
37 | 2024-09-16 00:00:00 | Access |  | Person 16 |  | External
36 | 2024-08-29 00:00:00 | Access |  | Person 17 |  | Location Seven
35 | 2024-08-28 00:00:00 | Access |  | Person 18 |  | Location Seven
34 | 2024-08-28 00:00:00 | Access |  | Person 19 |  | Location Five
33 | 2024-08-22 00:00:00 | Access |  | Person 20 |  | Partner
32 | 2024-08-22 00:00:00 | Erasure |  | Person 21 |  | Partner
31 | 2024-08-12 00:00:00 | Access |  | Person 22 |  | Partner
30 | 2024-08-05 00:00:00 | Access |  | Person 23 |  | Head Office
29 | 2024-08-01 00:00:00 | Access |  | Person 24 |  | Partner
28 | 2024-07-29 00:00:00 | Access |  | Person 25 |  | Partner
27 | 2024-07-29 00:00:00 | Access |  | Person 26 |  | External
26 | 2024-07-29 00:00:00 | Access |  | Person 27 |  | Head Office
25 | 2024-07-29 00:00:00 | Access |  | Person 28 |  | Location Seven
24 | 2024-07-17 00:00:00 | Access |  | Person 29 |  | Location Three
23 | 2024-07-08 00:00:00 | Access |  | Person 30 |  | Location Nine
22 | 2023-12-29 00:00:00 | Access |  | Person 31 |  | Partner
21 | 2023-12-29 00:00:00 | Erasure |  | Person 32 |  | Location One
20 | 2023-12-27 00:00:00 | Access |  | Person 33 |  | Location Two
19 | 2023-12-20 00:00:00 | Access |  | Person 34 |  | Location Four
18 | 2023-12-12 00:00:00 | Access |  | Person 35 |  | External
17 | 2023-12-06 00:00:00 | Access |  | Person 36 |  | Location Six