Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=141
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=142", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=140", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FLOOR.XCL(3.45,2)</input> returns 2." ], "previous_source": "", "target": [ "" ], "id_hash": -8840344486175129217, "content_hash": -8840344486175129217, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id531586291622306\nhelp.text", "note": "HXuMo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162328/?format=api", "priority": 100, "id": 112435308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0550c9872972c17f", "url": "https://translations.documentfoundation.org/api/units/112435308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.322207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FLOOR.XCL(-45.67,2)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": 4332440208327696310, "content_hash": 4332440208327696310, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id361586291628003\nhelp.text", "note": "gFyGC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162493/?format=api", "priority": 100, "id": 112435309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bc1feb6a4bfddfb6", "url": "https://translations.documentfoundation.org/api/units/112435309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.323411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": -7259014704777919222, "content_hash": -7259014704777919222, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id801586291641099\nhelp.text", "note": "EU7xy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162548/?format=api", "priority": 100, "id": 112435310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1b42cc95fe60050a", "url": "https://translations.documentfoundation.org/api/units/112435310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.324654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR\">FLOOR</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.MATH\">FLOOR.MATH</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.PRECISE\">FLOOR.PRECISE</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FLOOR.XCL\">FLOOR.XCL</link> wiki pages." ], "previous_source": "", "target": [ "" ], "id_hash": 1039882520411134199, "content_hash": 1039882520411134199, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id911677016119101\nhelp.text", "note": "LtNAq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111162601/?format=api", "priority": 100, "id": 112435311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8e6e67a48d3e58f7", "url": "https://translations.documentfoundation.org/api/units/112435311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.325926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.ADD" ], "previous_source": "", "target": [ "" ], "id_hash": 4977319760731178216, "content_hash": 4977319760731178216, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\ntit\nhelp.text", "note": "2YcR7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111162627/?format=api", "priority": 100, "id": 112435312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c512fdf38fea04e8", "url": "https://translations.documentfoundation.org/api/units/112435312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.327253Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.ADD function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1401542442830926795, "content_hash": 1401542442830926795, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nbm_id976559765597655\nhelp.text", "note": "SDUKF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111162643/?format=api", "priority": 100, "id": 112435313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9373476d129213cb", "url": "https://translations.documentfoundation.org/api/units/112435313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.328501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"text/scalc/01/func_forecastetsadd.xhp\">FORECAST.ETS.ADD function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -3916051291625343233, "content_hash": -3916051291625343233, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nhd_id0603201610022291\nhelp.text", "note": "Ai5EN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162685/?format=api", "priority": 100, "id": 112435314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=49a76419307636ff", "url": "https://translations.documentfoundation.org/api/units/112435314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.329936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FORECAST_ETS_ADD\">Calculates the additive 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." ], "previous_source": "", "target": [ "" ], "id_hash": -2836978008865390724, "content_hash": -2836978008865390724, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\npar_id0603201610023949\nhelp.text", "note": "gBZ7v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7008, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111162717/?format=api", "priority": 100, "id": 112435315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=58a1078829fbbf7c", "url": "https://translations.documentfoundation.org/api/units/112435315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.331231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.ADD calculates with the model" ], "previous_source": "", "target": [ "" ], "id_hash": -7404383107109326750, "content_hash": -7404383107109326750, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\npar_id0603201608440530\nhelp.text", "note": "Cy68d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7009, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111162758/?format=api", "priority": 100, "id": 112435316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=193e58cb4fd87062", "url": "https://translations.documentfoundation.org/api/units/112435316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.332578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.ADD(targets, values, timeline, [period_length], [data_completion], [aggregation])" ], "previous_source": "", "target": [ "" ], "id_hash": -17565592859084795, "content_hash": -17565592859084795, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\npar_id0403201618594544\nhelp.text", "note": "sRaGq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7010, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111162771/?format=api", "priority": 100, "id": 112435317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7fc1982fb55d7805", "url": "https://translations.documentfoundation.org/api/units/112435317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.333848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;1;TRUE();1)" ], "previous_source": "", "target": [ "" ], "id_hash": -2735323085733936350, "content_hash": -2735323085733936350, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nhd_id04032016185123\nhelp.text", "note": "cCDgz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7011, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111162773/?format=api", "priority": 100, "id": 112435318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a0a2e2558e74322", "url": "https://translations.documentfoundation.org/api/units/112435318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.335121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": -7815494025304677278, "content_hash": -7815494025304677278, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nhd_id04032016112394554\nhelp.text", "note": "BZHYV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7012, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111162785/?format=api", "priority": 100, "id": 112435319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1389c9979d86e462", "url": "https://translations.documentfoundation.org/api/units/112435319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.336378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;4;TRUE();7)" ], "previous_source": "", "target": [ "" ], "id_hash": -1793204516609986428, "content_hash": -1793204516609986428, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nhd_id04032123185123\nhelp.text", "note": "q2vBP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7013, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111162818/?format=api", "priority": 100, "id": 112435320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=671d41fe31d5f084", "url": "https://translations.documentfoundation.org/api/units/112435320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.337680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": -418010426734674506, "content_hash": -418010426734674506, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nhd_id040312316112394554\nhelp.text", "note": "ERJXc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7014, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111162865/?format=api", "priority": 100, "id": 112435321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7a32edbb4a11fdb6", "url": "https://translations.documentfoundation.org/api/units/112435321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.338944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.ADD\">FORECAST.ETS.ADD wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 3317187026203020857, "content_hash": 3317187026203020857, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\npar_id691677016005343\nhelp.text", "note": "LBqQW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7015, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111162905/?format=api", "priority": 100, "id": 112435322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ae0904066e5d8e39", "url": "https://translations.documentfoundation.org/api/units/112435322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.340228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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>" ], "previous_source": "", "target": [ "" ], "id_hash": -7431308809308287338, "content_hash": -7431308809308287338, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\npar_id0603201619261276\nhelp.text", "note": "2CDcv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7016, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111162912/?format=api", "priority": 100, "id": 112435323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=18deb002bcf2ce96", "url": "https://translations.documentfoundation.org/api/units/112435323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.341520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.MULT" ], "previous_source": "", "target": [ "" ], "id_hash": 5017562180026826707, "content_hash": 5017562180026826707, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\ntit\nhelp.text", "note": "6PMtc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7017, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111162913/?format=api", "priority": 100, "id": 112435324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c5a1f637f2eeffd3", "url": "https://translations.documentfoundation.org/api/units/112435324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.342831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.MULT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3846950496109871788, "content_hash": 3846950496109871788, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nbm_id976559765597655\nhelp.text", "note": "PcfYS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7018, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111162914/?format=api", "priority": 100, "id": 112435325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b5631d181d2442ac", "url": "https://translations.documentfoundation.org/api/units/112435325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.343943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"text/scalc/01/func_forecastetsmult.xhp\">FORECAST.ETS.MULT Function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5808249258177287395, "content_hash": -5808249258177287395, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nhd_id0603201610022291\nhelp.text", "note": "LnXao", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7019, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162915/?format=api", "priority": 100, "id": 112435326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2f64f412b76aab1d", "url": "https://translations.documentfoundation.org/api/units/112435326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.345202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FORECAST_ETS_MULT\">Calculates the multiplicative 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." ], "previous_source": "", "target": [ "" ], "id_hash": -621135771101560713, "content_hash": -621135771101560713, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\npar_id0603201610023949\nhelp.text", "note": "tYAjY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7020, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111162916/?format=api", "priority": 100, "id": 112435327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7761484e9e340077", "url": "https://translations.documentfoundation.org/api/units/112435327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.347050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.MULT calculates with the model" ], "previous_source": "", "target": [ "" ], "id_hash": 8682805239555719638, "content_hash": 8682805239555719638, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\npar_id0603201608440530\nhelp.text", "note": "enUbu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7021, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111162929/?format=api", "priority": 100, "id": 112435328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f87f855ca59e81d6", "url": "https://translations.documentfoundation.org/api/units/112435328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.349661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.MULT(targets, values, timeline, [period_length], [data_completion], [aggregation])" ], "previous_source": "", "target": [ "" ], "id_hash": -4999979826604365178, "content_hash": -4999979826604365178, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\npar_id0403201618594544\nhelp.text", "note": "joiBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7022, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111162962/?format=api", "priority": 100, "id": 112435329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3a9c80d6b720aa86", "url": "https://translations.documentfoundation.org/api/units/112435329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.354782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;1;TRUE();1)" ], "previous_source": "", "target": [ "" ], "id_hash": 6876590379575222623, "content_hash": 6876590379575222623, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nhd_id04032016185123\nhelp.text", "note": "bu5pP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7023, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111162980/?format=api", "priority": 100, "id": 112435330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=df6e8e843873215f", "url": "https://translations.documentfoundation.org/api/units/112435330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.356310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": -8295545420431076130, "content_hash": -8295545420431076130, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nhd_id04032016112394554\nhelp.text", "note": "r823v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7024, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111163005/?format=api", "priority": 100, "id": 112435331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0ce04d644d1654de", "url": "https://translations.documentfoundation.org/api/units/112435331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.358008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;4;TRUE();7)" ], "previous_source": "", "target": [ "" ], "id_hash": 7376501106950901973, "content_hash": 7376501106950901973, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nhd_id04032123185123\nhelp.text", "note": "UWXU6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7025, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111163032/?format=api", "priority": 100, "id": 112435332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e65e98aca51590d5", "url": "https://translations.documentfoundation.org/api/units/112435332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.359341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": 8283031858461156570, "content_hash": 8283031858461156570, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nhd_id040312316112394554\nhelp.text", "note": "PiBJn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7026, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111163072/?format=api", "priority": 100, "id": 112435333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f2f33d9702d224da", "url": "https://translations.documentfoundation.org/api/units/112435333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.360400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.MULT\">FORECAST.ETS.MULT wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -2353901644235626542, "content_hash": -2353901644235626542, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\npar_id501677015984498\nhelp.text", "note": "Gokyv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7027, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111163098/?format=api", "priority": 100, "id": 112435334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5f5542ed1320a7d2", "url": "https://translations.documentfoundation.org/api/units/112435334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.361464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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>" ], "previous_source": "", "target": [ "" ], "id_hash": -52329544886345237, "content_hash": -52329544886345237, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\npar_id0603201619261276\nhelp.text", "note": "CMedw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7028, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111163129/?format=api", "priority": 100, "id": 112435335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7f46168e61caa1eb", "url": "https://translations.documentfoundation.org/api/units/112435335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.362574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.ADD" ], "previous_source": "", "target": [ "" ], "id_hash": 3882959411008012481, "content_hash": 3882959411008012481, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\ntit\nhelp.text", "note": "jra8V", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7029, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111163163/?format=api", "priority": 100, "id": 112435336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b5e30b02f26480c1", "url": "https://translations.documentfoundation.org/api/units/112435336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.363645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.PI.ADD function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -7305360582426940950, "content_hash": -7305360582426940950, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nbm_id976559765597655\nhelp.text", "note": "iY4EE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7030, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111163172/?format=api", "priority": 100, "id": 112435337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1a9e2541784d29ea", "url": "https://translations.documentfoundation.org/api/units/112435337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.364565Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"text/scalc/01/func_forecastetspiadd.xhp\">FORECAST.ETS.PI.ADD function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7600036172682495559, "content_hash": -7600036172682495559, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nhd_id0603201617134175\nhelp.text", "note": "Ftk9s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111163186/?format=api", "priority": 100, "id": 112435338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=16873f5e1f23f9b9", "url": "https://translations.documentfoundation.org/api/units/112435338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.365513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FORECAST_ETS_PIA\">Calculates the prediction interval(s) for additive forecast 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." ], "previous_source": "", "target": [ "" ], "id_hash": -1036487183883105112, "content_hash": -1036487183883105112, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0603201617141750\nhelp.text", "note": "MNort", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/111163205/?format=api", "priority": 100, "id": 112435339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=719da865d6670ca8", "url": "https://translations.documentfoundation.org/api/units/112435339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.366607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.ADD calculates with the model" ], "previous_source": "", "target": [ "" ], "id_hash": -1770056396975295395, "content_hash": -1770056396975295395, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0603201610005998\nhelp.text", "note": "ZnBVX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7033, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111163216/?format=api", "priority": 100, "id": 112435340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=676f7f15c9e1345d", "url": "https://translations.documentfoundation.org/api/units/112435340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.367738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.ADD(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])" ], "previous_source": "", "target": [ "" ], "id_hash": -375104589659714179, "content_hash": -375104589659714179, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0603201610010044\nhelp.text", "note": "SBnyv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7034, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111163255/?format=api", "priority": 100, "id": 112435341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7acb5c5cf3b6cd7d", "url": "https://translations.documentfoundation.org/api/units/112435341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.368678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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)." ], "previous_source": "", "target": [ "" ], "id_hash": -7045886473001948975, "content_hash": -7045886473001948975, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0403201618595126\nhelp.text", "note": "LAKXv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7035, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111163274/?format=api", "priority": 100, "id": 112435342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1e37fb9560fd28d1", "url": "https://translations.documentfoundation.org/api/units/112435342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.369670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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' when increasing distance of the forecast-X from the observation data set." ], "previous_source": "", "target": [ "" ], "id_hash": -3824999004660727191, "content_hash": -3824999004660727191, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0403201618595143\nhelp.text", "note": "m37hk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/111163334/?format=api", "priority": 100, "id": 112435343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4aeadfabc4f98269", "url": "https://translations.documentfoundation.org/api/units/112435343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.370826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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)." ], "previous_source": "", "target": [ "" ], "id_hash": 3536764625990764506, "content_hash": 3536764625990764506, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0403201618595150\nhelp.text", "note": "FowFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7037, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111163360/?format=api", "priority": 100, "id": 112435344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b1151cb05258c7da", "url": "https://translations.documentfoundation.org/api/units/112435344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.371926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.9;1;TRUE();1)" ], "previous_source": "", "target": [ "" ], "id_hash": -4769859086945427728, "content_hash": -4769859086945427728, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nhd_id04032016185123\nhelp.text", "note": "KTjG5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111163400/?format=api", "priority": 100, "id": 112435345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3dce0e6ea5f2def0", "url": "https://translations.documentfoundation.org/api/units/112435345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.373069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Returns 18.8061295551355, the prediction interval for additive forecast for January 2014 based on <emph>Values</emph> and <emph>Timeline</emph> named ranges above, 90% (=0.9) confidence level, with one sample per period, no missing data, and AVERAGE as aggregation." ], "previous_source": "", "target": [ "" ], "id_hash": -7077889366336442118, "content_hash": -7077889366336442118, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nhd_id04032016112394554\nhelp.text", "note": "WAdwr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7039, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/111163458/?format=api", "priority": 100, "id": 112435346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1dc6491f200070fa", "url": "https://translations.documentfoundation.org/api/units/112435346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.374106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "=FORECAST.ETS.PI.ADD(DATE(2014;1;1);Values;Timeline;0.8;4;TRUE();7)" ], "previous_source": "", "target": [ "" ], "id_hash": -626779886751860414, "content_hash": -626779886751860414, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nhd_id04032123185123\nhelp.text", "note": "fZJa4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7040, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111163509/?format=api", "priority": 100, "id": 112435347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=774d3b0389cbb942", "url": "https://translations.documentfoundation.org/api/units/112435347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.375116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Returns 23.4416821953741, the prediction interval for additive 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." ], "previous_source": "", "target": [ "" ], "id_hash": 7857791279095254828, "content_hash": 7857791279095254828, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nhd_id040312316112394554\nhelp.text", "note": "U3bPF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7041, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/111163553/?format=api", "priority": 100, "id": 112435348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ed0c7b8935a28f2c", "url": "https://translations.documentfoundation.org/api/units/112435348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.376174Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FORECAST.ETS.PI.ADD\">FORECAST.ETS.PI.ADD wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7309193851986179963, "content_hash": 7309193851986179963, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id221677015965308\nhelp.text", "note": "aFBmX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7042, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111163619/?format=api", "priority": 100, "id": 112435349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e56f7915261af77b", "url": "https://translations.documentfoundation.org/api/units/112435349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.377301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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>" ], "previous_source": "", "target": [ "" ], "id_hash": -6114627880291916618, "content_hash": -6114627880291916618, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\npar_id0603201619261276\nhelp.text", "note": "J3FRt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7043, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111163650/?format=api", "priority": 100, "id": 112435350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2b247a56ed8024b6", "url": "https://translations.documentfoundation.org/api/units/112435350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.378379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.MULT" ], "previous_source": "", "target": [ "" ], "id_hash": 6937373311552921102, "content_hash": 6937373311552921102, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\ntit\nhelp.text", "note": "BAjwY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7044, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111163715/?format=api", "priority": 100, "id": 112435351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e046804565631e0e", "url": "https://translations.documentfoundation.org/api/units/112435351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.379647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.PI.MULT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 5876984233423769529, "content_hash": 5876984233423769529, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\nbm_id976559765597655\nhelp.text", "note": "fs4JG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7045, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111163752/?format=api", "priority": 100, "id": 112435352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d18f3e05cfcb8fb9", "url": "https://translations.documentfoundation.org/api/units/112435352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.380788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"text/scalc/01/func_forecastetspimult.xhp\">FORECAST.ETS.PI.MULT function</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8690471527634557673, "content_hash": 8690471527634557673, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\nhd_id0603201617134175\nhelp.text", "note": "o32J6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111163814/?format=api", "priority": 100, "id": 112435353, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f89ac1cf6f4ddae9", "url": "https://translations.documentfoundation.org/api/units/112435353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.381790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FORECAST_ETS_PIM\">Calculates the prediction interval(s) for multiplicative forecast 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." ], "previous_source": "", "target": [ "" ], "id_hash": 6817980928870657002, "content_hash": 6817980928870657002, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\npar_id0603201617141750\nhelp.text", "note": "dBj8S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/111163861/?format=api", "priority": 100, "id": 112435354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=de9e558816b92bea", "url": "https://translations.documentfoundation.org/api/units/112435354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.382803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.MULT calculates with the model" ], "previous_source": "", "target": [ "" ], "id_hash": 4864348593789675334, "content_hash": 4864348593789675334, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\npar_id0603201610005998\nhelp.text", "note": "zH7yz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7048, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111163920/?format=api", "priority": 100, "id": 112435355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c381a3460c812746", "url": "https://translations.documentfoundation.org/api/units/112435355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.384066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FORECAST.ETS.PI.MULT(target, values, timeline, [confidence_level], [period_length], [data_completion], [aggregation])" ], "previous_source": "", "target": [ "" ], "id_hash": -8795667083909873144, "content_hash": -8795667083909873144, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\npar_id0603201610010044\nhelp.text", "note": "FHdCq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7049, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111163969/?format=api", "priority": 100, "id": 112435356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=05ef83637cf4c208", "url": "https://translations.documentfoundation.org/api/units/112435356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.385070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "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)." ], "previous_source": "", "target": [ "" ], "id_hash": 5234577746308422190, "content_hash": 5234577746308422190, "location": "func_forecastetspimult.xhp", "context": "func_forecastetspimult.xhp\npar_id0403201618595126\nhelp.text", "note": "fM2ng", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111164006/?format=api", "priority": 100, "id": 112435357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c8a4f4b9ede0da2e", "url": "https://translations.documentfoundation.org/api/units/112435357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.386069Z" } ] }