{"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":1,"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 2018/19 | PERCENTAGE AT THE EXPECTED STANDARD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V0.6: 14-02-2020"]
[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",79.166666666666671,90,33.333333333333329,87.5,25,100,100,100,33.333333333333336,83.333333333333329,100,80,41.666666666666671,{"$f":"VLOOKUP(A6,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},75,42.857142857142861,100,75,70]
["Auckland Transport",83.333333333333343,50,33.333333333333329,100,75,25,100,50,33.333333333333336,83.333333333333329,0,50,66.666666666666671,{"$f":"VLOOKUP(A7,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},75,57.142857142857146,100,50,75]
["Buller District Council",45.833333333333336,40,75,50,87.5,25,33.333333333333336,50,0,75,50,30,33.333333333333336,{"$f":"VLOOKUP(A8,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":22.222222222222221},0,28.571428571428573,100,25,59]
["Carterton District Council",54.166666666666671,70,50,87.5,75,50,33.333333333333336,100,0,50,100,55.555555555555557,50,{"$f":"VLOOKUP(A9,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},75,52.38095238095238,0,50,72]
["Central Hawke's Bay District Council",79.166666666666671,90,83.333333333333329,100,87.5,50,100,100,100,58.333333333333321,100,50,50,{"$f":"VLOOKUP(A10,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":61.111111111111114},25,50,100,75,66]
["Central Otago District Council",62.5,80,41.666666666666664,100,37.5,50,66.666666666666671,100,33.333333333333336,41.666666666666664,100,20,91.666666666666671,{"$f":"VLOOKUP(A11,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":50},25,65,50,50,74]
["Chatham Islands Council",50,70,75,75,0,50,33.333333333333336,50,66.666666666666671,100,100,55.555555555555557,58.333333333333336,{"$f":"VLOOKUP(A12,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":57.142857142857139},50,63.157894736842103,0,50,74]
["Christchurch City Council",83.333333333333343,60,41.666666666666664,100,75,50,100,100,0,66.666666666666657,50,70,75,{"$f":"VLOOKUP(A13,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},75,61.904761904761905,100,75,75]
["Clutha District Council",79.166666666666671,80,100,87.5,75,75,66.666666666666671,100,100,75,100,70,75,{"$f":"VLOOKUP(A14,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},50,61.904761904761905,100,75,79]
["DOC Roads",25,40,50,50,25,0,0,50,0,75,100,22.222222222222221,0,{"$f":"VLOOKUP(A15,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":0},33.333333333333336,5.2631578947368425,0,0,24]
["Dunedin City Council",100,100,50,100,75,100,100,100,66.666666666666671,100,100,70,83.333333333333343,{"$f":"VLOOKUP(A16,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":72.222222222222229},100,69.047619047619051,100,75,85]
["Far North District Council",79.166666666666671,60,75,75,87.5,75,66.666666666666671,100,66.666666666666671,25,100,55.555555555555557,50,{"$f":"VLOOKUP(A17,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},25,57.142857142857146,0,75,64]
["Gisborne District Council",58.333333333333336,50,25,100,0,25,100,50,0,50,100,50,66.666666666666671,{"$f":"VLOOKUP(A18,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":33.333333333333336},50,47.61904761904762,100,50,68]
["Gore District Council",62.5,70,25,100,12.5,50,66.666666666666671,100,0,50,100,50,36.363636363636367,{"$f":"VLOOKUP(A19,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":50},66.666666666666671,45,50,25,62]
["Grey District Council",62.5,30,75,87.5,100,25,0,100,0,25,100,20,50,{"$f":"VLOOKUP(A20,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":25},0,35,50,50,53]
["Hamilton City Council",75,70,41.666666666666664,100,75,50,100,50,0,91.666666666666657,50,60,91.666666666666671,{"$f":"VLOOKUP(A21,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":61.111111111111114},50,78.571428571428569,50,75,84]
["Hastings District Council",66.666666666666671,60,75,100,0,25,100,50,66.666666666666671,100,100,70,58.333333333333336,{"$f":"VLOOKUP(A22,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},75,57.142857142857146,50,75,68]
["Hauraki District Council",95.833333333333343,70,100,100,87.5,100,100,50,33.333333333333336,100,100,80,91.666666666666671,{"$f":"VLOOKUP(A23,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":37.5},75,75,50,75,87]
["Horowhenua District Council",54.166666666666671,70,8.3333333333333321,100,62.5,0,33.333333333333336,100,66.666666666666671,58.333333333333321,50,44.444444444444443,58.333333333333336,{"$f":"VLOOKUP(A24,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},50,52.38095238095238,0,75,59]
["Hurunui District Council",87.5,50,50,100,62.5,50,66.666666666666671,100,0,75,100,50,50,{"$f":"VLOOKUP(A25,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":38.888888888888893},75,35.714285714285715,100,50,64]
["Hutt City Council",75,60,41.666666666666664,100,50,50,33.333333333333336,100,0,91.666666666666657,50,40,41.666666666666671,{"$f":"VLOOKUP(A26,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":27.777777777777779},50,30.952380952380953,50,50,60]
["Invercargill City Council",87.5,70,41.666666666666664,87.5,75,50,100,100,33.333333333333336,66.666666666666657,100,50,83.333333333333343,{"$f":"VLOOKUP(A27,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":27.777777777777779},75,50,100,50,75]
["Kaikoura District Council",58.333333333333336,50,25,50,25,25,66.666666666666671,100,66.666666666666671,50,50,55.555555555555557,45.454545454545453,{"$f":"VLOOKUP(A28,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},33.333333333333336,33.333333333333336,0,75,60]
["Kaipara District Council",83.333333333333343,40,100,62.5,87.5,25,66.666666666666671,100,33.333333333333336,100,100,66.666666666666671,83.333333333333343,{"$f":"VLOOKUP(A29,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},25,85.714285714285722,0,75,73]
["Kapiti Coast District Council",91.666666666666671,80,75,100,100,75,100,100,0,100,100,60,83.333333333333343,{"$f":"VLOOKUP(A30,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},75,71.428571428571431,100,50,83]
["Kawerau District Council",75,50,50,100,100,25,0,100,0,75,100,55.555555555555557,9.0909090909090917,{"$f":"VLOOKUP(A31,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},100,19.047619047619047,0,0,42]
["MacKenzie District Council",70.833333333333343,80,50,62.5,25,75,100,100,100,50,100,30,50,{"$f":"VLOOKUP(A32,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},50,14.285714285714286,100,75,55]
["Manawatu District Council",58.333333333333336,90,100,75,50,50,66.666666666666671,100,100,75,100,50,83.333333333333343,{"$f":"VLOOKUP(A33,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},50,71.428571428571431,100,50,76]
["Marlborough District Council",70.833333333333343,90,58.333333333333321,100,37.5,50,100,100,100,58.333333333333321,100,60,58.333333333333336,{"$f":"VLOOKUP(A34,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":38.888888888888893},50,45.238095238095241,100,75,70]
["Masterton District Council",50,80,75,100,25,50,66.666666666666671,100,66.666666666666671,100,50,60,41.666666666666671,{"$f":"VLOOKUP(A35,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},75,47.61904761904762,100,25,73]
["Matamata-Piako District Council",91.666666666666671,100,100,100,75,100,100,100,100,100,100,80,91.666666666666671,{"$f":"VLOOKUP(A36,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":61.111111111111114},75,83.333333333333343,50,75,86]
["Napier City Council",54.166666666666671,80,75,100,37.5,50,33.333333333333336,100,66.666666666666671,100,100,40,66.666666666666671,{"$f":"VLOOKUP(A37,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":62.5},25,55,100,75,64]
["Nelson City Council",54.166666666666671,70,75,100,62.5,50,66.666666666666671,100,66.666666666666671,50,50,22.222222222222221,50,{"$f":"VLOOKUP(A38,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":56.25},0,52.5,0,50,56]
["New Plymouth District Council",62.5,80,25,100,37.5,25,100,100,66.666666666666671,25,100,70,33.333333333333336,{"$f":"VLOOKUP(A39,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":16.666666666666668},75,30.952380952380953,50,50,57]
["Opotiki District Council",95.833333333333343,80,91.666666666666671,100,87.5,75,66.666666666666671,100,100,66.666666666666657,100,60,83.333333333333343,{"$f":"VLOOKUP(A40,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":22.222222222222221},75,52.38095238095238,100,50,81]
["Otorohanga District Council",95.833333333333343,90,75,100,87.5,100,66.666666666666671,100,66.666666666666671,100,100,80,91.666666666666671,{"$f":"VLOOKUP(A41,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},75,85.714285714285722,50,75,84]
["Palmerston North City Council",45.833333333333336,70,75,100,12.5,25,66.666666666666671,100,66.666666666666671,100,50,30,66.666666666666671,{"$f":"VLOOKUP(A42,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},25,28.571428571428573,100,75,53]
["Porirua City Council",66.666666666666671,80,66.666666666666657,100,50,75,33.333333333333336,100,66.666666666666671,66.666666666666657,100,30,41.666666666666671,{"$f":"VLOOKUP(A43,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":25},0,25,100,75,50]
["Queenstown-Lakes District Council",54.166666666666671,90,41.666666666666664,75,37.5,25,100,100,100,66.666666666666657,50,44.444444444444443,83.333333333333343,{"$f":"VLOOKUP(A44,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":72.222222222222229},50,73.80952380952381,0,75,74]
["Rangitikei District Council",79.166666666666671,90,100,87.5,75,100,100,100,100,75,50,33.333333333333336,83.333333333333343,{"$f":"VLOOKUP(A45,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":72.222222222222229},50,69.047619047619051,0,75,77]
["Rotorua Lakes Council",91.666666666666671,40,75,62.5,62.5,50,66.666666666666671,50,33.333333333333336,100,100,50,41.666666666666671,{"$f":"VLOOKUP(A46,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},50,47.61904761904762,50,50,65]
["Ruapehu District Council",75,70,50,75,50,50,100,100,0,100,100,60,50,{"$f":"VLOOKUP(A47,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},50,33.333333333333336,100,50,63]
["Selwyn District Council",75,60,100,100,25,25,100,50,100,100,100,77.777777777777786,75,{"$f":"VLOOKUP(A48,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":33.333333333333336},100,57.142857142857146,0,75,77]
["South Taranaki District Council",70.833333333333343,90,66.666666666666657,75,87.5,75,100,100,33.333333333333336,66.666666666666657,100,50,72.727272727272734,{"$f":"VLOOKUP(A49,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":33.333333333333336},33.333333333333336,47.61904761904762,100,75,68]
["South Waikato District Council",100,100,100,100,100,100,100,100,100,100,100,60,91.666666666666671,{"$f":"VLOOKUP(A50,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":33.333333333333336},50,66.666666666666671,50,75,77]
["South Wairarapa District Council",79.166666666666671,60,25,100,37.5,75,100,100,33.333333333333336,0,100,50,66.666666666666671,{"$f":"VLOOKUP(A51,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},75,47.61904761904762,100,50,70]
["Southland District Council",70.833333333333343,80,50,87.5,0,75,66.666666666666671,100,33.333333333333336,100,100,60,83.333333333333343,{"$f":"VLOOKUP(A52,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":50},75,64.285714285714292,100,50,82]
["Stratford District Council",45.833333333333336,40,25,75,62.5,25,0,100,33.333333333333336,0,50,40,63.636363636363633,{"$f":"VLOOKUP(A53,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},33.333333333333336,47.61904761904762,50,0,59]
["Tararua District Council",75,90,100,87.5,62.5,100,66.666666666666671,100,66.666666666666671,100,50,77.777777777777786,72.727272727272734,{"$f":"VLOOKUP(A54,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},66.666666666666671,66.666666666666671,0,75,72]
["Tasman District Council",58.333333333333336,90,75,87.5,87.5,50,33.333333333333336,100,100,50,100,40,41.666666666666671,{"$f":"VLOOKUP(A55,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":43.75},0,37.5,100,75,67]
["Taupo District Council",45.833333333333336,50,0,100,37.5,0,33.333333333333336,100,66.666666666666671,0,50,60,75,{"$f":"VLOOKUP(A56,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":77.777777777777786},75,71.428571428571431,50,75,86]
["Tauranga City Council",75,50,75,100,50,0,100,50,66.666666666666671,100,50,70,91.666666666666671,{"$f":"VLOOKUP(A57,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":88.888888888888886},50,90.476190476190482,100,75,84]
["Thames-Coromandel District Council",83.333333333333343,70,75,100,100,75,100,50,33.333333333333336,50,100,50,66.666666666666671,{"$f":"VLOOKUP(A58,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":72.222222222222229},25,69.047619047619051,50,75,73]
["Timaru District Council",87.5,100,100,87.5,100,75,100,100,100,100,100,60,66.666666666666671,{"$f":"VLOOKUP(A59,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":38.888888888888893},75,54.761904761904766,50,50,73]
["Upper Hutt City Council",58.333333333333336,50,58.333333333333321,100,50,50,0,100,66.666666666666671,33.333333333333329,50,30,50,{"$f":"VLOOKUP(A60,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},25,52.38095238095238,100,0,57]
["Waikato District Council",91.666666666666671,100,75,100,75,100,100,100,66.666666666666671,100,100,90,100,{"$f":"VLOOKUP(A61,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":77.777777777777786},100,90.476190476190482,100,75,90]
["Waimakariri District Council",58.333333333333336,70,66.666666666666657,75,25,25,66.666666666666671,100,100,66.666666666666657,100,22.222222222222221,50,{"$f":"VLOOKUP(A62,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},0,42.857142857142861,0,75,51]
["Waimate District Council",87.5,70,75,100,87.5,75,100,100,66.666666666666671,50,50,40,66.666666666666671,{"$f":"VLOOKUP(A63,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":22.222222222222221},50,38.095238095238095,100,50,72]
["Waipa District Council",95.833333333333343,100,75,100,87.5,100,100,100,66.666666666666671,100,100,70,91.666666666666671,{"$f":"VLOOKUP(A64,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},75,80.952380952380949,50,75,81]
["Wairoa District Council",79.166666666666671,70,50,100,62.5,75,100,100,66.666666666666671,50,0,33.333333333333336,75,{"$f":"VLOOKUP(A65,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":37.5},50,55,0,50,62]
["Waitaki District Council",87.5,90,87.5,100,87.5,50,100,100,100,87.5,100,50,41.666666666666671,{"$f":"VLOOKUP(A66,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":27.777777777777779},25,30.952380952380953,100,75,63]
["Waitomo District Council",100,80,100,100,100,100,66.666666666666671,50,100,100,100,80,90.909090909090907,{"$f":"VLOOKUP(A67,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":55.555555555555557},66.666666666666671,80.952380952380949,50,75,86]
["Wellington City Council",83.333333333333343,90,75,100,50,50,100,100,100,100,100,20,91.666666666666671,{"$f":"VLOOKUP(A68,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":66.666666666666671},50,61.904761904761905,100,50,70]
["Western Bay of Plenty District Council",58.333333333333336,70,75,100,0,0,100,100,100,75,100,80,100,{"$f":"VLOOKUP(A69,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":61.111111111111114},75,83.333333333333343,100,75,88]
["Westland District Council",79.166666666666671,30,25,75,62.5,25,33.333333333333336,100,0,25,100,77.777777777777786,25,{"$f":"VLOOKUP(A70,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":0},50,28.571428571428573,0,50,51]
["Whakatane District Council",83.333333333333343,90,75,100,50,75,33.333333333333336,100,100,100,100,60,58.333333333333336,{"$f":"VLOOKUP(A71,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},25,57.142857142857146,100,50,70]
["Whanganui District Council",54.166666666666671,70,50,87.5,75,0,100,100,66.666666666666671,25,50,22.222222222222221,81.818181818181813,{"$f":"VLOOKUP(A72,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":11.111111111111111},0,42.857142857142861,0,75,55]
["Whangarei District Council",62.5,50,75,87.5,25,0,66.666666666666671,100,33.333333333333336,100,100,66.666666666666671,58.333333333333336,{"$f":"VLOOKUP(A73,'[1]Flat Table (REG Website)'!$A$5:$O$73,15,FALSE)","v":44.444444444444443},25,61.904761904761905,0,75,66]

{"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,100,100,100,61.904761904761905,100]
["Auckland Transport",87.5,25,100,50,61.904761904761905,0]
["Buller District Council",68.75,25,33.333333333333336,50,42.857142857142854,50]
["Carterton District Council",81.25,50,33.333333333333336,100,28.571428571428569,100]
["Central Hawke's Bay District Council",93.75,50,100,100,76.190476190476176,100]
["Central Otago District Council",68.75,50,66.666666666666671,100,38.095238095238095,100]
["Chatham Islands Council",37.5,50,33.333333333333336,50,85.714285714285708,100]
["Christchurch City Council",87.5,50,100,100,38.095238095238088,50]
["Clutha District Council",81.25,75,66.666666666666671,100,85.714285714285708,100]
["DOC Roads",37.5,0,0,50,42.857142857142854,100]
["Dunedin City Council",87.5,100,100,100,85.714285714285708,100]
["Far North District Council",81.25,75,66.666666666666671,100,42.857142857142854,100]
["Gisborne District Council",50,25,100,50,28.571428571428569,100]
["Gore District Council",56.25,50,66.666666666666671,100,28.571428571428569,100]
["Grey District Council",93.75,25,0,100,14.285714285714285,100]
["Hamilton City Council",87.5,50,100,50,52.380952380952372,50]
["Hastings District Council",50,25,100,50,85.714285714285708,100]
["Hauraki District Council",93.75,100,100,50,71.428571428571416,100]
["Horowhenua District Council",81.25,0,33.333333333333336,100,61.904761904761905,50]
["Hurunui District Council",81.25,50,66.666666666666671,100,42.857142857142854,100]
["Hutt City Council",75,50,33.333333333333336,100,52.380952380952372,50]
["Invercargill City Council",81.25,50,100,100,52.38095238095238,100]
["Kaikoura District Council",37.5,25,66.666666666666671,100,57.142857142857139,50]
["Kaipara District Council",75,25,66.666666666666671,100,71.428571428571416,100]
["Kapiti Coast District Council",100,75,100,100,57.142857142857139,100]
["Kawerau District Council",100,25,0,100,42.857142857142854,100]
["MacKenzie District Council",43.75,75,100,100,71.428571428571416,100]
["Manawatu District Council",62.5,50,66.666666666666671,100,85.714285714285694,100]
["Marlborough District Council",68.75,50,100,100,76.190476190476176,100]
["Masterton District Council",62.5,50,66.666666666666671,100,85.714285714285708,50]
["Matamata-Piako District Council",87.5,100,100,100,99.999999999999972,100]
["Napier City Council",68.75,50,33.333333333333336,100,85.714285714285708,100]
["Nelson City Council",81.25,50,66.666666666666671,100,57.142857142857139,50]
["New Plymouth District Council",68.75,25,100,100,42.857142857142854,100]
["Opotiki District Council",93.75,75,66.666666666666671,100,80.952380952380935,100]
["Otorohanga District Council",93.75,100,66.666666666666671,100,85.714285714285708,100]
["Palmerston North City Council",56.25,25,66.666666666666671,100,85.714285714285708,50]
["Porirua City Council",75,75,33.333333333333336,100,66.666666666666671,100]
["Queenstown-Lakes District Council",56.25,25,100,100,80.952380952380935,50]
["Rangitikei District Council",81.25,100,100,100,85.714285714285694,50]
["Rotorua Lakes Council",62.5,50,66.666666666666671,50,71.428571428571416,100]
["Ruapehu District Council",62.5,50,100,100,57.142857142857139,100]
["Selwyn District Council",62.5,25,100,50,99.999999999999972,100]
["South Taranaki District Council",81.25,75,100,100,52.38095238095238,100]
["South Waikato District Council",100,100,100,100,99.999999999999986,100]
["South Wairarapa District Council",68.75,75,100,100,14.285714285714285,100]
["Southland District Council",43.75,75,66.666666666666671,100,71.428571428571416,100]
["Stratford District Council",68.75,25,0,100,14.285714285714285,50]
["Tararua District Council",75,100,66.666666666666671,100,85.714285714285708,50]
["Tasman District Council",87.5,50,33.333333333333336,100,71.428571428571416,100]
["Taupo District Council",68.75,0,33.333333333333336,100,28.571428571428569,50]
["Tauranga City Council",75,0,100,50,85.714285714285708,50]
["Thames-Coromandel District Council",100,75,100,50,42.857142857142854,100]
["Timaru District Council",93.75,75,100,100,99.999999999999972,100]
["Upper Hutt City Council",75,50,0,100,47.619047619047613,50]
["Waikato District Council",87.5,100,100,100,85.714285714285708,100]
["Waimakariri District Council",50,25,66.666666666666671,100,80.952380952380935,100]
["Waimate District Council",93.75,75,100,100,57.142857142857139,50]
["Waipa District Council",93.75,100,100,100,85.714285714285708,100]
["Wairoa District Council",81.25,75,100,100,57.142857142857139,0]
["Waitaki District Council",93.75,50,100,100,92.857142857142847,100]
["Waitomo District Council",100,100,66.666666666666671,50,99.999999999999986,100]
["Wellington City Council",75,50,100,100,99.999999999999972,100]
["Western Bay of Plenty District Council",50,0,100,100,85.714285714285694,100]
["Westland District Council",68.75,25,33.333333333333336,100,14.285714285714285,100]
["Whakatane District Council",75,75,33.333333333333336,100,99.999999999999972,100]
["Whanganui District Council",81.25,0,100,100,42.857142857142854,50]
["Whangarei District Council",56.25,0,66.666666666666671,100,71.428571428571416,100]

{"sheet":"Region & Peer Group Results","index":2,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":true,"merged":[[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],[19,21,19,26],[20,21,20,26],[2,1,2,11],[2,12,2,19],[3,1,3,3],[3,4,3,11],[3,12,3,14],[3,15,3,18],[32,1,32,3],[32,4,32,11],[32,12,32,14],[32,15,32,18],[32,21,32,26]]}
["REG DATA QUALITY RESULTS 2018/19 | 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",75.694444444444443,63.333333333333336,73.611111111111114,93.75,58.333333333333336,37.5,61.111111111111114,83.333333333333343,66.666666666666671,86.111111111111114,91.666666666666671,62.711864406779661,64.788732394366207,47.222222222222221,60.869565217391305,58.333333333333336,50,81.818181818181813,71.666666666666671,null,76.041666666666671,37.5,61.111111111111114,83.333333333333343,77.777777777777786,91.666666666666671]
["Canterbury",76.388888888888886,70,60.18518518518519,84.722222222222229,50,55.555555555555557,88.888888888888886,94.444444444444443,62.962962962962962,71.296296296296305,83.333333333333343,54.022988505747129,57.943925233644855,33.333333333333329,60.000000000000007,42.328042328042329,66.666666666666671,73.333333333333343,66.333333333333329,null,67.361111111111114,55.555555555555557,88.888888888888886,94.444444444444443,67.724867724867735,83.333333333333343]
["Gisborne and Hawkes Bay",69.166666666666671,70,61.666666666666657,100,37.5,45,86.666666666666671,80,60,71.666666666666657,80,48.979591836734691,63.333333333333336,50,45,52.912621359223301,65,77.777777777777786,65.599999999999994,null,68.75,45,86.666666666666671,80,66.666666666666671,80]
["No Region",43.055555555555557,60,55.55555555555555,70.833333333333343,16.666666666666668,16.666666666666668,44.444444444444443,66.666666666666671,44.444444444444443,88.888888888888886,83.333333333333343,42.857142857142854,42.857142857142861,39.130434782608695,36.363636363636367,44.067796610169495,41.666666666666671,25,55,null,43.75,16.666666666666668,44.444444444444443,66.666666666666671,69.841269841269835,83.333333333333343]
["North Auckland",77.083333333333343,50,70.833333333333329,81.25,68.75,31.25,75,87.5,41.666666666666671,77.083333333333329,75,59.45945945945946,64.583333333333343,58.333333333333336,37.5,65.476190476190482,68.75,40,69.5,null,75,31.25,75,87.5,61.904761904761898,75]
["Southland and Otago",72.395833333333343,82.5,54.6875,92.1875,50,59.375,83.333333333333343,100,58.333333333333336,73.4375,93.75,51.898734177215189,72.631578947368425,49.285714285714292,58.064516129032256,57.53012048192771,59.375,80,74.25,null,71.09375,59.375,83.333333333333343,100,66.964285714285708,93.75]
["Taranaki, Manawatu and Whanganui",62.083333333333336,76,60,86.25,57.5,45,73.333333333333343,100,60,62.5,70,47.916666666666671,66.379310344827587,33.333333333333336,44.444444444444443,49.047619047619044,60,62.5,63.9,null,71.875,45,73.333333333333343,100,61.428571428571431,70]
["Top of South Island and West Coast",61.805555555555557,58.333333333333336,63.888888888888886,83.333333333333343,72.916666666666671,37.5,44.444444444444443,91.666666666666671,44.444444444444443,47.222222222222221,83.333333333333343,41.379310344827587,43.055555555555557,30.392156862745097,16.666666666666668,37.804878048780488,54.166666666666671,70,59.333333333333336,null,78.125,37.5,44.444444444444443,91.666666666666671,46.031746031746032,83.333333333333343]
["Waikato",88.333333333333343,83,74.166666666666671,100,82.5,82.5,86.666666666666671,80,63.333333333333336,84.166666666666671,90,71,88.235294117647058,61.235955056179776,66.666666666666671,78.229665071770341,75,55,83.4,null,91.25,82.5,86.666666666666671,80,75.238095238095241,90]
["Wellington",69.791666666666671,71.25,58.333333333333336,98.4375,54.6875,59.375,58.333333333333336,100,41.666666666666671,67.708333333333329,81.25,43.037974683544299,58.333333333333336,50,53.125,48.802395209580837,43.75,86.666666666666671,66.875,null,76.5625,59.375,58.333333333333336,100,56.547619047619044,81.25]
[]
[]
["REG DATA QUALITY RESULTS 2018/19 | 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",70.987654320987644,71.1111111111111,62.654320987654309,89.81481481481481,57.407407407407405,45.370370370370367,74.074074074074076,88.888888888888886,64.197530864197532,69.135802469135783,87.037037037037038,56.273764258555133,63.975155279503099,43.541666666666671,49.056603773584904,54.698581560283692,63.888888888888886,61.702127659574472,69.740740740740748,null,73.6111111111111,45.370370370370367,74.074074074074076,88.888888888888886,67.019400352733683,87.037037037037038]
["Highly Urban",75,64,56.666666666666657,100,65,35,66.666666666666671,80,33.333333333333336,91.666666666666657,70,48.979591836734691,66.101694915254242,51.111111111111107,57.89473684210526,56.19047619047619,50,66.666666666666671,68,null,82.5,35,66.666666666666671,80,66.666666666666671,70]
["Rural Districts",73.397435897435898,75,67.788461538461533,88.461538461538453,58.653846153846153,66.34615384615384,76.92307692307692,94.230769230769226,57.692307692307693,69.711538461538453,88.461538461538453,55.952380952380949,67.426710097719877,45.633187772925766,55.555555555555557,56.099815157116453,60.576923076923073,70.454545454545453,71.307692307692307,null,73.557692307692307,66.34615384615384,76.92307692307692,94.230769230769226,64.560439560439562,88.461538461538453]
["Cities",72.222222222222214,67.777777777777771,60.18518518518519,98.611111111111114,59.722222222222221,50,66.666666666666657,94.444444444444443,44.444444444444443,74.074074074074076,66.666666666666671,42.696629213483142,64.81481481481481,47.435897435897431,41.666666666666671,50.537634408602145,55.555555555555557,94.117647058823522,65.333333333333329,null,79.166666666666671,50,66.666666666666657,94.444444444444443,61.37566137566138,66.666666666666671]
["No Group",43.75,55,45.833333333333329,68.75,25,0,50,75,33.333333333333336,83.333333333333329,75,36.842105263157897,34.782608695652172,31.25,28.571428571428569,35,37.5,33.333333333333336,45.5,null,46.875,0,50,75,61.904761904761898,75]
[]
[]
["REG DATA QUALITY RESULTS 2018/19 | 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",71.557971014492765,71.159420289855063,63.34541062801933,90.579710144927546,57.789855072463773,51.811594202898554,72.94685990338165,90.579710144927546,56.038647342995176,72.04106280193237,83.333333333333343,53.273809523809526,64.713064713064711,45.065789473684212,50.561797752808992,54.247910863509752,59.782608695652179,69.166666666666671,68.927536231884062,null,74.184782608695656,51.811594202898554,72.94685990338165,90.579710144927546,65.18288474810214,83.333333333333343]

{"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":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["DATA QUALITY RESULTS 2018/19 | PERCENTAGE AT THE EXPECTED STANDARD"]
[]
["My RCA:","Waipa 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":"Provincial Centres"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"V0.6: 14-02-2020"]

{"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":"Waipa District Council"},"National",{"$f":"VLOOKUP($C$3,Table22[[#All],[RCA_Name]:[Region]],4,FALSE)","v":"Waikato"},{"$f":"VLOOKUP($C$3,Table22[[#All],[RCA_Name]:[Region]],3,FALSE)","v":"Provincial Centres"},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.95833333333333348},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,2,FALSE)/100","v":0.71557971014492761},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,2,FALSE)/100","v":0.88333333333333341},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,2,FALSE)/100","v":0.70987654320987648},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.24803491822324908},{"$f":"C4*COS(Q4/180*PI())","v":0.9256789168603573},{"$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.18372956905425852},{"$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.68568808656322744},{"$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":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,3,FALSE)/100","v":0.71159420289855069},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,3,FALSE)/100","v":0.83},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,3,FALSE)/100","v":0.71111111111111103},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.70710678118654746,0.70710678118654757,{"$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.50283148884376705},{"$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.50283148884376705},{"$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.75},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,4,FALSE)/100","v":0.63345410628019327},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,4,FALSE)/100","v":0.7416666666666667},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,4,FALSE)/100","v":0.62654320987654311},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.72444436971680126,0.19411428382689055,{"$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.60519426770580509},{"$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":0.16216131529571512},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.9375},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,22,FALSE)/100","v":0.74184782608695654},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,22,FALSE)/100","v":0.91249999999999998},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,22,FALSE)/100","v":0.73611111111111105},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.92947955753794731,-0.12236830520629817,{"$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.72981357851127715},{"$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":-9.6081780384204479E-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":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,23,FALSE)/100","v":0.51811594202898559},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,23,FALSE)/100","v":0.82499999999999996},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,23,FALSE)/100","v":0.45370370370370366},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.92387953251128674,-0.38268343236508973,{"$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.41916756567641711},{"$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.17362489061008698},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.72946859903381656},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,24,FALSE)/100","v":0.8666666666666667},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,24,FALSE)/100","v":0.74074074074074081},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.58766914095647027},{"$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.45093439185831191},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.9057971014492755},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,25,FALSE)/100","v":0.8},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,25,FALSE)/100","v":0.88888888888888884},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.54112127022997336},{"$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.70520296914776492},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.8571428571428571},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,26,FALSE)/100","v":0.65182884748102143},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,26,FALSE)/100","v":0.75238095238095237},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,26,FALSE)/100","v":0.67019400352733682},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.32801437059864808,-0.79189674215253159,{"$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.2564721416203421},{"$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.61917852267070372},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":1},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,27,FALSE)/100","v":0.83333333333333348},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,27,FALSE)/100","v":0.9},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,27,FALSE)/100","v":0.87037037037037035},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,0.13052619222005113,-0.99144486137381049,{"$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":0.11360613026560006},{"$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.86292423119572392},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":0.5},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,18,FALSE)/100","v":0.59782608695652184},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,18,FALSE)/100","v":0.75},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,18,FALSE)/100","v":0.63888888888888884},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,-9.7545161008064402E-2,-0.49039264020161516,{"$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.12464103906586006},{"$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.62661281803539715},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.69166666666666676},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,19,FALSE)/100","v":0.55000000000000004},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,19,FALSE)/100","v":0.61702127659574468},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.34279865441635055},{"$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.51303444163348511},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.80952380952380953},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,17,FALSE)/100","v":0.54247910863509752},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,17,FALSE)/100","v":0.78229665071770338},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,17,FALSE)/100","v":0.54698581560283688},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.67309444805444185,-0.44974733149205826,{"$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.45480208403428257},{"$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.30388903703288483},-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":0.75},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,16,FALSE)/100","v":0.5056179775280899},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,16,FALSE)/100","v":0.66666666666666674},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,16,FALSE)/100","v":0.49056603773584906},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.73558896030242293,-0.14631774151209584,{"$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.48113994887705647},{"$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":-9.5704686272062689E-2},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.45065789473684215},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,15,FALSE)/100","v":0.61235955056179781},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,15,FALSE)/100","v":0.43541666666666673},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.42058020353003173},{"$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.11269412588838981},-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.91666666666666674},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,14,FALSE)/100","v":0.64713064713064705},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,14,FALSE)/100","v":0.88235294117647056},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,14,FALSE)/100","v":0.63975155279503104},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.6481812160876681,0.6481812160876691,{"$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.45237266125598968},{"$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.45237266125599035},-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.7},{"$f":"VLOOKUP($D$3,'Region & Peer Group Results'!$A$34:$AA$35,13,FALSE)/100","v":0.53273809523809523},{"$f":"VLOOKUP($E$3,'Region & Peer Group Results'!$A$5:$AA$15,13,FALSE)/100","v":0.71},{"$f":"VLOOKUP($F$3,'Region & Peer Group Results'!$A$22:$AA$27,13,FALSE)/100","v":0.56273764258555137},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.18117333157176388,0.67614807840234792,{"$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.14564721929723551},{"$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.54356282239841125},-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.95833333333333348},{"$f":"D4/100","v":7.1557971014492763E-3},{"$f":"E4","v":0.88333333333333341},0.70987654320987648,{"$f":"G4","v":0.51333333333333331},0.6,0.66666666666666663,0.73333333333333328,0.8666666666666667,2,8.3333333333333329E-2,0,30,"Accuracy",15,0.24803491822324908,0.9256789168603573,0.18372956905425852,0.68568808656322744,0.13286044315262729,0.49584192416172174,0.15529142706151244,0.57955549577344101,0.17254603006834715,0.6439505508593788,0.18980063307518186,0.7083456059453167,0.22430983908885133,0.83713571611719262]