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=37
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=38", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=36", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c553d69b6de8ec3a", "url": "https://translations.documentfoundation.org/api/units/112430108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.909632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=820ed1a562f74331", "url": "https://translations.documentfoundation.org/api/units/112430109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.910888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d294f95387370215", "url": "https://translations.documentfoundation.org/api/units/112430110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.912458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bdcab6b2c7fbe7ec", "url": "https://translations.documentfoundation.org/api/units/112430111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.913893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f0ffbb4dfa033256", "url": "https://translations.documentfoundation.org/api/units/112430112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.914999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7624980969d92950", "url": "https://translations.documentfoundation.org/api/units/112430113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.915927Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=23bfda843d11f0d5", "url": "https://translations.documentfoundation.org/api/units/112430114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.916869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8f34e9bf03dc5158", "url": "https://translations.documentfoundation.org/api/units/112430115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.917842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=281b3feda9918576", "url": "https://translations.documentfoundation.org/api/units/112430116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.918776Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0e16b50c4e54f2de", "url": "https://translations.documentfoundation.org/api/units/112430117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.919695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=da913dac3b290157", "url": "https://translations.documentfoundation.org/api/units/112430118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.920595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3de993bfc21b74a7", "url": "https://translations.documentfoundation.org/api/units/112430119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.921510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=517971471b4d8cd2", "url": "https://translations.documentfoundation.org/api/units/112430120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.922503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=960242bcc1f96d1b", "url": "https://translations.documentfoundation.org/api/units/112430121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.923477Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5e0f2c5875c097bf", "url": "https://translations.documentfoundation.org/api/units/112430122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.924354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fc8c5f56163e10c5", "url": "https://translations.documentfoundation.org/api/units/112430123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.925237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=77e6c15a8337bb4f", "url": "https://translations.documentfoundation.org/api/units/112430124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.926137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c127e4b6d9ecd747", "url": "https://translations.documentfoundation.org/api/units/112430125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.927189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7ad6e62d9f930872", "url": "https://translations.documentfoundation.org/api/units/112430126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.930149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f08faad185d52d4a", "url": "https://translations.documentfoundation.org/api/units/112430127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.933136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=def6635a586c6397", "url": "https://translations.documentfoundation.org/api/units/112430128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.935910Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fb084d2d3d97956c", "url": "https://translations.documentfoundation.org/api/units/112430129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.938163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1b7c33ff6fd06179", "url": "https://translations.documentfoundation.org/api/units/112430130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.939389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=aeb5e7757799cd4e", "url": "https://translations.documentfoundation.org/api/units/112430131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.940329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5bf6b4e777114188", "url": "https://translations.documentfoundation.org/api/units/112430132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.941335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1bca3c4f6a5c3f75", "url": "https://translations.documentfoundation.org/api/units/112430133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.942279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cf53f0167bd4cbe7", "url": "https://translations.documentfoundation.org/api/units/112430134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.945360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b5938079d6c7cd50", "url": "https://translations.documentfoundation.org/api/units/112430135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.946315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dc646c9574a53aa0", "url": "https://translations.documentfoundation.org/api/units/112430136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.947284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fa2688a7a74f1f05", "url": "https://translations.documentfoundation.org/api/units/112430137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.948258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=470d4dcd19c2c601", "url": "https://translations.documentfoundation.org/api/units/112430138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.949283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e70425babb50322c", "url": "https://translations.documentfoundation.org/api/units/112430139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.950333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=092ce57030a882ca", "url": "https://translations.documentfoundation.org/api/units/112430140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.951449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0247b89894f53ded", "url": "https://translations.documentfoundation.org/api/units/112430141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.952508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=90bbb4248a4bb1ab", "url": "https://translations.documentfoundation.org/api/units/112430142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.953533Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fbafb04b71797d50", "url": "https://translations.documentfoundation.org/api/units/112430143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.954589Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e76ef7e8b5b30890", "url": "https://translations.documentfoundation.org/api/units/112430144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.955606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=96e1f57dcd9246bc", "url": "https://translations.documentfoundation.org/api/units/112430145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.956605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5b4c2f469df94118", "url": "https://translations.documentfoundation.org/api/units/112430146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.957622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=476dcc730f188b50", "url": "https://translations.documentfoundation.org/api/units/112430147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.958767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=394f2d5a41fb443b", "url": "https://translations.documentfoundation.org/api/units/112430148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.959819Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4d93c1331b82ee0e", "url": "https://translations.documentfoundation.org/api/units/112430149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.960795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9d125adc23007fec", "url": "https://translations.documentfoundation.org/api/units/112430150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.961810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a8f18eafa53f2884", "url": "https://translations.documentfoundation.org/api/units/112430151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:04.962785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8741ec02ef652b5b", "url": "https://translations.documentfoundation.org/api/units/112430152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.525622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=06e3179d449c5786", "url": "https://translations.documentfoundation.org/api/units/112430153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.527567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c4c0ab58ccd462ad", "url": "https://translations.documentfoundation.org/api/units/112430154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.529233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b7f59720b51c32e5", "url": "https://translations.documentfoundation.org/api/units/112430155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.531017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7e538af1e94dc3a0", "url": "https://translations.documentfoundation.org/api/units/112430156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.532283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51bdb5e2458629fc", "url": "https://translations.documentfoundation.org/api/units/112430157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.533428Z" } ] }{ "count": 8439, "next": "