Spreadsheets, once prepared, can be used to make very complicated calculations very easily and quickly. Following are some prepared spreadsheets available for free download, that hopefully, can be used to make a number of calculations for the farm, ranch and home. This directory of spreadsheets was made available to participants of a series of "Ag Computer Workshops" in the South 4 Field Education Unit. These workshops will be offered upon request. For more information, contact one of the Extension offices in the South 4 Field Education Unit.
Directory of Spreadsheets – revised 3/7/2007
To download spreadsheets, "right-click" the link, then click "save target
as", and specify where you would like to download the file to.
Note: spreadsheets in red text can be
downloaded at:
http://econ.sdstate.edu/Extension/Tools/budgets.htm.
You can
also request any of these spreadsheets from the Lyman, Gregory or Tripp
County Extension office. We can also make them available to you in other
spreadsheet formats upon request. We have been offering "Ag Computer Workshops"
in the South 4 Field Education Unit in the past and will do so again based on
interest. The main topic we cover
in these workshops is the use of spreadsheets in agriculture. For more
information on these workshops, or to sign up for them when they are offered
again, contact the Lyman, Gregory or Tripp County Extension office.
| Livestock | MS Excel |
| Beef Cattle | |
| Beef Cow Unit, Feeder Calf sold, October | B1CC |
| Beef Cow Unit, Creep Fed Calf sold, October | B2CC |
| Beef Cow Unit, Feeder Calf sold 90 Days after Weaning | B3CC |
| Beef Cow Unit, Large Framed Feeders Sold, October | B4CC |
| Raising Beef Replacement Heifers, Calve as 2 year olds | B5HFR |
| Wintering Steer Calves | B6STR |
| Wintering Heifer Calves | B7HFR |
| Backgrounding Steer Calves | B8STR |
| Backgrounding Heifer Calves | B9HFR |
| Full Fed Steer Calf, High Energy | B10STR |
| Full Fed Heifer Calf | B11HFR |
| Finishing Yearling Steer (Grass Cattle) | B12STR |
| Feed Out Yearling Heifers, High Energy | B13HFR |
| Finishing Heavy Steers (Medium Frame) | B14STR |
| Finishing Yearling Heifers (Medium Frame) | B15HFR |
| Summer Grazing Stocker Steers, 5.5 mos, Apr-Sept, gain 250lbs | B-stocker |
| Performs simple beef production testing calculations for a calf crop | Beef_prod_test |
| Keep records on calving information | Beef_Herd_Records |
| Calculate ration for beef cows (requires nutrient requirements) | Beef-cow-ration |
| Calculate ration for growing cattle (requires nutrient requirements) | Beef-grow-ration |
| Breakeven analysis for feeder calves | Befdr |
| Performs calculations for the spa-ez analysis | Spa-ez |
| Dairy | |
| Dairy Cow, 12,000 - 20,000 Pounds Fluid Milk Sold per Cow | DAIRY |
| Sheep | |
| Ewes and Market Lambs | SH16MKT |
| Ewes and Feeder Lambs | SH17FDR |
| Finishing Feeder Lambs | SH18FIN |
| SWINE | |
| Sow & Litter, Farrow to Finish | HOG19MKT |
| Sow & Litter, Feeder Pigs | HOG20FDR |
| Finishing Purchased Feeder Pigs | FEEDRPIG |
| Crop Production | |
| Conducts enterprise analysis on a field basis | Crop_Enterprise_Analysis |
| Evaluates feasibility of applying a foliar fungicide | Fungicid |
| Estimates the value of drought stricken corn in the field for silage (instructions in drousil.rtf) | Drousil, instructions |
| Crop budgets for SC SD w/ macros removed | SCcrop |
| Calculates value of silage standing in field | Silage$ |
| Estimate wheat yield based on kernels/hd & hds/ft of row | Yieldest |
| Estimates corn yield based on ears/ft row, kernels/row, rows/ear | Corn_Yield_Estimate |
| Corrects various grains to industry standard | Grain_Mois_Correction |
| Table for correcting corn at various moistures to 15.5% | Cornmois |
| Contains formulas for drying grain | Graindry |
| Calculates the standard deviation of plant spacing on a planted field | std_dev_row_crop_planter |
| Marketing | |
| Evaluate results of various crop insurance and forward pricing strategies | MBM_Risk_Calculator |
| download from SDSU Extension Economics Website | Risk Calculator - Description |
| Risk Calculator - Excel version | |
| Evaluate various forward pricing strategies | Marketev |
| Calculates grain storage costs | Storage |
| Evaluates potential returns to storage | Storagecalc |
| Miscellaneous | |
| Farm income & expense record with summary page | Farm-income-expense-summ-3-2007 |
| Farm personal income & expense record with summary page | Farm-personal-income-expense-3-2007 |
| Estimate bushels of grain in a pile | Grainpil |
| Calculates investments and loans | Saveloan |
| Allows various calculations of interest to farmers | Farmmath |
| Set up similar to popular farm account books | Farmaccount |
| Evaluates various sources of feed | Feedeval |
| Calculates landowner vs tenant share arrangement based on value of inputs | Sharecrp |
| Calculates landowner vs tenant share arrangement based on value of inputs | Sharelvsk |