{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","KLR Analyser 1","KLR Analyser 2","KLR Analyser 3","KLR Analyser 4","KLR Analyser 5"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["E"]

{"sheet":"KLR Analyser 1","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[40,14,40,16],[41,14,41,16],[35,14,35,16],[36,14,36,16],[37,14,37,16],[38,14,38,16],[39,14,39,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[33,14,33,16],[34,1,34,3],[34,14,34,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[28,14,28,16],[29,14,29,16],[18,13,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[13,14,13,16],[14,14,14,16],[15,14,15,16],[16,14,16,16],[17,14,17,16],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[12,13,12,16],[36,1,37,2],[1,2,1,5],[1,10,1,12],[2,2,2,5],[2,10,2,12],[5,14,5,16],[6,14,6,16],[7,14,7,16],[0,1,0,17],[1,13,1,17],[2,13,2,17],[3,14,3,16],[4,13,4,16]]}
[null,"KLR Business Analyser"]
[null,"Business:  ",null,null,null,null,null,null,null,null,"Date:  "]
[null,"Enterprise:",null,null,null,null,null,null,null,null,"File Name:  "]
[null,"Expenses",null,null,null,"Expenses Cont."]
[null,"Interest Leasing & Rates",null,null,null,"Machinery & Vehicle Exp.",null,null,null,"Pasture Exp.",null,null,null,"Enterprise Allocation Ave over a few years"]
[null,"Interest ",null,"/yr",null,"Vehicle R&M.",null,"/yr",null,"Pasture Fertilizer & Seed ",null,null,null,"% Income From Sheep",null,null,null,"%"]
[null,"Lease Payments (Land)",null,"/yr",null,"Gen Mach R&M",null,"/yr",null,"Pasture Improvement",null,null,null,"% Income From Cattle",null,null,null,"%"]
[null,"Rent",null,"/yr",null,"Fuel,Oil&Grease",null,"/yr",null,"Pasture Chemicals",null,null,null,"% Income From Crop",null,null,null,"%"]
[null,"Bank Charges",null,"/yr",null,"Vehicle Lease Payments",null,"/yr",null,"Contract Spraying",null,null,null,"% Income From off Farm",null,null,null,"%"]
[null,"Council Rates",null,"/yr",null,"Farm Vehicle Costs",null,"/yr",null,"Other Contracting",null,null,null,"MUST EQUAL 100%",{"$f":"SUM(O6:O9)","v":0},null,null,"%"]
[null,"Other Rates etc",null,"/yr",null,"Vehicle Registrations",null,"/yr",null,null,{"$f":"SUM(K6:K10)","v":0}]
[null,"Other ",null,"/yr",null,"Other",null,"/yr"]
[null,null,{"$f":"SUM(C6:C12)","v":0},null,null,null,{"$f":"SUM(G6:G12)","v":0},null,null,null,null,null,null,"Alternative Income or cash Injection"]
[null,"Insurance ",null,null,null,"Business & Office Exp.",null,null,null,"Asset replacement provision",null,null,null,"Contracting",null,null,null,"/yr"]
[null,"Insurance Farm",null,"/yr",null,"Electricity",null,"/yr",null,"Tractors",null,"/yr",null,"Agistment  ",null,null,null,"/yr"]
[null,"Insurance Stock",null,"/yr",null,"Telephone (Bus.)/Internet",null,"/yr",null,"Machinery",null,null,null,"Off farm income",null,null,null,"/yr"]
[null,"Insurance Life",null,"/yr",null,"Accountancy",null,"/yr",null,"Other plant",null,null,null,null,{"$f":"SUM(O14:Q16)","v":0}]
[null,"Income protection ",null,"/yr",null,"Taxation",null,"/yr",null,"Trucks"]
[null,"Insurance Workers Comp.",null,"/yr",null,"Admin./Legal",null,"/yr",null,"Bikes",null,"/yr",null,"Total Yearly Operating Costs"]
[null,"Critical illness ",null,"/yr",null,"Professional Dev. & Training",null,"/yr",null,"Vehicles",null,"/yr",null,null,{"$f":"C13+C24+C34+G13+G24+G33+K11+K22+K28-O17","v":0}]
[null,"Debt Insurance",null,"/yr",null,"Consultancy Fees",null,"/yr",null,"Office Equipment.",null,"/yr"]
[null,"Health Insurance",null,"/yr",null,"General Office Expenses",null,null,null,null,{"$f":"SUM(K15:K21)","v":0},null,null,"Overhead Allocation "]
[null,"Other ",null,"/yr",null,"Other",null,"/yr",null,null,null,null,null,"Overheads Sheep",{"$f":"O6*O20/100","v":0}]
[null,null,{"$f":"SUM(C15:C23)","v":0},null,null,null,{"$f":"SUM(G15:G23)","v":0},null,null,null,null,null,null,"Overheads Cattle",{"$f":"O7*O20/100","v":0}]
[null,"General Farm Exp.",null,null,null,"Wages & Allowances ",null,null,null,"Debt Amortisation",null,null,null,"Overheads Cropping",{"$f":"O8*O20/100","v":0}]
[null,"Outside Contracting/Wages ",null,null,null,"Wages (Self)",null,"/yr",null,"Bank Debt Principle Repayments",null,"/yr",null,"Overheads Off Farm Income",{"$f":"O9*O20/100","v":0}]
[null,"General Freight",null,null,null,"Wages (Staff)",null,"/yr",null,"Other Debt Principle Repayments",null,"/yr"]
[null,"General Repairs",null,null,null,"Working Director",null,"/yr",null,null,{"$f":"SUM(K26:K27)","v":0},null,null,"Agistment  "]
[null,"Fencing New & Repairs",null,null,null,"Directors Fees",null,"/yr",null,null,null,null,null,"Agistment rate per week "]
[null,"Water System New & Repairs",null,null,null,"Superanuation/Investment",null,"/yr",null,"Livestock Numbers",null,null,null,"Sheep"]
[null,"Water/Soil Conservation",null,null,null,"Super (Staff)",null,"/yr",null,"Ave Sheep No. over 12 months",null,null,null,"Cost per Hd Sheep/week",{"$f":"O23/K31/52","v":{"$error":"#DIV/0!"}}]
[null,"Dog Maintanance",null,null,null,"Other",null,"/yr",null,"              & OR",null,null,null,"Cattle"]
[null,"Pest Control",null,null,null,null,{"$f":"SUM(G26:G32)","v":0},null,null,"Ave Cattle No. over 12 months",null,null,null,"Cost per Hd Cattle/week",{"$f":"O24/K33/52","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C26:C33)","v":0}]
[null," © Copyright KLR Marketing PTY LTD - 2025"]
[null,"     Version 54.26"]
[null,"This Sheet will lock 30th June. Download a new sheet after that time."]

{"sheet":"KLR Analyser 2","index":2,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,3,16],[4,13,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16],[1,2,1,5],[1,10,1,12],[2,2,2,5],[2,10,2,12],[0,1,0,17],[1,13,1,17],[2,13,2,17],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[12,13,12,16],[13,14,13,16],[14,14,14,16],[15,14,15,16],[16,14,16,16],[17,14,17,16],[18,13,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[28,14,28,16],[29,14,29,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[33,14,33,16],[34,1,34,3],[34,14,34,16],[39,14,39,16],[40,14,40,16],[41,14,41,16],[35,14,35,16],[36,1,37,2],[36,14,36,16],[37,14,37,16],[38,14,38,16]]}
[null,"KLR Business Analyser"]
[null,"Business:  ",null,null,null,null,null,null,null,null,"Date:  "]
[null,"Enterprise:",null,null,null,null,null,null,null,null,"File Name:  "]
[null,"Expenses",null,null,null,"Expenses Cont."]
[null,"Interest Leasing & Rates",null,null,null,"Machinery & Vehicle Exp.",null,null,null,"Pasture Exp.",null,null,null,"Enterprise Allocation Ave over a few years"]
[null,"Interest ",null,"/yr",null,"Vehicle R&M.",null,"/yr",null,"Pasture Fertilizer & Seed ",null,null,null,"% Income From Sheep",null,null,null,"%"]
[null,"Lease Payments (Land)",null,"/yr",null,"Gen Mach R&M",null,"/yr",null,"Pasture Improvement",null,null,null,"% Income From Cattle",null,null,null,"%"]
[null,"Rent",null,"/yr",null,"Fuel,Oil&Grease",null,"/yr",null,"Pasture Chemicals",null,null,null,"% Income From Crop",null,null,null,"%"]
[null,"Bank Charges",null,"/yr",null,"Vehicle Lease Payments",null,"/yr",null,"Contract Spraying",null,null,null,"% Income From off Farm",null,null,null,"%"]
[null,"Council Rates",null,"/yr",null,"Farm Vehicle Costs",null,"/yr",null,"Other Contracting",null,null,null,"MUST EQUAL 100%",{"$f":"SUM(O6:O9)","v":0},null,null,"%"]
[null,"Other Rates etc",null,"/yr",null,"Vehicle Registrations",null,"/yr",null,null,{"$f":"SUM(K6:K10)","v":0}]
[null,"Other ",null,"/yr",null,"Other",null,"/yr"]
[null,null,{"$f":"SUM(C6:C12)","v":0},null,null,null,{"$f":"SUM(G6:G12)","v":0},null,null,null,null,null,null,"Alternative Income or cash Injection"]
[null,"Insurance ",null,null,null,"Business & Office Exp.",null,null,null,"Asset replacement provision",null,null,null,"Contracting",null,null,null,"/yr"]
[null,"Insurance Farm",null,"/yr",null,"Electricity",null,"/yr",null,"Tractors",null,"/yr",null,"Agistment  ",null,null,null,"/yr"]
[null,"Insurance Stock",null,"/yr",null,"Telephone (Bus.)/Internet",null,"/yr",null,"Machinery",null,null,null,"Off farm income",null,null,null,"/yr"]
[null,"Insurance Life",null,"/yr",null,"Accountancy",null,"/yr",null,"Other plant",null,null,null,null,{"$f":"SUM(O14:Q16)","v":0}]
[null,"Income protection ",null,"/yr",null,"Taxation",null,"/yr",null,"Trucks"]
[null,"Insurance Workers Comp.",null,"/yr",null,"Admin./Legal",null,"/yr",null,"Bikes",null,"/yr",null,"Total Yearly Operating Costs"]
[null,"Critical illness ",null,"/yr",null,"Professional Dev. & Training",null,"/yr",null,"Vehicles",null,"/yr",null,null,{"$f":"C13+C24+C34+G13+G24+G33+K11+K22+K28-O17","v":0}]
[null,"Debt Insurance",null,"/yr",null,"Consultancy Fees",null,"/yr",null,"Office Equipment.",null,"/yr"]
[null,"Health Insurance",null,"/yr",null,"General Office Expenses",null,null,null,null,{"$f":"SUM(K15:K21)","v":0},null,null,"Overhead Allocation "]
[null,"Other ",null,"/yr",null,"Other",null,"/yr",null,null,null,null,null,"Overheads Sheep",{"$f":"O6*O20/100","v":0}]
[null,null,{"$f":"SUM(C15:C23)","v":0},null,null,null,{"$f":"SUM(G15:G23)","v":0},null,null,null,null,null,null,"Overheads Cattle",{"$f":"O7*O20/100","v":0}]
[null,"General Farm Exp.",null,null,null,"Wages & Allowances ",null,null,null,"Debt Amortisation",null,null,null,"Overheads Cropping",{"$f":"O8*O20/100","v":0}]
[null,"Outside Contracting/Wages ",null,null,null,"Wages (Self)",null,"/yr",null,"Bank Debt Principle Repayments",null,"/yr",null,"Overheads Off Farm Income",{"$f":"O9*O20/100","v":0}]
[null,"General Freight",null,null,null,"Wages (Staff)",null,"/yr",null,"Other Debt Principle Repayments",null,"/yr"]
[null,"General Repairs",null,null,null,"Working Director",null,"/yr",null,null,{"$f":"SUM(K26:K27)","v":0},null,null,"Agistment  "]
[null,"Fencing New & Repairs",null,null,null,"Directors Fees",null,"/yr",null,null,null,null,null,"Agistment rate per week "]
[null,"Water System New & Repairs",null,null,null,"Superanuation/Investment",null,"/yr",null,"Livestock Numbers",null,null,null,"Sheep"]
[null,"Water/Soil Conservation",null,null,null,"Super (Staff)",null,"/yr",null,"Ave Sheep No. over 12 months",null,null,null,"Cost per Hd Sheep/week",{"$f":"O23/K31/52","v":{"$error":"#DIV/0!"}}]
[null,"Dog Maintanance",null,null,null,"Other",null,"/yr",null,"              & OR",null,null,null,"Cattle"]
[null,"Pest Control",null,null,null,null,{"$f":"SUM(G26:G32)","v":0},null,null,"Ave Cattle No. over 12 months",null,null,null,"Cost per Hd Cattle/week",{"$f":"O24/K33/52","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C26:C33)","v":0}]
[null," © Copyright KLR Marketing PTY LTD - 2025"]
[null,{"$f":"'KLR Analyser 1'!B36","v":"     Version 54.26"}]
[null,"This Sheet will lock 30th June. Download a new sheet after that time."]

{"sheet":"KLR Analyser 3","index":3,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,3,16],[4,13,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16],[1,2,1,5],[1,10,1,12],[2,2,2,5],[2,10,2,12],[0,1,0,17],[1,13,1,17],[2,13,2,17],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[12,13,12,16],[13,14,13,16],[14,14,14,16],[15,14,15,16],[16,14,16,16],[17,14,17,16],[18,13,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[28,14,28,16],[29,14,29,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[33,14,33,16],[34,1,34,3],[34,14,34,16],[39,14,39,16],[40,14,40,16],[41,14,41,16],[35,14,35,16],[36,1,37,2],[36,14,36,16],[37,14,37,16],[38,14,38,16]]}
[null,"KLR Business Analyser"]
[null,"Business:  ",null,null,null,null,null,null,null,null,"Date:  "]
[null,"Enterprise:",null,null,null,null,null,null,null,null,"File Name:  "]
[null,"Expenses",null,null,null,"Expenses Cont."]
[null,"Interest Leasing & Rates",null,null,null,"Machinery & Vehicle Exp.",null,null,null,"Pasture Exp.",null,null,null,"Enterprise Allocation Ave over a few years"]
[null,"Interest ",null,"/yr",null,"Vehicle R&M.",null,"/yr",null,"Pasture Fertilizer & Seed ",null,null,null,"% Income From Sheep",null,null,null,"%"]
[null,"Lease Payments (Land)",null,"/yr",null,"Gen Mach R&M",null,"/yr",null,"Pasture Improvement",null,null,null,"% Income From Cattle",null,null,null,"%"]
[null,"Rent",null,"/yr",null,"Fuel,Oil&Grease",null,"/yr",null,"Pasture Chemicals",null,null,null,"% Income From Crop",null,null,null,"%"]
[null,"Bank Charges",null,"/yr",null,"Vehicle Lease Payments",null,"/yr",null,"Contract Spraying",null,null,null,"% Income From off Farm",null,null,null,"%"]
[null,"Council Rates",null,"/yr",null,"Farm Vehicle Costs",null,"/yr",null,"Other Contracting",null,null,null,"MUST EQUAL 100%",{"$f":"SUM(O6:O9)","v":0},null,null,"%"]
[null,"Other Rates etc",null,"/yr",null,"Vehicle Registrations",null,"/yr",null,null,{"$f":"SUM(K6:K10)","v":0}]
[null,"Other ",null,"/yr",null,"Other",null,"/yr"]
[null,null,{"$f":"SUM(C6:C12)","v":0},null,null,null,{"$f":"SUM(G6:G12)","v":0},null,null,null,null,null,null,"Alternative Income or cash Injection"]
[null,"Insurance ",null,null,null,"Business & Office Exp.",null,null,null,"Asset replacement provision",null,null,null,"Contracting",null,null,null,"/yr"]
[null,"Insurance Farm",null,"/yr",null,"Electricity",null,"/yr",null,"Tractors",null,"/yr",null,"Agistment  ",null,null,null,"/yr"]
[null,"Insurance Stock",null,"/yr",null,"Telephone (Bus.)/Internet",null,"/yr",null,"Machinery",null,null,null,"Off farm income",null,null,null,"/yr"]
[null,"Insurance Life",null,"/yr",null,"Accountancy",null,"/yr",null,"Other plant",null,null,null,null,{"$f":"SUM(O14:Q16)","v":0}]
[null,"Income protection ",null,"/yr",null,"Taxation",null,"/yr",null,"Trucks"]
[null,"Insurance Workers Comp.",null,"/yr",null,"Admin./Legal",null,"/yr",null,"Bikes",null,"/yr",null,"Total Yearly Operating Costs"]
[null,"Critical illness ",null,"/yr",null,"Professional Dev. & Training",null,"/yr",null,"Vehicles",null,"/yr",null,null,{"$f":"C13+C24+C34+G13+G24+G33+K11+K22+K28-O17","v":0}]
[null,"Debt Insurance",null,"/yr",null,"Consultancy Fees",null,"/yr",null,"Office Equipment.",null,"/yr"]
[null,"Health Insurance",null,"/yr",null,"General Office Expenses",null,null,null,null,{"$f":"SUM(K15:K21)","v":0},null,null,"Overhead Allocation "]
[null,"Other ",null,"/yr",null,"Other",null,"/yr",null,null,null,null,null,"Overheads Sheep",{"$f":"O6*O20/100","v":0}]
[null,null,{"$f":"SUM(C15:C23)","v":0},null,null,null,{"$f":"SUM(G15:G23)","v":0},null,null,null,null,null,null,"Overheads Cattle",{"$f":"O7*O20/100","v":0}]
[null,"General Farm Exp.",null,null,null,"Wages & Allowances ",null,null,null,"Debt Amortisation",null,null,null,"Overheads Cropping",{"$f":"O8*O20/100","v":0}]
[null,"Outside Contracting/Wages ",null,null,null,"Wages (Self)",null,"/yr",null,"Bank Debt Principle Repayments",null,"/yr",null,"Overheads Off Farm Income",{"$f":"O9*O20/100","v":0}]
[null,"General Freight",null,null,null,"Wages (Staff)",null,"/yr",null,"Other Debt Principle Repayments",null,"/yr"]
[null,"General Repairs",null,null,null,"Working Director",null,"/yr",null,null,{"$f":"SUM(K26:K27)","v":0},null,null,"Agistment  "]
[null,"Fencing New & Repairs",null,null,null,"Directors Fees",null,"/yr",null,null,null,null,null,"Agistment rate per week "]
[null,"Water System New & Repairs",null,null,null,"Superanuation/Investment",null,"/yr",null,"Livestock Numbers",null,null,null,"Sheep"]
[null,"Water/Soil Conservation",null,null,null,"Super (Staff)",null,"/yr",null,"Ave Sheep No. over 12 months",null,null,null,"Cost per Hd Sheep/week",{"$f":"O23/K31/52","v":{"$error":"#DIV/0!"}}]
[null,"Dog Maintanance",null,null,null,"Other",null,"/yr",null,"              & OR",null,null,null,"Cattle"]
[null,"Pest Control",null,null,null,null,{"$f":"SUM(G26:G32)","v":0},null,null,"Ave Cattle No. over 12 months",null,null,null,"Cost per Hd Cattle/week",{"$f":"O24/K33/52","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C26:C33)","v":0}]
[null," © Copyright KLR Marketing PTY LTD - 2025"]
[null,{"$f":"'KLR Analyser 1'!B36","v":"     Version 54.26"}]
[null,"This Sheet will lock 30th June. Download a new sheet after that time."]

{"sheet":"KLR Analyser 4","index":4,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,3,16],[4,13,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16],[1,2,1,5],[1,10,1,12],[2,2,2,5],[2,10,2,12],[0,1,0,17],[1,13,1,17],[2,13,2,17],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[12,13,12,16],[13,14,13,16],[14,14,14,16],[15,14,15,16],[16,14,16,16],[17,14,17,16],[18,13,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[28,14,28,16],[29,14,29,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[33,14,33,16],[34,1,34,3],[34,14,34,16],[39,14,39,16],[40,14,40,16],[41,14,41,16],[35,14,35,16],[36,1,37,2],[36,14,36,16],[37,14,37,16],[38,14,38,16]]}
[null,"KLR Business Analyser"]
[null,"Business:  ",null,null,null,null,null,null,null,null,"Date:  "]
[null,"Enterprise:",null,null,null,null,null,null,null,null,"File Name:  "]
[null,"Expenses",null,null,null,"Expenses Cont."]
[null,"Interest Leasing & Rates",null,null,null,"Machinery & Vehicle Exp.",null,null,null,"Pasture Exp.",null,null,null,"Enterprise Allocation Ave over a few years"]
[null,"Interest ",null,"/yr",null,"Vehicle R&M.",null,"/yr",null,"Pasture Fertilizer & Seed ",null,null,null,"% Income From Sheep",null,null,null,"%"]
[null,"Lease Payments (Land)",null,"/yr",null,"Gen Mach R&M",null,"/yr",null,"Pasture Improvement",null,null,null,"% Income From Cattle",null,null,null,"%"]
[null,"Rent",null,"/yr",null,"Fuel,Oil&Grease",null,"/yr",null,"Pasture Chemicals",null,null,null,"% Income From Crop",null,null,null,"%"]
[null,"Bank Charges",null,"/yr",null,"Vehicle Lease Payments",null,"/yr",null,"Contract Spraying",null,null,null,"% Income From off Farm",null,null,null,"%"]
[null,"Council Rates",null,"/yr",null,"Farm Vehicle Costs",null,"/yr",null,"Other Contracting",null,null,null,"MUST EQUAL 100%",{"$f":"SUM(O6:O9)","v":0},null,null,"%"]
[null,"Other Rates etc",null,"/yr",null,"Vehicle Registrations",null,"/yr",null,null,{"$f":"SUM(K6:K10)","v":0}]
[null,"Other ",null,"/yr",null,"Other",null,"/yr"]
[null,null,{"$f":"SUM(C6:C12)","v":0},null,null,null,{"$f":"SUM(G6:G12)","v":0},null,null,null,null,null,null,"Alternative Income or cash Injection"]
[null,"Insurance ",null,null,null,"Business & Office Exp.",null,null,null,"Asset replacement provision",null,null,null,"Contracting",null,null,null,"/yr"]
[null,"Insurance Farm",null,"/yr",null,"Electricity",null,"/yr",null,"Tractors",null,"/yr",null,"Agistment  ",null,null,null,"/yr"]
[null,"Insurance Stock",null,"/yr",null,"Telephone (Bus.)/Internet",null,"/yr",null,"Machinery",null,null,null,"Off farm income",null,null,null,"/yr"]
[null,"Insurance Life",null,"/yr",null,"Accountancy",null,"/yr",null,"Other plant",null,null,null,null,{"$f":"SUM(O14:Q16)","v":0}]
[null,"Income protection ",null,"/yr",null,"Taxation",null,"/yr",null,"Trucks"]
[null,"Insurance Workers Comp.",null,"/yr",null,"Admin./Legal",null,"/yr",null,"Bikes",null,"/yr",null,"Total Yearly Operating Costs"]
[null,"Critical illness ",null,"/yr",null,"Professional Dev. & Training",null,"/yr",null,"Vehicles",null,"/yr",null,null,{"$f":"C13+C24+C34+G13+G24+G33+K11+K22+K28-O17","v":0}]
[null,"Debt Insurance",null,"/yr",null,"Consultancy Fees",null,"/yr",null,"Office Equipment.",null,"/yr"]
[null,"Health Insurance",null,"/yr",null,"General Office Expenses",null,null,null,null,{"$f":"SUM(K15:K21)","v":0},null,null,"Overhead Allocation "]
[null,"Other ",null,"/yr",null,"Other",null,"/yr",null,null,null,null,null,"Overheads Sheep",{"$f":"O6*O20/100","v":0}]
[null,null,{"$f":"SUM(C15:C23)","v":0},null,null,null,{"$f":"SUM(G15:G23)","v":0},null,null,null,null,null,null,"Overheads Cattle",{"$f":"O7*O20/100","v":0}]
[null,"General Farm Exp.",null,null,null,"Wages & Allowances ",null,null,null,"Debt Amortisation",null,null,null,"Overheads Cropping",{"$f":"O8*O20/100","v":0}]
[null,"Outside Contracting/Wages ",null,null,null,"Wages (Self)",null,"/yr",null,"Bank Debt Principle Repayments",null,"/yr",null,"Overheads Off Farm Income",{"$f":"O9*O20/100","v":0}]
[null,"General Freight",null,null,null,"Wages (Staff)",null,"/yr",null,"Other Debt Principle Repayments",null,"/yr"]
[null,"General Repairs",null,null,null,"Working Director",null,"/yr",null,null,{"$f":"SUM(K26:K27)","v":0},null,null,"Agistment  "]
[null,"Fencing New & Repairs",null,null,null,"Directors Fees",null,"/yr",null,null,null,null,null,"Agistment rate per week "]
[null,"Water System New & Repairs",null,null,null,"Superanuation/Investment",null,"/yr",null,"Livestock Numbers",null,null,null,"Sheep"]
[null,"Water/Soil Conservation",null,null,null,"Super (Staff)",null,"/yr",null,"Ave Sheep No. over 12 months",null,null,null,"Cost per Hd Sheep/week",{"$f":"O23/K31/52","v":{"$error":"#DIV/0!"}}]
[null,"Dog Maintanance",null,null,null,"Other",null,"/yr",null,"              & OR",null,null,null,"Cattle"]
[null,"Pest Control",null,null,null,null,{"$f":"SUM(G26:G32)","v":0},null,null,"Ave Cattle No. over 12 months",null,null,null,"Cost per Hd Cattle/week",{"$f":"O24/K33/52","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C26:C33)","v":0}]
[null," © Copyright KLR Marketing PTY LTD - 2025"]
[null,{"$f":"'KLR Analyser 1'!B36","v":"     Version 54.26"}]
[null,"This Sheet will lock 30th June. Download a new sheet after that time."]

{"sheet":"KLR Analyser 5","index":5,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,3,16],[4,13,4,16],[5,14,5,16],[6,14,6,16],[7,14,7,16],[1,2,1,5],[1,10,1,12],[2,2,2,5],[2,10,2,12],[0,1,0,17],[1,13,1,17],[2,13,2,17],[8,14,8,16],[9,14,9,16],[10,14,10,16],[11,14,11,16],[12,13,12,16],[13,14,13,16],[14,14,14,16],[15,14,15,16],[16,14,16,16],[17,14,17,16],[18,13,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[24,14,24,16],[25,14,25,16],[28,14,28,16],[29,14,29,16],[30,14,30,16],[31,14,31,16],[32,14,32,16],[33,14,33,16],[34,1,34,3],[34,14,34,16],[39,14,39,16],[40,14,40,16],[41,14,41,16],[35,14,35,16],[36,1,37,2],[36,14,36,16],[37,14,37,16],[38,14,38,16]]}
[null,"KLR Business Analyser"]
[null,"Business:  ",null,null,null,null,null,null,null,null,"Date:  "]
[null,"Enterprise:",null,null,null,null,null,null,null,null,"File Name:  "]
[null,"Expenses",null,null,null,"Expenses Cont."]
[null,"Interest Leasing & Rates",null,null,null,"Machinery & Vehicle Exp.",null,null,null,"Pasture Exp.",null,null,null,"Enterprise Allocation Ave over a few years"]
[null,"Interest ",null,"/yr",null,"Vehicle R&M.",null,"/yr",null,"Pasture Fertilizer & Seed ",null,null,null,"% Income From Sheep",null,null,null,"%"]
[null,"Lease Payments (Land)",null,"/yr",null,"Gen Mach R&M",null,"/yr",null,"Pasture Improvement",null,null,null,"% Income From Cattle",null,null,null,"%"]
[null,"Rent",null,"/yr",null,"Fuel,Oil&Grease",null,"/yr",null,"Pasture Chemicals",null,null,null,"% Income From Crop",null,null,null,"%"]
[null,"Bank Charges",null,"/yr",null,"Vehicle Lease Payments",null,"/yr",null,"Contract Spraying",null,null,null,"% Income From off Farm",null,null,null,"%"]
[null,"Council Rates",null,"/yr",null,"Farm Vehicle Costs",null,"/yr",null,"Other Contracting",null,null,null,"MUST EQUAL 100%",{"$f":"SUM(O6:O9)","v":0},null,null,"%"]
[null,"Other Rates etc",null,"/yr",null,"Vehicle Registrations",null,"/yr",null,null,{"$f":"SUM(K6:K10)","v":0}]
[null,"Other ",null,"/yr",null,"Other",null,"/yr"]
[null,null,{"$f":"SUM(C6:C12)","v":0},null,null,null,{"$f":"SUM(G6:G12)","v":0},null,null,null,null,null,null,"Alternative Income or cash Injection"]
[null,"Insurance ",null,null,null,"Business & Office Exp.",null,null,null,"Asset replacement provision",null,null,null,"Contracting",null,null,null,"/yr"]
[null,"Insurance Farm",null,"/yr",null,"Electricity",null,"/yr",null,"Tractors",null,"/yr",null,"Agistment  ",null,null,null,"/yr"]
[null,"Insurance Stock",null,"/yr",null,"Telephone (Bus.)/Internet",null,"/yr",null,"Machinery",null,null,null,"Off farm income",null,null,null,"/yr"]
[null,"Insurance Life",null,"/yr",null,"Accountancy",null,"/yr",null,"Other plant",null,null,null,null,{"$f":"SUM(O14:Q16)","v":0}]
[null,"Income protection ",null,"/yr",null,"Taxation",null,"/yr",null,"Trucks"]
[null,"Insurance Workers Comp.",null,"/yr",null,"Admin./Legal",null,"/yr",null,"Bikes",null,"/yr",null,"Total Yearly Operating Costs"]
[null,"Critical illness ",null,"/yr",null,"Professional Dev. & Training",null,"/yr",null,"Vehicles",null,"/yr",null,null,{"$f":"C13+C24+C34+G13+G24+G33+K11+K22+K28-O17","v":0}]
[null,"Debt Insurance",null,"/yr",null,"Consultancy Fees",null,"/yr",null,"Office Equipment.",null,"/yr"]
[null,"Health Insurance",null,"/yr",null,"General Office Expenses",null,null,null,null,{"$f":"SUM(K15:K21)","v":0},null,null,"Overhead Allocation "]
[null,"Other ",null,"/yr",null,"Other",null,"/yr",null,null,null,null,null,"Overheads Sheep",{"$f":"O6*O20/100","v":0}]
[null,null,{"$f":"SUM(C15:C23)","v":0},null,null,null,{"$f":"SUM(G15:G23)","v":0},null,null,null,null,null,null,"Overheads Cattle",{"$f":"O7*O20/100","v":0}]
[null,"General Farm Exp.",null,null,null,"Wages & Allowances ",null,null,null,"Debt Amortisation",null,null,null,"Overheads Cropping",{"$f":"O8*O20/100","v":0}]
[null,"Outside Contracting/Wages ",null,null,null,"Wages (Self)",null,"/yr",null,"Bank Debt Principle Repayments",null,"/yr",null,"Overheads Off Farm Income",{"$f":"O9*O20/100","v":0}]
[null,"General Freight",null,null,null,"Wages (Staff)",null,"/yr",null,"Other Debt Principle Repayments",null,"/yr"]
[null,"General Repairs",null,null,null,"Working Director",null,"/yr",null,null,{"$f":"SUM(K26:K27)","v":0},null,null,"Agistment  "]
[null,"Fencing New & Repairs",null,null,null,"Directors Fees",null,"/yr",null,null,null,null,null,"Agistment rate per week "]
[null,"Water System New & Repairs",null,null,null,"Superanuation/Investment",null,"/yr",null,"Livestock Numbers",null,null,null,"Sheep"]
[null,"Water/Soil Conservation",null,null,null,"Super (Staff)",null,"/yr",null,"Ave Sheep No. over 12 months",null,null,null,"Cost per Hd Sheep/week",{"$f":"O23/K31/52","v":{"$error":"#DIV/0!"}}]
[null,"Dog Maintanance",null,null,null,"Other",null,"/yr",null,"              & OR",null,null,null,"Cattle"]
[null,"Pest Control",null,null,null,null,{"$f":"SUM(G26:G32)","v":0},null,null,"Ave Cattle No. over 12 months",null,null,null,"Cost per Hd Cattle/week",{"$f":"O24/K33/52","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C26:C33)","v":0}]
[null," © Copyright KLR Marketing PTY LTD - 2025"]
[null,{"$f":"'KLR Analyser 1'!B36","v":"     Version 54.26"}]
[null,"This Sheet will lock 30th June. Download a new sheet after that time."]