{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["A1.1 LDC Information","A2.1 Table of Contents","B1.1 Re-Based Bill Det & Rates","B1.2 Removal of Rate Adders","B1.3 Re-Based Rev From Rates","B1.4 Re-Based Rev Req","C1.1 Ld Act-Mst Rcent Yr","F1.2 CalcTaxChg RRider OptA FV","D1.1 Current Revenue from Rates","E1.1 Threshold Parameters","E2.1 Threshold Test","E3.1 Summary of I C Projects","E4.1 IncrementalCapitalAdjust","F1.1 Incr Cap RRider Opt A FV","F1.2 Incr Cap RRider Opt B Var","Z1.0 OEB Control Sheet"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"A1.1 LDC Information","index":0,"n_rows":105,"n_cols":34,"rows_kept":105,"cut":false,"hidden":false,"merged":[[19,3,19,4],[18,2,18,7],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Applicant Name","Festival Hydro Inc.",null,"OEB Audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name","Licence Number","EB Number","Application Type","Effective Date","Stretch Factor","Last Rebasing","Previous COS EB Number"]
[null,null,null,null,null,{"$f":"'Z1.0 OEB Control Sheet'!F2","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc.","ED-2009-0072","EB-2011-0152","IRM3","2012-05-01","II",2010,"EB-2010-0400"]
[null,null,"Application Type","IRM3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc.","ED-2003-0001",null,"IRM3","2012-05-01","II",2006,"EB-2005-0371"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attawapiskat Power Corp. ","ED-2001-0090",null,"IRM3","2012-05-01","II",2006]
[null,null,"LDC Licence Number","ED-2002-0513",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corporation","ED-2002-0517","EB-2011-0153","IRM3","2012-05-01","II",2009,"EB-2008-0221"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County Power Inc.","ED-2002-0522","EB-2011-0154","IRM3","2012-05-01","II",2011,"EB-2010-0125"]
[null,null,"Applied for Effective Date","2013-05-01",null,"May 1, 2013",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc.","ED-2003-0060","EB-2011-0147","IRM3","2012-05-01","II",2008,"EB-2007-0698"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc.","ED-2003-0004","EB-2011-0155","IRM3","2012-05-01","II",2010,"EB-2009-0259"]
[null,null,"Stretch Factor Group","I",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge and North Dumfries Hydro Inc.","ED-2002-0574","EB-2011-0156","IRM3","2012-05-01","II",2010,"EB-2009-0260"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. - Eastern Ontario Power","ED-2002-0572","EB-2011-0158","IRM3","2012-05-01","II",2009,"EB-2008-0222"]
[null,null,"Stretch Factor Value",{"$f":"STRETCH(D28)","v":2E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. - Fort Erie","ED-2002-0572","EB-2011-0158","IRM3","2012-05-01","II",2009,"EB-2008-0223"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. - Port Colborne Hydro Inc.","ED-2002-0572","EB-2011-0157","IRM3","2012-05-01","II",2009,"EB-2008-0224"]
[null,null,"Last COS Re-based Year",2010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd.","ED-2002-0498","EB-2011-0160","IRM3","2012-05-01","II",2009,"EB-2008-0225"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation","ED-2002-0528",null,"IRM3","2012-05-01","II",2008,"EB-2007-0755"]
[null,null,"Last COS OEB Application Number","EB-2009-0263",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chatham-Kent Hydro Inc.","ED-2002-0563","EB-2011-0163","IRM3","2012-05-01","II",2010,"EB-2009-0261"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinton Power Corporation","ED-2002-0496","EB-2011-0162","IRM3","2012-05-01","II",2010,"EB-2009-0262"]
[null,null,"ICM Billing Determinants for Growth - Numerator",{"$f":"ICMGrowthNumerator(D32)","v":"2010 Re-based Forecast"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corporation","ED-2002-0518","EB-2011-0163","IRM3","2012-05-01","II",2009,"EB-2008-0226"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc.","ED-2002-0493","EB-2011-0164","IRM3","2012-05-01","II",2010,"EB-2009-0132"]
[null,null,"ICM Billing Determinants for Growth - Denominator",{"$f":"ICMGrowthDenominator(D32)","v":"2011 Actual"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc.","ED-2003-0015","EB-2011-0099","IRM3","2012-05-01","II",2008,"EB-2007-0840"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enersource Hydro Mississauga Inc.","ED-2003-0017","EB-2011-0100","IRM3","2012-05-01","II",2008,"EB-2007-0706"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd.","ED-2002-0527","EB-2011-0165","IRM3","2012-05-01","II",2008,"EB-2008-0227"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie Thames Powerlines Corporation","ED-2002-0516",null,"IRM3","2012-05-01","II",2008,"EB-2007-0928"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espanola Regional Hydro Distribution Corporation","ED-2002-0502",null,"IRM3","2012-05-01","II",2008,"EB-2007-0901"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation","ED-2002-0499","EB-2011-0166","IRM3","2012-05-01","II",2010,"EB-2009-0143"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc.","ED-2002-0513","EB-2011-0167","IRM3","2012-05-01","II",2010,"EB-2009-0263"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Albany Power Corporation","ED-2003-0079","EB-2011-0168","IRM3","2012-05-01","II",2006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation","ED-2003-0028","EB-2011-0146","IRM3","2012-05-01","II",2008,"EB-2007-0885"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc.","ED-2002-0559","EB-2011-0169","IRM3","2012-05-01","II",2009,"EB-2008-0229"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimsby Power Inc.","ED-2002-0554",null,"IRM3","2012-05-01","II",2006,"EB-2005-0371"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guelph Hydro Electric Systems Inc.","ED-2002-0565","EB-2011-0123","IRM3","2012-05-01","II",2008,"EB-2007-0742"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro Inc.","ED-2002-0539","EB-2011-0170","IRM3","2012-05-01","II",2010,"EB-2009-0265"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc.","ED-2002-0552",null,"IRM3","2012-05-01","II",2008,"EB-2007-0696"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Company Limited","ED-2002-0533","EB-2011-0171","IRM3","2012-05-01","II",2010,"EB-2009-0266"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Utilities Corporation","ED-2006-0031","EB-2011-0172","IRM3","2012-05-01","II",2011,"EB-2010-0131"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc.","ED-2002-0542",null,"IRM3","2012-05-01","II",2008,"EB-2007-0704"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc.","ED-2003-0027","EB-2011-0173","IRM3","2012-05-01","II",2010,"EB-2009-0186"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Brampton Networks Inc.","ED-2003-0038","EB-2011-0174","IRM3","2012-05-01","II",2011,"EB-2010-0132"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc.","ED-2003-0043","EB-2011-0215","IRM3","2012-05-01","II",2010,"EB-2009-0096"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communities Inc.","ED-2003-0037","EB-2011-0175","IRM3","2012-05-01","II",2009,"EB-2008-0232"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited","ED-2002-0556","EB-2011-0054","IRM3","2012-05-01","II",2008,"EB-2007-0713"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innisfil Hydro Distribution Systems Limited","ED-2002-0520","EB-2011-0176","IRM3","2012-05-01","II",2009,"EB-2008-0233"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kashechewan Power Corporation","ED-2003-0081",null,"IRM3","2012-05-01","II",2006,"EB-2005-0383"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenora Hydro Electric Corporation Ltd.","ED-2003-0030","EB-2011-0177","IRM3","2012-05-01","II",2011,"EB-2010-0135"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation","ED-2003-0057","EB-2011-0178","IRM3","2012-05-01","II",2011,"EB-2010-0136"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kitchener-Wilmot Hydro Inc.","ED-2002-0573","EB-2011-0179","IRM3","2012-05-01","II",2010,"EB-2009-0267"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc.","ED-2002-0545",null,"IRM3","2012-05-01","II",2008,"EB-2007-0761"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd.","ED-2002-0540","EB-2011-0180","IRM3","2012-05-01","II",2009,"EB-2008-0234"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London Hydro Inc.","ED-2002-0567","EB-2011-0181","IRM3","2012-05-01","II",2008,"EB-2008-0235"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middlesex Power Distribution Corporation","ED-2003-0059","EB-2011-0148","IRM3","2012-05-01","II",2006,"EB-2005-0351"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middlesex Power Distribution Corporation - Dutton","ED-2003-0059","EB-2011-0149","IRM3","2012-05-01","II",2009,"EB-2009-0177"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Middlesex Power Distribution Corporation - Newbury","ED-2003-0059","EB-2011-0150","IRM3","2012-05-01","II",2008,"EB-2007-0864"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midland Power Utility Corporation","ED-2002-0541","EB-2011-0182","IRM3","2012-05-01","II",2009,"EB-2008-0236"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution inc.","ED-2003-0014","EB-2011-0183","IRM3","2012-05-01","II",2011,"EB-2010-0137"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket-Tay Power Distribution Ltd.","ED-2007-0624 ","EB-2011-0184","IRM3","2012-05-01","II",2010,"EB-2009-0269"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc.","ED-2007-0749","EB-2011-0185","IRM3","2012-05-01","II",2011,"EB-2010-0138"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc.","ED-2002-0547","EB-2011-0186","IRM3","2012-05-01","II",2009,"EB-2008-0237"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norfolk Power Distribution Inc.","ED-2002-0521",null,"IRM3","2012-05-01","II",2008,"EB-2007-0753"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited","ED-2003-0024","EB-2011-0187","IRM3","2012-05-01","II",2010,"EB-2009-0270"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc.","ED-2003-0118","EB-2011-0188","IRM3","2012-05-01","II",2009,"EB-2008-0238"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Electricity Distribution Inc.","ED-2003-0135","EB-2011-0189","IRM3","2012-05-01","II",2010,"EB-2009-0271"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited","ED-2002-0500","EB-2011-0190","IRM3","2012-05-01","II",2010,"EB-2009-0272"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corporation","ED-2002-0530","EB-2011-0191","IRM3","2012-05-01","II",2008,"EB-2009-0273"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc.","ED-2002-0560","EB-2011-0073","IRM3","2012-05-01","II",2008,"EB-2007-0710"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation","ED-2003-0033","EB-2011-0192","IRM3","2012-05-01","II",2010,"EB-2009-0165"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parry Sound Power Corporation","ED-2003-0006","EB-2011-0193","IRM3","2012-05-01","II",2011,"EB-2010-0140"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough Distribution Incorporated","ED-2002-0504","EB-2011-0194","IRM3","2012-05-01","II",2009,"EB-2008-0241"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PowerStream Inc. - Barrie","ED-2004-0420","EB-2011-0005","IRM3","2012-05-01","II",2009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PowerStream Inc. - South","ED-2004-0420","EB-2011-0005","IRM3","2012-05-01","II",2009,"EB-2008-0244"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc.","ED-2002-0546","EB-2011-0101","IRM3","2012-05-01","II",2008,"EB-2007-0931"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc.","ED-2002-0577","EB-2011-0195","IRM3","2012-05-01","II",2010,"EB-2009-0146"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc.","ED-2003-0003",null,"IRM3","2012-05-01","II",2008,"EB-2007-0762"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc.","ED-2002-0514","EB-2011-0102","IRM3","2012-05-01","II",2008,"EB-2007-0785"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Thomas Energy Inc.","ED-2002-0523","EB-2011-0196","IRM3","2012-05-01","II",2011,"EB-2010-0141"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thunder Bay Hydro Electricity Distribution Inc.","ED-2002-0529","EB-2011-0197","IRM3","2012-05-01","II",2009,"EB-2008-0245"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc.","ED-2003-0026","EB-2011-0198","IRM3","2012-05-01","II",2009,"EB-2008-0246"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited","ED-2002-0497","EB-2011-0144","IRM3","2012-05-01","II",2011,"EB-2010-0142"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veridian Connections Inc.","ED-2002-0503","EB-2011-0199","IRM3","2012-05-01","II",2010,"EB-2009-0140"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc.","ED-2002-0544","EB-2011-0103","IRM3","2012-05-01","II",2006,"EB-2005-0427"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterloo North Hydro Inc.","ED-2002-0575","EB-2011-0201","IRM3","2012-05-01","II",2011,"EB-2010-0144"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Welland Hydro-Electric System Corp.","ED-2003-0002","EB-2011-0202","IRM3","2012-05-01","II",2009,"EB-2008-0247"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc.","ED-2002-0511",null,"IRM3","2012-05-01","II",2008,"EB-2007-0693"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Coast Huron Energy Inc.","ED-2002-0510","EB-2011-0203","IRM3","2012-05-01","II",2009,"EB-2008-0248"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Perth Power Inc.","ED-2002-0508","EB-2011-0204","IRM3","2012-05-01","II",2010,"EB-2009-0255"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc.","ED-2002-0515","EB-2011-0205","IRM3","2012-05-01","II",2009,"EB-2008-0250"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitby Hydro Electric Corporation","ED-2002-0571 ","EB-2011-0206","IRM3","2012-05-01","II",2010,"EB-2009-0274"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodstock Hydro Services Inc.","ED-2003-0011","EB-2011-0207","IRM3","2012-05-01","II",2011,"EB-2010-0145"]

{"sheet":"A2.1 Table of Contents","index":1,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C3","v":"Table of Contents"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sheet Name","Purpose of Sheet"]
[]
[null,null,"A1.1 LDC Information",{"$f":"VLOOKUP(C22,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Enter LDC Data"}]
[]
[null,null,"A2.1 Table of Contents",{"$f":"VLOOKUP(C24,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Table of Contents"}]
[]
[null,null,"B1.1 Re-Based Bill Det & Rates",{"$f":"VLOOKUP(C26,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Set Up Rate Classes and enter Re-Based Billing Determinants and Tariff Rates "}]
[]
[null,null,"B1.2 Removal of Rate Adders",{"$f":"VLOOKUP(C28,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Removal of Rate Adders"}]
[]
[null,null,"B1.3 Re-Based Rev From Rates",{"$f":"VLOOKUP(C30,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Calculated Re-Based Revenue From Rates"}]
[]
[null,null,"B1.4 Re-Based Rev Req",{"$f":"VLOOKUP(C32,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Detailed Re-Based Revenue From Rates"}]
[]
[null,null,"C1.1 Ld Act-Mst Rcent Yr",{"$f":"VLOOKUP(C34,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Enter Billing Determinants for most recent actual year"}]
[]
[null,null,"D1.1 Current Revenue from Rates",{"$f":"VLOOKUP(C36,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Enter Current Rates to calculate current rate allocation"}]
[]
[null,null,"E1.1 Threshold Parameters",{"$f":"VLOOKUP(C38,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Shows calculation of Price Cap and Growth used for incremental capital threshold calculation"}]
[]
[null,null,"E2.1 Threshold Test",{"$f":"VLOOKUP(C40,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Input sheet to calculate Threshold and Incremental Capital"}]
[]
[null,null,"E3.1 Summary of I C Projects",{"$f":"VLOOKUP(C42,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Summary of Incremental Capital Projects"}]
[]
[null,null,"E4.1 IncrementalCapitalAdjust",{"$f":"VLOOKUP(C44,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Shows Calculation of Incremental Capital Revenue Requirement"}]
[]
[null,null,"F1.1 Incr Cap RRider Opt A FV",{"$f":"VLOOKUP(C46,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Option A - Calculation of Incremental Capital Rate Rider - Fixed & Variable Split"}]
[]
[null,null,"F1.2 Incr Cap RRider Opt B Var",{"$f":"VLOOKUP(C48,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Option B - Calculation of Incremental Capital Rate Rider - Variable Allocation"}]
[]
[null,null,"Z1.0 OEB Control Sheet",{"$f":"VLOOKUP(C50,'Z1.0 OEB Control Sheet'!D:G,4,0)","v":"Not Shown"}]

{"sheet":"B1.1 Re-Based Bill Det & Rates","index":2,"n_rows":46,"n_cols":51,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,2,11,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C4","v":"Rate Class and Re-Based Billing Determinants & Rates"}]
[]
[null,null,"Select the appropriate Rate Groups and Rate Classes from the drop-down menus in Columns C and D respectively.  Following your selection, all appropriate input cells will be shaded green.\n"]
[]
[]
[]
[null,null,null,"Last COS Re-based Year",null,null,null,null,{"$f":"'A1.1 LDC Information'!D32","v":2010}]
[]
[null,null,null,"Last COS OEB Application Number",null,null,null,null,{"$f":"'A1.1 LDC Information'!D34","v":"EB-2009-0263"}]
[]
[null,"Control","Rate Group","Rate Class","Fixed Metric","Vol Metric","OEB Audit",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Re-based Tariff Service Charge","Re-based Tariff Distribution Volumetric Rate kWh","Re-based Tariff Distribution Volumetric Rate kW",null,null,null,null,null,null,null,null,null,null,null,"Residential","Threshold",null,"Less Than 50","Threshold",null,"Greater Than 50","Threshold",null,"Large Use","Threshold",null,"USL","Threshold",null,"Sentinel","Threshold",null,"Street","Threshold",null,"EMB",null,null,"SB"]
[null,null,null,null,null,null,null,null,"A","B","C",null,"D","E","F",null,null,null,null,null,null,null,null,null,null,null,"Residential","250 / 2,250",null,"General Service Less Than 50 kW","2,000 / 20,000",null,"General Service 50 to 499 kW","50 / 500",null,"Large Use","5,000 / 100,000",null,"Unmetered Scattered Load","500 / 20,000",null,"Sentinel Lighting","0.2 / 1.0",null,"Street Lighting","0.2 / 1.0",null,"Embedded Distributor",null,null,"Stand-By"]
[null,1,"RES","Residential","Customer","kWh",null,null,17115,141132375,null,null,14.75,1.6299999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Regular","250 / 2,250",null,"General Service Less Than 50 kW – Single Phase energy-billed [G1]","2,000 / 20,000",null,"General Service 50 to 699 kW","50 / 700",null,"Large Use - Regular","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,"Low Voltage Wheeling Charge Rate",null,null,"Standby Power"]
[null,2,"RES","Residential - Hensall","Customer","kWh",null,null,413,4143109,null,null,11.21,1.2E-2,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Urban","250 / 2,250",null,"General Service Less Than 50 kW – Three Phase energy-billed [G3]","2,000 / 20,000",null,"General Service 50 to 999 kW","50 / 1,000",null,"Large Use > 5000 kW","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power – INTERIM APPROVAL"]
[null,3,"GSLT50","General Service Less Than 50 kW","Customer","kWh",null,null,1968,67469308,null,null,29.05,1.4500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Urban Year-Round","250 / 2,250",null,"General Service Less Than 50 kW – Transmission Class energy-billed [T]","2,000 / 20,000",null,"General Service 50 to 1,000 kW - Interval Meters","50 / 1,000",null,"Large Use - 3TS","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power - APPROVED ON AN INTERIM BASIS"]
[null,4,"GSGT50","General Service 50 to 4,999 kW","Customer","kW",null,null,221,316941804,797792,null,220.21,null,2.2578999999999998,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban","250 / 2,250",null,"General Service Less Than 50 kW – Urban energy-billed [UG]","2,000 / 20,000",null,"General Service 50 to 1,000 kW - Non Interval Meters","50 / 1,000",null,"Large Use - Ford Annex","5,000 / 100,000",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 50 - 1,000 kW"]
[null,5,"LU","Large Use","Customer","kW",null,null,2,65544852,128687,null,10692.01,null,0.99219999999999997,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban Seasonal","250 / 2,250",null,"Westport Sewage Treatment Plant","2,000 / 20,000",null,"General Service 50 to 1,499 kW","50 / 1,500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service 50 to 1,499 kW"]
[null,6,"USL","Unmetered Scattered Load","Connection","kWh",null,null,156,629732,null,null,12.6,1.2500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Suburban Year Round","250 / 2,250",null,"Small Commercial and USL - per meter","2,000 / 20,000",null,"General Service  50 to 2,499 kW","50 / 2,500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - General Service 1,000 - 5,000 kW"]
[null,7,"Sen","Sentinel Lighting","Connection","kW",null,null,83,234690,679,null,1.41,null,7.3990999999999998,null,null,null,null,null,null,null,null,null,null,null,"Residential - Time of Use","250 / 2,250",null,"Small Commercial and USL - per connection","2,000 / 20,000",null,"General Service 50 to 2,999 kW","50 / 3,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service 1,500 to 4,999 kW"]
[null,8,"SL","Street Lighting","Connection","kW",null,null,5915,3904130,11255,null,0.77,null,3.4864999999999999,null,null,null,null,null,null,null,null,null,null,null,"Residential - Hensall","250 / 2,250",null,"Farms – Single Phase energy-billed [F1]","2,000 / 20,000",null,"General Service 50 to 2,999 kW - Time of Use","50 / 3,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby - Large Use"]
[null,9,"NA","Rate Class 9","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – High Density [R1]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW","50 / 5,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Power General Service Large Use"]
[null,10,"NA","Rate Class 10","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – Normal Density [R2]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW - Time of Use","50 / 5,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standby Distribution Service"]
[null,11,"NA","Rate Class 11","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seasonal Residential – High Density [R3]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW (CoGeneration)","50 / 5,000"]
[null,12,"NA","Rate Class 12","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seasonal Residential – Normal Density [R4]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW (formerly Time of Use)","50 / 5,000"]
[null,13,"NA","Rate Class 13","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential – Urban [UR]","250 / 2,250",null,null,null,null,"General Service 50 to 4,999 kW – Time of Use by Service Area - Blenheim","50 / 5,000"]
[null,14,"NA","Rate Class 14","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 50 to 4,999 kW – Time of Use by Service Area - Chatham","50 / 5,000"]
[null,15,"NA","Rate Class 15","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 500 to 4,999 kW","500 / 5,000"]
[null,16,"NA","Rate Class 16","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 700 to 4,999 kW","700 / 5,000"]
[null,17,"NA","Rate Class 17","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 to 2,999 kW","1,000 / 3,000"]
[null,18,"NA","Rate Class 18","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,000 to 4,999 kW","1,000 / 5,000"]
[null,19,"NA","Rate Class 19","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 1,500 to 4,999 kW","1,500 / 5,000"]
[null,20,"NA","Rate Class 20","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 2,500 to 4,999 kW","2,500 / 5,000"]
[null,21,"NA","Rate Class 21","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4,999 kW","3,000 / 5,000"]
[null,22,"NA","Rate Class 22","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service 3,000 to 4.999 kW - Time of Use","3,000 / 5,000"]
[null,23,"NA","Rate Class 23","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Commercial","50 / 5,000"]
[null,24,"NA","Rate Class 24","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Institutional","50 / 5,000"]
[null,25,"NA","Rate Class 25","NA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farms – Three Phase energy-billed [F3]","50 / 5,000"]

{"sheet":"B1.2 Removal of Rate Adders","index":3,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C5","v":"Removal of Rate Adders"}]
[]
[]
[null,null,"Last COS Re-based Year",null,null,{"$f":"'A1.1 LDC Information'!D32","v":2010}]
[]
[null,null,"Last COS OEB Application Number",null,null,{"$f":"'A1.1 LDC Information'!D34","v":"EB-2009-0263"}]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Re-based Tariff Service Charge","Re-based Tariff Distribution Volumetric Rate kWh","Re-based Tariff Distribution Volumetric Rate kW",null,"Service Charge Rate Adders","Distribution Volumetric kWh Rate Adders","Distribution Volumetric kW Rate Adders",null,"Re-based Base Service Charge","Re-based Base Distribution Volumetric Rate kWh","Re-based Base Distribution Volumetric Rate kW"]
[null,null,null,null,"A","B","C",null,"D","E","F",null,"H = A - D","I = B - E","J = C - F"]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M22","v":14.75},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N22","v":1.6299999999999999E-2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O22","v":0},null,0,0,0,null,{"$f":"E22-I22","v":14.75},{"$f":"F22-J22","v":1.6299999999999999E-2},{"$f":"G22-K22","v":0}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M23","v":11.21},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N23","v":1.2E-2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O23","v":0},null,0,0,0,null,{"$f":"E23-I23","v":11.21},{"$f":"F23-J23","v":1.2E-2},{"$f":"G23-K23","v":0}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M24","v":29.05},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N24","v":1.4500000000000001E-2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O24","v":0},null,0,0,0,null,29.05,1.4500000000000001E-2,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M25","v":220.21},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N25","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O25","v":2.2578999999999998},null,0,0,0,null,220.21,0,2.2578999999999998]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M26","v":10692.01},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N26","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O26","v":0.99219999999999997},null,0,0,0,null,10692.01,0,0.99219999999999997]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M27","v":12.6},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N27","v":1.2500000000000001E-2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O27","v":0},null,0,0,0,null,12.6,1.2500000000000001E-2,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M28","v":1.41},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N28","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O28","v":7.3990999999999998},null,0,0,0,null,1.41,0,7.3990999999999998]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M29","v":0.77},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N29","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O29","v":3.4864999999999999},null,0,0,0,null,0.77,0,3.4864999999999999]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O30","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O31","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O32","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O33","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O34","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O35","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O36","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O37","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O38","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O39","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O40","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O41","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O42","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O43","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O44","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O45","v":0},null,0,0,0,null,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!M46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!N46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!O46","v":0},null,0,0,0,null,0,0,0]

{"sheet":"B1.3 Re-Based Rev From Rates","index":4,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C6","v":"Calculated Re-Based Revenue From Rates"}]
[]
[]
[null,null,"Last COS Re-based Year",null,null,{"$f":"'A1.1 LDC Information'!D32","v":2010}]
[]
[null,null,"Last COS OEB Application Number",null,null,{"$f":"'A1.1 LDC Information'!D34","v":"EB-2009-0263"}]
[]
[]
[]
[]
[null,null,"Rate Class",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Re-based Base Service Charge","Re-based Base Distribution Volumetric Rate kWh","Re-based Base Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenue Requirement from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,null,null,"A","B","C",null,"D","E","F",null,"G = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"K = G / J","L = H / J","M = I / J","N = J / R"]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I22","v":17115},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J22","v":141132375},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"'B1.2 Removal of Rate Adders'!M22","v":14.75},{"$f":"'B1.2 Removal of Rate Adders'!N22","v":1.6299999999999999E-2},{"$f":"'B1.2 Removal of Rate Adders'!O22","v":0},null,{"$f":"IF(ISERROR(E22*I22*12),0,E22*I22*12)","v":3029355},{"$f":"IF(ISERROR(F22*J22),0,F22*J22)","v":2300457.7124999999},{"$f":"IF(ISERROR(G22*K22),0,G22*K22)","v":0},{"$f":"SUM(M22:O22)","v":5329812.7125000004},null,{"$f":"IF(ISERROR(M22/P22),\"\",M22/P22)","v":0.5683792589738208},{"$f":"IF(ISERROR(N22/P22),\"\",N22/P22)","v":0.43162074102617909},{"$f":"IF(ISERROR(O22/P22),\"\",O22/P22)","v":0},{"$f":"IF(ISERROR(P22/P$47),\"\",P22/P$47)","v":0.53293640540715148}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I23","v":413},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J23","v":4143109},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"'B1.2 Removal of Rate Adders'!M23","v":11.21},{"$f":"'B1.2 Removal of Rate Adders'!N23","v":1.2E-2},{"$f":"'B1.2 Removal of Rate Adders'!O23","v":0},null,{"$f":"IF(ISERROR(E23*I23*12),0,E23*I23*12)","v":55556.760000000009},{"$f":"IF(ISERROR(F23*J23),0,F23*J23)","v":49717.308000000005},{"$f":"IF(ISERROR(G23*K23),0,G23*K23)","v":0},{"$f":"SUM(M23:O23)","v":105274.06800000001},null,{"$f":"IF(ISERROR(M23/P23),\"\",M23/P23)","v":0.52773452242768848},{"$f":"IF(ISERROR(N23/P23),\"\",N23/P23)","v":0.47226547757231152},{"$f":"IF(ISERROR(O23/P23),\"\",O23/P23)","v":0},{"$f":"IF(ISERROR(P23/P$47),\"\",P23/P$47)","v":1.0526520613177744E-2}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I24","v":1968},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J24","v":67469308},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K24","v":0},null,{"$f":"'B1.2 Removal of Rate Adders'!M24","v":29.05},{"$f":"'B1.2 Removal of Rate Adders'!N24","v":1.4500000000000001E-2},{"$f":"'B1.2 Removal of Rate Adders'!O24","v":0},null,686044.8,978304.96600000001,0,1664349.7660000001,null,0.4121998957279272,0.58780010427207285,0,0.16642096626622763]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I25","v":221},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J25","v":316941804},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K25","v":797792},null,{"$f":"'B1.2 Removal of Rate Adders'!M25","v":220.21},{"$f":"'B1.2 Removal of Rate Adders'!N25","v":0},{"$f":"'B1.2 Removal of Rate Adders'!O25","v":2.2578999999999998},null,583996.92000000004,0,1801334.5567999999,2385331.4767999998,null,0.24482841302352285,0,0.75517158697647724,0.2385130681926047]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I26","v":2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J26","v":65544852},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K26","v":128687},null,{"$f":"'B1.2 Removal of Rate Adders'!M26","v":10692.01},{"$f":"'B1.2 Removal of Rate Adders'!N26","v":0},{"$f":"'B1.2 Removal of Rate Adders'!O26","v":0.99219999999999997},null,256608.24,0,127683.2414,384291.48139999999,null,0.66774376331517604,0,0.3322562366848239,3.84259132118435E-2]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I27","v":156},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J27","v":629732},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K27","v":0},null,{"$f":"'B1.2 Removal of Rate Adders'!M27","v":12.6},{"$f":"'B1.2 Removal of Rate Adders'!N27","v":1.2500000000000001E-2},{"$f":"'B1.2 Removal of Rate Adders'!O27","v":0},null,23587.199999999997,7871.6500000000005,0,31458.85,null,0.74977947382056231,0.25022052617943763,0,3.1456201824732999E-3]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I28","v":83},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J28","v":234690},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K28","v":679},null,{"$f":"'B1.2 Removal of Rate Adders'!M28","v":1.41},{"$f":"'B1.2 Removal of Rate Adders'!N28","v":0},{"$f":"'B1.2 Removal of Rate Adders'!O28","v":7.3990999999999998},null,1404.36,0,5023.9889000000003,6428.3489,null,0.21846356223757549,0,0.78153643776242454,6.4278077678681957E-4]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I29","v":5915},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J29","v":3904130},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K29","v":11255},null,{"$f":"'B1.2 Removal of Rate Adders'!M29","v":0.77},{"$f":"'B1.2 Removal of Rate Adders'!N29","v":0},{"$f":"'B1.2 Removal of Rate Adders'!O29","v":3.4864999999999999},null,54654.600000000006,0,39240.557500000003,93895.157500000001,null,0.58208113661239669,0,0.41791886338760337,9.3887253497349481E-3]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},null,null,null,null,null,null,null,null,null,0,0,0,0,null,"","","",0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M46)","v":4691207.88},{"$f":"SUM(N22:N46)","v":3336351.6365},{"$f":"SUM(O22:O46)","v":1973282.3446},{"$f":"SUM(P22:P46)","v":10000841.861099999},null,null,null,null,{"$f":"SUM(U22:U46)","v":1.0000000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,"O","P","Q","R"]

