Original-Nachricht
> Datum: Sun, 03 Oct 2010 21:08:00 +0200
> Von: "Leonard Mada"
> An: Jean Brefort , gnumeric-list@gnome.org
> Betreff: Re: fft question
> Dear Jean,
>
> FFT generates symmetric spectra - basically symmetric mirror images.
>
Dear Jean,
FFT generates symmetric spectra - basically symmetric mirror images.
[The frequencies are mirrored against the central 0.]
This seems to be the case in the "real" image.
While the "complex" image seems to include only one half,
which is the usual way to represent the NMR spectrum.
[an
unately, spreadhseets are also dying out - being replaced
either by Cognos or by Custom solutions.
I have witnessed this trend since 2007 in various industries, and
both governments and industries. The only ones who can't afford such
a solution are simple users, but those who can afford, usually
Regarding chemical functions:
[...]
> As you seem to be a chemist, I'd like to know if you would like
> chemistry related functions in gnumeric and which. Currently, I added a
> gnumeric plugin to the GNOME Chemistry Utils
> (http://gchemutils.nongnu.org) (development version only) with just one
>
Dear Ken,
I came across a similar problem a few month ago.
I always thought that the chances of hitting a rows limit are minimal,
but then one day I got an error by Excel 2007 when I tried to
import a csv-file.
The csv file had slightly more than 2 million rows.
Of course, the remaining spreads
Dear all,
Andreas J. Guelzow wrote:
On Tue, 2008-11-18 at 14:07 -0800, John Leonard wrote:
I am inclined to agree with you on this issue. The problem as I see it
is that the open source community consists of a lot of fantastically
clever programmers, but few designers and even fewer techni
Hello Morten, hello everyone,
Morten Welinder wrote:
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/archive
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 var
Hello everyone,
Hal Ashburner wrote:
> Peap wrote:
>
>> [...]
>> When I sort A22-A401, the vast majority of the cells display "#REF!".
>> Within the cells, a seemingly random selection of first and second cell refs
>> became "#REF!".
>>
>> [...]
>>
> you probably want to do something li
Hi,
it is probably a general spreadsheet issue as witnessed by the similar
OpenOffice.org behaviour and bug-report:
http://www.openoffice.org/issues/show_bug.cgi?id=59453
Sincerely,
Leonard
Uri David Akavia wrote:
> Hi.
>
> When pasting into an entire sheet (which just happened to me, when
>
Hi Brandon,
you have very nicely summed up the features that a modern spreadsheet should
offer.
I touched myself some of these features in a similar post on the OpenOffice.org
website, see:
http://www.openoffice.org/issues/show_bug.cgi?id=80139
(especially the Track Changes paragraph) and
http
a more advanced object-model (described in this post), including
strong vectorization support
Some issues are overlapping (and beyond this TOP 5, I have some other
ideas, too; maybe later).
Sincerely,
Leonard Mada
> It would be nice to insert components (as
> supported in goffice) as a sh
Andreas J. Guelzow wrote:
>> NO, there is NO such unary operator: -x^2 = -x * -x = + x^2, THIS is
>> NONSENSE. Such a unary operator does NOT exist.
>>
>
> What is the - in -x if not a unary operator?
>
Well, the true unary operator has the fantastic property that -x^2 !=
+x^2, while th
x^2, because it would evaluate to +x^2 anyway. But it
would be utter nonsense.
Kind regards,
Leonard Mada
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
T calculated what they
expected. (it is transparent what has happened)
Stating however, that -4^2 = +16 is plain wrong!!! And inventing various
mathematical rules that break the old ones is really NOT good for a
standard.
I hope this gets corrected.
Kind regards,
Leonard Mada
=> TRUE
R returns an ERROR, too: (-27)^(1/3) returns "NaN".
Seems, a lot of software gets it wrong, though Excel manages to calculate it.
I hope therefore, that this gets corrected in gnumeric, too. Should I post it
as a BUG?
Kind
odify the input array. So there are many situations
where they are preferable over a sorting algorithm. Even if the data set
is of moderate size, if you compute 100 medians in your sheet and have
to correct an element (therefore triggering a formula update), a quick
algorithm makes a difference.
Ki
eans much less]
For really big numbers, even my previous formula was correct, with n/4 instead
of n/2.
Andreas J. Guelzow wrote:
> On Sat, 2007-10-02 at 19:49 +0200, Leonard Mada wrote:
>
>
>
>> - move array (with worst algorithm): log[(n/2)!] << log[(n/4)^(n/4)] =
it will be less than n * log(n),
and because log[(n/2-1)!] << log[(n/4)^(n/4)], there will indeed be a
significant difference. I presume, that more realistically, this
algorithm will be 2 times faster than the corresponding sort and uses
only half the memory.
Sin
Excel did take the easy ride, I do
NOT believe that a standard should follow the same way.
Sincerely Yours,
Leonard Mada
Andreas J. Guelzow wrote:
> On Sat, 2007-10-02 at 02:41 +0200, Leonard Mada wrote:
>
>> John Machin wrote:
>>
>>> ...
>>> So who car
Uri David Akavia wrote:
> Admittedly, my complexity course is behind me, but there seem to be a
> few things wrong with your calculations of the efficiency.
> ...
> First, if you're using 2*n elements, shouldn't your results be nlog(n)
> instead of n/2*log(n)?
I used n elements for this calculatio
John Machin wrote:
> ...
> So who cares? The median value is 1. Is your alternative going to
> return some value other than 1
Please define mathematically the middle value! It is NOT trivial as my
definitions showed. Anything else would be ambiguous. This should be a
standard, so make a b
the median does take just 2 of the 3 values of 2, which is a little bit
ambiguous. Which one is the middle value? Are 2 two's more middle than
the 3rd two?
Just my thoughts.
Leonard
Andreas J. Guelzow wrote:
> On Sat, 2007-10-02 at 00:38 +0200, Leonard Mada wrote:
>
>
>>
ther elements 1 have been excluded); b.)
element 3;
1,1,1,1 => 1 and 1 bisect list => median is 1; 2 equal lists, each
consisting of one element 1 (the other 2 elements of 1 have been
excluded per definition);
Although this definition is somehow more complex, I believe it is more
accurate an
to pipeline
data from/to gnumeric, like gawk does. And this should be not limited to
gawk. There are other programs that can be very useful for various users.
Kind regards,
Leonard Mada
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Uri David Akavia wrote:
> In order to keep security ...
I do NOT see, why security is an issue here.
This is NOT the way Excel executes macros. Indeed, such script would NOT
be run automatically when loading a spreadsheet, BUT only when the user
specifically clicks on a specific Menu Command.
believe this is easy to code and quite useful.
Many thanks in advance,
Leonard Mada
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Oliver Burnett-Hall wrote:
> You can use the if() and iserror() functions to cope with cases where
> the search string isn't found. This can make the formulas long,
> repetitive and unwieldy, but it does work.
>
This is just one of the problems (and indeed one very ugly).
The real problem is,
Hello!
Gnumeric, as well as other spreadsheet applications (like OOo Calc) have
unfortunately a very limited support for string operations. One issue
where gnumeric continues to copy the bad quirks of MS Office is the
string search/find function.
When the string is NOT found, instead of report
Hi Morten,
indeed, calculating the sum is not an easy task on some data sets. :-)
Morten Welinder wrote:
> Sorting works great if and if only all the numbers have the same sign.
> If not, I do not currently know what is best. In fact, all the simple
> algorithms we have thought up have been imme
y
influence more significant digits. When you add larger numbers first,
there is a higher chance to drop/round less significant digits.
Kind regards,
Leonard Mada
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
oo.
(http://sc.openoffice.org/servlets/BrowseList?listName=dev&by=date&from=2006-11-01&to=2006-11-30&first=1&count=6)
The National Institute of Standards has some Test Cases, too. See my
post in November for further details.
Kind regards,
Leonard
32 matches
Mail list logo
