Accelerated Pseudorabies Eradication Program (APEP) Download Instructions pages 08-09

Accelerated Pseudorabies Eradication Program (APEP) Download Instructions pages 08-09

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 2009 (Excel files are 22kb each)
WK010509
WK011209
WK011909
WK012609
WK020209
WK020909
WK021609
WK022309
WK030209
WK030909
WK031609
WK032309
WK033009
WK040609
WK041309
WK042009
WK042709
WK050409
WK051109
WK051809
WK052509
WK060109
WK060809
WK061509
WK062209
WK062909
WK070609
WK071309
WK072009
WK072709
WK080309
WK081009
WK081709
WK082409
WK083109
WK090709
WK091409
WK092109
WK092809
WK100509
WK101209
WK101909
WK102609
WK110209
WK110909
WK111609
WK112309
WK113009
WK120709
WK121409
WK122109
WK122809

FY 2008 (Excel files are 22kb each)
WK010708
WK011408
WK012108
WK012808
WK020408
WK021108
WK021808
WK022508
WK030308
WK031008
WK031708
WK033108
WK040708
WK041408
WK042108
WK042808
WK050508
WK051208
WK051908
WK052608
WK060208
WK060908
WK061608
WK062308
WK063008
WK070708
WK071408
WK072108
WK072808
WK080408
WK081108
WK081808
WK082508
WK090108
WK090808
WK091508
WK092208
WK092908
WK100608
WK101308
WK102008
WK102708
WK110308
WK111008
WK111708
WK112408
WK120108
WK120808
WK121508
WK122208
WK122908

Weekly Data Sheets 2006 and 2007

Weekly Data Sheets 2001 through 2005

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)

Complementary Content
${loading}