NoFeeBoards.com!

No Fees! No Ads! No Spam!

Log in Register FAQ Memberlist Search NoFeeBoards.com! Forum Index

JanSz Calculator Errata

 
Post new topic   Reply to topic    NoFeeBoards.com! Forum Index » SWR Research Group
View previous topic :: View next topic  
Author Message
JWR1945
***** Legend


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

PostPosted: Wed Jul 21, 2004 7:10 am    Post subject: JanSz Calculator Errata Reply with quote

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.


Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    NoFeeBoards.com! Forum Index » SWR Research Group All times are GMT - 9 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001- 2004 phpBB Group
Designed for Trushkin.net | Styles Database