{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1.0 LDC Info","2.0 Customer Classes","Instructions","3.0 LRAMVA Register","4.0 Approved Load Forecast","5.0 Carrying Charges","6.0 Rates","7.0 2011LostRev","8.0 2012LostRev","9.0 2013LostRev","10.0 2014LostRev","11.0 2015 Lost Revenue","12.0 Persistence "],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":15,"comments":2,"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.0 LDC Info","index":0,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,4,18,8],[20,4,20,8],[30,2,30,11],[32,2,32,12],[8,0,8,10],[10,4,10,10],[12,4,12,8],[14,4,14,8],[16,4,16,8],[16,9,16,10]]}
["LRAMVA Model version 1.0 © CHEC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
["LDC Info"]
[]
[null,null,null,"Utility Name   ","Wasaga Distribution"]
[]
[null,null,null,"Service Territory","Wasaga Beach"]
[]
[null,null,null,"Assigned EB Number","EB-2015-0107"]
[]
[null,null,null,"Name of Contact and Title","Brandon Weiss"]
[]
[null,null,null,"Phone Number   ","705-429-2517"]
[]
[null,null,null,"Email Address   ","B.weiss@wasagadist.ca"]
[]
[null,null,null,"Bridge Year",2015]
[]
[null,null,null,"Test Year",2016]
[]
[null,null,null,"Last Rebasing Year",2012,{"$f":"IF(Test_Year-Last_Rebasing_Year>6, \"Number of Years exceeds between CoS exceeds 6 years\",\"\")","v":""}]
[]
[null,"Notes"]
[]
[null,null,"Pale green cells represent input cells."]
[]
[null,null,"White cells contain fixed values, automatically generated values or formulae. "]

{"sheet":"2.0 Customer Classes","index":1,"n_rows":22,"n_cols":20,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
["LRAMVA Model version 1.0 © CHEC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
["Customer Class & Current Tariff Sheet"]
[]
[]
["Customer Class Name","Existing/ Proposed","MSC\nMetric","Usage Metric"]
["Residential","Exisitng","Customer","kWh"]
["General Service < 50 kW","Existing","Customer","kWh"]
["General Service > 50 to 4999 kW","Existing","Customer","kW"]
["Standy Power - Approved on an Interim Basis","Existing","Customer","kW"]
["Unmetered Scattered Load","Existing","Connection","kWh"]
["Sentinel Lighting","Existing","Connection","kW"]
["Street Lighting ","Existing","Connection","kW"]
["other"]
["other"]
["other"]

{"sheet":"Instructions","index":2,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Worksheet","Notes"]
["LRAM VA Register","Table 1 provides a summary of account balance history for account 1568 for each year. Amounts cleared through Rate Order are input by rate class."]
["Approved Load Forecast","Input kWh/kW savings included in most recent approved load forecast in Table 2.  Table 3 will calculate dollars for LRAMVA account 1568."]
["Carrying Charges","Input most recent Board-approved rate in Table 4 as available; Cumulative carrying charges are calculated in Table 5."]
["Rates","Input approved distribution rates in Table 6 from rate orders. Only the Distribution Volumetric Rate and the Rate Rider for Application of Tax Change are used."]
["2011LostRev","Table 7 - Input program details, report status, kWh and kW net savings from OPA 2011 Final Annual Report Data - Table 5; Input allocation % for each rate class."]
["2012LostRev","Table 8 - Input program details, report status, kWh and kW net savings from Final Verified Annual 2012 CDM Report_Local Distribution Corporation/Table 1 - 2012 Savings & Table 2 - Adjustments due to Errors and Omissions; OPA report provided in pdf with exception of a few LDCs; Input allocation % for each rate class."]
["2012 Gross to Net Savings","Table 9 - Retrieve the \"Gross to Net Savings\" report for the LDC from the OPA website: https://portal.ieso.ca - select your LDC under Community Projects/Documents/Conservation Officer - LDC Reports/Documents. \nNOTE: Check the values in the \"Net Annual Summer Peak Demand Savings - MWh\" (column O) against LDC Results for the corresponding year. \nAlso check any prior year true-ups against the LDC True-Up report - ensure that figures reconcile to the OPA reports;  \nCheck the values in the \"Net Annual Energy Savings - MWh\" (column AS) against LDC Results for the corresponding year. \nAlso check any prior year true-ups against the LDC True-Up report - ensure that figures reconcile to the OPA reports."]
["2013LostRev","Table 10 - Input program details, report status, kWh and kW net savings from OPA 2013 Final Annual Report Data (excel format) when available; Input allocation % for each rate class."]
["2014LostRev","Table 11 - Input program details, report status, kWh and kW net savings from OPA 2014 Final Annual Report (excel format) when available; Input allocation % for each rate class."]
["Persistence/2011","2011 OPA final report was provided in excel.  Copy MW and GWh from Annual OPA Report  - Progress Toward Targets (Tables 6 and 7_ sheet 3.1.1 Summary – LDC) in the 2011 Final Annual Report to row 7 and row 25 in Table 12 and 13 - Persistence tab. This data provides the information that LDCS require to calculate persistence for 2011 OPA Programs."]
["Persistence/2012","Copy MW and GWh from 2012 Gross to Net Savings to Report / Progress Toward Targets to row 8 and row 26 in Table 12 and 13 - Persistence tab. This data provides the information that LDCS require to calculate persistence for 2012 OPA Programs.   "]
["Persistence/2013","Copy MW and GWh from 2013 Final Annual OPA Report/Progress Toward Targets to row 9 and row 27 in Table 12 and 13 - Persistence tab when available. If the report is provided in excel format, data may be copied directly to appropriate cells in Persistence tab."]
["Classes Billed on kW","Annual Savings Methodology"]
["GS > 50 kW Initiatives excluding Demand Response 3","Apply 12 months of peak demand to the kW results in the OPA final verified CDM results to determine the annual savings."]
["GS > 50 kW Demand Response 3 Initiative","Apply 5 months of peak demand to the kW results in the OPA final verified CDM results to determine the annual savings."]
[null,"References:"]
["EB-2013-0148","Lakefront Utilities Inc."]
[null,"LUI_replySUB_BrdStaff_VECC_20140116, pages 2-3"]
[null,"BrdStaff_SUB_Lakefront Utilities_20131218, pages 4-6"]
[]
["EB-2012-0107","Bluewater Power Distribution Corporation"]
[null,"dec_order_rates_Bluewater_20130425, Settlement Agreement, page 48"]
[null,"Bluewater_appl_CoS_EDR_Ex 9_Deferral and Variance Accounts_20121022, Exhibit 9, Tab 3, Schedule 1, Attachment 2"]

{"sheet":"3.0 LRAMVA Register","index":3,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,14,37,15]]}
[null,null,"LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,null,null,null,null,null,"Table 1 - LRAMVA register"]
[]
[]
[null,null,"Verified results updated ",2015]
[]
[null,null,"Description",{"$f":"'2.0 Customer Classes'!$A13","v":"Residential"},{"$f":"'2.0 Customer Classes'!$A14","v":"General Service < 50 kW"},{"$f":"'2.0 Customer Classes'!$A15","v":"General Service > 50 to 4999 kW"},{"$f":"'2.0 Customer Classes'!$A16","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'2.0 Customer Classes'!$A17","v":"Unmetered Scattered Load"},{"$f":"'2.0 Customer Classes'!$A18","v":"Sentinel Lighting"},{"$f":"'2.0 Customer Classes'!$A19","v":"Street Lighting "},{"$f":"'2.0 Customer Classes'!$A20","v":"other"},{"$f":"'2.0 Customer Classes'!$A21","v":"other"},{"$f":"'2.0 Customer Classes'!$A22","v":"other"},"Total"]
[null,null,"2011 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D36","v":0},{"$f":"-'4.0 Approved Load Forecast'!E36","v":0},{"$f":"-'4.0 Approved Load Forecast'!F36","v":0},{"$f":"-'4.0 Approved Load Forecast'!G36","v":0},{"$f":"-'4.0 Approved Load Forecast'!H36","v":0},{"$f":"-'4.0 Approved Load Forecast'!I36","v":0},{"$f":"-'4.0 Approved Load Forecast'!J36","v":0},null,null,null,{"$f":"SUM(D12:M12)","v":0}]
[null,null,"2011 Verified",{"$f":"'7.0 2011LostRev'!F49","v":2609.4548298},{"$f":"'7.0 2011LostRev'!G49","v":1488.2706324000001},{"$f":"'7.0 2011LostRev'!H49","v":1660.2882954666668},{"$f":"'7.0 2011LostRev'!I49","v":0},{"$f":"'7.0 2011LostRev'!J49","v":0},{"$f":"'7.0 2011LostRev'!K49","v":0},{"$f":"'7.0 2011LostRev'!L49","v":0},null,null,null,{"$f":"SUM(D13:M13)","v":5758.0137576666666}]
[null,null,"2011 Cleared",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"2012 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D37","v":-7988.4826499999999},{"$f":"-'4.0 Approved Load Forecast'!E37","v":-1541.201},{"$f":"-'4.0 Approved Load Forecast'!F37","v":-1341.606425424},{"$f":"-'4.0 Approved Load Forecast'!G37","v":0},{"$f":"-'4.0 Approved Load Forecast'!H37","v":0},{"$f":"-'4.0 Approved Load Forecast'!I37","v":0},{"$f":"-'4.0 Approved Load Forecast'!J37","v":0},null,null,null,-10871.290075424]
[null,null,"2012 Verified",{"$f":"'8.0 2012LostRev'!F63","v":4204.8265976972789},{"$f":"'8.0 2012LostRev'!G63","v":2799.9386388979592},{"$f":"'8.0 2012LostRev'!H63","v":5522.4473865700693},{"$f":"'8.0 2012LostRev'!I63","v":0},{"$f":"'8.0 2012LostRev'!J63","v":0},{"$f":"'8.0 2012LostRev'!K63","v":0},{"$f":"'8.0 2012LostRev'!L63","v":0},null,null,null,12527.212623165307]
[null,null,"2012 Cleared",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"2013 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D38","v":-7811.3751000000002},{"$f":"-'4.0 Approved Load Forecast'!E38","v":-1525.8656666666668},{"$f":"-'4.0 Approved Load Forecast'!F38","v":-1325.5639810799998},{"$f":"-'4.0 Approved Load Forecast'!G38","v":0},{"$f":"-'4.0 Approved Load Forecast'!H38","v":0},{"$f":"-'4.0 Approved Load Forecast'!I38","v":0},{"$f":"-'4.0 Approved Load Forecast'!J38","v":0},null,null,null,-10662.804747746668]
[null,null,"2013 Actuals",{"$f":"'9.0 2013LostRev'!F70","v":5796.9611562923328},{"$f":"'9.0 2013LostRev'!G70","v":3482.0356794155382},{"$f":"'9.0 2013LostRev'!H70","v":5932.1538249758441},{"$f":"'9.0 2013LostRev'!I70","v":0},{"$f":"'9.0 2013LostRev'!J70","v":0},{"$f":"'9.0 2013LostRev'!K70","v":0},{"$f":"'9.0 2013LostRev'!L70","v":0},null,null,null,15211.150660683714]
[null,null,"2013 Cleared",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"2014 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D39","v":-7904.5895999999993},{"$f":"-'4.0 Approved Load Forecast'!E39","v":-1545.0348333333334},{"$f":"-'4.0 Approved Load Forecast'!F39","v":-1342.722505944},{"$f":"-'4.0 Approved Load Forecast'!G39","v":0},{"$f":"-'4.0 Approved Load Forecast'!H39","v":0},{"$f":"-'4.0 Approved Load Forecast'!I39","v":0},{"$f":"-'4.0 Approved Load Forecast'!J39","v":0},null,null,null,-10792.346939277333]
[null,null,"2014 Actuals",{"$f":"'10.0 2014LostRev'!F57","v":11092.468102210367},{"$f":"'10.0 2014LostRev'!G57","v":5997.7472598350942},{"$f":"'10.0 2014LostRev'!H57","v":6279.1635834632643},{"$f":"'10.0 2014LostRev'!I57","v":0},{"$f":"'10.0 2014LostRev'!J57","v":0},{"$f":"'10.0 2014LostRev'!K57","v":0},{"$f":"'10.0 2014LostRev'!L57","v":0},null,null,null,23369.378945508728]
[null,null,"2014 Cleared",null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"2015 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D40","v":-8016.4469999999992},{"$f":"-'4.0 Approved Load Forecast'!E40","v":-1568.0378333333333},{"$f":"-'4.0 Approved Load Forecast'!F40","v":-1364.6462093759999},{"$f":"-'4.0 Approved Load Forecast'!G40","v":0},{"$f":"-'4.0 Approved Load Forecast'!H40","v":0},{"$f":"-'4.0 Approved Load Forecast'!I40","v":0},{"$f":"-'4.0 Approved Load Forecast'!J40","v":0},null,null,null,{"$f":"SUM(D28:J28)","v":-10949.131042709332}]
[null,null,"2015 Actuals",{"$f":"'11.0 2015 Lost Revenue'!E17","v":10501.633744366663},{"$f":"'11.0 2015 Lost Revenue'!F17","v":5605.1351121066655},{"$f":"'11.0 2015 Lost Revenue'!G17","v":4728.9649180480001},0,0,0,0,null,null,null,{"$f":"SUM(D29:M29)","v":20835.73377452133},"      2011-2014 Persistence"]
[null,null,"2015 Cleared",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:M30)","v":0},"     (FROM FINAL CDM)"]
[]
[null,null,"Carrying Charges1",{"$f":"'5.0 Carrying Charges'!D114","v":-3.9574629655185714},{"$f":"'5.0 Carrying Charges'!E114","v":371.30631203536296},{"$f":"'5.0 Carrying Charges'!F114","v":636.92472709006904},0,0,0,0,null,null,null,{"$f":"SUM(D32:J32)","v":1004.2735761599134}]
[null,null,"Balance",{"$f":"SUM(D12:D32)","v":2480.4926174011239},{"$f":"SUM(E12:E32)","v":13564.294301357288},19385.403613789913,0,0,0,0,{"$f":"SUM(K12:K32)","v":0},{"$f":"SUM(L12:L32)","v":0},{"$f":"SUM(M12:M32)","v":0},{"$f":"SUM(N12:N32)","v":35430.190532548324}]
[]
[null,null,"Excluding 2015 Persistence for 2011-2014 CDM Portfolio:"]
[]
[null,null,"Carrying Charges1",-25.79,335.84,607.37,0,0,0,0,{"$f":"SUM('5.0 Carrying Charges'!K96:K104)","v":0},{"$f":"SUM('5.0 Carrying Charges'!L96:L104)","v":0},{"$f":"SUM('5.0 Carrying Charges'!M96:M104)","v":0},{"$f":"SUM(D37:M37)","v":917.42},"     Carrying charges up to April 30,2016"]
[null,null,"Balance",{"$f":"SUM(D12:D26)+D37","v":-26.526664000021846},9491.7307105485925,15991.530178027844,0,0,0,0,0,0,0,25456.734224576412]
[]
[]
[null,null,"Input amounts cleared by rate class."]
[null,null,"1 Update formula for most recent rate year"]

