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

{"sheet":"Input","index":0,"n_rows":141,"n_cols":12,"rows_kept":141,"cut":false,"hidden":false,"merged":[[4,1,4,11],[77,5,77,6],[111,4,111,5],[112,2,112,3],[113,2,113,3]]}
[]
[null,null,null,2022]
[" "]
[]
[]
[]
[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 2022/2023 BGS Filing"}]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,{"$f":"\"Based on average of year \"&(Input!D2-4)&\", \"&(Input!D2-3)&\" & \"&(Input!D2-2)&\" Load Profile Information\"","v":"Based on average of year 2018, 2019 & 2020 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.49170000000000003,0.48699999999999999,0.48930000000000001,0.49170000000000003,0.49170000000000003,0.49230000000000002,0.314,0.314,0.55500000000000005,0.5373]
[null,"February",0.48230000000000001,0.46870000000000001,0.47870000000000001,0.48230000000000001,0.48230000000000001,0.47670000000000001,0.29099999999999998,0.29099999999999998,0.54769999999999996,0.53300000000000003]
[null,"March",0.48770000000000002,0.47799999999999998,0.48070000000000002,0.48770000000000002,0.48770000000000002,0.49099999999999999,0.24829999999999999,0.24829999999999999,0.54630000000000001,0.53129999999999999]
[null,"April",0.504,0.50729999999999997,0.50129999999999997,0.504,0.504,0.53029999999999999,0.23,0.23,0.56630000000000003,0.54900000000000004]
[null,"May",0.48770000000000002,0.49769999999999998,0.49930000000000002,0.48770000000000002,0.48770000000000002,0.56769999999999998,0.20830000000000001,0.20830000000000001,0.56069999999999998,0.54169999999999996]
[null,"June",0.50700000000000001,0.51500000000000001,0.52569999999999995,0.50700000000000001,0.50700000000000001,0.60670000000000002,0.1973,0.1973,0.57269999999999999,0.55330000000000001]
[null,"July",0.50970000000000004,0.51900000000000002,0.52869999999999995,0.50970000000000004,0.50970000000000004,0.60870000000000002,0.19800000000000001,0.19800000000000001,0.57899999999999996,0.55269999999999997]
[null,"August",0.52300000000000002,0.52929999999999999,0.53569999999999995,0.52300000000000002,0.52300000000000002,0.62170000000000003,0.2157,0.2157,0.58330000000000004,0.55269999999999997]
[null,"September",0.48370000000000002,0.48970000000000002,0.49299999999999999,0.48370000000000002,0.48370000000000002,0.58599999999999997,0.22600000000000001,0.22600000000000001,0.55469999999999997,0.53200000000000003]
[null,"October",0.52229999999999999,0.52270000000000005,0.52270000000000005,0.52229999999999999,0.52229999999999999,0.59130000000000005,0.27729999999999999,0.27729999999999999,0.59,0.57130000000000003]
[null,"November",0.47299999999999998,0.46429999999999999,0.46629999999999999,0.47299999999999998,0.47299999999999998,0.49230000000000002,0.30299999999999999,0.30299999999999999,0.5363,0.51929999999999998]
[null,"December",0.4773,0.46600000000000003,0.47599999999999998,0.4773,0.4773,0.48070000000000002,0.30830000000000002,0.30830000000000002,0.52800000000000002,0.51100000000000001]
[]
[null,null,null,null,{"$f":"E9","v":"Based on average of year 2018, 2019 & 2020 Load Profile Information"}]
["Table #2","% Usage During PSE&G On-Peak Billing Period",null,null,{"$f":"\"On-Peak periods as defined in specified rate schedule (average of %s for \"&(Input!D2-4)&\", \"&(Input!D2-3)&\" & \"&(Input!D2-2)&\")\"","v":"On-Peak periods as defined in specified rate schedule (average of %s for 2018, 2019 & 2020)"}]
[null,null,"Profile Meter Data","Profile Meter Data"]
[null,"(data rounded to nearest .01%)","RLM","LPL-S"]
[]
[null,"January",0.42520000000000002,0.4703]
[null,"February",0.41510000000000002,0.47770000000000001]
[null,"March",0.41599999999999998,0.4753]
[null,"April",0.42380000000000001,0.4748]
[null,"May",0.4405,0.48499999999999999]
[null,"June",0.4597,0.49509999999999998]
[null,"July",0.48149999999999998,0.49480000000000002]
[null,"August",0.48089999999999999,0.49249999999999999]
[null,"September",0.48949999999999999,0.49690000000000001]
[null,"October",0.45569999999999999,0.49809999999999999]
[null,"November",0.42949999999999999,0.4899]
[null,"December",0.42749999999999999,0.47549999999999998]
[]
[]
["Table #3","Class Usage @ customer"]
[null,{"$f":"\"Calendar month sales forecasted for \"&(Input!D2)&\", less % for LPL-Sec > 500 kW Peak Load Share\"","v":"Calendar month sales forecasted for 2022, 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",1216460.8042101599,15356.34876296726,16023.811132804776,58,1,1312.7073641018796,15557,32676,536039.01539859804,625960.39082683367]
[null,"February",985328.47632836632,11760.939576136181,13924.875367453742,57,1,1175.880633162644,12802,29367,488422.31162583811,567126.46844730119]
[null,"March",925316.13675727637,9237.8111752826735,13405.29046568308,64,1,913.836712091138,12379,27322,503121.66935158957,586310.17763160076]
[null,"April",785557.03022227436,4853.0706364444468,11144.39400122155,53,1,613.64715693960261,10748,26105,450984.04808501509,522039.98258873454]
[null,"May",823748.98558658676,3364.1712011380082,11489.847746723126,61,1,301.01880806631857,9616,21208,459594.02408677386,620087.16836744046]
[null,"June",1290025.0967616264,4510.6042525698986,18697.566951646237,46,1,398.04139909595847,8470,19103,497554.25892154238,587083.78216619731]
[null,"July",1730592.1285201842,6291.2343111768787,22415.173519090018,36,1,430.3822627725051,9055,18825,603493.17868962837,639717.64644434012]
[null,"August",1592628.9940705989,5967.3059936659101,21296.427649511745,40,0,501.69801344386434,10329,19965,610019.52009617479,662758.15647700417]
[null,"September",908539.55359554919,4079.3502876908387,13967.003873002714,42,1,362.38352376027888,10991,21876,519714.23566303588,604949.62832193228]
[null,"October",658896.53387536667,5618.009795867938,10464.720778364792,20,1,431.21151568728834,13089,26616,476897.28746945539,606421.79143899295]
[null,"November",721135.95616163395,8358.7165545676671,9526.6593881410026,43,1,522.42933631344545,13505,27571,432735.45558365702,533458.18913744751]
[null,"December",1003987.0603783099,12198.047667235318,12509.357581008262,55,1,1031.5906259903591,15040,29607,500440.40312829305,608622.67179217865]
[null,null,{"$f":"SUM(C50:C61)","v":12642216.756467931},{"$f":"SUM(D50:D61)","v":91595.610214743036},174865.12845465107,575,11,7994.8273514252833,141581,300241,6079015.408099602,7164536.0536400042]
[]
[null,"LPL-S > 500 kW PLS","% of","% of"]
[null,null,"kWh","Gen Obl"]
[null,null,0.35088815042973703,0.34172074452167817]
[]
[]
[]
["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",67.2,null,"Summer",0.66836581709145426]
[null,"February",63,null,"Winter",0.77165615665449716]
[null,"March",45.2]
[null,"April",40.799999999999997]
[null,"May",40.9]
[null,"June",44.35,null,null,"Basis"]
[null,"July",50.8,null,null,"On-Peak","Off-Peak"]
[null,"August",47.55,null,"Summer",0.8879039176436947,0.89475926714955267]
[null,"September",45.45,null,"Winter",0.90395846852693051,0.94218684541265174]
[null,"October",45.05]
[null,"November",46.6]
[null,"December",48.9]
[]
[]
[]
["Table #6","Loss Type","Percentage","Source"]
[null,"Delivery Losses",5.8326999999999997E-2,"Tariff (Result of 2018 Rate Case Loss Study)"]
[null,"EHV Losses",4.5599999999999998E-3,"PJM - No update for 2021"]
[null,"Marginal Loss Deration Factor",1.1688694814362801E-2,"NERA"]
[]
[]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments"]
[null,"Obligations - Peak Load shares eff 6/1/22, scaling factors eff 1/1/22, Transmission Loads eff 1/1/22; 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",4302.4693517250362,17.819458494380996,57.390887807454881,0,0,2.7634796204940675,0,0,1567.7386098935538,1254.8923403065266]
[null,"Tranmsission Obligation",4775.0714225860565,20.017302020508449,64.53252810955162,0,0,3.0224328826980353,0,0,1685.270959707269,1318.8404831557339]
[]
[null,"Final Zonal RPM Scaling Factor",1.0740768592912917]
[null,{"$f":"\"PJM January 1, \"&(Input!D2)&\" (through May 31, \"&(Input!D2)&\") Forecast Pool Requirement\"","v":"PJM January 1, 2022 (through May 31, 2022) Forecast Pool Requirement"},1.0871]
[]
[null,"NITS Rate",null,"Tranches","NITS Rate"]
[null,null,2019,28,104709.15]
[null,null,2020,28,138497.08431889772]
[null,null,2021,29,144787.97744165195]
[]
[null,null,null,null,"Base Capacity"]
[null,"Generation Capacity cost","summer =",null,104.84,"$/MW/day"]
[null,null,"winter =",null,104.84,"$/MW/day"]
[]
[]
[]
[null,null,"RS","RHS"]
[null,"Required summer inversion =",0.86519999999999975,1.1569000000000003,"¢/kWh","(same as 2003/2004 BGS blocking inversion)(generally not updated)"]
[]
[]
["Table #11","Ancillary Services & Renewable Power Cost"]
[null,"Ancillary Services ",null,2,"per MWh @  bulk system"]
[null,"Renewable Power Cost",null,16.09,"per MWh @  bulk system"]
[]
[]
[]
[]
["Bill Impacts","BGS - CIEP BRA Clearing Price ($ per MW/Day)"]
[null,"Annual Obligation Clearing Price",null,351.06,"per MWh"]
[]
[]
[]
[]
["auction results and rates","Specific BGS-FP Auction >>","remaining portion of 36 month bid - 2020 auction","remaining portion of 36 month bid - 2021 auction","36 month bid - 2022 auction"]
[null,"Winning Bid - in $/MWh",102.16,64.8,57.48]
[null,"# of Tranches for Bid",28,29,28]
[null,"Use Estimated amount in cell e136",null,null,"Yes"]
[null,"Payment Factors"]
[null,"                           Summer",1,1,1]
[null,"                           Winter",1,1,1]

{"sheet":"Att 2","index":1,"n_rows":354,"n_cols":39,"rows_kept":354,"cut":false,"hidden":false,"merged":[[144,17,144,21]]}
[" "]
[null,{"$f":"Input!B7","v":"Development of BGS-RSCP Cost and Bid Factors for 2022/2023 BGS Filing"}]
[null,"Adjusted to Billing Time Periods"]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2018, 2019 & 2020 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.49170000000000003},{"$f":"Input!D14","v":0.48699999999999999},{"$f":"Input!E14","v":0.48930000000000001},{"$f":"Input!F14","v":0.49170000000000003},{"$f":"Input!G14","v":0.49170000000000003},{"$f":"Input!H14","v":0.49230000000000002},{"$f":"Input!I14","v":0.314},{"$f":"Input!J14","v":0.314},{"$f":"Input!K14","v":0.55500000000000005},{"$f":"Input!L14","v":0.5373},null,null,{"$f":"1-C9","v":0.50829999999999997},0.51300000000000001,0.51069999999999993,0.50829999999999997,0.50829999999999997,0.50770000000000004,0.68599999999999994,0.68599999999999994,0.44499999999999995,0.4627]
[null,"February",{"$f":"Input!C15","v":0.48230000000000001},{"$f":"Input!D15","v":0.46870000000000001},{"$f":"Input!E15","v":0.47870000000000001},{"$f":"Input!F15","v":0.48230000000000001},{"$f":"Input!G15","v":0.48230000000000001},{"$f":"Input!H15","v":0.47670000000000001},{"$f":"Input!I15","v":0.29099999999999998},{"$f":"Input!J15","v":0.29099999999999998},{"$f":"Input!K15","v":0.54769999999999996},{"$f":"Input!L15","v":0.53300000000000003},null,null,0.51770000000000005,0.53129999999999999,0.52129999999999999,0.51770000000000005,0.51770000000000005,0.52329999999999999,0.70900000000000007,0.70900000000000007,0.45230000000000004,0.46699999999999997]
[null,"March",{"$f":"Input!C16","v":0.48770000000000002},{"$f":"Input!D16","v":0.47799999999999998},{"$f":"Input!E16","v":0.48070000000000002},{"$f":"Input!F16","v":0.48770000000000002},{"$f":"Input!G16","v":0.48770000000000002},{"$f":"Input!H16","v":0.49099999999999999},{"$f":"Input!I16","v":0.24829999999999999},{"$f":"Input!J16","v":0.24829999999999999},{"$f":"Input!K16","v":0.54630000000000001},{"$f":"Input!L16","v":0.53129999999999999},null,null,0.51229999999999998,0.52200000000000002,0.51929999999999998,0.51229999999999998,0.51229999999999998,0.50900000000000001,0.75170000000000003,0.75170000000000003,0.45369999999999999,0.46870000000000001]
[null,"April",{"$f":"Input!C17","v":0.504},{"$f":"Input!D17","v":0.50729999999999997},{"$f":"Input!E17","v":0.50129999999999997},{"$f":"Input!F17","v":0.504},{"$f":"Input!G17","v":0.504},{"$f":"Input!H17","v":0.53029999999999999},{"$f":"Input!I17","v":0.23},{"$f":"Input!J17","v":0.23},{"$f":"Input!K17","v":0.56630000000000003},{"$f":"Input!L17","v":0.54900000000000004},null,null,0.496,0.49270000000000003,0.49870000000000003,0.496,0.496,0.46970000000000001,0.77,0.77,0.43369999999999997,0.45099999999999996]
[null,"May",{"$f":"Input!C18","v":0.48770000000000002},{"$f":"Input!D18","v":0.49769999999999998},{"$f":"Input!E18","v":0.49930000000000002},{"$f":"Input!F18","v":0.48770000000000002},{"$f":"Input!G18","v":0.48770000000000002},{"$f":"Input!H18","v":0.56769999999999998},{"$f":"Input!I18","v":0.20830000000000001},{"$f":"Input!J18","v":0.20830000000000001},{"$f":"Input!K18","v":0.56069999999999998},{"$f":"Input!L18","v":0.54169999999999996},null,null,0.51229999999999998,0.50229999999999997,0.50069999999999992,0.51229999999999998,0.51229999999999998,0.43230000000000002,0.79169999999999996,0.79169999999999996,0.43930000000000002,0.45830000000000004]
[null,"June",{"$f":"Input!C19","v":0.50700000000000001},{"$f":"Input!D19","v":0.51500000000000001},{"$f":"Input!E19","v":0.52569999999999995},{"$f":"Input!F19","v":0.50700000000000001},{"$f":"Input!G19","v":0.50700000000000001},{"$f":"Input!H19","v":0.60670000000000002},{"$f":"Input!I19","v":0.1973},{"$f":"Input!J19","v":0.1973},{"$f":"Input!K19","v":0.57269999999999999},{"$f":"Input!L19","v":0.55330000000000001},null,null,0.49299999999999999,0.48499999999999999,0.47430000000000005,0.49299999999999999,0.49299999999999999,0.39329999999999998,0.80269999999999997,0.80269999999999997,0.42730000000000001,0.44669999999999999]
[null,"July",{"$f":"Input!C20","v":0.50970000000000004},{"$f":"Input!D20","v":0.51900000000000002},{"$f":"Input!E20","v":0.52869999999999995},{"$f":"Input!F20","v":0.50970000000000004},{"$f":"Input!G20","v":0.50970000000000004},{"$f":"Input!H20","v":0.60870000000000002},{"$f":"Input!I20","v":0.19800000000000001},{"$f":"Input!J20","v":0.19800000000000001},{"$f":"Input!K20","v":0.57899999999999996},{"$f":"Input!L20","v":0.55269999999999997},null,null,0.49029999999999996,0.48099999999999998,0.47130000000000005,0.49029999999999996,0.49029999999999996,0.39129999999999998,0.80200000000000005,0.80200000000000005,0.42100000000000004,0.44730000000000003]
[null,"August",{"$f":"Input!C21","v":0.52300000000000002},{"$f":"Input!D21","v":0.52929999999999999},{"$f":"Input!E21","v":0.53569999999999995},{"$f":"Input!F21","v":0.52300000000000002},{"$f":"Input!G21","v":0.52300000000000002},{"$f":"Input!H21","v":0.62170000000000003},{"$f":"Input!I21","v":0.2157},{"$f":"Input!J21","v":0.2157},{"$f":"Input!K21","v":0.58330000000000004},{"$f":"Input!L21","v":0.55269999999999997},null,null,0.47699999999999998,0.47070000000000001,0.46430000000000005,0.47699999999999998,0.47699999999999998,0.37829999999999997,0.7843,0.7843,0.41669999999999996,0.44730000000000003]
[null,"September",{"$f":"Input!C22","v":0.48370000000000002},{"$f":"Input!D22","v":0.48970000000000002},{"$f":"Input!E22","v":0.49299999999999999},{"$f":"Input!F22","v":0.48370000000000002},{"$f":"Input!G22","v":0.48370000000000002},{"$f":"Input!H22","v":0.58599999999999997},{"$f":"Input!I22","v":0.22600000000000001},{"$f":"Input!J22","v":0.22600000000000001},{"$f":"Input!K22","v":0.55469999999999997},{"$f":"Input!L22","v":0.53200000000000003},null,null,0.51629999999999998,0.51029999999999998,0.50700000000000001,0.51629999999999998,0.51629999999999998,0.41400000000000003,0.77400000000000002,0.77400000000000002,0.44530000000000003,0.46799999999999997]
[null,"October",{"$f":"Input!C23","v":0.52229999999999999},{"$f":"Input!D23","v":0.52270000000000005},{"$f":"Input!E23","v":0.52270000000000005},{"$f":"Input!F23","v":0.52229999999999999},{"$f":"Input!G23","v":0.52229999999999999},{"$f":"Input!H23","v":0.59130000000000005},{"$f":"Input!I23","v":0.27729999999999999},{"$f":"Input!J23","v":0.27729999999999999},{"$f":"Input!K23","v":0.59},{"$f":"Input!L23","v":0.57130000000000003},null,null,0.47770000000000001,0.47729999999999995,0.47729999999999995,0.47770000000000001,0.47770000000000001,0.40869999999999995,0.72270000000000001,0.72270000000000001,0.41000000000000003,0.42869999999999997]
[null,"November",{"$f":"Input!C24","v":0.47299999999999998},{"$f":"Input!D24","v":0.46429999999999999},{"$f":"Input!E24","v":0.46629999999999999},{"$f":"Input!F24","v":0.47299999999999998},{"$f":"Input!G24","v":0.47299999999999998},{"$f":"Input!H24","v":0.49230000000000002},{"$f":"Input!I24","v":0.30299999999999999},{"$f":"Input!J24","v":0.30299999999999999},{"$f":"Input!K24","v":0.5363},{"$f":"Input!L24","v":0.51929999999999998},null,null,0.52700000000000002,0.53570000000000007,0.53370000000000006,0.52700000000000002,0.52700000000000002,0.50770000000000004,0.69700000000000006,0.69700000000000006,0.4637,0.48070000000000002]
[null,"December",{"$f":"Input!C25","v":0.4773},{"$f":"Input!D25","v":0.46600000000000003},{"$f":"Input!E25","v":0.47599999999999998},{"$f":"Input!F25","v":0.4773},{"$f":"Input!G25","v":0.4773},{"$f":"Input!H25","v":0.48070000000000002},{"$f":"Input!I25","v":0.30830000000000002},{"$f":"Input!J25","v":0.30830000000000002},{"$f":"Input!K25","v":0.52800000000000002},{"$f":"Input!L25","v":0.51100000000000001},null,null,0.52269999999999994,0.53400000000000003,0.52400000000000002,0.52269999999999994,0.52269999999999994,0.51929999999999998,0.69169999999999998,0.69169999999999998,0.47199999999999998,0.48899999999999999]
[]
[null,null,null,null,{"$f":"+Input!E9","v":"Based on average of year 2018, 2019 & 2020 Load Profile Information"}]
["Table #2","% Usage During PSE&G On-Peak Billing Period",null,null,{"$f":"Input!E28","v":"On-Peak periods as defined in specified rate schedule (average of %s for 2018, 2019 & 2020)"}]
[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.42520000000000002},0,0,0,0,0,0,{"$f":"Input!D32","v":0.4703},null,null,null,null,{"$f":"1-E27","v":0.57479999999999998},null,null,null,null,null,null,{"$f":"1-L27","v":0.52970000000000006}]
[null,"February",0,0,{"$f":"Input!C33","v":0.41510000000000002},0,0,0,0,0,0,{"$f":"Input!D33","v":0.47770000000000001},null,null,null,null,0.58489999999999998,null,null,null,null,null,null,0.52229999999999999]
[null,"March",0,0,{"$f":"Input!C34","v":0.41599999999999998},0,0,0,0,0,0,{"$f":"Input!D34","v":0.4753},null,null,null,null,0.58400000000000007,null,null,null,null,null,null,0.52469999999999994]
[null,"April",0,0,{"$f":"Input!C35","v":0.42380000000000001},0,0,0,0,0,0,{"$f":"Input!D35","v":0.4748},null,null,null,null,0.57620000000000005,null,null,null,null,null,null,0.5252]
[null,"May",0,0,{"$f":"Input!C36","v":0.4405},0,0,0,0,0,0,{"$f":"Input!D36","v":0.48499999999999999},null,null,null,null,0.5595,null,null,null,null,null,null,0.51500000000000001]
[null,"June",0,0,{"$f":"Input!C37","v":0.4597},0,0,0,0,0,0,{"$f":"Input!D37","v":0.49509999999999998},null,null,null,null,0.5403,null,null,null,null,null,null,0.50490000000000002]
[null,"July",0,0,{"$f":"Input!C38","v":0.48149999999999998},0,0,0,0,0,0,{"$f":"Input!D38","v":0.49480000000000002},null,null,null,null,0.51849999999999996,null,null,null,null,null,null,0.50519999999999998]
[null,"August",0,0,{"$f":"Input!C39","v":0.48089999999999999},0,0,0,0,0,0,{"$f":"Input!D39","v":0.49249999999999999},null,null,null,null,0.51910000000000001,null,null,null,null,null,null,0.50750000000000006]
[null,"September",0,0,{"$f":"Input!C40","v":0.48949999999999999},0,0,0,0,0,0,{"$f":"Input!D40","v":0.49690000000000001},null,null,null,null,0.51049999999999995,null,null,null,null,null,null,0.50309999999999999]
[null,"October",0,0,{"$f":"Input!C41","v":0.45569999999999999},0,0,0,0,0,0,{"$f":"Input!D41","v":0.49809999999999999},null,null,null,null,0.54430000000000001,null,null,null,null,null,null,0.50190000000000001]
[null,"November",0,0,{"$f":"Input!C42","v":0.42949999999999999},0,0,0,0,0,0,{"$f":"Input!D42","v":0.4899},null,null,null,null,0.57050000000000001,null,null,null,null,null,null,0.5101]
[null,"December",0,0,{"$f":"Input!C43","v":0.42749999999999999},0,0,0,0,0,0,{"$f":"Input!D43","v":0.47549999999999998},null,null,null,null,0.57250000000000001,null,null,null,null,null,null,0.52449999999999997]
[]
[]
["Table #3","Class Usage @ customer",null,null,null,null,null,null,null,null,null,null,null,null,"Usage by season - PSE&G periods"]
[null,{"$f":"Input!B47","v":"Calendar month sales forecasted for 2022, 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":1216460.8042101599},{"$f":"Input!D50","v":15356.34876296726},{"$f":"Input!E50","v":16023.811132804776},{"$f":"Input!F50","v":58},{"$f":"Input!G50","v":1},{"$f":"Input!H50","v":1312.7073641018796},{"$f":"Input!I50","v":15557},{"$f":"Input!J50","v":32676},{"$f":"Input!K50","v":536039.01539859804},{"$f":"AB45*$M$45","v":406318.30704733072},{"$f":"(1-AD45)","v":0.64911184957026302},"winter MWh =",{"$f":"SUM(C45:C49,C54:C56)","v":7120430.9835199751},{"$f":"SUM(D45:D49,D54:D56)","v":70747.115369639505},98488.956461400347,411,8,6302.3221523526754,102736,220472,3848234.2147292201,3031369.7598048099,{"$f":"SUM(O45:X45)","v":14499200.352037398},{"$f":"+Y45/(Y45+Y49)","v":0.60190926868384886},null,{"$f":"Input!L50","v":625960.39082683367},null,{"$f":"Input!C66","v":0.35088815042973703},{"$f":"Input!D66","v":0.34172074452167817},{"$f":"AE45","v":0.34172074452167817}]
[null,"February",{"$f":"Input!C51","v":985328.47632836632},{"$f":"Input!D51","v":11760.939576136181},{"$f":"Input!E51","v":13924.875367453742},{"$f":"Input!F51","v":57},{"$f":"Input!G51","v":1},{"$f":"Input!H51","v":1175.880633162644},{"$f":"Input!I51","v":12802},{"$f":"Input!J51","v":29367},{"$f":"Input!K51","v":488422.31162583811},{"$f":"AB46*$M$45","v":368128.51087407907},null,"on-peak",null,null,{"$f":"SUMPRODUCT(E27:E31,E45:E49)+SUMPRODUCT(E36:E38,E54:E56)","v":42162.637034360465},null,null,null,null,null,null,{"$f":"SUMPRODUCT(L27:L31,L45:L49)+SUMPRODUCT(L36:L38,L54:L56)","v":1457506.3447789373},null,null,null,{"$f":"Input!L51","v":567126.46844730119}]
[null,"March",{"$f":"Input!C52","v":925316.13675727637},{"$f":"Input!D52","v":9237.8111752826735},{"$f":"Input!E52","v":13405.29046568308},{"$f":"Input!F52","v":64},{"$f":"Input!G52","v":1},{"$f":"Input!H52","v":913.836712091138},{"$f":"Input!I52","v":12379},{"$f":"Input!J52","v":27322},{"$f":"Input!K52","v":503121.66935158957},380580.88382431783,null,"off-peak",{"$f":"+O45-O46","v":7120430.9835199751},{"$f":"+P45-P46","v":70747.115369639505},{"$f":"+Q45-Q46","v":56326.319427039882},{"$f":"+R45-R46","v":411},null,null,null,null,null,{"$f":"+X45-X46","v":1573863.4150258726},null,null,null,{"$f":"Input!L52","v":586310.17763160076}]
[null,"April",{"$f":"Input!C53","v":785557.03022227436},{"$f":"Input!D53","v":4853.0706364444468},{"$f":"Input!E53","v":11144.39400122155},{"$f":"Input!F53","v":53},{"$f":"Input!G53","v":1},{"$f":"Input!H53","v":613.64715693960261},{"$f":"Input!I53","v":10748},{"$f":"Input!J53","v":26105},{"$f":"Input!K53","v":450984.04808501509},338862.33864780137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L53","v":522039.98258873454}]
[null,"May",{"$f":"Input!C54","v":823748.98558658676},{"$f":"Input!D54","v":3364.1712011380082},{"$f":"Input!E54","v":11489.847746723126},{"$f":"Input!F54","v":61},{"$f":"Input!G54","v":1},{"$f":"Input!H54","v":301.01880806631857},{"$f":"Input!I54","v":9616},{"$f":"Input!J54","v":21208},{"$f":"Input!K54","v":459594.02408677386},402505.92875377636,null,"summer MWh =",{"$f":"SUM(C50:C53)","v":5521785.7729479587},{"$f":"+SUM(D50:D53)","v":20848.494845103523},76376.171993250711,164,3,1692.5051990726067,38845,79769,2230781.1933703814,1619215.4892862856,{"$f":"SUM(O49:X49)","v":9589480.6276420522},{"$f":"1-Z45","v":0.39809073131615114},null,{"$f":"Input!L54","v":620087.16836744046}]
[null,"June",{"$f":"Input!C55","v":1290025.0967616264},{"$f":"Input!D55","v":4510.6042525698986},{"$f":"Input!E55","v":18697.566951646237},{"$f":"Input!F55","v":46},{"$f":"Input!G55","v":1},{"$f":"Input!H55","v":398.04139909595847},{"$f":"Input!I55","v":8470},{"$f":"Input!J55","v":19103},{"$f":"Input!K55","v":497554.25892154238},381083.03969460574,null,"on-peak",null,null,{"$f":"+SUMPRODUCT(E32:E35,E50:E53)","v":36466.478029598642},null,null,null,null,null,null,{"$f":"+SUMPRODUCT(L32:L35,L50:L53)","v":801137.30735488236},null,null,null,{"$f":"Input!L55","v":587083.78216619731}]
[null,"July",{"$f":"Input!C56","v":1730592.1285201842},{"$f":"Input!D56","v":6291.2343111768787},{"$f":"Input!E56","v":22415.173519090018},{"$f":"Input!F56","v":36},{"$f":"Input!G56","v":1},{"$f":"Input!H56","v":430.3822627725051},{"$f":"Input!I56","v":9055},{"$f":"Input!J56","v":18825},{"$f":"Input!K56","v":603493.17868962837},415248.30468622124,null,"off-peak",null,null,{"$f":"+Q49-Q50","v":39909.693963652069},null,null,null,null,null,null,{"$f":"+X49-X50","v":818078.18193140323},null,null,null,{"$f":"Input!L56","v":639717.64644434012}]
[null,"August",{"$f":"Input!C57","v":1592628.9940705989},{"$f":"Input!D57","v":5967.3059936659101},{"$f":"Input!E57","v":21296.427649511745},{"$f":"Input!F57","v":40},{"$f":"Input!G57","v":0},{"$f":"Input!H57","v":501.69801344386434},{"$f":"Input!I57","v":10329},{"$f":"Input!J57","v":19965},{"$f":"Input!K57","v":610019.52009617479},430204.172768566,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L57","v":662758.15647700417}]
[null,"September",{"$f":"Input!C58","v":908539.55359554919},{"$f":"Input!D58","v":4079.3502876908387},{"$f":"Input!E58","v":13967.003873002714},{"$f":"Input!F58","v":42},{"$f":"Input!G58","v":1},{"$f":"Input!H58","v":362.38352376027888},{"$f":"Input!I58","v":10991},{"$f":"Input!J58","v":21876},{"$f":"Input!K58","v":519714.23566303588},392679.97213689261,null,"Block 1",{"$f":"+O49*C163","v":3567073.6093243812},{"$f":"+P49*D163","v":13780.85509261343},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L58","v":604949.62832193228}]
[null,"October",{"$f":"Input!C59","v":658896.53387536667},{"$f":"Input!D59","v":5618.009795867938},{"$f":"Input!E59","v":10464.720778364792},{"$f":"Input!F59","v":20},{"$f":"Input!G59","v":1},{"$f":"Input!H59","v":431.21151568728834},{"$f":"Input!I59","v":13089},{"$f":"Input!J59","v":26616},{"$f":"Input!K59","v":476897.28746945539},393635.57066067698,null,"Block 2",{"$f":"+O49-O53","v":1954712.1636235774},{"$f":"+P49-P53","v":7067.6397524900931},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L59","v":606421.79143899295}]
[null,"November",{"$f":"Input!C60","v":721135.95616163395},{"$f":"Input!D60","v":8358.7165545676671},{"$f":"Input!E60","v":9526.6593881410026},{"$f":"Input!F60","v":43},{"$f":"Input!G60","v":1},{"$f":"Input!H60","v":522.42933631344545},{"$f":"Input!I60","v":13505},{"$f":"Input!J60","v":27571},{"$f":"Input!K60","v":432735.45558365702},346274.03181941173,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L60","v":533458.18913744751}]
[null,"December",{"$f":"Input!C61","v":1003987.0603783099},{"$f":"Input!D61","v":12198.047667235318},{"$f":"Input!E61","v":12509.357581008262},{"$f":"Input!F61","v":55},{"$f":"Input!G61","v":1},{"$f":"Input!H61","v":1031.5906259903591},{"$f":"Input!I61","v":15040},{"$f":"Input!J61","v":29607},{"$f":"Input!K61","v":500440.40312829305},395064.18817741622,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!L61","v":608622.67179217865}]
[null,"Total",{"$f":"SUM(C45:C56)","v":12642216.756467931},{"$f":"SUM(D45:D56)","v":91595.610214743036},{"$f":"SUM(E45:E56)","v":174865.12845465107},575,11,{"$f":"SUM(H45:H56)","v":7994.8273514252833},{"$f":"SUM(I45:I56)","v":141581},{"$f":"SUM(J45:J56)","v":300241},6079015.408099602,{"$f":"SUM(L45:L56)","v":4650585.2490910953},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":7164536.0536400042}]
[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":3486739.4957885593},{"$f":"SUMPRODUCT(D9:D13,D45:D49)+SUMPRODUCT(D18:D20,D54:D56)","v":34044.654738877456},48140.422477387918,200.72069999999999,3.9260000000000002,3159.8403688836252,28517.465199999999,60874.357900000003,2130630.5146146975,1627384.7381727637,{"$f":"SUM(O61:X61)","v":7419696.1359611694},{"$f":"+Y61/(Y61+Y62)","v":0.51173140282309226}]
[null,null,"On-Peak","LMP ratio","Off-Peak",null,null,"On-Peak","Off-Peak",null,null,null,null,"off-peak",{"$f":"+O45-O61","v":3633691.4877314158},{"$f":"+P45-P61","v":36702.460630762049},50348.533984012429,210.27930000000001,4.0739999999999998,3142.4817834690502,74218.534799999994,159597.6421,1717603.7001145226,1403985.0216320462,{"$f":"SUM(O62:X62)","v":7079504.2160762278},{"$f":"1-Z61","v":0.48826859717690774}]
[null,"January",{"$f":"Input!C73","v":67.2},{"$f":"Input!F74","v":0.77165615665449716},{"$f":"ROUND(+C63*D63,3)","v":51.854999999999997},null,null,{"$f":"Input!F81","v":0.90395846852693051},{"$f":"Input!G81","v":0.94218684541265174},"NYMEX Forwards (January 5, 2022) from NERA"]
[null,"February",{"$f":"Input!C74","v":63},{"$f":"+$D$63","v":0.77165615665449716},{"$f":"ROUND(+C64*D64,3)","v":48.613999999999997},null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174},null,null,null,null,"Summer"]
[null,"March",{"$f":"Input!C75","v":45.2},{"$f":"+$D$63","v":0.77165615665449716},{"$f":"ROUND(+C65*D65,3)","v":34.878999999999998},null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174},"Congestion Factors & On/Off Peak Ratios ",null,null,null,"on-peak",{"$f":"SUMPRODUCT(C14:C17,C50:C53)","v":2808531.0779379727},{"$f":"SUMPRODUCT(D14:D17,D50:D53)","v":10744.264695903868},39974.442387257099,82.906599999999997,1.5004000000000002,1027.7278000627157,8175.9523000000008,16746.7984,1278481.7471400469,887040.57532911305,5050806.9929903559,{"$f":"+Y65/(Y65+Y66)","v":0.52670287256550763}]
[null,"April",{"$f":"Input!C76","v":40.799999999999997},{"$f":"+$D$63","v":0.77165615665449716},31.484000000000002,null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174},"  Summer Averages for Aug 2018-July 2021",null,null,null,"off-peak",{"$f":"+O49-O65","v":2713254.6950099859},{"$f":"+P49-P65","v":10104.230149199655},36401.729605993612,81.093400000000003,1.4995999999999998,664.77739900989104,30669.047699999999,63022.2016,952299.44623033446,732174.91395717254,4538673.6346516963,{"$f":"1-Z65","v":0.47329712743449237}]
[null,"May",{"$f":"Input!C77","v":40.9},{"$f":"+$D$63","v":0.77165615665449716},31.561,null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174},"  Winter Averages for Oct 2018-June 2021"]
[null,"June",{"$f":"Input!C78","v":44.35},{"$f":"Input!F73","v":0.66836581709145426},29.641999999999999,null,null,{"$f":"Input!F80","v":0.8879039176436947},{"$f":"Input!G80","v":0.89475926714955267},null,null,null,null,"Total on-peak",{"$f":"+O61+O65","v":6295270.573726532},{"$f":"+P61+P65","v":44788.919434781325},88114.864864645016,283.62729999999999,5.4264000000000001,4187.5681689463408,36693.417499999996,77621.156300000002,3409112.2617547447,2514425.3135018768,12470503.128951527,{"$f":"+Y68/(Y68+Y69)","v":0.51769140616172804}]
[null,"July",{"$f":"Input!C79","v":50.8},{"$f":"+$D$68","v":0.66836581709145426},33.953000000000003,null,null,{"$f":"+$H$68","v":0.8879039176436947},{"$f":"+$I$68","v":0.89475926714955267},null,null,null,null,"Total off-peak",{"$f":"+O62+O66","v":6346946.1827414017},46806.690779961704,86750.263590006041,291.37270000000001,5.5735999999999999,3807.2591824789415,104887.58249999999,222619.8437,2669903.1463448573,2136159.9355892185,11618177.850727925,{"$f":"1-Z68","v":0.48230859383827196}]
[null,"August",{"$f":"Input!C80","v":47.55},{"$f":"+$D$68","v":0.66836581709145426},31.780999999999999,null,null,{"$f":"+$H$68","v":0.8879039176436947},{"$f":"+$I$68","v":0.89475926714955267}]
[null,"September",{"$f":"Input!C81","v":45.45},{"$f":"+$D$68","v":0.66836581709145426},30.376999999999999,null,null,{"$f":"+$H$68","v":0.8879039176436947},{"$f":"+$I$68","v":0.89475926714955267}]
[null,"October",{"$f":"Input!C82","v":45.05},{"$f":"+$D$63","v":0.77165615665449716},34.762999999999998,null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174}]
[null,"November",{"$f":"Input!C83","v":46.6},{"$f":"+$D$63","v":0.77165615665449716},35.959000000000003,null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174}]
[null,"December",{"$f":"Input!C84","v":48.9},{"$f":"+$D$63","v":0.77165615665449716},37.734000000000002,null,null,{"$f":"+$H$63","v":0.90395846852693051},{"$f":"+$I$63","v":0.94218684541265174}]
[]
[]
["Table #6","Losses",{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL","GLP","LPL-S",null,null,null,"Loss Type","Percentage","Source"]
[null,"from meter to bulk system (includes Delivery & PJM EHV losses)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery Losses",{"$f":"Input!C89","v":5.8326999999999997E-2},"Tariff (Result of 2018 Loss Study)"]
[null,"     Loss Factors =",{"$f":"1-((1-$Q$78)*(1-$Q$79))","v":6.2621028879999985E-2},{"$f":"+$C79","v":6.2621028879999985E-2},{"$f":"+$C79","v":6.2621028879999985E-2},6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,6.2621028879999985E-2,null,null,null,"EHV Losses",{"$f":"Input!C90","v":4.5599999999999998E-3},"PJM"]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C79),6)","v":1.0668040000000001},{"$f":"ROUND(1/(1-D79),6)","v":1.0668040000000001},1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,1.0668040000000001,null,null,null,"Marginal Loss Deration Factor",{"$f":"+Input!C91","v":1.1688694814362801E-2},"NERA"]
[null,"     1 / Expansion Factor =",{"$f":"1/C80","v":0.93737931241352668},{"$f":"1/D80","v":0.93737931241352668},0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,0.93737931241352668,null,null,null,"Marginal Loss Factor",{"$f":"ROUND(1-((1-Q80)/(1-Q79)),7)","v":7.1614000000000001E-3}]
[]
[null,"from meter to transmission node (includes Delivery less mean hourly PJM marginal losses)"]
[null,"     Loss Factors =",{"$f":"1-((1-$Q$78)/((1-$Q$80)/(1-$Q$79)))","v":5.153470753435363E-2},{"$f":"+$C84","v":5.153470753435363E-2},{"$f":"+$C84","v":5.153470753435363E-2},5.153470753435363E-2,5.153470753435363E-2,5.153470753435363E-2,5.153470753435363E-2,5.153470753435363E-2,5.153470753435363E-2,5.153470753435363E-2]
[null,"     Expansion Factor =",{"$f":"ROUND(1/(1-C84),6)","v":1.054335},{"$f":"+$C$85","v":1.054335},{"$f":"+$C$85","v":1.054335},1.054335,1.054335,1.054335,1.054335,1.054335,1.054335,1.054335]
[null,"     1 / Expansion Factor =",{"$f":"1/C85","v":0.94846514627703715},{"$f":"1/D85","v":0.94846514627703715},0.94846514627703715,0.94846514627703715,0.94846514627703715,0.94846514627703715,0.94846514627703715,0.94846514627703715,0.94846514627703715,0.94846514627703715]
[]
[]
["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":37.759015085153976},37.820522643445877,37.865749306506508,37.200017797236882,37.152829796072751,38.957859441817057,33.052139327355441,33.015828948399381,38.5036348158755,38.047388707299568]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C14:C17,C50:C53,$C68:$C71,$H68:$H71)*C80)/SUMPRODUCT(C14:C17,C50:C53)","v":44.990020655114407},44.950641756430848,44.864975126879813,44.381536041352753,44.42056132737828,44.701750254308649,44.491476539506422,44.456045200030111,44.75754931982015,44.647818351987311]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(O14:O17,C50:C53,$E68:$E71,$I68:$I71)*C80)/SUMPRODUCT(O14:O17,C50:C53)","v":30.274091570481225},30.238758775042498,30.179571964376944,29.857925093544388,29.881221107375211,30.077960279609542,30.00256712331986,29.975836844752152,30.107624954567928,30.050872030977583]
[]
[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":44.341502637133864},46.104847571299388,44.153609627392314,43.560543596904758,43.15067505044432,46.249313923431487,41.933243525141926,41.885837251294241,44.099519842838248,43.72700196349745]
[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":49.216039980146334},51.254597276845459,48.983507304009891,48.370457544660447,47.871648053776589,50.96944443097351,49.561391463084568,49.557390000581272,48.266306129291429,48.035350844277829]
[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":39.664098973404336},41.328016598555116,39.535534456648392,38.969272394588216,38.601205239182057,41.503110141888605,39.002231158124253,38.959723547081623,38.930759430175371,38.733115912522727]
[]
[null,"Annual",{"$f":"(C94*SUM(C50:C53)+C98*SUM(C45:C49,C54:C56))/C57","v":41.466446243520473},44.219214568270196,41.407249014606926,41.746411020999489,41.51489907197935,44.705712782784758,39.496571284071329,39.529224755620369,42.046030216577556,41.749505096971099]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C102:L102,C57:L57)/SUM(C57:L57)","v":41.642753443739771}]
[]
[]
["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":208497.19229773057},788.50097137100249,2892.0409816870551,6.1008029187468482,0.11145848938821826,65.936379650015212,1283.910352171122,2633.6396593848704,85893.184423656101,61606.921121755571]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C50:C53,C14:C17)*C95/1000","v":126355.87120696013},482.96159328184217,1793.4523634151797,3.6795222559660159,6.6648610215598383E-2,45.941231447813564,363.76018994357361,744.49642662619192,57221.709852110485,39604.426478136556]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C50:C53,O14:O17)*C96/1000","v":82141.32109077042},305.53937808916015,1098.5886182718752,2.4212806627808328,4.4809879172619867E-2,19.995148202201648,920.15016222754855,1889.1432327586781,28671.474571545641,22002.494643619015]
[]
[null,"Winter - all hrs",{"$f":"SUM(C45:C49,C54:C56)*C98/1000","v":315730.60923328064},3261.7849702263616,4348.6429362059089,17.903383418327856,0.34520540040355457,291.47807567075529,4308.0537067989808,9234.6543104673437,169705.28111234031,132552.71143907172]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C45:C49,C9:C13)+SUMPRODUCT(C54:C56,C18:C20))*C99/1000","v":171603.510425085},1744.9450680704124,2358.0867360392531,9.7089520976845254,0.18794409025912692,161.05530809256078,1413.3652563120911,3016.7742954852656,102837.66466680274,78171.996856751924]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C45:C49,O9:O13)+SUMPRODUCT(C54:C56,O18:O20))*C100/1000","v":144127.09880819567},1516.8399021559492,1990.5562001666551,8.1944313206433321,0.15726131014442768,130.42276757819454,2894.688450486889,6217.8800149820763,66867.616445537555,54380.714582319793]
[]
[null,"Annual",{"$f":"+C112+C116","v":524227.80153101124},{"$f":"+D112+D116","v":4050.2859415973639},7240.683917892964,24.004186337074703,0.45666388979177286,357.41445532077051,5591.964058970103,11868.293969852213,255598.46553599642,194159.6325608273]
[]
[null,"System Total",{"$f":"SUM(C120:L120)","v":1003119.0028216953}]
[]
[]
["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":37.759015085153976},37.820522643445884,37.865749306506508,37.200017797236882,37.152829796072751,38.957859441817057,33.052139327355434,33.015828948399381,38.503634815875493,38.047388707299568]
[null,"PSE&G On pk",null,null,{"$f":"+(E113*1000-W131*AVERAGE(E$95,E$96))/Q131","v":45.571320703083956},null,null,null,null,null,null,{"$f":"+(L113*1000-X131*AVERAGE(L$95,L$96))/R131","v":45.430409163766655},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,E32:E35)","v":36466.478029598642},{"$f":"SUMPRODUCT(L50:L53,L32:L35)","v":801137.30735488236},null,{"$f":"SUMPRODUCT(E50:E53,E14:E17)","v":39974.442387257099},{"$f":"SUMPRODUCT(L50:L53,L14:L17)","v":887040.57532911305},null,{"$f":"+T131-Q131","v":3507.9643576584567},{"$f":"+U131-R131","v":85903.267974230694},null,{"$f":"+E131*Q131/1000","v":1661.8255651988047},{"$f":"+L131*R131/1000","v":36395.995669490592}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E114*1000-W132*AVERAGE(E$95,E$96))/Q132","v":30.824977450558105},null,null,null,null,null,null,{"$f":"+(L114*1000-X132*AVERAGE(L$95,L$96))/R132","v":30.817256845481968},null,null,null,null,{"$f":"SUMPRODUCT(E50:E53,Q32:Q35)","v":39909.693963652069},{"$f":"SUMPRODUCT(L50:L53,X32:X35)","v":818078.18193140335},null,{"$f":"SUMPRODUCT(E50:E53,Q14:Q17)","v":36401.72960599362},{"$f":"SUMPRODUCT(L50:L53,X14:X17)","v":732174.91395717254},null,{"$f":"+T132-Q132","v":-3507.9643576584494},{"$f":"+U132-R132","v":-85903.26797423081},null,{"$f":"+E132*Q132/1000","v":1230.21541648825},{"$f":"+L132*R132/1000","v":25210.925452264983}]
[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":2892.0409816870547},{"$f":"+AA132+AA131","v":61606.921121755571},null,{"$f":"+E112","v":2892.0409816870551},{"$f":"+L112","v":61606.921121755571}]
[null,"Winter - all hrs",{"$f":"+C116/SUM(C45:C49,C54:C56)*1000","v":44.341502637133864},46.104847571299388,44.153609627392314,43.560543596904765,43.15067505044432,46.249313923431487,41.933243525141926,41.885837251294241,44.099519842838248,43.72700196349745]
[null,"PSE&G On pk",null,null,{"$f":"+(E117*1000-W135*AVERAGE(E$99,E$100))/Q135","v":49.653270375364386},null,null,null,null,null,null,{"$f":"+(L117*1000-X135*AVERAGE(L$99,L$100))/R135","v":48.577457824065341},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38)","v":42162.637034360465},{"$f":"SUMPRODUCT(L45:L49,L27:L31)+SUMPRODUCT(L54:L56,L36:L38)","v":1457506.3447789373},null,{"$f":"SUMPRODUCT(E45:E49,E9:E13)+SUMPRODUCT(E54:E56,E18:E20)","v":48140.422477387918},{"$f":"SUMPRODUCT(L45:L49,L9:L13)+SUMPRODUCT(L54:L56,L18:L20)","v":1627384.7381727637},null,{"$f":"+T135-Q135","v":5977.7854430274529},{"$f":"+U135-R135","v":169878.39339382644},null,{"$f":"+E135*Q135/1000","v":2093.5128164054518},{"$f":"+L135*R135/1000","v":70801.952991806465}]
[null,"PSE&G Off pk",null,null,{"$f":"+(E118*1000-W136*AVERAGE(E$99,E$100))/Q136","v":40.03688049814},null,null,null,null,null,null,{"$f":"+(L118*1000-X136*AVERAGE(L$99,L$100))/R136","v":39.23514445899368},null,null,null,null,{"$f":"SUMPRODUCT(E45:E49,Q27:Q31)+SUMPRODUCT(E54:E56,Q36:Q38)","v":56326.319427039874},{"$f":"SUMPRODUCT(L45:L49,X27:X31)+SUMPRODUCT(L54:L56,X36:X38)","v":1573863.4150258729},null,{"$f":"SUMPRODUCT(E45:E49,Q9:Q13)+SUMPRODUCT(E54:E56,Q18:Q20)","v":50348.533984012407},{"$f":"SUMPRODUCT(L45:L49,X9:X13)+SUMPRODUCT(L54:L56,X18:X20)","v":1403985.0216320467},null,{"$f":"+T136-Q136","v":-5977.7854430274674},{"$f":"+U136-R136","v":-169878.39339382621},null,{"$f":"+E136*Q136/1000","v":2255.1301198004567},{"$f":"+L136*R136/1000","v":61750.758447265245}]
[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":4348.642936205908},{"$f":"+AA136+AA135","v":132552.71143907172},null,{"$f":"+E116","v":4348.6429362059089},{"$f":"+L116","v":132552.71143907172}]
[null,"Annual Average",{"$f":"(C130*SUM(C50:C53)+C134*SUM(C45:C49,C54:C56))/C57","v":41.466446243520473},44.219214568270196,41.407249014606926,41.746411020999496,41.51489907197935,44.705712782784758,39.496571284071329,39.529224755620369,42.046030216577549,41.749505096971099]
[null,"System Average",{"$f":"+C122/SUM(C57:L57)*1000","v":41.642753443739778}]
[]
[]
["Table #10","Generation & Transmission Obligations and Costs and Other Adjustments",null,null,null,null,null,null,null,null,null,"Adj for PLS"]
[null,{"$f":"Input!B97","v":"Obligations - Peak Load shares eff 6/1/22, scaling factors eff 1/1/22, Transmission Loads eff 1/1/22; 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":4302.4693517250362},{"$f":"Input!D101","v":17.819458494380996},{"$f":"Input!E101","v":57.390887807454881},{"$f":"Input!F101","v":0},{"$f":"Input!G101","v":0},{"$f":"Input!H101","v":2.7634796204940675},{"$f":"Input!I101","v":0},{"$f":"Input!J101","v":0},{"$f":"Input!K101","v":1567.7386098935538},{"$f":"Input!L101","v":1254.8923403065266}]
[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":4775.0714225860565},{"$f":"Input!D102","v":20.017302020508449},{"$f":"Input!E102","v":64.53252810955162},{"$f":"Input!F102","v":0},{"$f":"Input!G102","v":0},{"$f":"Input!H102","v":3.0224328826980353},{"$f":"Input!I102","v":0},{"$f":"Input!J102","v":0},{"$f":"Input!K102","v":1685.270959707269},{"$f":"Input!L102","v":1318.8404831557339}]
[null,"Gen Obl - MW",{"$f":"ROUND(AD145*$AD$148*$AD$149,1)","v":5023.7},{"$f":"ROUND(AE145*$AD$148*$AD$149,1)","v":20.8},67,0,0,3.2,0,0,1830.5,{"$f":"ROUND(AM145*$AD$148*$AD$149*(1-AE45),1)","v":964.5},null,null,null,null,null,{"$f":"Input!C108","v":2019}," NITS Rate",{"$f":"Input!D108","v":28},{"$f":"Input!E108","v":104709.15},{"$f":"U147/$T$150*T147","v":34492.425882352938}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!C109","v":2020}," NITS Rate",{"$f":"Input!D109","v":28},{"$f":"Input!E109","v":138497.08431889772},{"$f":"U148/$T$150*T148","v":45622.568952107482},null,null,null,null,null,null,"Final Zonal RPM Scaling Factor",{"$f":"Input!C104","v":1.0740768592912917}]
[null,"Trans Obl - MW",{"$f":"ROUND(AD146,1)","v":4775.1000000000004},{"$f":"ROUND(AE146,1)","v":20},64.5,0,0,3,0,0,1685.3,{"$f":"ROUND(AM146*(1-AF45),1)","v":868.2},null,null,null,null,null,{"$f":"Input!C110","v":2021}," NITS Rate",{"$f":"Input!D110","v":29},{"$f":"Input!E110","v":144787.97744165195},{"$f":"U149/$T$150*T149","v":49398.251127151845},null,{"$f":"+Input!B105","v":"PJM January 1, 2022 (through May 31, 2022) Forecast Pool Requirement"},null,null,null,null,null,{"$f":"Input!C105","v":1.0871}]
[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":129513.25}]
[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 =",0,"per MW-yr"]
[]
[null,null,null,"Base\nCapacity"]
[null,"Generation Capacity cost","summer =",{"$f":"Input!E113","v":104.84},"$/MW/day"]
[null,null,"winter =",{"$f":"Input!E114","v":104.84},"$/MW/day",null,null,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":"(D158*E152+D159*E153)/1000","v":38.266600000000004},"per kW/yr"]
[null,null,{"$f":"+C7","v":"RS"},{"$f":"+D7","v":"RHS"}]
[null,"% usage in Summer Blocks"]
[null,"Block 1 (0-600 kWh/m)",{"$f":"ROUND(Q165/Q167,3)","v":0.64600000000000002},{"$f":"ROUND(R165/R167,3)","v":0.66100000000000003},null,"(based on W/N actuals used in settlement and final rate design of 2018 Rate Case, rounded to .1%)",null,null,null,null,null,null,null,null,null,"Blocking Percentages based on Annualized W/N Usage Used in 2018 Electric Rate Case Settlement"]
[null,"Block 2  (>600 kWh/m)",{"$f":"1-C163","v":0.35399999999999998},{"$f":"1-D163","v":0.33899999999999997},null,null,null,null,null,null,null,null,null,null,null,null,"RS","RHS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June - September (0-600)",3528124,19973]
[null,"Required summer inversion =",{"$f":"Input!C119","v":0.86519999999999975},{"$f":"Input!D119","v":1.1569000000000003},"¢/kWh","(same as 2003/2004 BGS blocking inversion)",null,null,null,null,null,null,null,null,null,"June - September (600+)",1931618,10227]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Summer Usage",{"$f":"SUM(Q165:Q166)","v":5459742},{"$f":"SUM(R165:R166)","v":30200}]
["Table #11","Ancillary Services & Renewable Power Cost"]
[null,"Ancillary Services ",null,{"$f":"+Input!D123","v":2}]
[null,"Renewable Power Cost",null,{"$f":"+Input!D124","v":16.09}]
[null,"Total AncillaryServices & Renewable Power Costs",null,{"$f":"SUM(D169:D170)","v":18.09},"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":0},{"$f":"(+$D$155*D149*$H$154/12)/D57","v":0},{"$f":"(+$D$155*E149*$H$154/12)/SUMPRODUCT(E27:E38,E45:E56)","v":0},{"$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":0},{"$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":15.20618750043559},{"$f":"((+$Q$160*D147*1000)/D57)","v":8.6897753957196358},{"$f":"(+$Q$160*E147*1000)/SUMPRODUCT(E45:E56,E27:E38)","v":32.607033640331366},{"$f":"((+$Q$160*F147*1000)/F57)","v":0},{"$f":"((+$Q$160*G147*1000)/G57)","v":0},{"$f":"((+$Q$160*H147*1000)/H57)","v":15.31654338704007},{"$f":"((+$Q$160*I147*1000)/I57)","v":0},{"$f":"((+$Q$160*J147*1000)/J57)","v":0}]
[null,"recovery per summer MWh",{"$f":"(C147*$D$158*$E$152)/SUM(C50:C53)","v":11.636730763949105},{"$f":"(D147*$D$158*$E$152)/SUM(D50:D53)","v":12.760728579045724},{"$f":"(E147*$D$158*$E$152)/SUMPRODUCT(E50:E53,E32:E35)","v":23.499997979087315},{"$f":"(F147*$D$158*$E$152)/SUM(F50:F53)","v":0},{"$f":"(G147*$D$158*$E$152)/SUM(G50:G53)","v":0},{"$f":"(H147*$D$158*$E$152)/SUM(H50:H53)","v":24.182812568272752},{"$f":"(I147*$D$158*$E$152)/SUM(I50:I53)","v":0},{"$f":"(J147*$D$158*$E$152)/SUM(J50:J53)","v":0}]
[null,"recovery per winter MWh",{"$f":"(C147*$D$159*$E$153)/SUM(C45:C49,C54:C56)","v":17.974246831437036},{"$f":"(D147*$D$159*$E$153)/SUM(D45:D49,D54:D56)","v":7.4901046244975698},{"$f":"(E147*$D$159*$E$153)/(SUMPRODUCT(E45:E49,E27:E31)+SUMPRODUCT(E54:E56,E36:E38))","v":40.483711647565144},{"$f":"(F147*$D$159*$E$153)/SUM(F45:F49,F54:F56)","v":0},{"$f":"(G147*$D$159*$E$153)/SUM(G45:G49,G54:G56)","v":0},{"$f":"(H147*$D$159*$E$153)/SUM(H45:H49,H54:H56)","v":12.935483466132721},{"$f":"(I147*$D$159*$E$153)/SUM(I45:I49,I54:I56)","v":0},{"$f":"(J147*$D$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, Generation obligations, Ancillary Services and Renewable Power Costs- 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":72.263686945589569},{"$f":"+D130+($D$171*D80)+D$178+D181","v":65.808782399165523},null,{"$f":"+F130+($D$171*F80)+F$178+F181","v":56.498502157236885},{"$f":"+G130+($D$171*G80)+G$178+G181","v":56.451314156072755},{"$f":"+H130+($D$171*H80)+H$178+H181","v":73.572887188857123},{"$f":"+I130+($D$171*I80)+I$178+I181","v":52.350623687355437},{"$f":"+J130+($D$171*J80)+J$178+J181","v":52.314313308399377}]
[null,"PSE&G On pk",null,null,{"$f":"+E131+($D$171*E80)+E$178+E181","v":97.476838703415325}]
[null,"PSE&G Off pk",null,null,{"$f":"+E132+($D$171*E80)","v":50.123461810558105}]
[null,"Block 1 (0-600 kWh/m)",{"$f":"(C194*SUM(C50:C53)-C166*10*C164*SUM(C50:C53))/SUM(C50:C53)","v":69.200878945589565},{"$f":"(D194*SUM(D50:D53)-D166*10*D164*SUM(D50:D53))/SUM(D50:D53)","v":61.886891399165513}]
[null,"Block 2 (>600 kWh/m)",{"$f":"+C197+C166*10","v":77.852878945589566},{"$f":"+D197+D166*10","v":73.455891399165523}]
[]
[null,"Winter - all hrs",{"$f":"+C134+($D$171*C80)+C$178+C181","v":78.84617449756945},{"$f":"+D134+($D$171*D80)+D$178+D181","v":74.093107327019027},null,{"$f":"+F134+($D$171*F80)+F$178+F181","v":62.859027956904768},{"$f":"+G134+($D$171*G80)+G$178+G181","v":62.449159410444324},{"$f":"+H134+($D$171*H80)+H$178+H181","v":80.864341670471561},{"$f":"+I134+($D$171*I80)+I$178+I181","v":61.231727885141922},{"$f":"+J134+($D$171*J80)+J$178+J181","v":61.184321611294237}]
[null,"PSE&G On pk",null,null,{"$f":"+E135+($D$171*E80)+E$178+E181","v":101.55878837569576}]
[null,"PSE&G Off pk",null,null,{"$f":"+E136+($D$171*E80)","v":59.335364858139997}]
[]
[null,"Annual -all hrs",{"$f":"+C138+($D$171*C80)+C$178+C181","v":75.971118103956059},{"$f":"+D138+($D$171*D80)+D$178+D181","v":72.207474323989828},{"$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":75.367674395425738},{"$f":"+F138+($D$171*F80)+F$178+F181","v":61.044895380999492},{"$f":"+G138+($D$171*G80)+G$178+G181","v":60.813383431979346},{"$f":"+H138+($D$171*H80)+H$178+H181","v":79.320740529824832},{"$f":"+I138+($D$171*I80)+I$178+I181","v":58.795055644071326},{"$f":"+J138+($D$171*J80)+J$178+J181","v":58.827709115620365}]
[]
[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":57.80211917587549},{"$f":"+L130+($D$171*L$80)","v":57.345873067299564},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,{"$f":"+L131+($D$171*L$80)","v":64.728893523766658},null,null,null,"summer",{"$f":"+$D158*$E152/$H152/1000","v":3.1976199999999997},{"$f":"+$D158*$E152/$H152/1000","v":3.1976199999999997},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,{"$f":"+L132+($D$171*L$80)","v":50.115741205481967},null,null,null,"winter",{"$f":"+$D159*$E153/$H153/1000","v":3.1845150000000002},{"$f":"+$D159*$E153/$H153/1000","v":3.1845150000000002},"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",{"$f":"($D$158*$E$152+$D$159*$E$153)/$H$154/1000","v":3.1888833333333335},{"$f":"($D$158*$E$152+$D$159*$E$153)/$H$154/1000","v":3.1888833333333335},"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"+K134+($D$171*K80)","v":63.398004202838251},{"$f":"+L134+($D$171*L$80)","v":63.025486323497447}]
[null,"PSE&G On pk",null,{"$f":"+L135+($D$171*L$80)","v":67.875942184065337},null,null,null,"Trans cost"]
[null,"PSE&G Off pk",null,{"$f":"+L136+($D$171*L$80)","v":58.533628818993677},null,null,null,"all months",{"$f":"+$D155/1000/12","v":0},{"$f":"+$D155/1000/12","v":0},"per kW of T obl /month"]
[]
[null,"Annual - all hrs per MWh only",{"$f":"+K138+($D$171*K80)","v":61.344514576577552},{"$f":"+L138+($D$171*L$80)","v":61.047989456971095}]
[]
[null,"Including Generation Obligation $"]
[null,"Summer - all hrs",{"$f":"(C211*W49+((I214*$H152)*K147*1000)+(I217*$H152*K149*1000))/W49","v":68.268857839468836},{"$f":"(D211*X49+((J214*$H152)*L147*1000)+(J217*$H152*L149*1000))/X49","v":64.943819098202937},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":80.08545199015478}]
[null,"PSE&G Off pk",null,{"$f":"+D213","v":50.115741205481967}]
[]
[null,"Winter - all hrs",{"$f":"(C215*W45+((I214*$H153)*K147*1000)+(I217*$H153*K149*1000))/W45","v":75.532922434840714},{"$f":"(D215*X45+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X45","v":71.14241884893913}]
[null,"PSE&G On pk",null,{"$f":"(D216*X46+((J214*$H153)*L147*1000)+(J217*$H153*L149*1000))/X46","v":84.757806121152996}]
[null,"PSE&G Off pk",null,{"$f":"+D217","v":58.533628818993677}]
[]
[null,"Annual - including Gen Obl $",{"$f":"(C219*K57+((I214*$H152+I214*$H153)*K147*1000)+(I217*$H154*K149*1000))/K57","v":72.867270581879055},{"$f":"(D219*L57+((J214*$H152+J214*$H153)*L147*1000)+(J217*$H154*L149*1000))/L57","v":68.98422408619615}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C204:J204,C57:J57)+SUMPRODUCT(C230:D230,K57:L57))/1000","v":1770671.3619810685}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C233/SUM(C57:L57)*1000","v":73.506364398895826},"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":69.718224661891924},"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, Generation obligations, Ancillary Services and Renewable Power Costs- 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.81},{"$f":"ROUND(+G194/$D$235,3)","v":0.81},{"$f":"ROUND(+H194/$D$235,3)","v":1.0549999999999999},{"$f":"ROUND(+I194/$D$235,3)","v":0.751},{"$f":"ROUND(+J194/$D$235,3)","v":0.75}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E195/$D$235,3)","v":1.3979999999999999},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E196/$D$235,3)","v":0.71899999999999997},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I245*U49+J245*V49)/(U49+V49),3)","v":0.75}]
[]
[null,"All usage Multiplier",{"$f":"ROUND(+C194/$D$235,3)","v":1.0369999999999999},{"$f":"ROUND(+D194/$D$235,3)","v":0.94399999999999995}]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C197-C194,3)","v":-3.0630000000000002},{"$f":"ROUND(D197-D194,3)","v":-3.9220000000000002},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"ROUND(+C198-C194,3)","v":5.5890000000000004},{"$f":"ROUND(D198-D194,3)","v":7.6470000000000002},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C200/$D$235,3)","v":1.131},{"$f":"ROUND(+D200/$D$235,3)","v":1.0629999999999999},null,{"$f":"ROUND(+F200/$D$235,3)","v":0.90200000000000002},{"$f":"ROUND(+G200/$D$235,3)","v":0.89600000000000002},{"$f":"ROUND(+H200/$D$235,3)","v":1.1599999999999999},{"$f":"ROUND(+I200/$D$235,3)","v":0.878},{"$f":"ROUND(+J200/$D$235,3)","v":0.878}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E201/$D$235,3)","v":1.4570000000000001},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E202/$D$235,3)","v":0.85099999999999998},null,null,null,null,"for all streetlighting =",{"$f":"ROUND((I255*U45+J255*V45)/(U45+V45),3)","v":0.878}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C204/$D$235,3)","v":1.0900000000000001},{"$f":"ROUND(+D204/$D$235,3)","v":1.036},1.081,0.876,0.872,1.1379999999999999,0.84299999999999997,0.84399999999999997]
[]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+K7","v":"GLP"},{"$f":"+C265","v":"GLP"},{"$f":"+L7","v":"LPL-S"},{"$f":"+E265","v":"LPL-S"},null,"PLUS:"]
[null,null,"Multiplier","Constant (in $/MWh)","Multiplier","Constant (in $/MWh)"]
[null,"Summer - all hrs",{"$f":"ROUND(+C222/$D$235,3)","v":0.97899999999999998},{"$f":"ROUND(+C211-C222,3)","v":-10.467000000000001},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D223/$D$235,3)","v":1.149},{"$f":"ROUND(+D212-D223,3)","v":-15.356999999999999},null,"summer",{"$f":"ROUND(+I212,4)","v":3.1976},3.1976,"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D224/$D$235,3)","v":0.71899999999999997},{"$f":"ROUND(+D213-D224,3)","v":0},null,"winter",3.1844999999999999,3.1844999999999999,"per kW of G obl /month"]
[null,null,null,null,null,null,null,"annual",3.1888999999999998,3.1888999999999998,"per kW of G obl /month"]
[null,"Winter - all hrs",{"$f":"ROUND(+C226/$D$235,3)","v":1.083},{"$f":"ROUND(+C215-C226,3)","v":-12.135}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(D227/$D$235,3)","v":1.216},{"$f":"ROUND(+D216-D227,3)","v":-16.882000000000001},null,"Trans cost"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(D228/$D$235,3)","v":0.84},{"$f":"ROUND(+D217-D228,3)","v":0},null,"all months",{"$f":"ROUND(+I217,4)","v":0},{"$f":"ROUND(+J217,4)","v":0},"per kW of T obl /month"]
[]
[null,"Annual - including Gen Obl $",{"$f":"ROUND(+C230/$D$235,3)","v":1.0449999999999999},null,{"$f":"ROUND(+D230/$D$235,3)","v":0.98899999999999999}]
[]
[]
[]
["Assumptions:"]
[null,"Gen Cost =",{"$f":"+D158","v":104.84},"/MW day ","summer"]
[null,null,{"$f":"+D159","v":104.84},"/MW day ","winter"]
[]
[null,"Trans cost =",{"$f":"+D155","v":0},"per MW-yr"]
[null,"Analysis time period =",{"$f":"+H152","v":4},"summer months"]
[null,null,{"$f":"+H153","v":8},"winter months"]
[null,"Ancillary Services & RPS =",{"$f":"+D171","v":18.09},"per MWh"]
[null,"Energy Costs ="," based on Forwards @ PJM West - corrected for congestion"]
[null,"Usage patterns =",{"$f":"\" forecasted \"&(Input!D2-1)&\" energy use by class, PJM and PSE&G on/off % from \"&(Input!D2-4)&\", \"&(Input!D2-3)&\" & \"&(Input!D2-2)&\" class load profiles\"","v":" forecasted 2021 energy use by class, PJM and PSE&G on/off % from 2018, 2019 & 2020 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":399024.59847692162},{"$f":"(+D197*SUM(D50:D53)*D163+D198*SUM(D50:D53)*D164)/1000","v":1372.0140606115419},{"$f":"(E195*SUMPRODUCT(E32:E35,E50:E53)+E196*SUMPRODUCT(Q32:Q35,E50:E53))/1000","v":5555.0490182310004},{"$f":"+F194*SUM(F50:F53)/1000","v":9.2657543537868499},{"$f":"+G194*SUM(G50:G53)/1000","v":0.16935394246821828},{"$f":"+H194*SUM(H50:H53)/1000","v":124.52249407792307},{"$f":"+I194*SUM(I50:I53)/1000","v":2033.559977135322},{"$f":"+J194*SUM(J50:J53)/1000","v":4173.0604582977103},{"$f":"(C211*SUM(K50:K53)/1000)+(I212*$H152*K147)+(I217*$H152*K149)","v":152356.85403449653},{"$f":"(D211*SUM(L50:L53)/1000)+(J212*$H152*L147)+(J217*$H152*L149)","v":105191.74387721668}]
[null,"Winter",{"$f":"+C200*SUM(C45:C49,C54:C56)/1000","v":561418.74382451607},{"$f":"+D200*SUM(D45:D49,D54:D56)/1000","v":5241.8736121596976},{"$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":7624.1290462534371},{"$f":"+F200*SUM(F45:F49,F54:F56)/1000","v":25.835060490287859},{"$f":"+G200*SUM(G45:G49,G54:G56)/1000","v":0.49959327528355457},{"$f":"+H200*SUM(H45:H49,H54:H56)/1000","v":509.63313184522849},{"$f":"+I200*SUM(I45:I49,I54:I56)/1000","v":6290.7027960079404},{"$f":"+J200*SUM(J45:J49,J54:J56)/1000","v":13489.429754285264},{"$f":"(C215*SUM(K45:K49,K54:K56)/1000)+(I213*$H153*K147)+(I217*$H153*K149)","v":290604.40657890902},{"$f":"(D215*SUM(L45:L49,L54:L56)/1000)+(J213*$H153*L147)+(J217*$H153*L149)","v":215625.27107804178}]
[null,"Total",{"$f":"+C303+C302","v":960443.34230143763},{"$f":"+D303+D302","v":6613.8876727712395},13179.178064484437,35.100814844074705,0.66894721775177279,634.15562592315155,8324.2627731432622,17662.490212582976,{"$f":"+K303+K302","v":442961.26061340555},{"$f":"+L303+L302","v":320817.01495525846}]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C302/C304","v":0.41545875836961832},{"$f":"+D302/D304","v":0.2074444152204151},0.42150193214255743,0.26397547734852606,0.25316488053779557,0.19635951963156281,0.24429310229084045,{"$f":"+J302/J304","v":0.23626682353798392},{"$f":"+K302/K304","v":0.34395074147909738},{"$f":"+L302/L304","v":0.32788704767384874}]
[null,"Winter",{"$f":"+C303/C304","v":0.58454124163038168},{"$f":"+D303/D304","v":0.79255558477958488},0.57849806785744262,0.736024522651474,0.74683511946220449,0.80364048036843727,0.75570689770915955,{"$f":"+J303/J304","v":0.76373317646201599},{"$f":"+K303/K304","v":0.65604925852090268},{"$f":"+L303/L304","v":0.6721129523261512}]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C302:L302)","v":669840.83750528458}]
[null,"Winter",{"$f":"+SUM(C303:L303)","v":1100830.524475784}]
[null,"Total",{"$f":"+C312+C311","v":1770671.3619810687}]
[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.37829766261981607},null,{"$f":"+C311/SUMPRODUCT(O49:X49,C85:L85)*1000","v":66.25183496334995},"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.62170233738018388},null,{"$f":"+C312/SUMPRODUCT(O45:X45,C85:L85)*1000","v":72.010825360892227},"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":69.718224661891924},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":399211.89760932518},{"$f":"+($C$322*D249*P49+D250*P53+D251*P54)/1000","v":1372.1206523287844},{"$f":"(($C$322*E246*Q50)+(C322*E247*Q51))/1000","v":5554.8139289885466},{"$f":"+$C$322*F245*R49/1000","v":9.2613689640857242},{"$f":"+$C$322*G245*S49/1000","v":0.16941528592839739},{"$f":"+$C$322*H245*T49/1000","v":124.48837288443413},{"$f":"+$C$322*K247*U49/1000","v":2031.1533277433939},{"$f":"+$C$322*K247*V49/1000","v":4171.0147972908426},{"$f":"+($C$322*C267+D267)*W49/1000+(I268*H152*K147)+(I273*H152*K149)","v":152323.29666728253},{"$f":"(($C$322*E268+F268)*X50+(C322*E269*X51))/1000+(J268*$H$152*L147)+(J273*$H$152*L149)","v":105217.50784256017}]
[null,"Winter",{"$f":"+$C$322*C255*O45/1000","v":561455.32571535069},{"$f":"+$C$322*D255*P45/1000","v":5243.1021703831566},{"$f":"(($C$322*E256*Q46)+(C322*E257*Q47))/1000","v":7624.7099353570175},{"$f":"+$C$322*F255*R45/1000","v":25.846079683105899},{"$f":"+$C$322*G255*S45/1000","v":0.49974023437644133},{"$f":"+$C$322*H255*T45/1000","v":509.68858558283677},{"$f":"+$C$322*K257*U45/1000","v":6288.7378023427054},{"$f":"+$C$322*K257*V45/1000","v":13495.664623482528},{"$f":"+($C$322*C271+D271)*W45/1000+(I269*H153*K147)+(I273*H153*K149)","v":290495.79411365982},{"$f":"(($C$322*E272+F272)*X46+C322*E273*X47)/1000+(J269*$H$153*L147)+(J273*$H$153*L149)","v":215700.17076478316}]
[null,"Total",{"$f":"+C329+C328","v":960667.22332467581},{"$f":"+D329+D328","v":6615.2228227119413},13179.523864345563,35.107448647191625,0.66915552030483871,634.17695846727088,8319.8911300861,17666.679420773369,442819.09078094235,320917.67860734335]
[]
[null,"Total Summer",{"$f":"SUM(C328:L328)","v":670015.72398265393}]
[null,"Total Winter",{"$f":"SUM(C329:L329)","v":1100839.5395308596}]
[null,"Grand Total",{"$f":"+C333+C332","v":1770855.2635135134}]
[]
[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":405886.39715895127},1532.4970592526809,5614.134729928629,12.055043761418917,0.22051909319668747,124.40990391005674,2855.3547250751085,5863.529181735521,163976.61529408692,119022.64379581412]
[null,"Winter",{"$f":"+$C$322*$C$324*O45*C85/1000","v":523396.99455180747},5200.3632425314445,7239.5651229186788,30.211115767946183,0.58805091519116659,463.26078869006915,7551.749852884961,16206.095171753361,282869.7064801848,222824.97019200565]
[null,"Total",{"$f":"+C339+C338","v":929283.39171075867},6732.8603017841251,12853.699852847309,42.266159529365098,0.80857000838785409,587.6706926001259,10407.10457796007,22069.624353488882,446846.32177427172,341847.61398781976]
[]
[null,"Total Summer",{"$f":"SUM(C338:L338)","v":704887.85741160903}]
[null,"Total Winter",{"$f":"SUM(C339:L339)","v":1065783.5045694595}]
[null,"Grand Total",{"$f":"+C343+C342","v":1770671.3619810685}]
[]
[null,"Difference ( in $1000) =",{"$f":"+C334-C344","v":183.9015324448701}]
[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":10110525.057544984}]
[null,"Winter",{"$f":"SUMPRODUCT(O45:X45,C85:L85)","v":15287014.403165348}]
[null,"Total",{"$f":"+C353+C352","v":25397539.460710332}]

{"sheet":"Att 3","index":2,"n_rows":211,"n_cols":12,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"\"Calculation of June \"&(Input!D2)&\" to May \"&(Input!D2+1)&\" BGS-RSCP Rates\"","v":"Calculation of June 2022 to May 2023 BGS-RSCP Rates"}]
[null,"Illustrative Only"]
[null,"NJ Sales & Use Tax (SUT) excluded"]
[]
["Table A","Auction Results"]
["line #","Specific BGS-RSCP Auction >>",{"$f":"Input!C135","v":"remaining portion of 36 month bid - 2020 auction"},{"$f":"Input!D135","v":"remaining portion of 36 month bid - 2021 auction"},{"$f":"Input!E135","v":"36 month bid - 2022 auction"},null,"Notes:"]
[null,null,{"$f":"LEFT(RIGHT(C6,12),4)","v":"2020"},{"$f":"LEFT(RIGHT(D6,12),4)","v":"2021"},"2022"]
[1,"Winning Bid - in $/MWh",{"$f":"Input!C136","v":102.16},{"$f":"Input!D136","v":64.8},{"$f":"D11","v":57.48},null,"2022 Illustrative (Excluding transmission)"]
["1A","Capacity Proxy Price True-Up - in $/MWh",{"$f":"'Att 4-1'!C21","v":-7.32},{"$f":"C9","v":-7.32},0,null,"entered after 2022 Auction"]
["1B","Transmission Price ",37.770000000000003,0,0,null,"asssumed transmission price in bids"]
["1C","Total - in $/MWh",{"$f":"C8+C9-C10","v":57.07},{"$f":"D8+D9-D10","v":57.48},{"$f":"E8+E9-E10","v":57.48},null,"= line 1 + line 1A - line 1B"]
[]
[null,"      (includes all payments, including impact of PJM marginal losses)"]
[2,"# of Tranches for Bid",{"$f":"Input!C137","v":28},{"$f":"Input!D137","v":29},{"$f":"Input!E137","v":28},null,"from then current Bid"]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid"]
[null,"Payment Factors"]
[4,"                           Summer",{"$f":"Input!C140","v":1},{"$f":"Input!D140","v":1},{"$f":"IF(LEFT(Input!$B$2,6)=\"rebase\",Input!E140,'Att 2'!L316)","v":1}]
[5,"                           Winter",{"$f":"Input!C141","v":1},{"$f":"Input!D141","v":1},{"$f":"IF(LEFT(Input!$B$2,6)=\"rebase\",Input!E141,'Att 2'!L317)","v":1}]
[]
[null,"Applicable Customer Usage @ transmission nodes - in MWh"]
[6,"                           Summer MWh",{"$f":"+'Att 2'!C352","v":10110525.057544984},null,null,null,"from Table #17 of the current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"+'Att 2'!C353","v":15287014.403165348}]
[]
[null,"Total Payment to Suppliers - in $1000 "]
[8,"                           Summer",{"$f":"(+C$11*C$14/C$15*C17*$C21/1000)","v":190073.11318770095},198275.72269321038,191438.6288072376,null,"= ((1C * (2)/(3) * (4) * (6)) /1000 "]
[9,"                           Winter",287388.67689037765,299790.94175205153,289453.32307094627,null,"= ((1C * (2)/(3) * (5) * (7)) /1000"]
[10,"                           Total",{"$f":"+C26+C25","v":477461.79007807863},{"$f":"+D26+D25","v":498066.66444526194},{"$f":"+E26+E25","v":480891.95187818387},null,"Note: $ reflect total payment"]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":57.344999999999999},null,null,null,"= sum(line 8) / (6) - rounded to 3 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C26:E26)/C22*1000,3)","v":57.344999999999999},null,null,null,"= sum(line 9) / (7) - rounded to 3 decimal places"]
[]
[13,"                Total weighted average",{"$f":"ROUND(+SUM(C27:E27)/(C21+C22)*1000,3)","v":57.344999999999999},"   <<< 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":"(C33*(C22+C21))/1000","v":1456421.900374434},null,null,null,"= (13) * [(6)+(7)] / 1000"]
[15,"Total Payment to Suppliers =",{"$f":"SUM(C27:E27)","v":1456420.4064015243},null,null,null,"= sum (line 10)"]
[16,"Difference =",{"$f":"+C37-C38","v":1.4939729096367955},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":"+'Att 2'!C243","v":"RS"},{"$f":"+'Att 2'!D243","v":"RHS"},{"$f":"+'Att 2'!E243","v":"RLM"},{"$f":"+'Att 2'!F243","v":"WH"},{"$f":"+'Att 2'!G243","v":"WHS"},{"$f":"+'Att 2'!H243","v":"HS"},{"$f":"+'Att 2'!I243","v":"PSAL"},{"$f":"+'Att 2'!J243","v":"BPL"}]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"+'Att 2'!F245","v":0.81},{"$f":"+'Att 2'!G245","v":0.81},{"$f":"+'Att 2'!H245","v":1.0549999999999999},{"$f":"+'Att 2'!I245","v":0.751},{"$f":"+'Att 2'!J245","v":0.75}]
[null,"PSE&G On pk",null,null,{"$f":"+'Att 2'!E246","v":1.3979999999999999},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+'Att 2'!E247","v":0.71899999999999997},null,null,null,null,"for all streetlighting =",{"$f":"+'Att 2'!K247","v":0.75}]
[]
[null,"All usage Multiplier",{"$f":"+'Att 2'!C249","v":1.0369999999999999},{"$f":"+'Att 2'!D249","v":0.94399999999999995}]
[null,"Constant (in $/MWh)",{"$f":"+'Att 2'!C250","v":-3.0630000000000002},{"$f":"+'Att 2'!D250","v":-3.9220000000000002},"for Block 1 (0-600 kWh/m) usage"]
[null,"Constant (in $/MWh)",{"$f":"+'Att 2'!C251","v":5.5890000000000004},{"$f":"+'Att 2'!D251","v":7.6470000000000002},"for Block 2 (>600 kWh/m) usage"]
[]
[]
[]
[null,"Winter - all hrs",{"$f":"+'Att 2'!C255","v":1.131},{"$f":"+'Att 2'!D255","v":1.0629999999999999},null,{"$f":"+'Att 2'!F255","v":0.90200000000000002},{"$f":"+'Att 2'!G255","v":0.89600000000000002},{"$f":"+'Att 2'!H255","v":1.1599999999999999},{"$f":"+'Att 2'!I255","v":0.878},{"$f":"+'Att 2'!J255","v":0.878}]
[null,"PSE&G On pk",null,null,{"$f":"+'Att 2'!E256","v":1.4570000000000001},null,null,null,null,"Use weighted average"]
[null,"PSE&G Off pk",null,null,{"$f":"+'Att 2'!E257","v":0.85099999999999998},null,null,null,null,"for all streetlighting =",{"$f":"+'Att 2'!K257","v":0.878}]
[]
[null,"Annual - all hrs",{"$f":"+'Att 2'!C259","v":1.0900000000000001},{"$f":"+'Att 2'!D259","v":1.036},{"$f":"+'Att 2'!E259","v":1.081},{"$f":"+'Att 2'!F259","v":0.876},{"$f":"+'Att 2'!G259","v":0.872},{"$f":"+'Att 2'!H259","v":1.1379999999999999},{"$f":"+'Att 2'!I259","v":0.84299999999999997},{"$f":"+'Att 2'!J259","v":0.84399999999999997}]
[]
[]
[null,"DEMAND RATES",{"$f":"C33*C71+D71","v":45.673755}]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+'Att 2'!C265","v":"GLP"},{"$f":"+'Att 2'!D265","v":"GLP"},{"$f":"+'Att 2'!E265","v":"LPL-S"},{"$f":"+'Att 2'!F265","v":"LPL-S"},null,"PLUS:",{"$f":"+C69","v":"GLP"},{"$f":"+E69","v":"LPL-S"}]
[null,null,"Multiplier","Constant (in $/MWh)","Multiplier","Constant (in $/MWh)"]
[null,"Summer - all hrs",{"$f":"+'Att 2'!C267","v":0.97899999999999998},{"$f":"+'Att 2'!D267","v":-10.467000000000001},null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"+'Att 2'!E268","v":1.149},{"$f":"+'Att 2'!F268","v":-15.356999999999999},null,"summer",{"$f":"+'Att 2'!I$270","v":3.1888999999999998},{"$f":"+'Att 2'!J$270","v":3.1888999999999998},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+'Att 2'!E269","v":0.71899999999999997},{"$f":"+'Att 2'!F269","v":0},null,"winter",{"$f":"+'Att 2'!I$270","v":3.1888999999999998},{"$f":"+'Att 2'!J$270","v":3.1888999999999998},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"+'Att 2'!C271","v":1.083},{"$f":"+'Att 2'!D271","v":-12.135},null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"+'Att 2'!E272","v":1.216},{"$f":"+'Att 2'!F272","v":-16.882000000000001},null,"all months",{"$f":"+'Att 2'!I273","v":0},{"$f":"+'Att 2'!J273","v":0},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"+'Att 2'!E273","v":0.84},{"$f":"+'Att 2'!F273","v":0}]
[]
[null,"Annual - including T&G Obl $",{"$f":"+'Att 2'!C275","v":1.0449999999999999},null,{"$f":"+'Att 2'!E275","v":0.98899999999999999}]
[]
[]
["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":"+C47","v":"RS"},{"$f":"+D47","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(($C$33*F49)/10,4)","v":4.6448999999999998},{"$f":"ROUND(($C$33*G49)/10,4)","v":4.6448999999999998},{"$f":"ROUND(($C$33*H49)/10,4)","v":6.0499000000000001},{"$f":"ROUND(($C$33*K51)/10,4)","v":4.3009000000000004},{"$f":"+I90","v":4.3009000000000004}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$33*E50)/10,4)","v":8.0167999999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$33*E51/10),4)","v":4.1231}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND((+$C$33*C53+C54)/10,4)","v":5.6403999999999996},{"$f":"ROUND((+$C$33*D53+D54)/10,4)","v":5.0212000000000003}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND((+$C$33*C53+C55)/10,4)","v":6.5056000000000003},{"$f":"ROUND((+$C$33*D53+D55)/10,4)","v":6.1780999999999997}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$33*C59)/10,4)","v":6.4856999999999996},{"$f":"ROUND(($C$33*D59)/10,4)","v":6.0957999999999997},null,{"$f":"ROUND(($C$33*F59)/10,4)","v":5.1725000000000003},{"$f":"ROUND(($C$33*G59)/10,4)","v":5.1380999999999997},{"$f":"ROUND(($C$33*H59)/10,4)","v":6.6520000000000001},{"$f":"ROUND(($C$33*K61)/10,4)","v":5.0349000000000004},{"$f":"+I97","v":5.0349000000000004}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$33*E60)/10,4)","v":8.3552}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$33*E61)/10,4)","v":4.8800999999999997}]
[]
[]
[]
[null,"DEMAND RATES --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C69","v":"GLP"},null,{"$f":"+E69","v":"LPL-S"},null,null,"PLUS:",{"$f":"+C106","v":"GLP"},{"$f":"+E106","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(($C$33*C71+D71)/10,4)","v":4.5674000000000001},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$33*E72+F72)/10,4)","v":5.0532000000000004},null,null,"summer",{"$f":"+I72","v":3.1888999999999998},{"$f":"+J72","v":3.1888999999999998},"per kW of G obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$33*E73+F73)/10,4)","v":4.1231},null,null,"winter",{"$f":"+I73","v":3.1888999999999998},{"$f":"+J73","v":3.1888999999999998},"per kW of G obl /month"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(($C$33*C75+D75)/10,4)","v":4.9969999999999999},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(($C$33*E76+F76)/10,4)","v":5.2850000000000001},null,null,"all months",{"$f":"+I76","v":0},{"$f":"+J76","v":0},"per kW of T obl /month"]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(($C$33*E77+F77)/10,4)","v":4.8170000000000002}]
[]
[]
[]
["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":"+C94/100*'Att 2'!O53+'Att 3'!C95/100*'Att 2'!O54","v":328362.97437702783},{"$f":"+D94/100*'Att 2'!P53+'Att 3'!D95/100*'Att 2'!P54","v":1128.6101474588961},{"$f":"+E91/100*'Att 2'!Q50+E92/100*'Att 2'!Q51","v":4568.9612024922026},{"$f":"+F90/100*'Att 2'!R49","v":7.6176359999999992},{"$f":"+G90/100*'Att 2'!S49","v":0.139347},{"$f":"+H90/100*'Att 2'!T49","v":102.39487203869363},{"$f":"+I90/100*'Att 2'!U49","v":1670.6846050000001},{"$f":"+J90/100*'Att 2'!V49","v":3430.7849210000004}]
[null,"Winter",{"$f":"+C97/100*'Att 2'!O45","v":461809.79229815502},{"$f":"+D97/100*'Att 2'!P45","v":4312.6026587024844},{"$f":"+E98/100*'Att 2'!Q46+'Att 3'!E99/100*'Att 2'!Q47","v":6271.5533638538582},{"$f":"+F97/100*'Att 2'!R45","v":21.258975},{"$f":"+G97/100*'Att 2'!S45","v":0.41104799999999997},{"$f":"+H97/100*'Att 2'!T45","v":419.23046957449992},{"$f":"+I97/100*'Att 2'!U45","v":5172.6548640000001},{"$f":"+J97/100*'Att 2'!V45","v":11100.544728000001}]
[null,"Total",{"$f":"+C123+C122","v":790172.76667518285},{"$f":"+D123+D122","v":5441.2128061613803},10840.514566346061,28.876610999999997,0.55039499999999997,521.62534161319354,6843.3394690000005,14531.329649000001]
[]
[]
[null,null,"GLP","GLP",null,"LPL-S","LPL-S"]
[null,null,"Energy $","Obligation $",null,"Energy $","Obligation $"]
[]
[null,"Summer",{"$f":"+C108/100*'Att 2'!W49","v":101888.70022599879},{"$f":"I109*'Att 2'!K147*4+'Att 3'!I113*'Att 2'!K149*4","v":23349.125799999998},null,{"$f":"+E109/100*'Att 2'!X50+'Att 3'!E110/100*'Att 2'!X51","v":74213.251934470609},{"$f":"'Att 3'!J109*'Att 2'!L147*4+'Att 3'!J113*'Att 2'!L149*4","v":12302.7762}]
[null,"Winter",{"$f":"+C112/100*'Att 2'!W45","v":192296.26371001912},{"$f":"'Att 3'!I110*'Att 2'!K147*8+'Att 3'!I113*'Att 2'!K149*8","v":46698.251599999996},null,{"$f":"+E113/100*'Att 2'!X46+'Att 3'!E114/100*'Att 2'!X47","v":152842.21102336311},{"$f":"'Att 3'!J110*'Att 2'!L147*8+'Att 3'!J113*'Att 2'!L149*8","v":24605.5524}]
[null,"Total",{"$f":"+C131+C130","v":294184.96393601794},{"$f":"+D131+D130","v":70047.377399999998},null,{"$f":"+F131+F130","v":227055.46295783372},{"$f":"+G131+G130","v":36908.328600000001}]
[]
[]
[null,null,"Energy $","Obligation $","Total $"]
[null,"Total Summer",{"$f":"SUM(C122:J122)+C130+F130","v":515374.11926848697},{"$f":"+D130+G130","v":35651.902000000002},{"$f":"+C136+D136","v":551026.02126848698}]
[null,"Total Winter",{"$f":"SUM(C123:J123)+C131+F131","v":834246.52313866792},{"$f":"+D131+G131","v":71303.804000000004},{"$f":"+C137+D137","v":905550.32713866793}]
[null,"Grand Total",{"$f":"+C137+C136","v":1349620.6424071549},{"$f":"+D132+G132","v":106955.70600000001},{"$f":"+C138+D138","v":1456576.3484071549}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C25+D25+E25","v":579787.46468814893}]
[null,"Winter",{"$f":"+C26+D26+E26","v":876632.94171337539}]
[null,"Total",{"$f":"+C143+C142","v":1456420.4064015243},null,"kWh Rate"]
[null,null,null,null,"Adjustment","   rounded to 5 decimal places"]
[null,"Differences - in $1000",null,null,"Factors"]
[null,"Summer",{"$f":"+C142-E136","v":28761.443419661955},null,{"$f":"ROUND(1+(C147/C136),5)","v":1.0558099999999999}]
[null,"Winter",{"$f":"+C143-E137","v":-28917.385425292538},null,{"$f":"ROUND(1+(C148/C137),5)","v":0.96533999999999998}]
[null,"Total",{"$f":"+C144-E138","v":-155.94200563058257}]
[]
[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":"+C120","v":"RS"},{"$f":"+D120","v":"RHS"},"RLM","WH","WHS","HS","PSAL","BPL"]
[]
[null,"Summer - all hrs",null,null,null,{"$f":"ROUND(+F90*$E$147,4)","v":4.9040999999999997},{"$f":"ROUND(+G90*$E$147,4)","v":4.9040999999999997},{"$f":"ROUND(+H90*$E$147,4)","v":6.3875000000000002},{"$f":"ROUND(+I90*$E$147,4)","v":4.5408999999999997},{"$f":"ROUND(+J90*$E$147,4)","v":4.5408999999999997}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E91*$E$147,4)","v":8.4641999999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E92*$E$147,4)","v":4.3532000000000002}]
[]
[null,"for Block 1 (0-600 kWh/m) usage",{"$f":"ROUND(+C94*$E$147,4)","v":5.9551999999999996},{"$f":"ROUND(+D94*$E$147,4)","v":5.3014000000000001}]
[null,"for Block 2 (>600 kWh/m) usage",{"$f":"ROUND(+C95*$E$147,4)","v":6.8686999999999996},{"$f":"ROUND(+D95*$E$147,4)","v":6.5228999999999999}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C97*$E$148,4)","v":6.2609000000000004},{"$f":"ROUND(+D97*$E$148,4)","v":5.8845000000000001},null,{"$f":"ROUND(+F97*$E$148,4)","v":4.9931999999999999},{"$f":"ROUND(+G97*$E$148,4)","v":4.96},{"$f":"ROUND(+H97*$E$148,4)","v":6.4214000000000002},{"$f":"ROUND(+I97*$E$148,4)","v":4.8604000000000003},{"$f":"ROUND(+J97*$E$148,4)","v":4.8604000000000003}]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E98*$E$148,4)","v":8.0655999999999999}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E99*$E$148,4)","v":4.7110000000000003}]
[]
[]
[]
[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":"+C106","v":"GLP"},null,{"$f":"+E106","v":"LPL-S"},null,null,"PLUS:",{"$f":"+C178","v":"GLP"},{"$f":"+E178","v":"LPL-S"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(+C108*$E$147,4)","v":4.8223000000000003},null,null,null,null,"Gen Cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E109*$E$147,4)","v":5.3352000000000004},null,null,"summer",{"$f":"+I109","v":3.1888999999999998},{"$f":"+J109","v":3.1888999999999998}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E110*$E$147,4)","v":4.3532000000000002},null,null,"winter",{"$f":"+I110","v":3.1888999999999998},{"$f":"+J110","v":3.1888999999999998}]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C112*$E$148,4)","v":4.8238000000000003},null,null,null,null,"Trans cost"]
[null,"PSE&G On pk",null,null,{"$f":"ROUND(+E113*$E$148,4)","v":5.1017999999999999},null,null,"all months",{"$f":"+I113","v":0},{"$f":"+J113","v":0}]
[null,"PSE&G Off pk",null,null,{"$f":"ROUND(+E114*$E$148,4)","v":4.6500000000000004}]
[]
[]
[]
["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":"+C166/100*'Att 2'!O53+'Att 3'!C167/100*'Att 2'!O54","v":346689.68196529814},{"$f":"+D166/100*'Att 2'!P53+'Att 3'!D167/100*'Att 2'!P54","v":1191.5933252949847},{"$f":"+E163/100*'Att 2'!Q50+E164/100*'Att 2'!Q51","v":4823.9444310069903},{"$f":"+F162/100*'Att 2'!R49","v":8.0427239999999998},{"$f":"+G162/100*'Att 2'!S49","v":0.14712299999999998},{"$f":"+H162/100*'Att 2'!T49","v":108.10876959076276},{"$f":"+I162/100*'Att 2'!U49","v":1763.912605},{"$f":"+J162/100*'Att 2'!V49","v":3622.230521},{"$f":"+C180/100*'Att 2'!W49+I181*'Att 2'!K147*4+'Att 3'!I185*'Att 2'!K149*4","v":130924.08728789989},{"$f":"+E181/100*'Att 2'!X50+'Att 3'!E182/100*'Att 2'!X51+'Att 3'!J181*'Att 2'!L147*4+'Att 3'!J185*'Att 2'!L149*4","v":90657.633237835544}]
[null,"Winter",{"$f":"+C169/100*'Att 2'!O45","v":445803.06344720209},{"$f":"+D169/100*'Att 2'!P45","v":4163.1140039264365},{"$f":"+E170/100*'Att 2'!Q46+'Att 3'!E171/100*'Att 2'!Q47","v":6054.2025608512267},{"$f":"+F169/100*'Att 2'!R45","v":20.522051999999999},{"$f":"+G169/100*'Att 2'!S45","v":0.39679999999999999},{"$f":"+H169/100*'Att 2'!T45","v":404.69731469117477},{"$f":"+I169/100*'Att 2'!U45","v":4993.3805440000006},{"$f":"+J169/100*'Att 2'!V45","v":10715.821088000001},{"$f":"+C184/100*'Att 2'!W45+'Att 3'!I182*'Att 2'!K147*8+'Att 3'!I185*'Att 2'!K149*8","v":232329.37365010811},{"$f":"+E185/100*'Att 2'!X46+'Att 3'!E186/100*'Att 2'!X47+'Att 3'!J182*'Att 2'!L147*8+'Att 3'!J185*'Att 2'!L149*8","v":172149.2598966349}]
[null,"Total",{"$f":"+C195+C194","v":792492.74541250023},5354.7073292214209,10878.146991858217,28.564775999999998,0.54392299999999993,512.8060842819375,6757.293149000001,14338.051609,363253.46093800804,262806.89313447045]
[]
[null,"Total Summer",{"$f":"SUM(C194:L194)","v":579789.38198992633}]
[null,"Total Winter",{"$f":"SUM(C195:L195)","v":876633.8313574139}]
[null,"Grand Total",{"$f":"+C199+C198","v":1456423.2133473402}]
[]
[]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+C25+D25+E25","v":579787.46468814893}]
[null,"Winter",{"$f":"+C26+D26+E26","v":876632.94171337539}]
[null,"Total",{"$f":"+C205+C204","v":1456420.4064015243}]
[]
[null,"Differences - in $1000",null,null,"% difference"]
[null,"Summer",{"$f":"+C198-C204","v":1.9173017774010077},null,{"$f":"+C209/C198","v":3.3068935667992626E-6}]
[null,"Winter",{"$f":"+C199-C205","v":0.88964403851423413},null,{"$f":"+C210/C199","v":1.0148410963522531E-6}]
[null,"Total",{"$f":"+C200-C206","v":2.8069458159152418},null,{"$f":"+C211/C200","v":1.9272871993463738E-6}]

