{"text_format":"1","workbook":"xlsx","n_sheets":8,"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":"Отчёт клиенты","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент","Клиент 1","Клиент 2","Клиент 3","Клиент 4","Клиент 5","Итог"]
[null,"Продукт 1",100,null,null,null,150,{"$f":"SUM(C3:G3)","v":250}]
[null,"Продукт 2",50,25,null,null,null,75]
[null,"Продукт 3",20,null,null,null,33,53]
[null,"Продукт 4",50,35,null,null,null,85]
[null,"Продукт 10",60,null,null,null,46,106]
[null,"Продукт 11",null,42,null,null,15,57]
[null,"Продукт 12",null,null,null,100,null,100]
[null,"Продукт 13",50,null,null,120,null,170]
[null,"Продукт 14",15,100,null,null,null,115]
[null,"Продукт 15",null,null,25,null,null,25]
[null,"Продукт 18",35,15,35,null,null,85]
[null,"Продукт 19",null,null,null,null,27,27]
[null,"Продукт 20",65,300,15,null,null,380]
[null,"Продукт 21",null,null,null,null,33,33]
[null,"Продукт 22",null,null,58,null,null,58]
[null,"Продукт 23",null,null,null,15,null,15]
[null,"Продукт 32",null,null,null,15,null,15]
[null,"Продукт 33",28,null,null,null,null,28]
[null,"Продукт 34",null,null,33,null,null,33]
[null,"Итог",{"$f":"SUM(C3:C21)","v":473},{"$f":"SUM(D3:D21)","v":517},166,250,304,{"$f":"SUM(H3:H21)","v":1710}]

{"sheet":"Отчёт магазины","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент","Маг 1","Маг 2","Маг 3","Маг 4","Маг 5","Итог"]
[null,"Продукт 1",100,null,null,null,150,{"$f":"SUM(C3:G3)","v":250}]
[null,"Продукт 2",50,25,null,null,null,75]
[null,"Продукт 5",20,null,null,null,33,53]
[null,"Продукт 6",50,35,null,null,null,85]
[null,"Продукт 7",60,null,null,null,46,106]
[null,"Продукт 8",null,42,null,null,15,57]
[null,"Продукт 9",null,null,null,100,null,100]
[null,"Продукт 10",50,null,null,120,null,170]
[null,"Продукт 14",15,100,null,null,null,115]
[null,"Продукт 15",null,null,25,null,null,25]
[null,"Продукт 16",35,15,35,null,null,85]
[null,"Продукт 17",null,null,null,null,27,27]
[null,"Продукт 18",65,300,15,null,null,380]
[null,"Продукт 19",null,null,null,null,33,33]
[null,"Продукт 23",null,null,58,null,null,58]
[null,"Продукт 24",null,null,null,15,null,15]
[null,"Продукт 25",null,null,null,15,null,15]
[null,"Продукт 26",28,null,null,null,null,28]
[null,"Продукт 27",null,null,33,null,null,33]
[null,"Итог",{"$f":"SUM(C3:C21)","v":473},{"$f":"SUM(D3:D21)","v":517},166,250,304,1710]