{"sheet":"4.0 Approved Load Forecast","index":4,"n_rows":106,"n_cols":14,"rows_kept":106,"cut":false,"hidden":false,"merged":[[18,1,18,13],[31,1,31,13],[43,0,43,13],[52,3,53,13],[7,1,7,4]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[null,"CDM Targets"]
[]
[null,"Forecast Year",null," "]
[null,null,null,"kWh","kW"]
[null,2011,null,0,{"$f":"E13*0.5","v":-145.57571999999999}]
[null,2012,null,802000,{"$f":"N65","v":-291.15143999999998}]
[null,2013,null,{"$f":"+D13","v":802000},{"$f":"N78","v":-291.15143999999998}]
[null,2014,null,{"$f":"+D14","v":802000},{"$f":"N91","v":-291.15143999999998}]
[null,2015,null,{"$f":"D15","v":802000},{"$f":"E15","v":-291.15143999999998}]
[]
[]
[null,"Table 2 - Savings Due to CDM Included in Approved Load Forecast"]
[]
[null,"Forecast Year",null,{"$f":"'3.0 LRAMVA Register'!D$11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E$11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F$11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G$11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H$11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I$11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J$11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K$11","v":"other"},{"$f":"'3.0 LRAMVA Register'!L$11","v":"other"},{"$f":"'3.0 LRAMVA Register'!M$11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
[null,null,null,{"$f":"'2.0 Customer Classes'!$D13","v":"kWh"},{"$f":"'2.0 Customer Classes'!$D14","v":"kWh"},{"$f":"'2.0 Customer Classes'!$D15","v":"kW"},{"$f":"'2.0 Customer Classes'!$D16","v":"kW"},{"$f":"'2.0 Customer Classes'!$D17","v":"kWh"},{"$f":"'2.0 Customer Classes'!$D18","v":"kW"},{"$f":"'2.0 Customer Classes'!$D19","v":"kW"},{"$f":"'2.0 Customer Classes'!$D20","v":0},{"$f":"'2.0 Customer Classes'!$D21","v":0},{"$f":"'2.0 Customer Classes'!$D22","v":0}]
[null,2011,null,0,0,0,0,0,0,0]
[null,2012,null,{"$f":"-D61","v":559287},{"$f":"-E61","v":115015},{"$f":"-F65","v":291.15143999999998},{"$f":"-G65","v":0},{"$f":"-H61","v":0},{"$f":"-I65","v":0},{"$f":"-J65","v":0}]
[null,2013,null,{"$f":"-D74","v":559287},{"$f":"-E74","v":115015},{"$f":"-F78","v":291.15143999999998},{"$f":"-G78","v":0},{"$f":"-H74","v":0},{"$f":"-I78","v":0},{"$f":"-J78","v":0}]
[null,2014,null,{"$f":"-D87","v":559287},{"$f":"-E87","v":115015},{"$f":"-F91","v":291.15143999999998},{"$f":"-G91","v":0},{"$f":"-H87","v":0},{"$f":"-I91","v":0},{"$f":"-J91","v":0}]
[null,2014,null,{"$f":"-D100","v":559287},{"$f":"-E100","v":115015},{"$f":"-F104","v":291.15143999999998},0,0,0,0]
[]
[null,"Notes:",null,"No CDM for 2011-2014 assumed in the most recent load forecast  (2010 Cost of Service application)"]
[]
[]
[null,"Table 3 - Forecast Loss Revenue by Class"]
[]
[null,"Forecast Year",null,{"$f":"D21","v":"Residential"},"General Service < 50 kW","General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,null,null,"$","$","$","$","$","$","$","$","$","$","$"]
[null,2011,null,{"$f":"D23*'6.0 Rates'!C15","v":0},{"$f":"E23*'6.0 Rates'!C16","v":0},{"$f":"F23*'6.0 Rates'!C17","v":0},{"$f":"G23*'6.0 Rates'!C18","v":0},{"$f":"H23*'6.0 Rates'!C19","v":0},{"$f":"I23*'6.0 Rates'!C20","v":0},{"$f":"J23*'6.0 Rates'!C21","v":0},null,null,null,{"$f":"SUM(D36:M36)","v":0}]
[null,2012,null,{"$f":"D24*'6.0 Rates'!D15","v":7988.4826499999999},{"$f":"E24*'6.0 Rates'!D16","v":1541.201},{"$f":"F24*'6.0 Rates'!D17","v":1341.606425424},{"$f":"G24*'6.0 Rates'!D18","v":0},{"$f":"H24*'6.0 Rates'!D19","v":0},{"$f":"I24*'6.0 Rates'!D20","v":0},{"$f":"J24*'6.0 Rates'!D21","v":0},null,null,null,{"$f":"SUM(D37:M37)","v":10871.290075424}]
[null,2013,null,{"$f":"D25*'6.0 Rates'!E15","v":7811.3751000000002},{"$f":"E25*'6.0 Rates'!E16","v":1525.8656666666668},{"$f":"F25*'6.0 Rates'!E17","v":1325.5639810799998},{"$f":"G25*'6.0 Rates'!E18","v":0},{"$f":"H25*'6.0 Rates'!E19","v":0},{"$f":"I25*'6.0 Rates'!E20","v":0},{"$f":"J25*'6.0 Rates'!E21","v":0},null,null,null,10662.804747746668]
[null,2014,null,{"$f":"D26*'6.0 Rates'!F15","v":7904.5895999999993},{"$f":"E26*'6.0 Rates'!F16","v":1545.0348333333334},{"$f":"F26*'6.0 Rates'!F17","v":1342.722505944},{"$f":"G26*'6.0 Rates'!F18","v":0},{"$f":"H26*'6.0 Rates'!F19","v":0},{"$f":"I26*'6.0 Rates'!F20","v":0},{"$f":"J26*'6.0 Rates'!F21","v":0},null,null,null,10792.346939277333]
[null,2015,null,{"$f":"D26*'6.0 Rates'!G15","v":8016.4469999999992},{"$f":"E26*'6.0 Rates'!G16","v":1568.0378333333333},{"$f":"F26*'6.0 Rates'!G17","v":1364.6462093759999},{"$f":"G28*'6.0 Rates'!F19","v":0},{"$f":"H28*'6.0 Rates'!F20","v":0},{"$f":"I28*'6.0 Rates'!F21","v":0},{"$f":"J28*'6.0 Rates'!F22","v":0},null,null,null,{"$f":"SUM(D40:M40)","v":10949.131042709332}]
[]
[]
[]
["CDM Adjustment as Approved in last Cost of Service"]
[]
[null,2011,null,{"$f":"D34","v":"Residential"},{"$f":"E34","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[]
[null,"Approved Load Forecast",null,92721561,19067748,22680860,null,321139,null,1828859,null,null,null,{"$f":"SUM(D48:M48)","v":136620167}]
[null,"% of Billed",null,{"$f":"D48/$N$48","v":0.67868136188122208},0.13956759399950083,0.1660139970404223,0,2.3505973316516296E-3,0,1.3386449747203134E-2,{"$f":"K48/$N$48","v":0},0,{"$f":"M48/$N$48","v":0},{"$f":"SUM(D49:M49)","v":1}]
[null,"CDM Spread kWh",null,{"$f":"-$D$12*D49","v":0},0,0,0,0,0,{"$f":"-$D$12*J49","v":0},0,0,{"$f":"-$D$12*M49","v":0},{"$f":"SUM(D50:M50)","v":0}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D48+D50","v":92721561},{"$f":"E48+E50","v":19067748},22680860,0,321139,0,1828859,0,0,0,{"$f":"SUM(D51:M52)","v":136620167}]
[]
[null,null,null,"No CDM was applied to Load Forecast since to 2010.  \nThe tables below will be used to show the OEB approved billed data from which CDM adjustments are derived"]
[]
[]
[]
[null,2012,null,{"$f":"D46","v":"Residential"},"General Service < 50 kW","General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"Approved Billed Forecast Non CDM Adj",null,92721561,19067748,22680860,null,321139,null,1828859,null,null,null,{"$f":"SUM(D59:M59)","v":136620167}]
[null,"% of Billed",null,{"$f":"D59/$N$59","v":0.67868136188122208},{"$f":"E59/$N$59","v":0.13956759399950083},{"$f":"F59/$N$59","v":0.1660139970404223},0,2.3505973316516296E-3,0,{"$f":"J59/$N$59","v":1.3386449747203134E-2},0,0,{"$f":"M59/$N$59","v":0},{"$f":"SUM(D60:M60)","v":1}]
[null,"Applied CDM kWh",null,-559287,-115015,-127698,0,0,0,0,0,0,0,{"$f":"SUM(D61:M61)","v":-802000}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D59+D61","v":92162274},{"$f":"E59+E61","v":18952733},{"$f":"F59+F61","v":22553162},{"$f":"G59+G61","v":0},{"$f":"H59+H61","v":321139},{"$f":"I59+I61","v":0},1828859,0,0,{"$f":"M59+M61","v":0},{"$f":"SUM(D62:M63)","v":135818167}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D59*D67","v":0},0,{"$f":"F59*F67","v":51712.360799999995},{"$f":"G59*G67","v":0},0,0,{"$f":"J59*J67","v":0},0,0,0,{"$f":"SUM(D64:M64)","v":51712.360799999995}]
[null,"CDM kW Reduction",null,{"$f":"D61*D67","v":0},0,{"$f":"F61*F67","v":-291.15143999999998},{"$f":"G61*G67","v":0},0,0,{"$f":"J61*J67","v":0},0,0,0,{"$f":"SUM(D65:M65)","v":-291.15143999999998}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D64+D65","v":0},0,{"$f":"F64+F65","v":51421.209359999993},{"$f":"G64+G65","v":0},0,0,{"$f":"J64+J65","v":0},0,0,0,{"$f":"SUM(D66:M66)","v":51421.209359999993}]
[null,"kWh to KW Ratio",null,null,null,2.2799999999999999E-3]
[]
[]
[null,2013,null,{"$f":"D57","v":"Residential"},{"$f":"E57","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"Approved Billed Forecast Non CDM Adj",null,{"$f":"+D59","v":92721561},{"$f":"+E59","v":19067748},22680860,null,321139,null,1828859,null,null,null,{"$f":"SUM(D72:M72)","v":136620167}]
[null,"% of Billed",null,{"$f":"D72/$N$72","v":0.67868136188122208},0.13956759399950083,0.1660139970404223,0,2.3505973316516296E-3,0,1.3386449747203134E-2,0,0,0,{"$f":"SUM(D73:M73)","v":1}]
[null,"Applied CDM kWh",null,-559287,-115015,-127698,0,0,0,0,0,0,0,{"$f":"SUM(D74:M74)","v":-802000}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D72+D74","v":92162274},{"$f":"E72+E74","v":18952733},{"$f":"F72+F74","v":22553162},{"$f":"G72+G74","v":0},{"$f":"H72+H74","v":321139},{"$f":"I72+I74","v":0},1828859,0,0,{"$f":"M72+M74","v":0},{"$f":"SUM(D75:M76)","v":135818167}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D72*D80","v":0},{"$f":"E72*E80","v":0},{"$f":"F72*F80","v":51712.360799999995},{"$f":"G72*G80","v":0},0,0,{"$f":"J72*J80","v":0},0,0,0,{"$f":"SUM(D77:M77)","v":51712.360799999995}]
[null,"CDM kW Reduction",null,{"$f":"D74*D80","v":0},{"$f":"E74*E80","v":0},{"$f":"F74*F80","v":-291.15143999999998},{"$f":"G74*G80","v":0},0,0,{"$f":"J74*J80","v":0},0,0,0,{"$f":"SUM(D78:M78)","v":-291.15143999999998}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D77+D78","v":0},{"$f":"E77+E78","v":0},{"$f":"F77+F78","v":51421.209359999993},{"$f":"G77+G78","v":0},{"$f":"H77+H78","v":0},{"$f":"I77+I78","v":0},0,0,0,0,{"$f":"SUM(D79:M79)","v":51421.209359999993}]
[null,"kWh to KW Ratio",null,null,null,{"$f":"+F67","v":2.2799999999999999E-3}]
[]
[]
[null,2014,null,{"$f":"D70","v":"Residential"},{"$f":"E70","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"Approved Billed Forecast Non CDM Adj",null,{"$f":"+D72","v":92721561},{"$f":"+E72","v":19067748},22680860,null,321139,null,1828859,null,null,null,{"$f":"SUM(D85:M85)","v":136620167}]
[null,"% of Billed",null,{"$f":"D85/$N$85","v":0.67868136188122208},0.13956759399950083,0.1660139970404223,0,2.3505973316516296E-3,0,1.3386449747203134E-2,0,0,0,{"$f":"SUM(D86:M86)","v":1}]
[null,"Applied CDM kWh",null,-559287,-115015,-127698,0,0,0,0,0,0,0,{"$f":"SUM(D87:M87)","v":-802000}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D85+D87","v":92162274},{"$f":"E85+E87","v":18952733},{"$f":"F85+F87","v":22553162},{"$f":"G85+G87","v":0},{"$f":"H85+H87","v":321139},{"$f":"I85+I87","v":0},1828859,0,0,{"$f":"M85+M87","v":0},{"$f":"SUM(D88:M89)","v":135818167}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D85*D93","v":0},0,{"$f":"F85*F93","v":51712.360799999995},{"$f":"G85*G93","v":0},0,0,{"$f":"J85*J93","v":0},0,0,0,{"$f":"SUM(D90:M90)","v":51712.360799999995}]
[null,"CDM kW Reduction",null,{"$f":"D87*D93","v":0},0,{"$f":"F87*F93","v":-291.15143999999998},{"$f":"G87*G93","v":0},0,0,{"$f":"J87*J93","v":0},0,0,0,{"$f":"SUM(D91:M91)","v":-291.15143999999998}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D90+D91","v":0},0,{"$f":"F90+F91","v":51421.209359999993},{"$f":"G90+G91","v":0},{"$f":"H90+H91","v":0},{"$f":"I90+I91","v":0},0,0,0,0,{"$f":"SUM(D92:M92)","v":51421.209359999993}]
[null,"kWh to KW Ratio",null,null,null,{"$f":"+F80","v":2.2799999999999999E-3}]
[]
[]
[null,2015,null,{"$f":"D83","v":"Residential"},{"$f":"E83","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Standy Power - Approved on an Interim Basis","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"Approved Billed Forecast Non CDM Adj",null,{"$f":"+D85","v":92721561},{"$f":"+E85","v":19067748},22680860,null,321139,null,1828859,null,null,null,{"$f":"SUM(D98:M98)","v":136620167}]
[null,"% of Billed",null,{"$f":"D98/$N$85","v":0.67868136188122208},0.13956759399950083,0.1660139970404223,0,2.3505973316516296E-3,0,1.3386449747203134E-2,0,0,0,{"$f":"SUM(D99:M99)","v":1}]
[null,"Applied CDM kWh",null,-559287,-115015,-127698,0,0,0,0,0,0,0,{"$f":"SUM(D100:M100)","v":-802000}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D98+D100","v":92162274},{"$f":"E98+E100","v":18952733},22553162,0,321139,0,1828859,0,0,0,{"$f":"SUM(D101:M102)","v":135818167}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D98*D106","v":0},0,{"$f":"F98*F106","v":51712.360799999995},{"$f":"G98*G106","v":0},0,0,0,0,0,0,{"$f":"SUM(D103:M103)","v":51712.360799999995}]
[null,"CDM kW Reduction",null,{"$f":"D100*D106","v":0},0,{"$f":"F100*F106","v":-291.15143999999998},{"$f":"G100*G106","v":0},0,0,0,0,0,0,{"$f":"SUM(D104:M104)","v":-291.15143999999998}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D103+D104","v":0},0,{"$f":"F103+F104","v":51421.209359999993},{"$f":"G103+G104","v":0},0,0,0,0,0,0,{"$f":"SUM(D105:M105)","v":51421.209359999993}]
[null,"kWh to KW Ratio",null,null,null,{"$f":"+F93","v":2.2799999999999999E-3}]

{"sheet":"5.0 Carrying Charges","index":5,"n_rows":114,"n_cols":14,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,4,8,7],[30,4,30,7]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Table 4 - Carrying Charges Prescribed Rates"]
[]
[null,null,null,null,"Period","Board specified","Estimated","Used in calculations"]
[null,null,null,null,"2011 Q1",1.47E-2,null,{"$f":"IF(F12<>0,F12,G12)","v":1.47E-2}]
[null,null,null,null,"2011 Q2",1.47E-2,null,{"$f":"IF(F13<>0,F13,G13)","v":1.47E-2}]
[null,null,null,null,"2011 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2011 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q3",null,1.47E-2,1.47E-2]
[null,null,null,null,"2014 Q4",null,1.47E-2,1.47E-2]
[null,null,null,null,"2015 Q1",null,1.47E-2,1.47E-2]
[null,null,null,null,"2015 Q2 - PRESENT",null,1.0999999999999999E-2,1.0999999999999999E-2]
[]
[null,null,null,null,"Table 5 - Carrying Charges by Rate Class"]
[]
["Month","Quarter","Monthly Rate",{"$f":"'3.0 LRAMVA Register'!D11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K11","v":"other"},{"$f":"'3.0 LRAMVA Register'!L11","v":"other"},{"$f":"'3.0 LRAMVA Register'!M11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
["2011-01-01","Q1",{"$f":"H$12/12","v":1.225E-3}]
["2011-02-01","Q1",{"$f":"H$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A35)-1)/12*$C35","v":0.26638184720874997},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A35)-1)/12*$C35","v":0.15192762705750001},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A35)-1)/12*$C35","v":0.16948776349555555},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM(D35:M35)","v":0.58779723776180548}]
["2011-03-01","Q1",{"$f":"H$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A36)-1)/12*$C36","v":0.53276369441749993},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A36)-1)/12*$C36","v":0.30385525411500003},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A36)-1)/12*$C36","v":0.33897552699111111},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM(D36:M36)","v":1.175594475523611}]
["2011-04-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A37)-1)/12*$C37","v":0.79914554162624996},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A37)-1)/12*$C37","v":0.45578288117249999},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A37)-1)/12*$C37","v":0.50846329048666672},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A37)-1)/12*$C37","v":0},1.7633917132854164]
["Total for rate year 2010",null,null,{"$f":"SUM(D34:D37)","v":1.5982910832524997},{"$f":"SUM(E34:E37)","v":0.91156576234499997},1.0169265809733332,0,0,0,0,0,0,0,3.5267834265708329]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:M39)","v":0}]
["Opening Balance for rate year 2011",null,null,{"$f":"D38+D39","v":1.5982910832524997},{"$f":"E38+E39","v":0.91156576234499997},{"$f":"F38+F39","v":1.0169265809733332},{"$f":"G38+G39","v":0},0,0,0,0,0,0,{"$f":"N38+N39","v":3.5267834265708329}]
["2011-05-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A41)-1)/12*$C41","v":1.0655273888349999},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A41)-1)/12*$C41","v":0.60771050823000006},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A41)-1)/12*$C41","v":0.67795105398222222},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM(D41:M41)","v":2.3511889510472219}]
["2011-06-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A42)-1)/12*$C42","v":1.3319092360437499},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A42)-1)/12*$C42","v":0.75963813528750002},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A42)-1)/12*$C42","v":0.84743881747777783},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM(D42:M42)","v":2.9389861888090278}]
["2011-07-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A43)-1)/12*$C43","v":1.5982910832524999},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A43)-1)/12*$C43","v":0.91156576234499997},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A43)-1)/12*$C43","v":1.0169265809733334},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A43)-1)/12*$C43","v":0},3.5267834265708329]
["2011-08-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A44)-1)/12*$C44","v":1.8646729304612499},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A44)-1)/12*$C44","v":1.0634933894025},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A44)-1)/12*$C44","v":1.1864143444688888},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A44)-1)/12*$C44","v":0},4.1145806643326388]
["2011-09-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A45)-1)/12*$C45","v":2.1310547776699997},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A45)-1)/12*$C45","v":1.2154210164600001},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A45)-1)/12*$C45","v":1.3559021079644444},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A45)-1)/12*$C45","v":0},4.7023779020944438]
["2011-10-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A46)-1)/12*$C46","v":2.39743662487875},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A46)-1)/12*$C46","v":1.3673486435175},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A46)-1)/12*$C46","v":1.52538987146},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A46)-1)/12*$C46","v":0},5.2901751398562498]
["2011-11-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A47)-1)/12*$C47","v":2.6638184720874998},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A47)-1)/12*$C47","v":1.519276270575},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A47)-1)/12*$C47","v":1.6948776349555557},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A47)-1)/12*$C47","v":0},5.8779723776180557]
["2011-12-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!D$12:D$13)*(MONTH($A48)-1)/12*$C48","v":2.9302003192962496},{"$f":"SUM('3.0 LRAMVA Register'!E$12:E$13)*(MONTH($A48)-1)/12*$C48","v":1.6712038976325001},{"$f":"SUM('3.0 LRAMVA Register'!F$12:F$13)*(MONTH($A48)-1)/12*$C48","v":1.8643653984511113},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$13)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$13)*(MONTH($A48)-1)/12*$C48","v":0},6.4657696153798607]
["2012-01-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A49)-1)/12)*$C49","v":3.1965821665049998},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A49)-1)/12)*$C49","v":1.8231315246899999},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A49)-1)/12)*$C49","v":2.0338531619466669},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A49)-1)/12)*$C49","v":0},7.0535668531416658]
["2012-02-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A50)-1)/12)*$C50","v":2.8103339444990976},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A50)-1)/12)*$C50","v":1.9516276586608334},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A50)-1)/12)*$C50","v":2.4606473433969946},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A50)-1)/12)*$C50","v":0},7.2226089465569263]
["2012-03-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A51)-1)/12)*$C51","v":2.4240857224931944},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A51)-1)/12)*$C51","v":2.0801237926316665},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A51)-1)/12)*$C51","v":2.8874415248473224},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A51)-1)/12)*$C51","v":0},7.3916510399721833]
["2012-04-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A52)-1)/12)*$C52","v":2.0378375004872917},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A52)-1)/12)*$C52","v":2.2086199266025002},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A52)-1)/12)*$C52","v":3.3142357062976506},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"SUM(D52:M52)","v":7.560693133387443}]
["Total for rate year 2011",null,null,{"$f":"SUM(D40:D52)","v":28.050041249762089},{"$f":"SUM(E40:E52)","v":18.090726288379997},21.882370127195301,0,0,0,0,{"$f":"SUM(K40:K52)","v":0},0,0,68.023137665337387]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:M54)","v":0}]
["Opening Balance for rate year 2012",null,null,{"$f":"D53+D54","v":28.050041249762089},18.090726288379997,21.882370127195301,0,0,0,0,0,0,0,{"$f":"N53+N54","v":68.023137665337387}]
["2012-05-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A56)-1)/12)*$C56","v":1.6515892784813888},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A56)-1)/12)*$C56","v":2.3371160605733334},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A56)-1)/12)*$C56","v":3.7410298877479784},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"SUM(D56:M56)","v":7.7297352268027009}]
["2012-06-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A57)-1)/12)*$C57","v":1.2653410564754861},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A57)-1)/12)*$C57","v":2.4656121945441667},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A57)-1)/12)*$C57","v":4.1678240691983062},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A57)-1)/12)*$C57","v":0},7.8987773202179588]
["2012-07-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A58)-1)/12)*$C58","v":0.87909283446958353},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A58)-1)/12)*$C58","v":2.594108328515},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A58)-1)/12)*$C58","v":4.5946182506486348},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A58)-1)/12)*$C58","v":0},8.0678194136332184]
["2012-08-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A59)-1)/12)*$C59","v":0.49284461246368083},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A59)-1)/12)*$C59","v":2.7226044624858332},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A59)-1)/12)*$C59","v":5.0214124320989617},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A59)-1)/12)*$C59","v":0},8.2368615070484754]
["2012-09-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A60)-1)/12)*$C60","v":0.10659639045777779},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A60)-1)/12)*$C60","v":2.8511005964566669},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A60)-1)/12)*$C60","v":5.4482066135492904},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A60)-1)/12)*$C60","v":0},8.4059036004637342]
["2012-10-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A61)-1)/12)*$C61","v":-0.27965183154812528},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A61)-1)/12)*$C61","v":2.9795967304275002},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A61)-1)/12)*$C61","v":5.8750007949996172},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A61)-1)/12)*$C61","v":0},8.5749456938789912]
["2012-11-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A62)-1)/12)*$C62","v":-0.6659000535540277},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A62)-1)/12)*$C62","v":3.1080928643983339},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A62)-1)/12)*$C62","v":6.3017949764499459},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A62)-1)/12)*$C62","v":0},8.7439877872942517]
["2012-12-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$14)+SUM('3.0 LRAMVA Register'!D$16:D$17)*(MONTH($A63)-1)/12)*$C63","v":-1.0521482755599307},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$14)+SUM('3.0 LRAMVA Register'!E$16:E$17)*(MONTH($A63)-1)/12)*$C63","v":3.2365889983691667},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$14)+SUM('3.0 LRAMVA Register'!F$16:F$17)*(MONTH($A63)-1)/12)*$C63","v":6.7285891579002737},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$14)+SUM('3.0 LRAMVA Register'!G$16:G$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$14)+SUM('3.0 LRAMVA Register'!H$16:H$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$14)+SUM('3.0 LRAMVA Register'!I$16:I$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$14)+SUM('3.0 LRAMVA Register'!J$16:J$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$14)+SUM('3.0 LRAMVA Register'!K$16:K$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$14)+SUM('3.0 LRAMVA Register'!L$16:L$17)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$14)+SUM('3.0 LRAMVA Register'!M$16:M$17)*(MONTH($A63)-1)/12)*$C63","v":0},8.9130298807095087]
["2013-01-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A64)-1)/12)*$C64","v":-1.4383964975658332},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A64)-1)/12)*$C64","v":3.36508513234},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A64)-1)/12)*$C64","v":7.1553833393506014},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A64)-1)/12)*$C64","v":0},9.0820719741247675]
["2013-02-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A65)-1)/12)*$C65","v":-1.6440345876526576},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A65)-1)/12)*$C65","v":3.5647774878081138},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A65)-1)/12)*$C65","v":7.6256393859149689},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A65)-1)/12)*$C65","v":0},9.5463822860704255]
["2013-03-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A66)-1)/12)*$C66","v":-1.8496726777394821},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A66)-1)/12)*$C66","v":3.764469843276228},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A66)-1)/12)*$C66","v":8.0958954324793364},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A66)-1)/12)*$C66","v":0},10.010692598016082]
["2013-04-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A67)-1)/12)*$C67","v":-2.0553107678263065},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A67)-1)/12)*$C67","v":3.9641621987443418},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A67)-1)/12)*$C67","v":8.5661514790437039},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A67)-1)/12)*$C67","v":0},10.47500290996174]
["Total for rate year 2012",null,null,{"$f":"SUM(D55:D67)","v":23.460390730663644},{"$f":"SUM(E55:E67)","v":55.044041186318687},95.203915946576927,0,0,0,0,{"$f":"SUM(K55:K67)","v":0},0,0,{"$f":"SUM(N55:N67)","v":173.70834786355925}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:M69)","v":0}]
["Opening Balance for rate year 2013",null,null,{"$f":"D68+D69","v":23.460390730663644},55.044041186318687,95.203915946576927,0,0,0,0,0,0,0,{"$f":"N68+N69","v":173.70834786355925}]
["2013-05-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A71)-1)/12)*$C71","v":-2.2609488579131307},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A71)-1)/12)*$C71","v":4.1638545542124561},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A71)-1)/12)*$C71","v":9.0364075256080714},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"SUM(D71:M71)","v":10.939313221907398}]
["2013-06-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A72)-1)/12)*$C72","v":-2.4665869479999554},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A72)-1)/12)*$C72","v":4.3635469096805695},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A72)-1)/12)*$C72","v":9.5066635721724388},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A72)-1)/12)*$C72","v":0},11.403623533853054]
["2013-07-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A73)-1)/12)*$C73","v":-2.6722250380867796},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A73)-1)/12)*$C73","v":4.5632392651486837},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A73)-1)/12)*$C73","v":9.9769196187368063},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A73)-1)/12)*$C73","v":0},11.86793384579871]
["2013-08-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A74)-1)/12)*$C74","v":-2.8778631281736042},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A74)-1)/12)*$C74","v":4.762931620616798},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A74)-1)/12)*$C74","v":10.447175665301172},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A74)-1)/12)*$C74","v":0},12.332244157744366]
["2013-09-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A75)-1)/12)*$C75","v":-3.0835012182604284},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A75)-1)/12)*$C75","v":4.9626239760849113},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A75)-1)/12)*$C75","v":10.91743171186554},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A75)-1)/12)*$C75","v":0},12.796554469690022]
["2013-10-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A76)-1)/12)*$C76","v":-3.2891393083472531},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A76)-1)/12)*$C76","v":5.1623163315530256},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A76)-1)/12)*$C76","v":11.387687758429907},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A76)-1)/12)*$C76","v":0},13.260864781635679]
["2013-11-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A77)-1)/12)*$C77","v":-3.4947773984340773},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A77)-1)/12)*$C77","v":5.362008687021139},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A77)-1)/12)*$C77","v":11.857943804994276},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A77)-1)/12)*$C77","v":0},13.725175093581338]
["2013-12-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$18)+SUM('3.0 LRAMVA Register'!D$20:D$21)*(MONTH($A78)-1)/12)*$C78","v":-3.7004154885209015},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$18)+SUM('3.0 LRAMVA Register'!E$20:E$21)*(MONTH($A78)-1)/12)*$C78","v":5.5617010424892541},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$18)+SUM('3.0 LRAMVA Register'!F$20:F$21)*(MONTH($A78)-1)/12)*$C78","v":12.328199851558644},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$18)+SUM('3.0 LRAMVA Register'!G$20:G$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$18)+SUM('3.0 LRAMVA Register'!H$20:H$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$18)+SUM('3.0 LRAMVA Register'!I$20:I$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$18)+SUM('3.0 LRAMVA Register'!J$20:J$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$18)+SUM('3.0 LRAMVA Register'!K$20:K$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$18)+SUM('3.0 LRAMVA Register'!L$20:L$21)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$18)+SUM('3.0 LRAMVA Register'!M$20:M$21)*(MONTH($A78)-1)/12)*$C78","v":0},14.189485405526996]
["2014-01-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A79)-1)/12)*$C79","v":-3.9060535786077271},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A79)-1)/12)*$C79","v":5.7613933979573675},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A79)-1)/12)*$C79","v":12.798455898123011},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A79)-1)/12)*$C79","v":0},14.653795717472651]
["2014-02-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A80)-1)/12)*$C80","v":-3.5806243148404184},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A80)-1)/12)*$C80","v":6.2159411248294223},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A80)-1)/12)*$C80","v":13.302384258119769},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A80)-1)/12)*$C80","v":0},15.937701068108773]
["2014-03-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A81)-1)/12)*$C81","v":-3.2551950510731102},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A81)-1)/12)*$C81","v":6.6704888517014771},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A81)-1)/12)*$C81","v":13.806312618116527},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A81)-1)/12)*$C81","v":0},17.221606418744894]
["2014-04-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A82)-1)/12)*$C82","v":-2.9297657873058016},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A82)-1)/12)*$C82","v":7.125036578573531},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A82)-1)/12)*$C82","v":14.310240978113287},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A82)-1)/12)*$C82","v":0},18.505511769381016]
["Total for rate year 2013",null,null,{"$f":"SUM(D70:D82)","v":-14.056705386899548},{"$f":"SUM(E70:E82)","v":119.71912352618735},{"$f":"SUM(F70:F82)","v":234.87973920771637},{"$f":"SUM(G70:G82)","v":0},{"$f":"SUM(H70:H82)","v":0},{"$f":"SUM(I70:I82)","v":0},{"$f":"SUM(J70:J82)","v":0},0,0,0,{"$f":"SUM(N70:N82)","v":340.54215734700421}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D84:M84)","v":0}]
["Opening Balance for rate year 2014",null,null,{"$f":"D83+D84","v":-14.056705386899548},{"$f":"E83+E84","v":119.71912352618735},234.87973920771637,0,0,0,0,0,0,0,{"$f":"N83+N84","v":340.54215734700421}]
["2014-05-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A86)-1)/12)*$C86","v":-2.6043365235384934},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A86)-1)/12)*$C86","v":7.5795843054455858},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A86)-1)/12)*$C86","v":14.814169338110045},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"SUM(D86:M86)","v":19.789417120017138}]
["2014-06-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A87)-1)/12)*$C87","v":-2.2789072597711852},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A87)-1)/12)*$C87","v":8.0341320323176415},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A87)-1)/12)*$C87","v":15.318097698106802},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A87)-1)/12)*$C87","v":0},21.07332247065326]
["2014-07-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A88)-1)/12)*$C88","v":-1.9534779960038768},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A88)-1)/12)*$C88","v":8.4886797591896954},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A88)-1)/12)*$C88","v":15.822026058103562},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A88)-1)/12)*$C88","v":0},22.357227821289381]
["2014-08-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A89)-1)/12)*$C89","v":-1.6280487322365687},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A89)-1)/12)*$C89","v":8.9432274860617511},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A89)-1)/12)*$C89","v":16.325954418100316},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A89)-1)/12)*$C89","v":0},23.6411331719255]
["2014-09-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A90)-1)/12)*$C90","v":-1.30261946846926},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A90)-1)/12)*$C90","v":9.397775212933805},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A90)-1)/12)*$C90","v":16.829882778097076},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A90)-1)/12)*$C90","v":0},24.925038522561621]
["2014-10-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A91)-1)/12)*$C91","v":-0.97719020470195184},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A91)-1)/12)*$C91","v":9.8523229398058607},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A91)-1)/12)*$C91","v":17.333811138093836},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A91)-1)/12)*$C91","v":0},26.208943873197747]
["2014-11-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A92)-1)/12)*$C92","v":-0.65176094093464343},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A92)-1)/12)*$C92","v":10.306870666677915},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A92)-1)/12)*$C92","v":17.837739498090595},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A92)-1)/12)*$C92","v":0},27.492849223833865]
["2014-12-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$22)+SUM('3.0 LRAMVA Register'!D$24:D$25)*(MONTH($A93)-1)/12)*$C93","v":-0.32633167716733508},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$22)+SUM('3.0 LRAMVA Register'!E$24:E$25)*(MONTH($A93)-1)/12)*$C93","v":10.76141839354997},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$22)+SUM('3.0 LRAMVA Register'!F$24:F$25)*(MONTH($A93)-1)/12)*$C93","v":18.341667858087352},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A93)-1)/12)*$C93","v":0},28.776754574469987]
["2015-01-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A94)-1)/12)*$C94","v":-9.0241340002676217E-4},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A94)-1)/12)*$C94","v":11.215966120422026},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A94)-1)/12)*$C94","v":18.845596218084108},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C94","v":0},30.060659925106108]
["2015-02-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A95)-1)/12)*$C95","v":0.25279373342073685},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A95)-1)/12)*$C95","v":11.628086467630135},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A95)-1)/12)*$C95","v":19.189037086261042},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C95","v":0},31.069917287311913]
["2015-03-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A96)-1)/12)*$C96","v":0.50648988024150055},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A96)-1)/12)*$C96","v":12.040206814838248},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A96)-1)/12)*$C96","v":19.532477954437972},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C96","v":0},32.079174649517725]
["2015-04-01","Q2",{"$f":"H$29/12","v":9.1666666666666665E-4},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A97)-1)/12)*$C97","v":0.56884668691734053},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A97)-1)/12)*$C97","v":9.3180679443884316},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A97)-1)/12)*$C97","v":14.873136533929523},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C97","v":0},24.760051165235296]
["Total for rate year 2014",null,null,{"$f":"SUM(D85:D97)","v":-24.452150302543309},{"$f":"SUM(E85:E97)","v":237.28546166944841},{"$f":"SUM(F85:F97)","v":439.94333578521866},{"$f":"SUM(G85:G97)","v":0},{"$f":"SUM(H85:H97)","v":0},{"$f":"SUM(I85:I97)","v":0},{"$f":"SUM(J85:J97)","v":0},0,0,0,{"$f":"SUM(N85:N97)","v":652.77664715212381}]
[]
["Opening Balance for rate year 2015",null,null,{"$f":"D98+D99","v":-24.452150302543309},{"$f":"E98+E99","v":237.28546166944841},439.94333578521866,0,0,0,0,0,0,0,{"$f":"N98+N99","v":652.77664715212381}]
["2015-05-01","Q2",{"$f":"H$29/12","v":9.1666666666666665E-4},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A101)-1)/12)*$C101","v":0.75868734100090518},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A101)-1)/12)*$C101","v":9.6264573198502834},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A101)-1)/12)*$C101","v":15.130133101953078},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A101)-1)/12)*$C101","v":0},{"$f":"SUM(D101:M101)","v":25.515277762804267}]
["2015-06-01","Q2",{"$f":"H$29/12","v":9.1666666666666665E-4},{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A102)-1)/12)*$C102","v":0.94852799508446972},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A102)-1)/12)*$C102","v":9.9348466953121335},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A102)-1)/12)*$C102","v":15.387129669976634},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A102)-1)/12)*$C102","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A102)-1)/12)*$C102","v":0},26.270504360373238]
["2015-07-01","Q3",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A103)-1)/12)*$C103","v":1.1383686491680345},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A103)-1)/12)*$C103","v":10.243236070773987},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A103)-1)/12)*$C103","v":15.644126238000188},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A103)-1)/12)*$C103","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A103)-1)/12)*$C103","v":0},27.025730957942208]
["2015-08-01","Q3",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A104)-1)/12)*$C104","v":1.3282093032515989},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A104)-1)/12)*$C104","v":10.551625446235839},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A104)-1)/12)*$C104","v":15.901122806023745},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A104)-1)/12)*$C104","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A104)-1)/12)*$C104","v":0},27.780957555511183]
["2015-09-01","Q3",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A105)-1)/12)*$C105","v":1.5180499573351636},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A105)-1)/12)*$C105","v":10.860014821697689},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A105)-1)/12)*$C105","v":16.158119374047299},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A105)-1)/12)*$C105","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A105)-1)/12)*$C105","v":0},28.53618415308015]
["2015-10-01","Q4",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A106)-1)/12)*$C106","v":1.7078906114187282},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A106)-1)/12)*$C106","v":11.168404197159541},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A106)-1)/12)*$C106","v":16.415115942070855},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A106)-1)/12)*$C106","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A106)-1)/12)*$C106","v":0},29.291410750649124]
["2015-11-01","Q4",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A107)-1)/12)*$C107","v":1.8977312655022929},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A107)-1)/12)*$C107","v":11.476793572621395},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A107)-1)/12)*$C107","v":16.672112510094411},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A107)-1)/12)*$C107","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A107)-1)/12)*$C107","v":0},30.046637348218098]
["2015-12-01","Q4",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$25)+SUM('3.0 LRAMVA Register'!D$28:D$29)*(MONTH($A108)-1)/12)*$C108","v":2.0875719195858577},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$25)+SUM('3.0 LRAMVA Register'!E$28:E$29)*(MONTH($A108)-1)/12)*$C108","v":11.785182948083245},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$25)+SUM('3.0 LRAMVA Register'!F$28:F$29)*(MONTH($A108)-1)/12)*$C108","v":16.929109078117968},{"$f":"(SUM('3.0 LRAMVA Register'!G$12:G$22)+SUM('3.0 LRAMVA Register'!G$24:G$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$12:H$22)+SUM('3.0 LRAMVA Register'!H$24:H$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$12:I$22)+SUM('3.0 LRAMVA Register'!I$24:I$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$12:J$22)+SUM('3.0 LRAMVA Register'!J$24:J$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$12:K$22)+SUM('3.0 LRAMVA Register'!K$24:K$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!L$12:L$22)+SUM('3.0 LRAMVA Register'!L$24:L$25)*(MONTH($A108)-1)/12)*$C108","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!M$12:M$22)+SUM('3.0 LRAMVA Register'!M$24:M$25)*(MONTH($A108)-1)/12)*$C108","v":0},30.801863945787069]
["2016-01-01","Q1",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$29)*$C109)","v":2.2774125736694222},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$29)*$C109)","v":12.093572323545096},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$29)*$C109)","v":17.18610564614152},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C109","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C109","v":0},31.55709054335604]
["2016-02-01","Q1",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$29)*$C110)","v":2.2774125736694222},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$29)*$C110)","v":12.093572323545096},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$29)*$C110)","v":17.18610564614152},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C110","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C110","v":0},31.55709054335604]
["2016-03-01","Q1",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$29)*$C111)","v":2.2774125736694222},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$29)*$C111)","v":12.093572323545096},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$29)*$C111)","v":17.18610564614152},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C111","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C111","v":0},31.55709054335604]
["2016-04-01","Q2",9.1666666666666665E-4,{"$f":"(SUM('3.0 LRAMVA Register'!D$12:D$29)*$C112)","v":2.2774125736694222},{"$f":"(SUM('3.0 LRAMVA Register'!E$12:E$29)*$C112)","v":12.093572323545096},{"$f":"(SUM('3.0 LRAMVA Register'!F$12:F$29)*$C112)","v":17.18610564614152},{"$f":"SUM('3.0 LRAMVA Register'!G$12:G$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$12:H$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$12:I$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$12:J$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$12:K$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!L$12:L$25)*$C112","v":0},{"$f":"SUM('3.0 LRAMVA Register'!M$12:M$25)*$C112","v":0},31.55709054335604]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D113:M113)","v":0}]
["Opening Balance for rate year 2015",null,null,{"$f":"SUM(D100:D113)","v":-3.9574629655185714},{"$f":"SUM(E100:E113)","v":371.30631203536296},{"$f":"SUM(F100:F113)","v":636.92472709006904},{"$f":"G98+G113","v":0},0,0,0,0,0,0,{"$f":"SUM(N100:N112)","v":1004.2735761599133}]

