{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Building Consent Fee Summary","PIM Only Consent Fee Summary","Scanning | Printing Calculator","Connect Amendment Input Calcs","Scanning Calculations","Dropdowns","Names of Officers","DedupedNames","Role Fee Structure"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Building Consent Fee Summary","index":0,"n_rows":99,"n_cols":26,"rows_kept":99,"cut":false,"hidden":false,"merged":[[49,0,49,2],[50,4,50,5],[46,8,46,10],[39,3,39,4],[42,3,42,4],[69,6,70,6],[69,0,70,5],[63,4,63,5],[55,4,55,5],[53,2,53,3],[54,2,54,3],[53,4,53,5],[54,4,54,5],[67,0,67,5],[57,0,57,6],[59,1,59,3],[60,1,60,3],[65,0,65,5],[75,1,75,5],[2,0,2,4],[52,0,52,6],[47,0,47,2],[48,0,48,2],[46,0,46,2],[13,2,13,4],[4,5,4,6],[6,0,6,6],[11,0,11,6],[16,0,16,6],[21,0,21,6],[44,0,44,6],[41,3,41,4],[38,3,38,4],[4,3,4,4],[92,1,92,4],[94,1,94,4],[96,1,96,4],[98,1,98,4],[87,1,87,4],[90,1,90,4],[91,1,91,4],[88,1,88,5]]}
[]
[]
["Consent Fee Summary (Building Consent)"]
[]
["Consent Reference Number:","BCN/2017/2013/B","Consent Address:","80 Byron Street",null,"B103 LU: 01.07.20 LR: 01.07.20 v28"]
[]
["Accept:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["Lodging",null,"Bruce Lyon","2020-07-01",0.33,{"$f":"IF(C9=\"\",\" \",SUMPRODUCT((Z9=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W9=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D9>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D9<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":120},{"$f":"IF(C9=\"\", \" \",$E9*$F9)","v":39.6},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D9)>6,YEAR(D9)+1,YEAR(D9)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C9=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D9>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D9<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":59}]
[null," ",null,null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$7,$G:$G)","v":39.6}]
[null,null," "]
["PIM/Development Check:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["PIM Coordinator Sign-off"," ",null,null,null,"Not Applicable",{"$f":"VLOOKUP(F14,PIMCOORD[#All],2,0)","v":0},null,null,null,null,{"$f":"$A$12","v":"PIM/Development Check:"}]
[null,null,null,null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$12,$G:$G)","v":0}]
[null," "]
["Pre-acceptance Technical Review:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["Pre-acceptance technical review",null,"Michelle-Anne Reddock","2020-06-30",0.83,{"$f":"IF(C19=\"\",\" \",SUMPRODUCT((Z19=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W19=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D19>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D19<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":180},{"$f":"IF(C19=\"\", \" \",$E19*$F19)","v":149.4},null,null,null,null,{"$f":"$A$17","v":"Pre-acceptance Technical Review:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D19)>6,YEAR(D19)+1,YEAR(D19)),\"####\")","v":"2020"},null,"Role Type",{"$f":"SUMPRODUCT((C19=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D19>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D19<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":81}]
[null," "," ",null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$17,$G:$G)","v":149.4}]
[]
["Process and Grant:"]
["Type:","Comments:","Officer Name:","Date:","Hours Worked:","Rate Per Hour:","Fee:"]
["Processing",null,"Jim Nguyen","2020-07-02",1.75,{"$f":"IF(C24=\"\",\" \",SUMPRODUCT((Z24=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W24=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D24>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D24<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C24=\"\", \" \",$E24*$F24)","v":367.5},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D24)>6,YEAR(D24)+1,YEAR(D24)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C24=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D24>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D24<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Processing",null,"Jim Nguyen","2020-07-20",0.5,{"$f":"IF(C25=\"\",\" \",SUMPRODUCT((Z25=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W25=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D25>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D25<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C25=\"\", \" \",$E25*$F25)","v":105},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D25)>6,YEAR(D25)+1,YEAR(D25)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C25=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D25>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D25<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Processing",null,"Jim Nguyen","2020-07-21",0.5,{"$f":"IF(C26=\"\",\" \",SUMPRODUCT((Z26=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W26=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D26>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D26<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C26=\"\", \" \",$E26*$F26)","v":105},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D26)>6,YEAR(D26)+1,YEAR(D26)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C26=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D26>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D26<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["RFI Processing",null,"Jim Nguyen","2020-08-12",0.75,{"$f":"IF(C27=\"\",\" \",SUMPRODUCT((Z27=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W27=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D27>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D27<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C27=\"\", \" \",$E27*$F27)","v":157.5},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D27)>6,YEAR(D27)+1,YEAR(D27)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C27=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D27>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D27<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Processing",null,"Jim Nguyen","2020-12-09",0.33,{"$f":"IF(C28=\"\",\" \",SUMPRODUCT((Z28=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W28=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D28>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D28<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C28=\"\", \" \",$E28*$F28)","v":69.3},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D28)>6,YEAR(D28)+1,YEAR(D28)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C28=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D28>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D28<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Processing"," ","Jim Nguyen","2021-02-09",0.17,{"$f":"IF(C29=\"\",\" \",SUMPRODUCT((Z29=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W29=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D29>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D29<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C29=\"\", \" \",$E29*$F29)","v":35.700000000000003},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D29)>6,YEAR(D29)+1,YEAR(D29)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C29=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D29>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D29<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["RFI Processing",null,"Jim Nguyen","2021-02-19",0.17,{"$f":"IF(C30=\"\",\" \",SUMPRODUCT((Z30=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W30=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D30>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D30<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C30=\"\", \" \",$E30*$F30)","v":35.700000000000003},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D30)>6,YEAR(D30)+1,YEAR(D30)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C30=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D30>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D30<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Processing",null,"Jim Nguyen","2021-03-23",0.17,{"$f":"IF(C31=\"\",\" \",SUMPRODUCT((Z31=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W31=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D31>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D31<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C31=\"\", \" \",$E31*$F31)","v":35.700000000000003},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D31)>6,YEAR(D31)+1,YEAR(D31)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C31=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D31>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D31<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["RFI Processing",null,"Jim Nguyen","2021-04-09",0.75,{"$f":"IF(C32=\"\",\" \",SUMPRODUCT((Z32=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W32=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D32>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D32<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C32=\"\", \" \",$E32*$F32)","v":157.5},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D32)>6,YEAR(D32)+1,YEAR(D32)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C32=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D32>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D32<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["RFI Processing",null,"Jim Nguyen","2021-04-13",1.25,{"$f":"IF(C33=\"\",\" \",SUMPRODUCT((Z33=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W33=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D33>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D33<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C33=\"\", \" \",$E33*$F33)","v":262.5},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D33)>6,YEAR(D33)+1,YEAR(D33)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C33=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D33>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D33<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":3}]
["Fire Engineer"," ","Jason Dean","2020-07-10",0.25,{"$f":"IF(C34=\"\",\" \",SUMPRODUCT((Z34=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W34=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D34>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D34<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":245},{"$f":"IF(C34=\"\", \" \",$E34*$F34)","v":61.25},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D34)>6,YEAR(D34)+1,YEAR(D34)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C34=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D34>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D34<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":4}]
["Fire Engineer",null,"Jason Dean","2020-07-21",1.25,{"$f":"IF(C35=\"\",\" \",SUMPRODUCT((Z35=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W35=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D35>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D35<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":245},{"$f":"IF(C35=\"\", \" \",$E35*$F35)","v":306.25},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D35)>6,YEAR(D35)+1,YEAR(D35)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C35=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D35>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D35<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":4}]
["Fire Engineer",null,"Jason Dean","2020-08-11",0.25,{"$f":"IF(C36=\"\",\" \",SUMPRODUCT((Z36=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W36=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D36>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D36<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":245},{"$f":"IF(C36=\"\", \" \",$E36*$F36)","v":61.25},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D36)>6,YEAR(D36)+1,YEAR(D36)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C36=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D36>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D36<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":4}]
["Fire Engineer",null,"Jason Dean","2020-08-13",0.33,{"$f":"IF(C37=\"\",\" \",SUMPRODUCT((Z37=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W37=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D37>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D37<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":245},{"$f":"IF(C37=\"\", \" \",$E37*$F37)","v":80.850000000000009},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D37)>6,YEAR(D37)+1,YEAR(D37)),\"####\")","v":"2021"},null,"Role Type",{"$f":"SUMPRODUCT((C37=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D37>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D37<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":4}]
["End Administration"," ","Lynette Daniell","2021-04-15",1,{"$f":"IF(C38=\"\",\" \",SUMPRODUCT((Z38=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(W38=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D38>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D38<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":120},120,null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,"Financial Year","2021",null,"Role Type",{"$f":"SUMPRODUCT((C38=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D38>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D38<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":59}]
[null," ",null,"Issuing Consent:",null,"Applicable",{"$f":"VLOOKUP(F39,IssueConsent[#All],2,0)","v":30},null,null,null,null,{"$f":"$A$22","v":"Process and Grant:"}]
[null," ",null,"Fixed Administration Fee:",null,"Not Applicable",{"$f":"VLOOKUP(F40,FixedAdminFee[#All],2,0)","v":0},null,null,null,null,"Process and Grant:"]
[null,null,null,"Certificate of Title:",0,"Not Applicable",{"$f":"IF(AND(F41=\"Applicable\",E41<1),\"CHECK\",E41*W41)","v":0},null,null,null,null,"Process and Grant:",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F41,CT[#All],2,0)","v":0}]
[null,null,null,"External Contractors or Consultants:",null,"Not Applicable",{"$f":"VLOOKUP(F42,ExtContract[#All],2,0)","v":0},null,null,null,null,"Process and Grant:"]
[null,null,null,null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$22,$G:$G)","v":1991}]
[]
["Levies:",null,null,null,null,null,null,null,"Commercial Amendment"]
[null,null,"Original Value of Work:",140000]
["Amendment Value Of Work",null,null,5000,"Increase",null,null,null,"Reduction Levy Calculator",null,null,null,null,"ACL","BL","BRL","text","Residential Levy Charge Rates","MBIE Threshold:",20444,null,"Commercial Levy Charge Rates","MBIE Threshold:",20444]
["Accreditation Levy:",null,null,{"$f":"VLOOKUP(I45,M47:P52,2,0)","v":3},{"$f":"VLOOKUP(I45,M47:Q52,5,0)","v":"($0.60 for every $1,000 of estimated value)"},null,null,null,"Original","New Levy","Connect Value",{"$f":"$A$45","v":"Levies:"},"Residential",{"$f":"ROUNDDOWN(D46,-3)*$R48","v":56},{"$f":"IF(D46<$T$47,\"$0.00\",ROUNDUP(D46,-3)*$R49)","v":245},{"$f":"IF(D46<$T$48,\"$0.00\",ROUNDUP(D46,-3)*$R50)","v":140},"($0.40 for every $1,000 of estimated value)",4.0000000000000002E-4,"BRANZ Threshold:",20000,null,5.9999999999999995E-4,"BRANZ Threshold:",20000]
["Building Levy (MBIE):",null,null,{"$f":"VLOOKUP(I45,M47:P52,3,0)","v":8.75},"($1.75 per $1,000 (or part thereof) of building work valued over $20,444)",null,null,"ACL",null,{"$f":"D48","v":3},{"$f":"(I49+J49)","v":3},"Levies:","Commercial",{"$f":"ROUNDDOWN(D46,-3)*$V48","v":83.999999999999986},{"$f":"IF(D46<$X$47,\"$0.00\",ROUNDUP(D46,-3)*$V49)","v":245},{"$f":"IF(D46<$X$48,\"$0.00\",ROUNDUP(D46,-3)*$V50)","v":140},"($0.60 for every $1,000 of estimated value)",1.75E-3,null,null,null,1.75E-3]
["Building Research Levy (BRANZ):",null,null,{"$f":"VLOOKUP(I45,M47:P52,4,0)","v":5},"($1 per $1,000 (or part thereof) of building work valued over $20,000)",null,null,"MBIE",null,{"$f":"D49","v":8.75},{"$f":"(I50+J50)","v":8.75},"Levies:","Residential Amendment",{"$f":"ROUNDDOWN(D47+D46,-3)*$R48-(ROUNDDOWN(D46,-3)*$R48)","v":2},{"$f":"IF(($D$46+$D$47)<$T$47,IF($D$46>=$T$47,ROUNDUP($D$46,-3)*$R49*-1,0),IF($D$46>=$T$47,ROUNDUP(($D$47),-3)*$R49,ROUNDUP(($D$47+$D$46),-3)*$R49))","v":8.75},{"$f":"IF(($D$46+$D$47)<$T$48,IF($D$46>=$T$48,ROUNDUP($D$46,-3)*$R50*-1,0),IF($D$46>=$T$48,ROUNDUP(($D$47),-3)*$R50,ROUNDUP(($D$46+$D$47),-3)*$R50))","v":5},"($0.40 for every $1,000 of estimated value)",1E-3,null,null,null,1E-3]
[null,null,null,null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$45,$D:$D)","v":16.75},"BRANZ",null,5,{"$f":"(I51+J51)","v":5},"Levies:","Commercial Amendment",{"$f":"ROUNDDOWN(D47+D46,-3)*$V48-(ROUNDDOWN(D46,-3)*$V48)","v":3},{"$f":"IF(($D$46+$D$47)<$X$47,IF($D$46>=$X$47,ROUNDUP($D$46,-3)*$V49*-1,0),IF($D$46>=$X$47,ROUNDUP(($D$47),-3)*$V49,ROUNDUP(($D$47+$D$46),-3)*$V49))","v":8.75},{"$f":"IF(($D$46+$D$47)<$X$48,IF($D$46>=$X$48,ROUNDUP($D$46,-3)*$V50*-1,0),IF($D$46>=$X$48,ROUNDUP(($D$47),-3)*$V50,ROUNDUP(($D$46+$D$47),-3)*$V50))","v":5},"($0.60 for every $1,000 of estimated value)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"<Please Select>","CHECK","CHECK","CHECK","($0.40 for every $1,000 of estimated value)"]
["Inspections:"]
["Type:","Comments:","Number of Inspections:",null,"Cost Per Inspection:",null,"Fee:"]
["< Please Select >","No additional Inspections",0,null,{"$f":"VLOOKUP(A55,InspectionCharge[#All],2,0)","v":0},null,{"$f":"IF(OR(AND(A55=\"Residential\", C55=0),AND(A55=\"Commercial\", C55=0)),\"CHECK\",C55*E55)","v":0},null,null,null,null,{"$f":"$A$53","v":"Inspections:"}]
[null,null,null,null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$53,$G:$G)","v":0}]
[]
["Christchurch City Council Fees:"]
["Fee Type:",null,null,null,"Total Quantity:","Rate Per Quantity","Fee:"]
["Code Compliance Certificate","No Code Compliance Certificate",null,null,0,{"$f":"VLOOKUP(B60,CCC[#All],2,0)","v":0},{"$f":"E60*F60","v":0},null,null,null,null,{"$f":"$A$58","v":"Christchurch City Council Fees:"}]
["Electronic File Management Fee","Applicable",null,null,null,null,{"$f":"VLOOKUP(B61,ElectronicFile[#All],2,0)","v":52},null,null,null,null,{"$f":"$A$58","v":"Christchurch City Council Fees:"}]
["No CCC Connection"," ",null,null,0,{"$f":"VLOOKUP(A62,OptCon[#All],2,0)","v":0},{"$f":"IF(OR(AND(A62=\"Standard Water Connection:\", E62=0),AND(A62=\"Stormwater Opening:\", E62=0),AND(A62=\"Sewer Opening:\", E62=0),AND(A62=\"Vehicle Crossing Inspection:\", E62=0)),\" CHECK\",E62*F62)","v":0},null,null,null,null,"Christchurch City Council Fees:"]
["No Additional Fees",null,null,null,null,null,{"$f":"VLOOKUP(A63,OtherFees[#All],2,0)","v":0},null,null,null,null,"Christchurch City Council Fees:"]
[null," "," ",null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$58,$G:$G)","v":52}]
[]
["Subtotal (inc GST):",null,null,null,null,null,{"$f":"SUM(G10+G15+G20+G43+G51+G56+G64)","v":2248.75}]
[]
["Less Deposit Paid (inc GST):",null,null,null,null,null,0]
[]
["Final Total Invoice (inc GST):",null,null,null,null,null,{"$f":"SUM(G10,G15,G20,G43,G51,G56,G64-G68)","v":2248.75}]
[]
[]
[]
[]
[]
[null,"Fee Summary"]
[]
[null,"Accept:",null,null,null,{"$f":"G10","v":39.6}]
[]
[null,"PIM/Development Check:",null,null,null,{"$f":"G15","v":0}]
[]
[null,"Pre-acceptance Technical Check:",null,null,null,{"$f":"G20","v":149.4}]
[]
[null,"Process and Grant:",null,null,null,{"$f":"G43","v":1991}]
[]
[null,"Inspections:",null,null,null,{"$f":"G56","v":0}]
[]
[null,"Christchurch City Council Fees:",null,null,null,{"$f":"G64","v":52}]
[null,"Note: This fee is a summary only, please refer to the council fees section for a breakdown of the fees"]
[]
[null,"Accreditation Levy",null,null,null,{"$f":"D48","v":3}]
[null,"Building Levy",null,null,null,{"$f":"D49","v":8.75}]
[null,"Building Research Levy ",null,null,null,{"$f":"D50","v":5}]
[]
[null,"Subtotal (inc GST):",null,null,null,{"$f":"G66","v":2248.75}]
[]
[null,"Less Deposit Paid (inc GST):",null,null,null,{"$f":"G68","v":0}]
[]
[null,"Final Total Invoice (inc GST):",null,null,null,{"$f":"G70","v":2248.75}]

{"sheet":"PIM Only Consent Fee Summary","index":1,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,5,4,6],[2,0,2,4],[14,0,14,5],[16,0,17,5],[16,6,17,6],[12,3,12,4],[6,0,6,6],[11,3,11,4],[4,3,4,4]]}
[]
[]
["Consent Fee Summary (PIM Only)"]
[]
["Consent Reference Number:","BCN/201X/XXXX","Consent Address:","ENTER ADDRESS",null,"B103 LU: 01.07.20 LR: 01.07.20 v28"]
[]
["PIM/Development Check "]
["Type:","Comments:","Officer Name:","Date:","Hours Worked:","Rate Per Hour:","Fee:"]
["< Please Select >",null,"Please Select","2015-07-01",0,{"$f":"IF(C9=\"\",\" \",SUMPRODUCT((AA9=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(X9=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D9>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D9<=OFFSET('Role Fee Structure'!$E$4,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$4,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":0},{"$f":"IF(C9=\"\", \" \",$E9*$F9)","v":0},null,null,null,null,{"$f":"$A$7","v":"PIM/Development Check "},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D9)>6,YEAR(D9)+1,YEAR(D9)),\"####\")","v":"2016"},null,"Role Type",{"$f":"SUMPRODUCT((C9=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D9>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D9<=OFFSET('Names of Officers'!$E$4,0,0,'Names of Officers'!$AB$6))*(OFFSET('Names of Officers'!$F$4,0,0,'Names of Officers'!$AB$6)))","v":0}]
[null," ",null,"Certificate of Title:",0,"Not Applicable",{"$f":"IF(AND(F10=\"Applicable\",E10<1),\"CHECK\",E10*X10)","v":0},null,null,null,null,{"$f":"$A$7","v":"PIM/Development Check "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F10,CT[#All],2,0)","v":0}]
[null,null,null,"PIM Coordinator Sign Off",null,"Applicable",{"$f":"VLOOKUP(F11,PIMCOORD[#All],2,0)","v":30},null,null,null,null,"PIM/Development Check "]
[null,null,null,"Electronic File Management Fee",null,"Applicable",{"$f":"VLOOKUP(F12,ElectronicFile[#All],2,0)","v":52},null,null,null,null,"PIM/Development Check "]
[null,null,null,"Total Fee:",null,null,{"$f":"SUMIF($L:$L,$A$7,$G:$G)","v":82}]
[]
["Less Deposit Paid (inc GST):",null,null,null,null,null,0]
[]
["Total Invoice (inc GST):",null,null,null,null,null,{"$f":"SUM(G13-G15)","v":82}]

{"sheet":"Scanning | Printing Calculator","index":2,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
[]
[]
["Scanning"]
["Received: "]
["No. of pages: A4/A3",0]
["No. of pages: A2/Larger",0]
[]
[]
["Printing"]
["No. of pages: A4",0]
["No. of pages: A3",0]
["No. of pages: A2",0]
["No. of pages: A1",0]
[]
[]
["Total Scanning Charge:",{"$f":"'Scanning Calculations'!C8","v":0}]
["Total Printing Charge:",{"$f":"'Scanning Calculations'!O8","v":0}]

{"sheet":"Connect Amendment Input Calcs","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"(For Connect Input Only) Levies:"]
[]
[null,null,"New levies","Original levies","Amendment 1 levies","Amendment 2 levies","Amendment 3 levies","Total previous levies","Difference (Adjust by these amounts)"]
[null,"Accreditation Levy",null,null,null,null,null,{"$f":"SUM(D4:G4)","v":0},{"$f":"C4-H4","v":0}]
[null,"Building Levy",null,null,null,null,null,{"$f":"SUM(D5:G5)","v":0},{"$f":"C5-H5","v":0}]
[null,"Building Research Levy",null,null,null,null,null,0,0]

{"sheet":"Scanning Calculations","index":4,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":true,"merged":[[4,4,4,6]]}
["DO NOT EDIT THE RED CELLS",null,null,null,null,null,null,null,null,null,null,null,"Printing Calculations"]
[]
["Changes to the Scanning Fees can be made by editing the yellow cells. These changes will automatically feed through to the calculation formulae.",null,null,null,null,null,null,null,null,null,null,null,"A4",{"$f":"'Scanning | Printing Calculator'!B10","v":0},{"$f":"N3*0.2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"'Scanning | Printing Calculator'!B11","v":0},{"$f":"N4*2","v":0}]
[null,"No. of pages",null,null,"Scanning Fees",null,null,null,null,null,null,null,"A2",{"$f":"'Scanning | Printing Calculator'!B12","v":0},{"$f":"N5*3.5","v":0}]
[null,"A3/A4",{"$f":"'Scanning | Printing Calculator'!B5","v":0},null,"No. of pages","Size","Cost (inc. GST)",null,null,null,null,null,"A1",{"$f":"'Scanning | Printing Calculator'!B13","v":0},{"$f":"N6*6.5","v":0}]
[null,"A2/Larger",{"$f":"'Scanning | Printing Calculator'!B6","v":0},null,"1 to 20","A3/A4",27.4]
[null,"TOTAL COST",{"$f":"C10+C14","v":0},null,"21 to 40","A3/A4",29.5,null,null,null,null,null,"Total",null,{"$f":"SUM(O3:O6)","v":0}]
[null,null,null,null,"41 to 60","A3/A4",33.5]
[null,"Calculations",{"$f":"IF(AND(C6>0,C6<21),G7,IF(AND(C6>20,C6<41),G8,IF(AND(C6>40,C6<61),G9,IF(AND(C6>60,C6<81),G10,IF(AND(C6>80,C6<101),G11,IF(AND(C6>100,C6<151),G12,IF(AND(C6>150,C6<251),G13,C11)))))))","v":0},null,"61 to 80","A3/A4",37.9]
[null,"A3/A4",{"$f":"IF(AND(C6>250,C6<351),G14,IF(AND(C6>350,C6<451),G15,IF(AND(C6>450,C6<551),G16,IF(AND(C6>550,C6<651),G17,IF(AND(C6>650,C6<751),G18,IF(AND(C6>750,C6<851),G19,IF(AND(C6>850,C6<951),G20,C12)))))))","v":0},null,"81 to 100","A3/A4",42]
[null,null,{"$f":"IF(AND(C6>951),G21,0)","v":0},null,"101 to 150","A3/A4",49.5]
[null,null,null,null,"151 to 250","A3/A4",70.5]
[null,"Calculations",{"$f":"IF(AND(C7>0,C7<21),G24,IF(AND(C7>20,C7<41),G25,IF(AND(C7>40,C7<61),G26,IF(AND(C7>60,C7<81),G27,IF(AND(C7>80,C7<101),G28,IF(AND(C7>100,C7<151),G29,IF(AND(C7>150,C7<251),G30,C15)))))))","v":0},null,"251 to 350","A3/A4",141]
[null,"A2 or Larger",{"$f":"IF(AND(C7>250,C7<351),G31,IF(AND(C7>350,C7<451),G32,IF(AND(C7>450,C7<551),G33,IF(AND(C7>550,C7<651),G34,IF(AND(C7>650,C7<751),G35,IF(AND(C7>750,C7<851),G36,IF(AND(C7>850,C7<951),G37,C16)))))))","v":0},null,"351 to 450","A3/A4",211.5]
[null,null,{"$f":"IF(AND(C7>951),G38,0)","v":0},null,"451 to 550","A3/A4",282]
[null,null,null,null,"551 to 650","A3/A4",352.5]
[null,null,null,null,"651 to 750","A3/A4",423]
[null,null,null,null,"751 to 850","A3/A4",493.5]
[null,null,null,null,"851 to 950","A3/A4",564]
[null,null,null,null,"951+","A3/A4",634.5]
[]
[null,null,null,null,"No. of pages","Size","Cost (inc. GST)"]
[null,null,null,null,"1 to 20","A2/Larger",27.5]
[null,null,null,null,"21 to 40","A2/Larger",37.9]
[null,null,null,null,"41 to 60","A2/Larger",59]
[null,null,null,null,"61 to 80","A2/Larger",80]
[null,null,null,null,"81 to 100","A2/Larger",100]
[null,null,null,null,"101 to 150","A2/Larger",138]
[null,null,null,null,"151 to 250","A2/Larger",160]
[null,null,null,null,"251 to 350","A2/Larger",320]
[null,null,null,null,"351 to 450","A2/Larger",480]
[null,null,null,null,"451 to 550","A2/Larger",640]
[null,null,null,null,"551 to 650","A2/Larger",800]
[null,null,null,null,"651 to 750","A2/Larger",960]
[null,null,null,null,"751 to 850","A2/Larger",1120]
[null,null,null,null,"851 to 950","A2/Larger",1280]
[null,null,null,null,"951+","A2/Larger",1440]

{"sheet":"Dropdowns","index":5,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["< Please Select >",null,"< Please Select >",null,"< Please Select >",null,"Inspection Type","Charge",null,null,null,"IssueConsent","Charge",null,null,"ItemNum","Charge"]
["Lodging",null,"Building (Hazards) Check",null,"Vetting",null,"< Please Select >",0,null,null,null,"Applicable",30,null,null,"< Please Select CCC Type>",0]
["Additional Information 1",null,"Planning Check",null,"Communication",null,"Residential",200,null,null,null,"Not Applicable",0,null,null,"No Code Compliance Certificate",0]
["Additional Information 2",null,"Drainage Report",null,"Processing",null,"Commercial",255,null,null,null,null,null,null,null,"Residential solid or liquid fuel heater",100]
["Additional Information 3",null,"PIM Administration",null,"RFI Processing",null,null,null,null,null,null,null,null,null,null,"Residential minor building work",126]
["Additional Information 4",null,"Specialists",null,"Structural Engineer",null,null,null,null,null,null,"FixedAdminFee","Charge",null,null,"Residential accessory buildings and residential alterations",220]
["Additional Information 5",null,"Other",null,"Geotech Engineer",null,null,null,null,null,null,"Applicable",175,null,null,"Residential new dwelling",360]
["Additional Information 6",null,"Vetting",null,"Fire Engineer",null,null,null,null,null,null,"Not Applicable",0,null,null,"Commercial 1-2, Residential multi-unit or alterations to a commercial 3 less than/equal to $500,000",550]
["Additional Information 7",null,"Admin",null,"Other Specialist Input",null,null,null,null,null,null,null,null,null,null,"Commercial 3 over $500,000",1200]
["Additional Information 8",null,null,null,"Meeting"]
["Additional Information 9",null,null,null,"Other"]
["Additional Information 10",null,null,null,"End Administration",null,null,null,null,null,null,"CT","Charge",null,null,"Type","Charge"]
["Additional Information 11",null,null,null,"Granting",null,null,null,null,null,null,"Applicable",14.4,null,null,"< Please Select Connections >",0]
["Additional Information 12",null,null,null,null,null,null,null,null,null,null,"Not Applicable",0,null,null,"No CCC Connection",0]
["Additional Information 13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Water Connection:",995]
["Additional Information 14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stormwater Opening:",125]
["Additional Information 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sewer Opening:",245]
["Additional Information 16",null,null,null,null,null,null,null,null,null,null,"PIMCOORD","Charge",null,null,"Vehicle Crossing Inspection:",153]
["Additional Information 17",null,null,null,null,null,null,null,null,null,null,"Applicable",30]
["Additional Information 18",null,null,null,null,null,null,null,null,null,null,"Not Applicable",0,null,null,"Type","Charge"]
["Additional Information 19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< Please Select Other Fees >",0]
["Additional Information 20",null,null,null,null,null,null,null,null,null,null,"ExtContract","Charge",null,null,"No Additional Fees",0]
[null,null,null,null,null,null,null,null,null,null,null,"Applicable","ENTER VALUE",null,null,"Electronic File Management:",52]
[null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",0,null,null,"Compliance Schedule (New):",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance Schedule (Amend):",250]
[null,null,null,null,null,null,null,null,null,null,null,"Electronic File","Charge",null,null,"Section 73 (Hazards):",420]
[null,null,null,null,null,null,null,null,null,null,null,"Applicable",52,null,null,"Section 75 (Multi Titles):",420]
[null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",0,null,null,"Commercial/Residential PFVS:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Fire Service Review:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Consent Authority Covenant:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scanning Costs",{"$f":"'Scanning Calculations'!C8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Printing Costs",{"$f":"'Scanning Calculations'!O8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other","ENTER VALUE"]

{"sheet":"Names of Officers","index":6,"n_rows":514,"n_cols":28,"rows_kept":514,"cut":false,"hidden":true,"merged":[]}
[]
[null,"F1","F2","F3","F4","F5","F6","F7","F8","F9","F10","F11","F12","F13","F14","F15","F16","F17","F18","F19","F20","F21","F22","F23","F24","F25","F26","F27"]
[null,"Name","Role"]
[null,"Please Select",null,null,null,0]
[null,"Aaron Edwards","Planner 2/3","2015-07-01","3999-12-31",37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num Dates",1]
[null,"Aaron Harrison","Opus Intermediate","2015-07-01","2016-02-25",26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num Rows",511]
[null,"Aaron Haymes","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Abdul Musif","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Adam Modica","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Adam Wang","BCO 1","2015-07-01","3999-12-31",1]
[null,"Adelina Pop","BCO 1","2015-07-01","3999-12-31",1]
[null,"Adrian Cosby","Drainage Site Audit 2","2015-07-01","3999-12-31",51]
[null,"Adrienne Slattery","Holmes Fire Experienced","2015-07-01","2017-04-30",19]
[null,"Adrienne Slattery","Snr Engineer/Team manager","2017-05-01","3999-12-31",6]
[null,"Agnes van der Erf","Environmental Health Officer","2015-07-01","3999-12-31",76]
[null,"Aimee Dodge","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Al Wilson","Opus Experienced","2015-07-01","2021-02-16",25]
[null,"Al Wilson","WSP Experienced","2021-02-17","3999-12-31",25]
[null,"Alan Wilson","Opus Experienced","2015-07-01","2018-07-01",25]
[null,"Alie Nieuwenhuize","Building Administrator","2015-07-01","2017-01-25",59]
[null,"Alie Nieuwenhuize","Building Officers (BWOF)","2017-01-26","3999-12-31",79]
[null,"Alison Tang","PBO/Specialist Engineer","2019-01-01","3999-12-31",5]
[null,"Alison Thompson","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Alistair Sharp","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Allen Pranesh","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Amarana Furminger","BCO 1","2015-07-01","2016-09-11",1]
[null,"Amarana Furminger","BCO 2","2016-09-12","3999-12-31",2]
[null,"Amber Watson","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Amon Brown","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Amy Barney","Building Administrator","2015-07-01","2018-01-31",59]
[null,"Amy Barney","Building Officers (BWOF)","2018-02-01","3999-12-31",79]
[null,"Amy Clark","Building Administrator","2015-07-01","2016-10-09",59]
[null,"Amy Clark","Planner 2/3","2016-10-10","2017-04-09",37]
[null,"Amy Clark","Building Administrator","2017-04-10","2017-08-04",59]
[null,"Amy Clark","Planner 2/3","2017-08-05","3999-12-31",37]
[null,"Amy Doherty","BCO 2","2016-09-12","3999-12-31",2]
[null,"Amy Law","BCO 1","2015-07-01","2016-09-11",1]
[null,"Amy Maxwell","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Ana de Jong","BCO 2","2015-07-01","2016-04-10",2]
[null,"Ana de Jong","BCO 3","2016-04-11","3999-12-31",3]
[null,"Ana Garrido Morales","BCO 3","2020-12-15","3999-12-31",3]
[null,"Andre Winkelman","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Andrei Cotiga","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Andrew Dimock","BCO 1","2015-07-01","2017-06-30",1]
[null,"Andrew Dimock","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Andrew Eames","BCO 1","2015-07-01","2016-09-11",1]
[null,"Andrew Eames","BCO 3","2016-09-12","3999-12-31",3]
[null,"Andrew Long","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Andrew Smith","Davis Ogilvie","2015-07-01","2021-02-17",69]
[null,"Andrew Stewart","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Andrew Stewart","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Andy Christofferson","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Andy Lee","BCO 2","2015-07-01","2017-02-22",2]
[null,"Andy Lee","BCO 3","2017-02-23","3999-12-31",3]
[null,"Angela O'Reilly","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Anne Edwards","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Aradhna Dutt","BCO 2","2015-07-01","3999-12-31",2]
[null,"Atheel Allos","GHD Expert","2015-07-01","3999-12-31",12]
[null,"Aurecon Expert","Aurecon Expert","2015-07-01","3999-12-31",8]
[null,"Aurecon Experienced","Aurecon Experienced","2015-07-01","3999-12-31",9]
[null,"Avau Tito","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Azeema Aman","Building Administrator","2015-07-01","2016-05-01",59]
[null,"Azeema Aman","BCO 1","2016-05-02","2017-06-30",1]
[null,"Azeema Aman","Vetting & Allocation","2017-07-01","2021-03-03",81]
[null,"Banny Singh","BCO 1","2015-07-01","2017-06-30",1]
[null,"Banny Singh","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Barbara Thomas","Regulatory Advice Officer","2015-07-01","2018-05-01",62]
[null,"Barbara Thomas","Planning Technician","2018-05-02","3999-12-31",63]
[null,"Barbara Tomlinson","Water Supply Plan Tec 2","2015-07-01","3999-12-31",54]
[null,"Barry Hemming","BCO 2","2015-07-01","3999-12-31",2]
[null,"Bastien Ballu","Fire Review Solutions","2019-07-29","2021-02-17",24]
[null,"Bee Geok Chan","BCO 1","2015-07-01","3999-12-31",1]
[null,"Ben Healy","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Bex Hawksworth","Davis Ogilvie","2018-03-12","2021-02-17",69]
[null,"Bill Dray","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Bill Harrington","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Biswadeep Ghosh","WSP","2015-07-01","3999-12-31",23]
[null,"Bjorn Raasch","Golder Associate Intermediate","2020-01-01","2021-02-16",17]
[null,"Bjorn Raasch","Davis Ogilvie","2021-02-17","3999-12-31",69]
[null,"Bob Pritchard","Subdivision Officer","2015-07-01","3999-12-31",42]
[null,"Bogdan Balliu-Bottesch","Opus Experienced","2015-07-01","2021-02-16",25]
[null,"Bogdan Balliu-Bottesch","WSP Experienced","2021-02-17","3999-12-31",25]
[null,"Bonnie Caesar","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Brenda Carter","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Brendon Guyton","Watkins","2015-07-01","2017-01-25",28]
[null,"Brendon Guyton","Focus Consultancy","2017-01-26","3999-12-31",70]
[null,"Brent Watkins","Watkins","2015-07-01","2017-01-25",28]
[null,"Brent Watkins","Inspector (DSC Group)","2017-01-26","3999-12-31",74]
[null,"Brian Norton","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Brian Norton","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Brian Wilson","Senior Buidling Officer (BWOF)","2015-07-01","3999-12-31",80]
[null,"Bridget Crouch (nee Rowe)","Building Administrator","2016-04-26","2016-08-21",59]
[null,"Bridget Crouch (nee Rowe)","BCO 1","2016-08-22","2017-06-30",1]
[null,"Bridget Crouch (nee Rowe)","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Bridget Rowe","Building Administrator","2015-07-01","2016-04-25",59]
[null,"Brittany Bradley Cane","Planner 2/3","2015-07-01","2020-11-20",37]
[null,"Brittany Ratka","Planner 2/3","2020-11-21","3999-12-31",37]
[null,"Bruce Craig","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Bruce Lyon","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Bryan McKay","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"BTW","BTW Structural","2015-07-01","3999-12-31",10]
[null,"Calibre Consulting Ltd","Calibre Experienced","2015-07-01","2021-02-17",61]
[null,"Callum Thornton","BCO 3","2020-05-04","3999-12-31",3]
[null,"Carlo Botha","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Cate McPherson","BCO 3","2020-05-04","3999-12-31",3]
[null,"Catherine Elvidge","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Catherine McPherson","BCO 3","2020-05-04","2020-11-01",3]
[null,"Catriona MacPherson","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Cecile Coll","Ext Spec/Consult Experienced","2015-07-01","3999-12-31",29]
[null,"Charlotte Walsh","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Chen (Weng-Kei Chen)","Roading input","2015-07-01","3999-12-31",48]
[null,"Chi Chi Wang","GHD Intermediate","2015-07-01","3999-12-31",14]
[null,"Chloe Stewart","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Chris Beckham","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Chris D'Arth","Stephenson & Turner Fire Exp","2021-02-17","3999-12-31",82]
[null,"Chris Hewlett","Planner Snr/Subdivision Officer etc","2015-07-01","2016-02-15",38]
[null,"Chris Hewlett","Snr BCO/Specialists","2016-02-16","2018-08-31",4]
[null,"Chris Hewlett","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Chris van den Bosch","Snr Engineer/Team manager","2015-07-01","2017-10-29",6]
[null,"Chris van den Bosch","BCO 3","2017-10-30","3999-12-31",3]
[null,"City Certifiers","City Certifiers","2015-07-01","2016-04-30",64]
[null,"City Certifiers","City Certifiers","2016-05-01","2017-01-25",64]
[null,"City Certifiers","City Certifiers","2017-01-26","3999-12-31",64]
[null,"Claire Barry","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Clare Dale (Revell)","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Claudia Stuart","Building Administrator","2015-07-01","2016-05-01",59]
[null,"Claudia Stuart","BCO 1","2016-05-02","2017-06-30",1]
[null,"Claudia Stuart","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Clement Maloney","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Clive Anderson","Golder Associate Expert","2015-07-01","2021-02-17",15]
[null,"Colleen Jones","BCO 2","2015-07-01","3999-12-31",2]
[null,"Craig Marshall","Regulatory Advice Officer","2015-07-01","2020-02-09",62]
[null,"Craig Marshall","Planning Technician","2020-02-10","3999-12-31",63]
[null,"Damien Singleton","BCO 1","2015-07-01","2018-09-18",1]
[null,"Damien Singleton","Inspector 3","2018-09-19","3999-12-31",33]
[null,"Daniel Kennedy","BCO 1","2015-07-01","3999-12-31",1]
[null,"Daniel Pau","Opus Graduate","2015-07-01","3999-12-31",27]
[null,"Daniel Roh","BCO 1","2017-09-11","3999-12-31",1]
[null,"Danielle Yeoman (nee Bailey)","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Dannielle Heron","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Darryn Fenton","BTW Structural","2015-07-01","3999-12-31",10]
[null,"Daryl Lim","Drainage Site Audit 1","2015-07-01","3999-12-31",50]
[null,"David Barry-Maculay","Golder Associate Experienced","2015-07-01","3999-12-31",16]
[null,"David Hutt","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"David Keohane","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"David Lee","GHD Expert","2015-07-01","3999-12-31",12]
[null,"David Mudu","Calibre Experienced","2015-07-01","3999-12-31",61]
[null,"Debbie Laffey","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Di Liang","BCO 1","2017-09-18","2020-04-14",1]
[null,"Donna Chapman","BCO 2","2017-07-01","3999-12-31",2]
[null,"Donna Cooper","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Donnick Mugusto","Spiire Experienced","2015-07-01","3999-12-31",21]
[null,"Doru Hozias","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"DSC Group","DSC Group","2016-09-01","2017-01-25",73]
[null,"DSC Group","DSC Group","2017-01-26","3999-12-31",73]
[null,"Dylan Hunt","Greenspace","2015-07-01","3999-12-31",49]
[null,"Ed Nystad","PBO/Specialist Engineer","2015-07-01","2020-11-01",5]
[null,"Edwin Nystad","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Eddie Newman","BCO 3","2015-07-01","2018-10-14",3]
[null,"Eddie Newman","Snr BCO/Specialists","2018-10-15","3999-12-31",4]
[null,"Elizabeth Alexander","BCO 1","2015-07-01","3999-12-31",1]
[null,"Elizabeth Ashwin","BCO 3","2019-10-03","2020-11-01",3]
[null,"Liz Ashwin","BCO 3","2019-10-03","3999-12-31",3]
[null,"Elizabeth Reeves","BCO 1","2015-07-01","2016-09-22",1]
[null,"Elizabeth Reeves","DSC Group","2016-09-23","2017-01-25",73]
[null,"Elizabeth Reeves","Inspector (DSC Group)","2017-01-26","3999-12-31",74]
[null,"Ellen Worthington","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Emma Chapman","Planner 2/3","2015-07-01","2018-05-01",37]
[null,"Emma Chapman","Planner Snr/Subdivision Officer etc","2018-05-02","3999-12-31",38]
[null,"Emma Taylor","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Eria Metcalf","Planner Snr/Subdivision Officer etc","2015-07-01","2021-03-18",38]
[null,"Erik Kunkel","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Evan Stuthridge","Inspector 3","2017-10-24","3999-12-31",33]
[null,"Faye Arona","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Florian Risse","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Focus Consultancy","Focus Consultancy","2015-07-01","2017-01-25",70]
[null,"Focus Consultancy","Focus Consultancy","2017-01-26","3999-12-31",70]
[null,"Fons van Wamal","BCO 2","2015-07-01","3999-12-31",2]
[null,"Frank Wood","Inspector (DSC Group)","2015-07-01","2017-01-25",74]
[null,"Frank Wood","Inspector (DSC Group)","2017-01-26","3999-12-31",74]
[null,"Freya Barnard","Building Administrator","2017-07-01","3999-12-31",59]
[null,"Gabrielle George","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Gavin Bailey","BCO 1","2015-07-01","3999-12-31",1]
[null,"George Enersen","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Georgia Brown","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Gina Sharp","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Gordon Taylor","Drainage Site Audit 3","2015-07-01","3999-12-31",52]
[null,"Grace Mitchell","Vetting & Allocation","2015-07-01","3999-12-31",81]
[null,"Graham Brown","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Graham Erikson","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Graham Mcllory","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Graham Mcllory","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Gray Packer","BCO 2","2015-07-01","3999-12-31",2]
[null,"Greg Paterson","BCO 2","2015-07-01","2016-04-10",2]
[null,"Greg Paterson","BCO 3","2016-04-11","3999-12-31",3]
[null,"Greg Sutherland","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Donna Grice","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Hamish Cocks","BCO 2","2015-07-01","2016-04-10",2]
[null,"Hamish Cocks","BCO 3","2016-04-11","2020-04-14",3]
[null,"Hanish Aroa","Opus Intermediate","2015-07-01","3999-12-31",26]
[null,"Hariharan Vishnu","Building Administrator","2019-06-24","2020-11-01",59]
[null,"Hari Kumar Vishnu","Building Administrator","2019-06-24","3999-12-31",59]
[null,"Heath Wells","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Helen Bealey","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Helen Hay","Building Administrator","2021-03-09","3999-12-31",59]
[null,"Helene Kirpensteijn","Planner 2/3","2015-07-28","3999-12-31",37]
[null,"Hermione Blair","Planner 2/3","2015-07-01","2018-05-01",37]
[null,"Hermione Blair","Planner Snr/Subdivision Officer etc","2018-05-02","3999-12-31",38]
[null,"Holly Gardiner","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Holly Luzak","Building Administrator","2015-07-01","2017-09-13",59]
[null,"Holly Luzak","Planner 2/3","2017-09-14","3999-12-31",37]
[null,"Holmes Fire Expert","Holmes Fire Expert","2015-07-01","3999-12-31",18]
[null,"Holmes Fire Experienced","Holmes Fire Experienced","2015-07-01","3999-12-31",19]
[null,"Huw Parker","Ext Spec/Consult Experienced","2015-07-01","2021-02-16",29]
[null,"Huw Parker","Golder Associate Experienced","2021-02-17","3999-12-31",67]
[null,"Ian Carstens","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Ian Craig","Drainage Site Audit 2","2015-07-01","3999-12-31",51]
[null,"Iris Brookland","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Iris Brookland","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Ian Burford","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Ian Johnson","Water Supply Plan 1","2015-07-01","2018-08-31",53]
[null,"Ian Johnson","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Isobel Garland","BCO 1","2017-07-01","3999-12-31",1]
[null,"Isobel Stout","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Jindina Locke ","Environmental Health Officer","2020-05-01","3999-12-31",76]
[null,"James Dismuke","Golder Associate Experienced","2015-07-01","3999-12-31",16]
[null,"James Kwon","Snr BCO/Specialists","2015-07-01","2020-04-01",4]
[null,"James Kwon","Snr Engineer/Team Manager","2020-04-02","3999-12-31",6]
[null,"James Marsh","BCO 3","2015-07-01","3999-12-31",3]
[null,"Jan Bochow","PBO/Specialist Engineer","2017-07-01","3999-12-31",5]
[null,"Jan Steenkamp","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Jason Dean","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Jason King","Stephenson & Turner Fire Exp","2017-12-15","2021-02-17",82]
[null,"Jason Roberts","Legal Services","2015-07-01","3999-12-31",58]
[null,"Jeck Icaro","BTW Structural","2015-07-01","3999-12-31",10]
[null,"Jeffrey XU","GHD Intermediate","2015-07-01","3999-12-31",14]
[null,"Jennifer Clarke","Snr BCO/Specialists","2015-07-01","2021-03-03",4]
[null,"Jennifer van Heerden","BCO 2","2015-07-01","3999-12-31",2]
[null,"Jeremy Chang","Holmes Fire Experienced","2015-07-01","3999-12-31",19]
[null,"Jessica Manhire","Planning Technician","2015-07-01","3999-12-31",63]
[null,"Jessy Roberts","Regulatory Advice Officer","2015-07-01","3999-12-31",62]
[null,"Jill Ryan","BCO 3","2015-07-01","2016-04-10",3]
[null,"Jill Ryan","Snr BCO/Specialists","2016-04-11","2020-04-14",4]
[null,"Jim Nguyen","BCO 2","2015-07-01","2016-04-10",2]
[null,"Jim Nguyen","BCO 3","2016-04-11","3999-12-31",3]
[null,"Jim Thompson","Spiire Intermediate","2015-07-01","3999-12-31",22]
[null,"Jo McAfee","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Jo Rayne","Building Administrator","2015-07-01","3999-12-31",59,null,"`"]
[null,"Joanna Petheram","Davis Ogilvie","2021-02-17","3999-12-31",69]
[null,"Johan Dalkie","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"John Blackwell","BCO 2","2015-07-01","3999-12-31",2]
[null,"John Gibson","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"John Hargraves","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"John Higgins","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"John James","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"John Richards","BCO 2","2015-07-01","3999-12-31",2]
[null,"John Thornton","Arborist/Tree protection","2015-07-01","3999-12-31",46]
[null,"Jonathan Nyman","Fire Review Solutions","2015-07-01","3999-12-31",24]
[null,"Joel Bensing","Golder Associate Intermediate","2015-07-01","3999-12-31",17]
[null,"Jolene Anderson","BCO 2","2015-07-01","2016-08-31",2]
[null,"Jolene Anderson","BCO 3","2016-09-01","3999-12-31",3]
[null,"Jon King","BCO 1","2015-07-01","2016-11-02",1]
[null,"Jon King","BCO 2","2016-11-03","3999-12-31",2]
[null,"Jono Boorer","BCO 1","2021-01-22","3999-12-31",1]
[null,"Judy Benyon","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Julie Hand","BCO 1","2015-07-01","3999-12-31",1]
[null,"Julie Villard","Snr BCO/Specialists","2017-07-01","3999-12-31",4]
[null,"Karen Fitzpatrick","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Kasuni Thewarapperuma","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Kate Askew","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Kate Biddlecombe","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Kate Graham","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Katherina Woodlock","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Katherine Hall","Snr BCO/Specialists","2015-07-01","2017-07-25",4]
[null,"Katharine Riley","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Kathryn Ross (Stapleton)","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Kathy McTigue","Building Administrator","2017-08-07","3999-12-31",59]
[null,"Calvin Hock","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Kawal Singh","PBO/Specialist Engineer","2019-01-01","3999-12-31",5]
[null,"Kelly Roe","BCO 1","2021-01-22","3999-12-31",1]
[null,"Kent Wilson","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Kerry Magnuson","BCO 2","2015-07-01","3999-12-31",2]
[null,"Kevin Maher","BCO 2","2015-07-01","2016-12-14",2]
[null,"Kevin Maher","Snr BCO/Specialists","2016-12-15","3999-12-31",4]
[null,"Kelvin Lim","BCO 1","2015-07-01","3999-12-31",1]
[null,"Kelvin Newman","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Kevin Thompson","Inspector 3","2017-10-24","3999-12-31",33]
[null,"Kevin Williams","Greenspace","2015-07-01","3999-12-31",49]
[null,"Kirsten Boyd","BCO 1","2015-07-01","2017-06-30",1]
[null,"Kirsten Boyd","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Kirsten Rayne","Environmental Health Officer","2016-07-01","3999-12-31",76]
[null,"Kris Davys","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Kristin McKee","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Kyle Atkins","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Kyle Lewis","BCO 2","2015-07-01","3999-12-31",2]
[null,"Laura Braddick","Planning Technician","2015-07-01","3999-12-31",63]
[null,"Leashelle Miller","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Leashelle Miller - STF","Specialist Task Facilitator","2015-07-01","3999-12-31",34]
[null,"Liam Allan","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Lianne McCone","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Lionel Bridger","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Lisa Arnott","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Lisa Bennett","BCO 2","2015-07-01","2016-05-15",2]
[null,"Lisa Bennett","BCO 3","2016-05-16","2016-11-24",3]
[null,"Lisa Bennett","Snr BCO/Specialists","2016-11-25","2020-04-14",4]
[null,"Lisa Kupenga","Building Administrator","2015-07-01","2018-10-28",59]
[null,"Lisa Kupenga","Building Officers (BWOF)","2018-10-29","3999-12-31",79]
[null,"Lisa McRae","Building Administrator","2021-03-01","3999-12-31",59]
[null,"Lisa Williams","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Liz Hislop","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Lizzie Spencer","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Llyod McLauchlan","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Lorraine Bell","Building Administrator","2017-07-01","3999-12-31",59]
[null,"Louisa Armstrong","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Lucie Hanrahan","BCO 1","2015-07-01","3999-12-31",1]
[null,"Luke De Schot","Golder Associate Intermediate","2021-01-19","2021-02-16",17]
[null,"Luke De Schot","WSP Intermediate","2021-02-17","3999-12-31",26]
[null,"Luke Wignall","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Lynette Daniell","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Mal Nash","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Malory Bloor","BCO 2","2015-07-01","3999-12-31",2]
[null,"Marilyn Regnault","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Manasi Vaidya","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Margaret Stoffel","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Margie Cook","Building Officers (BWOF)","2015-07-01","3999-12-31",79]
[null,"Marie-Claude Hebert","Golder Associate Intermediate","2015-07-01","3999-12-31",17]
[null,"Mark Cui","BCO 2","2020-04-01","3999-12-31",2]
[null,"Mark Furdson","Inspector (DSC Group)","2015-07-01","2016-08-25",74]
[null,"Mark Furdson","Inspector (DSC Group)","2016-08-26","3999-12-31",74]
[null,"Mark Mitchell","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Mark Ranfurly","BCO 3","2015-07-01","3999-12-31",3]
[null,"Mary Greening","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Matthew Klomp","Planning Technician","2015-07-01","2017-07-27",63]
[null,"Matthew Klomp","Planner 2/3","2017-07-28","3999-12-31",37]
[null,"Mel Lawson","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Melinda Smith","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Michael Bush","Opus Intermediate","2015-07-01","3999-12-31",26]
[null,"Michael Cullum","Opus Intermediate","2015-07-01","3999-12-31",26]
[null,"Michael Heather","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Michael Nilsson","BCO 3","2015-07-01","2016-04-10",3]
[null,"Michael Nilsson","Snr BCO/Specialists","2016-04-11","3999-12-31",4]
[null,"Michael Ostash","Arborist/Tree protection","2015-07-01","3999-12-31",46]
[null,"Michelle Jackson","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Michele McDonald","Snr BCO/Specialists","2017-07-24","2018-08-31",4]
[null,"Michele McDonald","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Michelle Reddock","BCO 1","2015-07-01","2017-06-30",1]
[null,"Michelle Reddock","Vetting & Allocation","2017-07-01","2020-11-01",81]
[null,"Michelle-Anne Reddock","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Morehu Rangi","Beca Fire Engineering","2015-07-01","3999-12-31",68]
[null,"Nathan Harris","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Nathan O'Connell","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Michael Price","Drainage Site Audit 2","2015-07-01","3999-12-31",51]
[null,"Naveen Kadaba","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Neil Donnellan","BCO 2","2015-07-01","2016-09-11",2]
[null,"Neil Donnellan","Snr BCO/Specialists","2016-09-12","3999-12-31",4]
[null,"Neil Eade","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Niamh Sheehy","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Nick Reuther","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Nick Van Voorthuysen","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Nick Van Voorthuysen","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Nick Waddington","GHD Expert","2015-07-01","2021-02-17",12]
[null,"Nicky McCook-Weir","BCO 1","2015-07-01","2016-11-02",1]
[null,"Nicky McCook-Weir","BCO 2","2016-11-03","3999-12-31",2]
[null,"Nico Chen","Specialist Task Facilitator","2015-07-01","3999-12-31",34]
[null,"Nigel Baker","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Nikii Steele (nee Sharpe)","BCO 1","2015-07-01","2017-06-30",1]
[null,"Nikii Steele (nee Sharpe)","Vetting & Allocation","2017-07-01","2018-09-18",81]
[null,"Nikii Steele (nee Sharpe)","Regulatory Advice Officer","2018-09-19","3999-12-31",62]
[null,"Nikki Donaldson","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Nitin Bhaskar","Golder Associate Intermediate","2020-01-01","2021-01-19",17]
[null,"Noemi Ponferrada","Building Officers (BWOF)","2015-07-01","3999-12-31",79]
[null,"Odette White","Planner 2/3","2015-07-01","2018-05-01",37]
[null,"Odette White","Planner Snr/Subdivision Officer etc","2018-05-02","3999-12-31",38]
[null,"PBC","PBC","2015-07-01","3999-12-31",78]
[null,"Paul Clarke","GHD Intermediate","2015-07-01","3999-12-31",14]
[null,"Paul Dickson","Greenspace","2015-07-01","3999-12-31",49]
[null,"Paul Dietsche","BCO 1","2015-07-01","3999-12-31",1]
[null,"Paul Hodson","BCO 2","2015-07-01","3999-12-31",2]
[null,"Paul Lowe","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Paul Mullen","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Paula Kloosterman","Environmental Health Officer","2016-07-01","3999-12-31",76]
[null,"Pauline Robinson","BCO 1","2015-07-01","2017-06-30",1]
[null,"Pauline Robinson","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Peter Congdon","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Peter Van der Zee","BCO 2","2015-07-01","2016-04-10",2]
[null,"Peter Van der Zee","BCO 3","2016-04-11","3999-12-31",3]
[null,"Peter Warriner","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Pumping Station Clearances","Pumping Station Clearances","2015-07-01","3999-12-31",57]
[null,"Phill Carr","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Phillip Hector","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Phillip Judge","Focus Consultancy","2015-07-01","2017-01-25",70]
[null,"Phillip Judge","Focus Consultancy","2017-01-26","3999-12-31",70]
[null,"Philip Xie","Opus Experienced","2015-07-01","2017-11-26",25]
[null,"Philip Xie","PBO/Specialist Engineer","2017-11-27","2019-12-08",5]
[null,"Philip Xie","Snr Engineer/Team manager","2019-12-09","3999-12-31",6]
[null,"Prasanna Kanniah","BCO 2","2020-04-01","3999-12-31",2]
[null,"Rachel Anderson","Building Administrator","2017-08-07","3999-12-31",59]
[null,"Rachel Cottam","Planner 2/3","2017-08-28","3999-12-31",37]
[null,"Rachel Dowers","BCO 1","2015-07-01","2017-06-30",1]
[null,"Rachel Dowers","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Raewyn Kinnis","Building Officers (BWOF)","2015-07-01","2020-04-14",79]
[null,"Ray Wong","PBO/Specialist Engineer","2020-03-05","3999-12-31",5]
[null,"Rebecca Gourlay","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Rebecca Astwood","Planner 2/3","2017-08-28","2021-03-18",37]
[null,"Rebecca Wills","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Reece Morgan","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Rex Belworthy","Water Supply Audit/Clearance","2015-07-01","3999-12-31",55]
[null,"Reynaldo Pagaduan Jr","BCO 2","2015-07-01","3999-12-31",2]
[null,"Ricardo Anderson","BCO 2","2015-07-01","3999-12-31",2]
[null,"Richard Gant","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Richard Lorgelly","BCO 1","2015-07-01","3999-12-31",1]
[null,"Richard Meekin","BCO 3","2015-07-01","3999-12-31",3]
[null,"Richard Wang","GHD Experienced","2015-07-01","3999-12-31",13]
[null,"Richard Zac","BCO 1","2015-07-01","3999-12-31",1]
[null,"Rob Carlisle","BCO 1","2015-07-01","3999-12-31",1]
[null,"Robert Copeland","BCO 1","2015-07-01","3999-12-31",1]
[null,"Robert Herbert","Watkins","2015-07-01","2017-01-25",28]
[null,"Robert Herbert","Inspector (DSC Group)","2017-01-26","3999-12-31",74]
[null,"Robert O'Connor","Legal Services","2015-07-01","3999-12-31",58]
[null,"Robert Skinner","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Rochelle Willis","Building Administrator","2017-07-01","3999-12-31",59]
[null,"Roland Basobas","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Rod Pulahinge","BCO 2","2015-07-01","2020-11-01",2]
[null,"Buddhika Srijith Rodrigo Pulahinge","BCO 2","2015-07-01","2021-03-02",2]
[null,"Buddhika Srijith Rodrigo Pulahinge","BCO 3","2021-03-03","3999-12-31",3]
[null,"Ronel Catalo","PBO/Specialist Engineer","2015-07-01","2016-07-10",5]
[null,"Ronel Catalo","Snr Engineer/Team Manager","2016-07-11","3999-12-31",6]
[null,"Rosemary Hoare","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Roy Eastman","Stormwater Eng","2015-07-01","3999-12-31",45]
[null,"Roy Gurney","As Built Info","2015-07-01","3999-12-31",56]
[null,"Russel Wedge","Greenspace","2015-07-01","3999-12-31",49]
[null,"Ruth Markham-Short","Planner 2/3","2015-07-01","2018-05-01",37]
[null,"Ruth Markham-Short","Planner Snr/Subdivision Officer etc","2018-05-02","3999-12-31",38]
[null,"Ryan Brosnahan","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Ryan Cooper","BCO 2","2015-07-01","2018-09-18",2]
[null,"Ryan Cooper","Snr BCO/Specialists","2018-09-19","3999-12-31",4]
[null,"Sahana Poojari","Building Administrator","2017-08-07","3999-12-31",59]
[null,"Sahand Rasoulipour","Fire Review Solutions","2020-04-17","3999-12-31",24]
[null,"Sarah Congdon","BCO 1","2017-07-01","3999-12-31",1]
[null,"Sarah Saxon","Planning Technician","2015-07-01","3999-12-31",63]
[null,"Sam Owles","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Sandi Rhynd","BCO 1","2015-07-01","3999-12-31",1]
[null,"Sanjay Dutt","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Scott Blair","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Sean Patterson","BCO 1","2015-07-01","2020-04-14",1]
[null,"Sean Ward","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Selva Muniswamy","Spiire Experienced","2015-07-01","3999-12-31",21]
[null,"Setareki Ha'angana","BCO 3","2015-07-01","3999-12-31",3]
[null,"Shane Bruyns","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Sheryl Keenan","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Sheryl Keenan","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Shona Jowett","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Simon Biggs","Opus Experienced","2015-07-01","2021-02-17",25]
[null,"Simon Fenton","Opus Intermediate","2015-07-01","3999-12-31",26]
[null,"Sonia Gilmour","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Sophie Bainbridge","Golder Associate Intermediate","2015-07-01","2021-02-17",17]
[null,"Spiire","Spiire Experienced","2015-07-01","3999-12-31",21]
[null,"Stacey Jung","Planning Technician","2019-09-02","3999-12-31",63]
[null,"Stephen Burrows","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Stephen McNamee","Inspector 3","2017-10-24","3999-12-31",33]
[null,"Steve Carrington","BCO 2","2015-07-01","2016-09-22",2]
[null,"Steve Carrington","DSC Group","2016-09-23","2017-01-25",73]
[null,"Steve Carrington","Inspector (DSC Group)","2017-01-26","3999-12-31",74]
[null,"Steve Gray","Greenspace","2015-07-01","3999-12-31",49]
[null,"Steve Walders","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Sue McKenzie","Building Administrator","2017-07-01","3999-12-31",59]
[null,"Suzanne Richmond","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Taka Sato","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Tammy Bruyns","Building Administrator","2015-07-01","2016-07-19",59]
[null,"Tammy Bruyns","BCO 1","2016-07-20","2017-06-30",1]
[null,"Tammy Bruyns","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Tania Byrnes","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Tania McGrath","BCO 2","2015-07-01","2016-05-31",2]
[null,"Tania McGrath","BCO 3","2016-06-01","2020-12-09",3]
[null,"Tania McGrath","PBO/Specialist Engineer","2020-12-10","3999-12-31",5]
[null,"Tanya Prinsloo","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Terry Sparks","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Tim Farrant","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Toby King","BCO 1","2015-07-01","2016-09-27",1]
[null,"Toby King","BCO 2","2016-09-28","2018-10-14",2]
[null,"Toby King","Snr BCO/Specialists","2018-10-15","3999-12-31",4]
[null,"Tom Arthur","Spiire Experienced","2015-07-01","3999-12-31",21]
[null,"Thomas Aspell","BCO 2","2015-07-01","2016-04-10",2]
[null,"Tom Aspell","BCO 3","2016-04-11","3999-12-31",3]
[null,"Tony Borkus","Drainage Site Audit 1","2015-07-01","3999-12-31",50]
[null,"Tony Croager","BCO 2","2015-07-01","3999-12-31",2]
[null,"Tony Parkes","Fire Matters","2015-07-01","3999-12-31",11]
[null,"Tracey Atherton","BCO 1","2015-07-01","2017-06-30",1]
[null,"Tracey Atherton","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Vanessa Hammond","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Victor Mthamo","Snr BCO/Specialists","2015-07-01","2018-08-31",4]
[null,"Victor Mthamo","PBO/Specialist Engineer","2018-09-01","3999-12-31",5]
[null,"Victor Wong","Specialist","2020-12-02","3999-12-31",81]
[null,"Vil Vabuils","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Vincent Wong","Snr Engineer/Team Manager","2015-07-01","2019-08-26",6]
[null,"Vincent Wong","PBO/Specialist Engineer","2019-08-27","2020-05-10",5]
[null,"Vincent Wong","Snr Engineer/Team manager","2020-05-11","3999-12-31",6]
[null,"Watkins Consultants","Watkins","2015-07-01","2016-08-25",28]
[null,"Watkins Consultants","Watkins","2016-08-26","2017-01-25",28]
[null,"Watkins Consultants","DSC Group","2017-01-26","3999-12-31",73]
[null,"Wayne Roden","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Wendy Baker","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[null,"Wendy Payne","BCO 1","2015-07-01","3999-12-31",1]
[null,"Yo-An Lin","BCO 1","2017-08-21","3999-12-31",1]
[null,"Yolanda Filipo","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Yvonne McDonald","Subdivision Officer","2015-07-01","3999-12-31",42]
[null,"Zarnaz Mehryar","Snr Engineer/Team Manager","2015-07-01","2018-06-08",6]
[null,"Zarnaz Mehryar","Opus Experienced","2018-06-09","2021-02-16",25]
[null,"Zarnaz Mehryar","WSP Experienced","2021-02-17","3999-12-31",25]
[null,"Zoe Dolling","Regulatory Advice Officer","2015-07-01","2021-01-22",62]
[null,"Zoe Hallam","Regulatory Advice Officer","2021-01-23","3999-12-31",62]
[null,"Other","Other","2015-07-01","3999-12-31",60]
[null,"Other","Other","2015-07-01","3999-12-31",60]
[null,"   ","do not select","2015-07-01","3999-12-31",90]

{"sheet":"DedupedNames","index":7,"n_rows":412,"n_cols":1,"rows_kept":412,"cut":false,"hidden":true,"merged":[]}
["Please Select"]
["Aaron Edwards"]
["Aaron Harrison"]
["Aaron Haymes"]
["Abdul Musif"]
["Adam Modica"]
["Adam Wang"]
["Adelina Pop"]
["Adrian Cosby"]
["Adrienne Slattery"]
["Agnes van der Erf"]
["Aimee Dodge"]
["Al Wilson"]
["Alan Wilson"]
["Alie Nieuwenhuize"]
["Alison Tang"]
["Alison Thompson"]
["Alistair Sharp"]
["Allen Pranesh"]
["Amarana Furminger"]
["Amber Watson"]
["Amon Brown"]
["Amy Barney"]
["Amy Clark"]
["Amy Doherty"]
["Amy Law"]
["Amy Maxwell"]
["Ana de Jong"]
["Ana Garrido Morales"]
["Andre Winkelman"]
["Andrei Cotiga"]
["Andrew Dimock"]
["Andrew Eames"]
["Andrew Long"]
["Andrew Smith"]
["Andrew Stewart"]
["Andy Christofferson"]
["Andy Lee"]
["Angela O'Reilly"]
["Anne Edwards"]
["Aradhna Dutt"]
["Atheel Allos"]
["Aurecon Expert"]
["Aurecon Experienced"]
["Avau Tito"]
["Azeema Aman"]
["Banny Singh"]
["Barbara Thomas"]
["Barbara Tomlinson"]
["Barry Hemming"]
["Bastien Ballu"]
["Bee Geok Chan"]
["Ben Healy"]
["Bex Hawksworth"]
["Bill Dray"]
["Bill Harrington"]
["Biswadeep Ghosh"]
["Bjorn Raasch"]
["Bob Pritchard"]
["Bogdan Balliu-Bottesch"]
["Bonnie Caesar"]
["Brenda Carter"]
["Brendon Guyton"]
["Brent Watkins"]
["Brian Norton"]
["Brian Wilson"]
["Bridget Crouch (nee Rowe)"]
["Bridget Rowe"]
["Brittany Bradley Cane"]
["Brittany Ratka"]
["Bruce Craig"]
["Bruce Lyon"]
["Bryan McKay"]
["BTW"]
["Calibre Consulting Ltd"]
["Callum Thornton"]
["Carlo Botha"]
["Cate McPherson"]
["Catherine Elvidge"]
["Catherine McPherson"]
["Catriona MacPherson"]
["Cecile Coll"]
["Charlotte Walsh"]
["Chen (Weng-Kei Chen)"]
["Chi Chi Wang"]
["Chloe Stewart"]
["Chris Beckham"]
["Chris D'Arth"]
["Chris Hewlett"]
["Chris van den Bosch"]
["City Certifiers"]
["Claire Barry"]
["Clare Dale (Revell)"]
["Claudia Stuart"]
["Clement Maloney"]
["Clive Anderson"]
["Colleen Jones"]
["Craig Marshall"]
["Damien Singleton"]
["Daniel Kennedy"]
["Daniel Pau"]
["Daniel Roh"]
["Danielle Yeoman (nee Bailey)"]
["Dannielle Heron"]
["Darryn Fenton"]
["Daryl Lim"]
["David Barry-Maculay"]
["David Hutt"]
["David Keohane"]
["David Lee"]
["David Mudu"]
["Debbie Laffey"]
["Di Liang"]
["Donna Chapman"]
["Donna Cooper"]
["Donnick Mugusto"]
["Doru Hozias"]
["DSC Group"]
["Dylan Hunt"]
["Ed Nystad"]
["Edwin Nystad"]
["Eddie Newman"]
["Elizabeth Alexander"]
["Elizabeth Ashwin"]
["Liz Ashwin"]
["Elizabeth Reeves"]
["Ellen Worthington"]
["Emma Chapman"]
["Emma Taylor"]
["Eria Metcalf"]
["Erik Kunkel"]
["Evan Stuthridge"]
["Faye Arona"]
["Florian Risse"]
["Focus Consultancy"]
["Fons van Wamal"]
["Frank Wood"]
["Freya Barnard"]
["Gabrielle George"]
["Gavin Bailey"]
["George Enersen"]
["Georgia Brown"]
["Gina Sharp"]
["Gordon Taylor"]
["Grace Mitchell"]
["Graham Brown"]
["Graham Erikson"]
["Graham Mcllory"]
["Gray Packer"]
["Greg Paterson"]
["Greg Sutherland"]
["Donna Grice"]
["Hamish Cocks"]
["Hanish Aroa"]
["Hariharan Vishnu"]
["Hari Kumar Vishnu"]
["Heath Wells"]
["Helen Bealey"]
["Helen Hay"]
["Helene Kirpensteijn"]
["Hermione Blair"]
["Holly Gardiner"]
["Holly Luzak"]
["Holmes Fire Expert"]
["Holmes Fire Experienced"]
["Huw Parker"]
["Ian Carstens"]
["Ian Craig"]
["Iris Brookland"]
["Ian Burford"]
["Ian Johnson"]
["Isobel Garland"]
["Isobel Stout"]
["Jindina Locke "]
["James Dismuke"]
["James Kwon"]
["James Marsh"]
["Jan Bochow"]
["Jan Steenkamp"]
["Jason Dean"]
["Jason King"]
["Jason Roberts"]
["Jeck Icaro"]
["Jeffrey XU"]
["Jennifer Clarke"]
["Jennifer van Heerden"]
["Jeremy Chang"]
["Jessica Manhire"]
["Jessy Roberts"]
["Jill Ryan"]
["Jim Nguyen"]
["Jim Thompson"]
["Jo McAfee"]
["Jo Rayne"]
["Joanna Petheram"]
["Johan Dalkie"]
["John Blackwell"]
["John Gibson"]
["John Hargraves"]
["John Higgins"]
["John James"]
["John Richards"]
["John Thornton"]
["Jonathan Nyman"]
["Joel Bensing"]
["Jolene Anderson"]
["Jon King"]
["Jono Boorer"]
["Judy Benyon"]
["Julie Hand"]
["Julie Villard"]
["Karen Fitzpatrick"]
["Kasuni Thewarapperuma"]
["Kate Askew"]
["Kate Biddlecombe"]
["Kate Graham"]
["Katherina Woodlock"]
["Katherine Hall"]
["Katharine Riley"]
["Kathryn Ross (Stapleton)"]
["Kathy McTigue"]
["Calvin Hock"]
["Kawal Singh"]
["Kelly Roe"]
["Kent Wilson"]
["Kerry Magnuson"]
["Kevin Maher"]
["Kelvin Lim"]
["Kelvin Newman"]
["Kevin Thompson"]
["Kevin Williams"]
["Kirsten Boyd"]
["Kirsten Rayne"]
["Kris Davys"]
["Kristin McKee"]
["Kyle Atkins"]
["Kyle Lewis"]
["Laura Braddick"]
["Leashelle Miller"]
["Leashelle Miller - STF"]
["Liam Allan"]
["Lianne McCone"]
["Lionel Bridger"]
["Lisa Arnott"]
["Lisa Bennett"]
["Lisa Kupenga"]
["Lisa McRae"]
["Lisa Williams"]
["Liz Hislop"]
["Lizzie Spencer"]
["Llyod McLauchlan"]
["Lorraine Bell"]
["Louisa Armstrong"]
["Lucie Hanrahan"]
["Luke De Schot"]
["Luke Wignall"]
["Lynette Daniell"]
["Mal Nash"]
["Malory Bloor"]
["Marilyn Regnault"]
["Manasi Vaidya"]
["Margaret Stoffel"]
["Margie Cook"]
["Marie-Claude Hebert"]
["Mark Cui"]
["Mark Furdson"]
["Mark Mitchell"]
["Mark Ranfurly"]
["Mary Greening"]
["Matthew Klomp"]
["Mel Lawson"]
["Melinda Smith"]
["Michael Bush"]
["Michael Cullum"]
["Michael Heather"]
["Michael Nilsson"]
["Michael Ostash"]
["Michelle Jackson"]
["Michele McDonald"]
["Michelle Reddock"]
["Michelle-Anne Reddock"]
["Morehu Rangi"]
["Nathan Harris"]
["Nathan O'Connell"]
["Michael Price"]
["Naveen Kadaba"]
["Neil Donnellan"]
["Neil Eade"]
["Niamh Sheehy"]
["Nick Reuther"]
["Nick Van Voorthuysen"]
["Nick Waddington"]
["Nicky McCook-Weir"]
["Nico Chen"]
["Nigel Baker"]
["Nikii Steele (nee Sharpe)"]
["Nikki Donaldson"]
["Nitin Bhaskar"]
["Noemi Ponferrada"]
["Odette White"]
["PBC"]
["Paul Clarke"]
["Paul Dickson"]
["Paul Dietsche"]
["Paul Hodson"]
["Paul Lowe"]
["Paul Mullen"]
["Paula Kloosterman"]
["Pauline Robinson"]
["Peter Congdon"]
["Peter Van der Zee"]
["Peter Warriner"]
["Pumping Station Clearances"]
["Phill Carr"]
["Phillip Hector"]
["Phillip Judge"]
["Philip Xie"]
["Prasanna Kanniah"]
["Rachel Anderson"]
["Rachel Cottam"]
["Rachel Dowers"]
["Raewyn Kinnis"]
["Ray Wong"]
["Rebecca Gourlay"]
["Rebecca Astwood"]
["Rebecca Wills"]
["Reece Morgan"]
["Rex Belworthy"]
["Reynaldo Pagaduan Jr"]
["Ricardo Anderson"]
["Richard Gant"]
["Richard Lorgelly"]
["Richard Meekin"]
["Richard Wang"]
["Richard Zac"]
["Rob Carlisle"]
["Robert Copeland"]
["Robert Herbert"]
["Robert O'Connor"]
["Robert Skinner"]
["Rochelle Willis"]
["Roland Basobas"]
["Rod Pulahinge"]
["Buddhika Srijith Rodrigo Pulahinge"]
["Ronel Catalo"]
["Rosemary Hoare"]
["Roy Eastman"]
["Roy Gurney"]
["Russel Wedge"]
["Ruth Markham-Short"]
["Ryan Brosnahan"]
["Ryan Cooper"]
["Sahana Poojari"]
["Sahand Rasoulipour"]
["Sarah Congdon"]
["Sarah Saxon"]
["Sam Owles"]
["Sandi Rhynd"]
["Sanjay Dutt"]
["Scott Blair"]
["Sean Patterson"]
["Sean Ward"]
["Selva Muniswamy"]
["Setareki Ha'angana"]
["Shane Bruyns"]
["Sheryl Keenan"]
["Shona Jowett"]
["Simon Biggs"]
["Simon Fenton"]
["Sonia Gilmour"]
["Sophie Bainbridge"]
["Spiire"]
["Stacey Jung"]
["Stephen Burrows"]
["Stephen McNamee"]
["Steve Carrington"]
["Steve Gray"]
["Steve Walders"]
["Sue McKenzie"]
["Suzanne Richmond"]
["Taka Sato"]
["Tammy Bruyns"]
["Tania Byrnes"]
["Tania McGrath"]
["Tanya Prinsloo"]
["Terry Sparks"]
["Tim Farrant"]
["Toby King"]
["Tom Arthur"]
["Thomas Aspell"]
["Tom Aspell"]
["Tony Borkus"]
["Tony Croager"]
["Tony Parkes"]
["Tracey Atherton"]
["Vanessa Hammond"]
["Victor Mthamo"]
["Victor Wong"]
["Vil Vabuils"]
["Vincent Wong"]
["Watkins Consultants"]
["Wayne Roden"]
["Wendy Baker"]
["Wendy Payne"]
["Yo-An Lin"]
["Yolanda Filipo"]
["Yvonne McDonald"]
["Zarnaz Mehryar"]
["Zoe Dolling"]
["Zoe Hallam"]
["Other"]
["   "]

{"sheet":"Role Fee Structure","index":8,"n_rows":90,"n_cols":28,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Role","Role Value2","Effective Start Date","Effective End Date","2016","2017","2018","2019","2020","2021","2022","F13","F14","F15","F16","F17","F18","F19","F20","F21","F22","F23","F24","F25","F26","F27","F28"]
[null,"Please Select",null,null,null,0,0,0,0,0,0]
[null,"BCO 1",1,"2015-07-01","3999-12-31",173,173,210,210,210,210,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num Dates",7]
[null,"BCO 2",2,"2015-07-01","3999-12-31",200,200,210,210,210,210,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num Rows",87]
[null,"BCO 3",3,"2015-07-01","3999-12-31",220,220,210,210,210,210]
[null,"Snr BCO/Specialists",4,"2015-07-01","3999-12-31",236,236,243,245,245,245]
[null,"PBO/Specialist Engineer",5,"2015-07-01","3999-12-31",273,273,275,275,275,275]
[null,"Snr Engineer/Team Manager",6,"2015-07-01","3999-12-31",294,294,294,294,294,294]
[null,"Ext Spec/Consult Expert",7,"2015-07-01","3999-12-31",0,0,0,0,0,0]
[null,"Aurecon Expert",8,"2015-07-01","3999-12-31",330,330,330,330,330,330]
[null,"Aurecon Experienced",9,"2015-07-01","3999-12-31",265,265,265,265,265,265]
[null,"BTW Structural",10,"2015-07-01","3999-12-31",225,225,225,225,225,225]
[null,"DSC Group",73,"2016-09-01","2017-01-25",157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001]
[null,"DSC Group",73,"2017-01-26","3999-12-31",200,200,210,210,210,210]
[null,"Fire Matters",11,"2015-07-01","3999-12-31",235,235,235,235,235,235]
[null,"GHD Expert",12,"2015-07-01","3999-12-31",260,260,260,294,294,294]
[null,"GHD Experienced",13,"2015-07-01","3999-12-31",220,220,220,294,294,294]
[null,"GHD Intermediate",14,"2015-07-01","3999-12-31",185,185,185,275,275,275]
[null,"Golder Associate Expert",15,"2015-07-01","3999-12-31",375,375,375,294,294,294]
[null,"Golder Associate Experienced",16,"2015-07-01","3999-12-31",265,265,265,294,294,294]
[null,"Golder Associate Intermediate",17,"2015-07-01","3999-12-31",230,230,230,275,275,275]
[null,"Holmes Fire Expert",18,"2015-07-01","3999-12-31",305,305,305,0,0,0]
[null,"Holmes Fire Experienced",19,"2015-07-01","3999-12-31",295,295,295,0,0,0]
[null,"Spiire Expert",20,"2015-07-01","3999-12-31",0,0,0,0,0,0]
[null,"Spiire Experienced",21,"2015-07-01","3999-12-31",235,235,235,294,294,294]
[null,"Spiire Intermediate",22,"2015-07-01","3999-12-31",210,210,210,275,275,275]
[null,"WSP",23,"2015-07-01","3999-12-31",250,250,250,0,0,0]
[null,"Fire Review Solutions",24,"2015-07-01","3999-12-31",235,235,235,294,294,294]
[null,"WSP Experienced",25,"2021-02-17","3999-12-31",265,265,265,294,294,294]
[null,"WSP Intermediate",26,"2021-02-17","3999-12-31",205,205,205,275,275,275]
[null,"WSP Graduate",27,"2021-02-17","3999-12-31",200,200,200,275,275,275]
[null,"Opus Experienced",25,"2015-07-01","2021-02-16",265,265,265,294,294,294]
[null,"Opus Intermediate",26,"2015-07-01","2021-02-16",205,205,205,275,275,275]
[null,"Opus Graduate",27,"2015-07-01","2021-02-16",200,200,200,275,275,275]
[null,"Watkins",28,"2015-07-01","2016-08-25",149.5,149.5,149.5,149.5,149.5,149.5]
[null,"Watkins",28,"2016-08-26","3999-12-31",157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001,157.55000000000001]
[null,"Ext Spec/Consult Experienced",29,"2015-07-01","3999-12-31",265,265,265,294,294,294]
[null,"Building Inspection Coord",30,"2015-07-01","3999-12-31",115,115,120,120,120,120]
[null,"Inspector 1",31,"2015-07-01","3999-12-31",173,173,210,210,210,210]
[null,"Inspector 2",32,"2015-07-01","3999-12-31",200,200,210,210,210,210]
[null,"Inspector 3",33,"2015-07-01","3999-12-31",220,220,210,210,210,210]
[null,"Specialist Task Facilitator",34,"2015-07-01","3999-12-31",173,173,178,180,180,180]
[null,"Team Manager",35,"2015-07-01","3999-12-31",294,294,294,294,294,294]
[null,"Planner Admin",36,"2015-07-01","3999-12-31",100,100,105,105,105,105]
[null,"Planner 2/3",37,"2015-07-01","3999-12-31",180,180,185,185,185,185]
[null,"Planner Snr/Subdivision Officer etc",38,"2015-07-01","3999-12-31",200,200,200,200,200,200]
[null,"Internal Spec - Jnr/Int",39,"2015-07-01","3999-12-31",180,180,185,185,185,185]
[null,"Internal Spec - Snr",40,"2015-07-01","3999-12-31",200,200,205,205,205,205]
[null,"Subdivision Advisory",41,"2015-07-01","3999-12-31",200,200,200,200,200,200]
[null,"Subdivision Officer",42,"2015-07-01","3999-12-31",200,200,200,200,200,200]
[null,"Subdivision Engineer",43,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"Fire & Civil Eng Input",44,"2015-07-01","3999-12-31",200,200,200,200,200,200]
[null,"Stormwater Eng",45,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"Arborist/Tree protection",46,"2015-07-01","3999-12-31",180,180,180,185,185,185]
[null,"EHO (NES input)",47,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"Roading input",48,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"Greenspace",49,"2015-07-01","3999-12-31",225,225,225,205,205,205]
[null,"Drainage Site Audit 1",50,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"Drainage Site Audit 2",51,"2015-07-01","3999-12-31",150,150,150,155,155,155]
[null,"Drainage Site Audit 3",52,"2015-07-01","3999-12-31",180,180,180,185,185,185]
[null,"Water Supply Plan 1",53,"2015-07-01","3999-12-31",180,180,180,185,185,185]
[null,"Water Supply Plan Tec 2",54,"2015-07-01","3999-12-31",150,150,150,155,155,155]
[null,"Water Supply Audit/Clearance",55,"2015-07-01","3999-12-31",200,200,200,205,205,205]
[null,"As Built Info",56,"2015-07-01","3999-12-31",180,180,180,185,185,185]
[null,"Pumping Station Clearances",57,"2015-07-01","3999-12-31",180,180,180,185,185,185]
[null,"Legal Services",58,"2015-07-01","3999-12-31",200,200,200,200,200,200]
[null,"Building Administrator",59,"2015-07-01","3999-12-31",115,115,120,120,120,120]
[null,"Other",60,"2015-07-01","3999-12-31",0,0,0,0,0,0]
[null,"Inspector (DSC Group)",74,"2015-07-01","2017-01-25",178.25,178.25,178.25,178.25,178.25,178.25]
[null,"Inspector (DSC Group)",74,"2017-01-26","3999-12-31",200,200,200,200,200,200]
[null,"Calibre Experienced",61,"2015-07-01","3999-12-31",235,235,235,275,275,275]
[null,"Regulatory Advice Officer",62,"2015-07-01","3999-12-31",115,115,120,120,120,120]
[null,"Planning Technician",63,"2015-07-01","3999-12-31",150,150,155,155,155,155]
[null,"City Certifiers",64,"2015-07-01","2016-04-30",149.5,149.5,149.5,149.5,149.5,149.5]
[null,"City Certifiers",64,"2016-05-01","2017-01-25",172.5,172.5,172.5,172.5,172.5,172.5]
[null,"City Certifiers",64,"2017-01-26","3999-12-31",200,200,210,210,210,210]
[null,"Planning Engineer",66,"2015-07-01","3999-12-31",236,236,236,236,236,236]
[null,"Golder Associate Experienced",67,"2015-07-01","3999-12-31",315,315,315,294,294,294]
[null,"Beca Fire Engineering",68,"2015-07-01","3999-12-31",265,265,265,275,275,275]
[null,"Davis Ogilvie",69,"2015-07-01","3999-12-31",215,215,215,275,275,275]
[null,"Focus Consultancy",70,"2015-07-01","2017-01-25",149.5,149.5,149.5,149.5,149.5,149.5]
[null,"Focus Consultancy",70,"2017-01-26","3999-12-31",200,200,210,210,210,210]
[null,"PBC",78,"2015-07-01","3999-12-31",200,200,210,210,210,210]
[null,"Building Officers (BWOF)",79,"2015-07-01","3999-12-31",173,173,178,180,180,180]
[null,"Senior Buidling Officer (BWOF)",80,"2015-07-01","3999-12-31",220,220,243,245,245,245]
[null,"Vetting & Allocation",81,"2015-07-01","3999-12-31",173,173,178,180,180,180]
[null,"Environmental Health Officer",76,"2016-07-01","3999-12-31",0,0,120,120,120,210]
[null,"Stephenson & Turner Fire Exp",82,"2017-12-15","3999-12-31",0,243,243,294,294,294]
[null,"do not select",90,"2015-07-01","3999-12-31",0,0,0,0,0,0]