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/it/changes/?format=api&page=40
{ "count": 8481, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/it/changes/?format=api&page=41", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/it/changes/?format=api&page=39", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/112426399/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695451Z", "action": 59, "target": "<input>ARROTONDA.ECCESSO.PRECISO(3,45)</input> restituisce 4.", "id": 50169978, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169978/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426398/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695429Z", "action": 59, "target": "<emph>Peso</emph> (opzionale) è il valore, o un riferimento a una cella che contiene il valore, al cui <emph>Numero</emph> multiplo deve essere arrotondato. Il valore predefinito è 1.", "id": 50169977, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169977/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426397/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695405Z", "action": 59, "target": "ARROTONDA.ECCESSO.PRECISO(Numero [; Peso])", "id": 50169976, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169976/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426396/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695383Z", "action": 59, "target": "Questa funzione calcola risultati uguali alla funzione <link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">ISO.ARROTONDA.ECCESSO</link>.", "id": 50169975, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169975/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426395/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695360Z", "action": 59, "target": "Se il numero è positivo la funzione arrotonda per eccesso (lontano da zero). Se il numero è negativo la funzione arrotonda per difetto (verso lo zero). Il segno di Peso viene ignorato.", "id": 50169974, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169974/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426394/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695338Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_CEIL_MS\">Arrotonda per eccesso il numero al multiplo più prossimo a un valore peso.</ahelp>", "id": 50169973, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169973/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426393/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695315Z", "action": 59, "target": "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\">ARROTONDA.ECCESSO.PRECISO</link></variable>", "id": 50169972, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169972/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426392/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695293Z", "action": 59, "target": "<bookmark_value>ARROTONDA.ECCESSO.PRECISO, funzione</bookmark_value><bookmark_value>Arrotondamento;per eccesso al multiplo più prossimo a peso</bookmark_value>", "id": 50169971, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169971/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426391/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695271Z", "action": 59, "target": "<input>=ARROTONDA.ECCESSO(-45,67; -2; 1)</input> restituisce -46.", "id": 50169970, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169970/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426390/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695248Z", "action": 59, "target": "<input>=ARROTONDA.ECCESSO(-45,67; -2; 0)</input> restituisce -44.", "id": 50169969, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169969/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426389/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695226Z", "action": 59, "target": "<input>=ARROTONDA.ECCESSO(-1,234)</input> restituisce -1.", "id": 50169968, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169968/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426388/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695203Z", "action": 59, "target": "<input>=ARROTONDA.ECCESSO(3,45; 3)</input> restituisce 6.", "id": 50169967, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169967/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426387/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695180Z", "action": 59, "target": "<input>=ARROTONDA.ECCESSO(3,45)</input> restituisce 4.", "id": 50169966, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169966/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426386/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695154Z", "action": 59, "target": "<emph>Modo</emph> (opzionale) è un numero o un riferimento a una cella che contiene un numero. La funzione utilizza <emph>Modo</emph> solo se entrambi <emph>Numero</emph> e <emph>Peso</emph> sono negativi. Se, dunque, <emph>Modo</emph> è specificato e non è uguale a zero, i numeri sono arrotondati per difetto (lontano da zero); se <emph>Modo</emph> è uguale a zero o non viene specificato, i numeri negativi sono arrotondati per eccesso (verso lo zero).", "id": 50169965, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169965/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426385/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695122Z", "action": 59, "target": "<emph>Peso</emph> (opzionale) è il valore, o il riferimento a una cella che contiene il valore, al cui <emph>Numero</emph> deve essere arrotondato. Il valore predefinito è +1 o -1 a seconda del segno di <emph>Numero</emph>.", "id": 50169964, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169964/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426384/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695090Z", "action": 59, "target": "<emph>Numero</emph> è il numero che deve essere arrotondato o un riferimento a una cella che contiene il numero.", "id": 50169963, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169963/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426383/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695067Z", "action": 59, "target": "ARROTONDA.ECCESSO(Numero [; Peso [; Modo]])", "id": 50169962, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169962/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426382/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695044Z", "action": 59, "target": "Se il foglio elettronico viene esportato in Microsoft Excel, la funzione ARROTONDA.ECCESSO esportata alla funzione ARROTONDA.ECCESSO.MAT equivalente, presente da Excel 2013. Se pensate di utilizzare il foglio elettronico con versioni precedenti di Excel, utilizzate invece ARROTONDA.ECCESSO.PRECISO presente da Excel 2010 oppure ARROTONDA.ECCESSO.XCL, la quale viene esportata come funzione ARROTONDA.ECCESSO compatibile con tutte le versioni di Excel.", "id": 50169961, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169961/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426381/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.695021Z", "action": 59, "target": "Se un numero e un peso sono positivi, la funzione arrotonda per eccesso (lontano da zero). se un numero e un peso sono negativi, la direzione dell'arrotondamento viene determinata dal valore del parametro Modo. La funzione restituisce un errore se il numero e il peso presentano segno opposto.", "id": 50169960, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169960/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426380/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694998Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Arrotonda il numero al multiplo più prossimo a un valore peso.</ahelp>", "id": 50169959, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169959/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426379/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694975Z", "action": 59, "target": "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">ARROTONDA.ECCESSO</link></variable>", "id": 50169958, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169958/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426378/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694952Z", "action": 59, "target": "<bookmark_value>ARROTONDA.ECCESSO, funzione</bookmark_value><bookmark_value>Arrotondamento;per eccesso al multiplo più prossimo a peso</bookmark_value>", "id": 50169957, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169957/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426377/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694927Z", "action": 59, "target": "Funzioni di arrotondamento per eccesso", "id": 50169956, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169956/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426376/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694903Z", "action": 59, "target": "Funzioni di arrotondamento per eccesso", "id": 50169955, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169955/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426375/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694880Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS\">Pagina wiki relativa a MEDIA.PIÙ.SE</link> (in inglese).", "id": 50169954, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169954/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426374/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694856Z", "action": 59, "target": "Se E2 = pen, la funzione restituisce 65, perché il collegamento alla cella è sostituito dal suo contenuto.", "id": 50169953, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169953/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426373/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694833Z", "action": 59, "target": "<item type=\"input\">=MEDIA.PIÙ.SE(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50169952, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169952/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426372/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694810Z", "action": 59, "target": "Per cambiare in modo facile un criterio, potete specificarlo in una cella separata, utilizzando un riferimento alla cella all'interno della condizione della funzione MEDIA.PIÙ.SE. Per esempio, la funzione sopra citata può essere riscritta nel modo seguente:", "id": 50169951, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169951/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426371/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694785Z", "action": 59, "target": "Fare riferimento a una cella come criterio", "id": 50169950, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169950/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426370/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694759Z", "action": 59, "target": "Calcola la media per i valori dell'intervallo C2:C6 che corrispondono a tutte le celle dell'intervallo A2:B6 che iniziano con \"pen\" e a tutte le celle dell'intervallo B2:B6, eccetto il suo massimo. Restituisce 65, perché solo la seconda riga soddisfa tutti i criteri.", "id": 50169949, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169949/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426369/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.694703Z", "action": 59, "target": "<item type=\"input\">=MEDIA.PIÙ.SE(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50169948, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169948/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426368/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655643Z", "action": 59, "target": "Calcola la media per i valori dell'intervallo C2:C6 che corrispondono a tutti i valori dell'intervallo B2:B6, eccetto il suo minimo e massimo. Restituisce 127,5, perché la terza e la quinta riga non soddisfano almeno un criterio.", "id": 50169947, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169947/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426367/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655621Z", "action": 59, "target": "<item type=\"input\">=MEDIA.PIÙ.SE(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 50169946, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169946/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426366/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655595Z", "action": 59, "target": "Uso delle espressioni regolari e delle funzioni annidate", "id": 50169945, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169945/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426365/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655555Z", "action": 59, "target": "Calcola la media per i valori dell'intervallo C2:C6 maggiori di 70 e che corrispondono alle celle B2:B6 con valori maggiori o uguali a 20. Restituisce 137,5, perché la seconda e la quinta riga non soddisfano almeno un criterio.", "id": 50169944, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169944/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426364/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655515Z", "action": 59, "target": "<item type=\"input\">=MEDIA.PIÙ.SE(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>", "id": 50169943, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169943/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426363/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655477Z", "action": 59, "target": "Calcola la media per i valori dell'intervallo B2:B6, maggiori o uguali a 20. Restituisce 25, perché la quinta riga non soddisfa il criterio.", "id": 50169942, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169942/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426362/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655439Z", "action": 59, "target": "<item type=\"input\">=MEDIA.PIÙ.SE(B2:B6;B2:B6;\">=20\")</item>", "id": 50169941, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169941/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426361/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655402Z", "action": 59, "target": "Uso semplice", "id": 50169940, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169940/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426360/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655363Z", "action": 59, "target": "<emph>intervallo_media</emph> – argomento obbligatorio. È un intervallo di celle, il nome di un'area indicata, la dicitura di una colonna o di una riga che contiene valori per il calcolo della media.", "id": 50169939, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169939/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426359/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655323Z", "action": 59, "target": "MEDIA.PIÙ.SE(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)", "id": 50169938, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169938/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426358/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655283Z", "action": 59, "target": "<ahelp hid=\".\"><variable id=\"averageifs_des\">Restituisce la media aritmetica di tutte le celle all'interno di un intervallo che soddisfi più condizioni determinate. La funzione MEDIA.PIÙ.SE somma tutti i risultati che corrispondono ai test logici e divide per la quantità dei valori selezionati.</variable></ahelp>", "id": 50169937, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169937/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426357/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655246Z", "action": 59, "target": "Funzione <variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">MEDIA.PIÙ.SE</link></variable>", "id": 50169936, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169936/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426356/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655207Z", "action": 59, "target": "<bookmark_value>MEDIA.PIÙ.SE, funzione</bookmark_value><bookmark_value>Media aritmetica;soddisfare le condizioni</bookmark_value>", "id": 50169935, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169935/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426355/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655167Z", "action": 59, "target": "Funzione MEDIA.PIÙ.SE", "id": 50169934, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169934/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426354/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655126Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">Pagina wiki relativa a MEDIA.SE</link> (in inglese).", "id": 50169933, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169933/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426353/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655086Z", "action": 59, "target": "La funzione ricerca quali celle dall'intervallo B2:A6 sono minori del valore specificato in E2, e calcola la media dei valori corrispondenti dall'intervallo C2:C6. Se E2 = 35, la funzione restituisce 145.", "id": 50169932, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169932/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426352/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655047Z", "action": 59, "target": "<item type=\"input\">=MEDIA.SE(B2:B6;\"<\"&E2;C2:C6)</item>", "id": 50169931, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169931/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426351/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.655009Z", "action": 59, "target": "La funzione ricerca quali celle dall'intervallo A2:A6 contengono una combinazione di caratteri specificati in E2, che iniziano e terminano con un qualsiasi altro numero di altri caratteri, e calcola la media dei valori corrispondenti dall'intervallo B2:B6. Se E2 = book, la funzione restituisce 18,5.", "id": 50169930, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169930/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/112426350/?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/it/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T19:23:01.654970Z", "action": 59, "target": "<item type=\"input\">=MEDIA.SE(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>", "id": 50169929, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/50169929/?format=api" } ] }