{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["About","Tenement Details","Holders","Holder Changes","Dealings","Rent","Expenditure","Formulas","Conditions","Blocks","Bonds","Relationships","Shires","MRF","Compliance","Pivot Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":31,"comments":13,"pivot_tables":1},"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":"About","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"About this Merge Template"]
[null,"Tenement Details with Expenditure Highlights"]
[null,"This Merge template is similar to the TenementDetailsMergeTemplate but does not include any of the LandTracker-specific data (eg Actions, Rates)."]
[null,"Additional functionality highlights rows on the Expenditure tab if a forfeiture application was lodged, and includes a column showing the Forfeiture Application Number."]
[null,"The Pivot Table tab provides a summary by Combined Reporting Group of each year's expenditure and commitment. Click a year to filter the list."]
[null,"Due to the macros and formulas used to generate this additional functionality, modifications to the Tenement Details, Dealings or Expenditure tabs may cause this template to cease functioning."]
[null,"Please contact Support if changes are required."]

{"sheet":"Tenement Details","index":1,"n_rows":6,"n_cols":19,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Due Diligence Report - Tenement Details"]
[]
[null,"Name","Type","Jurisdiction","Holders","Status","Expiry","Commence","Last Rent","Next Rent","Next Commitment","Current Area","Approx Area Ha","Application Area","Grant Area","Mark Out","Received","Reporting Group","Warnings"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblTenements[Name])","v":"Total : 0"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,tblTenements[Approx Area Ha])","v":0}]

{"sheet":"Holders","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Holders"]
[]
[null,"Tenement","Company Name","Correspondence Address","Shares"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblHolders[Tenement])","v":"Total : 0"}]

{"sheet":"Holder Changes","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Holder Changes"]
[]
[null,"Tenement","Type","Ref No","Status","From Holder","From Shares","To Holder","To Shares"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblHolderChanges[Tenement])","v":"Total : 0"}]

{"sheet":"Dealings","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Dealings"]
[]
[null,"Tenement","Type","Ref No","Lodged","Status","Status Date","Full Text","Tenement Previous Anniversary"]
[null,null,null,null,null,null,null,null,{"$f":"IF(DATE(YEAR(tblDealings[[#This Row],[Lodged]]),MONTH(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE)),DAY(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE)))>tblDealings[[#This Row],[Lodged]],DATE(YEAR(tblDealings[[#This Row],[Lodged]])-1,MONTH(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE)),DAY(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE))),DATE(YEAR(tblDealings[[#This Row],[Lodged]]),MONTH(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE)),DAY(VLOOKUP(tblDealings[[#This Row],[Tenement]],tblTenements[],6,FALSE))))","v":{"$error":"#N/A"}}]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblDealings[Tenement])","v":"Total : 0"}]