{"sheet":"6.0 Rates","index":6,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,0,7,12]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
["Table 6 - Distribution Rates"]
[]
["Rate Class","Billing Unit",2011,2012,2013,2014,2015,"May 1, 2010\nto\nApr 30, 2011","May 1, 2011\nto\nApr 30, 2012","May 1, 2012\nto\nNovember 30, 2013","December 1, 2012\nto\nApr 30, 2013","May 1, 2013\nto\nApr 30, 2014","May 1, 2014\nto\nApr 30, 2015","May 1, 2015\nto\nApr 30, 2016"]
["For \"Calendar\" rate year",null,null,null,null,null,null,null,2011,2012,2012,2013,2014,2014]
["Pro-ratio of Rates (months) - Period 1",null,null,null,null,null,null,null,4,4,1,4,4,4]
["Pro-ratio of Rates (months) - Period 2",null,null,null,null,null,null,null,8,7,0,8,8,8]
[]
[{"$f":"'4.0 Approved Load Forecast'!D21","v":"Residential"},{"$f":"'2.0 Customer Classes'!D13","v":"kWh"},{"$f":"SUM(H15*$I$12+I15*$I$13)/12","v":1.47E-2},{"$f":"SUM(I15*$J$12+J15*$J$13+$K$12*K15)/12","v":1.4283333333333334E-2},{"$f":"SUM(K15*$L$12+L15*$L$13)/12","v":1.3966666666666667E-2},{"$f":"SUM(L15*$M$12+M15*$M$13)/12","v":1.4133333333333333E-2},{"$f":"SUM(M15*$M$12+N15*$M$13)/12","v":1.4333333333333332E-2},1.47E-2,1.47E-2,1.41E-2,1.3899999999999999E-2,1.4E-2,1.4200000000000001E-2,1.44E-2]
[{"$f":"'4.0 Approved Load Forecast'!E21","v":"General Service < 50 kW"},{"$f":"'2.0 Customer Classes'!D14","v":"kWh"},{"$f":"SUM(H16*$I$12+I16*$I$13)/12","v":1.38E-2},{"$f":"SUM(I16*$J$12+J16*$J$13+$K$12*K16)/12","v":1.34E-2},{"$f":"SUM(K16*$L$12+L16*$L$13)/12","v":1.3266666666666668E-2},{"$f":"SUM(L16*$M$12+M16*$M$13)/12","v":1.3433333333333334E-2},1.3633333333333332E-2,1.38E-2,1.38E-2,1.32E-2,1.32E-2,1.3299999999999999E-2,1.35E-2,1.37E-2]
[{"$f":"'4.0 Approved Load Forecast'!F21","v":"General Service > 50 to 4999 kW"},{"$f":"'2.0 Customer Classes'!D15","v":"kW"},4.7456333333333331,{"$f":"SUM(I17*$J$12+J17*$J$13+$K$12*K17)/12","v":4.6079333333333334},4.5528333333333331,4.611766666666667,4.6870666666666665,4.7424999999999997,4.7472000000000003,4.5382999999999996,4.5382999999999996,4.5601000000000003,4.6375999999999999,4.7118000000000002]
[{"$f":"'4.0 Approved Load Forecast'!G21","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'2.0 Customer Classes'!D16","v":"kW"},0,0,0,0,0]
[{"$f":"'4.0 Approved Load Forecast'!H21","v":"Unmetered Scattered Load"},{"$f":"'2.0 Customer Classes'!D17","v":"kWh"},1.38E-2,1.2933333333333333E-2,7.6E-3,7.6666666666666662E-3,7.7666666666666674E-3,1.38E-2,1.38E-2,1.32E-2,7.6E-3,7.6E-3,7.7000000000000002E-3,7.7999999999999996E-3]
[{"$f":"'4.0 Approved Load Forecast'!I21","v":"Sentinel Lighting"},{"$f":"'2.0 Customer Classes'!D18","v":"kW"},0,0,0,0,0]
[{"$f":"'4.0 Approved Load Forecast'!J21","v":"Street Lighting "},{"$f":"'2.0 Customer Classes'!D19","v":"kW"},0.14356666666666665,0.19856666666666667,0.85003333333333331,0.86106666666666676,0.87516666666666676,0.14349999999999999,0.14360000000000001,0.13730000000000001,0.84730000000000005,0.85140000000000005,0.8659,0.87980000000000003]
[{"$f":"'4.0 Approved Load Forecast'!K21","v":"other"},{"$f":"'2.0 Customer Classes'!D20","v":0}]
[{"$f":"'4.0 Approved Load Forecast'!L21","v":"other"},{"$f":"'2.0 Customer Classes'!D21","v":0}]
[{"$f":"'4.0 Approved Load Forecast'!M21","v":"other"},{"$f":"'2.0 Customer Classes'!D22","v":0},{"$f":"IF((H24*4+I24*8)/12=0,\" \",(H24*4+I24*8)/12)","v":" "},{"$f":"IF((I24*4+K24*8)/12=0,\" \",(I24*4+K24*8)/12)","v":" "},{"$f":"IF((K24*4+L24*8)/12=0,\" \",(K24*4+L24*8)/12)","v":" "},{"$f":"IF((L24*4+M24*8)/12=0,\" \",(L24*4+M24*8)/12)","v":" "}]
[]
["References:"]
["Decision & Orders relating to rates:",null,null,null,null,null,null,"EB-2009-0209","EB-2010-0143","EB-2011-0103","EB-2011-0103","EB-2012-0171","EB-2013-0175","EB-2014-0118"]