{"sheet":"B1.4 Re-Based Rev Req","index":5,"n_rows":82,"n_cols":11,"rows_kept":82,"cut":false,"hidden":false,"merged":[[19,4,19,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C7","v":"Detailed Re-Based Revenue From Rates"}]
[]
[]
[null,null,"Last COS Re-based Year",null,{"$f":"'A1.1 LDC Information'!D32","v":2010}]
[]
[null,null,"Last COS OEB Application Number",null,{"$f":"'A1.1 LDC Information'!D34","v":"EB-2009-0263"}]
[]
[]
[]
[]
[null,null,"Applicants Rate Base",null,"Last Rate Re-based Amount",null,null,null,"OEB Audit"]
[null,null,"Average Net Fixed Assets",null,null,null,null,null,{"$f":"'Z1.0 OEB Control Sheet'!F6","v":"No"}]
[null,null,"Gross Fixed Assets - Re-based Opening",null,73469244,"A"]
[null,null,"Add: CWIP Re-based Opening",null,3357000,"B"]
[null,null,"Re-based Capital Additions",null,null,"C"]
[null,null,"Re-based Capital Disposals",null,null,"D"]
[null,null,"Re-based Capital Retirements",null,null,"E"]
[null,null,"Deduct: CWIP Re-based Closing",null,null,"F"]
[null,null,"Gross Fixed Assets - Re-based Closing",null,{"$f":"SUM(E22:E27)","v":76826244},"G"]
[null,null,"Average Gross Fixed Assets",null,null,null,{"$f":"(E22+E28)/2","v":75147744},"H = ( A + G ) / 2"]
[]
[null,null,"Accumulated Depreciation - Re-based Opening",null,41462401,"I"]
[null,null,"Re-based Depreciation Expense",null,2787375,"J",null,null,null,null,"aaa"]
[null,null,"Re-based Disposals",null,null,"K"]
[null,null,"Re-based Retirements",null,null,"L"]
[null,null,"Accumulated Depreciation - Re-based Closing",null,{"$f":"SUM(E31:E34)","v":44249776},"M"]
[null,null,"Average Accumulated Depreciation",null,null,null,{"$f":"SUM(E31,E35)/2","v":42856088.5},"N =  ( I + M ) / 2"]
[]
[null,null,"Average Net Fixed Assets ",null,null,null,{"$f":"G29-G36","v":32291655.5},"O = H - N"]
[]
[null,null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Base",null,52239484,"P"]
[null,null,"Working Capital Allowance Rate",null,0.15,"Q"]
[null,null,"Working Capital Allowance",null,null,null,{"$f":"E41*E42","v":7835922.5999999996},"R = P * Q"]
[]
[null,null,"Rate Base",null,null,null,{"$f":"SUM(G38,G43)","v":40127578.100000001},"S =  O + R"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Deemed ShortTerm Debt %",null,0.04,"T",{"$f":"G45*E48","v":1605103.1240000001},"W = S * T"]
[null,null,"Deemed Long Term Debt %",null,0.56000000000000005,"U",{"$f":"G45*E49","v":22471443.736000001},"X = S * U"]
[null,null,"Deemed Equity %",null,{"$f":"1-E48-E49","v":0.39999999999999991},"V",{"$f":"G45*E50","v":16051031.239999996},"Y = S * V"]
[]
[null,null,"Short Term Interest",null,2.07E-2,"Z",{"$f":"G48*E52","v":33225.634666800004},"AC = W * Z"]
[null,null,"Long Term Interest",null,5.682152E-2,"AA",{"$f":"G49*E53","v":1276861.5896739988},"AD = X * AA"]
[null,null,"Return on Equity",null,9.8500000000000004E-2,"AB",{"$f":"G50*E54","v":1581026.5771399997},"AE = Y * AB"]
[null,null,"Return on Rate Base",null,null,null,{"$f":"SUM(G52:G54)","v":2891113.8014807985},"AF = AC + AD + AE"]
[]
[null,null,"Distribution Expenses"]
[null,null,"OM&A Expenses",null,3930487,"AG"]
[null,null,"Amortization",null,2568039,"AH"]
[null,null,"Ontario Capital Tax (F1.1 Z-Factor Tax Changes)",null,20188,"AI"]
[null,null,"Grossed Up PILs (F1.1 Z-Factor Tax Changes)",null,848366,"AJ"]
[null,null,"Low Voltage",null,null,"AK"]
[null,null,"Transformer Allowance",null,390940,"AL"]
[null,null,"Property Tax",null,30000,"AM"]
[null,null,null,null,null,"AN"]
[null,null,null,null,null,"AO"]
[null,null,null,null,null,null,{"$f":"SUM(E58:E66)","v":7788020},"AP = SUM ( AG : AO )"]
[]
[null,null,"Revenue Offsets"]
[null,null,"Specific Service Charges",null,-178810,"AQ"]
[null,null,"Late Payment Charges",null,-133335,"AR"]
[null,null,"Other Distribution Income",null,-204175,"AS"]
[null,null,"Other Income and Deductions",null,-161596,"AT",{"$f":"SUM(E70:E73)","v":-677916},"AU = SUM ( AQ : AT )"]
[]
[null,null,"Revenue Requirement from Distribution Rates",null,null,null,{"$f":"SUM(G73,G67,G55)","v":10001217.801480798},"AV = AF + AP + AU"]
[]
[null,null,"Rate Classes Revenue"]
[null,null,"Rate Classes Revenue - Total  (B1.1 Re-based Revenue - Gen)",null,null,null,{"$f":"'B1.3 Re-Based Rev From Rates'!P47","v":10000841.861099999},"AW"]
[]
[null,null,"Difference",null,null,null,{"$f":"G75-G78","v":375.94038079865277},"AZ = AV - AW"]
[]
[null,null,"Difference (Percentage - should be less than 1%)",null,null,null,{"$f":"IF(ISERROR(G80/G78),0,G80/G78)","v":3.7590873450457982E-5},"BA = AZ / AW"]

{"sheet":"C1.1 Ld Act-Mst Rcent Yr","index":6,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C9","v":"Load Actual - Most Recent Year"}]
[]
[null,null,{"$f":"MostRecentYear('A1.1 LDC Information'!D32)","v":"Please enter 2009 Audited RRR on this page"}]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric","OEB Audit",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Base Service Charge","Base Distribution Volumetric Rate kWh","Base Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue by Rate Class"]
[null,null,null,null,null,null,null,"A","B","C",null,"D","E","F",null,"G = A * D * 12","H = B * E","I = C * F","J = G + H + I"]
[null,1,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F22","v":"kWh"},null,null,17243,{"$f":"137105741+4713","v":137110454},0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I22","v":14.75},{"$f":"'B1.3 Re-Based Rev From Rates'!J22","v":1.6299999999999999E-2},{"$f":"'B1.3 Re-Based Rev From Rates'!K22","v":0},null,{"$f":"H22*L22*12","v":3052011},{"$f":"I22*M22","v":2234900.4001999996},{"$f":"J22*N22","v":0},{"$f":"SUM(P22:R22)","v":5286911.4002}]
[null,2,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F23","v":"kWh"},null,null,410,3814545,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I23","v":11.21},{"$f":"'B1.3 Re-Based Rev From Rates'!J23","v":1.2E-2},{"$f":"'B1.3 Re-Based Rev From Rates'!K23","v":0},null,{"$f":"H23*L23*12","v":55153.200000000004},{"$f":"I23*M23","v":45774.54},0,{"$f":"SUM(P23:R23)","v":100927.74}]
[null,3,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F24","v":"kWh"},null,null,2000,63567429,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I24","v":29.05},{"$f":"'B1.3 Re-Based Rev From Rates'!J24","v":1.4500000000000001E-2},{"$f":"'B1.3 Re-Based Rev From Rates'!K24","v":0},null,697200,921727.72050000005,0,1618927.7205000001]
[null,4,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F25","v":"kW"},null,null,231,342397426,893506,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I25","v":220.21},{"$f":"'B1.3 Re-Based Rev From Rates'!J25","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K25","v":2.2578999999999998},null,610422.12,0,2017447.1973999997,2627869.3173999996]
[null,5,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E26","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F26","v":"kW"},null,null,1,30589560,59443,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I26","v":10692.01},{"$f":"'B1.3 Re-Based Rev From Rates'!J26","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K26","v":0.99219999999999997},null,128304.12,0,58979.344599999997,187283.46460000001]
[null,6,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F27","v":"kWh"},null,null,233,666441,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I27","v":12.6},{"$f":"'B1.3 Re-Based Rev From Rates'!J27","v":1.2500000000000001E-2},{"$f":"'B1.3 Re-Based Rev From Rates'!K27","v":0},null,35229.599999999999,8330.5125000000007,0,43560.112500000003]
[null,7,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F28","v":"kW"},null,null,64,200336,556,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I28","v":1.41},{"$f":"'B1.3 Re-Based Rev From Rates'!J28","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K28","v":7.3990999999999998},null,1082.8799999999999,0,4113.8995999999997,5196.7795999999998,null,"aaa"]
[null,8,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E29","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F29","v":"kW"},null,null,6240,4206123,11209,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I29","v":0.77},{"$f":"'B1.3 Re-Based Rev From Rates'!J29","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K29","v":3.4864999999999999},null,57657.600000000006,0,39080.178500000002,96737.778500000015]
[null,9,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F30","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I30","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J30","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K30","v":0},null,0,0,0,0]
[null,10,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F31","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I31","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J31","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K31","v":0},null,0,0,0,0]
[null,11,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F32","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I32","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J32","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K32","v":0},null,0,0,0,0]
[null,12,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F33","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I33","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J33","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K33","v":0},null,0,0,0,0]
[null,13,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F34","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I34","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J34","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K34","v":0},null,0,0,0,0]
[null,14,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F35","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I35","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J35","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K35","v":0},null,0,0,0,0]
[null,15,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F36","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I36","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J36","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K36","v":0},null,0,0,0,0]
[null,16,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F37","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I37","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J37","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K37","v":0},null,0,0,0,0]
[null,17,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F38","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I38","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J38","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K38","v":0},null,0,0,0,0]
[null,18,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F39","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I39","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J39","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K39","v":0},null,0,0,0,0]
[null,19,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F40","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I40","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J40","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K40","v":0},null,0,0,0,0]
[null,20,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F41","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I41","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J41","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K41","v":0},null,0,0,0,0]
[null,21,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F42","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I42","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J42","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K42","v":0},null,0,0,0,0]
[null,22,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F43","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I43","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J43","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K43","v":0},null,0,0,0,0]
[null,23,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F44","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I44","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J44","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K44","v":0},null,0,0,0,0]
[null,24,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F45","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I45","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J45","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K45","v":0},null,0,0,0,0]
[null,25,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F46","v":"NA"},null,null,0,0,0,null,{"$f":"'B1.3 Re-Based Rev From Rates'!I46","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!J46","v":0},{"$f":"'B1.3 Re-Based Rev From Rates'!K46","v":0},null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P22:P46)","v":4637060.5199999996},{"$f":"SUM(Q22:Q46)","v":3210733.1732000001},{"$f":"SUM(R22:R46)","v":2119620.6200999995},{"$f":"SUM(S22:S46)","v":9967414.3133000005}]

{"sheet":"F1.2 CalcTaxChg RRider OptA FV","index":7,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":true,"merged":[[49,19,49,21]]}
[]
[null,null,{"$f":"'A1.1 LDC Information'!C2","v":0}]
[null,null,{"$f":"'A1.1 LDC Information'!C3","v":0}]
[null,null,{"$f":"'A1.1 LDC Information'!C4","v":0}]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue by Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Service Charge Rate Rider","Distribution Volumetric Rate kWh Rate Rider","Distribution Volumetric Rate kW Rate Rider"]
[null,null,null,null,null,null,"A","B","C",null,"D = $N * A","E = $N * B","F = $N * C","G = D + E + F",null,"H","I ","J ",null,"K = D / H / 12","L = E / I","M = F / J"]
[null,1,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F22","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,{"$f":"IF(ISERROR($N$47*G22),\"\",$N$47*G22)","v":""},{"$f":"IF(ISERROR($N$47*H22),\"\",$N$47*H22)","v":""},{"$f":"IF(ISERROR($N$47*I22),\"\",$N$47*I22)","v":""},{"$f":"SUM(K22:M22)","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I22","v":17115},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J22","v":141132375},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF(ISERROR(K22/P22/12),\"\",ROUND(K22/P22/12,6))","v":""},{"$f":"IF(ISERROR(L22/Q22),\"\",ROUND(L22/Q22,6))","v":""},{"$f":"IF(ISERROR(M22/R22),\"\",ROUND(M22/R22,6))","v":""}]
[null,2,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F23","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I23","v":413},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J23","v":4143109},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF(ISERROR(K23/P23/12),\"\",ROUND(K23/P23/12,6))","v":""},{"$f":"IF(ISERROR(L23/Q23),\"\",ROUND(L23/Q23,6))","v":""},{"$f":"IF(ISERROR(M23/R23),\"\",ROUND(M23/R23,6))","v":""}]
[null,3,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F24","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I24","v":1968},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J24","v":67469308},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K24","v":0},null,"","",""]
[null,4,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I25","v":221},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J25","v":316941804},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K25","v":797792},null,"","",""]
[null,5,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E26","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F26","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I26","v":2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J26","v":65544852},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K26","v":128687},null,"","",""]
[null,6,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F27","v":"kWh"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I27","v":156},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J27","v":629732},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K27","v":0},null,"","",""]
[null,7,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I28","v":83},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J28","v":234690},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K28","v":679},null,"","",""]
[null,8,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E29","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F29","v":"kW"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I29","v":5915},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J29","v":3904130},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K29","v":11255},null,"","",""]
[null,9,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F30","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K30","v":0},null,"","",""]
[null,10,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F31","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K31","v":0},null,"","",""]
[null,11,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F32","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K32","v":0},null,"","",""]
[null,12,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F33","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K33","v":0},null,"","",""]
[null,13,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F34","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K34","v":0},null,"","",""]
[null,14,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F35","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K35","v":0},null,"","",""]
[null,15,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F36","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K36","v":0},null,"","",""]
[null,16,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F37","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K37","v":0},null,"","",""]
[null,17,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F38","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K38","v":0},null,"","",""]
[null,18,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F39","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K39","v":0},null,"","",""]
[null,19,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F40","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K40","v":0},null,"","",""]
[null,20,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F41","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K41","v":0},null,"","",""]
[null,21,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F42","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K42","v":0},null,"","",""]
[null,22,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F43","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K43","v":0},null,"","",""]
[null,23,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F44","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K44","v":0},null,"","",""]
[null,24,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F45","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K45","v":0},null,"","",""]
[null,25,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F46","v":"NA"},null,{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},{"$f":"IF(ISERROR(#REF!*(#REF!/#REF!)),0,#REF!*(#REF!/#REF!))","v":0},null,"","","",0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K46","v":0},null,"","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:K46)","v":0},{"$f":"SUM(L22:L46)","v":0},{"$f":"SUM(M22:M46)","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:N46)-N47","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the above value onto Sheet \n\"J2.1 Tax Change Rate Rider\" \nof the 2010 OEB IRM3 Rate Generator."]

{"sheet":"D1.1 Current Revenue from Rates","index":8,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,6,48,8],[7,2,7,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"This sheet is used to determine the applicants most current allocation of revenues (after the most recent revenue to cost ratio adjustment, if applicable)  to be used to calculate the incremental capital rate riders.  \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C10","v":"Current Revenue from Rates"}]
[]
[null,null,"Rate Class",{"$f":"'B1.1 Re-Based Bill Det & Rates'!E20","v":"Fixed Metric"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F20","v":"Vol Metric"},null,"Current Base Service Charge","Current Base Distribution Volumetric Rate kWh","Current Base Distribution Volumetric Rate kW",null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I20","v":"Re-based Billed Customers or Connections"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J20","v":"Re-based Billed kWh"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K20","v":"Re-based Billed kW"},null,"Current Base Service Charge Revenue","Current Base Distribution Volumetric Rate kWh Revenue","Current Base Distribution Volumetric Rate kW Revenue","Total Current Base Revenue",null,"Service Charge % Total Revenue","Distribution Volumetric Rate % Total Revenue ","Distribution Volumetric Rate % Total Revenue ","Total % Revenue"]
[null,null,null,null,null,null,"A","B","C",null,"D","E","F",null,"G = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"L = G / $K","M = H / $K","N = I / $K","O = J / $K"]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F22","v":"kWh"},null,14.92,1.66E-2,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I22","v":17115},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J22","v":141132375},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"G22*K22*12","v":3064269.5999999996},{"$f":"H22*L22","v":2342797.4249999998},{"$f":"I22*M22","v":0},{"$f":"SUM(O22:Q22)","v":5407067.0249999994},null,{"$f":"IF(ISERROR(O22/$R$48),0,O22/$R$48)","v":0.3010281127025623},{"$f":"IF(ISERROR(P22/$R$48),0,P22/$R$48)","v":0.23015203599976083},{"$f":"IF(ISERROR(Q22/$R$48),0,Q22/$R$48)","v":0},{"$f":"SUM(T22:V22)","v":0.53118014870232311}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F23","v":"kWh"},null,13.82,1.49E-2,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I23","v":413},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J23","v":4143109},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"G23*K23*12","v":68491.92},{"$f":"H23*L23","v":61732.324099999998},0,{"$f":"SUM(O23:Q23)","v":130224.2441},null,{"$f":"IF(ISERROR(O23/$R$48),0,O23/$R$48)","v":6.7285180824085723E-3},{"$f":"IF(ISERROR(P23/$R$48),0,P23/$R$48)","v":6.0644680274104809E-3},{"$f":"IF(ISERROR(Q23/$R$48),0,Q23/$R$48)","v":0},{"$f":"SUM(T23:V23)","v":1.2792986109819052E-2}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F24","v":"kWh"},null,28.88,1.46E-2,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I24","v":1968},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J24","v":67469308},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K24","v":0},null,682030.07999999996,985051.89679999999,0,1667081.9767999998,null,6.7001359080407802E-2,9.6769655453222261E-2,0,0.16377101453363008]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F25","v":"kW"},null,223.24,null,2.2888999999999999,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I25","v":221},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J25","v":316941804},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K25","v":797792},null,592032.48,0,1826066.1088,2418098.5888,null,5.8160163228789488E-2,0,0.17938931822519005,0.23754948145397953]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E26","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F26","v":"kW"},null,10676.92,null,0.99080000000000001,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I26","v":2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J26","v":65544852},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K26","v":128687},null,256246.08000000002,0,127503.0796,383749.15960000001,null,2.5173135500162848E-2,0,1.2525664000240898E-2,3.7698799500403744E-2]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F27","v":"kWh"},null,12.79,1.26E-2,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I27","v":156},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J27","v":629732},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K27","v":0},null,23942.879999999997,7934.6232,0,31877.503199999999,null,2.3521037375640592E-3,7.794825386454135E-4,0,3.1315862762094728E-3]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F28","v":"kW"},null,2.02,null,10.614000000000001,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I28","v":83},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J28","v":234690},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K28","v":679},null,2011.92,0,7206.9060000000009,9218.8260000000009,null,1.9764725679115807E-4,0,7.0799296237014295E-4,9.0564021916130096E-4]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E29","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F29","v":"kW"},null,1.08,null,4.9196999999999997,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I29","v":5915},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J29","v":3904130},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K29","v":11255},null,76658.400000000009,0,55371.2235,132029.62350000002,null,{"$f":"IF(ISERROR(O29/$R$48),0,O29/$R$48)","v":7.5307777993157349E-3},{"$f":"IF(ISERROR(P29/$R$48),0,P29/$R$48)","v":0},{"$f":"IF(ISERROR(Q29/$R$48),0,Q29/$R$48)","v":5.4395654051578122E-3},{"$f":"SUM(T29:V29)","v":1.2970343204473548E-2}]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F30","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K30","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F31","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K31","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F32","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K32","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F33","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K33","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F34","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K34","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F35","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K35","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F36","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K36","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F37","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K37","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F38","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K38","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F39","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K39","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F40","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K40","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F41","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K41","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F42","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K42","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F43","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K43","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F44","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K44","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F45","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K45","v":0},null,0,0,0,0,null,0,0,0,0]
[null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F46","v":"NA"},null,null,null,null,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K46","v":0},null,0,0,0,0,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O22:O46)","v":4765683.3600000003},{"$f":"SUM(P22:P46)","v":3397516.2690999997},{"$f":"SUM(Q22:Q46)","v":2016147.3179000001},10179346.947000001,null,{"$f":"SUM(T22:T47)","v":0.46817181738800195},{"$f":"SUM(U22:U47)","v":0.33376564201903897},{"$f":"SUM(V22:V47)","v":0.19806254059295891},{"$f":"SUM(W22:W47)","v":0.99999999999999978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K"]

{"sheet":"E1.1 Threshold Parameters","index":9,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C11","v":"Threshold Parameters"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Price Cap Index"]
[]
[null,null,"Price Escalator (GDP-IPI)",null,1.6E-2]
[]
[null,null,"Less Productivity Factor",null,-7.1999999999999998E-3]
[]
[null,null,"Less Stretch Factor",null,{"$f":"-'A1.1 LDC Information'!D30","v":-2E-3}]
[]
[null,null,"Price Cap Index",null,null,null,{"$f":"SUM(E22,E24,E26)","v":6.8000000000000005E-3}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zzz"]
[null,null,"Growth"]
[]
[null,null,{"$f":"\"ICM Billing Determinants for Growth - Numerator : \" &'A1.1 LDC Information'!D36","v":"ICM Billing Determinants for Growth - Numerator : 2010 Re-based Forecast"},null,null,null,{"$f":"'C1.1 Ld Act-Mst Rcent Yr'!S47","v":9967414.3133000005},"A"]
[]
[null,null,{"$f":"\"ICM Billing Determinants for Growth - Denominator : \" &'A1.1 LDC Information'!D38","v":"ICM Billing Determinants for Growth - Denominator : 2011 Actual"},null,null,null,{"$f":"'B1.3 Re-Based Rev From Rates'!P47","v":10000841.861099999},"B"]
[]
[]
[null,null,"Growth",null,null,null,{"$f":"IF(ISERROR(G35/G37),0,(G35/G37)-1)","v":-3.3424733901673553E-3},"C = A / B"]

{"sheet":"E2.1 Threshold Test","index":10,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C12","v":"Threshold Test"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Year",null,{"$f":"'A1.1 LDC Information'!D32","v":2010}]
[]
[]
[null,null,"Price Cap Index",null,{"$f":"'E1.1 Threshold Parameters'!G28","v":6.8000000000000005E-3},"A"]
[null,null,"Growth",null,{"$f":"'E1.1 Threshold Parameters'!G40","v":-3.3424733901673553E-3},"B"]
[null,null,"Dead Band",null,0.2,"C"]
[null,null,"Average Net Fixed Assets"]
[null,null,"Gross Fixed Assets Opening",null,{"$f":"'B1.4 Re-Based Rev Req'!E22","v":73469244}]
[null,null,"Add: CWIP Opening",null,{"$f":"'B1.4 Re-Based Rev Req'!E23","v":3357000}]
[null,null,"Capital Additions",null,{"$f":"'B1.4 Re-Based Rev Req'!E24","v":0}]
[null,null,"Capital Disposals",null,{"$f":"'B1.4 Re-Based Rev Req'!E25","v":0}]
[null,null,"Capital Retirements",null,{"$f":"'B1.4 Re-Based Rev Req'!E26","v":0}]
[null,null,"Deduct: CWIP Closing",null,{"$f":"'B1.4 Re-Based Rev Req'!E27","v":0}]
[null,null,"Gross Fixed Assets - Closing",null,{"$f":"SUM(E27:E32)","v":76826244}]
[]
[null,null,"Average Gross Fixed Assets",null,{"$f":"(E27+E33)/2","v":75147744}]
[]
[null,null,"Accumulated Depreciation - Opening",null,{"$f":"'B1.4 Re-Based Rev Req'!E31","v":41462401}]
[null,null,"Depreciation Expense",null,{"$f":"'B1.4 Re-Based Rev Req'!E32","v":2787375},"D"]
[null,null,"Disposals",null,{"$f":"'B1.4 Re-Based Rev Req'!E33","v":0}]
[null,null,"Retirements",null,{"$f":"'B1.4 Re-Based Rev Req'!E34","v":0}]
[null,null,"Accumulated Depreciation - Closing",null,{"$f":"SUM(E37:E40)","v":44249776}]
[]
[null,null,"Average Accumulated Depreciation",null,{"$f":"(E37+E41)/2","v":42856088.5}]
[]
[null,null,"Average Net Fixed Assets ",null,{"$f":"E35-E43","v":32291655.5},"E"]
[]
[]
[null,null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Base",null,{"$f":"'B1.4 Re-Based Rev Req'!E41","v":52239484}]
[null,null,"Working Capital Allowance Rate",null,{"$f":"'B1.4 Re-Based Rev Req'!E42","v":0.15}]
[null,null,"Working Capital Allowance",null,{"$f":"E49*E50","v":7835922.5999999996},"F"]
[]
[null,null,"Rate Base",null,{"$f":"E45+E51","v":40127578.100000001},"G = E + F"]
[]
[null,null,"Depreciation","D",{"$f":"E38","v":2787375},"H"]
[]
[null,null,"Threshold Test",null,{"$f":"IF(ISERROR(1+(RB/d)*(g+PCI*(1+g))),0,1+(RB/d)*(g+PCI*(1+g))+db)","v":1.2494479991415621},"I = 1 + ( G / H) * ( B + A * ( 1 + B)) + C"]
[]
[]
[null,null,"Threshold CAPEX",null,{"$f":"d*E57","v":3482680.1166072115},"J = H *I"]

{"sheet":"E3.1 Summary of I C Projects","index":11,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C13 & \" (ICPs)\"","v":"Summary of Incremental Capital Projects (ICPs)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Number of ICPs"]
[null,null,1]
[]
[null,null,"Project ID #","Incremental Capital Non-Discretionary Project Description",null,"Incremental Capital CAPEX",null,"Amortization Expense",null,"CCA"]
[null,null,"ICP 1","Construction of 62 MVA Transformation Station",null,{"$f":"(15863113+3489000-3642654)/2","v":7854729.5},null,{"$f":"376208/2","v":188104},null,660552]
[null,null,"ICP 2"]
[null,null,"ICP 3"]
[null,null,"ICP 4"]
[null,null,"ICP 5"]
[null,null,"ICP 6"]
[null,null,"ICP 7"]
[null,null,"ICP 8"]
[null,null,"ICP 9"]
[null,null,"ICP 10"]
[null,null,"ICP 11"]
[null,null,"ICP 12"]
[null,null,"ICP 13"]
[null,null,"ICP 14"]
[null,null,"ICP 15"]
[null,null,"ICP 16"]
[null,null,"ICP 17"]
[null,null,"ICP 18"]
[null,null,"ICP 19"]
[null,null,"ICP 20"]
[null,null,"ICP 21"]
[null,null,"ICP 22"]
[null,null,"ICP 23"]
[null,null,"ICP 24"]
[null,null,"ICP 25"]
[]
[null,null,null,null,null,{"$f":"SUM(F24:F48)","v":7854729.5},null,{"$f":"SUM(H24:H48)","v":188104},null,{"$f":"SUM(J24:J48)","v":660552}]

{"sheet":"E4.1 IncrementalCapitalAdjust","index":12,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C14","v":"Incremental Capital Adjustment"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Current Revenue Requirement"]
[]
[null,null,"Current Revenue Requirement - Total",null,null,{"$f":"'B1.4 Re-Based Rev Req'!G75","v":10001217.801480798},"A"]
[]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'E3.1 Summary of I C Projects'!F50","v":7854729.5},"B"]
[null,null,"Depreciation Expense",null,null,{"$f":"'E3.1 Summary of I C Projects'!H50","v":188104},"C"]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28","v":7666625.5},"D = B - C"]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'B1.4 Re-Based Rev Req'!E48","v":0.04},"E",{"$f":"F29*D31","v":306665.02},"G = D * E"]
[null,null,"Deemed Long Term Debt %",{"$f":"'B1.4 Re-Based Rev Req'!E49","v":0.56000000000000005},"F",{"$f":"F29*D32","v":4293310.28},"H = D * F"]
[]
[null,null,"Short Term Interest",{"$f":"'B1.4 Re-Based Rev Req'!E52","v":2.07E-2},"I",{"$f":"F31*D34","v":6347.9659140000003},"K = G * I"]
[null,null,"Long Term Interest",{"$f":"'B1.4 Re-Based Rev Req'!E53","v":5.682152E-2},"J",{"$f":"F32*D35","v":243952.41594122563},"L = H * J"]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":250300.38185522563},"M = K + L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"aaa"]
[null,null,"Deemed Equity %",{"$f":"'B1.4 Re-Based Rev Req'!E50","v":0.39999999999999991},"N",{"$f":"F29*D40","v":3066650.1999999993},"P = D * N"]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'B1.4 Re-Based Rev Req'!E54","v":9.8500000000000004E-2},"O",{"$f":"F40*D42","v":302065.04469999991},"Q = P * O"]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":552365.42655522551},"R = M + Q"]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":188104},"S"]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":302065.04469999991},"T "]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":188104},"U"]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'E3.1 Summary of I C Projects'!J50","v":660552},"V"]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-170382.95530000009},"W = T + U - V"]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",0.26500000000000001,"X"]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-45151.483154500027},"Y = W * X"]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-61430.589325850378},"Z = Y / ( 1 - X ) "]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":7854729.5},"AA"]
[]
[null,null,"Less : Available Capital Exemption (if any)",null,null,0,"AB"]
[]
[null,null,"Incremental Capital CAPEX subject to OCT",null,null,{"$f":"F71-F73","v":7854729.5},"AC = AA - AB"]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",0,"AD"]
[]
[null,null,"Incremental Ontario Capital Tax",null,null,{"$f":"F75*D77","v":0},"AE = AC * AD"]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total",null,"Q",{"$f":"F44","v":552365.42655522551},"AF"]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":188104},"AG"]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-61430.589325850378},"AH"]
[null,null,"Incremental Ontario Capital Tax",null,"AE",{"$f":"F79","v":0},"AI"]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F83:F86)","v":679038.83722937515},"AJ = AF + AG + AH + AI"]

