[SI-LIST] Recursive calculations in spreadsheets

 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:
http://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:     
                http://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: