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=104
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=105", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=103", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "ROUNDSIG Function" ], "previous_source": "", "target": [ "Función REDONDEAR.PRECISION" ], "id_hash": -4682470879403904726, "content_hash": -4682470879403904726, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\ntit\nhelp.text", "note": "E7heY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951644/?format=api", "priority": 100, "id": 1511994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3f04858b4204f12a", "url": "https://translations.documentfoundation.org/api/units/1511994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.773196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>ROUNDSIG Function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función REDONDEAR.PRECISION</bookmark_value>" ], "id_hash": -5080785759558406640, "content_hash": -5080785759558406640, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\nbm_id151519154954070\nhelp.text", "note": "XV5Md", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951645/?format=api", "priority": 100, "id": 1511995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=397d6c4555a86e10", "url": "https://translations.documentfoundation.org/api/units/1511995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.783333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"roundsig\"><ahelp hid=\"HID_FUNC_ROUNDSIG\">Returns a number rounded to a specified number of significant decimal digits of its normalized floating point notation.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"roundsig\"><ahelp hid=\"HID_FUNC_ROUNDSIG\">Devuelve un número redondeado a una cantidad especificada de decimales de significatividad de su notación de coma flotante normalizada.</ahelp></variable>" ], "id_hash": -2015948536282137256, "content_hash": -2015948536282137256, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id921519154702177\nhelp.text", "note": "jJKBA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24951647/?format=api", "priority": 100, "id": 1511997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6405e97cb96f3d58", "url": "https://translations.documentfoundation.org/api/units/1511997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.807418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "ROUNDSIG( Value; Digits )" ], "previous_source": "", "target": [ "REDONDEAR.PRECISION( Valor; Dígitos )" ], "id_hash": -2458713796018075462, "content_hash": -2458713796018075462, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id291519155534115\nhelp.text", "note": "3EaJu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24951648/?format=api", "priority": 100, "id": 1511998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5de0e4d44ffd88ba", "url": "https://translations.documentfoundation.org/api/units/1511998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.821194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Value</emph>: the number to be rounded." ], "previous_source": "", "target": [ "<emph>Valor</emph>: el número que se debe redondear." ], "id_hash": 2448997303185349572, "content_hash": 2448997303185349572, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id51519155217204\nhelp.text", "note": "BBtjx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951649/?format=api", "priority": 100, "id": 1511999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a1fc961268409bc4", "url": "https://translations.documentfoundation.org/api/units/1511999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.836687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Digits</emph>: the number of decimal places to round." ], "previous_source": "", "target": [ "<emph>Dígitos</emph>: la cantidad de decimales que se redondearán." ], "id_hash": -8436917948603987566, "content_hash": -8436917948603987566, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id321519155209912\nhelp.text", "note": "cKLrn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24951650/?format=api", "priority": 100, "id": 1512000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0aea0bd392578992", "url": "https://translations.documentfoundation.org/api/units/1512000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.857135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Digits</emph> must be an integer greater than 0." ], "previous_source": "", "target": [ "<emph>Dígitos</emph> debe ser un entero mayor que 0." ], "id_hash": -1195489761785759652, "content_hash": -1195489761785759652, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id371519155264297\nhelp.text", "note": "ZuCEG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24951651/?format=api", "priority": 100, "id": 1512001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6f68c4654824b85c", "url": "https://translations.documentfoundation.org/api/units/1512001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.870434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROUNDSIG(123.456789; 5)</item> returns 123.46." ], "previous_source": "", "target": [ "<item type=\"input\">=REDONDEAR.PRECISION(123,456789; 5)</item> devuelve 123,46." ], "id_hash": 3283091708226823545, "content_hash": 3283091708226823545, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id691519155470333\nhelp.text", "note": "FRBcJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24951652/?format=api", "priority": 100, "id": 1512002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ad8fe28399e3e579", "url": "https://translations.documentfoundation.org/api/units/1512002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.885035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROUNDSIG(0.000123456789; 5)</item> returns 0.00012346" ], "previous_source": "", "target": [ "<item type=\"input\">REDONDEAR.PRECISION(0.000123456789; 5)</item>regresa 0.00012346" ], "id_hash": 2365580962568831879, "content_hash": 2365580962568831879, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id821519155475673\nhelp.text", "note": "23DRM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24951653/?format=api", "priority": 100, "id": 1512003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a0d43b5a21578387", "url": "https://translations.documentfoundation.org/api/units/1512003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.900046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROUNDSIG(123456789012345; 2)</item> returns 1.2E14" ], "previous_source": "", "target": [ "<item type=\"input\">=REDONDEAR.PRECISION</item> devuelve1.2E14" ], "id_hash": -5864696166076615367, "content_hash": -5864696166076615367, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id381519155481234\nhelp.text", "note": "Gmu9z", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24951654/?format=api", "priority": 100, "id": 1512004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2e9c69e8d1687539", "url": "https://translations.documentfoundation.org/api/units/1512004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.913166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROUNDSIG(123456789; 4)</item> returns 123500000 or 123.5E6" ], "previous_source": "", "target": [ "<item type=\"input\">=REDONDEAR.PRECISION(123456789; 4)</item> devuelve 123500000 o 123,5E6" ], "id_hash": 3076053034234844903, "content_hash": 3076053034234844903, "location": "func_roundsig.xhp", "context": "func_roundsig.xhp\npar_id231519155486155\nhelp.text", "note": "CDGCR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24951655/?format=api", "priority": 100, "id": 1512005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=aab055efdfd496e7", "url": "https://translations.documentfoundation.org/api/units/1512005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.931956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SECOND" ], "previous_source": "", "target": [ "SEGUNDO" ], "id_hash": 8109112161528446442, "content_hash": 8109112161528446442, "location": "func_second.xhp", "context": "func_second.xhp\ntit\nhelp.text", "note": "Mv5R9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951657/?format=api", "priority": 100, "id": 1512007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f0895a8c07b3fdea", "url": "https://translations.documentfoundation.org/api/units/1512007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.965575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>SECOND function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SEGUNDO</bookmark_value>" ], "id_hash": -3486185626138987919, "content_hash": -3486185626138987919, "location": "func_second.xhp", "context": "func_second.xhp\nbm_id3159390\nhelp.text", "note": "peiVF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951658/?format=api", "priority": 100, "id": 1512008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4f9e94a4c4e9b271", "url": "https://translations.documentfoundation.org/api/units/1512008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.976028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SECOND</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SEGUNDO</link></variable>" ], "id_hash": 2136833113727431423, "content_hash": 2136833113727431423, "location": "func_second.xhp", "context": "func_second.xhp\nhd_id3159390\nhelp.text", "note": "YBYRJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951659/?format=api", "priority": 100, "id": 1512009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9da78e654003f2ff", "url": "https://translations.documentfoundation.org/api/units/1512009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.986536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SEKUNDE\">Returns the second for the given time value.</ahelp> The second is given as an integer between 0 and 59." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SEKUNDE\">Devuelve el segundo para el valor de tiempo determinado.</ahelp> El segundo se devuelve como un entero entre 0 y 59." ], "id_hash": -887428729205783432, "content_hash": -887428729205783432, "location": "func_second.xhp", "context": "func_second.xhp\npar_id3148974\nhelp.text", "note": "cKTfS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24951660/?format=api", "priority": 100, "id": 1512010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=73af3845c8368478", "url": "https://translations.documentfoundation.org/api/units/1512010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.996492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SECOND(Number)" ], "previous_source": "", "target": [ "SEGUNDO(número)" ], "id_hash": -4580022977342187572, "content_hash": -4580022977342187572, "location": "func_second.xhp", "context": "func_second.xhp\npar_id3148407\nhelp.text", "note": "etVBc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951661/?format=api", "priority": 100, "id": 1512011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=40707d5e3c6457cc", "url": "https://translations.documentfoundation.org/api/units/1512011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.008177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Number</emph>, as a time value, is a decimal, for which the second is to be returned." ], "previous_source": "", "target": [ "El <emph>número</emph>, como valor temporal, es un número decimal en función del cual debe calcularse el número de segundos." ], "id_hash": -7964143779948742345, "content_hash": -7964143779948742345, "location": "func_second.xhp", "context": "func_second.xhp\npar_id3155904\nhelp.text", "note": "7DRDr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24951662/?format=api", "priority": 100, "id": 1512012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1179ad6d9004b937", "url": "https://translations.documentfoundation.org/api/units/1512012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.017755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SECOND(NOW())</item> returns the current second" ], "previous_source": "", "target": [ "<item type=\"input\">=SEGUNDO(AHORA())</item> devuelve el segundo actual." ], "id_hash": 2189616069575049049, "content_hash": 2189616069575049049, "location": "func_second.xhp", "context": "func_second.xhp\npar_id3153350\nhelp.text", "note": "fwYTM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951663/?format=api", "priority": 100, "id": 1512013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9e631436d581ff59", "url": "https://translations.documentfoundation.org/api/units/1512013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.028436Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SECOND(C4)</item> returns 17 if contents of C4 = <item type=\"input\">12:20:17</item>." ], "previous_source": "", "target": [ "<item type=\"input\">=SEGUNDO(C4)</item> devuelve 17 si el contenido de C4 = <item type=\"input\">12:20:17</item>." ], "id_hash": 8425364854405930797, "content_hash": 8425364854405930797, "location": "func_second.xhp", "context": "func_second.xhp\npar_id3150831\nhelp.text", "note": "CWx25", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24951664/?format=api", "priority": 100, "id": 1512014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f4ece8b211ed1f2d", "url": "https://translations.documentfoundation.org/api/units/1512014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.040315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SKEWP function" ], "previous_source": "", "target": [ "Función COEFICIENTE.ASIMETRIA.P" ], "id_hash": -2897760057626162533, "content_hash": -2897760057626162533, "location": "func_skewp.xhp", "context": "func_skewp.xhp\ntit\nhelp.text", "note": "JBtM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951665/?format=api", "priority": 100, "id": 1512015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=57c91694a0e08a9b", "url": "https://translations.documentfoundation.org/api/units/1512015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.051573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>skewness;population</bookmark_value> <bookmark_value>SKEWP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>asimetría;población</bookmark_value> <bookmark_value>función COEFICIENTE.ASIMETRIA.P</bookmark_value>" ], "id_hash": -5147071529756926360, "content_hash": -5147071529756926360, "location": "func_skewp.xhp", "context": "func_skewp.xhp\nbm_id1102201617201921\nhelp.text", "note": "fFaLh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951666/?format=api", "priority": 100, "id": 1512016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3891edb6cb4fde68", "url": "https://translations.documentfoundation.org/api/units/1512016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.061524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"skewp_head\"><link href=\"text/scalc/01/func_skewp.xhp\">SKEWP</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"skewp_head\"><link href=\"text/scalc/01/func_skewp.xhp\">COEFICIENTE.ASIMETRIA.P</link></variable>" ], "id_hash": 1754675695205416285, "content_hash": 1754675695205416285, "location": "func_skewp.xhp", "context": "func_skewp.xhp\nhd_id456845684568\nhelp.text", "note": "Xv6GF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951667/?format=api", "priority": 100, "id": 1512017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9859dc3f84bafd5d", "url": "https://translations.documentfoundation.org/api/units/1512017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.073475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\">Calculates the skewness of a distribution using the population of a random variable.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Devuelve la asimetría de una distribución utilizando la población de una variable aleatoria.</ahelp>" ], "id_hash": 1212482923548908224, "content_hash": 1212482923548908224, "location": "func_skewp.xhp", "context": "func_skewp.xhp\npar_id1102201617001848\nhelp.text", "note": "cuNXs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24951668/?format=api", "priority": 100, "id": 1512018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=90d39acb825c1ac0", "url": "https://translations.documentfoundation.org/api/units/1512018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.085726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<link href=\"text/scalc/01/04060185.xhp#skew\">SKEW</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060185.xhp#skew\">COEFICIENTE.ASIMETRIA</link>" ], "id_hash": -915857506398487071, "content_hash": -915857506398487071, "location": "func_skewp.xhp", "context": "func_skewp.xhp\npar_id14337286612130\nhelp.text", "note": "5iYyJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951676/?format=api", "priority": 100, "id": 1512028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=734a38734a3e3de1", "url": "https://translations.documentfoundation.org/api/units/1512028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.177861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SUMIFS function" ], "previous_source": "", "target": [ "Función SUMAR.SI.CONJUNTO" ], "id_hash": -3540436716313482577, "content_hash": -3540436716313482577, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\ntit\nhelp.text", "note": "DfceH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7717, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951677/?format=api", "priority": 100, "id": 1512029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4eddd79086626aaf", "url": "https://translations.documentfoundation.org/api/units/1512029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.192107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función SUMAR.SI.CONJUNTO</bookmark_value> <bookmark_value>suma;satisfacer condiciones</bookmark_value>" ], "id_hash": -2704983415798147745, "content_hash": -2704983415798147745, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nbm_id658066580665806\nhelp.text", "note": "jDeBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7718, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24951678/?format=api", "priority": 100, "id": 1512030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5a75f7ea3a07555f", "url": "https://translations.documentfoundation.org/api/units/1512030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.206559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Devuelve la suma de los valores de las celdas en un intervalo que cumple múltiples criterios en varios intervalos.</variable></ahelp>" ], "id_hash": 9169675903449353869, "content_hash": 9169675903449353869, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id659756597565975\nhelp.text", "note": "ZEdvF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7720, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24951680/?format=api", "priority": 100, "id": 1512032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ff413ba6b28ece8d", "url": "https://translations.documentfoundation.org/api/units/1512032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.236666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "SUMAR.SI.CONJUNTO(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "id_hash": 8486374903425621466, "content_hash": 8486374903425621466, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id11655988824213\nhelp.text", "note": "xhKwv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7721, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951681/?format=api", "priority": 100, "id": 1512033, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f5c5a9030d795dda", "url": "https://translations.documentfoundation.org/api/units/1512033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.250515Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." ], "previous_source": "", "target": [ "<emph>función_Rango</emph>– argumento requerido. Es un rango de celdas, un nombre de un rango con nombre o una etiqueta de una columna o una fila que contiene valores para calcular la suma." ], "id_hash": -3181281400957303016, "content_hash": -3181281400957303016, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id59901690530236\nhelp.text", "note": "mP5Et", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7722, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24951682/?format=api", "priority": 100, "id": 1512034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=53d9d16bc5620718", "url": "https://translations.documentfoundation.org/api/units/1512034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.262599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Uso simple" ], "id_hash": 100979218881927587, "content_hash": 100979218881927587, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id193452436229521\nhelp.text", "note": "zahGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7723, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951683/?format=api", "priority": 100, "id": 1512035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8166c010872759a3", "url": "https://translations.documentfoundation.org/api/units/1512035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.274908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(B2:B6;B2:B6;\">=20\")</item>" ], "id_hash": -3980841953204373942, "content_hash": -3980841953204373942, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id94321051525036\nhelp.text", "note": "tqgKL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7724, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951684/?format=api", "priority": 100, "id": 1512036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/1512036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.289248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores del intervalo B2:B6 que son mayores o iguales que 20. Devuelve 75 porque la quinta fila no cumple con el criterio." ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7725, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24951685/?format=api", "priority": 100, "id": 1512037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/1512037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.304114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -9075336950328213574, "content_hash": -9075336950328213574, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id36952767622741\nhelp.text", "note": "TzCFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7726, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951686/?format=api", "priority": 100, "id": 1512038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/1512038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.317727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores en el intervalo C2:C6 que son mayores que 70 y que se corresponden con las celdas del intervalo B2:B6 con valores mayores o iguales que 20. Devuelve 275 porque las filas segunda y quinta no cumplen con por lo menos un criterio." ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7727, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24951687/?format=api", "priority": 100, "id": 1512039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/1512039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.331232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Uso de expresiones regulares y funciones anidadas" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7728, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951688/?format=api", "priority": 100, "id": 1512040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/1512040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.343939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7729, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951689/?format=api", "priority": 100, "id": 1512041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/1512041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.356467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores en el intervalo C2:C6 que se corresponden con todos los valores del intervalo B2:B6, exceptuando su mínimo y su máximo. Devuelve 255 porque las filas tercera y quinta no cumplen con por lo menos un criterio." ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7730, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24951690/?format=api", "priority": 100, "id": 1512042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/1512042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.370547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;\"pan.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7731, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951691/?format=api", "priority": 100, "id": 1512043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/1512043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.383398Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Calcula la suma de los valores del intervalo C2:C6 que se corresponden con todas las celdas del intervalo A2:A6 que comienzan por «pan» y con todas las celdas del intervalo B2:B6 excepto su máximo. Devuelve 65 porque solo la segunda fila cumple con todos los criterios." ], "id_hash": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7732, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24951692/?format=api", "priority": 100, "id": 1512044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/1512044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.395563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referencia a una celda como criterio" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7733, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24951693/?format=api", "priority": 100, "id": 1512045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/1512045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.409656Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Si se necesita cambiar un criterio fácilmente, puede especificarlo en ena celda separada y usar una referencia a esa celda en la condición de la función SUMAR.SI.CONJUNTO. Por ejemplo, la función anterios puede reescribirse así:" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7734, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24951694/?format=api", "priority": 100, "id": 1512046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/1512046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.424478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7735, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951695/?format=api", "priority": 100, "id": 1512047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/1512047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.439390Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Si E2 = pen, la función devuelve 65 porque el link a la celda se sustituye por su contenido." ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7736, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24951696/?format=api", "priority": 100, "id": 1512048, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/1512048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.452578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SWITCH function" ], "previous_source": "", "target": [ "Función CAMBIAR" ], "id_hash": 5686056986956170649, "content_hash": 5686056986956170649, "location": "func_switch.xhp", "context": "func_switch.xhp\ntit\nhelp.text", "note": "UUeQC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7738, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951697/?format=api", "priority": 100, "id": 1512049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cee8eeb420268599", "url": "https://translations.documentfoundation.org/api/units/1512049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.466113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>SWITCH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función CAMBIAR</bookmark_value>" ], "id_hash": -2260707101919447878, "content_hash": -2260707101919447878, "location": "func_switch.xhp", "context": "func_switch.xhp\nbm_id571556244875552\nhelp.text", "note": "5ALMt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7739, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951698/?format=api", "priority": 100, "id": 1512050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=60a05ade58e374ba", "url": "https://translations.documentfoundation.org/api/units/1512050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.481303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"functionswitch\"><ahelp hid=\".\"> CAMBIAR Compara<emph>expresión</emph>con<emph>valor</emph>Para<emph>valor</emph>y devuelve el resultado que pertenece al primer valor que es igual a la expresión. Si no hay coincidencia y se da default_result, se devolverá</ahelp></variable>" ], "id_hash": 3196169826997080294, "content_hash": 3196169826997080294, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id361556242313793\nhelp.text", "note": "vaCEi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7741, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24951700/?format=api", "priority": 100, "id": 1512052, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ac5b13860bfb90e6", "url": "https://translations.documentfoundation.org/api/units/1512052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.515299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>expression</emph> is a text, numeric, logical or date input or reference to a cell." ], "previous_source": "", "target": [ "<emph>expresión</emph> es una entrada de texto, numérica, lógica o de fecha, o bien, una referencia a otra celda." ], "id_hash": 9117707988652973551, "content_hash": 9117707988652973551, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id341556242996378\nhelp.text", "note": "nnW4D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7744, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24951702/?format=api", "priority": 100, "id": 1512054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fe889b1ba566ddef", "url": "https://translations.documentfoundation.org/api/units/1512054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.549797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>value1, value2, ...</emph> is any value or reference to a cell. Each value must have a result given." ], "previous_source": "", "target": [ "<emph>valor1, valor2, ...</emph> es cualquier valor o referencia a una celda. Cada valor debe tener un resultado dado." ], "id_hash": 2789162408943903381, "content_hash": 2789162408943903381, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id321556243790332\nhelp.text", "note": "Z7xiA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7745, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24951703/?format=api", "priority": 100, "id": 1512055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a6b5186eedf96295", "url": "https://translations.documentfoundation.org/api/units/1512055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.568012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>result1, result2, ...</emph> is any value or reference to a cell." ], "previous_source": "", "target": [ "<emph>resultado1, resultado2, ...</emph> es cualquier valor o referencia a una celda." ], "id_hash": -4984656508639212289, "content_hash": -4984656508639212289, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id171556243796068\nhelp.text", "note": "ADDqw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7746, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24951811/?format=api", "priority": 100, "id": 1512056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3ad2f150b3388cff", "url": "https://translations.documentfoundation.org/api/units/1512056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.585501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>default_result</emph>: any value or reference to a cell that is returned when there is no match." ], "previous_source": "", "target": [ "<emph>resultado_predeterminado</emph>: cualquier valor o referencia a una celda que se devuelve cuando no hay coincidencia." ], "id_hash": 234638763577069450, "content_hash": 234638763577069450, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id331556245422283\nhelp.text", "note": "9SKCB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7747, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24951812/?format=api", "priority": 100, "id": 1512057, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=83419ab6598c4f8a", "url": "https://translations.documentfoundation.org/api/units/1512057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:10.600487Z" } ] }{ "count": 8628, "next": "