[SI-LIST] Recursive calculations in spreadsheets
- From: Ray Anderson <reanderson@xxxxxxxxxxxxx>
- To: si-list@xxxxxxxxxxxxx
- Date: Wed, 29 Sep 2004 10:08:08 -0700
In a recent (and possibly ongoing ) thread, I and at least a couple
others mentioned the use of Excel spreadsheets to recursively calculate
field solutions, DC drops and other such parameters.
I just wanted to mention something related to these recursive
calculations that might not be obvious until you try to implement them
in a spreadsheet. Specifically, A lot of spreadsheets that run just fine
in Excel may fail miserably when implemented in Sun's StarOffice (and
presumably OpenOffice) spreadsheets. In most instances StarOffice
functions very nearly exactly like Excel. The gotcha' is that circularly
referenced recursive calculations fail after just a few iterations in
StarOffice as they have implemented a very shallow stack structure as
opposed to Excel which allows recursion depth limited only by the memory
size available.
-Ray
------------------------------------------------------------------
To unsubscribe from si-list:
si-list-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
or to administer your membership from a web page, go to:
//www.freelists.org/webpage/si-list
For help:
si-list-request@xxxxxxxxxxxxx with 'help' in the Subject field
List FAQ wiki page is located at:
http://si-list.org/wiki/wiki.pl?Si-List_FAQ
List technical documents are available at:
http://www.si-list.org
List archives are viewable at:
//www.freelists.org/archives/si-list
or at our remote archives:
http://groups.yahoo.com/group/si-list/messages
Old (prior to June 6, 2001) list archives are viewable at:
http://www.qsl.net/wb6tpu
Other related posts:
