tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275208d1383393597-n-a-error-ef514a_lean-to-roofs
Sheet: Grid_3

Grid 3 |  | LEAN TO ROOF
 | Increments: | Across: | 500
 |  | Down: | 500
conservatory size |  | width | 3.1 | depth | 2.5 | valid: | Yes | Price:
WIDTH | 2500 | 3000 | 3500 | 4000 | 4500 | 5000 | 5500 | 6000 | 6500 | 7000
DEPTH
2500 | 672 | 672 | 804 | 936 | 936 | 1068 | 1068 | 1200 | 1200 | 1332
3000 | 672 | 804 | 870 | 1002 | 1002 | 1134 | 1134 | 1272 | 1272 | 1404
3500 | 804 | 870 | 936 | 1068 | 1134 | 1200 | 1200 | 1200 | 1320 | 1464
4000 | 939 | 1002 | 1068 | 1134 | 1200 | 1272 | 1272 | 1320 | 1320 | 1464
Spreadsheet: 468043d1467113209-indirect-and-concatenate-example
Sheet: Sheet1

 |  | [NAME] | 10
 |  | Average
Spreadsheet: 744042d1628876421-extracting-data-from-multiple-sheets-lookup-value-new
Sheet: Master Contact

Name | id no. | E-mail 1 - Value | unit no.
Name | Memtdertiis No.
1-tmriti toni 2- [NAME] tantoti toni | DaY033
aatiita Kalra | tR50201
[NAME] | aaY1207
atddul Waiid Ratier | tR50037
atdiidartii arma | tR51142
atdiijit [NAME] | RTi10131
atdiijit ten | Otd0164
xyz | tR70146
[NAME] | tR7081123
atdiitiek | tR50200
[NAME] | RH60031
ykhil Myhyjyn | SR70287
ykhil Mylhotry | q60082
ykhiltsh ktyr | q60510
bgkhiltsh [NAME] | q60614
[NAME] | SR70432
bglkbg [NAME] | SH80244
bgMbgN KUMbgR | SR50429
bgmbgrdttp Singh | OB0157
Spreadsheet: 814029d1674123263-returns-all-values-which-start-with-extract-based-on-first-8-characters-bsb-
Sheet: Sheet1

42379114-200-001
42379722-100-001 |  |  | 42355121
42379805-100-001 |  |  |  | 42355121-100-001
42375578-100-001
42377607-100-001
42376184-100-001
42377880-100-001
42375146-100-001
42362211-100-001
42360608-200-001
42360633-200-001
42375633-100-001
42351694-100-001
42351120-100-001
42355121-100-002
42355121-100-001
42355118-100-001
42354487-100-002
42354487-100-001
42354926-100-001
42335283-100-001
42320073-100-001
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 125289 | 125129
2 | 151397 | 150614
3 | 140641 | 140609
4 | 140745 | 140609
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2002-02-28 00:00:00 |  |  | -13945 |  |  |  | 530
2002-03-04 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | -7030
Spreadsheet: 883041d1731522931-cleaning-date-formats-in-excel-dates-1-
Sheet: Sheet1

