tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 673039d1587134302-conditional-formatting-and-if-formulas-error-on-formula-please-help
Sheet: Sheet5

 | February | March | Balance
 | planned cost | Actual Cost | [NAME]
 | 130 | 95 |  | underspent by £100
 | 20 | 0 |  | Not Spent
 | 100 | 200 |  | Overspent by £100
 | 50 | 300 |  | Overspent by £250
 | 20 | 1000 |  | Overspent by £980
 | 100 | 100 |  | Spent on Budget
 |  |  | the formula on this column (F) should show ovespent as a positive value and an under spent as a negative value |  | the formula on this column (H) should show ovespent as a positive value and an under spent as a negative value
 | February | March | Balance | April | Balance
 | planned cost | Actual Cost | [NAME] | Actual Cost | [NAME]
 | 130 | 30 |  | 200 |  | Overspent by £100 - shows the right retun value art this instance but if the numbers are as Row 23 the formula is not working as it should be due to positive and negative values please help
 | 20 | 0 |  | 20 |  | Spent on Budget- shows the right retun value art this instance but if the numbers are as Row 23 the formula is not working as it should be due to positive and negative values please help
 | 100 | 200 |  | 200 |  | this should show overspent by £300 | ERROR on FORMULA please help
 | 50 | 300 |  | 100 |  | this should show overspent by £350 | ERROR on FORMULA please help
 | 20 | 1000 |  | 20 |  | this should show overspent by £1000 | ERROR on FORMULA please help
 | 100 | 100 |  | 100 |  | Overspent by £100 - shows the right retun value art this instance but if the numbers are as Row 23 the formula is not working as it should be due to positive and negative values please help
 |  |  | This formula  on ROW 29F also should take into account the positives and negatives and give the remainder |  | This formula  on ROW 29H also should take into account the positives and negatives and give the remainder
 |  |  | ERROR on FORMULA please help |  | ERROR on FORMULA please help
Spreadsheet: 96011d1295492013-excel-2007-mutiple-horizontal-axises-with-a-single-vertical-axis-in-a-graph-example
Sheet: Sheet1

 | series 1 | series 2 | series 3 | series 4 | series 5 | series 6 | series 7 | series 8 | series 9 | lines
0 | 11 | 12 | 13
10
20
30
40
50
60
0 |  |  |  | 11 | 12 | 13 |  |  |  | 25
10
20
30
40
50
60
0 |  |  |  |  |  |  | 11 | 12 | 13 | 25
10
20
30
40
50
60
Spreadsheet: 713587d1610817361-translating-multiple-column-index-to-other-work-sheets-film-tester
Sheet: Genre

[NAME] | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
Gangster
Comedy
Rom-Com
Western
Romance
Sci-Fi
Historical
Action
Horror
Drama
Animated
Superhero
Thriller
Musical
Fantasy
Heist
[NAME]
Spreadsheet: 96192d1295611186-how-to-use-two-dependent-combo-boxes-to-display-prices-printing-prices
Sheet: Sheet1

Printing Prices - Computers Black & White
 | Paper Size | White Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper | 0.05 | 10 | 0.5
Printing Prices - Computers Colour
 | Paper size | White Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper | 0.21 | 5 | 1.05
Photocopying Prices Black & White Ink
 | Paper Size | White Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper | 0.04 | 0 | 0
 |  |  | Your Paper | 0.02 | 0 | 0
 | A4 | Double Sided | Agency Paper | 0.08 |  | 0
 |  |  | Your Paper | 0.06 |  | 0
Photocopying Prices Colour Ink
 | Paper Size | White Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper | 0.2 | 0 | 0
 |  |  | Your Paper | 0.18 | 0 | 0
 | A4 | Double Sided | Agency Paper | 0.38 |  | 0
 |  |  | Your Paper | 0.36 |  | 0
Photocopying Prices Coloured Paper (black & white print)
 | Paper Size | Coloured Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper | 0.05 | 0 | 0
 |  |  | Your Paper | 0.02 | 0 | 0
 | A4 | Double Sided | Agency Paper | 0.07 |  | 0
 |  |  | Your Paper | 0.04 |  | 0
