Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=139
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=140", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=138", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\">FLOOR.PRECISE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 370838481839743062, "content_hash": 370838481839743062, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id2957404\nhelp.text", "note": "Q6WU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6901, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314160/?format=api", "priority": 100, "id": 99529406, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=85257ba26b1a6056", "url": "https://translations.documentfoundation.org/api/units/99529406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.931849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 2370495124937784146, "content_hash": 2370495124937784146, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957432\nhelp.text", "note": "DgQBx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6902, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99314161/?format=api", "priority": 100, "id": 99529409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a0e5b0c1b7b63b52", "url": "https://translations.documentfoundation.org/api/units/99529409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.933272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 66257145829558831, "content_hash": 66257145829558831, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id261586641501175\nhelp.text", "note": "NHMnz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6903, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99314162/?format=api", "priority": 100, "id": 99529414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=80eb6485e9008a2f", "url": "https://translations.documentfoundation.org/api/units/99529414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.934721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR.PRECISE(Number[; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": 7745435786406884383, "content_hash": 7745435786406884383, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957464\nhelp.text", "note": "ni9y2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6904, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99314163/?format=api", "priority": 100, "id": 99529419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eb7d50cf8761741f", "url": "https://translations.documentfoundation.org/api/units/99529419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.936208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." ], "previous_source": "", "target": [ "" ], "id_hash": 2642075773291905594, "content_hash": 2642075773291905594, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957497\nhelp.text", "note": "pirHp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6905, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99314164/?format=api", "priority": 100, "id": 99529430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a4aa89eae0bac23a", "url": "https://translations.documentfoundation.org/api/units/99529430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.942714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.PRECISE(3.45)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": -21727037357043576, "content_hash": -21727037357043576, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id981586291388900\nhelp.text", "note": "smFCw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6906, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314165/?format=api", "priority": 100, "id": 99529432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7fb2cf5fe84fd088", "url": "https://translations.documentfoundation.org/api/units/99529432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.944776Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -3404203492867274222, "content_hash": -3404203492867274222, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id831586291395477\nhelp.text", "note": "Q9vnd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6907, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314166/?format=api", "priority": 100, "id": 99529437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=50c1d6f5a0808a12", "url": "https://translations.documentfoundation.org/api/units/99529437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.946447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FLOOR.XCL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -301887112973687715, "content_hash": -301887112973687715, "location": "func_floor.xhp", "context": "func_floor.xhp\nbm_id171586291849333\nhelp.text", "note": "HnS5F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6908, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99314236/?format=api", "priority": 100, "id": 99529452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7bcf7b452cef645d", "url": "https://translations.documentfoundation.org/api/units/99529452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.953382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\">FLOOR.XCL</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -849512561535502426, "content_hash": -849512561535502426, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id791586291468176\nhelp.text", "note": "gC7eY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6909, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314262/?format=api", "priority": 100, "id": 99529456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7435ecd38171b7a6", "url": "https://translations.documentfoundation.org/api/units/99529456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.955063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Rounds a number to the nearest multiple of a significance value." ], "previous_source": "", "target": [ "" ], "id_hash": -5250749246960873478, "content_hash": -5250749246960873478, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id521586291476023\nhelp.text", "note": "WMsAT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6910, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99314350/?format=api", "priority": 100, "id": 99529460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=372197612a3f4ffa", "url": "https://translations.documentfoundation.org/api/units/99529460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.956355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative." ], "previous_source": "", "target": [ "" ], "id_hash": 7873499457725653972, "content_hash": 7873499457725653972, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id401586291488768\nhelp.text", "note": "jrymG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6911, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/99314397/?format=api", "priority": 100, "id": 99529461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ed444a0a8cf7e3d4", "url": "https://translations.documentfoundation.org/api/units/99529461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.957554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function." ], "previous_source": "", "target": [ "" ], "id_hash": 4480435311530838145, "content_hash": 4480435311530838145, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id231586291503319\nhelp.text", "note": "BFXRR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6912, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/99314408/?format=api", "priority": 100, "id": 99529465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be2db42d6ee98881", "url": "https://translations.documentfoundation.org/api/units/99529465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.958943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR.XCL(Number; Significance)" ], "previous_source": "", "target": [ "" ], "id_hash": 4496390035747957631, "content_hash": 4496390035747957631, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id491586291532177\nhelp.text", "note": "WA7uC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6913, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99314472/?format=api", "priority": 100, "id": 99529467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be6662ea245ceb7f", "url": "https://translations.documentfoundation.org/api/units/99529467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.960365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded." ], "previous_source": "", "target": [ "" ], "id_hash": 2360606664300756422, "content_hash": 2360606664300756422, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id761586291578755\nhelp.text", "note": "aRww7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6914, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99314517/?format=api", "priority": 100, "id": 99529470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a0c28f411010fdc6", "url": "https://translations.documentfoundation.org/api/units/99529470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.961629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6915, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314544/?format=api", "priority": 100, "id": 99529472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0550c9872972c17f", "url": "https://translations.documentfoundation.org/api/units/99529472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.962952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6916, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314576/?format=api", "priority": 100, "id": 99529475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bc1feb6a4bfddfb6", "url": "https://translations.documentfoundation.org/api/units/99529475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.964364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6917, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314618/?format=api", "priority": 100, "id": 99529477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1b42cc95fe60050a", "url": "https://translations.documentfoundation.org/api/units/99529477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.965788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6918, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99314682/?format=api", "priority": 100, "id": 99529481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8e6e67a48d3e58f7", "url": "https://translations.documentfoundation.org/api/units/99529481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.967226Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6919, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99314711/?format=api", "priority": 100, "id": 99529485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c512fdf38fea04e8", "url": "https://translations.documentfoundation.org/api/units/99529485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.968768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.ADD function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función CONCATENAR</bookmark_value>" ], "id_hash": 1401542442830926795, "content_hash": 1401542442830926795, "location": "func_forecastetsadd.xhp", "context": "func_forecastetsadd.xhp\nbm_id976559765597655\nhelp.text", "note": "SDUKF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6920, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99314742/?format=api", "priority": 100, "id": 99529488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9373476d129213cb", "url": "https://translations.documentfoundation.org/api/units/99529488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.970220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6921, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314794/?format=api", "priority": 100, "id": 99529492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=49a76419307636ff", "url": "https://translations.documentfoundation.org/api/units/99529492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.972025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6922, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99314830/?format=api", "priority": 100, "id": 99529496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=58a1078829fbbf7c", "url": "https://translations.documentfoundation.org/api/units/99529496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.973567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6923, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99314870/?format=api", "priority": 100, "id": 99529500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=193e58cb4fd87062", "url": "https://translations.documentfoundation.org/api/units/99529500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.975143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6924, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99314903/?format=api", "priority": 100, "id": 99529503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7fc1982fb55d7805", "url": "https://translations.documentfoundation.org/api/units/99529503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.977086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6925, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99314915/?format=api", "priority": 100, "id": 99529512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5a0a2e2558e74322", "url": "https://translations.documentfoundation.org/api/units/99529512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.981569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6926, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99314916/?format=api", "priority": 100, "id": 99529517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1389c9979d86e462", "url": "https://translations.documentfoundation.org/api/units/99529517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.984477Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6927, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99314917/?format=api", "priority": 100, "id": 99529531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=671d41fe31d5f084", "url": "https://translations.documentfoundation.org/api/units/99529531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.993833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6928, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99314918/?format=api", "priority": 100, "id": 99529534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7a32edbb4a11fdb6", "url": "https://translations.documentfoundation.org/api/units/99529534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.995365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6929, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99315026/?format=api", "priority": 100, "id": 99529536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae0904066e5d8e39", "url": "https://translations.documentfoundation.org/api/units/99529536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.996659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6930, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99315051/?format=api", "priority": 100, "id": 99529537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=18deb002bcf2ce96", "url": "https://translations.documentfoundation.org/api/units/99529537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.998002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6931, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99315083/?format=api", "priority": 100, "id": 99529538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c5a1f637f2eeffd3", "url": "https://translations.documentfoundation.org/api/units/99529538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.999510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.MULT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DOMINGOPASCUA</bookmark_value>" ], "id_hash": 3846950496109871788, "content_hash": 3846950496109871788, "location": "func_forecastetsmult.xhp", "context": "func_forecastetsmult.xhp\nbm_id976559765597655\nhelp.text", "note": "PcfYS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6932, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99315112/?format=api", "priority": 100, "id": 99529541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b5631d181d2442ac", "url": "https://translations.documentfoundation.org/api/units/99529541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.003913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6933, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99315193/?format=api", "priority": 100, "id": 99529546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2f64f412b76aab1d", "url": "https://translations.documentfoundation.org/api/units/99529546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.010452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6934, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99315222/?format=api", "priority": 100, "id": 99529552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7761484e9e340077", "url": "https://translations.documentfoundation.org/api/units/99529552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.014727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6935, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99315268/?format=api", "priority": 100, "id": 99529557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f87f855ca59e81d6", "url": "https://translations.documentfoundation.org/api/units/99529557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.019184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6936, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99315288/?format=api", "priority": 100, "id": 99529562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3a9c80d6b720aa86", "url": "https://translations.documentfoundation.org/api/units/99529562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.021078Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6937, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99315316/?format=api", "priority": 100, "id": 99529563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=df6e8e843873215f", "url": "https://translations.documentfoundation.org/api/units/99529563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.022568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6938, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99315341/?format=api", "priority": 100, "id": 99529567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0ce04d644d1654de", "url": "https://translations.documentfoundation.org/api/units/99529567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.024074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6939, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99315365/?format=api", "priority": 100, "id": 99529568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e65e98aca51590d5", "url": "https://translations.documentfoundation.org/api/units/99529568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.025583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6940, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99315401/?format=api", "priority": 100, "id": 99529570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f2f33d9702d224da", "url": "https://translations.documentfoundation.org/api/units/99529570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.026959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6941, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99315430/?format=api", "priority": 100, "id": 99529571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5f5542ed1320a7d2", "url": "https://translations.documentfoundation.org/api/units/99529571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.030110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6942, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99315446/?format=api", "priority": 100, "id": 99529574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7f46168e61caa1eb", "url": "https://translations.documentfoundation.org/api/units/99529574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.034306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6943, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99315463/?format=api", "priority": 100, "id": 99529581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b5e30b02f26480c1", "url": "https://translations.documentfoundation.org/api/units/99529581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.038171Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FORECAST.ETS.PI.ADD function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DOMINGOPASCUA</bookmark_value>" ], "id_hash": -7305360582426940950, "content_hash": -7305360582426940950, "location": "func_forecastetspiadd.xhp", "context": "func_forecastetspiadd.xhp\nbm_id976559765597655\nhelp.text", "note": "iY4EE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99315481/?format=api", "priority": 100, "id": 99529587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1a9e2541784d29ea", "url": "https://translations.documentfoundation.org/api/units/99529587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.042330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6945, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99315519/?format=api", "priority": 100, "id": 99529591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=16873f5e1f23f9b9", "url": "https://translations.documentfoundation.org/api/units/99529591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.044295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6946, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99315568/?format=api", "priority": 100, "id": 99529593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=719da865d6670ca8", "url": "https://translations.documentfoundation.org/api/units/99529593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.045790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6947, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99315609/?format=api", "priority": 100, "id": 99529596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=676f7f15c9e1345d", "url": "https://translations.documentfoundation.org/api/units/99529596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.047407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6948, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99315653/?format=api", "priority": 100, "id": 99529597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7acb5c5cf3b6cd7d", "url": "https://translations.documentfoundation.org/api/units/99529597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.048898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6949, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99315694/?format=api", "priority": 100, "id": 99529599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1e37fb9560fd28d1", "url": "https://translations.documentfoundation.org/api/units/99529599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.050302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6950, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99315739/?format=api", "priority": 100, "id": 99529601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4aeadfabc4f98269", "url": "https://translations.documentfoundation.org/api/units/99529601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:36.051618Z" } ] }{ "count": 8352, "next": "