{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Tenement Details","Holders","Holder Changes","Dealings","Rent","Expenditure","Conditions","Blocks","Bonds","Relationships","Shires","MRF","Compliance","Native Title Referral","Procedure Detail","Claim","Representative Area Body","Water Comment","Objection","Determination Area","Wardens Court"],"not_rendered":{"images":1,"defined_names":44,"comments":21},"read":"whole","date_system":"1900"}

{"sheet":"Tenement Details","index":0,"n_rows":6,"n_cols":19,"rows_kept":6}
[null,"This Merge template is similar to the TenementDetailsMergeTemplate but does not include any of the LandTracker-specific data (eg Actions, Rates)"]
[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"},{"$nulls":10},{"$f":"SUBTOTAL(109,tblTenements[Approx Area Ha])","v":0}]

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

{"sheet":"Holder Changes","index":2,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[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":3,"n_rows":6,"n_cols":8,"rows_kept":6}
[]
[null,"Dealings"]
[]
[null,"Tenement","Type","Ref No","Lodged","Status","Status Date","Full Text"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblDealings[Tenement])","v":"Total : 0"}]

{"sheet":"Rent","index":4,"n_rows":6,"n_cols":12,"rows_kept":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"},{"$nulls":5},{"$f":"SUBTOTAL(109,tblRent[Amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblRent[Amount Due])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblRent[Discrepancy])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Expenditure","index":5,"n_rows":6,"n_cols":17,"rows_kept":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."]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblExpenditure[Tenement])","v":"Total : 0"},null,{"$f":"SUBTOTAL(109,tblExpenditure[Min. Exp.])","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUBTOTAL(109,tblExpenditure[Exp. Total])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Exemp. Amount])","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUBTOTAL(109,tblExpenditure[Expl. Activities])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Mining Activities])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Aboriginal Survey Activities])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Rent & Rates])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Admin.])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblExpenditure[Prospecting Exp.])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Conditions","index":6,"n_rows":6,"n_cols":9,"rows_kept":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":7,"n_rows":6,"n_cols":7,"rows_kept":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":8,"n_rows":6,"n_cols":7,"rows_kept":6}
[]
[null,"Bonds"]
[]
[null,"Tenement","Bond Date","Status","Status date","Dealing Number","Amount"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblBonds[Tenement])","v":"Total : 0"},{"$nulls":4},{"$f":"SUBTOTAL(109,tblBonds[Amount])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Relationships","index":9,"n_rows":6,"n_cols":7,"rows_kept":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":10,"n_rows":6,"n_cols":7,"rows_kept":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":11,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[null,"MRF"]
[]
[null,"Tenement","Year","Activity","Category","Disturbance Type","Disturbance Area","Rehabilitation Area","Rate"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblMRF[Tenement])","v":"Total : 0"}]

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

{"sheet":"Native Title Referral","index":13,"n_rows":6,"n_cols":9,"rows_kept":6}
[]
[null,"Native Title Referral"]
[]
[null,"Tenement","Referred To Native Title Date","Referral Type","Current Status","Procedure","Clearance Notification Date","Notification Date","Notification Close Date"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblReferral[Tenement])","v":"Total : 0"}]

{"sheet":"Procedure Detail","index":14,"n_rows":6,"n_cols":15,"rows_kept":6}
[]
[null,"Procedure Detail"]
[]
[null,"Tenement","Referred To Native Title Date","Referral Type","Current Status","Procedure","Procedure Outcome","Clearance Notification Date","Notification Date","Notification Close Date","Proposed Area To Grant","Area To Amalgamate","Locality","Purposes","Grantee Party Sec31 Letter Sent Date"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblReferral21[Tenement])","v":"Total : 0"}]

{"sheet":"Claim","index":15,"n_rows":6,"n_cols":8,"rows_kept":6}
[]
[null,"Claim"]
[]
[null,"Tenement","Claim Name","NNTT Number","Federal Court Number","Wholly Within?","Claim Status","Negotiation Status"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblClaim[Tenement])","v":"Total : 0"}]

{"sheet":"Representative Area Body","index":16,"n_rows":6,"n_cols":5,"rows_kept":6}
[]
[null,"Aboriginal Representative Area Bodies"]
[]
[null,"Tenement","Code","Region","Representative Body"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRepBody[Tenement])","v":"Total : 0"}]

{"sheet":"Water Comment","index":17,"n_rows":6,"n_cols":5,"rows_kept":6}
[]
[null,"Water Comment Under Sec 24HA(7)"]
[]
[null,"Tenement","Comment Under Sec 24HA(7) Received Date","Claim","Determined Area"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblWaterCom[Tenement])","v":"Total : 0"}]

{"sheet":"Objection","index":18,"n_rows":6,"n_cols":8,"rows_kept":6}
[]
[null,"Objection"]
[]
[null,"Tenement","Objection Number","Objection Received Date","Claim","Determined Area","Outcome","Outcome Date"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblObjection[Tenement])","v":"Total : 0"}]

{"sheet":"Determination Area","index":19,"n_rows":6,"n_cols":12,"rows_kept":6}
[]
[null,"Determination Areas"]
[]
[null,"Tenement","Native Title Holder","NNTT Number","Federal Court Number","Determination Number","Folio Number","Full Determination","Determination Decision","Wholly Within?","PBC Name Address","Negotiation Status"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblRates121320[Tenement])","v":"Total : 0"}]

{"sheet":"Wardens Court","index":20,"n_rows":6,"n_cols":10,"rows_kept":6}
[]
[null,"Wardens Court"]
[]
[null,"Tenement","Listing ID","Cause Date","Type","Warden","Proceeding Type","Cause List Ref No","Applicants","Respondents"]
[]
[null,{"$f":"\"Total : \" & SUBTOTAL(103,tblWardenCourt[Tenement])","v":"Total : 0"}]