{"sheet":"Att 4-1","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Development of Capacity Proxy Price True-Up - $/MWh"]
[null,"2022/2023 Delivery Year - Illustrative Data"]
[null,null,"2022/23\nDelivery Year",null,"Notes:"]
[1,"Zonal Capacity Price ($/MW-day)",97.75,null,"as may be determined by the RPM or its successor or otherwise"]
[2,"Capacity Proxy Price ($/MW-day)",162.13,null,"per Board Orders dated 11/13/2019 and 11/18/2020"]
[]
[3,"Capacity Proxy Price True-Up - $/MW-day",{"$f":"C4-C5","v":-64.38},null,"= line 1 - line 2 "]
[4,"BGS-RSCP Gen Obl - MW",{"$f":"SUM('Att 2'!C147:L147)","v":7909.7}]
[5,"Days in Year",365]
[6,"Capacity Proxy Price True-Up Annual Cost ",{"$f":"C7*C8*C9","v":-185867667.38999999},null,"= line 3 * line 4 * line 5"]
[]
[7,"Eligible Tranches",{"$f":"SUM('Att 3'!C14:D14)","v":57},null,"from Table A"]
[8,"Total Tranches",{"$f":"'Att 3'!E15","v":85},null,"from Table A"]
[9,"% of tranches eligible for payment",{"$f":"+C12/C13","v":0.6705882352941176},null,"= line 7 / line 8"]
[]
[10,"Capacity Proxy Price True-Up Cost ",{"$f":"C10*C14","v":-124640671.0732941},null,"= line 6 * line 9"]
[]
[11,"Total Applicable Customer Usage @ bulk system - in MWh",{"$f":"'Att 2'!C354","v":25397539.460710332}]
[12,"Eligible Customer Usage @ bulk system - in MWh",{"$f":"+C14*C18","v":17031291.167770457},null,"= line 9 * line 11"]
[]
[13,"Capacity Proxy Price True-Up - $/MWh",{"$f":"ROUND(+C16/C19,2)","v":-7.32},null,"= line 10/ line 12 - rounded to 2 decimal places"]

