{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"Лист1","index":0,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,"Перечень квартир",null,null,null,null,null,"Сколько квартир в доме",null,null,null,"Должно быть отображеное какие квартиры отсвтсвуют."]
["Город","Улица","Дом","Квартира",null,null,"Город","Улица","Дом","Количество квартир",null,"Не хватает"]
["Витебск","Ленина",1,1,null,null,"Витебск","Ленина",1,20,{"$f":"MAX(($H3&$I3=$B$3:$B$99&$C$3:$C$99)*$D$3:$D$99)","v":20},"10, 15",{"$f":"NotIn(G3,H3,I3,J3)","v":"10, 15"}]
["Витебск","Ленина",1,2,null,null,"Улан-Уде","Мира",2,20,{"$f":"MAX(($H4&$I4=$B$3:$B$99&$C$3:$C$99)*$D$3:$D$99)","v":20},"5, 8",{"$f":"NotIn(G4,H4,I4,J4)","v":"5, 8, 16"}]
["Витебск","Ленина",1,3,null,null,"Омск","Пушкина",3,20,{"$f":"MAX(($H5&$I5=$B$3:$B$99&$C$3:$C$99)*$D$3:$D$99)","v":20},null,""]
["Витебск","Ленина",1,4,null,null,"Курск","Лермонтова",4,20,{"$f":"MAX(($H6&$I6=$B$3:$B$99&$C$3:$C$99)*$D$3:$D$99)","v":20},"6, 7, 8","6, 7, 8"]
["Витебск","Ленина",1,5]
["Витебск","Ленина",1,6]
["Витебск","Ленина",1,7]
["Витебск","Ленина",1,8]
["Витебск","Ленина",1,9]
["Витебск","Ленина",1,11]
["Витебск","Ленина",1,12]
["Витебск","Ленина",1,13]
["Витебск","Ленина",1,14]
["Витебск","Ленина",1,16]
["Витебск","Ленина",1,17]
["Витебск","Ленина",1,18]
["Витебск","Ленина",1,19]
["Витебск","Ленина",1,20]
["Улан-Уде","Мира",2,1]
["Улан-Уде","Мира",2,2]
["Улан-Уде","Мира",2,3]
["Улан-Уде","Мира",2,4]
["Улан-Уде","Мира",2,6]
["Улан-Уде","Мира",2,7]
["Улан-Уде","Мира",2,9]
["Улан-Уде","Мира",2,10]
["Улан-Уде","Мира",2,11]
["Улан-Уде","Мира",2,12]
["Улан-Уде","Мира",2,13]
["Улан-Уде","Мира",2,14]
["Улан-Уде","Мира",2,15]
["Улан-Уде","Мира",2,17]
["Улан-Уде","Мира",2,18]
["Улан-Уде","Мира",2,19]
["Улан-Уде","Мира",2,20]
["Омск","Пушкина",3,1]
["Омск","Пушкина",3,2]
["Омск","Пушкина",3,3]
["Омск","Пушкина",3,4]
["Омск","Пушкина",3,5]
["Омск","Пушкина",3,6]
["Омск","Пушкина",3,7]
["Омск","Пушкина",3,8]
["Омск","Пушкина",3,9]
["Омск","Пушкина",3,10]
["Омск","Пушкина",3,11]
["Омск","Пушкина",3,12]
["Омск","Пушкина",3,13]
["Омск","Пушкина",3,14]
["Омск","Пушкина",3,15]
["Омск","Пушкина",3,16]
["Омск","Пушкина",3,17]
["Омск","Пушкина",3,18]
["Омск","Пушкина",3,19]
["Омск","Пушкина",3,20]
["Курск","Лермонтова",4,1]
["Курск","Лермонтова",4,2]
["Курск","Лермонтова",4,3]
["Курск","Лермонтова",4,4]
["Курск","Лермонтова",4,5]
["Курск","Лермонтова",4,9]
["Курск","Лермонтова",4,10]
["Курск","Лермонтова",4,11]
["Курск","Лермонтова",4,12]
["Курск","Лермонтова",4,13]
["Курск","Лермонтова",4,14]
["Курск","Лермонтова",4,15]
["Курск","Лермонтова",4,16]
["Курск","Лермонтова",4,17]
["Курск","Лермонтова",4,18]
["Курск","Лермонтова",4,19]
["Курск","Лермонтова",4,20]