{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Лист1","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,10,0,11],[0,0,1,0],[0,1,0,2],[0,3,0,4],[0,5,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,6],[10,0,11,0],[10,1,10,2],[10,3,10,4],[10,5,10,6],[11,1,11,2],[11,3,11,4],[11,5,11,6],[12,1,12,2],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[14,1,14,2],[14,3,14,4],[14,5,14,6],[15,1,15,2],[15,3,15,4],[15,5,15,6]]}
["ФИО","сб",null,"вс",null,"пн",null,null,null,null,"Легенда смен",null,"Значение цвета ячейки","комментарии"]
[null,"2014-11-01",null,"2014-11-02",null,"2014-11-03",null,null,null,null,"полуторная смена",null,{"$f":"смена2(L2)","v":40},"В случае использования других цветов Вы можете изменить цвет в Легенде"]
["Миша",null,null,"08:00:00","08:00:00",null,null,null,null,null,"двойная смена",null,{"$f":"смена2(K3)","v":33},"Функция Смена2( \"Ячейка\" ) определяет цвет заливки текущей ячейки и возвращает числовое значение для этого цвета"]
["Вася",null,null,null,null,"08:00:00","18:00:00",null,null,null,null,null,{"$f":"смена2(K4)","v":0},"и соответственно при расчете ориентируется на цвет ячеек в графике"]
["Петя","08:00:00","20:00:00"]
["Саша","08:00:00","20:00:00"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Инструкции по переносу VBA функции тут http://office.microsoft.com/ru-ru/excel-help/HA102749042.aspx"]
[]
["ФИО","сб",null,"вс",null,"пн"]
[null,"2014-11-01",null,"2014-11-02",null,"2014-11-03"]
["Миша",{"$f":"IF(B3=\"\",\"\",IF(AND(смена2(B3)=0,смена2(C3)=$M$2),IF(HOUR(B3)>=HOUR(C3),24-HOUR(B3)+HOUR(C3),HOUR(C3)-HOUR(B3))+IF(HOUR(B3)>=HOUR(C3),24-HOUR(B3)+ HOUR(C3), HOUR(C3)- HOUR(B3))/2,IF(AND(смена2(B3)=$M$3,смена2(C3)=$M$3),IF(HOUR(B3)>=HOUR(C3),24-HOUR(B3)+HOUR(C3),HOUR(C3)-HOUR(B3))*2,IF(HOUR(B3)>= HOUR(C3),24- HOUR(B3)+ HOUR(C3), HOUR(C3)- HOUR(B3)))))","v":""},null,{"$f":"IF(D3=\"\",\"\",IF(AND(смена2(D3)=0,смена2(E3)=$M$2),IF(HOUR(D3)>=HOUR(E3),24-HOUR(D3)+HOUR(E3),HOUR(E3)-HOUR(D3))+IF(HOUR(D3)>=HOUR(E3),24-HOUR(D3)+ HOUR(E3), HOUR(E3)- HOUR(D3))/2,IF(AND(смена2(D3)=$M$3,смена2(E3)=$M$3),IF(HOUR(D3)>=HOUR(E3),24-HOUR(D3)+HOUR(E3),HOUR(E3)-HOUR(D3))*2,IF(HOUR(D3)>= HOUR(E3),24- HOUR(D3)+ HOUR(E3), HOUR(E3)- HOUR(D3)))))","v":36},null,{"$f":"IF(F3=\"\",\"\",IF(AND(смена2(F3)=0,смена2(G3)=$M$2),IF(HOUR(F3)>=HOUR(G3),24-HOUR(F3)+HOUR(G3),HOUR(G3)-HOUR(F3))+IF(HOUR(F3)>=HOUR(G3),24-HOUR(F3)+ HOUR(G3), HOUR(G3)- HOUR(F3))/2,IF(AND(смена2(F3)=$M$3,смена2(G3)=$M$3),IF(HOUR(F3)>=HOUR(G3),24-HOUR(F3)+HOUR(G3),HOUR(G3)-HOUR(F3))*2,IF(HOUR(F3)>= HOUR(G3),24- HOUR(F3)+ HOUR(G3), HOUR(G3)- HOUR(F3)))))","v":""}]
["Вася",{"$f":"IF(B4=\"\",\"\",IF(AND(смена2(B4)=0,смена2(C4)=$M$2),IF(HOUR(B4)>=HOUR(C4),24-HOUR(B4)+HOUR(C4),HOUR(C4)-HOUR(B4))+IF(HOUR(B4)>=HOUR(C4),24-HOUR(B4)+ HOUR(C4), HOUR(C4)- HOUR(B4))/2,IF(AND(смена2(B4)=$M$3,смена2(C4)=$M$3),IF(HOUR(B4)>=HOUR(C4),24-HOUR(B4)+HOUR(C4),HOUR(C4)-HOUR(B4))*2,IF(HOUR(B4)>= HOUR(C4),24- HOUR(B4)+ HOUR(C4), HOUR(C4)- HOUR(B4)))))","v":""},null,{"$f":"IF(D4=\"\",\"\",IF(AND(смена2(D4)=0,смена2(E4)=$M$2),IF(HOUR(D4)>=HOUR(E4),24-HOUR(D4)+HOUR(E4),HOUR(E4)-HOUR(D4))+IF(HOUR(D4)>=HOUR(E4),24-HOUR(D4)+ HOUR(E4), HOUR(E4)- HOUR(D4))/2,IF(AND(смена2(D4)=$M$3,смена2(E4)=$M$3),IF(HOUR(D4)>=HOUR(E4),24-HOUR(D4)+HOUR(E4),HOUR(E4)-HOUR(D4))*2,IF(HOUR(D4)>= HOUR(E4),24- HOUR(D4)+ HOUR(E4), HOUR(E4)- HOUR(D4)))))","v":""},null,{"$f":"IF(F4=\"\",\"\",IF(AND(смена2(F4)=0,смена2(G4)=$M$2),IF(HOUR(F4)>=HOUR(G4),24-HOUR(F4)+HOUR(G4),HOUR(G4)-HOUR(F4))+IF(HOUR(F4)>=HOUR(G4),24-HOUR(F4)+ HOUR(G4), HOUR(G4)- HOUR(F4))/2,IF(AND(смена2(F4)=$M$3,смена2(G4)=$M$3),IF(HOUR(F4)>=HOUR(G4),24-HOUR(F4)+HOUR(G4),HOUR(G4)-HOUR(F4))*2,IF(HOUR(F4)>= HOUR(G4),24- HOUR(F4)+ HOUR(G4), HOUR(G4)- HOUR(F4)))))","v":10}]
["Петя",{"$f":"IF(B5=\"\",\"\",IF(AND(смена2(B5)=0,смена2(C5)=$M$2),IF(HOUR(B5)>=HOUR(C5),24-HOUR(B5)+HOUR(C5),HOUR(C5)-HOUR(B5))+IF(HOUR(B5)>=HOUR(C5),24-HOUR(B5)+ HOUR(C5), HOUR(C5)- HOUR(B5))/2,IF(AND(смена2(B5)=$M$3,смена2(C5)=$M$3),IF(HOUR(B5)>=HOUR(C5),24-HOUR(B5)+HOUR(C5),HOUR(C5)-HOUR(B5))*2,IF(HOUR(B5)>= HOUR(C5),24- HOUR(B5)+ HOUR(C5), HOUR(C5)- HOUR(B5)))))","v":12},null,{"$f":"IF(D5=\"\",\"\",IF(AND(смена2(D5)=0,смена2(E5)=$M$2),IF(HOUR(D5)>=HOUR(E5),24-HOUR(D5)+HOUR(E5),HOUR(E5)-HOUR(D5))+IF(HOUR(D5)>=HOUR(E5),24-HOUR(D5)+ HOUR(E5), HOUR(E5)- HOUR(D5))/2,IF(AND(смена2(D5)=$M$3,смена2(E5)=$M$3),IF(HOUR(D5)>=HOUR(E5),24-HOUR(D5)+HOUR(E5),HOUR(E5)-HOUR(D5))*2,IF(HOUR(D5)>= HOUR(E5),24- HOUR(D5)+ HOUR(E5), HOUR(E5)- HOUR(D5)))))","v":""},null,{"$f":"IF(F5=\"\",\"\",IF(AND(смена2(F5)=0,смена2(G5)=$M$2),IF(HOUR(F5)>=HOUR(G5),24-HOUR(F5)+HOUR(G5),HOUR(G5)-HOUR(F5))+IF(HOUR(F5)>=HOUR(G5),24-HOUR(F5)+ HOUR(G5), HOUR(G5)- HOUR(F5))/2,IF(AND(смена2(F5)=$M$3,смена2(G5)=$M$3),IF(HOUR(F5)>=HOUR(G5),24-HOUR(F5)+HOUR(G5),HOUR(G5)-HOUR(F5))*2,IF(HOUR(F5)>= HOUR(G5),24- HOUR(F5)+ HOUR(G5), HOUR(G5)- HOUR(F5)))))","v":""}]
["Саша",{"$f":"IF(B6=\"\",\"\",IF(AND(смена2(B6)=0,смена2(C6)=$M$2),IF(HOUR(B6)>=HOUR(C6),24-HOUR(B6)+HOUR(C6),HOUR(C6)-HOUR(B6))+IF(HOUR(B6)>=HOUR(C6),24-HOUR(B6)+ HOUR(C6), HOUR(C6)- HOUR(B6))/2,IF(AND(смена2(B6)=$M$3,смена2(C6)=$M$3),IF(HOUR(B6)>=HOUR(C6),24-HOUR(B6)+HOUR(C6),HOUR(C6)-HOUR(B6))*2,IF(HOUR(B6)>= HOUR(C6),24- HOUR(B6)+ HOUR(C6), HOUR(C6)- HOUR(B6)))))","v":24},null,{"$f":"IF(D6=\"\",\"\",IF(AND(смена2(D6)=0,смена2(E6)=$M$2),IF(HOUR(D6)>=HOUR(E6),24-HOUR(D6)+HOUR(E6),HOUR(E6)-HOUR(D6))+IF(HOUR(D6)>=HOUR(E6),24-HOUR(D6)+ HOUR(E6), HOUR(E6)- HOUR(D6))/2,IF(AND(смена2(D6)=$M$3,смена2(E6)=$M$3),IF(HOUR(D6)>=HOUR(E6),24-HOUR(D6)+HOUR(E6),HOUR(E6)-HOUR(D6))*2,IF(HOUR(D6)>= HOUR(E6),24- HOUR(D6)+ HOUR(E6), HOUR(E6)- HOUR(D6)))))","v":""},null,{"$f":"IF(F6=\"\",\"\",IF(AND(смена2(F6)=0,смена2(G6)=$M$2),IF(HOUR(F6)>=HOUR(G6),24-HOUR(F6)+HOUR(G6),HOUR(G6)-HOUR(F6))+IF(HOUR(F6)>=HOUR(G6),24-HOUR(F6)+ HOUR(G6), HOUR(G6)- HOUR(F6))/2,IF(AND(смена2(F6)=$M$3,смена2(G6)=$M$3),IF(HOUR(F6)>=HOUR(G6),24-HOUR(F6)+HOUR(G6),HOUR(G6)-HOUR(F6))*2,IF(HOUR(F6)>= HOUR(G6),24- HOUR(F6)+ HOUR(G6), HOUR(G6)- HOUR(F6)))))","v":""}]

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

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