{"sheet":"F1.1 Incr Cap RRider Opt A FV","index":13,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,19,48,21]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C15","v":"Calculation of Incremental Capital Rate Rider - Option A Fixed and Variable"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue by Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Service Charge Rate Rider","Distribution Volumetric Rate kWh Rate Rider","Distribution Volumetric Rate kW Rate Rider"]
[null,null,null,null,null,null,"A","B","C",null,"D = $N * A","E = $N * B","F = $N * C","G = D + E + F",null,"H","I ","J ",null,"K = D / H / 12","L = E / I","M = F / J"]
[null,1,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F22","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!T22","v":0.3010281127025623},{"$f":"'D1.1 Current Revenue from Rates'!U22","v":0.23015203599976083},{"$f":"'D1.1 Current Revenue from Rates'!V22","v":0},null,{"$f":"IF(ISERROR($N$47*G22),\"\",$N$47*G22)","v":204409.7796229012},{"$f":"IF(ISERROR($N$47*H22),\"\",$N$47*H22)","v":156282.1709112509},{"$f":"IF(ISERROR($N$47*I22),\"\",$N$47*I22)","v":0},{"$f":"SUM(K22:M22)","v":360691.9505341521},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I22","v":17115},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J22","v":141132375},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF(ISERROR(K22/P22/12),\"\",ROUND(K22/P22/12,6))","v":0.99527600000000005},{"$f":"IF(ISERROR(L22/Q22),\"\",ROUND(L22/Q22,6))","v":1.1069999999999999E-3},{"$f":"IF(ISERROR(M22/R22),\"\",ROUND(M22/R22,6))","v":""}]
[null,2,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F23","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!T23","v":6.7285180824085723E-3},{"$f":"'D1.1 Current Revenue from Rates'!U23","v":6.0644680274104809E-3},{"$f":"'D1.1 Current Revenue from Rates'!V23","v":0},null,4568.9250949555417,4118.0093177475355,0,8686.9344127030781,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I23","v":413},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J23","v":4143109},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF(ISERROR(K23/P23/12),\"\",ROUND(K23/P23/12,6))","v":0.921898},{"$f":"IF(ISERROR(L23/Q23),\"\",ROUND(L23/Q23,6))","v":9.9400000000000009E-4},{"$f":"IF(ISERROR(M23/R23),\"\",ROUND(M23/R23,6))","v":""}]
[null,3,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F24","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!T24","v":6.7001359080407802E-2},{"$f":"'D1.1 Current Revenue from Rates'!U24","v":9.6769655453222261E-2},{"$f":"'D1.1 Current Revenue from Rates'!V24","v":0},null,45496.52496274795,65710.354318043304,0,111206.87928079125,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I24","v":1968},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J24","v":67469308},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K24","v":0},null,1.9265129999999999,9.7400000000000004E-4,""]
[null,4,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!T25","v":5.8160163228789488E-2},{"$f":"'D1.1 Current Revenue from Rates'!U25","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V25","v":0.17938931822519005},null,39493.009611947877,0,121812.3140590034,161305.32367095127,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I25","v":221},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J25","v":316941804},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K25","v":797792},null,14.891783,0,0.15268699999999999]
[null,5,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E26","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F26","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!T26","v":2.5173135500162848E-2},{"$f":"'D1.1 Current Revenue from Rates'!U26","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V26","v":1.2525664000240898E-2},null,17093.536659448084,0,8505.4123182494241,25598.94897769751,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I26","v":2},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J26","v":65544852},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K26","v":128687},null,712.23069399999997,0,6.6094E-2]
[null,6,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F27","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!T27","v":2.3521037375640592E-3},{"$f":"'D1.1 Current Revenue from Rates'!U27","v":7.794825386454135E-4},{"$f":"'D1.1 Current Revenue from Rates'!V27","v":0},null,1597.1697869983661,529.29891668238304,0,2126.4687036807491,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I27","v":156},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J27","v":629732},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K27","v":0},null,0.85318899999999998,8.4099999999999995E-4,""]
[null,7,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!T28","v":1.9764725679115807E-4},{"$f":"'D1.1 Current Revenue from Rates'!U28","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V28","v":7.0799296237014295E-4},null,134.2101634330437,0,480.75471793440261,614.96488136744631,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I28","v":83},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J28","v":234690},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K28","v":679},null,0.13474900000000001,0,0.70803300000000002]
[null,8,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E29","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F29","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!T29","v":7.5307777993157349E-3},{"$f":"'D1.1 Current Revenue from Rates'!U29","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V29","v":5.4395654051578122E-3},null,5113.6906002801497,0,3693.6761677514955,8807.3667680316448,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I29","v":5915},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J29","v":3904130},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K29","v":11255},null,7.2043999999999997E-2,0,0.328181]
[null,9,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F30","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T30","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U30","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V30","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J30","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K30","v":0},null,"","",""]
[null,10,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F31","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T31","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U31","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V31","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J31","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K31","v":0},null,"","",""]
[null,11,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F32","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T32","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U32","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V32","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J32","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K32","v":0},null,"","",""]
[null,12,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F33","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T33","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U33","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V33","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J33","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K33","v":0},null,"","",""]
[null,13,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F34","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T34","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U34","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V34","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J34","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K34","v":0},null,"","",""]
[null,14,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F35","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T35","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U35","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V35","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J35","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K35","v":0},null,"","",""]
[null,15,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F36","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T36","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U36","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V36","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J36","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K36","v":0},null,"","",""]
[null,16,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F37","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T37","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U37","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V37","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J37","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K37","v":0},null,"","",""]
[null,17,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F38","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T38","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U38","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V38","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J38","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K38","v":0},null,"","",""]
[null,18,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F39","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T39","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U39","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V39","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J39","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K39","v":0},null,"","",""]
[null,19,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F40","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T40","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U40","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V40","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J40","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K40","v":0},null,"","",""]
[null,20,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F41","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T41","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U41","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V41","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J41","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K41","v":0},null,"","",""]
[null,21,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F42","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T42","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U42","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V42","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J42","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K42","v":0},null,"","",""]
[null,22,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F43","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T43","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U43","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V43","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J43","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K43","v":0},null,"","",""]
[null,23,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F44","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T44","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U44","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V44","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J44","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K44","v":0},null,"","",""]
[null,24,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F45","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T45","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U45","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V45","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J45","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K45","v":0},null,"","",""]
[null,25,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F46","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!T46","v":0},{"$f":"'D1.1 Current Revenue from Rates'!U46","v":0},{"$f":"'D1.1 Current Revenue from Rates'!V46","v":0},null,0,0,0,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!I46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!J46","v":0},{"$f":"'B1.1 Re-Based Bill Det & Rates'!K46","v":0},null,"","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K22:K46)","v":317906.84650271217},{"$f":"SUM(L22:L46)","v":226639.83346372412},{"$f":"SUM(M22:M46)","v":134492.15726293871},{"$f":"'E4.1 IncrementalCapitalAdjust'!F88","v":679038.83722937515}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N22:N46)-N47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the above rate riders onto \"Sheet \n11. Proposed Rates\" in the 2013 OEB IRM3 Rate Generator as a \"Rate Rider for Incremental Capital\""]

{"sheet":"F1.2 Incr Cap RRider Opt B Var","index":14,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,16,49,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'Z1.0 OEB Control Sheet'!C16","v":"Calculation of Incremental Capital Rate Rider - Option B Variable"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Control","Rate Class","Fixed Metric","Vol Metric",null,"Total Revenue $ by Rate Class",null,"Total Revenue % by Rate Class",null,"Total Incremental Capital $ by Rate Class",null,"Billed kWh",null,"Billed kW",null,"Distribution Volumetric Rate kWh Rate Rider",null,"Distribution Volumetric Rate kW Rate Rider"]
[null,null,null,null,null,null,"A",null,"B = A / $H",null,"C = $I * B",null,"D",null,"E",null,"F = C / D",null,"G = C / E"]
[null,1,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D22","v":"Residential"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E22","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F22","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!R22","v":5407067.0249999994},null,{"$f":"IF(ISERROR(G22/$G$47),0,G22/$G$47)","v":0.53118014870232311},null,{"$f":"IF(ISERROR(I22*$K$47),0,I22*$K$47)","v":360691.95053415204},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J22","v":141132375},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K22","v":0},null,{"$f":"IF($E22=\"kWh\",IF(ISERROR($K22/$M22),\"\",ROUND($K22/$M22,4)),\"\")","v":2.5999999999999999E-3},null,{"$f":"IF($E22=\"kW\",IF(ISERROR($K22/$O22),\"\",ROUND($K22/$O22,4)),\"\")","v":""}]
[null,2,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D23","v":"Residential - Hensall"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E23","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F23","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!R23","v":130224.2441},null,1.2792986109819054E-2,null,8686.9344127030781,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J23","v":4143109},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K23","v":0},null,{"$f":"IF($E23=\"kWh\",IF(ISERROR($K23/$M23),\"\",ROUND($K23/$M23,4)),\"\")","v":2.0999999999999999E-3},null,{"$f":"IF($E23=\"kW\",IF(ISERROR($K23/$O23),\"\",ROUND($K23/$O23,4)),\"\")","v":""}]
[null,3,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D24","v":"General Service Less Than 50 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E24","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F24","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!R24","v":1667081.9767999998},null,0.16377101453363005,null,111206.87928079124,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J24","v":67469308},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K24","v":0},null,1.6000000000000001E-3,null,""]
[null,4,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D25","v":"General Service 50 to 4,999 kW"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E25","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F25","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!R25","v":2418098.5888},null,0.23754948145397956,null,161305.3236709513,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J25","v":316941804},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K25","v":797792},null,"",null,0.20219999999999999]
[null,5,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D26","v":"Large Use"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E26","v":"Customer"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F26","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!R26","v":383749.15960000001},null,3.7698799500403744E-2,null,25598.948977697506,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J26","v":65544852},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K26","v":128687},null,"",null,0.19889999999999999]
[null,6,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D27","v":"Unmetered Scattered Load"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E27","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F27","v":"kWh"},null,{"$f":"'D1.1 Current Revenue from Rates'!R27","v":31877.503199999999},null,3.1315862762094728E-3,null,2126.4687036807491,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J27","v":629732},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K27","v":0},null,3.3999999999999998E-3,null,""]
[null,7,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D28","v":"Sentinel Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E28","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F28","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!R28","v":9218.8260000000009},null,9.0564021916130096E-4,null,614.96488136744631,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J28","v":234690},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K28","v":679},null,"",null,0.90569999999999995]
[null,8,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D29","v":"Street Lighting"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E29","v":"Connection"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F29","v":"kW"},null,{"$f":"'D1.1 Current Revenue from Rates'!R29","v":132029.62350000002},null,1.2970343204473548E-2,null,8807.3667680316448,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J29","v":3904130},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K29","v":11255},null,"",null,0.78249999999999997]
[null,9,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D30","v":"Rate Class 9"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E30","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F30","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R30","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J30","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K30","v":0},null,"",null,""]
[null,10,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D31","v":"Rate Class 10"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E31","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F31","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R31","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J31","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K31","v":0},null,"",null,"","aaa"]
[null,11,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D32","v":"Rate Class 11"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E32","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F32","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R32","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J32","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K32","v":0},null,"",null,""]
[null,12,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D33","v":"Rate Class 12"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E33","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F33","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R33","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J33","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K33","v":0},null,"",null,""]
[null,13,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D34","v":"Rate Class 13"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E34","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F34","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R34","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J34","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K34","v":0},null,"",null,""]
[null,14,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D35","v":"Rate Class 14"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E35","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F35","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R35","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J35","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K35","v":0},null,"",null,""]
[null,15,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D36","v":"Rate Class 15"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E36","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F36","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R36","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J36","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K36","v":0},null,"",null,""]
[null,16,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D37","v":"Rate Class 16"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E37","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F37","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R37","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J37","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K37","v":0},null,"",null,""]
[null,17,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D38","v":"Rate Class 17"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E38","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F38","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R38","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J38","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K38","v":0},null,"",null,""]
[null,18,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D39","v":"Rate Class 18"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E39","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F39","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R39","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J39","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K39","v":0},null,"",null,""]
[null,19,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D40","v":"Rate Class 19"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E40","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F40","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R40","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J40","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K40","v":0},null,"",null,""]
[null,20,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D41","v":"Rate Class 20"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E41","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F41","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R41","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J41","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K41","v":0},null,"",null,""]
[null,21,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D42","v":"Rate Class 21"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E42","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F42","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R42","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J42","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K42","v":0},null,"",null,""]
[null,22,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D43","v":"Rate Class 22"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E43","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F43","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R43","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J43","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K43","v":0},null,"",null,""]
[null,23,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D44","v":"Rate Class 23"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E44","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F44","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R44","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J44","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K44","v":0},null,"",null,""]
[null,24,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D45","v":"Rate Class 24"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E45","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F45","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R45","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J45","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K45","v":0},null,"",null,""]
[null,25,{"$f":"'B1.1 Re-Based Bill Det & Rates'!D46","v":"Rate Class 25"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!E46","v":"NA"},{"$f":"'B1.1 Re-Based Bill Det & Rates'!F46","v":"NA"},null,{"$f":"'D1.1 Current Revenue from Rates'!R46","v":0},null,0,null,0,null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!J46","v":0},null,{"$f":"'B1.1 Re-Based Bill Det & Rates'!K46","v":0},null,"",null,""]
[null,null,null,null,null,null,{"$f":"SUM(G22:G46)","v":10179346.947000001},null,{"$f":"SUM(I22:I46)","v":0.99999999999999989},null,{"$f":"'E4.1 IncrementalCapitalAdjust'!F88","v":679038.83722937515}]
[null,null,null,null,null,null,"H",null,null,null,"I ",null,null,null,null,null,"Enter the above rate riders onto \"Sheet \n11. Proposed Rates\" in the 2013 OEB IRM3 Rate Generator as a \"Rate Rider for Incremental Capital\""]

