{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input","bid_factors","auction_results_and_rates","4-1","4-2","4-3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":82,"comments":1,"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",1103241.022415668,17093.914011082521,15933.365083598062,94,2,2155.4355758420347,16719,31492,561707.37419042538,673444.31552568509]
[null,"February",884939.96852743544,14489.694391091827,12532.010134556667,88,2,2053.8124246830798,13249,27940,500731.3468146454,590922.97041974543]
[null,"March",900474.20353809127,12286.799954384289,13347.076973522584,165,2,1461.1530389325362,13900,27825,543590.67091787583,651708.51313821413]
[null,"April",737564.85956618492,7198.4653312978608,11110.647962745927,70,2,882.15727014454114,11672,25198,482431.38921796548,573824.65227280988]
[null,"May",808596.18360793928,5010.2177990897071,13150.698296531966,104,2,405.63862857566022,10104,19612,489186.32439443091,615626.36465384217]
[null,"June",1213518.8158535871,6546.1898509252387,20680.771935118843,74,1,649.02180572105635,9635,18056,569919.30450896779,671202.5330866623]
[null,"July",1621529.3461963243,7259.9823301952783,26953.450064236666,59,1,690.01265660870206,9762,19121,639726.05371033144,734766.58567628451]
[null,"August",1506520.1271832155,6941.6562724086398,24935.325505066085,63,1,690.86663266886137,10865,17559,646706.15339267894,750385.42029583885]
[null,"September",1036720.697910864,5424.2369662723295,16647.382700423175,63,1,574.72588848719863,11995,19529,535683.61662737094,642539.69594161911]
[null,"October",763663.10913754767,6421.2029325304848,11329.9057089005,65,1,706.23820175172852,14117,20385,518851.33716027346,630185.6767652228]
[null,"November",815550.23840204242,8801.8131438305645,10806.547001775018,77,1,918.02426467123109,14980,21877,478026.71129267907,598156.51701124152]
[null,"December",1002234.6575159732,12482.092014376092,13406.18123552947,76,1,1473.1087037747661,16091,36018,523441.73471449921,632595.97436835081]
[]
[]
[null,"LPL-S > 500 kW PLS","% of","% of"]
[null,null,"kWh","Gen Obl"]
[null,null,0.36776442997530606,0.35759013051564653]
[]
[]
[]
["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",47.3,null,"Summer",0.66839999999999999]
[null,"February",44.65,null,"Winter",0.78759999999999997]
[null,"March",33.700000000000003]
[null,"April",29.5]
[null,"May",29.25]
[null,"June",29.3,null,null,"Basis"]
[null,"July",34.450000000000003,null,null,"On-Peak","Off-Peak"]
[null,"August",31.95,null,"Summer",0.94,0.9]
[null,"September",31.45,null,"Winter",0.97,0.98]
[null,"October",29.35]
[null,"November",29.8]
[null,"December",33.4]
[]
[]
[]
["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 2019"]
[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",3904.1169483376193,20.23385310982194,67.956924969644461,0,0,3.8705097097770289,0,0,1646.4166590995444,1377.0476936878042]
[null,"Tranmsission Obligation",4225.8068167284737,21.909658389490048,74.221401071794475,0,0,4.255448492699049,0,0,1768.4981307815306,1406.9734684466575]
[]
[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":1103241.022415668},{"$f":"Input!D50","v":17093.914011082521},{"$f":"Input!E50","v":15933.365083598062},{"$f":"Input!F50","v":94},{"$f":"Input!G50","v":2},{"$f":"Input!H50","v":2155.4355758420347},{"$f":"Input!I50","v":16719},{"$f":"Input!J50","v":31492},{"$f":"Input!K50","v":561707.37419042538},{"$f":"AB45*$M$45","v":425775.4507062714},{"$f":"(1-AD45)","v":0.63223557002469399},"winter MWh =",{"$f":"SUM(C45:C49,C54:C56)","v":7016264.2427108828},{"$f":"SUM(D45:D49,D54:D56)","v":83784.199577683336},101616.43239716018,739,13,10055.568108375577,110832,210347,4097966.8887027944,3139975.8202649895,{"$f":"SUM(O45:X45)","v":14771594.151761886},{"$f":"+Y45/(Y45+Y49)","v":0.60178600435762097},null,{"$f":"Input!L50","v":673444.31552568509},null,{"$f":"Input!C66","v":0.36776442997530606},{"$f":"Input!D66","v":0.35759013051564653},{"$f":"AE45","v":0.35759013051564653}]
[null,"February",{"$f":"Input!C51","v":884939.96852743544},{"$f":"Input!D51","v":14489.694391091827},{"$f":"Input!E51","v":12532.010134556667},{"$f":"Input!F51","v":88},{"$f":"Input!G51","v":2},{"$f":"Input!H51","v":2053.8124246830798},{"$f":"Input!I51","v":13249},{"$f":"Input!J51","v":27940},{"$f":"Input!K51","v":500731.3468146454},{"$f":"AB46*$M$45","v":373602.52104401315},null,"on-peak",null,null,{"$f":"SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56)","v":43875.93908127927},null,null,null,null,null,null,{"$f":"SUMPRODUCT(L27:L31,L45:L49)+SUMPRODUCT(L36:L38,L54:L56)","v":1538540.5968935811},null,null,null,{"$f":"Input!L51","v":590922.97041974543}]
[null,"March",{"$f":"Input!C52","v":900474.20353809127},{"$f":"Input!D52","v":12286.799954384289},{"$f":"Input!E52","v":13347.076973522584},{"$f":"Input!F52","v":165},{"$f":"Input!G52","v":2},{"$f":"Input!H52","v":1461.1530389325362},{"$f":"Input!I52","v":13900},{"$f":"Input!J52","v":27825},{"$f":"Input!K52","v":543590.67091787583},412033.30329388456,null,"off-peak",{"$f":"+O45-O46","v":7016264.2427108828},{"$f":"+P45-P46","v":83784.199577683336},{"$f":"+Q45-Q46","v":57740.493315880914},{"$f":"+R45-R46","v":739},null,null,null,null,null,{"$f":"+X45-X46","v":1601435.2233714084},null,null,null,{"$f":"Input!L52","v":651708.51313821413}]
[null,"April",{"$f":"Input!C53","v":737564.85956618492},{"$f":"Input!D53","v":7198.4653312978608},{"$f":"Input!E53","v":11110.647962745927},{"$f":"Input!F53","v":70},{"$f":"Input!G53","v":2},{"$f":"Input!H53","v":882.15727014454114},{"$f":"Input!I53","v":11672},{"$f":"Input!J53","v":25198},{"$f":"Input!K53","v":482431.38921796548},362792.35612392175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L53","v":573824.65227280988}]
[null,"May",{"$f":"Input!C54","v":808596.18360793928},{"$f":"Input!D54","v":5010.2177990897071},{"$f":"Input!E54","v":13150.698296531966},{"$f":"Input!F54","v":104},{"$f":"Input!G54","v":2},{"$f":"Input!H54","v":405.63862857566022},{"$f":"Input!I54","v":10104},{"$f":"Input!J54","v":19612},{"$f":"Input!K54","v":489186.32439443091},389220.88557915203,null,"summer MWh =",{"$f":"SUM(C50:C53)","v":5378288.9871439906},{"$f":"+SUM(D50:D53)","v":26172.065419801485},89216.930204844757,259,4,2604.6269834858181,42257,74265,2392035.128239349,1769560.4921043105,{"$f":"SUM(O49:X49)","v":9774663.2300957832},{"$f":"1-Z45","v":0.39821399564237903},null,{"$f":"Input!L54","v":615626.36465384217}]
[null,"June",{"$f":"Input!C55","v":1213518.8158535871},{"$f":"Input!D55","v":6546.1898509252387},{"$f":"Input!E55","v":20680.771935118843},{"$f":"Input!F55","v":74},{"$f":"Input!G55","v":1},{"$f":"Input!H55","v":649.02180572105635},{"$f":"Input!I55","v":9635},{"$f":"Input!J55","v":18056},{"$f":"Input!K55","v":569919.30450896779},424358.11610806448,null,"on-peak",null,null,{"$f":"+SUMPRODUCT(E32:E35,E50:E53)","v":42865.162873425237},null,null,null,null,null,null,{"$f":"+SUMPRODUCT(L32:L35,L50:L53)","v":893735.14405984548},null,null,null,{"$f":"Input!L55","v":671202.5330866623}]
[null,"July",{"$f":"Input!C56","v":1621529.3461963243},{"$f":"Input!D56","v":7259.9823301952783},{"$f":"Input!E56","v":26953.450064236666},{"$f":"Input!F56","v":59},{"$f":"Input!G56","v":1},{"$f":"Input!H56","v":690.01265660870206},{"$f":"Input!I56","v":9762},{"$f":"Input!J56","v":19121},{"$f":"Input!K56","v":639726.05371033144},464545.57113014389,null,"off-peak",null,null,{"$f":"+Q49-Q50","v":46351.76733141952},null,null,null,null,null,null,{"$f":"+X49-X50","v":875825.34804446506},null,null,null,{"$f":"Input!L56","v":734766.58567628451}]
[null,"August",{"$f":"Input!C57","v":1506520.1271832155},{"$f":"Input!D57","v":6941.6562724086398},{"$f":"Input!E57","v":24935.325505066085},{"$f":"Input!F57","v":63},{"$f":"Input!G57","v":1},{"$f":"Input!H57","v":690.86663266886137},{"$f":"Input!I57","v":10865},{"$f":"Input!J57","v":17559},{"$f":"Input!K57","v":646706.15339267894},474420.35393895925,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L57","v":750385.42029583885}]
[null,"September",{"$f":"Input!C58","v":1036720.697910864},{"$f":"Input!D58","v":5424.2369662723295},{"$f":"Input!E58","v":16647.382700423175},{"$f":"Input!F58","v":63},{"$f":"Input!G58","v":1},{"$f":"Input!H58","v":574.72588848719863},{"$f":"Input!I58","v":11995},{"$f":"Input!J58","v":19529},{"$f":"Input!K58","v":535683.61662737094},406236.4509271431,null,"Block 1",{"$f":"+O49*C163","v":3474374.6856950182},{"$f":"+P49*D163","v":17299.735242488783},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L58","v":642539.69594161911}]
[null,"October",{"$f":"Input!C59","v":763663.10913754767},{"$f":"Input!D59","v":6421.2029325304848},{"$f":"Input!E59","v":11329.9057089005},{"$f":"Input!F59","v":65},{"$f":"Input!G59","v":1},{"$f":"Input!H59","v":706.23820175172852},{"$f":"Input!I59","v":14117},{"$f":"Input!J59","v":20385},{"$f":"Input!K59","v":518851.33716027346},398425.80057105818,null,"Block 2",{"$f":"+O49-O53","v":1903914.3014489724},{"$f":"+P49-P53","v":8872.3301773127023},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L59","v":630185.6767652228}]
[null,"November",{"$f":"Input!C60","v":815550.23840204242},{"$f":"Input!D60","v":8801.8131438305645},{"$f":"Input!E60","v":10806.547001775018},{"$f":"Input!F60","v":77},{"$f":"Input!G60","v":1},{"$f":"Input!H60","v":918.02426467123109},{"$f":"Input!I60","v":14980},{"$f":"Input!J60","v":21877},{"$f":"Input!K60","v":478026.71129267907},378175.82649658783,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L60","v":598156.51701124152}]
[null,"December",{"$f":"Input!C61","v":1002234.6575159732},{"$f":"Input!D61","v":12482.092014376092},{"$f":"Input!E61","v":13406.18123552947},{"$f":"Input!F61","v":76},{"$f":"Input!G61","v":1},{"$f":"Input!H61","v":1473.1087037747661},{"$f":"Input!I61","v":16091},{"$f":"Input!J61","v":36018},{"$f":"Input!K61","v":523441.73471449921},399949.67645010096,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L61","v":632595.97436835081}]
[null,"Total",{"$f":"SUM(C45:C56)","v":12394553.229854874},{"$f":"SUM(D45:D56)","v":109956.26499748482},{"$f":"SUM(E45:E56)","v":190833.36260200499},998,17,{"$f":"SUM(H45:H56)","v":12660.195091861395},{"$f":"SUM(I45:I56)","v":153089},{"$f":"SUM(J45:J56)","v":284612},6490002.0169421434,{"$f":"SUM(L45:L56)","v":4909536.3123693001},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":7765359.2191555165}]
[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":3396366.5376228355},{"$f":"SUMPRODUCT(D9:D13,D45:D49)+SUMPRODUCT(D18:D20,D54:D56)","v":40415.378957423542},50660.125322331281,360.38040000000001,6.3273999999999999,4873.5955168146074,30574.333500000001,57806.195099999997,2318942.0301837898,1707565.6384957992,{"$f":"SUM(O61:X61)","v":7607570.5424989937},{"$f":"+Y61/(Y61+Y62)","v":0.51501350933010837}]
[null,null,"On-Peak","LMP ratio","Off-Peak",null,null,"On-Peak","Off-Peak",null,null,null,null,"off-peak",{"$f":"+O45-O61","v":3619897.7050880473},{"$f":"+P45-P61","v":43368.820620259794},50956.307074828903,378.61959999999999,6.6726000000000001,5181.9725915609697,80257.666499999992,152540.80489999999,1779024.8585190047,1432410.1817691904,{"$f":"SUM(O62:X62)","v":7164023.6092628911},{"$f":"1-Z61","v":0.48498649066989163}]
[null,"January",{"$f":"Input!C73","v":47.3},{"$f":"Input!F74","v":0.78759999999999997},{"$f":"ROUND(+C63*D63,3)","v":37.253},null,null,{"$f":"Input!F81","v":0.97},{"$f":"Input!G81","v":0.98},"NYMEX Forwards (November 15, 2019) from NERA"]
[null,"February",{"$f":"Input!C74","v":44.65},{"$f":"+$D$63","v":0.78759999999999997},{"$f":"ROUND(+C64*D64,3)","v":35.165999999999997},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":33.700000000000003},{"$f":"+$D$63","v":0.78759999999999997},{"$f":"ROUND(+C65*D65,3)","v":26.542000000000002},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":2751345.0055475063},{"$f":"SUMPRODUCT(D14:D17,D50:D53)","v":13615.51371819011},47375.597954820703,132.4836,2.0426000000000002,1593.897725049482,8916.2464999999993,15560.4172,1409706.264219048,985681.96720268996,5233929.4362673033,{"$f":"+Y65/(Y65+Y66)","v":0.53545879925072537}]
[null,"April",{"$f":"Input!C76","v":29.5},{"$f":"+$D$63","v":0.78759999999999997},23.234000000000002,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":2626943.9815964843},{"$f":"+P49-P65","v":12556.551701611375},41841.332250024054,126.5164,1.9573999999999998,1010.7292584363361,33340.753499999999,58704.582800000004,982328.86402030103,783878.52490162058,4540733.7938284781,{"$f":"1-Z65","v":0.46454120074927463}]
[null,"May",{"$f":"Input!C77","v":29.25},{"$f":"+$D$63","v":0.78759999999999997},23.036999999999999,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":29.3},{"$f":"Input!F73","v":0.66839999999999999},19.584,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":6147711.5431703422},{"$f":"+P61+P65","v":54030.89267561365},98035.723277151992,492.86400000000003,8.370000000000001,6467.4932418640892,39490.58,73366.612299999993,3728648.2944028378,2693247.6056984891,12841499.9787663,{"$f":"+Y68/(Y68+Y69)","v":0.52315510992146408}]
[null,"July",{"$f":"Input!C79","v":34.450000000000003},{"$f":"+$D$68","v":0.66839999999999999},23.026,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":6246841.6866845321},{"$f":"+P62+P66","v":55925.372321871168},92797.639324852964,505.13599999999997,8.629999999999999,6192.7018499973055,113598.41999999998,211245.38769999999,2761353.7225393057,2216288.7066708109,11704757.403091369,{"$f":"1-Z68","v":0.47684489007853592}]
[null,"August",{"$f":"Input!C80","v":31.95},{"$f":"+$D$68","v":0.66839999999999999},21.355,null,null,{"$f":"+$H$68","v":0.94},{"$f":"+$I$68","v":0.9}]
[null,"September",{"$f":"Input!C81","v":31.45},{"$f":"+$D$68","v":0.66839999999999999},21.021000000000001,null,null,{"$f":"+$H$68","v":0.94},{"$f":"+$I$68","v":0.9}]
[null,"October",{"$f":"Input!C82","v":29.35},{"$f":"+$D$63","v":0.78759999999999997},23.116,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98}]
[null,"November",{"$f":"Input!C83","v":29.8},{"$f":"+$D$63","v":0.78759999999999997},23.47,null,null,{"$f":"+$H$63","v":0.97},{"$f":"+$I$63","v":0.98}]
[null,"December",{"$f":"Input!C84","v":33.4},{"$f":"+$D$63","v":0.78759999999999997},26.306000000000001,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":26.446013329453724},26.4370997546058,26.660585548644473,26.141906681527558,26.253119555345634,27.459292600001049,22.811498602860524,22.820197324286351,27.228669191010496,26.839340854504051]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80)/SUMPRODUCT(C14:C17,C50:C53)","v":32.055785689858126},31.927804076866078,32.043257059161625,31.692075439860083,31.83867701064878,31.884939404906788,31.803755085311547,31.832295697608892,31.919984513876187,31.891928243603516]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUMPRODUCT(O14:O17,C50:C53)","v":20.5705857321446},20.483334596878077,20.56595930965846,20.329961845036607,20.424438826724909,20.480145300827363,20.406718657237629,20.431422822403,20.496324412903785,20.486004056846397]
[]
[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":32.669828074954253},34.186721192630536,32.691221863501703,32.320763621639834,32.86847287028538,34.780976095158969,30.961552753889311,31.226180945369016,32.836479522958435,32.598286504170559]
[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":36.47844608292791},38.14509922230117,36.334029041044367,36.058868819642925,36.68015675060969,38.606548362558549,36.733798037446668,37.096230192030241,35.945123535724079,35.868741624521022]
[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":29.096394842659414},30.49791098663788,29.069588375258597,28.762733750765666,29.253982479078946,31.1830620726086,28.762603294733477,29.001692801219285,28.784391535788554,28.699601018107078]
[]
[null,"Annual",{"$f":"(C94*SUM(C50:C53)+C98*SUM(C45:C49,C54:C56))/C57","v":29.969168060592299},32.342136900327425,29.871825653859226,30.717232612131742,31.311919149123089,33.27466009784149,28.711901647277969,29.032772467793567,30.769595834555012,30.522570581232848]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C102:L102,C57:L57)/SUM(C57:L57)","v":30.284397735655457}]
[]
[]
["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":142234.30224366413},691.91350428736087,2378.5756001137065,6.7707538305156376,0.10501247822138254,71.521214453395174,963.94549646107714,1694.741954288126,65131.933200105603,47493.83721025152]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C50:C53,C14:C17)*C95/1000","v":88196.525856692373},434.71345440025624,1518.0684635978116,4.1986802457442476,6.5033681661951212E-2,50.821332380821516,283.57011996626625,495.32380148855941,44997.802122986264,31435.298569042141]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C50:C53,O14:O17)*C96/1000","v":54037.776386971782},257.20004988710463,860.50713651589513,2.57207358477139,3.9978796559431332E-2,20.699882072573661,680.37537649481078,1199.4181527995665,20134.131077119342,16058.538641209374]
[]
[null,"Winter - all hrs",{"$f":"SUM(C45:C49,C54:C56)*C98/1000","v":229220.14653781362},2864.3070713099737,3321.9653364730857,23.885044316391838,0.42729014731370996,349.74247400065383,3431.5308148190602,6568.3334833155368,134562.80582665102,102357.83140516609]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C45:C49,C9:C13)+SUMPRODUCT(C54:C56,C18:C20))*C99/1000","v":123894.17362053515},1541.6486404378238,1840.686464684532,12.994909568770446,0.23209002382380775,188.15270101945165,1123.11139191854,2144.3919199550105,83354.657747139121,61248.230694116086]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C45:C49,O9:O13)+SUMPRODUCT(C54:C56,O18:O20))*C100/1000","v":105325.9729172785},1322.658430872149,1481.2788717885542,10.890134747621396,0.19520012348990218,161.5897729812022,2308.4194229005202,4423.9415633605249,51208.148079511884,41109.600711050014]
[]
[null,"Annual",{"$f":"+C112+C116","v":371454.44878147775},{"$f":"+D112+D116","v":3556.2205755973346},5700.5409365867927,30.655798146907475,0.53230262553509244,421.26368845404897,4395.4763112801375,8263.0754376036621,199694.73902675661,149851.66861541761]
[]
[null,"System Total",{"$f":"SUM(C120:L120)","v":743368.62147394638}]
[]
[]
["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":26.446013329453724},26.437099754605804,26.66058554864447,26.141906681527558,26.253119555345634,27.459292600001049,22.811498602860524,22.820197324286351,27.228669191010496,26.839340854504055]
[null,"PSE&G On pk",null,null,{"$f":"+(E113*1000-W131*AVERAGE(E$95,E$96))/Q131","v":32.647099467994209},null,null,null,null,null,null,{"$f":"+(L113*1000-X131*AVERAGE(L$95,L$96))/R131","v":32.478644845804304},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,E32:E35)","v":42865.162873425237},{"$f":"SUMPRODUCT(L50:L53,L32:L35)","v":893735.14405984548},null,{"$f":"SUMPRODUCT(E50:E53,E14:E17)","v":47375.597954820703},{"$f":"SUMPRODUCT(L50:L53,L14:L17)","v":985681.96720268996},null,{"$f":"+T131-Q131","v":4510.4350813954661},{"$f":"+U131-R131","v":91946.823142844485},null,{"$f":"+E131*Q131/1000","v":1399.4232360404862},{"$f":"+L131*R131/1000","v":29027.30633013347}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E114*1000-W132*AVERAGE(E$95,E$96))/Q132","v":21.124380373075926},null,null,null,null,null,null,{"$f":"+(L114*1000-X132*AVERAGE(L$95,L$96))/R132","v":21.08471845596836},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,Q32:Q35)","v":46351.767331419542},{"$f":"SUMPRODUCT(L50:L53,X32:X35)","v":875825.3480444653},null,{"$f":"SUMPRODUCT(E50:E53,Q14:Q17)","v":41841.332250024061},{"$f":"SUMPRODUCT(L50:L53,X14:X17)","v":783878.52490162081},null,{"$f":"+T132-Q132","v":-4510.4350813954807},{"$f":"+U132-R132","v":-91946.823142844485},null,{"$f":"+E132*Q132/1000","v":979.15236407322084},{"$f":"+L132*R132/1000","v":18466.530880118051}]
[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":2378.575600113707},{"$f":"+AA132+AA131","v":47493.83721025152},null,{"$f":"+E112","v":2378.5756001137065},{"$f":"+L112","v":47493.83721025152}]
[null,"Winter - all hrs",{"$f":"+C116/SUM(C45:C49,C54:C56)*1000","v":32.669828074954246},34.186721192630543,32.691221863501703,32.320763621639834,32.86847287028538,34.780976095158969,30.961552753889311,31.22618094536902,32.836479522958442,32.598286504170559]
[null,"PSE&G On pk",null,null,{"$f":"+(E117*1000-W135*AVERAGE(E$99,E$100))/Q135","v":36.895650278625929},null,null,null,null,null,null,{"$f":"+(L117*1000-X135*AVERAGE(L$99,L$100))/R135","v":36.262544781778587},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38)","v":43875.93908127927},{"$f":"SUMPRODUCT(L45:L49,L27:L31)+SUMPRODUCT(L54:L56,L36:L38)","v":1538540.5968935811},null,{"$f":"SUMPRODUCT(E45:E49,E9:E13)+SUMPRODUCT(E54:E56,E18:E20)","v":50660.125322331281},{"$f":"SUMPRODUCT(L45:L49,L9:L13)+SUMPRODUCT(L54:L56,L18:L20)","v":1707565.6384957992},null,{"$f":"+T135-Q135","v":6784.1862410520116},{"$f":"+U135-R135","v":169025.04160221806},null,{"$f":"+E135*Q135/1000","v":1618.8313039891757},{"$f":"+L135*R135/1000","v":55791.39729343784}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E118*1000-W136*AVERAGE(E$99,E$100))/Q136","v":29.496354026048486},null,null,null,null,null,null,{"$f":"+(L118*1000-X136*AVERAGE(L$99,L$100))/R136","v":29.077937984712634},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,Q27:Q31)+SUMPRODUCT(E54:E56,Q36:Q38)","v":57740.493315880922},{"$f":"SUMPRODUCT(L45:L49,X27:X31)+SUMPRODUCT(L54:L56,X36:X38)","v":1601435.2233714089},null,{"$f":"SUMPRODUCT(E45:E49,Q9:Q13)+SUMPRODUCT(E54:E56,Q18:Q20)","v":50956.307074828917},{"$f":"SUMPRODUCT(L45:L49,X9:X13)+SUMPRODUCT(L54:L56,X18:X20)","v":1432410.1817691908},null,{"$f":"+T136-Q136","v":-6784.1862410520043},{"$f":"+U136-R136","v":-169025.04160221806},null,{"$f":"+E136*Q136/1000","v":1703.13403248391},{"$f":"+L136*R136/1000","v":46566.434111728253}]
[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":3321.9653364730857},{"$f":"+AA136+AA135","v":102357.8314051661},null,{"$f":"+E116","v":3321.9653364730857},{"$f":"+L116","v":102357.83140516609}]
[null,"Annual Average",{"$f":"(C130*SUM(C50:C53)+C134*SUM(C45:C49,C54:C56))/C57","v":29.969168060592292},32.342136900327425,29.871825653859222,30.717232612131742,31.311919149123089,33.27466009784149,28.711901647277969,29.032772467793567,30.76959583455502,30.522570581232848]
[null,"System Average",{"$f":"+C122/SUM(C57:L57)*1000","v":30.28439773565545}]
[]
[]
["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":3904.1169483376193},{"$f":"Input!D101","v":20.23385310982194},{"$f":"Input!E101","v":67.956924969644461},{"$f":"Input!F101","v":0},{"$f":"Input!G101","v":0},{"$f":"Input!H101","v":3.8705097097770289},{"$f":"Input!I101","v":0},{"$f":"Input!J101","v":0},{"$f":"Input!K101","v":1646.4166590995444},{"$f":"Input!L101","v":1377.0476936878042}]
[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":4225.8068167284737},{"$f":"Input!D102","v":21.909658389490048},{"$f":"Input!E102","v":74.221401071794475},{"$f":"Input!F102","v":0},{"$f":"Input!G102","v":0},{"$f":"Input!H102","v":4.255448492699049},{"$f":"Input!I102","v":0},{"$f":"Input!J102","v":0},{"$f":"Input!K102","v":1768.4981307815306},{"$f":"Input!L102","v":1406.9734684466575}]
[null,"Gen Obl - MW",{"$f":"ROUND(AD145*$AD$148*$AD$149,1)","v":4700.3999999999996},{"$f":"ROUND(AE145*$AD$148*$AD$149,1)","v":24.4},81.8,0,0,4.7,0,0,1982.2,{"$f":"ROUND(AM145*$AD$148*$AD$149*(1-AE45),1)","v":1065.0999999999999},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":4225.8},{"$f":"ROUND(AE146,1)","v":21.9},74.2,0,0,4.3,0,0,1768.5,{"$f":"ROUND(AM146*(1-AF45),1)","v":903.9},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":39.085722219264888},{"$f":"(+$D$155*D149*$H$154/12)/D57","v":22.833065101451286},{"$f":"(+$D$155*E149*$H$154/12)/SUMPRODUCT(E27:E38,E45:E56)","v":98.066132828724676},{"$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":38.937506525227008},{"$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.102961392784131},{"$f":"((+$Q$160*D147*1000)/D57)","v":14.10380554519084},{"$f":"(+$Q$160*E147*1000)/SUMPRODUCT(E45:E56,E27:E38)","v":59.936976736989976},{"$f":"((+$Q$160*F147*1000)/F57)","v":0},{"$f":"((+$Q$160*G147*1000)/G57)","v":0},{"$f":"((+$Q$160*H147*1000)/H57)","v":23.595214199505673},{"$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":18.566246585612603},{"$f":"(D147*$F$158*$E$152)/SUM(D50:D53)","v":19.805474871227482},{"$f":"(E147*$F$158*$E$152)/SUMPRODUCT(E50:E53,E32:E35)","v":40.539861078594832},{"$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":38.334142521388671},{"$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.347107742218427},{"$f":"(D147*$F$159*$E$153)/SUM(D45:D49,D54:D56)","v":12.322748217493297},{"$f":"(E147*$F$159*$E$153)/(SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38))","v":78.887238301341029},{"$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.777487542882053},{"$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":109.60526782150274},{"$f":"+D130+($D$171*D80)+D$178+D181","v":83.344541281247928},null,{"$f":"+F130+($D$171*F80)+F$178+F181","v":46.112477561527555},{"$f":"+G130+($D$171*G80)+G$178+G181","v":46.223690435345631},{"$f":"+H130+($D$171*H80)+H$178+H181","v":109.96258420473373},{"$f":"+I130+($D$171*I80)+I$178+I181","v":42.782069482860521},{"$f":"+J130+($D$171*J80)+J$178+J181","v":42.790768204286351}]
[null,"PSE&G On pk",null,null,{"$f":"+E131+($D$171*E80)+E$178+E181","v":210.62077991370884}]
[null,"PSE&G Off pk",null,null,{"$f":"+E132+($D$171*E80)","v":41.094951253075926}]
[null,"Block 1 (0-600 kWh/m)",{"$f":"(C194*SUM(C50:C53)-C166*10*C164*SUM(C50:C53))/SUM(C50:C53)","v":106.54245982150273},{"$f":"(D194*SUM(D50:D53)-D166*10*D164*SUM(D50:D53))/SUM(D50:D53)","v":79.422650281247911}]
[null,"Block 2 (>600 kWh/m)",{"$f":"+C197+C166*10","v":115.19445982150273},{"$f":"+D197+D166*10","v":90.991650281247914}]
[]
[null,"Winter - all hrs",{"$f":"+C134+($D$171*C80)+C$178+C181","v":115.82908256700327},{"$f":"+D134+($D$171*D80)+D$178+D181","v":91.09416271927266},null,{"$f":"+F134+($D$171*F80)+F$178+F181","v":52.291334501639838},{"$f":"+G134+($D$171*G80)+G$178+G181","v":52.839043750285384},{"$f":"+H134+($D$171*H80)+H$178+H181","v":117.28426769989166},{"$f":"+I134+($D$171*I80)+I$178+I181","v":50.932123633889312},{"$f":"+J134+($D$171*J80)+J$178+J181","v":51.19675182536902}]
[null,"PSE&G On pk",null,null,{"$f":"+E135+($D$171*E80)+E$178+E181","v":214.86933072434059}]
[null,"PSE&G Off pk",null,null,{"$f":"+E136+($D$171*E80)","v":49.46692490604849}]
[]
[null,"Annual -all hrs",{"$f":"+C138+($D$171*C80)+C$178+C181","v":113.1284225526413},{"$f":"+D138+($D$171*D80)+D$178+D181","v":89.249578426969549},{"$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":121.66088596950053},{"$f":"+F138+($D$171*F80)+F$178+F181","v":50.687803492131742},{"$f":"+G138+($D$171*G80)+G$178+G181","v":51.282490029123089},{"$f":"+H138+($D$171*H80)+H$178+H181","v":115.77795170257417},{"$f":"+I138+($D$171*I80)+I$178+I181","v":48.682472527277966},{"$f":"+J138+($D$171*J80)+J$178+J181","v":49.003343347793567}]
[]
[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":47.199240071010493},{"$f":"+L130+($D$171*L$80)","v":46.809911734504055},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,{"$f":"+L131+($D$171*L$80)","v":52.449215725804308},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":41.055289335968361},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":52.807050402958438},{"$f":"+L134+($D$171*L$80)","v":52.568857384170556}]
[null,"PSE&G On pk",null,{"$f":"+L135+($D$171*L$80)","v":56.233115661778584},null,null,null,"Trans cost"]
[null,"PSE&G Off pk",null,{"$f":"+L136+($D$171*L$80)","v":49.04850886471263},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":50.740166714555016},{"$f":"+L138+($D$171*L$80)","v":50.493141461232852}]
[]
[null,"Including T&G Obligation $"]
[null,"Summer - all hrs",{"$f":"(C211*W49+((I214*$H152)*K147*1000)+(I217*$H152*K149*1000))/W49","v":93.007686480541011},{"$f":"(D211*X49+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X49","v":79.081402833832001},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":116.34550093985287}]
[null,"PSE&G Off pk",null,{"$f":"+D213","v":41.055289335968361}]
[]
[null,"Winter - all hrs",{"$f":"(C215*W45+((I214*$H153)*K147*1000)+(I217*$H153*K149*1000))/W45","v":106.28499005334571},{"$f":"(D215*X45+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X45","v":88.942612431651995}]
[null,"PSE&G On pk",null,{"$f":"(D216*X46+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X46","v":130.4675632752745}]
[null,"PSE&G Off pk",null,{"$f":"+D217","v":49.04850886471263}]
[]
[null,"Annual - including T&G Obl $",{"$f":"(C219*K57+((I214*$H152+I214*$H153)*K147*1000)+(I217*$H154*K149*1000))/K57","v":101.39134341478723},{"$f":"(D219*L57+((J214*$H152+J214*$H153)*L147*1000)+(J217*$H154*L149*1000))/L57","v":85.388303878174611}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C204:J204,C57:J57)+SUMPRODUCT(C230:D230,K57:L57))/1000","v":2535370.6834850577}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C233/SUM(C57:L57)*1000","v":103.2895012890629},"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.85131652203431},"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.47099999999999997},{"$f":"ROUND(+G194/$D$235,3)","v":0.47199999999999998},{"$f":"ROUND(+H194/$D$235,3)","v":1.1240000000000001},{"$f":"ROUND(+I194/$D$235,3)","v":0.437},{"$f":"ROUND(+J194/$D$235,3)","v":0.437}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E195/$D$235,3)","v":2.1520000000000001},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E196/$D$235,3)","v":0.42},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I245*U49+J245*V49)/(U49+V49),3)","v":0.437}]
[]
[null,"All usage Multiplier",{"$f":"ROUND(+C194/$D$235,3)","v":1.1200000000000001},{"$f":"ROUND(+D194/$D$235,3)","v":0.85199999999999998}]
[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.1839999999999999},{"$f":"ROUND(+D200/$D$235,3)","v":0.93100000000000005},null,{"$f":"ROUND(+F200/$D$235,3)","v":0.53400000000000003},{"$f":"ROUND(+G200/$D$235,3)","v":0.54},{"$f":"ROUND(+H200/$D$235,3)","v":1.1990000000000001},{"$f":"ROUND(+I200/$D$235,3)","v":0.52100000000000002},{"$f":"ROUND(+J200/$D$235,3)","v":0.52300000000000002}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E201/$D$235,3)","v":2.1960000000000002},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E202/$D$235,3)","v":0.50600000000000001},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I255*U45+J255*V45)/(U45+V45),3)","v":0.52200000000000002}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C204/$D$235,3)","v":1.1559999999999999},{"$f":"ROUND(+D204/$D$235,3)","v":0.91200000000000003},1.2430000000000001,0.51800000000000002,0.52400000000000002,1.1830000000000001,0.498,0.501]
[]
[]
[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.95099999999999996},{"$f":"ROUND(+C211-C222,3)","v":-45.808},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D223/$D$235,3)","v":1.1890000000000001},{"$f":"ROUND(+D212-D223,3)","v":-63.896000000000001},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.42},{"$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.0860000000000001},{"$f":"ROUND(+C215-C226,3)","v":-53.478000000000002}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D227/$D$235,3)","v":1.333},{"$f":"ROUND(+D216-D227,3)","v":-74.233999999999995},null,"Trans cost"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D228/$D$235,3)","v":0.501},{"$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.036},null,{"$f":"ROUND(+D230/$D$235,3)","v":0.873}]
[]
[]
[]
["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":589488.80485735566},{"$f":"(+D197*SUM(D50:D53)*D163+D198*SUM(D50:D53)*D164)/1000","v":2181.298786796166},{"$f":"(E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))/1000","v":10933.117654507583},{"$f":"+F194*SUM(F50:F53)/1000","v":11.943131688435637},{"$f":"+G194*SUM(G50:G53)/1000","v":0.18489476174138253},{"$f":"+H194*SUM(H50:H53)/1000","v":286.41151399348087},{"$f":"+I194*SUM(I50:I53)/1000","v":1807.8419101372369},{"$f":"+J194*SUM(J50:J53)/1000","v":3177.8564006913257},{"$f":"(C211*SUM(K50:K53)/1000)+(I212*$H152*K147)+(I217*$H152*K149)","v":222592.70675305941},{"$f":"(D211*SUM(L50:L53)/1000)+(J212*$H152*L147)+(J217*$H152*L149)","v":140001.14806926833}]
[null,"Winter",{"$f":"+C200*SUM(C45:C49,C54:C56)/1000","v":812687.45028087148},{"$f":"+D200*SUM(D45:D49,D54:D56)/1000","v":7632.251509633501},{"$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":12283.83831219129},{"$f":"+F200*SUM(F45:F49,F54:F56)/1000","v":38.643296196711837},{"$f":"+G200*SUM(G45:G49,G54:G56)/1000","v":0.68690756875370995},{"$f":"+H200*SUM(H45:H49,H54:H56)/1000","v":1179.3599418972144},{"$f":"+I200*SUM(I45:I49,I54:I56)/1000","v":5644.9091265912202},{"$f":"+J200*SUM(J45:J49,J54:J56)/1000","v":10769.083156210898},{"$f":"(C215*SUM(K45:K49,K54:K56)/1000)+(I213*$H153*K147)+(I217*$H153*K149)","v":435437.31650938321},{"$f":"(D215*SUM(L45:L49,L54:L56)/1000)+(J213*$H153*L147)+(J217*$H153*L149)","v":279215.83047225419}]
[null,"Total",{"$f":"+C303+C302","v":1402176.2551382273},{"$f":"+D303+D302","v":9813.5502964296666},23216.955966698872,50.586427885147472,0.87180233049509248,1465.7714558906953,7452.7510367284576,13946.939556902224,{"$f":"+K303+K302","v":658030.02326244256},{"$f":"+L303+L302","v":419216.97854152252}]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C302/C304","v":0.42040991829464658},{"$f":"+D302/D304","v":0.22227417406621525},0.47091090107546602,0.23609359640003802,0.21208335338629075,0.19539984411788067,0.24257376923338464,{"$f":"+J302/J304","v":0.22785331417878205},{"$f":"+K302/K304","v":0.33827135371341954},{"$f":"+L302/L304","v":0.33395867828717135}]
[null,"Winter",{"$f":"+C303/C304","v":0.57959008170535331},{"$f":"+D303/D304","v":0.77772582593378481},0.52908909892453404,0.76390640359996198,0.7879166466137093,0.80460015588211931,0.7574262307666153,{"$f":"+J303/J304","v":0.77214668582121793},{"$f":"+K303/K304","v":0.66172864628658057},{"$f":"+L303/L304","v":0.6660413217128287}]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C302:L302)","v":970481.31397225941}]
[null,"Winter",{"$f":"+SUM(C303:L303)","v":1564889.3695127985}]
[null,"Total",{"$f":"+C312+C311","v":2535370.6834850581}]
[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.38277689345143789},null,{"$f":"+C311/SUMPRODUCT(O49:X49,C85:L85)*1000","v":94.058027513615571},"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.61722310654856205},null,{"$f":"+C312/SUMPRODUCT(O45:X45,C85:L85)*1000","v":100.36141273851447},"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.85131652203431},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":589424.34435987216},{"$f":"+($C$322*D249*P49+D250*P53+D251*P54)/1000","v":2181.9444881738523},{"$f":"(($C$322*E246*Q50)+(C322*E247*Q51))/1000","v":10931.320170177796},{"$f":"+$C$322*F245*R49/1000","v":11.936784251206442},{"$f":"+$C$322*G245*S49/1000","v":0.18474328559360079},{"$f":"+$C$322*H245*T49/1000","v":286.46958562638207},{"$f":"+$C$322*K247*U49/1000","v":1806.9526469526909},{"$f":"+$C$322*K247*V49/1000","v":3175.6475453993799},{"$f":"+($C$322*C267+D267)*W49/1000+(I268*H152*K147)+(I273*H152*K149)","v":222710.92417399184},{"$f":"(($C$322*E268+F268)*X50+(C322*E269*X51))/1000+(J268*$H$152*L147)+(J273*$H$152*L149)","v":140038.24307871854}]
[null,"Winter",{"$f":"+$C$322*C255*O45/1000","v":812876.02076742903},{"$f":"+$C$322*D255*P45/1000","v":7632.7050303841243},{"$f":"(($C$322*E256*Q46)+(C322*E257*Q47))/1000","v":12287.018755946161},{"$f":"+$C$322*F255*R45/1000","v":38.61467363382431},{"$f":"+$C$322*G255*S45/1000","v":0.68691624198468093},{"$f":"+$C$322*H255*T45/1000","v":1179.7567427600575},{"$f":"+$C$322*K257*U45/1000","v":5661.1198128659962},{"$f":"+$C$322*K257*V45/1000","v":10744.185517512304},{"$f":"+($C$322*C271+D271)*W45/1000+(I269*H153*K147)+(I273*H153*K149)","v":435361.16810982674},{"$f":"(($C$322*E272+F272)*X46+C322*E273*X47)/1000+(J269*$H$153*L147)+(J273*$H$153*L149)","v":279127.49494482705}]
[null,"Total",{"$f":"+C329+C328","v":1402300.3651273013},{"$f":"+D329+D328","v":9814.649518557977},23218.338926123957,50.55145788503075,0.87165952757828169,1466.2263283864395,7468.0724598186871,13919.833062911683,658072.09228381864,419165.73802354559]
[]
[null,"Total Summer",{"$f":"SUM(C328:L328)","v":970567.96757644962}]
[null,"Total Winter",{"$f":"SUM(C329:L329)","v":1564908.7712714272}]
[null,"Grand Total",{"$f":"+C333+C332","v":2535476.7388478769}]
[]
[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":555520.78727056191},2703.2995849160234,9215.1722273995492,26.751980833867293,0.41315800515625162,269.03062216828641,4364.7044559719307,7670.7948132322563,247072.11546176198,182777.02073028297]
[null,"Winter",{"$f":"+$C$322*$C$324*O45*C85/1000","v":724706.43454189168},8654.0281902822262,10495.910625076449,76.330941452617481,1.3427635167578176,1038.6346150923189,11447.782006869418,21726.636727650512,423276.95623320434,324326.53653488698]
[null,"Total",{"$f":"+C339+C338","v":1280227.2218124536},11357.32777519825,19711.082852476,103.08292228648477,1.7559215219140691,1307.6652372606054,15812.486462841349,29397.431540882768,670349.07169496629,507103.55726516992]
[]
[null,"Total Summer",{"$f":"SUM(C338:L338)","v":1009620.0903051338}]
[null,"Total Winter",{"$f":"SUM(C339:L339)","v":1525750.5931799232}]
[null,"Grand Total",{"$f":"+C343+C342","v":2535370.6834850572}]
[]
[null,"Difference ( in $1000) =",{"$f":"+C334-C344","v":106.05536281969398}]
[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":10317899.913771585}]
[null,"Winter",{"$f":"SUMPRODUCT(O45:X45,C85:L85)","v":15592540.268340206}]
[null,"Total",{"$f":"+C353+C352","v":25910440.182111792}]

{"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":10317899.913771585},null,null,null,"from Table #17 of the current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"+bid_factors!C353","v":15592540.268340206}]
[]
[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":323051.01855903212},{"$f":"+D$8*D$13/D$14*D16*$C20/1000+D$9*D$13/D$14*$C20/1000","v":333222.04013285483},333222.04013285483,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":488198.76696872752},{"$f":"+D$8*D$13/D$14*D17*$C21/1000+D$9*D$13/D$14*$C21/1000","v":503569.34284030675},503569.34284030675,null,"= (1) * (2)/(3) * (5) * (7) + (1A) * (2)/(3) * (7)"]
[10,"                           Total",{"$f":"+C25+C24","v":811249.7855277597},{"$f":"+D25+D24","v":836791.38297316153},{"$f":"+E25+E24","v":836791.38297316153},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":2484837.1239047027},null,null,null,"= (13) * [(6)+(7)] / 1000"]
[15,"Total Payment to Suppliers =",{"$f":"SUM(C26:E26)","v":2484832.5514740827},null,null,null,"= sum (line 10)"]
[16,"Difference =",{"$f":"+C36-C37","v":4.572430619969964},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.47099999999999997},{"$f":"+bid_factors!G245","v":0.47199999999999998},{"$f":"+bid_factors!H245","v":1.1240000000000001},{"$f":"+bid_factors!I245","v":0.437},{"$f":"+bid_factors!J245","v":0.437}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E246","v":2.1520000000000001},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E247","v":0.42},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K247","v":0.437}]
[]
[null,"All usage Multiplier",{"$f":"+bid_factors!C249","v":1.1200000000000001},{"$f":"+bid_factors!D249","v":0.85199999999999998}]
[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.1839999999999999},{"$f":"+bid_factors!D255","v":0.93100000000000005},null,{"$f":"+bid_factors!F255","v":0.53400000000000003},{"$f":"+bid_factors!G255","v":0.54},{"$f":"+bid_factors!H255","v":1.1990000000000001},{"$f":"+bid_factors!I255","v":0.52100000000000002},{"$f":"+bid_factors!J255","v":0.52300000000000002}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E256","v":2.1960000000000002},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E257","v":0.50600000000000001},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K257","v":0.52200000000000002}]
[]
[null,"Annual - all hrs",{"$f":"+bid_factors!C259","v":1.1559999999999999},{"$f":"+bid_factors!D259","v":0.91200000000000003},{"$f":"+bid_factors!E259","v":1.2430000000000001},{"$f":"+bid_factors!F259","v":0.51800000000000002},{"$f":"+bid_factors!G259","v":0.52400000000000002},{"$f":"+bid_factors!H259","v":1.1830000000000001},{"$f":"+bid_factors!I259","v":0.498},{"$f":"+bid_factors!J259","v":0.501}]
[]
[]
[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.95099999999999996},{"$f":"+bid_factors!D267","v":-45.808},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E268","v":1.1890000000000001},{"$f":"+bid_factors!F268","v":-63.896000000000001},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.42},{"$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.0860000000000001},{"$f":"+bid_factors!D271","v":-53.478000000000002},null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E272","v":1.333},{"$f":"+bid_factors!F272","v":-74.233999999999995},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.501},{"$f":"+bid_factors!F273","v":0}]
[]
[null,"Annual - including T&G Obl $",{"$f":"+bid_factors!C275","v":1.036},null,{"$f":"+bid_factors!E275","v":0.873}]
[]
[]
["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.5168999999999997},{"$f":"ROUND(($C$32*G48)/10,4)","v":4.5265000000000004},{"$f":"ROUND(($C$32*H48)/10,4)","v":10.779299999999999},{"$f":"ROUND(($C$32*K50)/10,4)","v":4.1909000000000001},{"$f":"+I89","v":4.1909000000000001}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E49)/10,4)","v":20.637899999999998}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E50/10),4)","v":4.0278}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C53)/10,4)","v":10.4346},{"$f":"ROUND((+$C$32*D52+D53)/10,4)","v":7.7786}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C54)/10,4)","v":11.299799999999999},{"$f":"ROUND((+$C$32*D52+D54)/10,4)","v":8.9354999999999993}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C58)/10,4)","v":11.354699999999999},{"$f":"ROUND(($C$32*D58)/10,4)","v":8.9283999999999999},null,{"$f":"ROUND(($C$32*F58)/10,4)","v":5.1211000000000002},{"$f":"ROUND(($C$32*G58)/10,4)","v":5.1787000000000001},{"$f":"ROUND(($C$32*H58)/10,4)","v":11.4985},{"$f":"ROUND(($C$32*K60)/10,4)","v":5.0060000000000002},{"$f":"+I96","v":5.0060000000000002}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E59)/10,4)","v":21.059899999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E60)/10,4)","v":4.8525999999999998}]
[]
[]
[]
[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.5393999999999997},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E71+F71)/10,4)","v":5.0129999999999999},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":4.0278},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":5.0670000000000002},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E75+F75)/10,4)","v":5.3601999999999999},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.8045999999999998}]
[]
[]
[]
["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":577675.60918866331},{"$f":"+D93/100*bid_factors!P53+auction_results_and_rates!D94/100*bid_factors!P54","v":2138.4642685660087},{"$f":"+E90/100*bid_factors!Q50+E91/100*bid_factors!Q51","v":10713.425933229542},{"$f":"+F89/100*bid_factors!R49","v":11.698770999999999},{"$f":"+G89/100*bid_factors!S49","v":0.18106000000000003},{"$f":"+H89/100*bid_factors!T49","v":280.76055643088677},{"$f":"+I89/100*bid_factors!U49","v":1770.948613},{"$f":"+J89/100*bid_factors!V49","v":3112.371885}]
[null,"Winter",{"$f":"+C96/100*bid_factors!O45","v":796675.75596709258},{"$f":"+D96/100*bid_factors!P45","v":7480.5884750938794},{"$f":"+E97/100*bid_factors!Q46+auction_results_and_rates!E98/100*bid_factors!Q47","v":12042.14407322477},{"$f":"+F96/100*bid_factors!R45","v":37.844929},{"$f":"+G96/100*bid_factors!S45","v":0.67323100000000002},{"$f":"+H96/100*bid_factors!T45","v":1156.2394989415657},{"$f":"+I96/100*bid_factors!U45","v":5548.2499200000002},{"$f":"+J96/100*bid_factors!V45","v":10529.97082}]
[null,"Total",{"$f":"+C122+C121","v":1374351.365155756},{"$f":"+D122+D121","v":9619.0527436598877},22755.570006454313,49.543700000000001,0.85429100000000002,1437.0000553724524,7319.1985330000007,13642.342705000001]
[]
[]
[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":108584.042611297},{"$f":"I108*bid_factors!K147*4+auction_results_and_rates!I112*bid_factors!K149*4","v":109575.64079999999},null,{"$f":"+E108/100*bid_factors!X50+auction_results_and_rates!E109/100*bid_factors!X51","v":80079.436140255013},{"$f":"auction_results_and_rates!J108*bid_factors!L147*4+auction_results_and_rates!J112*bid_factors!L149*4","v":57106.481639999998}]
[null,"Winter",{"$f":"+C111/100*bid_factors!W45","v":207643.98225057058},{"$f":"auction_results_and_rates!I109*bid_factors!K147*8+auction_results_and_rates!I112*bid_factors!K149*8","v":219151.28159999999},null,{"$f":"+E112/100*bid_factors!X46+auction_results_and_rates!E113/100*bid_factors!X47","v":159411.40981679241},{"$f":"auction_results_and_rates!J109*bid_factors!L147*8+auction_results_and_rates!J112*bid_factors!L149*8","v":114212.96328}]
[null,"Total",{"$f":"+C130+C129","v":316228.0248618676},{"$f":"+D130+D129","v":328726.92239999998},null,{"$f":"+F130+F129","v":239490.84595704742},{"$f":"+G130+G129","v":171319.44491999998}]
[]
[]
[null,null,"Energy $","Obligation $","Total $"]
[null,"Total Summer",{"$f":"SUM(C121:J121)+C129+F129","v":784366.93902744167},{"$f":"+D129+G129","v":166682.12244000001},{"$f":"+C135+D135","v":951049.06146744173}]
[null,"Total Winter",{"$f":"SUM(C122:J122)+C130+F130","v":1200526.8589817157},{"$f":"+D130+G130","v":333364.24488000001},{"$f":"+C136+D136","v":1533891.1038617156}]
[null,"Grand Total",{"$f":"+C136+C135","v":1984893.7980091574},{"$f":"+D131+G131","v":500046.36731999996},{"$f":"+C137+D137","v":2484940.1653291574}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":989495.09882474178}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1495337.452649341}]
[null,"Total",{"$f":"+C142+C141","v":2484832.5514740827},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":38446.037357300054},null,{"$f":"ROUND(1+(C146/C135),5)","v":1.0490200000000001}]
[null,"Winter",{"$f":"+C142-E136","v":-38553.65121237468},null,{"$f":"ROUND(1+(C147/C136),5)","v":0.96789000000000003}]
[null,"Total",{"$f":"+C143-E137","v":-107.61385507462546}]
[]
[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.7382999999999997},{"$f":"ROUND(+G89*$E$146,4)","v":4.7484000000000002},{"$f":"ROUND(+H89*$E$146,4)","v":11.307700000000001},{"$f":"ROUND(+I89*$E$146,4)","v":4.3963000000000001},{"$f":"ROUND(+J89*$E$146,4)","v":4.3963000000000001}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E90*$E$146,4)","v":21.6496}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E91*$E$146,4)","v":4.2252000000000001}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C93*$E$146,4)","v":10.946099999999999},{"$f":"ROUND(+D93*$E$146,4)","v":8.1599000000000004}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C94*$E$146,4)","v":11.8537},{"$f":"ROUND(+D94*$E$146,4)","v":9.3734999999999999}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C96*$E$147,4)","v":10.9901},{"$f":"ROUND(+D96*$E$147,4)","v":8.6417000000000002},null,{"$f":"ROUND(+F96*$E$147,4)","v":4.9566999999999997},{"$f":"ROUND(+G96*$E$147,4)","v":5.0124000000000004},{"$f":"ROUND(+H96*$E$147,4)","v":11.129300000000001},{"$f":"ROUND(+I96*$E$147,4)","v":4.8452999999999999},{"$f":"ROUND(+J96*$E$147,4)","v":4.8452999999999999}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E97*$E$147,4)","v":20.383700000000001}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E98*$E$147,4)","v":4.6967999999999996}]
[]
[]
[]
[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.7618999999999998},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E108*$E$146,4)","v":5.2587000000000002},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.2252000000000001},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.9043000000000001},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E112*$E$147,4)","v":5.1881000000000004},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.6502999999999997}]
[]
[]
[]
["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":605992.81702171918},{"$f":"+D165/100*bid_factors!P53+auction_results_and_rates!D166/100*bid_factors!P54","v":2243.2889652222484},{"$f":"+E162/100*bid_factors!Q50+E163/100*bid_factors!Q51","v":11238.591174732208},{"$f":"+F161/100*bid_factors!R49","v":12.272196999999998},{"$f":"+G161/100*bid_factors!S49","v":0.18993599999999999},{"$f":"+H161/100*bid_factors!T49","v":294.5234054116259},{"$f":"+I161/100*bid_factors!U49","v":1857.7444910000002},{"$f":"+J161/100*bid_factors!V49","v":3264.9121950000003},{"$f":"+C179/100*bid_factors!W49+I180*bid_factors!K147*4+auction_results_and_rates!I184*bid_factors!K149*4","v":223481.96157162957},{"$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":141110.70426624984}]
[null,"Winter",{"$f":"+C168/100*bid_factors!O45","v":771094.45653816871},{"$f":"+D168/100*bid_factors!P45","v":7240.3791749046613},{"$f":"+E169/100*bid_factors!Q46+auction_results_and_rates!E170/100*bid_factors!Q47","v":11655.495284571018},{"$f":"+F168/100*bid_factors!R45","v":36.630012999999998},{"$f":"+G168/100*bid_factors!S45","v":0.65161200000000008},{"$f":"+H168/100*bid_factors!T45","v":1119.1143414854432},{"$f":"+I168/100*bid_factors!U45","v":5370.1428959999994},{"$f":"+J168/100*bid_factors!V45","v":10191.943190999998},{"$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":420127.87172265118},{"$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":268505.53017987648}]
[null,"Total",{"$f":"+C194+C193","v":1377087.2735598879},9483.6681401269088,22894.086459303224,48.902209999999997,0.84154800000000007,1413.6377468970691,7227.8873869999998,13456.855385999999,643609.8332942808,409616.23444612633]
[]
[null,"Total Summer",{"$f":"SUM(C193:L193)","v":989497.00522396457}]
[null,"Total Winter",{"$f":"SUM(C194:L194)","v":1495342.2149536572}]
[null,"Grand Total",{"$f":"+C198+C197","v":2484839.2201776216}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":989495.09882474178}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1495337.452649341}]
[null,"Total",{"$f":"+C204+C203","v":2484832.5514740827}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C197-C203","v":1.9063992227893323},null,{"$f":"+C208/C197","v":1.9266346565221126E-6}]
[null,"Winter",{"$f":"+C198-C204","v":4.7623043162748218},null,{"$f":"+C209/C198","v":3.184758825539084E-6}]
[null,"Total",{"$f":"+C199-C205","v":6.6687035388313234},null,{"$f":"+C210/C199","v":2.6837565524076968E-6}]

{"sheet":"4-1","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Development of  Capacity Proxy Price True-Up - $/MWh"]
[null,"2020/2021 Delivery Year"]
[null,null,"2020/21\nDelivery Year",null,"Notes:"]
[1,"PJM Final Zonal Net Load Price ($/MW-day) - Zone",{"$f":"Input!E113","v":174.13},null,"PJM RPM Final Zonal Net Load Price - Zone "]
[2,"Capacity Proxy Price ($/MW-day)","N/A"]
[]
[3,"Capacity Proxy Price True-Up - $/MW-day","N/A",null,"= line 1 - line 2 "]
[4,"BGS-RSCP Gen Obl - MW",{"$f":"SUM(bid_factors!C147:L147)","v":7858.5999999999985}]
[5,"Days in Year",365]
[6,"Capacity Proxy Price True-Up Annual Cost","N/A",null,"= line 3 * line 4 * line 5"]
[]
[7,"Eligible Tranches",28,null,"from Table A"]
[8,"Total Tranches",85,null,"from Table A"]
[9,"% of tranches eligible for payment",{"$f":"C12/C13","v":0.32941176470588235},null,"= line 7 / line 8"]
[]
[10,"Capacity Proxy Price True-Up Cost ",{"$f":"IFERROR(C10*9,0)","v":0},null,"= line 6 * line 9"]
[]
[11,"Total Applicable Customer Usage @ transmission nodes - in MWh",{"$f":"SUM(auction_results_and_rates!C20:C21)","v":25910440.182111792}]
[12,"Eligible Customer Usage @ transmission nodes - in MWh",{"$f":"C14*C18","v":8535203.8246956486},null,"= line 9 * line 11"]
[]
[13,"Capacity Proxy Price True-Up - $/MWh",{"$f":"IFERROR(ROUND(C16/C19,2),0)","v":0},null,"= line 10/ line 12 - rounded to 2 decimal places"]

{"sheet":"4-2","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Development of  Capacity Proxy Price True-Up - $/MWh"]
[null,"Using 2022/2023 Illustrative Data for PSE&G"]
[null,null,"2022/23\nDelivery Year",null,"Notes:"]
[1,{"$f":"'4-1'!B4","v":"PJM Final Zonal Net Load Price ($/MW-day) - Zone"},165,null,"PJM RPM Final Zonal Net Load Price - Zone - Illustative Only"]
[2,{"$f":"'4-1'!B5","v":"Capacity Proxy Price ($/MW-day)"},162.13,null,"per Board Order dated 11/13/2019"]
[]
[3,{"$f":"'4-1'!B7","v":"Capacity Proxy Price True-Up - $/MW-day"},{"$f":"+C4-C5","v":2.8700000000000045},null,"= line 1 - line 2 "]
[4,{"$f":"'4-1'!B8","v":"BGS-RSCP Gen Obl - MW"},{"$f":"SUM(bid_factors!C147:L147)","v":7858.5999999999985}]
[5,{"$f":"'4-1'!B9","v":"Days in Year"},365]
[6,{"$f":"'4-1'!B10","v":"Capacity Proxy Price True-Up Annual Cost"},{"$f":"C7*C8*C9","v":8232276.4300000109},null,"= line 3 * line 4 * line 5"]
[]
[7,{"$f":"'4-1'!B12","v":"Eligible Tranches"},28,null,"from Table A"]
[8,{"$f":"'4-1'!B13","v":"Total Tranches"},85,null,"from Table A"]
[9,{"$f":"'4-1'!B14","v":"% of tranches eligible for payment"},{"$f":"+C12/C13","v":0.32941176470588235},null,"= line 7 / line 8"]
[]
[10,{"$f":"'4-1'!B16","v":"Capacity Proxy Price True-Up Cost "},{"$f":"+C10*C14","v":2711808.706352945},null,"= line 6 * line 9"]
[]
[11,{"$f":"'4-1'!B18","v":"Total Applicable Customer Usage @ transmission nodes - in MWh"},{"$f":"SUM(auction_results_and_rates!C20:C21)","v":25910440.182111792}]
[12,{"$f":"'4-1'!B19","v":"Eligible Customer Usage @ transmission nodes - in MWh"},{"$f":"+C14*C18","v":8535203.8246956486},null,"= line 9 * line 11"]
[]
[13,{"$f":"'4-1'!B21","v":"Capacity Proxy Price True-Up - $/MWh"},{"$f":"ROUND(+C16/C19,2)","v":0.32},null,"= line 10/ line 12 - rounded to 2 decimal places"]

{"sheet":"4-3","index":5,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table A With Additional Line Item"]
["Calculation of June 2022 to May 2023 BGS-RSCP Rates"]
["Illustrative Purposes Only"]
["NJ Sales & Use Tax (SUT) excluded"]
[]
["Table A","Auction Results"]
["line #","Specific BGS-RSCP Auction >>","remaining portion of 36 month bid - 2020 auction","remaining portion of 36 month bid - 2021 auction","36 month bid - 2022 auction",null,"Notes:"]
[]
[1,"Winning Bid - in $/MWh",{"$f":"auction_results_and_rates!$E$8","v":98.04},{"$f":"auction_results_and_rates!$E$8","v":98.04},{"$f":"auction_results_and_rates!$E$8","v":98.04},null,"Winning Bid"]
["1A","Capacity Proxy Price True-up - in $/MWh",{"$f":"'4-2'!C21","v":0.32},null,null,null,"Entered after 2022 BGS Auction"]
[null,"Total - in $/MWh",{"$f":"+C9+C10","v":98.36},{"$f":"+D9+D10","v":98.04},{"$f":"+E9+E10","v":98.04},null,"= line 1 + line 1A"]
[]
[null,"      (includes all payments, including impact of PJM marginal losses)",null,null,null,null,{"$f":"C10/C9","v":3.2639738882088943E-3}]
[2,"# of Tranches for Bid",28,29,28]
[3,"Total # of Tranches",85,85,85]
[null,"Payment Factors"]
[4,"                           Summer",{"$f":"Input!C140","v":1},{"$f":"Input!D140","v":1},{"$f":"Input!E140","v":1}]
[5,"                           Winter",{"$f":"Input!C141","v":1},{"$f":"Input!D141","v":1},{"$f":"Input!E141","v":1}]
[]
[null,"Applicable Customer Usage @ transmission nodes - in MWh"]
[6,"                           Summer MWh",{"$f":"auction_results_and_rates!C20","v":10317899.913771585}]
[7,"                           Winter MWh",{"$f":"auction_results_and_rates!C21","v":15592540.268340206}]
[]
[null,"Total Payment to Suppliers - in $1000 "]
[8,"                           Summer",{"$f":"+C$9*C$14/C$15*C17*$C21/1000+C$10*C$14/C$15*$C21/1000","v":334309.66817082418},345122.82728045672,333222.04013285483,null,"= (1+1A) * (2)/(3) * (4) * (6) + (1A) * (2)/(3) * (6)"]
[9,"                           Winter",505212.98002624005,521553.96222746052,503569.34284030675,null,"= (1+1A) * (2)/(3) * (5) * (7) + (1A) * (2)/(3) * (7)"]
[10,"                           Total",{"$f":"+C26+C25","v":839522.64819706418},{"$f":"+D26+D25","v":866676.78950791724},{"$f":"+E26+E25","v":836791.38297316153},null,"Note: $ reflect total payment"]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":98.144999999999996},null,null,null,"= sum(line 8) / (6) - rounded to 3 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C26:E26)/C22*1000,3)","v":98.144999999999996},null,null,null,"= sum(line 9) / (7) - rounded to 3 decimal places"]
[]
[13,"                Total weighted average",{"$f":"ROUND(+SUM(C27:E27)/(C21+C22)*1000,3)","v":98.144999999999996},"   <<< used in calculation of",null,null,"= sum(line 10) / [ (6) + (7)]"]
[null,null,null,"           Customer Rates",null,null,"   rounded to 3 decimal places"]