{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Cashflow","Summary","Standard chart of accounts","DairyBase Import","Working"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":51,"comments":1,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cashflow","index":1,"n_rows":91,"n_cols":24,"rows_kept":91,"cut":false,"hidden":false,"merged":[[34,2,34,3],[60,1,60,2],[62,1,62,2],[90,0,90,17]]}
[null,null,null,null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,"DairyBase"]
[null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Report"]
[]
[null,null,null,null,"Annual","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Annual","Month"]
[null,null,null,null,{"$f":"YEAR(E15)","v":2017},{"$f":"YEAR(F15)","v":2017},2017,2017,2017,2017,2017,2018,2018,2018,2018,2018,2018,{"$f":"Q5","v":2018},2016]
[null,null,null,null,{"$f":"IF(E8<=6,E5-1,E5)","v":2016},{"$f":"IF(F8<=6,F5-1,F5)","v":2017},{"$f":"IF(G8<=6,G5-1,G5)","v":2017},2017,2017,2017,2017,2017,2017,2017,2017,2017,2017,{"$f":"Q6","v":2017},2016]
[null,null,null,null,{"$f":"VLOOKUP(E8,Quarters,2,FALSE)","v":{"$error":"#NAME?"}},{"$f":"VLOOKUP(F8,Quarters,2,FALSE)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,1]
[null,null,null,null,{"$f":"MONTH(E15)","v":6},{"$f":"MONTH(F15)","v":7},8,9,10,11,12,1,2,3,4,5,6,null,7]
[null,null,null,null,{"$f":"DAY(DATE(YEAR(E15),MONTH(E15)+1,1)-1)","v":30},{"$f":"DAY(DATE(YEAR(F15),MONTH(F15)+1,1)-1)","v":31},31,30,31,30,31,31,28,31,30,31,30,365,31]
[null,null,null,null,{"$f":"TRIM(TEXT(E5,\"####\"))&TRIM(TEXT(E8,\"0#\"))","v":"201706"},{"$f":"TRIM(TEXT(F5,\"####\"))&TRIM(TEXT(F8,\"0#\"))","v":"201707"},"201708","201709","201710","201711","201712","201801","201802","201803","201804","201805","201806",null,"201607"]
[null,null,null,null,{"$f":"E16","v":"Budget"},{"$f":"F16","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"R16","v":"Budget"},"Budget"]
[]
[]
[null,null,null,null,{"$f":"F2","v":2017},{"$f":"YEAR(F15)","v":2017},{"$f":"YEAR(G15)","v":2017},2017,2017,2017,2017,{"$f":"YEAR(L15)","v":2018},2018,2018,2018,2018,2018,{"$f":"TRIM(TEXT(R6,\"####\")) & \"/\" & RIGHT(TRIM(TEXT(R6+1,\"####\")),2)","v":"2017/18"}]
[null,null,null,null,{"$f":"DATEVALUE(\"15/06/\"&TRIM(TEXT($E$14,\"####\")))","v":"2017-06-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(E15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(E15),\"####\")))","v":"2017-07-15"},"2017-08-15","2017-09-15","2017-10-15","2017-11-15","2017-12-15",{"$f":"DATEVALUE(\"15/01/\"&TRIM(TEXT(YEAR(K15)+1,\"####\")))","v":"2018-01-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(L15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(L15),\"####\")))","v":"2018-02-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(M15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(M15),\"####\")))","v":"2018-03-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(N15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(N15),\"####\")))","v":"2018-04-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(O15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(O15),\"####\")))","v":"2018-05-15"},{"$f":"DATEVALUE(\"15/\"&TRIM(TEXT(MONTH(P15)+1,\"##\"))&\"/\"&TRIM(TEXT(YEAR(P15),\"####\")))","v":"2018-06-15"},"Annual"]
[null,null,null,null,"Budget",null,null,null,null,null,null,null,null,null,null,null,null,"Budget"]
[null,{"$f":"GetVersion()","v":{"$error":"#NAME?"}}]
[]
[null,"Milk income (Current year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F19,G19,H19,I19,J19,K19,L19,M19,N19,O19,P19,Q19)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B19),'DairyBase Import'!B19,\"\")","v":846454}]
[null,"Milk income (Retrospective/Step ups)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null," "]
[null,"Livestock Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B21),'DairyBase Import'!B21,\"\")","v":45000}]
[null,"Feed and water sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B22),'DairyBase Import'!B22,\"\")","v":0}]
[null,"Other farm income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B23),'DairyBase Import'!B23,\"\")","v":11000}]
[null,"TOTAL CASH INCOME",null,null,null,{"$f":"SUM(F19:F23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B24),'DairyBase Import'!B24,\"\")","v":902454}]
[]
[null,"AI and herd test ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F26,G26,H26,I26,J26,K26,L26,M26,N26,O26,P26,Q26)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B26),'DairyBase Import'!B26,\"\")","v":11066}]
[null,"Animal health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B27),'DairyBase Import'!B27,\"\")","v":16687}]
[null,"Calf rearing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B28),'DairyBase Import'!B28,\"\")","v":3146}]
[null,"Other herd costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B29),'DairyBase Import'!B29,\"\")","v":""}]
[null,"Total herd costs",null,null,null,{"$f":"F26+F27+F28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B30),'DairyBase Import'!B30,\"\")","v":30899}]
[null,"Shed power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B31),'DairyBase Import'!B31,\"\")","v":12000}]
[null,"Dairy supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B32),'DairyBase Import'!B32,\"\")","v":9858}]
[null,"Other shed costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B33),'DairyBase Import'!B33,\"\")","v":""}]
[null,"Total shed costs",null,null,null,{"$f":"SUM(F31,F32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B34),'DairyBase Import'!B34,\"\")","v":21858}]
[null,"Concentrate 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B35),'DairyBase Import'!B35,\"\")","v":1167.4944444444445}]
[null,"Concentrate 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Concentrate 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Purchased fodder 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B38),'DairyBase Import'!B38,\"\")","v":""}]
[null,"Purchased fodder 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other puchased feeds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Agistment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B41),'DairyBase Import'!B41,\"\")","v":18000}]
[null,"Other feed costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F42,G42,H42,I42,J42,K42,L42,M42,N42,O42,P42,Q42)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B42),'DairyBase Import'!B42,\"\")","v":0}]
[null,"Total purchased feed costs",null,null,null,{"$f":"SUM(F35:F41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B43),'DairyBase Import'!B43,\"\")","v":247595}]
[null,"Hay and silage making",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B44),'DairyBase Import'!B44,\"\")","v":18545}]
[null,"PKS Fertiliser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Nitrogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B46),'DairyBase Import'!B46,\"\")","v":32910}]
[null,{"$f":"IF(LEN(C47)=0,\"Lime & Gypsum\",TRIM(C47))","v":"Lime & Gypsum"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Irrigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B48),'DairyBase Import'!B48,\"\")","v":30687}]
[null,"Pasture and cropping",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B49),'DairyBase Import'!B49,\"\")","v":13593}]
[null,"Fuel and oil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B50),'DairyBase Import'!B50,\"\")","v":9594}]
[null,"Total home grown feed costs",null,null,null,{"$f":"SUM(F44:F50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B51),'DairyBase Import'!B51,\"\")","v":105329}]
[null,"VARIABLE COSTS",null,null,null,{"$f":"SUM(F30,F34,F51,F43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B52),'DairyBase Import'!B52,\"\")","v":396781}]
[]
[null,"Employed labour costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F54,G54,H54,I54,J54,K54,L54,M54,N54,O54,P54,Q54)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B54),'DairyBase Import'!B54,\"\")","v":90000}]
[null,"Repairs and maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B55),'DairyBase Import'!B55,\"\")","v":20610}]
[null,"Vehicles (Rego and insurance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Farm insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B57),'DairyBase Import'!B57,\"\")","v":""}]
[null,"Other overheads (Rates/insurance/etc)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B58),'DairyBase Import'!B58,\"\")","v":20857}]
[null,"OVERHEAD COSTS",null,null,null,{"$f":"SUM(F54:F58)","v":0},{"$f":"SUM(G54:G58)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B59),'DairyBase Import'!B59,\"\")","v":131467}]
[]
[null,"FARM WORKING EXPENSES (FWE)\n(Variable plus Cash Overhead Costs)",null,null,null,{"$f":"F59+F52","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F61,G61,H61,I61,J61,K61,L61,M61,N61,O61,P61,Q61)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B61),'DairyBase Import'!B61,\"\")","v":528248}]
[]
[null,"FARM OPERATING CASH SURPLUS\n(Total Cash Income minus Farm Working Expenses)",null,null,null,{"$f":"F24-F61","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F63,G63,H63,I63,J63,K63,L63,M63,N63,O63,P63,Q63)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B63),'DairyBase Import'!B63,\"\")","v":374206}]
[]
[null,"Interest loan 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F65,G65,H65,I65,J65,K65,L65,M65,N65,O65,P65,Q65)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B65),'DairyBase Import'!B65,\"\")","v":35687}]
[null,"Interest loan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Interest loan 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Hire purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Leases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B69),'DairyBase Import'!B69,\"\")","v":56234}]
[null,"Finance costs",null,null,null,{"$f":"SUM(F65:F69)","v":0},{"$f":"SUM(G65:G69)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B70),'DairyBase Import'!B70,\"\")","v":91921}]
[null,"Principal repayments loan 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B71),'DairyBase Import'!B71,\"\")","v":150000}]
[null,"Principal repayments loan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Principal repayments loan 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Livestock purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other capital purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B75),'DairyBase Import'!B75,\"\")","v":25000}]
[null,"Capital sales/Farm man.deposits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Unpaid bills (60+ days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital Transactions",null,null,null,{"$f":"SUM(F71:F75)-F76-F77","v":0},0,0,0,0,0,0,{"$f":"SUM(M71:M75)-M76-M77","v":0},{"$f":"SUM(N71:N75)-N76-N77","v":0},0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B78),'DairyBase Import'!B78,\"\")","v":275000}]
[]
[null,"NET FARM CASH FLOW",null,null,null,{"$f":"F63-(F70+F78)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B80),'DairyBase Import'!B80,\"\")","v":-39744}]
[null,"Non farm income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F81,G81,H81,I81,J81,K81,L81,M81,N81,O81,P81,Q81)","v":0},{"$f":"IF(ISNUMBER('DairyBase Import'!B81),'DairyBase Import'!B81,\"\")","v":2971}]
[null,"Non farm expenses/drawings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(ISNUMBER('DairyBase Import'!B82),'DairyBase Import'!B82,\"\")","v":50000}]
[null,"GST (Estimate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tax (PAYG)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Net Non Farm Income and Tax",null,null,null,{"$f":"F81-F82-F83-F84","v":0},{"$f":"G81-G82-G83-G84","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"S81-S82-S83-S84","v":-47029}]
[]
[null,"Net monthly cash flow total",null,null,null,{"$f":"F80+F85","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F87,G87,H87,I87,J87,K87,L87,M87,N87,O87,P87,Q87)","v":0},{"$f":"S80+S85","v":-86773}]
[null,null,"Opening Balance",null,null,null,null,null,null,null,null,null,null,null,null,null,"Closing Balance"]
[null,"Cumulative cash flow",null,null,null,{"$f":"F87+C89","v":0},{"$f":"F89+G87","v":0},{"$f":"G89+H87","v":0},{"$f":"H89+I87","v":0},0,0,0,0,0,0,0,0,{"$f":"Q89","v":0}]
[]
["Published by Dairy Australia Limited. This is a reference tool to assist in the decision making process. Whilst all reasonable efforts have been taken to ensure the accuracy of the Dairy cash management planner, use of the information contained herein is at one’s own risk. To the fullest extent permitted by Australian law, Dairy Australia disclaims all liability for any losses, costs, damages and the like sustained or incurred as a result of the use of or reliance upon the information contained herein, including, without limitation, liability stemming from reliance upon any part which may contain inadvertent errors, whether typographical or otherwise, or omissions of any kind. © Dairy Australia Limited 2016. All rights reserved. "]

{"sheet":"Summary","index":2,"n_rows":97,"n_cols":20,"rows_kept":97,"cut":false,"hidden":false,"merged":[[72,1,72,2],[74,1,74,2],[13,1,13,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values imported from the DairyBase report file"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SUMMARY",null,null,null,null,"Milk solids","Cows","% Income","Milking area","Total area",null,null,null,null,"Milksolids","Cows","% Income","Milking area","Total area"]
[null,null,null,null,null,null,"(kg)",null,null,"(ha)","(ha)",null,null,null,null,"(kg)",null,null,"(ha)","(ha)"]
[null,null,null,null,null,null,{"$f":"E20","v":0},{"$f":"E21","v":0},null,null,null,null,null,null,null,{"$f":"N20","v":120475.3662},{"$f":"N21","v":260},null,{"$f":"IF(ISNUMBER('DairyBase Import'!B8),'DairyBase Import'!B8,\"\")","v":110},{"$f":"IF(ISNUMBER('DairyBase Import'!B9),'DairyBase Import'!B9,\"\")","v":137}]
[]
[null,"MILK PRODUCTION"]
[null,"Milk production - litres (l)",null,null,null,null,null,{"$f":"IF(H16>0,E19/H16,0)","v":0},null,{"$f":"IF(J16>0,E19/J16,0)","v":0},{"$f":"IF(K16>0,E19/K16,0)","v":0},null,null,{"$f":"IF(ISNUMBER('DairyBase Import'!B4),'DairyBase Import'!B4,\"\")","v":1504062},null,null,{"$f":"IF(Q16>0,N19/Q16,0)","v":5784.8538461538465},null,{"$f":"IF(S16>0,N19/S16,0)","v":13673.290909090909},{"$f":"IF(T16>0,N19/T16,0)","v":10978.554744525547}]
[null,"Milk production - milk solids (kg)",null,null,{"$f":"E19*(E22+E23)","v":0},null,{"$f":"IF(G16>0,1/(E19/G16),0)","v":0},{"$f":"IF(H$16>0,$E20/H$16,0)","v":0},null,{"$f":"IF(J$16>0,$E20/J$16,0)","v":0},{"$f":"IF(K$16>0,$E20/K$16,0)","v":0},null,null,{"$f":"N19*(N22+N23)","v":120475.3662},null,{"$f":"IF(P16>0,1/(N19/P16),0)","v":8.0100000000000005E-2},{"$f":"IF(Q$16>0,$N20/Q$16,0)","v":463.3667930769231},null,{"$f":"IF(S$16>0,$N20/S$16,0)","v":1095.2306018181819},{"$f":"IF(T$16>0,$N20/T$16,0)","v":879.38223503649635}]
[null,"Cows",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('DairyBase Import'!B5),'DairyBase Import'!B5,\"\")","v":260}]
[null,"Butterfat (% m/v)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('DairyBase Import'!B6),'DairyBase Import'!B6,\"\")","v":4.5400000000000003E-2}]
[null,"Protein (% m/v)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER('DairyBase Import'!B7),'DairyBase Import'!B7,\"\")","v":3.4700000000000002E-2}]
[null,"Milk payment equivilent ($/kg MS)",null,null,{"$f":"IF(E20>0,E27/E20,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N20>0,E27/N20,)","v":0}]
[null,"Milk payment (cpl)",null,null,{"$f":"IF(E19>0,E27*100/E19,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(N19>0,E27*100/N19,)","v":0}]
[]
[null,"Milk income (Current year)",null,null,{"$f":"Cashflow!R19","v":0},null,{"$f":"IF(G$16>0,$E27/G$16,0)","v":0},0,{"$f":"IF(E$32>0,$E27/E$32,0)","v":0},{"$f":"IF(J$16>0,$E27/J$16,0)","v":0},{"$f":"IF(K$16>0,$E27/K$16,0)","v":0}]
[null,"Milk income (Retrospective/Step ups)",null,null,{"$f":"Cashflow!R20","v":0},null,0,0,0,{"$f":"IF(J$16>0,$E28/J$16,0)","v":0},0]
[null,"Livestock sales",null,null,{"$f":"Cashflow!R21","v":0},null,0,0,0,0,0]
[null,"Feed and water sales",null,null,{"$f":"Cashflow!R22","v":0},null,0,0,0,0,0]
[null,"Other farm income",null,null,{"$f":"Cashflow!R23","v":0},null,0,0,0,{"$f":"IF(J$16>0,$E31/J$16,0)","v":0},{"$f":"IF(K$16>0,$E31/K$16,0)","v":0}]
[null,"Total Cash Income",null,null,{"$f":"Cashflow!R24","v":0},null,{"$f":"IF(G$16>0,$E32/G$16,0)","v":0},{"$f":"IF(H$16>0,$E32/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E32/J$16,0)","v":0},{"$f":"IF(K$16>0,$E32/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"AI and herd test ",null,null,{"$f":"Cashflow!R26","v":0},null,{"$f":"IF(G$16>0,$E34/G$16,0)","v":0},{"$f":"IF(H$16>0,$E34/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E34/J$16,0)","v":0},0]
[null,"Animal health",null,null,{"$f":"Cashflow!R27","v":0},null,{"$f":"IF(G$16>0,$E35/G$16,0)","v":0},0,0,0,0]
[null,"Calf rearing",null,null,{"$f":"Cashflow!R28","v":0},null,{"$f":"IF(G$16>0,$E36/G$16,0)","v":0},0,0,0,0]
[null,"Other herd costs",null,null,{"$f":"Cashflow!R29","v":0},null,{"$f":"IF(G$16>0,$E37/G$16,0)","v":0},{"$f":"IF(H$16>0,$E37/H$16,0)","v":0},{"$f":"IF(E$32>0,$E37/E$32,0)","v":0},{"$f":"IF(J$16>0,$E37/J$16,0)","v":0},{"$f":"IF(K$16>0,$E37/K$16,0)","v":0}]
[null,"Total Herd Costs",null,null,{"$f":"Cashflow!R30","v":0},null,{"$f":"IF(G$16>0,$E38/G$16,0)","v":0},{"$f":"IF(H$16>0,$E38/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E38/J$16,0)","v":0},{"$f":"IF(K$16>0,$E38/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Shed power",null,null,{"$f":"Cashflow!R31","v":0},null,{"$f":"IF(G$16>0,$E40/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E40/J$16,0)","v":0},0]
[null,"Dairy supplies",null,null,{"$f":"Cashflow!R32","v":0},null,{"$f":"IF(G$16>0,$E41/G$16,0)","v":0},0,0,0,0]
[null,"Other shed costs",null,null,{"$f":"Cashflow!R33","v":0},null,{"$f":"IF(G$16>0,$E42/G$16,0)","v":0},{"$f":"IF(H$16>0,$E42/H$16,0)","v":0},{"$f":"IF(E$32>0,$E42/E$32,0)","v":0},{"$f":"IF(J$16>0,$E42/J$16,0)","v":0},{"$f":"IF(K$16>0,$E42/K$16,0)","v":0}]
[null,"Total shed costs",null,null,{"$f":"Cashflow!R34","v":0},null,{"$f":"IF(G$16>0,$E43/G$16,0)","v":0},{"$f":"IF(H$16>0,$E43/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E43/J$16,0)","v":0},{"$f":"IF(K$16>0,$E43/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Concentrate 1",null,null,{"$f":"Cashflow!R35","v":0},null,{"$f":"IF(G$16>0,$E45/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E45/J$16,0)","v":0},0]
[null,"Concentrate 2",null,null,{"$f":"Cashflow!R36","v":0},null,0,0,0,0,0]
[null,"Concentrate 3",null,null,{"$f":"Cashflow!R37","v":0},null,0,0,0,0,0]
[null,"Purchased fodder 1",null,null,{"$f":"Cashflow!R38","v":0},null,0,0,0,0,0]
[null,"Purchased fodder 2",null,null,{"$f":"Cashflow!R39","v":0},null,0,0,0,0,0]
[null,"Other puchased feeds",null,null,{"$f":"Cashflow!R40","v":0},null,0,0,0,0,0]
[null,"Agistment",null,null,{"$f":"Cashflow!R41","v":0},null,0,null,0]
[null,"Other feed costs",null,null,{"$f":"Cashflow!R42","v":0},null,{"$f":"IF(G$16>0,$E52/G$16,0)","v":0},{"$f":"IF(H$16>0,$E52/H$16,0)","v":0},{"$f":"IF(E$32>0,$E52/E$32,0)","v":0},{"$f":"IF(J$16>0,$E52/J$16,0)","v":0},{"$f":"IF(K$16>0,$E52/K$16,0)","v":0}]
[null,"Total Purchased Feed Costs",null,null,{"$f":"Cashflow!R43","v":0},null,{"$f":"IF(G$16>0,$E53/G$16,0)","v":0},{"$f":"IF(H$16>0,$E53/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E53/J$16,0)","v":0},{"$f":"IF(K$16>0,$E53/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Hay and silage making",null,null,{"$f":"Cashflow!R44","v":0},null,{"$f":"IF(G$16>0,$E55/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E55/J$16,0)","v":0},0]
[null,"PKS fertiliser",null,null,{"$f":"Cashflow!R45","v":0},null,0,0,0,0,0]
[null,"Nitrogen",null,null,{"$f":"Cashflow!R46","v":0},null,0,0,0,0,0]
[null,"Lime and gypsum",null,null,{"$f":"Cashflow!R47","v":0},null,0,0,0,0,0]
[null,"Irrigation",null,null,{"$f":"Cashflow!R48","v":0},null,{"$f":"IF(G$16>0,$E59/G$16,0)","v":0},{"$f":"IF(H$16>0,$E59/H$16,0)","v":0},0,0,0]
[null,"Pasture and cropping",null,null,{"$f":"Cashflow!R49","v":0},null,{"$f":"IF(G$16>0,$E60/G$16,0)","v":0},0,0,0,0]
[null,"Fuel and oil",null,null,{"$f":"Cashflow!R50","v":0},null,{"$f":"IF(G$16>0,$E61/G$16,0)","v":0},0,0,0,0]
[null,"Total home grown feed costs",null,null,{"$f":"Cashflow!R51","v":0},null,{"$f":"IF(G$16>0,$E62/G$16,0)","v":0},{"$f":"IF(H$16>0,$E62/H$16,0)","v":0},{"$f":"IF(E$32>0,$E62/E$32,0)","v":0},{"$f":"IF(J$16>0,$E62/J$16,0)","v":0},{"$f":"IF(K$16>0,$E62/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"VARIABLE COSTS",null,null,{"$f":"Cashflow!R52","v":0},null,{"$f":"IF(G$16>0,$E64/G$16,0)","v":0},{"$f":"IF(H$16>0,$E64/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E64/J$16,0)","v":0},{"$f":"IF(K$16>0,$E64/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Employed labour costs",null,null,{"$f":"Cashflow!R54","v":0},null,{"$f":"IF(G$16>0,$E66/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E66/J$16,0)","v":0},0]
[null,"Repairs and maintenance",null,null,{"$f":"Cashflow!R55","v":0},null,0,0,0,0,0]
[null,"Vehicles (rego and insurance)",null,null,{"$f":"Cashflow!R56","v":0},null,0,0,0,0,0]
[null,"Farm insurance",null,null,{"$f":"Cashflow!R57","v":0},null,0,0,0,0,0]
[null,"Other overheads (rates/general freight/etc)",null,null,{"$f":"Cashflow!R58","v":0},null,0,0,0,0,0]
[null,"OVERHEAD COSTS",null,null,{"$f":"Cashflow!R59","v":0},null,{"$f":"IF(G$16>0,$E71/G$16,0)","v":0},{"$f":"IF(H$16>0,$E71/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E71/J$16,0)","v":0},{"$f":"IF(K$16>0,$E71/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"FARM WORKING EXPENSES (FWE)\n(Variable plus cash overhead costs)",null,null,{"$f":"Cashflow!R61","v":0},null,{"$f":"IF(G$16>0,$E73/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E73/J$16,0)","v":0},{"$f":"IF(K$16>0,$E73/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"FARM OPERATING CASH SURPLUS\n(Total cash income minus farm working expenses)",null,null,{"$f":"Cashflow!R63","v":0},null,{"$f":"IF(G$16>0,$E75/G$16,0)","v":0},{"$f":"IF(H$16>0,$E75/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E75/J$16,0)","v":0},{"$f":"IF(K$16>0,$E75/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Interest (Total)",null,null,{"$f":"SUM(Cashflow!R65:R67)","v":0},null,{"$f":"IF(G$16>0,$E77/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E77/J$16,0)","v":0},0]
[null,"Hire purchases",null,null,{"$f":"Cashflow!R68","v":0},null,{"$f":"IF(G$16>0,$E78/G$16,0)","v":0},0,0,0,0]
[null,"Leases",null,null,{"$f":"Cashflow!R69","v":0},null,{"$f":"IF(G$16>0,$E79/G$16,0)","v":0},0,0,0,0]
[null,"FINANCE COSTS",null,null,{"$f":"Cashflow!R70","v":0},null,{"$f":"IF(G$16>0,$E80/G$16,0)","v":0},{"$f":"IF(H$16>0,$E80/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E80/J$16,0)","v":0},{"$f":"IF(K$16>0,$E80/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Loan principal repayments (Total)",null,null,{"$f":"SUM(Cashflow!R71:R73)","v":0},null,{"$f":"IF(G$16>0,$E82/G$16,0)","v":0},{"$f":"IF(H$16>0,$E82/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E82/J$16,0)","v":0},0]
[null,"Livestock purchases",null,null,{"$f":"Cashflow!R74","v":0},null,null,null,null,0,0]
[null,"Other capital purchases",null,null,{"$f":"Cashflow!R75","v":0},null,{"$f":"IF(G$16>0,$E84/G$16,0)","v":0},{"$f":"IF(H$16>0,$E84/H$16,0)","v":0},{"$f":"IF(E$32>0,$E84/E$32,0)","v":0},0,0]
[null,"Capital sales/Capital introduced/FMDs",null,null,{"$f":"Cashflow!R76","v":0},null,{"$f":"IF(G$16>0,$E85/G$16,0)","v":0},0,0,0,0]
[null,"Unpaid bills",null,null,{"$f":"Cashflow!R77","v":0},null,{"$f":"IF(G$16>0,$E86/G$16,0)","v":0},0,0,0,0]
[null,"CAPITAL TRANSACTIONS",null,null,{"$f":"Cashflow!R78","v":0},null,{"$f":"IF(G$16>0,$E87/G$16,0)","v":0},{"$f":"IF(H$16>0,$E87/H$16,0)","v":0},{"$f":"IF(E$32>0,$E87/E$32,0)","v":0},{"$f":"IF(J$16>0,$E87/J$16,0)","v":0},{"$f":"IF(K$16>0,$E87/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"NET FARM CASH FLOW",null,null,{"$f":"Cashflow!R80","v":0},null,{"$f":"IF(G$16>0,$E89/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E89/J$16,0)","v":0},{"$f":"IF(K$16>0,$E89/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Non farm income",null,null,{"$f":"Cashflow!R81","v":0},null,{"$f":"IF(G$16>0,$E91/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E91/J$16,0)","v":0},0]
[null,"Non farm expenses/drawings",null,null,{"$f":"Cashflow!R82","v":0},null,{"$f":"IF(G$16>0,$E92/G$16,0)","v":0},0,0,0,0]
[null,"GST (Monthly estimate)",null,null,{"$f":"Cashflow!R83","v":0},null,{"$f":"IF(G$16>0,$E93/G$16,0)","v":0},0,0,0,0]
[null,"Tax",null,null,{"$f":"Cashflow!R84","v":0},null,{"$f":"IF(G$16>0,$E94/G$16,0)","v":0},0,0,0,0]
[null,"Net non farm income and tax",null,null,{"$f":"Cashflow!R85","v":0},null,{"$f":"IF(G$16>0,$E95/G$16,0)","v":0},{"$f":"IF(H$16>0,$E95/H$16,0)","v":0},0,{"$f":"IF(J$16>0,$E95/J$16,0)","v":0},{"$f":"IF(K$16>0,$E95/K$16,0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,"Net Cash Flow Total",null,null,{"$f":"Cashflow!R87","v":0},null,{"$f":"IF(G$16>0,$E97/G$16,0)","v":0},0,0,{"$f":"IF(J$16>0,$E97/J$16,0)","v":0},{"$f":"IF(K$16>0,$E97/K$16,0)","v":0}]

{"sheet":"Standard chart of accounts","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DairyBase Import","index":4,"n_rows":229,"n_cols":40,"rows_kept":229,"cut":false,"hidden":true,"merged":[[4,38,4,39],[5,38,5,39],[12,38,12,39],[4,33,4,34],[5,33,5,34],[10,33,10,34],[10,18,10,19],[10,23,10,24],[10,28,10,29],[4,18,4,19],[4,23,4,24],[4,28,4,29],[5,18,5,19],[5,23,5,24],[5,28,5,29]]}
["Last Import Format:",1,null,"Ranges",null,"Ranges 1",null,"Ranges 2",null,"Ranges 3",null,"Ranges 4",null,"Ranges 5",null,null,null,"DairyBase Farm Data Output Report",null,"Version 2.8 April 6 2016",null,null,"DairyBase Farm Data Output Report",null,"Version 2.10 February 2 2017",null,null,"DairyBase Farm Data Output Report",null,"Version 3.5 May 24 2017",null,null,"DairyBase Farm Data Output Report",null,"Version 3.6 December 1 2017",null,null,"DairyBase Farm Data Output Report",null,"Version 3.7 April 23 2018"]
[null,null,null,"R1","R2","R1","R2","R1","R2","R1","R2","R1","R2","R1","R2"]
["Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Dataset Details",null,null,null,null,"Farm Dataset Details",null,null,null,null,"Farm Dataset Details",null,null,null,null,"Farm Dataset Details",null,null,null,null,"Farm Dataset Details"]
["Milk production (litres)",{"$f":"IF(E4=0,INDIRECT(D4),SUM(INDIRECT(D4),INDIRECT(E4)))","v":1504062},null,{"$f":"OFFSET(D4,0,$B$1*2)","v":"T26"},0,"T26",null,"Y26",null,"AD26",null,"AI62",null,"AN64"]
["Cows milked",260,null,"T20",0,"T20",null,"Y20",null,"AD20",null,"AI56",null,"AN58",null,null,null,"Name","Example Farm 13/14",null,null,null,"Name","DR 300 cows",null,null,null,"Name","DR 260 cows",null,null,null,"Name","DR 260 cows",null,null,null,"Name","Default 1"]
["Fat %",4.5400000000000003E-2,null,"T30",0,"T30",null,"Y30",null,"AD30",null,"AI66",null,"AN68",null,null,null,"Description",null,null,null,null,"Description",null,null,null,null,"Description",null,null,null,null,"Description",null,null,null,null,"Description"]
["Protein %",3.4700000000000002E-2,null,"T31",0,"T31",null,"Y31",null,"AD31",null,"AI67",null,"AN69",null,null,null,"DairyBase Farm Id","DA0001",null,null,null,"DairyBase Farm Id","DA0001",null,null,null,"DairyBase Farm Id","DA0001",null,null,null,"DairyBase Farm Id","DA0001",null,null,null,"DairyBase Farm Id","DA0001"]
["Milking area (ha)",110,null,"T16",0,"T16",null,"Y16",null,"AD16",null,"AI52",null,"AN54",null,null,null,"Financial Year","13/14",null,null,null,"Financial Year","16/17",null,null,null,"Financial Year","16/17",null,null,null,"Financial Year","16/17",null,null,null,"Region","Gippsland"]
["Total area (ha)",137,null,"T15",0,"T15",null,"Y15",null,"AD15",null,"AI51",null,"AN53",null,null,null,"Privacy Setting","Public Access",null,null,null,"Privacy Setting","Group Comparison",null,null,null,"Privacy Setting","Group Comparison",null,null,null,"Privacy Setting","Group Comparison",null,null,null,"State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dataset Type","Created Scenario",null,null,null,"Dataset Type","Created Scenario",null,null,null,"Dataset Type","Created Scenario",null,null,null,"Dataset Type","Created Scenario",null,null,null,"Financial Year","17/18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dataset Notes",null,null,null,null,"Dataset Notes",null,null,null,null,"Dataset Notes",null,null,null,null,"Dataset Notes",null,null,null,null,"Privacy Setting","Group Comparison"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dataset Type","Created Scenario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physical Report",null,null,null,null,"Physical Report",null,null,null,null,"Physical Report",null,null,null,null,"Farm Business Summary",null,null,null,null,"Dataset Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Area",null,null,null,null,"Farm Area",null,null,null,null,"Farm Area",null,null,null,null,"Physical Parameters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usable Area","ha",137,null,null,"Usable Area","ha",150,null,null,"Usable Area","ha",150,null,null,"Usable Area","ha",150,null,null,"Farm Business Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milking Area","ha",110,null,null,"Milking Area","ha",100,null,null,"Milking Area","ha",100,null,null,"Milking Area","ha",100,null,null,"Physical Parameters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leased Area","ha",72,null,null,"Leased Area","ha",0,null,null,"Leased Area","ha",0,null,null,"Cows Milked","Number",260,null,null,"Usable Area","ha",137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigated Area","ha",10,null,null,"Irrigated Area","ha",0,null,null,"Irrigated Area","ha",0,null,null,"Annual Stocking Rate","Milking cows / Milking ha",2.6,null,null,"Milking Area","ha",110]
["Milk income (Current year)",{"$f":"IF(E19=0,INDIRECT(D19),SUM(INDIRECT(D19),INDIRECT(E19)))","v":846454},null,{"$f":"OFFSET(D19,0,$B$1*2)","v":"T119"},{"$f":"OFFSET(E19,0,$B$1*2)","v":0},"T119",null,"Y119",null,"AD121",null,"AI106",null,"AN111",null,null,null,"Livestock",null,null,null,null,"Livestock",null,null,null,null,"Livestock",null,null,null,null,"Milk Production - Litres","Total Litres",1768000,null,null,"Cows Milked","Number",177.91666666666666]
["Milk income (Retrospective/Step ups)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cows Milked","Number",260,null,null,"Cows Milked","Number",300,null,null,"Cows Milked","Number",260,null,null,"Milk Production - Kg Milksolids","Total Milksolids",132600,null,null,"Annual Stocking Rate","Milking cows / Milking ha",1.6174242424242424]
["Livestock Sales",{"$f":"IF(E21=0,INDIRECT(D21),SUM(INDIRECT(D21),INDIRECT(E21)))","v":45000},null,{"$f":"OFFSET(D21,0,$B$1*2)","v":"T70"},0,"T70",null,"Y71",null,"AD71",null,"AI107",null,"AN112",null,null,null,"Annual Stocking Rate","Milking cows / Milking ha",2.3636363636363638,null,null,"Annual Stocking Rate","Milking cows / Milking ha",3,null,null,"Annual Stocking Rate","Milking cows / Milking ha",2.6,null,null,"Homegrown Feed - Milking Area","t DM / Milking ha",9.1133174114090654,null,null,"Milk Production - Litres","Total Litres",1504062]
["Feed and water sales",0,null,"T71",0,"T71",null,"Y72",null,"AD72","AD73","AI108","AI109","AN113","AN114",null,null,"Annual Stocking Rate","Milking cows / Usable ha",1.8978102189781021,null,null,"Annual Stocking Rate","Milking cows / Usable ha",2,null,null,"Annual Stocking Rate","Milking cows / Usable ha",1.7333333333333334,null,null,"Homegrown Feed - Usable Area","t DM / Usable ha",8.3287712767048205,null,null,"Milk Production - Kg Milksolids","Total Milksolids",120522]
["Other farm income",11000,null,"T72",0,"T72",null,"Y73",null,"AD74",null,"AI110",null,"AN115",null,null,null,"Cow Liveweight","kgs  ",520,null,null,"Cow Liveweight","kgs  ",550,null,null,"Cow Liveweight","kgs  ",550,null,null,"Proportion of Homegrown Feed","% of Diet",0.67868059459144214,null,null,"Homegrown Feed - Milking Area","t DM / Milking ha",9.5972068000418194]
["TOTAL CASH INCOME",902454,null,"T73",0,"T73",null,"Y74",null,"AD75",null,"AI111",null,"AN116",null,null,null,"Cow Liveweight per Hectare","kgs / Milking ha",1229.090909090909,null,null,"Cow Liveweight per Hectare","kgs / Milking ha",1650,null,null,"Cow Liveweight per Hectare","kgs / Milking ha",1430,null,null,"Cows per Labour Unit","Milking cows / FTE",100.3861003861004,null,null,"Homegrown Feed - Usable Area","t DM / Usable ha",10.082361517772934]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milk Production",null,"Quantity",null,null,"Milk Production",null,"Quantity",null,null,"Milk Production",null,"Quantity",null,null,null,null,null,null,null,"Proportion of Homegrown Feed","% of Diet",0.83285103710148956]
["AI and herd test ",{"$f":"IF(E26=0,INDIRECT(D26),SUM(INDIRECT(D26),INDIRECT(E26)))","v":11066},null,{"$f":"OFFSET(D26,0,$B$1*2)","v":"T75"},0,"T75",null,"Y76",null,"AD77",null,"AI113",null,"AN118",null,null,null,"Litres","Litres",1504062,null,null,"Litres","Litres",2100000,null,null,"Litres","Litres",1768000,null,null,null,null,"Total",null,null,"Cows per Labour Unit","Milking cows / FTE",65.895061728395049]
["Animal health",16687,null,"T76",0,"T76",null,"Y77",null,"AD78",null,"AI114",null,"AN119",null,null,null,"Fat","kg",68264,null,null,"Fat","kg",90300,null,null,"Fat","kg",76024,null,null,"Cash",null,"($)"]
["Calf rearing",3146,null,"T77",0,"T77",null,"Y78",null,"AD79",null,"AI115",null,"AN120",null,null,null,"Protein","kg",52258,null,null,"Protein","kg",67200,null,null,"Protein","kg",56576,null,null,"Milk Income",null,737256,null,null,null,null,"Total"]
["Other herd costs",null,null,"T78",0,"T78",null,"Y79",null,"AD80",null,"AI116",null,"AN121",null,null,null,"Milksolids","kg",120522,null,null,"Milksolids","kg",157500,null,null,"Milksolids","kg",132600,null,null,"Total Farm Cash Income",null,779756,null,null,"Cash",null,"($)"]
["Total herd costs",30899,null,"T79",0,"T79",null,"Y80",null,"AD81",null,"AI117",null,"AN122",null,null,null,"Fat %","% w/v",4.5400000000000003E-2,null,null,"Fat %","% w/v",4.2999999999999997E-2,null,null,"Fat %","% w/v",4.2999999999999997E-2,null,null,"Total Farm Working Expenses",null,516693,null,null,"Milk Income",null,636454]
["Shed power",12000,null,"T80",0,"T80",null,"Y81",null,"AD82",null,"AI118",null,"AN123",null,null,null,"Protein %","% w/v",3.4700000000000002E-2,null,null,"Protein %","% w/v",3.2000000000000001E-2,null,null,"Protein %","% w/v",3.2000000000000001E-2,null,null,"Farm Operating Cash Surplus",null,263063,null,null,"Total Farm Cash Income",null,671454]
["Dairy supplies",9858,null,"T81",0,"T81",null,"Y82",null,"AD83",null,"AI119",null,"AN124",null,null,null,"Milksolids as % of Cow Liveweight","kg MS / Cow Liveweight",0.89143491124260354,null,null,"Milksolids as % of Cow Liveweight","kg MS / Cow Liveweight",0.95454545454545459,null,null,"Milksolids as % of Cow Liveweight","kg MS / Cow Liveweight",0.92727272727272725,null,null,"Finance Costs (Interest & Lease)",null,50000,null,null,"Total Farm Working Expenses",null,396148]
["Other shed costs",null,null,"T82",0,"T82",null,"Y83",null,"AD84",null,"AI120",null,"AN125",null,null,null,"Homegrown Feed Production",null,"Milking Area",null,null,"Homegrown Feed Production",null,"Milking Area",null,null,"Homegrown Feed Production",null,"Milking Area",null,null,"Net Farm Cash Flow Before Tax and Drawings",null,203063,null,null,"Farm Operating Cash Surplus",null,275306]
["Total shed costs",21858,null,"T83",0,"T83",null,"Y84",null,"AD85",null,"AI121",null,"AN126",null,null,null,"Grazed Feed per Hectare","t DM / ha",7.7374420255999681,null,null,"Grazed Feed per Hectare","t DM / ha",8.5668706947676263,null,null,"Grazed Feed per Hectare","t DM / ha",8.1133174114090654,null,null,"Profit",null,null,null,null,"Finance Costs (Interest & Lease)",null,91921]
["Concentrate 1",1167.4944444444445,null,"T47",0,"T47",null,"Y47",null,"AD47",null,"AI83",null,"AN88",null,null,null,"Conserved Feed per Hectare","t DM / ha",2.7272727272727271,null,null,"Conserved Feed per Hectare","t DM / ha",1,null,null,"Conserved Feed per Hectare","t DM / ha",1,null,null,"Total Farm Gross Income",null,779756,null,null,"Net Farm Cash Flow Before Tax and Drawings",null,-66615]
["Concentrate 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Homegrown Feed","t DM / ha",10.464714752872695,null,null,"Total Homegrown Feed","t DM / ha",9.5668706947676263,null,null,"Total Homegrown Feed","t DM / ha",9.1133174114090654,null,null,"Total Variable Costs",null,392693,null,null,"Profit"]
["Concentrate 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grazed and Supplementary Feed (Milking Area)",null,"Quantity",null,null,"Grazed and Supplementary Feed (Milking Area)",null,"Quantity",null,null,"Grazed and Supplementary Feed (Milking Area)",null,"Quantity",null,null,"Total Overhead Costs",null,272252.609765,null,null,"Total Farm Gross Income",null,667854]
["Purchased fodder 1",{"$f":"IF(E38=0,INDIRECT(D38),SUM(INDIRECT(D38),INDIRECT(E38)))","v":{"$error":"#REF!"}},null,{"$f":"OFFSET(D38,0,$B$1*2)","v":0},{"$f":"OFFSET(E38,0,$B$1*2)","v":0},null,null,"Y48",null,"AD48",null,"AI84",null,"AN89",null,null,null,"Grazed Feed Fed","t DM",851.11862281599645,null,null,"Grazed Feed Fed","t DM",856.68706947676264,null,null,"Grazed Feed Fed","t DM",811.33174114090662,null,null,"Cost of Production (includes inventory changes)",null,664945.60976499994,null,null,"Total Variable Costs",null,235781]
["Purchased fodder 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fodder Fed","t DM",180,null,null,"Fodder Fed","t DM",455,null,null,"Fodder Fed","t DM",275,null,null,"Total Costs",null,664945.60976499994,null,null,"Total Overhead Costs",null,263827.46019999997]
["Other puchased feeds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concentrates & Other Fed","t DM",312,null,null,"Concentrates & Other Fed","t DM",600,null,null,"Concentrates & Other Fed","t DM",494,null,null,"Earnings Before Interest and Tax (EBIT)",null,114810.39023500006,null,null,"Cost of Production (includes inventory changes)",null,513208.46019999997]
["Agistment",{"$f":"IF(E41=0,INDIRECT(D41),SUM(INDIRECT(D41),INDIRECT(E41)))","v":18000},null,{"$f":"OFFSET(D41,0,$B$1*2)","v":"T86"},0,"T86",null,"Y87",null,"AD88",null,"AI124",null,"AN129",null,null,null,"Total Feed Fed","t DM",1343.1186228159963,null,null,"Total Feed Fed","t DM",1911.6870694767626,null,null,"Total Feed Fed","t DM",1580.3317411409066,null,null,"Finance Costs (Interest & Lease)",null,50000,null,null,"Total Costs",null,499608.46019999997]
["Other feed costs",{"$f":"IF(E42=0,INDIRECT(D42),SUM(INDIRECT(D42),INDIRECT(E42)))","v":0},null,{"$f":"OFFSET(D42,0,$B$1*2)","v":"T91"},{"$f":"OFFSET(E42,0,$B$1*2)","v":0},"T91",null,"Y92",null,"AD94",null,"AI130",null,"AN135",null,null,null,"[1] % of Cow Diet is based on the % of Feed Energy Fed",null,null,null,null,"[1] % of Cow Diet is based on the % of Feed Energy Fed",null,null,null,null,"[1] % of Cow Diet is based on the % of Feed Energy Fed",null,null,null,null,"Net Farm Income",null,64810.390235000057,null,null,"Earnings Before Interest and Tax (EBIT)",null,168245.53980000003]
["Total purchased feed costs",{"$f":"IF(E43=0,INDIRECT(D43)+B42+B41,)","v":247595},null,"T84",0,"T84",null,"Y85",null,"AD86",null,"AI122",null,"AN127",null,null,null,"Feed Costs",null,null,null,null,"Feed Costs",null,null,null,null,"Feed Costs",null,null,null,null,"Wealth",null,null,null,null,"Finance Costs (Interest & Lease)",null,91921]
["Hay and silage making",{"$f":"IF(E44=0,INDIRECT(D44),SUM(INDIRECT(D44),INDIRECT(E44)))","v":18545},null,"T85",0,"T85",null,"Y86",null,"AD87",null,"AI123",null,"AN128",null,null,null,"Homegrown Feed - Direct Costs","$ / t DM",72.658321894986315,null,null,"Homegrown Feed - Direct Costs","$ / t DM",101.28434113451351,null,null,"Homegrown Feed - Direct Costs","$ / t DM",93.651269087148918,null,null,"Return on Total Assets (ROTA)",null,4.1932209727903604E-2,null,null,"Net Farm Income",null,76324.539800000028]
["PKS Fertiliser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grazed Feed - Direct Costs","$ / t DM",59.865562260483749,null,null,"Grazed Feed - Direct Costs","$ / t DM",79.692718024442797,null,null,"Grazed Feed - Direct Costs","$ / t DM",71.639218660682289,null,null,"Equity as % of Owned Assets",null,0.63476990504017528,null,null,"Wealth"]
["Nitrogen",{"$f":"IF(E46=0,INDIRECT(D46),SUM(INDIRECT(D46),INDIRECT(E46)))","v":32910},null,{"$f":"OFFSET(D46,0,$B$1*2)","v":"T87"},{"$f":"OFFSET(E46,0,$B$1*2)","v":0},"T87",null,"Y88",null,"AD89",null,"AI125",null,"AN130",null,null,null,"Conserved Feed - Direct Costs","$ / t DM",93.583744078665575,null,null,"Conserved Feed - Direct Costs","$ / t DM",158.26414659587135,null,null,"Conserved Feed - Direct Costs","$ / t DM",150.21064723211086,null,null,"Return on Equity (ROE)",null,3.7290213023590368E-2,null,null,"Return on Total Assets (ROTA)",null,3.4798275779871754E-2]
["Lime & Gypsum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concentrate Purchased - Direct Costs","$ / t DM ",1167.4944444444445,null,null,"Concentrate Purchased - Direct Costs","$ / t DM ",400,null,null,"Concentrate Purchased - Direct Costs","$ / t DM ",400,null,null,"Change in Net Worth",null,0,null,null,"Equity as % of Owned Assets",null,0.80546074726996097]
["Irrigation",{"$f":"IF(E48=0,INDIRECT(D48),SUM(INDIRECT(D48),INDIRECT(E48)))","v":30687},null,{"$f":"OFFSET(D48,0,$B$1*2)","v":"T88"},0,"T88",null,"Y89",null,"AD90","AD91","AI126","AI127","AN131","AN132",null,null,"Fertiliser Application",null,null,null,null,"Fodder Purchased - Direct Costs","$ / t DM ",233.57142857142858,null,null,"Fodder Purchased - Direct Costs","$ / t DM ",150,null,null,null,null,null,null,null,"Return on Equity (ROE)",null,2.4871864659743028E-2]
["Pasture and cropping",13593,null,"T89",0,"T89",null,"Y90",null,"AD92",null,"AI128",null,"AN133",null,null,null,"Nitrogen Applied","kgs N / Milking ha",83.636363636363654,null,null,"Fertiliser Application",null,null,null,null,"Fertiliser Application",null,null,null,null,"Physical Report",null,null,null,null,"Change in Net Worth",null,-12320]
["Fuel and oil",9594,null,"T90",0,"T90",null,"Y91",null,"AD93",null,"AI129",null,"AN134",null,null,null,"Nitrogen Applied","kgs N / Usable ha",83.941605839416056,null,null,"Nitrogen Applied","kgs N / Milking ha",276,null,null,"Nitrogen Applied","kgs N / Milking ha",230,null,null,"Farm Area"]
["Total home grown feed costs",{"$f":"IF(E51=0,INDIRECT(D51)-B43,SUM(INDIRECT(D51),INDIRECT(E51)))","v":105329},null,"T92",0,"T92",null,"Y93",null,"AD95",null,"AI131",null,"AN136",null,null,null,"Labour and Management",null,null,null,null,"Nitrogen Applied","kgs N / Usable ha",276,null,null,"Nitrogen Applied","kgs N / Usable ha",214.66666666666669,null,null,"Usable Area","ha",150,null,null,"Physical Report"]
["VARIABLE COSTS",396781,null,"T93",0,"T93",null,"Y94",null,"AD96",null,"AI132",null,"AN137",null,null,null,"Employed Labour","FTE",1,null,null,"Labour and Management",null,null,null,null,"Labour and Management",null,null,null,null,"Milking Area","ha",100,null,null,"Farm Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imputed Labour","FTE",3,null,null,"Employed Labour","FTE",1.4,null,null,"Employed Labour","FTE",1,null,null,"Leased Area","ha",0,null,null,"Usable Area","ha",137]
["Employed labour costs",{"$f":"IF(E54=0,INDIRECT(D54),SUM(INDIRECT(D54),INDIRECT(E54)))","v":90000},null,{"$f":"OFFSET(D54,0,$B$1*2)","v":"T95"},0,"T95",null,"Y96",null,"AD98",null,"AI134",null,"AN139",null,null,null,"Cows Milked per Labour Unit","Cows / FTE",65,null,null,"Imputed Labour","FTE",1.59,null,null,"Imputed Labour","FTE",1.59,null,null,"Irrigated Area","ha",0,null,null,"Milking Area","ha",110]
["Repairs and maintenance",20610,null,"T96",0,"T96",null,"Y97",null,"AD99",null,"AI135",null,"AN141",null,null,null,"Milksolids per Labour Unit","kg MS / FTE",30130.5,null,null,"Cows Milked per Labour Unit","Cows / FTE",100.3344481605351,null,null,"Cows Milked per Labour Unit","Cows / FTE",100.3861003861004,null,null,"Livestock",null,null,null,null,"Leased Area","ha",72]
["Vehicles (Rego and insurance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainfall and Irrigation",null,null,null,null,"Milksolids per Labour Unit","kg MS / FTE",52675.585284280933,null,null,"Milksolids per Labour Unit","kg MS / FTE",51196.911196911198,null,null,"Cows Milked","Number",260,null,null,"Irrigated Area","ha",10]
["Farm insurance",{"$error":"#REF!"},null,{"$f":"OFFSET(D57,0,$B$1*2)","v":0},0,null,null,null,null,null,null,null,null,"AN140",null,null,null,"Area of Farm Irrigated ","ha",10,null,null,"Rainfall and Irrigation",null,null,null,null,"Rainfall and Irrigation",null,null,null,null,"Annual Stocking Rate","Milking cows / Milking ha",2.6,null,null,"Livestock"]
["Other overheads (Rates/insurance/etc)",{"$f":"IF(E58=0,INDIRECT(D58),SUM(INDIRECT(D58),INDIRECT(E58)))","v":20857},null,"T97",0,"T97",null,"Y98",null,"AD100",null,"AI136",null,"AN142",null,null,null,"Annual Water Use","Megalitres",400,null,null,"Area of Farm Irrigated ","ha",0,null,null,"Area of Farm Irrigated ","ha",0,null,null,"Annual Stocking Rate","Milking cows / Usable ha",1.7333333333333334,null,null,"Cows Milked","Number",177.91666666666666]
["OVERHEAD COSTS",131467,null,"T98",0,"T98",null,"Y99",null,"AD101",null,"AI137",null,"AN143",null,null,null,"ML Irrigation/ Irrigated ha","Megalitres / Irrigated ha",40,null,null,"Annual Water Use","Megalitres",0,null,null,"Annual Water Use","Megalitres",0,null,null,"Cow Liveweight","kgs  ",550,null,null,"Annual Stocking Rate","Milking cows / Milking ha",1.6174242424242424]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rainfall","mm / annum",650,null,null,"ML Irrigation/ Irrigated ha","Megalitres / Irrigated ha",0,null,null,"ML Irrigation/ Irrigated ha","Megalitres / Irrigated ha",0,null,null,"Cow Liveweight per Hectare","kgs / Milking ha",1430,null,null,"Annual Stocking Rate","Milking cows / Usable ha",1.2986618004866179]
["FARM WORKING EXPENSES (FWE)\n(Variable plus Cash Overhead Costs)",{"$f":"IF(E61=0,INDIRECT(D61),SUM(INDIRECT(D61),INDIRECT(E61)))","v":528248},null,{"$f":"OFFSET(D61,0,$B$1*2)","v":"T99"},{"$f":"OFFSET(E61,0,$B$1*2)","v":0},"T99",null,"Y100",null,"AD102",null,"AI138",null,"AN144",null,null,null,"Total Water Use / Irrigated ha","mm / Iirrigated ha",4650,null,null,"Annual Rainfall","mm / annum",900,null,null,"Annual Rainfall","mm / annum",900,null,null,"Milk Production",null,"Quantity",null,null,"Cow Liveweight","kgs  ",520]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homegrown Feed / 100 mm / Usable ha","t DM/ 100 mm / Usable ha",1.1233228389104046,null,null,"Total Water Use / Irrigated ha","mm / Iirrigated ha",0,null,null,"Total Water Use / Irrigated ha","mm / Iirrigated ha",0,null,null,"Litres","Litres",1768000,null,null,"Cow Liveweight per Hectare","kgs / Milking ha",841.06060606060601]
["FARM OPERATING CASH SURPLUS\n(Total Cash Income minus Farm Working Expenses)",{"$f":"IF(E63=0,INDIRECT(D63),SUM(INDIRECT(D63),INDIRECT(E63)))","v":374206},null,{"$f":"OFFSET(D63,0,$B$1*2)","v":"T100"},{"$f":"OFFSET(E63,0,$B$1*2)","v":0},"T100",null,"Y101",null,"AD103",null,"AI139",null,"AN145",null,null,null,"Water Use Efficiency","t DM / Megalitre",3.6241203090346925,null,null,"Homegrown Feed / 100 mm / Usable ha","t DM/ 100 mm / Usable ha",0.9434385857202775,null,null,"Homegrown Feed / 100 mm / Usable ha","t DM/ 100 mm / Usable ha",0.92541903074498022,null,null,"Fat","kg",76024,null,null,"Milk Production",null,"Quantity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Use Efficiency","t DM / Megalitre",null,null,null,"Water Use Efficiency","t DM / Megalitre",null,null,null,"Protein","kg",56576,null,null,"Litres","Litres",1504062]
["Interest loan 1",{"$f":"IF(E65=0,INDIRECT(D65),SUM(INDIRECT(D65),INDIRECT(E65)))","v":35687},null,{"$f":"OFFSET(D65,0,$B$1*2)","v":"T147"},{"$f":"OFFSET(E65,0,$B$1*2)","v":0},"T147",null,"Y147",null,"AD149",null,"AI185",null,"AN193",null,null,null,"Cash Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milksolids","kg",132600,null,null,"Fat","kg",68264]
["Interest loan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Report",null,null,null,null,"Cash Report",null,null,null,null,"Fat %","% w/v",4.2999999999999997E-2,null,null,"Protein","kg",52258]
["Interest loan 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,"Protein %","% w/v",3.2000000000000001E-2,null,null,"Milksolids","kg",120522]
["Hire purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Cash Income",null,"($)",null,null,null,null,"Total",null,null,null,null,"Total",null,null,"Milksolids as % of Cow Liveweight","kg MS / Cow Liveweight",0.92727272727272725,null,null,"Fat %","% w/v",4.5400000000000003E-2]
["Leases",{"$f":"IF(E69=0,INDIRECT(D69),SUM(INDIRECT(D69),INDIRECT(E69)))","v":56234},null,{"$f":"OFFSET(D69,0,$B$1*2)","v":"T148"},0,"T148",null,"Y148",null,"AD150",null,"AI186",null,"AN194",null,null,null,"Milk Income (net)",null,846454,null,null,"Farm Cash Income",null,"($)",null,null,"Farm Cash Income",null,"($)",null,null,"Homegrown Feed Production",null,"Milking Area",null,null,"Protein %","% w/v",3.4700000000000002E-2]
["Finance costs",{"$f":"IF(E70=0,INDIRECT(D70),SUM(INDIRECT(D70),INDIRECT(E70)))","v":91921},null,"T104",0,"T104",null,"Y105",null,"AD151",null,"AI187",null,"AN195",null,null,null,"Livestock sales",null,45000,null,null,"Milk Income (net)",null,875700,null,null,"Milk Income (net)",null,737256,null,null,"Grazed Feed per Hectare","t DM / ha",8.1133174114090654,null,null,"Milksolids as % of Cow Liveweight","kg MS / Cow Liveweight",1.3027058187713927]
["Principal repayments loan 1",{"$f":"IF(E71=0,INDIRECT(D71),SUM(INDIRECT(D71),INDIRECT(E71)))","v":150000},null,"T108",0,"T108",null,"Y108",null,"AD110",null,"AI146",null,"AN152",null,null,null,"Feed Sales",null,0,null,37500,"Livestock sales - purchases",null,37500,null,32500,"Livestock sales - purchases",null,32500,null,null,"Conserved Feed per Hectare","t DM / ha",1,null,null,"Homegrown Feed Production",null,"Milking Area"]
["Principal repayments loan 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Farm Cash Income",null,11000,null,null,"Feed Sales",null,0,null,null,"Feed Sales",null,0,null,null,"Total Homegrown Feed","t DM / ha",9.1133174114090654,null,null,"Grazed Feed per Hectare","t DM / ha",6.8699340727690927]
["Principal repayments loan 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Farm Cash Income",null,902454,null,null,"Other Farm Cash Income",null,10000,null,null,"Water Sales",null,0,null,null,"Grazed and Supplementary Feed (Milking Area)",null,"Quantity",null,null,"Conserved Feed per Hectare","t DM / ha",2.7272727272727271]
["Livestock purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Costs",null,null,null,null,"Total Farm Cash Income",null,923200,null,null,"Other Farm Cash Income",null,10000,null,null,"Grazed Feed Fed","t DM",811.33174114090662,null,null,"Total Homegrown Feed","t DM / ha",9.5972068000418194]
["Other capital purchases",{"$f":"IF(E75=0,INDIRECT(D75),SUM(INDIRECT(D75),INDIRECT(E75)))","v":25000},null,{"$f":"OFFSET(D75,0,$B$1*2)","v":"T107"},{"$f":"OFFSET(E75,0,$B$1*2)","v":0},"T107",null,"Y107",null,"AD109",null,"AI145",null,"AN151",null,null,null,"AI & Herd Test",null,11066,null,null,"Variable Costs",null,null,null,null,"Total Farm Cash Income",null,779756,null,null,"Fodder Fed","t DM",275,null,null,"Grazed and Supplementary Feed (Milking Area)",null,"Quantity"]
["Capital sales/Farm man.deposits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Animal Health",null,16687,null,null,"AI & Herd Test",null,18000,null,null,"Variable Costs",null,null,null,null,"Concentrates & Other Fed","t DM",494,null,null,"Grazed Feed Fed","t DM",755.69274800460016]
["Unpaid bills (60+ days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calf Rearing",null,3146,null,null,"Animal Health",null,19500,null,null,"AI & Herd Test",null,15600,null,null,"Total Feed Fed","t DM",1580.3317411409066,null,null,"Homegrown Fodder Fed","t DM"]
["Capital Transactions",{"$f":"IF(E78=0,INDIRECT(D78),SUM(INDIRECT(D78),INDIRECT(E78)))","v":275000},null,{"$f":"OFFSET(D78,0,$B$1*2)","v":"T109"},{"$f":"OFFSET(E78,0,$B$1*2)","v":0},"T109",null,"Y109",null,"AD111",null,"AI147",null,"AN153",null,null,null,"Other Herd Costs",null,0,null,null,"Calf Rearing",null,7500,null,null,"Animal Health",null,16900,null,null,"[1] % of Diet is based on the % of Feed Energy Fed",null,null,null,null,"Purchased Fodder Fed","t DM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Herd Costs",null,30899,null,null,"Other Herd Costs",null,0,null,null,"Calf Rearing",null,6500,null,null,"Feed Costs",null,null,null,null,"Homegrown Concentrate Fed","t DM"]
["NET FARM CASH FLOW",{"$f":"IF(E80=0,INDIRECT(D80),SUM(INDIRECT(D80),INDIRECT(E80)))","v":-39744},null,{"$f":"OFFSET(D80,0,$B$1*2)","v":"T114"},0,"T114",null,"Y114",null,"AD116",null,"AI152",null,"AN158",null,null,null,"Shed Power",null,12000,null,null,"Total Herd Costs",null,45000,null,null,"Other Herd Costs",null,0,null,null,"Homegrown Feed - Direct Costs","$ / t DM",93.651269087148918,null,null,"Purchased Concentrate Fed","t DM"]
["Non farm income",{"$f":"IF(E81=0,INDIRECT(D81),SUM(INDIRECT(D81),INDIRECT(E81)))","v":2971},null,"T112",0,"T112",null,"Y112",null,"AD114",null,"AI150",null,"AN156",null,null,null,"Dairy Supplies",null,9858,null,null,"Shed Power",null,17000,null,null,"Total Herd Costs",null,39000,null,null,"Grazed Feed - Direct Costs","$ / t DM",71.639218660682289,null,null,"Other Feed Fed","t DM"]
["Non farm expenses/drawings",50000,null,"T113",0,"T113",null,"Y113",null,"AD115",null,"AI151",null,"AN157",null,null,null,"Other Shed Coss",null,0,null,null,"Dairy Supplies",null,10800,null,null,"Shed Power",null,14733,null,null,"Conserved Feed - Direct Costs","$ / t DM",150.21064723211086,null,null,"Total Feed Fed","t DM",1247.6927480046002]
["GST (Estimate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Shed Costs",null,21858,null,null,"Other Shed Coss",null,0,null,null,"Dairy Supplies",null,9360,null,null,"Concentrate Purchased - Direct Costs","$ / t DM ",400,null,null,"[1] % of Diet is based on the % of Feed Energy Fed"]
["Tax (PAYG)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeds Purchased",19446,229595,null,null,"Total Shed Costs",null,27800,null,null,"Other Shed Coss",null,0,null,null,"Fodder Purchased - Direct Costs","$ / t DM ",150,null,null,"Feed Costs"]
["Net Non Farm Income and Tax",{"$f":"B81-B82","v":-47029},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hay & Silage Making",210149,18545,null,null,"Feeds Purchased",65400,305400,null,null,"Total Shed Costs",null,24093,null,null,"Fertiliser Application",null,null,null,null,"Homegrown Feed - Direct Costs","$ / t DM",60.327223422827778]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agistment",0,18000,null,null,"Hay & Silage Making",240000,27500,null,null,"Feeds Purchased",15000,212600,null,null,"Nitrogen Applied","kgs N / Milking ha",230,null,null,"Grazed Feed - Direct Costs","$ / t DM",54.140948246741864]
["Net monthly cash flow total",{"$f":"B80+B85","v":-86773},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertiliser",null,32910,null,null,"Agistment",0,12000,null,null,"Hay & Silage Making",197600,27500,null,null,"Nitrogen Applied","kgs N / Usable ha",214.66666666666669,null,null,"Conserved Feed - Direct Costs","$ / t DM",69.677311883105503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigation",null,30687,null,null,"Fertiliser",null,79000,null,null,"Agistment",0,0,null,null,"Labour and Management",null,null,null,null,"Concentrate Purchased - Direct Costs","$ / t DM ",611.93888888888887]
["Cumulative cash flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasture & Crop Costs",null,13593,null,null,"Irrigation",null,0,null,null,"Fertiliser",null,67000,null,null,"Employed Labour","FTE",1,null,null,"Fodder Purchased - Direct Costs","$ / t DM ",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel & Oil",null,9594,null,null,"Pasture & Crop Costs",null,9000,null,null,"Water Purchase",0,0,null,null,"Imputed Labour","FTE",1.59,null,null,"Fertiliser Application"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Feed Costs",null,0,null,null,"Fuel & Oil",null,9000,null,null,"Other Irrigation Costs",null,0,null,null,"Cows Milked per Labour Unit","Cows / FTE",100.3861003861004,null,null,"Nitrogen Applied","kgs N / Milking ha",83.636363636363654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Feed Costs",null,352924,null,null,"Other Feed Costs",null,4500,null,null,"Pasture & Crop Costs",null,9000,null,null,"Milksolids per Labour Unit","kg MS / FTE",51196.911196911198,null,null,"Nitrogen Applied","kgs N / Usable ha",83.941605839416056]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable Costs",null,396781,null,null,"Total Feed Costs",null,446400,null,null,"Fuel & Oil",null,9000,null,null,"Rainfall and Irrigation",null,null,null,null,"Labour and Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Overheads",null,null,null,null,"Total Variable Costs",null,519200,null,null,"Other Feed Costs",null,4500,null,null,"Area of Farm Irrigated ","ha",0,null,null,"Employed Labour","FTE",1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employed Labour Cost",3113,90000,null,null,"Cash Overheads",null,null,null,null,"Total Feed Costs",null,329600,null,null,"Annual Water Use","Megalitres",0,null,null,"Imputed Labour","FTE",1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs & Maintenance",8808,20610,null,null,"Employed Labour Cost",8000,70000,null,null,"Total Variable Costs",null,392693,null,null,"ML Irrigation/ Irrigated ha","Megalitres / Irrigated ha",0,null,null,"Cows Milked per Labour Unit","Cows / FTE",65.895061728395049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Overhead Costs",8936,20857,null,null,"Repairs & Maintenance",6000,45000,null,null,"Cash Overheads",null,null,null,null,"Annual Rainfall","mm / annum",900,null,null,"Milksolids per Labour Unit","kg MS / FTE",44637.777777777774]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cash Overhead Costs",null,131467,null,null,"Other Overhead Costs",21000,35000,null,null,"Employed Labour Cost",8000,50000,null,null,"Total Water Use / Irrigated ha","mm / Iirrigated ha",0,null,null,"Rainfall and Irrigation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL FARM WORKING EXPENSES",null,528248,null,null,"Total Cash Overhead Costs",null,150000,null,null,"Repairs & Maintenance",6000,39000,null,null,"Homegrown Feed / 100 mm / Usable ha","t DM/ 100 mm / Usable ha",0.92541903074498022,null,null,"Area of Farm Irrigated ","ha",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FARM OPERATING CASH SURPLUS",null,374206,null,null,"TOTAL FARM WORKING EXPENSES",null,669200,null,null,"Other Overhead Costs",21000,35000,null,null,"Water Use Efficiency","t DM / Megalitre",null,null,null,"Annual Water Use","Megalitres",400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finance Costs",null,null,null,null,"FARM OPERATING CASH SURPLUS",null,254000,null,null,"Total Cash Overhead Costs",null,124000,null,null,null,null,null,null,null,"ML Irrigation/ Irrigated ha","Megalitres / Irrigated ha",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest Costs",null,35687,null,null,"Finance Costs",null,null,null,null,"TOTAL FARM WORKING EXPENSES",null,516693,null,null,"Cash Report",null,null,null,null,"Annual Rainfall","mm / annum",650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease Costs",null,56234,null,null,"Interest Costs",null,50000,null,null,"FARM OPERATING CASH SURPLUS",null,263063,null,null,null,null,null,null,null,"Total Water Use / Irrigated ha","mm / Iirrigated ha",4650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Finance Costs",null,91921,null,null,"Lease Costs",null,0,null,null,"Finance Costs",null,null,null,null,null,null,"Total",null,null,"Total Water Use Efficiency","t DM/ 100 mm / Usable ha",1.0703475613598543]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital and Principal Costs",null,null,null,null,"Total Finance Costs",null,50000,null,null,"Interest Costs",null,50000,null,null,"Farm Cash Income",null,"($)",null,null,"Irrigation Water Use Efficiency","t DM / Megalitre",3.4532088198372297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Purchases",null,100000,null,0,"Capital and Principal Costs",null,null,null,null,"Lease Costs",null,0,null,null,"Milk Income (net)",null,737256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Capital Purchases",null,25000,null,null,"Other Capital Purchases",null,0,null,null,"Total Finance Costs",null,50000,null,32500,"Livestock sales - purchases",null,32500,null,null,"Cash Report"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Principal Repayments",null,150000,null,null,"Loan Principal Repayments",null,10000,null,0,"Capital and Principal Costs",null,null,null,null,"Feed Sales",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Capital and Principal Costs",null,275000,null,null,"Total Capital and Principal Costs",null,10000,null,null,"Other Capital Purchases",null,0,null,null,"Water Sales",null,0,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET FARM CASH FLOW BEFORE TAX AND DRAWINGS",null,7285,null,null,"NET FARM CASH FLOW BEFORE TAX AND DRAWINGS",null,194000,null,null,"Loan Principal Repayments",null,10000,null,null,"Other Farm Cash Income",null,10000,null,null,"Farm Cash Income",null,"($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Cash Items",null,null,null,null,"Other Cash Items",null,null,null,null,"Total Capital and Principal Costs",null,10000,null,null,"Total Farm Cash Income",null,779756,null,null,"Milk Income (net)",null,636454]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Non Farm Cash Income",null,2971,null,null,"Net Non Farm Cash Income",null,0,null,null,"NET FARM CASH FLOW BEFORE TAX AND DRAWINGS",null,203063,null,null,"Variable Costs",null,null,null,45000,"Livestock sales - purchases",null,35000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawings",null,50000,null,null,"Drawings",null,60000,null,null,"Other Cash Items",null,null,null,null,"AI & Herd Test",null,15600,null,null,"Feed Sales",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET CASH FLOW BEFORE TAX",null,-39744,null,null,"NET CASH FLOW BEFORE TAX",null,134000,null,null,"Net Non Farm Cash Income",null,0,null,null,"Animal Health",null,16900,null,null,"Water Sales",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawings",null,60000,null,null,"Calf Rearing",null,6500,null,null,"Other Farm Cash Income",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Profit Report",null,null,null,null,"Profit Report",null,null,null,null,"NET CASH FLOW BEFORE TAX",null,143063,null,null,"Other Herd Costs",null,0,null,null,"Total Farm Cash Income",null,671454]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,"Total",null,null,null,null,null,null,null,"Total Herd Costs",null,39000,null,null,"Variable Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income",null,"($)",null,null,"Income",null,"($)",null,null,"Profit Report",null,null,null,null,"Shed Power",null,14733,null,null,"AI & Herd Test",null,9066]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milk Income (net)",null,846454,null,null,"Milk Income (net)",null,875700,null,null,null,null,"Total",null,null,"Dairy Supplies",null,9360,null,null,"Animal Health",null,13687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Trading Profit",null,105000,null,null,"Livestock Trading Profit",null,37500,null,null,"Income",null,"($)",null,null,"Other Shed Coss",null,0,null,null,"Calf Rearing",null,3146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Sales",null,0,null,null,"Feed Sales",null,0,null,null,"Milk Income (net)",null,737256,null,null,"Total Shed Costs",null,24093,null,null,"Other Herd Costs",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Farm Income",null,11000,null,null,"Other Farm Income",null,10000,null,null,"Livestock Trading Profit",null,32500,null,null,"Feeds Purchased",15000,212600,null,null,"Total Herd Costs",null,25899]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Farm Income",null,962454,null,null,"Gross Farm Income",null,923200,null,null,"Feed & Water Sales",null,0,null,null,"Hay & Silage Making",197600,27500,null,null,"Shed Power",null,9000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Costs",null,null,null,null,"Variable Costs",null,null,null,null,"Other Farm Income",null,10000,null,null,"Agistment",0,0,null,null,"Dairy Supplies",null,6858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Herd Costs",null,30899,null,null,"Herd Costs",null,45000,null,null,"Gross Farm Income",null,779756,null,null,"Fertiliser",null,67000,null,null,"Other Shed Coss",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shed Costs",null,21858,null,null,"Shed Costs",null,27800,null,null,"Variable Costs",null,null,null,null,"Water Purchase",0,0,null,null,"Total Shed Costs",null,15858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homegrown Feed",null,105329,null,null,"Homegrown Feed",null,129000,null,null,"Herd Costs",null,39000,null,null,"Other Irrigation Costs",null,0,null,null,"Feeds Purchased",9446,119595]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchased Feed",null,247595,null,null,"Purchased Feed",null,317400,null,null,"Shed Costs",null,24093,null,null,"Pasture & Crop Costs",null,9000,null,null,"Hay & Silage Making",110149,8545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Inventory Change",null,-8900,null,null,"Feed Inventory Change",null,0,null,null,"Homegrown Feed",null,117000,null,null,"Fuel & Oil",null,9000,null,null,"Agistment",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Costs",null,352924,null,null,"Feed Costs",null,446400,null,null,"Purchased Feed",0,212600,null,null,"Other Feed Costs",null,4500,null,null,"Fertiliser",null,32910]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable Costs",null,396781,null,null,"Total Variable Costs",null,519200,null,null,"Feed & Water Inventory Change",0,0,null,null,"Total Feed Costs",null,329600,null,null,"Water Purchase",30687,30687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GROSS MARGIN",null,565673,null,null,"GROSS MARGIN",null,404000,null,null,"Feed Costs",null,329600,null,null,"Total Variable Costs",null,392693,null,null,"Other Irrigation Costs",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overhead Costs",null,null,null,null,"Overhead Costs",null,null,null,null,"Total Variable Costs",null,392693,null,null,"Cash Overheads",null,null,null,null,"Pasture & Crop Costs",null,3593]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employed Labour Cost",null,90000,null,null,"Employed Labour Cost",null,70000,null,null,"GROSS MARGIN",null,387063,null,null,"Employed Labour Cost",8000,50000,null,null,"Fuel & Oil",null,7594]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repairs & Maintenance",null,20610,null,null,"Repairs & Maintenance",null,45000,null,null,"Overhead Costs",null,null,null,null,"Repairs & Maintenance",6000,39000,null,null,"Other Feed Costs",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Overhead Costs",null,20857,null,null,"Other Overhead Costs",null,35000,null,null,"Employed Labour Cost",null,50000,null,null,"Other Overhead Costs",21000,35000,null,null,"Total Feed Costs",null,202924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imputed Labour Cost",null,214118.77499999999,null,null,"Imputed Labour Cost",null,115752.60976499999,null,null,"Repairs & Maintenance",null,39000,null,null,"Total Cash Overhead Costs",null,124000,null,null,"Total Variable Costs",null,244681]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depreciation",null,15000,null,null,"Depreciation",null,37500,null,null,"Other Overhead Costs",null,35000,null,null,"TOTAL FARM WORKING EXPENSES",null,516693,null,null,"Cash Overheads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Overhead Costs",null,360585.77500000002,null,null,"Total Overhead Costs",null,303252.609765,null,null,"Imputed Labour Cost",null,115752.60976499999,null,null,"FARM OPERATING CASH SURPLUS",null,263063,null,null,"Employed Labour Cost",3113,110000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL OPERATING COST (Variable & Overhead)",null,757366.77500000002,null,null,"TOTAL OPERATING COST (Variable & Overhead)",null,822452.60976499994,null,null,"Depreciation",null,32500,null,null,"Finance Costs",null,null,null,null,"Farm Insurance",null,8808]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EARNINGS BEFORE INTEREST & TAX (EBIT)",null,205087.22499999998,null,null,"EARNINGS BEFORE INTEREST & TAX (EBIT)",null,100747.39023500006,null,null,"Total Overhead Costs",null,272252.609765,null,null,"Interest Costs",null,50000,null,null,"Repairs & Maintenance",0,20610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,766266.77500000002,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,822452.60976499994,null,null,"TOTAL OPERATING COST (Variable & Overhead)",null,664945.60976499994,null,null,"Lease Costs",null,0,null,null,"Other Overhead Costs",8936,12049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Inventory Change less Purchases",null,-60000,null,null,"Livestock Inventory Change less Purchases",null,0,null,null,"EARNINGS BEFORE INTEREST & TAX (EBIT)",null,114810.39023500006,null,null,"Total Finance Costs",null,50000,null,null,"Total Cash Overhead Costs",null,151467]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Inventory Change",null,-8900,null,null,"Feed Inventory Change",null,0,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,664945.60976499994,null,0,"Capital and Principal Costs",null,null,null,null,"TOTAL FARM WORKING EXPENSES",null,396148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,697366.77500000002,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,822452.60976499994,null,null,"Livestock Inventory Change less Purchases",null,0,null,null,"Other Capital Purchases",null,0,null,null,"FARM OPERATING CASH SURPLUS",null,275306]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finance Costs",null,null,null,null,"Finance Costs",null,null,null,null,"Feed & Water Inventory Change",null,0,null,null,"Loan Principal Repayments",null,10000,null,null,"Finance Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest Costs",null,35687,null,null,"Interest Costs",null,50000,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,664945.60976499994,null,null,"Total Capital and Principal Costs",null,10000,null,null,"Interest Costs",null,35687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease Costs",null,56234,null,null,"Lease Costs",null,0,null,null,"Finance Costs",null,null,null,null,"NET FARM CASH FLOW BEFORE TAX AND DRAWINGS",null,203063,null,null,"Lease Costs",null,56234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Finance Costs",null,91921,null,null,"Total Finance Costs",null,50000,null,null,"Interest Costs",null,50000,null,null,"Other Cash Items",null,null,null,null,"Total Finance Costs",null,91921]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET FARM INCOME",null,113166.22499999998,null,null,"NET FARM INCOME",null,50747.390235000057,null,null,"Lease Costs",null,0,null,null,"Net Non Farm Cash Income",null,0,null,10000,"Capital and Principal Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Finance Costs",null,50000,null,null,"Drawings",null,60000,null,null,"Other Capital Purchases",null,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wealth Report",null,null,null,null,"Wealth Report",null,null,null,null,"NET FARM INCOME",null,64810.390235000057,null,null,"NET CASH FLOW BEFORE TAX",null,143063,null,null,"Loan Principal Repayments",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"($)",null,null,null,null,"($)",null,null,null,null,null,null,null,null,null,null,null,null,"Total Capital and Principal Costs",null,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assets",null,null,null,null,"Assets",null,null,null,null,"Wealth Report",null,null,null,null,"Profit Report",null,null,null,null,"NET FARM CASH FLOW BEFORE TAX AND DRAWINGS",null,-66615]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Inventory",null,33900,null,null,"Feed Inventory",null,35000,null,null,null,null,"($)",null,null,null,null,"Total",null,null,"Other Cash Items"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Current Assets",null,21000,null,null,"Other Current Assets",null,0,null,null,"Assets",null,null,null,null,"Income",null,"($)",null,null,"Net Non Farm Cash Income",null,2971]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Management Deposits",null,265000,null,null,"Farm Management Deposits",null,0,null,null,"Feed Inventory",null,35000,null,null,"Milk Income (net)",null,737256,null,null,"Drawings",null,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Current Assets",null,319900,null,null,"Total Current Assets",null,35000,null,null,"Carryover Water",null,0,null,null,"Livestock Trading Profit",null,32500,null,null,"NET CASH FLOW BEFORE TAX",null,-113644]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land & Water",1700000,1800000,null,null,"Land & Water",2000000,2000000,null,null,"Other Current Assets",null,0,null,null,"Feed & Water Sales",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock",100000,597200,null,null,"Livestock",0,525000,null,null,"Farm Management Deposits",null,0,null,null,"Other Farm Income",null,10000,null,null,"Profit Report"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant & Equipment",null,150000,null,null,"Plant & Equipment",null,250000,null,null,"Total Current Assets",null,35000,null,null,"Gross Farm Income",null,779756,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factory Shares",null,73481.5,null,null,"Factory Shares",null,0,null,null,"Land & Water",2000000,2000000,null,null,"Variable Costs",null,null,null,null,"Income",null,"($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Farm Assets",null,32500,null,null,"Other Farm Assets",null,0,null,null,"Livestock",0,453000,null,null,"Herd Costs",null,39000,null,null,"Milk Income (net)",null,636454]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Non-Current Assets",null,2653181.5,null,null,"Total Non-Current Assets",null,2775000,null,null,"Plant & Equipment",null,250000,null,null,"Shed Costs",null,24093,null,null,"Livestock Trading Profit",null,31400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Farm Assets Owned",null,2973081.5,null,null,"Total Farm Assets Owned",null,2810000,null,null,"Factory Shares",null,0,null,null,"Homegrown Feed",null,117000,null,null,"Feed & Water Sales",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON ASSETS",null,5.0066984372947723E-2,null,null,"RETURN ON ASSETS",null,3.585316378469753E-2,null,null,"Other Farm Assets",null,0,null,null,"Purchased Feed",0,212600,null,null,"Other Farm Income",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leased Assets",null,525007.5,null,null,"Leased Assets",null,0,null,null,"Total Non-Current Assets",null,2703000,null,null,"Feed & Water Inventory Change",0,0,null,null,"Gross Farm Income",null,667854]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Assets Managed",null,3498089,null,null,"Total Assets Managed",null,2810000,null,null,"Total Farm Assets Owned",null,2738000,null,null,"Feed Costs",null,329600,null,null,"Variable Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON TOTAL ASSETS  (ROTA)",null,5.8628361085152486E-2,null,null,"RETURN ON TOTAL ASSETS  (ROTA)",null,3.585316378469753E-2,null,null,"RETURN ON ASSETS",null,4.1932209727903604E-2,null,null,"Total Variable Costs",null,392693,null,null,"Herd Costs",null,25899]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liabilities",null,null,null,null,"Liabilities",null,null,null,null,"Leased Assets",null,0,null,null,"GROSS MARGIN",null,387063,null,null,"Shed Costs",null,15858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Current Liabilities",null,null,null,null,"Total Current Liabilities",null,null,null,null,"Total Assets Managed",null,2738000,null,null,"Overhead Costs",null,null,null,null,"Homegrown Feed",null,83329]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment Liabilities",null,62500,null,null,"Equipment Liabilities",null,0,null,null,"RETURN ON TOTAL ASSETS  (ROTA)",null,4.1932209727903604E-2,null,null,"Employed Labour Cost",null,50000,null,null,"Purchased Feed",null,119595]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long Term Liabilities",null,600000,null,null,"Long Term Liabilities",null,1000000,null,null,"Liabilities",null,null,null,null,"Repairs & Maintenance",null,39000,null,null,"Feed Inventory Change",null,-8900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Non-Current Liabilities",null,662500,null,null,"Total Non-Current Liabilities",null,1000000,null,null,"Total Current Liabilities",null,null,null,null,"Other Overhead Costs",null,35000,null,null,"Water Inventory Change",-8900,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Liabilities",null,691171.5,null,null,"Total Liabilities",null,1000000,null,null,"Equipment Liabilities",null,0,null,null,"Imputed Labour Cost",null,115752.60976499999,null,null,"Feed Costs",null,194024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equity",null,null,null,null,"Equity",null,null,null,null,"Long Term Liabilities",null,1000000,null,null,"Depreciation",null,32500,null,null,"Total Variable Costs",null,235781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equity",null,2281910,null,null,"Total Equity",null,1810000,null,null,"Total Non-Current Liabilities",null,1000000,null,null,"Total Overhead Costs",null,272252.609765,null,null,"GROSS MARGIN",null,432073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUITY AS % OF OWNED ASSETS",null,0.76752352735705365,null,null,"EQUITY AS % OF OWNED ASSETS",null,0.64412811387900359,null,null,"Total Liabilities",null,1000000,null,null,"TOTAL OPERATING COST (Variable & Overhead)",null,664945.60976499994,null,null,"Overhead Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON EQUITY",null,4.9592764394739482E-2,null,null,"RETURN ON EQUITY",null,2.8037232174033182E-2,null,null,"Equity",null,null,null,null,"EARNINGS BEFORE INTEREST & TAX (EBIT)",null,114810.39023500006,null,null,"Employed Labour Cost",null,110000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANGE IN NET WORTH",null,141280,null,null,"CHANGE IN NET WORTH",null,0,null,null,"Total Equity",null,1738000,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,664945.60976499994,null,null,"Farm Insurance",null,8808]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUITY AS % OF OWNED ASSETS",null,0.63476990504017528,null,null,"Livestock Inventory Change less Purchases",null,0,null,null,"Repairs & Maintenance",null,20610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Ends",null,null,null,null,"Report Ends",null,null,null,null,"RETURN ON EQUITY",null,3.7290213023590368E-2,null,null,"Feed & Water Inventory Change",null,0,null,null,"Other Overhead Costs",null,12049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANGE IN NET WORTH",null,0,null,null,"COST OF PRODUCTION (COP) - INCLUDING INVENTORY CHANGE",null,664945.60976499994,null,null,"Imputed Labour Cost",null,87360.460200000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Finance Costs",null,null,null,null,"Depreciation",null,25000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Ends",null,null,null,null,"Interest Costs",null,50000,null,null,"Total Overhead Costs",null,263827.46019999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease Costs",null,0,null,null,"TOTAL OPERATING COST (Variable & Overhead)",null,499608.46019999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Finance Costs",null,50000,null,null,"EARNINGS BEFORE INTEREST & TAX (EBIT)",null,168245.53980000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET FARM INCOME",null,64810.390235000057,null,null,"COST OF PRODUCTION (COP) - EXCLUDING INVENTORY CHANGE",null,508508.46019999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock Inventory Change less Purchases",null,13600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wealth Report",null,null,null,null,"Feed & Water Inventory Change",null,-8900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"($)",null,null,"COST OF PRODUCTION (COP) - INCLUDING INVENTORY CHANGE",null,513208.46019999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assets",null,null,null,null,"Finance Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Inventory",null,35000,null,null,"Interest Costs",null,35687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carryover Water",null,0,null,null,"Lease Costs",null,56234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Current Assets",null,0,null,null,"Total Finance Costs",null,91921]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Farm Management Deposits",null,0,null,null,"NET FARM INCOME",null,76324.539800000028]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Current Assets",null,35000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land & Water",2000000,2000000,null,null,"Wealth Report"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock",0,453000,null,null,null,"Opening ($)","Closing ($)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant & Equipment",null,250000,null,null,"Assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factory Shares",null,0,null,null,"Feed Inventory",29450,38350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Farm Assets",null,0,null,null,"Carryover Water",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Non-Current Assets",null,2703000,null,null,"Other Current Assets",20000,22000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Farm Assets Owned",null,2738000,null,null,"Farm Management Deposits",280000,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON ASSETS",null,4.1932209727903604E-2,null,null,"Total Current Assets",329450,310350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leased Assets",null,0,null,2500000,"Land & Water",2600000,2700000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Assets Managed",null,2738000,null,2600000,"Livestock",480800,477200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON TOTAL ASSETS  (ROTA)",null,4.1932209727903604E-2,null,2550000,"Plant & Equipment",250000,260000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liabilities",null,null,null,100000,"Factory Shares",71963,75000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Current Liabilities",null,null,null,100000,"Other Farm Assets",25000,40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment Liabilities",null,0,null,100000,"Total Non-Current Assets",3427763,3552200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long Term Liabilities",null,1000000,null,null,"Total Farm Assets Owned",3757213,3862550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Non-Current Liabilities",null,1000000,null,null,"RETURN ON ASSETS",2.940026869602113E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Liabilities",null,1000000,null,null,"Leased Assets",1050000,1000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equity",null,null,null,null,"Total Assets Managed",4807213,4862550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equity",null,1738000,null,null,"RETURN ON TOTAL ASSETS  (ROTA)",3.4798275779871754E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUITY AS % OF OWNED ASSETS",null,0.63476990504017528,null,null,"Liabilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON EQUITY",null,3.7290213023590368E-2,null,null,"Total Current Liabilities",32343,25000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANGE IN NET WORTH",null,0,null,null,"Equipment Liabilities",50000,75000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long Term Liabilities",600000,700000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Ends",null,null,null,null,"Total Non-Current Liabilities",650000,775000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Liabilities",682343,800000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equity",3074870,3062550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUITY AS % OF OWNED ASSETS",0.80546074726996097]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RETURN ON EQUITY",2.4871864659743028E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANGE IN NET WORTH",-12320]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report Ends"]

{"sheet":"Working","index":5,"n_rows":327,"n_cols":20,"rows_kept":327,"cut":false,"hidden":true,"merged":[]}
["Working",null,"Version:",0.46,"Date:","March 2016",null,null,null,null,"Store 1",null,"Store 2",null,"Store 3",null,"Defaults Detailed",null,"Defaults Intro"]
["Columns visible","Cashflow","MilkPrice","Wages","Stock","Feed",null,null,null,null,"Heights","Widths","Heights","Widths","Heights","Widths","Heights","Widths","Heights","Widths"]
["Budget",true,true,true,true,true,null,null,null,"Number",null,null,null,null,null,null,324,70,324,70]
["Actual",true,false,false,false,true,null,null,null,null,null,null,null,null,null,null,24,5.86,24,5.86]
["Differences",true,false,false,false,true,null,null,null,null,null,null,null,null,null,null,15.5,31,15.5,31]
["Months",true,true,true,true,true,null,null,null,null,null,null,null,null,null,null,15.5,20.57,15.5,20.57]
["Quarters",true,true,true,true,true,null,null,null,null,null,null,null,null,null,null,0,1.29,0,1.29]
["Annual",true,true,true,true,true,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Purchased fodder check boxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 1",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 2",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 3",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 4",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 5",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Fodder 6",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,0,15.5,0]
["Purchased other check boxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,0,15.5,2.57]
["Other 1",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,0,15.5,10.71]
["Other 2",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Other 3",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Other 4",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Wages",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Interest paid","Compounding periods per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Daily",1,365,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Monthly",2,12,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Quarterly",3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Half yearly",4,2,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Yearly",5,1,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Quarter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Month","Quarter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
[2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
[5,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[6,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[7,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[8,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[9,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[10,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
[11,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[12,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Copy form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Copy",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Period",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Remember",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Fertiliser Group",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Enter form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Type",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Period",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,12]
["Annual",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Remember",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Milk price units",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["cents per litre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["$/kg milk solids",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,0,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,0,0]
["Gotos",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12,0,12]
["Goto section…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Milk production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,12,15.5,0]
["Purchased feed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Variable costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Overhead costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Finance costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Capital costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Capital sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Non farm income",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Non farm expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Net cashflow total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Detailed Sheets","RadioB","Budget","Actual",null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Fertiliser",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Wages",4,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Stock",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Feed",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Leases",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Health",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["AI",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["MortgageHP",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["FMD",null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Lease Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Monthly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Quarterly",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Stock Classes","Offset",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Milkers",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Dries",18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["R2 Heifers",25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["R1 Heifers",32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["R1 Bulls",40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Current year income",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Summary year menu","Offset","DropDown",null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Summary total offset",{"$f":"IF(C111<=1,0,(C111-1)*17)","v":0},1,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
[{"$f":"StartYear &\"/\"&RIGHT(TEXT(StartYear+1,\"####\"),2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
[{"$f":"StartYear+1 &\"/\"&RIGHT(TEXT(StartYear+2,\"####\"),2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
[{"$f":"StartYear+2 &\"/\"&RIGHT(TEXT(StartYear+3,\"####\"),2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Dashboard Text Combos","User","Defaults",null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 1",74,74,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 2",104,104,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 3",106,106,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 4",121,121,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 5",128,128,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 6",158,158,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 7",190,190,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 8",192,192,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 9",202,202,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 10",212,212,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 11",246,246,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 12",258,258,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25,null,14.25]
["Combo 13",287,287,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Combo 14",293,293,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Combo 15",311,311,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Dashboard Graph Combos","User","Defaults",null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Combo 1",1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Combo 2",3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Combo 3",9,9,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Constants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Milk weight",1.03,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Distance walked",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Height walked",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Position changes",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Time standing",14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["Milk lactose",0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
["True protein",0.94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,15.5]