{"sheet":"Z1.0 OEB Control Sheet","index":15,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Sheet Number","Assignment","Sheet Title","Core Sheet Name","Chrs","OEB Audit","Purpose of Sheet"]
["Sheet1","A1.1","LDC Information","A1.1 LDC Information",{"$f":"LEN(D2)","v":20},"No","Enter LDC Data"]
["Sheet2","A2.1","Table of Contents","A2.1 Table of Contents",22,"No","Table of Contents"]
["Sheet3","B1.1","Rate Class and Re-Based Billing Determinants & Rates","B1.1 Re-Based Bill Det & Rates",30,"No","Set Up Rate Classes and enter Re-Based Billing Determinants and Tariff Rates "]
["Sheet4","B1.2","Removal of Rate Adders","B1.2 Removal of Rate Adders",27,"No","Removal of Rate Adders"]
["Sheet5","B1.3","Calculated Re-Based Revenue From Rates","B1.3 Re-Based Rev From Rates",28,"No","Calculated Re-Based Revenue From Rates"]
["Sheet6","B1.4","Detailed Re-Based Revenue From Rates","B1.4 Re-Based Rev Req",21,"No","Detailed Re-Based Revenue From Rates"]
["Sheet7","B2.1","2010 Base Distribution Rates","B2.1 2010 Base Dist Rates",25,"No","2010 Base Distribution Rates"]
["Sheet8","C1.1","Load Actual - Most Recent Year","C1.1 Ld Act-Mst Rcent Yr",24,"No","Enter Billing Determinants for most recent actual year"]
["Sheet9","D1.1","Current Revenue from Rates","D1.1 Current Revenue from Rates",31,"No","Enter Current Rates to calculate current rate allocation"]
["Sheet10","E1.1","Threshold Parameters","E1.1 Threshold Parameters",25,"No","Shows calculation of Price Cap and Growth used for incremental capital threshold calculation"]
["Sheet11","E2.1","Threshold Test","E2.1 Threshold Test",19,"No","Input sheet to calculate Threshold and Incremental Capital"]
["Sheet12","E3.1","Summary of Incremental Capital Projects","E3.1 Summary of I C Projects",28,"No","Summary of Incremental Capital Projects"]
["Sheet13","E4.1","Incremental Capital Adjustment","E4.1 IncrementalCapitalAdjust",29,"No","Shows Calculation of Incremental Capital Revenue Requirement"]
["Sheet14","F1.1","Calculation of Incremental Capital Rate Rider - Option A Fixed and Variable","F1.1 Incr Cap RRider Opt A FV",29,"No","Option A - Calculation of Incremental Capital Rate Rider - Fixed & Variable Split"]
["Sheet15","F1.2","Calculation of Incremental Capital Rate Rider - Option B Variable","F1.2 Incr Cap RRider Opt B Var",30,"No","Option B - Calculation of Incremental Capital Rate Rider - Variable Allocation"]
["Sheet16","Z1.0","OEB Control Sheet","Z1.0 OEB Control Sheet",22,"N/A","Not Shown"]