Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/units/?format=api&page=131
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 615, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527543/?format=api", "priority": 100, "id": 45531021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/45531021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.722323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 616, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527544/?format=api", "priority": 100, "id": 45531022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/45531022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.723517Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 619, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527546/?format=api", "priority": 100, "id": 45531024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/45531024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.726939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527547/?format=api", "priority": 100, "id": 45531025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/45531025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.728055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 622, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527548/?format=api", "priority": 100, "id": 45531026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/45531026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.730471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527549/?format=api", "priority": 100, "id": 45531027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/45531027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.731619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/45527551/?format=api", "priority": 100, "id": 45531029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/45531029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.735057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527552/?format=api", "priority": 100, "id": 45531030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/45531030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.736185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 629, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527553/?format=api", "priority": 100, "id": 45531031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/45531031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.738553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 630, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527554/?format=api", "priority": 100, "id": 45531032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/45531032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.739713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527556/?format=api", "priority": 100, "id": 45531034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/45531034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.743149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/45527557/?format=api", "priority": 100, "id": 45531035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/45531035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.744268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527558/?format=api", "priority": 100, "id": 45531036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/45531036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.745377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 637, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527559/?format=api", "priority": 100, "id": 45531037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/45531037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.747763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 638, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527560/?format=api", "priority": 100, "id": 45531038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/45531038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.748940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation 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_DBVARIANZEN\">BDVARP calcula la variación 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 deben ignorarse." ], "id_hash": 167854092933931965, "content_hash": 167854092933931965, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155119\nhelp.text", "note": "nfgrg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 641, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527562/?format=api", "priority": 100, "id": 45531040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/45531040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.752776Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 5472297574716727343, "content_hash": 5472297574716727343, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181648263\nhelp.text", "note": "ERRmG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527563/?format=api", "priority": 100, "id": 45531041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/45531041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.754217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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 hacer coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": -8514566768429089441, "content_hash": -8514566768429089441, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147099\nhelp.text", "note": "STcMa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527564/?format=api", "priority": 100, "id": 45531042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=09d62ea2df703d5f", "url": "https://translations.documentfoundation.org/api/units/45531042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.757376Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DVARP(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the population variance of the distances in meters that Joe’s party guests travel to school. The value 171666.67 is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDVARP(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía en otra parte de la hoja para encontrar la varianza poblacional de las distancias en metros que los invitados a la fiesta de Joe recorren hasta la escuela. Obtenemos el valor 171666,67." ], "id_hash": 544007683892511232, "content_hash": 544007683892511232, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147322\nhelp.text", "note": "8puR2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 645, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527565/?format=api", "priority": 100, "id": 45531043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=878cb41b317f0200", "url": "https://translations.documentfoundation.org/api/units/45531043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:01.759105Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_FEST\">Nos devuelve un número como texto con un número especificado de decimales y separadores de miles opcionales.</ahelp>" ], "id_hash": 4564917541115818924, "content_hash": 4564917541115818924, "location": "04060110.xhp", "context": "04060110.xhp\npar_id641617285271044\nhelp.text", "note": "k4v7r", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2309, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45547896/?format=api", "priority": 100, "id": 45548239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bf59d851532873ac", "url": "https://translations.documentfoundation.org/api/units/45548239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.217356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])" ], "previous_source": "", "target": [ "FIJO(Número; [Decimales = 2 [; Sin separadores de miles = FALSo]])" ], "id_hash": 3164445034953640442, "content_hash": 3164445034953640442, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3147567\nhelp.text", "note": "vGkWA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2310, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547897/?format=api", "priority": 100, "id": 45548240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=abea5dfe4ba909fa", "url": "https://translations.documentfoundation.org/api/units/45548240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.218880Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Decimals</emph> (optional) refers to the number of decimal places to be displayed. If <literal>Decimals</literal> is negative, <literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places to the left from the decimal point. If <literal>Decimals</literal> is a fraction, it is truncated actually ignoring what is the closest integer." ], "previous_source": "", "target": [ "<emph>Decimales</emph> (opcional) se refiere al número de decimales que se mostrarán. Si <literal>Decimales</literal> es negativo, <literal>Número</literal> se redondea a ABS(<literal>Decimales</literal>) lugares a la izquierda del punto decimal. Si <literal>Decimales</literal> es una fracción, se trunca realmente ignorando cuál es el entero más cercano." ], "id_hash": -5788830311505226717, "content_hash": -5788830311505226717, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3156322\nhelp.text", "note": "5zSz5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2312, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/45547899/?format=api", "priority": 100, "id": 45548242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2fa9f18091b79423", "url": "https://translations.documentfoundation.org/api/units/45548242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.221495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FIJO(123456.789;VERDADERO)</item>nos devuelve 123456.79 como cadena de texto." ], "id_hash": -2868271223510780221, "content_hash": -2868271223510780221, "location": "04060110.xhp", "context": "04060110.xhp\npar_id5282143\nhelp.text", "note": "eo6wB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2315, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547901/?format=api", "priority": 100, "id": 45548244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5831da84db2a36c3", "url": "https://translations.documentfoundation.org/api/units/45548244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.224856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FIJO(12345,6789;-2)</item> devuelve 12 300 como una cadena de texto." ], "id_hash": 4714624350173270364, "content_hash": 4714624350173270364, "location": "04060110.xhp", "context": "04060110.xhp\npar_id21617202293406\nhelp.text", "note": "U8QaS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547902/?format=api", "priority": 100, "id": 45548245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c16db5de097c115c", "url": "https://translations.documentfoundation.org/api/units/45548245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.226147Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FIJO(12134567.89;-3;1)</item> devuelve 12135000 como una cadena de texto." ], "id_hash": -6001427891539983682, "content_hash": -6001427891539983682, "location": "04060110.xhp", "context": "04060110.xhp\npar_id161617202295558\nhelp.text", "note": "iqSth", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547903/?format=api", "priority": 100, "id": 45548246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2cb6a5212ba342be", "url": "https://translations.documentfoundation.org/api/units/45548246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.227394Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FIJO(12345.789;3/4)</item> devuelve 12,346 como una cadena de texto." ], "id_hash": -300381556576810427, "content_hash": -300381556576810427, "location": "04060110.xhp", "context": "04060110.xhp\npar_id451617286696878\nhelp.text", "note": "NmXWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547904/?format=api", "priority": 100, "id": 45548247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7bd4d490d7290a45", "url": "https://translations.documentfoundation.org/api/units/45548247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:41.228897Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">ecuación IM.COT</alt></image>" ], "id_hash": 2870055230817627947, "content_hash": 2870055230817627947, "location": "func_imcot.xhp", "context": "func_imcot.xhp\npar_id311713256011430\nhelp.text", "note": "fCe4Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549690/?format=api", "priority": 100, "id": 45549989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a7d47c06b6a2ef2b", "url": "https://translations.documentfoundation.org/api/units/45549989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.058386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">ecuación IM.CSC</alt></image>" ], "id_hash": 6846648871920688632, "content_hash": 6846648871920688632, "location": "func_imcsc.xhp", "context": "func_imcsc.xhp\npar_id13510198901485\nhelp.text", "note": "FV9Gz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549691/?format=api", "priority": 100, "id": 45549990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=df042edfb8a95df8", "url": "https://translations.documentfoundation.org/api/units/45549990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.068552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">ecuación IM.CSCH</alt></image>" ], "id_hash": -4113507468801013442, "content_hash": -4113507468801013442, "location": "func_imcsch.xhp", "context": "func_imcsch.xhp\npar_id195151657917534\nhelp.text", "note": "FFqZK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549692/?format=api", "priority": 100, "id": 45549991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=46e9e2c05d33093e", "url": "https://translations.documentfoundation.org/api/units/45549991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.082155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">ecuación IM.SEC</alt></image>" ], "id_hash": -1400137934339393315, "content_hash": -1400137934339393315, "location": "func_imsec.xhp", "context": "func_imsec.xhp\npar_id17543461310594\nhelp.text", "note": "y62eA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549693/?format=api", "priority": 100, "id": 45549992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6c91b5f78b26b8dd", "url": "https://translations.documentfoundation.org/api/units/45549992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.091177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">ecuación IM.SECH</alt></image>" ], "id_hash": -5814494115358634925, "content_hash": -5814494115358634925, "location": "func_imsech.xhp", "context": "func_imsech.xhp\npar_id74572850718840\nhelp.text", "note": "CVDgc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549694/?format=api", "priority": 100, "id": 45549993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2f4ec46899730c53", "url": "https://translations.documentfoundation.org/api/units/45549993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.099675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">Ecuación IM.TAN</alt></image>" ], "id_hash": -166417047733024562, "content_hash": -166417047733024562, "location": "func_imtan.xhp", "context": "func_imtan.xhp\npar_id25021317131239\nhelp.text", "note": "ujidB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549695/?format=api", "priority": 100, "id": 45549994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7db0c493a94dc8ce", "url": "https://translations.documentfoundation.org/api/units/45549994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:55.124251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>BDCONTAR función</bookmark_value><bookmark_value>recuento de filas;con valores numéricos</bookmark_value>" ], "id_hash": -4283882863480380764, "content_hash": -4283882863480380764, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150882\nhelp.text", "note": "KBZPC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 559, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612149/?format=api", "priority": 100, "id": 45624235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/45624235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.764552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDCONTARA</bookmark_value><bookmark_value>registros; conteo en bases de datos Calc</bookmark_value><bookmark_value>contar filas; con valores numéricos o alfanuméricos</bookmark_value>" ], "id_hash": -1670587375212033188, "content_hash": -1670587375212033188, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3156123\nhelp.text", "note": "tGFyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 566, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612150/?format=api", "priority": 100, "id": 45624236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/45624236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.774908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDEXTRAER</bookmark_value><bookmark_value>contenido de las celdas; búsqueda en bases de datos Calc</bookmark_value><bookmark_value>búsqueda; contenido de las celdas en bases de datos Calc</bookmark_value>" ], "id_hash": 746247400884686976, "content_hash": 746247400884686976, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3147256\nhelp.text", "note": "GasLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 573, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612151/?format=api", "priority": 100, "id": 45624237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/45624237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.785881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BDMAX</bookmark_value><bookmark_value>valores máximos en bases de datos de Calc</bookmark_value><bookmark_value>buscar;valores máximos en columnas</bookmark_value>" ], "id_hash": 6067482821286383874, "content_hash": 6067482821286383874, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3149766\nhelp.text", "note": "rB9Ek", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612152/?format=api", "priority": 100, "id": 45624238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d434077aa38f5102", "url": "https://translations.documentfoundation.org/api/units/45624238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.798406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDMIN</bookmark_value><bookmark_value>valores mínimos en bases de datos de Calc</bookmark_value><bookmark_value>búsqueda;valores mínimos en columnas</bookmark_value>" ], "id_hash": -7229204091064779011, "content_hash": -7229204091064779011, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159141\nhelp.text", "note": "CnaXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612153/?format=api", "priority": 100, "id": 45624239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1bacb52e5f487efd", "url": "https://translations.documentfoundation.org/api/units/45624239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.807815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 595, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612154/?format=api", "priority": 100, "id": 45624240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/45624240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.818637Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/45612155/?format=api", "priority": 100, "id": 45624241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/45624241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.828844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612156/?format=api", "priority": 100, "id": 45624242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/45624242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.839786Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45612157/?format=api", "priority": 100, "id": 45624243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/45624243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.851899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612158/?format=api", "priority": 100, "id": 45624244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/45624244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.861841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 631, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612159/?format=api", "priority": 100, "id": 45624245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/45624245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.872682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDVARP</bookmark_value><bookmark_value>varianzas;basadas en poblaciones</bookmark_value>" ], "id_hash": -1507646871452132173, "content_hash": -1507646871452132173, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3153880\nhelp.text", "note": "7FWS4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612160/?format=api", "priority": 100, "id": 45624246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6b13c328845ddcb3", "url": "https://translations.documentfoundation.org/api/units/45624246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:23.884291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función comprueba si un valor específico está contenido en la primera columna de una matriz. La función devuelve entonces el valor en la misma fila de la columna nombrada por <emph>Indice</emph>. Si el parámetro <emph>Ordenado</emph> se omite o se pone a VERDADERO o a uno, se supone que los datos están ordenados de forma ascendente. En este caso, si no se encuentra la <emph>Búsqueda</emph> exacta, se devolverá el último valor que sea menor que el criterio. Si <emph>Ordenado</emph> se establece en FALSO o en cero, se debe encontrar una coincidencia exacta, de lo contrario se producirá el error <emph>Error: Valor no disponible</emph> será el resultado. Por lo tanto, con un valor de cero no es necesario ordenar los datos en orden ascendente." ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2061, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/45612171/?format=api", "priority": 100, "id": 45624247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/45624247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.049333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "=BUSCARV(Búsqueda; Matriz; Índice [; Búsqueda por intervalos ordenados])" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2062, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612172/?format=api", "priority": 100, "id": 45624248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/45624248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.051154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." ], "previous_source": "", "target": [ "<emph>Buscar</emph> es el valor de cualquier tipo buscado en la primera columna de la matriz." ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2063, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612173/?format=api", "priority": 100, "id": 45624249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/45624249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.052642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "<emph>Búsqueda por intervalos ordenados</emph> es un parámetro opcional que indica si la primera columna de la matriz contiene límites de intervalo en lugar de valores simples. En este modo, la búsqueda devuelve el valor de la fila cuya primera columna tiene un valor igual o menor que <emph>Búsqueda</emph>. Por ejemplo, podría contener fechas en las que se ha modificado algún valor fiscal, por lo que los valores representan fechas de inicio de un período en el que un valor fiscal específico estuvo vigente. Así, la búsqueda de una fecha ausente en la primera columna de la matriz, pero que cae entre algunas fechas límite existentes, daría la más baja de ellas, permitiendo encontrar los datos vigentes a la fecha buscada. Introduzca el valor booleano FALSO o cero si la primera columna no es una lista de límites del intervalo. Cuando este parámetro es VERDADERO o no se indica, la primera columna de la matriz <emph>debe estar ordenada de forma ascendente</emph>. Las columnas ordenadas se pueden buscar mucho más rápido y la función siempre devuelve un valor, aunque el valor de búsqueda no haya coincidido exactamente, si es mayor que el valor más bajo de la lista ordenada. En las listas no ordenadas, el valor de búsqueda debe coincidir exactamente. En caso contrario, la función devolverá #N/A con el mensaje <emph>Error: Valor no disponible</emph>." ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2066, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/45612174/?format=api", "priority": 100, "id": 45624250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/45624250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.056873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "COINCIDIR(Búsqueda; Matriz de búsqueda [; Tipo])" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612175/?format=api", "priority": 100, "id": 45624251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/45624251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.091151Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "<emph>Búsqueda</emph> es el valor que se buscará en la matriz de una sola fila o de una sola columna." ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612176/?format=api", "priority": 100, "id": 45624252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/45624252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:27.092617Z" } ] }