{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Главная","Полнота","Письмо","Список","Отчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Кому"]
[]
[null,"Тема",{"$f":"Письмо!B54","v":"Отчет за Июль на 23.08"}]
[]
[null,"Фаил"]

{"sheet":"Полнота","index":1,"n_rows":26,"n_cols":81,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,26,4,26],[2,25,4,25],[18,42,18,44]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"отсутствует Покуп.с/с собственного ПА (физические лица)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Письмо!C59","v":"С:\\7 Июль 2017\\Отчет за Июль на 23.08"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СВО, ХМАО, ЯНАО",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Письмо!C60","v":"С:\\Для других\\Отчет за Июль на 23.08"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал"," Факт"," % выполнение плана","Рейтинг"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал1",30000,0.74940558649640721,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал2",50000,0.74877561002368676,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал3",6000,0.72852255162016044,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал4",8000,0.65343525001175029,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал5",2000,0.59793822929362295,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Филиал6",1000,0.49056973300930257,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Общий итог",{"$f":"SUM(AP6:AP11)","v":97000},0.683658981922318]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"июл.17","июл.17","июл.17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел","Руководитель"," План"," Факт"," % выполнения плана","Рейтинг"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 1","Иванов",1000,{"$f":"AQ21*AS21","v":760.45130795608191},0.76045130795608196,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 2","Петров",2000,{"$f":"AQ22*AS22","v":1276.1515029108216},0.63807575145541084,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 3","Сидоров",30000,14128.620092702238,0.47095400309007462,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 4","Григорьев",4000,801.08796758589051,0.20027199189647263,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 5","Васечкин",500,82.869228322761685,0.16573845664552336,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Отдел 6","_",50,-3.5039551388725431E-5,-7.0079102777450859E-7,6]

