{"text_format":"1","workbook":"xlsx","n_sheets":1,"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":32,"n_cols":56,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,28,12,33],[12,2,12,6],[12,7,12,11],[12,12,12,17],[12,18,12,22],[12,23,12,27],[8,37,8,55],[11,11,11,12],[2,52,3,52],[2,53,3,53],[2,54,3,54],[2,55,3,55],[2,35,3,35],[2,36,8,36],[2,37,3,37],[2,38,3,38],[11,6,11,7],[3,28,3,33],[2,46,3,46],[2,47,3,47],[2,48,3,48],[3,2,3,6],[3,7,3,11],[3,12,3,17],[3,18,3,22],[3,23,3,27],[2,50,3,50],[2,51,3,51],[2,45,3,45],[2,39,3,39],[2,49,3,49],[2,40,3,40],[2,41,3,41],[2,42,3,42],[2,43,3,43],[2,44,3,44],[20,17,20,18],[18,35,18,36],[18,37,18,38],[18,41,18,44],[18,45,18,46],[19,41,19,44],[19,45,19,46],[15,51,20,55],[16,35,16,36],[16,37,16,38],[16,41,16,44],[16,45,16,46],[17,35,17,36],[17,37,17,38],[17,41,17,44],[17,45,17,46],[20,45,20,46],[1,27,1,33],[22,1,23,33],[22,41,22,44],[22,45,22,47],[20,6,20,7],[20,11,20,12],[31,1,31,33],[31,36,31,37],[31,43,31,44],[31,45,31,46],[26,1,26,33],[29,1,29,33],[30,1,30,33],[30,36,30,37],[30,43,30,44],[30,45,30,46],[31,47,31,48],[26,36,26,37],[30,47,30,48],[26,45,26,46],[26,47,26,48],[29,36,29,37],[29,45,29,46],[29,47,29,48],[4,37,4,55],[20,22,20,23],[11,17,11,18],[11,22,11,23],[11,27,11,28],[28,47,28,48],[23,48,23,49],[24,35,24,37],[27,36,27,37],[27,45,27,46],[27,47,27,48],[27,1,27,33],[28,1,28,33],[28,36,28,37],[28,45,28,46],[15,35,15,50],[22,49,22,54],[24,1,24,33],[25,1,25,33],[25,36,25,37],[25,45,25,46],[25,47,25,48],[20,27,20,28],[20,41,20,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,{"$f":"'[1]вых пт,сб'!Z2","v":"НА 2019 ГОД"}]
[null,null,null,null,null,null,null,null,null,null,null,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":"'[1]вых субб,воскр'!AK3:AK4","v":"2019 год"},"часы в табеле / в день","Январь","Февраль","Март","I квартал","Апрель","Май","Июнь","II квартал","1-е полу­годие","Июль","Август","Сентябрь","III квартал","Октябрь","Ноябрь","Декабрь","IV квартал","2-е полу­годие",{"$f":"AJ3","v":"2019 год"}]
[null,null,"Январь"]
[null,"Понедельник",null,7,14,21,28]
[null,"Вторник",1,8,15,22,29]
[null,"Среда",2,9,16,23,30,null,null,null,null,null,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":"СчетЧерных(C5:G11)","v":15},20,22,{"$f":"SUM(AL7:AN7)","v":57},21,20,21,{"$f":"SUM(AP7:AR7)","v":62},{"$f":"SUM(AO7,AS7)","v":119},22,22,21,{"$f":"SUM(AU7:AW7)","v":65},22,21,22,{"$f":"SUM(AY7:BA7)","v":65},{"$f":"SUM(AX7,BB7)","v":130},{"$f":"SUM(AT7,BC7)","v":249}]
[null,"Четверг",3,10,17,24,31]
[null,"Пятница",4,11,18,25]
[null,"Суббота",5,12,19,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,112,159,176,{"$f":"SUM(AL10:AN10)","v":447},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA7*$AK$10-1","v":175},{"$f":"SUM(AY10:BA10)","v":175},{"$f":"SUM(AX10,BB10)","v":175},{"$f":"AT10+BC10","v":175}]
[null,"Воскресенье",6,13,20,27]
[null,"№ недели",1,2,3,4,5,null,6,7,8,9,null,10,11,12,13,14,null,15,16,17,18,null,19,20,21,22,null,23,24,25,26]
[null,null,"Июль",null,null,null,null,"Август",null,null,null,null,"Сентябрь",null,null,null,null,null,"Октябрь",null,null,null,null,"Ноябрь",null,null,null,null,"Декабрь"]
[null,"Понедельник"]
[null,"Вторник"]
[null,"Среда"]
[null,"Четверг"]
[null,"Пятница"]
[null,"Суббота"]
[null,"Воскресенье"]
[null,"№ недели"]
[]
[null,"Возможно ли сделать так, чтобы в графе АL и далее автоматически считались рабочие дни из блока \"Январь\"? В феврале, соответственно, за февраль и т.п. Рабочие дни - это выделенные обычным черным нежирным шрифтом дни"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"исправить"]