{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Company Details","1 Appointment","exadDetails","2 Assets","detailsOfAssets","3 Remuneration","remunerations","4 Liabilities","creditor","5 Summary","6 Fair entitlement","7 Dividends","7a","dividends","8 Completion","Receipts","Payments","Lookups","lodgementDetails","appointees","fairEntitlement","receiptsAndPayments","receiptsAndPayments.summary","receiptsAndPayments.receipts","receiptsAndPayments.payments","risksOrTasks","CONFIG.receipts","CONFIG.payments","Data 1","Data 2","meeting","additionalInfo"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":80,"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":"Company Details","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,2,12,4],[3,1,3,2],[2,1,2,4],[0,6,0,9],[8,3,9,4],[6,2,6,4]]}
[null,"Australian Securities &\nInvestments Commission",null,null,null,null,"Form 5602"]
[]
[null,"Annual administration return"]
[]
[null,"Company or Pool Details"]
[]
[null,"Company name"]
[]
[null,"ACN / ABN / ARBN",null,"If ACN starts with 0, the ACN must be\nentered in the format 000 000 000"]
[]
["OR","Pool Details"]
[]
[null,"Pool Name"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]
[null,"Hint:  Use the mouse or Tab key to move through fields"]

{"sheet":"1 Appointment","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2],[17,7,17,10],[6,1,6,2],[10,3,10,5],[13,3,13,4],[7,2,7,5]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"1. Details of Appointment"]
[]
[null,"Date of commencement",null,"Date you first began to be an external administrator of the company"]
[]
[null,"Type of appointment"]
[]
[]
[null,"Period Covered by the Annual Return"]
[null,"Start Date"]
[]
[null,"End Date"]
[]
[null,"Appointees"]
[]
[null,"Start Date","Liquidator Number","Given Names","Family Name","Business Address","Country"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab",null,"Next Tab"]
[]
[]
[]
[null,"Note:  If you are a registered liquidator, you only provide your start date and registration number in the Appointees table above"]

{"sheet":"exadDetails","index":2,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["value","name","poolName","commenceDate","appointmentType","estCompletionDate"]
[{"$f":"CONCATENATE(acn,\"\")","v":""},{"$f":"IF(LEN(companyName)>0, companyName,\"\")","v":""},{"$f":"IF(LEN(poolName)>0, poolName,\"\")","v":""},{"$f":"IF(commenceDate=\"\",\"\",commenceDate)","v":""},{"$f":"IFERROR(VLOOKUP(appointmentType,AppointmentTypesAndCodes,2,FALSE),\"\")","v":""},{"$f":"IF(estCompletionDate=\"\",\"\",estCompletionDate)","v":""}]

{"sheet":"2 Assets","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"2. Details of Assets"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[null,null,"Low",null,"High"]
[]
[null,"Gross realisations to date",0,null,{"$f":"C9","v":0}]
[]
[null,"Future realisations"]
[]
[null,"Estimated total realisations",{"$f":"C9+C11","v":0},null,{"$f":"E9+E11","v":0}]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"detailsOfAssets","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["estimate","low","high","cashAtBank"]
["Gross realisations to date",{"$f":"IF('2 Assets'!C9=\"\",\"\",'2 Assets'!C9)","v":0},{"$f":"IF('2 Assets'!E9=\"\",\"\",'2 Assets'!E9)","v":0},{"$f":"IF(cashAtBank=\"\",\"\",cashAtBank)","v":0}]
["Future realisations",{"$f":"IF('2 Assets'!C11=\"\",\"\",'2 Assets'!C11)","v":""},{"$f":"IF('2 Assets'!E11=\"\",\"\",'2 Assets'!E11)","v":""}]
["Estimated total realisations",{"$f":"IF('2 Assets'!C13=0,\"\",'2 Assets'!C13)","v":""},{"$f":"IF('2 Assets'!E13=0,\"\",'2 Assets'!E13)","v":""}]

{"sheet":"3 Remuneration","index":5,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,3],[35,1,37,1]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"3. Details of Remuneration"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[]
[null,"Type of appointment",null,"Amount of remunation determined/fixed by creditors, committee or court (inc GST)",null,"Remuneration paid to date (inc GST)",null,"Disbursements paid to date (inc GST)"]
[]
[null,"Provisional liquidator"]
[]
[null,"Liquidator of a court liquidation"]
[]
[null,"Liquidator of creditors voluntary winding up"]
[]
[null,"Liquidator of members voluntary liquidation"]
[]
[null,"Liquidator of a simplified liquidation"]
[]
[null,"Restructuring practitioner"]
[]
[null,"Restructuring plan practitioner"]
[]
[null,"Deed administrator"]
[]
[null,"Administrator"]
[]
[null,"Receiver"]
[]
[null,"Receiver & Manager"]
[]
[null,"Managing Controller (other than receiver or manager)"]
[]
[null,"Scheme Administrator"]
[]
[null,"Controller (other than receiver, receiver & manager of managing controller"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"remunerations","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["appointmentType","fixedAmount","remunPaid","disbursePaid"]
["PQ",{"$f":"IF('3 Remuneration'!D10=\"\",\"\",'3 Remuneration'!D10)","v":""},{"$f":"IF('3 Remuneration'!F10=\"\",\"\",'3 Remuneration'!F10)","v":""},{"$f":"IF('3 Remuneration'!H10=\"\",\"\",'3 Remuneration'!H10)","v":""}]
["CQ",{"$f":"IF('3 Remuneration'!D12=\"\",\"\",'3 Remuneration'!D12)","v":""},{"$f":"IF('3 Remuneration'!F12=\"\",\"\",'3 Remuneration'!F12)","v":""},{"$f":"IF('3 Remuneration'!H12=\"\",\"\",'3 Remuneration'!H12)","v":""}]
["VQ",{"$f":"IF('3 Remuneration'!D14=\"\",\"\",'3 Remuneration'!D14)","v":""},{"$f":"IF('3 Remuneration'!F14=\"\",\"\",'3 Remuneration'!F14)","v":""},{"$f":"IF('3 Remuneration'!H14=\"\",\"\",'3 Remuneration'!H14)","v":""}]
["MQ",{"$f":"IF('3 Remuneration'!D16=\"\",\"\",'3 Remuneration'!D16)","v":""},{"$f":"IF('3 Remuneration'!F16=\"\",\"\",'3 Remuneration'!F16)","v":""},{"$f":"IF('3 Remuneration'!H16=\"\",\"\",'3 Remuneration'!H16)","v":""}]
["BI",{"$f":"IF('3 Remuneration'!D18=\"\",\"\",'3 Remuneration'!D18)","v":""},{"$f":"IF('3 Remuneration'!F18=\"\",\"\",'3 Remuneration'!F18)","v":""},{"$f":"IF('3 Remuneration'!H18=\"\",\"\",'3 Remuneration'!H18)","v":""}]
["BM",{"$f":"IF('3 Remuneration'!D20=\"\",\"\",'3 Remuneration'!D20)","v":""},{"$f":"IF('3 Remuneration'!F20=\"\",\"\",'3 Remuneration'!F20)","v":""},{"$f":"IF('3 Remuneration'!H20=\"\",\"\",'3 Remuneration'!H20)","v":""}]
["BP",{"$f":"IF('3 Remuneration'!D22=\"\",\"\",'3 Remuneration'!D22)","v":""},{"$f":"IF('3 Remuneration'!F22=\"\",\"\",'3 Remuneration'!F22)","v":""},{"$f":"IF('3 Remuneration'!H22=\"\",\"\",'3 Remuneration'!H22)","v":""}]
["AD",{"$f":"IF('3 Remuneration'!D24=\"\",\"\",'3 Remuneration'!D24)","v":""},{"$f":"IF('3 Remuneration'!F24=\"\",\"\",'3 Remuneration'!F24)","v":""},{"$f":"IF('3 Remuneration'!H24=\"\",\"\",'3 Remuneration'!H24)","v":""}]
["AC",{"$f":"IF('3 Remuneration'!D26=\"\",\"\",'3 Remuneration'!D26)","v":""},{"$f":"IF('3 Remuneration'!F26=\"\",\"\",'3 Remuneration'!F26)","v":""},{"$f":"IF('3 Remuneration'!H26=\"\",\"\",'3 Remuneration'!H26)","v":""}]
["RC",{"$f":"IF('3 Remuneration'!D28=\"\",\"\",'3 Remuneration'!D28)","v":""},{"$f":"IF('3 Remuneration'!F28=\"\",\"\",'3 Remuneration'!F28)","v":""},{"$f":"IF('3 Remuneration'!H28=\"\",\"\",'3 Remuneration'!H28)","v":""}]
["RM",{"$f":"IF('3 Remuneration'!D30=\"\",\"\",'3 Remuneration'!D30)","v":""},{"$f":"IF('3 Remuneration'!F30=\"\",\"\",'3 Remuneration'!F30)","v":""},{"$f":"IF('3 Remuneration'!H30=\"\",\"\",'3 Remuneration'!H30)","v":""}]
["MC",{"$f":"IF('3 Remuneration'!D32=\"\",\"\",'3 Remuneration'!D32)","v":""},{"$f":"IF('3 Remuneration'!F32=\"\",\"\",'3 Remuneration'!F32)","v":""},{"$f":"IF('3 Remuneration'!H32=\"\",\"\",'3 Remuneration'!H32)","v":""}]
["SM",{"$f":"IF('3 Remuneration'!D34=\"\",\"\",'3 Remuneration'!D34)","v":""},{"$f":"IF('3 Remuneration'!F34=\"\",\"\",'3 Remuneration'!F34)","v":""},{"$f":"IF('3 Remuneration'!H34=\"\",\"\",'3 Remuneration'!H34)","v":""}]
["CR",{"$f":"IF('3 Remuneration'!D36=\"\",\"\",'3 Remuneration'!D36)","v":""},{"$f":"IF('3 Remuneration'!F36=\"\",\"\",'3 Remuneration'!F36)","v":""},{"$f":"IF('3 Remuneration'!H36=\"\",\"\",'3 Remuneration'!H36)","v":""}]

{"sheet":"4 Liabilities","index":7,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"4. Details of Liabilities"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[]
[null,"Category",null,"Estimated number of creditors",null,"Estimated value"]
[]
[null,"Priority - Wages & Super incl SGC"]
[]
[null,"Priority - Leave of absence"]
[]
[null,"Priority - Retrenchment"]
[]
[null,"Secured"]
[]
[null,"Unsecured"]
[]
[null,"Deferred"]
[]
[null,"Note:  Claims are as at the date of appointment and exclude the impact of dividends paid to date."]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"creditor","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["category","estCount","estValue"]
["Priority - Wages & Super incl SGC",{"$f":"IF('4 Liabilities'!D10=\"\",\"\",'4 Liabilities'!D10)","v":""},{"$f":"IF('4 Liabilities'!F10=\"\",\"\",'4 Liabilities'!F10)","v":""}]
["Priority - Leave of absence",{"$f":"IF('4 Liabilities'!D12=\"\",\"\",'4 Liabilities'!D12)","v":""},{"$f":"IF('4 Liabilities'!F12=\"\",\"\",'4 Liabilities'!F12)","v":""}]
["Priority - Retrenchment",{"$f":"IF('4 Liabilities'!D14=\"\",\"\",'4 Liabilities'!D14)","v":""},{"$f":"IF('4 Liabilities'!F14=\"\",\"\",'4 Liabilities'!F14)","v":""}]
["Secured",{"$f":"IF('4 Liabilities'!D16=\"\",\"\",'4 Liabilities'!D16)","v":""},{"$f":"IF('4 Liabilities'!F16=\"\",\"\",'4 Liabilities'!F16)","v":""}]
["Unsecured",{"$f":"IF('4 Liabilities'!D18=\"\",\"\",'4 Liabilities'!D18)","v":""},{"$f":"IF('4 Liabilities'!F18=\"\",\"\",'4 Liabilities'!F18)","v":""}]
["Deferred",{"$f":"IF('4 Liabilities'!D20=\"\",\"\",'4 Liabilities'!D20)","v":""},{"$f":"IF('4 Liabilities'!F20=\"\",\"\",'4 Liabilities'!F20)","v":""}]

{"sheet":"5 Summary","index":9,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"5. Summary of Receipts and Payments"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[null,"Receipts:"]
[]
[null,"Total amounts you received before the period of this return"]
[]
[null,"Total amounts you received during the period of this return",null,{"$f":"Receipts!F3","v":0}]
[]
[null,"Total receipts",null,{"$f":"D9+D11","v":0}]
[]
[null,"Payments:"]
[]
[null,"Total amounts you paid before the period of this return"]
[]
[null,"Total amounts you paid during the period of this return",null,{"$f":"Payments!F3","v":0}]
[]
[null,"Total payments",null,{"$f":"D17+D19","v":0}]
[]
[]
[null,"Cash at bank at period end for this return",null,0]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"6 Fair entitlement","index":10,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"6. Payments under Fair entitlement guarantee scheme"]
[]
[null,"What is the amount paid during the period to employees under the Fair entitlement guarantee scheme or GEERS?"]
[]
[null,"Wages"]
[]
[null,"Leave of absence"]
[]
[null,"Retrenchment"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"7 Dividends","index":11,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[null,"7. Details of Dividends"]
[]
[null,"Estimate of dividends to be paid and actual dividends paid since your appointment and to the date of this account."]
[]
[null,"Category",null,"Current estimate of total rate of dividend",null,"Cumulative rate of dividend paid",null,"Total Paid"]
[]
[]
[null,"Priority - Wages & Super incl SGC"]
[]
[null,"Priority - Leave of absence"]
[]
[null,"Priority - Retrenchment"]
[]
[null,"Secured"]
[]
[null,"Unsecured"]
[]
[null,"Deferred"]
[]
[null,"Contributories"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"7a","index":12,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"Home",null,null,null,null,null,null,null,"Previous Tab"]
[]
[null,"Dividend Schedule"]
[]
[null,"Dividends paid since your appointment and to the date of this account (multiple payments per category permitted)."]
[null,"Category","Date","Amount","Rate","Units","CategoryDesc","TransactionType"]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table510[[#This Row],[Category]],DividendCategories,4,FALSE),\"\")","v":""},null,"Next Tab"]

{"sheet":"dividends","index":13,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["category","estDividend","rate","totalPaid"]
["Priority - Wages & Super incl SGC",{"$f":"IF('7 Dividends'!D10=\"\",\"\",'7 Dividends'!D10)","v":""},{"$f":"IF('7 Dividends'!F10=\"\",\"\",'7 Dividends'!F10)","v":""},{"$f":"IF('7 Dividends'!H10=\"\",\"\",'7 Dividends'!H10)","v":""}]
["Priority - Leave of absence",{"$f":"IF('7 Dividends'!D12=\"\",\"\",'7 Dividends'!D12)","v":""},{"$f":"IF('7 Dividends'!F12=\"\",\"\",'7 Dividends'!F12)","v":""},{"$f":"IF('7 Dividends'!H12=\"\",\"\",'7 Dividends'!H12)","v":""}]
["Priority - Retrenchment",{"$f":"IF('7 Dividends'!D14=\"\",\"\",'7 Dividends'!D14)","v":""},{"$f":"IF('7 Dividends'!F14=\"\",\"\",'7 Dividends'!F14)","v":""},{"$f":"IF('7 Dividends'!H14=\"\",\"\",'7 Dividends'!H14)","v":""}]
["Secured",{"$f":"IF('7 Dividends'!D16=\"\",\"\",'7 Dividends'!D16)","v":""},{"$f":"IF('7 Dividends'!F16=\"\",\"\",'7 Dividends'!F16)","v":""},{"$f":"IF('7 Dividends'!H16=\"\",\"\",'7 Dividends'!H16)","v":""}]
["Unsecured",{"$f":"IF('7 Dividends'!D18=\"\",\"\",'7 Dividends'!D18)","v":""},{"$f":"IF('7 Dividends'!F18=\"\",\"\",'7 Dividends'!F18)","v":""},{"$f":"IF('7 Dividends'!H18=\"\",\"\",'7 Dividends'!H18)","v":""}]
["Deferred",{"$f":"IF('7 Dividends'!D20=\"\",\"\",'7 Dividends'!D20)","v":""},{"$f":"IF('7 Dividends'!F20=\"\",\"\",'7 Dividends'!F20)","v":""},{"$f":"IF('7 Dividends'!H20=\"\",\"\",'7 Dividends'!H20)","v":""}]
["Contributories",{"$f":"IF('7 Dividends'!D22=\"\",\"\",'7 Dividends'!D22)","v":""},{"$f":"IF('7 Dividends'!F22=\"\",\"\",'7 Dividends'!F22)","v":""},{"$f":"IF('7 Dividends'!H22=\"\",\"\",'7 Dividends'!H22)","v":""}]

{"sheet":"8 Completion","index":14,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Home",null,null,null,"Previous Tab"]
[]
[null,null,"8. Completion"]
[]
[null,null,"Estimated completion date:"]
[]
[]
[]
[null,null,"Causes which may delay the termination of your appointment","Please provide details:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Next Tab"]

{"sheet":"Receipts","index":15,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Home",null,null,null,null,null,"Previous Tab"]
[]
[null,"Account of receipts for the period",null,null,"Total Receipts:",{"$f":"SUM(F7:F99999)","v":0}]
[]
[]
[null,"General Ledger Name","Transaction Category","Date","Received From","Amount (incl tax)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"Payments","index":16,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Home",null,null,null,null,null,"Previous Tab"]
[]
[null,"Account of payments for the period",null,null,"Total Payments:",{"$f":"SUM(F7:F100006)","v":0}]
[]
[]
[null,"General Ledger Name","Transaction Category","Date","Paid To","Amount (incl tax)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"Lookups","index":17,"n_rows":98,"n_cols":5,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
[null,null,"Appointment Type Code:"]
["Filename",{"$f":"CONCATENATE(\"Form5602_\", IF(LEN(acn)>0,acn,IF(LEN('Company Details'!C7)>0,'Company Details'!C7,IF(LEN(poolName)>0,poolName,\"5602\"))), \".xlsx\")","v":"Form5602_5602.xlsx"},{"$f":"IF(appointmentType=\"\",\"\",VLOOKUP(appointmentType,AppointmentTypesAndCodes,2,FALSE))","v":""}]
[]
["Appointment Types","Administrator","AC"]
[null,"Provisional liquidator","PQ"]
[null,"Liquidator of Court liquidation","CQ"]
[null,"Liquidator of members' voluntary liquidation","MQ"]
[null,"Liquidator of creditors' voluntary liquidation","VQ"]
[null,"Liquidator of a simplified liquidation","BI"]
[null,"Restructuring practitioner","BM"]
[null,"Restructuring plan practitioner","BP"]
[null,"Receiver","RC"]
[null,"Receiver and manager","RM"]
[null,"Managing controller (other than receiver and manager)","MC"]
[null,"Controller (other than receiver, receiver and manager or managing controller)","CR"]
[null,"Deed administrator","AD"]
[null,"Scheme administrator","SM"]
[]
["Appointment methods","Appointment by court order","COURTORD"]
[null,"Appointment by instrument","INSTRMNT"]
[null,"Appointment other than by court or instrument","OTHERTHA"]
[]
["Court types","Federal Court of Australia","FEDERAL"]
[null,"Family Court of Australia","FAMILY"]
[null,"Supreme Court","SUPREME"]
[]
["States","ACT"]
[null,"NSW"]
[null,"VIC"]
[null,"NT"]
[null,"QLD"]
[null,"SA"]
[null,"VIC"]
[null,"TAS"]
[null,"WA"]
[]
["Instrument Register Types","Personal Property Securities Register","AUSTREGR"]
[null,"Instrument not registered","NOTREGTR"]
[null,"Other register","OTHERREG"]
[]
["YesNo","Yes",true]
[null,"No",false]
[]
["Creditor Categories","Contributories","Dividend - Contributories creditor","$/share","PAYMENT"]
[null,"Deferred","Dividend - Deferred creditor","cents/$","PAYMENT"]
[null,"Priority","Dividend - Priority creditor","cents/$","PAYMENT"]
[null,"Secured","Dividend - Secured creditor","n/a","PAYMENT"]
[null,"Unsecured","Dividend - Unsecured creditor (inc statutory)","cents/$","PAYMENT"]
[]
["Months","January","01"]
[null,"February","02"]
[null,"March","03"]
[null,"April","04"]
[null,"May","05"]
[null,"June","06"]
[null,"July","07"]
[null,"August","08"]
[null,"September","09"]
[null,"October","10"]
[null,"November","11"]
[null,"December","12"]
[]
["Completion Causes","Future asset realisations"]
[null,"Investigations"]
[null,"Litigation"]
[null,"Payment of dividend"]
[null,"Other"]
[]
[]
["transactionCategoryReceipts","Sale of business"]
[null,"Land and buildings"]
[null,"Plant and Equipment"]
[null,"Cash on Hand/Bank"]
[null,"Work in progress"]
[null,"Inventory"]
[null,"Sundry Debtors"]
[null,"Other (Pre appointment Assets)"]
[null,"Legal Recoveries"]
[null,"Antecedent Transactions"]
[null,"Trading Receipts"]
[null,"Other Receipts"]
[null,"GST Received"]
[null,"FEGS Received"]
["transactionCategoryPayments","Appointee - remuneration"]
[null,"Appointee - disbursements"]
[null,"Legal Fees"]
[null,"Property Realisation and Preservation Costs"]
[null,"Other Cost of Realisation"]
[null,"GST Paid"]
[null,"Payroll Expenses"]
[null,"Purchases"]
[null,"Other Trading Expense"]
[null,"FEGS Paid"]
[null,"Priority Creditors"]
[null,"Unsecured Creditors"]
[null,"Secured Creditors"]
[null,"Deferred Creditors"]
[null,"Contributories Creditors"]

{"sheet":"lodgementDetails","index":18,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["reportStartDate","reportEndDate"]
[{"$f":"IF(reportStartDate=\"\",\"\",reportStartDate)","v":""},{"$f":"IF(reportEndDate=\"\",\"\",reportEndDate)","v":""}]

{"sheet":"appointees","index":19,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["appointmentStartDate","liquidatorNo","givenNames","familyName","adressLine","country","iso3166CountryCode"]

{"sheet":"fairEntitlement","index":20,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["wages","leaves","retrenchment"]
[{"$f":"IF('6 Fair entitlement'!C8=\"\",\"\",'6 Fair entitlement'!C8)","v":""},{"$f":"IF('6 Fair entitlement'!C10=\"\",\"\",'6 Fair entitlement'!C10)","v":""},{"$f":"IF('6 Fair entitlement'!C12=\"\",\"\",'6 Fair entitlement'!C12)","v":""}]

{"sheet":"receiptsAndPayments","index":21,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["prevReceipts","prevPayments","currReceipts","currPayments"]

{"sheet":"receiptsAndPayments.summary","index":22,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["prevReceipt","prevPayments","currReceipt","currPayments"]
[{"$f":"IF('5 Summary'!D9=\"\",\"\",'5 Summary'!D9)","v":""},{"$f":"IF('5 Summary'!D17=\"\",\"\",'5 Summary'!D17)","v":""},{"$f":"IF('5 Summary'!D11=\"\",\"\",'5 Summary'!D11)","v":0},{"$f":"IF('5 Summary'!D19=\"\",\"\",'5 Summary'!D19)","v":0}]

{"sheet":"receiptsAndPayments.receipts","index":23,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ledgerName","category","date","payee","amt"]

{"sheet":"receiptsAndPayments.payments","index":24,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ledgerName","category","date","payee","amt"]

{"sheet":"risksOrTasks","index":25,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["type","details"]
["Causes which may delay the termination of your appointment","Please provide details:"]

{"sheet":"CONFIG.receipts","index":26,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["transactionCategory"]
["Sale of business"]
["Land and buildings"]
["Plant and Equipment"]
["Cash on Hand/Bank"]
["Work in progress"]
["Inventory"]
["Sundry Debtors"]
["Other (Pre appointment Assets)"]
["Legal Recoveries"]
["Antecedent Transactions"]
["Trading Receipts"]
["Other Receipts"]
["GST Received"]
["FEGS Received"]

{"sheet":"CONFIG.payments","index":27,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["transactionCategory"]
["Appointee - remuneration"]
["Appointee - disbursements"]
["Legal Fees"]
["Property Realisation and Preservation Costs"]
["Other Cost of Realisation"]
["GST Paid"]
["Payroll Expenses"]
["Purchases"]
["Other Trading Expense"]
["FEGS Paid"]
["Priority Creditors"]
["Unsecured Creditors"]
["Secured Creditors"]
["Deferred Creditors"]
["Contributories Creditors"]

{"sheet":"Data 1","index":28,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blank worksheet provided for data import."]

{"sheet":"Data 2","index":29,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blank worksheet provided for data import."]

{"sheet":"meeting","index":30,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["meetingName","meetingDate","meetingQuorum","dateLodged"]
[{"$f":"IF(AND(OR(LEN(meetingDate)>0,LEN(dateLodged)>0), appointmentTypeCode = \"VQ\"), \"Annual meeting of creditors\", \"\")","v":{"$error":"#NAME?"}},{"$f":"IF(AND(LEN(meetingDate)>0, appointmentTypeCode = \"VQ\"), meetingDate, \"\")","v":{"$error":"#NAME?"}},{"$f":"IF(AND(LEN(meetingQuorum) >0, appointmentTypeCode = \"VQ\"), VLOOKUP(meetingQuorum,YesNo,2,FALSE), \"\")","v":{"$error":"#NAME?"}},{"$f":"IF(AND(appointmentTypeCode = \"VQ\", LEN(dateLodged)>0), dateLodged, \"\")","v":{"$error":"#NAME?"}}]

{"sheet":"additionalInfo","index":31,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["disposalOfAssets"]