{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","bid_factors","auction_results_and_rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":141,"n_cols":12,"rows_kept":141,"cut":false,"hidden":false,"merged":[[112,2,112,3],[113,2,113,3],[4,1,4,11],[77,5,77,6],[114,2,114,3]]}
[]
[]
[]
[]
[]
[]
[null,"Development of BGS-RSCP Cost and Bid Factors for 2020/2021 BGS Filing"]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,"Based on average of year 2016,2017 & 2018 Load Profile Information"]
["Table #1","% Usage During PJM On-Peak Period",null,null,"On-Peak periods defined as the 16 hr PJM Trading period, adj for NERC holidays"]
[null,null,"Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","   --- Other Analysis ---",null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"January",0.46870000000000001,0.46700000000000003,0.47870000000000001,0.46870000000000001,0.46870000000000001,0.45800000000000002,0.3,0.3,0.54600000000000004,0.52429999999999999]
[null,"February",0.49869999999999998,0.49070000000000003,0.50670000000000004,0.49869999999999998,0.49869999999999998,0.47799999999999998,0.29730000000000001,0.29730000000000001,0.56969999999999998,0.55030000000000001]
[null,"March",0.50429999999999997,0.49569999999999997,0.51400000000000001,0.50429999999999997,0.50429999999999997,0.48630000000000001,0.26400000000000001,0.26400000000000001,0.57999999999999996,0.56000000000000005]
[null,"April",0.4763,0.48130000000000001,0.49030000000000001,0.4763,0.4763,0.49270000000000003,0.219,0.219,0.56599999999999995,0.54330000000000001]
[null,"May",0.49769999999999998,0.50870000000000004,0.51729999999999998,0.49769999999999998,0.49769999999999998,0.5857,0.21199999999999999,0.21199999999999999,0.58899999999999997,0.56430000000000002]
[null,"June",0.52300000000000002,0.53,0.54369999999999996,0.52300000000000002,0.52300000000000002,0.62829999999999997,0.20369999999999999,0.20369999999999999,0.60499999999999998,0.57699999999999996]
[null,"July",0.48830000000000001,0.49730000000000002,0.50729999999999997,0.48830000000000001,0.48830000000000001,0.58330000000000004,0.183,0.183,0.56200000000000006,0.52869999999999995]
[null,"August",0.54430000000000001,0.55369999999999997,0.56369999999999998,0.54430000000000001,0.54430000000000001,0.63929999999999998,0.2253,0.2253,0.61799999999999999,0.57999999999999996]
[null,"September",0.48699999999999999,0.49630000000000002,0.50470000000000004,0.48699999999999999,0.48699999999999999,0.59499999999999997,0.22670000000000001,0.22670000000000001,0.57069999999999999,0.54169999999999996]
[null,"October",0.49930000000000002,0.51770000000000005,0.51829999999999998,0.49930000000000002,0.49930000000000002,0.57169999999999999,0.26929999999999998,0.26929999999999998,0.58799999999999997,0.56469999999999998]
[null,"November",0.48199999999999998,0.48270000000000002,0.50170000000000003,0.48199999999999998,0.48199999999999998,0.48899999999999999,0.31,0.31,0.56469999999999998,0.54200000000000004]
[null,"December",0.45469999999999999,0.45229999999999998,0.46829999999999999,0.45469999999999999,0.45469999999999999,0.45429999999999998,0.29870000000000002,0.29870000000000002,0.52629999999999999,0.50329999999999997]
[]
[null,null,null,null,{"$f":"E9","v":"Based on average of year 2016,2017 & 2018 Load Profile Information"}]
["Table #2","% Usage During PSE&G On-Peak Billing Period",null,null,"On-Peak periods as defined in specified rate schedule (average of %s for 2016, 2017 & 2018)"]
[null,null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RLM","LPL-S"]
[]
[null,"January",0.42699999999999999,0.4783]
[null,"February",0.42320000000000002,0.48259999999999997]
[null,"March",0.41849999999999998,0.48110000000000003]
[null,"April",0.41930000000000001,0.4894]
[null,"May",0.44369999999999998,0.50139999999999996]
[null,"June",0.46,0.50729999999999997]
[null,"July",0.48649999999999999,0.50639999999999996]
[null,"August",0.48620000000000002,0.49940000000000001]
[null,"September",0.48749999999999999,0.50780000000000003]
[null,"October",0.46179999999999999,0.50619999999999998]
[null,"November",0.43609999999999999,0.49680000000000002]
[null,"December",0.42849999999999999,0.48530000000000001]
[]
[]
["Table #3","Class Usage @ customer"]
[null,"Calendar month sales forecasted for 2020, less % for LPL-Sec > 500 kW Peak Load Share"]
[null,"in MWh","RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"January",1081757.8894000214,16281.351533194471,14609.307048244767,77,2,1987.0872781741152,15657,32646,551271.57970443647,635885.57966835273]
[null,"February",926769.90195212536,13814.016772148098,12566.685002924984,71,2,1702.3600548880529,13467,27223,520226.47053984442,594602.76958742482]
[null,"March",857391.91407228913,10809.640130502163,11989.461898153811,78,1,1334.444456123834,12961,27598,530696.71172781789,611529.70000201708]
[null,"April",713094.85623466456,6831.5167338189503,10156.573366415969,66,2,901.35033636642004,10692,23860,464119.48244831781,531821.06086118915]
[null,"May",813401.01389094617,4749.2849583270645,13047.248314480128,78,1,404.79291985247409,10116,22188,490162.09729777509,608365.25910870521]
[null,"June",1196743.3173224113,5677.1633676903602,19706.743313127627,56,1,603.75893130538509,8906,19116,539921.06420817017,634636.44075000437]
[null,"July",1558280.6277681533,6018.3091886406137,25395.992840248226,43,1,622.62639790867831,9387,16613,611191.16840157192,672625.70341116353]
[null,"August",1459451.2163344752,6014.4868265011155,23262.182310762375,49,1,673.22551289023761,10539,19843,618380.76146584225,709730.51981633715]
[null,"September",1001261.1470830349,4733.0399192341947,16059.203946485151,42,1,458.82248330735939,12185,20878,534710.23556188645,587895.21968969819]
[null,"October",762395.1000460668,5903.6383244556546,10440.169552172421,84,1,629.48729485533045,13604,28116,502657.21643157839,609806.06132406171]
[null,"November",787720.26573014352,7731.6830176708809,9914.9238833759046,59,1,731.54313693678046,14748,28564,458717.61204382661,565103.25928714441]
[null,"December",997804.7728237774,11830.210821748302,12995.270878505473,63,2,1361.0304317921109,15642,32311,518063.25201048487,597603.49808120879]
[]
[]
[null,"LPL-S > 500 kW PLS","% of","% of"]
[null,null,"kWh","Gen Obl"]
[null,null,0.35663068980336626,0.34538456609153972]
[]
[]
[]
["Table #4","Forwards Prices - Energy Only @ bulk system",null,null,"Table #5","Zone to Western Hub Basis Differential"]
[null,"in $/MWh, not including PJM losses",null,null,null,"Off/On Pk"]
[null,null,"On-Peak",null,null,"LMP ratio"]
[null,"January",42.05,null,"Summer",0.66839999999999999]
[null,"February",39.75,null,"Winter",0.78759999999999997]
[null,"March",32.1]
[null,"April",29.05]
[null,"May",29.05]
[null,"June",28.25,null,null,"Basis"]
[null,"July",32.9,null,null,"On-Peak","Off-Peak"]
[null,"August",30.75,null,"Summer",0.94,0.9]
[null,"September",30.45,null,"Winter",0.97,0.98]
[null,"October",28.35]
[null,"November",28.8]
[null,"December",31.55]
[]
[]
[]
["Table #6","Loss Type","Percentage","Source"]
[null,"Delivery Losses",5.8326999999999997E-2,"Tariff (Result of 2018 Rate Case Loss Study)"]
[null,"EHV Losses",4.5599999999999998E-3,"PJM - No update for 2020"]
[null,"Marginal Loss Deration Factor",1.0525E-2,"NERA"]
[]
[]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments"]
[null,"Obligations - Peak Load shares eff 1/1/19, scaling factors eff 6/1/18, Transmission Loads eff 1/1/19; costs are market estimates"]
[null,"in MW"]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,"Generation Peak Load Share",3942.6720872925002,18.278651099544039,63.414647665295938,0,0,3.3750143976915514,0,0,1677.4443227486215,1328.1438265494457]
[null,"Tranmsission Obligation",4409.3488484669124,19.95785360948198,69.352239348610141,0,0,3.2978384299601702,0,0,1572.9757961273096,1261.747990868246]
[]
[null,"Final Zonal RPM Scaling Factor",1.1050543994531257]
[null,{"$f":"\"PJM June 1, \"&(Input!D2-1)&\" (through May 31, \"&(Input!D2)&\") Forecast Pool Requirement\"","v":"PJM June 1, -1 (through May 31, ) Forecast Pool Requirement"},1.0894999999999999]
[]
[null,"NITS Rate",null,"Tranches","NITS Rate"]
[null,null,2018,29,101197]
[null,null,2019,28,104709.15]
[null,null,2020,28,138497.08431889772]
[]
[null,null,null,null,"Base\nCapacity"]
[null,"Generation Capacity cost","summer =",null,174.13,"$/MW/day"]
[null,null,"winter =",null,174.13,"$/MW/day"]
[null,null,"Capacity Proxy Price True Up",null,0,"$/MW/day"]
[]
[]
[null,null,"RS","RHS"]
[null,"Required summer inversion =",0.86519999999999975,1.1569000000000003,"¢/kWh","(same as 2003/2004 BGS blocking inversion)(generally not updated)"]
[]
[]
["Table #11","Ancillary Services & Renewable Power Cost"]
[null,"Ancillary Services ",null,2,"per MWh @  bulk system"]
[null,"Renewable Power Cost",null,16.72,"per MWh @  bulk system"]
[]
[]
[]
[]
["Bill Impacts","BGS - CIEP BRA Clearing Price ($ per MW/Day)"]
[null,"Annual Obligation Clearing Price",null,281.77999999999997,"per MWh"]
[]
[]
[]
[]
["auction results and rates","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2018 auction","remaining portion of 36 month bid - 2019 auction","36 month bid - 2020 auction"]
[null,"Winning Bid - in $/MWh",91.77,98.04,98.04]
[null,"# of Tranches for Bid",29,28,28]
[null,"Use Estimated amount in cell e136",null,null,"Yes"]
[null,"Payment Factors"]
[null,"                           Summer",1,1,1]
[null,"                           Winter",1,1,1]

{"sheet":"bid_factors","index":1,"n_rows":354,"n_cols":39,"rows_kept":354,"cut":false,"hidden":false,"merged":[[144,17,144,21]]}
[" "]
[null,{"$f":"Input!B7","v":"Development of BGS-RSCP Cost and Bid Factors for 2020/2021 BGS Filing"}]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2016,2017 & 2018 Load Profile Information"}]
["Table #1","% Usage During PJM On-Peak Period",null,null,"On-Peak periods defined as the 16 hr PJM Trading period, adj for NERC holidays",null,null,null,null,null,null,null,null,null,"% usage during Off-Peak period"]
[null,null,"Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","   --- Other Analysis ---",null,"Profile Meter Data","Profile Meter Data",null,null,"Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data","Profile Meter Data"," -- Other Analysis --",null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"January",{"$f":"Input!C14","v":0.46870000000000001},{"$f":"Input!D14","v":0.46700000000000003},{"$f":"Input!E14","v":0.47870000000000001},{"$f":"Input!F14","v":0.46870000000000001},{"$f":"Input!G14","v":0.46870000000000001},{"$f":"Input!H14","v":0.45800000000000002},{"$f":"Input!I14","v":0.3},{"$f":"Input!J14","v":0.3},{"$f":"Input!K14","v":0.54600000000000004},{"$f":"Input!L14","v":0.52429999999999999},null,null,{"$f":"1-C9","v":0.53129999999999999},0.53299999999999992,0.52129999999999999,0.53129999999999999,0.53129999999999999,0.54200000000000004,0.7,0.7,0.45399999999999996,0.47570000000000001]
[null,"February",{"$f":"Input!C15","v":0.49869999999999998},{"$f":"Input!D15","v":0.49070000000000003},{"$f":"Input!E15","v":0.50670000000000004},{"$f":"Input!F15","v":0.49869999999999998},{"$f":"Input!G15","v":0.49869999999999998},{"$f":"Input!H15","v":0.47799999999999998},{"$f":"Input!I15","v":0.29730000000000001},{"$f":"Input!J15","v":0.29730000000000001},{"$f":"Input!K15","v":0.56969999999999998},{"$f":"Input!L15","v":0.55030000000000001},null,null,{"$f":"1-C10","v":0.50130000000000008},{"$f":"1-D10","v":0.50929999999999997},{"$f":"1-E10","v":0.49329999999999996},{"$f":"1-F10","v":0.50130000000000008},{"$f":"1-G10","v":0.50130000000000008},{"$f":"1-H10","v":0.52200000000000002},{"$f":"1-I10","v":0.70269999999999999},{"$f":"1-J10","v":0.70269999999999999},{"$f":"1-K10","v":0.43030000000000002},{"$f":"1-L10","v":0.44969999999999999}]
[null,"March",{"$f":"Input!C16","v":0.50429999999999997},{"$f":"Input!D16","v":0.49569999999999997},{"$f":"Input!E16","v":0.51400000000000001},{"$f":"Input!F16","v":0.50429999999999997},{"$f":"Input!G16","v":0.50429999999999997},{"$f":"Input!H16","v":0.48630000000000001},{"$f":"Input!I16","v":0.26400000000000001},{"$f":"Input!J16","v":0.26400000000000001},{"$f":"Input!K16","v":0.57999999999999996},{"$f":"Input!L16","v":0.56000000000000005},null,null,0.49570000000000003,0.50429999999999997,0.48599999999999999,0.49570000000000003,0.49570000000000003,0.51370000000000005,0.73599999999999999,0.73599999999999999,0.42000000000000004,0.43999999999999995]
[null,"April",{"$f":"Input!C17","v":0.4763},{"$f":"Input!D17","v":0.48130000000000001},{"$f":"Input!E17","v":0.49030000000000001},{"$f":"Input!F17","v":0.4763},{"$f":"Input!G17","v":0.4763},{"$f":"Input!H17","v":0.49270000000000003},{"$f":"Input!I17","v":0.219},{"$f":"Input!J17","v":0.219},{"$f":"Input!K17","v":0.56599999999999995},{"$f":"Input!L17","v":0.54330000000000001},null,null,0.52370000000000005,0.51869999999999994,0.50970000000000004,0.52370000000000005,0.52370000000000005,0.50729999999999997,0.78100000000000003,0.78100000000000003,0.43400000000000005,0.45669999999999999]
[null,"May",{"$f":"Input!C18","v":0.49769999999999998},{"$f":"Input!D18","v":0.50870000000000004},{"$f":"Input!E18","v":0.51729999999999998},{"$f":"Input!F18","v":0.49769999999999998},{"$f":"Input!G18","v":0.49769999999999998},{"$f":"Input!H18","v":0.5857},{"$f":"Input!I18","v":0.21199999999999999},{"$f":"Input!J18","v":0.21199999999999999},{"$f":"Input!K18","v":0.58899999999999997},{"$f":"Input!L18","v":0.56430000000000002},null,null,0.50229999999999997,0.49129999999999996,0.48270000000000002,0.50229999999999997,0.50229999999999997,0.4143,0.78800000000000003,0.78800000000000003,0.41100000000000003,0.43569999999999998]
[null,"June",{"$f":"Input!C19","v":0.52300000000000002},{"$f":"Input!D19","v":0.53},{"$f":"Input!E19","v":0.54369999999999996},{"$f":"Input!F19","v":0.52300000000000002},{"$f":"Input!G19","v":0.52300000000000002},{"$f":"Input!H19","v":0.62829999999999997},{"$f":"Input!I19","v":0.20369999999999999},{"$f":"Input!J19","v":0.20369999999999999},{"$f":"Input!K19","v":0.60499999999999998},{"$f":"Input!L19","v":0.57699999999999996},null,null,0.47699999999999998,0.47,0.45630000000000004,0.47699999999999998,0.47699999999999998,0.37170000000000003,0.79630000000000001,0.79630000000000001,0.39500000000000002,0.42300000000000004]
[null,"July",{"$f":"Input!C20","v":0.48830000000000001},{"$f":"Input!D20","v":0.49730000000000002},{"$f":"Input!E20","v":0.50729999999999997},{"$f":"Input!F20","v":0.48830000000000001},{"$f":"Input!G20","v":0.48830000000000001},{"$f":"Input!H20","v":0.58330000000000004},{"$f":"Input!I20","v":0.183},{"$f":"Input!J20","v":0.183},{"$f":"Input!K20","v":0.56200000000000006},{"$f":"Input!L20","v":0.52869999999999995},null,null,0.51170000000000004,0.50269999999999992,0.49270000000000003,0.51170000000000004,0.51170000000000004,0.41669999999999996,0.81699999999999995,0.81699999999999995,0.43799999999999994,0.47130000000000005]
[null,"August",{"$f":"Input!C21","v":0.54430000000000001},{"$f":"Input!D21","v":0.55369999999999997},{"$f":"Input!E21","v":0.56369999999999998},{"$f":"Input!F21","v":0.54430000000000001},{"$f":"Input!G21","v":0.54430000000000001},{"$f":"Input!H21","v":0.63929999999999998},{"$f":"Input!I21","v":0.2253},{"$f":"Input!J21","v":0.2253},{"$f":"Input!K21","v":0.61799999999999999},{"$f":"Input!L21","v":0.57999999999999996},null,null,0.45569999999999999,0.44630000000000003,0.43630000000000002,0.45569999999999999,0.45569999999999999,0.36070000000000002,0.77469999999999994,0.77469999999999994,0.38200000000000001,0.42000000000000004]
[null,"September",{"$f":"Input!C22","v":0.48699999999999999},{"$f":"Input!D22","v":0.49630000000000002},{"$f":"Input!E22","v":0.50470000000000004},{"$f":"Input!F22","v":0.48699999999999999},{"$f":"Input!G22","v":0.48699999999999999},{"$f":"Input!H22","v":0.59499999999999997},{"$f":"Input!I22","v":0.22670000000000001},{"$f":"Input!J22","v":0.22670000000000001},{"$f":"Input!K22","v":0.57069999999999999},{"$f":"Input!L22","v":0.54169999999999996},null,null,0.51300000000000001,0.50370000000000004,0.49529999999999996,0.51300000000000001,0.51300000000000001,0.40500000000000003,0.77329999999999999,0.77329999999999999,0.42930000000000001,0.45830000000000004]
[null,"October",{"$f":"Input!C23","v":0.49930000000000002},{"$f":"Input!D23","v":0.51770000000000005},{"$f":"Input!E23","v":0.51829999999999998},{"$f":"Input!F23","v":0.49930000000000002},{"$f":"Input!G23","v":0.49930000000000002},{"$f":"Input!H23","v":0.57169999999999999},{"$f":"Input!I23","v":0.26929999999999998},{"$f":"Input!J23","v":0.26929999999999998},{"$f":"Input!K23","v":0.58799999999999997},{"$f":"Input!L23","v":0.56469999999999998},null,null,0.50069999999999992,0.48229999999999995,0.48170000000000002,0.50069999999999992,0.50069999999999992,0.42830000000000001,0.73070000000000002,0.73070000000000002,0.41200000000000003,0.43530000000000002]
[null,"November",{"$f":"Input!C24","v":0.48199999999999998},{"$f":"Input!D24","v":0.48270000000000002},{"$f":"Input!E24","v":0.50170000000000003},{"$f":"Input!F24","v":0.48199999999999998},{"$f":"Input!G24","v":0.48199999999999998},{"$f":"Input!H24","v":0.48899999999999999},{"$f":"Input!I24","v":0.31},{"$f":"Input!J24","v":0.31},{"$f":"Input!K24","v":0.56469999999999998},{"$f":"Input!L24","v":0.54200000000000004},null,null,0.51800000000000002,0.51729999999999998,0.49829999999999997,0.51800000000000002,0.51800000000000002,0.51100000000000001,0.69,0.69,0.43530000000000002,0.45799999999999996]
[null,"December",{"$f":"Input!C25","v":0.45469999999999999},{"$f":"Input!D25","v":0.45229999999999998},{"$f":"Input!E25","v":0.46829999999999999},{"$f":"Input!F25","v":0.45469999999999999},{"$f":"Input!G25","v":0.45469999999999999},{"$f":"Input!H25","v":0.45429999999999998},{"$f":"Input!I25","v":0.29870000000000002},{"$f":"Input!J25","v":0.29870000000000002},{"$f":"Input!K25","v":0.52629999999999999},{"$f":"Input!L25","v":0.50329999999999997},null,null,0.54530000000000001,0.54770000000000008,0.53170000000000006,0.54530000000000001,0.54530000000000001,0.54570000000000007,0.70130000000000003,0.70130000000000003,0.47370000000000001,0.49670000000000003]
[]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2016,2017 & 2018 Load Profile Information"}]
["Table #2","% Usage During PSE&G On-Peak Billing Period",null,null,{"$f":"Input!E28","v":"On-Peak periods as defined in specified rate schedule (average of %s for 2016, 2017 & 2018)"}]
[null,null,"N/A","N/A","Profile Meter Data","N/A","N/A","N/A","N/A","N/A","N/A","Profile Meter Data",null,null,"N/A","N/A","Actual Billed Sales","N/A","N/A","N/A","N/A","N/A","N/A","Actual Billed Sales"]
[null,"(data rounded to nearest .01%)",{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"January",0,0,{"$f":"Input!C32","v":0.42699999999999999},0,0,0,0,0,0,{"$f":"Input!D32","v":0.4783},null,null,null,null,{"$f":"1-E27","v":0.57299999999999995},null,null,null,null,null,null,{"$f":"1-L27","v":0.52170000000000005}]
[null,"February",0,0,{"$f":"Input!C33","v":0.42320000000000002},0,0,0,0,0,0,{"$f":"Input!D33","v":0.48259999999999997},null,null,null,null,0.57679999999999998,null,null,null,null,null,null,0.51740000000000008]
[null,"March",0,0,{"$f":"Input!C34","v":0.41849999999999998},0,0,0,0,0,0,{"$f":"Input!D34","v":0.48110000000000003},null,null,null,null,0.58150000000000002,null,null,null,null,null,null,0.51889999999999992]
[null,"April",0,0,{"$f":"Input!C35","v":0.41930000000000001},0,0,0,0,0,0,{"$f":"Input!D35","v":0.4894},null,null,null,null,0.58069999999999999,null,null,null,null,null,null,0.51059999999999994]
[null,"May",0,0,{"$f":"Input!C36","v":0.44369999999999998},0,0,0,0,0,0,{"$f":"Input!D36","v":0.50139999999999996},null,null,null,null,0.55630000000000002,null,null,null,null,null,null,0.49860000000000004]
[null,"June",0,0,{"$f":"Input!C37","v":0.46},0,0,0,0,0,0,{"$f":"Input!D37","v":0.50729999999999997},null,null,null,null,0.54,null,null,null,null,null,null,0.49270000000000003]
[null,"July",0,0,{"$f":"Input!C38","v":0.48649999999999999},0,0,0,0,0,0,{"$f":"Input!D38","v":0.50639999999999996},null,null,null,null,0.51350000000000007,null,null,null,null,null,null,0.49360000000000004]
[null,"August",0,0,{"$f":"Input!C39","v":0.48620000000000002},0,0,0,0,0,0,{"$f":"Input!D39","v":0.49940000000000001},null,null,null,null,0.51380000000000003,null,null,null,null,null,null,0.50059999999999993]
[null,"September",0,0,{"$f":"Input!C40","v":0.48749999999999999},0,0,0,0,0,0,{"$f":"Input!D40","v":0.50780000000000003},null,null,null,null,0.51249999999999996,null,null,null,null,null,null,0.49219999999999997]
[null,"October",0,0,{"$f":"Input!C41","v":0.46179999999999999},0,0,0,0,0,0,{"$f":"Input!D41","v":0.50619999999999998},null,null,null,null,0.53820000000000001,null,null,null,null,null,null,0.49380000000000002]
[null,"November",0,0,{"$f":"Input!C42","v":0.43609999999999999},0,0,0,0,0,0,{"$f":"Input!D42","v":0.49680000000000002},null,null,null,null,0.56390000000000007,null,null,null,null,null,null,0.50319999999999998]
[null,"December",0,0,{"$f":"Input!C43","v":0.42849999999999999},0,0,0,0,0,0,{"$f":"Input!D43","v":0.48530000000000001},null,null,null,null,0.57150000000000001,null,null,null,null,null,null,0.51469999999999994]
[]
[]
["Table #3","Class Usage @ customer",null,null,null,null,null,null,null,null,null,null,null,null,"Usage by season - PSE&G periods"]
[null,{"$f":"Input!B47","v":"Calendar month sales forecasted for 2020, less % for LPL-Sec > 500 kW Peak Load Share"},null,null,null,null,null,null,null,null,null,"< 500 kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"LPL-S > 500 kW PLS"]
[null,"in MWh",{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,"%",null,"LPL-S",null,"% of","% of","% of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh","Gen Obl","Trans Obl"]
[null,"January",{"$f":"Input!C50","v":1081757.8894000214},{"$f":"Input!D50","v":16281.351533194471},{"$f":"Input!E50","v":14609.307048244767},{"$f":"Input!F50","v":77},{"$f":"Input!G50","v":2},{"$f":"Input!H50","v":1987.0872781741152},{"$f":"Input!I50","v":15657},{"$f":"Input!J50","v":32646},{"$f":"Input!K50","v":551271.57970443647},{"$f":"AB45*$M$45","v":409109.26675521472},{"$f":"(1-AD45)","v":0.64336931019663379},"winter MWh =",{"$f":"SUM(C45:C49,C54:C56)","v":6940335.7141500339},{"$f":"SUM(D45:D49,D54:D56)","v":77951.342291865585},95719.639944273455,576,12,9052.0959089891185,106887,222506,4035914.4222040814,3059039.1173722357,{"$f":"SUM(O45:X45)","v":14547993.331871478},{"$f":"+Y45/(Y45+Y49)","v":0.60690670510980749},null,{"$f":"Input!L50","v":635885.57966835273},null,{"$f":"Input!C66","v":0.35663068980336626},{"$f":"Input!D66","v":0.34538456609153972},{"$f":"AE45","v":0.34538456609153972}]
[null,"February",{"$f":"Input!C51","v":926769.90195212536},{"$f":"Input!D51","v":13814.016772148098},{"$f":"Input!E51","v":12566.685002924984},{"$f":"Input!F51","v":71},{"$f":"Input!G51","v":2},{"$f":"Input!H51","v":1702.3600548880529},{"$f":"Input!I51","v":13467},{"$f":"Input!J51","v":27223},{"$f":"Input!K51","v":520226.47053984442},{"$f":"AB46*$M$45","v":382549.17371046951},null,"on-peak",null,null,{"$f":"SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56)","v":41335.342473061843},null,null,null,null,null,null,{"$f":"SUMPRODUCT(L27:L31,L45:L49)+SUMPRODUCT(L36:L38,L54:L56)","v":1499087.7960871218},null,null,null,{"$f":"Input!L51","v":594602.76958742482}]
[null,"March",{"$f":"Input!C52","v":857391.91407228913},{"$f":"Input!D52","v":10809.640130502163},{"$f":"Input!E52","v":11989.461898153811},{"$f":"Input!F52","v":78},{"$f":"Input!G52","v":1},{"$f":"Input!H52","v":1334.444456123834},{"$f":"Input!I52","v":12961},{"$f":"Input!J52","v":27598},{"$f":"Input!K52","v":530696.71172781789},393439.44125505211,null,"off-peak",{"$f":"+O45-O46","v":6940335.7141500339},{"$f":"+P45-P46","v":77951.342291865585},{"$f":"+Q45-Q46","v":54384.297471211612},{"$f":"+R45-R46","v":576},null,null,null,null,null,{"$f":"+X45-X46","v":1559951.3212851139},null,null,null,{"$f":"Input!L52","v":611529.70000201708}]
[null,"April",{"$f":"Input!C53","v":713094.85623466456},{"$f":"Input!D53","v":6831.5167338189503},{"$f":"Input!E53","v":10156.573366415969},{"$f":"Input!F53","v":66},{"$f":"Input!G53","v":2},{"$f":"Input!H53","v":901.35033636642004},{"$f":"Input!I53","v":10692},{"$f":"Input!J53","v":23860},{"$f":"Input!K53","v":464119.48244831781},342157.34907430527,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L53","v":531821.06086118915}]
[null,"May",{"$f":"Input!C54","v":813401.01389094617},{"$f":"Input!D54","v":4749.2849583270645},{"$f":"Input!E54","v":13047.248314480128},{"$f":"Input!F54","v":78},{"$f":"Input!G54","v":1},{"$f":"Input!H54","v":404.79291985247409},{"$f":"Input!I54","v":10116},{"$f":"Input!J54","v":22188},{"$f":"Input!K54","v":490162.09729777509},391403.53710036405,null,"summer MWh =",{"$f":"SUM(C50:C53)","v":5215736.3085080748},{"$f":"+SUM(D50:D53)","v":22442.999302066281},84424.122410623386,190,4,2358.4333254116605,41017,76450,2304203.2296374706,1675904.9208545377,{"$f":"SUM(O49:X49)","v":9422731.0140381828},{"$f":"1-Z45","v":0.39309329489019251},null,{"$f":"Input!L54","v":608365.25910870521}]
[null,"June",{"$f":"Input!C55","v":1196743.3173224113},{"$f":"Input!D55","v":5677.1633676903602},{"$f":"Input!E55","v":19706.743313127627},{"$f":"Input!F55","v":56},{"$f":"Input!G55","v":1},{"$f":"Input!H55","v":603.75893130538509},{"$f":"Input!I55","v":8906},{"$f":"Input!J55","v":19116},{"$f":"Input!K55","v":539921.06420817017},408305.60911097715,null,"on-peak",null,null,{"$f":"+SUMPRODUCT(E32:E35,E50:E53)","v":40559.187404223652},null,null,null,null,null,null,{"$f":"+SUMPRODUCT(L32:L35,L50:L53)","v":846378.9223629632},null,null,null,{"$f":"Input!L55","v":634636.44075000437}]
[null,"July",{"$f":"Input!C56","v":1558280.6277681533},{"$f":"Input!D56","v":6018.3091886406137},{"$f":"Input!E56","v":25395.992840248226},{"$f":"Input!F56","v":43},{"$f":"Input!G56","v":1},{"$f":"Input!H56","v":622.62639790867831},{"$f":"Input!I56","v":9387},{"$f":"Input!J56","v":16613},{"$f":"Input!K56","v":611191.16840157192},432746.73482416588,null,"off-peak",null,null,{"$f":"+Q49-Q50","v":43864.935006399734},null,null,null,null,null,null,{"$f":"+X49-X50","v":829525.99849157454},null,null,null,{"$f":"Input!L56","v":672625.70341116353}]
[null,"August",{"$f":"Input!C57","v":1459451.2163344752},{"$f":"Input!D57","v":6014.4868265011155},{"$f":"Input!E57","v":23262.182310762375},{"$f":"Input!F57","v":49},{"$f":"Input!G57","v":1},{"$f":"Input!H57","v":673.22551289023761},{"$f":"Input!I57","v":10539},{"$f":"Input!J57","v":19843},{"$f":"Input!K57","v":618380.76146584225},456618.83495973516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L57","v":709730.51981633715}]
[null,"September",{"$f":"Input!C58","v":1001261.1470830349},{"$f":"Input!D58","v":4733.0399192341947},{"$f":"Input!E58","v":16059.203946485151},{"$f":"Input!F58","v":42},{"$f":"Input!G58","v":1},{"$f":"Input!H58","v":458.82248330735939},{"$f":"Input!I58","v":12185},{"$f":"Input!J58","v":20878},{"$f":"Input!K58","v":534710.23556188645},378233.74195965962,null,"Block 1",{"$f":"+O49*C163","v":3369365.6552962163},{"$f":"+P49*D163","v":14834.822538665812},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L58","v":587895.21968969819}]
[null,"October",{"$f":"Input!C59","v":762395.1000460668},{"$f":"Input!D59","v":5903.6383244556546},{"$f":"Input!E59","v":10440.169552172421},{"$f":"Input!F59","v":84},{"$f":"Input!G59","v":1},{"$f":"Input!H59","v":629.48729485533045},{"$f":"Input!I59","v":13604},{"$f":"Input!J59","v":28116},{"$f":"Input!K59","v":502657.21643157839},392330.50502778776,null,"Block 2",{"$f":"+O49-O53","v":1846370.6532118586},{"$f":"+P49-P53","v":7608.1767634004682},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L59","v":609806.06132406171}]
[null,"November",{"$f":"Input!C60","v":787720.26573014352},{"$f":"Input!D60","v":7731.6830176708809},{"$f":"Input!E60","v":9914.9238833759046},{"$f":"Input!F60","v":59},{"$f":"Input!G60","v":1},{"$f":"Input!H60","v":731.54313693678046},{"$f":"Input!I60","v":14748},{"$f":"Input!J60","v":28564},{"$f":"Input!K60","v":458717.61204382661},363570.09411743958,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L60","v":565103.25928714441}]
[null,"December",{"$f":"Input!C61","v":997804.7728237774},{"$f":"Input!D61","v":11830.210821748302},{"$f":"Input!E61","v":12995.270878505473},{"$f":"Input!F61","v":63},{"$f":"Input!G61","v":2},{"$f":"Input!H61","v":1361.0304317921109},{"$f":"Input!I61","v":15642},{"$f":"Input!J61","v":32311},{"$f":"Input!K61","v":518063.25201048487},384479.75033160264,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L61","v":597603.49808120879}]
[null,"Total",{"$f":"SUM(C45:C56)","v":12156072.02265811},{"$f":"SUM(D45:D56)","v":100394.34159393187},{"$f":"SUM(E45:E56)","v":180143.76235489687},766,16,{"$f":"SUM(H45:H56)","v":11410.529234400779},{"$f":"SUM(I45:I56)","v":147904},{"$f":"SUM(J45:J56)","v":298956},6340117.6518415529,{"$f":"SUM(L45:L56)","v":4734944.038226773},null,null,"Usage by season/period - PJM periods",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB45:AB56)","v":7359605.0715873064}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in MWhs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total","%"]
["Table #4","Forwards Prices - Energy Only @ bulk system",null,null,null,null,"Table #5","Zone to Western Hub Basis Differential",null,null,null,null,null,"Winter"]
[null,"in $/MWh, not including PJM losses",null,"Off/On Pk","Resulting",null,null,null,null,null,null,null,null,"on-peak",{"$f":"SUMPRODUCT(C9:C13,C45:C49)+SUMPRODUCT(C18:C20,C54:C56)","v":3360106.451507967},{"$f":"SUMPRODUCT(D9:D13,D45:D49)+SUMPRODUCT(D18:D20,D54:D56)","v":37583.439378950032},47723.850008847003,280.11470000000003,5.7801,4389.8555481326184,29516.385699999999,61180.040399999998,2283825.4662774783,1664214.6752360049,{"$f":"SUM(O61:X61)","v":7488826.0588573795},{"$f":"+Y61/(Y61+Y62)","v":0.51476694331794859}]
[null,null,"On-Peak","LMP ratio","Off-Peak",null,null,"On-Peak","Off-Peak",null,null,null,null,"off-peak",{"$f":"+O45-O61","v":3580229.2626420669},{"$f":"+P45-P61","v":40367.902912915553},47995.789935426452,295.88529999999997,6.2199,4662.2403608565,77370.614300000001,161325.9596,1752088.9559266032,1394824.4421362309,{"$f":"SUM(O62:X62)","v":7059167.2730140993},{"$f":"1-Z61","v":0.48523305668205141}]
[null,"January",{"$f":"Input!C73","v":42.05},{"$f":"Input!F74","v":0.78759999999999997},{"$f":"ROUND(+C63*D63,3)","v":33.119},null,null,{"$f":"Input!F81","v":0.97},{"$f":"Input!G81","v":0.98},"NYMEX Forwards (January 10, 2020) from NERA"]
[null,"February",{"$f":"Input!C74","v":39.75},{"$f":"+$D$63","v":0.78759999999999997},{"$f":"ROUND(+C64*D64,3)","v":31.306999999999999},null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98},null,null,null,null,"Summer"]
[null,"March",{"$f":"Input!C75","v":32.1},{"$f":"+$D$63","v":0.78759999999999997},{"$f":"ROUND(+C65*D65,3)","v":25.282},null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98},"Congestion Factors & On/Off Peak Ratios ",null,null,null,"on-peak",{"$f":"SUMPRODUCT(C14:C17,C50:C53)","v":2668798.6611791034},{"$f":"SUMPRODUCT(D14:D17,D50:D53)","v":11681.030812136467},44815.915907573217,97.409600000000012,2.0426000000000002,1445.9121623979133,8668.7494000000006,16137.778700000003,1357460.1225086856,934113.67745476426,5043221.3003246607,{"$f":"+Y65/(Y65+Y66)","v":0.53521864232473182}]
[null,"April",{"$f":"Input!C76","v":29.05},{"$f":"+$D$63","v":0.78759999999999997},22.88,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98},"  Summer Averages for Aug 2016-Jul 2019",null,null,null,"off-peak",{"$f":"+O49-O65","v":2546937.6473289714},{"$f":"+P49-P65","v":10761.968489929814},39608.206503050169,92.590399999999988,1.9573999999999998,912.52116301374713,32348.250599999999,60312.221299999997,946743.10712878499,741791.24339977349,4379509.7137135239,{"$f":"1-Z65","v":0.46478135767526818}]
[null,"May",{"$f":"Input!C77","v":29.05},{"$f":"+$D$63","v":0.78759999999999997},22.88,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98},"  Winter Averages for Oct 2016-May 2019"]
[null,"June",{"$f":"Input!C78","v":28.25},{"$f":"Input!F73","v":0.66839999999999999},18.882000000000001,null,null,{"$f":"Input!F80","v":0.94},{"$f":"Input!G80","v":0.9},null,null,null,null,"Total on-peak",{"$f":"+O61+O65","v":6028905.1126870699},{"$f":"+P61+P65","v":49264.470191086497},92539.76591642022,377.52430000000004,7.8227000000000002,5835.767710530532,38185.1351,77317.819099999993,3641285.5887861638,2598328.3526907694,12532047.359182039,{"$f":"+Y68/(Y68+Y69)","v":0.52280636906662747}]
[null,"July",{"$f":"Input!C79","v":32.9},{"$f":"+$D$68","v":0.66839999999999999},21.99,null,null,{"$f":"+$H$68","v":0.94},{"$f":"+$I$68","v":0.9},null,null,null,null,"Total off-peak",{"$f":"+O62+O66","v":6127166.9099710379},{"$f":"+P62+P66","v":51129.871402845369},87603.996438476621,388.47569999999996,8.1772999999999989,5574.7615238702474,109718.8649,221638.18090000001,2698832.0630553882,2136615.6855360046,11438676.986727623,{"$f":"1-Z68","v":0.47719363093337253}]
[null,"August",{"$f":"Input!C80","v":30.75},{"$f":"+$D$68","v":0.66839999999999999},20.553000000000001,null,null,{"$f":"+$H$68","v":0.94},{"$f":"+$I$68","v":0.9}]
[null,"September",{"$f":"Input!C81","v":30.45},{"$f":"+$D$68","v":0.66839999999999999},20.353000000000002,null,null,{"$f":"+$H$68","v":0.94},{"$f":"+$I$68","v":0.9}]
[null,"October",{"$f":"Input!C82","v":28.35},{"$f":"+$D$63","v":0.78759999999999997},22.327999999999999,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98}]
[null,"November",{"$f":"Input!C83","v":28.8},{"$f":"+$D$63","v":0.78759999999999997},22.683,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98}]
[null,"December",{"$f":"Input!C84","v":31.55},{"$f":"+$D$63","v":0.78759999999999997},24.849,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98}]
[]
[]
["Table #6","Losses",{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,null,"Loss Type","Percentage","Source"]
[null,"from meter to bulk system (includes Delivery & PJM EHV losses)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery Losses",{"$f":"Input!C89","v":5.8326999999999997E-2},"Tariff (Result of 2018 Loss Study)"]
[null,"     Loss Factors =",{"$f":"1-((1-$Q$78)*(1-$Q$79))","v":6.2621028879999985E-2},{"$f":"+$C79","v":6.2621028879999985E-2},{"$f":"+$C79","v":6.2621028879999985E-2},6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,null,null,null,"EHV Losses",{"$f":"Input!C90","v":4.5599999999999998E-3},"PJM"]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C79),6)","v":1.0668040000000001},{"$f":"ROUND(1/(1-D79),6)","v":1.0668040000000001},1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,null,null,null,"Marginal Loss Deration Factor",{"$f":"+Input!C91","v":1.0525E-2},"NERA"]
[null,"     1 / Expansion Factor =",{"$f":"1/C80","v":0.93737931241352668},{"$f":"1/D80","v":0.93737931241352668},0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,null,null,null,"Marginal Loss Factor",{"$f":"ROUND(1-((1-Q80)/(1-Q79)),7)","v":5.9922999999999999E-3}]
[]
[null,"from meter to transmission node (includes Delivery less mean hourly PJM marginal losses)"]
[null,"     Loss Factors =",{"$f":"1-((1-$Q$78)/((1-$Q$80)/(1-$Q$79)))","v":5.2650171939664925E-2},{"$f":"+$C84","v":5.2650171939664925E-2},{"$f":"+$C84","v":5.2650171939664925E-2},5.2650171939664925E-2,5.2650171939664925E-2,5.2650171939664925E-2,5.2650171939664925E-2,5.2650171939664925E-2,5.2650171939664925E-2,5.2650171939664925E-2]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C84),6)","v":1.0555760000000001},{"$f":"+$C$85","v":1.0555760000000001},{"$f":"+$C$85","v":1.0555760000000001},1.0555760000000001,1.0555760000000001,1.0555760000000001,1.0555760000000001,1.0555760000000001,1.0555760000000001,1.0555760000000001]
[null,"     1 / Expansion Factor =",{"$f":"1/C85","v":0.94735007237754543},{"$f":"1/D85","v":0.94735007237754543},0.94735007237754543,0.94735007237754543,0.94735007237754543,0.94735007237754543,0.94735007237754543,0.94735007237754543,0.94735007237754543,0.94735007237754543]
[]
[]
["Table #7","Summary of Average BGS Energy Only Unit Costs @ customer - PJM Time Periods"]
[null,"based on Forwards prices corrected for congestion & all losses - PJM time periods"]
[null,"in $/MWh"]
[null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"Summer - all hrs",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80+SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUM(C50:C53)","v":25.416383685418449},25.406792337410103,25.624597918384655,25.157371868539716,25.262266122055593,26.418121726915309,21.975505827143675,21.901420314191633,26.1930172566891,25.809582490617917]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80)/SUMPRODUCT(C14:C17,C50:C53)","v":30.807761084617756},30.68211263029475,30.801988874361104,30.4837608442792,30.637749801103102,30.662986204204518,30.64269626685553,30.548986955477769,30.710624918533863,30.665770339976135]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUMPRODUCT(O14:O17,C50:C53)","v":19.767049945354611},19.680964488839969,19.766480669733113,19.553751843448627,19.652803077801764,19.692029857251068,19.652854662695919,19.587585510190177,19.715576645907046,19.69434248106386]
[]
[null,"Winter - all hrs",{"$f":"(SUMPRODUCT(C9:C13,C45:C49,$C63:$C67,$H63:$H67)*C80+SUMPRODUCT(O9:O13,C45:C49,$E63:$E67,$I63:$I67)*C80+SUMPRODUCT(C18:C20,C54:C56,$C72:$C74,$H72:$H74)*C80+SUMPRODUCT(O18:O20,C54:C56,$E72:$E74,$I72:$I74)*C80)/SUM(C45:C49,C54:C56)","v":30.672728453515155},31.811599077174989,30.697391426917893,30.251705630169226,31.079232137795003,32.081871742138098,29.039873241371769,29.008395778825736,30.933848451231821,30.691755234009847]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C9:C13,C45:C49,$C63:$C67,$H63:$H67)*C80+SUMPRODUCT(C18:C20,C54:C56,$C72:$C74,$H72:$H74)*C80)/(SUMPRODUCT(C9:C13,C45:C49)+SUMPRODUCT(C18:C20,C54:C56))","v":34.257971425022099},35.513153999096254,34.137930857747044,33.766777383393439,34.75146805047892,35.652745594344296,34.349000205579934,34.336038212073589,33.881881828588746,33.78697655495764]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O9:O13,C45:C49,$E63:$E67,$I63:$I67)*C80+SUMPRODUCT(O18:O20,C54:C56,$E72:$E74,$I72:$I74)*C80)/(SUMPRODUCT(O9:O13,C45:C49)+SUMPRODUCT(O18:O20,C54:C56))","v":27.307916550409814},28.36536692298073,27.276345790054258,26.923986173903998,27.666654636725173,28.7196211547597,27.014475865073081,26.987980836859645,27.091124781369366,26.99873653587494]
[]
[null,"Annual",{"$f":"(C94*SUM(C50:C53)+C98*SUM(C45:C49,C54:C56))/C57","v":28.417418662169943},30.379814467522237,28.320033840233819,28.988098039164516,29.624990633860151,30.911235699908662,27.080770321711764,27.190976913603841,29.210877498719846,28.96373959981101]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C102:L102,C57:L57)/SUM(C57:L57)","v":28.720348852443614}]
[]
[]
["Table #8","Summary of Average BGS Energy Only Costs @ customer - PJM Time Periods"]
[null,"based on Forwards prices corrected for congestion & all losses"]
[null,"in $1000"]
[null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[]
[null,"Summer - all hrs",{"$f":"SUM(C50:C53)*C94/1000","v":132565.15521900929},570.20462269623783,2163.3341913847112,4.779900655022546,0.10104906448822237,62.305378675538911,901.36932251195219,1674.3635830199505,60354.034956813026,43254.406301227682]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C50:C53,C14:C17)*C95/1000","v":82219.711536553543},358.39870301591441,1380.4193431793731,2.9694109503368997,6.2580667743733207E-2,44.33598468809874,265.63385487768613,492.99279099668706,41688.44866423127,28645.315504258342]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C50:C53,O14:O17)*C96/1000","v":50345.443682455749},211.8059196803234,782.91484820533822,1.8104897046856461,3.8468396744489167E-2,17.969393987440178,635.735467634266,1181.3707920232634,18665.586292581753,14609.090796969342]
[]
[null,"Winter - all hrs",{"$f":"SUM(C45:C49,C54:C56)*C98/1000","v":212879.03273635719},2479.7568485164629,2938.3432546130075,17.424982442977473,0.37295078565354006,290.4081799497219,3103.9849311505045,6454.5421111633996,124846.36509860189,93887.279841650176]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C45:C49,C9:C13)+SUMPRODUCT(C54:C56,C18:C20))*C99/1000","v":115110.43080079234},1334.7064704803511,1629.1934918675097,9.4585707167160393,0.20086696047857319,156.51040305349306,1013.8583384772766,2100.6802049906059,77380.304565535116,56228.782214615334]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C45:C49,O9:O13)+SUMPRODUCT(C54:C56,O18:O20))*C100/1000","v":97768.601935564846},1145.0503780361121,1309.1497627454978,7.9664117262614367,0.1720838251749669,133.89777689622883,2090.1265926732281,4353.8619061727932,47466.060533066782,37658.497627034834]
[]
[null,"Annual",{"$f":"+C112+C116","v":345444.18795536645},{"$f":"+D112+D116","v":3049.9614712127009},5101.6774459977187,22.204883098000018,0.47399985014176244,352.71355862526082,4005.3542536624568,8128.9056941833496,185200.40005541491,137141.68614287785]
[]
[null,"System Total",{"$f":"SUM(C120:L120)","v":688447.5654602889}]
[]
[]
["Table #9","Summary of Average BGS Energy Only Unit Costs @ customer - PSE&G Time Periods",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWhs in PSE&G time periods",null,null,"MWhs in PJM time periods",null,null,"Difference in MWhs",null,null,"Check on total $ recovered"]
[null,"based on Forwards prices corrected for congestion & all losses - PSE&G billing time periods",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(PJM - PSE&G)",null,null,"PSE&G time periods",null,null,"PJM time periods (Table #8)"]
[null,"in $/MWh"]
[null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,null,null,{"$f":"+E128","v":"RLM"},{"$f":"+L128","v":"LPL-S"},null,{"$f":"+E128","v":"RLM"},{"$f":"+L128","v":"LPL-S"},null,{"$f":"+E128","v":"RLM"},{"$f":"+L128","v":"LPL-S"},null,{"$f":"+E128","v":"RLM"},{"$f":"+L128","v":"LPL-S"},null,{"$f":"+E128","v":"RLM"},{"$f":"+L128","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"+C112/SUM(C50:C53)*1000","v":25.416383685418452},25.406792337410099,25.624597918384652,25.157371868539716,25.262266122055593,26.418121726915309,21.975505827143675,21.901420314191636,26.1930172566891,25.809582490617917]
[null,"PSE&G On pk",null,null,{"$f":"+(E113*1000-W131*AVERAGE(E$95,E$96))/Q131","v":31.38108285195268},null,null,null,null,null,null,{"$f":"+(L113*1000-X131*AVERAGE(L$95,L$96))/R131","v":31.234413716350431},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,E32:E35)","v":40559.187404223652},{"$f":"SUMPRODUCT(L50:L53,L32:L35)","v":846378.9223629632},null,{"$f":"SUMPRODUCT(E50:E53,E14:E17)","v":44815.915907573217},{"$f":"SUMPRODUCT(L50:L53,L14:L17)","v":934113.67745476426},null,{"$f":"+T131-Q131","v":4256.7285033495646},{"$f":"+U131-R131","v":87734.755091801053},null,{"$f":"+E131*Q131/1000","v":1272.791220339818},{"$f":"+L131*R131/1000","v":26436.149421883634}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E114*1000-W132*AVERAGE(E$95,E$96))/Q132","v":20.301932988501335},null,null,null,null,null,null,{"$f":"+(L114*1000-X132*AVERAGE(L$95,L$96))/R132","v":20.274538603885443},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,Q32:Q35)","v":43864.935006399734},{"$f":"SUMPRODUCT(L50:L53,X32:X35)","v":829525.99849157454},null,{"$f":"SUMPRODUCT(E50:E53,Q14:Q17)","v":39608.206503050154},{"$f":"SUMPRODUCT(L50:L53,X14:X17)","v":741791.24339977349},null,{"$f":"+T132-Q132","v":-4256.7285033495791},{"$f":"+U132-R132","v":-87734.755091801053},null,{"$f":"+E132*Q132/1000","v":890.54297104489376},{"$f":"+L132*R132/1000","v":16818.256879344048}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z132+Z131","v":2163.3341913847116},{"$f":"+AA132+AA131","v":43254.406301227682},null,{"$f":"+E112","v":2163.3341913847112},{"$f":"+L112","v":43254.406301227682}]
[null,"Winter - all hrs",{"$f":"+C116/SUM(C45:C49,C54:C56)*1000","v":30.672728453515155},31.811599077174993,30.697391426917893,30.251705630169226,31.079232137795007,32.081871742138098,29.039873241371769,29.008395778825736,30.933848451231817,30.691755234009847]
[null,"PSE&G On pk",null,null,{"$f":"+(E117*1000-W135*AVERAGE(E$99,E$100))/Q135","v":34.668170663319643},null,null,null,null,null,null,{"$f":"+(L117*1000-X135*AVERAGE(L$99,L$100))/R135","v":34.16084421374002},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38)","v":41335.342473061843},{"$f":"SUMPRODUCT(L45:L49,L27:L31)+SUMPRODUCT(L54:L56,L36:L38)","v":1499087.7960871218},null,{"$f":"SUMPRODUCT(E45:E49,E9:E13)+SUMPRODUCT(E54:E56,E18:E20)","v":47723.850008847003},{"$f":"SUMPRODUCT(L45:L49,L9:L13)+SUMPRODUCT(L54:L56,L18:L20)","v":1664214.6752360049},null,{"$f":"+T135-Q135","v":6388.5075357851601},{"$f":"+U135-R135","v":165126.87914888305},null,{"$f":"+E135*Q135/1000","v":1433.0207072828728},{"$f":"+L135*R135/1000","v":51210.104664851031}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E118*1000-W136*AVERAGE(E$99,E$100))/Q136","v":27.679359986712679},null,null,null,null,null,null,{"$f":"+(L118*1000-X136*AVERAGE(L$99,L$100))/R136","v":27.358017262770073},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,Q27:Q31)+SUMPRODUCT(E54:E56,Q36:Q38)","v":54384.297471211612},{"$f":"SUMPRODUCT(L45:L49,X27:X31)+SUMPRODUCT(L54:L56,X36:X38)","v":1559951.3212851137},null,{"$f":"SUMPRODUCT(E45:E49,Q9:Q13)+SUMPRODUCT(E54:E56,Q18:Q20)","v":47995.789935426452},{"$f":"SUMPRODUCT(L45:L49,X9:X13)+SUMPRODUCT(L54:L56,X18:X20)","v":1394824.4421362309},null,{"$f":"+T136-Q136","v":-6388.5075357851601},{"$f":"+U136-R136","v":-165126.87914888281},null,{"$f":"+E136*Q136/1000","v":1505.3225473301343},{"$f":"+L136*R136/1000","v":42677.175176799123}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z136+Z135","v":2938.343254613007},{"$f":"+AA136+AA135","v":93887.279841650161},null,{"$f":"+E116","v":2938.3432546130075},{"$f":"+L116","v":93887.279841650176}]
[null,"Annual Average",{"$f":"(C130*SUM(C50:C53)+C134*SUM(C45:C49,C54:C56))/C57","v":28.417418662169943},30.379814467522237,28.320033840233819,28.988098039164516,29.624990633860154,30.911235699908662,27.080770321711764,27.190976913603841,29.210877498719846,28.96373959981101]
[null,"System Average",{"$f":"+C122/SUM(C57:L57)*1000","v":28.720348852443614}]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments",null,null,null,null,null,null,null,null,null,"Adj for PLS"]
[null,{"$f":"Input!B97","v":"Obligations - Peak Load shares eff 1/1/19, scaling factors eff 6/1/18, Transmission Loads eff 1/1/19; costs are market estimates"},null,null,null,null,null,null,null,null,null,"> 500 kW"]
[null,"in MW",{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NITS Rate Weighted Average Calculation",null,null,null,null,null,null,null,null,null,null,"Generation Peak Load Share",{"$f":"Input!C101","v":3942.6720872925002},{"$f":"Input!D101","v":18.278651099544039},{"$f":"Input!E101","v":63.414647665295938},{"$f":"Input!F101","v":0},{"$f":"Input!G101","v":0},{"$f":"Input!H101","v":3.3750143976915514},{"$f":"Input!I101","v":0},{"$f":"Input!J101","v":0},{"$f":"Input!K101","v":1677.4443227486215},{"$f":"Input!L101","v":1328.1438265494457}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tranches","NITS Rate",null,null,null,null,null,null,null,"Tranmsission Obligation",{"$f":"Input!C102","v":4409.3488484669124},{"$f":"Input!D102","v":19.95785360948198},{"$f":"Input!E102","v":69.352239348610141},{"$f":"Input!F102","v":0},{"$f":"Input!G102","v":0},{"$f":"Input!H102","v":3.2978384299601702},{"$f":"Input!I102","v":0},{"$f":"Input!J102","v":0},{"$f":"Input!K102","v":1572.9757961273096},{"$f":"Input!L102","v":1261.747990868246}]
[null,"Gen Obl - MW",{"$f":"ROUND(AD145*$AD$148*$AD$149,1)","v":4746.8},{"$f":"ROUND(AE145*$AD$148*$AD$149,1)","v":22},76.3,0,0,4.0999999999999996,0,0,2019.6,{"$f":"ROUND(AM145*$AD$148*$AD$149*(1-AE45),1)","v":1046.7},null,null,null,null,null,{"$f":"Input!C108","v":2018}," NITS Rate",{"$f":"Input!D108","v":29},{"$f":"Input!E108","v":101197},{"$f":"U147/$T$150*T147","v":34526.035294117646}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!C109","v":2019}," NITS Rate",{"$f":"Input!D109","v":28},{"$f":"Input!E109","v":104709.15},{"$f":"U148/$T$150*T148","v":34492.425882352938},null,null,null,null,null,null,"Final Zonal RPM Scaling Factor",{"$f":"Input!C104","v":1.1050543994531257}]
[null,"Trans Obl - MW",{"$f":"ROUND(AD146,1)","v":4409.3},{"$f":"ROUND(AE146,1)","v":20},69.400000000000006,0,0,3.3,0,0,1573,{"$f":"ROUND(AM146*(1-AF45),1)","v":826},null,null,null,null,null,{"$f":"Input!C110","v":2020}," NITS Rate",{"$f":"Input!D110","v":28},{"$f":"Input!E110","v":138497.08431889772},{"$f":"U149/$T$150*T149","v":45622.568952107482},null,{"$f":"+Input!B105","v":"PJM June 1, -1 (through May 31, ) Forecast Pool Requirement"},null,null,null,null,null,{"$f":"Input!C105","v":1.0894999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T147:T149)","v":85},null,{"$f":"ROUND(SUM(V147:V149),2)","v":114641.03}]
[null,"# of Months and Days used in this analysis"]
[null,null,null,"# of summer days =",122,null,"# of summer months =",4]
[null,null,null,"# of winter days =",243,null,"# of winter months =",8]
[null,null,null,null,null,null,"total # months =",{"$f":"+H152+H153","v":12}]
[null,"Transmission Cost","year round =",{"$f":"V150","v":114641.03},"per MW-yr"]
[]
[null,null,null,"Base\nCapacity","Capacity Proxy True Up","Total Capacity"]
[null,"Generation Capacity cost","summer =",{"$f":"Input!E113","v":174.13},{"$f":"SUM(auction_results_and_rates!E13:E13)/SUM(auction_results_and_rates!C13:E13)*Input!E115","v":0},{"$f":"SUM(D158:E158)","v":174.13},"$/MW/day"]
[null,null,"winter =",{"$f":"Input!E114","v":174.13},{"$f":"E158","v":0},{"$f":"SUM(D159:E159)","v":174.13},"$/MW/day",null,null,null,null,null,null,null,null,null,"Resulting average generation capacity cost = "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"annual  >>",{"$f":"(F158*E152+F159*E153)/1000","v":63.557449999999996},"per kW/yr"]
[null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"}]
[null,"% usage in Summer Blocks"]
[null,"Block 1 (0-600 kWh/m)",{"$f":"ROUND(Q165/Q167,3)","v":0.64600000000000002},{"$f":"ROUND(R165/R167,3)","v":0.66100000000000003},null,"(based on W/N actuals used in settlement and final rate design of 2018 Rate Case, rounded to .1%)",null,null,null,null,null,null,null,null,null,"Blocking Percentages based on Annualized W/N Usage Used in 2018 Electric Rate Case Settlement"]
[null,"Block 2  (>600 kWh/m)",{"$f":"1-C163","v":0.35399999999999998},{"$f":"1-D163","v":0.33899999999999997},null,null,null,null,null,null,null,null,null,null,null,null,"RS","RHS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June - September (0-600)",3528124,19973]
[null,"Required summer inversion =",{"$f":"Input!C119","v":0.86519999999999975},{"$f":"Input!D119","v":1.1569000000000003},"¢/kWh","(same as 2003/2004 BGS blocking inversion)",null,null,null,null,null,null,null,null,null,"June - September (600+)",1931618,10227]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Summer Usage",{"$f":"SUM(Q165:Q166)","v":5459742},{"$f":"SUM(R165:R166)","v":30200}]
["Table #11","Ancillary Services & Renewable Power Cost"]
[null,"Ancillary Services ",null,{"$f":"+Input!D123","v":2}]
[null,"Renewable Power Cost",null,{"$f":"+Input!D124","v":16.72}]
[null,"Total AncillaryServices & Renewable Power Costs",null,{"$f":"SUM(D169:D170)","v":18.72},"per MWh @  bulk system"]
[]
[]
["Table #12","Summary of Obligation Costs Expressed as $/MWh @ customer (for non-demand rates only)"]
[]
[null,null,{"$f":"+C7","v":"RS"},"RHS","RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Transmission Obl - all months",{"$f":"(+$D$155*C149*$H$154/12)/C57","v":41.583061751921711},{"$f":"(+$D$155*D149*$H$154/12)/D57","v":22.838145692252692},{"$f":"(+$D$155*E149*$H$154/12)/SUMPRODUCT(E27:E38,E45:E56)","v":97.150414001054344},{"$f":"(+$D$155*F149*$H$154/12)/F57","v":0},{"$f":"(+$D$155*G149*$H$154/12)/G57","v":0},{"$f":"(+$D$155*H149*$H$154/12)/H57","v":33.154938848887419},{"$f":"(+$D$155*I149*$H$154/12)/I57","v":0},{"$f":"(+$D$155*J149*$H$154/12)/J57","v":0}]
[]
[null,"Generation Obl -                "]
[null,"per annual MWh",{"$f":"((+$Q$160*C147*1000)/C57)","v":24.818420218114987},{"$f":"((+$Q$160*D147*1000)/D57)","v":13.927716221852439},{"$f":"(+$Q$160*E147*1000)/SUMPRODUCT(E45:E56,E27:E38)","v":59.215596478380327},{"$f":"((+$Q$160*F147*1000)/F57)","v":0},{"$f":"((+$Q$160*G147*1000)/G57)","v":0},{"$f":"((+$Q$160*H147*1000)/H57)","v":22.837288231502832},{"$f":"((+$Q$160*I147*1000)/I57)","v":0},{"$f":"((+$Q$160*J147*1000)/J57)","v":0}]
[null,"recovery per summer MWh",{"$f":"(C147*$F$158*$E$152)/SUM(C50:C53)","v":19.333867489333386},{"$f":"(D147*$F$158*$E$152)/SUM(D50:D53)","v":20.824530345058232},{"$f":"(E147*$F$158*$E$152)/SUMPRODUCT(E50:E53,E32:E35)","v":39.963979106524356},{"$f":"(F147*$F$158*$E$152)/SUM(F50:F53)","v":0},{"$f":"(G147*$F$158*$E$152)/SUM(G50:G53)","v":0},{"$f":"(H147*$F$158*$E$152)/SUM(H50:H53)","v":36.9312225457113},{"$f":"(I147*$F$158*$E$152)/SUM(I50:I53)","v":0},{"$f":"(J147*$F$158*$E$152)/SUM(J50:J53)","v":0}]
[null,"recovery per winter MWh",{"$f":"(C147*$F$159*$E$153)/SUM(C45:C49,C54:C56)","v":28.940120087058084},{"$f":"(D147*$F$159*$E$153)/SUM(D45:D49,D54:D56)","v":11.942051959984548},{"$f":"(E147*$F$159*$E$153)/(SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38))","v":78.105725605249901},{"$f":"(F147*$F$159*$E$153)/SUM(F45:F49,F54:F56)","v":0},{"$f":"(G147*$F$159*$E$153)/SUM(G45:G49,G54:G56)","v":0},{"$f":"(H147*$F$159*$E$153)/SUM(H45:H49,H54:H56)","v":19.165254184693431},{"$f":"(I147*$F$159*$E$153)/SUM(I45:I49,I54:I56)","v":0},{"$f":"(J147*$F$159*$E$153)/SUM(J45:J49,J54:J56)","v":0}]
[null,null,null,null,"For RLM, per "]
[null,null,null,null,"on-peak kWh only"]
[]
["Table #13","Summary of BGS Unit Costs @ customer"]
[]
[null,"NON-DEMAND RATES"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[null,"in $/MWh"]
[null,null,{"$f":"+C7","v":"RS"},"RHS","RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",{"$f":"+C130+($D$171*C80)+C$178+C181","v":111.78843653545516},{"$f":"+D130+($D$171*D80)+D$178+D181","v":82.143225131515223},null,{"$f":"+F130+($D$171*F80)+F$178+F181","v":45.127942748539716},{"$f":"+G130+($D$171*G80)+G$178+G181","v":45.232837002055589},{"$f":"+H130+($D$171*H80)+H$178+H181","v":102.38091968730558},{"$f":"+I130+($D$171*I80)+I$178+I181","v":41.946076707143675},{"$f":"+J130+($D$171*J80)+J$178+J181","v":41.871991194191637}]
[null,"PSE&G On pk",null,null,{"$f":"+E131+($D$171*E80)+E$178+E181","v":207.71766421138736}]
[null,"PSE&G Off pk",null,null,{"$f":"+E132+($D$171*E80)","v":40.272503868501332}]
[null,"Block 1 (0-600 kWh/m)",{"$f":"(C194*SUM(C50:C53)-C166*10*C164*SUM(C50:C53))/SUM(C50:C53)","v":108.72562853545516},{"$f":"(D194*SUM(D50:D53)-D166*10*D164*SUM(D50:D53))/SUM(D50:D53)","v":78.221334131515235}]
[null,"Block 2 (>600 kWh/m)",{"$f":"+C197+C166*10","v":117.37762853545516},{"$f":"+D197+D166*10","v":89.790334131515237}]
[]
[null,"Winter - all hrs",{"$f":"+C134+($D$171*C80)+C$178+C181","v":117.04478130355187},{"$f":"+D134+($D$171*D80)+D$178+D181","v":88.548031871280116},null,{"$f":"+F134+($D$171*F80)+F$178+F181","v":50.222276510169223},{"$f":"+G134+($D$171*G80)+G$178+G181","v":51.049803017795007},{"$f":"+H134+($D$171*H80)+H$178+H181","v":108.04466970252835},{"$f":"+I134+($D$171*I80)+I$178+I181","v":49.010444121371769},{"$f":"+J134+($D$171*J80)+J$178+J181","v":48.97896665882574}]
[null,"PSE&G On pk",null,null,{"$f":"+E135+($D$171*E80)+E$178+E181","v":211.0047520227543}]
[null,"PSE&G Off pk",null,null,{"$f":"+E136+($D$171*E80)","v":47.64993086671268}]
[]
[null,"Annual -all hrs",{"$f":"+C138+($D$171*C80)+C$178+C181","v":114.78947151220666},{"$f":"+D138+($D$171*D80)+D$178+D181","v":87.116247261627365},{"$f":"((E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))+(E201*(SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56))+E202*(SUMPRODUCT(Q27:Q31,E45:E49)+SUMPRODUCT(Q36:Q38,E54:E56))))/E57","v":119.37561343550728},{"$f":"+F138+($D$171*F80)+F$178+F181","v":48.958668919164516},{"$f":"+G138+($D$171*G80)+G$178+G181","v":49.595561513860154},{"$f":"+H138+($D$171*H80)+H$178+H181","v":106.87403366029892},{"$f":"+I138+($D$171*I80)+I$178+I181","v":47.051341201711764},{"$f":"+J138+($D$171*J80)+J$178+J181","v":47.161547793603845}]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[null,"in $/MWh"]
[null,null,{"$f":"+K7","v":"GLP"},{"$f":"+L7","v":"LPL-S"},null,null,null,"PLUS:",{"$f":"+C209","v":"GLP"},{"$f":"+D209","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"+K130+($D$171*K80)","v":46.1635881366891},{"$f":"+L130+($D$171*L$80)","v":45.780153370617917},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,{"$f":"+L131+($D$171*L$80)","v":51.204984596350428},null,null,null,"summer",{"$f":"+$F158*$E152/$H152/1000","v":5.3109650000000004},{"$f":"+$F158*$E152/$H152/1000","v":5.3109650000000004},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,{"$f":"+L132+($D$171*L$80)","v":40.245109483885443},null,null,null,"winter",{"$f":"+$F159*$E153/$H153/1000","v":5.2891987499999997},{"$f":"+$F159*$E153/$H153/1000","v":5.2891987499999997},"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",{"$f":"($F$158*$E$152+$F$159*$E$153)/$H$154/1000","v":5.296454166666666},{"$f":"($F$158*$E$152+$F$159*$E$153)/$H$154/1000","v":5.296454166666666},"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"+K134+($D$171*K80)","v":50.904419331231821},{"$f":"+L134+($D$171*L$80)","v":50.662326114009844}]
[null,"PSE&G On pk",null,{"$f":"+L135+($D$171*L$80)","v":54.131415093740017},null,null,null,"Trans cost"]
[null,"PSE&G Off pk",null,{"$f":"+L136+($D$171*L$80)","v":47.328588142770073},null,null,null,"all months",{"$f":"+$D155/1000/12","v":9.5534191666666661},{"$f":"+$D155/1000/12","v":9.5534191666666661},"per kW of T obl /month"]
[]
[null,"Annual - all hrs per MWh only",{"$f":"+K138+($D$171*K80)","v":49.18144837871985},{"$f":"+L138+($D$171*L$80)","v":48.93431047981101}]
[]
[null,"Including T&G Obligation $"]
[null,"Summer - all hrs",{"$f":"(C211*W49+((I214*$H152)*K147*1000)+(I217*$H152*K149*1000))/W49","v":90.81980049381518},{"$f":"(D211*X49+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X49","v":77.846227384091776},null,"Note: Obligation $ included in On pk costs"]
[null,"PSE&G On pk",null,{"$f":"(D212*X50+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X50","v":114.69863952059345}]
[null,"PSE&G Off pk",null,{"$f":"+D213","v":40.245109483885443}]
[]
[null,"Winter - all hrs",{"$f":"(C215*W45+((I214*$H153)*K147*1000)+(I217*$H153*K149*1000))/W45","v":101.8950885934769},{"$f":"(D215*X45+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X45","v":85.797340195052342}]
[null,"PSE&G On pk",null,{"$f":"(D216*X46+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X46","v":125.82793796843293}]
[null,"PSE&G Off pk",null,{"$f":"+D217","v":47.328588142770073}]
[]
[null,"Annual - including T&G Obl $",{"$f":"(C219*K57+((I214*$H152+I214*$H153)*K147*1000)+(I217*$H154*K149*1000))/K57","v":97.869971709251033},{"$f":"(D219*L57+((J214*$H152+J214*$H153)*L147*1000)+(J217*$H154*L149*1000))/L57","v":82.983091710048356}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C204:J204,C57:J57)+SUMPRODUCT(C230:D230,K57:L57))/1000","v":2461383.3585602199}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C233/SUM(C57:L57)*1000","v":102.68289447749738},"per MWh at customer (per customer metered MWh)"]
[null,null,"All-In Average costs @ transmission nodes =",{"$f":"+C233/SUMPRODUCT(C57:L57,C85:L85)*1000","v":97.276647515193019},"per MWh at transmission nodes (per metered MWh at transmission node)"]
[]
[]
["Table #14","Ratio of BGS Unit Costs @ customer to All-In Average Cost @ transmission nodes - rounded to 3 decimal places, unit obligation $ rounded to 4 decimal places"]
[]
[null,"NON-DEMAND RATES"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C7","v":"RS"},"RHS","RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(+F194/$D$235,3)","v":0.46400000000000002},{"$f":"ROUND(+G194/$D$235,3)","v":0.46500000000000002},{"$f":"ROUND(+H194/$D$235,3)","v":1.052},{"$f":"ROUND(+I194/$D$235,3)","v":0.43099999999999999},{"$f":"ROUND(+J194/$D$235,3)","v":0.43}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E195/$D$235,3)","v":2.1349999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E196/$D$235,3)","v":0.41399999999999998},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I245*U49+J245*V49)/(U49+V49),3)","v":0.43}]
[]
[null,"All usage Multiplier",{"$f":"ROUND(+C194/$D$235,3)","v":1.149},{"$f":"ROUND(+D194/$D$235,3)","v":0.84399999999999997}]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C197-C194,3)","v":-3.0630000000000002},{"$f":"ROUND(D197-D194,3)","v":-3.9220000000000002},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C198-C194,3)","v":5.5890000000000004},{"$f":"ROUND(D198-D194,3)","v":7.6470000000000002},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C200/$D$235,3)","v":1.2030000000000001},{"$f":"ROUND(+D200/$D$235,3)","v":0.91},null,{"$f":"ROUND(+F200/$D$235,3)","v":0.51600000000000001},{"$f":"ROUND(+G200/$D$235,3)","v":0.52500000000000002},{"$f":"ROUND(+H200/$D$235,3)","v":1.111},{"$f":"ROUND(+I200/$D$235,3)","v":0.504},{"$f":"ROUND(+J200/$D$235,3)","v":0.504}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E201/$D$235,3)","v":2.169},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E202/$D$235,3)","v":0.49},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I255*U45+J255*V45)/(U45+V45),3)","v":0.504}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C204/$D$235,3)","v":1.18},{"$f":"ROUND(+D204/$D$235,3)","v":0.89600000000000002},1.2270000000000001,0.503,0.51,1.099,0.48399999999999999,0.48499999999999999]
[]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+K7","v":"GLP"},{"$f":"+C265","v":"GLP"},{"$f":"+L7","v":"LPL-S"},{"$f":"+E265","v":"LPL-S"},null,"PLUS:"]
[null,null,"Multiplier","Constant (in $/MWh)","Multiplier","Constant (in $/MWh)"]
[null,"Summer - all hrs",{"$f":"ROUND(+C222/$D$235,3)","v":0.93400000000000005},{"$f":"ROUND(+C211-C222,3)","v":-44.655999999999999},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D223/$D$235,3)","v":1.179},{"$f":"ROUND(+D212-D223,3)","v":-63.494},null,"summer",{"$f":"ROUND(+I212,4)","v":5.3109999999999999},5.3109999999999999,"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D224/$D$235,3)","v":0.41399999999999998},{"$f":"ROUND(+D213-D224,3)","v":0},null,"winter",5.2892000000000001,5.2892000000000001,"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",5.2965,5.2965,"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"ROUND(+C226/$D$235,3)","v":1.0469999999999999},{"$f":"ROUND(+C215-C226,3)","v":-50.991}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D227/$D$235,3)","v":1.294},{"$f":"ROUND(+D216-D227,3)","v":-71.697000000000003},null,"Trans cost"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D228/$D$235,3)","v":0.48699999999999999},{"$f":"ROUND(+D217-D228,3)","v":0},null,"all months",{"$f":"ROUND(+I217,4)","v":9.5533999999999999},{"$f":"ROUND(+J217,4)","v":9.5533999999999999},"per kW of T obl /month"]
[]
[null,"Annual - including T&G Obl $",{"$f":"ROUND(+C230/$D$235,3)","v":1.006},null,{"$f":"ROUND(+D230/$D$235,3)","v":0.85299999999999998}]
[]
[]
[]
["Assumptions:"]
[null,"Gen Cost =",{"$f":"+F158","v":174.13},"/MW day ","summer"]
[null,null,{"$f":"+F159","v":174.13},"/MW day ","winter"]
[]
[null,"Trans cost =",{"$f":"+D155","v":114641.03},"per MW-yr"]
[null,"Analysis time period =",{"$f":"+H152","v":4},"summer months"]
[null,null,{"$f":"+H153","v":8},"winter months"]
[null,"Ancillary Services & RPS =",{"$f":"+D171","v":18.72},"per MWh"]
[null,"Energy Costs ="," based on Forwards @ PJM West - corrected for congestion"]
[null,"Usage patterns ="," forecasted 2019 energy use by class, PJM and PSE&G on/off % from 2016, 2017 & 2018 class load profiles"]
[]
[null,"Obligations ="," class totals in effect as of filing date"]
[null,"Losses ="," Delivery losses from tariff, PJM losses based on 3 year average %"]
[null,"PJM Time Periods ="," PJM trading time periods - 7 AM to 11 PM weekdays, local time, x NERC "]
[null,null,"     holidays - New Year's, Memorial, 4th of July, Labor Day, Thanksgiving & Christmas"]
[null,"PSE&G Billing time periods ="," as per specific rate schedule"]
[null,"NJ SUT (Sales & Use Tax) =","SUT excluded from all rates"]
[]
[]
["Table #15","Summary of Total BGS Costs by Season"]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,"Total Costs by Rate - in $1000"]
[null,"Summer",{"$f":"(+C197*SUM(C50:C53)*C163+C198*SUM(C50:C53)*C164)/1000","v":583059.00730932411},{"$f":"(+D197*SUM(D50:D53)*D163+D198*SUM(D50:D53)*D164)/1000","v":1843.5403442960699},{"$f":"(E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))/1000","v":10191.410434654052},{"$f":"+F194*SUM(F50:F53)/1000","v":8.5743091222225463},{"$f":"+G194*SUM(G50:G53)/1000","v":0.18093134800822236},{"$f":"+H194*SUM(H50:H53)/1000","v":241.45857287683623},{"$f":"+I194*SUM(I50:I53)/1000","v":1720.5022282969121},{"$f":"+J194*SUM(J50:J53)/1000","v":3201.1137267959502},{"$f":"(C211*SUM(K50:K53)/1000)+(I212*$H152*K147)+(I217*$H152*K149)","v":209384.5019288797},{"$f":"(D211*SUM(L50:L53)/1000)+(J212*$H152*L147)+(J217*$H152*L149)","v":130523.62949996069}]
[null,"Winter",{"$f":"+C200*SUM(C45:C49,C54:C56)/1000","v":812330.07583592122},{"$f":"+D200*SUM(D45:D49,D54:D56)/1000","v":6902.4379416691791},{"$f":"(E201*(SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56))+E202*(SUMPRODUCT(Q27:Q31,E45:E49)+SUMPRODUCT(Q36:Q38,E54:E56)))/1000","v":11313.361703042008},{"$f":"+F200*SUM(F45:F49,F54:F56)/1000","v":28.92803126985747},{"$f":"+G200*SUM(G45:G49,G54:G56)/1000","v":0.61259763621354013},{"$f":"+H200*SUM(H45:H49,H54:H56)/1000","v":978.03071260233742},{"$f":"+I200*SUM(I45:I49,I54:I56)/1000","v":5238.5793408010641},{"$f":"+J200*SUM(J45:J49,J54:J56)/1000","v":10898.113955388681},{"$f":"(C215*SUM(K45:K49,K54:K56)/1000)+(I213*$H153*K147)+(I217*$H153*K149)","v":411122.63329017605},{"$f":"(D215*SUM(L45:L49,L54:L56)/1000)+(J213*$H153*L147)+(J217*$H153*L149)","v":262396.66586615838}]
[null,"Total",{"$f":"+C303+C302","v":1395389.0831452454},{"$f":"+D303+D302","v":8745.9782859652496},21504.772137696062,37.502340392080015,0.79352898422176255,1219.4892854791738,6959.0815690979762,14099.227682184632,{"$f":"+K303+K302","v":620507.13521905569},{"$f":"+L303+L302","v":392920.29536611907}]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C302/C304","v":0.41784690331322721},{"$f":"+D302/D304","v":0.21078720801930365},0.47391390010542656,0.22863397410880854,0.22800849320666858,0.19799974936389864,0.24723122027148772,{"$f":"+J302/J304","v":0.22704177838342046},{"$f":"+K302/K304","v":0.33744092540525156},{"$f":"+L302/L304","v":0.33218856607633396}]
[null,"Winter",{"$f":"+C303/C304","v":0.58215309668677273},{"$f":"+D303/D304","v":0.78921279198069627},0.52608609989457333,0.77136602589119152,0.77199150679333139,0.80200025063610125,0.75276877972851231,{"$f":"+J303/J304","v":0.77295822161657946},{"$f":"+K303/K304","v":0.6625590745947485},{"$f":"+L303/L304","v":0.66781143392366604}]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C302:L302)","v":940173.91928555467}]
[null,"Winter",{"$f":"+SUM(C303:L303)","v":1521209.439274665}]
[null,"Total",{"$f":"+C312+C311","v":2461383.3585602194}]
[null,null,null,null,null,null,null,null,null,null,null,"rounded to 4 decimal places"]
[null,"% of Annual Total $",null,"         If total $ were split on a per MWh basis (on transmission node MWhs):",null,null,null,null,null,null," "]
[null,"Summer",{"$f":"+C311/C313","v":0.38196972284541131},null,{"$f":"+C311/SUMPRODUCT(O49:X49,C85:L85)*1000","v":94.523957985822378},"per MWh @ trans nodes",null,null,"Ratio to All-In Cost >>>",null,"Summer",{"$f":"IF(ROUND(E316/$D$235,4)<ROUND(E317/$D$235,4),1,ROUND(E316/$D$235,4))","v":1}]
[null,"Winter",{"$f":"+C312/C313","v":0.6180302771545888},null,{"$f":"+C312/SUMPRODUCT(O45:X45,C85:L85)*1000","v":99.059563715985774},"per MWh @ trans nodes",null,null,null,null,"Winter",{"$f":"IF(ROUND(E316/$D$235,4)<ROUND(E317/$D$235,4),1,ROUND(E317/$D$235,4))","v":1}]
[]
[]
["Table #16","Spreadsheet Error Checking - Reconciliation of Customer Revenue and Supplier Payments, based on above data only"]
[]
[null,"Assumed Winning Bid Price =",{"$f":"D235","v":97.276647515193019},null,"(bid includes payments for all losses)"]
[null,"Payment Ratio - Summer =",{"$f":"+L316","v":1}]
[null,"Payment Ratio - Winter =",{"$f":"+L317","v":1}]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,"Total Rate Revenue - in $1000"]
[null,"Summer",{"$f":"+($C$322*C249*O49+C250*O53+C251*O54)/1000","v":582966.37301338802},{"$f":"+($C$322*D249*P49+D250*P53+D251*P54)/1000","v":1842.601247766532},{"$f":"(($C$322*E246*Q50)+(C322*E247*Q51))/1000","v":10190.11289494107},{"$f":"+$C$322*F245*R49/1000","v":8.5759092449394174},{"$f":"+$C$322*G245*S49/1000","v":0.180934564378259},{"$f":"+$C$322*H245*T49/1000","v":241.35035262293067},{"$f":"+$C$322*K247*U49/1000","v":1715.6983879861889},{"$f":"+$C$322*K247*V49/1000","v":3197.8238720906979},{"$f":"+($C$322*C267+D267)*W49/1000+(I268*H152*K147)+(I273*H152*K149)","v":209469.46023551701},{"$f":"(($C$322*E268+F268)*X50+(C322*E269*X51))/1000+(J268*$H$152*L147)+(J273*$H$152*L149)","v":130538.15140970099}]
[null,"Winter",{"$f":"+$C$322*C255*O45/1000","v":812184.50685568142},{"$f":"+$C$322*D255*P45/1000","v":6900.3891751903902},{"$f":"(($C$322*E256*Q46)+(C322*E257*Q47))/1000","v":11313.727763927727},{"$f":"+$C$322*F255*R45/1000","v":28.912176067875606},{"$f":"+$C$322*G255*S45/1000","v":0.61284287934571602},{"$f":"+$C$322*H255*T45/1000","v":978.29943028683772},{"$f":"+$C$322*K257*U45/1000","v":5240.3949475700438},{"$f":"+$C$322*K257*V45/1000","v":10908.897416935832},{"$f":"+($C$322*C271+D271)*W45/1000+(I269*H153*K147)+(I273*H153*K149)","v":410933.65506618284},{"$f":"(($C$322*E272+F272)*X46+C322*E273*X47)/1000+(J269*$H$153*L147)+(J273*$H$153*L149)","v":262538.27142579487}]
[null,"Total",{"$f":"+C329+C328","v":1395150.8798690694},{"$f":"+D329+D328","v":8742.990422956922},21503.840658868798,37.488085312815024,0.79377744372397507,1219.6497829097684,6956.0933355562329,14106.721289026529,620403.11530169984,393076.42283549585]
[]
[null,"Total Summer",{"$f":"SUM(C328:L328)","v":940170.32825782266}]
[null,"Total Winter",{"$f":"SUM(C329:L329)","v":1521027.6671005171}]
[null,"Grand Total",{"$f":"+C333+C332","v":2461197.9953583395}]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+$C$322*$C$323*O49*C85/1000","v":535566.90098898648},2304.5121290926195,8668.9132528453629,19.509749950724505,0.4107315779099896,242.17076028545878,4211.7442827835112,7850.1072828046763,236602.25708357309,172086.76814242511]
[null,"Winter",{"$f":"+$C$322*$C$324*O45*C85/1000","v":712653.75977447443},8004.2694549349135,9828.769687821874,59.145347219038491,1.2321947337299686,929.49540902291551,10975.466542016264,22847.560118610036,414419.37473539158,314110.99089167005]
[null,"Total",{"$f":"+C339+C338","v":1248220.6607634609},10308.781584027533,18497.682940667237,78.655097169762996,1.6429263116399582,1171.6661693083743,15187.210824799775,30697.667401414714,651021.63181896461,486197.75903409516]
[]
[null,"Total Summer",{"$f":"SUM(C338:L338)","v":967553.29440432496}]
[null,"Total Winter",{"$f":"SUM(C339:L339)","v":1493830.0641558948}]
[null,"Grand Total",{"$f":"+C343+C342","v":2461383.3585602199}]
[]
[null,"Difference ( in $1000) =",{"$f":"+C334-C344","v":-185.36320188036188}]
[null,null,"Note: Minor differences in totals are due to rounding of Bid Factors and Payment Factors"]
[]
[]
["Table #17","Total Supplier Energy","@ transmission nodes"]
[null,"in MWh"]
[null,"Summer",{"$f":"SUMPRODUCT(O49:X49,C85:L85)","v":9946408.7128743716}]
[null,"Winter",{"$f":"SUMPRODUCT(O45:X45,C85:L85)","v":15356512.609283572}]
[null,"Total",{"$f":"+C353+C352","v":25302921.322157942}]

