{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Модель суммы вознаграждения",null,null,"\nМир MS Excel Расчет вознаграждения при нескольких условиях ",null,null,null,"2022-09-06","83 просмотра"]
["Номер маршрута","Уникальные номера маршрута","Дата открытия вакансии","Дата закрытия вакансии","Месяц закрытия вакансии","Сколько повторов (по критерию уник.  номеров)","Номер последней строки (>=3)","Сумма вознаграждения"]
["ЕК000111",{"$f":"listUnique($A$3:$A$9)","v":"ЕК000111"},"2022-04-01","2022-05-10","май",{"$f":"COUNTIF($A$3:$A$9,B3)","v":3},{"$f":"MAX(IF($A$3:$A$9=B3,ROW($A$3:$A$9)))","v":9},{"$f":"IF(F3=1,200,IF(AND(F3=2,ABS(C3-D3)>30),200,IF(AND(F3=2,ABS(C3-D3)<30),100,IF(F3>=3,IF(ABS(OFFSET($A$3,G3-3,2)-OFFSET($A$3,G3-3,3))>30,200,100)))))","v":200}]
["ЕК000112",{"$f":"listUnique($A$3:$A$9)","v":"ЕК000112"},"2022-05-16","2022-06-30","июнь",{"$f":"COUNTIF($A$3:$A$9,B4)","v":1},{"$f":"MAX(IF($A$3:$A$9=B4,ROW($A$3:$A$9)))","v":4},{"$f":"IF(F4=1,200,IF(AND(F4=2,ABS(C4-D4)>30),200,IF(AND(F4=2,ABS(C4-D4)<30),100,IF(F4>=3,IF(ABS(OFFSET($A$3,G4-3,2)-OFFSET($A$3,G4-3,3))>30,200,100)))))","v":200}]
["ЕК000111",{"$f":"listUnique($A$3:$A$9)","v":"ЕК000113"},"2022-06-16","2022-06-30","июнь",{"$f":"COUNTIF($A$3:$A$9,B5)","v":2},{"$f":"MAX(IF($A$3:$A$9=B5,ROW($A$3:$A$9)))","v":7},100]
["ЕК000113","ЕК000114","2022-05-25","2022-07-03","июль",{"$f":"COUNTIF($A$3:$A$9,B6)","v":1},{"$f":"MAX(IF($A$3:$A$9=B6,ROW($A$3:$A$9)))","v":8},200]
["ЕК000113","","2022-08-01","2022-08-15","август"]
["ЕК000114","","2022-08-28","2022-09-05","сентябрь"]
["ЕК000111","","2022-08-16","2022-09-30","сентябрь"]