{"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":150,"n_cols":27,"rows_kept":150,"cut":false,"hidden":false,"merged":[[143,1,143,4],[145,1,145,4],[147,1,147,4],[149,1,149,4],[138,1,138,4],[141,1,141,4],[142,1,142,4],[139,1,139,5],[126,1,126,5],[2,0,2,4],[102,0,102,6],[98,0,98,2],[99,0,99,2],[100,4,100,5],[97,0,97,2],[21,2,21,4],[4,5,4,6],[6,0,6,6],[15,0,15,6],[24,0,24,6],[29,0,29,6],[95,0,95,6],[92,3,92,4],[89,3,89,4],[90,3,90,4],[93,3,93,4],[4,3,4,4],[120,6,121,6],[120,0,121,5],[114,4,114,5],[105,4,105,5],[103,2,103,3],[104,2,104,3],[103,4,103,5],[104,4,104,5],[118,0,118,5],[107,0,107,6],[109,1,109,3],[110,1,110,3],[116,0,116,5]]}
[]
[]
["Consent Fee Summary (Building Consent)"]
[]
["Consent Reference Number:","BCN/2017/2013","Consent Address:","80 Byron Street",null,"B103 LU: 01.07.16 LR: 01.07.16 v20"]
[]
["Accept:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["Lodging",null,"Bruce Lyon","2017-03-23",0.25,{"$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":115},{"$f":"IF(C9=\"\", \" \",$E9*$F9)","v":28.75},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D9)>6,YEAR(D9)+1,YEAR(D9)),\"####\")","v":"2017"},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}]
["Additional Information 1","ADD/2017/3795","Rebecca Gourlay","2017-04-05",0.17,{"$f":"IF(C10=\"\",\" \",SUMPRODUCT((AA10=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(X10=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D10>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D10<=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":115},{"$f":"IF(C10=\"\", \" \",$E10*$F10)","v":19.55},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D10)>6,YEAR(D10)+1,YEAR(D10)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C10=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D10>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D10<=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}]
["Additional Information 2","ADD/2017/8090 8093","Allen Pranesh","2017-07-12",0.17,{"$f":"IF(C11=\"\",\" \",SUMPRODUCT((AA11=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(X11=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D11>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D11<=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(C11=\"\", \" \",$E11*$F11)","v":20.400000000000002},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D11)>6,YEAR(D11)+1,YEAR(D11)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C11=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D11>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D11<=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}]
["Additional Information 3","ADD/2017/8865","Jo Rayne","2017-07-31",0.17,{"$f":"IF(C12=\"\",\" \",SUMPRODUCT((AA12=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(X12=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D12>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D12<=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(C12=\"\", \" \",$E12*$F12)","v":20.400000000000002},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D12)>6,YEAR(D12)+1,YEAR(D12)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C12=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D12>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D12<=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}]
["Additional Information 4","ADD/2017/9070","Jo Rayne","2017-08-02",0.17,{"$f":"IF(C13=\"\",\" \",SUMPRODUCT((AA13=OFFSET('Role Fee Structure'!$C$4,0,0,'Role Fee Structure'!$AB$5))*(X13=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D13>=OFFSET('Role Fee Structure'!$D$4,0,0,'Role Fee Structure'!$AB$5))*(D13<=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(C13=\"\", \" \",$E13*$F13)","v":20.400000000000002},null,null,null,null,{"$f":"$A$7","v":"Accept:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D13)>6,YEAR(D13)+1,YEAR(D13)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C13=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D13>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D13<=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":109.50000000000001}]
[null,null," "]
["PIM/Development Check:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["Building (Hazards) Check",null,"Ed Nystad","2017-03-23",0.33,{"$f":"IF(C18=\"\",\" \",SUMPRODUCT((AA18=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X18=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D18>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D18<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":273},{"$f":"IF(C18=\"\", \" \",$E18*$F18)","v":90.09},null,null,null,null,{"$f":"$A$16","v":"PIM/Development Check:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D18)>6,YEAR(D18)+1,YEAR(D18)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C18=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D18>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D18<=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":5}]
["Drainage Report",null,"Heath Wells","2017-03-24",0.17,{"$f":"IF(C19=\"\",\" \",SUMPRODUCT((AA19=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X19=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D19>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D19<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":273},{"$f":"IF(C19=\"\", \" \",$E19*$F19)","v":46.410000000000004},null,null,null,null,"PIM/Development Check:",null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D19)>6,YEAR(D19)+1,YEAR(D19)),\"####\")","v":"2017"},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":5}]
["PIM Administration",null,"Lynette Daniell","2017-04-04",0.25,{"$f":"IF(C20=\"\",\" \",SUMPRODUCT((AA20=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X20=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D20>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D20<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":115},{"$f":"IF(C20=\"\", \" \",$E20*$F20)","v":28.75},null,null,null,null,"PIM/Development Check:",null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D20)>6,YEAR(D20)+1,YEAR(D20)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C20=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D20>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D20<=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}]
["Planning Check",null,"Peter Warriner","2017-04-03",0.75,{"$f":"IF(C21=\"\",\" \",SUMPRODUCT((AA21=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X21=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D21>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D21<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":180},{"$f":"IF(C21=\"\", \" \",$E21*$F21)","v":135},null,null,null,null,"PIM/Development Check:",null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D21)>6,YEAR(D21)+1,YEAR(D21)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C21=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D21>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D21<=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":37}]
["PIM Coordinator Sign-off"," ",null,null,null,"Applicable",30,null,null,null,null,"PIM/Development Check:"]
[null,null,null,null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$16,$G:$G)","v":330.25}]
[null," "]
["Pre-acceptance Technical Review:"]
["Type:","Comments:","Officer Name: ","Date: ","Hours Worked:","Rate Per Hour:","Fee:"]
["Pre-acceptance technical review",null,"Banny Singh","2017-03-23",1,{"$f":"IF(C27=\"\",\" \",SUMPRODUCT((AA27=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X27=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D27>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D27<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":173},{"$f":"IF(C27=\"\", \" \",$E27*$F27)","v":173},null,null,null,null,{"$f":"$A$25","v":"Pre-acceptance Technical Review:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D27)>6,YEAR(D27)+1,YEAR(D27)),\"####\")","v":"2017"},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":1}]
[null," "," ",null,null,"Total Fee:",{"$f":"SUMIF($L:$L,$A$25,$G:$G)","v":173}]
[]
["Process and Grant:"]
["Type:","Comments:","Officer Name:","Date:","Hours Worked:","Rate Per Hour:","Fee:"]
["Processing","Civil","Donnick Mugusto","2017-04-06",1,{"$f":"IF(C32=\"\",\" \",SUMPRODUCT((AA32=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X32=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D32>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D32<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C32=\"\", \" \",$E32*$F32)","v":235},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D32)>6,YEAR(D32)+1,YEAR(D32)),\"####\")","v":"2017"},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":21}]
["Processing","Civil","Donnick Mugusto","2017-04-09",1.25,{"$f":"IF(C33=\"\",\" \",SUMPRODUCT((AA33=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X33=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D33>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D33<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C33=\"\", \" \",$E33*$F33)","v":293.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D33)>6,YEAR(D33)+1,YEAR(D33)),\"####\")","v":"2017"},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":21}]
["Processing","Civil","Donnick Mugusto","2017-07-13",1.25,{"$f":"IF(C34=\"\",\" \",SUMPRODUCT((AA34=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X34=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D34>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D34<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C34=\"\", \" \",$E34*$F34)","v":293.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D34)>6,YEAR(D34)+1,YEAR(D34)),\"####\")","v":"2018"},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":21}]
["Fire Engineer",null,"Adrienne Slattery","2017-04-03",0.25,{"$f":"IF(C35=\"\",\" \",SUMPRODUCT((AA35=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X35=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D35>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D35<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":295},{"$f":"IF(C35=\"\", \" \",$E35*$F35)","v":73.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D35)>6,YEAR(D35)+1,YEAR(D35)),\"####\")","v":"2017"},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":19}]
["Fire Engineer",null,"Adrienne Slattery","2017-04-10",1,{"$f":"IF(C36=\"\",\" \",SUMPRODUCT((AA36=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X36=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D36>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D36<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":295},{"$f":"IF(C36=\"\", \" \",$E36*$F36)","v":295},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D36)>6,YEAR(D36)+1,YEAR(D36)),\"####\")","v":"2017"},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":19}]
["Fire Engineer",null,"Adrienne Slattery","2017-04-11",0.75,{"$f":"IF(C37=\"\",\" \",SUMPRODUCT((AA37=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X37=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D37>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D37<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":295},{"$f":"IF(C37=\"\", \" \",$E37*$F37)","v":221.25},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D37)>6,YEAR(D37)+1,YEAR(D37)),\"####\")","v":"2017"},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":19}]
["Fire Engineer",null,"Adrienne Slattery","2017-04-20",0.5,{"$f":"IF(C38=\"\",\" \",SUMPRODUCT((AA38=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X38=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D38>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D38<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":295},{"$f":"IF(C38=\"\", \" \",$E38*$F38)","v":147.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D38)>6,YEAR(D38)+1,YEAR(D38)),\"####\")","v":"2017"},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":19}]
["Fire Engineer",null,"Adrienne Slattery","2017-04-21",0.25,{"$f":"IF(C39=\"\",\" \",SUMPRODUCT((AA39=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X39=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D39>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D39<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":295},{"$f":"IF(C39=\"\", \" \",$E39*$F39)","v":73.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D39)>6,YEAR(D39)+1,YEAR(D39)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C39=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D39>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D39<=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":19}]
["Fire Engineer",null,"Adrienne Slattery","2017-05-04",0.25,{"$f":"IF(C40=\"\",\" \",SUMPRODUCT((AA40=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X40=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D40>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D40<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":294},{"$f":"IF(C40=\"\", \" \",$E40*$F40)","v":73.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D40)>6,YEAR(D40)+1,YEAR(D40)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C40=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D40>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D40<=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":6}]
["Fire Engineer",null,"Adrienne Slattery","2017-05-09",0.25,{"$f":"IF(C41=\"\",\" \",SUMPRODUCT((AA41=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X41=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D41>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D41<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":294},{"$f":"IF(C41=\"\", \" \",$E41*$F41)","v":73.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D41)>6,YEAR(D41)+1,YEAR(D41)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C41=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D41>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D41<=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":6}]
["Fire Engineer",null,"Adrienne Slattery","2017-07-31",0.5,{"$f":"IF(C42=\"\",\" \",SUMPRODUCT((AA42=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X42=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D42>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D42<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":294},{"$f":"IF(C42=\"\", \" \",$E42*$F42)","v":147},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D42)>6,YEAR(D42)+1,YEAR(D42)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C42=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D42>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D42<=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":6}]
["Fire Engineer",null,"Adrienne Slattery","2017-08-01",0.5,{"$f":"IF(C43=\"\",\" \",SUMPRODUCT((AA43=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X43=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D43>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D43<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":294},{"$f":"IF(C43=\"\", \" \",$E43*$F43)","v":147},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D43)>6,YEAR(D43)+1,YEAR(D43)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C43=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D43>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D43<=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":6}]
["Other Specialist Input","Fire Consultant","Jonathan Nyman","2017-07-13",1,{"$f":"IF(C44=\"\",\" \",SUMPRODUCT((AA44=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X44=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D44>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D44<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C44=\"\", \" \",$E44*$F44)","v":235},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D44)>6,YEAR(D44)+1,YEAR(D44)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C44=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D44>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D44<=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":24}]
["Other Specialist Input","Fire Consultant","Jonathan Nyman","2017-07-27",0.25,{"$f":"IF(C45=\"\",\" \",SUMPRODUCT((AA45=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X45=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D45>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D45<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C45=\"\", \" \",$E45*$F45)","v":58.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D45)>6,YEAR(D45)+1,YEAR(D45)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C45=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D45>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D45<=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":24}]
["Other Specialist Input","Fire Consultant","Jonathan Nyman","2017-07-31",0.25,{"$f":"IF(C46=\"\",\" \",SUMPRODUCT((AA46=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X46=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D46>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D46<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C46=\"\", \" \",$E46*$F46)","v":58.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D46)>6,YEAR(D46)+1,YEAR(D46)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C46=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D46>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D46<=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":24}]
["Other Specialist Input","Fire Consultant","Jonathan Nyman","2017-08-01",0.25,{"$f":"IF(C47=\"\",\" \",SUMPRODUCT((AA47=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X47=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D47>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D47<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":235},{"$f":"IF(C47=\"\", \" \",$E47*$F47)","v":58.75},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D47)>6,YEAR(D47)+1,YEAR(D47)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C47=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D47>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D47<=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":24}]
["Geotech Engineer",null,"Margaret Stoffel","2017-04-05",0.5,{"$f":"IF(C48=\"\",\" \",SUMPRODUCT((AA48=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X48=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D48>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D48<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C48=\"\", \" \",$E48*$F48)","v":132.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D48)>6,YEAR(D48)+1,YEAR(D48)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C48=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D48>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D48<=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":25}]
["Geotech Engineer",null,"Margaret Stoffel","2017-04-05",1,{"$f":"IF(C49=\"\",\" \",SUMPRODUCT((AA49=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X49=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D49>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D49<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C49=\"\", \" \",$E49*$F49)","v":265},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D49)>6,YEAR(D49)+1,YEAR(D49)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C49=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D49>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D49<=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":25}]
["Geotech Engineer",null,"Margaret Stoffel","2017-07-13",1,{"$f":"IF(C50=\"\",\" \",SUMPRODUCT((AA50=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X50=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D50>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D50<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C50=\"\", \" \",$E50*$F50)","v":265},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D50)>6,YEAR(D50)+1,YEAR(D50)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C50=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D50>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D50<=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":25}]
["Geotech Engineer",null,"Margaret Stoffel","2017-07-31",1,{"$f":"IF(C51=\"\",\" \",SUMPRODUCT((AA51=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X51=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D51>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D51<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C51=\"\", \" \",$E51*$F51)","v":265},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D51)>6,YEAR(D51)+1,YEAR(D51)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C51=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D51>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D51<=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":25}]
["Geotech Engineer",null,"Margaret Stoffel","2017-08-01",0.08,{"$f":"IF(C52=\"\",\" \",SUMPRODUCT((AA52=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X52=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D52>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D52<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C52=\"\", \" \",$E52*$F52)","v":21.2},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D52)>6,YEAR(D52)+1,YEAR(D52)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C52=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D52>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D52<=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":25}]
["Geotech Engineer",null,"Margaret Stoffel","2017-08-15",1,{"$f":"IF(C53=\"\",\" \",SUMPRODUCT((AA53=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X53=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D53>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D53<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":265},{"$f":"IF(C53=\"\", \" \",$E53*$F53)","v":265},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D53)>6,YEAR(D53)+1,YEAR(D53)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C53=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D53>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D53<=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":25}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-04-07",0.75,{"$f":"IF(C54=\"\",\" \",SUMPRODUCT((AA54=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X54=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D54>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D54<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C54=\"\", \" \",$E54*$F54)","v":195},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D54)>6,YEAR(D54)+1,YEAR(D54)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C54=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D54>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D54<=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":12}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-07-12",0.75,{"$f":"IF(C55=\"\",\" \",SUMPRODUCT((AA55=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X55=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D55>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D55<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C55=\"\", \" \",$E55*$F55)","v":195},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D55)>6,YEAR(D55)+1,YEAR(D55)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C55=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D55>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D55<=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":12}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-08-01",0.75,{"$f":"IF(C56=\"\",\" \",SUMPRODUCT((AA56=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X56=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D56>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D56<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C56=\"\", \" \",$E56*$F56)","v":195},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D56)>6,YEAR(D56)+1,YEAR(D56)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C56=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D56>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D56<=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":12}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-08-02",0.5,{"$f":"IF(C57=\"\",\" \",SUMPRODUCT((AA57=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X57=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D57>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D57<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C57=\"\", \" \",$E57*$F57)","v":130},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D57)>6,YEAR(D57)+1,YEAR(D57)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C57=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D57>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D57<=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":12}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-08-03",0.25,{"$f":"IF(C58=\"\",\" \",SUMPRODUCT((AA58=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X58=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D58>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D58<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C58=\"\", \" \",$E58*$F58)","v":65},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D58)>6,YEAR(D58)+1,YEAR(D58)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C58=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D58>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D58<=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":12}]
["Other Specialist Input","Mechanical Engineer","Nick Waddington","2017-08-15",0.75,{"$f":"IF(C59=\"\",\" \",SUMPRODUCT((AA59=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X59=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D59>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D59<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":260},{"$f":"IF(C59=\"\", \" \",$E59*$F59)","v":195},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D59)>6,YEAR(D59)+1,YEAR(D59)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C59=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D59>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D59<=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":12}]
["Communication",null,"Nico Chen","2017-03-30",0.17,{"$f":"IF(C60=\"\",\" \",SUMPRODUCT((AA60=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X60=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D60>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D60<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":173},{"$f":"IF(C60=\"\", \" \",$E60*$F60)","v":29.410000000000004},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D60)>6,YEAR(D60)+1,YEAR(D60)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C60=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D60>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D60<=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":34}]
["Communication",null,"Nico Chen","2017-03-30",0.17,{"$f":"IF(C61=\"\",\" \",SUMPRODUCT((AA61=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X61=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D61>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D61<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":173},{"$f":"IF(C61=\"\", \" \",$E61*$F61)","v":29.410000000000004},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D61)>6,YEAR(D61)+1,YEAR(D61)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C61=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D61>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D61<=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":34}]
["Communication",null,"Nico Chen","2017-04-04",0.17,{"$f":"IF(C62=\"\",\" \",SUMPRODUCT((AA62=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X62=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D62>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D62<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":173},{"$f":"IF(C62=\"\", \" \",$E62*$F62)","v":29.410000000000004},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D62)>6,YEAR(D62)+1,YEAR(D62)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C62=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D62>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D62<=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":34}]
["Communication",null,"Nico Chen","2017-04-06",0.17,{"$f":"IF(C63=\"\",\" \",SUMPRODUCT((AA63=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X63=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D63>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D63<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":173},{"$f":"IF(C63=\"\", \" \",$E63*$F63)","v":29.410000000000004},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D63)>6,YEAR(D63)+1,YEAR(D63)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C63=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D63>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D63<=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":34}]
["Structural Engineer",null,"Rolando Basobas","2017-03-29",0.5,{"$f":"IF(C64=\"\",\" \",SUMPRODUCT((AA64=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X64=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D64>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D64<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":273},{"$f":"IF(C64=\"\", \" \",$E64*$F64)","v":136.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D64)>6,YEAR(D64)+1,YEAR(D64)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C64=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D64>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D64<=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":5}]
["Structural Engineer",null,"Rolando Basobas","2017-07-14",0.7,{"$f":"IF(C65=\"\",\" \",SUMPRODUCT((AA65=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X65=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D65>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D65<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":275},{"$f":"IF(C65=\"\", \" \",$E65*$F65)","v":192.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D65)>6,YEAR(D65)+1,YEAR(D65)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C65=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D65>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D65<=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":5}]
["Processing",null,"Tania McGrath","2017-04-06",0.57999999999999996,{"$f":"IF(C66=\"\",\" \",SUMPRODUCT((AA66=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X66=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D66>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D66<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C66=\"\", \" \",$E66*$F66)","v":127.6},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D66)>6,YEAR(D66)+1,YEAR(D66)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C66=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D66>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D66<=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,"Tania McGrath","2017-04-06",1.33,{"$f":"IF(C67=\"\",\" \",SUMPRODUCT((AA67=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X67=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D67>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D67<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C67=\"\", \" \",$E67*$F67)","v":292.60000000000002},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D67)>6,YEAR(D67)+1,YEAR(D67)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C67=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D67>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D67<=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,"Tania McGrath","2017-04-06",1.5,{"$f":"IF(C68=\"\",\" \",SUMPRODUCT((AA68=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X68=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D68>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D68<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C68=\"\", \" \",$E68*$F68)","v":330},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D68)>6,YEAR(D68)+1,YEAR(D68)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C68=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D68>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D68<=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,"Tania McGrath","2017-04-07",1.17,{"$f":"IF(C69=\"\",\" \",SUMPRODUCT((AA69=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X69=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D69>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D69<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C69=\"\", \" \",$E69*$F69)","v":257.39999999999998},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D69)>6,YEAR(D69)+1,YEAR(D69)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C69=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D69>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D69<=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,"Tania McGrath","2017-04-10",3.67,{"$f":"IF(C70=\"\",\" \",SUMPRODUCT((AA70=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X70=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D70>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D70<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C70=\"\", \" \",$E70*$F70)","v":807.4},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D70)>6,YEAR(D70)+1,YEAR(D70)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C70=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D70>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D70<=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,"Tania McGrath","2017-04-11",1.75,{"$f":"IF(C71=\"\",\" \",SUMPRODUCT((AA71=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X71=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D71>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D71<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C71=\"\", \" \",$E71*$F71)","v":385},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D71)>6,YEAR(D71)+1,YEAR(D71)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C71=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D71>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D71<=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,"Tania McGrath","2017-04-11",0.42,{"$f":"IF(C72=\"\",\" \",SUMPRODUCT((AA72=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X72=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D72>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D72<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C72=\"\", \" \",$E72*$F72)","v":92.399999999999991},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D72)>6,YEAR(D72)+1,YEAR(D72)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C72=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D72>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D72<=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,"Tania McGrath","2017-06-07",0.25,{"$f":"IF(C73=\"\",\" \",SUMPRODUCT((AA73=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X73=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D73>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D73<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":220},{"$f":"IF(C73=\"\", \" \",$E73*$F73)","v":55},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D73)>6,YEAR(D73)+1,YEAR(D73)),\"####\")","v":"2017"},null,"Role Type",{"$f":"SUMPRODUCT((C73=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D73>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D73<=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,"Tania McGrath","2017-07-10",0.5,{"$f":"IF(C74=\"\",\" \",SUMPRODUCT((AA74=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X74=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D74>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D74<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C74=\"\", \" \",$E74*$F74)","v":105},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D74)>6,YEAR(D74)+1,YEAR(D74)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C74=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D74>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D74<=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,"Tania McGrath","2017-07-12",0.5,{"$f":"IF(C75=\"\",\" \",SUMPRODUCT((AA75=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X75=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D75>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D75<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C75=\"\", \" \",$E75*$F75)","v":105},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D75)>6,YEAR(D75)+1,YEAR(D75)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C75=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D75>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D75<=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,"Tania McGrath","2017-07-13",2.0299999999999998,{"$f":"IF(C76=\"\",\" \",SUMPRODUCT((AA76=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X76=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D76>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D76<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C76=\"\", \" \",$E76*$F76)","v":426.29999999999995},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D76)>6,YEAR(D76)+1,YEAR(D76)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C76=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D76>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D76<=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,"Tania McGrath","2017-07-13",0.53,{"$f":"IF(C77=\"\",\" \",SUMPRODUCT((AA77=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X77=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D77>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D77<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C77=\"\", \" \",$E77*$F77)","v":111.30000000000001},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D77)>6,YEAR(D77)+1,YEAR(D77)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C77=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D77>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D77<=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,"Tania McGrath","2017-07-13",1,{"$f":"IF(C78=\"\",\" \",SUMPRODUCT((AA78=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X78=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D78>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D78<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C78=\"\", \" \",$E78*$F78)","v":210},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D78)>6,YEAR(D78)+1,YEAR(D78)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C78=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D78>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D78<=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,"Tania McGrath","2017-07-13",0.75,{"$f":"IF(C79=\"\",\" \",SUMPRODUCT((AA79=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X79=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D79>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D79<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C79=\"\", \" \",$E79*$F79)","v":157.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D79)>6,YEAR(D79)+1,YEAR(D79)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C79=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D79>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D79<=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,"Tania McGrath","2017-07-13",0.92,{"$f":"IF(C80=\"\",\" \",SUMPRODUCT((AA80=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X80=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D80>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D80<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C80=\"\", \" \",$E80*$F80)","v":193.20000000000002},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D80)>6,YEAR(D80)+1,YEAR(D80)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C80=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D80>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D80<=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,"Tania McGrath","2017-07-14",0.17,{"$f":"IF(C81=\"\",\" \",SUMPRODUCT((AA81=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X81=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D81>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D81<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C81=\"\", \" \",$E81*$F81)","v":35.700000000000003},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D81)>6,YEAR(D81)+1,YEAR(D81)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C81=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D81>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D81<=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,"Tania McGrath","2017-07-14",0.57999999999999996,{"$f":"IF(C82=\"\",\" \",SUMPRODUCT((AA82=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X82=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D82>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D82<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C82=\"\", \" \",$E82*$F82)","v":121.8},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D82)>6,YEAR(D82)+1,YEAR(D82)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C82=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D82>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D82<=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"," ","Tania McGrath","2017-07-17",0.17,{"$f":"IF(C83=\"\",\" \",SUMPRODUCT((AA83=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X83=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D83>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D83<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C83=\"\", \" \",$E83*$F83)","v":35.700000000000003},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D83)>6,YEAR(D83)+1,YEAR(D83)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C83=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D83>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D83<=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,"Tania McGrath","2017-07-31",1.08,{"$f":"IF(C84=\"\",\" \",SUMPRODUCT((AA84=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X84=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D84>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D84<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C84=\"\", \" \",$E84*$F84)","v":226.8},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D84)>6,YEAR(D84)+1,YEAR(D84)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C84=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D84>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D84<=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"," ","Tania McGrath","2017-08-02",0.5,{"$f":"IF(C85=\"\",\" \",SUMPRODUCT((AA85=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X85=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D85>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D85<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C85=\"\", \" \",$E85*$F85)","v":105},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D85)>6,YEAR(D85)+1,YEAR(D85)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C85=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D85>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D85<=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,"Tania McGrath","2017-08-04",0.33,{"$f":"IF(C86=\"\",\" \",SUMPRODUCT((AA86=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X86=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D86>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D86<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C86=\"\", \" \",$E86*$F86)","v":69.3},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D86)>6,YEAR(D86)+1,YEAR(D86)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C86=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D86>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D86<=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,"Tania McGrath","2017-08-15",0.5,{"$f":"IF(C87=\"\",\" \",SUMPRODUCT((AA87=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X87=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D87>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D87<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C87=\"\", \" \",$E87*$F87)","v":105},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D87)>6,YEAR(D87)+1,YEAR(D87)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C87=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D87>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D87<=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,"Tania McGrath","2017-08-15",0.75,{"$f":"IF(C88=\"\",\" \",SUMPRODUCT((AA88=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X88=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D88>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D88<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":210},{"$f":"IF(C88=\"\", \" \",$E88*$F88)","v":157.5},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D88)>6,YEAR(D88)+1,YEAR(D88)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C88=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D88>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D88<=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}]
["End Administration"," ","Mel Lawson","2017-08-17",1,{"$f":"IF(C89=\"\",\" \",SUMPRODUCT((AA89=OFFSET('Role Fee Structure'!$C$3,0,0,'Role Fee Structure'!$AB$5))*(X89=OFFSET('Role Fee Structure'!$F$2,0,0,1,'Role Fee Structure'!$AB$4))*(D89>=OFFSET('Role Fee Structure'!$D$3,0,0,'Role Fee Structure'!$AB$5))*(D89<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,0,0,'Role Fee Structure'!$AB$5,'Role Fee Structure'!$AB$4))))","v":120},{"$f":"IF(C89=\"\", \" \",$E89*$F89)","v":120},null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"},null,null,null,null,null,null,null,null,null,null,"Financial Year",{"$f":"TEXT(IF(MONTH(D89)>6,YEAR(D89)+1,YEAR(D89)),\"####\")","v":"2018"},null,"Role Type",{"$f":"SUMPRODUCT((C89=OFFSET('Names of Officers'!$B$4,0,0,'Names of Officers'!$AB$6))*(D89>=OFFSET('Names of Officers'!$D$4,0,0,'Names of Officers'!$AB$6))*(D89<=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",30,null,null,null,null,{"$f":"$A$30","v":"Process and Grant:"}]
[null," ",null,"Fixed Administration Fee:",null,"Applicable",{"$f":"VLOOKUP(F91,FixedAdminFee[#All],2,0)","v":175},null,null,null,null,"Process and Grant:"]
[null,null,null,"Certificate of Title:",0,"Not Applicable",{"$f":"IF(AND(F92=\"Applicable\",E92<1),\"CHECK\",E92*X92)","v":0},null,null,null,null,"Process and Grant:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F92,CT[#All],2,0)","v":0}]
[null,null,null,"External Contractors or Consultants:",null,"Not Applicable",{"$f":"VLOOKUP(F93,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$30,$G:$G)","v":9958.8399999999983}]
[]
["Levies:"]
[null,null,"Value of Work:",140000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge Rate","Threshold:",20000]
["Accreditation Levy:",null,null,{"$f":"ROUNDDOWN(D97,-3)*$W98","v":41.999999999999993},"($0.30 for every $1,000 of estimated value)",null,null,null,null,null,null,{"$f":"$A$96","v":"Levies:"},null,null,null,null,null,null,null,null,null,null,2.9999999999999997E-4]
["Building Levy (MBIE):",null,null,{"$f":"IF(D97<$Y$97,\"$0.00\",ROUNDUP(D97,-3)*$W99)","v":281.40000000000003},"($2.01 per $1,000 (or part thereof) of building work valued over $20,000)",null,null,null,null,null,null,"Levies:",null,null,null,null,null,null,null,null,null,null,2.0100000000000001E-3]
["Building Research Levy (BRANZ):",null,null,{"$f":"IF(D97<$Y$97,\"$0.00\",ROUNDUP(D97,-3)*$W100)","v":140},"($1 per $1,000 (or part thereof) of building work valued over $20,000)",null,null,null,null,null,null,"Levies:",null,null,null,null,null,null,null,null,null,null,1E-3]
[null,null,null,null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$96,$D:$D)","v":463.40000000000003}]
[]
["Inspections:"]
["Type:","Comments:","Number of Inspections:",null,"Cost Per Inspection:",null,"Fee:"]
["Commercial",null,9,null,255,null,{"$f":"IF(OR(AND(A105=\"Residential\", C105=0),AND(A105=\"Commercial\", C105=0)),\"CHECK\",C105*E105)","v":2295},null,null,null,null,{"$f":"$A$103","v":"Inspections:"}]
[null,null,null,null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$103,$G:$G)","v":2295}]
[]
["Christchurch City Council Fees:"]
["Fee Type:",null,null,null,"Total Quantity:","Rate Per Quantity","Fee:"]
["Code Compliance Certificate","Commercial 1-2, Residential multi-unit or alterations to a commercial 3 less than/equal to $500,000",null,null,1,{"$f":"VLOOKUP(B110,CCC[#All],2,0)","v":488},{"$f":"E110*F110","v":488},null,null,null,null,{"$f":"$A$108","v":"Christchurch City Council Fees:"}]
["Electronic File Management Fee","Applicable",null,null,null,null,{"$f":"VLOOKUP(B111,ElectronicFile[#All],2,0)","v":52},null,null,null,null,{"$f":"$A$108","v":"Christchurch City Council Fees:"}]
["No CCC Connection"," ",null,null,0,{"$f":"VLOOKUP(A112,OptCon[#All],2,0)","v":0},{"$f":"IF(OR(AND(A112=\"Standard Water Connection:\", E112=0),AND(A112=\"Stormwater Opening:\", E112=0),AND(A112=\"Sewer Opening:\", E112=0),AND(A112=\"Vehicle Crossing Inspection:\", E112=0)),\" CHECK\",E112*F112)","v":0},null,null,null,null,"Christchurch City Council Fees:"]
["NZ Fire Service Review:",null,null,null,null,null,603.75,null,null,null,null,"Christchurch City Council Fees:"]
["Compliance Schedule:",null,null,null,null,null,140,null,null,null,null,"Christchurch City Council Fees:"]
[null," "," ",null,"Total Fee:",null,{"$f":"SUMIF($L:$L,$A$108,$G:$G)","v":1283.75}]
[]
["Subtotal (inc GST):",null,null,null,null,null,{"$f":"SUM(G14+G23+G28+G94+G101+G106+G115)","v":14613.739999999998}]
[]
["Less Deposit Paid (inc GST):",null,null,null,null,null,4000]
[]
["Final Total Invoice (inc GST):",null,null,null,null,null,{"$f":"SUM(G14,G23,G28,G94,G101,G106,G115-G119)","v":10613.739999999998}]
[]
[]
[]
[]
[]
[null,"Fee Summary"]
[]
[null,"Accept:",null,null,null,{"$f":"G14","v":109.50000000000001}]
[]
[null,"PIM/Development Check:",null,null,null,{"$f":"G23","v":330.25}]
[]
[null,"Pre-acceptance Technical Check:",null,null,null,{"$f":"G28","v":173}]
[]
[null,"Process and Grant:",null,null,null,{"$f":"G94","v":9958.8399999999983}]
[]
[null,"Inspections:",null,null,null,{"$f":"G106","v":2295}]
[]
[null,"Christchurch City Council Fees:",null,null,null,{"$f":"G115","v":1283.75}]
[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":"D98","v":41.999999999999993}]
[null,"Building Levy",null,null,null,{"$f":"D99","v":281.40000000000003}]
[null,"Building Research Levy ",null,null,null,{"$f":"D100","v":140}]
[]
[null,"Subtotal (inc GST):",null,null,null,{"$f":"G117","v":14613.739999999998}]
[]
[null,"Less Deposit Paid (inc GST):",null,null,null,{"$f":"G119","v":4000}]
[]
[null,"Final Total Invoice (inc GST):",null,null,null,{"$f":"G121","v":10613.739999999998}]

{"sheet":"PIM Only Consent Fee Summary","index":1,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,5,4,6],[2,0,2,4],[16,0,16,5],[19,0,20,5],[19,6,20,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.16 LR: 01.07.16 v20"]
[]
["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$3,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$3,0,0,'Role Fee Structure'!$AB$5))*(D9<=OFFSET('Role Fee Structure'!$E$3,0,0,'Role Fee Structure'!$AB$5))*(OFFSET('Role Fee Structure'!$F$3,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":28.75},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":80.75}]
[]
[]
[]
["Less Deposit Paid (inc GST):",null,null,null,null,null,0]
[]
[]
["Total Invoice (inc GST):",null,null,null,null,null,{"$f":"SUM(G13-G17)","v":80.75}]

{"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",0]
[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",28.75,null,null,"< Please Select CCC Type>",0]
["Additional Information 1",null,"Planning Check",null,"Communication",null,"Residential",190,null,null,null,"Not Applicable",0,null,null,"No Code Compliance Certificate",0]
["Additional Information 2",null,"Drainage Report",null,"Processing",null,"Commercial",245,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",357]
["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",488]
["Additional Information 7",null,"Admin",null,"Other Specialist Input",null,null,null,null,null,null,null,null,null,null,"Commercial 3 over $500,000",966]
["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",13.8,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:",670]
["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",28.75]
["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:",140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 73 (Hazards):",420]
[null,null,null,null,null,null,null,null,null,null,null,"Electronic File","Charge",null,null,"Section 75 (Multi Titles):",420]
[null,null,null,null,null,null,null,null,null,null,null,"Applicable",52,null,null,"Sewer Lateral Fee:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",0,null,null,"NZ Fire Service Review:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Memo of Encumbrance:","ENTER VALUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commercial/Residential PFVS:","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":417,"n_cols":28,"rows_kept":417,"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","3999-12-31",26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num Rows",414]
[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","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Al Wilson","Opus Experienced","2015-07-01","3999-12-31",25]
[null,"Alan Wilson","Opus Experienced","2015-07-01","3999-12-31",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 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","3999-12-31",59]
[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,"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","3999-12-31",1]
[null,"Andrew Eames","BCO 3","2016-09-12","3999-12-31",3]
[null,"Andrew Smith","David Ogilvie","2015-07-01","3999-12-31",69]
[null,"Andrew Stewart","Snr BCO/Specialists","2015-07-01","2017-07-25",4]
[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","3999-12-31",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","Public Advice Officer","2015-07-01","3999-12-31",62]
[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,"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,"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,"Bob Pritchard","Subdivision Officer","2015-07-01","3999-12-31",42]
[null,"Bogdan Balliu-Bottesch","Opus Experienced","2015-07-01","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","2017-07-25",4]
[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","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","3999-12-31",61]
[null,"Carlo Botha","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Catherine Elvidge","Planner Snr/Subdivision Officer etc","2015-07-01","3999-12-31",38]
[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 Hewlett","Planner Snr/Subdivision Officer etc","2015-07-01","2016-02-15",38]
[null,"Chris Hewlett","Snr BCO/Specialists","2016-02-16","2017-07-25",4]
[null,"Chris van den Bosch","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[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 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","3999-12-31",15]
[null,"Colleen Jones","BCO 2","2015-07-01","3999-12-31",2]
[null,"Craig Marshall","Public Advice Officer","2015-07-01","3999-12-31",62]
[null,"Damien Singleton","BCO 1","2015-07-01","3999-12-31",1]
[null,"Daniel Pau","Opus Graduate","2015-07-01","3999-12-31",27]
[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,"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","3999-12-31",5]
[null,"Eddie Newman","BCO 3","2015-07-01","3999-12-31",3]
[null,"Elizabeth Alexander","BCO 1","2015-07-01","3999-12-31",1]
[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","Planning Engineer","2015-07-01","2017-07-25",66]
[null,"Emma Chapman","Planner 2/3","2015-07-01","3999-12-31",37]
[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","3999-12-31",38]
[null,"Erik Kunkel","Opus Experienced","2015-07-01","3999-12-31",25]
[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","3999-12-31",4]
[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","3999-12-31",3]
[null,"Hanish Aroa","Opus Intermediate","2015-07-01","3999-12-31",26]
[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,"Helene Kirpensteijn","Planner 2/3","2015-07-28","3999-12-31",37]
[null,"Hermione Blair","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Holly Gardiner","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Holly Luzak","Building Administrator","2015-07-01","3999-12-31",59]
[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","3999-12-31",29]
[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","2017-07-25",4]
[null,"Ian Burford","Snr Engineer/Team manager","2015-07-01","3999-12-31",6]
[null,"Ian Johnson","Water Supply Plan 1","2015-07-01","2017-07-25",53]
[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,"James Dismuke","Golder Associate Experienced","2015-07-01","3999-12-31",67]
[null,"James Kwon","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[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 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","3999-12-31",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","Public 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","3999-12-31",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,"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,"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,"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,"Katherine Riley","Snr BCO/Specialists","2015-07-01","3999-12-31",4]
[null,"Kathryn 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,"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 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,"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,"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","3999-12-31",4]
[null,"Lisa Kupenga","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Lisa Williams","Planner 2/3","2015-07-01","3999-12-31",37]
[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 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 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","Planning Engineer","2017-07-24","2017-07-25",66]
[null,"Michelle Reddock","BCO 1","2015-07-01","2017-06-30",1]
[null,"Michelle 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 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","Planning Engineer","2015-07-01","2017-07-25",66]
[null,"Nick Waddington","GHD Expert","2015-07-01","3999-12-31",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 Sharpe","BCO 1","2015-07-01","2017-06-30",1]
[null,"Nikii Sharpe","Vetting & Allocation","2017-07-01","3999-12-31",81]
[null,"Nikki Donaldson","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Noemi Ponferrada","Building Officers (BWOF)","2015-07-01","3999-12-31",79]
[null,"Odette White","Planner 2/3","2015-07-01","3999-12-31",37]
[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,"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 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","3999-12-31",25]
[null,"Rachel Anderson","Building Administrator","2017-08-07","3999-12-31",59]
[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","3999-12-31",79]
[null,"Rebecca Gourlay","Building Administrator","2015-07-01","3999-12-31",59]
[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,"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,"Rolando Basobas","PBO/Specialist Engineer","2015-07-01","3999-12-31",5]
[null,"Rod Pulahinge","BCO 2","2015-07-01","3999-12-31",2]
[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","3999-12-31",37]
[null,"Ryan Brosnahan","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Ryan Cooper","BCO 2","2015-07-01","3999-12-31",2]
[null,"Sahana Poojari","Building Administrator","2017-08-07","3999-12-31",59]
[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,"Sean Patterson","BCO 1","2015-07-01","3999-12-31",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","2017-07-25",4]
[null,"Shona Jowett","Planner 2/3","2015-07-01","3999-12-31",37]
[null,"Simon Biggs","Opus Experienced","2015-07-01","3999-12-31",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","3999-12-31",17]
[null,"Spiire","Spiire Experienced","2015-07-01","3999-12-31",21]
[null,"Stephen Burrows","Building Administrator","2015-07-01","3999-12-31",59]
[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","3999-12-31",3]
[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,"Toby King","BCO 1","2015-07-01","2016-09-27",1]
[null,"Toby King","BCO 2","2016-09-28","3999-12-31",2]
[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","2017-07-25",4]
[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","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,"Yolanda Filipo","Building Administrator","2015-07-01","3999-12-31",59]
[null,"Zarnaz Mehryar","Snr Engineer/Team Manager","2015-07-01","3999-12-31",6]
[null,"Zoe Dolling","Public Advice Officer","2015-07-01","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":354,"n_cols":1,"rows_kept":354,"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"]
["Al Wilson"]
["Alan Wilson"]
["Alie Nieuwenhuize"]
["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"]
["Andre Winkelman"]
["Andrei Cotiga"]
["Andrew Dimock"]
["Andrew Eames"]
["Andrew Smith"]
["Andrew Stewart"]
["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"]
["Bee Geok Chan"]
["Ben Healy"]
["Bill Dray"]
["Bill Harrington"]
["Biswadeep Ghosh"]
["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"]
["Bruce Craig"]
["Bruce Lyon"]
["Bryan McKay"]
["BTW"]
["Calibre Consulting Ltd"]
["Carlo Botha"]
["Catherine Elvidge"]
["Catriona MacPherson"]
["Cecile Coll"]
["Charlotte Walsh"]
["Chen (Weng-Kei Chen)"]
["Chi Chi Wang"]
["Chloe Stewart"]
["Chris Beckham"]
["Chris Hewlett"]
["Chris van den Bosch"]
["City Certifiers"]
["Claire Barry"]
["Clare Revell"]
["Claudia Stuart"]
["Clement Maloney"]
["Clive Anderson"]
["Colleen Jones"]
["Craig Marshall"]
["Damien Singleton"]
["Daniel Pau"]
["Danielle Yeoman (nee Bailey)"]
["Dannielle Heron"]
["Darryn Fenton"]
["Daryl Lim"]
["David Barry-Maculay"]
["David Hutt"]
["David Keohane"]
["David Lee"]
["David Mudu"]
["Debbie Laffey"]
["Donna Chapman"]
["Donna Cooper"]
["Donnick Mugusto"]
["Doru Hozias"]
["DSC Group"]
["Dylan Hunt"]
["Ed Nystad"]
["Eddie Newman"]
["Elizabeth Alexander"]
["Elizabeth Reeves"]
["Ellen Worthington"]
["Emma Chapman"]
["Emma Taylor"]
["Eria Metcalf"]
["Erik Kunkel"]
["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"]
["Heath Wells"]
["Helen Bealey"]
["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"]
["James Dismuke"]
["James Kwon"]
["James Marsh"]
["Jan Bochow"]
["Jan Steenkamp"]
["Jason Dean"]
["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"]
["Johan Dalkie"]
["John Blackwell"]
["John Gibson"]
["John Hargraves"]
["John Higgins"]
["John James"]
["John Richards"]
["John Thornton"]
["Jonathan Nyman"]
["Joel Bensing"]
["Jolene Anderson"]
["Jon King"]
["Judy Benyon"]
["Julie Hand"]
["Julie Villard"]
["Karen Fitzpatrick"]
["Kate Askew"]
["Kate Biddlecombe"]
["Kate Graham"]
["Katherina Woodlock"]
["Katherine Hall"]
["Katherine Riley"]
["Kathryn Stapleton"]
["Kathy McTigue"]
["Calvin Hock"]
["Kent Wilson"]
["Kerry Magnuson"]
["Kevin Maher"]
["Kelvin Lim"]
["Kelvin Newman"]
["Kevin Williams"]
["Kirsten Boyd"]
["Kris Davys"]
["Kristin McKee"]
["Kyle Atkins"]
["Kyle Lewis"]
["Laura Braddick"]
["Leashelle Miller"]
["Leashelle Miller - STF"]
["Lianne McCone"]
["Lionel Bridger"]
["Lisa Arnott"]
["Lisa Bennett"]
["Lisa Kupenga"]
["Lisa Williams"]
["Lizzie Spencer"]
["Llyod McLauchlan"]
["Lorraine Bell  "]
["Louisa Armstrong"]
["Lucie Hanrahan"]
["Luke Wignall"]
["Lynette Daniell"]
["Mal Nash"]
["Malory Bloor"]
["Marilyn Regnault"]
["Manasi Vaidya"]
["Margaret Stoffel"]
["Margie Cook"]
["Marie-Claude Hebert"]
["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"]
["Morehu Rangi"]
["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 Sharpe"]
["Nikki Donaldson"]
["Noemi Ponferrada"]
["Odette White"]
["PBC"]
["Paul Clarke"]
["Paul Dickson"]
["Paul Dietsche"]
["Paul Hodson"]
["Paul Lowe"]
["Paul Mullen"]
["Pauline Robinson"]
["Peter Van der Zee"]
["Peter Warriner"]
["Pumping Station Clearances"]
["Phill Carr"]
["Phillip Hector"]
["Phillip Judge"]
["Philip Xie"]
["Rachel Anderson"]
["Rachel Dowers"]
["Raewyn Kinnis"]
["Rebecca Gourlay"]
["Rebecca Wills"]
["Reece Morgan"]
["Rex Belworthy"]
["Reynaldo Pagaduan Jr"]
["Ricardo Anderson "]
["Richard Gant"]
["Richard Lorgelly"]
["Richard Meekin"]
["Richard Wang"]
["Richard Zac"]
["Robert Herbert"]
["Robert O'Connor"]
["Robert Skinner"]
["Rochelle Willis"]
["Rolando Basobas"]
["Rod Pulahinge"]
["Ronel Catalo"]
["Rosemary Hoare"]
["Roy Eastman"]
["Roy Gurney"]
["Russel Wedge"]
["Ruth Markham-Short"]
["Ryan Brosnahan"]
["Ryan Cooper"]
["Sahana Poojari"]
["Sarah Congdon"]
["Sarah Saxon"]
["Sam Owles"]
["Sandi Rhynd"]
["Sanjay Dutt"]
["Sean Patterson"]
["Sean Ward"]
["Selva Muniswamy"]
["Setareki Ha'angana"]
["Shane Bruyns"]
["Sheryl Keenan"]
["Shona Jowett"]
["Simon Biggs"]
["Simon Fenton"]
["Sonia Gilmour"]
["Sophie Bainbridge"]
["Spiire"]
["Stephen Burrows"]
["Steve Carrington"]
["Steve Gray"]
["Steve Walders"]
["Sue McKenzie"]
["Suzanne Richmond"]
["Taka Sato"]
["Tammy Bruyns"]
["Tania Byrnes"]
["Tania McGrath"]
["Tanya Prinsloo"]
["Terry Sparks"]
["Toby King"]
["Tom Arthur"]
["Thomas Aspell"]
["Tom Aspell"]
["Tony Borkus"]
["Tony Croager"]
["Tony Parkes"]
["Tracey Atherton"]
["Vanessa Hammond"]
["Victor Mthamo"]
["Vil Vabuils"]
["Vincent Wong"]
["Watkins Consultants"]
["Wayne Roden"]
["Wendy Baker"]
["Wendy Payne"]
["Yolanda Filipo"]
["Zarnaz Mehryar"]
["Zoe Dolling"]
["Other"]
["   "]

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