Date: prev next · Thread: first prev next last


Der er kommet en række nye regnearksfunktioner som jeg ikke umiddelbart kan
finde oversættelser til.

FORECAST => PROGNOSE

Men de øvrige har jeg ikke fundet noget på. Se f.eks.
http://en.excel-translator.de/functions/statistical/

ETS er forkortelse for "Exponential Triple Smoothing (ETS)" jvnf.
https://support.office.com/en-us/article/Forecasting-functions-reference-897a2fe9-6595-4680-a0b0-93e0308d5f6e

Umiddelbart vil jeg foreslå at vi vælger PROGNOSE.ETS

Men hvad med de øvrige?


Har I andre nogen ideer?



Udpluk fra release notes:
New spreadsheet functions

    RAWSUBTRACT to subtract numbers without canceling out small roundoff
errors. tdf#71459 (Eike Rathke (Red Hat, Inc.))
        =RAWSUBTRACT(a,b,c) is like =a-b-c, but the - minus operator
cancels out small roundoff errors that are due to the fact that not every
decimal number can be exactly represented as a binary floating point number
and effectively the operation snaps to zero. RAWSUBTRACT uses the IEEE754
operation the platform/compiler provides. For example, =0.3-0.2-0.1 results
in 0, whereas =RAWSUBTRACT(0.3,0.2,0.1) results in 2.77555756156289E-17
        This can be used to compare whether a result exactly matches an
expected number, i.e. if =RAWSUBTRACT(result,expected) equals 0.0

    FORECAST.ETS a set of forecasting functions that use triple and double
exponential smoothing and handle seasonal effects. tdf#94635 (Winfried
Donkers)

The Holt-Winters algorithms are used. Both Additional and Multiplicative
methods are supported for triple exponential smoothing. The set consists of
the functions FORECAST.ETS.ADD*, FORECAST.ETS.MULT,
FORCAST.ETS.SEASONALITY*, FORECAST.ETS.PI.ADD*, FORECAST.ETS.PI.MULT,
FORECAST.ETS.STAT.ADD* and FORECAST.ETS.STAT.MULT. The functions marked
with * are interchangeable with MS Excel2016.


/Leif

-- 
Send en e-mail til dansk+unsubscribe@da.libreoffice.org for instruktioner om hvordan du ophæver dit 
abonnement
Problemer? http://da.libreoffice.org/kontakt-os/postlister/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Listens arkiv er tilgængelig på http://listarchives.libreoffice.org/da/dansk/
Alle beskeder du sender til listen bliver publiseret her og kan ikke efterfølgende slettes

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.