tdf94635 (FORECAST functions) and triple exponential smoothing

Eike Rathke erack at
Thu Oct 8 10:27:08 PDT 2015

Hi Winfried,

On Thursday, 2015-10-08 07:44:07 +0200, Winfried Donkers wrote:

> I'm currently implementing the new FORECAST functions that are added to Excel 2016.

Great! :)

> Mostly they use triple exponential smoothing.
> To avoid double work, am I correct that the current LO codebase does not contain code that uses triple exponential smoothing?

I'm quite sure we don't have such. Not even double I guess ;-)
The only place I ran across exponential smoothing was

> I would also like to create a new source file, sc/source/core/tool/interpr8.cxx, as probably a lot of code lines will be added, all specifically for FORECAST.ETS functions. Any objections to that?

No, please go ahead. Would be good to have every new code related in one
place and in a separate file.

Btw, do you have access to Excel 2016 to compare results?


LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why:
Care about Free Software, support the FSFE
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <>

More information about the LibreOffice mailing list