{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Результат","Sales","Articles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"Результат","index":0,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["OneGroup","(Все)"]
[]
[null,null,"Данные"]
["Main","WithIt","Max Rate","%Rate"]
["177287","89180/630/C",1,1,{"$f":"A5=B5","v":false}]
["177287","177287",1,1,{"$f":"A6=B6","v":true}]
["189320/7240","189320/7240",1,1,true]
["19sdp12/9s151","19sdp12/9s151",1,1,true]
["218403/1081","218403/1081",1,1,true]
["232656","232656",2,1,true]
["234959","234959",1,1,true]
["24047/черн.","24047/черн.",2,1,true]
["24047/черн.","ANOUK/",1,0.5,false]
["24047/черн.","GU58098/00",1,0.5,false]
["24047/черн.","2424/000",1,0.5,false]
["2424/000","2424/000",1,1,true]
["2424/000","24047/черн.",1,1,false]
["24253","24253",1,1,true]
["24253","B1169",1,1,false]
["24253","6152636",1,1,false]
["245445","245445",1,1,true]
["254315","254315",3,1,true]
["256110","256110",1,1,true]
["269996/40","269996/40",1,1,true]
["31613/600654","31613/600654",1,1,true]
["406C","406C",1,1,true]
["406C","45365/98223чк",1,1,false]
["406C","440",1,1,false]
["440","406C",1,1,false]
["440","45365/98223чк",1,1,false]
["440","440",1,1,true]
["45365/98223кк","45365/98223кк",1,1,true]
["45365/98223чк","406C",1,1,false]
["45365/98223чк","45365/98223чк",1,1,true]
["45365/98223чк","440",1,1,false]
["460aktb999","460aktb999",1,1,true]
["5/36/90970","5/36/90970",1,1,true]
["50150033/026","50150033/026",1,1,true]
["56/622/999","56/622/999",2,1,true]
["6152636","24253",1,1,false]
["6152636","B1169",1,1,false]
["6152636","6152636",1,1,true]
["6177398/черн.","6177398/черн.",1,1,true]
["6513","6513",1,1,true]
["72GC494","31613/600654",1,1,false]
["72GC494","ANOUK/",1,1,false]
["72GC494","72GC494",1,1,true]
["89180/630/C","89180/630/C",1,1,true]
["89180/630/C","177287",1,1,false]
["95/000","S49WP0018(SO99770)",1,1,false]
["95/000","95/000",1,1,true]
["ANOUK/","ANOUK/",2,1,true]
["ANOUK/","24047/черн.",1,0.5,false]
["ANOUK/","GU58098/00",1,0.5,false]
["ANOUK/","31613/600654",1,0.5,false]
["ANOUK/","72GC494",1,0.5,false]
["B1169","24253",1,1,false]
["B1169","B1169",1,1,true]
["B1169","6152636",1,1,false]
["CH9094","CH9094",1,1,true]
["CSJ-NS-W-04","CSJ-NS-W-04",1,1,true]
["E1532","E1532",1,1,true]
["GU58098/00","24047/черн.",1,1,false]
["GU58098/00","GU58098/00",1,1,true]
["GU58098/00","ANOUK/",1,1,false]
["I36126/коричневый,синий","I36126/коричневый,синий",1,1,true]
["JS17040","JS17040",1,1,true]
["JULIE/02","JULIE/02",2,1,true]
["LF027/","LF027/",1,1,true]
["M2MG021","M2MG021",2,1,{"$f":"A70=B70","v":true}]
["R0000/00W09","R0000/00W09",1,1,true]
["S49WP0018(SO99770)","S49WP0018(SO99770)",1,1,true]
["S49WP0018(SO99770)","95/000",1,1,false]
["SMS17","SMS17",1,1,true]
["С12267","С12267",1,1,true]

{"sheet":"Sales","index":1,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Check","Article","AGroup","Amount"]
[{"$f":"RANDBETWEEN(1,10)","v":3},"M2MG021","топы",3120]
[{"$f":"RANDBETWEEN(1,10)","v":8},"189320/7240","туфли",10410]
[6,"6177398/черн.","туфли",23700]
[1,"M2MG021","топы",3120]
[1,"5/36/90970","сапоги",12870]
[4,"LF027/","пиджаки",7000]
[3,"JULIE/02","сандалии",2700]
[9,"56/622/999","повседневные платья",8190]
[7,254315,"вечерние платья",2070]
[4,"72GC494","туфли",1770]
[4,"19sdp12/9s151","джинсы",4590]
[2,"95/000","вечерние платья",16860]
[3,6152636,"туфли",6240]
[7,"E1532","туфли",3300]
[9,"2424/000","туфли",6960]
[9,"45365/98223кк","ботинки",7380]
[9,254315,"леггинсы",2070]
[7,245445,"мокасины",6180]
[6,"С12267","сапоги",6930]
[5,"CH9094","сапоги",11550]
[2,"S49WP0018(SO99770)","вечерние платья",9810]
[3,"B1169","туфли",11280]
[8,"31613/600654","повседневные платья",5640]
[1,232656,"лонгсливы",2310]
[10,"460aktb999","полусапоги",5310]
[2,"269996/40","кроссовки",7560]
[8,"56/622/999","повседневные платья",8190]
[2,"CSJ-NS-W-04","полусапоги",5300]
[10,"R0000/00W09","подвески и бусы",4620]
[4,"ANOUK/","туфли",34600]
[9,"I36126/коричневый,синий","туфли",27650]
[7,234959,"балетки",5640]
[8,"89180/630/C","сумки",5580]
[6,"45365/98223чк","повседневные платья",7380]
[7,"45365/98223кк","повседневные платья",7380]
[2,"218403/1081","ботильоны",7800]
[4,"SMS17","шарфы",1740]
[2,256110,"поло с коротким рукавом",3960]
[7,24253,"туфли",6780]
[5,"GU58098/00","туфли",7050]
[6,"JS17040","сапоги",11880]
[5,"24047/черн.","туфли",6210]
[1,"24047/черн.","туфли",6210]
[3,232656,"лонгсливы",2310]
[9,"ANOUK/","туфли",33600]
[2,254315,"леггинсы",2070]
[2,"406C","повседневные платья",4170]
[4,"56/622/999","вечерние платья",8190]
[2,"31613/600654","туфли",5640]
[9,440,"повседневные платья",5550]
[4,"JULIE/02","сандалии",2700]
[1,177287,"сумки",24750]
[10,6513,"туфли",9720]
[2,"50150033/026","куртки",5640]

{"sheet":"Articles","index":2,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Article","Count","AGroup","Price"]
["56/622/999",{"$f":"COUNTIF(Sales!B:B,Articles!A2)","v":3},{"$f":"VLOOKUP(A2,Sales!$B:$D,2,0)","v":"повседневные платья"},{"$f":"VLOOKUP(A2,Sales!$B:$D,3,0)","v":8190}]
[254315,{"$f":"COUNTIF(Sales!B:B,Articles!A3)","v":3},{"$f":"VLOOKUP(A3,Sales!$B:$D,2,0)","v":"вечерние платья"},{"$f":"VLOOKUP(A3,Sales!$B:$D,3,0)","v":2070}]
["M2MG021",{"$f":"COUNTIF(Sales!B:B,Articles!A4)","v":2},{"$f":"VLOOKUP(A4,Sales!$B:$D,2,0)","v":"топы"},{"$f":"VLOOKUP(A4,Sales!$B:$D,3,0)","v":3120}]
["JULIE/02",{"$f":"COUNTIF(Sales!B:B,Articles!A5)","v":2},{"$f":"VLOOKUP(A5,Sales!$B:$D,2,0)","v":"сандалии"},{"$f":"VLOOKUP(A5,Sales!$B:$D,3,0)","v":2700}]
["45365/98223кк",{"$f":"COUNTIF(Sales!B:B,Articles!A6)","v":2},{"$f":"VLOOKUP(A6,Sales!$B:$D,2,0)","v":"ботинки"},{"$f":"VLOOKUP(A6,Sales!$B:$D,3,0)","v":7380}]
["31613/600654",{"$f":"COUNTIF(Sales!B:B,Articles!A7)","v":2},{"$f":"VLOOKUP(A7,Sales!$B:$D,2,0)","v":"повседневные платья"},{"$f":"VLOOKUP(A7,Sales!$B:$D,3,0)","v":5640}]
[232656,{"$f":"COUNTIF(Sales!B:B,Articles!A8)","v":2},{"$f":"VLOOKUP(A8,Sales!$B:$D,2,0)","v":"лонгсливы"},{"$f":"VLOOKUP(A8,Sales!$B:$D,3,0)","v":2310}]
["ANOUK/",{"$f":"COUNTIF(Sales!B:B,Articles!A9)","v":2},{"$f":"VLOOKUP(A9,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A9,Sales!$B:$D,3,0)","v":34600}]
["24047/черн.",{"$f":"COUNTIF(Sales!B:B,Articles!A10)","v":2},{"$f":"VLOOKUP(A10,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A10,Sales!$B:$D,3,0)","v":6210}]
["189320/7240",{"$f":"COUNTIF(Sales!B:B,Articles!A11)","v":1},{"$f":"VLOOKUP(A11,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A11,Sales!$B:$D,3,0)","v":10410}]
["6177398/черн.",{"$f":"COUNTIF(Sales!B:B,Articles!A12)","v":1},{"$f":"VLOOKUP(A12,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A12,Sales!$B:$D,3,0)","v":23700}]
["5/36/90970",{"$f":"COUNTIF(Sales!B:B,Articles!A13)","v":1},{"$f":"VLOOKUP(A13,Sales!$B:$D,2,0)","v":"сапоги"},{"$f":"VLOOKUP(A13,Sales!$B:$D,3,0)","v":12870}]
["LF027/",{"$f":"COUNTIF(Sales!B:B,Articles!A14)","v":1},{"$f":"VLOOKUP(A14,Sales!$B:$D,2,0)","v":"пиджаки"},{"$f":"VLOOKUP(A14,Sales!$B:$D,3,0)","v":7000}]
["72GC494",{"$f":"COUNTIF(Sales!B:B,Articles!A15)","v":1},{"$f":"VLOOKUP(A15,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A15,Sales!$B:$D,3,0)","v":1770}]
["19sdp12/9s151",{"$f":"COUNTIF(Sales!B:B,Articles!A16)","v":1},{"$f":"VLOOKUP(A16,Sales!$B:$D,2,0)","v":"джинсы"},{"$f":"VLOOKUP(A16,Sales!$B:$D,3,0)","v":4590}]
["95/000",{"$f":"COUNTIF(Sales!B:B,Articles!A17)","v":1},{"$f":"VLOOKUP(A17,Sales!$B:$D,2,0)","v":"вечерние платья"},{"$f":"VLOOKUP(A17,Sales!$B:$D,3,0)","v":16860}]
[6152636,{"$f":"COUNTIF(Sales!B:B,Articles!A18)","v":1},{"$f":"VLOOKUP(A18,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A18,Sales!$B:$D,3,0)","v":6240}]
["E1532",{"$f":"COUNTIF(Sales!B:B,Articles!A19)","v":1},{"$f":"VLOOKUP(A19,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A19,Sales!$B:$D,3,0)","v":3300}]
["2424/000",{"$f":"COUNTIF(Sales!B:B,Articles!A20)","v":1},{"$f":"VLOOKUP(A20,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A20,Sales!$B:$D,3,0)","v":6960}]
[245445,{"$f":"COUNTIF(Sales!B:B,Articles!A21)","v":1},{"$f":"VLOOKUP(A21,Sales!$B:$D,2,0)","v":"мокасины"},{"$f":"VLOOKUP(A21,Sales!$B:$D,3,0)","v":6180}]
["С12267",{"$f":"COUNTIF(Sales!B:B,Articles!A22)","v":1},{"$f":"VLOOKUP(A22,Sales!$B:$D,2,0)","v":"сапоги"},{"$f":"VLOOKUP(A22,Sales!$B:$D,3,0)","v":6930}]
["CH9094",{"$f":"COUNTIF(Sales!B:B,Articles!A23)","v":1},{"$f":"VLOOKUP(A23,Sales!$B:$D,2,0)","v":"сапоги"},{"$f":"VLOOKUP(A23,Sales!$B:$D,3,0)","v":11550}]
["S49WP0018(SO99770)",{"$f":"COUNTIF(Sales!B:B,Articles!A24)","v":1},{"$f":"VLOOKUP(A24,Sales!$B:$D,2,0)","v":"вечерние платья"},{"$f":"VLOOKUP(A24,Sales!$B:$D,3,0)","v":9810}]
["B1169",{"$f":"COUNTIF(Sales!B:B,Articles!A25)","v":1},{"$f":"VLOOKUP(A25,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A25,Sales!$B:$D,3,0)","v":11280}]
["460aktb999",{"$f":"COUNTIF(Sales!B:B,Articles!A26)","v":1},{"$f":"VLOOKUP(A26,Sales!$B:$D,2,0)","v":"полусапоги"},{"$f":"VLOOKUP(A26,Sales!$B:$D,3,0)","v":5310}]
["269996/40",{"$f":"COUNTIF(Sales!B:B,Articles!A27)","v":1},{"$f":"VLOOKUP(A27,Sales!$B:$D,2,0)","v":"кроссовки"},{"$f":"VLOOKUP(A27,Sales!$B:$D,3,0)","v":7560}]
["CSJ-NS-W-04",{"$f":"COUNTIF(Sales!B:B,Articles!A28)","v":1},{"$f":"VLOOKUP(A28,Sales!$B:$D,2,0)","v":"полусапоги"},{"$f":"VLOOKUP(A28,Sales!$B:$D,3,0)","v":5300}]
["R0000/00W09",{"$f":"COUNTIF(Sales!B:B,Articles!A29)","v":1},{"$f":"VLOOKUP(A29,Sales!$B:$D,2,0)","v":"подвески и бусы"},{"$f":"VLOOKUP(A29,Sales!$B:$D,3,0)","v":4620}]
["I36126/коричневый,синий",{"$f":"COUNTIF(Sales!B:B,Articles!A30)","v":1},{"$f":"VLOOKUP(A30,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A30,Sales!$B:$D,3,0)","v":27650}]
[234959,{"$f":"COUNTIF(Sales!B:B,Articles!A31)","v":1},{"$f":"VLOOKUP(A31,Sales!$B:$D,2,0)","v":"балетки"},{"$f":"VLOOKUP(A31,Sales!$B:$D,3,0)","v":5640}]
["89180/630/C",{"$f":"COUNTIF(Sales!B:B,Articles!A32)","v":1},{"$f":"VLOOKUP(A32,Sales!$B:$D,2,0)","v":"сумки"},{"$f":"VLOOKUP(A32,Sales!$B:$D,3,0)","v":5580}]
["45365/98223чк",{"$f":"COUNTIF(Sales!B:B,Articles!A33)","v":1},{"$f":"VLOOKUP(A33,Sales!$B:$D,2,0)","v":"повседневные платья"},{"$f":"VLOOKUP(A33,Sales!$B:$D,3,0)","v":7380}]
["218403/1081",{"$f":"COUNTIF(Sales!B:B,Articles!A34)","v":1},{"$f":"VLOOKUP(A34,Sales!$B:$D,2,0)","v":"ботильоны"},{"$f":"VLOOKUP(A34,Sales!$B:$D,3,0)","v":7800}]
["SMS17",{"$f":"COUNTIF(Sales!B:B,Articles!A35)","v":1},{"$f":"VLOOKUP(A35,Sales!$B:$D,2,0)","v":"шарфы"},{"$f":"VLOOKUP(A35,Sales!$B:$D,3,0)","v":1740}]
[256110,{"$f":"COUNTIF(Sales!B:B,Articles!A36)","v":1},{"$f":"VLOOKUP(A36,Sales!$B:$D,2,0)","v":"поло с коротким рукавом"},{"$f":"VLOOKUP(A36,Sales!$B:$D,3,0)","v":3960}]
[24253,{"$f":"COUNTIF(Sales!B:B,Articles!A37)","v":1},{"$f":"VLOOKUP(A37,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A37,Sales!$B:$D,3,0)","v":6780}]
["GU58098/00",{"$f":"COUNTIF(Sales!B:B,Articles!A38)","v":1},{"$f":"VLOOKUP(A38,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A38,Sales!$B:$D,3,0)","v":7050}]
["JS17040",{"$f":"COUNTIF(Sales!B:B,Articles!A39)","v":1},{"$f":"VLOOKUP(A39,Sales!$B:$D,2,0)","v":"сапоги"},{"$f":"VLOOKUP(A39,Sales!$B:$D,3,0)","v":11880}]
["406C",{"$f":"COUNTIF(Sales!B:B,Articles!A40)","v":1},{"$f":"VLOOKUP(A40,Sales!$B:$D,2,0)","v":"повседневные платья"},{"$f":"VLOOKUP(A40,Sales!$B:$D,3,0)","v":4170}]
[440,{"$f":"COUNTIF(Sales!B:B,Articles!A41)","v":1},{"$f":"VLOOKUP(A41,Sales!$B:$D,2,0)","v":"повседневные платья"},{"$f":"VLOOKUP(A41,Sales!$B:$D,3,0)","v":5550}]
[177287,{"$f":"COUNTIF(Sales!B:B,Articles!A42)","v":1},{"$f":"VLOOKUP(A42,Sales!$B:$D,2,0)","v":"сумки"},{"$f":"VLOOKUP(A42,Sales!$B:$D,3,0)","v":24750}]
[6513,{"$f":"COUNTIF(Sales!B:B,Articles!A43)","v":1},{"$f":"VLOOKUP(A43,Sales!$B:$D,2,0)","v":"туфли"},{"$f":"VLOOKUP(A43,Sales!$B:$D,3,0)","v":9720}]
["50150033/026",{"$f":"COUNTIF(Sales!B:B,Articles!A44)","v":1},{"$f":"VLOOKUP(A44,Sales!$B:$D,2,0)","v":"куртки"},{"$f":"VLOOKUP(A44,Sales!$B:$D,3,0)","v":5640}]