{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RCA Results Table","ONRC Category Results","Region & Peer Group Results","Lookups","Charts","Chart Data"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"RCA Results Table","index":0,"n_rows":73,"n_cols":20,"rows_kept":73,"cut":false,"hidden":false,"merged":[[2,1,2,11],[2,12,2,19],[3,1,3,3],[3,4,3,11],[3,12,3,14],[3,15,3,18]]}
[null,"DATA QUALITY RESULTS 2017/18 | PERCENTAGE AT THE EXPECTED STANDARD"]
[]
[null,"ONRC",null,null,null,null,null,null,null,null,null,null,"Asset Management"]
[null,"Quality Dimension",null,null,"Data Sub-Category",null,null,null,null,null,null,null,"Quality Dimension",null,null,"Data Category",null,null,null,"Score"]
["RCA Name","Accuracy","Complete-ness","Timeliness","Carriageway","Treatment Length","Surfacing","Maintenance Activity","Roughness","Traffic Count","Traffic Estimates","Crash","Accuracy","Complete-ness","Timeliness","Network","Asset Inventory","Condition","Maintenance Activity","AM Score"]
["Ashburton District Council",87.5,70,16.666666666666664,87.5,25,75,100,100,33.333333333333336,91.666666666666657,50,60,50,66.666666666666671,100,42.857142857142861,100,75,75]
["Auckland Transport",83.333333333333343,40,49.999999999999993,100,50,25,66.666666666666671,50,66.666666666666671,75,0,40,50,77.777777777777786,50,57.142857142857146,50,50,63]
["Buller District Council",33.333333333333336,50,25,50,50,0,0,100,0,100,0,20,25,11.111111111111111,0,19.047619047619047,100,0,40]
["Carterton District Council",70.833333333333343,70,12.5,87.5,50,25,100,100,33.333333333333336,62.5,50,50,25,66.666666666666671,75,38.095238095238095,50,50,56]
["Central Hawke's Bay District Council",66.666666666666671,60,33.333333333333329,100,25,25,66.666666666666671,100,100,58.333333333333321,0,40,41.666666666666671,44.444444444444443,25,33.333333333333336,100,75,56]
["Central Otago District Council",62.5,70,33.333333333333329,100,37.5,0,66.666666666666671,100,100,33.333333333333329,50,0,66.666666666666671,50,25,45,0,50,62]
["Chatham Islands Council",54.166666666666671,50,50,87.5,0,25,33.333333333333336,100,66.666666666666671,75,0,30,33.333333333333336,62.5,50,45,0,25,55]
["Christchurch City Council",66.666666666666671,40,25,75,25,25,66.666666666666671,100,0,100,0,40,33.333333333333336,55.555555555555557,50,42.857142857142861,50,25,57]
["Clutha District Council",70.833333333333343,60,75,87.5,50,25,66.666666666666671,100,100,75,50,50,58.333333333333336,33.333333333333336,75,33.333333333333336,100,75,61]
["DOC Roads",25,50,25,50,25,0,0,100,0,75,50,20,0,57.142857142857139,25,26.315789473684209,0,0,34]
["Dunedin City Council",100,90,25,100,50,100,100,100,66.666666666666671,100,50,50,66.666666666666671,66.666666666666671,100,47.61904761904762,100,75,72]
["Far North District Council",79.166666666666671,50,41.666666666666664,75,37.5,50,66.666666666666671,100,66.666666666666671,41.666666666666664,50,20,50,66.666666666666671,50,47.61904761904762,0,50,60]
["Gisborne District Council",66.666666666666671,50,8.3333333333333321,100,0,25,100,100,0,58.333333333333321,50,30,50,33.333333333333336,25,42.857142857142861,0,50,54]
["Gore District Council",62.5,40,12.5,100,12.5,25,33.333333333333336,50,0,62.5,50,50,33.333333333333336,12.5,50,20,50,75,51]
["Grey District Council",41.666666666666671,20,0,87.5,12.5,0,0,100,0,0,50,40,8.3333333333333339,0,0,19.047619047619047,50,0,36]
["Hamilton City Council",83.333333333333343,60,25,100,50,75,100,50,0,100,0,40,75,83.333333333333343,25,73.80952380952381,50,75,74]
["Hastings District Council",75,50,25,100,0,50,100,50,66.666666666666671,50,50,60,50,55.555555555555557,50,52.38095238095238,50,75,68]
["Hauraki District Council",75,90,58.333333333333336,100,100,50,100,100,66.666666666666671,58.333333333333321,50,60,83.333333333333343,55.555555555555557,25,76.19047619047619,50,75,80]
["Horowhenua District Council",62.5,50,8.3333333333333321,75,37.5,0,66.666666666666671,50,66.666666666666671,58.333333333333321,50,20,50,44.444444444444443,50,38.095238095238095,0,50,53]
["Hurunui District Council",70.833333333333343,60,25,100,37.5,0,66.666666666666671,100,33.333333333333336,100,50,50,33.333333333333336,66.666666666666671,50,47.61904761904762,100,25,57]
["Hutt City Council",75,40,16.666666666666664,100,25,25,33.333333333333336,100,0,91.666666666666657,0,30,33.333333333333336,22.222222222222221,25,23.80952380952381,50,50,52]
["Invercargill City Council",91.666666666666671,50,16.666666666666664,100,75,25,66.666666666666671,100,33.333333333333336,66.666666666666657,50,30,83.333333333333343,22.222222222222221,75,38.095238095238095,100,50,62]
["Kaikoura District Council",50,40,25,50,25,25,0,100,66.666666666666671,50,50,30,8.3333333333333339,28.571428571428569,25,26.315789473684209,0,0,42]
["Kaipara District Council",66.666666666666671,40,25,62.5,37.5,0,100,100,0,75,50,40,58.333333333333336,66.666666666666671,25,61.904761904761905,0,75,60]
["Kapiti Coast District Council",100,70,50,100,100,50,100,100,100,50,50,50,75,66.666666666666671,25,71.428571428571431,100,50,72]
["Kawerau District Council",58.333333333333336,50,12.5,100,75,0,0,50,0,87.5,50,40,8.3333333333333339,0,75,9.5238095238095237,0,0,34]
["MacKenzie District Council",70.833333333333343,70,25,62.5,50,75,66.666666666666671,100,33.333333333333336,50,50,20,33.333333333333336,33.333333333333336,25,28.571428571428573,0,50,57]
["Manawatu District Council",50,50,25,75,25,0,66.666666666666671,50,66.666666666666671,25,50,30,25,55.555555555555557,25,38.095238095238095,0,50,47]
["Marlborough District Council",79.166666666666671,60,41.666666666666664,100,37.5,50,66.666666666666671,100,66.666666666666671,66.666666666666657,50,20,58.333333333333336,33.333333333333336,25,33.333333333333336,100,50,50]
["Masterton District Council",58.333333333333336,70,0,100,25,25,66.666666666666671,100,33.333333333333336,50,0,40,41.666666666666671,44.444444444444443,75,33.333333333333336,100,25,58]
["Matamata-Piako District Council",70.833333333333343,100,75.000000000000014,87.5,75,50,100,100,100,100,50,40,50,50,50,40.476190476190474,50,75,67]
["Napier City Council",66.666666666666671,70,49.999999999999993,75,25,75,100,100,66.666666666666671,75,0,40,58.333333333333336,72.222222222222229,25,54.761904761904766,100,75,62]
["Nelson City Council",37.5,40,25,50,12.5,0,66.666666666666671,100,66.666666666666671,50,0,20,41.666666666666671,55.555555555555557,25,42.857142857142861,0,50,51]
["New Plymouth District Council",70.833333333333343,60,25,75,37.5,25,100,100,100,25,50,60,25,11.111111111111111,50,23.80952380952381,50,50,50]
["Opotiki District Council",79.166666666666671,60,50,100,87.5,50,66.666666666666671,100,66.666666666666671,25,0,40,66.666666666666671,33.333333333333336,50,42.857142857142861,100,50,59]
["Otorohanga District Council",83.333333333333343,100,62.5,87.5,87.5,100,66.666666666666671,100,100,62.5,50,60,58.333333333333336,44.444444444444443,75,47.61904761904762,50,75,72]
["Palmerston North City Council",25,40,0,87.5,12.5,0,33.333333333333336,50,33.333333333333336,25,0,20,58.333333333333336,11.111111111111111,25,23.80952380952381,100,50,48]
["Porirua City Council",83.333333333333343,60,25,100,25,50,100,100,33.333333333333336,100,0,30,41.666666666666671,33.333333333333336,0,28.571428571428573,100,75,53]
["Queenstown-Lakes District Council",50,40,25,37.5,12.5,25,100,100,33.333333333333336,50,0,30,58.333333333333336,62.5,25,55,0,75,62]
["Rangitikei District Council",75,60,25,87.5,87.5,50,100,100,33.333333333333336,25,0,20,41.666666666666671,33.333333333333336,25,28.571428571428573,0,75,44]
["Rotorua Lakes Council",83.333333333333343,40,25,87.5,62.5,50,66.666666666666671,50,33.333333333333336,25,50,60,50,44.444444444444443,75,42.857142857142861,100,50,63]
["Ruapehu District Council",75,60,25,75,50,25,66.666666666666671,100,0,100,50,50,41.666666666666671,11.111111111111111,50,23.80952380952381,100,50,57]
["Selwyn District Council",66.666666666666671,90,49.999999999999993,100,25,25,100,100,100,100,50,80,75,27.777777777777779,100,50,100,75,79]
["South Taranaki District Council",79.166666666666671,80,25,75,62.5,75,100,100,33.333333333333336,75,50,40,58.333333333333336,44.444444444444443,25,52.38095238095238,100,25,68]
["South Waikato District Council",50,60,75,50,100,25,33.333333333333336,50,100,75,50,40,58.333333333333336,22.222222222222221,25,38.095238095238095,50,75,56]
["South Wairarapa District Council",70.833333333333343,50,25,100,62.5,25,100,100,33.333333333333336,0,50,40,50,44.444444444444443,75,33.333333333333336,100,50,60]
["Southland District Council",75,80,25,87.5,37.5,50,66.666666666666671,100,33.333333333333336,100,50,60,75,33.333333333333336,100,47.61904761904762,100,50,73]
["Stratford District Council",33.333333333333336,30,25,75,0,0,0,100,66.666666666666671,0,50,30,41.666666666666671,22.222222222222221,25,38.095238095238095,50,0,44]
["Tararua District Council",54.166666666666671,50,25,87.5,75,0,0,100,33.333333333333336,50,50,50,16.666666666666668,33.333333333333336,100,28.571428571428573,0,0,49]
["Tasman District Council",62.5,80,50,100,62.5,0,66.666666666666671,100,100,50,50,40,41.666666666666671,50,50,30,100,75,61]
["Taupo District Council",54.166666666666671,60,25,100,12.5,50,66.666666666666671,50,100,0,50,40,58.333333333333336,55.555555555555557,75,42.857142857142861,50,75,65]
["Tauranga City Council",58.333333333333336,50,16.666666666666664,100,50,25,66.666666666666671,100,0,66.666666666666657,0,30,66.666666666666671,77.777777777777786,0,66.666666666666671,50,75,61]
["Thames-Coromandel District Council",62.5,40,37.5,87.5,75,25,0,100,0,62.5,50,40,33.333333333333336,44.444444444444443,0,52.38095238095238,50,0,50]
["Timaru District Council",87.5,100,49.999999999999993,87.5,75,75,100,100,100,100,50,50,66.666666666666671,55.555555555555557,50,57.142857142857146,100,50,72]
["Upper Hutt City Council",70.833333333333343,60,50,87.5,75,25,66.666666666666671,100,66.666666666666671,25,50,30,50,62.5,25,55,50,25,56]
["Waikato District Council",75,40,49.999999999999993,75,50,50,66.666666666666671,100,33.333333333333336,49.999999999999993,50,30,66.666666666666671,77.777777777777786,0,66.666666666666671,100,50,59]
["Waimakariri District Council",58.333333333333336,70,41.666666666666664,75,0,25,100,100,100,66.666666666666657,50,20,50,77.777777777777786,0,52.38095238095238,50,75,54]
["Waimate District Council",95.833333333333343,60,50,100,62.5,50,66.666666666666671,100,66.666666666666671,75,50,50,66.666666666666671,22.222222222222221,75,38.095238095238095,100,50,72]
["Waipa District Council",70.833333333333343,90,41.666666666666664,100,37.5,50,100,100,100,66.666666666666657,50,50,75,77.777777777777786,50,76.19047619047619,50,50,83]
["Wairoa District Council",37.5,80,62.5,100,37.5,50,66.666666666666671,50,66.666666666666671,62.5,50,50,75,44.444444444444443,75,52.38095238095238,50,75,61]
["Waitaki District Council",70.833333333333343,60,37.5,62.5,0,25,100,100,100,87.5,50,50,33.333333333333336,22.222222222222221,50,23.80952380952381,100,50,54]
["Waitomo District Council",83.333333333333343,90,50,100,100,50,66.666666666666671,100,66.666666666666671,100,50,50,33.333333333333336,33.333333333333336,25,33.333333333333336,50,75,58]
["Wellington City Council",66.666666666666671,60,16.666666666666664,100,50,25,66.666666666666671,100,33.333333333333336,66.666666666666657,50,40,41.666666666666671,44.444444444444443,25,38.095238095238095,100,50,53]
["Western Bay of Plenty District Council",58.333333333333336,80,75.000000000000014,100,25,25,100,100,100,75,50,80,91.666666666666671,77.777777777777786,25,90.476190476190482,100,100,84]
["Westland District Council",54.166666666666671,30,0,75,62.5,0,0,100,0,25,50,60,25,0,50,25,100,0,46]
["Whakatane District Council",91.666666666666671,70,49.999999999999993,100,75,50,66.666666666666671,100,33.333333333333336,100,50,50,75,77.777777777777786,25,76.19047619047619,100,50,68]
["Whanganui District Council",62.5,70,25,87.5,100,0,100,100,66.666666666666671,25,0,30,75,11.111111111111111,0,42.857142857142861,0,100,56]
["Whangarei District Council",54.166666666666671,50,49.999999999999993,87.5,25,0,100,100,0,75,50,20,58.333333333333336,55.555555555555557,50,47.61904761904762,0,50,58]

{"sheet":"ONRC Category Results","index":1,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":true,"merged":[[2,1,2,6],[3,1,3,6]]}
["REG DATA QUALITY RESULTS 2018/19 | PERCENTAGE AT THE EXPECTED STANDARD"]
[]
[null,"ONRC"]
[null,"Data Category"]
[null,"Network","Asset Inventory","Maintenance Acitivity","Condition","Demand/Use","Crash"]
["Ashburton District Council",56.25,75,100,100,66.666666666666671,50]
["Auckland Transport",75,25,66.666666666666671,50,71.428571428571416,0]
["Buller District Council",50,0,0,100,57.142857142857139,0]
["Carterton District Council",68.75,25,100,100,49.999999999999993,50]
["Central Hawke's Bay District Council",62.5,25,66.666666666666671,100,76.190476190476176,0]
["Central Otago District Council",68.75,0,66.666666666666671,100,61.904761904761898,50]
["Chatham Islands Council",43.75,25,33.333333333333336,100,71.428571428571416,0]
["Christchurch City Council",50,25,66.666666666666671,100,57.142857142857139,0]
["Clutha District Council",68.75,25,66.666666666666671,100,85.714285714285708,50]
["DOC Roads",37.5,0,0,100,42.857142857142854,50]
["Dunedin City Council",75,100,100,100,85.714285714285708,50]
["Far North District Council",56.25,50,66.666666666666671,100,52.38095238095238,50]
["Gisborne District Council",50,25,100,100,33.333333333333329,50]
["Gore District Council",56.25,25,33.333333333333336,50,35.714285714285708,50]
["Grey District Council",50,0,0,100,0,50]
["Hamilton City Council",75,75,100,50,57.142857142857139,0]
["Hastings District Council",50,50,100,50,57.142857142857139,50]
["Hauraki District Council",100,50,100,100,61.904761904761905,50]
["Horowhenua District Council",56.25,0,66.666666666666671,50,61.904761904761905,50]
["Hurunui District Council",68.75,0,66.666666666666671,100,71.428571428571416,50]
["Hutt City Council",62.5,25,33.333333333333336,100,52.380952380952372,0]
["Invercargill City Council",87.5,25,66.666666666666671,100,52.38095238095238,50]
["Kaikoura District Council",37.5,25,0,100,57.142857142857139,50]
["Kaipara District Council",50,0,100,100,42.857142857142854,50]
["Kapiti Coast District Council",100,50,100,100,71.428571428571416,50]
["Kawerau District Council",87.5,0,0,50,49.999999999999993,50]
["MacKenzie District Council",56.25,75,66.666666666666671,100,42.857142857142854,50]
["Manawatu District Council",50,0,66.666666666666671,50,42.857142857142854,50]
["Marlborough District Council",68.75,50,66.666666666666671,100,66.666666666666671,50]
["Masterton District Council",62.5,25,66.666666666666671,100,42.857142857142854,0]
["Matamata-Piako District Council",81.25,50,100,100,99.999999999999972,50]
["Napier City Council",50,75,100,100,71.428571428571416,0]
["Nelson City Council",31.25,0,66.666666666666671,100,57.142857142857139,0]
["New Plymouth District Council",56.25,25,100,100,57.142857142857139,50]
["Opotiki District Council",93.75,50,66.666666666666671,100,42.857142857142854,0]
["Otorohanga District Council",87.5,100,66.666666666666671,100,78.571428571428569,50]
["Palmerston North City Council",50,0,33.333333333333336,50,28.571428571428569,0]
["Porirua City Council",62.5,50,100,100,71.428571428571416,0]
["Queenstown-Lakes District Council",25,25,100,100,42.857142857142854,0]
["Rangitikei District Council",87.5,50,100,100,28.571428571428569,0]
["Rotorua Lakes Council",75,50,66.666666666666671,50,28.571428571428569,50]
["Ruapehu District Council",62.5,25,66.666666666666671,100,57.142857142857139,50]
["Selwyn District Council",62.5,25,100,100,99.999999999999972,50]
["South Taranaki District Council",68.75,75,100,100,57.142857142857139,50]
["South Waikato District Council",75,25,33.333333333333336,50,85.714285714285708,50]
["South Wairarapa District Council",81.25,25,100,100,14.285714285714285,50]
["Southland District Council",62.5,50,66.666666666666671,100,71.428571428571416,50]
["Stratford District Council",37.5,0,0,100,28.571428571428569,50]
["Tararua District Council",81.25,0,0,100,42.857142857142854,50]
["Tasman District Council",81.25,0,66.666666666666671,100,71.428571428571416,50]
["Taupo District Council",56.25,50,66.666666666666671,50,42.857142857142854,50]
["Tauranga City Council",75,25,66.666666666666671,100,38.095238095238088,0]
["Thames-Coromandel District Council",81.25,25,0,100,35.714285714285708,50]
["Timaru District Council",81.25,75,100,100,99.999999999999972,50]
["Upper Hutt City Council",81.25,25,66.666666666666671,100,42.857142857142854,50]
["Waikato District Council",62.5,50,66.666666666666671,100,42.857142857142861,50]
["Waimakariri District Council",37.5,25,100,100,80.952380952380935,50]
["Waimate District Council",81.25,50,66.666666666666671,100,71.428571428571416,50]
["Waipa District Council",68.75,50,100,100,80.952380952380935,50]
["Wairoa District Council",68.75,50,66.666666666666671,50,64.285714285714278,50]
["Waitaki District Council",31.25,25,100,100,92.857142857142847,50]
["Waitomo District Council",100,50,66.666666666666671,100,85.714285714285708,50]
["Wellington City Council",75,25,66.666666666666671,100,52.38095238095238,50]
["Western Bay of Plenty District Council",62.5,25,100,100,85.714285714285694,50]
["Westland District Council",68.75,0,0,100,14.285714285714285,50]
["Whakatane District Council",87.5,50,66.666666666666671,100,71.428571428571416,50]
["Whanganui District Council",93.75,0,100,100,42.857142857142854,0]
["Whangarei District Council",56.25,0,100,100,42.857142857142854,50]

{"sheet":"Region & Peer Group Results","index":2,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":true,"merged":[[32,1,32,3],[32,4,32,11],[32,12,32,14],[32,15,32,18],[32,21,32,26],[2,21,2,26],[3,21,3,26],[31,1,31,11],[31,12,31,19],[31,21,31,26],[19,1,19,11],[19,12,19,19],[20,1,20,3],[20,4,20,11],[20,12,20,14],[20,15,20,18],[2,1,2,11],[2,12,2,19],[3,1,3,3],[3,4,3,11],[3,12,3,14],[3,15,3,18],[19,21,19,26],[20,21,20,26]]}
["REG DATA QUALITY RESULTS 2017/18 | PERCENTAGE AT THE EXPECTED STANDARD (REGIONS)"]
[]
[null,"ONRC",null,null,null,null,null,null,null,null,null,null,"Asset Management",null,null,null,null,null,null,null,null,"ONRC"]
[null,"Quality Dimension",null,null,"Data Sub-Category",null,null,null,null,null,null,null,"Quality Dimension",null,null,"Data Category",null,null,null,"Score",null,"Data Category"]
["Region","Accuracy","Completeness","Timeliness","Carriageway","Treatment Length","Surfacing","Maintenance Activity","Roughness","Traffic Count","Traffic Estimates","Crash","Accuracy","Completeness","Timeliness","Network","Asset Inventory","Condition","Maintenance Activity","AM Score",null,"Network","Asset Inventory","Maintenance Acitivity","Condition","Demand/Use","Crash"]
["Bay of Plenty",68.75,58.333333333333336,38.19444444444445,95.833333333333343,64.583333333333343,33.333333333333336,61.111111111111114,83.333333333333343,38.888888888888893,63.19444444444445,33.333333333333336,50,59.722222222222221,51.851851851851848,41.666666666666671,54.761904761904759,75,54.166666666666671,null,null,80.208333333333343,33.333333333333336,61.111111111111114,83.333333333333343,52.777777777777771,33.333333333333336]
["Canterbury",71.296296296296291,66.666666666666671,34.259259259259267,81.944444444444443,37.5,41.666666666666671,74.074074074074076,100,59.259259259259252,81.481481481481495,44.444444444444443,44.444444444444443,46.296296296296291,48.734177215189874,52.777777777777779,43.048128342245988,66.666666666666671,47.222222222222221,null,null,59.722222222222221,41.666666666666671,74.074074074074076,100,71.957671957671963,44.444444444444443]
["Gisborne and Hawkes Bay",63.333333333333336,62,35.833333333333329,95,15,45,86.666666666666671,80,60,60.833333333333329,30,44.897959183673471,55,50,42.10526315789474,47.142857142857139,60,70,null,null,55,45,86.666666666666671,80,60.476190476190482,30]
["No Region",35.416666666666671,50,37.5,62.5,18.75,12.5,16.666666666666668,100,33.333333333333336,75,25,25,16.666666666666668,60,37.5,35.897435897435898,0,12.5,null,null,40.625,12.5,16.666666666666668,100,57.142857142857139,25]
["North Auckland",66.31578947368422,45,41.666666666666664,81.25,35.483870967741936,18.75,83.333333333333343,87.5,33.333333333333336,66.666666666666671,37.5,30,54.166666666666671,66.666666666666671,43.75,53.571428571428577,12.5,56.25,null,null,58.730158730158728,18.75,83.333333333333343,87.5,52.380952380952372,37.5]
["Southland and Otago",69.270833333333343,61.25,31.25,82.8125,34.375,34.375,75,93.75,58.333333333333336,71.875,43.75,40.506329113924046,59.375,37.681159420289859,64.516129032258064,38.787878787878789,68.75,62.5,null,null,58.59375,34.375,75,93.75,66.071428571428569,43.75]
["Taranaki, Manawatu and Whanganui",55.416666666666671,55,20.833333333333329,72.5,48.75,17.5,63.333333333333336,85,50,40.833333333333336,35,35,43.333333333333336,27.777777777777779,37.5,33.80952380952381,40,45,null,null,60.625,17.5,63.333333333333336,85,44.761904761904766,35]
["Top of South Island and West Coast",50.694444444444443,46.666666666666671,23.611111111111111,75,39.583333333333336,8.3333333333333339,33.333333333333336,100,38.888888888888893,48.611111111111107,33.333333333333336,33.898305084745765,33.333333333333336,25,26.086956521739129,28.225806451612904,75,29.166666666666668,null,null,57.291666666666671,8.3333333333333339,33.333333333333336,100,44.44444444444445,33.333333333333336]
["Waikato",69.583333333333343,73,50,86.25,67.5,52.5,70,85,66.666666666666671,67.5,45,45.454545454545453,59.166666666666671,54.444444444444443,35.897435897435898,54.761904761904759,55,62.5,null,null,76.875,52.5,70,85,67.142857142857153,45]
["Wellington",72.395833333333343,60,24.479166666666668,96.875,51.5625,31.25,79.166666666666671,100,41.666666666666671,55.729166666666671,31.25,40.259740259740262,44.791666666666671,47.887323943661976,44.827586206896555,40.119760479041915,81.25,46.875,null,null,74.21875,31.25,79.166666666666671,100,49.702380952380949,31.25]
[]
[]
["REG DATA QUALITY RESULTS 2017/18 | PERCENTAGE AT THE EXPECTED STANDARD (PEER GROUPS)"]
[]
[null,"ONRC",null,null,null,null,null,null,null,null,null,null,"Asset Management",null,null,null,null,null,null,null,null,"ONRC"]
[null,"Quality Dimension",null,null,"Data Sub-Category",null,null,null,null,null,null,null,"Quality Dimension",null,null,"Data Category",null,null,null,"Score",null,"Data Category"]
["Region","Accuracy","Completeness","Timeliness","Carriageway","Treatment Length","Surfacing","Maintenance Activity","Roughness","Traffic Count","Traffic Estimates","Crash","Accuracy","Completeness","Timeliness","Network","Asset Inventory","Condition","Maintenance Activity","AM Score",null,"Network","Asset Inventory","Maintenance Acitivity","Condition","Demand/Use","Crash"]
["Provincial Centres",64.043209876543202,61.851851851851848,34.722222222222221,82.870370370370367,49.074074074074069,31.481481481481481,69.135802469135797,90.740740740740733,58.02469135802469,56.944444444444443,40.74074074074074,41.947565543071164,51.851851851851848,43.907563025210088,39.047619047619044,45.462633451957295,59.259259259259252,51.851851851851848,null,null,65.972222222222214,31.481481481481481,69.135802469135797,90.740740740740733,57.407407407407405,40.74074074074074]
["Highly Urban",68.333333333333343,52,17.5,100,45,30,53.333333333333336,80,6.666666666666667,82.5,20,36.734693877551024,45,45.555555555555557,31.578947368421051,42.38095238095238,50,50,null,null,72.5,30,53.333333333333336,80,50,20]
["Rural Districts",65.650080256821823,62.307692307692307,35.096153846153847,83.653846153846146,44.927536231884062,34.615384615384613,69.230769230769226,94.230769230769226,53.846153846153847,62.980769230769226,44.230769230769226,42.801556420233467,47.756410256410255,43.073593073593074,54.455445544554458,40.239410681399633,57.692307692307693,52.88461538461538,null,null,64.337349397590359,34.615384615384613,69.230769230769226,94.230769230769226,59.065934065934066,44.230769230769226]
["Cities",65.740740740740733,52.222222222222221,32.407407407407405,84.722222222222229,34.722222222222221,30.555555555555557,74.074074074074076,88.888888888888886,51.851851851851848,62.962962962962962,16.666666666666668,33.333333333333336,54.629629629629626,50.625,33.333333333333336,46.01063829787234,72.222222222222229,50,null,null,59.722222222222221,30.555555555555557,74.074074074074076,88.888888888888886,58.20105820105821,16.666666666666668]
["No Group",25,50,25,37.5,37.5,0,0,100,0,75,50,20,0,57.142857142857139,25,26.315789473684209,0,0,null,null,37.5,0,0,100,42.857142857142854,50]
[]
[]
["REG DATA QUALITY RESULTS 2017/18 | PERCENTAGE AT THE EXPECTED STANDARD (NATIONAL)"]
[]
[null,"ONRC",null,null,null,null,null,null,null,null,null,null,"Asset Management",null,null,null,null,null,null,null,null,"ONRC"]
[null,"Quality Dimension",null,null,"Data Sub-Category",null,null,null,null,null,null,null,"Quality Dimension",null,null,"Data Category",null,null,null,"Score",null,"Data Category"]
["Region","Accuracy","Completeness","Timeliness","Carriageway","Treatment Length","Surfacing","Maintenance Activity","Roughness","Traffic Count","Traffic Estimates","Crash","Accuracy","Completeness","Timeliness","Network","Asset Inventory","Condition","Maintenance Activity","AM Score",null,"Network","Asset Inventory","Maintenance Acitivity","Condition","Demand/Use","Crash"]
["National",65.318627450980387,59.852941176470587,33.149509803921568,86.213235294117638,45.036764705882348,31.985294117647058,67.647058823529406,91.17647058823529,50.980392156862742,62.193627450980387,37.5,40.416047548291232,49.38725490196078,44.75873544093178,43.39622641509434,43.048694424841216,58.823529411764703,51.102941176470587,null,null,65.625,31.985294117647058,67.647058823529406,91.17647058823529,57.387955182072837,37.5]

{"sheet":"Lookups","index":3,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"RCA_ID","RCA_Name","old_RCA_Name","Peer Group","Region"]
["Financial Years",null,null,null,null,null,null,57,"Ashburton District Council","Ashburton District","Rural Districts","Canterbury"]
["2018/19",null,null,null,null,null,null,80,"Auckland Transport","Auckland","Cities","North Auckland"]
["2017/18",null,null,null,null,null,null,58,"Buller District Council","Buller District","Provincial Centres","Top of South Island and West Coast"]
["2016/17",null,null,null,null,null,null,23,"Carterton District Council","Carterton District","Rural Districts","Wellington"]
["2015/16",null,null,null,null,null,null,38,"Central Hawke's Bay District Council","Central Hawkes Bay District","Rural Districts","Gisborne and Hawkes Bay"]
["2014/15",null,null,null,null,null,null,59,"Central Otago District Council","Central Otago District","Rural Districts","Southland and Otago"]
[null,null,null,null,null,null,null,86,"Chatham Islands Council","Chatham Island","Rural Districts","No Region"]
["Comparison",null,null,null,null,null,null,76,"Christchurch City Council","Christchurch City","Cities","Canterbury"]
["National",null,null,null,null,null,null,60,"Clutha District Council","Clutha District","Rural Districts","Southland and Otago"]
["Regional",null,null,null,null,null,null,88,"DOC Roads","DOC Roads","No Group","No Region"]
["Peer Group",null,null,null,null,null,null,61,"Dunedin City Council","Dunedin City","Provincial Centres","Southland and Otago"]
[null,null,null,null,null,null,null,79,"Far North District Council","Far North District","Rural Districts","North Auckland"]
["Shade","Threshold (>)",null,null,null,null,null,39,"Gisborne District Council","Gisborne District","Provincial Centres","Gisborne and Hawkes Bay"]
[null,80,null,null,null,null,null,62,"Gore District Council","Gore District","Rural Districts","Southland and Otago"]
[null,70,null,null,null,null,null,63,"Grey District Council","Grey District","Provincial Centres","Top of South Island and West Coast"]
[null,50,null,null,null,null,null,11,"Hamilton City Council","Hamilton City","Highly Urban","Waikato"]
[null,null,null,null,null,null,null,40,"Hastings District Council","Hastings District","Provincial Centres","Gisborne and Hawkes Bay"]
[null,null,null,null,null,null,null,9,"Hauraki District Council","Hauraki District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,41,"Horowhenua District Council","Horowhenua District","Provincial Centres","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,64,"Hurunui District Council","Hurunui District","Rural Districts","Canterbury"]
[null,null,null,null,null,null,null,24,"Hutt City Council","Hutt City","Highly Urban","Wellington"]
[null,null,null,null,null,null,null,65,"Invercargill City Council","Invercargill City","Cities","Southland and Otago"]
[null,null,null,null,null,null,null,66,"Kaikoura District Council","Kaikoura District","Provincial Centres","Canterbury"]
[null,null,null,null,null,null,null,78,"Kaipara District Council","Kaipara District","Rural Districts","North Auckland"]
[null,null,null,null,null,null,null,25,"Kapiti Coast District Council","Kapiti Coast District","Cities","Wellington"]
[null,null,null,null,null,null,null,21,"Kawerau District Council","Kawerau District","Highly Urban","Bay of Plenty"]
[null,null,null,null,null,null,null,67,"MacKenzie District Council","MacKenzie District","Rural Districts","Canterbury"]
[null,null,null,null,null,null,null,42,"Manawatu District Council","Manawatu District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,26,"Marlborough District Council","Marlborough District","Provincial Centres","Top of South Island and West Coast"]
[null,null,null,null,null,null,null,87,"Masterton District Council","Masterton District","Provincial Centres","Wellington"]
[null,null,null,null,null,null,null,8,"Matamata-Piako District Council","Matamata-Piako District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,43,"Napier City Council","Napier City","Cities","Gisborne and Hawkes Bay"]
[null,null,null,null,null,null,null,30,"Nelson City Council","Nelson City","Cities","Top of South Island and West Coast"]
[null,null,null,null,null,null,null,44,"New Plymouth District Council","New Plymouth District","Provincial Centres","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,12,"Opotiki District Council","Opotiki District","Provincial Centres","Bay of Plenty"]
[null,null,null,null,null,null,null,17,"Otorohanga District Council","Otorohanga District","Rural Districts","Waikato"]
[null,null,null,null,null,null,null,45,"Palmerston North City Council","Palmerston North City","Cities","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,31,"Porirua City Council","Porirua City","Cities","Wellington"]
[null,null,null,null,null,null,null,68,"Queenstown-Lakes District Council","Queenstown-Lakes District","Provincial Centres","Southland and Otago"]
[null,null,null,null,null,null,null,46,"Rangitikei District Council","Rangitikei District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,20,"Rotorua Lakes Council","Rotorua Lakes","Provincial Centres","Bay of Plenty"]
[null,null,null,null,null,null,null,47,"Ruapehu District Council","Ruapehu District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,75,"Selwyn District Council","Selwyn District","Rural Districts","Canterbury"]
[null,null,null,null,null,null,null,48,"South Taranaki District Council","South Taranaki District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,10,"South Waikato District Council","South Waikato District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,32,"South Wairarapa District Council","South Wairarapa District","Rural Districts","Wellington"]
[null,null,null,null,null,null,null,69,"Southland District Council","Southland District","Rural Districts","Southland and Otago"]
[null,null,null,null,null,null,null,49,"Stratford District Council","Stratford District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,54,"Tararua District Council","Tararua District","Rural Districts","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,33,"Tasman District Council","Tasman District","Provincial Centres","Top of South Island and West Coast"]
[null,null,null,null,null,null,null,7,"Taupo District Council","Taupo District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,15,"Tauranga City Council","Tauranga City","Highly Urban","Bay of Plenty"]
[null,null,null,null,null,null,null,18,"Thames-Coromandel District Council","Thames-Coromandel District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,70,"Timaru District Council","Timaru District","Provincial Centres","Canterbury"]
[null,null,null,null,null,null,null,34,"Upper Hutt City Council","Upper Hutt City","Cities","Wellington"]
[null,null,null,null,null,null,null,22,"Waikato District Council","Waikato District","Rural Districts","Waikato"]
[null,null,null,null,null,null,null,74,"Waimakariri District Council","Waimakariri District","Provincial Centres","Canterbury"]
[null,null,null,null,null,null,null,71,"Waimate District Council","Waimate District","Rural Districts","Canterbury"]
[null,null,null,null,null,null,null,5,"Waipa District Council","Waipa District","Provincial Centres","Waikato"]
[null,null,null,null,null,null,null,55,"Wairoa District Council","Wairoa District","Rural Districts","Gisborne and Hawkes Bay"]
[null,null,null,null,null,null,null,72,"Waitaki District Council","Waitaki District","Rural Districts","Southland and Otago"]
[null,null,null,null,null,null,null,14,"Waitomo District Council","Waitomo District","Rural Districts","Waikato"]
[null,null,null,null,null,null,null,37,"Wellington City Council","Wellington City","Highly Urban","Wellington"]
[null,null,null,null,null,null,null,13,"Western Bay of Plenty District Council","Western Bay of Plenty District","Provincial Centres","Bay of Plenty"]
[null,null,null,null,null,null,null,73,"Westland District Council","Westland District","Provincial Centres","Top of South Island and West Coast"]
[null,null,null,null,null,null,null,16,"Whakatane District Council","Whakatane District","Provincial Centres","Bay of Plenty"]
[null,null,null,null,null,null,null,56,"Whanganui District Council","Whanganui District","Provincial Centres","Taranaki, Manawatu and Whanganui"]
[null,null,null,null,null,null,null,77,"Whangarei District Council","Whangarei District","Provincial Centres","North Auckland"]
[null,null,null,null,null,null,null,81,"NZTA",null,"No Group","No Region"]

{"sheet":"Charts","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["DATA QUALITY RESULTS 2017/18 | PERCENTAGE AT THE EXPECTED STANDARD"]
[]
["My RCA:","Ashburton District Council","Select RCA from drop down list"]
["Comparison","Peer Group"]
[{"$f":"B4&\":\"","v":"Peer Group:"},{"$f":"IF($B$4=Lookups!$A$10,'Chart Data'!$D$3,IF(Charts!$B$4=Lookups!$A$11,'Chart Data'!$E$3,IF(Charts!$B$4=Lookups!$A$12,'Chart Data'!$F$3,\"\")))","v":"Rural Districts"}]

{"sheet":"Chart Data","index":5,"n_rows":20,"n_cols":45,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"Financial Year","2018/19"]
[null,"Reported Grade",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RCA",null,"Comparison",null,"10%ile",null,"25%ile",null,"50%ile",null,"75%ile",null,"90%ile"]
[null,"Individual RCA",{"$f":"Charts!$B$3","v":"Ashburton District Council"},"National",{"$f":"VLOOKUP($C$3,Table22[[#All],[RCA_Name]:[Region]],4,FALSE)","v":"Canterbury"},{"$f":"VLOOKUP($C$3,Table22[[#All],[RCA_Name]:[Region]],3,FALSE)","v":"Rural Districts"},10,25,50,75,90,"Sector Weight","% of 360","Start Angle","Finish Angle","Chart Label","Theta",null,"Values",null,null,null,"Values",null,"Values",null,"Values",null,"Values",null,"Values",null,null,null,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
["ONRC","Accuracy",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,2,FALSE)/100","v":0.875},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,2,FALSE)/100","v":0.65318627450980382},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,2,FALSE)/100","v":0.71296296296296291},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,2,FALSE)/100","v":0.65650080256821819},0.51333333333333331,0.6,0.66666666666666663,0.73333333333333328,0.8666666666666667,2,{"$f":"L4/SUM($L$4:$L$19)","v":8.3333333333333329E-2},0,{"$f":"360*SUM($M$3:M4)","v":30},"Accuracy",{"$f":"(O4-N4)/2+N4","v":15},{"$f":"C4*SIN(Q4/180*PI())","v":0.22646666446470565},{"$f":"C4*COS(Q4/180*PI())","v":0.84518509800293473},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D4*SIN(Q4/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E4*SIN(Q4/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F4*SIN(Q4/180*PI()),\"\")))","v":0.16991491082974472},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D4*COS(Q4/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E4*COS(Q4/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F4*COS(Q4/180*PI()),\"\")))","v":0.63413108018014264},{"$f":"$G4*SIN($Q4/180*PI())","v":0.13286044315262729},{"$f":"$G4*COS($Q4/180*PI())","v":0.49584192416172174},{"$f":"$H4*SIN($Q4/180*PI())","v":0.15529142706151244},{"$f":"$H4*COS($Q4/180*PI())","v":0.57955549577344101},{"$f":"$I4*SIN($Q4/180*PI())","v":0.17254603006834715},{"$f":"$I4*COS($Q4/180*PI())","v":0.6439505508593788},{"$f":"$J4*SIN($Q4/180*PI())","v":0.18980063307518186},{"$f":"$J4*COS($Q4/180*PI())","v":0.7083456059453167},{"$f":"$K4*SIN($Q4/180*PI())","v":0.22430983908885133},{"$f":"$K4*COS($Q4/180*PI())","v":0.83713571611719262},null,null,32.727272727272727,{"$f":"$L4","v":2},{"$f":"$L4","v":2},2,2,2,2,2,2,2,2,2]
["ONRC","Completeness",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,3,FALSE)/100","v":0.7},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,3,FALSE)/100","v":0.59852941176470587},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,3,FALSE)/100","v":0.66666666666666674},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,3,FALSE)/100","v":0.62307692307692308},0.4,0.5,0.6,0.7,0.8,2,{"$f":"L5/SUM($L$4:$L$19)","v":8.3333333333333329E-2},{"$f":"O4","v":30},{"$f":"360*SUM($M$3:M5)","v":60},"Completeness",{"$f":"(O5-N5)/2+N5","v":45},0.49497474683058318,0.49497474683058329,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D5*SIN(Q5/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E5*SIN(Q5/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F5*SIN(Q5/180*PI()),\"\")))","v":0.44058191750854114},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D5*COS(Q5/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E5*COS(Q5/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F5*COS(Q5/180*PI()),\"\")))","v":0.4405819175085412},{"$f":"$G5*SIN($Q5/180*PI())","v":0.28284271247461901},{"$f":"$G5*COS($Q5/180*PI())","v":0.28284271247461906},{"$f":"$H5*SIN($Q5/180*PI())","v":0.35355339059327373},{"$f":"$H5*COS($Q5/180*PI())","v":0.35355339059327379},{"$f":"$I5*SIN($Q5/180*PI())","v":0.42426406871192845},{"$f":"$I5*COS($Q5/180*PI())","v":0.42426406871192851},{"$f":"$J5*SIN($Q5/180*PI())","v":0.49497474683058318},{"$f":"$J5*COS($Q5/180*PI())","v":0.49497474683058329},{"$f":"$K5*SIN($Q5/180*PI())","v":0.56568542494923801},{"$f":"$K5*COS($Q5/180*PI())","v":0.56568542494923812},null,null,65.454545454545453,{"$f":"$L5","v":2},2,2,2,2,2,2,2,2,2,2]
["ONRC","Timeliness",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,4,FALSE)/100","v":0.16666666666666663},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,4,FALSE)/100","v":0.33149509803921567},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,4,FALSE)/100","v":0.34259259259259267},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,4,FALSE)/100","v":0.35096153846153849},0.16666666666666666,0.16666666666666666,0.33333333333333331,0.5,0.66666666666666663,2,8.3333333333333329E-2,{"$f":"O5","v":60},{"$f":"360*SUM($M$3:M6)","v":90},"Timeliness",75,0.16098763771484467,4.3136507517086781E-2,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D6*SIN(Q6/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E6*SIN(Q6/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F6*SIN(Q6/180*PI()),\"\")))","v":0.33900281403414417},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D6*COS(Q6/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E6*COS(Q6/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F6*COS(Q6/180*PI()),\"\")))","v":9.0835530252327004E-2},0.1609876377148447,4.3136507517086788E-2,0.1609876377148447,4.3136507517086788E-2,0.3219752754296894,8.6273015034173575E-2,0.48296291314453416,0.12940952255126037,0.6439505508593788,0.17254603006834715,null,null,98.181818181818173,2,2,2,2,2,2,2,2,2,2,2]
["ONRC","Network",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,2,FALSE)/100","v":0.5625},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,22,FALSE)/100","v":0.65625},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,22,FALSE)/100","v":0.59722222222222221},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,22,FALSE)/100","v":0.6433734939759036},0.45454545454545453,0.54545454545454541,0.63636363636363635,0.81818181818181823,0.81818181818181823,1,4.1666666666666664E-2,90,{"$f":"360*SUM($M$3:M7)","v":105},"Network",97.5,0.55768773452276843,-7.3420983123778899E-2,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D7*SIN(Q7/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E7*SIN(Q7/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F7*SIN(Q7/180*PI()),\"\")))","v":0.63786934454652389},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D7*COS(Q7/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E7*COS(Q7/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F7*COS(Q7/180*PI()),\"\")))","v":-8.3977092343984858E-2},0.45065675516991383,-5.9330087372750626E-2,0.54078810620389661,-7.1196104847300754E-2,0.63091945723787934,-8.3062122321850881E-2,0.81118215930584503,-0.10679415727095114,0.81118215930584503,-0.10679415727095114,null,null,114.54545454545455,1,1,1,1,1,1,1,1,1,1,1]
["ONRC","Asset Inventory",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,3,FALSE)/100","v":0.75},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,23,FALSE)/100","v":0.31985294117647056},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,23,FALSE)/100","v":0.41666666666666674},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,23,FALSE)/100","v":0.34615384615384615},0,0.25,0.25,0.5,0.75,1,4.1666666666666664E-2,105,{"$f":"360*SUM($M$3:M8)","v":120.00000000000001},"Asset Inventory",112.5,0.692909649383465,-0.28701257427381732,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D8*SIN(Q8/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E8*SIN(Q8/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F8*SIN(Q8/180*PI()),\"\")))","v":0.31980445356159926},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D8*COS(Q8/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E8*COS(Q8/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F8*COS(Q8/180*PI()),\"\")))","v":-0.13246734197253104},0,0,0.23096988312782168,-9.5670858091272432E-2,0.23096988312782168,-9.5670858091272432E-2,0.46193976625564337,-0.19134171618254486,0.692909649383465,-0.28701257427381732,null,null,130.90909090909091,1,1,1,1,1,1,1,1,1,1,1]
["ONRC","Maintenance Activity",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,4,FALSE)/100","v":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,24,FALSE)/100","v":0.67647058823529405},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,24,FALSE)/100","v":0.74074074074074081},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,24,FALSE)/100","v":0.69230769230769229},0,0.58333333333333326,0.66666666666666663,1,1,1,4.1666666666666664E-2,120.00000000000001,{"$f":"360*SUM($M$3:M9)","v":135.00000000000003},"Maintenance Activtity",127.50000000000003,0.79335334029123483,-0.60876142900872099,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D9*SIN(Q9/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E9*SIN(Q9/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F9*SIN(Q9/180*PI()),\"\")))","v":0.54924462020162412},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D9*COS(Q9/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E9*COS(Q9/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F9*COS(Q9/180*PI()),\"\")))","v":-0.42145022008296068},0,0,0.46278944850322024,-0.35511083358842055,0.52890222686082322,-0.40584095267248066,0.79335334029123483,-0.60876142900872099,0.79335334029123483,-0.60876142900872099,null,null,147.27272727272728,1,1,1,1,1,1,1,1,1,1,1]
["ONRC","Condition",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,5,FALSE)/100","v":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,25,FALSE)/100","v":0.91176470588235292},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,25,FALSE)/100","v":1},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,25,FALSE)/100","v":0.94230769230769229},0.5,1,1,1,1,1,4.1666666666666664E-2,135.00000000000003,{"$f":"360*SUM($M$3:M10)","v":150.00000000000003},"Condition",142.50000000000003,0.6087614290087201,-0.79335334029123561,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D10*SIN(Q10/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E10*SIN(Q10/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F10*SIN(Q10/180*PI()),\"\")))","v":0.57364057733514007},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D10*COS(Q10/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E10*COS(Q10/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F10*COS(Q10/180*PI()),\"\")))","v":-0.74758295527443352},0.30438071450436005,-0.3966766701456178,0.6087614290087201,-0.79335334029123561,0.6087614290087201,-0.79335334029123561,0.6087614290087201,-0.79335334029123561,0.6087614290087201,-0.79335334029123561,null,null,163.63636363636365,1,1,1,1,1,1,1,1,1,1,1]
["ONRC","Demand",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,6,FALSE)/100","v":0.66666666666666674},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,26,FALSE)/100","v":0.57387955182072836},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,26,FALSE)/100","v":0.71957671957671965},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,26,FALSE)/100","v":0.59065934065934067},0.33333333333333331,0.41666666666666663,0.55555555555555558,0.77777777777777779,0.77777777777777779,1,4.1666666666666664E-2,150.00000000000003,{"$f":"360*SUM($M$3:M11)","v":165.00000000000003},"Demand",157.50000000000003,0.255122288243393,-0.61591968834085797,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D11*SIN(Q11/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E11*SIN(Q11/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F11*SIN(Q11/180*PI()),\"\")))","v":0.22603554384201713},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D11*COS(Q11/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E11*COS(Q11/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F11*COS(Q11/180*PI()),\"\")))","v":-0.54569807552177663},0.12756114412169647,-0.30795984417042893,0.1594514301521206,-0.38494980521303618,0.21260190686949415,-0.5132664069507149,0.2976426696172918,-0.71857296973100093,0.2976426696172918,-0.71857296973100093,null,null,180,1,1,1,1,1,1,1,1,1,1,1]
["ONRC","Crash",{"$f":"VLOOKUP($C$3,'ONRC Category Results'!$A:$G,7,FALSE)/100","v":0.5},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,27,FALSE)/100","v":0.375},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,27,FALSE)/100","v":0.44444444444444442},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,27,FALSE)/100","v":0.44230769230769229},0,0.375,0.5,0.5,0.5,1,4.1666666666666664E-2,165.00000000000003,{"$f":"360*SUM($M$3:M12)","v":180.00000000000003},"Crash",172.50000000000003,6.5263096110025565E-2,-0.49572243068690525,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D12*SIN(Q12/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E12*SIN(Q12/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F12*SIN(Q12/180*PI()),\"\")))","v":5.7732738866561072E-2},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D12*COS(Q12/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E12*COS(Q12/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F12*COS(Q12/180*PI()),\"\")))","v":-0.43852368868457003},0,0,4.8947322082519173E-2,-0.37179182301517893,6.5263096110025565E-2,-0.49572243068690525,6.5263096110025565E-2,-0.49572243068690525,6.5263096110025565E-2,-0.49572243068690525,null,null,196.36363636363635,1,1,1,1,1,1,1,1,1,1,1]
["Asset Management","Condition",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,18,FALSE)/100","v":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,18,FALSE)/100","v":0.58823529411764708},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,18,FALSE)/100","v":0.66666666666666674},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,18,FALSE)/100","v":0.57692307692307698},0,0.375,0.5,1,0.6,{"$f":"6/4","v":1.5},6.25E-2,180.00000000000003,{"$f":"360*SUM($M$3:M13)","v":202.50000000000003},"Condition",191.25000000000003,-0.1950903220161288,-0.98078528040323032,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D13*SIN(Q13/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E13*SIN(Q13/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F13*SIN(Q13/180*PI()),\"\")))","v":-0.11255210885545894},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D13*COS(Q13/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E13*COS(Q13/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F13*COS(Q13/180*PI()),\"\")))","v":-0.56583766177109451},0,0,-7.3158870756048294E-2,-0.36779448015121136,-9.7545161008064402E-2,-0.49039264020161516,-0.1950903220161288,-0.98078528040323032,-0.11705419320967728,-0.58847116824193813,null,null,220.90909090909088,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
["Asset Management","Maintenance Activity",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,19,FALSE)/100","v":0.75},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,19,FALSE)/100","v":0.51102941176470584},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,19,FALSE)/100","v":0.47222222222222221},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,19,FALSE)/100","v":0.52884615384615374},0,0.5,0.5,0.75,0.75,{"$f":"6/4","v":1.5},6.25E-2,202.50000000000003,{"$f":"360*SUM($M$3:M14)","v":225.00000000000003},"Maintenance Activtity",213.75000000000003,-0.41667767476470197,-0.62360220922690868,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D14*SIN(Q14/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E14*SIN(Q14/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F14*SIN(Q14/180*PI()),\"\")))","v":-0.29381118092382824},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D14*COS(Q14/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E14*COS(Q14/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F14*COS(Q14/180*PI()),\"\")))","v":-0.43971950650615349},0,0,-0.27778511650980131,-0.41573480615127245,-0.27778511650980131,-0.41573480615127245,-0.41667767476470197,-0.62360220922690868,-0.41667767476470197,-0.62360220922690868,null,null,245.45454545454538,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
["Asset Management","Asset Inventory",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,17,FALSE)/100","v":0.4285714285714286},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,17,FALSE)/100","v":0.43048694424841216},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,17,FALSE)/100","v":0.43048128342245989},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,17,FALSE)/100","v":0.40239410681399634},0.22727272727272727,0.27272727272727271,0.36363636363636365,0.45454545454545453,0.5,{"$f":"6/4","v":1.5},6.25E-2,225.00000000000003,{"$f":"360*SUM($M$3:M15)","v":247.50000000000003},"Asset Inventory",236.25000000000003,-0.35634411955823392,-0.23810152843697205,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D15*SIN(Q15/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E15*SIN(Q15/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F15*SIN(Q15/180*PI()),\"\")))","v":-0.33457847198546276},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D15*COS(Q15/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E15*COS(Q15/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F15*COS(Q15/180*PI()),\"\")))","v":-0.22355818768836633},-0.18897036643239676,-0.12626596204990939,-0.22676443971887611,-0.15151915445989128,-0.30235258629183487,-0.20202553927985506,-0.37794073286479352,-0.25253192409981878,-0.4157348061512729,-0.2777851165098007,null,null,269.99999999999994,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
["Asset Management","Network",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,16,FALSE)/100","v":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,16,FALSE)/100","v":0.43396226415094341},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,16,FALSE)/100","v":0.52777777777777779},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,16,FALSE)/100","v":0.54455445544554459},0,0.25,0.375,0.5,0.75,{"$f":"6/4","v":1.5},6.25E-2,247.50000000000003,{"$f":"360*SUM($M$3:M16)","v":270.00000000000006},"Network",258.75000000000006,-0.98078528040323054,-0.19509032201612778,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D16*SIN(Q16/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E16*SIN(Q16/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F16*SIN(Q16/180*PI()),\"\")))","v":-0.53409099427898699},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D16*COS(Q16/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E16*COS(Q16/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F16*COS(Q16/180*PI()),\"\")))","v":-0.1062373040681884},0,0,-0.24519632010080764,-4.8772580504031944E-2,-0.36779448015121147,-7.315887075604792E-2,-0.49039264020161527,-9.7545161008063888E-2,-0.73558896030242293,-0.14631774151209584,null,null,294.54545454545445,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
["Asset Management","Timeliness",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,15,FALSE)/100","v":0.66666666666666674},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,15,FALSE)/100","v":0.44758735440931779},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,15,FALSE)/100","v":0.48734177215189872},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,15,FALSE)/100","v":0.43073593073593075},0.1,0.27500000000000002,0.4,0.5,0.5590909090909093,2,8.3333333333333329E-2,270.00000000000006,{"$f":"360*SUM($M$3:M17)","v":300.00000000000006},"Timeliness",285.00000000000006,-0.64395055085937869,0.17254603006834804,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D17*SIN(Q17/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E17*SIN(Q17/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F17*SIN(Q17/180*PI()),\"\")))","v":-0.41605895980849467},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D17*COS(Q17/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E17*COS(Q17/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F17*COS(Q17/180*PI()),\"\")))","v":0.11148266228441966},-9.6592582628906798E-2,2.5881904510252202E-2,-0.26562960222949372,7.1175237403193564E-2,-0.38637033051562719,0.10352761804100881,-0.48296291314453399,0.12940952255126101,-0.54004034833434278,0.14470337521641008,null,null,327.2727272727272,2,2,2,2,2,2,2,2,2,2,2]
["Asset Management","Completeness",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,14,FALSE)/100","v":0.5},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,14,FALSE)/100","v":0.49387254901960781},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,14,FALSE)/100","v":0.46296296296296291},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,14,FALSE)/100","v":0.47756410256410253},0.25,0.33333333333333331,0.5,0.66666666666666663,0.75,2,8.3333333333333329E-2,300.00000000000006,{"$f":"360*SUM($M$3:M18)","v":330.00000000000006},"Completeness",315.00000000000006,-0.35355339059327351,0.35355339059327401,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D18*SIN(Q18/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E18*SIN(Q18/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F18*SIN(Q18/180*PI()),\"\")))","v":-0.33768881537434453},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D18*COS(Q18/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E18*COS(Q18/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F18*COS(Q18/180*PI()),\"\")))","v":0.33768881537434503},-0.17677669529663675,0.176776695296637,-0.23570226039551567,0.23570226039551601,-0.35355339059327351,0.35355339059327401,-0.47140452079103135,0.47140452079103201,-0.53033008588991026,0.53033008588991104,null,null,359.99999999999994,2,2,2,2,2,2,2,2,2,2,2]
["Asset Management","Accuracy",{"$f":"VLOOKUP($C$3,'RCA Results Table'!$A$5:$T$73,13,FALSE)/100","v":0.6},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,13,FALSE)/100","v":0.40416047548291234},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,13,FALSE)/100","v":0.44444444444444442},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,13,FALSE)/100","v":0.42801556420233466},0.2,0.3,0.4,0.5,1,2,8.3333333333333329E-2,330.00000000000006,{"$f":"360*SUM($M$3:M19)","v":360.00000000000006},"Accuracy",345.00000000000006,-0.15529142706151192,0.57955549577344112,{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D19*SIN(Q19/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E19*SIN(Q19/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F19*SIN(Q19/180*PI()),\"\")))","v":-0.11077857961586454},{"$f":"IF(Charts!$B$5='Chart Data'!$D$3,D19*COS(Q19/180*PI()),IF(Charts!$B$5='Chart Data'!$E$3,E19*COS(Q19/180*PI()),IF(Charts!$B$5='Chart Data'!$F$3,F19*COS(Q19/180*PI()),\"\")))","v":0.41343128751672198},-5.1763809020503974E-2,0.19318516525781371,-7.7645713530755958E-2,0.28977774788672056,-0.10352761804100795,0.38637033051562741,-0.12940952255125993,0.48296291314453427,-0.25881904510251985,0.96592582628906853,null,null,392.72727272727263,2,2,2,2,2,2,2,2,2,2,2]
["ONRC",{"$f":"B4","v":"Accuracy"},{"$f":"C4","v":0.875},{"$f":"D4/100","v":6.5318627450980382E-3},{"$f":"E4","v":0.71296296296296291},0.65650080256821819,{"$f":"G4","v":0.51333333333333331},0.6,0.66666666666666663,0.73333333333333328,0.8666666666666667,2,8.3333333333333329E-2,0,30,"Accuracy",15,0.22646666446470565,0.84518509800293473,0.16991491082974472,0.63413108018014264,0.13286044315262729,0.49584192416172174,0.15529142706151244,0.57955549577344101,0.17254603006834715,0.6439505508593788,0.18980063307518186,0.7083456059453167,0.22430983908885133,0.83713571611719262]