{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input Data","Power Purchased True-Up","2023-24 Overcollection","Alternate Historic PP True-Up","Alt. Historic Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Data","index":0,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[[42,2,42,7],[41,1,41,13],[42,8,42,13],[58,1,58,3],[67,1,67,2],[19,1,19,8],[36,1,36,8],[1,2,1,22],[2,5,2,7],[2,8,2,10],[2,11,2,13],[2,14,2,16],[2,17,2,19],[2,20,2,22],[2,2,2,4]]}
[]
[null,null,"GA Paid on Waltham energy"]
[null,null,2017,null,null,{"$f":"C3+1","v":2018},null,null,{"$f":"F3+1","v":2019},null,null,{"$f":"I3+1","v":2020},null,null,{"$f":"L3+1","v":2021},null,null,{"$f":"O3+1","v":2022},null,null,{"$f":"R3+1","v":2023}]
[null,null,"Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA","Brookfield kWh","GA ($/kWh)","Brookfield GA"]
[null,"January ",2134510,8.2269999999999996E-2,175606.1399999999,2813138,6.7360000000000003E-2,189492.96999999997,2196000,8.0920000000000006E-2,177700.31999999983,2089120,0.10231999999999999,213758.76,1805830,8.2970000000000002E-2,149829.71999999997,857320,4.3529999999999999E-2,37319.140000000014,2581360,5.3769999999999998E-2,138799.72999999998]
[null,"February ",2975320,8.6389999999999995E-2,257037.8899999999,3302320,8.1670000000000006E-2,269700.47999999998,2533990,8.8120000000000004E-2,223295.19999999995,1688900,0.11330999999999999,191369.26,1373740,5.042E-2,69263.969999999972,640680,5.246E-2,33610.069999999949,2016690,8.2489999999999994E-2,166356.76]
[null,"March ",3883530,7.1349999999999997E-2,277089.8600000001,4336290,9.4810000000000005E-2,411123.65999999992,4480180,8.0409999999999995E-2,360251.28,3223950,0.11942,385004.1100000001,2724430,9.0800000000000006E-2,247378.25,2937880,5.9409999999999998E-2,174539.44999999995,2816580,8.0310000000000006E-2,226199.54000000004]
[null,"April",4799720,0.10778,517313.81999999995,4359310,9.9589999999999998E-2,434143.68000000017,2161930,0.12333,266630.83000000007,3323490,0.15057000000000001,500417.89000000013,4398280,0.10934000000000001,480907.93000000005,4152090,8.2930000000000004E-2,344332.82999999996,4255470,9.8530000000000006E-2,419291.45999999996]
[null,"May ",5096570,0.12307,627234.87000000011,5824650,0.10791000000000001,628537.98,573300,0.12604000000000001,72258.729999999981,4369220,0.14718000000000001,643061.80000000005,3333080,0.10054,335107.8600000001,5665250,8.4750000000000006E-2,480129.94000000006,5063950,9.962E-2,504470.69000000006]
[null,"June ",5673460,0.11848,672191.54,5836836,0.11896,694350.00999999989,2446170,0.13728000000000001,335810.2100000002,4206240,0.12839999999999999,540081.22,1333260,8.6319999999999994E-2,115087.01000000001,5632520,7.868E-2,443166.67999999993,2509010,8.2930000000000004E-2,208072.19999999995]
[null,"July ",5380900,0.1128,606965.52,2286590,7.7369999999999994E-2,176913.45999999996,3676680,9.6449999999999994E-2,354615.79000000004,3494520,9.9019999999999997E-2,346027.36999999988,3685060,7.3599999999999999E-2,271220.41000000003,4101700,4.0079999999999998E-2,164396.14000000001,5180845.5999999996,{"$f":"W11/U11","v":4.9489998312244633E-2},{"$f":"128200.02*2","v":256400.04}]
[null,"August ",2756940,0.10109,278699.06000000006,2719400,7.4899999999999994E-2,203683.05999999994,3537380,0.12606999999999999,445957.5,4660990,0.10348,482319.24,4492060,4.5990000000000003E-2,206589.83999999997,2637510,4.9899999999999996E-3,13161.179999999993,5107690,{"$f":"W12/U12","v":7.6059999725903493E-2},{"$f":"194245.45*2","v":388490.9}]
[null,"September ",3210200,8.8639999999999997E-2,284552.13,3075670,8.584E-2,264015.50999999989,2684440,0.12263,329192.87999999989,4094420,0.12175999999999999,498536.58000000007,2697760,7.5649999999999995E-2,204085.54999999993,4344770,3.2410000000000001E-2,140814,3976555.51,5.0930000000000003E-2,202525.97]
[null,"October ",2748080,0.12562999999999999,345241.29000000004,1716320,0.12059,206971.03000000003,2841830,0.1368,388762.34999999986,3886120,0.12806000000000001,497656.53,5203800,5.2440000000000001E-2,272887.27999999997,2424300,5.7709999999999997E-2,139906.34999999998]
[null,"November ",5298050,9.7040000000000001E-2,514122.77,1807480,9.8549999999999999E-2,178127.15999999992,1506800,9.9529999999999993E-2,149971.81000000006,3140570,0.11705,367603.7200000002,3090470,5.4170000000000003E-2,167410.76,419910,6.9889999999999994E-2,29347.509999999776]
[null,"December ",3896110,9.2069999999999999E-2,358714.85000000009,3020740,7.4039999999999995E-2,223655.59000000008,1996200,9.3210000000000001E-2,186065.80000000005,1979050,0.10557999999999999,208948.10000000009,2661390,5.9679999999999997E-2,158831.75000000012,947060,3.4270000000000002E-2,32455.75]
[null,"Total",{"$f":"SUM(C5:C16)","v":47853390},{"$f":"E17/C17","v":0.10270473502504211},{"$f":"SUM(E5:E16)","v":4914769.74},{"$f":"SUM(F5:F16)","v":41098744},{"$f":"H17/F17","v":9.4424165127771298E-2},{"$f":"SUM(H5:H16)","v":3880714.59},{"$f":"SUM(I5:I16)","v":30634900},{"$f":"K17/I17","v":0.10741059053563094},{"$f":"SUM(K5:K16)","v":3290512.7},{"$f":"SUM(L5:L16)","v":40156590},{"$f":"N17/L17","v":0.12139438582807953},{"$f":"SUM(N5:N16)","v":4874784.58},{"$f":"SUM(O5:O16)","v":36799160},{"$f":"Q17/O17","v":7.2789713949992313E-2},{"$f":"SUM(Q5:Q16)","v":2678600.3299999991},{"$f":"SUM(R5:R16)","v":34760990},{"$f":"T17/R17","v":5.8490251284557766E-2},{"$f":"SUM(T5:T16)","v":2033179.0399999996},{"$f":"SUM(U5:U16)","v":33508151.109999999},{"$f":"W17/U17","v":7.4925270623205101E-2},{"$f":"SUM(W5:W16)","v":2510607.2900000005}]
[]
[]
[null,"Loss-Adjusted Customer kWh Volumes"]
[null,null,2017,2018,2019,2020,2021,2022,"2023 (Jan-May)"]
[null,"January ",null,{"$f":"AVERAGE($F22:$H22)/AVERAGE($F$34:$H$34)*D$34","v":19993015.348075904},{"$f":"AVERAGE($F22:$H22)/AVERAGE($F$34:$H$34)*E$34","v":19851792.116210446},18532699.559999999,18108281,21815284,18297978.789999999]
[null,"February ",null,{"$f":"AVERAGE($F23:$H23)/AVERAGE($F$34:$H$34)*D$34","v":18053329.087784704},17925807.078957107,17122074.289999995,17058986,18603883,17127145.93]
[null,"March ",null,17272986.426261805,17150976.468053091,16257560.630000001,16774215,17471575,17018167.98]
[null,"April",null,14320657.567374827,14219501.763265578,14169162.850000001,13283172.32,14418895,14122661.539999999]
[null,"May ",null,13951225.092934867,13852678.822559681,13581227.420000002,13525305.4,13684538,13523423.939999999]
[null,"June ",null,14765624.29764352,14661325.413882347,14310807.100000001,14899498.07,13961934,0]
[null,"July ",null,16704937.038139086,16586939.569745103,17697701.819999997,15280453.51,15864313,0]
[null,"August ",null,16536185.434954928,16419379.965184927,15178815.48,17447380.119999997,15722871,0]
[null,"September ",null,13373983.720246311,13279514.868449477,12631571.830000002,13047454.850000001,13424286,0]
[null,"October ",null,14179379.48732389,14079221.619079199,13822431.74,13724579.729999999,13911145,0]
[null,"November ",null,{"$f":"AVERAGE($F32:$H32)/AVERAGE($F$34:$H$34)*D$34","v":15836289.69133297},15724428.025044452,14799407.27,15438886,16064394.129999999,0]
[null,"December ",null,18642255.807927199,18510573.839568611,18400520.98,18096479,18009867.469999999,0]
[null,"Total",185695254.03,193629869,192262139.55000001,{"$f":"SUM(F22:F33)","v":186503980.97},{"$f":"SUM(G22:G33)","v":186684690.99999997},{"$f":"SUM(H22:H33)","v":192952985.59999999},{"$f":"SUM(I22:I33)","v":80089378.180000007}]
[null,null,177934181,185198705,183512928.40000001]
[]
[null,"RRR Volumes"]
[null,null,2017,2018,2019,2020,2021,2022,2023]
[null,"Total",177934181,185198705,183512928,178353238,182112496,185090366]
[]
[]
[null,"Waltham Volumes (kWh)"]
[null,"Month","Actual",null,null,null,null,null,"Forecast (4-Year Average)"]
[null,null,2017,2018,2019,2020,2021,2022,{"$f":"\"Average \"&$C$44&\" to \"&C44","v":"Average 2017 to 2017"},{"$f":"\"Average \"&$C$44&\" to \"&D44","v":"Average 2017 to 2018"},{"$f":"\"Average \"&$C$44&\" to \"&E44","v":"Average 2017 to 2019"},{"$f":"\"Average \"&C44&\" to \"&F44","v":"Average 2017 to 2020"},{"$f":"\"Average \"&D44&\" to \"&G44","v":"Average 2018 to 2021"},{"$f":"\"Average \"&E44&\" to \"&H44","v":"Average 2019 to 2022"}]
[null,"January ",{"$f":"C5","v":2134510},{"$f":"F5","v":2813138},{"$f":"I5","v":2196000},{"$f":"L5","v":2089120},{"$f":"O5","v":1805830},{"$f":"R5","v":857320},{"$f":"AVERAGE($C45:C45)","v":2134510},{"$f":"AVERAGE($C45:D45)","v":2473824},{"$f":"AVERAGE($C45:E45)","v":2381216},{"$f":"AVERAGE(C45:F45)","v":2308192},{"$f":"AVERAGE(D45:G45)","v":2226022},{"$f":"AVERAGE(E45:H45)","v":1737067.5}]
[null,"February ",2975320,3302320,2533990,1688900,1373740,640680,{"$f":"AVERAGE($C46:C46)","v":2975320},{"$f":"AVERAGE($C46:D46)","v":3138820},{"$f":"AVERAGE($C46:E46)","v":2937210},2625132.5,2224737.5,1559327.5]
[null,"March ",3883530,4336290,4480180,3223950,2724430,2937880,{"$f":"AVERAGE($C47:C47)","v":3883530},{"$f":"AVERAGE($C47:D47)","v":4109910},{"$f":"AVERAGE($C47:E47)","v":4233333.333333333},3980987.5,3691212.5,3341610]
[null,"April",4799720,4359310,2161930,3323490,4398280,4152090,{"$f":"AVERAGE($C48:C48)","v":4799720},{"$f":"AVERAGE($C48:D48)","v":4579515},{"$f":"AVERAGE($C48:E48)","v":3773653.3333333335},3661112.5,3560752.5,3508947.5]
[null,"May ",5096570,5824650,573300,4369220,3333080,5665250,{"$f":"AVERAGE($C49:C49)","v":5096570},{"$f":"AVERAGE($C49:D49)","v":5460610},{"$f":"AVERAGE($C49:E49)","v":3831506.6666666665},3965935,3525062.5,3485212.5]
[null,"June ",5673460,5836836,2446170,4206240,1333260,5632520,{"$f":"AVERAGE($C50:C50)","v":5673460},{"$f":"AVERAGE($C50:D50)","v":5755148},{"$f":"AVERAGE($C50:E50)","v":4652155.333333333},4540676.5,3455626.5,3404547.5]
[null,"July ",5380900,2286590,3676680,3494520,3685060,4101700,{"$f":"AVERAGE($C51:C51)","v":5380900},{"$f":"AVERAGE($C51:D51)","v":3833745},{"$f":"AVERAGE($C51:E51)","v":3781390},3709672.5,3285712.5,3739490]
[null,"August ",2756940,2719400,3537380,4660990,4492060,2637510,{"$f":"AVERAGE($C52:C52)","v":2756940},{"$f":"AVERAGE($C52:D52)","v":2738170},{"$f":"AVERAGE($C52:E52)","v":3004573.3333333335},3418677.5,3852457.5,3831985]
[null,"September ",3210200,3075670,2684440,4094420,2697760,4344770,{"$f":"AVERAGE($C53:C53)","v":3210200},{"$f":"AVERAGE($C53:D53)","v":3142935},{"$f":"AVERAGE($C53:E53)","v":2990103.3333333335},3266182.5,3138072.5,3455347.5]
[null,"October ",2748080,1716320,2841830,3886120,5203800,2424300,{"$f":"AVERAGE($C54:C54)","v":2748080},{"$f":"AVERAGE($C54:D54)","v":2232200},{"$f":"AVERAGE($C54:E54)","v":2435410},2798087.5,3412017.5,3589012.5]
[null,"November ",5298050,1807480,1506800,3140570,3090470,419910,{"$f":"AVERAGE($C55:C55)","v":5298050},{"$f":"AVERAGE($C55:D55)","v":3552765},{"$f":"AVERAGE($C55:E55)","v":2870776.6666666665},2938225,2386330,2039437.5]
[null,"December ",3896110,3020740,1996200,1979050,2661390,947060,{"$f":"AVERAGE($C56:C56)","v":3896110},{"$f":"AVERAGE($C56:D56)","v":3458425},{"$f":"AVERAGE($C56:E56)","v":2971016.6666666665},2723025,2414345,1895925]
[null,"Total",{"$f":"SUM(C45:C56)","v":47853390},{"$f":"SUM(D45:D56)","v":41098744},{"$f":"SUM(E45:E56)","v":30634900},{"$f":"SUM(F45:F56)","v":40156590},36799160,34760990,{"$f":"SUM(I45:I56)","v":47853390},44476067,{"$f":"SUM(K45:K56)","v":39862344.666666657},39935906,{"$f":"SUM(M45:M56)","v":37172348.5},{"$f":"SUM(N45:N56)","v":35587910}]
[]
[null,"Global Adjustment Forecast"]
[null,"RPP Report","$/MWh","RPP Report"]
[null,2019,102.22,"Apr. 2018 Report"]
[null,2020,106.94,"Oct. 2019 Report"]
[null,2021,109.47,"Oct. 2020 Report"]
[null,2022,68.78,"Oct. 2021 Report"]
[null,2023,36.04,"Oct. 2022 Report"]
[null,2024,72.86,"Oct. 2023 Report"]
[]
[null,"DVA Variance Interest Rates"]
[null,null,"Interest"]
[null,"Q1 2019",2.4500000000000002]
[null,"Q2 2019",2.1800000000000002]
[null,"Q3 2019",2.1800000000000002]
[null,"Q4 2019",2.1800000000000002]
[null,"Q1 2020",2.1800000000000002]
[null,"Q2 2020",2.1800000000000002]
[null,"Q3 2020",0.56999999999999995]
[null,"Q4 2020",0.56999999999999995]
[null,"Q1 2021",0.56999999999999995]
[null,"Q2 2021",0.56999999999999995]
[null,"Q3 2021",0.56999999999999995]
[null,"Q4 2021",0.56999999999999995]
[null,"Q1 2022",0.56999999999999995]
[null,"Q2 2022",1.02]
[null,"Q3 2022",2.2000000000000002]
[null,"Q4 2022",3.87]
[null,"Q1 2023",4.7300000000000004]
[null,"Q2 2023",4.9800000000000004]
[null,"Q3 2023",4.9800000000000004]
[null,"Q4 2023",5.49]

{"sheet":"Power Purchased True-Up","index":1,"n_rows":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":false,"merged":[[44,1,56,1],[45,22,54,22],[1,6,1,20],[4,2,4,4],[19,22,28,22],[32,22,41,22],[31,1,43,1],[5,1,17,1],[18,1,30,1],[6,22,15,22]]}
[]
[null,null,null,null,null,null,"Power Purchased True-Up Rate"]
[null,null,null,null,null,null,null,"Customer Volumes (kWh)","Rate ($/kWh)","Credited to Customers","GA Savings","Purchasd Power Adjustmnet","Net GA Savings","Variance Disposition & Overcollection","Owed to Customers","Variance","Cumulative Variance","Interest %","Interest $","Lagged Interest","Lagged Interest"]
[null,null,null,null,null,null,null,"A","B","C = A * B","D","E = D / 2","F = D / 2","G","H = F + G","I = H - C","J","K","L = J * L"]
[null,null,"Power Purchased True-Up Balance and Rate Calculations",null,null,"Notes",null,"Total Customer kWh Volumes (metered)","Forecast rate (changes each May)","Actual amount credited to customers","Actual avoided GA (Waltham volumes * GA $/kWh)","Actual half paid to Brookfield","Actual half to be credited to customers","Adjustment for audited variances (3-year lag) and Overcollection","Actual amount to be credit to customers, including variances and overcollection","Difference between what was actually credited to customers and what should be","Cumulative variance used to calculate variances","OEB's DVA interest rate","Monthly interest on variances","Monthly interest on variances in lag year 1","Monthly interest on variances in lag year 2"]
["z",2024,null,"Forecast Data",null,null,"January "]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!N57","v":35587910},null,"2019-2022 Average Waltham Volumes","February ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C66/1000","v":7.2859999999999994E-2},null,"Oct. 2023 RPP Report","March ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GA Savings on Waltham Energy",null,{"$f":"K18","v":0},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D7*D8","v":2592935.1225999999},null,null,"April",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchased Power-Adjustment",null,{"$f":"L18","v":0},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D9/2","v":1296467.5612999999},"Total savings * 50%","May ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Customer Share",{"$f":"M18","v":0},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,null,"(No variance in this year)","June ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variance Disposition",null,null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,null,{"$f":"F11","v":"(No variance in this year)"},"July ",null,{"$f":"E17","v":-7.0000000000000001E-3},{"$f":"H12*I12","v":0},null,{"$f":"-K12/2","v":0},{"$f":"-K12/2","v":0},null,{"$f":"M12+N12","v":0},{"$f":"O12-J12","v":0},{"$f":"P12+Q11","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"Q12*R12","v":0},null,null,null,null,"Owed to Customers",null,{"$f":"Y11+Y10","v":0},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E10:E12)","v":1296467.5612999999},null,"August ",null,{"$f":"I12","v":-7.0000000000000001E-3},0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,null,null,null,null,"Credited to Customers",null,{"$f":"J18","v":0},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",null,-7.0000000000000001E-3,0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,null,null,null,null,"Variance",null,{"$f":"Z12-Z13","v":0},"Variance to be disposed in 2027"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!H39","v":185090366},null,"2022 Actual Volumes (RRR values in IRM model)","October ",null,-7.0000000000000001E-3,0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,null,null,null,null,"Interest on Variance",null,{"$f":"S18+T31+U44","v":0},"Interest on variance to be disposed in 2027"]
[null,null,null,null,null,null,"November ",null,-7.0000000000000001E-3,0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0]
[null,null,"Power Purchased True-Up-2024 ($/kWh)",null,{"$f":"ROUND(-E13/D15,4)","v":-7.0000000000000001E-3},null,"December ",null,-7.0000000000000001E-3,0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H17)","v":0},null,{"$f":"SUM(J6:J17)","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(S6:S17)","v":0}]
[null,2025,null,null,null,null,"January ",null,{"$f":"I17","v":-7.0000000000000001E-3},{"$f":"H19*I19","v":0},null,{"$f":"-K19/2","v":0},{"$f":"-K19/2","v":0},null,{"$f":"M19+N19","v":0},{"$f":"O19-J19","v":0},{"$f":"P19","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"Q19*R19","v":0},{"$f":"(P18+S18)*R19","v":0}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!M84","v":0},null,"2020-2023 Average Waltham Volumes","February ",null,{"$f":"I19","v":-7.0000000000000001E-3},0,null,0,0,null,{"$f":"M20+N20","v":0},0,{"$f":"P20+Q19","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P18+S18)*R20","v":0},null,null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C92/1000","v":0},null,"Oct. 2024 RPP Report","March ",null,{"$f":"I20","v":-7.0000000000000001E-3},0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P18+S18)*R21","v":0},null,null,null,"GA Savings",null,{"$f":"K31","v":0},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D20*D21","v":0},null,null,"April",null,{"$f":"I21","v":-7.0000000000000001E-3},0,null,0,0,null,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P18+S18)*R22","v":0},null,null,null,"Purchased Power-Adjustment",null,{"$f":"L31","v":0},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D22/2","v":0},"Total savings * 50%","May ",null,{"$f":"E30","v":-2.3999999999999998E-3},0,null,0,0,{"$f":"($E$26)/12","v":37169.084594542917},37169.084594542917,37169.084594542917,37169.084594542917,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},119.87029781740091,{"$f":"(P18+S18)*R23","v":0},null,null,null,"Customer Share",{"$f":"M31","v":0},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,null,"(No variance in this year)","June ",null,{"$f":"I23","v":-2.3999999999999998E-3},0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,74338.169189085835,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},239.74059563480182,{"$f":"(P18+S18)*R24","v":0},null,null,null,"Variance Disposition",null,null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,null,{"$f":"F24","v":"(No variance in this year)"},"July ",null,{"$f":"I24","v":-2.3999999999999998E-3},0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,111507.25378362875,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},359.61089345220273,{"$f":"(P18+S18)*R25","v":0},null,null,null,"Owed to Customers",null,{"$f":"Y24+Y23","v":0},"Amount to be credited to customers including variances"]
[null,null,"Dispostion of 2023 Overcollection",null,{"$f":"-'2023-24 Overcollection'!P9-'2023-24 Overcollection'!P10","v":446029.01513451501},"Actual 2023 Overcollection","August ",null,-2.3999999999999998E-3,0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P18+S18)*R26","v":0},null,null,null,"Credited to Customers",null,{"$f":"J31","v":0},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E23:E26)","v":446029.01513451501},null,"September ",null,-2.3999999999999998E-3,0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,185845.42297271459,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},599.35148908700455,{"$f":"(P18+S18)*R27","v":0},null,null,null,"Variance",null,{"$f":"Z25-Z26","v":0},"Variance to be disposed in 2027"]
[null,null,null,null,null,null,"October ",null,-2.3999999999999998E-3,0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,223014.5075672575,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},719.22178690440546,{"$f":"(P18+S18)*R28","v":0},null,null,null,"Interest on Variance",null,{"$f":"S31+T44+U57","v":28116.239658325198},"Interest on variance to be disposed in 2027"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"D15","v":185090366},null,"2023 Actual Volumes (RRR values in IRM model)","November ",null,-2.3999999999999998E-3,0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,260183.59216180042,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},839.09208472180637,{"$f":"(P18+S18)*R29","v":0}]
[null,null,"Power Purchased True-Up-2025 ($/kWh)",null,{"$f":"ROUND(-E27/D29,4)","v":-2.3999999999999998E-3},null,"December ",null,-2.3999999999999998E-3,0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,297352.67675634334,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},958.96238253920728,{"$f":"(P18+S18)*R30","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H19:H30)","v":0},null,{"$f":"SUM(J19:J30)","v":0},0,0,0,297352.67675634334,297352.67675634334,297352.67675634334,null,null,{"$f":"SUM(S19:S30)","v":4315.3307214264332},{"$f":"SUM(T19:T30)","v":0}]
[null,2026,null,null,null,null,"January ",null,{"$f":"I30","v":-2.3999999999999998E-3},{"$f":"H32*I32","v":0},null,{"$f":"-K32/2","v":0},{"$f":"-K32/2","v":0},37169.084594542917,{"$f":"M32+N32","v":37169.084594542917},{"$f":"O32-J32","v":37169.084594542917},{"$f":"P32","v":37169.084594542917},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"Q32*R32","v":119.87029781740091},{"$f":"(P31+S31)*R32","v":972.87932411580744},{"$f":"(P18+S18+T31)*R32","v":0}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!M97","v":0},null,"2021-2024 Average Waltham Volumes","February ",null,{"$f":"I32","v":-2.3999999999999998E-3},0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,{"$f":"P33+Q32","v":74338.169189085835},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},239.74059563480182,{"$f":"(P31+S31)*R33","v":972.87932411580744},{"$f":"(P18+S18+T31)*R33","v":0},null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C105/1000","v":0},null,"Oct. 2024 RPP Report","March ",null,{"$f":"I33","v":-2.3999999999999998E-3},0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,111507.25378362875,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},359.61089345220273,{"$f":"(P31+S31)*R34","v":972.87932411580744},{"$f":"(P18+S18+T31)*R34","v":0},null,null,"GA Savings",null,{"$f":"K44","v":0},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D33*D34","v":0},null,null,"April",null,{"$f":"I34","v":-2.3999999999999998E-3},0,null,0,0,37169.084594542917,37169.084594542917,37169.084594542917,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R35","v":972.87932411580744},{"$f":"(P18+S18+T31)*R35","v":0},null,null,"Purchased Power-Adjustment",null,{"$f":"L44","v":0},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D35/2","v":0},"Total savings * 50%","May ",null,{"$f":"E43","v":0},0,null,0,0,{"$f":"($E$39)/12","v":0},0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R36","v":972.87932411580744},{"$f":"(P18+S18+T31)*R36","v":0},null,null,"Customer Share",{"$f":"M44","v":0},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,null,"(No variance in this year)","June ",null,{"$f":"I36","v":0},0,null,0,0,{"$f":"($E$39)/12","v":0},0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R37","v":972.87932411580744},{"$f":"(P18+S18+T31)*R37","v":0},null,null,"Variance Disposition",{"$f":"Z14+Z15","v":0},null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,null,{"$f":"F37","v":"(No variance in this year)"},"July ",null,{"$f":"I37","v":0},0,null,0,0,{"$f":"($E$39)/12","v":0},0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R38","v":972.87932411580744},{"$f":"(P18+S18+T31)*R38","v":0},null,null,"Owed to Customers",null,{"$f":"Y37+Y36","v":0},"Amount to be credited to customers including variances"]
[null,null,"Dispostion of 2024 Overcollection",null,{"$f":"-'2023-24 Overcollection'!P22-'2023-24 Overcollection'!P23","v":0},"Actual 2024 Overcollection","August ",null,0,0,null,0,0,{"$f":"($E$39)/12","v":0},0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R39","v":972.87932411580744},{"$f":"(P18+S18+T31)*R39","v":0},null,null,"Credited to Customers",null,{"$f":"J44","v":0},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E36:E39)","v":0},null,"September ",null,0,0,null,0,0,{"$f":"($E$39)/12","v":0},0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R40","v":972.87932411580744},{"$f":"(P18+S18+T31)*R40","v":0},null,null,"Variance",null,{"$f":"Z38-Z39","v":0},"Variance to be disposed in 2028"]
[null,null,null,null,null,null,"October ",null,0,0,null,0,0,0,0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R41","v":972.87932411580744},{"$f":"(P18+S18+T31)*R41","v":0},null,null,"Interest on Variance",null,{"$f":"S44+T57+U70","v":10983.163985638486},"Interest on variance to be disposed in 2028"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"D29","v":185090366},null,"2024 Actual Volumes (RRR values in IRM model)","November ",null,0,0,null,0,0,0,0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R42","v":972.87932411580744},{"$f":"(P18+S18+T31)*R42","v":0}]
[null,null,"Power Purchased True-Up-2026 ($/kWh)",null,{"$f":"ROUND(-E40/D42,4)","v":0},null,"December ",null,0,0,null,0,0,0,0,0,148676.33837817167,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},479.48119126960364,{"$f":"(P31+S31)*R43","v":972.87932411580744},{"$f":"(P18+S18+T31)*R43","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H32:H43)","v":0},null,{"$f":"SUM(J32:J43)","v":0},0,0,0,148676.33837817167,148676.33837817167,148676.33837817167,null,null,{"$f":"SUM(S32:S43)","v":5034.5525083308385},{"$f":"SUM(T32:T43)","v":11674.55188938969},{"$f":"SUM(U32:U43)","v":0}]
[null,2027,null,null,null,null,"January ",null,{"$f":"I43","v":0},{"$f":"H45*I45","v":0},null,0,{"$f":"-K45/2","v":0},{"$f":"($E$39)/12","v":0},{"$f":"M45+N45","v":0},{"$f":"O45-J45","v":0},{"$f":"P45","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"Q45*R45","v":0},{"$f":"(P44+S44)*R45","v":495.7176231089706},{"$f":"(P31+S31+T44)*R45","v":1010.5297539590892}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!N97","v":0},null,"2022-2025 Average Waltham Volumes","February ",null,{"$f":"I45","v":0},0,null,0,0,0,0,0,{"$f":"P46+Q45","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R46","v":495.7176231089706},{"$f":"(P31+S31+T44)*R46","v":1010.5297539590892},null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C116/1000","v":0},null,"Oct. 2025 RPP Report","March ",null,{"$f":"I46","v":0},0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R47","v":495.7176231089706},{"$f":"(P31+S31+T44)*R47","v":1010.5297539590892},null,null,"GA Savings",null,{"$f":"K57","v":0},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D46*D47","v":0},null,null,"April",null,{"$f":"I47","v":0},0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R48","v":495.7176231089706},{"$f":"(P31+S31+T44)*R48","v":1010.5297539590892},null,null,"Purchased Power-Adjustment",null,{"$f":"L57","v":0},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D48/2","v":0},"Total savings * 50%","May ",null,{"$f":"E55","v":0},0,null,0,0,{"$f":"($E$50+$E$51)/12","v":0},0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R49","v":495.7176231089706},{"$f":"(P31+S31+T44)*R49","v":1010.5297539590892},null,null,"Customer Share",{"$f":"M57","v":0},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,{"$f":"Z14","v":0},"Audited Variance from 2024","June ",null,{"$f":"I49","v":0},0,null,0,0,{"$f":"($E$50+$E$51)/12","v":0},0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R50","v":495.7176231089706},{"$f":"(P31+S31+T44)*R50","v":1010.5297539590892},null,null,"Variance Disposition",{"$f":"Z27+Z28","v":28116.239658325198},null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,{"$f":"Z15","v":0},"Interest on variance from 2024","July ",null,{"$f":"I50","v":0},0,null,0,0,{"$f":"($E$50+$E$51)/12","v":0},0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R51","v":495.7176231089706},{"$f":"(P31+S31+T44)*R51","v":1010.5297539590892},null,null,"Owed to Customers",null,{"$f":"Y50+Y49","v":28116.239658325198},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E49:E51)","v":0},null,"August ",null,0,0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R52","v":495.7176231089706},{"$f":"(P31+S31+T44)*R52","v":1010.5297539590892},null,null,"Credited to Customers",null,{"$f":"J57","v":0},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",null,0,0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R53","v":495.7176231089706},{"$f":"(P31+S31+T44)*R53","v":1010.5297539590892},null,null,"Variance",null,{"$f":"Z51-Z52","v":28116.239658325198},"Variance to be disposed in 2029"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"D42","v":185090366},null,"2025 Actual Volumes (RRR values in IRM model)","October ",null,0,0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R54","v":495.7176231089706},{"$f":"(P31+S31+T44)*R54","v":1010.5297539590892},null,null,"Interest on Variance",null,{"$f":"S57+T70+U83","v":0},"Interest on variance to be disposed in 2029"]
[null,null,"Power Purchased True-Up-2027 ($/kWh)",null,{"$f":"ROUND(-E52/D54,4)","v":0},null,"November ",null,0,0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R55","v":495.7176231089706},{"$f":"(P31+S31+T44)*R55","v":1010.5297539590892}]
[null,null,null,null,null,null,"December ",null,0,0,null,0,0,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(P44+S44)*R56","v":495.7176231089706},{"$f":"(P31+S31+T44)*R56","v":1010.5297539590892}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H45:H56)","v":0},null,{"$f":"SUM(J45:J56)","v":0},{"$f":"SUM(K45:K56)","v":0},{"$f":"SUM(L45:L56)","v":0},{"$f":"SUM(M45:M56)","v":0},{"$f":"SUM(N45:N56)","v":0},{"$f":"SUM(O45:O56)","v":0},{"$f":"SUM(P45:P56)","v":0},null,null,{"$f":"SUM(S45:S56)","v":0},{"$f":"SUM(T45:T56)","v":5948.611477307647},{"$f":"SUM(U45:U56)","v":12126.357047509075}]

