An optional marketing sheet is available. Producers can record the number of stockersfrom each load that were sorted into commingled pastures for grazing. The Stockers Records Spreadsheet has four page formats which are linked together: 1)Health Treatment of Sick Pulls (treatment data input from chute-side sick pull records)2)Load Data ( 1 – 10)(Purchase information, processing, feed, death loss, total load cost)3)Load Summary(Summary display of all Load Data sheets information)4)Grazing and Marketing Data(optional pasture sort & marketing records of each load)
Health Treatment of Sick Pulls:This sheet was designed to input data from your chute side, sick pull treatmentrecords. One individual treated stocker calf is recorded per row (line). The load number(1 thru 10) for each treated stocker must be entered to assess the treatment cost to the load itcame from. The code from the veterinary product code list (column AT, rows 7-107) isentered to display the product used. Each calf can have up to four treatment product codes(with dose) per row on each treatment date. The amount given per head is entered to computethe cost per head. The code and treatment dose must be entered for accurate cost calculations.The total treatment cost for each load is forwarded to the Receiving Cost Summarypage for the appropriate load. There are a maximum of 500 treatment lines for the 10 loads.The treatment cost total and number of head treated per load (counting re-pulls) is totaled atcolumn AF, row 508 on the Health Treatment sheet. When first entering data, producers should re-name the base program under a separatefile name, probably based on a given time-period or common set of loads (5-10 loadsrecommended). If file timetables overlap the sick pull treatment data will have to be enteredseparately in the appropriate files with the loads the sick pulls were from.Veterinary Code List (column AT, rows 7-107 on Health Treatment sheet) To allow producers to record the Health Products they utilize in a simple quick entryin the data sheets, a code system is used to list the health products and prices. This listshould include all products utilized and the purchase price. Once the code list is created,the code number is entered for the appropriate action on the initial processing,revaccination or health treatment sheets. The amount given per head is entered separatelyby product to allow producers to input the dose for each load, processing group or sickpull treatment. As producers record the dose administered, the spreadsheet calculates thetreatment cost. Veterinary codes must be used to report health and processing expensescorrectly. Products in the original code list that are not used in your operation should bereplaced with a product common to your operation. A current code list should be printedand kept computer-side for easy reference.
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '18
- Dr. Moez