summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <ohallot@collabora.co.uk>2016-03-08 11:28:49 -0300
committerCaolán McNamara <caolanm@redhat.com>2016-03-09 17:10:00 +0000
commit9dc3878117e8d2c4e6e6cf09b41fb2e06867a477 (patch)
tree4bd9a6f34b85dae4743037658708bae0508ffa3f
parent35c3a7c5774b09f974ebd34919c13b3aaa51bd4a (diff)
tdf#97021 Help pages for FORECAST.ETS functions
Write help page for FORECAST.ETS.* Calc functions Change-Id: I4fc3a0f18bb09e033b011206c41bec841e0d01f5 Reviewed-on: https://gerrit.libreoffice.org/23093 Reviewed-by: Caolán McNamara <caolanm@redhat.com> Tested-by: Caolán McNamara <caolanm@redhat.com>
-rw-r--r--AllLangHelp_scalc.mk8
-rw-r--r--source/text/scalc/01/04060185.xhp22
-rw-r--r--source/text/scalc/01/exponsmooth_embd.xhp386
-rw-r--r--source/text/scalc/01/func_forecastetsadd.xhp62
-rw-r--r--source/text/scalc/01/func_forecastetsmult.xhp63
-rw-r--r--source/text/scalc/01/func_forecastetspiadd.xhp66
-rw-r--r--source/text/scalc/01/func_forecastetspimult.xhp66
-rw-r--r--source/text/scalc/01/func_forecastetsseason.xhp58
-rw-r--r--source/text/scalc/01/func_forecastetsstatadd.xhp64
-rw-r--r--source/text/scalc/01/func_forecastetsstatmult.xhp63
10 files changed, 858 insertions, 0 deletions
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 9b480ea4f0..4574dfc618 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -198,6 +198,14 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_edate \
helpcontent2/source/text/scalc/01/func_eomonth \
helpcontent2/source/text/scalc/01/func_error_type \
+ helpcontent2/source/text/scalc/01/func_forecastetsadd \
+ helpcontent2/source/text/scalc/01/func_forecastetsmult \
+ helpcontent2/source/text/scalc/01/func_forecastetsstatadd \
+ helpcontent2/source/text/scalc/01/func_forecastetsstatmult \
+ helpcontent2/source/text/scalc/01/func_forecastetspiadd \
+ helpcontent2/source/text/scalc/01/func_forecastetspimult \
+ helpcontent2/source/text/scalc/01/func_forecastetsseason \
+ helpcontent2/source/text/scalc/01/exponsmooth_embd \
helpcontent2/source/text/scalc/01/func_hour \
helpcontent2/source/text/scalc/01/func_imcot \
helpcontent2/source/text/scalc/01/func_imcos \
diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 7926cbf2a6..bb83598d14 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -133,6 +133,28 @@
<paragraph xml-lang="en-US" id="par_id3157874" role="paragraph" l10n="U" oldref="28">
<item type="input">=FORECAST(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph>
</section>
+ <section id="forecastlinear">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149052"><bookmark_value>regression lines;FORECAST.LINEAR function</bookmark_value>
+ <bookmark_value>extrapolations</bookmark_value>
+ <bookmark_value>FORECAST.LINEAR function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_LIN" id="bm_id3146102" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id3149052" role="heading" level="2">FORECAST.LINEAR</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153291" role="paragraph" l10n="U" oldref="21"><ahelp hid="HID_FUNC_SCHAETZER">Extrapolates future values based on existing x and y values.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3151344" role="heading" level="3" l10n="U"
+ oldref="22">Syntax</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147405" role="code" l10n="U" oldref="23">FORECAST(Value; DataY; DataX)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3148744" role="paragraph" l10n="U" oldref="24">
+ <emph>Value</emph> is the x value, for which the y value on the linear regression is to be returned.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146326" role="paragraph" l10n="U" oldref="25">
+ <emph>DataY</emph> is the array or range of known y's.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150537" role="paragraph" l10n="U" oldref="26">
+ <emph>DataX</emph> is the array or range of known x's.</paragraph>
+ <paragraph xml-lang="en-US" id="hd_id3147417" role="heading" level="3" l10n="U"
+ oldref="27">Example</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3157875" role="paragraph" l10n="U" oldref="28">
+ <item type="input">=FORECAST.LINEAR(50;A1:A50;B1;B50)</item> returns the Y value expected for the X value of 50 if the X and Y values in both references are linked by a linear trend.</paragraph>
+ </section>
<section id="stdev">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149143"><bookmark_value>STDEV function</bookmark_value>
<bookmark_value>standard deviations in statistics;based on a sample</bookmark_value>
diff --git a/source/text/scalc/01/exponsmooth_embd.xhp b/source/text/scalc/01/exponsmooth_embd.xhp
new file mode 100644
index 0000000000..ecb83899e5
--- /dev/null
+++ b/source/text/scalc/01/exponsmooth_embd.xhp
@@ -0,0 +1,386 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+-->
+
+<meta>
+ <topic id="ID" indexer="Indexer">
+ <title id="tit" xml-lang="en-US">embeded text for exponential smoothing</title>
+ <filename>/text/scalc/01/exponsmooth_embd.xhp</filename>
+ </topic>
+</meta>
+<body>
+<section id="intro">
+ <paragraph id="par_id0403201618694534" role="paragraph" xml-lang="en-US">Exponential Smoothing is a method to smooth real values in time series in order to forecast probable future values.</paragraph>
+
+<paragraph id="par_id0403201618694535" role="paragraph" xml-lang="en-US">Exponential Triple Smoothing (ETS) is a set of algorithms in which both trend and periodical (seasonal) influences are processed. Exponential Double Smoothing (EDS) is an algorithm like ETS, but without the periodical influences. EDS produces linear forecasts.</paragraph>
+
+<paragraph id="par_id0403201618694537" role="tip" xml-lang="en-US">See the <link href="http://en.wikipedia.org/wiki/Exponential_smoothing">Wikipedia on Exponential smoothing algorithms</link> for more information.</paragraph>
+ </section>
+
+<section id="target">
+<paragraph id="par_id0403201618594534" role="paragraph" xml-lang="en-US"><emph>target (mandatory):</emph> A date, time or numeric single value or range. The data point/range for which to calculate a forecast.</paragraph>
+</section>
+
+<section id="values">
+<paragraph id="par_id040320161859459" role="paragraph" xml-lang="en-US"><emph>values (mandatory):</emph> A numeric array or range. <emph>values</emph> are the historical values, for which you want to forecast the next points.</paragraph>
+</section>
+
+<section id="timeline">
+<paragraph id="par_id0403201618594553" role="paragraph" xml-lang="en-US"><emph>timeline (mandatory):</emph> A numeric array or range. The time line (x-value) range for the historical values. </paragraph>
+<paragraph id="par_id040320161859450" role="note" xml-lang="en-US">The time line doesn't have to to be sorted, the functions will sort it for calculations. <br/>The time line values must have a consistent step between them. <br/>If a constant step can't be identified in the sorted time line, the functions will return the #NUM! error. <br/>If the ranges of the time line and historical values aren't of same size, the functions will return the #N/A error.<br/>If the time line contains less than 2 periods of data, the functions will return the #VALUE! Error.</paragraph>
+</section>
+
+<section id="datacompletion">
+<paragraph id="par_id0403201618594513" role="paragraph" xml-lang="en-US"><emph>data_completion (optional):</emph> a logical value TRUE or FALSE, a numeric 1 or 0, default is 1 (TRUE). A value of 0 (FALSE) will add missing data points with zero as historical value. A value of 1 (TRUE) will add missing data points by interpolating between the neighboring data points.</paragraph>
+<paragraph id="par_id0403201618594678" role="note" xml-lang="en-US">Although the time line requires a constant step between data points, the function support up to 30% missing data points, and will add these data points. </paragraph>
+</section>
+
+<section id="aggregation">
+<paragraph id="par_id0403201618594650" role="paragraph" xml-lang="en-US"><emph>aggregation (optional):</emph> A numeric value from 1 to 7, with default 1. The aggregation parameter is a numeric value indicating which method will be used:</paragraph>
+
+<table id="Tabela1">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618594696" role="tablehead" xml-lang="en-US">Aggregation</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id040320161859464" role="tablehead" xml-lang="en-US">Function</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618564423" role="tablecontent" localize="false" xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594636" role="tablecontent" xml-lang="en-US">AVERAGE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618565433" role="tablecontent" localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594692" role="tablecontent" xml-lang="en-US">COUNT</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618565982" role="tablecontent" localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594633" role="tablecontent" xml-lang="en-US">COUNTA</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618570026" role="tablecontent" localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id040320161859460" role="tablecontent" xml-lang="en-US">MAX</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618570154" role="tablecontent" localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594658" role="tablecontent" xml-lang="en-US">MEDIAN</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618570236" role="tablecontent" localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594671" role="tablecontent" xml-lang="en-US">MIN</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0403201618570394" role="tablecontent" localize="false" xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0403201618594639" role="tablecontent" xml-lang="en-US">SUM</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+<paragraph id="par_id0403201618595033" role="note" xml-lang="en-US">Although the time line requires a constant step between data points, the functions will aggregate multiple points which have the same time stamp. </paragraph>
+</section>
+
+<section id="statistics">
+<paragraph id="par_id0503201619582693" role="paragraph" xml-lang="en-US"><emph>stat_type (mandatory)</emph>: A numerical value from 1 to 9. A value indicating which statistic will be returned for the given values and x-range.</paragraph>
+<paragraph id="par_id0503201619582620" role="paragraph" xml-lang="en-US">The following statistics can be returned:</paragraph>
+
+<table id="tbl_0503201619535874">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582666" role="tablehead" xml-lang="en-US">stat_type</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id050320161958264" role="tablehead" xml-lang="en-US">Statistics</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582639" role="tablecontent" localize="false" xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582658" role="tablecontent" xml-lang="en-US">Alpha smoothing parameter of ETS algorithm (base)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582687" role="tablecontent" localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582673" role="tablecontent" xml-lang="en-US">Gamma smoothing parameter of ETS algorithm (trend)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619583658" role="tablecontent" localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582780" role="tablecontent" xml-lang="en-US">Beta smoothing parameter of ETS algorithm (periodic deviation)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582737" role="tablecontent" localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582795" role="tablecontent" xml-lang="en-US">Mean absolute scaled error (MASE) - a measure of the accuracy of forecasts.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582782" role="tablecontent" localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582749" role="tablecontent" xml-lang="en-US">Symmetric mean absolute percentage error (SMAPE) - an accuracy measure based on percentage errors.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582739" role="tablecontent" localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582725" role="tablecontent" xml-lang="en-US">Mean absolute error (MAE)- a measure of the accuracy of forecasts.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582788" role="tablecontent" localize="false" xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582750" role="tablecontent" xml-lang="en-US">Root mean squared error (RMSE) - a measure of the differences between predicted and observed values.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582741" role="tablecontent" localize="false" xml-lang="en-US">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582771" role="tablecontent" xml-lang="en-US">Step size detected time line (x-range). When a stepsize in months/quarters/years is detected, the stepsize is in months, otherwise the stepsize is in days in case of date(time) timeline and numeric in other cases. </paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0503201619582767" role="tablecontent" localize="false" xml-lang="en-US">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0503201619582717" role="tablecontent" xml-lang="en-US">Number of samples in period – this is the same as argument <emph>period_length</emph>, or the calculated number in case of argument <emph>period_length</emph> being 1. </paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+
+</section>
+
+<section id="confidence">
+<paragraph id="par_id0503201619582665" role="paragraph" xml-lang="en-US"><emph>confidence (mandatory)</emph>: A numeric value between 0 and 1 (exclusive), default is 0.95. A value indicating a confidence level for the calculated prediction interval. </paragraph>
+<paragraph id="par_id0503201619582644" role="note" xml-lang="en-US">With values &lt;= 0 or &gt;= 1, the functions will return the #NUM! Error.</paragraph>
+</section>
+
+<section id="numsampperiod">
+<paragraph id="par_id0603201609412381" role="paragraph" xml-lang="en-US"><emph>period_length (optional)</emph>: A numeric value &gt;= 0, the default is 1. A positive integer indicating the number of samples in a period. </paragraph>
+<paragraph id="par_id0603201609412399" role="note" xml-lang="en-US">A value of 1 indicates that Calc is to determine the number of samples in a period automatically. <br/>A value of 0 indicates no periodic effects, a forecast is calculated with EDS algorithms. <br/>For all other positive values, forecasts are calculated with ETS algorithms.<br/>For values that not being a positive whole number, the functions will return the #NUM! Error.</paragraph>
+</section>
+
+<section id="etsadd">
+<paragraph id="par_id0603201608440579" role="code" xml-lang="en-US">forecast = basevalue + trend * ∆x + periodical_abberation.</paragraph>
+</section>
+
+<section id="etsmult">
+<paragraph id="par_id0603201608440675" role="code" xml-lang="en-US">forecast = ( basevalue + trend * ∆x ) * periodical_abberation.</paragraph>
+</section>
+
+<section id="exampledata">
+ <paragraph id="hd_id0603201610005796" role="heading" level="2" xml-lang="en-US">Examples</paragraph>
+ <paragraph id="hd_id0603201610005723" role="paragraph" xml-lang="en-US">The table below contains a timeline and its associated values:</paragraph>
+<table id="Tabela3">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610293753" role="tablecontent" localize="false" xml-lang="en-US"/>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610300936" role="tablehead" localize="false" xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610303544" role="tablehead" localize="false" xml-lang="en-US">B</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610294112" role="tablehead" localize="false" xml-lang="en-US">1</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610312235" role="tablehead" xml-lang="en-US">Timeline</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610312228" role="tablehead" xml-lang="en-US">Values</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id090320161029434" role="tablehead" localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610301211" role="tablecontent" localize="false" xml-lang="en-US">01/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610303777" role="tablecontent" localize="false" xml-lang="en-US">112</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610294532" role="tablehead" localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610301377" role="tablecontent" localize="false" xml-lang="en-US">02/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610303972" role="tablecontent" localize="false" xml-lang="en-US">118</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610294658" role="tablehead" localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610301586" role="tablecontent" localize="false" xml-lang="en-US">03/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610304214" role="tablecontent" localize="false" xml-lang="en-US">132</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610294721" role="tablehead" localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610301829" role="tablecontent" localize="false" xml-lang="en-US">04/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610304365" role="tablecontent" localize="false" xml-lang="en-US">100</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610294810" role="tablehead" localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610301986" role="tablecontent" localize="false" xml-lang="en-US">05/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610304419" role="tablecontent" localize="false" xml-lang="en-US">121</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295069" role="tablehead" localize="false" xml-lang="en-US">7</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302140" role="tablecontent" localize="false" xml-lang="en-US">06/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id090320161030452" role="tablecontent" localize="false" xml-lang="en-US">135</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295133" role="tablehead" localize="false" xml-lang="en-US">8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302288" role="tablecontent" localize="false" xml-lang="en-US">07/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610304756" role="tablecontent" localize="false" xml-lang="en-US">148</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295347" role="tablehead" localize="false" xml-lang="en-US">9</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302389" role="tablecontent" localize="false" xml-lang="en-US">08/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id090320161030480" role="tablecontent" localize="false" xml-lang="en-US">148</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295495" role="tablehead" localize="false" xml-lang="en-US">10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302420" role="tablecontent" localize="false" xml-lang="en-US">09/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610304994" role="tablecontent" localize="false" xml-lang="en-US">136</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295668" role="tablehead" localize="false" xml-lang="en-US">11</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302687" role="tablecontent" localize="false" xml-lang="en-US">10/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610305156" role="tablecontent" localize="false" xml-lang="en-US">119</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610295729" role="tablehead" localize="false" xml-lang="en-US">12</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302713" role="tablecontent" localize="false" xml-lang="en-US">11/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610305294" role="tablecontent" localize="false" xml-lang="en-US">104</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id0903201610300473" role="tablehead" localize="false" xml-lang="en-US">13</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610302922" role="tablecontent" localize="false" xml-lang="en-US">12/2013</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id0903201610305330" role="tablecontent" localize="false" xml-lang="en-US">118</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsadd.xhp b/source/text/scalc/01/func_forecastetsadd.xhp
new file mode 100644
index 0000000000..04bf45b7c4
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetsadd.xhp
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+-->
+
+<meta>
+ <topic id="textscalc01func_forecastetsaddxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.ADD</title>
+ <filename>/text/scalc/01/func_forecastetsadd.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="function_forecastetsadd">
+ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_ADD" id="bm_id0603201610024692" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.ADD function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201610022291" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD fucntion</link></paragraph>
+<paragraph id="par_id0603201610023949" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_ADD">Calculates forecast(s) (future values) based on the historical data using ETS or EDS algorithms</ahelp>. EDS is used when argument <emph>period_length</emph> is 0, otherwise ETS is used.</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.ADD calculates with the model</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
+
+<paragraph id="hd_id0403201618594554" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0403201618594544" role="code" xml-lang="en-US">FORECAST.ETS.ADD(targets, values, timeline, [period_length], [data_completion], [aggregation]) </paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 157.166666666667, the additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;4;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 113.251442038722, the additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with period length of 4, no missing data, and SUM as aggregation.</paragraph>
+
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT</link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD</link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsmult.xhp b/source/text/scalc/01/func_forecastetsmult.xhp
new file mode 100644
index 0000000000..2b19e5e2b9
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetsmult.xhp
@@ -0,0 +1,63 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+-->
+
+<meta>
+ <topic id="textscalc01func_forecastetsmultxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.MULT</title>
+ <filename>/text/scalc/01/func_forecastetsmult.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="function_forecastetsmult">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_MULT" id="bm_id0603201610024692" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.MULT function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201610022291" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsmult.xhp"> FORECAST.ETS.MULT Function</link></paragraph>
+
+<paragraph id="par_id0603201610023949" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_MULT">Calculates additive forecast(s) (future values) based on the historical data using ETS or EDS algorithms</ahelp>. EDS is used when argument <emph>period_lenght</emph> is 0, otherwise ETS is used.</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.MULT calculates with the model </paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
+
+<paragraph id="hd_id0403201618594554" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0403201618594544" role="code" xml-lang="en-US">FORECAST.ETS.MULT(targets, values, timeline, [period_length], [data_completion], [aggregation]) </paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 131.71437427439, the multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;4;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 120.747806144882, the multiplicative forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with period length of 4, no missing data, and SUM as aggregation.</paragraph>
+
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also:
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT</link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD</link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp b/source/text/scalc/01/func_forecastetspiadd.xhp
new file mode 100644
index 0000000000..3d561b63a0
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetspiadd.xhp
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+<meta>
+ <topic id="textscalc01func_forecastpiaddxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.PI.ADD</title>
+ <filename>/text/scalc/01/func_forecastetspiadd.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="forecastetspiadd">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_PIA" id="bm_id0603201617144585" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.PI.ADD function</bookmark_value>
+</bookmark>
+<paragraph id="hd_id0603201617134175" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD function</link></paragraph>
+
+<paragraph id="par_id0603201617141750" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_PIA">Calculates Prediction Interval(s) based on the historical data using ETS or EDS algorithms.</ahelp>. EDS is used when argument <emph>period_lenght</emph> is 0, otherwise ETS is used.</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201610005998" role="paragraph" xml-lang="en-US">FORECAST.ETS.PI.ADD calculates with the model</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
+
+<paragraph id="hd_id0603201610005973" role="heading" level="2" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0603201610010044" role="code" xml-lang="en-US">FORECAST.ETS.PI.ADD(target, values, timeline, [confidence], [period_length], [completion], [aggregation])</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#confidence"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+<paragraph id="par_id0403201618595126" role="paragraph" xml-lang="en-US">For example, with a 90% Confidence level, a 90% prediction interval will be computed (90% of future points are to fall within this radius from forecast). </paragraph>
+<paragraph id="par_id0403201618595143" role="note" xml-lang="en-US">Note on Prediction Intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction Intervals tend to be increasingly 'over-optimistic' with increasing distance of the forecast-X to the observation data set.</paragraph>
+<paragraph id="par_id0403201618595150" role="paragraph" xml-lang="en-US">For ETS, Calc uses an approximation based on 1000 calculations with random variations within the standard deviation of the observation data set (the historical values).</paragraph>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0,9;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 18.8061295551355, the the additive prediction interval forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 23.4416821953741, the additive prediction interval forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation.</paragraph>
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT</link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetspimult.xhp b/source/text/scalc/01/func_forecastetspimult.xhp
new file mode 100644
index 0000000000..1afc765db0
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetspimult.xhp
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+<meta>
+ <topic id="textscalc01func_forecastetspimultxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.PI.MULT</title>
+ <filename>/text/scalc/01/func_forecastetspimult.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+<section id="forecastetspimult">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_PIM" id="bm_id0603201617144585" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.PI.MULT function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201617134175" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT function</link></paragraph>
+
+<paragraph id="par_id0603201617141750" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_PIM">Calculates Prediction Interval(s) based on the historical data using ETS or EDS algorithms.</ahelp>. EDS is used when argument <emph>period_lenght</emph> is 0, otherwise ETS is used.</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201610005998" role="paragraph" xml-lang="en-US">FORECAST.ETS.PI.MULT calculates with the model</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
+
+<paragraph id="hd_id0603201610005973" role="heading" level="2" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0603201610010044" role="code" xml-lang="en-US">FORECAST.ETS.PI.MULT(target, values, timeline, [confidence], [period_length], [completion], [aggregation])</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#confidence"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+<paragraph id="par_id0403201618595126" role="paragraph" xml-lang="en-US">For example, with a 90% Confidence level, a 90% prediction interval will be computed (90% of future points are to fall within this radius from forecast). </paragraph>
+<paragraph id="par_id0403201618595143" role="note" xml-lang="en-US">Note on Prediction Intervals: there is no exact mathematical way to calculate this for forecasts, there are various approximations. Prediction Intervals tend to be increasingly 'over-optimistic' with increasing distance of the forecast-X to the observation data set.</paragraph>
+<paragraph id="par_id0403201618595150" role="paragraph" xml-lang="en-US">For ETS, Calc uses an approximation based on 1000 calculations with random variations within the standard deviation of the observation data set (the historical values).</paragraph>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.MULT(DATE(2014;1;1);Values;Timeline;0,9;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 20.1040952101013, the the multiplicative prediction interval forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.PI.MULT(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 27.5285874381574, the multiplicative prediction interval forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with confidence level of 0.8, period length of 4, no missing data, and SUM as aggregation.</paragraph>
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT</link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsseason.xhp b/source/text/scalc/01/func_forecastetsseason.xhp
new file mode 100644
index 0000000000..7ffb6e6fa0
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetsseason.xhp
@@ -0,0 +1,58 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="textscalc01func_forecastetsseasonxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.SEASONALITY</title>
+ <filename>/text/scalc/01/func_forecastetsseason.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="forecastetsseasonality">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_SEA" id="bm_id0603201617512578" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.SEASONALITY function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201617435371" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY Function</link></paragraph>
+
+<paragraph id="par_id0603201617510446" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_SEA">Returns the number of samples in period as calculated by Calc in case of FORECAST.ETS functions when argument <emph>period_length</emph> equals 1. </ahelp></paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0403201618595132" role="paragraph" xml-lang="en-US">The same result is returned with FORECAST.ETS.STAT functions when argument <emph>stat_type</emph> equals 9 (and <emph>period_length</emph> equals 1).</paragraph>
+
+<paragraph id="hd_id0603201618013635" role="heading" level="2" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0603201618013796" role="code" xml-lang="en-US">FORECAST.ETS.SEASONALITY (values, timeline, [data_completion], [aggregation])</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.SEASONALITY(Values;Timeline;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 6, the number of samples in period based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, no missing data, and AVERAGE as aggregation.</paragraph>
+</section>
+
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT</link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD</link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp b/source/text/scalc/01/func_forecastetsstatadd.xhp
new file mode 100644
index 0000000000..5745214f03
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetsstatadd.xhp
@@ -0,0 +1,64 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="textscalc01func_forecastetsstataddxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.STAT.ADD</title>
+ <filename>/text/scalc/01/func_forecastetsstatadd.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="forecastetsstatadd">
+
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_STA" id="bm_id0603201615491416" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.STAT.ADD function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201615483251" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD Function</link></paragraph>
+
+<paragraph id="par_id0603201615485387" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_STA">Returns statistical value(s) that are results of the ETS/EDS algorithms.</ahelp></paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.STAT.ADD calculates with the model </paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
+
+<paragraph id="par_id050320162122554" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0603201610005728" role="code" xml-lang="en-US">FORECAST.ETS.STAT.ADD (values, timeline, stat_type, [period_length], [data_completion], [aggregation])</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#statistics"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.ADD(Values;Timeline;3;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 0.9990234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with beta smoothing, one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.ADD(Values;Timeline;2;1;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 0.0615234375, the additive statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with gamma smoothing, no missing data, and SUM as aggregation.</paragraph>
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD </link>,
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT </link>,
+ <link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT </link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD </link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>
diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp b/source/text/scalc/01/func_forecastetsstatmult.xhp
new file mode 100644
index 0000000000..e7a459f291
--- /dev/null
+++ b/source/text/scalc/01/func_forecastetsstatmult.xhp
@@ -0,0 +1,63 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="textscalc01func_forecastetsstatmultxml">
+ <title id="tit" xml-lang="en-US">FORECAST.ETS.STAT.MULT</title>
+ <filename>/text/scalc/01/func_forecastetsstatmult.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="forecastetsstatmult">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORECAST_ETS_STM" id="bm_id0603201615491416" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id976559765597655">
+<bookmark_value>FORECAST.ETS.STAT.MULT function</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id0603201615483251" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/func_forecastetsstatmult.xhp">FORECAST.ETS.STAT.MULT Function</link></paragraph>
+
+<paragraph id="par_id0603201615485387" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_STM">Returns statistical value(s) that are results of the ETS/EDS algorithms.</ahelp></paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
+<paragraph id="par_id0603201608440530" role="paragraph" xml-lang="en-US">FORECAST.ETS.STAT.MULT calculates with the model </paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
+
+<paragraph id="par_id050320162122554" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id0603201610005728" role="code" xml-lang="en-US">FORECAST.ETS.STAT.MULT (values, timeline, stat_type, [period_lenght], [data_completion], [aggregation])</paragraph>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#timeline"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#statistics"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#numsampperiod"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#datacompletion"/>
+<embed href="text/scalc/01/exponsmooth_embd.xhp#aggregation"/>
+
+<embed href="text/scalc/01/exponsmooth_embd.xhp#exampledata"/>
+ <paragraph id="hd_id04032016185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.MULT(Values;Timeline;5;1;TRUE();1)</paragraph>
+ <paragraph id="hd_id04032016112394554" role="paragraph" xml-lang="en-US">Returns 0.084073452803966, the multiplicative statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with symetric mean absolute percentage error (SMAPE), one sample per period, no missing data, and AVERAGE as aggregation.</paragraph>
+ <paragraph id="hd_id04032123185123" role="code" xml-lang="en-US">=FORECAST.ETS.STAT.MULT(Values;Timeline;7;1;TRUE();7)</paragraph>
+ <paragraph id="hd_id040312316112394554" role="paragraph" xml-lang="en-US">Returns 15.8372533480997, the multiplicative statistics based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, with root mean squared error, no missing data, and SUM as aggregation.</paragraph>
+</section>
+<section id="relatedtopics">
+<paragraph id="par_id0603201619261276" role="paragraph" xml-lang="en-US">See also :
+ <link href="text/scalc/01/func_forecastetsadd.xhp">FORECAST.ETS.ADD</link>,
+ <link href="text/scalc/01/func_forecastetsmult.xhp">FORECAST.ETS.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsstatadd.xhp">FORECAST.ETS.STAT.ADD</link>,
+ <link href="text/scalc/01/func_forecastetspiadd.xhp">FORECAST.ETS.PI.ADD</link>,
+ <link href="text/scalc/01/func_forecastetspimult.xhp">FORECAST.ETS.PI.MULT</link>,
+ <link href="text/scalc/01/func_forecastetsseason.xhp">FORECAST.ETS.SEASONALITY</link>,
+ <link href="text/scalc/01/04060185.xhp#forecast">FORECAST</link>,
+ <link href="text/scalc/01/04060185.xhp#forecastlinear">FORECAST.LINEAR</link>
+ </paragraph>
+</section>
+</body>
+
+</helpdocument>