JanSz Calculator Errata

Research on Safe Withdrawal Rates

Moderator: hocus2004

Post Reply
JWR1945
***** Legend
Posts: 1697
Joined: Tue Nov 26, 2002 3:59 am
Location: Crestview, Florida

JanSz Calculator Errata

Post by JWR1945 » Wed Jul 21, 2004 7:10 am

I have identified two errors that apply to the JanSz algorithms in my calculators. The errors and corrections apply to all of my calculators that have JanSz in their titles.

To reach a cell rapidly, press function key F5, type in the cell location and then click OK (or press Enter). To return to the beginning of a spreadsheet, press CTRL+Home (that is, press CTRL and hold it down and then press Home).

To use the fill handle, position you mouse cursor over the lower right hand corner of a cell. When the fat plus sign changes to narrow cross hairs, click the mouse button and hold it down. The affected cells will show up in reverse colors (e.g., white on black instead of black on white). While still holding down the mouse button, drag the cursor in the desired direction (in this case, to the right) until you reach you desired destination. Lift the mouse button and then click on any cell. It can be the cell at which you had stopped. You may do this in several stages.

Highlight the cell and look at the formula just above the spreadsheet (in the Formula Bar). Make the corrections in the Formula Bar and then click on the check mark. You may copy the formulas from this document and paste them directly into the Formula Bar or you may choose to edit the formula directly. Finally, drag the formula to the right all of the way to the last column in the row.

Here are the specific changes.

Cell P327 [in year 1878], correct to:
=IF(P325<=0,0,-$B$15*P325)*$B$10+IF(P325<=J325,0,-$B$17*(P325-J325)*$B$10)
Use the fill handle to drag the formula all of the way to the right.
Previously, the right half had P235 and J235 instead of P325 and J325.

Cell AQ813 [in year 1905], correct to:
=IF(AQ811<=0,0,-$B$15*AQ811)*$B$10+IF(AQ811<=AK811,0,-$B$17*(AQ811-AK811)*(1-$B$10))
Use the fill handle to drag the formula all of the way to the right.
Previously, the right half referred to row 806 instead of 811.

Finally, Save the changes.

Have fun.

John R.

Post Reply