=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,
},
};const blocksCount = 9;
let shuffledArray = new Array(blocksCount).fill().map((_,i)=>i+1).sort(_=>Math.random()-0.5);=filter(ОКТЯБРЬ!S3:U; ОКТЯБРЬ!V3:V="Партнер 1")=filter(ОКТЯБРЬ!S3:U; ОКТЯБРЬ!V3:V)
=arrayformula(let(
students_lookup; a2:a;
students; Лист2!a2:a;
dates; Лист2!b2:b;
spots; Лист2!c2:c;
find_students_records;lambda(student;join(";";filter(dates&" "&spots;students=student)));
out;byrow(students_lookup;find_students_records);
if(students_lookup="";;out)
))=arrayformula(let(
states;J2:J;
sums;K2:K;
states_;{"Премия"; "Штраф"};
coeffs_;{1 ; -1 };
coeff;lambda(state;ЕСЛИОШИБКА(ВПР(state;{states_\coeffs_};2;0);1));
out;sums*coeff(states);
ЕСЛИ(states="";;out)
))=9,5/24