{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1с","агент"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["название клиента","дата транзакции","сумма транзакции","сумма агента","разница","найденное имя"]
["pupkin Fil","2015-10-27",150,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A2,агент!$A$2:$A$5,0),агент!$A$2:$C$5,2,0)<>B2,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A2,агент!$A$2:$A$5,0),агент!$A$2:$C$5,3,0))","v":150},{"$f":"IFERROR(C2-D2,\"\")","v":0},{"$f":"FuzzyVLOOKUP(A2,агент!$A$2:$A$5,0)","v":"Fil pupkin "}]
["Dip Fak Ry","2015-10-28",250,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A3,агент!$A$2:$A$5,0),агент!$A$2:$C$5,2,0)<>B3,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A3,агент!$A$2:$A$5,0),агент!$A$2:$C$5,3,0))","v":"дата не совпадает"},{"$f":"IFERROR(C3-D3,\"\")","v":""},{"$f":"FuzzyVLOOKUP(A3,агент!$A$2:$A$5,0)","v":"Ry Fak Dip "}]
["San Kan Ti","2015-10-29",350,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A4,агент!$A$2:$A$5,0),агент!$A$2:$C$5,2,0)<>B4,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A4,агент!$A$2:$A$5,0),агент!$A$2:$C$5,3,0))","v":300},50,{"$f":"FuzzyVLOOKUP(A4,агент!$A$2:$A$5,0)","v":"Ti San Kan"}]
["Kut Manuta","2015-10-30",450,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A5,агент!$A$2:$A$5,0),агент!$A$2:$C$5,2,0)<>B5,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A5,агент!$A$2:$A$5,0),агент!$A$2:$C$5,3,0))","v":"дата не совпадает"},"",{"$f":"FuzzyVLOOKUP(A5,агент!$A$2:$A$5,0)","v":"Kut M"}]

{"sheet":"агент","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["название клиента","дата транзакции","сумма транзакции","сумма 1C","разница","найденное имя"]
["Fil pupkin ","2015-10-27",150,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A2,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,2,0)<>B2,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A2,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,3,0))","v":150},{"$f":"IFERROR(C2-D2,\"\")","v":0},{"$f":"FuzzyVLOOKUP(A2,'1с'!$A$2:$A$5,0)","v":"pupkin Fil"}]
["Ry Fak Dip ","2015-10-27",250,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A3,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,2,0)<>B3,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A3,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,3,0))","v":"дата не совпадает"},{"$f":"IFERROR(C3-D3,\"\")","v":""},{"$f":"FuzzyVLOOKUP(A3,'1с'!$A$2:$A$5,0)","v":"Dip Fak Ry"}]
["Ti San Kan","2015-10-29",300,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A4,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,2,0)<>B4,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A4,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,3,0))","v":350},-50,{"$f":"FuzzyVLOOKUP(A4,'1с'!$A$2:$A$5,0)","v":"San Kan Ti"}]
["Kut M","2015-10-27",450,{"$f":"IF(VLOOKUP(FuzzyVLOOKUP(A5,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,2,0)<>B5,\"дата не совпадает\",VLOOKUP(FuzzyVLOOKUP(A5,'1с'!$A$2:$A$5,0),'1с'!$A$2:$C$5,3,0))","v":"дата не совпадает"},"",{"$f":"FuzzyVLOOKUP(A5,'1с'!$A$2:$A$5,0)","v":"Kut Manuta"}]