Digi Printer Prices White Paper
 | Paper Size | White Paper |  | Unit Cost | Quantity | Total
 | A4 | Single Sided | Agency Paper |  | 0 | 0
 |  |  | Your Paper |  | 0 | 0
 | A4 | Double Sided | Agency Paper |  | 0 | 0
 |  |  | Your Paper |  | 0 | 0 |  | None | 0
 |  |  |  |  |  |  |  | Agency Paper | 1.75
 |  |  |  |  |  |  |  | Own Paper | 0.75
Digi Printer Prices - |  |  |  |  |  |  |  | Link Cell > | 3
 | Agency Paper | Own Paper |  |  |  | Total
White Paper 50 - 100 copies S/S  minimum charge | 1.75 | 0.75 | price includes  1 master |  |  | 0.75 |  | None | 0
White Paper 50 - 100 copies D/S  minimum charge | 2.5 | 1.5 | price includes  1 master |  |  | 0 |  | Agency Paper | 2.5
 |  |  |  |  |  |  |  | Own Paper | 1.5
 | Agency Paper | Own Paper | Plus per master |  | Quantity | Total |  | Link Cell > | 1
White Paper 100+ copies S/S per sheet | 0.015 | 0.05 | 0.25 |  | 0
White Paper 100+ copies D/S per sheet | 0.02 | 0.01 | 0.25 |  | 0
 | Agency Paper | Own Paper |  |  | Quantity | Total |  | None | 0
Coloured Paper 50 - 100 copies S/S minimum charge | 2.25 | 0.75 | price includes  1 master |  |  | 2.25 |  | Agency Paper | 2.25
Coloured Paper 50 - 100 copies D/S minimum charge | 3 | 1.5 | price includes 1 master |  |  | 0 |  | Own Paper | 0.75
 |  |  |  |  |  |  |  | Link Cell > | 2
 | Agency Paper | Own Paper | Plus per master |  | Quantity | Total
Coloured Paper 100+ copies S/S per sheet | 0.02 | 0.005 | 0.25 |  | 0 |  |  | None | 0
Coloured Paper 100+ copies D/S per sheet | 0.025 | 0.01 | 0.25 |  | 0 |  |  | Agency Paper | 3
 |  |  |  |  |  |  |  | Own Paper | 1.5
 |  |  | Old total with old VAT @ 17.5% |  |  | 4.55 |  | Link Cell > | 1
 |  |  | VAT increase up to 20% |  |  | 0.0819
 |  |  | Grand Total with VAT @ 20% |  |  | 4.6319
Spreadsheet: 695574d1600282828-vlookup-function-frustration-vlookup-issue
Sheet: lookup

UPC | ARTICLE
761025
246970
792130
210397
316490
145248
655425
625415
685477
654122
125222
254254
458795
543256
166435
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Jackson

School | Scholarship | Experation Date
[NAME] | Foodland Scholarship Program | March 12th
 | Morehead State University Full Tution Scholarship | December 1st
 | [NAME] | February 3rd
 | Ohio University Southern Scholarship | March 1st
 | Best Buy Scholarship | February 15th
 | Jackson County Sportsman Scholarship | April 2nd
 | Junior Altrurian Women's League Scholarship | April 15th
 | Flourence [NAME] Scholarship | March 1st
 | [NAME] Teaching Scholarship | April 15th
 | Dr. [NAME] Scholarship | March 31st
 | Foundation of Applachian Ohio Scholarship | March 31st
 | Junior Achievement Scholarship | April 15th
 | OHSAA Scholarship | 2012-03-23 00:00:00
 | [NAME] | April 13th
Spreadsheet: 139522d1328283486-lookup-vertically-maybe-example
Sheet: Sheet1

Username | Location | White | Yellow | Green
username.1 | 1001 |  | x |  | 1 | username.1 | 1001 | Yellow
username.2 | 1002 | x |  | x | 3 | username.2 | 1002 | White
Username.3 | 1001 | x | x | x | 6 | username.2 | 1002 | Green
Username.4 | 1001 |  | x |  | 7 | Username.3 | 1001 | White
 |  |  |  |  |  | Username.3 | 1001 | Yellow
 |  |  |  |  |  | Username.3 | 1001 | Green
 |  |  |  |  |  | Username.4 | 1001 | Yellow
