Re: Large test spreadsheets

Hello everyone,

you can find a nasty spreadsheet at:

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:

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



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

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:
cells can, in principle, be computed by different threads as they by and
large are independent.  Actually implementing this will not be easy.

gnumeric-list mailing list
gnumeric-list gnome org

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN:

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]