{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["1. Information Sheet","3. Continuity Schedule","4. Billing Det. for Def-Var","5. Allocating Def-Var Balances","6. GA Calculation","6A. GA Allocation_Class A","6B. GA Allocation_new Class B","7. CBR Calculation","7A. CBR Allocation_Class A","7B. CBR Allocation_new Class B","8. Calculation of Def-Var RR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":63,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Information Sheet","index":0,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,8,14],[23,6,23,10],[13,6,13,12],[15,6,15,10],[17,6,17,8],[19,6,19,11],[21,6,21,8],[43,1,43,7],[25,6,25,8],[27,6,27,8],[29,1,29,5],[29,6,29,8],[31,1,31,5],[31,6,31,8],[36,3,36,12],[38,3,38,14],[40,3,40,13]]}
["Back to Index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a"]
[null,"INCENTIVE REGULATION MODEL FOR 2019 FILERS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",1]
[]
[null,null,null,null,null,"Utility Name   ","Alectra Utilities - Horizon Utilites Rate Zone"]
[]
[null,null,null,null,null,"Service Territory"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2018-0016"]
[]
[null,null,null,null,null,"Name of Contact and Title","Indy J. Butany-DeSouza, Vice-President, Regulatory Affairs"]
[]
[null,null,null,null,null,"Phone Number   ","905-821-5727"]
[]
[null,null,null,null,null,"Email Address   ","indy.butany@alectrautilities.com"]
[]
[null,null,null,null,null,"We are applying for rates effective   ","2019-01-01"]
[]
[null,null,null,null,null,"Rate-Setting Method","Price Cap IR"]
[]
[null,"Please indicate in which Rate Year the Group 1 accounts were last cleared1",null,null,null,null,2017]
[]
[null,"Please indicate the last Cost of Service \nRe-Basing Year",null,null,null,null,2018]
[]
[]
[null,null,"Notes"]
[]
[null,null,null,"Pale gray cells represent input cells."]
[]
[null,null,null,"Pale blue cells represent drop-down lists.  "]
[]
[null,null,null,"White cells contain fixed values, automatically generated values or formulae. "]
[]
[]
[null,"Note:  \n1.  Rate year of application"]

{"sheet":"3. Continuity Schedule","index":1,"n_rows":58,"n_cols":99,"rows_kept":58,"cut":false,"hidden":false,"merged":[[16,70,18,70],[16,71,18,71],[16,72,18,72],[16,51,18,51],[16,52,18,52],[16,56,18,56],[16,55,18,55],[16,66,18,66],[15,74,15,83],[16,74,18,74],[16,75,18,75],[16,76,18,76],[16,77,18,77],[16,78,18,78],[16,79,18,79],[16,80,18,80],[16,81,18,81],[16,82,18,82],[16,83,18,83],[15,84,15,87],[16,84,18,84],[16,85,18,85],[16,86,18,86],[16,87,18,87],[16,89,18,89],[16,90,18,90],[16,91,18,91],[16,92,18,92],[16,93,18,93],[16,45,18,45],[16,46,18,46],[16,47,18,47],[16,48,18,48],[16,49,18,49],[16,50,18,50],[16,42,18,42],[16,43,18,43],[16,73,18,73],[16,88,18,88],[16,57,18,57],[16,58,18,58],[16,59,18,59],[16,60,18,60],[16,61,18,61],[16,62,18,62],[16,67,18,67],[16,68,18,68],[16,69,18,69],[16,53,18,53],[16,54,18,54],[16,44,18,44],[16,63,18,63],[16,38,18,38],[16,27,18,27],[16,28,18,28],[16,29,18,29],[16,30,18,30],[16,31,18,31],[16,32,18,32],[16,33,18,33],[16,34,18,34],[16,35,18,35],[16,36,18,36],[16,37,18,37],[1,2,8,16],[15,34,15,43],[16,14,18,14],[15,54,15,63],[15,88,15,91],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[16,6,18,6],[16,7,18,7],[16,8,18,8],[15,44,15,53],[15,64,15,73],[16,64,18,64],[16,65,18,65],[16,39,18,39],[16,40,18,40],[16,41,18,41],[16,23,18,23],[16,9,18,9],[16,10,18,10],[16,11,18,11],[16,12,18,12],[57,2,58,3],[11,2,14,3],[15,4,15,13],[15,14,15,23],[15,24,15,33],[16,24,18,24],[16,25,18,25],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[48,2,49,3],[16,26,18,26],[16,15,18,15],[16,16,18,16],[16,17,18,17],[16,13,18,13],[16,18,18,18],[16,19,18,19],[16,20,18,20],[16,21,18,21],[16,22,18,22]]}
["Back to Index","Back to Index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,"Please complete the following continuity schedule for the following Deferral/Variance Accounts.  Enter information into green cells only. Column CE shoudl match the latest 2.1.7 RRR filing.\n\nWhen inputting balances in the continuity schedule, Account 1580 RSVA - Wholesale Market Service Charge is to exclude any amounts relating to CBR. The CBR amounts are to be entered separately in the Class A and Class B 1580 sub-accounts. Only Class B amounts are to be disposed. Class A amounts are not to be disposed.\n\nIf you have received approval to dispose of balances from prior years, the starting point for entries in the schedule below will be the balance sheet date as per your general ledger for which you received approval.  For example, if in the 2016 EDR process (CoS or IRM) you received approval for the December 31, 2014 balances, the starting point for your entries below should be the 2013 year. This will allow for the correct starting point for the 2014 opening balance columns for both principal and interest.\n\nPlease refer to the footnotes for further instructions."]
[]
[]
[]
[null,null,null,null,2010,null,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,null,2014,null,null,null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,2018,null,null,null,"Projected Interest on Dec-31-17 Balances",null,null,null,"2.1.7 RRR"]
[null,null,"Account Descriptions","Account Number","Opening Principal Amounts as of Jan 1, 2010","Transactions2 Debit / (Credit) during 2010","OEB-Approved Disposition during 2010","Principal Adjustments1 during 2010","Closing Principal Balance as of Dec 31, 2010","Opening Interest Amounts as of Jan 1, 2010","Interest Jan 1 to Dec 31, 2010","OEB-Approved Disposition during 2010","Interest Adjustments1 during 2010","Closing Interest Amounts as of Dec 31, 2010","Opening Principal Amounts as of Jan 1, 2011","Transactions2 Debit / (Credit) during 2011 ","OEB-Approved Disposition during 2011","Principal Adjustments1 during 2011 ","Closing Principal Balance as of Dec 31, 2011","Opening Interest Amounts as of Jan 1, 2011","Interest Jan 1 to Dec 31, 2011","OEB-Approved Disposition during 2011","Interest Adjustments1 during 2011","Closing Interest Amounts as of Dec 31, 2011","Opening Principal Amounts as of Jan 1, 2012","Transactions2 Debit / (Credit) during 2012","OEB-Approved Disposition during 2012","Principal Adjustments1 during 2012","Closing Principal Balance as of Dec 31, 2012","Opening Interest Amounts as of Jan 1, 2012","Interest Jan 1 to Dec 31, 2012","OEB-Approved Disposition during 2012","Interest Adjustments1 during 2012","Closing Interest Amounts as of Dec 31, 2012","Opening Principal Amounts as of Jan 1, 2013","Transactions2 Debit / (Credit) during 2013","OEB-Approved Disposition during 2013","Principal Adjustments1 during 2013","Closing Principal Balance as of Dec 31, 2013","Opening Interest Amounts as of Jan 1, 2013","Interest Jan 1 to Dec 31, 2013","OEB-Approved Disposition during 2013","Interest Adjustments1 during 2013","Closing Interest Amounts as of Dec 31, 2013","Opening Principal Amounts as of Jan 1, 2014","Transactions2 Debit / (Credit) during 2014","OEB-Approved Disposition during 2014","Principal Adjustments1 during 2014","Closing Principal Balance as of Dec 31, 2014","Opening Interest Amounts as of Jan 1, 2014","Interest Jan 1 to Dec 31. 2014","OEB-Approved Disposition during 2014","Interest Adjustments1 during 2014","Closing Interest Amounts as of Dec 31, 2014","Opening Principal Amounts as of Jan 1, 2015","Transactions2 Debit / (Credit) during 2015","OEB-Approved Disposition during 2015","Principal Adjustments1 during 2015 ","Closing Principal Balance as of Dec 31, 15","Opening Interest Amounts as of Jan 1, 15","Interest Jan 1 to Dec 31, 15","OEB-Approved Disposition during 2015","Interest Adjustments1 during 2015","Closing Interest Amounts as of Dec 31, 15","Opening Principal Amounts as of Jan 1, 2016","Transactions2 Debit / (Credit) during 2016","OEB-Approved Disposition during 2016","Principal Adjustments1 during 2016","Closing Principal Balance as of Dec 31, 16","Opening Interest Amounts as of Jan 1, 16","Interest Jan 1 to Dec 31, 16","OEB-Approved Disposition during 2016","Interest Adjustments1 during 2016","Closing Interest Amounts as of Dec 31, 16","Opening Principal Amounts as of Jan 1, 2017","Transactions2 Debit / (Credit) during 2017","OEB-Approved Disposition during 2017","Principal Adjustments1 during 2017","Closing Principal Balance as of Dec 31, 17","Opening Interest Amounts as of Jan 1, 17","Interest Jan 1 to Dec 31, 17","OEB-Approved Disposition during 2017","Interest Adjustments1 during 2017","Closing Interest Amounts as of Dec 31, 17","Principal Disposition during 2018 - instructed by OEB","Interest Disposition during 2018 - instructed by OEB","Closing Principal Balances as of Dec 31, 2017 Adjusted for Dispositions during 2018","Closing Interest Balances as of Dec 31, 2017 Adjusted for Disposition in 2018","Projected Interest from January 1, 2018 to December 31, 2018 on December 31, 2017 balance adjusted for disposition during 2019 3","Projected Interest from January 1, 2018 to April 30, 2018 on Dec 31 -17 balance adjusted for disposition during 2018  3","Total Interest","Total Claim","As of Dec 31-17","Variance                           RRR vs. 2017 Balance                        (Principal + Interest)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claim before Forecasted Transactions"]
[null,null,"Group 1 Accounts"]
[null,null,"LV Variance Account",1550,null,null,null,null,{"$f":"E21+F21-G21+H21","v":0},null,null,null,null,{"$f":"J21+K21-L21+M21","v":0},{"$f":"I21","v":0},115767.79999999999,null,null,{"$f":"O21+P21-Q21+SUM(R21:R21)","v":115767.79999999999},{"$f":"N21","v":0},1571.3600000000008,null,null,{"$f":"T21+U21-V21+W21","v":1571.3600000000008},{"$f":"S21","v":115767.79999999999},16682.929999999993,null,null,{"$f":"Y21+Z21-AA21+SUM(AB21:AB21)","v":132450.72999999998},{"$f":"X21","v":1571.3600000000008},1800.8000000000002,null,null,{"$f":"AD21+AE21-AF21+AG21","v":3372.1600000000008},{"$f":"AC21","v":132450.72999999998},288057.23,117339.16,null,{"$f":"AI21+AJ21-AK21+SUM(AL21:AL21)","v":303168.79999999993},{"$f":"AH21","v":3372.1600000000008},2247.7599999999998,1702,null,{"$f":"AN21+AO21-AP21+AQ21","v":3917.92},{"$f":"AM21","v":303168.79999999993},287709.56999999995,15111.23,null,{"$f":"AS21+AT21-AU21+SUM(AV21:AV21)","v":575767.1399999999},{"$f":"AR21","v":3917.92},6269.8600000000006,1892.3000000000002,null,{"$f":"AX21+AY21-AZ21+BA21","v":8295.48},{"$f":"AW21","v":575767.1399999999},471028.0500000001,288057.57,null,{"$f":"BC21+BD21-BE21+SUM(BF21:BF21)","v":758737.61999999988},{"$f":"BB21","v":8295.48},5408.92,6482.1999999999935,null,{"$f":"BH21+BI21-BJ21+BK21","v":7222.2000000000062},{"$f":"BG21","v":758737.61999999988},552752.01,287709.56999999989,null,{"$f":"BM21+BN21-BO21+SUM(BP21:BP21)","v":1023780.06},{"$f":"BL21","v":7222.2000000000062},8152.7710916666665,5244.2199999999993,null,{"$f":"BR21+BS21-BT21+BU21","v":10130.751091666674},{"$f":"BQ21","v":1023780.06},586395.17000000004,471028.05,null,{"$f":"BW21+BX21-BY21+SUM(BZ21:BZ21)","v":1139147.18},{"$f":"BV21","v":10130.751091666674},10283.85,7159.29,null,{"$f":"CB21+CC21-CD21+CE21","v":13255.311091666674},552752.01,9051.7332016666733,{"$f":"CA21-CG21","v":586395.16999999993},{"$f":"CF21-CH21","v":4203.5778900000005},{"$f":"CI21*((1.5%*25%)+(1.89%*75%))","v":10511.133422249999},null,{"$f":"CJ21+CK21+CL21","v":14714.71131225},{"$f":"SUM(CI21:CL21)","v":601109.88131224993},1152402.49,{"$f":"CO21-SUM(CA21,CF21)","v":-1.0916665196418762E-3}]
[null,null,"Smart Metering Entity Charge Variance Account",1551,null,null,null,null,{"$f":"E22+F22-G22+H22","v":0},null,null,null,null,{"$f":"J22+K22-L22+M22","v":0},{"$f":"I22","v":0},0,null,null,0,0,0,null,null,{"$f":"T22+U22-V22+W22","v":0},0,null,null,null,{"$f":"Y22+Z22-AA22+SUM(AB22:AB22)","v":0},{"$f":"X22","v":0},null,null,null,{"$f":"AD22+AE22-AF22+AG22","v":0},0,-17910.510000000431,null,null,-17910.510000000431,0,-71.11,null,null,{"$f":"AN22+AO22-AP22+AQ22","v":-71.11},-17910.510000000431,-18781.050000000076,0,null,-36691.560000000507,-71.11,-365.06,0,null,{"$f":"AX22+AY22-AZ22+BA22","v":-436.17},-36691.560000000507,-22681.349999999657,-17910.510000000431,null,-41462.399999999732,-436.17,-330.71999999999997,-334.39449700000631,null,{"$f":"BH22+BI22-BJ22+BK22","v":-432.49550299999368},{"$f":"BG22","v":-41462.399999999732},-23673.089999999298,-18781.050000000105,null,{"$f":"BM22+BN22-BO22+SUM(BP22:BP22)","v":-46354.439999998925},-432.49550299999368,-366.13353333332844,-325.74311624999581,null,{"$f":"BR22+BS22-BT22+BU22","v":-472.88592008332631},{"$f":"BQ22","v":-46354.439999998925},-27963.919999999998,-22681.35,null,{"$f":"BW22+BX22-BY22+SUM(BZ22:BZ22)","v":-51637.009999998925},-472.88592008332631,-432.21,-356.25,null,{"$f":"CB22+CC22-CD22+CE22","v":-548.84592008332629},-23673.089999999269,-377.03908133332328,{"$f":"CA22-CG22","v":-27963.919999999656},{"$f":"CF22-CH22","v":-171.80683875000301},{"$f":"CI22*((1.5%*25%)+(1.89%*75%))","v":-501.25326599999386},null,{"$f":"CJ22+CK22+CL22","v":-673.06010474999687},{"$f":"SUM(CI22:CL22)","v":-28636.980104749651},-52185.86,{"$f":"CO22-SUM(CA22,CF22)","v":-4.0799177513690665E-3}]
[null,null,"RSVA - Wholesale Market Service Charge",1580,null,null,null,null,{"$f":"E23+F23-G23+H23","v":0},null,null,null,null,{"$f":"J23+K23-L23+M23","v":0},{"$f":"I23","v":0},-5518757.6099999947,null,null,{"$f":"O23+P23-Q23+SUM(R23:R23)","v":-5518757.6099999947},0,-58243.990000000005,null,null,{"$f":"T23+U23-V23+W23","v":-58243.990000000005},-5518757.6099999947,-6544300.1500000022,null,null,{"$f":"Y23+Z23-AA23+SUM(AB23:AB23)","v":-12063057.759999998},{"$f":"X23","v":-58243.990000000005},-125746.44,null,null,{"$f":"AD23+AE23-AF23+AG23","v":-183990.43},-12063057.759999998,-3416930.3099999949,-5577001.5999999996,16968,-9886018.4699999932,-183990.43,-134976.81,-81126,null,{"$f":"AN23+AO23-AP23+AQ23","v":-237841.24},-9886018.4699999932,-750596.12999999523,-6486055.7400000002,-428586,-4579144.8599999882,-237841.24,-28008.970000000005,-198209.45,null,{"$f":"AX23+AY23-AZ23+BA23","v":-67640.760000000009},-4579144.8599999882,-10407994.030000001,-3399962.7300000004,null,-11587176.159999989,-67640.760000000009,-49704.58,-184956.261509,null,{"$f":"BH23+BI23-BJ23+BK23","v":67610.921508999993},-11587176.159999989,-4482608.5399999889,-1179182.1299999952,null,{"$f":"BM23+BN23-BO23+SUM(BP23:BP23)","v":-14890602.569999982},67610.921508999993,-138990.09154250001,104324.321509,null,{"$f":"BR23+BS23-BT23+BU23","v":-175703.49154250004},-14890602.569999982,{"$f":"-4605646.76+173.67","v":-4605473.09},-10407994.029999999,null,{"$f":"BW23+BX23-BY23+SUM(BZ23:BZ23)","v":-9088081.6299999822},-175703.49154250004,-85982.75,-150131.01,null,{"$f":"CB23+CC23-CD23+CE23","v":-111555.23154250003},-4482608.5399999805,-74881.176991499829,-4605473.0900000017,-36674.054551000198,-82553.10513825003,null,{"$f":"CJ23+CK23+CL23","v":-119227.15968925023},{"$f":"SUM(CI23:CL23)","v":-4724700.2496892512},-9199636.8599999994,1.5424825251102448E-3]
[null,null,"Variance WMS – Sub-account CBR Class A",1580,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,124743.51999999997,null,null,{"$f":"BC24+BD24-BE24+SUM(BF24:BF24)","v":124743.51999999997},0,374.96999999999997,null,null,374.96999999999997,124743.51999999997,-124743.54000000001,null,null,{"$f":"BM24+BN24-BO24+SUM(BP24:BP24)","v":-2.0000000033178367E-2},374.96999999999997,-374.97,null,null,-5.6843418860808015E-14,-2.0000000033178367E-2,null,null,null,{"$f":"BW24+BX24-BY24+SUM(BZ24:BZ24)","v":-2.0000000033178367E-2},-5.6843418860808015E-14,null,null,null,-5.6843418860808015E-14,-2.0000000033178367E-2,-2.2000000042180545E-4,0,2.2000000036496203E-4,0,null,{"$f":"CJ24+CK24+CL24","v":2.2000000036496203E-4},2.2000000036496203E-4,0,2.000000003323521E-2]
[null,null,"Variance WMS – Sub-account CBR Class B",1580,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,1108630.1000000001,null,null,1108630.1000000001,0,3562.9900000000002,null,null,3562.9900000000002,1108630.1000000001,-185940.40999999992,null,null,{"$f":"BM25+BN25-BO25+SUM(BP25:BP25)","v":922689.69000000018},3562.9900000000002,11337.264244166667,null,null,14900.254244166666,922689.69000000018,{"$f":"-55141.27-184.99","v":-55326.259999999995},1108630.1000000001,null,{"$f":"BW25+BX25-BY25+SUM(BZ25:BZ25)","v":-241266.66999999993},14900.254244166666,-1607.39,15757.92,null,-2465.055755833333,-185940.40999999992,-2903.0102658333326,-55326.260000000009,437.95450999999957,-991.72321050000016,null,{"$f":"CJ25+CK25+CL25","v":-553.76870050000059},-55880.028700500014,-243731.73,-4.2441667465027422E-3]
[null,null,"RSVA - Retail Transmission Network Charge",1584,null,null,null,null,0,null,null,null,null,0,{"$f":"I26","v":0},631982.58999999706,null,null,631982.58999999706,0,26118.280000000002,null,null,{"$f":"T26+U26-V26+W26","v":26118.280000000002},631982.58999999706,177337.63000000268,null,null,{"$f":"Y26+Z26-AA26+SUM(AB26:AB26)","v":809320.21999999974},26118.280000000002,12236.08,null,null,{"$f":"AD26+AE26-AF26+AG26","v":38354.36},809320.21999999974,3378169.1599999964,658101,null,3529388.3799999962,38354.36,24797.879999999997,9290,null,{"$f":"AN26+AO26-AP26+AQ26","v":53862.239999999998},3529388.3799999962,3491680.4500000104,151219.22,null,6869849.6100000069,53862.239999999998,73256.38,31287.010000000002,null,{"$f":"AX26+AY26-AZ26+BA26","v":95831.609999999986},6869849.6100000069,-1237207.2899999917,3378169.2099999995,null,2254473.1100000157,95831.609999999986,40112.399999999987,74457.239999999991,null,{"$f":"BH26+BI26-BJ26+BK26","v":61486.76999999999},2254473.1100000157,-532829.40000000596,3491680.45000001,null,{"$f":"BM26+BN26-BO26+SUM(BP26:BP26)","v":-1770036.7400000002},61486.76999999999,-12513.329999999998,63012.66,null,{"$f":"BR26+BS26-BT26+BU26","v":-14039.220000000016},-1770036.7400000002,-187534.89,-1237207.29,null,-720364.34000000032,-14039.220000000016,-7639.01,-15135.17,null,-6543.0600000000177,-532829.45000000903,-4765.1739500000931,-187534.88999999128,-1777.8860499999246,-3361.5629032498437,null,{"$f":"CJ26+CK26+CL26","v":-5139.4489532497682},-192674.33895324104,-726907.37,3.0000000377185643E-2]
[null,null,"RSVA - Retail Transmission Connection Charge",1586,null,null,null,null,0,null,null,null,null,0,0,-170342.67000001055,null,null,-170342.67000001055,0,699.95000000000027,null,null,699.95000000000027,-170342.67000001055,-76744.958999998868,null,null,-247087.62900000942,699.95000000000027,-2601.08,null,null,-1901.1299999999997,-247087.62900000942,1314693.9300000034,-169642.72,null,1237249.0209999939,-1901.1299999999997,5832.1399999999994,-2504,null,6435.01,1237249.0209999939,2601535.59,-77444.91,null,3916229.5209999941,6435.01,35834.119999999995,-536.0100000000001,null,42805.14,3916229.5209999941,-230302.05000001192,1314693.9299999992,null,2371233.540999983,42805.14,32228.909999999996,25158.58,null,49875.469999999987,2371233.540999983,941983.46999999881,2601535.5900000003,null,711681.42099998146,49875.469999999987,4911.1400000000003,48669.87000000001,null,6116.7399999999761,711681.42099998146,433359.47,-230302.05,null,1375342.9409999815,6116.7399999999761,12740.23,-1327.72,null,20184.689999999977,941983.47099999338,17806.278180999911,433359.4699999881,2378.4118190000663,7767.968499749787,null,10146.380318749852,{"$f":"SUM(CI27:CL27)","v":443505.85031873797},1395527.63,-9.9998153746128082E-4]
[null,null,"RSVA - Power",1588,null,null,null,null,0,null,null,null,null,0,0,-1031401.6699999867,null,null,-1031401.6699999867,0,-19574.559999999983,null,null,-19574.559999999983,-1031401.6699999867,-541508.42000001669,null,null,-1572910.0900000033,-19574.559999999983,-3471.5899999999997,null,null,-23046.149999999983,-1572910.0900000033,924467.16000005603,-1050976.23,-4668526.9869420975,-4265993.6869420446,-23046.149999999983,11467.690000000002,-15162,-60232.101746408574,-56648.561746408552,-4265993.6869420446,-552173.06000000238,-521933.17,-2337699.4944851007,-6633933.0714271478,-56648.561746408552,-82951.48,-15556.57,null,-124043.47174640856,-6633933.0714271478,-859776.22000002861,-3744060.5233259667,null,-3749648.7681012098,-124043.47174640856,-29325.460000000003,-103602.67174640857,null,-49766.25999999998,-3749648.7681012098,-148172.50999999046,-2889872.5544851031,819534,-188414.72361609712,-49766.25999999998,5680.2400000000007,-54902.530000000006,null,10816.510000000024,-188414.72361609712,{"$f":"-3817332.75+8484","v":-3808848.75},-859776.22,{"$f":"-BP28-587573","v":-1407107},-4544594.2536160974,10816.510000000024,-2168.9499999999998,-4321.2700000000004,null,12968.830000000024,671361.49638393149,22522.756460223274,-5215955.7500000289,-9553.9264602232506,-93496.006818750524,null,-103049.93327897377,-5319005.683279003,-3944052.49,587572.93361609709]
[null,null,"RSVA - Global Adjustment",1589,null,null,null,null,0,null,null,null,null,0,0,1058062.9899999946,null,null,1058062.9899999946,0,69597.939999999988,null,null,69597.939999999988,1058062.9899999946,-3235246.1200000048,null,null,-2177183.1300000101,69597.939999999988,495.22,null,null,70093.159999999989,-2177183.1300000101,-1669046.0400000215,1127660.93,4668526.9869420975,-305363.11305793375,70093.159999999989,-16958.78,15553,60232.101746408574,97813.481746408565,-305363.11305793375,1473743.9699999839,-3304844.06,5344769.4944851007,9817994.4114271514,97813.481746408565,92778.54,5958.9500000000044,null,184633.07174640853,9817994.4114271514,2612620.8600000739,2999480.9533259743,null,9431134.3181012515,184633.07174640853,97517.37999999999,87365.691746408585,null,194784.75999999995,9431134.3181012515,-3004934.7699999809,6818513.4644850846,-1808419,-2200732.9163838141,194784.75999999995,28693.39,178578.15000000002,null,44899.999999999942,-2200732.9163838141,-1322742,2612620.86,{"$f":"-BP29+1842135","v":3650554},-2485541.7763838135,44899.999999999942,-17300.04,{"$f":"16206.61+28738.83","v":44945.440000000002},null,-17345.480000000061,-4813353.7763838582,-52992.331540222513,2327812.0000000447,35646.851540222451,41726.030100000804,null,77372.881640223262,2405184.881640268,-4345022.2699999996,-1842135.0136161861]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2009)4",1595,null,null,null,null,0,null,null,null,null,0,0,-2913895.8499999996,null,null,-2913895.8499999996,0,-2492081.56,null,null,-2492081.56,-2913895.8499999996,2840650.07,null,null,-73245.779999999795,-2492081.56,-9602.92,null,null,-2501684.48,-73245.779999999795,null,null,null,-73245.779999999795,-2501684.48,-1076.7600000000002,null,null,-2502761.2399999998,-73245.779999999795,null,null,null,-73245.779999999795,-2502761.2399999998,-1076.7600000000002,null,null,-2503837.9999999995,-73245.779999999795,null,-73245.780000000261,null,4.6566128730773926E-10,-2503837.9999999995,null,-2503838,null,4.6566128730773926E-10,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.6566128730773926E-10,4.7078356146812434E-10,0,-5.1222741603850847E-12,0,null,-5.1222741603850847E-12,{"$f":"IF(CD30=0,IF(SUM(CG30:CH30)=0,SUM(CI30:CL30),0),SUM(CI30:CL30))","v":0},null,-9.3132257461547852E-10]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2010)4",1595,null,null,null,null,0,null,null,null,null,0,0,1927441.5699999998,null,null,1927441.5699999998,0,-21555.89,null,null,-21555.89,1927441.5699999998,-2230636.5699999998,null,null,-303195,-21555.89,13368.490000000003,null,null,-8187.399999999996,-303195,null,null,null,-303195,-8187.399999999996,-4456.9199999999992,null,null,-12644.319999999996,-303195,null,null,null,-303195,-12644.319999999996,-4456.9199999999992,null,null,-17101.239999999994,-303195,null,-303195,null,0,-17101.239999999994,null,-17101.239999999998,null,3.637978807091713E-12,0,null,null,null,0,3.637978807091713E-12,null,null,null,3.637978807091713E-12,0,null,null,null,0,3.637978807091713E-12,null,null,null,3.637978807091713E-12,0,3.637978807091713E-12,0,0,0,null,0,0,null,-3.637978807091713E-12]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2011)4",1595,null,null,null,null,0,null,null,null,null,0,0,-8695917.6799999997,null,null,{"$f":"O32+P32-Q32+SUM(R32:R32)","v":-8695917.6799999997},0,-154326.92000000001,null,null,-154326.92000000001,-8695917.6799999997,9300673.2400000002,null,null,604755.56000000052,-154326.92000000001,-65930.35000000002,null,null,-220257.27000000002,604755.56000000052,null,null,null,604755.56000000052,-220257.27000000002,8889.9600000000009,null,null,-211367.31000000003,604755.56000000052,null,null,null,604755.56000000052,-211367.31000000003,8889.9600000000009,null,null,-202477.35000000003,604755.56000000052,null,604755.56000000052,null,0,-202477.35000000003,null,-202477.35000000003,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,0,0,0,0,null,0,0,null,0]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2012)4",1595,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,-2039038,-493721.79000000004,1545316.21,0,null,-1284828,2206.5,1287034.5,1545316.21,-2940696.3899999997,null,null,-1395380.1799999997,1287034.5,1788.8500000000006,null,1306.01415,1290129.36415,-1395380.1799999997,null,null,null,-1395380.1799999997,1290129.36415,-20512.079999999998,null,null,1269617.28415,-1395380.1799999997,null,-1395380.1800000002,null,4.6566128730773926E-10,1269617.28415,null,1269617.28,null,4.1499999351799488E-3,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.1499999351799488E-3,null,null,null,4.1499999351799488E-3,4.6566128730773926E-10,null,null,null,4.6566128730773926E-10,4.1499999351799488E-3,null,null,null,4.1499999351799488E-3,4.6566128730773926E-10,4.1499999403022229E-3,0,-5.1222741326295562E-12,0,null,-5.1222741326295562E-12,0,null,-4.1500004008412361E-3]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2013)4",1595,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,5370488.5799999982,4894519.459999999,null,475969.11999999918,0,-30180.3035065,72247,null,-102427.3035065,475969.11999999918,null,null,null,475969.11999999918,-102427.3035065,6996.722171999998,null,null,-95430.581334500006,475969.11999999918,null,475969.12000000011,null,-9.3132257461547852E-10,-95430.581334500006,null,-95430.58,null,-1.3345000043045729E-3,-9.3132257461547852E-10,null,null,null,-9.3132257461547852E-10,-1.3345000043045729E-3,null,null,null,-1.3345000043045729E-3,-9.3132257461547852E-10,null,null,null,-9.3132257461547852E-10,-1.3345000043045729E-3,null,null,null,-1.3345000043045729E-3,-9.3132257461547852E-10,-1.3345000145491212E-3,0,1.0244548265259112E-11,0,null,1.0244548265259112E-11,0,null,1.3345009356271476E-3]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2014)4",1595,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,10296123.939841045,10223947.43,null,72176.509841045365,0,174450.57,175163.77000000002,null,-713.20000000001164,72176.509841045365,null,null,null,72176.509841045365,-713.20000000001164,860.7018008333331,null,null,147.50180083332145,72176.509841045365,null,72176.509999999995,null,-1.5895463002379984E-4,147.50180083332145,null,147.5,null,1.8008333214538652E-3,-1.5895463002379984E-4,null,null,null,-1.5895463002379984E-4,1.8008333214538652E-3,null,null,null,1.8008333214538652E-3,-1.5895463002379984E-4,1.7990848205236033E-3,0,1.7485009302618815E-6,0,null,{"$f":"CJ35+CK35+CL35","v":1.7485009302618815E-6},0,null,-1.6418786914300654E-3]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2015)4",1595,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,-256826.83052762854,-456725.31731672533,null,199898.48678909679,0,1587898.7337583362,1610163.3623086384,4709.509837407868,-17555.118712894371,199898.48678909679,null,null,null,199898.48678909679,-17555.118712894371,2198.883354680067,null,null,-15356.235358214304,199898.48678909679,null,{"$f":"127372+72526","v":199898},null,0.48678909678710625,-15356.235358214304,null,{"$f":"-47712+4715.9+27640","v":-15356.099999999999},null,-0.13535821430559736,0,3.3546799859323073E-3,0.48678909678710625,-0.13871289429152966,8.7256945599088788E-3,null,-0.12998719973162079,{"$f":"IF(CD36=0,IF(SUM(CG36:CH36)=0,SUM(CI36:CL36),0),SUM(CI36:CL36))","v":0.35680189705548548},null,-0.35143088248150889]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2016)4",1595,null,null,null,null,0,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,-8988871.513268102,-9183779.8008410539,null,194908.28757295199,0,47944.961923766954,-343677.95373252931,null,391622.91565629625,194908.28757295199,null,null,null,194908.28757295199,391622.91565629625,{"$f":"2338.9-65.43","v":2273.4700000000003},null,null,393896.38565629622,194908.28757295199,393766.90681959869,0,129.47883669752628,0,null,129.47883669752628,{"$f":"IF(CD37=0,IF(SUM(CG37:CH37)=0,SUM(CI37:CL37),0),SUM(CI37:CL37))","v":0},588804.67000000004,-3.2292482210323215E-3]
[null,null,"Disposition and Recovery/Refund of Regulatory Balances (2017)4",1595,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"7897024.61-458.44","v":7896566.1699999999},8365783.4400000004,null,-469217.27000000048,0,-46776.26,118765,null,-165541.26,0,0,-469217.27000000048,-165541.26,-8410.7195647500084,null,{"$f":"CJ38+CK38+CL38","v":-173951.97956475001},0,-634758.53,{"$f":"CO38-SUM(CA38,CF38)","v":0}]
[]
[null,null,{"$f":"C29","v":"RSVA - Global Adjustment"},1589,{"$f":"E29","v":0},0,0,0,0,0,0,0,0,0,0,1058062.9899999946,0,0,1058062.9899999946,0,69597.939999999988,0,0,69597.939999999988,1058062.9899999946,-3235246.1200000048,0,0,-2177183.1300000101,69597.939999999988,495.22,0,0,70093.159999999989,-2177183.1300000101,-1669046.0400000215,1127660.93,4668526.9869420975,-305363.11305793375,70093.159999999989,-16958.78,15553,60232.101746408574,97813.481746408565,-305363.11305793375,1473743.9699999839,-3304844.06,5344769.4944851007,9817994.4114271514,97813.481746408565,92778.54,5958.9500000000044,0,184633.07174640853,9817994.4114271514,2612620.8600000739,2999480.9533259743,0,9431134.3181012515,184633.07174640853,97517.37999999999,87365.691746408585,0,194784.75999999995,9431134.3181012515,-3004934.7699999809,6818513.4644850846,-1808419,{"$f":"BQ29","v":-2200732.9163838141},194784.75999999995,28693.39,178578.15000000002,0,44899.999999999942,-2200732.9163838141,null,null,null,{"$f":"CA29","v":-2485541.7763838135},{"$f":"CB29","v":44899.999999999942},null,null,null,{"$f":"CF29","v":-17345.480000000061},-4813353.7763838582,-52992.331540222513,2327812.0000000447,35646.851540222451,{"$f":"CK29","v":41726.030100000804},{"$f":"CL29","v":0},{"$f":"CM29","v":77372.881640223262},{"$f":"CN29","v":2405184.881640268},{"$f":"CO29","v":-4345022.2699999996},{"$f":"CO40-SUM(CA40,CF40)","v":-1842135.0136161861}]
[null,null,"Total Group 1 Balance excluding Account 1589 - Global Adjustment",null,{"$f":"SUM(E21:E37)-E29","v":0},{"$f":"SUM(F21:F37)-F29","v":0},0,0,0,0,0,0,0,0,0,-15655123.519999994,0,0,-15655123.519999994,0,-2717393.33,0,0,-2717393.33,-15655123.519999994,2942153.7709999848,-2039038,-493721.79000000004,-11167653.539000012,-2717393.33,-179947.01,-1284828,2206.5,-1610305.8399999996,-11167653.539000012,4900338.8500000592,-1127660.93,-4651558.9869420975,-9791212.7459420469,-1610305.8399999996,-115737.62350649998,-15553,-58926.087596408572,-1769416.5511029081,-9791212.7459420469,15355499.309841059,3304844.06,-2766285.4944851007,-506842.99058609083,-1769416.5511029081,168326.34217200003,-5958.9500000000044,0,-1595131.2589309085,-506842.99058609083,-11310386.100527661,-3328834.650642694,0,-8488394.4404710587,-1595131.2589309085,1591086.8655591696,-121861.83544377051,4709.509837407868,122526.95190943929,-8488394.4404710587,{"$f":"SUM(BN21:BN37)-BN29","v":-12992103.523268089},-6818513.4153261427,819534,-13842450.548413003,{"$f":"SUM(BR21:BR37)-BR29","v":122526.95190943929},-72019.264461552957,-177507.65533977933,0,228015.34278766561,{"$f":"SUM(BW21:BW38)-BW29","v":-13842450.548413003},null,null,null,{"$f":"SUM(CA21:CA38)-CA29","v":-12405762.298413005},{"$f":"SUM(CB21:CB38)-CB29","v":228015.34278766561},null,null,null,{"$f":"SUM(CF21:CF38)-CF29","v":153651.63278766561},-2864046.2452020673,360221.28212308715,{"$f":"SUM(CI21:CI38)-CI29","v":-9541716.0532109365},{"$f":"SUM(CJ21:CJ38)-CJ29","v":-206569.64933542156},{"$f":"SUM(CK21:CK38)-CK29","v":-171035.26025380605},0,{"$f":"SUM(CM21:CM38)-CM29","v":-377604.90958922758},{"$f":"SUM(CN21:CN38)-CN29","v":-9276281.1920738593},{"$f":"SUM(CO21:CO38)-CO29","v":-11664538.050000001},587572.61562533863]
[null,null,"Total Group 1 Balance",null,{"$f":"SUM(E40,E41)","v":0},{"$f":"SUM(F40,F41)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(P40,P41)","v":-14597060.529999999},{"$f":"SUM(Q40,Q41)","v":0},0,-14597060.529999999,0,-2647795.39,0,0,-2647795.39,-14597060.529999999,-293092.34900001995,-2039038,-493721.79000000004,-13344836.669000022,-2647795.39,-179451.79,-1284828,2206.5,-1540212.6799999997,-13344836.669000022,3231292.8100000378,0,16968,-10096575.858999981,-1540212.6799999997,-132696.40350649998,0,1306.0141500000027,-1671603.0693564995,-10096575.858999981,16829243.279841043,0,2578484,9311151.4208410606,-1671603.0693564995,261104.88217200001,0,0,-1410498.1871845,9311151.4208410606,-8697765.240527587,-329353.69731671968,0,942739.87763019279,-1410498.1871845,1688604.2455591694,-34496.143697361927,4709.509837407868,317311.71190943924,942739.87763019279,-15997038.29326807,4.9158941954374313E-2,-988885,-16043183.464796817,317311.71190943924,-43325.874461552958,1070.494660220691,0,272915.34278766555,{"$f":"SUM(BW40,BW41)","v":-16043183.464796817},null,null,null,{"$f":"SUM(CA40,CA41)","v":-14891304.074796818},{"$f":"SUM(CB40,CB41)","v":272915.34278766555},null,null,null,{"$f":"SUM(CF40,CF41)","v":136306.15278766555},-7677400.0215859255,307228.95058286464,-7213904.0532108918,-170922.79779519912,{"$f":"SUM(CK40,CK41)","v":-129309.23015380524},0,-300232.02794900432,{"$f":"SUM(CN40,CN41)","v":-6871096.3104335908},{"$f":"SUM(CO40,CO41)","v":-16009560.32},-1254562.397990847]
[]
[29,null,"LRAM Variance Account (only input amounts if applying for disposition of this account)",1568,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O44+P44-Q44+SUM(R44:R44)","v":0},null,null,null,null,{"$f":"T44+U44-V44+W44","v":0},{"$f":"S44","v":0},-237216,null,null,{"$f":"Y44+Z44-AA44+SUM(AB44:AB44)","v":-237216},{"$f":"X44","v":0},-278,null,null,{"$f":"AD44+AE44-AF44+AG44","v":-278},{"$f":"AC44","v":-237216},null,null,null,{"$f":"AI44+AJ44-AK44+SUM(AL44:AL44)","v":-237216},{"$f":"AH44","v":-278},-3487,null,null,{"$f":"AN44+AO44-AP44+AQ44","v":-3765},{"$f":"AM44","v":-237216},-59871,null,null,{"$f":"AS44+AT44-AU44+SUM(AV44:AV44)","v":-297087},{"$f":"AR44","v":-3765},-3487,null,null,{"$f":"AX44+AY44-AZ44+BA44","v":-7252},{"$f":"AW44","v":-297087},85881,-237216,null,{"$f":"BC44+BD44-BE44+SUM(BF44:BF44)","v":26010},{"$f":"BB44","v":-7252},-1005,-7252,null,{"$f":"BH44+BI44-BJ44+BK44","v":-1005},{"$f":"BG44","v":26010},303456,null,null,{"$f":"BM44+BN44-BO44+SUM(BP44:BP44)","v":329466},{"$f":"BL44","v":-1005},564,null,null,{"$f":"BR44+BS44-BT44+BU44","v":-441},{"$f":"BQ44","v":329466},{"$f":"2283050.55+1.5","v":2283052.0499999998},null,null,{"$f":"BW44+BX44-BY44+SUM(BZ44:BZ44)","v":2612518.0499999998},{"$f":"BV44","v":-441},67737.27,null,null,{"$f":"CB44+CC44-CD44+CE44","v":67296.27},null,null,{"$f":"CA44-CG44","v":2612518.0499999998},{"$f":"CF44-CH44","v":67296.27},{"$f":"CI44*((1.5%*25%)+(1.89%*75%))","v":46829.386046249994},null,{"$f":"CJ44+CK44+CL44","v":114125.65604624999},{"$f":"SUM(CI44:CL44)","v":2726643.7060462497},2679814.3199999998,{"$f":"CO44-SUM(CA44,CF44)","v":0}]
[]
[null,null,"Total including Account 1568",null,{"$f":"SUM(E42,E44)","v":0},{"$f":"SUM(F42,F44)","v":0},0,0,0,0,0,0,0,0,0,-14597060.529999999,0,0,-14597060.529999999,0,-2647795.39,0,0,-2647795.39,-14597060.529999999,-530308.34900001995,-2039038,-493721.79000000004,-13582052.669000022,-2647795.39,-179729.79,-1284828,2206.5,-1540490.6799999997,-13582052.669000022,3231292.8100000378,0,16968,-10333791.858999981,-1540490.6799999997,-136183.40350649998,0,1306.0141500000027,-1675368.0693564995,-10333791.858999981,16769372.279841043,0,2578484,9014064.4208410606,-1675368.0693564995,257617.88217200001,0,0,-1417750.1871845,9014064.4208410606,-8611884.240527587,-566569.69731671968,0,968749.87763019279,-1417750.1871845,1687599.2455591694,-41748.143697361927,4709.509837407868,316306.71190943924,968749.87763019279,-15693582.29326807,4.9158941954374313E-2,-988885,-15713717.464796817,316306.71190943924,-42761.874461552958,1070.494660220691,0,272474.34278766555,{"$f":"SUM(BW42,BW44)","v":-15713717.464796817},null,null,null,{"$f":"SUM(CA42,CA44)","v":-12278786.024796817},272474.34278766555,null,null,null,{"$f":"SUM(CF42,CF44)","v":203602.42278766556},-7677400.0215859255,307228.95058286464,-4601386.003210892,-103626.52779519912,-82479.844107555255,{"$f":"SUM(CL42,CL44)","v":0},{"$f":"SUM(CM42,CM44)","v":-186106.37190275433},{"$f":"SUM(CN42,CN44)","v":-4144452.6043873411},{"$f":"SUM(CO42,CO44)","v":-13329746},{"$f":"CO46-SUM(CA46,CF46)","v":-1254562.3979908489}]
[]
[]
[null,null,"For all OEB-Approved dispositions, please ensure that the disposition amount has the same sign (e.g: debit balances are to have a positive figure and credit balance are to have a negative figure) as per the related OEB decision."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+CA42-BZ28-BZ29","v":-17134751.074796818},{"$f":"+CF42","v":136306.15278766555},{"$f":"+CA50+CB50","v":-16998444.922009151}]
[]
[null,1,"Please provide explanations for the nature of the adjustments.  If the adjustment relates to previously OEB-Approved disposed balances, please provide amounts for adjustments and include supporting documentations."]
[null,2,"For RSVA accounts only, report the net variance to the account during the year.  For all other accounts, record the transactions during the year."]
[null,3,"If the LDC’s rate year begins on January 1, 2017, the projected interest is recorded from January 1, 2016 to December 31, 2016 on the December 31, 2015 balances adjusted for the disposed balances approved by the OEB in the 2016 rate decision.  If the LDC’s rate year begins on May 1, 2017, the projected interest is recorded from January 1, 2016 to April 30, 2017 on the December 31, 2015 balances adjusted for the disposed interest balances approved by the OEB in the 2016 rate decision."]
[null,4,"Include Account 1595 as part of Group 1 accounts (lines 30-36) for review and disposition if the recovery (or refund) period has been completed. If the recovery (or refund) period has not been completed, do not include the respective balance in Account 1595 for disposition at this time."]
[]
[null,null,"Account 1595 - adjustments (2016):"]
[null,null,"These were required due to a comprehensive review of all the dispositions during 2015 and 2016. \nIt was determined that there were a number of reporting errors.  \nPast recovery billings were applied to the wrong year or there was transposition errors whereby billings were applied to interest rather than principal or vice versa."]

{"sheet":"4. Billing Det. for Def-Var","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,8,9],[14,21,15,21],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,15,15,15],[12,1,12,7],[13,3,13,8],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[13,11,13,19],[31,17,31,20],[32,17,32,21],[14,8,15,8],[14,9,15,9],[14,16,15,16],[14,17,15,17],[14,20,15,20],[14,19,15,19],[14,18,15,18]]}
["Back to Index",null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,{"$f":"IF(D18=\"YES\", \"YES\", \"NO\")","v":"NO"}]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Information from the most recent RRR (2017 for 2019 IRM)"]
[null,null,null,null,null,null,null,null,null,null,null,"Approved Recoveries (class allocation %)"]
[null,null,null,"Total Metered kWh","Total Metered kW","Metered kWh for Non-RPP Customers","Metered kW for Non-RPP Customers","Metered kWh for Wholesale Market Participants (WMP)","Metered kW for Wholesale Market Participants (WMP)","Total Metered kWh less WMP consumption\n(if applicable)","Total Metered kW less WMP consumption \n(if applicable)","1595 Recovery Proportion (2009) 1","1595 Recovery Proportion (2010) 1","1595 Recovery Proportion (2011) 1","1595 Recovery Proportion (2012) 1","1595 Recovery Proportion (2013) 1","1595 Recovery Proportion (2014) 1","1595 Recovery Proportion (2015) 1","1595 Recovery Proportion (2016) 1","1595 Recovery Proportion (2017) 1","1568 LRAM Variance Account Class Allocation                           ($ amounts)","Number of Customers for Residential and GS<50 classes3"]
[null,"Rate Class","Unit"]
[null,"RESIDENTIAL","kWh",1537580328.6899991,0,70075468,0,null,null,{"$f":"D17-H17","v":1537580328.6899991},{"$f":"E17-I17","v":0},null,null,null,null,null,null,{"$f":"+$D17/$D$29","v":0.29782845376443828},{"$f":"+$D17/$D$29","v":0.29782845376443828},0.29521796842914355,314148.05376999005,225004]
[null,"GENERAL SERVICE LESS THAN 50 KW","kWh",558828431.00972259,0,103616724,0,null,null,{"$f":"D18-H18","v":558828431.00972259},{"$f":"E18-I18","v":0},null,null,null,null,null,null,{"$f":"+$D18/$D$29","v":0.10824475601156623},{"$f":"+$D18/$D$29","v":0.10824475601156623},0.10964625837666012,277384.81461151555,18847]
[null,"GENERAL SERVICE 50 TO 4,999 KW","kW",1751908545.0163753,4824433.3829784254,1588736386,4041629.4929784252,null,null,{"$f":"D19-H19","v":1751908545.0163753},{"$f":"E19-I19","v":4824433.3829784254},null,null,null,null,null,null,{"$f":"+$D19/$D$29","v":0.33934370995983959},0.33934370995983959,0.33543396370843093,-65768.436887662494]
[null,"LARGE USE (1)","kW",220526376.81002384,456125.73797999998,220526376.81002384,456125.73797999998,34953648.313999996,117811.20582,185572728.49602383,338314.53215999994,null,null,null,null,null,null,4.2715836430842653E-2,4.2715836430842653E-2,4.5400090140208287E-2,8001.7932345831623]
[null,"LARGE USE (2)","kW",1050812632.4245863,1982813.5380800001,1050812632.4245863,1982813.5380800001,743436642.68899989,1192576.56012,307375989.7355864,790236.97796000005,null,null,null,null,null,null,0.20354182195982801,0.20354182195982801,0.20561734349921015,11758.412107540107]
[null,"UNMETERED SCATTERED LOAD","kWh",11347508.416576881,0,427147,0,null,null,11347508.416576881,0,null,null,null,null,null,null,2.1980060636359938E-3,2.1980060636359938E-3,2.124971106046081E-3]
[null,"SENTINEL LIGHTING","kW",439954.02282899455,946.91011767210034,5557,16.169999999999959,null,null,{"$f":"D23-H23","v":439954.02282899455},946.91011767210034,null,null,null,null,null,null,8.5218849319073048E-5,8.5218849319073048E-5,7.9695953529687299E-5]
[null,"STREET LIGHTING","kW",31193672.300799686,87344.171000000002,30966099.30725503,86709.010999999999,null,null,{"$f":"D24-H24","v":31193672.300799686},87344.171000000002,null,null,null,null,null,null,6.0421969605302132E-3,6.0421969605302132E-3,6.4797087867712183E-3,104278.5625944291]
[null,null,null,null,null,null,null,null,null,{"$f":"D25-H25","v":0},0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,0,0,0]
[null,null,"Total",{"$f":"SUM(D17:D28)","v":5162637448.6909122},{"$f":"SUM(E17:E28)","v":7351663.7401560973},3065166390.5418653,6567293.9500384256,778390291.0029999,1310387.7659400001,4384247157.6879129,6041275.974216097,0,0,0,0,0,0,1.0000000000000002,{"$f":"SUM(S17:S28)","v":1.0000000000000002},0.99999999999999989,649803.19943039538,243851]
[]
[]
[null,"Threshold Test",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1568 Account Balance from Continuity Schedule",null,null,null,{"$f":"'3. Continuity Schedule'!CN44","v":2726643.7060462497}]
[null,"Total Claim per Continuity (including Account 1568)",null,{"$f":"'3. Continuity Schedule'!CN46","v":-4144452.6043873411},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V32=U29,\"Total Balance of Account 1568 in Column R matches the amount entered on the Continuity Schedule\",\"Total Balance of Account 1568 in Column T DOES NOT MATCH the amount entered on the Continuity Schedule\")","v":"Total Balance of Account 1568 in Column T DOES NOT MATCH the amount entered on the Continuity Schedule"}]
[null,"Total Claim for Threshold Test (All Group 1 Accounts)",null,{"$f":"+'3. Continuity Schedule'!CN42","v":-6871096.3104335908}]
[null,"Threshold Test (Total claim per kWh) 2",null,{"$f":"IFERROR(D34/D29,\"\")","v":-1.3309275304962372E-3}]
[null,"Exceeds Threshold?",null,{"$f":"IF(D35=\"\",\"\",IF(OR(D35>0.001,D35<-0.001),\"Yes\",\"No\"))","v":"Yes"}]
[null,"ELECT TO DISPOSE of the Group 1 Account Balances?",null,"Yes"]
[]
[]
[null,"As per Section 3.2.5 of the 2017 Filing Requirements for Electricity Distribution Rate Applications, an applicant may elect to dispose of the Group 1 account balances below the threshold. "]
[null,"1 Residual Account balance to be allocated to rate classes in proportion to the recovery share as established when rate riders were implemented."]
[null,"2 The Threshold Test does not include the amount in 1568."]
[null,"3 The proportion of customers for the Residential and GS<50 Classes will be used to allocate Account 1551."]

{"sheet":"5. Allocating Def-Var Balances","index":3,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,8,7],[13,22,14,22],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,19,14,19],[13,20,14,20],[13,14,14,14],[10,1,11,11],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,21,14,21]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"No input required.  This workshseet allocates the deferral/variance account balances (Group 1 and 1568) to the appropriate classes as per EDDVAR dated July 31, 2009"]
[]
[null,"Allocation of Group 1 Accounts (including Account 1568)"]
[null,null,"% of  Total kWh","% of  Total non-RPP kWh","% of Customer Numbers **","% of  Total kWh adjusted for WMP",null,null,"allocated based on Total less WMP",null,null,null,null,"allocated based on Total less WMP","1595_(2009)","1595_(2010)","1595_(2011)","1595_(2012)","1595_(2013)","1595_(2014)","1595_(2015)","1595_(2017)",1568]
[null,"Rate Class",null,null,null,null,1550,1551,1580,"1580 (Class A)","1580 (Class B)",1584,1586,1588]
[null,{"$f":"'4. Billing Det. for Def-Var'!B17","v":"RESIDENTIAL"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D17/'4. Billing Det. for Def-Var'!D$29,\"\")","v":0.29782845376443828},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F17/'4. Billing Det. for Def-Var'!F$29,\"\")","v":2.2861880587047655E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V17/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0.92271099974984727},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J17/'4. Billing Det. for Def-Var'!J$29,\"\")","v":0.35070566813136994},{"$f":"IFERROR(G$28*C16,\"\")","v":179027.62649375241},{"$f":"IFERROR(H$28*E16,\"\")","v":-26423.656542270037},{"$f":"IFERROR(I$28*F16,\"\")","v":-1656979.1577877193},null,null,{"$f":"IFERROR(L$28*$C16,\"\")","v":-57383.900450529058},{"$f":"IFERROR(M$28*$C16,\"\")","v":132088.66163591214},{"$f":"IFERROR(N$28*$F16,\"\")","v":-1865405.4419489165},{"$f":"'4. Billing Det. for Def-Var'!$L17*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L17*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L17*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L17*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L17*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L17*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T17","v":0.10533433118038484},{"$f":"'4. Billing Det. for Def-Var'!U17","v":314148.05376999005}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B18","v":"GENERAL SERVICE LESS THAN 50 KW"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D18/'4. Billing Det. for Def-Var'!D$29,\"\")","v":0.10824475601156623},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F18/'4. Billing Det. for Def-Var'!F$29,\"\")","v":3.3804600076435806E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V18/'4. Billing Det. for Def-Var'!V$29,\"\")","v":7.7289000250152756E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J18/'4. Billing Det. for Def-Var'!J$29,\"\")","v":0.12746280282802935},{"$f":"IFERROR(G$28*C17,\"\")","v":65066.99243878603},{"$f":"IFERROR(H$28*E17,\"\")","v":-2213.3235624796152},{"$f":"IFERROR(I$28*F17,\"\")","v":-602223.53634768212},null,null,{"$f":"IFERROR(L$28*$C17,\"\")","v":-20855.986809683389},48007.182557454005,{"$f":"IFERROR(N$28*$F17,\"\")","v":-677975.37264895916},{"$f":"'4. Billing Det. for Def-Var'!$L18*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L18*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L18*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L18*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L18*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L18*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T18","v":3.9121992993828243E-2},{"$f":"'4. Billing Det. for Def-Var'!U18","v":277384.81461151555}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B19","v":"GENERAL SERVICE 50 TO 4,999 KW"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D19/'4. Billing Det. for Def-Var'!D$29,\"\")","v":0.33934370995983959},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F19/'4. Billing Det. for Def-Var'!F$29,\"\")","v":0.51831978547798851},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V19/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J19/'4. Billing Det. for Def-Var'!J$29,\"\")","v":0.39959164755215715},{"$f":"IFERROR(G$28*C18,\"\")","v":203982.85721801774},0,{"$f":"IFERROR(I$28*F18,\"\")","v":-1887950.7569634162},null,null,-65382.82499445245,150500.92063605384,{"$f":"IFERROR(N$28*$F18,\"\")","v":-2125430.2443207442},{"$f":"'4. Billing Det. for Def-Var'!$L19*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L19*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L19*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L19*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L19*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L19*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T19","v":0.11968347458800903},{"$f":"'4. Billing Det. for Def-Var'!U19","v":-65768.436887662494}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B20","v":"LARGE USE (1)"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D20/'4. Billing Det. for Def-Var'!D$29,\"\")","v":4.2715836430842653E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F20/'4. Billing Det. for Def-Var'!F$29,\"\")","v":7.1945972489617052E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V20/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J20/'4. Billing Det. for Def-Var'!J$29,\"\")","v":4.2327159446432283E-2},25676.911367097309,0,-199983.14080519535,null,null,-8230.2455471473786,18944.723358336996,-225138.40165262987,{"$f":"'4. Billing Det. for Def-Var'!$L20*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L20*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L20*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L20*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L20*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L20*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T20","v":1.619883828851636E-2},{"$f":"'4. Billing Det. for Def-Var'!U20","v":8001.7932345831623}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B21","v":"LARGE USE (2)"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D21/'4. Billing Det. for Def-Var'!D$29,\"\")","v":0.20354182195982801},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F21/'4. Billing Det. for Def-Var'!F$29,\"\")","v":0.34282400970696469},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V21/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J21/'4. Billing Det. for Def-Var'!J$29,\"\")","v":7.0109183784630644E-2},122351.00044035132,0,-331244.87813275401,null,null,-39217.285995448139,90271.988823718697,-372911.1470005025,{"$f":"'4. Billing Det. for Def-Var'!$L21*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L21*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L21*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L21*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L21*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L21*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T21","v":7.3364658228027582E-2},{"$f":"'4. Billing Det. for Def-Var'!U21","v":11758.412107540107}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B22","v":"UNMETERED SCATTERED LOAD"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D22/'4. Billing Det. for Def-Var'!D$29,\"\")","v":2.1980060636359938E-3},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F22/'4. Billing Det. for Def-Var'!F$29,\"\")","v":1.3935524065448473E-4},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V22/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J22/'4. Billing Det. for Def-Var'!J$29,\"\")","v":2.5882456003144517E-3},1321.2431640358379,0,-12228.684634062796,null,null,-423.49936532628055,974.82854825862353,-13766.893057794443,{"$f":"'4. Billing Det. for Def-Var'!$L22*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L22*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L22*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L22*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L22*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L22*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T22","v":7.5819372182533496E-4},{"$f":"'4. Billing Det. for Def-Var'!U22","v":0}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B23","v":"SENTINEL LIGHTING"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D23/'4. Billing Det. for Def-Var'!D$29,\"\")","v":8.5218849319073048E-5},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F23/'4. Billing Det. for Def-Var'!F$29,\"\")","v":1.812952150704492E-6},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V23/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J23/'4. Billing Det. for Def-Var'!J$29,\"\")","v":1.0034881862385919E-4},51.225892399754507,0,-474.11808840816889,null,null,-16.419485458908255,37.795058230439899,-533.75593657064087,{"$f":"'4. Billing Det. for Def-Var'!$L23*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L23*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L23*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L23*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L23*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L23*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T23","v":2.8435667407038243E-5},{"$f":"'4. Billing Det. for Def-Var'!U23","v":0}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B24","v":"STREET LIGHTING"},{"$f":"IFERROR('4. Billing Det. for Def-Var'!D24/'4. Billing Det. for Def-Var'!D$29,\"\")","v":6.0421969605302132E-3},{"$f":"IFERROR('4. Billing Det. for Def-Var'!F24/'4. Billing Det. for Def-Var'!F$29,\"\")","v":1.0102583469141063E-2},{"$f":"IFERROR('4. Billing Det. for Def-Var'!V24/'4. Billing Det. for Def-Var'!V$29,\"\")","v":0},{"$f":"IFERROR('4. Billing Det. for Def-Var'!J24/'4. Billing Det. for Def-Var'!J$29,\"\")","v":7.1149438384422777E-3},3632.0242978095539,0,-33615.976930013232,null,null,-1164.176305195441,2679.7497007732463,-37844.426712885397,{"$f":"'4. Billing Det. for Def-Var'!$L24*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L24*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L24*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L24*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L24*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L24*T$28","v":0},0,{"$f":"+$V$28*'4. Billing Det. for Def-Var'!T24","v":2.3119723874870692E-3},{"$f":"'4. Billing Det. for Def-Var'!U24","v":104278.5625944291}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'4. Billing Det. for Def-Var'!$L25*O$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L25*P$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L25*Q$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L25*R$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L25*S$28","v":0},{"$f":"'4. Billing Det. for Def-Var'!$L25*T$28","v":0}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B26","v":0}]
[]
[]
[null,null,{"$f":"SUM(C16:C27)","v":1.0000000000000002},{"$f":"SUM(D16:D27)","v":1},{"$f":"SUM(E16:E27)","v":1},{"$f":"SUM(F16:F27)","v":0.99999999999999989},{"$f":"'3. Continuity Schedule'!CN21","v":601109.88131224993},{"$f":"'3. Continuity Schedule'!CN22","v":-28636.980104749651},{"$f":"'3. Continuity Schedule'!CN23","v":-4724700.2496892512},null,null,{"$f":"'3. Continuity Schedule'!CN26","v":-192674.33895324104},{"$f":"'3. Continuity Schedule'!CN27","v":443505.85031873797},{"$f":"'3. Continuity Schedule'!CN28","v":-5319005.683279003},{"$f":"SUM('3. Continuity Schedule'!CN30:CN38)","v":0.35680189705548548},0.35680189705548548,0.35680189705548548,0.35680189705548548,0.35680189705548548,0.35680189705548548,0.35680189705548548,0.35680189705548548,{"$f":"SUM(W16:W27)","v":649803.19943039538}]
[null,null,null,null,null,null,{"$f":"SUM(G16:G27)-G28","v":0},{"$f":"SUM(H16:H27)-H28","v":0},0,0,0,0,0,0,-0.35680189705548548,-0.35680189705548548,-0.35680189705548548,-0.35680189705548548,-0.35680189705548548,-0.35680189705548548,-0.35680189705548548,0,0]
[]
[]
[null,"** Used to allocate Account 1551 as this account records the variances arising from the Smart Metering Entity Charges to Residential and GS<50 customers."]

