{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","bid_factors","auction_results_and_rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"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],[114,2,114,3],[77,5,77,6]]}
[]
[]
[]
[]
[]
[]
[null,"Development of BGS-FP Cost and Bid Factors for 2017/18 BGS Filing"]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,"Based on average of year 2013,2014 & 2015 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.50229999999999997,0.49130000000000001,0.50870000000000004,0.45129999999999998,0.45129999999999998,0.49330000000000002,0.314,0.314,0.57599999999999996,0.56469999999999998]
[null,"February",0.49769999999999998,0.48599999999999999,0.50670000000000004,0.44569999999999999,0.44569999999999999,0.48299999999999998,0.29430000000000001,0.29430000000000001,0.57330000000000003,0.56430000000000002]
[null,"March",0.4793,0.48070000000000002,0.48599999999999999,0.45200000000000001,0.45200000000000001,0.47099999999999997,0.2437,0.2437,0.56299999999999994,0.55330000000000001]
[null,"April",0.52170000000000005,0.5363,0.52300000000000002,0.48770000000000002,0.48770000000000002,0.52729999999999999,0.23330000000000001,0.23330000000000001,0.60370000000000001,0.59630000000000005]
[null,"May",0.50170000000000003,0.51500000000000001,0.51200000000000001,0.43869999999999998,0.43869999999999998,0.5877,0.20830000000000001,0.20830000000000001,0.5857,0.57730000000000004]
[null,"June",0.51670000000000005,0.53,0.53269999999999995,0.44330000000000003,0.44330000000000003,0.63570000000000004,0.1973,0.1973,0.59399999999999997,0.57869999999999999]
[null,"July",0.54369999999999996,0.55630000000000002,0.56299999999999994,0.4713,0.4713,0.66200000000000003,0.20430000000000001,0.20430000000000001,0.61270000000000002,0.59]
[null,"August",0.51300000000000001,0.52769999999999995,0.53469999999999995,0.48530000000000001,0.48530000000000001,0.64270000000000005,0.2087,0.2087,0.58699999999999997,0.56569999999999998]
[null,"September",0.50670000000000004,0.53,0.52629999999999999,0.48930000000000001,0.48930000000000001,0.63900000000000001,0.23669999999999999,0.23669999999999999,0.59699999999999998,0.57599999999999996]
[null,"October",0.51870000000000005,0.53129999999999999,0.53069999999999995,0.51429999999999998,0.51429999999999998,0.58730000000000004,0.2777,0.2777,0.61199999999999999,0.59599999999999997]
[null,"November",0.46629999999999999,0.4597,0.4773,0.41199999999999998,0.41199999999999998,0.4713,0.29970000000000002,0.29970000000000002,0.55230000000000001,0.53769999999999996]
[null,"December",0.50670000000000004,0.50600000000000001,0.52329999999999999,0.45629999999999998,0.45629999999999998,0.50729999999999997,0.32300000000000001,0.32300000000000001,0.58069999999999999,0.56200000000000006]
[]
[null,null,null,null,"Based on average of year 2013, 2014 & 2015 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 2013, 2014 & 2015)"]
[null,null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RLM","LPL-S"]
[]
[null,"January",0.43140000000000001,0.48249999999999998]
[null,"February",0.42630000000000001,0.4854]
[null,"March",0.41899999999999998,0.4839]
[null,"April",0.42509999999999998,0.4889]
[null,"May",0.44230000000000003,0.50560000000000005]
[null,"June",0.46479999999999999,0.51439999999999997]
[null,"July",0.48270000000000002,0.51080000000000003]
[null,"August",0.48199999999999998,0.51]
[null,"September",0.48180000000000001,0.50880000000000003]
[null,"October",0.45829999999999999,0.51490000000000002]
[null,"November",0.43530000000000002,0.50739999999999996]
[null,"December",0.43099999999999999,0.49009999999999998]
[]
[]
["Table #3","Class Usage @ customer"]
[null,"calendar month sales forecasted for 2017, 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",1047801.5644843972,20621.732103439805,17929.801162539057,131,3,2444.0842304990306,16433,31380,539710.99454241025,620314.07130254607]
[null,"February",892336.6227910365,17413.413340415183,14526.847527491107,139,3,2058.3926073146276,14486,29833,501623.54270921013,604405.17614034086]
[null,"March",870769.90215152514,15370.175103800586,15198.679282931844,118,3,1949.8397410878872,13475,26173,520385.00999383314,619628.38235793461]
[null,"April",777804.32211723074,9283.9335479273177,14330.236569934941,129,3,1153.7853887584588,12345,23503,503200.94202805759,554546.5385125496]
[null,"May",805417.16649420199,6710.3228328723362,14698.299736923973,119,2,629.11320199588101,10458,21900,508931.40144848422,629428.58997085213]
[null,"June",1186987.6896451076,7341.1666004890412,22064.222104134828,93,3,869.24530001260939,10264,18101,551087.43885743455,608788.89691443788]
[null,"July",1580533.5953463644,8619.2773272224276,29515.870576062112,79,1,864.31107882048479,10333,18677,652433.31445574155,705867.60464526666]
[null,"August",1471181.6830488173,8239.6117825465244,25889.283624362601,78,2,795.23198213074102,11212,20782,634898.35230575269,701307.41501647851]
[null,"September",1018291.7686518352,6113.2915183438154,19569.77881798385,78,1,777.13983775961765,12484,21773,538797.20760435495,607362.16901544109]
[null,"October",782675.25217323285,7733.3910563119853,14777.503203238068,98,2,897.20588676798184,14901,24425,491590.56825689122,593086.42472986027]
[null,"November",787082.46220854821,10433.556952925601,12940.914590237107,106,2,1052.6338543199054,15525,28254,459447.19892385864,554753.61266676278]
[null,"December",980713.61842708557,15175.995016065581,16804.180135392857,115,2,1705.5957920777219,17052,31467,514456.36033973045,576323.18588737946]
[]
[]
[null,"LPL-S > 500 kW PLS","% of","% of"]
[null,null,"kWh","Gen Obl"]
[null,null,0.3887591935154856,0.3579282364326658]
[]
[]
[]
["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",52.53,null,"Summer",0.64162163177611842]
[null,"February",49.85,null,"Winter",0.69962854520404805]
[null,"March",40.31]
[null,"April",33.729999999999997]
[null,"May",33.630000000000003]
[null,"June",37.35,null,null,"Basis"]
[null,"July",45.53,null,null,"On-Peak","Off-Peak"]
[null,"August",41.6,null,"Summer",0.96359893118946383,0.91337074893074877]
[null,"September",35.39,null,"Winter",1.0962615127818722,1.0786547625250522]
[null,"October",33.72]
[null,"November",34.020000000000003]
[null,"December",38]
[]
[]
[]
["Table #6","Loss Type","Percentage","Source"]
[null,"Delivery Losses",7.5377E-2,"Tariff (Result of 2000 Loss Study)"]
[null,"EHV Losses",5.4999999999999997E-3,"PJM"]
[null,"Marginal Loss Deration Factor",1.2175565232170003E-2,"NERA"]
[]
[]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments"]
[null,"obligations - Peak Load shares eff 6/1/17, scaling factors eff 1/1/17, Transmission Loads eff 1/1/17; 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",3620.2438590151692,24.054579651008826,69.434657470195589,0,0,2.7853403471235012,0,0,1790.2102822282061,1402.6500020589795]
[null,"Tranmsission Obligation",3892.6433848899769,25.480412930542734,73.123743718335987,0,0,2.8285138229406002,0,0,1779.2805747545256,1379.1019954537435]
[]
[null,"Final Zonal RPM Scaling Factor",1.0624633824601797]
[null,"PJM June 1, 2016 (through May 31, 2017) Forecast Pool Requirement",1.0952]
[]
[null,"NITS Rate",null,"Tranches","NITS Rate"]
[null,null,2015,29,72688.289999999994]
[null,null,2016,28,82516.44]
[null,null,2017,28,91224.18]
[]
[null,null,null,null,"Base\nCapacity"]
[null,"Generation Capacity cost","summer =",null,178.95948526236626,"$/MW/day"]
[null,null,"winter =",null,178.95948526236626,"$/MW/day"]
[null,null,"Incremental RPM Capacity",null,31.1,"$/MW/day"]
[]
[]
[null,null,"RS","RHS"]
[null,"Required summer inversion =",0.86519999999999975,1.1569000000000003,"¢/kWh","(same as 2003/2004 BGS blocking inversion)"]
[]
[]
["Table #11","Ancillary Services & Renewable Power Cost"]
[null,"Ancillary Services ",null,2,"per MWh @  bulk system"]
[null,"Renewable Power Cost",null,8.57,"per MWh @  bulk system"]
[]
[]
[]
[]
["Bill Impacts","BGS - CIEP BRA Clearing Price ($ per MW/Day)"]
[null,"Annual Obligation Clearing Price",null,335.33,"per MWh"]
[]
[]
[]
[]
["auction results and rates","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2015 auction","remaining portion of 36 month bid - 2016 auction","36 month bid - 2017 auction"]
[null,"Winning Bid - in $/MWh",99.54,96.38,96.38]
[null,"# of Tranches for Bid",29,28,28]
[null,"Use Estimated amount in cell e134",null,null,"Yes"]
[null,"Payment Factors"]
[null,"                           Summer",1,1]
[null,"                           Winter",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":"\"Development of BGS-RSCP Cost and Bid Factors for \"&(Input!D2)&\"/\"&(Input!D2+1)&\" BGS Filing\"","v":"Development of BGS-RSCP Cost and Bid Factors for /1 BGS Filing"}]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2013,2014 & 2015 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.50229999999999997},{"$f":"Input!D14","v":0.49130000000000001},{"$f":"Input!E14","v":0.50870000000000004},{"$f":"Input!F14","v":0.45129999999999998},{"$f":"Input!G14","v":0.45129999999999998},{"$f":"Input!H14","v":0.49330000000000002},{"$f":"Input!I14","v":0.314},{"$f":"Input!J14","v":0.314},{"$f":"Input!K14","v":0.57599999999999996},{"$f":"Input!L14","v":0.56469999999999998},null,null,{"$f":"1-C9","v":0.49770000000000003},0.50869999999999993,0.49129999999999996,0.54869999999999997,0.54869999999999997,0.50669999999999993,0.68599999999999994,0.68599999999999994,0.42400000000000004,0.43530000000000002]
[null,"February",{"$f":"Input!C15","v":0.49769999999999998},{"$f":"Input!D15","v":0.48599999999999999},{"$f":"Input!E15","v":0.50670000000000004},{"$f":"Input!F15","v":0.44569999999999999},{"$f":"Input!G15","v":0.44569999999999999},{"$f":"Input!H15","v":0.48299999999999998},{"$f":"Input!I15","v":0.29430000000000001},{"$f":"Input!J15","v":0.29430000000000001},{"$f":"Input!K15","v":0.57330000000000003},{"$f":"Input!L15","v":0.56430000000000002},null,null,{"$f":"1-C10","v":0.50229999999999997},{"$f":"1-D10","v":0.51400000000000001},{"$f":"1-E10","v":0.49329999999999996},{"$f":"1-F10","v":0.55430000000000001},{"$f":"1-G10","v":0.55430000000000001},{"$f":"1-H10","v":0.51700000000000002},{"$f":"1-I10","v":0.70569999999999999},{"$f":"1-J10","v":0.70569999999999999},{"$f":"1-K10","v":0.42669999999999997},{"$f":"1-L10","v":0.43569999999999998}]
[null,"March",{"$f":"Input!C16","v":0.4793},{"$f":"Input!D16","v":0.48070000000000002},{"$f":"Input!E16","v":0.48599999999999999},{"$f":"Input!F16","v":0.45200000000000001},{"$f":"Input!G16","v":0.45200000000000001},{"$f":"Input!H16","v":0.47099999999999997},{"$f":"Input!I16","v":0.2437},{"$f":"Input!J16","v":0.2437},{"$f":"Input!K16","v":0.56299999999999994},{"$f":"Input!L16","v":0.55330000000000001},null,null,0.52069999999999994,0.51929999999999998,0.51400000000000001,0.54800000000000004,0.54800000000000004,0.52900000000000003,0.75629999999999997,0.75629999999999997,0.43700000000000006,0.44669999999999999]
[null,"April",{"$f":"Input!C17","v":0.52170000000000005},{"$f":"Input!D17","v":0.5363},{"$f":"Input!E17","v":0.52300000000000002},{"$f":"Input!F17","v":0.48770000000000002},{"$f":"Input!G17","v":0.48770000000000002},{"$f":"Input!H17","v":0.52729999999999999},{"$f":"Input!I17","v":0.23330000000000001},{"$f":"Input!J17","v":0.23330000000000001},{"$f":"Input!K17","v":0.60370000000000001},{"$f":"Input!L17","v":0.59630000000000005},null,null,0.47829999999999995,0.4637,0.47699999999999998,0.51229999999999998,0.51229999999999998,0.47270000000000001,0.76669999999999994,0.76669999999999994,0.39629999999999999,0.40369999999999995]
[null,"May",{"$f":"Input!C18","v":0.50170000000000003},{"$f":"Input!D18","v":0.51500000000000001},{"$f":"Input!E18","v":0.51200000000000001},{"$f":"Input!F18","v":0.43869999999999998},{"$f":"Input!G18","v":0.43869999999999998},{"$f":"Input!H18","v":0.5877},{"$f":"Input!I18","v":0.20830000000000001},{"$f":"Input!J18","v":0.20830000000000001},{"$f":"Input!K18","v":0.5857},{"$f":"Input!L18","v":0.57730000000000004},null,null,0.49829999999999997,0.48499999999999999,0.48799999999999999,0.56130000000000002,0.56130000000000002,0.4123,0.79169999999999996,0.79169999999999996,0.4143,0.42269999999999996]
[null,"June",{"$f":"Input!C19","v":0.51670000000000005},{"$f":"Input!D19","v":0.53},{"$f":"Input!E19","v":0.53269999999999995},{"$f":"Input!F19","v":0.44330000000000003},{"$f":"Input!G19","v":0.44330000000000003},{"$f":"Input!H19","v":0.63570000000000004},{"$f":"Input!I19","v":0.1973},{"$f":"Input!J19","v":0.1973},{"$f":"Input!K19","v":0.59399999999999997},{"$f":"Input!L19","v":0.57869999999999999},null,null,0.48329999999999995,0.47,0.46730000000000005,0.55669999999999997,0.55669999999999997,0.36429999999999996,0.80269999999999997,0.80269999999999997,0.40600000000000003,0.42130000000000001]
[null,"July",{"$f":"Input!C20","v":0.54369999999999996},{"$f":"Input!D20","v":0.55630000000000002},{"$f":"Input!E20","v":0.56299999999999994},{"$f":"Input!F20","v":0.4713},{"$f":"Input!G20","v":0.4713},{"$f":"Input!H20","v":0.66200000000000003},{"$f":"Input!I20","v":0.20430000000000001},{"$f":"Input!J20","v":0.20430000000000001},{"$f":"Input!K20","v":0.61270000000000002},{"$f":"Input!L20","v":0.59},null,null,0.45630000000000004,0.44369999999999998,0.43700000000000006,0.52869999999999995,0.52869999999999995,0.33799999999999997,0.79569999999999996,0.79569999999999996,0.38729999999999998,0.41000000000000003]
[null,"August",{"$f":"Input!C21","v":0.51300000000000001},{"$f":"Input!D21","v":0.52769999999999995},{"$f":"Input!E21","v":0.53469999999999995},{"$f":"Input!F21","v":0.48530000000000001},{"$f":"Input!G21","v":0.48530000000000001},{"$f":"Input!H21","v":0.64270000000000005},{"$f":"Input!I21","v":0.2087},{"$f":"Input!J21","v":0.2087},{"$f":"Input!K21","v":0.58699999999999997},{"$f":"Input!L21","v":0.56569999999999998},null,null,0.48699999999999999,0.47230000000000005,0.46530000000000005,0.51469999999999994,0.51469999999999994,0.35729999999999995,0.7913,0.7913,0.41300000000000003,0.43430000000000002]
[null,"September",{"$f":"Input!C22","v":0.50670000000000004},{"$f":"Input!D22","v":0.53},{"$f":"Input!E22","v":0.52629999999999999},{"$f":"Input!F22","v":0.48930000000000001},{"$f":"Input!G22","v":0.48930000000000001},{"$f":"Input!H22","v":0.63900000000000001},{"$f":"Input!I22","v":0.23669999999999999},{"$f":"Input!J22","v":0.23669999999999999},{"$f":"Input!K22","v":0.59699999999999998},{"$f":"Input!L22","v":0.57599999999999996},null,null,0.49329999999999996,0.47,0.47370000000000001,0.51069999999999993,0.51069999999999993,0.36099999999999999,0.76329999999999998,0.76329999999999998,0.40300000000000002,0.42400000000000004]
[null,"October",{"$f":"Input!C23","v":0.51870000000000005},{"$f":"Input!D23","v":0.53129999999999999},{"$f":"Input!E23","v":0.53069999999999995},{"$f":"Input!F23","v":0.51429999999999998},{"$f":"Input!G23","v":0.51429999999999998},{"$f":"Input!H23","v":0.58730000000000004},{"$f":"Input!I23","v":0.2777},{"$f":"Input!J23","v":0.2777},{"$f":"Input!K23","v":0.61199999999999999},{"$f":"Input!L23","v":0.59599999999999997},null,null,0.48129999999999995,0.46870000000000001,0.46930000000000005,0.48570000000000002,0.48570000000000002,0.41269999999999996,0.72229999999999994,0.72229999999999994,0.38800000000000001,0.40400000000000003]
[null,"November",{"$f":"Input!C24","v":0.46629999999999999},{"$f":"Input!D24","v":0.4597},{"$f":"Input!E24","v":0.4773},{"$f":"Input!F24","v":0.41199999999999998},{"$f":"Input!G24","v":0.41199999999999998},{"$f":"Input!H24","v":0.4713},{"$f":"Input!I24","v":0.29970000000000002},{"$f":"Input!J24","v":0.29970000000000002},{"$f":"Input!K24","v":0.55230000000000001},{"$f":"Input!L24","v":0.53769999999999996},null,null,0.53370000000000006,0.5403,0.52269999999999994,0.58800000000000008,0.58800000000000008,0.52869999999999995,0.70029999999999992,0.70029999999999992,0.44769999999999999,0.46230000000000004]
[null,"December",{"$f":"Input!C25","v":0.50670000000000004},{"$f":"Input!D25","v":0.50600000000000001},{"$f":"Input!E25","v":0.52329999999999999},{"$f":"Input!F25","v":0.45629999999999998},{"$f":"Input!G25","v":0.45629999999999998},{"$f":"Input!H25","v":0.50729999999999997},{"$f":"Input!I25","v":0.32300000000000001},{"$f":"Input!J25","v":0.32300000000000001},{"$f":"Input!K25","v":0.58069999999999999},{"$f":"Input!L25","v":0.56200000000000006},null,null,0.49329999999999996,0.49399999999999999,0.47670000000000001,0.54370000000000007,0.54370000000000007,0.49270000000000003,0.67700000000000005,0.67700000000000005,0.41930000000000001,0.43799999999999994]
[]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2013,2014 & 2015 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 2013, 2014 & 2015)"]
[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.43140000000000001},0,0,0,0,0,0,{"$f":"Input!D32","v":0.48249999999999998},null,null,null,null,{"$f":"1-E27","v":0.56859999999999999},null,null,null,null,null,null,{"$f":"1-L27","v":0.51750000000000007}]
[null,"February",0,0,{"$f":"Input!C33","v":0.42630000000000001},0,0,0,0,0,0,{"$f":"Input!D33","v":0.4854},null,null,null,null,0.57369999999999999,null,null,null,null,null,null,0.51459999999999995]
[null,"March",0,0,{"$f":"Input!C34","v":0.41899999999999998},0,0,0,0,0,0,{"$f":"Input!D34","v":0.4839},null,null,null,null,0.58099999999999996,null,null,null,null,null,null,0.5161]
[null,"April",0,0,{"$f":"Input!C35","v":0.42509999999999998},0,0,0,0,0,0,{"$f":"Input!D35","v":0.4889},null,null,null,null,0.57489999999999997,null,null,null,null,null,null,0.5111]
[null,"May",0,0,{"$f":"Input!C36","v":0.44230000000000003},0,0,0,0,0,0,{"$f":"Input!D36","v":0.50560000000000005},null,null,null,null,0.55769999999999997,null,null,null,null,null,null,0.49439999999999995]
[null,"June",0,0,{"$f":"Input!C37","v":0.46479999999999999},0,0,0,0,0,0,{"$f":"Input!D37","v":0.51439999999999997},null,null,null,null,0.53520000000000001,null,null,null,null,null,null,0.48560000000000003]
[null,"July",0,0,{"$f":"Input!C38","v":0.48270000000000002},0,0,0,0,0,0,{"$f":"Input!D38","v":0.51080000000000003},null,null,null,null,0.51729999999999998,null,null,null,null,null,null,0.48919999999999997]
[null,"August",0,0,{"$f":"Input!C39","v":0.48199999999999998},0,0,0,0,0,0,{"$f":"Input!D39","v":0.51},null,null,null,null,0.51800000000000002,null,null,null,null,null,null,0.49]
[null,"September",0,0,{"$f":"Input!C40","v":0.48180000000000001},0,0,0,0,0,0,{"$f":"Input!D40","v":0.50880000000000003},null,null,null,null,0.51819999999999999,null,null,null,null,null,null,0.49119999999999997]
[null,"October",0,0,{"$f":"Input!C41","v":0.45829999999999999},0,0,0,0,0,0,{"$f":"Input!D41","v":0.51490000000000002},null,null,null,null,0.54170000000000007,null,null,null,null,null,null,0.48509999999999998]
[null,"November",0,0,{"$f":"Input!C42","v":0.43530000000000002},0,0,0,0,0,0,{"$f":"Input!D42","v":0.50739999999999996},null,null,null,null,0.56469999999999998,null,null,null,null,null,null,0.49260000000000004]
[null,"December",0,0,{"$f":"Input!C43","v":0.43099999999999999},0,0,0,0,0,0,{"$f":"Input!D43","v":0.49009999999999998},null,null,null,null,0.56899999999999995,null,null,null,null,null,null,0.50990000000000002]
[]
[]
["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":"\"calendar month sales forecasted for \"&(Input!D2)&\", less % for LPL-Sec > 500 kW Peak Load Share\"","v":"calendar month sales forecasted for , 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":1047801.5644843972},{"$f":"Input!D50","v":20621.732103439805},{"$f":"Input!E50","v":17929.801162539057},{"$f":"Input!F50","v":131},{"$f":"Input!G50","v":3},{"$f":"Input!H50","v":2444.0842304990306},{"$f":"Input!I50","v":16433},{"$f":"Input!J50","v":31380},{"$f":"Input!K50","v":539710.99454241025},{"$f":"AB45*$M$45","v":379161.27321666083},{"$f":"(1-AD45)","v":0.6112408064845144},"winter MWh =",{"$f":"SUM(C45:C49,C54:C56)","v":6944600.9108472588},{"$f":"SUM(D45:D49,D54:D56)","v":102742.5199537584},121206.46220868896,955,20,11890.650702821495,114675,216935,4039346.018242476,2904913.3641801113,{"$f":"SUM(O45:X45)","v":14457284.926135115},{"$f":"+Y45/(Y45+Y49)","v":0.60365456263072226},null,{"$f":"Input!L50","v":620314.07130254607},null,{"$f":"Input!C66","v":0.3887591935154856},{"$f":"Input!D66","v":0.3579282364326658},{"$f":"AE45","v":0.3579282364326658}]
[null,"February",{"$f":"Input!C51","v":892336.6227910365},{"$f":"Input!D51","v":17413.413340415183},{"$f":"Input!E51","v":14526.847527491107},{"$f":"Input!F51","v":139},{"$f":"Input!G51","v":3},{"$f":"Input!H51","v":2058.3926073146276},{"$f":"Input!I51","v":14486},{"$f":"Input!J51","v":29833},{"$f":"Input!K51","v":501623.54270921013},{"$f":"AB46*$M$45","v":369437.10730743693},null,"on-peak",null,null,{"$f":"SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56)","v":52537.110959086611},null,null,null,null,null,null,{"$f":"SUMPRODUCT(L27:L31,L45:L49)+SUMPRODUCT(L36:L38,L54:L56)","v":1437145.1424745168},null,null,null,{"$f":"Input!L51","v":604405.17614034086}]
[null,"March",{"$f":"Input!C52","v":870769.90215152514},{"$f":"Input!D52","v":15370.175103800586},{"$f":"Input!E52","v":15198.679282931844},{"$f":"Input!F52","v":118},{"$f":"Input!G52","v":3},{"$f":"Input!H52","v":1949.8397410878872},{"$f":"Input!I52","v":13475},{"$f":"Input!J52","v":26173},{"$f":"Input!K52","v":520385.00999383314},378742.15215315903,null,"off-peak",{"$f":"+O45-O46","v":6944600.9108472588},{"$f":"+P45-P46","v":102742.5199537584},{"$f":"+Q45-Q46","v":68669.351249602347},{"$f":"+R45-R46","v":955},null,null,null,null,null,{"$f":"+X45-X46","v":1467768.2217055946},null,null,null,{"$f":"Input!L52","v":619628.38235793461}]
[null,"April",{"$f":"Input!C53","v":777804.32211723074},{"$f":"Input!D53","v":9283.9335479273177},{"$f":"Input!E53","v":14330.236569934941},{"$f":"Input!F53","v":129},{"$f":"Input!G53","v":3},{"$f":"Input!H53","v":1153.7853887584588},{"$f":"Input!I53","v":12345},{"$f":"Input!J53","v":23503},{"$f":"Input!K53","v":503200.94202805759},338961.47343360662,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L53","v":554546.5385125496}]
[null,"May",{"$f":"Input!C54","v":805417.16649420199},{"$f":"Input!D54","v":6710.3228328723362},{"$f":"Input!E54","v":14698.299736923973},{"$f":"Input!F54","v":119},{"$f":"Input!G54","v":2},{"$f":"Input!H54","v":629.11320199588101},{"$f":"Input!I54","v":10458},{"$f":"Input!J54","v":21900},{"$f":"Input!K54","v":508931.40144848422},384732.4389581944,null,"summer MWh =",{"$f":"SUM(C50:C53)","v":5256994.736692125},{"$f":"+SUM(D50:D53)","v":30313.347228601808},97039.155122543394,328,7,3305.9281987234526,44293,79333,2377216.3132232837,1603483.9522288886,{"$f":"SUM(O49:X49)","v":9492314.432694165},{"$f":"1-Z45","v":0.39634543736927774},null,{"$f":"Input!L54","v":629428.58997085213}]
[null,"June",{"$f":"Input!C55","v":1186987.6896451076},{"$f":"Input!D55","v":7341.1666004890412},{"$f":"Input!E55","v":22064.222104134828},{"$f":"Input!F55","v":93},{"$f":"Input!G55","v":3},{"$f":"Input!H55","v":869.24530001260939},{"$f":"Input!I55","v":10264},{"$f":"Input!J55","v":18101},{"$f":"Input!K55","v":551087.43885743455},372116.61632879893,null,"on-peak",null,null,{"$f":"+SUMPRODUCT(E32:E35,E50:E53)","v":46410.115302514445},null,null,null,null,null,null,{"$f":"+SUMPRODUCT(L32:L35,L50:L53)","v":819313.79936530697},null,null,null,{"$f":"Input!L55","v":608788.89691443788}]
[null,"July",{"$f":"Input!C56","v":1580533.5953463644},{"$f":"Input!D56","v":8619.2773272224276},{"$f":"Input!E56","v":29515.870576062112},{"$f":"Input!F56","v":79},{"$f":"Input!G56","v":1},{"$f":"Input!H56","v":864.31107882048479},{"$f":"Input!I56","v":10333},{"$f":"Input!J56","v":18677},{"$f":"Input!K56","v":652433.31445574155},431455.08393466513,null,"off-peak",null,null,{"$f":"+Q49-Q50","v":50629.039820028949},null,null,null,null,null,null,{"$f":"+X49-X50","v":784170.15286358166},null,null,null,{"$f":"Input!L56","v":705867.60464526666}]
[null,"August",{"$f":"Input!C57","v":1471181.6830488173},{"$f":"Input!D57","v":8239.6117825465244},{"$f":"Input!E57","v":25889.283624362601},{"$f":"Input!F57","v":78},{"$f":"Input!G57","v":2},{"$f":"Input!H57","v":795.23198213074102},{"$f":"Input!I57","v":11212},{"$f":"Input!J57","v":20782},{"$f":"Input!K57","v":634898.35230575269},428667.70994824235,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L57","v":701307.41501647851}]
[null,"September",{"$f":"Input!C58","v":1018291.7686518352},{"$f":"Input!D58","v":6113.2915183438154},{"$f":"Input!E58","v":19569.77881798385},{"$f":"Input!F58","v":78},{"$f":"Input!G58","v":1},{"$f":"Input!H58","v":777.13983775961765},{"$f":"Input!I58","v":12484},{"$f":"Input!J58","v":21773},{"$f":"Input!K58","v":538797.20760435495},371244.54201718216,null,"Block 1",{"$f":"+O49*C163","v":3401275.5946398051},{"$f":"+P49*D163","v":19188.348795704944},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L58","v":607362.16901544109}]
[null,"October",{"$f":"Input!C59","v":782675.25217323285},{"$f":"Input!D59","v":7733.3910563119853},{"$f":"Input!E59","v":14777.503203238068},{"$f":"Input!F59","v":98},{"$f":"Input!G59","v":2},{"$f":"Input!H59","v":897.20588676798184},{"$f":"Input!I59","v":14901},{"$f":"Input!J59","v":24425},{"$f":"Input!K59","v":491590.56825689122},362518.62456689705,null,"Block 2",{"$f":"+O49-O53","v":1855719.1420523198},{"$f":"+P49-P53","v":11124.998432896864},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L59","v":593086.42472986027}]
[null,"November",{"$f":"Input!C60","v":787082.46220854821},{"$f":"Input!D60","v":10433.556952925601},{"$f":"Input!E60","v":12940.914590237107},{"$f":"Input!F60","v":106},{"$f":"Input!G60","v":2},{"$f":"Input!H60","v":1052.6338543199054},{"$f":"Input!I60","v":15525},{"$f":"Input!J60","v":28254},{"$f":"Input!K60","v":459447.19892385864},339088.04560662998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L60","v":554753.61266676278}]
[null,"December",{"$f":"Input!C61","v":980713.61842708557},{"$f":"Input!D61","v":15175.995016065581},{"$f":"Input!E61","v":16804.180135392857},{"$f":"Input!F61","v":115},{"$f":"Input!G61","v":2},{"$f":"Input!H61","v":1705.5957920777219},{"$f":"Input!I61","v":17052},{"$f":"Input!J61","v":31467},{"$f":"Input!K61","v":514456.36033973045},352272.24893752654,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L61","v":576323.18588737946}]
[null,"Total",{"$f":"SUM(C45:C56)","v":12201595.647539385},{"$f":"SUM(D45:D56)","v":133055.86718236021},{"$f":"SUM(E45:E56)","v":218245.61733123232},1283,27,{"$f":"SUM(H45:H56)","v":15196.578901544948},{"$f":"SUM(I45:I56)","v":158968},{"$f":"SUM(J45:J56)","v":296268},6416562.3314657593,{"$f":"SUM(L45:L56)","v":4508397.3164090002},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":7375812.0671598502}]
[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":3467562.7802706445},{"$f":"SUMPRODUCT(D9:D13,D45:D49)+SUMPRODUCT(D18:D20,D54:D56)","v":51001.719136549014},61701.191765178992,436.07510000000002,9.1526999999999994,5984.6498607566818,32064.185400000002,60470.939200000001,2346645.525237008,1652738.2733118488,{"$f":"SUM(O61:X61)","v":7678614.491981986},{"$f":"+Y61/(Y61+Y62)","v":0.53112424159954075}]
[null,null,"On-Peak","LMP ratio","Off-Peak",null,null,"On-Peak","Off-Peak",null,null,null,null,"off-peak",{"$f":"+O45-O61","v":3477038.1305766143},{"$f":"+P45-P61","v":51740.800817209383},59505.270443509966,518.92489999999998,10.847300000000001,5906.0008420648128,82610.814599999998,156464.06080000001,1692700.493005468,1252175.0908682626,{"$f":"SUM(O62:X62)","v":6778670.4341531284},{"$f":"1-Z61","v":0.46887575840045925}]
[null,"January",{"$f":"Input!C73","v":52.53},{"$f":"Input!F74","v":0.69962854520404805},{"$f":"ROUND(+C63*D63,3)","v":36.750999999999998},null,null,{"$f":"Input!F81","v":1.0962615127818722},{"$f":"Input!G81","v":1.0786547625250522},"NYMEX Forwards (January 6, 2017) from NERA"]
[null,"February",{"$f":"Input!C74","v":49.85},{"$f":"+$D$63","v":0.69962854520404805},{"$f":"ROUND(+C64*D64,3)","v":34.875999999999998},null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522},null,null,null,null,"Summer"]
[null,"March",{"$f":"Input!C75","v":40.31},{"$f":"+$D$63","v":0.69962854520404805},{"$f":"ROUND(+C65*D65,3)","v":28.202000000000002},null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522},"Congestion Factors & On/Off Peak Ratios ",null,null,null,"on-peak",{"$f":"SUMPRODUCT(C14:C17,C50:C53)","v":2743337.2976093739},{"$f":"SUMPRODUCT(D14:D17,D50:D53)","v":16273.809917765053},52513.620795047173,154.47839999999999,3.2611000000000003,2132.4411226409993,9431.0262999999995,16877.910899999999,1421439.0961916258,926236.56511054595,5188399.5074469987,{"$f":"+Y65/(Y65+Y66)","v":0.54658951136054978}]
[null,"April",{"$f":"Input!C76","v":33.729999999999997},{"$f":"+$D$63","v":0.69962854520404805},23.597999999999999,null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522},"Averages for Aug 2013- Sept 2016",null,null,null,"off-peak",{"$f":"+O49-O65","v":2513657.4390827511},{"$f":"+P49-P65","v":14039.537310836755},44525.534327496222,173.52160000000001,3.7388999999999997,1173.4870760824533,34861.973700000002,62455.089099999997,955777.21703165793,677247.38711834268,4303914.9252471672,{"$f":"1-Z65","v":0.45341048863945022}]
[null,"May",{"$f":"Input!C77","v":33.630000000000003},{"$f":"+$D$63","v":0.69962854520404805},23.529,null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522}]
[null,"June",{"$f":"Input!C78","v":37.35},{"$f":"Input!F73","v":0.64162163177611842},23.965,null,null,{"$f":"Input!F80","v":0.96359893118946383},{"$f":"Input!G80","v":0.91337074893074877},null,null,null,null,"Total on-peak",{"$f":"+O61+O65","v":6210900.0778800184},{"$f":"+P61+P65","v":67275.529054314073},114214.81256022616,590.55349999999999,12.4138,8117.0909833976812,41495.2117,77348.850099999996,3768084.621428634,2578974.8384223948,12867013.999428986,{"$f":"+Y68/(Y68+Y69)","v":0.53725383070700183}]
[null,"July",{"$f":"Input!C79","v":45.53},{"$f":"+$D$68","v":0.64162163177611842},29.213000000000001,null,null,{"$f":"+$H$68","v":0.96359893118946383},{"$f":"+$I$68","v":0.91337074893074877},null,null,null,null,"Total off-peak",{"$f":"+O62+O66","v":5990695.5696593653},{"$f":"+P62+P66","v":65780.338128046133},104030.80477100619,692.44650000000001,14.5862,7079.4879181472661,117472.7883,218919.14990000002,2648477.7100371262,1929422.4779866054,11082585.359400297,{"$f":"1-Z68","v":0.46274616929299817}]
[null,"August",{"$f":"Input!C80","v":41.6},{"$f":"+$D$68","v":0.64162163177611842},26.690999999999999,null,null,{"$f":"+$H$68","v":0.96359893118946383},{"$f":"+$I$68","v":0.91337074893074877}]
[null,"September",{"$f":"Input!C81","v":35.39},{"$f":"+$D$68","v":0.64162163177611842},22.707000000000001,null,null,{"$f":"+$H$68","v":0.96359893118946383},{"$f":"+$I$68","v":0.91337074893074877}]
[null,"October",{"$f":"Input!C82","v":33.72},{"$f":"+$D$63","v":0.69962854520404805},23.591000000000001,null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522}]
[null,"November",{"$f":"Input!C83","v":34.020000000000003},{"$f":"+$D$63","v":0.69962854520404805},23.800999999999998,null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522}]
[null,"December",{"$f":"Input!C84","v":38},{"$f":"+$D$63","v":0.69962854520404805},26.585999999999999,null,null,{"$f":"+$H$63","v":1.0962615127818722},{"$f":"+$I$63","v":1.0786547625250522}]
[]
[]
["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":7.5377E-2},"Tariff (Result of 2000 Loss Study)"]
[null,"     Loss Factors =",{"$f":"1-((1-$Q$78)*(1-$Q$79))","v":8.0462426500000017E-2},{"$f":"+$C79","v":8.0462426500000017E-2},{"$f":"+$C79","v":8.0462426500000017E-2},8.0462426500000017E-2,8.0462426500000017E-2,8.0462426500000017E-2,8.0462426500000017E-2,8.0462426500000017E-2,8.0462426500000017E-2,8.0462426500000017E-2,null,null,null,"EHV Losses",{"$f":"Input!C90","v":5.4999999999999997E-3},"PJM"]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C79),6)","v":1.0875030000000001},{"$f":"ROUND(1/(1-D79),6)","v":1.0875030000000001},1.0875030000000001,1.0875030000000001,1.0875030000000001,1.0875030000000001,1.0875030000000001,1.0875030000000001,1.0875030000000001,1.0875030000000001,null,null,null,"Marginal Loss Deration Factor",{"$f":"+Input!C91","v":1.2175565232170003E-2},"NERA"]
[null,"     1 / Expansion Factor =",{"$f":"1/C80","v":0.91953769322935197},{"$f":"1/D80","v":0.91953769322935197},0.91953769322935197,0.91953769322935197,0.91953769322935197,0.91953769322935197,0.91953769322935197,0.91953769322935197,0.91953769322935197,0.91953769322935197,null,null,null,"Marginal Loss Factor",{"$f":"ROUND(1-((1-Q80)/(1-Q79)),7)","v":6.7124999999999997E-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":6.9128540319899567E-2},{"$f":"+$C84","v":6.9128540319899567E-2},{"$f":"+$C84","v":6.9128540319899567E-2},6.9128540319899567E-2,6.9128540319899567E-2,6.9128540319899567E-2,6.9128540319899567E-2,6.9128540319899567E-2,6.9128540319899567E-2,6.9128540319899567E-2]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C84),6)","v":1.0742620000000001},{"$f":"+$C$85","v":1.0742620000000001},{"$f":"+$C$85","v":1.0742620000000001},1.0742620000000001,1.0742620000000001,1.0742620000000001,1.0742620000000001,1.0742620000000001,1.0742620000000001,1.0742620000000001]
[null,"     1 / Expansion Factor =",{"$f":"1/C85","v":0.93087161232548477},{"$f":"1/D85","v":0.93087161232548477},0.93087161232548477,0.93087161232548477,0.93087161232548477,0.93087161232548477,0.93087161232548477,0.93087161232548477,0.93087161232548477,0.93087161232548477]
[]
[]
["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":34.610764746828011},34.699142851232615,34.898052744716324,33.118297940644986,32.700446829785562,36.14708860248377,28.817525043545373,28.865209590537873,35.574340542025517,35.189868023688611]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80)/SUMPRODUCT(C14:C17,C50:C53)","v":42.663746604031275},42.446326873737007,42.62338262442492,41.789602438138914,41.395889132714217,42.028834493417243,41.519888354963648,41.594927322011785,42.253257653255211,42.187355205634638]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUMPRODUCT(O14:O17,C50:C53)","v":25.821959580958296},25.719060574385214,25.786763010700962,25.39862935364679,25.116208980663998,25.45887816848153,25.381221537236978,25.425120964453971,25.641404568086454,25.619763191850819]
[]
[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":40.330933016732622},42.064660406474808,40.262275404505694,39.597360837613508,40.004118634290116,42.370637744246579,36.933518214566959,37.116563675009914,41.085830464429996,40.884964980920827]
[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":47.770795298809034},49.780138530714211,47.501518324115708,47.572407708251276,48.023586741879932,49.880481702693004,48.092942630691773,48.375990178537407,47.185034408762242,47.165250515646107]
[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":32.911345261050073},34.459392569843956,32.755882907027534,32.895583062798586,33.237477557862121,34.760786712713724,32.602150037549691,32.764969500345124,32.63030646439713,32.595654367522535]
[]
[null,"Annual",{"$f":"(C94*SUM(C50:C53)+C98*SUM(C45:C49,C54:C56))/C57","v":37.866427934239901},40.386617221318524,37.877166181418126,37.940983105574794,38.110574092381526,41.01674047979035,34.672171996937884,34.907061894245807,39.043926548145166,38.859412232037727]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C102:L102,C57:L57)/SUM(C57:L57)","v":38.327118597975563}]
[]
[]
["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":181948.60810696421},1051.8471657842706,3386.4775537692285,10.862801724531556,0.22890312780849895,119.49967951270621,1276.4146367537551,2289.9636724461411,84567.90266866349,56426.388657037205]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C50:C53,C14:C17)*C95/1000","v":117041.04731459425},690.76345525051863,2238.3081521412528,6.4555909212797982,0.13499613405069433,89.624015010435429,391.57515904872582,702.03547723289046,60060.432369794988,39075.470976765537]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C50:C53,O14:O17)*C96/1000","v":64907.560792369943},361.0837105337518,1148.1694016279755,4.4072108032517567,9.3906993757804619E-2,29.875664502270787,884.83947770502914,1587.9281952132505,24507.470298868513,17350.917680271657]
[]
[null,"Winter - all hrs",{"$f":"SUM(C45:C49,C54:C56)*C98/1000","v":280082.23416332115},4321.8292111603087,4880.0479622520461,37.815479599920899,0.80008237268580229,503.81445347262053,4235.3512012554656,8051.8817408382756,165959.88569268072,118767.28116711277]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C45:C49,C9:C13)+SUMPRODUCT(C54:C56,C18:C20))*C99/1000","v":165648.23176207807},2538.8726439219881,2930.900291253427,20.745142448616448,0.43954548237240443,298.51721787649791,1542.0610289420649,2925.3415608261325,110726.54985347617,77951.814697549737]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C45:C49,O9:O13)+SUMPRODUCT(C54:C56,O18:O20))*C100/1000","v":114434.00240124304},1782.956567238321,1949.1476709986189,17.070337151304447,0.36053689031339781,205.29723559612256,2693.2901723134005,5126.5401800121444,55233.335839204519,40815.466469563005]
[]
[null,"Annual",{"$f":"+C112+C116","v":462030.84227028536},{"$f":"+D112+D116","v":5373.6763769445788},8266.5255160212746,48.678281324452456,1.0289855004943012,623.31413298532675,5511.7658380092207,10341.845413284416,250527.7883613442,175193.66982414998]
[]
[null,"System Total",{"$f":"SUM(C120:L120)","v":917919.13499984937}]
[]
[]
["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":34.610764746828011},34.699142851232622,34.898052744716324,33.118297940644993,32.700446829785562,36.147088602483763,28.81752504354537,28.865209590537876,35.574340542025517,35.189868023688611]
[null,"PSE&G On pk",null,null,{"$f":"+(E113*1000-W131*AVERAGE(E$95,E$96))/Q131","v":43.730494722921271},null,null,null,null,null,null,{"$f":"+(L113*1000-X131*AVERAGE(L$95,L$96))/R131","v":43.268413989964145},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,E32:E35)","v":46410.115302514445},{"$f":"SUMPRODUCT(L50:L53,L32:L35)","v":819313.79936530697},null,{"$f":"SUMPRODUCT(E50:E53,E14:E17)","v":52513.620795047173},{"$f":"SUMPRODUCT(L50:L53,L14:L17)","v":926236.56511054595},null,{"$f":"+T131-Q131","v":6103.5054925327277},{"$f":"+U131-R131","v":106922.76574523898},null,{"$f":"+E131*Q131/1000","v":2029.5373023267757},{"$f":"+L131*R131/1000","v":35450.408658628527}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E114*1000-W132*AVERAGE(E$95,E$96))/Q132","v":26.801619313065554},null,null,null,null,null,null,{"$f":"+(L114*1000-X132*AVERAGE(L$95,L$96))/R132","v":26.749271088436544},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,Q32:Q35)","v":50629.039820028949},{"$f":"SUMPRODUCT(L50:L53,X32:X35)","v":784170.15286358155},null,{"$f":"SUMPRODUCT(E50:E53,Q14:Q17)","v":44525.534327496222},{"$f":"SUMPRODUCT(L50:L53,X14:X17)","v":677247.38711834268},null,{"$f":"+T132-Q132","v":-6103.5054925327277},{"$f":"+U132-R132","v":-106922.76574523887},null,{"$f":"+E132*Q132/1000","v":1356.9402514424528},{"$f":"+L132*R132/1000","v":20975.979998408668}]
[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":3386.4775537692285},{"$f":"+AA132+AA131","v":56426.388657037198},null,{"$f":"+E112","v":3386.4775537692285},{"$f":"+L112","v":56426.388657037205}]
[null,"Winter - all hrs",{"$f":"+C116/SUM(C45:C49,C54:C56)*1000","v":40.330933016732622},42.064660406474808,40.262275404505694,39.597360837613508,40.004118634290109,42.370637744246579,36.933518214566952,37.116563675009914,41.085830464429996,40.884964980920834]
[null,"PSE&G On pk",null,null,{"$f":"+(E117*1000-W135*AVERAGE(E$99,E$100))/Q135","v":48.787563483742083},null,null,null,null,null,null,{"$f":"+(L117*1000-X135*AVERAGE(L$99,L$100))/R135","v":48.258078496541984},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38)","v":52537.110959086611},{"$f":"SUMPRODUCT(L45:L49,L27:L31)+SUMPRODUCT(L54:L56,L36:L38)","v":1437145.1424745168},null,{"$f":"SUMPRODUCT(E45:E49,E9:E13)+SUMPRODUCT(E54:E56,E18:E20)","v":61701.191765178992},{"$f":"SUMPRODUCT(L45:L49,L9:L13)+SUMPRODUCT(L54:L56,L18:L20)","v":1652738.2733118488},null,{"$f":"+T135-Q135","v":9164.080806092381},{"$f":"+U135-R135","v":215593.13083733199},null,{"$f":"+E135*Q135/1000","v":2563.1576361688399},{"$f":"+L135*R135/1000","v":69353.863096459245}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E118*1000-W136*AVERAGE(E$99,E$100))/Q136","v":33.739802166787221},null,null,null,null,null,null,{"$f":"+(L118*1000-X136*AVERAGE(L$99,L$100))/R136","v":33.665681910753925},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,Q27:Q31)+SUMPRODUCT(E54:E56,Q36:Q38)","v":68669.351249602347},{"$f":"SUMPRODUCT(L45:L49,X27:X31)+SUMPRODUCT(L54:L56,X36:X38)","v":1467768.2217055946},null,{"$f":"SUMPRODUCT(E45:E49,Q9:Q13)+SUMPRODUCT(E54:E56,Q18:Q20)","v":59505.270443509973},{"$f":"SUMPRODUCT(L45:L49,X9:X13)+SUMPRODUCT(L54:L56,X18:X20)","v":1252175.0908682626},null,{"$f":"+T136-Q136","v":-9164.0808060923737},{"$f":"+U136-R136","v":-215593.13083733199},null,{"$f":"+E136*Q136/1000","v":2316.8903260832062},{"$f":"+L136*R136/1000","v":49413.41807065349}]
[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":4880.0479622520461},{"$f":"+AA136+AA135","v":118767.28116711273},null,{"$f":"+E116","v":4880.0479622520461},{"$f":"+L116","v":118767.28116711277}]
[null,"Annual Average",{"$f":"(C130*SUM(C50:C53)+C134*SUM(C45:C49,C54:C56))/C57","v":37.866427934239901},40.386617221318524,37.877166181418126,37.940983105574794,38.110574092381519,41.01674047979035,34.67217199693787,34.907061894245807,39.043926548145166,38.859412232037734]
[null,"System Average",{"$f":"+C122/SUM(C57:L57)*1000","v":38.327118597975556}]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments",null,null,null,null,null,null,null,null,null,"Adj for PLS"]
[null,"obligations - Peak Load shares eff 6/1/17, scaling factors eff 1/1/17, Transmission Loads eff 1/1/17; 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":3620.2438590151692},{"$f":"Input!D101","v":24.054579651008826},{"$f":"Input!E101","v":69.434657470195589},{"$f":"Input!F101","v":0},{"$f":"Input!G101","v":0},{"$f":"Input!H101","v":2.7853403471235012},{"$f":"Input!I101","v":0},{"$f":"Input!J101","v":0},{"$f":"Input!K101","v":1790.2102822282061},{"$f":"Input!L101","v":1402.6500020589795}]
[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":3892.6433848899769},{"$f":"Input!D102","v":25.480412930542734},{"$f":"Input!E102","v":73.123743718335987},{"$f":"Input!F102","v":0},{"$f":"Input!G102","v":0},{"$f":"Input!H102","v":2.8285138229406002},{"$f":"Input!I102","v":0},{"$f":"Input!J102","v":0},{"$f":"Input!K102","v":1779.2805747545256},{"$f":"Input!L102","v":1379.1019954537435}]
[null,"Gen Obl - MW",{"$f":"ROUND(AD145*$AD$148*$AD$149,1)","v":4212.6000000000004},{"$f":"ROUND(AE145*$AD$148*$AD$149,1)","v":28},80.8,0,0,3.2,0,0,2083.1,{"$f":"ROUND(AM145*$AD$148*$AD$149*(1-AE45),1)","v":1047.9000000000001},null,null,null,null,null,{"$f":"Input!C108","v":2015}," NITS Rate",{"$f":"Input!D108","v":29},{"$f":"Input!E108","v":72688.289999999994},{"$f":"U147/$T$150*T147","v":24799.534235294115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!C109","v":2016}," NITS Rate",{"$f":"Input!D109","v":28},{"$f":"Input!E109","v":82516.44},{"$f":"U148/$T$150*T148","v":27181.88611764706},null,null,null,null,null,null,"Final Zonal RPM Scaling Factor",{"$f":"Input!C104","v":1.0624633824601797}]
[null,"Trans Obl - MW",{"$f":"ROUND(AD146,1)","v":3892.6},{"$f":"ROUND(AE146,1)","v":25.5},73.099999999999994,0,0,2.8,0,0,1779.3,{"$f":"ROUND(AM146*(1-AF45),1)","v":885.5},null,null,null,null,null,{"$f":"Input!C110","v":2017}," NITS Rate",{"$f":"Input!D110","v":28},{"$f":"Input!E110","v":91224.18},{"$f":"U149/$T$150*T149","v":30050.318117647053},null,{"$f":"+Input!B105","v":"PJM June 1, 2016 (through May 31, 2017) Forecast Pool Requirement"},null,null,null,null,null,{"$f":"Input!C105","v":1.0952}]
[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":82031.740000000005}]
[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":82031.740000000005},"per MW-yr"]
[]
[null,null,null,"Base\nCapacity","Incremental RPM Capacity","Total Capacity"]
[null,"Generation Capacity cost","summer =",{"$f":"Input!E113","v":178.95948526236626},{"$f":"SUM(auction_results_and_rates!C13:C13)/SUM(auction_results_and_rates!C13:E13)*Input!E115","v":10.610588235294118},{"$f":"SUM(D158:E158)","v":189.57007349766039},"$/MW/day"]
[null,null,"winter =",{"$f":"Input!E114","v":178.95948526236626},{"$f":"E158","v":10.610588235294118},{"$f":"SUM(D159:E159)","v":189.57007349766039},"$/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":69.193076826646049},"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.64700000000000002},{"$f":"ROUND(R165/R167,3)","v":0.63300000000000001},null,"(based on W/N actuals used in settlement and final rate design of 2009 Rate Case, rounded to .1%)",null,null,null,null,null,null,null,null,null,"Blocking Percentages based on Annualized W/N Usaeg Used in 2009 Electric Rate Case Settlement"]
[null,"Block 2  (>600 kWh/m)",{"$f":"1-C163","v":0.35299999999999998},{"$f":"1-D163","v":0.36699999999999999},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)",3626859,27006]
[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+)",1975894,15667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Summer Usage",{"$f":"SUM(Q165:Q166)","v":5602753},{"$f":"SUM(R165:R166)","v":42673}]
["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":8.57}]
[null,"Total AncillaryServices & Renewable Power Costs",null,{"$f":"SUM(D169:D170)","v":10.57},"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":26.170081385084625},{"$f":"(+$D$155*D149*$H$154/12)/D57","v":15.721286210799432},{"$f":"(+$D$155*E149*$H$154/12)/SUMPRODUCT(E27:E38,E45:E56)","v":60.60321668993668},{"$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":15.114511857445024},{"$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":23.888904685897423},{"$f":"((+$Q$160*D147*1000)/D57)","v":14.560847200302488},{"$f":"(+$Q$160*E147*1000)/SUMPRODUCT(E45:E56,E27:E38)","v":56.502853276672916},{"$f":"((+$Q$160*F147*1000)/F57)","v":0},{"$f":"((+$Q$160*G147*1000)/G57)","v":0},{"$f":"((+$Q$160*H147*1000)/H57)","v":14.570242900048846},{"$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.5328533995235},{"$f":"(D147*$F$158*$E$152)/SUM(D50:D53)","v":21.362582171625029},{"$f":"(E147*$F$158*$E$152)/SUMPRODUCT(E50:E53,E32:E35)","v":40.265057398150709},{"$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":22.386498509575631},{"$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":27.943382946547477},{"$f":"(D147*$F$159*$E$153)/SUM(D45:D49,D54:D56)","v":12.554050461859422},{"$f":"(E147*$F$159*$E$153)/(SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38))","v":70.846960998313207},{"$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":12.397108689501943},{"$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":96.16465752781005},{"$f":"+D130+($D$171*D80)+D$178+D181","v":76.476182972334541},null,{"$f":"+F130+($D$171*F80)+F$178+F181","v":44.613204650644995},{"$f":"+G130+($D$171*G80)+G$178+G181","v":44.195353539785565},{"$f":"+H130+($D$171*H80)+H$178+H181","v":77.326750069977635},{"$f":"+I130+($D$171*I80)+I$178+I181","v":40.312431753545368},{"$f":"+J130+($D$171*J80)+J$178+J181","v":40.360116300537882}]
[null,"PSE&G On pk",null,null,{"$f":"+E131+($D$171*E80)+E$178+E181","v":172.33147139953087}]
[null,"PSE&G Off pk",null,null,{"$f":"+E132+($D$171*E80)","v":38.296526023065553}]
[null,"Block 1 (0-600 kWh/m)",{"$f":"(C194*SUM(C50:C53)-C166*10*C164*SUM(C50:C53))/SUM(C50:C53)","v":93.110501527810044},{"$f":"(D194*SUM(D50:D53)-D166*10*D164*SUM(D50:D53))/SUM(D50:D53)","v":72.23035997233454}]
[null,"Block 2 (>600 kWh/m)",{"$f":"+C197+C166*10","v":101.76250152781004},{"$f":"+D197+D166*10","v":83.799359972334543}]
[]
[null,"Winter - all hrs",{"$f":"+C134+($D$171*C80)+C$178+C181","v":101.88482579771468},{"$f":"+D134+($D$171*D80)+D$178+D181","v":83.841700527576734},null,{"$f":"+F134+($D$171*F80)+F$178+F181","v":51.09226754761351},{"$f":"+G134+($D$171*G80)+G$178+G181","v":51.499025344290111},{"$f":"+H134+($D$171*H80)+H$178+H181","v":83.550299211740452},{"$f":"+I134+($D$171*I80)+I$178+I181","v":48.428424924566954},{"$f":"+J134+($D$171*J80)+J$178+J181","v":48.611470385009916}]
[null,"PSE&G On pk",null,null,{"$f":"+E135+($D$171*E80)+E$178+E181","v":177.38854016035168}]
[null,"PSE&G Off pk",null,null,{"$f":"+E136+($D$171*E80)","v":45.234708876787224}]
[]
[null,"Annual -all hrs",{"$f":"+C138+($D$171*C80)+C$178+C181","v":99.420320715221948},{"$f":"+D138+($D$171*D80)+D$178+D181","v":82.16365734242045},{"$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":102.46510148592537},{"$f":"+F138+($D$171*F80)+F$178+F181","v":49.435889815574797},{"$f":"+G138+($D$171*G80)+G$178+G181","v":49.605480802381521},{"$f":"+H138+($D$171*H80)+H$178+H181","v":82.196401947284215},{"$f":"+I138+($D$171*I80)+I$178+I181","v":46.167078706937872},{"$f":"+J138+($D$171*J80)+J$178+J181","v":46.401968604245809}]
[]
[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.069247252025519},{"$f":"+L130+($D$171*L$80)","v":46.684774733688613},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,{"$f":"+L131+($D$171*L$80)","v":54.763320699964147},null,null,null,"summer",{"$f":"+$F158*$E152/$H152/1000","v":5.7818872416786418},{"$f":"+$F158*$E152/$H152/1000","v":5.7818872416786418},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,{"$f":"+L132+($D$171*L$80)","v":38.244177798436546},null,null,null,"winter",{"$f":"+$F159*$E153/$H153/1000","v":5.7581909824914348},{"$f":"+$F159*$E153/$H153/1000","v":5.7581909824914348},"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.7660897355538374},{"$f":"($F$158*$E$152+$F$159*$E$153)/$H$154/1000","v":5.7660897355538374},"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"+K134+($D$171*K80)","v":52.580737174429999},{"$f":"+L134+($D$171*L$80)","v":52.379871690920837}]
[null,"PSE&G On pk",null,{"$f":"+L135+($D$171*L$80)","v":59.752985206541986},null,null,null,"Trans cost"]
[null,"PSE&G Off pk",null,{"$f":"+L136+($D$171*L$80)","v":45.160588620753927},null,null,null,"all months",{"$f":"+$D155/1000/12","v":6.8359783333333333},{"$f":"+$D155/1000/12","v":6.8359783333333333},"per kW of T obl /month"]
[]
[null,"Annual - all hrs per MWh only",{"$f":"+K138+($D$171*K80)","v":50.538833258145168},{"$f":"+L138+($D$171*L$80)","v":50.354318942037736}]
[]
[null,"Including T&G Obligation $"]
[null,"Summer - all hrs",{"$f":"(C211*W49+((I214*$H152)*K147*1000)+(I217*$H152*K149*1000))/W49","v":87.746400007811047},{"$f":"(D211*X49+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X49","v":76.857934199962983},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":113.81539211593942}]
[null,"PSE&G Off pk",null,{"$f":"+D213","v":38.244177798436546}]
[]
[null,"Winter - all hrs",{"$f":"(C215*W45+((I214*$H153)*K147*1000)+(I217*$H153*K149*1000))/W45","v":100.45897819157484},{"$f":"(D215*X45+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X45","v":85.690453403136274}]
[null,"PSE&G On pk",null,{"$f":"(D216*X46+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X46","v":127.08393955803962}]
[null,"PSE&G Off pk",null,{"$f":"+D217","v":45.160588620753927}]
[]
[null,"Annual - including T&G Obl $",{"$f":"(C219*K57+((I214*$H152+I214*$H153)*K147*1000)+(I217*$H154*K149*1000))/K57","v":95.749205780672952},{"$f":"(D219*L57+((J214*$H152+J214*$H153)*L147*1000)+(J217*$H154*L149*1000))/L57","v":82.549026016403033}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C204:J204,C57:J57)+SUMPRODUCT(C230:D230,K57:L57))/1000","v":2255326.39927221}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C233/SUM(C57:L57)*1000","v":94.169692172356079},"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":87.659893184675695},"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.50900000000000001},{"$f":"ROUND(+G194/$D$235,3)","v":0.504},{"$f":"ROUND(+H194/$D$235,3)","v":0.88200000000000001},{"$f":"ROUND(+I194/$D$235,3)","v":0.46},{"$f":"ROUND(+J194/$D$235,3)","v":0.46}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E195/$D$235,3)","v":1.966},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E196/$D$235,3)","v":0.437},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I245*U49+J245*V49)/(U49+V49),3)","v":0.46}]
[]
[null,"All usage Multiplier",{"$f":"ROUND(+C194/$D$235,3)","v":1.097},{"$f":"ROUND(+D194/$D$235,3)","v":0.872}]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C197-C194,3)","v":-3.0539999999999998},{"$f":"ROUND(D197-D194,3)","v":-4.2460000000000004},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C198-C194,3)","v":5.5979999999999999},{"$f":"ROUND(D198-D194,3)","v":7.3230000000000004},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C200/$D$235,3)","v":1.1619999999999999},{"$f":"ROUND(+D200/$D$235,3)","v":0.95599999999999996},null,{"$f":"ROUND(+F200/$D$235,3)","v":0.58299999999999996},{"$f":"ROUND(+G200/$D$235,3)","v":0.58699999999999997},{"$f":"ROUND(+H200/$D$235,3)","v":0.95299999999999996},{"$f":"ROUND(+I200/$D$235,3)","v":0.55200000000000005},{"$f":"ROUND(+J200/$D$235,3)","v":0.55500000000000005}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E201/$D$235,3)","v":2.024},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E202/$D$235,3)","v":0.51600000000000001},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I255*U45+J255*V45)/(U45+V45),3)","v":0.55400000000000005}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C204/$D$235,3)","v":1.1339999999999999},{"$f":"ROUND(+D204/$D$235,3)","v":0.93700000000000006},1.169,0.56399999999999995,0.56599999999999995,0.93799999999999994,0.52700000000000002,0.52900000000000003]
[]
[]
[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":1.0009999999999999},{"$f":"ROUND(+C211-C222,3)","v":-40.677},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D223/$D$235,3)","v":1.298},{"$f":"ROUND(+D212-D223,3)","v":-59.052},null,"summer",{"$f":"ROUND(+I212,4)","v":5.7819000000000003},5.7819000000000003,"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D224/$D$235,3)","v":0.436},{"$f":"ROUND(+D213-D224,3)","v":0},null,"winter",5.7582000000000004,5.7582000000000004,"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",5.7660999999999998,5.7660999999999998,"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"ROUND(+C226/$D$235,3)","v":1.1459999999999999},{"$f":"ROUND(+C215-C226,3)","v":-47.878}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D227/$D$235,3)","v":1.45},{"$f":"ROUND(+D216-D227,3)","v":-67.331000000000003},null,"Trans cost"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D228/$D$235,3)","v":0.51500000000000001},{"$f":"ROUND(+D217-D228,3)","v":0},null,"all months",{"$f":"ROUND(+I217,4)","v":6.8360000000000003},{"$f":"ROUND(+J217,4)","v":6.8360000000000003},"per kW of T obl /month"]
[]
[null,"Annual - including T&G Obl $",{"$f":"ROUND(+C230/$D$235,3)","v":1.0920000000000001},null,{"$f":"ROUND(+D230/$D$235,3)","v":0.94199999999999995}]
[]
[]
[]
["Assumptions:"]
[null,"Gen Cost =",{"$f":"+F158","v":189.57007349766039},"/MW day ","summer"]
[null,null,{"$f":"+F159","v":189.57007349766039},"/MW day ","winter"]
[]
[null,"Trans cost =",{"$f":"+D155","v":82031.740000000005},"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":10.57},"per MWh"]
[null,"Energy Costs ="," based on Forwards @ PJM West - corrected for congestion"]
[null,"Usage patterns ="," forecasted 2017 energy use by class, PJM and PSE&G on/off % from 2013, 2014 & 2015 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":505537.09847949812},{"$f":"(+D197*SUM(D50:D53)*D163+D198*SUM(D50:D53)*D164)/1000","v":2318.2490891584621},{"$f":"(E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))/1000","v":9936.83979889476},{"$f":"+F194*SUM(F50:F53)/1000","v":14.633131125411559},{"$f":"+G194*SUM(G50:G53)/1000","v":0.30936747477849896},{"$f":"+H194*SUM(H50:H53)/1000","v":255.63668357197977},{"$f":"+I194*SUM(I50:I53)/1000","v":1785.5585396597851},{"$f":"+J194*SUM(J50:J53)/1000","v":3201.8891064705717},{"$f":"(C211*SUM(K50:K53)/1000)+(I212*$H152*K147)+(I217*$H152*K149)","v":208723.8046652184},{"$f":"(D211*SUM(L50:L53)/1000)+(J212*$H152*L147)+(J217*$H152*L149)","v":123306.68091777724}]
[null,"Winter",{"$f":"+C200*SUM(C45:C49,C54:C56)/1000","v":707549.4540363237},{"$f":"+D200*SUM(D45:D49,D54:D56)/1000","v":8614.1075894115893},{"$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":12425.719529808395},{"$f":"+F200*SUM(F45:F49,F54:F56)/1000","v":48.793115507970896},{"$f":"+G200*SUM(G45:G49,G54:G56)/1000","v":1.0299805068858023},{"$f":"+H200*SUM(H45:H49,H54:H56)/1000","v":993.46742404302779},{"$f":"+I200*SUM(I45:I49,I54:I56)/1000","v":5553.5296282247155},{"$f":"+J200*SUM(J45:J49,J54:J56)/1000","v":10545.529327972125},{"$f":"(C215*SUM(K45:K49,K54:K56)/1000)+(I213*$H153*K147)+(I217*$H153*K149)","v":405656.94241481123},{"$f":"(D215*SUM(L45:L49,L54:L56)/1000)+(J213*$H153*L147)+(J217*$H153*L149)","v":248857.12644675098}]
[null,"Total",{"$f":"+C303+C302","v":1213086.5525158218},{"$f":"+D303+D302","v":10932.356678570051},22362.559328703155,63.426246633382455,1.3393479816643012,1249.1041076150075,7339.0881678845008,13747.418434442696,{"$f":"+K303+K302","v":614380.74708002969},{"$f":"+L303+L302","v":372163.80736452818}]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C302/C304","v":0.41673621509616449},{"$f":"+D302/D304","v":0.21205392005758161},0.44435163492849705,0.23071097380228489,0.23098364205101693,0.20465602667825891,0.24329433014216997,{"$f":"+J302/J304","v":0.23290839089094567},{"$f":"+K302/K304","v":0.33973037999192035},{"$f":"+L302/L304","v":0.33132367650409494}]
[null,"Winter",{"$f":"+C303/C304","v":0.58326378490383557},{"$f":"+D303/D304","v":0.78794607994241839},0.55564836507150295,0.76928902619771511,0.76901635794898315,0.79534397332174112,0.75670566985782994,{"$f":"+J303/J304","v":0.76709160910905438},{"$f":"+K303/K304","v":0.66026962000807954},{"$f":"+L303/L304","v":0.66867632349590511}]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C302:L302)","v":855080.69977884949}]
[null,"Winter",{"$f":"+SUM(C303:L303)","v":1400245.6994933602}]
[null,"Total",{"$f":"+C312+C311","v":2255326.39927221}]
[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.37913833671914743},null,{"$f":"+C311/SUMPRODUCT(O49:X49,C85:L85)*1000","v":83.854191231803128},"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.62086166328085246},null,{"$f":"+C312/SUMPRODUCT(O45:X45,C85:L85)*1000","v":90.158627888899417},"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":87.659893184675695},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":505528.69409982377},{"$f":"+($C$322*D249*P49+D250*P53+D251*P54)/1000","v":2317.1295228102199},{"$f":"(($C$322*E246*Q50)+(C322*E247*Q51))/1000","v":9937.7546340153949},{"$f":"+$C$322*F245*R49/1000","v":14.634994486967976},{"$f":"+$C$322*G245*S49/1000","v":0.30926410315553587},{"$f":"+$C$322*H245*T49/1000","v":255.60122986870115},{"$f":"+$C$322*K247*U49/1000","v":1786.0510384612667},{"$f":"+$C$322*K247*V49/1000","v":3198.9882607691438},{"$f":"+($C$322*C267+D267)*W49/1000+(I268*H152*K147)+(I273*H152*K149)","v":208727.1694091321},{"$f":"(($C$322*E268+F268)*X50+(C322*E269*X51))/1000+(J268*$H$152*L147)+(J273*$H$152*L149)","v":123260.77033947111}]
[null,"Winter",{"$f":"+$C$322*C255*O45/1000","v":707382.57585199375},{"$f":"+$C$322*D255*P45/1000","v":8610.1167983853538},{"$f":"(($C$322*E256*Q46)+(C322*E257*Q47))/1000","v":12427.411376377873},{"$f":"+$C$322*F255*R45/1000","v":48.80596042896596},{"$f":"+$C$322*G255*S45/1000","v":1.0291271459880926},{"$f":"+$C$322*H255*T45/1000","v":993.34351149185693},{"$f":"+$C$322*K257*U45/1000","v":5569.0286310277888},{"$f":"+$C$322*K257*V45/1000","v":10535.140406121764},{"$f":"+($C$322*C271+D271)*W45/1000+(I269*H153*K147)+(I273*H153*K149)","v":405655.38310594903},{"$f":"(($C$322*E272+F272)*X46+C322*E273*X47)/1000+(J269*$H$153*L147)+(J273*$H$153*L149)","v":248867.10053863173}]
[null,"Total",{"$f":"+C329+C328","v":1212911.2699518176},{"$f":"+D329+D328","v":10927.246321195573},22365.166010393266,63.440954915933936,1.3383912491436285,1248.9447413605581,7355.079669489056,13734.128666890907,614382.55251508113,372127.87087810284]
[]
[null,"Total Summer",{"$f":"SUM(C328:L328)","v":855027.10279294197}]
[null,"Total Winter",{"$f":"SUM(C329:L329)","v":1400089.9353075542}]
[null,"Grand Total",{"$f":"+C333+C332","v":2255117.0381004959}]
[]
[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":495049.57610599359},2854.5985772311756,9138.1473665554222,30.887659032532795,0.65918784520649265,311.31824081769918,4171.0581753901679,7470.7641891095254,223861.72844333985,150999.59018470737]
[null,"Winter",{"$f":"+$C$322*$C$324*O45*C85/1000","v":653970.93003435002},9675.2314770575795,11413.975235492551,89.932056024600072,1.8833938434471218,1119.7389164137098,10798.909449864934,20428.70217141007,380383.97111552622,273554.79729220446]
[null,"Total",{"$f":"+C339+C338","v":1149020.5061403436},12529.830054288755,20552.122602047973,120.81971505713287,2.5425816886536143,1431.0571572314091,14969.967625255102,27899.466360519596,604245.69955886609,424554.38747691183]
[]
[null,"Total Summer",{"$f":"SUM(C338:L338)","v":893888.32813002239}]
[null,"Total Winter",{"$f":"SUM(C339:L339)","v":1361438.0711421873}]
[null,"Grand Total",{"$f":"+C343+C342","v":2255326.39927221}]
[]
[null,"Difference ( in $1000) =",{"$f":"+C334-C344","v":-209.36117171403021}]
[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":10197232.687094901}]
[null,"Winter",{"$f":"SUMPRODUCT(O45:X45,C85:L85)","v":15530911.819319762}]
[null,"Total",{"$f":"+C353+C352","v":25728144.506414663}]

{"sheet":"auction_results_and_rates","index":2,"n_rows":273,"n_cols":17,"rows_kept":273,"cut":false,"hidden":false,"merged":[[5,16,16,16],[5,15,16,15]]}
[null,"Calculation of June 2017 to May 2018 BGS-RSCP Rates"]
[null,"Illustrative Purposes Only"]
[null,"NJ Sales & Use Tax (SUT) excluded"]
[]
["Table A","Auction Results",null,null,null,null,null,null,null,null,null,null,"Line Designation","Incremental RPM cost $/MWh","2015 Auction","2016 Auction","2017 Auction"]
["line #","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2015 auction","remaining portion of 36 month bid - 2016 auction","36 month bid - 2017 auction",null,"Notes:",null,null,null,null,null,"A","Incremental Capacity Cost",{"$f":"+bid_factors!$E$158","v":10.610588235294118},"No adder required as data known prior to Feb. 2016 auction","No adder required as data known prior to Feb. 2016 auction"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B","Total Generation Obligation",{"$f":"SUM(bid_factors!$C$147:$L$147)","v":7455.6}]
[1,"Winning Bid - in $/MWh",{"$f":"Input!C136","v":99.54},{"$f":"Input!D136","v":96.38},{"$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":96.38},null,"Winning Bid - 2017 Illustrative Purposes Only",null,null,null,null,null,"C","Days in Year",365]
["1A","Incremental RPM Cost - in $/MWh",{"$f":"ROUND(O17,2)","v":3.29},null,null,null,"Based upon 2nd Incremental auction results - Illustrative Purposes Only",null,null,null,null,null,"D = A * B * C","Total Incremental Cost",{"$f":"+O6*O7*O8","v":28874530.101176474}]
[null,"Total - in $/MWh",{"$f":"+C8+C9","v":102.83000000000001},{"$f":"+D8+D9","v":96.38},{"$f":"+E8+E9","v":96.38},null,"= line 1 + line 2",null,null,null,null,null,"E","Eligible Tranches",{"$f":"+C13","v":29}]
[null,null,null,null,null,null,null,null,null,null,null,null,"F","Total Inc. Adder Tranches ",{"$f":"SUM($C$13)","v":29}]
[null,"      (includes all payments, including impact of PJM marginal losses)",null,null,null,null,null,null,null,null,null,null,"G = E / F","Eligibility %",{"$f":"+O10/O11","v":1}]
[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",null,null,null,null,null,"H = D * G","Allocated Period Cost",{"$f":"+O9*O12","v":28874530.101176474}]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid",null,null,null,null,null,"I","Total Tranches",{"$f":"SUM($C$13:$E$13)","v":85}]
[null,"Payment Factors",null,null,null,null,null,null,null,null,null,null,"J","Total MWhs",{"$f":"SUM(bid_factors!$C$354)","v":25728144.506414663}]
[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},null,null,null,null,null,null,null,"K = E / I * J","Allocated MWhs",{"$f":"+O10/O14*O15","v":8777837.5374826491}]
[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,null,null,null,null,null,null,"L = H / K","Incremental RPM Cost ",{"$f":"ROUND(+O13/O16,2)","v":3.29}]
[]
[null,"Applicable Customer Usage @ transmission nodes - in MWh"]
[6,"                           Summer MWh",{"$f":"+bid_factors!C352","v":10197232.687094901},null,null,null,"from Table #17 of the current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"+bid_factors!C353","v":15530911.819319762}]
[]
[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":357751.31387300114},{"$f":"+D$8*D$13/D$14*D16*$C20/1000+D$9*D$13/D$14*$C20/1000","v":323748.94139649154},323748.94139649154,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":544873.7201063399},{"$f":"+D$8*D$13/D$14*D17*$C21/1000+D$9*D$13/D$14*$C21/1000","v":493086.35143634211},493086.35143634211,null,"= (1) * (2)/(3) * (5) * (7) + (1A) * (2)/(3) * (7)"]
[10,"                           Total",{"$f":"+C25+C24","v":902625.03397934104},{"$f":"+D25+D24","v":816835.29283283371},{"$f":"+E25+E24","v":816835.29283283371},null,"Note: $ reflect total payment"]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C24:E24)/C20*1000,3)","v":98.581000000000003},null,null,null,"= sum(line 8) / (6) - rounded to 3 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":98.581000000000003},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":98.581000000000003},"   <<< 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":2536306.2135868641},null,null,null,"= (13) * [(6)+(7)] / 1000"]
[15,"Total Payment to Suppliers =",{"$f":"SUM(C26:E26)","v":2536295.6196450084},null,null,null,"= sum (line 10)"]
[16,"Difference =",{"$f":"+C36-C37","v":10.59394185571},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.50900000000000001},{"$f":"+bid_factors!G245","v":0.504},{"$f":"+bid_factors!H245","v":0.88200000000000001},{"$f":"+bid_factors!I245","v":0.46},{"$f":"+bid_factors!J245","v":0.46}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E246","v":1.966},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E247","v":0.437},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K247","v":0.46}]
[]
[null,"All usage Multiplier",{"$f":"+bid_factors!C249","v":1.097},{"$f":"+bid_factors!D249","v":0.872}]
[null,"Constant (in $/MWh)",{"$f":"+bid_factors!C250","v":-3.0539999999999998},{"$f":"+bid_factors!D250","v":-4.2460000000000004},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"+bid_factors!C251","v":5.5979999999999999},{"$f":"+bid_factors!D251","v":7.3230000000000004},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"+bid_factors!C255","v":1.1619999999999999},{"$f":"+bid_factors!D255","v":0.95599999999999996},null,{"$f":"+bid_factors!F255","v":0.58299999999999996},{"$f":"+bid_factors!G255","v":0.58699999999999997},{"$f":"+bid_factors!H255","v":0.95299999999999996},{"$f":"+bid_factors!I255","v":0.55200000000000005},{"$f":"+bid_factors!J255","v":0.55500000000000005}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E256","v":2.024},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E257","v":0.51600000000000001},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K257","v":0.55400000000000005}]
[]
[null,"Annual - all hrs",{"$f":"+bid_factors!C259","v":1.1339999999999999},{"$f":"+bid_factors!D259","v":0.93700000000000006},{"$f":"+bid_factors!E259","v":1.169},{"$f":"+bid_factors!F259","v":0.56399999999999995},{"$f":"+bid_factors!G259","v":0.56599999999999995},{"$f":"+bid_factors!H259","v":0.93799999999999994},{"$f":"+bid_factors!I259","v":0.52700000000000002},{"$f":"+bid_factors!J259","v":0.52900000000000003}]
[]
[]
[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":1.0009999999999999},{"$f":"+bid_factors!D267","v":-40.677},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E268","v":1.298},{"$f":"+bid_factors!F268","v":-59.052},null,"summer",{"$f":"+bid_factors!I$270","v":5.7660999999999998},{"$f":"+bid_factors!J$270","v":5.7660999999999998},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E269","v":0.436},{"$f":"+bid_factors!F269","v":0},null,"winter",{"$f":"+bid_factors!I$270","v":5.7660999999999998},{"$f":"+bid_factors!J$270","v":5.7660999999999998},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"+bid_factors!C271","v":1.1459999999999999},{"$f":"+bid_factors!D271","v":-47.878},null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E272","v":1.45},{"$f":"+bid_factors!F272","v":-67.331000000000003},null,"all months",{"$f":"+bid_factors!I273","v":6.8360000000000003},{"$f":"+bid_factors!J273","v":6.8360000000000003},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E273","v":0.51500000000000001},{"$f":"+bid_factors!F273","v":0}]
[]
[null,"Annual - including T&G Obl $",{"$f":"+bid_factors!C275","v":1.0920000000000001},null,{"$f":"+bid_factors!E275","v":0.94199999999999995}]
[]
[]
["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":5.0178000000000003},{"$f":"ROUND(($C$32*G48)/10,4)","v":4.9684999999999997},{"$f":"ROUND(($C$32*H48)/10,4)","v":8.6948000000000008},{"$f":"ROUND(($C$32*K50)/10,4)","v":4.5347},{"$f":"+I89","v":4.5347}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E49)/10,4)","v":19.381}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E50/10),4)","v":4.3079999999999998}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C53)/10,4)","v":10.508900000000001},{"$f":"ROUND((+$C$32*D52+D53)/10,4)","v":8.1716999999999995}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C54)/10,4)","v":11.3741},{"$f":"ROUND((+$C$32*D52+D54)/10,4)","v":9.3285999999999998}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C58)/10,4)","v":11.4551},{"$f":"ROUND(($C$32*D58)/10,4)","v":9.4243000000000006},null,{"$f":"ROUND(($C$32*F58)/10,4)","v":5.7473000000000001},{"$f":"ROUND(($C$32*G58)/10,4)","v":5.7866999999999997},{"$f":"ROUND(($C$32*H58)/10,4)","v":9.3948},{"$f":"ROUND(($C$32*K60)/10,4)","v":5.4614000000000003},{"$f":"+I96","v":5.4614000000000003}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E59)/10,4)","v":19.9528}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E60)/10,4)","v":5.0868000000000002}]
[]
[]
[]
[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":5.8003},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E71+F71)/10,4)","v":6.8906000000000001},null,null,"summer",{"$f":"+I71","v":5.7660999999999998},{"$f":"+J71","v":5.7660999999999998},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E72+F72)/10,4)","v":4.2980999999999998},null,null,"winter",{"$f":"+I72","v":5.7660999999999998},{"$f":"+J72","v":5.7660999999999998},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C74+D74)/10,4)","v":6.5095999999999998},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E75+F75)/10,4)","v":7.5610999999999997},null,null,"all months",{"$f":"+I75","v":6.8360000000000003},{"$f":"+J75","v":6.8360000000000003},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E76+F76)/10,4)","v":5.0769000000000002}]
[]
[]
[]
["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":568508.00190127548},{"$f":"+D93/100*bid_factors!P53+auction_results_and_rates!D94/100*bid_factors!P54","v":2605.8209023498375},{"$f":"+E90/100*bid_factors!Q50+E91/100*bid_factors!Q51","v":11175.843482227172},{"$f":"+F89/100*bid_factors!R49","v":16.458383999999999},{"$f":"+G89/100*bid_factors!S49","v":0.34779500000000002},{"$f":"+H89/100*bid_factors!T49","v":287.44384502260681},{"$f":"+I89/100*bid_factors!U49","v":2008.5546709999999},{"$f":"+J89/100*bid_factors!V49","v":3597.513551}]
[null,"Winter",{"$f":"+C96/100*bid_factors!O45","v":795510.97893846431},{"$f":"+D96/100*bid_factors!P45","v":9682.7633080020532},{"$f":"+E97/100*bid_factors!Q46+auction_results_and_rates!E98/100*bid_factors!Q47","v":13975.697234809408},{"$f":"+F96/100*bid_factors!R45","v":54.886715000000002},{"$f":"+G96/100*bid_factors!S45","v":1.1573399999999998},{"$f":"+H96/100*bid_factors!T45","v":1117.1028522286738},{"$f":"+I96/100*bid_factors!U45","v":6262.8604500000001},{"$f":"+J96/100*bid_factors!V45","v":11847.688090000001}]
[null,"Total",{"$f":"+C122+C121","v":1364018.9808397398},{"$f":"+D122+D121","v":12288.584210351892},25151.54071703658,71.345099000000005,1.5051349999999999,1404.5466972512806,8271.415121,15445.201641000001]
[]
[]
[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":137885.67781589011},{"$f":"I108*bid_factors!K147*4+auction_results_and_rates!I112*bid_factors!K149*4","v":96698.630839999998},null,{"$f":"+E108/100*bid_factors!X50+auction_results_and_rates!E109/100*bid_factors!X51","v":90160.053999295429},{"$f":"auction_results_and_rates!J108*bid_factors!L147*4+auction_results_and_rates!J112*bid_factors!L149*4","v":48382.296759999997}]
[null,"Winter",{"$f":"+C111/100*bid_factors!W45","v":262945.26840351225},{"$f":"auction_results_and_rates!I109*bid_factors!K147*8+auction_results_and_rates!I112*bid_factors!K149*8","v":193397.26168},null,{"$f":"+E112/100*bid_factors!X46+auction_results_and_rates!E113/100*bid_factors!X47","v":183181.10621541203},{"$f":"auction_results_and_rates!J109*bid_factors!L147*8+auction_results_and_rates!J112*bid_factors!L149*8","v":96764.593519999995}]
[null,"Total",{"$f":"+C130+C129","v":400830.94621940237},{"$f":"+D130+D129","v":290095.89251999999},null,{"$f":"+F130+F129","v":273341.16021470749},{"$f":"+G130+G129","v":145146.89027999999}]
[]
[]
[null,null,"Energy $","Obligation $","Total $"]
[null,"Total Summer",{"$f":"SUM(C121:J121)+C129+F129","v":816245.71634706063},{"$f":"+D129+G129","v":145080.9276},{"$f":"+C135+D135","v":961326.64394706069}]
[null,"Total Winter",{"$f":"SUM(C122:J122)+C130+F130","v":1284579.5095474287},{"$f":"+D130+G130","v":290161.85519999999},{"$f":"+C136+D136","v":1574741.3647474288}]
[null,"Grand Total",{"$f":"+C136+C135","v":2100825.2258944893},{"$f":"+D131+G131","v":435242.78279999999},{"$f":"+C137+D137","v":2536068.0086944895}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":1005249.1966659843}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1531046.4229790242}]
[null,"Total",{"$f":"+C142+C141","v":2536295.6196450088},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":43922.55271892366},null,{"$f":"ROUND(1+(C146/C135),5)","v":1.0538099999999999}]
[null,"Winter",{"$f":"+C142-E136","v":-43694.941768404562},null,{"$f":"ROUND(1+(C147/C136),5)","v":0.96599000000000002}]
[null,"Total",{"$f":"+C143-E137","v":227.6109505193308}]
[]
[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":5.2877999999999998},{"$f":"ROUND(+G89*$E$146,4)","v":5.2359},{"$f":"ROUND(+H89*$E$146,4)","v":9.1626999999999992},{"$f":"ROUND(+I89*$E$146,4)","v":4.7786999999999997},{"$f":"ROUND(+J89*$E$146,4)","v":4.7786999999999997}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E90*$E$146,4)","v":20.4239}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E91*$E$146,4)","v":4.5397999999999996}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C93*$E$146,4)","v":11.074400000000001},{"$f":"ROUND(+D93*$E$146,4)","v":8.6113999999999997}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C94*$E$146,4)","v":11.9861},{"$f":"ROUND(+D94*$E$146,4)","v":9.8306000000000004}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C96*$E$147,4)","v":11.0655},{"$f":"ROUND(+D96*$E$147,4)","v":9.1037999999999997},null,{"$f":"ROUND(+F96*$E$147,4)","v":5.5518000000000001},{"$f":"ROUND(+G96*$E$147,4)","v":5.5899000000000001},{"$f":"ROUND(+H96*$E$147,4)","v":9.0753000000000004},{"$f":"ROUND(+I96*$E$147,4)","v":5.2756999999999996},{"$f":"ROUND(+J96*$E$147,4)","v":5.2756999999999996}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E97*$E$147,4)","v":19.2742}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E98*$E$147,4)","v":4.9138000000000002}]
[]
[]
[]
[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":6.1124000000000001},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E108*$E$146,4)","v":7.2614000000000001},null,null,"summer",{"$f":"+I108","v":5.7660999999999998},{"$f":"+J108","v":5.7660999999999998}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E109*$E$146,4)","v":4.5293999999999999},null,null,"winter",{"$f":"+I109","v":5.7660999999999998},{"$f":"+J109","v":5.7660999999999998}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C111*$E$147,4)","v":6.2881999999999998},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E112*$E$147,4)","v":7.3038999999999996},null,null,"all months",{"$f":"+I112","v":6.8360000000000003},{"$f":"+J112","v":6.8360000000000003}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E113*$E$147,4)","v":4.9042000000000003}]
[]
[]
[]
["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":599099.21653832367},{"$f":"+D165/100*bid_factors!P53+auction_results_and_rates!D166/100*bid_factors!P54","v":2746.0395641376945},{"$f":"+E162/100*bid_factors!Q50+E163/100*bid_factors!Q51","v":11777.212689019922},{"$f":"+F161/100*bid_factors!R49","v":17.343983999999999},{"$f":"+G161/100*bid_factors!S49","v":0.36651300000000003},{"$f":"+H161/100*bid_factors!T49","v":302.91228306443372},{"$f":"+I161/100*bid_factors!U49","v":2116.6295909999999},{"$f":"+J161/100*bid_factors!V49","v":3791.0860709999997},{"$f":"+C179/100*bid_factors!W49+I180*bid_factors!K147*4+auction_results_and_rates!I184*bid_factors!K149*4","v":242003.60076946003},{"$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":143394.15189091547}]
[null,"Winter",{"$f":"+C168/100*bid_factors!O45","v":768454.81378980342},{"$f":"+D168/100*bid_factors!P45","v":9353.4735315502567},{"$f":"+E169/100*bid_factors!Q46+auction_results_and_rates!E170/100*bid_factors!Q47","v":13500.382422179233},{"$f":"+F168/100*bid_factors!R45","v":53.019689999999997},{"$f":"+G168/100*bid_factors!S45","v":1.1179800000000002},{"$f":"+H168/100*bid_factors!T45","v":1079.1122232331591},{"$f":"+I168/100*bid_factors!U45","v":6049.9089749999994},{"$f":"+J168/100*bid_factors!V45","v":11444.839795},{"$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":447399.41799912334},{"$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":273714.52671008202}]
[null,"Total",{"$f":"+C194+C193","v":1367554.0303281271},12099.513095687951,25277.595111199153,70.363674000000003,1.4844930000000003,1382.0245062975928,8166.5385659999993,15235.925866,689403.01876858342,417108.67860099749]
[]
[null,"Total Summer",{"$f":"SUM(C193:L193)","v":1005248.5598939214}]
[null,"Total Winter",{"$f":"SUM(C194:L194)","v":1531050.6131159717}]
[null,"Grand Total",{"$f":"+C198+C197","v":2536299.1730098929}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":1005249.1966659843}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1531046.4229790242}]
[null,"Total",{"$f":"+C204+C203","v":2536295.6196450088}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C197-C203","v":-0.63677206297870725},null,{"$f":"+C208/C197","v":-6.3344737648358578E-7}]
[null,"Winter",{"$f":"+C198-C204","v":4.1901369474362582},null,{"$f":"+C209/C198","v":2.736772325840067E-6}]
[null,"Total",{"$f":"+C199-C205","v":3.553364884108305},null,{"$f":"+C210/C199","v":1.4010038413139698E-6}]
[]
[]
["DO NOT USE"]
["Table G","Final Resulting BGS Rates with NITS Differential Adder (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, Ancillary Services, and NITS Differential Adder - adjusted to billing time periods & adjustment to energy price"]
[]
[null,null,{"$f":"C159","v":"RS"},{"$f":"D159","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(+F161+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+G161+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+H161+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+I161+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+J161+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(E162+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(E163+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C165+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+D165+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C166+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+D166+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+D168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+F168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+G168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+H168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+I168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+J168+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(E169+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(E170+bid_factors!#REF!*100,4)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"DEMAND RATES --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy and Ancillary Services, G&T obligations with NITS Differential Adder charged separately - adjusted to billing time periods & adjustment to energy price"]
[]
[null,null,{"$f":"C177","v":"GLP"},null,{"$f":"E177","v":"LPL-S"},null,null,"PLUS:",{"$f":"+C238","v":"GLP"},{"$f":"+E238","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"C179","v":6.1124000000000001},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"E180","v":7.2614000000000001},null,null,"summer",{"$f":"I180","v":5.7660999999999998},{"$f":"J180","v":5.7660999999999998}]
[null,"PSE&G Off pk",null,null,{"$f":"E181","v":4.5293999999999999},null,null,"winter",{"$f":"I181","v":5.7660999999999998},{"$f":"J181","v":5.7660999999999998}]
[]
[null,"Winter - all hrs",{"$f":"C183","v":6.2881999999999998},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"E184","v":7.3038999999999996},null,null,"all months",{"$f":"ROUND(+I184+bid_factors!#REF!,4)","v":{"$error":"#REF!"}},{"$f":"ROUND(+J184+bid_factors!#REF!,4)","v":{"$error":"#REF!"}}]
[null,"PSE&G Off pk",null,null,{"$f":"E185","v":4.9042000000000003}]
[]
[]
[]
[]
["Table H","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":"+C226/100*bid_factors!O53+auction_results_and_rates!C227/100*bid_factors!O54","v":{"$error":"#REF!"}},{"$f":"+D226/100*bid_factors!P53+auction_results_and_rates!D227/100*bid_factors!P54","v":{"$error":"#REF!"}},{"$f":"+E223/100*bid_factors!Q50+E224/100*bid_factors!Q51","v":{"$error":"#REF!"}},{"$f":"+F222/100*bid_factors!R49","v":{"$error":"#REF!"}},{"$f":"+G222/100*bid_factors!S49","v":{"$error":"#REF!"}},{"$f":"+H222/100*bid_factors!T49","v":{"$error":"#REF!"}},{"$f":"+I222/100*bid_factors!U49","v":{"$error":"#REF!"}},{"$f":"+J222/100*bid_factors!V49","v":{"$error":"#REF!"}},{"$f":"+C240/100*bid_factors!W49+I241*bid_factors!K147*4+auction_results_and_rates!I245*bid_factors!K149*4","v":{"$error":"#REF!"}},{"$f":"+E241/100*bid_factors!X50+auction_results_and_rates!E242/100*bid_factors!X51+auction_results_and_rates!J241*bid_factors!L147*4+auction_results_and_rates!J245*bid_factors!L149*4","v":{"$error":"#REF!"}}]
[null,"Winter",{"$f":"+C229/100*bid_factors!O45","v":{"$error":"#REF!"}},{"$f":"+D229/100*bid_factors!P45","v":{"$error":"#REF!"}},{"$f":"+E230/100*bid_factors!Q46+auction_results_and_rates!E231/100*bid_factors!Q47","v":{"$error":"#REF!"}},{"$f":"+F229/100*bid_factors!R45","v":{"$error":"#REF!"}},{"$f":"+G229/100*bid_factors!S45","v":{"$error":"#REF!"}},{"$f":"+H229/100*bid_factors!T45","v":{"$error":"#REF!"}},{"$f":"+I229/100*bid_factors!U45","v":{"$error":"#REF!"}},{"$f":"+J229/100*bid_factors!V45","v":{"$error":"#REF!"}},{"$f":"+C244/100*bid_factors!W45+auction_results_and_rates!I242*bid_factors!K147*8+auction_results_and_rates!I245*bid_factors!K149*8","v":{"$error":"#REF!"}},{"$f":"+E245/100*bid_factors!X46+auction_results_and_rates!E246/100*bid_factors!X47+auction_results_and_rates!J242*bid_factors!L147*8+auction_results_and_rates!J245*bid_factors!L149*8","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"+C256+C255","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Total Summer",{"$f":"SUM(C255:L255)","v":{"$error":"#REF!"}}]
[null,"Total Winter",{"$f":"SUM(C256:L256)","v":{"$error":"#REF!"}}]
[null,"Grand Total",{"$f":"+C260+C259","v":{"$error":"#REF!"}}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,null,"BGS-FP Auction","NITS Differential Adder","Total"]
[null,"Summer",{"$f":"+SUM(C24:E24)","v":1005249.1966659843},{"$f":"bid_factors!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C266:D266)","v":{"$error":"#REF!"}}]
[null,"Winter",{"$f":"+SUM(C25:E25)","v":1531046.4229790242},{"$f":"bid_factors!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C267:D267)","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"+C267+C266","v":2536295.6196450088},{"$f":"+D267+D266","v":{"$error":"#REF!"}},{"$f":"+E267+E266","v":{"$error":"#REF!"}}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C259-E266","v":{"$error":"#REF!"}},null,{"$f":"+C271/C259","v":{"$error":"#REF!"}}]
[null,"Winter",{"$f":"+C260-E267","v":{"$error":"#REF!"}},null,{"$f":"+C272/C260","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"+C261-E268","v":{"$error":"#REF!"}},null,{"$f":"+C273/C261","v":{"$error":"#REF!"}}]