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=146
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=147", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=145", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/JIS\">JIS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 2039448152051293608, "content_hash": 2039448152051293608, "location": "func_jis.xhp", "context": "func_jis.xhp\npar_id801677015502335\nhelp.text", "note": "jqAPC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111171966/?format=api", "priority": 100, "id": 112435558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9c4d9349f0d81da8", "url": "https://translations.documentfoundation.org/api/units/112435558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.257124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MAXIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": -2449898255212847766, "content_hash": -2449898255212847766, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\ntit\nhelp.text", "note": "Cauxq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172032/?format=api", "priority": 100, "id": 112435559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5e0036845a305d6a", "url": "https://translations.documentfoundation.org/api/units/112435559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.258163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3340120921755827711, "content_hash": -3340120921755827711, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nbm_id658066580665806\nhelp.text", "note": "8HdEW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172101/?format=api", "priority": 100, "id": 112435560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51a581b7e7e4c201", "url": "https://translations.documentfoundation.org/api/units/112435560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.259573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" ], "previous_source": "", "target": [ "" ], "id_hash": -1324032980930569323, "content_hash": -1324032980930569323, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id658866588665886\nhelp.text", "note": "kKHTn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172123/?format=api", "priority": 100, "id": 112435561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6da01704d4bb5b95", "url": "https://translations.documentfoundation.org/api/units/112435561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.261182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -7080741019089367299, "content_hash": -7080741019089367299, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id659756597565975\nhelp.text", "note": "DXshy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172186/?format=api", "priority": 100, "id": 112435562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1dbc278efaa40efd", "url": "https://translations.documentfoundation.org/api/units/112435562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.262502Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": -4696446051791201984, "content_hash": -4696446051791201984, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id11655988824213\nhelp.text", "note": "PKmRh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172220/?format=api", "priority": 100, "id": 112435563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3ed2df32e0331940", "url": "https://translations.documentfoundation.org/api/units/112435563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.263796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." ], "previous_source": "", "target": [ "" ], "id_hash": 2724450032633823262, "content_hash": 2724450032633823262, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id59901690530236\nhelp.text", "note": "UrwgE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172229/?format=api", "priority": 100, "id": 112435564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a5cf30deb370c01e", "url": "https://translations.documentfoundation.org/api/units/112435564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.273204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -5218410125489394970, "content_hash": -5218410125489394970, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id193452436229521\nhelp.text", "note": "BUavo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172272/?format=api", "priority": 100, "id": 112435565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=37947ba3a1e72ae6", "url": "https://translations.documentfoundation.org/api/units/112435565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.275393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 3417653096642167929, "content_hash": 3417653096642167929, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id94321051525036\nhelp.text", "note": "8CyiM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172306/?format=api", "priority": 100, "id": 112435566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=af6df16246dec479", "url": "https://translations.documentfoundation.org/api/units/112435566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.277473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -5025962791241282951, "content_hash": -5025962791241282951, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id28647227259438\nhelp.text", "note": "j2PKY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111172330/?format=api", "priority": 100, "id": 112435567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3a40317855bb8a79", "url": "https://translations.documentfoundation.org/api/units/112435567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.279059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -4882410858544181930, "content_hash": -4882410858544181930, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id36952767622741\nhelp.text", "note": "c6yAQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172361/?format=api", "priority": 100, "id": 112435568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3c3e313138f6cd56", "url": "https://translations.documentfoundation.org/api/units/112435568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.280385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -6133095175833196497, "content_hash": -6133095175833196497, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id189772445525114\nhelp.text", "note": "nGj4o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111172395/?format=api", "priority": 100, "id": 112435569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2ae2de6e9ecce82f", "url": "https://translations.documentfoundation.org/api/units/112435569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.281634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": 7310294577384814773, "content_hash": 7310294577384814773, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id30455222431067\nhelp.text", "note": "9Ayop", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111172431/?format=api", "priority": 100, "id": 112435570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e573622fc07c78b5", "url": "https://translations.documentfoundation.org/api/units/112435570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.282705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5335659071310958503, "content_hash": -5335659071310958503, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id307691022525348\nhelp.text", "note": "LNubZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172446/?format=api", "priority": 100, "id": 112435571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=35f3ee581beb7059", "url": "https://translations.documentfoundation.org/api/units/112435571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.283722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 2728227791290826569, "content_hash": 2728227791290826569, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id27619246864839\nhelp.text", "note": "CR2To", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/111172484/?format=api", "priority": 100, "id": 112435572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a5dc9cb8ae3cff49", "url": "https://translations.documentfoundation.org/api/units/112435572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.284733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 158249065123773810, "content_hash": 158249065123773810, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id220502883332563\nhelp.text", "note": "xriFt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172524/?format=api", "priority": 100, "id": 112435573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=823236afb0bd7d72", "url": "https://translations.documentfoundation.org/api/units/112435573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.285780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." ], "previous_source": "", "target": [ "" ], "id_hash": -3964634836356299185, "content_hash": -3964634836356299185, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id15342189586295\nhelp.text", "note": "FQicN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172542/?format=api", "priority": 100, "id": 112435574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=48fac99f32d8064f", "url": "https://translations.documentfoundation.org/api/units/112435574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.286821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 975754287595702701, "content_hash": 975754287595702701, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\nhd_id8168283329426\nhelp.text", "note": "DwLDF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111172674/?format=api", "priority": 100, "id": 112435575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8d8a935ad434c9ad", "url": "https://translations.documentfoundation.org/api/units/112435575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.287843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": 5584486400786439957, "content_hash": 5584486400786439957, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id50762995519951\nhelp.text", "note": "9BMGq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111172707/?format=api", "priority": 100, "id": 112435576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cd8014cb2be01f15", "url": "https://translations.documentfoundation.org/api/units/112435576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.288839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -8528842879162885577, "content_hash": -8528842879162885577, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id135761606425300\nhelp.text", "note": "gcYDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172745/?format=api", "priority": 100, "id": 112435577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=09a37696d2605a37", "url": "https://translations.documentfoundation.org/api/units/112435577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.289887Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -722999157949055427, "content_hash": -722999157949055427, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id30574750215839\nhelp.text", "note": "wHPFq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172771/?format=api", "priority": 100, "id": 112435578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=75f76418b18a3e3d", "url": "https://translations.documentfoundation.org/api/units/112435578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.290913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MAXIFS\">MAXIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -4761749996077925314, "content_hash": -4761749996077925314, "location": "func_maxifs.xhp", "context": "func_maxifs.xhp\npar_id401677015482616\nhelp.text", "note": "defwR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172786/?format=api", "priority": 100, "id": 112435579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3deadd9b7e8ebc3e", "url": "https://translations.documentfoundation.org/api/units/112435579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.291941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MINIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": 7812476771991873893, "content_hash": 7812476771991873893, "location": "func_minifs.xhp", "context": "func_minifs.xhp\ntit\nhelp.text", "note": "zGQnQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172791/?format=api", "priority": 100, "id": 112435580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ec6b7e3b5a90e965", "url": "https://translations.documentfoundation.org/api/units/112435580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.292946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1093582569723425218, "content_hash": -1093582569723425218, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nbm_id658066580665806\nhelp.text", "note": "V8Fu7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172844/?format=api", "priority": 100, "id": 112435581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=70d2d07267138e3e", "url": "https://translations.documentfoundation.org/api/units/112435581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.293938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" ], "previous_source": "", "target": [ "" ], "id_hash": -6433400122557603538, "content_hash": -6433400122557603538, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id658866588665886\nhelp.text", "note": "vnegG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111172893/?format=api", "priority": 100, "id": 112435582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=26b7f8ac94ffe12e", "url": "https://translations.documentfoundation.org/api/units/112435582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.294992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -841053936576294524, "content_hash": -841053936576294524, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id659756597565975\nhelp.text", "note": "PmaDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111172923/?format=api", "priority": 100, "id": 112435583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7453f9e6996d1184", "url": "https://translations.documentfoundation.org/api/units/112435583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.296005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": 8859664611740713808, "content_hash": 8859664611740713808, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id11655988824213\nhelp.text", "note": "yekSJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111172946/?format=api", "priority": 100, "id": 112435584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=faf3da061be78350", "url": "https://translations.documentfoundation.org/api/units/112435584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.297131Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." ], "previous_source": "", "target": [ "" ], "id_hash": 284793519782481500, "content_hash": 284793519782481500, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id59901690530236\nhelp.text", "note": "Gf5P2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111172971/?format=api", "priority": 100, "id": 112435585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=83f3ca3284f7ce5c", "url": "https://translations.documentfoundation.org/api/units/112435585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.298164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -6681775116397015665, "content_hash": -6681775116397015665, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id193452436229521\nhelp.text", "note": "KkDwL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172976/?format=api", "priority": 100, "id": 112435586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=234590eee61c8d8f", "url": "https://translations.documentfoundation.org/api/units/112435586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.299279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2823450842571719474, "content_hash": 2823450842571719474, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id94321051525036\nhelp.text", "note": "TGRCF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172977/?format=api", "priority": 100, "id": 112435587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a72ee9950043c332", "url": "https://translations.documentfoundation.org/api/units/112435587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.300408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." ], "previous_source": "", "target": [ "" ], "id_hash": 8689637701657927848, "content_hash": 8689637701657927848, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id28647227259438\nhelp.text", "note": "eRNbh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111172978/?format=api", "priority": 100, "id": 112435588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f897cb733229a0a8", "url": "https://translations.documentfoundation.org/api/units/112435588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.301441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 8274293814976130446, "content_hash": 8274293814976130446, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id36952767622741\nhelp.text", "note": "zufoC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111172979/?format=api", "priority": 100, "id": 112435589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f2d43262b8dd2d8e", "url": "https://translations.documentfoundation.org/api/units/112435589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.302496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 8479070192479725407, "content_hash": 8479070192479725407, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id189772445525114\nhelp.text", "note": "iCk4M", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111172980/?format=api", "priority": 100, "id": 112435590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f5abb56a805b675f", "url": "https://translations.documentfoundation.org/api/units/112435590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.303525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": 3935808270846501747, "content_hash": 3935808270846501747, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id30455222431067\nhelp.text", "note": "iqFXq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111173071/?format=api", "priority": 100, "id": 112435591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b69eccc4ffd9a373", "url": "https://translations.documentfoundation.org/api/units/112435591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.304582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 5059510094262033099, "content_hash": 5059510094262033099, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id307691022525348\nhelp.text", "note": "CBaMz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173119/?format=api", "priority": 100, "id": 112435592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c636fd9fd1fddacb", "url": "https://translations.documentfoundation.org/api/units/112435592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.305612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 65." ], "previous_source": "", "target": [ "" ], "id_hash": -4181087204647800947, "content_hash": -4181087204647800947, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id27619246864839\nhelp.text", "note": "Dp4Sx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111173174/?format=api", "priority": 100, "id": 112435593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=45f9cb56f8096f8d", "url": "https://translations.documentfoundation.org/api/units/112435593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.306634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2524283094541941754, "content_hash": 2524283094541941754, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id220502883332563\nhelp.text", "note": "7S443", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173196/?format=api", "priority": 100, "id": 112435594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/112435594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.307723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 1511293224466033220, "content_hash": 1511293224466033220, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id15342189586295\nhelp.text", "note": "gNhzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111173197/?format=api", "priority": 100, "id": 112435595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/112435595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.308771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 562770679139324109, "content_hash": 562770679139324109, "location": "func_minifs.xhp", "context": "func_minifs.xhp\nhd_id8168283329426\nhelp.text", "note": "uz4wr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111173198/?format=api", "priority": 100, "id": 112435596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=87cf5cf3741ad0cd", "url": "https://translations.documentfoundation.org/api/units/112435596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.309843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -6961485744941843957, "content_hash": -6961485744941843957, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id50762995519951\nhelp.text", "note": "27hDw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111173199/?format=api", "priority": 100, "id": 112435597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1f63d59937cbba0b", "url": "https://translations.documentfoundation.org/api/units/112435597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.310854Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -4878672984956085105, "content_hash": -4878672984956085105, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id135761606425300\nhelp.text", "note": "EcoDf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173200/?format=api", "priority": 100, "id": 112435598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3c4b78c4bc65dc8f", "url": "https://translations.documentfoundation.org/api/units/112435598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.311927Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -7124754506057414550, "content_hash": -7124754506057414550, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id30574750215839\nhelp.text", "note": "cxmqK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173201/?format=api", "priority": 100, "id": 112435599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1d1fc9867a95886a", "url": "https://translations.documentfoundation.org/api/units/112435599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.313077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS\">MINIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -4642634868378127656, "content_hash": -4642634868378127656, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id941677015454359\nhelp.text", "note": "zBVgq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173202/?format=api", "priority": 100, "id": 112435600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3f920c2f587ab2d8", "url": "https://translations.documentfoundation.org/api/units/112435600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.314163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MINUTE" ], "previous_source": "", "target": [ "" ], "id_hash": 6583649393914450800, "content_hash": 6583649393914450800, "location": "func_minute.xhp", "context": "func_minute.xhp\ntit\nhelp.text", "note": "SAxB8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173225/?format=api", "priority": 100, "id": 112435601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=db5dd23df9fc9370", "url": "https://translations.documentfoundation.org/api/units/112435601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.315846Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>MINUTE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6674063580216568736, "content_hash": 6674063580216568736, "location": "func_minute.xhp", "context": "func_minute.xhp\nbm_id3149803\nhelp.text", "note": "7cQwC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111173282/?format=api", "priority": 100, "id": 112435602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dc9f09772b2e2ba0", "url": "https://translations.documentfoundation.org/api/units/112435602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.317717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"minute\"><link href=\"text/scalc/01/func_minute.xhp\">MINUTE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6278203477099020855, "content_hash": -6278203477099020855, "location": "func_minute.xhp", "context": "func_minute.xhp\nhd_id3149803\nhelp.text", "note": "aFbYG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111173324/?format=api", "priority": 100, "id": 112435603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=28df57336fe3fdc9", "url": "https://translations.documentfoundation.org/api/units/112435603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.320038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_MINUTE\">Calculates the minute for an internal time value.</ahelp> The minute is returned as a number between 0 and 59." ], "previous_source": "", "target": [ "" ], "id_hash": 3800930512976531485, "content_hash": 3800930512976531485, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148988\nhelp.text", "note": "kGsA6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111173366/?format=api", "priority": 100, "id": 112435604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b4bf9e29d1e8d01d", "url": "https://translations.documentfoundation.org/api/units/112435604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.321997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "MINUTE(Number)" ], "previous_source": "", "target": [ "" ], "id_hash": -2617622125915151773, "content_hash": -2617622125915151773, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148660\nhelp.text", "note": "LeQE8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111173367/?format=api", "priority": 100, "id": 112435605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5bac568b949fe263", "url": "https://translations.documentfoundation.org/api/units/112435605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.323664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Number</emph>, as a time value, is a decimal number where the number of the minute is to be returned." ], "previous_source": "", "target": [ "" ], "id_hash": 316469162102282401, "content_hash": 316469162102282401, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3154611\nhelp.text", "note": "8eGft", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111173393/?format=api", "priority": 100, "id": 112435606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=84645306b578d8a1", "url": "https://translations.documentfoundation.org/api/units/112435606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.325224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MINUTE(8.999)</item> returns 58" ], "previous_source": "", "target": [ "" ], "id_hash": -4031844472942077863, "content_hash": -4031844472942077863, "location": "func_minute.xhp", "context": "func_minute.xhp\npar_id3148463\nhelp.text", "note": "L77op", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111173418/?format=api", "priority": 100, "id": 112435607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=480c02d040aa5859", "url": "https://translations.documentfoundation.org/api/units/112435607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:28.326702Z" } ] }