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=159
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=160", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=158", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>share spreadsheet</bookmark_value> <bookmark_value>spreadsheet;collaboration</bookmark_value> <bookmark_value>spreadsheet;share</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2489854121294303907, "content_hash": 2489854121294303907, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\nbm_id671647274159909\nhelp.text", "note": "nGSyy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7901, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111193038/?format=api", "priority": 100, "id": 112436208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a28dbd21aa4a12a3", "url": "https://translations.documentfoundation.org/api/units/112436208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.294801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/shared_spreadsheet.xhp\">Share Spreadsheet</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -4250835850818561178, "content_hash": -4250835850818561178, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\nhd_id461647272004705\nhelp.text", "note": "yDBns", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7902, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111193096/?format=api", "priority": 100, "id": 112436209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4501ff50c976db66", "url": "https://translations.documentfoundation.org/api/units/112436209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.295960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Sharing a spreadsheet allows several users to open the same file for editing at the same time." ], "previous_source": "", "target": [ "" ], "id_hash": -4649798162586905476, "content_hash": -4649798162586905476, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\npar_id551647272004709\nhelp.text", "note": "KZGLG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7903, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/111193113/?format=api", "priority": 100, "id": 112436210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3f789934f1be547c", "url": "https://translations.documentfoundation.org/api/units/112436210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.297580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The spreadsheet needs to be on a shared drive, server, website, or similar. Some conditions must be met on operating systems with user permission management:" ], "previous_source": "", "target": [ "" ], "id_hash": 7512183453255805730, "content_hash": 7512183453255805730, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\npar_id211647275285230\nhelp.text", "note": "9BuYS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7904, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111193166/?format=api", "priority": 100, "id": 112436211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e840a30caae12b22", "url": "https://translations.documentfoundation.org/api/units/112436211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.299574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The shared file needs to reside in a location which is accessible by all collaborators." ], "previous_source": "", "target": [ "" ], "id_hash": 3641266573656955321, "content_hash": 3641266573656955321, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\npar_id621647275321672\nhelp.text", "note": "7Cbn3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7905, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111193179/?format=api", "priority": 100, "id": 112436212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b28860a80f5399b9", "url": "https://translations.documentfoundation.org/api/units/112436212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.301833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The file permissions for both the document and the corresponding lock file need to be set so that all collaborators can create, delete, and change the files." ], "previous_source": "", "target": [ "" ], "id_hash": 7842172435026492541, "content_hash": 7842172435026492541, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\npar_id731647275360618\nhelp.text", "note": "6hGDF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7906, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111193180/?format=api", "priority": 100, "id": 112436213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ecd4fe47b11d3c7d", "url": "https://translations.documentfoundation.org/api/units/112436213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.303234Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "In order to correctly identify the changes, each collaborator should enter their name in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - User Data</menuitem> on the Menu bar." ], "previous_source": "", "target": [ "" ], "id_hash": 5365539319250023305, "content_hash": 5365539319250023305, "location": "shared_spreadsheet.xhp", "context": "shared_spreadsheet.xhp\npar_id631647275500217\nhelp.text", "note": "UhRSD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7907, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/111193181/?format=api", "priority": 100, "id": 112436214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ca7639954049f389", "url": "https://translations.documentfoundation.org/api/units/112436214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.304576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Sheet Tab Color" ], "previous_source": "", "target": [ "" ], "id_hash": -5981570845704676280, "content_hash": -5981570845704676280, "location": "sheet_tab_color.xhp", "context": "sheet_tab_color.xhp\ntit\nhelp.text", "note": "Fjipz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7908, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111193231/?format=api", "priority": 100, "id": 112436215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2cfd3101eef09c48", "url": "https://translations.documentfoundation.org/api/units/112436215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.305939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/sheet_tab_color.xhp\">Sheet Tab Color</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4601492358539208417, "content_hash": 4601492358539208417, "location": "sheet_tab_color.xhp", "context": "sheet_tab_color.xhp\nhd_id481684777219483\nhelp.text", "note": "uRFek", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7909, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111193260/?format=api", "priority": 100, "id": 112436216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bfdbc8eb9b6766e1", "url": "https://translations.documentfoundation.org/api/units/112436216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.307049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Opens a color selector window where you can assign a color to the sheet tab." ], "previous_source": "", "target": [ "" ], "id_hash": 5169954279574332203, "content_hash": 5169954279574332203, "location": "sheet_tab_color.xhp", "context": "sheet_tab_color.xhp\npar_id05092009140203523\nhelp.text", "note": "BEcBk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7910, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111193301/?format=api", "priority": 100, "id": 112436217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c7bf5e069309e32b", "url": "https://translations.documentfoundation.org/api/units/112436217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.308033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Solver" ], "previous_source": "", "target": [ "" ], "id_hash": -169288640599896149, "content_hash": -169288640599896149, "location": "solver.xhp", "context": "solver.xhp\ntit\nhelp.text", "note": "k7H5Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7911, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111193316/?format=api", "priority": 100, "id": 112436218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7da690e0d888cfab", "url": "https://translations.documentfoundation.org/api/units/112436218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.308983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>goal seeking;solver</bookmark_value> <bookmark_value>what if operations;solver</bookmark_value> <bookmark_value>back-solving</bookmark_value> <bookmark_value>solver</bookmark_value> <bookmark_value>mathematical programming;solver for Calc</bookmark_value> <bookmark_value>mathematical optimization;solver for Calc</bookmark_value> <bookmark_value>operations research;solver for Calc</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2465490087328275122, "content_hash": -2465490087328275122, "location": "solver.xhp", "context": "solver.xhp\nbm_id7654652\nhelp.text", "note": "pDGKS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7912, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111193317/?format=api", "priority": 100, "id": 112436219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5dc8d1d40b8d254e", "url": "https://translations.documentfoundation.org/api/units/112436219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.309938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"solver\"><link href=\"text/scalc/01/solver.xhp\">Solver</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -3830354247019191108, "content_hash": -3830354247019191108, "location": "solver.xhp", "context": "solver.xhp\nhd_id9216284\nhelp.text", "note": "cBvDd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7913, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111193318/?format=api", "priority": 100, "id": 112436220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4ad7d91b3e8324bc", "url": "https://translations.documentfoundation.org/api/units/112436220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.310947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Opens the Solver dialog. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4111004312117100402, "content_hash": 4111004312117100402, "location": "solver.xhp", "context": "solver.xhp\npar_id9210486\nhelp.text", "note": "JGk9s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7914, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111193319/?format=api", "priority": 100, "id": 112436221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b90d38a40dd6bf72", "url": "https://translations.documentfoundation.org/api/units/112436221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.311883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Solver settings" ], "previous_source": "", "target": [ "" ], "id_hash": 2675576711974976608, "content_hash": 2675576711974976608, "location": "solver.xhp", "context": "solver.xhp\nhd_id21589912365601\nhelp.text", "note": "wszcE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7915, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111193320/?format=api", "priority": 100, "id": 112436222, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a5218ed7fe937c60", "url": "https://translations.documentfoundation.org/api/units/112436222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.313042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Target Cell" ], "previous_source": "", "target": [ "" ], "id_hash": -6432490799742893815, "content_hash": -6432490799742893815, "location": "solver.xhp", "context": "solver.xhp\nhd_id121589913023217\nhelp.text", "note": "GgVk7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7916, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111193321/?format=api", "priority": 100, "id": 112436223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=26bb33b2cc5b4109", "url": "https://translations.documentfoundation.org/api/units/112436223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.314057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Enter or click the cell reference of the target cell. This field takes the address of the cell whose value is to be optimized.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -5800787002628726764, "content_hash": -5800787002628726764, "location": "solver.xhp", "context": "solver.xhp\npar_id8538773\nhelp.text", "note": "EsgHG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7917, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111193342/?format=api", "priority": 100, "id": 112436224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2f7f76f47a9ca014", "url": "https://translations.documentfoundation.org/api/units/112436224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.315059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Optimize results to" ], "previous_source": "", "target": [ "" ], "id_hash": -6029236034779350377, "content_hash": -6029236034779350377, "location": "solver.xhp", "context": "solver.xhp\nhd_id441589913036601\nhelp.text", "note": "9j2m7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7918, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111193414/?format=api", "priority": 100, "id": 112436225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2c53d9c547fdfa97", "url": "https://translations.documentfoundation.org/api/units/112436225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.316086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Maximum:</emph> Try to solve the equation for a maximum value of the target cell.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4290699300027557219, "content_hash": 4290699300027557219, "location": "solver.xhp", "context": "solver.xhp\npar_id7564012\nhelp.text", "note": "U8Ttv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7919, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111193472/?format=api", "priority": 100, "id": 112436226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bb8ba047c028e563", "url": "https://translations.documentfoundation.org/api/units/112436226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.317085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Minimum:</emph> Try to solve the equation for a minimum value of the target cell.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2429922108896798884, "content_hash": -2429922108896798884, "location": "solver.xhp", "context": "solver.xhp\npar_id1186254\nhelp.text", "note": "N5C2U", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7920, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111193507/?format=api", "priority": 100, "id": 112436227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5e472eb75b56975c", "url": "https://translations.documentfoundation.org/api/units/112436227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.319029Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Value of:</emph> Try to solve the equation to approach a given value of the target cell.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3475460324661717868, "content_hash": 3475460324661717868, "location": "solver.xhp", "context": "solver.xhp\npar_id7432477\nhelp.text", "note": "JAo82", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7921, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/111193526/?format=api", "priority": 100, "id": 112436228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b03b50c0626ceb6c", "url": "https://translations.documentfoundation.org/api/units/112436228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.321119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Enter the value or a cell reference in the text field.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -1457270203426034260, "content_hash": -1457270203426034260, "location": "solver.xhp", "context": "solver.xhp\npar_id7141026\nhelp.text", "note": "5BC94", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7922, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111193602/?format=api", "priority": 100, "id": 112436229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6bc6bc788f07adac", "url": "https://translations.documentfoundation.org/api/units/112436229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.326497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "By Changing Cells" ], "previous_source": "", "target": [ "" ], "id_hash": -747392980121388723, "content_hash": -747392980121388723, "location": "solver.xhp", "context": "solver.xhp\nhd_id761589914010085\nhelp.text", "note": "KMA6B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7923, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111193629/?format=api", "priority": 100, "id": 112436230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=75a0ba0b603e794d", "url": "https://translations.documentfoundation.org/api/units/112436230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.328856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Enter the cell range that can be changed.</ahelp> These are the variables of the equations." ], "previous_source": "", "target": [ "" ], "id_hash": 6548355087789648653, "content_hash": 6548355087789648653, "location": "solver.xhp", "context": "solver.xhp\npar_id8531449\nhelp.text", "note": "VvrzV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7924, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111193698/?format=api", "priority": 100, "id": 112436231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dae06e41f6d2eb0d", "url": "https://translations.documentfoundation.org/api/units/112436231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.331192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Limiting Conditions" ], "previous_source": "", "target": [ "" ], "id_hash": 6364282747972679743, "content_hash": 6364282747972679743, "location": "solver.xhp", "context": "solver.xhp\nhd_id671589914927836\nhelp.text", "note": "if7S9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7925, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111193725/?format=api", "priority": 100, "id": 112436232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d85279709b0ef83f", "url": "https://translations.documentfoundation.org/api/units/112436232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.332460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Add the set of constraints for the mathematical problem. Each constraint is represented by a cell reference (a variable), an operator, and a value." ], "previous_source": "", "target": [ "" ], "id_hash": -6881169927386807402, "content_hash": -6881169927386807402, "location": "solver.xhp", "context": "solver.xhp\npar_id421589915278885\nhelp.text", "note": "QQCWC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7926, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/111193757/?format=api", "priority": 100, "id": 112436233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=20812c68b7024396", "url": "https://translations.documentfoundation.org/api/units/112436233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.333426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Cell reference:</emph> Enter a cell reference of the variable.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2390967711975543939, "content_hash": -2390967711975543939, "location": "solver.xhp", "context": "solver.xhp\npar_id9183935\nhelp.text", "note": "YApta", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7927, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111193769/?format=api", "priority": 100, "id": 112436234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5ed19388aa44eb7d", "url": "https://translations.documentfoundation.org/api/units/112436234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.334400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Click the Shrink button to shrink or restore the dialog. You can click or select cells in the sheet. You can enter a cell reference manually in the input box.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 70724633036726149, "content_hash": 70724633036726149, "location": "solver.xhp", "context": "solver.xhp\npar_id1939451\nhelp.text", "note": "eyxy9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7928, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/111193803/?format=api", "priority": 100, "id": 112436235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=80fb43add5061f85", "url": "https://translations.documentfoundation.org/api/units/112436235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.335400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Operator:</emph> Select an operator from the list.</ahelp> Use Binary operator to restrict your variable to 0 or 1. Use the Integer operator to restrict your variable to take only integer values (no decimal part)." ], "previous_source": "", "target": [ "" ], "id_hash": -3761586327352091270, "content_hash": -3761586327352091270, "location": "solver.xhp", "context": "solver.xhp\npar_id946684\nhelp.text", "note": "CWWbZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7929, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/111193855/?format=api", "priority": 100, "id": 112436236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4bcc292a3e365d7a", "url": "https://translations.documentfoundation.org/api/units/112436236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.336378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Value:</emph> Enter a value or a cell reference.</ahelp> This field is ignored when the operator is Binary or Integer." ], "previous_source": "", "target": [ "" ], "id_hash": -4654362324754817475, "content_hash": -4654362324754817475, "location": "solver.xhp", "context": "solver.xhp\npar_id9607226\nhelp.text", "note": "CtpNG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7930, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111193905/?format=api", "priority": 100, "id": 112436237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3f68622021071e3d", "url": "https://translations.documentfoundation.org/api/units/112436237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.337356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><emph>Remove button:</emph> Click to remove the row from the list. Any rows from below this row move up.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 6034905961690360245, "content_hash": 6034905961690360245, "location": "solver.xhp", "context": "solver.xhp\npar_id9038972\nhelp.text", "note": "GzohM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7931, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111193955/?format=api", "priority": 100, "id": 112436238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d3c04aff7370e9b5", "url": "https://translations.documentfoundation.org/api/units/112436238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.338321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "You can set multiple conditions for a variable. For example, a variable in cell A1 that must be an integer less than 10. In that case, set two limiting conditions for A1." ], "previous_source": "", "target": [ "" ], "id_hash": -6781471920092469806, "content_hash": -6781471920092469806, "location": "solver.xhp", "context": "solver.xhp\npar_id511589916338595\nhelp.text", "note": "H3FEH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7932, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111193998/?format=api", "priority": 100, "id": 112436239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=21e35f37ec9a25d2", "url": "https://translations.documentfoundation.org/api/units/112436239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.339310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "" ], "id_hash": -902513450646127754, "content_hash": -902513450646127754, "location": "solver.xhp", "context": "solver.xhp\nhd_id441589917031236\nhelp.text", "note": "B4DtG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7933, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111194042/?format=api", "priority": 100, "id": 112436240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7379a0cc6139bb76", "url": "https://translations.documentfoundation.org/api/units/112436240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.340271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Opens the <link href=\"text/scalc/01/solver_options.xhp#solveroptionsh1\">Solver Options</link> dialog.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 9103744343524302095, "content_hash": 9103744343524302095, "location": "solver.xhp", "context": "solver.xhp\npar_id2423780\nhelp.text", "note": "5aZF7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7934, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111194063/?format=api", "priority": 100, "id": 112436241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fe56ff3f29bcdd0f", "url": "https://translations.documentfoundation.org/api/units/112436241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.341216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The <emph>Solver Options</emph> dialog let you select the different solver algorithms for either linear and non-linear problems and set their solving parameters." ], "previous_source": "", "target": [ "" ], "id_hash": -8416899017505327805, "content_hash": -8416899017505327805, "location": "solver.xhp", "context": "solver.xhp\npar_id221589917833431\nhelp.text", "note": "jDGPG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7935, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111194091/?format=api", "priority": 100, "id": 112436242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0b312af02f42b543", "url": "https://translations.documentfoundation.org/api/units/112436242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.342196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Solve" ], "previous_source": "", "target": [ "" ], "id_hash": -6482207173939229572, "content_hash": -6482207173939229572, "location": "solver.xhp", "context": "solver.xhp\nhd_id771589917064147\nhelp.text", "note": "8YGDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7936, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111194126/?format=api", "priority": 100, "id": 112436243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=260a92eb64dd0c7c", "url": "https://translations.documentfoundation.org/api/units/112436243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.348216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\">Click to solve the problem with the current settings. The dialog settings are retained until you close the current document.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6296718917408287555, "content_hash": -6296718917408287555, "location": "solver.xhp", "context": "solver.xhp\npar_id2569658\nhelp.text", "note": "jFwTt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7937, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111194150/?format=api", "priority": 100, "id": 112436244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=289d8f818d6594bd", "url": "https://translations.documentfoundation.org/api/units/112436244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.350921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "To solve equations with the solver" ], "previous_source": "", "target": [ "" ], "id_hash": 456363052497750399, "content_hash": 456363052497750399, "location": "solver.xhp", "context": "solver.xhp\npar_id5474410\nhelp.text", "note": "VFnjv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7938, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111194160/?format=api", "priority": 100, "id": 112436245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=865553c740bdc97f", "url": "https://translations.documentfoundation.org/api/units/112436245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.376629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The goal of the solver process is to find those variable values of an equation that result in an optimized value in the <emph>target cell</emph>, also named the \"objective\". You can choose whether the value in the target cell should be a maximum, a minimum, or approaching a given value." ], "previous_source": "", "target": [ "" ], "id_hash": 3427986110705969512, "content_hash": 3427986110705969512, "location": "solver.xhp", "context": "solver.xhp\npar_id2216559\nhelp.text", "note": "HMiDW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7939, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/111194161/?format=api", "priority": 100, "id": 112436246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=af92a734979a2968", "url": "https://translations.documentfoundation.org/api/units/112436246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.380222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The initial variable values are inserted in a rectangular cell range that you enter in the <emph>By changing cells</emph> box." ], "previous_source": "", "target": [ "" ], "id_hash": 406957525090222790, "content_hash": 406957525090222790, "location": "solver.xhp", "context": "solver.xhp\npar_id7869502\nhelp.text", "note": "tPUFj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7940, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111194210/?format=api", "priority": 100, "id": 112436247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=85a5cdb681acc2c6", "url": "https://translations.documentfoundation.org/api/units/112436247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.383591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "You can define a series of limiting conditions that set constraints for some cells. For example, you can set the constraint that one of the variables or cells must not be bigger than another variable, or not bigger than a given value. You can also define the constraint that one or more variables must be integers (values without decimals), or binary values (where only 0 and 1 are allowed)." ], "previous_source": "", "target": [ "" ], "id_hash": 3751004467421655882, "content_hash": 3751004467421655882, "location": "solver.xhp", "context": "solver.xhp\npar_id9852900\nhelp.text", "note": "HtNbG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7941, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 69, "source_unit": "https://translations.documentfoundation.org/api/units/111194228/?format=api", "priority": 100, "id": 112436248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b40e3eb07f92334a", "url": "https://translations.documentfoundation.org/api/units/112436248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.385712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Using Non-Linear solvers" ], "previous_source": "", "target": [ "" ], "id_hash": -2363136234431922322, "content_hash": -2363136234431922322, "location": "solver.xhp", "context": "solver.xhp\nhd_id0603200910430882\nhelp.text", "note": "irGoh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7942, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111194245/?format=api", "priority": 100, "id": 112436249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5f34741d7ed4bf6e", "url": "https://translations.documentfoundation.org/api/units/112436249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.388214Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Regardless whether you use DEPS or SCO, you start by going to <menuitem>Tools - Solver</menuitem> and set the Cell to be optimized, the direction to go (minimization, maximization) and the cells to be modified to reach the goal. Then you go to the Options and specify the solver to be used and if necessary adjust the according <link href=\"text/scalc/01/solver_options.xhp\">parameters</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 778431936418991826, "content_hash": 778431936418991826, "location": "solver.xhp", "context": "solver.xhp\npar_id0603200910430845\nhelp.text", "note": "UTzzV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7943, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111194261/?format=api", "priority": 100, "id": 112436250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8acd8bb8cc12ced2", "url": "https://translations.documentfoundation.org/api/units/112436250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.389860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "There is also a list of constraints you can use to restrict the possible range of solutions or to penalize certain conditions. However, in case of the evolutionary solvers DEPS and SCO, these constraints are also used to specify bounds on the variables of the problem. Due to the random nature of the algorithms, it is <emph>highly recommended</emph> to do so and give upper (and in case \"Assume Non-Negative Variables\" is turned off also lower) bounds for all variables. They don't have to be near the actual solution (which is probably unknown) but should give a rough indication of the expected size (0 ≤ var ≤ 1 or maybe -1000000 ≤ var ≤ 1000000)." ], "previous_source": "", "target": [ "" ], "id_hash": 5140000261356386949, "content_hash": 5140000261356386949, "location": "solver.xhp", "context": "solver.xhp\npar_id0603200910430821\nhelp.text", "note": "gJGz2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 114, "source_unit": "https://translations.documentfoundation.org/api/units/111194279/?format=api", "priority": 100, "id": 112436251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c754f3013b8ffa85", "url": "https://translations.documentfoundation.org/api/units/112436251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.392410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Bounds are specified by selecting one or more variables (as range) on the left side and entering a numerical value (not a cell or a formula) on the right side. That way you can also choose one or more variables to be <emph>Integer</emph> or <emph>Binary</emph> only." ], "previous_source": "", "target": [ "" ], "id_hash": -963237502070867170, "content_hash": -963237502070867170, "location": "solver.xhp", "context": "solver.xhp\npar_id0603200910430873\nhelp.text", "note": "GFZqJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7945, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/111194300/?format=api", "priority": 100, "id": 112436252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=72a1e49866bb3b1e", "url": "https://translations.documentfoundation.org/api/units/112436252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.394651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/NLPSolver\">Wiki page on solvers and their algorithms</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2438698256178827796, "content_hash": -2438698256178827796, "location": "solver.xhp", "context": "solver.xhp\npar_id271589981559367\nhelp.text", "note": "nApF3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7946, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111194320/?format=api", "priority": 100, "id": 112436253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5e2800db5618adec", "url": "https://translations.documentfoundation.org/api/units/112436253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.396890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Solver Options" ], "previous_source": "", "target": [ "" ], "id_hash": 59236137812703730, "content_hash": 59236137812703730, "location": "solver_options.xhp", "context": "solver_options.xhp\ntit\nhelp.text", "note": "akxrP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7947, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111194328/?format=api", "priority": 100, "id": 112436254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=80d272f4183139f2", "url": "https://translations.documentfoundation.org/api/units/112436254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.398895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>solver for Calc;options</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4775707961655460697, "content_hash": -4775707961655460697, "location": "solver_options.xhp", "context": "solver_options.xhp\nbm_id291590166034871\nhelp.text", "note": "UBnZK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7948, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111194413/?format=api", "priority": 100, "id": 112436255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3db946e962857ca7", "url": "https://translations.documentfoundation.org/api/units/112436255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.400389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"solveroptionsh1\"><link href=\"text/scalc/01/solver_options.xhp\">Solver Options</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 7381661233447486494, "content_hash": 7381661233447486494, "location": "solver_options.xhp", "context": "solver_options.xhp\nhd_id2794274\nhelp.text", "note": "sPBHR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7949, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111194442/?format=api", "priority": 100, "id": 112436256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e670edc837e8c41e", "url": "https://translations.documentfoundation.org/api/units/112436256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.401853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Use the Options dialog to configure the solver engine." ], "previous_source": "", "target": [ "" ], "id_hash": -52670272274893761, "content_hash": -52670272274893761, "location": "solver_options.xhp", "context": "solver_options.xhp\npar_id3163853\nhelp.text", "note": "LHgS8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7950, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111194481/?format=api", "priority": 100, "id": 112436257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7f44e0aa9ad4f43f", "url": "https://translations.documentfoundation.org/api/units/112436257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:30.403018Z" } ] }