Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=85
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=86", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=84", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=dcd947a4d8108034", "url": "https://translations.documentfoundation.org/api/units/112381874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.368963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d50112d3afde9cf6", "url": "https://translations.documentfoundation.org/api/units/112381875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.370695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=51444569316897dc", "url": "https://translations.documentfoundation.org/api/units/112381876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.373076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7fc3d4a703b85646", "url": "https://translations.documentfoundation.org/api/units/112381877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.374860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d62872d2e6801c3c", "url": "https://translations.documentfoundation.org/api/units/112381878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.376821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f165adf682bceaf5", "url": "https://translations.documentfoundation.org/api/units/112381879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.378848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b67314e7c953543d", "url": "https://translations.documentfoundation.org/api/units/112381880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.380605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4377cd274cb90148", "url": "https://translations.documentfoundation.org/api/units/112381881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.382653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=084704e45662330a", "url": "https://translations.documentfoundation.org/api/units/112381882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.384744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f0f2a33833e9d122", "url": "https://translations.documentfoundation.org/api/units/112381883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.386890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0c1bf9fc5f25bede", "url": "https://translations.documentfoundation.org/api/units/112381884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.388939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ee54e2acbb7cbd1c", "url": "https://translations.documentfoundation.org/api/units/112381885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.391002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0a994d14d11d15d7", "url": "https://translations.documentfoundation.org/api/units/112381886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.393179Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=be0eb068eac79dda", "url": "https://translations.documentfoundation.org/api/units/112381887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.395280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6134b0d6bb219724", "url": "https://translations.documentfoundation.org/api/units/112381888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.397216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f18b643c051e9447", "url": "https://translations.documentfoundation.org/api/units/112381889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.398624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d4e980588883e266", "url": "https://translations.documentfoundation.org/api/units/112381890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.400247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9e1e694be36630e4", "url": "https://translations.documentfoundation.org/api/units/112381891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.401865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=962600630b4e1e1c", "url": "https://translations.documentfoundation.org/api/units/112381892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.403130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=fdc1a8866276cdd2", "url": "https://translations.documentfoundation.org/api/units/112381893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.404806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0e0889016fd26beb", "url": "https://translations.documentfoundation.org/api/units/112381894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.406783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6271e4de904588af", "url": "https://translations.documentfoundation.org/api/units/112381895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.408989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=dcaf845f0f1891c8", "url": "https://translations.documentfoundation.org/api/units/112381896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.411185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=76d427afa4f18648", "url": "https://translations.documentfoundation.org/api/units/112381897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.413103Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=dbd5e30542659645", "url": "https://translations.documentfoundation.org/api/units/112381898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.415925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=242b81379dfbd675", "url": "https://translations.documentfoundation.org/api/units/112381899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.417732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0a17e2af6de7ab6c", "url": "https://translations.documentfoundation.org/api/units/112381900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.419285Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=12042b2961fd0edc", "url": "https://translations.documentfoundation.org/api/units/112381901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.420710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=2eb0ca0032a6c208", "url": "https://translations.documentfoundation.org/api/units/112381902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.422468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=cd76fb3b7714ebeb", "url": "https://translations.documentfoundation.org/api/units/112381903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.424155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0cc1860e7a6c7d0f", "url": "https://translations.documentfoundation.org/api/units/112381904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.426119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=091648657c1a8d98", "url": "https://translations.documentfoundation.org/api/units/112381905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.428130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=da9a9fd8cfa1aa9c", "url": "https://translations.documentfoundation.org/api/units/112381906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.429730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e72f95dc3114400b", "url": "https://translations.documentfoundation.org/api/units/112381907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.430965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112381908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=98f0c02e417c6280", "url": "https://translations.documentfoundation.org/api/units/112381908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.432380Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112381909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f4f862bc51261d52", "url": "https://translations.documentfoundation.org/api/units/112381909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.434199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to. 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": 112381910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=79cb6a0e338b6057", "url": "https://translations.documentfoundation.org/api/units/112381910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.436155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d05dfa163ae9cd0e", "url": "https://translations.documentfoundation.org/api/units/112381911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.438743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5379e7de3eae6595", "url": "https://translations.documentfoundation.org/api/units/112381912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.440814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3b02b36796736ce9", "url": "https://translations.documentfoundation.org/api/units/112381913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.442203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=28361cd3fb29f53b", "url": "https://translations.documentfoundation.org/api/units/112381914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.443442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "The difference between <item type=\"input\">PERCENTRANK.INC</item> and <item type=\"input\">PERCENTRANK.EXC</item> is that <item type=\"input\">PERCENTRANK.INC</item> calculates a value in the range 0 to 1 inclusive, whereas the <item type=\"input\">PERCENTRANK.EXC</item> function calculates a value in the range 0 to 1 exclusive." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112381915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d5746af9e55d0cef", "url": "https://translations.documentfoundation.org/api/units/112381915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.444705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7780fe695afe887a", "url": "https://translations.documentfoundation.org/api/units/112381916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.446084Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 112381917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=569811b31a054a61", "url": "https://translations.documentfoundation.org/api/units/112381917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.447609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 112381918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f4c4db4ac7400ede", "url": "https://translations.documentfoundation.org/api/units/112381918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.449246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Significance</emph> An optional argument that specifies the number of significant digits that the returned percentage value is rounded to." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 112381919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=25779ad5034ecb28", "url": "https://translations.documentfoundation.org/api/units/112381919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.451125Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=35f835a3f66125c3", "url": "https://translations.documentfoundation.org/api/units/112381920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.454574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=47a4e9ad44e754bb", "url": "https://translations.documentfoundation.org/api/units/112381921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.458348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=23476b0f8919b8e2", "url": "https://translations.documentfoundation.org/api/units/112381922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.460264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112381923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ec584dd5083ae3b6", "url": "https://translations.documentfoundation.org/api/units/112381923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:35.462178Z" } ] }{ "count": 8439, "next": "