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/en_AU/units/?format=api&page=37
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=38", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=36", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c553d69b6de8ec3a", "url": "https://translations.documentfoundation.org/api/units/112108195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.588691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=820ed1a562f74331", "url": "https://translations.documentfoundation.org/api/units/112108197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.590550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d294f95387370215", "url": "https://translations.documentfoundation.org/api/units/112108199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.592260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bdcab6b2c7fbe7ec", "url": "https://translations.documentfoundation.org/api/units/112108201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.594393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f0ffbb4dfa033256", "url": "https://translations.documentfoundation.org/api/units/112108203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.596664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7624980969d92950", "url": "https://translations.documentfoundation.org/api/units/112108205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.598579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=23bfda843d11f0d5", "url": "https://translations.documentfoundation.org/api/units/112108206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.600256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=8f34e9bf03dc5158", "url": "https://translations.documentfoundation.org/api/units/112108208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.602317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=281b3feda9918576", "url": "https://translations.documentfoundation.org/api/units/112108210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.603977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0e16b50c4e54f2de", "url": "https://translations.documentfoundation.org/api/units/112108212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.605710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=da913dac3b290157", "url": "https://translations.documentfoundation.org/api/units/112108214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.607630Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3de993bfc21b74a7", "url": "https://translations.documentfoundation.org/api/units/112108217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.611985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=517971471b4d8cd2", "url": "https://translations.documentfoundation.org/api/units/112108219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.615080Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=960242bcc1f96d1b", "url": "https://translations.documentfoundation.org/api/units/112108221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.617402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5e0f2c5875c097bf", "url": "https://translations.documentfoundation.org/api/units/112108223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.619329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fc8c5f56163e10c5", "url": "https://translations.documentfoundation.org/api/units/112108224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.620922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=77e6c15a8337bb4f", "url": "https://translations.documentfoundation.org/api/units/112108225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.622673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c127e4b6d9ecd747", "url": "https://translations.documentfoundation.org/api/units/112108226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.623959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7ad6e62d9f930872", "url": "https://translations.documentfoundation.org/api/units/112108227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.625223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f08faad185d52d4a", "url": "https://translations.documentfoundation.org/api/units/112108229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.627015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=def6635a586c6397", "url": "https://translations.documentfoundation.org/api/units/112108231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.628802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fb084d2d3d97956c", "url": "https://translations.documentfoundation.org/api/units/112108232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.630458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1b7c33ff6fd06179", "url": "https://translations.documentfoundation.org/api/units/112108234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.631917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=aeb5e7757799cd4e", "url": "https://translations.documentfoundation.org/api/units/112108236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.633020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5bf6b4e777114188", "url": "https://translations.documentfoundation.org/api/units/112108238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.634206Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1bca3c4f6a5c3f75", "url": "https://translations.documentfoundation.org/api/units/112108240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.635497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cf53f0167bd4cbe7", "url": "https://translations.documentfoundation.org/api/units/112108241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.636638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b5938079d6c7cd50", "url": "https://translations.documentfoundation.org/api/units/112108243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.637649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=dc646c9574a53aa0", "url": "https://translations.documentfoundation.org/api/units/112108245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.638669Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fa2688a7a74f1f05", "url": "https://translations.documentfoundation.org/api/units/112108247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.639678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=470d4dcd19c2c601", "url": "https://translations.documentfoundation.org/api/units/112108249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.640682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e70425babb50322c", "url": "https://translations.documentfoundation.org/api/units/112108251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.641724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=092ce57030a882ca", "url": "https://translations.documentfoundation.org/api/units/112108253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.643011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0247b89894f53ded", "url": "https://translations.documentfoundation.org/api/units/112108255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.644223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=90bbb4248a4bb1ab", "url": "https://translations.documentfoundation.org/api/units/112108257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.645558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fbafb04b71797d50", "url": "https://translations.documentfoundation.org/api/units/112108258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.646911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e76ef7e8b5b30890", "url": "https://translations.documentfoundation.org/api/units/112108260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.648163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=96e1f57dcd9246bc", "url": "https://translations.documentfoundation.org/api/units/112108262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.650004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5b4c2f469df94118", "url": "https://translations.documentfoundation.org/api/units/112108264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.651483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=476dcc730f188b50", "url": "https://translations.documentfoundation.org/api/units/112108265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.653514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=394f2d5a41fb443b", "url": "https://translations.documentfoundation.org/api/units/112108267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.656307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4d93c1331b82ee0e", "url": "https://translations.documentfoundation.org/api/units/112108270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.658229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=9d125adc23007fec", "url": "https://translations.documentfoundation.org/api/units/112108271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.659446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a8f18eafa53f2884", "url": "https://translations.documentfoundation.org/api/units/112108273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.660472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=8741ec02ef652b5b", "url": "https://translations.documentfoundation.org/api/units/112108275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.661648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=06e3179d449c5786", "url": "https://translations.documentfoundation.org/api/units/112108277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.662788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c4c0ab58ccd462ad", "url": "https://translations.documentfoundation.org/api/units/112108279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.663913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b7f59720b51c32e5", "url": "https://translations.documentfoundation.org/api/units/112108280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.664921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7e538af1e94dc3a0", "url": "https://translations.documentfoundation.org/api/units/112108282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.666024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?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": 112108284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=51bdb5e2458629fc", "url": "https://translations.documentfoundation.org/api/units/112108284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.667132Z" } ] }