Spreadsheet: 95020d1294743226-estimate-next-months-based-on-historic-and-future-target-case
Sheet: Sheet3

 |  | Delivered | Target
2010 | March | 1883473 | 1725000
2010 | April | 1511157 | 2530000
2010 | May | 1275655 | 2285000
2010 | June | 1353752 | 2685000
2010 | July | 1084476 | 2711000
2010 | August | 1343266 | 1995000
2010 | September | 1317873 | 1785000
2010 | October | 1259645 | 1110000
2010 | November | 1511077 | 1140000
2010 | December | 1274704 | 1160000
2011 | January | ? | 1225000
2011 | February | ? | 995000
2011 | March | ? | 995000
2011 | April | ? | 995000
2011
2011
Spreadsheet: 675469d1588313638-number-of-times-a-topic-appears-in-an-table-example1689
Sheet: Sheet1

Summary 1 | Summary 2 | Summary 3 | Summary 4 | Summary 5 |  |  | Order |  |  | Value | Count
 |  |  |  |  |  |  |  |  |  | Dermatology | 3
 |  |  |  |  |  |  |  |  |  | ECG | 2
Ophthalmology | Soft tissue injuries | Diabetes - medication |  |  |  |  |  |  |  | Ophthalmology | 2
Dermatoscopy | ECG | Skin procedures | Antibiotic prescribing | Opioids |  |  |  |  |  | Orthopaedics | 2
Pain management | High-risk conditions | Dermatology | MS and Parkinson's | Adrenal conditions |  |  |  |  |  | Emergency care | 1
Ophthalmology | Musculoskeletal |  |  |  |  |  |  |  |  | Endocrinology | 1
Infant care | Breastfeeding | Sleep disorders | Primary health system | Aggression management |  |  |  |  |  | Asthma | 1
Diabetes | Mental Health | Skin conditions | Asthma | HTN |  |  |  |  |  | Diabetes | 1
Dermatology | Emergency care | Endocrinology |  |  |  |  |  |  |  | Skin conditions | 1
GP Care Planning |  |  |  |  |  |  |  |  |  | Mental Health | 1
Heart failure | ECG | Orthopaedics | Eye injuries | NDIS |  |  |  |  |  | HTN | 1
Paediatrics | Women's health | Dermatology | Orthopaedics | AOD |  |  |  |  |  | Paediatrics | 1
 |  |  |  |  |  |  |  |  |  | Women's health | 1
 |  |  |  |  |  |  |  |  |  | AOD | 1
 |  |  |  |  |  |  |  |  |  | NDIS | 1
 |  |  |  |  |  |  |  |  |  | GP Care Planning | 1
 |  |  |  |  |  |  |  |  |  | Heart failure | 1
 |  |  |  |  |  |  |  |  |  | Eye injuries | 1
 |  |  |  |  |  |  |  |  |  | Aggression management | 1
 |  |  |  |  |  |  |  |  |  | Antibiotic prescribing | 1
 |  |  |  |  |  |  |  |  |  | Opioids | 1
 |  |  |  |  |  |  |  |  |  | Pain management | 1
 |  |  |  |  |  |  |  |  |  | Skin procedures | 1
 |  |  |  |  |  |  |  |  |  | Soft tissue injuries | 1
 |  |  |  |  |  |  |  |  |  | Diabetes - medication | 1
 |  |  |  |  |  |  |  |  |  | Dermatoscopy | 1
 |  |  |  |  |  |  |  |  |  | High-risk conditions | 1
 |  |  |  |  |  |  |  |  |  | Breastfeeding | 1
 |  |  |  |  |  |  |  |  |  | Sleep disorders | 1
 |  |  |  |  |  |  |  |  |  | Primary health system | 1
 |  |  |  |  |  |  |  |  |  | Infant care | 1
 |  |  |  |  |  |  |  |  |  | MS and Parkinson's | 1
 |  |  |  |  |  |  |  |  |  | Adrenal conditions | 1
 |  |  |  |  |  |  |  |  |  | Musculoskeletal | 1
