{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1.0 LDC Info","2.0 Customer Classes","Instructions","3.0 LRAMVA Register","4.0 Approved Load Forecast","5.0 Carrying Charges","6.0 Rates","7.0 2011LostRev","8.0 2012LostRev","9.0 2013LostRev","10.0 2014LostRev","11.0 Persistence ","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":18,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1.0 LDC Info","index":0,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,4,18,8],[20,4,20,8],[30,2,30,11],[32,2,32,12],[8,0,8,10],[10,4,10,10],[12,4,12,8],[14,4,14,8],[16,4,16,8],[16,9,16,10]]}
["LRAMVA Model version 1.0 © CHEC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
["LDC Info"]
[]
[null,null,null,"Utility Name   ","Innisfil Hydro Distribution Systems Limited"]
[]
[null,null,null,"Service Territory"]
[]
[null,null,null,"Assigned EB Number","EB-2012-0139"]
[]
[null,null,null,"Name of Contact and Title","Brenda L Pinke"]
[]
[null,null,null,"Phone Number   ","705-431-6870 Ext 262"]
[]
[null,null,null,"Email Address   ","brendap@innisfilhydro.com"]
[]
[null,null,null,"Bridge Year",2012]
[]
[null,null,null,"Test Year",2013]
[]
[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 4999 kW","Existing","Customer","kW"]
["Unmetered Scattered Load","Existing","Connection","kW"]
["Sentinel Lighting","Existing","Connection","kWh"]
["Street Lighting ","Existing","Connection","kW"]
["other"]
["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":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[53,1,53,2],[53,3,53,4],[53,5,53,6]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[null,null,null,null,"Table 1 - LRAMVA register"]
[]
["Verified results updated ",2014]
[]
["Description",{"$f":"'2.0 Customer Classes'!$A13","v":"Residential"},{"$f":"'2.0 Customer Classes'!$A14","v":"General Service < 50 kW"},{"$f":"'2.0 Customer Classes'!$A15","v":"General Service > 50 to 4999 kW"},{"$f":"'2.0 Customer Classes'!$A16","v":"Unmetered Scattered Load"},{"$f":"'2.0 Customer Classes'!$A17","v":"Sentinel Lighting"},{"$f":"'2.0 Customer Classes'!$A18","v":"Street Lighting "},{"$f":"'2.0 Customer Classes'!$A19","v":"other"},{"$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"]
["2011 CDM 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},null,"No CDM component for 2011"]
["2011 Verified",{"$f":"'7.0 2011LostRev'!F47","v":7645.7717999999995},{"$f":"'7.0 2011LostRev'!G47","v":1264.8574000000001},{"$f":"'7.0 2011LostRev'!H47","v":0},{"$f":"'7.0 2011LostRev'!I47","v":0},{"$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":8910.6291999999994}]
["2011 Cleared",0,0,0,0,0,0,null,null,null,null,0]
["2011 LRAM variance",{"$f":"B11+B12","v":7645.7717999999995},{"$f":"C11+C12","v":1264.8574000000001},0,0,0,0,null,null,null,null,8910.6291999999994]
["Cummulative LRAM variance",{"$f":"B14","v":7645.7717999999995},{"$f":"C14","v":1264.8574000000001},0,0,0,0,null,null,null,null,8910.6291999999994]
["2011 Carrying Charges",{"$f":"B14*'5.0 Carrying Charges'!$F$15","v":112.39284545999999},{"$f":"C14*'5.0 Carrying Charges'!$F$15","v":18.593403779999999},{"$f":"D14*'5.0 Carrying Charges'!$F$15","v":0},{"$f":"E14*'5.0 Carrying Charges'!$F$15","v":0},{"$f":"F14*'5.0 Carrying Charges'!$F$15","v":0},{"$f":"G14*'5.0 Carrying Charges'!$F$15","v":0},null,null,null,null,{"$f":"SUM(B16:K16)","v":130.98624923999998}]
["Cummulative carrying charges",{"$f":"B16","v":112.39284545999999},{"$f":"C16","v":18.593403779999999},0,0,0,0,0,0,0,0,130.98624923999998]
[]
["2012 CDM 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,null,"No CDM component for 2012"]
["2012 Verified",{"$f":"'8.0 2012LostRev'!F63","v":13289.632733333334},{"$f":"'8.0 2012LostRev'!G63","v":2380.8360066666669},{"$f":"'8.0 2012LostRev'!H63","v":1053.6771200000001},{"$f":"'8.0 2012LostRev'!I63","v":0},{"$f":"'8.0 2012LostRev'!J63","v":0},{"$f":"'8.0 2012LostRev'!K63","v":0},{"$f":"'8.0 2012LostRev'!L63","v":0},null,null,null,16724.145860000001]
["2012 Cleared",0,0,0,0,0,0,null,null,null,null,0]
["2012 LRAM variance",{"$f":"B19+B20","v":13289.632733333334},{"$f":"C19+C20","v":2380.8360066666669},1053.6771200000001,0,0,0,null,null,null,null,16724.145860000001]
["Cummulative LRAM variance",{"$f":"B15+B22","v":20935.404533333334},{"$f":"C15+C22","v":3645.6934066666672},1053.6771200000001,0,0,0,null,null,null,null,25634.77506]
["2012 Carrying charges",{"$f":"B23*'5.0 Carrying Charges'!$F$19","v":307.75044664000001},{"$f":"C23*'5.0 Carrying Charges'!$F$19","v":53.591693078000006},{"$f":"D23*'5.0 Carrying Charges'!$F$19","v":15.489053664},{"$f":"E23*'5.0 Carrying Charges'!$F$19","v":0},{"$f":"F23*'5.0 Carrying Charges'!$F$19","v":0},{"$f":"G23*'5.0 Carrying Charges'!$F$19","v":0},null,null,null,null,376.83119338199998]
["Cummulative carrying charges",{"$f":"B17+B24","v":420.1432921},{"$f":"C17+C24","v":72.185096858000009},15.489053664,0,0,0,null,null,null,null,507.81744262199999]
[]
["2013 CDM Forecast",{"$f":"-'4.0 Approved Load Forecast'!D36","v":-22902.5124},{"$f":"-'4.0 Approved Load Forecast'!E36","v":-2207.8879999999999},{"$f":"-'4.0 Approved Load Forecast'!F36","v":-7339.0445},{"$f":"-'4.0 Approved Load Forecast'!G36","v":-2024.5130000000001},{"$f":"-'4.0 Approved Load Forecast'!H36","v":-243.94549999999998},{"$f":"-'4.0 Approved Load Forecast'!I36","v":-2685.7028},{"$f":"-'4.0 Approved Load Forecast'!J36","v":0},null,null,null,-37403.606200000002,null,"Refer to TAB 4.0 for 2013 Forecast Assumptions"]
["2013 Actuals",{"$f":"'9.0 2013LostRev'!F70","v":18237.808799999999},{"$f":"'9.0 2013LostRev'!G70","v":3974.3487999999998},{"$f":"'9.0 2013LostRev'!H70","v":7514.7052000000012},{"$f":"'9.0 2013LostRev'!I70","v":0},{"$f":"'9.0 2013LostRev'!J70","v":0},{"$f":"'9.0 2013LostRev'!K70","v":0},{"$f":"'9.0 2013LostRev'!L70","v":0},null,null,null,29726.862799999999]
["2013 Cleared",0,0,0,0,0,0,null,null,null,null,0]
["2013 LRAM variance",{"$f":"B27+B28","v":-4664.7036000000007},{"$f":"C27+C28","v":1766.4607999999998},175.66070000000127,-2024.5130000000001,-243.94549999999998,-2685.7028,null,null,null,null,{"$f":"SUM(B30:K30)","v":-7676.7433999999994}]
["Cummulative LRAM variance",{"$f":"B23+B30","v":16270.700933333334},{"$f":"C23+C30","v":5412.1542066666671},{"$f":"D23+D30","v":1229.3378200000013},{"$f":"E23+E30","v":-2024.5130000000001},{"$f":"F23+F30","v":-243.94549999999998},{"$f":"G23+G30","v":-2685.7028},null,null,null,null,17958.031660000001]
["2013 Carrying charges",{"$f":"B31*'5.0 Carrying Charges'!$F$19","v":239.17930372000001},{"$f":"C31*'5.0 Carrying Charges'!$F$19","v":79.558666838000008},{"$f":"D31*'5.0 Carrying Charges'!$F$19","v":18.071265954000019},{"$f":"E31*'5.0 Carrying Charges'!$F$19","v":-29.760341100000002},{"$f":"F31*'5.0 Carrying Charges'!$F$19","v":-3.5859988499999997},{"$f":"G31*'5.0 Carrying Charges'!$F$19","v":-39.479831159999996},null,null,null,null,263.98306540200002]
["Cummulative carrying charges",{"$f":"B25+B32","v":659.32259582000006},{"$f":"C25+C32","v":151.74376369600003},{"$f":"D25+D32","v":33.560319618000023},{"$f":"E25+E32","v":-29.760341100000002},{"$f":"F25+F32","v":-3.5859988499999997},{"$f":"G25+G32","v":-39.479831159999996},null,null,null,null,771.80050802400012]
[]
["2014 CDM Forecast",{"$f":"-'4.0 Approved Load Forecast'!D37","v":-23159.843999999997},{"$f":"-'4.0 Approved Load Forecast'!E37","v":-2235.4865999999997},{"$f":"-'4.0 Approved Load Forecast'!F37","v":-7441.835},{"$f":"-'4.0 Approved Load Forecast'!G37","v":-2048.3308000000002},{"$f":"-'4.0 Approved Load Forecast'!H37","v":-247.36049999999994},{"$f":"-'4.0 Approved Load Forecast'!I37","v":-2723.3044},{"$f":"-'4.0 Approved Load Forecast'!J37","v":0},null,null,null,-37856.161300000007,null,"Refer to TAB 4.0 for 2014 Forecast Assumptions"]
["2014 Actuals",{"$f":"'10.0 2014LostRev'!F57","v":30239.378999999997},{"$f":"'10.0 2014LostRev'!G57","v":5900.2627499999999},{"$f":"'10.0 2014LostRev'!H57","v":8771.5751142857152},{"$f":"'10.0 2014LostRev'!I57","v":0},{"$f":"'10.0 2014LostRev'!J57","v":0},{"$f":"'10.0 2014LostRev'!K57","v":0},{"$f":"'10.0 2014LostRev'!L57","v":0},null,null,null,{"$f":"SUM(B36:K36)","v":44911.216864285714}]
["2014 Cleared",0,0,0,0,0,0,null,null,null,null,0]
["2014 LRAM variance",{"$f":"B35+B36","v":7079.5349999999999},{"$f":"C35+C36","v":3664.7761500000001},1329.7401142857152,-2048.3308000000002,-247.36049999999994,-2723.3044,null,null,null,null,7055.0555642857134]
["Cummulative LRAM variance",{"$f":"B31+B38","v":23350.235933333333},{"$f":"C31+C38","v":9076.9303566666676},{"$f":"D31+D38","v":2559.0779342857168},{"$f":"E31+E38","v":-4072.8438000000006},{"$f":"F31+F38","v":-491.30599999999993},{"$f":"G31+G38","v":-5409.0072},null,null,null,null,25013.087224285719]
["2014 Carrying charges",{"$f":"B39*'5.0 Carrying Charges'!$F$19","v":343.24846822000001},{"$f":"C39*'5.0 Carrying Charges'!$F$19","v":133.430876243},{"$f":"D39*'5.0 Carrying Charges'!$F$19","v":37.618445634000032},{"$f":"E39*'5.0 Carrying Charges'!$F$19","v":-59.870803860000009},{"$f":"F39*'5.0 Carrying Charges'!$F$19","v":-7.2221981999999985},{"$f":"G39*'5.0 Carrying Charges'!$F$19","v":-79.51240584},null,null,null,null,367.69238219700009]
["Cummulative carrying charges",{"$f":"B33+B40","v":1002.57106404},{"$f":"C33+C40","v":285.17463993900003},{"$f":"D33+D40","v":71.178765252000062},{"$f":"E33+E40","v":-89.631144960000015},{"$f":"F33+F40","v":-10.808197049999999},{"$f":"G33+G40","v":-118.99223699999999},null,null,null,null,1139.4928902210004]
[]
[]
["Principal and Carry Chrgs",{"$f":"B41+B39","v":24352.806997373333},{"$f":"C41+C39","v":9362.1049966056671},2630.2566995377169,-4162.4749449600004,-502.11419704999992,-5527.9994370000004,0,null,null,{"$f":"SUM(K11:K43)","v":0},{"$f":"SUM(B44:K44)","v":26152.580114506716}]
[]
[null,null,null,null,null,null,null,null,null,"Forecast for 2011- 2014",null,{"$f":"SUM(L11+L19+L27+L35)","v":-75259.767500000016}]
["Input amounts cleared by rate class.",null,null,null,null,null,null,null,null,"Actual to Date",null,{"$f":"SUM(L12+L20+L28+L36)","v":100272.85472428572}]
["1 Update formula for most recent rate year",null,null,null,null,null,null,null,null,"Difference",null,{"$f":"SUM(L46:L47)","v":25013.0872242857}]
[null,null,null,null,null,null,null,null,null,"Carrying Charges",null,{"$f":"L41","v":1139.4928902210004}]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L48+L49)","v":26152.580114506702}]
[]
[]
[]
["up to Dec 2013 booked","Previous Amts Booked ",null,"New 1568 Amount",null,"Correction Required"]
["in financials (verified)","Principal","Carry Chrgs","Principal","Carry Chrgs","Principal","Carry Chrgs"]
[2011,14134.24,null,{"$f":"L14","v":8910.6291999999994},{"$f":"L16","v":130.98624923999998},{"$f":"D56-B56","v":-5223.6108000000004},{"$f":"E56-C56","v":130.98624923999998}]
[2012,16028.43,480.53,{"$f":"L22","v":16724.145860000001},{"$f":"L24","v":376.83119338199998},{"$f":"D57-B57","v":695.71586000000025},{"$f":"E57-C57","v":-103.69880661799999}]
[2013,0,0,{"$f":"L30","v":-7676.7433999999994},{"$f":"L32","v":263.98306540200002},-7676.7433999999994,263.98306540200002]
["Dec 31, 2014 GL Totals",null,null,{"$f":"SUM(D56:D58)","v":17958.031660000001},{"$f":"SUM(E56:E58)","v":771.80050802400001}]
[null,null,null,"1580.800","1580.801"]

{"sheet":"4.0 Approved Load Forecast","index":4,"n_rows":97,"n_cols":16,"rows_kept":97,"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"]
[]
[null,"Forecast Year",null," "]
[null,null,null,"kWh","kW"]
[null,2011,null,560000,121630]
[null,2012,null,1723333,121630]
[null,2013,null,2886667,121630]
[null,2014,null,4030000,121630]
[null,null,null,{"$f":"SUM(D12:D15)","v":9200000},{"$f":"SUM(E12:E15)","v":486520}]
[]
[null,"Table 2 - Savings Due to CDM Included in Approved Load Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes & Assumptions"]
[]
[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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E$10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F$10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G$10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H$10","v":"other"},{"$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":0},{"$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,null,null,{"$f":"SUM(D22:M22)","v":0},null,"No CDM load forecast component EB-2008-0233"]
[null,2012,null,0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(D23:M23)","v":0},null,"No CDM load forecast component EB-2008-0233"]
[null,2013,null,1286658,275986,2465,119089,5,71,{"$f":"-J76","v":0},null,null,null,{"$f":"SUM(D24:M24)","v":1684274}]
[null,2014,null,1286658,275986,2465,119089,5,71,{"$f":"-J89","v":0},null,null,null,{"$f":"SUM(D25:M25)","v":1684274}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," "]
[]
[]
[null,"Table 3 - Forecast Loss Revenue by Class"]
[]
[null,"Forecast Year",null,{"$f":"D20","v":"Residential"},"General Service < 50 kW","General Service > 50 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","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":22902.5124},{"$f":"E24*'6.0 Rates'!E16","v":2207.8879999999999},{"$f":"F24*'6.0 Rates'!E17","v":7339.0445},{"$f":"G24*'6.0 Rates'!E18","v":2024.5130000000001},{"$f":"H24*'6.0 Rates'!E19","v":243.94549999999998},{"$f":"I24*'6.0 Rates'!E20","v":2685.7028},{"$f":"J24*'6.0 Rates'!E21","v":0},null,null,null,37403.606200000002]
[null,2014,null,{"$f":"D25*'6.0 Rates'!F15","v":23159.843999999997},{"$f":"E25*'6.0 Rates'!F16","v":2235.4865999999997},{"$f":"F25*'6.0 Rates'!F17","v":7441.835},{"$f":"G25*'6.0 Rates'!F18","v":2048.3308000000002},{"$f":"H25*'6.0 Rates'!F19","v":247.36049999999994},{"$f":"I25*'6.0 Rates'!F20","v":2723.3044},{"$f":"J25*'6.0 Rates'!F21","v":0},null,null,null,37856.161300000007]
[]
[]
[]
[]
["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 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","other","Total"]
[]
[null,"2011 Weather Normal Billed kWh",null,0,0,0,0,0,0,null,null,null,null,{"$f":"SUM(D46:M46)","v":0}]
[null,"% of Billed",null,{"$f":"D46/$N$46","v":{"$error":"#DIV/0!"}},{"$f":"E46/$N$46","v":{"$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,2012,null,{"$f":"D44","v":"Residential"},"General Service < 50 kW","General Service > 50 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","other","Total"]
[null,"kWh"]
[null,"2011 Weather Normal Billed kWh",null,0,0,0,0,0,0,null,null,null,null,{"$f":"SUM(D57:M57)","v":0}]
[null,"% of Billed",null,{"$f":"D57/$N$46","v":{"$error":"#DIV/0!"}},{"$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,"2012 Weather Normal Billed kW",null,{"$f":"D57*D65","v":0},0,0,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,null,null,{"$f":"SUM(F62/F57)*100","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H62/H57)*100","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I62/I57)*100","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,2013,null,{"$f":"D55","v":"Residential"},{"$f":"E55","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","other","Total"]
[null,"kWh"]
[null,"2011 Weather Normal Billed kWh",null,149060361,31973156,51773902,592220,105833,1529715,null,null,null,null,{"$f":"SUM(D70:M70)","v":235035187}]
[null,"% of Billed",null,{"$f":"D70/$N$70","v":0.63420444786422558},{"$f":"E70/$N$70","v":0.13603561410572962},0.22028149342591838,2.5197078257052636E-3,4.5028576933886922E-4,6.5084510090823123E-3,0,0,0,0,{"$f":"SUM(D71:M71)","v":1}]
[null,"CDM Spread kWh",null,{"$f":"-$D$14*D71","v":-1830737.0509028805},-392689.51806374418,-635879.31778331555,-7273.5574301051365,-1299.8250709201257,-18787.73074903461,{"$f":"-$D$14*J71","v":0},0,0,{"$f":"-$D$14*M71","v":0},{"$f":"SUM(D72:M72)","v":-2886667.0000000005}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D70+D72","v":147229623.94909713},{"$f":"E70+E72","v":31580466.481936257},{"$f":"F70+F72","v":51138022.682216682},{"$f":"G70+G72","v":584946.44256989483},{"$f":"H70+H72","v":104533.17492907988},{"$f":"I70+I72","v":1510927.2692509654},0,0,0,{"$f":"M70+M72","v":0},{"$f":"SUM(D73:M74)","v":232148519.99999997}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D70*D78","v":0},{"$f":"E70*E78","v":0},148945,{"$f":"G70*G78","v":0},294,4471,{"$f":"J70*J78","v":0},0,0,0,{"$f":"SUM(D75:M75)","v":153710}]
[null,"CDM kW Reduction",null,{"$f":"D72*D78","v":0},{"$f":"E72*E78","v":0},{"$f":"F72*F78","v":-182942.47972625989},{"$f":"G72*G78","v":0},-379.93886822995273,-5219.2316020818143,{"$f":"J72*J78","v":0},0,0,0,{"$f":"SUM(D76:M76)","v":-188541.65019657166}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D75+D76","v":0},{"$f":"E75+E76","v":0},{"$f":"F75+F76","v":-33997.479726259888},{"$f":"G75+G76","v":0},{"$f":"H75+H76","v":-85.938868229952732},{"$f":"I75+I76","v":-748.23160208181434},0,0,0,0,{"$f":"SUM(D77:M77)","v":-34831.65019657166}]
[null,"kWh to KW Ratio",null,null,null,0.28770000000000001,0,0.2923,0.27779999999999999]
[]
[]
[null,2014,null,{"$f":"D68","v":"Residential"},{"$f":"E68","v":"General Service < 50 kW"},"General Service > 50 to 4999 kW","Unmetered Scattered Load","Sentinel Lighting","Street Lighting ","other","other","other","other","Total"]
[null,"kWh"]
[null,"2011 Weather Normal Billed kWh",null,149060361,31973156,51773902,592220,105833,1529715,null,null,null,null,{"$f":"SUM(D83:M83)","v":235035187}]
[null,"% of Billed",null,{"$f":"D83/$N$83","v":0.63420444786422558},0.13603561410572962,0.22028149342591838,2.5197078257052636E-3,4.5028576933886922E-4,6.5084510090823123E-3,0,0,0,0,{"$f":"SUM(D84:M84)","v":1}]
[null,"CDM Spread kWh",null,{"$f":"-$D$15*D84","v":-2555843.9248928293},-548223.52484609035,-887734.41850645107,-10154.422537592212,-1814.651650435643,-26229.057566601718,{"$f":"-$D$15*J84","v":0},0,0,{"$f":"-$D$15*M84","v":0},{"$f":"SUM(D85:M85)","v":-4030000.0000000005}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D83+D85","v":146504517.07510716},{"$f":"E83+E85","v":31424932.475153908},{"$f":"F83+F85","v":50886167.581493549},{"$f":"G83+G85","v":582065.57746240776},{"$f":"H83+H85","v":104018.34834956436},{"$f":"I83+I85","v":1503485.9424333982},0,0,0,{"$f":"M83+M85","v":0},{"$f":"SUM(D86:M87)","v":231005187}]
[null,"kW"]
[null,"2012 Weather Normal Billed kW",null,{"$f":"D83*D91","v":0},0,148945,0,294,4471,{"$f":"J83*J91","v":0},0,0,0,{"$f":"SUM(D88:M88)","v":153710}]
[null,"CDM kW Reduction",null,{"$f":"D85*D91","v":0},0,{"$f":"F85*F91","v":-255401.19220430599},0,{"$f":"H85*H91","v":-530.42267742233844},0,{"$f":"J85*J91","v":0},0,0,0,{"$f":"SUM(D89:M89)","v":-255931.61488172834}]
[null,"Adjusted Billed kWh with CDM Applied",null,{"$f":"D88+D89","v":0},0,{"$f":"F88+F89","v":-106456.19220430599},0,{"$f":"H88+H89","v":-236.42267742233844},{"$f":"I88+I89","v":4471},0,0,0,0,{"$f":"SUM(D90:M90)","v":-102221.61488172832}]
[null,"kWh to KW Ratio",null,null,null,0.28770000000000001,0,0.2923]
[]
[]
[]
[]
[]
[null,"Assumptions "]

{"sheet":"5.0 Carrying Charges","index":5,"n_rows":100,"n_cols":14,"rows_kept":100,"cut":false,"hidden":false,"merged":[[8,4,8,7],[30,4,30,7]]}
["LRAMVA Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Table 4 - Carrying Charges Prescribed Rates"]
[]
[null,null,null,null,"Period","Board specified","Estimated","Used in calculations"]
[null,null,null,null,"2011 Q1",1.47E-2,null,{"$f":"IF(F12<>0,F12,G12)","v":1.47E-2}]
[null,null,null,null,"2011 Q2",1.47E-2,null,{"$f":"IF(F13<>0,F13,G13)","v":1.47E-2}]
[null,null,null,null,"2011 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2011 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2012 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q3",1.47E-2,null,1.47E-2]
[null,null,null,null,"2013 Q4",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q1",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q2",1.47E-2,null,1.47E-2]
[null,null,null,null,"2014 Q3",1.47E-2,null,{"$f":"IF(F26<>0,F26,G26)","v":1.47E-2}]
[null,null,null,null,"2014 Q4",1.47E-2,null,{"$f":"IF(F27<>0,F27,G27)","v":1.47E-2}]
[null,null,null,null,"2015 Q1",1.47E-2,null,{"$f":"IF(F28<>0,F28,G28)","v":1.47E-2}]
[null,null,null,null,"2015 Q2",1.0999999999999999E-2,null,1.0999999999999999E-2]
[]
[null,null,null,null,"Table 5 - Carrying Charges by Rate Class"]
[]
["Month","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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H10","v":"other"},{"$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","Q1",{"$f":"H$12/12","v":1.225E-3}]
["2011-02-01","Q1",{"$f":"H$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A35)-1)/12*$C35","v":0.78050587124999993},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A35)-1)/12*$C35","v":0.12912085958333333},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A35)-1)/12*$C35","v":0},{"$f":"SUM(D35:M35)","v":0.90962673083333323}]
["2011-03-01","Q1",{"$f":"H$12/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A36)-1)/12*$C36","v":1.5610117424999999},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A36)-1)/12*$C36","v":0.25824171916666666},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A36)-1)/12*$C36","v":0},{"$f":"SUM(D36:M36)","v":1.8192534616666665}]
["2011-04-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A37)-1)/12*$C37","v":2.3415176137499998},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A37)-1)/12*$C37","v":0.38736257875000002},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A37)-1)/12*$C37","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A37)-1)/12*$C37","v":0},2.7288801924999997]
["Total for rate year 2010",null,null,{"$f":"SUM(D34:D37)","v":4.6830352274999996},{"$f":"SUM(E34:E37)","v":0.77472515750000004},0,0,0,0,0,0,0,0,5.4577603849999994]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D39:M39)","v":0}]
["Opening Balance for rate year 2011",null,null,{"$f":"D38+D39","v":4.6830352274999996},{"$f":"E38+E39","v":0.77472515750000004},{"$f":"F38+F39","v":0},{"$f":"G38+G39","v":0},0,0,0,0,0,0,{"$f":"N38+N39","v":5.4577603849999994}]
["2011-05-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A41)-1)/12*$C41","v":3.1220234849999997},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A41)-1)/12*$C41","v":0.51648343833333332},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A41)-1)/12*$C41","v":0},{"$f":"SUM(D41:M41)","v":3.6385069233333329}]
["2011-06-01","Q2",{"$f":"H$13/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A42)-1)/12*$C42","v":3.9025293562499996},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A42)-1)/12*$C42","v":0.64560429791666663},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A42)-1)/12*$C42","v":0},{"$f":"SUM(D42:M42)","v":4.5481336541666666}]
["2011-07-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A43)-1)/12*$C43","v":4.6830352274999996},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A43)-1)/12*$C43","v":0.77472515750000004},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A43)-1)/12*$C43","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A43)-1)/12*$C43","v":0},5.4577603849999994]
["2011-08-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A44)-1)/12*$C44","v":5.4635410987499986},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A44)-1)/12*$C44","v":0.90384601708333334},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A44)-1)/12*$C44","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A44)-1)/12*$C44","v":0},6.3673871158333322]
["2011-09-01","Q3",{"$f":"H$14/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A45)-1)/12*$C45","v":6.2440469699999994},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A45)-1)/12*$C45","v":1.0329668766666666},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A45)-1)/12*$C45","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A45)-1)/12*$C45","v":0},7.2770138466666658]
["2011-10-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A46)-1)/12*$C46","v":7.0245528412499985},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A46)-1)/12*$C46","v":1.1620877362500002},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A46)-1)/12*$C46","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A46)-1)/12*$C46","v":0},8.1866405774999986]
["2011-11-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A47)-1)/12*$C47","v":7.8050587124999993},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A47)-1)/12*$C47","v":1.2912085958333333},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A47)-1)/12*$C47","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A47)-1)/12*$C47","v":0},9.0962673083333332]
["2011-12-01","Q4",{"$f":"H$15/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$12)*(MONTH($A48)-1)/12*$C48","v":8.5855645837499992},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$12)*(MONTH($A48)-1)/12*$C48","v":1.4203294554166666},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$12)*(MONTH($A48)-1)/12*$C48","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$12)*(MONTH($A48)-1)/12*$C48","v":0},10.005894039166666]
["2012-01-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A49)-1)/12)*$C49","v":9.3660704549999991},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A49)-1)/12)*$C49","v":1.5494503150000001},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A49)-1)/12)*$C49","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A49)-1)/12)*$C49","v":0},10.915520769999999]
["2012-02-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A50)-1)/12)*$C50","v":10.722720463194445},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A50)-1)/12)*$C50","v":1.7924939906805557},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A50)-1)/12)*$C50","v":0.10756287266666667},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A50)-1)/12)*$C50","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A50)-1)/12)*$C50","v":0},12.622777326541668]
["2012-03-01","Q1",{"$f":"H$16/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A51)-1)/12)*$C51","v":12.07937047138889},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A51)-1)/12)*$C51","v":2.0355376663611113},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A51)-1)/12)*$C51","v":0.21512574533333334},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A51)-1)/12)*$C51","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A51)-1)/12)*$C51","v":0},14.330033883083335]
["2012-04-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A52)-1)/12)*$C52","v":13.436020479583332},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A52)-1)/12)*$C52","v":2.278581342041667},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A52)-1)/12)*$C52","v":0.32268861799999998},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A52)-1)/12)*$C52","v":0},{"$f":"SUM(D52:M52)","v":16.037290439625}]
["Total for rate year 2011",null,null,{"$f":"SUM(D40:D52)","v":97.117569371666661},{"$f":"SUM(E40:E52)","v":16.178040046583334},0.64537723600000008,0,0,0,0,{"$f":"SUM(K40:K52)","v":0},0,0,113.94098665424998]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D54:M54)","v":0}]
["Opening Balance for rate year 2012",null,null,{"$f":"D53+D54","v":97.117569371666661},16.178040046583334,0.64537723600000008,0,0,0,0,0,0,0,{"$f":"N53+N54","v":113.94098665424998}]
["2012-05-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A56)-1)/12)*$C56","v":14.792670487777777},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A56)-1)/12)*$C56","v":2.5216250177222226},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A56)-1)/12)*$C56","v":0.43025149066666668},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A56)-1)/12)*$C56","v":0},{"$f":"SUM(D56:M56)","v":17.744546996166665}]
["2012-06-01","Q2",{"$f":"H$17/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A57)-1)/12)*$C57","v":16.149320495972223},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A57)-1)/12)*$C57","v":2.7646686934027778},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A57)-1)/12)*$C57","v":0.53781436333333332},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A57)-1)/12)*$C57","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A57)-1)/12)*$C57","v":0},19.451803552708334]
["2012-07-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A58)-1)/12)*$C58","v":17.505970504166665},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A58)-1)/12)*$C58","v":3.0077123690833334},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A58)-1)/12)*$C58","v":0.64537723599999997},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A58)-1)/12)*$C58","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A58)-1)/12)*$C58","v":0},21.159060109249999]
["2012-08-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A59)-1)/12)*$C59","v":18.862620512361111},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A59)-1)/12)*$C59","v":3.250756044763889},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A59)-1)/12)*$C59","v":0.75294010866666661},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A59)-1)/12)*$C59","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A59)-1)/12)*$C59","v":0},22.866316665791668]
["2012-09-01","Q3",{"$f":"H$18/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A60)-1)/12)*$C60","v":20.219270520555558},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A60)-1)/12)*$C60","v":3.4937997204444446},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A60)-1)/12)*$C60","v":0.86050298133333336},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A60)-1)/12)*$C60","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A60)-1)/12)*$C60","v":0},24.573573222333337]
["2012-10-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A61)-1)/12)*$C61","v":21.57592052875},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A61)-1)/12)*$C61","v":3.7368433961250003},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A61)-1)/12)*$C61","v":0.96806585400000011},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A61)-1)/12)*$C61","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A61)-1)/12)*$C61","v":0},26.280829778874999]
["2012-11-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A62)-1)/12)*$C62","v":22.932570536944446},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A62)-1)/12)*$C62","v":3.9798870718055555},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A62)-1)/12)*$C62","v":1.0756287266666666},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A62)-1)/12)*$C62","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A62)-1)/12)*$C62","v":0},27.988086335416671]
["2012-12-01","Q4",{"$f":"H$19/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$13)+SUM('3.0 LRAMVA Register'!B$19:B$20)*(MONTH($A63)-1)/12)*$C63","v":24.289220545138889},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$13)+SUM('3.0 LRAMVA Register'!C$19:C$20)*(MONTH($A63)-1)/12)*$C63","v":4.2229307474861111},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$13)+SUM('3.0 LRAMVA Register'!D$19:D$20)*(MONTH($A63)-1)/12)*$C63","v":1.1831915993333333},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$13)+SUM('3.0 LRAMVA Register'!E$19:E$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$13)+SUM('3.0 LRAMVA Register'!F$19:F$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$13)+SUM('3.0 LRAMVA Register'!G$19:G$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$13)+SUM('3.0 LRAMVA Register'!H$19:H$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$13)+SUM('3.0 LRAMVA Register'!I$19:I$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$13)+SUM('3.0 LRAMVA Register'!J$19:J$20)*(MONTH($A63)-1)/12)*$C63","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$13)+SUM('3.0 LRAMVA Register'!K$19:K$20)*(MONTH($A63)-1)/12)*$C63","v":0},29.695342891958333]
["2013-01-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A64)-1)/12)*$C64","v":44.653373934710331},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A64)-1)/12)*$C64","v":7.6104288924276666},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A64)-1)/12)*$C64","v":1.2907544719999999},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A64)-1)/12)*$C64","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A64)-1)/12)*$C64","v":0},53.554557299137997]
["2013-02-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A65)-1)/12)*$C65","v":44.17718544221033},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A65)-1)/12)*$C65","v":7.7907550990943326},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A65)-1)/12)*$C65","v":1.3086865017916669},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A65)-1)/12)*$C65","v":-0.20666903541666667},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A65)-1)/12)*$C65","v":-2.4902769791666661E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A65)-1)/12)*$C65","v":-0.27416549416666669},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A65)-1)/12)*$C65","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A65)-1)/12)*$C65","v":0},52.770889743721334]
["2013-03-01","Q1",{"$f":"H$20/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A66)-1)/12)*$C66","v":43.70099694971033},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A66)-1)/12)*$C66","v":7.9710813057609986},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A66)-1)/12)*$C66","v":1.3266185315833334},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A66)-1)/12)*$C66","v":-0.41333807083333335},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A66)-1)/12)*$C66","v":-4.9805539583333322E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A66)-1)/12)*$C66","v":-0.54833098833333338},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A66)-1)/12)*$C66","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A66)-1)/12)*$C66","v":0},51.987222188304663]
["2013-04-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A67)-1)/12)*$C67","v":43.224808457210322},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A67)-1)/12)*$C67","v":8.1514075124276673},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A67)-1)/12)*$C67","v":1.3445505613750004},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A67)-1)/12)*$C67","v":-0.62000710625},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A67)-1)/12)*$C67","v":-7.470830937499999E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A67)-1)/12)*$C67","v":-0.82249648249999996},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A67)-1)/12)*$C67","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A67)-1)/12)*$C67","v":0},51.203554632887993]
["Total for rate year 2012",null,null,{"$f":"SUM(D55:D67)","v":429.20149828717462},{"$f":"SUM(E55:E67)","v":74.679935917127338},12.369759662750001,-1.2400142125,-0.14941661874999995,-1.6449929650000001,0,{"$f":"SUM(K55:K67)","v":0},0,0,513.216770070802]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:M69)","v":0}]
["Opening Balance for rate year 2013",null,null,{"$f":"D68+D69","v":429.20149828717462},74.679935917127338,12.369759662750001,-1.2400142125,-0.14941661874999995,-1.6449929650000001,0,0,0,0,{"$f":"N68+N69","v":513.216770070802}]
["2013-05-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A71)-1)/12)*$C71","v":42.748619964710329},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A71)-1)/12)*$C71","v":8.3317337190943324},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A71)-1)/12)*$C71","v":1.3624825911666674},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A71)-1)/12)*$C71","v":-0.8266761416666667},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A71)-1)/12)*$C71","v":-9.9611079166666644E-2},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A71)-1)/12)*$C71","v":-1.0966619766666668},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A71)-1)/12)*$C71","v":0},{"$f":"SUM(D71:M71)","v":50.41988707747133}]
["2013-06-01","Q2",{"$f":"H$21/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A72)-1)/12)*$C72","v":42.272431472210329},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A72)-1)/12)*$C72","v":8.5120599257609992},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A72)-1)/12)*$C72","v":1.3804146209583339},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A72)-1)/12)*$C72","v":-1.0333451770833333},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A72)-1)/12)*$C72","v":-0.12451384895833333},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A72)-1)/12)*$C72","v":-1.370827470833333},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A72)-1)/12)*$C72","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A72)-1)/12)*$C72","v":0},49.63621952205466]
["2013-07-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A73)-1)/12)*$C73","v":41.796242979710321},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A73)-1)/12)*$C73","v":8.6923861324276661},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A73)-1)/12)*$C73","v":1.3983466507500009},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A73)-1)/12)*$C73","v":-1.2400142125},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A73)-1)/12)*$C73","v":-0.14941661874999998},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A73)-1)/12)*$C73","v":-1.6449929649999999},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A73)-1)/12)*$C73","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A73)-1)/12)*$C73","v":0},48.852551966637982]
["2013-08-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A74)-1)/12)*$C74","v":41.320054487210328},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A74)-1)/12)*$C74","v":8.872712339094333},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A74)-1)/12)*$C74","v":1.4162786805416676},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A74)-1)/12)*$C74","v":-1.4466832479166667},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A74)-1)/12)*$C74","v":-0.17431938854166665},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A74)-1)/12)*$C74","v":-1.9191584591666668},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A74)-1)/12)*$C74","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A74)-1)/12)*$C74","v":0},48.068884411221326]
["2013-09-01","Q3",{"$f":"H$22/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A75)-1)/12)*$C75","v":40.843865994710328},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A75)-1)/12)*$C75","v":9.0530385457609999},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A75)-1)/12)*$C75","v":1.4342107103333344},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A75)-1)/12)*$C75","v":-1.6533522833333334},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A75)-1)/12)*$C75","v":-0.19922215833333329},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A75)-1)/12)*$C75","v":-2.1933239533333335},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A75)-1)/12)*$C75","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A75)-1)/12)*$C75","v":0},47.285216855804656]
["2013-10-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A76)-1)/12)*$C76","v":40.367677502210327},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A76)-1)/12)*$C76","v":9.233364752427665},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A76)-1)/12)*$C76","v":1.4521427401250011},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A76)-1)/12)*$C76","v":-1.8600213187500001},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A76)-1)/12)*$C76","v":-0.22412492812499996},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A76)-1)/12)*$C76","v":-2.4674894474999998},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A76)-1)/12)*$C76","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A76)-1)/12)*$C76","v":0},46.501549300387985]
["2013-11-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A77)-1)/12)*$C77","v":39.891489009710327},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A77)-1)/12)*$C77","v":9.4136909590943336},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A77)-1)/12)*$C77","v":1.4700747699166681},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A77)-1)/12)*$C77","v":-2.0666903541666666},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A77)-1)/12)*$C77","v":-0.24902769791666665},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A77)-1)/12)*$C77","v":-2.741654941666666},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A77)-1)/12)*$C77","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A77)-1)/12)*$C77","v":0},45.717881744971329]
["2013-12-01","Q4",{"$f":"H$23/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$21)+SUM('3.0 LRAMVA Register'!B$27:B$28)*(MONTH($A78)-1)/12)*$C78","v":39.415300517210326},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$21)+SUM('3.0 LRAMVA Register'!C$27:C$28)*(MONTH($A78)-1)/12)*$C78","v":9.5940171657610005},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$21)+SUM('3.0 LRAMVA Register'!D$27:D$28)*(MONTH($A78)-1)/12)*$C78","v":1.4880067997083346},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$21)+SUM('3.0 LRAMVA Register'!E$27:E$28)*(MONTH($A78)-1)/12)*$C78","v":-2.2733593895833333},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$21)+SUM('3.0 LRAMVA Register'!F$27:F$28)*(MONTH($A78)-1)/12)*$C78","v":-0.27393046770833329},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$21)+SUM('3.0 LRAMVA Register'!G$27:G$28)*(MONTH($A78)-1)/12)*$C78","v":-3.0158204358333331},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$21)+SUM('3.0 LRAMVA Register'!H$27:H$28)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$21)+SUM('3.0 LRAMVA Register'!I$27:I$28)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$21)+SUM('3.0 LRAMVA Register'!J$27:J$28)*(MONTH($A78)-1)/12)*$C78","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$21)+SUM('3.0 LRAMVA Register'!K$27:K$28)*(MONTH($A78)-1)/12)*$C78","v":0},44.934214189554666]
["2014-01-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A79)-1)/12)*$C79","v":81.756452506333488},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A79)-1)/12)*$C79","v":17.310918471432601},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A79)-1)/12)*$C79","v":4.1253959549768018},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A79)-1)/12)*$C79","v":-2.480028425},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A79)-1)/12)*$C79","v":-0.29883323749999996},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A79)-1)/12)*$C79","v":-3.2899859299999998},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A79)-1)/12)*$C79","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A79)-1)/12)*$C79","v":0},97.123919340242878]
["2014-02-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A80)-1)/12)*$C80","v":82.479155037583482},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A80)-1)/12)*$C80","v":17.685031036745102},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A80)-1)/12)*$C80","v":4.2611402583101352},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A80)-1)/12)*$C80","v":-2.6891288608333337},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A80)-1)/12)*$C80","v":-0.32408462187499998},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A80)-1)/12)*$C80","v":-3.567989920833333},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A80)-1)/12)*$C80","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A80)-1)/12)*$C80","v":0},97.844122929097054]
["2014-03-01","Q1",{"$f":"H$24/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A81)-1)/12)*$C81","v":83.201857568833489},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A81)-1)/12)*$C81","v":18.059143602057599},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A81)-1)/12)*$C81","v":4.3968845616434677},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A81)-1)/12)*$C81","v":-2.8982292966666665},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A81)-1)/12)*$C81","v":-0.34933600624999994},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A81)-1)/12)*$C81","v":-3.8459939116666666},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A81)-1)/12)*$C81","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A81)-1)/12)*$C81","v":0},98.56432651795123]
["2014-04-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A82)-1)/12)*$C82","v":83.924560100083482},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A82)-1)/12)*$C82","v":18.4332561673701},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A82)-1)/12)*$C82","v":4.5326288649768021},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A82)-1)/12)*$C82","v":-3.1073297325000002},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A82)-1)/12)*$C82","v":-0.37458739062499996},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A82)-1)/12)*$C82","v":-4.1239979025000002},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A82)-1)/12)*$C82","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A82)-1)/12)*$C82","v":0},99.284530106805391]
["Total for rate year 2013",null,null,{"$f":"SUM(D70:D82)","v":1089.2192054276911},{"$f":"SUM(E70:E82)","v":217.87128873415404},{"$f":"SUM(F70:F82)","v":41.087766866157217},{"$f":"SUM(G70:G82)","v":-24.8148726525},{"$f":"SUM(H70:H82)","v":-2.9904240624999989},{"$f":"SUM(I70:I82)","v":-32.922890280000004},{"$f":"SUM(J70:J82)","v":0},0,0,0,{"$f":"SUM(N70:N82)","v":1287.4500740330027}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D84:M84)","v":0}]
["Opening Balance for rate year 2014",null,null,{"$f":"D83+D84","v":1089.2192054276911},{"$f":"E83+E84","v":217.87128873415404},41.087766866157217,-24.8148726525,-2.9904240624999989,-32.922890280000004,0,0,0,0,{"$f":"N83+N84","v":1287.4500740330027}]
["2014-05-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A86)-1)/12)*$C86","v":84.64726263133349},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A86)-1)/12)*$C86","v":18.807368732682601},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A86)-1)/12)*$C86","v":4.6683731683101355},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A86)-1)/12)*$C86","v":-3.3164301683333335},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A86)-1)/12)*$C86","v":-0.39983877499999992},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A86)-1)/12)*$C86","v":-4.4020018933333338},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A86)-1)/12)*$C86","v":0},{"$f":"SUM(D86:M86)","v":100.00473369565955}]
["2014-06-01","Q2",{"$f":"H$25/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A87)-1)/12)*$C87","v":85.369965162583483},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A87)-1)/12)*$C87","v":19.181481297995102},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A87)-1)/12)*$C87","v":4.8041174716434689},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A87)-1)/12)*$C87","v":-3.5255306041666672},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A87)-1)/12)*$C87","v":-0.42509015937499994},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A87)-1)/12)*$C87","v":-4.6800058841666665},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A87)-1)/12)*$C87","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A87)-1)/12)*$C87","v":0},100.72493728451373]
["2014-07-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A88)-1)/12)*$C88","v":86.092667693833491},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A88)-1)/12)*$C88","v":19.555593863307603},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A88)-1)/12)*$C88","v":4.9398617749768023},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A88)-1)/12)*$C88","v":-3.73463104},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A88)-1)/12)*$C88","v":-0.45034154374999991},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A88)-1)/12)*$C88","v":-4.9580098750000001},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A88)-1)/12)*$C88","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A88)-1)/12)*$C88","v":0},101.4451408733679]
["2014-08-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A89)-1)/12)*$C89","v":86.815370225083484},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A89)-1)/12)*$C89","v":19.929706428620101},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A89)-1)/12)*$C89","v":5.0756060783101349},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A89)-1)/12)*$C89","v":-3.9437314758333333},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A89)-1)/12)*$C89","v":-0.47559292812499993},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A89)-1)/12)*$C89","v":-5.2360138658333328},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A89)-1)/12)*$C89","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A89)-1)/12)*$C89","v":0},102.16534446222207]
["2014-09-01","Q3",{"$f":"H$26/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A90)-1)/12)*$C90","v":87.538072756333491},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A90)-1)/12)*$C90","v":20.303818993932598},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A90)-1)/12)*$C90","v":5.2113503816434692},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A90)-1)/12)*$C90","v":-4.1528319116666665},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A90)-1)/12)*$C90","v":-0.50084431249999994},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A90)-1)/12)*$C90","v":-5.5140178566666664},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A90)-1)/12)*$C90","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A90)-1)/12)*$C90","v":0},102.88554805107623]
["2014-10-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A91)-1)/12)*$C91","v":88.260775287583485},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A91)-1)/12)*$C91","v":20.677931559245103},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A91)-1)/12)*$C91","v":5.3470946849768017},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A91)-1)/12)*$C91","v":-4.3619323474999998},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A91)-1)/12)*$C91","v":-0.52609569687499991},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A91)-1)/12)*$C91","v":-5.7920218474999992},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A91)-1)/12)*$C91","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A91)-1)/12)*$C91","v":0},103.60575163993038]
["2014-11-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A92)-1)/12)*$C92","v":88.983477818833492},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A92)-1)/12)*$C92","v":21.052044124557604},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A92)-1)/12)*$C92","v":5.4828389883101361},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A92)-1)/12)*$C92","v":-4.5710327833333331},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A92)-1)/12)*$C92","v":-0.55134708124999987},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A92)-1)/12)*$C92","v":-6.0700258383333336},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A92)-1)/12)*$C92","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A92)-1)/12)*$C92","v":0},104.32595522878457]
["2014-12-01","Q4",{"$f":"H$27/12","v":1.225E-3},{"$f":"(SUM('3.0 LRAMVA Register'!B$11:B$29)+SUM('3.0 LRAMVA Register'!B$35:B$36)*(MONTH($A93)-1)/12)*$C93","v":89.706180350083486},{"$f":"(SUM('3.0 LRAMVA Register'!C$11:C$29)+SUM('3.0 LRAMVA Register'!C$35:C$36)*(MONTH($A93)-1)/12)*$C93","v":21.426156689870101},{"$f":"(SUM('3.0 LRAMVA Register'!D$11:D$29)+SUM('3.0 LRAMVA Register'!D$35:D$36)*(MONTH($A93)-1)/12)*$C93","v":5.6185832916434686},{"$f":"(SUM('3.0 LRAMVA Register'!E$11:E$29)+SUM('3.0 LRAMVA Register'!E$35:E$36)*(MONTH($A93)-1)/12)*$C93","v":-4.7801332191666672},{"$f":"(SUM('3.0 LRAMVA Register'!F$11:F$29)+SUM('3.0 LRAMVA Register'!F$35:F$36)*(MONTH($A93)-1)/12)*$C93","v":-0.57659846562499983},{"$f":"(SUM('3.0 LRAMVA Register'!G$11:G$29)+SUM('3.0 LRAMVA Register'!G$35:G$36)*(MONTH($A93)-1)/12)*$C93","v":-6.3480298291666672},{"$f":"(SUM('3.0 LRAMVA Register'!H$11:H$29)+SUM('3.0 LRAMVA Register'!H$35:H$36)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!I$11:I$29)+SUM('3.0 LRAMVA Register'!I$35:I$36)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!J$11:J$29)+SUM('3.0 LRAMVA Register'!J$35:J$36)*(MONTH($A93)-1)/12)*$C93","v":0},{"$f":"(SUM('3.0 LRAMVA Register'!K$11:K$29)+SUM('3.0 LRAMVA Register'!K$35:K$36)*(MONTH($A93)-1)/12)*$C93","v":0},105.04615881763873]
["2015-01-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$36)*$C94","v":105.74689444160333},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$36)*$C94","v":30.877418115753414},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$36)*$C94","v":7.5386994743025069},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$36)*$C94","v":-10.022203340695},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$36)*$C94","v":-1.2083020221824998},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$36)*$C94","v":-13.302731266341999},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$36)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$36)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$36)*$C94","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$36)*$C94","v":0},119.62977540243978]
["2015-02-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$36)*$C95","v":105.74689444160333},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$36)*$C95","v":30.877418115753414},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$36)*$C95","v":7.5386994743025069},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$36)*$C95","v":-10.022203340695},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$36)*$C95","v":-1.2083020221824998},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$36)*$C95","v":-13.302731266341999},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$36)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$36)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$36)*$C95","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$36)*$C95","v":0},119.62977540243978]
["2015-03-01","Q1",{"$f":"H$28/12","v":1.225E-3},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$36)*$C96","v":105.74689444160333},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$36)*$C96","v":30.877418115753414},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$36)*$C96","v":7.5386994743025069},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$36)*$C96","v":-10.022203340695},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$36)*$C96","v":-1.2083020221824998},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$36)*$C96","v":-13.302731266341999},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$36)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$36)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$36)*$C96","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$36)*$C96","v":0},119.62977540243978]
["2015-04-01","Q2",{"$f":"H$29/12","v":9.1666666666666665E-4},{"$f":"SUM('3.0 LRAMVA Register'!B$11:B$36)*$C97","v":79.130329173988883},{"$f":"SUM('3.0 LRAMVA Register'!C$11:C$36)*$C97","v":23.105550970971944},{"$f":"SUM('3.0 LRAMVA Register'!D$11:D$36)*$C97","v":5.6412036882535768},{"$f":"SUM('3.0 LRAMVA Register'!E$11:E$36)*$C97","v":-7.4996079420166666},{"$f":"SUM('3.0 LRAMVA Register'!F$11:F$36)*$C97","v":-0.90417158122499985},{"$f":"SUM('3.0 LRAMVA Register'!G$11:G$36)*$C97","v":-9.9544247571266666},{"$f":"SUM('3.0 LRAMVA Register'!H$11:H$36)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!I$11:I$36)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!J$11:J$36)*$C97","v":0},{"$f":"SUM('3.0 LRAMVA Register'!K$11:K$36)*$C97","v":0},89.518879552846073]
["Total for rate year 2014",null,null,{"$f":"SUM(D85:D97)","v":2183.0039898521572},{"$f":"SUM(E85:E97)","v":494.54319574259699},{"$f":"SUM(F85:F97)","v":110.49289481713272},{"$f":"SUM(G85:G97)","v":-94.767344166601674},{"$f":"SUM(H85:H97)","v":-11.425250672772497},{"$f":"SUM(I85:I97)","v":-125.78563572615266},{"$f":"SUM(J85:J97)","v":0},0,0,0,{"$f":"SUM(N85:N97)","v":2556.0618498463614}]
["Amount Cleared",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D99:M99)","v":0}]
["Opening Balance for rate year 2015",null,null,{"$f":"D98+D99","v":2183.0039898521572},{"$f":"E98+E99","v":494.54319574259699},110.49289481713272,-94.767344166601674,-11.425250672772497,-125.78563572615266,0,0,0,0,{"$f":"N98+N99","v":2556.0618498463614}]

