{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["input_account","Menu","input_balances","array_account","array_balances","Справочник"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"input_account","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,1,3]]}
[]
[null,"Карточка ввода счета"]
[]
[null,"Выбрать компанию",null,"№ счета"]
[null,"Выбрать банк"]
[null,null,"Указать тип счета"]
[null,null,"Комментарий к счету"]
[]
[null,"Инициатор"]
[null,"Дата",{"$f":"TODAY()","v":"2024-10-01"}]
[]
[]
[]
[null,"Банковский счет","Комментарий к счету","Тип счета","Банк","Компания","Инициатор","Дата заведения"]
[null,{"$f":"D5","v":0},{"$f":"D7","v":0},{"$f":"D6","v":0},{"$f":"C5","v":0},{"$f":"C4","v":0},{"$f":"C9","v":0},{"$f":"C10","v":"2024-10-01"}]

{"sheet":"Menu","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"input_balances","index":2,"n_rows":22,"n_cols":20,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ключ","Банковский счет","Дата","Тип счета","Банк","Компания","Материнская","остаток ден.средств"]
[null,"Ввод остатков на счетах компании",null,null,null,null,null,null,null,null,true,1,{"$f":"IF(ISNUMBER($N3),R3&O3&N3,\"\")","v":"Компания 14556640702810200559000000"},{"$f":"_xlfn._xlws.FILTER($C:$C,ISNUMBER($C:$C)=$K$3,\" \")","v":4.0702810200559002E+19},{"$f":"IF(ISNUMBER($N3),$H$7,\"\")","v":"2024-10-01"},{"$f":"IF(ISNUMBER($N3),VLOOKUP($N3,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":"Расчетный"},{"$f":"IF(ISNUMBER($N3),VLOOKUP($N3,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":"ВТБ"},{"$f":"IF(ISNUMBER($N3),VLOOKUP($N3,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":"Компания 1"},{"$f":"IF(ISNUMBER($N3),VLOOKUP($R3,Справочник!$A:$B,2,0),\"\")","v":"Компания 18"},{"$f":"IF(ISNUMBER($N3),VLOOKUP($N3,$C:$H,6,0),\"\")","v":561165}]
[null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(ISNUMBER($N4),R4&O4&N4,\"\")","v":"Компания 14556640702810138000200000"},4.0702810138000204E+19,{"$f":"IF(ISNUMBER($N4),$H$7,\"\")","v":"2024-10-01"},{"$f":"IF(ISNUMBER($N4),VLOOKUP($N4,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":"Расчетный"},{"$f":"IF(ISNUMBER($N4),VLOOKUP($N4,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":"Сбербанк"},{"$f":"IF(ISNUMBER($N4),VLOOKUP($N4,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":"Компания 1"},{"$f":"IF(ISNUMBER($N4),VLOOKUP($R4,Справочник!$A:$B,2,0),\"\")","v":"Компания 18"},{"$f":"IF(ISNUMBER($N4),VLOOKUP($N4,$C:$H,6,0),\"\")","v":56613}]
[null,null,null,null,null,null,null,null,null,null,null,3,"Компания 14556640702810738000200000",4.07028107380002E+19,{"$f":"IF(ISNUMBER($N5),$H$7,\"\")","v":"2024-10-01"},{"$f":"IF(ISNUMBER($N5),VLOOKUP($N5,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":"Специальный"},{"$f":"IF(ISNUMBER($N5),VLOOKUP($N5,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":"Сбербанк"},{"$f":"IF(ISNUMBER($N5),VLOOKUP($N5,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":"Компания 1"},{"$f":"IF(ISNUMBER($N5),VLOOKUP($R5,Справочник!$A:$B,2,0),\"\")","v":"Компания 18"},68741]
[null,null,null,null,null,"остатки на",null,"Дата",null,null,null,4,"",null,"",{"$f":"IF(ISNUMBER($N6),VLOOKUP($N6,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N6),VLOOKUP($N6,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N6),VLOOKUP($N6,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N6),VLOOKUP($R6,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,"Компания","Компания 1",{"$f":"C7&F7","v":"Компания 145562"},null,{"$f":"MAX(array_balances!$C:$C)","v":"2024-09-27"},null,{"$f":"TODAY()","v":"2024-10-01"},null,null,null,5,"",null,"",{"$f":"IF(ISNUMBER($N7),VLOOKUP($N7,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N7),VLOOKUP($N7,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N7),VLOOKUP($N7,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N7),VLOOKUP($R7,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,6,"",null,"",{"$f":"IF(ISNUMBER($N8),VLOOKUP($N8,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N8),VLOOKUP($N8,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N8),VLOOKUP($N8,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N8),VLOOKUP($R8,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,"Названия строк","Банковский счет","Комментарий к счету",null,null,null,"Текущие остатки",null,null,null,7,"",null,"",{"$f":"IF(ISNUMBER($N9),VLOOKUP($N9,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N9),VLOOKUP($N9,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N9),VLOOKUP($N9,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N9),VLOOKUP($R9,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,"ВТБ",4.0702810200559002E+19,"текущий",null,{"$f":"VLOOKUP($D$7&C10,array_balances[],8,0)","v":0},null,561165,null,null,null,8,"",null,"",{"$f":"IF(ISNUMBER($N10),VLOOKUP($N10,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N10),VLOOKUP($N10,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N10),VLOOKUP($N10,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N10),VLOOKUP($R10,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,9,"",null,"",{"$f":"IF(ISNUMBER($N11),VLOOKUP($N11,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N11),VLOOKUP($N11,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N11),VLOOKUP($N11,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N11),VLOOKUP($R11,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,"Сбербанк",4.0702810138000204E+19,"текущий",null,{"$f":"VLOOKUP($D$7&C12,array_balances[],8,0)","v":0},null,56613,null,null,null,10,"",null,"",{"$f":"IF(ISNUMBER($N12),VLOOKUP($N12,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N12),VLOOKUP($N12,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N12),VLOOKUP($N12,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N12),VLOOKUP($R12,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,4.07028107380002E+19,"текущий",null,{"$f":"VLOOKUP($D$7&C13,array_balances[],8,0)","v":0},null,68741,null,null,null,11,"",null,"",{"$f":"IF(ISNUMBER($N13),VLOOKUP($N13,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N13),VLOOKUP($N13,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N13),VLOOKUP($N13,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N13),VLOOKUP($R13,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"VLOOKUP($D$7&C14,array_balances[],8,0)","v":{"$error":"#N/A"}},null,99999,null,null,null,12,"",null,"",{"$f":"IF(ISNUMBER($N14),VLOOKUP($N14,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N14),VLOOKUP($N14,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N14),VLOOKUP($N14,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N14),VLOOKUP($R14,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,13,"",null,"",{"$f":"IF(ISNUMBER($N15),VLOOKUP($N15,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N15),VLOOKUP($N15,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N15),VLOOKUP($N15,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N15),VLOOKUP($R15,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,14,"",null,"",{"$f":"IF(ISNUMBER($N16),VLOOKUP($N16,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N16),VLOOKUP($N16,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N16),VLOOKUP($N16,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N16),VLOOKUP($R16,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,15,"",null,"",{"$f":"IF(ISNUMBER($N17),VLOOKUP($N17,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N17),VLOOKUP($N17,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N17),VLOOKUP($N17,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N17),VLOOKUP($R17,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,16,"",null,"",{"$f":"IF(ISNUMBER($N18),VLOOKUP($N18,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N18),VLOOKUP($N18,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N18),VLOOKUP($N18,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N18),VLOOKUP($R18,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,17,"",null,"",{"$f":"IF(ISNUMBER($N19),VLOOKUP($N19,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N19),VLOOKUP($N19,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N19),VLOOKUP($N19,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N19),VLOOKUP($R19,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,18,"",null,"",{"$f":"IF(ISNUMBER($N20),VLOOKUP($N20,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N20),VLOOKUP($N20,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N20),VLOOKUP($N20,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N20),VLOOKUP($R20,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,19,"",null,"",{"$f":"IF(ISNUMBER($N21),VLOOKUP($N21,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N21),VLOOKUP($N21,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N21),VLOOKUP($N21,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N21),VLOOKUP($R21,Справочник!$A:$B,2,0),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,20,"",null,"",{"$f":"IF(ISNUMBER($N22),VLOOKUP($N22,base_account,MATCH(P$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N22),VLOOKUP($N22,base_account,MATCH(Q$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N22),VLOOKUP($N22,base_account,MATCH(R$2,array_account!$1:$1,0),0),\"\")","v":""},{"$f":"IF(ISNUMBER($N22),VLOOKUP($R22,Справочник!$A:$B,2,0),\"\")","v":""},""]

{"sheet":"array_account","index":3,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Банковский счет","Комментарий к счету","Тип счета","Банк","Компания","Инициатор","Дата заведения"]
[4.0702810138000204E+19,"текущий","Расчетный","Сбербанк","Компания 1","ФИО 1","2024-09-27"]
[4.0702810200559002E+19,"текущий","Расчетный","ВТБ","Компания 1","ФИО 1","2024-09-27"]
[4.07028107380002E+19,"текущий","Специальный","Сбербанк","Компания 1","ФИО 1","2024-09-27"]
[4.0702810138000499E+19,"текущий","Расчетный","Сбербанк","Компания 2","ФИО 1","2024-09-27"]

{"sheet":"array_balances","index":4,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ключ","Банковский счет","Дата","Тип счета","Банк","Компания","Материнская","остаток ден.средств"]
[{"$f":"F2&C2&B2","v":"Компания 24556240702810138000500000"},4.0702810138000499E+19,"2024-09-27","Расчетный","Сбербанк","Компания 2","Компания 18",5000000]
[{"$f":"F3&C3&B3","v":"Компания 24556240702810138000500000"},4.0702810138000499E+19,"2024-09-27","Расчетный","Сбербанк","Компания 2","Компания 18",0]
["Компания 14556240702810200559000000",4.0702810200559002E+19,"2024-09-27","Расчетный","ВТБ","Компания 1","Компания 18",0]
["Компания 14556240702810138000200000",4.0702810138000204E+19,"2024-09-27","Расчетный","Сбербанк","Компания 1","Компания 18",0]
["Компания 14556240702810738000200000",4.07028107380002E+19,"2024-09-27","Специальный","Сбербанк","Компания 1","Компания 18",0]

{"sheet":"Справочник","index":5,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Компания группы","Материнская","Банк","Тип счетов"]
["Компания 1","Компания 18","Сбербанк","Расчетный"]
["Компания 2","Компания 19","ВТБ","Специальный"]
["Компания 3","Компания 20","Промсвязьбанк","Казначейский"]
["Компания 4","Компания 21","Т-Банк"]
["Компания 5","Компания 22","Газпромбанк"]
["Компания 6","Компания 23","РНКБ"]
["Компания 7","Компания 24","Банк Дом.РФ"]
["Компания 8","Компания 25"]
["Компания 9","Компания 26"]
["Компания 10","Компания 27"]
["Компания 11","Компания 28"]
["Компания 12","Компания 29"]
["Компания 13","Компания 30"]
["Компания 14","Компания 31"]
["Компания 15","Компания 32"]
["Компания 16","Компания 33"]
["Компания 17","Компания 34"]