{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["График смен"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":74,"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":69,"n_cols":38,"rows_kept":69,"cut":false,"hidden":false,"merged":[[2,37,3,37],[43,4,43,5],[1,2,1,5],[1,8,1,9],[1,10,1,13],[1,15,1,18],[2,33,3,33],[2,34,3,34],[2,35,3,35],[2,1,3,1],[2,2,2,32],[62,1,63,1],[62,2,62,32],[2,36,3,36],[53,28,53,34],[50,13,53,21]]}
[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,null,2012]
[null,"Месяц","Смены",null,null,null,null,null,null,null,null,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$6),MONTH($B$6),1)","v":"2012-01-01"},{"$f":"IF(D5,DATE(YEAR($B$6),MONTH($B$6),DAY(C$4)+1),\"\")","v":"2012-01-02"},{"$f":"IF(E5,DATE(YEAR($B$6),MONTH($B$6),DAY(D$4)+1),\"\")","v":"2012-01-03"},"2012-01-04","2012-01-05","2012-01-06","2012-01-07","2012-01-08","2012-01-09","2012-01-10","2012-01-11","2012-01-12","2012-01-13","2012-01-14","2012-01-15","2012-01-16","2012-01-17","2012-01-18","2012-01-19","2012-01-20","2012-01-21","2012-01-22","2012-01-23","2012-01-24","2012-01-25","2012-01-26","2012-01-27","2012-01-28","2012-01-29","2012-01-30","2012-01-31"]
[{"$f":"DAY(DATE(YEAR(B6),MONTH(B6)+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$2,1,1)","v":"2012-01-01"},{"$f":"IF(C5,INDEX($F$51:$M$54,$C$44,MOD((C4-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(D5,INDEX($F$51:$M$54,$C$44,MOD((D4-$C$4+8),8)+1),\"\")","v":2},0,0,1,1,0,0,2,2,0,0,1,1,0,0,2,2,0,0,1,1,0,0,2,2,0,0,1,1,0,{"$f":"AI6*12","v":192},{"$f":"COUNTIF(C6:AG6,\">0\")","v":16},151]
[null,null,{"$f":"DATE(YEAR($O$2),MONTH($B$9),1)","v":"1900-02-01"},{"$f":"IF(D8,DATE(YEAR($B$9),MONTH($B$9),DAY(C7)+1),\"\")","v":"2012-02-02"},{"$f":"IF(E8,DATE(YEAR($B$9),MONTH($B$9),DAY(D7)+1),\"\")","v":"2012-02-03"},"2012-02-04","2012-02-05","2012-02-06","2012-02-07","2012-02-08","2012-02-09","2012-02-10","2012-02-11","2012-02-12","2012-02-13","2012-02-14","2012-02-15","2012-02-16","2012-02-17","2012-02-18","2012-02-19","2012-02-20","2012-02-21","2012-02-22","2012-02-23","2012-02-24","2012-02-25","2012-02-26","2012-02-27","2012-02-28","2012-02-29","",""]
[{"$f":"DAY(DATE(YEAR(B9),MONTH(B9)+1,))","v":29},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays2,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","00:00:00","00:00:00"]
[null,{"$f":"DATE($P$2,2,1)","v":"2012-02-01"},{"$f":"IF(C8,INDEX($F$51:$M$54,$C$44,MOD((C7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(D8,INDEX($F$51:$M$54,$C$44,MOD((D7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(E8,INDEX($F$51:$M$54,$C$44,MOD((E7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(F8,INDEX($F$51:$M$54,$C$44,MOD((F7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(G8,INDEX($F$51:$M$54,$C$44,MOD((G7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(H8,INDEX($F$51:$M$54,$C$44,MOD((H7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(I8,INDEX($F$51:$M$54,$C$44,MOD((I7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(J8,INDEX($F$51:$M$54,$C$44,MOD((J7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(K8,INDEX($F$51:$M$54,$C$44,MOD((K7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(L8,INDEX($F$51:$M$54,$C$44,MOD((L7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(M8,INDEX($F$51:$M$54,$C$44,MOD((M7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(N8,INDEX($F$51:$M$54,$C$44,MOD((N7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(O8,INDEX($F$51:$M$54,$C$44,MOD((O7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(P8,INDEX($F$51:$M$54,$C$44,MOD((P7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(Q8,INDEX($F$51:$M$54,$C$44,MOD((Q7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(R8,INDEX($F$51:$M$54,$C$44,MOD((R7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(S8,INDEX($F$51:$M$54,$C$44,MOD((S7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(T8,INDEX($F$51:$M$54,$C$44,MOD((T7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(U8,INDEX($F$51:$M$54,$C$44,MOD((U7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(V8,INDEX($F$51:$M$54,$C$44,MOD((V7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(W8,INDEX($F$51:$M$54,$C$44,MOD((W7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(X8,INDEX($F$51:$M$54,$C$44,MOD((X7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(Y8,INDEX($F$51:$M$54,$C$44,MOD((Y7-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(Z8,INDEX($F$51:$M$54,$C$44,MOD((Z7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AA8,INDEX($F$51:$M$54,$C$44,MOD((AA7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AB8,INDEX($F$51:$M$54,$C$44,MOD((AB7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(AC8,INDEX($F$51:$M$54,$C$44,MOD((AC7-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(AD8,INDEX($F$51:$M$54,$C$44,MOD((AD7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AE8,INDEX($F$51:$M$54,$C$44,MOD((AE7-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AF8,INDEX($F$51:$M$54,$C$44,MOD((AF7-$C$4+8),8)+1),\"\")","v":""},{"$f":"IF(AG8,INDEX($F$51:$M$54,$C$44,MOD((AG7-$C$4+8),8)+1),\"\")","v":""},{"$f":"AI9*12","v":168},{"$f":"COUNTIF(C9:AG9,\">0\")","v":14},168]
[null,null,{"$f":"DATE(YEAR($B$12),MONTH($B$12),1)","v":"2012-03-01"},{"$f":"IF(D11,DATE(YEAR($B$12),MONTH($B$12),DAY(C$10)+1),\"\")","v":"2012-03-02"},{"$f":"IF(E11,DATE(YEAR($B$12),MONTH($B$12),DAY(D$10)+1),\"\")","v":"2012-03-03"},"2012-03-04","2012-03-05","2012-03-06","2012-03-07","2012-03-08","2012-03-09","2012-03-10","2012-03-11","2012-03-12","2012-03-13","2012-03-14","2012-03-15","2012-03-16","2012-03-17","2012-03-18","2012-03-19","2012-03-20","2012-03-21","2012-03-22","2012-03-23","2012-03-24","2012-03-25","2012-03-26","2012-03-27","2012-03-28","2012-03-29","2012-03-30","2012-03-31"]
[{"$f":"DAY(DATE(YEAR(B12),MONTH(B12)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays3,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$2,3,1)","v":"2012-03-01"},{"$f":"IF(C11,INDEX($F$51:$M$54,$C$44,MOD((C10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(D11,INDEX($F$51:$M$54,$C$44,MOD((D10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(E11,INDEX($F$51:$M$54,$C$44,MOD((E10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(F11,INDEX($F$51:$M$54,$C$44,MOD((F10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(G11,INDEX($F$51:$M$54,$C$44,MOD((G10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(H11,INDEX($F$51:$M$54,$C$44,MOD((H10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(I11,INDEX($F$51:$M$54,$C$44,MOD((I10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(J11,INDEX($F$51:$M$54,$C$44,MOD((J10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(K11,INDEX($F$51:$M$54,$C$44,MOD((K10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(L11,INDEX($F$51:$M$54,$C$44,MOD((L10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(M11,INDEX($F$51:$M$54,$C$44,MOD((M10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(N11,INDEX($F$51:$M$54,$C$44,MOD((N10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(O11,INDEX($F$51:$M$54,$C$44,MOD((O10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(P11,INDEX($F$51:$M$54,$C$44,MOD((P10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(Q11,INDEX($F$51:$M$54,$C$44,MOD((Q10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(R11,INDEX($F$51:$M$54,$C$44,MOD((R10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(S11,INDEX($F$51:$M$54,$C$44,MOD((S10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(T11,INDEX($F$51:$M$54,$C$44,MOD((T10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(U11,INDEX($F$51:$M$54,$C$44,MOD((U10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(V11,INDEX($F$51:$M$54,$C$44,MOD((V10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(W11,INDEX($F$51:$M$54,$C$44,MOD((W10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(X11,INDEX($F$51:$M$54,$C$44,MOD((X10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(Y11,INDEX($F$51:$M$54,$C$44,MOD((Y10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(Z11,INDEX($F$51:$M$54,$C$44,MOD((Z10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AA11,INDEX($F$51:$M$54,$C$44,MOD((AA10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(AB11,INDEX($F$51:$M$54,$C$44,MOD((AB10-$C$4+8),8)+1),\"\")","v":1},{"$f":"IF(AC11,INDEX($F$51:$M$54,$C$44,MOD((AC10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AD11,INDEX($F$51:$M$54,$C$44,MOD((AD10-$C$4+8),8)+1),\"\")","v":0},{"$f":"IF(AE11,INDEX($F$51:$M$54,$C$44,MOD((AE10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(AF11,INDEX($F$51:$M$54,$C$44,MOD((AF10-$C$4+8),8)+1),\"\")","v":2},{"$f":"IF(AG11,INDEX($F$51:$M$54,$C$44,MOD((AG10-$C$4+8),8)+1),\"\")","v":0},{"$f":"AI12*12","v":192},16,175]
[null,null,{"$f":"DATE(YEAR($B$15),MONTH($B$15),1)","v":"2012-04-01"},{"$f":"IF(D14,DATE(YEAR($B$15),MONTH($B$15),DAY(C$13)+1),\"\")","v":"2012-04-02"},{"$f":"IF(E14,DATE(YEAR($B$15),MONTH($B$15),DAY(D$13)+1),\"\")","v":"2012-04-03"},"2012-04-04","2012-04-05","2012-04-06","2012-04-07","2012-04-08","2012-04-09","2012-04-10","2012-04-11","2012-04-12","2012-04-13","2012-04-14","2012-04-15","2012-04-16","2012-04-17","2012-04-18","2012-04-19","2012-04-20","2012-04-21","2012-04-22","2012-04-23","2012-04-24","2012-04-25","2012-04-26","2012-04-27","2012-04-28","2012-04-29","2012-04-30",""]
[{"$f":"DAY(DATE(YEAR(B15),MONTH(B15)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays4,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","00:00:00"]
[null,{"$f":"DATE($P$2,4,1)","v":"2012-04-01"},"-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,null,180,15,168]
[null,null,{"$f":"DATE(YEAR($B$18),MONTH($B$18),1)","v":"2012-05-01"},{"$f":"IF(D17,DATE(YEAR($B$18),MONTH($B$18),DAY(C$16)+1),\"\")","v":"2012-05-02"},{"$f":"IF(E17,DATE(YEAR($B$18),MONTH($B$18),DAY(D$16)+1),\"\")","v":"2012-05-03"},"2012-05-04","2012-05-05","2012-05-06","2012-05-07","2012-05-08","2012-05-09","2012-05-10","2012-05-11","2012-05-12","2012-05-13","2012-05-14","2012-05-15","2012-05-16","2012-05-17","2012-05-18","2012-05-19","2012-05-20","2012-05-21","2012-05-22","2012-05-23","2012-05-24","2012-05-25","2012-05-26","2012-05-27","2012-05-28","2012-05-29","2012-05-30","2012-05-31"]
[{"$f":"DAY(DATE(YEAR(B18),MONTH(B18)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays5,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$2,5,1)","v":"2012-05-01"},1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",180,15,160]
[null,null,{"$f":"DATE(YEAR($B$21),MONTH($B$21),1)","v":"2012-06-01"},{"$f":"IF(D20,DATE(YEAR($B$21),MONTH($B$21),DAY(C$19)+1),\"\")","v":"2012-06-02"},{"$f":"IF(E20,DATE(YEAR($B$21),MONTH($B$21),DAY(D$19)+1),\"\")","v":"2012-06-03"},"2012-06-04","2012-06-05","2012-06-06","2012-06-07","2012-06-08","2012-06-09","2012-06-10","2012-06-11","2012-06-12","2012-06-13","2012-06-14","2012-06-15","2012-06-16","2012-06-17","2012-06-18","2012-06-19","2012-06-20","2012-06-21","2012-06-22","2012-06-23","2012-06-24","2012-06-25","2012-06-26","2012-06-27","2012-06-28","2012-06-29","2012-06-30",""]
[{"$f":"DAY(DATE(YEAR(B21),MONTH(B21)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays6,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","00:00:00"]
[null,{"$f":"DATE($P$2,6,1)","v":"2012-06-01"},1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,null,192,16,176]
[null,null,{"$f":"DATE(YEAR($B$24),MONTH($B$24),1)","v":"2012-07-01"},{"$f":"IF(D23,DATE(YEAR($B$24),MONTH($B$24),DAY(C$22)+1),\"\")","v":"2012-07-02"},{"$f":"IF(E23,DATE(YEAR($B$24),MONTH($B$24),DAY(D$22)+1),\"\")","v":"2012-07-03"},"2012-07-04","2012-07-05","2012-07-06","2012-07-07","2012-07-08","2012-07-09","2012-07-10","2012-07-11","2012-07-12","2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26","2012-07-27","2012-07-28","2012-07-29","2012-07-30","2012-07-31"]
[{"$f":"DAY(DATE(YEAR(B24),MONTH(B24)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays7,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$2,7,1)","v":"2012-07-01"},"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,180,15,168]
[null,null,{"$f":"DATE(YEAR($B$27),MONTH($B$27),1)","v":"2012-08-01"},{"$f":"IF(D26,DATE(YEAR($B$27),MONTH($B$27),DAY(C$25)+1),\"\")","v":"2012-08-02"},{"$f":"IF(E26,DATE(YEAR($B$27),MONTH($B$27),DAY(D$25)+1),\"\")","v":"2012-08-03"},"2012-08-04","2012-08-05","2012-08-06","2012-08-07","2012-08-08","2012-08-09","2012-08-10","2012-08-11","2012-08-12","2012-08-13","2012-08-14","2012-08-15","2012-08-16","2012-08-17","2012-08-18","2012-08-19","2012-08-20","2012-08-21","2012-08-22","2012-08-23","2012-08-24","2012-08-25","2012-08-26","2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31"]
[{"$f":"DAY(DATE(YEAR(B27),MONTH(B27)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays8,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$2,8,1)","v":"2012-08-01"},2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",180,15,184]
[null,null,{"$f":"DATE(YEAR($B$30),MONTH($B$30),1)","v":"2012-09-01"},{"$f":"IF(D29,DATE(YEAR($B$30),MONTH($B$30),DAY(C$28)+1),\"\")","v":"2012-09-02"},{"$f":"IF(E29,DATE(YEAR($B$30),MONTH($B$30),DAY(D$28)+1),\"\")","v":"2012-09-03"},"2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08","2012-09-09","2012-09-10","2012-09-11","2012-09-12","2012-09-13","2012-09-14","2012-09-15","2012-09-16","2012-09-17","2012-09-18","2012-09-19","2012-09-20","2012-09-21","2012-09-22","2012-09-23","2012-09-24","2012-09-25","2012-09-26","2012-09-27","2012-09-28","2012-09-29","2012-09-30",""]
[{"$f":"DAY(DATE(YEAR(B30),MONTH(B30)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays9,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","00:00:00"]
[null,{"$f":"DATE($P$2,9,1)","v":"2012-09-01"},2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,null,192,16,176]
[null,null,{"$f":"DATE(YEAR($B$33),MONTH($B$33),1)","v":"2012-10-01"},{"$f":"IF(D32,DATE(YEAR($B$33),MONTH($B$33),DAY(C$31)+1),\"\")","v":"2012-10-02"},{"$f":"IF(E32,DATE(YEAR($B$33),MONTH($B$33),DAY(D$31)+1),\"\")","v":"2012-10-03"},"2012-10-04","2012-10-05","2012-10-06","2012-10-07","2012-10-08","2012-10-09","2012-10-10","2012-10-11","2012-10-12","2012-10-13","2012-10-14","2012-10-15","2012-10-16","2012-10-17","2012-10-18","2012-10-19","2012-10-20","2012-10-21","2012-10-22","2012-10-23","2012-10-24","2012-10-25","2012-10-26","2012-10-27","2012-10-28","2012-10-29","2012-10-30","2012-10-31"]
[{"$f":"DAY(DATE(YEAR(B33),MONTH(B33)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays10,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$2,10,1)","v":"2012-10-01"},"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,180,15,168]
[null,null,{"$f":"DATE(YEAR($B$36),MONTH($B$36),1)","v":"2012-11-01"},{"$f":"IF(D35,DATE(YEAR($B$36),MONTH($B$36),DAY(C$34)+1),\"\")","v":"2012-11-02"},{"$f":"IF(E35,DATE(YEAR($B$36),MONTH($B$36),DAY(D$34)+1),\"\")","v":"2012-11-03"},"2012-11-04","2012-11-05","2012-11-06","2012-11-07","2012-11-08","2012-11-09","2012-11-10","2012-11-11","2012-11-12","2012-11-13","2012-11-14","2012-11-15","2012-11-16","2012-11-17","2012-11-18","2012-11-19","2012-11-20","2012-11-21","2012-11-22","2012-11-23","2012-11-24","2012-11-25","2012-11-26","2012-11-27","2012-11-28","2012-11-29","2012-11-30",""]
[{"$f":"DAY(DATE(YEAR(B36),MONTH(B36)+1,))","v":30},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays11,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","00:00:00"]
[null,{"$f":"DATE($P$2,11,1)","v":"2012-11-01"},1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-",null,180,15,168]
[null,null,{"$f":"DATE(YEAR($B$39),MONTH($B$39),1)","v":"2012-12-01"},{"$f":"IF(D38,DATE(YEAR($B$39),MONTH($B$39),DAY(C$37)+1),\"\")","v":"2012-12-02"},{"$f":"IF(E38,DATE(YEAR($B$39),MONTH($B$39),DAY(D$37)+1),\"\")","v":"2012-12-03"},"2012-12-04","2012-12-05","2012-12-06","2012-12-07","2012-12-08","2012-12-09","2012-12-10","2012-12-11","2012-12-12","2012-12-13","2012-12-14","2012-12-15","2012-12-16","2012-12-17","2012-12-18","2012-12-19","2012-12-20","2012-12-21","2012-12-22","2012-12-23","2012-12-24","2012-12-25","2012-12-26","2012-12-27","2012-12-28","2012-12-29","2012-12-30","2012-12-31"]
[{"$f":"DAY(DATE(YEAR(B39),MONTH(B39)+1,))","v":31},null,{"$f":"IF(COLUMN()-Toffset2<=Tdays12,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$2,12,1)","v":"2012-12-01"},"-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,"-","-",1,1,"-","-",2,2,192,16,176]
[null,null,null,null,null,null,null,null,null,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(AH6:AH39)","v":2208},{"$f":"SUM(AI6:AI39)","v":184},{"$f":"SUM(AJ6:AJ39)","v":2038}]
[null,null,1,"ночная смена",null,null,null,0,"выходной день",null,null,null,null,null,"суббота"]
[null,null,2,"дневная смена",null,null,null,null,"праздничный день",null,null,null,null,null,"воскресенье"]
[]
[null,null,2,"-","смена"]
[]
[]
[]
[]
[null,null,"1. всего 4 смены"]
[]
[null,null,"смена 1: ",null,null,1,1,null,null,2,2,null,null,"далее цикл повторяется"]
[null,null,"смена 2:",null,null,2,2,null,null,1,1]
[null,null,"смена 3:",null,null,null,null,1,1,null,null,2,2]
[null,null,"смена 4:",null,null,null,null,2,2,null,null,1,1]
[]
[]
[null,null,"2. обозначения:",null,null,null,1,"ночная смена"]
[null,null,null,null,null,null,2,"дневная смена"]
[null,null,null,null,null,null,null,"выходной"]
[]
[null,null,"3. должно быть так:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,"Месяц","Смены"]
[null,null,{"$f":"DATE(YEAR(B$6),MONTH($B$6),1)","v":"2012-01-01"},{"$f":"IF(D65,DATE(YEAR($B$6),MONTH($B$6),DAY(C$4)+1),\"\")","v":"2012-01-02"},{"$f":"IF(E65,DATE(YEAR($B$6),MONTH($B$6),DAY(D$4)+1),\"\")","v":"2012-01-03"},{"$f":"IF(F65,DATE(YEAR($B$6),MONTH($B$6),DAY(E$4)+1),\"\")","v":"2012-01-04"},{"$f":"IF(G65,DATE(YEAR($B$6),MONTH($B$6),DAY(F$4)+1),\"\")","v":"2012-01-05"},{"$f":"IF(H65,DATE(YEAR($B$6),MONTH($B$6),DAY(G$4)+1),\"\")","v":"2012-01-06"},{"$f":"IF(I65,DATE(YEAR($B$6),MONTH($B$6),DAY(H$4)+1),\"\")","v":"2012-01-07"},{"$f":"IF(J65,DATE(YEAR($B$6),MONTH($B$6),DAY(I$4)+1),\"\")","v":"2012-01-08"},{"$f":"IF(K65,DATE(YEAR($B$6),MONTH($B$6),DAY(J$4)+1),\"\")","v":"2012-01-09"},{"$f":"IF(L65,DATE(YEAR($B$6),MONTH($B$6),DAY(K$4)+1),\"\")","v":"2012-01-10"},{"$f":"IF(M65,DATE(YEAR($B$6),MONTH($B$6),DAY(L$4)+1),\"\")","v":"2012-01-11"},{"$f":"IF(N65,DATE(YEAR($B$6),MONTH($B$6),DAY(M$4)+1),\"\")","v":"2012-01-12"},{"$f":"IF(O65,DATE(YEAR($B$6),MONTH($B$6),DAY(N$4)+1),\"\")","v":"2012-01-13"},{"$f":"IF(P65,DATE(YEAR($B$6),MONTH($B$6),DAY(O$4)+1),\"\")","v":"2012-01-14"},{"$f":"IF(Q65,DATE(YEAR($B$6),MONTH($B$6),DAY(P$4)+1),\"\")","v":"2012-01-15"},{"$f":"IF(R65,DATE(YEAR($B$6),MONTH($B$6),DAY(Q$4)+1),\"\")","v":"2012-01-16"},{"$f":"IF(S65,DATE(YEAR($B$6),MONTH($B$6),DAY(R$4)+1),\"\")","v":"2012-01-17"},{"$f":"IF(T65,DATE(YEAR($B$6),MONTH($B$6),DAY(S$4)+1),\"\")","v":"2012-01-18"},{"$f":"IF(U65,DATE(YEAR($B$6),MONTH($B$6),DAY(T$4)+1),\"\")","v":"2012-01-19"},{"$f":"IF(V65,DATE(YEAR($B$6),MONTH($B$6),DAY(U$4)+1),\"\")","v":"2012-01-20"},{"$f":"IF(W65,DATE(YEAR($B$6),MONTH($B$6),DAY(V$4)+1),\"\")","v":"2012-01-21"},{"$f":"IF(X65,DATE(YEAR($B$6),MONTH($B$6),DAY(W$4)+1),\"\")","v":"2012-01-22"},{"$f":"IF(Y65,DATE(YEAR($B$6),MONTH($B$6),DAY(X$4)+1),\"\")","v":"2012-01-23"},{"$f":"IF(Z65,DATE(YEAR($B$6),MONTH($B$6),DAY(Y$4)+1),\"\")","v":"2012-01-24"},{"$f":"IF(AA65,DATE(YEAR($B$6),MONTH($B$6),DAY(Z$4)+1),\"\")","v":"2012-01-25"},{"$f":"IF(AB65,DATE(YEAR($B$6),MONTH($B$6),DAY(AA$4)+1),\"\")","v":"2012-01-26"},{"$f":"IF(AC65,DATE(YEAR($B$6),MONTH($B$6),DAY(AB$4)+1),\"\")","v":"2012-01-27"},{"$f":"IF(AD65,DATE(YEAR($B$6),MONTH($B$6),DAY(AC$4)+1),\"\")","v":"2012-01-28"},{"$f":"IF(AE65,DATE(YEAR($B$6),MONTH($B$6),DAY(AD$4)+1),\"\")","v":"2012-01-29"},{"$f":"IF(AF65,DATE(YEAR($B$6),MONTH($B$6),DAY(AE$4)+1),\"\")","v":"2012-01-30"},{"$f":"IF(AG65,DATE(YEAR($B$6),MONTH($B$6),DAY(AF$4)+1),\"\")","v":"2012-01-31"}]
[null,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$2,1,1)","v":"2012-01-01"},{"$f":"IF(C65=1,MOD($C$44-TRUNC(MOD((C$4)/2,2)),2),\"\")","v":0},{"$f":"IF(D65=1,MOD($C$44-TRUNC(MOD((D$4)/2,2)),2),\"\")","v":1},{"$f":"IF(E65=1,MOD($C$44-TRUNC(MOD((E$4)/2,2)),2),\"\")","v":1},0,0,2,2,0,0,1,1,0,0,2,2,0,0,1,1,0,0,2,2,0,0,1,1,0,0,2,2]
[null,null,{"$f":"DATE(YEAR($O$2),MONTH($B$9),1)","v":"1900-02-01"},{"$f":"IF(D68,DATE(YEAR($B$9),MONTH($B$9),DAY(C67)+1),\"\")","v":"2012-02-02"},{"$f":"IF(E68,DATE(YEAR($B$9),MONTH($B$9),DAY(D67)+1),\"\")","v":"2012-02-03"},{"$f":"IF(F68,DATE(YEAR($B$9),MONTH($B$9),DAY(E67)+1),\"\")","v":"2012-02-04"},{"$f":"IF(G68,DATE(YEAR($B$9),MONTH($B$9),DAY(F67)+1),\"\")","v":"2012-02-05"},{"$f":"IF(H68,DATE(YEAR($B$9),MONTH($B$9),DAY(G67)+1),\"\")","v":"2012-02-06"},{"$f":"IF(I68,DATE(YEAR($B$9),MONTH($B$9),DAY(H67)+1),\"\")","v":"2012-02-07"},{"$f":"IF(J68,DATE(YEAR($B$9),MONTH($B$9),DAY(I67)+1),\"\")","v":"2012-02-08"},{"$f":"IF(K68,DATE(YEAR($B$9),MONTH($B$9),DAY(J67)+1),\"\")","v":"2012-02-09"},{"$f":"IF(L68,DATE(YEAR($B$9),MONTH($B$9),DAY(K67)+1),\"\")","v":"2012-02-10"},{"$f":"IF(M68,DATE(YEAR($B$9),MONTH($B$9),DAY(L67)+1),\"\")","v":"2012-02-11"},{"$f":"IF(N68,DATE(YEAR($B$9),MONTH($B$9),DAY(M67)+1),\"\")","v":"2012-02-12"},{"$f":"IF(O68,DATE(YEAR($B$9),MONTH($B$9),DAY(N67)+1),\"\")","v":"2012-02-13"},{"$f":"IF(P68,DATE(YEAR($B$9),MONTH($B$9),DAY(O67)+1),\"\")","v":"2012-02-14"},{"$f":"IF(Q68,DATE(YEAR($B$9),MONTH($B$9),DAY(P67)+1),\"\")","v":"2012-02-15"},{"$f":"IF(R68,DATE(YEAR($B$9),MONTH($B$9),DAY(Q67)+1),\"\")","v":"2012-02-16"},{"$f":"IF(S68,DATE(YEAR($B$9),MONTH($B$9),DAY(R67)+1),\"\")","v":"2012-02-17"},{"$f":"IF(T68,DATE(YEAR($B$9),MONTH($B$9),DAY(S67)+1),\"\")","v":"2012-02-18"},{"$f":"IF(U68,DATE(YEAR($B$9),MONTH($B$9),DAY(T67)+1),\"\")","v":"2012-02-19"},{"$f":"IF(V68,DATE(YEAR($B$9),MONTH($B$9),DAY(U67)+1),\"\")","v":"2012-02-20"},{"$f":"IF(W68,DATE(YEAR($B$9),MONTH($B$9),DAY(V67)+1),\"\")","v":"2012-02-21"},{"$f":"IF(X68,DATE(YEAR($B$9),MONTH($B$9),DAY(W67)+1),\"\")","v":"2012-02-22"},{"$f":"IF(Y68,DATE(YEAR($B$9),MONTH($B$9),DAY(X67)+1),\"\")","v":"2012-02-23"},{"$f":"IF(Z68,DATE(YEAR($B$9),MONTH($B$9),DAY(Y67)+1),\"\")","v":"2012-02-24"},{"$f":"IF(AA68,DATE(YEAR($B$9),MONTH($B$9),DAY(Z67)+1),\"\")","v":"2012-02-25"},{"$f":"IF(AB68,DATE(YEAR($B$9),MONTH($B$9),DAY(AA67)+1),\"\")","v":"2012-02-26"},{"$f":"IF(AC68,DATE(YEAR($B$9),MONTH($B$9),DAY(AB67)+1),\"\")","v":"2012-02-27"},{"$f":"IF(AD68,DATE(YEAR($B$9),MONTH($B$9),DAY(AC67)+1),\"\")","v":"2012-02-28"},{"$f":"IF(AE68,DATE(YEAR($B$9),MONTH($B$9),DAY(AD67)+1),\"\")","v":"2012-02-29"},{"$f":"IF(AF68,DATE(YEAR($B$9),MONTH($B$9),DAY(AE67)+1),\"\")","v":""},{"$f":"IF(AG68,DATE(YEAR($B$9),MONTH($B$9),DAY(AF67)+1),\"\")","v":""}]
[null,null,{"$f":"IF(COLUMN()-Toffset2<=Tdays2,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","00:00:00","00:00:00"]
[null,{"$f":"DATE($P$2,2,1)","v":"2012-02-01"},"-","-","1900-01-01","1900-01-01","-","-","1900-01-02","1900-01-02","-","-","1900-01-01","1900-01-01","-","-","1900-01-02","1900-01-02","-","-","1900-01-01","1900-01-01","-","-","1900-01-02","1900-01-02","-","-","1900-01-01","1900-01-01","-"]