{"sheet":"7.0 2011LostRev","index":7,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,5,9,13],[49,1,49,2],[50,1,50,2],[9,1,10,1],[11,1,11,2],[22,1,22,2],[5,1,5,13],[51,1,51,2],[44,1,44,2],[46,1,46,2],[36,1,36,2],[38,1,38,2],[43,1,43,2],[47,1,47,2],[48,1,48,2],[45,1,45,2],[30,1,30,2]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,"Table 7: Allocation of Program Savings Across Rate Classes"]
[null,null,null,null,null,null,2011]
[]
[]
["#","Initiative","Results Status","Net Incremental Peak Demand Savings (kW) ","Net Incremental Energy Savings (kWh)\n","Rate Allocation for LRAMVA"]
[null,null,null,"2011 kW Saved","2011 kWh Saved",{"$f":"'3.0 LRAMVA Register'!D11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!M11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",5.36,39547.269999999997,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",0.85,1075.616,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",28.85,{"$f":"53127.539-8027","v":45100.538999999997},1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",2.1269999999999998,{"$f":"34491.336+496","v":34987.336000000003},1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",3.0249999999999999,{"$f":"52875.173+3928","v":56803.173000000003},1,null,null,null,null,null,null,null,1]
[]
[]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"Business Program"]
[9,"Retrofit","Verified",0,56159.125999999997,null,1,0,null,null,null,null,null,{"$f":"SUM(F24:M24)","v":1}]
[10,"Direct Install Lighting","Verified",18.193999999999999,51686.572,null,1,null,null,null,null,null,null,1]
[11,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[12,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"Energy Audit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Commercial Demand Response (part of residential program)","Verified",null,null,null,null,null,null,null,null,null,null,0]
[15,"Demand Response 3","Verified",67.504000000000005,2635.5509999999999,null,null,1,null,null,null,null,null,1]
[null,"Industrial Program"]
[16,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F32:M32)","v":0}]
[17,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[18,"Energy Manager","Verified",null,null,null,null,null,null,null,null,null,null,0]
[19,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[21,"Home Assistance Program","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F38:M38)","v":1}]
[null,"Pre-2011 Programs completed in 2011"]
[22,"Electricity Retrofit Incentive Program","Verified",1,{"$f":"1838.017+29113","v":30951.017},null,null,1,null,null,null,null,null,{"$f":"SUM(F40:M40)","v":1}]
[23,"High Performance New Construction","Verified",2.8000000000000001E-2,141.624,null,null,1,null,null,null,null,null,1]
[24,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[25,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D22,D24:D29,D32:D35,D38,D40:D43)","v":59.434000000000005},{"$f":"SUM(E13:E22,E24:E29,E32:E35,E38,E40:E43)","v":316452.27299999999},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E20*F20,E21*F21,E22*F22,E38*F38)","v":177513.93400000001},{"$f":"SUM(E24*G24,E25*G25)","v":107845.698},{"$f":"SUM($E$24*H24,$E$40*H40,$E$41*H41)","v":31092.641},{"$f":"SUM($E$24*I24,$E$40*I40,$E$41*I41)","v":0},{"$f":"SUM($E$24*J24,$E$40*J40,$E$41*J41)","v":0},0,0,null,{"$f":"SUM(F44:M44)","v":316452.27299999999}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM($D$24*H24,$D$40*H40,$D$41*H41)*$A45","v":12.336},{"$f":"SUM($D$24*I24,$D$40*I40,$D$41*I41)*$A45","v":0},0,0,0,null,{"$f":"SUM(F45:M45)","v":12.336}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D30,D36)","v":67.504000000000005},{"$f":"SUM(E30,E36)","v":2635.5509999999999},null,null,{"$f":"SUM($D$30*H30,$D$36*H36)*$A46","v":337.52000000000004},{"$f":"SUM($D$30*I30,$D$36*I36)*$A46","v":0},0,0,0,null,{"$f":"SUM(F46:M46)","v":337.52000000000004}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D44:D46)","v":126.93800000000002},{"$f":"SUM(E44:E46)","v":319087.82399999996}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!C15","v":1.47E-2},{"$f":"'6.0 Rates'!C16","v":1.38E-2},{"$f":"'6.0 Rates'!C17","v":4.7456333333333331},{"$f":"'6.0 Rates'!C18","v":0},{"$f":"'6.0 Rates'!C19","v":1.38E-2},{"$f":"'6.0 Rates'!C20","v":0},{"$f":"'6.0 Rates'!C21","v":0.14356666666666665}]
[null,"Lost Revenue in 2011",null,null,null,{"$f":"F44*F48","v":2609.4548298},{"$f":"G44*G48","v":1488.2706324000001},{"$f":"SUM(H45,H46)*H48","v":1660.2882954666668},{"$f":"I45*I48","v":0},0,0,0,null,{"$f":"SUM(F49:M49)","v":5758.0137576666666}]
[null,"2011 Savings Persisting in 2012",null,null,null,{"$f":"F44*'12.0 Persistence '!C44","v":175702.56732653061},{"$f":"G44*'12.0 Persistence '!C44","v":106745.23169387755},{"$f":"H45*'12.0 Persistence '!C25","v":12.210122448979591},{"$f":"I45*'12.0 Persistence '!C25","v":0},{"$f":"J45*'12.0 Persistence '!C25","v":0},{"$f":"K45*'12.0 Persistence '!C25","v":0},{"$f":"L45*'12.0 Persistence '!C44","v":0}]
[null,"2011 Savings Persisting in 2013",null,null,null,{"$f":"F44*'12.0 Persistence '!D44","v":175702.56732653061},{"$f":"G44*'12.0 Persistence '!D44","v":106745.23169387755},{"$f":"H45*'12.0 Persistence '!D25","v":12.210122448979591},{"$f":"I45*'12.0 Persistence '!D25","v":0},{"$f":"J45*'12.0 Persistence '!D25","v":0},{"$f":"K45*'12.0 Persistence '!D25","v":0},{"$f":"L45*'12.0 Persistence '!D44","v":0}]
[null,"2011 Savings Persisting in 2014",null,null,null,{"$f":"F44*'12.0 Persistence '!E44","v":157588.90059183675},{"$f":"G44*'12.0 Persistence '!E44","v":95740.56863265307},{"$f":"H45*'12.0 Persistence '!E25","v":10.951346938775512},{"$f":"I45*'12.0 Persistence '!E25","v":0},{"$f":"J45*'12.0 Persistence '!E25","v":0},{"$f":"K45*'12.0 Persistence '!E25","v":0},{"$f":"L45*'12.0 Persistence '!E44","v":0}]
[]
[null,"Input program details, report status, kWh and kW net savings from OPA 2011 Final Annual Report Data - Table 5"]
[null,"Input % allocation where applicable based on LDC information"]
[]
[null,"2011 savings persisting - OPA 2011 Final Annual Report Data - Tables 6 and 7"]

