{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Строка","гражд. База","в наличии","убираем","нет дел","админ. база","в наличии","убираем","нет дел","уголовн. база","в наличии","убираем","нет дел",null,null,null,null,null,null,null,null,null,null,"Order:=xlDescending"]
[{"$f":"ROW()-1&\")\"","v":"1)"},1,1,7,null,1,{"$f":"F2","v":1},3,1,1,2,1,1]
[{"$f":"ROW()-1&\")\"","v":"2)"},2,2,10,null,4,2,5,2,4,5,2,2]
[{"$f":"ROW()-1&\")\"","v":"3)"},3,3,14,null,6,12,6,5,6,11,4,5,null,null,null,"красными отмечены, что повторы должны убираться вручную"]
[{"$f":"ROW()-1&\")\"","v":"4)"},4,4,18,null,12,22,12,7,12,24,32,7]
[{"$f":"ROW()-1&\")\"","v":"5)"},5,5,21,null,24,34,19,9,24,35,34,9,"можно кнопку Duplicate доработать, если не окрасил написать - Дубликатов нет"]
[{"$f":"ROW()-1&\")\"","v":"6)"},6,6,null,null,32,43,234,11,32,45,45,11]
[{"$f":"ROW()-1&\")\"","v":"7)"},7,8,null,null,34,65,435,34,34,54,543,23,null,null,null,null,"кнопка удаляет окончательно из столбца повторы"]
[{"$f":"ROW()-1&\")\"","v":"8)"},8,9,null,null,43,67,null,35,43,65,null,34,null,null,null,null,"но почему то это делает очень долго, когда выбираешь весь столбец"]
[{"$f":"ROW()-1&\")\"","v":"9)"},9,10,null,null,65,76,null,43,67,67,null,35,null,"су1","Итого","Итого","Итого","Итого","Остаток"]
[{"$f":"ROW()-1&\")\"","v":"10)"},10,11,null,null,67,123,null,45,76,76,null,43,null,"Гражд ","B","C","D","E","A-D"]
[{"$f":"ROW()-1&\")\"","v":"11)"},11,12,null,null,76,345,null,54,123,123,null,45,null,"Админ","F","G","H","I","F-I"]
[{"$f":"ROW()-1&\")\"","v":"12)"},12,18,null,null,123,435,null,234,345,345,null,54,null,"Угоовка ","J","K","L","M","J-M"]
[{"$f":"ROW()-1&\")\"","v":"13)"},13,null,null,null,345,456,null,434,456,534,null,65,null,null,"Проверка на дубликаты и составление списка существующих в наличии"]
[{"$f":"ROW()-1&\")\"","v":"14)"},14,null,null,null,456,534,null,453,534,645,null,null,null,null,"нужно прописать количество подсчитанных из A-L в таблицу "]
[{"$f":"ROW()-1&\")\"","v":"15)"},15,null,null,null,534,645,null,1245,645,654,null,null,null,null,"нужна кнопка числовой сортировки для выбранного столбца"]
[{"$f":"ROW()-1&\")\"","v":"16)"},16,null,null,null,645,654,null,null,654,null,null,null,null,null,"в D, H, L автоматически прописать номера оставшиеся"]
[{"$f":"ROW()-1&\")\"","v":"17)"},17,null,null,null,654,657,null,null,657]
[{"$f":"ROW()-1&\")\"","v":"18)"},18,null,null,null,657,745,null,null,745,null,null,null,null,null,"правильный вариант без макросов B-E "]
[{"$f":"ROW()-1&\")\"","v":"19)"},19,null,null,null,745,1324,null,null,1324]
[{"$f":"ROW()-1&\")\"","v":"20)"},20,null,null,null,1324,null,null,null,6456]
[{"$f":"ROW()-1&\")\"","v":"21)"},21,null,null,null,6456,null,null,null,7656]
[{"$f":"ROW()-1&\")\"","v":"22)"},22,null,null,null,7656,null,null,null,12323]
[{"$f":"ROW()-1&\")\"","v":"23)"},23,null,null,null,12323,null,null,null,34643]
[{"$f":"ROW()-1&\")\"","v":"24)"},24,null,null,null,34643,null,null,null,53465]
[{"$f":"ROW()-1&\")\"","v":"25)"},25,null,null,null,53465]
[{"$f":"ROW()-1&\")\"","v":"26)"},26]
[{"$f":"ROW()-1&\")\"","v":"27)"},27]
[{"$f":"ROW()-1&\")\"","v":"28)"},28]
[{"$f":"ROW()-1&\")\"","v":"29)"},29]
[{"$f":"ROW()-1&\")\"","v":"30)"},30]
[{"$f":"ROW()-1&\")\"","v":"31)"},31]
[{"$f":"ROW()-1&\")\"","v":"32)"},32]
[{"$f":"ROW()-1&\")\"","v":"33)"},33]
[{"$f":"ROW()-1&\")\"","v":"34)"},34]
[{"$f":"ROW()-1&\")\"","v":"35)"},35]
[{"$f":"ROW()-1&\")\"","v":"36)"},36]
[{"$f":"ROW()-1&\")\"","v":"37)"},37]
[{"$f":"ROW()-1&\")\"","v":"38)"}]
[{"$f":"ROW()-1&\")\"","v":"39)"}]
[{"$f":"ROW()-1&\")\"","v":"40)"}]
[{"$f":"ROW()-1&\")\"","v":"41)"}]