{"sheet":"Клиенты по регионам","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"№пп","Клиент","Город"]
[null,1,"Клиент 1","Н.Новгород"]
[null,{"$f":"B3+1","v":2},"Клиент 2","Казань"]
[null,3,"Клиент 3","Н.Новгород"]
[null,4,"Клиент 4","Уфа"]
[null,5,"Клиент 5"]
[null,6,"Маг 1","Уфа"]
[null,7,"Маг 2","Казань"]
[null,8,"Маг 3","Екатеринбург"]
[null,9,"Маг 4"]
[null,10,"Маг 5"]

{"sheet":"Н.Новгород","index":3,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент",null,null,null,null,null,null,null,null,"Итог"]
[null,"Продукт 1",null,null,null,null,null,null,null,null,{"$f":"SUM(C3:J3)","v":0}]
[null,"Продукт 2",null,null,null,null,null,null,null,null,{"$f":"SUM(C4:J4)","v":0}]
[null,"Продукт 3",null,null,null,null,null,null,null,null,0]
[null,"Продукт 4",null,null,null,null,null,null,null,null,0]
[null,"Продукт 5",null,null,null,null,null,null,null,null,0]
[null,"Продукт 6",null,null,null,null,null,null,null,null,0]
[null,"Продукт 7",null,null,null,null,null,null,null,null,0]
[null,"Продукт 8",null,null,null,null,null,null,null,null,0]
[null,"Продукт 9",null,null,null,null,null,null,null,null,0]
[null,"Продукт 10",null,null,null,null,null,null,null,null,0]
[null,"Продукт 11",null,null,null,null,null,null,null,null,0]
[null,"Продукт 12",null,null,null,null,null,null,null,null,0]
[null,"Продукт 13",null,null,null,null,null,null,null,null,0]
[null,"Продукт 14",null,null,null,null,null,null,null,null,0]
[null,"Продукт 15",null,null,null,null,null,null,null,null,0]
[null,"Продукт 16",null,null,null,null,null,null,null,null,0]
[null,"Продукт 17",null,null,null,null,null,null,null,null,0]
[null,"Продукт 18",null,null,null,null,null,null,null,null,0]
[null,"Продукт 19",null,null,null,null,null,null,null,null,0]
[null,"Продукт 20",null,null,null,null,null,null,null,null,0]
[null,"Продукт 21",null,null,null,null,null,null,null,null,0]
[null,"Продукт 22",null,null,null,null,null,null,null,null,0]
[null,"Продукт 23",null,null,null,null,null,null,null,null,0]
[null,"Продукт 24",null,null,null,null,null,null,null,null,0]
[null,"Продукт 25",null,null,null,null,null,null,null,null,0]
[null,"Продукт 26",null,null,null,null,null,null,null,null,0]
[null,"Продукт 27",null,null,null,null,null,null,null,null,0]
[null,"Продукт 28",null,null,null,null,null,null,null,null,0]
[null,"Продукт 29",null,null,null,null,null,null,null,null,0]
[null,"Продукт 30",null,null,null,null,null,null,null,null,0]
[null,"Продукт 31",null,null,null,null,null,null,null,null,0]
[null,"Продукт 32",null,null,null,null,null,null,null,null,0]
[null,"Продукт 33",null,null,null,null,null,null,null,null,0]
[null,"Продукт 34",null,null,null,null,null,null,null,null,0]
[null,"Итог",{"$f":"SUM(C3:C36)","v":0},{"$f":"SUM(D3:D36)","v":0},0,0,0,0,0,0,0]

{"sheet":"Казань","index":4,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент",null,null,null,null,null,null,null,null,"Итог"]
[null,"Продукт 1",null,null,null,null,null,null,null,null,{"$f":"SUM(C3:J3)","v":0}]
[null,"Продукт 2",null,null,null,null,null,null,null,null,{"$f":"SUM(C4:J4)","v":0}]
[null,"Продукт 3",null,null,null,null,null,null,null,null,0]
[null,"Продукт 4",null,null,null,null,null,null,null,null,0]
[null,"Продукт 5",null,null,null,null,null,null,null,null,0]
[null,"Продукт 6",null,null,null,null,null,null,null,null,0]
[null,"Продукт 7",null,null,null,null,null,null,null,null,0]
[null,"Продукт 8",null,null,null,null,null,null,null,null,0]
[null,"Продукт 9",null,null,null,null,null,null,null,null,0]
[null,"Продукт 10",null,null,null,null,null,null,null,null,0]
[null,"Продукт 11",null,null,null,null,null,null,null,null,0]
[null,"Продукт 12",null,null,null,null,null,null,null,null,0]
[null,"Продукт 13",null,null,null,null,null,null,null,null,0]
[null,"Продукт 14",null,null,null,null,null,null,null,null,0]
[null,"Продукт 15",null,null,null,null,null,null,null,null,0]
[null,"Продукт 16",null,null,null,null,null,null,null,null,0]
[null,"Продукт 17",null,null,null,null,null,null,null,null,0]
[null,"Продукт 18",null,null,null,null,null,null,null,null,0]
[null,"Продукт 19",null,null,null,null,null,null,null,null,0]
[null,"Продукт 20",null,null,null,null,null,null,null,null,0]
[null,"Продукт 21",null,null,null,null,null,null,null,null,0]
[null,"Продукт 22",null,null,null,null,null,null,null,null,0]
[null,"Продукт 23",null,null,null,null,null,null,null,null,0]
[null,"Продукт 24",null,null,null,null,null,null,null,null,0]
[null,"Продукт 25",null,null,null,null,null,null,null,null,0]
[null,"Продукт 26",null,null,null,null,null,null,null,null,0]
[null,"Продукт 27",null,null,null,null,null,null,null,null,0]
[null,"Продукт 28",null,null,null,null,null,null,null,null,0]
[null,"Продукт 29",null,null,null,null,null,null,null,null,0]
[null,"Продукт 30",null,null,null,null,null,null,null,null,0]
[null,"Продукт 31",null,null,null,null,null,null,null,null,0]
[null,"Продукт 32",null,null,null,null,null,null,null,null,0]
[null,"Продукт 33",null,null,null,null,null,null,null,null,0]
[null,"Продукт 34",null,null,null,null,null,null,null,null,0]
[null,"Итог",{"$f":"SUM(C3:C36)","v":0},{"$f":"SUM(D3:D36)","v":0},0,0,0,0,0,0,0]

{"sheet":"Уфа","index":5,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент",null,null,null,null,null,null,null,null,"Итог"]
[null,"Продукт 1",null,null,null,null,null,null,null,null,{"$f":"SUM(C3:J3)","v":0}]
[null,"Продукт 2",null,null,null,null,null,null,null,null,{"$f":"SUM(C4:J4)","v":0}]
[null,"Продукт 3",null,null,null,null,null,null,null,null,0]
[null,"Продукт 4",null,null,null,null,null,null,null,null,0]
[null,"Продукт 5",null,null,null,null,null,null,null,null,0]
[null,"Продукт 6",null,null,null,null,null,null,null,null,0]
[null,"Продукт 7",null,null,null,null,null,null,null,null,0]
[null,"Продукт 8",null,null,null,null,null,null,null,null,0]
[null,"Продукт 9",null,null,null,null,null,null,null,null,0]
[null,"Продукт 10",null,null,null,null,null,null,null,null,0]
[null,"Продукт 11",null,null,null,null,null,null,null,null,0]
[null,"Продукт 12",null,null,null,null,null,null,null,null,0]
[null,"Продукт 13",null,null,null,null,null,null,null,null,0]
[null,"Продукт 14",null,null,null,null,null,null,null,null,0]
[null,"Продукт 15",null,null,null,null,null,null,null,null,0]
[null,"Продукт 16",null,null,null,null,null,null,null,null,0]
[null,"Продукт 17",null,null,null,null,null,null,null,null,0]
[null,"Продукт 18",null,null,null,null,null,null,null,null,0]
[null,"Продукт 19",null,null,null,null,null,null,null,null,0]
[null,"Продукт 20",null,null,null,null,null,null,null,null,0]
[null,"Продукт 21",null,null,null,null,null,null,null,null,0]
[null,"Продукт 22",null,null,null,null,null,null,null,null,0]
[null,"Продукт 23",null,null,null,null,null,null,null,null,0]
[null,"Продукт 24",null,null,null,null,null,null,null,null,0]
[null,"Продукт 25",null,null,null,null,null,null,null,null,0]
[null,"Продукт 26",null,null,null,null,null,null,null,null,0]
[null,"Продукт 27",null,null,null,null,null,null,null,null,0]
[null,"Продукт 28",null,null,null,null,null,null,null,null,0]
[null,"Продукт 29",null,null,null,null,null,null,null,null,0]
[null,"Продукт 30",null,null,null,null,null,null,null,null,0]
[null,"Продукт 31",null,null,null,null,null,null,null,null,0]
[null,"Продукт 32",null,null,null,null,null,null,null,null,0]
[null,"Продукт 33",null,null,null,null,null,null,null,null,0]
[null,"Продукт 34",null,null,null,null,null,null,null,null,0]
[null,"Итог",{"$f":"SUM(C3:C36)","v":0},{"$f":"SUM(D3:D36)","v":0},0,0,0,0,0,0,0]

{"sheet":"Екатеринбург","index":6,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ассортимент",null,null,null,null,null,null,null,null,"Итог"]
[null,"Продукт 1",null,null,null,null,null,null,null,null,{"$f":"SUM(C3:J3)","v":0}]
[null,"Продукт 2",null,null,null,null,null,null,null,null,{"$f":"SUM(C4:J4)","v":0}]
[null,"Продукт 3",null,null,null,null,null,null,null,null,0]
[null,"Продукт 4",null,null,null,null,null,null,null,null,0]
[null,"Продукт 5",null,null,null,null,null,null,null,null,0]
[null,"Продукт 6",null,null,null,null,null,null,null,null,0]
[null,"Продукт 7",null,null,null,null,null,null,null,null,0]
[null,"Продукт 8",null,null,null,null,null,null,null,null,0]
[null,"Продукт 9",null,null,null,null,null,null,null,null,0]
[null,"Продукт 10",null,null,null,null,null,null,null,null,0]
[null,"Продукт 11",null,null,null,null,null,null,null,null,0]
[null,"Продукт 12",null,null,null,null,null,null,null,null,0]
[null,"Продукт 13",null,null,null,null,null,null,null,null,0]
[null,"Продукт 14",null,null,null,null,null,null,null,null,0]
[null,"Продукт 15",null,null,null,null,null,null,null,null,0]
[null,"Продукт 16",null,null,null,null,null,null,null,null,0]
[null,"Продукт 17",null,null,null,null,null,null,null,null,0]
[null,"Продукт 18",null,null,null,null,null,null,null,null,0]
[null,"Продукт 19",null,null,null,null,null,null,null,null,0]
[null,"Продукт 20",null,null,null,null,null,null,null,null,0]
[null,"Продукт 21",null,null,null,null,null,null,null,null,0]
[null,"Продукт 22",null,null,null,null,null,null,null,null,0]
[null,"Продукт 23",null,null,null,null,null,null,null,null,0]
[null,"Продукт 24",null,null,null,null,null,null,null,null,0]
[null,"Продукт 25",null,null,null,null,null,null,null,null,0]
[null,"Продукт 26",null,null,null,null,null,null,null,null,0]
[null,"Продукт 27",null,null,null,null,null,null,null,null,0]
[null,"Продукт 28",null,null,null,null,null,null,null,null,0]
[null,"Продукт 29",null,null,null,null,null,null,null,null,0]
[null,"Продукт 30",null,null,null,null,null,null,null,null,0]
[null,"Продукт 31",null,null,null,null,null,null,null,null,0]
[null,"Продукт 32",null,null,null,null,null,null,null,null,0]
[null,"Продукт 33",null,null,null,null,null,null,null,null,0]
[null,"Продукт 34",null,null,null,null,null,null,null,null,0]
[null,"Итог",{"$f":"SUM(C3:C36)","v":0},{"$f":"SUM(D3:D36)","v":0},0,0,0,0,0,0,0]

{"sheet":"Лист1","index":7,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Доброго времени суток. Прошу о помощи, есть несколько вопросов."]
["Есть отчёт на двух листах (во вложенной книге они идут первыми), клиенты на них из разных городов, но в отчёте подписаны только их названия. Поэтому на листе \"Клиенты по регионам\", я вручную, каждому уточняю местоположение, по другому никак. Клиенты в отчёте периодически добавляются. Вопрос первый, можно ли в данной таблице автоматом добавлять нового клиента, оставляя пустой клетку для заполнения города?"]
["Затем эти данные я ВПРом (т.к. ассортимент в отчётах разнится) разношу по листам соответствующих городов, при этом наименования клиентов копирую так же вручную. Вопрос второй. Можно ли на основании листа \"Клиенты по регионам\", автоматом заполнять строку с клиентами соответсвующего города? Количество клиентов 80-150, ассортимент на 250 строк."]
["Знаю что можно и очень много, но не знаю как, спасибо."]