Skip to main content
Skip to main content

SHAP — v5n3p95 Template download

   

Template download

May and June, 1997

Using partial budgets to analyze selected management practices associated with reduced preweaning mortality

David M. Lane, DVM; C. Matthew Rendleman, PhD; Stephen L. Ott, PhD

This template was originally created in Microsoft Excel version 5.0 for the Macintosh.

I used the SUMPRODUCT function which apparantly isn’t available on some other spreadsheet packages, such as Quattro Pro. This function in this template multiplies each dollar value by the hidden multiplier (i.e., the number of litters or by 1 for the whole year) and then sums the products.

Additionally, it seems that some spreadsheets may complain about summing a range that includes empty cells. I’m less certain of how to get around this and still have a useful number of blank rows into which to put data.

I can, if anyone wants, create a simplified version that might be more transportable to other systems. Though this won’t be as high up on our list as getting out the next issue, please let me know what your needs are and we can try to help. Send email to webmaster@aasp.org.

But for now, here’s what you can download…

Hope this will be of some use,

Dave Brown
Publications Editor, Swine Health and Production