{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Tab 1","Tab 2","Tab 3","Tab 4","Tab 5","Tab 5a","Tab 6","Tab 7","Tab 8","Tab 9","Lookups","lodgementDetails","exadDetails","appointment","appointees","meeting","taskAndRisk","creditor","statementOfFinancialPosition","receiptsAndPayments.summary","receiptsAndPayments.receipts","receiptsAndPayments.payments","additionalInfo","CONFIG.receipts","CONFIG.payments","Data 1","Data 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":139,"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":"Tab 1","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,2],[10,1,10,2],[0,1,0,4],[16,5,16,8],[6,3,8,3]]}
[null,"Form 524 - Presentation of Accounts and Statements"]
[]
[]
[null,"Company or Pool Details"]
[null,"Company Details"]
[null,"Company name"]
[null,"A.C.N / A.B.N / ARBN",null,"If ACN starts with 0, the ACN must be entered in the format 000 000 000"]
["OR","Pool Details"]
[null,"Pool Name"]
[]
[null,"1. Details of Appointment"]
[]
[null,"Date of commencement"]
[null,"Type of appointment"]
[]
[null,"Appointees"]
[null,"Start Date","End Date","Firm Name","Liquidator Number"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"Tab 2","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,3,8,4],[3,1,3,2],[6,3,6,5],[0,4,0,5],[10,4,10,5]]}
[null,"Home",null,null,"Previous Tab"]
[]
[]
[null,"Details of the accounts"]
[]
[null,"Are the accounts final?"]
[null,"Reporting Period",null,"The period for which the accounts and statements are made up must not be more than 6 months"]
[null,"Start Date"]
[null,"End Date",null,"For final accounts this is also the date of ceasing to act"]
[]
[null,null,null,null,"Next Tab"]

{"sheet":"Tab 3","index":2,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,4,24,4],[0,4,0,5],[26,4,26,5],[2,1,2,2],[21,1,21,2]]}
[null,"Home",null,null,"Previous Tab"]
[]
[null,"1. Details of appointment"]
[null,"Details of the original appointment"]
[null,"Method of Appointment",null,null,"Complete this section only if you are a controller"]
[null,"For Appointment by Court Order"]
[null,"Court Type"]
[null,"Court State"]
[null,"Date of obtaining order"]
[null,"Proceeding matter number"]
[null,"Year"]
[null,"For Appointment by Instrument"]
[null,"Date of instrument"]
[null,"Description of instrument"]
[null,"Register Type"]
[null,"Instrument details"]
[null,"Security Interest Number"]
[null,"Other Register Details"]
[null,"Name of Appointer"]
[]
[]
[null,"3. Secured lenders"]
[null,"Amount owing under instrument at the date of appointment/control day",0]
[null,"Amount owing under instrument at date of this account",0]
[null,"Estimated value of property subject to the instrument at date of this account",0]
[]
[null,null,null,null,"Next Tab"]

{"sheet":"Tab 4","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,4,10,6],[0,7,0,8],[2,1,2,2]]}
[null,"Home",null,null,null,null,null,"Previous Tab"]
[null,null,null,null,"Complete this section only if you are a members or creditors voluntary liquidator"]
[null,"1. Details of appointment"]
[null,"Creditors' meeting or report"]
[null,"Date of last annual meeting of creditors"]
[null,"Was a quorum present at this meeting?"]
[null,"OR"]
[null,"The liquidator decided not to convene a meeting of the creditors and has lodged a copy of the report with ASIC"]
[null,"Date report lodged with ASIC"]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"Tab 5","index":4,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[13,1,13,2],[26,1,27,1],[0,4,0,5],[26,3,27,4]]}
[null,"Home",null,null,"Previous Tab"]
[]
[null,"2. Dividend"]
[null,"Your estimate of total creditors in this administration at the date of this account"]
[null,"Category","Estimated number of creditors","Estimated value $"]
[null,"Priority"]
[null,"Secured"]
[null,"Unsecured"]
[null,"Deferred"]
[]
[null,"Dividends paid since your appointment and to the date of this account."]
[null,"Click here to provide schedule"]
[]
[null,"4. Summary of professional fees and completion dates"]
[null,"Professional fees and outlays"]
[null,"Remuneration paid to you during the period for which this account is made up (inclusive of GST)"]
[null,"Remuneration paid to you from the date of your appointment to the date to which this account is made up (inclusive of GST)"]
[null,"Amount received by you in respect of expenses during the period for which this account is made up (inclusive of GST)"]
[null,"Amount received by you in respect of expenses from the date of your appointment to the date to which this account is made up (inclusive of GST)"]
[]
[null,"Estimated completion date"]
[null,"Month"]
[null,"Year"]
[]
[]
[]
[null,"Details of causes which may delay the termination of your appointment","Risks and Tasks"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Next Tab"]

{"sheet":"Tab 5a","index":5,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,5,0,9]]}
[null,"Home",null,null,null,"Back to Dividend Information"]
[]
[null,"2.1. 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":""}]

