{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DSE values","Stocking rate","Assumptions"],"not_rendered":{"charts":0,"images":0,"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":"DSE values","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Dry sheep equivalent (DSE) values for different classes of livestock, at different liveweights"]
[]
[null,"Sheep",null,"30kg","40kg","50 kg","60kg"]
[null,"Dry ewes or wethers (maintaining weight)",null,null,0.9,1,1.2]
[null,"Last month of pregnancy (single / twins)",null,null,"1.2/1.4","1.4/1.6","1.6/1.9"]
[null,"Lactation (single / twins)",null,null,"2.6/3.7","2.7/3.9","2.9/4.4"]
[null,"Weaners (growth rate 100 g /d)",null,1.1000000000000001,1.3]
[null,"Average (year) ewe",null,null,1.5,1.6,1.8]
[]
[]
[null,"Beef Cattle",null,"400 kg","500 kg","600 kg"]
[null,"Dry cows or store steers (maintaining weight)",null,6,7,8]
[null,"Dry cows or store steers (growth rate 0.5 kg/d)",null,8,11,12]
[null,"Dry cows or store steers (growth rate 1.0 kg/d)",null,11,13,15]
[null,"Last 3 months of pregnancy",null,8,9,11]
[null,"Cows with 0-3 month calves",null,13,14,17]
[null,"Cows with 3-9 month calves",null,19,21,24]
[null,"Average (year) cow",null,15,16,19]
[]
[]
[null,"Source: Greener Pastures for south west Victoria  DPI 2006"]

{"sheet":"Stocking rate","index":1,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,3,1,6],[6,3,6,4],[5,3,5,4],[4,3,4,4],[3,5,3,6],[4,5,4,6],[3,3,3,4],[16,3,16,4],[15,3,15,4],[14,3,14,4],[13,3,13,4],[12,3,12,4],[11,3,11,4],[10,3,10,4],[9,3,9,4],[8,3,8,4],[7,3,7,4],[8,7,8,8],[7,7,7,8],[16,7,16,8],[15,7,15,8],[14,7,14,8],[13,7,13,8],[12,7,12,8],[3,7,3,8],[16,5,16,6],[15,5,15,6],[14,5,14,6],[13,5,13,6],[12,5,12,6],[11,5,11,6],[10,5,10,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[6,5,6,6],[5,5,5,6],[11,7,11,8],[10,7,10,8],[9,7,9,8],[5,9,5,10],[4,9,4,10],[6,7,6,8],[5,7,5,8],[4,7,4,8],[17,7,18,8],[17,9,18,10],[17,5,18,6],[17,3,18,4],[3,9,3,10],[16,9,16,10],[15,9,15,10],[14,9,14,10],[13,9,13,10],[11,9,11,10],[12,9,12,10],[10,9,10,10],[9,9,9,10],[8,9,8,10],[7,9,7,10],[6,9,6,10]]}
[null,"Stocking Rate"]
[null,null,null,"Whole of farm stocking rate"]
[]
[null,"Livestock type",null,"Hd",null,"Av. dse rating",null,"Months on-farm (max 12)",null,"Total dse"]
[]
[null,"Ewes",null,0,null,1.6,null,12,null,{"$f":"(D6*F6)*(H6/12)","v":0}]
[null,"Weaners (sale)",null,0,null,1.3,null,4,null,{"$f":"(D7*F7)*(H7/12)","v":0}]
[null,"Weaners (keep)",null,0,null,1.1000000000000001,null,9,null,{"$f":"(D8*F8)*(H8/12)","v":0}]
[null,"Wethers/dry ewes",null,0,null,1,null,12,null,{"$f":"(D9*F9)*(H9/12)","v":0}]
[null,"Rams",null,0,null,2.2000000000000002,null,12,null,{"$f":"(D10*F10)*(H10/12)","v":0}]
[]
[null,"Cows",null,50,null,16,null,12,null,{"$f":"(D12*F12)*(H12/12)","v":800}]
[null,"Weaners (sale)",null,0,null,11,null,4,null,{"$f":"(D13*F13)*(H13/12)","v":0}]
[null,"Weaners (keep)",null,0,null,8,null,6,null,{"$f":"(D14*F14)*(H14/12)","v":0}]
[null,"Steers/dry heifers",null,0,null,11,null,9,null,{"$f":"(D15*F15)*(H15/12)","v":0}]
[null,"Bulls",null,0,null,11,null,12,null,{"$f":"(D16*F16)*(H16/12)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:J16)","v":800}]
[null,null,null,"Ha",null,80,null,"dse/ha",null,{"$f":"J17/F18","v":10}]
[]
[]
[null,"Instructions"]
[null,"Choose a 12 month period (often time of weaning is useful) and list all the types of livestock you have carried at any point in time throughout the year."]
[null,"Using the reference table provided and the assumptions adjust the average yearly dse rating for each livestock type, if necessary."]
[null,"Enter in the number months within the defined period that those animals were grazing on-farm."]
[null,"Finally enter in the number of hectares that these animals were grazed over to calculate your whole farm average stocking rate."]
[]
[null,null,null,"Example calendar"]
[]
[null,"Livestock type",null,"Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct"]
[null,null,null,"Weaning",null,null,null,null,null,null,null,null,"Lambing"]
[null,"Ewes",null,null,null,null,null,null,null,null,null,null,"Lambs at foot"]
[null,"Weaners (sale)",null,"New season weaners",null,null,null,"Sold"]
[null,"Weaners (keep)",null,"New season weaners",null,null,null,null,null,null,null,null,"At 12 mths age weaners become ewes or wethers"]
[null,"Wethers/dry ewes"]
[null,"Rams"]
[]
[null,"Cows",null,null,null,null,"Calves at foot"]
[null,"Weaners (sale)",null,"New season weaners",null,null,null,"Sold"]
[null,"Weaners (keep)",null,"New season weaners",null,null,null,null,null,"At 15 mths age weaners become steers or heifers"]
[null,"Steers/dry heifers"]
[null,"Bulls"]
[null,null,null,"Weaning",null,null,"Calving"]

{"sheet":"Assumptions","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Assumptions",null,null," "]
[null,"Sheep"]
[null,"Ewes - 50kg ewe, 90% conception rate, 50% single and 50% twin lambing, dse rating assumes lambs at foot for 3 months at which point they are weaned"]
[null,"Weaners (sale) - 30-40kg lambs post weaning until the point of sale, but not beyond the defined period, growing at average 100g/day."]
[null,"Weaners (keep) - 30-40kg lambs post weaning, kept for future breeding or sale, enter months from weaning to end of defined period, once lambs cut 2 teeth they become wethers/dry ewes."]
[null,"Wethers/dry ewes - 2 teeth or older, 50kg weight, only include deliberately dry ewes, ewes that are unsuccessful in joining are accounted for in the 90% conception rate under ewes."]
[null,"Rams - 100kg body weight"]
[]
[null,"Beef"]
[null,"Cows - 500kg cow, 95% conception rate, dse rating assumes calves at foot for 9 months at which point they are weaned."]
[null,"Weaners (sale) - 300kg body weight, post weaning until point of sale, but not beyond the defined period, growing at average 500g/day"]
[null,"Weaners (keep) - 300kg body weight, post weaning, kept for future breeding or sale, enter months from weaning to end of defined period, after 15 months of age weaners become steers/dry heifers"]
[null,"Steers/dry heifers - "]
[null,"Bulls"]