{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2020 год"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"2020 год","index":0,"n_rows":22,"n_cols":378,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,256,7,285],[7,133,7,163],[7,164,7,193],[7,194,7,224],[7,225,7,255],[7,72,7,102],[7,103,7,132],[8,380,8,436],[7,13,7,43],[7,44,7,71],[7,286,7,316],[7,317,7,346],[7,347,7,377]]}
[null,null,null,null,null,"ГОД",2020]
[null,null,null,null,null,"Макс",0.3]
[null,null,null,null,null,"Чел",{"$f":"100-COUNTBLANK(D9:D100)-8","v":13}]
[null,null,null,null,null,"Чел %",{"$f":"ROUNDUP(G3*G2,0.00001)","v":4}]
[]
[]
[]
[null,null,null,"Ф.И.О.","Должность","1 часть отпуска",null,"2 часть отпуска",null,"3 часть отпуска",null,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Март",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Апрель",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Май",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Июнь",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Июль",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Август",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сентябрь",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Октябрь",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ноябрь",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"DATEVALUE(\"01.01.\" &G1)","v":"2020-01-01"},{"$f":"N9+1","v":"2020-01-02"},{"$f":"O9+1","v":"2020-01-03"},"2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11","2020-01-12","2020-01-13","2020-01-14","2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26","2020-01-27","2020-01-28","2020-01-29","2020-01-30","2020-01-31","2020-02-01","2020-02-02","2020-02-03","2020-02-04","2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09","2020-02-10","2020-02-11","2020-02-12","2020-02-13","2020-02-14","2020-02-15","2020-02-16","2020-02-17","2020-02-18","2020-02-19","2020-02-20","2020-02-21","2020-02-22","2020-02-23","2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28","2020-02-29","2020-03-01","2020-03-02","2020-03-03","2020-03-04","2020-03-05","2020-03-06",{"$f":"CA9+1","v":"2020-03-07"},"2020-03-08","2020-03-09","2020-03-10","2020-03-11","2020-03-12","2020-03-13","2020-03-14","2020-03-15","2020-03-16","2020-03-17","2020-03-18","2020-03-19","2020-03-20","2020-03-21","2020-03-22","2020-03-23","2020-03-24","2020-03-25","2020-03-26","2020-03-27","2020-03-28","2020-03-29","2020-03-30","2020-03-31","2020-04-01","2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09",{"$f":"EM9+1","v":"2020-05-10"},"2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04","2020-06-05","2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19","2020-06-20","2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29","2020-06-30","2020-07-01","2020-07-02","2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12",{"$f":"GY9+1","v":"2020-07-13"},"2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31","2020-08-01","2020-08-02","2020-08-03","2020-08-04","2020-08-05","2020-08-06","2020-08-07","2020-08-08","2020-08-09","2020-08-10","2020-08-11","2020-08-12","2020-08-13","2020-08-14","2020-08-15","2020-08-16","2020-08-17","2020-08-18","2020-08-19","2020-08-20","2020-08-21","2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14",{"$f":"JK9+1","v":"2020-09-15"},"2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10","2020-10-11","2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17",{"$f":"LW9+1","v":"2020-11-18"},"2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11","2020-12-12","2020-12-13","2020-12-14","2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30"]
[{"$f":"IF(B10,\"п\",\"н\")","v":"н"},{"$f":"SUMPRODUCT((F10<=$G$9:$G$100)*(G10>=$F$9:$F$100))>=$G$4","v":false},1,"Сотрудник 1","Специалист","2020-06-01","2020-06-15","2020-07-13","2020-07-27"]
[{"$f":"IF(B11,\"п\",\"н\")","v":"н"},{"$f":"SUMPRODUCT((F11<=$G$9:$G$100)*(G11>=$F$9:$F$100))>=$G$4","v":false},2,"Сотрудник 2","Специалист","2020-01-09","2020-01-17","2020-05-18","2020-05-31"]
["п",true,3,"Сотрудник 3","Специалист","2020-06-15","2020-07-01","2020-08-17","2020-08-30"]
["н",false,4,"Сотрудник 4","Специалист","2020-02-17","2020-02-21","2020-05-25","2020-05-29","2020-07-27","2020-08-11"]
["п",true,5,"Сотрудник 5","Специалист","2020-06-29","2020-08-06","2020-09-02","2020-09-10"]
["н",false,6,"Сотрудник 6","Специалист","2020-04-22","2020-04-30","2020-06-29","2020-07-17","2020-09-21","2020-09-25"]
["н",false,7,"Сотрудник 7","Специалист","2020-04-22","2020-04-30","2020-07-06","2020-07-24","2020-09-21","2020-09-25"]
["н",false,8,"Сотрудник 8","Специалист","2020-03-23","2020-03-27","2020-07-13","2020-08-07"]
["н",false,9,"Сотрудник 9","Специалист","2020-01-13","2020-01-31","2020-06-15","2020-06-26"]
["н",false,10,"Сотрудник 10","Специалист","2020-07-13","2020-08-13"]
["п",true,11,"Сотрудник 11","Специалист","2020-06-15","2020-07-17"]
["н",false,12,"Сотрудник 12","Специалист","2020-05-25","2020-05-29","2020-06-22","2020-07-10","2020-08-31","2020-09-06"]
["н",false,13,"Сотрудник 13","Специалист","2020-02-03","2020-02-07","2020-05-12","2020-05-22","2020-08-31","2020-09-11"]