{"sheet":"6. GA Calculation","index":4,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,1,12,11],[1,1,8,6]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this tab is to calculate the GA rate riders for all current Class B customers of the distributor.\nIdentify the total billed consumption for former Class B customers prior to becoming Class A customers in  Column G.\nEffective January 2017, the billing determinant and all rate riders for the disposition of GA balances will be calculated on an energy basis (kWhs) regardless of the billing determinant used for distribution rates for the particular class (see Chapter 3, Filing Requirements, section 3.2.5.2)"]
[null,null,"Total Metered Non-RPP consumption minus WMP",null,"Total  Metered Class A Consumption in 2017 (partial and/or full year Class A customers)*",null,"Total Metered Consumption for New Class A customer(s) in the period prior to becoming Class A (i.e. Jan. 1 - June 30, 2017) ","Total Metered Consumption for New Class B customer(s) in the period after becoming Class B (i.e. Jul 1 - Dec 31, 2017) ","Metered Consumption for Current Class B Customers (Non-RPP consumption LESS WMP, Class A and new Class A's former Class B consumption if applicable)",null,"% of total kWh","Total GA $ allocated to Current Class B Customers","GA Rate Rider",null,"Revenue Reconciliation","Variance"]
[null,null,"kWh","kW","kWh","kW","kWh","kWh","kWh","kW"]
[]
[null,{"$f":"'4. Billing Det. for Def-Var'!B17","v":"RESIDENTIAL"},{"$f":"'4. Billing Det. for Def-Var'!F17-'4. Billing Det. for Def-Var'!H17","v":70075468},null,null,null,null,null,{"$f":"C17-E17-G17-H17","v":70075468},null,{"$f":"IFERROR(I17/I$29,\"\")","v":5.1539068032311654E-2},{"$f":"IFERROR(L$29*K17,\"\")","v":112879.33056458717},{"$f":"IFERROR(L17/I17,\"\")","v":1.6108252115360423E-3},"kwh",{"$f":"ROUND(M17,4)*I17","v":112120.7488},{"$f":"L17-O17","v":758.58176458717207}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B18","v":"GENERAL SERVICE LESS THAN 50 KW"},{"$f":"'4. Billing Det. for Def-Var'!F18-'4. Billing Det. for Def-Var'!H18","v":103616724},null,null,null,null,null,{"$f":"C18-E18-G18-H18","v":103616724},null,{"$f":"IFERROR(I18/I$29,\"\")","v":7.6207973202851234E-2},{"$f":"IFERROR(L$29*K18,\"\")","v":166908.43135597173},{"$f":"IFERROR(L18/I18,\"\")","v":1.6108252115360423E-3},"kwh",{"$f":"ROUND(M18,4)*I18","v":165786.75840000002},{"$f":"L18-O18","v":1121.672955971706}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B19","v":"GENERAL SERVICE 50 TO 4,999 KW"},{"$f":"'4. Billing Det. for Def-Var'!F19-'4. Billing Det. for Def-Var'!H19","v":1588736386},null,294613747,null,127847550,5633530,{"$f":"C19-E19-G19-H19","v":1160641559},null,0.85362803813781529,{"$f":"IFERROR(L$29*K19,\"\")","v":1869590.684793697},{"$f":"IFERROR(L19/I19,\"\")","v":1.6108252115360423E-3},"kwh",1857026.4944000002,12564.190393696772]
[null,{"$f":"'4. Billing Det. for Def-Var'!B20","v":"LARGE USE (1)"},{"$f":"'4. Billing Det. for Def-Var'!F20-'4. Billing Det. for Def-Var'!H20","v":185572728.49602383},null,184005518,null,null,null,1567210.4960238338,null,1.1526511442709916E-3,2524.5021787790979,1.6108252115360423E-3,"kwh",2507.536793638134,16.965385140963917]
[null,{"$f":"'4. Billing Det. for Def-Var'!B21","v":"LARGE USE (2)"},{"$f":"'4. Billing Det. for Def-Var'!F21-'4. Billing Det. for Def-Var'!H21","v":307375989.7355864},null,315018495,null,null,null,-7642505.2644135952,null,{"$f":"IFERROR(I21/I$29,\"\")","v":-5.6209057178171432E-3},-12310.740159214349,0,"kwh",0,-12310.740159214349]
[null,{"$f":"'4. Billing Det. for Def-Var'!B22","v":"UNMETERED SCATTERED LOAD"},{"$f":"'4. Billing Det. for Def-Var'!F22-'4. Billing Det. for Def-Var'!H22","v":427147},null,null,null,null,null,427147,null,3.141578489750197E-4,688.05915663198596,1.6108252115360426E-3,"kwh",683.43520000000001,4.6239566319859478]
[null,{"$f":"'4. Billing Det. for Def-Var'!B23","v":"SENTINEL LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!F23-'4. Billing Det. for Def-Var'!H23","v":5557},null,null,null,null,null,5557,null,4.0870594122261993E-6,8.951355700505788,1.6108252115360426E-3,"kwh",8.8911999999999995,6.0155700505788445E-2]
[null,{"$f":"'4. Billing Det. for Def-Var'!B24","v":"STREET LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!F24-'4. Billing Det. for Def-Var'!H24","v":30966099.30725503},null,null,null,null,null,30966099.30725503,null,2.277493029218065E-2,49880.973467055184,1.6108252115360426E-3,"kwh",49545.758891608049,335.21457544713485]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C17:C28)","v":2286776099.5388651},{"$f":"SUM(D17:D28)","v":0},793637760,0,127847550,5633530,1359657259.5388653,0,1,{"$f":"'6B. GA Allocation_new Class B'!D28","v":2190170.1927132085},null,null,{"$f":"SUM(O17:O28)","v":2187679.6236852463},{"$f":"SUM(P17:P28)","v":2490.5690279618916}]
[null,null,null,null,null,null,null,null,null,null,null,"from Sheet 6B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE: if rate rider is at 5 decimal places, then the balance dispostion is in full"]
[null,"*For new Class A customers (who became Class A in 2017), add their consumption only related to July to December period."]

