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
- [da-dansk] Oversættelse af regenarksfunktioner · Leif Lodahl
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.