{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Approvals Register","Approvals","Categories","Related Tenements","Actions","Pivot"],"not_rendered":{"images":1,"defined_names":10,"comments":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Approvals Register","index":0,"n_rows":33,"n_cols":68,"rows_kept":33}
[]
[null,"Environment Report - Approvals Register"]
[]
[null,"Project","Licence","ID","Agency","Type","Fees","Expiry",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2019-08-01"},{"$f":"EDATE(I4,1)","v":"2019-09-01"},{"$f":"EDATE(J4,1)","v":"2019-10-01"},"2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01"]
[null,"Project","Licence","ID","Agency","Type","Fees","Expiry","Month","Month2","Month3","Month4","Month5","Month6","Month7","Month8","Month9","Month10","Month11","Month12","Month13","Month14","Month15","Month16","Month17","Month18","Month19","Month20","Month59","Month21","Month22","Month23","Month24","Month25","Month26","Month27","Month28","Month29","Month30","Month31","Month32","Month33","Month34","Month35","Month36","Month37","Month38","Month39","Month60","Month40","Month41","Month42","Month43","Month44","Month45","Month46","Month47","Month48","Month49","Month50","Month51","Month52","Month53","Month54","Month55","Month56","Month57","Month58"]
[null,{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A4=\"Grand Total\",Pivot!A4=\"\"),\"\",Pivot!A4)","v":"(blank)"},{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D6,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A5=\"Grand Total\",Pivot!A5=\"\"),\"\",Pivot!A5)","v":""},{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D7,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A6=\"Grand Total\",Pivot!A6=\"\"),\"\",Pivot!A6)","v":""},{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D8,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A7=\"Grand Total\",Pivot!A7=\"\"),\"\",Pivot!A7)","v":""},{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D9,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A8=\"Grand Total\",Pivot!A8=\"\"),\"\",Pivot!A8)","v":""},{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D10,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A9=\"Grand Total\",Pivot!A9=\"\"),\"\",Pivot!A9)","v":""},{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D11,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A10=\"Grand Total\",Pivot!A10=\"\"),\"\",Pivot!A10)","v":""},{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D12,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A11=\"Grand Total\",Pivot!A11=\"\"),\"\",Pivot!A11)","v":""},{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D13,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A12=\"Grand Total\",Pivot!A12=\"\"),\"\",Pivot!A12)","v":""},{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D14,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A13=\"Grand Total\",Pivot!A13=\"\"),\"\",Pivot!A13)","v":""},{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D15,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A14=\"Grand Total\",Pivot!A14=\"\"),\"\",Pivot!A14)","v":""},{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D16,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A15=\"Grand Total\",Pivot!A15=\"\"),\"\",Pivot!A15)","v":""},{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D17,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A16=\"Grand Total\",Pivot!A16=\"\"),\"\",Pivot!A16)","v":""},{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D18,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A17=\"Grand Total\",Pivot!A17=\"\"),\"\",Pivot!A17)","v":""},{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D19,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A18=\"Grand Total\",Pivot!A18=\"\"),\"\",Pivot!A18)","v":""},{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D20,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A19=\"Grand Total\",Pivot!A19=\"\"),\"\",Pivot!A19)","v":""},{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D21,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A20=\"Grand Total\",Pivot!A20=\"\"),\"\",Pivot!A20)","v":""},{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D22,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A21=\"Grand Total\",Pivot!A21=\"\"),\"\",Pivot!A21)","v":""},{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D23,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A22=\"Grand Total\",Pivot!A22=\"\"),\"\",Pivot!A22)","v":""},{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D24,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A23=\"Grand Total\",Pivot!A23=\"\"),\"\",Pivot!A23)","v":""},{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D25,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A24=\"Grand Total\",Pivot!A24=\"\"),\"\",Pivot!A24)","v":""},{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D26,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A25=\"Grand Total\",Pivot!A25=\"\"),\"\",Pivot!A25)","v":""},{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D27,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A26=\"Grand Total\",Pivot!A26=\"\"),\"\",Pivot!A26)","v":""},{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D28,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A27=\"Grand Total\",Pivot!A27=\"\"),\"\",Pivot!A27)","v":""},{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D29,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A28=\"Grand Total\",Pivot!A28=\"\"),\"\",Pivot!A28)","v":""},{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D30,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A29=\"Grand Total\",Pivot!A29=\"\"),\"\",Pivot!A29)","v":""},{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D31,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A30=\"Grand Total\",Pivot!A30=\"\"),\"\",Pivot!A30)","v":""},{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D32,tblApprovals[#Data],10,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],2,FALSE),\"\")","v":""},{"$f":"IF(OR(Pivot!A31=\"Grand Total\",Pivot!A31=\"\"),\"\",Pivot!A31)","v":""},{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($D33,tblApprovals[#Data],10,FALSE),\"\")","v":""}]

{"sheet":"Approvals","index":1,"n_rows":6,"n_cols":13,"rows_kept":6,"merged":[[1,1,1,12]]}
[]
[null,"Environment Report - Approvals List"]
[]
[null,"ID","Name","Type","Agency","Project","Status","Fees?","Date Issued","Commenced Date","Expiry Date","Summary","Comments"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblApprovals[Name])","v":"Total : 0"}]

{"sheet":"Categories","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[1,1,1,2]]}
[]
[null,"Categories"]
[]
[null,"Approval","Category Number","Category Name"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblCategories[Approval])","v":"Total : 0"}]

{"sheet":"Related Tenements","index":3,"n_rows":6,"n_cols":6,"rows_kept":6,"merged":[[1,1,1,5]]}
[]
[null,"Related Tenements"]
[]
[null,"Approval","Related Tenement","Tenement Status","Commence Date","Expiry"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRelTenements[Approval])","v":"Total : 0"}]

{"sheet":"Actions","index":4,"n_rows":6,"n_cols":10,"rows_kept":6,"merged":[[1,1,1,9]]}
[]
[null,"Actions Coming Up"]
[]
[null,"Agreement","ActionType","Seq","Deadline Date","Start Date","Next Task","Amount","Responsible","Manager"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblActions[Agreement])","v":"Total : 0"},{"$nulls":5},{"$f":"SUBTOTAL(109,tblActions[Amount])","v":{"v":0,"d":"$0"}}]

{"sheet":"Pivot","index":5,"n_rows":5,"n_cols":1,"rows_kept":5}
["Used by other tabs. Do not change"]
[]
["Row Labels"]
["(blank)"]
["Grand Total"]