{"text_format":"1","workbook":"xlsx","n_sheets":14,"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","8.1 2012 Gross to Net Savings","9.0 2013LostRev","10.0 2014LostRev","11.0 Persistence ","CDM in 2013 CoS"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":19,"comments":6,"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   ","Centre Wellington Hydro Ltd"]
[]
[null,null,null,"Service Territory","Fergus and Elora"]
[]
[null,null,null,"Assigned EB Number"]
[]
[null,null,null,"Name of Contact and Title"]
[]
[null,null,null,"Phone Number   "]
[]
[null,null,null,"Email Address   "]
[]
[null,null,null,"Bridge Year"]
[]
[null,null,null,"Test Year"]
[]
[null,null,null,"Last Rebasing Year",2013,{"$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 2999 kW","Existing","Customer","kW"]
["General Service 3000 to 4999 kW","Existing","Customer","kW"]
["Unmetered Scattered Load","Existing","Customer","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":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,null,null,null,"Table 1 - LRAMVA register"]
[]
["Verified results updated ",2013]
[]
["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 2999 kW"},{"$f":"'2.0 Customer Classes'!$A16","v":"General Service 3000 to 4999 kW"},{"$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","Final Claim"]
["2011 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D34","v":0},{"$f":"-'4.0 Approved Load Forecast'!E34","v":0},{"$f":"-'4.0 Approved Load Forecast'!F34","v":0},{"$f":"-'4.0 Approved Load Forecast'!G34","v":0},{"$f":"-'4.0 Approved Load Forecast'!H34","v":0},{"$f":"-'4.0 Approved Load Forecast'!I34","v":0},{"$f":"-'4.0 Approved Load Forecast'!J34","v":0},null,null,null,{"$f":"SUM(B11:K11)","v":0}]
["2011 Verified",{"$f":"'7.0 2011LostRev'!F47","v":2227.9602538000004},{"$f":"'7.0 2011LostRev'!G47","v":2187.0437147333332},{"$f":"'7.0 2011LostRev'!H47","v":3956.0804517286961},{"$f":"'7.0 2011LostRev'!I47","v":88.273655436521736},{"$f":"'7.0 2011LostRev'!J47","v":0},{"$f":"'7.0 2011LostRev'!K47","v":0},{"$f":"'7.0 2011LostRev'!L47","v":0},null,null,null,{"$f":"SUM(B12:K12)","v":8459.3580756985521}]
["2011 Cleared",0,0,0,0,0,0,0,null,null,null,0,{"$f":"L12","v":8459.3580756985521}]
[]
["2012 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D35","v":0},{"$f":"-'4.0 Approved Load Forecast'!E35","v":0},{"$f":"-'4.0 Approved Load Forecast'!F35","v":0},{"$f":"-'4.0 Approved Load Forecast'!G35","v":0},{"$f":"-'4.0 Approved Load Forecast'!H35","v":0},{"$f":"-'4.0 Approved Load Forecast'!I35","v":0},{"$f":"-'4.0 Approved Load Forecast'!J35","v":0},null,null,null,0]
["2012 Verified",{"$f":"'8.0 2012LostRev'!F63","v":3647.6948506578456},{"$f":"'8.0 2012LostRev'!G63","v":14307.071257132218},{"$f":"'8.0 2012LostRev'!H63","v":5802.5380830839667},{"$f":"'8.0 2012LostRev'!I63","v":82.71938918761343},{"$f":"'8.0 2012LostRev'!J63","v":0},{"$f":"'8.0 2012LostRev'!K63","v":0},{"$f":"'8.0 2012LostRev'!L63","v":0},null,null,null,23840.023580061643]
["2012 Cleared",0,0,0,0,0,0,0,null,null,null,0,{"$f":"L16","v":23840.023580061643}]
[]
["2013 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D36","v":-4138.8135999921797},{"$f":"-'4.0 Approved Load Forecast'!E36","v":-2346.0548877010715},{"$f":"-'4.0 Approved Load Forecast'!F36","v":-3405.0214463312332},{"$f":"-'4.0 Approved Load Forecast'!G36","v":-659.78978530221968},{"$f":"-'4.0 Approved Load Forecast'!H36","v":-70.292696714607715},{"$f":"-'4.0 Approved Load Forecast'!I36","v":-8.2658684248910266},{"$f":"-'4.0 Approved Load Forecast'!J36","v":-321.39304771968358},null,null,null,-10949.631332185887]
["2013 Actuals",{"$f":"'9.0 2013LostRev'!F70","v":5362.4342706234138},{"$f":"'9.0 2013LostRev'!G70","v":18972.888662910722},{"$f":"'9.0 2013LostRev'!H70","v":36106.679726063026},{"$f":"'9.0 2013LostRev'!I70","v":87.748045000691079},{"$f":"'9.0 2013LostRev'!J70","v":0},{"$f":"'9.0 2013LostRev'!K70","v":0},{"$f":"'9.0 2013LostRev'!L70","v":0},null,null,null,60529.750704597849]
["2013 Cleared",0,0,0,0,0,0,0,null,null,null,0,{"$f":"SUM(L19:L20)","v":49580.119372411966}]
[]
["2014 Forecast",{"$f":"-'4.0 Approved Load Forecast'!D37","v":-4365.315836807672},{"$f":"-'4.0 Approved Load Forecast'!E37","v":-2518.0530466234377},{"$f":"-'4.0 Approved Load Forecast'!F37","v":-3747.3409344124125},{"$f":"-'4.0 Approved Load Forecast'!G37","v":-701.63495319624451},{"$f":"-'4.0 Approved Load Forecast'!H37","v":-42.243533677764255},{"$f":"-'4.0 Approved Load Forecast'!I37","v":-8.3462067693569786},{"$f":"-'4.0 Approved Load Forecast'!J37","v":-188.60548305997131},null,null,null,-11571.539994546858]
["2014 Actuals",{"$f":"'10.0 2014LostRev'!F57","v":5500.1098155929903},{"$f":"'10.0 2014LostRev'!G57","v":19781.519427875341},{"$f":"'10.0 2014LostRev'!H57","v":12713.937686267647},{"$f":"'10.0 2014LostRev'!I57","v":88.516726029193094},{"$f":"'10.0 2014LostRev'!J57","v":0},{"$f":"'10.0 2014LostRev'!K57","v":0},{"$f":"'10.0 2014LostRev'!L57","v":0},null,null,null,{"$f":"SUM(B24:K24)","v":38084.083655765171}]
["2014 Cleared",null,null,null,null,null,null,null,null,null,null,0]
[]
["Carrying Charges1",{"$f":"'5.0 Carrying Charges'!F68","v":101.8784196697498},{"$f":"'5.0 Carrying Charges'!G68","v":234.28374127898127},{"$f":"'5.0 Carrying Charges'!H68","v":191.75007153562993},{"$f":"'5.0 Carrying Charges'!I68","v":2.9371787257955573},{"$f":"'5.0 Carrying Charges'!J68","v":-4.3054276737697225E-2},{"$f":"'5.0 Carrying Charges'!K68","v":-5.0628444102457527E-3},{"$f":"'5.0 Carrying Charges'!L68","v":-0.19685324172830618},null,null,null,530.60444084728033]
["Balance",{"$f":"SUM(B11:B27)","v":8335.9481735441495},{"$f":"SUM(C11:C27)","v":50618.698869606087},51618.623637935321,-1011.2297441186494,-112.57928466910967,-16.617138038658254,-510.19538402138318,null,null,0,{"$f":"SUM(L11:L27)","v":108922.64913023777},{"$f":"SUM(M11:M27)","v":81879.501028172162},"*** received 2010 persistance in 2013 CoS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*** reconciles with balance at Dec 31,2014/RRR"]
[]
["Input amounts cleared by rate class."]
["1 Update formula for most recent rate year"]

