{"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,"Bharat Ksk"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Jul-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Bharat Krushi Seva Kendra 2021-22"]
["26 Akshardham, Near Old Grampanchayat,"]
["Jarimari Nagar, Vikramgad"]
["Dist- Palghar"]
["BAYER"]
["Stock Category Summary"]
["1-Apr-2021 to 31-Jul-2021"]
["","BAYER"]
["","Bharat Krushi Seva Kendra 2021-22"]
["Particulars","1-Apr-2021 to 31-Jul-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["Admire 2gm (Bayer)",952,0,925,27]
["Admire 30gm (Bayer)",10,0,10,0]
["Aliete 250gm (Bayer)",14,0,0,14]
["Aliette 100gm (Bayer)",100,0,1,99]
["Aliette 500gm (Bayer)",0,0,0,0]
["Ambition 1lit (Bayer)",0,0,0,0]
["Ambition 250ml (Bayer)",51,0,10,41]
["Ambition 500ml (Bayer)",0,40,0,40]
["Antracol 100gm (Bayer)",725,0,25,700]
["Antracol 250gm (Bayer)",0,80,0,80]
["Antracol 500gm (Bayer)",0,0,0,0]
["Arize 6129 Gold 1kg (Bayer S)",0,4020,3277,743]
["Arize 6444 Gold 1kg (Bayer S)",0,10020,9914,106]
["Arize Tej Gold 1kg (Bayer S)",0,510,404,106]
["Bittergourd Amanthree 500sds(Bayer)",0,0,2,-2]
["Bounos 500ml (Bayer)",0,0,0,0]
["Confidor 100ml (Bayer)",0,0,35,-35]
["Confidor 1lit (Bayer)",0,0,0,0]
["Confidor 250ml (Bayer)",0,0,0,0]
["Confidor 500ml (Bayer)",0,0,0,0]
["Confidor 50ml (Bayer)",40,0,60,-20]
["Confidor Super 100ml (Bayer)",0,0,0,0]
["Confidor Super 1lit (Bayer)",0,0,0,0]
["Confidor Super 500ml (Bayer)",0,0,0,0]
["Confidor Super 50ml (Bayer)",0,0,0,0]
["Decis 100 100ml (Bayer)",0,0,0,0]
["Decis 2.8 100ml (Bayer)",0,0,15,-15]
["Decis 2.8 1lit (Bayer)",3,0,0,3]
["Decis 2.8 500ml (Bayer)",20,0,12,8]
["Ethrel 100ml (Bayer)",0,100,98,2]
["Fame 10ml (Bayer)",307,0,5,302]
["Fame 50ml (Bayer)",0,0,0,0]
["Folicur 250ml (Bayer)",0,0,0,0]
["Infinito 100ml (Bayer)",148,0,0,148]
["Infinito 500ml (Bayer)",0,0,0,0]
["Jump 2gm (Bayer)",1420,0,642,778]
["Jump 40gm (Bayer P)",65,0,65,0]
["Luna Experience 100ml (Bayer)",29,0,30,-1]
["Luna Experience 1lit (Bayer)",0,0,0,0]
["Luna Experience 250ml (Bayer)",0,40,0,40]
["Melody Deo 100gm (Bayer)",77,0,0,77]
["Melody Duo 400gm (Bayer)",0,0,0,0]
["Movento Energy 100ml (Bayer)",24,0,0,24]
["Movento Energy 250ml (Bayer)",0,40,30,10]
["Natio 100gm (Bayer)",150,0,0,150]
["Natio 10gm (Bayer)",140,0,0,140]
["Natio 250gm (Bayer)",16,0,0,16]
["Natio 500gm (Bayer)",0,0,0,0]
["Natio 50ml (Bayer)",0,0,1,-1]
["Oberon 100ml (Bayer)",43,0,58,-15]
["Oberon 200ml (Bayer)",30,80,26,84]
["Planofix 100ml (Bayer)",50,100,65,85]
["Regent 100ml (Bayer)",45,0,41,4]
["Regent 250ml (Bayer)",15,0,15,0]
["Regent Gold 100ml (Bayer)",0,0,0,0]
["Regent Gold 250ml (Bayer)",0,0,0,0]
["Regent Gold 500ml (Bayer)",0,0,0,0]
["Sectin 100gm (Bayer)",50,0,0,50]
["Soloman 1lit (Bayer)",0,0,0,0]
["Solomon 100ml (Bayer)",0,0,0,0]
["Solomon 250ml (Bayer)",0,0,0,0]
["Velum Prime 500ml (Bayer)",0,0,0,0]
["Grand Total",{"$f":"SUM(B13:B74)","v":4524},15030,15766,3788]

{"sheet":"Dealer Report working","index":2,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["Admire 2gm (Bayer)",952,0,925,27,"ADMIRE WG70 125X(8X2GR) BAG IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["Admire 30gm (Bayer)",10,0,10,0,"ADMIRE (T) WG70 150X30GR BOT IN",null,null,null,"ADMIRE (T) WG70 150X30GR BOT IN",10,0,10,0]
["Aliete 250gm (Bayer)",14,0,0,14,"ALIETTE WP80 20X250GR BAG IN",null,null,null,"ADMIRE WG70 125X(8X2GR) BAG IN",952,0,925,27]
["Aliette 100gm (Bayer)",100,0,1,99,"ALIETTE WP80 40X100GR BAG IN",null,null,null,"ALIETTE WP80 20X250GR BAG IN",14,0,0,14]
["Aliette 500gm (Bayer)",0,0,0,0,"ALIETTE WP80 20X500GR BAG IN",null,null,null,"ALIETTE WP80 20X500GR BAG IN",0,0,0,0]
["Ambition 1lit (Bayer)",0,0,0,0,"AMBITION 10X1L BOT IN",null,null,null,"ALIETTE WP80 40X100GR BAG IN",100,0,1,99]
["Ambition 250ml (Bayer)",51,0,10,41,"AMBITION 40X250ML BOT IN",null,null,null,"AMBITION 10X1L BOT IN",0,0,0,0]
["Ambition 500ml (Bayer)",0,40,0,40,"AMBITION 20X500ML BOT IN",null,null,null,"AMBITION 20X500ML BOT IN",0,40,0,40]
["Antracol 100gm (Bayer)",725,0,25,700,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,"AMBITION 40X250ML BOT IN",51,0,10,41]
["Antracol 250gm (Bayer)",0,80,0,80,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",0,0,0,0]
["Antracol 500gm (Bayer)",0,0,0,0,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",0,80,0,80]
["Arize 6129 Gold 1kg (Bayer S)",0,4020,3277,743,"ARIZE 6129 GOLD LOC 30X1KG BAG IN",null,null,null,"ANTRACOL (T) WP70 50X100GR BAG IN",725,0,25,700]
["Arize 6444 Gold 1kg (Bayer S)",0,10020,9914,106,"ARIZE 6444 GOLD LOC 30X1 BAG IN",null,null,null,"ARIZE 6129 GOLD LOC 30X1KG BAG IN",0,4020,3277,743]
["Arize Tej Gold 1kg (Bayer S)",0,510,404,106,"ARIZE TEJ GOLD LOC 30X1KG BAG IN",null,null,null,"ARIZE 6444 GOLD LOC 30X1 BAG IN",0,10020,9914,106]
["Bittergourd Amanthree 500sds(Bayer)",0,0,2,-2,"DISCOUNTINUE PRODUCT",null,null,null,"ARIZE TEJ GOLD LOC 30X1KG BAG IN",0,510,404,106]
["Bounos 500ml (Bayer)",0,0,0,0,"BUONOS SC430 20X500ML BOT IN",null,null,null,"BUONOS SC430 20X500ML BOT IN",0,0,0,0]
["Confidor 100ml (Bayer)",0,0,35,-35,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,"CONFIDOR (T) SL200 100X50ML BOT IN",40,0,60,-20]
["Confidor 1lit (Bayer)",0,0,0,0,"CONFIDOR (T) SL200 10X1L BOT IN",null,null,null,"CONFIDOR (T) SL200 10X1L BOT IN",0,0,0,0]
["Confidor 250ml (Bayer)",0,0,0,0,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN",0,0,0,0]
["Confidor 500ml (Bayer)",0,0,0,0,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X500ML BOT IN",0,0,0,0]
["Confidor 50ml (Bayer)",40,0,60,-20,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN",0,0,35,-35]
["Confidor Super 100ml (Bayer)",0,0,0,0,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 10X1L BOT IN",0,0,0,0]
["Confidor Super 1lit (Bayer)",0,0,0,0,"CONFIDOR SUPER (T) SC350 10X1L BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",0,0,0,0]
["Confidor Super 500ml (Bayer)",0,0,0,0,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",0,0,0,0]
["Confidor Super 50ml (Bayer)",0,0,0,0,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",0,0,0,0]
["Decis 100 100ml (Bayer)",0,0,0,0,"DECIS EC101-2 50X100ML BOX IN",null,null,null,"DECIS EC 28 10X1L BOT IN",3,0,0,3]
["Decis 2.8 100ml (Bayer)",0,0,15,-15,"DECIS EC 28 50X100ML BOT IN",null,null,null,"DECIS EC 28 20X500ML BOT IN",20,0,12,8]
["Decis 2.8 1lit (Bayer)",3,0,0,3,"DECIS EC 28 10X1L BOT IN",null,null,null,"DECIS EC 28 50X100ML BOT IN",0,0,15,-15]
["Decis 2.8 500ml (Bayer)",20,0,12,8,"DECIS EC 28 20X500ML BOT IN",null,null,null,"DECIS EC101-2 50X100ML BOX IN",0,0,0,0]
["Ethrel 100ml (Bayer)",0,100,98,2,"ETHREL SL39 50X100ML BOT IN",null,null,null,"DISCOUNTINUE PRODUCT",0,0,2,-2]
["Fame 10ml (Bayer)",307,0,5,302,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,"ETHREL SL39 50X100ML BOT IN",0,100,98,2]
["Fame 50ml (Bayer)",0,0,0,0,"FAME (T) SC480 40X50ML BOT IN",null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN",307,0,5,302]
["Folicur 250ml (Bayer)",0,0,0,0,"FOLICUR (T) EC250 40X250ML BOT IN",null,null,null,"FAME (T) SC480 40X50ML BOT IN",0,0,0,0]
["Infinito 100ml (Bayer)",148,0,0,148,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,"FOLICUR (T) EC250 40X250ML BOT IN",0,0,0,0]
["Infinito 500ml (Bayer)",0,0,0,0,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,"INFINITO SC687 5 20X500ML BOT IN",0,0,0,0]
["Jump 2gm (Bayer)",1420,0,642,778,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,"INFINITO SC687 5 50X100ML BOT IN",148,0,0,148]
["Jump 40gm (Bayer P)",65,0,65,0,"JUMP WG80 80X40GR BAG IN",null,null,null,"JUMP WG80 160X(10X2GR) BAG IN",1420,0,642,778]
["Luna Experience 100ml (Bayer)",29,0,30,-1,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,"JUMP WG80 80X40GR BAG IN",65,0,65,0]
["Luna Experience 1lit (Bayer)",0,0,0,0,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,"LUNA EXPERIENCE SC400 10X1L BOT IN",0,0,0,0]
["Luna Experience 250ml (Bayer)",0,40,0,40,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",0,40,0,40]
["Melody Deo 100gm (Bayer)",77,0,0,77,"MELODY DUO WP66 8 50X100GR BAG IN",null,null,null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",29,0,30,-1]
["Melody Duo 400gm (Bayer)",0,0,0,0,"MELODY DUO WP66 8 10X400GR BAG IN",null,null,null,"MELODY DUO WP66 8 10X400GR BAG IN",0,0,0,0]
["Movento Energy 100ml (Bayer)",24,0,0,24,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,"MELODY DUO WP66 8 50X100GR BAG IN",77,0,0,77]
["Movento Energy 250ml (Bayer)",0,40,30,10,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",0,40,30,10]
["Natio 100gm (Bayer)",150,0,0,150,"NATIVO WG75 50X100GR BAG IN",null,null,null,"MOVENTO ENERGY SC240 50X100ML BOT IN",24,0,0,24]
["Natio 10gm (Bayer)",140,0,0,140,"NATIVO WG75 10X1KG BAG IN",null,null,null,"NATIVO WG75 100X50GR BAG IN",0,0,1,-1]
["Natio 250gm (Bayer)",16,0,0,16,"NATIVO WG75 40X250GR BAG IN",null,null,null,"NATIVO WG75 10X1KG BAG IN",140,0,0,140]
["Natio 500gm (Bayer)",0,0,0,0,"NATIVO WG75 20X500GR BAG IN",null,null,null,"NATIVO WG75 20X500GR BAG IN",0,0,0,0]
["Natio 50ml (Bayer)",0,0,1,-1,"NATIVO WG75 100X50GR BAG IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",16,0,0,16]
["Oberon 100ml (Bayer)",43,0,58,-15,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",150,0,0,150]
["Oberon 200ml (Bayer)",30,80,26,84,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",30,80,26,84]
["Planofix 100ml (Bayer)",50,100,65,85,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN",43,0,58,-15]
["Regent 100ml (Bayer)",45,0,41,4,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",50,100,65,85]
["Regent 250ml (Bayer)",15,0,15,0,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,"REGENT (T) SC50 20X250ML BOT IN",15,0,15,0]
["Regent Gold 100ml (Bayer)",0,0,0,0,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 50X100ML BOT IN",45,0,41,4]
["Regent Gold 250ml (Bayer)",0,0,0,0,"REGENT GOLD SC200 40X250ML BOT IN",null,null,null,"REGENT GOLD SC200 20X500ML BOT IN",0,0,0,0]
["Regent Gold 500ml (Bayer)",0,0,0,0,"REGENT GOLD SC200 20X500ML BOT IN",null,null,null,"REGENT GOLD SC200 40X250ML BOT IN",0,0,0,0]
["Sectin 100gm (Bayer)",50,0,0,50,"SECTIN WG60 50X100GR BAG IN",null,null,null,"REGENT GOLD SC200 50X100ML BOT IN",0,0,0,0]
["Soloman 1lit (Bayer)",0,0,0,0,"SOLOMON OD300 10X1L BOT IN",null,null,null,"SECTIN WG60 50X100GR BAG IN",50,0,0,50]
["Solomon 100ml (Bayer)",0,0,0,0,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"SOLOMON OD300 10X1L BOT IN",0,0,0,0]
["Solomon 250ml (Bayer)",0,0,0,0,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN",0,0,0,0]
["Velum Prime 500ml (Bayer)",0,0,0,0,"VELUM PRIME SC400 20X500ML BOT IN",null,null,null,"SOLOMON OD300 50X100ML BOT IN",0,0,0,0]
[null,null,null,null,null,null,null,null,null,"VELUM PRIME SC400 20X500ML BOT IN",0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Grand Total",4524,15030,15766,3788]

{"sheet":"Master","index":3,"n_rows":63,"n_cols":2,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["Admire 2gm (Bayer)","ADMIRE WG70 125X(8X2GR) BAG IN"]
["Admire 30gm (Bayer)","ADMIRE (T) WG70 150X30GR BOT IN"]
["Aliete 250gm (Bayer)","ALIETTE WP80 20X250GR BAG IN"]
["Aliette 100gm (Bayer)","ALIETTE WP80 40X100GR BAG IN"]
["Aliette 500gm (Bayer)","ALIETTE WP80 20X500GR BAG IN"]
["Ambition 1lit (Bayer)","AMBITION 10X1L BOT IN"]
["Ambition 250ml (Bayer)","AMBITION 40X250ML BOT IN"]
["Ambition 500ml (Bayer)","AMBITION 20X500ML BOT IN"]
["Antracol 100gm (Bayer)","ANTRACOL (T) WP70 50X100GR BAG IN"]
["Antracol 250gm (Bayer)","ANTRACOL (T) WP70 40X250GR BAG IN"]
["Antracol 500gm (Bayer)","ANTRACOL (T) WP70 20X500GR BAG IN"]
["Arize 6129 Gold 1kg (Bayer S)","ARIZE 6129 GOLD LOC 30X1KG BAG IN"]
["Arize 6444 Gold 1kg (Bayer S)","ARIZE 6444 GOLD LOC 30X1 BAG IN"]
["Arize Tej Gold 1kg (Bayer S)","ARIZE TEJ GOLD LOC 30X1KG BAG IN"]
["Bittergourd Amanthree 500sds(Bayer)","DISCOUNTINUE PRODUCT"]
["Bounos 500ml (Bayer)","BUONOS SC430 20X500ML BOT IN"]
["Confidor 100ml (Bayer)","CONFIDOR (T) SL200 50X100ML BOT IN"]
["Confidor 1lit (Bayer)","CONFIDOR (T) SL200 10X1L BOT IN"]
["Confidor 250ml (Bayer)","CONFIDOR (T) SL200 20X250ML BOT IN"]
["Confidor 500ml (Bayer)","CONFIDOR (T) SL200 20X500ML BOT IN"]
["Confidor 50ml (Bayer)","CONFIDOR (T) SL200 100X50ML BOT IN"]
["Confidor Super 100ml (Bayer)","CONFIDOR SUPER (T) SC350 50X100ML BOT IN"]
["Confidor Super 1lit (Bayer)","CONFIDOR SUPER (T) SC350 10X1L BOT IN"]
["Confidor Super 500ml (Bayer)","CONFIDOR SUPER (T) SC350 20X500ML BOT IN"]
["Confidor Super 50ml (Bayer)","CONFIDOR SUPER (T) SC350 50X50ML BOT IN"]
["Decis 100 100ml (Bayer)","DECIS EC101-2 50X100ML BOX IN"]
["Decis 2.8 100ml (Bayer)","DECIS EC 28 50X100ML BOT IN"]
["Decis 2.8 1lit (Bayer)","DECIS EC 28 10X1L BOT IN"]
["Decis 2.8 500ml (Bayer)","DECIS EC 28 20X500ML BOT IN"]
["Ethrel 100ml (Bayer)","ETHREL SL39 50X100ML BOT IN"]
["Fame 10ml (Bayer)","FAME (T) SC480 10X(20X10ML) BOT IN"]
["Fame 50ml (Bayer)","FAME (T) SC480 40X50ML BOT IN"]
["Folicur 250ml (Bayer)","FOLICUR (T) EC250 40X250ML BOT IN"]
["Infinito 100ml (Bayer)","INFINITO SC687 5 50X100ML BOT IN"]
["Infinito 500ml (Bayer)","INFINITO SC687 5 20X500ML BOT IN"]
["Jump 2gm (Bayer)","JUMP WG80 160X(10X2GR) BAG IN"]
["Jump 40gm (Bayer P)","JUMP WG80 80X40GR BAG IN"]
["Luna Experience 100ml (Bayer)","LUNA EXPERIENCE SC400 50X100ML BOT IN"]
["Luna Experience 1lit (Bayer)","LUNA EXPERIENCE SC400 10X1L BOT IN"]
["Luna Experience 250ml (Bayer)","LUNA EXPERIENCE SC400 40X250ML BOT IN"]
["Melody Deo 100gm (Bayer)","MELODY DUO WP66 8 50X100GR BAG IN"]
["Melody Duo 400gm (Bayer)","MELODY DUO WP66 8 10X400GR BAG IN"]
["Movento Energy 100ml (Bayer)","MOVENTO ENERGY SC240 50X100ML BOT IN"]
["Movento Energy 250ml (Bayer)","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["Natio 100gm (Bayer)","NATIVO WG75 50X100GR BAG IN"]
["Natio 10gm (Bayer)","NATIVO WG75 10X1KG BAG IN"]
["Natio 250gm (Bayer)","NATIVO WG75 40X250GR BAG IN"]
["Natio 500gm (Bayer)","NATIVO WG75 20X500GR BAG IN"]
["Natio 50ml (Bayer)","NATIVO WG75 100X50GR BAG IN"]
["Oberon 100ml (Bayer)","OBERON (T) SC240 50X100ML BOT IN"]
["Oberon 200ml (Bayer)","OBERON (T) SC240 40X200ML BOT IN"]
["Planofix 100ml (Bayer)","PLANOFIX SL4 5 50X100ML BOT IN"]
["Regent 100ml (Bayer)","REGENT (T) SC50 50X100ML BOT IN"]
["Regent 250ml (Bayer)","REGENT (T) SC50 20X250ML BOT IN"]
["Regent Gold 100ml (Bayer)","REGENT GOLD SC200 50X100ML BOT IN"]
["Regent Gold 250ml (Bayer)","REGENT GOLD SC200 40X250ML BOT IN"]
["Regent Gold 500ml (Bayer)","REGENT GOLD SC200 20X500ML BOT IN"]
["Sectin 100gm (Bayer)","SECTIN WG60 50X100GR BAG IN"]
["Soloman 1lit (Bayer)","SOLOMON OD300 10X1L BOT IN"]
["Solomon 100ml (Bayer)","SOLOMON OD300 50X100ML BOT IN"]
["Solomon 250ml (Bayer)","SOLOMON OD300 40X250ML BOT IN"]
["Velum Prime 500ml (Bayer)","VELUM PRIME SC400 20X500ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":65,"n_cols":14,"rows_kept":65,"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,10,0,0,10,0,0,0,0,0]
[null,"ADMIRE WG70 125X(8X2GR) BAG IN",null,null,null,952,0,0,925,0,0,0,0,27]
[null,"ALIETTE WP80 20X250GR BAG IN",null,null,null,14,0,0,0,0,0,0,0,14]
[null,"ALIETTE WP80 20X500GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ALIETTE WP80 40X100GR BAG IN",null,null,null,100,0,0,1,0,0,0,0,99]
[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,0,40,0,0,0,0,0,0,40]
[null,"AMBITION 40X250ML BOT IN",null,null,null,51,0,0,10,0,0,0,0,41]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,0,80,0,0,0,0,0,0,80]
[null,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,725,0,0,25,0,0,0,0,700]
[null,"ARIZE 6129 GOLD LOC 30X1KG BAG IN",null,null,null,0,4020,0,3277,0,0,0,0,743]
[null,"ARIZE 6444 GOLD LOC 30X1 BAG IN",null,null,null,0,10020,0,9914,0,0,0,0,106]
[null,"ARIZE TEJ GOLD LOC 30X1KG BAG IN",null,null,null,0,510,0,404,0,0,0,0,106]
[null,"BUONOS SC430 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,40,0,0,60,0,0,0,0,-20]
[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,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,0,0,0,35,0,0,0,0,-35]
[null,"CONFIDOR SUPER (T) SC350 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"DECIS EC 28 10X1L BOT IN",null,null,null,3,0,0,0,0,0,0,0,3]
[null,"DECIS EC 28 20X500ML BOT IN",null,null,null,20,0,0,12,0,0,0,0,8]
[null,"DECIS EC 28 50X100ML BOT IN",null,null,null,0,0,0,15,0,0,0,0,-15]
[null,"DECIS EC101-2 50X100ML BOX IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"DISCOUNTINUE PRODUCT",null,null,null,0,0,0,2,0,0,0,0,-2]
[null,"ETHREL SL39 50X100ML BOT IN",null,null,null,0,100,0,98,0,0,0,0,2]
[null,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,307,0,0,5,0,0,0,0,302]
[null,"FAME (T) SC480 40X50ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FOLICUR (T) EC250 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,148,0,0,0,0,0,0,0,148]
[null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,1420,0,0,642,0,0,0,0,778]
[null,"JUMP WG80 80X40GR BAG IN",null,null,null,65,0,0,65,0,0,0,0,0]
[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,0,40,0,0,0,0,0,0,40]
[null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,29,0,0,30,0,0,0,0,-1]
[null,"MELODY DUO WP66 8 10X400GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"MELODY DUO WP66 8 50X100GR BAG IN",null,null,null,77,0,0,0,0,0,0,0,77]
[null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,0,40,0,30,0,0,0,0,10]
[null,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,24,0,0,0,0,0,0,0,24]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,0,0,0,1,0,0,0,0,-1]
[null,"NATIVO WG75 10X1KG BAG IN",null,null,null,140,0,0,0,0,0,0,0,140]
[null,"NATIVO WG75 20X500GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,16,0,0,0,0,0,0,0,16]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,150,0,0,0,0,0,0,0,150]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,30,80,0,26,0,0,0,0,84]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,43,0,0,58,0,0,0,0,-15]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,50,100,0,65,0,0,0,0,85]
[null,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,15,0,0,15,0,0,0,0,0]
[null,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,45,0,0,41,0,0,0,0,4]
[null,"REGENT GOLD SC200 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT GOLD SC200 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SECTIN WG60 50X100GR BAG IN",null,null,null,50,0,0,0,0,0,0,0,50]
[null,"SOLOMON OD300 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"VELUM PRIME SC400 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Grand Total",null,null,null,4524,15030,0,15766,0,0,0,0,3788]

{"sheet":"Zylem SNS Report","index":5,"n_rows":45,"n_cols":13,"rows_kept":45,"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-2021 TO 31-Jul-2021"]
["Generated on 9/3/2021 9:43:14 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Bharat Ksk,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Bharat Ksk",4192904,"ADMIRE (T) WG70 150X30GR BOT IN",79234988,10,0,0,10,0,0,0,0,0]
["Bharat Ksk",4192904,"ADMIRE WG70 125X(8X2GR) BAG IN",6101665,952,0,0,925,0,0,0,0,27]
["Bharat Ksk",4192904,"ALIETTE WP80 20X250GR BAG IN",3822358,14,0,0,0,0,0,0,0,14]
["Bharat Ksk",4192904,"ALIETTE WP80 40X100GR BAG IN",3822331,100,0,0,1,0,0,0,0,99]
["Bharat Ksk",4192904,"AMBITION 20X500ML BOT IN",86228564,0,40,0,0,0,0,0,0,40]
["Bharat Ksk",4192904,"AMBITION 40X250ML BOT IN",86232308,51,0,0,10,0,0,0,0,41]
["Bharat Ksk",4192904,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,0,80,0,0,0,0,0,0,80]
["Bharat Ksk",4192904,"ANTRACOL (T) WP70 50X100GR BAG IN",6113191,725,0,0,25,0,0,0,0,700]
["Bharat Ksk",4192904,"ARIZE 6129 GOLD LOC 30X1KG BAG IN",80958439,0,4020,0,3939,662,0,0,0,743]
["Bharat Ksk",4192904,"ARIZE TEJ GOLD LOC 30X1KG BAG IN",80887760,0,510,0,433,29,0,0,0,106]
["Bharat Ksk",4192904,"CONFIDOR (T) SL200 100X50ML BOT IN",5708361,40,0,0,60,0,0,0,0,-20]
["Bharat Ksk",4192904,"CONFIDOR (T) SL200 50X100ML BOT IN",5703475,0,0,0,35,0,0,0,0,-35]
["Bharat Ksk",4192904,"DECIS EC 28 10X1L BOT IN",3823303,3,0,0,0,0,0,0,0,3]
["Bharat Ksk",4192904,"DECIS EC 28 20X500ML BOT IN",3823370,20,0,0,12,0,0,0,0,8]
["Bharat Ksk",4192904,"ETHREL SL39 50X100ML BOT IN",4299026,0,100,0,98,0,0,0,0,2]
["Bharat Ksk",4192904,"FAME (T) SC480 10X(20X10ML) BOT IN",79305885,307,0,0,5,0,0,0,0,302]
["Bharat Ksk",4192904,"INFINITO SC687 5 50X100ML BOT IN",79632487,148,0,0,0,0,0,0,0,148]
["Bharat Ksk",4192904,"JUMP WG80 160X(10X2GR) BAG IN",79215304,1420,0,0,642,0,0,0,0,778]
["Bharat Ksk",4192904,"JUMP WG80 80X40GR BAG IN",79267509,65,0,0,65,0,0,0,0,0]
["Bharat Ksk",4192904,"LUNA EXPERIENCE SC400 40X250ML BOT IN",80549652,0,40,0,0,0,0,0,0,40]
["Bharat Ksk",4192904,"LUNA EXPERIENCE SC400 50X100ML BOT IN",80199414,29,0,0,30,0,0,0,0,-1]
["Bharat Ksk",4192904,"MELODY DUO WP66 8 50X100GR BAG IN",5997541,77,0,0,0,0,0,0,0,77]
["Bharat Ksk",4192904,"MOVENTO ENERGY SC240 40X250ML BOT IN",79679505,0,40,0,30,0,0,0,0,10]
["Bharat Ksk",4192904,"MOVENTO ENERGY SC240 50X100ML BOT IN",79722605,24,0,0,0,0,0,0,0,24]
["Bharat Ksk",4192904,"NATIVO WG75 100X50GR BAG IN",80580061,0,0,0,1,0,0,0,0,-1]
["Bharat Ksk",4192904,"NATIVO WG75 10X1KG BAG IN",80525346,140,0,0,0,0,0,0,0,140]
["Bharat Ksk",4192904,"NATIVO WG75 40X250GR BAG IN",79237790,16,0,0,0,0,0,0,0,16]
["Bharat Ksk",4192904,"NATIVO WG75 50X100GR BAG IN",79304102,150,0,0,0,0,0,0,0,150]
["Bharat Ksk",4192904,"OBERON (T) SC240 40X200ML BOT IN",79971362,30,80,0,26,0,0,0,0,84]
["Bharat Ksk",4192904,"OBERON (T) SC240 50X100ML BOT IN",79998538,43,0,0,58,0,0,0,0,-15]
["Bharat Ksk",4192904,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,50,100,0,65,0,0,0,0,85]
["Bharat Ksk",4192904,"REGENT (T) SC50 20X250ML BOT IN",5976951,15,0,0,15,0,0,0,0,0]
["Bharat Ksk",4192904,"REGENT (T) SC50 50X100ML BOT IN",5975343,45,0,0,41,0,0,0,0,4]
["Bharat Ksk",4192904,"SECTIN WG60 50X100GR BAG IN",5950812,50,0,0,0,0,0,0,0,50]
["Bharat Ksk",4192904,"ARIZE 6444 GOLD LOC 30X1 BAG IN",80187408,0,10020,0,9991,77,0,0,0,106]
["Bharat Ksk",4192904,"DECIS EC 28 50X100ML BOT IN",3823311,0,0,0,15,0,0,0,0,-15]
["GRANDTOTAL",null,null,null,4524,15030,0,16532,768,0,0,0,3790]

{"sheet":"OPG","index":6,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["ADMIRE (T) WG70 150X30GR BOT IN",{"$f":"VLOOKUP(A1,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":13},10]
["ADMIRE WG70 125X(8X2GR) BAG IN",{"$f":"VLOOKUP(A2,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":16},952]
["ALIETTE WP80 40X100GR BAG IN",{"$f":"VLOOKUP(A3,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":35},100]
["AMBITION 20X500ML BOT IN",{"$f":"VLOOKUP(A4,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":40},0]
["AMBITION 40X250ML BOT IN",{"$f":"VLOOKUP(A5,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":41},51]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A6,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":44},0]
["ANTRACOL (T) WP70 50X100GR BAG IN",{"$f":"VLOOKUP(A7,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":45},725]
["ARIZE 6129 GOLD LOC 30X1KG BAG IN",{"$f":"VLOOKUP(A8,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":52},0]
["ARIZE TEJ GOLD LOC 30X1KG BAG IN",{"$f":"VLOOKUP(A9,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":95},0]
["CONFIDOR (T) SL200 100X50ML BOT IN",{"$f":"VLOOKUP(A10,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":112},40]
["CONFIDOR (T) SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A11,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":116},0]
["DECIS EC 28 20X500ML BOT IN",{"$f":"VLOOKUP(A12,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":125},20]
["ETHREL SL39 50X100ML BOT IN",{"$f":"VLOOKUP(A13,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":138},0]
["FAME (T) SC480 10X(20X10ML) BOT IN",{"$f":"VLOOKUP(A14,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":144},307]
["JUMP WG80 160X(10X2GR) BAG IN",{"$f":"VLOOKUP(A15,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":199},1420]
["JUMP WG80 80X40GR BAG IN",{"$f":"VLOOKUP(A16,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":202},65]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A17,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":225},0]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",{"$f":"VLOOKUP(A18,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":226},29]
["MOVENTO ENERGY SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A19,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":273},0]
["NATIVO WG75 100X50GR BAG IN",{"$f":"VLOOKUP(A20,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":289},0]
["OBERON (T) SC240 40X200ML BOT IN",{"$f":"VLOOKUP(A21,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":299},30]
["OBERON (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A22,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":300},43]
["PLANOFIX SL4 5 50X100ML BOT IN",{"$f":"VLOOKUP(A23,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":307},50]
["REGENT (T) SC50 20X250ML BOT IN",{"$f":"VLOOKUP(A24,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":325},15]
["REGENT (T) SC50 50X100ML BOT IN",{"$f":"VLOOKUP(A25,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":327},45]
["ARIZE 6444 GOLD LOC 30X1 BAG IN",{"$f":"VLOOKUP(A26,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":60},0]
["DECIS EC 28 50X100ML BOT IN",{"$f":"VLOOKUP(A27,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":928},0]
["ALIETTE WP80 20X250GR BAG IN",{"$f":"VLOOKUP(A28,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":33},14]
["ALIETTE WP80 20X500GR BAG IN",{"$f":"VLOOKUP(A29,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":34},0]
["AMBITION 10X1L BOT IN",{"$f":"VLOOKUP(A30,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":39},0]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A31,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":43},0]
["BUONOS SC430 20X500ML BOT IN",{"$f":"VLOOKUP(A32,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1396},0]
["CONFIDOR (T) SL200 10X1L BOT IN",{"$f":"VLOOKUP(A33,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":113},0]
["CONFIDOR (T) SL200 20X250ML BOT IN",{"$f":"VLOOKUP(A34,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":114},0]
["CONFIDOR (T) SL200 20X500ML BOT IN",{"$f":"VLOOKUP(A35,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":115},0]
["CONFIDOR SUPER (T) SC350 10X1L BOT IN",{"$f":"VLOOKUP(A36,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":117},0]
["CONFIDOR SUPER (T) SC350 20X500ML BOT IN",{"$f":"VLOOKUP(A37,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":119},0]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",{"$f":"VLOOKUP(A38,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":120},0]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",{"$f":"VLOOKUP(A39,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":121},0]
["DECIS EC 28 10X1L BOT IN",{"$f":"VLOOKUP(A40,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":124},3]
["DECIS EC101-2 50X100ML BOX IN",{"$f":"VLOOKUP(A41,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":924},0]
["DISCOUNTINUE PRODUCT",{"$f":"VLOOKUP(A42,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":993},0]
["FAME (T) SC480 40X50ML BOT IN",{"$f":"VLOOKUP(A43,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":146},0]
["FOLICUR (T) EC250 40X250ML BOT IN",{"$f":"VLOOKUP(A44,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":164},0]
["INFINITO SC687 5 20X500ML BOT IN",{"$f":"VLOOKUP(A45,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":195},0]
["INFINITO SC687 5 50X100ML BOT IN",{"$f":"VLOOKUP(A46,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":197},148]
["LUNA EXPERIENCE SC400 10X1L BOT IN",{"$f":"VLOOKUP(A47,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":223},0]
["MELODY DUO WP66 8 10X400GR BAG IN",{"$f":"VLOOKUP(A48,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":228},0]
["MELODY DUO WP66 8 50X100GR BAG IN",{"$f":"VLOOKUP(A49,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":233},77]
["MOVENTO ENERGY SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A50,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":274},24]
["NATIVO WG75 10X1KG BAG IN",{"$f":"VLOOKUP(A51,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":290},140]
["NATIVO WG75 20X500GR BAG IN",{"$f":"VLOOKUP(A52,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":292},0]
["NATIVO WG75 40X250GR BAG IN",{"$f":"VLOOKUP(A53,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":293},16]
["NATIVO WG75 50X100GR BAG IN",{"$f":"VLOOKUP(A54,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":294},150]
["REGENT GOLD SC200 20X500ML BOT IN",{"$f":"VLOOKUP(A55,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":330},0]
["REGENT GOLD SC200 40X250ML BOT IN",{"$f":"VLOOKUP(A56,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":331},0]
["REGENT GOLD SC200 50X100ML BOT IN",{"$f":"VLOOKUP(A57,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":332},0]
["SECTIN WG60 50X100GR BAG IN",{"$f":"VLOOKUP(A58,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":346},50]
["SOLOMON OD300 10X1L BOT IN",{"$f":"VLOOKUP(A59,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":365},0]
["SOLOMON OD300 40X250ML BOT IN",{"$f":"VLOOKUP(A60,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":368},0]
["SOLOMON OD300 50X100ML BOT IN",{"$f":"VLOOKUP(A61,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":370},0]
["VELUM PRIME SC400 20X500ML BOT IN",{"$f":"VLOOKUP(A62,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":400},0]

{"sheet":"Reco","index":7,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Jul-2021",null,null,null,null,null,null,null,null,"Dealer Report -Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Jul-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",10,0,0,10,0,0,0,0,0,10,0,0,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ADMIRE WG70 125X(8X2GR) BAG IN",952,0,0,925,0,0,0,0,27,952,0,0,925,0,0,0,0,27,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 20X250GR BAG IN",14,0,0,0,0,0,0,0,14,14,0,0,0,0,0,0,0,14,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 40X100GR BAG IN",100,0,0,1,0,0,0,0,99,100,0,0,1,0,0,0,0,99,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 20X500ML BOT IN",0,40,0,0,0,0,0,0,40,0,40,0,0,0,0,0,0,40,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 40X250ML BOT IN",51,0,0,10,0,0,0,0,41,51,0,0,10,0,0,0,0,41,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",0,80,0,0,0,0,0,0,80,0,80,0,0,0,0,0,0,80,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 50X100GR BAG IN",725,0,0,25,0,0,0,0,700,725,0,0,25,0,0,0,0,700,0,0,0,0,0,0,0,0,0,"Ok"]
["ARIZE 6129 GOLD LOC 30X1KG BAG IN",0,4020,0,3939,662,0,0,0,743,0,4020,0,3277,0,0,0,0,743,0,0,0,662,662,0,0,0,0,"Ok"]
["ARIZE TEJ GOLD LOC 30X1KG BAG IN",0,510,0,433,29,0,0,0,106,0,510,0,404,0,0,0,0,106,0,0,0,29,29,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 100X50ML BOT IN",40,0,0,60,0,0,0,0,-20,40,0,0,60,0,0,0,0,-20,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 50X100ML BOT IN",0,0,0,35,0,0,0,0,-35,0,0,0,35,0,0,0,0,-35,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 10X1L BOT IN",3,0,0,0,0,0,0,0,3,3,0,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 20X500ML BOT IN",20,0,0,12,0,0,0,0,8,20,0,0,12,0,0,0,0,8,0,0,0,0,0,0,0,0,0,"Ok"]
["ETHREL SL39 50X100ML BOT IN",0,100,0,98,0,0,0,0,2,0,100,0,98,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 10X(20X10ML) BOT IN",307,0,0,5,0,0,0,0,302,307,0,0,5,0,0,0,0,302,0,0,0,0,0,0,0,0,0,"Ok"]
["INFINITO SC687 5 50X100ML BOT IN",148,0,0,0,0,0,0,0,148,148,0,0,0,0,0,0,0,148,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 160X(10X2GR) BAG IN",1420,0,0,642,0,0,0,0,778,1420,0,0,642,0,0,0,0,778,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 80X40GR BAG IN",65,0,0,65,0,0,0,0,0,65,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",0,40,0,0,0,0,0,0,40,0,40,0,0,0,0,0,0,40,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",29,0,0,30,0,0,0,0,-1,29,0,0,30,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,"Ok"]
["MELODY DUO WP66 8 50X100GR BAG IN",77,0,0,0,0,0,0,0,77,77,0,0,0,0,0,0,0,77,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 40X250ML BOT IN",0,40,0,30,0,0,0,0,10,0,40,0,30,0,0,0,0,10,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 50X100ML BOT IN",24,0,0,0,0,0,0,0,24,24,0,0,0,0,0,0,0,24,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR BAG IN",0,0,0,1,0,0,0,0,-1,0,0,0,1,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 10X1KG BAG IN",140,0,0,0,0,0,0,0,140,140,0,0,0,0,0,0,0,140,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",16,0,0,0,0,0,0,0,16,16,0,0,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",150,0,0,0,0,0,0,0,150,150,0,0,0,0,0,0,0,150,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",30,80,0,26,0,0,0,0,84,30,80,0,26,0,0,0,0,84,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",43,0,0,58,0,0,0,0,-15,43,0,0,58,0,0,0,0,-15,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",50,100,0,65,0,0,0,0,85,50,100,0,65,0,0,0,0,85,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X250ML BOT IN",15,0,0,15,0,0,0,0,0,15,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 50X100ML BOT IN",45,0,0,41,0,0,0,0,4,45,0,0,41,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["SECTIN WG60 50X100GR BAG IN",50,0,0,0,0,0,0,0,50,50,0,0,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,"Ok"]
["ARIZE 6444 GOLD LOC 30X1 BAG IN",0,10020,0,9991,77,0,0,0,106,0,10020,0,9914,0,0,0,0,106,0,0,0,77,77,0,0,0,0,"Ok"]
["DECIS EC 28 50X100ML BOT IN",0,0,0,15,0,0,0,0,-15,0,0,0,15,0,0,0,0,-15,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 20X500GR 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"]
["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"]
["ANTRACOL (T) WP70 20X500GR 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"]
["BUONOS SC430 20X500ML 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"]
["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"]
["CONFIDOR (T) SL200 20X250ML 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"]
["CONFIDOR (T) SL200 20X500ML 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"]
["CONFIDOR SUPER (T) SC350 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"]
["CONFIDOR SUPER (T) SC350 20X500ML 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"]
["CONFIDOR SUPER (T) SC350 50X100ML 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"]
["CONFIDOR SUPER (T) SC350 50X50ML 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"]
["DECIS EC101-2 50X100ML BOX 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"]
["FAME (T) SC480 40X50ML 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"]
["FOLICUR (T) EC250 40X250ML 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"]
["INFINITO SC687 5 20X500ML 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 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"]
["MELODY DUO WP66 8 10X400GR 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"]
["NATIVO WG75 20X500GR 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"]
["REGENT GOLD SC200 20X500ML 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 GOLD SC200 40X250ML 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 GOLD SC200 50X100ML 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"]
["SOLOMON OD300 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"]
["SOLOMON OD300 40X250ML 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"]
["SOLOMON OD300 50X100ML 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"]
["VELUM PRIME SC400 20X500ML 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"]
["Total",{"$f":"SUM(B4:B64)","v":4524},{"$f":"SUM(C4:C64)","v":15030},0,16532,768,0,0,0,3790,4524,15030,0,15764,0,0,0,0,3790,0,0,0,768,768,0,0,0,0]