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=86
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=87", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=85", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": -7977618757259385461, "content_hash": -7977618757259385461, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2453976\nhelp.text", "note": "JEbgU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/111053486/?format=api", "priority": 100, "id": 112432558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1149ce01ec0fa58b", "url": "https://translations.documentfoundation.org/api/units/112432558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.284888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "PERCENTRANK.INC(Data; Value [; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": 3246910416661004990, "content_hash": 3246910416661004990, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2947238\nhelp.text", "note": "YfPDe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111053505/?format=api", "priority": 100, "id": 112432559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ad0f57d2329842be", "url": "https://translations.documentfoundation.org/api/units/112432559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.286209Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": -3809832170961013306, "content_hash": -3809832170961013306, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954266\nhelp.text", "note": "QmR4b", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111053527/?format=api", "priority": 100, "id": 112432560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4b20c1d36c0375c6", "url": "https://translations.documentfoundation.org/api/units/112432560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.287576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "" ], "id_hash": -8707785746311008920, "content_hash": -8707785746311008920, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2948475\nhelp.text", "note": "CjCor", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111053552/?format=api", "priority": 100, "id": 112432561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0727baffe2ec2d68", "url": "https://translations.documentfoundation.org/api/units/112432561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.288724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to." ], "previous_source": "", "target": [ "" ], "id_hash": -2779155355145501752, "content_hash": -2779155355145501752, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2648475\nhelp.text", "note": "qf4Ss", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111053581/?format=api", "priority": 100, "id": 112432562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=596e74edd8ed83c8", "url": "https://translations.documentfoundation.org/api/units/112432562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.289759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=PERCENTRANK.INC(A1:A50;50)</item> returns the percentage rank of the value 50 from the total range of all values found in A1:A50. If 50 falls outside the total range, an error message will appear." ], "previous_source": "", "target": [ "" ], "id_hash": 9045921848388488607, "content_hash": 9045921848388488607, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2949163\nhelp.text", "note": "EwRBE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111053587/?format=api", "priority": 100, "id": 112432563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fd8991fe67240d9f", "url": "https://translations.documentfoundation.org/api/units/112432563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.290737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>QUARTILE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4263704765753126388, "content_hash": 4263704765753126388, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id3166442\nhelp.text", "note": "naeAj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053588/?format=api", "priority": 100, "id": 112432564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bb2bb8e4f5daedf4", "url": "https://translations.documentfoundation.org/api/units/112432564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.291706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE" ], "previous_source": "", "target": [ "" ], "id_hash": 3110334196901073195, "content_hash": 3110334196901073195, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id3166442\nhelp.text", "note": "zG8mr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111053876/?format=api", "priority": 100, "id": 112432565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ab2a20790b09d12b", "url": "https://translations.documentfoundation.org/api/units/112432565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.292777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUARTILE\">Returns the quartile of a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2100962799212041749, "content_hash": -2100962799212041749, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3146958\nhelp.text", "note": "E6MEC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111053877/?format=api", "priority": 100, "id": 112432566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=62d7e1772aa7e9eb", "url": "https://translations.documentfoundation.org/api/units/112432566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.293947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE(Data; Type)" ], "previous_source": "", "target": [ "" ], "id_hash": 3612448919096912593, "content_hash": 3612448919096912593, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153684\nhelp.text", "note": "SKFH8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053878/?format=api", "priority": 100, "id": 112432567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b221ff270003ead1", "url": "https://translations.documentfoundation.org/api/units/112432567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.295011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": -3632401067737062036, "content_hash": -3632401067737062036, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153387\nhelp.text", "note": "BypuU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111053879/?format=api", "priority": 100, "id": 112432568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4d971e7963c8656c", "url": "https://translations.documentfoundation.org/api/units/112432568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.296347Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Type</emph> represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)" ], "previous_source": "", "target": [ "" ], "id_hash": -2206280425944819819, "content_hash": -2206280425944819819, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3155589\nhelp.text", "note": "aSRpW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/111053880/?format=api", "priority": 100, "id": 112432569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6161b7a458a95795", "url": "https://translations.documentfoundation.org/api/units/112432569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.298233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=QUARTILE(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": -2984319701457823295, "content_hash": -2984319701457823295, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3159276\nhelp.text", "note": "oXLQZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111053888/?format=api", "priority": 100, "id": 112432570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5695910b0a6819c1", "url": "https://translations.documentfoundation.org/api/units/112432570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.300832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>QUARTILE.EXC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 5972312952313654104, "content_hash": 5972312952313654104, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2866442\nhelp.text", "note": "rGSFw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053931/?format=api", "priority": 100, "id": 112432571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d2e1eafcca1eab58", "url": "https://translations.documentfoundation.org/api/units/112432571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.302446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE.EXC" ], "previous_source": "", "target": [ "" ], "id_hash": 1768584531839313321, "content_hash": 1768584531839313321, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2866442\nhelp.text", "note": "NHukC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111053956/?format=api", "priority": 100, "id": 112432572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=988b4642e78865a9", "url": "https://translations.documentfoundation.org/api/units/112432572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.303986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUARTILE_EXC\">Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6365731183688797808, "content_hash": -6365731183688797808, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2846958\nhelp.text", "note": "SZFDZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111054005/?format=api", "priority": 100, "id": 112432573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=27a861372c9a3190", "url": "https://translations.documentfoundation.org/api/units/112432573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.305454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The difference between <item type=\"input\">QUARTILE.INC</item> and <item type=\"input\">QUARTILE.EXC</item> is that the <item type=\"input\">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type=\"input\">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": 8070746398896606831, "content_hash": 8070746398896606831, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2353976\nhelp.text", "note": "oTHWG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111054044/?format=api", "priority": 100, "id": 112432574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f0010d16d27ece6f", "url": "https://translations.documentfoundation.org/api/units/112432574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.307419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE.EXC(Data; Type)" ], "previous_source": "", "target": [ "" ], "id_hash": 2197143877091721430, "content_hash": 2197143877091721430, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2853684\nhelp.text", "note": "yki2G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111054094/?format=api", "priority": 100, "id": 112432575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9e7dd2b71a7a00d6", "url": "https://translations.documentfoundation.org/api/units/112432575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.309786Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the range of data values for which you want to calculate the specified quartile." ], "previous_source": "", "target": [ "" ], "id_hash": -4732713455207104307, "content_hash": -4732713455207104307, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2853387\nhelp.text", "note": "BBCHu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111054112/?format=api", "priority": 100, "id": 112432576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3e52062ffeab40cd", "url": "https://translations.documentfoundation.org/api/units/112432576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.312027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Type</emph> An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values)" ], "previous_source": "", "target": [ "" ], "id_hash": -6888394945681360609, "content_hash": -6888394945681360609, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2855589\nhelp.text", "note": "5nCQJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111054113/?format=api", "priority": 100, "id": 112432577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2067814b0e10f91f", "url": "https://translations.documentfoundation.org/api/units/112432577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.313563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=QUARTILE.EXC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": 8943600720702432663, "content_hash": 8943600720702432663, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2859276\nhelp.text", "note": "8u38W", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111054116/?format=api", "priority": 100, "id": 112432578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fc1e0d7862656597", "url": "https://translations.documentfoundation.org/api/units/112432578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.314968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>QUARTILE.INC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3871791491352065076, "content_hash": 3871791491352065076, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2966442\nhelp.text", "note": "SVXeF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111054163/?format=api", "priority": 100, "id": 112432579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b5bb5dd9066b7434", "url": "https://translations.documentfoundation.org/api/units/112432579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.316182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE.INC" ], "previous_source": "", "target": [ "" ], "id_hash": 8690256258192919033, "content_hash": 8690256258192919033, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2966442\nhelp.text", "note": "GpKJA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111054222/?format=api", "priority": 100, "id": 112432580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f899fe061cb449f9", "url": "https://translations.documentfoundation.org/api/units/112432580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.317194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUARTILE_INC\">Returns the quartile of a data set.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2081951455752858209, "content_hash": -2081951455752858209, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2946958\nhelp.text", "note": "rsvn5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111054253/?format=api", "priority": 100, "id": 112432581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=631b6c2e803e559f", "url": "https://translations.documentfoundation.org/api/units/112432581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.318206Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The difference between <item type=\"input\">QUARTILE.INC</item> and <item type=\"input\">QUARTILE.EXC</item> is that the <item type=\"input\">QUARTILE.INC</item> function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the <item type=\"input\">QUARTILE.EXC</item> function bases its calculation on a percentile range of 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": 4783460191319659692, "content_hash": 4783460191319659692, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2253976\nhelp.text", "note": "z9AvW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111054286/?format=api", "priority": 100, "id": 112432582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c26243b33cd494ac", "url": "https://translations.documentfoundation.org/api/units/112432582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.319204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "QUARTILE.INC(Data; Type)" ], "previous_source": "", "target": [ "" ], "id_hash": -3175251652932145604, "content_hash": -3175251652932145604, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2953684\nhelp.text", "note": "qgazA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111054337/?format=api", "priority": 100, "id": 112432583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=53ef3d71e281ee3c", "url": "https://translations.documentfoundation.org/api/units/112432583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.320204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": -1471786030152819637, "content_hash": -1471786030152819637, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2953387\nhelp.text", "note": "SBw8d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111054389/?format=api", "priority": 100, "id": 112432584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6b932a67475bdc4b", "url": "https://translations.documentfoundation.org/api/units/112432584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.321623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Type</emph> represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)" ], "previous_source": "", "target": [ "" ], "id_hash": 4613647110213568263, "content_hash": 4613647110213568263, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2955589\nhelp.text", "note": "uStbq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/111054414/?format=api", "priority": 100, "id": 112432585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c006f79a43498707", "url": "https://translations.documentfoundation.org/api/units/112432585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.323255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=QUARTILE.INC(A1:A50;2)</item> returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": -971361341193720902, "content_hash": -971361341193720902, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2959276\nhelp.text", "note": "a6GUK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111054463/?format=api", "priority": 100, "id": 112432586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=72850801b599ebba", "url": "https://translations.documentfoundation.org/api/units/112432586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.324450Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Statistical Functions Part Five" ], "previous_source": "", "target": [ "" ], "id_hash": -8259675342387452960, "content_hash": -8259675342387452960, "location": "04060185.xhp", "context": "04060185.xhp\ntit\nhelp.text", "note": "D5ZGD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111054501/?format=api", "priority": 100, "id": 112432587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0d5fbd09a8f163e0", "url": "https://translations.documentfoundation.org/api/units/112432587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.325873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"rz\"><link href=\"text/scalc/01/04060185.xhp\">Statistical Functions Part Five</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4573360874848389266, "content_hash": 4573360874848389266, "location": "04060185.xhp", "context": "04060185.xhp\nhd_id3147072\nhelp.text", "note": "JzHCG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111054525/?format=api", "priority": 100, "id": 112432588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bf77d77c27020892", "url": "https://translations.documentfoundation.org/api/units/112432588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.327592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>RANK function</bookmark_value> <bookmark_value>numbers;determining ranks</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2527923692360999579, "content_hash": -2527923692360999579, "location": "04060185.xhp", "context": "04060185.xhp\nbm_id3155071\nhelp.text", "note": "REYKA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111054526/?format=api", "priority": 100, "id": 112432589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5ceb02cb99875d65", "url": "https://translations.documentfoundation.org/api/units/112432589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.328938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "RANK" ], "previous_source": "", "target": [ "" ], "id_hash": 1295097581310292350, "content_hash": 1295097581310292350, "location": "04060185.xhp", "context": "04060185.xhp\nhd_id3155071\nhelp.text", "note": "L4gtc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111054556/?format=api", "priority": 100, "id": 112432590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=91f91c637377b17e", "url": "https://translations.documentfoundation.org/api/units/112432590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.331376Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RANG\">Returns the rank of a number in a sample.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -5505466162875260788, "content_hash": -5505466162875260788, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3153976\nhelp.text", "note": "r5Q99", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111054568/?format=api", "priority": 100, "id": 112432591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3398a7b1aee3208c", "url": "https://translations.documentfoundation.org/api/units/112432591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.333553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "RANK(Value; Data [; Type])" ], "previous_source": "", "target": [ "" ], "id_hash": 6326817030969474366, "content_hash": 6326817030969474366, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3153250\nhelp.text", "note": "oVk4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111054598/?format=api", "priority": 100, "id": 112432592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d7cd5e9199d3bd3e", "url": "https://translations.documentfoundation.org/api/units/112432592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.334956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value</emph> is the value, whose rank is to be determined." ], "previous_source": "", "target": [ "" ], "id_hash": 7834228270601926127, "content_hash": 7834228270601926127, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3154543\nhelp.text", "note": "AzAQx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111054639/?format=api", "priority": 100, "id": 112432593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ecb8c51ac68cf5ef", "url": "https://translations.documentfoundation.org/api/units/112432593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.336440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> is the array or range of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": 5670998495889252337, "content_hash": 5670998495889252337, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3149130\nhelp.text", "note": "rCUdg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111054671/?format=api", "priority": 100, "id": 112432594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ceb36f15f540dff1", "url": "https://translations.documentfoundation.org/api/units/112432594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.338083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Type</emph> (optional) is the sequence order." ], "previous_source": "", "target": [ "" ], "id_hash": 8510102448011746582, "content_hash": 8510102448011746582, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3150215\nhelp.text", "note": "okjBp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111054709/?format=api", "priority": 100, "id": 112432595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f619f51687ec1d16", "url": "https://translations.documentfoundation.org/api/units/112432595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.339351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Type = 0 means descending from the last item of the array to the first (this is the default)," ], "previous_source": "", "target": [ "" ], "id_hash": 904609104765196277, "content_hash": 904609104765196277, "location": "04060185.xhp", "context": "04060185.xhp\npar_id9305398\nhelp.text", "note": "PrJu5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111054738/?format=api", "priority": 100, "id": 112432596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8c8dd1301e1d17f5", "url": "https://translations.documentfoundation.org/api/units/112432596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.340728Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Type = 1 means ascending from the first item of the range to the last." ], "previous_source": "", "target": [ "" ], "id_hash": -2987653646754566991, "content_hash": -2987653646754566991, "location": "04060185.xhp", "context": "04060185.xhp\npar_id9996948\nhelp.text", "note": "iTDKV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111054760/?format=api", "priority": 100, "id": 112432597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5689b8d6694b2cb1", "url": "https://translations.documentfoundation.org/api/units/112432597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.341990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=RANK(A10;A1:A50)</item> returns the ranking of the value in A10 in value range A1:A50. If <item type=\"literal\">Value</item> does not exist within the range an error message is displayed." ], "previous_source": "", "target": [ "" ], "id_hash": 6210685321560921583, "content_hash": 6210685321560921583, "location": "04060185.xhp", "context": "04060185.xhp\npar_id3155919\nhelp.text", "note": "kjqPS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111054795/?format=api", "priority": 100, "id": 112432598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d630c964f35f15ef", "url": "https://translations.documentfoundation.org/api/units/112432598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.343036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>RANK.AVG function</bookmark_value> <bookmark_value>numbers;determining ranks</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3127351551952936895, "content_hash": 3127351551952936895, "location": "04060185.xhp", "context": "04060185.xhp\nbm_id2955071\nhelp.text", "note": "wBmQf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111054840/?format=api", "priority": 100, "id": 112432599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ab6695aac5ebdfbf", "url": "https://translations.documentfoundation.org/api/units/112432599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.344041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "RANK.AVG" ], "previous_source": "", "target": [ "" ], "id_hash": -4770645256448525157, "content_hash": -4770645256448525157, "location": "04060185.xhp", "context": "04060185.xhp\nhd_id2955071\nhelp.text", "note": "ynDwy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111054844/?format=api", "priority": 100, "id": 112432600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3dcb436a4bfbbc9b", "url": "https://translations.documentfoundation.org/api/units/112432600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.345076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_RANK_AVG\">Returns the statistical rank of a given value, within a supplied array of values.</ahelp> If there are duplicate values in the list, the average rank is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -1760777311933631870, "content_hash": -1760777311933631870, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2953976\nhelp.text", "note": "EWhCU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111054845/?format=api", "priority": 100, "id": 112432601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6790765d21a0f282", "url": "https://translations.documentfoundation.org/api/units/112432601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.346157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The difference between <item type=\"input\">RANK.AVG</item> and <item type=\"input\">RANK.EQ</item> occurs when there are duplicates in the list of values. The <item type=\"input\">RANK.EQ</item> function returns the lower rank, whereas the <item type=\"input\">RANK.AVG</item> function returns the average rank." ], "previous_source": "", "target": [ "" ], "id_hash": -4993131397577793780, "content_hash": -4993131397577793780, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2653976\nhelp.text", "note": "BmBW6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/111054873/?format=api", "priority": 100, "id": 112432602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3ab4d572da869f0c", "url": "https://translations.documentfoundation.org/api/units/112432602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.347268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "RANK.AVG(Value; Data [; Type])" ], "previous_source": "", "target": [ "" ], "id_hash": 3198832905586027024, "content_hash": 3198832905586027024, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2953250\nhelp.text", "note": "f8zpD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111054883/?format=api", "priority": 100, "id": 112432603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ac64899459492a10", "url": "https://translations.documentfoundation.org/api/units/112432603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.348256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value</emph> is the value, whose rank is to be determined." ], "previous_source": "", "target": [ "" ], "id_hash": -7299765743168693109, "content_hash": -7299765743168693109, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2954543\nhelp.text", "note": "9jn8F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111054893/?format=api", "priority": 100, "id": 112432604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1ab205bb7edd5c8b", "url": "https://translations.documentfoundation.org/api/units/112432604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.350257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> is the array or range of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": 4209858368675809009, "content_hash": 4209858368675809009, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2949130\nhelp.text", "note": "B7Rub", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111054938/?format=api", "priority": 100, "id": 112432605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ba6c6be1aba086f1", "url": "https://translations.documentfoundation.org/api/units/112432605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.352928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Type</emph> (optional) is the sequence order." ], "previous_source": "", "target": [ "" ], "id_hash": 604736137838793500, "content_hash": 604736137838793500, "location": "04060185.xhp", "context": "04060185.xhp\npar_id2950215\nhelp.text", "note": "y7boJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111054939/?format=api", "priority": 100, "id": 112432606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8864745036b9131c", "url": "https://translations.documentfoundation.org/api/units/112432606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.355605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Type = 0 means descending from the last item of the array to the first (this is the default)," ], "previous_source": "", "target": [ "" ], "id_hash": 6395878065678288585, "content_hash": 6395878065678288585, "location": "04060185.xhp", "context": "04060185.xhp\npar_id0305398\nhelp.text", "note": "J7EAf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111054976/?format=api", "priority": 100, "id": 112432607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d8c2b936c37786c9", "url": "https://translations.documentfoundation.org/api/units/112432607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.357183Z" } ] }