{"sheet":"2023-24 Overcollection","index":2,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,1,42,1],[1,2,1,10],[4,1,16,1],[17,1,29,1]]}
[]
[null,null,"2023/24 Overcollection "]
[null,null,null,"GA Savings","Purchasd Power Adjustmnet","Customer Share","Owed to Customers","Cumulative Credit","Interest %","Interest $","Lagged Interest"]
[null,null,null,"A","B = A / 2","C = A / 2","D = C","E","F","G = E * F"]
[null,2023,"January ",null,{"$f":"-D5/2","v":0},{"$f":"-D5/2","v":0},{"$f":"F5","v":0},{"$f":"G5","v":0},{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},{"$f":"H5*I5","v":0}]
[null,null,"February ",null,0,0,0,{"$f":"H5+G6","v":0},{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},0,null,null,"Summary"]
[null,null,"March ",null,0,0,0,0,{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},0,null,null,null,"GA Savings on Waltham Energy",null,{"$f":"D17","v":847416.91},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"April",null,0,0,0,0,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},0,null,null,null,"Purchased Power-Adjustment",null,{"$f":"E17","v":-423708.45500000002},"Paid to Brookfield"]
[null,null,"May ",null,0,0,0,0,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},0,null,null,null,"Customer Share Owed to Customers",null,{"$f":"F17","v":-423708.45500000002},"Amount to be credited to customers in 2025"]
[null,null,"June ",null,0,0,0,0,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},0,null,null,null,"Interest",null,{"$f":"J17+K30","v":-22320.560134514984},"Interest on balance owed to customers in 2025"]
[null,null,"July ",{"$f":"'Input Data'!W11","v":256400.04},{"$f":"-D11/2","v":-128200.02},-128200.02,-128200.02,-128200.02,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},-235.03337000000002]
[null,null,"August ",{"$f":"'Input Data'!W12","v":388490.9},-194245.45,-194245.45,-194245.45,-322445.47000000003,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},-591.15002833333347]
[null,null,"September ",{"$f":"'Input Data'!W13","v":202525.97},-101262.985,-101262.985,-101262.985,-423708.45500000002,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},-776.79883416666678]
[null,null,"October ",{"$f":"'Input Data'!W14","v":0},0,0,0,-423708.45500000002,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},-1366.459767375]
[null,null,"November ",{"$f":"'Input Data'!W15","v":0},0,0,0,-423708.45500000002,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},-1366.459767375]
[null,null,"December ",{"$f":"'Input Data'!W16","v":0},0,0,0,-423708.45500000002,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},-1366.459767375]
[null,null,"Total",{"$f":"SUM(D5:D16)","v":847416.91},{"$f":"SUM(E5:E16)","v":-423708.45500000002},{"$f":"SUM(F5:F16)","v":-423708.45500000002},{"$f":"SUM(G5:G16)","v":-423708.45500000002},null,null,{"$f":"SUM(J5:J16)","v":-5702.361534624999},{"$f":"SUM(K5:K16)","v":0}]
[null,2024,"January ",null,{"$f":"-D18/2","v":0},{"$f":"-D18/2","v":0},0,{"$f":"G18","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"H18*I18","v":0},{"$f":"(H16+J17)*I18","v":-1384.8498833241656}]
[null,null,"February ",null,0,0,0,{"$f":"H18+G19","v":0},{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I19","v":-1384.8498833241656},null,"Summary"]
[null,null,"March ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I20","v":-1384.8498833241656},null,null,"GA Savings on Waltham Energy",null,{"$f":"D30","v":0},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"April",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I21","v":-1384.8498833241656},null,null,"Purchased Power-Adjustment",null,{"$f":"E30","v":0},"Paid to Brookfield"]
[null,null,"May ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I22","v":-1384.8498833241656},null,null,"Customer Share Owed to Customers",null,{"$f":"F30","v":0},"Amount to be credited to customers in 2026"]
[null,null,"June ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I23","v":-1384.8498833241656},null,null,"Interest",null,{"$f":"J30+K43","v":0},"Interest on balance owed to customers in 2026"]
[null,null,"July ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I24","v":-1384.8498833241656}]
[null,null,"August ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I25","v":-1384.8498833241656}]
[null,null,"September ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I26","v":-1384.8498833241656}]
[null,null,"October ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I27","v":-1384.8498833241656}]
[null,null,"November ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I28","v":-1384.8498833241656}]
[null,null,"December ",null,0,0,0,0,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H16+J17)*I29","v":-1384.8498833241656}]
[null,null,"Total",{"$f":"SUM(D18:D29)","v":0},{"$f":"SUM(E18:E29)","v":0},{"$f":"SUM(F18:F29)","v":0},{"$f":"SUM(G18:G29)","v":0},null,null,{"$f":"SUM(J18:J29)","v":0},{"$f":"SUM(K18:K29)","v":-16618.198599889984}]
[null,2025,"January ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},{"$f":"H31*I31","v":0},{"$f":"(H29+J30)*I31","v":0}]
[null,null,"February ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I32","v":0}]
[null,null,"March ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I33","v":0}]
[null,null,"April",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I34","v":0}]
[null,null,"May ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I35","v":0}]
[null,null,"June ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I36","v":0}]
[null,null,"July ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I37","v":0}]
[null,null,"August ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I38","v":0}]
[null,null,"September ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I39","v":0}]
[null,null,"October ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I40","v":0}]
[null,null,"November ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I41","v":0}]
[null,null,"December ",null,null,null,null,null,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},0,{"$f":"(H29+J30)*I42","v":0}]
[null,null,"Total",{"$f":"SUM(D31:D42)","v":0},{"$f":"SUM(E31:E42)","v":0},{"$f":"SUM(F31:F42)","v":0},{"$f":"SUM(G31:G42)","v":0},null,null,{"$f":"SUM(J31:J42)","v":0},{"$f":"SUM(K31:K42)","v":0}]

