{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Survey"],"not_rendered":{"charts":0,"images":85,"macros":1,"external_links":0,"defined_names":27,"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":"Survey","index":0,"n_rows":227,"n_cols":14,"rows_kept":227,"cut":false,"hidden":false,"merged":[[1,0,1,14],[160,10,161,11],[42,2,42,3],[39,1,40,1],[56,1,57,1],[79,2,79,3],[77,1,78,1],[16,1,16,2],[90,1,91,1],[90,2,91,14],[141,0,144,13],[227,2,232,13],[160,13,161,14],[165,13,165,14],[167,13,167,14],[168,13,168,14],[188,2,190,2],[182,2,183,2],[185,2,186,2],[207,2,208,4],[210,2,210,4],[18,1,32,13],[39,2,41,14],[45,2,50,13],[62,2,67,13],[82,2,87,13],[77,2,78,14],[59,2,59,3],[5,1,5,2],[7,1,7,2],[9,1,9,2],[11,1,11,2],[13,1,13,2],[107,1,110,14],[211,2,211,4],[193,2,194,2],[160,6,161,6],[170,13,170,14],[160,8,161,8],[114,1,119,13],[146,0,146,13],[156,0,158,0],[156,1,158,12],[35,0,37,0],[224,2,224,4],[221,2,222,4],[204,2,205,13],[212,2,212,4],[214,2,214,4],[215,2,215,4],[216,2,216,4],[218,2,219,4],[96,2,101,13],[173,2,178,13],[197,2,202,13],[107,0,109,0],[56,2,58,14],[140,0,140,13],[160,2,161,4]]}
[]
["Important: The information provided in this questionnaire will not be used to disclose the identity of individual distributors."]
[]
[]
[]
[null,"Distributor Name"]
[]
[null,"Submitted by"]
[]
[null,"Contact Telephone No."]
[]
[null,"Contact Email"]
[]
[null,"Date"]
[]
[]
[null,"Introduction"]
[]
[null,"At the APB working group meetings, OEB staff has presented and discussed a preliminary list set of activities / programs for benchmarking consideration from the results of its empirical analysis using a combination of four approaches. The OEB plans to leverage and maximize existing RRR data to support the APB initiative going forward however there will be a need for new data in limited amounts for the activities / program benchmarking.\n\nTo inform whether new data is available to support the benchmarking of these activities / programs, OEB staff would like to get your advice on the availability of the data specified in this questionnaire for potential reporting to the OEB in the future. \n\nIn order to determine whether the data are reportable, you would first need to determine whether records are currently maintained (e.g., accounting records, CIS, GIS and asset management) even though they may not currently be in a reporting format.\n\nPlease note that although numerous data items are outlined for potential reporting in this questionnaire, no final decision has been made as to what items constitute the final set or subset of activities or programs for benchmarking. OEB staff is interested in knowing what the potential possibilities are in order to carry out further assessments.  \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Q1"]
[]
[]
[]
[null,"a.","Do you maintain records for Accumulated Depreciation at the Asset class levels that can be reported?  If so, for how many years are these data available? \n(i.e., each item of PP&E in the 1800 and 1900 accounts series)"]
[]
[]
[]
[]
[null,null,"Please provide an explanation below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"b.","Can you report annually a fixed asset continuity schedule filed in rate applications (Appendix 2-BA)?  If so, for how many years are these data available?\nNote: As required in the filing requirements for cost of service rebasing and custom IR applications, at a minimum, a distributor must provide data for at least three years of historical actuals or from time of last application."]
[]
[]
[]
[]
[null,null,"Please provide an explanation below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"c.","Are some assets available for reporting by age or asset condition?  \nNote: In relation to asset condition, a visual inspection of an asset is not sufficient for this purpose."]
[]
[]
[]
[null,null,"Please provide an explanation below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"d.","Are asset value breakdowns (i.e., by gross and net book value $ amounts) available for reporting poles in Account 1830 “Poles, Towers and Fixtures”?  If so, for how many years are these data available?"]
[]
[]
[]
[]
[null,null,"Please provide an explanation below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Q2","Can you provide annually the values for the four DSP categories per the rate applications filing requirements in Chapter 5 (system access, system renewal, system service and general plant)?  If so, for how many years are these data available?"]
[]
[]
[]
[]
[]
[null,"Please provide an explanation below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note for the following question (Q3):"]
["\n The RRR uses the CEA definition of circuit-km in its request for this information. Please refer to the Canadian Electricity Association (link below) website for the definition. The potential request for “km of conductors”, “route-km” and “route length” are variations on circuit-km.  The km of conductors is the length of conductors that make up the circuits and will vary according to phase and grounding.  Route-km is the km of route followed by the circuits regardless of the number of circuits installed over that route."]
[]
[]
[]
[]
["CEA Definition"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Q3","Please provide some general guidance on providing the following data items: [see note on previous page]"]
[]
[]
[]
[null,null,"Data Item",null,null,null,"Already have it",null,"Easy to Gather",null,"Difficult to Gather",null,null,"Very Difficult or Impossible"]
[]
[]
[null,null,"Scale Variables (to determine impact of drivers on costs)"]
[]
[null,null,"MVa of Substation capacity"]
[]
[null,null,"Km of conductors (OH and UG)"]
[null,null,"Km of route (pole-km) (OH and UG)"]
[]
[null,null,"Number of line transformers"]
[]
[null,null,"Please provide any comments if applicable below:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Business Conditions (to determine the degree to which a condition impacts a distributor)"]
[]
[null,null,"% of useful life remaining by asset type"]
[]
[]
[null,null,"Asset failures by asset type"]
[]
[]
[null,null,"% of overhead route length with vegetation mature enough to be part of a management program"]
[]
[]
[]
[]
[null,null,"% of overhead route length with standard vehicle access"]
[]
[]
[null,null,"Please provide any comments if applicable below (text field expandable):"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data for Cost-Volume Analysis (to determine the costs for specific programs, for example, poles replacement)"]
[]
[]
[null,null,"Km of line charged to Account 5135 \"Overhead Distribution Lines & Feeders-Right of Way\""]
[]
[]
[null,null,"Number of poles replaced by type of pole"]
[null,null,"Cost of pole replacement by type of pole"]
[null,null,"% of poles unplanned"]
[]
[null,null,"Km of line installed/replaced by type of line"]
[null,null,"Cost of new line by type of line"]
[null,null,"% of km unplanned"]
[]
[null,null,"Number and capacity of new/replaced transformers by type of transformer"]
[]
[]
[null,null,"Cost of new transformers by type of transformer"]
[]
[]
[null,null,"% of transformers unplanned"]
[]
[null,null,"Please provide any comments if applicable below (text field expandable):"]