Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=131
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Eksempel-databasetabellen som gjev informasjon om gjestane som er inviterte til Joe sin fødselsdagsfest (omtalt ovanfor), bør oppta cellene A1:E10. Innhaldet i cellene A12:E12 må vera identisk med overskriftsetikettane for databasetabellen i cellene A1:E1. Sjå etter at cellene A13:E13 er tomme, bortsett frå celle E13 som skal innehalda «>0» (dette søkjekriteriet er meint å samsvara med alle postane i databasetabellen)." ], "id_hash": 3273024958610690874, "content_hash": 3273024958610690874, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149934\nhelp.text", "note": "q4kzs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527543/?format=api", "priority": 100, "id": 45536261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/45536261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.920981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Set inn formelen <input>=DSTDAV (A1:E10; \"Vekt\"; A12:E13)</input> i ei tom celle ein annan stad på arket for å rekna ut standardavviket for vektene av Joe sine gjester. Verdien 5,5 vert returnert." ], "id_hash": 3932075065911071924, "content_hash": 3932075065911071924, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150630\nhelp.text", "note": "SXqfH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527544/?format=api", "priority": 100, "id": 45536262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/45536262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.922514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDAVP reknar ut standardavviket for populasjonen basert på talverdiane i cellene (felta) i den gjevne kolonnen, for alle radene (databasepostar) som oppfyller dei gjevne søkjevilkåra.</ahelp> Ikkje-numeriske verdiar vert ikkje tekne med." ], "id_hash": -1359803832062133205, "content_hash": -1359803832062133205, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145598\nhelp.text", "note": "Cfkn3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527546/?format=api", "priority": 100, "id": 45536264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/45536264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.927089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Returnerer ein #TAL!-feil viss ingen postar passar med dei gjevne søkjekriteria eller viss det ikkje er numeriske verdiar i cellene i den gjevne kolonnen for dei samsvarande postane." ], "id_hash": -5674625038366763722, "content_hash": -5674625038366763722, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541616181205698\nhelp.text", "note": "TjThw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527547/?format=api", "priority": 100, "id": 45536265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/45536265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.928456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Eksempel-databasetabellen som gjev informasjon om gjestane som er inviterte til Joe sin fødselsdagsfest (omtalt ovanfor), bør oppta cellene A1:E10. Innhaldet i cellene A12:E12 må vera identisk med overskriftsetikettane for databasetabellen i cellene A1:E1. Sjå etter at cellene A13:E13 er tomme, bortsett frå celle E13 som skal innehalda «>0» (dette søkjekriteriet er meint å samsvara med alle postane i databasetabellen)." ], "id_hash": -3178976914139084068, "content_hash": -3178976914139084068, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155431\nhelp.text", "note": "jm7Bx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527548/?format=api", "priority": 100, "id": 45536266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/45536266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.930858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Set inn formelen <input>=DSTDAVP (A1:E10; \"Vekt\"; A12:E13)</input> i ei tom celle ein annan stad på arket for å rekna ut standardavviket for populasjonen for vektene i kg for Joe sine gjester. Verdien 5,18545 vert returnert." ], "id_hash": -5195435835451844799, "content_hash": -5195435835451844799, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148411\nhelp.text", "note": "6eisL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527549/?format=api", "priority": 100, "id": 45536267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/45536267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.932030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUMMER reknar ut summen av alle talverdiar i cellene (felta) i den gjevne kolonnen, for alle rader (databasepostar) som oppfyller dei gjevne søkjevilkåra.</ahelp> Tomme celler eller celler som inneheld teikn som ikkje er tal, vert ikkje rekna med." ], "id_hash": -7238116556220802580, "content_hash": -7238116556220802580, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149591\nhelp.text", "note": "pqV9N", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/45527551/?format=api", "priority": 100, "id": 45536269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/45536269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.935542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Returnerer 0 viss det ikkje finst treff eller viss det ikkje finst talverdiar i cellene i den gjevne kolonnen for dei samsvarande postane." ], "id_hash": -2425954765439131674, "content_hash": -2425954765439131674, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691616181332088\nhelp.text", "note": "PEAvG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527552/?format=api", "priority": 100, "id": 45536270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/45536270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.936695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Eksempel-databasetabellen som gjev informasjon om gjestane som er inviterte til Joe sin fødselsdagsfest (omtalt ovanfor), bør oppta cellene A1:E10. Innhaldet i cellene A12:E12 må vera identisk med overskriftsetikettane for databasetabellen i cellene A1:E1. Sjå etter at cellene A13:E13 er tomme, bortsett frå celle D13 som skal innehalda «>0» (dette søkjekriteriet er meint å samsvara med alle postane i databasetabellen)." ], "id_hash": 5806862272351628538, "content_hash": 5806862272351628538, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152766\nhelp.text", "note": "G9FsG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527553/?format=api", "priority": 100, "id": 45536271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/45536271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.939114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Set inn formelen <input>=DSUMMER(A1:E10; \"Avstand\"; A12:E13)</input> i ei tom celle på ein annan stad på arket for å finna den totale avstanden i meter som alle Joe sine gjestar har til skolen. Verdien 6000 vert returnert." ], "id_hash": 1895489060518919853, "content_hash": 1895489060518919853, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151312\nhelp.text", "note": "riVB4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527554/?format=api", "priority": 100, "id": 45536272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/45536272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.940290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVARIANS reknar ut prøvevariasjonen basert på talverdiane i cellene (felta) i den gjevne kolonnen, for alle radene (databasepostar) som oppfyller dei gjevne søkjevilkåra.</ahelp> Ikkje-numeriske verdiar vert ikkje tekne med." ], "id_hash": 7397650893937352998, "content_hash": 7397650893937352998, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154418\nhelp.text", "note": "QN7LU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527556/?format=api", "priority": 100, "id": 45536274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/45536274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.943766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Returnerer ein #TAL!-feil viss nøyaktig éin post passar med dei gjevne søkjekriteria eller viss det berre er éin numeriske verdi i cellene i den gjevne kolonnen for dei samsvarande postane." ], "id_hash": -358442623195869881, "content_hash": -358442623195869881, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181465164\nhelp.text", "note": "yytCQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/45527557/?format=api", "priority": 100, "id": 45536275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/45536275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.944879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Returnerer 0 viss det ikkje finst treff eller viss det ikkje finst talverdiar i cellene i den gjevne kolonnen for dei samsvarande postane." ], "id_hash": -8110133978835548470, "content_hash": -8110133978835548470, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616181469136\nhelp.text", "note": "gW4LZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527558/?format=api", "priority": 100, "id": 45536276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/45536276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.945977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Eksempel-databasetabellen som gjev informasjon om gjestane som er inviterte til Joe sin fødselsdagsfest (omtalt ovanfor), bør oppta cellene A1:E10. Innhaldet i cellene A12:E12 må vera identisk med overskriftsetikettane for databasetabellen i cellene A1:E1. Sjå etter at cellene A13:E13 er tomme, bortsett frå celle D13 som skal innehalda «>0» (dette søkjekriteriet er meint å samsvara med alle postane i databasetabellen)." ], "id_hash": -2778539481399798989, "content_hash": -2778539481399798989, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153701\nhelp.text", "note": "TyAAP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527559/?format=api", "priority": 100, "id": 45536277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/45536277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.948415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Set inn formelen <input>=DVARIANS(A1:E10; \"Avstand\"; A12:E13)</input> i ei tom celle på ein annan stad på arket for å finna prøvevariansen av dei avstandane i meter som kvar av Joe sine gjester har til skolen. Verdien 193125 vert returnert." ], "id_hash": -3271768490011218818, "content_hash": -3271768490011218818, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153676\nhelp.text", "note": "bRDWF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527560/?format=api", "priority": 100, "id": 45536278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/45536278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.949603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARIANSP reknar ut populasjonsvariasjonen basert på talverdiane i cellene (felta) i den gjevne kolonnen, for alle radene (databasepostar) som oppfyller dei gjevne søkjevilkåra.</ahelp> Ikkje-numeriske verdiar vert ikkje tekne med." ], "id_hash": 167854092933931965, "content_hash": 167854092933931965, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155119\nhelp.text", "note": "nfgrg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527562/?format=api", "priority": 100, "id": 45536280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/45536280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.953120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Returnerer ein #TAL!-feil viss ingen postar passar med dei gjevne søkjekriteria eller viss det ikkje er numeriske verdiar i cellene i den gjevne kolonnen for dei samsvarande postane." ], "id_hash": 5472297574716727343, "content_hash": 5472297574716727343, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181648263\nhelp.text", "note": "ERRmG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527563/?format=api", "priority": 100, "id": 45536281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/45536281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.954241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?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": [ "Eksempel-databasetabellen som gjev informasjon om gjestane som er inviterte til Joe sin fødselsdagsfest (omtalt ovanfor), bør oppta cellene A1:E10. Innhaldet i cellene A12:E12 må vera identisk med overskriftsetikettane for databasetabellen i cellene A1:E1. Sjå etter at cellene A13:E13 er tomme, bortsett frå celle D13 som skal innehalda «>0» (dette søkjekriteriet er meint å samsvara med alle postane i databasetabellen)." ], "id_hash": -8514566768429089441, "content_hash": -8514566768429089441, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147099\nhelp.text", "note": "STcMa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527564/?format=api", "priority": 100, "id": 45536282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=09d62ea2df703d5f", "url": "https://translations.documentfoundation.org/api/units/45536282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.956639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Insert the formula <input>=DVARP(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the population variance of the distances in meters that Joe’s party guests travel to school. The value 171666.67 is returned." ], "previous_source": "", "target": [ "Set inn formelen <input>=DVARIANSP(A1:E10; \"Avstand\"; A12:E13)</input> i ei tom celle på ein annan stad på arket for å finna populasjonsvariansen av dei avstandane i meter som Joe sine gjester har til skolen. Verdien 171666,67 vert returnert." ], "id_hash": 544007683892511232, "content_hash": 544007683892511232, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147322\nhelp.text", "note": "8puR2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527565/?format=api", "priority": 100, "id": 45536283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=878cb41b317f0200", "url": "https://translations.documentfoundation.org/api/units/45536283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:53:44.957835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_FEST\">Returnerer eit tal som tekst med eit bestemt tal på desimalar og valfrie tusenskiljeteikn.</ahelp>" ], "id_hash": 4564917541115818924, "content_hash": 4564917541115818924, "location": "04060110.xhp", "context": "04060110.xhp\npar_id641617285271044\nhelp.text", "note": "k4v7r", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45547896/?format=api", "priority": 100, "id": 45548706, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=bf59d851532873ac", "url": "https://translations.documentfoundation.org/api/units/45548706/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.771366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])" ], "previous_source": "", "target": [ "FAST(Tal; [Desimalar = 2[; IngenTusenskiljeteikn = USANN]])" ], "id_hash": 3164445034953640442, "content_hash": 3164445034953640442, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3147567\nhelp.text", "note": "vGkWA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547897/?format=api", "priority": 100, "id": 45548707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=abea5dfe4ba909fa", "url": "https://translations.documentfoundation.org/api/units/45548707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.772890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Decimals</emph> (optional) refers to the number of decimal places to be displayed. If <literal>Decimals</literal> is negative, <literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places to the left from the decimal point. If <literal>Decimals</literal> is a fraction, it is truncated actually ignoring what is the closest integer." ], "previous_source": "", "target": [ "<emph>Desimalar</emph> (valfri) er kor mange desimalar som skal visast. Viss<literal>Desimalar</literal> er negativ, vert <literal>Tal</literal> avrunda til ABS (<literal>Desimalar</literal>) (absolutte desimalar) til venstre for desimalteiknet. Viss <literal>Desimalar</literal> er ein brøk, vert berre heile talet brukt." ], "id_hash": -5788830311505226717, "content_hash": -5788830311505226717, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3156322\nhelp.text", "note": "5zSz5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/45547899/?format=api", "priority": 100, "id": 45548709, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2fa9f18091b79423", "url": "https://translations.documentfoundation.org/api/units/45548709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.775697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FAST(123456,789;;Sann)</item> returnerer 123456,79 som ein tekststreng." ], "id_hash": -2868271223510780221, "content_hash": -2868271223510780221, "location": "04060110.xhp", "context": "04060110.xhp\npar_id5282143\nhelp.text", "note": "eo6wB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547901/?format=api", "priority": 100, "id": 45548711, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=5831da84db2a36c3", "url": "https://translations.documentfoundation.org/api/units/45548711/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.780055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FAST(12345,6789;-2)</item> returnerer 12,300 som ein tekststreng." ], "id_hash": 4714624350173270364, "content_hash": 4714624350173270364, "location": "04060110.xhp", "context": "04060110.xhp\npar_id21617202293406\nhelp.text", "note": "U8QaS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547902/?format=api", "priority": 100, "id": 45548712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c16db5de097c115c", "url": "https://translations.documentfoundation.org/api/units/45548712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.781920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FAST(1234567,89;-3;1)</item> returnerer 12135000 som ein tekststreng." ], "id_hash": -6001427891539983682, "content_hash": -6001427891539983682, "location": "04060110.xhp", "context": "04060110.xhp\npar_id161617202295558\nhelp.text", "note": "iqSth", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547903/?format=api", "priority": 100, "id": 45548713, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2cb6a5212ba342be", "url": "https://translations.documentfoundation.org/api/units/45548713/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.783400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string." ], "previous_source": "", "target": [ "<item type=\"input\">=FAST(12345,789;3/4)</item> returnerer 12.346 som ein tekststreng." ], "id_hash": -300381556576810427, "content_hash": -300381556576810427, "location": "04060110.xhp", "context": "04060110.xhp\npar_id451617286696878\nhelp.text", "note": "NmXWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547904/?format=api", "priority": 100, "id": 45548714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7bd4d490d7290a45", "url": "https://translations.documentfoundation.org/api/units/45548714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:45:22.784936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCOT-uttrykket</alt></image>" ], "id_hash": 2870055230817627947, "content_hash": 2870055230817627947, "location": "func_imcot.xhp", "context": "func_imcot.xhp\npar_id311713256011430\nhelp.text", "note": "fCe4Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549690/?format=api", "priority": 100, "id": 45550336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=a7d47c06b6a2ef2b", "url": "https://translations.documentfoundation.org/api/units/45550336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.058086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSC-uttrykket</alt></image>" ], "id_hash": 6846648871920688632, "content_hash": 6846648871920688632, "location": "func_imcsc.xhp", "context": "func_imcsc.xhp\npar_id13510198901485\nhelp.text", "note": "FV9Gz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549691/?format=api", "priority": 100, "id": 45550337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=df042edfb8a95df8", "url": "https://translations.documentfoundation.org/api/units/45550337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.065454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSCH-uttrykket</alt></image>" ], "id_hash": -4113507468801013442, "content_hash": -4113507468801013442, "location": "func_imcsch.xhp", "context": "func_imcsch.xhp\npar_id195151657917534\nhelp.text", "note": "FFqZK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549692/?format=api", "priority": 100, "id": 45550338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=46e9e2c05d33093e", "url": "https://translations.documentfoundation.org/api/units/45550338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.072162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSEC-uttrykket</alt></image>" ], "id_hash": -1400137934339393315, "content_hash": -1400137934339393315, "location": "func_imsec.xhp", "context": "func_imsec.xhp\npar_id17543461310594\nhelp.text", "note": "y62eA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549693/?format=api", "priority": 100, "id": 45550339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6c91b5f78b26b8dd", "url": "https://translations.documentfoundation.org/api/units/45550339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.078700Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSECH-uttrykket</alt></image>" ], "id_hash": -5814494115358634925, "content_hash": -5814494115358634925, "location": "func_imsech.xhp", "context": "func_imsech.xhp\npar_id74572850718840\nhelp.text", "note": "CVDgc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549694/?format=api", "priority": 100, "id": 45550340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=2f4ec46899730c53", "url": "https://translations.documentfoundation.org/api/units/45550340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.085549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>" ], "previous_source": "", "target": [ "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN-uttrykket</alt></image>" ], "id_hash": -166417047733024562, "content_hash": -166417047733024562, "location": "func_imtan.xhp", "context": "func_imtan.xhp\npar_id25021317131239\nhelp.text", "note": "ujidB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549695/?format=api", "priority": 100, "id": 45550341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7db0c493a94dc8ce", "url": "https://translations.documentfoundation.org/api/units/45550341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:35:09.104214Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DTAL.PÅ-funksjonen</bookmark_value><bookmark_value>telja rader; med talverdiar</bookmark_value>" ], "id_hash": -4283882863480380764, "content_hash": -4283882863480380764, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150882\nhelp.text", "note": "KBZPC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612149/?format=api", "priority": 100, "id": 45631905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/45631905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.409582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DTAL.PÅA-funksjonen</bookmark_value><bookmark_value>datapostar; telja i Calc databasar</bookmark_value><bookmark_value>telja rader; med numeriske eller alfanumeriske verdiar</bookmark_value>" ], "id_hash": -1670587375212033188, "content_hash": -1670587375212033188, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3156123\nhelp.text", "note": "tGFyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612150/?format=api", "priority": 100, "id": 45631906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/45631906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.421586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DHENT-funksjonen</bookmark_value><bookmark_value>celleinnhald;søkje i Calc-databasar</bookmark_value><bookmark_value>søkje;celleinnhald i Calc-databasar</bookmark_value>" ], "id_hash": 746247400884686976, "content_hash": 746247400884686976, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3147256\nhelp.text", "note": "GasLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612151/?format=api", "priority": 100, "id": 45631907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/45631907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.434957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DMAKS-funksjonen</bookmark_value><bookmark_value>maksimumsverdiar i Calc databasar</bookmark_value><bookmark_value>søkje;maksimumsverdiar i kolonnar</bookmark_value>" ], "id_hash": 6067482821286383874, "content_hash": 6067482821286383874, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3149766\nhelp.text", "note": "rB9Ek", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612152/?format=api", "priority": 100, "id": 45631908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=d434077aa38f5102", "url": "https://translations.documentfoundation.org/api/units/45631908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.450210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DMAKS-funksjonen</bookmark_value><bookmark_value>maksimumsverdiar i Calc databasar</bookmark_value><bookmark_value>søkje;maksimumsverdiar i kolonnar</bookmark_value>" ], "id_hash": -7229204091064779011, "content_hash": -7229204091064779011, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159141\nhelp.text", "note": "CnaXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612153/?format=api", "priority": 100, "id": 45631909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1bacb52e5f487efd", "url": "https://translations.documentfoundation.org/api/units/45631909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.461713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DGJENNOMSNITT-funksjonen</bookmark_value> <bookmark_value>gjennomsnitt; i Calc databasar</bookmark_value> <bookmark_value>rekne ut;gjennomsnitt i Calc databasar</bookmark_value>" ], "id_hash": -2870387606319136727, "content_hash": -2870387606319136727, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154274\nhelp.text", "note": "XEu9j", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612154/?format=api", "priority": 100, "id": 45631910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/45631910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.472221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DPRODUKT-funksjonen</bookmark_value> <bookmark_value>multiplisera;celleinnhald i Calc-databasar</bookmark_value>" ], "id_hash": 8547260052556627769, "content_hash": 8547260052556627769, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159269\nhelp.text", "note": "6fcFr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/45612155/?format=api", "priority": 100, "id": 45631911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/45631911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.481256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DSTDAV-funksjonen</bookmark_value><bookmark_value>standardavvik i databasar;basert på ein stikkprøve</bookmark_value>" ], "id_hash": 8527548628645799969, "content_hash": 8527548628645799969, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148462\nhelp.text", "note": "KsVCV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612156/?format=api", "priority": 100, "id": 45631912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/45631912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.491591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DSTDAVP-funksjonen</bookmark_value> <bookmark_value>standardavvik i databasar;basert på populasjonar</bookmark_value>" ], "id_hash": 3090290711562855157, "content_hash": 3090290711562855157, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150429\nhelp.text", "note": "VRXXy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45612157/?format=api", "priority": 100, "id": 45631913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/45631913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.502650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DSUMMER-funksjonen</bookmark_value> <bookmark_value>rekna ut;summar i Calc-databasar</bookmark_value> <bookmark_value>summar;celler i Calc-databasar</bookmark_value>" ], "id_hash": 571292261639023166, "content_hash": 571292261639023166, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154794\nhelp.text", "note": "Z2CTY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612158/?format=api", "priority": 100, "id": 45631914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/45631914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.511632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DVARIANS-funksjonen</bookmark_value> <bookmark_value>variansar;baserte på stikkprøvar</bookmark_value>" ], "id_hash": -8976625786291172676, "content_hash": -8976625786291172676, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3155614\nhelp.text", "note": "YBFb7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612159/?format=api", "priority": 100, "id": 45631915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/45631915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.521040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DVARIANSP-funksjonen</bookmark_value><bookmark_value>variansar;baseret på populasjonar</bookmark_value>" ], "id_hash": -1507646871452132173, "content_hash": -1507646871452132173, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3153880\nhelp.text", "note": "7FWS4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612160/?format=api", "priority": 100, "id": 45631916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6b13c328845ddcb3", "url": "https://translations.documentfoundation.org/api/units/45631916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:04.533297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Loddrett søking med tilvising til tilstøytane celler til høgre.</ahelp> Denne funksjonen kontrollerer om ein bestemt verdi finst i den første kolonnen i ei matrise. Funksjonen returnerer så verdien i den same rada i kolonnen som er namngjeven i <emph>Indeks</emph>. Viss parameteren <emph>Sortert</emph> manglar eller er sett til SANN, vert dataa sorterte i stigande rekkjefølgje. Viss det eksakte <emph>oppslag</emph> ikkje vart funne, vert den siste verdien som er mindre enn kriteriet returnert. Viss <emph>Sortert</emph> er sett til USANN eller null, må der vera eit eksakt samanfall, elles vert feilen <emph>Feil: Verdi ikkje tilgjengeleg (#I/T)</emph> returnert. Med ein verdi på null treng dataa ikkje vera sorterte stigande." ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/45612171/?format=api", "priority": 100, "id": 45631917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/45631917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.642236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "=FINN.RAD(Oppslag; Matrise; Indeks[; SortertOmrådeOppslag])" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612172/?format=api", "priority": 100, "id": 45631918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/45631918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.643565Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." ], "previous_source": "", "target": [ "<emph>Oppslag</emph> er verdien av kva type som helst som det vert sett etter i den første kolonnen i matrisa." ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612173/?format=api", "priority": 100, "id": 45631919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/45631919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.644662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "<emph>SortertOmråde</emph> er ein valfri parameter som indikerer om den første kolonnen i matrisa inneheld områdegrenser i staden for vanlege verdiar. I denne modusen returnerer uttrykket verdien i rada med den første kolonnen som har ein verdi som er lik eller mindre enn <emph>oppslag</emph>. Den kan for eksempel innehalde datoar når nokre MVA-verdiar er endra når verdiane representerer startdatoar for ein periode når ein bestemt MVA-verdi var brukt. Eit søk etter ein dato som manglar i den første matrisekolonnen, men er mellom nokre eksisterande grensedatoar, vil returnera den lågaste av dei slik at det er råd å finna dataa som høver til den søkte datoen. Bruk USANN eller null viss den første kolonnen ikkje inneheld områdegrenser. Når denne parameteren er sann eller ikkje gjeven, må den første kolonnen i matrisen vera <emph>sortert i stigande rekkjefølgje</emph>. Ei søk i sorterte kolonnar går mykje raskare og funksjonen returnerer alltid ein verdi, sjølv om søkjeverdien ikkje samsvarar nøyaktig, viss han er større enn den lågaste verdien i den sorterte lista. I usorterte lister må søkjeverdien samsvara nøyaktig elles vil funksjonen returnera #I/T med meldinga <emph> Feil: verdi ikkje tilgjengeleg </emph>." ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/45612174/?format=api", "priority": 100, "id": 45631920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/45631920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.648427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "SAMANLIKNA(Søk; Søkjetabell[; Type])" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612175/?format=api", "priority": 100, "id": 45631921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/45631921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.675598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "<emph>Søk</emph> er den verdien det skal søkjast etter i matrisa bygd opp av ei rad eller ein kolonne." ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612176/?format=api", "priority": 100, "id": 45631922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/45631922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:10:10.676697Z" } ] }