{"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":1,"external_links":2,"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":12,"n_cols":6,"rows_kept":12,"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"]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":7,"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,"Jemena"]
[]
[null,"DNSP - trading name:",null,"Jemena Electricity Networks (Vic) Ltd"]
[]
[null,"DNSP - Australian business number: ",null,"82 064 651 083"]
[]
[null,"Reporting year:",null,"2018/19"]
[]
[]
[]
[]
[null,"Business address","Address",null,"Level 16, 567 Collins Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",3000]
[]
[null,"Postal address","Address",null,"PO Box 16182"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",3000]
[]
[]
[null,"Contact name/s","Matthew Serpell"]
[null,"Contact phone/s","(03) 9173 7000"]
[null,"Contact email address/s","matthew.serpell@jemena.com.au"]

{"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":"Jemena"},"IRU target:",{"$f":"IF(SUM(K6:O6)=0,\"\",SUM(K6:O6))","v":9.6999999999999993},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:S190)=0,\"\",SUM('2. Individual fire start info'!S38:S190))","v":1.9400000000000002},null,null,null,null,null,"2016/17",247.7,3.4,9.6999999999999993,468,22.3]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2018/19"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":116399.99999999999},null,null,null,null,null,"2017/18",247.7,3.4,9.6999999999999993,468,22.3]
[null,null,null,null,null,null,null,null,null,"2018/19",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,"2019/20",221.1,3.4,9.6999999999999993,412.8,22.3]
[null,"This is a summary of data in worksheet \"2. Fire Start Report\"",null,null,null,null,null,null,null,null,{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>K1),\"\",LOOKUP($B3,$J2:$J5,K2:K5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>L1),\"\",LOOKUP($B3,$J2:$J5,L2:L5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>M1),\"\",LOOKUP($B3,$J2:$J5,M2:M5))","v":9.6999999999999993},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>N1),\"\",LOOKUP($B3,$J2:$J5,N2:N5))","v":""},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>O1),\"\",LOOKUP($B3,$J2:$J5,O2:O5))","v":""}]
[null,"Kind of Fire Start by definition of fire start under clause 5 of F-factor Order","Total fires by cause"]
[null,"Started in or originated from a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$818,'1. F-Factor summary'!$B8)","v":13}]
[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$818,'1. F-Factor summary'!$B9)","v":2}]
[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$818,'1. F-Factor summary'!$B10)","v":2}]
[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$818,'1. F-Factor summary'!$B11)","v":1}]
[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$818,'1. F-Factor summary'!$B12)","v":1}]
[null,"Otherwise started by a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$818,'1. F-Factor summary'!$B13)","v":0}]
[null,"Total",{"$f":"SUM(C8:C13)","v":19}]

