{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Список","График смен"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":11,"n_cols":26,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"DATE('График смен'!$P$3,1,1)","v":"2015-01-01"},"Новый год",null,null,null,{"$f":"DATE('График смен'!$P$3,2,23)","v":"2015-02-23"},"День защитников Отечества и Вооруженных Сил Республики Беларусь"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,1,7)","v":"2015-01-07"},"Рождество Христово (православное)",null,null,null,{"$f":"DOLLAR((\"4/\"&'График смен'!P3)/7+MOD(19*MOD('График смен'!P3,19)-7,30)*14%,)*7-6","v":"2015-04-05"},"Католическая Пасха"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,3,8)","v":"2015-03-08"},"День женщин",null,null,null,{"$f":"IF((MOD(19*MOD('График смен'!$P$3,19)+15,30)+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7))<9,DATE('График смен'!$P$3,3,22+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7)+MOD(19*MOD('График смен'!$P$3,19)+15,30)+13),DATE('График смен'!$P$3,4,MOD(19*MOD('График смен'!$P$3,19)+15,30)+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7)-9+13))","v":"2015-04-12"},"Православная Пасха"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,5,1)","v":"2015-05-01"},"Праздник труда"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,5,9)","v":"2015-05-09"},"День Победы"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((MOD(19*MOD('График смен'!$P$3,19)+15,30)+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7))<9,DATE('График смен'!$P$3,3,22+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7)+MOD(19*MOD('График смен'!$P$3,19)+15,30)+13+9),DATE('График смен'!$P$3,4,MOD(19*MOD('График смен'!$P$3,19)+15,30)+MOD(2*MOD('График смен'!$P$3,4)+4*MOD('График смен'!$P$3,7)+6*MOD(19*MOD('График смен'!$P$3,19)+15,30)+6,7)-9+13+9))","v":"2015-04-21"},"Радоница"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,7,3)","v":"2015-07-03"},"День Независимости Республики Беларусь (День Республики)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,11,7)","v":"2015-11-07"},"День Октябрьской революции"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3,12,25)","v":"2015-12-25"},"Рождество Христово (католическое)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE('График смен'!$P$3+1,1,1)","v":"2016-01-01"},"Новый год"]