{"sheet":"Rent","index":5,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Rent"]
[]
[null,"Tenement","Type","Year","Receipt Date","Receipt No","Registrar Lodged","Amount","Amount Due","Discrepancy","Rental Area","Effective Date"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRent[Tenement])","v":"Total : 0"},null,null,null,null,null,{"$f":"SUBTOTAL(109,tblRent[Amount])","v":0},{"$f":"SUBTOTAL(109,tblRent[Amount Due])","v":0},{"$f":"SUBTOTAL(109,tblRent[Discrepancy])","v":0}]

{"sheet":"Expenditure","index":6,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Expenditure"]
[]
[null,"Tenement","Year","Min. Exp.","Lodge Date","Exp. Total","Exemp. Amount","Exemp. Lodged Date","Exemp. No","Exemp. Status","Outcome Date","Expl. Activities","Mining Activities","Aboriginal Survey Activities","Rent & Rates","Admin.","Prospecting Exp.","CRG","Anniversary","Forfeiture Application Lodged?","Forfeiture Application Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(tblExpenditure[Tenement],tblTenements[],17,FALSE)=\"\",\"Not in a CRG\",VLOOKUP(tblExpenditure[Tenement],tblTenements[],17,FALSE))","v":{"$error":"#N/A"}},{"$f":"DATE(tblExpenditure[[#This Row],[Year]],MONTH(VLOOKUP(tblExpenditure[[#This Row],[Tenement]],tblTenements[],6,FALSE)),DAY(VLOOKUP(tblExpenditure[[#This Row],[Tenement]],tblTenements[],6,FALSE)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(INDEX(tblDealings[],MATCH(1,(tblDealings[Tenement]=tblExpenditure[[#This Row],[Tenement]])*(tblDealings[Tenement Previous Anniversary]=tblExpenditure[[#This Row],[Anniversary]])*(tblDealings[Type]=\"Application for Forfeiture\"),0),3)),\"N\",\"Y\")","v":"N"},{"$f":"IFERROR(INDEX(tblDealings[],MATCH(1,(tblDealings[Tenement]=tblExpenditure[[#This Row],[Tenement]])*(tblDealings[Tenement Previous Anniversary]=tblExpenditure[[#This Row],[Anniversary]])*(tblDealings[Type]=\"Application for Forfeiture\"),0),3),\"\")","v":""}]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblExpenditure[Tenement])","v":"Total : 0"},null,{"$f":"SUBTOTAL(109,tblExpenditure[Min. Exp.])","v":0},null,{"$f":"SUBTOTAL(109,tblExpenditure[Exp. Total])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Exemp. Amount])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,tblExpenditure[Expl. Activities])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Mining Activities])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Aboriginal Survey Activities])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Rent & Rates])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Admin.])","v":0},{"$f":"SUBTOTAL(109,tblExpenditure[Prospecting Exp.])","v":0}]

{"sheet":"Formulas","index":7,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["These are converted to array formulas after merge has run"]
[]
[]
[]
["Worksheet","Column","Formula"]
["Expenditure sheet","Forfeiture Application Lodged?","IF(ISERROR(INDEX(tblDealings,MATCH(1,(tblDealings[Tenement]=[@Tenement])*(tblDealings[Tenement Previous Anniversary]=[@Anniversary])*(tblDealings[Type]=\"Application for Forfeiture\"),0),3)),\"N\",\"Y\")"]
["Expenditure sheet","Forfeiture Application Number","IFERROR(INDEX(tblDealings,MATCH(1,(tblDealings[Tenement]=[@Tenement])*(tblDealings[Tenement Previous Anniversary]=[@Anniversary])*(tblDealings[Type]=\"Application for Forfeiture\"),0),3),\"\")"]

{"sheet":"Conditions","index":8,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Conditions & Endorsements"]
[]
[null,"Tenement","Type","No","Version","Start Date","End Date","Header","Text"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblConditions[Tenement])","v":"Total : 0"}]

{"sheet":"Blocks","index":9,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Blocks"]
[]
[null,"Tenement","Area Type","Is Current","Million Plan","Primary","Graticules"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblBlocks[Tenement])","v":"Total : 0"}]

{"sheet":"Bonds","index":10,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Bonds"]
[]
[null,"Tenement","Bond Date","Status","Status Date","Dealing Number","Amount"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblBonds[Tenement])","v":"Total : 0"},null,null,null,null,{"$f":"SUBTOTAL(109,tblBonds[Amount])","v":0}]

{"sheet":"Relationships","index":11,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Relationships"]
[]
[null,"Tenement","Dealing","Status","Related Tenement","Tenement Status","Type"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRelationships[Tenement])","v":"Total : 0"}]

{"sheet":"Shires","index":12,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Shires"]
[]
[null,"Tenement","Shire Name","Shire No","Start Date","Area","Assessment Number"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblShires[Tenement])","v":"Total : 0"},{"$f":"SUBTOTAL(103,tblShires[Shire Name])","v":0}]

{"sheet":"MRF","index":13,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"MRF"]
[]
[null,"Tenement","Year","Activity","Category","Disturbance Type","Disturbance Area","Rehabilitation Area","Rate"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRates12[Tenement])","v":"Total : 0"}]

{"sheet":"Compliance","index":14,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Compliance"]
[]
[null,"Tenement","Name","Type","Status","Due Date","Amount","Details"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRates1213[Tenement])","v":"Total : 0"}]

{"sheet":"Pivot Table","index":15,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of Min. Exp.","Sum of Exp. Total"]
["(blank)"]
["#N/A"]
["(blank)"]
["Grand Total"]