{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["AGR","acquire","RRK","Дата поступления","сумма","валюта","карта","дата операции","Client","причина обращения","результат","вид операции","сроки","КОЛИЧЕСТВО",null,"ИСКОМОЕ ЗНАЧЕНИЕ"]
["AGR 121","RUS",1234567,"2019-09-01",5000,"RUR","5222*****3444","2019-07-22","Client 1","запрос","В работе","Операция 1","2019-09-08",null,null,{"$f":"SUM(IF(FREQUENCY(IF(ВсеСтроки A:A<>\"\",IF(ВсеСтроки D:D>=DATE(YEAR(TODAY()),MONTH(TODAY()),1),IF(ВсеСтроки K:K=K2,IF(ВсеСтроки I:I=I2,MATCH(ВсеСтроки A:A,A:A,0))))),ROW(ВсеСтроки)-ROW(K2)+1),1))","v":4}]
["AGR 121","RUS",12312312,"2019-09-01",7000,"RUR","5222*****3444","2019-07-23","Client 1","запрос","В работе","Операция 2","2019-09-10",null,null,{"$f":"SUM(FREQUENCY(IF((ВсеСтроки I:I=I2)*(ВсеСтроки A:A<>\"\")*(ВсеСтроки D:D>=EOMONTH(TODAY(),-1)+1)*(ВсеСтроки K:K=K2),MATCH(ВсеСтроки A:A,A:A,0)),ROW(ВсеСтроки)-ROW(K2)+1))","v":7}]
["AGR 121","RUS",23423423,"2019-09-01",200,"USD","5222*****3444","2019-07-24","Client 1","запрос","В работе","Операция 3","2019-09-13"]
["AGR 121","RUS",435345,"2019-09-02",300,"USD","5222*****3444","2019-07-25","Client 1","запрос","В работе","Операция 4","2019-09-14"]
["AGR 511","RUS",456456,"2019-09-03",300,"USD","2200*****5525","2019-02-01","Client 5","запрос","В работе","Операция 5","2019-09-15"]
["AGR 511","RUS",234234,"2019-09-05",300,"USD","2200*****5526","2019-02-02","Client 5","запрос","В работе","Операция 6","2019-09-16"]
["AGR 511","RUS",657567567,"2019-09-06",300,"RUR","2200*****5527","2019-02-03","Client 5","запрос","В работе","Операция 7","2019-09-17"]
["AGR 5131","RUS",8978978,"2019-09-04",300,"RUR","2200*****5528","2019-02-04","Client 5","запрос","В работе","Операция 8","2019-09-18"]
["AGR 511","RUS",890543,"2019-08-30",300,"RUR","2200*****5529","2019-02-05","Client 5","запрос","В работе","Операция 9","2019-09-11"]
["AGR 124","RUS",890543,"2019-09-05",300,"RUR","2200*****5529","2019-02-05","Client 10","запрос","закрыт","Операция 10","2019-09-19"]
["AGR 124","RUS",657567567,"2019-09-09",300,"RUR","2200*****5527","2019-02-03","Client 10","запрос","закрыт","Операция 11","2019-09-17"]
["AGR 124","RUS",1273737373,"2019-09-05",70000,"RUR","22*******3322","2015-07-06","Client 10","запрос","закрыт","Операция 12","2019-09-11"]
["AGR 124","RUS",1273737373,"2019-07-22",70000,"RUR","22*******3322","2015-07-06","Client 10","запрос","закрыт","Операция 13","2019-09-11"]
["AGR 124","RUS",435345,"2019-09-06",300,"USD","2200*****5529","2015-07-06","Client 10","запрос","закрыт","Операция 14","2019-09-16"]
["AGR 124","RUS",1234567,"2019-09-10",5000,"RUR","5222*****3444","2019-07-22","Client 10","запрос","закрыт","Операция 15","2019-09-08"]
["AGR 125","RUS",1234567,"2019-09-10",5000,"RUR","5222*****3444","2019-07-22","Client 1","запрос","закрыт","Операция 15","2019-09-08"]
["AGR 126","RUS",1234567,"2019-09-10",5000,"RUR","5222*****3444","2019-07-22","Client 1","запрос","В работе","Операция 15","2019-09-08"]
["AGR 126123","RUS",1234567,"2019-09-10",5000,"RUR","5222*****3444","2019-07-22","Client 1","запрос","В работе","Операция 15","2019-09-08"]
["AGR 12226123","RUS",1234567,"2019-09-10",5000,"RUR","5222*****3444","2019-07-22","Client 1","запрос","В работе","Операция 15","2019-09-08"]

{"sheet":"Лист2","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"SUM(IF(FREQUENCY(IF(ВсеСтроки Лист1!A:A<>\"\",IF(ВсеСтроки Лист1!D:D>=DATE(YEAR(TODAY()),MONTH(TODAY()),1),IF(ВсеСтроки Лист1!K:K=Лист1!K2,IF(ВсеСтроки Лист1!I:I=Лист1!I2,MATCH(ВсеСтроки Лист1!A:A,Лист1!A:A,0))))),ROW(ВсеСтроки)-ROW(Лист1!K2)+1),1))","v":{"$error":"#VALUE!"}}]