[SI-LIST] Re: Recursive calculations in spreadsheets
- From: "Brent DeWitt" <bdewitt@xxxxxxxxxxxxx>
- To: <reanderson@xxxxxxxxxxxxx>, <si-list@xxxxxxxxxxxxx>
- Date: Wed, 29 Sep 2004 19:48:16 -0700
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:
> //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
>
>
------------------------------------------------------------------
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:
