Niklas Nebel wrote:
I noticed that Calc calculates the SUM in the same order as that of
the data cells. However I was reading somewhere (though do not
remember anymore where) that it is best to calculate the sum by:
1. ordering the numbers from smallest to largest (as absolute
numbers, i.e. without sign)
2. adding them up starting with the smallest (smallest absolute
number, i.e. 2 and not -90000 in this two number example)
If someone tried such a change, and measured the accuracy versus the
performance hit, we could decide if we want to change it.
This is a tricky question: *accuracy* vs *performance*
For academic users, accuracy might be much more important than
performance, but for someone keeping track of various sales, accuracy
has probably a lesser relevance.
Indeed, some of the problem arises that most of the benefit (in terms of
accuracy) would come on huge data sets, but here we would note also the
greatest performance hit. Difficult question.
Yet, the sum is used almost in every formula. So it is worth thinking
more deeply.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
