Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=85
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=86", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=84", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dcd947a4d8108034", "url": "https://translations.documentfoundation.org/api/units/112432508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.210468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d50112d3afde9cf6", "url": "https://translations.documentfoundation.org/api/units/112432509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.211740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51444569316897dc", "url": "https://translations.documentfoundation.org/api/units/112432510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.213291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7fc3d4a703b85646", "url": "https://translations.documentfoundation.org/api/units/112432511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.214750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d62872d2e6801c3c", "url": "https://translations.documentfoundation.org/api/units/112432512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.215883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f165adf682bceaf5", "url": "https://translations.documentfoundation.org/api/units/112432513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.216953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b67314e7c953543d", "url": "https://translations.documentfoundation.org/api/units/112432514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.218044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4377cd274cb90148", "url": "https://translations.documentfoundation.org/api/units/112432515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.219019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=084704e45662330a", "url": "https://translations.documentfoundation.org/api/units/112432516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.220657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f0f2a33833e9d122", "url": "https://translations.documentfoundation.org/api/units/112432517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.222549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0c1bf9fc5f25bede", "url": "https://translations.documentfoundation.org/api/units/112432518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.224295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ee54e2acbb7cbd1c", "url": "https://translations.documentfoundation.org/api/units/112432519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.226321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0a994d14d11d15d7", "url": "https://translations.documentfoundation.org/api/units/112432520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.227924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=be0eb068eac79dda", "url": "https://translations.documentfoundation.org/api/units/112432521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.229262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6134b0d6bb219724", "url": "https://translations.documentfoundation.org/api/units/112432522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.230727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f18b643c051e9447", "url": "https://translations.documentfoundation.org/api/units/112432523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.232798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d4e980588883e266", "url": "https://translations.documentfoundation.org/api/units/112432524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.234651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9e1e694be36630e4", "url": "https://translations.documentfoundation.org/api/units/112432525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.236411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=962600630b4e1e1c", "url": "https://translations.documentfoundation.org/api/units/112432526/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.237646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fdc1a8866276cdd2", "url": "https://translations.documentfoundation.org/api/units/112432527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.239041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0e0889016fd26beb", "url": "https://translations.documentfoundation.org/api/units/112432528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.240559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6271e4de904588af", "url": "https://translations.documentfoundation.org/api/units/112432529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.241923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dcaf845f0f1891c8", "url": "https://translations.documentfoundation.org/api/units/112432530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.243606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=76d427afa4f18648", "url": "https://translations.documentfoundation.org/api/units/112432531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.245954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432532, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dbd5e30542659645", "url": "https://translations.documentfoundation.org/api/units/112432532/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.247335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432533, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=242b81379dfbd675", "url": "https://translations.documentfoundation.org/api/units/112432533/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.248901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0a17e2af6de7ab6c", "url": "https://translations.documentfoundation.org/api/units/112432534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.250631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=12042b2961fd0edc", "url": "https://translations.documentfoundation.org/api/units/112432535/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.252290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2eb0ca0032a6c208", "url": "https://translations.documentfoundation.org/api/units/112432536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.253863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cd76fb3b7714ebeb", "url": "https://translations.documentfoundation.org/api/units/112432537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.255356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0cc1860e7a6c7d0f", "url": "https://translations.documentfoundation.org/api/units/112432538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.257102Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=091648657c1a8d98", "url": "https://translations.documentfoundation.org/api/units/112432539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.258389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=da9a9fd8cfa1aa9c", "url": "https://translations.documentfoundation.org/api/units/112432540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.259445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e72f95dc3114400b", "url": "https://translations.documentfoundation.org/api/units/112432541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.260414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112432542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=98f0c02e417c6280", "url": "https://translations.documentfoundation.org/api/units/112432542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.261323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112432543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f4f862bc51261d52", "url": "https://translations.documentfoundation.org/api/units/112432543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.262257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. 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": 112432544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=79cb6a0e338b6057", "url": "https://translations.documentfoundation.org/api/units/112432544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.263469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d05dfa163ae9cd0e", "url": "https://translations.documentfoundation.org/api/units/112432545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.264746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5379e7de3eae6595", "url": "https://translations.documentfoundation.org/api/units/112432546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.266279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432547, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3b02b36796736ce9", "url": "https://translations.documentfoundation.org/api/units/112432547/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.267694Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=28361cd3fb29f53b", "url": "https://translations.documentfoundation.org/api/units/112432548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.269114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112432549, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d5746af9e55d0cef", "url": "https://translations.documentfoundation.org/api/units/112432549/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.270506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7780fe695afe887a", "url": "https://translations.documentfoundation.org/api/units/112432550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.271872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 112432551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=569811b31a054a61", "url": "https://translations.documentfoundation.org/api/units/112432551/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.272904Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112432552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f4c4db4ac7400ede", "url": "https://translations.documentfoundation.org/api/units/112432552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.273891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 112432553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=25779ad5034ecb28", "url": "https://translations.documentfoundation.org/api/units/112432553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.275769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432554, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=35f835a3f66125c3", "url": "https://translations.documentfoundation.org/api/units/112432554/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.278680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=47a4e9ad44e754bb", "url": "https://translations.documentfoundation.org/api/units/112432555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.281057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=23476b0f8919b8e2", "url": "https://translations.documentfoundation.org/api/units/112432556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.282538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112432557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ec584dd5083ae3b6", "url": "https://translations.documentfoundation.org/api/units/112432557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:10.283691Z" } ] }