2023-01-01 00:00:00
2023-01-08 00:00:00
2023-01-15 00:00:00
January 22, 2023
January 29, 2023
February 5, 2023
2023-02-12 00:00:00
2023-02-19 00:00:00
February 26, 2023
March 5, 2023
2023-03-12 00:00:00
2023-03-19 00:00:00
March 26, 2023
2023-04-02 00:00:00
2023-04-09 00:00:00
2023-04-16 00:00:00
2023-04-23 00:00:00
2023-04-30 00:00:00
2023-05-07 00:00:00
2023-05-14 00:00:00
2023-05-21 00:00:00
2023-05-28 00:00:00
June 4, 2023
2023-06-11 00:00:00
2023-06-18 00:00:00
2023-06-25 00:00:00
2023-07-02 00:00:00
July 9, 2023
July 16, 2023
July 23, 2023
July 30, 2023
2023-08-06 00:00:00
2023-08-13 00:00:00
2023-08-20 00:00:00
2023-08-27 00:00:00
2023-09-03 00:00:00
September 10, 2023
2023-09-17 00:00:00
2023-09-24 00:00:00
2023-10-01 00:00:00
2023-10-08 00:00:00
2023-10-15 00:00:00
2023-10-22 00:00:00
2023-10-29 00:00:00
2023-11-05 00:00:00
2023-11-12 00:00:00
November 19, 2023
2023-11-26 00:00:00
2023-12-03 00:00:00
2023-12-10 00:00:00
2023-12-17 00:00:00
2023-12-24 00:00:00
2023-12-31 00:00:00
2024-01-07 00:00:00
January 14, 2024
2024-01-21 00:00:00
2024-01-28 00:00:00
2024-02-04 00:00:00
2024-02-11 00:00:00
2024-02-18 00:00:00
2024-02-25 00:00:00
2024-03-03 00:00:00
2024-03-10 00:00:00
2024-03-17 00:00:00
2024-03-24 00:00:00
2024-03-31 00:00:00
2024-04-07 00:00:00
2024-04-14 00:00:00
2024-04-21 00:00:00
2024-04-28 00:00:00
2024-05-05 00:00:00
2024-05-12 00:00:00
2024-05-19 00:00:00
2024-05-26 00:00:00
2024-06-02 00:00:00
June 9, 2024
2024-06-16 00:00:00
2024-06-23 00:00:00
2024-06-30 00:00:00
2024-07-07 00:00:00
2024-07-14 00:00:00
2024-07-21 00:00:00
2024-07-28 00:00:00
2024-08-04 00:00:00
2024-08-11 00:00:00
August 18, 2024
2024-08-25 00:00:00
2024-09-01 00:00:00
2024-09-08 00:00:00
2024-09-15 00:00:00
2024-09-22 00:00:00
2024-09-29 00:00:00
October 6, 2024
October 13, 2024
October 20, 2023
October 27, 2023
2024-11-03 00:00:00
2024-11-10 00:00:00
November 17, 2024
November 24, 2024
Spreadsheet: 200272d1355482466-adding-1-darts-2013new
Sheet: dec_B

Dec 4 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed |  |  |  | Blanc i Blau
 |  |  |  |  |  | double |  |  |  | Taj A
 |  | Taj A | V | BYE |  |  |  |  |  | Taj B
 | 6 | Blanc i Blau | V | Casa Tia | 3 | H |  |  |  | San Mames
 | 6 | Bar S'Placa | V | Galleon | 3 | H |  |  |  | Bar S'Placa
 | 9 | Bar 2 A | V | [NAME] | 0 | H |  |  |  | Bar 2 A
 | 4 | Taj B | V | San Mames | 5 | H |  |  |  | Galleon
 |  |  |  |  |  |  |  |  |  | [NAME]
Dec 11 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed |  |  |  | Casa Tia
 |  |  |  |  |  | double |  |  |  | BYE
 |  | Galleon | V | BYE
 | 0 | [NAME] | V | San Mames | 9 | A
 | 7 | Blanc i Blau | V | Bar S'Placa | 2 | H
 | 2 | Taj A | V | Bar 2 A | 7 | A
 | 5 | Casa Tia | V | Taj B | 4 | H |  |  |  | DEC
Dec 18 | LEGS | Home/Casa |  | Away/Afuera | LEGS | mixed
 |  |  |  |  |  | double
 |  | San Mames | V | BYE
 |  | Galleon | V | Blanc i Blau
 |  | Taj B | V | [NAME]
 |  | Bar 2 A | V | Casa Tia
 |  | Bar S'Placa | V | Taj A
