=query(IMPORTRANGE("https://docs.google.com/spreadsheets...";"'3.0 Сделки GF'!A1:Z"); "select * where Col6 contains 'К1П1'")
function print(a, offset=0){
let out="";
let offsetText = "\t".repeat(offset);
if (Array.isArray(a)){
for(x in a){
out+=`\n${offsetText}${a[x]}`;
};
}else{
for(x in a){
out += `\n${offsetText}${x}:`;
out += print(a[x], offset+1);
};
};
return out;
};
/*
console.log(print(a))
большой 1:
средний 1 1:
маленький 1 1 1
маленький 1 1 2
средний 1 2:
маленький 1 2 1
большой 2:
средний 2 1:
маленький 2 1 1
маленький 2 1 2
маленький 2 1 3
*/
const deleteFirstElemsCount = 2;
let elems = Array.from(document.querySelectorAll("table tr") || []);
elems.forEach((elem,i)=>{
if(i<deleteFirstElemsCount){
elem.remove();
};
});
Условное форматирование - Своя формула
=B1="красный"
int main() {
SetConsoleCP(1251);
SetConsoleOutputCP(1251);
string message;
const int block_size = 8;
int key[block_size];
cout << "Введите текст: ";
cin >> message;
for (int i = 0; i < message.length()%block_size; i++){
message+= "_"; // default symbol
};
cout << "Введите ключ через пробел(размер ключа: " << block_size << " ): ";
for (int i = 0; i < block_size; i++)
{
cin >> key[i];
}
string encrypt_message = "";
int text_length = message.length();
for (int block_index = 0; block_index <= text_length/block_size; block_index++) {
for (int offset = 0; offset < block_size; offset++) {
encrypt_message += message[block_index*block_size + key[offset] - 1];
};
};
cout << "Зашифрованный текст: " << encrypt_message;
_getch();
return 0;
}
const ready = () => {
let elem = document.querySelector('.hi');
elem.innerText = +elem.innerText+100;
};
document.addEventListener("DOMContentLoaded", ready);
const getNums = string => {
return string.split(/[+*\/-]/g).map(num => num.trim);
};
const getNums = string => {
return string.split(/[+*\/-]/g).map(num => num.trim());
};
const nums = getNums(string);
// ...
nums = nums.map(num => romanToArabic(num));