tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15992__AIG swaps positions
Sheet: Sheet1

Notional |  |  |  |  |  |  | PV'd
Sum of Quantity | Pub Code |  |  |  |  |  | Sum of Quantity2 | Pub Code
Period | IF-TRANSCO/Z6 | NGI/CHI. GATE | NX1 | NXB2 | Grand Total |  | Period | IF-TRANSCO/Z6 | NGI/CHI. GATE | NX1 | NXB2 | Grand Total
2001-12-01 00:00:00 | 0 | 0 | 732500 | 380000 | 1112500 |  | 2001-12-01 00:00:00 | 0 | 0 | 732074.1435 | 379779.0778 | 1111853.2213
2002-01-01 00:00:00 | 0 |  | 3776000 | -1090000 | 2686000 |  | 2002-01-01 00:00:00 | 0.0001000000047497451 |  | 3767016.2911 | -1087406.7154 | 2679609.5758
2002-02-01 00:00:00 | 0 |  | 2968000 | -1090000 | 1878000 |  | 2002-02-01 00:00:00 | 9.999994654208422e-05 |  | 2955552.8832 | -1085428.7881 | 1870124.0952
2002-03-01 00:00:00 | 0 |  | 1576000 | -1090000 | 486000 |  | 2002-03-01 00:00:00 | 0 |  | 1566820.6198 | -1083651.3169 | 483169.3029000005
2002-04-01 00:00:00 |  |  | 2575000 | -1300000 | 1275000 |  | 2002-04-01 00:00:00 |  |  | 2555417.1184 | -1290113.4966 | 1265303.6218
2002-05-01 00:00:00 |  |  | 1593500 | -1300000 | 293500 |  | 2002-05-01 00:00:00 |  |  | 1578421.0354 | -1287698.3657 | 290722.6697
2002-06-01 00:00:00 |  |  | 1575000 | -1300000 | 275000 |  | 2002-06-01 00:00:00 |  |  | 1557001.8088 | -1285144.3502 | 271857.4586000002
2002-07-01 00:00:00 |  |  | 1593500 | -1300000 | 293500 |  | 2002-07-01 00:00:00 |  |  | 1572102.8376 | -1282543.89 | 289558.9475999994
2002-08-01 00:00:00 |  |  | 1593500 | -1300000 | 293500 |  | 2002-08-01 00:00:00 |  |  | 1568550.2529 | -1279645.6409 | 288904.6120000002
2002-09-01 00:00:00 |  |  | 1575000 | -1300000 | 275000 |  | 2002-09-01 00:00:00 |  |  | 1546694.7006 | -1276636.8956 | 270057.8050000004
2002-10-01 00:00:00 |  |  | 1593500 | -1300000 | 293500 |  | 2002-10-01 00:00:00 |  |  | 1561103.8189 | -1273570.7339 | 287533.085
2002-11-01 00:00:00 |  |  | 650000 | -1350000 | -700000 |  | 2002-11-01 00:00:00 |  |  | 635103.9269 | -1319062.0022 | -683958.0752999998
2002-12-01 00:00:00 |  |  | 671000 | -710000 | -39000 |  | 2002-12-01 00:00:00 |  |  | 653878.4517000001 | -691883.3096 | -38004.85789999994
2003-01-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-01-01 00:00:00 |  |  | 116599.0087 |  | 116599.0087
2003-02-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-02-01 00:00:00 |  |  | 116241.0382 |  | 116241.0382
2003-03-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-03-01 00:00:00 |  |  | 115906.2565 |  | 115906.2565
2003-04-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-04-01 00:00:00 |  |  | 115522.1451 |  | 115522.1451
2003-05-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-05-01 00:00:00 |  |  | 115138.5264 |  | 115138.5264
2003-06-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-06-01 00:00:00 |  |  | 114729.3971 |  | 114729.3971
2003-07-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-07-01 00:00:00 |  |  | 114322.2635 |  | 114322.2635
2003-08-01 00:00:00 |  |  | 120000 |  | 120000 |  | 2003-08-01 00:00:00 |  |  | 113890.6821 |  | 113890.6821
Grand Total | 0 | 0 | 23432500 | -14050000 | 9382500 |  | Grand Total | 0.0001999999512918293 | 0 | 23172087.2064 | -13863006.4273 | 9309080.779299999
Spreadsheet: 810707d1671972808-index-match-column-row-with-duplicate-variables-in-the-row-ss-3-
Sheet: Sheet1

 | 2023-09-01 00:00:00 |  |  | Sale Date | Customer | Sale
