{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["СВОД","Иванов","Петров","Сидоров","Смирнов","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":110,"n_cols":12,"rows_kept":110,"cut":false,"hidden":false,"merged":[[65,6,65,7],[92,4,92,5],[103,8,103,10],[0,1,0,5],[0,7,0,10],[2,5,2,8],[9,6,9,7],[40,6,40,7]]}
[]
[]
[null,"Расчет количества дней отпуска",null,null,null,"СВОД по отделу"]
[]
[]
[]
[]
[null,"Журнал \"ДОЛГОВ\" По ОТПУСКАМ"]
[]
[null,"ФИО","Конец","Календарные дни","Праздничные дни","Отгуленные дни","За период с… по…",null,"Приказ №","Период (закрыт/нет)","Кол-во дней за период осталось"]
[null,{"$f":"IFERROR(INDEX(оглавление,ROW(A2)),\"\")","v":"Иванов"},null,{"$f":"$C11-$B11+1","v":{"$error":"#VALUE!"}},null,{"$f":"$D11-$E11","v":{"$error":"#VALUE!"}},null,null,null,null,null,"В \"оранжевой\" строке должен быть Иванов"]
[null,{"$f":"IFERROR(INDEX(оглавление,ROW(A3)),\"\")","v":"Петров"},null,{"$f":"$C12-$B12+1","v":{"$error":"#VALUE!"}},null,{"$f":"$D12-$E12","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Тут - Петров"]
[null,"Сидоров",null,{"$error":"#VALUE!"},1,{"$error":"#VALUE!"},null,null,null,null,null,"Тут - Сидоров "]
[null,"Смирнов",null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,null,null,null,null,"И т.д."]
[null,"Лист1",null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[null,"",null,{"$error":"#VALUE!"},null,7]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,"",null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[{"$f":"IF(K37=0,#REF!,K37)","v":{"$error":"#REF!"}},"Журнал отпусков  ДОПОЛНИТЕЛЬНЫХ"]
[]
[null,"Начало","Конец","Календарные дни","Праздничные дни","Отгуленные дни","За период с… по…",null,"Приказ №","Период (закрыт/нет)"]
[null,"2016-02-27","2016-02-29",{"$f":"$C42-$B42+1","v":3},null,{"$f":"$D42-$E42","v":3},"2014-08-01",{"$f":"G42+364","v":"2015-07-31"},"13-0","Период закрыт"]
[null,null,null,{"$f":"$C43-$B43+1","v":1},null,{"$f":"$D43-$E43","v":1},null,{"$f":"G43+364","v":"1900-12-29"},null,"Период закрыт"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Период закрыт"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Период закрыт"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Период закрыт"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Период закрыт"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Период закрыт"]
[null,null,null,null,null,0]
[]
[null,"Журнал отпусков  УЧЕБНЫХ"]
[]
[null,"Начало","Конец","Календарные дни","Приказ №","Примечание"]
[null,null,null,{"$f":"$C54-$B54+1","v":1}]
[null,null,null,{"$f":"$C55-$B55+1","v":1}]
[null,null,null,1]
[null,null,null,1]
[null,null,null,1]
[null,null,null,1]
[null,null,null,1]
[null,null,null,1]
[]
[]
[null,"Журнал отпусков  БЕЗ СОХРАНЕНИЯ ЗАРАБОТНОЙ ПЛАТЫ"]
[]
[null,"Начало","Конец","Календарные дни","Праздничные дни","Отгуленные дни","За период с… по…",null,"Приказ №","Меняет/не меняет период","На сколько дней меняет период","НОВЫЙ период"]
[null,null,null,{"$f":"$C67-$B67+1","v":1},null,{"$f":"$D67-$E67","v":1},null,{"$f":"G67+364","v":"1900-12-29"},null,"Нет",null,{"$f":"H67+K67","v":"1900-12-29"}]
[null,null,null,{"$f":"$C68-$B68+1","v":1},null,{"$f":"$D68-$E68","v":1},null,{"$f":"G68+364","v":"1900-12-29"},null,"Нет",null,{"$f":"H68+K68","v":"1900-12-29"}]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[null,null,null,1,null,1,null,"1900-12-29",null,"Нет",null,"1900-12-29"]
[]
[]
[]
[null,"Журнал отпусков  ПО БЕРЕМЕННОСТИ И РОДАМ  (БиР)"]
[]
[null,"Начало","Конец","Календарные дни","Приказ №","Примечание"]
[null,null,null,{"$f":"$C86-$B86+1","v":1}]
[null,null,null,{"$f":"$C87-$B87+1","v":1}]
[null,null,null,1]
[]
[]
[null,"Журнал отпусков  ПО УХОДУ ЗА РЕБЕНКОМ"]
[]
[null,"Начало","Конец","Календарные дни","Должен быть период                       с… по…",null,"Приказ №","Меняет/не меняет период","На сколько дней меняет период","НОВЫЙ период","Примечание"]
[null,null,null,{"$f":"$C94-$B94+1","v":1},null,{"$f":"E94+364","v":"1900-12-29"},null,"Нет",{"$f":"$D94","v":1},{"$f":"F94+I94","v":"1900-12-30"}]
[null,null,null,null,null,{"$f":"E95+365","v":"1900-12-30"},null,"Нет",{"$f":"$D95","v":0},{"$f":"F95+I95","v":"1900-12-30"}]
[null,null,null,null,null,"1900-12-30",null,"Нет",0,"1900-12-30"]
[null,null,null,null,null,"1900-12-30",null,"Нет",0,"1900-12-30"]
[null,null,null,null,null,"1900-12-30",null,"Нет",0,"1900-12-30"]
[]
[]
[null,"Журнал изменений РАБОЧЕГО ПЕРИОДА"]
[]
[null,"Начало (должен быть)","Конец (должен быть)","Календарные дни","Меняет/не меняет период","На сколько дней меняет период","НОВЫЙ период начало","НОВЫЙ период окончание"]
[null,null,null,{"$f":"D94","v":1},"Нет",null,{"$f":"$B104","v":"00:00:00"},{"$f":"$C104+$F104","v":"00:00:00"},"Первое изменение"]
[null,null,null,{"$f":"D95","v":0},"Нет",null,null,{"$f":"$C105+$F105","v":"00:00:00"}]
[null,null,null,{"$f":"D96","v":0},"Нет",null,null,"00:00:00"]
[null,null,null,{"$f":"D98","v":0},"Нет",null,null,"00:00:00"]
[null,null,null,0,"Нет",null,null,"00:00:00"]
[null,null,null,0,"Нет",null,null,"00:00:00"]
[null,null,null,0,"Нет",null,null,"00:00:00"]

{"sheet":"Иванов","index":1,"n_rows":59,"n_cols":1,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10],[4,6,4,9],[4,10,4,12],[5,8,5,9],[5,10,16,12],[6,8,6,9],[8,1,8,2],[2,5,2,8],[18,0,23,0],[18,5,23,5],[18,6,18,9],[19,8,19,9],[20,8,20,9],[22,1,22,2],[11,0,16,0],[11,5,16,5],[11,6,11,9],[12,8,12,9],[13,8,13,9],[15,1,15,2],[29,6,29,7],[60,6,60,7],[85,6,85,7],[112,4,112,5],[123,8,123,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[]
[]
[]
[]
[]
[]
[2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"H6","v":0}]
[{"$f":"IF(K31=0,$H$6,K31)","v":0}]
[{"$f":"IF(K32=0,$H$6,K32)","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[]
[]
[{"$f":"IF(K57=0,$H$6,K57)","v":0}]

{"sheet":"Петров","index":2,"n_rows":59,"n_cols":1,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10],[4,6,4,9],[4,10,4,12],[5,8,5,9],[5,10,16,12],[6,8,6,9],[8,1,8,2],[2,5,2,8],[18,0,23,0],[18,5,23,5],[18,6,18,9],[19,8,19,9],[20,8,20,9],[22,1,22,2],[11,0,16,0],[11,5,16,5],[11,6,11,9],[12,8,12,9],[13,8,13,9],[15,1,15,2],[29,6,29,7],[60,6,60,7],[85,6,85,7],[112,4,112,5],[123,8,123,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[]
[]
[]
[]
[]
[]
[2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"H6","v":0}]
[{"$f":"IF(K31=0,$H$6,K31)","v":0}]
[{"$f":"IF(K32=0,$H$6,K32)","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[]
[]
[{"$f":"IF(K57=0,$H$6,K57)","v":0}]

{"sheet":"Сидоров","index":3,"n_rows":60,"n_cols":1,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10],[4,6,4,9],[4,10,4,12],[5,8,5,9],[5,10,16,12],[6,8,6,9],[8,1,8,2],[2,5,2,8],[18,0,23,0],[18,5,23,5],[18,6,18,9],[19,8,19,9],[20,8,20,9],[22,1,22,2],[11,0,16,0],[11,5,16,5],[11,6,11,9],[12,8,12,9],[13,8,13,9],[15,1,15,2],[29,6,29,7],[61,6,61,7],[86,6,86,7],[113,4,113,5],[124,8,124,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[]
[]
[]
[]
[]
[]
[2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"H6","v":0}]
[{"$f":"IF(K31=0,$H$6,K31)","v":0}]
[{"$f":"IF(K32=0,$H$6,K32)","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[]
[]
[{"$f":"IF(K58=0,$H$6,K58)","v":0}]

{"sheet":"Смирнов","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,10],[4,6,4,9],[4,10,4,12],[11,0,16,0],[11,5,16,5],[11,6,11,9],[12,8,12,9],[13,8,13,9],[15,1,15,2],[5,8,5,9],[5,10,16,12],[6,8,6,9],[8,1,8,2],[2,5,2,8],[18,0,23,0],[18,5,23,5],[18,6,18,9],[19,8,19,9],[20,8,20,9],[22,1,22,2],[29,6,29,7],[60,6,60,7],[85,6,85,7],[112,4,112,5],[123,8,123,10]]}

{"sheet":"Лист1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}