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/es/units/?format=api&page=13
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DMIN" ], "previous_source": "", "target": [ "BDMIN" ], "id_hash": 6315401607782341768, "content_hash": 6315401607782341768, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3159141\nhelp.text", "note": "iGV4a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099443/?format=api", "priority": 100, "id": 100424609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d7a4d04d45cc1c88", "url": "https://translations.documentfoundation.org/api/units/100424609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.808602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMIN\">DMIN calculates the minimum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBMIN\">BDMIN calcula el valor mínimo en todas las celdas (campos) de la columna especificada que contienen valores numéricos, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> No se incluyen las celdas en blanco ni las que contienen caracteres no numéricos." ], "id_hash": -2182869194426701095, "content_hash": -2182869194426701095, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154261\nhelp.text", "note": "kv5Gb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99099469/?format=api", "priority": 100, "id": 100424612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=61b4e408730daad9", "url": "https://translations.documentfoundation.org/api/units/100424612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.809583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se encuentran coincidencias o si no hay valores numéricos distintos de cero en las celdas de la columna especificada para los registros coincidentes." ], "id_hash": -7088825732426253501, "content_hash": -7088825732426253501, "location": "04060101.xhp", "context": "04060101.xhp\npar_id901616180605426\nhelp.text", "note": "yYJTa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99099506/?format=api", "priority": 100, "id": 100424616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1d9f6e8df815bb43", "url": "https://translations.documentfoundation.org/api/units/100424616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.810862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DMIN(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDMIN(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)" ], "id_hash": -2365212603741018146, "content_hash": -2365212603741018146, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148479\nhelp.text", "note": "QxBsV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099513/?format=api", "priority": 100, "id": 100424619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5f2d13ab17bd67de", "url": "https://translations.documentfoundation.org/api/units/100424619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.811867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">0\" (este criterio de búsqueda pretende coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": -2901804372218614756, "content_hash": -2901804372218614756, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148925\nhelp.text", "note": "p4YQB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099558/?format=api", "priority": 100, "id": 100424622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=57bab84c423bec1c", "url": "https://translations.documentfoundation.org/api/units/100424622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.812845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDMIN(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la distancia mínima en metros que recorre cualquiera de los invitados a la fiesta de Joe hasta la escuela. Nos devolverá el valor 150." ], "id_hash": 4931777981835359673, "content_hash": 4931777981835359673, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149161\nhelp.text", "note": "LrfjC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99099566/?format=api", "priority": 100, "id": 100424625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c47131f1de63b5b9", "url": "https://translations.documentfoundation.org/api/units/100424625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.814070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BDPROMEDIO</bookmark_value><bookmark_value>promedios; en bases de datos Calc</bookmark_value><bookmark_value>cálculo; medias en bases de datos Calc</bookmark_value>" ], "id_hash": -2870387606319136727, "content_hash": -2870387606319136727, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154274\nhelp.text", "note": "XEu9j", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99099609/?format=api", "priority": 100, "id": 100424629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/100424629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.815271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DAVERAGE" ], "previous_source": "", "target": [ "BDPROMEDIO" ], "id_hash": 8325687557178170627, "content_hash": 8325687557178170627, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154274\nhelp.text", "note": "dQciw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099666/?format=api", "priority": 100, "id": 100424632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f38ac8b8cc7e9d03", "url": "https://translations.documentfoundation.org/api/units/100424632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.816381Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">DAVERAGE calculates the average of the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values in those cells are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">BDPROMEDIO calcula la media de los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos de esas celdas deben ser ignorados." ], "id_hash": -1578848825274792703, "content_hash": -1578848825274792703, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3166453\nhelp.text", "note": "Y7wdv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99099686/?format=api", "priority": 100, "id": 100424635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6a16cd5bc7740501", "url": "https://translations.documentfoundation.org/api/units/100424635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.817286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns a #DIV/0! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve un error #¡DIV/0! si ningún registro coincide con los criterios de búsqueda especificados, o si no hay valores numéricos en las celdas de la columna especificada para los registros coincidentes." ], "id_hash": 7303987702708060116, "content_hash": 7303987702708060116, "location": "04060101.xhp", "context": "04060101.xhp\npar_id31615978739452\nhelp.text", "note": "87qxe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99099714/?format=api", "priority": 100, "id": 100424638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e55cfa1e0fbc3fd4", "url": "https://translations.documentfoundation.org/api/units/100424638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.818546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DAVERAGE(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDPROMEDIO(Base de datos; Campo de base de datos; Criterios de búsqueda)" ], "id_hash": 6939834441930249975, "content_hash": 6939834441930249975, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150710\nhelp.text", "note": "PPkBD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099758/?format=api", "priority": 100, "id": 100424641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e04f3ea7f74616f7", "url": "https://translations.documentfoundation.org/api/units/100424641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.819571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de la base de datos de ejemplo que proporciona información sobre los invitados a la fiesta de cumpleaños de Juan (descrita anteriormente) debe situarse en las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico a las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, a excepción de la celda D13 que debe contener «>0» (este criterio de búsqueda tiene como objetivo hacer coincidir todos los registros en la tabla de la base de datos)." ], "id_hash": 6372245985782288987, "content_hash": 6372245985782288987, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149104\nhelp.text", "note": "PcjTP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099776/?format=api", "priority": 100, "id": 100424644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d86ec3f663f6525b", "url": "https://translations.documentfoundation.org/api/units/100424644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.820530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned." ], "previous_source": "", "target": [ "Introduzca la fórmula <input>=BDPROMEDIO(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular la distancia media en metros recorrida hasta la escuela por los invitados a la fiesta de Joe. Se obtendrá el valor 666,67." ], "id_hash": 1814434218395281006, "content_hash": 1814434218395281006, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201616368312277\nhelp.text", "note": "CjTGB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99099814/?format=api", "priority": 100, "id": 100424650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=992e2a4eefc3a66e", "url": "https://translations.documentfoundation.org/api/units/100424650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.934104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDPRODUCTO</bookmark_value><bookmark_value>multiplicar;contenido de celda en bases de datos de Calc</bookmark_value>" ], "id_hash": 8547260052556627769, "content_hash": 8547260052556627769, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159269\nhelp.text", "note": "6fcFr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99099823/?format=api", "priority": 100, "id": 100424654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/100424654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.941990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DPRODUCT" ], "previous_source": "", "target": [ "BDPRODUCTO" ], "id_hash": 3613951182874316910, "content_hash": 3613951182874316910, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3159269\nhelp.text", "note": "gvW9Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099854/?format=api", "priority": 100, "id": 100424657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b22755740ad3906e", "url": "https://translations.documentfoundation.org/api/units/100424657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.943928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT calculates the product of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBPRODUKT\">BDPRODUCTO calcula el producto de todos los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> No se incluyen las celdas en blanco ni las que contienen caracteres no numéricos." ], "id_hash": -6870910731368740162, "content_hash": -6870910731368740162, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152879\nhelp.text", "note": "oJApo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99099882/?format=api", "priority": 100, "id": 100424660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=20a59f17ed58cabe", "url": "https://translations.documentfoundation.org/api/units/100424660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.945410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes." ], "id_hash": -6088134275114650130, "content_hash": -6088134275114650130, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616180868336\nhelp.text", "note": "oUsZD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99099899/?format=api", "priority": 100, "id": 100424664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2b829a2212e935ee", "url": "https://translations.documentfoundation.org/api/units/100424664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.947619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DPRODUCT(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDPRODUCTO(BaseDeDatos; CampoBaseDeDatos; CriteriosDeBúsqueda)" ], "id_hash": -2550060692960315488, "content_hash": -2550060692960315488, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154854\nhelp.text", "note": "PgAsj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099923/?format=api", "priority": 100, "id": 100424667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5c9c5d4f8069f7a0", "url": "https://translations.documentfoundation.org/api/units/100424667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.949507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda C13, que debe contener \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": 6697853395288567308, "content_hash": 6697853395288567308, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148986\nhelp.text", "note": "oGQtm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099937/?format=api", "priority": 100, "id": 100424671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=dcf38e2d1fd1ae0c", "url": "https://translations.documentfoundation.org/api/units/100424671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.951286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDPRODUCTO(A1:E10; \"Antigüedad\"; A12:E13)</input> en una celda vacía de la hoja para calcular el producto de las edades en años de los invitados a la fiesta de Joe. Nos dará el valor 279417600." ], "id_hash": -4597042588880741787, "content_hash": -4597042588880741787, "location": "04060101.xhp", "context": "04060101.xhp\npar_id91616368981807\nhelp.text", "note": "iaoUA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99099960/?format=api", "priority": 100, "id": 100424675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4034061f206bda65", "url": "https://translations.documentfoundation.org/api/units/100424675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.953330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BDDESVEST</bookmark_value><bookmark_value>desviaciones típicas en bases de datos; basadas en una muestra</bookmark_value>" ], "id_hash": 8527548628645799969, "content_hash": 8527548628645799969, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148462\nhelp.text", "note": "KsVCV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99100000/?format=api", "priority": 100, "id": 100424679, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/100424679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.955446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSTDEV" ], "previous_source": "", "target": [ "BDDESVEST" ], "id_hash": 3411649162921893682, "content_hash": 3411649162921893682, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3148462\nhelp.text", "note": "EvGNP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100031/?format=api", "priority": 100, "id": 100424683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=af589cd68637df32", "url": "https://translations.documentfoundation.org/api/units/100424683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.957526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the sample standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBSTDABW\">BDDESVEST calcula la desviación estándar de la muestra basándose en los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coincidan con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos deben ignorarse." ], "id_hash": -1613820941292791608, "content_hash": -1613820941292791608, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154605\nhelp.text", "note": "56CsG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100058/?format=api", "priority": 100, "id": 100424686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=699a8e677f2818c8", "url": "https://translations.documentfoundation.org/api/units/100424686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.959166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve un error #¡NUM! si un registro coincide exactamente con los criterios de búsqueda especificados, o si solo hay un valor numérico en las celdas de la columna especificada para los registros coincidentes." ], "id_hash": 8749639485209474966, "content_hash": 8749639485209474966, "location": "04060101.xhp", "context": "04060101.xhp\npar_id121616181037440\nhelp.text", "note": "RACag", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99100082/?format=api", "priority": 100, "id": 100424689, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f96cf6c114a47796", "url": "https://translations.documentfoundation.org/api/units/100424689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.961503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes." ], "id_hash": -2977119669398935399, "content_hash": -2977119669398935399, "location": "04060101.xhp", "context": "04060101.xhp\npar_id931616181041535\nhelp.text", "note": "r6onB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99100120/?format=api", "priority": 100, "id": 100424693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=56af256f23a5e899", "url": "https://translations.documentfoundation.org/api/units/100424693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.963504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSTDEV(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDDSTDEV(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)" ], "id_hash": -2597026079391988949, "content_hash": -2597026079391988949, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148661\nhelp.text", "note": "GgdKD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100173/?format=api", "priority": 100, "id": 100424696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5bf5828a596a432b", "url": "https://translations.documentfoundation.org/api/units/100424696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.965305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Debe asegurarse que las celdas A13:D13 estén en blanco y que la celda E13 contenga \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": 3273024958610690874, "content_hash": 3273024958610690874, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149934\nhelp.text", "note": "q4kzs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/99100203/?format=api", "priority": 100, "id": 100424700, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/100424700/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.967185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDDESVEST(A1:E10; \"Peso\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular la desviación estándar muestral de los pesos en kg de los invitados a la fiesta de Joe. Nos devolverá el valor 5,5." ], "id_hash": 3932075065911071924, "content_hash": 3932075065911071924, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150630\nhelp.text", "note": "SXqfH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100243/?format=api", "priority": 100, "id": 100424704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/100424704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.969283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BDDESVESTP</bookmark_value><bookmark_value>desviaciones típicas en bases de datos;basadas en poblaciones</bookmark_value>" ], "id_hash": 3090290711562855157, "content_hash": 3090290711562855157, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150429\nhelp.text", "note": "VRXXy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99100273/?format=api", "priority": 100, "id": 100424707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/100424707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.970764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSTDEVP" ], "previous_source": "", "target": [ "BDDESVESTP" ], "id_hash": -3363240082687938335, "content_hash": -3363240082687938335, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150429\nhelp.text", "note": "FpESx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100310/?format=api", "priority": 100, "id": 100424711, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=51535ef6c907b0e1", "url": "https://translations.documentfoundation.org/api/units/100424711/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.972255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">BDDESVESTP calcula la desviación estándar de la población basándose en los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coincidan con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos se ignoran." ], "id_hash": -1359803832062133205, "content_hash": -1359803832062133205, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145598\nhelp.text", "note": "Cfkn3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100375/?format=api", "priority": 100, "id": 100424714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/100424714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.973399Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve el error #¡NUM! si no se corresponde ningún registro con los criterios de búsqueda dados o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes." ], "id_hash": -5674625038366763722, "content_hash": -5674625038366763722, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541616181205698\nhelp.text", "note": "TjThw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99100449/?format=api", "priority": 100, "id": 100424717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/100424717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.974799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSTDEVP(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDDESVESTP(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)" ], "id_hash": -6317791940157661886, "content_hash": -6317791940157661886, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149484\nhelp.text", "note": "uGaWp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100475/?format=api", "priority": 100, "id": 100424721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2852b1b41a139d42", "url": "https://translations.documentfoundation.org/api/units/100424721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.975926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Debe asegurarse de que las celdas A13:D13 estén en blanco y que la celda E13 contenga \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": -3178976914139084068, "content_hash": -3178976914139084068, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155431\nhelp.text", "note": "jm7Bx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/99100569/?format=api", "priority": 100, "id": 100424724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/100424724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.977007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned." ], "previous_source": "", "target": [ "Inserte la fórmula <input>=BDESVESTP(A1:E10; \"Peso\"; A12:E13)</input> en una celda vacía en otra parte de la hoja para calcular la desviación típica de población de los pesos en kilogramos de los invitados a la fiesta de Juan. Devolverá el valor 5,18545." ], "id_hash": -5195435835451844799, "content_hash": -5195435835451844799, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148411\nhelp.text", "note": "6eisL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100587/?format=api", "priority": 100, "id": 100424728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/100424728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.978319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDSUMA</bookmark_value><bookmark_value>calcular;sumas en bases de datos de Calc</bookmark_value><bookmark_value>sumas;celdas en bases de datos de Calc</bookmark_value>" ], "id_hash": 571292261639023166, "content_hash": 571292261639023166, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154794\nhelp.text", "note": "Z2CTY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99100693/?format=api", "priority": 100, "id": 100424733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/100424733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.979594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSUM" ], "previous_source": "", "target": [ "BDSUMA" ], "id_hash": 6500722574647928150, "content_hash": 6500722574647928150, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154794\nhelp.text", "note": "ybMg9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100730/?format=api", "priority": 100, "id": 100424737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=da3734bd4540a556", "url": "https://translations.documentfoundation.org/api/units/100424737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.980693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">BDSUMA calcula la suma de todos los valores numéricos en las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Las celdas en blanco o celdas que contienen caracteres no numéricos no están incluidas." ], "id_hash": -7238116556220802580, "content_hash": -7238116556220802580, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149591\nhelp.text", "note": "pqV9N", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99100761/?format=api", "priority": 100, "id": 100424741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/100424741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.982448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes." ], "id_hash": -2425954765439131674, "content_hash": -2425954765439131674, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691616181332088\nhelp.text", "note": "PEAvG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99100767/?format=api", "priority": 100, "id": 100424744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/100424744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.983870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DSUM(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDSUM(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)" ], "id_hash": 4014294215559015126, "content_hash": 4014294215559015126, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150989\nhelp.text", "note": "LD8jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100768/?format=api", "priority": 100, "id": 100424747, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b7b5a352064cead6", "url": "https://translations.documentfoundation.org/api/units/100424747/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.985188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da la información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": 5806862272351628538, "content_hash": 5806862272351628538, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152766\nhelp.text", "note": "G9FsG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99100769/?format=api", "priority": 100, "id": 100424750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/100424750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.986396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDSUMA(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la distancia total en metros que recorren todos los invitados a la fiesta de Joe hasta la escuela. Nos devolverá el valor 6000." ], "id_hash": 1895489060518919853, "content_hash": 1895489060518919853, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151312\nhelp.text", "note": "riVB4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100770/?format=api", "priority": 100, "id": 100424754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/100424754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.987962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDVAR</bookmark_value><bookmark_value>varianzas; basadas en muestras</bookmark_value>" ], "id_hash": -8976625786291172676, "content_hash": -8976625786291172676, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3155614\nhelp.text", "note": "YBFb7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99100771/?format=api", "priority": 100, "id": 100424758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/100424758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.989770Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DVAR" ], "previous_source": "", "target": [ "BDVAR" ], "id_hash": -8231158565170443628, "content_hash": -8231158565170443628, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3155614\nhelp.text", "note": "G6ZBW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100778/?format=api", "priority": 100, "id": 100424761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0dc50ce5411a0a94", "url": "https://translations.documentfoundation.org/api/units/100424761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.991345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">BDVAR calcula la varianza de la muestra en función de los valores numéricos en las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos son ignorados." ], "id_hash": 7397650893937352998, "content_hash": 7397650893937352998, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154418\nhelp.text", "note": "QN7LU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100938/?format=api", "priority": 100, "id": 100424765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/100424765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.992695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve un error #¡NUM! si un registro coincide exactamente con los criterios de búsqueda especificados, o si solo hay un valor numérico en las celdas de la columna especificada para los registros coincidentes." ], "id_hash": -358442623195869881, "content_hash": -358442623195869881, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181465164\nhelp.text", "note": "yytCQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99100981/?format=api", "priority": 100, "id": 100424769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/100424769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.994501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes." ], "id_hash": -8110133978835548470, "content_hash": -8110133978835548470, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616181469136\nhelp.text", "note": "gW4LZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99101030/?format=api", "priority": 100, "id": 100424771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/100424771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.995790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DVAR(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDVAR(Base de Datos; Campo de la Base de Datos; Criterios de búsqueda)" ], "id_hash": 5531771093627333732, "content_hash": 5531771093627333732, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156138\nhelp.text", "note": "hLSuf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99101084/?format=api", "priority": 100, "id": 100424773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ccc4cc80466e6c64", "url": "https://translations.documentfoundation.org/api/units/100424773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.996779Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Debe asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": -2778539481399798989, "content_hash": -2778539481399798989, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153701\nhelp.text", "note": "TyAAP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99101123/?format=api", "priority": 100, "id": 100424775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/100424775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.997710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDVAR(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la varianza muestral de las distancias en metros que los invitados a la fiesta de Joe recorren hasta la escuela. Nos devolverá el valor 193125." ], "id_hash": -3271768490011218818, "content_hash": -3271768490011218818, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153676\nhelp.text", "note": "bRDWF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99101162/?format=api", "priority": 100, "id": 100424778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/100424778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:43.999049Z" } ] }