{"text_format":"1","workbook":"xlsx","n_sheets":36,"sheets":["Company Details","exadDetails","1 Appointment","lodgementDetails","appointment.appointees","2 Assets","detailsOfAssets","3 Activities","reportAsToAffairs","4 Liabilities","creditor","5 Remuneration","remunerations","6 Summary","receiptsAndPayments","7 Fair Entitlement","fairEntitlement","8 Dividends","8a","dividends","Receipts","receiptsAndPayments.receipts","Payments","Lookups","receiptsAndPayments.payments","Summary Receipts","summaryReceipts","Summary Payments","summaryPayments","Data 1","Data 2","risksOrTasks","CONFIG.receipts","CONFIG.payments","additionalInfo","statementOfFinancialPosition"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":72,"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 5603"]
[]
[null,"End of 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":"exadDetails","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["value","name","poolName","commenceDate","appointmentType"]
[{"$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":""}]

{"sheet":"1 Appointment","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,3,9,5],[12,3,12,4],[3,1,3,2],[17,7,17,10],[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 end of administration 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"]

{"sheet":"lodgementDetails","index":3,"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":"appointment.appointees","index":4,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["appointmentStartDate","liquidatorNo","givenNames","familyName","adressLine","country","iso3166CountryCode"]

{"sheet":"2 Assets","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"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,"What is the gross amount (excl GST) of assets realised?"]
[]
[null,"Did you assign any claims to a third party?"]
[]
[null,"If you answered 'Yes' above, what consideration did you receive for assigning the claim?"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"detailsOfAssets","index":6,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["grossAssets","cashAtBank","thirdPartyClaim","consideration"]
[{"$f":"IF(grossAssets=0,0,grossAssets)","v":0},{"$f":"IF(cashAtBank=\"\",0,cashAtBank)","v":0},{"$f":"IF(thirdPartyClaim=\"\",\"\",IF(thirdPartyClaim=\"Yes\",TRUE,FALSE))","v":""},{"$f":"IF(consideration=\"\",\"\",consideration)","v":""}]

{"sheet":"3 Activities","index":7,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,2],[8,1,9,1]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"3. Report on Company Activities and Property"]
[]
[]
[null,"Did you receive a report on company activities and property from the company's director?"]
[]
[null,"If you answered 'No' above, did you seek assistance from ASIC to obtain compliance under the liquidator assistance program?"]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"reportAsToAffairs","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["rataReceived","asicAssistance"]
[{"$f":"IF(rataReceived=\"\",\"\",IF(rataReceived=\"Yes\",TRUE,FALSE))","v":""},{"$f":"IF(asicAssistance=\"\",\"\",IF(asicAssistance=\"Yes\",TRUE,FALSE))","v":""}]

{"sheet":"4 Liabilities","index":9,"n_rows":23,"n_cols":9,"rows_kept":23,"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 payments"]
[]
[null,"Secured"]
[]
[null,"Unsecured"]
[]
[null,"Deferred"]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"creditor","index":10,"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 Remuneration","index":11,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,3],[33,1,35,1]]}
[null,"Home",null,null,null,null,null,null,null,"Previous Tab"]
[]
[null,"5. Details of Remuneration"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[null,"Type of appointment",null,"Amount of remuneration 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,"Scheme Administrator"]
[]
[null,"Managing Controller (other than receiver or manager)"]
[]
[null,"Controller (other than receiver, receiver & manager of managing controller"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Next Tab"]

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

{"sheet":"6 Summary","index":13,"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,"6. 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 for this return"]
[]
[null,"Total amounts you paid during the period for 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":"receiptsAndPayments","index":14,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["prevReceipt","prevPayments","currReceipts","currPayments"]
[{"$f":"IF('6 Summary'!D9=\"\",0,'6 Summary'!D9)","v":0},{"$f":"IF('6 Summary'!D17=\"\",0,'6 Summary'!D17)","v":0},{"$f":"IF('6 Summary'!D11=\"\",\"\",'6 Summary'!D11)","v":0},{"$f":"IF('6 Summary'!D19=\"\",\"\",'6 Summary'!D19)","v":0}]

{"sheet":"7 Fair Entitlement","index":15,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,8]]}
[null,"Home",null,null,null,null,null,null,"Previous Tab"]
[]
[]
[null,"7. Payments under Fair entitlement guarantee scheme"]
[]
[null,"What is the total amount advised by the Department of Employment as paid to employees under the Fair entitlement\nguarantee scheme or GEERS since the start of the external administration?"]
[]
[null,"Amounts to be in whole Australian dollars unless otherwise specified"]
[]
[null,"Wages",0]
[]
[null,"Leave of absence",0]
[]
[null,"Retrenchment",0]
[]
[]
[null,null,null,null,null,null,null,null,"Next Tab"]

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

{"sheet":"8 Dividends","index":17,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,5,25,5],[24,1,26,1]]}
[null,"Home",null,null,null,null,null,"Previous Tab"]
[]
[null,"8. Details of Dividends"]
[]
[null,"Actual dividends paid since your appointment and to the date of this account."]
[]
[null,"Category",null,"Rate of dividend paid",null,"Total Paid"]
[]
[null,"Priority - Wages & Super incl SGC"]
[]
[null,"Priority - Leave of absence"]
[]
[null,"Priority - Retrenchment payments"]
[]
[null,"Secured"]
[]
[null,"Unsecured"]
[]
[null,"Deferred"]
[]
[null,"Contributories"]
[]
[]
[null,null,null,null,null,null,null,"Next Tab"]

{"sheet":"8a","index":18,"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":19,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["category","rate","totalPaid"]
["Priority - Wages & Super incl SGC",{"$f":"IF('8 Dividends'!D9=\"\",\"\",'8 Dividends'!D9)","v":""},{"$f":"IF('8 Dividends'!F9=\"\",\"\",'8 Dividends'!F9)","v":""}]
["Priority - Leave of absence",{"$f":"IF('8 Dividends'!D11=\"\",\"\",'8 Dividends'!D11)","v":""},{"$f":"IF('8 Dividends'!F11=\"\",\"\",'8 Dividends'!F11)","v":""}]
["Priority - Retrenchment",{"$f":"IF('8 Dividends'!D13=\"\",\"\",'8 Dividends'!D13)","v":""},{"$f":"IF('8 Dividends'!F13=\"\",\"\",'8 Dividends'!F13)","v":""}]
["Secured",{"$f":"IF('8 Dividends'!D15=\"\",\"\",'8 Dividends'!D15)","v":""},{"$f":"IF('8 Dividends'!F15=\"\",\"\",'8 Dividends'!F15)","v":""}]
["Unsecured",{"$f":"IF('8 Dividends'!D17=\"\",\"\",'8 Dividends'!D17)","v":""},{"$f":"IF('8 Dividends'!F17=\"\",\"\",'8 Dividends'!F17)","v":""}]
["Deferred",{"$f":"IF('8 Dividends'!D19=\"\",\"\",'8 Dividends'!D19)","v":""},{"$f":"IF('8 Dividends'!F19=\"\",\"\",'8 Dividends'!F19)","v":""}]
["Contributories",{"$f":"IF('8 Dividends'!D21=\"\",\"\",'8 Dividends'!D21)","v":""},{"$f":"IF('8 Dividends'!F21=\"\",\"\",'8 Dividends'!F21)","v":""}]

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

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

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

{"sheet":"Lookups","index":23,"n_rows":124,"n_cols":5,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[null,null,"Appointment Type Code:"]
["Filename",{"$f":"CONCATENATE(\"Form5603_\", IF(LEN(acn)>0,acn,IF(LEN('Company Details'!C7)>0,'Company Details'!C7,IF(LEN(poolName)>0,poolName,\"5603\"))), \".xlsx\")","v":"Form5603_5603.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"]
[]
["Transaction Type","Group","Name","Transaction Category Description"]
["RECEIPT","Asset Realisation","Sale of business","Sale of business"]
["RECEIPT","Asset Realisation","Land and buildings","Land and buildings"]
["RECEIPT","Asset Realisation","Plant and Equipment","Plant and Equipment"]
["RECEIPT","Asset Realisation","Cash on Hand/Bank","Cash on Hand/Bank"]
["RECEIPT","Asset Realisation","Work in progress","Work in progress"]
["RECEIPT","Asset Realisation","Inventory","Inventory"]
["RECEIPT","Asset Realisation","Sundry Debtors","Sundry Debtors"]
["RECEIPT","Asset Realisation","Other (Pre appointment Assets)","Other (Pre appointment Assets)"]
["RECEIPT","Asset Realisation","Legal Recoveries","Legal Recoveries"]
["RECEIPT","Asset Realisation","Antecedent Transactions","Antecedent Transactions"]
["RECEIPT","Trading Receipts","Trading Receipts","Trading Receipts"]
["RECEIPT","Other Receipts","Other Receipts","Other Receipts"]
["RECEIPT","Other Receipts","GST Received","GST Received"]
["RECEIPT","Other Receipts","FEGS Received","FEGS Received"]
["PAYMENT","Cost of Realisation","Appointee - remuneration","Appointee - remuneration"]
["PAYMENT","Cost of Realisation","Appointee - disbursements","Appointee - disbursements"]
["PAYMENT","Cost of Realisation","Legal Fees","Legal Fees"]
["PAYMENT","Cost of Realisation","Property Realisation and Preservation Costs","Property Realisation and Preservation Costs"]
["PAYMENT","Cost of Realisation","Other Cost of Realisation","Other Cost of Realisation"]
["PAYMENT","Cost of Realisation","GST Paid","GST Paid"]
["PAYMENT","Trading Expense","Payroll Expenses","Payroll Expenses"]
["PAYMENT","Trading Expense","Purchases","Purchases"]
["PAYMENT","Trading Expense","Other Trading Expense","Other Trading Expense"]
["PAYMENT","Distribution/Dividends","Priority Creditors - (Wages & Super incl SGC)","Priority Creditors - (Wages & Super incl SGC)"]
["PAYMENT","Distribution/Dividends","Priority Creditors - (Leave of absence)","Priority Creditors - (Leave of absence)"]
["PAYMENT","Distribution/Dividends","Priority Creditors - (Retrenchment)","Priority Creditors - (Retrenchment)"]
["PAYMENT","Distribution/Dividends","Unsecured Creditors","Unsecured Creditors"]
["PAYMENT","Distribution/Dividends","Secured Creditors","Secured Creditors"]
["PAYMENT","Distribution/Dividends","Deferred Creditors","Deferred Creditors"]
["PAYMENT","Distribution/Dividends","Contributories Creditors","Contributories Creditors"]
["PAYMENT","Distribution/Dividends","FEGS Paid","FEGS Paid"]
[]
["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":"receiptsAndPayments.payments","index":24,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["ledger name","category","date","payee","amt"]

{"sheet":"Summary Receipts","index":25,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,"Home",null,null,null,"Previous Tab"]
[]
[null,"Summary of total receipts received during the external administration"]
[null,null,"Total Receipts:",{"$f":"SUM(D7:D100166)","v":0}]
[]
[null,"General Ledger Name","Transaction Category","Amount (incl tax)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Next tab"]

{"sheet":"summaryReceipts","index":26,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["transactionType","transactionCategory","transactionAmountIncludingTax"]

{"sheet":"Summary Payments","index":27,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,"Home",null,null,null,"Previous Tab"]
[]
[null,"Summary of total payments made during the external administration"]
[null,"(tab at end of last row to extend table)","Total Payments:",{"$f":"SUM(D7:D100166)","v":0}]
[]
[null,"General Ledger Name","Transaction Category","Amount (incl tax)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Next tab"]

{"sheet":"summaryPayments","index":28,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["transactionType","transactionCategory","transactionAmountIncludingTax"]

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

{"sheet":"risksOrTasks","index":31,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["type","details"]

{"sheet":"CONFIG.receipts","index":32,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["transactionCategoryReceipts"]
["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"]
["FEGS Received"]
["Other Receipts"]

{"sheet":"CONFIG.payments","index":33,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["transactionCategoryPayments"]
["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":"additionalInfo","index":34,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["disposalOfAssets"]

{"sheet":"statementOfFinancialPosition","index":35,"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":{"$error":"#NAME?"}},null,null,{"$f":"IF(LEN(C2)>0,FALSE,TRUE)","v":{"$error":"#NAME?"}}]
["LIABILITY","Amount owing under instrument at date of this account",{"$f":"IF(securedCurrentDebt>0, securedCurrentDebt, \"\")","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(LEN(C3)>0,FALSE,TRUE)","v":{"$error":"#NAME?"}}]
["ASSET","Estimated value of property subject to the instrument at the date of this account",{"$f":"IF(securedCurrentValue>0, securedCurrentValue, \"\")","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["ASSET","Cash in Hand",{"$f":"IF(cashInHand=\"\", 0, cashInHand)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["ASSET","Cash at Bank - per bank statement",{"$f":"IF(creditAsPerBankStatement =\"\",0, creditAsPerBankStatement)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["LIABILITY","Cash at Bank - Unpresented Cheques",{"$f":"IF(unpresentedCheques=\"\", 0,unpresentedCheques)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["ASSET","Cash at Bank - Outstanding Deposits",{"$f":"IF(outstandingDeposits=\"\",0, outstandingDeposits)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["ASSET","Amounts invested and not converted to cash",{"$f":"IF(investmentsNotCash=\"\",0, investmentsNotCash)","v":{"$error":"#NAME?"}},null,null,{"$error":"#NAME?"}]
["ASSET","Interests in Land",null,{"$f":"IF(LEN(interestInLandLow)>0,interestInLandLow,IF(OR(LEN(interestInLandHigh)>0,LEN(interestInLandLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(interestInLandHigh)>0,interestInLandHigh, IF(OR(LEN(interestInLandHigh)>0,LEN(interestInLandLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(AND(OR(LEN(D10)=0, LEN(E10)=0),dividendTobePaid = \"Yes\"),TRUE, FALSE)","v":{"$error":"#NAME?"}}]
["ASSET","Sundry Debtors",null,{"$f":"IF(LEN(sundryDebtorsLow)>0, sundryDebtorsLow,IF(OR(LEN(sundryDebtorsHigh)>0,LEN(sundryDebtorsLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(sundryDebtorsHigh)>0, sundryDebtorsHigh, IF(OR(LEN(sundryDebtorsHigh)>0,LEN(sundryDebtorsLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Stock on Hand",null,{"$f":"IF(LEN(stockOnHandLow)>0, stockOnHandLow, IF(OR(LEN(stockOnHandHigh)>0,LEN(stockOnHandLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(stockOnHandHigh)>0, stockOnHandHigh,  IF(OR(LEN(stockOnHandHigh)>0,LEN(stockOnHandLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Work in progress",null,{"$f":"IF(LEN(workInProgressLow)>0, workInProgressLow,  IF(OR(LEN(workInProgressLow)>0,LEN(workInProgressHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(workInProgressHigh)>0, workInProgressHigh,IF(OR(LEN(workInProgressLow)>0,LEN(workInProgressHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Plant and Equipment",null,{"$f":"IF(LEN(plantAndEquipmentLow)>0, plantAndEquipmentLow, IF(OR(LEN(plantAndEquipmentLow)>0,LEN(plantAndEquipmentHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(plantAndEquipmentHigh)>0, plantAndEquipmentHigh, IF(OR(LEN(plantAndEquipmentLow)>0,LEN(plantAndEquipmentHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Potential Legal Recoveries",null,{"$f":"IF(LEN(potentialLegalRecoveriesLow)>0, potentialLegalRecoveriesLow, IF(OR(LEN(potentialLegalRecoveriesLow)>0,LEN(potentialLegalRecoveriesHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(potentialLegalRecoveriesHigh) >0, potentialLegalRecoveriesHigh, IF(OR(LEN(potentialLegalRecoveriesLow)>0,LEN(potentialLegalRecoveriesHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Contingent Assets",null,{"$f":"IF(LEN(contingentAssetsLow)>0, contingentAssetsLow, IF(OR(LEN(contingentAssetsHigh)>0,LEN(contingentAssetsLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(contingentAssetsHigh)>0, contingentAssetsHigh, IF(OR(LEN(contingentAssetsHigh)>0,LEN(contingentAssetsLow)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["ASSET","Other Recoveries",null,{"$f":"IF(LEN(otherRecoveriesLow)>0, otherRecoveriesLow,  IF(OR(LEN(otherRecoveriesLow)>0,LEN(otherRecoveriesHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(otherRecoveriesHigh)>0, otherRecoveriesHigh, IF(OR(LEN(otherRecoveriesLow)>0,LEN(otherRecoveriesHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["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":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFutureRemunerationHigh)>0, estFutureRemunerationHigh, IF(OR(LEN(estFutureRemunerationLow)>0,LEN(estFutureRemunerationHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["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":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFutureOtherPaymentsHigh)>0, estFutureOtherPaymentsHigh,  IF(OR(LEN(estFutureOtherPaymentsLow)>0,LEN(estFutureOtherPaymentsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["LIABILITY","Estimated Future Payments to Priority Creditor",null,{"$f":"IF(LEN(estFuturePriorityCreditorsLow)>0, estFuturePriorityCreditorsLow,  IF(OR(LEN(estFuturePriorityCreditorsLow)>0,LEN(estFuturePriorityCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFuturePriorityCreditorsHigh)>0, estFuturePriorityCreditorsHigh, IF(OR(LEN(estFuturePriorityCreditorsLow)>0,LEN(estFuturePriorityCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["LIABILITY","Estimated Future Payments to Secured Creditor",null,{"$f":"IF(LEN(estFutureSecuredCreditorsLow)>0, estFutureSecuredCreditorsLow, IF(OR(LEN(estFutureSecuredCreditorsLow)>0,LEN(estFutureSecuredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFutureSecuredCreditorsHigh)>0, estFutureSecuredCreditorsHigh,  IF(OR(LEN(estFutureSecuredCreditorsLow)>0,LEN(estFutureSecuredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["LIABILITY","Estimated Future Payments to Unsecured Creditor",null,{"$f":"IF(LEN(estFutureUnsecuredCreditorsLow)>0, estFutureUnsecuredCreditorsLow,  IF(OR(LEN(estFutureUnsecuredCreditorsLow)>0,LEN(estFutureUnsecuredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFutureUnsecuredCreditorsHigh)>0, estFutureUnsecuredCreditorsHigh,  IF(OR(LEN(estFutureUnsecuredCreditorsLow)>0,LEN(estFutureUnsecuredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["LIABILITY","Estimated Future Payments to Deferred Creditor",null,{"$f":"IF(LEN(estFutureDeferredCreditorsLow)>0, estFutureDeferredCreditorsLow, IF(OR(LEN(estFutureDeferredCreditorsLow)>0,LEN(estFutureDeferredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(estFutureDeferredCreditorsHigh) >0, estFutureDeferredCreditorsHigh, IF(OR(LEN(estFutureDeferredCreditorsLow)>0,LEN(estFutureDeferredCreditorsHigh)>0),0,\"\"))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
["LIABILITY","Balance for contributories",null,{"$f":"IF(LEN(estBalanceForContributoriesLow)>0, estBalanceForContributoriesLow, \"\")","v":{"$error":"#NAME?"}},{"$f":"IF(LEN(estBalanceForContributoriesHigh)>0, estBalanceForContributoriesHigh, \"\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]