{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,8,24,11],[15,8,15,10],[4,4,4,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[4,0,4,1],[5,4,5,5],[0,0,0,11],[9,4,9,5],[10,4,10,5],[4,7,4,8]]}
["                        Fodder Budgeting Worksheet (Complete yellow cells)"]
["Farmer:",null,null,null,null,null,"Advisor:"]
["Phone No.",null,null,null,null,null,"Phone No.",null,null,"Date:"]
[]
["Animal Type",null,"No. of Animals (a)","Winter Feeding Days           (b)","Dry Matter Required / Head Day Kg      \n(c)",null,"Planned Meal Feeding Kg /Head/Day (d)","Meal required (tonnes fresh wt.)",null,"Net Roughage Intake per Day (Kg DM)               (e = c - d*0.86)","Total Roughage required             Kg DM                   (f = a x b x e)"]
["Cows",null,null,null,11,null,null,null,{"$f":"G6*D6*C6/1000","v":0},{"$f":"E6-(G6*0.86)","v":11},{"$f":"C6*D6*J6","v":0}]
["Incalf Heifers",null,null,null,9,null,null,null,0,9,0]
["Weanlings",null,null,null,4.7,null,null,null,0,4.7,0]
["Cattle: ","1½ Males",null,null,9.5,null,null,null,0,9.5,0]
[null,"1½ Heifers",null,null,8.3000000000000007,null,null,null,0,8.3000000000000007,0]
[null,"Other",null,null,null,null,null,null,0,0,0]
["Total",null,{"$f":"SUM(C6:C11)","v":0},null,null,null,null,null,{"$f":"SUM(I6:I11)","v":0},null,{"$f":"SUM(K6:K11)","v":0},"(x)"]
[]
["Fodder Available",null,null,null,null,"*","Kg Dry Matter",null,"Meal Feeding"]
["Silage",null,"Tons x ",1000,"x",0.2,{"$f":"B15*1000*0.2","v":0},null,"Planned Meal Feeding",null,{"$f":"I12","v":0},"Fresh wt"]
["Silage",null,"Rd bales x",700,"x",0.3,{"$f":"B16*D16*F16","v":0}]
["Maize",null,"Tons x ",1000,"x",0.25,{"$f":"B17*D17*F17","v":0},null,"Roughage "]
["Straw",null,"Rd bales x",150,"x",0.86,0,null,"Roughage required",null,{"$f":"K12/1000","v":0},"t DM",null,null,null,null,null,null,null,"silage","bales","maize ","grass","grains"]
["Hay",null,"Rd bales x",240,"x",0.86,0,null,null,null,null,null,null,null,null,null,null,null,null,16,20,20,12,16]
["Kale",null,"Tons x ",1000,"x",0.14000000000000001,0,null,"Roughage available",null,{"$f":"G26/1000","v":0},"t DM",null,null,null,null,null,null,null,18,22,22,14,18]
["Home Grains",null,"Tons x ",1000,"x",0.18,{"$f":"B21*D21*F21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,20,24,24,16,20]
["Winter Grass ",null,"Tons x ",1000,"x",0.16,{"$f":"B22*D22*F22","v":0},null,"Surplus/Deficit",null,null,null,null,null,null,null,null,null,null,22,26,26,18,22]
["Other Feeds",null,"Tons x ",1000,"x",null,{"$f":"B23*D23*F23","v":0},null,"Fodder surplus/defecit*  = ",null,{"$f":"K20-K18","v":0},"t DM",null,null,null,null,null,null,null,24,28,28,20,24]
["Other Feeds",null,"Tons x ",1000,"x",null,0,null,"( x - y)  kgs DM",null,null,null,null,null,null,null,null,null,null,26,30,30,22,26]
[null,null,null,null,null,null,null,null,"* A minimum roughage budget must be done if fodder deficit",null,null,null,null,null,null,null,null,null,null,28,32,32,24,28]
["Total kg Dry Matter Available    =             ",null,null,null,null,null,{"$f":"SUM(G15:G25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,30,34,34,null,30]
["* Convert from tons to kg",null,null,null,null,null,"(y)",null,null,null,null,null,null,null,null,null,null,null,null,null,36,36]
["** Use the known Dry Matter (where available)"]
[]
["Recommendations  -  How to Make Up Deficit"]
[]
[]
[]
[]
[]
["Where roughage is very tight and meals are good value, the minimum roguhage that can be fed in terms dry matter is 1% "]
["of body weight.  For example, a 600kg cow must get 6kgs DM roughage per day (600 x 1/100)."]

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

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}