NoFeeBoards.com! No Fees! No Ads! No Spam!

Author Message
JWR1945
***** Legend

Joined: 26 Nov 2002
Posts: 1697
Location: Crestview, Florida

 Posted: Wed Jul 21, 2004 7:10 am    Post subject: JanSz Calculator Errata 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.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 9 Hours Page 1 of 1

 Jump to: Select a forum General----------------NFBTown CenterTest Posts Personal finance----------------FIRE BoardIndex Funds BoardSWR Research GroupLBYMGeneral FinanceNewbies Board Community----------------WorkspacePolitically CorrectYour HealthGummy Stuff
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum