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+unsubscr...@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
