{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Реестр","Вспомогательный лист_Реестр","1_Джон_Траволта_Проекты","Расширенный шаблон_Проекты"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["№ пп","№ договора","Дата заключения","Заказчик","Адрес","Категория работ","Стоимость","Оплата","Дата начала","Дата конца","Период.","Статус договора","Примечание","Отправить в работу"]
[1,"первый","2014-05-01","Джон Траволта","Санкт-Петербург, дворцовая площадь д.1","Археология",30000,"есть","2014-01-01","2014-02-01",null,null,null,"В работе"]
[2,"второй","2014-01-02","Чарли Шин","Санкт-Петербург, дворцовая площадь д.2","Геодезия",30000,"есть","2014-01-02","2014-02-02",null,null,null,"Ожидание"]
[3,"третий","2014-01-03","Мартин Фримен","Санкт-Петербург, дворцовая площадь д.3","Лаборатория",30000,"есть","2014-01-03","2014-02-03",null,null,null,"Ожидание"]

{"sheet":"Вспомогательный лист_Реестр","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Категории работ (занятые отделы)",null,"Виды работ",null,"Отправить в работу"]
["Археология",null,null,null,"Ожидание"]
["Геодезия",null,null,null,"В работе"]
["Геология",null,null,null,"Закрыт"]
["Лаборатория"]
["Экология"]
["Экспертиза"]

{"sheet":"1_Джон_Траволта_Проекты","index":2,"n_rows":17,"n_cols":56,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Наименование договора",null,null,null,"Джон Траволта Санкт-Петербург, дворцовая площадь д.1 "]
[]
[null,null,null,null,"Дата начала договора",null,null,null,"2014-05-01"]
[]
[null,null,null,null,"Занятые отделы",null,null,null,"Археология"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Уровень 1","Уровень 2","Уровень 3","Уровень 4","Уровень 5","СДР","Задача","Длительность, раб. Дн.","Начало","Окончание","Завершено","Завершено, %","Ресурсы",null,{"$f":"I3+O6","v":"2014-05-01"},{"$f":"O7+1","v":"2014-05-02"},{"$f":"P7+1","v":"2014-05-03"},"2014-05-04","2014-05-05","2014-05-06","2014-05-07","2014-05-08","2014-05-09","2014-05-10","2014-05-11","2014-05-12","2014-05-13","2014-05-14","2014-05-15","2014-05-16","2014-05-17","2014-05-18","2014-05-19","2014-05-20","2014-05-21","2014-05-22","2014-05-23","2014-05-24","2014-05-25","2014-05-26","2014-05-27","2014-05-28","2014-05-29","2014-05-30","2014-05-31","2014-06-01","2014-06-02","2014-06-03","2014-06-04","2014-06-05","2014-06-06","2014-06-07","2014-06-08","2014-06-09","2014-06-10","2014-06-11"]
[1,null,null,null,null,{"$f":"CONCATENATE(IF(A8<>\"\",A8&\".\",\"\"),IF(B8<>\"\",B8&\".\",\"\"),IF(C8<>\"\",C8&\".\",\"\"),IF(D8<>\"\",D8&\".\",\"\"),IF(E8<>\"\",E8&\".\",\"\"))","v":"1."},"Задача 1",{"$f":"CountNetDays(I8,J8)","v":7},{"$f":"MIN(I9:I11)","v":"2014-05-01"},{"$f":"MAX(J9:J11)","v":"2014-05-09"},null,{"$f":"AVERAGE(L9:L11)","v":0.80000000000000016}]
[1,1,null,null,null,{"$f":"CONCATENATE(IF(A9<>\"\",A9&\".\",\"\"),IF(B9<>\"\",B9&\".\",\"\"),IF(C9<>\"\",C9&\".\",\"\"),IF(D9<>\"\",D9&\".\",\"\"),IF(E9<>\"\",E9&\".\",\"\"))","v":"1.1."},"Задача 2",1,{"$f":"I3","v":"2014-05-01"},{"$f":"setnetdays(I9,H9)","v":"2014-05-01"},null,1]
[1,2,null,null,null,"1.2.","Задача 3",3,{"$f":"J9+1","v":"2014-05-02"},{"$f":"setnetdays(I10,H10)","v":"2014-05-06"},null,0.6]
[1,3,null,null,null,"1.3.","Задача 4",3,{"$f":"J10+1","v":"2014-05-07"},"2014-05-09",null,0.8]
[2,null,null,null,null,"2.","Задача 5",{"$f":"CountNetDays(I12,J12)","v":15},{"$f":"MIN(I13:I15)","v":"2014-05-10"},{"$f":"MAX(J13:J16)","v":"2014-05-30"},null,{"$f":"AVERAGE(L13:L16)","v":0.77500000000000002}]
[2,1,null,null,null,"2.1.","Задача 6",1,{"$f":"J11+1","v":"2014-05-10"},{"$f":"setnetdays(I13,H13)","v":"2014-05-12"},null,1]
[2,2,null,null,null,"2.2.","Задача 7",2,{"$f":"J13+1","v":"2014-05-13"},{"$f":"setnetdays(I14,H14)","v":"2014-05-14"},null,1]
[2,3,null,null,null,"2.3.","Задача 8",1,{"$f":"J14+1","v":"2014-05-15"},{"$f":"setnetdays(I15,H15)","v":"2014-05-15"},null,1]
[2,4,null,null,null,"2.4.","Задача 9",11,"2014-05-16","2014-05-30",null,0.1]
[3,null,null,null,null,"3.","Задача 10",1,"2014-05-31","2014-06-02"]

{"sheet":"Расширенный шаблон_Проекты","index":3,"n_rows":17,"n_cols":56,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Наименование договора",null,null,null,"=Сцепить('Реестр договоров'!C2;\" \";'Реестр договоров'!D2)"]
[]
[null,null,null,null,"Дата начала договора",null,null,null,"='Реестр договоров'!I2"]
[]
[null,null,null,null,"Занятые отделы",null,null,null,"='Реестр договоров'!E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Уровень 1","Уровень 2","Уровень 3","Уровень 4","Уровень 5","СДР","Задача","Длительность, раб. Дн.","Начало","Окончание","Завершено","Завершено, %","Ресурсы",null,{"$f":"I9+O6","v":"2014-04-29"},{"$f":"O7+1","v":"2014-04-30"},{"$f":"P7+1","v":"2014-05-01"},"2014-05-02","2014-05-03","2014-05-04","2014-05-05","2014-05-06","2014-05-07","2014-05-08","2014-05-09","2014-05-10","2014-05-11","2014-05-12","2014-05-13","2014-05-14","2014-05-15","2014-05-16","2014-05-17","2014-05-18","2014-05-19","2014-05-20","2014-05-21","2014-05-22","2014-05-23","2014-05-24","2014-05-25","2014-05-26","2014-05-27","2014-05-28","2014-05-29","2014-05-30","2014-05-31","2014-06-01","2014-06-02","2014-06-03",{"$f":"AX7+1","v":"2014-06-04"},{"$f":"AY7+1","v":"2014-06-05"},{"$f":"AZ7+1","v":"2014-06-06"},{"$f":"BA7+1","v":"2014-06-07"},{"$f":"BB7+1","v":"2014-06-08"},{"$f":"BC7+1","v":"2014-06-09"}]
[1,null,null,null,null,{"$f":"CONCATENATE(IF(A8<>\"\",A8&\".\",\"\"),IF(B8<>\"\",B8&\".\",\"\"),IF(C8<>\"\",C8&\".\",\"\"),IF(D8<>\"\",D8&\".\",\"\"),IF(E8<>\"\",E8&\".\",\"\"))","v":"1."},"Задача 1",{"$f":"CountNetDays(I8,J8)","v":20},{"$f":"MIN(I9:I11)","v":"2014-04-29"},{"$f":"MAX(J9:J11)","v":"2014-05-26"},null,{"$f":"AVERAGE(L9:L11)","v":0.80000000000000016}]
[1,1,null,null,null,{"$f":"CONCATENATE(IF(A9<>\"\",A9&\".\",\"\"),IF(B9<>\"\",B9&\".\",\"\"),IF(C9<>\"\",C9&\".\",\"\"),IF(D9<>\"\",D9&\".\",\"\"),IF(E9<>\"\",E9&\".\",\"\"))","v":"1.1."},"Задача 2",1,"2014-04-29",{"$f":"setnetdays(I9,H9)","v":"2014-04-29"},null,1]
[1,2,null,null,null,"1.2.","Задача 3",15,{"$f":"J9+1","v":"2014-04-30"},{"$f":"setnetdays(I10,H10)","v":"2014-05-20"},null,0.6]
[1,3,null,null,null,"1.3.","Задача 4",4,{"$f":"J10+1","v":"2014-05-21"},"2014-05-26",null,0.8]
[2,null,null,null,null,"2.","Задача 5",{"$f":"CountNetDays(I12,J12)","v":15},{"$f":"MIN(I13:I15)","v":"2014-05-27"},{"$f":"MAX(J13:J16)","v":"2014-06-16"},null,{"$f":"AVERAGE(L13:L16)","v":0.77500000000000002}]
[2,1,null,null,null,"2.1.","Задача 6",1,{"$f":"J11+1","v":"2014-05-27"},{"$f":"setnetdays(I13,H13)","v":"2014-05-27"},null,1]
[2,2,null,null,null,"2.2.","Задача 7",2,{"$f":"J13+1","v":"2014-05-28"},{"$f":"setnetdays(I14,H14)","v":"2014-05-29"},null,1]
[2,3,null,null,null,"2.3.","Задача 8",1,{"$f":"J14+1","v":"2014-05-30"},{"$f":"setnetdays(I15,H15)","v":"2014-05-30"},null,1]
[2,4,null,null,null,"2.4.","Задача 9",11,"2014-05-31","2014-06-16",null,0.1]
[3,null,null,null,null,"3.","Задача 10",1,"2014-06-17","2014-06-17"]