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=85
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=86", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=84", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 6690457494760751156, "content_hash": 6690457494760751156, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954298\nhelp.text", "note": "Twq2U", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111052205/?format=api", "priority": 100, "id": 112356557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dcd947a4d8108034", "url": "https://translations.documentfoundation.org/api/units/112356557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.383396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "POISSON.DIST(Number; Mean ; Cumulative)" ], "previous_source": "", "target": [ "" ], "id_hash": 6125197668598586614, "content_hash": 6125197668598586614, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2946093\nhelp.text", "note": "nVnxU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111052206/?format=api", "priority": 100, "id": 112356558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d50112d3afde9cf6", "url": "https://translations.documentfoundation.org/api/units/112356558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.384664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Number</emph> represents the value based on which the Poisson distribution is calculated." ], "previous_source": "", "target": [ "" ], "id_hash": -3367490303263467556, "content_hash": -3367490303263467556, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2947253\nhelp.text", "note": "jnjk7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111052207/?format=api", "priority": 100, "id": 112356559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=51444569316897dc", "url": "https://translations.documentfoundation.org/api/units/112356559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.385879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Mean</emph> represents the middle value of the Poisson distribution." ], "previous_source": "", "target": [ "" ], "id_hash": -16936159792310714, "content_hash": -16936159792310714, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2951177\nhelp.text", "note": "EEfdC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4204, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111052208/?format=api", "priority": 100, "id": 112356560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7fc3d4a703b85646", "url": "https://translations.documentfoundation.org/api/units/112356560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.387240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Cumulative</emph> = 0 or False to calculate the probability mass function; <emph>Cumulative</emph> = 1, True, or any other non-zero value to calculate the cumulative distribution function." ], "previous_source": "", "target": [ "" ], "id_hash": 6208338336466082876, "content_hash": 6208338336466082876, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2949200\nhelp.text", "note": "MiQ2K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4205, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111052209/?format=api", "priority": 100, "id": 112356561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d62872d2e6801c3c", "url": "https://translations.documentfoundation.org/api/units/112356561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.388623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=POISSON.DIST(60;50;1)</item> returns 0.9278398202." ], "previous_source": "", "target": [ "" ], "id_hash": 8171128373200612085, "content_hash": 8171128373200612085, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2950113\nhelp.text", "note": "gXFJQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4206, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111052210/?format=api", "priority": 100, "id": 112356562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f165adf682bceaf5", "url": "https://translations.documentfoundation.org/api/units/112356562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.389957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTILE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3923502686117516349, "content_hash": 3923502686117516349, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id3153100\nhelp.text", "note": "n8dGY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4207, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052211/?format=api", "priority": 100, "id": 112356563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b67314e7c953543d", "url": "https://translations.documentfoundation.org/api/units/112356563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.391451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE" ], "previous_source": "", "target": [ "" ], "id_hash": -4361792145410424504, "content_hash": -4361792145410424504, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id3153100\nhelp.text", "note": "ofqnY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4208, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111052212/?format=api", "priority": 100, "id": 112356564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4377cd274cb90148", "url": "https://translations.documentfoundation.org/api/units/112356564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.393146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUANTIL\">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <item type=\"literal\">Alpha</item> = 25%, the percentile means the first quartile; <item type=\"literal\">Alpha</item> = 50% is the MEDIAN." ], "previous_source": "", "target": [ "" ], "id_hash": -8626921182456564982, "content_hash": -8626921182456564982, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154940\nhelp.text", "note": "fxFVH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4209, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/111052213/?format=api", "priority": 100, "id": 112356565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=084704e45662330a", "url": "https://translations.documentfoundation.org/api/units/112356565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.395006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE(Data; Alpha)" ], "previous_source": "", "target": [ "" ], "id_hash": 8138746938396365090, "content_hash": 8138746938396365090, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3148813\nhelp.text", "note": "6cfc9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4210, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052214/?format=api", "priority": 100, "id": 112356566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f0f2a33833e9d122", "url": "https://translations.documentfoundation.org/api/units/112356566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.396523Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "" ], "id_hash": -8350806221705068834, "content_hash": -8350806221705068834, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153054\nhelp.text", "note": "ErPqf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4211, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111052215/?format=api", "priority": 100, "id": 112356567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0c1bf9fc5f25bede", "url": "https://translations.documentfoundation.org/api/units/112356567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.397982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "" ], "id_hash": 7950228473723534620, "content_hash": 7950228473723534620, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154212\nhelp.text", "note": "Ysdg6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111052216/?format=api", "priority": 100, "id": 112356568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ee54e2acbb7cbd1c", "url": "https://translations.documentfoundation.org/api/units/112356568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.399257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=PERCENTILE(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": -8459645673235737129, "content_hash": -8459645673235737129, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3159147\nhelp.text", "note": "Fv6gC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4213, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111052217/?format=api", "priority": 100, "id": 112356569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0a994d14d11d15d7", "url": "https://translations.documentfoundation.org/api/units/112356569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.400263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTILE.EXC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4471705444687519194, "content_hash": 4471705444687519194, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2853100\nhelp.text", "note": "zzrCV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4214, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052218/?format=api", "priority": 100, "id": 112356570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=be0eb068eac79dda", "url": "https://translations.documentfoundation.org/api/units/112356570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.401262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE.EXC" ], "previous_source": "", "target": [ "" ], "id_hash": -2218954280077781212, "content_hash": -2218954280077781212, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2853100\nhelp.text", "note": "YHgvC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4215, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111052224/?format=api", "priority": 100, "id": 112356571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6134b0d6bb219724", "url": "https://translations.documentfoundation.org/api/units/112356571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.402241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_PERCENTILE_EXC\">Returns the <item type=\"literal\">Alpha</item>'th percentile of a supplied range of values for a given value of <item type=\"literal\">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A percentile returns the scale value for a data series which goes from the smallest (<item type=\"literal\">Alpha=0</item>) to the largest value (<item type=\"literal\">Alpha=1</item>) of a data series. For <item type=\"literal\">Alpha</item> = 25%, the percentile means the first quartile; <item type=\"literal\">Alpha</item> = 50% is the MEDIAN." ], "previous_source": "", "target": [ "" ], "id_hash": 8181743356995343431, "content_hash": 8181743356995343431, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2854940\nhelp.text", "note": "nvtYH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4216, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/111052231/?format=api", "priority": 100, "id": 112356572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f18b643c051e9447", "url": "https://translations.documentfoundation.org/api/units/112356572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.403329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If <item type=\"literal\">Alpha</item> is not a multiple of <item type=\"literal\">1/(n+1)</item>, (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if <item type=\"literal\">Alpha</item> is less than <item type=\"literal\">1/(n+1)</item> or <item type=\"literal\">Alpha</item> is greater than <item type=\"literal\">n/(n+1)</item>, the function is unable to interpolate, and so returns an error." ], "previous_source": "", "target": [ "" ], "id_hash": 6118562686495351398, "content_hash": 6118562686495351398, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2754940\nhelp.text", "note": "88Eod", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4217, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/111052239/?format=api", "priority": 100, "id": 112356573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d4e980588883e266", "url": "https://translations.documentfoundation.org/api/units/112356573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.404418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": 2170287845097746660, "content_hash": 2170287845097746660, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2653976\nhelp.text", "note": "6oVxn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4218, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111052247/?format=api", "priority": 100, "id": 112356574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9e1e694be36630e4", "url": "https://translations.documentfoundation.org/api/units/112356574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.405504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE.EXC(Data; Alpha)" ], "previous_source": "", "target": [ "" ], "id_hash": 1595963543340850716, "content_hash": 1595963543340850716, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2848813\nhelp.text", "note": "iu26H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4219, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052248/?format=api", "priority": 100, "id": 112356575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=962600630b4e1e1c", "url": "https://translations.documentfoundation.org/api/units/112356575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.406513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "" ], "id_hash": 9061709220377185746, "content_hash": 9061709220377185746, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2853054\nhelp.text", "note": "tVAsL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4220, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111052284/?format=api", "priority": 100, "id": 112356576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fdc1a8866276cdd2", "url": "https://translations.documentfoundation.org/api/units/112356576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.407545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "" ], "id_hash": -8212163281246065685, "content_hash": -8212163281246065685, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2854212\nhelp.text", "note": "mtefb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4221, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111052312/?format=api", "priority": 100, "id": 112356577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0e0889016fd26beb", "url": "https://translations.documentfoundation.org/api/units/112356577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.409060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=PERCENTILE.EXC(A1:A50;10%)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": -2129669504215185233, "content_hash": -2129669504215185233, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2859147\nhelp.text", "note": "DEwyL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111052313/?format=api", "priority": 100, "id": 112356578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6271e4de904588af", "url": "https://translations.documentfoundation.org/api/units/112356578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.411919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTILE.INC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6678702316223762888, "content_hash": 6678702316223762888, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2953100\nhelp.text", "note": "CqovE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4223, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052314/?format=api", "priority": 100, "id": 112356579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dcaf845f0f1891c8", "url": "https://translations.documentfoundation.org/api/units/112356579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.415812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE.INC" ], "previous_source": "", "target": [ "" ], "id_hash": -660859609976568248, "content_hash": -660859609976568248, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2953100\nhelp.text", "note": "CjvFy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4224, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111052368/?format=api", "priority": 100, "id": 112356580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=76d427afa4f18648", "url": "https://translations.documentfoundation.org/api/units/112356580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.418623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_PERCENTILE_INC\">Returns the alpha-percentile of data values in an array.</ahelp> A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For <item type=\"literal\">Alpha</item> = 25%, the percentile means the first quartile; <item type=\"literal\">Alpha</item> = 50% is the MEDIAN." ], "previous_source": "", "target": [ "" ], "id_hash": 6617444839219107397, "content_hash": 6617444839219107397, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954940\nhelp.text", "note": "PgcQ8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4225, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/111052393/?format=api", "priority": 100, "id": 112356581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dbd5e30542659645", "url": "https://translations.documentfoundation.org/api/units/112356581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.420438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The difference between <item type=\"input\">PERCENTILE.INC</item> and <item type=\"input\">PERCENTILE.EXC</item> is that, in the <item type=\"input\">PERCENTILE.INC</item> function the value of alpha is within the range 0 to 1 inclusive, and in the <item type=\"input\">PERCENTILE.EXC</item> function, the value of alpha is within the range 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": -6617053151617100171, "content_hash": -6617053151617100171, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2753976\nhelp.text", "note": "oLxJG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4226, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111052404/?format=api", "priority": 100, "id": 112356582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=242b81379dfbd675", "url": "https://translations.documentfoundation.org/api/units/112356582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.422109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTILE.INC(Data; Alpha)" ], "previous_source": "", "target": [ "" ], "id_hash": -8496072928920097940, "content_hash": -8496072928920097940, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2948813\nhelp.text", "note": "LYbqG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4227, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111052922/?format=api", "priority": 100, "id": 112356583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0a17e2af6de7ab6c", "url": "https://translations.documentfoundation.org/api/units/112356583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.423663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "" ], "id_hash": -7925161987527602468, "content_hash": -7925161987527602468, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2953054\nhelp.text", "note": "QcWDU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4228, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111052961/?format=api", "priority": 100, "id": 112356584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=12042b2961fd0edc", "url": "https://translations.documentfoundation.org/api/units/112356584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.424953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "" ], "id_hash": -5858961013010415096, "content_hash": -5858961013010415096, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954212\nhelp.text", "note": "vspfD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4229, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111052983/?format=api", "priority": 100, "id": 112356585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2eb0ca0032a6c208", "url": "https://translations.documentfoundation.org/api/units/112356585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.426295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=PERCENTILE.INC(A1:A50;0.1)</item> represents the value in the data set, which equals 10% of the total data scale in A1:A50." ], "previous_source": "", "target": [ "" ], "id_hash": 5581925020991810539, "content_hash": 5581925020991810539, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2959147\nhelp.text", "note": "TnH8L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4230, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111052997/?format=api", "priority": 100, "id": 112356586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cd76fb3b7714ebeb", "url": "https://translations.documentfoundation.org/api/units/112356586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.427512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTRANK function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8304208841152889585, "content_hash": -8304208841152889585, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id3148807\nhelp.text", "note": "odDob", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4231, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053029/?format=api", "priority": 100, "id": 112356587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0cc1860e7a6c7d0f", "url": "https://translations.documentfoundation.org/api/units/112356587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.428732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTRANK" ], "previous_source": "", "target": [ "" ], "id_hash": -8568581640314778216, "content_hash": -8568581640314778216, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id3148807\nhelp.text", "note": "BuLHr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4232, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111053053/?format=api", "priority": 100, "id": 112356588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=091648657c1a8d98", "url": "https://translations.documentfoundation.org/api/units/112356588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.429805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Returns the percentage rank of a value in a sample.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 6528706363372186268, "content_hash": 6528706363372186268, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153573\nhelp.text", "note": "zvKoQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4233, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111053070/?format=api", "priority": 100, "id": 112356589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=da9a9fd8cfa1aa9c", "url": "https://translations.documentfoundation.org/api/units/112356589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.430818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTRANK(Data; Value [; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": 7435326282760732683, "content_hash": 7435326282760732683, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3147238\nhelp.text", "note": "AAjBU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4234, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111053071/?format=api", "priority": 100, "id": 112356590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e72f95dc3114400b", "url": "https://translations.documentfoundation.org/api/units/112356590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.431823Z" }, { "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": 1797147556220527232, "content_hash": 1797147556220527232, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154266\nhelp.text", "note": "hPEyS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4235, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111053108/?format=api", "priority": 100, "id": 112356591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=98f0c02e417c6280", "url": "https://translations.documentfoundation.org/api/units/112356591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.432792Z" }, { "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": 8428595263578709330, "content_hash": 8428595263578709330, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3148475\nhelp.text", "note": "pmEDN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4236, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111053138/?format=api", "priority": 100, "id": 112356592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f4f862bc51261d52", "url": "https://translations.documentfoundation.org/api/units/112356592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.433806Z" }, { "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. If omitted, a value of 3 is used." ], "previous_source": "", "target": [ "" ], "id_hash": -447147128766373801, "content_hash": -447147128766373801, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2748477\nhelp.text", "note": "dfAfa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4237, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/111053169/?format=api", "priority": 100, "id": 112356593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=79cb6a0e338b6057", "url": "https://translations.documentfoundation.org/api/units/112356593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.434835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=PERCENTRANK(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": 5791059669252951310, "content_hash": 5791059669252951310, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3149163\nhelp.text", "note": "s6CE8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4238, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111053205/?format=api", "priority": 100, "id": 112356594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d05dfa163ae9cd0e", "url": "https://translations.documentfoundation.org/api/units/112356594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.435882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTRANK.EXC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3208278317804395115, "content_hash": -3208278317804395115, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2848807\nhelp.text", "note": "ShkPW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4239, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053222/?format=api", "priority": 100, "id": 112356595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5379e7de3eae6595", "url": "https://translations.documentfoundation.org/api/units/112356595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.436915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTRANK.EXC" ], "previous_source": "", "target": [ "" ], "id_hash": -4971213781176455959, "content_hash": -4971213781176455959, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2848807\nhelp.text", "note": "z5iwA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4240, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111053259/?format=api", "priority": 100, "id": 112356596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3b02b36796736ce9", "url": "https://translations.documentfoundation.org/api/units/112356596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.437893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_PERCENTRANK_EXC\"> Returns the relative position, between 0 and 1 (exclusive), of a specified value within a supplied array.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6325836929817774789, "content_hash": -6325836929817774789, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2853573\nhelp.text", "note": "kXmRd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4241, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111053260/?format=api", "priority": 100, "id": 112356597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=28361cd3fb29f53b", "url": "https://translations.documentfoundation.org/api/units/112356597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.438895Z" }, { "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": 6157664212049792239, "content_hash": 6157664212049792239, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2553976\nhelp.text", "note": "SiK26", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4242, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/111053281/?format=api", "priority": 100, "id": 112356598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d5746af9e55d0cef", "url": "https://translations.documentfoundation.org/api/units/112356598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.439927Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTRANK.EXC(Data; Value [; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": -612209820870735750, "content_hash": -612209820870735750, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2847238\nhelp.text", "note": "FFw3f", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4243, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111053308/?format=api", "priority": 100, "id": 112356599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7780fe695afe887a", "url": "https://translations.documentfoundation.org/api/units/112356599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.440951Z" }, { "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": -2983615292199581087, "content_hash": -2983615292199581087, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2854266\nhelp.text", "note": "paUED", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4244, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111053313/?format=api", "priority": 100, "id": 112356600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=569811b31a054a61", "url": "https://translations.documentfoundation.org/api/units/112356600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.441928Z" }, { "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": 8414091118051856094, "content_hash": 8414091118051856094, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2848475\nhelp.text", "note": "aRW4r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4245, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111053332/?format=api", "priority": 100, "id": 112356601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f4c4db4ac7400ede", "url": "https://translations.documentfoundation.org/api/units/112356601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.442890Z" }, { "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": -6523575295548667096, "content_hash": -6523575295548667096, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2748475\nhelp.text", "note": "mCBKk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4246, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111053353/?format=api", "priority": 100, "id": 112356602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=25779ad5034ecb28", "url": "https://translations.documentfoundation.org/api/units/112356602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.444697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=PERCENTRANK.EXC(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": -5334454780290849341, "content_hash": -5334454780290849341, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2849163\nhelp.text", "note": "rFP7K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4247, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/111053377/?format=api", "priority": 100, "id": 112356603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=35f835a3f66125c3", "url": "https://translations.documentfoundation.org/api/units/112356603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.445697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>PERCENTRANK.INC function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4060864033586719557, "content_hash": -4060864033586719557, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2948807\nhelp.text", "note": "owuKF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4248, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111053409/?format=api", "priority": 100, "id": 112356604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=47a4e9ad44e754bb", "url": "https://translations.documentfoundation.org/api/units/112356604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.446845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "PERCENTRANK.INC" ], "previous_source": "", "target": [ "" ], "id_hash": -6681253807711995678, "content_hash": -6681253807711995678, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2948807\nhelp.text", "note": "PGEyz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4249, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111053437/?format=api", "priority": 100, "id": 112356605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=23476b0f8919b8e2", "url": "https://translations.documentfoundation.org/api/units/112356605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.451833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_PERCENTRANK_INC\">Returns the relative position, between 0 and 1 (inclusive), of a specified value within a supplied array.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 7807075531408204726, "content_hash": 7807075531408204726, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2953573\nhelp.text", "note": "zYCJE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4250, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111053457/?format=api", "priority": 100, "id": 112356606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ec584dd5083ae3b6", "url": "https://translations.documentfoundation.org/api/units/112356606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:22.452860Z" } ] }{ "count": 8439, "next": "