{"sheet":"6.0 Rates","index":6,"n_rows":27,"n_cols":11,"rows_kept":27,"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\nto\nApr 30, 2012","May 1, 2012\nto\nDec 31, 2012","Jan 1, 2013\nto\nDec 31, 2013","Jan 1, 2014\nto\nDec 31, 2014"]
["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,4,4,4,0,0]
["Pro-ratio of Rates (months) - Period 2",null,null,null,null,null,8,8,8,12,12]
[]
[{"$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.8599999999999998E-2},{"$f":"SUM(H15*$I$12+I15*$I$13)/12","v":1.8733333333333334E-2},{"$f":"SUM(I15*$J$12+J15*$J$13)/12","v":1.78E-2},{"$f":"SUM(J15*$K$12+K15*$K$13)/12","v":1.7999999999999999E-2},1.8599999999999998E-2,1.8599999999999998E-2,1.8800000000000001E-2,1.78E-2,1.7999999999999999E-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":8.7333333333333343E-3},8.5666666666666669E-3,8.0000000000000002E-3,{"$f":"SUM(J16*$K$12+K16*$K$13)/12","v":8.0999999999999996E-3},9.1999999999999998E-3,8.5000000000000006E-3,8.6E-3,8.0000000000000002E-3,8.0999999999999996E-3]
[{"$f":"'4.0 Approved Load Forecast'!F20","v":"General Service > 50 to 4999 kW"},{"$f":"'2.0 Customer Classes'!D15","v":"kW"},3.0111000000000003,2.9664333333333333,2.9773000000000001,3.0190000000000001,3.1351,2.9491000000000001,2.9750999999999999,2.9773000000000001,3.0190000000000001]
[{"$f":"'4.0 Approved Load Forecast'!G20","v":"Unmetered Scattered Load"},{"$f":"'2.0 Customer Classes'!D16","v":"kW"},3.9266666666666665E-2,3.95E-2,1.7000000000000001E-2,1.72E-2,3.9199999999999999E-2,3.9300000000000002E-2,3.9600000000000003E-2,1.7000000000000001E-2,1.72E-2]
[{"$f":"'4.0 Approved Load Forecast'!H20","v":"Sentinel Lighting"},{"$f":"'2.0 Customer Classes'!D17","v":"kWh"},32.112966666666665,34.693933333333327,48.789099999999998,49.47209999999999,27.355699999999999,34.491599999999998,34.795099999999998,48.789099999999998,49.472099999999998]
[{"$f":"'4.0 Approved Load Forecast'!I20","v":"Street Lighting "},{"$f":"'2.0 Customer Classes'!D18","v":"kW"},34.275766666666662,37.197633333333336,37.826799999999999,38.356400000000001,28.8659,36.980699999999999,37.306100000000001,37.826799999999999,38.356400000000001]
[{"$f":"'4.0 Approved Load Forecast'!J20","v":"other"},{"$f":"'2.0 Customer Classes'!D19","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'4.0 Approved Load Forecast'!K20","v":"other"},{"$f":"'2.0 Customer Classes'!D20","v":0},0,0,0,0,0,0,0,0,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 distribution volumetric rates:",null,null,null,null,null,"EB-2009-0232","EB-2010-0093","EB-2011-0176","EB-2012-0139","EB-2013-0144"]

{"sheet":"7.0 2011LostRev","index":7,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[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],[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]]}
["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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",14,100309,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",2,2387,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",58,113459,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",5,78462,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",7,116108,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",130,338,1,null,null,null,null,null,null,null,1]
[8,"Residential New Construction","Verified",0,0,0,null,null,null,null,null,null,null,0]
[null,"Business Program"]
[9,"Retrofit","Verified",0,44014,null,1,0,null,null,null,null,null,{"$f":"SUM(F22:M22)","v":1}]
[10,"Direct Install Lighting","Verified",14,35938,null,1,null,null,null,null,null,null,1]
[11,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[12,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"Energy Audit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Commercial Demand Response (part of residential program)","Verified",3,12,null,1,null,null,null,null,null,null,1]
[15,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"Industrial Program"]
[16,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(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,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[21,"Home Assistance Program","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F36:M36)","v":1}]
[null,"Pre-2011 Programs completed in 2011"]
[22,"Electricity Retrofit Incentive Program","Verified",29,481,null,1,0,null,null,null,null,null,{"$f":"SUM(F38:M38)","v":1}]
[23,"High Performance New Construction","Verified",13,64386,null,1,0,null,null,null,null,null,1]
[24,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[25,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D20,D22:D27,D30:D33,D36,D38:D41)","v":275},{"$f":"SUM(E13:E20,E22:E27,E30:E33,E36,E38:E41)","v":555894},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E20*F20,E36*F36)","v":411063},{"$f":"SUM(E22*G22,E23*G23,E27*G27,E38*G38,E39*G39)","v":144831},{"$f":"SUM($E$22*H22,$E$38*H38,$E$39*H39)","v":0},{"$f":"SUM($E$22*I22,$E$38*I38,$E$39*I39)","v":0},{"$f":"SUM($E$22*J22,$E$38*J38,$E$39*J39)","v":0},0,0,null,{"$f":"SUM(F42:M42)","v":555894}]
[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":0},{"$f":"SUM($D$22*I22,$D$38*I38,$D$39*I39)*$A43","v":0},0,0,0,null,{"$f":"SUM(F43:M43)","v":0}]
[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":275},{"$f":"SUM(E42:E44)","v":555894}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!C15","v":1.8599999999999998E-2},{"$f":"'6.0 Rates'!C16","v":8.7333333333333343E-3},{"$f":"'6.0 Rates'!C17","v":3.0111000000000003},{"$f":"'6.0 Rates'!C18","v":3.9266666666666665E-2},{"$f":"'6.0 Rates'!C19","v":32.112966666666665},{"$f":"'6.0 Rates'!C20","v":34.275766666666662},{"$f":"'6.0 Rates'!C21","v":0}]
[null,"Lost Revenue in 2011",null,null,null,{"$f":"F42*F46","v":7645.7717999999995},{"$f":"G42*G46","v":1264.8574000000001},{"$f":"SUM(H43,H44)*H46","v":0},{"$f":"I43*I46","v":0},0,0,0,null,{"$f":"SUM(F47:M47)","v":8910.6291999999994}]
[null,"2011 Savings Persisting in 2012",null,null,null,{"$f":"F42*'11.0 Persistence '!C42","v":411063},{"$f":"G42*'11.0 Persistence '!C42","v":144831},{"$f":"H43*'11.0 Persistence '!C24","v":0},{"$f":"I43*'11.0 Persistence '!C24","v":0},{"$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":411063},{"$f":"G42*'11.0 Persistence '!D42","v":144831},{"$f":"H43*'11.0 Persistence '!D24","v":0},{"$f":"I43*'11.0 Persistence '!D24","v":0},{"$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":342552.5},{"$f":"G42*'11.0 Persistence '!E42","v":120692.5},{"$f":"H43*'11.0 Persistence '!E24","v":0},{"$f":"I43*'11.0 Persistence '!E24","v":0},{"$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,"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":[[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],[9,0,10,0],[9,1,10,1],[9,5,9,13],[11,1,11,2],[25,1,25,2],[21,1,21,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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",5,38037,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",1,1178,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",46,81926,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",1,5524,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",6,105813,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",null,null,1,null,null,null,null,null,null,null,{"$f":"SUM(F20:M20)","v":1}]
[9,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["3a","HVAC Incentives","True-Up",-9,7220,1,null,null,null,null,null,null,null,1]
["4a","Conservation Instant Coupon Booklet","True-Up",null,null,1,null,null,null,null,null,null,null,1]
["5a","Bi-Annual Retailer Event","True-Up",null,null,1,null,null,null,null,null,null,null,1]
[null,"Business Program"]
[10,"Retrofit","Verified",37,221113,null,0.2,0.8,null,null,null,null,null,{"$f":"SUM(F27:M27)","v":1}]
[11,"Direct Install Lighting","Verified",23,88865,null,1,null,null,null,null,null,null,1]
[12,"Building Commissioning","Verified",null,null,null,null,null,null,null,null,null,null,0]
[13,"New Construction","Verified",null,null,null,null,null,null,null,null,null,null,0]
[14,"Energy Audit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[15,"Small Commercial Demand Response (switch/pstat)*","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F32:M32)","v":0}]
[16,"Small Commercial Demand Response (IHD)","Verified",null,null,null,null,null,null,null,null,null,null,0]
[17,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"2011 True-up (Verified Errors & Omissions)"]
["11a","Direct Install Lighting","True-Up",null,null,null,1,null,null,null,null,null,null,1]
[null,"Industrial Program"]
[18,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F38:M38)","v":0}]
[19,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Energy Manager","Verified",null,null,null,null,null,null,null,null,null,null,0]
[21,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[22,"Demand Response 3","Verified",null,null,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",8,58650,1,null,null,null,null,null,null,null,{"$f":"SUM(F44:M44)","v":1}]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F46:M46)","v":1}]
[25,"High Performance New Construction","Verified",null,433,null,null,1,null,null,null,null,null,1]
[26,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[27,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[28,"LDC Custom Programs","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"2011 True-up (Verified Errors & Omissions)"]
["22a","High Performance New Construction","True-Up",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":1}]
[null,"Other"]
[29,"Program Enabled Savings","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F54:M54)","v":0}]
[30,"Time-of-Use Savings","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D25,D27:D33,D35:D36,D38:D41,D44,D46:D52,D54:D55)","v":118},{"$f":"SUM(E13:E25,E27:E33,E35:E36,E38:E41,E44,E46:E52,E54:E55)","v":608759},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E23*F23,E24*F24,E25*F25,E44*F44)","v":298348},{"$f":"SUM(E27*G27,E28*G28,E36*G36)","v":133087.6},{"$f":"SUM($E$27*H27,$E$46*H46,$E$47*H47,$E$52*H52)","v":177323.40000000002},{"$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":608759}]
[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":355.20000000000005},{"$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":355.20000000000005}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D42)","v":0},{"$f":"SUM(E34,E42)","v":0},null,null,{"$f":"SUM($D$34*H34,$D$42*H42)*$A$58","v":0},{"$f":"SUM($D$34*I34,$D$42*I42)*$A$58","v":0},0,0,0,null,{"$f":"SUM(F58:M58)","v":0}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D56:D58)","v":118},{"$f":"SUM(E56:E58)","v":608759}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!D15","v":1.8733333333333334E-2},{"$f":"'6.0 Rates'!D16","v":8.5666666666666669E-3},{"$f":"'6.0 Rates'!D17","v":2.9664333333333333},{"$f":"'6.0 Rates'!D18","v":3.95E-2},{"$f":"'6.0 Rates'!D19","v":34.693933333333327},{"$f":"'6.0 Rates'!D20","v":37.197633333333336},{"$f":"'6.0 Rates'!D21","v":0}]
[null,"Lost Revenue in 2012 from 2012",null,null,null,{"$f":"F56*F60","v":5589.0525333333335},{"$f":"G56*G60","v":1140.1171066666668},{"$f":"SUM(H57,H58)*H60","v":1053.6771200000001},{"$f":"SUM(I57,I58)*I60","v":0},{"$f":"J57*J60","v":0},0,0,null,{"$f":"SUM(F61:M61)","v":7782.8467600000004}]
[null,"Lost Revenue in 2012 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F48*F60","v":7700.5802000000003},{"$f":"'7.0 2011LostRev'!G48*G60","v":1240.7189000000001},{"$f":"'7.0 2011LostRev'!H48*H60","v":0},{"$f":"'7.0 2011LostRev'!I48*I60","v":0},{"$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":8941.2991000000002}]
[null,"Total Lost Revenue in 2012",null,null,null,{"$f":"SUM(F61:F62)","v":13289.632733333334},{"$f":"SUM(G61:G62)","v":2380.8360066666669},1053.6771200000001,0,0,0,0,null,{"$f":"SUM(N61:N62)","v":16724.145860000001}]
[null,"2012 Savings Persisting in 2013",null,null,null,{"$f":"F56*'11.0 Persistence '!D43","v":298348},{"$f":"G56*'11.0 Persistence '!D43","v":133087.6},{"$f":"H57*'11.0 Persistence '!D25","v":355.20000000000005},{"$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":298348},{"$f":"G56*'11.0 Persistence '!E43","v":133087.6},{"$f":"H57*'11.0 Persistence '!E25","v":355.20000000000005},{"$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":"9.0 2013LostRev","index":9,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[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],[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]]}
["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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",3,19120,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",4,7019,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",46,83619,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",2,30452,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",5,67876,1,null,null,null,null,null,null,null,1]
[6,"Retailer Co-op","Verified",null,null,1,null,null,null,null,null,null,null,1]
[7,"Residential Demand Response (switch/pstat)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[8,"Residential Demand Response (IHD)","Verified",null,null,1,null,null,null,null,null,null,null,1]
[9,"Residential New Construction","Verified",null,null,1,null,null,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,"HVAC Incentives","True-up",-9,7220,1]
[null,null,"True-up"]
[null,null,"True-up"]
[null,"Business Program"]
[10,"Retrofit","Verified",53,282136,null,0.2,0.8,null,null,null,null,null,{"$f":"SUM(F27:M27)","v":1}]
[11,"Direct Install Lighting","Verified",29,116579,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",166,2828,null,0,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,"Retrofit","True-up",47,229344,null,0.2,0.8]
[null,null,"True-up"]
[null,null,"True-up"]
[null,"Industrial Program"]
[18,"Process & System Upgrades","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F40:M40)","v":0}]
[19,"Monitoring & Targeting","Verified",null,null,null,null,null,null,null,null,null,null,0]
[20,"Energy Manager","Verified",149,356400,null,0.5,0.5,null,null,null,null,null,1]
[21,"Retrofit","Verified",null,null,null,null,null,null,null,null,null,null,0]
[22,"Demand Response 3","Verified",166,3780,null,null,1,null,null,null,null,null,1]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",18,99879,1,null,null,null,null,null,null,null,{"$f":"SUM(F48:M48)","v":1}]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Pre-2011 Programs completed in 2011"]
[24,"Electricity Retrofit Incentive Program","Verified",null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(F52:M52)","v":1}]
[25,"High Performance New Construction","Verified",null,null,null,null,1,null,null,null,null,null,1]
[26,"Toronto Comprehensive","Verified",null,null,null,null,null,null,null,null,null,null,0]
[27,"Multifamily Energy Efficiency Rebates","Verified",null,null,null,null,null,null,null,null,null,null,0]
[28,"LDC Custom Programs","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"2012 True-up (Verified Errors & Omissions)"]
[null,null,"True-up"]
[null,"Other"]
[29,"Program Enabled Savings","Verified",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F60:M60)","v":0}]
[30,"Time-of-Use Savings","Verified",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total kWh",null,{"$f":"SUM(D13:D21,D27:D33,D40:D43,D48,D52:D56,D60:D61)","v":309},{"$f":"SUM(E13:E21,E27:E33,E40:E43,E48,E52:E56,E60:E61)","v":1063080},{"$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":315185},{"$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":218875},{"$f":"SUM($E$27*H27,$E$34*H34,$E$44*H44,$E$52*H52,$E$53*H53,$E$28*H28,$E$29*H29,$E$30*H30,$E$31*H31,$E$36*H36,$E$37*H37,$E$38*H38,$E$46*H46,$E$58*H58)","v":415792},{"$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":949852}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM($D$27*H27,$D$52*H52,$D$53*H53)*$A63","v":508.80000000000007},{"$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":508.80000000000007}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D34,D44)","v":332},{"$f":"SUM(E34,E44)","v":6608},null,null,{"$f":"SUM($D$34*H34,$D$44*H44)*$A64","v":1660},{"$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":1660}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D62:D64)","v":641},{"$f":"SUM(E62:E64)","v":1069688}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!E15","v":1.78E-2},{"$f":"'6.0 Rates'!E16","v":8.0000000000000002E-3},{"$f":"'6.0 Rates'!E17","v":2.9773000000000001},{"$f":"'6.0 Rates'!E18","v":1.7000000000000001E-2},{"$f":"'6.0 Rates'!E19","v":48.789099999999998},{"$f":"'6.0 Rates'!E20","v":37.826799999999999},{"$f":"'6.0 Rates'!E21","v":0}]
[null,"Lost Revenue in 2013 from 2013",null,null,null,{"$f":"F62*F66","v":5610.2929999999997},{"$f":"G62*G66","v":1751},{"$f":"SUM(H63,H64)*H66","v":6457.1682400000009},{"$f":"SUM(I63,I64)*I66","v":0},{"$f":"J63*J66","v":0},0,0,null,{"$f":"SUM(F67:M67)","v":13818.461240000001}]
[null,"Lost Revenue in 2013 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F64*F66","v":5310.5944},{"$f":"'8.0 2012LostRev'!G64*G66","v":1064.7008000000001},{"$f":"'8.0 2012LostRev'!H64*H66","v":1057.5369600000001},{"$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":7432.8321600000008}]
[null,"Lost Revenue in 2013 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F49*F66","v":7316.9214000000002},{"$f":"'7.0 2011LostRev'!G49*G66","v":1158.6479999999999},{"$f":"'7.0 2011LostRev'!H49*H66","v":0},{"$f":"'7.0 2011LostRev'!I49*I66","v":0},{"$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,8475.5694000000003]
[null,"Total Lost Revenue in 2013",null,null,null,{"$f":"SUM(F67:F69)","v":18237.808799999999},{"$f":"SUM(G67:G69)","v":3974.3487999999998},7514.7052000000012,0,0,0,0,null,{"$f":"SUM(N67:N69)","v":29726.862800000003}]
[null,"2013 Savings Persisting in 2014",null,null,null,{"$f":"F62*'11.0 Persistence '!E44","v":315185},{"$f":"G62*'11.0 Persistence '!E44","v":218875},{"$f":"H63*'11.0 Persistence '!E26","v":218.05714285714291},{"$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":10,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[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],[55,1,55,2],[49,1,49,2],[50,1,50,2],[54,1,54,2],[52,1,52,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 4999 kW"},{"$f":"'3.0 LRAMVA Register'!E10","v":"Unmetered Scattered Load"},{"$f":"'3.0 LRAMVA Register'!F10","v":"Sentinel Lighting"},{"$f":"'3.0 LRAMVA Register'!G10","v":"Street Lighting "},{"$f":"'3.0 LRAMVA Register'!H10","v":"other"},{"$f":"'3.0 LRAMVA Register'!K10","v":"other"},{"$f":"'3.0 LRAMVA Register'!L10","v":"Total"}]
[null,"Consumer Program"]
[1,"Appliance Retirement","Verified",2,14856,1,null,null,null,null,null,null,null,{"$f":"SUM(F13:M13)","v":1}]
[2,"Appliance Exchange","Verified",4,6650,1,null,null,null,null,null,null,null,{"$f":"SUM(F14:M14)","v":1}]
[3,"HVAC Incentives","Verified",52,96392,1,null,null,null,null,null,null,null,1]
[4,"Conservation Instant Coupon Booklet","Verified",8,111610,1,null,null,null,null,null,null,null,1]
[5,"Bi-Annual Retailer Event","Verified",32,485581,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",28,0,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",32,178737,"%",0.2,0.8,null,null,null,null,null,{"$f":"SUM(F23:M23)","v":1}]
[11,"Direct Install Lighting","Verified",55,220025,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",5,24230,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",3,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",230,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",{"$f":"175","v":175},null,null,null,1,null,null,null,null,null,1]
[null,"Home Assistance Program"]
[23,"Home Assistance Program","Verified",1,8791,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",103,null,0.8,0.2,null,null,null,null,null,null,1]
[null,"Total kWh",null,{"$f":"SUM(D13:D18,D23:D27,D32:D35,D38,D40:D44,D46:D47)","v":294},{"$f":"SUM(E13:E21,E23:E29,E32:E35,E38,E40:E44,E46:E47)","v":1146872},{"$f":"SUM(E13*F13,E14*F14,E15*F15,E16*F16,E17*F17,E18*F18,E19*F19,E21*F21,E38*F38)","v":723880},{"$f":"SUM(E23*G23,E24*G24)","v":255772.4},{"$f":"SUM(E23*H23,E30*H30,E36*H36,E40*H40,E41*H41)","v":142989.6},null,null,null,null,null,{"$f":"SUM(F48:M48)","v":1122642}]
[12,"Total GS > 50 kW excluding Demand Response 3",null,null,null,null,null,{"$f":"SUM(D23*H23,D40*H40,D41*H41)*$A49","v":307.20000000000005},null,null,null,null,null,{"$f":"SUM(F49:M49)","v":307.20000000000005}]
[5,"Demand Response Total (Scenario 1)",null,{"$f":"SUM(D19,D28,D30,D36,)","v":436},{"$f":"SUM(E30,E36)","v":0},null,null,{"$f":"SUM(D30*H30,D36*H36)*$A50","v":2025},null,null,null,null,null,{"$f":"SUM(F50:M50)","v":2025}]
[null,"OPA-Contracted LDC Portfolio Total",null,{"$f":"SUM(D48:D50)","v":730},{"$f":"SUM(E48:E50)","v":1146872}]
[null,"Rate",null,null,null,{"$f":"'6.0 Rates'!F15","v":1.7999999999999999E-2},{"$f":"'6.0 Rates'!F16","v":8.0999999999999996E-3},{"$f":"'6.0 Rates'!F17","v":3.0190000000000001},{"$f":"'6.0 Rates'!F18","v":1.72E-2},{"$f":"'6.0 Rates'!F19","v":49.47209999999999},{"$f":"'6.0 Rates'!F20","v":38.356400000000001},{"$f":"'6.0 Rates'!F21","v":0}]
[null,"Lost Revenue in 2014 from 2014",null,null,null,{"$f":"F48*F52","v":13029.839999999998},{"$f":"G48*G52","v":2071.7564399999997},{"$f":"SUM(H49,H50)*H52","v":7040.9117999999999},{"$f":"SUM(I49,I50)*I52","v":0},{"$f":"J49*J52","v":0},0,0,null,{"$f":"SUM(F53:M53)","v":22142.508239999996}]
[null,"Lost Revenue in 2014 from 2013",null,null,null,{"$f":"'9.0 2013LostRev'!F71*F52","v":5673.33},{"$f":"'9.0 2013LostRev'!G71*G52","v":1772.8874999999998},{"$f":"'9.0 2013LostRev'!H71*H52","v":658.31451428571449},{"$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":8104.5320142857145}]
[null,"Lost Revenue in 2014 from 2012",null,null,null,{"$f":"'8.0 2012LostRev'!F65*F52","v":5370.2639999999992},{"$f":"'8.0 2012LostRev'!G65*G52","v":1078.00956},{"$f":"'8.0 2012LostRev'!H65*H52","v":1072.3488000000002},{"$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":7520.6223599999994}]
[null,"Lost Revenue in 2014 from 2011",null,null,null,{"$f":"'7.0 2011LostRev'!F50*F52","v":6165.9449999999997},{"$f":"'7.0 2011LostRev'!G50*G52","v":977.60924999999997},{"$f":"'7.0 2011LostRev'!H50*H52","v":0},{"$f":"'7.0 2011LostRev'!I50*I52","v":0},{"$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,7143.5542499999992]
[null,"Total Lost Revenue in 2014",null,null,null,{"$f":"SUM(F53:F56)","v":30239.378999999997},{"$f":"SUM(G53:G56)","v":5900.2627499999999},8771.5751142857152,0,0,0,0,null,{"$f":"SUM(N53:N56)","v":44911.216864285714}]
[]
[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":11,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[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],[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]]}
["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.3,0.1,0.1,0.1]
["2012 - Verified",0,0.1,0.1,0.1]
[2013,0,0,0.7,0.3]
[2014]
["Verified Net Annual Peak Demand Savings Persisting in 2014:  ",null,null,null,{"$f":"SUM(E15:E18)","v":0.5}]
["2011-2014 CDM Capacity Target",null,null,null,2.5]
["Verified Portion of Peak Demand Savings Target Achieved in 2014(%):  ",null,null,null,{"$f":"E19/E20","v":0.2}]
[]
["Persistence Factor (MW)"]
[2011,null,{"$f":"C15/$B$15","v":0.33333333333333337},{"$f":"D15/$B$15","v":0.33333333333333337},{"$f":"E15/$B$15","v":0.33333333333333337}]
[2012,null,null,{"$f":"D16/$C$16","v":1},{"$f":"E16/$C$16","v":1}]
[2013,null,null,null,{"$f":"E17/D17","v":0.4285714285714286}]
[]
[]
["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.6,0.6,0.6,0.5,2.2000000000000002]
["2012 - Verified",0,0.6,0.6,0.6,{"$f":"SUM(B34:E34)","v":1.7999999999999998}]
[2013,0,0.2,1.3,1.3,{"$f":"SUM(B35:E35)","v":2.8}]
[2014,null,null,null,1,1]
["Verified Net Cumulative Energy Savings 2011-2014:",null,null,null,null,{"$f":"SUM(F33:F36)","v":7.8}]
[" 2011-2014 CDM Energy Target",null,null,null,null,9.1999999999999993]
["Verified Portion of Cumulative Energy Target Achieved (%):  ",null,null,null,null,{"$f":"F37/F38","v":0.84782608695652184}]
[]
["Persistence Factor (GWh)"]
[2011,null,{"$f":"C33/$B$33","v":1},{"$f":"D33/$B$33","v":1},{"$f":"E33/$B$33","v":0.83333333333333337}]
[2012,null,null,{"$f":"D34/$C$34","v":1},{"$f":"E34/$C$34","v":1}]
[2013,null,null,null,{"$f":"E35/D35","v":1}]

{"sheet":"Sheet1","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}