{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BGS Cost & Bid Factors","Weighted Avg Price Calc","Rate Calculations","Backup Calcs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":12,"defined_names":407,"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":"BGS Cost & Bid Factors","index":0,"n_rows":610,"n_cols":27,"rows_kept":610,"cut":false,"hidden":false,"merged":[[209,19,209,20],[375,8,375,9],[397,8,397,9]]}
[null,{"$f":"\"Development of BGS Cost and Bid Factors for Rates Effective June 1, \" &M1","v":"Development of BGS Cost and Bid Factors for Rates Effective June 1, 2022"},null,null,null,null,null,null,null,null,null,null,2022,"<<< Year of the auction"]
[]
[null,null,null,{"$f":"\"Based on \" &M1-1  &\" Load Profile Information\"","v":"Based on 2021 Load Profile Information"}]
["Table #1","% Usage During PJM On-Peak Period",null,"On-Peak periods defined as the 16 hr PJM Trading period, adj for NERC holidays",null,null,null,null,null,null,null,{"$f":"\"'% usage during Off-Peak period (from \"&M1-1&\" profiles)\"","v":"'% usage during Off-Peak period (from 2021 profiles)"}]
[null,null,"Profile Meter Data","Profile Meter Data","Profile Meter Data","   --- Other Analysis ---",null,"Profile Meter Data",null,null,null,"Profile Meter Data","Profile Meter Data","Profile Meter Data"," -- Other Analysis --",null,"Profile Meter Data"]
[null,null,"SC1","SC3","SC2 ND","SC4","SC6","SC2 Dem",null,null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"January",0.41586027693136868,0.45255312285509552,0.32844313711550627,0.49396201750906749,{"$f":"F8","v":0.49396201750906749},0.48293282703884877,null,null,null,{"$f":"1-C8","v":0.58413972306863138},0.54744687714490448,0.67155686288449368,0.50603798249093246,0.50603798249093246,0.51706717296115123]
[null,"February",0.45459235640647283,0.49347954380352294,0.36180062668171481,0.53024884905253877,{"$f":"F9","v":0.53024884905253877},0.52032532567065604,null,null,null,0.54540764359352711,0.50652045619647712,0.63819937331828513,0.46975115094746123,0.46975115094746123,0.47967467432934396]
[null,"March",0.47877247998186895,0.51275904068566602,0.36797325071491799,0.55177175734087569,0.55177175734087569,0.54314951879908469,null,null,null,0.52122752001813111,0.48724095931433398,0.63202674928508196,0.44822824265912431,0.44822824265912431,0.45685048120091531]
[null,"April",0.47580705729475697,0.50327178938632566,0.36808585216138973,0.54471324265278132,0.54471324265278132,0.54263803531648758,null,null,null,0.52419294270524297,0.49672821061367434,0.63191414783861033,0.45528675734721868,0.45528675734721868,0.45736196468351242]
[null,"May",0.42043993607420027,0.45497046169459338,0.29260536927944036,0.48961046885554355,0.48961046885554355,0.49182264593008596,null,null,null,0.57956006392579973,0.54502953830540668,0.70739463072055964,0.5103895311444564,0.5103895311444564,0.50817735406991404]
[null,"June",0.4891456463655543,0.51240953300497505,0.31775433775788992,0.54789499178832779,0.54789499178832779,0.55335852670449281,null,null,null,0.51085435363444565,0.48759046699502495,0.68224566224211003,0.45210500821167221,0.45210500821167221,0.44664147329550719]
[null,"July",0.44959476101459167,0.48542440996834119,0.28622969565576639,0.50793861238183169,0.50793861238183169,0.50832240698422715,null,null,null,0.55040523898540838,0.51457559003165887,0.71377030434423361,0.49206138761816831,0.49206138761816831,0.49167759301577285]
[null,"August",0.49313895202143876,0.50686769872888759,0.30971114345556544,0.53512463229496876,0.53512463229496876,0.54003256626590279,null,null,null,0.50686104797856124,0.49313230127111241,0.6902888565444345,0.46487536770503124,0.46487536770503124,0.45996743373409721]
[null,"September",0.47185772383886793,0.49575907479915676,0.35045972103001771,0.53174882883232566,0.53174882883232566,0.53261717795942898,null,null,null,0.52814227616113207,0.50424092520084329,0.64954027896998223,0.46825117116767434,0.46825117116767434,0.46738282204057102]
[null,"October",0.44952102971235808,0.49290100839877493,0.34039300254943405,0.51559042677182765,0.51559042677182765,0.51145727357183601,null,null,null,0.55047897028764192,0.50709899160122507,0.65960699745056595,0.48440957322817235,0.48440957322817235,0.48854272642816399]
[null,"November",0.44991463138933457,0.50550233602208716,0.3579207104557397,0.52708542362051503,0.52708542362051503,0.51592112096634724,null,null,null,0.55008536861066548,0.49449766397791284,0.6420792895442603,0.47291457637948497,0.47291457637948497,0.48407887903365276]
[null,"December",0.47748656530301725,0.52819650578125388,0.3784929227442777,0.54169246783101832,0.54169246783101832,0.53606089069154805,null,null,null,0.52251343469698275,0.47180349421874612,0.6215070772557223,0.45830753216898168,0.45830753216898168,0.46393910930845195]
[]
[]
["Table #2","% Usage During RECO On-Peak Billing Period",null,null,"On-Peak periods as defined in specified rate schedule"]
[null,null,"N/A",null,"N/A","N/A","N/A","N/A",null,null,null,"N/A",{"$f":"M1-2&\" Forecasted Billed Sales\"","v":"2020 Forecasted Billed Sales"},"N/A","N/A","N/A","N/A"]
[null,"(data rounded to nearest %)",{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},"SC2 ND","SC4","SC6","SC2 Dem",null,null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"January","----",0.32595656670113754,"----","----","----","----",null,null,null,null,{"$f":"1-D26","v":0.67404343329886252}]
[null,"February","----",0.35905680600214362,"----","----","----","----",null,null,null,null,0.64094319399785638]
[null,"March","----",0.33603912305798594,"----","----","----","----",null,null,null,null,0.663960876942014]
[null,"April","----",0.34774089442139233,"----","----","----","----",null,null,null,null,0.65225910557860767]
[null,"May","----",0.35975147030923921,"----","----","----","----",null,null,null,null,0.64024852969076074]
[null,"June","----",0.39489624951669028,"----","----","----","----",null,null,null,null,0.60510375048330967]
[null,"July","----",0.4169343227378447,"----","----","----","----",null,null,null,null,0.5830656772621553]
[null,"August","----",0.42892105024624588,"----","----","----","----",null,null,null,null,0.57107894975375406]
[null,"September","----",0.41815557337610265,"----","----","----","----",null,null,null,null,0.58184442662389735]
[null,"October","----",0.39968445963712856,"----","----","----","----",null,null,null,null,0.60031554036287149]
[null,"November","----",0.37566715186802524,"----","----","----","----",null,null,null,null,0.62433284813197476]
[null,"December","----",0.35755115297174406,"----","----","----","----",null,null,null,null,0.64244884702825589]
[]
[]
["Table #3","Class Usage @ customer",null,null,null,null,null,null,null,null,null,"Usage by season"]
[null,{"$f":"\"Calendar month billed sales forecasted for \" &M1","v":"Calendar month billed sales forecasted for 2022"}]
[null,"in MWh",{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},"SC2 ND","SC4","SC6","SC2 Dem","Total",null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"January",53238.5,34,{"$f":"'Backup Calcs'!D79","v":1624},665.5,480.5,{"$f":"'Backup Calcs'!E79","v":31301.173000000003},{"$f":"SUM(C44:H44)","v":87343.67300000001},null,"winter MWh =",{"$f":"SUM(C44:C48,C53:C55)","v":362566.5},211,11255,4619,3505.5,218005.40699999998]
[null,"February",47896,33,{"$f":"'Backup Calcs'!D80","v":1786},544.5,414,{"$f":"'Backup Calcs'!E80","v":25911.248},76584.747999999992,null,"on-peak",null,{"$f":"SUMPRODUCT(D26:D30,D44:D48)+SUMPRODUCT(D35:D37,D53:D55)","v":74.99291787534986}]
[null,"March",44101.5,29,{"$f":"'Backup Calcs'!D81","v":2145},582,377.5,{"$f":"'Backup Calcs'!E81","v":27071.0285},74306.0285,null,"off-peak",null,{"$f":"+M44-M45","v":136.00708212465014}]
[null,"April",39240.5,20,{"$f":"'Backup Calcs'!D82","v":1241},473.5,368.5,{"$f":"'Backup Calcs'!E82","v":28540.044999999998},69883.544999999998]
[null,"May",38907,23,{"$f":"'Backup Calcs'!D83","v":978},460,340,{"$f":"'Backup Calcs'!E83","v":24732.9905},65440.9905,null,"summer MWh =",{"$f":"SUM(C49:C52)","v":288272.5},{"$f":"+SUM(D49:D52)","v":119},{"$f":"+SUM(E49:E52)","v":4156},{"$f":"+SUM(F49:F52)","v":1851.5},{"$f":"+SUM(G49:G52)","v":1357.5},{"$f":"+SUM(H49:H52)","v":117584.12299999999}]
[null,"June",54168.5,27,{"$f":"'Backup Calcs'!D84","v":947},411,321,{"$f":"'Backup Calcs'!E84","v":26418.698},82293.198000000004,null,"on-peak",null,{"$f":"+SUMPRODUCT(D31:D34,D49:D52)","v":49.405630296361984}]
[null,"July",81120.5,32,{"$f":"'Backup Calcs'!D85","v":1106},440,311.5,{"$f":"'Backup Calcs'!E85","v":30114.226999999999},113124.227,null,"off-peak",null,{"$f":"+M48-M49","v":69.594369703638023}]
[null,"August",82132,29,{"$f":"'Backup Calcs'!D86","v":1097},484,325.5,{"$f":"'Backup Calcs'!E86","v":31287.1185},115354.6185]
[null,"September",70851.5,31,{"$f":"'Backup Calcs'!D87","v":1006},516.5,399.5,{"$f":"'Backup Calcs'!E87","v":29764.0795},102568.57949999999,null,"Block1",{"$f":"ROUND(L48*E156,0)","v":123871}]
[null,"October",48959.5,22,{"$f":"'Backup Calcs'!D88","v":1016},583.5,472.5,{"$f":"'Backup Calcs'!E88","v":27993.328000000001},79046.828000000009,null,"Block2",{"$f":"L48-L52","v":164401.5}]
[null,"November",41051.5,23,{"$f":"'Backup Calcs'!D89","v":975},636.5,523.5,{"$f":"'Backup Calcs'!E89","v":24926.511500000001},68136.011499999993,null,"Block3"]
[null,"December",49172,27,{"$f":"'Backup Calcs'!D90","v":1490},673.5,529,{"$f":"'Backup Calcs'!E90","v":27529.0825},79420.582500000004]
[null,"Total",{"$f":"SUM(C44:C55)","v":650839},{"$f":"SUM(D44:D55)","v":330},15411,{"$f":"SUM(F44:F55)","v":6470.5},{"$f":"SUM(G44:G55)","v":4863},335589.53,{"$f":"SUM(I44:I55)","v":1013503.0299999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of TOU Rate Adjustment to Reflect Difference between RECO and PJM Time Periods"]
[]
["Table #4","Forwards Prices - Energy Only @ bulk system",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tariff Based On-Peak"]
[null,"in $/MWh (See Table 18)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6","v":"SC3"}]
[null,null,"On-Peak","Off-Peak"]
[null,"January",{"$f":"G428","v":67.39},53.7,null,null,null,null,null,null,null,null,null,null,null,null,"winter MWh =",null,{"$f":"SUM(D44:D48,D53:D55)","v":211}]
[null,"February",63.57,50.74,null,null,null,null,null,null,null,null,null,null,null,null,"on-peak",null,{"$f":"SUMPRODUCT(D26:D30,D44:D48)+SUMPRODUCT(D35:D37,D53:D55)","v":74.99291787534986},{"$f":"S63/S62","v":0.35541667239502306}]
[null,"March",44.91,35.74,null,null,null,null,null,null,null,null,null,null,null,null,"off-peak",null,{"$f":"SUMPRODUCT(M26:M30,D44:D48)+SUMPRODUCT(M35:M37,D53:D55)","v":136.00708212465014}]
[null,"April",38.5,30.98]
[null,"May",37.97,30.39,null,null,null,null,null,null,null,null,null,null,null,null,"summer MWh =",null,{"$f":"+SUM(D49:D52)","v":119}]
[null,"June",41.35,27.63,null,null,null,null,null,null,null,null,null,null,null,null,"on-peak",null,{"$f":"+SUMPRODUCT(D31:D34,D49:D52)","v":49.405630296361984},{"$f":"S67/S66","v":0.41517336383497466}]
[null,"July",48.16,32.15,null,null,null,null,null,null,null,null,null,null,null,null,"off-peak",null,{"$f":"SUMPRODUCT(M31:M34,D49:D52)","v":69.594369703638023}]
[null,"August",45.14,30.17]
[null,"September",42.33,28.19,null,null,null,null,null,null,null,null,null,null,null,"PJM based On-Peak kWh"]
[null,"October",42.53,33.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S60","v":"SC3"}]
[null,"November",44.64,35.01]
[null,"December",49.08,38.619999999999997,null,null,null,null,null,null,null,null,null,null,null,null,"winter MWh =",null,{"$f":"SUM(D44:D48,D53:D55)","v":211}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"on-peak",null,{"$f":"SUMPRODUCT(D8:D12,D44:D48)+SUMPRODUCT(D17:D19,D53:D55)","v":103.80308127855088},{"$f":"S74/S73","v":0.49195773117796626}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"off-peak",null,{"$f":"SUMPRODUCT(M8:M12,D44:D48)+SUMPRODUCT(M17:M19,D53:D55)","v":107.19691872144912}]
["Table #5","Losses",{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"summer MWh =",null,{"$f":"+SUM(D49:D52)","v":119}]
[null,"Expansion Factor =",1.0863130817804996,1.0863130817804996,1.0863130817804996,1.0825306476101875,1.0825306476101875,1.0863130817804996,null,null,null,null,null,null,null,null,"on-peak",null,{"$f":"+SUMPRODUCT(D13:D16,D49:D52)","v":59.436333092032847},{"$f":"S78/S77","v":0.49946498396666256}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"off-peak",null,{"$f":"SUMPRODUCT(M13:M16,D49:D52)","v":59.563666907967161}]
[null,"Expansion Factor (net"]
[null,"Marginal Losses)",1.0762702514264817,1.0762702514264817,1.0734651330799554,1.0725227853931965,1.0661402195831178,1.0762702514264817]
[]
["Table #6","Summary of Average BGS Energy Only Unit Costs @ customer - PJM Time Periods",null,null,null,null,null,null,null,null,null,null,null,null,null,"Delta between PJM and Tariff based On-Peak kWh"]
[null,"based on Forwards prices corrected for basis differential & losses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S60","v":"SC3"}]
[null,"in $/MWh"]
[null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem",null,null,null,null,null,null,null,null,"Winter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On-Peak MWh",null,{"$f":"S74-S63","v":28.810163403201017}]
[null,"Summer - all hrs",{"$f":"(SUMPRODUCT(C13:C16,C49:C52,$C67:$C70)*C78+SUMPRODUCT(L13:L16,C49:C52,$D67:$D70)*C78)/SUM(C49:C52)","v":39.968715487369685},40.161607423711487,37.233484227929296,40.39699476149358,40.28981384035022,40.6853866884951,null,null,null,null,null,null,null,null,"Associated $",null,{"$f":"S87*(D93-D94)","v":313.42280190482785}]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C13:C16,C49:C52,$C67:$C70)*C78)/SUMPRODUCT(C13:C16,C49:C52)","v":48.367882267763548},48.145921567563128,48.061558129379335,47.818236506681892,47.685338480898444,48.105025800900854,null,null,null,null,null,null,null,null,"Rate Increment/MWh",null,{"$f":"ROUND(S88/S73,2)","v":1.49}]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(L13:L16,C49:C52,$D67:$D70)*C78)/SUMPRODUCT(L13:L16,C49:C52)","v":32.372374128108653},32.194361960153245,32.250490951358906,32.009623062937699,31.919566235669464,32.216183054924372]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer"]
[null,"Winter - all hrs",{"$f":"(SUMPRODUCT(C8:C12,C44:C48,$C62:$C66)*C78+SUMPRODUCT(L8:L12,C44:C48,$D62:$D66)*C78+SUMPRODUCT(C17:C19,C53:C55,$C71:$C73)*C78+SUMPRODUCT(L17:L19,C53:C55,$D71:$D73)*C78)/SUM(C44:C48,C53:C55)","v":47.619811195590451},48.94352424071127,47.194629000290853,48.07347172776258,47.915538292356992,47.831259181613547,null,null,null,null,null,null,null,null,"On-Peak MWh",null,{"$f":"S78-S67","v":10.030702795670862}]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C8:C12,C44:C48,$C62:$C66)*C78+SUMPRODUCT(C17:C19,C53:C55,$C71:$C73)*C78)/(SUMPRODUCT(C8:C12,C44:C48)+SUMPRODUCT(C17:C19,C53:C55))","v":53.497648521742278},{"$f":"(SUMPRODUCT(D8:D12,D44:D48,$C62:$C66)*D78+SUMPRODUCT(D17:D19,D53:D55,$C71:$C73)*D78)/(SUMPRODUCT(D8:D12,D44:D48)+SUMPRODUCT(D17:D19,D53:D55))","v":54.470463784643037},{"$f":"(SUMPRODUCT(E8:E12,E44:E48,$C62:$C66)*E78+SUMPRODUCT(E17:E19,E53:E55,$C71:$C73)*E78)/(SUMPRODUCT(E8:E12,E44:E48)+SUMPRODUCT(E17:E19,E53:E55))","v":54.413666770860146},{"$f":"(SUMPRODUCT(F8:F12,F44:F48,$C62:$C66)*F78+SUMPRODUCT(F17:F19,F53:F55,$C71:$C73)*F78)/(SUMPRODUCT(F8:F12,F44:F48)+SUMPRODUCT(F17:F19,F53:F55))","v":53.207623586811678},{"$f":"(SUMPRODUCT(G8:G12,G44:G48,$C62:$C66)*G78+SUMPRODUCT(G17:G19,G53:G55,$C71:$C73)*G78)/(SUMPRODUCT(G8:G12,G44:G48)+SUMPRODUCT(G17:G19,G53:G55))","v":53.050642309289067},{"$f":"(SUMPRODUCT(H8:H12,H44:H48,$C62:$C66)*H78+SUMPRODUCT(H17:H19,H53:H55,$C71:$C73)*H78)/(SUMPRODUCT(H8:H12,H44:H48)+SUMPRODUCT(H17:H19,H53:H55))","v":52.940477444904332},null,null,null,null,null,null,null,null,"Associated $",null,{"$f":"S92*(D89-D90)","v":160.00535354935673}]
[null,"PJM off pk",{"$f":"(SUMPRODUCT(L8:L12,C44:C48,$D62:$D66)*C78+SUMPRODUCT(L17:L19,C53:C55,$D71:$D73)*C78)/(SUMPRODUCT(L8:L12,C44:C48)+SUMPRODUCT(L17:L19,C53:C55))","v":42.764462307560052},43.591566726044462,43.259657998241657,42.409131521400099,42.25239028195201,42.344333393313832,null,null,null,null,null,null,null,null,"Rate Increment/MWh",null,{"$f":"ROUND(S93/S77,2)","v":1.34}]
[]
[null,"Annual",{"$f":"(C88*SUM(C49:C52)+C92*SUM(C44:C48,C53:C55))/C56","v":44.230953908998735},{"$f":"(D88*SUM(D49:D52)+D92*SUM(D44:D48,D53:D55))/D56","v":45.776711812762862},{"$f":"(E88*SUM(E49:E52)+E92*SUM(E44:E48,E53:E55))/E56","v":44.508332350239947},{"$f":"(F88*SUM(F49:F52)+F92*SUM(F44:F48,F53:F55))/F56","v":45.876887676600063},{"$f":"(G88*SUM(G49:G52)+G92*SUM(G44:G48,G53:G55))/G56","v":45.786827425896121},{"$f":"(H88*SUM(H49:H52)+H92*SUM(H44:H48,H53:H55))/H56","v":45.32748276709561}]
[]
[null,"System Total",{"$f":"SUMPRODUCT(C96:H96,C56:H56)/SUM(C56:H56)","v":44.616729381956439}]
[]
[]
["Table #7","Summary of Average BGS Energy Only Costs @ customer - PJM Time Periods"]
[null,"based on Forwards prices corrected for basis differential & losses"]
[null,"in $1000"]
[null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"Summer - all hrs",{"$f":"SUM(C49:C52)*C88/1000","v":11521.881535332779},{"$f":"SUM(D49:D52)*D88/1000","v":4.7792312834216677},{"$f":"SUM(E49:E52)*E88/1000","v":154.74236045127415},{"$f":"SUM(F49:F52)*F88/1000","v":74.795035800905353},{"$f":"SUM(G49:G52)*G88/1000","v":54.693422288275428},{"$f":"SUM(H49:H52)*H88/1000","v":4783.9555126825699}]
[null,"PJM on pk",{"$f":"SUMPRODUCT(C49:C52,C13:C16)*C89/1000","v":6621.6575780160347},{"$f":"SUMPRODUCT(D49:D52,D13:D16)*D89/1000","v":2.8616170313125702},{"$f":"SUMPRODUCT(E49:E52,E13:E16)*E89/1000","v":62.95098101559914},{"$f":"SUMPRODUCT(F49:F52,F13:F16)*F89/1000","v":46.973117231133422},{"$f":"SUMPRODUCT(G49:G52,G13:G16)*G89/1000","v":34.367486033418466},{"$f":"SUMPRODUCT(H49:H52,H13:H16)*H89/1000","v":3015.0147743109183}]
[null,"PJM off pk",{"$f":"SUMPRODUCT(C49:C52,L13:L16)*C90/1000","v":4900.2239573167444},1.9176142521090966,91.791379435674997,27.821918569771945,20.325936254856966,1768.9407383716521]
[]
[null,"Winter - all hrs",{"$f":"SUM(C44:C48,C53:C55)*C92/1000","v":17265.348275846045},{"$f":"SUM(D44:D48,D53:D55)*D92/1000","v":10.327083614790077},{"$f":"SUM(E44:E48,E53:E55)*E92/1000","v":531.17554939827357},{"$f":"SUM(F44:F48,F53:F55)*F92/1000","v":222.05136591053537},{"$f":"SUM(G44:G48,G53:G55)*G92/1000","v":167.96791948385743},{"$f":"SUM(H44:H48,H53:H55)*H92/1000","v":10427.473125210146}]
[null,"PJM on pk",{"$f":"(SUMPRODUCT(C44:C48,C8:C12)+SUMPRODUCT(C53:C55,C17:C19))*C93/1000","v":8774.333662346904},{"$f":"(SUMPRODUCT(D44:D48,D8:D12)+SUMPRODUCT(D53:D55,D17:D19))*D93/1000","v":5.654201979517663},{"$f":"(SUMPRODUCT(E44:E48,E8:E12)+SUMPRODUCT(E53:E55,E17:E19))*E93/1000","v":216.0548633042462},{"$f":"(SUMPRODUCT(F44:F48,F8:F12)+SUMPRODUCT(F53:F55,F17:F19))*F93/1000","v":128.91636187061525},{"$f":"(SUMPRODUCT(G44:G48,G8:G12)+SUMPRODUCT(G53:G55,G17:G19))*G93/1000","v":97.531537549472617},{"$f":"(SUMPRODUCT(H44:H48,H8:H12)+SUMPRODUCT(H53:H55,H17:H19))*H93/1000","v":5976.3545100863503}]
[null,"PJM off pk",{"$f":"+(SUMPRODUCT(C44:C48,L8:L12)+SUMPRODUCT(C53:C55,L17:L19))*C94/1000","v":8491.0146134991428},4.6728816352724145,315.12068609402741,93.135004039920105,70.436381934384798,4451.118615123798]
[]
[null,"Annual",{"$f":"+C106+C110","v":28787.229811178826},{"$f":"+D106+D110","v":15.106314898211744},685.91790984954775,296.84640171144071,222.66134177213286,15211.428637892717]
[]
[null,"System Total",{"$f":"SUM(C114:H114)","v":45219.190417302874}]
[]
[]
["Table #8","Summary of Average BGS Energy Only Unit Costs @ customer - RECO Time Periods"]
[null,"based on Forwards prices corrected for basis differential & losses - RECO billing time periods in $/MWh"]
[]
[null,null,{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"Summer - all hrs",{"$f":"+C106/SUM(C49:C52)*1000","v":39.968715487369685},{"$f":"+D106/SUM(D49:D52)*1000","v":40.161607423711494},{"$f":"+E106/SUM(E49:E52)*1000","v":37.233484227929296},{"$f":"+F106/SUM(F49:F52)*1000","v":40.396994761493573},{"$f":"+G106/SUM(G49:G52)*1000","v":40.28981384035022},{"$f":"+H106/SUM(H49:H52)*1000","v":40.6853866884951}]
[null,"RECO On pk",null,{"$f":"D89+S94","v":49.485921567563132}]
[null,"RECO Off pk",null,{"$f":"D90+S94","v":33.534361960153248}]
[]
[null,"Winter - all hrs",{"$f":"+C110/SUM(C44:C48,C53:C55)*1000","v":47.619811195590451},{"$f":"+D110/SUM(D44:D48,D53:D55)*1000","v":48.943524240711263},{"$f":"+E110/SUM(E44:E48,E53:E55)*1000","v":47.194629000290853},{"$f":"+F110/SUM(F44:F48,F53:F55)*1000","v":48.07347172776258},{"$f":"+G110/SUM(G44:G48,G53:G55)*1000","v":47.915538292356992},{"$f":"+H110/SUM(H44:H48,H53:H55)*1000","v":47.831259181613547}]
[null,"RECO On pk",null,{"$f":"D93+S89","v":55.960463784643039}]
[null,"RECO Off pk",null,{"$f":"D94+S89","v":45.081566726044464}]
[]
[null,"Annual Average",{"$f":"(C124*SUM(C49:C52)+C128*SUM(C44:C48,C53:C55))/C56","v":44.230953908998735},{"$f":"(D124*SUM(D49:D52)+D128*SUM(D44:D48,D53:D55))/D56","v":45.776711812762862},{"$f":"(E124*SUM(E49:E52)+E128*SUM(E44:E48,E53:E55))/E56","v":44.508332350239947},{"$f":"(F124*SUM(F49:F52)+F128*SUM(F44:F48,F53:F55))/F56","v":45.876887676600063},{"$f":"(G124*SUM(G49:G52)+G128*SUM(G44:G48,G53:G55))/G56","v":45.786827425896121},{"$f":"(H124*SUM(H49:H52)+H128*SUM(H44:H48,H53:H55))/H56","v":45.32748276709561},null,null,null,42644]
[null,"System Average",{"$f":"+C116/SUM(C56:H56)*1000","v":44.616729381956432},null,null,null,null,null,null,null,null,{"$f":"L136-L132","v":2434}]
[]
["Table #9","Generation & Transmission Obligations and Costs and Other Adjustments"]
[null,{"$f":"\"Obligations - annual average forecasted for \" &M1-1 &\"; costs are market estimates\"","v":"Obligations - annual average forecasted for 2021; costs are market estimates"},null,null,null,null,null,null,null,null,null,{"$f":"(DATE($M$1+1,6,1))","v":"2023-06-01"}]
[null,"in MW",{"$f":"+C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem","Total FP",null,null,{"$f":"(DATE($M$1,10,1))","v":"2022-10-01"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L136-L137","v":243}]
[null,"Gen Obl - MW",295.74799999999999,0.114,2.6960000000000002,0,0,79.956999999999994,{"$f":"SUM(C139:H139)","v":378.51499999999999},true]
[]
[null,"Trans Obl - MW",311.19900000000001,0.11700000000000001,2.9329999999999998,0,0,86.182000000000002,{"$f":"SUM(C141:H141)","v":400.43100000000004},true]
[]
[null,"# of Months and Days used in this analysis"]
[null,null,null,"# of summer days =",{"$f":"(DATE($M$1,10,1))-(DATE($M$1,6,1))","v":122},null,"# of summer months =",4]
[null,null,null,"# of winter days =",{"$f":"(DATE($M$1+1,6,1))-(DATE($M$1,10,1))","v":243},null,"# of winter months =",8]
[null,null,null,null,null,null,"total # months =",{"$f":"+H144+H145","v":12}]
[null,"Transmission Cost*",42548,"per MW-yr",{"$f":"C147/SUM(E144:E145)","v":116.56986301369864}]
[]
[null,"Generation Capacity cost","summer",{"$f":"F449","v":110.02},"$/MW/day",null,"Resulting avg gen cap cost = ","summer >>",{"$f":"+D149*365/1000","v":40.157299999999992},"per kW/yr"]
[null,"(see Table 19)","winter",{"$f":"F451","v":94.7},"$/MW/day",null,null,"winter  >>",{"$f":"+D150*365/1000","v":34.5655},"per kW/yr"]
[]
[null,"Current residential summer BGS charges"]
[null,"Current Tariff and % of total summer usage"]
[null,null,{"$f":"\" ---------- \"&C6&\" ----------\"","v":" ---------- SC1 ----------"}]
[null,null,"Charges",null,"% usage"]
[null,"Block 1 (0-600 kWh/month)",5.407,"¢/kWh",{"$f":"'Backup Calcs'!H104","v":0.42970000000000003}]
[null,"Block 2 (>600 kWh/m)",10.038,"¢/kWh",{"$f":"'Backup Calcs'!H105","v":0.57030000000000003}]
[null,"Calculated inversion =",{"$f":"+C157-C156","v":4.6310000000000002},"¢/kWh"]
[]
["Table #10","Ancillary Services"]
[null,"forecasted overall annual average",null,{"$f":"H461","v":18.059999999999999},"/MWh"]
[]
["Table #11","Summary of Obligation Costs Expressed as $/MWh @ customer (for non-demand rates only)"]
[]
[null,null,{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},{"$f":"+E6","v":"SC2 ND"},{"$f":"+F6","v":"SC4"},{"$f":"+G6","v":"SC6"}]
[]
[null,"Transmission Obl - all months",{"$f":"(+$C$147*C141*$H$146/12)/C56","v":20.344347914000238},{"$f":"(+$C$147*D141*$H$146/12)/D56","v":15.0852},{"$f":"(+$C$147*E141*$H$146/12)/E56","v":8.0976759457530338},{"$f":"(+$C$147*F141*$H$146/12)/F56","v":0},{"$f":"(+$C$147*G141*$H$146/12)/G56","v":0}]
[]
[null,"Generation Obl -                "]
[null,"per annual MWh",{"$f":"((+$D$149*$E$144*C139)+($D$150*$E$145*C139))/C56","v":16.556233317179824},{"$f":"((+$D$149*$E$144*D139)+($D$150*$E$145*D139))/D56","v":12.586477454545456},{"$f":"((+$D$149*$E$144*E139)+($D$150*$E$145*E139))/E56","v":6.3738576237752271},{"$f":"((+$D$149*$E$144*F139)+($D$150*$E$145*F139))/F56","v":0},{"$f":"((+$D$149*$E$144*G139)+($D$150*$E$145*G139))/G56","v":0}]
[null,"per summer MWh",{"$f":"C$139*$D149*$E144/SUM(C$49:C$52)","v":13.770511530305527},{"$f":"D$139*$D149*$E144/SUM(D$49:D$52)","v":12.858471932773108},{"$f":"E$139*$D149*$E144/SUM(E$49:E$52)","v":8.7071458710298373},{"$f":"F$139*$D149*$E144/SUM(F$49:F$52)","v":0},{"$f":"G$139*$D149*$E144/SUM(G$49:G$52)","v":0}]
[null,"per winter MWh",{"$f":"C$139*$D150*$E145/(SUM(C$44:C$48)+SUM(C$53:C$55))","v":18.77112902267584},{"$f":"D$139*$D150*$E145/(SUM(D$44:D$48)+SUM(D$53:D$55))","v":12.433077725118482},{"$f":"E$139*$D150*$E145/(SUM(E$44:E$48)+SUM(E$53:E$55))","v":5.5122720213238567},{"$f":"F$139*$D150*$E145/(SUM(F$44:F$48)+SUM(F$53:F$55))","v":0},{"$f":"G$139*$D150*$E145/(SUM(G$44:G$48)+SUM(G$53:G$55))","v":0}]
[]
[]
["Table #12","Summary of BGS Unit Costs @ customer"]
[]
[null,"NON-DEMAND RATES (includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods in $/MWh)"]
[]
[null,null,{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},{"$f":"+E6","v":"SC2 ND"},{"$f":"+F6","v":"SC4"},{"$f":"+G6","v":"SC6"}]
[]
[null,"Summer - all hrs",{"$f":"+C124+$D$161+C$167+C171","v":92.143574931675445},{"$f":"+D124+$D$161+D$167+D171","v":86.165279356484604},{"$f":"+E124+$D$161+E$167+E171","v":72.09830604471216},{"$f":"+F124+$D$161+F$167+F171","v":58.456994761493576},{"$f":"+G124+$D$161+G$167+G171","v":58.349813840350222}]
[null,"RECO On pk",null,{"$f":"+D125+$D$161+D$167+(D171*M48/M49)","v":113.60245319153543}]
[null,"RECO Off pk",null,{"$f":"+D126+$D$161+D$167","v":66.679561960153251}]
[null,"Block 1",{"$f":"(C181*SUM(C49:C52)-C158*10*E157*SUM(C49:C52))/SUM(C49:C52)","v":65.73298193167544}]
[null,"Block 2",{"$f":"C184+C158*10","v":112.04298193167544}]
[]
[]
[null,"Winter - all hrs",{"$f":"+C128+$D$161+C$167+C172","v":104.79528813226652},{"$f":"+D128+$D$161+D$167+D172","v":94.521801965829738},{"$f":"+E128+$D$161+E$167+E172","v":78.864576967367739},{"$f":"+F128+$D$161+F$167+F172","v":66.133471727762583},{"$f":"+G128+$D$161+G$167+G172","v":65.975538292356987}]
[null,"RECO On pk",null,{"$f":"+D129+$D$161+D$167+(D172*M44/M45)","v":124.08735904766073}]
[null,"RECO Off pk",null,{"$f":"+D130+$D$161+D$167","v":78.22676672604446}]
[]
[null,"Annual -all hrs",{"$f":"+C132+$D$161+C$167+C170","v":99.191535140178786},{"$f":"+D132+$D$161+D$167+D170","v":91.508389267308317},{"$f":"+E132+$D$161+E$167+E170","v":77.039865919768204},{"$f":"+F132+$D$161+F$167+F170","v":63.936887676600065},{"$f":"+G132+$D$161+G$167+G170","v":63.846827425896123}]
[]
[null,"DEMAND RATES (includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods in $/MWh)"]
[]
[null,null,{"$f":"+H6","v":"SC2 Dem"},null,null,"PLUS:"]
[]
[null,"Summer - all hrs",{"$f":"+H124+$D$161","v":58.745386688495103},null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[]
[null,null,null,null,null,null,null,"< 5 kW","> 5 kW"]
[]
[null,"Winter - all hrs",{"$f":"+H128+$D$161","v":65.891259181613549},null,null,"summer",null,{"$f":"H213","v":0.80100000000000005},{"$f":"I213","v":2.952}]
[null,null,null,null,null,"winter",null,{"$f":"H214","v":1.034},{"$f":"I214","v":2.6819999999999999}]
[]
[null,null,null,null,null,"Trans cost"]
[null,"Annual - all hrs per MWh only",{"$f":"+H132+$D$161","v":63.387482767095605},null,null,"all months",{"$f":"+C147/1000/12","v":3.545666666666667},"per kW of T obl /month"]
["Table #12","(Continued)",null,null,null,null,null,null,null,null,"PLUS:"]
[]
[null,"Including T&G Obligation $",null,null,null,"Gen Cost (per kW of Billed Demand/Month)",null,null,null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[null,"Summer - all hrs",{"$f":"(C198*Q48+($H213*($M$223/4*H144))+($I213*($M$223/4*H144))+($G206*$H144*H141*1000))/Q48","v":80.098203151249251},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$ / kW",null,null,null,null,null,"Round",3]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H6","v":"SC2 Dem"},"1st 5 kW","> 5 kW",null,"Summer Revenue","1st 5 kW","> 5 kW","Total kW","< 5 kW Charge","> 5 kW Charge","Differential","Reduce Differential By:",0.33]
[null,null,null,null,null,null,null,"< 5 kW","> 5 kW"]
[null,null,null,null,null,"summer",null,{"$f":"M213","v":0.80100000000000005},{"$f":"N213","v":2.952},null,"summer",{"$f":"ROUND(H139*D149*E144/$M$223,3)","v":3.1259999999999999},{"$f":"ROUND((P213-V213*(1-$X$211)*R213)/S213,$AA$210)","v":0.80100000000000005},{"$f":"ROUND(M213+V213*(1-$X$211),$AA$210)","v":2.952},null,{"$f":"H139*D149*E144","v":1073218.0350799998},{"$f":"$M$229","v":74540.737107316367},{"$f":"$M$223","v":343315.11289268365},{"$f":"Q213+R213","v":417855.85000000003},1.96,5.17,{"$f":"U213-T213","v":3.21},null,null,null,{"$f":"M213*Q213+N213*R213","v":1073173.3436821625},{"$f":"P213-Z213","v":44.691397837363183}]
[null,"Winter - all hrs",{"$f":"(C202*Q44+($H214*($M$224/8*H145))+($I214*($M$224/8*H145))+($G206*$H145*H141*1000))/Q44","v":87.730048291855525},null,null,"winter",null,{"$f":"M214","v":1.034},{"$f":"N214","v":2.6819999999999999},null,"winter",{"$f":"ROUND(H139*D150*E145/$M$224,3)","v":2.952},{"$f":"ROUND((P214-V214*(1-$X$211)*R214)/S214,$AA$210)","v":1.034},{"$f":"ROUND(M214+V214*(1-$X$211),$AA$210)","v":2.6819999999999999},null,{"$f":"H139*D150*E145","v":1839978.4797},{"$f":"$M$230","v":162294.29697735884},{"$f":"$M$224","v":623356.55302264099},{"$f":"Q214+R214","v":785650.84999999986},2.3199999999999998,4.78,{"$f":"U214-T214","v":2.4600000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,"Trans cost"]
[null,null,null,null,null,null,null,null,null,null,"all months",{"$f":"+C147/1000/12","v":3.545666666666667},"per kW of T obl /month",null,null,{"$f":"P213+P214","v":2913196.5147799999}]
[null,"Annual - including T&G Obl $",{"$f":"(C206*H56+($H213*($M$229/4*H144)+$H214*($M$230/8*H145)+$I213*($M$223/4*H144)+$I214*($M$224/8*H145))+($G206*$H146*H141*1000))/H56","v":82.993874116561955}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C192:G192,C56:G56)+SUMPRODUCT(C218,H56))/1000","v":94351.244642386344},null,null,null,null,null,null,null,null,"SC2 Sales and Demands"]
[null,null,"All-In Average cost @ customer =",{"$f":"+C221/SUM(C56:H56)*1000","v":93.094190988640989},"per MWh at customer (per customer metered MWh)",null,null,null,null,null,null,null,"Over 5 kW"]
[null,null,"All-In Average costs @ transmission nodes =",{"$f":"+C221/SUMPRODUCT(C56:H56,C81:H81)*1000","v":86.506298082509588},"per MWH at transmission nodes (per metered MWh at transmission node)",null,null,null,null,null,null,"Summer",{"$f":"'Backup Calcs'!$I$95","v":343315.11289268365}]
[null,null,null,null,null,null,null,null,null,null,null,"Winter",{"$f":"'Backup Calcs'!$I$96","v":623356.55302264099}]
[]
["Table #13","Ratio of BGS Unit Costs @ customer to All-In Average Cost @ transmission nodes"]
[null,null,null,null,null,null,null,null,null,null,null,"SC2 Sales and Demands"]
[null,"NON-DEMAND RATES",null,null,null,null,null,null,null,null,null,null,"First 5 kW"]
[null,"Includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods",null,null,null,null,null,null,null,null,null,"Summer",{"$f":"'Backup Calcs'!$H$95","v":74540.737107316367}]
[null,null,null,null,null,null,null,null,null,null,null,"Winter",{"$f":"'Backup Calcs'!$H$96","v":162294.29697735884}]
[null,null,{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},{"$f":"+E6","v":"SC2 ND"},{"$f":"+F6","v":"SC4"},{"$f":"+G6","v":"SC6"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(+C181/$D$223,3)","v":1.0649999999999999},null,{"$f":"ROUND(+E181/$D$223,3)","v":0.83299999999999996},{"$f":"ROUND(+F181/$D$223,3)","v":0.67600000000000005},{"$f":"ROUND(+G181/$D$223,3)","v":0.67500000000000004}]
[null,"RECO On pk",null,{"$f":"ROUND(+D182/$D$223,3)","v":1.3129999999999999}]
[null,"RECO Off pk",null,{"$f":"ROUND(+D183/$D$223,3)","v":0.77100000000000002}]
[]
[]
[null,"Constant Blk 1",{"$f":"C184-C181","v":-26.410593000000006}]
[null,"Constant Blk 2",{"$f":"C185-C181","v":19.899406999999997}]
[]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C188/$D$223,3)","v":1.2110000000000001},null,{"$f":"ROUND(+E188/$D$223,3)","v":0.91200000000000003},{"$f":"ROUND(+F188/$D$223,3)","v":0.76400000000000001},{"$f":"ROUND(+G188/$D$223,3)","v":0.76300000000000001}]
[null,"RECO On pk",null,{"$f":"ROUND(+D189/$D$223,3)","v":1.4339999999999999}]
[null,"RECO Off pk",null,{"$f":"ROUND(+D190/$D$223,3)","v":0.90400000000000003}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C192/$D$223,3)","v":1.147},{"$f":"ROUND(+D192/$D$223,3)","v":1.0580000000000001},{"$f":"ROUND(+E192/$D$223,3)","v":0.89100000000000001},{"$f":"ROUND(+F192/$D$223,3)","v":0.73899999999999999},{"$f":"ROUND(+G192/$D$223,3)","v":0.73799999999999999}]
[]
["Table #13","(Continued)"]
[]
[null,"DEMAND RATES"]
[null,"Includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+H6","v":"SC2 Dem"},{"$f":"+C253","v":"SC2 Dem"},null,null,"PLUS:"]
[null,null,"Multiplier","Constant"]
[null,"Summer - all hrs",{"$f":"ROUND(+C210/$D$223,3)","v":0.92600000000000005},{"$f":"+C198-C210","v":-21.352816462754149},null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[]
[null,null,null,null,null,null,null,null,"< 5 kW","> 5 kW"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C214/$D$223,3)","v":1.014},{"$f":"+C202-C214","v":-21.838789110241976},null,null,"summer",null,{"$f":"M213","v":0.80100000000000005},{"$f":"N213","v":2.952}]
[null,null,null,null,null,null,"winter",null,{"$f":"M214","v":1.034},{"$f":"N214","v":2.6819999999999999}]
[]
[null,null,null,null,null,null,"Trans cost"]
[null,"Annual - including T&G Obl $",{"$f":"ROUND(+C218/$D$223,3)","v":0.95899999999999996},null,null,null,"all months",{"$f":"+G206","v":3.545666666666667},"per kW of T obl /month"]
[]
[]
["Table #14","Summary of BGS Unit Costs Less Transmission @ customer"]
[]
[null,"NON-DEMAND RATES"]
[null,"Includes energy, generation capacity obligation, and Ancillary Services - adjusted to billing time periods.  Transmission billed at retail tariff level."]
[null,"in $/MWh"]
[null,null,{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},{"$f":"+E6","v":"SC2 ND"},{"$f":"+F6","v":"SC4"},{"$f":"+G6","v":"SC6"}]
[]
[null,"Summer - all hrs",{"$f":"C181-C$167","v":71.799227017675207},{"$f":"D181-D$167","v":71.080079356484603},{"$f":"E181-E$167","v":64.000630098959121},{"$f":"F181-F$167","v":58.456994761493576},{"$f":"G181-G$167","v":58.349813840350222}]
[null,"RECO On pk",null,{"$f":"D182-D$167","v":98.517253191535431}]
[null,"RECO Off pk",null,{"$f":"D183-D$167","v":51.59436196015325}]
[null,"Block 1",{"$f":"(C273*SUM(C49:C52)-C158*10*E157*SUM(C49:C52))/SUM(C49:C52)","v":45.388634017675209}]
[null,"Block 2",{"$f":"C276+C158*10","v":91.698634017675204}]
[]
[]
[null,"Winter - all hrs",{"$f":"C188-C$167","v":84.450940218266282},{"$f":"D188-D$167","v":79.436601965829738},{"$f":"E188-E$167","v":70.7669010216147},{"$f":"F188-F$167","v":66.133471727762583},{"$f":"G188-G$167","v":65.975538292356987}]
[null,"RECO On pk",null,{"$f":"D189-D$167","v":109.00215904766073}]
[null,"RECO Off pk",null,{"$f":"D190-D$167","v":63.141566726044459}]
[]
[null,"Annual -all hrs",{"$f":"C192-C$167","v":78.847187226178548},{"$f":"D192-D$167","v":76.423189267308317},{"$f":"E192-E$167","v":68.942189974015164},{"$f":"F192-F$167","v":63.936887676600065},{"$f":"G192-G$167","v":63.846827425896123}]
[]
["Table #14","(Continued)"]
[]
[null,"DEMAND RATES"]
[null,"Includes energy and Ancillary Services, generation obligation charged separately - adjusted to billing time periods."]
[null,"Transmission billed at retail tariff level.  In $/MWh."]
[]
[null,null,{"$f":"+H6","v":"SC2 Dem"},null,null,null,"PLUS:"]
[]
[null,"Summer - all hrs",{"$f":"C198","v":58.745386688495103},null,null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I257","v":"< 5 kW"},"> 5 kW"]
[]
[null,"Winter - all hrs",{"$f":"C202","v":65.891259181613549},null,null,null,"summer",null,{"$f":"I259","v":0.80100000000000005},2.952]
[null,null,null,null,null,null,"winter",null,1.034,2.6819999999999999]
[]
[]
[null,"Annual - all hrs per MWh only",{"$f":"C206","v":63.387482767095605}]
[null,null,null,null,null,null,null,null,null,null,"SC2 Sales and Demands"]
[null,"Including Generation Obligation $",null,null,null,null,null,null,null,null,null,"Over 5 kW"]
[null,"Summer - all hrs",{"$f":"(C294*Q48+($I298*($L$305/4*H144))+($J298*($L$305/4*H144)))/Q48","v":69.703172364085347},null,null,null,null,null,null,null,"Summer",{"$f":"'Backup Calcs'!$I$95","v":343315.11289268365}]
[null,null,null,null,null,null,null,null,null,null,"Winter",{"$f":"'Backup Calcs'!$I$96","v":623356.55302264099}]
[]
[]
[null,"Winter - all hrs",{"$f":"(C298*Q44+($I299*($L$306/8*H145))+($J299*($L$306/8*H145)))/Q44","v":76.516651381322305}]
[]
[]
[]
[null,"Annual - including T&G Obl $",{"$f":"(C302*H56+($I298*($L$305/4*H144)+($J298*($L$305/4*H144))+($I299*($L$306/8*H145))+($J299*($L$306/8*H145))))/H56","v":74.129339253853033}]
[]
[null,"ALL RATES"]
[null,"Grand Total Cost in $1000 =",{"$f":"(+SUMPRODUCT(C284:G284,C56:G56)+SUMPRODUCT(C313,H56))/1000","v":78005.733102141239}]
[null,null,"All-In Average cost @ customer =",{"$f":"+C316/SUM(C56:H56)*1000","v":76.966452781242538},"per MWh at customer (per customer metered MWh)"]
[null,null,"All-In Average costs @ tansmission nodes =",{"$f":"+C316/SUMPRODUCT(C56:H56,C81:H81)*1000","v":71.519853558424074},"per MWh at tranmission node system (per metered MWh at transmission node)"]
[]
["Table #15","Ratio of BGS Unit Costs Less Transmission @ customer to All-In Average Cost @ transmission nodes"]
[]
[null,"NON-DEMAND RATES"]
[null,"Includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"+C6","v":"SC1"},{"$f":"+D6","v":"SC3"},{"$f":"+E6","v":"SC2 ND"},{"$f":"+F6","v":"SC4"},{"$f":"+G6","v":"SC6"}]
[]
[null,"Summer - all hrs",{"$f":"ROUND(+C273/$D$318,3)","v":1.004},null,{"$f":"ROUND(+E273/$D$318,3)","v":0.89500000000000002},{"$f":"ROUND(+F273/$D$318,3)","v":0.81699999999999995},{"$f":"ROUND(+G273/$D$318,3)","v":0.81599999999999995}]
[null,"RECO On pk",null,{"$f":"ROUND(+D274/$D$318,3)","v":1.377}]
[null,"RECO Off pk",null,{"$f":"ROUND(+D275/$D$318,3)","v":0.72099999999999997}]
[]
[]
[null,"Constant Blk 1",{"$f":"C276-C273","v":-26.410592999999999}]
[null,"Constant Blk 2",{"$f":"C277-C273","v":19.899406999999997}]
[]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C280/$D$318,3)","v":1.181},null,{"$f":"ROUND(+E280/$D$318,3)","v":0.98899999999999999},{"$f":"ROUND(+F280/$D$318,3)","v":0.92500000000000004},{"$f":"ROUND(+G280/$D$318,3)","v":0.92200000000000004}]
[null,"RECO On pk",null,{"$f":"ROUND(+D281/$D$318,3)","v":1.524}]
[null,"RECO Off pk",null,{"$f":"ROUND(+D282/$D$318,3)","v":0.88300000000000001}]
[]
[null,"Annual - all hrs",{"$f":"ROUND(+C284/$D$318,3)","v":1.1020000000000001},{"$f":"ROUND(+D284/$D$318,3)","v":1.069},{"$f":"ROUND(,3)+E284/$D$318","v":0.96395876870324915},{"$f":"ROUND(+F284/$D$318,3)","v":0.89400000000000002},{"$f":"ROUND(+G284/$D$318,3)","v":0.89300000000000002}]
[]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"+H6","v":"SC2 Dem"},{"$f":"+C346","v":"SC2 Dem"},null,null,"PLUS:"]
[null,null,"Multiplier","Constant"]
[null,"Summer - all hrs",{"$f":"ROUND(+C305/$D$318,3)","v":0.97499999999999998},{"$f":"C294-C305","v":-10.957785675590245},null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I296","v":"< 5 kW"},"> 5 kW"]
[]
[null,"Winter - all hrs",{"$f":"ROUND(+C309/$D$318,3)","v":1.07},{"$f":"C298-C309","v":-10.625392199708756},null,null,"summer",null,{"$f":"I298","v":0.80100000000000005},2.952]
[null,null,null,null,null,null,"winter",null,1.034,2.6819999999999999]
[]
[]
[null,"Annual - including T&G Obl $",{"$f":"ROUND(+C313/$D$318,3)","v":1.036}]
[]
[]
["Table #16","Summary of Total BGS Costs by Season"]
[]
[null,null,{"$f":"C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[null,"Total Costs by Rate - in $1000"]
[null,"Summer",{"$f":"(C184*SUM(C49:C52)*E156+C185*SUM(C49:C52)*E157)/1000","v":26562.458704491415},{"$f":"+D181*SUM(D49:D52)/1000","v":10.253668243421668},{"$f":"+E181*SUM(E49:E52)/1000","v":299.64055992182375},{"$f":"+F181*SUM(F49:F52)/1000","v":108.23312580090536},{"$f":"+G181*SUM(G49:G52)/1000","v":79.20987228827542},{"$f":"(C198*SUM(H49:H52)/1000)+($H202*('Backup Calcs'!H95/4*H144)/1000)+($I202*('Backup Calcs'!I95/4*H144)/1000)+($G206*$H144*H141)","v":9202.9886964113994}]
[null,"Winter",{"$f":"+C188*SUM(C44:C48,C53:C55)/1000","v":37995.260834607405},{"$f":"+D188*SUM(D44:D48,D53:D55)/1000","v":19.944100214790076},{"$f":"+E188*SUM(E44:E48,E53:E55)/1000","v":887.6208137677238},{"$f":"+F188*SUM(F44:F48,F53:F55)/1000","v":305.47050591053534},{"$f":"+G188*SUM(G44:G48,G53:G55)/1000","v":231.27724948385742},{"$f":"(C202*SUM(H44:H48,H53:H55)/1000)+($H203*('Backup Calcs'!H96/8*H145)/1000)+($I203*('Backup Calcs'!I96/8*H145)/1000)+($G206*$H145*H141)","v":18648.886511244793}]
[null,"Total",{"$f":"+C364+C363","v":64557.71953909882},{"$f":"+D364+D363","v":30.197768458211744},1187.2613736895476,413.70363171144072,310.48712177213281,27851.875207656194]
[]
[null,"% of Annual Total $ by Rate"]
[null,"Summer",{"$f":"+C363/C365","v":0.41145286565465022},0.33955052862965329,0.25237960786230013,0.26161995569910351,0.25511483966284348,0.33042617876880304]
[null,"Winter",{"$f":"+C364/C365","v":0.58854713434534978},0.66044947137034671,0.74762039213769993,0.73838004430089643,0.74488516033715657,0.66957382123119691]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C363:H363)","v":36262.784627157242}]
[null,"Winter",{"$f":"+SUM(C364:H364)","v":58088.460015229095}]
[null,"Total",{"$f":"+C373+C372","v":94351.244642386329}]
[]
[null,"% of Annual Total $",null,"         If total $ were split on a per MWh basis (on transmission node MWhs):",null,null,null,null,"Ratio to All-In Cost"]
[null,"Summer",{"$f":"+C372/C374","v":0.38433816919534897},null,{"$f":"+C372/SUMPRODUCT(L48:Q48,C81:H81)*1000","v":81.519837445071531},"per MWh @ transmission nodes",null,null,"Summer",{"$f":"ROUND(E377/$D$223,4)","v":0.94240000000000002}]
[null,"Winter",{"$f":"+C373/C374","v":0.61566183080465109},null,{"$f":"+C373/SUMPRODUCT(L44:Q44,C81:H81)*1000","v":89.940745410766212},"per MWh @ transmission nodes",null,null,"Winter",{"$f":"ROUND(E378/$D$223,4)","v":1.0397000000000001}]
[]
[]
["Table #17","Summary of Total BGS Costs by Season - Less Transmission"]
[null,null,null,null,null,null,null,null,null,null,"SC2 Sales and Demands"]
[null,null,{"$f":"C6","v":"SC1"},"SC3","SC2 ND","SC4","SC6","SC2 Dem",null,null,null,"First 5 kW"]
[null,"Total Costs by Rate - in $1000",null,null,null,null,null,null,null,null,"Summer",{"$f":"'Backup Calcs'!$H$95","v":74540.737107316367},null,8429.1397260492577]
[null,"Summer",{"$f":"(C276*SUM(C49:C52)*E156+C277*SUM(C49:C52)*E157)/1000","v":20697.742670452775},{"$f":"+D273*SUM(D49:D52)/1000","v":8.4585294434216678},{"$f":"+E273*SUM(E49:E52)/1000","v":265.98661869127409},{"$f":"+F273*SUM(F49:F52)/1000","v":108.23312580090536},{"$f":"+G273*SUM(G49:G52)/1000","v":79.20987228827542},{"$f":"(C294*SUM(H49:H52)/1000)+($I298*($L$384/4*H144)/1000)+($J298*($L$389/4*H144)/1000)","v":7980.6981177447324},null,null,"Winter",{"$f":"'Backup Calcs'!$H$96","v":162294.29697735884},null,15486.148409442889]
[null,"Winter",{"$f":"+C280*SUM(C44:C48,C53:C55)/1000","v":30619.081816646045},{"$f":"+D280*SUM(D44:D48,D53:D55)/1000","v":16.761123014790076},{"$f":"+E280*SUM(E44:E48,E53:E55)/1000","v":796.48147099827349},{"$f":"+F280*SUM(F44:F48,F53:F55)/1000","v":305.47050591053534},{"$f":"+G280*SUM(G44:G48,G53:G55)/1000","v":231.27724948385742},{"$f":"(C298*SUM(H44:H48,H53:H55)/1000)+($I299*($L$385/8*H145)/1000)+($J299*($L$390/8*H145)/1000)","v":16204.305353911459},null,null,null,null,null,23915.288135492148]
[null,"Total",{"$f":"+C386+C385","v":51316.82448709882},25.219652458211744,1062.4680896895475,413.70363171144072,310.48712177213281,24185.003471656193,null,null,"SC2 Sales and Demands"]
[null,null,null,null,null,null,null,null,null,null,null,"Over 5 kW"]
[null,"% of Annual Total $ by Rate",null,null,null,null,null,null,null,null,"Summer",{"$f":"'Backup Calcs'!$I$95","v":343315.11289268365}]
[null,"Summer",{"$f":"+C385/C387","v":0.40333249138703509},0.33539436982477111,0.25034786575942741,0.26161995569910351,0.25511483966284348,0.32998540302455509,null,null,"Winter",{"$f":"'Backup Calcs'!$I$96","v":623356.55302264099}]
[null,"Winter",{"$f":"+C386/C387","v":0.59666750861296491},0.66460563017522889,0.74965213424057275,0.73838004430089643,0.74488516033715657,0.67001459697544485]
[]
[null,"Total Costs - in $1000"]
[null,"Summer",{"$f":"+SUM(C385:H385)","v":29140.328934421384}]
[null,"Winter",{"$f":"+SUM(C386:H386)","v":48173.377519964961}]
[null,"Total",{"$f":"+C395+C394","v":77313.706454386353}]
[]
[null,"% of Annual Total $",null,"         If total $ were split on a per MWh basis (on transmission node MWhs):",null,null,null,null,"Ratio to All-In Cost"]
[null,"Summer",{"$f":"+C394/C396","v":0.37691025654828275},null,{"$f":"+C394/SUMPRODUCT(L48:Q48,C81:H81)*1000","v":65.508341465065541},"per MWh @ transmission nodes",null,null,"Summer",{"$f":"ROUND(E399/$D$318,4)","v":0.91590000000000005}]
[null,"Winter",{"$f":"+C395/C396","v":0.62308974345171719},null,{"$f":"+C395/SUMPRODUCT(L44:Q44,C81:H81)*1000","v":74.588816469983485},"per MWh @ transmission nodes",null,null,"Winter",{"$f":"ROUND(E400/$D$318,4)","v":1.0428999999999999}]
[]
[]
["Table #18","Forward Energy Prices"]
[]
[null,null,null,null,null,"Zone to Western Hub",null,null,"PJM Forward Prices"]
[null,"PJM Forward Prices - Energy Only @ bulk system",null,null,null,"Basis Differential",null,null,"(incl basis differential)"]
[null,"in $/MWh",null,"Off/On Peak",null,"in $/MWh",null,null," in $/MWh"]
[null,null,"On-Peak","LMP ratio","Off-Peak","On-Peak","Off-Peak",null,"On-Peak","Off-Peak"]
[null,"January",67.2,0.77170000000000005,{"$f":"ROUND(C409*D409,2)","v":51.86},0.94,0.96,null,{"$f":"ROUND(C409*F409,2)","v":63.17},{"$f":"ROUND(E409*G409,2)","v":49.79}]
[null,"February",63,{"$f":"D409","v":0.77170000000000005},{"$f":"ROUND(C410*D410,2)","v":48.62},{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,59.22,46.68]
[null,"March",45.2,{"$f":"D409","v":0.77170000000000005},{"$f":"ROUND(C411*D411,2)","v":34.880000000000003},{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,42.49,33.479999999999997]
[null,"April",40.799999999999997,{"$f":"D409","v":0.77170000000000005},31.49,{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,38.35,30.23]
[null,"May",40.9,{"$f":"D409","v":0.77170000000000005},31.56,{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,38.450000000000003,30.3]
[null,"June",44.35,0.66839999999999999,29.64,0.93,0.91,null,41.25,26.97]
[null,"July",50.8,{"$f":"D414","v":0.66839999999999999},33.950000000000003,{"$f":"F414","v":0.93},{"$f":"G414","v":0.91},null,47.24,30.89]
[null,"August",47.55,{"$f":"D414","v":0.66839999999999999},31.78,{"$f":"F414","v":0.93},{"$f":"G414","v":0.91},null,44.22,28.92]
[null,"September",45.45,{"$f":"D414","v":0.66839999999999999},30.38,{"$f":"F414","v":0.93},{"$f":"G414","v":0.91},null,42.27,27.65]
[null,"October",45.05,{"$f":"D409","v":0.77170000000000005},34.770000000000003,{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,42.35,33.380000000000003]
[null,"November",46.6,{"$f":"D409","v":0.77170000000000005},35.96,{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,43.8,34.520000000000003]
[null,"December",48.9,{"$f":"D409","v":0.77170000000000005},37.74,{"$f":"F409","v":0.94},{"$f":"G409","v":0.96},null,45.97,36.229999999999997]
[]
[]
[]
[null,"NYISO Forward Prices - Energy Only @ bulk system",null,null,null,"Weighted Average Forward Prices - Energy Only @ bulk"]
[null,"in $/MWh",null,null,null,{"$f":"\"system (\"&TEXT(D447*100,\"0.0\")&\"% PJM - \"&TEXT(E447*100,\"0.0\")&\"% NYISO)\"","v":"system (86.9% PJM - 13.1% NYISO)"}]
[null,null,null,null,null,"in $/MWh"]
[null,null,"On-Peak","Off-Peak",null,null,"On-Peak","Off-Peak"]
[null,"January",95.5,79.75,null,"January",{"$f":"ROUND($K$428*I409+$K$429*C428,2)","v":67.39},53.7,null,null,{"$f":"D447","v":0.86937622256031299},"PJM",null,null,null,null,{"$f":"AVERAGE(G433:G436)","v":44.24499999999999},{"$f":"AVERAGE(H433:H436)","v":29.535}]
[null,"February",92.5,77.75,null,"February",63.57,50.74,null,null,{"$f":"E447","v":0.13062377743968703},"NYISO",null,null,null,null,{"$f":"AVERAGE(G428:G432,G437:G439)","v":48.573749999999997},{"$f":"AVERAGE(H428:H432,H437:H439)","v":38.543750000000003}]
[null,"March",61,50.75,null,"March",44.91,35.74,null,null,null,null,null,null,null,null,{"$f":"Q428/Q429","v":0.9108829357420416},{"$f":"R428/R429","v":0.76627209340035674}]
[null,"April",39.5,36,null,"April",38.5,30.98]
[null,"May",34.75,31,null,"May",37.97,30.39,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(G428:G439)","v":47.130833333333335},{"$f":"AVERAGE(H428:H439)","v":35.540833333333332},{"$f":"Q432/R432","v":1.326103777345307}]
[null,"June",42,32,null,"June",41.35,27.63]
[null,"July",54.25,40.5,null,"July",48.16,32.15]
[null,"August",51.25,38.5,null,"August",45.14,30.17]
[null,"September",42.75,31.75,null,"September",42.33,28.19]
[null,"October",43.75,31.75,null,"October",42.53,33.17]
[null,"November",50.25,38.25,null,"November",44.64,35.01]
[null,"December",69.75,54.5,null,"December",49.08,38.619999999999997]
[]
[]
[]
["Table #19","Generation Capacity Prices ($/MW/Day)"]
[]
[]
[null,null,"PJM Base","PJM","NYISO","Weighted"]
[null,null," Capacity",{"$f":"4/(4+M466)","v":0.86937622256031299},{"$f":"M466/(4+M466)","v":0.13062377743968703},"Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/kW/mo","$/MW/mo","Days"]
[null,"Summer",101.28,{"$f":"C449","v":101.28},168.22434782608693,{"$f":"ROUND(D449*D$447+E449*E$447,2)","v":110.02},null,null,null,null,null,null,null,null,null,"Oct",2.25,{"$f":"Q449*1000","v":2250},31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nov",1.25,{"$f":"Q450*1000","v":1250},30]
[null,"Winter",{"$f":"C449","v":101.28},{"$f":"C451","v":101.28},50.869502762430926,{"$f":"ROUND(D451*D$447+E451*E$447,2)","v":94.7},null,null,null,null,null,null,null,null,null,"Dec",1.25,{"$f":"Q451*1000","v":1250},31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan",1.25,1250,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feb",1.25,1250,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mar",1.25,1250,31]
["Table #20","Ancillary Services",null,null,null,null,null,null,null,null,null,null,null,null,"Apr",1.25,1250,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",2,2000,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P449:P456)","v":7},{"$f":"SUM(Q449:Q456)","v":7004.75},{"$f":"SUM(R449:R456)","v":4900},{"$f":"Q457/R457","v":1.4295408163265306}]
[null,null,"PJM Ancillary ","NYISO Ancillary ","Renewable","PJM","NYISO","Weighted"]
[null,null,"Services ","Services ","Power Cost",{"$f":"D447","v":0.86937622256031299},{"$f":"E447","v":0.13062377743968703},"Average"]
[]
[null,null,2,1.77,16.09,{"$f":"C461+E461","v":18.09},{"$f":"E461+D461","v":17.86},{"$f":"ROUND(F461*F$459+G461*G$459,2)","v":18.059999999999999}]
[]
["Assumptions:"]
[null,"Gen Cost =",{"$f":"F449","v":110.02},"per MW-day in summer",null,null,null,null,null,null,null,"RECO RFP MW",54.72]
[null,null,{"$f":"+F451","v":94.7},"per MW-day in winter",null,null,null,null,null,null,null,"Tranch MW",91.072500000000005,null,null,null,null,null,91.072500000000005]
[null,"Trans cost =",{"$f":"+C147","v":42548},"per MW-yr",null,null,null,null,null,null,null,"RFP %",{"$f":"ROUND(M464/M465,3)","v":0.60099999999999998}]
[null,"Analysis time period =",{"$f":"+H144","v":4},"summer months"]
[null,null,{"$f":"+H145","v":8},"winter months",null,null,null,null,null,null,null,"RECO Avg.x'mission",{"$f":"D223-D318","v":14.986444524085513},"$/MWh"]
[null,"Ancillary Services =",{"$f":"+D161","v":18.059999999999999},"/MWh",null,null,null,null,null,null,null,"Cen/West x'mission cont",{"$f":"ROUND(M466/(4+M466)*M468,2)","v":1.96},"$/MWh"]
[null,"Energy Costs =","Based on Jun  2022 to May 2023 Forwards @ PJM West as of January 04, 2022",null,null,null,null,null,null,null,null,"Actual RECO x'mission",{"$f":"M468-M469","v":13.026444524085512},"$/MWh"]
[null,null,"Based on Jun 2023 to May 2024 Forwards @ NYISO Zone G and Lower Hudson Valley (LHV) as of January 10, 2022"]
[null,"Usage patterns =",{"$f":"\"Forecasted \" &M1-1 &\" energy use by class, PJM on/off % from \" &M1-2 &\" class load profiles,\"","v":"Forecasted 2021 energy use by class, PJM on/off % from 2020 class load profiles,"}]
[null,null,{"$f":"\"RECO billing on/off % from \" &TEXT(DATE(M1-2,6,1),\"m/yy\") &\" to 5/\" &TEXT(DATE(M1-1,5,1),\"yy\") &\" actual data\"","v":"RECO billing on/off % from 6/20 to 5/21 actual data"}]
[null,"Obligations =",{"$f":"\" Class totals for \" &M1-1","v":" Class totals for 2021"}]
[null,"Losses =","Per RECO's Third Party Supplier Agreement adjusted for PJM 500kV losses and inadvertent energy."]
[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,"RECO Billing time periods ="," as per specific rate schedule"]
[]
[]
["No Longer Used"]
["Table #21","Determination of Retail Rates to be Charged to BGS Customers"]
[]
[null,"All-In Average costs @ bulk system =",null,{"$f":"D223","v":86.506298082509588},"/MWh","* Price from Table A (which does not include"]
[null,"Less Transmission",null,{"$f":"-M470","v":-13.026444524085512},"/MWh","transmission for the Central/Western Division)."]
[null,"BGS Cost ",null,{"$f":"D484+D485","v":73.479853558424082},"/MWh",{"$f":"\"** RECO average transmission rate of \"&TEXT(D223-D318,\"0.00\")&\" minus\"","v":"** RECO average transmission rate of 14.99 minus"}]
[null,null,null,null,null,"Central/West transmission contribution to weighted"]
[null,null,null,null,null,{"$f":"\"average rate \"&TEXT(M466,\"0.000\")&\"/\"&TEXT(4+M466,\"0.000\")&\" *$\"&TEXT(M468,\"0.00\")&\" per MWh).\"","v":"average rate 0.601/4.601 *$14.99 per MWh)."}]
[null,"Retail BGS Rates (excl SUT) (¢/kWh)"]
[]
[null,null,{"$f":"C6","v":"SC1"},{"$f":"D6","v":"SC3"},{"$f":"E6","v":"SC2 ND"},{"$f":"F6","v":"SC4"},{"$f":"G6","v":"SC6"},{"$f":"H6","v":"SC2 Dem"}]
[null,"Summer"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(($D$486*C327)/10,3)","v":7.3769999999999998},null,{"$f":"ROUND(E327*$D$486/10,3)","v":6.5759999999999996},{"$f":"ROUND(F327*$D$486/10,3)","v":6.0030000000000001},{"$f":"ROUND(G327*$D$486/10,3)","v":5.9960000000000004},{"$f":"ROUND((C348*$D$486+D348)/10,3)","v":6.069}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D328*$D$486/10,3)","v":10.118}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D329*$D$486/10,3)","v":5.298}]
[null,"Block1",{"$f":"ROUND(($D$486*C327+C332)/10,3)","v":4.7359999999999998}]
[null,"Block2",{"$f":"ROUND(($D$486*C327+C333)/10,3)","v":9.3670000000000009}]
[]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"I352","v":0.80100000000000005}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"J352","v":2.952}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C336*$D$486/10,3)","v":8.6780000000000008},null,{"$f":"ROUND(E336*$D$486/10,3)","v":7.2670000000000003},{"$f":"ROUND(F336*$D$486/10,3)","v":6.7969999999999997},{"$f":"ROUND(G336*$D$486/10,3)","v":6.7750000000000004},{"$f":"ROUND((C352*$D$486+D352)/10,3)","v":6.8}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D337*$D$486/10,3)","v":11.198}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D338*$D$486/10,3)","v":6.4880000000000004}]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"I353","v":1.034}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"J353","v":2.6819999999999999}]
[]
[null,"Retail BGS Rates (incl SUT) (¢/kWh)",null,"SUT @",6.6250000000000003E-2]
[]
[null,null,"SC1","SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[null,"Summer"]
[null,"All kWh (¢/kWh)",null,null,{"$f":"ROUND(E493*(1+$E$511),3)","v":7.0119999999999996},{"$f":"ROUND(F493*(1+$E$511),3)","v":6.4009999999999998},{"$f":"ROUND(G493*(1+$E$511),3)","v":6.3929999999999998},{"$f":"ROUND(H493*(1+$E$511),3)","v":6.4710000000000001}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D494*(1+$E$511),3)","v":10.788}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D495*(1+$E$511),3)","v":5.649}]
[null,"Block1",{"$f":"ROUND(C496*(1+$E$511),3)","v":5.05}]
[null,"Block2",{"$f":"ROUND(C497*(1+$E$511),3)","v":9.9879999999999995}]
[]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H500*(1+$E$511),3)","v":0.85399999999999998}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"ROUND(H501*(1+$E$511),3)","v":3.1480000000000001}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C504*(1+$E$511),3)","v":9.2530000000000001},null,{"$f":"ROUND(E504*(1+$E$511),3)","v":7.7480000000000002},{"$f":"ROUND(F504*(1+$E$511),3)","v":7.2469999999999999},{"$f":"ROUND(G504*(1+$E$511),3)","v":7.2240000000000002},{"$f":"ROUND(H504*(1+$E$511),3)","v":7.2510000000000003}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D505*(1+$E$511),3)","v":11.94}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D506*(1+$E$511),3)","v":6.9180000000000001}]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H508*(1+$E$511),3)","v":1.103}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"ROUND(H509*(1+$E$511),3)","v":2.86}]
[]
[]
["Table #21A","Determination of Retail Rates to be Charged to BGS Customers (INCLUDING RETAIL TRANSMISSION RATES)"]
[]
[null,"Transmission Rates (excl SUT)"]
[null,null,{"$f":"C491","v":"SC1"},{"$f":"D491","v":"SC3"},{"$f":"E491","v":"SC2 ND"},{"$f":"F491","v":"SC4"},{"$f":"G491","v":"SC6"},{"$f":"H491","v":"SC2 Dem"}]
[null,"Cents/kWh",1.421,1.421,0.52300000000000002,1.147,1.147,0.52300000000000002]
[null,"Summer $/kW",null,null,null,null,null,1.32]
[null,"Winter $/kW",null,null,null,null,null,1.1100000000000001]
[]
[]
[null,"Retail Shopping Credits (BGS and Transmission Rates) (excl SUT) (¢/kWh)"]
[]
[]
[null,"Summer"]
[null,"All kWh (¢/kWh)",{"$f":"IF(C493>0,C493+C$538,\"\")","v":8.798},"",7.0989999999999993,7.15,7.1430000000000007,6.5919999999999996]
[null,"Peak kWh (¢/kWh)","",11.539,"","","",""]
[null,"Off-Peak kWh (¢/kWh)","",6.7190000000000003,"","","",""]
[null,"Block1",6.157,"","","","",""]
[null,"Block2",10.788,"","","","",""]
[null,null,null,"","","","",""]
[null,null,"","","","","",""]
[null,"Demand Charge ($/kW)","",{"$f":"IF(D500>0,D500+D$538,\"\")","v":""},{"$f":"IF(E500>0,E500+E$538,\"\")","v":""},{"$f":"IF(F500>0,F500+F$538,\"\")","v":""},{"$f":"IF(G500>0,G500+G$538,\"\")","v":""},{"$f":"IF(H500>0,H500+H$539,\"\")","v":2.121}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"IF(C504>0,C504+C$538,\"\")","v":10.099},"",7.79,7.944,7.9220000000000006,7.3229999999999995]
[null,"Peak kWh (¢/kWh)","",12.619,"","","",""]
[null,"Off-Peak kWh (¢/kWh)","",7.9090000000000007,"","","",""]
[null,null,"",{"$f":"IF(E507>0,E507+D$538,\"\")","v":""},{"$f":"IF(F507>0,F507+E$538,\"\")","v":""},{"$f":"IF(G507>0,G507+F$538,\"\")","v":""},{"$f":"IF(H507>0,H507+G$538,\"\")","v":""},{"$f":"IF(I507>0,I507+H$538,\"\")","v":""}]
[null,"Demand Charge ($/kW)","",{"$f":"IF(D508>0,D508+D$538,\"\")","v":""},{"$f":"IF(E508>0,E508+E$538,\"\")","v":""},{"$f":"IF(F508>0,F508+F$538,\"\")","v":""},{"$f":"IF(G508>0,G508+G$538,\"\")","v":""},{"$f":"IF(H508>0,H508+H$540,\"\")","v":2.1440000000000001}]
[]
[]
[]
[]
["Table #22","Reconciliation of Customer Revenue and Supplier Payments"]
[]
[null,"Assumed Winning Bid Price =",{"$f":"+D223","v":86.506298082509588}]
[null,"Payment Ratio - Summer =",{"$f":"+J377","v":0.94240000000000002}]
[null,"Payment Ratio - Winter =",{"$f":"+J378","v":1.0397000000000001}]
[null,"Supplier Price - Summer =",{"$f":"ROUND(C568*C569,4)","v":81.523499999999999}]
[null,"Supplier Price - Winter =",{"$f":"ROUND(C568*C570,4)","v":89.940600000000003}]
[]
[]
[null,null,{"$f":"C6","v":"SC1"},{"$f":"D6","v":"SC3"},{"$f":"E6","v":"SC2 ND"},{"$f":"F6","v":"SC4"},{"$f":"G6","v":"SC6"},{"$f":"H6","v":"SC2 Dem"}]
[null,"Total BGS Revenue (Excl SUT) - in $1000"]
[null,"Summer",{"$f":"ROUND((C493*L48)/100,0)","v":21266},{"$f":"ROUND((D494*M49+D495*M50)/100,0)","v":9},{"$f":"ROUND(E493*N48/100,0)","v":273},{"$f":"ROUND(F493*O48/100,0)","v":111},{"$f":"ROUND(G493*P48/100,0)","v":81},{"$f":"ROUND(H493*Q48/100+H500*('Backup Calcs'!I95/4*H144)/1000,0)","v":7411}]
[null,"Winter",{"$f":"ROUND(C504*L44/100,0)","v":31464},{"$f":"ROUND((D505*M45+D506*M46)/100,0)","v":17},{"$f":"ROUND(E504*N44/100,0)","v":818},{"$f":"ROUND(F504*O44/100,0)","v":314},{"$f":"ROUND(G504*P44/100,0)","v":237},{"$f":"ROUND(H504*Q44/100+H508*('Backup Calcs'!I96/8*H145)/1000,0)","v":15469}]
[null,"Total",{"$f":"+C578+C577","v":52730},{"$f":"+D578+D577","v":26},1091,425,318,22880]
[]
[null,"Total"]
[null,"Summer",{"$f":"SUM(C577:H577)","v":29151}]
[null,"Winter",{"$f":"SUM(C578:H578)","v":48319}]
[null,"Total",{"$f":"+C583+C582","v":77470}]
[]
[null,null,{"$f":"C6","v":"SC1"},{"$f":"D6","v":"SC3"},{"$f":"E6","v":"SC2 ND"},{"$f":"F6","v":"SC4"},{"$f":"G6","v":"SC6"},{"$f":"H6","v":"SC2 Dem"}]
[null,"Total Supplier Payment - in $1000"]
[null,"Summer",{"$f":"+$C571*L48*C78/1000","v":25529.425434621768},10.538645298181375,368.05554503564525,163.39799894420653,119.80166544248468,10413.255168022944]
[null,"Winter",{"$f":"+$C572*L44*C78/1000","v":35424.070549404518},20.6154702266325,1099.654584837672,449.72180309978916,341.30759488337532,21299.924062812323]
[null,"Total",{"$f":"+C589+C588","v":60953.495984026289},31.154115524813875,1467.7101298733173,613.11980204399572,461.10926032585996,31713.179230835267]
[]
[null,"Total"]
[null,"Summer",{"$f":"SUM(C588:H588)","v":36604.474457365228}]
[null,"Winter",{"$f":"SUM(C589:H589)","v":58635.294065264308}]
[null,"Total",{"$f":"+C594+C593","v":95239.768522629543}]
[]
[null,"Less Transmission Credits"]
[null,"Summer",{"$f":"ROUND($C$147*SUM($C$141:$H$141)/12*H$144/1000*D447,0)","v":4937}]
[null,"Winter",{"$f":"ROUND($C$147*SUM($C$141:$H$141)/12*H$145/1000*D447,0)","v":9875}]
[null,"Total",{"$f":"SUM(C598:C599)","v":14812}]
[]
[null,"Net BGS Cost"]
[null,"Summer",{"$f":"C593-C598","v":31667.474457365228}]
[null,"Winter",{"$f":"C594-C599","v":48760.294065264308}]
[null,"Total",{"$f":"SUM(C603:C604)","v":80427.768522629543}]
[]
[null,"Differences"]
[null,"Summer",{"$f":"C603-C582","v":2516.4744573652279}]
[null,"Winter",{"$f":"C604-C583","v":441.2940652643083}]
[null,"Total",{"$f":"SUM(C608:C609)","v":2957.7685226295362}]

{"sheet":"Weighted Avg Price Calc","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["ROCKLAND ELECTRIC COMPANY"]
[{"$f":"'BGS Cost & Bid Factors'!M1&\" BGS Auction\"","v":"2022 BGS Auction"}]
[]
["Table A","Weighted Average Price Calculation"]
[]
[null,null,null,{"$f":"F6-2","v":2020},{"$f":"F6-1","v":2021},2022]
[null,null,null,"Auction","Auction","Auction"]
[null,"Line #","Specific BGS-FP Auction >>","36 Month","36 Month","36 Month","Total",null,"Notes:"]
[null,1,"Tranches",2,1,1,{"$f":"SUM(D9:F9)","v":4},null,"From then-current auction"]
[null,"2(a)","Winning Bid Price (¢/kWh)*",8.2420000000000009,6.6920000000000002,6.6920000000000002,null,null,{"$f":"\"(Note: \"&F6&\" Auction Price Shown for Illustrative Purposes Only)\"","v":"(Note: 2022 Auction Price Shown for Illustrative Purposes Only)"}]
[null,"2(b)","Capacity Proxy Price True-up - in (¢/kWh)*",-0.73399999999999999,-0.73399999999999999,0,null,null,"Entered After 2022 BGS Auction"]
[null,"2(C)","Winning Bid Price (¢/kWh)*",{"$f":"D11+D10","v":7.5080000000000009},{"$f":"E11+E10","v":5.9580000000000002},6.6920000000000002,null,null," = 2(a) + 2(b)"]
[null,3,"Transmission (¢/kWh)",1.327,0,0,null,null,"Average transmission cost included in bid for existing tranches only"]
[null,4,"BGS (¢/kWh)",{"$f":"D12-D13","v":6.1810000000000009},{"$f":"E12-E13","v":5.9580000000000002},6.6920000000000002,null,null,"=(2) - (3)"]
[null,5,"Weighted Avg BGS",{"$f":"D9/$G$9*D14","v":3.0905000000000005},{"$f":"E9/$G$9*E14","v":1.4895},{"$f":"F9/$G$9*F14","v":1.673},{"$f":"SUM(D15:F15)","v":6.2530000000000001},null,"= (1) / Total Tranches * (4)"]
[null,6,"Weighted Avg Trans",{"$f":"D9/$G$9*D13","v":0.66349999999999998},{"$f":"E9/$G$9*E13","v":0},{"$f":"F9/$G$9*F13","v":0},{"$f":"SUM(D16:F16)","v":0.66349999999999998},null,"= (1) / Total Tranches * (3)"]
[null,7,"Weighted Avg Total Price (¢/kWh)",null,null,null,{"$f":"G15+G16","v":6.9165000000000001}]
[]
[null,null,"Seasonal Payment Factors"]
[null,8,"                           Summer",1,1,{"$f":"IF('BGS Cost & Bid Factors'!J377<1,1,'BGS Cost & Bid Factors'!J377)","v":1},"**",null,"From then-current Bid Factor Spreadsheet"]
[null,9,"                           Winter",1,1,{"$f":"IF('BGS Cost & Bid Factors'!J378>1,1,'BGS Cost & Bid Factors'!J378)","v":1},"**",null,"From then-current Bid Factor Spreadsheet"]
[]
[null,null,"Applicable Customer Usage @ transmission nodes",null,null,"(Eastern Division)"]
[null,10,"                           Summer MWh",{"$f":"'Rate Calculations'!$D$251","v":386727.44055912853},null,null,null,null,"From then-current Bid Factor Spreadsheet"]
[null,11,"                           Winter MWh",{"$f":"'Rate Calculations'!$D$252","v":561490.00230262347},null,null,null,null,"From then-current Bid Factor Spreadsheet"]
[null,12,null,{"$f":"SUM(D24:D25)","v":948217.442861752}]
[]
[null,null,"Total Cost"]
[null,13,"Summer",{"$f":"ROUND(D$9/$G$9*(D$12-D$13)/100*D$20*$D$24*1000,0)","v":11951812},{"$f":"ROUND(E$9/$G$9*(E$12-E$13)/100*E$20*$D$24*1000,0)","v":5760305},{"$f":"ROUND(F$9/$G$9*(F$12-F$13)/100*F$20*$D$24*1000,0)","v":6469950},{"$f":"SUM(D29:F29)","v":24182067},null,"= (1) / Total Tranches * (2C - 3) / 100 * (8) * (10) * 1,000"]
[null,14,"Winter",{"$f":"ROUND(D$9/$G$9*(D$12-D$13)/100*D$21*$D$25*1000,0)","v":17352849},{"$f":"ROUND(E$9/$G$9*(E$12-E$13)/100*E$21*$D$25*1000,0)","v":8363394},{"$f":"ROUND(F$9/$G$9*(F$12-F$13)/100*F$21*$D$25*1000,0)","v":9393728},{"$f":"SUM(D30:F30)","v":35109971},null,"= (1) / Total Tranches * (2C - 3) / 100 * (9) * (11) * 1,000"]
[null,15,"Total",{"$f":"SUM(D29:D30)","v":29304661},{"$f":"SUM(E29:E30)","v":14123699},{"$f":"SUM(F29:F30)","v":15863678},{"$f":"SUM(G29:G30)","v":59292038},null,"= (13) + (14)"]
[]
[null,null,"Average Cost (NJ Statewide Auction)"]
[null,16,"Summer",{"$f":"ROUND(G29/D24/1000*100,3)","v":6.2530000000000001},"¢/kWh",null,null,null,"= sum(line 13) / (10) / 1000 * 100  rounded to 3 decimal places"]
[null,17,"Winter",{"$f":"ROUND(G30/D25/1000*100,3)","v":6.2530000000000001},"¢/kWh",null,null,null,"= sum(line 14) / (11) / 1000 * 100  rounded to 3 decimal places"]
[null,18,"Total",{"$f":"ROUND(G31/D26/1000*100,3)","v":6.2530000000000001},"¢/kWh",null,null,null,"= sum(line 15) / (12) / 1000 * 100  rounded to 3 decimal places"]
[]
[null,null,"Average Cost (Including RECO RFP)"]
[null,null,null,"BGS","RECO"]
[null,null,null,"Auction","RFP",null,"Total"]
[null,19,"Tranches",{"$f":"SUM(D9:F9)","v":4},{"$f":"'BGS Cost & Bid Factors'!M466","v":0.60099999999999998},null,{"$f":"SUM(D41:E41)","v":4.601},null,"Includes RECO RFP equivalent tranches"]
[null,20,"Price ¢/kWh",{"$f":"D36","v":6.2530000000000001},{"$f":"'Rate Calculations'!$D$286*(100/1000)","v":6.5900000000000007},null,null,null,{"$f":"\"BGS Auction from (18)\"","v":"BGS Auction from (18)"},null,{"$f":"\"Note \"&$E$42&\"¢ for RFP is illustrative\"","v":"Note 6.59¢ for RFP is illustrative"}]
[null,null,null,null,null,null,null,null,"(excludes transmission)."]
[null,21,"Transmission",{"$f":"F13","v":0},0]
[null,22,"BGS",{"$f":"D42-D44","v":6.2530000000000001},{"$f":"E42-E44","v":6.5900000000000007},null,null,null,"= (20) - (21)"]
[null,23,"Weighted Avg BGS",{"$f":"D41/$G$41*D45","v":5.4362095196696369},{"$f":"E41/$G$41*E45","v":0.86081069332753768},null,{"$f":"SUM(D46:E46)","v":6.2970202129971744},null,"= (19) / Total Tranches * (22)"]
[null,24,"Weighted Avg Trans",{"$f":"D41/$G$41*D44","v":0},{"$f":"E41/$G$41*E44","v":0},null,{"$f":"SUM(D47:E47)","v":0},null,"= (19) / Total Tranches * (21)"]
[null,25,"Weighted Avg Total Price",null,null,null,{"$f":"ROUND(G46+G47,3)","v":6.2969999999999997},null,"= (23) + (24)"]
[]
[null,null,"*  Includes Impact of PJM Marginal Losses"]
[null,null,"** Auction results set to 1.0 to avoid using an atypical result from the current 12-month forward prices."]

{"sheet":"Rate Calculations","index":2,"n_rows":286,"n_cols":34,"rows_kept":286,"cut":false,"hidden":false,"merged":[[256,18,256,20],[256,4,256,6],[256,7,256,9],[256,10,256,12],[256,13,256,14],[256,15,256,17]]}
["ROCKLAND ELECTRIC COMPANY"]
[{"$f":"'BGS Cost & Bid Factors'!M1 &\" BGS Auction\"","v":"2022 BGS Auction"}]
[]
[]
[]
["Table B","Ratio of BGS Unit Costs Less Transmission @ customer to All-In Average Cost @ transmission nodes"]
[null,"(from Table 15 of Bid Factor Spreadsheet)"]
[]
[null,"NON-DEMAND RATES"]
[null,"includes energy, G&T obligations, and Ancillary Services - adjusted to billing time periods"]
[]
[null,null,{"$f":"'BGS Cost & Bid Factors'!C$6","v":"SC1"},{"$f":"'BGS Cost & Bid Factors'!D$6","v":"SC3"},{"$f":"'BGS Cost & Bid Factors'!E$6","v":"SC2 ND"},{"$f":"'BGS Cost & Bid Factors'!F$6","v":"SC4"},{"$f":"'BGS Cost & Bid Factors'!G$6","v":"SC6"}]
[]
[null,"Summer - all hrs",{"$f":"'BGS Cost & Bid Factors'!C327","v":1.004},null,{"$f":"'BGS Cost & Bid Factors'!E327","v":0.89500000000000002},{"$f":"'BGS Cost & Bid Factors'!F327","v":0.81699999999999995},{"$f":"'BGS Cost & Bid Factors'!G327","v":0.81599999999999995}]
[null,"RECO On pk",null,{"$f":"'BGS Cost & Bid Factors'!D328","v":1.377}]
[null,"RECO Off pk",null,{"$f":"'BGS Cost & Bid Factors'!D329","v":0.72099999999999997}]
[]
[]
[null,"Constant Blk 1",{"$f":"'BGS Cost & Bid Factors'!C332","v":-26.410592999999999}]
[null,"Constant Blk 2",{"$f":"'BGS Cost & Bid Factors'!C333","v":19.899406999999997}]
[]
[]
[null,"Winter - all hrs",{"$f":"'BGS Cost & Bid Factors'!C336","v":1.181},null,{"$f":"'BGS Cost & Bid Factors'!E336","v":0.98899999999999999},{"$f":"'BGS Cost & Bid Factors'!F336","v":0.92500000000000004},{"$f":"'BGS Cost & Bid Factors'!G336","v":0.92200000000000004}]
[null,"RECO On pk",null,{"$f":"'BGS Cost & Bid Factors'!D337","v":1.524}]
[null,"RECO Off pk",null,{"$f":"'BGS Cost & Bid Factors'!D338","v":0.88300000000000001}]
[]
[null,"Annual - all hrs",{"$f":"'BGS Cost & Bid Factors'!C340","v":1.1020000000000001},{"$f":"'BGS Cost & Bid Factors'!D340","v":1.069},{"$f":"'BGS Cost & Bid Factors'!E340","v":0.96395876870324915},{"$f":"'BGS Cost & Bid Factors'!F340","v":0.89400000000000002},{"$f":"'BGS Cost & Bid Factors'!G340","v":0.89300000000000002}]
[]
[]
[null,"DEMAND RATES"]
[null,"includes energy and Ancillary Services, G&T obligations charged separately - adjusted to billing time periods"]
[]
[null,null,{"$f":"'BGS Cost & Bid Factors'!H6","v":"SC2 Dem"},{"$f":"+C33","v":"SC2 Dem"},null,null,"PLUS:"]
[null,null,"Multiplier","Constant"]
[null,"Summer - all hrs",{"$f":"'BGS Cost & Bid Factors'!C348","v":0.97499999999999998},{"$f":"'BGS Cost & Bid Factors'!D348","v":-10.957785675590245},null,null,"Gen Cost (per kW of Billed Demand/Month)"]
[]
[null,null,null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!G212","v":0},{"$f":"'BGS Cost & Bid Factors'!H212","v":"< 5 kW"},{"$f":"'BGS Cost & Bid Factors'!I212","v":"> 5 kW"}]
[]
[null,"Winter - all hrs",{"$f":"'BGS Cost & Bid Factors'!C352","v":1.07},{"$f":"'BGS Cost & Bid Factors'!D352","v":-10.625392199708756},null,null,"summer",{"$f":"'BGS Cost & Bid Factors'!H352","v":0},{"$f":"'BGS Cost & Bid Factors'!I352","v":0.80100000000000005},{"$f":"'BGS Cost & Bid Factors'!J352","v":2.952}]
[null,null,null,null,null,null,"winter",{"$f":"'BGS Cost & Bid Factors'!H353","v":0},{"$f":"'BGS Cost & Bid Factors'!I353","v":1.034},{"$f":"'BGS Cost & Bid Factors'!J353","v":2.6819999999999999}]
[]
[]
[null,"Annual - including T&G Obl $",{"$f":"'BGS Cost & Bid Factors'!C356","v":1.036}]
[]
[]
["Table C","Determination of Preliminary Retail Rates to be Charged to BGS Customers"]
[]
[null,"All-In Average costs @ Trans node =",null,{"$f":"'Weighted Avg Price Calc'!G48*10","v":62.97},"/MWh*","* Price from Table A (which does not include",null,null,null,null,"RECO RFP MW",{"$f":"'BGS Cost & Bid Factors'!M464","v":54.72}]
[null,"Less Transmission",null,0,"/MWh**","transmission for the Central/Western Division).",null,null,null,null,"Tranch MW",{"$f":"'BGS Cost & Bid Factors'!M465","v":91.072500000000005}]
[null,"BGS Cost ",null,{"$f":"D48+D49","v":62.97},"/MWh",{"$f":"\"** RECO average transmission rate of \"&TEXT(L52,\"0.00\")&\" minus\"","v":"** RECO average transmission rate of 14.99 minus"},null,null,null,null,"RFP %",{"$f":"ROUND(L48/L49,3)","v":0.60099999999999998}]
[null,null,null,null,null,"Central/West transmission contribution to weighted"]
[null,null,null,null,null,{"$f":"\"average rate \"&TEXT(L50,\"0.000\")&\"/\"&TEXT(4+L50,\"0.000\")&\" *$\"&TEXT(L52,\"0.00\")&\" per MWh).\"","v":"average rate 0.601/4.601 *$14.99 per MWh)."},null,null,{"$f":"ROUND(L50/(4+L50)*L52,2)","v":1.96},null,"RECO Avg.x'mission",{"$f":"'BGS Cost & Bid Factors'!D223-'BGS Cost & Bid Factors'!D318","v":14.986444524085513},"$/MWh"]
[null,"Retail BGS Rates (excl SUT) (¢/kWh)",null,null,null,null,null,null,null,null,"Cen/West x'mission cont",{"$f":"I52","v":1.96},"$/MWh"]
[null,null,null,null,null,null,null,null,null,null,"Actual RECO x'mission",{"$f":"L52-L53","v":13.026444524085512},"$/MWh"]
[null,null,{"$f":"'BGS Cost & Bid Factors'!C$6","v":"SC1"},{"$f":"'BGS Cost & Bid Factors'!D$6","v":"SC3"},{"$f":"'BGS Cost & Bid Factors'!E$6","v":"SC2 ND"},{"$f":"'BGS Cost & Bid Factors'!F$6","v":"SC4"},{"$f":"'BGS Cost & Bid Factors'!G$6","v":"SC6"},{"$f":"'BGS Cost & Bid Factors'!H$6","v":"SC2 Dem"}]
[null,"Summer"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(($D$50*C14)/10,3)","v":6.3220000000000001},null,{"$f":"ROUND(E14*$D$50/10,3)","v":5.6360000000000001},{"$f":"ROUND(F14*$D$50/10,3)","v":5.1449999999999996},{"$f":"ROUND(G14*$D$50/10,3)","v":5.1379999999999999},{"$f":"ROUND((C35*$D$50+D35)/10,3)","v":5.0439999999999996}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D15*$D$50/10,3)","v":8.6709999999999994}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D16*$D$50/10,3)","v":4.54}]
[null,"Block1",{"$f":"ROUND(($D$50*C14+C19)/10,3)","v":3.681}]
[null,"Block2",{"$f":"ROUND(($D$50*C14+C20)/10,3)","v":8.3119999999999994}]
[]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!H213","v":0.80100000000000005}]
[null,"Demand Charge ($/kW)> 5 kW",null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!I213","v":2.952}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C23*$D$50/10,3)","v":7.4370000000000003},null,{"$f":"ROUND(E23*$D$50/10,3)","v":6.2279999999999998},{"$f":"ROUND(F23*$D$50/10,3)","v":5.8250000000000002},{"$f":"ROUND(G23*$D$50/10,3)","v":5.806},{"$f":"ROUND((C39*$D$50+D39)/10,3)","v":5.6749999999999998}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D24*$D$50/10,3)","v":9.5969999999999995}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D25*$D$50/10,3)","v":5.56}]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!H214","v":1.034}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!I214","v":2.6819999999999999}]
[]
[]
["Table D","Calculation of Rate Adjustment Factors"]
[]
[null,null,{"$f":"'BGS Cost & Bid Factors'!C$6","v":"SC1"},{"$f":"'BGS Cost & Bid Factors'!D$6","v":"SC3"},{"$f":"'BGS Cost & Bid Factors'!E$6","v":"SC2 ND"},{"$f":"'BGS Cost & Bid Factors'!F$6","v":"SC4"},{"$f":"'BGS Cost & Bid Factors'!G$6","v":"SC6"},{"$f":"'BGS Cost & Bid Factors'!H$6","v":"SC2 Dem"},null,null,"SC2 Sales and Demands"]
[null,"Total BGS Revenue (Excl SUT) - in $1000",null,null,null,null,null,null,null,null,null,"Over 5 kW"]
[null,"Summer",{"$f":"ROUND((C57*'BGS Cost & Bid Factors'!L$48)/100,0)","v":18225},{"$f":"ROUND((D58*'BGS Cost & Bid Factors'!M$49+D59*'BGS Cost & Bid Factors'!M$50)/100,0)","v":7},{"$f":"ROUND((E57*'BGS Cost & Bid Factors'!N$48)/100,0)","v":234},{"$f":"ROUND((F57*'BGS Cost & Bid Factors'!O$48)/100,0)","v":95},{"$f":"ROUND((G57*'BGS Cost & Bid Factors'!P$48)/100,0)","v":70},{"$f":"ROUND(H57*'BGS Cost & Bid Factors'!Q$48/100+(H64*($L$80/4*'BGS Cost & Bid Factors'!H$144)+H65*($L$80/4*'BGS Cost & Bid Factors'!H$144))/1000,0)","v":7219},null,null,"Summer",{"$f":"'Backup Calcs'!$I$95","v":343315.11289268365}]
[null,"Winter",{"$f":"ROUND(C68*'BGS Cost & Bid Factors'!L$44/100,0)","v":26964},{"$f":"ROUND((D69*'BGS Cost & Bid Factors'!M$45+D70*'BGS Cost & Bid Factors'!M$46)/100,0)","v":15},{"$f":"ROUND(E68*'BGS Cost & Bid Factors'!N$44/100,0)","v":701},{"$f":"ROUND(F68*'BGS Cost & Bid Factors'!O$44/100,0)","v":269},{"$f":"ROUND(G68*'BGS Cost & Bid Factors'!P$44/100,0)","v":204},{"$f":"ROUND(H68*'BGS Cost & Bid Factors'!Q$44/100+(H72*($L$81/8*'BGS Cost & Bid Factors'!H$145)++H73*($L$81/8*'BGS Cost & Bid Factors'!H$145))/1000,0)","v":14688},null,null,"Winter",{"$f":"'Backup Calcs'!$I$96","v":623356.55302264099}]
[null,"Total",{"$f":"+C81+C80","v":45189},22,935,364,274,21907]
[]
[null,"Total"]
[null,"Summer",{"$f":"SUM(C80:H80)","v":25850}]
[null,"Winter",{"$f":"SUM(C81:H81)","v":42841}]
[null,"Total",{"$f":"+C86+C85","v":68691}]
[]
[]
[null,"Total Supplier Payments - in $1000"]
[]
[null,"Eastern Division","Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"'Weighted Avg Price Calc'!G$29/1000","v":24182.066999999999},null,{"$f":"C93-D93","v":24182.066999999999},null,{"$f":"ROUND('BGS Cost & Bid Factors'!$C$147*SUM('BGS Cost & Bid Factors'!$C$141:$H$141)/12*'BGS Cost & Bid Factors'!H$144/1000*'BGS Cost & Bid Factors'!D447,0)","v":4937}]
[null,"Winter",{"$f":"'Weighted Avg Price Calc'!G$30/1000","v":35109.970999999998},null,{"$f":"C94-D94","v":35109.970999999998},null,{"$f":"ROUND('BGS Cost & Bid Factors'!$C$147*SUM('BGS Cost & Bid Factors'!$C$141:$H$141)/12*'BGS Cost & Bid Factors'!H$145/1000*'BGS Cost & Bid Factors'!F459,0)","v":9875}]
[null,"Total",{"$f":"+C94+C93","v":59292.038},{"$f":"D93+D94","v":0},{"$f":"E93+E94","v":59292.038}]
[]
[null,"Central/Western Division","Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"ROUND($E$251*1000*'Weighted Avg Price Calc'!E42/100/1000,0)","v":3865},0,{"$f":"C98-D98","v":3865}]
[null,"Winter",{"$f":"ROUND($E$252*1000*'Weighted Avg Price Calc'!E42/100/1000,0)","v":5560},0,{"$f":"C99-D99","v":5560}]
[null,"Total",{"$f":"+C99+C98","v":9425},{"$f":"D98+D99","v":0},{"$f":"E98+E99","v":9425}]
[]
[null,"Total RECO FP","Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"C93+C98","v":28047.066999999999},{"$f":"D93+D98","v":0},{"$f":"C103-D103","v":28047.066999999999}]
[null,"Winter",{"$f":"C94+C99","v":40669.970999999998},{"$f":"D94+D99","v":0},{"$f":"C104-D104","v":40669.970999999998}]
[null,"Total",{"$f":"+C104+C103","v":68717.038},{"$f":"+D104+D103","v":0},{"$f":"E103+E104","v":68717.038}]
[null,null,null,null,null,null,"Rate"]
[null,"Differences","BGS","BGS",null,null,"Adjustment"]
[null,null,"Revenue","Costs","Difference",null,"Factors"]
[null,"Summer",{"$f":"C85","v":25850},{"$f":"E103","v":28047.066999999999},{"$f":"D109-C109","v":2197.0669999999991},null,{"$f":"ROUND(1+E109/C85,5)","v":1.0849899999999999}]
[null,"Winter",{"$f":"C86","v":42841},{"$f":"E104","v":40669.970999999998},{"$f":"D110-C110","v":-2171.0290000000023},null,{"$f":"ROUND(1+E110/C86,5)","v":0.94932000000000005}]
[null,"Total",{"$f":"+C110+C109","v":68691},{"$f":"+D110+D109","v":68717.038},{"$f":"+E110+E109","v":26.037999999996828}]
[]
["Table E","Final Retail BGS Rates (¢/kWh)"]
[]
[]
[null,"Rates Excluding SUT:",null,null,null,null,null,null,null,null,"Original Rates Excluding SUT (zero Retail Access Adjustment)",null,null,null,null,null,null,null,null,"Difference",null,null,null,null,null,null,null,null,"Difference"]
[]
[null,null,{"$f":"'BGS Cost & Bid Factors'!C$6","v":"SC1"},{"$f":"'BGS Cost & Bid Factors'!D$6","v":"SC3"},{"$f":"'BGS Cost & Bid Factors'!E$6","v":"SC2 ND"},{"$f":"'BGS Cost & Bid Factors'!F$6","v":"SC4"},{"$f":"'BGS Cost & Bid Factors'!G$6","v":"SC6"},{"$f":"'BGS Cost & Bid Factors'!H$6","v":"SC2 Dem"},null,null,null,"SC1","SC3","SC2 ND","SC4","SC6","SC2 Dem",null,null,"SC1","SC3","SC2 ND","SC4","SC6","SC2 Dem",null,null,"SC1",null,"SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[]
[null,"Summer",null,null,null,null,null,null,null,null,"Summer",null,null,null,null,null,null,null,"Summer",null,null,null,null,null,null,null,"Summer"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C57*$G$109,3)","v":6.859},null,{"$f":"ROUND(E57*$G$109,3)","v":6.1150000000000002},{"$f":"ROUND(F57*$G$109,3)","v":5.5819999999999999},{"$f":"ROUND(G57*$G$109,3)","v":5.5750000000000002},{"$f":"ROUND(H57*$G$109,3)","v":5.4729999999999999},null,null,"All kWh (¢/kWh)",9.5500000000000007,null,9.7089999999999996,5.8860000000000001,5.8860000000000001,7.4980000000000002,null,"All kWh (¢/kWh)",{"$f":"C121-L121","v":-2.6910000000000007},null,{"$f":"E121-N121","v":-3.5939999999999994},{"$f":"F121-O121","v":-0.30400000000000027},{"$f":"G121-P121","v":-0.31099999999999994},{"$f":"H121-Q121","v":-2.0250000000000004},null,"All kWh (¢/kWh)",{"$f":"T121/L121","v":-0.28178010471204196},null,{"$f":"V121/N121","v":-0.37017200535585537},{"$f":"W121/O121","v":-5.1647978253482885E-2},{"$f":"X121/P121","v":-5.2837240910635394E-2},{"$f":"Y121/Q121","v":-0.27007201920512142}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D58*$G$109,3)","v":9.4079999999999995},null,null,null,null,null,null,"Peak kWh (¢/kWh)",null,14.58,null,null,null,null,null,"Peak kWh (¢/kWh)",null,{"$f":"D122-M122","v":-5.1720000000000006},null,null,null,null,null,"Peak kWh (¢/kWh)",null,{"$f":"U122/M122","v":-0.35473251028806591}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D59*$G$109,3)","v":4.9260000000000002},null,null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,5.7709999999999999,null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,{"$f":"D123-M123","v":-0.84499999999999975},null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,{"$f":"U123/M123","v":-0.14642176399237564}]
[null,"Block1",{"$f":"ROUND(C60*$G$109,3)","v":3.9940000000000002},null,null,null,null,null,null,null,"Block1",8.4120000000000008,null,null,null,null,null,null,"Block1",{"$f":"C124-L124","v":-4.418000000000001},null,null,null,null,null,null,"Block1",{"$f":"T124/L124","v":-0.52520209224916792}]
[null,"Block2",{"$f":"ROUND(C61*$G$109,3)","v":9.0180000000000007},null,null,null,null,null,null,null,"Block2",9.8390000000000004,null,null,null,null,null,null,"Block2",{"$f":"C125-L125","v":-0.82099999999999973},null,null,null,null,null,null,"Block2",{"$f":"T125/L125","v":-8.3443439373920084E-2}]
[null,null,null,null,null,null,null,null,null,null,"Block3","NA",null,null,null,null,null,null,"Block3","NA",null,null,null,null,null,null,"Block3","NA"]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H64*$G$109,3)","v":0.86899999999999999},null,null,"Demand Charge ($/kW)",null,null,null,null,null,5.4420000000000002,null,"Demand Charge ($/kW)",null,null,null,null,null,{"$f":"H128-Q128","v":-4.5730000000000004},null,"Demand Charge ($/kW)",null,null,null,null,null,{"$f":"Y128/Q128","v":-0.84031606027195893}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"ROUND(H65*$G$109,3)","v":3.2029999999999998}]
[null,null,null,null,null,null,null,null,null,null,"Winter",null,null,null,null,null,null,null,"Winter",null,null,null,null,null,null,null,"Winter"]
[null,"Winter",null,null,null,null,null,null,null,null,"All kWh (¢/kWh)",9.7379999999999995,null,8.1769999999999996,5.8460000000000001,5.8209999999999997,6.7539999999999996,null,"All kWh (¢/kWh)",{"$f":"C132-L131","v":-2.6779999999999999},null,{"$f":"E132-N131","v":-2.2649999999999997},{"$f":"F132-O131","v":-0.31599999999999984},{"$f":"G132-P131","v":-0.30900000000000016},{"$f":"H132-Q131","v":-1.367},null,"All kWh (¢/kWh)",{"$f":"T131/L131","v":-0.27500513452454306},null,{"$f":"V131/N131","v":-0.27699645346704166},{"$f":"W131/O131","v":-5.4054054054054022E-2},{"$f":"X131/P131","v":-5.3083662600927707E-2},{"$f":"Y131/Q131","v":-0.20239857862007701}]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C68*$G$110,3)","v":7.06},null,{"$f":"ROUND(E68*$G$110,3)","v":5.9119999999999999},{"$f":"ROUND(F68*$G$110,3)","v":5.53},{"$f":"ROUND(G68*$G$110,3)","v":5.5119999999999996},{"$f":"ROUND(H68*$G$110,3)","v":5.3869999999999996},null,null,"Peak kWh (¢/kWh)",null,12.37,null,null,null,null,null,"Peak kWh (¢/kWh)",null,{"$f":"D133-M132","v":-3.2589999999999986},null,null,null,null,null,"Peak kWh (¢/kWh)",null,{"$f":"U132/M132","v":-0.26345998383185115}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D69*$G$110,3)","v":9.1110000000000007},null,null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,5.6959999999999997,null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,{"$f":"D134-M133","v":-0.41800000000000015},null,null,null,null,null,"Off-Peak kWh (¢/kWh)",null,{"$f":"U133/M133","v":-7.3384831460674191E-2}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D70*$G$110,3)","v":5.2779999999999996}]
[null,null,null,null,null,null,null,null,null,null,"Demand Charge ($/kW)",null,null,null,null,null,5.4,null,"Demand Charge ($/kW)",null,null,null,null,null,{"$f":"H136-Q135","v":-4.4180000000000001},null,"Demand Charge ($/kW)",null,null,null,null,null,{"$f":"Y135/Q135","v":-0.81814814814814807}]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H72*$G$110,3)","v":0.98199999999999998}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"ROUND(H73*$G$110,3)","v":2.5459999999999998}]
[]
[null,"Rates Including SUT:",null,"SUT @",6.6250000000000003E-2]
[]
[null,null,"SC1","SC3","SC2 ND","SC4","SC6","SC2 Dem"]
[null,"Summer"]
[null,"All kWh (¢/kWh)",null,null,{"$f":"ROUND(E121*(1+$E$139),3)","v":6.52},{"$f":"ROUND(F121*(1+$E$139),3)","v":5.952},{"$f":"ROUND(G121*(1+$E$139),3)","v":5.944},{"$f":"ROUND(H121*(1+$E$139),3)","v":5.8360000000000003}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D122*(1+$E$139),3)","v":10.031000000000001}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D123*(1+$E$139),3)","v":5.2519999999999998}]
[null,"Block1",{"$f":"ROUND(C124*(1+$E$139),3)","v":4.2590000000000003}]
[null,"Block2",{"$f":"ROUND(C125*(1+$E$139),3)","v":9.6150000000000002}]
[]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H128*(1+$E$139),2)","v":0.93}]
[null,"Demand Charge ($/kW)> 5 kW",null,null,null,null,null,{"$f":"ROUND(H129*(1+$E$139),2)","v":3.42}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"ROUND(C132*(1+$E$139),3)","v":7.5279999999999996},null,{"$f":"ROUND(E132*(1+$E$139),3)","v":6.3040000000000003},{"$f":"ROUND(F132*(1+$E$139),3)","v":5.8959999999999999},{"$f":"ROUND(G132*(1+$E$139),3)","v":5.8769999999999998},{"$f":"ROUND(H132*(1+$E$139),3)","v":5.7439999999999998}]
[null,"Peak kWh (¢/kWh)",null,{"$f":"ROUND(D133*(1+$E$139),3)","v":9.7149999999999999}]
[null,"Off-Peak kWh (¢/kWh)",null,{"$f":"ROUND(D134*(1+$E$139),3)","v":5.6280000000000001}]
[]
[null,"Demand Charge ($/kW) 1st 5kW",null,null,null,null,null,{"$f":"ROUND(H136*(1+$E$139),2)","v":1.05}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"ROUND(H137*(1+$E$139),2)","v":2.71}]
[]
[]
["Table F","Spreadsheet Error Checking"]
[]
[]
[null,"Total BGS Revenue (Excl SUT) - in $1000"]
[]
[null,null,{"$f":"'BGS Cost & Bid Factors'!C$6","v":"SC1"},{"$f":"'BGS Cost & Bid Factors'!D$6","v":"SC3"},{"$f":"'BGS Cost & Bid Factors'!E$6","v":"SC2 ND"},{"$f":"'BGS Cost & Bid Factors'!F$6","v":"SC4"},{"$f":"'BGS Cost & Bid Factors'!G$6","v":"SC6"},{"$f":"'BGS Cost & Bid Factors'!H$6","v":"SC2 Dem"},null,null,"SC2 Sales and Demands"]
[null,null,null,null,null,null,null,null,null,null,null,"Over 5 kW"]
[null,"Summer",{"$f":"ROUND((C121*'BGS Cost & Bid Factors'!L$48)/100,0)","v":19773},{"$f":"ROUND((D122*'BGS Cost & Bid Factors'!M$49+D123*'BGS Cost & Bid Factors'!M$50)/100,0)","v":8},{"$f":"ROUND((E121*'BGS Cost & Bid Factors'!N$48)/100,0)","v":254},{"$f":"ROUND((F121*'BGS Cost & Bid Factors'!O$48)/100,0)","v":103},{"$f":"ROUND((G121*'BGS Cost & Bid Factors'!P$48)/100,0)","v":76},{"$f":"ROUND(H121*'BGS Cost & Bid Factors'!Q$48/100+(H128*($L$169/4*'BGS Cost & Bid Factors'!H$144)+H129*($L$169/4*'BGS Cost & Bid Factors'!H$144))/1000,0)","v":7833},null,null,"Summer",{"$f":"'Backup Calcs'!$I$95","v":343315.11289268365}]
[null,"Winter",{"$f":"ROUND(C132*'BGS Cost & Bid Factors'!L$44/100,0)","v":25597},{"$f":"ROUND((D133*'BGS Cost & Bid Factors'!M$45+D134*'BGS Cost & Bid Factors'!M$46)/100,0)","v":14},{"$f":"ROUND(E132*'BGS Cost & Bid Factors'!N$44/100,0)","v":665},{"$f":"ROUND(F132*'BGS Cost & Bid Factors'!O$44/100,0)","v":255},{"$f":"ROUND(G132*'BGS Cost & Bid Factors'!P$44/100,0)","v":193},{"$f":"ROUND(H132*'BGS Cost & Bid Factors'!Q$44/100+(H136*($L$170/8*'BGS Cost & Bid Factors'!H$145)+H137*($L$170/8*'BGS Cost & Bid Factors'!H$145))/1000,0)","v":13943},null,null,"Winter",{"$f":"'Backup Calcs'!$I$96","v":623356.55302264099}]
[null,"Total",{"$f":"+C170+C169","v":45370},22,919,358,269,21776]
[]
[null,"Total"]
[null,"Summer",{"$f":"SUM(C169:H169)","v":28047}]
[null,"Winter",{"$f":"SUM(C170:H170)","v":40667}]
[null,"Total",{"$f":"+C175+C174","v":68714}]
[]
[null,"Supplier Payments - in $1000"]
[]
[null,"Eastern Division"]
[null,null,"Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"'Weighted Avg Price Calc'!G$29/1000","v":24182.066999999999},0,{"$f":"C182-D182","v":24182.066999999999},null,{"$f":"ROUND('BGS Cost & Bid Factors'!$C$147*SUM('BGS Cost & Bid Factors'!$C$141:$H$141)/12*'BGS Cost & Bid Factors'!H$144/1000*'BGS Cost & Bid Factors'!D447,0)","v":4937}]
[null,"Winter",{"$f":"'Weighted Avg Price Calc'!G$30/1000","v":35109.970999999998},0,{"$f":"C183-D183","v":35109.970999999998},null,{"$f":"ROUND('BGS Cost & Bid Factors'!$C$147*SUM('BGS Cost & Bid Factors'!$C$141:$H$141)/12*'BGS Cost & Bid Factors'!H$145/1000*'BGS Cost & Bid Factors'!D447,0)","v":9875}]
[null,"Total",{"$f":"+C183+C182","v":59292.038},{"$f":"D182+D183","v":0},{"$f":"E182+E183","v":59292.038}]
[]
[null,"Central/Western Division"]
[null,null,"Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"ROUND($E$251*1000*'Weighted Avg Price Calc'!E42/100/1000,0)","v":3865},0,{"$f":"C188-D188","v":3865}]
[null,"Winter",{"$f":"ROUND($E$252*1000*'Weighted Avg Price Calc'!E42/100/1000,0)","v":5560},0,{"$f":"C189-D189","v":5560}]
[null,"Total",{"$f":"+C189+C188","v":9425},{"$f":"D188+D189","v":0},{"$f":"E188+E189","v":9425}]
[]
[null,"Total RECO FP"]
[null,null,"Total","Transmission","Net BGS"]
[null,"Summer",{"$f":"C182+C188","v":28047.066999999999},{"$f":"D182+D188","v":0},{"$f":"C194-D194","v":28047.066999999999}]
[null,"Winter",{"$f":"C183+C189","v":40669.970999999998},{"$f":"D183+D189","v":0},{"$f":"C195-D195","v":40669.970999999998}]
[null,"Total",{"$f":"+C195+C194","v":68717.038},{"$f":"D194+D195","v":0},{"$f":"E194+E195","v":68717.038}]
[]
[null,"Differences"]
[null,null,"BGS","BGS"]
[null,null,"Revenue","Costs","Difference"]
[null,"Summer",{"$f":"C174","v":28047},{"$f":"E194","v":28047.066999999999},{"$f":"D201-C201","v":6.6999999999097781E-2}]
[null,"Winter",{"$f":"C175","v":40667},{"$f":"E195","v":40669.970999999998},{"$f":"D202-C202","v":2.9709999999977299}]
[null,"Total",{"$f":"+C202+C201","v":68714},{"$f":"+D202+D201","v":68717.038},{"$f":"+E202+E201","v":3.0379999999968277}]
[]
[null,"Determination of Retail Rates to be Charged to BGS Customers (INCLUDING RETAIL TRANSMISSION RATES)"]
[]
[null,"Transmission Rates (excl SUT)"]
[null,null,{"$f":"C55","v":"SC1"},{"$f":"D55","v":"SC3"},{"$f":"E55","v":"SC2 ND"},{"$f":"F55","v":"SC4"},{"$f":"G55","v":"SC6"},{"$f":"H55","v":"SC2 Dem"}]
[null,"Cents/kWh",{"$f":"'BGS Cost & Bid Factors'!C538","v":1.421},{"$f":"'BGS Cost & Bid Factors'!D538","v":1.421},{"$f":"'BGS Cost & Bid Factors'!E538","v":0.52300000000000002},{"$f":"'BGS Cost & Bid Factors'!F538","v":1.147},{"$f":"'BGS Cost & Bid Factors'!G538","v":1.147},{"$f":"'BGS Cost & Bid Factors'!H538","v":0.52300000000000002}]
[null,"$/kW",null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!H539","v":1.32}]
[null,null,null,null,null,null,null,{"$f":"'BGS Cost & Bid Factors'!H540","v":1.1100000000000001}]
[]
[]
[null,"Retail Shopping Credits (BGS and Transmission Rates) (excl SUT) (¢/kWh)"]
[]
[]
[null,"Summer"]
[null,"All kWh (¢/kWh)",{"$f":"IF(C121>0,C121+C$209,\"\")","v":8.2799999999999994},"",6.6379999999999999,6.7290000000000001,6.7220000000000004,5.9959999999999996]
[null,"Peak kWh (¢/kWh)","",10.828999999999999,"","","",""]
[null,"Off-Peak kWh (¢/kWh)","",6.3470000000000004,"","","",""]
[null,"Block1",5.415,"","","","",""]
[null,"Block2",10.439,"","","","",""]
[null,null,null,"","","","",""]
[null,null,"","","","","",""]
[null,"Demand Charge ($/kW) 1st 5kW","",{"$f":"IF(D128>0,D128+D$209,\"\")","v":""},{"$f":"IF(E128>0,E128+E$209,\"\")","v":""},{"$f":"IF(F128>0,F128+F$209,\"\")","v":""},{"$f":"IF(G128>0,G128+G$209,\"\")","v":""},{"$f":"IF(H128>0,H128+H$210,\"\")","v":2.1890000000000001}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"IF(H129>0,H129+H$210,\"\")","v":4.5229999999999997}]
[]
[null,"Winter"]
[null,"All kWh (¢/kWh)",{"$f":"IF(C132>0,C132+C$209,\"\")","v":8.4809999999999999},"",6.4349999999999996,6.6770000000000005,6.6589999999999998,5.9099999999999993]
[null,"Peak kWh (¢/kWh)","",10.532,"","","",""]
[null,"Off-Peak kWh (¢/kWh)","",6.6989999999999998,"","","",""]
[null,null,"","","","","",""]
[null,"Demand Charge ($/kW) 1st 5kW","",{"$f":"IF(D136>0,D136+D$209,\"\")","v":""},{"$f":"IF(E136>0,E136+E$209,\"\")","v":""},{"$f":"IF(F136>0,F136+F$209,\"\")","v":""},{"$f":"IF(G136>0,G136+G$209,\"\")","v":""},{"$f":"IF(H136>0,H136+H$211,\"\")","v":2.0920000000000001}]
[null,"Demand Charge ($/kW) > 5 kW",null,null,null,null,null,{"$f":"IF(H137>0,H137+H$211,\"\")","v":3.6559999999999997}]
[]
[]
["DETAILS OF RECO RFP AND INPUTS"]
[]
[null,"Summary of Usage By Season"]
[]
[null,"Sales:"]
[null,null,null,"Eastern","Cen/West","Total"]
[]
[null,null,"Summer",359348,53992,{"$f":"SUM(D244:E244)","v":413340}]
[null,null,"Winter",521768,78396,{"$f":"SUM(D245:E245)","v":600164}]
[null,null,"Total",{"$f":"SUM(D244:D245)","v":881116},{"$f":"SUM(E244:E245)","v":132388},1013504]
[]
[null,"Sendout:"]
[null,null,null,"Eastern","Cen/West","Total"]
[]
[null,null,"Summer",386727.44055912853,58650.631071575364,{"$f":"SUM(D251:E251)","v":445378.07163070387}]
[null,null,"Winter",561490.00230262347,84364.259830258743,{"$f":"SUM(D252:E252)","v":645854.26213288226}]
[null,null,"Total",{"$f":"SUM(D251:D252)","v":948217.442861752},{"$f":"SUM(E251:E252)","v":143014.89090183412},1091232.3337635861]
[]
[]
[]
[null,null,null,"ORU Budget","Total NUG",null,null,"Hedged Energy",null,null,"Unhedged Energy",null,null,"Ancillary Services",null,"Hedged Capacity",null,null,"Unhedged Capacity"]
[null,null,null,"Sendout (MWh)","Output (MWh)","Energy Charge ($/MWh)","Total ($)","Sendout (MWh)","Energy Charge ($/MWh)","Total ($)","Sendout (MWh)","ATC Forward Energy ($/MWh)","Total ($)","Charge ($/MWh)","Total ($)","Peak Load (MW)","Capacity Charge ($/kW-month)","Total ($)","Peak Load (MW)","Capacity Charge ($/kW-month)","Total ($)"]
[]
[null,"2022-06-01",null,9962,null,null,null,7200,32.39,{"$f":"H260*I260","v":233208},{"$f":"D260-H260","v":2762},36.888888888888886,{"$f":"K260*L260","v":101887.11111111111},1.7540701087467583,{"$f":"N260*(K260+H260)","v":17474.046423335207},0,0,{"$f":"P260*Q260*1000","v":0},50.420347477115371,5.6407331327889993,{"$f":"S260*T260*1000","v":284407.72458089888}]
[null,{"$f":"B260+31-DAY(B260+31)+1","v":"2022-07-01"},null,14114,null,null,null,7440,32.39,240981.6,{"$f":"D261-H261","v":6674},46.413978494623656,309766.89247311826,1.5639790738187798,22074.000647878256,0,0,{"$f":"P261*Q261*1000","v":0},50.420347477115371,5.6760209262435684,{"$f":"S261*T261*1000","v":286186.94738857896}]
[null,{"$f":"B261+31-DAY(B261+31)+1","v":"2022-08-01"},null,12280,null,null,null,7440,32.39,240981.6,4840,44.806451612903224,216863.22580645161,1.51473227135805,18600.912292276855,0,0,0,50.420347477115371,5.6761344952178545,286192.67357572506]
[null,"2022-09-01",null,8929,null,null,null,7200,32.39,233208,1729,36.883333333333333,63771.283333333333,1.3592193980179004,12136.470004901832,0,0,0,50.420347477115371,5.6910646338844746,286945.45635517756]
[null,"2022-10-01",null,7562,null,null,null,7440,32.39,240981.6,122,37.16935483870968,4534.6612903225805,1.331826727646348,10071.273714461684,0,0,0,50.420347477115371,5.7443665879321451,289632.95939947036]
[null,"2022-11-01",null,6966,null,null,null,7210,32.39,233531.9,-244,43.842233009708735,-10697.504854368932,1.8717612134623938,13038.688612979035,0,0,0,50.420347477115371,3.8015561485909481,191675.78196572003]
[null,"2022-12-01",null,7662,null,null,null,7440,32.39,240981.6,222,61.387096774193552,13627.935483870968,1.9084411355949598,14622.475980928582,0,0,0,50.420347477115371,3.7491838984813817,189035.15491703729]
[null,"2023-01-01",null,10433,null,null,null,7440,32.39,240981.6,2993,86.862903225806448,259980.6693548387,1.9204545881910384,20036.102718597103,0,0,0,50.420347477115371,4.0950101871594402,206471.83655890625]
[null,"2023-02-01",null,8865,null,null,null,6720,32.39,217660.80000000002,2145,84.773809523809518,181839.82142857142,1.9599537933674918,17374.990378202816,0,0,0,50.420347477115371,3.9919405039664024,201275.02731795708]
[null,"2023-03-01",null,8601,null,null,null,7430,32.39,240657.7,1171,55.826716016150741,65373.084454912518,2.1369738249400827,18380.11186830965,0,0,0,50.420347477115371,4.0003414519906322,201698.60603647592]
[null,"2023-04-01",null,6506,null,null,null,7200,32.39,233208,-694,37.555555555555557,-26063.555555555558,2.0330792409461185,13227.213541595447,0,0,0,50.420347477115371,3.9699893715341954,200168.24359320902]
[null,"2023-05-01",null,7937,null,null,null,7440,32.39,240981.6,497,32.774193548387096,16288.774193548386,2.3733157416217607,18837.007041251916,0,0,0,50.420347477115371,7.5863766767633063,382507.7481346897]
[]
[null,"Total",null,{"$f":"SUM(D260:D272)","v":109817},0,0,0,{"$f":"SUM(H260:H272)","v":87600},null,{"$f":"SUM(J260:J272)","v":2837364.0000000005},{"$f":"SUM(K260:K272)","v":22217},null,{"$f":"SUM(M260:M272)","v":1197172.3985201542},{"$f":"O273/D273","v":1.7836336197921849},{"$f":"SUM(O260:O271)","v":195873.29322471836},null,null,{"$f":"SUM(R260:R272)","v":0},null,null,{"$f":"SUM(U260:U272)","v":3006198.1598238461}]
[]
[]
[]
[null,"Avg Annual Price for RECO RFP"]
[]
[null,"At Market NUGS",null,{"$f":"$G$273","v":0},{"$f":"ROUND(D279/$D$273,2)","v":0}]
[null,"Hedged Energy",null,{"$f":"$J$273","v":2837364.0000000005},{"$f":"ROUND(D280/$D$273,2)","v":25.84}]
[null,"Unhedged Energy",null,{"$f":"$M$273","v":1197172.3985201542},{"$f":"ROUND(D281/$K$273,2)","v":53.89}]
[null,"Ancillary Services",null,{"$f":"O273","v":195873.29322471836},{"$f":"ROUND(D282/$D$273,2)","v":1.78}]
[null,"Hedged Capacity",null,{"$f":"U273","v":3006198.1598238461},{"$f":"ROUND(D283/$D$273,2)","v":27.37}]
[null,null,null,{"$f":"SUM(D279:D283)","v":7236607.8515687194},{"$f":"SUM(E279:E283)","v":108.88000000000001}]
[null,"MWh",null,{"$f":"$D$273","v":109817}]
[null,"$/MWh",null,{"$f":"ROUND(D284/D285,2)","v":65.900000000000006}]

{"sheet":"Backup Calcs","index":3,"n_rows":106,"n_cols":16,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["SC2 Sales and Demands"]
[]
["Actual Data"]
[null,null,"Percent",null,null,null,null,null,null,null,null,null,null,null,"Number of","Average Use/"]
[null,"Total","Non-Demand","Non-Demand","Demand","Hours",null,"First","Over 5",null,null,null,null,"% of 5kW","Demand Billed","Demand Billed"]
[null,"MWh","Metered","Metered MWh","Metered MWh","Use","kW","5 kW","kW",null,null,null,null,"Per Cust","Customers","Customers"]
[]
["Jan",{"$f":"D8+E8","v":56590.874734426128},{"$f":"ROUND(D8/B8,4)","v":4.3299999999999998E-2},2452.7653675552524,54138.109366870878,{"$f":"E8*1000/G8","v":373.99509911748834},{"$f":"H8+I8","v":144756.19999999978},27387.100000000035,117369.09999999973,null,null,null,null,{"$f":"H8/(O8*5)","v":0.76697020756223},7141.6333333333332,{"$f":"E8/O8*1000","v":7580.6341266756272}]
["Feb",{"$f":"D9+E9","v":45048.834803055688},{"$f":"ROUND(D9/B9,4)","v":5.5500000000000001E-2},2501.7083155254859,42547.1264875302,{"$f":"E9*1000/G9","v":299.70236585409469},{"$f":"H9+I9","v":141964.59999999998},27425.900000000031,114538.69999999995,null,null,null,null,{"$f":"H9/(O9*5)","v":0.76560185357501875},7164.5333333333319,{"$f":"E9/O9*1000","v":5938.5761092879102}]
["Mar",32183.750871403281,6.4299999999999996E-2,2069.8293384760018,30113.921532927281,216.91658070556255,138827.20000000004,25852.700000000041,112974.5,null,null,null,null,0.76881161374101159,6725.3666666666677,4477.6624123979282]
["Apr",46104.576538556139,3.6799999999999999E-2,1698.9187954522224,44405.657743103919,285.94353040598747,155295.20000000004,28847.100000000053,126448.09999999998,null,null,null,null,0.75470857297339888,7644.5666666666639,5808.786773582623]
["May",42354.403045012412,3.2500000000000001E-2,1376.0365633313288,40978.366481681085,278.16718990847659,147315.59999999969,27293.399999999983,120022.19999999969,null,null,null,null,0.76064675253494007,7176.3666666666722,5710.1829358887808]
["Jun",46527.836232255017,2.92E-2,1358.1850642430834,45169.651168011937,281.81626066809116,160280.49999999983,26477.099999999973,133803.39999999985,null,null,null,null,0.74744097637172802,7084.7333333333336,6375.6318047273389]
["Jul",50876.054040435032,3.0300000000000001E-2,1541.0917336100015,49334.962306825029,289.6258977284005,170340.29999999987,26497.399999999991,143842.89999999988,null,null,null,null,0.7489548934165583,7075.8333333333348,6972.3183097621031]
["Aug",54049.896578316992,2.9000000000000001E-2,1566.1857426600004,52483.710835656988,315.12493229109816,166548.90000000034,26519.499999999967,140029.40000000037,null,null,null,null,0.73249856139946945,7240.8333333333358,7248.2970425582189]
["Sep",51025.783302213298,2.7900000000000001E-2,1423.1722717809687,49602.61103043233,296.31968241956349,167395.60000000015,26809.29999999997,140586.30000000019,null,null,null,null,0.74231773837761927,7223.1333333333323,6867.1875128659312]
["Oct",47378.75258003037,3.0200000000000001E-2,1431.4505888921556,45947.301991138214,299.78698535647504,153266.50000000009,26862.900000000074,126403.60000000002,null,null,null,null,0.74838832499094754,7178.8666666666686,6400.3559509585821]
["Nov",42414.99964904724,3.2099999999999997E-2,1362.5965261389645,41052.403122908276,289.04321469695782,142028.59999999977,27052.40000000002,114976.19999999976,null,null,null,null,0.7622255198452208,7098.2666666666692,5783.4405286137826]
["Dec",46830.993544255551,4.4600000000000001E-2,2090.9315077687361,44740.062036486815,306.15338740042262,146136.09999999971,27548.099999999977,118587.99999999974,null,null,null,null,0.76032512695959276,7246.4000000000033,6174.1088038870057]
[]
["Total",{"$f":"SUM(B8:B19)","v":561386.755919007},null,{"$f":"SUM(D8:D19)","v":20872.871815434199},{"$f":"SUM(E8:E19)","v":540513.88410357293},null,{"$f":"SUM(G8:G19)","v":1834155.2999999991},{"$f":"SUM(H8:H19)","v":324572.90000000008},{"$f":"SUM(I8:I19)","v":1509582.3999999994}]
[null,null,null,{"$f":"ROUND(D21/B21,3)","v":3.6999999999999998E-2},{"$f":"ROUND(E21/B21,3)","v":0.96299999999999997}]
[]
["Summer",{"$f":"SUM(B13:B16)","v":202479.57015322032},null,{"$f":"SUM(D13:D16)","v":5888.6348122940535},{"$f":"SUM(E13:E16)","v":196590.93534092628},null,{"$f":"SUM(G13:G16)","v":664565.30000000028},{"$f":"SUM(H13:H16)","v":106303.2999999999},{"$f":"SUM(I13:I16)","v":558262.00000000023}]
["Winter",{"$f":"SUM(B8:B12)+SUM(B17:B19)","v":358907.18576578679},null,{"$f":"SUM(D8:D12)+SUM(D17:D19)","v":14984.237003140146},{"$f":"SUM(E8:E12)+SUM(E17:E19)","v":343922.94876264664},null,{"$f":"SUM(G8:G12)+SUM(G17:G19)","v":1169589.9999999991},{"$f":"SUM(H8:H12)+SUM(H17:H19)","v":218269.60000000021},{"$f":"SUM(I8:I12)+SUM(I17:I19)","v":951320.39999999898}]
[]
[]
["Forecast Data - Without CIEP Expansion"]
[]
[null,null,"Percent",null,null,null,null,null,null,null,null,null,null,null,"Number of","Average Use/"]
[null,"Total","Non-Demand","Non-Demand","Demand","Hours",null,"First","Over 5",null,null,null,null,"% of 5kW","Demand Billed","Demand Billed"]
[null,"MWh","Metered","Metered MWh","Metered MWh","Use","kW","5 kW","kW",null,null,null,null,"Per Cust","Customers","Customers"]
[]
["Jan",37514.5,{"$f":"C8","v":4.3299999999999998E-2},{"$f":"ROUND(B34*C8,0)","v":1624},{"$f":"B34-D34","v":35890.5},{"$f":"F8","v":373.99509911748834},{"$f":"ROUND(E34*1000/F34,0)","v":95965},{"$f":"O34*5*N34","v":18156.096030045275},{"$f":"G34-H34","v":77808.903969954728},null,null,null,null,{"$f":"N8","v":0.76697020756223},{"$f":"E34/P34*1000","v":4734.4983810396925},{"$f":"P8","v":7580.6341266756272}]
["Feb",32174,{"$f":"C9","v":5.5500000000000001E-2},1786,{"$f":"B35-D35","v":30388},{"$f":"F9","v":299.70236585409469},{"$f":"ROUND(E35*1000/F35,0)","v":101394},{"$f":"O35*5*N35","v":19588.120702916585},{"$f":"G35-H35","v":81805.879297083418},null,null,null,null,{"$f":"N9","v":0.76560185357501875},{"$f":"E35/P35*1000","v":5117.0515357163285},{"$f":"P9","v":5938.5761092879102}]
["Mar",33355.5,6.4299999999999996E-2,2145,31210.5,216.91658070556255,143883,26794.108912973825,117088.89108702618,null,null,null,null,0.76881161374101159,6970.266430444407,4477.6624123979282]
["Apr",33731.5,3.6799999999999999E-2,1241,32490.5,285.94353040598747,113626,21106.695637124198,92519.304362875802,null,null,null,null,0.75470857297339888,5593.3366581402652,5808.786773582623]
["May",30094.5,3.2500000000000001E-2,978,29116.5,278.16718990847659,104673,19392.873589903982,85280.126410096011,null,null,null,null,0.76064675253494007,5099.048546588826,5710.1829358887808]
["Jun",32415.5,2.92E-2,947,31468.5,281.81626066809116,111663,18445.89452884789,93217.105471152114,null,null,null,null,0.74744097637172802,4935.7461289823941,6375.6318047273389]
["Jul",36516,3.0300000000000001E-2,1106,35410,289.6258977284005,122261,19018.417976376939,103242.58202362306,null,null,null,null,0.7489548934165583,5078.6551082186888,6972.3183097621031]
["Aug",37831,2.9000000000000001E-2,1097,36734,315.12493229109816,116570,18561.326885791728,98008.673114208272,null,null,null,null,0.73249856139946945,5067.9490346928542,7248.2970425582189]
["Sep",36049,2.7900000000000001E-2,1006,35043,296.31968241956349,118261,18940.097716299806,99320.902283700198,null,null,null,null,0.74231773837761927,5102.9624477772941,6867.1875128659312]
["Oct",33630,3.0200000000000001E-2,1016,32614,299.78698535647504,108791,19067.640158044011,89723.359841955986,null,null,null,null,0.74838832499094754,5095.6540932876396,6400.3559509585821]
["Nov",30360,3.2099999999999997E-2,975,29385,289.04321469695782,101663,19363.903536170994,82299.096463829002,null,null,null,null,0.7622255198452208,5080.8856518220673,5783.4405286137826]
["Dec",33419,4.4600000000000001E-2,1490,31929,306.15338740042262,104291,19659.858410179975,84631.141589820021,null,null,null,null,0.76032512695959276,5171.4346173975109,6174.1088038870057]
[]
["Total",{"$f":"SUM(B34:B45)","v":407090.5},null,{"$f":"SUM(D34:D45)","v":15411},{"$f":"SUM(E34:E45)","v":391679.5},null,{"$f":"SUM(G34:G45)","v":1343041},{"$f":"SUM(H34:H45)","v":238095.03408467519},{"$f":"SUM(I34:I45)","v":1104945.9659153246}]
[null,null,null,{"$f":"ROUND(D47/B47,3)","v":3.7999999999999999E-2},{"$f":"ROUND(E47/B47,3)","v":0.96199999999999997}]
[]
["Summer",{"$f":"SUM(B39:B42)","v":142811.5},null,{"$f":"SUM(D39:D42)","v":4156},{"$f":"SUM(E39:E42)","v":138655.5},null,{"$f":"SUM(G39:G42)","v":468755},{"$f":"SUM(H39:H42)","v":74965.737107316367},{"$f":"SUM(I39:I42)","v":393789.26289268362}]
["Winter",{"$f":"SUM(B34:B38)+SUM(B43:B45)","v":264279},null,{"$f":"SUM(D34:D38)+SUM(D43:D45)","v":11255},{"$f":"SUM(E34:E38)+SUM(E43:E45)","v":253024},null,{"$f":"SUM(G34:G38)+SUM(G43:G45)","v":874286},{"$f":"SUM(H34:H38)+SUM(H43:H45)","v":163129.29697735884},{"$f":"SUM(I34:I38)+SUM(I43:I45)","v":711156.70302264113}]
[]
["Forecast Data - CIEP Figures"]
[]
[null,null,"Percent"]
[null,"Total","Non-Demand","Non-Demand","Demand","Hours",null,"First","Over 5"]
[null,"MWh","Metered","Metered MWh","Metered MWh","Use","kW","5 kW","kW"]
[]
["Jan",null,null,null,4589.3269999999993,null,{"$f":"H59+I59","v":10715.2},102.5,10612.7]
["Feb",null,null,null,4476.7520000000004,null,{"$f":"H60+I60","v":11093.6},102.5,10991.1]
["Mar",null,null,null,4139.4714999999997,null,10941.5,102.5,10839]
["Apr",null,null,null,3950.4549999999999,null,10454.799999999999,102.5,10352.299999999999]
["May",null,null,null,4383.5095000000001,null,10946.7,102.5,10844.2]
["Jun",null,null,null,5049.8019999999997,null,12771.25,102.5,12668.75]
["Jul",null,null,null,5295.7730000000001,null,12834.75,107.5,12727.25]
["Aug",null,null,null,5446.8814999999995,null,12738.55,107.5,12631.05]
["Sep",null,null,null,5278.9205000000002,null,12554.600000000002,107.5,12447.100000000002]
["Oct",null,null,null,4620.6720000000005,null,11883.7,107.5,11776.2]
["Nov",null,null,null,4458.4885000000004,null,11596.3,112.5,11483.8]
["Dec",null,null,null,4399.9174999999996,null,11003.350000000002,102.5,10900.850000000002]
[]
[]
[]
["Forecast Data"]
[null,null,"Percent",null,null,null,null,null,null,null,null,null,null,null,"Number of","Average Use/"]
[null,"Total","Non-Demand","Non-Demand","Demand","Hours",null,"First","Over 5",null,null,null,null,"% of 5kW","Demand Billed","Demand Billed"]
[null,"MWh","Metered","Metered MWh","Metered MWh","Use","kW","5 kW","kW",null,null,null,null,"Per Cust","Customers","Customers"]
[]
["Jan",{"$f":"B34-B59","v":37514.5},null,{"$f":"D34-D59","v":1624},{"$f":"E34-E59","v":31301.173000000003},null,{"$f":"G34-G59","v":85249.8},{"$f":"H34-H59","v":18053.596030045275},{"$f":"I34-I59","v":67196.203969954731},null,null,null,null,{"$f":"N8","v":0.76697020756223},{"$f":"E79/P79*1000","v":4129.0969168204219},{"$f":"P8","v":7580.6341266756272}]
["Feb",{"$f":"B35-B60","v":32174},null,{"$f":"ROUND(B80*C9,0)","v":1786},{"$f":"E35-E60","v":25911.248},null,{"$f":"G35-G60","v":90300.4},19485.620702916585,70814.779297083413,null,null,null,null,{"$f":"N9","v":0.76560185357501875},{"$f":"E80/P80*1000","v":4363.208877541354},{"$f":"P9","v":5938.5761092879102}]
["Mar",33355.5,null,2145,27071.0285,null,132941.5,26691.608912973825,106249.89108702618,null,null,null,null,0.76881161374101159,6045.7948828488425,4477.6624123979282]
["Apr",33731.5,null,1241,28540.044999999998,null,103171.2,21004.195637124198,82167.004362875799,null,null,null,null,0.75470857297339888,4913.2540257451492,5808.786773582623]
["May",30094.5,null,978,24732.9905,null,93726.3,19290.373589903982,74435.926410096014,null,null,null,null,0.76064675253494007,4331.383210956682,5710.1829358887808]
["Jun",32415.5,null,947,26418.698,null,98891.75,18343.39452884789,80548.355471152114,null,null,null,null,0.74744097637172802,4143.698822195367,6375.6318047273389]
["Jul",36516,null,1106,30114.226999999999,null,109426.25,18910.917976376939,90515.332023623065,null,null,null,null,0.7489548934165583,4319.1124762385534,6972.3183097621031]
["Aug",37831,null,1097,31287.1185,null,103831.45,18453.826885791728,85377.623114208269,null,null,null,null,0.73249856139946945,4316.4785212717361,7248.2970425582189]
["Sep",36049,null,1006,29764.0795,null,105706.4,18832.597716299806,86873.802283700192,null,null,null,null,0.74231773837761927,4334.245925895556,6867.1875128659312]
["Oct",33630,null,1016,27993.328000000001,null,96907.3,18960.140158044011,77947.159841955989,null,null,null,null,0.74838832499094754,4373.7142456596403,6400.3559509585821]
["Nov",30360,null,975,24926.511500000001,null,90066.7,19251.403536170994,70815.296463829,null,null,null,null,0.7622255198452208,4309.9797389936284,5783.4405286137826]
["Dec",33419,null,1490,27529.0825,null,93287.65,19557.358410179975,73730.291589820015,null,null,null,null,0.76032512695959276,4458.7945198938896,6174.1088038870057]
[]
["Total",{"$f":"SUM(B79:B90)","v":407090.5},null,{"$f":"SUM(D79:D90)","v":15411},{"$f":"SUM(E79:E90)","v":335589.53},null,{"$f":"SUM(G79:G90)","v":1203506.7},{"$f":"SUM(H79:H90)","v":236835.03408467519},{"$f":"SUM(I79:I90)","v":966671.6659153247}]
[null,null,null,{"$f":"ROUND(D92/B92,3)","v":3.7999999999999999E-2},{"$f":"ROUND(E92/B92,3)","v":0.82399999999999995}]
[]
["Summer",{"$f":"SUM(B84:B87)","v":142811.5},null,{"$f":"SUM(D84:D87)","v":4156},{"$f":"SUM(E84:E87)","v":117584.12299999999},null,{"$f":"SUM(G84:G87)","v":417855.85},{"$f":"SUM(H84:H87)","v":74540.737107316367},{"$f":"SUM(I84:I87)","v":343315.11289268365}]
["Winter",{"$f":"SUM(B79:B83)+SUM(B88:B90)","v":264279},null,{"$f":"SUM(D79:D83)+SUM(D88:D90)","v":11255},{"$f":"SUM(E79:E83)+SUM(E88:E90)","v":218005.40700000001},null,{"$f":"SUM(G79:G83)+SUM(G88:G90)","v":785650.85000000009},{"$f":"SUM(H79:H83)+SUM(H88:H90)","v":162294.29697735884},{"$f":"SUM(I79:I83)+SUM(I88:I90)","v":623356.55302264099}]
[]
[]
[]
["SC1 Blocking Percentages (Rate Case Historical Billing Determinants)"]
[]
[null,null,"2021-06-01","2021-07-01","2021-08-01","2021-09-01","Total","Percentages"]
[]
["First 600 kWh",null,32851109,35132633,35541143,34341562,{"$f":"SUM(C104:F104)","v":137866447},{"$f":"ROUND(G104/G106,4)","v":0.42970000000000003}]
["Over 600 kWh (incl WH)",null,33489610,53006726,55602055,40847365,{"$f":"SUM(C105:F105)","v":182945756},{"$f":"ROUND(G105/G106,4)","v":0.57030000000000003}]
["Total",null,{"$f":"SUM(C104:C105)","v":66340719},88139359,91143198,75188927,320812203,1]