Web Content Viewer (JSR 286)

Accelerated Pseudorabies Eradication Program (APEP)

Pseudorabies Program Standards

Indemnity Calculation Data

Download Instructions

The Indemnity Calculator spreadsheet uses a second spreadsheet, "Weekly Data Sheet", to supply the market data that is required in the calculations. This spreadsheet (WKmmddyy.XLS), is prepared at the end of every week for use in the next week's calculations and posted on this website. Prior to performing any indemnity calculations it is necessary to ensure that you are using the current Weekly Data Sheet. This can be done by observing the date in the upper right corner of the calculator spreadsheet.

At the beginning of every week the current Weekly Data Sheet should be downloaded from this web site and located in the same directory in which the calculator spreadsheet is located. To perform this download follow the instructions below.

  1. RIGHT CLICK on the link in the list below for the desired Weekly Data Sheet.
  2. From the menu select "Save Link as" or "Save Target as". The wording may vary depending upon your web browser.
  3. In the navigator box, ensure that the directory is the same as that in which the calculator spreadsheet is located.
  4. Save the file.
FY 2012 (Excel files are 22kb each)
WK010212
WK010912
WK011612
WK012312
WK013012
WK020612
WK021312
WK022012
WK022712
WK030512
WK031212
WK031912
WK032612
WK040212
WK049012
WK041612
WK042312
WK043012
WK050712
WK051412
WK052112
WK052812
WK060412
WK061112
WK061812
WK062512
WK070212
WK070912
WK071612
WK072312
WK073012
WK081312
WK082012
WK082712
WK090312

Weekly Data Sheets 2010 and 2011

Weekly Data Sheets 2008 and 2009

Weekly Data Sheets 2006 and 2007

The indemnity calculator spreadsheet may be downloaded by following the instructions below.

  1. RIGHT CLICK on the link below "DOWNLOAD CALCULATOR"
  2. From the menu select "Save Link as" or "Save Target as". The wording may vary depending upon your web browser.
  3. In the navigator box, navigate to the desired directory.
  4. Save the file.

DOWNLOAD CALCULATOR (xls 90kb)



Additional Information