Spreadsheet: chris_germany__2294__NewPower2001
Sheet: TRCO_Z6_TETC_M3

 | All volumes are monthly
 |  | Tetco M3 |  |  |  | Tetco M3 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 | Month | Deal | Volume | Price |  | Deal | Volume | Price |  | Deal | Volume | Price |  | Deal | Volume | Price |  | Deal | Volume | Price
 | 2001-01-01 00:00:00 | 377251 | 3650 | NX1 + .59 |  | 377250 | 3015 | NX1 +.68 |  | 377264 | 14568 | NX1 +.835 |  | 377268 | 145 | NX1 + .59 |  | N/A | 0 | 0
 | 2001-02-01 00:00:00 | 377251 | 2900 | NX1 + .59 |  |  | 2395 | NX1 +.68 |  |  | 14423 | NX1 +.835 |  |  | 144 | NX1 + .59 |  |  | 0 | 0
 | 2001-03-01 00:00:00 | 377251 | 2563 | NX1 + .59 |  |  | 2117 | NX1 +.68 |  |  |  |  |  |  | 142 | NX1 + .59 |  |  | 4407 | NX1 +.835
 | 2001-04-01 00:00:00 | 377251 | 1318 | NX1 + .59 |  |  | 1089 | NX1 +.28 |  |  |  |  |  |  | 141 | NX1 + .59 |  |  | 689 | NX1 +.455
 | 2001-05-01 00:00:00 | 377251 | 686 | NX1 + .59 |  |  |  |  |  |  |  |  |  |  | 139 | NX1 + .59
 | 2001-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 138 | NX1 + .59
 | 2001-07-01 00:00:00
 | 2001-08-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | 2002-01-01 00:00:00
 | 2002-02-01 00:00:00
 | 2002-03-01 00:00:00
Spreadsheet: 725269d1616601993-else-function-on-each-scenario-sample-2
Sheet: Main

Section | Name | Physics | Chem | Bio | Maths
A | [NAME]
B | Maria
C | [NAME]
Spreadsheet: 800280d1665577795-countifs-to-work-out-how-often-a-player-competed-ranges-can-include-blanks-test
Sheet: Superstar

Quarter | Goals
1 | 1
2 | 1
3 | 1
4 | 2
 |  |  |  | Quarter | Participations
1 | 0 |  |  | 1
2 | 1 |  |  | 2
3 | 0 |  |  | 3
4 | 2 |  |  | 4
1 | 1
2 | 2
3
4
Spreadsheet: 141883d1329496311-single-criteria-return-multiple-rows-example
Sheet: Sheet4

NAME | DESC | SUBJ | CRSE | CRN | INST TYPE | SEM HRS | CONT HRS | ENRL | WORKLOAD VALUE | % OR WORKLOAD |  |  |  |  | NAME | COLL | DEPT | SUBJ | CRSE | SECT | INST TYPE | SEM HRS | ENRL
Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | BU | AFM | MISY | 2013 | 22279 | 1 | 3 | 24
Rank | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | AS | BIO | BIOL | 3124 | 20453 | 1 | 4 | 19
Tenure | Non-Tenured |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | AS | BIO | BIOL | 5013 | 20883 | 1 | 3 | 7
Full/Part-Time | Full-Time |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | BU | AFM | MISY | 2013 | 22529 | 1 | 3 | 23
Contract Length | 9 Months |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | AS | BIO | BIOL | 3124 | 20748 | 2 | 0 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | AS | BIO | BIOL | 4061 | 20882 | 5 | 1 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doe, [NAME] | BU | AFM | MISY | 5533 | 22533 | 1 | 3 | 16
NAME | DESC | SUBJ | CRSE | CRN | INST TYPE | SEM HRS | CONT HRS | ENRL | WORKLOAD VALUE | % OR WORKLOAD
Doe, [NAME]
Rank | [NAME]
Tenure | Non-Tenured
Full/Part-Time | Full-Time
Contract Length | 9 Months
Spreadsheet: 860725d1708711419-final-cost-final-cost
Sheet: Sheet1

 |  |  | Final cost | Funds | Positioning
 |  | From here | 1000 | 10000 |  | The amount in column "D" can be be in any row, in this example is in row 3.
 |  |  |  | 10000
 |  | or here |  | 10000
 |  |  |  | 10000
 |  | or here |  | 10000
 |  |  |  | 10000
 |  |  |  | 10000
 |  |  |  | 10000
 |  |  |  | 10000
 |  |  |  | -500 | 1000 | It should appear here, where the negative number starts. [NAME] should be the 1st negative number in column 2 (funds).
 |  |  |  | -300
 |  |  |  | -300
 |  |  |  | -100