Customer 1 | 1 |  |  | 2023-09-03 00:00:00 | Customer 2
Customer 1 |  | 3 | 4 | 2023-09-01 00:00:00 | Customer 2
Customer 2 | 2 | 2 |  | 2023-09-04 00:00:00 | Customer 2
Customer 3 |  | 2
Customer 2 | 1 |  | 1
Spreadsheet: 813964d1674075121-employee-rotation-taking-into-account-expected-absences-libro2
Sheet: Week 3

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ubicaciones
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BCN | PRAT
 |  |  |  |  |  | Lun, 16/01 | Mar, 17/01 | Mie, 18/01 | Jue, 19/01 | Vie, 20/01
 | Empleado | Ausencias
 | AA A | CC C |  |  |  |  | AA A |  | BB B
 | BB B | DD D |  |  |  |  | EE E |  | AA A
 | CC C
 | DD D
 | EE E
Spreadsheet: 67cc8e8c-efe9-49ba-afe7-d98570c7b89b
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
FENTS | Test | FENTS | [NAME], Serum | [NAME] and [NAME], S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Serum, [NAME] |  |  | 2.3 | mL | Container/Tube: Red top [NAME]: 2.3 mL Collection Instructions: Spin down within 2 hours of draw. | 1.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Not applicable | Monday | 2 days | 9 days | 1 | 80299 |  |  |  |  | Rochester
FENTS | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
FENTS | Result | 31829 | Norfentanyl | Norfentanyl | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 11074-2 | Norfentanyl:MCnc:Pt:Ser/Plas:Qn:
FENTS | Result | 31830 | [NAME] | [NAME] | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3636-8 | [NAME]:MCnc:Pt:Ser/Plas:Qn:
FENTS | Result | 31832 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 480260d1473844446-how-to-sum-how-many-items-you-have-per-date-sample
Sheet: Sheet1

 | Date raised |  | Date | File
 | 2016-09-14 00:00:00 |  | 2016-09-12 00:00:00 | 1
 | 2016-09-14 00:00:00 |  | 2016-09-13 00:00:00 | 2
 | 2016-09-13 00:00:00 |  | 2016-09-14 00:00:00 | 2
 | 2016-09-12 00:00:00 |  | 2016-09-15 00:00:00 | 0
 | 2016-09-20 00:00:00 |  | 2016-09-16 00:00:00 | 0
 | 2016-09-13 00:00:00 |  | 2016-09-17 00:00:00 | 0
 |  |  | 2016-09-18 00:00:00 | 0
 |  |  | 2016-09-19 00:00:00 | 0
 |  |  | 2016-09-20 00:00:00 | 1
