{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Projects","Notes","Related Tenements","Tenement Conditions","Approvals Schedule","Study Outcomes","Studies","Studies by Status","Lookups"],"not_rendered":{"charts":1,"images":1,"defined_names":16,"comments":7,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Projects","index":0,"n_rows":6,"n_cols":7,"rows_kept":6}
[]
[null,"Environmental Report - Projects"]
[]
[null,"Name","Status","Commencement Date","Approvals Deadline","Summary","Comments"]
[]
[null,{"$f":"SUBTOTAL(103,tblProjects[Name])","v":0}]

{"sheet":"Notes","index":1,"n_rows":6,"n_cols":4,"rows_kept":6}
[]
[null,"Notes"]
[]
[null,"Environmental Project","Date","Note"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblNotes[Environmental Project])","v":"Total : 0"}]

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

{"sheet":"Tenement Conditions","index":3,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[null,"Tenement Conditions"]
[]
[null,"Environmental Project","Tenement","No","Version","Start Date","End Date","Text","Comments"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblTenConditions[Environmental Project])","v":"Total : 0"}]

{"sheet":"Approvals Schedule","index":4,"n_rows":7,"n_cols":43,"rows_kept":7,"merged":[[1,7,1,18],[1,19,1,30],[1,31,1,42],[2,7,2,9],[2,10,2,12],[2,13,2,15],[2,16,2,18],[2,19,2,21],[2,22,2,24],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[2,37,2,39],[2,40,2,42]]}
[]
[null,"Approvals Schedule",{"$nulls":5},"2019-01-01",{"$nulls":11},{"$f":"EDATE(H2,12)","v":"2020-01-01"},{"$nulls":11},{"$f":"EDATE(T2,12)","v":"2021-01-01"}]
[{"$nulls":7},"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4",null,null,"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4",null,null,"Q1",null,null,"Q2",null,null,"Q3",null,null,"Q4"]
[null,"Environmental Project","ActionType","Start Date","Deadline Date","Next Task","Project Start Date",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2019-01-01"},{"$f":"EDATE(H4,1)","v":"2019-02-01"},"2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","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",{"$f":"EDATE(AE4,1)","v":"2021-01-01"},{"$f":"EDATE(AF4,1)","v":"2021-02-01"},{"$f":"EDATE(AG4,1)","v":"2021-03-01"},{"$f":"EDATE(AH4,1)","v":"2021-04-01"},{"$f":"EDATE(AI4,1)","v":"2021-05-01"},{"$f":"EDATE(AJ4,1)","v":"2021-06-01"},{"$f":"EDATE(AK4,1)","v":"2021-07-01"},{"$f":"EDATE(AL4,1)","v":"2021-08-01"},{"$f":"EDATE(AM4,1)","v":"2021-09-01"},{"$f":"EDATE(AN4,1)","v":"2021-10-01"},{"$f":"EDATE(AO4,1)","v":"2021-11-01"},{"$f":"EDATE(AP4,1)","v":"2021-12-01"}]
[null,"Environmental Project","ActionType","Start Date","Deadline Date","Next Task","Project Start Date","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan2","Feb3","Mar4","Apr5","May6","Jun7","Jul8","Aug9","Sep10","Oct11","Nov12","Dec13","Jan22","Feb33","Mar44","Apr55","May66","Jun77","Jul88","Aug99","Sep1010","Oct1111","Nov1212","Dec1313"]
[{"$nulls":6},{"$f":"VLOOKUP(tblActionApprovalsTracking[[#This Row],[Environmental Project]],tblProjects[],4,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblActionApprovalsTracking[Environmental Project])","v":"Total : 0"}]

{"sheet":"Study Outcomes","index":5,"n_rows":6,"n_cols":10,"rows_kept":6}
[]
[null,"Study Outcomes"]
[]
[null,"Environmental Project","Type","Start Date","Finish Date","Results of Note","Constaints Identified? Y/N","Key Issues","Management Required","Comments"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblStudyOutcomes[Environmental Project])","v":"Total : 0"}]

{"sheet":"Studies","index":6,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[null,"Environmental Studies"]
[]
[null,"Environmental Project","Project Start Date","ActionType","Start Date","Deadline Date","Next Task","Completion Date","Study Status"]
[null,null,{"$f":"VLOOKUP(tblActionStudies[[#This Row],[Environmental Project]],tblProjects[],4,FALSE)","v":{"$error":"#N/A"}},{"$nulls":5},{"$f":"IFERROR(VLOOKUP(tblActionStudies[Next Task],tblNextTask[],2,FALSE),\"Not yet started\")","v":"Not yet started"}]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblActionStudies[Environmental Project])","v":"Total : 0"}]

{"sheet":"Studies by Status","index":7,"n_rows":6,"n_cols":3,"rows_kept":6}
[]
[]
["Count of Environmental Project","Column Labels"]
["Row Labels","Not yet started","Grand Total"]
["(blank)"]
["Grand Total"]

{"sheet":"Lookups","index":8,"n_rows":7,"n_cols":2,"rows_kept":7}
["Used to determine the Status of a Study Action"]
[]
["Next Task","Status"]
["Completed","Completed"]
["Complete surveys on site & compile data","In progress"]
["Review draft report","In progress"]
["Finalise and accept report","In progress"]