Spreadsheet: 48687d1247925936-selecting-values-based-on-conditions-value-test
Sheet: Sheet2

Select the month | 2009-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-09 00:00:00
List of Trucks | Qty | Cost |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-09 00:00:00
 |  |  | Values should be updated from the Data Sheet for the selected month |  |  |  |  |  |  |  |  |  |  |  | 2009-05-09 00:00:00
 |  |  | If there are three trucks all three should be listed according to the date of arrivals |  |  |  |  |  |  |  |  |  |  |  | 2009-06-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00
Spreadsheet: 61534d1262428899-excel-2007-hours-calculation-example-hours-2
Sheet: Monday

 | 01/01.10 | Agency Drivers Hours Monday
Names | Agency Supplier | Comments | Start Time | Finish Time | [NAME] | Paid Hours | O/T Hours
PRESSURE VAN DRIVERS ONLY
SMITH | agency 1 |  | 06:00:00 | 14:00:00
JONES | agency 1 |  | 06:00:00 | 18:00:00
[NAME] | agency 1 |  | 07:00:00 | 15:00:00
 |  |  |  |  |  |  |  |  |  | agency 1
 |  |  |  |  |  |  |  |  |  | agency 2
 |  |  |  |  |  |  |  |  |  | agency 3
LGV DRIVERS ONLY |  |  |  |  |  |  |  |  |  | agency 4
 |  |  |  |  |  |  |  |  |  | agency 5
 |  |  |  |  |  |  |  |  |  | agency 6
PEW | agency 2 |  | 12:00:00 | 22:00:00
PHEW | agency 2 |  | 12:00:00 | 23:00:00
BARNEY | agency 2 |  | 10:00:00 | 21:00:00
McGREW | agency 2 |  | 06:00:00 | 18:00:00
Spreadsheet: 731998d1620739959-extract-data-based-on-a-drop-down-list-selection-version-10
Sheet: Sheet6

Select Vessel:
BCK35
Species | Presentation | 6a | 4a | Other | 6a | 4a | OTHER | TOTAL (V:X) | SALENOTE | % 6a | % 4a | % OTHER | 6a | 4a | OTHER
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: benjamin_rogers__905__ny prices 09_17_01
Sheet: Nov DA

 |  |  |  |  |  |  |  |  |  |  | 16 Hr Avg |  |  |  | Price |  |  |  | Price |  |  |  | Price
 |  | Day Ahead Prices |  |  |  |  |  |  |  |  | NYISO |  | Zone A |  | Forecast |  | Zone G |  | Forecast |  | Zone G |  | Forecast
Date |  | Zone A | % | Zone G | % | Zone J | % | PJM | % |  | Load |  | Average |  | Zone A |  | Average |  | Zone G |  | Average |  | Zone J |  | A-G | G-J | A-J
2001-10-27 00:00:00 |  | 32.28 |  | 37.37 |  | 37.62 |  |  |  |  | 18338
 |  | 31.33 |  | 36.69 |  | 36.9 |  |  |  |  | 18700
 |  | 34.34 |  | 37.84 |  | 43.58 |  |  |  |  | 19628
 |  | 37.47 |  | 44.03 |  | 44.68 |  |  |  |  | 19310
 |  | 33.32 |  | 40.36 |  | 40.95 |  |  |  |  | 19485
 |  | 31.75 |  | 40.32 |  | 40.98 |  |  |  |  | 19408
 |  | 31.96 |  | 39.39 |  | 40.83 |  |  |  |  | 19122
 |  | 29.52 |  | 36.14 |  | 36.46 |  |  |  |  | 16843
 |  | 26.75 |  | 32.93 |  | 33.48 |  |  |  |  | 16392
 |  | 32.29 |  | 39.08 |  | 39.18 |  |  |  |  | 19452
 |  | 32.13 |  | 38.27 |  | 38.45 |  |  |  |  | 19509
 |  | 28.54 |  | 35.08 |  | 37.63 |  |  |  |  | 19287
 |  | 27.33 |  | 33.07 |  | 38.23 |  |  |  |  | 19296
 |  | 26.99 |  | 33.53 |  | 38.79 |  |  |  |  | 19081
 |  | 24.5 |  | 29.35 |  | 35.04 |  |  |  |  | 17373
 |  | 23.34 |  | 28.26 |  | 31.26 |  |  |  |  | 16349
 |  | 28.02 |  | 33.77 |  | 41.87 |  |  |  |  | 19690
 |  | 27.72 |  | 34.59 |  | 40.67 |  |  |  |  | 19604
 |  | 27.32 |  | 33.14 |  | 40.44 |  |  |  |  | 19406
 |  | 26.4 |  | 34.09 |  | 40.32 |  |  |  |  | 19329
 |  | 25.57 |  | 32.78 |  | 46.99 |  |  |  |  | 18972
 |  | 24.02 |  | 29.92 |  | 32.82 |  |  |  |  | 16801
 |  | 22.54 |  | 26.35 |  | 29.67 |  |  |  |  | 16319
 |  | 24.52 |  | 28.65 |  | 31.82 |  |  |  |  | 19374
 |  | 25.35 |  | 29.37 |  | 32.06 |  |  |  |  | 19533
 |  | 24.67 |  | 31.13 |  | 32.45 |  |  |  |  | 19389
 |  | 21.28 |  | 25.71 |  | 26.19 |  |  |  |  | 15920
 |  | 21.62 |  | 26.43 |  | 28.05
 |  | 21.73 |  | 26.06 |  | 27.8 |  |  |  |  | 16226
 |  | 21.3 |  | 25.51 |  | 26.07 |  |  |  |  | 16482
 |  | 27.85 |  | 33.31 |  | 35.25
 |  | 26.16 |  | 32.49 |  | 33.65
 |  | 22.4 |  | 27.37 |  | 29.68
 |  | 26 |  | 30.97 |  | 34.54
 |  | 22.72 |  | 30.65 |  | 32.73
1st Week Avg
2nd Week Avg
3rd Week Avg
4th Week Avg
5th Week Avg
[NAME]
Spreadsheet: james_steffes__12828__residental rate components
Sheet: NY

NEW YORK
 | Customer charge ($/month) |  | Distribution (/kWh) |  | Transmission |  | CTC (/kWh) |  | Generation/Energy (if PLR)  (/kWh) |  | SBC (/kWh) | Other (/kWh) |  | Notes
