Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=94
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=95", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=93", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060106.xhp#Section26\">PRODUCT</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdots\">STDEV.S</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdotp\">STDEV.P</link>, <link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060185.xhp#vardots\">VAR.S</link>, <link href=\"text/scalc/01/04060185.xhp#vardotp\">VAR.P</link>, <link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link>, <link href=\"text/scalc/01/04060184.xhp#modedotsngl\">MODE.SNGL</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>, <link href=\"text/scalc/01/04060184.xhp#percentileinc\">PERCENTILE.INC</link> , <link href=\"text/scalc/01/04060184.xhp#quartileinc\">QUARTILE.INC</link>, <link href=\"text/scalc/01/04060184.xhp#percentileexc\">PERCENTILE.EXC</link>, <link href=\"text/scalc/01/04060184.xhp#quartileexc\">QUARTILE.EXC</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -1055625715242427970, "content_hash": -1055625715242427970, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id241712879431120\nhelp.text", "note": "cjxCG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6439, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24950691/?format=api", "priority": 100, "id": 1473451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7159aa01433519be", "url": "https://translations.documentfoundation.org/api/units/1473451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.034489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7032246338767650268, "content_hash": -7032246338767650268, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id125062615028497\nhelp.text", "note": "DCMbQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6440, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950692/?format=api", "priority": 100, "id": 1473452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1e6871369cb68224", "url": "https://translations.documentfoundation.org/api/units/1473452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.048535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "AVERAGEIF function" ], "previous_source": "", "target": [ "" ], "id_hash": 7906118277027848232, "content_hash": 7906118277027848232, "location": "func_averageif.xhp", "context": "func_averageif.xhp\ntit\nhelp.text", "note": "y9q7t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950693/?format=api", "priority": 100, "id": 1473453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/1473453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.060612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>AVERAGEIF function</bookmark_value> <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>AVEDEV ལས་འགན་</bookmark_value><bookmark_value>ཆ་སྙོམས་ཚུ་ ཚད་རྩིས་ལས་འགན་</bookmark_value>" ], "id_hash": 3420912059300929210, "content_hash": 3420912059300929210, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nbm_id237812197829662\nhelp.text", "note": "Xqih3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950694/?format=api", "priority": 100, "id": 1473454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=af798564a67b5eba", "url": "https://translations.documentfoundation.org/api/units/1473454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.081140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\"> དུས་ཚོད་ </link></variable>" ], "id_hash": -5363749350071768942, "content_hash": -5363749350071768942, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id16852304621982\nhelp.text", "note": "c5oJz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950696/?format=api", "priority": 100, "id": 1473455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=359022626cbd6892", "url": "https://translations.documentfoundation.org/api/units/1473455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.094223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"averageif_des\">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6622583741804826371, "content_hash": -6622583741804826371, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id7281266615152\nhelp.text", "note": "DFigD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24950697/?format=api", "priority": 100, "id": 1473456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2417db2cbe7230fd", "url": "https://translations.documentfoundation.org/api/units/1473456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.105475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "AVERAGEIF(Range; Criterion [; Average_Range ])" ], "previous_source": "", "target": [ "" ], "id_hash": -993686738782804889, "content_hash": -993686738782804889, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id200801176228491\nhelp.text", "note": "jto8p", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6467, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950699/?format=api", "priority": 100, "id": 1473457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7235b72d04d5a467", "url": "https://translations.documentfoundation.org/api/units/1473457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.120012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition." ], "previous_source": "", "target": [ "" ], "id_hash": -2017124283082570331, "content_hash": -2017124283082570331, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id15226321619829\nhelp.text", "note": "CCW4A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950701/?format=api", "priority": 100, "id": 1473458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6401bc26d70c85a5", "url": "https://translations.documentfoundation.org/api/units/1473458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.135011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean." ], "previous_source": "", "target": [ "" ], "id_hash": -98089280091714849, "content_hash": -98089280091714849, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id174711913219765\nhelp.text", "note": "sDeiD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950705/?format=api", "priority": 100, "id": 1473460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7ea38451c7dc0adf", "url": "https://translations.documentfoundation.org/api/units/1473460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.158207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error." ], "previous_source": "", "target": [ "" ], "id_hash": -3871217538132935641, "content_hash": -3871217538132935641, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id278275053653\nhelp.text", "note": "8v8Zv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/24950708/?format=api", "priority": 100, "id": 1473462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4a46ac28df52fc27", "url": "https://translations.documentfoundation.org/api/units/1473462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.183670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": 2753884199285647846, "content_hash": 2753884199285647846, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id229513120314273\nhelp.text", "note": "u7E4B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950712/?format=api", "priority": 100, "id": 1473464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a637c316aafb69e6", "url": "https://translations.documentfoundation.org/api/units/1473464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.208395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7978380300095268972, "content_hash": 7978380300095268972, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519225446\nhelp.text", "note": "CqBc8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950713/?format=api", "priority": 100, "id": 1473465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=eeb8e69c9627286c", "url": "https://translations.documentfoundation.org/api/units/1473465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.218489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -5817879000436386063, "content_hash": -5817879000436386063, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id11322891219251\nhelp.text", "note": "DFAzM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24950714/?format=api", "priority": 100, "id": 1473466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2f42bddfa0c8d6f1", "url": "https://translations.documentfoundation.org/api/units/1473466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.228280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -8874281900013346317, "content_hash": -8874281900013346317, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id250920151922590\nhelp.text", "note": "qcBmp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950715/?format=api", "priority": 100, "id": 1473467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=04d837a14106a1f3", "url": "https://translations.documentfoundation.org/api/units/1473467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.240332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -2185649765359564296, "content_hash": -2185649765359564296, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id3813266131474\nhelp.text", "note": "DqwCP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24950716/?format=api", "priority": 100, "id": 1473468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=61ab031e5453c9f8", "url": "https://translations.documentfoundation.org/api/units/1473468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.250261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2972934131274319266, "content_hash": 2972934131274319266, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519230832\nhelp.text", "note": "oFhok", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950717/?format=api", "priority": 100, "id": 1473469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a941fbd7533d85a2", "url": "https://translations.documentfoundation.org/api/units/1473469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.263690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -5935274051802001896, "content_hash": -5935274051802001896, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id243522732832394\nhelp.text", "note": "6MArD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950718/?format=api", "priority": 100, "id": 1473470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2da1abb241bf8e18", "url": "https://translations.documentfoundation.org/api/units/1473470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.274433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Using the Average_Range" ], "previous_source": "", "target": [ "" ], "id_hash": -8799472871613920817, "content_hash": -8799472871613920817, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id2101254257133\nhelp.text", "note": "gxAAH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950719/?format=api", "priority": 100, "id": 1473471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=05e1fe0b7cc409cf", "url": "https://translations.documentfoundation.org/api/units/1473471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.285693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 1778804898648709030, "content_hash": 1778804898648709030, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315584\nhelp.text", "note": "4oRE4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950720/?format=api", "priority": 100, "id": 1473472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=98af95a17cae57a6", "url": "https://translations.documentfoundation.org/api/units/1473472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.298059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 1759337501942295314, "content_hash": 1759337501942295314, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id148222637631350\nhelp.text", "note": "AGDaT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950721/?format=api", "priority": 100, "id": 1473473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=986a6c22fb4b2b12", "url": "https://translations.documentfoundation.org/api/units/1473473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.309997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7990476685659041340, "content_hash": 7990476685659041340, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315535\nhelp.text", "note": "crnMW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950722/?format=api", "priority": 100, "id": 1473474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=eee3e035d2bf6e3c", "url": "https://translations.documentfoundation.org/api/units/1473474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.322771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -4619371184654671204, "content_hash": -4619371184654671204, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2412836525208\nhelp.text", "note": "tiu8M", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/24950723/?format=api", "priority": 100, "id": 1473475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3fe4b261ccfba29c", "url": "https://translations.documentfoundation.org/api/units/1473475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.334923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 4882444317738799733, "content_hash": 4882444317738799733, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519315547\nhelp.text", "note": "HAi7e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950724/?format=api", "priority": 100, "id": 1473476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c3c1ed3d1a721275", "url": "https://translations.documentfoundation.org/api/units/1473476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.666045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 6249045149062265141, "content_hash": 6249045149062265141, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id173931101529497\nhelp.text", "note": "T6LU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24950725/?format=api", "priority": 100, "id": 1473477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d6b91174473bf935", "url": "https://translations.documentfoundation.org/api/units/1473477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.677200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Using regular expressions" ], "previous_source": "", "target": [ "" ], "id_hash": -6511700013815696116, "content_hash": -6511700013815696116, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id30054471316969\nhelp.text", "note": "Naigm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950726/?format=api", "priority": 100, "id": 1473478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=25a1cb56809bf50c", "url": "https://translations.documentfoundation.org/api/units/1473478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.688580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 4799956928460139135, "content_hash": 4799956928460139135, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519360514\nhelp.text", "note": "rJEzm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950727/?format=api", "priority": 100, "id": 1473479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c29cdf652a0aaa7f", "url": "https://translations.documentfoundation.org/api/units/1473479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.699562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range." ], "previous_source": "", "target": [ "" ], "id_hash": -3763770976287304356, "content_hash": -3763770976287304356, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id14714860719948\nhelp.text", "note": "pFhEN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/24950728/?format=api", "priority": 100, "id": 1473480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4bc4663d0678555c", "url": "https://translations.documentfoundation.org/api/units/1473480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.713063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -8355210824882972227, "content_hash": -8355210824882972227, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id250920151936096\nhelp.text", "note": "g76se", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950729/?format=api", "priority": 100, "id": 1473481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0c0c5405c75a19bd", "url": "https://translations.documentfoundation.org/api/units/1473481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.726461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -8996681651405615576, "content_hash": -8996681651405615576, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id26959239098104\nhelp.text", "note": "QX275", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24950730/?format=api", "priority": 100, "id": 1473482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=03255db45ab18e28", "url": "https://translations.documentfoundation.org/api/units/1473482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.739514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5422157762202301127, "content_hash": -5422157762202301127, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id2509201519361352\nhelp.text", "note": "L3vXX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950731/?format=api", "priority": 100, "id": 1473483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=34c0a03e3bce0d39", "url": "https://translations.documentfoundation.org/api/units/1473483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.751500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 3000864586355334547, "content_hash": 3000864586355334547, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id227041304619482\nhelp.text", "note": "pSESy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950732/?format=api", "priority": 100, "id": 1473484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a9a5367128c25d93", "url": "https://translations.documentfoundation.org/api/units/1473484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.764268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 5169793171942831839, "content_hash": 5169793171942831839, "location": "func_averageif.xhp", "context": "func_averageif.xhp\nhd_id251309885188\nhelp.text", "note": "SGMWy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950733/?format=api", "priority": 100, "id": 1473485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c7becb7fc7e476df", "url": "https://translations.documentfoundation.org/api/units/1473485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.773674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?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 AVERAGEIF function." ], "previous_source": "", "target": [ "" ], "id_hash": -1938851708135682050, "content_hash": -1938851708135682050, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id177972099720424\nhelp.text", "note": "CnVcF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950734/?format=api", "priority": 100, "id": 1473486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6517d0a4d869cffe", "url": "https://translations.documentfoundation.org/api/units/1473486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.785679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 8721990768323701577, "content_hash": 8721990768323701577, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id134941261230060\nhelp.text", "note": "3i7KZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950735/?format=api", "priority": 100, "id": 1473487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f90abc64882bab49", "url": "https://translations.documentfoundation.org/api/units/1473487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.799526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5." ], "previous_source": "", "target": [ "" ], "id_hash": -3962518927411692650, "content_hash": -3962518927411692650, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id172572288310247\nhelp.text", "note": "vTFAk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24950736/?format=api", "priority": 100, "id": 1473488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=49024e07a3dd3b96", "url": "https://translations.documentfoundation.org/api/units/1473488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.811222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7641095132828542682, "content_hash": 7641095132828542682, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id316901523627285\nhelp.text", "note": "2W6Qv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950737/?format=api", "priority": 100, "id": 1473489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ea0a9f89ff3626da", "url": "https://translations.documentfoundation.org/api/units/1473489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.824824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." ], "previous_source": "", "target": [ "" ], "id_hash": -5537168185278317268, "content_hash": -5537168185278317268, "location": "func_averageif.xhp", "context": "func_averageif.xhp\npar_id302181300528607\nhelp.text", "note": "5Mfay", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950738/?format=api", "priority": 100, "id": 1473490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=332806df66e43d2c", "url": "https://translations.documentfoundation.org/api/units/1473490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.835746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "AVERAGEIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": -8231205857855212900, "content_hash": -8231205857855212900, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\ntit\nhelp.text", "note": "TUEKr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950739/?format=api", "priority": 100, "id": 1473491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0dc4e1e2116cf29c", "url": "https://translations.documentfoundation.org/api/units/1473491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.848812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>AVERAGEIFS function</bookmark_value> <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>AVEDEV ལས་འགན་</bookmark_value><bookmark_value>ཆ་སྙོམས་ཚུ་ ཚད་རྩིས་ལས་འགན་</bookmark_value>" ], "id_hash": 6968964040490941999, "content_hash": 6968964040490941999, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nbm_id536715367153671\nhelp.text", "note": "DDuFq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950740/?format=api", "priority": 100, "id": 1473492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e0b6bbdf25eefe2f", "url": "https://translations.documentfoundation.org/api/units/1473492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.861486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\"> སྐར་ཆ། </link></variable>" ], "id_hash": -1407714252203597011, "content_hash": -1407714252203597011, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id537445374453744\nhelp.text", "note": "uGhsw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950741/?format=api", "priority": 100, "id": 1473493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6c76cb589426632d", "url": "https://translations.documentfoundation.org/api/units/1473493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.873447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"averageifs_des\">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3279985427204285555, "content_hash": 3279985427204285555, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id538405384053840\nhelp.text", "note": "CZ8LX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24950742/?format=api", "priority": 100, "id": 1473494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ad84d95e30f82473", "url": "https://translations.documentfoundation.org/api/units/1473494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.884200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": 7067003664368111027, "content_hash": 7067003664368111027, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id21050267713178\nhelp.text", "note": "zNyZv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950743/?format=api", "priority": 100, "id": 1473495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e2130a63e10b8db3", "url": "https://translations.documentfoundation.org/api/units/1473495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.897260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." ], "previous_source": "", "target": [ "" ], "id_hash": -6673945048355538743, "content_hash": -6673945048355538743, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id165832700711773\nhelp.text", "note": "8gSoS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950744/?format=api", "priority": 100, "id": 1473496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=23616256ae4a78c9", "url": "https://translations.documentfoundation.org/api/units/1473496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.909202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -177492428930155164, "content_hash": -177492428930155164, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id20733192524041\nhelp.text", "note": "y7NZn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950745/?format=api", "priority": 100, "id": 1473497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7d896b93874bfd64", "url": "https://translations.documentfoundation.org/api/units/1473497/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.920557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5171018155499093805, "content_hash": -5171018155499093805, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id24004653627203\nhelp.text", "note": "bcbN9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950746/?format=api", "priority": 100, "id": 1473498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=383cda62826180d3", "url": "https://translations.documentfoundation.org/api/units/1473498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.930868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -7122264083157546154, "content_hash": -7122264083157546154, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id30201168686268\nhelp.text", "note": "NGDGm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24950747/?format=api", "priority": 100, "id": 1473499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1d28a28d3edf0b56", "url": "https://translations.documentfoundation.org/api/units/1473499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.942446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 8739660139979311326, "content_hash": 8739660139979311326, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id30279247419921\nhelp.text", "note": "zb4se", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950748/?format=api", "priority": 100, "id": 1473500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f9498297b51b88de", "url": "https://translations.documentfoundation.org/api/units/1473500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.954270Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -9026955012991545679, "content_hash": -9026955012991545679, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id2930764965983\nhelp.text", "note": "7jj4X", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950749/?format=api", "priority": 100, "id": 1473501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=02b9d03e17350eb1", "url": "https://translations.documentfoundation.org/api/units/1473501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.964427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": -4802370245918093632, "content_hash": -4802370245918093632, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id317532515726820\nhelp.text", "note": "2pMbp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950750/?format=api", "priority": 100, "id": 1473502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3d5a8db494258ec0", "url": "https://translations.documentfoundation.org/api/units/1473502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.974713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5400278182055976891, "content_hash": -5400278182055976891, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id457966021670\nhelp.text", "note": "qZDFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950751/?format=api", "priority": 100, "id": 1473503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=350e5b9af642e045", "url": "https://translations.documentfoundation.org/api/units/1473503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.985559Z" } ] }{ "count": 8628, "next": "