{"sheet":"4.0 Approved Load Forecast","index":4,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[[17,1,17,13],[29,1,29,13],[41,0,41,13],[50,3,51,13],[7,1,7,4]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[null,"CDM Targets - 1/2 year rule - final CDM via Irs"]
[]
[null,"Forecast Year",null," "]
[null,null,null,"kWh","kW"]
[null,2011,null,0,{"$f":"E13*0.5","v":{"$error":"#DIV/0!"}}]
[null,2012,null,0,{"$f":"N63","v":{"$error":"#DIV/0!"}}]
[null,2013,null,{"$f":"'CDM in 2013 CoS'!D11","v":986133},{"$f":"N76","v":-1337.0534362595438}]
[null,2014,null,{"$f":"'CDM in 2013 CoS'!D11","v":986133},{"$f":"N89","v":-1337.0534362595438}]
[null,null,null,{"$f":"SUM(D12:D15)","v":1972266},{"$f":"SUM(E12:E15)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Table 2 - Savings Due to CDM Included in Approved Load Forecast"]
[]
[null,"Forecast Year",null,{"$f":"'3.0 LRAMVA Register'!B$10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C$10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D$10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E$10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F$10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G$10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H$10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!I$10","v":"other"},{"$f":"'3.0 LRAMVA Register'!J$10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K$10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","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,0,0,0,0,0,0,0]
[null,2013,null,{"$f":"-D72","v":308866.68656658055},{"$f":"-E72","v":137598.52713789276},{"$f":"-F76","v":1062.7739462315408},{"$f":"-G76","v":252.2566134473513},{"$f":"-H72","v":4074.9389399772595},{"$f":"-I76","v":0.70164492983362858},{"$f":"-J76","v":21.321231650818046}]
[null,2014,null,{"$f":"-D85","v":308866.68656658055},{"$f":"-E85","v":137598.52713789276},{"$f":"-F89","v":1062.7739462315408},{"$f":"-G89","v":252.2566134473513},{"$f":"-H85","v":4074.9389399772595},{"$f":"-I89","v":0.70164492983362858},{"$f":"-J89","v":21.321231650818046}]
[]
[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":"D20","v":"Residential"},"General Service < 50 kW","General Service 50 to 2999 kW","General Service 3000 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,null,null,"$","$","$","$","$","$","$","$","$","$","$"]
[null,2011,null,{"$f":"D22*'6.0 Rates'!C15","v":0},{"$f":"E22*'6.0 Rates'!C16","v":0},{"$f":"F22*'6.0 Rates'!C17","v":0},{"$f":"G22*'6.0 Rates'!C18","v":0},{"$f":"H22*'6.0 Rates'!C19","v":0},{"$f":"I22*'6.0 Rates'!C20","v":0},{"$f":"J22*'6.0 Rates'!C21","v":0},null,null,null,{"$f":"SUM(D34:M34)","v":0}]
[null,2012,null,{"$f":"D23*'6.0 Rates'!D15","v":0},{"$f":"E23*'6.0 Rates'!D16","v":0},{"$f":"F23*'6.0 Rates'!D17","v":0},{"$f":"G23*'6.0 Rates'!D18","v":0},{"$f":"H23*'6.0 Rates'!D19","v":0},{"$f":"I23*'6.0 Rates'!D20","v":0},{"$f":"J23*'6.0 Rates'!D21","v":0},null,null,null,{"$f":"SUM(D35:M35)","v":0}]
[null,2013,null,{"$f":"D24*'6.0 Rates'!E15","v":4138.8135999921797},{"$f":"E24*'6.0 Rates'!E16","v":2346.0548877010715},{"$f":"F24*'6.0 Rates'!E17","v":3405.0214463312332},{"$f":"G24*'6.0 Rates'!E18","v":659.78978530221968},{"$f":"H24*'6.0 Rates'!E19","v":70.292696714607715},{"$f":"I24*'6.0 Rates'!E20","v":8.2658684248910266},{"$f":"J24*'6.0 Rates'!E21","v":321.39304771968358},null,null,null,10949.631332185887]
[null,2014,null,{"$f":"D25*'6.0 Rates'!F15","v":4365.315836807672},{"$f":"E25*'6.0 Rates'!F16","v":2518.0530466234377},{"$f":"F25*'6.0 Rates'!F17","v":3747.3409344124125},{"$f":"G25*'6.0 Rates'!F18","v":701.63495319624451},{"$f":"H25*'6.0 Rates'!F19","v":42.243533677764255},{"$f":"I25*'6.0 Rates'!F20","v":8.3462067693569786},{"$f":"J25*'6.0 Rates'!F21","v":188.60548305997131},null,null,null,11571.539994546858]
[]
[]
[]
[]
["CDM Adjustment as Approved in last Cost of Service"]
[]
[null,2011,null,{"$f":"D32","v":"Residential"},{"$f":"E32","v":"General Service < 50 kW"},"General Service 50 to 2999 kW","General Service 3000 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[]
[null,"Test Weather Normal Billed kWh",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D46:M46)","v":0}]
[null,"% of Billed",null,{"$f":"D46/$N$46","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"K46/$N$46","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"M46/$N$46","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D47:M47)","v":{"$error":"#DIV/0!"}}]
[null,"CDM Spread kWh",null,{"$f":"-$D$12*D47","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-$D$12*J47","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-$D$12*M47","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D48:M48)","v":{"$error":"#DIV/0!"}}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D46+D48","v":{"$error":"#DIV/0!"}},{"$f":"E46+E48","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D49:M50)","v":{"$error":"#DIV/0!"}}]
[]
[null,"***CWH No CDM was applied to Load Forecast prior to 2012",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,"Model should be shown with all rows as CDM may have been included for other LDC in previous CoS applications - Comment row should be included."]
[]
[]
[null,2012,null,{"$f":"D44","v":"Residential"},"General Service < 50 kW","General Service 50 to 2999 kW","General Service 3000 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"TEST Weather Normal Billed kWh",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D57:M57)","v":0}]
[null,"% of Billed",null,{"$f":"D57/$N$57","v":{"$error":"#DIV/0!"}},{"$f":"E57/$N$57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J57/$N$57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M57/$N$57","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D58:M58)","v":{"$error":"#DIV/0!"}}]
[null,"CDM Spread kWh",null,{"$f":"-$D$13*D58","v":{"$error":"#DIV/0!"}},{"$f":"-$D$13*E58","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-$D$13*J58","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"-$D$13*M58","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D59:M59)","v":{"$error":"#DIV/0!"}}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D57+D59","v":{"$error":"#DIV/0!"}},{"$f":"E57+E59","v":{"$error":"#DIV/0!"}},{"$f":"F57+F59","v":{"$error":"#DIV/0!"}},{"$f":"G57+G59","v":{"$error":"#DIV/0!"}},{"$f":"H57+H59","v":{"$error":"#DIV/0!"}},{"$f":"I57+I59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M57+M59","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D60:M61)","v":{"$error":"#DIV/0!"}}]
[null,"kW"]
[null,"TEST Weather Normal Billed kW",null,{"$f":"D57*D65","v":0},0,{"$f":"F57*F65","v":0},{"$f":"G57*G65","v":0},0,0,{"$f":"J57*J65","v":0},0,0,0,{"$f":"SUM(D62:M62)","v":0}]
[null,"CDM kW Reduction",null,{"$f":"D59*D65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F59*F65","v":{"$error":"#DIV/0!"}},{"$f":"G59*G65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J59*J65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D63:M63)","v":{"$error":"#DIV/0!"}}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D62+D63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"F62+F63","v":{"$error":"#DIV/0!"}},{"$f":"G62+G63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"J62+J63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(D64:M64)","v":{"$error":"#DIV/0!"}}]
[null,"kWh to KW Ratio"]
[]
[]
[null,2013,null,{"$f":"D55","v":"Residential"},{"$f":"E55","v":"General Service < 50 kW"},"General Service 50 to 2999 kW","General Service 3000 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"2013 TEST Weather Normal Billed kWh",null,{"$f":"'CDM in 2013 CoS'!B4","v":46118694},{"$f":"'CDM in 2013 CoS'!B5","v":20545642},{"$f":"'CDM in 2013 CoS'!B6","v":61722677},{"$f":"'CDM in 2013 CoS'!B7","v":17074303},{"$f":"'CDM in 2013 CoS'!B10","v":608453},{"$f":"'CDM in 2013 CoS'!B8","v":37713},{"$f":"'CDM in 2013 CoS'!B9","v":1137812},null,null,null,{"$f":"SUM(D70:M70)","v":147245294},"***In our rate order it says the CDM Adjustment to the Load Forecast is 986,133 kWh"]
[null,"% of Billed",null,{"$f":"D70/$N$70","v":0.3132099692096102},{"$f":"E70/$N$70","v":0.13953343731311371},0.41918268029672989,0.11595822546287965,{"$f":"H70/$N$70","v":4.1322407220702071E-3},2.5612363543516713E-4,7.7273233601611747E-3,0,0,0,{"$f":"SUM(D71:M71)","v":1},"***In the same rate order \"LRAMVA determined using annualized \"net\" CDM savings of 2,288,799 kWh"]
[null,"CDM Spread kWh",null,{"$f":"-$D$14*D71","v":-308866.68656658055},-137598.52713789276,{"$f":"-$D$14*F71","v":-413369.87406905513},-114350.2327503859,{"$f":"-$D$14*H71","v":-4074.9389399772595},-252.57196898258766,{"$f":"-$D$14*J71","v":-7620.1685671258201},0,0,{"$f":"-$D$14*M71","v":0},{"$f":"SUM(D72:M72)","v":-986132.99999999988}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D70+D72","v":45809827.313433416},{"$f":"E70+E72","v":20408043.472862106},{"$f":"F70+F72","v":61309307.125930943},{"$f":"G70+G72","v":16959952.767249614},{"$f":"H70+H72","v":604378.0610600228},{"$f":"I70+I72","v":37460.428031017414},1130191.8314328741,0,0,{"$f":"M70+M72","v":0},{"$f":"SUM(D73:M74)","v":146259161}]
[null,"kW"]
[null,"2013 TEST Weather Normal Billed kW",null,{"$f":"D70*D78","v":0},{"$f":"E70*E78","v":0},{"$f":"F70*F78","v":158689.00256699999},{"$f":"G70*G78","v":37665.912418},0,104.76671400000001,{"$f":"J70*J78","v":3183.597976},0,0,0,{"$f":"SUM(D75:M75)","v":199643.27967499997}]
[null,"CDM kW Reduction",null,{"$f":"D72*D78","v":0},{"$f":"E72*E78","v":0},{"$f":"F72*F78","v":-1062.7739462315408},{"$f":"G72*G78","v":-252.2566134473513},0,-0.70164492983362858,{"$f":"J72*J78","v":-21.321231650818046},0,0,0,{"$f":"SUM(D76:M76)","v":-1337.0534362595438}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D75+D76","v":0},{"$f":"E75+E76","v":0},{"$f":"F75+F76","v":157626.22862076844},{"$f":"G75+G76","v":37413.655804552647},{"$f":"H75+H76","v":0},{"$f":"I75+I76","v":104.06506907016637},3162.2767443491821,0,0,0,{"$f":"SUM(D77:M77)","v":198306.22623874043}]
[null,"kWh to KW Ratio",null,0,0,2.5709999999999999E-3,2.2060000000000001E-3,0,2.7780000000000001E-3,2.7980000000000001E-3]
[]
[]
[null,2014,null,{"$f":"D68","v":"Residential"},{"$f":"E68","v":"General Service < 50 kW"},"General Service 50 to 2999 kW","General Service 3000 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","Total"]
[null,"kWh"]
[null,"2013 TEST Weather Normal Billed kWh",null,{"$f":"D70","v":46118694},{"$f":"E70","v":20545642},61722677,17074303,608453,37713,1137812,0,0,0,{"$f":"SUM(D83:M83)","v":147245294}]
[null,"% of Billed",null,{"$f":"D83/$N$83","v":0.3132099692096102},0.13953343731311371,0.41918268029672989,0.11595822546287965,4.1322407220702071E-3,2.5612363543516713E-4,7.7273233601611747E-3,0,0,0,{"$f":"SUM(D84:M84)","v":1}]
[null,"CDM Spread kWh",null,{"$f":"-$D$15*D84","v":-308866.68656658055},-137598.52713789276,-413369.87406905513,-114350.2327503859,-4074.9389399772595,-252.57196898258766,{"$f":"-$D$15*J84","v":-7620.1685671258201},0,0,{"$f":"-$D$15*M84","v":0},{"$f":"SUM(D85:M85)","v":-986132.99999999988}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D83+D85","v":45809827.313433416},{"$f":"E83+E85","v":20408043.472862106},{"$f":"F83+F85","v":61309307.125930943},{"$f":"G83+G85","v":16959952.767249614},{"$f":"H83+H85","v":604378.0610600228},{"$f":"I83+I85","v":37460.428031017414},1130191.8314328741,0,0,{"$f":"M83+M85","v":0},{"$f":"SUM(D86:M87)","v":146259161}]
[null,"kW"]
[null,"2013 TEST Weather Normal Billed kW",null,{"$f":"D83*D91","v":0},0,{"$f":"F83*F91","v":158689.00256699999},{"$f":"G83*G91","v":37665.912418},0,104.76671400000001,{"$f":"J83*J91","v":3183.597976},0,0,0,{"$f":"SUM(D88:M88)","v":199643.27967499997}]
[null,"CDM kW Reduction",null,{"$f":"D85*D91","v":0},0,{"$f":"F85*F91","v":-1062.7739462315408},{"$f":"G85*G91","v":-252.2566134473513},0,-0.70164492983362858,{"$f":"J85*J91","v":-21.321231650818046},0,0,0,{"$f":"SUM(D89:M89)","v":-1337.0534362595438}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D88+D89","v":0},0,{"$f":"F88+F89","v":157626.22862076844},{"$f":"G88+G89","v":37413.655804552647},{"$f":"H88+H89","v":0},{"$f":"I88+I89","v":104.06506907016637},3162.2767443491821,0,0,0,{"$f":"SUM(D90:M90)","v":198306.22623874043}]
[null,"kWh to KW Ratio",null,{"$f":"+D78","v":0},0,2.5709999999999999E-3,2.2060000000000001E-3,0,2.7780000000000001E-3,2.7980000000000001E-3]

{"sheet":"5.0 Carrying Charges","index":5,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[[8,6,8,9],[30,6,30,9]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Table 4 - Carrying Charges Prescribed Rates"]
[]
[null,null,null,null,null,null,"Period","Board specified","Estimated","Used in calculations"]
[null,null,null,null,null,null,"2011 Q1",1.47E-2,null,{"$f":"IF(H12<>0,H12,I12)","v":1.47E-2}]
[null,null,null,null,null,null,"2011 Q2",1.47E-2,null,{"$f":"IF(H13<>0,H13,I13)","v":1.47E-2}]
[null,null,null,null,null,null,"2011 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2011 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2012 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2012 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2012 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2012 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2013 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2013 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2013 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2013 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2014 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2014 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2014 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2014 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,null,null,"2015 Q1",null,1.47E-2,1.47E-2]
[null,null,null,null,null,null,"2015 Q2",null,1.47E-2,1.47E-2]
[]
[null,null,null,null,null,null,"Table 5 - Carrying Charges by Rate Class"]
[null,null,null,"**Need to change this if go with coloumn B"]
["Month","What CWH thinks (Fiscal month)","Interest for CDM year","Quarter","Monthly Rate",{"$f":"'3.0 LRAMVA Register'!B10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!I10","v":"other"},{"$f":"'3.0 LRAMVA Register'!J10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
["2011-01-01","2012-10-01","2011","Q1",{"$f":"J$12/12","v":1.225E-3}]
["2011-02-01","2012-11-01","2011","Q1",{"$f":"J$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A35)-1)/12*$E35","v":0.22743760924208337},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A35)-1)/12*$E35","v":0.22326071254569441},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A35)-1)/12*$E35","v":0.40384987944730438},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A35)-1)/12*$E35","v":9.0112689924782604E-3},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A35)-1)/12*$E35","v":0},{"$f":"SUM(F35:O35)","v":0.86355947022756052}]
["2011-03-01","2012-12-01","2011","Q1",{"$f":"J$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A36)-1)/12*$E36","v":0.45487521848416673},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A36)-1)/12*$E36","v":0.44652142509138881},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A36)-1)/12*$E36","v":0.80769975889460877},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A36)-1)/12*$E36","v":1.8022537984956521E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A36)-1)/12*$E36","v":0},{"$f":"SUM(F36:O36)","v":1.727118940455121}]
["2011-04-01","2013-01-01","2011","Q2",{"$f":"J$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A37)-1)/12*$E37","v":0.68231282772625013},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A37)-1)/12*$E37","v":0.66978213763708327},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A37)-1)/12*$E37","v":1.2115496383419131},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A37)-1)/12*$E37","v":2.7033806977434779E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A37)-1)/12*$E37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A37)-1)/12*$E37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A37)-1)/12*$E37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A37)-1)/12*$E37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A37)-1)/12*$E37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A37)-1)/12*$E37","v":0},2.5906784106826817]
["Total for rate year 2010",null,null,null,null,{"$f":"SUM(F34:F37)","v":1.3646256554525003},{"$f":"SUM(G34:G37)","v":1.3395642752741663},2.4230992766838262,5.4067613954869559E-2,0,0,0,0,0,0,5.1813568213653634]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F39:O39)","v":0}]
["Opening Balance for rate year 2011",null,null,null,null,{"$f":"F38+F39","v":1.3646256554525003},{"$f":"G38+G39","v":1.3395642752741663},{"$f":"H38+H39","v":2.4230992766838262},{"$f":"I38+I39","v":5.4067613954869559E-2},0,0,0,0,0,0,{"$f":"P38+P39","v":5.1813568213653634}]
["2011-05-01","2013-02-01","2011","Q2",{"$f":"J$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A41)-1)/12*$E41","v":0.90975043696833346},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A41)-1)/12*$E41","v":0.89304285018277763},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A41)-1)/12*$E41","v":1.6153995177892175},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A41)-1)/12*$E41","v":3.6045075969913042E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A41)-1)/12*$E41","v":0},{"$f":"SUM(F41:O41)","v":3.4542378809102421}]
["2011-06-01","2013-03-01","2011","Q2",{"$f":"J$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A42)-1)/12*$E42","v":1.1371880462104169},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A42)-1)/12*$E42","v":1.1163035627284721},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A42)-1)/12*$E42","v":2.0192493972365217},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A42)-1)/12*$E42","v":4.5056344962391297E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A42)-1)/12*$E42","v":0},{"$f":"SUM(F42:O42)","v":4.3177973511378012}]
["2011-07-01","2013-04-01","2011","Q3",{"$f":"J$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A43)-1)/12*$E43","v":1.3646256554525003},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A43)-1)/12*$E43","v":1.3395642752741665},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A43)-1)/12*$E43","v":2.4230992766838262},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A43)-1)/12*$E43","v":5.4067613954869559E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A43)-1)/12*$E43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A43)-1)/12*$E43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A43)-1)/12*$E43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A43)-1)/12*$E43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A43)-1)/12*$E43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A43)-1)/12*$E43","v":0},5.1813568213653634]
["2011-08-01","2013-05-01","2011","Q3",{"$f":"J$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A44)-1)/12*$E44","v":1.5920632646945836},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A44)-1)/12*$E44","v":1.562824987819861},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A44)-1)/12*$E44","v":2.8269491561311306},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A44)-1)/12*$E44","v":6.3078882947347828E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A44)-1)/12*$E44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A44)-1)/12*$E44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A44)-1)/12*$E44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A44)-1)/12*$E44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A44)-1)/12*$E44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A44)-1)/12*$E44","v":0},6.0449162915929229]
["2011-09-01","2013-06-01","2011","Q3",{"$f":"J$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A45)-1)/12*$E45","v":1.8195008739366669},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A45)-1)/12*$E45","v":1.7860857003655553},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A45)-1)/12*$E45","v":3.2307990355784351},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A45)-1)/12*$E45","v":7.2090151939826083E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A45)-1)/12*$E45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A45)-1)/12*$E45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A45)-1)/12*$E45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A45)-1)/12*$E45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A45)-1)/12*$E45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A45)-1)/12*$E45","v":0},6.9084757618204842]
["2011-10-01","2013-07-01","2011","Q4",{"$f":"J$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A46)-1)/12*$E46","v":2.0469384831787503},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A46)-1)/12*$E46","v":2.0093464129112499},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A46)-1)/12*$E46","v":3.6346489150257395},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A46)-1)/12*$E46","v":8.1101420932304352E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A46)-1)/12*$E46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A46)-1)/12*$E46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A46)-1)/12*$E46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A46)-1)/12*$E46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A46)-1)/12*$E46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A46)-1)/12*$E46","v":0},7.7720352320480437]
["2011-11-01","2013-08-01","2011","Q4",{"$f":"J$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A47)-1)/12*$E47","v":2.2743760924208338},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A47)-1)/12*$E47","v":2.2326071254569442},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A47)-1)/12*$E47","v":4.0384987944730435},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A47)-1)/12*$E47","v":9.0112689924782594E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A47)-1)/12*$E47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A47)-1)/12*$E47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A47)-1)/12*$E47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A47)-1)/12*$E47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A47)-1)/12*$E47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A47)-1)/12*$E47","v":0},8.6355947022756023]
["2011-12-01","2013-09-01","2011","Q4",{"$f":"J$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A48)-1)/12*$E48","v":2.5018137016629169},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A48)-1)/12*$E48","v":2.4558678380026389},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A48)-1)/12*$E48","v":4.4423486739203479},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A48)-1)/12*$E48","v":9.9123958917260849E-2},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A48)-1)/12*$E48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A48)-1)/12*$E48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A48)-1)/12*$E48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A48)-1)/12*$E48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A48)-1)/12*$E48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A48)-1)/12*$E48","v":0},9.4991541725031645]
["2012-01-01","2013-10-01","2011-2012","Q1",{"$f":"J$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A49)-1)/12)*$E49","v":2.7292513109050005},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A49)-1)/12)*$E49","v":2.6791285505483331},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A49)-1)/12)*$E49","v":4.8461985533676524},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A49)-1)/12)*$E49","v":0.10813522790973912},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A49)-1)/12)*$E49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A49)-1)/12)*$E49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A49)-1)/12)*$E49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A49)-1)/12)*$E49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A49)-1)/12)*$E49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A49)-1)/12)*$E49","v":0},10.362713642730727]
["2012-02-01","2013-11-01","2011-2012","Q1",{"$f":"J$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A50)-1)/12)*$E50","v":3.1016201602429887},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A50)-1)/12)*$E50","v":4.1396420747139135},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A50)-1)/12)*$E50","v":5.4385409826824738},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A50)-1)/12)*$E50","v":0.11657949888930799},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A50)-1)/12)*$E50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A50)-1)/12)*$E50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A50)-1)/12)*$E50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A50)-1)/12)*$E50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A50)-1)/12)*$E50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A50)-1)/12)*$E50","v":0},12.796382716528685]
["2012-03-01","2013-12-01","2011-2012","Q1",{"$f":"J$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A51)-1)/12)*$E51","v":3.4739890095809769},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A51)-1)/12)*$E51","v":5.6001555988794944},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A51)-1)/12)*$E51","v":6.0308834119972961},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A51)-1)/12)*$E51","v":0.12502376986887687},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A51)-1)/12)*$E51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A51)-1)/12)*$E51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A51)-1)/12)*$E51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A51)-1)/12)*$E51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A51)-1)/12)*$E51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A51)-1)/12)*$E51","v":0},15.230051790326645]
["2012-04-01","2014-01-01","2011-2012","Q2",{"$f":"J$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A52)-1)/12)*$E52","v":3.846357858918966},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A52)-1)/12)*$E52","v":7.0606691230450744},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A52)-1)/12)*$E52","v":6.6232258413121174},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A52)-1)/12)*$E52","v":0.13346804084844574},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A52)-1)/12)*$E52","v":0},{"$f":"SUM(F52:O52)","v":17.663720864124603}]
["Total for rate year 2011",null,null,null,null,{"$f":"SUM(F40:F52)","v":28.162100549625432},{"$f":"SUM(G40:G52)","v":34.214802375202652},49.592940832881631,1.0779502910199348,0,0,0,{"$f":"SUM(M40:M52)","v":0},0,0,113.04779404872963]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F54:O54)","v":0}]
["Opening Balance for rate year 2012",null,null,null,null,{"$f":"F53+F54","v":28.162100549625432},34.214802375202652,49.592940832881631,1.0779502910199348,0,0,0,0,0,0,{"$f":"P53+P54","v":113.04779404872963}]
["2012-05-01","2014-02-01","2011-2012","Q2",{"$f":"J$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A56)-1)/12)*$E56","v":4.2187267082569537},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A56)-1)/12)*$E56","v":8.5211826472106544},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A56)-1)/12)*$E56","v":7.2155682706269388},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A56)-1)/12)*$E56","v":0.14191231182801461},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A56)-1)/12)*$E56","v":0},{"$f":"SUM(F56:O56)","v":20.097389937922564}]
["2012-06-01","2014-03-01","2011-2012","Q2",{"$f":"J$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A57)-1)/12)*$E57","v":4.5910955575949428},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A57)-1)/12)*$E57","v":9.9816961713762371},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A57)-1)/12)*$E57","v":7.8079106999417602},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A57)-1)/12)*$E57","v":0.15035658280758349},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A57)-1)/12)*$E57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A57)-1)/12)*$E57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A57)-1)/12)*$E57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A57)-1)/12)*$E57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A57)-1)/12)*$E57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A57)-1)/12)*$E57","v":0},22.531059011720522]
["2012-07-01","2014-04-01","2011-2012","Q3",{"$f":"J$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A58)-1)/12)*$E58","v":4.963464406932931},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A58)-1)/12)*$E58","v":11.442209695541816},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A58)-1)/12)*$E58","v":8.4002531292565834},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A58)-1)/12)*$E58","v":0.15880085378715234},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A58)-1)/12)*$E58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A58)-1)/12)*$E58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A58)-1)/12)*$E58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A58)-1)/12)*$E58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A58)-1)/12)*$E58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A58)-1)/12)*$E58","v":0},24.964728085518484]
["2012-08-01","2014-05-01","2011-2012","Q3",{"$f":"J$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A59)-1)/12)*$E59","v":5.3358332562709192},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A59)-1)/12)*$E59","v":12.902723219707395},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A59)-1)/12)*$E59","v":8.9925955585714039},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A59)-1)/12)*$E59","v":0.16724512476672124},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A59)-1)/12)*$E59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A59)-1)/12)*$E59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A59)-1)/12)*$E59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A59)-1)/12)*$E59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A59)-1)/12)*$E59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A59)-1)/12)*$E59","v":0},27.398397159316438]
["2012-09-01","2014-06-01","2011-2012","Q3",{"$f":"J$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A60)-1)/12)*$E60","v":5.7082021056089074},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A60)-1)/12)*$E60","v":14.363236743872978},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A60)-1)/12)*$E60","v":9.5849379878862262},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A60)-1)/12)*$E60","v":0.17568939574629008},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A60)-1)/12)*$E60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A60)-1)/12)*$E60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A60)-1)/12)*$E60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A60)-1)/12)*$E60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A60)-1)/12)*$E60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A60)-1)/12)*$E60","v":0},29.832066233114404]
["2012-10-01","2014-07-01","2011-2012","Q4",{"$f":"J$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A61)-1)/12)*$E61","v":6.0805709549468956},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A61)-1)/12)*$E61","v":15.823750268038561},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A61)-1)/12)*$E61","v":10.177280417201047},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A61)-1)/12)*$E61","v":0.18413366672585899},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A61)-1)/12)*$E61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A61)-1)/12)*$E61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A61)-1)/12)*$E61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A61)-1)/12)*$E61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A61)-1)/12)*$E61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A61)-1)/12)*$E61","v":0},32.265735306912362]
["2012-11-01","2014-08-01","2011-2012","Q4",{"$f":"J$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A62)-1)/12)*$E62","v":6.4529398042848838},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A62)-1)/12)*$E62","v":17.28426379220414},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A62)-1)/12)*$E62","v":10.769622846515867},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A62)-1)/12)*$E62","v":0.19257793770542783},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A62)-1)/12)*$E62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A62)-1)/12)*$E62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A62)-1)/12)*$E62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A62)-1)/12)*$E62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A62)-1)/12)*$E62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A62)-1)/12)*$E62","v":0},34.69940438071032]
["2012-12-01","2014-09-01","2011-2012","Q4",{"$f":"J$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$15:B$16)*(MONTH($A63)-1)/12)*$E63","v":6.825308653622872},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$15:C$16)*(MONTH($A63)-1)/12)*$E63","v":18.744777316369721},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$15:D$16)*(MONTH($A63)-1)/12)*$E63","v":11.361965275830689},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$15:E$16)*(MONTH($A63)-1)/12)*$E63","v":0.20102220868499668},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$15:F$16)*(MONTH($A63)-1)/12)*$E63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$15:G$16)*(MONTH($A63)-1)/12)*$E63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$15:H$16)*(MONTH($A63)-1)/12)*$E63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$15:I$16)*(MONTH($A63)-1)/12)*$E63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$15:J$16)*(MONTH($A63)-1)/12)*$E63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$15:K$16)*(MONTH($A63)-1)/12)*$E63","v":0},37.133073454508278]
["2013-01-01","2014-10-01","2011-2013","Q1",{"$f":"J$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A64)-1)/12)*$E64","v":7.197677502960862},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A64)-1)/12)*$E64","v":20.205290840535298},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A64)-1)/12)*$E64","v":11.954307705145512},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A64)-1)/12)*$E64","v":0.20946647966456558},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A64)-1)/12)*$E64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A64)-1)/12)*$E64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A64)-1)/12)*$E64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A64)-1)/12)*$E64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A64)-1)/12)*$E64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A64)-1)/12)*$E64","v":0},39.566742528306236]
["2013-02-01","2014-11-01","2011-2013","Q1",{"$f":"J$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A65)-1)/12)*$E65","v":7.3225887797544669},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A65)-1)/12)*$E65","v":21.902613455087948},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A65)-1)/12)*$E65","v":15.292601987868133},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A65)-1)/12)*$E65","v":0.15107055200878453},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A65)-1)/12)*$E65","v":-7.1757127896162039E-3},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A65)-1)/12)*$E65","v":-8.4380740170762552E-4},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A65)-1)/12)*$E65","v":-3.2808873621384363E-2},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A65)-1)/12)*$E65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A65)-1)/12)*$E65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A65)-1)/12)*$E65","v":0},44.628046380906618]
["2013-03-01","2014-12-01","2011-2013","Q1",{"$f":"J$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A66)-1)/12)*$E66","v":7.4475000565480727},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A66)-1)/12)*$E66","v":23.599936069640602},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A66)-1)/12)*$E66","v":18.630896270590753},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A66)-1)/12)*$E66","v":9.2674624353003471E-2},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A66)-1)/12)*$E66","v":-1.4351425579232408E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A66)-1)/12)*$E66","v":-1.687614803415251E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A66)-1)/12)*$E66","v":-6.5617747242768726E-2},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A66)-1)/12)*$E66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A66)-1)/12)*$E66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A66)-1)/12)*$E66","v":0},49.689350233507007]
["2013-04-01","2015-01-01","2011-2013","Q2",{"$f":"J$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A67)-1)/12)*$E67","v":7.5724113333416767},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A67)-1)/12)*$E67","v":25.297258684193253},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A67)-1)/12)*$E67","v":21.969190553313375},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A67)-1)/12)*$E67","v":3.427869669722243E-2},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A67)-1)/12)*$E67","v":-2.1527138368848613E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A67)-1)/12)*$E67","v":-2.5314222051228768E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A67)-1)/12)*$E67","v":-9.8426620864153089E-2},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A67)-1)/12)*$E67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A67)-1)/12)*$E67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A67)-1)/12)*$E67","v":0},54.750654086107403]
["Total for rate year 2012",null,null,null,null,{"$f":"SUM(F55:F67)","v":101.8784196697498},{"$f":"SUM(G55:G67)","v":234.28374127898127},191.75007153562993,2.9371787257955573,-4.3054276737697225E-2,-5.0628444102457527E-3,-0.19685324172830618,{"$f":"SUM(M55:M67)","v":0},0,0,530.60444084728033]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F69:O69)","v":0}]
["Opening Balance for rate year 2013",null,null,null,null,{"$f":"F68+F69","v":101.8784196697498},234.28374127898127,191.75007153562993,2.9371787257955573,-4.3054276737697225E-2,-5.0628444102457527E-3,-0.19685324172830618,0,0,0,{"$f":"P68+P69","v":530.60444084728033}]
["2013-05-01","2015-02-01","2011-2013","Q2",{"$f":"J$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A71)-1)/12)*$E71","v":7.6973226101352825},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A71)-1)/12)*$E71","v":26.994581298745906},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A71)-1)/12)*$E71","v":25.307484836035993},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A71)-1)/12)*$E71","v":-2.4117230958558632E-2},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A71)-1)/12)*$E71","v":-2.8702851158464816E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A71)-1)/12)*$E71","v":-3.3752296068305021E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A71)-1)/12)*$E71","v":-0.13123549448553745},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A71)-1)/12)*$E71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A71)-1)/12)*$E71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A71)-1)/12)*$E71","v":0},{"$f":"SUM(F71:O71)","v":59.811957938707792}]
["2013-06-01","2015-03-01","2011-2013","Q2",{"$f":"J$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A72)-1)/12)*$E72","v":7.8222338869288874},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A72)-1)/12)*$E72","v":28.691903913298557},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A72)-1)/12)*$E72","v":28.645779118758618},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A72)-1)/12)*$E72","v":-8.2513158614339652E-2},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A72)-1)/12)*$E72","v":-3.5878563948081019E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A72)-1)/12)*$E72","v":-4.2190370085381278E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A72)-1)/12)*$E72","v":-0.16404436810692183},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A72)-1)/12)*$E72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A72)-1)/12)*$E72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A72)-1)/12)*$E72","v":0},64.873261791308181]
["2013-07-01","2015-04-01","2011-2013","Q3",{"$f":"J$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A73)-1)/12)*$E73","v":7.9471451637224924},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A73)-1)/12)*$E73","v":30.389226527851207},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A73)-1)/12)*$E73","v":31.984073401481233},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A73)-1)/12)*$E73","v":-0.14090908627012072},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A73)-1)/12)*$E73","v":-4.3054276737697225E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A73)-1)/12)*$E73","v":-5.0628444102457535E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A73)-1)/12)*$E73","v":-0.19685324172830618},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A73)-1)/12)*$E73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A73)-1)/12)*$E73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A73)-1)/12)*$E73","v":0},69.934565643908556]
["2013-08-01","2015-05-01","2011-2013","Q3",{"$f":"J$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A74)-1)/12)*$E74","v":8.0720564405160982},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A74)-1)/12)*$E74","v":32.086549142403861},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A74)-1)/12)*$E74","v":35.322367684203861},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A74)-1)/12)*$E74","v":-0.19930501392590178},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A74)-1)/12)*$E74","v":-5.0229989527313432E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A74)-1)/12)*$E74","v":-5.9066518119533793E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A74)-1)/12)*$E74","v":-0.22966211534969055},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A74)-1)/12)*$E74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A74)-1)/12)*$E74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A74)-1)/12)*$E74","v":0},74.995869496508959]
["2013-09-01","2015-06-01","2011-2013","Q3",{"$f":"J$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A75)-1)/12)*$E75","v":8.1969677173097022},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A75)-1)/12)*$E75","v":33.783871756956515},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A75)-1)/12)*$E75","v":38.660661966926476},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A75)-1)/12)*$E75","v":-0.25770094158168283},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A75)-1)/12)*$E75","v":-5.7405702316929631E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A75)-1)/12)*$E75","v":-6.7504592136610041E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A75)-1)/12)*$E75","v":-0.2624709889710749},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A75)-1)/12)*$E75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A75)-1)/12)*$E75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A75)-1)/12)*$E75","v":0},80.057173349109348]
["2013-10-01","2015-07-01","2011-2013","Q4",{"$f":"J$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A76)-1)/12)*$E76","v":8.321878994103308},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A76)-1)/12)*$E76","v":35.481194371509169},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A76)-1)/12)*$E76","v":41.99895624964909},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A76)-1)/12)*$E76","v":-0.31609686923746388},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A76)-1)/12)*$E76","v":-6.4581415106545831E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A76)-1)/12)*$E76","v":-7.5942666153686299E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A76)-1)/12)*$E76","v":-0.29527986259245931},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A76)-1)/12)*$E76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A76)-1)/12)*$E76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A76)-1)/12)*$E76","v":0},85.118477201709723]
["2013-11-01","2015-08-01","2011-2013","Q4",{"$f":"J$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A77)-1)/12)*$E77","v":8.4467902708969138},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A77)-1)/12)*$E77","v":37.178516986061815},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A77)-1)/12)*$E77","v":45.337250532371719},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A77)-1)/12)*$E77","v":-0.37449279689324488},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A77)-1)/12)*$E77","v":-7.1757127896162037E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A77)-1)/12)*$E77","v":-8.4380740170762556E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A77)-1)/12)*$E77","v":-0.32808873621384366},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A77)-1)/12)*$E77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A77)-1)/12)*$E77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A77)-1)/12)*$E77","v":0},90.179781054310112]
["2013-12-01","2015-09-01","2011-2013","Q4",{"$f":"J$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$17)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A78)-1)/12)*$E78","v":8.5717015476905178},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$17)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A78)-1)/12)*$E78","v":38.875839600614469},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$17)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A78)-1)/12)*$E78","v":48.675544815094341},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$17)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A78)-1)/12)*$E78","v":-0.43288872454902599},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$17)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A78)-1)/12)*$E78","v":-7.8932840685778244E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$17)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A78)-1)/12)*$E78","v":-9.2818814187838813E-3},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$17)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A78)-1)/12)*$E78","v":-0.36089760983522806},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$17)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A78)-1)/12)*$E78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$17)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A78)-1)/12)*$E78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$17)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A78)-1)/12)*$E78","v":0},95.241084906910487]
["2014-01-01","2015-10-01","2011-2014","Q1",{"$f":"J$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A79)-1)/12)*$E79","v":8.6966128244841236},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A79)-1)/12)*$E79","v":40.573162215167116},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A79)-1)/12)*$E79","v":52.013839097816955},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A79)-1)/12)*$E79","v":-0.49128465220480694},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A79)-1)/12)*$E79","v":-8.610855347539445E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A79)-1)/12)*$E79","v":-1.0125688820491507E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A79)-1)/12)*$E79","v":-0.39370648345661236},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A79)-1)/12)*$E79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A79)-1)/12)*$E79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A79)-1)/12)*$E79","v":0},100.30238875951088]
["2014-02-01","2015-11-01","2011-2014","Q1",{"$f":"J$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A80)-1)/12)*$E80","v":8.8124563764851249},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A80)-1)/12)*$E80","v":42.335474408253255},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A80)-1)/12)*$E80","v":52.929179182902182},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A80)-1)/12)*$E80","v":-0.55387380456144342},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A80)-1)/12)*$E80","v":-9.042091420499955E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A80)-1)/12)*$E80","v":-1.0977697428196698E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A80)-1)/12)*$E80","v":-0.41295995985231776},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A80)-1)/12)*$E80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A80)-1)/12)*$E80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A80)-1)/12)*$E80","v":0},103.00887759159359]
["2014-03-01","2015-12-01","2011-2014","Q1",{"$f":"J$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A81)-1)/12)*$E81","v":8.9282999284861262},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A81)-1)/12)*$E81","v":44.097786601339379},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A81)-1)/12)*$E81","v":53.844519267987401},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A81)-1)/12)*$E81","v":-0.61646295691807995},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A81)-1)/12)*$E81","v":-9.4733274934604636E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A81)-1)/12)*$E81","v":-1.182970603590189E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A81)-1)/12)*$E81","v":-0.43221343624802316},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A81)-1)/12)*$E81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A81)-1)/12)*$E81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A81)-1)/12)*$E81","v":0},105.7153664236763]
["2014-04-01","2016-01-01","2011-2014","Q2",{"$f":"J$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A82)-1)/12)*$E82","v":9.0441434804871275},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A82)-1)/12)*$E82","v":45.860098794425511},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A82)-1)/12)*$E82","v":54.759859353072621},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A82)-1)/12)*$E82","v":-0.67905210927471638},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A82)-1)/12)*$E82","v":-9.9045635664209764E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A82)-1)/12)*$E82","v":-1.2681714643607081E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A82)-1)/12)*$E82","v":-0.45146691264372857},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A82)-1)/12)*$E82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A82)-1)/12)*$E82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A82)-1)/12)*$E82","v":0},108.421855255759]
["Total for rate year 2013",null,null,null,null,{"$f":"SUM(F70:F82)","v":202.4360289109955},{"$f":"SUM(G70:G82)","v":670.63194689560805},{"$f":"SUM(H70:H82)","v":701.22958704193047},{"$f":"SUM(I70:I82)","v":-1.2315186191938272},{"$f":"SUM(J70:J82)","v":-0.84390542239387789},{"$f":"SUM(K70:K82)","v":-0.10130609544090045},{"$f":"SUM(L70:L82)","v":-3.8557324512120501},0,0,0,{"$f":"SUM(P70:P82)","v":1568.2651002602934}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F84:O84)","v":0}]
["Opening Balance for rate year 2014",null,null,null,null,{"$f":"F83+F84","v":202.4360289109955},{"$f":"G83+G84","v":670.63194689560805},701.22958704193047,-1.2315186191938272,-0.84390542239387789,-0.10130609544090045,-3.8557324512120501,0,0,0,{"$f":"P83+P84","v":1568.2651002602934}]
["2014-05-01","2016-02-01","2011-2014","Q2",{"$f":"J$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A86)-1)/12)*$E86","v":9.1599870324881287},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A86)-1)/12)*$E86","v":47.622410987511643},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A86)-1)/12)*$E86","v":55.675199438157847},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A86)-1)/12)*$E86","v":-0.74164126163135291},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A86)-1)/12)*$E86","v":-0.10335799639381485},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A86)-1)/12)*$E86","v":-1.3533723251312274E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A86)-1)/12)*$E86","v":-0.47072038903943403},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A86)-1)/12)*$E86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A86)-1)/12)*$E86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A86)-1)/12)*$E86","v":0},{"$f":"SUM(F86:O86)","v":111.12834408784171}]
["2014-06-01","2016-03-01","2011-2014","Q2",{"$f":"J$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A87)-1)/12)*$E87","v":9.27583058448913},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A87)-1)/12)*$E87","v":49.384723180597781},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A87)-1)/12)*$E87","v":56.590539523243073},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A87)-1)/12)*$E87","v":-0.80423041398798933},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A87)-1)/12)*$E87","v":-0.10767035712341995},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A87)-1)/12)*$E87","v":-1.4385731859017465E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A87)-1)/12)*$E87","v":-0.48997386543513943},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A87)-1)/12)*$E87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A87)-1)/12)*$E87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A87)-1)/12)*$E87","v":0},113.83483291992441]
["2014-07-01","2016-04-01","2011-2014","Q3",{"$f":"J$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A88)-1)/12)*$E88","v":9.3916741364901313},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A88)-1)/12)*$E88","v":51.147035373683906},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A88)-1)/12)*$E88","v":57.505879608328293},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A88)-1)/12)*$E88","v":-0.86681956634462587},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A88)-1)/12)*$E88","v":-0.11198271785302505},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A88)-1)/12)*$E88","v":-1.5237740466722657E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A88)-1)/12)*$E88","v":-0.50922734183084484},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A88)-1)/12)*$E88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A88)-1)/12)*$E88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A88)-1)/12)*$E88","v":0},116.54132175200711]
["2014-08-01","2016-05-01",null,"Q3",{"$f":"J$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A89)-1)/12)*$E89","v":9.5075176884911325},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A89)-1)/12)*$E89","v":52.909347566770037},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A89)-1)/12)*$E89","v":58.421219693413505},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A89)-1)/12)*$E89","v":-0.92940871870126229},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A89)-1)/12)*$E89","v":-0.11629507858263015},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A89)-1)/12)*$E89","v":-1.6089749074427846E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A89)-1)/12)*$E89","v":-0.52848081822655024},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A89)-1)/12)*$E89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A89)-1)/12)*$E89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A89)-1)/12)*$E89","v":0},119.24781058408981]
["2014-09-01","2016-06-01",null,"Q3",{"$f":"J$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A90)-1)/12)*$E90","v":9.6233612404921338},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A90)-1)/12)*$E90","v":54.671659759856176},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A90)-1)/12)*$E90","v":59.336559778498732},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A90)-1)/12)*$E90","v":-0.99199787105789894},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A90)-1)/12)*$E90","v":-0.12060743931223526},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A90)-1)/12)*$E90","v":-1.6941757682133039E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A90)-1)/12)*$E90","v":-0.54773429462225565},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A90)-1)/12)*$E90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A90)-1)/12)*$E90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A90)-1)/12)*$E90","v":0},121.95429941617252]
["2014-10-01","2016-07-01",null,"Q4",{"$f":"J$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A91)-1)/12)*$E91","v":9.7392047924931351},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A91)-1)/12)*$E91","v":56.433971952942301},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A91)-1)/12)*$E91","v":60.251899863583958},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A91)-1)/12)*$E91","v":-1.0545870234145354},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A91)-1)/12)*$E91","v":-0.12491980004184036},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A91)-1)/12)*$E91","v":-1.7793766289838232E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A91)-1)/12)*$E91","v":-0.56698777101796094},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A91)-1)/12)*$E91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A91)-1)/12)*$E91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A91)-1)/12)*$E91","v":0},124.66078824825522]
["2014-11-01",null,null,"Q4",{"$f":"J$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A92)-1)/12)*$E92","v":9.8550483444941364},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A92)-1)/12)*$E92","v":58.196284146028432},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A92)-1)/12)*$E92","v":61.167239948669177},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A92)-1)/12)*$E92","v":-1.1171761757711718},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A92)-1)/12)*$E92","v":-0.12923216077144545},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A92)-1)/12)*$E92","v":-1.8645774897543422E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A92)-1)/12)*$E92","v":-0.58624124741366634},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A92)-1)/12)*$E92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A92)-1)/12)*$E92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A92)-1)/12)*$E92","v":0},127.36727708033791]
["2014-12-01",null,null,"Q4",{"$f":"J$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$23:B$24)*(MONTH($A93)-1)/12)*$E93","v":9.9708918964951376},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$23:C$24)*(MONTH($A93)-1)/12)*$E93","v":59.958596339114571},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$23:D$24)*(MONTH($A93)-1)/12)*$E93","v":62.082580033754397},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$23:E$24)*(MONTH($A93)-1)/12)*$E93","v":-1.1797653281278082},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$23:F$24)*(MONTH($A93)-1)/12)*$E93","v":-0.13354452150105056},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$23:G$24)*(MONTH($A93)-1)/12)*$E93","v":-1.9497783505248615E-2},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$23:H$24)*(MONTH($A93)-1)/12)*$E93","v":-0.60549472380937186},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$23:I$24)*(MONTH($A93)-1)/12)*$E93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$23:J$24)*(MONTH($A93)-1)/12)*$E93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$23:K$24)*(MONTH($A93)-1)/12)*$E93","v":0},130.07376591242061]
["2015-01-01",null,null,"Q1",{"$f":"J$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$24)*$E94","v":10.086735448496139},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$24)*$E94","v":61.720908532200703},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$24)*$E94","v":62.997920118839623},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$24)*$E94","v":-1.2423544804844451},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$24)*$E94","v":-0.13785688223065568},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$24)*$E94","v":-2.0349792112953808E-2},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$24)*$E94","v":-0.62474820020507715},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$24)*$E94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$24)*$E94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$24)*$E94","v":0},132.78025474450331]
["2015-02-01",null,null,"Q1",{"$f":"J$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$24)*$E95","v":10.086735448496139},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$24)*$E95","v":61.720908532200703},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$24)*$E95","v":62.997920118839623},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$24)*$E95","v":-1.2423544804844451},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$24)*$E95","v":-0.13785688223065568},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$24)*$E95","v":-2.0349792112953808E-2},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$24)*$E95","v":-0.62474820020507715},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$24)*$E95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$24)*$E95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$24)*$E95","v":0},132.78025474450331]
["2015-03-01",null,null,"Q1",{"$f":"J$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$24)*$E96","v":10.086735448496139},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$24)*$E96","v":61.720908532200703},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$24)*$E96","v":62.997920118839623},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$24)*$E96","v":-1.2423544804844451},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$24)*$E96","v":-0.13785688223065568},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$24)*$E96","v":-2.0349792112953808E-2},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$24)*$E96","v":-0.62474820020507715},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$24)*$E96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$24)*$E96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$24)*$E96","v":0},132.78025474450331]
["2015-04-01",null,null,"Q2",{"$f":"J$29/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$24)*$E97","v":10.086735448496139},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$24)*$E97","v":61.720908532200703},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$24)*$E97","v":62.997920118839623},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$24)*$E97","v":-1.2423544804844451},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$24)*$E97","v":-0.13785688223065568},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$24)*$E97","v":-2.0349792112953808E-2},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$24)*$E97","v":-0.62474820020507715},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$24)*$E97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$24)*$E97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$24)*$E97","v":0},132.78025474450331]
["Total for rate year 2014",null,null,null,null,{"$f":"SUM(F85:F97)","v":319.30648642091313},{"$f":"SUM(G85:G97)","v":1347.8396103309155},{"$f":"SUM(H85:H97)","v":1424.2523854049377},{"$f":"SUM(I85:I97)","v":-13.886562900168254},{"$f":"SUM(J85:J97)","v":-2.3429430228959625},{"$f":"SUM(K85:K97)","v":-0.31483129091895917},{"$f":"SUM(L85:L97)","v":-10.659585703427584},0,0,0,{"$f":"SUM(P85:P97)","v":3064.1945592393567}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F99:O99)","v":0}]
["Opening Balance for rate year 2015",null,null,null,null,{"$f":"F98+F99","v":319.30648642091313},{"$f":"G98+G99","v":1347.8396103309155},1424.2523854049377,-13.886562900168254,-2.3429430228959625,-0.31483129091895917,-10.659585703427584,0,0,0,{"$f":"P98+P99","v":3064.1945592393567}]