{"sheet":"Att 4-2","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Development of Capacity Proxy Price True-Up - $/MWh"]
[null,"2023/2024 Delivery Year - Illustrative Data","Capacity Proxy Price True-Up Development for Winning Suppliers from 2021 BGS-RSCP Auction","Capacity Proxy Price True-Up Development for Winning Suppliers from 2022 BGS-RSCP Auction"]
[null,null,"2023/24\nDelivery Year","2023/24\nDelivery Year",null,"Notes:"]
[1,"Zonal Capacity Price ($/MW-day)",170,170,null,"as may be determined by the RPM or its successor or otherwise"]
[2,"Capacity Proxy Price ($/MW-day)",166.64,128.79,null,"per Board Orders dated 11/18/2020 and 11/17/2021"]
[]
[3,"Capacity Proxy Price True-Up - $/MW-day",{"$f":"C4-C5","v":3.3600000000000136},{"$f":"D4-D5","v":41.210000000000008},null,"= line 1 - line 2 "]
[4,"BGS-RSCP Gen Obl - MW",{"$f":"'Att 4-1'!C8","v":7909.7},{"$f":"C8","v":7909.7}]
[5,"Days in Year",365,365]
[6,"Capacity Proxy Price True-Up Annual Cost ",{"$f":"C7*C8*C9","v":9700456.0800000392},{"$f":"D7*D8*D9","v":118974939.00500003},null,"= line 3 * line 4 * line 5"]
[]
[7,"Eligible Tranches",{"$f":"'Att 3'!D14","v":29},{"$f":"'Att 3'!E14","v":28},null,"from Table A"]
[8,"Total Tranches",{"$f":"'Att 4-1'!C13","v":85},{"$f":"C13","v":85},null,"from Table A"]
[9,"% of tranches eligible for payment",{"$f":"+C12/C13","v":0.3411764705882353},{"$f":"+D12/D13","v":0.32941176470588235},null,"= line 7 / line 8"]
[]
[10,"Capacity Proxy Price True-Up Cost ",{"$f":"C10*C14","v":3309567.3684706017},{"$f":"D10*D14","v":39191744.613411769},null,"= line 6 * line 9"]
[]
[11,"Total Applicable Customer Usage @ bulk system - in MWh",{"$f":"'Att 4-1'!C18","v":25397539.460710332},{"$f":"C18","v":25397539.460710332}]
[12,"Eligible Customer Usage @ bulk system - in MWh",{"$f":"+C14*C18","v":8665042.8748305831},{"$f":"+D14*D18","v":8366248.2929398743},null,"= line 9 * line 11"]
[]
[13,"Capacity Proxy Price True-Up - $/MWh",{"$f":"ROUND(+C16/C19,2)","v":0.38},{"$f":"ROUND(+D16/D19,2)","v":4.68},null,"= line 10/ line 12 - rounded to 2 decimal places"]

