Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 8598,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=44",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/changes/?format=api&page=42",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781053/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791860Z",
            "action": 59,
            "target": "Ús d'expressions regulars i funcions imbricades",
            "id": 49522952,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522952/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781049/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791839Z",
            "action": 59,
            "target": "Calcula la mitjana dels valors de l'interval C2C6 que són majors de 70 i corresponen a cel·les de B2B6 amb valors majors o iguals a 20. Retorna 1377.5 perquè la segona i cinquena fila no compleixen almenys un criteri.",
            "id": 49522951,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522951/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781045/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791818Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANA(A1:A50)</item>",
            "id": 49522950,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522950/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781040/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791796Z",
            "action": 59,
            "target": "Calcula la suma de valors de l'interval B2:B6 majors o igual a 20. Retorna 75, perquè la cinquena fila no compleixen el criteri.",
            "id": 49522949,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522949/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781035/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791774Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANA(A1:A50)</item>",
            "id": 49522948,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522948/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781031/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791753Z",
            "action": 59,
            "target": "Ús simple",
            "id": 49522947,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522947/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781024/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791731Z",
            "action": 59,
            "target": "<unk>GA Funcrange</emph> - argument requerit. És un interval de cel·les un nom d'un interval amb nom o una etiqueta d'una columna o una fila que conté valors per calcular la mitjana.",
            "id": 49522946,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522946/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781019/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791709Z",
            "action": 59,
            "target": "AVERAGEIFS( <embedvar href=\"text/scalc/01/exdatastatfunc.xhp#args\" markup=\"ignore\"/>)",
            "id": 49522945,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522945/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781013/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791688Z",
            "action": 59,
            "target": "<unk>GA<variable id=\"averageifsdes\">retorna la mitjana aritmètica de totes les cel·les en un interval que satisfà múltiples criteris donats. La funció AVERAGEIFS suma tots els resultats que coincideixen amb les proves lògiques i divideix aquesta suma per la quantitat de valors seleccionats.</variable></ahelp>",
            "id": 49522944,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522944/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781009/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791665Z",
            "action": 59,
            "target": "<variable id=\"averageifs_head\">funció <link href=\"text/scalc/01/func_averageifs.xhp\">MITJANASICONJUNT</link></variable>",
            "id": 49522943,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522943/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781005/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791644Z",
            "action": 59,
            "target": "<bookmark_value>funció DESVMITJ</bookmark_value><bookmark_value>mitjanes;funcions estadístiques</bookmark_value>",
            "id": 49522942,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522942/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111781001/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791622Z",
            "action": 59,
            "target": "funció MITJANASI",
            "id": 49522941,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522941/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780998/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791600Z",
            "action": 59,
            "target": "",
            "id": 49522940,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522940/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780994/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791578Z",
            "action": 59,
            "target": "La funció cerca quines cel·les de l'interval B2B6 són inferiors al valor especificat a E2 i calcula la mitjana dels valors corresponents des de l'interval C2C6. Si E2 = 35 la funció retorna 145.",
            "id": 49522939,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522939/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780991/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791556Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\"<\"&E2;C2:C6)</item>",
            "id": 49522938,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522938/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780986/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791535Z",
            "action": 59,
            "target": "La funció cerca quines cel·les de l'interval A2A6 contenen una combinació de caràcters especificats a E2 començant i acabant amb qualsevol quantitat d'altres caràcters i calcula la mitjana dels valors corresponents des de l'interval B2B6. Si E2 = llibre la funció retorna 18.5.",
            "id": 49522937,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522937/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780983/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791514Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>",
            "id": 49522936,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522936/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780979/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791491Z",
            "action": 59,
            "target": "Si necessiteu canviar un criteri fàcilment podeu especificar-lo en una cel·la separada i utilitzar una referència a aquesta cel·la en la condició de la funció AVERAGEIF.",
            "id": 49522935,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522935/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780974/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791469Z",
            "action": 59,
            "target": "Referència a una cel·la com a criteri",
            "id": 49522934,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522934/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780969/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791448Z",
            "action": 59,
            "target": "La funció cerca quines cel·les de l'interval A2A6 contenen «llibre» començant i acabant amb qualsevol quantitat d'altres caràcters i calcula la mitjana dels valors corresponents des de l'interval B2B6. Retorna 18.5 perquè només les files tercera i quarta participen en el càlcul.",
            "id": 49522933,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522933/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780964/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791427Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(A2:A6;\".*book.*\";B2:B6)</item>",
            "id": 49522932,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522932/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780960/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791405Z",
            "action": 59,
            "target": "La funció cerca quines cel·les de l'interval A2A6 comencen amb «pen» acabant amb qualsevol quantitat d'altres caràcters i calcula la mitjana dels valors corresponents des de l'interval B2B6. Retorna 27.5 perquè ara també «pencil» satisfà la condició i les files primera i segona participen en el càlcul.",
            "id": 49522931,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522931/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780956/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791384Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(A2:A6;\"pen.*\";B2:B6)</item>",
            "id": 49522930,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522930/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780953/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791363Z",
            "action": 59,
            "target": "La funció cerca quines cel·les de l'interval A2A6 només contenen la paraula «pen» i calcula la mitjana dels valors corresponents des de l'interval B2B6. Retorna 35 perquè només participa la segona fila en el càlcul. La cerca es realitza a l'interval A2A6 però els valors es retornen des de l'interval B2B6.",
            "id": 49522929,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522929/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780952/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791341Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(A2:A6;\"pen\";B2:B6)</item>",
            "id": 49522928,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522928/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780950/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791319Z",
            "action": 59,
            "target": "Ús d'expressions regulars",
            "id": 49522927,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522927/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780941/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791296Z",
            "action": 59,
            "target": "La funció cerca quins valors de l'interval B2B6 són inferiors al segon valor gran de l'interval B2B6 i calcula la mitjana dels valors corresponents de l'interval C2C6. Retorna 180 perquè només participa la quarta fila en el càlcul.",
            "id": 49522926,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522926/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780936/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791274Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\"<\"&GRAN(B2:B6;2);C2:C6)</item>",
            "id": 49522925,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522925/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780931/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791253Z",
            "action": 59,
            "target": "La funció cerca quins valors de l'interval B2B6 són més grans que el valor mínim en l'interval B2B6 i calcula la mitjana dels valors corresponents des de l'interval C2C6. Retorna 113.3 perquè la quarta fila (on hi ha el valor mínim en l'interval B2B6) no participa en el càlcul.",
            "id": 49522924,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522924/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780928/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791231Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANA(A1:A50)</item>",
            "id": 49522923,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522923/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780920/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791209Z",
            "action": 59,
            "target": "La funció cerca quins valors són inferiors a 35 en l'interval B2B6 i calcula la mitjana dels valors corresponents des de l'interval C2C6. Retorna 145 perquè la segona fila no participa en el càlcul.",
            "id": 49522922,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522922/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780915/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791188Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\"<35\";C2:C6)</item>",
            "id": 49522921,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522921/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780912/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791163Z",
            "action": 59,
            "target": "Ús de la mitjanaRange",
            "id": 49522920,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522920/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780903/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791142Z",
            "action": 59,
            "target": "Calcula la mitjana dels valors del mateix interval que són més grans que el primer valor més petit d'aquest interval. Retorna 25 perquè el primer valor més petit (la quarta fila) no participa en el càlcul.",
            "id": 49522919,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522919/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780899/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791120Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\">\"&PETIT(B2:B6;1))</item>",
            "id": 49522918,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522918/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780895/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791098Z",
            "action": 59,
            "target": "Calcula la mitjana dels valors del mateix interval que són inferiors al valor màxim d'aquest interval. Retorna 19 perquè el valor més gran (la segona fila) no participa en el càlcul.",
            "id": 49522917,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522917/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780890/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791077Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\"<\"&MAX(B2:B6))</item>",
            "id": 49522916,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522916/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780886/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791055Z",
            "action": 59,
            "target": "Calcula la mitjana dels valors de l'interval B2B6 que són inferiors a 35. Retorna 19 perquè la segona fila no participa en el càlcul.",
            "id": 49522915,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522915/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780882/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791034Z",
            "action": 59,
            "target": "<item type=\"input\">=MITJANASI(B2:B6;\"<35\")</item>",
            "id": 49522914,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522914/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780878/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.791013Z",
            "action": 59,
            "target": "Ús simple",
            "id": 49522913,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522913/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780872/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790991Z",
            "action": 59,
            "target": "Si una cel·la en un interval de valors per a calcular la mitjana està buida o conté la funció de text AVERAGESI ignora aquesta cel·la.<br/>Si tot l'interval està buit només conté text o tots els valors de l'interval no satisfan la condició (o qualsevol combinació d'aquests) la funció retorna l'error #DIV/0!.",
            "id": 49522912,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522912/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780868/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790967Z",
            "action": 59,
            "target": "Si no s'especifica el <emph>Average</emph> <emph>Range</emph> s'utilitza tant per al càlcul de la mitjana com per a la cerca d'acord amb la condició. Si s'especifica <emph>AverageRange</emph> l'interval <emph></emph> només s'utilitza per a la prova de condició mentre que <emph>AverageRange</emph> s'utilitza per al càlcul mitjà.",
            "id": 49522911,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522911/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780862/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790945Z",
            "action": 59,
            "target": "<unk>GA Average</emph> – opcional. És un rang de valors per calcular la mitjana.",
            "id": 49522910,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522910/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780853/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790923Z",
            "action": 59,
            "target": "Interval de <emph></emph> - argument requerit. Una matriu un nom d'interval anomenat o una etiqueta d'una columna o una fila que conté números per a la mitjana o números o text per a la condició.",
            "id": 49522909,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522909/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780848/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790901Z",
            "action": 59,
            "target": "AVERAGEIF(Range; Criterion [; MitjanaRange ])",
            "id": 49522908,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522908/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780843/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790880Z",
            "action": 59,
            "target": "<unk>GA<variable id=\"averageifdes\">retorna la mitjana aritmètica de totes les cel·les en un interval que satisfà una condició donada. La funció AVERAGEIF suma tots els resultats que coincideixen amb la prova lògica i divideix aquesta suma per la quantitat de valors seleccionats.</variable></ahelp>",
            "id": 49522907,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522907/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780839/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790858Z",
            "action": 59,
            "target": "<variable id=\"averageif_head\">funció <link href=\"text/scalc/01/func_averageif.xhp\">MITJANASI</link></variable>",
            "id": 49522906,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522906/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780830/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790837Z",
            "action": 59,
            "target": "<bookmark_value>funció MITJANASI</bookmark_value>  <bookmark_value>mitjana aritmètica;condicionament</bookmark_value>",
            "id": 49522905,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522905/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780826/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790816Z",
            "action": 59,
            "target": "funció MITJANASI",
            "id": 49522904,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522904/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/111780823/?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/ca/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:56:30.790794Z",
            "action": 59,
            "target": "",
            "id": 49522903,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/49522903/?format=api"
        }
    ]
}