Well, its only been out a day and already I’m coming out with bug fixes. This is a minor, but important one though. You can either download the latest version of the spreadsheet HERE< or you can make the adjustement within your current spreadsheet. The problem lies within the M-Column (AKA: Risk Unit)

To make the correction yourself you will have to unprotect the sheet. Then go to cell M9 and in the formula you will find two instances where it says:

(B9*2*$A$5)/200

The 200 needs to be replaced with $B$5 in each of these cases so that the the total formula will read:

=IF(J9=0,”",IF(K9>0,ABS(J9-H9)/ABS(H9-D9)-(B9*2*$A$5)/$B$5,IF(K9<0,-ABS(J9-H9)/ABS(H9-D9)-(B9*2*$A$5)/$B$5,”")))

Once you have this cell fixed, simply go to the lower right-hand corner of the cell until a + appears and drag the formula down to all the other cells and save the spreadsheet.

It might be a good idea to protect the sheet again if you are doing this manually so that no mistaken cell changes are made.

Sorry for any confusion,

Jason