Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=85
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=86", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=84", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "POISSON(Number; Mean [; C])" ], "previous_source": "", "target": [ "" ], "id_hash": 8270841061222924725, "content_hash": 8270841061222924725, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3146093\nhelp.text", "note": "SH95D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99221123/?format=api", "priority": 100, "id": 99512079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f2c7ee1fd7e841b5", "url": "https://translations.documentfoundation.org/api/units/99512079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.868356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> represents the value based on which the Poisson distribution is calculated." ], "previous_source": "", "target": [ "<emph>Númberu</emph> representa'l valor nel que se basa pa calcular la distribución de Poisson." ], "id_hash": -211228542813314537, "content_hash": -211228542813314537, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3147253\nhelp.text", "note": "mZnNF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99221142/?format=api", "priority": 100, "id": 99512090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7d1190c26b306217", "url": "https://translations.documentfoundation.org/api/units/99512090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.892293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mean</emph> represents the middle value of the Poisson distribution." ], "previous_source": "", "target": [ "<emph>Media</emph> ye'l valor mediu de la distribución de Poisson." ], "id_hash": 367278264897600635, "content_hash": 367278264897600635, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3151177\nhelp.text", "note": "HEia5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99221151/?format=api", "priority": 100, "id": 99512096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8518d5a2d0f17c7b", "url": "https://translations.documentfoundation.org/api/units/99512096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.894957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>C</emph> (optional) = 0 or False calculates the density function; <emph>C</emph> = 1 or True calculates the distribution. When omitted, the default value True is inserted when you save the document, for best compatibility with other programs and older versions of %PRODUCTNAME." ], "previous_source": "", "target": [ "<emph>C</emph> (opcional) = 0 o Falsu calcula la función de densidá. <emph>C</emph> = 1 o Verdaderu calcula la distribución. Cuando s'omite, inxertar el valor predetermináu Verdaderu cuando guarda'l documentu, pa una mayor compatibilidá con otros programes y versiones anteriores de %PRODUCTNAME." ], "id_hash": 2606228162791925701, "content_hash": 2606228162791925701, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3149200\nhelp.text", "note": "C5Cg3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4204, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99221182/?format=api", "priority": 100, "id": 99512105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a42b2eb4a6d4e7c5", "url": "https://translations.documentfoundation.org/api/units/99512105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.898305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=POISSON(60;50;1)</item> returns 0.93." ], "previous_source": "", "target": [ "<item type=\"input\">=POISSON(60;50;1)</item> devuelve 0,93." ], "id_hash": -4143421195495158853, "content_hash": -4143421195495158853, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3150113\nhelp.text", "note": "bE3Ap", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4205, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99221201/?format=api", "priority": 100, "id": 99512111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=467f9c601fafcbbb", "url": "https://translations.documentfoundation.org/api/units/99512111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.901158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>POISSON.DIST function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>POISSON</bookmark_value>" ], "id_hash": 4241874588375339172, "content_hash": 4241874588375339172, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2953985\nhelp.text", "note": "sLFos", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4206, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221208/?format=api", "priority": 100, "id": 99512117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bade2a76b5de50a4", "url": "https://translations.documentfoundation.org/api/units/99512117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.903149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "POISSON.DIST" ], "previous_source": "", "target": [ "" ], "id_hash": -3142611479596618154, "content_hash": -3142611479596618154, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id2953985\nhelp.text", "note": "kEGyt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4207, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99221221/?format=api", "priority": 100, "id": 99512121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5463338273942e56", "url": "https://translations.documentfoundation.org/api/units/99512121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.905069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_POISSON_DIST_MS\">Returns the Poisson distribution.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_POISSON\">Devuelve la distribución de Poisson.</ahelp>" ], "id_hash": 6690457494760751156, "content_hash": 6690457494760751156, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954298\nhelp.text", "note": "Twq2U", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4208, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99221248/?format=api", "priority": 100, "id": 99512125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dcd947a4d8108034", "url": "https://translations.documentfoundation.org/api/units/99512125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.906722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4209, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99221280/?format=api", "priority": 100, "id": 99512130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d50112d3afde9cf6", "url": "https://translations.documentfoundation.org/api/units/99512130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.908659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> represents the value based on which the Poisson distribution is calculated." ], "previous_source": "", "target": [ "<emph>Númberu</emph> representa'l valor nel que se basa pa calcular la distribución de Poisson." ], "id_hash": -3367490303263467556, "content_hash": -3367490303263467556, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2947253\nhelp.text", "note": "jnjk7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4210, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99221292/?format=api", "priority": 100, "id": 99513092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51444569316897dc", "url": "https://translations.documentfoundation.org/api/units/99513092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:07.910218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mean</emph> represents the middle value of the Poisson distribution." ], "previous_source": "", "target": [ "<emph>Media</emph> ye'l valor mediu de la distribución de Poisson." ], "id_hash": -16936159792310714, "content_hash": -16936159792310714, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2951177\nhelp.text", "note": "EEfdC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4211, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99221312/?format=api", "priority": 100, "id": 99513105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7fc3d4a703b85646", "url": "https://translations.documentfoundation.org/api/units/99513105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.346815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99221333/?format=api", "priority": 100, "id": 99513113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d62872d2e6801c3c", "url": "https://translations.documentfoundation.org/api/units/99513113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.349922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=POISSON.DIST(60;50;1)</item> returns 0.9278398202." ], "previous_source": "", "target": [ "<item type=\"input\">=POISSON(60;50;1)</item> devuelve 0,93." ], "id_hash": 8171128373200612085, "content_hash": 8171128373200612085, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2950113\nhelp.text", "note": "gXFJQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4213, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99221359/?format=api", "priority": 100, "id": 99513119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f165adf682bceaf5", "url": "https://translations.documentfoundation.org/api/units/99513119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.351617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>PERCENTILE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>PERCENTIL</bookmark_value>" ], "id_hash": 3923502686117516349, "content_hash": 3923502686117516349, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id3153100\nhelp.text", "note": "n8dGY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/99221380/?format=api", "priority": 100, "id": 99513128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b67314e7c953543d", "url": "https://translations.documentfoundation.org/api/units/99513128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.353705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "PERCENTILE" ], "previous_source": "", "target": [ "PERCENTIL" ], "id_hash": -4361792145410424504, "content_hash": -4361792145410424504, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id3153100\nhelp.text", "note": "ofqnY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/99221398/?format=api", "priority": 100, "id": 99513137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4377cd274cb90148", "url": "https://translations.documentfoundation.org/api/units/99513137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.355538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<ahelp hid=\"HID_FUNC_QUANTIL\">devuelve'l alpha-percentil de los valores de datos nuna matriz.</ahelp> Un percentil devuelve la escala de valores pa una serie de datos que van dende'l valor más pequeñu (Alpha=0) al más altu (alpha=1) d'una serie. Para <item type=\"literal\">Alpha</item> = 25%, el percentil significa'l primera cuartil; <item type=\"literal\">Alpha</item> = 50% ye la MEDIANA." ], "id_hash": -8626921182456564982, "content_hash": -8626921182456564982, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154940\nhelp.text", "note": "fxFVH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4216, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/99221426/?format=api", "priority": 100, "id": 99513143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=084704e45662330a", "url": "https://translations.documentfoundation.org/api/units/99513143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.357271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "PERCENTILE(Data; Alpha)" ], "previous_source": "", "target": [ "PERCENTIL(Datos; Alpha)" ], "id_hash": 8138746938396365090, "content_hash": 8138746938396365090, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3148813\nhelp.text", "note": "6cfc9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4217, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221440/?format=api", "priority": 100, "id": 99513154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f0f2a33833e9d122", "url": "https://translations.documentfoundation.org/api/units/99513154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.359604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "<emph>Datos</emph> ye la matriz de los datos." ], "id_hash": -8350806221705068834, "content_hash": -8350806221705068834, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153054\nhelp.text", "note": "ErPqf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4218, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99221447/?format=api", "priority": 100, "id": 99513160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0c1bf9fc5f25bede", "url": "https://translations.documentfoundation.org/api/units/99513160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.361337Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "<emph>Alfa</emph> representa'l porcentaxe de la escala ente 0 y 1." ], "id_hash": 7950228473723534620, "content_hash": 7950228473723534620, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154212\nhelp.text", "note": "Ysdg6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4219, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99221478/?format=api", "priority": 100, "id": 99513169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ee54e2acbb7cbd1c", "url": "https://translations.documentfoundation.org/api/units/99513169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.363310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<item type=\"input\">=PERCENTIL(A1:A50;0,1)</item> representa'l valor nel grupu de datos, qu'equival al 10% de la escala de tolos datos conteníos n'A1:A50." ], "id_hash": -8459645673235737129, "content_hash": -8459645673235737129, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3159147\nhelp.text", "note": "Fv6gC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4220, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99221504/?format=api", "priority": 100, "id": 99513177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0a994d14d11d15d7", "url": "https://translations.documentfoundation.org/api/units/99513177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.365307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>PERCENTILE.EXC function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>PERCENTIL</bookmark_value>" ], "id_hash": 4471705444687519194, "content_hash": 4471705444687519194, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2853100\nhelp.text", "note": "zzrCV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4221, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221520/?format=api", "priority": 100, "id": 99513184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be0eb068eac79dda", "url": "https://translations.documentfoundation.org/api/units/99513184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.367407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99221551/?format=api", "priority": 100, "id": 99513192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6134b0d6bb219724", "url": "https://translations.documentfoundation.org/api/units/99513192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.369401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4223, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/99221580/?format=api", "priority": 100, "id": 99513200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f18b643c051e9447", "url": "https://translations.documentfoundation.org/api/units/99513200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.371086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4224, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/99221609/?format=api", "priority": 100, "id": 99513208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d4e980588883e266", "url": "https://translations.documentfoundation.org/api/units/99513208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.372947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4225, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99221644/?format=api", "priority": 100, "id": 99513212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9e1e694be36630e4", "url": "https://translations.documentfoundation.org/api/units/99513212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.374733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "PERCENTILE.EXC(Data; Alpha)" ], "previous_source": "", "target": [ "PERCENTIL(Datos; Alpha)" ], "id_hash": 1595963543340850716, "content_hash": 1595963543340850716, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2848813\nhelp.text", "note": "iu26H", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4226, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221671/?format=api", "priority": 100, "id": 99513216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=962600630b4e1e1c", "url": "https://translations.documentfoundation.org/api/units/99513216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.376408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "<emph>Datos</emph> ye la matriz de los datos." ], "id_hash": 9061709220377185746, "content_hash": 9061709220377185746, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2853054\nhelp.text", "note": "tVAsL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4227, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99221695/?format=api", "priority": 100, "id": 99513220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fdc1a8866276cdd2", "url": "https://translations.documentfoundation.org/api/units/99513220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.378083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "<emph>Alfa</emph> representa'l porcentaxe de la escala ente 0 y 1." ], "id_hash": -8212163281246065685, "content_hash": -8212163281246065685, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2854212\nhelp.text", "note": "mtefb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4228, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99221707/?format=api", "priority": 100, "id": 99513224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0e0889016fd26beb", "url": "https://translations.documentfoundation.org/api/units/99513224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.379957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<item type=\"input\">=PERCENTIL(A1:A50;0,1)</item> representa'l valor nel grupu de datos, qu'equival al 10% de la escala de tolos datos conteníos n'A1:A50." ], "id_hash": -2129669504215185233, "content_hash": -2129669504215185233, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2859147\nhelp.text", "note": "DEwyL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4229, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99221723/?format=api", "priority": 100, "id": 99513228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6271e4de904588af", "url": "https://translations.documentfoundation.org/api/units/99513228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.381919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>PERCENTILE.INC function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>PERCENTIL</bookmark_value>" ], "id_hash": 6678702316223762888, "content_hash": 6678702316223762888, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2953100\nhelp.text", "note": "CqovE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4230, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221745/?format=api", "priority": 100, "id": 99513237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dcaf845f0f1891c8", "url": "https://translations.documentfoundation.org/api/units/99513237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.384119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4231, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99221770/?format=api", "priority": 100, "id": 99513245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=76d427afa4f18648", "url": "https://translations.documentfoundation.org/api/units/99513245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.386052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<ahelp hid=\"HID_FUNC_QUANTIL\">devuelve'l alpha-percentil de los valores de datos nuna matriz.</ahelp> Un percentil devuelve la escala de valores pa una serie de datos que van dende'l valor más pequeñu (Alpha=0) al más altu (alpha=1) d'una serie. Para <item type=\"literal\">Alpha</item> = 25%, el percentil significa'l primera cuartil; <item type=\"literal\">Alpha</item> = 50% ye la MEDIANA." ], "id_hash": 6617444839219107397, "content_hash": 6617444839219107397, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954940\nhelp.text", "note": "PgcQ8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4232, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/99221805/?format=api", "priority": 100, "id": 99513252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dbd5e30542659645", "url": "https://translations.documentfoundation.org/api/units/99513252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.387746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4233, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99221832/?format=api", "priority": 100, "id": 99513258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=242b81379dfbd675", "url": "https://translations.documentfoundation.org/api/units/99513258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.390138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "PERCENTILE.INC(Data; Alpha)" ], "previous_source": "", "target": [ "PERCENTIL(Datos; Alpha)" ], "id_hash": -8496072928920097940, "content_hash": -8496072928920097940, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2948813\nhelp.text", "note": "LYbqG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4234, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221854/?format=api", "priority": 100, "id": 99513265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0a17e2af6de7ab6c", "url": "https://translations.documentfoundation.org/api/units/99513265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.391769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Data</emph> represents the array of data." ], "previous_source": "", "target": [ "<emph>Datos</emph> ye la matriz de los datos." ], "id_hash": -7925161987527602468, "content_hash": -7925161987527602468, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2953054\nhelp.text", "note": "QcWDU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4235, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99221876/?format=api", "priority": 100, "id": 99513270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=12042b2961fd0edc", "url": "https://translations.documentfoundation.org/api/units/99513270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.393497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Alpha</emph> represents the percentage of the scale between 0 and 1." ], "previous_source": "", "target": [ "<emph>Alfa</emph> representa'l porcentaxe de la escala ente 0 y 1." ], "id_hash": -5858961013010415096, "content_hash": -5858961013010415096, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2954212\nhelp.text", "note": "vspfD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4236, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99221899/?format=api", "priority": 100, "id": 99513277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2eb0ca0032a6c208", "url": "https://translations.documentfoundation.org/api/units/99513277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.395405Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<item type=\"input\">=PERCENTIL(A1:A50;0,1)</item> representa'l valor nel grupu de datos, qu'equival al 10% de la escala de tolos datos conteníos n'A1:A50." ], "id_hash": 5581925020991810539, "content_hash": 5581925020991810539, "location": "04060184.xhp", "context": "04060184.xhp\npar_id2959147\nhelp.text", "note": "TnH8L", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4237, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99221949/?format=api", "priority": 100, "id": 99513284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cd76fb3b7714ebeb", "url": "https://translations.documentfoundation.org/api/units/99513284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.397326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>PERCENTRANK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>RANGU.PERCENTIL</bookmark_value>" ], "id_hash": -8304208841152889585, "content_hash": -8304208841152889585, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id3148807\nhelp.text", "note": "odDob", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4238, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99221972/?format=api", "priority": 100, "id": 99513291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0cc1860e7a6c7d0f", "url": "https://translations.documentfoundation.org/api/units/99513291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.399410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "PERCENTRANK" ], "previous_source": "", "target": [ "RANGU.PERCENTIL" ], "id_hash": -8568581640314778216, "content_hash": -8568581640314778216, "location": "04060184.xhp", "context": "04060184.xhp\nhd_id3148807\nhelp.text", "note": "BuLHr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4239, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99221982/?format=api", "priority": 100, "id": 99513297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=091648657c1a8d98", "url": "https://translations.documentfoundation.org/api/units/99513297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.401546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Returns the percentage rank of a value in a sample.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_QUANTILSRANG\">Calcula'l rangu porcentual d'un valor nuna amosanza.</ahelp>" ], "id_hash": 6528706363372186268, "content_hash": 6528706363372186268, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3153573\nhelp.text", "note": "zvKoQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4240, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99222002/?format=api", "priority": 100, "id": 99513300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=da9a9fd8cfa1aa9c", "url": "https://translations.documentfoundation.org/api/units/99513300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.403293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4241, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99222024/?format=api", "priority": 100, "id": 99513305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e72f95dc3114400b", "url": "https://translations.documentfoundation.org/api/units/99513305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.405282Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Data</emph> represents the array of data in the sample." ], "previous_source": "", "target": [ "<emph>Datos</emph> ye la matriz de datos na amuesa." ], "id_hash": 1797147556220527232, "content_hash": 1797147556220527232, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3154266\nhelp.text", "note": "hPEyS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4242, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99222943/?format=api", "priority": 100, "id": 99513309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=98f0c02e417c6280", "url": "https://translations.documentfoundation.org/api/units/99513309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.406791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Value</emph> represents the value whose percentile rank must be determined." ], "previous_source": "", "target": [ "<emph>Valor</emph> representa'l valor pal que tien de determinase'l rangu de percentil." ], "id_hash": 8428595263578709330, "content_hash": 8428595263578709330, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3148475\nhelp.text", "note": "pmEDN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4243, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99222981/?format=api", "priority": 100, "id": 99513314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f4f862bc51261d52", "url": "https://translations.documentfoundation.org/api/units/99513314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.408759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4244, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99223012/?format=api", "priority": 100, "id": 99513318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=79cb6a0e338b6057", "url": "https://translations.documentfoundation.org/api/units/99513318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.410774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "<item type=\"input\">=RANGU.PERCENTIL(A1:A50;50)</item> devuelve'l rangu de porcentaxe del valor 50 a partir del rangu total de tolos valores que s'atopen n'A1:A50. Si 50 nun ta dientro del rangu total, va apaecer un mensaxe de fallu." ], "id_hash": 5791059669252951310, "content_hash": 5791059669252951310, "location": "04060184.xhp", "context": "04060184.xhp\npar_id3149163\nhelp.text", "note": "s6CE8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4245, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99223065/?format=api", "priority": 100, "id": 99513324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d05dfa163ae9cd0e", "url": "https://translations.documentfoundation.org/api/units/99513324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.412445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>PERCENTRANK.EXC function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>RANGU.PERCENTIL</bookmark_value>" ], "id_hash": -3208278317804395115, "content_hash": -3208278317804395115, "location": "04060184.xhp", "context": "04060184.xhp\nbm_id2848807\nhelp.text", "note": "ShkPW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4246, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99223099/?format=api", "priority": 100, "id": 99513330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5379e7de3eae6595", "url": "https://translations.documentfoundation.org/api/units/99513330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.414555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4247, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99223117/?format=api", "priority": 100, "id": 99513335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3b02b36796736ce9", "url": "https://translations.documentfoundation.org/api/units/99513335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.416512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4248, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99223151/?format=api", "priority": 100, "id": 99513342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=28361cd3fb29f53b", "url": "https://translations.documentfoundation.org/api/units/99513342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.418135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4249, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99223201/?format=api", "priority": 100, "id": 99513348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d5746af9e55d0cef", "url": "https://translations.documentfoundation.org/api/units/99513348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.419828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 4250, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99223225/?format=api", "priority": 100, "id": 99513355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7780fe695afe887a", "url": "https://translations.documentfoundation.org/api/units/99513355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:08.421470Z" } ] }