[SI-LIST] Re: Recursive calculations in spreadsheets

Ray, all:

To reinforce your information, I have verified Ray's compatibility issue
with OpenOffice under both Windows XP and Linux.

Brent DeWitt

> -----Original Message-----
> From: si-list-bounce@xxxxxxxxxxxxx
> [mailto:si-list-bounce@xxxxxxxxxxxxx]On Behalf Of Ray Anderson
> Sent: Wednesday, September 29, 2004 10:08 AM
> To: si-list@xxxxxxxxxxxxx
> Subject: [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
>
>

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