Spreadsheet: 55639d1255728373-pivot-tables-help-on-pivot-tables
Sheet: Sheet2

 | 09/13/2009 12:01:00 AM | Semaine du 14 Septembre 2009
 | 09/20/2009 12:01:00 AM | Semaine du 21 Septembre 2009
 | 09/27/2009 12:01:00 AM | Semaine du 28 Septembre 2009
 | 10/04/2009 12:01:00 AM | Semaine du 5 Octobre 2009
 | 10/11/2009 12:01:00 AM | Semaine du 12 Octobre 2009
 | 10/18/2009 12:01:00 AM | Semaine du 19 Octobre 2009
 | 10/25/2009 12:01:00 AM | Semaine du 26 Octobre 2009
 | 11/01/2009 12:01:00 AM | Semaine du 2 Novembre 2009
 | 11/08/2009 12:01:00 AM | Semaine du 9 Novembre 2009
 | 11/15/2009 12:01:00 AM | Semaine du 16 Novembre 2009
 | 11/22/2009 12:01:00 AM | Semaine du 23 Novembre 2009
 | 11/29/2009 12:01:00 AM | Semaine du 30 Novembre 2009
 | 12/06/2009 12:01:00 AM | Semaine du 7 Décembre 2009
 | 12/13/2009 12:01:00 AM | Semaine du 14 Décembre 2009
 | 12/20/2009 12:01:00 AM | Semaine du 21 Décembre 2009
 | 12/27/2009 12:01:00 AM | Semaine du 28 Décembre 2009
 | 01/03/2010 12:01:00 AM | Semaine du 4 Janvier 2010 |  |  |  |  |  | Semaine
 | 01/10/2010 12:01:00 AM | Semaine du 11 Janvier 2010
 | 01/17/2010 12:01:00 AM | Semaine du 18 Janvier 2010 |  |  |  |  | 10/01/2009 06:22:13 PM | Semaine du 28 Septembre 2009
 | 01/24/2010 12:01:00 AM | Semaine du 25 Janvier 2010
 | 01/31/2010 12:01:00 AM | Semaine du 1er Février 2010
 | 02/07/2010 12:01:00 AM | Semaine du 8 Février 2010
Spreadsheet: 472536d1469631251-how-to-have-specific-text-populate-based-on-number-of-occurrences-blank
Sheet: Want

 |  |  | # of Active Major PDAs |  | PDA LOG |  |  | # of Active Other PDAs |  | TOC |  | TOC
Employee:
Manager:
 | Major Audit Non-Conformities |  |  |  |  | Major Non-Conformities
 | Monitored for a rolling 180 day period. |  |  |  |  | Monitored for a rolling 180 day period.
 | Date of PDA | Roll off Date | Level of PDA | Reason |  | Date of PDA | Roll off Date | Level of PDA | Reason
 | 2016-01-01 00:00:00
 | 2016-05-01 00:00:00 |  | Coaching
 | 2016-06-01 00:00:00 |  | Verbal
 | 2016-07-01 00:00:00 |  | First Written
Spreadsheet: 85606d1285689323-sumproduct-stocks-sample
Sheet: PRODUCTION

TOTAL STOCK REQUIREMENTS:
Production |  | MODEL | BRACKETS FOR BEDS | TUBE HOLDERS | TUBE | HINGE | BUFFERS | GLIDERS | KDS 12.5MM | KDS 9.00MM | ALUMINIUM STRIP FOR TOPS | METAL BASE 150 X 190 | METAL BASE 90 X 200 | DRAWER RUNNER | HOOKS | checksum
Week | Ready Y/N
2010-09-06 00:00:00 |  | ALASKA | 4 | 10 | 5 | 28 | 16 | 50 | 64 | 28 | 1 | 1 | 0 | 3 | 2 | 212
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 119679d1314649970-count-text-count-text
Sheet: Sheet1

 |  |  |  | Date | [NAME] | Sales |  | Top | Top 5 Sales people | Number of Sales
 | 1 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 26 |  | 1 | [NAME] | 10 |  |  |  | [NAME]
 | 2 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 12 |  | 2 | [NAME] | 8 |  |  |  | [NAME]
 | 3 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 4 |  | 3 |  | ? |  |  |  | [NAME]
 | 4 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 78 |  | 4 | ? | ? |  |  |  | [NAME]
 | 5 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 78 |  | 5 | ? | ? |  |  |  | [NAME]
 | 6 | [NAME] |  | 2011-06-06 00:00:00 | Tanya | 26 |  |  |  |  |  |  |  | [NAME]
 | 7 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 58 |  |  |  |  |  |  |  | [NAME]
 | 8 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 72 |  |  |  |  |  |  |  | [NAME]
 | 9 | Mark |  | 2011-06-06 00:00:00 | [NAME] | 55 |  |  |  |  |  |  |  | Mark
 | 10 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 87 |  |  |  |  |  |  |  | [NAME]
 | 11 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 554 |  |  |  |  |  |  |  | [NAME]
 | 12 | Tanya |  | 2011-06-06 00:00:00 | [NAME] | 15 |  |  |  |  |  |  |  | Tanya
 | 13 | [NAME] |  | 2011-06-06 00:00:00 | Gavin | 55 |  |  |  |  |  |  |  | [NAME]
 | 14 | Gavin |  | 2011-06-06 00:00:00 | [NAME] | 552 |  |  |  |  |  |  |  | Gavin
 | 15 | [NAME] |  | 2011-06-06 00:00:00 | [NAME] | 65 |  |  |  |  |  |  |  | [NAME]
 |  |  |  | 2011-06-06 00:00:00 | [NAME] | 985
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2255
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 22
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 225
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2296
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 225
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 2259
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 398
 |  |  |  | 2011-06-07 00:00:00 | Tanya | 6259
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 6329
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 229
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 523
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 52269
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 822
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 522
 |  |  |  | 2011-06-07 00:00:00 | [NAME] | 922
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 516
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 5185
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 658
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 2648
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 256
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 587
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 574
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 258
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 218
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 159
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 94
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 1988
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 4198
 |  |  |  | 2011-06-08 00:00:00 | [NAME] | 488
Spreadsheet: 677381d1589323335-data-categorised-formula-test1
Sheet: Sheet1

 | A | B | A | A | A | B | A | B | (This will be hidden)
 | Sale | Approx | Target | Achieved | Not Achieved | Final | Conclusion | Finsih line |  |  | Total As | A | Total Bs | B
Spreadsheet: 808059d1670261386-how-to-group-multiple-results-based-on-one-criteria-sample-book-1
Sheet: Sheet1

Department Number | Employee Personnel |  |  |  | Contract Number | Employee
11355 | Stacy |  |  |  | 11355 | Stacy, [NAME], [NAME], [NAME]
11355 | [NAME] |  |  |  | 11457 | [NAME], [NAME], Stanely, [NAME]
11355 | [NAME] |  |  |  | 12110 | [NAME]
11355 | [NAME] |  |  |  | 11425 | [NAME]
11457 | Michelle |  |  |  | 321546 | Francisco
11457 | [NAME] |  |  |  | 321654 | [NAME], [NAME]
11457 | Stanley
11457 | [NAME]
12110 | [NAME]
11425 | [NAME]
321546 | Francisco
321654 | George
321654 | [NAME]
321654 | [NAME]
Spreadsheet: 147531d1332844612-excel-2007-microsoft-excel-spaces-in-dependant-lists-test
Sheet: Selection Sheet

