Sean Breheny wrote:

> On Wed, Aug 17, 2011 at 11:06 AM, Carl Denk <cdenk@windstream.net>
> wrote:
>> For the say dozen or so simple formulas, enter the formulas into an
>> Excel (or Open office calc). Save the spreadsheet =A0 =A0:)
>=20
> I second the Excel recommendation for simple, fixed formulas.

One big advantage with spreadsheets is the following. Instead of single,
big formulas create meaningful sub-results on the way. Do this per
column (or per row, depending on taste). Then fill in different data
sets (make sure you use a different format, like cell color, for data
that is supposed to be entered) in different rows (or columns, depending
on taste). This may help you see relationships in the data that you
weren't aware of before. This is something unique to this technique of
using spreadsheets, and while other tools can provide something similar,
you usually have to go to greater lengths to actually see the data in
this way.

Also, keep constants in separate cells and refer to them with absolute
references or names. This allows you both to copy your formulas and they
still work, and to change the constants if needed. (It also documents
them better than just "hardcoded" into the formulas.)

Gerhard

--=20
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.