NiMo | 13.79 |  | 6.0324 | a |  |  |  |  |  | b | 0.1673 |  | c
NY Electric & Gas | 7.43 |  |  |  |  |  |  |  | 12.37 |  | 0.17
Consolidated Edison | 8.57 |  | 4.49 | d | 0.747 | e |  |  |  |  | 0.18 |  | f
Rochester Gas & Electric | 17.5 |  |  |  |  |  |  |  | 7.443 |  | 0.089
Orange and Rockland Utilities | 8.45 |  | 5.497 | g |  |  |  |  | 12.41 | h | 0.145 |  | I | Effective 4/1/01 - rate increase for all classifications.  Example, Orange/Rockland counties charges multiplied by factor of 0.9950
LIPA |  | j |  |  |  |  |  |  |  |  |  |  |  | k
Central Hudson Gas & Electric | 7.15 |  | 4.072 |  |  |  | 0.431 |  |  | l
Notes:
All charges are in cents unless otherwise specified
a) Referred to as "delivery". Basic service and delivery charges vary by load zone. Cost listed is for load including Buffalo
b) "Electricity supply charge" - based on market; varies by month and load zone.
c) Other charges/credits: 1) Delivery charge adjustment (varies by month and zone); 2) Customer service credit = $1.00 + 0.7/kWh if ESCo used
d) Charge is for July 2001 for first 250 kWh (over 250= 5.023)
e) Charge is for July 2001 for first 250 kWh (over 250= 0.819)
f) Monthly adjustment - negative most months for NYC, positive for Westchester
g) for first 250 kWh all year (over 250=5.800 in summer and 4.335 in other months)
h) "Market supply"
i) energy cost adjustment = 0.27
j) Rate is .1790/day (charge on table is multiplied by 30 days)
k) Charges are inclusive- first 250 kWh= 12.49 all summer; over 250 kWh = 13.67 summer; 11.79 winter
l) The charge for electric power will be adjusted each month by an amount determined as the factor of adjustment (currently 1.0739) multiplied by the Energy Supply Charge ("designed to recover all costs incurred by the Company in providing electric supply"
Spreadsheet: 28511cc1-915d-4b5c-b8a7-f367990f574d
Sheet: Sheet1

UNITED STATES SENATOR -DEMOCRATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Summary By Counties | Condodemetraky, d | [NAME], r | Weber, r | [NAME]
Belknap County | 746 | 55 | 8 | 22
Carroll County | 733 | 5 | 0 | 6
Cheshire County | 1551 | 19 | 4 | 35
Coos County | 819 | 21 | 2 | 11
Grafton County | 1547 | 34 | 5 | 38
Hillsborough County | 7670 | 120 | 6 | 106
Merrimack County | 2747 | 34 | 2 | 54
Rockingham County | 4062 | 57 | 6 | 47
Strafford County | 2115 | 25 | 0 | 21
Sullivan County | 998 | 22 | 1 | 17
Totals | 22988 | 392 | 34 | 357
Spreadsheet: 253761d1375104281-time-and-date-forumla-issues-maintenance-example-forum
Sheet: Allocation & Codes

 |  |  | Codes | Allocation times |  |  |  |  |  |  |  |  |  | 14:19:06
Paris | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
[NAME] | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
London | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
[NAME] | Business cards | [EMAIL] | a | 14 days
 | Catering | [EMAIL] | b | 4 hours
 | Cleaning | [EMAIL] | c | 90 minutes
 | Computer Errors | [EMAIL] | d | 7 days
 | HSE Objects | [EMAIL] | e | 1 day
 | [NAME] | [EMAIL] | f | 5 hours
Spreadsheet: lindy_donoho__22190__TWCapacitySubscriptionForecast
Sheet: Existing volumes

Transwestern Pipeline Revenue Projections
Existing projections by area
Contracted volumes (average)
 | Capacity/day |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00
Mainline West | 1090000
San Juan (Blanco to Thoreau) | 850000
San Juan (Ignacio to Blanco ) | 476000
San Juan (South Ignacio to Blanco) | 205000
East of Thoreau | 750000
Red Rock (mainline west) | 107000 |  |  | 106700 | 105533 | 100950 | 99700 | 99700
Total
% capacity utilized
Contracted revenues |  |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00
Mainline west subscription
San Juan (Blanco to Thoreau) & east of Thoreau
[NAME] to Blanco
South Ignacio to Blanco
East of Thoreau
Red Rock |  |  |  | 10988351 | 16408788 | 13830215 | 13488028 | 13488028
Total
Average Rates
Mainline west subscription
San Juan (Blanco to Thoreau) & east of Thoreau
[NAME] to Blanco
South Ignacio to Blanco
East of Thoreau
Red Rock
Total Average
Total Known Revenue |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Capacity Available
Utilization % |  |  |  |  | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
Average Rate
Expected  other Revenue
Expected Total Revenue |  |  |  |  | 187580 | 191331 | 195158 | 199061 | 199061 | 199061 | 199061 | 199061
Note the average rate needed in the future years at 90% capacity is only .1742 to keep that revenue level which is only slightly higher than the existing firm contracts only.