{"sheet":"6.0 Rates","index":6,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,0,7,10]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
["Table 6 - Distribution Rates"]
[]
["Rate Class","Billing Unit",2011,2012,2013,2014,"May 1, 2010\nto\nApr 30, 2011","May 1, 2011 to July 31, 2012","Aug 1, 2012 to June 30, 2013","July 1, 2013 to Apr 30, 2014","May 1, 2014 to Apr 30, 2015"]
["For \"Calendar\" rate year",null,null,null,null,null,null,2011,2012,2013,2014]
["Pro-ratio of Rates (months) - Period 1",null,null,null,null,null,null,4,7,6,4]
["Pro-ratio of Rates (months) - Period 2",null,null,null,null,null,null,8,5,6,8]
[]
[{"$f":"'4.0 Approved Load Forecast'!D20","v":"Residential"},{"$f":"'2.0 Customer Classes'!D13","v":"kWh"},{"$f":"SUM(G15*$H$12+H15*$H$13)/12","v":1.2766666666666667E-2},{"$f":"SUM(H15*$I$12+I15*$I$13)/12","v":1.2741666666666665E-2},{"$f":"SUM(I15*$J$12+J15*$J$13)/12","v":1.34E-2},{"$f":"SUM(J15*$K$12+K15*$K$13)/12","v":1.4133333333333333E-2},1.29E-2,1.2699999999999999E-2,1.2800000000000001E-2,1.4E-2,1.4200000000000001E-2]
[{"$f":"'4.0 Approved Load Forecast'!E20","v":"General Service < 50 kW"},{"$f":"'2.0 Customer Classes'!D14","v":"kWh"},{"$f":"SUM(G16*$H$12+H16*$H$13)/12","v":1.5966666666666667E-2},1.594166666666667E-2,1.7049999999999999E-2,{"$f":"SUM(J16*$K$12+K16*$K$13)/12","v":1.83E-2},1.61E-2,1.5900000000000001E-2,1.6E-2,1.8100000000000002E-2,1.84E-2]
[{"$f":"'4.0 Approved Load Forecast'!F20","v":"General Service 50 to 2999 kW"},{"$f":"'2.0 Customer Classes'!D15","v":"kW"},2.9517000000000002,2.902908333333333,3.2038999999999995,3.5259999999999998,3.0657000000000001,2.8946999999999998,2.9144000000000001,3.4933999999999998,3.5423]
[{"$f":"'4.0 Approved Load Forecast'!G20","v":"General Service 3000 to 4999 kW"},{"$f":"'2.0 Customer Classes'!D16","v":"kW"},2.4588666666666668,2.4656583333333333,2.6155499999999998,2.7814333333333336,2.4592000000000001,2.4586999999999999,2.4754,2.7557,2.7942999999999998]
[{"$f":"'4.0 Approved Load Forecast'!H20","v":"Unmetered Scattered Load"},{"$f":"'2.0 Customer Classes'!D17","v":"kWh"},2.4133333333333336E-2,2.4083333333333335E-2,1.7249999999999998E-2,1.0366666666666666E-2,2.4400000000000002E-2,2.4E-2,2.4199999999999999E-2,1.03E-2,1.04E-2]
[{"$f":"'4.0 Approved Load Forecast'!I20","v":"Sentinel Lighting"},{"$f":"'2.0 Customer Classes'!D18","v":"kW"},10.961366666666668,11.729825,11.780699999999998,11.895200000000001,9.4907000000000004,11.6967,11.776199999999999,11.7852,11.950200000000001]
[{"$f":"'4.0 Approved Load Forecast'!J20","v":"Street Lighting "},{"$f":"'2.0 Customer Classes'!D19","v":"kW"},19.583600000000001,21.299366666666668,15.07385,8.8458999999999985,16.272400000000001,21.2392,21.383600000000001,8.7640999999999991,8.8867999999999991]
[{"$f":"'4.0 Approved Load Forecast'!K20","v":"other"},{"$f":"'2.0 Customer Classes'!D20","v":0}]
[{"$f":"'4.0 Approved Load Forecast'!L20","v":"other"},{"$f":"'2.0 Customer Classes'!D21","v":0}]
[{"$f":"'4.0 Approved Load Forecast'!M20","v":"other"},{"$f":"'2.0 Customer Classes'!D22","v":0},{"$f":"IF((G24*4+H24*8)/12=0,\" \",(G24*4+H24*8)/12)","v":" "},{"$f":"IF((H24*4+I24*8)/12=0,\" \",(H24*4+I24*8)/12)","v":" "},{"$f":"IF((I24*4+J24*8)/12=0,\" \",(I24*4+J24*8)/12)","v":" "},{"$f":"IF((J24*4+K24*8)/12=0,\" \",(J24*4+K24*8)/12)","v":" "}]
[]
["References:"]
["Decision & Orders relating to rates:",null,null,null,null,null," EB-2009-0218","EB-2010-0072","EB-2011-0160","EB-2013-0113","EB-2013-0118"]
[null,null,null,null,null,null,null,null,"Updated to EB-2012-0052 (PILs)"]

