{"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":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,0,27,0],[24,2,27,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:I28)=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:H25)=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:H26)=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(H25:H27)=100,1,0),1)","v":{"$error":"#REF!"}}]
["Исполнительный блок","Ведущий специалист","Иванов Иван Иванович",79,31.75,null,"01.04.2017","30.04.2017",{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(H26:H28)=100,1,0),1)","v":{"$error":"#REF!"}}]
[null,null,null,null,23.5,{"$f":"(E26+SUM(D25:E25)*150/610)","v":50.733606557377044},null,{"$f":"$F26/SUM(F26:F28)*100","v":37.790395945904685},{"$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":36.311475409836063},null,{"$f":"$F27/SUM(F26:F28)*100","v":27.047653936563176},{"$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":47.204918032786885},null,{"$f":"$F28/SUM(F26:F28)*100","v":35.161950117532129},{"$f":"IF(#REF!=\"ВЭС 610\",IF(SUM(#REF!)=100,1,0),1)","v":{"$error":"#REF!"}}]
[]
[]
["Ответственный сотрудник"]
[null,null,"подпись"]

{"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!"}}]