{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Disclaimer","Title","Inputs","Calcs_Days","Calcs_Alt"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":52,"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":"Disclaimer","index":0,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Legal disclaimer"]
[null,"Please fully read this disclaimer before using this model"]
[]
[]
[]
[null,"\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"www.lentransolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 8, Suite 3, 234 George Street, NSW 2000"]
[null,null,null,null,"contact@lentransolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABN: 66 615 474 523"]

{"sheet":"Title","index":1,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Model_Name","v":"Working Capital Adjustments"}]
[null,null,"LMS Tutorial"]
[null,null,"Sydney, January 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"www.lentransolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 8, Suite 3, 234 George Street, NSW 2000"]
[null,null,null,null,"contact@lentransolutions.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABN: 66 615 474 523"]

{"sheet":"Inputs","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,"Assumptions"]
[null,null,{"$f":"\"Tutorial: \"&Model_Name","v":"Tutorial: Working Capital Adjustments"}]
[]
[]
[]
[null,null,"Tutorial inputs"]
[null,null,"Timing"]
[null,null,"Model start","Date","2016-12-31"]
[null,null,"Operations start","Date",{"$f":"E8+1","v":"2017-01-01"}]
[null,null,"Operations duration","Year(s)",3]
[null,null,"Operations end","Date",{"$f":"EOMONTH(E9,E10*Mths_Yr-1)","v":"2019-12-31"}]
[]
[null,null,"'Days' method"]
[null,null,"Debtors"]
[null,null,"Debtor days","Days",10]
[]
[null,null,"Alternative method"]
[null,null,"Debtors",null,"Days","Months"]
[null,null,"Debtor period (until revenue recognised)","Days",42,{"$f":"E19/Days_Mth","v":1.4}]
[]
[null,null,"Technical inputs"]
[null,null,"General"]
[null,null,"Tutorial name","Name","Working Capital Adjustments"]
[null,null,"Months in year","Months",12]
[null,null,"Months in quarter","Months",3]
[null,null,"Days in month (constant)","Months",30]

{"sheet":"Calcs_Days","index":3,"n_rows":21,"n_cols":68,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculations: Days method"]
[null,null,{"$f":"\"Tutorial: \"&Model_Name","v":"Tutorial: Working Capital Adjustments"}]
[null,null,"Period start",null,null,null,null,null,{"$f":"H4+1","v":"2017-01-01"},{"$f":"I4+1","v":"2017-02-01"},{"$f":"J4+1","v":"2017-03-01"},{"$f":"K4+1","v":"2017-04-01"},"2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
[null,null,"Period end","Start","End",null,null,{"$f":"Inputs!E8","v":"2016-12-31"},{"$f":"EOMONTH(I3,0)","v":"2017-01-31"},{"$f":"EOMONTH(J3,0)","v":"2017-02-28"},{"$f":"EOMONTH(K3,0)","v":"2017-03-31"},{"$f":"EOMONTH(L3,0)","v":"2017-04-30"},"2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30","2017-10-31","2017-11-30","2017-12-31","2018-01-31","2018-02-28","2018-03-31","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31"]
[null,null,"Operations",{"$f":"Inputs!E9","v":"2017-01-01"},{"$f":"Inputs!E11","v":"2019-12-31"},null,null,{"$f":"SUM(I5:BP5)","v":36},{"$f":"IF(AND(I$3>=$D5,I$4<=$E5),1,0)","v":1},{"$f":"IF(AND(J$3>=$D5,J$4<=$E5),1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Counter"]
[null,null,"Days in period","Days",null,null,null,null,{"$f":"I4-I3+1","v":31},{"$f":"J4-J3+1","v":28},31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,29,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31]
[]
[null,null,"Time-series inputs"]
[null,null,"Revenue (random values)","AUD '000",null,null,null,null,1033.3917656922476,1202.4034882671697,8104.8824751387783,532.96794265413223,1707.3214021012041,9558.8881160781293,1596.8979171808285,5762.2916059232684,8429.3494100380794,3194.5835318847239,3985.9594473468806,7214.3809582720442,1579.0888709048556,7923.885468837967,4864.3035376676953,9143.9444219544348,4337.3898559154159,5876.3952870971725,5357.3003826027862,1669.4426321207311,1454.4526175851281,1845.2165994470304,7105.7826760059761,590.94001481344799,4699.4978804941875,9063.1596119087517,6720.1013212898633,9551.8046272309421,3766.3561670763847,1624.2550157286462,7419.6742689839821,6688.2756382135776,3547.3366719976175,8143.0490146696457,6869.0919341416911,8702.426047563531,6979.4416112937961,2766.7004664815686,7594.8913553688317,2267.3564994407348,2892.0500611808666,9949.8216224570951,2609.3834655292058,7848.9288154917394,8539.9364360408345,6047.8397695461417,5400.1637286739742,6612.0704982245325,6404.3822612669874,4959.0878173552501,4224.0502918252769,4380.4184768861369,3521.4302010495912,6687.5595573631608,6038.1595750607539,5051.2199516084429,6874.2763441569041,6914.8953446866399,9691.3387889124915,650.29261162994794]
[null,null,"Revenue (utilised)","AUD '000",null,null,null,null,{"$f":"I5*I11","v":1033.3917656922476},{"$f":"J5*J11","v":1202.4034882671697},8104.8824751387783,532.96794265413223,1707.3214021012041,9558.8881160781293,1596.8979171808285,5762.2916059232684,8429.3494100380794,3194.5835318847239,3985.9594473468806,7214.3809582720442,1579.0888709048556,7923.885468837967,4864.3035376676953,9143.9444219544348,4337.3898559154159,5876.3952870971725,5357.3003826027862,1669.4426321207311,1454.4526175851281,1845.2165994470304,7105.7826760059761,590.94001481344799,4699.4978804941875,9063.1596119087517,6720.1013212898633,9551.8046272309421,3766.3561670763847,1624.2550157286462,7419.6742689839821,6688.2756382135776,3547.3366719976175,8143.0490146696457,6869.0919341416911,8702.426047563531,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Trade debtors"]
[null,null,"Account"]
[null,null,"Balance b/f","AUD '000",null,null,null,null,{"$f":"H19*I5","v":0},{"$f":"I19*J5","v":333.35218248137028},429.42981723827506,2614.4782177867028,177.65598088471097,550.7488393874853,3186.2960386927089,515.12836038091245,1858.8037438462161,2809.7831366793598,1030.5108167370072,1328.653149115627,2327.2196639587255,509.38350674350204,2829.9590960135583,1569.1301734411918,3047.9814739848116,1399.1580180372312,1958.7984290323911,1728.1614137428342,538.52988132926839,484.81753919504285,595.23116111194531,2368.594225335326,190.62581123014479,1515.9670582239319,3236.8427185388391,2167.7746197709239,3183.9348757436474,1214.9536022827051,541.41833857621532,2393.4433125754786,2157.5082703914768,1182.4455573325395,2626.7900047321455,2289.6973113805652,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Revenue","AUD '000","Days",null,null,{"$f":"SUM(I17:BP17)","v":180866.48862482895},{"$f":"I12","v":1033.3917656922476},{"$f":"J12","v":1202.4034882671697},8104.8824751387783,532.96794265413223,1707.3214021012041,9558.8881160781293,1596.8979171808285,5762.2916059232684,8429.3494100380794,3194.5835318847239,3985.9594473468806,7214.3809582720442,1579.0888709048556,7923.885468837967,4864.3035376676953,9143.9444219544348,4337.3898559154159,5876.3952870971725,5357.3003826027862,1669.4426321207311,1454.4526175851281,1845.2165994470304,7105.7826760059761,590.94001481344799,4699.4978804941875,9063.1596119087517,6720.1013212898633,9551.8046272309421,3766.3561670763847,1624.2550157286462,7419.6742689839821,6688.2756382135776,3547.3366719976175,8143.0490146696457,6869.0919341416911,8702.426047563531,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Received","AUD '000",{"$f":"Inputs!E15","v":10},null,null,{"$f":"SUM(I18:BP18)","v":-178059.25441593744},{"$f":"-((I8-$E18)/I8*I17+I16)","v":-700.03958321087737},{"$f":"-((J8-$E18)/J8*J17+J16)","v":-1106.325853510265},-5919.8340745903506,-2969.7901795561243,-1334.2285435984297,-6923.3409167729051,-4268.0655954926251,-4418.6162224579648,-7478.3700172049357,-4973.8558518270765,-3687.8171149682607,-6215.8144434289461,-3396.9250281200793,-5603.3098795679098,-6125.1324602400618,-7665.093121410815,-5986.2133118629963,-5316.7548761020125,-5587.9373978923431,-2859.0741645342969,-1508.1649597193536,-1734.8029775301279,-5332.4196117825959,-2768.9084289186294,-3374.1566335004004,-7342.2839515938449,-7789.1694200577786,-8535.6443712582186,-5735.337440537327,-2297.7902794351357,-5567.6492949847188,-6924.2106803975794,-4522.3993850565548,-6698.7045672700406,-7206.1846274932723,-8184.8891500526342,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Balance c/f","AUD '000",null,null,null,null,{"$f":"SUM(I16:I18)","v":333.35218248137028},{"$f":"SUM(J16:J18)","v":429.42981723827506},2614.4782177867028,177.65598088471097,550.7488393874853,3186.2960386927089,515.12836038091245,1858.8037438462161,2809.7831366793598,1030.5108167370072,1328.653149115627,2327.2196639587255,509.38350674350204,2829.9590960135583,1569.1301734411918,3047.9814739848116,1399.1580180372312,1958.7984290323911,1728.1614137428342,538.52988132926839,484.81753919504285,595.23116111194531,2368.594225335326,190.62581123014479,1515.9670582239319,3236.8427185388391,2167.7746197709239,3183.9348757436474,1214.9536022827051,541.41833857621532,2393.4433125754786,2157.5082703914768,1182.4455573325395,2626.7900047321455,2289.6973113805652,2807.234208891462,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Working captial adjustment for cashflow","AUD '000",null,null,null,{"$f":"SUM(I21:BP21)","v":-2807.234208891462},{"$f":"I16-I19","v":-333.35218248137028},{"$f":"J16-J19","v":-96.077634756904786},-2185.0484005484277,2436.8222369019918,-373.09285850277433,-2635.5471993052233,2671.1676783117964,-1343.6753834653036,-950.97939283314372,1779.2723199423526,-298.14233237861981,-998.5665148430985,1817.8361572152235,-2320.5755892700563,1260.8289225723665,-1478.8513005436198,1648.8234559475804,-559.64041099515998,230.63701528955698,1189.6315324135658,53.712342134225537,-110.41362191690246,-1773.3630642233807,2177.9684141051812,-1325.3412469937871,-1720.8756603149072,1069.0680987679152,-1016.1602559727235,1968.9812734609422,673.53526370648979,-1852.0249739992632,235.93504218400176,975.06271305893733,-1444.344447399606,337.09269335158024,-517.53689751089678,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Calcs_Alt","index":4,"n_rows":26,"n_cols":68,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculations: Alternative method"]
[null,null,{"$f":"\"Tutorial: \"&Model_Name","v":"Tutorial: Working Capital Adjustments"}]
[null,null,"Period start",null,null,null,null,null,{"$f":"H4+1","v":"2017-01-01"},{"$f":"I4+1","v":"2017-02-01"},{"$f":"J4+1","v":"2017-03-01"},{"$f":"K4+1","v":"2017-04-01"},"2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
[null,null,"Period end","Start","End",null,null,{"$f":"Inputs!E8","v":"2016-12-31"},{"$f":"EOMONTH(I3,0)","v":"2017-01-31"},{"$f":"EOMONTH(J3,0)","v":"2017-02-28"},{"$f":"EOMONTH(K3,0)","v":"2017-03-31"},{"$f":"EOMONTH(L3,0)","v":"2017-04-30"},"2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30","2017-10-31","2017-11-30","2017-12-31","2018-01-31","2018-02-28","2018-03-31","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31"]
[null,null,"Operations",{"$f":"Inputs!E9","v":"2017-01-01"},{"$f":"Inputs!E11","v":"2019-12-31"},null,null,{"$f":"SUM(I5:BP5)","v":36},{"$f":"IF(AND(I$3>=$D5,I$4<=$E5),1,0)","v":1},{"$f":"IF(AND(J$3>=$D5,J$4<=$E5),1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Time-series inputs"]
[null,null,"Revenue (utilised)","AUD '000",null,null,null,1000,{"$f":"Calcs_Days!I12","v":1033.3917656922476},{"$f":"Calcs_Days!J12","v":1202.4034882671697},{"$f":"Calcs_Days!K12","v":8104.8824751387783},{"$f":"Calcs_Days!L12","v":532.96794265413223},{"$f":"Calcs_Days!M12","v":1707.3214021012041},{"$f":"Calcs_Days!N12","v":9558.8881160781293},{"$f":"Calcs_Days!O12","v":1596.8979171808285},{"$f":"Calcs_Days!P12","v":5762.2916059232684},{"$f":"Calcs_Days!Q12","v":8429.3494100380794},{"$f":"Calcs_Days!R12","v":3194.5835318847239},{"$f":"Calcs_Days!S12","v":3985.9594473468806},{"$f":"Calcs_Days!T12","v":7214.3809582720442},{"$f":"Calcs_Days!U12","v":1579.0888709048556},{"$f":"Calcs_Days!V12","v":7923.885468837967},{"$f":"Calcs_Days!W12","v":4864.3035376676953},{"$f":"Calcs_Days!X12","v":9143.9444219544348},{"$f":"Calcs_Days!Y12","v":4337.3898559154159},{"$f":"Calcs_Days!Z12","v":5876.3952870971725},{"$f":"Calcs_Days!AA12","v":5357.3003826027862},{"$f":"Calcs_Days!AB12","v":1669.4426321207311},{"$f":"Calcs_Days!AC12","v":1454.4526175851281},{"$f":"Calcs_Days!AD12","v":1845.2165994470304},{"$f":"Calcs_Days!AE12","v":7105.7826760059761},{"$f":"Calcs_Days!AF12","v":590.94001481344799},{"$f":"Calcs_Days!AG12","v":4699.4978804941875},{"$f":"Calcs_Days!AH12","v":9063.1596119087517},{"$f":"Calcs_Days!AI12","v":6720.1013212898633},{"$f":"Calcs_Days!AJ12","v":9551.8046272309421},{"$f":"Calcs_Days!AK12","v":3766.3561670763847},{"$f":"Calcs_Days!AL12","v":1624.2550157286462},{"$f":"Calcs_Days!AM12","v":7419.6742689839821},{"$f":"Calcs_Days!AN12","v":6688.2756382135776},{"$f":"Calcs_Days!AO12","v":3547.3366719976175},{"$f":"Calcs_Days!AP12","v":8143.0490146696457},{"$f":"Calcs_Days!AQ12","v":6869.0919341416911},{"$f":"Calcs_Days!AR12","v":8702.426047563531},{"$f":"Calcs_Days!AS12","v":0},{"$f":"Calcs_Days!AT12","v":0},{"$f":"Calcs_Days!AU12","v":0},{"$f":"Calcs_Days!AV12","v":0},{"$f":"Calcs_Days!AW12","v":0},{"$f":"Calcs_Days!AX12","v":0},{"$f":"Calcs_Days!AY12","v":0},{"$f":"Calcs_Days!AZ12","v":0},{"$f":"Calcs_Days!BA12","v":0},{"$f":"Calcs_Days!BB12","v":0},{"$f":"Calcs_Days!BC12","v":0},{"$f":"Calcs_Days!BD12","v":0},{"$f":"Calcs_Days!BE12","v":0},{"$f":"Calcs_Days!BF12","v":0},{"$f":"Calcs_Days!BG12","v":0},{"$f":"Calcs_Days!BH12","v":0},{"$f":"Calcs_Days!BI12","v":0},{"$f":"Calcs_Days!BJ12","v":0},{"$f":"Calcs_Days!BK12","v":0},{"$f":"Calcs_Days!BL12","v":0},{"$f":"Calcs_Days!BM12","v":0},{"$f":"Calcs_Days!BN12","v":0},{"$f":"Calcs_Days!BO12","v":0},{"$f":"Calcs_Days!BP12","v":0}]
[]
[null,null,"Trade debtors"]
[null,null,"Controls"]
[null,null,"Date revenue first recognised","Months",{"$f":"Inputs!F19","v":1.4},null,null,null,{"$f":"EOMONTH(I$4,-$E12)","v":"2016-12-31"},{"$f":"EOMONTH(J$4,-$E12)","v":"2017-01-31"},"2017-02-28","2017-03-31","2017-04-30","2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30","2017-10-31","2017-11-30","2017-12-31","2018-01-31","2018-02-28","2018-03-31","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30"]
[null,null,"Outstanding balances from previous periods","Months",{"$f":"E12+1","v":2.4},null,null,null,{"$f":"EOMONTH(I$4,-$E13)","v":"2016-11-30"},"2016-12-31","2017-01-31","2017-02-28","2017-03-31","2017-04-30","2017-05-31","2017-06-30","2017-07-31","2017-08-31","2017-09-30","2017-10-31","2017-11-30","2017-12-31","2018-01-31","2018-02-28","2018-03-31","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31"]
[]
[null,null,"Debtor receipt"]
[null,null,"Revenue","AUD '000",{"$f":"1-(E12-ROUNDDOWN(E12,0))","v":0.60000000000000009},null,null,{"$f":"SUM(I16:BP16)","v":109119.8931748974},{"$f":"IFERROR(LOOKUP(I12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":600.00000000000011},{"$f":"IFERROR(LOOKUP(J12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":620.03505941534866},{"$f":"IFERROR(LOOKUP(K12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":721.44209296030192},{"$f":"IFERROR(LOOKUP(L12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4862.9294850832675},{"$f":"IFERROR(LOOKUP(M12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":319.78076559247938},{"$f":"IFERROR(LOOKUP(N12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":1024.3928412607227},{"$f":"IFERROR(LOOKUP(O12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5735.3328696468789},{"$f":"IFERROR(LOOKUP(P12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":958.13875030849726},{"$f":"IFERROR(LOOKUP(Q12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":3457.3749635539616},{"$f":"IFERROR(LOOKUP(R12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5057.6096460228482},{"$f":"IFERROR(LOOKUP(S12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":1916.7501191308347},{"$f":"IFERROR(LOOKUP(T12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2391.5756684081289},{"$f":"IFERROR(LOOKUP(U12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4328.628574963227},{"$f":"IFERROR(LOOKUP(V12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":947.4533225429135},{"$f":"IFERROR(LOOKUP(W12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4754.3312813027806},{"$f":"IFERROR(LOOKUP(X12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2918.5821226006178},{"$f":"IFERROR(LOOKUP(Y12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5486.3666531726612},{"$f":"IFERROR(LOOKUP(Z12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2602.4339135492501},{"$f":"IFERROR(LOOKUP(AA12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":3525.8371722583042},{"$f":"IFERROR(LOOKUP(AB12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":3214.380229561672},{"$f":"IFERROR(LOOKUP(AC12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":1001.6655792724388},{"$f":"IFERROR(LOOKUP(AD12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":872.67157055107702},{"$f":"IFERROR(LOOKUP(AE12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":1107.1299596682184},{"$f":"IFERROR(LOOKUP(AF12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4263.4696056035864},{"$f":"IFERROR(LOOKUP(AG12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":354.56400888806883},{"$f":"IFERROR(LOOKUP(AH12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2819.6987282965129},{"$f":"IFERROR(LOOKUP(AI12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5437.8957671452517},{"$f":"IFERROR(LOOKUP(AJ12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4032.0607927739188},{"$f":"IFERROR(LOOKUP(AK12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5731.082776338566},{"$f":"IFERROR(LOOKUP(AL12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2259.8137002458311},{"$f":"IFERROR(LOOKUP(AM12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":974.55300943718782},{"$f":"IFERROR(LOOKUP(AN12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4451.8045613903896},{"$f":"IFERROR(LOOKUP(AO12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4012.9653829281474},{"$f":"IFERROR(LOOKUP(AP12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":2128.4020031985706},{"$f":"IFERROR(LOOKUP(AQ12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4885.8294088017883},{"$f":"IFERROR(LOOKUP(AR12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":4121.4551604850149},{"$f":"IFERROR(LOOKUP(AS12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":5221.4556285381195},{"$f":"IFERROR(LOOKUP(AT12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AU12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AV12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AW12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AX12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AY12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(AZ12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BA12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BB12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BC12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BD12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BE12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BF12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BG12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BH12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BI12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BJ12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BK12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BL12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BM12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BN12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BO12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0},{"$f":"IFERROR(LOOKUP(BP12,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E16=0,0,$E16)","v":0}]
[null,null,"Outstanding balances from previous periods","AUD '000",{"$f":"1-E16","v":0.39999999999999991},null,null,{"$f":"SUM(I17:BP17)","v":72746.595449931556},{"$f":"IFERROR(LOOKUP(I13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(J13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":399.99999999999989},{"$f":"IFERROR(LOOKUP(K13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":413.35670627689899},{"$f":"IFERROR(LOOKUP(L13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":480.96139530686776},{"$f":"IFERROR(LOOKUP(M13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3241.9529900555108},{"$f":"IFERROR(LOOKUP(N13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":213.18717706165285},{"$f":"IFERROR(LOOKUP(O13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":682.92856084048151},{"$f":"IFERROR(LOOKUP(P13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3823.5552464312509},{"$f":"IFERROR(LOOKUP(Q13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":638.75916687233121},{"$f":"IFERROR(LOOKUP(R13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2304.9166423693068},{"$f":"IFERROR(LOOKUP(S13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3371.7397640152312},{"$f":"IFERROR(LOOKUP(T13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1277.8334127538892},{"$f":"IFERROR(LOOKUP(U13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1594.3837789387519},{"$f":"IFERROR(LOOKUP(V13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2885.7523833088171},{"$f":"IFERROR(LOOKUP(W13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":631.63554836194214},{"$f":"IFERROR(LOOKUP(X13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3169.554187535186},{"$f":"IFERROR(LOOKUP(Y13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1945.7214150670777},{"$f":"IFERROR(LOOKUP(Z13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3657.5777687817731},{"$f":"IFERROR(LOOKUP(AA13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1734.955942366166},{"$f":"IFERROR(LOOKUP(AB13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2350.5581148388683},{"$f":"IFERROR(LOOKUP(AC13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2142.9201530411142},{"$f":"IFERROR(LOOKUP(AD13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":667.77705284829233},{"$f":"IFERROR(LOOKUP(AE13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":581.78104703405108},{"$f":"IFERROR(LOOKUP(AF13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":738.08663977881201},{"$f":"IFERROR(LOOKUP(AG13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2842.3130704023897},{"$f":"IFERROR(LOOKUP(AH13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":236.37600592537913},{"$f":"IFERROR(LOOKUP(AI13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1879.7991521976746},{"$f":"IFERROR(LOOKUP(AJ13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3625.2638447634999},{"$f":"IFERROR(LOOKUP(AK13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2688.0405285159445},{"$f":"IFERROR(LOOKUP(AL13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3820.7218508923761},{"$f":"IFERROR(LOOKUP(AM13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1506.5424668305536},{"$f":"IFERROR(LOOKUP(AN13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":649.70200629145836},{"$f":"IFERROR(LOOKUP(AO13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2967.869707593592},{"$f":"IFERROR(LOOKUP(AP13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2675.3102552854302},{"$f":"IFERROR(LOOKUP(AQ13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":1418.9346687990467},{"$f":"IFERROR(LOOKUP(AR13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3257.2196058678574},{"$f":"IFERROR(LOOKUP(AS13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":2747.6367736566758},{"$f":"IFERROR(LOOKUP(AT13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":3480.9704190254115},{"$f":"IFERROR(LOOKUP(AU13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(AV13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(AW13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(AX13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(AY13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(AZ13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BA13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BB13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BC13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BD13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BE13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BF13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BG13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BH13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BI13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BJ13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BK13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BL13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BM13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BN13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BO13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0},{"$f":"IFERROR(LOOKUP(BP13,$H$4:$BP$4,$H$22:$BP$22),0)*IF($E17=0,0,$E17)","v":0}]
[null,null,"Total","AUD '000",null,null,null,{"$f":"SUM(I18:BP18)","v":181866.48862482898},{"$f":"SUM(I16:I17)","v":600.00000000000011},{"$f":"SUM(J16:J17)","v":1020.0350594153485},1134.7987992372009,5343.890880390135,3561.7337556479902,1237.5800183223755,6418.2614304873605,4781.6939967397484,4096.1341304262933,7362.526288392155,5288.4898831460659,3669.4090811620181,5923.0123539019787,3833.2057058517307,5385.9668296647224,6088.1363101358038,7432.0880682397392,6260.0116823310236,5260.79311462447,5564.9383444005398,3144.5857323135529,1540.4486233993694,1688.9110067022693,5001.5562453823986,3196.8770792904584,3056.074734221892,7317.6949193429264,7657.3246375374183,8419.1233048545109,6080.5355511382077,2481.0954762677416,5101.5065676818476,6980.8350905217394,4803.7122584840008,6304.7640776008348,7378.6747663528722,7969.0924021947958,3480.9704190254115,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Account"]
[null,null,"Balance b/f","AUD '000",null,null,null,null,{"$f":"H24*I5","v":0},{"$f":"I24*J5","v":433.39176569224753},{"$f":"J24*K5","v":615.76019454406855},{"$f":"K24*L5","v":7585.8438704456466},{"$f":"L24*M5","v":2774.9209327096441},{"$f":"M24*N5","v":920.50857916285759},{"$f":"N24*O5","v":9241.81667691861},{"$f":"O24*P5","v":4420.4531636120773},{"$f":"P24*Q5","v":5401.0507727955974},{"$f":"Q24*R5","v":9734.2660524073835},{"$f":"R24*S5","v":5566.3232958999524},{"$f":"S24*T5","v":4263.792860100767},{"$f":"T24*U5","v":7808.764737210794},{"$f":"U24*V5","v":3464.8412542136703},{"$f":"V24*W5","v":7555.5210171999061},{"$f":"W24*X5","v":7033.8577252028799},{"$f":"X24*Y5","v":10089.665837021512},{"$f":"Y24*Z5","v":6994.9676246971876},{"$f":"Z24*AA5","v":6611.3512294633365},{"$f":"AA24*AB5","v":6707.8584974416517},{"$f":"AB24*AC5","v":2812.3627851618439},{"$f":"AC24*AD5","v":1122.229670433419},{"$f":"AD24*AE5","v":1426.9976464810798},{"$f":"AE24*AF5","v":6843.8693157847856},{"$f":"AF24*AG5","v":2433.2530852158352},{"$f":"AG24*AH5","v":3935.8738864195643},{"$f":"AH24*AI5","v":9942.9587641064245},{"$f":"AI24*AJ5","v":9345.3651660533633},{"$f":"AJ24*AK5","v":11239.845155746887},{"$f":"AK24*AL5","v":6587.0780179687608},{"$f":"AL24*AM5","v":2130.7974825591991},{"$f":"AM24*AN5","v":7069.3762752754392},{"$f":"AN24*AO5","v":8656.1453458071701},{"$f":"AO24*AP5","v":5222.6469272830491},{"$f":"AP24*AQ5","v":8561.9836834686939},{"$f":"AQ24*AR5","v":9126.3115400095521},{"$f":"AR24*AS5","v":0},{"$f":"AS24*AT5","v":0},{"$f":"AT24*AU5","v":0},{"$f":"AU24*AV5","v":0},{"$f":"AV24*AW5","v":0},{"$f":"AW24*AX5","v":0},{"$f":"AX24*AY5","v":0},{"$f":"AY24*AZ5","v":0},{"$f":"AZ24*BA5","v":0},{"$f":"BA24*BB5","v":0},{"$f":"BB24*BC5","v":0},{"$f":"BC24*BD5","v":0},{"$f":"BD24*BE5","v":0},{"$f":"BE24*BF5","v":0},{"$f":"BF24*BG5","v":0},{"$f":"BG24*BH5","v":0},{"$f":"BH24*BI5","v":0},{"$f":"BI24*BJ5","v":0},{"$f":"BJ24*BK5","v":0},{"$f":"BK24*BL5","v":0},{"$f":"BL24*BM5","v":0},{"$f":"BM24*BN5","v":0},{"$f":"BN24*BO5","v":0},{"$f":"BO24*BP5","v":0}]
[null,null,"Revenue","AUD '000",null,null,{"$f":"SUM(I22:BP22)","v":180866.48862482895},{"$f":"H8","v":1000},{"$f":"I8","v":1033.3917656922476},{"$f":"J8","v":1202.4034882671697},{"$f":"K8","v":8104.8824751387783},{"$f":"L8","v":532.96794265413223},{"$f":"M8","v":1707.3214021012041},{"$f":"N8","v":9558.8881160781293},{"$f":"O8","v":1596.8979171808285},{"$f":"P8","v":5762.2916059232684},{"$f":"Q8","v":8429.3494100380794},{"$f":"R8","v":3194.5835318847239},{"$f":"S8","v":3985.9594473468806},{"$f":"T8","v":7214.3809582720442},{"$f":"U8","v":1579.0888709048556},{"$f":"V8","v":7923.885468837967},{"$f":"W8","v":4864.3035376676953},{"$f":"X8","v":9143.9444219544348},{"$f":"Y8","v":4337.3898559154159},{"$f":"Z8","v":5876.3952870971725},{"$f":"AA8","v":5357.3003826027862},{"$f":"AB8","v":1669.4426321207311},{"$f":"AC8","v":1454.4526175851281},{"$f":"AD8","v":1845.2165994470304},{"$f":"AE8","v":7105.7826760059761},{"$f":"AF8","v":590.94001481344799},{"$f":"AG8","v":4699.4978804941875},{"$f":"AH8","v":9063.1596119087517},{"$f":"AI8","v":6720.1013212898633},{"$f":"AJ8","v":9551.8046272309421},{"$f":"AK8","v":3766.3561670763847},{"$f":"AL8","v":1624.2550157286462},{"$f":"AM8","v":7419.6742689839821},{"$f":"AN8","v":6688.2756382135776},{"$f":"AO8","v":3547.3366719976175},{"$f":"AP8","v":8143.0490146696457},{"$f":"AQ8","v":6869.0919341416911},{"$f":"AR8","v":8702.426047563531},{"$f":"AS8","v":0},{"$f":"AT8","v":0},{"$f":"AU8","v":0},{"$f":"AV8","v":0},{"$f":"AW8","v":0},{"$f":"AX8","v":0},{"$f":"AY8","v":0},{"$f":"AZ8","v":0},{"$f":"BA8","v":0},{"$f":"BB8","v":0},{"$f":"BC8","v":0},{"$f":"BD8","v":0},{"$f":"BE8","v":0},{"$f":"BF8","v":0},{"$f":"BG8","v":0},{"$f":"BH8","v":0},{"$f":"BI8","v":0},{"$f":"BJ8","v":0},{"$f":"BK8","v":0},{"$f":"BL8","v":0},{"$f":"BM8","v":0},{"$f":"BN8","v":0},{"$f":"BO8","v":0},{"$f":"BP8","v":0}]
[null,null,"Received","AUD '000",null,null,null,{"$f":"SUM(I23:BP23)","v":-170416.42580360878},{"$f":"-I18*I5","v":-600.00000000000011},{"$f":"-J18*J5","v":-1020.0350594153485},{"$f":"-K18*K5","v":-1134.7987992372009},{"$f":"-L18*L5","v":-5343.890880390135},{"$f":"-M18*M5","v":-3561.7337556479902},{"$f":"-N18*N5","v":-1237.5800183223755},{"$f":"-O18*O5","v":-6418.2614304873605},{"$f":"-P18*P5","v":-4781.6939967397484},{"$f":"-Q18*Q5","v":-4096.1341304262933},{"$f":"-R18*R5","v":-7362.526288392155},{"$f":"-S18*S5","v":-5288.4898831460659},{"$f":"-T18*T5","v":-3669.4090811620181},{"$f":"-U18*U5","v":-5923.0123539019787},{"$f":"-V18*V5","v":-3833.2057058517307},{"$f":"-W18*W5","v":-5385.9668296647224},{"$f":"-X18*X5","v":-6088.1363101358038},{"$f":"-Y18*Y5","v":-7432.0880682397392},{"$f":"-Z18*Z5","v":-6260.0116823310236},{"$f":"-AA18*AA5","v":-5260.79311462447},{"$f":"-AB18*AB5","v":-5564.9383444005398},{"$f":"-AC18*AC5","v":-3144.5857323135529},{"$f":"-AD18*AD5","v":-1540.4486233993694},{"$f":"-AE18*AE5","v":-1688.9110067022693},{"$f":"-AF18*AF5","v":-5001.5562453823986},{"$f":"-AG18*AG5","v":-3196.8770792904584},{"$f":"-AH18*AH5","v":-3056.074734221892},{"$f":"-AI18*AI5","v":-7317.6949193429264},{"$f":"-AJ18*AJ5","v":-7657.3246375374183},{"$f":"-AK18*AK5","v":-8419.1233048545109},{"$f":"-AL18*AL5","v":-6080.5355511382077},{"$f":"-AM18*AM5","v":-2481.0954762677416},{"$f":"-AN18*AN5","v":-5101.5065676818476},{"$f":"-AO18*AO5","v":-6980.8350905217394},{"$f":"-AP18*AP5","v":-4803.7122584840008},{"$f":"-AQ18*AQ5","v":-6304.7640776008348},{"$f":"-AR18*AR5","v":-7378.6747663528722},{"$f":"-AS18*AS5","v":0},{"$f":"-AT18*AT5","v":0},{"$f":"-AU18*AU5","v":0},{"$f":"-AV18*AV5","v":0},{"$f":"-AW18*AW5","v":0},{"$f":"-AX18*AX5","v":0},{"$f":"-AY18*AY5","v":0},{"$f":"-AZ18*AZ5","v":0},{"$f":"-BA18*BA5","v":0},{"$f":"-BB18*BB5","v":0},{"$f":"-BC18*BC5","v":0},{"$f":"-BD18*BD5","v":0},{"$f":"-BE18*BE5","v":0},{"$f":"-BF18*BF5","v":0},{"$f":"-BG18*BG5","v":0},{"$f":"-BH18*BH5","v":0},{"$f":"-BI18*BI5","v":0},{"$f":"-BJ18*BJ5","v":0},{"$f":"-BK18*BK5","v":0},{"$f":"-BL18*BL5","v":0},{"$f":"-BM18*BM5","v":0},{"$f":"-BN18*BN5","v":0},{"$f":"-BO18*BO5","v":0},{"$f":"-BP18*BP5","v":0}]
[null,null,"Balance c/f","AUD '000",null,null,null,null,{"$f":"SUM(I21:I23)","v":433.39176569224753},{"$f":"SUM(J21:J23)","v":615.76019454406855},7585.8438704456466,2774.9209327096441,920.50857916285759,9241.81667691861,4420.4531636120773,5401.0507727955974,9734.2660524073835,5566.3232958999524,4263.792860100767,7808.764737210794,3464.8412542136703,7555.5210171999061,7033.8577252028799,10089.665837021512,6994.9676246971876,6611.3512294633365,6707.8584974416517,2812.3627851618439,1122.229670433419,1426.9976464810798,6843.8693157847856,2433.2530852158352,3935.8738864195643,9942.9587641064245,9345.3651660533633,11239.845155746887,6587.0780179687608,2130.7974825591991,7069.3762752754392,8656.1453458071701,5222.6469272830491,8561.9836834686939,9126.3115400095521,10450.06282122021,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Working captial adjustment for cashflow","AUD '000",null,null,null,{"$f":"SUM(I26:BP26)","v":-10450.06282122021},{"$f":"I21-I24","v":-433.39176569224753},{"$f":"J21-J24","v":-182.36842885182102},-6970.0836759015783,4810.9229377360025,1854.4123535467866,-8321.3080977557529,4821.3635133065327,-980.59760918352004,-4333.2152796117862,4167.9427565074311,1302.5304357991854,-3544.971877110027,4343.9234829971238,-4090.6797629862358,521.66329199702614,-3055.8081118186319,3094.6982123243242,383.61639523385111,-96.507267978315213,3895.4957122798078,1690.133114728425,-304.7679760476608,-5416.8716693037059,4410.6162305689504,-1502.6208012037291,-6007.0848776868606,597.59359805306121,-1894.4799896935237,4652.7671377781262,4456.2805354095617,-4938.5787927162401,-1586.7690705317309,3433.498418524121,-3339.3367561856448,-564.32785654085819,-1323.7512812106579,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]