{"sheet":"График смен","index":1,"n_rows":152,"n_cols":41,"rows_kept":152,"cut":false,"hidden":false,"merged":[[4,38,5,38],[4,35,5,35],[4,37,5,37],[43,31,43,34],[44,31,44,34],[4,36,5,36],[2,15,2,18],[2,2,2,5],[2,8,2,9],[2,22,2,24],[2,13,2,14],[56,2,56,24],[57,2,57,24],[58,2,58,24],[59,2,59,24],[60,2,60,24],[52,2,52,24],[53,2,53,24],[54,2,54,24],[55,2,55,24],[46,31,46,34],[52,25,52,31],[4,1,5,1],[4,2,4,32],[4,33,5,33],[4,34,5,34],[45,31,45,34],[61,2,61,24],[62,2,62,24],[63,2,63,24],[64,2,64,24],[65,2,65,24],[66,2,66,24],[67,2,67,24],[68,2,68,24],[69,2,69,24],[70,2,70,24],[71,2,71,24],[72,2,72,24],[73,2,73,24],[74,2,74,24],[75,2,75,24],[76,2,76,24],[77,2,77,24],[78,2,78,24],[79,2,79,24],[80,2,80,24],[81,2,81,24],[82,2,82,24],[83,2,83,24],[84,2,84,24],[85,2,85,24],[86,2,86,24],[87,2,87,24],[88,2,88,24],[89,2,89,24],[90,2,90,24],[91,2,91,24],[92,2,92,24],[93,2,93,24],[94,2,94,24],[95,2,95,24],[101,2,101,24],[96,2,96,24],[97,2,97,24],[98,2,98,24],[99,2,99,24],[100,2,100,24],[122,2,122,24],[113,2,113,24],[114,2,114,24],[115,2,115,24],[116,2,116,24],[117,2,117,24],[102,2,102,24],[118,2,118,24],[119,2,119,24],[120,2,120,24],[121,2,121,24],[108,2,108,24],[109,2,109,24],[110,2,110,24],[111,2,111,24],[112,2,112,24],[103,2,103,24],[104,2,104,24],[105,2,105,24],[106,2,106,24],[107,2,107,24]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"год",null,2015,null,null,null,null,null,null,"смена №",null,null,1]
[]
[null,"Месяц","Смены",null,null,null,null,null,null,null,null,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":"DATE(YEAR(B$8),MONTH($B$8),1)","v":"2015-01-01"},{"$f":"IF(D7,DATE(YEAR($B$8),MONTH($B$8),DAY(C$6)+1),\"\")","v":"2015-01-02"},{"$f":"IF(E7,DATE(YEAR($B$8),MONTH($B$8),DAY(D$6)+1),\"\")","v":"2015-01-03"},"2015-01-04","2015-01-05","2015-01-06","2015-01-07","2015-01-08",{"$f":"IF(K7,DATE(YEAR($B$8),MONTH($B$8),DAY(J$6)+1),\"\")","v":"2015-01-09"},"2015-01-10","2015-01-11","2015-01-12","2015-01-13","2015-01-14","2015-01-15","2015-01-16","2015-01-17","2015-01-18","2015-01-19","2015-01-20","2015-01-21","2015-01-22","2015-01-23","2015-01-24","2015-01-25","2015-01-26","2015-01-27","2015-01-28","2015-01-29","2015-01-30","2015-01-31"]
[{"$f":"DAY(DATE(YEAR(B8),MONTH(B8)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays1,1,0)","v":"1900-01-01"},"1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01"]
[null,{"$f":"DATE($P$3,1,1)","v":"2015-01-01"},{"$f":"IF(C7,INDEX($S$44:$AD$47,$Z$3,MOD((C6+$Z$43),$Z$43)+1),\"\")","v":2},{"$f":"IF(D7,INDEX($S$44:$AD$47,$Z$3,MOD((D6+$Z$43),$Z$43)+1),\"\")","v":""},"",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",{"$f":"AI8*$C$47","v":180},{"$f":"COUNTIF(C8:AG8,\">0\")","v":15},{"$f":"NETWORKDAYS(C6,AG6,Holidays)*8-AK8","v":159},{"$f":"COUNT(MATCH((C6:AG6+1)*(WEEKDAY(C6:AG6,2)<6)*ISNA(MATCH(C6:AG6,Holidays,)),Holidays,))","v":1},{"$f":"IF(SUM(AH8-AJ8-AM8)<0,\"\",SUM(AH8-AJ8-AM8))","v":9},{"$f":"SUM(IF(ISNUMBER(MATCH(C6:AG6,Holidays,0)),--(C8:AG8<>\"\")))*$C$47","v":12},null,"Поправил красное УФ. Сделал одно на весь диапазон. Аналогично можете переделать остальные УФ"]
[null,null,{"$f":"DATE(YEAR($B$11),MONTH($B$11),1)","v":"2015-02-01"},{"$f":"IF(D10,DATE(YEAR($B$11),MONTH($B$11),DAY(C9)+1),\"\")","v":"2015-02-02"},{"$f":"IF(E10,DATE(YEAR($B$11),MONTH($B$11),DAY(D9)+1),\"\")","v":"2015-02-03"},"2015-02-04","2015-02-05","2015-02-06","2015-02-07","2015-02-08",{"$f":"IF(K10,DATE(YEAR($B$11),MONTH($B$11),DAY(J9)+1),\"\")","v":"2015-02-09"},"2015-02-10","2015-02-11","2015-02-12","2015-02-13","2015-02-14","2015-02-15","2015-02-16","2015-02-17","2015-02-18","2015-02-19","2015-02-20","2015-02-21","2015-02-22","2015-02-23","2015-02-24","2015-02-25","2015-02-26","2015-02-27","2015-02-28","","","",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C7:AG7,Holidays,0)),--(C9:AG9>0)))*$C$47","v":0},null,"Поправил имена Holidays и Holidays_2 - там была лишняя пустая ячейка снизу"]
[{"$f":"DAY(DATE(YEAR(B11),MONTH(B11)+1,))","v":28},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays2,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C8:AG8,Holidays,0)),--(C10:AG10>0)))*$C$47","v":0},null,"Добавил в праздники Новый год следующего года последней строкой"]
[null,{"$f":"DATE($P$3,2,1)","v":"2015-02-01"},{"$f":"IF(C10,INDEX($S$44:$AD$47,$Z$3,MOD((C9+$Z$43),$Z$43)+1),\"\")","v":2},{"$f":"IF(D10,INDEX($S$44:$AD$47,$Z$3,MOD((D9+$Z$43),$Z$43)+1),\"\")","v":2},"","",1,1,"","",2,2,"","",1,1,"","",{"$f":"IF(S10,INDEX($S$44:$AD$47,$Z$3,MOD((S9+$Z$43),$Z$43)+1),\"\")","v":2},2,"","",1,1,"","",2,2,"","","","","",{"$f":"AI11*$C$47","v":168},{"$f":"COUNTIF(C11:AG11,\">0\")","v":14},{"$f":"NETWORKDAYS(C9,IF(AE9<>\"\",AE9,AD9),Holidays)*8-AK11","v":160},{"$f":"COUNT(MATCH((C9:AG9+1)*(WEEKDAY(C9:AG9,2)<6)*ISNA(MATCH(C9:AG9,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH11-AJ11-AM11)<0,\"\",SUM(AH11-AJ11-AM11))","v":8},{"$f":"SUM(IF(ISNUMBER(MATCH(C9:AG9,Holidays,0)),--(C11:AG11<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$14),MONTH($B$14),1)","v":"2015-03-01"},{"$f":"IF(D13,DATE(YEAR($B$14),MONTH($B$14),DAY(C$12)+1),\"\")","v":"2015-03-02"},{"$f":"IF(E13,DATE(YEAR($B$14),MONTH($B$14),DAY(D$12)+1),\"\")","v":"2015-03-03"},"2015-03-04","2015-03-05","2015-03-06","2015-03-07","2015-03-08","2015-03-09","2015-03-10","2015-03-11","2015-03-12","2015-03-13","2015-03-14","2015-03-15","2015-03-16","2015-03-17","2015-03-18","2015-03-19","2015-03-20","2015-03-21","2015-03-22","2015-03-23","2015-03-24","2015-03-25","2015-03-26","2015-03-27","2015-03-28","2015-03-29","2015-03-30",{"$f":"IF(AG13,DATE(YEAR($B$14),MONTH($B$14),DAY(AF$12)+1),\"\")","v":"2015-03-31"},null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C10:AG10,Holidays,0)),--(C12:AG12>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B14),MONTH(B14)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays3,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C11:AG11,Holidays,0)),--(C13:AG13>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,3,1)","v":"2015-03-01"},{"$f":"IF(C13,INDEX($S$44:$AD$47,$Z$3,MOD((C12+$Z$43),$Z$43)+1),\"\")","v":1},{"$f":"IF(D13,INDEX($S$44:$AD$47,$Z$3,MOD((D12+$Z$43),$Z$43)+1),\"\")","v":1},"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"",192,16,{"$f":"NETWORKDAYS(C12,AG12,Holidays)*8-AK14","v":176},{"$f":"COUNT(MATCH((C12:AG12+1)*(WEEKDAY(C12:AG12,2)<6)*ISNA(MATCH(C12:AG12,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH14-AJ14-AM14)<0,\"\",SUM(AH14-AJ14-AM14))","v":16},{"$f":"SUM(IF(ISNUMBER(MATCH(C12:AG12,Holidays,0)),--(C14:AG14<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$17),MONTH($B$17),1)","v":"2015-04-01"},{"$f":"IF(D16,DATE(YEAR($B$17),MONTH($B$17),DAY(C$15)+1),\"\")","v":"2015-04-02"},{"$f":"IF(E16,DATE(YEAR($B$17),MONTH($B$17),DAY(D$15)+1),\"\")","v":"2015-04-03"},"2015-04-04","2015-04-05","2015-04-06","2015-04-07","2015-04-08","2015-04-09","2015-04-10","2015-04-11","2015-04-12","2015-04-13","2015-04-14","2015-04-15","2015-04-16","2015-04-17","2015-04-18","2015-04-19","2015-04-20","2015-04-21","2015-04-22","2015-04-23","2015-04-24","2015-04-25","2015-04-26","2015-04-27","2015-04-28","2015-04-29","2015-04-30","",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C13:AG13,Holidays,0)),--(C15:AG15>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B17),MONTH(B17)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays4,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C14:AG14,Holidays,0)),--(C16:AG16>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,4,1)","v":"2015-04-01"},{"$f":"IF(C16,INDEX($S$44:$AD$47,$Z$3,MOD((C15+$Z$43),$Z$43)+1),\"\")","v":""},{"$f":"IF(D16,INDEX($S$44:$AD$47,$Z$3,MOD((D15+$Z$43),$Z$43)+1),\"\")","v":1},1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,"",180,15,{"$f":"NETWORKDAYS(C15,AF15,Holidays)*8-AK17","v":166},{"$f":"COUNT(MATCH((C15:AG15+1)*(WEEKDAY(C15:AG15,2)<6)*ISNA(MATCH(C15:AG15,Holidays,)),Holidays,))","v":2},{"$f":"IF(SUM(AH17-AJ17-AM17)<0,\"\",SUM(AH17-AJ17-AM17))","v":14},{"$f":"SUM(IF(ISNUMBER(MATCH(C15:AG15,Holidays,0)),--(C17:AG17<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$20),MONTH($B$20),1)","v":"2015-05-01"},{"$f":"IF(D19,DATE(YEAR($B$20),MONTH($B$20),DAY(C$18)+1),\"\")","v":"2015-05-02"},{"$f":"IF(E19,DATE(YEAR($B$20),MONTH($B$20),DAY(D$18)+1),\"\")","v":"2015-05-03"},"2015-05-04","2015-05-05","2015-05-06","2015-05-07","2015-05-08","2015-05-09","2015-05-10","2015-05-11","2015-05-12","2015-05-13","2015-05-14","2015-05-15","2015-05-16","2015-05-17","2015-05-18","2015-05-19","2015-05-20","2015-05-21","2015-05-22","2015-05-23","2015-05-24","2015-05-25","2015-05-26","2015-05-27","2015-05-28","2015-05-29","2015-05-30","2015-05-31",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C16:AG16,Holidays,0)),--(C18:AG18>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B20),MONTH(B20)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays5,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C17:AG17,Holidays,0)),--(C19:AG19>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,5,1)","v":"2015-05-01"},{"$f":"IF(C19,INDEX($S$44:$AD$47,$Z$3,MOD((C18+$Z$43),$Z$43)+1),\"\")","v":2},{"$f":"IF(D19,INDEX($S$44:$AD$47,$Z$3,MOD((D18+$Z$43),$Z$43)+1),\"\")","v":""},"",1,1,"","",2,{"$f":"IF(K19,INDEX($S$44:$AD$47,$Z$3,MOD((K18+$Z$43),$Z$43)+1),\"\")","v":2},"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",180,15,{"$f":"NETWORKDAYS(C18,AG18,Holidays)*8-AK20","v":159},{"$f":"COUNT(MATCH((C18:AG18+1)*(WEEKDAY(C18:AG18,2)<6)*ISNA(MATCH(C18:AG18,Holidays,)),Holidays,))","v":1},{"$f":"IF(SUM(AH20-AJ20-AM20)<0,\"\",SUM(AH20-AJ20-AM20))","v":""},{"$f":"SUM(IF(ISNUMBER(MATCH(C18:AG18,Holidays,0)),--(C20:AG20<>\"\")))*$C$47","v":24}]
[null,null,{"$f":"DATE(YEAR($B$23),MONTH($B$23),1)","v":"2015-06-01"},{"$f":"IF(D22,DATE(YEAR($B$23),MONTH($B$23),DAY(C$21)+1),\"\")","v":"2015-06-02"},{"$f":"IF(E22,DATE(YEAR($B$23),MONTH($B$23),DAY(D$21)+1),\"\")","v":"2015-06-03"},"2015-06-04","2015-06-05","2015-06-06","2015-06-07","2015-06-08","2015-06-09","2015-06-10","2015-06-11","2015-06-12","2015-06-13","2015-06-14","2015-06-15","2015-06-16","2015-06-17","2015-06-18","2015-06-19","2015-06-20","2015-06-21","2015-06-22","2015-06-23","2015-06-24","2015-06-25","2015-06-26","2015-06-27","2015-06-28","2015-06-29","2015-06-30","",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C19:AG19,Holidays,0)),--(C21:AG21>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B23),MONTH(B23)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays6,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C20:AG20,Holidays,0)),--(C22:AG22>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,6,1)","v":"2015-06-01"},{"$f":"IF(C22,INDEX($S$44:$AD$47,$Z$3,MOD((C21+$Z$43),$Z$43)+1),\"\")","v":2},{"$f":"IF(D22,INDEX($S$44:$AD$47,$Z$3,MOD((D21+$Z$43),$Z$43)+1),\"\")","v":2},"","",1,1,"","",2,2,"","",1,1,"","",2,2,{"$f":"IF(U22,INDEX($S$44:$AD$47,$Z$3,MOD((U21+$Z$43),$Z$43)+1),\"\")","v":""},"",1,1,"","",2,2,"","",1,1,"",192,16,{"$f":"NETWORKDAYS(C21,AF21,Holidays)*8-AK23","v":176},{"$f":"COUNT(MATCH((C21:AG21+1)*(WEEKDAY(C21:AG21,2)<6)*ISNA(MATCH(C21:AG21,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH23-AJ23-AM23)<0,\"\",SUM(AH23-AJ23-AM23))","v":16},{"$f":"SUM(IF(ISNUMBER(MATCH(C21:AG21,Holidays,0)),--(C23:AG23<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$26),MONTH($B$26),1)","v":"2015-07-01"},{"$f":"IF(D25,DATE(YEAR($B$26),MONTH($B$26),DAY(C$24)+1),\"\")","v":"2015-07-02"},{"$f":"IF(E25,DATE(YEAR($B$26),MONTH($B$26),DAY(D$24)+1),\"\")","v":"2015-07-03"},"2015-07-04","2015-07-05","2015-07-06","2015-07-07","2015-07-08","2015-07-09","2015-07-10","2015-07-11","2015-07-12","2015-07-13","2015-07-14","2015-07-15","2015-07-16","2015-07-17","2015-07-18","2015-07-19","2015-07-20","2015-07-21","2015-07-22","2015-07-23","2015-07-24","2015-07-25","2015-07-26","2015-07-27","2015-07-28","2015-07-29","2015-07-30","2015-07-31",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C22:AG22,Holidays,0)),--(C24:AG24>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B26),MONTH(B26)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays7,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C23:AG23,Holidays,0)),--(C25:AG25>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,7,1)","v":"2015-07-01"},{"$f":"IF(C25,INDEX($S$44:$AD$47,$Z$3,MOD((C24+$Z$43),$Z$43)+1),\"\")","v":""},{"$f":"IF(D25,INDEX($S$44:$AD$47,$Z$3,MOD((D24+$Z$43),$Z$43)+1),\"\")","v":""},2,2,"","",1,1,"","",2,2,{"$f":"IF(O25,INDEX($S$44:$AD$47,$Z$3,MOD((O24+$Z$43),$Z$43)+1),\"\")","v":""},"",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,180,15,{"$f":"NETWORKDAYS(C24,AG24,Holidays)*8-AK26","v":175},{"$f":"COUNT(MATCH((C24:AG24+1)*(WEEKDAY(C24:AG24,2)<6)*ISNA(MATCH(C24:AG24,Holidays,)),Holidays,))","v":1},{"$f":"IF(SUM(AH26-AJ26-AM26)<0,\"\",SUM(AH26-AJ26-AM26))","v":""},{"$f":"SUM(IF(ISNUMBER(MATCH(C24:AG24,Holidays,0)),--(C26:AG26<>\"\")))*$C$47","v":12}]
[null,null,{"$f":"DATE(YEAR($B$29),MONTH($B$29),1)","v":"2015-08-01"},{"$f":"IF(D28,DATE(YEAR($B$29),MONTH($B$29),DAY(C$27)+1),\"\")","v":"2015-08-02"},{"$f":"IF(E28,DATE(YEAR($B$29),MONTH($B$29),DAY(D$27)+1),\"\")","v":"2015-08-03"},"2015-08-04","2015-08-05","2015-08-06","2015-08-07","2015-08-08","2015-08-09","2015-08-10","2015-08-11","2015-08-12","2015-08-13","2015-08-14","2015-08-15","2015-08-16","2015-08-17","2015-08-18","2015-08-19","2015-08-20","2015-08-21","2015-08-22","2015-08-23","2015-08-24","2015-08-25","2015-08-26","2015-08-27","2015-08-28","2015-08-29","2015-08-30","2015-08-31",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C25:AG25,Holidays,0)),--(C27:AG27>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B29),MONTH(B29)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays8,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C26:AG26,Holidays,0)),--(C28:AG28>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,8,1)","v":"2015-08-01"},{"$f":"IF(C28,INDEX($S$44:$AD$47,$Z$3,MOD((C27+$Z$43),$Z$43)+1),\"\")","v":1},{"$f":"IF(D28,INDEX($S$44:$AD$47,$Z$3,MOD((D27+$Z$43),$Z$43)+1),\"\")","v":""},"",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",180,15,{"$f":"NETWORKDAYS(C27,AG27,Holidays)*8-AK29","v":168},{"$f":"COUNT(MATCH((C27:AG27+1)*(WEEKDAY(C27:AG27,2)<6)*ISNA(MATCH(C27:AG27,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH29-AJ29-AM29)<0,\"\",SUM(AH29-AJ29-AM29))","v":12},{"$f":"SUM(IF(ISNUMBER(MATCH(C27:AG27,Holidays,0)),--(C29:AG29<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$32),MONTH($B$32),1)","v":"2015-09-01"},{"$f":"IF(D31,DATE(YEAR($B$32),MONTH($B$32),DAY(C$30)+1),\"\")","v":"2015-09-02"},{"$f":"IF(E31,DATE(YEAR($B$32),MONTH($B$32),DAY(D$30)+1),\"\")","v":"2015-09-03"},"2015-09-04","2015-09-05","2015-09-06","2015-09-07","2015-09-08","2015-09-09","2015-09-10","2015-09-11","2015-09-12","2015-09-13","2015-09-14","2015-09-15","2015-09-16","2015-09-17","2015-09-18","2015-09-19","2015-09-20","2015-09-21","2015-09-22","2015-09-23","2015-09-24","2015-09-25","2015-09-26","2015-09-27","2015-09-28","2015-09-29","2015-09-30","",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C28:AG28,Holidays,0)),--(C30:AG30>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B32),MONTH(B32)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays9,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C29:AG29,Holidays,0)),--(C31:AG31>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,9,1)","v":"2015-09-01"},{"$f":"IF(C31,INDEX($S$44:$AD$47,$Z$3,MOD((C30+$Z$43),$Z$43)+1),\"\")","v":1},{"$f":"IF(D31,INDEX($S$44:$AD$47,$Z$3,MOD((D30+$Z$43),$Z$43)+1),\"\")","v":1},"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"",192,16,{"$f":"NETWORKDAYS(C30,AF30,Holidays)*8-AK32","v":176},{"$f":"COUNT(MATCH((C30:AG30+1)*(WEEKDAY(C30:AG30,2)<6)*ISNA(MATCH(C30:AG30,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH32-AJ32-AM32)<0,\"\",SUM(AH32-AJ32-AM32))","v":16},{"$f":"SUM(IF(ISNUMBER(MATCH(C30:AG30,Holidays,0)),--(C32:AG32<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$35),MONTH($B$35),1)","v":"2015-10-01"},{"$f":"IF(D34,DATE(YEAR($B$35),MONTH($B$35),DAY(C$33)+1),\"\")","v":"2015-10-02"},{"$f":"IF(E34,DATE(YEAR($B$35),MONTH($B$35),DAY(D$33)+1),\"\")","v":"2015-10-03"},"2015-10-04","2015-10-05","2015-10-06","2015-10-07","2015-10-08","2015-10-09","2015-10-10","2015-10-11","2015-10-12","2015-10-13","2015-10-14","2015-10-15","2015-10-16","2015-10-17","2015-10-18","2015-10-19","2015-10-20","2015-10-21","2015-10-22","2015-10-23","2015-10-24","2015-10-25","2015-10-26","2015-10-27","2015-10-28","2015-10-29","2015-10-30","2015-10-31",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C31:AG31,Holidays,0)),--(C33:AG33>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B35),MONTH(B35)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays10,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C32:AG32,Holidays,0)),--(C34:AG34>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,10,1)","v":"2015-10-01"},{"$f":"IF(C34,INDEX($S$44:$AD$47,$Z$3,MOD((C33+$Z$43),$Z$43)+1),\"\")","v":""},{"$f":"IF(D34,INDEX($S$44:$AD$47,$Z$3,MOD((D33+$Z$43),$Z$43)+1),\"\")","v":""},1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,180,15,{"$f":"NETWORKDAYS(C33,AG33,Holidays)*8","v":176},{"$f":"COUNT(MATCH((C33:AG33+1)*(WEEKDAY(C33:AG33,2)<6)*ISNA(MATCH(C33:AG33,Holidays,)),Holidays,))","v":0},{"$f":"IF(SUM(AH35-AJ35-AM35)<0,\"\",SUM(AH35-AJ35-AM35))","v":4},{"$f":"SUM(IF(ISNUMBER(MATCH(C33:AG33,Holidays,0)),--(C35:AG35<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$38),MONTH($B$38),1)","v":"2015-11-01"},{"$f":"IF(D37,DATE(YEAR($B$38),MONTH($B$38),DAY(C$36)+1),\"\")","v":"2015-11-02"},{"$f":"IF(E37,DATE(YEAR($B$38),MONTH($B$38),DAY(D$36)+1),\"\")","v":"2015-11-03"},"2015-11-04","2015-11-05","2015-11-06","2015-11-07","2015-11-08","2015-11-09","2015-11-10","2015-11-11","2015-11-12","2015-11-13","2015-11-14","2015-11-15","2015-11-16","2015-11-17","2015-11-18","2015-11-19","2015-11-20","2015-11-21","2015-11-22","2015-11-23","2015-11-24","2015-11-25","2015-11-26","2015-11-27","2015-11-28","2015-11-29","2015-11-30","",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C34:AG34,Holidays,0)),--(C36:AG36>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B38),MONTH(B38)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays11,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C35:AG35,Holidays,0)),--(C37:AG37>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,11,1)","v":"2015-11-01"},{"$f":"IF(C37,INDEX($S$44:$AD$47,$Z$3,MOD((C36+$Z$43),$Z$43)+1),\"\")","v":2},{"$f":"IF(D37,INDEX($S$44:$AD$47,$Z$3,MOD((D36+$Z$43),$Z$43)+1),\"\")","v":""},"",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",180,15,{"$f":"NETWORKDAYS(C36,AF36,Holidays)*8-AK38","v":167},{"$f":"COUNT(MATCH((C36:AG36+1)*(WEEKDAY(C36:AG36,2)<6)*ISNA(MATCH(C36:AG36,Holidays,)),Holidays,))","v":1},{"$f":"IF(SUM(AH38-AJ38-AM38)<0,\"\",SUM(AH38-AJ38-AM38))","v":13},{"$f":"SUM(IF(ISNUMBER(MATCH(C36:AG36,Holidays,0)),--(C38:AG38<>\"\")))*$C$47","v":0}]
[null,null,{"$f":"DATE(YEAR($B$41),MONTH($B$41),1)","v":"2015-12-01"},{"$f":"IF(D40,DATE(YEAR($B$41),MONTH($B$41),DAY(C$39)+1),\"\")","v":"2015-12-02"},{"$f":"IF(E40,DATE(YEAR($B$41),MONTH($B$41),DAY(D$39)+1),\"\")","v":"2015-12-03"},"2015-12-04","2015-12-05","2015-12-06","2015-12-07","2015-12-08","2015-12-09","2015-12-10","2015-12-11","2015-12-12","2015-12-13","2015-12-14","2015-12-15","2015-12-16","2015-12-17","2015-12-18","2015-12-19","2015-12-20","2015-12-21","2015-12-22","2015-12-23","2015-12-24","2015-12-25","2015-12-26","2015-12-27","2015-12-28","2015-12-29","2015-12-30","2015-12-31",null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C37:AG37,Holidays,0)),--(C39:AG39>0)))*$C$47","v":0}]
[{"$f":"DAY(DATE(YEAR(B41),MONTH(B41)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays12,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,{"$f":"SUM(IF(ISNUMBER(MATCH(C38:AG38,Holidays,0)),--(C40:AG40>0)))*$C$47","v":0}]
[null,{"$f":"DATE($P$3,12,1)","v":"2015-12-01"},{"$f":"IF(C40,INDEX($S$44:$AD$47,$Z$3,MOD((C39+$Z$43),$Z$43)+1),\"\")","v":""},{"$f":"IF(D40,INDEX($S$44:$AD$47,$Z$3,MOD((D39+$Z$43),$Z$43)+1),\"\")","v":2},2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,"","",2,2,"","",1,1,192,16,{"$f":"NETWORKDAYS(C39,AG39,Holidays)*8-AK41","v":174},{"$f":"COUNT(MATCH((C39:AG39+1)*(WEEKDAY(C39:AG39,2)<6)*ISNA(MATCH(C39:AG39,Holidays,)),Holidays,))","v":2},{"$f":"IF(SUM(AH41-AJ41-AM41)<0,\"\",SUM(AH41-AJ41-AM41))","v":18},{"$f":"SUM(IF(ISNUMBER(MATCH(C39:AG39,Holidays,0)),--(C41:AG41<>\"\")))*$C$47","v":0}]
[null,null,null,null,null,null,null,null,null,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":"SUM(AH8:AH41)","v":2196},{"$f":"SUM(AI8:AI41)","v":183},{"$f":"SUM(AJ8:AJ41)","v":2032},{"$f":"SUM(AK8:AK41)","v":8},{"$f":"SUM(AL8:AL41)","v":126},{"$f":"SUM(AM8:AM41)","v":48}]
[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":"IF($Z$3=1,COUNTA($S$44:$AD$44))+IF($Z$3=2,COUNTA($S$45:$AD$45))+IF($Z$3=3,COUNTA($S$46:$AD$46))+IF($Z$3=4,COUNTA($S$47:$AD$47))","v":8},"дней"]
[null,null,1,"ночная смена",null,null,null,null,"выходной день",null,null,null,null,null,"суббота",null,null,null,1,1,"","",2,2,"","",null,null,null,null,"-","см. Хомич Н.Н."]
[null,null,2,"дневная смена",null,null,null,null,"праздничный день",null,null,null,null,null,"воскресенье",null,null,null,2,2,"","",1,1,"","",null,null,null,null,"-","см. Булавский А.В."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",2,2,"","",1,1,null,null,null,null,"-","см. Сушкевич А.А."]
[null,null,12,"-","график работы, часов",null,null,null,null,null,null,"сегодня",null,null,null,null,null,null,"","",1,1,"","",2,2,null,null,null,null,"-","см. Сандульская Л.А."]
[]
[null,null,{"$f":"CONCATENATE(\"Государственные праздники и нерабочие (выходные) дни в \",$P$3,\" году:\")","v":"Государственные праздники и нерабочие (выходные) дни в 2015 году:"}]
[]
[null,null,60,"-",{"$f":"CONCATENATE(\"ближайшие \",C51,\" дней праздники:\")","v":"ближайшие 60 дней праздники:"}]
[]
[null,{"$f":"Список!T2","v":"2015-01-01"},{"$f":"Список!U2","v":"Новый год"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сайт календарь.by >>>"]
[null,{"$f":"Список!T3","v":"2015-01-07"},{"$f":"Список!U3","v":"Рождество Христово (православное)"}]
[null,{"$f":"Список!T4","v":"2015-03-08"},{"$f":"Список!U4","v":"День женщин"}]
[null,{"$f":"Список!T5","v":"2015-05-01"},{"$f":"Список!U5","v":"Праздник труда"}]
[null,{"$f":"Список!T6","v":"2015-05-09"},{"$f":"Список!U6","v":"День Победы"}]
[null,{"$f":"Список!T7","v":"2015-04-21"},{"$f":"Список!U7","v":"Радоница"}]
[null,{"$f":"Список!T8","v":"2015-07-03"},{"$f":"Список!U8","v":"День Независимости Республики Беларусь (День Республики)"}]
[null,{"$f":"Список!T9","v":"2015-11-07"},{"$f":"Список!U9","v":"День Октябрьской революции"}]
[null,{"$f":"Список!T10","v":"2015-12-25"},{"$f":"Список!U10","v":"Рождество Христово (католическое)"}]
[null,{"$f":"Список!T11","v":"2016-01-01"},{"$f":"Список!U11","v":"Новый год"}]
[null,{"$f":"Список!T12","v":"00:00:00"},{"$f":"Список!U12","v":0}]
[null,{"$f":"Список!T13","v":"00:00:00"},{"$f":"Список!U13","v":0}]
[null,{"$f":"Список!T14","v":"00:00:00"},{"$f":"Список!U14","v":0}]
[null,{"$f":"Список!T15","v":"00:00:00"},{"$f":"Список!U15","v":0}]
[null,{"$f":"Список!T16","v":"00:00:00"},{"$f":"Список!U16","v":0}]
[null,{"$f":"Список!T17","v":"00:00:00"},{"$f":"Список!U17","v":0}]
[null,{"$f":"Список!T18","v":"00:00:00"},{"$f":"Список!U18","v":0}]
[null,{"$f":"Список!T19","v":"00:00:00"},{"$f":"Список!U19","v":0}]
[null,{"$f":"Список!T20","v":"00:00:00"},{"$f":"Список!U20","v":0}]
[null,{"$f":"Список!T21","v":"00:00:00"},{"$f":"Список!U21","v":0}]
[null,{"$f":"Список!T22","v":"00:00:00"},{"$f":"Список!U22","v":0}]
[null,{"$f":"Список!T23","v":"00:00:00"},{"$f":"Список!U23","v":0}]
[null,{"$f":"Список!T24","v":"00:00:00"},{"$f":"Список!U24","v":0}]
[null,{"$f":"Список!T25","v":"00:00:00"},{"$f":"Список!U25","v":0}]
[null,{"$f":"Список!T26","v":"00:00:00"},{"$f":"Список!U26","v":0}]
[null,{"$f":"Список!T27","v":"00:00:00"},{"$f":"Список!U27","v":0}]
[null,{"$f":"Список!T28","v":"00:00:00"},{"$f":"Список!U28","v":0}]
[null,{"$f":"Список!T29","v":"00:00:00"},{"$f":"Список!U29","v":0}]
[null,{"$f":"Список!T30","v":"00:00:00"},{"$f":"Список!U30","v":0}]
[null,{"$f":"Список!T31","v":"00:00:00"},{"$f":"Список!U31","v":0}]
[null,{"$f":"Список!T32","v":"00:00:00"},{"$f":"Список!U32","v":0}]
[null,{"$f":"Список!T33","v":"00:00:00"},{"$f":"Список!U33","v":0}]
[null,{"$f":"Список!T34","v":"00:00:00"},{"$f":"Список!U34","v":0}]
[null,{"$f":"Список!T35","v":"00:00:00"},{"$f":"Список!U35","v":0}]
[null,{"$f":"Список!T36","v":"00:00:00"},{"$f":"Список!U36","v":0}]
[null,{"$f":"Список!T37","v":"00:00:00"},{"$f":"Список!U37","v":0}]
[null,{"$f":"Список!T38","v":"00:00:00"},{"$f":"Список!U38","v":0}]
[null,{"$f":"Список!T39","v":"00:00:00"},{"$f":"Список!U39","v":0}]
[null,{"$f":"Список!T40","v":"00:00:00"},{"$f":"Список!U40","v":0}]
[null,{"$f":"Список!T41","v":"00:00:00"},{"$f":"Список!U41","v":0}]
[null,{"$f":"Список!T42","v":"00:00:00"},{"$f":"Список!U42","v":0}]
[null,{"$f":"Список!T43","v":"00:00:00"},{"$f":"Список!U43","v":0}]
[null,{"$f":"Список!T44","v":"00:00:00"},{"$f":"Список!U44","v":0}]
[null,{"$f":"Список!T45","v":"00:00:00"},{"$f":"Список!U45","v":0}]
[null,{"$f":"Список!T46","v":"00:00:00"},{"$f":"Список!U46","v":0}]
[null,{"$f":"Список!T47","v":"00:00:00"},{"$f":"Список!U47","v":0}]
[null,{"$f":"Список!T48","v":"00:00:00"},{"$f":"Список!U48","v":0}]
[null,{"$f":"Список!T49","v":"00:00:00"},{"$f":"Список!U49","v":0}]
[null,{"$f":"Список!T50","v":"00:00:00"},{"$f":"Список!U50","v":0}]
[null,{"$f":"Список!T51","v":"00:00:00"},{"$f":"Список!U51","v":0}]
[null,null,{"$f":"CONCATENATE(\"Рабочие праздники в \",P3,\" году:\")","v":"Рабочие праздники в 2015 году:"}]
[null,{"$f":"Список!Y2","v":"2015-02-23"},{"$f":"Список!Z2","v":"День защитников Отечества и Вооруженных Сил Республики Беларусь"}]
[null,{"$f":"Список!Y3","v":"2015-04-05"},{"$f":"Список!Z3","v":"Католическая Пасха"}]
[null,{"$f":"Список!Y4","v":"2015-04-12"},{"$f":"Список!Z4","v":"Православная Пасха"}]
[null,{"$f":"Список!Y5","v":"00:00:00"},{"$f":"Список!Z5","v":0}]
[null,{"$f":"Список!Y6","v":"00:00:00"},{"$f":"Список!Z6","v":0}]
[null,{"$f":"Список!Y7","v":"00:00:00"},{"$f":"Список!Z7","v":0}]
[null,{"$f":"Список!Y8","v":"00:00:00"},{"$f":"Список!Z8","v":0}]
[null,{"$f":"Список!Y9","v":"00:00:00"},{"$f":"Список!Z9","v":0}]
[null,{"$f":"Список!Y10","v":"00:00:00"},{"$f":"Список!Z10","v":0}]
[null,{"$f":"Список!Y11","v":"00:00:00"},{"$f":"Список!Z11","v":0}]
[null,{"$f":"Список!Y12","v":"00:00:00"},{"$f":"Список!Z12","v":0}]
[null,{"$f":"Список!Y13","v":"00:00:00"},{"$f":"Список!Z13","v":0}]
[null,{"$f":"Список!Y14","v":"00:00:00"},{"$f":"Список!Z14","v":0}]
[null,{"$f":"Список!Y15","v":"00:00:00"},{"$f":"Список!Z15","v":0}]
[null,{"$f":"Список!Y16","v":"00:00:00"},{"$f":"Список!Z16","v":0}]
[null,{"$f":"Список!Y17","v":"00:00:00"},{"$f":"Список!Z17","v":0}]
[null,{"$f":"Список!Y18","v":"00:00:00"},{"$f":"Список!Z18","v":0}]
[null,{"$f":"Список!Y19","v":"00:00:00"},{"$f":"Список!Z19","v":0}]
[null,{"$f":"Список!Y20","v":"00:00:00"},{"$f":"Список!Z20","v":0}]
[null,{"$f":"Список!T71","v":"00:00:00"},{"$f":"Список!Z21","v":0}]
[null,{"$f":"Список!T72","v":"00:00:00"},{"$f":"Список!U72","v":0}]
[null,{"$f":"Список!T73","v":"00:00:00"},{"$f":"Список!U73","v":0}]
[null,{"$f":"Список!T74","v":"00:00:00"},{"$f":"Список!U74","v":0}]
[null,{"$f":"Список!T75","v":"00:00:00"},{"$f":"Список!U75","v":0}]
[null,{"$f":"Список!T76","v":"00:00:00"},{"$f":"Список!U76","v":0}]
[null,{"$f":"Список!T77","v":"00:00:00"},{"$f":"Список!U77","v":0}]
[null,{"$f":"Список!T78","v":"00:00:00"},{"$f":"Список!U78","v":0}]
[null,{"$f":"Список!T79","v":"00:00:00"},{"$f":"Список!U79","v":0}]
[null,{"$f":"Список!T80","v":"00:00:00"},{"$f":"Список!U80","v":0}]
[null,{"$f":"Список!T81","v":"00:00:00"},{"$f":"Список!U81","v":0}]
[null,{"$f":"Список!T82","v":"00:00:00"},{"$f":"Список!U82","v":0}]
[null,{"$f":"Список!T83","v":"00:00:00"},{"$f":"Список!U83","v":0}]
[null,{"$f":"Список!T84","v":"00:00:00"},{"$f":"Список!U84","v":0}]
[null,{"$f":"Список!T85","v":"00:00:00"},{"$f":"Список!U85","v":0}]
[null,{"$f":"Список!T86","v":"00:00:00"},{"$f":"Список!U86","v":0}]
[null,{"$f":"Список!T87","v":"00:00:00"},{"$f":"Список!U87","v":0}]
[null,{"$f":"Список!T88","v":"00:00:00"},{"$f":"Список!U88","v":0}]
[null,{"$f":"Список!T89","v":"00:00:00"},{"$f":"Список!U89","v":0}]
[null,{"$f":"Список!T90","v":"00:00:00"},{"$f":"Список!U90","v":0}]
[null,{"$f":"Список!T91","v":"00:00:00"},{"$f":"Список!U91","v":0}]
[null,{"$f":"Список!T92","v":"00:00:00"},{"$f":"Список!U92","v":0}]
[null,{"$f":"Список!T93","v":"00:00:00"},{"$f":"Список!U93","v":0}]
[null,{"$f":"Список!T94","v":"00:00:00"},{"$f":"Список!U94","v":0}]
[null,{"$f":"Список!T95","v":"00:00:00"},{"$f":"Список!U95","v":0}]
[null,{"$f":"Список!T96","v":"00:00:00"},{"$f":"Список!U96","v":0}]
[null,{"$f":"Список!T97","v":"00:00:00"},{"$f":"Список!U97","v":0}]
[null,{"$f":"Список!T98","v":"00:00:00"},{"$f":"Список!U98","v":0}]
[null,{"$f":"Список!T99","v":"00:00:00"},{"$f":"Список!U99","v":0}]
[null,{"$f":"Список!T100","v":"00:00:00"},{"$f":"Список!U100","v":0}]