{"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,"Jangale and Sons"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2020 TO 31-May-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":96,"n_cols":5,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["JANGALE AND SONS - (2020-2021) - (from 1-Apr-2020)"]
["BAYER"]
["Stock Category Summary"]
["1-Apr-2020 to 31-May-2021"]
["","BAYER"]
["","JANGALE AND SONS - (2020-2021) - (from 1-Apr-2020)"]
["Particulars","1-Apr-2020 to 31-May-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["ADMIRE-150 GM",15,90,79,26]
["ADMIRE-300 GM",1,null,null,1]
["ADMIRE-30 GM",112,null,62,50]
["ADMIRE-75 GM",7,120,75,52]
["ALIETTE-1 KG",5,null,5]
["ALIETTE 250 GM",1,60,24,37]
["ALIETTE 500 GM",null,100,83,17]
["Ambition-1 Ltr",null,100,17,83]
["AMBITION-250 ML",40,null,40]
["AMBITION-500 ML",17,200,88,129]
["ANTRACOL-1 KG",26,50,49,27]
["ANTRACOL-250MI.",43,200,207,36]
["ANTRACOL-500 MI",83,300,178,205]
["BARCELO TAB-5 GM",9,null,9]
["BELT EXPART-250 ML",1,null,null,1]
["BELT EXPERT-100 ML",50,null,48,2]
["BG2-FIRIST CLASS 7149-450 GM",null,840,828,12]
["BG2-SUPERB BAYER -450 GM",null,733,721,12]
["BHENDI SHAKTI-3500 SEEDS",null,4,4]
["BHENDI SHAKTI 7000 SEEDS",null,2,2]
["BHENDI SMARAT-7000 SEED",2,null,null,2]
["CONFIDOR-100 ML",65,2100,1579,586]
["CONFIDOR-250 ML",2,720,613,109]
["CONFIDOR-500 ML",11,140,149,2]
["CONFIDOR-50 ML",1,900,395,506]
["CONFIDOR SUPER-100 ML",null,350,206,144]
["CONFIDOR SUPER-250 ML",null,140,114,26]
["CONFIDOR SUPER-500 ML",3,20,5,18]
["CONFIDOR SUPER-50 ML",71,150,74,147]
["DESIS-1 LTR",10,10,9,11]
["DESIS-250 ML",40,40,68,12]
["DESIS-500 ML",44,null,11,33]
["DESIS EC 101.2-100 ML",45,null,70,-25]
["DESIS EC 101.2-250 ML",2,80,67,15]
["ETHREL-100 ML",58,100,76,82]
["FAME-100 ML",8,20,6,22]
["FAME-10 ML"]
["FAME-50 ML",10,40,8,42]
["FOOST-500 GM",65,87,138,14]
["GAUCHO-50 ML"]
["GHAS EC10-500 ML"]
["ICON10 CS-100 ML",null,100,47,53]
["Infinito Sc 687.5 100 Ml",null,50,16,34]
["JUMP-2 GM",436,1600,733,1303]
["JUMP-40 GM",3,null,null,3]
["LARVIN-250 GM",4,80,85,-1]
["LARVIN-500 GM",23,20,33,10]
["LAUDIS-115 ML",48,160,177,31]
["LAUDIS SC630-57.5 ML",6,null,6]
["LESENTA-40 GM",1,null,null,1]
["LESENTA WG80-100 GM",86,null,46,40]
["LESENTA WG80-250 GM",28,null,28]
["MELODY DUO-400 GM",14,20,23,11]
["MOVENTO SC 240-1 LTR",7,20,26,1]
["MOVENTO SC 240-250 ML",30,80,100,10]
["NATIVO-100 GM",95,200,250,45]
["NATIVO -10 GM",null,200,20,180]
["NATIVO-250 GM",94,160,239,15]
["NATIVO-50 GM",63,300,96,267]
["OBARON-100 ML",41,null,5,36]
["OBARON-200 ML",70,null,5,65]
["OBARON-500 ML"]
["PLANOFIX-100 ML",71,300,325,46]
["PLANOFIX-250 ML",4,120,82,42]
["PREMISE SC 350-250 ML"]
["PROFEX-250 ML"]
["REGENT GOLD SC200-100 ML"]
["REGENT GOLD SC200-250 ML",4,null,5,-1]
["REGENT GOLD SC200-500 ML"]
["REGENT GR-1 KG",102,null,74,28]
["REGENT GR-5 KG",25,8,32,1]
["REGENT SC-1 LTR",3,100,85,18]
["REGENT SC-250 ML",17,100,110,7]
["REGENT SC-500 ML",31,160,166,25]
["SENCOR-100 GM"]
["SENCOR-500 GM",11,180,109,82]
["SIVANTO-250 ML"]
["SOLOMOM OD300-250 ML",null,240,240]
["SOLOMON-500 ML",4,280,223,61]
["SOLOMON OD300-100 ML",null,58,63,-5]
["SPINTAR-7 ML"]
["TEMPRID-50 ML"]
["WHIPSUPER-100 ML"]
["WHIPSUPER-1 LTR"]
["WHIPSUPER-250 ML",null,40,null,40]
["WHIPSUPER-500 ML",null,40,20,20]
["Grand Total",2168,12312,9576,4904]

{"sheet":"Dealer Report working","index":2,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["ADMIRE-150 GM",15,90,79,26,"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-300 GM",1,null,null,1,"ADMIRE WG70 20X300GR BAG IN",null,null,null,"ADMIRE (T) WG70 150X30GR BOT IN",112,null,62,50]
["ADMIRE-30 GM",112,null,62,50,"ADMIRE (T) WG70 150X30GR BOT IN",null,null,null,"ADMIRE (T) WG70 30X150GR BOT IN",15,90,79,26]
["ADMIRE-75 GM",7,120,75,52,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,"ADMIRE (T) WG70 60X75GR BOT IN",7,120,75,52]
["ALIETTE-1 KG",5,null,5,null,"ALIETTE WP80 10X1KG BAG IN",null,null,null,"ADMIRE WG70 20X300GR BAG IN",1,null,null,1]
["ALIETTE 250 GM",1,60,24,37,"ALIETTE WP80 20X250GR BAG IN",null,null,null,"ALIETTE WP80 10X1KG BAG IN",5,null,5]
["ALIETTE 500 GM",null,100,83,17,"ALIETTE WP80 20X500GR BAG IN",null,null,null,"ALIETTE WP80 20X250GR BAG IN",1,60,24,37]
["Ambition-1 Ltr",null,100,17,83,"AMBITION 10X1L BOT IN",null,null,null,"ALIETTE WP80 20X500GR BAG IN",null,100,83,17]
["AMBITION-250 ML",40,null,40,null,"AMBITION 40X250ML BOT IN",null,null,null,"AMBITION 10X1L BOT IN",null,100,17,83]
["AMBITION-500 ML",17,200,88,129,"AMBITION 20X500ML BOT IN",null,null,null,"AMBITION 20X500ML BOT IN",17,200,88,129]
["ANTRACOL-1 KG",26,50,49,27,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"AMBITION 40X250ML BOT IN",40,null,40]
["ANTRACOL-250MI.",43,200,207,36,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",26,50,49,27]
["ANTRACOL-500 MI",83,300,178,205,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",83,300,178,205]
["BARCELO TAB-5 GM",9,null,9,null,"DISCOUNTINUE PRODUCT",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",43,200,207,36]
["BELT EXPART-250 ML",1,null,null,1,"BELT EXPERT SC480 40X250ML BOT IN",null,null,null,"BELT EXPERT SC480 40X250ML BOT IN",1,null,null,1]
["BELT EXPERT-100 ML",50,null,48,2,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,"BELT EXPERT SC480 50X100ML BOT IN",50,null,48,2]
["BG2-FIRIST CLASS 7149-450 GM",null,840,828,12,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",null,null,null,"CONFIDOR (T) SL200 100X50ML BOT IN",1,900,395,506]
["BG2-SUPERB BAYER -450 GM",null,733,721,12,"SURPASS SUPERB BG2 20X450G BAG IN",null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN",2,720,613,109]
["BHENDI SHAKTI-3500 SEEDS",null,4,4,null,"DISCOUNTINUE PRODUCT",null,null,null,"CONFIDOR (T) SL200 20X500ML BOT IN",11,140,149,2]
["BHENDI SHAKTI 7000 SEEDS",null,2,2,null,"DISCOUNTINUE PRODUCT",null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN",65,2100,1579,586]
["BHENDI SMARAT-7000 SEED",2,null,null,2,"DISCOUNTINUE PRODUCT",null,null,null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,140,114,26]
["CONFIDOR-100 ML",65,2100,1579,586,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",3,20,5,18]
["CONFIDOR-250 ML",2,720,613,109,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,350,206,144]
["CONFIDOR-500 ML",11,140,149,2,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",71,150,74,147]
["CONFIDOR-50 ML",1,900,395,506,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,"DECIS EC 28 10X1L BOT IN",10,10,9,11]
["CONFIDOR SUPER-100 ML",null,350,206,144,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,"DECIS EC 28 20X500ML BOT IN",44,null,11,33]
["CONFIDOR SUPER-250 ML",null,140,114,26,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,"DECIS EC 28 40X250ML BOT IN",40,40,68,12]
["CONFIDOR SUPER-500 ML",3,20,5,18,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,"DECIS EC101-2 40X250ML BOT IN",2,80,67,15]
["CONFIDOR SUPER-50 ML",71,150,74,147,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,"DECIS EC101-2 50X100ML BOX IN",45,null,70,-25]
["DESIS-1 LTR",10,10,9,11,"DECIS EC 28 10X1L BOT IN",null,null,null,"DISCOUNTINUE PRODUCT",11,106,62,55]
["DESIS-250 ML",40,40,68,12,"DECIS EC 28 40X250ML BOT IN",null,null,null,"ETHREL SL39 50X100ML BOT IN",58,100,76,82]
["DESIS-500 ML",44,null,11,33,"DECIS EC 28 20X500ML BOT IN",null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN"]
["DESIS EC 101.2-100 ML",45,null,70,-25,"DECIS EC101-2 50X100ML BOX IN",null,null,null,"FAME (T) SC480 20X100ML BOT IN",8,20,6,22]
["DESIS EC 101.2-250 ML",2,80,67,15,"DECIS EC101-2 40X250ML BOT IN",null,null,null,"FAME (T) SC480 40X50ML BOT IN",10,40,8,42]
["ETHREL-100 ML",58,100,76,82,"ETHREL SL39 50X100ML BOT IN",null,null,null,"FOOST WP50 24X500G BAG IN",65,87,138,14]
["FAME-100 ML",8,20,6,22,"FAME (T) SC480 20X100ML BOT IN",null,null,null,"GAUCHO FS600 100X50ML BOT IN"]
["FAME-10 ML",null,null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,"INFINITO SC687 5 50X100ML BOT IN",null,50,16,34]
["FAME-50 ML",10,40,8,42,"FAME (T) SC480 40X50ML BOT IN",null,null,null,"JUMP WG80 160X(10X2GR) BAG IN",436,1600,733,1303]
["FOOST-500 GM",65,87,138,14,"FOOST WP50 24X500G BAG IN",null,null,null,"JUMP WG80 80X40GR BAG IN",3,null,null,3]
["GAUCHO-50 ML",null,null,null,null,"GAUCHO FS600 100X50ML BOT IN",null,null,null,"LARVIN (T) WP75 20X250GR BAG IN",4,80,85,-1]
["GHAS EC10-500 ML",null,null,null,null,"DISCOUNTINUE PRODUCT",null,null,null,"LARVIN (T) WP75 20X500GR BAG IN",23,20,33,10]
["ICON10 CS-100 ML",null,100,47,53,"DISCOUNTINUE PRODUCT",null,null,null,"LAUDIS SC630 10X57.5ML BOT IN",6,null,6]
["Infinito Sc 687.5 100 Ml",null,50,16,34,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN",48,160,177,31]
["JUMP-2 GM",436,1600,733,1303,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,"LESENTA WG80 100X40GR BAG IN",1,null,null,1]
["JUMP-40 GM",3,null,null,3,"JUMP WG80 80X40GR BAG IN",null,null,null,"LESENTA WG80 20X250GR BAG IN",28,null,28]
["LARVIN-250 GM",4,80,85,-1,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,"LESENTA WG80 50X100GR BAG IN",86,null,46,40]
["LARVIN-500 GM",23,20,33,10,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,"MELODY DUO WP66 8 10X400GR BAG IN",14,20,23,11]
["LAUDIS-115 ML",48,160,177,31,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 10X1L BOT IN",7,20,26,1]
["LAUDIS SC630-57.5 ML",6,null,6,null,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",30,80,100,10]
["LESENTA-40 GM",1,null,null,1,"LESENTA WG80 100X40GR BAG IN",null,null,null,"NATIVO WG75 100X50GR BAG IN",63,300,96,267]
["LESENTA WG80-100 GM",86,null,46,40,"LESENTA WG80 50X100GR BAG IN",null,null,null,"NATIVO WG75 20X(10X10GR) BAG IN",null,200,20,180]
["LESENTA WG80-250 GM",28,null,28,null,"LESENTA WG80 20X250GR BAG IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",94,160,239,15]
["MELODY DUO-400 GM",14,20,23,11,"MELODY DUO WP66 8 10X400GR BAG IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",95,200,250,45]
["MOVENTO SC 240-1 LTR",7,20,26,1,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,"OBERON (T) SC240 20X500ML BOT IN"]
["MOVENTO SC 240-250 ML",30,80,100,10,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",70,null,5,65]
["NATIVO-100 GM",95,200,250,45,"NATIVO WG75 50X100GR BAG IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN",41,null,5,36]
["NATIVO -10 GM",null,200,20,180,"NATIVO WG75 20X(10X10GR) BAG IN",null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",4,120,82,42]
["NATIVO-250 GM",94,160,239,15,"NATIVO WG75 40X250GR BAG IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",71,300,325,46]
["NATIVO-50 GM",63,300,96,267,"NATIVO WG75 100X50GR BAG IN",null,null,null,"PREMISE SC350 40X250ML BOT IN"]
["OBARON-100 ML",41,null,5,36,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 10X1L BOT IN",3,100,85,18]
["OBARON-200 ML",70,null,5,65,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"REGENT (T) SC50 20X250ML BOT IN",17,100,110,7]
["OBARON-500 ML",null,null,null,null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,"REGENT (T) SC50 20X500ML BOT IN",31,160,166,25]
["PLANOFIX-100 ML",71,300,325,46,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"REGENT GOLD SC200 20X500ML BOT IN"]
["PLANOFIX-250 ML",4,120,82,42,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"REGENT GOLD SC200 40X250ML BOT IN",4,null,5,-1]
["PREMISE SC 350-250 ML",null,null,null,null,"PREMISE SC350 40X250ML BOT IN",null,null,null,"REGENT GOLD SC200 50X100ML BOT IN"]
["PROFEX-250 ML",null,null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"REGENT GR0 3 20X1KG BAG IN",102,null,74,28]
["REGENT GOLD SC200-100 ML",null,null,null,null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,"REGENT GR0 3 4X5KG BAG IN",25,8,32,1]
["REGENT GOLD SC200-250 ML",4,null,5,-1,"REGENT GOLD SC200 40X250ML BOT IN",null,null,null,"SENCOR WP70 20X500GR BOX IN",11,180,109,82]
["REGENT GOLD SC200-500 ML",null,null,null,null,"REGENT GOLD SC200 20X500ML BOT IN",null,null,null,"SENCOR WP70 60X100GR BAG IN"]
["REGENT GR-1 KG",102,null,74,28,"REGENT GR0 3 20X1KG BAG IN",null,null,null,"SIVANTO PRIME SL200 40X250ML BOT IN"]
["REGENT GR-5 KG",25,8,32,1,"REGENT GR0 3 4X5KG BAG IN",null,null,null,"SOLOMON OD300 20X500ML BOT IN",4,280,223,61]
["REGENT SC-1 LTR",3,100,85,18,"REGENT (T) SC50 10X1L BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN",null,240,240]
["REGENT SC-250 ML",17,100,110,7,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,"SOLOMON OD300 50X100ML BOT IN",null,58,63,-5]
["REGENT SC-500 ML",31,160,166,25,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,"SPINTOR SC495 10X(20X7ML) BOT IN"]
["SENCOR-100 GM",null,null,null,null,"SENCOR WP70 60X100GR BAG IN",null,null,null,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",null,840,828,12]
["SENCOR-500 GM",11,180,109,82,"SENCOR WP70 20X500GR BOX IN",null,null,null,"SURPASS SUPERB BG2 20X450G BAG IN",null,733,721,12]
["SIVANTO-250 ML",null,null,null,null,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,"TEMPRID SC365.4 100X50ML BOT IN"]
["SOLOMOM OD300-250 ML",null,240,240,null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 10X1L BOT IN"]
["SOLOMON-500 ML",4,280,223,61,"SOLOMON OD300 20X500ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 20X500ML BOT IN",null,40,20,20]
["SOLOMON OD300-100 ML",null,58,63,-5,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 40X250ML BOT IN",null,40,null,40]
["SPINTAR-7 ML",null,null,null,null,"SPINTOR SC495 10X(20X7ML) BOT IN",null,null,null,"WHIPSUPER (T) EC90 50X100ML BOT IN"]
["TEMPRID-50 ML",null,null,null,null,"TEMPRID SC365.4 100X50ML BOT IN",null,null,null,"Grand Total",2168,12312,9576,4904]
["WHIPSUPER-100 ML",null,null,null,null,"WHIPSUPER (T) EC90 50X100ML BOT IN"]
["WHIPSUPER-1 LTR",null,null,null,null,"WHIPSUPER (T) EC90 10X1L BOT IN"]
["WHIPSUPER-250 ML",null,40,null,40,"WHIPSUPER (T) EC90 40X250ML BOT IN"]
["WHIPSUPER-500 ML",null,40,20,20,"WHIPSUPER (T) EC90 20X500ML BOT IN"]

{"sheet":"Master","index":3,"n_rows":87,"n_cols":2,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["ADMIRE-150 GM","ADMIRE (T) WG70 30X150GR BOT IN"]
["ADMIRE-300 GM","ADMIRE WG70 20X300GR BAG IN"]
["ADMIRE-30 GM","ADMIRE (T) WG70 150X30GR BOT IN"]
["ADMIRE-75 GM","ADMIRE (T) WG70 60X75GR BOT IN"]
["ALIETTE-1 KG","ALIETTE WP80 10X1KG BAG IN"]
["ALIETTE 250 GM","ALIETTE WP80 20X250GR BAG IN"]
["ALIETTE 500 GM","ALIETTE WP80 20X500GR BAG IN"]
["Ambition-1 Ltr","AMBITION 10X1L BOT IN"]
["AMBITION-250 ML","AMBITION 40X250ML BOT IN"]
["AMBITION-500 ML","AMBITION 20X500ML BOT IN"]
["ANTRACOL-1 KG","ANTRACOL (T) WP70 10X1KG BAG IN"]
["ANTRACOL-250MI.","ANTRACOL (T) WP70 40X250GR BAG IN"]
["ANTRACOL-500 MI","ANTRACOL (T) WP70 20X500GR BAG IN"]
["BARCELO TAB-5 GM","DISCOUNTINUE PRODUCT"]
["BELT EXPART-250 ML","BELT EXPERT SC480 40X250ML BOT IN"]
["BELT EXPERT-100 ML","BELT EXPERT SC480 50X100ML BOT IN"]
["BG2-FIRIST CLASS 7149-450 GM","SURPASS FIRSTCLASS 7149B2 20X450G BAG IN"]
["BG2-SUPERB BAYER -450 GM","SURPASS SUPERB BG2 20X450G BAG IN"]
["BHENDI SHAKTI-3500 SEEDS","DISCOUNTINUE PRODUCT"]
["BHENDI SHAKTI 7000 SEEDS","DISCOUNTINUE PRODUCT"]
["BHENDI SMARAT-7000 SEED","DISCOUNTINUE PRODUCT"]
["CONFIDOR-100 ML","CONFIDOR (T) SL200 50X100ML BOT IN"]
["CONFIDOR-250 ML","CONFIDOR (T) SL200 20X250ML BOT IN"]
["CONFIDOR-500 ML","CONFIDOR (T) SL200 20X500ML BOT IN"]
["CONFIDOR-50 ML","CONFIDOR (T) SL200 100X50ML BOT IN"]
["CONFIDOR SUPER-100 ML","CONFIDOR SUPER (T) SC350 50X100ML BOT IN"]
["CONFIDOR SUPER-250 ML","CONFIDOR SUPER (T) SC350 20X250ML BOT IN"]
["CONFIDOR SUPER-500 ML","CONFIDOR SUPER (T) SC350 20X500ML BOT IN"]
["CONFIDOR SUPER-50 ML","CONFIDOR SUPER (T) SC350 50X50ML BOT IN"]
["DESIS-1 LTR","DECIS EC 28 10X1L BOT IN"]
["DESIS-250 ML","DECIS EC 28 40X250ML BOT IN"]
["DESIS-500 ML","DECIS EC 28 20X500ML BOT IN"]
["DESIS EC 101.2-100 ML","DECIS EC101-2 50X100ML BOX IN"]
["DESIS EC 101.2-250 ML","DECIS EC101-2 40X250ML BOT IN"]
["ETHREL-100 ML","ETHREL SL39 50X100ML BOT IN"]
["FAME-100 ML","FAME (T) SC480 20X100ML BOT IN"]
["FAME-10 ML","FAME (T) SC480 10X(20X10ML) BOT IN"]
["FAME-50 ML","FAME (T) SC480 40X50ML BOT IN"]
["FOOST-500 GM","FOOST WP50 24X500G BAG IN"]
["GAUCHO-50 ML","GAUCHO FS600 100X50ML BOT IN"]
["ICON10 CS-100 ML","DISCOUNTINUE PRODUCT"]
["JUMP-2 GM","JUMP WG80 160X(10X2GR) BAG IN"]
["JUMP-40 GM","JUMP WG80 80X40GR BAG IN"]
["LARVIN-250 GM","LARVIN (T) WP75 20X250GR BAG IN"]
["LARVIN-500 GM","LARVIN (T) WP75 20X500GR BAG IN"]
["LAUDIS-115 ML","LAUDIS SC630 8X115ML BOT IN"]
["LAUDIS SC630-57.5 ML","LAUDIS SC630 10X57.5ML BOT IN"]
["LESENTA-40 GM","LESENTA WG80 100X40GR BAG IN"]
["LESENTA WG80-100 GM","LESENTA WG80 50X100GR BAG IN"]
["LESENTA WG80-250 GM","LESENTA WG80 20X250GR BAG IN"]
["MELODY DUO-400 GM","MELODY DUO WP66 8 10X400GR BAG IN"]
["MOVENTO SC 240-1 LTR","MOVENTO ENERGY SC240 10X1L BOT IN"]
["MOVENTO SC 240-250 ML","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["NATIVO-100 GM","NATIVO WG75 50X100GR BAG IN"]
["NATIVO-250 GM","NATIVO WG75 40X250GR BAG IN"]
["NATIVO-50 GM","NATIVO WG75 100X50GR BAG IN"]
["OBARON-100 ML","OBERON (T) SC240 50X100ML BOT IN"]
["OBARON-200 ML","OBERON (T) SC240 40X200ML BOT IN"]
["OBARON-500 ML","OBERON (T) SC240 20X500ML BOT IN"]
["PLANOFIX-100 ML","PLANOFIX SL4 5 50X100ML BOT IN"]
["PLANOFIX-250 ML","PLANOFIX SL4 5 40X250ML BOT IN"]
["PREMISE SC 350-250 ML","PREMISE SC350 40X250ML BOT IN"]
["PROFEX-250 ML","PLANOFIX SL4 5 40X250ML BOT IN"]
["REGENT GOLD SC200-100 ML","REGENT GOLD SC200 50X100ML BOT IN"]
["REGENT GOLD SC200-250 ML","REGENT GOLD SC200 40X250ML BOT IN"]
["REGENT GOLD SC200-500 ML","REGENT GOLD SC200 20X500ML BOT IN"]
["REGENT GR-1 KG","REGENT GR0 3 20X1KG BAG IN"]
["REGENT GR-5 KG","REGENT GR0 3 4X5KG BAG IN"]
["REGENT SC-1 LTR","REGENT (T) SC50 10X1L BOT IN"]
["REGENT SC-250 ML","REGENT (T) SC50 20X250ML BOT IN"]
["REGENT SC-500 ML","REGENT (T) SC50 20X500ML BOT IN"]
["SENCOR-100 GM","SENCOR WP70 60X100GR BAG IN"]
["SENCOR-500 GM","SENCOR WP70 20X500GR BOX IN"]
["SIVANTO-250 ML","SIVANTO PRIME SL200 40X250ML BOT IN"]
["SOLOMOM OD300-250 ML","SOLOMON OD300 40X250ML BOT IN"]
["SOLOMON-500 ML","SOLOMON OD300 20X500ML BOT IN"]
["SOLOMON OD300-100 ML","SOLOMON OD300 50X100ML BOT IN"]
["SPINTAR-7 ML","SPINTOR SC495 10X(20X7ML) BOT IN"]
["TEMPRID-50 ML","TEMPRID SC365.4 100X50ML BOT IN"]
["WHIPSUPER-100 ML","WHIPSUPER (T) EC90 50X100ML BOT IN"]
["WHIPSUPER-1 LTR","WHIPSUPER (T) EC90 10X1L BOT IN"]
["WHIPSUPER-250 ML","WHIPSUPER (T) EC90 40X250ML BOT IN"]
["WHIPSUPER-500 ML","WHIPSUPER (T) EC90 20X500ML BOT IN"]
["GHAS EC10-500 ML","DISCOUNTINUE PRODUCT"]
["Infinito Sc 687.5 100 Ml","INFINITO SC687 5 50X100ML BOT IN"]
["NATIVO -10 GM","NATIVO WG75 20X(10X10GR) BAG IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":83,"n_cols":14,"rows_kept":83,"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,112,0,0,62,0,0,0,0,50]
[null,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,15,90,0,79,0,0,0,0,26]
[null,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,7,120,0,75,0,0,0,0,52]
[null,"ADMIRE WG70 20X300GR BAG IN",null,null,null,1,0,0,0,0,0,0,0,1]
[null,"ALIETTE WP80 10X1KG BAG IN",null,null,null,5,0,0,5,0,0,0,0,0]
[null,"ALIETTE WP80 20X250GR BAG IN",null,null,null,1,60,0,24,0,0,0,0,37]
[null,"ALIETTE WP80 20X500GR BAG IN",null,null,null,0,100,0,83,0,0,0,0,17]
[null,"AMBITION 10X1L BOT IN",null,null,null,0,100,0,17,0,0,0,0,83]
[null,"AMBITION 20X500ML BOT IN",null,null,null,17,200,0,88,0,0,0,0,129]
[null,"AMBITION 40X250ML BOT IN",null,null,null,40,0,0,40,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,26,50,0,49,0,0,0,0,27]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,83,300,0,178,0,0,0,0,205]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,43,200,0,207,0,0,0,0,36]
[null,"BELT EXPERT SC480 40X250ML BOT IN",null,null,null,1,0,0,0,0,0,0,0,1]
[null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,50,0,0,48,0,0,0,0,2]
[null,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,1,900,0,395,0,0,0,0,506]
[null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,2,720,0,613,0,0,0,0,109]
[null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,11,140,0,149,0,0,0,0,2]
[null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,65,2100,0,1579,0,0,0,0,586]
[null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,0,140,0,114,0,0,0,0,26]
[null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,3,20,0,5,0,0,0,0,18]
[null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,0,350,0,206,0,0,0,0,144]
[null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,71,150,0,74,0,0,0,0,147]
[null,"DECIS EC 28 10X1L BOT IN",null,null,null,10,10,0,9,0,0,0,0,11]
[null,"DECIS EC 28 20X500ML BOT IN",null,null,null,44,0,0,11,0,0,0,0,33]
[null,"DECIS EC 28 40X250ML BOT IN",null,null,null,40,40,0,68,0,0,0,0,12]
[null,"DECIS EC101-2 40X250ML BOT IN",null,null,null,2,80,0,67,0,0,0,0,15]
[null,"DECIS EC101-2 50X100ML BOX IN",null,null,null,45,0,0,70,0,0,0,0,-25]
[null,"DISCOUNTINUE PRODUCT",null,null,null,11,106,0,62,0,0,0,0,55]
[null,"ETHREL SL39 50X100ML BOT IN",null,null,null,58,100,0,76,0,0,0,0,82]
[null,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,8,20,0,6,0,0,0,0,22]
[null,"FAME (T) SC480 40X50ML BOT IN",null,null,null,10,40,0,8,0,0,0,0,42]
[null,"FOOST WP50 24X500G BAG IN",null,null,null,65,87,0,138,0,0,0,0,14]
[null,"GAUCHO FS600 100X50ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,0,50,0,16,0,0,0,0,34]
[null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,436,1600,0,733,0,0,0,0,1303]
[null,"JUMP WG80 80X40GR BAG IN",null,null,null,3,0,0,0,0,0,0,0,3]
[null,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,4,80,0,85,0,0,0,0,-1]
[null,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,23,20,0,33,0,0,0,0,10]
[null,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,6,0,0,6,0,0,0,0,0]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,48,160,0,177,0,0,0,0,31]
[null,"LESENTA WG80 100X40GR BAG IN",null,null,null,1,0,0,0,0,0,0,0,1]
[null,"LESENTA WG80 20X250GR BAG IN",null,null,null,28,0,0,28,0,0,0,0,0]
[null,"LESENTA WG80 50X100GR BAG IN",null,null,null,86,0,0,46,0,0,0,0,40]
[null,"MELODY DUO WP66 8 10X400GR BAG IN",null,null,null,14,20,0,23,0,0,0,0,11]
[null,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,7,20,0,26,0,0,0,0,1]
[null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,30,80,0,100,0,0,0,0,10]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,63,300,0,96,0,0,0,0,267]
[null,"NATIVO WG75 20X(10X10GR) BAG IN",null,null,null,0,200,0,20,0,0,0,0,180]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,94,160,0,239,0,0,0,0,15]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,95,200,0,250,0,0,0,0,45]
[null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,70,0,0,5,0,0,0,0,65]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,41,0,0,5,0,0,0,0,36]
[null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,4,120,0,82,0,0,0,0,42]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,71,300,0,325,0,0,0,0,46]
[null,"PREMISE SC350 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT (T) SC50 10X1L BOT IN",null,null,null,3,100,0,85,0,0,0,0,18]
[null,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,17,100,0,110,0,0,0,0,7]
[null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,31,160,0,166,0,0,0,0,25]
[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,4,0,0,5,0,0,0,0,-1]
[null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT GR0 3 20X1KG BAG IN",null,null,null,102,0,0,74,0,0,0,0,28]
[null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,25,8,0,32,0,0,0,0,1]
[null,"SENCOR WP70 20X500GR BOX IN",null,null,null,11,180,0,109,0,0,0,0,82]
[null,"SENCOR WP70 60X100GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,4,280,0,223,0,0,0,0,61]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,0,240,0,240,0,0,0,0,0]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,0,58,0,63,0,0,0,0,-5]
[null,"SPINTOR SC495 10X(20X7ML) BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",null,null,null,0,840,0,828,0,0,0,0,12]
[null,"SURPASS SUPERB BG2 20X450G BAG IN",null,null,null,0,733,0,721,0,0,0,0,12]
[null,"TEMPRID SC365.4 100X50ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"WHIPSUPER (T) EC90 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"WHIPSUPER (T) EC90 20X500ML BOT IN",null,null,null,0,40,0,20,0,0,0,0,20]
[null,"WHIPSUPER (T) EC90 40X250ML BOT IN",null,null,null,0,40,0,0,0,0,0,0,40]
[null,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Grand Total",null,null,null,2168,12312,0,9576,0,0,0,0,4904]

{"sheet":"Zylem SNS Report","index":5,"n_rows":76,"n_cols":13,"rows_kept":76,"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-May-2021"]
["Generated on 6/25/2021 11:44:25 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Jangale and Sons,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Jangale and Sons",9061592,"ADMIRE (T) WG70 150X30GR BOT IN",79234988,112,150,150,62,0,0,0,0,50]
["Jangale and Sons",9061592,"ADMIRE (T) WG70 30X150GR BOT IN",79277857,15,120,30,79,0,0,0,0,26]
["Jangale and Sons",9061592,"ADMIRE (T) WG70 60X75GR BOT IN",79297696,7,180,60,75,0,0,0,0,52]
["Jangale and Sons",9061592,"ADMIRE WG70 20X300GR BAG IN",79696000,1,0,0,0,0,0,0,0,1]
["Jangale and Sons",9061592,"ALIETTE WP80 10X1KG BAG IN",3822323,5,0,0,5,0,0,0,0,0]
["Jangale and Sons",9061592,"ALIETTE WP80 20X250GR BAG IN",3822358,1,60,0,24,0,0,0,0,37]
["Jangale and Sons",9061592,"ALIETTE WP80 20X500GR BAG IN",3822366,0,100,0,83,0,0,0,0,17]
["Jangale and Sons",9061592,"AMBITION 10X1L BOT IN",86212544,0,100,0,17,0,0,0,0,83]
["Jangale and Sons",9061592,"AMBITION 20X500ML BOT IN",86228564,17,200,0,88,0,0,0,0,129]
["Jangale and Sons",9061592,"AMBITION 40X250ML BOT IN",86232308,40,0,0,40,0,0,0,0,0]
["Jangale and Sons",9061592,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,26,50,0,49,0,0,0,0,27]
["Jangale and Sons",9061592,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,83,300,0,178,0,0,0,0,205]
["Jangale and Sons",9061592,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,43,200,0,207,0,0,0,0,36]
["Jangale and Sons",9061592,"BELT EXPERT SC480 40X250ML BOT IN",80979479,1,0,0,0,0,0,0,0,1]
["Jangale and Sons",9061592,"BELT EXPERT SC480 50X100ML BOT IN",79722869,50,0,0,48,0,0,0,0,2]
["Jangale and Sons",9061592,"CONFIDOR (T) SL200 100X50ML BOT IN",5708361,1,900,0,395,0,0,0,0,506]
["Jangale and Sons",9061592,"CONFIDOR (T) SL200 20X250ML BOT IN",5699494,2,720,0,613,0,0,0,0,109]
["Jangale and Sons",9061592,"CONFIDOR (T) SL200 20X500ML BOT IN",5704439,11,140,0,149,0,0,0,0,2]
["Jangale and Sons",9061592,"CONFIDOR (T) SL200 50X100ML BOT IN",5703475,65,2100,0,1578,0,0,0,0,587]
["Jangale and Sons",9061592,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",79710852,0,200,60,114,0,0,0,0,26]
["Jangale and Sons",9061592,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",79734727,3,40,20,5,0,0,0,0,18]
["Jangale and Sons",9061592,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",79735219,0,350,0,205,0,0,0,0,145]
["Jangale and Sons",9061592,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",79985169,71,150,0,75,1,0,0,0,147]
["Jangale and Sons",9061592,"DECIS EC 28 10X1L BOT IN",3823303,10,10,0,9,0,0,0,0,11]
["Jangale and Sons",9061592,"DECIS EC 28 20X500ML BOT IN",3823370,44,0,0,11,0,0,0,0,33]
["Jangale and Sons",9061592,"DECIS EC 28 40X250ML BOT IN",3823346,40,40,0,68,0,0,0,0,12]
["Jangale and Sons",9061592,"ETHREL SL39 50X100ML BOT IN",4299026,58,100,0,76,0,0,0,0,82]
["Jangale and Sons",9061592,"FAME (T) SC480 20X100ML BOT IN",79266197,8,20,0,6,0,0,0,0,22]
["Jangale and Sons",9061592,"FAME (T) SC480 40X50ML BOT IN",79224699,10,40,0,7,0,0,0,0,43]
["Jangale and Sons",9061592,"FOOST WP50 24X500G BAG IN",85811770,65,87,0,137,0,0,0,0,15]
["Jangale and Sons",9061592,"INFINITO SC687 5 50X100ML BOT IN",79632487,0,50,0,16,0,0,0,0,34]
["Jangale and Sons",9061592,"JUMP WG80 160X(10X2GR) BAG IN",79215304,436,1600,0,738,5,0,0,0,1303]
["Jangale and Sons",9061592,"JUMP WG80 80X40GR BAG IN",79267509,3,0,0,0,0,0,0,0,3]
["Jangale and Sons",9061592,"LARVIN (T) WP75 20X250GR BAG IN",6003167,4,80,0,86,1,0,0,0,-1]
["Jangale and Sons",9061592,"LARVIN (T) WP75 20X500GR BAG IN",6005291,23,20,0,33,0,0,0,0,10]
["Jangale and Sons",9061592,"LAUDIS SC630 10X57.5ML BOT IN",84470481,6,0,0,6,0,0,0,0,0]
["Jangale and Sons",9061592,"LAUDIS SC630 8X115ML BOT IN",80491085,48,160,0,176,0,0,0,0,32]
["Jangale and Sons",9061592,"LESENTA WG80 100X40GR BAG IN",80500823,1,0,0,0,0,0,0,0,1]
["Jangale and Sons",9061592,"LESENTA WG80 20X250GR BAG IN",80557817,28,0,0,28,0,0,0,0,0]
["Jangale and Sons",9061592,"LESENTA WG80 50X100GR BAG IN",80503385,86,0,0,46,0,0,0,0,40]
["Jangale and Sons",9061592,"MELODY DUO WP66 8 10X400GR BAG IN",80994974,14,20,0,23,0,0,0,0,11]
["Jangale and Sons",9061592,"MOVENTO ENERGY SC240 10X1L BOT IN",79556837,7,30,10,26,0,0,0,0,1]
["Jangale and Sons",9061592,"MOVENTO ENERGY SC240 40X250ML BOT IN",79679505,30,160,80,100,0,0,0,0,10]
["Jangale and Sons",9061592,"NATIVO WG75 100X50GR BAG IN",80580061,63,300,0,92,0,0,0,0,271]
["Jangale and Sons",9061592,"NATIVO WG75 20X(10X10GR) BAG IN",80899920,0,200,0,20,0,0,0,0,180]
["Jangale and Sons",9061592,"NATIVO WG75 40X250GR BAG IN",79237790,94,160,0,239,0,0,0,0,15]
["Jangale and Sons",9061592,"NATIVO WG75 50X100GR BAG IN",79304102,95,200,0,249,0,0,0,0,46]
["Jangale and Sons",9061592,"OBERON (T) SC240 40X200ML BOT IN",79971362,70,0,0,5,0,0,0,0,65]
["Jangale and Sons",9061592,"OBERON (T) SC240 50X100ML BOT IN",79998538,41,0,0,5,0,0,0,0,36]
["Jangale and Sons",9061592,"PLANOFIX SL4 5 40X250ML BOT IN",3825128,4,120,0,82,0,0,0,0,42]
["Jangale and Sons",9061592,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,71,300,0,325,0,0,0,0,46]
["Jangale and Sons",9061592,"REGENT (T) SC50 20X250ML BOT IN",5976951,17,100,0,108,0,0,0,0,9]
["Jangale and Sons",9061592,"REGENT (T) SC50 20X500ML BOT IN",5987678,31,160,0,167,1,0,0,0,25]
["Jangale and Sons",9061592,"REGENT GOLD SC200 40X250ML BOT IN",84126616,4,0,0,5,0,0,0,0,-1]
["Jangale and Sons",9061592,"REGENT GR0 3 20X1KG BAG IN",79667140,102,0,0,74,0,0,0,0,28]
["Jangale and Sons",9061592,"REGENT GR0 3 4X5KG BAG IN",80018703,25,8,0,32,0,0,0,0,1]
["Jangale and Sons",9061592,"SENCOR WP70 20X500GR BOX IN",79052375,11,180,0,109,0,0,0,0,82]
["Jangale and Sons",9061592,"SOLOMON OD300 20X500ML BOT IN",79987870,4,280,0,223,0,0,0,0,61]
["Jangale and Sons",9061592,"SOLOMON OD300 40X250ML BOT IN",79706723,0,280,40,240,0,0,0,0,0]
["Jangale and Sons",9061592,"SOLOMON OD300 50X100ML BOT IN",79641931,0,100,42,63,0,0,0,0,-5]
["Jangale and Sons",9061592,"SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",80938829,0,860,20,880,52,0,0,0,12]
["Jangale and Sons",9061592,"SURPASS SUPERB BG2 20X450G BAG IN",84950246,0,900,167,806,85,0,0,0,12]
["Jangale and Sons",9061592,"WHIPSUPER (T) EC90 20X500ML BOT IN",5955989,0,40,0,21,1,0,0,0,20]
["Jangale and Sons",9061592,"WHIPSUPER (T) EC90 40X250ML BOT IN",5966131,0,40,0,0,0,0,0,0,40]
["Jangale and Sons",9061592,"DECIS EC101-2 50X100ML BOX IN",6103692,45,50,50,70,0,0,0,0,-25]
["Jangale and Sons",9061592,"DECIS EC101-2 40X250ML BOT IN",3823281,2,80,0,67,0,0,0,0,15]
["Jangale and Sons",9061592,"REGENT (T) SC50 10X1L BOT IN",5962667,3,100,0,85,0,0,0,0,18]
["GRANDTOTAL",null,null,null,2157,12935,729,9648,146,0,0,0,4861]

{"sheet":"OPG","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"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},132]

{"sheet":"Reco","index":7,"n_rows":83,"n_cols":29,"rows_kept":83,"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-May-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2020 TO 31-May-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",112,150,150,62,0,0,0,0,50,112,0,0,62,0,0,0,0,50,0,150,150,0,0,0,0,0,{"$f":"J4-S4","v":0},"Ok"]
["ADMIRE (T) WG70 30X150GR BOT IN",15,120,30,79,0,0,0,0,26,15,90,0,79,0,0,0,0,26,0,30,30,0,0,0,0,0,{"$f":"J5-S5","v":0},"Ok"]
["ADMIRE (T) WG70 60X75GR BOT IN",7,180,60,75,0,0,0,0,52,7,120,0,75,0,0,0,0,52,0,60,60,0,0,0,0,0,0,"Ok"]
["ADMIRE WG70 20X300GR BAG IN",1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 10X1KG BAG IN",5,0,0,5,0,0,0,0,0,5,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 20X250GR BAG IN",1,60,0,24,0,0,0,0,37,1,60,0,24,0,0,0,0,37,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 20X500GR BAG IN",0,100,0,83,0,0,0,0,17,0,100,0,83,0,0,0,0,17,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 10X1L BOT IN",0,100,0,17,0,0,0,0,83,0,100,0,17,0,0,0,0,83,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 20X500ML BOT IN",17,200,0,88,0,0,0,0,129,17,200,0,88,0,0,0,0,129,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 40X250ML BOT IN",40,0,0,40,0,0,0,0,0,40,0,0,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",26,50,0,49,0,0,0,0,27,26,50,0,49,0,0,0,0,27,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",83,300,0,178,0,0,0,0,205,83,300,0,178,0,0,0,0,205,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",43,200,0,207,0,0,0,0,36,43,200,0,207,0,0,0,0,36,0,0,0,0,0,0,0,0,0,"Ok"]
["BELT EXPERT SC480 40X250ML BOT IN",1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,"Ok"]
["BELT EXPERT SC480 50X100ML BOT IN",50,0,0,48,0,0,0,0,2,50,0,0,48,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 100X50ML BOT IN",1,900,0,395,0,0,0,0,506,1,900,0,395,0,0,0,0,506,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X250ML BOT IN",2,720,0,613,0,0,0,0,109,2,720,0,613,0,0,0,0,109,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X500ML BOT IN",11,140,0,149,0,0,0,0,2,11,140,0,149,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 50X100ML BOT IN",65,2100,0,1579,0,0,0,0,586,65,2100,0,1579,0,0,0,0,586,0,0,0,-1,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",0,200,60,114,0,0,0,0,26,0,140,0,114,0,0,0,0,26,0,60,60,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X500ML BOT IN",3,40,20,5,0,0,0,0,18,3,20,0,5,0,0,0,0,18,0,20,20,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",0,350,0,206,0,0,0,0,144,0,350,0,206,0,0,0,0,144,0,0,0,-1,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",71,150,0,75,1,0,0,0,147,71,150,0,74,0,0,0,0,147,0,0,0,1,1,0,0,0,0,"Ok"]
["DECIS EC 28 10X1L BOT IN",10,10,0,9,0,0,0,0,11,10,10,0,9,0,0,0,0,11,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 20X500ML BOT IN",44,0,0,11,0,0,0,0,33,44,0,0,11,0,0,0,0,33,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 40X250ML BOT IN",40,40,0,68,0,0,0,0,12,40,40,0,68,0,0,0,0,12,0,0,0,0,0,0,0,0,0,"Ok"]
["ETHREL SL39 50X100ML BOT IN",58,100,0,76,0,0,0,0,82,58,100,0,76,0,0,0,0,82,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 20X100ML BOT IN",8,20,0,6,0,0,0,0,22,8,20,0,6,0,0,0,0,22,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 40X50ML BOT IN",10,40,0,8,0,0,0,0,42,10,40,0,8,0,0,0,0,42,0,0,0,-1,0,0,0,0,0,"Ok"]
["FOOST WP50 24X500G BAG IN",65,87,0,138,0,0,0,0,14,65,87,0,138,0,0,0,0,14,0,0,0,-1,0,0,0,0,0,"Ok"]
["INFINITO SC687 5 50X100ML BOT IN",0,50,0,16,0,0,0,0,34,0,50,0,16,0,0,0,0,34,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 160X(10X2GR) BAG IN",436,1600,0,738,5,0,0,0,1303,436,1600,0,733,0,0,0,0,1303,0,0,0,5,5,0,0,0,0,"Ok"]
["JUMP WG80 80X40GR BAG 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"]
["LARVIN (T) WP75 20X250GR BAG IN",4,80,0,86,1,0,0,0,-1,4,80,0,85,0,0,0,0,-1,0,0,0,1,1,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X500GR BAG IN",23,20,0,33,0,0,0,0,10,23,20,0,33,0,0,0,0,10,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 10X57.5ML BOT IN",6,0,0,6,0,0,0,0,0,6,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 8X115ML BOT IN",48,160,0,177,0,0,0,0,31,48,160,0,177,0,0,0,0,31,0,0,0,-1,0,0,0,0,0,"Ok"]
["LESENTA WG80 100X40GR BAG IN",1,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,"Ok"]
["LESENTA WG80 20X250GR BAG IN",28,0,0,28,0,0,0,0,0,28,0,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LESENTA WG80 50X100GR BAG IN",86,0,0,46,0,0,0,0,40,86,0,0,46,0,0,0,0,40,0,0,0,0,0,0,0,0,0,"Ok"]
["MELODY DUO WP66 8 10X400GR BAG IN",14,20,0,23,0,0,0,0,11,14,20,0,23,0,0,0,0,11,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 10X1L BOT IN",7,30,10,26,0,0,0,0,1,7,20,0,26,0,0,0,0,1,0,10,10,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 40X250ML BOT IN",30,160,80,100,0,0,0,0,10,30,80,0,100,0,0,0,0,10,0,80,80,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR BAG IN",63,300,0,96,0,0,0,0,267,63,300,0,96,0,0,0,0,267,0,0,0,-4,0,0,0,0,0,"Ok"]
["NATIVO WG75 20X(10X10GR) BAG IN",0,200,0,20,0,0,0,0,180,0,200,0,20,0,0,0,0,180,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",94,160,0,239,0,0,0,0,15,94,160,0,239,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",95,200,0,250,0,0,0,0,45,95,200,0,250,0,0,0,0,45,0,0,0,-1,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",70,0,0,5,0,0,0,0,65,70,0,0,5,0,0,0,0,65,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",41,0,0,5,0,0,0,0,36,41,0,0,5,0,0,0,0,36,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 40X250ML BOT IN",4,120,0,82,0,0,0,0,42,4,120,0,82,0,0,0,0,42,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",71,300,0,325,0,0,0,0,46,71,300,0,325,0,0,0,0,46,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X250ML BOT IN",17,100,0,110,0,0,0,0,7,17,100,0,110,0,0,0,0,7,0,0,0,-2,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X500ML BOT IN",31,160,0,167,1,0,0,0,25,31,160,0,166,0,0,0,0,25,0,0,0,1,1,0,0,0,0,"Ok"]
["REGENT GOLD SC200 40X250ML BOT IN",4,0,0,5,0,0,0,0,-1,4,0,0,5,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT GR0 3 20X1KG BAG IN",102,0,0,74,0,0,0,0,28,102,0,0,74,0,0,0,0,28,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT GR0 3 4X5KG BAG IN",25,8,0,32,0,0,0,0,1,25,8,0,32,0,0,0,0,1,0,0,0,0,0,0,0,0,0,"Ok"]
["SENCOR WP70 20X500GR BOX IN",11,180,0,109,0,0,0,0,82,11,180,0,109,0,0,0,0,82,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 20X500ML BOT IN",4,280,0,223,0,0,0,0,61,4,280,0,223,0,0,0,0,61,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 40X250ML BOT IN",0,280,40,240,0,0,0,0,0,0,240,0,240,0,0,0,0,0,0,40,40,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 50X100ML BOT IN",0,100,42,63,0,0,0,0,-5,0,58,0,63,0,0,0,0,-5,0,42,42,0,0,0,0,0,0,"Ok"]
["SURPASS FIRSTCLASS 7149B2 20X450G BAG IN",0,860,20,880,52,0,0,0,12,0,840,0,828,0,0,0,0,12,0,20,20,52,52,0,0,0,0,"Ok"]
["SURPASS SUPERB BG2 20X450G BAG IN",0,900,167,806,85,0,0,0,12,0,733,0,721,0,0,0,0,12,0,167,167,85,85,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 20X500ML BOT IN",0,40,0,21,1,0,0,0,20,0,40,0,20,0,0,0,0,20,0,0,0,1,1,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 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"]
["DECIS EC101-2 50X100ML BOX IN",45,50,50,70,0,0,0,0,-25,45,0,0,70,0,0,0,0,-25,0,50,50,0,0,0,0,0,0,"Ok"]
["DECIS EC101-2 40X250ML BOT IN",2,80,0,67,0,0,0,0,15,2,80,0,67,0,0,0,0,15,0,0,0,0,0,0,0,0,{"$f":"J69-S69","v":0},"Ok"]
["REGENT (T) SC50 10X1L BOT IN",3,100,0,85,0,0,0,0,18,3,100,0,85,0,0,0,0,18,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 10X(20X10ML) 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"]
["GAUCHO FS600 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"]
["OBERON (T) SC240 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"]
["PREMISE SC350 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 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 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"]
["SENCOR WP70 60X100GR 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"]
["SIVANTO PRIME SL200 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"]
["SPINTOR SC495 10X(20X7ML) 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"]
["TEMPRID SC365.4 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"]
["WHIPSUPER (T) EC90 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"]
["WHIPSUPER (T) EC90 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"]
["Total",{"$f":"SUM(B4:B82)","v":2157},12935,729,9660,146,0,0,0,4849,2157,12206,0,9514,0,0,0,0,4849,0,729,729,134,146,0,0,0,{"$f":"SUM(AB4:AB82)","v":0}]