{"sheet":"Att 4-3","index":5,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Development of Capacity Proxy Price True-Up - $/MWh"]
[null,"2024/2025 Delivery Year - Illustrative Data"]
[null,null,"2024/25\nDelivery Year",null,"Notes:"]
[1,"Zonal Capacity Price ($/MW-day)",90,null,"as may be determined by the RPM or its successor or otherwise"]
[2,"Capacity Proxy Price ($/MW-day)",87.98,null,"per Board Orders dated 11/17/2021"]
[]
[3,"Capacity Proxy Price True-Up - $/MW-day",{"$f":"C4-C5","v":2.019999999999996},null,"= line 1 - line 2 "]
[4,"BGS-RSCP Gen Obl - MW",{"$f":"SUM('Att 2'!C147:L147)","v":7909.7}]
[5,"Days in Year",365]
[6,"Capacity Proxy Price True-Up Annual Cost ",{"$f":"C7*C8*C9","v":5831821.8099999884},null,"= line 3 * line 4 * line 5"]
[]
[7,"Eligible Tranches",{"$f":"'Att 3'!D14","v":29},null,"from Table A"]
[8,"Total Tranches",{"$f":"'Att 3'!E15","v":85},null,"from Table A"]
[9,"% of tranches eligible for payment",{"$f":"+C12/C13","v":0.3411764705882353},null,"= line 7 / line 8"]
[]
[10,"Capacity Proxy Price True-Up Cost ",{"$f":"C10*C14","v":1989680.3822352902},null,"= line 6 * line 9"]
[]
[11,"Total Applicable Customer Usage @ bulk system - in MWh",{"$f":"'Att 2'!C354","v":25397539.460710332}]
[12,"Eligible Customer Usage @ bulk system - in MWh",{"$f":"+C14*C18","v":8665042.8748305831},null,"= line 9 * line 11"]
[]
[13,"Capacity Proxy Price True-Up - $/MWh",{"$f":"ROUND(+C16/C19,2)","v":0.23},null,"= line 10/ line 12 - rounded to 2 decimal places"]

{"sheet":"Att 4-4","index":6,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Table A With Additional Line Item"]
["Calculation of June 2023 to May 2024 BGS-RSCP Rates"]
["Illustrative Purposes Only"]
[]
["Table A","Auction Results"]
["line #","Specific BGS-RSCP Auction >>","remaining portion of 36 month bid - 2021 auction","remaining portion of 36 month bid - 2022 auction","36 month bid - 2023 auction",null,"Notes:"]
[]
[1,"Winning Bid - in $/MWh",{"$f":"'Att 3'!E11","v":57.48},{"$f":"C8","v":57.48},{"$f":"D8","v":57.48},null,"winning Bids"]
["1A","23/24 Capacity Proxy Price True-up - in $/MWh",{"$f":"'Att 4-2'!C21","v":0.38},{"$f":"'Att 4-2'!D21","v":4.68},null,null,"entered after 2023 BGS Auction"]
["1B","Total - in $/MWh",{"$f":"C8+C9","v":57.86},{"$f":"D8+D9","v":62.16},{"$f":"E8+E9","v":57.48},null,"= line 1 + line 1A "]
[]
[2,"# of Tranches for Bid",29,28,28,null,"from then current Bid"]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid"]
[]
[null,"Payment Factors"]
[4,"                           Summer",1,1,1,null,"from then current Bid Factor Spreadsheet"]
[5,"                           Winter",1,1,1,null,"from then current Bid Factor Spreadsheet"]
[]
[null,"Applicable Customer Usage @ bulk system - in MWh"]
[6,"                           Summer MWh",{"$f":"'Att 3'!C21","v":10110525.057544984},null,null,null,"from current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"'Att 3'!C22","v":15287014.403165348}]
[]
[null,"Total Payment to Suppliers - in $1000 "]
[8,"                           Summer",{"$f":"((+C$10)*C$12/C$13*C16*$C20/1000)","v":199586.5225300827},{"$f":"((+D$10)*D$12/D$13*D16*$C20/1000)","v":207025.49002536346},191438.6288072376,null,"= (1B * (2)/(3) * (4) * (6)) / 1000"]
[9,"                           Winter",{"$f":"((+C$10)*C$12/C$13*C17*$C21/1000)","v":301772.85820761486},313020.50386377913,289453.32307094627,null,"= (1B * (2)/(3) * (5) * (7)) / 1000"]
[10,"                           Total",{"$f":"+C25+C24","v":501359.38073769759},{"$f":"+D25+D24","v":520045.99388914258},{"$f":"+E25+E24","v":480891.95187818387}]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C24:E24)/C20*1000,3)","v":59.151000000000003},null,null,null,"= sum(line 8) / (6) - rounded to 2 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":59.151000000000003},null,null,null,"= sum(line 9) / (7) - rounded to 2 decimal places"]
[]
[13,"                Total weighted average",{"$f":"ROUND(+SUM(C26:E26)/(C20+C21)*1000,3)","v":59.151000000000003},"   <<< used in calculation of",null,null,"= sum(line 10) / [ (6) + (7)]"]
[null,null,null,"           Customer Rates",null,null,"   rounded to 2 decimal places"]

{"sheet":"Att 4-5","index":7,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Table A With Additional Line Item"]
["Calculation of June 2024 to May 2025 BGS-RSCP Rates"]
["Illustrative Purposes Only"]
[]
["Table A","Auction Results"]
["line #","Specific BGS-RSCP Auction >>","remaining portion of 36 month bid - 2022 auction","remaining portion of 36 month bid - 2023 auction","36 month bid - 2024 auction",null,"Notes:"]
[]
[1,"Winning Bid - in $/MWh",{"$f":"'Att 3'!E8","v":57.48},{"$f":"'Att 3'!E11","v":57.48},{"$f":"D8","v":57.48},null,"winning Bids"]
["1A","22/23 Capacity Proxy Price True-up - in $/MWh",{"$f":"'Att 4-3'!C21","v":0.23},null,null,null,"entered after 2024 BGS Auction"]
["1B","Total - in $/MWh",{"$f":"C8+C9","v":57.709999999999994},{"$f":"D8+D9","v":57.48},57.48,null,"= line 1 + line 1A"]
[]
[2,"# of Tranches for Bid",{"$f":"'Att 3'!E14","v":28},{"$f":"'Att 3'!C14","v":28},{"$f":"'Att 3'!D14","v":29},null,"from then current Bid"]
[3,"Total # of Tranches",85,85,85,null,"from then current Bid"]
[]
[null,"Payment Factors"]
[4,"                           Summer",1,1,1,null,"from then current Bid Factor Spreadsheet"]
[5,"                           Winter",1,1,1,null,"from then current Bid Factor Spreadsheet"]
[]
[null,"Applicable Customer Usage @ bulk system - in MWh"]
[6,"                           Summer MWh",{"$f":"'Att 3'!C21","v":10110525.057544984},null,null,null,"from current Bid Factor Spreadsheet"]
[7,"                           Winter MWh",{"$f":"'Att 3'!C22","v":15287014.403165348}]
[]
[null,"Total Payment to Suppliers - in $1000 "]
[8,"                           Summer",{"$f":"((+C$10)*C$12/C$13*C16*$C20/1000)","v":192204.64976453866},{"$f":"((+D$10)*D$12/D$13*D16*$C20/1000)","v":191438.6288072376},198275.72269321038,null,"= (1B * (2)/(3) * (4) * (6)) / 1000"]
[9,"                           Winter",{"$f":"((+C$10)*C$12/C$13*C17*$C21/1000)","v":290611.5392210214},289453.32307094627,299790.94175205153,null,"= (1B * (2)/(3) * (5) * (7)) / 1000"]
[10,"                           Total",{"$f":"+C25+C24","v":482816.18898556009},{"$f":"+D25+D24","v":480891.95187818387},{"$f":"+E25+E24","v":498066.66444526194}]
[]
[null,"Average Payment to Suppliers - in $/MWh"]
[11,"                           Summer",{"$f":"ROUND(+SUM(C24:E24)/C20*1000,3)","v":57.555999999999997},null,null,null,"= sum(line 8) / (6) - rounded to 2 decimal places"]
[12,"                           Winter",{"$f":"ROUND(+SUM(C25:E25)/C21*1000,3)","v":57.555999999999997},null,null,null,"= sum(line 9) / (7) - rounded to 2 decimal places"]
[]
[13,"                Total weighted average",{"$f":"ROUND(+SUM(C26:E26)/(C20+C21)*1000,3)","v":57.555999999999997},"   <<< used in calculation of",null,null,"= sum(line 10) / [ (6) + (7)]"]
[null,null,57.555999999999997,"           Customer Rates",null,null,"   rounded to 2 decimal places"]

{"sheet":"Att 5","index":8,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Development of Assumed Transmission Price in Bids"]
["Calculation for 2020/2021"]
[]
["line #",null,"remaining portion of 36 month bid - 2020 auction",null,"Notes:"]
[]
[1,"Eligible Tranches",28]
[2,"Total Tranches",{"$f":"'Att 3'!E15","v":85}]
[3,"Tranche %",{"$f":"C6/C7","v":0.32941176470588235},null,"= line 1 / line 2"]
[4,"Transmission Obligations (MW)",6901,null,"Obligations from filing years"]
[5,"Adjustment Transmission Obligation (MW)",{"$f":"C8*C9","v":2273.2705882352939},null,"= line 3 * line 4"]
[6,"NITS Rate ($/MW-yr)",138497.08431889772,null,"NITS Rates from from 2020"]
[7,"Payment ($/yr)",{"$f":"C10*C11","v":314841348.3384937},null,"= line 5 * line 6"]
[8,"Pre Loss Usage (MWh)",25302921.322157942,null,"Applicable usage from filing year"]
[9,"Allocated Usage (MWh)",{"$f":"C8*C13","v":8335079.9649461452},null,"= line 3 * line 8"]
[10,"Transmission Price ($/MWh)",{"$f":"C12/C14","v":37.773044729334877},null,"= line 7 / line 9 (To Attachment 3, Table A, Line 1B)"]