{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Navigation","Dealer Report","Dealer Report working","Master","Final Dealer Work","Zylem SNS Report","OPG","Reco"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":11,"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":"Navigation","index":0,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ganga Traders"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2020 TO 31-Mar-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":102,"n_cols":5,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["GANGA TRADERS(2020-21)"]
["D No;4-1-2,Near Kuravi Gate"]
["Mahabubabad-506101"]
["PH;9550635188,8367234825"]
["Gst No;36AKIPN4723B1ZE"]
["BAYER CROP SCIENCE LTD (CP)"]
["Stock Summary"]
["1-Apr-2020 to 31-Mar-2021"]
["","BAYER CROP SCIENCE LTD (CP)"]
["","GANGA TRADERS(2020-21)"]
["Particulars","1-Apr-2020 to 31-Mar-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["ADMIRE 150 GM (150X30)"]
["ADMIRE 30GM(1X150)",44,900,866,78]
["ADMIRE 75GM(1X60)",29,480,428,81]
["ALANTO 100 ML (1X50)",38,null,37,1]
["ALANTO 250 ML (1X40)",93,40,53,80]
["ALIETTE 100 GM(1X40)",null,80,70,10]
["AMBITION 1 LT(1X10)"]
["AMBITION 250 ML (1X40)",20,80,67,33]
["AMBITION 500 ML(1X20)",6,60,51,15]
["ANTRACOL 100GM (1X50)",19,1350,1255,114]
["ANTRACOL 1 KG (1X10)",8,490,440,58]
["ANTRACOL 250GM (1X40)",195,4800,4998,-3]
["ANTRACOL 500GM (1X20)",65,1960,1989,36]
["BELT EXPERT SC 100 ML (1X50)",23,250,227,46]
["CONFIDOR 100 ML (1X50)",79,1250,1317,12]
["CONFIDOR 1 LT (1X10)"]
["CONFIDOR 250 ML (1X20)",null,500,485,15]
["CONFIDOR 500 ML (20X500)",null,40,40]
["CONFIDOR 50ML(1X100)",19,400,254,165]
["CONFIDOR SUPER 100 ML(1X50)",37,1100,1105,32]
["CONFIDOR SUPER 250 ML(1X20)",10,60,60,10]
["CONFIDOR SUPER 50 ML(1X50)",39,950,986,3]
["COUNCIL ACTIV 45 GM(1X80)",null,80,35,45]
["COUNCIL ACTIV 90 GM(1X60)",null,60,40,20]
["DECIS 100 ML (1X50)"]
["DECIS 50 ML (1X100)"]
["FAME 100 ML (1X20)",18,160,169,9]
["FAME 10ML (1X200)",43,800,786,57]
["FAME 50 ML (1X40)",36,640,608,68]
["FENOS QUICK SC 100 ML(1X50)",null,100,95,5]
["FENOS QUICK SC 250 ML(1X40)",null,80,74,6]
["FOLICURE 100 ML",16,300,280,36]
["FOLICURE 250 ML",null,320,270,50]
["FOOST 250 GM (1X20)",66,1060,1057,69]
["FOOST 500 GM (1X24)",64,8064,8083,45]
["GAUCHO 250 ML (1X40)",null,40,25,15]
["GAUCHO 50 ML (1X50)",88,null,null,88]
["GLAMORE 100 GM(1X20)",null,20,10,10]
["GLAMORE 50 GM(1X40)",49,40,52,37]
["INFINITO 100 ML (1X50)",null,100,65,35]
["INFINITO 500 ML (1X20)",null,20,20]
["JUMP 2GR (160X2)"]
["LARVIN 100GM (100X40)",29,null,29]
["LARVIN 250 GM (1X20)",46,140,144,42]
["LARVIN 500 GM (1X20)",44,null,2,42]
["LAUDIS 115Ml (1X8)",4,5280,5230,54]
["LAUDIS 230 ML(1X3)",2,1110,1164,-52]
["LAUDIS 57.5ML(1X10)",null,1360,1343,17]
["LESENTA 100 GM(1X50)",47,50,77,20]
["LESENTA 250 GM(250X20)"]
["LESENTA 40 GM(1X100)",69,100,143,26]
["LUNA EXPERIENCE 1 LT (1X10)"]
["LUNA EXPERIENCE SC 100 ML(1X50)",88,50,64,74]
["LUNA EXPERIENCE SC 250 ML(1X40)",71,120,139,52]
["MOVENTO ENERGY 100ML(1X50)",119,550,432,237]
["MOVENTO ENERGY 250ML(1X40)",105,1480,1458,127]
["NATIVO 100 GM (1X50)",117,1450,1393,174]
["NATIVO 10 GM (1X200)",147,5800,5432,515]
["NATIVO 250 GM(1X40)",null,80,68,12]
["NATIVO 50 GM(1X100)",-18,1100,769,313]
["OBERON 100 ML(1X50)",164,4950,5000,114]
["OBERON 200 ML(1X40)",162,6200,6277,85]
["OBERON 500 ML(1X20)",32,460,428,64]
["PLANOFIX 100ML (1X50)",23,1200,1148,75]
["PLANOFIX 250 ML(1X40)",12,120,129,3]
["REGENT GOLD SC 100ML(1X50)",24,200,217,7]
["REGENT GOLD SC 250ML(1X40)",42,120,125,37]
["REGENT GR 1 KG (1X20)",828,3400,4036,192]
["REGENT GR 5 KG(1x4)",141,4220,4155,206]
["REGENT SC 100 ML (1X50)",null,250,235,15]
["REGENT SC 1 LT (1X10)",12,700,692,20]
["REGENT SC 250 ML (1X20)",88,2700,2679,109]
["REGENT SC 500 ML(1X20)",82,2940,2954,68]
["REGENT ULTRA GR 4 KG(4X5)",36,75,104,7]
["SECTIN 100 GM (1X50)",74,null,23,51]
["SIVANTO PRIME 100 ML(1X50)",null,50,40,10]
["SIVANTO PRIME 250 ML(1X40)",63,80,138,5]
["SOLOMON 100ML (1X50)",115,2750,2722,143]
["SOLOMON 1LT (1X10)",1,40,26,15]
["SOLOMON 250ML (1X40)",47,4760,4675,132]
["SOLOMON 500 ML (1X20)",25,420,381,64]
["TOPSTAR 35 GM",-166,null,34,-200]
["VELUM PRIME 250 ML(1X40)",null,40,34,6]
["C DK DKC9081 4 KG (1X7)",null,252,252]
["C DK DKC9120 4 KG (1X7)",null,2,2]
["DKC8171 4.5 KG(1X6)",null,184,184]
["COTTON FIRST CLASS BG II"]
["COTTON SUPERB BGII",null,166,166]
["Total",{"$f":"SUM(B14:B101)","v":3779},81623,81140,4262]

{"sheet":"Dealer Report working","index":2,"n_rows":90,"n_cols":14,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["ADMIRE 150 GM (150X30)",null,null,null,null,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["ADMIRE 30GM(1X150)",44,900,866,78,"ADMIRE (T) WG70 150X30GR BOT IN",null,null,null,"ADMIRE (T) WG70 150X30GR BOT IN",44,900,866,78]
["ADMIRE 75GM(1X60)",29,480,428,81,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,"ADMIRE (T) WG70 30X150GR BOT IN"]
["ALANTO 100 ML (1X50)",38,null,37,1,"ALANTO (T) SC240 50X100ML BOT IN",null,null,null,"ADMIRE (T) WG70 60X75GR BOT IN",29,480,428,81]
["ALANTO 250 ML (1X40)",93,40,53,80,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,"ALANTO (T) SC240 40X250ML BOT IN",93,40,53,80]
["ALIETTE 100 GM(1X40)",null,80,70,10,"ALIETTE WP80 40X100GR BAG IN",null,null,null,"ALANTO (T) SC240 50X100ML BOT IN",38,null,37,1]
["AMBITION 1 LT(1X10)",null,null,null,null,"AMBITION 10X1L BOT IN",null,null,null,"ALIETTE WP80 40X100GR BAG IN",null,80,70,10]
["AMBITION 250 ML (1X40)",20,80,67,33,"AMBITION 40X250ML BOT IN",null,null,null,"AMBITION 10X1L BOT IN"]
["AMBITION 500 ML(1X20)",6,60,51,15,"AMBITION 20X500ML BOT IN",null,null,null,"AMBITION 20X500ML BOT IN",6,60,51,15]
["ANTRACOL 100GM (1X50)",19,1350,1255,114,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,"AMBITION 40X250ML BOT IN",20,80,67,33]
["ANTRACOL 1 KG (1X10)",8,490,440,58,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",8,490,440,58]
["ANTRACOL 250GM (1X40)",195,4800,4998,-3,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",65,1960,1989,36]
["ANTRACOL 500GM (1X20)",65,1960,1989,36,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",195,4800,4998,-3]
["BELT EXPERT SC 100 ML (1X50)",23,250,227,46,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,"ANTRACOL (T) WP70 50X100GR BAG IN",19,1350,1255,114]
["CONFIDOR 100 ML (1X50)",79,1250,1317,12,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,"BELT EXPERT SC480 50X100ML BOT IN",23,250,227,46]
["CONFIDOR 1 LT (1X10)",null,null,null,null,"CONFIDOR (T) SL200 10X1L BOT IN",null,null,null,"C DK DKC8171 4.5KG IN",null,184,184]
["CONFIDOR 250 ML (1X20)",null,500,485,15,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,"C DK DKC9081 4KG IN",null,252,252]
["CONFIDOR 500 ML (20X500)",null,40,40,null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,"C DK DKC9120 4KG IN",null,2,2]
["CONFIDOR 50ML(1X100)",19,400,254,165,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,"CONFIDOR (T) SL200 100X50ML BOT IN",19,400,254,165]
["CONFIDOR SUPER 100 ML(1X50)",37,1100,1105,32,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,"CONFIDOR (T) SL200 10X1L BOT IN"]
["CONFIDOR SUPER 250 ML(1X20)",10,60,60,10,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,500,485,15]
["CONFIDOR SUPER 50 ML(1X50)",39,950,986,3,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,40,40]
["COUNCIL ACTIV 45 GM(1X80)",null,80,35,45,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN",79,1250,1317,12]
["COUNCIL ACTIV 90 GM(1X60)",null,60,40,20,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",10,60,60,10]
["DECIS 100 ML (1X50)",null,null,null,null,"DECIS EC101-2 100X50ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",37,1100,1105,32]
["DECIS 50 ML (1X100)",null,null,null,null,"DECIS EC101-2 100X50ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",39,950,986,3]
["FAME 100 ML (1X20)",18,160,169,9,"FAME (T) SC480 20X100ML BOT IN",null,null,null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,60,40,20]
["FAME 10ML (1X200)",43,800,786,57,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,80,35,45]
["FAME 50 ML (1X40)",36,640,608,68,"FAME (T) SC480 40X50ML BOT IN",null,null,null,"DECIS EC101-2 100X50ML BOT IN"]
["FENOS QUICK SC 100 ML(1X50)",null,100,95,5,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN",43,800,786,57]
["FENOS QUICK SC 250 ML(1X40)",null,80,74,6,"FENOS QUICK SC150 40X250ML BOT IN",null,null,null,"FAME (T) SC480 20X100ML BOT IN",18,160,169,9]
["FOLICURE 100 ML",16,300,280,36,"FOLICUR (T) EC250 50X100ML BOT IN",null,null,null,"FAME (T) SC480 40X50ML BOT IN",36,640,608,68]
["FOLICURE 250 ML",null,320,270,50,"FOLICUR (T) EC250 40X250ML BOT IN",null,null,null,"FENOS QUICK SC150 40X250ML BOT IN",null,80,74,6]
["FOOST 250 GM (1X20)",66,1060,1057,69,"FOOST WP50 20X250G BAG IN",null,null,null,"FENOS QUICK SC150 50X100ML BOT IN",null,100,95,5]
["FOOST 500 GM (1X24)",64,8064,8083,45,"FOOST WP50 24X500G BAG IN",null,null,null,"FOLICUR (T) EC250 40X250ML BOT IN",null,320,270,50]
["GAUCHO 250 ML (1X40)",null,40,25,15,"GAUCHO FS600 40X250ML BOT IN",null,null,null,"FOLICUR (T) EC250 50X100ML BOT IN",16,300,280,36]
["GAUCHO 50 ML (1X50)",88,null,null,88,"GAUCHO FS600 100X50ML BOT IN",null,null,null,"FOOST WP50 20X250G BAG IN",66,1060,1057,69]
["GLAMORE 100 GM(1X20)",null,20,10,10,"GLAMORE WG80 20X100GR BOT IN",null,null,null,"FOOST WP50 24X500G BAG IN",64,8064,8083,45]
["GLAMORE 50 GM(1X40)",49,40,52,37,"GLAMORE WG80 40X50GR BOT IN",null,null,null,"GAUCHO FS600 100X50ML BOT IN",88,null,null,88]
["INFINITO 100 ML (1X50)",null,100,65,35,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,"GAUCHO FS600 40X250ML BOT IN",null,40,25,15]
["INFINITO 500 ML (1X20)",null,20,20,null,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,"GLAMORE WG80 20X100GR BOT IN",null,20,10,10]
["JUMP 2GR (160X2)",null,null,null,null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,"GLAMORE WG80 40X50GR BOT IN",49,40,52,37]
["LARVIN 100GM (100X40)",29,null,29,null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,"INFINITO SC687 5 20X500ML BOT IN",null,20,20]
["LARVIN 250 GM (1X20)",46,140,144,42,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,"INFINITO SC687 5 50X100ML BOT IN",null,100,65,35]
["LARVIN 500 GM (1X20)",44,null,2,42,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,"JUMP WG80 160X(10X2GR) BAG IN"]
["LAUDIS 115Ml (1X8)",4,5280,5230,54,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"LARVIN (T) WP75 20X250GR BAG IN",46,140,144,42]
["LAUDIS 230 ML(1X3)",2,1110,1164,-52,"LAUDIS SC630 3X230ML BOT IN",null,null,null,"LARVIN (T) WP75 20X500GR BAG IN",44,null,2,42]
["LAUDIS 57.5ML(1X10)",null,1360,1343,17,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,"LARVIN (T) WP75 40X100GR BAG IN",29,null,29]
["LESENTA 100 GM(1X50)",47,50,77,20,"LESENTA WG80 50X100GR BAG IN",null,null,null,"LAUDIS SC630 10X57.5ML BOT IN",null,1360,1343,17]
["LESENTA 250 GM(250X20)",null,null,null,null,"LESENTA WG80 20X250GR BAG IN",null,null,null,"LAUDIS SC630 3X230ML BOT IN",2,1110,1164,-52]
["LESENTA 40 GM(1X100)",69,100,143,26,"LESENTA WG80 100X40GR BAG IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN",4,5280,5230,54]
["LUNA EXPERIENCE 1 LT (1X10)",null,null,null,null,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,"LESENTA WG80 100X40GR BAG IN",69,100,143,26]
["LUNA EXPERIENCE SC 100 ML(1X50)",88,50,64,74,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,"LESENTA WG80 20X250GR BAG IN"]
["LUNA EXPERIENCE SC 250 ML(1X40)",71,120,139,52,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,"LESENTA WG80 50X100GR BAG IN",47,50,77,20]
["MOVENTO ENERGY 100ML(1X50)",119,550,432,237,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,"LUNA EXPERIENCE SC400 10X1L BOT IN"]
["MOVENTO ENERGY 250ML(1X40)",105,1480,1458,127,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",71,120,139,52]
["NATIVO 100 GM (1X50)",117,1450,1393,174,"NATIVO WG75 50X100GR BAG IN",null,null,null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",88,50,64,74]
["NATIVO 10 GM (1X200)",147,5800,5432,515,"NATIVO WG75 20X(10X10GR) BAG IN",null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",105,1480,1458,127]
["NATIVO 250 GM(1X40)",null,80,68,12,"NATIVO WG75 40X250GR BAG IN",null,null,null,"MOVENTO ENERGY SC240 50X100ML BOT IN",119,550,432,237]
["NATIVO 50 GM(1X100)",-18,1100,769,313,"NATIVO WG75 100X50GR BAG IN",null,null,null,"NATIVO WG75 100X50GR BAG IN",-18,1100,769,313]
["OBERON 100 ML(1X50)",164,4950,5000,114,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"NATIVO WG75 20X(10X10GR) BAG IN",147,5800,5432,515]
["OBERON 200 ML(1X40)",162,6200,6277,85,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",null,80,68,12]
["OBERON 500 ML(1X20)",32,460,428,64,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",117,1450,1393,174]
["PLANOFIX 100ML (1X50)",23,1200,1148,75,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 20X500ML BOT IN",32,460,428,64]
["PLANOFIX 250 ML(1X40)",12,120,129,3,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",162,6200,6277,85]
["REGENT GOLD SC 100ML(1X50)",24,200,217,7,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN",164,4950,5000,114]
["REGENT GOLD SC 250ML(1X40)",42,120,125,37,"REGENT GOLD SC200 40X250ML BOT IN",null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",12,120,129,3]
["REGENT GR 1 KG (1X20)",828,3400,4036,192,"REGENT GR0 3 20X1KG BAG IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",23,1200,1148,75]
["REGENT GR 5 KG(1x4)",141,4220,4155,206,"REGENT GR0 3 4X5KG BAG IN",null,null,null,"REGENT (T) SC50 10X1L BOT IN",12,700,692,20]
["REGENT SC 100 ML (1X50)",null,250,235,15,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 20X250ML BOT IN",88,2700,2679,109]
["REGENT SC 1 LT (1X10)",12,700,692,20,"REGENT (T) SC50 10X1L BOT IN",null,null,null,"REGENT (T) SC50 20X500ML BOT IN",82,2940,2954,68]
["REGENT SC 250 ML (1X20)",88,2700,2679,109,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,"REGENT (T) SC50 50X100ML BOT IN",null,250,235,15]
["REGENT SC 500 ML(1X20)",82,2940,2954,68,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,"REGENT GOLD SC200 40X250ML BOT IN",42,120,125,37]
["REGENT ULTRA GR 4 KG(4X5)",36,75,104,7,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,"REGENT GOLD SC200 50X100ML BOT IN",24,200,217,7]
["SECTIN 100 GM (1X50)",74,null,23,51,"SECTIN WG60 50X100GR BAG IN",null,null,null,"REGENT GR0 3 20X1KG BAG IN",828,3400,4036,192]
["SIVANTO PRIME 100 ML(1X50)",null,50,40,10,"SIVANTO PRIME SL200 50X100ML BOT IN",null,null,null,"REGENT GR0 3 4X5KG BAG IN",141,4220,4155,206]
["SIVANTO PRIME 250 ML(1X40)",63,80,138,5,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,"REGENT ULTRA GR0 6 5X4KG BAG IN",36,75,104,7]
["SOLOMON 100ML (1X50)",115,2750,2722,143,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"SECTIN WG60 50X100GR BAG IN",74,null,23,51]
["SOLOMON 1LT (1X10)",1,40,26,15,"SOLOMON OD300 10X1L BOT IN",null,null,null,"SIVANTO PRIME SL200 40X250ML BOT IN",63,80,138,5]
["SOLOMON 250ML (1X40)",47,4760,4675,132,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"SIVANTO PRIME SL200 50X100ML BOT IN",null,50,40,10]
["SOLOMON 500 ML (1X20)",25,420,381,64,"SOLOMON OD300 20X500ML BOT IN",null,null,null,"SOLOMON OD300 10X1L BOT IN",1,40,26,15]
["TOPSTAR 35 GM",-166,null,34,-200,"TOPSTAR (T) WP80 10X(10X35GR) BOX IN",null,null,null,"SOLOMON OD300 20X500ML BOT IN",25,420,381,64]
["VELUM PRIME 250 ML(1X40)",null,40,34,6,"VELUM PRIME SC400 40X250ML BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN",47,4760,4675,132]
["C DK DKC9081 4 KG (1X7)",null,252,252,null,"C DK DKC9081 4KG IN",null,null,null,"SOLOMON OD300 50X100ML BOT IN",115,2750,2722,143]
["C DK DKC9120 4 KG (1X7)",null,2,2,null,"C DK DKC9120 4KG IN",null,null,null,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN"]
["DKC8171 4.5 KG(1X6)",null,184,184,null,"C DK DKC8171 4.5KG IN",null,null,null,"SURPASS SUPERB BG2 20X450G BAG IN",null,166,166]
["COTTON FIRST CLASS BG II",null,null,null,null,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",null,null,null,"TOPSTAR (T) WP80 10X(10X35GR) BOX IN",-166,null,34,-200]
["COTTON SUPERB BGII",null,166,166,null,"SURPASS SUPERB BG2 20X450G BAG IN",null,null,null,"VELUM PRIME SC400 40X250ML BOT IN",null,40,34,6]
[null,null,null,null,null,null,null,null,null,"Grand Total",3779,81623,81140,4262]

{"sheet":"Master","index":3,"n_rows":89,"n_cols":2,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["ADMIRE 150 GM (150X30)","ADMIRE (T) WG70 30X150GR BOT IN"]
["ADMIRE 30GM(1X150)","ADMIRE (T) WG70 150X30GR BOT IN"]
["ADMIRE 75GM(1X60)","ADMIRE (T) WG70 60X75GR BOT IN"]
["ALANTO 100 ML (1X50)","ALANTO (T) SC240 50X100ML BOT IN"]
["ALANTO 250 ML (1X40)","ALANTO (T) SC240 40X250ML BOT IN"]
["ALIETTE 100 GM(1X40)","ALIETTE WP80 40X100GR BAG IN"]
["AMBITION 1 LT(1X10)","AMBITION 10X1L BOT IN"]
["AMBITION 250 ML (1X40)","AMBITION 40X250ML BOT IN"]
["AMBITION 500 ML(1X20)","AMBITION 20X500ML BOT IN"]
["ANTRACOL 100GM (1X50)","ANTRACOL (T) WP70 50X100GR BAG IN"]
["ANTRACOL 1 KG (1X10)","ANTRACOL (T) WP70 10X1KG BAG IN"]
["ANTRACOL 250GM (1X40)","ANTRACOL (T) WP70 40X250GR BAG IN"]
["ANTRACOL 500GM (1X20)","ANTRACOL (T) WP70 20X500GR BAG IN"]
["BELT EXPERT SC 100 ML (1X50)","BELT EXPERT SC480 50X100ML BOT IN"]
["CONFIDOR 100 ML (1X50)","CONFIDOR (T) SL200 50X100ML BOT IN"]
["CONFIDOR 1 LT (1X10)","CONFIDOR (T) SL200 10X1L BOT IN"]
["CONFIDOR 250 ML (1X20)","CONFIDOR (T) SL200 20X250ML BOT IN"]
["CONFIDOR 500 ML (20X500)","CONFIDOR (T) SL200 20X500ML BOT IN"]
["CONFIDOR 50ML(1X100)","CONFIDOR (T) SL200 100X50ML BOT IN"]
["CONFIDOR SUPER 100 ML(1X50)","CONFIDOR SUPER (T) SC350 50X100ML BOT IN"]
["CONFIDOR SUPER 250 ML(1X20)","CONFIDOR SUPER (T) SC350 20X250ML BOT IN"]
["CONFIDOR SUPER 50 ML(1X50)","CONFIDOR SUPER (T) SC350 50X50ML BOT IN"]
["COUNCIL ACTIV 45 GM(1X80)","COUNCIL ACTIV WG30 8X(10X45GR) BOX IN"]
["COUNCIL ACTIV 90 GM(1X60)","COUNCIL ACTIV WG30 12X(5X90GR) BOX IN"]
["DECIS 100 ML (1X50)","DECIS EC101-2 100X50ML BOT IN"]
["DECIS 50 ML (1X100)","DECIS EC101-2 100X50ML BOT IN"]
["FAME 100 ML (1X20)","FAME (T) SC480 20X100ML BOT IN"]
["FAME 10ML (1X200)","FAME (T) SC480 10X(20X10ML) BOT IN"]
["FAME 50 ML (1X40)","FAME (T) SC480 40X50ML BOT IN"]
["FENOS QUICK SC 100 ML(1X50)","FENOS QUICK SC150 50X100ML BOT IN"]
["FENOS QUICK SC 250 ML(1X40)","FENOS QUICK SC150 40X250ML BOT IN"]
["FOLICURE 100 ML","FOLICUR (T) EC250 50X100ML BOT IN"]
["FOLICURE 250 ML","FOLICUR (T) EC250 40X250ML BOT IN"]
["FOOST 250 GM (1X20)","FOOST WP50 20X250G BAG IN"]
["FOOST 500 GM (1X24)","FOOST WP50 24X500G BAG IN"]
["GAUCHO 250 ML (1X40)","GAUCHO FS600 40X250ML BOT IN"]
["GAUCHO 50 ML (1X50)","GAUCHO FS600 100X50ML BOT IN"]
["GLAMORE 100 GM(1X20)","GLAMORE WG80 20X100GR BOT IN"]
["GLAMORE 50 GM(1X40)","GLAMORE WG80 40X50GR BOT IN"]
["INFINITO 100 ML (1X50)","INFINITO SC687 5 50X100ML BOT IN"]
["INFINITO 500 ML (1X20)","INFINITO SC687 5 20X500ML BOT IN"]
["JUMP 2GR (160X2)","JUMP WG80 160X(10X2GR) BAG IN"]
["LARVIN 100GM (100X40)","LARVIN (T) WP75 40X100GR BAG IN"]
["LARVIN 250 GM (1X20)","LARVIN (T) WP75 20X250GR BAG IN"]
["LARVIN 500 GM (1X20)","LARVIN (T) WP75 20X500GR BAG IN"]
["LAUDIS 115Ml (1X8)","LAUDIS SC630 8X115ML BOT IN"]
["LAUDIS 230 ML(1X3)","LAUDIS SC630 3X230ML BOT IN"]
["LAUDIS 57.5ML(1X10)","LAUDIS SC630 10X57.5ML BOT IN"]
["LESENTA 100 GM(1X50)","LESENTA WG80 50X100GR BAG IN"]
["LESENTA 250 GM(250X20)","LESENTA WG80 20X250GR BAG IN"]
["LESENTA 40 GM(1X100)","LESENTA WG80 100X40GR BAG IN"]
["LUNA EXPERIENCE 1 LT (1X10)","LUNA EXPERIENCE SC400 10X1L BOT IN"]
["LUNA EXPERIENCE SC 100 ML(1X50)","LUNA EXPERIENCE SC400 50X100ML BOT IN"]
["LUNA EXPERIENCE SC 250 ML(1X40)","LUNA EXPERIENCE SC400 40X250ML BOT IN"]
["MOVENTO ENERGY 100ML(1X50)","MOVENTO ENERGY SC240 50X100ML BOT IN"]
["MOVENTO ENERGY 250ML(1X40)","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["NATIVO 100 GM (1X50)","NATIVO WG75 50X100GR BAG IN"]
["NATIVO 10 GM (1X200)","NATIVO WG75 20X(10X10GR) BAG IN"]
["NATIVO 250 GM(1X40)","NATIVO WG75 40X250GR BAG IN"]
["NATIVO 50 GM(1X100)","NATIVO WG75 100X50GR BAG IN"]
["OBERON 100 ML(1X50)","OBERON (T) SC240 50X100ML BOT IN"]
["OBERON 200 ML(1X40)","OBERON (T) SC240 40X200ML BOT IN"]
["OBERON 500 ML(1X20)","OBERON (T) SC240 20X500ML BOT IN"]
["PLANOFIX 100ML (1X50)","PLANOFIX SL4 5 50X100ML BOT IN"]
["PLANOFIX 250 ML(1X40)","PLANOFIX SL4 5 40X250ML BOT IN"]
["REGENT GOLD SC 100ML(1X50)","REGENT GOLD SC200 50X100ML BOT IN"]
["REGENT GOLD SC 250ML(1X40)","REGENT GOLD SC200 40X250ML BOT IN"]
["REGENT GR 1 KG (1X20)","REGENT GR0 3 20X1KG BAG IN"]
["REGENT GR 5 KG(1x4)","REGENT GR0 3 4X5KG BAG IN"]
["REGENT SC 100 ML (1X50)","REGENT (T) SC50 50X100ML BOT IN"]
["REGENT SC 1 LT (1X10)","REGENT (T) SC50 10X1L BOT IN"]
["REGENT SC 250 ML (1X20)","REGENT (T) SC50 20X250ML BOT IN"]
["REGENT SC 500 ML(1X20)","REGENT (T) SC50 20X500ML BOT IN"]
["REGENT ULTRA GR 4 KG(4X5)","REGENT ULTRA GR0 6 5X4KG BAG IN"]
["SECTIN 100 GM (1X50)","SECTIN WG60 50X100GR BAG IN"]
["SIVANTO PRIME 100 ML(1X50)","SIVANTO PRIME SL200 50X100ML BOT IN"]
["SIVANTO PRIME 250 ML(1X40)","SIVANTO PRIME SL200 40X250ML BOT IN"]
["SOLOMON 100ML (1X50)","SOLOMON OD300 50X100ML BOT IN"]
["SOLOMON 1LT (1X10)","SOLOMON OD300 10X1L BOT IN"]
["SOLOMON 250ML (1X40)","SOLOMON OD300 40X250ML BOT IN"]
["SOLOMON 500 ML (1X20)","SOLOMON OD300 20X500ML BOT IN"]
["TOPSTAR 35 GM","TOPSTAR (T) WP80 10X(10X35GR) BOX IN"]
["VELUM PRIME 250 ML(1X40)","VELUM PRIME SC400 40X250ML BOT IN"]
["C DK DKC9081 4 KG (1X7)","C DK DKC9081 4KG IN"]
["C DK DKC9120 4 KG (1X7)","C DK DKC9120 4KG IN"]
["DKC8171 4.5 KG(1X6)","C DK DKC8171 4.5KG IN"]
["COTTON FIRST CLASS BG II","SURPASS FIRSTCLASS 7149B2 20X450G BAG IN"]
["COTTON SUPERB BGII","SURPASS SUPERB BG2 20X450G BAG IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":90,"n_cols":14,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PRODUCT","ITEMALIAS","Bpc","Volume","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
[null,"ADMIRE (T) WG70 150X30GR BOT IN",null,null,null,44,900,0,866,0,0,0,0,78]
[null,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,29,480,0,428,0,0,0,0,81]
[null,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,93,40,0,53,0,0,0,0,80]
[null,"ALANTO (T) SC240 50X100ML BOT IN",null,null,null,38,0,0,37,0,0,0,0,1]
[null,"ALIETTE WP80 40X100GR BAG IN",null,null,null,0,80,0,70,0,0,0,0,10]
[null,"AMBITION 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"AMBITION 20X500ML BOT IN",null,null,null,6,60,0,51,0,0,0,0,15]
[null,"AMBITION 40X250ML BOT IN",null,null,null,20,80,0,67,0,0,0,0,33]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,8,490,0,440,0,0,0,0,58]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,65,1960,0,1989,0,0,0,0,36]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,195,4800,0,4998,0,0,0,0,-3]
[null,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,19,1350,0,1255,0,0,0,0,114]
[null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,23,250,0,227,0,0,0,0,46]
[null,"C DK DKC8171 4.5KG IN",null,null,null,0,184,0,184,0,0,0,0,0]
[null,"C DK DKC9081 4KG IN",null,null,null,0,252,0,252,0,0,0,0,0]
[null,"C DK DKC9120 4KG IN",null,null,null,0,2,0,2,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,19,400,0,254,0,0,0,0,165]
[null,"CONFIDOR (T) SL200 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,0,500,0,485,0,0,0,0,15]
[null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,0,40,0,40,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,79,1250,0,1317,0,0,0,0,12]
[null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,10,60,0,60,0,0,0,0,10]
[null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,37,1100,0,1105,0,0,0,0,32]
[null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,39,950,0,986,0,0,0,0,3]
[null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,0,60,0,40,0,0,0,0,20]
[null,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,null,null,0,80,0,35,0,0,0,0,45]
[null,"DECIS EC101-2 100X50ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,43,800,0,786,0,0,0,0,57]
[null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,18,160,0,169,0,0,0,0,9]
[null,"FAME (T) SC480 40X50ML BOT IN",null,null,null,36,640,0,608,0,0,0,0,68]
[null,"FENOS QUICK SC150 40X250ML BOT IN",null,null,null,0,80,0,74,0,0,0,0,6]
[null,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,0,100,0,95,0,0,0,0,5]
[null,"FOLICUR (T) EC250 40X250ML BOT IN",null,null,null,0,320,0,270,0,0,0,0,50]
[null,"FOLICUR (T) EC250 50X100ML BOT IN",null,null,null,16,300,0,280,0,0,0,0,36]
[null,"FOOST WP50 20X250G BAG IN",null,null,null,66,1060,0,1057,0,0,0,0,69]
[null,"FOOST WP50 24X500G BAG IN",null,null,null,64,8064,0,8083,0,0,0,0,45]
[null,"GAUCHO FS600 100X50ML BOT IN",null,null,null,88,0,0,0,0,0,0,0,88]
[null,"GAUCHO FS600 40X250ML BOT IN",null,null,null,0,40,0,25,0,0,0,0,15]
[null,"GLAMORE WG80 20X100GR BOT IN",null,null,null,0,20,0,10,0,0,0,0,10]
[null,"GLAMORE WG80 40X50GR BOT IN",null,null,null,49,40,0,52,0,0,0,0,37]
[null,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,0,20,0,20,0,0,0,0,0]
[null,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,0,100,0,65,0,0,0,0,35]
[null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,46,140,0,144,0,0,0,0,42]
[null,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,44,0,0,2,0,0,0,0,42]
[null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,29,0,0,29,0,0,0,0,0]
[null,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,0,1360,0,1343,0,0,0,0,17]
[null,"LAUDIS SC630 3X230ML BOT IN",null,null,null,2,1110,0,1164,0,0,0,0,-52]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,4,5280,0,5230,0,0,0,0,54]
[null,"LESENTA WG80 100X40GR BAG IN",null,null,null,69,100,0,143,0,0,0,0,26]
[null,"LESENTA WG80 20X250GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"LESENTA WG80 50X100GR BAG IN",null,null,null,47,50,0,77,0,0,0,0,20]
[null,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,71,120,0,139,0,0,0,0,52]
[null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,88,50,0,64,0,0,0,0,74]
[null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,105,1480,0,1458,0,0,0,0,127]
[null,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,119,550,0,432,0,0,0,0,237]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,-18,1100,0,769,0,0,0,0,313]
[null,"NATIVO WG75 20X(10X10GR) BAG IN",null,null,null,147,5800,0,5432,0,0,0,0,515]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,0,80,0,68,0,0,0,0,12]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,117,1450,0,1393,0,0,0,0,174]
[null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,32,460,0,428,0,0,0,0,64]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,162,6200,0,6277,0,0,0,0,85]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,164,4950,0,5000,0,0,0,0,114]
[null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,12,120,0,129,0,0,0,0,3]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,23,1200,0,1148,0,0,0,0,75]
[null,"REGENT (T) SC50 10X1L BOT IN",null,null,null,12,700,0,692,0,0,0,0,20]
[null,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,88,2700,0,2679,0,0,0,0,109]
[null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,82,2940,0,2954,0,0,0,0,68]
[null,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,0,250,0,235,0,0,0,0,15]
[null,"REGENT GOLD SC200 40X250ML BOT IN",null,null,null,42,120,0,125,0,0,0,0,37]
[null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,24,200,0,217,0,0,0,0,7]
[null,"REGENT GR0 3 20X1KG BAG IN",null,null,null,828,3400,0,4036,0,0,0,0,192]
[null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,141,4220,0,4155,0,0,0,0,206]
[null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,36,75,0,104,0,0,0,0,7]
[null,"SECTIN WG60 50X100GR BAG IN",null,null,null,74,0,0,23,0,0,0,0,51]
[null,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,63,80,0,138,0,0,0,0,5]
[null,"SIVANTO PRIME SL200 50X100ML BOT IN",null,null,null,0,50,0,40,0,0,0,0,10]
[null,"SOLOMON OD300 10X1L BOT IN",null,null,null,1,40,0,26,0,0,0,0,15]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,25,420,0,381,0,0,0,0,64]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,47,4760,0,4675,0,0,0,0,132]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,115,2750,0,2722,0,0,0,0,143]
[null,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SURPASS SUPERB BG2 20X450G BAG IN",null,null,null,0,166,0,166,0,0,0,0,0]
[null,"TOPSTAR (T) WP80 10X(10X35GR) BOX IN",null,null,null,-166,0,0,34,0,0,0,0,-200]
[null,"VELUM PRIME SC400 40X250ML BOT IN",null,null,null,0,40,0,34,0,0,0,0,6]
[null,"Grand Total",null,null,null,3779,81623,0,81140,0,0,0,0,4262]

{"sheet":"Zylem SNS Report","index":5,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,0,1,12],[3,0,3,12],[4,0,4,12],[5,0,5,12],[6,0,6,12]]}
[]
["Company Name:-BAYER"]
["Stock and Sales FOR THE PERIOD 01-Apr-2020 TO 31-Mar-2021"]
["Generated on 5/10/2021 5:45:25 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Ganga Traders,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Ganga Traders",3920886,"ADMIRE (T) WG70 150X30GR BOT IN",79234988,44,1050,150,874,8,0,0,0,78]
["Ganga Traders",3920886,"ADMIRE (T) WG70 60X75GR BOT IN",79297696,29,480,0,454,26,0,0,0,81]
["Ganga Traders",3920886,"ALANTO (T) SC240 40X250ML BOT IN",79915713,93,40,0,53,0,0,0,0,80]
["Ganga Traders",3920886,"ALANTO (T) SC240 50X100ML BOT IN",79901062,38,0,0,37,0,0,0,0,1]
["Ganga Traders",3920886,"ALIETTE WP80 40X100GR BAG IN",3822331,0,80,0,78,8,0,0,0,10]
["Ganga Traders",3920886,"AMBITION 20X500ML BOT IN",86228564,6,60,0,51,0,0,0,0,15]
["Ganga Traders",3920886,"AMBITION 40X250ML BOT IN",86232308,20,80,0,75,8,0,0,0,33]
["Ganga Traders",3920886,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,8,490,0,450,10,0,0,0,58]
["Ganga Traders",3920886,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,65,1960,0,1989,0,0,0,0,36]
["Ganga Traders",3920886,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,195,4800,0,5006,8,0,0,0,-3]
["Ganga Traders",3920886,"ANTRACOL (T) WP70 50X100GR BAG IN",6113191,19,1350,0,1309,54,0,0,0,114]
["Ganga Traders",3920886,"BELT EXPERT SC480 50X100ML BOT IN",79722869,23,350,100,290,63,0,0,0,46]
["Ganga Traders",3920886,"CONFIDOR (T) SL200 100X50ML BOT IN",5708361,19,500,100,334,80,0,0,0,165]
["Ganga Traders",3920886,"CONFIDOR (T) SL200 20X250ML BOT IN",5699494,0,580,80,512,27,0,0,0,15]
["Ganga Traders",3920886,"CONFIDOR (T) SL200 20X500ML BOT IN",5704439,0,120,80,40,0,0,0,0,0]
["Ganga Traders",3920886,"CONFIDOR (T) SL200 50X100ML BOT IN",5703475,79,1300,50,1320,3,0,0,0,12]
["Ganga Traders",3920886,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",79710852,10,80,20,60,0,0,0,0,10]
["Ganga Traders",3920886,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",79735219,37,1150,50,1114,9,0,0,0,32]
["Ganga Traders",3920886,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",79985169,39,1000,50,986,0,0,0,0,3]
["Ganga Traders",3920886,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",80882629,0,60,0,60,20,0,0,0,20]
["Ganga Traders",3920886,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",80861729,0,80,0,80,45,0,0,0,45]
["Ganga Traders",3920886,"FAME (T) SC480 10X(20X10ML) BOT IN",79305885,43,1000,200,828,42,0,0,0,57]
["Ganga Traders",3920886,"FAME (T) SC480 20X100ML BOT IN",79266197,18,180,20,179,10,0,0,0,9]
["Ganga Traders",3920886,"FAME (T) SC480 40X50ML BOT IN",79224699,36,640,0,649,41,0,0,0,68]
["Ganga Traders",3920886,"FENOS QUICK SC150 40X250ML BOT IN",81016984,0,80,0,74,0,0,0,0,6]
["Ganga Traders",3920886,"FENOS QUICK SC150 50X100ML BOT IN",80942990,0,100,0,95,0,0,0,0,5]
["Ganga Traders",3920886,"FOLICUR (T) EC250 40X250ML BOT IN",79682271,0,320,0,286,16,0,0,0,50]
["Ganga Traders",3920886,"FOLICUR (T) EC250 50X100ML BOT IN",79629125,16,300,0,301,21,0,0,0,36]
["Ganga Traders",3920886,"FOOST WP50 20X250G BAG IN",85760270,66,1080,20,1062,5,0,0,0,69]
["Ganga Traders",3920886,"FOOST WP50 24X500G BAG IN",85811770,64,10536,2472,8193,110,0,0,0,45]
["Ganga Traders",3920886,"GAUCHO FS600 100X50ML BOT IN",80034733,88,0,0,0,0,0,0,0,88]
["Ganga Traders",3920886,"GAUCHO FS600 40X250ML BOT IN",84995681,0,40,0,35,10,0,0,0,15]
["Ganga Traders",3920886,"GLAMORE WG80 20X100GR BOT IN",79985312,0,20,0,10,0,0,0,0,10]
["Ganga Traders",3920886,"GLAMORE WG80 40X50GR BOT IN",79973772,49,40,0,89,37,0,0,0,37]
["Ganga Traders",3920886,"INFINITO SC687 5 20X500ML BOT IN",79641176,0,20,0,20,0,0,0,0,0]
["Ganga Traders",3920886,"INFINITO SC687 5 50X100ML BOT IN",79632487,0,150,50,75,10,0,0,0,35]
["Ganga Traders",3920886,"JUMP WG80 160X(10X2GR) BAG IN",79215304,0,0,0,0,0,0,0,0,0]
["Ganga Traders",3920886,"LARVIN (T) WP75 20X250GR BAG IN",6003167,46,140,0,161,17,0,0,0,42]
["Ganga Traders",3920886,"LARVIN (T) WP75 20X500GR BAG IN",6005291,44,0,0,2,0,0,0,0,42]
["Ganga Traders",3920886,"LARVIN (T) WP75 40X100GR BAG IN",5980436,29,0,0,29,0,0,0,0,0]
["Ganga Traders",3920886,"LAUDIS SC630 10X57.5ML BOT IN",84470481,0,1910,550,1353,10,0,0,0,17]
["Ganga Traders",3920886,"LAUDIS SC630 3X230ML BOT IN",80563523,2,1362,252,1205,41,0,0,0,-52]
["Ganga Traders",3920886,"LAUDIS SC630 8X115ML BOT IN",80491085,4,6040,760,5295,65,0,0,0,54]
["Ganga Traders",3920886,"LESENTA WG80 100X40GR BAG IN",80500823,69,100,0,143,0,0,0,0,26]
["Ganga Traders",3920886,"LESENTA WG80 50X100GR BAG IN",80503385,47,50,0,77,0,0,0,0,20]
["Ganga Traders",3920886,"LUNA EXPERIENCE SC400 10X1L BOT IN",80251904,0,0,0,0,0,0,0,0,0]
["Ganga Traders",3920886,"LUNA EXPERIENCE SC400 40X250ML BOT IN",80549652,71,160,40,165,26,0,0,0,52]
["Ganga Traders",3920886,"LUNA EXPERIENCE SC400 50X100ML BOT IN",80199414,88,100,50,92,28,0,0,0,74]
["Ganga Traders",3920886,"MOVENTO ENERGY SC240 40X250ML BOT IN",79679505,105,1760,280,1919,461,0,0,0,127]
["Ganga Traders",3920886,"MOVENTO ENERGY SC240 50X100ML BOT IN",79722605,119,650,100,607,175,0,0,0,237]
["Ganga Traders",3920886,"NATIVO WG75 100X50GR BAG IN",80580061,-18,1100,0,955,186,0,0,0,313]
["Ganga Traders",3920886,"NATIVO WG75 20X(10X10GR) BAG IN",80899920,147,6800,1000,5432,0,0,0,0,515]
["Ganga Traders",3920886,"NATIVO WG75 40X250GR BAG IN",79237790,0,120,40,81,13,0,0,0,12]
["Ganga Traders",3920886,"NATIVO WG75 50X100GR BAG IN",79304102,117,1450,0,1444,51,0,0,0,174]
["Ganga Traders",3920886,"OBERON (T) SC240 20X500ML BOT IN",80026471,32,480,20,492,64,0,0,0,64]
["Ganga Traders",3920886,"OBERON (T) SC240 40X200ML BOT IN",79971362,162,6280,80,6383,106,0,0,0,85]
["Ganga Traders",3920886,"OBERON (T) SC240 50X100ML BOT IN",79998538,164,6100,1150,5294,294,0,0,0,114]
["Ganga Traders",3920886,"PLANOFIX SL4 5 40X250ML BOT IN",3825128,12,120,0,129,0,0,0,0,3]
["Ganga Traders",3920886,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,23,1200,0,1154,6,0,0,0,75]
["Ganga Traders",3920886,"REGENT (T) SC50 20X250ML BOT IN",5976951,88,2860,160,2734,55,0,0,0,109]
["Ganga Traders",3920886,"REGENT (T) SC50 20X500ML BOT IN",5987678,82,3040,100,2980,26,0,0,0,68]
["Ganga Traders",3920886,"REGENT (T) SC50 50X100ML BOT IN",5975343,0,600,350,235,0,0,0,0,15]
["Ganga Traders",3920886,"REGENT GOLD SC200 40X250ML BOT IN",84126616,42,120,0,155,30,0,0,0,37]
["Ganga Traders",3920886,"REGENT GOLD SC200 50X100ML BOT IN",84133965,24,200,0,256,39,0,0,0,7]
["Ganga Traders",3920886,"REGENT GR0 3 20X1KG BAG IN",79667140,828,3400,0,4036,0,0,0,0,192]
["Ganga Traders",3920886,"REGENT GR0 3 4X5KG BAG IN",80018703,141,4220,0,4155,0,0,0,0,206]
["Ganga Traders",3920886,"REGENT ULTRA GR0 6 5X4KG BAG IN",84093394,36,75,0,124,20,0,0,0,7]
["Ganga Traders",3920886,"SECTIN WG60 50X100GR BAG IN",5950812,74,0,0,35,12,0,0,0,51]
["Ganga Traders",3920886,"SIVANTO PRIME SL200 40X250ML BOT IN",80895909,63,80,0,149,11,0,0,0,5]
["Ganga Traders",3920886,"SIVANTO PRIME SL200 50X100ML BOT IN",80961197,0,50,0,50,10,0,0,0,10]
["Ganga Traders",3920886,"SOLOMON OD300 10X1L BOT IN",79637365,1,40,0,32,6,0,0,0,15]
["Ganga Traders",3920886,"SOLOMON OD300 20X500ML BOT IN",79987870,25,560,140,445,64,0,0,0,64]
["Ganga Traders",3920886,"SOLOMON OD300 40X250ML BOT IN",79706723,47,4840,80,4843,168,0,0,0,132]
["Ganga Traders",3920886,"SOLOMON OD300 50X100ML BOT IN",79641931,115,2850,100,2926,204,0,0,0,143]
["Ganga Traders",3920886,"SURPASS SUPERB BG2 20X450G BAG IN",84950246,0,500,334,420,254,0,0,0,0]
["Ganga Traders",3920886,"TOPSTAR (T) WP80 10X(10X35GR) BOX IN",79109040,-166,0,0,34,0,0,0,0,-200]
["Ganga Traders",3920886,"VELUM PRIME SC400 40X250ML BOT IN",84474886,0,40,0,45,11,0,0,0,6]
["Ganga Traders",3920886,"C DK DKC8171 4.5KG IN",12801403,0,282,98,249,65,0,0,0,0]
["Ganga Traders",3920886,"DECIS EC101-2 100X50ML BOT IN",79646194,0,0,0,0,0,0,0,0,0]
["Ganga Traders",3920886,"REGENT (T) SC50 10X1L BOT IN",5962667,12,850,150,703,11,0,0,0,20]
["GRANDTOTAL",null,null,null,3779,90645,9276,84086,3200,0,0,0,4262]

{"sheet":"OPG","index":6,"n_rows":87,"n_cols":3,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["ADMIRE (T) WG70 150X30GR BOT IN",{"$f":"VLOOKUP(A1,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":13},44]
["ADMIRE (T) WG70 60X75GR BOT IN",{"$f":"VLOOKUP(A2,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":15},29]
["ALANTO (T) SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A3,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":29},93]
["ALANTO (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A4,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":30},38]
["ALIETTE WP80 40X100GR BAG IN",{"$f":"VLOOKUP(A5,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":35},0]
["AMBITION 20X500ML BOT IN",{"$f":"VLOOKUP(A6,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":40},6]
["AMBITION 40X250ML BOT IN",{"$f":"VLOOKUP(A7,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":41},20]
["ANTRACOL (T) WP70 10X1KG BAG IN",{"$f":"VLOOKUP(A8,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":42},8]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A9,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":43},65]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A10,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":44},195]
["ANTRACOL (T) WP70 50X100GR BAG IN",{"$f":"VLOOKUP(A11,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":45},19]
["BELT EXPERT SC480 50X100ML BOT IN",{"$f":"VLOOKUP(A12,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":111},23]
["CONFIDOR (T) SL200 100X50ML BOT IN",{"$f":"VLOOKUP(A13,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":112},19]
["CONFIDOR (T) SL200 20X250ML BOT IN",{"$f":"VLOOKUP(A14,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":114},0]
["CONFIDOR (T) SL200 20X500ML BOT IN",{"$f":"VLOOKUP(A15,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":115},0]
["CONFIDOR (T) SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A16,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":116},79]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",{"$f":"VLOOKUP(A17,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":118},10]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",{"$f":"VLOOKUP(A18,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":120},37]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",{"$f":"VLOOKUP(A19,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":121},39]
["COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",{"$f":"VLOOKUP(A20,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":122},0]
["COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",{"$f":"VLOOKUP(A21,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":123},0]
["FAME (T) SC480 10X(20X10ML) BOT IN",{"$f":"VLOOKUP(A22,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":144},43]
["FAME (T) SC480 20X100ML BOT IN",{"$f":"VLOOKUP(A23,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":145},18]
["FAME (T) SC480 40X50ML BOT IN",{"$f":"VLOOKUP(A24,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":146},36]
["FENOS QUICK SC150 40X250ML BOT IN",{"$f":"VLOOKUP(A25,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":151},0]
["FENOS QUICK SC150 50X100ML BOT IN",{"$f":"VLOOKUP(A26,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":152},0]
["FOLICUR (T) EC250 40X250ML BOT IN",{"$f":"VLOOKUP(A27,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":164},0]
["FOLICUR (T) EC250 50X100ML BOT IN",{"$f":"VLOOKUP(A28,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":165},16]
["FOOST WP50 20X250G BAG IN",{"$f":"VLOOKUP(A29,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":175},66]
["FOOST WP50 24X500G BAG IN",{"$f":"VLOOKUP(A30,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":177},64]
["GAUCHO FS600 100X50ML BOT IN",{"$f":"VLOOKUP(A31,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":179},88]
["GAUCHO FS600 40X250ML BOT IN",{"$f":"VLOOKUP(A32,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":181},0]
["GLAMORE WG80 20X100GR BOT IN",{"$f":"VLOOKUP(A33,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":186},0]
["GLAMORE WG80 40X50GR BOT IN",{"$f":"VLOOKUP(A34,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":189},49]
["INFINITO SC687 5 20X500ML BOT IN",{"$f":"VLOOKUP(A35,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":195},0]
["INFINITO SC687 5 50X100ML BOT IN",{"$f":"VLOOKUP(A36,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":197},0]
["JUMP WG80 160X(10X2GR) BAG IN",{"$f":"VLOOKUP(A37,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":199},0]
["LARVIN (T) WP75 20X250GR BAG IN",{"$f":"VLOOKUP(A38,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":205},46]
["LARVIN (T) WP75 20X500GR BAG IN",{"$f":"VLOOKUP(A39,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":206},44]
["LARVIN (T) WP75 40X100GR BAG IN",{"$f":"VLOOKUP(A40,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":207},29]
["LAUDIS SC630 10X57.5ML BOT IN",{"$f":"VLOOKUP(A41,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":210},0]
["LAUDIS SC630 3X230ML BOT IN",{"$f":"VLOOKUP(A42,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":211},2]
["LAUDIS SC630 8X115ML BOT IN",{"$f":"VLOOKUP(A43,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":212},4]
["LESENTA WG80 100X40GR BAG IN",{"$f":"VLOOKUP(A44,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":215},69]
["LESENTA WG80 50X100GR BAG IN",{"$f":"VLOOKUP(A45,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":219},47]
["LUNA EXPERIENCE SC400 10X1L BOT IN",{"$f":"VLOOKUP(A46,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":223},0]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A47,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":225},71]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",{"$f":"VLOOKUP(A48,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":226},88]
["MOVENTO ENERGY SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A49,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":273},105]
["MOVENTO ENERGY SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A50,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":274},119]
["NATIVO WG75 100X50GR BAG IN",{"$f":"VLOOKUP(A51,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":289},-18]
["NATIVO WG75 20X(10X10GR) BAG IN",{"$f":"VLOOKUP(A52,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":291},147]
["NATIVO WG75 40X250GR BAG IN",{"$f":"VLOOKUP(A53,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":293},0]
["NATIVO WG75 50X100GR BAG IN",{"$f":"VLOOKUP(A54,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":294},117]
["OBERON (T) SC240 20X500ML BOT IN",{"$f":"VLOOKUP(A55,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":297},32]
["OBERON (T) SC240 40X200ML BOT IN",{"$f":"VLOOKUP(A56,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":299},162]
["OBERON (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A57,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":300},164]
["PLANOFIX SL4 5 40X250ML BOT IN",{"$f":"VLOOKUP(A58,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":306},12]
["PLANOFIX SL4 5 50X100ML BOT IN",{"$f":"VLOOKUP(A59,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":307},23]
["REGENT (T) SC50 20X250ML BOT IN",{"$f":"VLOOKUP(A60,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":325},88]
["REGENT (T) SC50 20X500ML BOT IN",{"$f":"VLOOKUP(A61,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":326},82]
["REGENT (T) SC50 50X100ML BOT IN",{"$f":"VLOOKUP(A62,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":327},0]
["REGENT GOLD SC200 40X250ML BOT IN",{"$f":"VLOOKUP(A63,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":331},42]
["REGENT GOLD SC200 50X100ML BOT IN",{"$f":"VLOOKUP(A64,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":332},24]
["REGENT GR0 3 20X1KG BAG IN",{"$f":"VLOOKUP(A65,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":335},828]
["REGENT GR0 3 4X5KG BAG IN",{"$f":"VLOOKUP(A66,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":336},141]
["REGENT ULTRA GR0 6 5X4KG BAG IN",{"$f":"VLOOKUP(A67,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":339},36]
["SECTIN WG60 50X100GR BAG IN",{"$f":"VLOOKUP(A68,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":346},74]
["SIVANTO PRIME SL200 40X250ML BOT IN",{"$f":"VLOOKUP(A69,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":361},63]
["SIVANTO PRIME SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A70,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":362},0]
["SOLOMON OD300 10X1L BOT IN",{"$f":"VLOOKUP(A71,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":365},1]
["SOLOMON OD300 20X500ML BOT IN",{"$f":"VLOOKUP(A72,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":366},25]
["SOLOMON OD300 40X250ML BOT IN",{"$f":"VLOOKUP(A73,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":368},47]
["SOLOMON OD300 50X100ML BOT IN",{"$f":"VLOOKUP(A74,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":370},115]
["SURPASS SUPERB BG2 20X450G BAG IN",{"$f":"VLOOKUP(A75,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":394},0]
["TOPSTAR (T) WP80 10X(10X35GR) BOX IN",{"$f":"VLOOKUP(A76,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":395},-166]
["VELUM PRIME SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A77,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":401},0]
["C DK DKC8171 4.5KG IN",{"$f":"VLOOKUP(A78,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":941},0]
["DECIS EC101-2 100X50ML BOT IN",{"$f":"VLOOKUP(A79,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":927},0]
["REGENT (T) SC50 10X1L BOT IN",{"$f":"VLOOKUP(A80,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":324},12]
["ADMIRE (T) WG70 30X150GR BOT IN",{"$f":"VLOOKUP(A81,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":14},0]
["AMBITION 10X1L BOT IN",{"$f":"VLOOKUP(A82,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":39},0]
["C DK DKC9081 4KG IN",{"$f":"VLOOKUP(A83,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":945},0]
["C DK DKC9120 4KG IN",{"$f":"VLOOKUP(A84,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":952},0]
["CONFIDOR (T) SL200 10X1L BOT IN",{"$f":"VLOOKUP(A85,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":113},0]
["LESENTA WG80 20X250GR BAG IN",{"$f":"VLOOKUP(A86,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":217},0]
["SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",{"$f":"VLOOKUP(A87,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":391},0]

{"sheet":"Reco","index":7,"n_rows":91,"n_cols":29,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -01-Apr-2020 TO 31-Mar-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2020 TO 31-Mar-2021",null,null,null,null,null,null,null,null,"Difference (+/-)"]
[]
["DEALER CODE","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG","Opening Stock Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustments Qty","CLSG","Remark"]
["ADMIRE (T) WG70 150X30GR BOT IN",44,1050,150,874,8,0,0,0,78,44,900,0,866,0,0,0,0,78,0,150,150,8,8,0,0,0,0,"Ok"]
["ADMIRE (T) WG70 60X75GR BOT IN",29,480,0,454,26,0,0,0,81,29,480,0,428,0,0,0,0,81,0,0,0,26,26,0,0,0,0,"Ok"]
["ALANTO (T) SC240 40X250ML BOT IN",93,40,0,53,0,0,0,0,80,93,40,0,53,0,0,0,0,80,0,0,0,0,0,0,0,0,0,"Ok"]
["ALANTO (T) SC240 50X100ML BOT IN",38,0,0,37,0,0,0,0,1,38,0,0,37,0,0,0,0,1,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 40X100GR BAG IN",0,80,0,78,8,0,0,0,10,0,80,0,70,0,0,0,0,10,0,0,0,8,8,0,0,0,0,"Ok"]
["AMBITION 20X500ML BOT IN",6,60,0,51,0,0,0,0,15,6,60,0,51,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 40X250ML BOT IN",20,80,0,75,8,0,0,0,33,20,80,0,67,0,0,0,0,33,0,0,0,8,8,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",8,490,0,450,10,0,0,0,58,8,490,0,440,0,0,0,0,58,0,0,0,10,10,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",65,1960,0,1989,0,0,0,0,36,65,1960,0,1989,0,0,0,0,36,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",195,4800,0,5006,8,0,0,0,-3,195,4800,0,4998,0,0,0,0,-3,0,0,0,8,8,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 50X100GR BAG IN",19,1350,0,1309,54,0,0,0,114,19,1350,0,1255,0,0,0,0,114,0,0,0,54,54,0,0,0,0,"Ok"]
["BELT EXPERT SC480 50X100ML BOT IN",23,350,100,290,63,0,0,0,46,23,250,0,227,0,0,0,0,46,0,100,100,63,63,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 100X50ML BOT IN",19,500,100,334,80,0,0,0,165,19,400,0,254,0,0,0,0,165,0,100,100,80,80,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X250ML BOT IN",0,580,80,512,27,0,0,0,15,0,500,0,485,0,0,0,0,15,0,80,80,27,27,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X500ML BOT IN",0,120,80,40,0,0,0,0,0,0,40,0,40,0,0,0,0,0,0,80,80,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 50X100ML BOT IN",79,1300,50,1320,3,0,0,0,12,79,1250,0,1317,0,0,0,0,12,0,50,50,3,3,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",10,80,20,60,0,0,0,0,10,10,60,0,60,0,0,0,0,10,0,20,20,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",37,1150,50,1114,9,0,0,0,32,37,1100,0,1105,0,0,0,0,32,0,50,50,9,9,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",39,1000,50,986,0,0,0,0,3,39,950,0,986,0,0,0,0,3,0,50,50,0,0,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,60,0,60,20,0,0,0,20,0,60,0,40,0,0,0,0,20,0,0,0,20,20,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",0,80,0,80,45,0,0,0,45,0,80,0,35,0,0,0,0,45,0,0,0,45,45,0,0,0,0,"Ok"]
["FAME (T) SC480 10X(20X10ML) BOT IN",43,1000,200,828,42,0,0,0,57,43,800,0,786,0,0,0,0,57,0,200,200,42,42,0,0,0,0,"Ok"]
["FAME (T) SC480 20X100ML BOT IN",18,180,20,179,10,0,0,0,9,18,160,0,169,0,0,0,0,9,0,20,20,10,10,0,0,0,0,"Ok"]
["FAME (T) SC480 40X50ML BOT IN",36,640,0,649,41,0,0,0,68,36,640,0,608,0,0,0,0,68,0,0,0,41,41,0,0,0,0,"Ok"]
["FENOS QUICK SC150 40X250ML BOT IN",0,80,0,74,0,0,0,0,6,0,80,0,74,0,0,0,0,6,0,0,0,0,0,0,0,0,0,"Ok"]
["FENOS QUICK SC150 50X100ML BOT IN",0,100,0,95,0,0,0,0,5,0,100,0,95,0,0,0,0,5,0,0,0,0,0,0,0,0,0,"Ok"]
["FOLICUR (T) EC250 40X250ML BOT IN",0,320,0,286,16,0,0,0,50,0,320,0,270,0,0,0,0,50,0,0,0,16,16,0,0,0,0,"Ok"]
["FOLICUR (T) EC250 50X100ML BOT IN",16,300,0,301,21,0,0,0,36,16,300,0,280,0,0,0,0,36,0,0,0,21,21,0,0,0,0,"Ok"]
["FOOST WP50 20X250G BAG IN",66,1080,20,1062,5,0,0,0,69,66,1060,0,1057,0,0,0,0,69,0,20,20,5,5,0,0,0,0,"Ok"]
["FOOST WP50 24X500G BAG IN",64,10536,2472,8193,110,0,0,0,45,64,8064,0,8083,0,0,0,0,45,0,2472,2472,110,110,0,0,0,0,"Ok"]
["GAUCHO FS600 100X50ML BOT IN",88,0,0,0,0,0,0,0,88,88,0,0,0,0,0,0,0,88,0,0,0,0,0,0,0,0,0,"Ok"]
["GAUCHO FS600 40X250ML BOT IN",0,40,0,35,10,0,0,0,15,0,40,0,25,0,0,0,0,15,0,0,0,10,10,0,0,0,0,"Ok"]
["GLAMORE WG80 20X100GR BOT IN",0,20,0,10,0,0,0,0,10,0,20,0,10,0,0,0,0,10,0,0,0,0,0,0,0,0,0,"Ok"]
["GLAMORE WG80 40X50GR BOT IN",49,40,0,89,37,0,0,0,37,49,40,0,52,0,0,0,0,37,0,0,0,37,37,0,0,0,0,"Ok"]
["INFINITO SC687 5 20X500ML BOT IN",0,20,0,20,0,0,0,0,0,0,20,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["INFINITO SC687 5 50X100ML BOT IN",0,150,50,75,10,0,0,0,35,0,100,0,65,0,0,0,0,35,0,50,50,10,10,0,0,0,0,"Ok"]
["JUMP WG80 160X(10X2GR) BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X250GR BAG IN",46,140,0,161,17,0,0,0,42,46,140,0,144,0,0,0,0,42,0,0,0,17,17,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X500GR BAG IN",44,0,0,2,0,0,0,0,42,44,0,0,2,0,0,0,0,42,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 40X100GR BAG IN",29,0,0,29,0,0,0,0,0,29,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 10X57.5ML BOT IN",0,1910,550,1353,10,0,0,0,17,0,1360,0,1343,0,0,0,0,17,0,550,550,10,10,0,0,0,0,"Ok"]
["LAUDIS SC630 3X230ML BOT IN",2,1362,252,1205,41,0,0,0,-52,2,1110,0,1164,0,0,0,0,-52,0,252,252,41,41,0,0,0,0,"Ok"]
["LAUDIS SC630 8X115ML BOT IN",4,6040,760,5295,65,0,0,0,54,4,5280,0,5230,0,0,0,0,54,0,760,760,65,65,0,0,0,0,"Ok"]
["LESENTA WG80 100X40GR BAG IN",69,100,0,143,0,0,0,0,26,69,100,0,143,0,0,0,0,26,0,0,0,0,0,0,0,0,0,"Ok"]
["LESENTA WG80 50X100GR BAG IN",47,50,0,77,0,0,0,0,20,47,50,0,77,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 10X1L BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",71,160,40,165,26,0,0,0,52,71,120,0,139,0,0,0,0,52,0,40,40,26,26,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",88,100,50,92,28,0,0,0,74,88,50,0,64,0,0,0,0,74,0,50,50,28,28,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 40X250ML BOT IN",105,1760,280,1919,461,0,0,0,127,105,1480,0,1458,0,0,0,0,127,0,280,280,461,461,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 50X100ML BOT IN",119,650,100,607,175,0,0,0,237,119,550,0,432,0,0,0,0,237,0,100,100,175,175,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR BAG IN",-18,1100,0,955,186,0,0,0,313,-18,1100,0,769,0,0,0,0,313,0,0,0,186,186,0,0,0,0,"Ok"]
["NATIVO WG75 20X(10X10GR) BAG IN",147,6800,1000,5432,0,0,0,0,515,147,5800,0,5432,0,0,0,0,515,0,1000,1000,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",0,120,40,81,13,0,0,0,12,0,80,0,68,0,0,0,0,12,0,40,40,13,13,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",117,1450,0,1444,51,0,0,0,174,117,1450,0,1393,0,0,0,0,174,0,0,0,51,51,0,0,0,0,"Ok"]
["OBERON (T) SC240 20X500ML BOT IN",32,480,20,492,64,0,0,0,64,32,460,0,428,0,0,0,0,64,0,20,20,64,64,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",162,6280,80,6383,106,0,0,0,85,162,6200,0,6277,0,0,0,0,85,0,80,80,106,106,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",164,6100,1150,5294,294,0,0,0,114,164,4950,0,5000,0,0,0,0,114,0,1150,1150,294,294,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 40X250ML BOT IN",12,120,0,129,0,0,0,0,3,12,120,0,129,0,0,0,0,3,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",23,1200,0,1154,6,0,0,0,75,23,1200,0,1148,0,0,0,0,75,0,0,0,6,6,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X250ML BOT IN",88,2860,160,2734,55,0,0,0,109,88,2700,0,2679,0,0,0,0,109,0,160,160,55,55,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X500ML BOT IN",82,3040,100,2980,26,0,0,0,68,82,2940,0,2954,0,0,0,0,68,0,100,100,26,26,0,0,0,0,"Ok"]
["REGENT (T) SC50 50X100ML BOT IN",0,600,350,235,0,0,0,0,15,0,250,0,235,0,0,0,0,15,0,350,350,0,0,0,0,0,0,"Ok"]
["REGENT GOLD SC200 40X250ML BOT IN",42,120,0,155,30,0,0,0,37,42,120,0,125,0,0,0,0,37,0,0,0,30,30,0,0,0,0,"Ok"]
["REGENT GOLD SC200 50X100ML BOT IN",24,200,0,256,39,0,0,0,7,24,200,0,217,0,0,0,0,7,0,0,0,39,39,0,0,0,0,"Ok"]
["REGENT GR0 3 20X1KG BAG IN",828,3400,0,4036,0,0,0,0,192,828,3400,0,4036,0,0,0,0,192,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT GR0 3 4X5KG BAG IN",141,4220,0,4155,0,0,0,0,206,141,4220,0,4155,0,0,0,0,206,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT ULTRA GR0 6 5X4KG BAG IN",36,75,0,124,20,0,0,0,7,36,75,0,104,0,0,0,0,7,0,0,0,20,20,0,0,0,0,"Ok"]
["SECTIN WG60 50X100GR BAG IN",74,0,0,35,12,0,0,0,51,74,0,0,23,0,0,0,0,51,0,0,0,12,12,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 40X250ML BOT IN",63,80,0,149,11,0,0,0,5,63,80,0,138,0,0,0,0,5,0,0,0,11,11,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 50X100ML BOT IN",0,50,0,50,10,0,0,0,10,0,50,0,40,0,0,0,0,10,0,0,0,10,10,0,0,0,0,"Ok"]
["SOLOMON OD300 10X1L BOT IN",1,40,0,32,6,0,0,0,15,1,40,0,26,0,0,0,0,15,0,0,0,6,6,0,0,0,0,"Ok"]
["SOLOMON OD300 20X500ML BOT IN",25,560,140,445,64,0,0,0,64,25,420,0,381,0,0,0,0,64,0,140,140,64,64,0,0,0,0,"Ok"]
["SOLOMON OD300 40X250ML BOT IN",47,4840,80,4843,168,0,0,0,132,47,4760,0,4675,0,0,0,0,132,0,80,80,168,168,0,0,0,0,"Ok"]
["SOLOMON OD300 50X100ML BOT IN",115,2850,100,2926,204,0,0,0,143,115,2750,0,2722,0,0,0,0,143,0,100,100,204,204,0,0,0,0,"Ok"]
["SURPASS SUPERB BG2 20X450G BAG IN",0,500,334,420,254,0,0,0,0,0,166,0,166,0,0,0,0,0,0,334,334,254,254,0,0,0,0,"Ok"]
["TOPSTAR (T) WP80 10X(10X35GR) BOX IN",-166,0,0,34,0,0,0,0,-200,-166,0,0,34,0,0,0,0,-200,0,0,0,0,0,0,0,0,0,"Ok"]
["VELUM PRIME SC400 40X250ML BOT IN",0,40,0,45,11,0,0,0,6,0,40,0,34,0,0,0,0,6,0,0,0,11,11,0,0,0,0,"Ok"]
["C DK DKC8171 4.5KG IN",0,282,98,249,65,0,0,0,0,0,184,0,184,0,0,0,0,0,0,98,98,65,65,0,0,0,0,"Ok"]
["DECIS EC101-2 100X50ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 10X1L BOT IN",12,850,150,703,11,0,0,0,20,12,700,0,692,0,0,0,0,20,0,150,150,11,11,0,0,0,0,"Ok"]
["ADMIRE (T) WG70 30X150GR BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 10X1L BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["C DK DKC9081 4KG IN",0,0,0,0,0,0,0,0,0,0,252,0,252,0,0,0,0,0,0,-252,0,-252,0,0,0,0,0,"Ok"]
["C DK DKC9120 4KG IN",0,0,0,0,0,0,0,0,0,0,2,0,2,0,0,0,0,0,0,-2,0,-2,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 10X1L BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LESENTA WG80 20X250GR BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["Total",3779,90645,9276,84086,3200,0,0,0,4262,3779,81623,0,81140,0,0,0,0,4262,0,9022,9276,2946,3200,0,0,0,0]