{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Contents","Cover","1. F-Factor summary","2. Individual fire start info","3. Systems and Audit"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":97,"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":"Contents","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,2,9,3],[2,1,2,10],[4,1,4,10]]}
[" "]
[]
[null,"Electricity Distribution Network Service Provider\nF-factor Reporting Template"]
[]
[null,"Table of contents"]
[]
[]
[null,null,"Cover sheet",null,null,"2. Fire start report"]
[]
[]
[]
[null,null,"1. F-factor summary",null,null,"3. Systems and Audit"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"NOTE: This spreadsheet includes IRU targets up to and including FY\"&'1. F-Factor summary'!J9","v":"NOTE: This spreadsheet includes IRU targets up to and including FY2022/23"}]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[26,3,26,8],[28,3,28,8],[26,1,26,2],[31,3,31,5],[14,1,14,8],[16,1,16,8],[17,1,17,8],[21,1,21,8],[19,1,19,8],[10,1,11,8],[13,1,13,8],[48,2,48,6],[42,2,42,3],[42,4,42,7],[46,2,46,6],[47,2,47,6],[38,2,38,3],[38,4,38,7],[41,2,41,3],[41,4,41,7],[37,2,37,3],[37,4,37,7],[32,3,32,8],[30,3,30,8],[15,1,15,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Distribution Network Service Provider"]
[null,"Fire start report"]
[]
[null,"This template is to be used by a DNSP to provide a fire start report to the AER in accordance with section 5 of the F-factor Order in Council.  "]
[]
[]
[null,"Colour coding of input sheets:"]
[null,"Dark blue = AER headings"]
[null,"Grey = AER instructions"]
[null,"Yellow = Input cells"]
[null,"Light orange = Automatically-generated cells"]
[]
[null,"Leave coloured cells blank if no information exists - PLEASE DO NOT ENTER TEXT unless specifically requested to do so."]
[null,"The cells and structure of the spreadsheet is locked to prevent inadvertent interference with the automated settings."]
[null,"All dollar amounts are to be unrounded, and in nominal terms."]
[]
[]
[]
[]
[null,"DNSP:",null,"CitiPower"]
[]
[null,"DNSP - trading name:",null,"CitiPower Pty Ltd"]
[]
[null,"DNSP - Australian business number: ",null,"ACN 064 651 056"]
[]
[null,"Reporting year:",null,"2022/23"]
[]
[]
[]
[]
[null,"Business address","Address",null,"40 Market Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode"]
[]
[null,"Postal address","Address",null,"Locked Bag 14090"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode"]
[]
[]
[null,"Contact name/s"]
[null,"Contact phone/s"]
[null,"Contact email address/s"]

{"sheet":"1. F-Factor summary","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,2,12,3],[13,2,13,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[5,1,5,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[11,2,11,3]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"},"IRU target:",{"$f":"IF(SUM(K2:O2)=0,\"\",SUM(K2:O2))","v":1.5},null,null,null,null,null,null,"AusNet Services","CitiPower","Jemena","Powercor","United Energy"]
[null,"F-factor data reporting","IRU amount:",{"$f":"IF(SUM('2. Individual fire start info'!S38:S2000)=0,\"\",SUM('2. Individual fire start info'!S38:S2000))","v":0.84680000000000011},null,null,null,null,null,"current",{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>K1),\"\",LOOKUP($B3,$J3:$J100,K3:K100))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>L1),\"\",LOOKUP($B3,$J3:$J100,L3:L100))","v":1.5},"","",""]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2022/23"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":9797.9999999999982},null,null,null,null,null,"2016/17",247.7,3.4,9.6999999999999993,468,22.3]
[null,null,null,null,null,null,null,null,null,"2017/18",247.7,3.4,9.6999999999999993,468,22.3]
[null,"Table 2: Summary of total fire starts by F factor Order definition",null,null,null,null,null,null,null,"2018/19",247.7,3.4,9.6999999999999993,468,22.3]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\"",null,null,null,null,null,null,null,"2019/20",221.1,3.4,9.6999999999999993,412.8,22.3]
[null,"Kind of Fire Start by definition of fire start under clause 5 of F-factor Order","Total fires by cause",null,null,null,null,null,null,"2020/21",177.5,1.3,4.2,277.60000000000002,18.7]
[null,"Started in or originated from a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B8)","v":20},null,null,null,null,null,null,"2021/22",164.3,1.9,3.7,235.2,19]
[null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B9)","v":1},null,null,null,null,null,null,"2022/23",149.69999999999999,1.5,2.7,188,13.9]
[null,"Started by any person, bird, reptile or other animal coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B10)","v":0}]
[null,"Started by lightning striking a distribution system or a part of a distribution system ",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B11)","v":0}]
[null,"Started by any other thing forming part of or coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B12)","v":0}]
[null,"Otherwise started by a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B13)","v":0}]
[null,"Total",{"$f":"SUM(C8:C13)","v":21}]

