{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["startup","defaults","forage_cost","birth_wean","wean_conception","conception_calving","summary","blank","form_data","lookup_tables","Input sheet"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":4,"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":"startup","index":0,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[13,1,13,8],[14,1,14,8],[15,1,15,8]]}
["Heifer Rearing Cost Calculator "]
["Version 26.08, 15.10"]
[null,"This calculator enables you to calculate the cost of rearing heifers through to the point of calving.  You will be "]
[null,"provided with a summary of the cash cost of rearing heifers on your system, and the full economic cost.  "]
[]
[null,"The calculator is loaded with default values for you, but we suggest you use the actual values for your farm if "]
[null,"they are available.  "]
[]
[null,"It is very important that you read the supporting guidance material for this tool before use.  "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"            Jun",30,31,31,30,31,30,31,31,28,31,30,31]
[null,null,null,null,null,null,null,null,null,null,null,"            Jul",31,31,30,31,30,31,31,28,31,30,31,30]
[null,"AHDB Dairy is a division of the Agricultural and Horticultural Development Board.",null,null,null,null,null,null,null,null,null,"            Aug "]
[null,"While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law, the Agriculture and Horticulture Development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. ",null,null,null,null,null,null,null,null,null,"            Sep",31,30,31,30,31,31,28,31,30,31,30,31]
[null,"© Agriculture and Horticulture Development Board 2015. All rights reserved. ",null,null,null,null,null,null,null,null,null,"            Oct",30,31,30,31,31,28,31,30,31,30,31,31]
[null,null,null,null,null,null,null,null,null,null,null,"            Nov",31,30,31,31,28,31,30,31,30,31,31,30]
[null,null,null,null,null,null,null,null,null,null,null,"            Dec",30,31,31,28,31,30,31,30,31,31,30,31]
[null,null,null,null,null,null,null,null,null,null,null,"            Jan",31,31,28,31,30,31,30,31,31,30,31,30]
[null,null,null,null,null,null,null,null,null,null,null,"            Feb",31,28,31,30,31,30,31,31,30,31,30,31]
[null,null,null,null,null,null,null,null,null,null,null,"            Mar",28,31,30,31,30,31,31,30,31,30,31,31]
[null,null,null,null,null,null,null,null,null,null,null,null,31,30,31,30,31,31,30,31,30,31,31,28]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,12]

{"sheet":"defaults","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[null,null,null,null,null,"Below are the default values which will be used in these calculations.  If you have your own, more accurate figures, "]
[null,null,null,null,null,"you can use them here instead."]
[]
[null,null,null,null,null,"To recall a default value, click the        next to the item heading              indicates the default value is in use"]
[]
[]
[null,null,null,null,null,"Replacement heifer calf value (£/hd)",200,null,null,"Water (£/hd)",29]
[]
[null,null,null,null,null,"Beef calf value (£/hd)",150,null,null,"Electricity (£/hd)",22]
[]
[null,null,null,null,null,"Milk powder (£/T)",1500,null,null,"Consumables (£/hd)",16.5]
[]
[null,null,null,null,null,"Calf starter mix (£/T)",230,null,null,"Interest rate (%)",4]
[]
[null,null,null,null,null,"Rearing concentrate (£/T)",210,null,null,"Land opportunity cost (£/ha)",265]
[]
[null,null,null,null,null,"Feeding straw (£/T)",41,null,null,"AI price (£/service)",50]
[]
[null,null,null,null,null,"Feeding hay (£/T)",50,null,null,"Conception rate to AI (%)",40]
[]
[null,null,null,null,null,"Bedding material (£/T)",36,null,null,"Pregnancy Testing (£/hd)",10]
[]
[null,null,null,null,null,"Disposal cost (£/carcase)",30,null,null,"Milk price (ppl)",21]
[]
[null,null,null,null,null,"Labour cost (£/hr)",10,null,null,"Margin over Puchased Feed (ppl)",15]
[]
[]
[null,null,null,null,null,"Age at first calving (months)",24,null,null,"Mature cow weight (kg)",650]
[]
[null,null,null,null,null,"Age at weaning (weeks)",8,null,null,"Heifer lactation yield (l)",8000]

{"sheet":"forage_cost","index":2,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[]
[]
[null,null,null,null,null,"Forage Cost Calculator"]
[]
[null,null,null,null,null,"Crop Type",null,"Grazing",null,"Grass Silage (3 cuts)",null,"Maize",null,"Wholecrop",null,"Green forage catch crops"]
[null,null,null,null,null,"Crop Life (years)",null,8,null,5,null,1,null,1,null,1]
[]
[]
[null,null,null,null,null,"Establishment Costs",null,"£ / Ha.",null,"£ / Ha.",null,"£ / Ha.",null,"£ / Ha.",null,"£ / Ha."]
[null,null,null,null,null,"Seed",null,150,null,150,null,150,null,59,null,14]
[null,null,null,null,null,"Fertilisers",null,75,null,75,null,190,null,276,null,150]
[null,null,null,null,null,"Sprays& slug pellets",null,30,null,30,null,53,null,186,null,15]
[null,null,null,null,null,"Labour & Machinery:"]
[null,null,null,null,null,"Cultivations (plough, p. harrow, roll)",null,150,null,150,null,150,null,130,null,45]
[null,null,null,null,null,"Sowing",null,30,null,30,null,44,null,46,null,25]
[null,null,null,null,null,"Fertilising",null,14,null,14,null,14,null,28,null,14]
[null,null,null,null,null,"Spraying & slug pelleting",null,13,null,13,null,26,null,50,null,11]
[]
[null,null,null,null,null,"Total Establishment Cost",null,{"$f":"SUM(H21:H28)","v":462},null,{"$f":"SUM(J21:J28)","v":462},null,{"$f":"SUM(L21:L28)","v":627},null,{"$f":"SUM(N21:N28)","v":775},null,{"$f":"SUM(P21:P28)","v":274}]
[null,null,null,null,null,"Establishment cost per year",null,{"$f":"H30/H17","v":57.75},null,{"$f":"J30/J17","v":92.4},null,{"$f":"L30/L17","v":627},null,{"$f":"N30/N17","v":775},null,{"$f":"P30/P17","v":274}]
[]
[]
[null,null,null,null,null,"Production Costs"]
[null,null,null,null,null,"Fertilisers",null,200,null,250,null,0,null,0,null,0]
[null,null,null,null,null,"Sprays",null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,"Additive",null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,"Sundries",null,0,null,20,null,20,null,20,null,0]
[null,null,null,null,null,"Labour & Machinery:"]
[null,null,null,null,null,"Fertilising",null,42,null,56,null,0,null,0,null,0]
[null,null,null,null,null,"Spraying",null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null,"Harvesting",null,0,null,450,null,175,null,166,null,0]
[]
[null,null,null,null,null,"Total Production Cost",null,{"$f":"SUM(H35:H42)","v":242},null,{"$f":"SUM(J35:J42)","v":776},null,195,null,186,null,0]
[]
[]
[null,null,null,null,null,"Rent ",null,180,null,180,null,250,null,250,null,0]
[]
[]
[null,null,null,null,null,"Total forage cost per year",null,{"$f":"H31+H44+H47","v":479.75},null,{"$f":"J31+J44+J47","v":1048.4000000000001},null,{"$f":"L31+L44+L47","v":1072},null,{"$f":"N31+N44+N47","v":1211},null,{"$f":"P31+P44+P47","v":274}]
[]
[]
[null,null,null,null,null,"Tonnes DM produced per Ha.",null,9,null,11,null,11,null,11,null,8]
[null,null,null,null,null,"Cost per tonne DM",null,{"$f":"IF(H53=\"\",\"\",H50/H53)","v":53.305555555555557},null,{"$f":"IF(J53=\"\",\"\",J50/J53)","v":95.309090909090912},null,{"$f":"IF(L53=\"\",\"\",L50/L53)","v":97.454545454545453},null,{"$f":"IF(N53=\"\",\"\",N50/N53)","v":110.09090909090909},null,{"$f":"IF(P53=\"\",\"\",P50/P53)","v":34.25}]
[null,null,null,null,null,"Dry Matter %",null,18,null,30,null,30,null,45]
[null,null,null,null,null,"Cost per tonne fresh",null,{"$f":"H54*(H55/100)","v":9.5950000000000006},null,{"$f":"J54*(J55/100)","v":28.592727272727274},null,{"$f":"L54*(L55/100)","v":29.236363636363635},null,{"$f":"N54*(N55/100)","v":49.540909090909096},null,{"$f":"P54*(P55/100)","v":0}]
[]
[]
[null,null,null,null,null,"Forage Quallity (populated from user form) "]
[null,null,null,null,null,"DM",null,null,null,"30",null,"33",null,"35"]
[null,null,null,null,null,"CP",null,null,null,"12",null,"8",null,"8"]
[null,null,null,null,null,"NDF",null,null,null,"45",null,"40",null,"45"]
[null,null,null,null,null,"ME",null,null,null,"11",null,"11.3",null,"10.5"]
[]
[]
[null,null,null,null,null,"Forages Grown (populated from T/ha grown above) "]
[null,null,null,null,null,"Grass Silage ",{"$f":"IF($J$53=\"\",\"\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,"Maize Silage",{"$f":"IF($L$53=\"\",\"\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,"Wholecrop Silage",{"$f":"IF($N$53=\"\",\"\",\"Yes\")","v":"Yes"}]

{"sheet":"birth_wean","index":3,"n_rows":141,"n_cols":15,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[]
[]
[null,null,null,null,null,{"$f":"\" Birth to Weaning  (\"& INT(G82) &\" kg at weaning)\"","v":" Birth to Weaning  (81 kg at weaning)"}]
[]
[null,null,null,null,null,"Based on the information you have entered, we have calculated your birth to weaning period costs as follows: "]
[null,null,null,null,null,null,null,null,null,null,null,"Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Source "]
[]
[null,null,null,null,null,null,null,null,null,"Quantity",null,"£"]
[null,null,null,null,null,null,"Calf value ",null,null,null,null,{"$f":"defaults!G19","v":200}]
[]
[null,null,null,null,null,null,"Milk Powder",null,null,{"$f":"LEFT(K42,3) & \" kg\"","v":"0 kg"},null,{"$f":"IF(form_data!E16=\"\",birth_wean!L42,(form_data!E16/1000)*defaults!G23)","v":0}]
[null,null,null,null,null,null,null,"Age","powder/day (g)","days ","powder (kg)","Total £"]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$21","v":"1-9 days"},{"$f":"IF(form_data!F21=\"\",0,form_data!F21*form_data!G21)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I36*J36/1000","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"IF(form_data!F22=\"\",0,form_data!F22*form_data!G22)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I37*J37/1000","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$23","v":"19-27 days"},{"$f":"IF(form_data!F23=\"\",0,form_data!F23*form_data!G23)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$24","v":"28-36 days"},{"$f":"IF(form_data!F24=\"\",0,form_data!F24*form_data!G24)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$25","v":"37-45 days"},{"$f":"IF(form_data!F25=\"\",0,form_data!F25*form_data!G25)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$26","v":"46-54 days"},{"$f":"IF(form_data!F26=\"\",0,form_data!F26*form_data!G26)","v":0},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!E16=\"\",SUM(K36:K41),form_data!E16)","v":0},{"$f":"K42/1000*defaults!G23","v":0}]
[]
[null,null,null,null,null,null,"Whole Milk ",null,null,{"$f":"LEFT(K52,3)&\" litres\"","v":"0 litres"},null,{"$f":"IF(form_data!F16=\"\",birth_wean!L52,form_data!F16*(defaults!K35/100))","v":0}]
[null,null,null,null,null,null,null,"Age","litres/day","days ","total litres","Total £"]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$21","v":"1-9 days"},{"$f":"form_data!H21","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"IF(I46=\"\",0,I46*J46)","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"form_data!H22","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"IF(I47=\"\",0,I47*J47)","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$23","v":"19-27 days"},null,{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$24","v":"28-36 days"},null,{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$25","v":"37-45 days"},null,{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$26","v":"46-54 days"},null,{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!F16=\"\",SUM(K46:K51),form_data!F16)","v":0},{"$f":"K52*(defaults!K35/100)","v":0}]
[]
[null,null,null,null,null,null,"Calf starter",null,null,{"$f":"LEFT(K62,3) & \" kg\"","v":"0 kg"},null,{"$f":"IF(form_data!G16=\"\",birth_wean!L62,form_data!G16*defaults!G25/1000)","v":0}]
[null,null,null,null,null,null,null,"Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$21","v":"1-9 days"},{"$f":"form_data!I21","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"IF(I56=\"\",0,I56*J56)","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"form_data!I22","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"IF(I57=\"\",0,I57*J57)","v":0}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$23","v":"19-27 days"},{"$f":"form_data!I23","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$24","v":"28-36 days"},{"$f":"form_data!I24","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$25","v":"37-45 days"},{"$f":"form_data!I25","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$26","v":"46-54 days"},{"$f":"form_data!I26","v":""},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!G16=\"\",SUM(K56:K61),(form_data!G16))","v":0},{"$f":"(K62/1000)*defaults!G25","v":0}]
[]
[null,null,null,null,null,null,"Bedding",null,null,{"$f":"LEFT(K72,3) & \" kg\"","v":"65. kg"},null,{"$f":"IF(form_data!D16=\"\",birth_wean!L72,form_data!D16*defaults!G33/1000)","v":2.3520000000000003}]
[null,null,null,null,null,null,null,"Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$21","v":"1-9 days"},{"$f":"IF(form_data!D21=TRUE,1,\"0\")","v":1},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I66*J66","v":9.3333333333333339}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"IF(form_data!D22=TRUE,1,\"0\")","v":1},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I67*J67","v":9.3333333333333339}]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$23","v":"19-27 days"},{"$f":"IF(form_data!D23=TRUE,1,\"0\")","v":1},{"$f":"form_data!$C$9","v":9.3333333333333339},9.3333333333333339]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$24","v":"28-36 days"},1.25,{"$f":"form_data!$C$9","v":9.3333333333333339},11.666666666666668]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$25","v":"37-45 days"},1.25,{"$f":"form_data!$C$9","v":9.3333333333333339},11.666666666666668]
[null,null,null,null,null,null,null,{"$f":"form_data!$C$26","v":"46-54 days"},1.5,{"$f":"form_data!$C$9","v":9.3333333333333339},14]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!D16=\"\",SUM(K66:K71),(form_data!D16))","v":65.333333333333343},{"$f":"(K72/1000)*defaults!G33","v":2.3520000000000003}]
[]
[]
[null,null,null,null,null,null,"Feed straw",null,null,{"$f":"LEFT(K83,3)&\" kg\"","v":"31. kg"},null,{"$f":"IF(form_data!H16=\"\",birth_wean!L83,form_data!H16*defaults!G29/1000)","v":1.2915478333333335}]
[null,null,null,null,null,"age (wks)","lwt","Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,{"$f":"INT((J77/7)+0.35)","v":1},{"$f":"(VLOOKUP(F77,lookup_tables!A12:C116,2,TRUE))*defaults!$K$40/100","v":46.15},{"$f":"form_data!$C$21","v":"1-9 days"},0,{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I77*J77","v":0}]
[null,null,null,null,null,{"$f":"INT((J78*2/7))","v":2},{"$f":"(VLOOKUP(F78,lookup_tables!A13:C117,2,TRUE))*defaults!$K$40/100","v":52},{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"IF(form_data!J22=TRUE,IF(form_data!L22=TRUE,G78*0.005,G78*0.01),\"0\")","v":0.52},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I78*J78","v":4.8533333333333335}]
[null,null,null,null,null,{"$f":"INT((J79*3/7))","v":4},{"$f":"(VLOOKUP(F79,lookup_tables!A14:C118,2,TRUE))*defaults!$K$40/100","v":63.70000000000001},{"$f":"form_data!$C$23","v":"19-27 days"},{"$f":"IF(form_data!J23=TRUE,IF(form_data!L23=TRUE,G79*0.005,G79*0.01),\"0\")","v":0.63700000000000012},{"$f":"form_data!$C$9","v":9.3333333333333339},5.9453333333333349]
[null,null,null,null,null,{"$f":"INT((J80*4/7))","v":5},{"$f":"(VLOOKUP(F80,lookup_tables!A15:C119,2,TRUE))*defaults!$K$40/100","v":68.087500000000006},{"$f":"form_data!$C$24","v":"28-36 days"},{"$f":"IF(form_data!J24=TRUE,IF(form_data!L24=TRUE,G80*0.005,G80*0.01),\"0\")","v":0.68087500000000012},{"$f":"form_data!$C$9","v":9.3333333333333339},6.3548333333333344]
[null,null,null,null,null,{"$f":"INT((J81*5/7))","v":6},{"$f":"(VLOOKUP(F81,lookup_tables!A16:C120,2,TRUE))*defaults!$K$40/100","v":72.474999999999994},{"$f":"form_data!$C$25","v":"37-45 days"},{"$f":"IF(form_data!J25=TRUE,IF(form_data!L25=TRUE,G81*0.005,G81*0.01),\"0\")","v":0.72475000000000001},{"$f":"form_data!$C$9","v":9.3333333333333339},6.764333333333334]
[null,null,null,null,null,{"$f":"INT((J82*6/7))","v":8},{"$f":"(VLOOKUP(F82,lookup_tables!A17:C121,2,TRUE))*defaults!$K$40/100","v":81.25},{"$f":"form_data!$C$26","v":"46-54 days"},{"$f":"IF(form_data!J26=TRUE,IF(form_data!L26=TRUE,G82*0.005,G82*0.01),\"0\")","v":0.8125},{"$f":"form_data!$C$9","v":9.3333333333333339},7.5833333333333339]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!H16=\"\",SUM(K77:K82),(form_data!H16))","v":31.50116666666667},{"$f":"(K83/1000)*defaults!G29","v":1.2915478333333335}]
[]
[null,null,null,null,null,null,"Feed hay",null,null,{"$f":"LEFT(K93,3)&\" kg\"","v":"0 kg"},null,{"$f":"IF(form_data!I16=\"\",birth_wean!L93,form_data!I16*defaults!G31/1000)","v":0}]
[null,null,null,null,null,"age (wks)","lwt","Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,{"$f":"INT((J87/7)+0.35)","v":1},{"$f":"wean_conception!N2","v":0},{"$f":"form_data!$C$21","v":"1-9 days"},0,{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I87*J87","v":0}]
[null,null,null,null,null,{"$f":"INT((J88*2/7))","v":2},{"$f":"(VLOOKUP(F88,lookup_tables!A13:C117,2,TRUE))*defaults!$K$40/100","v":52},{"$f":"form_data!$C$22","v":"10-18 days"},{"$f":"IF(form_data!L22=TRUE,IF(form_data!J22=TRUE,G88*0.005,G88*0.01),\"0\")","v":"0"},{"$f":"form_data!$C$9","v":9.3333333333333339},{"$f":"I88*J88","v":0}]
[null,null,null,null,null,{"$f":"INT((J89*3/7))","v":4},{"$f":"(VLOOKUP(F89,lookup_tables!A14:C118,2,TRUE))*defaults!$K$40/100","v":63.70000000000001},{"$f":"form_data!$C$23","v":"19-27 days"},{"$f":"IF(form_data!L23=TRUE,IF(form_data!J23=TRUE,G89*0.005,G89*0.01),\"0\")","v":"0"},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,{"$f":"INT((J90*4/7))","v":5},{"$f":"(VLOOKUP(F90,lookup_tables!A15:C119,2,TRUE))*defaults!$K$40/100","v":68.087500000000006},{"$f":"form_data!$C$24","v":"28-36 days"},{"$f":"IF(form_data!L24=TRUE,IF(form_data!J24=TRUE,G90*0.005,G90*0.01),\"0\")","v":"0"},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,{"$f":"INT((J91*5/7))","v":6},{"$f":"(VLOOKUP(F91,lookup_tables!A16:C120,2,TRUE))*defaults!$K$40/100","v":72.474999999999994},{"$f":"form_data!$C$25","v":"37-45 days"},{"$f":"IF(form_data!L25=TRUE,IF(form_data!J25=TRUE,G91*0.005,G91*0.01),\"0\")","v":"0"},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,{"$f":"INT((J92*6/7))","v":8},{"$f":"(VLOOKUP(F92,lookup_tables!A17:C121,2,TRUE))*defaults!$K$40/100","v":81.25},{"$f":"form_data!$C$26","v":"46-54 days"},{"$f":"IF(form_data!L26=TRUE,IF(form_data!J26=TRUE,G92*0.005,G92*0.01),\"0\")","v":"0"},{"$f":"form_data!$C$9","v":9.3333333333333339},0]
[null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!I16=\"\",SUM(K87:K92),(form_data!I16))","v":0},{"$f":"(K93/1000)*defaults!G31","v":0}]
[]
[null,null,null,null,null,null,"Vet & Med, inc Vaccinations",null,null,null,null,12.5]
[]
[null,null,null,null,null,null,"Sundries (milk mixing equipment, water heating)",null,null,null,null,{"$f":"defaults!K23/3","v":5.5}]
[]
[null,null,null,null,null,null,"Mortality Rate",null,null,null,10.5]
[]
[null,null,null,null,null,null,"Mortality Cost (incl carcass disposal)",null,null,null,null,{"$f":"(defaults!$G$19+(SUM(L34,L44,L54,L64,L75,L85,L95,L97)))*(birth_wean!K99/100)+defaults!G35*birth_wean!K99/100","v":26.422572522499998}]
[null,null,null,null,null,null,"Water",null,null,null,null,{"$f":"defaults!K19/(defaults!G40*4.3)*defaults!G42","v":2.2480620155038764}]
[null,null,null,null,null,null,"Power & Machinery (incl electricity, excluding forage costs)",null,null,null,null,10]
[null,null,null,null,null,null,"Labour (includes bedding and cleaning out)",null,null,null,null,25]
[]
[null,null,null,null,null,"Feed Inputs Check:"]
[]
[null,null,null,null,null,null,null,"Mature cow body weight",{"$f":"defaults!K40","v":650},"Age at wean",{"$f":"defaults!G42","v":8},"Avg % of mature weight in period",null,null,{"$f":"(VLOOKUP(8,lookup_tables!A12:C116,2,TRUE)+VLOOKUP(1,lookup_tables!A12:C116,2,TRUE))/2","v":9.8000000000000007}]
[]
[null,null,null,null,null,"Average Weight in this period",null,null,null,{"$f":"I108*(O108/100)","v":63.7},"kg"]
[]
[null,null,null,null,null,"Average feed/day (kgDM)",null,null,null,{"$f":"((K42*0.95)+(K52*0.13)+(K62*0.87)+(K83*0.85)+(K93*0.85))/(defaults!$G$42*7)","v":0.47814270833333339},"Assumed 13% solids in whole milk. Conc 87% DM, Straw & hay 85% DM, milk powder 95%"]
[]
[null,null,null,null,null,"Target at 3% BW (kgDM)",null,null,null,{"$f":"J110*0.03","v":1.911}]
[]
[null,null,null,null,null,"Intake indicator",null,null,null,{"$f":"IF(J112>(J114*1.1),\"High\",IF(J112<(J114*0.9),\"Low\",\"OK\"))","v":"Low"},"If this cell = High or Low then a message needs to be shown to the user"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rearing cost for this period",null,null,null,null,{"$f":"SUM(L34:L104)","v":88.95773020467054}]
[null,null,null,null,null,null,"Rearing cost per day in this period ",null,null,null,null,{"$f":"L139/(defaults!G42*7)","v":1.588530896511974}]
[null,null,null,null,null,null,"Total cost to this stage including calf value",null,null,null,null,{"$f":"L139+L32","v":288.95773020467055}]

{"sheet":"wean_conception","index":4,"n_rows":160,"n_cols":36,"rows_kept":160,"cut":false,"hidden":false,"merged":[[48,20,48,23],[48,24,48,27],[48,28,48,31],[48,32,48,33],[48,34,48,35]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[]
[]
[null,null,null,null,null,{"$f":" \"Weaning to Conception  (\" & INT(N23) & \"kg to \" & INT(N24) & \" kg)\"","v":"Weaning to Conception  (81kg to 380 kg)"}]
[]
[null,null,null,null,null,"Based on the information you have entered, we have calculated your weaning to conception period costs as follows: "]
[null,null,null,null,null,null,null,null,null,null,null,"costs"]
[]
[]
[null,null,null,null,null,null,"Age at Conception",null,null,null,null,null,null,{"$f":"(defaults!G40*4.33)-(274/7)","v":64.777142857142849},"wks"]
[null,null,null,null,null,null,"Number of weeks in Weaning to Conception Group",null,null,null,null,null,null,{"$f":"N21-defaults!G42","v":56.777142857142849},"wks"]
[null,null,null,null,null,null,"weight at weaning",null,null,null,null,null,null,{"$f":"(VLOOKUP(defaults!G42,lookup_tables!$A$12:$C$116,3,TRUE))","v":81.25},"kg"]
[null,null,null,null,null,null,{"$f":" \"weight at   \" & INT(N21+0.5)  & \"  weeks\"","v":"weight at   65  weeks"},null,null,null,null,null,null,{"$f":"(VLOOKUP(N21,lookup_tables!A14:C118,3,TRUE))","v":380.41249999999997},"kg"]
[null,null,null,null,null,null,"average daily weight gain required",null,null,null,null,null,null,{"$f":"(N24-N23)/N22/7","v":0.75272368156199676},"kg/d"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Forage cost","T Fresh","T DM",null,null,"£"]
[null,null,null,null,null,null,"Grass Silage",{"$f":"IF(I33=\"\",0,I33/forage_cost!J60*100)","v":0.73889565707094784},{"$f":"IF(form_data!E116>0,form_data!E116,X57*1.15)","v":0.22166869712128434},null,null,{"$f":"IF(I33=\"\",0,I33*forage_cost!J54)","v":21.127042005632227}]
[null,null,null,null,null,null,"Maize Silage",{"$f":"IF(I34=\"\",0,I34/forage_cost!J61*100)","v":0},{"$f":"IF(form_data!F116>0,form_data!F116,AB57*1.15)","v":0},null,null,{"$f":"IF(I34=\"\",0,I34*forage_cost!J55)","v":0}]
[null,null,null,null,null,null,"Wholecrop",{"$f":"IF(I35=\"\",0,I35/forage_cost!J62*100)","v":0},{"$f":"IF(form_data!G116>0,form_data!G116,AF57*1.15)","v":0},null,null,{"$f":"IF(I35=\"\",0,I35*forage_cost!J56)","v":0}]
[null,null,null,null,null,null,"Grazing",null,{"$f":"IF(form_data!I116>0,form_data!I116,AH57*1.15)","v":0},null,null,{"$f":"I36*forage_cost!H54","v":0}]
[null,null,null,null,null,null,"Green crop",null,{"$f":"IF(form_data!J116>0,form_data!J116,AJ57*1.15)","v":0},null,null,{"$f":"I37*forage_cost!P54","v":0}]
[null,null,null,null,null,null,"Total forage costs",null,null,null,null,{"$f":"SUM(L33:L37)","v":21.127042005632227}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if both green crop and grazing assume 50% of each"]
[null,null,null,null,null,null,"Avg Age (wks) ","Bodyweight","DMI ","Conc DM","WT gain","MEm Req","MEg","Total ME","ME from conc","Me Req from forage","combined Forage ME","Forage DMI","Weighted DM","Total Forage ","Grass Silage",null,null,null,"Maize",null,null,null,"Wholecrop ",null,null,null,"Grazing",null,"Green Crop"]
[null,null,null,null,null,null,null,"kg","kg","kg/d","kg/d","MJ/d","MJ/d","MJ/d","MJ","MJ","MJ/kg DM","Req kg","of all forage","Fresh Weight","%","kg Fresh","kgDM","Total T","%","kg fresh","kgDM","Total T","%","kg Fresh","kgDM","T Total","kg dm/d","t dm",null,"t dm"]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B124,form_data!B125)","v":12.5},{"$f":"VLOOKUP(G51,lookup_tables!$A$12:$C$116,3,TRUE)","v":105.95},{"$f":"H51*0.03","v":3.1785000000000001},{"$f":"J63*0.87","v":0},{"$f":"$N$25","v":0.75272368156199676},{"$f":"1.05*(0.53*(H51/1.08)^0.67)/((0.35*(11/18)+0.503))","v":16.76629283396618},{"$f":"1.05*$N$25*(6.28+0.0188*H51)/(1-0.3*$N$25)/0.5","v":16.889409972578029},{"$f":"L51+M51","v":33.655702806544213},{"$f":"J51*12.5","v":0},{"$f":"N51-O51","v":33.655702806544213},{"$f":"form_data!F121*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G121*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H121*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":11},{"$f":"IF(Q51=0,0,P51/Q51)","v":3.059609346049474},{"$f":"(forage_cost!$J$60*(wean_conception!U51/100))+(forage_cost!$L$60*(wean_conception!Y51/100))+(forage_cost!$N$60*(wean_conception!AC51/100))","v":30},{"$f":"IF(S51=0,0,R51/(S51/100))","v":10.198697820164913},{"$f":"IF(form_data!F121=\"\",0,form_data!F121)","v":"100"},{"$f":"$T51*(U51/100)","v":10.198697820164913},{"$f":"V51*(forage_cost!$J$60/100)","v":3.059609346049474},{"$f":"(W51*K63)/1000","v":0.19275538880111684},{"$f":"IF(form_data!G121=\"\",0,form_data!G121)","v":0},{"$f":"T51*(Y51/100)","v":0},{"$f":"Z51*(forage_cost!$L$60/100)","v":0},{"$f":"(AA51*K63)/1000","v":0},{"$f":"IF(form_data!H121=\"\",0,form_data!H121)","v":0},{"$f":"$T51*(AC51/100)","v":0},{"$f":"AD51*(forage_cost!$N$60/100)","v":0},{"$f":"(AE51*K63)/1000","v":0},{"$f":"IF(form_data!J121=FALSE,0,IF(form_data!L121=FALSE,P51/11,P51/2/11))","v":0},{"$f":"AG51*K63/1000","v":0},{"$f":"IF(form_data!L121=FALSE,0,IF(form_data!J121=FALSE,P51/11,P51/2/11))","v":0},{"$f":"AI51*K63/1000","v":0}]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B125,form_data!B126)","v":21.5},{"$f":"VLOOKUP(G52,lookup_tables!$A$12:$C$116,3,TRUE)","v":154.04999999999998},{"$f":"H52*0.03","v":4.6214999999999993},{"$f":"J64*0.87","v":0},{"$f":"$N$25","v":0.75272368156199676},{"$f":"1.05*(0.53*(H52/1.08)^0.67)/((0.35*(11/18)+0.503))","v":21.545309839931502},{"$f":"1.05*$N$25*(6.28+0.0188*H52)/(1-0.3*$N$25)/0.5","v":18.735760811446539},{"$f":"L52+M52","v":40.281070651378045},{"$f":"J52*12.5","v":0},{"$f":"N52-O52","v":40.281070651378045},{"$f":"form_data!F122*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G122*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H122*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},{"$f":"IF(Q52=0,0,P52/Q52)","v":0},{"$f":"(forage_cost!$J$60*(wean_conception!U52/100))+(forage_cost!$L$60*(wean_conception!Y52/100))+(forage_cost!$N$60*(wean_conception!AC52/100))","v":0},{"$f":"IF(S52=0,0,R52/(S52/100))","v":0},{"$f":"IF(form_data!F122=\"\",0,form_data!F122)","v":0},0,{"$f":"V52*(forage_cost!$J$60/100)","v":0},0,{"$f":"IF(form_data!G122=\"\",0,form_data!G122)","v":0},{"$f":"T52*(Y52/100)","v":0},{"$f":"Z52*(forage_cost!$L$60/100)","v":0},0,{"$f":"IF(form_data!H122=\"\",0,form_data!H122)","v":0},0,{"$f":"AD52*(forage_cost!$N$60/100)","v":0},0,{"$f":"IF(form_data!J122=FALSE,0,IF(form_data!L122=FALSE,P52/11,P52/2/11))","v":0},{"$f":"AG52*K64/1000","v":0},{"$f":"IF(form_data!L122=FALSE,0,IF(form_data!J122=FALSE,P52/11,P52/2/11))","v":0},{"$f":"AI52*K64/1000","v":0}]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B126,form_data!B127)","v":30.5},{"$f":"VLOOKUP(G53,lookup_tables!$A$12:$C$116,3,TRUE)","v":202.96249999999998},6.0888749999999989,0,0.75272368156199676,25.917194721697133,20.613300009079719,46.530494730776851,0,46.530494730776851,{"$f":"form_data!F123*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G123*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H123*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},0,{"$f":"(forage_cost!$J$60*(wean_conception!U53/100))+(forage_cost!$L$60*(wean_conception!Y53/100))+(forage_cost!$N$60*(wean_conception!AC53/100))","v":0},{"$f":"IF(S53=0,0,R53/(S53/100))","v":0},{"$f":"IF(form_data!F123=\"\",0,form_data!F123)","v":0},0,{"$f":"V53*(forage_cost!$J$60/100)","v":0},0,{"$f":"IF(form_data!G123=\"\",0,form_data!G123)","v":0},0,{"$f":"Z53*(forage_cost!$L$60/100)","v":0},0,{"$f":"IF(form_data!H123=\"\",0,form_data!H123)","v":0},0,{"$f":"AD53*(forage_cost!$N$60/100)","v":0},0,{"$f":"IF(form_data!J123=FALSE,0,IF(form_data!L123=FALSE,P53/11,P53/2/11))","v":0},0,{"$f":"IF(form_data!L123=FALSE,0,IF(form_data!J123=FALSE,P53/11,P53/2/11))","v":0},0]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B127,form_data!B128)","v":39.5},{"$f":"VLOOKUP(G54,lookup_tables!$A$12:$C$116,3,TRUE)","v":241.15},7.2344999999999997,0,0.75272368156199676,29.090545934343815,22.079152871019247,51.169698805363062,0,51.169698805363062,{"$f":"form_data!F124*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G124*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H124*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},0,{"$f":"(forage_cost!$J$60*(wean_conception!U54/100))+(forage_cost!$L$60*(wean_conception!Y54/100))+(forage_cost!$N$60*(wean_conception!AC54/100))","v":0},0,{"$f":"IF(form_data!F124=\"\",0,form_data!F124)","v":0},0,{"$f":"V54*(forage_cost!$J$60/100)","v":0},0,{"$f":"IF(form_data!G124=\"\",0,form_data!G124)","v":0},0,{"$f":"Z54*(forage_cost!$L$60/100)","v":0},0,{"$f":"IF(form_data!H124=\"\",0,form_data!H124)","v":0},0,{"$f":"AD54*(forage_cost!$N$60/100)","v":0},0,{"$f":"IF(form_data!J124=FALSE,0,IF(form_data!L124=FALSE,P54/11,P54/2/11))","v":0},0,{"$f":"IF(form_data!L124=FALSE,0,IF(form_data!J124=FALSE,P54/11,P54/2/11))","v":0},0]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B128,form_data!B129)","v":48.5},{"$f":"VLOOKUP(G55,lookup_tables!$A$12:$C$116,3,TRUE)","v":283.39999999999998},8.5019999999999989,0,0.75272368156199676,32.413602356287328,23.700947526782127,56.114549883069458,0,56.114549883069458,{"$f":"form_data!F125*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G125*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H125*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},0,{"$f":"(forage_cost!$J$60*(wean_conception!U55/100))+(forage_cost!$L$60*(wean_conception!Y55/100))+(forage_cost!$N$60*(wean_conception!AC55/100))","v":0},0,{"$f":"IF(form_data!F125=\"\",0,form_data!F125)","v":0},0,{"$f":"V55*(forage_cost!$J$60/100)","v":0},0,{"$f":"IF(form_data!G125=\"\",0,form_data!G125)","v":0},0,{"$f":"Z55*(forage_cost!$L$60/100)","v":0},0,{"$f":"IF(form_data!H125=\"\",0,form_data!H125)","v":0},0,{"$f":"AD55*(forage_cost!$N$60/100)","v":0},0,{"$f":"IF(form_data!J125=FALSE,0,IF(form_data!L125=FALSE,P55/11,P55/2/11))","v":0},0,{"$f":"IF(form_data!L125=FALSE,0,IF(form_data!J125=FALSE,P55/11,P55/2/11))","v":0},0]
[null,null,null,null,null,null,{"$f":"AVERAGE(form_data!B129,form_data!B130)","v":53},{"$f":"VLOOKUP(G56,lookup_tables!$A$12:$C$116,3,TRUE)","v":318.98750000000001},9.5696250000000003,0,0.75272368156199676,35.087122951416518,25.066997640674703,60.154120592091218,0,60.154120592091218,{"$f":"form_data!F126*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G126*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H126*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},0,{"$f":"(forage_cost!$J$60*(wean_conception!U56/100))+(forage_cost!$L$60*(wean_conception!Y56/100))+(forage_cost!$N$60*(wean_conception!AC56/100))","v":0},0,{"$f":"IF(form_data!F126=\"\",0,form_data!F126)","v":0},0,{"$f":"V56*(forage_cost!$J$60/100)","v":0},0,{"$f":"IF(form_data!G126=\"\",0,form_data!G126)","v":0},0,{"$f":"Z56*(forage_cost!$L$60/100)","v":0},0,{"$f":"IF(form_data!H126=\"\",0,form_data!H126)","v":0},0,{"$f":"AD56*(forage_cost!$N$60/100)","v":0},0,{"$f":"IF(form_data!J126=FALSE,0,IF(form_data!L126=FALSE,P56/11,P56/2/11))","v":0},0,{"$f":"IF(form_data!L126=FALSE,0,IF(form_data!J126=FALSE,P56/11,P56/2/11))","v":0},0]
[null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X51:X56)","v":0.19275538880111684},null,null,null,{"$f":"SUM(AB51:AB56)","v":0},null,null,null,{"$f":"SUM(AF51:AF56)","v":0},null,{"$f":"SUM(AH51:AH56)","v":0},null,{"$f":"SUM(AJ51:AJ56)","v":0}]
[]
[]
[null,null,null,null,null,null,"Concentrates ",null,{"$f":"IF(form_data!H116>0,form_data!H116*1000,L69)","v":0},"kg",null,{"$f":"M69","v":0}]
[]
[null,null,null,null,null,null,null,null,"Age (wks)","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C121","v":"8 - 17"},{"$f":"IF(form_data!I121=\"\",0,form_data!I121)","v":0},{"$f":"form_data!$B$123*7","v":63},{"$f":"IF(J63=\"\",0,J63*K63)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C122","v":"17 - 26"},{"$f":"IF(form_data!I122=\"\",0,form_data!I122)","v":0},{"$f":"form_data!$B$123*7","v":63},{"$f":"IF(J64=\"\",0,J64*K64)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C123","v":"26 - 35"},{"$f":"IF(form_data!I123=\"\",0,form_data!I123)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C124","v":"35 - 44"},{"$f":"IF(form_data!I124=\"\",0,form_data!I124)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C125","v":"44 - 53"},{"$f":"IF(form_data!I125=\"\",0,form_data!I125)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,null,null,{"$f":"form_data!C126","v":"53 - Conception"},{"$f":"IF(form_data!I126=\"\",0,form_data!I126)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!H116=0,SUM(L63:L68),(form_data!H116*1000))","v":0},{"$f":"(L69/1000)*defaults!G27","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"Bedding cost",null,{"$f":"J82","v":1102.5},"kg",null,{"$f":"K82","v":39.69}]
[]
[null,null,null,null,null,null,"Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,{"$f":"I63","v":"8 - 17"},2,{"$f":"K63","v":63},{"$f":"H76*I76","v":126}]
[null,null,null,null,null,null,{"$f":"I64","v":"17 - 26"},2.5,{"$f":"K64","v":63},{"$f":"H77*I77","v":157.5}]
[null,null,null,null,null,null,"26 - 35",3,63,189]
[null,null,null,null,null,null,"35 - 44",3,63,189]
[null,null,null,null,null,null,"44 - 53",3.5,63,220.5]
[null,null,null,null,null,null,"53 - Conception",3.5,63,220.5]
[null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!D116=0,SUM(J76:J81),(form_data!D116*1000))","v":1102.5},{"$f":"(J82/1000)*defaults!$G$33","v":39.69}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Vet & Med, inc Vacc",null,null,null,null,12]
[null,null,null,null,null,null,"AI costs",null,null,null,null,{"$f":"(defaults!K29/defaults!K31*100) +defaults!K33","v":135}]
[null,null,null,null,null,null,"Sundries ",null,null,null,null,{"$f":"defaults!K23/3","v":5.5}]
[]
[null,null,null,null,null,null,"Mortality Rate",null,null,3.4,"%"]
[]
[null,null,null,null,null,null,"Mortality Cost (incl carcass disposal)",null,null,null,null,{"$f":"((SUM(L38:L111)*0.5)+birth_wean!L141)*J113/100 + defaults!G35*wean_conception!J113/100","v":17.204893707894467}]
[null,null,null,null,null,null,"Water",null,null,null,null,{"$f":"defaults!K19/(defaults!G40*4.3)*wean_conception!N22","v":15.954817275747509}]
[null,null,null,null,null,null,"Power & Machinery (incl electricity, excluding forage costs)",null,null,null,null,15]
[null,null,null,null,null,null,"Labour (includes bedding and cleaning out)",null,null,null,null,75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total cost of this period",null,null,null,null,{"$f":"SUM(L38,L60,L73,L109,L110,L111,L115,L116,L117,L118)","v":336.47675298927419}]
[]
[null,null,null,null,null,null,"Total cost per day in this period ",null,null,null,null,{"$f":"L157/(N22*7)","v":0.84661018767430107}]
[null,null,null,null,null,null,"Total cost to this stage including calf value",null,null,null,null,{"$f":"L157+birth_wean!L141","v":625.43448319394474}]

{"sheet":"conception_calving","index":5,"n_rows":126,"n_cols":38,"rows_kept":126,"cut":false,"hidden":false,"merged":[[39,22,39,25],[39,26,39,29],[39,30,39,33],[39,34,39,35],[39,36,39,37]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[]
[]
[null,null,null,null,null,{"$f":"\"Conception to Calving (\" & INT(M19) & \"kg to \" & INT(M20) & \"kg)\"","v":"Conception to Calving (380kg to 586kg)"}]
[]
[null,null,null,null,null,"Based on the information you have entered, we have calculated your conception to calving period costs as follows: "]
[]
[null,null,null,null,null,null,null,null,null,null,"Wt entering this group",null,{"$f":"wean_conception!N24","v":380.41249999999997},"kg"]
[null,null,null,null,null,null,"Age at Calving",null,{"$f":"defaults!G40*4.33","v":103.92},"weeks","Wt at calving",null,{"$f":"(VLOOKUP(I20,lookup_tables!A12:C116,3,TRUE))","v":586.1171875},"kg","DLW in this group",null,{"$f":"(M20-M19)/(I21*7)","v":0.75074703467153292}]
[null,null,null,null,null,null,"Weeks in group",null,{"$f":"274/7","v":39.142857142857146}]
[null,null,null,null,null,null,"Weeks in late preg",null,{"$f":"I21/3","v":13.047619047619049},{"$f":"I20-I22","v":90.872380952380951},"weeks to",{"$f":"I20","v":103.92},"weeks = ",{"$f":"AVERAGE(L22,J22)","v":97.396190476190469},"Avg Age Late Preg"]
[null,null,null,null,null,null,"Weeks in mid preg",null,{"$f":"I21/3","v":13.047619047619049},{"$f":"L23-I23","v":77.8247619047619},"weeks to",{"$f":"J22","v":90.872380952380951},"weeks = ",{"$f":"AVERAGE(L23,J23)","v":84.348571428571432},"Avg Age Mid Preg"]
[null,null,null,null,null,null,"Weeks in early preg",null,{"$f":"I21/3","v":13.047619047619049},{"$f":"L24-I24","v":64.777142857142849},"weeks to",{"$f":"J23","v":77.8247619047619},"weeks = ",{"$f":"AVERAGE(L24,J24)","v":71.300952380952367},"Avg Age Early Preg"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"costs"]
[null,null,null,null,null,null,"Forage cost",null,"T Fresh","T DM",null,"£"]
[null,null,null,null,null,null,"Grass Silage",null,{"$f":"J34/forage_cost!J60*100","v":9.99780521349855},{"$f":"IF(form_data!E216>0,form_data!E216*forage_cost!J60/100,Z45*1.15)","v":2.9993415640495646},null,{"$f":"J34*forage_cost!J54","v":285.86451779541488}]
[null,null,null,null,null,null,"Maize Silage",null,{"$f":"J35/forage_cost!L60*100","v":0},{"$f":"IF(form_data!F216>0,form_data!F216*forage_cost!L60/100,AD45*1.15)","v":0},null,{"$f":"J35*forage_cost!L54","v":0}]
[null,null,null,null,null,null,"Wholecrop",null,{"$f":"J36/forage_cost!N60*100","v":0},{"$f":"IF(form_data!G216>0,form_data!G216*forage_cost!N60/100,AH45*1.15)","v":0},null,{"$f":"J36*forage_cost!N54","v":0}]
[null,null,null,null,null,null,"Grazing",null,null,{"$f":"IF(form_data!I216>0,form_data!I216,AJ45*1.15)","v":0.68341093502579475},null,{"$f":"J37*forage_cost!H54","v":36.429599564291671}]
[null,null,null,null,null,null,"Green crop",null,null,{"$f":"IF(form_data!J216>0,form_data!J216/100,AL45*1.15)","v":0},null,{"$f":"J38*forage_cost!P54","v":0}]
[null,null,null,null,null,null,"Total forage costs",null,null,null,null,{"$f":"SUM(L34:L38)","v":322.29411735970655},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if both green crop and grazing assume 50% of each"]
[null,null,null,null,null,null,null,"Avg Age","Bodyweight","DMI ","DMI from ","WT gain","MEm Req","MEg","Total ME","ME from conc","Me Req from forage","combined Forage ME",null,"Forage DMI","Weighted DM","Total Forage ","Grass Silage",null,null,null,"Maize",null,null,null,"Wholecrop ",null,null,null,"Grazing",null,"Green Crop"]
[null,null,null,null,null,null,null,"(wks)","kg","kg","conc kg","kg/d","MJ/d","MJ/d","MJ/d","MJ","MJ","MJ/kg DM",null,"Req kg","of all forage","Fresh Weight","%","kg Fresh","kgDM","Total T","%","kg fresh","kgDM","Total T","%","kg Fresh","kgDM","T Total","kg dm/d","t dm",null,"t dm"]
[null,null,null,null,null,null,null,{"$f":"N24","v":71.300952380952367},{"$f":"VLOOKUP(H42,lookup_tables!$A$12:$C$116,3,TRUE)","v":425.1},{"$f":"I42*0.025","v":10.627500000000001},{"$f":"form_data!I221 *0.87","v":0},{"$f":"$Q$20","v":0.75074703467153292},{"$f":"1.05*(0.53*(I42/1.08)^0.67)/((0.35*(11/18)+0.503))","v":42.531279052602905},{"$f":"1.05*$Q$20*(6.28+0.0188*I42)/(1-0.3*$Q$20)/0.5","v":29.041430740641246},{"$f":"M42+N42","v":71.572709793244144},{"$f":"K42*12.5","v":0},{"$f":"O42-P42","v":71.572709793244144},{"$f":"form_data!F221*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G221*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H221*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},null,{"$f":"IF(R42=0,0,Q42/R42)","v":0},{"$f":"(forage_cost!$J$60*(W42/100))+(forage_cost!$L$60*(AA42/100))+(forage_cost!$N$60*(AE42/100))","v":0},{"$f":"IF(U42=0,0,T42/(U42/100))","v":0},{"$f":"IF(form_data!F221=\"\",0,form_data!F221)","v":0},{"$f":"$V42*(W42/100)","v":0},{"$f":"X42*(forage_cost!$J$60/100)","v":0},{"$f":"(Y42/1000)*($I24*7)","v":0},{"$f":"IF(form_data!G221=\"\",0,form_data!G221)","v":0},{"$f":"V42*(AA42/100)","v":0},{"$f":"AB42*(forage_cost!$L$60/100)","v":0},{"$f":"(AC42/1000)*($I24*7)","v":0},{"$f":"IF(form_data!H221=\"\",0,form_data!H221)","v":0},{"$f":"$V42*(AE42/100)","v":0},{"$f":"AF42*(forage_cost!$N$60/100)","v":0},{"$f":"(AG42/1000)*($I24*7)","v":0},{"$f":"IF(form_data!J221=FALSE,0,IF(form_data!L221=FALSE,Q42/11,Q42/2/11))","v":6.5066099812040132},{"$f":"AI42*I22*7/1000","v":0.59427037828329987},{"$f":"IF(form_data!L221=FALSE,0,IF(form_data!J221=FALSE,Q42/11,Q42/2/11))","v":0},{"$f":"AK42*I22*7/1000","v":0}]
[null,null,null,null,null,null,null,{"$f":"N23","v":84.348571428571432},{"$f":"VLOOKUP(H43,lookup_tables!$A$12:$C$116,3,TRUE)","v":492.21249999999998},{"$f":"I43*0.025","v":12.305312499999999},{"$f":"form_data!I222 *0.87","v":0},{"$f":"$Q$20","v":0.75074703467153292},{"$f":"1.05*(0.53*(I43/1.08)^0.67)/((0.35*(11/18)+0.503))","v":46.920396246526067},{"$f":"1.05*$Q$20*(6.28+0.0188*I43)/(1-0.3*$Q$20)/0.5","v":31.608857651947126},{"$f":"M43+N43","v":78.5292538984732},{"$f":"K43*12.5","v":0},{"$f":"O43-P43","v":78.5292538984732},{"$f":"form_data!F222*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G222*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H222*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":2.75},null,{"$f":"IF(R43=0,0,Q43/R43)","v":28.556092326717529},{"$f":"(forage_cost!$J$60*(W43/100))+(forage_cost!$L$60*(AA43/100))+(forage_cost!$N$60*(AE43/100))","v":7.5},{"$f":"IF(U43=0,0,T43/(U43/100))","v":380.74789768956708},{"$f":"IF(form_data!F222=\"\",0,form_data!F222)","v":"25"},{"$f":"$V43*(W43/100)","v":95.186974422391771},{"$f":"X43*(forage_cost!$J$60/100)","v":28.556092326717529},{"$f":"(Y43/1000)*($I23*7)","v":2.6081230991735347},{"$f":"IF(form_data!G222=\"\",0,form_data!G222)","v":0},{"$f":"V43*(AA43/100)","v":0},{"$f":"AB43*(forage_cost!$L$60/100)","v":0},{"$f":"(AC43/1000)*($I23*7)","v":0},{"$f":"IF(form_data!H222=\"\",0,form_data!H222)","v":0},{"$f":"$V43*(AE43/100)","v":0},{"$f":"AF43*(forage_cost!$N$60/100)","v":0},{"$f":"(AG43/1000)*($I23*7)","v":0},{"$f":"IF(form_data!J222=FALSE,0,IF(form_data!L222=FALSE,Q43/11,Q43/2/11))","v":0},{"$f":"AI43*I23*7/1000","v":0},{"$f":"IF(form_data!L222=FALSE,0,IF(form_data!J222=FALSE,Q43/11,Q43/2/11))","v":0},{"$f":"AK43*I23*7/1000","v":0}]
[null,null,null,null,null,null,null,{"$f":"N22","v":97.396190476190469},{"$f":"VLOOKUP(H44,lookup_tables!$A$12:$C$116,3,TRUE)","v":557.53750000000002},{"$f":"I44*0.025","v":13.938437500000001},{"$f":"form_data!I223 *0.87","v":0},0.75074703467153292,51.006208174534486,34.107902732685538,85.114110907220024,0,85.114110907220024,{"$f":"form_data!F223*forage_cost!$J$60/100*forage_cost!$J$63/forage_cost!$J$60+form_data!G223*forage_cost!$L$60/100*forage_cost!$L$63/forage_cost!$L$60+form_data!H223*forage_cost!$N$60/100*forage_cost!$N$63/forage_cost!$N$60","v":0},null,0,{"$f":"(forage_cost!$J$60*(W44/100))+(forage_cost!$L$60*(AA44/100))+(forage_cost!$N$60*(AE44/100))","v":0},{"$f":"IF(U44=0,0,T44/(U44/100))","v":0},{"$f":"IF(form_data!F223=\"\",0,form_data!F223)","v":0},{"$f":"$V44*(W44/100)","v":0},{"$f":"X44*(forage_cost!$J$60/100)","v":0},{"$f":"(Y44/1000)*($I22*7)","v":0},{"$f":"IF(form_data!G223=\"\",0,form_data!G223)","v":0},0,{"$f":"AB44*(forage_cost!$L$60/100)","v":0},{"$f":"(AC44/1000)*($I22*7)","v":0},{"$f":"IF(form_data!H223=\"\",0,form_data!H223)","v":0},{"$f":"$V44*(AE44/100)","v":0},{"$f":"AF44*(forage_cost!$N$60/100)","v":0},{"$f":"(AG44/1000)*($I22*7)","v":0},{"$f":"IF(form_data!J223=FALSE,0,IF(form_data!L223=FALSE,Q44/11,Q44/2/11))","v":0},0,{"$f":"IF(form_data!L223=FALSE,0,IF(form_data!J223=FALSE,Q44/11,Q44/2/11))","v":0},0]
[null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z42:Z44)","v":2.6081230991735347},null,null,null,{"$f":"SUM(AD42:AD44)","v":0},null,null,null,{"$f":"SUM(AH42:AH44)","v":0},null,{"$f":"SUM(AJ42:AJ44)","v":0.59427037828329987},null,{"$f":"SUM(AL42:AL44)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Concentrates",null,{"$f":"J59","v":0},"kg",null,{"$f":"K59","v":0}]
[]
[null,null,null,null,null,null,"Stage","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,"Early",{"$f":"IF(form_data!I221=\"\",0,form_data!I221)","v":0},{"$f":"I24*7","v":91.333333333333343},{"$f":"IF(H56=\"\",0,H56*I56)","v":0}]
[null,null,null,null,null,null,"Mid",{"$f":"IF(form_data!I222=\"\",0,form_data!I222)","v":0},{"$f":"I23*7","v":91.333333333333343},{"$f":"IF(H57=\"\",0,H57*I57)","v":0}]
[null,null,null,null,null,null,"Late",{"$f":"IF(form_data!I223=\"\",0,form_data!I223)","v":0},{"$f":"I22*7","v":91.333333333333343},0]
[null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!H216=0,SUM(J56:J58),(form_data!H216*1000))","v":0},{"$f":"(J59/1000)*defaults!G27","v":0}]
[]
[null,null,null,null,null,null,"Bedding Cost",null,null,null,null,{"$f":"K67","v":27.948000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Age","kg/day","days ","total kg","Total £"]
[null,null,null,null,null,null,"Stage","kg/day","days ","total kg","Total £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"form_data!Y121","v":0},{"$f":"IF(form_data!AE121=\"\",0,form_data!AE121)","v":0},{"$f":"form_data!$B$123*7","v":63},{"$f":"IF(AF63=\"\",0,AF63*AG63)","v":0}]
[null,null,null,null,null,null,"Early",4,{"$f":"I22*7","v":91.333333333333343},{"$f":"H64*I64","v":365.33333333333337},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"form_data!Y122","v":0},{"$f":"IF(form_data!AE122=\"\",0,form_data!AE122)","v":0},{"$f":"form_data!$B$123*7","v":63},{"$f":"IF(AF64=\"\",0,AF64*AG64)","v":0}]
[null,null,null,null,null,null,"Mid",4.5,{"$f":"I23*7","v":91.333333333333343},{"$f":"H65*I65","v":411.00000000000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"form_data!Y123","v":0},{"$f":"IF(form_data!AE123=\"\",0,form_data!AE123)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,"Late",{"$f":"IF(form_data!D223=TRUE,5,\"0\")","v":"0"},91.333333333333343,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"form_data!Y124","v":0},{"$f":"IF(form_data!AE124=\"\",0,form_data!AE124)","v":0},{"$f":"form_data!$B$123*7","v":63},0]
[null,null,null,null,null,null,"Total",null,null,{"$f":"IF(form_data!D216=0,SUM(J64:J66),(form_data!D216*1000))","v":776.33333333333348},{"$f":"(J67/1000)*defaults!$G$33","v":27.948000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"form_data!Y125","v":0},{"$f":"IF(form_data!AE125=\"\",0,form_data!AE125)","v":0},{"$f":"form_data!$B$123*7","v":63},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,{"$f":"form_data!Y126","v":0},{"$f":"IF(form_data!AE126=\"\",0,form_data!AE126)","v":0},{"$f":"form_data!$B$123*7","v":63},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,"Total",null,null,{"$f":"IF(form_data!AD116=\"\",SUM(AH63:AH68),(form_data!AD1116*1000))","v":0},{"$f":"(AH69/1000)*defaults!AC27","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Vet & Med, inc Vacc",null,null,null,null,20]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Sundries ",null,null,null,null,{"$f":"defaults!K23/3","v":5.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Mortality Rate",null,null,4.2,"%"]
[]
[null,null,null,null,null,null,"Mortality Cost (incl carcass disposal)",null,null,null,null,{"$f":"((SUM(L39:L102)*0.5)+birth_wean!L141+wean_conception!L157)*J113/100 + defaults!G35*conception_calving!J113/100","v":35.466129821883825}]
[null,null,null,null,null,null,"Water",null,null,null,null,{"$f":"defaults!K19/(defaults!G40*4.3)*conception_calving!I21","v":10.999446290143968}]
[null,null,null,null,null,null,"Power & Machinery (incl electricity, excluding forage costs)",null,null,null,null,15]
[null,null,null,null,null,null,"Labour (includes bedding and cleaning out)",null,null,null,null,120]
[]
[]
[]
[null,null,null,null,null,null,"Total cost of this period",null,null,null,null,{"$f":"SUM(L39,L53,L61,L96,L102,L115:L118)","v":557.20769347173427}]
[]
[null,null,null,null,null,null,"Total cost per day in this period ",null,null,null,null,{"$f":"L122/(I21*7)","v":2.0336047206997603}]
[]
[null,null,null,null,null,null,"Total cost to this stage including calf value",null,null,null,null,{"$f":"L122+wean_conception!L160","v":1182.642176665679}]

{"sheet":"summary","index":6,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[[77,5,77,10],[78,5,78,10],[79,5,79,10],[61,5,61,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Summary of Costs"]
[]
[]
[null,null,null,null,null,null,"Standard ",null,"Your Farm "]
[null,null,null,null,null,null,"Calving at 24 Months ",null,"£"]
[null,null,null,null,null,"Cash Cost "]
[]
[null,null,null,null,null,"Birth to Weaning ( incl. calf value)",288.95999999999998,null,{"$f":"birth_wean!L141","v":288.95773020467055}]
[]
[null,null,null,null,null,"Weaning to Conception ",274.63,null,{"$f":"wean_conception!L157","v":336.47675298927419}]
[]
[null,null,null,null,null,"Conception to Calving ",197.01,null,{"$f":"conception_calving!L122","v":557.20769347173427}]
[]
[null,null,null,null,null,"Total Cash Cost ",760.6,null,{"$f":"SUM(I38:I42)","v":1182.642176665679}]
[]
[]
[]
[]
[null,null,null,null,null,"Please note this is only a cash cost, not a full economic cost.  A full economic cost would take "]
[null,null,null,null,null,"account of deprecation on buildings, opportunity costs etc. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"In an AHDB Dairy funded a study carried out in 2013 on 102 farms across England, Scotland and Wales the full economic cost of rearing heifers was found to be between £1,073 and £3,070 with the average at £1,819. This included interest and opportunity costs of £442 per heifer reared"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"AHDB Dairy is a division of the Agricultural and Horticultural Development Board."]
[null,null,null,null,null,"While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law, the Agriculture and Horticulture Development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. "]
[null,null,null,null,null,"© Agriculture and Horticulture Development Board 2015. All rights reserved. "]

{"sheet":"blank","index":7,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["birth_wean"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"","","","","","",""]

{"sheet":"form_data","index":8,"n_rows":223,"n_cols":17,"rows_kept":223,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Age Bracket Calculation "]
[null,"Age at weaning ",{"$f":"defaults!G42*7","v":56},"days"]
[null,"=",{"$f":"C8/6","v":9.3333333333333339},"days per period in b>w period"]
[null,"=",{"$f":"ROUND(C9,0)","v":9},"days per period in b>w period rounded"]
[]
[]
[null,null,"Data populated from birth to weaning form "]
[]
[null,null,null,"Bedding (kg)","Milk Replacer (kg)","Whole Milk (L)","Conc (kg)","Feed Straw (kg)","Feed Hay (kg)"]
[null,null,"Total","","","","","",""]
[]
[]
[]
[null,null,"Age","Bedding Yes","Bedding No ","Milk Replacer L","Mixing Rate (g/l)","Whole Milk (L)","Conc (kg)","Straw Yes","Straw No","Hay Yes","Hay No"]
[null,null,{"$f":"\"1-\" & C10 & \" days\"","v":"1-9 days"},true,false,"","0","","",true,false,false,true]
[null,null,{"$f":"C10+1&\"-\"&C10*2&\" days\"","v":"10-18 days"},true,false,"","0","","",true,false,false,true]
[null,null,{"$f":"C10*2+1&\"-\"&C10*3&\" days\"","v":"19-27 days"},true,false,"","0","","",true,false,false,true]
[null,null,{"$f":"C10*3+1&\"-\"&C10*4&\" days\"","v":"28-36 days"},true,false,"","0","","",true,false,false,true]
[null,null,{"$f":"C10*4+1&\"-\"&C10*5&\" days\"","v":"37-45 days"},true,false,"","0","","",true,false,false,true]
[null,null,{"$f":"C10*5+1&\"-\"&C10*6&\" days\"","v":"46-54 days"},true,false,"","0","","",true,false,false,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"defaults!$G$19+(SUM(L34,L44,L54,L64,L75,L85,L95,L97))*(birth_wean!K99/100)","v":200}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data populated from weaning to conception form "]
[]
[null,null,null,"Bedding (T)","Grass Silage (T)","Maize (T)","Wholecrop (T)","Conc (T)","Grazing (T)","Green crop (T)"]
[null,null,"Total",0,0,0,0,0,0,0]
[]
[]
[]
["Age Bracket Calcualtion ",null,"Age (wks)","Bedding Yes","Bedding No ","Grass Silage %","Maize %","WC %","Conc kg","Grazing Yes","Grazing No ","Green Crop Yes","Green Crop No ",null,null,"Forage Check"]
["total wks",{"$f":"wean_conception!N22","v":56.777142857142849},{"$f":"B124 & \" - \" & B125","v":"8 - 17"},true,false,"100",0,0,"",false,true,false,true,null,null,{"$f":"F121+G121+H121","v":100},{"$f":"IF(P121=0,\"\",IF(P121=100,\"\",\"Error\"))","v":""}]
["wks/period",{"$f":"B121/6","v":9.4628571428571409},"17 - 26",true,false,0,0,0,"",false,true,false,true,null,null,{"$f":"F122+G122+H122","v":0},{"$f":"IF(P122=0,\"\",IF(P122=100,\"\",\"Error\"))","v":""}]
["round",{"$f":"ROUND(B122,0)","v":9},"26 - 35",true,false,0,0,0,"",false,true,false,true,null,null,0,""]
["Age 1",{"$f":"defaults!G42","v":8},"35 - 44",true,false,0,0,0,"",false,true,false,true,null,null,0,""]
["Age 2",{"$f":"B124+B123","v":17},"44 - 53",true,false,0,0,0,"",false,true,false,true,null,null,0,""]
["Age 3",{"$f":"B125+$B$123","v":26},"53 - Conception",true,false,0,0,0,"",false,true,false,true,null,null,0,""]
["Age 4",{"$f":"B126+$B$123","v":35}]
["Age 5",44]
["Age 6",53]
["Age 7","Conception"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Data populated from conception to calving form "]
[]
[null,null,null,"Bedding (T)","Grass Sil (T)","Maize (T)","WC (T)","Conc (T)","Grazing (T)","Green Crop (T) "]
[null,null,"Total",0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"Stage","Bedding Yes","Bedding No","Grass Silage %","Maize %","WC %","Conc kg","Grazing Yes","Grazing No","Green crop Yes","Green crop No ",null,null,"Forage Check "]
[null,null,"Early Preg",false,false,0,0,0,0,true,false,false,false,null,null,{"$f":"F221+G221+H221","v":0},{"$f":"IF(P221=0,\"\",IF(P221=100,\"\",\"Error\"))","v":""}]
[null,null,"Mid Preg",false,false,"25",0,0,0,false,false,false,false,null,null,{"$f":"F222+G222+H222","v":25},{"$f":"IF(P222=0,\"\",IF(P222=100,\"\",\"Error\"))","v":"Error"}]
[null,null,"Late Preg",false,false,0,0,0,0,false,false,false,false,null,null,0,""]

{"sheet":"lookup_tables","index":9,"n_rows":116,"n_cols":3,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Lookup Tables"]
[]
[]
[]
[]
[]
[]
[]
["1:  % of mature weight with age"]
[]
["age (wks)","%","weight kg"]
[0,6.2,{"$f":"defaults!$K$40*(lookup_tables!B12/100)","v":40.299999999999997}]
[1,7.1,{"$f":"defaults!$K$40*(lookup_tables!B13/100)","v":46.15}]
[2,8,{"$f":"defaults!$K$40*(lookup_tables!B14/100)","v":52}]
[3,8.9,{"$f":"defaults!$K$40*(lookup_tables!B15/100)","v":57.850000000000009}]
[4,9.8000000000000007,{"$f":"defaults!$K$40*(lookup_tables!B16/100)","v":63.7}]
[5,10.475,{"$f":"defaults!$K$40*(lookup_tables!B17/100)","v":68.087499999999991}]
[6,11.15,{"$f":"defaults!$K$40*(lookup_tables!B18/100)","v":72.474999999999994}]
[7,{"$f":"AVERAGE(B18,B20)","v":11.824999999999999},{"$f":"defaults!$K$40*(lookup_tables!B19/100)","v":76.862499999999997}]
[8,12.5,{"$f":"defaults!$K$40*(lookup_tables!B20/100)","v":81.25}]
[9,{"$f":"AVERAGE(B20,B22)","v":13.45},{"$f":"defaults!$K$40*(lookup_tables!B21/100)","v":87.424999999999983}]
[10,14.4,{"$f":"defaults!$K$40*(lookup_tables!B22/100)","v":93.600000000000009}]
[11,15.35,{"$f":"defaults!$K$40*(lookup_tables!B23/100)","v":99.774999999999991}]
[12,16.3,{"$f":"defaults!$K$40*(lookup_tables!B24/100)","v":105.95}]
[13,17.149999999999999,{"$f":"defaults!$K$40*(lookup_tables!B25/100)","v":111.47499999999999}]
[14,18,{"$f":"defaults!$K$40*(lookup_tables!B26/100)","v":117}]
[15,{"$f":"AVERAGE(B28,B26)","v":18.850000000000001},{"$f":"defaults!$K$40*(lookup_tables!B27/100)","v":122.52500000000001}]
[16,19.7,{"$f":"defaults!$K$40*(lookup_tables!B28/100)","v":128.04999999999998}]
[17,{"$f":"AVERAGE(B30,B28)","v":20.7},{"$f":"defaults!$K$40*(lookup_tables!B29/100)","v":134.54999999999998}]
[18,21.7,{"$f":"defaults!$K$40*(lookup_tables!B30/100)","v":141.05000000000001}]
[19,21.7,{"$f":"defaults!$K$40*(lookup_tables!B31/100)","v":141.05000000000001}]
[20,{"$f":"AVERAGE(B33,B31)","v":22.7},{"$f":"defaults!$K$40*(lookup_tables!B32/100)","v":147.54999999999998}]
[21,23.7,{"$f":"defaults!$K$40*(lookup_tables!B33/100)","v":154.04999999999998}]
[22,{"$f":"AVERAGE(B35,B33)","v":24.7},{"$f":"defaults!$K$40*(lookup_tables!B34/100)","v":160.55000000000001}]
[23,25.7,{"$f":"defaults!$K$40*(lookup_tables!B35/100)","v":167.05}]
[24,25.7,{"$f":"defaults!$K$40*(lookup_tables!B36/100)","v":167.05}]
[25,{"$f":"AVERAGE(B38,B36)","v":26.7},{"$f":"defaults!$K$40*(lookup_tables!B37/100)","v":173.55}]
[26,27.7,{"$f":"defaults!$K$40*(lookup_tables!B38/100)","v":180.04999999999998}]
[27,28.875,{"$f":"defaults!$K$40*(lookup_tables!B39/100)","v":187.6875}]
[28,28.875,{"$f":"defaults!$K$40*(lookup_tables!B40/100)","v":187.6875}]
[29,30.049999999999997,{"$f":"defaults!$K$40*(lookup_tables!B41/100)","v":195.32499999999999}]
[30,31.224999999999998,{"$f":"defaults!$K$40*(lookup_tables!B42/100)","v":202.96249999999998}]
[31,31.225000000000001,{"$f":"defaults!$K$40*(lookup_tables!B43/100)","v":202.96250000000001}]
[32,32.4,{"$f":"defaults!$K$40*(lookup_tables!B44/100)","v":210.6}]
[33,32.4,{"$f":"defaults!$K$40*(lookup_tables!B45/100)","v":210.6}]
[34,33.575000000000003,{"$f":"defaults!$K$40*(lookup_tables!B46/100)","v":218.23750000000004}]
[35,33.575000000000003,{"$f":"defaults!$K$40*(lookup_tables!B47/100)","v":218.23750000000004}]
[36,34.75,{"$f":"defaults!$K$40*(lookup_tables!B48/100)","v":225.87499999999997}]
[37,35.924999999999997,{"$f":"defaults!$K$40*(lookup_tables!B49/100)","v":233.51249999999996}]
[38,35.924999999999997,{"$f":"defaults!$K$40*(lookup_tables!B50/100)","v":233.51249999999996}]
[39,37.1,{"$f":"defaults!$K$40*(lookup_tables!B51/100)","v":241.15}]
[40,38.400000000000006,{"$f":"defaults!$K$40*(lookup_tables!B52/100)","v":249.60000000000005}]
[41,38.4,{"$f":"defaults!$K$40*(lookup_tables!B53/100)","v":249.6}]
[42,39.700000000000003,{"$f":"defaults!$K$40*(lookup_tables!B54/100)","v":258.05}]
[43,41,{"$f":"defaults!$K$40*(lookup_tables!B55/100)","v":266.5}]
[44,41,{"$f":"defaults!$K$40*(lookup_tables!B56/100)","v":266.5}]
[45,42.3,{"$f":"defaults!$K$40*(lookup_tables!B57/100)","v":274.95}]
[46,42.3,{"$f":"defaults!$K$40*(lookup_tables!B58/100)","v":274.95}]
[47,43.599999999999994,{"$f":"defaults!$K$40*(lookup_tables!B59/100)","v":283.39999999999998}]
[48,43.6,{"$f":"defaults!$K$40*(lookup_tables!B60/100)","v":283.39999999999998}]
[49,44.9,{"$f":"defaults!$K$40*(lookup_tables!B61/100)","v":291.85000000000002}]
[50,46.2,{"$f":"defaults!$K$40*(lookup_tables!B62/100)","v":300.3}]
[51,46.2,{"$f":"defaults!$K$40*(lookup_tables!B63/100)","v":300.3}]
[52,47.5,{"$f":"defaults!$K$40*(lookup_tables!B64/100)","v":308.75}]
[53,49.075000000000003,{"$f":"defaults!$K$40*(lookup_tables!B65/100)","v":318.98750000000001}]
[54,49.075000000000003,{"$f":"defaults!$K$40*(lookup_tables!B66/100)","v":318.98750000000001}]
[55,50.65,{"$f":"defaults!$K$40*(lookup_tables!B67/100)","v":329.22499999999997}]
[56,52.224999999999994,{"$f":"defaults!$K$40*(lookup_tables!B68/100)","v":339.46249999999998}]
[57,52.225000000000001,{"$f":"defaults!$K$40*(lookup_tables!B69/100)","v":339.46249999999998}]
[58,53.8,{"$f":"defaults!$K$40*(lookup_tables!B70/100)","v":349.69999999999993}]
[59,53.8,{"$f":"defaults!$K$40*(lookup_tables!B71/100)","v":349.69999999999993}]
[60,55.375,{"$f":"defaults!$K$40*(lookup_tables!B72/100)","v":359.9375}]
[61,55.375,{"$f":"defaults!$K$40*(lookup_tables!B73/100)","v":359.9375}]
[62,56.95,{"$f":"defaults!$K$40*(lookup_tables!B74/100)","v":370.17500000000001}]
[63,58.525000000000006,{"$f":"defaults!$K$40*(lookup_tables!B75/100)","v":380.41250000000002}]
[64,58.524999999999999,{"$f":"defaults!$K$40*(lookup_tables!B76/100)","v":380.41249999999997}]
[65,60.1,{"$f":"defaults!$K$40*(lookup_tables!B77/100)","v":390.65}]
[66,61.424999999999997,{"$f":"defaults!$K$40*(lookup_tables!B78/100)","v":399.26249999999999}]
[67,61.424999999999997,{"$f":"defaults!$K$40*(lookup_tables!B79/100)","v":399.26249999999999}]
[68,62.75,{"$f":"defaults!$K$40*(lookup_tables!B80/100)","v":407.87499999999994}]
[69,64.075000000000003,{"$f":"defaults!$K$40*(lookup_tables!B81/100)","v":416.48750000000001}]
[70,64.075000000000003,{"$f":"defaults!$K$40*(lookup_tables!B82/100)","v":416.48750000000001}]
[71,65.400000000000006,{"$f":"defaults!$K$40*(lookup_tables!B83/100)","v":425.1}]
[72,65.400000000000006,{"$f":"defaults!$K$40*(lookup_tables!B84/100)","v":425.1}]
[73,66.725000000000009,{"$f":"defaults!$K$40*(lookup_tables!B85/100)","v":433.71250000000009}]
[74,67.387500000000017,{"$f":"defaults!$K$40*(lookup_tables!B86/100)","v":438.01875000000013}]
[75,68.050000000000011,{"$f":"defaults!$K$40*(lookup_tables!B87/100)","v":442.32500000000005}]
[76,69.375,{"$f":"defaults!$K$40*(lookup_tables!B88/100)","v":450.9375}]
[77,70.037499999999994,{"$f":"defaults!$K$40*(lookup_tables!B89/100)","v":455.24374999999998}]
[78,70.7,{"$f":"defaults!$K$40*(lookup_tables!B90/100)","v":459.55000000000007}]
[79,71.956250000000011,{"$f":"defaults!$K$40*(lookup_tables!B91/100)","v":467.71562500000005}]
[80,71.956000000000003,{"$f":"defaults!$K$40*(lookup_tables!B92/100)","v":467.714}]
[81,73.212500000000006,{"$f":"defaults!$K$40*(lookup_tables!B93/100)","v":475.88125000000002}]
[82,74.468000000000004,{"$f":"defaults!$K$40*(lookup_tables!B94/100)","v":484.04200000000003}]
[83,75.096499999999992,{"$f":"defaults!$K$40*(lookup_tables!B95/100)","v":488.12724999999995}]
[84,75.724999999999994,{"$f":"defaults!$K$40*(lookup_tables!B96/100)","v":492.21249999999998}]
[85,75.724999999999994,{"$f":"defaults!$K$40*(lookup_tables!B97/100)","v":492.21249999999998}]
[86,76.981249999999989,{"$f":"defaults!$K$40*(lookup_tables!B98/100)","v":500.37812499999995}]
[87,76.98,{"$f":"defaults!$K$40*(lookup_tables!B99/100)","v":500.37}]
[88,78.237499999999997,{"$f":"defaults!$K$40*(lookup_tables!B100/100)","v":508.54374999999993}]
[89,79.493750000000006,{"$f":"defaults!$K$40*(lookup_tables!B101/100)","v":516.70937500000002}]
[90,79.489999999999995,{"$f":"defaults!$K$40*(lookup_tables!B102/100)","v":516.68499999999995}]
[91,80.75,{"$f":"defaults!$K$40*(lookup_tables!B103/100)","v":524.875}]
[92,82.006249999999994,{"$f":"defaults!$K$40*(lookup_tables!B104/100)","v":533.04062499999998}]
[93,82.006,{"$f":"defaults!$K$40*(lookup_tables!B105/100)","v":533.03899999999999}]
[94,83.262500000000003,{"$f":"defaults!$K$40*(lookup_tables!B106/100)","v":541.20625000000007}]
[95,84.518750000000011,{"$f":"defaults!$K$40*(lookup_tables!B107/100)","v":549.37187500000005}]
[96,85.146875000000009,{"$f":"defaults!$K$40*(lookup_tables!B108/100)","v":553.45468750000009}]
[97,85.775000000000006,{"$f":"defaults!$K$40*(lookup_tables!B109/100)","v":557.53750000000002}]
[98,85.775000000000006,{"$f":"defaults!$K$40*(lookup_tables!B110/100)","v":557.53750000000002}]
[99,87.03125,{"$f":"defaults!$K$40*(lookup_tables!B111/100)","v":565.703125}]
[100,87.659374999999997,{"$f":"defaults!$K$40*(lookup_tables!B112/100)","v":569.78593749999993}]
[101,88.287499999999994,{"$f":"defaults!$K$40*(lookup_tables!B113/100)","v":573.86874999999998}]
[102,89.543749999999989,{"$f":"defaults!$K$40*(lookup_tables!B114/100)","v":582.03437499999995}]
[103,90.171875,{"$f":"defaults!$K$40*(lookup_tables!B115/100)","v":586.1171875}]
[104,90.8,{"$f":"defaults!$K$40*(lookup_tables!B116/100)","v":590.19999999999993}]

{"sheet":"Input sheet","index":10,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Heifer Rearing Cost Calculator "]
[]
[null,null,null,null,null,null,null,"Input Sheet "]
[]
[null,null,null,null,null,null,null,"Default values are loaded here but we suggest you use your own values if you have them."]
[]
[null,null,null,null,null,null,null,"Replacement heifer calf value (£/hd)",200,null,null,"Water (£/hd)",29]
[]
[null,null,null,null,null,null,null,"Beef calf value (£/hd)",150,null,null,"Electricity (£/hd)",22]
[]
[null,null,null,null,null,null,null,"Milk powder (£/T)",1500,null,null,"Consumables (£/hd)",16.5]
[]
[null,null,null,null,null,null,null,"Calf starter mix (£/T)",230,null,null,"Interest rate (%)",4]
[]
[null,null,null,null,null,null,null,"Rearing concentrate (£/T)",210,null,null,"Land opportunity cost (£/ha)",265]
[]
[null,null,null,null,null,null,null,"Feeding straw (£/T)",41,null,null,"AI price (£/service)",50]
[]
[null,null,null,null,null,null,null,"Feeding hay (£/T)",50,null,null,"Conception rate to AI (%)",40]
[]
[null,null,null,null,null,null,null,"Bedding material (£/T)",36,null,null,"Pregnancy Testing (£/hd)",10]
[]
[null,null,null,null,null,null,null,"Disposal cost (£/carcase)",30,null,null,"Milk price (ppl)",21]
[]
[null,null,null,null,null,null,null,"Labour cost (£/hr)",10,null,null,"Margin over Puchased Feed (ppl)",15]
[]
[]
[null,null,null,null,null,null,null,"Age at first calving (months)",24,null,null,"Mature cow weight (kg)",650]
[]
[null,null,null,null,null,null,null,"Age at weaning (weeks)",8,null,null,"Heifer lactation yield (l)",8000]
[]
[]
[null,null,null,null,null,null,null,"Birth to Weaning "]
[]
[null,null,null,null,null,null,null,"Vet & Med, inc Vaccinations",12.5,null,null,"Power & Machinery (incl electricity, excluding forage costs)",10]
[]
[null,null,null,null,null,null,null,"Mortality Rate",10.5,null,null,"Labour (includes bedding and cleaning out)",25]
[]
[]
[null,null,null,null,null,null,null,"Weaning to Conception "]
[]
[null,null,null,null,null,null,null,"Vet & Med, inc Vaccinations",12,null,null,"Power & Machinery (incl electricity, excluding forage costs)",15]
[]
[null,null,null,null,null,null,null,"Mortality Rate",3.4,null,null,"Labour (includes bedding and cleaning out)",75]
[]
[]
[null,null,null,null,null,null,null,"Conception to Calving"]
[]
[null,null,null,null,null,null,null,"Vet & Med, inc Vaccinations",20,null,null,"Power & Machinery (incl electricity, excluding forage costs)",15]
[]
[null,null,null,null,null,null,null,"Mortality Rate",4.2,null,null,"Labour (includes bedding and cleaning out)",120]