{"sheet":"Письмо","index":2,"n_rows":60,"n_cols":23,"rows_kept":60,"cut":false,"hidden":false,"merged":[[21,3,21,6],[33,1,33,8],[38,1,38,8],[42,1,42,8],[44,1,44,8],[35,1,35,8]]}
[{"$f":"B54","v":"Отчет за Июль на 23.08"}]
["Формирование письма:"]
[]
["Кому?","aaa@bbb.ru"]
["Копия","aaa@bbb.ru"]
[null,{"$f":"CONCATENATE(CONCATENATE(\"полнота отражения за \",TEXT(T20,\"ММММ\"), \" \",TEXT(TODAY(),\"ГГГГ\")))","v":"полнота отражения за Июль 2017"}]
[null,"Добрый день!"]
[null,{"$f":"CONCATENATE(\"Высылаю отчет за \", TEXT(EOMONTH(TODAY(),-1), \"ММММ\"),\" на утро \",TEXT(TODAY(),\"ДД.ММ.ГГГГ\"))","v":"Высылаю отчет за Июль на утро 23.08.2017"}]
[null,{"$f":"CONCATENATE(\"Итог составляет \",TEXT(D18,\"0%\"),\" :\")","v":"Итог составляет 68% :"}]
[]
[null,{"$f":"Полнота!AO5","v":"Филиал"},{"$f":"Полнота!AP5","v":" Факт"},{"$f":"Полнота!AQ5","v":" % выполнение плана"},{"$f":"Полнота!AR5","v":"Рейтинг"}]
[null,{"$f":"Полнота!AO6","v":"Филиал1"},{"$f":"Полнота!AP6","v":30000},{"$f":"Полнота!AQ6","v":0.74940558649640721},{"$f":"Полнота!AR6","v":1}]
[null,{"$f":"Полнота!AO7","v":"Филиал2"},{"$f":"Полнота!AP7","v":50000},{"$f":"Полнота!AQ7","v":0.74877561002368676},{"$f":"Полнота!AR7","v":2}]
[null,{"$f":"Полнота!AO8","v":"Филиал3"},{"$f":"Полнота!AP8","v":6000},{"$f":"Полнота!AQ8","v":0.72852255162016044},{"$f":"Полнота!AR8","v":3}]
[null,{"$f":"Полнота!AO9","v":"Филиал4"},{"$f":"Полнота!AP9","v":8000},{"$f":"Полнота!AQ9","v":0.65343525001175029},{"$f":"Полнота!AR9","v":4}]
[null,{"$f":"Полнота!AO10","v":"Филиал5"},{"$f":"Полнота!AP10","v":2000},{"$f":"Полнота!AQ10","v":0.59793822929362295},{"$f":"Полнота!AR10","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(TODAY(),-1)","v":"2017-07-31"},{"$f":"VLOOKUP(V:V,T:U,2,0)","v":"С:\\7 Июль 2017"}]
[null,{"$f":"Полнота!AO11","v":"Филиал6"},{"$f":"Полнота!AP11","v":1000},{"$f":"Полнота!AQ11","v":0.49056973300930257},{"$f":"Полнота!AR11","v":6}]
[null,{"$f":"Полнота!AO12","v":"Общий итог"},{"$f":"Полнота!AP12","v":97000},{"$f":"Полнота!AQ12","v":0.683658981922318}]
[]
[null,"В рассылку добавлен рейтинг по отделам:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-31","С:\\7 Июль 2017"]
[]
[null,null,null,{"$f":"Полнота!AQ19","v":"июл.17"}]
[null,"ЦФО МРЦ","Руководитель"," План"," Факт"," % выполнения плана","Рейтинг"]
[null,{"$f":"Полнота!AO21","v":"Отдел 1"},{"$f":"Полнота!AP21","v":"Иванов"},{"$f":"Полнота!AQ21","v":1000},{"$f":"Полнота!AR21","v":760.45130795608191},{"$f":"Полнота!AS21","v":0.76045130795608196},{"$f":"Полнота!AT21","v":1}]
[null,{"$f":"Полнота!AO22","v":"Отдел 2"},{"$f":"Полнота!AP22","v":"Петров"},{"$f":"Полнота!AQ22","v":2000},{"$f":"Полнота!AR22","v":1276.1515029108216},{"$f":"Полнота!AS22","v":0.63807575145541084},{"$f":"Полнота!AT22","v":2}]
[null,{"$f":"Полнота!AO23","v":"Отдел 3"},{"$f":"Полнота!AP23","v":"Сидоров"},{"$f":"Полнота!AQ23","v":30000},{"$f":"Полнота!AR23","v":14128.620092702238},{"$f":"Полнота!AS23","v":0.47095400309007462},{"$f":"Полнота!AT23","v":3}]
[null,{"$f":"Полнота!AO24","v":"Отдел 4"},{"$f":"Полнота!AP24","v":"Григорьев"},{"$f":"Полнота!AQ24","v":4000},{"$f":"Полнота!AR24","v":801.08796758589051},{"$f":"Полнота!AS24","v":0.20027199189647263},{"$f":"Полнота!AT24","v":4}]
[null,{"$f":"Полнота!AO25","v":"Отдел 5"},{"$f":"Полнота!AP25","v":"Васечкин"},{"$f":"Полнота!AQ25","v":500},{"$f":"Полнота!AR25","v":82.869228322761685},{"$f":"Полнота!AS25","v":0.16573845664552336},{"$f":"Полнота!AT25","v":5}]
[null,{"$f":"Полнота!AO26","v":"Отдел 6"},{"$f":"Полнота!AP26","v":"_"},{"$f":"Полнота!AQ26","v":50},{"$f":"Полнота!AR26","v":-3.5039551388725431E-5},{"$f":"Полнота!AS26","v":-7.0079102777450859E-7},{"$f":"Полнота!AT26","v":6}]
[]
[null,"Просьба руководителей дать обратную связь по суммам и формату таблицы."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Папки для сохранения в разных месяцах:"]
[null,"Доступ к файлу 1: "]
[null,{"$f":"CONCATENATE(W16, \"\\Отчет за \",TEXT(EOMONTH(TODAY(),-1), \"ММММ\"), \" на \", TEXT(TODAY(),\"ДД.ММ\"))","v":"С:\\7 Июль 2017\\Отчет за Июль на 23.08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-31","С:\\8 Август 2017"]
[null,"Доступ к файлу 2: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-30","С:\\9 Сентябрь 2017"]
[null,{"$f":"CONCATENATE(CONCATENATE(\"С:\\Для других\",\"\\Отчет за \",TEXT(EOMONTH(TODAY(),-1), \"ММММ\"), \" на \", TEXT(TODAY(),\"ДД.ММ\")))","v":"С:\\Для других\\Отчет за Июль на 23.08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-31","С:\\10 Октябрь 2017"]
[null,"Пояснение.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-30","С:\\11 Ноябрь 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-31","С:\\12 Декабрь 2017"]
[null,"Комментарий 1"]
[]
[null,"Как пользоваться отчетом:"]
[null,"1) Комментарий 2"]
[null,"2) Комментарий 3"]
[null,"3) Комментарий 4"]
[null,"Комментарий 5"]
[]
[]
[]
[null,"Папки для сохранения:"]
["Путь1",{"$f":"CONCATENATE(W16,\"\\\")","v":"С:\\7 Июль 2017\\"}]
["Путь2",{"$f":"CONCATENATE(CONCATENATE(\"С:\\Для других\",\"\\\"))","v":"С:\\Для других\\"}]
[]
[null,"Названия файла для сохранения:"]
[null,{"$f":"CONCATENATE(\"Отчет за \",TEXT(EOMONTH(TODAY(),-1),\"ММММ\"), \" на \", TEXT(TODAY(),\"ДД.ММ\"))","v":"Отчет за Июль на 23.08"}]
[]
[null,{"$f":"B50","v":"С:\\7 Июль 2017\\"}]
[null,{"$f":"B51","v":"С:\\Для других\\"}]
[]
[null,{"$f":"CONCATENATE(C59,\".xlsm\")","v":"С:\\7 Июль 2017\\Отчет за Июль на 23.08.xlsm"},{"$f":"B34","v":"С:\\7 Июль 2017\\Отчет за Июль на 23.08"}]
[null,{"$f":"CONCATENATE(C60,\".xlsm\")","v":"С:\\Для других\\Отчет за Июль на 23.08.xlsm"},{"$f":"B36","v":"С:\\Для других\\Отчет за Июль на 23.08"}]

{"sheet":"Список","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Укажите e-mail"]

{"sheet":"Отчет","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["Адрес эл почты","Получатель","Время отправки","Дата отправки"]
[null,null,"12:30:40","2017-01-11"]