{"sheet":"Alternate Historic PP True-Up","index":3,"n_rows":96,"n_cols":27,"rows_kept":96,"cut":false,"hidden":false,"merged":[[58,22,67,22],[1,2,1,3],[6,22,15,22],[19,22,28,22],[31,1,43,1],[32,22,41,22],[45,22,54,22],[44,1,56,1],[57,1,69,1],[1,6,1,20],[4,2,4,4],[5,1,17,1],[18,1,30,1]]}
[]
[null,null,"Calcultion as if GA was not applied to Waltham before July 2023",null,null,"Input Cells","Power Purchased True-Up Rate"]
[null,null,null,null,null,null,null,"Customer Volumes (kWh)","Rate ($/kWh)","Credited to Customers","GA Savings","Purchasd Power Adjustmnet","Net GA Savings","Variance Disposition & Overcollection","Owed to Customers","Variance","Cumulative Variance","Interest %","Interest $","Lagged Interest","Lagged Interest"]
[null,null,null,null,null,null,null,"A","B","C = A * B","D","E = D / 2","F = D / 2","G","H","I = H - C","J","K","L = J * L"]
[null,null,"Forecast Power Purchased True-Up Balance and Rate Calculations",null,null,"Notes",null,"Total Customer kWh Volumes (metered)","Forecast rate (changes each May)","Actual amount credited to customers","Actual avoided GA (Waltham volumes * GA $/kWh)","Actual half paid to Brookfield","Actual half to be credited to customers","Adjustment for audited variances (3-year lag) and Overcollection","Actual amount to be credit to customers, including variances and overcollection","Difference between what was actually credited to customers and what should be","Cumulative variance used to calculate variances","OEB's DVA interest rate","Monthly interest on variances","Monthly interest on variances in lag year 1","Monthly interest on variances in lag year 2"]
[null,2019,null,null,null,null,"January ",{"$f":"'Input Data'!E22/1.041","v":19069925.183679584},{"$f":"E16","v":-1.37E-2},{"$f":"H6*I6","v":-261257.97501641032},{"$f":"'Input Data'!K5","v":177700.31999999983},{"$f":"-K6/2","v":-88850.159999999916},{"$f":"-K6/2","v":-88850.159999999916},null,{"$f":"M6+N6","v":-88850.159999999916},{"$f":"O6-J6","v":172407.8150164104},{"$f":"P6","v":172407.8150164104},{"$f":"'Input Data'!$C$70/100/12","v":2.0416666666666669E-3},{"$f":"Q6*R6","v":351.99928899183794}]
[null,null,null,"Forecast Data",null,null,"February ",{"$f":"'Input Data'!E23/1.041","v":17219795.464896359},{"$f":"I6","v":-1.37E-2},-235911.19786908012,{"$f":"'Input Data'!K6","v":223295.19999999995},-111647.59999999998,-111647.59999999998,null,{"$f":"M7+N7","v":-111647.59999999998},{"$f":"O7-J7","v":124263.59786908014},{"$f":"P7+Q6","v":296671.41288549057},{"$f":"'Input Data'!$C$70/100/12","v":2.0416666666666669E-3},605.70413464120998,null,null,null,"Summary"]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!I57","v":47853390},null,"4-Year Avg.","March ",{"$f":"'Input Data'!E24/1.041","v":16475481.717630252},-1.37E-2,-225714.09953153445,{"$f":"'Input Data'!K7","v":360251.28},-180125.64,-180125.64,null,-180125.64,45588.459531534434,342259.87241702504,{"$f":"'Input Data'!$C$70/100/12","v":2.0416666666666669E-3},698.7805728514262,null,null,null,null,"GA Savings on Waltham Energy",null,{"$f":"K18","v":3290512.7},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C61/1000","v":0.10222000000000001},null,"Apr 2018 RPP Report","April",{"$f":"'Input Data'!E25/1.041","v":13659463.749534657},-1.37E-2,-187134.6533686248,{"$f":"'Input Data'!K8","v":266630.83000000007},-133315.41500000004,-133315.41500000004,null,-133315.41500000004,53819.238368624763,396079.1107856498,{"$f":"'Input Data'!$C$71/100/12","v":1.8166666666666667E-3},719.54371792726386,null,null,null,null,"Purchased Power-Adjustment",null,{"$f":"L18","v":-1645256.35},"Paid to Brookfield"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D8*D9","v":4891573.5257999999},null,null,"May ",{"$f":"'Input Data'!E26/1.041","v":13307088.206109205},-1.37E-2,-182307.1084236961,{"$f":"'Input Data'!K9","v":72258.729999999981},-36129.364999999991,-36129.364999999991,null,-36129.364999999991,146177.74342369611,542256.85420934588,{"$f":"'Input Data'!$C$71/100/12","v":1.8166666666666667E-3},985.09995181364502,null,null,null,null,"Customer Share",{"$f":"M18","v":-1645256.35},null,"Amount that should be credited to customers"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D10/2","v":2445786.7629},"Total savings * 50%","June ",{"$f":"'Input Data'!E27/1.041","v":14083886.084421083},-1.37E-2,-192949.23935656884,{"$f":"'Input Data'!K10","v":335810.2100000002},-167905.1050000001,-167905.1050000001,null,-167905.1050000001,25044.134356568742,567300.98856591457,{"$f":"'Input Data'!$C$71/100/12","v":1.8166666666666667E-3},1030.5967958947449,null,null,null,null,"Variance Disposition",null,null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"E11","v":2445786.7629},null,"July ",{"$f":"'Input Data'!E28/1.041","v":15933659.529053895},-1.37E-2,-218291.13554803838,{"$f":"'Input Data'!K11","v":354615.79000000004},-177307.89500000002,-177307.89500000002,null,-177307.89500000002,40983.24054803836,608284.22911395296,{"$f":"'Input Data'!$C$72/100/12","v":1.8166666666666667E-3},1105.0496828903479,null,null,null,null,"Owed to Customers",null,{"$f":"Y11+Y10","v":-1645256.35},"Amount to be credited to customers including variances"]
[null,null,null,null,null,null,"August ",{"$f":"'Input Data'!E29/1.041","v":15772699.294125771},-1.37E-2,-216085.98032952307,{"$f":"'Input Data'!K12","v":445957.5},-222978.75,-222978.75,null,-222978.75,-6892.7696704769332,601391.45944347605,{"$f":"'Input Data'!$C$72/100/12","v":1.8166666666666667E-3},1092.5278179889815,null,null,null,null,"Credited to Customers",null,{"$f":"J18","v":-2530251.0200144099},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!C39","v":177934181},null,"2017 Volumes","September ",{"$f":"'Input Data'!E30/1.041","v":12756498.432708433},-1.37E-2,-174764.02852810553,{"$f":"'Input Data'!K13","v":329192.87999999989},-164596.43999999994,-164596.43999999994,null,-164596.43999999994,10167.588528105582,611559.04797158157,{"$f":"'Input Data'!$C$72/100/12","v":1.8166666666666667E-3},1110.9989371483732,null,null,null,null,"Variance",null,{"$f":"Z12-Z13","v":884994.67001440981},"Variance to be disposed in 2022"]
[null,null,null,null,null,null,"October ",{"$f":"'Input Data'!E31/1.041","v":13524708.567799423},-1.37E-2,-185288.50737885211,{"$f":"'Input Data'!K14","v":388762.34999999986},-194381.17499999993,-194381.17499999993,null,-194381.17499999993,-9092.6676211478189,602466.38035043376,{"$f":"'Input Data'!$C$73/100/12","v":1.8166666666666667E-3},1094.4805909699546,null,null,null,null,"Interest on Variance",null,{"$f":"S18+T31+U44","v":29248.42606476213},"Interest on variance to be disposed in 2022"]
[null,null,"Power Purchased True-Up-2019 ($/kWh)",null,{"$f":"ROUND(-E12/D14,4)","v":-1.37E-2},null,"November ",{"$f":"'Input Data'!E32/1.041","v":15105118.179677669},-1.37E-2,-206940.11906158406,{"$f":"'Input Data'!K15","v":149971.81000000006},-74985.905000000028,-74985.905000000028,null,-74985.905000000028,131954.21406158403,734420.59441201785,{"$f":"'Input Data'!$C$73/100/12","v":1.8166666666666667E-3},1334.1974131818324]
[null,null,null,null,null,null,"December ",{"$f":"'Input Data'!E33/1.041","v":17781531.065868024},-1.37E-2,-243606.97560239193,{"$f":"'Input Data'!K16","v":186065.80000000005},-93032.900000000023,-93032.900000000023,null,-93032.900000000023,150574.07560239191,884994.67001440981,{"$f":"'Input Data'!$C$73/100/12","v":1.8166666666666667E-3},1607.7403171928445]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H17)","v":184689855.47550434},null,{"$f":"SUM(J6:J17)","v":-2530251.0200144099},3290512.7,-1645256.35,-1645256.35,0,-1645256.35,884994.67001440981,null,null,{"$f":"SUM(S6:S17)","v":11736.719221492465}]
[null,2020,null,null,null,null,"January ",{"$f":"'Input Data'!F22/1.041","v":17802785.360230546},{"$f":"E16","v":-1.37E-2},{"$f":"H19*I19","v":-243898.15943515848},{"$f":"'Input Data'!N5","v":213758.76},{"$f":"-K19/2","v":-106879.38},{"$f":"-K19/2","v":-106879.38},null,{"$f":"M19+N19","v":-106879.38},{"$f":"O19-J19","v":137018.77943515847},{"$f":"P19","v":137018.77943515847},{"$f":"'Input Data'!$C$74/100/12","v":1.8166666666666667E-3},{"$f":"Q19*R19","v":248.91744930720458},{"$f":"(P18+S18)*R19","v":1629.0620237785558}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!J57","v":44476067},null,"4-Year Avg.","February ",{"$f":"'Input Data'!F23/1.041","v":16447717.857829006},{"$f":"I19","v":-1.37E-2},-225333.73465225741,{"$f":"'Input Data'!N6","v":191369.26},-95684.63,-95684.63,null,-95684.63,129649.1046522574,{"$f":"P20+Q19","v":266667.88408741588},{"$f":"'Input Data'!$C$74/100/12","v":1.8166666666666667E-3},484.44665609213888,{"$f":"(P18+S18)*R20","v":1629.0620237785558},null,null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C62/1000","v":0.10693999999999999},null,"Oct 2019 RPP Report","March ",{"$f":"'Input Data'!F24/1.041","v":15617253.246878004},{"$f":"I20","v":-1.37E-2},-213956.36948222865,{"$f":"'Input Data'!N7","v":385004.1100000001},-192502.05500000005,-192502.05500000005,null,-192502.05500000005,21454.314482228598,288122.19856964448,{"$f":"'Input Data'!$C$74/100/12","v":1.8166666666666667E-3},523.42199406818747,{"$f":"(P18+S18)*R21","v":1629.0620237785558},null,null,null,"GA Savings on Waltham Energy",null,{"$f":"K31","v":4874784.58},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D20*D21","v":4756270.6049799994},null,null,"April",{"$f":"'Input Data'!F25/1.041","v":13611107.444764651},{"$f":"I21","v":-1.37E-2},-186472.17199327573,{"$f":"'Input Data'!N8","v":500417.89000000013},-250208.94500000007,-250208.94500000007,null,-250208.94500000007,-63736.773006724339,224385.42556292014,{"$f":"'Input Data'!$C$75/100/12","v":1.8166666666666667E-3},407.63352310597162,{"$f":"(P18+S18)*R22","v":1629.0620237785558},null,null,null,"Purchased Power-Adjustment",null,{"$f":"L31","v":-2437392.29},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D22/2","v":2378135.3024899997},"Total savings * 50%","May ",{"$f":"'Input Data'!F26/1.041","v":13046327.973102788},{"$f":"E30","v":-1.2800000000000001E-2},-166992.9980557157,{"$f":"'Input Data'!N9","v":643061.80000000005},-321530.90000000002,-321530.90000000002,null,-321530.90000000002,-154537.90194428433,69847.523618635809,{"$f":"'Input Data'!$C$75/100/12","v":1.8166666666666667E-3},126.8896679071884,{"$f":"(P18+S18)*R23","v":1629.0620237785558},null,null,null,"Customer Share",{"$f":"M31","v":-2437392.29},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,null,null,"June ",{"$f":"'Input Data'!F27/1.041","v":13747173.006724305},{"$f":"I23","v":-1.2800000000000001E-2},-175963.81448607112,{"$f":"'Input Data'!N10","v":540081.22},-270040.61,-270040.61,null,-270040.61,-94076.795513928868,-24229.271895293059,{"$f":"'Input Data'!$C$75/100/12","v":1.8166666666666667E-3},-44.016510609782394,{"$f":"(P18+S18)*R24","v":1629.0620237785558},null,null,null,"Variance Disposition",null,null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,null,null,"July ",{"$f":"'Input Data'!F28/1.041","v":17000674.178674348},-1.2800000000000001E-2,-217608.62948703166,{"$f":"'Input Data'!N11","v":346027.36999999988},-173013.68499999994,-173013.68499999994,null,-173013.68499999994,44594.944487031724,20365.672591738665,{"$f":"'Input Data'!$C$76/100/12","v":4.7499999999999994E-4},9.6736944810758647,{"$f":"(P18+S18)*R25","v":425.94740988705348},null,null,null,"Owed to Customers",null,{"$f":"Y24+Y23","v":-2437392.29},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E23:E25)","v":2378135.3024899997},null,"August ",{"$f":"'Input Data'!F29/1.041","v":14580994.697406342},-1.2800000000000001E-2,-186636.73212680119,{"$f":"'Input Data'!N12","v":482319.24},-241159.62,-241159.62,null,-241159.62,-54522.887873198808,-34157.215281460143,{"$f":"'Input Data'!$C$76/100/12","v":4.7499999999999994E-4},-16.224677258693568,{"$f":"(P18+S18)*R26","v":425.94740988705348},null,null,null,"Credited to Customers",null,{"$f":"J31","v":-2350359.5619721427},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",{"$f":"'Input Data'!F30/1.041","v":12134074.764649378},-1.2800000000000001E-2,-155316.15698751205,{"$f":"'Input Data'!N13","v":498536.58000000007},-249268.29000000004,-249268.29000000004,null,-249268.29000000004,-93952.13301248799,-128109.34829394813,{"$f":"'Input Data'!$C$76/100/12","v":4.7499999999999994E-4},-60.851940439625359,{"$f":"(P18+S18)*R27","v":425.94740988705348},null,null,null,"Variance",null,{"$f":"Z25-Z26","v":-87032.728027857374},"Variance to be disposed in 2023"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!D39","v":185198705},null,"2018 Volumes","October ",{"$f":"'Input Data'!F31/1.041","v":13278032.411143133},-1.2800000000000001E-2,-169958.81486263211,{"$f":"'Input Data'!N14","v":497656.53},-248828.26500000001,-248828.26500000001,null,-248828.26500000001,-78869.450137367909,-206978.79843131604,{"$f":"'Input Data'!$C$77/100/12","v":4.7499999999999994E-4},-98.314929254875111,{"$f":"(P18+S18)*R28","v":425.94740988705348},null,null,null,"Interest on Variance",null,{"$f":"S31+T44+U57","v":-695.2458883525635},"Interest on variance to be disposed in 2023"]
[null,null,null,null,null,null,"November ",{"$f":"'Input Data'!F32/1.041","v":14216529.558117196},-1.2800000000000001E-2,-181971.57834390012,{"$f":"'Input Data'!N15","v":367603.7200000002},-183801.8600000001,-183801.8600000001,null,-183801.8600000001,-1830.2816560999781,-208809.08008741602,{"$f":"'Input Data'!$C$77/100/12","v":4.7499999999999994E-4},-99.1843130415226,{"$f":"(P18+S18)*R29","v":425.94740988705348}]
[null,null,"Power Purchased True-Up-2020 ($/kWh)",null,{"$f":"ROUND(-E26/D28,4)","v":-1.2800000000000001E-2},null,"December ",{"$f":"'Input Data'!F33/1.041","v":17675812.660902981},-1.2800000000000001E-2,-226250.40205955817,{"$f":"'Input Data'!N16","v":208948.10000000009},-104474.05000000005,-104474.05000000005,null,-104474.05000000005,121776.35205955812,-87032.728027857898,{"$f":"'Input Data'!$C$77/100/12","v":4.7499999999999994E-4},-41.340545813232495,{"$f":"(P18+S18)*R30","v":425.94740988705348}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H19:H30)","v":179158483.16042268},null,{"$f":"SUM(J19:J30)","v":-2350359.5619721427},4874784.58,-2437392.29,-2437392.29,0,-2437392.29,-87032.728027857898,null,null,{"$f":"SUM(S19:S30)","v":1441.0500685440352},{"$f":"SUM(T19:T30)","v":12330.05660199366}]
[null,2021,null,null,null,null,"January ",{"$f":"'Input Data'!G22/1.041","v":17395082.612872239},{"$f":"E30","v":-1.2800000000000001E-2},{"$f":"H32*I32","v":-222657.05744476468},{"$f":"'Input Data'!Q5","v":149829.71999999997},{"$f":"-K32/2","v":-74914.859999999986},{"$f":"-K32/2","v":-74914.859999999986},null,{"$f":"M32+N32","v":-74914.859999999986},{"$f":"O32-J32","v":147742.19744476469},{"$f":"P32","v":147742.19744476469},{"$f":"'Input Data'!$C$78/100/12","v":4.7499999999999994E-4},{"$f":"Q32*R32","v":70.177543786263215},{"$f":"(P31+S31)*R32","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R32","v":431.80418677300048}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!K57","v":39862344.666666657},null,"4-Year Avg.","February ",{"$f":"'Input Data'!G23/1.041","v":16387114.313160423},{"$f":"I32","v":-1.2800000000000001E-2},-209755.06320845342,{"$f":"'Input Data'!Q6","v":69263.969999999972},-34631.984999999986,-34631.984999999986,null,-34631.984999999986,175123.07820845343,{"$f":"P33+Q32","v":322865.27565321815},{"$f":"'Input Data'!$C$78/100/12","v":4.7499999999999994E-4},{"$f":"Q33*R33","v":153.3610059352786},{"$f":"(P31+S31)*R33","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R33","v":431.80418677300048},null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C63/1000","v":0.10947},null,"Oct 2020 RPP Report","March ",{"$f":"'Input Data'!G24/1.041","v":16113559.077809799},{"$f":"I33","v":-1.2800000000000001E-2},-206253.55619596544,{"$f":"'Input Data'!Q7","v":247378.25},-123689.125,-123689.125,null,-123689.125,82564.431195965444,405429.7068491836,{"$f":"'Input Data'!$C$78/100/12","v":4.7499999999999994E-4},192.57911075336219,{"$f":"(P31+S31)*R34","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R34","v":431.80418677300048},null,null,"GA Savings",null,{"$f":"K44","v":2678600.3299999991},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Forecast GA Savings ($)",{"$f":"D33*D34","v":4363730.8706599986},null,null,"April",{"$f":"'Input Data'!G25/1.041","v":12760011.834774258},{"$f":"I34","v":-1.2800000000000001E-2},-163328.15148511052,{"$f":"'Input Data'!Q8","v":480907.93000000005},-240453.96500000003,-240453.96500000003,null,-240453.96500000003,-77125.813514889509,328303.89333429409,{"$f":"'Input Data'!$C$79/100/12","v":4.7499999999999994E-4},155.94434933378966,{"$f":"(P31+S31)*R35","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R35","v":431.80418677300048},null,null,"Purchased Power-Adjustment",null,{"$f":"L44","v":-1339300.1649999996},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D35/2","v":2181865.4353299993},"Total savings * 50%","May ",{"$f":"'Input Data'!G26/1.041","v":12992608.453410184},{"$f":"E43","v":-1.1900000000000001E-2},-154612.0405955812,{"$f":"'Input Data'!Q9","v":335107.8600000001},-167553.93000000005,-167553.93000000005,null,-167553.93000000005,-12941.889404418849,315362.00392987521,{"$f":"'Input Data'!$C$79/100/12","v":4.7499999999999994E-4},149.7969518666907,{"$f":"(P31+S31)*R36","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R36","v":431.80418677300048},null,null,"Customer Share",{"$f":"M44","v":-1339300.1649999996},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,null,null,"June ",{"$f":"'Input Data'!G27/1.041","v":14312678.261287225},{"$f":"I36","v":-1.1900000000000001E-2},-170320.871309318,{"$f":"'Input Data'!Q10","v":115087.01000000001},-57543.505000000005,-57543.505000000005,null,-57543.505000000005,112777.36630931799,428139.3702391932,{"$f":"'Input Data'!$C$79/100/12","v":4.7499999999999994E-4},203.36620086361674,{"$f":"(P31+S31)*R37","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R37","v":431.80418677300048},null,null,"Variance Disposition",null,null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,null,null,"July ",{"$f":"'Input Data'!G28/1.041","v":14678629.692603268},-1.1900000000000001E-2,-174675.69334197891,{"$f":"'Input Data'!Q11","v":271220.41000000003},-135610.20500000002,-135610.20500000002,null,-135610.20500000002,39065.488341978897,467204.85858117207,{"$f":"'Input Data'!$C$80/100/12","v":4.7499999999999994E-4},221.92230782605671,{"$f":"(P31+S31)*R38","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R38","v":431.80418677300048},null,null,"Owed to Customers",null,{"$f":"Y37+Y36","v":-1339300.1649999996},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E36:E38)","v":2181865.4353299993},null,"August ",{"$f":"'Input Data'!G29/1.041","v":16760211.450528337},-1.1900000000000001E-2,-199446.51626128721,{"$f":"'Input Data'!Q12","v":206589.83999999997},-103294.91999999998,-103294.91999999998,null,-103294.91999999998,96151.596261287224,563356.45484245929,{"$f":"'Input Data'!$C$80/100/12","v":4.7499999999999994E-4},267.59431605016812,{"$f":"(P31+S31)*R39","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R39","v":431.80418677300048},null,null,"Credited to Customers",null,{"$f":"J44","v":-2190441.8941287226},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",{"$f":"'Input Data'!G30/1.041","v":12533578.146013452},-1.1900000000000001E-2,-149149.57993756008,{"$f":"'Input Data'!Q13","v":204085.54999999993},-102042.77499999997,-102042.77499999997,null,-102042.77499999997,47106.804937560111,610463.25978001941,{"$f":"'Input Data'!$C$80/100/12","v":4.7499999999999994E-4},289.9700483955092,{"$f":"(P31+S31)*R40","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R40","v":431.80418677300048},null,null,"Variance",null,{"$f":"Z38-Z39","v":851141.72912872303},"Variance to be disposed in 2024"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!E39","v":183512928},null,"2019 Volumes","October ",{"$f":"'Input Data'!G31/1.041","v":13184034.32276657},-1.1900000000000001E-2,-156890.00844092219,{"$f":"'Input Data'!Q14","v":272887.27999999997},-136443.63999999998,-136443.63999999998,null,-136443.63999999998,20446.368440922204,630909.62822094164,{"$f":"'Input Data'!$C$81/100/12","v":4.7499999999999994E-4},299.68207340494723,{"$f":"(P31+S31)*R41","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R41","v":431.80418677300048},null,null,"Interest on Variance",null,{"$f":"S44+T57+U70","v":63008.435704362477},"Interest on variance to be disposed in 2024"]
[null,null,null,null,null,null,"November ",{"$f":"'Input Data'!G32/1.041","v":14830822.286263209},-1.1900000000000001E-2,-176486.78520653219,{"$f":"'Input Data'!Q15","v":167410.76},-83705.38,-83705.38,null,-83705.38,92781.405206532188,723691.03342747386,{"$f":"'Input Data'!$C$81/100/12","v":4.7499999999999994E-4},343.75324087805006,{"$f":"(P31+S31)*R42","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R42","v":431.80418677300048}]
[null,null,"Power Purchased True-Up-2021 ($/kWh)",null,{"$f":"ROUND(-E39/D41,4)","v":-1.1900000000000001E-2},null,"December ",{"$f":"'Input Data'!G33/1.041","v":17383745.437079731},-1.1900000000000001E-2,-206866.57070124883,{"$f":"'Input Data'!Q16","v":158831.75000000012},-79415.875000000058,-79415.875000000058,null,-79415.875000000058,127450.69570124877,851141.72912872257,{"$f":"'Input Data'!$C$81/100/12","v":4.7499999999999994E-4},404.29232133614317,{"$f":"(P31+S31)*R43","v":-40.656047030674081},{"$f":"(P18+S18+T31)*R43","v":431.80418677300048}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H32:H43)","v":179332075.88856867},null,{"$f":"SUM(J32:J43)","v":-2190441.8941287226},2678600.3299999991,-1339300.1649999996,-1339300.1649999996,0,-1339300.1649999996,851141.72912872257,null,null,{"$f":"SUM(S32:S43)","v":2752.4394704298757},{"$f":"SUM(T32:T43)","v":-487.87256436808894},{"$f":"SUM(U32:U43)","v":5181.6502412760055}]
[null,2022,null,null,null,null,"January ",{"$f":"'Input Data'!H22/1.041","v":20956084.534101825},{"$f":"I43","v":-1.1900000000000001E-2},{"$f":"H45*I45","v":-249377.40595581173},{"$f":"'Input Data'!T5","v":37319.140000000014},{"$f":"-K45/2","v":-18659.570000000007},{"$f":"-K45/2","v":-18659.570000000007},null,{"$f":"M45+N45","v":-18659.570000000007},{"$f":"O45-J45","v":230717.83595581172},{"$f":"P45","v":230717.83595581172},{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},{"$f":"Q45*R45","v":109.59097207901056},{"$f":"(P44+S44)*R45","v":405.59973008459735},{"$f":"(P31+S31+T44)*R45","v":-40.887786498748923}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!L57","v":39935906},null,"4-Year Avg.","February ",{"$f":"'Input Data'!H23/1.041","v":17871165.225744478},{"$f":"I45","v":-1.1900000000000001E-2},-212666.86618635932,{"$f":"'Input Data'!T6","v":33610.069999999949},-16805.034999999974,-16805.034999999974,null,-16805.034999999974,195861.83118635934,{"$f":"P46+Q45","v":426579.66714217106},{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},202.62534189253122,{"$f":"(P44+S44)*R46","v":405.59973008459735},{"$f":"(P31+S31+T44)*R46","v":-40.887786498748923},null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C64/1000","v":6.8780000000000008E-2},null,"Oct 2021 RPP Report","March ",{"$f":"'Input Data'!H24/1.041","v":16783453.410182517},{"$f":"I46","v":-1.1900000000000001E-2},-199723.09558117198,{"$f":"'Input Data'!T7","v":174539.44999999995},-87269.724999999977,-87269.724999999977,null,-87269.724999999977,112453.370581172,539033.03772334312,{"$f":"'Input Data'!$C$82/100/12","v":4.7499999999999994E-4},256.04069291858798,{"$f":"(P44+S44)*R47","v":405.59973008459735},{"$f":"(P31+S31+T44)*R47","v":-40.887786498748923},null,null,"GA Savings",null,{"$f":"K57","v":2033179.0399999996},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D46*D47","v":2746791.6146800001},null,null,"April",{"$f":"'Input Data'!H25/1.041","v":13851003.842459176},{"$f":"I47","v":-1.1900000000000001E-2},-164826.9457252642,{"$f":"'Input Data'!T8","v":344332.82999999996},-172166.41499999998,-172166.41499999998,null,-172166.41499999998,-7339.4692747357767,531693.56844860734,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},451.93953318131628,{"$f":"(P44+S44)*R48","v":725.81004330927965},{"$f":"(P31+S31+T44)*R48","v":-73.167617945129663},null,null,"Purchased Power-Adjustment",null,{"$f":"L57","v":-1016589.5199999998},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D48/2","v":1373395.8073400001},"Total savings * 50%","May ",{"$f":"'Input Data'!H26/1.041","v":13145569.644572528},{"$f":"E56","v":-2.5999999999999999E-3},-34178.481075888572,{"$f":"'Input Data'!T9","v":480129.94000000006},-240064.97000000003,-240064.97000000003,{"$f":"-($E$50+$E$51)/12","v":76186.924673264337},-163878.04532673571,-129699.56425084714,401994.00419776019,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},341.69490356809621,{"$f":"(P44+S44)*R49","v":725.81004330927965},{"$f":"(P31+S31+T44)*R49","v":-73.167617945129663},null,null,"Customer Share",{"$f":"M57","v":-1016589.5199999998},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,{"$f":"-Z14","v":-884994.67001440981},"Variance from 2019","June ",{"$f":"'Input Data'!H27/1.041","v":13412040.345821327},{"$f":"I49","v":-2.5999999999999999E-3},-34871.304899135444,{"$f":"'Input Data'!T10","v":443166.67999999993},-221583.33999999997,-221583.33999999997,{"$f":"-($E$50+$E$51)/12","v":76186.924673264337},-145396.41532673565,-110525.1104276002,291468.89377015998,{"$f":"'Input Data'!$C$83/100/12","v":8.5000000000000006E-4},247.74855970463599,{"$f":"(P44+S44)*R50","v":725.81004330927965},{"$f":"(P31+S31+T44)*R50","v":-73.167617945129663},null,null,"Variance Disposition",{"$f":"-(E50+E51)","v":914243.09607917198},null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,{"$f":"-Z15","v":-29248.42606476213},"Int. on 2019 var.","July ",{"$f":"'Input Data'!H28/1.041","v":15239493.756003844},-2.5999999999999999E-3,-39622.683765609989,{"$f":"'Input Data'!T11","v":164396.14000000001},-82198.070000000007,-82198.070000000007,76186.924673264337,-6011.1453267356701,33611.538438874319,325080.43220903428,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},595.98079238322953,{"$f":"(P44+S44)*R51","v":1565.4726424317796},{"$f":"(P31+S31+T44)*R51","v":-157.81250929341695},null,null,"Owed to Customers",null,{"$f":"Y50+Y49","v":-102346.4239208278},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E49:E51)","v":459152.71126082813},null,"August ",{"$f":"'Input Data'!H29/1.041","v":15103622.478386167},-2.5999999999999999E-3,-39269.418443804032,{"$f":"'Input Data'!T12","v":13161.179999999993},-6580.5899999999965,-6580.5899999999965,76186.924673264337,69606.33467326434,108875.75311706838,433956.18532610266,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},795.58633976452165,{"$f":"(P44+S44)*R52","v":1565.4726424317796},{"$f":"(P31+S31+T44)*R52","v":-157.81250929341695},null,null,"Credited to Customers",null,{"$f":"J57","v":-1127912.9554851106},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",{"$f":"'Input Data'!H30/1.041","v":12895567.72334294},-2.5999999999999999E-3,-33528.476080691646,{"$f":"'Input Data'!T13","v":140814},-70407,-70407,76186.924673264337,5779.9246732643369,39308.400753955983,473264.58608005865,{"$f":"'Input Data'!$C$84/100/12","v":1.8333333333333335E-3},867.65174114677427,{"$f":"(P44+S44)*R53","v":1565.4726424317796},{"$f":"(P31+S31+T44)*R53","v":-157.81250929341695},null,null,"Variance",null,{"$f":"Z51-Z52","v":1025566.5315642828},"Variance to be disposed in 2025"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!F39","v":178353238},null,"2020 Volumes","October ",{"$f":"'Input Data'!H31/1.041","v":13363251.68107589},-2.5999999999999999E-3,-34744.454370797313,{"$f":"'Input Data'!T14","v":139906.34999999998},-69953.174999999988,-69953.174999999988,76186.924673264337,6233.7496732643485,40978.204044061662,514242.79012412031,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},1658.4329981502881,{"$f":"(P44+S44)*R54","v":2753.8086937322669},{"$f":"(P31+S31+T44)*R54","v":-277.60655043887431},null,null,"Interest on Variance",null,{"$f":"S57+T70+U83","v":88836.556740655215},"Interest on variance to be disposed in 2025"]
[null,null,null,null,null,null,"November ",{"$f":"'Input Data'!H32/1.041","v":15431694.649375601},-2.5999999999999999E-3,-40122.406088376563,{"$f":"'Input Data'!T15","v":29347.509999999776},-14673.754999999888,-14673.754999999888,76186.924673264337,61513.169673264449,101635.57576164101,615878.36588576133,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},1986.2077299815803,{"$f":"(P44+S44)*R55","v":2753.8086937322669},{"$f":"(P31+S31+T44)*R55","v":-277.60655043887431}]
[null,null,"Power Purchased True-Up-2022 ($/kWh)",null,{"$f":"ROUND(-E52/D54,4)","v":-2.5999999999999999E-3},null,"December ",{"$f":"'Input Data'!H33/1.041","v":17300545.12007685},-2.5999999999999999E-3,-44981.41731219981,{"$f":"'Input Data'!T16","v":32455.75},-16227.875,-16227.875,76186.924673264337,59959.049673264337,104940.46698546415,720818.83287122543,{"$f":"'Input Data'!$C$85/100/12","v":3.225E-3},2324.6407360097019,{"$f":"(P44+S44)*R56","v":2753.8086937322669},{"$f":"(P31+S31+T44)*R56","v":-277.60655043887431}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H45:H56)","v":185353492.41114312},null,{"$f":"SUM(J45:J56)","v":-1127912.9554851106},2033179.0399999996,-1016589.5199999998,-1016589.5199999998,609495.3973861147,-407094.12261388521,720818.83287122543,null,null,{"$f":"SUM(S45:S56)","v":9838.1403407802736},{"$f":"SUM(T45:T56)","v":16352.073328673767},{"$f":"SUM(U45:U56)","v":-1648.4233925285098}]
[null,2023,null,null,null,null,"January ",{"$f":"'Input Data'!I22/1.041","v":17577309.116234392},{"$f":"E56","v":-2.5999999999999999E-3},{"$f":"H58*I58","v":-45701.003702209418},{"$f":"'Input Data'!W5","v":138799.72999999998},{"$f":"-K58/2","v":-69399.864999999991},{"$f":"-K58/2","v":-69399.864999999991},76186.924673264337,{"$f":"M58+N58","v":6787.0596732643462},{"$f":"O58-J58","v":52488.063375473765},{"$f":"P58","v":52488.063375473765},{"$f":"'Input Data'!$C$86/100/12","v":3.9416666666666671E-3},{"$f":"Q58*R58","v":206.89044980499244},{"$f":"(P57+S57)*R58","v":2880.0062360773227},{"$f":"(P44+S44+T57)*R58","v":3430.2206035988488}]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Input Data'!M57","v":37172348.5},null,"4-Year Avg.","February ",{"$f":"'Input Data'!I23/1.041","v":16452589.750240155},{"$f":"I58","v":-2.5999999999999999E-3},-42776.733350624403,{"$f":"'Input Data'!W6","v":166356.76},-83178.38,-83178.38,76186.924673264337,-6991.4553267356678,35785.278023888735,{"$f":"P59+Q58","v":88273.3413993625},{"$f":"'Input Data'!$C$86/100/12","v":3.9416666666666671E-3},347.9440873491539,{"$f":"(P57+S57)*R59","v":2880.0062360773227},{"$f":"(P44+S44+T57)*R59","v":3430.2206035988488},null,"Summary"]
[null,null,"Forecast GA ($/kWh)",{"$f":"'Input Data'!C65/1000","v":3.6040000000000003E-2},null,"Oct 2022 RPP Report","March ",{"$f":"'Input Data'!I24/1.041","v":16347903.919308359},{"$f":"I59","v":-2.5999999999999999E-3},-42504.550190201728,{"$f":"'Input Data'!W7","v":226199.54000000004},-113099.77000000002,-113099.77000000002,76186.924673264337,-36912.845326735682,5591.7048634660459,93865.046262828546,{"$f":"'Input Data'!$C$86/100/12","v":3.9416666666666671E-3},369.98472401931588,{"$f":"(P57+S57)*R60","v":2880.0062360773227},{"$f":"(P44+S44+T57)*R60","v":3430.2206035988488},null,null,"GA Savings",null,{"$f":"K70","v":2510607.2900000005},"Total GA avoided (Waltham kWh * GA $/kWh)"]
[null,null,"Total Forecast GA Savings ($)",{"$f":"D59*D60","v":1339691.4399400002},null,null,"April",{"$f":"'Input Data'!I25/1.041","v":13566437.598463016},{"$f":"I60","v":-2.5999999999999999E-3},-35272.737756003837,{"$f":"'Input Data'!W8","v":419291.45999999996},-209645.72999999998,-209645.72999999998,76186.924673264337,-133458.80532673566,-98186.06757073183,-4321.0213079032837,{"$f":"'Input Data'!$C$87/100/12","v":4.15E-3},-17.932238427798627,{"$f":"(P57+S57)*R61","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R61","v":3611.5219040004786},null,null,"Purchased Power-Adjustment",null,{"$f":"L70","v":-1255303.6450000003},"Paid to Brookfield"]
[null,null,"Forecast net GA Savings ($)",null,{"$f":"D61/2","v":669845.71997000009},"Total savings * 50%","May ",{"$f":"'Input Data'!I26/1.041","v":12990801.095100865},{"$f":"E69","v":-4.1999999999999997E-3},-54561.364599423629,{"$f":"'Input Data'!W9","v":504470.69000000006},-252235.34500000003,-252235.34500000003,{"$f":"-($E$63+$E$64)/12","v":-7310.6644930174953},-259546.00949301751,-204984.64489359388,-209305.66620149717,{"$f":"'Input Data'!$C$87/100/12","v":4.15E-3},-868.61851473621323,{"$f":"(P57+S57)*R62","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R62","v":3611.5219040004786},null,null,"Customer Share",{"$f":"M70","v":-1255303.6450000003},null,"Amount that should be credited to customers"]
[null,null,"Variance from previous years ($)",null,{"$f":"-Z27","v":87032.728027857374},"Variance from 2020","June ",{"$f":"'Input Data'!I27/1.041","v":0},{"$f":"I62","v":-4.1999999999999997E-3},0,{"$f":"'Input Data'!W10","v":208072.19999999995},-104036.09999999998,-104036.09999999998,{"$f":"-($E$63+$E$64)/12","v":-7310.6644930174953},-111346.76449301747,-111346.76449301747,-320652.43069451465,{"$f":"'Input Data'!$C$87/100/12","v":4.15E-3},-1330.7075873822357,{"$f":"(P57+S57)*R63","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R63","v":3611.5219040004786},null,null,"Variance Disposition",{"$f":"-(E63+E64)","v":-87727.973916209943},null,"Adjustment for earlier variances (3-year lag)"]
[null,null,"Interest on variance ($)",null,{"$f":"-Z28","v":695.2458883525635},"Int. on 2020 var.","July ",{"$f":"'Input Data'!I28/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W11","v":256400.04},-128200.02,-128200.02,{"$f":"-($E$63+$E$64)/12","v":-7310.6644930174953},-135510.6844930175,-135510.6844930175,-456163.11518753215,{"$f":"'Input Data'!$C$88/100/12","v":4.15E-3},-1893.0769280282584,{"$f":"(P57+S57)*R64","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R64","v":3611.5219040004786},null,null,"Owed to Customers",null,{"$f":"Y63+Y62","v":-1343031.6189162103},"Amount to be credited to customers including variances"]
[null,null,"Forecast Power Purchased True-Up Balance ($)",null,{"$f":"SUM(E62:E64)","v":757573.69388620998},null,"August ",{"$f":"'Input Data'!I29/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W12","v":388490.9},-194245.45,-194245.45,-7310.6644930174953,-201556.11449301749,-201556.11449301749,-657719.22968054959,{"$f":"'Input Data'!$C$88/100/12","v":4.15E-3},-2729.534803174281,{"$f":"(P57+S57)*R65","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R65","v":3611.5219040004786},null,null,"Credited to Customers",null,{"$f":"J70","v":-220816.38959846302},"Actual amount credited to customers based on actual volumes and forecast Power Purchased True-Up "]
[null,null,null,null,null,null,"September ",{"$f":"'Input Data'!I30/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W13","v":202525.97},-101262.985,-101262.985,-7310.6644930174953,-108573.6494930175,-108573.6494930175,-766292.87917356705,{"$f":"'Input Data'!$C$88/100/12","v":4.15E-3},-3180.1154485703032,{"$f":"(P57+S57)*R66","v":3032.2264388298236},{"$f":"(P44+S44+T57)*R66","v":3611.5219040004786},null,null,"Variance",null,{"$f":"Z64-Z65","v":-1122215.2293177473},"Variance to be disposed in 2026"]
[null,null,"Total Customer Volumes (kWh)",{"$f":"'Input Data'!G39","v":182112496},null,"2021 Volumes","October ",{"$f":"'Input Data'!I31/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W14","v":0},0,0,-7310.6644930174953,-7310.6644930174953,-7310.6644930174953,-773603.54366658453,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},-3539.2362122746244,{"$f":"(P57+S57)*R67","v":3342.755652444926},{"$f":"(P44+S44+T57)*R67","v":3981.376556819805},null,null,"Interest on Variance",null,{"$f":"S70+T83+U96","v":-110971.23052776253},"Interest on variance to be disposed in 2026"]
[null,null,null,null,null,null,"November ",{"$f":"'Input Data'!I32/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W15","v":0},0,0,-7310.6644930174953,-7310.6644930174953,-7310.6644930174953,-780914.20815960201,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},-3572.6825023301794,{"$f":"(P57+S57)*R68","v":3342.755652444926},{"$f":"(P44+S44+T57)*R68","v":3981.376556819805}]
[null,null,"Power Purchased True-Up-2023 ($/kWh)",null,{"$f":"ROUND(-E65/D67,4)","v":-4.1999999999999997E-3},null,"December ",{"$f":"'Input Data'!I33/1.041","v":0},-4.1999999999999997E-3,0,{"$f":"'Input Data'!W16","v":0},0,0,-7310.6644930174953,-7310.6644930174953,-7310.6644930174953,-788224.8726526195,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},-3606.1287923857344,{"$f":"(P57+S57)*R69","v":3342.755652444926},{"$f":"(P44+S44+T57)*R69","v":3981.376556819805}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H58:H69)","v":76935041.479346782},null,{"$f":"SUM(J58:J69)","v":-220816.38959846302},2510607.2900000005,-1255303.6450000003,-1255303.6450000003,246262.3827489175,-1009041.2622510825,-788224.8726526195,null,null,{"$f":"SUM(S58:S69)","v":-19813.213766136167},{"$f":"SUM(T58:T69)","v":36861.644298545689},{"$f":"SUM(U58:U69)","v":43903.922905258834}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R71","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R71","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R72","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R72","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R73","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R73","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R74","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R74","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R75","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R75","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R76","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R76","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R77","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R77","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R78","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R78","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R79","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R79","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R80","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R80","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R81","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R81","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P70+S70)*R82","v":-3696.7742453658075},{"$f":"(P57+S57+T70)*R82","v":3511.3976751107725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T71:T82)","v":-44361.290944389686},{"$f":"SUM(U71:U82)","v":42136.772101329261}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R84","v":0},{"$f":"(P70+S70+T83)*R84","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R85","v":0},{"$f":"(P70+S70+T83)*R85","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R86","v":0},{"$f":"(P70+S70+T83)*R86","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R87","v":0},{"$f":"(P70+S70+T83)*R87","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R88","v":0},{"$f":"(P70+S70+T83)*R88","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R89","v":0},{"$f":"(P70+S70+T83)*R89","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R90","v":0},{"$f":"(P70+S70+T83)*R90","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R91","v":0},{"$f":"(P70+S70+T83)*R91","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R92","v":0},{"$f":"(P70+S70+T83)*R92","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R93","v":0},{"$f":"(P70+S70+T83)*R93","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R94","v":0},{"$f":"(P70+S70+T83)*R94","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Input Data'!$C$89/100/12","v":4.5750000000000001E-3},null,{"$f":"(P83+S83)*R95","v":0},{"$f":"(P70+S70+T83)*R95","v":-3899.7271514363902}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T84:T95)","v":0},{"$f":"SUM(U84:U95)","v":-46796.725817236678}]

