{"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":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[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,"2014-11-01",null,"2014-11-02",null,"2014-11-03",null,null,null,null,"полуторная смена",null,{"$f":"смена2(L2)","v":40}]
["Миша",null,null,8,8,null,null,null,null,null,"двойная смена",null,{"$f":"смена2(K3)","v":33}]
["Вася",null,null,null,null,8,19]
["Петя",20,8]
["Саша",8,20]
[]
[]
[]
[]
["ФИО","сб",null,"вс",null,"пн"]
[null,"2014-11-01",null,"2014-11-02",null,"2014-11-03"]
["Миша",{"$f":"IF(B3=\"\",\"\",IF(AND(смена2(B3)=$M$3,смена2(C3)=$M$3),IF(B3>=C3,24-B3+C3,C3-B3)*2,IF(AND(смена2(B3)=0,смена2(C3)=$M$2),IF(B3>=C3,24-B3+C3,C3-B3)+IF(B3>=C3,24-B3+C3,C3-B3)/2,IF(B3>=C3,24-B3+C3,C3-B3))))","v":""},null,{"$f":"IF(D3=\"\",\"\",IF(AND(смена2(D3)=$M$3,смена2(E3)=$M$3),IF(D3>=E3,24-D3+E3,E3-D3)*2,IF(AND(смена2(D3)=0,смена2(E3)=$M$2),IF(D3>=E3,24-D3+E3,E3-D3)+IF(D3>=E3,24-D3+E3,E3-D3)/2,IF(D3>=E3,24-D3+E3,E3-D3))))","v":36},null,{"$f":"IF(F3=\"\",\"\",IF(AND(смена2(F3)=$M$3,смена2(G3)=$M$3),IF(F3>=G3,24-F3+G3,G3-F3)*2,IF(AND(смена2(F3)=0,смена2(G3)=$M$2),IF(F3>=G3,24-F3+G3,G3-F3)+IF(F3>=G3,24-F3+G3,G3-F3)/2,IF(F3>=G3,24-F3+G3,G3-F3))))","v":""}]
["Вася",{"$f":"IF(B4=\"\",\"\",IF(AND(смена2(B4)=$M$3,смена2(C4)=$M$3),IF(B4>=C4,24-B4+C4,C4-B4)*2,IF(AND(смена2(B4)=0,смена2(C4)=$M$2),IF(B4>=C4,24-B4+C4,C4-B4)+IF(B4>=C4,24-B4+C4,C4-B4)/2,IF(B4>=C4,24-B4+C4,C4-B4))))","v":""},null,{"$f":"IF(D4=\"\",\"\",IF(AND(смена2(D4)=$M$3,смена2(E4)=$M$3),IF(D4>=E4,24-D4+E4,E4-D4)*2,IF(AND(смена2(D4)=0,смена2(E4)=$M$2),IF(D4>=E4,24-D4+E4,E4-D4)+IF(D4>=E4,24-D4+E4,E4-D4)/2,IF(D4>=E4,24-D4+E4,E4-D4))))","v":""},null,{"$f":"IF(F4=\"\",\"\",IF(AND(смена2(F4)=$M$3,смена2(G4)=$M$3),IF(F4>=G4,24-F4+G4,G4-F4)*2,IF(AND(смена2(F4)=0,смена2(G4)=$M$2),IF(F4>=G4,24-F4+G4,G4-F4)+IF(F4>=G4,24-F4+G4,G4-F4)/2,IF(F4>=G4,24-F4+G4,G4-F4))))","v":11}]
["Петя",{"$f":"IF(B5=\"\",\"\",IF(AND(смена2(B5)=$M$3,смена2(C5)=$M$3),IF(B5>=C5,24-B5+C5,C5-B5)*2,IF(AND(смена2(B5)=0,смена2(C5)=$M$2),IF(B5>=C5,24-B5+C5,C5-B5)+IF(B5>=C5,24-B5+C5,C5-B5)/2,IF(B5>=C5,24-B5+C5,C5-B5))))","v":12},null,{"$f":"IF(D5=\"\",\"\",IF(AND(смена2(D5)=$M$3,смена2(E5)=$M$3),IF(D5>=E5,24-D5+E5,E5-D5)*2,IF(AND(смена2(D5)=0,смена2(E5)=$M$2),IF(D5>=E5,24-D5+E5,E5-D5)+IF(D5>=E5,24-D5+E5,E5-D5)/2,IF(D5>=E5,24-D5+E5,E5-D5))))","v":""},null,{"$f":"IF(F5=\"\",\"\",IF(AND(смена2(F5)=$M$3,смена2(G5)=$M$3),IF(F5>=G5,24-F5+G5,G5-F5)*2,IF(AND(смена2(F5)=0,смена2(G5)=$M$2),IF(F5>=G5,24-F5+G5,G5-F5)+IF(F5>=G5,24-F5+G5,G5-F5)/2,IF(F5>=G5,24-F5+G5,G5-F5))))","v":""}]
["Саша",{"$f":"IF(B6=\"\",\"\",IF(AND(смена2(B6)=$M$3,смена2(C6)=$M$3),IF(B6>=C6,24-B6+C6,C6-B6)*2,IF(AND(смена2(B6)=0,смена2(C6)=$M$2),IF(B6>=C6,24-B6+C6,C6-B6)+IF(B6>=C6,24-B6+C6,C6-B6)/2,IF(B6>=C6,24-B6+C6,C6-B6))))","v":24},null,{"$f":"IF(D6=\"\",\"\",IF(AND(смена2(D6)=$M$3,смена2(E6)=$M$3),IF(D6>=E6,24-D6+E6,E6-D6)*2,IF(AND(смена2(D6)=0,смена2(E6)=$M$2),IF(D6>=E6,24-D6+E6,E6-D6)+IF(D6>=E6,24-D6+E6,E6-D6)/2,IF(D6>=E6,24-D6+E6,E6-D6))))","v":""},null,{"$f":"IF(F6=\"\",\"\",IF(AND(смена2(F6)=$M$3,смена2(G6)=$M$3),IF(F6>=G6,24-F6+G6,G6-F6)*2,IF(AND(смена2(F6)=0,смена2(G6)=$M$2),IF(F6>=G6,24-F6+G6,G6-F6)+IF(F6>=G6,24-F6+G6,G6-F6)/2,IF(F6>=G6,24-F6+G6,G6-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":[]}