{"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":[[10,1,11,8],[13,1,13,8],[42,2,42,3],[42,4,42,7],[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[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,"2017/18"]
[]
[]
[]
[]
[null,"Business address","Address",null,"40 Market Street"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",3000]
[]
[null,"Postal address","Address",null,"Locked Bag 14090"]
[null,null,"Suburb",null,"Melbourne"]
[null,null,null,"State","Victoria","Postcode",8001]
[]
[]
[null,"Contact name/s","Mark de Villiers"]
[null,"Contact phone/s",396834907]
[null,"Contact email address/s","mdevilliers@powercor.com.au"]

{"sheet":"1. F-Factor summary","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,5,2],[3,6,3,8],[4,6,4,8],[5,6,5,8],[11,2,11,3],[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]]}
[null,{"$f":"IF(Cover!D27=\"\",\"[DNSP Name]\", Cover!D27)","v":"CitiPower"},"IRU target:",{"$f":"IF(SUM(K6:O6)=0,\"\",SUM(K6:O6))","v":3.4},null,null,null,null,null,null,"AusNet Services","CitiPower","Jemena","Powercor","United Energy"]
[null,"F-factor data reporting","IRU amount:",{"$f":"IF(SUM('2. Individual fire start info'!S38:S2000)=0,\"\",SUM('2. Individual fire start info'!S38:S2000))","v":0.9800000000000002},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":"2017/18"},"Revenue adjustment:",{"$f":"IF(OR(D1=\"\",D2=\"\"),\"\",15000*(D1-D2))","v":36300},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":3.4},{"$f":"IF(OR($B3=\"[Year]\",$B1=\"[DNSP Name]\",$B1<>M1),\"\",LOOKUP($B3,$J2:$J5,M2:M5))","v":""},{"$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$2000,'1. F-Factor summary'!$B8)","v":11}]
[null,"Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system",{"$f":"COUNTIF('2. Individual fire start info'!$N$38:$N$2000,'1. F-Factor summary'!$B9)","v":1}]
[null,"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":12}]

{"sheet":"2. Individual fire start info","index":3,"n_rows":317,"n_cols":25,"rows_kept":317,"cut":false,"hidden":false,"merged":[[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],[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],[3,22,3,24],[4,22,4,24],[5,22,5,24],[7,1,7,21],[11,1,11,2],[9,1,9,21]]}
[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":"2017/18"}]
[]
[]
[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,"2017-07-27","07:10:00","-37.79215818","145.00015339","18 Kiewa St., Clifton Hill.","30169158","F029","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","three 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},13259,"20170728PWA_01","A passer-by reported that the pole is on fire at the incident location. On arrival the fault crew found that a krone box had overheated caught fire and debris had fallen onto the footpath  at the incident location. The krone box fire self-extinguished.",null,null,"Overhead conductors"]
[17,2,"2017-07-14","13:42:00","-37.82894203","144.92291095","115 Salmon St., Port Melbourne.","30218476","PM004","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,13268,"20170731PWA_03","MFB reported a fire on building wall at the incident location. Upon arrival, the CitiPower crew found that the 3Ph meter board caught fire. The crew believe overheated connections/fuses ignited the box. There were no injuries, third party damages or ground fire. The repairs arranged.  MFB attended.",null,null," - overhead conductor (bare; aluminium core steel reinforced)"]
[17,3,"2017-08-06","23:44:00","-37.79809268","144.97472982","1 Barkly St., Carlton.","30180584","BQ041","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,13290,"20170807PWA_01","MFB reported a street light pole on fire at the above incident location. On arrival, the crew found that MFB had extinguish the fire out of a Public Lighting head unit as it had faulted and caught on fire. There was no ground fire nor third party damaged. There were no reported injuries.",null,null," - overhead conductor (bare; all aluminium conductor)"]
[17,4,"2017-08-04","06:32:00","-37.85700177","145.02074312","3A Hume St., Armadale.","30166655","AR011","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,13323,"20170817PWA_02","MFB reports a pole fire at the above address. A crew attended and found a PE cell in a 80 MV public light had over heated and caught fire. MFB where onsite and extinguished fire. Crew replaced PE cell. Lantern still serviceable. No ground fire start.  There were no reported shocks, injuries or 3rd party damage.",null,null," - overhead conductor (bare; copper)"]
[17,5,"2017-11-09","03:08:00","-37.83048","144.992233","131 Cubitt St., Cremorne.","30187885","R031","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,13523,"20171207PWA_02","MFB reported a garage fire at incident location. On arrival it was found that  the fire affected customer’s garage. The fire appears to have started at the meter board position. There was a small ground fire (3x2 m). On arrival supply isolated. Repairs where to be co-ordinated with customer REC for the customer to resume supply. There were no injuries reported.",null,null," - overhead conductor (bare; steel)"]
[17,6,"2017-12-28","13:12:00","-37.84368992","144.99064922","58A Osborne St., South Yarra.",30217304,"BC024","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,13554,"20180103PWA_02","The MFB notified the CitiPower report room of a pole box fire . Upon attendance the CitiPower faults crew found the FOLCB supplying customers at 58A, 58B, 51 and 53 Osborne St, South Yarra had been damaged",null,null," - overhead conductor (ABC)"]
[17,7,"2017-12-26","20:43:00","-37.78554194","145.08690298","430 Balwyn road, Balwyn North.","30186091","WD021","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,13557,"20180102PWA_07","MFB reported a pole fire at the above incident location. On arrival, the crew found that the overhead line fuse box unit had overheated and caught on fire.",null,null," - overhead conductor (covered uninsulated)"]
[17,8,"2017-12-03","22:07:00","-37.77266954","144.99825060","257 High St., Northcote.","30190763","NC005","Low voltage AC (<1kV)","Urban"," - luminaires (minor road)","single phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,13588,"20180115PWA_04","Street light fire outside 257 High st Northcote. There was no ground fire, no reported injuries and no third party property damage.",null,null," - overhead conductor (insulated)"]
[17,9,"2018-01-19","02:00:00","-37.83218392","145.00637820","159 Alexandra Ave., Toorak.","30216322","TK001","Low voltage AC (<1kV)","Urban"," - fuse (any other type)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Severe",2,0.4,13606,"20180119PWA_04","The MFB reported a  pole fire at the incident location. On arrival the fault crew found that a FMJB had overheated burning material fell to the ground igniting a small grass fire at the base of the pole , fire self-extinguished. There was no injury as a result of this incident.",null,null,"Service lines"]
[17,10,"2018-03-24","11:12:00","-37.80961","145.099258","9 FITZGERALD STREET, BALWYN.","30176449","WD032","Low voltage AC (<1kV)","Urban"," - overhead service conductor (residential)","two phase","Started by any tree, or part of a tree, falling upon or coming into contact with a distribution system","LBRA only",0.2,"High",0.5,0.1,13913,"20180327PWA_03","Vicfire reported a small grass fire in the front yard of 9 Fitzgerald Street, Balwyn. On Arrival the CitiPower crew found a private tree within the yard of 9 Fitzgerald St, Balwyn had bought down the overhead service to the property. The crew found the insulation of the service wire had been damage by the tree and a 15m2 charring mark was found on the grass. There was no reported injuries, no third party damage, no shocks.",null,null," - overhead service conductor (residential)"]
[17,11,"2018-03-19","16:45:00","-37.84241276","144.95008367","229 BRIDPORT STREET W, ALBERT PARK.","30173056","AP003","11kV AC","Urban"," - connector / termination","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Very high",1,0.2,13923,"20180328PWA_05","A customer reported that there is a grass fire adjacent the incident location. On arrival the fault crew found that fault current had caused overheating of a high voltage connection which ejected hot debris onto the ground igniting a small grass fire approximately 3m by 2m in area. The fire self-extinguished. There was no injury as a result of this incident.",null,null," - overhead service conductor (commercial / industrial)"]
[17,12,"2018-04-17","00:03:00","-37.82184765","144.96572042","70 City Rd., Southbank.","30160563","SO022","Low voltage AC (<1kV)","CBD"," - crossarm (wood)","three phase","Started in or originated from a distribution system","LBRA only",0.2,"Low-moderate",0.2,4.0000000000000008E-2,14063,"20180517PWA_03","MFB reported pole fire at incident location. There was no ground fire, no reported injuries or third property damages.",null,null," - overhead service conductor (subdivision / construction)"]
[0,13,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - overhead service conductor (other)"]
[0,14,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - underground service cable (residential)"]
[0,15,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - underground service cable (commercial / industrial)"]
[0,16,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null," - underground service cable (subdivision / construction)"]
[0,17,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(OR(P54=\"\",R54=\"\"),\"\",IF(AND(O54=\"within electric line construction area\",Q54=\"No forecast\"),1,P54*R54))","v":""},null,null,null,null,null," - underground service cable (other)"]
[0,18,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,null,null,"Underground cables"]
[0,19,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",null,null,null,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,"",""]
[{"$f":"COUNTA(C238:O238,Q238,T238:V238)","v":0},201,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O238=\"\",\"\",IF(O238=\"LBRA only\",0.2,IF(O238=\"HBRA only\",1,IF(O238=\"within electric line construction area\",19.8,IF(O238=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,{"$f":"IF(Q238=\"\",\"\",IF(Q238=\"No forecast\",0.1,IF(Q238=\"Low-moderate\",0.2,IF(Q238=\"High\",0.5,IF(Q238=\"Very high\",1,IF(Q238=\"Severe\",2,IF(Q238=\"Extreme\",3.5,5)))))))","v":""},{"$f":"IF(OR(P238=\"\",R238=\"\"),\"\",IF(AND(O238=\"within electric line construction area\",Q238=\"No forecast\"),1,P238*R238))","v":""}]
[{"$f":"COUNTA(C239:O239,Q239,T239:V239)","v":0},202,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O239=\"\",\"\",IF(O239=\"LBRA only\",0.2,IF(O239=\"HBRA only\",1,IF(O239=\"within electric line construction area\",19.8,IF(O239=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,{"$f":"IF(Q239=\"\",\"\",IF(Q239=\"No forecast\",0.1,IF(Q239=\"Low-moderate\",0.2,IF(Q239=\"High\",0.5,IF(Q239=\"Very high\",1,IF(Q239=\"Severe\",2,IF(Q239=\"Extreme\",3.5,5)))))))","v":""},{"$f":"IF(OR(P239=\"\",R239=\"\"),\"\",IF(AND(O239=\"within electric line construction area\",Q239=\"No forecast\"),1,P239*R239))","v":""}]
[0,203,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,204,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,205,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,206,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,207,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,208,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,209,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,210,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,211,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,212,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,213,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,214,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,215,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,216,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,217,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,218,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,219,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,220,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,221,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,222,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,223,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,224,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,225,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,226,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,227,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,228,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,229,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,230,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,231,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,232,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,233,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,234,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,235,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,236,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,237,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,238,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,239,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,240,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,241,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,242,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,243,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,244,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,245,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,246,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,247,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,248,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,249,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,250,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,251,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,252,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,253,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,254,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,255,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,256,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,257,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,258,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,259,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,260,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,261,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,262,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,263,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,264,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,265,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[{"$f":"COUNTA(C303:O303,Q303,T303:V303)","v":0},266,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O303=\"\",\"\",IF(O303=\"LBRA only\",0.2,IF(O303=\"HBRA only\",1,IF(O303=\"within electric line construction area\",19.8,IF(O303=\"within area delineated on plan LEGL./16-354\",4.6,\"\")))))","v":""},null,{"$f":"IF(Q303=\"\",\"\",IF(Q303=\"No forecast\",0.1,IF(Q303=\"Low-moderate\",0.2,IF(Q303=\"High\",0.5,IF(Q303=\"Very high\",1,IF(Q303=\"Severe\",2,IF(Q303=\"Extreme\",3.5,5)))))))","v":""},{"$f":"IF(OR(P303=\"\",R303=\"\"),\"\",IF(AND(O303=\"within electric line construction area\",Q303=\"No forecast\"),1,P303*R303))","v":""}]
[0,267,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,268,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,269,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,270,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,271,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,272,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,273,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,274,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,275,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,276,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,277,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,278,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,279,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[0,280,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":"2017/18"}]
[]
[]
[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."]