{"sheet":"7.0 2011LostRev","index":7,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[9,0,10,0],[9,5,9,13],[47,1,47,2],[48,1,48,2],[9,1,10,1],[11,1,11,2],[20,1,20,2],[5,1,5,13],[49,1,49,2],[42,1,42,2],[44,1,44,2],[34,1,34,2],[36,1,36,2],[41,1,41,2],[45,1,45,2],[46,1,46,2],[43,1,43,2],[28,1,28,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'!B10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",5.0830000000000002,35188.552000000003,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",0.77100000000000002,985.59500000000003,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",43.573999999999998,84048.247000000003,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",1.3,21106.559000000001,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",1.899,33184.904999999999,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",0,0,null,null,null,null,null,null,null,null,0]
[7,"Residential Demand Response","Verified",0,0,null,null,null,null,null,null,null,null,0]
[8,"Residential New Construction","Verified",0,0,null,null,null,null,null,null,null,null,0]
[null,"Business Program"]
[9,"Retrofit","Verified",2.6680000000000001,18910.988000000001,null,1,null,null,null,null,null,null,{"$f":"SUM(F22:M22)","v":1}]
[10,"Direct Install Lighting","Verified",43.484999999999999,117589.22100000001,null,1,null,null,null,null,null,null,1]
[11,"Building Commissioning","Verified",0,0,null,null,null,null,null,null,null,null,0]
[12,"New Construction","Verified",0,0,null,null,null,null,null,null,null,null,0]
[13,"Energy Audit","Verified",0,0,null,null,null,null,null,null,null,null,0]
[14,"Commercial Demand Response (part of residential program)","Verified",0,0,null,null,null,null,null,null,null,null,0]
[15,"Demand Response 3","Verified",0,0,null,null,null,null,null,null,null,null,0]
[null,"Industrial Program"]
[16,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F30:M30)","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,null,null,null,null,null,null,0]
[null,"Home Assistance Program"]
[21,"Home Assistance Program","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F36:M36)","v":0}]
[null,"Pre-2011 Programs completed in 2011"]
[22,"Electricity Retrofit Incentive Program","Verified",114.681,662465.43999999994,null,null,{"$f":"112/115","v":0.97391304347826091},{"$f":"3/115","v":2.6086956521739129E-2},null,null,null,null,{"$f":"SUM(F38:M38)","v":1}]
[23,"High Performance New Construction","Verified",9.2999999999999999E-2,475.38900000000001,null,1,null,null,null,null,null,null,1]
[24,"Toronto Comprehensive","Verified",0,0,null,null,null,null,null,null,null,null,0]
[25,"Multifamily Energy Efficiency Rebates","Verified",0,0,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D20,D22:D27,D30:D33,D36,D38:D41)","v":213.554},{"$f":"SUM(E13:E20,E22:E27,E30:E33,E36,E38:E41)","v":973954.89599999995},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17)","v":174513.85800000001},{"$f":"SUM(E22*G22,E23*G23,E39*G39)","v":136975.598},{"$f":"SUM($E$38*H38)","v":645183.73286956514},{"$f":"SUM($E$38*I38)","v":17281.707130434781},{"$f":"SUM($E$22*J22,$E$38*J38,$E$39*J39)","v":0},0,0,null,{"$f":"SUM(F42:M42)","v":973954.89599999995}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM($D$22*H22,$D$38*H38,$D$39*H39)*$A43","v":1340.2718608695652},{"$f":"SUM($D$22*I22,$D$38*I38,$D$39*I39)*$A43","v":35.900139130434781},{"$f":"SUM($D$22*J22,$D$38*J38,$D$39*J39)*$A43","v":0},0,0,null,{"$f":"SUM(F43:M43)","v":1376.172}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D28,D34)","v":0},{"$f":"SUM(E28,E34)","v":0},null,null,{"$f":"SUM($D$28*H28,$D$34*H34)*$A44","v":0},{"$f":"SUM($D$28*I28,$D$34*I34)*$A44","v":0},0,0,0,null,{"$f":"SUM(F44:M44)","v":0}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D42:D44)","v":213.554},{"$f":"SUM(E42:E44)","v":973954.89599999995}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!C15","v":1.2766666666666667E-2},{"$f":"'6.0 Rates'!C16","v":1.5966666666666667E-2},{"$f":"'6.0 Rates'!C17","v":2.9517000000000002},{"$f":"'6.0 Rates'!C18","v":2.4588666666666668},{"$f":"'6.0 Rates'!C19","v":2.4133333333333336E-2},{"$f":"'6.0 Rates'!C20","v":10.961366666666668},{"$f":"'6.0 Rates'!C21","v":19.583600000000001}]
[null,"Lost Revenue in 2011",null,null,null,{"$f":"F42*F46","v":2227.9602538000004},{"$f":"G42*G46","v":2187.0437147333332},{"$f":"SUM(H43,H44)*H46","v":3956.0804517286961},{"$f":"I43*I46","v":88.273655436521736},{"$f":"J43*J46","v":0},0,0,null,{"$f":"SUM(F47:M47)","v":8459.3580756985521}]
[null,"2011 Savings Persisting in 2012",null,null,null,{"$f":"F42*'11.0 Persistence '!C42","v":174334.86942769232},{"$f":"G42*'11.0 Persistence '!C42","v":136835.11020717947},{"$f":"H43*'11.0 Persistence '!C24","v":1252.4811276248338},{"$f":"I43*'11.0 Persistence '!C24","v":33.548601632808044},{"$f":"J43*'11.0 Persistence '!C24","v":0},{"$f":"K43*'11.0 Persistence '!C24","v":0},{"$f":"L43*'11.0 Persistence '!C42","v":0}]
[null,"2011 Savings Persisting in 2013",null,null,null,{"$f":"F42*'11.0 Persistence '!D42","v":174334.86942769232},{"$f":"G42*'11.0 Persistence '!D42","v":136835.11020717947},{"$f":"H43*'11.0 Persistence '!D24","v":1252.4811276248338},{"$f":"I43*'11.0 Persistence '!D24","v":33.548601632808044},{"$f":"J43*'11.0 Persistence '!D24","v":0},{"$f":"K43*'11.0 Persistence '!D24","v":0},{"$f":"L43*'11.0 Persistence '!D42","v":0}]
[null,"2011 Savings Persisting in 2014",null,null,null,{"$f":"F42*'11.0 Persistence '!E42","v":168786.22368615383},{"$f":"G42*'11.0 Persistence '!E42","v":132479.98862974357},{"$f":"H43*'11.0 Persistence '!E24","v":1188.1012565786975},{"$f":"I43*'11.0 Persistence '!E24","v":31.824140801215112},{"$f":"J43*'11.0 Persistence '!E24","v":0},{"$f":"K43*'11.0 Persistence '!E24","v":0},{"$f":"L43*'11.0 Persistence '!E42","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,null,null,null,null,{"$f":"N42-E42","v":0}]
[]
[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'!B10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",4.6749999999999998,29799.859,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",5.9619999999999997,10401.995000000001,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",27.831,51118.478000000003,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",0.26,1578.877,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",1.671,30242.392,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",0,0,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",0,0,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",0,0,1,null,null,null,null,null,null,null,{"$f":"SUM(F20:M20)","v":1}]
[9,"Residential New Construction","Verified",0,0,1,null,null,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["3a","HVAC Incentives","True-Up",-7.351,-13972.448,1,null,null,null,null,null,null,null,1]
["4a","Conservation Instant Coupon Booklet","True-Up",null,311.27499999999998,1,null,null,null,null,null,null,null,1]
["5a","Bi-Annual Retailer Event","True-Up",null,2465.5279999999998,1,null,null,null,null,null,null,null,1]
[null,"Business Program"]
[10,"Retrofit","Verified",132.988,446895.09,null,{"$f":"1-H27","v":0.5871122087638162},{"$f":"(25808.49+12264.82+328059.46)/886760.95","v":0.4128877912361838},null,null,null,null,null,{"$f":"SUM(F27:M27)","v":1}]
[11,"Direct Install Lighting","Verified",56.344000000000001,217952.96599999999,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",0,0,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",0,0,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",0,0,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",0,0,null,null,null,null,null,null,null,null,{"$f":"SUM(F32:M32)","v":0}]
[16,"Small Commercial Demand Response (IHD)","Verified",0,0,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",17.495999999999999,254.31299999999999,null,null,1,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["11a","Direct Install Lighting","True-Up",39.963999999999999,280174.69300000003,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",null,null,null,null,null,null,null,null,null,null,0]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F44:M44)","v":0}]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F46:M46)","v":0}]
[25,"High Performance New Construction","Verified",null,123.625,null,1,null,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,null,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":0}]
[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":262.34399999999999},{"$f":"SUM(E13:E25,E27:E33,E35:E36,E38:E41,E44,E46:E52,E54:E55)","v":1057092.33},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E23*F23,E24*F24,E25*F25)","v":111945.95599999999},{"$f":"SUM($E$27*G27,$E$28*G28,$E$36*G36,$E$47*G47)","v":760628.84737560456},{"$f":"SUM($E$27*H27,$E$28*H28,$E$36*H36,$E$47*H47)","v":184517.52662439557},{"$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":1057092.33}]
[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":658.90945897101142},{"$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":658.90945897101142}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D42)","v":17.495999999999999},{"$f":"SUM(E34,E42)","v":254.31299999999999},null,null,{"$f":"SUM($D$34*H34)*$A$58","v":87.47999999999999},{"$f":"SUM($D$34*I34,$D$42*I42)*$A$58","v":0},0,0,0,null,{"$f":"SUM(F58:M58)","v":87.47999999999999}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D56:D58)","v":279.83999999999997},{"$f":"SUM(E56:E58)","v":1057346.6430000002}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!D15","v":1.2741666666666665E-2},{"$f":"'6.0 Rates'!D16","v":1.594166666666667E-2},{"$f":"'6.0 Rates'!D17","v":2.902908333333333},{"$f":"'6.0 Rates'!D18","v":2.4656583333333333},{"$f":"'6.0 Rates'!D19","v":2.4083333333333335E-2},{"$f":"'6.0 Rates'!D20","v":11.729825},{"$f":"'6.0 Rates'!D21","v":21.299366666666668}]
[null,"Lost Revenue in 2012 from 2012",null,null,null,{"$f":"F56*F60","v":1426.378056033333},{"$f":"G56*G60","v":12125.691541912765},{"$f":"SUM(H57,H58)*H60","v":2166.700180359107},{"$f":"SUM(I57,I58)*I60","v":0},{"$f":"J57*J60","v":0},0,0,null,{"$f":"SUM(F61:M61)","v":15718.769778305204}]
[null,"Lost Revenue in 2012 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F48*F60","v":2221.3167946245126},{"$f":"'7.0 2011LostRev'!G48*G60","v":2181.3797152194534},{"$f":"'7.0 2011LostRev'!H48*H60","v":3635.8379027248598},{"$f":"'7.0 2011LostRev'!I48*I60","v":82.71938918761343},{"$f":"'7.0 2011LostRev'!J48*J60","v":0},{"$f":"'7.0 2011LostRev'!K48*K60","v":0},{"$f":"'7.0 2011LostRev'!L48*L60","v":0},null,{"$f":"SUM(F62:M62)","v":8121.2538017564393}]
[null,"Total Lost Revenue in 2012",null,null,null,{"$f":"SUM(F61:F62)","v":3647.6948506578456},{"$f":"SUM(G61:G62)","v":14307.071257132218},5802.5380830839667,82.71938918761343,0,0,0,null,{"$f":"SUM(N61:N62)","v":23840.023580061643}]
[null,"2012 Savings Persisting in 2013",null,null,null,{"$f":"F56*'11.0 Persistence '!D43","v":106120.9535591296},{"$f":"G56*'11.0 Persistence '!D43","v":721050.24131537916},{"$f":"H57*'11.0 Persistence '!D25","v":578.89902466738852},{"$f":"I57*'11.0 Persistence '!D25","v":0},{"$f":"J57*'11.0 Persistence '!D25","v":0},{"$f":"K57*'11.0 Persistence '!D25","v":0},{"$f":"L57*'11.0 Persistence '!D43","v":0}]
[null,"2012 Savings Persisting in 2014",null,null,null,{"$f":"F56*'11.0 Persistence '!E43","v":102731.86122989592},{"$f":"G56*'11.0 Persistence '!E43","v":698022.68869852077},{"$f":"H57*'11.0 Persistence '!E25","v":555.3665439898524},{"$f":"I57*'11.0 Persistence '!E25","v":0},{"$f":"J57*'11.0 Persistence '!E25","v":0},{"$f":"K57*'11.0 Persistence '!E25","v":0},{"$f":"L57*'11.0 Persistence '!E43","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":"8.1 2012 Gross to Net Savings","index":9,"n_rows":43,"n_cols":73,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,0,6,1],[7,0,7,1],[7,13,7,42],[7,43,7,72]]}
[null,null,"LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Table 9: 2012 Gross to Net Savings"]
["Orillia Power Distribution Corporation"]
["Table is at the End User Level",null,null,null,null,null,null,null,null,null,null,null,null,"Net Annual Summer Peak Demand Savings (MW)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Annual Energy Savings (MWh)"]
["Portfolio","Program","Initiative","LDC","Sector","Conservation Resource Type ","(Implementation) Year","Status","Notes:","Activity Unit Name","Activity and Participation\n(i.e. # of appliances)","Gross Summer Peak \nDemand Savings (MW)","Gross Energy \nSavings (MWh)",2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
["Tier 1","Business","Direct Install Lighting","Centre Wellington Hydro Ltd.","C&I","EE",2012,"Final; Released August 31, 2013","","Projects",58,5.9728626893679485E-2,231.36303701388758,0,5.6344428164709665E-2,5.6344428164709665E-2,5.6344428164709665E-2,3.5267132128002927E-2,3.5213215369312809E-2,5.6110153218480816E-3,5.6110153218480816E-3,5.6110153218480816E-3,5.6110153218480816E-3,5.6110153218480816E-3,5.1484247284996126E-3,5.1484247284996126E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,217.95296565182056,217.95296565182056,217.95296565182056,129.04133292760338,128.75075130022148,22.887643729032224,22.887643729032224,22.887643729032224,22.887643729032224,22.887643729032224,18.361295513031823,18.361295513031823,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Business","Retrofit","Centre Wellington Hydro Ltd.","C&I","EE",2012,"Final; Released August 31, 2013",null,"Projects",15,0.16631369452065828,550.02457805617473,0,0.13298825537286091,0.11615077671298987,0.10624140369164198,6.4101827696446359E-2,6.4101827696446359E-2,6.138768796469931E-2,6.1292286722161797E-2,6.1292286722161797E-2,6.0783082424663085E-2,5.9496608332669898E-2,5.7966436056037449E-2,5.7966436056037449E-2,5.39016925447343E-2,9.6835352982421359E-3,9.6835352982421359E-3,3.5159344351101051E-3,3.5159344351101051E-3,3.5159344351101051E-3,3.5159344351101051E-3,3.5159344351101051E-3,0,0,0,0,0,0,0,0,0,0,446.89509034690218,392.06895693819257,359.80209452725893,220.98684811764886,220.98684811764886,212.00893936106436,211.68012689116966,211.68012689116966,209.99576640378186,205.56177044741344,188.7356100767322,188.7356100767322,163.89117848210432,19.908184516305258,19.908184516305258,11.630108127201469,11.630108127201469,11.630108127201469,11.630108127201469,11.630108127201469,0,0,0,0,0,0,0,0,0]
["Tier 1","Consumer","Appliance Exchange","Centre Wellington Hydro Ltd.","Residential","EE",2012,"Final; Released August 31, 2013",null,"Appliances",41.433620327111321,1.156877529654355E-2,20.183737706921349,0,5.9621433412411825E-3,5.9621433412411825E-3,5.9621433412411825E-3,5.7046349454267136E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10.401994531489752,10.401994531489752,10.401994531489752,10.17171651026311,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Consumer","Appliance Retirement","Centre Wellington Hydro Ltd.","Residential","EE",2012,"Final; Released August 31, 2013",null,"Appliances",76.373771688213139,1.0367657366396343E-2,64.028889871853465,0,4.6747701263870787E-3,4.6747701263870787E-3,4.6747701263870787E-3,4.4455623021455006E-3,2.2603305944096865E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29.799859107336903,29.799859107336903,29.799859107336903,29.594888997336906,17.191476653999977,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Consumer","Bi-Annual Retailer Event","Centre Wellington Hydro Ltd.","Residential","EE",2012,"Final; Released August 31, 2013",null,"Products",1197.9899309845848,1.8318501485417265E-3,32.998137008927984,0,1.6712262382713651E-3,1.6712262382713651E-3,1.6712262382713651E-3,1.6712262382713651E-3,1.5297056498734217E-3,1.2944914639783566E-3,9.6909890429048402E-4,9.6552085844276131E-4,9.6552085844276131E-4,6.226750509573392E-4,2.4361489383057814E-4,2.4359350399770011E-4,2.4359350399770011E-4,2.3941325954147851E-4,2.3941325954147851E-4,2.3346488271150785E-4,6.5505742849923017E-5,6.5505742849923017E-5,6.5505742849923017E-5,6.5505742849923017E-5,0,0,0,0,0,0,0,0,0,0,30.242391579478166,30.242391579478166,30.242391579478166,30.242391579478166,27.185986143470735,22.106089822136713,15.078620536396816,15.047276854770763,15.047276854770763,7.642871590681068,5.6720076170194176,5.4957309249005615,5.4957309249005615,5.1120470887935276,5.1120470887935276,5.0421168023257046,1.414720718749636,1.414720718749636,1.414720718749636,1.414720718749636,0,0,0,0,0,0,0,0,0]
["Tier 1","Consumer","Conservation Instant Coupon Booklet","Centre Wellington Hydro Ltd.","Residential","EE",2012,"Final; Released August 31, 2013",null,"Products",34.882569558468433,2.6073677026455165E-4,1.497230409062158,0,2.6018977357492913E-4,2.6018977357492913E-4,2.6018977357492913E-4,2.6018977357492913E-4,2.590914564372744E-4,2.590914564372744E-4,2.2099159730681431E-4,2.2053021771066059E-4,2.2053021771066059E-4,2.2053021771066059E-4,4.0565846391544608E-6,4.0537909287676195E-6,4.0537909287676195E-6,3.9078175437845963E-6,3.9078175437845963E-6,3.6502106731953163E-6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.5788769418256752,1.5788769418256752,1.5788769418256752,1.5788769418256752,1.5551567007781415,1.5551567007781415,0.73231800376811718,0.72827631850581043,0.72827631850581043,0.72827631850581043,0.11828323750758514,9.5259868015228094E-2,9.5259868015228094E-2,8.1861697428228852E-2,8.1861697428228852E-2,7.8833220455212932E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Consumer","HVAC Incentives","Centre Wellington Hydro Ltd.","Residential","EE",2012,"Final; Released August 31, 2013",null,"Installations",109.02646061808383,5.6780082370752757E-2,104.97019970855072,0,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.783146215065254E-2,2.5314049551066385E-2,0,0,0,0,0,0,0,0,0,0,0,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,51.118478322377513,48.867270977427907,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Pre-2011 Programs Completed in 2011","High Performance New Construction","Centre Wellington Hydro Ltd.","C&I","EE",2012,"Final; Released August 31, 2013","Projects","Projects",1.1292196018523875E-3,1.276018150093198E-4,0.1236252681813966,0,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,1.276018150093198E-4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0.1236252681813966,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1","Business","Demand Response 3 (part of the Industrial program schedule)","Centre Wellington Hydro Ltd.","C&I","DR",2012,"Final; Released August 31, 2013",null,"Facilities",1,1.7496226500000003E-2,0.25431320000000002,0,1.7496226500000003E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.25431320000000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N10:N18)","v":0},{"$f":"SUM(O10:O18)","v":0.24735630348270699},0.21302259832283596,0.20311322530148807,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR10:AR18)","v":0},{"$f":"SUM(AS10:AS18)","v":788.36759494941225},{"$f":"SUM(AT10:AT18)","v":733.28714834070263},{"$f":"SUM(AU10:AU18)","v":701.02028592976899}]
[]
["Tier 1 True Up","Business","Retrofit","Centre Wellington Hydro Ltd.","C&I","EE",2011,"Final; Released August 31, 2013",null,"Projects",3,5.3682380884934447E-2,368.39817624663146,3.9964107915485547E-2,3.9964107915485547E-2,3.9964107915485547E-2,3.9964107915485547E-2,3.9964107915485547E-2,3.9964107915485547E-2,3.92846059250751E-2,3.92846059250751E-2,3.92846059250751E-2,3.92846059250751E-2,3.92846059250751E-2,3.92846059250751E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,280.17469323690023,280.17469323690023,280.17469323690023,280.17469323690023,280.17469323690023,280.17469323690023,277.54465132148579,277.54465132148579,277.54465132148579,277.54465132148579,277.54465132148579,277.54465132148579,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1 True Up","Pre-2011 Programs Completed in 2011","High Performance New Construction","Centre Wellington Hydro Ltd.","C&I","EE",2011,"Final; Released August 31, 2013",null,"Buildings",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1 True Up","Consumer","HVAC Incentives","Centre Wellington Hydro Ltd.","Residential","EE",2011,"Final; Released August 31, 2013",null,"Installations",-24.377159347018697,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-7.3514421739217604E-3,-6.3681529961421516E-3,0,0,0,0,0,0,0,0,0,0,0,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.972447727434892,-13.094642575668516,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1 True Up","Consumer","Bi-Annual Retailer Event","Centre Wellington Hydro Ltd.","Residential","EE",2011,"Final; Released August 31, 2013",null,"Products",92.38936016475644,1.3167758847500862E-4,2.6803342480306687,1.2180222372070542E-4,1.2180222372070542E-4,1.2180222372070542E-4,1.2180222372070542E-4,1.2180222372070542E-4,1.1138083142194219E-4,6.3649018925765645E-5,6.362088819383855E-5,6.362088819383855E-5,1.9977579927231418E-5,8.3004368455222296E-6,8.2982148925275303E-6,8.2982148925275303E-6,7.9166654705718043E-6,7.9166654705718043E-6,7.8991948175532335E-6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.4655276607785468,2.4655276607785468,2.4655276607785468,2.4655276607785468,2.4655276607785468,2.2404579346469617,1.2095989420770745,1.2093525168653931,1.2093525168653931,0.26679252512538759,0.22413543496438007,0.20582400045328209,0.20582400045328209,0.17080347775095309,0.17080347775095309,0.17059808932226225,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tier 1 True Up","Consumer","Conservation Instant Coupon Booklet","Centre Wellington Hydro Ltd.","Residential","EE",2011,"Final; Released August 31, 2013",null,"Products",9.2776682488192446,1.6493013204956059E-5,0.28905249023917701,1.8179297034201184E-5,1.8179297034201184E-5,1.8179297034201184E-5,1.8179297034201184E-5,1.8179297034201184E-5,1.6935181616358576E-5,1.1845309623548079E-5,1.1818190940629628E-5,1.1818190940629628E-5,6.6080125744829521E-6,8.734895871733886E-7,8.725682209127871E-7,8.725682209127871E-7,8.4991267574284899E-7,8.4991267574284899E-7,8.3436826602409669E-7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.31127518320938102,0.31127518320938102,0.31127518320938102,0.31127518320938102,0.31127518320938102,0.28440615186093537,0.17448071554446171,0.17424315588209607,0.17424315588209607,6.1719475327002761E-2,2.7875059585249516E-2,2.0281947587838738E-2,2.0281947587838738E-2,1.8202507839533925E-2,1.8202507839533925E-2,1.8019764705452607E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N21:N25)","v":3.2752647262318697E-2},{"$f":"SUM(O21:O25)","v":3.2752647262318697E-2},3.2752647262318697E-2,3.2752647262318697E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR21:AR25)","v":268.97904835345327},{"$f":"SUM(AS21:AS25)","v":268.97904835345327},{"$f":"SUM(AT21:AT25)","v":268.97904835345327},268.97904835345327]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"GWh",{"$f":"(N19+N26)/1000","v":3.2752647262318695E-5},{"$f":"(O19+O26)/1000","v":2.8010895074502567E-4},2.4577524558515464E-4,2.3586587256380675E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AR19+AR26)/1000","v":0.26897904835345327},{"$f":"(AS19+AS26)/1000","v":1.0573466433028655},{"$f":"(AT19+AT26)/1000","v":1.002266196694156},0.96999933428322216]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MW",{"$f":"N19+N26","v":3.2752647262318697E-2},{"$f":"O19+O26","v":0.28010895074502568},0.24577524558515465,0.23586587256380676,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR19+AR26","v":268.97904835345327},{"$f":"AS19+AS26","v":1057.3466433028655},{"$f":"AT19+AT26","v":1002.266196694156},{"$f":"AU19+AU26","v":969.9993342832222}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"kW",{"$f":"N30*1000","v":32.752647262318696},{"$f":"O30*1000","v":280.10895074502565},245.77524558515466,235.86587256380676,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR30*1000","v":268979.04835345328},{"$f":"AS30*1000","v":1057346.6433028656},{"$f":"AT30*1000","v":1002266.1966941559},{"$f":"AU30*1000","v":969999.33428322221}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj to Previous Year's Verified Results",{"$f":"O28","v":2.8010895074502567E-4},"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adj to Previous Year's Verified Results",{"$f":"AS26","v":268.97904835345327},"MWh"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Efficiency Total",{"$f":"SUM(O10+O17)+O19","v":0.30382833346242599},"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Efficiency Total",{"$f":"AS19","v":788.36759494941225},"MWh"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand Response",0,"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand Response",0,"MWh"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPA- Contract LDC Portfolio (MWh)",{"$f":"O35+O37+O39","v":0.30410844241317103},"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPA- Contract LDC Portfolio (MWh)",{"$f":"AS35+AS37+AS39","v":1057.3466433028655},"MWh"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECK: Variance to LDC Summary sheet",{"$f":"SUM((O41-('8.0 2012LostRev'!D59/1000)))","v":2.4268442413171054E-2},"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECK: Variance to LDC Summary sheet",{"$f":"SUM((AS41-('8.0 2012LostRev'!E59/1000)))","v":3.0286537366919219E-7},"MWh"]

