{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Март","Апрель"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Март","index":0,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[24,0,24,31],[0,0,0,31],[1,0,2,0],[3,0,3,31],[10,0,10,31],[17,0,17,31],[69,0,69,31],[41,0,41,31],[48,0,48,31],[55,0,55,29],[60,0,60,29],[64,0,64,29],[66,0,66,31]]}
["Табель Март 2014"]
["ФИО",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,"Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн"]
["Администраторы"]
["Глебова Марина",null,null,9,8,8,8,11,null,null,null,8,11,8,8,null,null,8,8,9,8,9,null,null,9,8,9,9,9,null,null,null,{"$f":"SUM(B5:AF5)","v":165}]
[]
["Денисов Вадим",15,null,12,null,null,null,14,12,12,null,null,null,null,null,12,null,null,null,null,null,12,null,null,null,null,null,null,12,13,null,null,{"$f":"SUM(B7:AF7)","v":114}]
[null,7,null,7,null,null,null,7,7,7,null,null,null,null,null,7,null,null,null,null,null,7,null,null,null,null,null,null,7,7,null,null,{"$f":"SUM(B8:AF8)","v":63}]
["Цепилов Василий",14,null,null,null,null,12,13,14,null,null,12,null,16,12,12,null,null,null,16,14,12,12,null,12,12,12,12,12,12,null,null,{"$f":"SUM(B9:AF9)","v":231}]
[null,7,null,null,null,null,7,7,7,null,null,7,null,7,7,7,null,null,null,7,7,7,7,null,7,7,7,7,7,7,null,null,{"$f":"SUM(B10:AF10)","v":126}]
["Бармены"]
["Беленкин Сергей",14,null,null,null,13,null,12,13,null,12,null,null,12,12,null,null,null,null,12,null,null,null,null,null,null,12,12,12,null,null,null,{"$f":"SUM(B12:AF12)","v":136}]
[null,7,null,null,null,7,null,7,7,null,7,null,null,7,7,null,null,null,null,7,null,null,null,null,null,null,7,7,7,null,null,null,77]
["Максимов Дмитрий",12,null,null,12,null,12,null,13,12,null,12,12,3,null,12,null,12,12,null,10,11,12,null,12,12,null,null,null,12,null,null,193]
[null,7,null,null,7,null,7,null,7,7,null,7,7,null,null,7,null,7,7,null,null,7,7,null,7,7,null,null,null,7,null,null,105]
["Плешанов Дмитрий",null,null,12,null,null,null,12,null,null,null,null,null,null,null,12,null,null,null,null,12,12,12,null,null,null,null,null,12,12,null,null,96]
[null,null,null,7,null,null,null,7,null,null,null,null,null,null,null,7,null,null,null,null,7,7,7,null,null,null,null,null,7,7,null,null,56]
["Официанты 5/2"]
["Петрякова Оксана",null,null,8,8,8,12,8,null,null,null,8,null,8,null,null,null,8,8,10,10,8,null,null,8,8,10,9,9,null,null,null,{"$f":"SUM(B19:AF19)","v":148}]
["Лузенинова Александра",null,null,8,8,8,7,8,null,null,null,8,9,null,8,null,null,7,6,9,null,null,null,null,null,null,null,null,null,null,null,null,86]
["Агаева Лилия",null,null,8,8,8,8,8,null,null,null,8,10,8,8,null,null,8,8,8,9,null,null,null,8,7,null,7,8,null,null,null,137]
["Носкова Кристина",null,null,null,8,8,null,8,null,null,null,8,9,9,8,null,null,null,8,9,6,8,null,null,6,8,10,5,8,null,null,null,126]
["Сотченко Алексей",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,8,8,null,null,null,null,24]
["Максимов Дмитрий",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,5]
["Официанты 2/2"]
["Кудрина Аня",12,null,null,null,12,12,null,null,null,null,null,11,null,12,12,null,12,null,null,13,12,12,null,null,null,11,null,12,null,null,null,{"$f":"SUM(B26:AF26)","v":143}]
[null,7,null,null,null,7,7,null,null,null,null,null,7,null,7,7,null,7,null,null,7,7,7,null,null,null,7,null,7,null,null,null,84]
["Ветошкина Даша",14,null,null,null,11,null,13,13,12,null,null,null,null,12,null,null,null,null,12,null,null,12,null,null,null,12,null,null,12,null,null,123]
[null,7,null,null,null,7,null,7,7,7,null,null,null,null,7,null,null,null,null,7,null,null,7,null,null,null,7,null,null,7,null,null,70]
["Голубинов Дмитрий",12,null,12,null,null,null,13,13,12,12,12,null,null,null,null,null,null,12,null,null,null,null,null,12,12,null,null,null,null,null,null,122]
[null,7,null,7,null,null,null,7,7,7,7,7,null,null,null,null,null,null,7,null,null,null,null,null,7,7,null,null,null,null,null,null,70]
["Неволин Илья",null,null,12,12,null,null,10,13,null,null,null,11,12,null,null,null,12,null,null,null,11,12,null,null,null,null,10,null,null,null,null,115]
[null,null,null,7,7,null,null,7,7,null,null,null,7,7,null,null,null,7,null,null,null,7,7,null,null,null,null,7,null,null,null,null,70]
["Савинов Александр",null,null,null,null,null,null,15,13,null,null,12,null,null,12,12,null,null,12,null,null,11,12,null,null,14,null,null,12,12,null,null,137]
[null,null,null,null,null,null,null,7,7,null,null,7,null,null,7,7,null,null,7,null,null,7,7,null,null,7,null,null,7,7,null,null,77]
["Балыбердин Александр",14,null,null,null,null,11,12,13,null,null,null,12,12,null,12,null,null,null,null,12,12,null,null,null,null,null,12,12,12,null,null,146]
[null,7,null,null,null,null,7,7,7,null,null,null,7,7,null,7,null,null,null,null,7,7,null,null,null,null,null,7,7,7,null,null,84]
["Сотченко Алексей",null,null,null,12,null,null,17,13,null,12,null,null,null,12,null,null,null,null,11,null,null,null,null,12,null,null,null,12,3,null,null,104]
[null,null,null,null,7,null,null,7,7,null,7,null,null,null,7,null,null,null,null,7,null,null,null,null,7,null,null,null,7,7,null,null,63]
["Петрякова Оксана",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,14]
["Звукорежисеры"]
["Тихонов Сергей",13,null,null,null,null,13,12,12,12,null,12,12,15,12,12,null,null,12,17,15,12,12,null,null,null,16,15,12,12,null,null,{"$f":"SUM(B43:AF43)","v":248}]
[null,7,null,null,null,null,7,7,7,7,null,7,7,7,7,7,null,null,7,7,7,7,7,null,null,null,7,7,7,7,null,null,133]
["Цепилов Василий",null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["Мальхамов Владимир",12,null,12,12,null,null,12,12,null,12,null,null,null,12,12,null,null,null,null,null,12,12,null,12,12,null,null,12,12,null,null,168]
[null,7,null,7,7,null,null,7,7,null,7,null,null,null,7,7,null,null,null,null,null,7,7,null,7,7,null,null,7,7,null,null,98]
["Уборщицы"]
["Николаева Людмила",null,null,17,null,null,17,null,null,12,null,null,19,null,null,12,null,null,17,null,null,17,null,null,17,null,null,17,null,null,null,null,{"$f":"SUM(B50:AF50)","v":145}]
[null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,63]
["Солдатова Наталья",13,null,null,17,null,null,17,null,null,12,null,null,17,null,null,null,null,null,17,null,null,12,null,null,17,null,null,17,null,null,17,156]
[null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,70]
["Круглова Елена",null,null,null,null,17,null,null,12,null,null,17,null,null,17,null,null,19,null,null,17,null,null,null,null,null,17,null,null,12,null,null,128]
[null,null,null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,null,7,null,null,7,null,null,56]
["Стажеры",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,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,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,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,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,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,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,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,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,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,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,0]
["Мойщицы"]
["Клининг",12,null,17,17,17,17,17,12,12,12,17,17,9,17,12,null,17,17,17,17,17,12,null,17,17,17,17,17,12,null,17,{"$f":"SUM(B68:AF68)","v":416}]
[null,7,null,7,7,7,7,7,7,7,7,7,7,7,7,7,null,7,7,7,7,7,7,null,7,7,7,7,7,7,null,7,{"$f":"SUM(B69:AF69)","v":189}]
["Гардероб"]
["Перминов Владимир",12,null,null,17,null,null,17,null,null,12,null,null,17,null,null,null,null,null,17,null,null,12,null,null,17,null,null,17,null,null,17,{"$f":"SUM(B71:AF71)","v":155}]
[null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,70]
["Родина Мария",null,null,17,null,null,17,null,null,12,null,null,17,null,null,12,null,null,17,null,null,17,null,null,17,null,null,17,null,null,null,null,143]
[null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,63]
["Круглова Татьяна",null,null,null,null,17,null,null,12,null,null,17,null,null,17,null,null,19,null,null,17,null,null,null,null,null,17,null,null,12,null,null,128]
[null,null,null,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,7,null,null,null,null,null,7,null,null,7,null,null,56]

{"sheet":"Апрель","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,10,1,10],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[2,10,3,10],[2,1,3,1],[2,3,3,3],[2,5,3,5],[2,7,3,7],[2,9,3,9]]}
["2014-04-11",null,"2014-04-12",null,"2014-04-13",null,"2014-04-14",null,"2014-04-15",null,"Итого ","22:00:00"]
["Пятница",null,"Суббота",null,"Воскресенье",null,"Понедельник",null,"Вторник",null,null,"00:00:00"]
["00:00:00",{"$f":"IF((A3<>\"\")*(A4<>\"\"),MOD(A4-A3,1),0)","v":0.20833333333333334},"17:00:00",{"$f":"IF((C3<>\"\")*(C4<>\"\"),MOD(C4-C3,1),0)","v":0.5},"17:00:00",{"$f":"IF((E3<>\"\")*(E4<>\"\"),MOD(E4-E3,1),0)","v":0.25},"17:42:00",{"$f":"IF((G3<>\"\")*(G4<>\"\"),MOD(G4-G3,1),0)","v":0.47083333333333344},"17:00:00",{"$f":"IF((I3<>\"\")*(I4<>\"\"),MOD(I4-I3,1),0)","v":0.5},{"$f":"SUMIF($A$2:$J$2,\"=\",A3:J3)","v":1.9291666666666667}]
["05:00:00",null,"05:00:00",null,"23:00:00",null,"05:00:00",null,"05:00:00"]
[null,{"$f":"IF((A3<>\"\")*(A4<>\"\"),MOD(A4-A3,1)-MIN(MAX(MIN(MAX(--\"6:00\",A3+MOD(A4-A3,1)),--\"22:00\")-MAX(MIN(--\"22:00\",A3),--\"6:00\")+MIN(MAX(1+\"6:00\",A3+MOD(A4-A3,1)),1+\"22:00\")-MAX(MIN(1+\"22:00\",A3),1+\"6:00\"),0),MOD(A4-A3,1)),0)","v":"05:00:00"},null,{"$f":"IF((C3<>\"\")*(C4<>\"\"),MOD(C4-C3,1)-MIN(MAX(MIN(MAX(--\"6:00\",C3+MOD(C4-C3,1)),--\"22:00\")-MAX(MIN(--\"22:00\",C3),--\"6:00\")+MIN(MAX(1+\"6:00\",C3+MOD(C4-C3,1)),1+\"22:00\")-MAX(MIN(1+\"22:00\",C3),1+\"6:00\"),0),MOD(C4-C3,1)),0)","v":"07:00:00"},null,{"$f":"IF((E3<>\"\")*(E4<>\"\"),MOD(E4-E3,1)-MIN(MAX(MIN(MAX(--\"6:00\",E3+MOD(E4-E3,1)),--\"22:00\")-MAX(MIN(--\"22:00\",E3),--\"6:00\")+MIN(MAX(1+\"6:00\",E3+MOD(E4-E3,1)),1+\"22:00\")-MAX(MIN(1+\"22:00\",E3),1+\"6:00\"),0),MOD(E4-E3,1)),0)","v":"01:00:00"},null,{"$f":"IF((G3<>\"\")*(G4<>\"\"),MOD(G4-G3,1)-MIN(MAX(MIN(MAX(--\"6:00\",G3+MOD(G4-G3,1)),--\"22:00\")-MAX(MIN(--\"22:00\",G3),--\"6:00\")+MIN(MAX(1+\"6:00\",G3+MOD(G4-G3,1)),1+\"22:00\")-MAX(MIN(1+\"22:00\",G3),1+\"6:00\"),0),MOD(G4-G3,1)),0)","v":"07:00:00"},null,{"$f":"IF((I3<>\"\")*(I4<>\"\"),MOD(I4-I3,1)-MIN(MAX(MIN(MAX(--\"6:00\",I3+MOD(I4-I3,1)),--\"22:00\")-MAX(MIN(--\"22:00\",I3),--\"6:00\")+MIN(MAX(1+\"6:00\",I3+MOD(I4-I3,1)),1+\"22:00\")-MAX(MIN(1+\"22:00\",I3),1+\"6:00\"),0),MOD(I4-I3,1)),0)","v":"07:00:00"},{"$f":"SUMIF($A$2:$J$2,\"=\",A5:J5)","v":1.1250000000000004}]