{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":"Лист1","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,14,7,14],[6,2,6,13],[6,1,7,1],[29,1,29,9],[28,1,28,9],[27,1,27,9],[7,2,7,13]]}
[]
[]
[]
[]
[]
[]
[null,"ФИО","можно ли данное вычисление сделать макросом (без нажатия на кнопку) и только в данном листе ?",null,null,null,null,null,null,null,null,null,null,null,"должно быть так"]
[null,null,"продолжить формулу для второго и третьего совмещения не получается."]
[null,"ваня",12,null,null,null,12,10,null,null,null,null,null,{"$f":"IF(B9>0,IF(RIGHT(B9,1)=\"%\",C9:M9*C8:M8/100,SUM(C9:M9)),\"\")","v":34},34,"час"]
[null,"ваня,%",50,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10>0,IF(RIGHT(B10,1)=\"%\",C10:M10*C9:M9/100,SUM(C10:M10)),\"\")","v":6},6,"час"]
[null,"ваня,%",100,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B11>0,IF(RIGHT(B11,1)=\"%\",C11:M11*C10:M10/100,SUM(C11:M11)),\"\")","v":50},12,"час"]
[null,"кузя",null,null,null,12,null,null,null,null,null,null,null,{"$f":"IF(B12>0,IF(RIGHT(B12,1)=\"%\",C12:M12*C11:M11/100,SUM(C12:M12)),\"\")","v":12},12,"час"]
[null,"кузя,%",null,null,100,null,null,null,null,null,null,null,null,{"$f":"IF(B13>0,IF(RIGHT(B13,1)=\"%\",C13:M13*C12:M12/100,SUM(C13:M13)),\"\")","v":0},12,"час"]
[null,"петя",null,null,12,null,9,null,null,null,null,null,null,{"$f":"IF(B14>0,IF(RIGHT(B14,1)=\"%\",C14:M14*C13:M13/100,SUM(C14:M14)),\"\")","v":21},21,"час"]
[null,"петя,%",null,null,50,null,null,null,null,null,null,null,0,{"$f":"IF(B15>0,IF(RIGHT(B15,1)=\"%\",C15:M15*C14:M14/100,SUM(C15:M15)),\"\")","v":0},6,"час"]
[null,"петя,%",null,null,50,null,null,null,null,null,null,null,null,{"$f":"IF(B16>0,IF(RIGHT(B16,1)=\"%\",C16:M16*C15:M15/100,SUM(C16:M16)),\"\")","v":0},6,"час"]
[null,"петя,%",null,null,null,null,50,100,null,null,null,null,null,{"$f":"IF(B17>0,IF(RIGHT(B17,1)=\"%\",C17:M17*C16:M16/100,SUM(C17:M17)),\"\")","v":0},16.5,"час"]
[null,"петя",null,null,null,12,null,null,null,null,null,null,null,{"$f":"IF(B18>0,IF(RIGHT(B18,1)=\"%\",C18:M18*C17:M17/100,SUM(C18:M18)),\"\")","v":12},12,"час"]
[null,"петя,%",null,null,null,25,50,null,null,null,null,null,null,{"$f":"IF(B19>0,IF(RIGHT(B19,1)=\"%\",C19:M19*C18:M18/100,SUM(C19:M19)),\"\")","v":0},7.5,"час"]
[null,"сеня",null,null,null,5,null,null,null,null,null,null,null,{"$f":"IF(B20>0,IF(RIGHT(B20,1)=\"%\",C20:M20*C19:M19/100,SUM(C20:M20)),\"\")","v":5},5,"час"]
[null,"сеня,%",100,50,25,50,null,null,null,null,null,null,null,{"$f":"IF(B21>0,IF(RIGHT(B21,1)=\"%\",C21:M21*C20:M20/100,SUM(C21:M21)),\"\")","v":0},23.5,"час"]
[null,"сеня,%",null,null,null,50,null,null,null,null,null,null,null,{"$f":"IF(B22>0,IF(RIGHT(B22,1)=\"%\",C22:M22*C21:M21/100,SUM(C22:M22)),\"\")","v":0},2.5,"час"]
[]
[]
[]
[]
[null,"Обозначения:"]
["1.","от 1 до 12 это один рабочий день в часах по основной профессии."]
["2.","более 12 до 100 это сумма в процентах  отработанной паралельной основной (совмещаемой) професии."]
[2.1,"более 12 до 100 это сумма в процентах  совмещаемой професии (работа выполнялась не паралельно)."]

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