{"sheet":"Tab 6","index":6,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,2,2],[0,3,0,4],[23,3,23,4],[20,3,20,4],[18,3,18,4],[15,3,15,4],[10,3,10,4],[7,3,7,4],[6,3,6,4]]}
[null,"Home",null,"Previous Tab"]
[]
[null,"5. Account of receipts and payments"]
[]
[null,"Receipts (Exclude the principal component of matured investments)"]
[null,"Total amounts received by you before the period for which this account has been made up"]
[null,"Total amount received by you during the period for which this account has been made up (attach detailed schedule)",{"$f":"SUM(Table1[Amount (incl tax)])","v":0}]
[null,"Total Receipts",{"$f":"SUM(C6:C7)","v":0}]
[null,"Payments (Exclude the principal amounts invested or rolled over)"]
[null,"Total payments made by you before the period for which this account has been made up"]
[null,"Payments made by you during the period for which this account has been made up (attach detailed schedule)",{"$f":"SUM(Table3[Amount (incl tax)])","v":0}]
[null,"Total Payments",{"$f":"SUM(C10:C11)","v":0}]
[null,"Reconciliation of money held"]
[null,"Cash in hand"]
[null,"Cash at bank"]
[null,"Credit as per bank statement"]
[null,"Less unpresented cheques"]
[null,"Add outstanding deposits"]
[null,null,{"$f":"C16-C17+C18","v":0}]
[null,"Amounts invested and not converted to cash"]
[null,"Total balance of money held",{"$f":"SUM(C20,C19,C14)","v":0}]
[]
[]
[null,null,null,"Next Tab"]

{"sheet":"Tab 7","index":7,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,6,0,7],[41,6,41,7],[2,1,2,3],[7,1,7,3],[32,1,37,1],[2,5,39,5]]}
[null,"Home",null,null,null,null,"Previous Tab"]
[]
[null,"6. Estimated outcome",null,null,null,"Complete this section only if you are a appointed a creditors voluntary or court appointed liquidator and expect to pay a dividend"]
[]
[null,"Do you expect that a dividend will be paid to any class of creditor?"]
[]
[]
[null,"Statement of financial position and estimated outcome of your appointment"]
[]
[null,"Expected net asset recoveries"]
[null,null,"Estimated (High)","Estimated (Low)"]
[null,"Total money held at date of this account (amount taken section 6)",{"$f":"IF(dividendTobePaid = \"Yes\", 'Tab 6'!C21,0)","v":0},{"$f":"C12","v":0}]
[null,"Interest in land"]
[null,"Sundry debtors"]
[null,"Stock on hand"]
[null,"Work in progress"]
[null,"Plant and equipment"]
[null,"Potential legal recoveries"]
[null,"Contingent assets"]
[null,"Other recoveries"]
[null,"Expected net asset recoveries at date of this account",{"$f":"SUM(C12:C20)","v":0},{"$f":"SUM(D12:D20)","v":0}]
[null,"Less estimated future insolvency practitioners remuneration"]
[null,"Less estimated future other payments or costs incurred"]
[null,"Estimated net asset recoveries at date of this account available for further dividends to creditors",{"$f":"C21-SUM(C22:C23)","v":0},{"$f":"D21-SUM(D22:D23)","v":0}]
[null,"Less estimated future dividends to priority creditors"]
[null,"Less estimated future payments to secured creditors"]
[null,"Less estimated future dividends to unsecured creditors"]
[null,"Less estimated future dividends to deferred creditors"]
[null,"Balance for contributories",{"$f":"IF(dividendTobePaid = \"Yes\",+C24-SUM(C25:C28),\"\")","v":""},{"$f":"IF(dividendTobePaid = \"Yes\",+D24-SUM(D25:D28),\"\")","v":""}]
[]
[]
[null,"Additional Information","Disposal of Assets"]
[null,"Provide details of any arrangement where assets of the company have been disposed of by you for consideration other than for cash or of any benefit that you have received directly or indirectly resulting from this appointment."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Next Tab"]

{"sheet":"Tab 8","index":8,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,1,2,3],[0,6,0,7],[26,6,26,7]]}
[null,"Home",null,null,null,null,"Previous Tab"]
[]
[null,"7. Account of receipts for the period"]
[null,"(tab at end of last row to extend table)"]
[null,"Date","Received From","Transaction Category","Transaction Details","Amount (incl tax)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Next Tab"]

