{"text_format":"3","workbook":"xls","n_sheets":19,"sheets":["Introduction","Release Notes","References","Input","Tx Options","Results","Ca-Con Summary","Literature Review Figures","Cost of Cull","Tx Costs","Digital Dermatitis","White Line Disease","Digital","Inter-digital","Sole Ulcer","TMR 6-8K","TMR 8-10K","PMR 6-8K","PMR 8-10K"],"not_rendered":{"charts":6,"images":2,"external_links":1,"defined_names":1,"comments":112},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Introduction","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"This cost calculator was created by Nick Bell (University of Bristol, Healthy Feet Project) and Jim Willshire (Endell Vet Group, www.dairymedicine.co.uk). It is adapted from the work by Esslemont et al. (2002) and uses updated references from the literature together with data from the individual farm concerned to create a farm-specific cost for lameness."]
[null,"For a list of the references used, please follow this link."]
[]
[null,"How to use this calculator:"]
[null,"1. Click the 'Start' button below."]
[null,"2. Complete as many the cells shaded yellow as possible, those shaded green will be calculated from the values you enter, or if you know the values for the farm concerned you can over-write them."]
[null,"3. The more yellow cells you can complete the more farm-specific the costs calculated will be."]
[null,"4. Click the 'Results' button to see the results of the cost calculations."]
[null,"5. Follow the hyperlinks from the results page to see how the values were calculated then click the 'Input' or 'Results' buttons to return."]
[]
[null,"Regards,"]
[null,"Jim Willshire BVSc CertCHP MRCVS and Nick Bell MA VetMB PhD MRCVS"]
[]
[null,"Release Notes"]

{"sheet":"Release Notes","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Version","Date","Details"]
[null,{"v":1,"d":"1.0"},"2009-07-13","Initial release"]
[null,1.1,"2009-07-14","Standard values for labour added"]
[null,1.2,"2009-07-20","Treatment options added"]
[null,1.3,"2009-07-22","Labour values for lesions not receiving further foot trims added, PMR fed herds concentrate feeding rate calculation changed"]
[null,1.4,"2009-08-05","Culling rates updated"]
[null,1.6,"2009-11-18","Cost of treatment calculations improved"]

{"sheet":"References","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"flags":["formulas_cached_only"]}
[]
[null,"References"]
[null,"ABC (2009). The Agricultural Budgeting and Costings Book, Agro-Business Consultants."]
[null,"Amory, J. R., Z. E. Barker, et al. (2008). \"Associations between sole ulcer, white line disease and digital dermatitis and the milk yield of 1824 dairy cows on 30 dairy cow farms in England and Wales from February 2003-November 2004.\" Preventive Veterinary Medicine 83(3-4): 381-391."]
[null,"ArgaezRodriguez, F. D. J., D. W. Hird, et al. (1997). \"Papillomatous digital dermatitis on a commercial dairy farm in Mexicali, Mexico: Incidence and effect on reproduction and milk production.\" Preventive Veterinary Medicine 32(3-4): 275-286."]
[null,"Barker, Z. (2007). Epidemiology of Lameness in Dairy Cows, Warwick. PhD."]
[null,"Collick, D. W., W. R. Ward, et al. (1989). \"Associations between types of lameness and fertility.\" Vet Rec 125(5): 103-6."]
[null,"DairyCo (2005). Heifer rearing in the 21st century. DairyCo desktop review 2005, MDC."]
[null,"DairyCo (2008). Datum. Dairy Statistics; an insiders guide, DairyCo: 55."]
[null,"DairyCo. (2009). \"DairyCo Datum.\"   Retrieved 21st July, 2009, from http://www.mdcdatum.org.uk/index.html."]
[null,"Enting, H., D. Kooij, et al. (1997). \"Economic losses due to clinical lameness in dairy cattle.\" Livestock Production Science 49(3): 259-267."]
[null,"Esslemont, R. J. and M. A. Kossaibati (2002). The Costs of Poor Fertility and Disease in UK Dairy Herds, Intervet."]
[null,"Esslemont, R. (2005) The costs of lameness in dairy herds, UK Vet, 10(1), 41-49."]
[null,"Green, L., V. Hedges, et al. (2002). \"The impact of clinical lameness on the milk yield of dairy cows.\" Journal of Dairy Science 85: 2250-2256."]
[null,"Hultgren, J., T. Manske, et al. (2004). \"Associations of sole ulcer at claw trimming with reproductive performance, udder health, milk yield, and culling in Swedish dairy cattle.\" Preventive Veterinary Medicine 62(4): 233-251."]
[null,"John Nix (2009). Farm Management Pocketbook, Impress Print."]
[null,"Lucey, S., G. Rowlands, et al. (1986). \"Short-term associations between disease and milk yield of dairy cows.\" J. Dairy Res. 53: 7-15."]
[null,"Skidmore, A., A. Brand, et al. (2001). Monitoring milk production: defining preset targets and execution. Herd health and production management in dairy practice. A. Brand, J. P. T. M. Noordhuizen and Y. Schukken, Wageningen Press."]
[null,"Whitaker, D., Kelly, J. and Smith, S. (2000) Disposal and disease rates in 340 British dairy herds, Vet Rec., 146, 363-367."]
[null,"Whitaker, D., A. Macrae, et al. (2004). \"Disposal and disease rates in British dairy herds between April 1998 and March 2002.\" Vet Rec. 155: 43-47."]

{"sheet":"Input","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"merged":[[1,1,1,2],[1,4,1,6],[8,4,8,6],[17,4,17,6],[18,1,18,2]],"flags":["formulas_cached_only"]}
[]
[null,"Herd Details",null,null,"Labour Costs"]
[null,"Milk Price (ppl)",22.5,null,"Vet Time/hr",null,{"v":70,"d":"£70.00"}]
[null,"Number of cows",112,null,"Vet Call Out Fee",null,{"v":17.5,"d":"£17.50"}]
[null,"Calving Index (days)",410,null,"Herdsman's Time/hr",null,{"v":7.42,"d":"£7.42"}]
[null,"Calving to Conception (days)",130,null,"Cost of service",null,{"v":20,"d":"£20.00"}]
[null,"Dry Period Length (days)",60]
[null,"Days in milk at drying off",350]
[null,"Weight of average cow in herd (kg)",650,null,"Treatment Costs"]
[null,"Value of average calf",{"v":120.12,"d":"£120.12"},null,"Cost of topical antibiotic spray can",null,{"v":5.2,"d":"£5.20"}]
[null,"Value/kg of cull cow liveweight",{"v":1,"d":"£1.00"},null,"Cost of injectable antibiotic used for treating feet for FIVE days",null,{"v":17.5,"d":"£17.50"}]
[null,"Margin over purchased feed (MOPF)",{"v":0.19,"d":"£0.19"},null,"Milk withdrawal of injectable used (days)",null,4.5]
[null,"305d Yield (L)",6885,null,"Cost of bandage",null,{"v":1.65,"d":"£1.65"}]
[null,"Average cow peak yield (L)",34.425,null,"Cost of a block",null,{"v":9.26,"d":"£9.26"}]
[null,"Yield peaks at (days/p-p)",42,null,"Cost of foot trim (farmer or foot-trimmer)",null,{"v":10,"d":"£10.00"}]
[null,"Yield decline of cows per day",{"v":0.003,"d":"0.30%"}]
[null,"Average yield per cow per day (L)",19.67142857142857]
[{"$nulls":4},"Lameness Incidence (cases/100cows/year)"]
[null,"Feed Details",{"$nulls":3},"On-farm","UK Average"]
[null,"Type of feeding system","PMR",null,"Digital Dermatitis",20,1.7]
[null,null,"PMR"]
[null,null,"TMR"]
[null,"Concentrate feeding rage (kg/l)",0.29,null,"Sole Ulcer",null,7.2]
[null,"Cost of concentrate/tonne",{"v":180,"d":"£180.00"},null,"Un-categorised lameness",null,6.2]
[null,"Cost of feeding HIGH yielder per day",{"v":0,"d":"£0.00"},null,"White Line Disease",null,5.6]
[null,"Cost of feeding LOW yielder per day",{"v":0,"d":"£0.00"}]

{"sheet":"Tx Options","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[3,1,3,3],[3,5,3,7],[16,1,16,3],[16,5,16,7],[29,1,29,3]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Sole Ulcer",{"$nulls":3},"General Lameness"]
[null,"First Treatment",{"v":0.15,"d":"15%"},"of sole ulcers treated by the vet alone",null,"First Treatment",{"v":0.15,"d":"15%"},"of general lameness treated by the vet alone"]
[null,null,{"v":0.2,"d":"20%"},"treated with injectable antibiotic",null,null,{"v":0.2,"d":"20%"},"treated with injectable antibiotic"]
[null,null,{"v":17.5,"d":"£17.50"},"per 100ml bottle of antibiotic",null,null,{"v":17.5,"d":"£17.50"},"per 100ml bottle of antibiotic"]
[null,null,5,"days of antibiotic given",null,null,5,"days of antibiotic given"]
[null,null,4.5,"days of milk withheld",null,null,4.5,"days of milk withheld"]
[null,null,{"v":0.5,"d":"50%"},"have a block applied",null,null,{"v":0,"d":"0%"},"have a block applied"]
[null,null,{"v":0,"d":"0%"},"have a bandage applied",null,null,{"v":0,"d":"0%"},"have a bandage applied"]
[null,"Repeat Treatments",{"$nulls":3},"Repeat Treatments"]
[null,null,{"v":0.5,"d":"50%"},"have a second block applied",null,null,{"v":0,"d":"0%"},"have a second block applied"]
[null,null,{"v":1,"d":"100%"},"have a second application of antibiotic spray",null,null,{"v":0.2,"d":"20%"},"have a second application of antibiotic spray"]
[null,null,{"v":1,"d":"100%"},"have FOUR further foot trims through the year",null,null,{"v":1,"d":"100%"},"have FOUR further foot trims through the year"]
[]
[null,"White Line Disease",{"$nulls":3},"Interdigital Lameness"]
[null,"First Treatment",{"v":0.15,"d":"15%"},"of white line disease treated by the vet alone",null,"First Treatment",{"v":0.15,"d":"15%"},"of interdigial lameness treated by the vet alone"]
[null,null,{"v":0.1,"d":"10%"},"treated with injectable antibiotic",null,null,{"v":1,"d":"100%"},"treated with injectable antibiotic"]
[null,null,{"v":17.5,"d":"£17.50"},"per 100ml bottle of antibiotic",null,null,{"v":17.5,"d":"£17.50"},"per 100ml bottle of antibiotic"]
[null,null,5,"days of antibiotic given",null,null,5,"days of antibiotic given"]
[null,null,4.5,"days of milk withheld",null,null,4.5,"days of milk withheld"]
[null,null,{"v":0.5,"d":"50%"},"have a block applied",null,null,{"v":0,"d":"0%"},"have a block applied"]
[null,null,{"v":0.2,"d":"20%"},"have a bandage applied",null,null,{"v":0,"d":"0%"},"have a bandage applied"]
[null,"Repeat Treatments",{"$nulls":3},"Repeat Treatments"]
[null,null,{"v":0.5,"d":"50%"},"have a second block applied",null,null,{"v":0,"d":"0%"},"have a second block applied"]
[null,null,{"v":1,"d":"100%"},"have a second application of antibiotic spray",null,null,{"v":0,"d":"0%"},"have a second application of antibiotic spray"]
[null,null,{"v":1,"d":"100%"},"have FOUR further foot trims through the year",null,null,{"v":0,"d":"0%"},"have FOUR further foot trims through the year"]
[]
[null,"Digital Dermatitis"]
[null,"First Treatment",{"v":0.15,"d":"15%"},"of digital dermatitis treated by the vet alone"]
[null,null,{"v":0,"d":"0%"},"treated with injectable antibiotic"]
[null,null,{"v":17.5,"d":"£17.50"},"per 100ml bottle of antibiotic"]
[null,null,0,"days of antibiotic given"]
[null,null,0,"days of milk withheld"]
[null,null,{"v":0,"d":"0%"},"have a block applied"]
[null,null,{"v":0.1,"d":"10%"},"have a bandage applied"]
[null,"Repeat Treatments"]
[null,null,{"v":0,"d":"0%"},"have a second block applied"]
[null,null,{"v":1,"d":"100%"},"have a second application of antibiotic spray"]
[null,null,{"v":0,"d":"0%"},"have FOUR further foot trims through the year"]

{"sheet":"Results","index":5,"n_rows":60,"n_cols":6,"rows_kept":60,"merged":[[3,1,3,2],[11,1,11,3]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Results"]
[null,"Cost of average day extension to Ca-Con",{"v":3.2044083931611413,"d":"£3.20"}]
[null,"Cost of digital dermatitis",{"v":74.78491786322282,"d":"£74.78"}]
[null,"Cost of digital lameness (not White Line Disease)",{"v":187.9736855408823,"d":"£187.97"}]
[null,"Cost of interdigital lameness",{"v":151.36313554088227,"d":"£151.36"}]
[null,"Cost of Sole Ulcer",{"v":524.4333250121599,"d":"£524.43"}]
[null,"Cost of White Line Disease",{"v":330.1492928693028,"d":"£330.15"}]
[]
[null,"Herd Results"]
[null,null,"Incidence","Cost"]
[null,"Digital Dermatitis",20,{"v":1675.1821601361912,"d":"£1,675.18"}]
[null,"Digital Lameness (not White Line Disease)",6.2,{"v":1305.2892723958867,"d":"£1,305.29"}]
[null,"Sole Ulcer",7.2,{"v":4229.030332898058,"d":"£4,229.03"}]
[null,"White Line Disease",5.6,{"v":2070.6963648762676,"d":"£2,070.70"}]
[null,"Cost of an 'average' case of lameness on this unit",null,{"v":212.4587484044506,"d":"£212.46"}]
[null,"Total cost of lameness in this herd",null,{"v":9280.198130306402,"d":"£9,280.20"}]
[null,"Total cost of lameness in the herd ppl",null,{"v":1.2034700345350142,"d":"1.20"}]
{"$rows_empty":33}
[{"$nulls":3},"Total cost to herd",null,"Breakdown for average "]
[null,null,"Vet Costs",{"v":19.5069,"d":"£19.51"},{"v":0.5001769230769231,"d":"£0.50"},{"v":3.0625,"d":"£3.06"}]
[null,null,"Medicine Costs",{"v":923.2784032,"d":"£923.28"},null,30.420721428571426]
[null,null,"Labour Costs",{"v":159.642784,"d":"£159.64"},{"v":4.093404717948718,"d":"£4.09"}]
[null,null,"Fertility Costs",{"v":4219.335350898571,"d":"£4,219.34"}]
[null,null,"Culling Costs",{"v":1812.5569280000004,"d":"£1,812.56"}]
[null,null,"Reduced Yield",{"v":1748.6201600000004,"d":"£1,748.62"}]

{"sheet":"Ca-Con Summary","index":6,"n_rows":43,"n_cols":7,"rows_kept":43,"merged":[[3,1,3,6],[8,5,8,6],[13,5,13,6],[25,1,25,6],[30,5,30,6],[35,5,35,6]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of extended calving index/calving-conception period if feeding a PMR"]
[]
[null,null,"Actual Figures","Target"]
[null,"Milk Price (ppl)",22.5]
[]
[null,"Calving index (days)",410,400,null,"Current Costs of Calving Index"]
[null,"Calving-Conception (days)",130,120,null,"Total cost of extension to Ca-Con over 365d",{"v":144.19837769225137,"d":"£144.20"}]
[null,"Dry period length (days)",60,null,null,"Cost per day of extension to Ca-Con over 365d",{"v":3.2044083931611413,"d":"£3.20"}]
[null,"Days in milk at drying off",350]
[null,"Value of average calf",{"v":120.12,"d":"£120.12"}]
[{"$nulls":5},"Potenial savings if targets achieved"]
[null,"305d Yield (L)",6885,null,null,"Total cost of extension to Ca-Con over 365d",{"v":102.20611465678328,"d":"£102.21"}]
[null,"Average cow peak yield (L)",34.425,null,null,"Cost per day of extension to Ca-Con over 365d",{"v":2.2712469923729617,"d":"£2.27"}]
[null,"Yield peaks at (days/p-p)",42,null,null,"Total potential saving",{"v":41.992263035468085,"d":"£41.99"}]
[null,"Yield decline of cows per day",{"v":0.003,"d":"0.30%"},null,null,"Potential saving per day",{"v":0.9331614007881797,"d":"£0.93"}]
[]
[null,"Concentrate feeding rage (kg/l)",0.29,null,null,"See Calculations if yield <8,000L"]
[null,"Cost of concentrate/tonne",{"v":180,"d":"£180.00"},null,null,"See Calculations if yield >8,000L"]
[]
[null,"Cost of ration for HIGH yielder per day",{"v":0,"d":"£0.00"}]
[null,"Cost of ration for LOW yielder per day",{"v":0,"d":"£0.00"}]
[]
[null,"Cost of extended calving index/calving-conception period if feeding ONLY a TMR"]
[]
[null,null,"Actual Figures","Target"]
[null,"Milk Price (ppl)",22.5]
[]
[null,"Calving index (days)",410,400,null,"Current Costs of Calving Index"]
[null,"Calving-Conception (days)",130,120,null,"Total cost of extension to Ca-Con over 365d",{"v":177.57528202651167,"d":"£177.58"}]
[null,"Dry period length (days)",60,null,null,"Cost per day of extension to Ca-Con over 365d",{"v":3.946117378366926,"d":"£3.95"}]
[null,"Days in milk at drying off",350]
[null,"Value of average calf",{"v":120.12,"d":"£120.12"}]
[{"$nulls":5},"Potenial savings if targets achieved"]
[null,"305d Yield (L)",6885,null,null,"Total cost of extension to Ca-Con over 365d",{"v":126.06700003469567,"d":"£126.07"}]
[null,"Average cow peak yield (L)",34.425,null,null,"Cost per day of extension to Ca-Con over 365d",{"v":2.8014888896599035,"d":"£2.80"}]
[null,"Yield peaks at (days/p-p)",42,null,null,"Total potential saving",{"v":51.508281991816006,"d":"£51.51"}]
[null,"Yield decline of cows per day",{"v":0.003,"d":"0.30%"},null,null,"Potential saving per day",{"v":1.1446284887070224,"d":"£1.14"}]
[]
[null,"Cost of ration for HIGH yielder per day",{"v":0,"d":"£0.00"},null,null,"See Calculations if yield <8,000L"]
[null,"Cost of ration for LOW yielder per day",{"v":0,"d":"£0.00"},null,null,"See Calculations if yield >8,000L"]

{"sheet":"Literature Review Figures","index":7,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[3,1,3,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Literature Review"]
[null,null,"Sole Ulcer","White Line Disease","Digital Dermatitis","General Lameness"]
[null,"Extension to Ca-Con Period (days)",40,40,20,8.9]
[null,"Reduced Yield (L)",574,369,0,360]

{"sheet":"Cost of Cull","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[3,1,3,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of Culling"]
[null,null,"Unit","Cost/Unit","Total"]
[null,"Return from sale",650,{"v":1,"d":"£1.00"},{"v":650,"d":"£650.00"}]
[null,"Cost of rearing replacement heifer",1,{"v":712,"d":"£712.00"},{"v":712,"d":"£712.00"}]
[null,"Lower milk yield from heifer",1377,{"v":0.19,"d":"£0.19"},{"v":261.63,"d":"£261.63"}]
[null,"Value of smaller calf from heifer",null,null,{"v":8,"d":"£8.00"}]
[null,"Total cost of culling",null,null,{"v":331.63,"d":"£331.63"}]

{"sheet":"Tx Costs","index":9,"n_rows":25,"n_cols":17,"rows_kept":25,"merged":[[3,1,3,16],[4,2,4,4],[4,5,4,7],[4,8,4,10],[4,11,4,13],[4,14,4,16],[13,1,13,16],[14,2,14,4],[14,5,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,16]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of FIRST treatment"]
[null,null,"Sole Ulcer",null,null,"White Line Disease",null,null,"Digital Dermatitis",null,null,"General Lameness",null,null,"Interdigital Lameness"]
[null,null,"Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total"]
[null,"Cost of topical treatment",3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"}]
[null,"Cost of injectable treatment",{"v":0.2,"d":"20%"},{"v":17.5,"d":"£17.50"},{"v":3.5,"d":"£3.50"},{"v":0.1,"d":"10%"},{"v":17.5,"d":"£17.50"},{"v":1.75,"d":"£1.75"},{"v":0,"d":"0%"},{"v":17.5,"d":"£17.50"},{"v":0,"d":"£0.00"},{"v":0.2,"d":"20%"},{"v":17.5,"d":"£17.50"},{"v":3.5,"d":"£3.50"},{"v":0.6,"d":"60%"},{"v":17.5,"d":"£17.50"},{"v":10.5,"d":"£10.50"}]
[null,"Bandage",{"v":0,"d":"0%"},{"v":1.65,"d":"£1.65"},{"v":0,"d":"£0.00"},{"v":0.2,"d":"20%"},{"v":1.65,"d":"£1.65"},{"v":0.33,"d":"£0.33"},{"v":0.1,"d":"10%"},{"v":1.65,"d":"£1.65"},{"v":0.165,"d":"£0.17"},{"v":0,"d":"0%"},{"v":1.65,"d":"£1.65"},{"v":0,"d":"£0.00"},{"v":0,"d":"0%"},{"v":1.65,"d":"£1.65"},{"v":0,"d":"£0.00"}]
[null,"Block",{"v":0.5,"d":"50%"},{"v":9.26,"d":"£9.26"},{"v":4.63,"d":"£4.63"},{"v":0.5,"d":"50%"},{"v":9.26,"d":"£9.26"},{"v":4.63,"d":"£4.63"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"}]
[null,"Cost of withheld milk",17.704285714285714,{"v":0.19,"d":"£0.19"},{"v":3.3638142857142856,"d":"£3.36"},8.852142857142857,{"v":0.19,"d":"£0.19"},{"v":1.6819071428571428,"d":"£1.68"},0,{"v":0.19,"d":"£0.19"},{"v":0,"d":"£0.00"},17.704285714285714,{"v":0.19,"d":"£0.19"},{"v":3.3638142857142856,"d":"£3.36"},53.112857142857145,{"v":0.19,"d":"£0.19"},{"v":10.091442857142857,"d":"£10.09"}]
[null,"Total cost of FIRST treatment per case",null,null,{"v":12.273814285714286,"d":"£12.27"},null,null,{"v":9.171907142857144,"d":"£9.17"},null,null,{"v":0.9450000000000001,"d":"£0.95"},null,null,{"v":7.643814285714286,"d":"£7.64"},null,null,{"v":21.371442857142856,"d":"£21.37"}]
[]
[null,"Cost of REPEAT treatment"]
[null,null,"Sole Ulcer",null,null,"White Line Disease",null,null,"Digital Dermatitis",null,null,"General Lameness",null,null,"Interdigital Lameness"]
[null,null,"Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total","Units/Proportion","Cost/unit","Total"]
[null,"Trimming of the chronically lame cow",4,{"v":10,"d":"£10.00"},{"v":40,"d":"£40.00"},4,{"v":10,"d":"£10.00"},{"v":40,"d":"£40.00"},0,{"v":10,"d":"£10.00"},{"v":0,"d":"£0.00"},4,{"v":10,"d":"£10.00"},{"v":40,"d":"£40.00"},0,{"v":10,"d":"£10.00"},{"v":0,"d":"£0.00"}]
[null,"Repeat treatments"]
[null,"Cost of topical treatment",3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},3,{"v":0.26,"d":"£0.26"},{"v":0.78,"d":"£0.78"},0.6000000000000001,{"v":0.26,"d":"£0.26"},{"v":0.15600000000000003,"d":"£0.16"},0,{"v":0.26,"d":"£0.26"},{"v":0,"d":"£0.00"}]
[null,"Block",{"v":0.5,"d":"50%"},{"v":9.26,"d":"£9.26"},{"v":2.315,"d":"£2.32"},{"v":0.5,"d":"50%"},{"v":9.26,"d":"£9.26"},{"v":2.315,"d":"£2.32"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"},{"v":0,"d":"0%"},{"v":9.26,"d":"£9.26"},{"v":0,"d":"£0.00"}]
[null,"Total cost of REPEAT treatment per case",null,null,{"v":43.095,"d":"£43.10"},null,null,{"v":43.095,"d":"£43.10"},null,null,{"v":0.78,"d":"£0.78"},null,null,{"v":40.156,"d":"£40.16"},null,null,{"v":0,"d":"£0.00"}]
[]
[]
[null,null,"Sole Ulcer","White Line Disease","Digital Dermatitis","General Lameness","Interdigital Lameness"]
[null,"Total treatment cost of each lesion",{"v":55.368814285714286,"d":"£55.37"},{"v":52.26690714285714,"d":"£52.27"},{"v":1.725,"d":"£1.73"},{"v":47.799814285714284,"d":"£47.80"},{"v":21.371442857142856,"d":"£21.37"}]

{"sheet":"Digital Dermatitis","index":10,"n_rows":129,"n_cols":8,"rows_kept":129,"merged":[[3,1,3,4],[26,1,26,2]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of Digital Dermatitis"]
[null,null,"Units","Cost/Unit","Total"]
[null,"Labour Costs"]
[null,"FIRST treatment"]
[null,"Herdsman's Time if self-treated",30,{"v":7.42,"d":"£7.42"},{"v":3.1534999999999997,"d":"£3.15"}]
[null,"Herdsman's Time if vet treating",20,{"v":7.42,"d":"£7.42"},{"v":0.37099999999999994,"d":"£0.37"}]
[null,"Vet Time",10,{"v":70,"d":"£70.00"},{"v":1.7500000000000002,"d":"£1.75"}]
[null,"Cost of visit",0.3,{"v":17.5,"d":"£17.50"},{"v":0.7875,"d":"£0.79"}]
[null,"REPEAT treatment"]
[null,"Herdsman's time",15,{"v":7.42,"d":"£7.42"},{"v":1.855,"d":"£1.86"}]
[null,"Cost of treatment",null,null,{"v":1.725,"d":"£1.73"}]
[null,"Cost of reduced yield",0,{"v":0.19,"d":"£0.19"},{"v":0,"d":"£0.00"}]
[null,"Fertility Costs"]
[null,"Cost of extension to Ca-Con",20,{"v":3.2044083931611413,"d":"£3.20"},{"v":64.08816786322282,"d":"£64.09"}]
[null,"Extra serves",0.2,{"v":20,"d":"£20.00"},{"v":4,"d":"£4.00"}]
[null,"Cost of culling"]
[null,"Increased risk of culling",{"v":0,"d":"0.00%"},{"v":331.63,"d":"£331.63"},{"v":0,"d":"£0.00"}]
[]
[null,"Cost of treatment by the farmer",null,null,{"v":74.82166786322281,"d":"£74.82"}]
[null,"Cost of treatment by the vet",null,null,{"v":74.57666786322282,"d":"£74.58"}]
[]
[null,"Average cost a case of digital dermatitis",null,null,{"v":74.78491786322282,"d":"£74.78"}]
[]
[null,"For a graphical breakdown follow this link"]
{"$rows_empty":96}
[{"$nulls":5},"Vet Costs",{"v":0.380625,"d":"£0.38"},8.526]
[{"$nulls":5},"Medicine Costs",{"v":1.725,"d":"£1.73"},38.64000000000001]
[{"$nulls":5},"Labour Costs",{"v":3.1534999999999997,"d":"£3.15"},70.6384]
[{"$nulls":5},"Fertility Costs",{"v":68.08816786322282,"d":"£68.09"},1525.1749601361914]
[{"$nulls":5},"Culling Costs",{"v":0,"d":"£0.00"},0]
[{"$nulls":5},"Reduced Yield",0,0]

{"sheet":"White Line Disease","index":11,"n_rows":108,"n_cols":5,"rows_kept":108,"merged":[[3,1,3,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of White Line Disease"]
[null,null,"Units","Cost/Unit","Total"]
[null,"Labour Costs"]
[null,"FIRST treatment"]
[null,"Herdsman's Time if self-treated",30,{"v":7.42,"d":"£7.42"},{"v":3.1534999999999997,"d":"£3.15"}]
[null,"Herdsman's Time if vet treating",20,{"v":7.42,"d":"£7.42"},{"v":0.37099999999999994,"d":"£0.37"}]
[null,"Vet Time",10,{"v":70,"d":"£70.00"},{"v":1.7500000000000002,"d":"£1.75"}]
[null,"Cost of visit",0.3,{"v":17.5,"d":"£17.50"},{"v":0.7875,"d":"£0.79"}]
[null,"REPEAT treatment"]
[null,"Herdsman's time",0,{"v":7.42,"d":"£7.42"},{"v":0,"d":"£0.00"}]
[null,"Cost of treatment",null,null,{"v":52.26690714285714,"d":"£52.27"}]
[null,"Cost of reduced yield",369,{"v":0.19,"d":"£0.19"},{"v":70.11,"d":"£70.11"}]
[null,"Fertility Costs"]
[null,"Cost of extension to Ca-Con",40,{"v":3.2044083931611413,"d":"£3.20"},{"v":128.17633572644564,"d":"£128.18"}]
[null,"Extra serves",2,{"v":20,"d":"£20.00"},{"v":40,"d":"£40.00"}]
[null,"Cost of culling"]
[null,"Increased risk of culling",{"v":0.11,"d":"11.00%"},{"v":331.63,"d":"£331.63"},{"v":36.4793,"d":"£36.48"}]
[]
[null,"Cost of treatment by the farmer",null,null,{"v":330.1860428693028,"d":"£330.19"}]
[null,"Cost of treatment by the vet",null,null,{"v":329.9410428693028,"d":"£329.94"}]
[]
[null,"Average cost of treating a case of White Line Disease",null,null,{"v":330.1492928693028,"d":"£330.15"}]
[]
[null,"For a graphical breakdown follow this link"]
{"$rows_empty":75}
[null,null,"Vet Costs",{"v":0.380625,"d":"£0.38"},{"v":2.38728,"d":"£2.39"}]
[null,null,"Medicine Costs",{"v":52.26690714285714,"d":"£52.27"},{"v":327.8180416,"d":"£327.82"}]
[null,null,"Labour Costs",{"v":3.1534999999999997,"d":"£3.15"},{"v":19.778752,"d":"£19.78"}]
[null,null,"Fertility Costs",{"v":168.17633572644564,"d":"£168.18"},{"v":1054.8019776762671,"d":"£1,054.80"}]
[null,null,"Culling Costs",{"v":36.4793,"d":"£36.48"},{"v":228.79816960000002,"d":"£228.80"}]
[null,null,"Reduced Yield",{"v":70.11,"d":"£70.11"},{"v":439.72992,"d":"£439.73"}]

{"sheet":"Digital","index":12,"n_rows":107,"n_cols":5,"rows_kept":107,"merged":[[3,1,3,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of General Digital Lameness (not White Line Disease)"]
[null,null,"Units","Cost/Unit","Total"]
[null,"Labour Costs"]
[null,"Herdsman's Time if self-treated",30,{"v":7.42,"d":"£7.42"},{"v":3.1534999999999997,"d":"£3.15"}]
[null,"Herdsman's Time if vet treating",20,{"v":7.42,"d":"£7.42"},{"v":0.37099999999999994,"d":"£0.37"}]
[null,"Vet Time",15,{"v":70,"d":"£70.00"},{"v":2.625,"d":"£2.63"}]
[null,"Cost of visit",0.3,{"v":17.5,"d":"£17.50"},{"v":0.7875,"d":"£0.79"}]
[null,"REPEAT treatment"]
[null,"Herdsman's time",0,{"v":7.42,"d":"£7.42"},{"v":0,"d":"£0.00"}]
[null,"Cost of treatment",null,null,{"v":21.371442857142856,"d":"£21.37"}]
[null,"Cost of reduced yield",360,{"v":0.19,"d":"£0.19"},{"v":68.4,"d":"£68.40"}]
[null,"Fertility Costs"]
[null,"Cost of extension to Ca-Con",17,{"v":3.2044083931611413,"d":"£3.20"},{"v":54.4749426837394,"d":"£54.47"}]
[null,"Extra serves",0.2,{"v":20,"d":"£20.00"},{"v":4,"d":"£4.00"}]
[null,"Cost of culling"]
[null,"Increased risk of culling",{"v":0.11,"d":"11.00%"},{"v":331.63,"d":"£331.63"},{"v":36.4793,"d":"£36.48"}]
[]
[null,"Cost of treatment by the farmer",null,null,{"v":187.87918554088228,"d":"£187.88"}]
[null,"Cost of treatment by the vet",null,null,{"v":188.50918554088227,"d":"£188.51"}]
[]
[null,"Average cost of digital lameness",null,null,{"v":187.9736855408823,"d":"£187.97"}]
[]
[null,"For a graphical breakdown follow this link"]
{"$rows_empty":75}
[null,null,"Vet Costs",{"v":0.511875,"d":"£0.51"},4.12776]
[null,null,"Medicine Costs",{"v":21.371442857142856,"d":"£21.37"},172.33931520000004]
[null,null,"Labour Costs",{"v":3.1534999999999997,"d":"£3.15"},25.429824000000004]
[null,null,"Fertility Costs",{"v":58.4749426837394,"d":"£58.47"},471.54193780167464]
[null,null,"Culling Costs",{"v":36.4793,"d":"£36.48"},294.16907520000007]
[null,null,"Reduced Yield",{"v":68.4,"d":"£68.40"},551.5776000000002]

{"sheet":"Inter-digital","index":13,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[3,1,3,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of Interdigital Lameness"]
[null,null,"Units","Cost/Unit","Total"]
[null,"Labour Costs"]
[null,"FIRST treatment"]
[null,"Herdsman's Time if self-treated",30,{"v":7.42,"d":"£7.42"},{"v":3.1534999999999997,"d":"£3.15"}]
[null,"Herdsman's Time if vet treating",20,{"v":7.42,"d":"£7.42"},{"v":0.37099999999999994,"d":"£0.37"}]
[null,"Vet Time",10,{"v":70,"d":"£70.00"},{"v":1.7500000000000002,"d":"£1.75"}]
[null,"Cost of visit",0.3,{"v":17.5,"d":"£17.50"},{"v":0.7875,"d":"£0.79"}]
[null,"REPEAT treatment"]
[null,"Herdsman's time",0,{"v":7.42,"d":"£7.42"},{"v":0,"d":"£0.00"}]
[null,"Cost of treatment",null,null,{"v":21.371442857142856,"d":"£21.37"}]
[null,"Cost of reduced yield",360,{"v":0.19,"d":"£0.19"},{"v":68.4,"d":"£68.40"}]
[null,"Fertility Costs"]
[null,"Cost of extension to Ca-Con",17,{"v":3.2044083931611413,"d":"£3.20"},{"v":54.4749426837394,"d":"£54.47"}]
[null,"Extra serves",0.2,{"v":20,"d":"£20.00"},{"v":4,"d":"£4.00"}]
[null,"Cost of culling"]
[null,"Increased risk of culling",{"v":0,"d":"0.00%"},{"v":331.63,"d":"£331.63"},{"v":0,"d":"£0.00"}]
[]
[null,"Cost of treatment by the farmer",null,null,{"v":151.39988554088228,"d":"£151.40"}]
[null,"Cost of treatment by the vet",null,null,{"v":151.15488554088228,"d":"£151.15"}]
[]
[null,"Average cost of treating interdigital lameness (not digital dermatitis)",null,null,{"v":151.36313554088227,"d":"£151.36"}]

{"sheet":"Sole Ulcer","index":14,"n_rows":108,"n_cols":6,"rows_kept":108,"merged":[[3,1,3,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Cost of Sole Ulcer"]
[null,null,"Units","Cost/Unit","Total"]
[null,"Labour Costs"]
[null,"FIRST treatment"]
[null,"Herdsman's Time if self-treated",60,{"v":7.42,"d":"£7.42"},{"v":6.3069999999999995,"d":"£6.31"}]
[null,"Herdsman's Time if vet treating",40,{"v":7.42,"d":"£7.42"},{"v":0.7419999999999999,"d":"£0.74"}]
[null,"Vet Time",20,{"v":70,"d":"£70.00"},{"v":3.5000000000000004,"d":"£3.50"}]
[null,"Cost of visit",0.3,{"v":17.5,"d":"£17.50"},{"v":0.7875,"d":"£0.79"}]
[null,"REPEAT treatment"]
[null,"Herdsman's time",0,{"v":7.42,"d":"£7.42"},{"v":0,"d":"£0.00"}]
[null,"Cost of treatment",null,null,{"v":55.368814285714286,"d":"£55.37"}]
[null,"Cost of reduced yield",574,{"v":0.19,"d":"£0.19"},{"v":109.06,"d":"£109.06"}]
[null,"Fertility Costs"]
[null,"Cost of extension to Ca-Con",40,{"v":3.2044083931611413,"d":"£3.20"},{"v":128.17633572644564,"d":"£128.18"}]
[null,"Extra serves",2,{"v":20,"d":"£20.00"},{"v":40,"d":"£40.00"}]
[null,"Cost of culling"]
[null,"Increased risk of culling",{"v":0.56,"d":"56.00%"},{"v":331.63,"d":"£331.63"},{"v":185.71280000000002,"d":"£185.71"}]
[]
[null,"Cost of treatment by the farmer",null,null,{"v":524.62495001216,"d":"£524.62"}]
[null,"Cost of treatment by the vet",null,null,{"v":523.3474500121599,"d":"£523.35"}]
[]
[null,"Average cost of treating sole ulcer",null,null,{"v":524.4333250121599,"d":"£524.43"}]
[]
[null,"For a graphical breakdown follow this link"]
{"$rows_empty":75}
[null,null,"Vet Costs",0.6431250000000001,null,4.465860000000001]
[null,null,"Medicine Costs",{"v":55.368814285714286,"d":"£55.37"},null,384.4810464]
[null,null,"Labour Costs",{"v":6.3069999999999995,"d":"£6.31"},null,43.795808]
[null,null,"Fertility Costs",{"v":168.17633572644564,"d":"£168.18"},null,1167.8164752844386]
[null,null,"Culling Costs",{"v":185.71280000000002,"d":"£185.71"},null,1289.5896832000003]
[null,null,"Reduced Yield",{"v":109.06,"d":"£109.06"},null,757.3126400000001]

{"sheet":"TMR 6-8K","index":15,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[3,1,3,5],[33,0,34,0]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"TMR (6,000-8,000L)"]
[]
[null,"Calving to conception (days)","85-100","101-115","116-145","146-175"]
[null,"No of days in period days)",15,15,30,30]
[null,"Calving Interval (days)",381,396,426,456]
[]
["A","No of days by which lactation is extended per one day delay (days)",1,0.7,0.4,0]
["B","Effect of putting off next lactation (lost litres/day) (=7500/305)",{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"}]
["C","Yield in last day of extended period (litres)",12.43175997903773,11.883927434480793,10.859622798723308,9.923605473084365]
["D","Yield gained from the extended period (litres) (=C*A)",{"v":12.43175997903773,"d":"12.43"},{"v":8.318749204136555,"d":"8.32"},{"v":4.343849119489323,"d":"4.34"},{"v":0,"d":"0.00"}]
["E","Net loss in annual yield per day of delay in conception (litres) (=B-D)",{"v":10.14201051276555,"d":"10.14"},{"v":14.255021287666725,"d":"14.26"},{"v":18.229921372313957,"d":"18.23"},{"v":22.57377049180328,"d":"22.57"}]
["F","Value of milk loss/day",{"v":2.281952365372249,"d":"£2.28"},{"v":3.2073797897250134,"d":"£3.21"},{"v":4.10173230877064,"d":"£4.10"},{"v":5.079098360655738,"d":"£5.08"}]
[]
["G","Cost saved in feeding, if lactation extended, ONE extra day fed as a LOW, but ONE day saved as a HIGH (=Cost of feeding high-cost of feeding low per day)",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[]
["I","Cost of calf per day (£) [Average cost of calf/365]",{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"}]
["J","Cost of extra dry day (£) (=1-A)",{"v":0,"d":"£0.00"},{"v":0.3,"d":"£0.30"},{"v":0.6,"d":"£0.60"},{"v":1,"d":"£1.00"}]
["K","Benefit in delay of calving for reduced risk of disease",{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"}]
["L","Increased yield from non-pregnant cows",{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"}]
[null,"Extra vet and AI costs",{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"}]
[]
[null,"NET cost of lost day",{"v":2.7310482557832074,"d":"£2.73"},{"v":3.9564756801359717,"d":"£3.96"},{"v":5.150828199181599,"d":"£5.15"},{"v":6.528194251066697,"d":"£6.53"}]
[null,"NET cost of period",{"v":40.96572383674811,"d":"£40.97"},{"v":59.347135202039574,"d":"£59.35"},{"v":154.52484597544796,"d":"£154.52"},{"v":195.84582753200092,"d":"£195.85"}]
[]
[null,null,"Actual","Target"]
[null,"Average cost of extension for this herd",{"v":177.57528202651167,"d":"£177.58"},{"v":126.06700003469567,"d":"£126.07"}]
[null,"Average cost per day",{"v":3.946117378366926,"d":"£3.95"},{"v":2.8014888896599035,"d":"£2.80"}]

{"sheet":"TMR 8-10K","index":16,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[3,1,3,6],[33,0,34,0]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"TMR (8,000-10,000L)"]
[]
[null,"Calving to conception (days)","85-115","116-145","146-175","176-205","206-235"]
[null,"No of days in period days)",30,30,30,30,30]
[null,"Calving Interval (days)",395,425,455,485,515]
[]
["A","No of days by which lactation is extended per one day delay (days)",1,0.7,0.4,0.1,0]
["B","Effect of putting off next lactation (lost litres/day) (=7500/305)",{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"}]
["C","Yield in last day of extended period (litres)",11.919686493962681,10.892299697816757,9.953465870696453,9.095552416628502,8.311584611667328]
["D","Yield gained from the extended period (litres) (=C*A)",{"v":11.919686493962681,"d":"11.92"},{"v":7.624609788471729,"d":"7.62"},{"v":3.9813863482785816,"d":"3.98"},{"v":0.9095552416628503,"d":"0.91"},{"v":0,"d":"0.00"}]
["E","Net loss in annual yield per day of delay in conception (litres) (=B-D)",{"v":10.6540839978406,"d":"10.65"},{"v":14.94916070333155,"d":"14.95"},{"v":18.592384143524697,"d":"18.59"},{"v":21.66421525014043,"d":"21.66"},{"v":22.57377049180328,"d":"22.57"}]
["F","Value of milk loss/day",{"v":2.397168899514135,"d":"£2.40"},{"v":3.363561158249599,"d":"£3.36"},{"v":4.183286432293057,"d":"£4.18"},{"v":4.874448431281597,"d":"£4.87"},{"v":5.079098360655738,"d":"£5.08"}]
[]
["G","Cost saved in feeding; if lactation extended, ONE extra day fed as a LOW, but ONE day saved as a HIGH (=Cost of feeding high-cost of feeding low per day)",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[]
["I","Cost of calf per day (£) [Average cost of calf/365]",{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"}]
["J","Cost of extra dry day (£) (=1-A)",{"v":0,"d":"£0.00"},{"v":0.3,"d":"£0.30"},{"v":0.6,"d":"£0.60"},{"v":1,"d":"£1.00"},{"v":1,"d":"£1.00"}]
["K","Benefit in delay of calving for reduced risk of disease",{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"}]
["L","Increased yield from non-pregnant cows",{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"}]
[null,"Extra vet and AI costs",{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"}]
[]
[null,"NET cost of lost day",{"v":2.846264789925094,"d":"£2.85"},{"v":4.112657048660558,"d":"£4.11"},{"v":5.232382322704016,"d":"£5.23"},{"v":6.323544321692556,"d":"£6.32"},{"v":6.528194251066697,"d":"£6.53"}]
[null,"NET cost of period",{"v":85.38794369775282,"d":"£85.39"},{"v":123.37971145981673,"d":"£123.38"},{"v":156.97146968112048,"d":"£156.97"},{"v":189.7063296507767,"d":"£189.71"},{"v":195.84582753200092,"d":"£195.85"}]
[]
[null,null,"Actual","Target"]
[null,"Average cost of extension for this herd",{"v":147.07779942766118,"d":"£147.08"},{"v":105.9512289410556,"d":"£105.95"}]
[null,"Average cost per day",{"v":3.268395542836915,"d":"£3.27"},{"v":3.0271779697444456,"d":"£3.03"}]

{"sheet":"PMR 6-8K","index":17,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[3,1,3,5],[35,0,36,0]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"PMR (6,000-8,000L)"]
[]
[null,"Calving to conception (days)","85-100","101-115","116-145","146-175"]
[null,"No of days in period days)",15,15,30,30]
[null,"Calving Interval (days)",381,396,426,456]
[]
["A","No of days by which lactation is extended per one day delay (days)",1,0.7,0.4,0]
["B","Effect of putting off next lactation (lost litres/day)",{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"}]
["C","Yield in last day of extended period (litres)",12.43175997903773,11.883927434480793,10.859622798723308,9.923605473084365]
["D","Yield gained from the extended period (litres) (=C*A)",{"v":12.43175997903773,"d":"12.43"},{"v":8.318749204136555,"d":"8.32"},{"v":4.343849119489323,"d":"4.34"},{"v":0,"d":"0.00"}]
["E","Net loss in annual yield per day of delay in conception (litres) (=B-D)",{"v":10.14201051276555,"d":"10.14"},{"v":14.255021287666725,"d":"14.26"},{"v":18.229921372313957,"d":"18.23"},{"v":22.57377049180328,"d":"22.57"}]
["F","Value of milk loss/day",{"v":2.281952365372249,"d":"£2.28"},{"v":3.2073797897250134,"d":"£3.21"},{"v":4.10173230877064,"d":"£4.10"},{"v":5.079098360655738,"d":"£5.08"}]
[]
[null,"Concentrate feeding rate (kg/l)",0.29,0.29,0.29,0.29]
["G","Cost of saved concentrate",{"v":0.5294129487663617,"d":"£0.53"},{"v":0.7441121112162029,"d":"£0.74"},{"v":0.9516018956347884,"d":"£0.95"},{"v":1.178350819672131,"d":"£1.18"}]
[null,"Saving made when low yielder fed not high yielder",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[]
["I","Cost of calf per day (£) [Average cost of calf/365]",{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"}]
["J","Cost of extra dry day (£) (=1-A)",{"v":0,"d":"£0.00"},{"v":0.3,"d":"£0.30"},{"v":0.6,"d":"£0.60"},{"v":1,"d":"£1.00"}]
["K","Benefit in delay of calving for reduced risk of disease",{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"}]
["L","Increased yield from non-pregnant cows",{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"}]
[null,"Extra vet and AI costs",{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"}]
[]
[null,"NET cost of lost day",{"v":2.201635307016846,"d":"£2.20"},{"v":3.212363568919769,"d":"£3.21"},{"v":4.19922630354681,"d":"£4.20"},{"v":5.349843431394566,"d":"£5.35"}]
[null,"NET cost of period",{"v":33.024529605252695,"d":"£33.02"},{"v":48.18545353379653,"d":"£48.19"},{"v":125.97678910640431,"d":"£125.98"},{"v":160.495302941837,"d":"£160.50"}]
[]
[null,null,"Actual","Target"]
[null,"Average cost of extension for this herd",{"v":144.19837769225137,"d":"£144.20"},{"v":102.20611465678328,"d":"£102.21"}]
[null,"Average cost per day",{"v":3.2044083931611413,"d":"£3.20"},{"v":2.2712469923729617,"d":"£2.27"}]

{"sheet":"PMR 8-10K","index":18,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[3,1,3,6],[35,0,36,0]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"PMR (8,000-10,000L)"]
[]
[null,"Calving to conception (days)","85-115","116-145","146-175","176-205","206-235"]
[null,"No of days in period days)",30,30,30,30,30]
[null,"Calving Interval (days)",395,425,455,485,515]
[]
["A","No of days by which lactation is extended per one day delay (days)",1,0.7,0.4,0.1,0]
["B","Effect of putting off next lactation (lost litres/day) (=7500/305)",{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"},{"v":22.57377049180328,"d":"22.57"}]
["C","Yield in last day of extended period (litres)",11.919686493962681,10.892299697816757,9.953465870696453,9.095552416628502,8.311584611667328]
["D","Yield gained from the extended period (litres) (=C*A)",{"v":11.919686493962681,"d":"11.92"},{"v":7.624609788471729,"d":"7.62"},{"v":3.9813863482785816,"d":"3.98"},{"v":0.9095552416628503,"d":"0.91"},{"v":0,"d":"0.00"}]
["E","Net loss in annual yield per day of delay in conception (litres) (=B-D)",{"v":10.6540839978406,"d":"10.65"},{"v":14.94916070333155,"d":"14.95"},{"v":18.592384143524697,"d":"18.59"},{"v":21.66421525014043,"d":"21.66"},{"v":22.57377049180328,"d":"22.57"}]
["F","Value of milk loss/day",{"v":2.397168899514135,"d":"£2.40"},{"v":3.363561158249599,"d":"£3.36"},{"v":4.183286432293057,"d":"£4.18"},{"v":4.874448431281597,"d":"£4.87"},{"v":5.079098360655738,"d":"£5.08"}]
[]
[null,"Concentrate feeding rate (kg/l)",0.29,0.29,0.29,0.29,0.29]
["G","Cost of saved concentrate",{"v":0.5561431846872792,"d":"£0.56"},{"v":0.7803461887139068,"d":"£0.78"},{"v":0.9705224522919891,"d":"£0.97"},{"v":1.1308720360573303,"d":"£1.13"},{"v":1.178350819672131,"d":"£1.18"}]
[null,"Saving made when low yielder fed not high yielder",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[]
["I","Cost of calf per day (£) [Average cost of calf/365]",{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"},{"v":0.32909589041095894,"d":"£0.33"}]
["J","Cost of extra dry day (£) (=1-A)",{"v":0,"d":"£0.00"},{"v":0.3,"d":"£0.30"},{"v":0.6,"d":"£0.60"},{"v":1,"d":"£1.00"},{"v":1,"d":"£1.00"}]
["K","Benefit in delay of calving for reduced risk of disease",{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"},{"v":0.43,"d":"£0.43"}]
["L","Increased yield from non-pregnant cows",{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"},{"v":0.15,"d":"£0.15"}]
[null,"Extra vet and AI costs",{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"},{"v":0.7,"d":"£0.70"}]
[]
[null,"NET cost of lost day",{"v":2.2901216052378146,"d":"£2.29"},{"v":3.3323108599466513,"d":"£3.33"},{"v":4.261859870412027,"d":"£4.26"},{"v":5.192672285635226,"d":"£5.19"},{"v":5.349843431394566,"d":"£5.35"}]
[null,"NET cost of period",{"v":68.70364815713444,"d":"£68.70"},{"v":99.96932579839954,"d":"£99.97"},{"v":127.85579611236082,"d":"£127.86"},{"v":155.78016856905677,"d":"£155.78"},{"v":160.495302941837,"d":"£160.50"}]
[]
[null,null,"Actual","Target"]
[null,"Average cost of extension for this herd",{"v":118.68831105633421,"d":"£118.69"},{"v":85.36520245686769,"d":"£85.37"}]
[null,"Average cost per day",{"v":2.637518023474094,"d":"£2.64"},{"v":2.439005784481934,"d":"£2.44"}]