{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["0","Лист2","2016"],"not_rendered":{"charts":1,"images":7,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":1},"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":"0","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,140065]
[null,142061]
[null,209024]
[null,301131]
[null,301136]
[null,301137]
[null,301148]
[null,301158]
[null,301160]
[null,"06-1550"]
[null,"142061, 142062"]
[null,"больничный"]
[null,"отпуск"]
[null,"ТКП"]

{"sheet":"Лист2","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Сумма по полю Столбец128","Столбец1"]
["Столбец2","заказ","проект","Общий итог"]
["Алексеев А.А.",264,null,264]
["Андреев А.А.",254,8,262]
["Егоров Е.Е.",189,null,189]
["Иванов И.И.",null,104,104]
["Петров П.П.",400,8,408]
["Сидоров С.С.",337,2,339]
["Федоров Ф.Ф.",190,null,190]
["Общий итог",1634,122,1756]

{"sheet":"2016","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[41,2,45,2],[33,2,40,2],[72,1,72,2],[68,6,68,7],[46,1,52,1],[46,2,52,2],[53,1,60,1],[53,2,60,2],[61,1,67,1],[61,2,67,2],[33,1,40,1],[41,1,45,1],[8,1,27,1],[4,6,4,7],[4,8,6,8],[5,6,6,6],[5,7,6,7],[28,1,32,1],[28,2,32,2],[7,4,7,8],[7,2,7,3],[8,2,27,2],[4,1,6,1],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5]]}
[]
[]
[]
[]
[null,"№ п/п","ФИО сотрудника","№ заказа\nили проекта","Примечание",null,"Сроки выполнения",null,"Трудоёмкость работ, чел/час"]
[null,null,null,null,null,null,"Начало","Окончание"]
[]
[null,null,"Отдел 1"]
[null,1,"Иванов И.И.","88-043",null,{"$f":"IF(AND(G9=\"Итого_за\",1=MONTH(H9)),1,\nIF(AND(G9=\"Итого_за\",2=MONTH(H9)),2,\nIF(AND(G9=\"Итого_за\",3=MONTH(H9)),3,\nIF(AND(G9=\"Итого_за\",4=MONTH(H9)),4,\nIF(AND(G9=\"Итого_за\",5=MONTH(H9)),5,\nIF(AND(G9=\"Итого_за\",6=MONTH(H9)),6,\nIF(AND(G9=\"Итого_за\",7=MONTH(H9)),7,\nIF(AND(G9=\"Итого_за\",8=MONTH(H9)),8,\nIF(AND(G9=\"Итого_за\",9=MONTH(H9)),9,\nIF(AND(G9=\"Итого_за\",10=MONTH(H9)),10,\nIF(AND(G9=\"Итого_за\",11=MONTH(H9)),11,\nIF(AND(G9=\"Итого_за\",12=MONTH(H9)),12,\nIF(AND(1=MONTH(G9),1=MONTH(H9)),\"1\",\nIF(AND(2=MONTH(G9),2=MONTH(H9)),\"2\",\nIF(AND(3=MONTH(G9),3=MONTH(H9)),\"3\",\nIF(AND(4=MONTH(G9),4=MONTH(H9)),\"4\",\nIF(AND(5=MONTH(G9),5=MONTH(H9)),\"5\",\nIF(AND(6=MONTH(G9),6=MONTH(H9)),\"6\",\nIF(AND(7=MONTH(G9),7=MONTH(H9)),\"7\",\nIF(AND(8=MONTH(G9),8=MONTH(H9)),\"8\",\nIF(AND(9=MONTH(G9),9=MONTH(H9)),\"9\",\nIF(AND(10=MONTH(G9),10=MONTH(H9)),\"10\",\nIF(AND(11=MONTH(G9),11=MONTH(H9)),\"11\",\nIF(AND(12=MONTH(G9),12=MONTH(H9)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-01","2016-10-03",8,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},{"$f":"IF(C9=\"\",K8,C9)","v":"Иванов И.И."}]
[null,null,null,"06-1514",null,"10","2016-10-04","2016-10-04",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-647",null,"10","2016-10-04","2016-10-04",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-645",null,"10","2016-10-05","2016-10-05",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-646-01",null,"10","2016-10-05","2016-10-05",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"88-045",null,"10","2016-10-06","2016-10-06",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-646",null,"10","2016-10-06","2016-10-06",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"06-1513",null,"10","2016-10-07","2016-10-07",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-575",null,"10","2016-10-07","2016-10-12",24,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-647",null,"10","2016-10-12","2016-10-12",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"06-1517",null,"10","2016-10-13","2016-10-13",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"06-1516",null,"10","2016-10-13","2016-10-13",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"04-622",null,"10","2016-10-14","2016-10-14",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-628",null,"10","2016-10-18","2016-10-19",6,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"04-621",null,"10","2016-10-19","2016-10-21",12,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-628",null,"10","2016-10-24","2016-10-24",1,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"17-575",null,"10","2016-10-25","2016-10-27",7,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"06-1525",null,"10","2016-10-27","2016-10-27",1,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,"06-1491",null,"10","2016-10-28","2016-10-28",1,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Иванов И.И."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I9:I27)","v":104},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Иванов И.И."]
[null,2,"Петров П.П.",140065,null,{"$f":"IF(AND(G29=\"Итого_за\",1=MONTH(H29)),1,\nIF(AND(G29=\"Итого_за\",2=MONTH(H29)),2,\nIF(AND(G29=\"Итого_за\",3=MONTH(H29)),3,\nIF(AND(G29=\"Итого_за\",4=MONTH(H29)),4,\nIF(AND(G29=\"Итого_за\",5=MONTH(H29)),5,\nIF(AND(G29=\"Итого_за\",6=MONTH(H29)),6,\nIF(AND(G29=\"Итого_за\",7=MONTH(H29)),7,\nIF(AND(G29=\"Итого_за\",8=MONTH(H29)),8,\nIF(AND(G29=\"Итого_за\",9=MONTH(H29)),9,\nIF(AND(G29=\"Итого_за\",10=MONTH(H29)),10,\nIF(AND(G29=\"Итого_за\",11=MONTH(H29)),11,\nIF(AND(G29=\"Итого_за\",12=MONTH(H29)),12,\nIF(AND(1=MONTH(G29),1=MONTH(H29)),\"1\",\nIF(AND(2=MONTH(G29),2=MONTH(H29)),\"2\",\nIF(AND(3=MONTH(G29),3=MONTH(H29)),\"3\",\nIF(AND(4=MONTH(G29),4=MONTH(H29)),\"4\",\nIF(AND(5=MONTH(G29),5=MONTH(H29)),\"5\",\nIF(AND(6=MONTH(G29),6=MONTH(H29)),\"6\",\nIF(AND(7=MONTH(G29),7=MONTH(H29)),\"7\",\nIF(AND(8=MONTH(G29),8=MONTH(H29)),\"8\",\nIF(AND(9=MONTH(G29),9=MONTH(H29)),\"9\",\nIF(AND(10=MONTH(G29),10=MONTH(H29)),\"10\",\nIF(AND(11=MONTH(G29),11=MONTH(H29)),\"11\",\nIF(AND(12=MONTH(G29),12=MONTH(H29)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-01","2016-10-18",88,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Петров П.П."]
[null,null,null,140065,null,"10","2016-10-18","2016-10-25",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Петров П.П."]
[null,null,null,140065,null,"10","2016-10-18","2016-10-31",296,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Петров П.П."]
[null,null,null,"17-575 ",null,"10","2016-10-27","2016-10-27",8,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Петров П.П."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I29:I32)","v":408},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Петров П.П."]
[null,3,"Сидоров С.С.","301136",null,"10","2016-10-01","2016-10-04",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,"140065",null,"10","2016-10-05","2016-10-10",24,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,"301084",null,"10","2016-10-07","2016-10-13",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,"04-622",null,{"$f":"IF(AND(G37=\"Итого_за\",1=MONTH(H37)),1,\nIF(AND(G37=\"Итого_за\",2=MONTH(H37)),2,\nIF(AND(G37=\"Итого_за\",3=MONTH(H37)),3,\nIF(AND(G37=\"Итого_за\",4=MONTH(H37)),4,\nIF(AND(G37=\"Итого_за\",5=MONTH(H37)),5,\nIF(AND(G37=\"Итого_за\",6=MONTH(H37)),6,\nIF(AND(G37=\"Итого_за\",7=MONTH(H37)),7,\nIF(AND(G37=\"Итого_за\",8=MONTH(H37)),8,\nIF(AND(G37=\"Итого_за\",9=MONTH(H37)),9,\nIF(AND(G37=\"Итого_за\",10=MONTH(H37)),10,\nIF(AND(G37=\"Итого_за\",11=MONTH(H37)),11,\nIF(AND(G37=\"Итого_за\",12=MONTH(H37)),12,\nIF(AND(1=MONTH(G37),1=MONTH(H37)),\"1\",\nIF(AND(2=MONTH(G37),2=MONTH(H37)),\"2\",\nIF(AND(3=MONTH(G37),3=MONTH(H37)),\"3\",\nIF(AND(4=MONTH(G37),4=MONTH(H37)),\"4\",\nIF(AND(5=MONTH(G37),5=MONTH(H37)),\"5\",\nIF(AND(6=MONTH(G37),6=MONTH(H37)),\"6\",\nIF(AND(7=MONTH(G37),7=MONTH(H37)),\"7\",\nIF(AND(8=MONTH(G37),8=MONTH(H37)),\"8\",\nIF(AND(9=MONTH(G37),9=MONTH(H37)),\"9\",\nIF(AND(10=MONTH(G37),10=MONTH(H37)),\"10\",\nIF(AND(11=MONTH(G37),11=MONTH(H37)),\"11\",\nIF(AND(12=MONTH(G37),12=MONTH(H37)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-14","2016-10-14",2,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Сидоров С.С."]
[null,null,null,"140067 ",null,{"$f":"IF(AND(G38=\"Итого_за\",1=MONTH(H38)),1,\nIF(AND(G38=\"Итого_за\",2=MONTH(H38)),2,\nIF(AND(G38=\"Итого_за\",3=MONTH(H38)),3,\nIF(AND(G38=\"Итого_за\",4=MONTH(H38)),4,\nIF(AND(G38=\"Итого_за\",5=MONTH(H38)),5,\nIF(AND(G38=\"Итого_за\",6=MONTH(H38)),6,\nIF(AND(G38=\"Итого_за\",7=MONTH(H38)),7,\nIF(AND(G38=\"Итого_за\",8=MONTH(H38)),8,\nIF(AND(G38=\"Итого_за\",9=MONTH(H38)),9,\nIF(AND(G38=\"Итого_за\",10=MONTH(H38)),10,\nIF(AND(G38=\"Итого_за\",11=MONTH(H38)),11,\nIF(AND(G38=\"Итого_за\",12=MONTH(H38)),12,\nIF(AND(1=MONTH(G38),1=MONTH(H38)),\"1\",\nIF(AND(2=MONTH(G38),2=MONTH(H38)),\"2\",\nIF(AND(3=MONTH(G38),3=MONTH(H38)),\"3\",\nIF(AND(4=MONTH(G38),4=MONTH(H38)),\"4\",\nIF(AND(5=MONTH(G38),5=MONTH(H38)),\"5\",\nIF(AND(6=MONTH(G38),6=MONTH(H38)),\"6\",\nIF(AND(7=MONTH(G38),7=MONTH(H38)),\"7\",\nIF(AND(8=MONTH(G38),8=MONTH(H38)),\"8\",\nIF(AND(9=MONTH(G38),9=MONTH(H38)),\"9\",\nIF(AND(10=MONTH(G38),10=MONTH(H38)),\"10\",\nIF(AND(11=MONTH(G38),11=MONTH(H38)),\"11\",\nIF(AND(12=MONTH(G38),12=MONTH(H38)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-17","2016-10-27",204,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,"301138  ",null,{"$f":"IF(AND(G39=\"Итого_за\",1=MONTH(H39)),1,\nIF(AND(G39=\"Итого_за\",2=MONTH(H39)),2,\nIF(AND(G39=\"Итого_за\",3=MONTH(H39)),3,\nIF(AND(G39=\"Итого_за\",4=MONTH(H39)),4,\nIF(AND(G39=\"Итого_за\",5=MONTH(H39)),5,\nIF(AND(G39=\"Итого_за\",6=MONTH(H39)),6,\nIF(AND(G39=\"Итого_за\",7=MONTH(H39)),7,\nIF(AND(G39=\"Итого_за\",8=MONTH(H39)),8,\nIF(AND(G39=\"Итого_за\",9=MONTH(H39)),9,\nIF(AND(G39=\"Итого_за\",10=MONTH(H39)),10,\nIF(AND(G39=\"Итого_за\",11=MONTH(H39)),11,\nIF(AND(G39=\"Итого_за\",12=MONTH(H39)),12,\nIF(AND(1=MONTH(G39),1=MONTH(H39)),\"1\",\nIF(AND(2=MONTH(G39),2=MONTH(H39)),\"2\",\nIF(AND(3=MONTH(G39),3=MONTH(H39)),\"3\",\nIF(AND(4=MONTH(G39),4=MONTH(H39)),\"4\",\nIF(AND(5=MONTH(G39),5=MONTH(H39)),\"5\",\nIF(AND(6=MONTH(G39),6=MONTH(H39)),\"6\",\nIF(AND(7=MONTH(G39),7=MONTH(H39)),\"7\",\nIF(AND(8=MONTH(G39),8=MONTH(H39)),\"8\",\nIF(AND(9=MONTH(G39),9=MONTH(H39)),\"9\",\nIF(AND(10=MONTH(G39),10=MONTH(H39)),\"10\",\nIF(AND(11=MONTH(G39),11=MONTH(H39)),\"11\",\nIF(AND(12=MONTH(G39),12=MONTH(H39)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-20","2016-10-31",72,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,"301133 ",null,{"$f":"IF(AND(G40=\"Итого_за\",1=MONTH(H40)),1,\nIF(AND(G40=\"Итого_за\",2=MONTH(H40)),2,\nIF(AND(G40=\"Итого_за\",3=MONTH(H40)),3,\nIF(AND(G40=\"Итого_за\",4=MONTH(H40)),4,\nIF(AND(G40=\"Итого_за\",5=MONTH(H40)),5,\nIF(AND(G40=\"Итого_за\",6=MONTH(H40)),6,\nIF(AND(G40=\"Итого_за\",7=MONTH(H40)),7,\nIF(AND(G40=\"Итого_за\",8=MONTH(H40)),8,\nIF(AND(G40=\"Итого_за\",9=MONTH(H40)),9,\nIF(AND(G40=\"Итого_за\",10=MONTH(H40)),10,\nIF(AND(G40=\"Итого_за\",11=MONTH(H40)),11,\nIF(AND(G40=\"Итого_за\",12=MONTH(H40)),12,\nIF(AND(1=MONTH(G40),1=MONTH(H40)),\"1\",\nIF(AND(2=MONTH(G40),2=MONTH(H40)),\"2\",\nIF(AND(3=MONTH(G40),3=MONTH(H40)),\"3\",\nIF(AND(4=MONTH(G40),4=MONTH(H40)),\"4\",\nIF(AND(5=MONTH(G40),5=MONTH(H40)),\"5\",\nIF(AND(6=MONTH(G40),6=MONTH(H40)),\"6\",\nIF(AND(7=MONTH(G40),7=MONTH(H40)),\"7\",\nIF(AND(8=MONTH(G40),8=MONTH(H40)),\"8\",\nIF(AND(9=MONTH(G40),9=MONTH(H40)),\"9\",\nIF(AND(10=MONTH(G40),10=MONTH(H40)),\"10\",\nIF(AND(11=MONTH(G40),11=MONTH(H40)),\"11\",\nIF(AND(12=MONTH(G40),12=MONTH(H40)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-25","2016-10-25",5,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Сидоров С.С."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I34:I40)","v":339},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Сидоров С.С."]
[null,4,"Егоров Е.Е.",301136,null,"10","2016-10-01","2016-10-19",96,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Егоров Е.Е."]
[null,null,null,301082,null,"10","2016-10-20","2016-10-21",15,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Егоров Е.Е."]
[null,null,null,301082,null,"10","2016-10-24","2016-10-25",14,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Егоров Е.Е."]
[null,null,null,301133,null,"10","2016-10-25","2016-10-31",64,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Егоров Е.Е."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I42:I45)","v":189},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Егоров Е.Е."]
[null,5,"Федоров Ф.Ф.","301136",null,{"$f":"IF(AND(G47=\"Итого_за\",1=MONTH(H47)),1,\nIF(AND(G47=\"Итого_за\",2=MONTH(H47)),2,\nIF(AND(G47=\"Итого_за\",3=MONTH(H47)),3,\nIF(AND(G47=\"Итого_за\",4=MONTH(H47)),4,\nIF(AND(G47=\"Итого_за\",5=MONTH(H47)),5,\nIF(AND(G47=\"Итого_за\",6=MONTH(H47)),6,\nIF(AND(G47=\"Итого_за\",7=MONTH(H47)),7,\nIF(AND(G47=\"Итого_за\",8=MONTH(H47)),8,\nIF(AND(G47=\"Итого_за\",9=MONTH(H47)),9,\nIF(AND(G47=\"Итого_за\",10=MONTH(H47)),10,\nIF(AND(G47=\"Итого_за\",11=MONTH(H47)),11,\nIF(AND(G47=\"Итого_за\",12=MONTH(H47)),12,\nIF(AND(1=MONTH(G47),1=MONTH(H47)),\"1\",\nIF(AND(2=MONTH(G47),2=MONTH(H47)),\"2\",\nIF(AND(3=MONTH(G47),3=MONTH(H47)),\"3\",\nIF(AND(4=MONTH(G47),4=MONTH(H47)),\"4\",\nIF(AND(5=MONTH(G47),5=MONTH(H47)),\"5\",\nIF(AND(6=MONTH(G47),6=MONTH(H47)),\"6\",\nIF(AND(7=MONTH(G47),7=MONTH(H47)),\"7\",\nIF(AND(8=MONTH(G47),8=MONTH(H47)),\"8\",\nIF(AND(9=MONTH(G47),9=MONTH(H47)),\"9\",\nIF(AND(10=MONTH(G47),10=MONTH(H47)),\"10\",\nIF(AND(11=MONTH(G47),11=MONTH(H47)),\"11\",\nIF(AND(12=MONTH(G47),12=MONTH(H47)),\"12\",\n\"\"))))))))))))))))))))))))","v":"10"},"2016-10-01","2016-10-07",32,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,"140067 ",null,"10","2016-10-17","2016-10-21",40,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,"отпуск",null,"10","2016-10-24","2016-10-25",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,"301136 ",null,"10","2016-10-21","2016-10-21",2,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,"140067 ",null,"10","2016-10-26","2016-10-27",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,"301150",null,"10","2016-10-27","2016-10-31",84,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Федоров Ф.Ф."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I47:I52)","v":190},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Федоров Ф.Ф."]
[null,6,"Андреев А.А.","301082",null,"10","2016-10-01","2016-10-04",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"140065",null,"10","2016-10-04","2016-10-10",42,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"301082 ",null,"10","2016-10-10","2016-10-18",null,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"301082 ",null,"10","2016-10-17","2016-10-18",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"140065 ",null,"10","2016-10-18","2016-10-31",32,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"301152",null,"10","2016-10-24","2016-10-31",160,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Андреев А.А."]
[null,null,null,"17-575 ",null,"10","2016-10-27","2016-10-27",8,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"проект"},"Андреев А.А."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I54:I60)","v":262},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Андреев А.А."]
[null,7,"Алексеев А.А.",301136,null,"10","2016-10-01","2016-10-17",80,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,301082,null,"10","2016-10-13","2016-10-13",4,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,301136,null,"10","2016-10-17","2016-10-21",28,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,140065,null,"10","2016-10-21","2016-10-24",16,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,140065,null,"10","2016-10-25","2016-10-27",24,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,301152,null,"10","2016-10-28","2016-10-31",112,{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":"заказ"},"Алексеев А.А."]
[null,null,null,null,null,10,"Итого_за","2016-10-01",{"$f":"SUBTOTAL(109,I62:I67)","v":264},{"$f":"IF(КТП_8[[#This Row],[Столбец123]]=\"\",\"\",IF(ISNUMBER(SEARCH(\"-\",КТП_8[[#This Row],[Столбец123]])),\"проект\",\"заказ\"))","v":""},"Алексеев А.А."]
[null,null,null,null,null,null,"Итого по отделу",null,{"$f":"SUBTOTAL(109,(I9:I68))","v":1756}]