{"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'!J8","v":"NOTE: This spreadsheet includes IRU targets up to and including FY2021/22"}]

{"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,"2021/22"]
[]
[]
[]
[]
[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.9},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":1.1000000000000001},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.9},"","",""]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2021/22"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":11999.999999999998},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":18},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":5}]
[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":23}]

{"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":"2021/22"}]
[]
[]
[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"]
[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)"]
[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,"2021-07-02","22:15",-37.800835999999997,144.97690600000001,"293 FITZROY STREET,FITZROY,VIC,3065",30166548,"CW004","Low voltage AC (<1kV)","Urban"," - overhead service conductor (commercial / industrial)","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(Q38=\"No forecast\",0.1,IF(Q38=\"Low-moderate\",0.2,IF(Q38=\"High\",0.5,IF(Q38=\"Very high\",1,IF(Q38=\"Severe\",2,IF(Q38=\"Extreme\",3.5,5)))))))","v":0.1},{"$f":"IF(OR(P38=\"\",R38=\"\"),\"\",IF(AND(O38=\"within electric line construction area\",Q38=\"No forecast\"),1,P38*R38))","v":2.0000000000000004E-2},"INC-0014251","20210706PWA_01","POA caught on fire. Fire brigade attended.   Supply is no off  ( unsure if fire brigade isolated. )\n\nCrew advise FMJB has overloaded (loose connection), heat has caused melting of the box and possibly  a fire which has self extinguished.\n",null,null,"Overhead conductors"]
[17,2,"2021-07-27","08:28",-37.787249000000003,145.073531,"8 Aquila St, Balwyn North VIC 3104",30184622,"WD011","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","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.1,2.0000000000000004E-2,"INC-0016305","20211209PWA_02","Report of tree branch burnt and fallen to ground.\nNo ground fire.\nFound during outage data review\nNo photos found",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2021-08-09","13:23",-37.866602,144.99598499999999,"80 Westbury St, Balaclava VIC 3183",30210461,"BC006","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0014699","20210810PWA_02","Report of fire on service line at incident location.\nOn arrival crew found that a fuse box had overheated and possibly caught fire.\nThere was no ground fire, no reported injuries or third party property damage",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2021-08-18","04:30",-37.818284200000001,145.00466119999999,"9-13 Palmer St Richmond 3121",30195105,"NR042","Low voltage AC (<1kV)","Urban"," - connection box","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0014779","20210818PWA_04","Report received from MFB and customer of pole arcing and sparking at incident location.\nOn arrival crew found a section of LV droppers burnt and a FOLCB melted.\nThere was no evidence of ground fire, no reported injuries or third party property damage.",null,null," - overhead conductor (bare; copper)"]
[17,5,"2021-09-09","16:43",-37.782288000000001,145.006393,"169 Westgarth st Northcote vic 3070 (104 State Route 38, Northcote VIC 3070, Australia)",30324249,"NC002","11kV AC","Urban"," - overhead conductor (bare; copper)","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.1,2.0000000000000004E-2,"INC-0016319","20211210PWA_05","Large branch fallen onto hv mains, on fire at the moment, cust Lee ph 0427874796 will call 000 for fire brigade and police to attend. it's over a footpath and people walking around. huge bang when the branch fell onto mains and fire started.\nNo ground fire\nFound during otage data review \nno photos",null,null," - overhead conductor (bare; steel)"]
[17,6,"2021-09-09","19:54",-37.775337999999998,145.011021,"cnr Bastings st and Victoria st Northcote vic 3070",30316541,"NC002","Low voltage AC (<1kV)","Urban"," - luminaires (minor road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0016320","20211210PWA_06","Report of street light on fire.\nNo ground fire\nno photos\nfound during outage data review",null,null," - overhead conductor (ABC)"]
[17,7,"2021-10-29","05:20",-37.815375000000003,145.00745699999999,"156 Kent St, Richmond VIC 3121",30183187,"NR002","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","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,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016343","20211214PWA_04","Report of Tree branch on wire and causing fire.\nNo report of ground fire\nNo photos\nFound during outage data review\n",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2021-10-29","08:46",-37.791609999999999,145.07089300000001,"5 Bulleen Rd, Balwyn North VIC 3104",30185528,"WD011","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,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016344","20211214PWA_05","Branch fell on pole, during violent wind storm, ​caused a fire, now out. right hand side of this property. wire looks like it been turned around.\nNo ground fire\nFound during outage data review\nNo photos",null,null," - overhead conductor (insulated)"]
[17,9,"2021-10-31","19:03",-37.791828000000002,145.096642,"2 Ellsa St, Balwyn North VIC 3104",30184063,"WD013","11kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","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,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016345","20211214PWA_06","Tree on pole to pole wire, caught fire however now not on fire. above footpath.\nNo ground fire\nno photos \nfound during outage data review",null,null,"Service lines"]
[17,10,"2021-12-20","16:45",-37.856855000000003,144.97389999999999,"212 Canterbury Rd, St Kilda West VIC 3182, Australia",30214595,"AP005","11kV AC","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016411","20211222PWA_01","A HV feeder fault occurred on AP005. When restoring the feeder via remote switching there was a flash over at HV tee off pole LIS-36373. The flash over resulted in a grass fire in the road reserve which was put out by residents and VicFire. The fire covered approx 45sqm \n\nTMC advised  but case # appears incorrectly as #1790441",null,null," - overhead service conductor (residential)"]
[17,11,"2021-12-31","14:35",-37.770021999999997,144.94169400000001,"21 Moule St, Brunswick West VIC 3055, Australia",30156966,"C024","6.6kV AC","Urban"," - overhead conductor (bare; copper)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Very high",1,0.2,"INC-0016476","20220104PWA_02"," 6.6kV conductor on ground, resulted in a small ground fire.  ",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2022-01-19","13:56",-37.814646000000003,144.95812699999999,"493 little Bourke Street / Melbourne",60288443,"LQ010","Low voltage AC (<1kV)","Urban"," - underground cable","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,0.1,"INC-0016624","20220121PWA_02","Fire comms advised of box on fire on side of building 493 little Bourke st Melbourne.\n\nUpon arrival the crew found that LV cable supplying fuse box had failed & damage to the building wall (charring) was sustained. ",null,null," - overhead service conductor (subdivision / construction)"]
[17,13,"2022-01-27","09:26",-37.851458999999998,144.95662100000001,"189-191 Beaconsfield Parade, Middle Park VIC 3206",30213813,"AP008","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,0.1,"INC-0016921","20220218PWA_05","Customer reported pole fire.\nOn arrival crew found a lantern head had caught fire.\nNo Ground fire\nFound during outage data review, no photo of damage",null,null," - overhead service conductor (other)"]
[17,14,"2022-01-28","18:14",-37.839356000000002,144.946144,"46 Cruikshank st Port Melbourne",30205465,"AP014","Low voltage AC (<1kV)","Urban"," - connection box","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016674","20220131PWA_04","Customer  reported Crossarm and service wire to neighbours property on fire.\nOn arrival crew found that overhead connection box had caught fire.\nThere was no ground fire, no reported injuries or third party property damage.",null,null," - underground service cable (residential)"]
[17,15,"2022-01-31","19:43",-37.819597999999999,145.031781,"29-35 Linda Cres, Hawthorn VIC 3122, Australia",30244132,"CL013","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0016680","20220201PWA_01","MFB reported wire down and grass fire. \nCrew arrived onsite and found LV IPC  burnt out resulting in red phase bare aluminium conductor contacting the ground. small amount of burnt grass around base of pole. \nThere was no reported injuries or third party property damage.",null,null," - underground service cable (commercial / industrial)"]
[17,16,"2022-02-16","15:44",-37.829894000000003,145.01071200000001,"45 Gibdon St, Burnley VIC 3121","CP0009953","R033","Low voltage AC (<1kV)","Urban","Fuses and switchgear","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,0.1,"INC-0016944","20220218PWA_01","Firecom report smoke from Substation, 45 Gibdon St, Burnley VIC 3121\nCrew arrived onsite and found customers LV circuit had been alight and was extinguished by MFB. \n As a result the water has run through to lower level and caused an outage on Gibdon-Crimea substation.\nThere was no reported injuries",null,null," - underground service cable (subdivision / construction)"]
[17,17,"2022-03-06","16:01",-37.834919999999997,144.95394200000001,"348 DORCAS STREET,SOUTH MELBOURNE,VIC,3205",30206683,"AP007","Low voltage AC (<1kV)","Urban"," - luminaires (minor road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,{"$f":"IF(OR(P54=\"\",R54=\"\"),\"\",IF(AND(O54=\"within electric line construction area\",Q54=\"No forecast\"),1,P54*R54))","v":0.1},"INC-0017047","20220307PWA_05","Report received of street light fire at incident location.\nCrew advise watchman light on pole has shorted out and caught fire. \nFire already extinguished when crew arrived on site.\nThere was no ground fire or reported injuries",null,null," - underground service cable (other)"]
[17,18,"2022-04-09","06:23",-37.809849,144.991581,"1-9 Hoddle St, Richmond VIC 3121, Australia",30320636,"B014","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"INC-0017331","20220517PWA_02","Street light head needs replacing after fire earlier \nNo ground fire\nFound during outage data review\nNo photos found",null,null,"Underground cables"]
[17,19,"2022-05-17","11:20",-37.815702000000002,145.00235699999999,"42 Somerset St, Richmond VIC 3121",30186622,"NR042","11kV AC","Urban"," - insulators","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0017541","20220519PWA_04","Crews carrying out work in the area found  HV strain xarm burnt and deteriorated, needs to be replaced.\nNot sure when fire damage occurred.\nThere was no ground fire, no reported injuries or third party property damage.",null,null," - underground cable"]
[17,20,"2022-05-30","19:06",-37.770386000000002,145.007983,"163 SEPARATION STREET NORTHCOTE 3070.",30190934,"NC006","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0017659","20220601PWA_07","Crew report that an IPC has melted and the roadside conductor outside this address has broken and fallen onto the ground.\nThere was no ground fire, no reported injuries or third party property damage",null,null," - underground communications cable"]
[17,21,"2022-05-31","17:50",-37.800758000000002,145.059314,"1 Lady Brasseys Dr, Kew VIC 3101",30242382,"L015","Low voltage AC (<1kV)","Urban"," - dropper / bridge","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0017661","20220602PWA_02","Crew report that the Red phase low voltage transformer connection to the bushing has ignited due to load / loose connection. \nFire was extinguished by the fire brigade.\nThere was no ground fire, injuries or third party property damage.\n",null,null,"Poles"]
[17,22,"2022-06-10","07:17",-37.848202000000001,145.00450900000001,"539 MALVERN ROAD,TOORAK,VIC,3142",30160827,"TK004","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0017757","20220610PWA_02","Person  reported pole at the front of property caught on fire and smoking (not currently on fire) it exploded and made a bang, supply off, unsure what caused, customer unsure if any wires down\nAttending crew found IPC on blue had had overheated and had signs of burning.\nThere was no ground fire.",null,null," - pole (concrete)"]
[17,23,"2022-06-30","11:10",-37.846801999999997,144.994764,"251-253 Malvern Rd, South Yarra VIC 3141",30216891,"BC019","Low voltage AC (<1kV)","Urban"," - connector / termination","single phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"INC-0017903","20220704PWA_01","Vic fire advised of pole fire at the incident location. \nUpon arrival the crew found that an IPC had burnt.\nThere was no reportable ground fire. ",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,{"$f":"IF(Q76=\"\",\"\",IF(Q76=\"No forecast\",0.1,IF(Q76=\"Low-moderate\",0.2,IF(Q76=\"High\",0.5,IF(Q76=\"Very high\",1,IF(Q76=\"Severe\",2,IF(Q76=\"Extreme\",3.5,5)))))))","v":""},"",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,"","",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,{"$f":"IF(Q140=\"\",\"\",IF(Q140=\"No forecast\",0.1,IF(Q140=\"Low-moderate\",0.2,IF(Q140=\"High\",0.5,IF(Q140=\"Very high\",1,IF(Q140=\"Severe\",2,IF(Q140=\"Extreme\",3.5,5)))))))","v":""},"",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,"",""]
[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(Q191=\"\",\"\",IF(Q191=\"No forecast\",0.1,IF(Q191=\"Low-moderate\",0.2,IF(Q191=\"High\",0.5,IF(Q191=\"Very high\",1,IF(Q191=\"Severe\",2,IF(Q191=\"Extreme\",3.5,5)))))))","v":""},{"$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,"",""]
[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(Q234=\"\",\"\",IF(Q234=\"No forecast\",0.1,IF(Q234=\"Low-moderate\",0.2,IF(Q234=\"High\",0.5,IF(Q234=\"Very high\",1,IF(Q234=\"Severe\",2,IF(Q234=\"Extreme\",3.5,5)))))))","v":""},{"$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(Q235=\"\",\"\",IF(Q235=\"No forecast\",0.1,IF(Q235=\"Low-moderate\",0.2,IF(Q235=\"High\",0.5,IF(Q235=\"Very high\",1,IF(Q235=\"Severe\",2,IF(Q235=\"Extreme\",3.5,5)))))))","v":""},{"$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":"2021/22"}]
[]
[]
[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."]