{"sheet":"2. Individual fire start info","index":3,"n_rows":237,"n_cols":25,"rows_kept":237,"cut":false,"hidden":false,"merged":[[3,22,3,24],[4,22,4,24],[5,22,5,24],[7,1,7,21],[11,1,11,2],[9,1,9,21],[13,1,13,11],[22,1,22,21],[24,1,24,21],[14,1,14,20],[15,1,15,18],[16,1,16,18],[18,1,18,18],[21,1,21,18],[19,1,19,18],[23,1,23,18],[20,1,20,18],[17,1,17,18],[25,1,25,18],[27,1,27,20],[26,1,26,21],[35,19,35,21],[33,1,33,4],[35,2,35,10],[28,1,28,18],[29,1,29,18],[35,11,35,13],[35,14,35,17]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2022/23"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"\"Enter into this worksheet fire start data, from any IT system, which have been recorded by \"&IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)&\". Note that fire starts must be in accordance with the definition of a fire start in the Order In Council.\"","v":"Enter into this worksheet fire start data, from any IT system, which have been recorded by CitiPower. Note that fire starts must be in accordance with the definition of a fire start in the Order In Council."}]
[]
[null,"\"Fire\" should be interpreted using its common meaning and can be defined as a process in which substances combine chemically with oxygen from the air and typically give out bright light, heat and smoke. A fire should be recorded where there is evidence of smoking, charring, scorching, burning or any other evidence that a fire had occurred.  "]
[]
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" must provide:\"))","v":"CitiPower must provide:"}]
[]
[null,"Table 3 - Individual Fire Starts"]
[null,"   (1) Date - dd/mm/yyyy"]
[null,"   (2) Time - if known, the 24-hour time of the fire start hh:mm"]
[null,"   (3) Latitude and longitude of the fire start as decimal coordinates"]
[null,"   (4) Address of the property on which the incident occurred or closest to the incident"]
[null,"   (5) Asset number for the asset nearest the fire start"]
[null,{"$f":"\"   (6) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the \"&B1&\" network\"","v":"   (6) Feeder ID for the polyphase overhead line or underground cable nearest the fire start in the CitiPower network"}]
[null,"   (7) Voltage on the line in which the fire start occurred (note: this may not be the nearest polyphase overhead line)"]
[null,"   (8) Network categorisation - CBD, Urban, Rural Long or Rural Short"]
[null,"   (9) Asset type of primary asset causing fire in accordance with OSIRIS asset categories"]
[null,"   (10) Where the asset involved in the fire is a transformer or an overhead or underground line, provide the phase, or phases, of the line or transformer"]
[null,"   (11) Kind of fire start in accordance with categories specified in Clause 5 of the F-factor Order-In-Council [Note: For the 2022-2023 period, the AER and ESV will accept either the initiating event or the cause.]"]
[null,"   (12) Identify the location of the fire start in accordance with the categories specified in Clause 11(b) of the F-factor Order-In-Council"]
[null,"   (13) Provide the BOM fire danger rating applicable at the time of the fire start (data is available on the EM-COP website) [Note: The fire danger rating applies from the time it was issued; ratings do no apply retrospectively. The rating from the previous day carries into the current day until the rating is changed. If no fire danger rating is issued for the day, a rating of \"No forecast\" applies for the whole day.]"]
[null,{"$f":"\"   (14) \"&IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)&\"'s record number for the incident\"","v":"   (14) CitiPower's record number for the incident"}]
[null,"   (15) ESV's OSIRIS reference number for the incident"]
[null,"   (16) Free text description of the fault containing relevant comments from field reports "]
[]
[]
[]
[null,"Table 2: Individual Fire Starts"]
[]
[null,"Number","Fire starts",null,null,null,null,null,null,null,null,"Fire Type",null,null,"Risk Factors",null,null,null,"IRU \namount","Additional information"]
[null,null,"Date 1","Time 2","Latitude 3","Longitude 3","Address of incident 4","ID of \nnearest \nasset 5","ID of nearest \npolyphase \nline 6","Voltage of line in which \nfire start \noccurred 7","Network categorisation 8","Type of primary asset \ninvolved in fire start 9","Phase(s) of \nline or \ntransformer 10","Kind of fire start as per Clause 5\nof F-factor Order-In-Council 11","Location \narea 12","Location\nmultiplier","Fire \ndanger \nrating 13","Danger multiplier","Product of multipliers","DNSP record number 14","OSIRIS \n(ESV) reference \nnumber 15","Fault \ndescription 16"]
[{"$f":"COUNTA(C38:O38,Q38,T38:V38)","v":17},1,"2022-07-18","07:35",-37.818392000000003,145.05113900000001,"40 HARCOURT STREET,HAWTHORN EAST,VIC,3123",30590633,"L019","Low voltage AC (<1kV)","Urban"," - connection box","single phase","Started in or originated from a distribution system","LBRA only",{"$f":"IF(O38=\"\",\"\",IF(O38=\"LBRA only\",0.2,IF(O38=\"HBRA only\",1,IF(O38=\"within electric line construction area\",19.8,IF(O38=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":0.2},"No forecast",{"$f":"IF(Q38=\"\",\"\",IF(C38>=DATE(2022,9,1),IF(Q38=\"No forecast\",0.05,IF(Q38=\"Moderate\",0.334,IF(Q38=\"High\",0.678,IF(Q38=\"Extreme\",2.272,4.754)))),0.05))","v":0.05},{"$f":"IF(OR(P38=\"\",R38=\"\"),\"\",IF(AND(O38=\"within electric line construction area\",Q38=\"No forecast\"),1,P38*R38))","v":1.0000000000000002E-2},"INC-0017997","20220718PWA_01","Emergency services advised of a pole fire at the incident address.\nUpon arrival crew found that a FOLCB had caught fire & was burnt.\nThere was no reportable ground fire.",null,null,"Overhead conductors"]
[17,2,"2022-07-20","19:07",-37.768014000000001,144.97086200000001,"Victoria St, Brunswick VIC 3056","30155702, CP0001093","BK002","Low voltage AC (<1kV)","Urban"," - underground cable","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",{"$f":"IF(Q39=\"\",\"\",IF(C39>=DATE(2022,9,1),IF(Q39=\"No forecast\",0.05,IF(Q39=\"Moderate\",0.334,IF(Q39=\"High\",0.678,IF(Q39=\"Extreme\",2.272,4.754)))),0.05))","v":0.05},1.0000000000000002E-2,"INC-0018037","20220721PWA_01","Customer reported large bang from Victoria 164-Lygon substation.\ncrew found damaged straight joint on cable just under LV board in substation ",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2022-07-31","11:18",-37.861705000000001,145.01613399999999,"426 DANDENONG ROAD  CAULFIELD NORTH 3161",30219201,"AR004","Low voltage AC (<1kV)","Urban"," - connection box","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0018133","20220801PWA_02","Emergency services, reported apartment fire, started at POA\nAttending fault crew  advised Customer FOLCB had caught fire and was melting. The CitiPower aerial service cable  was damaged\nCrew checked connection at mains prior to disconnecting, no faults found, Insufficient remains to determine  exact point of origin of fire ",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2022-08-10","16:02",-37.791327000000003,144.97385700000001,"271A Canning St, Carlton North VIC 3054, Australia",30179877,"VM006","Low voltage AC (<1kV)","Urban"," - pole (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0018234","20220811PWA_04","The CitiPower report room was notified of a pole fire at 53-66 Lee Street, Carlton North. \nVic Fire was in attendance and did not require any action. \nOn attendance the CitiPower faults crew found minor burn mark on the pole LIS 75259 between 2 steel conduits for both a LV cable head and a public lighting cascade cable head. \n No shock, no third party damage, no injuries.",null,null," - overhead conductor (bare; copper)"]
[17,5,"2022-08-21","08:18",-37.829990000000002,144.95516699999999,"412 City Road, Southbank, 3006.",30167534,"AP001","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0018303","20220822PWA_02","Customer reported blue phase caught on fire. Fire has been put out, no one injured. Property has part power.\nCrew report W phase LV fuse has overheated causing the fuse housing to melt and catch fire. Fire extinguished before crew arrived.",null,null," - overhead conductor (bare; steel)"]
[17,6,"2022-09-17","08:53",-37.833401000000002,144.921672,"2/359 Plummer St, Port Melbourne VIC 3207, Australia",30202746,"PM002","6.6kV AC","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0018549","20220920PWA_01","VicFire called the CitiPower report room to advise of a wire down on the corner of Smith and Plummer Streets in Port Melbourne.\nOn arrival the CitiPower faults crew found that the HV crossarm had failed (burnt off).\nThe HV conductor making contact with with the LV conductor below which resulted in a HV injection. \nThere was a crossarm fire, no ground fire, no shocks or injuries.",null,null," - overhead conductor (ABC)"]
[17,7,"2022-10-22","09:10",-37.842354,145.08552299999999,"50 Lynden St, Camberwell VIC 3124",30177644,"RD009","Low voltage AC (<1kV)","Urban","Overhead conductors","three phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0019478","20230105PWA_02","Tree branch contacted LV conductors.\nFRV reports small fire\nFound during outage data review\nNo photos found",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2022-11-28","00:19",-37.859509000000003,144.97781499999999,"151/129 Fitzroy St, St Kilda VIC 3182, Australia",30202660,"SK005","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0019158","20221129PWA_04","A member of the public reported a street light on fire.  FRV also attended.  On arrival, CitiPower faults personnel found that a public light head burnt out.",null,null," - overhead conductor (insulated)"]
[17,9,"2022-12-06","11:38",-37.796519000000004,145.089236,"15 McShane St, Balwyn North VIC 3104",30192160,"WD013","11kV AC","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0019525","20230113PWA_03","Crossarm fire, no ground fire, 15 McShane St, Balwyn North VIC 3104, \nOutage data review",null,null,"Service lines"]
[17,10,"2023-01-01","19:15",-37.846753999999997,144.94881100000001,"150 Victoria Avenue, Albert Park, VIC, 3206",30172536,"AP003","Low voltage AC (<1kV)","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0019456","20230103PWA_02","System showed customer outages on LV fuse 2 at substation 'VICTORIA-REED'.\nCrew dispatched and when arrived on site, the crew observed burnt shrubs in the garden bed on the southeast side of LIS 39395 that had been extinguished.",null,null," - overhead service conductor (residential)"]
[17,11,"2023-01-02","02:41",-37.826695000000001,144.927527,"2-46 DOUGLAS STREET, PORT MELBOURNE 3207",30218735,"FBTS-WG","66kV AC","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0019455","20230103PWA_01","Pole fire fault reported. CitiPower crew was dispatched to site. \nCrew observed LIS 31835 on fire from the level of the supervisory cables through to the top of the pole",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2023-01-12","19:03",-37.796754,144.96478500000001,"834 Swanston St, Carlton VIC 3053, Australia (Corner Swanston st and Elgin st Carlton)",30325286,"BQ032","Low voltage AC (<1kV)","CBD"," - underground cable","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0019523","20230113PWA_02","FRV reported pole fire at incident location\nOn arrival crew found underground cable had faulted\nThere was no ground fire, no reported injuries or third party property damage.",null,null," - overhead service conductor (subdivision / construction)"]
[17,13,"2023-01-17","13:42",-37.799779000000001,145.04941099999999,"593b State Route 36, Kew VIC 3101 (595 High St, Kew East VIC 3102)",30180302,"Q005","Low voltage AC (<1kV)","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.67800000000000005,0.13560000000000003,"INC-0019577","20230118PWA_01","Dispatch reported that Vic emergency reporting of lines on fire and a BMW car trapped under the lines and no occupant. \nThey also reported that the crossarm is on fire, flame.\nUpon arrival, crew reported a burnt out IPC that disconnected itself and the plastic has melted off on to the ground which has resulted in small patch of burns on the grass (approx 30 sq. cm size) .\nNo vehicle was found to be present.\nThere were no reported injuries. ",null,null," - overhead service conductor (other)"]
[17,14,"2023-03-21","22:15",-37.802244999999999,144.95411999999999,"21 Courtney St, North Melbourne VIC 3051",30190223,"BQ017","11kV AC","CBD"," - dropper / bridge","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0020219","20230322PWA_01","Report received of pole fire at incident location.\nCrew advise that Blue phase HV bushing on gas switch has caught fire. \nFire brigade on site. Fire self extinguished.\nNo ground fire.",null,null," - underground service cable (residential)"]
[17,15,"2023-03-21","17:15",-37.821947000000002,145.04578000000001,"3 Victoria Road, Hawthorn East, 3123.",30182211,"CL037","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0020220","20230322PWA_02","Report received of service wire sparking and POA on fire.\nFlames have subsided, lost supply.\nCrew advise that the service connections at the point  of attachment appear to have become loose causing overheating of the connection at the POA. \nThis resulted in a small fire when the connection fused. \nThe fire self extinguished.\n",null,null," - underground service cable (commercial / industrial)"]
[17,16,"2023-03-23","09:19",-37.825983999999998,144.98869999999999,"413 PUNT ROAD,CREMORNE,VIC,3121 (389 State Route 29, Cremorne VIC 3121, Australia)",30221593,"R031","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0020251","20230324PWA_02","Yarra City Council advised fire at top of street light pole at incident location.\nCrew found lantern head had been on fire.\nthere was no ground fire or reported injuries.",null,null," - underground service cable (subdivision / construction)"]
[17,17,"2023-04-11","03:36",-37.794469999999997,144.96995999999999,"Level 12/478 Drummond st Carlton",83732241,"BQ065","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,{"$f":"IF(OR(P54=\"\",R54=\"\"),\"\",IF(AND(O54=\"within electric line construction area\",Q54=\"No forecast\"),1,P54*R54))","v":6.6800000000000012E-2},"INC-0020381","20230411PWA_07","Crew arrived and found severe damage to a number of meters located in meter panel enclosure on level 12/478 Drummond st Carlton. Meters damaged A3349798,  A1349792, A5349813, A3349791, A8349789, A349790. 3 x meters unable to read as per damage. Total 54 customers off supply",null,null," - underground service cable (other)"]
[17,18,"2023-04-11","09:10",-37.868290999999999,145.01420400000001,"577 Inkerman Rd, Caulfield North VIC 3161 ",30219376,"EL022","Low voltage AC (<1kV)","Urban"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0020399","20230412PWA_03","Upon arrival, crew confirmed that the white phase FSD had caught fire and all three had melted. \nNo ground fire and no reported injuries.",null,null,"Underground cables"]
[17,19,"2023-04-28","19:04",-37.773394000000003,144.95437699999999,"102 Union Street, Brunswick, 3056.",30238305,"C024","Low voltage AC (<1kV)","Urban"," - switch (disconnector/isolator)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Moderate",0.33400000000000002,6.6800000000000012E-2,"INC-0020526","20230501PWA_02","Crew advise that a FMJB on pole LIS 96745 located on the corner of Union and Fallon Streets was on fire and has self extinguished",null,null," - underground cable"]
[17,20,"2023-05-12","18:39",-37.854717000000001,145.011573,"Outside 570 Orrong Road, Armadale",30164279,"AR011","Low voltage AC (<1kV)","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0020634","20230515PWA_05","LV CABUS box failed explosively no injury,  small ground fire",null,null," - underground communications cable"]
[17,21,"2023-06-01","10:37",-37.761557000000003,145.011078,"46A Clyde St, Thornbury VIC 3071",30195825,"FF084","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.05,1.0000000000000002E-2,"INC-0020768","20230601PWA_02","House fire start at poa.",null,null,"Poles"]
[0,22,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - pole (concrete)"]
[0,23,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - pole (steel)"]
[0,24,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - pole (wood)"]
[0,25,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Crossarms"]
[0,26,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (wood)"]
[0,27,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (steel)"]
[0,28,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - crossarm (other)"]
[0,29,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Overhead assets"]
[0,30,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - capacity balancing units"]
[0,31,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - connector / termination"]
[0,32,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - dropper / bridge"]
[0,33,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - guy wire"]
[0,34,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - insulator tie wires / connections"]
[0,35,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - insulators"]
[0,36,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - tower"]
[0,37,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - traction lines"]
[0,38,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P75=\"\",R75=\"\"),\"\",IF(AND(O75=\"within electric line construction area\",Q75=\"No forecast\"),1,P75*R75))","v":""},null,null,null,null,null,"Underground assets"]
[{"$f":"COUNTA(C76:O76,Q76,T76:V76)","v":0},39,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O76=\"\",\"\",IF(O76=\"LBRA only\",0.2,IF(O76=\"HBRA only\",1,IF(O76=\"within electric line construction area\",19.8,IF(O76=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"","",null,null,null,null,null," - LV pillar"]
[0,40,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - services pit"]
[0,41,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Transformers"]
[0,42,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (pole mounted)"]
[0,43,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (kiosk mounted)"]
[0,44,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (ground outdoor mounted)"]
[0,45,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (indoor chamber mounted)"]
[0,46,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - transformer (any other type)"]
[0,47,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (current transformer)"]
[0,48,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (voltage transformer)"]
[0,49,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - measurement transformer (capacitive voltage transformer)"]
[0,50,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Fuses and switchgear"]
[0,51,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (boric acid)"]
[0,52,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (EDO fuse)"]
[0,53,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (Fault Tamer)"]
[0,54,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (powder filled)"]
[0,55,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - fuse (any other type)"]
[0,56,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - circuit breaker"]
[0,57,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (disconnector/isolator)"]
[0,58,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (earth)"]
[0,59,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (FuseSaver)"]
[0,60,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - switch (any other type)"]
[0,61,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"SCADA, network control and protection systems"]
[0,62,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - audio frequency load controller (AFLC)"]
[0,63,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - arc suppresion coil"]
[0,64,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - automatic circuit recloser (ACR)"]
[0,65,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - communications linear assets"]
[0,66,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q103=\"\",\"\",IF(C103>=DATE(2022,9,1),IF(Q103=\"No forecast\",0.05,IF(Q103=\"Moderate\",0.334,IF(Q103=\"High\",0.678,IF(Q103=\"Extreme\",2.272,4.754)))),0.05))","v":""},"",null,null,null,null,null," - communications network assets"]
[0,67,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - communications site infrastructure"]
[0,68,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - field devices"]
[0,69,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - local network wiring assets"]
[0,70,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P107=\"\",R107=\"\"),\"\",IF(AND(O107=\"within electric line construction area\",Q107=\"No forecast\"),1,P107*R107))","v":""},null,null,null,null,null," - master station assets"]
[0,71,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - neutral earthing resistor"]
[0,72,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - oil-filled circuit recloser (OCR)"]
[0,73,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - rapid earth fault current limiter (REFCL)"]
[0,74,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - surge diverter"]
[0,75,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - voltage regulator"]
[0,76,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Public lighting"]
[0,77,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - brackets (major road)"]
[0,78,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - brackets (minor road)"]
[0,79,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - lamps (major road)"]
[0,80,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - lamps (minor road)"]
[0,81,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - luminaires (major road)"]
[0,82,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - luminaires (minor road)"]
[0,83,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - poles / columns (major road)"]
[0,84,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - poles / columns (minor road)"]
[0,85,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Other "]
[0,86,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - connection box"]
[0,87,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - earth / earthing"]
[0,88,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,89,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,90,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Extra low voltage AC (<50V)"]
[0,91,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Low voltage AC (<1kV)"]
[0,92,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"2.2kV AC"]
[0,93,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"6.6kV AC"]
[0,94,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"11kV AC"]
[0,95,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"12.7kV AC (SWER)"]
[0,96,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"22kV AC"]
[0,97,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"33kV AC"]
[0,98,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"66kV AC"]
[0,99,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"132kV AC"]
[0,100,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"220kV AC"]
[0,101,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"330kV AC"]
[0,102,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P139=\"\",R139=\"\"),\"\",IF(AND(O139=\"within electric line construction area\",Q139=\"No forecast\"),1,P139*R139))","v":""},null,null,null,null,null,"500kV AC"]
[{"$f":"COUNTA(C140:O140,Q140,T140:V140)","v":0},103,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O140=\"\",\"\",IF(O140=\"LBRA only\",0.2,IF(O140=\"HBRA only\",1,IF(O140=\"within electric line construction area\",19.8,IF(O140=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"","",null,null,null,null,null,"Extra low voltage DC (<120V ripple free)"]
[0,104,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Low voltage DC (<1.5kV)"]
[0,105,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"600V DC"]
[0,106,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"1500V DC"]
[0,107,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Earthing cable"]
[0,108,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,109,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,110,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"single wire earth return (SWER)"]
[0,111,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"single phase"]
[0,112,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"two phase"]
[0,113,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"three phase"]
[0,114,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,115,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,116,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Negligible: no ground fire"]
[0,117,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Localised: less than 10 sq.m"]
[0,118,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Small: 10 - 1000 aq.m"]
[0,119,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Medium: 1000 sq.m - 10 ha"]
[0,120,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Large: more than 10 ha"]
[0,121,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,122,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,123,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started in or originated from a distribution system"]
[0,124,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system"]
[0,125,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any person, bird, reptile or other animal coming into contact with a distribution system"]
[0,126,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by lightning striking a distribution system or a part of a distribution system "]
[0,127,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Started by any other thing forming part of or coming into contact with a distribution system"]
[0,128,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Otherwise started by a distribution system"]
[0,129,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,130,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q167=\"\",\"\",IF(C167>=DATE(2022,9,1),IF(Q167=\"No forecast\",0.05,IF(Q167=\"Moderate\",0.334,IF(Q167=\"High\",0.678,IF(Q167=\"Extreme\",2.272,4.754)))),0.05))","v":""},""]
[0,131,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,1]
[0,132,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,2]
[0,133,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,3]
[0,134,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P171=\"\",R171=\"\"),\"\",IF(AND(O171=\"within electric line construction area\",Q171=\"No forecast\"),1,P171*R171))","v":""},null,null,null,null,null,4]
[0,135,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,5]
[0,136,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,6]
[0,137,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,7]
[0,138,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,8]
[0,139,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,9]
[0,140,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,10]
[0,141,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,{"$f":"Y177+1","v":11}]
[0,142,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,{"$f":"Y178+1","v":12}]
[0,143,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,13]
[0,144,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,14]
[0,145,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,15]
[0,146,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,16]
[0,147,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,17]
[0,148,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,18]
[0,149,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,19]
[0,150,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,20]
[0,151,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,152,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,153,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,154,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P191=\"\",R191=\"\"),\"\",IF(AND(O191=\"within electric line construction area\",Q191=\"No forecast\"),1,P191*R191))","v":""}]
[0,155,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,156,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,157,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,158,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,159,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,160,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C198:O198,Q198,T198:V198)","v":0},161,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C199:O199,Q199,T199:V199)","v":0},162,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,163,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,164,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,165,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,166,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,167,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O204=\"\",\"\",IF(O204=\"LBRA only\",0.2,IF(O204=\"HBRA only\",1,IF(O204=\"within electric line construction area\",19.8,IF(O204=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",""]
[0,168,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,169,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,170,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C208:O208,Q208,T208:V208)","v":0},171,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C209:O209,Q209,T209:V209)","v":0},172,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,173,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,174,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,175,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,176,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,177,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,178,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,179,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,180,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,181,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,182,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,183,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C221:O221,Q221,T221:V221)","v":0},184,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C222:O222,Q222,T222:V222)","v":0},185,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,186,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,187,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,188,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,189,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,190,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,191,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,192,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,193,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,194,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(Q231=\"\",\"\",IF(C231>=DATE(2022,9,1),IF(Q231=\"No forecast\",0.05,IF(Q231=\"Moderate\",0.334,IF(Q231=\"High\",0.678,IF(Q231=\"Extreme\",2.272,4.754)))),0.05))","v":""},""]
[0,195,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,196,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C234:O234,Q234,T234:V234)","v":0},197,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O234=\"\",\"\",IF(O234=\"LBRA only\",0.2,IF(O234=\"HBRA only\",1,IF(O234=\"within electric line construction area\",19.8,IF(O234=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",{"$f":"IF(OR(P234=\"\",R234=\"\"),\"\",IF(AND(O234=\"within electric line construction area\",Q234=\"No forecast\"),1,P234*R234))","v":""}]
[{"$f":"COUNTA(C235:O235,Q235,T235:V235)","v":0},198,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O235=\"\",\"\",IF(O235=\"LBRA only\",0.2,IF(O235=\"HBRA only\",1,IF(O235=\"within electric line construction area\",19.8,IF(O235=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,"",{"$f":"IF(OR(P235=\"\",R235=\"\"),\"\",IF(AND(O235=\"within electric line construction area\",Q235=\"No forecast\"),1,P235*R235))","v":""}]
[0,199,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,200,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]

{"sheet":"3. Systems and Audit","index":4,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,1,29,4],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,1,6,4],[9,1,9,4],[14,1,14,4],[10,1,10,4],[13,1,13,4],[12,1,12,4],[11,1,11,4]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2022/23"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" must provide:\"))","v":"CitiPower must provide:"}]
[]
[null,"Table 4 - Information or reporting systems"]
[null,"   (1) Name of any IT system used to collect fire start data or fault event data - i.e. SCADA system, or fault reporting system"]
[null,"   (2) Whether the fire recording or fault recording process has been audited or complies with a relevant Australian or industry standard - Yes or No"]
[null,"   (3) List any relevant Australian or industry standards that the fire recording or fault recording process complies with"]
[null,"   (4) Whether the data entered into or removed from the IT system has been audited - Yes or No"]
[]
[]
[null,"Table 4: Information or reporting systems"]
[]
[null,"Information or reporting systems","Name","System Audited","Relevant Standards"]
[null,"System 1","Network Incidents Database","Yes","None applicable"]
[null,"System 2","Outage Management System (OMS)","Yes","None applicable"]
[null,"System 3 ","Smallworld GIS (Graphical Information System)","Yes","None applicable"]
[null,"System 4"]
[null,"System 5"]
[null,"System 6"]
[null,"System 7"]
[null,"System 8"]
[]
[null,"The SGSPAA Internal Audit function undertakes a programme of work in accordance with the SGSPAA Group Internal Audit Plan. This internal audit activity covers elements of the systems and process used for capturing, recording and maintaining fire start data."]