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/hsb/units/?format=api&page=37
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=38", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=36", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Select a square range within the spreadsheet, for example, from A1 to E5." ], "previous_source": "", "target": [ "" ], "id_hash": 4995572374736268346, "content_hash": 4995572374736268346, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150949\nhelp.text", "note": "UQDNX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110970715/?format=api", "priority": 100, "id": 112354157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c553d69b6de8ec3a", "url": "https://translations.documentfoundation.org/api/units/112354157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.065076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Without deselecting the range, select the MUNIT function. Mark the <emph>Array</emph> check box. Enter the desired dimensions for the array unit, in this case <item type=\"input\">5</item>, and click <emph>OK</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 148286346009985841, "content_hash": 148286346009985841, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151260\nhelp.text", "note": "YABET", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110970724/?format=api", "priority": 100, "id": 112354158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=820ed1a562f74331", "url": "https://translations.documentfoundation.org/api/units/112354158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.066058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "You can also enter the <item type=\"input\">=MUNIT(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"keycode\">Shift + Command + Enter</item></caseinline><defaultinline><item type=\"keycode\">Shift + Ctrl + Enter</item></defaultinline></switchinline>." ], "previous_source": "", "target": [ "" ], "id_hash": 5950655144809398805, "content_hash": 5950655144809398805, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150403\nhelp.text", "note": "yywEQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110970737/?format=api", "priority": 100, "id": 112354159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d294f95387370215", "url": "https://translations.documentfoundation.org/api/units/112354159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.067098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "You now see a unit array with a range of A1:E5." ], "previous_source": "", "target": [ "" ], "id_hash": 4452572060584765420, "content_hash": 4452572060584765420, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156143\nhelp.text", "note": "gB9Be", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110970742/?format=api", "priority": 100, "id": 112354160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bdcab6b2c7fbe7ec", "url": "https://translations.documentfoundation.org/api/units/112354160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.068110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>FREQUENCY function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8142432594890535510, "content_hash": 8142432594890535510, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3159084\nhelp.text", "note": "Gf6DP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970750/?format=api", "priority": 100, "id": 112354161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f0ffbb4dfa033256", "url": "https://translations.documentfoundation.org/api/units/112354161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.069075Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "FREQUENCY" ], "previous_source": "", "target": [ "" ], "id_hash": -710275675019728560, "content_hash": -710275675019728560, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3159084\nhelp.text", "note": "z7DBb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110970761/?format=api", "priority": 100, "id": 112354162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7624980969d92950", "url": "https://translations.documentfoundation.org/api/units/112354162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.070049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HAEUFIGKEIT\">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the <emph>Data</emph> array that are within the values given by the <emph>Classes</emph> array." ], "previous_source": "", "target": [ "" ], "id_hash": -6647354263480438571, "content_hash": -6647354263480438571, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3145777\nhelp.text", "note": "CgxiG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110970762/?format=api", "priority": 100, "id": 112354163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=23bfda843d11f0d5", "url": "https://translations.documentfoundation.org/api/units/112354163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.071046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "FREQUENCY(Data; Classes)" ], "previous_source": "", "target": [ "" ], "id_hash": 1095757615970668888, "content_hash": 1095757615970668888, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155498\nhelp.text", "note": "NFDXK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970763/?format=api", "priority": 100, "id": 112354164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8f34e9bf03dc5158", "url": "https://translations.documentfoundation.org/api/units/112354164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.072065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Data</emph> represents the reference to the values to be counted." ], "previous_source": "", "target": [ "" ], "id_hash": -6333398160981785226, "content_hash": -6333398160981785226, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154352\nhelp.text", "note": "NCyy5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110970764/?format=api", "priority": 100, "id": 112354165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=281b3feda9918576", "url": "https://translations.documentfoundation.org/api/units/112354165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.073050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Classes</emph> represents the array of the limit values." ], "previous_source": "", "target": [ "" ], "id_hash": -8208174206377725218, "content_hash": -8208174206377725218, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3148402\nhelp.text", "note": "b3WxQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110970788/?format=api", "priority": 100, "id": 112354166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0e16b50c4e54f2de", "url": "https://translations.documentfoundation.org/api/units/112354166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.074035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "You can find a general introduction to Array functions at the top of this page." ], "previous_source": "", "target": [ "" ], "id_hash": 6526065144972771671, "content_hash": 6526065144972771671, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN10D71\nhelp.text", "note": "Wew2J", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110970831/?format=api", "priority": 100, "id": 112354167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=da913dac3b290157", "url": "https://translations.documentfoundation.org/api/units/112354167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.075160Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 and less than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." ], "previous_source": "", "target": [ "" ], "id_hash": -4762112679162973017, "content_hash": -4762112679162973017, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155904\nhelp.text", "note": "h7yjC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 98, "source_unit": "https://translations.documentfoundation.org/api/units/110970854/?format=api", "priority": 100, "id": 112354168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3de993bfc21b74a7", "url": "https://translations.documentfoundation.org/api/units/112354168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.076281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph> range in (A1:A11), and then the <emph>Classes</emph> range in which you entered the class limits (B1:B6). Select the <emph>Array</emph> check box and click <emph>OK</emph>. You will see the frequency count in the range C1:C6." ], "previous_source": "", "target": [ "" ], "id_hash": -3352523897385939758, "content_hash": -3352523897385939758, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150312\nhelp.text", "note": "tVPA4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/110970903/?format=api", "priority": 100, "id": 112354169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=517971471b4d8cd2", "url": "https://translations.documentfoundation.org/api/units/112354169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.077418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MDETERM function</bookmark_value><bookmark_value>determinants</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1585903397263469851, "content_hash": 1585903397263469851, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3151030\nhelp.text", "note": "shMJG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110970918/?format=api", "priority": 100, "id": 112354170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=960242bcc1f96d1b", "url": "https://translations.documentfoundation.org/api/units/112354170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.078656Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MDETERM" ], "previous_source": "", "target": [ "" ], "id_hash": -2445687314194589761, "content_hash": -2445687314194589761, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151030\nhelp.text", "note": "vg6ML", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110970957/?format=api", "priority": 100, "id": 112354171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5e0f2c5875c097bf", "url": "https://translations.documentfoundation.org/api/units/112354171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.079954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MDET\">Returns the array determinant of an array.</ahelp> This function returns a value in the current cell; it is not necessary to define a range for the results." ], "previous_source": "", "target": [ "" ], "id_hash": 8974652980787548357, "content_hash": 8974652980787548357, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154073\nhelp.text", "note": "KPSAt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110970999/?format=api", "priority": 100, "id": 112354172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fc8c5f56163e10c5", "url": "https://translations.documentfoundation.org/api/units/112354172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.081240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MDETERM(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": -583566507205215409, "content_hash": -583566507205215409, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156380\nhelp.text", "note": "Zahsu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971037/?format=api", "priority": 100, "id": 112354173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=77e6c15a8337bb4f", "url": "https://translations.documentfoundation.org/api/units/112354173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.082497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array</emph> represents a square array in which the determinants are defined." ], "previous_source": "", "target": [ "" ], "id_hash": 4694972610548389703, "content_hash": 4694972610548389703, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150290\nhelp.text", "note": "GEptz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110971062/?format=api", "priority": 100, "id": 112354174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c127e4b6d9ecd747", "url": "https://translations.documentfoundation.org/api/units/112354174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.083750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "You can find a general introduction to using Array functions on top of this page." ], "previous_source": "", "target": [ "" ], "id_hash": -371856835586357134, "content_hash": -371856835586357134, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN11635\nhelp.text", "note": "MbKkA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110971072/?format=api", "priority": 100, "id": 112354175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7ad6e62d9f930872", "url": "https://translations.documentfoundation.org/api/units/112354175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.084938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MINVERSE function</bookmark_value><bookmark_value>inverse arrays</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8110889270787779914, "content_hash": 8110889270787779914, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3151348\nhelp.text", "note": "y56Lm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1820, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110971088/?format=api", "priority": 100, "id": 112354176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f08faad185d52d4a", "url": "https://translations.documentfoundation.org/api/units/112354176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.086110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINVERSE" ], "previous_source": "", "target": [ "" ], "id_hash": 6842765923517752215, "content_hash": 6842765923517752215, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151348\nhelp.text", "note": "xTHGA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971107/?format=api", "priority": 100, "id": 112354177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=def6635a586c6397", "url": "https://translations.documentfoundation.org/api/units/112354177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.087318Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINV\">Returns the inverse array.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 8865420723181032812, "content_hash": 8865420723181032812, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3145569\nhelp.text", "note": "mnbtj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110971132/?format=api", "priority": 100, "id": 112354178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fb084d2d3d97956c", "url": "https://translations.documentfoundation.org/api/units/112354178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.088351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MINVERSE(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": -7242856928532995719, "content_hash": -7242856928532995719, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3156085\nhelp.text", "note": "A3Hyn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971215/?format=api", "priority": 100, "id": 112354179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1b7c33ff6fd06179", "url": "https://translations.documentfoundation.org/api/units/112354179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.089317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array</emph> represents a square array that is to be inverted." ], "previous_source": "", "target": [ "" ], "id_hash": 3365850788233071950, "content_hash": 3365850788233071950, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3157849\nhelp.text", "note": "ajEGo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110971257/?format=api", "priority": 100, "id": 112354180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=aeb5e7757799cd4e", "url": "https://translations.documentfoundation.org/api/units/112354180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.090284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Select a square range and select MINVERSE. Select the output array, select the <emph>Array</emph> field and click <emph>OK</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -2596689228904447608, "content_hash": -2596689228904447608, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149638\nhelp.text", "note": "YgTJD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110971267/?format=api", "priority": 100, "id": 112354181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5bf6b4e777114188", "url": "https://translations.documentfoundation.org/api/units/112354181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.091252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>MMULT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -7220892740750655627, "content_hash": -7220892740750655627, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3148546\nhelp.text", "note": "c2Z39", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971268/?format=api", "priority": 100, "id": 112354182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1bca3c4f6a5c3f75", "url": "https://translations.documentfoundation.org/api/units/112354182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.092273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MMULT" ], "previous_source": "", "target": [ "" ], "id_hash": 5716176331420781543, "content_hash": 5716176331420781543, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3148546\nhelp.text", "note": "cvame", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971269/?format=api", "priority": 100, "id": 112354183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cf53f0167bd4cbe7", "url": "https://translations.documentfoundation.org/api/units/112354183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.093618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns." ], "previous_source": "", "target": [ "" ], "id_hash": 3860570566369463632, "content_hash": 3860570566369463632, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3148518\nhelp.text", "note": "mWLDh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110971296/?format=api", "priority": 100, "id": 112354184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b5938079d6c7cd50", "url": "https://translations.documentfoundation.org/api/units/112354184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.095672Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "MMULT(Array 1; Array 2)" ], "previous_source": "", "target": [ "" ], "id_hash": 6657565538323348128, "content_hash": 6657565538323348128, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150798\nhelp.text", "note": "JUTAD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110971344/?format=api", "priority": 100, "id": 112354185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dc646c9574a53aa0", "url": "https://translations.documentfoundation.org/api/units/112354185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.097897Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array 1</emph> represents the first array used in the array product." ], "previous_source": "", "target": [ "" ], "id_hash": 8801872775390109445, "content_hash": 8801872775390109445, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150812\nhelp.text", "note": "DqghH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110971398/?format=api", "priority": 100, "id": 112354186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fa2688a7a74f1f05", "url": "https://translations.documentfoundation.org/api/units/112354186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.100057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array 2</emph> represents the second array with the same number of rows." ], "previous_source": "", "target": [ "" ], "id_hash": -4103538142168824319, "content_hash": -4103538142168824319, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152553\nhelp.text", "note": "FDfwg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110971406/?format=api", "priority": 100, "id": 112354187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=470d4dcd19c2c601", "url": "https://translations.documentfoundation.org/api/units/112354187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.102123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range." ], "previous_source": "", "target": [ "" ], "id_hash": 7423099569750159916, "content_hash": 7423099569750159916, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3146826\nhelp.text", "note": "CuGxm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1832, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110971409/?format=api", "priority": 100, "id": 112354188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e70425babb50322c", "url": "https://translations.documentfoundation.org/api/units/112354188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.103522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>TRANSPOSE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8562216521522707766, "content_hash": -8562216521522707766, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3154970\nhelp.text", "note": "vPBWq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971469/?format=api", "priority": 100, "id": 112354189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=092ce57030a882ca", "url": "https://translations.documentfoundation.org/api/units/112354189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.104664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TRANSPOSE" ], "previous_source": "", "target": [ "" ], "id_hash": -9059069159958823443, "content_hash": -9059069159958823443, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3154970\nhelp.text", "note": "5Tcfr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971474/?format=api", "priority": 100, "id": 112354190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0247b89894f53ded", "url": "https://translations.documentfoundation.org/api/units/112354190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.105736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MTRANS\">Transposes the rows and columns of an array.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 1205755394283778475, "content_hash": 1205755394283778475, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155276\nhelp.text", "note": "DQZoL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110971514/?format=api", "priority": 100, "id": 112354191, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=90bbb4248a4bb1ab", "url": "https://translations.documentfoundation.org/api/units/112354191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.106856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TRANSPOSE(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": 8912536025662324048, "content_hash": 8912536025662324048, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153843\nhelp.text", "note": "yX4Fn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971535/?format=api", "priority": 100, "id": 112354192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fbafb04b71797d50", "url": "https://translations.documentfoundation.org/api/units/112354192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.108031Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array</emph> represents the array in the spreadsheet that is to be transposed." ], "previous_source": "", "target": [ "" ], "id_hash": 7453167012197632144, "content_hash": 7453167012197632144, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153857\nhelp.text", "note": "FHbAX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110971562/?format=api", "priority": 100, "id": 112354193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e76ef7e8b5b30890", "url": "https://translations.documentfoundation.org/api/units/112354193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.109591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "You can find a general introduction to using Array functions on top of this page." ], "previous_source": "", "target": [ "" ], "id_hash": 1648868859262944956, "content_hash": 1648868859262944956, "location": "04060107.xhp", "context": "04060107.xhp\npar_idN11035\nhelp.text", "note": "eBkbU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110971582/?format=api", "priority": 100, "id": 112354194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=96e1f57dcd9246bc", "url": "https://translations.documentfoundation.org/api/units/112354194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.111233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes." ], "previous_source": "", "target": [ "" ], "id_hash": -2644686900828749544, "content_hash": -2644686900828749544, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3159366\nhelp.text", "note": "TdFfe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1839, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 85, "source_unit": "https://translations.documentfoundation.org/api/units/110971605/?format=api", "priority": 100, "id": 112354195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5b4c2f469df94118", "url": "https://translations.documentfoundation.org/api/units/112354195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.112563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:" ], "previous_source": "", "target": [ "" ], "id_hash": -4076377293153858736, "content_hash": -4076377293153858736, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3168518\nhelp.text", "note": "3oHh6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110971662/?format=api", "priority": 100, "id": 112354196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=476dcc730f188b50", "url": "https://translations.documentfoundation.org/api/units/112354196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.113962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TRANSPOSE(A1:D2)" ], "previous_source": "", "target": [ "" ], "id_hash": -5093802787855449029, "content_hash": -5093802787855449029, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3166145\nhelp.text", "note": "FVsQ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971689/?format=api", "priority": 100, "id": 112354197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=394f2d5a41fb443b", "url": "https://translations.documentfoundation.org/api/units/112354197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.115346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Then <emph>make sure to enter it as matrix formula with </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Shift + Command + Enter</emph></caseinline><defaultinline><emph>Shift + Ctrl + Enter</emph></defaultinline></switchinline>. The result will be as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -3633348049108799986, "content_hash": -3633348049108799986, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3178518\nhelp.text", "note": "EaoXz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1842, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110971716/?format=api", "priority": 100, "id": 112354198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4d93c1331b82ee0e", "url": "https://translations.documentfoundation.org/api/units/112354198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.116392Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>LINEST function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2094836678207242220, "content_hash": 2094836678207242220, "location": "04060107.xhp", "context": "04060107.xhp\nbm_id3109846\nhelp.text", "note": "CGWog", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110971744/?format=api", "priority": 100, "id": 112354199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9d125adc23007fec", "url": "https://translations.documentfoundation.org/api/units/112354199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.117410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "LINEST" ], "previous_source": "", "target": [ "" ], "id_hash": 2950296115947186308, "content_hash": 2950296115947186308, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3109846\nhelp.text", "note": "KKgvt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110971779/?format=api", "priority": 100, "id": 112354200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a8f18eafa53f2884", "url": "https://translations.documentfoundation.org/api/units/112354200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.118373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RGP\">Returns a table of statistics for a straight line that best fits a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 522958529102162779, "content_hash": 522958529102162779, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3144733\nhelp.text", "note": "GECEu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110971808/?format=api", "priority": 100, "id": 112354201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8741ec02ef652b5b", "url": "https://translations.documentfoundation.org/api/units/112354201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.119354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "LINEST(data_Y [; data_X [; linearType [; stats]]])" ], "previous_source": "", "target": [ "" ], "id_hash": -8727105688685488250, "content_hash": -8727105688685488250, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152839\nhelp.text", "note": "7YFEn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110971818/?format=api", "priority": 100, "id": 112354202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=06e3179d449c5786", "url": "https://translations.documentfoundation.org/api/units/112354202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.120388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>data_Y</emph> is a single row or column range specifying the y coordinates in a set of data points." ], "previous_source": "", "target": [ "" ], "id_hash": 4954147987989488301, "content_hash": 4954147987989488301, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3152853\nhelp.text", "note": "M2QFp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110971829/?format=api", "priority": 100, "id": 112354203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c4c0ab58ccd462ad", "url": "https://translations.documentfoundation.org/api/units/112354203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.121342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>data_X</emph> is a corresponding single row or column range specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item type=\"literal\">1, 2, 3, ..., n</item>. If there is more than one set of variables <emph>data_X</emph> may be a range with corresponding multiple rows or columns." ], "previous_source": "", "target": [ "" ], "id_hash": 4032295208113418981, "content_hash": 4032295208113418981, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154428\nhelp.text", "note": "pKKLj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/110971839/?format=api", "priority": 100, "id": 112354204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b7f59720b51c32e5", "url": "https://translations.documentfoundation.org/api/units/112354204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.122323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "LINEST finds a straight line <item type=\"literal\">y = a + bx</item> that best fits the data, using linear regression (the \"least squares\" method). With more than one set of variables the straight line is of the form <item type=\"literal\">y = a + b1x1 + b2x2 ... + bnxn</item>." ], "previous_source": "", "target": [ "" ], "id_hash": -120599993402932320, "content_hash": -120599993402932320, "location": "04060107.xhp", "context": "04060107.xhp\npar_id0811200804502119\nhelp.text", "note": "BWBpx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110971840/?format=api", "priority": 100, "id": 112354205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7e538af1e94dc3a0", "url": "https://translations.documentfoundation.org/api/units/112354205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.123367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If <emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin)." ], "previous_source": "", "target": [ "" ], "id_hash": -3333308165750642180, "content_hash": -3333308165750642180, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154448\nhelp.text", "note": "VG9J7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110971898/?format=api", "priority": 100, "id": 112354206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=51bdb5e2458629fc", "url": "https://translations.documentfoundation.org/api/units/112354206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.124368Z" } ] }{ "count": 8439, "next": "