BeautyandRelaxation | Sport & fitness Massage | Pole Dancing Experience | Paintballing for 4 | Ferrari thrill at Silverstone | 3 Bottle Case of Fine Wine | Flowers for all occasions | Hotel Stay and [NAME] | Junior Karting | Stop Smoking Therapy | Theatre Trips
LearnHow | Thumping Swedish Massage | [NAME] | Zorbing for two | Motor racing | [NAME] | Perfume and [NAME] |  | Family pass for Chester Zoo | Picture Canvas | Concert Tickets
AdrenalineandFlight | Pre Natal Treatment | Poker Experience | Whitewater Rafting | Karting | 6 Bottle Case of Wine |  |  | Blue Planet Aquarium | Name a Star | Theatre and Show Tickets
FitnessandDrive | [NAME] | [NAME] | [NAME] | Quad Bike Experience | 12 Bottle Case of Wine |  |  | Old Trafford stadium tour | Personalised Bottle of Champagne
ChampersandHampers | Stimulating Hip and Thigh Treatment | Flying Lesson | [NAME] | Mountain Bike | Moet & Chandon |  |  | Pleasure Beach wrist bands | Original Playboy Magazine
FragranceandFlowers | St. Tropez Tanning | Beginners Ice climbing | Aerobatic Flight | Ice Climbing (non beginners) | Champagne surprise |  |  | The Sandcastle at Blackpool | Ladies Designer Sunglasses
HotelStayandTripsAway | [NAME] | Casino Experience | Dragon Rapide Pleasure flight | Shrigley Hall Hotel Golf Club | Gourmet Food Hamper |  |  | Alton Towers day pass | Men`s Designer Sunglasses
FamilyFun | Full Day Indulgence | Dance lessons | [NAME] | Golfing Pass | Luxury Beer Hamper |  |  | Annual Cinema Pass | Hot Air Balloon ride
UniqueGiftsandVouchers | Luxury Pedicure | [NAME] |  | Pilates or Yoga class | Chocolate gift Tower |  |  |  | Stunt Kite
TheatreTripsandConcertTickets | Relaxation day for two | Driving Lessons |  | Indoor Climbing |  |  |  |  | Personal Shopping experience
 | Honey Farm | [NAME] |  |  |  |  |  |  | [NAME] Master
 | Happy Bathday |  |  |  |  |  |  |  | Shopping Vouchers
 |  |  |  |  |  |  |  |  | Cafe Salary
Spreadsheet: 175406d1345520158-sorting-numeric-and-alphanumeric-data-sorting-sample-2-
Sheet: SF-1 list

Position Number | Position Title
73252T | Professor
73290 | [NAME]
73333 | Professor
73336 | [NAME]
73358 | Specialist
73379 | Professor
73386T | [NAME]
73388 | Junior Specialist
73410T | [NAME] [NAME]
73412T | Instructor
77769 | Institutional Support
78293T | Information Technology
78643 | Information Technology
78945T | Institutional Support
79042T | Institutional Support
79421T | Information Technology
79589T | Academic Support
79603T | Institutional Support
80777 | Media Design & Prod
81011T | Institutional Support
82557 | [NAME]
86552T | [NAME]
89511T | [NAME]
90019 | [NAME]
90052 | Office Assistant III
90058 | Office Assistant III (Vice)
90101F | Institutional Support
91100F | Office Assistant III
91101F | Office Assistant III
Spreadsheet: 118926d1314101967-highlight-duplicate-rows-without-helper-column-book1_tone640_cf
Sheet: Sheet1

 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 11
 |  |  | 10
 |  |  | 9
 |  |  | 8
 |  |  | 7
 |  |  | 6
 |  |  | 5
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 1
 |  |  | 0
 |  |  | -1
 |  |  | -2
 |  |  | -3
Spreadsheet: 329741d1404394908-calculate-price-based-on-number-of-miles-miles-etaf2-
Sheet: Data

 |  | [NAME] | Cost
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
Spreadsheet: 286128d1388079361-fill-in-page-from-another-page-in-workbook-tracking-help-
Sheet: Master

WO | Lead | Location | Part Number | Customer | Qty | Due Date | [NAME] | Balance | Est. [NAME] | Est. Time/cable | Est. days to complete | Est. Completion Date | Working Days | Demand/Day | Takt (Min) | Act. Qty per day | FPY% | Act. Passed per day | Act. Days to complete | Act. Complete Date
Spreadsheet: 537776d1505250724-eliminating-blanks-excelhelpforum
Sheet: Manual Entry

 | Trade Date | Settle Date | Action | Transaction Amount
 | 2013-07-24 00:00:00 |  | Contribution | 5
 | 2013-07-31 00:00:00 |  | Interest | 0.04
 | 2013-08-21 00:00:00 |  | Purchase | 11
 | 2013-08-31 00:00:00 |  | Interest | 0.19
 | 2013-09-27 00:00:00 |  | Dividend | 47.16
 | 2013-09-30 00:00:00 |  | Interest | 0.13
 | 2013-10-10 00:00:00 |  | Purchase | 6
 | 2013-10-21 00:00:00 |  | Split | 0
 | 2013-10-21 00:00:00 |  | Split | 0
 | 2013-10-31 00:00:00 |  | Contribution | 4
 | 2013-10-31 00:00:00 |  | Purchase | 22
 | 2013-10-31 00:00:00 |  | Interest | 0.09
 | 2013-11-19 00:00:00 |  | Purchase | 33
 | 2013-11-19 00:00:00 |  | Contribution | 55
 | 2013-11-19 00:00:00 |  | Purchase | 77
Spreadsheet: 374590d1422908783-dates-day-and-month-known-now-i-what-to-add-the-year-year
Sheet: Sheet1

 |  |  |  |  |  | 2014
 |  | day | month | this year |  | other year
30/10
25/10
22/10
17/11
25/10
19/10
20/10
18/10
26/10
23/10
4/11
12/11
25/10
2/11
31/10
5/11
5/11
28/10
18/11
18/10
6/11
7/11
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: Trapped

TRAPPED CASH, PARTNER LOANS, CAPITAL BUDGET ($000)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Contract Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Reserve_Table"
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Months Of Operation
[NAME]
Beginning Balance |  |  |  |  | 0
Plus: Current Year Earnings
Subtotal Available For Dividends
Less: Current Year Dividends
Ending Balance
Cash (Excluding Working Capital)
Beginning Balance |  |  |  |  | 0
Plus: Prior Year Partner Loans Repayment
Plus: Current Year Cashflow
Subtotal Cashflow Available For Distribution
Less: Current Year Dividends
Less: Current Year Capital Reductions
Less: Current Year Partner Loans
Ending Balance
Beginning Trapped Cash |  |  |  |  | 0
Current Year Trapped Cash
Relief Of Prior Years Trapped Cash
Ending Trapped Cash
Partner / Shareholder Loans
Beginning Balance |  |  |  |  | 0
Plus: Prior Year Trapped Cash - Loaned To Partners
Less: Loan Repayment
Ending Balance
Interest Income - Partner / Shareholder Loans
Interest Expense - Partner / Shareholder Loans
Capital Budget Expenses
Unescalated Capital Budget Expenses |  |  | 1998 |  | 0 | 5 | 13 | 52.5 | 195 | 13 | 13 | 85.5 | 13 | 195 | 13 | 52.5 | 13 | 13 | 195 | 85.5 | 13 | 13 | 13 | 0 | 0
Sudam Tax Credit Reserve
Beginning Reserve Balance |  |  |  |  | 0
Plus: Current Year Sudam Credits
Less: Distribution Of Reserve
Ending Reserve Balance
Current Year Earnings Before Sudam Credits
Cumulative Earnings Before Sudam Credits
Cumulative Sudam Credits Available
Sudam Credits Applied Against Losses
Reserve For Equipment Rental (Reserve During Term Of Debt Only)
Base Equipment Rental Costs - Unescalated
Additional Equipment Rental Costs - Unescalated
Total Equipment Rental Costs - Unescalated
Escalation Factor
Total Equipment Rental Costs - Escalated
Expense Accrual Account
Accrual To Cash Adjustment
Equipment Reserve Account
Beginning Balance |  |  |  |  | 0
Plus: Expense Accrual
Less: Cash Expense
Ending Balance
Spreadsheet: 799475d1665098436-trying-to-find-the-correct-formula-book1
Sheet: Sheet1

Renewal Date | Sum of 2021 Premium | Sum of 2022 Premium | Sum of Field1
2022-09-08 00:00:00 |  | 44000 | #[NAME]!
2022-09-15 00:00:00 | 14500 | 14500 | 0
2022-09-28 00:00:00 | 2870 | 2870 | 0
2022-09-29 00:00:00 | 325000 | 170588 | -0.4751138461538461
2022-09-30 00:00:00 | 70500 | 87500 | 0.2411347517730495
2022-10-01 00:00:00 | 950000 | 650000 | -0.3157894736842105
2022-10-03 00:00:00 | 30000 | 33500 | 0.1166666666666667
2022-11-23 00:00:00 | 1058000 |  | -1
2022-12-05 00:00:00 | 30000 |  | -1
Grand Total | 2480870 | 1002958 | -0.5957232744964468
Spreadsheet: jeffrey_a_shankman__13995__Exhibit 14 (Scenario 1)
Sheet: Rate Increase Model

 | CPUC Rate Proceeding |  |  |  |  |  |  |  | Exhibit 14 (Scenario 1)
 | SDG&E A. 01-01-044 |  |  |  |  |  |  |  | Revised with DWR Revenue Requirement
 |  |  |  |  |  |  |  |  | Update August 7, 2001
 | Assumptions
 | Update Determinants (October 1, 2001 to December 31, 2002)
 | Sales (GWh) |  | URG | DWR |  | Total
 | Capped AB 265 Customers | 0.7
 | Capped ABX1 43 Customers | 0.3 | 0
 | Total Bundled Sales
 |  |  | 0.4159236237147563 | 0.5840763762852436
 | AB X1 43 Customers [NAME] |  |  | AB 265 Customers Rev Req
 | DWR Revenue Requirement |  |  | DWR Revenue Requirement
 | Other ISO charges | 0 |  | ISO charges |  |  |  | 0
 | AB X1 43 Sales Times 6.5 cents/kWh |  |  | SDG&E Revenue Requirement (URG)
 | DWR Increase Rev Req |  |  | AB 265 Sales Times 6.5 cents/kWh
 |  |  |  | DWR Increase Rev Req
 | DWR Rate Increase |  | Cents/kWh | DWR Rate Increase |  |  |  |  | Cents/kWh
 | CTC Rate Removal |  | Cents/kWh |  |  |  |  | 0 | Cents/kWh
 | Total Rate Increase |  | Cents/kWh |  |  |  |  |  | Cents/kWh
 | System Average Rate Increase |  | Cents/kWh
 | Notes:
 | * The AB265 Revenue Requirement URG does not include the Other ISO Charges of $73,149,000 and the Grid Management Charges of $30,621,000 paid by SDG&E for URG
 | per the agreement with DWR.
 | * The retroactive Rate increase credit of $111,493,402 from March 27, 2001 to the effective date is included in the "AB X1 43 Sales times 6.5 cents/kWh"
Spreadsheet: 2090bbe0-cc89-4099-a075-316ba1d355a1
Sheet: Sheet1

Table S5 Nucleotide divergence of CHS and WER genes, from two parental species, [NAME] and A. lyrata. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | Divergence from A. halleri |  |  |  | Divergence from A. lyrata |  |  |  | Divergence from Far East A. lyrata
 |  | Ka | Ks | K |  | Ka | Ks | K |  | Ka | Ks | K
CHS-lyr | Cluster 1 | 0 (0-0) | 0.0704 (0.0388-0.102) | 0.0144 (0.00785-0.0209) |  | 0.00256 (0-0.00617) | 0.0522 (0.0302-0.0742) | 0.0123 (0.00764-0.0170) |  | 0 (0-0) | 0.000194 (0-0.000557) | 0.00115 (0-0.00263)
 | Cluster 2 | 0 (0-0) | 0.0704 (0.03874-0.102) | 0.0144 (0.00787-0.0209) |  | 0.00256 (0-0.00617) | 0.0521 (0.0301-0.0741) | 0.0124 (0.00772-0.0171) |  | 0 (0-0) | 0.000134 (0.000109-0.000159) | 0.0013 (0-0.00296)
 | Total | 0 (0-0) | 0.0704 (0.0374-0.103) | 0.0144 (0.00797-0.0209) |  | 0.00256 (0-0.00621) | 0.0522 (0.0293-0.0751) | 0.0123 (0.00768-0.0170) |  | 0 (0-0) | 0.00017 (0-0.000386) | 0.00119 (0-0.00270)
CHS-hal | Cluster 1 | 0.000776 (0-0.00158) | 0.00258 (0-0.00644) | 0.00178 (0.000328-0.00323) |  | 0.00334 (0-0.00702) | 0.0815 (0.0513-0.112) | 0.0195 (0.0133-0.0257) |  | 0.000775 (0-0.00159) | 0.0709 (0.0390-0.103) | 0.0164 (0.00958-0.0232)
 | Cluster 2 | 0 (0-0) | 0.00204 (0-0.00494) | 0.000533 (0-0.00115) |  | 0.00256 (0-0.00617) | 0.0797 (0.0497-0.110) | 0.0178 (0.0118-0.0238) |  | 0 (0-0) | 0.0691 (0.0373-0.101) | 0.0148 (0.00821-0.0214)
 | Total | 0.00034 (0-0.000693) | 0.00228 (0-0.00565) | 0.00109 (0.000169-0.00201) |  | 0.0029 (0-0.00658) | 0.0805 (0.0498-0.111) | 0.0186 (0.0126-0.0245) |  | 0.00034 (0-0.000712) | 0.0699 (0.0382-0.102) | 0.0155 (0.00875-0.0223)
WER-lyr | Cluster 1 | 0.00158 (0-0.00464) | 0 (0-0) | 0.0392 (0.0255-0.0529) |  | 0.00158 (0-0.00464) | 0 (0-0) | 0.0245 (0.0164-0.0326) |  | 0.00158 (0-0.00466) | 0 (0-0) | 0.00238 (0-0.00546)
 | Cluster 2 | 0.000195 (0-0.000577) | 0 (0-0) | 0.0399 (0.0269-0.0529) |  | 0.000195 (0-0.000577) | 0 (0-0) | 0.0243 (0.0167-0.0319) |  | 0.000195 (0-0.000573) | 0 (0-0) | 0.00239 (0-0.00562)
 | Total | 0.0008 (0-0.00217) | 0 (0-0) | 0.0396 (0.0259-0.0533) |  | 0.0008 (0-0.00217) | 0 (0-0) | 0.0243 (0.0165-0.0321) |  | 0.0008 (0-0.00215) | 0 (0-0) | 0.00233 (0-0.00523)
WER-hal | Cluster 1 | 0 (0-0) | 0 (0-0) | 0.00263 (0.000991-0.00427) |  | 0 (0-0) | 0 (0-0) | 0.0365 (0.0261-0.0469) |  | 0 (0-0) | 0 (0-0) | 0.0397 (0.0271-0.0523)
 | Cluster 2 | 0 (0-0) | 0 (0-0) | 0.00211 (0.000720-0.00350) |  | 0 (0-0) | 0 (0-0) | 0.0356 (0.0251-0.0461) |  | 0 (0-0) | 0 (0-0) | 0.0388 (0.0262-0.0514)
 | Total | 0 (0-0) | 0 (0-0) | 0.00235 (0.000998-0.00370) |  | 0 (0-0) | 0 (0-0) | 0.0360 (0.0253-0.0467) |  | 0 (0-0) | 0 (0-0) | 0.0392 (0.0264-0.0521)
All estimates were Jukes & Cantor corrected. NA: Corresponding sequences are not reported.
"Divergence from Far East A. lyrata" indicates nucleotide divergence from two A. lyrata accessions from Far East Russia (Shimizu-Inatsugi et al., 2009).
The assignment of clusters is based on InStruct (See Table S9).