{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Farm Calculator","Graph - costs","Graph - store cattle vaccine","Graph breeding cattle vaccine"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Graph - costs","index":1,"reason":"not_a_worksheet"},{"sheet":"Graph - store cattle vaccine","index":2,"reason":"not_a_worksheet"},{"sheet":"Graph breeding cattle vaccine","index":3,"reason":"not_a_worksheet"}],"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":"Farm Calculator","index":0,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":false,"merged":[[21,1,21,5],[1,1,1,3],[56,1,56,4],[59,1,59,4],[18,1,18,4],[19,1,19,4],[57,1,57,4],[58,1,58,4]]}
[]
[null,"How much will farmers spend or save by vaccinating their cattle against BTV-3?"]
[]
[]
[null,"Step 1. Input your data in the blue cells"]
[]
[null,"How many store cattle do you have?",4,"  Use the number of store or finishing cattle"]
[]
[null,"How many breeding females do you have?",6,"  Heifers and cows you expect to breed from"]
[]
[null,"What is the expected store or finishing cattle value?",1784,"  Default £1784 is the 2024 average deadweight steer figure"]
[]
[null,"What is the expected breeding female value?",2500,"  Default £2500 is a suggested figure"]
[]
[null,"What is the vaccination cost per animal?",10,"  Please talk to your vet to get an up-to-date figure"]
[]
[null,"Step 2. Review your results",null,""]
[]
[null,"The tables below show the impact of BTV-3 infection in different scenarios, based on the numbers you provide in step 1. The scenarios represent mild infection (A) through to severe infection (D). AHDB has developed each scenario based on actual data from the UK and mainland Europe. "]
[null,"The calculator doesn't allow you to mix the scenarios - so the results won't be valid if you take productivity costs from Scenario A and add mortality costs from Scenario B etc. You need to follow the same scenario throughout."]
[]
[null,"Productivity costs - we estimate that infected cattle will lose around 10% of their value due to slower growth and the additional treatment costs."]
[null,"Scenario","Store cattle","Breeding cattle","Total"]
[0.1,"A) If 10% of your cattle are infected",{"$f":"$C$7*(A24*$B$72)*$C$11","v":71.360000000000014},{"$f":"$C$9*A24*($C$13*$B$72)","v":150.00000000000003},{"$f":"SUM(C24:D24)","v":221.36000000000004}]
[0.15,"B) If 15% of your cattle are infected",{"$f":"$C$7*(A25*$B$72)*$C$11","v":107.03999999999999},{"$f":"$C$9*A25*($C$13*$B$72)","v":224.99999999999997},{"$f":"SUM(C25:D25)","v":332.03999999999996}]
[0.25,"C) If 25% of your cattle are infected",{"$f":"$C$7*(A26*$B$72)*$C$11","v":178.4},{"$f":"$C$9*A26*($C$13*$B$72)","v":375},553.4]
[0.3,"D) If 30% of your cattle are infected",{"$f":"$C$7*(A27*$B$72)*$C$11","v":214.07999999999998},{"$f":"$C$9*A27*($C$13*$B$72)","v":449.99999999999994},664.07999999999993]
[]
[null,"Mortality costs - the lost value from cattle that die"]
[null,"Scenario","Store cattle","Breeding cattle","Total"]
[0.01,"A) If 1% of infected animals die",{"$f":"($C$7*A24*A31)*$C$11","v":7.1360000000000001},{"$f":"($C$9*A24*A31)*$C$13","v":15.000000000000002},{"$f":"SUM(C31:D31)","v":22.136000000000003}]
[2.5000000000000001E-2,"B) If 2.5% of infected animals die",{"$f":"($C$7*A25*A32)*$C$11","v":26.759999999999998},{"$f":"($C$9*A25*A32)*$C$13","v":56.25},{"$f":"SUM(C32:D32)","v":83.009999999999991}]
[0.04,"C) If 4% of infected animals die",{"$f":"($C$7*A26*A33)*$C$11","v":71.36},{"$f":"($C$9*A26*A33)*$C$13","v":150},221.36]
[0.06,"D) If 6% of infected animals die",{"$f":"($C$7*A27*A34)*$C$11","v":128.44799999999998},{"$f":"($C$9*A27*A34)*$C$13","v":269.99999999999994},398.44799999999992]
[]
[null,"Fertility costs - infected cattle can have reduced fertility"]
[null,"Scenario","Store cattle","Breeding cattle","Total"]
[0,"A) 0% reduction in calves from infected cattle","n/a",{"$f":"($C$9*A38*A24)*$C$11","v":0},{"$f":"D38","v":0}]
[0.15,"B) 15% reduction in calves from infected cattle","n/a",{"$f":"($C$9*A39*A25)*$C$11","v":240.83999999999997},{"$f":"D39","v":240.83999999999997}]
[0.3,"C) 30% reduction in calves from infected cattle","n/a",{"$f":"($C$9*A40*A26)*$C$11","v":802.8},802.8]
[0.5,"D) 50% reduction in calves from infected cattle","n/a",{"$f":"($C$9*A41*A27)*$C$11","v":1605.6},1605.6]
[]
[null,"Step 3. Understand the cost of vaccination"]
[]
[null,null,"Store cattle","Breeding cattle","Total"]
[null,"How much will it cost to vaccinate your cattle?",{"$f":"C7*C15","v":40},{"$f":"C9*C15","v":60},{"$f":"D46+C46","v":100}]
[]
[null,"How much will vaccinating your cattle save you? - we assume a 50% reduction in infections and 75% reduction in mortality."]
[]
[null,"Scenario","Store cattle","Breeding cattle","Total"]
[null,"Scenario A - Mild infection",{"$f":"(C24*$B$70)+(C31*$F$70)","v":44.600000000000009},{"$f":"(D24*$B$70)+(D31*$F$70)+(D38*$B$70)","v":93.750000000000014},{"$f":"D51+C51","v":138.35000000000002}]
[null,"Scenario B - Mild to moderate infection",{"$f":"(C25*$B$70)+(C32*$F$70)","v":86.97},{"$f":"(D25*$B$70)+(D32*$F$70)+(D39*$B$70)","v":303.23249999999996},{"$f":"D52+C52","v":390.20249999999999}]
[null,"Scenario C - Moderate to severe infection",{"$f":"(C26*$B$70)+(C33*$F$70)","v":178.4},{"$f":"(D26*$B$70)+(D33*$F$70)+(D40*$B$70)","v":776.4},954.8]
[null,"Scenario D - Severe infection",{"$f":"(C27*$B$70)+(C34*$F$70)","v":267.59999999999997},{"$f":"(D27*$B$70)+(D34*$F$70)+(D41*$B$70)","v":1365.2999999999997},1632.8999999999996]
[]
[]
[null,"1. Savings are calculated by accounting for the number of cattle you have identified, the cost of the vaccine and the effect of productivity, mortality and reduced fertility. It does not include costs associated with gathering the herd for vaccination, labour and consumables or costs for the disposal of dead stock. "]
[null,"2. The calculator does not assess the impact on breeding bulls, which should be the highest priority cattle for vacination on farm due to their high value and the potential impact of BTV-3 on the bull's fertllity. "]
[null,"3. BTV-3 is an emerging disease and there is a high level on uncertainty around the fertility impacts of the disease including how severe clinical signs are in calves.  The fertility scenarios are very broad, relecting this uncertainty. Scenario D with a 50% reduction is most likely to occur with an infected bull, but there are some farms with high levels of abortion/deformed calves which are purely related to infected cows."]
[null,"4. Results from this calculator are based on a series of assumptions and should be treated as a tool to aid decision-making on-farm. Actual impacts will vary depending on the specific outbreak of BTV-3. Always seek advice of your vet to fully assess the risks and the cost-benefits as part of your herd health planning. Please note that vaccination will reduce clinical signs and mortality, but it will not eliminate them altogether. "]
[null,"For more information and advice on Bluetongue please visit the AHDB website: "]
[null,"Bluetongue virus latest news | AHDB"]
[]
[]
[]
[]
[]
[]
["hidden data"]
["vaccination impact on infection",0.5,"set value which can not be changed",null,null,{"$f":"B71+B70","v":1.25},"vaccination impact on ingection + mortality"]
["vaccination impact on mortality",0.75,"set value which can not be changed"]
["value drop for infected cattle",0.1,"set value which can not be changed"]
[]
[]
[null,"Store cattle vaccination cost","Store cattle savings","Breeding cattle vaccination cost","Breeding cattle savings"]
[null,{"$f":"C46","v":40},{"$f":"C51","v":44.600000000000009},{"$f":"D46","v":60},{"$f":"D51","v":93.750000000000014}]
[null,{"$f":"C46","v":40},{"$f":"C52","v":86.97},{"$f":"D46","v":60},{"$f":"D52","v":303.23249999999996}]
[null,{"$f":"C46","v":40},{"$f":"C53","v":178.4},{"$f":"D46","v":60},776.4]
[null,{"$f":"C46","v":40},{"$f":"C54","v":267.59999999999997},{"$f":"D46","v":60},1365.2999999999997]
[]
[]
[]
[null,"Productivity costs","Mortality costs","Fertility costs"]
["Scenario A - mild",{"$f":"E24","v":221.36000000000004},{"$f":"E31","v":22.136000000000003},{"$f":"D38","v":0}]
["Scenario B - mild to moderate",{"$f":"E25","v":332.03999999999996},{"$f":"E32","v":83.009999999999991},{"$f":"D39","v":240.83999999999997}]
["Scenario C - moderate to severe",{"$f":"E26","v":553.4},{"$f":"E33","v":221.36},{"$f":"D40","v":802.8}]
["Scenario D - severe",{"$f":"E27","v":664.07999999999993},{"$f":"E34","v":398.44799999999992},{"$f":"D41","v":1605.6}]