Accelerated Pseudorabies Eradication Program (APEP) Download Instructions pages 10-11

Accelerated Pseudorabies Eradication Program (APEP) Download Instructions pages 10-11

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 2011 (Excel files are 22kb each)
WK010311
WK011011
WK011711
WK012411
WK013111
WK020711
WK021411
WK022111
WK022811
WK030711
WK031411
WK032111
WK032811
WK040411
WK041111
WK041811
WK042511
WK050211
WK050911
WK051611
WK052311
WK053011
WK060611
WK061311
WK062011
WK062711
WK070411
WK071111
WK071811
WK072511
WK080111
WK080811
WK081511
WK082211
WK090511
WK091211
WK091911
WK092611
WK100311
WK101011
WK101711
WK102411
WK103111
WK110711
WK111411
WK112111
WK112811
WK120511
WK121211
WK121911
WK122611
FY 2010 (Excel files are 22kb each)
WK010410
WK011110
WK011810
WK012510
WK020110
WK020810
WK021510
WK022210
WK030110
WK030810
WK031510
WK032210
WK032910
WK040510
WK041210
WK041910
WK042610
WK050310
WK051010
WK051710
WK052410
WK053110
WK060710
WK061410
WK062110
WK062810
WK070510
WK071210
WK071910
WK072610
WK080210
WK080910
WK081610
WK082310
WK083010
WK090610
WK091310
WK092010
WK092710
WK100410
WK101110
WK101810
WK102510
WK110110
WK110810
WK111510
WK112210
WK112910
WK120610
WK121310
WK122010
WK122710

Weekly Data Sheets 2008 and 2009

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}