{"sheet":"9.0 2013LostRev","index":10,"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'!B10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",3.6429999999999998,21580.708999999999,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",2.0720000000000001,3694.3989999999999,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",28.317,50936.682000000001,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",0.58299999999999996,8703.5419999999995,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",1.337,19399.812999999998,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",0,0,null,null,null,null,null,null,null,null,0]
[7,"Residential Demand Response (switch/pstat)","Verified",4.2249999999999996,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",0,null,null,null,null,null,null,null,null,null,0]
[9,"Residential New Construction","Verified",0,null,null,null,null,null,null,null,null,null,0]
[null,"2012 True-up (Verified Errors & Omissions)",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"HVAC Incentives","True-up",0.50600000000000001,1112.9590000000001,1,null,null,null,null,null,null,null,1]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[null,"Business Program"]
[10,"Retrofit","Verified",88.721999999999994,356535.91100000002,null,{"$f":"(4555.2+13360.14+45715.68+20701.44)/563617.64","v":0.14962707696657615},{"$f":"(33120+441400+4765.178)/563617.64","v":0.85037291948491889},null,null,null,null,null,{"$f":"SUM(F27:M27)","v":0.99999999645149507}]
[11,"Direct Install Lighting","Verified",57.048000000000002,192984.00099999999,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",0,0,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",0,0,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",0,0,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",0,0,null,null,null,null,null,null,null,null,0]
[16,"Small Commercial Demand Response (IHD)","Verified",0,0,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",17.744,236.934,null,null,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Direct Install Lighting","True-up",2.3780000000000001,8562.6149999999998,null,1,null,null,null,null,null,null,1]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[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",484.18900000000002,11025.27,null,null,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",1.0660000000000001,14297.735000000001,1,null,null,null,null,null,null,null,{"$f":"SUM(F48:M48)","v":1}]
[null,"2012 True-up (Verified Errors & Omissions)",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"True-up",null,null,null,null,null,null,null,null,null,null,0]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":0}]
[25,"High Performance New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[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,null,null,null,null,null,null,null,null,null,0]
[null,null,"True-up",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(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:D18,D27:D33,D40:D43,D48,D52:D56,D60:D61)","v":182.78799999999998},{"$f":"SUM(E13:E23,E27:E33,E40:E43,E48,E52:E56,E60:E61,E36)","v":677808.36600000004},{"$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":119725.83900000001},{"$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":254894.04219654534},{"$f":"SUM($E$27*H27,$E$28*H28,$E$29*H29,$E$30*H30,$E$31*H31,$E$36*H36,$E$37*H37,$E$38*H38)","v":303188.48353828525},{"$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":677808.36473483057}]
[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,H34*D34,H44*D44)*$A63","v":6928.5574339504919},{"$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":6928.5574339504919}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D44,D19)","v":506.15800000000002},{"$f":"SUM(E34,E44)","v":11262.204},null,null,{"$f":"SUM($D$34*H34,$D$44*H44)*$A64","v":2509.665},{"$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":2509.665}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D62:D64)","v":688.94600000000003},{"$f":"SUM(E62:E64)","v":689070.57000000007}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!E15","v":1.34E-2},{"$f":"'6.0 Rates'!E16","v":1.7049999999999999E-2},{"$f":"'6.0 Rates'!E17","v":3.2038999999999995},{"$f":"'6.0 Rates'!E18","v":2.6155499999999998},{"$f":"'6.0 Rates'!E19","v":1.7249999999999998E-2},{"$f":"'6.0 Rates'!E20","v":11.780699999999998},{"$f":"'6.0 Rates'!E21","v":15.07385}]
[null,"Lost Revenue in 2013 from 2013",null,null,null,{"$f":"F62*F66","v":1604.3262426000001},{"$f":"G62*G66","v":4345.9434194510977},{"$f":"SUM(H63,H64)*H66","v":30239.120856133977},{"$f":"SUM(I63,I64)*I66","v":0},{"$f":"J63*J66","v":0},0,0,null,{"$f":"SUM(F67:M67)","v":36189.390518185071}]
[null,"Lost Revenue in 2013 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F64*F66","v":1422.0207776923367},{"$f":"'8.0 2012LostRev'!G64*G66","v":12293.906614427215},{"$f":"'8.0 2012LostRev'!H64*H66","v":1854.7345851318457},{"$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":15570.661977251397}]
[null,"Lost Revenue in 2013 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F49*F66","v":2336.087250331077},{"$f":"'7.0 2011LostRev'!G49*G66","v":2333.03862903241},{"$f":"'7.0 2011LostRev'!H49*H66","v":4012.8242847972042},{"$f":"'7.0 2011LostRev'!I49*I66","v":87.748045000691079},{"$f":"'7.0 2011LostRev'!J49*J66","v":0},{"$f":"'7.0 2011LostRev'!K49*K66","v":0},{"$f":"'7.0 2011LostRev'!L49*L66","v":0},null,8769.6982091613827]
[null,"Total Lost Revenue in 2013",null,null,null,{"$f":"SUM(F67:F69)","v":5362.4342706234138},{"$f":"SUM(G67:G69)","v":18972.888662910722},{"$f":"SUM(H67:H69)","v":36106.679726063026},87.748045000691079,0,0,0,null,{"$f":"SUM(N67:N69)","v":60529.750704597849}]
[null,"2013 Savings Persisting in 2014",null,null,null,{"$f":"F62*'11.0 Persistence '!E44","v":117640.62845137884},{"$f":"G62*'11.0 Persistence '!E44","v":250454.66845727319},{"$f":"H63*'11.0 Persistence '!E26","v":1862.3001195300455},{"$f":"I63*'11.0 Persistence '!E26","v":0},{"$f":"J63*'11.0 Persistence '!E26","v":0},{"$f":"K63*'11.0 Persistence '!E26","v":0},{"$f":"L63*'11.0 Persistence '!E44","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":11,"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'!B10","v":"Residential"},{"$f":"'3.0 LRAMVA Register'!C10","v":"General Service < 50 kW"},{"$f":"'3.0 LRAMVA Register'!D10","v":"General Service 50 to 2999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"General Service 3000 to 4999 kW"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!H10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",null,null,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",null,null,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",null,null,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",null,null,null,0.2,0.8,null,null,null,null,null,{"$f":"SUM(F23:M23)","v":1}]
[11,"Direct Install Lighting","Verified",null,null,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",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",null,null,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[23,"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"]
[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":0},{"$f":"SUM(E13:E21,E23:E29,E32:E35,E38,E40:E44,E46:E47)","v":0},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E38*F38)","v":0},{"$f":"SUM(E23*G23,E24*G24)","v":0},{"$f":"SUM(E23*H23,E30*H30,E36*H36,E40*H40,E41*H41)","v":0},null,null,null,null,null,{"$f":"SUM(F48:M48)","v":0}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM(D23*H23,D40*H40,D41*H41)*$A49","v":0},null,null,null,null,null,{"$f":"SUM(F49:M49)","v":0}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D30,D36)","v":0},{"$f":"SUM(E30,E36)","v":0},null,null,{"$f":"SUM(D30*H30,D36*H36)*$A50","v":0},null,null,null,null,null,{"$f":"SUM(F50:M50)","v":0}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D48:D50)","v":0},{"$f":"SUM(E48:E50)","v":0}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!F15","v":1.4133333333333333E-2},{"$f":"'6.0 Rates'!F16","v":1.83E-2},{"$f":"'6.0 Rates'!F17","v":3.5259999999999998},{"$f":"'6.0 Rates'!F18","v":2.7814333333333336},{"$f":"'6.0 Rates'!F19","v":1.0366666666666666E-2},{"$f":"'6.0 Rates'!F20","v":11.895200000000001},{"$f":"'6.0 Rates'!F21","v":8.8458999999999985}]
[null,"Lost Revenue in 2014 from 2014",null,null,null,{"$f":"F48*F52","v":0},{"$f":"G48*G52","v":0},{"$f":"SUM(H49,H50)*H52","v":0},{"$f":"SUM(I49,I50)*I52","v":0},{"$f":"J49*J52","v":0},0,0,null,{"$f":"SUM(F53:M53)","v":0}]
[null,"Lost Revenue in 2014 from 2013",null,null,null,{"$f":"'9.0 2013LostRev'!F71*F52","v":1662.6542154461542},{"$f":"'9.0 2013LostRev'!G71*G52","v":4583.3204327680996},{"$f":"'9.0 2013LostRev'!H71*H52","v":6566.4702214629406},{"$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":12812.444869677194}]
[null,"Lost Revenue in 2014 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F65*F52","v":1451.9436387158623},{"$f":"'8.0 2012LostRev'!G65*G52","v":12773.81520318293},{"$f":"'8.0 2012LostRev'!H65*H52","v":1958.2224341082194},{"$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":16183.981276007013}]
[null,"Lost Revenue in 2014 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F50*F52","v":2385.5119614309738},{"$f":"'7.0 2011LostRev'!G50*G52","v":2424.3837919243074},{"$f":"'7.0 2011LostRev'!H50*H52","v":4189.2450306964874},{"$f":"'7.0 2011LostRev'!I50*I52","v":88.516726029193094},{"$f":"'7.0 2011LostRev'!J50*J52","v":0},{"$f":"'7.0 2011LostRev'!K50*K52","v":0},{"$f":"'7.0 2011LostRev'!L50*L52","v":0},null,9087.6575100809605]
[null,"Total Lost Revenue in 2014",null,null,null,{"$f":"SUM(F53:F56)","v":5500.1098155929903},{"$f":"SUM(G53:G56)","v":19781.519427875341},12713.937686267647,88.516726029193094,0,0,0,null,{"$f":"SUM(N53:N56)","v":38084.083655765164}]
[]
[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 Persistence ","index":12,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[21,0,21,5],[22,0,22,4],[40,0,40,4],[37,0,37,4],[38,0,38,4],[28,0,28,5],[30,0,31,0],[30,1,30,4],[36,0,36,4],[29,0,29,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.22900000000000001,0.214,0.214,0.20300000000000001]
["2012 - Verified",3.3000000000000002E-2,0.28000000000000003,0.246,0.23599999999999999]
[2013,0,3.0000000000000001E-3,0.69199999999999995,0.186]
[2014]
["Verified Net Annual Peak Demand Savings Persisting in 2014:  ",null,null,null,0.625]
["2011-2014 CDM Capacity Target",null,null,null,1.64]
["Verified Portion of Peak Demand Savings Target Achieved in 2014(%):  ",null,null,null,{"$f":"E19/E20","v":0.38109756097560976}]
[]
["Persistence Factor (MW)"]
[2011,null,{"$f":"C15/$B$15","v":0.93449781659388642},{"$f":"D15/$B$15","v":0.93449781659388642},{"$f":"E15/$B$15","v":0.88646288209606994}]
[2012,null,null,{"$f":"D16/$C$16","v":0.87857142857142845},{"$f":"E16/$C$16","v":0.84285714285714275}]
[2013,null,null,null,{"$f":"+E17/D17","v":0.26878612716763006}]
[]
[]
["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.97499999999999998,0.97399999999999998,0.97399999999999998,0.94299999999999995,3.8660000000000001]
["2012 - Verified",0.26900000000000002,1.0569999999999999,1.002,0.97,3.298]
[2013,0,0.01,0.68899999999999995,0.67700000000000005,1.3759999999999999]
[2014,null,null,null,null,{"$f":"SUM(B36:E36)","v":0}]
["Verified Net Cumulative Energy Savings 2011-2014:",null,null,null,null,8.5399999999999991]
[" 2011-2014 CDM Energy Target",null,null,null,null,7.81]
["Verified Portion of Cumulative Energy Target Achieved (%):  ",null,null,null,null,{"$f":"F37/F38","v":1.0934699103713188}]
[]
["Persistence Factor (GWh)"]
[2011,null,{"$f":"C33/$B$33","v":0.99897435897435893},{"$f":"D33/$B$33","v":0.99897435897435893},{"$f":"E33/$B$33","v":0.9671794871794871}]
[2012,null,null,{"$f":"D34/$C$34","v":0.94796594134342482},{"$f":"E34/$C$34","v":0.91769157994323558}]
[2013,null,null,null,{"$f":"E35/D35","v":0.98258345428156768}]

{"sheet":"CDM in 2013 CoS","index":13,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["The following table reflects the CDM adjusted kWh and kW by rate class for CWH."]
[]
["Rate Class","Billed Load Forecast Prior to CDM Adjustment kWh","Billed Load Forecast After CDM Adjustment kWh","CDM Adjustment kWh"]
["Residential",46118694,45809827,{"$f":"B4-C4","v":308867}]
["GS<50 kW",20545642,20408044,{"$f":"B5-C5","v":137598}]
["GS>50 kW to 2,999 kW",61722677,61309307,413370]
["GS>3,000 to 4,999 kW",17074303,16959953,114350]
["Sentinel Lights",37713,37461,252]
["Street Lights",1137812,1130191,7621]
["Unmetered Scattered Load",608453,604378,4075]
["Total Billed kWh",{"$f":"SUM(B4:B10)","v":147245294},{"$f":"SUM(C4:C10)","v":146259161},986133]
[]
[]
[]
["Rate Class","Billed Load Forecast Prior to CDM Adjustment kW","Billed Load Forecast After CDM Adjustment kW","CDM Adjustment kW"]
["GS>50 kW to 2,999 kW",{"$f":"61722677*0.002571218","v":158702.45811058601},{"$f":"C6*0.002571218","v":157639.59372592601},{"$f":"B16-C16","v":1062.8643846600025}]
["GS>3,000 to 4,999 kW",{"$f":"17074303*0.002206117","v":37667.910111450998},{"$f":"C7*0.002206117","v":37415.640632501003},252.26947894999466]
["Sentinel Lights",{"$f":"37713*0.002778","v":104.76671400000001},{"$f":"C8*0.002778","v":104.066658},0.70005600000000356]
["Street Lights",{"$f":"1137812*0.002798","v":3183.597976},{"$f":"C9*0.002798","v":3162.274418},21.323558000000048]
["Total Billed kWh",{"$f":"SUM(B16:B19)","v":199658.732912037},{"$f":"SUM(C16:C19)","v":198321.57543442698},{"$f":"SUM(D16:D19)","v":1337.1574776099972}]
[]
[]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,null," "]