{"sheet":"Tab 9","index":9,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,3],[0,6,0,7]]}
[null,"Home",null,null,null,null,"Previous Tab"]
[]
[null,"8. Account of payments for the period"]
[null,"(tab at end of last row to extend table)"]
[null,"Date","Payments To","Transaction Category","Transaction Details","Amount (incl tax)"]

{"sheet":"Lookups","index":10,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
["Filename",{"$f":"CONCATENATE(\"Form524_\", IF(LEN(acn)>0,acn,IF(LEN('Tab 1'!C6)>0,'Tab 1'!C6,IF(LEN(poolName)>0,poolName,\"524\"))), \".xlsx\")","v":"Form524_524.xlsx"}]
[]
["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,"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 under Part 5.1","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"]

{"sheet":"lodgementDetails","index":11,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["reportPeriodStartDate","reportPeriodEndDate","finalReport"]
[{"$f":"'Tab 2'!C8","v":"00:00:00"},{"$f":"'Tab 2'!C9","v":"00:00:00"},{"$f":"VLOOKUP(finalReport,YesNo,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"exadDetails","index":12,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["companyACN","companyName","poolName","commencementDate","appointmentType","estimatedCompletionDate","dividendToBePaid"]
[{"$f":"CONCATENATE(acn,\"\")","v":""},{"$f":"IF(LEN(companyName)>0, companyName,\"\")","v":""},{"$f":"IF(LEN(poolName)>0, poolName,\"\")","v":""},{"$f":"IF(commencementDate >0, commencementDate,\"\")","v":""},{"$f":"VLOOKUP(appointmentType,Lookups!B4:C14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"DATEVALUE(CONCATENATE(VLOOKUP('Tab 5'!C22,Months, 2, FALSE), \"/\", 'Tab 5'!C23))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Tab 7'!C5,YesNo,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"appointment","index":13,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["methodOfAppointment","courtType","courtState","obtainOrderDate","matterNumber","matterYear","instrumentDate","instrumentDesc","registerType","securityInterestNumber","otherRegisterDetails","nameOfAppointer"]
[{"$f":"VLOOKUP('Tab 3'!C5,MethodsOfAppointment,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(LEN(courtType)>0, VLOOKUP('Tab 3'!C7,CourtTypes,2,FALSE),\"\")","v":""},{"$f":"IF(LEN(courtState)>0, courtState, \"\")","v":""},{"$f":"IF(obtainOrderDate > 0, obtainOrderDate,\"\")","v":""},{"$f":"IF(LEN(matterNumber)>0, matterNumber,\"\")","v":""},{"$f":"IF(matterYear>0, matterYear,\"\")","v":""},{"$f":"IF(instrumentDate > 0, instrumentDate, \"\")","v":""},{"$f":"IF(LEN(instrumentDesc)>0,instrumentDesc,\"\")","v":""},{"$f":"IF(ISBLANK(registerType),\"\",VLOOKUP(registerType,InstrumentRegisterTypes,2,FALSE))","v":""},{"$f":"IF(LEN(securityInterestNumber)>0, securityInterestNumber, \"\")","v":""},{"$f":"IF(LEN(otherRegisterDetails)>0, otherRegisterDetails,\"\")","v":""},{"$f":"IF(ISBLANK(nameOfAppointer),\"\", nameOfAppointer)","v":""}]

{"sheet":"appointees","index":14,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["appointmentStartDate","appointmentEndDate","firmName","liquidatorNo"]

{"sheet":"meeting","index":15,"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":"#N/A"}},{"$f":"IF(AND(LEN(meetingDate)>0, appointmentTypeCode = \"VQ\"), meetingDate, \"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(LEN(meetingQuorum) >0, appointmentTypeCode = \"VQ\"), VLOOKUP(meetingQuorum,YesNo,2,FALSE), \"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(appointmentTypeCode = \"VQ\", LEN(dateLodged)>0), dateLodged, \"\")","v":{"$error":"#N/A"}}]

{"sheet":"taskAndRisk","index":16,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["taskAndRiskDetails"]
["None identified."]

{"sheet":"creditor","index":17,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["category","estimatedCreditorCount","estimatedValue"]
["Priority",{"$f":"'Tab 5'!C6","v":0},{"$f":"'Tab 5'!D6","v":0}]
["Secured",{"$f":"'Tab 5'!C7","v":0},{"$f":"'Tab 5'!D7","v":0}]
["Unsecured",{"$f":"'Tab 5'!C8","v":0},{"$f":"'Tab 5'!D8","v":0}]
["Deferred",{"$f":"'Tab 5'!C9","v":0},{"$f":"'Tab 5'!D9","v":0}]

{"sheet":"statementOfFinancialPosition","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["transactionType","categoryType","value.actual","value.estimated.low","value.estimated.high","valueWithheld"]
["LIABILITY","Amount owing under instrument at the date of appointment/control day",{"$f":"IF(securedOriginalValue>0, securedOriginalValue, \"\")","v":""},null,null,{"$f":"IF(LEN(C2)>0,FALSE,TRUE)","v":true}]
["LIABILITY","Amount owing under instrument at date of this account",{"$f":"IF(securedCurrentDebt>0, securedCurrentDebt, \"\")","v":""},null,null,{"$f":"IF(LEN(C3)>0,FALSE,TRUE)","v":true}]
["ASSET","Estimated value of property subject to the instrument at the date of this account",{"$f":"IF(securedCurrentValue>0, securedCurrentValue, \"\")","v":""},null,null,true]
["ASSET","Cash in Hand",{"$f":"IF(cashInHand=\"\", 0, cashInHand)","v":0},null,null,false]
["ASSET","Cash at Bank - per bank statement",{"$f":"IF(creditAsPerBankStatement =\"\",0, creditAsPerBankStatement)","v":0},null,null,false]
["LIABILITY","Cash at Bank - Unpresented Cheques",{"$f":"IF(unpresentedCheques=\"\", 0,unpresentedCheques)","v":0},null,null,false]
["ASSET","Cash at Bank - Outstanding Deposits",{"$f":"IF(outstandingDeposits=\"\",0, outstandingDeposits)","v":0},null,null,false]
["ASSET","Amounts invested and not converted to cash",{"$f":"IF(investmentsNotCash=\"\",0, investmentsNotCash)","v":0},null,null,false]
["ASSET","Interests in Land",null,{"$f":"IF(LEN(interestInLandLow)>0,interestInLandLow,IF(OR(LEN(interestInLandHigh)>0,LEN(interestInLandLow)>0),0,\"\"))","v":""},{"$f":"IF(LEN(interestInLandHigh)>0,interestInLandHigh, IF(OR(LEN(interestInLandHigh)>0,LEN(interestInLandLow)>0),0,\"\"))","v":""},{"$f":"IF(AND(OR(LEN(D10)=0, LEN(E10)=0),dividendTobePaid = \"Yes\"),TRUE, FALSE)","v":false}]
["ASSET","Sundry Debtors",null,{"$f":"IF(LEN(sundryDebtorsLow)>0, sundryDebtorsLow,IF(OR(LEN(sundryDebtorsHigh)>0,LEN(sundryDebtorsLow)>0),0,\"\"))","v":""},{"$f":"IF(LEN(sundryDebtorsHigh)>0, sundryDebtorsHigh, IF(OR(LEN(sundryDebtorsHigh)>0,LEN(sundryDebtorsLow)>0),0,\"\"))","v":""},false]
["ASSET","Stock on Hand",null,{"$f":"IF(LEN(stockOnHandLow)>0, stockOnHandLow, IF(OR(LEN(stockOnHandHigh)>0,LEN(stockOnHandLow)>0),0,\"\"))","v":""},{"$f":"IF(LEN(stockOnHandHigh)>0, stockOnHandHigh,  IF(OR(LEN(stockOnHandHigh)>0,LEN(stockOnHandLow)>0),0,\"\"))","v":""},false]
["ASSET","Work in progress",null,{"$f":"IF(LEN(workInProgressLow)>0, workInProgressLow,  IF(OR(LEN(workInProgressLow)>0,LEN(workInProgressHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(workInProgressHigh)>0, workInProgressHigh,IF(OR(LEN(workInProgressLow)>0,LEN(workInProgressHigh)>0),0,\"\"))","v":""},false]
["ASSET","Plant and Equipment",null,{"$f":"IF(LEN(plantAndEquipmentLow)>0, plantAndEquipmentLow, IF(OR(LEN(plantAndEquipmentLow)>0,LEN(plantAndEquipmentHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(plantAndEquipmentHigh)>0, plantAndEquipmentHigh, IF(OR(LEN(plantAndEquipmentLow)>0,LEN(plantAndEquipmentHigh)>0),0,\"\"))","v":""},false]
["ASSET","Potential Legal Recoveries",null,{"$f":"IF(LEN(potentialLegalRecoveriesLow)>0, potentialLegalRecoveriesLow, IF(OR(LEN(potentialLegalRecoveriesLow)>0,LEN(potentialLegalRecoveriesHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(potentialLegalRecoveriesHigh) >0, potentialLegalRecoveriesHigh, IF(OR(LEN(potentialLegalRecoveriesLow)>0,LEN(potentialLegalRecoveriesHigh)>0),0,\"\"))","v":""},false]
["ASSET","Contingent Assets",null,{"$f":"IF(LEN(contingentAssetsLow)>0, contingentAssetsLow, IF(OR(LEN(contingentAssetsHigh)>0,LEN(contingentAssetsLow)>0),0,\"\"))","v":""},{"$f":"IF(LEN(contingentAssetsHigh)>0, contingentAssetsHigh, IF(OR(LEN(contingentAssetsHigh)>0,LEN(contingentAssetsLow)>0),0,\"\"))","v":""},false]
["ASSET","Other Recoveries",null,{"$f":"IF(LEN(otherRecoveriesLow)>0, otherRecoveriesLow,  IF(OR(LEN(otherRecoveriesLow)>0,LEN(otherRecoveriesHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(otherRecoveriesHigh)>0, otherRecoveriesHigh, IF(OR(LEN(otherRecoveriesLow)>0,LEN(otherRecoveriesHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future Payments to Insolvency Practitioners Remuneration",null,{"$f":"IF(LEN(estFutureRemunerationLow)>0, estFutureRemunerationLow,  IF(OR(LEN(estFutureRemunerationLow)>0,LEN(estFutureRemunerationHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFutureRemunerationHigh)>0, estFutureRemunerationHigh, IF(OR(LEN(estFutureRemunerationLow)>0,LEN(estFutureRemunerationHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future (Practitioner) Other Payments or Costs",null,{"$f":"IF(LEN(estFutureOtherPaymentsLow)>0, estFutureOtherPaymentsLow,  IF(OR(LEN(estFutureOtherPaymentsLow)>0,LEN(estFutureOtherPaymentsHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFutureOtherPaymentsHigh)>0, estFutureOtherPaymentsHigh,  IF(OR(LEN(estFutureOtherPaymentsLow)>0,LEN(estFutureOtherPaymentsHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future Payments to Priority Creditor",null,{"$f":"IF(LEN(estFuturePriorityCreditorsLow)>0, estFuturePriorityCreditorsLow,  IF(OR(LEN(estFuturePriorityCreditorsLow)>0,LEN(estFuturePriorityCreditorsHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFuturePriorityCreditorsHigh)>0, estFuturePriorityCreditorsHigh, IF(OR(LEN(estFuturePriorityCreditorsLow)>0,LEN(estFuturePriorityCreditorsHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future Payments to Secured Creditor",null,{"$f":"IF(LEN(estFutureSecuredCreditorsLow)>0, estFutureSecuredCreditorsLow, IF(OR(LEN(estFutureSecuredCreditorsLow)>0,LEN(estFutureSecuredCreditorsHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFutureSecuredCreditorsHigh)>0, estFutureSecuredCreditorsHigh,  IF(OR(LEN(estFutureSecuredCreditorsLow)>0,LEN(estFutureSecuredCreditorsHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future Payments to Unsecured Creditor",null,{"$f":"IF(LEN(estFutureUnsecuredCreditorsLow)>0, estFutureUnsecuredCreditorsLow,  IF(OR(LEN(estFutureUnsecuredCreditorsLow)>0,LEN(estFutureUnsecuredCreditorsHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFutureUnsecuredCreditorsHigh)>0, estFutureUnsecuredCreditorsHigh,  IF(OR(LEN(estFutureUnsecuredCreditorsLow)>0,LEN(estFutureUnsecuredCreditorsHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Estimated Future Payments to Deferred Creditor",null,{"$f":"IF(LEN(estFutureDeferredCreditorsLow)>0, estFutureDeferredCreditorsLow, IF(OR(LEN(estFutureDeferredCreditorsLow)>0,LEN(estFutureDeferredCreditorsHigh)>0),0,\"\"))","v":""},{"$f":"IF(LEN(estFutureDeferredCreditorsHigh) >0, estFutureDeferredCreditorsHigh, IF(OR(LEN(estFutureDeferredCreditorsLow)>0,LEN(estFutureDeferredCreditorsHigh)>0),0,\"\"))","v":""},false]
["LIABILITY","Balance for contributories",null,{"$f":"IF(LEN(estBalanceForContributoriesLow)>0, estBalanceForContributoriesLow, \"\")","v":""},{"$f":"IF(LEN(estBalanceForContributoriesHigh)>0, estBalanceForContributoriesHigh, \"\")","v":""},false]

{"sheet":"receiptsAndPayments.summary","index":19,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["transactionType","transactionCategory","dateOfTransaction","transactionAmountIncludingTax","rateOfDividend"]
["RECEIPT","Summary for this period",null,{"$f":"'Tab 6'!C7","v":0}]
["RECEIPT","Summary for all previous periods",null,{"$f":"'Tab 6'!C6","v":0}]
["PAYMENT","Summary for this period",null,{"$f":"'Tab 6'!C11","v":0}]
["PAYMENT","Summary for all previous periods",null,{"$f":"'Tab 6'!C10","v":0}]
["PAYMENT","Remuneration during report period",null,{"$f":"'Tab 5'!C16","v":0}]
["PAYMENT","Remuneration since appointment to end date of report",null,{"$f":"'Tab 5'!C17","v":0}]
["PAYMENT","Expenses during report period",null,{"$f":"'Tab 5'!C18","v":0}]
["PAYMENT","Expenses since appointment to end date of report",null,{"$f":"'Tab 5'!C19","v":0}]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]
["",""]

{"sheet":"receiptsAndPayments.receipts","index":20,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["transactionCategory","dateOfTransaction","thirdPartyName","transactionAmountIncludingTax","transactionDetails"]
[null,"s"]

{"sheet":"receiptsAndPayments.payments","index":21,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["transactionCategory","dateOfTransaction","thirdPartyName","transactionAmountIncludingTax","transactionDetails"]
["Appointee - disbursements","112","22","112","asdf"]

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

{"sheet":"CONFIG.receipts","index":23,"n_rows":13,"n_cols":1,"rows_kept":13,"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"]

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

{"sheet":"Data 1","index":25,"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":26,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blank worksheet provided for data import."]