Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=146
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=147", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=145", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "How many workdays fall between 2001-12-15 and 2002-01-15? The start date is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: \"2001-12-24\", \"2001-12-25\", \"2001-12-26\", \"2001-12-31\", \"2002-01-01\"." ], "previous_source": "", "target": [ "" ], "id_hash": -1982293131885698049, "content_hash": -1982293131885698049, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3154661\nhelp.text", "note": "yTEUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99325843/?format=api", "priority": 100, "id": 99531166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=647d7ae63141a3ff", "url": "https://translations.documentfoundation.org/api/units/99531166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.864844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays." ], "previous_source": "", "target": [ "" ], "id_hash": 2935738812314091017, "content_hash": 2935738812314091017, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3147328\nhelp.text", "note": "FWMFn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99325881/?format=api", "priority": 100, "id": 99531173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a8bdd6e5454efe09", "url": "https://translations.documentfoundation.org/api/units/99531173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.866836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "How many workdays fall between September 12nd and 25th in 2016 if only Mondays, Tuesdays and Wednesdays are considered as workdays?" ], "previous_source": "", "target": [ "" ], "id_hash": -1466287873485381398, "content_hash": -1466287873485381398, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161751233621\nhelp.text", "note": "DxQVm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99325919/?format=api", "priority": 100, "id": 99531182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6ba6b2f2a270e0ea", "url": "https://translations.documentfoundation.org/api/units/99531182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:37.870205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays." ], "previous_source": "", "target": [ "" ], "id_hash": 5717208620301641003, "content_hash": 5717208620301641003, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161751235483\nhelp.text", "note": "fELgW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99325941/?format=api", "priority": 100, "id": 99531186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cf579af2f7e1652b", "url": "https://translations.documentfoundation.org/api/units/99531186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.598055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NETWORKDAYS\">NETWORKDAYS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7600124991530768004, "content_hash": 7600124991530768004, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id151677015372427\nhelp.text", "note": "95acN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99325980/?format=api", "priority": 100, "id": 99531189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e9791169a0c29684", "url": "https://translations.documentfoundation.org/api/units/99531189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.599640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NOW" ], "previous_source": "", "target": [ "AGORA" ], "id_hash": 7672545122372848302, "content_hash": 7672545122372848302, "location": "func_now.xhp", "context": "func_now.xhp\ntit\nhelp.text", "note": "HCN8H", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99326004/?format=api", "priority": 100, "id": 99531193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ea7a5b234e308aae", "url": "https://translations.documentfoundation.org/api/units/99531193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.600835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>NOW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>AGORA</bookmark_value>" ], "id_hash": 4319039634089526508, "content_hash": 4319039634089526508, "location": "func_now.xhp", "context": "func_now.xhp\nbm_id3150521\nhelp.text", "note": "bUAGA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99326027/?format=api", "priority": 100, "id": 99531199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bbf04fa9f8bd44ec", "url": "https://translations.documentfoundation.org/api/units/99531199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.611238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"now\"><link href=\"text/scalc/01/func_now.xhp\">NOW</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"now\"><link href=\"text/scalc/01/func_now.xhp\">AGORA</link></variable>" ], "id_hash": 8724488582914162175, "content_hash": 8724488582914162175, "location": "func_now.xhp", "context": "func_now.xhp\nhd_id3150521\nhelp.text", "note": "n4jYR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99326062/?format=api", "priority": 100, "id": 99531201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f9139c244f8cbdff", "url": "https://translations.documentfoundation.org/api/units/99531201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.613512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_JETZT\">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_JETZT\">Devuelve la fecha y l'hora del sistema.</ahelp> El valor actualízase cuando se recalcula el documentu o cada vez que se modificar un valor de la caxella." ], "id_hash": 4908476510420007667, "content_hash": 4908476510420007667, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3148829\nhelp.text", "note": "o7Wxp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99326118/?format=api", "priority": 100, "id": 99531206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c41e696147eefaf3", "url": "https://translations.documentfoundation.org/api/units/99531206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.615441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NOW()" ], "previous_source": "", "target": [ "AGORA()" ], "id_hash": 3319766644813171290, "content_hash": 3319766644813171290, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3154897\nhelp.text", "note": "4wCVv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99326155/?format=api", "priority": 100, "id": 99531210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae122e2cb1478a5a", "url": "https://translations.documentfoundation.org/api/units/99531210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.617357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NOW is a function without arguments." ], "previous_source": "", "target": [ "NOW ye una función ensin argumentos." ], "id_hash": -4095934625277828030, "content_hash": -4095934625277828030, "location": "func_now.xhp", "context": "func_now.xhp\npar_id4598529\nhelp.text", "note": "j8sKU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99326185/?format=api", "priority": 100, "id": 99531214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=47285128d517a442", "url": "https://translations.documentfoundation.org/api/units/99531214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.618887Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number." ], "previous_source": "", "target": [ "<item type=\"input\">=AGORA()-A1</item> devuelve la diferencia ente la fecha n'A1 y agora. El formatu resultáu como un númberu." ], "id_hash": -2769973158782386336, "content_hash": -2769973158782386336, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3150774\nhelp.text", "note": "DXy7U", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99326210/?format=api", "priority": 100, "id": 99531219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=598f14168968bf60", "url": "https://translations.documentfoundation.org/api/units/99531219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.620435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NOW\">NOW wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7155968183938091263, "content_hash": 7155968183938091263, "location": "func_now.xhp", "context": "func_now.xhp\npar_id481677015356908\nhelp.text", "note": "eoaoB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99326232/?format=api", "priority": 100, "id": 99531224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e34f1b263ba088ff", "url": "https://translations.documentfoundation.org/api/units/99531224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.622336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NUMBERVALUE" ], "previous_source": "", "target": [ "" ], "id_hash": -1807660715623394968, "content_hash": -1807660715623394968, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\ntit\nhelp.text", "note": "G3PMG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99326308/?format=api", "priority": 100, "id": 99531227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=66e9e62812d6d168", "url": "https://translations.documentfoundation.org/api/units/99531227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.623724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>NUMBERVALUE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HORANÚMERO</bookmark_value>" ], "id_hash": -3577443060746469869, "content_hash": -3577443060746469869, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\nbm_id3145621\nhelp.text", "note": "ExLmD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99326341/?format=api", "priority": 100, "id": 99531231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4e5a5e7d88053e13", "url": "https://translations.documentfoundation.org/api/units/99531231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.625157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"numbervalue_h1\"><link href=\"text/scalc/01/func_numbervalue.xhp\">NUMBERVALUE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -8818760029261852724, "content_hash": -8818760029261852724, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\nhd_id3145621\nhelp.text", "note": "GomzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99326370/?format=api", "priority": 100, "id": 99531237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=059d787a286f0fcc", "url": "https://translations.documentfoundation.org/api/units/99531237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.626973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_NUMBERVALUE\">Converts the string representation of a number into a locale-independent numeric value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -4889151883558462759, "content_hash": -4889151883558462759, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3145087\nhelp.text", "note": "Ywca6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99326403/?format=api", "priority": 100, "id": 99531240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3c263e440790dad9", "url": "https://translations.documentfoundation.org/api/units/99531240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.628364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The input text may be in a locale-dependent or other bespoke format." ], "previous_source": "", "target": [ "" ], "id_hash": -3177750020528423366, "content_hash": -3177750020528423366, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3149281\nhelp.text", "note": "xfP9G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99326444/?format=api", "priority": 100, "id": 99531245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=53e65d315969be3a", "url": "https://translations.documentfoundation.org/api/units/99531245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.629981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The output number is formatted as a valid floating point value and shown using the current cell's number format." ], "previous_source": "", "target": [ "" ], "id_hash": 1835724502749695149, "content_hash": 1835724502749695149, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id381625600941159\nhelp.text", "note": "vVK9p", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99326479/?format=api", "priority": 100, "id": 99531247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9979cdb58be04cad", "url": "https://translations.documentfoundation.org/api/units/99531247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.631780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Refer to the <link href=\"text/shared/01/05020300.xhp\">Numbers / Format</link> help page to learn how to change the format of numbers in a cell." ], "previous_source": "", "target": [ "" ], "id_hash": 1293969678943672560, "content_hash": 1293969678943672560, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id351625601754290\nhelp.text", "note": "pCZWD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99326508/?format=api", "priority": 100, "id": 99531248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=91f51a91379058f0", "url": "https://translations.documentfoundation.org/api/units/99531248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.633106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "NUMBERVALUE(Text[; Decimal Separator[; Group Separator]])" ], "previous_source": "", "target": [ "" ], "id_hash": -2679538892279753387, "content_hash": -2679538892279753387, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id721625602228575\nhelp.text", "note": "vEdwF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99326540/?format=api", "priority": 100, "id": 99531250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5ad05d9303d25555", "url": "https://translations.documentfoundation.org/api/units/99531250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.634424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Text</emph> is a string that contains the number to be converted." ], "previous_source": "", "target": [ "<emph>Testu</emph> ye una cadena que contién el númberu que va convertise." ], "id_hash": -6033916780931706379, "content_hash": -6033916780931706379, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3154819\nhelp.text", "note": "Y3A9n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99326571/?format=api", "priority": 100, "id": 99531252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2c4338a8244c11f5", "url": "https://translations.documentfoundation.org/api/units/99531252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.635749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Decimal Separator</emph> is a single character that specifies the decimal separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any decimal or group separators." ], "previous_source": "", "target": [ "" ], "id_hash": -8866510144490139424, "content_hash": -8866510144490139424, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3154820\nhelp.text", "note": "gwZ7A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99326625/?format=api", "priority": 100, "id": 99531258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=04f3d400184490e0", "url": "https://translations.documentfoundation.org/api/units/99531258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.638116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Group Separator</emph> is a string that specifies the character(s) used as the group separator in <emph>Text</emph>. It can be omitted if <emph>Text</emph> does not include any group separators. The <emph>Decimal Separator</emph> character should not be used in <emph>Group Separator</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -3717560467131311919, "content_hash": -3717560467131311919, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3154821\nhelp.text", "note": "KJ6WA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99326654/?format=api", "priority": 100, "id": 99531261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4c6892739d9a58d1", "url": "https://translations.documentfoundation.org/api/units/99531261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.640826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=NUMBERVALUE(\"1.234.567,89\"; \",\"; \".\")</input> returns 1234567.89 (considering en-US locale). The function removes the two group separators and changes the decimal separator from a comma to a full stop." ], "previous_source": "", "target": [ "" ], "id_hash": -6819620511998587793, "content_hash": -6819620511998587793, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id3155841\nhelp.text", "note": "yptHN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99326691/?format=api", "priority": 100, "id": 99531266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=215bd746b75b4c6f", "url": "https://translations.documentfoundation.org/api/units/99531266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.643618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=NUMBERVALUE(\"123·4\"; \"·\")</input> returns 123.4 (considering en-US locale). The function changes the decimal separator from a \"·\" to a full stop. No group separator is used in the supplied number and so the <emph>Group Separator</emph> argument is omitted." ], "previous_source": "", "target": [ "" ], "id_hash": -831594558472780564, "content_hash": -831594558472780564, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id721625603302860\nhelp.text", "note": "UNiLM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99326731/?format=api", "priority": 100, "id": 99531269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=74759527b11504ec", "url": "https://translations.documentfoundation.org/api/units/99531269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.645231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=NUMBERVALUE(\"123e12\")</input> returns 1.23E+14 (considering en-US locale). No decimal or group separators are used in the supplied number and so the <emph>Decimal Separator</emph> and <emph>Group Separator</emph> arguments are omitted." ], "previous_source": "", "target": [ "" ], "id_hash": 7300574713619796163, "content_hash": 7300574713619796163, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id491625603415715\nhelp.text", "note": "iGGwj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99326762/?format=api", "priority": 100, "id": 99531273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e550da059d81d0c3", "url": "https://translations.documentfoundation.org/api/units/99531273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.646850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=NUMBERVALUE(\"1#!234#!567\"; \".\"; \"#!\")</input> returns 1234567 (considering en-US locale). Note that in this case the group separator is specified as a two-character string." ], "previous_source": "", "target": [ "" ], "id_hash": -4732235899399666423, "content_hash": -4732235899399666423, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id801625603497421\nhelp.text", "note": "vTYDd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99326855/?format=api", "priority": 100, "id": 99531276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3e53b8859eee8509", "url": "https://translations.documentfoundation.org/api/units/99531276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.648728Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/NUMBERVALUE\">NUMBERVALUE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -6125162708868205853, "content_hash": -6125162708868205853, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\npar_id411677015337340\nhelp.text", "note": "nDXY8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99326925/?format=api", "priority": 100, "id": 99531278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2aff0cf80270f2e3", "url": "https://translations.documentfoundation.org/api/units/99531278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.650382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Function OPT_BARRIER" ], "previous_source": "", "target": [ "" ], "id_hash": -1608973533593781808, "content_hash": -1608973533593781808, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\ntit\nhelp.text", "note": "EJhfD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99326956/?format=api", "priority": 100, "id": 99531283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=69abc7188d2339d0", "url": "https://translations.documentfoundation.org/api/units/99531283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.651963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>OPT_BARRIER function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8433996772325081644, "content_hash": -8433996772325081644, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\nbm_id511575065323638\nhelp.text", "note": "4HRGX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99326977/?format=api", "priority": 100, "id": 99531285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0af46c9eecc5bdd4", "url": "https://translations.documentfoundation.org/api/units/99531285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.653524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"optbrarrierh1\"><link href=\"text/scalc/01/func_opt_barrier.xhp\">OPT_BARRIER</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6058111889723697892, "content_hash": -6058111889723697892, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\nhd_id241575063871994\nhelp.text", "note": "zrZgo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99327006/?format=api", "priority": 100, "id": 99531287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2bed43556372d51c", "url": "https://translations.documentfoundation.org/api/units/99531287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.655114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"variable name\"><ahelp hid=\".\">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -268585752536468063, "content_hash": -268585752536468063, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id121575063871995\nhelp.text", "note": "uFKBs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99327047/?format=api", "priority": 100, "id": 99531290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7c45caae5c5535a1", "url": "https://translations.documentfoundation.org/api/units/99531290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.656657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek])" ], "previous_source": "", "target": [ "" ], "id_hash": 55317342696685206, "content_hash": 55317342696685206, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id371575067051846\nhelp.text", "note": "3ky3t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99327055/?format=api", "priority": 100, "id": 99531293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=80c486d4815abe96", "url": "https://translations.documentfoundation.org/api/units/99531293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.658162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Strike</emph> is the strike price of the option and should be non-negative." ], "previous_source": "", "target": [ "" ], "id_hash": 4957969820802546737, "content_hash": 4957969820802546737, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id681575073426941\nhelp.text", "note": "XEMff", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99327078/?format=api", "priority": 100, "id": 99531296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c4ce3f48980afc31", "url": "https://translations.documentfoundation.org/api/units/99531296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.659692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Rebate</emph> is the amount of money to be paid at maturity if the barrier is hit." ], "previous_source": "", "target": [ "" ], "id_hash": -4179903024043830224, "content_hash": -4179903024043830224, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id671575073495724\nhelp.text", "note": "8tgWG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99327112/?format=api", "priority": 100, "id": 99531299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=45fe005880495430", "url": "https://translations.documentfoundation.org/api/units/99531299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.661492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"optputcall\"><emph>Put or Call</emph> is a string that defines whether the option is a put (“p”) or a call (“c”).</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -8844942970378732142, "content_hash": -8844942970378732142, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id691575073511191\nhelp.text", "note": "uAzky", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99327123/?format=api", "priority": 100, "id": 99531301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0540733b1ffcbd92", "url": "https://translations.documentfoundation.org/api/units/99531301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.662989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;\"c\";\"o\";\"c\")</input> returns the value 0.4243." ], "previous_source": "", "target": [ "" ], "id_hash": -4378797789791531314, "content_hash": -4378797789791531314, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id651575073773761\nhelp.text", "note": "PdCJb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99327180/?format=api", "priority": 100, "id": 99531306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=433b629c2c35cece", "url": "https://translations.documentfoundation.org/api/units/99531306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.664509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;\"p\";\"o\";\"c\";\"e\")</input> returns the value 10.1585." ], "previous_source": "", "target": [ "" ], "id_hash": -8812193663017690208, "content_hash": -8812193663017690208, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id401575073777593\nhelp.text", "note": "ABVQH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99327204/?format=api", "priority": 100, "id": 99531308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=05b4cc8d6fe1dba0", "url": "https://translations.documentfoundation.org/api/units/99531308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.665986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/OPT_BARRIER\">OPT_BARRIER wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5502688473486855340, "content_hash": -5502688473486855340, "location": "func_opt_barrier.xhp", "context": "func_opt_barrier.xhp\npar_id471677015317570\nhelp.text", "note": "kNCjN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99327240/?format=api", "priority": 100, "id": 99531313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=33a285fce42df354", "url": "https://translations.documentfoundation.org/api/units/99531313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.667603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Function OPT_PROB_HIT" ], "previous_source": "", "target": [ "" ], "id_hash": -8977397444842444451, "content_hash": -8977397444842444451, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\ntit\nhelp.text", "note": "HWhRY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99327275/?format=api", "priority": 100, "id": 99531317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0369e09694aaa95d", "url": "https://translations.documentfoundation.org/api/units/99531317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.669437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>OPT_PROB_HIT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2637137765456586483, "content_hash": 2637137765456586483, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\nbm_id961575074485125\nhelp.text", "note": "5Naq2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99327297/?format=api", "priority": 100, "id": 99531322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a498fed355cea6f3", "url": "https://translations.documentfoundation.org/api/units/99531322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.670812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"optprobhith1\"><link href=\"text/scalc/01/func_opt_prob_hit.xhp\">OPT_PROB_HIT</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -7144863671262362730, "content_hash": -7144863671262362730, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\nhd_id71575063908363\nhelp.text", "note": "GaMLc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99327316/?format=api", "priority": 100, "id": 99531325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1cd8585899d04396", "url": "https://translations.documentfoundation.org/api/units/99531325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.672169Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"variable name\"><ahelp hid=\".\">Returns the probability that an asset hits a predetermined barrier price, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows." ], "previous_source": "", "target": [ "" ], "id_hash": 5529996202116398292, "content_hash": 5529996202116398292, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id591575063908364\nhelp.text", "note": "fWecm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99327331/?format=api", "priority": 100, "id": 99531330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ccbe7e3f24683cd4", "url": "https://translations.documentfoundation.org/api/units/99531330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.673648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<image src=\"media/helpimg/sc_func_opt01.svg\" id=\"img_id211575078735993\" width=\"197.38334px\" height=\"51.2125px\"><alt id=\"alt_id401575078735994\">OPT_PROB_HIT equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": 4870345766175975529, "content_hash": 4870345766175975529, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id21575078735992\nhelp.text", "note": "ZJBj2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99327365/?format=api", "priority": 100, "id": 99531339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c396f1ab8e3f2869", "url": "https://translations.documentfoundation.org/api/units/99531339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.676916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<literal>µ</literal> is the asset’s percentage drift, <literal>vol</literal> is the percentage volatility of the stock, and <literal>dW</literal> is a random sample drawn from a normal distribution with a zero mean. <literal>W</literal> is a Wiener process or Brownian motion." ], "previous_source": "", "target": [ "" ], "id_hash": -4348320986480588861, "content_hash": -4348320986480588861, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id821575074114118\nhelp.text", "note": "FnaCP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99327401/?format=api", "priority": 100, "id": 99531346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=43a7a919e772c7c3", "url": "https://translations.documentfoundation.org/api/units/99531346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.679257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier)" ], "previous_source": "", "target": [ "" ], "id_hash": 505119542386427697, "content_hash": 505119542386427697, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id211575074192954\nhelp.text", "note": "9NRxu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99327433/?format=api", "priority": 100, "id": 99531351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=87028b8c2d0d0731", "url": "https://translations.documentfoundation.org/api/units/99531351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.681442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"optdrift\"><emph>Drift</emph> is the annual stock price percentage drift rate (µ in the above formula). The value is expressed as a decimal (for example, enter 15% as 0.15).</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -890491577805847270, "content_hash": -890491577805847270, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id901575074339820\nhelp.text", "note": "XaA8K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99327476/?format=api", "priority": 100, "id": 99531359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=73a456a0c567c51a", "url": "https://translations.documentfoundation.org/api/units/99531359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.683558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"optstrike\"><emph>Strike</emph> is the strike price of the option and should be non-negative.</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3301563730392574633, "content_hash": 3301563730392574633, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id681575073426941\nhelp.text", "note": "6yrWk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99327557/?format=api", "priority": 100, "id": 99531366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=add182b8695ceaa9", "url": "https://translations.documentfoundation.org/api/units/99531366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.685583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=OPT_PROB_HIT(30;0.2;0.3;1;0;40)</input> returns the value 0.6119." ], "previous_source": "", "target": [ "" ], "id_hash": 48434085572133025, "content_hash": 48434085572133025, "location": "func_opt_prob_hit.xhp", "context": "func_opt_prob_hit.xhp\npar_id971575074431070\nhelp.text", "note": "mHW3F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99327604/?format=api", "priority": 100, "id": 99531371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=80ac128b518c40a1", "url": "https://translations.documentfoundation.org/api/units/99531371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:38.687300Z" } ] }