{"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-RSCP Cost and Bid Factors for 2018/2019 BGS Filing"]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,"Based on average of year 2014,2015 & 2016 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.47570000000000001,0.46899999999999997,0.48270000000000002,0.43669999999999998,0.43669999999999998,0.4713,0.29970000000000002,0.29970000000000002,0.55600000000000005,0.53700000000000003]
[null,"February",0.502,0.48499999999999999,0.50929999999999997,0.45269999999999999,0.45269999999999999,0.48530000000000001,0.29670000000000002,0.29670000000000002,0.57330000000000003,0.56030000000000002]
[null,"March",0.49199999999999999,0.48870000000000002,0.49930000000000002,0.46400000000000002,0.46400000000000002,0.47870000000000001,0.253,0.253,0.57730000000000004,0.56269999999999998]
[null,"April",0.51029999999999998,0.51829999999999998,0.51670000000000005,0.46729999999999999,0.46729999999999999,0.50829999999999997,0.2293,0.2293,0.59499999999999997,0.58030000000000004]
[null,"May",0.46800000000000003,0.48470000000000002,0.48270000000000002,0.42030000000000001,0.42030000000000001,0.54269999999999996,0.20200000000000001,0.20200000000000001,0.56699999999999995,0.55300000000000005]
[null,"June",0.53369999999999995,0.54330000000000001,0.55430000000000001,0.46899999999999997,0.46899999999999997,0.64170000000000005,0.20369999999999999,0.20369999999999999,0.61429999999999996,0.59]
[null,"July",0.52829999999999999,0.5353,0.54930000000000001,0.47799999999999998,0.47799999999999998,0.64400000000000002,0.1953,0.1953,0.6,0.56699999999999995]
[null,"August",0.51300000000000001,0.52600000000000002,0.5373,0.50370000000000004,0.50370000000000004,0.63270000000000004,0.21199999999999999,0.21199999999999999,0.59530000000000005,0.56069999999999998]
[null,"September",0.502,0.52070000000000005,0.52500000000000002,0.48970000000000002,0.48970000000000002,0.63100000000000001,0.23769999999999999,0.23769999999999999,0.59699999999999998,0.56830000000000003]
[null,"October",0.50070000000000003,0.51670000000000005,0.52100000000000002,0.504,0.504,0.57230000000000003,0.2697,0.2697,0.59870000000000001,0.57669999999999999]
[null,"November",0.45669999999999999,0.45469999999999999,0.47970000000000002,0.42399999999999999,0.42399999999999999,0.47070000000000001,0.29799999999999999,0.29799999999999999,0.55469999999999997,0.5333]
[null,"December",0.49230000000000002,0.49170000000000003,0.51270000000000004,0.45500000000000002,0.45500000000000002,0.49730000000000002,0.318,0.318,0.57399999999999995,0.54830000000000001]
[]
[null,null,null,null,"Based on average of year 2014, 2015 & 2016 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 2014, 2015 & 2016)"]
[null,null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RLM","LPL-S"]
[]
[null,"January",0.43409999999999999,0.48459999999999998]
[null,"February",0.42659999999999998,0.48249999999999998]
[null,"March",0.41970000000000002,0.48480000000000001]
[null,"April",0.42299999999999999,0.49020000000000002]
[null,"May",0.44019999999999998,0.50590000000000002]
[null,"June",0.46579999999999999,0.51170000000000004]
[null,"July",0.4894,0.51300000000000001]
[null,"August",0.48180000000000001,0.50580000000000003]
[null,"September",0.48480000000000001,0.50839999999999996]
[null,"October",0.45929999999999999,0.51300000000000001]
[null,"November",0.43580000000000002,0.50390000000000001]
[null,"December",0.43120000000000003,0.49109999999999998]
[]
[]
["Table #3","Class Usage @ customer"]
[null,"calendar month sales forecasted for 2018, 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",1046226.9803722645,20269.48548847908,17920.82019425742,131,3,2531.5984050932002,16433,31380,540032.49328409287,618043.99327527231]
[null,"February",890995.66366619279,17115.969077571226,14519.571085566635,139,3,2132.0965033473353,14486,29833,501922.35325672565,602193.31770700612]
[null,"March",869461.35242252576,15107.632067914465,15191.066323071032,118,3,2019.6567356917826,13475,26173,520694.99650067708,617360.81365211378]
[null,"April",776635.47644123051,9125.3516136177259,14323.05860968116,129,3,1195.0984395510634,12345,23503,503500.69221160281,552517.14087284321]
[null,"May",804206.82560811564,6595.7015929436748,14690.937415248756,119,2,651.6395625492255,10458,21900,509234.56519134471,627125.15679412219]
[null,"June",1185203.9435420637,7215.7697098731624,22053.170220342035,93,3,900.36995766605412,10264,18101,551415.71439738327,606560.99598155764]
[null,"July",1578158.4480166801,8472.0486052754786,29501.086190276379,79,1,895.25905913625627,10333,18677,652821.9604009795,703284.43812753016]
[null,"August",1468970.8643378057,8098.8682531264913,25876.315782000216,78,2,823.70647971908636,11212,20782,635276.55290464114,698740.93679706601]
[null,"September",1016761.5303941517,6008.8683674269478,19559.976391216835,78,1,804.96651844316091,12484,21773,539118.1620151758,605139.48928227916]
[null,"October",781499.08670564461,7601.2944502611745,14770.101208851909,98,2,929.33171600157527,14901,24425,491883.40229346958,590915.98797315964]
[null,"November",785899.67380477104,10255.337921651553,12934.43253600702,106,2,1090.3250196902075,15525,28254,459720.8855780444,552723.4572262757]
[null,"December",979239.85074580973,14916.768834372617,16795.762986344369,115,2,1766.6672584667892,17052,31467,514762.81522794341,574214.09524859348]
[]
[]
[null,"LPL-S > 500 kW PLS","% of","% of"]
[null,null,"kWh","Gen Obl"]
[null,null,0.39235454228816002,0.37054372342479364]
[]
[]
[]
["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",50.45,null,"Summer",0.63277854259404198]
[null,"February",47.55,null,"Winter",0.73177018623467571]
[null,"March",35.130000000000003]
[null,"April",30.38]
[null,"May",31.55]
[null,"June",33.549999999999997,null,null,"Basis"]
[null,"July",41.74,null,null,"On-Peak","Off-Peak"]
[null,"August",37.880000000000003,null,"Summer",0.93597529595311468,0.87669709660592343]
[null,"September",32.119999999999997,null,"Winter",0.99579791999572242,0.97945749962685158]
[null,"October",31]
[null,"November",30.88]
[null,"December",33.9]
[]
[]
[]
["Table #6","Loss Type","Percentage","Source"]
[null,"Delivery Losses",7.5377E-2,"Tariff (Result of 2000 Loss Study)"]
[null,"EHV Losses",4.5599999999999998E-3,"PJM"]
[null,"Marginal Loss Deration Factor",1.07687434555201E-2,"NERA"]
[]
[]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments"]
[null,"obligations - Peak Load shares eff 6/1/17, scaling factors eff 6/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",3614.8035376744388,23.643695494965005,69.399876937336387,0,0,2.8850730932572,0,0,1791.2766878838574,1397.5169179511906]
[null,"Tranmsission Obligation",3884.3082612142225,25.019442282317307,73.093907081139662,0,0,2.9247629259559189,0,0,1779.5058449484745,1369.6951113062776]
[]
[null,"Final Zonal RPM Scaling Factor",1.0459721343534554]
[null,"PJM June 1, 2017 (through May 31, 2018) Forecast Pool Requirement",1.0967]
[]
[null,"NITS Rate",null,"Tranches","NITS Rate"]
[null,null,2016,28,82516.44]
[null,null,2017,28,91224.18]
[null,null,2018,29,91224.18]
[]
[null,null,null,null,"Base\nCapacity"]
[null,"Generation Capacity cost","summer =",null,168.47364367310715,"$/MW/day"]
[null,null,"winter =",null,168.47364367310715,"$/MW/day"]
[null,null,"Incremental RPM Capacity",null,0,"$/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.4,"per MWh @  bulk system"]
[]
[]
[]
[]
["Bill Impacts","BGS - CIEP BRA Clearing Price ($ per MW/Day)"]
[null,"Annual Obligation Clearing Price",null,276.83,"per MWh"]
[]
[]
[]
[]
["auction results and rates","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2016 auction","remaining portion of 36 month bid - 2017 auction","36 month bid - 2018 auction"]
[null,"Winning Bid - in $/MWh",96.38,90.78,90.78]
[null,"# of Tranches for Bid",28,28,29]
[]
[null,"Payment Factors"]
[null,"                           Summer",1,1,1]
[null,"                           Winter",1,1,1]

{"sheet":"bid_factors","index":1,"n_rows":354,"n_cols":39,"rows_kept":354,"cut":false,"hidden":false,"merged":[[144,17,144,21]]}
[" "]
[null,{"$f":"\"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 2014,2015 & 2016 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.47570000000000001},{"$f":"Input!D14","v":0.46899999999999997},{"$f":"Input!E14","v":0.48270000000000002},{"$f":"Input!F14","v":0.43669999999999998},{"$f":"Input!G14","v":0.43669999999999998},{"$f":"Input!H14","v":0.4713},{"$f":"Input!I14","v":0.29970000000000002},{"$f":"Input!J14","v":0.29970000000000002},{"$f":"Input!K14","v":0.55600000000000005},{"$f":"Input!L14","v":0.53700000000000003},null,null,{"$f":"1-C9","v":0.52429999999999999},0.53100000000000003,0.51729999999999998,0.56330000000000002,0.56330000000000002,0.52869999999999995,0.70029999999999992,0.70029999999999992,0.44399999999999995,0.46299999999999997]
[null,"February",{"$f":"Input!C15","v":0.502},{"$f":"Input!D15","v":0.48499999999999999},{"$f":"Input!E15","v":0.50929999999999997},{"$f":"Input!F15","v":0.45269999999999999},{"$f":"Input!G15","v":0.45269999999999999},{"$f":"Input!H15","v":0.48530000000000001},{"$f":"Input!I15","v":0.29670000000000002},{"$f":"Input!J15","v":0.29670000000000002},{"$f":"Input!K15","v":0.57330000000000003},{"$f":"Input!L15","v":0.56030000000000002},null,null,{"$f":"1-C10","v":0.498},{"$f":"1-D10","v":0.51500000000000001},{"$f":"1-E10","v":0.49070000000000003},{"$f":"1-F10","v":0.54730000000000001},{"$f":"1-G10","v":0.54730000000000001},{"$f":"1-H10","v":0.51469999999999994},{"$f":"1-I10","v":0.70330000000000004},{"$f":"1-J10","v":0.70330000000000004},{"$f":"1-K10","v":0.42669999999999997},{"$f":"1-L10","v":0.43969999999999998}]
[null,"March",{"$f":"Input!C16","v":0.49199999999999999},{"$f":"Input!D16","v":0.48870000000000002},{"$f":"Input!E16","v":0.49930000000000002},{"$f":"Input!F16","v":0.46400000000000002},{"$f":"Input!G16","v":0.46400000000000002},{"$f":"Input!H16","v":0.47870000000000001},{"$f":"Input!I16","v":0.253},{"$f":"Input!J16","v":0.253},{"$f":"Input!K16","v":0.57730000000000004},{"$f":"Input!L16","v":0.56269999999999998},null,null,0.50800000000000001,0.51129999999999998,0.50069999999999992,0.53600000000000003,0.53600000000000003,0.52129999999999999,0.747,0.747,0.42269999999999996,0.43730000000000002]
[null,"April",{"$f":"Input!C17","v":0.51029999999999998},{"$f":"Input!D17","v":0.51829999999999998},{"$f":"Input!E17","v":0.51670000000000005},{"$f":"Input!F17","v":0.46729999999999999},{"$f":"Input!G17","v":0.46729999999999999},{"$f":"Input!H17","v":0.50829999999999997},{"$f":"Input!I17","v":0.2293},{"$f":"Input!J17","v":0.2293},{"$f":"Input!K17","v":0.59499999999999997},{"$f":"Input!L17","v":0.58030000000000004},null,null,0.48970000000000002,0.48170000000000002,0.48329999999999995,0.53269999999999995,0.53269999999999995,0.49170000000000003,0.77069999999999994,0.77069999999999994,0.40500000000000003,0.41969999999999996]
[null,"May",{"$f":"Input!C18","v":0.46800000000000003},{"$f":"Input!D18","v":0.48470000000000002},{"$f":"Input!E18","v":0.48270000000000002},{"$f":"Input!F18","v":0.42030000000000001},{"$f":"Input!G18","v":0.42030000000000001},{"$f":"Input!H18","v":0.54269999999999996},{"$f":"Input!I18","v":0.20200000000000001},{"$f":"Input!J18","v":0.20200000000000001},{"$f":"Input!K18","v":0.56699999999999995},{"$f":"Input!L18","v":0.55300000000000005},null,null,0.53200000000000003,0.51529999999999998,0.51729999999999998,0.57969999999999999,0.57969999999999999,0.45730000000000004,0.79800000000000004,0.79800000000000004,0.43300000000000005,0.44699999999999995]
[null,"June",{"$f":"Input!C19","v":0.53369999999999995},{"$f":"Input!D19","v":0.54330000000000001},{"$f":"Input!E19","v":0.55430000000000001},{"$f":"Input!F19","v":0.46899999999999997},{"$f":"Input!G19","v":0.46899999999999997},{"$f":"Input!H19","v":0.64170000000000005},{"$f":"Input!I19","v":0.20369999999999999},{"$f":"Input!J19","v":0.20369999999999999},{"$f":"Input!K19","v":0.61429999999999996},{"$f":"Input!L19","v":0.59},null,null,0.46630000000000005,0.45669999999999999,0.44569999999999999,0.53100000000000003,0.53100000000000003,0.35829999999999995,0.79630000000000001,0.79630000000000001,0.38570000000000004,0.41000000000000003]
[null,"July",{"$f":"Input!C20","v":0.52829999999999999},{"$f":"Input!D20","v":0.5353},{"$f":"Input!E20","v":0.54930000000000001},{"$f":"Input!F20","v":0.47799999999999998},{"$f":"Input!G20","v":0.47799999999999998},{"$f":"Input!H20","v":0.64400000000000002},{"$f":"Input!I20","v":0.1953},{"$f":"Input!J20","v":0.1953},{"$f":"Input!K20","v":0.6},{"$f":"Input!L20","v":0.56699999999999995},null,null,0.47170000000000001,0.4647,0.45069999999999999,0.52200000000000002,0.52200000000000002,0.35599999999999998,0.80469999999999997,0.80469999999999997,0.4,0.43300000000000005]
[null,"August",{"$f":"Input!C21","v":0.51300000000000001},{"$f":"Input!D21","v":0.52600000000000002},{"$f":"Input!E21","v":0.5373},{"$f":"Input!F21","v":0.50370000000000004},{"$f":"Input!G21","v":0.50370000000000004},{"$f":"Input!H21","v":0.63270000000000004},{"$f":"Input!I21","v":0.21199999999999999},{"$f":"Input!J21","v":0.21199999999999999},{"$f":"Input!K21","v":0.59530000000000005},{"$f":"Input!L21","v":0.56069999999999998},null,null,0.48699999999999999,0.47399999999999998,0.4627,0.49629999999999996,0.49629999999999996,0.36729999999999996,0.78800000000000003,0.78800000000000003,0.40469999999999995,0.43930000000000002]
[null,"September",{"$f":"Input!C22","v":0.502},{"$f":"Input!D22","v":0.52070000000000005},{"$f":"Input!E22","v":0.52500000000000002},{"$f":"Input!F22","v":0.48970000000000002},{"$f":"Input!G22","v":0.48970000000000002},{"$f":"Input!H22","v":0.63100000000000001},{"$f":"Input!I22","v":0.23769999999999999},{"$f":"Input!J22","v":0.23769999999999999},{"$f":"Input!K22","v":0.59699999999999998},{"$f":"Input!L22","v":0.56830000000000003},null,null,0.498,0.47929999999999995,0.47499999999999998,0.51029999999999998,0.51029999999999998,0.36899999999999999,0.76229999999999998,0.76229999999999998,0.40300000000000002,0.43169999999999997]
[null,"October",{"$f":"Input!C23","v":0.50070000000000003},{"$f":"Input!D23","v":0.51670000000000005},{"$f":"Input!E23","v":0.52100000000000002},{"$f":"Input!F23","v":0.504},{"$f":"Input!G23","v":0.504},{"$f":"Input!H23","v":0.57230000000000003},{"$f":"Input!I23","v":0.2697},{"$f":"Input!J23","v":0.2697},{"$f":"Input!K23","v":0.59870000000000001},{"$f":"Input!L23","v":0.57669999999999999},null,null,0.49929999999999997,0.48329999999999995,0.47899999999999998,0.496,0.496,0.42769999999999997,0.73029999999999995,0.73029999999999995,0.40129999999999999,0.42330000000000001]
[null,"November",{"$f":"Input!C24","v":0.45669999999999999},{"$f":"Input!D24","v":0.45469999999999999},{"$f":"Input!E24","v":0.47970000000000002},{"$f":"Input!F24","v":0.42399999999999999},{"$f":"Input!G24","v":0.42399999999999999},{"$f":"Input!H24","v":0.47070000000000001},{"$f":"Input!I24","v":0.29799999999999999},{"$f":"Input!J24","v":0.29799999999999999},{"$f":"Input!K24","v":0.55469999999999997},{"$f":"Input!L24","v":0.5333},null,null,0.54330000000000001,0.54530000000000001,0.52029999999999998,0.57600000000000007,0.57600000000000007,0.52929999999999999,0.70199999999999996,0.70199999999999996,0.44530000000000003,0.4667]
[null,"December",{"$f":"Input!C25","v":0.49230000000000002},{"$f":"Input!D25","v":0.49170000000000003},{"$f":"Input!E25","v":0.51270000000000004},{"$f":"Input!F25","v":0.45500000000000002},{"$f":"Input!G25","v":0.45500000000000002},{"$f":"Input!H25","v":0.49730000000000002},{"$f":"Input!I25","v":0.318},{"$f":"Input!J25","v":0.318},{"$f":"Input!K25","v":0.57399999999999995},{"$f":"Input!L25","v":0.54830000000000001},null,null,0.50770000000000004,0.50829999999999997,0.48729999999999996,0.54499999999999993,0.54499999999999993,0.50269999999999992,0.68199999999999994,0.68199999999999994,0.42600000000000005,0.45169999999999999]
[]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2014,2015 & 2016 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 2014, 2015 & 2016)"]
[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.43409999999999999},0,0,0,0,0,0,{"$f":"Input!D32","v":0.48459999999999998},null,null,null,null,{"$f":"1-E27","v":0.56590000000000007},null,null,null,null,null,null,{"$f":"1-L27","v":0.51540000000000008}]
[null,"February",0,0,{"$f":"Input!C33","v":0.42659999999999998},0,0,0,0,0,0,{"$f":"Input!D33","v":0.48249999999999998},null,null,null,null,0.57340000000000002,null,null,null,null,null,null,0.51750000000000007]
[null,"March",0,0,{"$f":"Input!C34","v":0.41970000000000002},0,0,0,0,0,0,{"$f":"Input!D34","v":0.48480000000000001},null,null,null,null,0.58030000000000004,null,null,null,null,null,null,0.51519999999999999]
[null,"April",0,0,{"$f":"Input!C35","v":0.42299999999999999},0,0,0,0,0,0,{"$f":"Input!D35","v":0.49020000000000002},null,null,null,null,0.57699999999999996,null,null,null,null,null,null,0.50980000000000003]
[null,"May",0,0,{"$f":"Input!C36","v":0.44019999999999998},0,0,0,0,0,0,{"$f":"Input!D36","v":0.50590000000000002},null,null,null,null,0.55980000000000008,null,null,null,null,null,null,0.49409999999999998]
[null,"June",0,0,{"$f":"Input!C37","v":0.46579999999999999},0,0,0,0,0,0,{"$f":"Input!D37","v":0.51170000000000004},null,null,null,null,0.53420000000000001,null,null,null,null,null,null,0.48829999999999996]
[null,"July",0,0,{"$f":"Input!C38","v":0.4894},0,0,0,0,0,0,{"$f":"Input!D38","v":0.51300000000000001},null,null,null,null,0.51059999999999994,null,null,null,null,null,null,0.48699999999999999]
[null,"August",0,0,{"$f":"Input!C39","v":0.48180000000000001},0,0,0,0,0,0,{"$f":"Input!D39","v":0.50580000000000003},null,null,null,null,0.51819999999999999,null,null,null,null,null,null,0.49419999999999997]
[null,"September",0,0,{"$f":"Input!C40","v":0.48480000000000001},0,0,0,0,0,0,{"$f":"Input!D40","v":0.50839999999999996},null,null,null,null,0.51519999999999999,null,null,null,null,null,null,0.49160000000000004]
[null,"October",0,0,{"$f":"Input!C41","v":0.45929999999999999},0,0,0,0,0,0,{"$f":"Input!D41","v":0.51300000000000001},null,null,null,null,0.54069999999999996,null,null,null,null,null,null,0.48699999999999999]
[null,"November",0,0,{"$f":"Input!C42","v":0.43580000000000002},0,0,0,0,0,0,{"$f":"Input!D42","v":0.50390000000000001},null,null,null,null,0.56420000000000003,null,null,null,null,null,null,0.49609999999999999]
[null,"December",0,0,{"$f":"Input!C43","v":0.43120000000000003},0,0,0,0,0,0,{"$f":"Input!D43","v":0.49109999999999998},null,null,null,null,0.56879999999999997,null,null,null,null,null,null,0.50890000000000002]
[]
[]
["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":1046226.9803722645},{"$f":"Input!D50","v":20269.48548847908},{"$f":"Input!E50","v":17920.82019425742},{"$f":"Input!F50","v":131},{"$f":"Input!G50","v":3},{"$f":"Input!H50","v":2531.5984050932002},{"$f":"Input!I50","v":16433},{"$f":"Input!J50","v":31380},{"$f":"Input!K50","v":540032.49328409287},{"$f":"AB45*$M$45","v":375551.6251798062},{"$f":"(1-AD45)","v":0.60764545771183998},"winter MWh =",{"$f":"SUM(C45:C49,C54:C56)","v":6934164.9097665548},{"$f":"SUM(D45:D49,D54:D56)","v":100987.54104681152},121145.7503590283,955,20,12316.413640391178,114675,216935,4041752.2035439005,2877258.3383034207,{"$f":"SUM(O45:X45)","v":14420210.156660106},{"$f":"+Y45/(Y45+Y49)","v":0.60360035776671983},null,{"$f":"Input!L50","v":618043.99327527231},null,{"$f":"Input!C66","v":0.39235454228816002},{"$f":"Input!D66","v":0.37054372342479364},{"$f":"AE45","v":0.37054372342479364}]
[null,"February",{"$f":"Input!C51","v":890995.66366619279},{"$f":"Input!D51","v":17115.969077571226},{"$f":"Input!E51","v":14519.571085566635},{"$f":"Input!F51","v":139},{"$f":"Input!G51","v":3},{"$f":"Input!H51","v":2132.0965033473353},{"$f":"Input!I51","v":14486},{"$f":"Input!J51","v":29833},{"$f":"Input!K51","v":501922.35325672565},{"$f":"AB46*$M$45","v":365920.03416908521},null,"on-peak",null,null,{"$f":"SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56)","v":52537.838233439645},null,null,null,null,null,null,{"$f":"SUMPRODUCT(L27:L31,L45:L49)+SUMPRODUCT(L36:L38,L54:L56)","v":1422570.4665419753},null,null,null,{"$f":"Input!L51","v":602193.31770700612}]
[null,"March",{"$f":"Input!C52","v":869461.35242252576},{"$f":"Input!D52","v":15107.632067914465},{"$f":"Input!E52","v":15191.066323071032},{"$f":"Input!F52","v":118},{"$f":"Input!G52","v":3},{"$f":"Input!H52","v":2019.6567356917826},{"$f":"Input!I52","v":13475},{"$f":"Input!J52","v":26173},{"$f":"Input!K52","v":520694.99650067708},375136.49418499263,null,"off-peak",{"$f":"+O45-O46","v":6934164.9097665548},{"$f":"+P45-P46","v":100987.54104681152},{"$f":"+Q45-Q46","v":68607.912125588657},{"$f":"+R45-R46","v":955},null,null,null,null,null,{"$f":"+X45-X46","v":1454687.8717614454},null,null,null,{"$f":"Input!L52","v":617360.81365211378}]
[null,"April",{"$f":"Input!C53","v":776635.47644123051},{"$f":"Input!D53","v":9125.3516136177259},{"$f":"Input!E53","v":14323.05860968116},{"$f":"Input!F53","v":129},{"$f":"Input!G53","v":3},{"$f":"Input!H53","v":1195.0984395510634},{"$f":"Input!I53","v":12345},{"$f":"Input!J53","v":23503},{"$f":"Input!K53","v":503500.69221160281},335734.53095931601,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L53","v":552517.14087284321}]
[null,"May",{"$f":"Input!C54","v":804206.82560811564},{"$f":"Input!D54","v":6595.7015929436748},{"$f":"Input!E54","v":14690.937415248756},{"$f":"Input!F54","v":119},{"$f":"Input!G54","v":2},{"$f":"Input!H54","v":651.6395625492255},{"$f":"Input!I54","v":10458},{"$f":"Input!J54","v":21900},{"$f":"Input!K54","v":509234.56519134471},381069.7529427738,null,"summer MWh =",{"$f":"SUM(C50:C53)","v":5249094.7862907015},{"$f":"+SUM(D50:D53)","v":29795.554935702079},96990.548583835451,328,7,3424.3020149645577,44293,79333,2378632.3897181801,1588218.6466474729,{"$f":"SUM(O49:X49)","v":9470117.2281908579},{"$f":"1-Z45","v":0.39639964223328017},null,{"$f":"Input!L54","v":627125.15679412219}]
[null,"June",{"$f":"Input!C55","v":1185203.9435420637},{"$f":"Input!D55","v":7215.7697098731624},{"$f":"Input!E55","v":22053.170220342035},{"$f":"Input!F55","v":93},{"$f":"Input!G55","v":3},{"$f":"Input!H55","v":900.36995766605412},{"$f":"Input!I55","v":10264},{"$f":"Input!J55","v":18101},{"$f":"Input!K55","v":551415.71439738327},368574.0340333631,null,"on-peak",null,null,{"$f":"+SUMPRODUCT(E32:E35,E50:E53)","v":46660.083768386205},null,null,null,null,null,null,{"$f":"+SUMPRODUCT(L32:L35,L50:L53)","v":809528.52763515909},null,null,null,{"$f":"Input!L55","v":606560.99598155764}]
[null,"July",{"$f":"Input!C56","v":1578158.4480166801},{"$f":"Input!D56","v":8472.0486052754786},{"$f":"Input!E56","v":29501.086190276379},{"$f":"Input!F56","v":79},{"$f":"Input!G56","v":1},{"$f":"Input!H56","v":895.25905913625627},{"$f":"Input!I56","v":10333},{"$f":"Input!J56","v":18677},{"$f":"Input!K56","v":652821.9604009795},427347.59430761728,null,"off-peak",null,null,{"$f":"+Q49-Q50","v":50330.464815449246},null,null,null,null,null,null,{"$f":"+X49-X50","v":778690.11901231378},null,null,null,{"$f":"Input!L56","v":703284.43812753016}]
[null,"August",{"$f":"Input!C57","v":1468970.8643378057},{"$f":"Input!D57","v":8098.8682531264913},{"$f":"Input!E57","v":25876.315782000216},{"$f":"Input!F57","v":78},{"$f":"Input!G57","v":2},{"$f":"Input!H57","v":823.70647971908636},{"$f":"Input!I57","v":11212},{"$f":"Input!J57","v":20782},{"$f":"Input!K57","v":635276.55290464114},424586.75636205304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L57","v":698740.93679706601}]
[null,"September",{"$f":"Input!C58","v":1016761.5303941517},{"$f":"Input!D58","v":6008.8683674269478},{"$f":"Input!E58","v":19559.976391216835},{"$f":"Input!F58","v":78},{"$f":"Input!G58","v":1},{"$f":"Input!H58","v":804.96651844316091},{"$f":"Input!I58","v":12484},{"$f":"Input!J58","v":21773},{"$f":"Input!K58","v":539118.1620151758},367710.26194443961,null,"Block 1",{"$f":"+O49*C163","v":3396164.3267300841},{"$f":"+P49*D163","v":18860.586274299418},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L58","v":605139.48928227916}]
[null,"October",{"$f":"Input!C59","v":781499.08670564461},{"$f":"Input!D59","v":7601.2944502611745},{"$f":"Input!E59","v":14770.101208851909},{"$f":"Input!F59","v":98},{"$f":"Input!G59","v":2},{"$f":"Input!H59","v":929.33171600157527},{"$f":"Input!I59","v":14901},{"$f":"Input!J59","v":24425},{"$f":"Input!K59","v":491883.40229346958},359067.4159811947,null,"Block 2",{"$f":"+O49-O53","v":1852930.4595606173},{"$f":"+P49-P53","v":10934.968661402661},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L59","v":590915.98797315964}]
[null,"November",{"$f":"Input!C60","v":785899.67380477104},{"$f":"Input!D60","v":10255.337921651553},{"$f":"Input!E60","v":12934.43253600702},{"$f":"Input!F60","v":106},{"$f":"Input!G60","v":2},{"$f":"Input!H60","v":1090.3250196902075},{"$f":"Input!I60","v":15525},{"$f":"Input!J60","v":28254},{"$f":"Input!K60","v":459720.8855780444},335859.89815433091,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L60","v":552723.4572262757}]
[null,"December",{"$f":"Input!C61","v":979239.85074580973},{"$f":"Input!D61","v":14916.768834372617},{"$f":"Input!E61","v":16795.762986344369},{"$f":"Input!F61","v":115},{"$f":"Input!G61","v":2},{"$f":"Input!H61","v":1766.6672584667892},{"$f":"Input!I61","v":17052},{"$f":"Input!J61","v":31467},{"$f":"Input!K61","v":514762.81522794341},348918.58673192165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L61","v":574214.09524859348}]
[null,"Total",{"$f":"SUM(C45:C56)","v":12183259.696057254},{"$f":"SUM(D45:D56)","v":130783.09598251358},{"$f":"SUM(E45:E56)","v":218136.29894286377},1283,27,{"$f":"SUM(H45:H56)","v":15740.715655355738},{"$f":"SUM(I45:I56)","v":158968},{"$f":"SUM(J45:J56)","v":296268},6420384.5932620801,{"$f":"SUM(L45:L56)","v":4465476.9849508936},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":7348819.8229378201}]
[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":3377727.6133902729},{"$f":"SUMPRODUCT(D9:D13,D45:D49)+SUMPRODUCT(D18:D20,D54:D56)","v":49042.60602303232},60633.194451152507,431.84339999999997,9.0686999999999998,6079.4079236612306,31643.1515,59704.464500000002,2321897.9073213544,1600844.1684246073,{"$f":"SUM(O61:X61)","v":7508013.4256340805},{"$f":"+Y61/(Y61+Y62)","v":0.52065908499720692}]
[null,null,"On-Peak","LMP ratio","Off-Peak",null,null,"On-Peak","Off-Peak",null,null,null,null,"off-peak",{"$f":"+O45-O61","v":3556437.2963762819},{"$f":"+P45-P61","v":51944.935023779195},60512.555907875794,523.15660000000003,10.9313,6237.0057167299474,83031.848499999993,157230.5355,1719854.2962225461,1276414.1698788134,{"$f":"SUM(O62:X62)","v":6912196.7310260255},{"$f":"1-Z61","v":0.47934091500279308}]
[null,"January",{"$f":"Input!C73","v":50.45},{"$f":"Input!F74","v":0.73177018623467571},{"$f":"ROUND(+C63*D63,3)","v":36.917999999999999},null,null,{"$f":"Input!F81","v":0.99579791999572242},{"$f":"Input!G81","v":0.97945749962685158},"NYMEX Forwards (June 1, 2017) from NERA"]
[null,"February",{"$f":"Input!C74","v":47.55},{"$f":"+$D$63","v":0.73177018623467571},{"$f":"ROUND(+C64*D64,3)","v":34.795999999999999},null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158},null,null,null,null,"Summer"]
[null,"March",{"$f":"Input!C75","v":35.130000000000003},{"$f":"+$D$63","v":0.73177018623467571},{"$f":"ROUND(+C65*D65,3)","v":25.707000000000001},null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158},"Congestion Factors & On/Off Peak Ratios ",null,null,null,"on-peak",{"$f":"SUMPRODUCT(C14:C17,C50:C53)","v":2730280.7944187699},{"$f":"SUMPRODUCT(D14:D17,D50:D53)","v":15844.2377618418},52601.350972511958,158.86419999999998,3.3821000000000003,2183.4071987739567,9453.2024999999994,16916.017899999999,1430461.524262093,906800.30220733129,5164703.0835213223,{"$f":"+Y65/(Y65+Y66)","v":0.54536844255178996}]
[null,"April",{"$f":"Input!C76","v":30.38},{"$f":"+$D$63","v":0.73177018623467571},22.231000000000002,null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158},"Averages for Mar 2014-Feb 2017",null,null,null,"off-peak",{"$f":"+O49-O65","v":2518813.9918719316},{"$f":"+P49-P65","v":13951.31717386028},44389.197611323492,169.13580000000002,3.6178999999999997,1240.894816190601,34839.797500000001,62416.982100000001,948170.86545608705,681418.34444014158,4305414.1446695346,{"$f":"1-Z65","v":0.45463155744821004}]
[null,"May",{"$f":"Input!C77","v":31.55},{"$f":"+$D$63","v":0.73177018623467571},23.087,null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158}]
[null,"June",{"$f":"Input!C78","v":33.549999999999997},{"$f":"Input!F73","v":0.63277854259404198},21.23,null,null,{"$f":"Input!F80","v":0.93597529595311468},{"$f":"Input!G80","v":0.87669709660592343},null,null,null,null,"Total on-peak",{"$f":"+O61+O65","v":6108008.4078090433},{"$f":"+P61+P65","v":64886.843784874116},113234.54542366447,590.70759999999996,12.450800000000001,8262.8151224351877,41096.353999999999,76620.482400000008,3752359.4315834474,2507644.4706319384,12672716.509155404,{"$f":"+Y68/(Y68+Y69)","v":0.53045386549165785}]
[null,"July",{"$f":"Input!C79","v":41.74},{"$f":"+$D$68","v":0.63277854259404198},26.411999999999999,null,null,{"$f":"+$H$68","v":0.93597529595311468},{"$f":"+$I$68","v":0.87669709660592343},null,null,null,null,"Total off-peak",{"$f":"+O62+O66","v":6075251.288248213},{"$f":"+P62+P66","v":65896.252197639478},104901.75351919929,692.29240000000004,14.549199999999999,7477.9005329205484,117871.64599999999,219647.51759999999,2668025.1616786332,1957832.5143189551,11217610.87569556,{"$f":"1-Z68","v":0.46954613450834215}]
[null,"August",{"$f":"Input!C80","v":37.880000000000003},{"$f":"+$D$68","v":0.63277854259404198},23.97,null,null,{"$f":"+$H$68","v":0.93597529595311468},{"$f":"+$I$68","v":0.87669709660592343}]
[null,"September",{"$f":"Input!C81","v":32.119999999999997},{"$f":"+$D$68","v":0.63277854259404198},20.324999999999999,null,null,{"$f":"+$H$68","v":0.93597529595311468},{"$f":"+$I$68","v":0.87669709660592343}]
[null,"October",{"$f":"Input!C82","v":31},{"$f":"+$D$63","v":0.73177018623467571},22.684999999999999,null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158}]
[null,"November",{"$f":"Input!C83","v":30.88},{"$f":"+$D$63","v":0.73177018623467571},22.597000000000001,null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158}]
[null,"December",{"$f":"Input!C84","v":33.9},{"$f":"+$D$63","v":0.73177018623467571},24.806999999999999,null,null,{"$f":"+$H$63","v":0.99579791999572242},{"$f":"+$I$63","v":0.97945749962685158}]
[]
[]
["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":7.9593280880000061E-2},{"$f":"+$C79","v":7.9593280880000061E-2},{"$f":"+$C79","v":7.9593280880000061E-2},7.9593280880000061E-2,7.9593280880000061E-2,7.9593280880000061E-2,7.9593280880000061E-2,7.9593280880000061E-2,7.9593280880000061E-2,7.9593280880000061E-2,null,null,null,"EHV Losses",{"$f":"Input!C90","v":4.5599999999999998E-3},"PJM"]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C79),6)","v":1.086476},{"$f":"ROUND(1/(1-D79),6)","v":1.086476},1.086476,1.086476,1.086476,1.086476,1.086476,1.086476,1.086476,1.086476,null,null,null,"Marginal Loss Deration Factor",{"$f":"+Input!C91","v":1.07687434555201E-2},"NERA"]
[null,"     1 / Expansion Factor =",{"$f":"1/C80","v":0.92040689347946936},{"$f":"1/D80","v":0.92040689347946936},0.92040689347946936,0.92040689347946936,0.92040689347946936,0.92040689347946936,0.92040689347946936,0.92040689347946936,0.92040689347946936,0.92040689347946936,null,null,null,"Marginal Loss Factor",{"$f":"ROUND(1-((1-Q80)/(1-Q79)),7)","v":6.2372E-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.9573759390593182E-2},{"$f":"+$C84","v":6.9573759390593182E-2},{"$f":"+$C84","v":6.9573759390593182E-2},6.9573759390593182E-2,6.9573759390593182E-2,6.9573759390593182E-2,6.9573759390593182E-2,6.9573759390593182E-2,6.9573759390593182E-2,6.9573759390593182E-2]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C84),6)","v":1.074776},{"$f":"+$C$85","v":1.074776},{"$f":"+$C$85","v":1.074776},1.074776,1.074776,1.074776,1.074776,1.074776,1.074776,1.074776]
[null,"     1 / Expansion Factor =",{"$f":"1/C85","v":0.93042643304279227},{"$f":"1/D85","v":0.93042643304279227},0.93042643304279227,0.93042643304279227,0.93042643304279227,0.93042643304279227,0.93042643304279227,0.93042643304279227,0.93042643304279227,0.93042643304279227]
[]
[]
["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":30.235696570553767},30.26067491925523,30.542902223000791,29.092983713686081,28.711593482426583,31.553914489926456,24.967780705745628,25.010834553421169,31.198386851262782,30.690353151222652]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80)/SUMPRODUCT(C14:C17,C50:C53)","v":37.604237005813999},37.398084854448705,37.563219669615471,36.836502915092503,36.395583521254963,37.029425820961684,36.54611450439284,36.615295928906399,37.234951447791339,37.163840706488891]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUMPRODUCT(O14:O17,C50:C53)","v":22.248530984603665},22.154858199037513,22.223802040535965,21.8197276489377,21.528414646548999,21.91951945405069,21.826191435279679,21.86583667394877,22.091301083653594,22.075732603732416]
[]
[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":34.248779128145038},35.836360958230919,34.195517815934686,33.789951402413095,34.12295070666233,36.090563903469551,31.73750450061042,31.92111483188452,34.797501884538249,34.586690317229994]
[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":39.998386113422782},41.752699311173416,39.704157755694446,39.844423787778041,40.200712947094338,41.837302244816449,40.226280034728447,40.495171834527646,39.430409306339847,39.429751410223297]
[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":28.788087806495064},30.250587276745158,28.675895786792019,28.792243373684972,29.080787155226925,30.489035190119338,28.502461380071079,28.665325615703384,28.542822013620437,28.512653933899543]
[]
[null,"Annual",{"$f":"(C94*SUM(C50:C53)+C98*SUM(C45:C49,C54:C56))/C57","v":32.519763145926127},34.566084716255887,32.571445197845001,32.589167768818037,32.720006241119727,35.103641957344578,29.851267169537842,30.070718348527112,33.464097091084753,33.200895392850491]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C102:L102,C57:L57)/SUM(C57:L57)","v":32.866114739826841}]
[]
[]
["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":158710.03722836144},901.63360194809127,2962.372841951294,9.5424986580890341,0.20098115437698608,108.0501329678745,1105.897910799591,1984.1845376265617,74209.493471371447,48742.991146967841]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C50:C53,C14:C17)*C95/1000","v":102670.12608574556},592.54414827142,1975.876101499008,5.8520015664038372,0.12309350302723643,80.850314903953972,345.47782099821262,619.38500134717776,53263.165403832623,33700.181983829243]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C50:C53,O14:O17)*C96/1000","v":56039.911142615907},309.08945367667127,986.49674045228551,3.6904970916851978,7.7887651349749634E-2,27.199818063920532,760.42008980137837,1364.799536279384,20946.328067538812,15042.809163138601]
[]
[null,"Winter - all hrs",{"$f":"SUM(C45:C49,C54:C56)*C98/1000","v":237486.6824327285},3619.0259732376985,4142.641664726928,32.26940358930451,0.68245901413324661,444.50631355010188,3639.4983286074998,6924.8070460548679,140642.8799196555,99514.843109568174]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C45:C49,C9:C13)+SUMPRODUCT(C54:C56,C18:C20))*C99/1000","v":135103.65326635417},2047.6611827160109,2407.3899177202566,17.206551439554946,0.36456820550331442,254.34602677174692,1272.8862734203376,2417.7425492159555,91553.384853214942,63120.887607487901]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C45:C49,O9:O13)+SUMPRODUCT(C54:C56,O18:O20))*C100/1000","v":102383.0291663743},1571.3647905216887,1735.2517470066721,15.06285214974956,0.31789080862993213,190.1602867783549,2366.6120551871627,4507.0644968389106,49089.49506644057,36393.955502080295]
[]
[null,"Annual",{"$f":"+C112+C116","v":396196.71966108994},{"$f":"+D112+D116","v":4520.6595751857894},7105.0145066782225,41.811902247393547,0.88344016851023266,552.55644651797638,4745.3962394070913,8908.9915836814289,214852.37339102695,148257.83425653601]
[]
[null,"System Total",{"$f":"SUM(C120:L120)","v":785182.24100253929}]
[]
[]
["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":30.23569657055377},30.26067491925523,30.542902223000791,29.092983713686078,28.711593482426583,31.553914489926456,24.967780705745628,25.010834553421169,31.198386851262786,30.690353151222649]
[null,"PSE&G On pk",null,null,{"$f":"+(E113*1000-W131*AVERAGE(E$95,E$96))/Q131","v":38.539810060477414},null,null,null,null,null,null,{"$f":"+(L113*1000-X131*AVERAGE(L$95,L$96))/R131","v":38.070323307157246},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,E32:E35)","v":46660.083768386205},{"$f":"SUMPRODUCT(L50:L53,L32:L35)","v":809528.52763515909},null,{"$f":"SUMPRODUCT(E50:E53,E14:E17)","v":52601.350972511958},{"$f":"SUMPRODUCT(L50:L53,L14:L17)","v":906800.30220733129},null,{"$f":"+T131-Q131","v":5941.2672041257538},{"$f":"+U131-R131","v":97271.774572172202},null,{"$f":"+E131*Q131/1000","v":1798.2707658395695},{"$f":"+L131*R131/1000","v":30819.012773437484}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E114*1000-W132*AVERAGE(E$95,E$96))/Q132","v":23.129173958162919},null,null,null,null,null,null,{"$f":"+(L114*1000-X132*AVERAGE(L$95,L$96))/R132","v":23.018114569458042},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,Q32:Q35)","v":50330.464815449261},{"$f":"SUMPRODUCT(L50:L53,X32:X35)","v":778690.11901231389},null,{"$f":"SUMPRODUCT(E50:E53,Q14:Q17)","v":44389.197611323507},{"$f":"SUMPRODUCT(L50:L53,X14:X17)","v":681418.34444014169},null,{"$f":"+T132-Q132","v":-5941.2672041257538},{"$f":"+U132-R132","v":-97271.774572172202},null,{"$f":"+E132*Q132/1000","v":1164.102076111724},{"$f":"+L132*R132/1000","v":17923.978373530357}]
[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":2962.3728419512936},{"$f":"+AA132+AA131","v":48742.991146967841},null,{"$f":"+E112","v":2962.372841951294},{"$f":"+L112","v":48742.991146967841}]
[null,"Winter - all hrs",{"$f":"+C116/SUM(C45:C49,C54:C56)*1000","v":34.248779128145038},35.836360958230912,34.195517815934686,33.789951402413102,34.12295070666233,36.090563903469558,31.73750450061042,31.92111483188452,34.797501884538249,34.586690317229987]
[null,"PSE&G On pk",null,null,{"$f":"+(E117*1000-W135*AVERAGE(E$99,E$100))/Q135","v":40.553809284025661},null,null,null,null,null,null,{"$f":"+(L117*1000-X135*AVERAGE(L$99,L$100))/R135","v":40.113805882986512},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38)","v":52537.838233439645},{"$f":"SUMPRODUCT(L45:L49,L27:L31)+SUMPRODUCT(L54:L56,L36:L38)","v":1422570.4665419753},null,{"$f":"SUMPRODUCT(E45:E49,E9:E13)+SUMPRODUCT(E54:E56,E18:E20)","v":60633.194451152507},{"$f":"SUMPRODUCT(L45:L49,L9:L13)+SUMPRODUCT(L54:L56,L18:L20)","v":1600844.1684246073},null,{"$f":"+T135-Q135","v":8095.3562177128624},{"$f":"+U135-R135","v":178273.70188263198},null,{"$f":"+E135*Q135/1000","v":2130.6094719139032},{"$f":"+L135*R135/1000","v":57064.715549734356}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E118*1000-W136*AVERAGE(E$99,E$100))/Q136","v":29.326532909643792},null,null,null,null,null,null,{"$f":"+(L118*1000-X136*AVERAGE(L$99,L$100))/R136","v":29.181605472816663},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,Q27:Q31)+SUMPRODUCT(E54:E56,Q36:Q38)","v":68607.912125588657},{"$f":"SUMPRODUCT(L45:L49,X27:X31)+SUMPRODUCT(L54:L56,X36:X38)","v":1454687.8717614461},null,{"$f":"SUMPRODUCT(E45:E49,Q9:Q13)+SUMPRODUCT(E54:E56,Q18:Q20)","v":60512.555907875794},{"$f":"SUMPRODUCT(L45:L49,X9:X13)+SUMPRODUCT(L54:L56,X18:X20)","v":1276414.1698788141},null,{"$f":"+T136-Q136","v":-8095.3562177128624},{"$f":"+U136-R136","v":-178273.70188263198},null,{"$f":"+E136*Q136/1000","v":2012.0321928130252},{"$f":"+L136*R136/1000","v":42450.12755983384}]
[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":4142.6416647269289},{"$f":"+AA136+AA135","v":99514.843109568203},null,{"$f":"+E116","v":4142.641664726928},{"$f":"+L116","v":99514.843109568174}]
[null,"Annual Average",{"$f":"(C130*SUM(C50:C53)+C134*SUM(C45:C49,C54:C56))/C57","v":32.519763145926127},34.56608471625588,32.571445197845001,32.589167768818044,32.720006241119727,35.103641957344585,29.851267169537842,30.070718348527112,33.464097091084753,33.200895392850491]
[null,"System Average",{"$f":"+C122/SUM(C57:L57)*1000","v":32.866114739826848}]
[]
[]
["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":3614.8035376744388},{"$f":"Input!D101","v":23.643695494965005},{"$f":"Input!E101","v":69.399876937336387},{"$f":"Input!F101","v":0},{"$f":"Input!G101","v":0},{"$f":"Input!H101","v":2.8850730932572},{"$f":"Input!I101","v":0},{"$f":"Input!J101","v":0},{"$f":"Input!K101","v":1791.2766878838574},{"$f":"Input!L101","v":1397.5169179511906}]
[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":3884.3082612142225},{"$f":"Input!D102","v":25.019442282317307},{"$f":"Input!E102","v":73.093907081139662},{"$f":"Input!F102","v":0},{"$f":"Input!G102","v":0},{"$f":"Input!H102","v":2.9247629259559189},{"$f":"Input!I102","v":0},{"$f":"Input!J102","v":0},{"$f":"Input!K102","v":1779.5058449484745},{"$f":"Input!L102","v":1369.6951113062776}]
[null,"Gen Obl - MW",{"$f":"ROUND(AD145*$AD$148*$AD$149,1)","v":4146.6000000000004},{"$f":"ROUND(AE145*$AD$148*$AD$149,1)","v":27.1},79.599999999999994,0,0,3.3,0,0,2054.8000000000002,{"$f":"ROUND(AM145*$AD$148*$AD$149*(1-AE45),1)","v":1009.1},null,null,null,null,null,{"$f":"Input!C108","v":2016}," NITS Rate",{"$f":"Input!D108","v":28},{"$f":"Input!E108","v":82516.44},{"$f":"U147/$T$150*T147","v":27181.88611764706}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!C109","v":2017}," NITS Rate",{"$f":"Input!D109","v":28},{"$f":"Input!E109","v":91224.18},{"$f":"U148/$T$150*T148","v":30050.318117647053},null,null,null,null,null,null,"Final Zonal RPM Scaling Factor",{"$f":"Input!C104","v":1.0459721343534554}]
[null,"Trans Obl - MW",{"$f":"ROUND(AD146,1)","v":3884.3},{"$f":"ROUND(AE146,1)","v":25},73.099999999999994,0,0,2.9,0,0,1779.5,{"$f":"ROUND(AM146*(1-AF45),1)","v":862.2},null,null,null,null,null,{"$f":"Input!C110","v":2018}," NITS Rate",{"$f":"Input!D110","v":29},{"$f":"Input!E110","v":91224.18},{"$f":"U149/$T$150*T149","v":31123.543764705879},null,{"$f":"+Input!B105","v":"PJM June 1, 2017 (through May 31, 2018) Forecast Pool Requirement"},null,null,null,null,null,{"$f":"Input!C105","v":1.0967}]
[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":88355.75}]
[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":88355.75},"per MW-yr"]
[]
[null,null,null,"Base\nCapacity","Incremental RPM Capacity","Total Capacity"]
[null,"Generation Capacity cost","summer =",{"$f":"Input!E113","v":168.47364367310715},0,{"$f":"SUM(D158:E158)","v":168.47364367310715},"$/MW/day"]
[null,null,"winter =",{"$f":"Input!E114","v":168.47364367310715},{"$f":"E158","v":0},{"$f":"SUM(D159:E159)","v":168.47364367310715},"$/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":61.492879940684112},"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.4}]
[null,"Total AncillaryServices & Renewable Power Costs",null,{"$f":"SUM(D169:D170)","v":10.4},"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":28.16982058061739},{"$f":"(+$D$155*D149*$H$154/12)/D57","v":16.889749653084685},{"$f":"(+$D$155*E149*$H$154/12)/SUMPRODUCT(E27:E38,E45:E56)","v":65.110288548999208},{"$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":16.278273530264666},{"$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":20.929240804458878},{"$f":"((+$Q$160*D147*1000)/D57)","v":12.742144035306779},{"$f":"(+$Q$160*E147*1000)/SUMPRODUCT(E45:E56,E27:E38)","v":49.344110688007753},{"$f":"((+$Q$160*F147*1000)/F57)","v":0},{"$f":"((+$Q$160*G147*1000)/G57)","v":0},{"$f":"((+$Q$160*H147*1000)/H57)","v":12.89182196333064},{"$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":16.236765841396736},{"$f":"(D147*$F$158*$E$152)/SUM(D50:D53)","v":18.694317387745677},{"$f":"(E147*$F$158*$E$152)/SUMPRODUCT(E50:E53,E32:E35)","v":35.063830072820799},{"$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":19.807683039165269},{"$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":24.481398300557185},{"$f":"(D147*$F$159*$E$153)/SUM(D45:D49,D54:D56)","v":10.986003562223988},{"$f":"(E147*$F$159*$E$153)/(SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38))","v":62.026762128290692},{"$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":10.969022217507611},{"$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":90.634108355630048},{"$f":"+D130+($D$171*D80)+D$178+D181","v":71.191919007646703},null,{"$f":"+F130+($D$171*F80)+F$178+F181","v":40.392334113686076},{"$f":"+G130+($D$171*G80)+G$178+G181","v":40.010943882426581},{"$f":"+H130+($D$171*H80)+H$178+H181","v":72.023360383521762},{"$f":"+I130+($D$171*I80)+I$178+I181","v":36.267131105745626},{"$f":"+J130+($D$171*J80)+J$178+J181","v":36.310184953421171}]
[null,"PSE&G On pk",null,null,{"$f":"+E131+($D$171*E80)+E$178+E181","v":164.29355969748437}]
[null,"PSE&G Off pk",null,null,{"$f":"+E132+($D$171*E80)","v":34.428524358162917}]
[null,"Block 1 (0-600 kWh/m)",{"$f":"(C194*SUM(C50:C53)-C166*10*C164*SUM(C50:C53))/SUM(C50:C53)","v":87.579952355630056},{"$f":"(D194*SUM(D50:D53)-D166*10*D164*SUM(D50:D53))/SUM(D50:D53)","v":66.946096007646702}]
[null,"Block 2 (>600 kWh/m)",{"$f":"+C197+C166*10","v":96.231952355630057},{"$f":"+D197+D166*10","v":78.515096007646704}]
[]
[null,"Winter - all hrs",{"$f":"+C134+($D$171*C80)+C$178+C181","v":94.647190913221323},{"$f":"+D134+($D$171*D80)+D$178+D181","v":76.767605046622378},null,{"$f":"+F134+($D$171*F80)+F$178+F181","v":45.089301802413104},{"$f":"+G134+($D$171*G80)+G$178+G181","v":45.422301106662331},{"$f":"+H134+($D$171*H80)+H$178+H181","v":76.560009797064865},{"$f":"+I134+($D$171*I80)+I$178+I181","v":43.036854900610422},{"$f":"+J134+($D$171*J80)+J$178+J181","v":43.220465231884518}]
[null,"PSE&G On pk",null,null,{"$f":"+E135+($D$171*E80)+E$178+E181","v":166.30755892103264}]
[null,"PSE&G Off pk",null,null,{"$f":"+E136+($D$171*E80)","v":40.62588330964379}]
[]
[null,"Annual -all hrs",{"$f":"+C138+($D$171*C80)+C$178+C181","v":92.918174931002397},{"$f":"+D138+($D$171*D80)+D$178+D181","v":75.497328804647339},{"$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":95.919164545611451},{"$f":"+F138+($D$171*F80)+F$178+F181","v":43.888518168818045},{"$f":"+G138+($D$171*G80)+G$178+G181","v":44.019356641119728},{"$f":"+H138+($D$171*H80)+H$178+H181","v":75.573087850939899},{"$f":"+I138+($D$171*I80)+I$178+I181","v":41.150617569537843},{"$f":"+J138+($D$171*J80)+J$178+J181","v":41.37006874852711}]
[]
[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":42.497737251262784},{"$f":"+L130+($D$171*L$80)","v":41.989703551222647},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,{"$f":"+L131+($D$171*L$80)","v":49.369673707157247},null,null,null,"summer",{"$f":"+$F158*$E152/$H152/1000","v":5.1384461320297676},{"$f":"+$F158*$E152/$H152/1000","v":5.1384461320297676},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,{"$f":"+L132+($D$171*L$80)","v":34.317464969458044},null,null,null,"winter",{"$f":"+$F159*$E153/$H153/1000","v":5.1173869265706298},{"$f":"+$F159*$E153/$H153/1000","v":5.1173869265706298},"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.1244066617236754},{"$f":"($F$158*$E$152+$F$159*$E$153)/$H$154/1000","v":5.1244066617236754},"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"+K134+($D$171*K80)","v":46.096852284538251},{"$f":"+L134+($D$171*L$80)","v":45.886040717229989}]
[null,"PSE&G On pk",null,{"$f":"+L135+($D$171*L$80)","v":51.413156282986513},null,null,null,"Trans cost"]
[null,"PSE&G Off pk",null,{"$f":"+L136+($D$171*L$80)","v":40.480955872816665},null,null,null,"all months",{"$f":"+$D155/1000/12","v":7.3629791666666664},{"$f":"+$D155/1000/12","v":7.3629791666666664},"per kW of T obl /month"]
[]
[null,"Annual - all hrs per MWh only",{"$f":"+K138+($D$171*K80)","v":44.763447491084754},{"$f":"+L138+($D$171*L$80)","v":44.500245792850492}]
[]
[null,"Including T&G Obligation $"]
[null,"Summer - all hrs",{"$f":"(C211*W49+((I214*$H152)*K147*1000)+(I217*$H152*K149*1000))/W49","v":82.238308072957608},{"$f":"(D211*X49+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X49","v":71.001828359507314},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":106.28872723821185}]
[null,"PSE&G Off pk",null,{"$f":"+D213","v":34.317464969458044}]
[]
[null,"Winter - all hrs",{"$f":"(C215*W45+((I214*$H153)*K147*1000)+(I217*$H153*K149*1000))/W45","v":92.87270799359834},{"$f":"(D215*X45+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X45","v":77.914862728778076}]
[null,"PSE&G On pk",null,{"$f":"(D216*X46+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X46","v":116.1939157365244}]
[null,"PSE&G Off pk",null,{"$f":"+D217","v":40.480955872816665}]
[]
[null,"Annual - including T&G Obl $",{"$f":"(C219*K57+((I214*$H152+I214*$H153)*K147*1000)+(I217*$H154*K149*1000))/K57","v":88.93286175401343},{"$f":"(D219*L57+((J214*$H152+J214*$H153)*L147*1000)+(J217*$H154*L149*1000))/L57","v":75.456130967939899}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C204:J204,C57:J57)+SUMPRODUCT(C230:D230,K57:L57))/1000","v":2090819.6041504641}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C233/SUM(C57:L57)*1000","v":87.517411145912916},"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":81.428512681631247},"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.496},{"$f":"ROUND(+G194/$D$235,3)","v":0.49099999999999999},{"$f":"ROUND(+H194/$D$235,3)","v":0.88400000000000001},{"$f":"ROUND(+I194/$D$235,3)","v":0.44500000000000001},{"$f":"ROUND(+J194/$D$235,3)","v":0.44600000000000001}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E195/$D$235,3)","v":2.0179999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E196/$D$235,3)","v":0.42299999999999999},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I245*U49+J245*V49)/(U49+V49),3)","v":0.44600000000000001}]
[]
[null,"All usage Multiplier",{"$f":"ROUND(+C194/$D$235,3)","v":1.113},{"$f":"ROUND(+D194/$D$235,3)","v":0.874}]
[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.94299999999999995},null,{"$f":"ROUND(+F200/$D$235,3)","v":0.55400000000000005},{"$f":"ROUND(+G200/$D$235,3)","v":0.55800000000000005},{"$f":"ROUND(+H200/$D$235,3)","v":0.94},{"$f":"ROUND(+I200/$D$235,3)","v":0.52900000000000003},{"$f":"ROUND(+J200/$D$235,3)","v":0.53100000000000003}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E201/$D$235,3)","v":2.0419999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E202/$D$235,3)","v":0.499},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I255*U45+J255*V45)/(U45+V45),3)","v":0.53}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C204/$D$235,3)","v":1.141},{"$f":"ROUND(+D204/$D$235,3)","v":0.92700000000000005},1.1779999999999999,0.53900000000000003,0.54100000000000004,0.92800000000000005,0.505,0.50800000000000001]
[]
[]
[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.01},{"$f":"ROUND(+C211-C222,3)","v":-39.741},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D223/$D$235,3)","v":1.3049999999999999},{"$f":"ROUND(+D212-D223,3)","v":-56.918999999999997},null,"summer",{"$f":"ROUND(+I212,4)","v":5.1383999999999999},5.1383999999999999,"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D224/$D$235,3)","v":0.42099999999999999},{"$f":"ROUND(+D213-D224,3)","v":0},null,"winter",5.1173999999999999,5.1173999999999999,"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",5.1243999999999996,5.1243999999999996,"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"ROUND(+C226/$D$235,3)","v":1.141},{"$f":"ROUND(+C215-C226,3)","v":-46.776000000000003}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D227/$D$235,3)","v":1.427},{"$f":"ROUND(+D216-D227,3)","v":-64.781000000000006},null,"Trans cost"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D228/$D$235,3)","v":0.497},{"$f":"ROUND(+D217-D228,3)","v":0},null,"all months",{"$f":"ROUND(+I217,4)","v":7.3630000000000004},{"$f":"ROUND(+J217,4)","v":7.3630000000000004},"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.92700000000000005}]
[]
[]
[]
["Assumptions:"]
[null,"Gen Cost =",{"$f":"+F158","v":168.47364367310715},"/MW day ","summer"]
[null,null,{"$f":"+F159","v":168.47364367310715},"/MW day ","winter"]
[]
[null,"Trans cost =",{"$f":"+D155","v":88355.75},"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.4},"per MWh"]
[null,"Energy Costs ="," based on Forwards @ PJM West - corrected for congestion"]
[null,"Usage patterns ="," forecasted 2018 energy use by class, PJM and PSE&G on/off % from 2014, 2015 & 2016 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":475747.02562964422},{"$f":"(+D197*SUM(D50:D53)*D163+D198*SUM(D50:D53)*D164)/1000","v":2121.2027337703903},{"$f":"(E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))/1000","v":9398.7548919473356},{"$f":"+F194*SUM(F50:F53)/1000","v":13.248685589289032},{"$f":"+G194*SUM(G50:G53)/1000","v":0.28007660717698607},{"$f":"+H194*SUM(H50:H53)/1000","v":246.62973808581208},{"$f":"+I194*SUM(I50:I53)/1000","v":1606.380038066791},{"$f":"+J194*SUM(J50:J53)/1000","v":2880.5959029097617},{"$f":"(C211*SUM(K50:K53)/1000)+(I212*$H152*K147)+(I217*$H152*K149)","v":195730.0964722989},{"$f":"(D211*SUM(L50:L53)/1000)+(J212*$H152*L147)+(J217*$H152*L149)","v":112823.09666457638}]
[null,"Winter",{"$f":"+C200*SUM(C45:C49,C54:C56)/1000","v":656299.2300384352},{"$f":"+D200*SUM(D45:D49,D54:D56)/1000","v":7752.5716657111925},{"$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":11524.696659723904},{"$f":"+F200*SUM(F45:F49,F54:F56)/1000","v":43.060283221304509},{"$f":"+G200*SUM(G45:G49,G54:G56)/1000","v":0.90844602213324666},{"$f":"+H200*SUM(H45:H49,H54:H56)/1000","v":942.9447489730519},{"$f":"+I200*SUM(I45:I49,I54:I56)/1000","v":4935.2513357275002},{"$f":"+J200*SUM(J45:J49,J54:J56)/1000","v":9376.0316250788674},{"$f":"(C215*SUM(K45:K49,K54:K56)/1000)+(I213*$H153*K147)+(I217*$H153*K149)","v":375253.07896787545},{"$f":"(D215*SUM(L45:L49,L54:L56)/1000)+(J213*$H153*L147)+(J217*$H153*L149)","v":224124.51954619965}]
[null,"Total",{"$f":"+C303+C302","v":1132046.2556680795},{"$f":"+D303+D302","v":9873.7743994815828},20923.451551671242,56.308968810593541,1.1885226293102327,1189.574487058864,6541.631373794291,12256.627527988629,{"$f":"+K303+K302","v":570983.17544017429},{"$f":"+L303+L302","v":336947.61621077603}]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C302/C304","v":0.42025405167643182},{"$f":"+D302/D304","v":0.21483200323898052},0.44919715414719036,0.23528553033627078,0.23565105137251821,0.20732601511620016,0.24556260453652787,{"$f":"+J302/J304","v":0.23502353288714822},{"$f":"+K302/K304","v":0.3427948578719669},{"$f":"+L302/L304","v":0.33483868481799978}]
[null,"Winter",{"$f":"+C303/C304","v":0.57974594832356807},{"$f":"+D303/D304","v":0.78516799676101945},0.55080284585280959,0.76471446966372925,0.76434894862748182,0.79267398488379981,0.75443739546347222,{"$f":"+J303/J304","v":0.76497646711285183},{"$f":"+K303/K304","v":0.65720514212803316},{"$f":"+L303/L304","v":0.66516131518200028}]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C302:L302)","v":800567.31083349604}]
[null,"Winter",{"$f":"+SUM(C303:L303)","v":1290252.2933169683}]
[null,"Total",{"$f":"+C312+C311","v":2090819.6041504643}]
[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.38289640543081677},null,{"$f":"+C311/SUMPRODUCT(O49:X49,C85:L85)*1000","v":78.654674433398512},"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.61710359456918318},null,{"$f":"+C312/SUMPRODUCT(O45:X45,C85:L85)*1000","v":83.250162511794883},"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":81.428512681631247},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":475725.93612644245},{"$f":"+($C$322*D249*P49+D250*P53+D251*P54)/1000","v":2120.5002760346379},{"$f":"(($C$322*E246*Q50)+(C322*E247*Q51))/1000","v":9400.9084072578207},{"$f":"+$C$322*F245*R49/1000","v":13.247441871149224},{"$f":"+$C$322*G245*S49/1000","v":0.2798697980867666},{"$f":"+$C$322*H245*T49/1000","v":246.49086492532879},{"$f":"+$C$322*K247*U49/1000","v":1608.5940480445418},{"$f":"+$C$322*K247*V49/1000","v":2881.145815671046},{"$f":"+($C$322*C267+D267)*W49/1000+(I268*H152*K147)+(I273*H152*K149)","v":195739.52416842655},{"$f":"(($C$322*E268+F268)*X50+(C322*E269*X51))/1000+(J268*$H$152*L147)+(J273*$H$152*L149)","v":112775.09702298837}]
[null,"Winter",{"$f":"+$C$322*C255*O45/1000","v":656110.21040866291},{"$f":"+$C$322*D255*P45/1000","v":7754.5391466084757},{"$f":"(($C$322*E256*Q46)+(C322*E257*Q47))/1000","v":11523.56881188905},{"$f":"+$C$322*F255*R45/1000","v":43.08138320447064},{"$f":"+$C$322*G255*S45/1000","v":0.90874220152700469},{"$f":"+$C$322*H255*T45/1000","v":942.7328096502805},{"$f":"+$C$322*K257*U45/1000","v":4949.041786636014},{"$f":"+$C$322*K257*V45/1000","v":9362.2880312525267},{"$f":"+($C$322*C271+D271)*W45/1000+(I269*H153*K147)+(I273*H153*K149)","v":375403.46139859833},{"$f":"(($C$322*E272+F272)*X46+C322*E273*X47)/1000+(J269*$H$153*L147)+(J273*$H$153*L149)","v":224114.95053616678}]
[null,"Total",{"$f":"+C329+C328","v":1131836.1465351053},{"$f":"+D329+D328","v":9875.0394226431126},20924.477219146873,56.328825075619861,1.1886119996137712,1189.2236745756093,6557.6358346805555,12243.433846923574,571142.98556702491,336890.04755915515]
[]
[null,"Total Summer",{"$f":"SUM(C328:L328)","v":800511.72404145997}]
[null,"Total Winter",{"$f":"SUM(C329:L329)","v":1290204.7830548703}]
[null,"Grand Total",{"$f":"+C333+C332","v":2090716.5070963302}]
[]
[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":459387.18655567116},2607.6298316284729,8488.3617176791668,28.705710855859433,0.61262187802139034,299.68604733143127,3876.4086918859202,6943.018778438709,208171.74881595132,138996.78428825224]
[null,"Winter",{"$f":"+$C$322*$C$324*O45*C85/1000","v":606860.16136160167},8838.1681504085591,10602.362442751206,83.579127644346826,1.7503482229182581,1077.9006364092445,10036.05912315756,18985.589586938615,353723.68934745097,251810.20096630661]
[null,"Total",{"$f":"+C339+C338","v":1066247.3479172727},11445.797982037031,19090.724160430371,112.28483850020626,2.3629701009396484,1377.5866837406757,13912.467815043481,25928.608365377324,561895.43816340226,390806.98525455885]
[]
[null,"Total Summer",{"$f":"SUM(C338:L338)","v":828800.14305957232}]
[null,"Total Winter",{"$f":"SUM(C339:L339)","v":1262019.4610908916}]
[null,"Grand Total",{"$f":"+C343+C342","v":2090819.6041504638}]
[]
[null,"Difference ( in $1000) =",{"$f":"+C334-C344","v":-103.09705413365737}]
[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":10178254.714046055}]
[null,"Winter",{"$f":"SUMPRODUCT(O45:X45,C85:L85)","v":15498495.791334525}]
[null,"Total",{"$f":"+C353+C352","v":25676750.505380578}]

{"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],[5,14,16,14]]}
[null,"Calculation of June 2018 to May 2019 BGS-RSCP Rates"]
[null,"Final"]
[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","2016 Auction","2017 Auction","2018 Auction"]
["line #","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2016 auction","remaining portion of 36 month bid - 2017 auction","36 month bid - 2018 auction",null,"Notes:",null,null,null,null,null,"A","Incremental Capacity Cost","No adder required as data known prior to Feb. 2016 auction","No adder required as data known prior to Feb. 2017 auction","No adder required as data known prior to Feb. 2018 auction"]
[null,null,null,null,null,null,null,null,null,null,null,null,"B","Total Generation Obligation"]
[1,"Winning Bid - in $/MWh",{"$f":"Input!C136","v":96.38},{"$f":"Input!D136","v":90.78},{"$f":"+Input!E136","v":90.78},null,"Winning Bid ",null,null,null,null,null,"C","Days in Year"]
["1A","Incremental RPM Cost - in $/MWh",null,null,null,null,"The Incremental RPM Cost is not applicable for tranches from the 2016, 2017, or 2018 BGS-RSCP Auctions",null,null,null,null,null,"D = A * B * C","Total Incremental Cost"]
[null,"Total - in $/MWh",{"$f":"+C8+C9","v":96.38},{"$f":"+D8+D9","v":90.78},{"$f":"+E8+E9","v":90.78},null,"= line 1 + line 2",null,null,null,null,null,"E","Eligible Tranches"]
[null,null,null,null,null,null,null,null,null,null,null,null,"F","Total Inc. Adder Tranches "]
[null,"      (includes all payments, including impact of PJM marginal losses)",null,null,null,null,null,null,null,null,null,null,"G = E / F","Eligibility %"]
[2,"# of Tranches for Bid",{"$f":"Input!C137","v":28},{"$f":"Input!D137","v":28},{"$f":"Input!E137","v":29},null,"from then current Bid",null,null,null,null,null,"H = D * G","Allocated Period Cost"]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid",null,null,null,null,null,"I","Total Tranches"]
[null,"Payment Factors",null,null,null,null,null,null,null,null,null,null,"J","Total MWhs"]
[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"]
[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 "]
[]
[null,"Applicable Customer Usage @ transmission nodes - in MWh"]
[6,"                           Summer MWh",{"$f":"+bid_factors!C352","v":10178254.714046055},null,null,null,"from Table #17 of the current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"+bid_factors!C353","v":15498495.791334525}]
[]
[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":323146.41531192051},{"$f":"+D$8*D$13/D$14*D16*$C20/1000+D$9*D$13/D$14*$C20/1000","v":304370.52896883327},315240.9050034344,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":492057.18449796474},{"$f":"+D$8*D$13/D$14*D17*$C21/1000+D$9*D$13/D$14*$C21/1000","v":463467.01814406773},480019.41164921282,null,"= (1) * (2)/(3) * (5) * (7) + (1A) * (2)/(3) * (7)"]
[10,"                           Total",{"$f":"+C25+C24","v":815203.59980988526},{"$f":"+D25+D24","v":767837.547112901},{"$f":"+E25+E24","v":795260.31665264722},null,"Note: $ reflect total payment"]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C24:E24)/C20*1000,3)","v":92.625},null,null,null,"= sum(line 8) / (6) - rounded to 3 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":92.625},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":92.625},"   <<< 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":2378309.0155608761},null,null,null,"= (13) * [(6)+(7)] / 1000"]
[15,"Total Payment to Suppliers =",{"$f":"SUM(C26:E26)","v":2378301.4635754335},null,null,null,"= sum (line 10)"]
[16,"Difference =",{"$f":"+C36-C37","v":7.5519854426383972},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.496},{"$f":"+bid_factors!G245","v":0.49099999999999999},{"$f":"+bid_factors!H245","v":0.88400000000000001},{"$f":"+bid_factors!I245","v":0.44500000000000001},{"$f":"+bid_factors!J245","v":0.44600000000000001}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E246","v":2.0179999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E247","v":0.42299999999999999},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K247","v":0.44600000000000001}]
[]
[null,"All usage Multiplier",{"$f":"+bid_factors!C249","v":1.113},{"$f":"+bid_factors!D249","v":0.874}]
[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.94299999999999995},null,{"$f":"+bid_factors!F255","v":0.55400000000000005},{"$f":"+bid_factors!G255","v":0.55800000000000005},{"$f":"+bid_factors!H255","v":0.94},{"$f":"+bid_factors!I255","v":0.52900000000000003},{"$f":"+bid_factors!J255","v":0.53100000000000003}]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E256","v":2.0419999999999998},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E257","v":0.499},null,null,null,null,"for all streetlighting =",{"$f":"+bid_factors!K257","v":0.53}]
[]
[null,"Annual - all hrs",{"$f":"+bid_factors!C259","v":1.141},{"$f":"+bid_factors!D259","v":0.92700000000000005},{"$f":"+bid_factors!E259","v":1.1779999999999999},{"$f":"+bid_factors!F259","v":0.53900000000000003},{"$f":"+bid_factors!G259","v":0.54100000000000004},{"$f":"+bid_factors!H259","v":0.92800000000000005},{"$f":"+bid_factors!I259","v":0.505},{"$f":"+bid_factors!J259","v":0.50800000000000001}]
[]
[]
[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.01},{"$f":"+bid_factors!D267","v":-39.741},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E268","v":1.3049999999999999},{"$f":"+bid_factors!F268","v":-56.918999999999997},null,"summer",{"$f":"+bid_factors!I$270","v":5.1243999999999996},{"$f":"+bid_factors!J$270","v":5.1243999999999996},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E269","v":0.42099999999999999},{"$f":"+bid_factors!F269","v":0},null,"winter",{"$f":"+bid_factors!I$270","v":5.1243999999999996},{"$f":"+bid_factors!J$270","v":5.1243999999999996},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"+bid_factors!C271","v":1.141},{"$f":"+bid_factors!D271","v":-46.776000000000003},null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"+bid_factors!E272","v":1.427},{"$f":"+bid_factors!F272","v":-64.781000000000006},null,"all months",{"$f":"+bid_factors!I273","v":7.3630000000000004},{"$f":"+bid_factors!J273","v":7.3630000000000004},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+bid_factors!E273","v":0.497},{"$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.92700000000000005}]
[]
[]
["Table C","Preliminary Resulting BGS Rates (in cents per kWh) - equal to bid factors times weighted average bid price"]
[null,"   rounded to 4 decimal places"]
[]
[null,"NON-DEMAND RATES -----------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C46","v":"RS"},{"$f":"+D46","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(($C$32*F48)/10,4)","v":4.5941999999999998},{"$f":"ROUND(($C$32*G48)/10,4)","v":4.5479000000000003},{"$f":"ROUND(($C$32*H48)/10,4)","v":8.1881000000000004},{"$f":"ROUND(($C$32*K50)/10,4)","v":4.1311},{"$f":"+I89","v":4.1311}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E49)/10,4)","v":18.691700000000001}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E50/10),4)","v":3.9180000000000001}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C53)/10,4)","v":10.0038},{"$f":"ROUND((+$C$32*D52+D53)/10,4)","v":7.6707999999999998}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND((+$C$32*C52+C54)/10,4)","v":10.869},{"$f":"ROUND((+$C$32*D52+D54)/10,4)","v":8.8277000000000001}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C58)/10,4)","v":10.763},{"$f":"ROUND(($C$32*D58)/10,4)","v":8.7345000000000006},null,{"$f":"ROUND(($C$32*F58)/10,4)","v":5.1314000000000002},{"$f":"ROUND(($C$32*G58)/10,4)","v":5.1684999999999999},{"$f":"ROUND(($C$32*H58)/10,4)","v":8.7067999999999994},{"$f":"ROUND(($C$32*K60)/10,4)","v":4.9090999999999996},{"$f":"+I96","v":4.9090999999999996}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E59)/10,4)","v":18.914000000000001}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E60)/10,4)","v":4.6219999999999999}]
[]
[]
[]
[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.3810000000000002},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E71+F71)/10,4)","v":6.3956999999999997},null,null,"summer",{"$f":"+I71","v":5.1243999999999996},{"$f":"+J71","v":5.1243999999999996},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E72+F72)/10,4)","v":3.8995000000000002},null,null,"winter",{"$f":"+I72","v":5.1243999999999996},{"$f":"+J72","v":5.1243999999999996},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$32*C74+D74)/10,4)","v":5.8909000000000002},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$32*E75+F75)/10,4)","v":6.7394999999999996},null,null,"all months",{"$f":"+I75","v":7.3630000000000004},{"$f":"+J75","v":7.3630000000000004},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$32*E76+F76)/10,4)","v":4.6035000000000004}]
[]
[]
[]
["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":541140.49856706767},{"$f":"+D93/100*bid_factors!P53+auction_results_and_rates!D94/100*bid_factors!P54","v":2412.0640804516024},{"$f":"+E90/100*bid_factors!Q50+E91/100*bid_factors!Q51","v":10693.510489204746},{"$f":"+F89/100*bid_factors!R49","v":15.068975999999999},{"$f":"+G89/100*bid_factors!S49","v":0.31835300000000005},{"$f":"+H89/100*bid_factors!T49","v":280.385273287313},{"$f":"+I89/100*bid_factors!U49","v":1829.788123},{"$f":"+J89/100*bid_factors!V49","v":3277.3255629999999}]
[null,"Winter",{"$f":"+C96/100*bid_factors!O45","v":746324.16923817433},{"$f":"+D96/100*bid_factors!P45","v":8820.7567727337519},{"$f":"+E97/100*bid_factors!Q46+auction_results_and_rates!E98/100*bid_factors!Q47","v":13108.064421917481},{"$f":"+F96/100*bid_factors!R45","v":49.004869999999997},{"$f":"+G96/100*bid_factors!S45","v":1.0337000000000001},{"$f":"+H96/100*bid_factors!T45","v":1072.365502841579},{"$f":"+I96/100*bid_factors!U45","v":5629.5104249999995},{"$f":"+J96/100*bid_factors!V45","v":10649.556084999998}]
[null,"Total",{"$f":"+C122+C121","v":1287464.6678052419},{"$f":"+D122+D121","v":11232.820853185354},23801.574911122225,64.073846000000003,1.3520530000000002,1352.7507761288921,7459.2985479999998,13926.881647999999]
[]
[]
[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":127994.20889073527},{"$f":"I108*bid_factors!K147*4+auction_results_and_rates!I112*bid_factors!K149*4","v":94528.302480000013},null,{"$f":"+E108/100*bid_factors!X50+auction_results_and_rates!E109/100*bid_factors!X51","v":82140.03723284704},{"$f":"auction_results_and_rates!J108*bid_factors!L147*4+auction_results_and_rates!J112*bid_factors!L149*4","v":46077.642560000008}]
[null,"Winter",{"$f":"+C111/100*bid_factors!W45","v":238095.58055856766},{"$f":"auction_results_and_rates!I109*bid_factors!K147*8+auction_results_and_rates!I112*bid_factors!K149*8","v":189056.60496000003},null,{"$f":"+E112/100*bid_factors!X46+auction_results_and_rates!E113/100*bid_factors!X47","v":162840.69276913456},{"$f":"auction_results_and_rates!J109*bid_factors!L147*8+auction_results_and_rates!J112*bid_factors!L149*8","v":92155.285120000015}]
[null,"Total",{"$f":"+C130+C129","v":366089.78944930295},{"$f":"+D130+D129","v":283584.90744000004},null,{"$f":"+F130+F129","v":244980.7300019816},{"$f":"+G130+G129","v":138232.92768000002}]
[]
[]
[null,null,"Energy $","Obligation $","Total $"]
[null,"Total Summer",{"$f":"SUM(C121:J121)+C129+F129","v":769783.20554859366},{"$f":"+D129+G129","v":140605.94504000002},{"$f":"+C135+D135","v":910389.15058859368}]
[null,"Total Winter",{"$f":"SUM(C122:J122)+C130+F130","v":1186590.7343433693},{"$f":"+D130+G130","v":281211.89008000004},{"$f":"+C136+D136","v":1467802.6244233693}]
[null,"Grand Total",{"$f":"+C136+C135","v":1956373.9398919628},{"$f":"+D131+G131","v":421817.83512000006},{"$f":"+C137+D137","v":2378191.7750119627}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":942757.84928418824}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1435543.6142912451}]
[null,"Total",{"$f":"+C142+C141","v":2378301.4635754335},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":32368.698695594561},null,{"$f":"ROUND(1+(C146/C135),5)","v":1.0420499999999999}]
[null,"Winter",{"$f":"+C142-E136","v":-32259.010132124182},null,{"$f":"ROUND(1+(C147/C136),5)","v":0.97280999999999995}]
[null,"Total",{"$f":"+C143-E137","v":109.6885634707287}]
[]
[null,null,"Note: These differences are due to rounding and seasonal differences in Bidder Payments (which are based on prior "]
[null,null,"          wining bids and Seasonal Payment Factors) and current Rates (based on current seasonal market differentials)"]
[]
["Table E","Final Resulting BGS Rates from Auctions (in cents per kWh) - with preliminary kWh rates adjusted by the kWh Rate Adjustment Factor"]
[null,"   rounded to 4 decimal places"]
[]
[null,"NON-DEMAND RATES -----------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods & adjustment to energy price"]
[]
[null,null,{"$f":"+C119","v":"RS"},{"$f":"+D119","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(+F89*$E$146,4)","v":4.7873999999999999},{"$f":"ROUND(+G89*$E$146,4)","v":4.7390999999999996},{"$f":"ROUND(+H89*$E$146,4)","v":8.5324000000000009},{"$f":"ROUND(+I89*$E$146,4)","v":4.3048000000000002},{"$f":"ROUND(+J89*$E$146,4)","v":4.3048000000000002}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E90*$E$146,4)","v":19.477699999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E91*$E$146,4)","v":4.0827999999999998}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C93*$E$146,4)","v":10.4245},{"$f":"ROUND(+D93*$E$146,4)","v":7.9934000000000003}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C94*$E$146,4)","v":11.326000000000001},{"$f":"ROUND(+D94*$E$146,4)","v":9.1989000000000001}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C96*$E$147,4)","v":10.4704},{"$f":"ROUND(+D96*$E$147,4)","v":8.4969999999999999},null,{"$f":"ROUND(+F96*$E$147,4)","v":4.9919000000000002},{"$f":"ROUND(+G96*$E$147,4)","v":5.0279999999999996},{"$f":"ROUND(+H96*$E$147,4)","v":8.4701000000000004},{"$f":"ROUND(+I96*$E$147,4)","v":4.7755999999999998},{"$f":"ROUND(+J96*$E$147,4)","v":4.7755999999999998}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E97*$E$147,4)","v":18.399699999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E98*$E$147,4)","v":4.4962999999999997}]
[]
[]
[]
[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":5.6073000000000004},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E108*$E$146,4)","v":6.6646000000000001},null,null,"summer",{"$f":"+I108","v":5.1243999999999996},{"$f":"+J108","v":5.1243999999999996}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E109*$E$146,4)","v":4.0635000000000003},null,null,"winter",{"$f":"+I109","v":5.1243999999999996},{"$f":"+J109","v":5.1243999999999996}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C111*$E$147,4)","v":5.7306999999999997},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E112*$E$147,4)","v":6.5563000000000002},null,null,"all months",{"$f":"+I112","v":7.3630000000000004},{"$f":"+J112","v":7.3630000000000004}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E113*$E$147,4)","v":4.4782999999999999}]
[]
[]
[]
["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":563896.05408981314},{"$f":"+D165/100*bid_factors!P53+auction_results_and_rates!D166/100*bid_factors!P54","v":2513.4989354436193},{"$f":"+E162/100*bid_factors!Q50+E163/100*bid_factors!Q51","v":11143.20335364012},{"$f":"+F161/100*bid_factors!R49","v":15.702672},{"$f":"+G161/100*bid_factors!S49","v":0.33173699999999995},{"$f":"+H161/100*bid_factors!T49","v":292.17514512483598},{"$f":"+I161/100*bid_factors!U49","v":1906.7250640000002},{"$f":"+J161/100*bid_factors!V49","v":3415.1269840000004},{"$f":"+C179/100*bid_factors!W49+I180*bid_factors!K147*4+auction_results_and_rates!I184*bid_factors!K149*4","v":227905.35646866754},{"$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":131671.5537988382}]
[null,"Winter",{"$f":"+C168/100*bid_factors!O45","v":726034.8027121973},{"$f":"+D168/100*bid_factors!P45","v":8580.9113627475745},{"$f":"+E169/100*bid_factors!Q46+auction_results_and_rates!E170/100*bid_factors!Q47","v":12751.622174341037},{"$f":"+F168/100*bid_factors!R45","v":47.672645000000003},{"$f":"+G168/100*bid_factors!S45","v":1.0056},{"$f":"+H168/100*bid_factors!T45","v":1043.2125517547731},{"$f":"+I168/100*bid_factors!U45","v":5476.4192999999996},{"$f":"+J168/100*bid_factors!V45","v":10359.94786},{"$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":420677.29848849028},{"$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":250568.55957898431}]
[null,"Total",{"$f":"+C194+C193","v":1289930.8568020104},11094.410298191193,23894.825527981156,63.375317000000003,1.337337,1335.3876968796092,7383.1443639999998,13775.074844000001,648582.65495715779,382240.1133778225]
[]
[null,"Total Summer",{"$f":"SUM(C193:L193)","v":942759.72824852739}]
[null,"Total Winter",{"$f":"SUM(C194:L194)","v":1435541.4522735153}]
[null,"Grand Total",{"$f":"+C198+C197","v":2378301.1805220428}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C24+D24+E24","v":942757.84928418824}]
[null,"Winter",{"$f":"+C25+D25+E25","v":1435543.6142912451}]
[null,"Total",{"$f":"+C204+C203","v":2378301.4635754335}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C197-C203","v":1.8789643391501158},null,{"$f":"+C208/C197","v":1.9930468844282125E-6}]
[null,"Winter",{"$f":"+C198-C204","v":-2.1620177298318595},null,{"$f":"+C209/C198","v":-1.506064298183657E-6}]
[null,"Total",{"$f":"+C199-C205","v":-0.28305339068174362},null,{"$f":"+C210/C199","v":-1.1901494772819846E-7}]
[]
[]
["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":5.6073000000000004},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"E180","v":6.6646000000000001},null,null,"summer",{"$f":"I180","v":5.1243999999999996},{"$f":"J180","v":5.1243999999999996}]
[null,"PSE&G Off pk",null,null,{"$f":"E181","v":4.0635000000000003},null,null,"winter",{"$f":"I181","v":5.1243999999999996},{"$f":"J181","v":5.1243999999999996}]
[]
[null,"Winter - all hrs",{"$f":"C183","v":5.7306999999999997},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"E184","v":6.5563000000000002},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.4782999999999999}]
[]
[]
[]
[]
["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":942757.84928418824},{"$f":"bid_factors!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C266:D266)","v":{"$error":"#REF!"}}]
[null,"Winter",{"$f":"+SUM(C25:E25)","v":1435543.6142912451},{"$f":"bid_factors!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C267:D267)","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"+C267+C266","v":2378301.4635754335},{"$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!"}}]