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=13
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DMIN" ], "previous_source": "", "target": [ "BDMIN" ], "id_hash": 6315401607782341768, "content_hash": 6315401607782341768, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3159141\nhelp.text", "note": "iGV4a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099443/?format=api", "priority": 100, "id": 99487991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d7a4d04d45cc1c88", "url": "https://translations.documentfoundation.org/api/units/99487991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.015251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMIN\">DMIN calculates the minimum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "" ], "id_hash": -2182869194426701095, "content_hash": -2182869194426701095, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154261\nhelp.text", "note": "kv5Gb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99099469/?format=api", "priority": 100, "id": 99487997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=61b4e408730daad9", "url": "https://translations.documentfoundation.org/api/units/99487997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.017251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -7088825732426253501, "content_hash": -7088825732426253501, "location": "04060101.xhp", "context": "04060101.xhp\npar_id901616180605426\nhelp.text", "note": "yYJTa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99099506/?format=api", "priority": 100, "id": 99488004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d9f6e8df815bb43", "url": "https://translations.documentfoundation.org/api/units/99488004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.018851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DMIN(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDMIN(Base de Datos; Riolo Base de Datos; Busca por Criterios)" ], "id_hash": -2365212603741018146, "content_hash": -2365212603741018146, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148479\nhelp.text", "note": "QxBsV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099513/?format=api", "priority": 100, "id": 99488009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5f2d13ab17bd67de", "url": "https://translations.documentfoundation.org/api/units/99488009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.020195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -2901804372218614756, "content_hash": -2901804372218614756, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148925\nhelp.text", "note": "p4YQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099558/?format=api", "priority": 100, "id": 99488018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=57bab84c423bec1c", "url": "https://translations.documentfoundation.org/api/units/99488018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.021872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 4931777981835359673, "content_hash": 4931777981835359673, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149161\nhelp.text", "note": "LrfjC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99099566/?format=api", "priority": 100, "id": 99488026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c47131f1de63b5b9", "url": "https://translations.documentfoundation.org/api/units/99488026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.023603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2870387606319136727, "content_hash": -2870387606319136727, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154274\nhelp.text", "note": "XEu9j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99099609/?format=api", "priority": 100, "id": 99488032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/99488032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.025072Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DAVERAGE" ], "previous_source": "", "target": [ "BDPROMEDIO" ], "id_hash": 8325687557178170627, "content_hash": 8325687557178170627, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154274\nhelp.text", "note": "dQciw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099666/?format=api", "priority": 100, "id": 99488036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f38ac8b8cc7e9d03", "url": "https://translations.documentfoundation.org/api/units/99488036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.026475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">DAVERAGE calculates the average of the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values in those cells are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -1578848825274792703, "content_hash": -1578848825274792703, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3166453\nhelp.text", "note": "Y7wdv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99099686/?format=api", "priority": 100, "id": 99488040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6a16cd5bc7740501", "url": "https://translations.documentfoundation.org/api/units/99488040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.027958Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns a #DIV/0! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": 7303987702708060116, "content_hash": 7303987702708060116, "location": "04060101.xhp", "context": "04060101.xhp\npar_id31615978739452\nhelp.text", "note": "87qxe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99099714/?format=api", "priority": 100, "id": 99488044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e55cfa1e0fbc3fd4", "url": "https://translations.documentfoundation.org/api/units/99488044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.029420Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DAVERAGE(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDPROMEDIO(Base de Datos; Campu de Base de Datos; Busca por Criterios)" ], "id_hash": 6939834441930249975, "content_hash": 6939834441930249975, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150710\nhelp.text", "note": "PPkBD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099758/?format=api", "priority": 100, "id": 99488049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e04f3ea7f74616f7", "url": "https://translations.documentfoundation.org/api/units/99488049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.030845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 6372245985782288987, "content_hash": 6372245985782288987, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149104\nhelp.text", "note": "PcjTP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099776/?format=api", "priority": 100, "id": 99488060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d86ec3f663f6525b", "url": "https://translations.documentfoundation.org/api/units/99488060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.033333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1814434218395281006, "content_hash": 1814434218395281006, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201616368312277\nhelp.text", "note": "CjTGB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99099814/?format=api", "priority": 100, "id": 99488065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=992e2a4eefc3a66e", "url": "https://translations.documentfoundation.org/api/units/99488065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.035200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8547260052556627769, "content_hash": 8547260052556627769, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159269\nhelp.text", "note": "6fcFr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99099823/?format=api", "priority": 100, "id": 99488071, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/99488071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.037135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DPRODUCT" ], "previous_source": "", "target": [ "BDPRODUCTO" ], "id_hash": 3613951182874316910, "content_hash": 3613951182874316910, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3159269\nhelp.text", "note": "gvW9Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099854/?format=api", "priority": 100, "id": 99488077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b22755740ad3906e", "url": "https://translations.documentfoundation.org/api/units/99488077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.038675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT calculates the product of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "" ], "id_hash": -6870910731368740162, "content_hash": -6870910731368740162, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152879\nhelp.text", "note": "oJApo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99099882/?format=api", "priority": 100, "id": 99488086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=20a59f17ed58cabe", "url": "https://translations.documentfoundation.org/api/units/99488086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.040843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -6088134275114650130, "content_hash": -6088134275114650130, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616180868336\nhelp.text", "note": "oUsZD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99099899/?format=api", "priority": 100, "id": 99488096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2b829a2212e935ee", "url": "https://translations.documentfoundation.org/api/units/99488096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.042490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DPRODUCT(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "DPRODUCT(Base de Datos; Riolo Base de Datos; Criterios de Busca)" ], "id_hash": -2550060692960315488, "content_hash": -2550060692960315488, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154854\nhelp.text", "note": "PgAsj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099923/?format=api", "priority": 100, "id": 99488101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5c9c5d4f8069f7a0", "url": "https://translations.documentfoundation.org/api/units/99488101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.044042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 6697853395288567308, "content_hash": 6697853395288567308, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148986\nhelp.text", "note": "oGQtm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099937/?format=api", "priority": 100, "id": 99488106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dcf38e2d1fd1ae0c", "url": "https://translations.documentfoundation.org/api/units/99488106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.045719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -4597042588880741787, "content_hash": -4597042588880741787, "location": "04060101.xhp", "context": "04060101.xhp\npar_id91616368981807\nhelp.text", "note": "iaoUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99099960/?format=api", "priority": 100, "id": 99488114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4034061f206bda65", "url": "https://translations.documentfoundation.org/api/units/99488114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.047331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8527548628645799969, "content_hash": 8527548628645799969, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148462\nhelp.text", "note": "KsVCV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99100000/?format=api", "priority": 100, "id": 99488117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/99488117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.048701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSTDEV" ], "previous_source": "", "target": [ "BDDESVEST" ], "id_hash": 3411649162921893682, "content_hash": 3411649162921893682, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3148462\nhelp.text", "note": "EvGNP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100031/?format=api", "priority": 100, "id": 99488124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=af589cd68637df32", "url": "https://translations.documentfoundation.org/api/units/99488124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.050119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the sample standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -1613820941292791608, "content_hash": -1613820941292791608, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154605\nhelp.text", "note": "56CsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100058/?format=api", "priority": 100, "id": 99488129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=699a8e677f2818c8", "url": "https://translations.documentfoundation.org/api/units/99488129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.051626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": 8749639485209474966, "content_hash": 8749639485209474966, "location": "04060101.xhp", "context": "04060101.xhp\npar_id121616181037440\nhelp.text", "note": "RACag", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99100082/?format=api", "priority": 100, "id": 99488134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f96cf6c114a47796", "url": "https://translations.documentfoundation.org/api/units/99488134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.052783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -2977119669398935399, "content_hash": -2977119669398935399, "location": "04060101.xhp", "context": "04060101.xhp\npar_id931616181041535\nhelp.text", "note": "r6onB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99100120/?format=api", "priority": 100, "id": 99488139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=56af256f23a5e899", "url": "https://translations.documentfoundation.org/api/units/99488139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.053743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSTDEV(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDDSTDEV(Base de Datos; Riolo Base de Datos; Busca por Criterios)" ], "id_hash": -2597026079391988949, "content_hash": -2597026079391988949, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148661\nhelp.text", "note": "GgdKD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100173/?format=api", "priority": 100, "id": 99488141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5bf5828a596a432b", "url": "https://translations.documentfoundation.org/api/units/99488141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.054826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 3273024958610690874, "content_hash": 3273024958610690874, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149934\nhelp.text", "note": "q4kzs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/99100203/?format=api", "priority": 100, "id": 99488149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/99488149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.056386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 3932075065911071924, "content_hash": 3932075065911071924, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150630\nhelp.text", "note": "SXqfH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100243/?format=api", "priority": 100, "id": 99488157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/99488157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.059327Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3090290711562855157, "content_hash": 3090290711562855157, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150429\nhelp.text", "note": "VRXXy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99100273/?format=api", "priority": 100, "id": 99488162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/99488162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.060981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSTDEVP" ], "previous_source": "", "target": [ "BDDESVESTP" ], "id_hash": -3363240082687938335, "content_hash": -3363240082687938335, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150429\nhelp.text", "note": "FpESx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100310/?format=api", "priority": 100, "id": 99488166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=51535ef6c907b0e1", "url": "https://translations.documentfoundation.org/api/units/99488166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.062219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -1359803832062133205, "content_hash": -1359803832062133205, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145598\nhelp.text", "note": "Cfkn3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100375/?format=api", "priority": 100, "id": 99488175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/99488175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.078518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -5674625038366763722, "content_hash": -5674625038366763722, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541616181205698\nhelp.text", "note": "TjThw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99100449/?format=api", "priority": 100, "id": 99488190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/99488190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.084106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSTDEVP(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDDESVESTP(Base de Datos; Riolo Base de Datos; Busca por Criterios)" ], "id_hash": -6317791940157661886, "content_hash": -6317791940157661886, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149484\nhelp.text", "note": "uGaWp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100475/?format=api", "priority": 100, "id": 99488199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2852b1b41a139d42", "url": "https://translations.documentfoundation.org/api/units/99488199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.087644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -3178976914139084068, "content_hash": -3178976914139084068, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155431\nhelp.text", "note": "jm7Bx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/99100569/?format=api", "priority": 100, "id": 99488209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/99488209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.091374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -5195435835451844799, "content_hash": -5195435835451844799, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148411\nhelp.text", "note": "6eisL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100587/?format=api", "priority": 100, "id": 99488220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/99488220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.095120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 571292261639023166, "content_hash": 571292261639023166, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154794\nhelp.text", "note": "Z2CTY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99100693/?format=api", "priority": 100, "id": 99488229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/99488229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.098926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSUM" ], "previous_source": "", "target": [ "BDSUMA" ], "id_hash": 6500722574647928150, "content_hash": 6500722574647928150, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154794\nhelp.text", "note": "ybMg9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100730/?format=api", "priority": 100, "id": 99488237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=da3734bd4540a556", "url": "https://translations.documentfoundation.org/api/units/99488237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.102731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "" ], "id_hash": -7238116556220802580, "content_hash": -7238116556220802580, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149591\nhelp.text", "note": "pqV9N", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99100761/?format=api", "priority": 100, "id": 99488245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/99488245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.106686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -2425954765439131674, "content_hash": -2425954765439131674, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691616181332088\nhelp.text", "note": "PEAvG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99100767/?format=api", "priority": 100, "id": 99488256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/99488256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.110441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DSUM(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDSUM(Base de Datos; Riolo Base de Datos; Busca por Criterios)" ], "id_hash": 4014294215559015126, "content_hash": 4014294215559015126, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150989\nhelp.text", "note": "LD8jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99100768/?format=api", "priority": 100, "id": 99488264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b7b5a352064cead6", "url": "https://translations.documentfoundation.org/api/units/99488264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.114047Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 5806862272351628538, "content_hash": 5806862272351628538, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152766\nhelp.text", "note": "G9FsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99100769/?format=api", "priority": 100, "id": 99488275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/99488275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.117910Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1895489060518919853, "content_hash": 1895489060518919853, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151312\nhelp.text", "note": "riVB4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99100770/?format=api", "priority": 100, "id": 99488283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/99488283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.121590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8976625786291172676, "content_hash": -8976625786291172676, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3155614\nhelp.text", "note": "YBFb7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99100771/?format=api", "priority": 100, "id": 99488291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/99488291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.125245Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DVAR" ], "previous_source": "", "target": [ "BDVAR" ], "id_hash": -8231158565170443628, "content_hash": -8231158565170443628, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3155614\nhelp.text", "note": "G6ZBW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99100778/?format=api", "priority": 100, "id": 99488301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0dc50ce5411a0a94", "url": "https://translations.documentfoundation.org/api/units/99488301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.128989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 7397650893937352998, "content_hash": 7397650893937352998, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154418\nhelp.text", "note": "QN7LU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99100938/?format=api", "priority": 100, "id": 99488308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/99488308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.132824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -358442623195869881, "content_hash": -358442623195869881, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181465164\nhelp.text", "note": "yytCQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99100981/?format=api", "priority": 100, "id": 99488316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/99488316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.136503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -8110133978835548470, "content_hash": -8110133978835548470, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616181469136\nhelp.text", "note": "gW4LZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99101030/?format=api", "priority": 100, "id": 99488323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/99488323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.138634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DVAR(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDVAR(Base de Datos; Campu de la Base de Datos; Criterios de busca)" ], "id_hash": 5531771093627333732, "content_hash": 5531771093627333732, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156138\nhelp.text", "note": "hLSuf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99101084/?format=api", "priority": 100, "id": 99488337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ccc4cc80466e6c64", "url": "https://translations.documentfoundation.org/api/units/99488337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.149257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -2778539481399798989, "content_hash": -2778539481399798989, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153701\nhelp.text", "note": "TyAAP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99101123/?format=api", "priority": 100, "id": 99488348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/99488348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.155618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3271768490011218818, "content_hash": -3271768490011218818, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153676\nhelp.text", "note": "bRDWF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99101162/?format=api", "priority": 100, "id": 99488355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/99488355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:26.160392Z" } ] }