{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Рез_30.04.2022 17-20-46","как должнобыть","Пример"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Рез_30.04.2022 17-20-46","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Расхождения","Нет в списке2","Нет в списке1"]
[510000001315,"Нет в списке2"]
[580000069030,null,"Нет в списке1"]
[580000070841,null,"Нет в списке1"]
[510000008677,null,"Нет в списке1"]

{"sheet":"как должнобыть","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Расхождения",null,"Нет в списке2","Нет в списке1"]
[510000001315,"Холодильник \"Стинол\"(спец отдел)","Нет в списке2"]
[580000069030,"ампа настольная",null,"Нет в списке1"]
[580000070841,"ИБП ВК 500ЕI",null,"Нет в списке1"]
[510000008677,"ИБП ВК 500ЕI",null,"Нет в списке1"]

{"sheet":"Пример","index":2,"n_rows":75,"n_cols":17,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Номенклатура Список 1","наименование","Нет в Списке 2",null,"Номенклатура Список 2","наименование","Нет в Списке 1"]
[510000008677,"Стол рабочий",{"$f":"--ISNA(VLOOKUP(A2,$E$2:$E$66,1,0))","v":0},null,580000002786,"ампа настольная",{"$f":"--ISNA(VLOOKUP(E2,$A$2:$A$66,1,0))","v":1},null,null,null,{"$f":"IF(I2<>\"\",A2=I2,\"\")","v":""},{"$f":"IF(J2<>\"\",C2=J2,\"\")","v":""},null,null,null,{"$f":"IF(N2<>\"\",#REF!=N2,\"\")","v":""},{"$f":"IF(O2<>\"\",G2=O2,\"\")","v":""}]
[510000009236,"Стол рабочий",{"$f":"--ISNA(VLOOKUP(A3,$E$2:$E$66,1,0))","v":0},null,580000069030,"ИБП ВК 500ЕI",1,null,null,null,"","",null,null,null,{"$f":"IF(N3<>\"\",#REF!=N3,\"\")","v":""},{"$f":"IF(O3<>\"\",G3=O3,\"\")","v":""}]
[510000009237,"Стол рабочий",0,null,580000070841,"ИБП ВК 500ЕI",1,null,null,null,"","",null,null,null,{"$f":"IF(N4<>\"\",#REF!=N4,\"\")","v":""},""]
[510000009238,"Стол рабочий",0,null,510000008677,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N5<>\"\",#REF!=N5,\"\")","v":""},""]
[510000009239,"Стол рабочий",0,null,510000009236,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N6<>\"\",#REF!=N6,\"\")","v":""},""]
[510000009240,"Стол рабочий",0,null,510000009237,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N7<>\"\",#REF!=N7,\"\")","v":""},""]
[510000009242,"Стол рабочий",0,null,510000009238,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N8<>\"\",#REF!=N8,\"\")","v":""},""]
[510000009243,"Стол рабочий",0,null,510000009239,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N9<>\"\",#REF!=N9,\"\")","v":""},""]
[510000009245,"Стол рабочий",0,null,510000009240,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N10<>\"\",#REF!=N10,\"\")","v":""},""]
[510000009246,"Стол рабочий",0,null,510000009242,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N11<>\"\",#REF!=N11,\"\")","v":""},""]
[510000009248,"Стол рабочий",0,null,510000009243,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N12<>\"\",#REF!=N12,\"\")","v":""},""]
[510000009250,"Стол рабочий",0,null,510000009245,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N13<>\"\",#REF!=N13,\"\")","v":""},""]
[510000009251,"Стол рабочий",0,null,510000009246,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N14<>\"\",#REF!=N14,\"\")","v":""},""]
[580000001957,"ФИЛЬТР СЕТЕВОЙ BURO",0,null,510000009248,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N15<>\"\",#REF!=N15,\"\")","v":""},""]
[580000069029,"фильтр сетевой АРС PS-RS",0,null,510000009250,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N16<>\"\",#REF!=N16,\"\")","v":""},""]
[580000003322,"ХОЛОД-К 1-КАМЕРНЫЙ СВИЯГА RS 411 160/18Л",0,null,510000009251,"Стол рабочий",0,null,null,null,"","",null,null,null,{"$f":"IF(N17<>\"\",#REF!=N17,\"\")","v":""},""]
[510000001315,"Холодильник \"Стинол\"(спец отдел)",1,null,580000001957,"ФИЛЬТР СЕТЕВОЙ BURO",0,null,null,null,"","",null,null,null,{"$f":"IF(N18<>\"\",#REF!=N18,\"\")","v":""},""]
[null,null,1,null,580000069029,"фильтр сетевой АРС PS-RS",0,null,null,null,"","",null,null,null,{"$f":"IF(N19<>\"\",#REF!=N19,\"\")","v":""},""]
[null,null,1,null,580000003322,"ХОЛОД-К 1-КАМЕРНЫЙ СВИЯГА RS 411 160/18Л",0,null,null,null,"","",null,null,null,{"$f":"IF(N20<>\"\",E2=N20,\"\")","v":""},""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,{"$f":"--ISNA(VLOOKUP(A32,$E$2:$E$66,1,0))","v":1},null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,{"$f":"IF(I34<>\"\",A34=I34,\"\")","v":""},{"$f":"IF(J34<>\"\",C34=J34,\"\")","v":""},null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,{"$f":"IF(N39<>\"\",E39=N39,\"\")","v":""},""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,{"$f":"--ISNA(VLOOKUP(E61,$A$2:$A$66,1,0))","v":1},null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,1,null,null,null,"","",null,null,null,"",""]
[null,null,1,null,null,null,{"$f":"--ISNA(VLOOKUP(E66,$A$2:$A$66,1,0))","v":1},null,null,null,{"$f":"IF(I66<>\"\",A66=I66,\"\")","v":""},{"$f":"IF(J66<>\"\",C66=J66,\"\")","v":""},null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]
[null,null,1,null,null,null,null,null,null,null,"",""]