Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=13
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110928993/?format=api", "priority": 100, "id": 112428908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=57bab84c423bec1c", "url": "https://translations.documentfoundation.org/api/units/112428908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.227898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110929033/?format=api", "priority": 100, "id": 112428909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c47131f1de63b5b9", "url": "https://translations.documentfoundation.org/api/units/112428909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.229181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110929078/?format=api", "priority": 100, "id": 112428910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/112428910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.230262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DAVERAGE" ], "previous_source": "", "target": [ "" ], "id_hash": 8325687557178170627, "content_hash": 8325687557178170627, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154274\nhelp.text", "note": "dQciw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110929126/?format=api", "priority": 100, "id": 112428911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f38ac8b8cc7e9d03", "url": "https://translations.documentfoundation.org/api/units/112428911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.231239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110929160/?format=api", "priority": 100, "id": 112428912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6a16cd5bc7740501", "url": "https://translations.documentfoundation.org/api/units/112428912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.232188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110929212/?format=api", "priority": 100, "id": 112428913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e55cfa1e0fbc3fd4", "url": "https://translations.documentfoundation.org/api/units/112428913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.233154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DAVERAGE(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": 6939834441930249975, "content_hash": 6939834441930249975, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150710\nhelp.text", "note": "PPkBD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110929260/?format=api", "priority": 100, "id": 112428914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e04f3ea7f74616f7", "url": "https://translations.documentfoundation.org/api/units/112428914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.234100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110929289/?format=api", "priority": 100, "id": 112428915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d86ec3f663f6525b", "url": "https://translations.documentfoundation.org/api/units/112428915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.235057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110929326/?format=api", "priority": 100, "id": 112428916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=992e2a4eefc3a66e", "url": "https://translations.documentfoundation.org/api/units/112428916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.236070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110929377/?format=api", "priority": 100, "id": 112428917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/112428917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.237042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DPRODUCT" ], "previous_source": "", "target": [ "" ], "id_hash": 3613951182874316910, "content_hash": 3613951182874316910, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3159269\nhelp.text", "note": "gvW9Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110929420/?format=api", "priority": 100, "id": 112428918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b22755740ad3906e", "url": "https://translations.documentfoundation.org/api/units/112428918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.238009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110929464/?format=api", "priority": 100, "id": 112428919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=20a59f17ed58cabe", "url": "https://translations.documentfoundation.org/api/units/112428919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.239060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110929527/?format=api", "priority": 100, "id": 112428920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2b829a2212e935ee", "url": "https://translations.documentfoundation.org/api/units/112428920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.240068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DPRODUCT(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": -2550060692960315488, "content_hash": -2550060692960315488, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154854\nhelp.text", "note": "PgAsj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110929546/?format=api", "priority": 100, "id": 112428921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5c9c5d4f8069f7a0", "url": "https://translations.documentfoundation.org/api/units/112428921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.241096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110929609/?format=api", "priority": 100, "id": 112428922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dcf38e2d1fd1ae0c", "url": "https://translations.documentfoundation.org/api/units/112428922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.242089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110930102/?format=api", "priority": 100, "id": 112428923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4034061f206bda65", "url": "https://translations.documentfoundation.org/api/units/112428923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.243188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110930159/?format=api", "priority": 100, "id": 112428924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/112428924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.244218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSTDEV" ], "previous_source": "", "target": [ "" ], "id_hash": 3411649162921893682, "content_hash": 3411649162921893682, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3148462\nhelp.text", "note": "EvGNP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110930213/?format=api", "priority": 100, "id": 112428925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=af589cd68637df32", "url": "https://translations.documentfoundation.org/api/units/112428925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.245286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110930273/?format=api", "priority": 100, "id": 112428926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=699a8e677f2818c8", "url": "https://translations.documentfoundation.org/api/units/112428926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.246256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110930347/?format=api", "priority": 100, "id": 112428927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f96cf6c114a47796", "url": "https://translations.documentfoundation.org/api/units/112428927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.247297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110930401/?format=api", "priority": 100, "id": 112428928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=56af256f23a5e899", "url": "https://translations.documentfoundation.org/api/units/112428928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.248304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSTDEV(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": -2597026079391988949, "content_hash": -2597026079391988949, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148661\nhelp.text", "note": "GgdKD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110930472/?format=api", "priority": 100, "id": 112428929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5bf5828a596a432b", "url": "https://translations.documentfoundation.org/api/units/112428929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.249282Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/110930533/?format=api", "priority": 100, "id": 112428930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/112428930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.250267Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110930594/?format=api", "priority": 100, "id": 112428931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/112428931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.251372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110930650/?format=api", "priority": 100, "id": 112428932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/112428932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.252395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSTDEVP" ], "previous_source": "", "target": [ "" ], "id_hash": -3363240082687938335, "content_hash": -3363240082687938335, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150429\nhelp.text", "note": "FpESx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110930693/?format=api", "priority": 100, "id": 112428933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51535ef6c907b0e1", "url": "https://translations.documentfoundation.org/api/units/112428933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.253363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110930712/?format=api", "priority": 100, "id": 112428934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/112428934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.254316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110930764/?format=api", "priority": 100, "id": 112428935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/112428935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.255431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSTDEVP(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": -6317791940157661886, "content_hash": -6317791940157661886, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149484\nhelp.text", "note": "uGaWp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110930804/?format=api", "priority": 100, "id": 112428936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2852b1b41a139d42", "url": "https://translations.documentfoundation.org/api/units/112428936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.256549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/110930833/?format=api", "priority": 100, "id": 112428937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/112428937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.257621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110930866/?format=api", "priority": 100, "id": 112428938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/112428938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.258816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110930906/?format=api", "priority": 100, "id": 112428939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/112428939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.260886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSUM" ], "previous_source": "", "target": [ "" ], "id_hash": 6500722574647928150, "content_hash": 6500722574647928150, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3154794\nhelp.text", "note": "ybMg9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110930922/?format=api", "priority": 100, "id": 112428940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=da3734bd4540a556", "url": "https://translations.documentfoundation.org/api/units/112428940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.263380Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110930939/?format=api", "priority": 100, "id": 112428941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/112428941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.265512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110930950/?format=api", "priority": 100, "id": 112428942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/112428942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.267506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DSUM(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": 4014294215559015126, "content_hash": 4014294215559015126, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150989\nhelp.text", "note": "LD8jB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110930996/?format=api", "priority": 100, "id": 112428943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b7b5a352064cead6", "url": "https://translations.documentfoundation.org/api/units/112428943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.269553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110931045/?format=api", "priority": 100, "id": 112428944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/112428944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.271552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110931105/?format=api", "priority": 100, "id": 112428945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/112428945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.273024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110931161/?format=api", "priority": 100, "id": 112428946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/112428946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.274026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DVAR" ], "previous_source": "", "target": [ "" ], "id_hash": -8231158565170443628, "content_hash": -8231158565170443628, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3155614\nhelp.text", "note": "G6ZBW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110931207/?format=api", "priority": 100, "id": 112428947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0dc50ce5411a0a94", "url": "https://translations.documentfoundation.org/api/units/112428947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.275012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110931225/?format=api", "priority": 100, "id": 112428948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/112428948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.276035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110931261/?format=api", "priority": 100, "id": 112428949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/112428949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.277120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110931292/?format=api", "priority": 100, "id": 112428950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/112428950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.278168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DVAR(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "" ], "id_hash": 5531771093627333732, "content_hash": 5531771093627333732, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156138\nhelp.text", "note": "hLSuf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110931326/?format=api", "priority": 100, "id": 112428951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ccc4cc80466e6c64", "url": "https://translations.documentfoundation.org/api/units/112428951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.279274Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110931358/?format=api", "priority": 100, "id": 112428952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/112428952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.280277Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110931388/?format=api", "priority": 100, "id": 112428953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/112428953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.281435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1507646871452132173, "content_hash": -1507646871452132173, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3153880\nhelp.text", "note": "7FWS4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110931438/?format=api", "priority": 100, "id": 112428954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6b13c328845ddcb3", "url": "https://translations.documentfoundation.org/api/units/112428954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.282457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DVARP" ], "previous_source": "", "target": [ "" ], "id_hash": 7750041785969186120, "content_hash": 7750041785969186120, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3153880\nhelp.text", "note": "XpcPC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110931452/?format=api", "priority": 100, "id": 112428955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eb8dadf15f209548", "url": "https://translations.documentfoundation.org/api/units/112428955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.283581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 167854092933931965, "content_hash": 167854092933931965, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155119\nhelp.text", "note": "nfgrg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110931475/?format=api", "priority": 100, "id": 112428956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/112428956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.284543Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 5472297574716727343, "content_hash": 5472297574716727343, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181648263\nhelp.text", "note": "ERRmG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110931497/?format=api", "priority": 100, "id": 112428957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/112428957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.285543Z" } ] }