{"sheet":"6A. GA Allocation_Class A","index":5,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[30,1,30,3],[1,1,8,7],[28,1,28,5],[11,1,11,6],[13,3,13,10],[15,1,15,6],[22,1,22,3]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tab allocates the GA balance to former Class B customers who contributed to the current GA balance but are now Class A customers. The tables below calculate specific amounts for each customer who made the change. Consistent with both decisions for 2016 rates and EDDVAR, distributors are generally expected to settle the amount through 12 equal adjustments to bills. A one-time settlement is acceptable if the affected customer has expressed a clear preference for this approach. (see Filing Requirements section 3.2.5.2)"]
[]
[null,"Year of Group 1 Account Balance Last Disposed",2016,"(e.g. If in the 2017 EDR process, you received approval to dispose the GA variance account balance as of December 31, 2014, please enter 2014 in cell C16.)"]
[]
[null,"Allocation of total Non-RPP consumption (kWh) between Class B and New Class A (Former Class B) customers"]
[null,null,null,"Total",2017,2016,2015,2014,2013,2012]
[null,"Total Class B Consumption for Years Since Last Disposition (Non-RPP consumption LESS WMP and Class A)","A",{"$f":"SUM(E18:J18)","v":1493138339.5388651},{"$f":"'6. GA Calculation'!C29-'6. GA Calculation'!E29","v":1493138339.5388651},null,0]
[null,"New Class A Customer(s)' Former Class B Consumption","B",{"$f":"SUM(E19:J19)","v":127847550},{"$f":"E69","v":127847550},null,0,{"$f":"H69","v":0},{"$f":"I69","v":0},{"$f":"J69","v":0}]
[null,"Portion of Consumption of Former Class B Customers","C=B/A",{"$f":"IFERROR(+D19/D18,0)","v":8.5623379036321529E-2}]
[]
[]
[null,"Allocation of Total GA Balance $"]
[]
[null,"Total GA Balance","D",{"$f":"'3. Continuity Schedule'!CN29","v":2405184.881640268}]
[null,"New Class A Customer(s)' Former Class B Portion of GA Balance","E=C*D",{"$f":"+D20*D25","v":205940.0567731148}]
[null,"GA Balance to be disposed to Current Class B Customers (if no Class A to Class  B Transition Customers)","F=D-E",{"$f":"+D25-D26","v":2199244.8248671531},null,null,null,null,null,null,null,null,null,null,null,"s"]
[]
[null,"Allocation of GA Balances to Former Class B Customers"]
[]
[null,"# of Former Class B customer(s)",null,null,null,2,9]
[null,"Customer",null,"Total Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A",2017,"Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2016","Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2015","Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2014","Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2013","Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2012","% of kWh","Customer specific GA allocation for the period prior to becoming Class A","Monthly Equal Payments"]
[null,"Customer 1",null,{"$f":"SUM(E33:J33)","v":1112523},1112523,null,null,null,null,null,{"$f":"IFERROR(+D33/$D$69,0)","v":8.7019500960323452E-3},{"$f":"+K33*$D$26","v":1792.080096813713},{"$f":"+L33/12","v":149.34000806780941}]
[null,"Customer 2",null,{"$f":"SUM(E34:J34)","v":11119481},11119481,null,null,null,null,null,8.6974533340685833E-2,{"$f":"+K34*$D$26","v":17911.540333996007},{"$f":"+L34/12","v":1492.6283611663339}]
[null,"Customer 3",null,1259299,1259299,null,null,null,null,null,9.8500049472985598E-3,2028.510578062127,169.04254817184392]
[null,"Customer 4",null,2132444,2132444,null,null,null,null,null,1.6679584395633707E-2,3434.9945573887653,286.24954644906376]
[null,"Customer 5",null,1331127,1331127,null,null,null,null,null,1.0411830340119933E-2,2144.2129313563382,178.68441094636151]
[null,"Customer 6",null,2762887,2762887,null,null,null,null,null,2.1610793480203571E-2,4450.5280362251824,370.87733635209855]
[null,"Customer 7",null,6256539,6256539,null,null,null,null,null,4.8937496260194273E-2,10078.190758158502,839.84922984654179]
[null,"Customer 8",null,999971,999971,null,null,null,null,null,7.8215890722974357E-3,{"$f":"+K40*$D$26","v":1610.7784976049084},{"$f":"+L40/12","v":134.23154146707569}]
[null,"Customer 9",null,7013680,7013680,null,null,null,null,null,5.4859713776290592E-2,11297.812569646112,941.48438080384267]
[null,"Customer 10",null,3468287,3468287,null,null,null,null,null,2.7128302419561424E-2,5586.8041404427076,465.56701170355899]
[null,"Customer 11",null,5796244,5796244,null,null,null,null,null,4.5337153508221317E-2,9336.7359674145191,778.06133061787659]
[null,"Customer 12",null,7763800,7763800,null,null,null,null,null,6.0727014322918195E-2,12506.124777323528,1042.1770647769606]
[null,"Customer 13",null,5278662,5278662,null,null,null,null,null,4.1288722388500995E-2,8503.0018327772705,708.5834860647725]
[null,"Customer 14",null,3940838,3940838,null,null,null,null,null,3.0824509347265553E-2,6348.0012049792758,529.00010041493965]
[null,"Customer 15",null,6298192,6298192,null,null,null,null,null,4.9263298358083511E-2,10145.286460694611,845.44053839121761]
[null,"Customer 16",null,4930067,4930067,null,null,null,null,null,3.8562076473111918E-2,7941.4762181618635,661.78968484682196]
[null,"Customer 17",null,3018648,3018648,null,null,null,null,null,2.3611308937871708E-2,4862.5143031528523,405.20952526273771]
[null,"Customer 18",null,3108153,3108153,null,null,null,null,null,2.4311400570445035E-2,5006.6912137113859,417.22426780928214]
[null,"Customer 19",null,1506099,1506099,null,null,null,null,null,1.1780429112642363E-2,2426.0622402692225,202.17185335576855]
[null,"Customer 20",null,2076084,2076084,null,null,null,null,null,1.6238746851230234E-2,3344.2084484665938,278.68403737221615]
[null,"Customer 21",null,5424020,5424020,null,null,null,null,null,4.2425685904813978E-2,8737.1481638757268,728.09568032297727]
[null,"Customer 22",null,2583905,2583905,null,null,null,null,null,2.0210829225902255E-2,4162.2193182140381,346.85160985116983]
[null,"Customer 23",null,2529573,2529573,null,null,null,null,null,1.9785854324154042E-2,{"$f":"+K55*$D$26","v":4074.6999628208628},339.55833023507188,"These two accounts (Bartek) are now combined - adjustment to be made to account 219286"]
[null,"Customer 24",null,3390659,3390659,null,null,null,null,null,2.6521110494491292E-2,5461.7590009215874,455.14658341013228,"Account 219454 (Bartek) now combined with above account number"]
[null,"Customer 25",null,1161128,1161128,null,null,null,null,null,9.0821294580928618E-3,1870.3742562204222,155.86452135170185,"This customer account shut down and left premise/ premise now occupied by Class B customer.  Should this credit be removed and allocated to the remainder of the Class A customers?"]
[null,"Customer 26",null,2421761,2421761,null,null,null,null,null,1.8942568707808635E-2,3901.0336751147383,325.08613959289488]
[null,"Customer 27",null,1568280,1568280,null,null,null,null,null,1.2266797447428597E-2,2526.2249627477449,210.51874689564542]
[null,"Customer 28",null,3124881,3124881,null,null,null,null,null,2.4442243906903183E-2,5033.6370978499608,419.4697581541634]
[null,"Customer 29",null,2706410,2706410,null,null,null,null,null,2.116904078333922E-2,4359.5534607532618,363.29612172943848]
[null,"Customer 30",null,3613039,3613039,null,null,null,null,null,2.8260525915436003E-2,5819.9743114629728,484.99785928858108]
[null,"Customer 31",null,3605652,3605652,null,null,null,null,null,2.8202746161346073E-2,5808.0751456253556,484.00626213544632]
[null,"Customer 32",null,1802628,1802628,null,null,null,null,null,1.4099824361123853E-2,2903.7186294207936,241.9765524517328]
[null,"Customer 33",null,736499,736499,null,null,null,null,null,5.7607595921861619E-3,1186.371157471084,98.86426312259033]
[null,"Customer 34",null,3439510,3439510,null,null,null,null,null,2.6903214023264427E-2,5540.449423330334,461.70411861086114]
[null,"Customer 35",null,792832,792832,null,null,null,null,null,6.2013859475601998E-3,1277.113774112544,106.426147842712]
[null,"Customer 36",null,7773748,7773748,null,null,null,null,null,6.0804825747540724E-2,12522.149266527889,1043.512438877324]
[null,"Total",null,{"$f":"SUM(D33:D68)","v":127847550},{"$f":"SUM(E33:E68)","v":127847550},{"$f":"SUM(F33:F43)","v":0},{"$f":"SUM(G33:G43)","v":0},{"$f":"SUM(H33:H39)","v":0},0,0,{"$f":"SUM(K33:K68)","v":1},{"$f":"SUM(L33:L68)","v":205940.0567731148}]

{"sheet":"6B. GA Allocation_new Class B","index":6,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[30,1,30,3],[1,1,8,7],[11,1,11,6],[13,3,13,10],[15,1,15,6],[22,1,22,3],[29,1,29,5]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tab allocates the GA balance to former Class A customers who contributed to the current Class B GA balance once switched to Class B customers. The tables below calculate specific amounts for each customer who made the transition. Consistent with both decisions for 2016 rates and EDDVAR, distributors are generally expected to settle the amount through 12 equal adjustments to bills. A one-time settlement is acceptable if the affected customer has expressed a clear preference for this approach. (see Filing Requirements section 3.2.5.2)"]
[]
[null,"Year of Group 1 Account Balance Last Disposed",2016,"(e.g. If in the 2017 EDR process, you received approval to dispose the GA variance account balance as of December 31, 2014, please enter 2014 in cell C16.)"]
[]
[null,"Allocation of total Non-RPP consumption (kWh) between Class B and New Class B (Former Class A) customers"]
[null,null,null,"Total",2017,2016,2015,2014,2013,2012]
[null,"Total Class B Consumption for Years Since Last Disposition (Non-RPP consumption LESS WMP and Class A)","A",{"$f":"SUM(E18:J18)","v":1493138339.5388651},{"$f":"'6. GA Calculation'!C29-'6. GA Calculation'!E29","v":1493138339.5388651}]
[null,"New Class B Customer(s)'  Consumption","B",{"$f":"SUM(E19:J19)","v":5633530},{"$f":"E42","v":5633530},null,{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0}]
[null,"Portion of Consumption of New Class B Customers","C=B/A",{"$f":"IFERROR(+D19/D18,0)","v":3.7729457819292464E-3}]
[]
[]
[null,"Allocation of Total GA Balance $"]
[]
[null,"Total GA Calss B Balance adjusted for Class A","D",{"$f":"'6A. GA Allocation_Class A'!D25","v":2405184.881640268}]
[null,"New Class B Customer(s)' Former Class A Portion of GA Balance attributable to Class B","E=C*D",{"$f":"+D20*D25","v":9074.6321539446435}]
[null,"New Class A Customer(s)' Former Class B Portion of GA Balance","F=Sheet 6A",{"$f":"'6A. GA Allocation_Class A'!D26","v":205940.0567731148}]
[null,"GA Balance to be disposed to Current Class B Customers","G=D-E-F",{"$f":"+D25-D26-D27","v":2190170.1927132085},null,"Input into Sheet 6. GA Calculation",null,null,null,null,null,null,null,null,null,"s"]
[]
[null,"Allocation of GA Balances to Former Class A Customers"]
[null,"# of Former Class B customer(s)",null,null,2017]
[null,"Customer",null,"Total Metered kWh Consumption for each new Class B customer for the period after becoming Class B",null,"Metered kWh Consumption for each new Class B customer for the period after becoming Class B in 2016","Metered kWh Consumption for each new Class B customer for the period prior to becoming Class B in 2015","Metered kWh Consumption for each new Class B customer for the period prior to becoming Class B in 2014","Metered kWh Consumption for each new Class B customer for the period prior to becoming Class B in 2013","Metered kWh Consumption for each new Class B customer for the period prior to becoming Class B in 2012","% of kWh","Customer specific GA allocation for the period after becoming Class B","Monthly Equal Payments"]
[null,"Customer 1",null,{"$f":"SUM(E33:J33)","v":5633530},5633530,null,null,null,null,null,{"$f":"IFERROR(+D33/$D$42,0)","v":1},{"$f":"+K33*$D$26","v":9074.6321539446435},{"$f":"+L33/12","v":756.21934616205363}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+K34*$D$26","v":0},{"$f":"+L34/12","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total",null,{"$f":"SUM(D33:D41)","v":5633530},{"$f":"SUM(E33:E41)","v":5633530},{"$f":"SUM(F33:F41)","v":0},{"$f":"SUM(G33:G41)","v":0},{"$f":"SUM(H33:H37)","v":0},0,0,{"$f":"SUM(K33:K41)","v":1},{"$f":"SUM(L33:L41)","v":9074.6321539446435}]

{"sheet":"7. CBR Calculation","index":7,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,8,6],[12,1,12,13],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,10,18,11],[18,8,18,9]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The purpose of this tab is to calculate the CBR rate riders for all current Class B customers of the distributor.\nIdentify and input the total billed consumption for former Class B customers prior to becoming Class A customers in  Column H.\nIdentify and input the total billed consumption for former Class A customers after becoming  Class B customers in  Column H."]
[]
[null,"Account 1580"]
[null,"Variance WMS – Sub-account CBR Class A",{"$f":"'3. Continuity Schedule'!CN24","v":2.2000000036496203E-4}]
[null,"Variance WMS – Sub-account CBR Class B",{"$f":"'3. Continuity Schedule'!CN25","v":-55880.028700500014}]
[]
[null,null,"Total Metered LESS WMP",null,"Total  Metered Class A \nConsumption/Demand in  2016  (partial \nand/or full year Class A customers)*",null,"Total Metered Consumption/Demand\nfor New Class A customer(s)\n in the period prior to becoming\n Class A (i.e. Jan 1 - Jun 30, 2016) ",null,"Total Metered Consumption for New Class B customer(s) in the period after becoming Class B (i.e. Jul 1 - Dec 31, 2016) ",null,"Metered Consumption for Current Class B Customers (metered consumption/demand LESS WMP, Class A and new Class A's former Class B, if applicable)",null,"% of total kWh","Total CBR $ allocated to Current Class B Customers","CBR Rate Rider",null,"Revenue Reconciliation","Variance"]
[null,null,"kWh","kW","kWh","kW","kWh","kW","kWh","kW","kWh","kW"]
[]
["R_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B17","v":"RESIDENTIAL"},{"$f":"'4. Billing Det. for Def-Var'!D17-'4. Billing Det. for Def-Var'!H17","v":1537580328.6899991},{"$f":"'4. Billing Det. for Def-Var'!E17-'4. Billing Det. for Def-Var'!I17","v":0},{"$f":"'6. GA Calculation'!E17","v":0},null,{"$f":"'6. GA Calculation'!G17","v":0},null,{"$f":"'6. GA Calculation'!H17","v":0},null,{"$f":"C22-E22-G22-I22","v":1537580328.6899991},{"$f":"D22-F22-H22-J22","v":0},{"$f":"IFERROR(K22/K$34,\"\")","v":0.44475651101036218},{"$f":"IFERROR(N$34*M22,\"\")","v":-23929.094863910163},{"$f":"ROUND(IFERROR(IF(P22=\"kwh\",N22/K22,N22/L22),0),5)","v":-2.0000000000000002E-5},"kwh",{"$f":"ROUND(O22,5)*K22","v":-30751.606573799985},{"$f":"N22-Q22","v":6822.5117098898227}]
["GSL_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B18","v":"GENERAL SERVICE LESS THAN 50 KW"},{"$f":"'4. Billing Det. for Def-Var'!D18-'4. Billing Det. for Def-Var'!H18","v":558828431.00972259},{"$f":"'4. Billing Det. for Def-Var'!E18-'4. Billing Det. for Def-Var'!I18","v":0},{"$f":"'6. GA Calculation'!E18","v":0},null,{"$f":"'6. GA Calculation'!G18","v":0},null,{"$f":"'6. GA Calculation'!H18","v":0},null,{"$f":"C23-E23-G23-I23","v":558828431.00972259},{"$f":"D23-F23-H23-J23","v":0},{"$f":"IFERROR(K23/K$34,\"\")","v":0.16164526730192663},{"$f":"IFERROR(N$34*M23,\"\")","v":-8696.9495438815466},{"$f":"ROUND(IFERROR(IF(P23=\"kwh\",N23/K23,N23/L23),0),5)","v":-2.0000000000000002E-5},"kwh",{"$f":"ROUND(O23,5)*K23","v":-11176.568620194454},{"$f":"N23-Q23","v":2479.6190763129071}]
["GSG_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B19","v":"GENERAL SERVICE 50 TO 4,999 KW"},{"$f":"'4. Billing Det. for Def-Var'!D19-'4. Billing Det. for Def-Var'!H19","v":1751908545.0163753},{"$f":"'4. Billing Det. for Def-Var'!E19-'4. Billing Det. for Def-Var'!I19","v":4824433.3829784254},{"$f":"'6. GA Calculation'!E19","v":294613747},674039.68999999983,{"$f":"'6. GA Calculation'!G19","v":127847550},337632.35,{"$f":"'6. GA Calculation'!H19","v":5633530},13722.77,1323813718.0163753,3799038.5729784253,0.3829229338243732,-20602.282332493465,-5.4200000000000003E-3,"kW",{"$f":"ROUND(O24,5)*L24","v":-20590.789065543067},-11.49326695039781]
["LU_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B20","v":"LARGE USE (1)"},{"$f":"'4. Billing Det. for Def-Var'!D20-'4. Billing Det. for Def-Var'!H20","v":185572728.49602383},{"$f":"'4. Billing Det. for Def-Var'!E20-'4. Billing Det. for Def-Var'!I20","v":338314.53215999994},{"$f":"'6. GA Calculation'!E20","v":184005518},339319.55,{"$f":"'6. GA Calculation'!G20","v":0},0,{"$f":"'6. GA Calculation'!H20","v":0},0,1567210.4960238338,-1005.0178400000441,4.5332725661509891E-4,-24.390223997611383,2.427E-2,"kW",{"$f":"ROUND(O25,5)*L25","v":-24.391782976801071},1.558979189688614E-3]
["LUDA_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B21","v":"LARGE USE (2)"},{"$f":"'4. Billing Det. for Def-Var'!D21-'4. Billing Det. for Def-Var'!H21","v":307375989.7355864},{"$f":"'4. Billing Det. for Def-Var'!E21-'4. Billing Det. for Def-Var'!I21","v":790236.97796000005},{"$f":"'6. GA Calculation'!E21","v":315018495},778897.54999999993,{"$f":"'6. GA Calculation'!G21","v":0},null,{"$f":"'6. GA Calculation'!H21","v":0},null,-7642505.2644135952,11339.427960000117,-2.2106513158079168E-3,118.93897837903265,1.0489999999999999E-2,"kW",{"$f":"ROUND(O26,5)*L26","v":118.95059930040122},-1.1620921368574955E-2]
["USL_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B22","v":"UNMETERED SCATTERED LOAD"},{"$f":"'4. Billing Det. for Def-Var'!D22-'4. Billing Det. for Def-Var'!H22","v":11347508.416576881},{"$f":"'4. Billing Det. for Def-Var'!E22-'4. Billing Det. for Def-Var'!I22","v":0},{"$f":"'6. GA Calculation'!E22","v":0},null,{"$f":"'6. GA Calculation'!G22","v":0},null,{"$f":"'6. GA Calculation'!H22","v":0},null,11347508.416576881,0,3.2823509496361309E-3,-176.59929715713284,-2.0000000000000002E-5,"kWh",{"$f":"ROUND(O27,5)*K27","v":-226.95016833153764},50.350871174404801]
["SEN_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B23","v":"SENTINEL LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!D23-'4. Billing Det. for Def-Var'!H23","v":439954.02282899455},{"$f":"'4. Billing Det. for Def-Var'!E23-'4. Billing Det. for Def-Var'!I23","v":946.91011767210034},{"$f":"'6. GA Calculation'!E23","v":0},null,{"$f":"'6. GA Calculation'!G23","v":0},null,{"$f":"'6. GA Calculation'!H23","v":0},null,439954.02282899455,946.91011767210034,{"$f":"IFERROR(K28/K$34,\"\")","v":1.2725996329902809E-4},-6.8469278330345107,-7.2300000000000003E-3,"kW",{"$f":"ROUND(O28,5)*L28","v":-6.8461601507692862},-7.6768226522450078E-4]
["SL_CBR19",{"$f":"'4. Billing Det. for Def-Var'!B24","v":"STREET LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!D24-'4. Billing Det. for Def-Var'!H24","v":31193672.300799686},{"$f":"'4. Billing Det. for Def-Var'!E24-'4. Billing Det. for Def-Var'!I24","v":87344.171000000002},{"$f":"'6. GA Calculation'!E24","v":0},null,{"$f":"'6. GA Calculation'!G24","v":0},null,{"$f":"'6. GA Calculation'!H24","v":0},null,31193672.300799686,87344.171000000002,9.0230010095956326E-3,-485.46168919546318,-5.5599999999999998E-3,"kW",{"$f":"ROUND(O29,5)*L29","v":-485.63359076},0.17190156453682448]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C22:C33)","v":4384247157.6879129},{"$f":"SUM(D22:D33)","v":6041275.974216097},793637760,1792256.7899999996,127847550,337632.35,{"$f":"SUM(I22:I33)","v":5633530},13722.77,3457128317.6879129,3897664.0642160978,0.99999999999999989,{"$f":"'7B. CBR Allocation_new Class B'!D28","v":-53802.685900089382},null,null,{"$f":"SUM(Q22:Q33)","v":-63143.835362456215},{"$f":"SUM(R22:R33)","v":9341.1494623668295}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from Sheet 7B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE: if rate rider is at 5 decimal places, then the balance dispostion is in full"]
[null,"*For new Class A customers (who became Class A in 2016), add their consumption only related to July to December period."]

