{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["App.2-V_Revenue_Reconciliation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":6,"defined_names":81,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"App.2-V_Revenue_Reconciliation","index":0,"n_rows":116,"n_cols":16,"rows_kept":116,"cut":false,"hidden":false,"merged":[[95,13,96,13],[95,14,96,14],[95,15,96,15],[96,8,96,9],[95,1,96,1],[95,2,95,4],[95,5,95,6],[95,7,95,9],[95,10,96,10],[95,12,96,12],[74,13,75,13],[74,14,75,14],[74,15,75,15],[75,8,75,9],[92,0,92,15],[93,0,93,15],[74,1,75,1],[74,2,74,4],[74,5,74,6],[74,7,74,9],[74,10,75,10],[74,12,75,12],[53,13,54,13],[53,14,54,14],[53,15,54,15],[54,8,54,9],[71,0,71,15],[72,0,72,15],[53,1,54,1],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,10,54,10],[53,12,54,12],[32,13,33,13],[32,14,33,14],[32,15,33,15],[33,8,33,9],[50,0,50,15],[51,0,51,15],[11,15,12,15],[12,8,12,9],[29,0,29,15],[30,0,30,15],[32,1,33,1],[32,2,32,4],[32,5,32,6],[32,7,32,9],[32,10,33,10],[32,12,33,12],[8,0,8,15],[9,0,9,15],[11,1,12,1],[11,2,11,4],[11,5,11,6],[11,7,11,9],[11,10,12,10],[11,12,12,12],[11,13,12,13],[11,14,12,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2014-0101"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-V"]
["Revenue Reconciliation 2015"]
[]
["Rate Class","Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[]
["Residential","Customers",50202.5,51751.5,{"$f":"IF(SUM(C16:D16)=0,0,AVERAGE(C16:D16))","v":50977},488310441.84458584,null,10.5,1.32E-2,null,{"$f":"H16*E16*12+I16*F16+J16*G16","v":12868799.832348533},null,12845602.595781012,null,{"$f":"SUM(M16:N16)","v":12845602.595781012},{"$f":"O16-K16","v":-23197.236567521468}]
["GS Less Than 50 KW","Customers",3952.5,4051.5,4002,134064266.11914393,null,15.21,1.47E-2,null,{"$f":"H17*E17*12+I17*F17+J17*G17","v":2701189.751951416},null,2706175.1326604313,null,2706175.1326604313,4985.3807090152986]
["GS 50 To 999 KW","Customers",502.5,511.5,507,null,851954.05092458322,48.76,null,4.1839000000000004,3861146.393663364,null,3794693.9064651723,66477.515050139424,3861171.4215153116,25.027851947583258]
["GS Intermediate 1,000 To 4,999 KW","Customers",11,13,12,null,195333.21024632914,1024.6300000000001,null,2.2648999999999999,589956.90788691095,null,480277.74348804652,109679.6171671044,589957.36065515096,0.45276824000757188]
["Large Use","Customers",1,1,1,null,96450.280123117438,7812.41,null,1.9725999999999999,284006.74257086148,null,226135.53988316999,57870.53202541967,284006.07190858969,-0.67066227179020643]
["Street Lighting","Connections",12464.5,12955.5,12710,null,23911.673714127413,1.65,null,25.491599999999998,861204.82165105036,null,861202.34860017814,null,861202.34860017814,-2.4730508722132072]
["Sentinel Lighting","Connections",24,22,23,null,100.15889621450508,4.91,null,7.0133000000000001,2057.6043868211887,null,2070.6345799380219,null,2070.6345799380219,13.030193116833289]
["Unmetered Scattered Load","Connections",295.5,296.5,296,2686537.3140891874,null,4.07,1.66E-2,null,59053.159413880509,null,59028.186950306343,null,59028.186950306343,-24.972463574165886]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K16:K25)","v":21227415.213872839},null,{"$f":"SUM(M16:M25)","v":20975186.088408258},{"$f":"SUM(N16:N25)","v":234027.66424266351},{"$f":"M27+N27","v":21209213.75265092},{"$f":"O27-K27","v":-18201.461221918464}]
[]
[]
["Appendix 2-V"]
["Revenue Reconciliation 2016"]
[]
["Rate Class","Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[]
["Residential","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D16","v":51751.5},51732.5,{"$f":"IF(SUM(C37:D37)=0,0,AVERAGE(C37:D37))","v":51742},491380160.90018409,null,11.213082431285882,1.4168759967643618E-2,null,{"$f":"H37*E37*12+I37*F37+J37*G37","v":13924495.286571939},null,13924495.105313618,null,{"$f":"SUM(M37:N37)","v":13924495.105313618},{"$f":"O37-K37","v":-0.18125832080841064}]
["GS Less Than 50 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D17","v":4051.5},4072.5,4062,134854491.64774501,null,16.022360102984027,1.5660082537613865E-2,null,2892826.3906314997,null,2892921.1914680093,null,2892921.1914680093,94.800836509559304]
["GS 50 To 999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D18","v":511.5},518.5,515,null,860398.47773257422,52.204638095776467,null,4.4739582050111091,4172011.4924626173,null,4104624.4810807095,67136.429119048174,4171760.9101997577,-250.58226285967976]
["GS Intermediate 1,000 To 4,999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D19","v":13},11,12,null,194669.69353718983,1097.0147319949854,null,2.3852362630529709,622303.33374959161,null,512996.28128129395,109307.05246829765,622303.33374959161,0]
["Large Use","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D20","v":1},1,1,null,96497.827923500081,8347.4247155914982,null,2.0665990578787765,299591.41686115152,null,241692.35597608244,57899.060885069113,299591.41686115158,0]
["Street Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D21","v":12955.5},12964.5,12960,null,14599.316515348542,1.8291260710940083,null,28.259000093272729,697027.77334549278,null,697028.28377216973,null,697028.28377216973,0.51042667694855481]
["Sentinel Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D22","v":22},22,22,null,96.106500369299738,5.2568657311374638,null,7.5087528375124988,2109.452510371666,null,2138.9452176317882,null,2138.9452176317882,29.492707260122188]
["Unmetered Scattered Load","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D23","v":296.5},295.5,296,2667193.4637021297,null,4.3575241396597724,1.7772702879202015E-2,null,62881.162695799139,null,62888.528108738392,null,62888.528108738392,7.3654129392525647]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K37:K46)","v":22673246.308828462},null,{"$f":"SUM(M37:M46)","v":22438785.172218252},{"$f":"SUM(N37:N46)","v":234342.54247241493},{"$f":"M48+N48","v":22673127.714690667},{"$f":"O48-K48","v":-118.59413779526949}]
[]
[]
["Appendix 2-V"]
["Revenue Reconciliation 2017"]
[]
["Rate Class","Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[]
["Residential","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D37","v":51732.5},53303.5,{"$f":"IF(SUM(C58:D58)=0,0,AVERAGE(C58:D58))","v":52518},492297000.53160763,null,14.221728204894363,1.0923630316466364E-2,null,{"$f":"H58*E58*12+I58*F58+J58*G58","v":14340431.102088233},null,14340454.505900068,null,{"$f":"SUM(M58:N58)","v":14340454.505900068},{"$f":"O58-K58","v":23.40381183475256}]
["GS Less Than 50 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D38","v":4072.5},4173.5,4123,135063742.04659477,null,16.240164758428584,1.6085881239226926E-2,null,2976117.7058751164,null,2976190.8414891833,null,2976190.8414891833,73.135614066850394]
["GS 50 To 999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D39","v":518.5},525.5,522,null,865544.379866131,53.33,null,4.5690788439460972,4288799.6345427837,null,4221453.6614559507,67537.961086833093,4288991.6225427836,191.98799999989569]
["GS Intermediate 1,000 To 4,999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D40","v":11},13,12,null,193285.76673996553,1120.7384686911003,null,2.4246468655430098,630036.06797165319,null,521506.09053895983,108529.9774326934,630036.06797165319,0]
["Large Use","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D41","v":1},1,1,null,96705.677469853224,8527.9757780890468,null,2.0983226667431221,305255.42437481123,null,247231.65297761772,58023.771397193537,305255.42437481123,0]
["Street Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D42","v":12964.5},13465.5,13215,null,13528.419217862043,1.921138029484547,null,29.666360423608644,705993.02919442859,null,705995.88622365647,null,705995.88622365647,2.8570292278891429]
["Sentinel Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D43","v":22},22,22,null,92.371157468960305,5.3737744827441736,null,7.6712163186367803,2127.2755939917179,null,2110.4052919270061,null,2110.4052919270061,-16.870302064711723]
["Unmetered Scattered Load","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D44","v":295.5},296.5,296,2652384.9112346303,null,4.4526486319928358,1.8178244415016625E-2,null,64031.50913996384,null,64056.184223041935,null,64056.184223041935,24.675083078094758]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K58:K67)","v":23312791.748780984},null,{"$f":"SUM(M58:M67)","v":23078999.228100404},{"$f":"SUM(N58:N67)","v":234091.70991672005},{"$f":"M69+N69","v":23313090.938017122},{"$f":"O69-K69","v":299.18923613801599}]
[]
[]
["Appendix 2-V"]
["Revenue Reconciliation 2018"]
[]
["Rate Class","Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[]
["Residential","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D58","v":53303.5},54322.5,{"$f":"IF(SUM(C79:D79)=0,0,AVERAGE(C79:D79))","v":53813},480011939.38473219,null,17.354871589918435,7.7824315440538014E-3,null,{"$f":"H79*E79*12+I79*F79+J79*G79","v":14942672.517009551},null,14942640.234360727,null,{"$f":"SUM(M79:N79)","v":14942640.234360727},{"$f":"O79-K79","v":-32.282648824155331}]
["GS Less Than 50 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D59","v":4173.5},4268.5,4221,129585178.21250525,null,16.071498672864532,1.6985257581145507E-2,null,3015091.1814159807,null,3015120.0419699261,null,3015120.0419699261,28.860553945414722]
["GS 50 To 999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D60","v":525.5},526.5,526,null,834069.22595941229,55.276632186119762,null,4.7330314168784771,4296581.9526761994,null,4231367.316953782,65081.971805171022,4296449.2887589531,-132.66391724627465]
["GS Intermediate 1,000 To 4,999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D61","v":13},13,13,null,167714.00346680533,1161.6488422327377,null,2.492606192208787,599262.18294979201,null,507878.71038404747,94171.429787103072,602050.14017115056,2787.9572213585488]
["Large Use","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D62","v":1},1,1,null,90488.372107827323,8839.2652118992282,null,2.152990261746091,300891.76649219956,null,246598.40177299242,54293.364719207166,300891.76649219962,0]
["Street Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D63","v":13465.5},13478.5,13472,null,13345.422407816242,1.9900831388964935,null,30.749272099874435,732086.82547226571,null,732092.04998941428,null,732092.04998941428,5.2245171485701576]
["Sentinel Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D64","v":22},24,23,null,96.768186330400098,5.5660137791011293,null,7.9512113411993655,2305.6441036494825,null,2285.3900973216196,null,2285.3900973216196,-20.254006327862953]
["Unmetered Scattered Load","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D65","v":296.5},245.5,271,2612658.5895418967,null,4.4887048612639573,1.8358298533708774E-2,null,62561.234562299025,null,62548.295949943567,null,62548.295949943567,-12.938612355457735]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K79:K88)","v":23951453.304681938},null,{"$f":"SUM(M79:M88)","v":23740530.441478152},{"$f":"SUM(N79:N88)","v":213546.76631148125},{"$f":"M90+N90","v":23954077.207789633},{"$f":"O90-K90","v":2623.9031076952815}]
[]
[]
["Appendix 2-V"]
["Revenue Reconciliation 2019"]
[]
["Rate Class","Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[]
["Residential","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D79","v":54322.5},55241.5,{"$f":"IF(SUM(C100:D100)=0,0,AVERAGE(C100:D100))","v":54782},478548339.49470502,null,20.974805796721402,4.1161318795820473E-3,null,{"$f":"H100*E100*12+I100*F100+J100*G100","v":15758269.809987111},null,15758144.608921647,null,{"$f":"SUM(M100:N100)","v":15758144.608921647},{"$f":"O100-K100","v":-125.20106546394527}]
["GS Less Than 50 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D80","v":4268.5},4325.5,4297,129015225.78797366,null,16.470974086962965,1.7798983045551886E-2,null,3145649.1242383495,null,3145670.9813947831,null,3145670.9813947831,21.857156433630735]
["GS 50 To 999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D81","v":526.5},543.5,535,null,835118.23784245062,57.543898459216472,null,4.9236364079566659,4481250.3888978744,null,4416293.7212957591,65163.825636568123,4481457.5469323276,207.15803445316851]
["GS Intermediate 1,000 To 4,999 KW","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D82","v":13},15,14,null,169067.84371452243,1209.2234016850373,null,2.5716849147480194,637938.75473269937,null,545909.27967460547,94931.611222137988,640840.8908967434,2902.13616404403]
["Large Use","Customers",{"$f":"'App.2-V_Revenue_Reconciliation'!D83","v":1},1,1,null,88370.102609788868,9201.267281722121,null,2.2166003213535905,306296.40522357321,null,253274.0101964004,53022.395027172832,306296.40522357321,0]
["Street Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D84","v":13478.5},13995.5,13737,null,13901.837880180767,2.0714970682677429,null,32.008585327279057,786452.02671529411,null,786456.88824475557,null,786456.88824475557,4.8615294614573941]
["Sentinel Lighting","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D85","v":24},20,22,null,93.036557088953359,5.7981098845484089,null,8.2768278840253693,2300.7485794683471,null,2305.7528817135694,null,2305.7528817135694,5.004302245222334]
["Unmetered Scattered Load","Connections",{"$f":"'App.2-V_Revenue_Reconciliation'!D86","v":245.5},292.5,269,2660941.3975806902,null,4.6738803198603867,1.915354073172185E-2,null,66053.735115795935,null,66076.169870689424,null,66076.169870689424,22.434754893489298]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K100:K109)","v":25184210.993490167},null,{"$f":"SUM(M100:M109)","v":24974131.412480351},{"$f":"SUM(N100:N109)","v":213117.83188587896},{"$f":"M111+N111","v":25187249.244366229},{"$f":"O111-K111","v":3038.2508760616183}]
[]
[]
["Note"]
["1       The class specific revenue requirements in column N must be the amounts used in the final rate design process.  The total of column N should equate to the proposed base revenue requirement."]
["2       Rates should be entered with the number of decimal places that will show on the Tariff of Rates and Charges."]