генератор паролей google таблиц

google_docs_pass_generator.txt

=ArrayFormula(let(
 symbols;LAMBDA(from;to;ArrayFormula(JOIN(;СИМВОЛ(SEQUENCE(abs(КОДСИМВ(to)-КОДСИМВ(from))+1;1;МИН(КОДСИМВ(from);КОДСИМВ(to)))))));
 
 alphabetEn;symbols("a";"z")&symbols("A";"Z");
 alphabetRu;symbols("а";"я")&symbols("А";"Я")&"ёЁ";
 specString;"!""№;%:?*()_+@#$%^&*\|/.,-='{}[]<>`~"; 
 numbers;"0123456789";
 
 generate;lambda(fromText;count;join("";ПСТР(fromText;ОКРУГЛВВЕРХ(randarray(count)*ДЛСТР(fromText));1)));
 
 letterEn;lambda(count;ЕСЛИ(count<=0;"";generate(alphabetEn;count)));
 letterRu;lambda(count;ЕСЛИ(count<=0;"";generate(alphabetRu;count))); 
 spec;    lambda(count;ЕСЛИ(count<=0;"";generate(specString;count)));
 numeric; lambda(count;ЕСЛИ(count<=0;"";generate(numbers   ;count)));
 shuffle;lambda(txt;join("";array_constrain(SORT({ПСТР(txt;SEQUENCE(ДЛСТР(txt));1)\RANDARRAY(ДЛСТР(txt))};2;1);ДЛСТР(txt);1)));
 
 passw;lambda(enCount;ruCount;specCount;numsCount;
  shuffle( letterEn(enCount) & letterRu(ruCount) & spec(specCount) & numeric(numsCount) )
 );
 
 passw(5;0;1;2)
))