{"sheet":"7A. CBR Allocation_Class A","index":8,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[30,1,30,3],[1,1,8,7],[11,1,11,6],[15,1,15,6],[22,1,22,3],[28,1,28,5]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tab allocates the CBR balance to former Class B customers who contributed to the current CBR balance but are now Class A customers. The tables below calculate specific amounts for each customer who made the change. Consistent with both decisions for 2016 rates and EDDVAR, distributors are generally expected to settle the amount through 12 equal adjustments to bills. A one-time settlement is acceptable if the affected customer has expressed a clear preference for this approach. (see Filing Requirements section 3.2.5.2)"]
[]
[null,"Year of Group 1 Account Balance Last Disposed",2016]
[]
[null,"Allocation of total Non-RPP consumption (kWh) between Class B and New Class A (Former Class B) customers"]
[null,null,null,"Total",2017,2016]
[null,"Total MeteredConsumption for Years Since Last Disposition (consumption LESS WMP and Class A)","A",{"$f":"SUM(E18:J18)","v":3590609397.6879129},{"$f":"'7. CBR Calculation'!C34-'7. CBR Calculation'!E34","v":3590609397.6879129}]
[null,"New Class A Customer(s)' Former Class B Consumption","B",{"$f":"SUM(E19:J19)","v":127847550},{"$f":"E69","v":127847550}]
[null,"Portion of Consumption of Former Class B Customers","C=B/A",{"$f":"IFERROR(+D19/D18,0)","v":3.5606086833706939E-2}]
[]
[]
[null,"Allocation of Total CBR Class B Balance $"]
[]
[null,"Total CBR-Class B Balance","D",{"$f":"'7. CBR Calculation'!C17","v":-55880.028700500014}]
[null,"New Class A Customer(s)' Former Class B Portion of CBR-Class B Balance","E=C*D",{"$f":"+D20*D25","v":-1989.6691541800394}]
[null,"CBR-Class B Balance to be disposed to Current Class B Customers (if no Class A to Class  B Transition Customers)","F=D-E",{"$f":"+D25-D26","v":-53890.359546319974},null,null,null,null,null,null,null,null,null,null,null,"s"]
[]
[null,"Allocation of CBR Class B Balances to Former Class B Customers"]
[]
[null,"# of Former Class B customer(s)"]
[null,"Customer",null,"Total Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A",2017,"Metered kWh Consumption for each new Class A customer for the period prior to becoming Class A in 2016",null,null,null,null,"% of kWh","Customer specific CBR-Class B allocation for the period prior to becoming Class A","Monthly Equal Payments"]
[null,"Customer 1",null,{"$f":"SUM(E33:J33)","v":1112523},{"$f":"'6A. GA Allocation_Class A'!E33","v":1112523},null,null,null,null,null,{"$f":"IFERROR(+D33/$D$69,0)","v":8.7019500960323452E-3},{"$f":"+K33*$D$26","v":-17.31400168728959},{"$f":"+L33/12","v":-1.4428334739407991}]
[null,"Customer 2",null,{"$f":"SUM(E34:J34)","v":11119481},{"$f":"'6A. GA Allocation_Class A'!E34","v":11119481},null,null,null,null,null,8.6974533340685833E-2,{"$f":"+K34*$D$26","v":-173.05054618716602},{"$f":"+L34/12","v":-14.420878848930501}]
[null,"Customer 3",null,{"$f":"SUM(E35:J35)","v":1259299},{"$f":"'6A. GA Allocation_Class A'!E35","v":1259299},null,null,null,null,null,9.8500049472985598E-3,-19.598251012160731,-1.6331875843467276]
[null,"Customer 4",null,2132444,{"$f":"'6A. GA Allocation_Class A'!E36","v":2132444},null,null,null,null,null,1.6679584395633707E-2,-33.186854576535104,-2.7655712147112586]
[null,"Customer 5",null,1331127,{"$f":"'6A. GA Allocation_Class A'!E37","v":1331127},null,null,null,null,null,1.0411830340119933E-2,-20.716097666292498,-1.7263414721910415]
[null,"Customer 6",null,2762887,{"$f":"'6A. GA Allocation_Class A'!E38","v":2762887},null,null,null,null,null,2.1610793480203571E-2,-42.998329184916152,-3.5831940987430126]
[null,"Customer 7",null,6256539,{"$f":"'6A. GA Allocation_Class A'!E39","v":6256539},null,null,null,null,null,4.8937496260194273E-2,-97.369426791709586,-8.1141188993091315]
[null,"Customer 8",null,999971,{"$f":"'6A. GA Allocation_Class A'!E40","v":999971},null,null,null,null,null,7.8215890722974357E-3,-15.562374513821878,-1.2968645428184897]
[null,"Customer 9",null,7013680,{"$f":"'6A. GA Allocation_Class A'!E41","v":7013680},null,null,null,null,null,5.4859713776290592E-2,-109.15268030783116,-9.0960566923192641]
[null,"Customer 10",null,3468287,{"$f":"'6A. GA Allocation_Class A'!E42","v":3468287},null,null,null,null,null,2.7128302419561424E-2,-53.976346529469097,-4.4980288774557584]
[null,"Customer 11",null,5796244,{"$f":"'6A. GA Allocation_Class A'!E43","v":5796244},null,null,null,null,null,4.5337153508221317E-2,-90.205935873633308,-7.5171613228027754]
[null,"Customer 12",null,7763800,{"$f":"'6A. GA Allocation_Class A'!E44","v":7763800},null,null,null,null,null,{"$f":"IFERROR(+D44/$D$69,0)","v":6.0727014322918195E-2},{"$f":"+K44*$D$26","v":-120.82666722375978},-10.068888935313316]
[null,"Customer 13",null,5278662,{"$f":"'6A. GA Allocation_Class A'!E45","v":5278662},null,null,null,null,null,4.1288722388500995E-2,-82.150897351903225,-6.8459081126586021]
[null,"Customer 14",null,3940838,{"$f":"'6A. GA Allocation_Class A'!E46","v":3940838},null,null,null,null,null,3.0824509347265553E-2,-61.330575440988575,-5.1108812867490476]
[null,"Customer 15",null,6298192,{"$f":"'6A. GA Allocation_Class A'!E47","v":6298192},null,null,null,null,null,4.9263298358083511E-2,-98.01766517624695,-8.1681387646872459]
[null,"Customer 16",null,4930067,{"$f":"'6A. GA Allocation_Class A'!E48","v":4930067},null,null,null,null,null,3.8562076473111918E-2,-76.725774079682594,-6.3938145066402159]
[null,"Customer 17",null,3018648,{"$f":"'6A. GA Allocation_Class A'!E49","v":3018648},null,null,null,null,null,2.3611308937871708E-2,-46.978693083498804,-3.914891090291567]
[null,"Customer 18",null,3108153,{"$f":"'6A. GA Allocation_Class A'!E50","v":3108153},null,null,null,null,null,2.4311400570445035E-2,-48.371643809929502,-4.0309703174941252]
[null,"Customer 19",null,1506099,{"$f":"'6A. GA Allocation_Class A'!E51","v":1506099},null,null,null,null,null,1.1780429112642363E-2,-23.43915642842904,-1.9532630357024201]
[null,"Customer 20",null,2076084,{"$f":"'6A. GA Allocation_Class A'!E52","v":2076084},null,null,null,null,null,1.6238746851230234E-2,-32.30973371243104,-2.6924778093692532]
[null,"Customer 21",null,5424020,{"$f":"'6A. GA Allocation_Class A'!E53","v":5424020},null,null,null,null,null,4.2425685904813978E-2,-84.413078589739243,-7.0344232158116036]
[null,"Customer 22",null,2583905,{"$f":"'6A. GA Allocation_Class A'!E54","v":2583905},null,null,null,null,null,2.0210829225902255E-2,-40.212863491178162,-3.35107195759818]
[null,"Customer 23",null,2529573,{"$f":"'6A. GA Allocation_Class A'!E55","v":2529573},null,null,null,null,null,1.9785854324154042E-2,-39.367304037869047,-3.2806086698224206,"These two accounts (Bartek) are now combined - adjustment to be made to account 219286"]
[null,"Customer 24",null,3390659,{"$f":"'6A. GA Allocation_Class A'!E56","v":3390659},null,null,null,null,null,2.6521110494491292E-2,-52.768235485489853,-4.3973529571241547,"Account 219454 (Bartek) now combined with above account number"]
[null,"Customer 25",null,1161128,{"$f":"'6A. GA Allocation_Class A'!E57","v":1161128},null,null,null,null,null,9.0821294580928618E-3,-18.070432837037245,-1.505869403086437,"This customer account shut down and left premise/ premise now occupied by Class B customer.  Should this credit be removed and allocated to the remainder of the Class A customers?"]
[null,"Customer 26",null,2421761,{"$f":"'6A. GA Allocation_Class A'!E58","v":2421761},null,null,null,null,null,1.8942568707808635E-2,-37.68944465886289,-3.1407870549052408]
[null,"Customer 27",null,1568280,{"$f":"'6A. GA Allocation_Class A'!E59","v":1568280},null,null,null,null,null,1.2266797447428597E-2,-24.406868501723125,-2.0339057084769272]
[null,"Customer 28",null,3124881,{"$f":"'6A. GA Allocation_Class A'!E60","v":3124881},null,null,null,null,null,2.4442243906903183E-2,-48.631978760510279,-4.0526648967091896]
[null,"Customer 29",null,2706410,{"$f":"'6A. GA Allocation_Class A'!E61","v":2706410},null,null,null,null,null,2.116904078333922E-2,-42.119387470189302,-3.5099489558491084]
[null,"Customer 30",null,3613039,{"$f":"'6A. GA Allocation_Class A'!E62","v":3613039},null,null,null,null,null,2.8260525915436003E-2,-56.229096694848636,-4.685758057904053]
[null,"Customer 31",null,3605652,{"$f":"'6A. GA Allocation_Class A'!E63","v":3605652},null,null,null,null,null,2.8202746161346073E-2,-56.114134100399795,-4.6761778416999826]
[null,"Customer 32",null,1802628,{"$f":"'6A. GA Allocation_Class A'!E64","v":1802628},null,null,null,null,null,1.4099824361123853E-2,-28.053985610684411,-2.3378321342237007]
[null,"Customer 33",null,736499,{"$f":"'6A. GA Allocation_Class A'!E65","v":736499},null,null,null,null,null,5.7607595921861619E-3,-11.462005665219589,-0.95516713876829906]
[null,"Customer 34",null,3439510,{"$f":"'6A. GA Allocation_Class A'!E66","v":3439510},null,null,null,null,null,2.6903214023264427E-2,-53.528495090393108,-4.4607079241994256]
[null,"Customer 35",null,792832,{"$f":"'6A. GA Allocation_Class A'!E67","v":792832},null,null,null,null,null,6.2013859475601998E-3,-12.338706333026085,-1.0282255277521737]
[null,"Customer 36",null,7773748,{"$f":"'6A. GA Allocation_Class A'!E68","v":7773748},null,null,null,null,null,6.0804825747540724E-2,-120.98148621517403,-10.08179051793117]
[null,"Total",null,{"$f":"SUM(D33:D68)","v":127847550},{"$f":"SUM(E33:E68)","v":127847550},{"$f":"SUM(F33:F68)","v":0},{"$f":"SUM(G33:G43)","v":0},{"$f":"SUM(H33:H39)","v":0},0,0,{"$f":"SUM(K33:K68)","v":1},{"$f":"SUM(L33:L68)","v":-1989.6691541800392}]

{"sheet":"7B. CBR Allocation_new Class B","index":9,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,1,31,3],[1,1,8,7],[11,1,11,6],[15,1,15,6],[22,1,22,3],[29,1,29,5]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tab allocates the CBR-Class B balance to former Class A customers who contributed to the current CBR-Class B balance once switched to Class B customers. The tables below calculate specific amounts for each customer who made the transition. Consistent with both decisions for 2016 rates and EDDVAR, distributors are generally expected to settle the amount through 12 equal adjustments to bills. A one-time settlement is acceptable if the affected customer has expressed a clear preference for this approach. (see Filing Requirements section 3.2.5.2)"]
[]
[null,"Year of Group 1 Account Balance Last Disposed",2016]
[]
[null,"Allocation of total Non-RPP consumption (kWh) between Class B and New Class B (Former Class A) customers"]
[null,null,null,"Total",2017,2016,2015,2014,2013,2012]
[null,"Total Class B Consumption for Years Since Last Disposition (Non-RPP consumption LESS WMP and Class A)","A",{"$f":"SUM(E18:J18)","v":3590609397.6879129},{"$f":"'7. CBR Calculation'!C34-'7. CBR Calculation'!E34","v":3590609397.6879129}]
[null,"New Class B Customer(s)'  Consumption","B",{"$f":"SUM(E19:J19)","v":5633530},{"$f":"E42","v":5633530},0,0,0,0,0]
[null,"Portion of Consumption of New Class B Customers","C=B/A",{"$f":"IFERROR(+D19/D18,0)","v":1.5689620830457295E-3}]
[]
[]
[null,"Allocation of Total CBR-Class B Balance $"]
[]
[null,"Total CBR-Class B Balance adjusted for Class A","D",{"$f":"'7. CBR Calculation'!C17","v":-55880.028700500014}]
[null,"New Class B Customer(s)' Former Class A Portion of CBR-Class B Balance attributable to Class B","E=C*D",{"$f":"+D20*D25","v":-87.673646230591643}]
[null,"New Class A Customer(s)' Former Class B Portion of CBR-Class B Balance","F=Sheet 6A",{"$f":"'7A. CBR Allocation_Class A'!D26","v":-1989.6691541800394}]
[null,"CBR-Class B Balance to be disposed to Current Class B Customers","G=D-E-F",{"$f":"+D25-D26-D27","v":-53802.685900089382},null,"Input into Sheet 7. CBR Calculation",null,null,null,null,null,null,null,null,null,"s"]
[]
[null,"Allocation of CBR-Class B Balances to Former Class A Customers"]
[]
[null,"# of Former Class B customer(s)",null,null,2017,2]
[null,"Customer",null,"Total Metered kWh Consumption for each new Class B customer for the period after becoming Class B",null,"Metered kWh Consumption for each new Class B customer for the period after becoming Class B in 2016",null,null,null,null,"% of kWh","Customer specific CBR-Class B allocation for the period after becoming Class B","Monthly Equal Payments"]
[null,"Customer 1",null,{"$f":"SUM(E34:J34)","v":5633530},{"$f":"'6B. GA Allocation_new Class B'!E33","v":5633530},null,null,null,null,null,{"$f":"IFERROR(+D34/$D$42,0)","v":1},{"$f":"+K34*$D$26","v":-87.673646230591643},{"$f":"+L34/12","v":-7.3061371858826369}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+K35*$D$26","v":0},{"$f":"+L35/12","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Total",null,{"$f":"SUM(D34:D41)","v":5633530},{"$f":"SUM(E34:E41)","v":5633530},{"$f":"SUM(F34:F41)","v":0},{"$f":"SUM(G34:G41)","v":0},{"$f":"SUM(H34:H37)","v":0},0,0,{"$f":"SUM(K34:K41)","v":1},{"$f":"SUM(L34:L41)","v":-87.673646230591643}]

{"sheet":"8. Calculation of Def-Var RR","index":10,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,8,7],[14,10,15,10],[14,11,15,11],[15,12,15,13],[10,1,10,10],[11,1,11,2],[12,1,12,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9]]}
["Back to Index"]
[null,{"$f":"+'1. Information Sheet'!B2","v":"INCENTIVE REGULATION MODEL FOR 2019 FILERS"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input required at cell D13 only.  This workshseet calculates rate riders related to the Deferral/Variance Account Disposition (if applicable) and rate riders for Account 1568.  Rate Riders will not be generated for the microFIT class."]
[null,"Default Rate Rider Recovery Period (in months)",null,12]
[null,"Proposed Rate Rider Recovery Period (in months)",null,12,{"$f":"IF(D13>0, \"Rate Rider Recovery to be used below\", \"If no rate rider recovery period is proposed then the default recovery period of 12 months will be used\")","v":"Rate Rider Recovery to be used below"}]
[]
[null,null,null,"Total Metered kWh","Metered kW \nor kVA","Total Metered kWh less WMP consumption ","Total Metered kW less WMP consumption ","Allocation of Group 1 Account Balances to All Classes 2","Allocation of Group 1 Account Balances to Non-WMP Classes Only \n(if Applicable) 2","Deferral/Variance Account Rate Rider 2","Deferral/Variance Account Rate Rider for Non-WMP \n(if applicable) 2","Account 1568 Rate Rider"]
[null,"Rate Class","Unit",null,null,null,null,null,null,null,null,null,"Revenue Reconciliation:",null,"Revenue\n Reconcilation 1"]
[null,{"$f":"'4. Billing Det. for Def-Var'!B17","v":"RESIDENTIAL"},{"$f":"'4. Billing Det. for Def-Var'!C17","v":"kWh"},{"$f":"'4. Billing Det. for Def-Var'!D17","v":1537580328.6899991},{"$f":"'4. Billing Det. for Def-Var'!E17","v":0},{"$f":"'4. Billing Det. for Def-Var'!J17","v":1537580328.6899991},{"$f":"'4. Billing Det. for Def-Var'!K17","v":0},{"$f":"SUM('5. Allocating Def-Var Balances'!G16:V16)-I17","v":-3295075.7632654393},null,{"$f":"IF(ISERROR(H17/D17),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H17/D17/(D$12/12), H17/D17/(D$13/12)))","v":-2.143026742591593E-3},{"$f":"IF(ISERROR(I17/F17),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), I17/F17/(D$12/12), I17/F17/(D$13/12)))","v":0},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U17/D17), 0, IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), ('4. Billing Det. for Def-Var'!U17/D17)/(D$12/12), ('4. Billing Det. for Def-Var'!U17/D17)/(D$13/12)))","v":2.0431326279885526E-4},{"$f":"J17*D17","v":-3295075.7632654398},{"$f":"K17*G17","v":0}]
[null,{"$f":"'4. Billing Det. for Def-Var'!B18","v":"GENERAL SERVICE LESS THAN 50 KW"},{"$f":"'4. Billing Det. for Def-Var'!C18","v":"kWh"},{"$f":"'4. Billing Det. for Def-Var'!D18","v":558828431.00972259},{"$f":"'4. Billing Det. for Def-Var'!E18","v":0},{"$f":"'4. Billing Det. for Def-Var'!J18","v":558828431.00972259},{"$f":"'4. Billing Det. for Def-Var'!K18","v":0},{"$f":"SUM('5. Allocating Def-Var Balances'!G17:V17)-I18","v":-1190194.0052505713},null,{"$f":"IF(ISERROR(H18/D18),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H18/D18/(D$12/12), H18/D18/(D$13/12)))","v":-2.1298021704086565E-3},{"$f":"IF(ISERROR(I18/F18),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), I18/F18/(D$12/12), I18/F18/(D$13/12)))","v":0},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U18/D18), 0, IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), ('4. Billing Det. for Def-Var'!U18/D18)/(D$12/12), ('4. Billing Det. for Def-Var'!U18/D18)/(D$13/12)))","v":4.9636847235979219E-4},{"$f":"J18*D18","v":-1190194.0052505713},0]
[null,{"$f":"'4. Billing Det. for Def-Var'!B19","v":"GENERAL SERVICE 50 TO 4,999 KW"},{"$f":"'4. Billing Det. for Def-Var'!C19","v":"kW"},{"$f":"'4. Billing Det. for Def-Var'!D19","v":1751908545.0163753},{"$f":"'4. Billing Det. for Def-Var'!E19","v":4824433.3829784254},{"$f":"'4. Billing Det. for Def-Var'!J19","v":1751908545.0163753},{"$f":"'4. Billing Det. for Def-Var'!K19","v":4824433.3829784254},{"$f":"SUM('5. Allocating Def-Var Balances'!G18:V18)-I19","v":289101.0725430944},{"$f":"'5. Allocating Def-Var Balances'!I18+'5. Allocating Def-Var Balances'!N18","v":-4013381.0012841607},{"$f":"IF(ISERROR(H19/E19),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H19/E19/(D$12/12), H19/E19/(D$13/12)))","v":5.9924357866169599E-2},{"$f":"IF(ISERROR(I19/G19),0,IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), I19/G19/(D12/12), I19/G19/(D$13/12)))","v":-0.83188649996581543},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U19/E19), 0, IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), ('4. Billing Det. for Def-Var'!U19/E19)/(D12/12), ('4. Billing Det. for Def-Var'!U19/E19)/(D13/12)))","v":-1.363236501921797E-2},{"$f":"J19*E19","v":289101.0725430944},-4013381.0012841607]
[null,{"$f":"'4. Billing Det. for Def-Var'!B20","v":"LARGE USE (1)"},{"$f":"'4. Billing Det. for Def-Var'!C20","v":"kW"},{"$f":"'4. Billing Det. for Def-Var'!D20","v":220526376.81002384},{"$f":"'4. Billing Det. for Def-Var'!E20","v":456125.73797999998},{"$f":"'4. Billing Det. for Def-Var'!J20","v":185572728.49602383},{"$f":"'4. Billing Det. for Def-Var'!K20","v":338314.53215999994},{"$f":"SUM('5. Allocating Def-Var Balances'!G19:V19)-I20","v":36391.405377125251},{"$f":"'5. Allocating Def-Var Balances'!I19+'5. Allocating Def-Var Balances'!N19","v":-425121.54245782521},{"$f":"IF(ISERROR(H20/E20),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H20/E20/(D$12/12), H20/E20/(D$13/12)))","v":7.9783713890578409E-2},{"$f":"IF(ISERROR(I20/G20),0,IF(OR(ISBLANK(D14), OR(D14=0, D14=\"\")), I20/G20/(D13/12), I20/G20/(D$13/12)))","v":-1.2565867027455131},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U20/E20), 0, IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), ('4. Billing Det. for Def-Var'!U20/E20)/(D12/12), ('4. Billing Det. for Def-Var'!U20/E20)/(D13/12)))","v":1.7542954865954138E-2},{"$f":"J20*E20","v":36391.405377125251},-425121.54245782515]
[null,{"$f":"'4. Billing Det. for Def-Var'!B21","v":"LARGE USE (2)"},{"$f":"'4. Billing Det. for Def-Var'!C21","v":"kW"},{"$f":"'4. Billing Det. for Def-Var'!D21","v":1050812632.4245863},{"$f":"'4. Billing Det. for Def-Var'!E21","v":1982813.5380800001},{"$f":"'4. Billing Det. for Def-Var'!J21","v":307375989.7355864},{"$f":"'4. Billing Det. for Def-Var'!K21","v":790236.97796000005},{"$f":"SUM('5. Allocating Def-Var Balances'!G20:V20)-I21","v":173405.77663328021},{"$f":"'5. Allocating Def-Var Balances'!I20+'5. Allocating Def-Var Balances'!N20","v":-704156.02513325657},{"$f":"IF(ISERROR(H21/E21),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H21/E21/(D$12/12), H21/E21/(D$13/12)))","v":8.7454404210490042E-2},{"$f":"IF(ISERROR(I21/G21),0,IF(OR(ISBLANK(D15), OR(D15=0, D15=\"\")), I21/G21/(D14/12), I21/G21/(D$13/12)))","v":-0.89106944470130744},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U21/E21), 0, IF(OR(ISBLANK(D14), OR(D14=0, D14=\"\")), ('4. Billing Det. for Def-Var'!U21/E21)/(D13/12), ('4. Billing Det. for Def-Var'!U21/E21)/(D14/12)))","v":5.9301653341171075E-3},{"$f":"J21*E21","v":173405.77663328021},-704156.02513325657]
[null,{"$f":"'4. Billing Det. for Def-Var'!B22","v":"UNMETERED SCATTERED LOAD"},{"$f":"'4. Billing Det. for Def-Var'!C22","v":"kWh"},{"$f":"'4. Billing Det. for Def-Var'!D22","v":11347508.416576881},{"$f":"'4. Billing Det. for Def-Var'!E22","v":0},{"$f":"'4. Billing Det. for Def-Var'!J22","v":11347508.416576881},{"$f":"'4. Billing Det. for Def-Var'!K22","v":0},{"$f":"SUM('5. Allocating Def-Var Balances'!G21:V21)-I22","v":-24123.004586695341},null,{"$f":"IF(ISERROR(H22/D22),0,IF(OR(ISBLANK(D18), OR(D18=0, D18=\"\")), H22/D22/(D17/12), H22/D22/(D$13/12)))","v":-2.1258415240702107E-3},{"$f":"IF(ISERROR(I22/F22),0,IF(OR(ISBLANK(D18), OR(D18=0, D18=\"\")), I22/F22/(D17/12), I22/F22/(D18/12)))","v":0},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U22/E22), 0, IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), ('4. Billing Det. for Def-Var'!U22/E22)/(D12/12), ('4. Billing Det. for Def-Var'!U22/E22)/(D13/12)))","v":0},{"$f":"J22*D22","v":-24123.004586695341},0]
[null,{"$f":"'4. Billing Det. for Def-Var'!B23","v":"SENTINEL LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!C23","v":"kW"},{"$f":"'4. Billing Det. for Def-Var'!D23","v":439954.02282899455},{"$f":"'4. Billing Det. for Def-Var'!E23","v":946.91011767210034},{"$f":"'4. Billing Det. for Def-Var'!J23","v":439954.02282899455},{"$f":"'4. Billing Det. for Def-Var'!K23","v":946.91011767210034},{"$f":"SUM('5. Allocating Def-Var Balances'!G22:V22)-I23","v":-935.27253137185608},null,{"$f":"IF(ISERROR(H23/E23),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H23/E23/(D$12/12), H23/E23/(D$13/12)))","v":-0.98770993562846887},{"$f":"IF(ISERROR(I23/G23),0,IF(OR(ISBLANK(D17), OR(D17=0, D17=\"\")), I23/G23/(D16/12), I23/G23/(D17/12)))","v":0},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U23/E23), 0, IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), ('4. Billing Det. for Def-Var'!U23/E23)/(D12/12), ('4. Billing Det. for Def-Var'!U23/E23)/(D13/12)))","v":0},{"$f":"J23*E23","v":-935.27253137185608},0]
[null,{"$f":"'4. Billing Det. for Def-Var'!B24","v":"STREET LIGHTING"},{"$f":"'4. Billing Det. for Def-Var'!C24","v":"kW"},{"$f":"'4. Billing Det. for Def-Var'!D24","v":31193672.300799686},{"$f":"'4. Billing Det. for Def-Var'!E24","v":87344.171000000002},{"$f":"'4. Billing Det. for Def-Var'!J24","v":31193672.300799686},{"$f":"'4. Billing Det. for Def-Var'!K24","v":87344.171000000002},{"$f":"SUM('5. Allocating Def-Var Balances'!G23:V23)-I24","v":-66312.803637538877},null,{"$f":"IF(ISERROR(H24/E24),0,IF(OR(ISBLANK(D$13), OR(D$13=0, D$13=\"\")), H24/E24/(D$12/12), H24/E24/(D$13/12)))","v":-0.75921269706182082},{"$f":"IF(ISERROR(I24/G24),0,IF(OR(ISBLANK(D18), OR(D18=0, D18=\"\")), I24/G24/(D17/12), I24/G24/(D18/12)))","v":0},{"$f":"IF(ISERROR('4. Billing Det. for Def-Var'!U24/E24), 0, IF(OR(ISBLANK(D13), OR(D13=0, D13=\"\")), ('4. Billing Det. for Def-Var'!U24/E24)/(D12/12), ('4. Billing Det. for Def-Var'!U24/E24)/(D13/12)))","v":1.1938811874970923},{"$f":"J24*E24","v":-66312.803637538877},0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M26)","v":-4077742.5947181182},{"$f":"SUM(N17:N26)","v":-5142658.568875243},{"$f":"SUM(M27:N27)","v":-9220401.1635933612}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O27-('3. Continuity Schedule'!CN41-'3. Continuity Schedule'!CN25)","v":-2.2000260651111603E-4}]
[]
[null,"1 When calculating the revenue reconciliation for distributors with Class A customers, the balances of sub-account 1580-CBR Class A and B will not be taken into consideration since the rate riders, if any, are calculated outside of the model."]
[null,"2 Only for rate classes with WMP customers are the Deferral/Variance Account Rate Riders for Non-WMP (column H and J) calculated separately. For all rate classes without WMP customers, balances in account 1580 and 1588 are included in column H and disposed through a combined Deferral/Variance Account and Rate Rider."]