{"sheet":"Alt. Historic Summary","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,12,1],[13,1,25,1]]}
[null,null,null,null,null,null,null,"Actuals are incomplete"]
[null,null,"Calendar Year",2019,2020,2021,2022,2023]
[null,"Power Purchased True-Up Calculation"]
[null,null,"Forecast Global Adjustment ($/kWh)",{"$f":"'Alternate Historic PP True-Up'!D9","v":0.10222000000000001},{"$f":"'Alternate Historic PP True-Up'!D21","v":0.10693999999999999},{"$f":"'Alternate Historic PP True-Up'!D34","v":0.10947},{"$f":"'Alternate Historic PP True-Up'!D47","v":6.8780000000000008E-2},{"$f":"'Alternate Historic PP True-Up'!D60","v":3.6040000000000003E-2},"Forecast (RPP Report)"]
[null,null,"Forecast Waltham Volumes (kWh)",{"$f":"'Alternate Historic PP True-Up'!D8","v":47853390},{"$f":"'Alternate Historic PP True-Up'!D20","v":44476067},{"$f":"'Alternate Historic PP True-Up'!D33","v":39862344.666666657},{"$f":"'Alternate Historic PP True-Up'!D46","v":39935906},{"$f":"'Alternate Historic PP True-Up'!D59","v":37172348.5},"Forecast (3-year historic average)"]
[]
[null,null,"Forecast net GA Savings",{"$f":"'Alternate Historic PP True-Up'!E11","v":2445786.7629},{"$f":"'Alternate Historic PP True-Up'!E23","v":2378135.3024899997},{"$f":"'Alternate Historic PP True-Up'!E36","v":2181865.4353299993},{"$f":"'Alternate Historic PP True-Up'!E49","v":1373395.8073400001},{"$f":"'Alternate Historic PP True-Up'!E62","v":669845.71997000009},"(= GA$/kWh * Forecast volumes * 0.5)"]
[null,null,"Variance Disposal (2-year lag)",null,null,null,{"$f":"D25","v":-914243.09607917187},{"$f":"E25","v":87727.973916209943},"Actual (calculated below)"]
[null,null,"Power Purchased True-Up Balance",{"$f":"D7+D8","v":2445786.7629},{"$f":"E7+E8","v":2378135.3024899997},{"$f":"F7+F8","v":2181865.4353299993},{"$f":"G7+G8","v":459152.71126082819},{"$f":"H7+H8","v":757573.69388620998},"(=Net GA Savings + Variance Disposal)"]
[]
[null,null,"Forecast Total Customer kWh",{"$f":"'Alternate Historic PP True-Up'!D14","v":177934181},{"$f":"'Alternate Historic PP True-Up'!D28","v":185198705},{"$f":"'Alternate Historic PP True-Up'!D41","v":183512928},{"$f":"'Alternate Historic PP True-Up'!D54","v":178353238},{"$f":"'Alternate Historic PP True-Up'!D67","v":182112496},"Forecast (actual of last year)"]
[]
[null,null,"Power Purchased True-Up ($/kWh)",{"$f":"-D9/D11","v":-1.3745457725741856E-2},{"$f":"-E9/E11","v":-1.284099315105902E-2},{"$f":"-F9/F11","v":-1.1889437213546064E-2},-2.5744007589076023E-3,-4.1599215349077965E-3,"(= Power Purchased True-Up Balance / customer volumes)"]
[null,"Variances"]
[null,null,"Actual customer share of GA savings",{"$f":"-'Alternate Historic PP True-Up'!Y10","v":1645256.35},{"$f":"-'Alternate Historic PP True-Up'!Y23","v":2437392.29},{"$f":"-'Alternate Historic PP True-Up'!Y36","v":1339300.1649999996},{"$f":"-'Alternate Historic PP True-Up'!Y49","v":1016589.5199999998},{"$f":"-'Alternate Historic PP True-Up'!Y62","v":1255303.6450000003},"Actual"]
[null,null,"Variance to include in rate",null,null,null,{"$f":"D25","v":-914243.09607917187},{"$f":"E25","v":87727.973916209943},"Actual (calculated below)"]
[null,null,"Actual customer share inc'l variances",{"$f":"D15+D16","v":1645256.35},{"$f":"E15+E16","v":2437392.29},1339300.1649999996,102346.42392082792,1343031.6189162103,"(= Actual Net GA Savings + variance)"]
[]
[null,null,"Actual credited to customers",{"$f":"-'Alternate Historic PP True-Up'!Z13","v":2530251.0200144099},{"$f":"-'Alternate Historic PP True-Up'!Z26","v":2350359.5619721427},{"$f":"-'Alternate Historic PP True-Up'!Z39","v":2190441.8941287226},{"$f":"-'Alternate Historic PP True-Up'!Z52","v":1127912.9554851106},{"$f":"-'Alternate Historic PP True-Up'!Z65","v":220816.38959846302},"Actual"]
[]
[]
[null,null,"Variance",{"$f":"D17-D19","v":-884994.67001440981},{"$f":"E17-E19","v":87032.728027857374},{"$f":"F17-F19","v":-851141.72912872303},{"$f":"G17-G19","v":-1025566.5315642827},{"$f":"H17-H19","v":1122215.2293177473},"Actual"]
[null,null,"Interest on Variance",{"$f":"-'Alternate Historic PP True-Up'!S18","v":-11736.719221492465},{"$f":"-'Alternate Historic PP True-Up'!S31","v":-1441.0500685440352},{"$f":"-'Alternate Historic PP True-Up'!S44","v":-2752.4394704298757},{"$f":"-'Alternate Historic PP True-Up'!S57","v":-9838.1403407802736},{"$f":"-'Alternate Historic PP True-Up'!S70","v":19813.213766136167},"Actual"]
[null,null,"Add'l Interest before disposition",{"$f":"-'Alternate Historic PP True-Up'!T31-'Alternate Historic PP True-Up'!U44","v":-17511.706843269665},{"$f":"-'Alternate Historic PP True-Up'!T44-'Alternate Historic PP True-Up'!U57","v":2136.2959568965989},{"$f":"-'Alternate Historic PP True-Up'!T57-'Alternate Historic PP True-Up'!U70","v":-60255.996233932601},{"$f":"-'Alternate Historic PP True-Up'!T70-'Alternate Historic PP True-Up'!U83","v":-78998.416399874957},{"$f":"-'Alternate Historic PP True-Up'!T83-'Alternate Historic PP True-Up'!U96","v":91158.016761626364},"Actual"]
[null,null,"Variance Total",{"$f":"SUM(D22:D24)","v":-914243.09607917187},{"$f":"SUM(E22:E24)","v":87727.973916209943},{"$f":"SUM(F22:F24)","v":-914150.1648330855},{"$f":"SUM(G22:G24)","v":-1114403.0883049378},{"$f":"SUM(H22:H24)","v":1233186.4598455098}]
[]
[]
[null,null,null,{"$f":"D2","v":2019},{"$f":"E2","v":2020},2021,2022,2023]
[null,"1508 Power Purchased True-Up Tracking Account "]
[null,null,{"$f":"C7","v":"Forecast net GA Savings"},{"$f":"D7","v":2445786.7629},{"$f":"E7","v":2378135.3024899997},{"$f":"F7","v":2181865.4353299993},{"$f":"G7","v":1373395.8073400001},{"$f":"H7","v":669845.71997000009}]
[null,null,"Difference between forecast and actual",{"$f":"-'Alternate Historic PP True-Up'!Z12-'Alternate Historic PP True-Up'!E11","v":-800530.41289999988},{"$f":"-'Alternate Historic PP True-Up'!Z25-'Alternate Historic PP True-Up'!E23","v":59256.987510000356},{"$f":"-'Alternate Historic PP True-Up'!Z38-'Alternate Historic PP True-Up'!E39","v":-842565.27032999974},{"$f":"-'Alternate Historic PP True-Up'!Z51-'Alternate Historic PP True-Up'!E52","v":-356806.28734000033},{"$f":"-'Alternate Historic PP True-Up'!Z64-'Alternate Historic PP True-Up'!E65","v":585457.92503000028}]
[null,null,{"$f":"C19","v":"Actual credited to customers"},{"$f":"-D19","v":-2530251.0200144099},{"$f":"-E19","v":-2350359.5619721427},{"$f":"-F19","v":-2190441.8941287226},{"$f":"-G19","v":-1127912.9554851106},{"$f":"-H19","v":-220816.38959846302}]
[null,null,"Variance",{"$f":"SUM(D30:D32)","v":-884994.67001440981},{"$f":"SUM(E30:E32)","v":87032.728027857374},{"$f":"SUM(F30:F32)","v":-851141.72912872303},{"$f":"SUM(G30:G32)","v":-111323.43548511085},{"$f":"SUM(H30:H32)","v":1034487.2554015375}]
[null,null,"Interest (in year)",{"$f":"D23","v":-11736.719221492465},{"$f":"E23","v":-1441.0500685440352},{"$f":"F23","v":-2752.4394704298757},{"$f":"G23","v":-9838.1403407802736},{"$f":"H23","v":19813.213766136167}]
[null,null,"Interest (lag year 1)",null,{"$f":"-'Alternate Historic PP True-Up'!T31","v":-12330.05660199366},{"$f":"-'Alternate Historic PP True-Up'!T44","v":487.87256436808894},{"$f":"-'Alternate Historic PP True-Up'!T57","v":-16352.073328673767},{"$f":"-'Alternate Historic PP True-Up'!T70","v":-36861.644298545689}]
[null,null,"Interest (lag year 2)",null,null,{"$f":"-'Alternate Historic PP True-Up'!U44","v":-5181.6502412760055},{"$f":"-'Alternate Historic PP True-Up'!U57","v":1648.4233925285098},{"$f":"-'Alternate Historic PP True-Up'!U70","v":-43903.922905258834}]
[null,null,"Variance Disposition",null,null,null,{"$f":"-(D33+D34+E35+F36)","v":914243.09607917187},{"$f":"-(E33+E34+F35+G36)","v":-87727.973916209943}]
[null,null,"Year-End Balance",{"$f":"SUM(D30:D37)","v":-1781726.0592503122},{"$f":"SUM(E30:E37)","v":160294.34938517705},{"$f":"SUM(F30:F37)","v":-1709729.6754047838},{"$f":"SUM(G30:G37)","v":667054.43483202462},{"$f":"SUM(H30:H37)","v":1920294.1834491966}]