{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Таймшит_образец","Лист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":"Таймшит_образец","index":0,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[40,0,43,0],[40,1,43,1],[40,2,43,2],[44,0,47,0],[44,1,47,1],[44,2,47,2],[36,0,39,0],[36,1,39,1],[36,2,39,2],[24,0,27,0],[24,1,27,1],[24,2,27,2],[32,0,35,0],[32,1,35,1],[32,2,35,2],[28,0,31,0],[28,1,31,1],[28,2,31,2],[5,3,5,7],[0,0,3,0],[0,1,3,1],[0,2,3,2],[8,0,8,2],[16,0,19,0],[16,2,19,2],[20,0,23,0],[20,2,23,2]]}
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H2:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E2+SUM(D1:E1)*150/610)","v":0},null,{"$f":"$F2/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H3:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E3+SUM(D1:E1)*200/610)","v":0},null,{"$f":"$F3/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H4:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E4+SUM(D1:E1)*260/610)","v":0},null,{"$f":"$F4/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(MIN(I17:I24)=0,\"ОШИБКА\",\"ОК\")","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,"кадры","кадры","ПЭО",null,"ПЭО"]
[]
["Подразделение","Должность","ФИО","Отработано всего часов в месяц (без учета неявок)","Кол-во часов  в командировке","Расчет весовой процентной ставки","Начальная дата","Конечная дата","Проверка"]
[null,null,null,null,null,null,"Код СПП-элемента","Весовая процентная ставка"]
[1,2,3,8,9,10,11,12,13]
["Исполнительный блок","Ведущий специалист","Иванов Иван Иванович",50,31.75,null,"01.04.2017","30.04.2017",{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H18:H20)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,23.5,{"$f":"(E18+SUM(D17:E17)*150/610)","v":43.602459016393439},null,{"$f":"$F18/SUM(F18:F20)*100","v":41.427514504886872},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H19:H21)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E19+SUM(D17:E17)*200/610)","v":26.803278688524589},null,{"$f":"$F19/SUM(F18:F20)*100","v":25.466298041353529},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H20:H22)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E20+SUM(D17:E17)*260/610)","v":34.844262295081968},null,{"$f":"$F20/SUM(F18:F20)*100","v":33.106187453759588},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H21:H23)=100,1,0),1)","v":{"$error":"#REF!"}}]
["Аппарат советников","Ведущий специалист","Иванов Иван Иванович",79,31.75,null,"01.04.2017","30.04.2017",{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H22:H24)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,23.5,{"$f":"(E22+SUM(D21:E21)*150/610)","v":50.733606557377044},null,{"$f":"$F22/SUM(F22:F24)*100","v":37.790395945904685},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H23:H24)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E23+SUM(D21:E21)*200/610)","v":36.311475409836063},null,{"$f":"$F23/SUM(F22:F24)*100","v":27.047653936563176},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H24:H24)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E24+SUM(D21:E21)*260/610)","v":47.204918032786885},null,{"$f":"$F24/SUM(F22:F24)*100","v":35.161950117532129},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H26:H28)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E26+SUM(D25:E25)*150/610)","v":0},null,{"$f":"$F26/SUM(F26:F28)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H27:H28)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E27+SUM(D25:E25)*200/610)","v":0},null,{"$f":"$F27/SUM(F26:F28)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H28:H28)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E28+SUM(D25:E25)*260/610)","v":0},null,{"$f":"$F28/SUM(F26:F28)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H30:H32)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E30+SUM(D29:E29)*150/610)","v":0},null,{"$f":"$F30/SUM(F30:F32)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H31:H32)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E31+SUM(D29:E29)*200/610)","v":0},null,{"$f":"$F31/SUM(F30:F32)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H32:H32)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E32+SUM(D29:E29)*260/610)","v":0},null,{"$f":"$F32/SUM(F30:F32)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H34:H36)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E34+SUM(D33:E33)*150/610)","v":0},null,{"$f":"$F34/SUM(F34:F36)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H35:H36)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E35+SUM(D33:E33)*200/610)","v":0},null,{"$f":"$F35/SUM(F34:F36)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H36:H36)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E36+SUM(D33:E33)*260/610)","v":0},null,{"$f":"$F36/SUM(F34:F36)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H38:H40)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E38+SUM(D37:E37)*150/610)","v":0},null,{"$f":"$F38/SUM(F38:F40)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H39:H40)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E39+SUM(D37:E37)*200/610)","v":0},null,{"$f":"$F39/SUM(F38:F40)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H40:H40)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E40+SUM(D37:E37)*260/610)","v":0},null,{"$f":"$F40/SUM(F38:F40)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H42:H44)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E42+SUM(D41:E41)*150/610)","v":0},null,{"$f":"$F42/SUM(F42:F44)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H43:H44)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E43+SUM(D41:E41)*200/610)","v":0},null,{"$f":"$F43/SUM(F42:F44)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H44:H44)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E44+SUM(D41:E41)*260/610)","v":0},null,{"$f":"$F44/SUM(F42:F44)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H46:H48)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E46+SUM(D45:E45)*150/610)","v":0},null,{"$f":"$F46/SUM(F46:F48)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H47:H48)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E47+SUM(D45:E45)*200/610)","v":0},null,{"$f":"$F47/SUM(F46:F48)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H48:H48)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E48+SUM(D45:E45)*260/610)","v":0},null,{"$f":"$F48/SUM(F46:F48)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Ответственный сотрудник"]

{"sheet":"Лист3","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,3,1],[0,2,3,2]]}
[null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H2:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E2+SUM(D1:E1)*150/610)","v":0},null,{"$f":"$F2/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H3:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E3+SUM(D1:E1)*200/610)","v":0},null,{"$f":"$F3/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H4:H4)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"(E4+SUM(D1:E1)*260/610)","v":0},null,{"$f":"$F4/SUM(F2:F4)*100","v":{"$error":"#DIV/0!"}},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]