Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/el/changes/?format=api&page=41
{ "count": 8511, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/changes/?format=api&page=42", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/changes/?format=api&page=40", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/112093368/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200767Z", "action": 59, "target": "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">CEILING</link></variable>", "id": 49838369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093364/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200723Z", "action": 59, "target": "<bookmark_value>Συνάρτηση CEILING</bookmark_value><bookmark_value>στρογγυλοποίηση;έως πολλαπλάσια σημαντικότητας</bookmark_value>", "id": 49838368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093361/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200680Z", "action": 59, "target": "Συναρτήσεις οροφής (Ceiling)", "id": 49838367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093358/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200635Z", "action": 59, "target": "Συναρτήσεις οροφής (Ceiling)", "id": 49838366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093354/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200590Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS\">Σελίδα βίκι AVERAGEIFS</link>.", "id": 49838365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093341/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200544Z", "action": 59, "target": "Αν E2 = pen, η συνάρτηση επιστρέφει 65, επειδή ο σύνδεσμος στο κελί αντικαθίσταται με το περιεχόμενό του.", "id": 49838364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093339/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200495Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49838363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093336/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200450Z", "action": 59, "target": "Αν χρειάζεται να αλλάξετε ένα κριτήριο εύκολα, μπορεί να θέλετε να το ορίσετε σε ένα ξεχωριστό κελί και να χρησιμοποιήσετε μια αναφορά σε αυτό το κελί στη συνθήκη της συνάρτησης AVERAGEIF. Παραδείγματος χάρη, η παραπάνω συνάρτηση μπορεί να ξαναγραφτεί ως εξής:", "id": 49838362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093334/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200407Z", "action": 59, "target": "Αναφορά σε ένα κελί ως κριτήριο", "id": 49838361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093330/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200361Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές στην περιοχή C2:C6 που αντιστοιχούν σε όλα τα κελιά της περιοχής A2:A6 που αρχίζουν με \"pen\" και σε όλα τα κελιά της περιοχής B2:B6, εκτός από το μέγιστό του. Επιστρέφει 65, επειδή μόνο η δεύτερη γραμμή ικανοποιεί όλα τα κριτήρια.", "id": 49838360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093326/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.200293Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49838359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093323/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147820Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές στην περιοχή C2:C6 που αντιστοιχούν σε όλες τις τιμές της περιοχής B2:B6, εκτός από την ελάχιστη και τη μέγιστη. Επιστρέφει 127,5, επειδή η δεύτερη και η πέμπτη γραμμή δεν ικανοποιούν τουλάχιστον ένα κριτήριο.", "id": 49838358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093320/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147798Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49838357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093317/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147777Z", "action": 59, "target": "Χρήση κανονικών παραστάσεων και ένθετων συναρτήσεων", "id": 49838356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093315/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147755Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές στην περιοχή C2:C6 που είναι μεγαλύτερες από 70 και αντιστοιχεί στα κελιά B2:B6 με τιμές μεγαλύτερες από ή ίσες με 20. Επιστρέφει 137,5, επειδή η δεύτερη και η πέμπτη γραμμή δεν ικανοποιούν τουλάχιστον ένα κριτήριο.", "id": 49838355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093311/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147733Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>", "id": 49838354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093306/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147711Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές στην περιοχή B2:B6 που είναι μεγαλύτερες από ή ίσες με 20. Επιστρέφει 25, επειδή η πέμπτη γραμμή δεν ικανοποιεί το κριτήριο.", "id": 49838353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093303/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147689Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>", "id": 49838352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093301/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147667Z", "action": 59, "target": "Απλή χρήση", "id": 49838351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093297/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147645Z", "action": 59, "target": "<emph>Περιοχή_συνάρτησης</emph> – απαιτούμενο όρισμα. Είναι μια περιοχή κελιών, ένα όνομα μιας ονοματισμένης περιοχής, ή μια ετικέτα μιας στήλης ή μιας γραμμής που περιέχουν τιμές για τον υπολογισμό του μέσου όρου.", "id": 49838350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093295/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147624Z", "action": 59, "target": "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)", "id": 49838349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093293/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147602Z", "action": 59, "target": "<ahelp hid=\".\"><variable id=\"averageifs_des\">Επιστρέφει τον αριθμητικό μέσο όλων των κελιών σε μια περιοχή που ικανοποιεί δεδομένα πολλαπλά κριτήρια. Η συνάρτηση AVERAGEIFS αθροίζει όλα τα αποτελέσματα που ταιριάζουν τις λογικές δοκιμές και διαιρεί αυτό το άθροισμα με το μέγεθος των επιλεγμένων τιμών.</variable></ahelp>", "id": 49838348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093291/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147580Z", "action": 59, "target": "Συνάρτηση <variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable>", "id": 49838347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093102/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147558Z", "action": 59, "target": "<bookmark_value>συνάρτηση AVERAGEIFS</bookmark_value> <bookmark_value>αριθμητικός μέσος;ικανοποίηση συνθηκών</bookmark_value>", "id": 49838346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093097/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147536Z", "action": 59, "target": "Συνάρτηση AVERAGEIFS", "id": 49838345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093094/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147514Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">Σελίδα βίκι AVERAGEIF</link>.", "id": 49838344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093087/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147492Z", "action": 59, "target": "Η συνάρτηση αναζητά ποια κελιά από την περιοχή B2:A6 είναι μικρότερα από την τιμή που ορίστηκε στο E2 και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή C2:C6. Αν E2 = 35, η συνάρτηση επιστρέφει 145.", "id": 49838343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838343/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093082/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147471Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>", "id": 49838342, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838342/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093075/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147449Z", "action": 59, "target": "Η συνάρτηση αναζητά ποια κελιά από την περιοχή A2:A6 περιέχουν συνδυασμό χαρακτήρων που ορίζονται στο E2 αρχίζοντας και τελειώνοντας με οποιονδήποτε αριθμό άλλων χαρακτήρων και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή B2:B6. Αν E2 = book, η συνάρτηση επιστρέφει 18,5.", "id": 49838341, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838341/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093071/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147426Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>", "id": 49838340, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838340/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093068/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147404Z", "action": 59, "target": "Αν χρειάζεται να αλλάξετε ένα κριτήριο εύκολα, μπορεί να θέλετε να το ορίσετε σε ένα ξεχωριστό κελί και να χρησιμοποιήσετε μια αναφορά σε αυτό το κελί στη συνθήκη της συνάρτησης AVERAGEIF.", "id": 49838339, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838339/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093064/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147383Z", "action": 59, "target": "Αναφορά σε ένα κελί ως ένα κριτήριο", "id": 49838338, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093055/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147361Z", "action": 59, "target": "Η συνάρτηση αναζητά ποια κελιά από την περιοχή A2:A6 περιέχουν το “book” αρχίζοντας και τελειώνοντας με οποιονδήποτε αριθμό άλλων χαρακτήρων και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή B2:B6. Επιστρέφει 18,5, επειδή μόνο η τρίτη και τέταρτη γραμμή συμμετέχουν στον υπολογισμό.", "id": 49838337, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838337/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093043/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147338Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>", "id": 49838336, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838336/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093039/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147317Z", "action": 59, "target": "Η συνάρτηση αναζητά ποια κελιά από την περιοχή A2:A6 ξεκινούν με “pen” και τελειώνουν με οποιονδήποτε αριθμό άλλων χαρακτήρων και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή B2:B6. Επιστρέφει 27,5, επειδή τώρα και το “pencil” ικανοποιεί τη συνθήκη και οι δυο, πρώτη και δεύτερη γραμμή, συμμετέχουν στον υπολογισμό.", "id": 49838335, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093032/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147294Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>", "id": 49838334, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838334/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093028/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147272Z", "action": 59, "target": "Η συνάρτηση αναζητά ποια κελιά από την περιοχή A2:A6 περιέχουν μόνο τη λέξη “pen” και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή B2:B6. Επιστρέφει 35, επειδή μόνο η δεύτερη γραμμή συμμετέχει στον υπολογισμό. Η αναζήτηση εκτελείται στην περιοχή A2:A6, αλλά οι τιμές επιστρέφονται από την περιοχή B2:B6.", "id": 49838333, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838333/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093024/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147251Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>", "id": 49838332, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093021/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147229Z", "action": 59, "target": "Χρήση κανονικών παραστάσεων", "id": 49838331, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838331/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093018/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147207Z", "action": 59, "target": "Η συνάρτηση αναζητά ποιες τιμές από 35 την περιοχή B2:B6 είναι μικρότερες από τη δεύτερη μεγάλη τιμή στην περιοχή B2:B6 και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή C2:C6. Επιστρέφει 180, επειδή μόνο η τέταρτη γραμμή συμμετέχει στον υπολογισμό.", "id": 49838330, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838330/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093014/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147185Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>", "id": 49838329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093009/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147163Z", "action": 59, "target": "Η συνάρτηση αναζητά ποιες τιμές από την περιοχή B2:B6 είναι μεγαλύτερες από την ελάχιστη τιμή στην περιοχή B2:B6 και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή C2:C6, Επιστρέφει 113,3, επειδή η τέταρτη γραμμή (όπου υπάρχει η ελάχιστη τιμή στην περιοχή B2:B6) δεν συμμετέχει στον υπολογισμό.", "id": 49838328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093005/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147141Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>", "id": 49838327, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838327/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112093000/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147119Z", "action": 59, "target": "Η συνάρτηση αναζητά ποιες τιμές είναι μικρότερες από 35 στην περιοχή B2:B6 και υπολογίζει τον μέσο όρο των αντίστοιχων τιμών από την περιοχή C2:C6. Επιστρέφει 145, επειδή η δεύτερη σειρά δεν συμμετέχει στον υπολογισμό.", "id": 49838326, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838326/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092995/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147097Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>", "id": 49838325, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838325/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092992/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147075Z", "action": 59, "target": "Χρήση του Περιοχή_μέσου_όρου", "id": 49838324, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838324/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092987/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147052Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές της ίδιας περιοχής που είναι μεγαλύτερες από την πρώτη ελάχιστη τιμή της περιοχής. Επιστρέφει 25, επειδή η πρώτη ελάχιστη τιμή (η τέταρτη γραμμή) δεν συμμετέχει στον υπολογισμό.", "id": 49838323, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838323/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092976/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147031Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>", "id": 49838322, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838322/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092971/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.147009Z", "action": 59, "target": "Υπολογίζει τον μέσο όρο για τιμές της ίδιας περιοχής που είναι μικρότερες από τη μέγιστη τιμή αυτής της περιοχής. Επιστρέφει 19, επειδή η μέγιστη τιμή (η δεύτερη γραμμή) δεν συμμετέχει στον υπολογισμό.", "id": 49838321, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838321/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112092968/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/el/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:09:53.146987Z", "action": 59, "target": "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 49838320, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/49838320/?format=api" } ] }