Re: Large test spreadsheets

["Leonard Mada" <discoleo gmx net>]

Hello everyone,

you can find a nasty spreadsheet at:
http://www.openoffice.org/issues/show_bug.cgi?id=89976

In general, optimizing a spreadsheet for parallel processing is not that easy, because
you will likely end waiting most of the time for other cells to compute first and/or
recomputing various cels multiple times instead of once.

In an effort to move away from puting the burden on the developers, I began
designing functions that would compute intrinsically faster by expanding
existing functions to array functions:
 - PERCENTILE():
   http://lists.oasis-open.org/archives/office-comment/200806/msg00011.html

 - LOOKUP() and OFFSET()-functions will follow when I have some more time

Though, there is still a long way to improve existing spreadsheets. The ultimate
goal is to make the spreadsheet more vector-like: a good solution is the
multidimensional spreadsheet model.

Sincerely,

Leonard


-------- Original-Nachricht --------
> Datum: Tue, 10 Jun 2008 11:35:54 -0400
> Von: "Morten Welinder" <mwelinder gmail com>
> An: "bla blabla" <chico lorotta gmail com>
> CC: gnumeric-list gnome org
> Betreff: Re: Large test spreadsheets

> On Sun, Jun 8, 2008 at 8:33 PM, bla blabla <chico lorotta gmail com>
> wrote:
> > Hello,
> >
> > do you guys know where i can get large spreadsheets (that take a very
> > long time to process) so i can use it for profiling? My idea is to
> > identify parts of the code that can be changed to exploit paralellism
> > (i'm using OpenMP).
> 
> The traditional way of getting such sheets is to take some formulas and
> replicate then hundreds or thousands of times.  That is not particularly
> useful to you as it will tell you that when replicated enough times, the
> functions you use take up a lot of time.
> 
> Parallelism in a spreadsheet falls naturally at the level of cells:
> different
> cells can, in principle, be computed by different threads as they by and
> large are independent.  Actually implementing this will not be easy.
> 
> Morten
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer