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/hye/units/?format=api&page=86
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=87", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=85", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1149ce01ec0fa58b", "url": "https://translations.documentfoundation.org/api/units/112381924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.464045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ad0f57d2329842be", "url": "https://translations.documentfoundation.org/api/units/112381925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.465806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4b20c1d36c0375c6", "url": "https://translations.documentfoundation.org/api/units/112381926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.467242Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0727baffe2ec2d68", "url": "https://translations.documentfoundation.org/api/units/112381927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.468542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=596e74edd8ed83c8", "url": "https://translations.documentfoundation.org/api/units/112381928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.469955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=fd8991fe67240d9f", "url": "https://translations.documentfoundation.org/api/units/112381929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.471445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=bb2bb8e4f5daedf4", "url": "https://translations.documentfoundation.org/api/units/112381930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.472866Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ab2a20790b09d12b", "url": "https://translations.documentfoundation.org/api/units/112381931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.474440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=62d7e1772aa7e9eb", "url": "https://translations.documentfoundation.org/api/units/112381932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.476184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b221ff270003ead1", "url": "https://translations.documentfoundation.org/api/units/112381933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.477894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4d971e7963c8656c", "url": "https://translations.documentfoundation.org/api/units/112381934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.479466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6161b7a458a95795", "url": "https://translations.documentfoundation.org/api/units/112381935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.480654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5695910b0a6819c1", "url": "https://translations.documentfoundation.org/api/units/112381936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.482031Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d2e1eafcca1eab58", "url": "https://translations.documentfoundation.org/api/units/112381937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.483455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=988b4642e78865a9", "url": "https://translations.documentfoundation.org/api/units/112381938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.484699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=27a861372c9a3190", "url": "https://translations.documentfoundation.org/api/units/112381939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.485971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f0010d16d27ece6f", "url": "https://translations.documentfoundation.org/api/units/112381940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.487315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9e7dd2b71a7a00d6", "url": "https://translations.documentfoundation.org/api/units/112381941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.490191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3e52062ffeab40cd", "url": "https://translations.documentfoundation.org/api/units/112381942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.492576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=2067814b0e10f91f", "url": "https://translations.documentfoundation.org/api/units/112381943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.498018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=fc1e0d7862656597", "url": "https://translations.documentfoundation.org/api/units/112381944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.500674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b5bb5dd9066b7434", "url": "https://translations.documentfoundation.org/api/units/112381945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.502895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f899fe061cb449f9", "url": "https://translations.documentfoundation.org/api/units/112381946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.504449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=631b6c2e803e559f", "url": "https://translations.documentfoundation.org/api/units/112381947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.505671Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c26243b33cd494ac", "url": "https://translations.documentfoundation.org/api/units/112381948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.506910Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=53ef3d71e281ee3c", "url": "https://translations.documentfoundation.org/api/units/112381949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.508058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6b932a67475bdc4b", "url": "https://translations.documentfoundation.org/api/units/112381950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.509164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c006f79a43498707", "url": "https://translations.documentfoundation.org/api/units/112381951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.510696Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=72850801b599ebba", "url": "https://translations.documentfoundation.org/api/units/112381952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.512390Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0d5fbd09a8f163e0", "url": "https://translations.documentfoundation.org/api/units/112381953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.514550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=bf77d77c27020892", "url": "https://translations.documentfoundation.org/api/units/112381954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.516604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5ceb02cb99875d65", "url": "https://translations.documentfoundation.org/api/units/112381955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.519180Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=91f91c637377b17e", "url": "https://translations.documentfoundation.org/api/units/112381956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.521025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3398a7b1aee3208c", "url": "https://translations.documentfoundation.org/api/units/112381957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.522963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d7cd5e9199d3bd3e", "url": "https://translations.documentfoundation.org/api/units/112381958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.524796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ecb8c51ac68cf5ef", "url": "https://translations.documentfoundation.org/api/units/112381959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.526208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ceb36f15f540dff1", "url": "https://translations.documentfoundation.org/api/units/112381960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.527636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f619f51687ec1d16", "url": "https://translations.documentfoundation.org/api/units/112381961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.529447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8c8dd1301e1d17f5", "url": "https://translations.documentfoundation.org/api/units/112381962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.531301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5689b8d6694b2cb1", "url": "https://translations.documentfoundation.org/api/units/112381963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.533375Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d630c964f35f15ef", "url": "https://translations.documentfoundation.org/api/units/112381964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.535415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ab6695aac5ebdfbf", "url": "https://translations.documentfoundation.org/api/units/112381965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.537056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3dcb436a4bfbbc9b", "url": "https://translations.documentfoundation.org/api/units/112381966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.539105Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6790765d21a0f282", "url": "https://translations.documentfoundation.org/api/units/112381967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.540740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3ab4d572da869f0c", "url": "https://translations.documentfoundation.org/api/units/112381968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.541935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ac64899459492a10", "url": "https://translations.documentfoundation.org/api/units/112381969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.542997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1ab205bb7edd5c8b", "url": "https://translations.documentfoundation.org/api/units/112381970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.544334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ba6c6be1aba086f1", "url": "https://translations.documentfoundation.org/api/units/112381971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.545606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8864745036b9131c", "url": "https://translations.documentfoundation.org/api/units/112381972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.547148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d8c2b936c37786c9", "url": "https://translations.documentfoundation.org/api/units/112381973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.548835Z" } ] }