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/hsb/units/?format=api&page=86
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=87", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=85", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1149ce01ec0fa58b", "url": "https://translations.documentfoundation.org/api/units/112356607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.453889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356608, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ad0f57d2329842be", "url": "https://translations.documentfoundation.org/api/units/112356608/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.454922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4b20c1d36c0375c6", "url": "https://translations.documentfoundation.org/api/units/112356609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.455911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0727baffe2ec2d68", "url": "https://translations.documentfoundation.org/api/units/112356610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.456876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=596e74edd8ed83c8", "url": "https://translations.documentfoundation.org/api/units/112356611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.457856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fd8991fe67240d9f", "url": "https://translations.documentfoundation.org/api/units/112356612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.458917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bb2bb8e4f5daedf4", "url": "https://translations.documentfoundation.org/api/units/112356613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.459930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ab2a20790b09d12b", "url": "https://translations.documentfoundation.org/api/units/112356614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.460899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=62d7e1772aa7e9eb", "url": "https://translations.documentfoundation.org/api/units/112356615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.461875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b221ff270003ead1", "url": "https://translations.documentfoundation.org/api/units/112356616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.462864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4d971e7963c8656c", "url": "https://translations.documentfoundation.org/api/units/112356617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.463873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6161b7a458a95795", "url": "https://translations.documentfoundation.org/api/units/112356618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.464842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5695910b0a6819c1", "url": "https://translations.documentfoundation.org/api/units/112356619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.465834Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d2e1eafcca1eab58", "url": "https://translations.documentfoundation.org/api/units/112356620/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.466867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=988b4642e78865a9", "url": "https://translations.documentfoundation.org/api/units/112356621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.467839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=27a861372c9a3190", "url": "https://translations.documentfoundation.org/api/units/112356622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.468828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f0010d16d27ece6f", "url": "https://translations.documentfoundation.org/api/units/112356623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.469853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356624, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9e7dd2b71a7a00d6", "url": "https://translations.documentfoundation.org/api/units/112356624/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.470884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3e52062ffeab40cd", "url": "https://translations.documentfoundation.org/api/units/112356625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.471880Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2067814b0e10f91f", "url": "https://translations.documentfoundation.org/api/units/112356626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.472873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fc1e0d7862656597", "url": "https://translations.documentfoundation.org/api/units/112356627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.473870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b5bb5dd9066b7434", "url": "https://translations.documentfoundation.org/api/units/112356628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.474857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f899fe061cb449f9", "url": "https://translations.documentfoundation.org/api/units/112356629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.475827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=631b6c2e803e559f", "url": "https://translations.documentfoundation.org/api/units/112356630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.476792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c26243b33cd494ac", "url": "https://translations.documentfoundation.org/api/units/112356631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.477798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=53ef3d71e281ee3c", "url": "https://translations.documentfoundation.org/api/units/112356632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.478905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6b932a67475bdc4b", "url": "https://translations.documentfoundation.org/api/units/112356633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.479897Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c006f79a43498707", "url": "https://translations.documentfoundation.org/api/units/112356634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.480877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=72850801b599ebba", "url": "https://translations.documentfoundation.org/api/units/112356635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.481864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0d5fbd09a8f163e0", "url": "https://translations.documentfoundation.org/api/units/112356636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.482874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bf77d77c27020892", "url": "https://translations.documentfoundation.org/api/units/112356637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.483857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5ceb02cb99875d65", "url": "https://translations.documentfoundation.org/api/units/112356638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.484827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=91f91c637377b17e", "url": "https://translations.documentfoundation.org/api/units/112356639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.485842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3398a7b1aee3208c", "url": "https://translations.documentfoundation.org/api/units/112356640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.486821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d7cd5e9199d3bd3e", "url": "https://translations.documentfoundation.org/api/units/112356641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.487825Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ecb8c51ac68cf5ef", "url": "https://translations.documentfoundation.org/api/units/112356642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.488783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ceb36f15f540dff1", "url": "https://translations.documentfoundation.org/api/units/112356643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.489756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f619f51687ec1d16", "url": "https://translations.documentfoundation.org/api/units/112356644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.490719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8c8dd1301e1d17f5", "url": "https://translations.documentfoundation.org/api/units/112356645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.491674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5689b8d6694b2cb1", "url": "https://translations.documentfoundation.org/api/units/112356646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.492642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d630c964f35f15ef", "url": "https://translations.documentfoundation.org/api/units/112356647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.493665Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ab6695aac5ebdfbf", "url": "https://translations.documentfoundation.org/api/units/112356648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.494657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3dcb436a4bfbbc9b", "url": "https://translations.documentfoundation.org/api/units/112356649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.495663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6790765d21a0f282", "url": "https://translations.documentfoundation.org/api/units/112356650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.496638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3ab4d572da869f0c", "url": "https://translations.documentfoundation.org/api/units/112356651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.497657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ac64899459492a10", "url": "https://translations.documentfoundation.org/api/units/112356652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.498655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1ab205bb7edd5c8b", "url": "https://translations.documentfoundation.org/api/units/112356653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.499618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ba6c6be1aba086f1", "url": "https://translations.documentfoundation.org/api/units/112356654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.500575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8864745036b9131c", "url": "https://translations.documentfoundation.org/api/units/112356655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.501519Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112356656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d8c2b936c37786c9", "url": "https://translations.documentfoundation.org/api/units/112356656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.502463Z" } ] }