{"sheet":"8.0 2012LostRev","index":8,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,1,10,1],[9,5,9,13],[11,1,11,2],[25,1,25,2],[21,1,21,2],[5,1,5,13],[63,1,63,2],[64,1,64,2],[60,1,60,2],[56,1,56,2],[55,1,55,2],[59,1,59,2],[61,1,61,2],[57,1,57,2],[58,1,58,2],[36,1,36,2],[52,1,52,2],[42,1,42,2],[44,1,44,2],[34,1,34,2],[50,1,50,2]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,"Table 8: Allocation of Program Savings Across Rate Classes"]
[null,null,null,null,null,null,2012]
[]
[]
["#","Initiative","Results Status","Net Incremental Peak Demand Savings (kW) ","Net Incremental Energy Savings (kWh)\n","Rate Allocation for LRAMVA"]
[null,null,null,"2012 kW Saved","2012 kWh Saved",{"$f":"'3.0 LRAMVA Register'!D11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!M11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",2.0640000000000001,15566.909,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",0.1,174.495,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",20.143999999999998,{"$f":"35480.533+2342","v":37822.533000000003},1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",0.41499999999999998,2515.7040000000002,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",2.6629999999999998,48186.718000000001,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F20:M20)","v":1}]
[9,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["3a","HVAC Incentives","True-Up",null,null,1,null,null,null,null,null,null,null,1]
["4a","Conservation Instant Coupon Booklet","True-Up",null,null,1,null,null,null,null,null,null,null,1]
["5a","Bi-Annual Retailer Event","True-Up",null,null,1,null,null,null,null,null,null,null,1]
[null,"Business Program"]
[10,"Retrofit","Verified",70.644999999999996,395203.30599999998,null,0,1,null,null,null,null,null,{"$f":"SUM(F27:M27)","v":1}]
[11,"Direct Install Lighting","Verified",24.451000000000001,102205.413,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F32:M32)","v":0}]
[16,"Small Commercial Demand Response (IHD)","Verified",null,null,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["11a","Direct Install Lighting","True-Up",null,null,null,1,null,null,null,null,null,null,1]
[null,"Industrial Program"]
[18,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F38:M38)","v":0}]
[19,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Energy Manager","Verified",null,null,null,null,null,null,null,null,null,null,0]
[21,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[22,"Demand Response 3","Verified",67.703000000000003,984.08199999999999,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",1,14418,1,null,null,null,null,null,null,null,{"$f":"SUM(F44:M44)","v":1}]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F46:M46)","v":1}]
[25,"High Performance New Construction","Verified",null,197,null,null,1,null,null,null,null,null,1]
[26,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[27,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[28,"LDC Custom Programs","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"2011 True-up (Verified Errors & Omissions)"]
["22a","High Performance New Construction","True-Up",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":1}]
[null,"Other"]
[29,"Program Enabled Savings","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F54:M54)","v":0}]
[30,"Time-of-Use Savings","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D25,D27:D33,D35:D36,D38:D41,D44,D46:D52,D54:D55)","v":121.482},{"$f":"SUM(E13:E25,E27:E33,E35:E36,E38:E41,E44,E46:E52,E54:E55)","v":616290.07799999998},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E23*F23,E24*F24,E25*F25,E44*F44)","v":118684.359},{"$f":"SUM(E27*G27,E28*G28,E36*G36)","v":102205.413},{"$f":"SUM($E$27*H27,$E$46*H46,$E$47*H47,$E$52*H52)","v":395400.30599999998},{"$f":"SUM($E$27*I27,$E$46*I46,$E$47*I47,$E$52*I52)","v":0},{"$f":"SUM($E$27*J27,$E$46*J46,$E$47*J47,$E$52*J52)","v":0},{"$f":"SUM($E$27*K27,$E$46*K46,$E$47*K47,$E$52*K52)","v":0},{"$f":"SUM($E$27*L27,$E$46*L46,$E$47*L47,$E$52*L52)","v":0},null,{"$f":"SUM(F56:M56)","v":616290.07799999998}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM($D$27*H27,$D$46*H46,$D$47*H47,$D$52*H52)*$A$57","v":847.74},{"$f":"SUM($D$27*I27,$D$46*I46,$D$47*I47,$D$52*I52)*$A$57","v":0},{"$f":"SUM($D$27*J27,$D$46*J46,$D$47*J47,$D$52*J52)*$A$57","v":0},0,0,null,{"$f":"SUM(F57:M57)","v":847.74}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D42)","v":67.703000000000003},{"$f":"SUM(E34,E42)","v":984.08199999999999},null,null,{"$f":"SUM($D$34*H34,$D$42*H42)*$A$58","v":338.51499999999999},{"$f":"SUM($D$34*I34,$D$42*I42)*$A$58","v":0},0,0,0,null,{"$f":"SUM(F58:M58)","v":338.51499999999999}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D56:D58)","v":189.185},{"$f":"SUM(E56:E58)","v":617274.16}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!D15","v":1.4283333333333334E-2},{"$f":"'6.0 Rates'!D16","v":1.34E-2},{"$f":"'6.0 Rates'!D17","v":4.6079333333333334},{"$f":"'6.0 Rates'!D18","v":0},{"$f":"'6.0 Rates'!D19","v":1.2933333333333333E-2},{"$f":"'6.0 Rates'!D20","v":0},{"$f":"'6.0 Rates'!D21","v":0.19856666666666667}]
[null,"Lost Revenue in 2012 from 2012",null,null,null,{"$f":"F56*F60","v":1695.2082610499999},{"$f":"G56*G60","v":1369.5525342000001},{"$f":"SUM(H57,H58)*H60","v":5466.1839563333342},{"$f":"SUM(I57,I58)*I60","v":0},{"$f":"J57*J60","v":0},0,0,null,{"$f":"SUM(F61:M61)","v":8530.9447515833344}]
[null,"Lost Revenue in 2012 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F50*F60","v":2509.6183366472787},{"$f":"'7.0 2011LostRev'!G50*G60","v":1430.3861046979591},{"$f":"'7.0 2011LostRev'!H50*H60","v":56.263430236734692},{"$f":"'7.0 2011LostRev'!I50*I60","v":0},{"$f":"'7.0 2011LostRev'!J50*J60","v":0},{"$f":"'7.0 2011LostRev'!K50*K60","v":0},{"$f":"'7.0 2011LostRev'!L50*L60","v":0},null,{"$f":"SUM(F62:M62)","v":3996.2678715819725}]
[null,"Total Lost Revenue in 2012",null,null,null,{"$f":"SUM(F61:F62)","v":4204.8265976972789},{"$f":"SUM(G61:G62)","v":2799.9386388979592},5522.4473865700693,0,0,0,0,null,{"$f":"SUM(N61:N62)","v":12527.212623165307}]
[null,"2012 Savings Persisting in 2013",null,null,null,{"$f":"F56*'12.0 Persistence '!D45","v":118494.76737220447},{"$f":"G56*'12.0 Persistence '!D45","v":102042.14556709265},{"$f":"H57*'12.0 Persistence '!D26","v":846.38578274760391},{"$f":"I57*'12.0 Persistence '!D26","v":0},{"$f":"J57*'12.0 Persistence '!D26","v":0},{"$f":"K57*'12.0 Persistence '!D26","v":0},{"$f":"L57*'12.0 Persistence '!D45","v":0}]
[null,"2012 Savings Persisting in 2014",null,null,null,{"$f":"F56*'12.0 Persistence '!E45","v":118494.76737220447},{"$f":"G56*'12.0 Persistence '!E45","v":102042.14556709265},{"$f":"H57*'12.0 Persistence '!E26","v":846.38578274760391},{"$f":"I57*'12.0 Persistence '!E26","v":0},{"$f":"J57*'12.0 Persistence '!E26","v":0},{"$f":"K57*'12.0 Persistence '!E26","v":0},{"$f":"L57*'12.0 Persistence '!E45","v":0}]
[]
[null,"Input program details, report status, kWh and kW net savings from Final Verified Annual 2012 CDM Report_Orillia Power Distribution Corporation/Table 1 2012 Savings & Table 2 (Adjustments due to Errors and Omissions)"]
[null,"Input % allocation where applicable based on LDC information"]
[]
[null,"2012 savings persisting - OPA 2012 Gross to Net Savings Report Data "]

{"sheet":"9.0 2013LostRev","index":9,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[70,1,70,2],[67,1,67,2],[66,1,66,2],[61,1,61,2],[62,1,62,2],[65,1,65,2],[68,1,68,2],[63,1,63,2],[64,1,64,2],[50,1,50,2],[5,0,5,13],[38,1,38,2],[58,1,58,2],[9,0,10,0],[9,1,10,1],[9,5,9,13],[11,1,11,2],[25,1,25,2],[46,1,46,2],[21,1,21,2],[34,1,34,2],[44,1,44,2],[48,1,48,2],[56,1,56,2]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
["Table 10: Allocation of Program Savings Across Rate Classes"]
[null,null,null,null,null,null,2013]
[]
[]
["#","Initiative","Results Status","Net Incremental Peak Demand Savings (kW) ","Net Incremental Energy Savings (kWh)\n","Rate Allocation for LRAMVA"]
[null,null,null,"2013 kW Saved","2013 kWh Saved",{"$f":"'3.0 LRAMVA Register'!D11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!M11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",{"$f":"0.00149*1000","v":1.49},{"$f":"10.42293*1000","v":10422.929999999998},1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",{"$f":"0.00104*1000","v":1.0399999999999998},{"$f":"1.8472*1000","v":1847.2},1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",{"$f":"0.03057*1000","v":30.57},{"$f":"53319+3768","v":57087},1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",{"$f":"0.00093*1000","v":0.93},{"$f":"13868+42","v":13910},1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",{"$f":"0.00213*1000","v":2.13},{"$f":"30.91069*1000","v":30910.69},1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[9,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,null,"True-up"]
[null,null,"True-up"]
[null,"Business Program"]
[10,"Retrofit","Verified",{"$f":"0.01257*1000","v":12.57},{"$f":"77.70189*1000","v":77701.89},null,0.33,0.67,null,null,null,null,null,{"$f":"SUM(F27:M27)","v":1}]
[11,"Direct Install Lighting","Verified",{"$f":"0.00625*1000","v":6.25},28036,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",null,null,null,null,null,null,null,null,null,null,0]
[16,"Small Commercial Demand Response (IHD)","Verified",null,null,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",{"$f":"0.06866*1000","v":68.66},{"$f":"0.91683*1000","v":916.83},null,null,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,null,"True-up"]
[null,null,"True-up"]
[null,"Industrial Program"]
[18,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F40:M40)","v":0}]
[19,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Energy Manager","Verified",null,null,null,null,null,null,null,null,null,null,0]
[21,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[22,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",{"$f":"0.00143*1000","v":1.4300000000000002},{"$f":"6.68173*1000","v":6681.73},1,null,null,null,null,null,null,null,{"$f":"SUM(F48:M48)","v":1}]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":1}]
[25,"High Performance New Construction","Verified",null,null,null,null,1,null,null,null,null,null,1]
[26,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[27,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[28,"LDC Custom Programs","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Other"]
[29,"Program Enabled Savings","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F60:M60)","v":0}]
[30,"Time-of-Use Savings","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D21,D27:D33,D40:D43,D48,D52:D56,D60:D61)","v":56.410000000000004},{"$f":"SUM(E13:E21,E27:E33,E40:E43,E48,E52:E56,E60:E61)","v":226597.44000000003},{"$f":"SUM($E$13*F13,$E$14*F14,$E$15*F15,$E$16*F16,$E$17*F17,$E$18*F18,$E$19*F19,$E$21*F21,$E$48*F48,$E$23*F23,$E$24*F24,$E$25*F25,$E$50*F50)","v":120859.55},{"$f":"SUM($E$27*G27,$E$28*G28,$E$29*G29,$E$30*G30,$E$31*G31,$E$36*G36,$E$37*G37,$E$38*G38)","v":53677.623699999996},{"$f":"SUM($E$27*H27,$E$34*H34,$E$44*H44,$E$52*H52,$E$53*H53,$E$28*H28,$E$29*H29,$E$30*H30,$E$31*H31,$E$36*H36,$E$37*H37,$E$38*H38,$E$46*H46,$E$58*H58)","v":52977.096300000005},{"$f":"SUM($E$27*I27,$E$34*I34,$E$44*I44,$E$52*I52,$E$53*I53,$E$28*I28,$E$29*I29,$E$30*I30,$E$31*I31,$E$36*I36,$E$37*I37,$E$38*I38,$E$46*I46,$E$58*I58)","v":0},{"$f":"SUM($E$27*J27,$E$34*J34,$E$44*J44,$E$52*J52,$E$53*J53,$E$28*J28,$E$29*J29,$E$30*J30,$E$31*J31,$E$36*J36,$E$37*J37,$E$38*J38,$E$46*J46,$E$58*J58)","v":0},{"$f":"SUM($E$27*K27,$E$34*K34,$E$44*K44,$E$52*K52,$E$53*K53,$E$28*K28,$E$29*K29,$E$30*K30,$E$31*K31,$E$36*K36,$E$37*K37,$E$38*K38,$E$46*K46,$E$58*K58)","v":0},{"$f":"SUM($E$27*L27,$E$34*L34,$E$44*L44,$E$52*L52,$E$53*L53,$E$28*L28,$E$29*L29,$E$30*L30,$E$31*L31,$E$36*L36,$E$37*L37,$E$38*L38,$E$46*L46,$E$58*L58)","v":0},null,{"$f":"SUM(F62:M62)","v":227514.27}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM($D$27*H27,$D$52*H52,$D$53*H53)*$A63","v":101.06280000000001},{"$f":"SUM($D$27*I27,$D$52*I52,$D$53*I53)*$A63","v":0},{"$f":"SUM($D$27*J27,$D$52*J52,$D$53*J53)*$A63","v":0},{"$f":"SUM($D$27*K27,$D$52*K52,$D$53*K53)*$A63","v":0},{"$f":"SUM($D$27*L27,$D$52*L52,$D$53*L53)*$A63","v":0},null,{"$f":"SUM(F63:M63)","v":101.06280000000001}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D44)","v":68.66},{"$f":"SUM(E34,E44)","v":916.83},null,null,{"$f":"SUM($D$34*H34,$D$44*H44)*$A64","v":343.29999999999995},{"$f":"SUM($D$34*I34,$D$44*I44)*$A64","v":0},{"$f":"SUM($D$34*J34,$D$44*J44)*$A64","v":0},{"$f":"SUM($D$34*K34,$D$44*K44)*$A64","v":0},{"$f":"SUM($D$34*L34,$D$44*L44)*$A64","v":0},null,{"$f":"SUM(F64:M64)","v":343.29999999999995}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D62:D64)","v":125.07},{"$f":"SUM(E62:E64)","v":227514.27000000002}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!E15","v":1.3966666666666667E-2},{"$f":"'6.0 Rates'!E16","v":1.3266666666666668E-2},{"$f":"'6.0 Rates'!E17","v":4.5528333333333331},{"$f":"'6.0 Rates'!E18","v":0},{"$f":"'6.0 Rates'!E19","v":7.6E-3},{"$f":"'6.0 Rates'!E20","v":0},{"$f":"'6.0 Rates'!E21","v":0.85003333333333331}]
[null,"Lost Revenue in 2013 from 2013",null,null,null,{"$f":"F62*F66","v":1688.0050483333334},{"$f":"G62*G66","v":712.12314108666669},{"$f":"SUM(H63,H64)*H66","v":2023.1097679333332},{"$f":"SUM(I63,I64)*I66","v":0},{"$f":"J63*J66","v":0},0,0,null,{"$f":"SUM(F67:M67)","v":4423.2379573533335}]
[null,"Lost Revenue in 2013 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F64*F66","v":1654.9769176317891},{"$f":"'8.0 2012LostRev'!G64*G66","v":1353.759131190096},{"$f":"'8.0 2012LostRev'!H64*H66","v":3853.4534045527157},{"$f":"'8.0 2012LostRev'!I64*I66","v":0},{"$f":"'8.0 2012LostRev'!J64*J66","v":0},{"$f":"'8.0 2012LostRev'!K64*K66","v":0},{"$f":"'8.0 2012LostRev'!L64*L66","v":0},null,{"$f":"SUM(F68:M68)","v":6862.1894533746008}]
[null,"Lost Revenue in 2013 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F51*F66","v":2453.9791903272107},{"$f":"'7.0 2011LostRev'!G51*G66","v":1416.1534071387755},{"$f":"'7.0 2011LostRev'!H51*H66","v":55.590652489795914},{"$f":"'7.0 2011LostRev'!I51*I66","v":0},{"$f":"'7.0 2011LostRev'!J51*J66","v":0},{"$f":"'7.0 2011LostRev'!K51*K66","v":0},{"$f":"'7.0 2011LostRev'!L51*L66","v":0},null,3925.7232499557822]
[null,"Total Lost Revenue in 2013",null,null,null,{"$f":"SUM(F67:F69)","v":5796.9611562923328},{"$f":"SUM(G67:G69)","v":3482.0356794155382},5932.1538249758441,0,0,0,0,null,{"$f":"SUM(N67:N69)","v":15211.150660683717}]
[null,"2013 Savings Persisting in 2014",null,null,null,{"$f":"F62*'12.0 Persistence '!E46","v":120324.7732300885},{"$f":"G62*'12.0 Persistence '!E46","v":53440.11209070796},{"$f":"H63*'12.0 Persistence '!E27","v":100.61561946902656},{"$f":"I63*'12.0 Persistence '!E27","v":0},{"$f":"J63*'12.0 Persistence '!E27","v":0},{"$f":"K63*'12.0 Persistence '!E27","v":0},{"$f":"L63*'12.0 Persistence '!E46","v":0}]
[]
[null,"Input program details, report status, kWh and kW net savings from OPA Final Annual Report"]
[null,"Input % allocation where applicable based on LDC information"]
[]
[null,"2013 savings persisting - "]

{"sheet":"10.0 2014LostRev","index":10,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[55,1,55,2],[49,1,49,2],[50,1,50,2],[54,1,54,2],[52,1,52,2],[5,0,5,13],[47,1,47,2],[48,1,48,2],[51,1,51,2],[53,1,53,2],[30,1,30,2],[44,1,44,2],[9,0,10,0],[9,1,10,1],[9,5,9,13],[11,1,11,2],[21,1,21,2],[36,1,36,2],[38,1,38,2]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
["Table 11: Allocation of Program Savings Across Rate Classes"]
[null,null,null,null,null,null,2014]
[]
[]
["#","Initiative","Results Status","Net Incremental Peak Demand Savings (kW) ","Net Incremental Energy Savings (kWh)\n","Rate Allocation for LRAMVA"]
[null,null,null,"2014 kW Saved","2014 kWh Saved",{"$f":"'3.0 LRAMVA Register'!D11","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!E11","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!F11","v":"General Service > 50 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!G11","v":"Standy Power - Approved on an Interim Basis"},{"$f":"'3.0 LRAMVA Register'!H11","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!I11","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!J11","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!M11","v":"other"},{"$f":"'3.0 LRAMVA Register'!N11","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",null,3565,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",null,5542,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",null,85574,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",null,71252,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",null,221132,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[9,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"Business Program"]
[10,"Retrofit","Verified",16,165138,null,0.2,0.8,null,null,null,null,null,{"$f":"SUM(F23:M23)","v":1}]
[11,"Direct Install Lighting","Verified",40,162232,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",null,65274,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",null,null,null,null,null,null,null,null,null,null,0]
[16,"Small Commercial Demand Response (IHD)","Verified",null,null,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"Industrial Program"]
[18,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F32:M32)","v":0}]
[19,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Energy Manager","Verified",null,null,null,null,null,null,null,null,null,null,0]
[21,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[22,"Demand Response 3","Verified",50,0,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",null,1371,1,null,null,null,null,null,null,null,{"$f":"SUM(F38:M38)","v":1}]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F40:M40)","v":1}]
[25,"High Performance New Construction","Verified",null,null,null,null,1,null,null,null,null,null,1]
[26,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[27,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[28,"LDC Custom Programs","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Other"]
[29,"Program Enabled Savings","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F46:M46)","v":0}]
[30,"Time-of-Use Savings","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D21,D23:D29,D32:D35,D38,D40:D44,D46:D47)","v":56},{"$f":"SUM(E13:E21,E23:E29,E32:E35,E38,E40:E44,E46:E47)","v":781080},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E38*F38)","v":388436},{"$f":"SUM(E23*G23,E24*G24)","v":195259.6},{"$f":"SUM(E23*H23,E30*H30,E36*H36,E40*H40,E41*H41)","v":132110.39999999999},null,null,null,null,null,{"$f":"SUM(F48:M48)","v":715806}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM(D23*H23,D40*H40,D41*H41)*$A49","v":153.60000000000002},null,null,null,null,null,{"$f":"SUM(F49:M49)","v":153.60000000000002}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D30,D36)","v":50},{"$f":"SUM(E30,E36)","v":0},null,null,{"$f":"SUM(D30*H30,D36*H36)*$A50","v":250},null,null,null,null,null,{"$f":"SUM(F50:M50)","v":250}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D48:D50)","v":106},{"$f":"SUM(E48:E50)","v":781080}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!F15","v":1.4133333333333333E-2},{"$f":"'6.0 Rates'!F16","v":1.3433333333333334E-2},{"$f":"'6.0 Rates'!F17","v":4.611766666666667},{"$f":"'6.0 Rates'!F18","v":0},{"$f":"'6.0 Rates'!F19","v":7.6666666666666662E-3},{"$f":"'6.0 Rates'!F20","v":0},{"$f":"'6.0 Rates'!F21","v":0.86106666666666676}]
[null,"Lost Revenue in 2014 from 2014",null,null,null,{"$f":"F48*F52","v":5489.8954666666668},{"$f":"G48*G52","v":2622.9872933333336},{"$f":"SUM(H49,H50)*H52","v":1861.309026666667},{"$f":"SUM(I49,I50)*I52","v":0},{"$f":"J49*J52","v":0},0,0,null,{"$f":"SUM(F53:M53)","v":9974.1917866666681}]
[null,"Lost Revenue in 2014 from 2013",null,null,null,{"$f":"'9.0 2013LostRev'!F71*F52","v":1700.590128318584},{"$f":"'9.0 2013LostRev'!G71*G52","v":717.87883908517699},{"$f":"'9.0 2013LostRev'!H71*H52","v":464.01576001327442},{"$f":"'9.0 2013LostRev'!I71*I52","v":0},{"$f":"'9.0 2013LostRev'!J71*J52","v":0},{"$f":"'9.0 2013LostRev'!K71*K52","v":0},{"$f":"'9.0 2013LostRev'!L71*L52","v":0},null,{"$f":"SUM(F54:M54)","v":2882.4847274170352}]
[null,"Lost Revenue in 2014 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F65*F52","v":1674.7260455271564},{"$f":"'8.0 2012LostRev'!G65*G52","v":1370.7661554512779},{"$f":"'8.0 2012LostRev'!H65*H52","v":3903.3337400159753},{"$f":"'8.0 2012LostRev'!I65*I52","v":0},{"$f":"'8.0 2012LostRev'!J65*J52","v":0},{"$f":"'8.0 2012LostRev'!K65*K52","v":0},{"$f":"'8.0 2012LostRev'!L65*L52","v":0},null,{"$f":"SUM(F55:M55)","v":6948.8259409944094}]
[null,"Lost Revenue in 2014 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F52*F52","v":2227.2564616979594},{"$f":"'7.0 2011LostRev'!G52*G52","v":1286.1149719653063},{"$f":"'7.0 2011LostRev'!H52*H52","v":50.50505676734695},{"$f":"'7.0 2011LostRev'!I52*I52","v":0},{"$f":"'7.0 2011LostRev'!J52*J52","v":0},{"$f":"'7.0 2011LostRev'!K52*K52","v":0},{"$f":"'7.0 2011LostRev'!L52*L52","v":0},null,3563.8764904306126]
[null,"Total Lost Revenue in 2014",null,null,null,{"$f":"SUM(F53:F56)","v":11092.468102210367},{"$f":"SUM(G53:G56)","v":5997.7472598350942},6279.1635834632643,0,0,0,0,null,{"$f":"SUM(N53:N56)","v":23369.378945508724}]
[]
[null,"Input program details, report status, kWh and kW net savings from OPA Final Annual Report"]
[null,"Input % allocation where applicable based on LDC information"]

{"sheet":"11.0 2015 Lost Revenue","index":11,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,13]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
["Table 12: 2015 Persistence Savings from 2011-2014 CDM Programs"]
[]
[]
[null,null,null,null,"Residential","GS<50 kW","GS>50 kW"]
[null,null,null,"Rates ($)",{"$f":"'6.0 Rates'!G15","v":1.4333333333333332E-2},{"$f":"'6.0 Rates'!G16","v":1.3633333333333332E-2},{"$f":"'6.0 Rates'!G17","v":4.6870666666666665}]
[null,null,null,null,"(kWh)","(kWh)","(kW)"]
[null,null,null,"Lost Revenue in 2015 from 2014",{"$f":"'10.0 2014LostRev'!F48*'12.0 Persistence '!F47","v":388436},{"$f":"'10.0 2014LostRev'!G48*'12.0 Persistence '!F47","v":195259.6},{"$f":"'10.0 2014LostRev'!H49*'12.0 Persistence '!F28","v":153.60000000000002}]
[null,null,null,"Lost Revenue in 2015 from 2013",{"$f":"'9.0 2013LostRev'!F62*'12.0 Persistence '!F46","v":120859.55},{"$f":"'9.0 2013LostRev'!G62*'12.0 Persistence '!F46","v":53677.623699999996},{"$f":"'9.0 2013LostRev'!H63*'12.0 Persistence '!F27","v":101.06280000000001}]
[null,null,null,"Lost Revenue in 2015 from 2012",{"$f":"'8.0 2012LostRev'!F56*'12.0 Persistence '!F45","v":104442.23591999999},{"$f":"'8.0 2012LostRev'!G56*'12.0 Persistence '!F45","v":89940.763439999995},{"$f":"'8.0 2012LostRev'!H57*'12.0 Persistence '!F26","v":746.01120000000003}]
[null,null,null,"Lost Revenue in 2015 from 2011",{"$f":"'7.0 2011LostRev'!F44*'12.0 Persistence '!F44","v":118934.33578000001},{"$f":"'7.0 2011LostRev'!G44*'12.0 Persistence '!F44","v":72256.617660000004},{"$f":"'7.0 2011LostRev'!H45*'12.0 Persistence '!F25","v":8.2651200000000014}]
[null,null,null,"Total kWh/kW",{"$f":"SUM(E12:E15)","v":732672.1216999999},{"$f":"SUM(F12:F15)","v":411134.60479999997},1008.9391200000001]
[null,null,null,"Total Lost Revenue in 2015",{"$f":"E16*E10","v":10501.633744366663},{"$f":"F16*F10","v":5605.1351121066655},4728.9649180480001]

{"sheet":"12.0 Persistence ","index":12,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[41,0,41,5],[22,0,22,5],[21,0,21,5],[38,0,38,4],[39,0,39,4],[29,0,29,5],[31,0,32,0],[31,1,31,4],[37,0,37,4],[30,0,30,5],[8,0,8,5],[12,0,13,0],[12,1,12,4],[18,0,18,3],[9,0,9,5],[11,5,20,5],[11,0,11,4],[19,0,19,3],[20,0,20,3],[10,0,10,4]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
["Progress Towards CDM Targets"]
["Results are attributed to target using current OPA reporting policies. Energy efficiency resources persist for the duration of the effective useful life. Any upcoming code changes are taken into account. Demand response resources persist for 1 year. Please see methodology tab for more detailed information. "]
["Table 12: Net Peak Demand Savings at the End User Level (MW)"]
[]
["Implementation Period","Annual"]
[null,2011,2012,2013,2014]
["2011 - Verified",0.126,5.8999999999999997E-2,5.8999999999999997E-2,4.8000000000000001E-2]
["2012 - Verified",1E-3,0.189,0.121,0.121]
[2013,0,1E-3,0.125,5.6000000000000001E-2]
[2014,0,1E-3,3.0000000000000001E-3,0.33800000000000002]
["Verified Net Annual Peak Demand Savings Persisting in 2014:  ",null,null,null,{"$f":"SUM(E15:E18)","v":0.56299999999999994}]
["2011-2014 CDM Capacity Target",null,null,null,1.34]
["Verified Portion of Peak Demand Savings Target Achieved in 2014(%):  ",null,null,null,{"$f":"E19/E20","v":0.42014925373134321}]
[]
["Persistence Factor (MW)"]
[null,2011,2012,2013,2014,2015,null,"(ADJUSTED)"]
[2011,null,{"$f":"C44","v":0.98979591836734693},{"$f":"D44","v":0.98979591836734693},{"$f":"E44","v":0.88775510204081642},{"$f":"F44","v":0.67},null,"USED kWH - Above removes Persistence on Demand Response."]
[2012,null,null,{"$f":"D45","v":0.99840255591054317},{"$f":"E45","v":0.99840255591054317},0.88]
[2013,null,null,null,{"$f":"E46","v":0.99557522123893805},1]
[2014,null,null,null,null,{"$f":"F47","v":1}]
[]
["Table 13: Net Energy Savings at the End User Level (GWh)"]
[]
["Implementation Period","Annual",null,null,null,"Cumulative"]
[null,2011,2012,2013,2014,"2011-2014 "]
["2011 - Verified",0.29399999999999998,0.29099999999999998,0.29099999999999998,0.26100000000000001,1.137]
["2012 - Verified",2.5999999999999999E-2,0.626,0.625,0.625,1.9019999999999999]
[2013,0,2E-3,0.22600000000000001,0.22500000000000001,0.45300000000000001]
[2014,0,1.4E-2,1.9E-2,0.8,0.83299999999999996]
["Verified Net Cumulative Energy Savings 2011-2014:",null,null,null,null,{"$f":"SUM(F34:F37)","v":4.3249999999999993}]
[" 2011-2014 CDM Energy Target",null,null,null,null,4.01]
["Verified Portion of Cumulative Energy Target Achieved (%):  ",null,null,null,null,{"$f":"F38/F39","v":1.0785536159600997}]
[]
["Persistence Factor (KWh)"]
[null,2011,2012,2013,2014,2015]
[2011,null,{"$f":"C34/$B$34","v":0.98979591836734693},{"$f":"D34/$B$34","v":0.98979591836734693},{"$f":"E34/$B$34","v":0.88775510204081642},0.67]
[2012,null,null,{"$f":"D35/$C$35","v":0.99840255591054317},{"$f":"E35/$C$35","v":0.99840255591054317},0.88]
[2013,null,null,null,{"$f":"E36/D36","v":0.99557522123893805},1]
[2014,null,null,null,null,1]