Spreadsheet: 97c28ccc-dfea-49fd-9938-3b6d52b763ab
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
ISPG | Test | ISPG | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ISPG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ISPG | Result | ISPG | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6150-7 | [NAME] laxative [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 118659a4-3b82-4b2f-bb6d-2e37221a9bab
Sheet: Total Request

Calculator Instructions:                                                                                                FOOD GROUP - POLLUCK | Click on a processor name to access its calculator.  While calculator formats are different, each will help you estimate the number of pounds you will need by asking for your estimated number of servings, ect.   Note, each excel spreadsheet is restricted by food group.  While some processors offer multiple items on one calculator, your request will only populate on the Total Request tab if it is within the food group listed on that spreadsheet.  You will need to pull up the beef spreadsheet to allocate beef pounds, the chicken calculator to allocate chicken pounds, ect.
 | The calculator will automatically calculate the number of pounds you will need for a specific item, and will input that number on the Total Request tab.  Once finished, take the numbers in yellow and transfer them to your NOI Request Form.  Be sure you are inputting the correct number of pounds for each processor.  The processor number on this form should match the processor number on the NOI Request Form.
Processor | Broker | Contact | Material | [NAME] | USDA Value | Total Value
68. Highliner | Advantage Waypoint | [NAME] | 100892 |  | 1.6302
69. Trident Seafoods Corp | Elite Foodservice | [NAME] | 100892 |  | 1.6302
 |  |  |  |  | Total Value:
Spreadsheet: 791507d1660401766-help-creating-a-spreadsheet-to-check-for-crossovers-example
Sheet: DATES

 | 1 | 2
13/10//2022 | TEAM 2 | TEAM 3
2022-10-14 00:00:00 | TEAM 1 | TEAM 2
2022-10-15 00:00:00
2022-10-16 00:00:00
2022-10-17 00:00:00
2022-10-18 00:00:00
2022-10-19 00:00:00
2022-10-20 00:00:00
2022-10-21 00:00:00
2022-10-22 00:00:00
2022-10-23 00:00:00
2022-10-24 00:00:00
2022-10-25 00:00:00
2022-10-26 00:00:00
2022-10-27 00:00:00
2022-10-28 00:00:00
2022-10-29 00:00:00
2022-10-30 00:00:00
2022-10-31 00:00:00
2022-11-01 00:00:00
2022-11-02 00:00:00
2022-11-03 00:00:00
2022-11-04 00:00:00
2022-11-05 00:00:00
2022-11-06 00:00:00
2022-11-07 00:00:00
Spreadsheet: 90625d1290419587-creating-a-dynamic-bar-chart-based-on-counting-blank-cells-copy-of-excel-forum-dynamic-ranges
Sheet: Listing

Sample Data
Subject Number | Date of first | Still on | [NAME]? | Date of treatment | End of treatment reason | Total treatment
 | treatment | treatment? |  | cessation |  | duration
 |  |  |  |  |  | in days
1 | x | No | x | x | a | 5
2 | x | No | x | x | a | 7
3 | x | No | x | x | a | 11
4 | x | No | x | x | a | 12
5 | x | No | x | x | a | 12
6 | x | No | x | x | a | 18
7 | x | No | x | x | b | 3
8 | x | No | x | x | b | 4
9 | x | No | x | x | b | 4
10 | x | No | x | x | b | 6
11 | x | No | x | x | b | 7
12 | x | No | x | x | b | 9
13 | x | No | x | x | b | 9
14 | x | No | x | x | b | 12
15 | x | No | x | x | b | 12
16 | x | No | x | x | b | 12
17 | x | No | x | x | c | 4
18 | x | No | x | x | c | 7
19 | x | No | x | x | c | 15
20 | x | No | x | x | d | 2
21 | x | No | x | x | d | 9
22 | x | No | x | x | d | 11
23 | x | No | x | x | d | 13
24 | x | No | x | x | d | 19
25 | x | No | x | x | e | 2
26 | x | No | x | x | e | 4
27 | x | No | x | x | e | 4
28 | x | Yes | x | x |  | 1
29 | x | Yes | x | x |  | 1
30 | x | Yes | x | x |  | 3
31 | x | Yes | x | x |  | 6
32 | x | Yes | x | x |  | 6
33 | x | Yes | x | x |  | 6
34 | x | Yes | x | x |  | 11
35 | x | Yes | x | x |  | 12
36 | x | Yes | x | x |  | 15
37 | x | Yes | x | x |  | 16
38 | x | Yes | x | x |  | 19
39 | x | Yes | x | x |  | 20
40 | x | Yes | x | x |  | 20
41 | x | Yes | x | x |  | 21
42 | x | Yes | x | x |  | 25
43 | x | Yes | x | x |  | 25
44 | x | Yes | x | x |  | 26
45 | x | Yes | x | x |  | 28
46 | x | Yes | x | x |  | 30
47 | x | Yes | x | x |  | 33
48 | x | Yes | x | x |  | 34
49 | x | Yes | x | x |  | 36
50 | x | Yes | x | x |  | 41
End Sample Data
Spreadsheet: 874385d1720974584-i-need-to-separate-men-and-women-scores-boharris-no-tap-bowling-scores-template-2-aligw
Sheet: No Tap Roster

Total Bowlers
Date |  |  |  |  | 1 | [NAME] | 202 | M
# | NAME | M/W | HDCP | Paid | 2 | [NAME] | 100 | M
 |  |  |  |  | 3 | [NAME] | 145 | M
 |  |  |  |  | 4 | [NAME] | 189 | W
 |  |  |  |  | 5 | [NAME] | 189 | W
 |  |  |  |  | 6 | [NAME] | 199 | M
 |  |  |  |  | 7 | Coleen | 53 | W
 |  |  |  |  | 8 | [NAME] | 205 | W
 |  |  |  |  | 9 | Doug | 155 | M
 |  |  |  |  | 10 | [NAME] | 165 | M
 |  |  |  |  | 11 | [NAME] | 175 | M
 |  |  |  |  | 12 | [NAME] | 113 | M
 |  |  |  |  | 13 | CeCe | 195 | W
 |  |  |  |  | 14 | [NAME] | 200 | M
 |  |  |  |  | 15 | [NAME] | 201 | W
 |  |  |  |  | 16 | [NAME] | 100 | M
 |  |  |  |  | 17 | Beryl Slie | 240 | M
 |  |  |  |  | 18 | [NAME] | 224 | W
 |  |  |  |  | 19 | [NAME] | 93 | M
 |  |  |  |  | 20 | [NAME] | 100 | W
 |  |  |  |  | 21 | [NAME] |  | M
 |  |  |  |  | 22 | [NAME] |  | M
 |  |  |  |  | 23 | [NAME] |  | W
 |  |  |  |  | 24 | [NAME] |  | W
 |  |  |  |  | 25 | [NAME] |  | W
 |  |  |  |  | 26 | [NAME] |  | W
 |  |  |  |  | 27 | Mac |  | M
 |  |  |  |  | 28 | [NAME] |  | M
 |  |  |  |  | 29 | [NAME] |  | M
 |  |  |  |  | 30 | [NAME] |  | M
 |  |  |  |  | 31 | [NAME] |  | M
 |  |  |  |  | 32 | [NAME] |  | M
 |  |  |  |  | 33 | [NAME] |  | M
Spreadsheet: richard_sanders__31693__Ice Drilling legal fees
Sheet: Ice legal fees

ICE DRILLING
Detail of Bankruptcy Legal Expenses
As of 4/30/01
Posting Date per SAP |  | Amount |  | Description
2000-08-17 00:00:00 |  | 861.59 |  | Blake, Cassels & Graydon legal expenses
2000-08-18 00:00:00 |  | 700 |  | Blake, Cassels & Graydon legal expenses
2000-12-05 00:00:00 |  | 1417.55 |  | Blake, Cassels & Graydon legal expenses
2000-12-18 00:00:00 |  | 3284.7 |  | Blake, Cassels & Graydon legal expenses
2000-12-31 00:00:00 |  |  |  | Blake, Cassels & Graydon legal expenses
2001-02-21 00:00:00 |  | 6496.38 |  | BDO retainer fee
2001-03-09 00:00:00 |  | 470.42 |  | Blake, Cassels & Graydon legal expenses
Outstanding as of 4/30/01 |  | 3761.97 |  | Blake, Cassels & Graydon legal expenses
Outstanding as of 4/30/01 |  | 14829.94 |  | Blake, Cassels & Graydon legal expenses
Spreadsheet: 417535f5-3697-456f-8160-d0cc580c6ba5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3853 | 15876 | [NAME] | Pritchard-Peschek | AUS | 0 | 00:41:58 | 00:00:43 | 01:27:45 | 00:00:56 | 00:22:05 | 1 | 02:33:29
Spreadsheet: 812411d1673123884-vlookup-and-if-statement-test-if-statement
Sheet: Sheet1

Grade | Min | Mid | [NAME]
2 | 15.96 |  | 20.75
3 |  |  | 22.62
4
5
6
7 |  |  |  | '=IF(AND(A2=2,D2<=20.75),D2,"Above [NAME], adjust")
8
9
10 |  |  |  |  | Don't know what the blu triangle means.
11
12
13
14
15
Pay Grade | Pay Rate | New Rate
3 | 19
11 | 50
9 | 40 |  |  |  | '=VLOOKUP(C19,A2:D15,4,0)
6 | 23
7 | 33
14 | 50
5 | 27
Pay Grade can be 2 though 15
New rate formula for Pay Grade 2  is =IF(AND(A2=2,D2<=20.75),D2,"Above [NAME], adjust")
Is there a way to create a formula that encompasses all pay grades without using 14 If statements?
by combining a vlookup with an if(and) statement
Spreadsheet: 744437d1629244021-vcard-to-excel-two-way-lookup-skip-blanks-vcard-export-sample
Sheet: Sheet1

BEGIN | VCARD
VERSION | 3
CATEGORY | Business
N | Bgood | [NAME]
ORG | FSDFLKSF | Every 6 Weeks $340.00
ADR | WORK
ADR | HOME | PREF
TEL | CELL | (123) 156-1234
TEL | PREF | [NAME]
END | VCARD
BEGIN | VCARD
VERSION | 3
CATEGORY | Business
N | Football | [NAME]
ORG | SDFSDFS | Every 7 Weeks $845
TITLE | 5w+156
ADR | WORK
ADR | HOME | PREF
TEL | HOME | (123) 123-4567
TEL | WORK | (234) 234-4567
TEL | FAX | (345) 678-9123
TEL | CELL | (456) 789-1234
END | VCARD
BEGIN | VCARD
VERSION | 3
CATEGORY | Business
N | Schmo | [NAME]
ORG | SDFSDFSGS | 4
TITLE | 10d+234234
ADR | WORK
ADR | HOME | PREF
TEL | HOME | PREF
TEL | CELL | (001) 987-6543
TEL | A.M.
END | VCARD
Spreadsheet: 536630d1504612971-min-if-function-across-multiple-worksheets-min-if-test-sheet-gk-yet-again
Sheet: summary

Project | Start |  |  |  |  |  |  |  | 2015
A | 2015-01-01 00:00:00 |  |  |  |  |  |  |  | 2016
B | 2015-01-01 00:00:00 |  |  |  |  |  |  |  | 2017
C | 2015-04-01 00:00:00
D | 2015-02-01 00:00:00
E | 2015-02-01 00:00:00
F | 2016-02-01 00:00:00
Spreadsheet: 728217d1618371421-automatic-copy-data-to-other-sheet-based-on-date-value-samplefilehpr
Sheet: Mar-02

DAILY REPORT SHIPPING COSTS
RS NUMBER   : |  | 1 | /SB/III/2021
No | Trans Date | Ship Date | Cust 1 | Driver Name | No Pol | Type | Cust 2 | City 2 | Cust 3 | City 3
1
2
3
4
5
6
7
8
9
10
 | SUB TOTAL
 | Cilegon, | 2021-03-02 00:00:00
Spreadsheet: kate_symes__18468__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
Spreadsheet: 711807d1609923827-pulling-one-of-multiple-headers-in-single-column-based-on-information-below-schedule-gk-06-01-0900
Sheet: Daily Sheet

DAILY STAFFING SHEET
a |  |  |  |  |  | p
X | m | a | e | n | d | y
 |  | Date |  |  | DAY:
7a - 3p |  | 3p - 7p |  | 7p -11p |  | 11p - 7a
Name | Department | Name | Department | Name | Department | Name | Department
Spreadsheet: jeff_dasovich__14156__m010508e
Sheet: Core & Non-core

 |  |  |  |  |  |  | Toggle switch | 0 | 1=83,000 mw
 | 2001 |  |  |  |  |  | Total Vol |  | 0=93,000 mw
 | PGE | SCE | SDGE |  |  |  | Toggle switch | 0 | 1=dwr for spot (104)
 |  |  |  |  |  |  | Prices |  | 0=dwr/hen for spot (82.75)
Under 500kW (core) CPUC
Over (non core) CPUC |  |  |  |  |  |  | Toggle switch | 0 | 1=All nc
Total CPUC (demand) |  |  |  |  |  |  | Past Utility |  | 0=Core and NC
[NAME] (supply)* |  |  |  |  |  |  | Toggle switch | 0 | 1=Over 500kW
 |  |  |  |  |  |  | 20kW/500kW |  | 0=Over 20kW
[NAME] |  |  |  |  |  |  | *PG&E, SCE only
Open long (short)
Core / Open Long / (short) position
* From 2001 estimated (page 27 MOU slides)
 | PGE | SCE | SDGE
Past DWR |  | 400
Future DWR |  | 2700
Past Utility with 15 year amortization assumption |  | 300
Future Utility |  | 3900
Total Gen
Other T&D
Total Revenue
Other T&D per Ghw (cents) | 3.91 | 4.2 | 6.23
T&D per CPUC | 3.95 | 4.02
Core Cost: |  |  |  |  | Cents per kw:
Share of past DWR
Cost of short
Value of long
Cost of generation + QF
Share of Past Utility with 20 year amortization |  |  | 0
Total Gen
Other T&D (at~200% of non-core rate)
Total
Total Core Load
Cost to Core
Cost to Core per proposed CPUC
Non-Core Cost: |  |  |  |  | Cents per kw:
Share of past DWR
Cost of short
Share of Past Utility with 20 year amortization
Total Gen
Other T&D
Total
Total Non-Core Load
Cost to Non-Core
Cost to Non-Core per proposed CPUC
 | PGE | SCE | SDGE
Core Rate T&D (cents) |  |  | 6.379
Non Core T&D (cents)
All T&D  (cents)
Total dollars T&D
Core T&D/non core T&D
Core T&D/ All T&D
Per 12/31/00 10-K (kwh) | 81923 | 83436 | 19322
Electric revenue | 6854 | 7870 | 2184
Electric Revenue per kwh
Generating portion per MOU | 5.5 | 6.3 | 5.5
T&D and other costs
T&D and other costs
Spreadsheet: 773655d1647976948-low-pdf-resolution-from-excel-for-mac-chart-test-for-mac-pdf-print
Sheet: Sheet1

 |  |  |  |  |  |  |  | Review 1 |  |  |  | Review 2 |  |  | Review 3
 |  |  |  |  |  |  |  | 3 | 6 | 1 | 0 | 4 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2 | 5 | 2 | 0 | 4 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2 | 4 | 2 | 0 | 4 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2 | 3 | 2 | 0 | 4 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 2 | 2 | 2 | 0 | 4 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 3 | 1 | 1 | 0 | 4 | 0 | 0 | 0
Spreadsheet: 88844d1288682475-pull-value-from-table-on-excel-verse-distance-in-cm_b
Sheet: Sheet2

Days/Hours | Days/Hours | Days/Hours |  |  |  |  |  |  |  |  |  |  |  | Days/Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ares
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Athens
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Beaumonde
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Bellerophon
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Beylix
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Boros
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Deadwood
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dyton
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Freehold
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Greenleaf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Harvest
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Haven
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]' [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Jiangyin
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lilac
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Londinium
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Canaan
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Melbourne
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Newhall
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Paquin
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Persephone
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Regina
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Santo
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shadow
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shinbone
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sihnon
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Silverhold
 |  |  |  |  |  |  |  |  |  |  |  |  |  | St. Albans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Three Hills
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Triumph
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Verbena
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Whitefall
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Whittier
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]