{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Billing and Collecting"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Billing and Collecting","index":0,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,4,1,8],[5,10,6,10],[5,12,5,16],[6,4,6,8],[17,10,18,11]]}
[]
[null,null,null,null,"Customers, 2023 Forecast"]
[null,null,null,null,"Res","GS<50","GS>50 ","Strt Lgt","USL"]
[null,null,null,null,{"$f":"[1]Meters!N6","v":16987},{"$f":"[1]Meters!O7+[1]Meters!O9","v":1830},{"$f":"[1]Meters!P8","v":128},3,30]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Weighted Customers",null,"Allocated Cost"]
[null,"Expense Description ",null,"2021 Budget","Relative Cost (weight) Per Customer",null,null,null,null,null,null,null,{"$f":"E3","v":"Res"},{"$f":"F3","v":"GS<50"},{"$f":"G3","v":"GS>50 "},{"$f":"H3","v":"Strt Lgt"},{"$f":"I3","v":"USL"}]
[null,"Canada Post Corp",null,100000,1,1,1,1,1,null,{"$f":"SUMPRODUCT(E8:I8,E$4:I$4)","v":18978},null,{"$f":"IFERROR($D8*E8/$K8,0)","v":5.2692591421646116},{"$f":"IFERROR($D8*F8/$K8,0)","v":5.2692591421646116},5.2692591421646116,5.2692591421646116,{"$f":"IFERROR($D8*I8/$K8,0)","v":5.2692591421646116}]
[null,"Utility Collaborative Services",null,130000,1,1,1,1,1,null,{"$f":"SUMPRODUCT(E9:I9,E$4:I$4)","v":18978},null,{"$f":"IFERROR($D9*E9/$K9,0)","v":6.8500368848139948},6.8500368848139948,6.8500368848139948,6.8500368848139948,6.8500368848139948]
[null,"Util-Assist Inc",null,55000,1,1,1,null,null,null,18945,null,2.903140670361573,2.903140670361573,2.903140670361573,0,0]
[null,"Utilismart",null,77000,1,1.5,3,1,null,null,20119,null,3.8272279934390379,5.7408419901585566,11.481683980317113,3.8272279934390379,0]
[null,"Docu-Link",null,120000,1,1,1,1,1,null,18978,null,6.3231109705975337,6.3231109705975337,6.3231109705975337,6.3231109705975337,6.3231109705975337]
[null,"Other",null,27000,1,1,1,1,1,null,18978,null,1.4226999683844452,1.4226999683844452,1.4226999683844452,1.4226999683844452,1.4226999683844452]
[null,"Supervision",null,134000,1,1,2,1,1,null,19106,null,7.0135036114309637,7.0135036114309637,14.027007222861927,7.0135036114309637,7.0135036114309637]
[null,"Billing Department",null,84000,1,1,1,1,1,null,18978,null,4.4261776794182737,4.4261776794182737,4.4261776794182737,4.4261776794182737,4.4261776794182737]
[null,"Collections Department",null,95000,1,1,1,null,null,null,18945,null,5.0145157033518082,5.0145157033518082,5.0145157033518082,0,0]
[null,"Customer Service Department",null,146000,1,1,2,1,1,null,19106,null,7.6415785617083642,7.6415785617083642,15.283157123416728,7.6415785617083642,7.6415785617083642]
[null,null,null,null,null,null,null,null,null,null,"Identified Cost per Customer"]
[null,"Totals",null,{"$f":"SUM(D8:D18)","v":968000},null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M17)","v":50.691251185670602},{"$f":"SUM(N8:N17)","v":52.604865182390121},{"$f":"SUM(O8:O17)","v":73.000789345688005},{"$f":"SUM(P8:P17)","v":42.773594811957224},{"$f":"SUM(Q8:Q17)","v":38.946366818518186}]
[]
[null,"WEIGHTING FACTORS for Cost Allocation Model",null,null,null,null,null,null,null,null,null,null,{"$f":"M19/$M19","v":1},{"$f":"N19/$M19","v":1.0377503800352132},1.440106283395977,0.8438062547575953,0.7683054946871688,"<Output to CAM"]
[]
[]
[null,"Assumptions:"]
[null,"UtiliSmart","GS<50 and GS>50 have higher weights due to the increased data collection and interval data stored."]
[null,null,"It is higher for GS>50kW because not all GS<50kW have interval data but we do track certain meters for reclassification"]
[null,"Supervision/Customer service","Higher for GS>50kW customers due to increased involvement and engagement (i.e. ICI, ad hoc requests for load data and other expansion projects)"]