{"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":"SUM(IF(RIGHTB(B9)=\"%\",TEXT(INDEX(C$9:M9,MATCH(LEFTB(B9,SEARCH(\",\",B9)-1),B$9:B9,),),\"0;0;12\")*C9:M9%,C9:M9))","v":34},34,"час"]
[null,"ваня,%",50,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B10)=\"%\",TEXT(INDEX(C$9:M10,MATCH(LEFTB(B10,SEARCH(\",\",B10)-1),B$9:B10,),),\"0;0;12\")*C10:M10%,C10:M10))","v":6},6,"час"]
[null,"ваня,%",100,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B11)=\"%\",TEXT(INDEX(C$9:M11,MATCH(LEFTB(B11,SEARCH(\",\",B11)-1),B$9:B11,),),\"0;0;12\")*C11:M11%,C11:M11))","v":12},12,"час"]
[null,"кузя",null,null,null,12,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B12)=\"%\",TEXT(INDEX(C$9:M12,MATCH(LEFTB(B12,SEARCH(\",\",B12)-1),B$9:B12,),),\"0;0;12\")*C12:M12%,C12:M12))","v":12},12,"час"]
[null,"кузя,%",null,null,100,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B13)=\"%\",TEXT(INDEX(C$9:M13,MATCH(LEFTB(B13,SEARCH(\",\",B13)-1),B$9:B13,),),\"0;0;12\")*C13:M13%,C13:M13))","v":12},12,"час"]
[null,"петя",null,null,12,null,9,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B14)=\"%\",TEXT(INDEX(C$9:M14,MATCH(LEFTB(B14,SEARCH(\",\",B14)-1),B$9:B14,),),\"0;0;12\")*C14:M14%,C14:M14))","v":21},21,"час"]
[null,"петя,%",null,null,50,null,null,null,null,null,null,null,0,{"$f":"SUM(IF(RIGHTB(B15)=\"%\",TEXT(INDEX(C$9:M15,MATCH(LEFTB(B15,SEARCH(\",\",B15)-1),B$9:B15,),),\"0;0;12\")*C15:M15%,C15:M15))","v":6},6,"час"]
[null,"петя,%",null,null,50,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B16)=\"%\",TEXT(INDEX(C$9:M16,MATCH(LEFTB(B16,SEARCH(\",\",B16)-1),B$9:B16,),),\"0;0;12\")*C16:M16%,C16:M16))","v":6},6,"час"]
[null,"петя,%",null,null,null,null,50,100,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B17)=\"%\",TEXT(INDEX(C$9:M17,MATCH(LEFTB(B17,SEARCH(\",\",B17)-1),B$9:B17,),),\"0;0;12\")*C17:M17%,C17:M17))","v":16.5},16.5,"час"]
[null,"петя",null,null,null,12,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B18)=\"%\",TEXT(INDEX(C$9:M18,MATCH(LEFTB(B18,SEARCH(\",\",B18)-1),B$9:B18,),),\"0;0;12\")*C18:M18%,C18:M18))","v":12},12,"час"]
[null,"петя,%",null,null,null,25,50,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B19)=\"%\",TEXT(INDEX(C$9:M19,MATCH(LEFTB(B19,SEARCH(\",\",B19)-1),B$9:B19,),),\"0;0;12\")*C19:M19%,C19:M19))","v":7.5},7.5,"час"]
[null,"сеня",null,null,null,5,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B20)=\"%\",TEXT(INDEX(C$9:M20,MATCH(LEFTB(B20,SEARCH(\",\",B20)-1),B$9:B20,),),\"0;0;12\")*C20:M20%,C20:M20))","v":5},5,"час"]
[null,"сеня,%",100,50,25,50,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B21)=\"%\",TEXT(INDEX(C$9:M21,MATCH(LEFTB(B21,SEARCH(\",\",B21)-1),B$9:B21,),),\"0;0;12\")*C21:M21%,C21:M21))","v":23.5},23.5,"час"]
[null,"сеня,%",null,null,null,50,null,null,null,null,null,null,null,{"$f":"SUM(IF(RIGHTB(B22)=\"%\",TEXT(INDEX(C$9:M22,MATCH(LEFTB(B22,SEARCH(\",\",B22)-1),B$9:B22,),),\"0;0;12\")*C22:M22%,C22:M22))","v":2.5},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":[]}