This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Your herd
Your herd
Settings
Input
Output
Number of cows per 100 cows that died or got euthanized in the herd during the last 12 months
Dead cows, %
Dead cows due to, %
Reduction target, %
Input: herd data
Today
Number of cows per 100 cows that died or got euthanized with lameness being the primary cause of death
Lameness
Average number of lactating cows and dry cows during one year. The number of cow-years is calculated as the total number of feeding days of lactating- and dry-cows during a year, divided by 365.
Herd size
Number of cows per 100 cows that died or got euthanized with metabolic diseases being the primary cause of death
Metabolic
Milk yield level per cow-year: amount of milk produced on the farm divided by the total number of cow-years.
Milk yield, kg ECM/cow-year
Number of cows per 100 cows that died or got euthanized with mastitis being the primary cause of death
Mastitis
The chance of a succesful observation and insemination of a cow during each cycle (21 days). It is calculated as the product of the "heat observation rate" and "conception rate"
Reproductive efficiency
Number of cows per 100 cows that died or got euthanized with an injury being the primary cause of death.
Injuries
Number of cows per 100 cows that died or got euthanized. Here we define mortality as sudden death, without it being caused or preceeded by a disease.
Unspecified cause
More info
Estimated true incidence
An estimate of the size of the entire ice- berg: based on the number of cows that dies because of lameness (tip of the iceberg), we estimate the TOTAL number of lame cows in the herd.
Lameness, %
An estimate of the size of the entire ice- berg: based on the number of cows that dies because of metabolic diseases (tip of the iceberg), we estimate the TOTAL number of cows with metabolic diseases in the herd.
Metabolic diseases, %
An estimate of the size of the entire ice- berg: based on the number of cows that dies because of mastitis (tip of the iceberg), we estimate the TOTAL number of cows with mastitis in the herd. This estimated number represents the severe cases of mastitis (gram negative) and not just all cases of mastitis (Aureus and other Gram positive).
Mastitis, %
Output: KPI changes
Output: changes
Change in annual replacement rate, which not only covers fewer dead cows, but also fewer other cullings (cows send to slaughter because of health and fertility reasons)
Replacement rate
Total amount of methane produced on the farm (by cows and youngstock) divided by the amount of milk produced on the farm
Methane emission per kg ECM
The simulated change in the number of surplus heifers that can be sold every year as an effect of lower cow mortality.
Sold surplus heifers per year
Change in labor need because of fewer disease treatments, mortality handling and heifer raising
Labour need, hours per week
Change in milk yield per cow-year
Milk yield, kg ECM/cow-year
Net Return per cow per year
Change in lifetime production due to cows' longer life and higher milk yield while alive
Lifetime production, kg ECM
Net Return per herd per year
More info
Settings
Milk, feed and livestock
Milk price, € per kg milk (4.2% / 3.4%)
Feeding costs, € per kg DM
Disposal costs per dead cow, €
Price of a heifer, €
Treatment costs, € per case
Lameness
Metabolic disease
Mastitis
About this SimHerd application
Print