{"sheet":"auction_results_and_rates","index":2,"n_rows":210,"n_cols":12,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of June 2020 to May 2021 BGS-RSCP Rates"]
[null,"Illustrative Purposes Only"]
[null,"NJ Sales & Use Tax (SUT) excluded"]
[]
["Table A","Auction Results"]
["line #","Specific BGS-FP Auction >>",{"$f":"Input!C135","v":"remaining portion of 36 month bid - 2018 auction"},{"$f":"Input!D135","v":"remaining portion of 36 month bid - 2019 auction"},{"$f":"Input!E135","v":"36 month bid - 2020 auction"},null,"Notes:"]
[]
[1,"Winning Bid - in $/MWh",{"$f":"Input!C136","v":91.77},{"$f":"Input!D136","v":98.04},{"$f":"ROUND(IF(Input!E138=\"yes\",Input!$E$136,IF(LEFT(Input!B2,6)=\"Rebase\",Input!E136,(bid_factors!D235*(1+#REF!)*SUM(C20:C21)/1000-SUM(C26:D26))/(E$13/E$14/1000*(E16*$C20+E17*$C21)))),2)","v":98.04},null,{"$f":"\"Winning Bid\"","v":"Winning Bid"}]
["1A","Capacity Proxy Price True-up - in $/MWh",null,null,0,null,"Entered after 2022 BGS Auction"]
[null,"Total - in $/MWh",{"$f":"+C8+C9","v":91.77},{"$f":"+D8+D9","v":98.04},{"$f":"+E8+E9","v":98.04},null,"= line 1 + line 1A"]
[]
[null,"      (includes all payments, including impact of PJM marginal losses)"]
[2,"# of Tranches for Bid",{"$f":"Input!C137","v":29},{"$f":"Input!D137","v":28},{"$f":"Input!E137","v":28},null,"from then current Bid"]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid"]
[null,"Payment Factors"]
[4,"                           Summer",{"$f":"Input!C140","v":1},{"$f":"Input!D140","v":1},{"$f":"IF(LEFT(Input!$B$2,6)=\"rebase\",Input!E140,bid_factors!L316)","v":1}]
[5,"                           Winter",{"$f":"Input!C141","v":1},{"$f":"Input!D141","v":1},{"$f":"IF(LEFT(Input!$B$2,6)=\"rebase\",Input!E141,bid_factors!L317)","v":1}]
[]
[null,"Applicable Customer Usage @ transmission nodes - in MWh"]
[6,"                           Summer MWh",{"$f":"+bid_factors!C352","v":9946408.7128743716},null,null,null,"from Table #17 of the current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"+bid_factors!C353","v":15356512.609283572}]
[]
[null,"Total Payment to Suppliers - in $1000 "]
[8,"                           Summer",{"$f":"+C$8*C$13/C$14*C16*$C20/1000+C$9*C$13/C$14*$C20/1000","v":311419.71646863472},{"$f":"+D$8*D$13/D$14*D16*$C20/1000+D$9*D$13/D$14*$C20/1000","v":321224.53512806707},321224.53512806707,null,"= (1) * (2)/(3) * (4) * (6) + (1A) * (2)/(3) * (6)"]
[9,"                           Winter",{"$f":"+C$8*C$13/C$14*C17*$C21/1000+C$9*C$13/C$14*$C21/1000","v":480808.7964995841},{"$f":"+D$8*D$13/D$14*D17*$C21/1000+D$9*D$13/D$14*$C21/1000","v":495946.70463525323},495946.70463525323,null,"= (1) * (2)/(3) * (5) * (7) + (1A) * (2)/(3) * (7)"]
[10,"                           Total",{"$f":"+C25+C24","v":792228.51296821889},{"$f":"+D25+D24","v":817171.23976332031},{"$f":"+E25+E24","v":817171.23976332031},null,"Note: $ reflect total payment"]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C24:E24)/C20*1000,3)","v":95.900999999999996},null,null,null,"= sum(line 8) / (6) - rounded to 3 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":95.900999999999996},null,null,null,"= sum(line 9) / (7) - rounded to 3 decimal places"]
[]
[13,"                Total weighted average",{"$f":"ROUND(+SUM(C26:E26)/(C20+C21)*1000,3)","v":95.900999999999996},"   <<< used in calculation of",null,null,"= sum(line 10) / [ (6) + (7)]"]
[null,null,null,"           Customer Rates",null,null,"   rounded to 3 decimal places"]
[]
[null,"Reconciliation of amounts - in $1000"]
[14,"Weighted Average * Total MWh =",{"$f":"(C32*(C21+C20))/1000","v":2426575.4577162685},null,null,null,"= (13) * [(6)+(7)] / 1000"]
[15,"Total Payment to Suppliers =",{"$f":"SUM(C26:E26)","v":2426570.9924948597},null,null,null,"= sum (line 10)"]
[16,"Difference =",{"$f":"+C36-C37","v":4.4652214087545872},null,null,null,"= line (14) - line (15)"]
[]
[]
["Table B","Ratio of BGS Unit Costs @ customer to All-In Average Cost @ transmission nodes",null,null,null,null,"from Table #14 of the bid factor spreadsheet ---"]
[null,null,null,null,null,null,"rounded to 3 decimal places, unit obligation $ rounded to 4 decimal places"]
[null,"NON-DEMAND RATES"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"+bid_factors!C243","v":"RS"},{"$f":"+bid_factors!D243","v":"RHS"},{"$f":"+bid_factors!E243","v":"RLM"},{"$f":"+bid_factors!F243","v":"WH"},{"$f":"+bid_factors!G243","v":"WHS"},{"$f":"+bid_factors!H243","v":"HS"},{"$f":"+bid_factors!I243","v":"PSAL"},{"$f":"+bid_factors!J243","v":"BPL"}]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"+bid_factors!F245","v":0.46400000000000002},{"$f":"+bid_factors!G245","v":0.46500000000000002},{"$f":"+bid_factors!H245","v":1.052},{"$f":"+bid_factors!I245","v":0.43099999999999999},{"$f":"+bid_factors!J245","v":0.43}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E246","v":2.1349999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E247","v":0.41399999999999998},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K247","v":0.43}]
[]
[null,"All usage Multiplier",{"$f":"+bid_factors!C249","v":1.149},{"$f":"+bid_factors!D249","v":0.84399999999999997}]
[null,"Constant (in $/MWh)",{"$f":"+bid_factors!C250","v":-3.0630000000000002},{"$f":"+bid_factors!D250","v":-3.9220000000000002},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"+bid_factors!C251","v":5.5890000000000004},{"$f":"+bid_factors!D251","v":7.6470000000000002},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"+bid_factors!C255","v":1.2030000000000001},{"$f":"+bid_factors!D255","v":0.91},null,{"$f":"+bid_factors!F255","v":0.51600000000000001},{"$f":"+bid_factors!G255","v":0.52500000000000002},{"$f":"+bid_factors!H255","v":1.111},{"$f":"+bid_factors!I255","v":0.504},{"$f":"+bid_factors!J255","v":0.504}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E256","v":2.169},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E257","v":0.49},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K257","v":0.504}]
[]
[null,"Annual - all hrs",{"$f":"+bid_factors!C259","v":1.18},{"$f":"+bid_factors!D259","v":0.89600000000000002},{"$f":"+bid_factors!E259","v":1.2270000000000001},{"$f":"+bid_factors!F259","v":0.503},{"$f":"+bid_factors!G259","v":0.51},{"$f":"+bid_factors!H259","v":1.099},{"$f":"+bid_factors!I259","v":0.48399999999999999},{"$f":"+bid_factors!J259","v":0.48499999999999999}]
[]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+bid_factors!C265","v":"GLP"},{"$f":"+bid_factors!D265","v":"GLP"},{"$f":"+bid_factors!E265","v":"LPL-S"},{"$f":"+bid_factors!F265","v":"LPL-S"},null,"PLUS:",{"$f":"+C68","v":"GLP"},{"$f":"+E68","v":"LPL-S"}]
[null,null,"Multiplier","Constant (in $/MWh)","Multiplier","Constant (in $/MWh)"]
[null,"Summer - all hrs",{"$f":"+bid_factors!C267","v":0.93400000000000005},{"$f":"+bid_factors!D267","v":-44.655999999999999},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E268","v":1.179},{"$f":"+bid_factors!F268","v":-63.494},null,"summer",{"$f":"+bid_factors!I$270","v":5.2965},{"$f":"+bid_factors!J$270","v":5.2965},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E269","v":0.41399999999999998},{"$f":"+bid_factors!F269","v":0},null,"winter",{"$f":"+bid_factors!I$270","v":5.2965},{"$f":"+bid_factors!J$270","v":5.2965},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"+bid_factors!C271","v":1.0469999999999999},{"$f":"+bid_factors!D271","v":-50.991},null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E272","v":1.294},{"$f":"+bid_factors!F272","v":-71.697000000000003},null,"all months",{"$f":"+bid_factors!I273","v":9.5533999999999999},{"$f":"+bid_factors!J273","v":9.5533999999999999},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E273","v":0.48699999999999999},{"$f":"+bid_factors!F273","v":0}]
[]
[null,"Annual - including T&G Obl $",{"$f":"+bid_factors!C275","v":1.006},null,{"$f":"+bid_factors!E275","v":0.85299999999999998}]
[]
[]
["Table C","Preliminary Resulting BGS Rates (in cents per kWh) - equal to bid factors times weighted average bid price"]
[null,"   rounded to 4 decimal places"]
[]
[null,"NON-DEMAND RATES -----------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C46","v":"RS"},{"$f":"+D46","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(($C$32*F48)/10,4)","v":4.4497999999999998},{"$f":"ROUND(($C$32*G48)/10,4)","v":4.4593999999999996},{"$f":"ROUND(($C$32*H48)/10,4)","v":10.088800000000001},{"$f":"ROUND(($C$32*K50)/10,4)","v":4.1237000000000004},{"$f":"+I89","v":4.1237000000000004}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E49)/10,4)","v":20.474900000000002}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E50/10),4)","v":3.9702999999999999}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C53)/10,4)","v":10.7127},{"$f":"ROUND((+$C$32*D52+D53)/10,4)","v":7.7018000000000004}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C54)/10,4)","v":11.5779},{"$f":"ROUND((+$C$32*D52+D54)/10,4)","v":8.8587000000000007}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C58)/10,4)","v":11.536899999999999},{"$f":"ROUND(($C$32*D58)/10,4)","v":8.7270000000000003},null,{"$f":"ROUND(($C$32*F58)/10,4)","v":4.9485000000000001},{"$f":"ROUND(($C$32*G58)/10,4)","v":5.0347999999999997},{"$f":"ROUND(($C$32*H58)/10,4)","v":10.6546},{"$f":"ROUND(($C$32*K60)/10,4)","v":4.8334000000000001},{"$f":"+I96","v":4.8334000000000001}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E59)/10,4)","v":20.800899999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E60)/10,4)","v":4.6990999999999996}]
[]
[]
[]
[null,"DEMAND RATES --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C68","v":"GLP"},null,{"$f":"+E68","v":"LPL-S"},null,null,"PLUS:",{"$f":"+C105","v":"GLP"},{"$f":"+E105","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(($C$32*C70+D70)/10,4)","v":4.4916},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E71+F71)/10,4)","v":4.9573},null,null,"summer",{"$f":"+I71","v":5.2965},{"$f":"+J71","v":5.2965},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E72+F72)/10,4)","v":3.9702999999999999},null,null,"winter",{"$f":"+I72","v":5.2965},{"$f":"+J72","v":5.2965},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C74+D74)/10,4)","v":4.9417},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E75+F75)/10,4)","v":5.2398999999999996},null,null,"all months",{"$f":"+I75","v":9.5533999999999999},{"$f":"+J75","v":9.5533999999999999},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E76+F76)/10,4)","v":4.6703999999999999}]
[]
[]
[]
["Table D","Revenue Recovery Calculations - Reconciliation of seasonal Customer Revenue and Supplier Payments, based on actual anticipated revenues and payments"]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL"]
[null,"Total Preliminary Rate Revenue - in $1000"]
[null,"Summer",{"$f":"+C93/100*bid_factors!O53+auction_results_and_rates!C94/100*bid_factors!O54","v":574720.98241313361},{"$f":"+D93/100*bid_factors!P53+auction_results_and_rates!D94/100*bid_factors!P54","v":1816.533917222321},{"$f":"+E90/100*bid_factors!Q50+E91/100*bid_factors!Q51","v":10046.022576386478},{"$f":"+F89/100*bid_factors!R49","v":8.4546199999999985},{"$f":"+G89/100*bid_factors!S49","v":0.17837599999999998},{"$f":"+H89/100*bid_factors!T49","v":237.93762133413162},{"$f":"+I89/100*bid_factors!U49","v":1691.4180290000002},{"$f":"+J89/100*bid_factors!V49","v":3152.5686500000002}]
[null,"Winter",{"$f":"+C96/100*bid_factors!O45","v":800699.59100577526},{"$f":"+D96/100*bid_factors!P45","v":6802.8136418111098},{"$f":"+E97/100*bid_factors!Q46+auction_results_and_rates!E98/100*bid_factors!Q47","v":11153.695774948827},{"$f":"+F96/100*bid_factors!R45","v":28.503360000000001},{"$f":"+G96/100*bid_factors!S45","v":0.60417599999999994},{"$f":"+H96/100*bid_factors!T45","v":964.46461071915462},{"$f":"+I96/100*bid_factors!U45","v":5166.2762579999999},{"$f":"+J96/100*bid_factors!V45","v":10754.605004000001}]
[null,"Total",{"$f":"+C122+C121","v":1375420.5734189088},{"$f":"+D122+D121","v":8619.347559033431},21199.718351335305,36.957979999999999,0.78255199999999991,1202.4022320532863,6857.6942870000003,13907.173654000002]
[]
[]
[null,null,"GLP","GLP",null,"LPL-S","LPL-S"]
[null,null,"Energy $","Obligation $",null,"Energy $","Obligation $"]
[]
[null,"Summer",{"$f":"+C107/100*bid_factors!W49","v":103495.59226239662},{"$f":"I108*bid_factors!K147*4+auction_results_and_rates!I112*bid_factors!K149*4","v":102897.2384},null,{"$f":"+E108/100*bid_factors!X50+auction_results_and_rates!E109/100*bid_factors!X51","v":74892.213036410161},{"$f":"auction_results_and_rates!J108*bid_factors!L147*4+auction_results_and_rates!J112*bid_factors!L149*4","v":53739.819799999997}]
[null,"Winter",{"$f":"+C111/100*bid_factors!W45","v":199442.78300205909},{"$f":"auction_results_and_rates!I109*bid_factors!K147*8+auction_results_and_rates!I112*bid_factors!K149*8","v":205794.4768},null,{"$f":"+E112/100*bid_factors!X46+auction_results_and_rates!E113/100*bid_factors!X47","v":151406.66793646902},{"$f":"auction_results_and_rates!J109*bid_factors!L147*8+auction_results_and_rates!J112*bid_factors!L149*8","v":107479.63959999999}]
[null,"Total",{"$f":"+C130+C129","v":302938.37526445568},{"$f":"+D130+D129","v":308691.71519999998},null,{"$f":"+F130+F129","v":226298.88097287918},{"$f":"+G130+G129","v":161219.45939999999}]
[]
[]
[null,null,"Energy $","Obligation $","Total $"]
[null,"Total Summer",{"$f":"SUM(C121:J121)+C129+F129","v":770061.90150188329},{"$f":"+D129+G129","v":156637.0582},{"$f":"+C135+D135","v":926698.95970188326}]
[null,"Total Winter",{"$f":"SUM(C122:J122)+C130+F130","v":1186420.0047697825},{"$f":"+D130+G130","v":313274.1164},{"$f":"+C136+D136","v":1499694.1211697825}]
[null,"Grand Total",{"$f":"+C136+C135","v":1956481.9062716658},{"$f":"+D131+G131","v":469911.17459999997},{"$f":"+C137+D137","v":2426393.0808716659}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":953868.78672476881}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1472702.2057700905}]
[null,"Total",{"$f":"+C142+C141","v":2426570.9924948593},null,"kWh Rate"]
[null,null,null,null,"Adjustment","   rounded to 5 decimal places"]
[null,"Differences - in $1000",null,null,"Factors"]
[null,"Summer",{"$f":"+C141-E135","v":27169.827022885554},null,{"$f":"ROUND(1+(C146/C135),5)","v":1.03528}]
[null,"Winter",{"$f":"+C142-E136","v":-26991.915399692021},null,{"$f":"ROUND(1+(C147/C136),5)","v":0.97724999999999995}]
[null,"Total",{"$f":"+C143-E137","v":177.91162319341674}]
[]
[null,null,"Note: These differences are due to rounding and seasonal differences in Bidder Payments (which are based on prior "]
[null,null,"          wining bids and Seasonal Payment Factors) and current Rates (based on current seasonal market differentials)"]
[]
["Table E","Final Resulting BGS Rates from Auctions (in cents per kWh) - with preliminary kWh rates adjusted by the kWh Rate Adjustment Factor"]
[null,"   rounded to 4 decimal places"]
[]
[null,"NON-DEMAND RATES -----------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods & adjustment to energy price"]
[]
[null,null,{"$f":"+C119","v":"RS"},{"$f":"+D119","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(+F89*$E$146,4)","v":4.6067999999999998},{"$f":"ROUND(+G89*$E$146,4)","v":4.6166999999999998},{"$f":"ROUND(+H89*$E$146,4)","v":10.444699999999999},{"$f":"ROUND(+I89*$E$146,4)","v":4.2691999999999997},{"$f":"ROUND(+J89*$E$146,4)","v":4.2691999999999997}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E90*$E$146,4)","v":21.197299999999998}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E91*$E$146,4)","v":4.1104000000000003}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C93*$E$146,4)","v":11.0906},{"$f":"ROUND(+D93*$E$146,4)","v":7.9734999999999996}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C94*$E$146,4)","v":11.9864},{"$f":"ROUND(+D94*$E$146,4)","v":9.1712000000000007}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C96*$E$147,4)","v":11.2744},{"$f":"ROUND(+D96*$E$147,4)","v":8.5284999999999993},null,{"$f":"ROUND(+F96*$E$147,4)","v":4.8358999999999996},{"$f":"ROUND(+G96*$E$147,4)","v":4.9203000000000001},{"$f":"ROUND(+H96*$E$147,4)","v":10.4122},{"$f":"ROUND(+I96*$E$147,4)","v":4.7233999999999998},{"$f":"ROUND(+J96*$E$147,4)","v":4.7233999999999998}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E97*$E$147,4)","v":20.3277}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E98*$E$147,4)","v":4.5922000000000001}]
[]
[]
[]
[null,"DEMAND RATES --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods & adjustment to energy price"]
[]
[null,null,{"$f":"+C105","v":"GLP"},null,{"$f":"+E105","v":"LPL-S"},null,null,"PLUS:",{"$f":"+C177","v":"GLP"},{"$f":"+E177","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(+C107*$E$146,4)","v":4.6501000000000001},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E108*$E$146,4)","v":5.1322000000000001},null,null,"summer",{"$f":"+I108","v":5.2965},{"$f":"+J108","v":5.2965}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E109*$E$146,4)","v":4.1104000000000003},null,null,"winter",{"$f":"+I109","v":5.2965},{"$f":"+J109","v":5.2965}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C111*$E$147,4)","v":4.8292999999999999},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E112*$E$147,4)","v":5.1207000000000003},null,null,"all months",{"$f":"+I112","v":9.5533999999999999},{"$f":"+J112","v":9.5533999999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E113*$E$147,4)","v":4.5640999999999998}]
[]
[]
[]
["Table F","Spreadsheet Error Checking - Checking of seasonal Customer Revenue and Supplier Payments, based on final actual anticipated revenues and payments"]
[]
[null,null,"RS","RHS","RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S"]
[null,"Total Rate Revenue - in $1000"]
[null,"Summer",{"$f":"+C165/100*bid_factors!O53+auction_results_and_rates!C166/100*bid_factors!O54","v":594996.23934286833},{"$f":"+D165/100*bid_factors!P53+auction_results_and_rates!D166/100*bid_factors!P54","v":1880.6156824455024},{"$f":"+E162/100*bid_factors!Q50+E163/100*bid_factors!Q51","v":10400.476920138555},{"$f":"+F161/100*bid_factors!R49","v":8.7529199999999996},{"$f":"+G161/100*bid_factors!S49","v":0.184668},{"$f":"+H161/100*bid_factors!T49","v":246.3312855392717},{"$f":"+I161/100*bid_factors!U49","v":1751.0977639999996},{"$f":"+J161/100*bid_factors!V49","v":3263.8033999999993},{"$f":"+C179/100*bid_factors!W49+I180*bid_factors!K147*4+auction_results_and_rates!I184*bid_factors!K149*4","v":210044.99278137204},{"$f":"+E180/100*bid_factors!X50+auction_results_and_rates!E181/100*bid_factors!X51+auction_results_and_rates!J180*bid_factors!L147*4+auction_results_and_rates!J184*bid_factors!L149*4","v":131274.51549550967}]
[null,"Winter",{"$f":"+C168/100*bid_factors!O45","v":782481.2097561314},{"$f":"+D168/100*bid_factors!P45","v":6648.0802273617564},{"$f":"+E169/100*bid_factors!Q46+auction_results_and_rates!E170/100*bid_factors!Q47","v":10899.960120369573},{"$f":"+F168/100*bid_factors!R45","v":27.854783999999999},{"$f":"+G168/100*bid_factors!S45","v":0.59043600000000007},{"$f":"+H168/100*bid_factors!T45","v":942.52233023576503},{"$f":"+I168/100*bid_factors!U45","v":5048.7005579999995},{"$f":"+J168/100*bid_factors!V45","v":10509.848404},{"$f":"+C183/100*bid_factors!W45+auction_results_and_rates!I181*bid_factors!K147*8+auction_results_and_rates!I184*bid_factors!K149*8","v":400700.89199150173},{"$f":"+E184/100*bid_factors!X46+auction_results_and_rates!E185/100*bid_factors!X47+auction_results_and_rates!J181*bid_factors!L147*8+auction_results_and_rates!J184*bid_factors!L149*8","v":255441.16662900717}]
[null,"Total",{"$f":"+C194+C193","v":1377477.4490989996},8528.6959098072584,21300.437040508128,36.607703999999998,0.77510400000000002,1188.8536157750368,6799.7983219999987,13773.651803999999,610745.88477287372,386715.68212451681]
[]
[null,"Total Summer",{"$f":"SUM(C193:L193)","v":953867.01025987323}]
[null,"Total Winter",{"$f":"SUM(C194:L194)","v":1472700.8252366073}]
[null,"Grand Total",{"$f":"+C198+C197","v":2426567.8354964806}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":953868.78672476881}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1472702.2057700905}]
[null,"Total",{"$f":"+C204+C203","v":2426570.9924948593}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C197-C203","v":-1.7764648955781013},null,{"$f":"+C208/C197","v":-1.8623821523024662E-6}]
[null,"Winter",{"$f":"+C198-C204","v":-1.3805334831122309},null,{"$f":"+C209/C198","v":-9.3741611293687658E-7}]
[null,"Total",{"$f":"+C199-C205","v":-3.1569983786903322},null,{"$f":"+C210/C199","v":-1.3010138569006476E-6}]