{"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":"Jemena"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2018/19"}]
[]
[]
[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 Jemena. 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":"Jemena 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 Jemena 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) Jemena'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,"2018-08-18","15:49:28",-37.778078999999998,144.860445,"31 LACY STREET BRAYBROOK","A127303 ","BY15","22kV 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",{"$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},168375,"20180905JEM_01","Small branch, from a council responsible tree, broke during high winds and failed onto 2 phasaes of HV conductor",null,null,"Overhead conductors"]
[17,2,"2018-09-01","01:25:00","-37.85797","144.902069","10 THE STRAND WILLIAMSTOWN","A024432","NT04","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,168981,"20180907JEM_01","Public lighting lantern fire",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2018-09-05","01:05:00","-37.7503","145.016083","35 VICTORIA STREET PRESTON","A078208","EP37","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,169116,"20181009JEM_01","Public lighting lantern fire",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2018-09-11","15:18:00",-37.796278000000001,144.931727,"167 EASTWOOD STREET KENSINGTON","A030298","WMTSFT1","66kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,"PM10285287","20190819JEM_01","Pole top fire",null,null," - overhead conductor (bare; copper)"]
[17,5,"2018-11-07","19:51:00",-37.741109999999999,144.96367699999999,"135A BELL STREET COBURG","A111280  ","CS03","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"PM10286835","20190819JEM_02","Public lighting lantern fire",null,null," - overhead conductor (bare; steel)"]
[17,6,"2018-12-06","17:45:15",-37.783271999999997,144.927772,"2 DOVER STREET FLEMINGTON","A028095","FT11","11kV AC","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,0.1,173522,"20181206JEM_01","Fire at pole top due to cable termintaion failure",null,null," - overhead conductor (ABC)"]
[17,7,"2018-12-25","05:32:45",-37.712432999999997,145.02276800000001,"144 BOLDREWOOD PARADE RESERVOIR","A034511","TT0-011","Low voltage AC (<1kV)","Urban"," - luminaires (major road)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"PM10288106","20190819JEM_03","Public lighting lantern fire",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2019-01-25","17:03:51",-37.779494999999997,144.878501,"60 EMU ROAD MAIDSTONE","A151624","BY14","22kV AC","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Severe",2,0.4,175477,"20190126JEM_01","Small grass fire ",null,null," - overhead conductor (insulated)"]
[17,9,"2019-02-07","00:37:15",-37.743946999999999,145.035572,"207 LIBERTY PARADE, HEIDELBERG WEST","A039071","TTSEP","66kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,"PM10289147","20190819JEM_04","Pole top fire",null,null,"Service lines"]
[17,10,"2019-02-07","22:01:35",-37.589086000000002,144.742806,"108 BROOK ST SUNBURY","A005293","KTSSBY","66kV AC","Rural Short"," - connector / termination","three phase","Started by lightning striking a distribution system or a part of a distribution system ","HBRA only",1,"Low-moderate",0.2,0.2,176116,"20190207JEM_05","Small grass fire due to lighting strike",null,null," - overhead service conductor (residential)"]
[17,11,"2019-03-06","17:46:55",-37.818832999999998,144.85952700000001,"1 HARDIE ROAD YARRAVILLE","A030064","FW13","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"High",0.5,0.1,177682,"20190403JEM_01","Pole top fire",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2019-03-19","19:55:00",-37.648307799999998,144.94232199999999,"25 FODEN AVENUE CAMPBELLFIELD","A080873","ST12","22kV AC","Urban"," - overhead conductor (bare; all aluminium conductor)","three phase","Started by any other thing forming part of or coming into contact with a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,178234,"20190319JEM_01","Small grass fire due to vehicle impact",null,null," - overhead service conductor (subdivision / construction)"]
[17,13,"2019-03-25","14:58:23",-37.658242999999999,144.970585,"65 METROLINK CIRCUIT CAMPBELLFIELD","A090085","ST13","Low voltage AC (<1kV)","Urban"," - underground service cable (commercial / industrial)","three phase","Started by any person, bird, reptile or other animal coming into contact with a distribution system","LBRA only",0.2,"Very high",1,0.2,"PM10290642","20190325JEM_05","Small grass fire due to vadalism (copper theft)",null,null," - overhead service conductor (other)"]
[17,14,"2019-03-29","15:53:48",-37.673895999999999,144.898562,"1 SHIRRA PLACE ATTWOOD","A040004","BD07","22kV 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,"Very high",1,0.2,"PM10290870","20190330JEM_01","A branch, from a Jemena responsible tree, broke during high winds and failed onto HV resulting in failed burnt through conductor and a consequent minor grass fire.",null,null," - underground service cable (residential)"]
[17,15,"2019-03-29","21:30:00",-37.803959999999996,144.86992499999999,"3A INDWE ST WEST FOOTSCRAY","A052410 ","TH11","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Very high",1,0.2,178847,"20190402JEM_01","Pole top fire",null,null," - underground service cable (commercial / industrial)"]
[17,16,"2019-04-10","04:14:07",-37.770496999999999,145.055182,"34 YORK AVENUE IVANHOE EAST","A016819","HB14","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,179232,"20190410JEM_01","Small grass fire due to LV fused switch failure",null,null," - underground service cable (subdivision / construction)"]
[17,17,"2019-04-10","13:04:10",-37.835414999999998,144.886527,"91-119 CRAIG STREET SPOTSWOOD","A059706","NT16","22kV AC","Urban"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,{"$f":"IF(OR(P54=\"\",R54=\"\"),\"\",IF(AND(O54=\"within electric line construction area\",Q54=\"No forecast\"),1,P54*R54))","v":4.0000000000000008E-2},179262,"20190411JEM_01","Pole top fire",null,null," - underground service cable (other)"]
[17,18,"2019-04-16","09:19:00",-37.595049000000003,144.921064,"1 WATFORD CRESCENT CRAIGIEBURN","A026749","ST33","22kV AC","Urban"," - dropper / bridge","three phase","Started by any person, bird, reptile or other animal coming into contact with a distribution system","LBRA only",0.2,"Very high",1,0.2,179498,"20190416JEM_01","Small grass fire due to bird strike",null,null,"Underground cables"]
[17,19,"2019-06-25","19:13:47",-37.751562999999997,144.97851,"129 RENNIE STREET COBURG","A073199","CS09","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"No forecast",0.1,2.0000000000000004E-2,182256,"20190625JEM_01","LV fused switch burnt out",null,null," - underground cable"]
[0,20,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - underground communications cable"]
[0,21,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,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,{"$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":"Jemena"}]
[null,"F-factor data reporting"]
[null,{"$f":"IF(Cover!D33=\"\",\"[Year]\",Cover!D33)","v":"2018/19"}]
[]
[]
[null,"Instructions:"]
[]
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name] must provide:\", CONCATENATE(Cover!D27,\" must provide:\"))","v":"Jemena 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","SAP Plant Maintenance Module","Yes","None"]
[null,"System 2","Outage Management System (OMS/CMOS)","Yes","Jemena, JEN PR 0502, \"JEN AER Network Reliability Reporting Procedure\""]
[null,"System 3 ","ESV Fault Reporting Register (OSIRIS)","Yes","Energy Safe Victoria, \"Electrical Incident and Safety Performance Reporting Guidelines\""]
[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."]