{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":137,"n_cols":8,"rows_kept":137,"cut":false,"hidden":false,"merged":[[136,1,136,2],[136,3,136,4],[135,1,135,2],[135,3,135,4],[134,1,134,2],[134,3,134,4],[133,1,133,2],[133,3,133,4],[132,1,132,2],[132,3,132,4],[106,2,106,3],[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4]]}
["Контрагент","Действие","Дата действия","Дата следующего действия","Ответ клиента","Следующее действие",null,"Нужно вписать в ячейку примечание если выбраны: \"Я подумаю, и  Дорого\""]
[]
[]
[]
[]
[null,null,null,null,"Дорого"]
[]
[null,null,null,null,"я_подумаю"]
[null,null,null,null,"я подумаю"]
[]
[]
[]
[]
[null,null,null,null,"Я_подумаю"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Дата подписания","№ договора",null,1]
[null,{"$f":"IFERROR(VLOOKUP(C108,$I$3:$R$100,MATCH($C$107,$I$1:$R$1,0),FALSE),\" \")","v":" "},{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E108)/($L$3:$L$99=MAX(IF($B$3:$B$99=E108,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E108)/($L$3:$L$99=MAX(IF($B$3:$B$99=E108,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E109)/($L$3:$L$99=MAX(IF($B$3:$B$99=E109,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E109)/($L$3:$L$99=MAX(IF($B$3:$B$99=E109,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E110)/($L$3:$L$99=MAX(IF($B$3:$B$99=E110,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E110)/($L$3:$L$99=MAX(IF($B$3:$B$99=E110,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E111)/($L$3:$L$99=MAX(IF($B$3:$B$99=E111,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E111)/($L$3:$L$99=MAX(IF($B$3:$B$99=E111,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E112)/($L$3:$L$99=MAX(IF($B$3:$B$99=E112,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E112)/($L$3:$L$99=MAX(IF($B$3:$B$99=E112,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E113)/($L$3:$L$99=MAX(IF($B$3:$B$99=E113,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E113)/($L$3:$L$99=MAX(IF($B$3:$B$99=E113,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E114)/($L$3:$L$99=MAX(IF($B$3:$B$99=E114,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E114)/($L$3:$L$99=MAX(IF($B$3:$B$99=E114,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E115)/($L$3:$L$99=MAX(IF($B$3:$B$99=E115,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E115)/($L$3:$L$99=MAX(IF($B$3:$B$99=E115,$L$3:$L$99))))))","v":" "}]
[null," ",{"$f":"IF(INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E116)/($L$3:$L$99=MAX(IF($B$3:$B$99=E116,$L$3:$L$99)))))=0,\" \",INDEX($I$3:$I$99,MATCH(1,($B$3:$B$99=E116)/($L$3:$L$99=MAX(IF($B$3:$B$99=E116,$L$3:$L$99))))))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ВИД ПРАЙСА",null,"СУММА ДОГОВОРА"]
[null,"Договора по 7,5%",null,{"$f":"SUMIF($K$3:$K$99,1,$J$3:$J$99)","v":0}]
[null,"Договора по 5%",null,{"$f":"SUMIF($K$3:$K$99,2,$J$3:$J$99)","v":0}]
[null,"Договора по 2,5%",null,{"$f":"SUMIF($K$3:$K$99,3,$J$3:$J$99)","v":0}]
[null,"ИТОГО",null,{"$f":"SUM(D134:D136)","v":0}]

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