(getFullYear()-1700)
=ARRAYFORMULA(let(
author; "@ProgrammerForever";
dates; hook!A2:A;
type; hook!B2:B;
duration; hook!G2:G;
lookupdates;A2:A;
timestampTodate;lambda(unixTimestamp;(unixTimestamp/86400000)+ДАТА(1970;1;1));
toSqldate;lambda(d;ТЕКСТ(d;"yyyy-mm-dd"));
remove_header;lambda(data;query({data};"SELECT * OFFSET 1";0));
data;remove_header(query({toSqldate(timestampTodate(dates))\duration};"SELECT Col1, Sum(Col2) GROUP BY Col1"));
out;ЕСЛИОШИБКА(ВПР(toSqldate(lookupdates);data;2;0));
ЕСЛИ(lookupdates="";;out)
))частота_ноты*(1+2^(1/12) )частота_ноты*(1-2^(1/12) )
=arrayformula(if(A:A="";;ВПР(A:A&B:B;{Справочник!A:A&Справочник!B:B\Справочник!C:C};2;0)))let options = {
method: "POST",
headers: {
'Client-Id':'000',
'API-key':'111',
'accept': 'application/json',
},
payload: {
"filter": {
"date": {
"from": "2023-10-01T00:00:00.000Z",
"to": "2023-10-31T00:00:00.000Z",
},
"operation_type": [],
"posting_number": "",
"transaction_type": "all",
},
"page": 1,
"page_size": 1000,
},
};