Indemnity Calculation Data
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.
|FY 2012 (Excel files are 22kb each)|
The indemnity calculator spreadsheet may be downloaded by following the instructions below.
DOWNLOAD CALCULATOR (xls 90kb)