{"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,"Khandelwal Krushi Kendra"]
[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":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Khandelwal Krushi Kendra 2021-22"]
["Malkapur Road Bodwad"]
["Tal. Bodwad Dist. Jalgaon"]
["Bayer"]
["Stock Category Summary"]
["1-Apr-21 to 31-Jul-21"]
["","Bayer"]
["","Khandelwal Krushi Kendra 2021-22"]
["Particulars","1-Apr-21 to 31-Jul-21"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["7517- BG II(Superb) Bayer- 475 GM",null,400,195,205]
["ADMIRE 150 GMS",23,60,30,53]
["ADMIRE 30 GMS",119,null,12,107]
["ADMIRE 75 GMS",39,120,30,129]
["AMBITION-1 LTR",175,null,8,167]
["AMBITION-250 ML",143,null,21,122]
["AMBITION-500 ML",296,null,27,269]
["ANTRACOL 1 KG(10 NOS)",10,200,80,130]
["ANTRACOL 250 GMS(40 NOS)",155,80,107,128]
["ANTRACOL 500 GMS(20 NOS)",10,500,212,298]
["BELT EXPERT 100 ML",10,50,5,55]
["BUONOS-250 ML",34,null,18,16]
["BUONOS-500 ML",null,20,null,20]
["CONFIDOR 100 ML(50 NOS)",35,1250,1062,223]
["CONFIDOR 250 ML (20 NOS)",75,500,475,100]
["CONFIDOR 50 ML",29,1000,624,405]
["CONFIDOR SUPER 100 ML(50 NOS)",12,1000,687,325]
["CONFIDOR SUPER 250 ML(20 NOS)",53,400,267,186]
["CONFIDOR SUPER 50 ML(50 NOS)",12,650,603,59]
["DECIS 100 BAYER 100 ML",14,null,null,14]
["DECIS-100 BAYER 250 ML",16,null,null,16]
["EVICENT-24 GM",null,50,null,50]
["FAME 100 ML",15,null,null,15]
["FAME 10 ML",100,null,8,92]
["FAME 50 ML",6,null,1,5]
["FENOS QUICK-100 ML",null,300,null,300]
["FENOS QUICK-250 ML",null,80,2,78]
["Fenus Quick-100ml",34,null,9,25]
["Firstclass-7149 Bayer-475GM",null,126,116,10]
["FOOST 500 GM",17,240,93,164]
["INFINITO-100 ML",6,null,1,5]
["INFINITO-500 ML",16,null,1,15]
["JUMP 2GM",1249,null,476,773]
["JUMP 40 GMS",29,80,10,99]
["LARVIN 100 GMS"]
["LARVIN 250 GMS",2,null,null,2]
["LARVIN 500 GMS",39,null,3,36]
["LAUDIS 115 MLS(08 NOS)",null,480,233,247]
["LAUDIS 57.5 ML",null,10,4,6]
["MOVENTO ENERGY SC240_100 ML",7,null,null,7]
["MOVENTO ENERGY SC240_1 LTR",30,null,null,30]
["MOVENTO ENERGY SC240_250 ML",14,null,10,4]
["NATIVO 100 GMS",68,50,27,91]
["NATIVO 250 GMS",29,null,10,19]
["NATIVO 50 GMS",51,null,5,46]
["OBERON 100 ML",20,null,16,4]
["OBERON 200 ML",24,null,3,21]
["OBERON 500 ML",13,null,9,4]
["PLANOFIX 100 ML(50 NOS)",37,250,27,260]
["PLANOFIX 250 ML(40 NOS)",35,200,6,229]
["REGENT SC 1 KG/LTR(10 NOS)",32,250,36,246]
["REGENT SC 250 GMS/ML",13,100,46,67]
["REGENT SC 500 GMS/ML(20 NOS)",12,300,56,256]
["SOLOMAN 100 ML",29,300,21,308]
["SOLOMAN 250 ML",42,600,228,414]
["SOLOMAN 500 ML",null,300,165,135]
["WHIPSUPER(T) EC90_100 ML",30,null,25,5]
["WHIPSUPER(T) EC90_1 LTR",7,null,null,7]
["Grand Total",3266,9946,6110,7102]

{"sheet":"Dealer Report working","index":2,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["7517- BG II(Superb) Bayer- 475 GM",null,400,195,205,"SURPASS 7517 BGII LOC 20X450GR BAG IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["ADMIRE 150 GMS",23,60,30,53,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,"ADMIRE (T) WG70 150X30GR BOT IN",119,null,12,107]
["ADMIRE 30 GMS",119,null,12,107,"ADMIRE (T) WG70 150X30GR BOT IN",null,null,null,"ADMIRE (T) WG70 30X150GR BOT IN",23,60,30,53]
["ADMIRE 75 GMS",39,120,30,129,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,"ADMIRE (T) WG70 60X75GR BOT IN",39,120,30,129]
["AMBITION-1 LTR",175,null,8,167,"AMBITION 10X1L BOT IN",null,null,null,"AMBITION 10X1L BOT IN",175,null,8,167]
["AMBITION-250 ML",143,null,21,122,"AMBITION 40X250ML BOT IN",null,null,null,"AMBITION 20X500ML BOT IN",296,null,27,269]
["AMBITION-500 ML",296,null,27,269,"AMBITION 20X500ML BOT IN",null,null,null,"AMBITION 40X250ML BOT IN",143,null,21,122]
["ANTRACOL 1 KG(10 NOS)",10,200,80,130,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",10,200,80,130]
["ANTRACOL 250 GMS(40 NOS)",155,80,107,128,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",10,500,212,298]
["ANTRACOL 500 GMS(20 NOS)",10,500,212,298,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",155,80,107,128]
["BELT EXPERT 100 ML",10,50,5,55,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,"BELT EXPERT SC480 50X100ML BOT IN",10,50,5,55]
["BUONOS-250 ML",34,null,18,16,"BUONOS SC430 40X250ML BOT IN",null,null,null,"BUONOS SC430 20X500ML BOT IN",null,20,null,20]
["BUONOS-500 ML",null,20,null,20,"BUONOS SC430 20X500ML BOT IN",null,null,null,"BUONOS SC430 40X250ML BOT IN",34,null,18,16]
["CONFIDOR 100 ML(50 NOS)",35,1250,1062,223,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,"CONFIDOR (T) SL200 100X50ML BOT IN",29,1000,624,405]
["CONFIDOR 250 ML (20 NOS)",75,500,475,100,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN",75,500,475,100]
["CONFIDOR 50 ML",29,1000,624,405,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN",35,1250,1062,223]
["CONFIDOR SUPER 100 ML(50 NOS)",12,1000,687,325,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",53,400,267,186]
["CONFIDOR SUPER 250 ML(20 NOS)",53,400,267,186,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",12,1000,687,325]
["CONFIDOR SUPER 50 ML(50 NOS)",12,650,603,59,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",12,650,603,59]
["DECIS 100 BAYER 100 ML",14,null,null,14,"DECIS EC101-2 50X100ML BOX IN",null,null,null,"DECIS EC101-2 40X250ML BOT IN",16,null,null,16]
["DECIS-100 BAYER 250 ML",16,null,null,16,"DECIS EC101-2 40X250ML BOT IN",null,null,null,"DECIS EC101-2 50X100ML BOX IN",14,null,null,14]
["EVICENT-24 GM",null,50,null,50,"DISCOUNTINUE PRODUCT",null,null,null,"DISCOUNTINUE PRODUCT",null,50,null,50]
["FAME 100 ML",15,null,null,15,"FAME (T) SC480 20X100ML BOT IN",null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN",100,null,8,92]
["FAME 10 ML",100,null,8,92,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,"FAME (T) SC480 20X100ML BOT IN",15,null,null,15]
["FAME 50 ML",6,null,1,5,"FAME (T) SC480 40X50ML BOT IN",null,null,null,"FAME (T) SC480 40X50ML BOT IN",6,null,1,5]
["FENOS QUICK-100 ML",null,300,null,300,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,"FENOS QUICK SC150 40X250ML BOT IN",null,80,2,78]
["FENOS QUICK-250 ML",null,80,2,78,"FENOS QUICK SC150 40X250ML BOT IN",null,null,null,"FENOS QUICK SC150 50X100ML BOT IN",34,300,9,325]
["Fenus Quick-100ml",34,null,9,25,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,"FOOST WP50 24X500G BAG IN",17,240,93,164]
["Firstclass-7149 Bayer-475GM",null,126,116,10,"SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN",null,null,null,"INFINITO SC687 5 20X500ML BOT IN",16,null,1,15]
["FOOST 500 GM",17,240,93,164,"FOOST WP50 24X500G BAG IN",null,null,null,"INFINITO SC687 5 50X100ML BOT IN",6,null,1,5]
["INFINITO-100 ML",6,null,1,5,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,"JUMP WG80 160X(10X2GR) BAG IN",1249,null,476,773]
["INFINITO-500 ML",16,null,1,15,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,"JUMP WG80 80X40GR BAG IN",29,80,10,99]
["JUMP 2GM",1249,null,476,773,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,"LARVIN (T) WP75 20X250GR BAG IN",2,null,null,2]
["JUMP 40 GMS",29,80,10,99,"JUMP WG80 80X40GR BAG IN",null,null,null,"LARVIN (T) WP75 20X500GR BAG IN",39,null,3,36]
["LARVIN 100 GMS",null,null,null,null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,"LARVIN (T) WP75 40X100GR BAG IN"]
["LARVIN 250 GMS",2,null,null,2,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,"LAUDIS SC630 10X57.5ML BOT IN",null,10,4,6]
["LARVIN 500 GMS",39,null,3,36,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN",null,480,233,247]
["LAUDIS 115 MLS(08 NOS)",null,480,233,247,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 10X1L BOT IN",30,null,null,30]
["LAUDIS 57.5 ML",null,10,4,6,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",14,null,10,4]
["MOVENTO ENERGY SC240_100 ML",7,null,null,7,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 50X100ML BOT IN",7,null,null,7]
["MOVENTO ENERGY SC240_1 LTR",30,null,null,30,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,"NATIVO WG75 100X50GR BAG IN",51,null,5,46]
["MOVENTO ENERGY SC240_250 ML",14,null,10,4,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",29,null,10,19]
["NATIVO 100 GMS",68,50,27,91,"NATIVO WG75 50X100GR BAG IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",68,50,27,91]
["NATIVO 250 GMS",29,null,10,19,"NATIVO WG75 40X250GR BAG IN",null,null,null,"OBERON (T) SC240 20X500ML BOT IN",13,null,9,4]
["NATIVO 50 GMS",51,null,5,46,"NATIVO WG75 100X50GR BAG IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",24,null,3,21]
["OBERON 100 ML",20,null,16,4,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN",20,null,16,4]
["OBERON 200 ML",24,null,3,21,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",35,200,6,229]
["OBERON 500 ML",13,null,9,4,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",37,250,27,260]
["PLANOFIX 100 ML(50 NOS)",37,250,27,260,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 10X1L BOT IN",32,250,36,246]
["PLANOFIX 250 ML(40 NOS)",35,200,6,229,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"REGENT (T) SC50 20X250ML BOT IN",13,100,46,67]
["REGENT SC 1 KG/LTR(10 NOS)",32,250,36,246,"REGENT (T) SC50 10X1L BOT IN",null,null,null,"REGENT (T) SC50 20X500ML BOT IN",12,300,56,256]
["REGENT SC 250 GMS/ML",13,100,46,67,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,"SOLOMON OD300 20X500ML BOT IN",null,300,165,135]
["REGENT SC 500 GMS/ML(20 NOS)",12,300,56,256,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN",42,600,228,414]
["SOLOMAN 100 ML",29,300,21,308,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"SOLOMON OD300 50X100ML BOT IN",29,300,21,308]
["SOLOMAN 250 ML",42,600,228,414,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"SURPASS 7517 BGII LOC 20X450GR BAG IN",null,400,195,205]
["SOLOMAN 500 ML",null,300,165,135,"SOLOMON OD300 20X500ML BOT IN",null,null,null,"SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN",null,126,116,10]
["WHIPSUPER(T) EC90_100 ML",30,null,25,5,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 10X1L BOT IN",7,null,null,7]
["WHIPSUPER(T) EC90_1 LTR",7,null,null,7,"WHIPSUPER (T) EC90 10X1L BOT IN",null,null,null,"WHIPSUPER (T) EC90 50X100ML BOT IN",30,null,25,5]
[null,null,null,null,null,null,null,null,null,"Grand Total",3266,9946,6110,7102]

{"sheet":"Master","index":3,"n_rows":59,"n_cols":2,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["7517- BG II(Superb) Bayer- 475 GM","SURPASS 7517 BGII LOC 20X450GR BAG IN"]
["ADMIRE 150 GMS","ADMIRE (T) WG70 30X150GR BOT IN"]
["ADMIRE 30 GMS","ADMIRE (T) WG70 150X30GR BOT IN"]
["ADMIRE 75 GMS","ADMIRE (T) WG70 60X75GR BOT 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(10 NOS)","ANTRACOL (T) WP70 10X1KG BAG IN"]
["ANTRACOL 250 GMS(40 NOS)","ANTRACOL (T) WP70 40X250GR BAG IN"]
["ANTRACOL 500 GMS(20 NOS)","ANTRACOL (T) WP70 20X500GR BAG IN"]
["BELT EXPERT 100 ML","BELT EXPERT SC480 50X100ML BOT IN"]
["BUONOS-250 ML","BUONOS SC430 40X250ML BOT IN"]
["BUONOS-500 ML","BUONOS SC430 20X500ML BOT IN"]
["CONFIDOR 100 ML(50 NOS)","CONFIDOR (T) SL200 50X100ML BOT IN"]
["CONFIDOR 250 ML (20 NOS)","CONFIDOR (T) SL200 20X250ML BOT IN"]
["CONFIDOR 50 ML","CONFIDOR (T) SL200 100X50ML BOT IN"]
["CONFIDOR SUPER 100 ML(50 NOS)","CONFIDOR SUPER (T) SC350 50X100ML BOT IN"]
["CONFIDOR SUPER 250 ML(20 NOS)","CONFIDOR SUPER (T) SC350 20X250ML BOT IN"]
["CONFIDOR SUPER 50 ML(50 NOS)","CONFIDOR SUPER (T) SC350 50X50ML BOT IN"]
["DECIS 100 BAYER 100 ML","DECIS EC101-2 50X100ML BOX IN"]
["DECIS-100 BAYER 250 ML","DECIS EC101-2 40X250ML BOT IN"]
["EVICENT-24 GM","DISCOUNTINUE PRODUCT"]
["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"]
["FENOS QUICK-100 ML","FENOS QUICK SC150 50X100ML BOT IN"]
["FENOS QUICK-250 ML","FENOS QUICK SC150 40X250ML BOT IN"]
["Fenus Quick-100ml","FENOS QUICK SC150 50X100ML BOT IN"]
["Firstclass-7149 Bayer-475GM","SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN"]
["FOOST 500 GM","FOOST WP50 24X500G BAG IN"]
["INFINITO-100 ML","INFINITO SC687 5 50X100ML BOT IN"]
["INFINITO-500 ML","INFINITO SC687 5 20X500ML BOT IN"]
["JUMP 2GM","JUMP WG80 160X(10X2GR) BAG IN"]
["JUMP 40 GMS","JUMP WG80 80X40GR BAG IN"]
["LARVIN 100 GMS","LARVIN (T) WP75 40X100GR BAG IN"]
["LARVIN 250 GMS","LARVIN (T) WP75 20X250GR BAG IN"]
["LARVIN 500 GMS","LARVIN (T) WP75 20X500GR BAG IN"]
["LAUDIS 115 MLS(08 NOS)","LAUDIS SC630 8X115ML BOT IN"]
["LAUDIS 57.5 ML","LAUDIS SC630 10X57.5ML BOT IN"]
["MOVENTO ENERGY SC240_100 ML","MOVENTO ENERGY SC240 50X100ML BOT IN"]
["MOVENTO ENERGY SC240_1 LTR","MOVENTO ENERGY SC240 10X1L BOT IN"]
["MOVENTO ENERGY SC240_250 ML","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["NATIVO 100 GMS","NATIVO WG75 50X100GR BAG IN"]
["NATIVO 250 GMS","NATIVO WG75 40X250GR BAG IN"]
["NATIVO 50 GMS","NATIVO WG75 100X50GR BAG IN"]
["OBERON 100 ML","OBERON (T) SC240 50X100ML BOT IN"]
["OBERON 200 ML","OBERON (T) SC240 40X200ML BOT IN"]
["OBERON 500 ML","OBERON (T) SC240 20X500ML BOT IN"]
["PLANOFIX 100 ML(50 NOS)","PLANOFIX SL4 5 50X100ML BOT IN"]
["PLANOFIX 250 ML(40 NOS)","PLANOFIX SL4 5 40X250ML BOT IN"]
["REGENT SC 1 KG/LTR(10 NOS)","REGENT (T) SC50 10X1L BOT IN"]
["REGENT SC 250 GMS/ML","REGENT (T) SC50 20X250ML BOT IN"]
["REGENT SC 500 GMS/ML(20 NOS)","REGENT (T) SC50 20X500ML BOT IN"]
["SOLOMAN 100 ML","SOLOMON OD300 50X100ML BOT IN"]
["SOLOMAN 250 ML","SOLOMON OD300 40X250ML BOT IN"]
["SOLOMAN 500 ML","SOLOMON OD300 20X500ML BOT IN"]
["WHIPSUPER(T) EC90_100 ML","WHIPSUPER (T) EC90 50X100ML BOT IN"]
["WHIPSUPER(T) EC90_1 LTR","WHIPSUPER (T) EC90 10X1L BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":60,"n_cols":14,"rows_kept":60,"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,119,0,0,12,0,0,0,0,107]
[null,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,23,60,0,30,0,0,0,0,53]
[null,"ADMIRE (T) WG70 60X75GR BOT IN",null,null,null,39,120,0,30,0,0,0,0,129]
[null,"AMBITION 10X1L BOT IN",null,null,null,175,0,0,8,0,0,0,0,167]
[null,"AMBITION 20X500ML BOT IN",null,null,null,296,0,0,27,0,0,0,0,269]
[null,"AMBITION 40X250ML BOT IN",null,null,null,143,0,0,21,0,0,0,0,122]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,10,200,0,80,0,0,0,0,130]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,10,500,0,212,0,0,0,0,298]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,155,80,0,107,0,0,0,0,128]
[null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,10,50,0,5,0,0,0,0,55]
[null,"BUONOS SC430 20X500ML BOT IN",null,null,null,0,20,0,0,0,0,0,0,20]
[null,"BUONOS SC430 40X250ML BOT IN",null,null,null,34,0,0,18,0,0,0,0,16]
[null,"CONFIDOR (T) SL200 100X50ML BOT IN",null,null,null,29,1000,0,624,0,0,0,0,405]
[null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,75,500,0,475,0,0,0,0,100]
[null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,35,1250,0,1062,0,0,0,0,223]
[null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,53,400,0,267,0,0,0,0,186]
[null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,12,1000,0,687,0,0,0,0,325]
[null,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",null,null,null,12,650,0,603,0,0,0,0,59]
[null,"DECIS EC101-2 40X250ML BOT IN",null,null,null,16,0,0,0,0,0,0,0,16]
[null,"DECIS EC101-2 50X100ML BOX IN",null,null,null,14,0,0,0,0,0,0,0,14]
[null,"DISCOUNTINUE PRODUCT",null,null,null,0,50,0,0,0,0,0,0,50]
[null,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,100,0,0,8,0,0,0,0,92]
[null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,15,0,0,0,0,0,0,0,15]
[null,"FAME (T) SC480 40X50ML BOT IN",null,null,null,6,0,0,1,0,0,0,0,5]
[null,"FENOS QUICK SC150 40X250ML BOT IN",null,null,null,0,80,0,2,0,0,0,0,78]
[null,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,34,300,0,9,0,0,0,0,325]
[null,"FOOST WP50 24X500G BAG IN",null,null,null,17,240,0,93,0,0,0,0,164]
[null,"INFINITO SC687 5 20X500ML BOT IN",null,null,null,16,0,0,1,0,0,0,0,15]
[null,"INFINITO SC687 5 50X100ML BOT IN",null,null,null,6,0,0,1,0,0,0,0,5]
[null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,1249,0,0,476,0,0,0,0,773]
[null,"JUMP WG80 80X40GR BAG IN",null,null,null,29,80,0,10,0,0,0,0,99]
[null,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,2,0,0,0,0,0,0,0,2]
[null,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,39,0,0,3,0,0,0,0,36]
[null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"LAUDIS SC630 10X57.5ML BOT IN",null,null,null,0,10,0,4,0,0,0,0,6]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,0,480,0,233,0,0,0,0,247]
[null,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,30,0,0,0,0,0,0,0,30]
[null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,14,0,0,10,0,0,0,0,4]
[null,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,7,0,0,0,0,0,0,0,7]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,51,0,0,5,0,0,0,0,46]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,29,0,0,10,0,0,0,0,19]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,68,50,0,27,0,0,0,0,91]
[null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,13,0,0,9,0,0,0,0,4]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,24,0,0,3,0,0,0,0,21]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,20,0,0,16,0,0,0,0,4]
[null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,35,200,0,6,0,0,0,0,229]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,37,250,0,27,0,0,0,0,260]
[null,"REGENT (T) SC50 10X1L BOT IN",null,null,null,32,250,0,36,0,0,0,0,246]
[null,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,13,100,0,46,0,0,0,0,67]
[null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,12,300,0,56,0,0,0,0,256]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,0,300,0,165,0,0,0,0,135]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,42,600,0,228,0,0,0,0,414]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,29,300,0,21,0,0,0,0,308]
[null,"SURPASS 7517 BGII LOC 20X450GR BAG IN",null,null,null,0,400,0,195,0,0,0,0,205]
[null,"SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN",null,null,null,0,126,0,116,0,0,0,0,10]
[null,"WHIPSUPER (T) EC90 10X1L BOT IN",null,null,null,7,0,0,0,0,0,0,0,7]
[null,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,null,null,30,0,0,25,0,0,0,0,5]
[null,"Grand Total",null,null,null,3266,9946,0,6110,0,0,0,0,7102]

{"sheet":"Zylem SNS Report","index":5,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[5,0,5,12],[6,0,6,12],[1,0,1,12],[3,0,3,12],[4,0,4,12]]}
[]
["Company Name:-BAYER"]
["Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Jul-2021"]
["Generated on 8/18/2021 7:48:01 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Khandelwal Krushi Kendra,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Khandelwal Krushi Kendra",4434413,"ADMIRE (T) WG70 150X30GR BOT IN",79234988,119,0,0,12,0,0,0,0,107]
["Khandelwal Krushi Kendra",4434413,"ADMIRE (T) WG70 30X150GR BOT IN",79277857,23,60,0,30,0,0,0,0,53]
["Khandelwal Krushi Kendra",4434413,"ADMIRE (T) WG70 60X75GR BOT IN",79297696,39,120,0,30,0,0,0,0,129]
["Khandelwal Krushi Kendra",4434413,"ALIETTE WP80 20X500GR BAG IN",3822366,0,0,0,6,0,0,0,0,-6]
["Khandelwal Krushi Kendra",4434413,"AMBITION 10X1L BOT IN",86212544,175,0,0,8,0,0,0,0,167]
["Khandelwal Krushi Kendra",4434413,"AMBITION 20X500ML BOT IN",86228564,296,0,0,27,0,0,0,0,269]
["Khandelwal Krushi Kendra",4434413,"AMBITION 40X250ML BOT IN",86232308,143,0,0,21,0,0,0,0,122]
["Khandelwal Krushi Kendra",4434413,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,10,200,0,80,0,0,0,0,130]
["Khandelwal Krushi Kendra",4434413,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,10,500,0,212,0,0,0,0,298]
["Khandelwal Krushi Kendra",4434413,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,155,80,0,107,0,0,0,0,128]
["Khandelwal Krushi Kendra",4434413,"BELT EXPERT SC480 50X100ML BOT IN",79722869,10,50,0,5,0,0,0,0,55]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR (T) SL200 100X50ML BOT IN",5708361,29,1000,0,624,0,0,0,0,405]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR (T) SL200 20X250ML BOT IN",5699494,75,500,0,475,0,0,0,0,100]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR (T) SL200 50X100ML BOT IN",5703475,35,1250,0,1062,0,0,0,0,223]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",79710852,53,400,0,267,0,0,0,0,186]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",79735219,12,1000,0,687,0,0,0,0,325]
["Khandelwal Krushi Kendra",4434413,"CONFIDOR SUPER (T) SC350 50X50ML BOT IN",79985169,12,650,0,603,0,0,0,0,59]
["Khandelwal Krushi Kendra",4434413,"ETHREL SL39 50X100ML BOT IN",4299026,0,0,0,1,0,0,0,0,-1]
["Khandelwal Krushi Kendra",4434413,"FAME (T) SC480 10X(20X10ML) BOT IN",79305885,100,0,0,8,0,0,0,0,92]
["Khandelwal Krushi Kendra",4434413,"FAME (T) SC480 20X100ML BOT IN",79266197,15,0,0,0,0,0,0,0,15]
["Khandelwal Krushi Kendra",4434413,"FAME (T) SC480 40X50ML BOT IN",79224699,6,0,0,1,0,0,0,0,5]
["Khandelwal Krushi Kendra",4434413,"FENOS QUICK SC150 40X250ML BOT IN",81016984,0,80,0,2,0,0,0,0,78]
["Khandelwal Krushi Kendra",4434413,"FENOS QUICK SC150 50X100ML BOT IN",80942990,34,300,0,9,0,0,0,0,325]
["Khandelwal Krushi Kendra",4434413,"FOOST WP50 24X500G BAG IN",85811770,17,240,0,93,0,0,0,0,164]
["Khandelwal Krushi Kendra",4434413,"INFINITO SC687 5 20X500ML BOT IN",79641176,16,0,0,1,0,0,0,0,15]
["Khandelwal Krushi Kendra",4434413,"INFINITO SC687 5 50X100ML BOT IN",79632487,6,0,0,1,0,0,0,0,5]
["Khandelwal Krushi Kendra",4434413,"JUMP WG80 160X(10X2GR) BAG IN",79215304,1249,0,0,476,0,0,0,0,773]
["Khandelwal Krushi Kendra",4434413,"JUMP WG80 80X40GR BAG IN",79267509,29,80,0,10,0,0,0,0,99]
["Khandelwal Krushi Kendra",4434413,"LARVIN (T) WP75 20X250GR BAG IN",6003167,2,0,0,0,0,0,0,0,2]
["Khandelwal Krushi Kendra",4434413,"LARVIN (T) WP75 20X500GR BAG IN",6005291,39,0,0,3,0,0,0,0,36]
["Khandelwal Krushi Kendra",4434413,"LAUDIS SC630 10X57.5ML BOT IN",84470481,0,10,0,4,0,0,0,0,6]
["Khandelwal Krushi Kendra",4434413,"LAUDIS SC630 8X115ML BOT IN",80491085,0,480,0,233,0,0,0,0,247]
["Khandelwal Krushi Kendra",4434413,"MOVENTO ENERGY SC240 10X1L BOT IN",79556837,30,0,0,0,0,0,0,0,30]
["Khandelwal Krushi Kendra",4434413,"MOVENTO ENERGY SC240 40X250ML BOT IN",79679505,14,0,0,10,0,0,0,0,4]
["Khandelwal Krushi Kendra",4434413,"MOVENTO ENERGY SC240 50X100ML BOT IN",79722605,7,0,0,0,0,0,0,0,7]
["Khandelwal Krushi Kendra",4434413,"NATIVO WG75 100X50GR BAG IN",80580061,51,0,0,5,0,0,0,0,46]
["Khandelwal Krushi Kendra",4434413,"NATIVO WG75 40X250GR BAG IN",79237790,29,0,0,10,0,0,0,0,19]
["Khandelwal Krushi Kendra",4434413,"NATIVO WG75 50X100GR BAG IN",79304102,68,50,0,27,0,0,0,0,91]
["Khandelwal Krushi Kendra",4434413,"OBERON (T) SC240 20X500ML BOT IN",80026471,13,0,0,9,0,0,0,0,4]
["Khandelwal Krushi Kendra",4434413,"OBERON (T) SC240 40X200ML BOT IN",79971362,24,0,0,3,0,0,0,0,21]
["Khandelwal Krushi Kendra",4434413,"OBERON (T) SC240 50X100ML BOT IN",79998538,20,0,0,16,0,0,0,0,4]
["Khandelwal Krushi Kendra",4434413,"PLANOFIX SL4 5 40X250ML BOT IN",3825128,35,200,0,6,0,0,0,0,229]
["Khandelwal Krushi Kendra",4434413,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,37,250,0,27,0,0,0,0,260]
["Khandelwal Krushi Kendra",4434413,"REGENT (T) SC50 20X250ML BOT IN",5976951,13,100,0,46,0,0,0,0,67]
["Khandelwal Krushi Kendra",4434413,"REGENT (T) SC50 20X500ML BOT IN",5987678,12,300,0,56,0,0,0,0,256]
["Khandelwal Krushi Kendra",4434413,"SOLOMON OD300 20X500ML BOT IN",79987870,0,300,0,165,0,0,0,0,135]
["Khandelwal Krushi Kendra",4434413,"SOLOMON OD300 40X250ML BOT IN",79706723,42,600,0,228,0,0,0,0,414]
["Khandelwal Krushi Kendra",4434413,"SOLOMON OD300 50X100ML BOT IN",79641931,29,300,0,21,0,0,0,0,308]
["Khandelwal Krushi Kendra",4434413,"WHIPSUPER (T) EC90 10X1L BOT IN",5972697,7,0,0,0,0,0,0,0,7]
["Khandelwal Krushi Kendra",4434413,"WHIPSUPER (T) EC90 50X100ML BOT IN",5994151,30,0,0,25,0,0,0,0,5]
["Khandelwal Krushi Kendra",4434413,"SURPASS 7517 BGII LOC 20X450GR BAG IN",80891601,0,400,0,315,120,0,0,0,205]
["Khandelwal Krushi Kendra",4434413,"DECIS EC101-2 50X100ML BOX IN",6103692,14,0,0,0,0,0,0,0,14]
["Khandelwal Krushi Kendra",4434413,"DECIS EC101-2 40X250ML BOT IN",3823281,16,0,0,0,0,0,0,0,16]
["Khandelwal Krushi Kendra",4434413,"BUONOS SC430 40X250ML BOT IN",86224801,34,0,0,18,0,0,0,0,16]
["Khandelwal Krushi Kendra",4434413,"BUONOS SC430 20X500ML BOT IN",86254468,0,20,0,0,0,0,0,0,20]
["Khandelwal Krushi Kendra",4434413,"REGENT (T) SC50 10X1L BOT IN",5962667,32,250,0,37,1,0,0,0,246]
["Khandelwal Krushi Kendra",4434413,"SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN",86737310,0,100,0,116,0,0,0,0,-16]
["GRANDTOTAL",null,null,null,3266,9870,0,6238,121,0,0,0,7019]

{"sheet":"OPG","index":6,"n_rows":58,"n_cols":3,"rows_kept":58,"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},119]
["ADMIRE (T) WG70 30X150GR BOT IN",{"$f":"VLOOKUP(A2,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":14},23]
["ADMIRE (T) WG70 60X75GR BOT IN",{"$f":"VLOOKUP(A3,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":15},39]
["ALIETTE WP80 20X500GR BAG IN",{"$f":"VLOOKUP(A4,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":34},0]
["AMBITION 10X1L BOT IN",{"$f":"VLOOKUP(A5,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":39},175]
["AMBITION 20X500ML BOT IN",{"$f":"VLOOKUP(A6,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":40},296]
["AMBITION 40X250ML BOT IN",{"$f":"VLOOKUP(A7,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":41},143]
["ANTRACOL (T) WP70 10X1KG BAG IN",{"$f":"VLOOKUP(A8,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":42},10]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A9,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":43},10]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A10,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":44},155]
["BELT EXPERT SC480 50X100ML BOT IN",{"$f":"VLOOKUP(A11,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":111},10]
["CONFIDOR (T) SL200 100X50ML BOT IN",{"$f":"VLOOKUP(A12,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":112},29]
["CONFIDOR (T) SL200 20X250ML BOT IN",{"$f":"VLOOKUP(A13,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":114},75]
["CONFIDOR (T) SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A14,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":116},35]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",{"$f":"VLOOKUP(A15,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":118},53]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",{"$f":"VLOOKUP(A16,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":120},12]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",{"$f":"VLOOKUP(A17,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":121},12]
["ETHREL SL39 50X100ML BOT IN",{"$f":"VLOOKUP(A18,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":138},0]
["FAME (T) SC480 10X(20X10ML) BOT IN",{"$f":"VLOOKUP(A19,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":144},100]
["FAME (T) SC480 40X50ML BOT IN",{"$f":"VLOOKUP(A20,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":146},6]
["FENOS QUICK SC150 40X250ML BOT IN",{"$f":"VLOOKUP(A21,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":151},0]
["FENOS QUICK SC150 50X100ML BOT IN",{"$f":"VLOOKUP(A22,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":152},34]
["FOOST WP50 24X500G BAG IN",{"$f":"VLOOKUP(A23,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":177},17]
["INFINITO SC687 5 20X500ML BOT IN",{"$f":"VLOOKUP(A24,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":195},16]
["INFINITO SC687 5 50X100ML BOT IN",{"$f":"VLOOKUP(A25,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":197},6]
["JUMP WG80 160X(10X2GR) BAG IN",{"$f":"VLOOKUP(A26,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":199},1249]
["JUMP WG80 80X40GR BAG IN",{"$f":"VLOOKUP(A27,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":202},29]
["LARVIN (T) WP75 20X500GR BAG IN",{"$f":"VLOOKUP(A28,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":206},39]
["LAUDIS SC630 10X57.5ML BOT IN",{"$f":"VLOOKUP(A29,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":210},0]
["LAUDIS SC630 8X115ML BOT IN",{"$f":"VLOOKUP(A30,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":212},0]
["MOVENTO ENERGY SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A31,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":273},14]
["NATIVO WG75 100X50GR BAG IN",{"$f":"VLOOKUP(A32,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":289},51]
["NATIVO WG75 40X250GR BAG IN",{"$f":"VLOOKUP(A33,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":293},29]
["NATIVO WG75 50X100GR BAG IN",{"$f":"VLOOKUP(A34,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":294},68]
["OBERON (T) SC240 20X500ML BOT IN",{"$f":"VLOOKUP(A35,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":297},13]
["OBERON (T) SC240 40X200ML BOT IN",{"$f":"VLOOKUP(A36,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":299},24]
["OBERON (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A37,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":300},20]
["PLANOFIX SL4 5 40X250ML BOT IN",{"$f":"VLOOKUP(A38,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":306},35]
["PLANOFIX SL4 5 50X100ML BOT IN",{"$f":"VLOOKUP(A39,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":307},37]
["REGENT (T) SC50 20X250ML BOT IN",{"$f":"VLOOKUP(A40,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":325},13]
["REGENT (T) SC50 20X500ML BOT IN",{"$f":"VLOOKUP(A41,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":326},12]
["SOLOMON OD300 20X500ML BOT IN",{"$f":"VLOOKUP(A42,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":366},0]
["SOLOMON OD300 40X250ML BOT IN",{"$f":"VLOOKUP(A43,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":368},42]
["SOLOMON OD300 50X100ML BOT IN",{"$f":"VLOOKUP(A44,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":370},29]
["WHIPSUPER (T) EC90 50X100ML BOT IN",{"$f":"VLOOKUP(A45,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":406},30]
["SURPASS 7517 BGII LOC 20X450GR BAG IN",{"$f":"VLOOKUP(A46,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":384},0]
["BUONOS SC430 40X250ML BOT IN",{"$f":"VLOOKUP(A47,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1397},34]
["BUONOS SC430 20X500ML BOT IN",{"$f":"VLOOKUP(A48,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1396},0]
["REGENT (T) SC50 10X1L BOT IN",{"$f":"VLOOKUP(A49,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":324},32]
["SURPASS FC 7149 BG2 (RIB) 20X475G BAG IN",{"$f":"VLOOKUP(A50,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1839},0]
["DECIS EC101-2 40X250ML BOT IN",{"$f":"VLOOKUP(A51,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":925},16]
["DECIS EC101-2 50X100ML BOX IN",{"$f":"VLOOKUP(A52,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":924},14]
["FAME (T) SC480 20X100ML BOT IN",{"$f":"VLOOKUP(A53,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":145},15]
["LARVIN (T) WP75 20X250GR BAG IN",{"$f":"VLOOKUP(A54,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":205},2]
["LARVIN (T) WP75 40X100GR BAG IN",{"$f":"VLOOKUP(A55,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":207},0]
["MOVENTO ENERGY SC240 10X1L BOT IN",{"$f":"VLOOKUP(A56,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":271},30]
["MOVENTO ENERGY SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A57,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":274},7]
["WHIPSUPER (T) EC90 10X1L BOT IN",{"$f":"VLOOKUP(A58,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":403},7]

{"sheet":"Reco","index":7,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -01-Apr-2021 TO 31-Jul-2021",null,null,null,null,null,null,null,null,"Dealer Report -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",119,0,0,12,0,0,0,0,107,119,0,0,12,0,0,0,0,107,0,0,0,0,0,0,0,0,0,"Ok"]
["ADMIRE (T) WG70 30X150GR BOT IN",23,60,0,30,0,0,0,0,53,23,60,0,30,0,0,0,0,53,0,0,0,0,0,0,0,0,0,"Ok"]
["ADMIRE (T) WG70 60X75GR BOT IN",39,120,0,30,0,0,0,0,129,39,120,0,30,0,0,0,0,129,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 10X1L BOT IN",175,0,0,8,0,0,0,0,167,175,0,0,8,0,0,0,0,167,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 20X500ML BOT IN",296,0,0,27,0,0,0,0,269,296,0,0,27,0,0,0,0,269,0,0,0,0,0,0,0,0,0,"Ok"]
["AMBITION 40X250ML BOT IN",143,0,0,21,0,0,0,0,122,143,0,0,21,0,0,0,0,122,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",10,200,0,80,0,0,0,0,130,10,200,0,80,0,0,0,0,130,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",10,500,0,212,0,0,0,0,298,10,500,0,212,0,0,0,0,298,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",155,80,0,107,0,0,0,0,128,155,80,0,107,0,0,0,0,128,0,0,0,0,0,0,0,0,0,"Ok"]
["BELT EXPERT SC480 50X100ML BOT IN",10,50,0,5,0,0,0,0,55,10,50,0,5,0,0,0,0,55,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 100X50ML BOT IN",29,1000,0,624,0,0,0,0,405,29,1000,0,624,0,0,0,0,405,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X250ML BOT IN",75,500,0,475,0,0,0,0,100,75,500,0,475,0,0,0,0,100,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 50X100ML BOT IN",35,1250,0,1062,0,0,0,0,223,35,1250,0,1062,0,0,0,0,223,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",53,400,0,267,0,0,0,0,186,53,400,0,267,0,0,0,0,186,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",12,1000,0,687,0,0,0,0,325,12,1000,0,687,0,0,0,0,325,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X50ML BOT IN",12,650,0,603,0,0,0,0,59,12,650,0,603,0,0,0,0,59,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 10X(20X10ML) BOT IN",100,0,0,8,0,0,0,0,92,100,0,0,8,0,0,0,0,92,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 20X100ML BOT IN",15,0,0,0,0,0,0,0,15,15,0,0,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 40X50ML BOT IN",6,0,0,1,0,0,0,0,5,6,0,0,1,0,0,0,0,5,0,0,0,0,0,0,0,0,0,"Ok"]
["FENOS QUICK SC150 40X250ML BOT IN",0,80,0,2,0,0,0,0,78,0,80,0,2,0,0,0,0,78,0,0,0,0,0,0,0,0,0,"Ok"]
["FENOS QUICK SC150 50X100ML BOT IN",34,300,0,9,0,0,0,0,325,34,300,0,9,0,0,0,0,325,0,0,0,0,0,0,0,0,0,"Ok"]
["FOOST WP50 24X500G BAG IN",17,240,0,93,0,0,0,0,164,17,240,0,93,0,0,0,0,164,0,0,0,0,0,0,0,0,0,"Ok"]
["INFINITO SC687 5 20X500ML BOT IN",16,0,0,1,0,0,0,0,15,16,0,0,1,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["INFINITO SC687 5 50X100ML BOT IN",6,0,0,1,0,0,0,0,5,6,0,0,1,0,0,0,0,5,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 160X(10X2GR) BAG IN",1249,0,0,476,0,0,0,0,773,1249,0,0,476,0,0,0,0,773,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 80X40GR BAG IN",29,80,0,10,0,0,0,0,99,29,80,0,10,0,0,0,0,99,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X250GR BAG IN",2,0,0,0,0,0,0,0,2,2,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X500GR BAG IN",39,0,0,3,0,0,0,0,36,39,0,0,3,0,0,0,0,36,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 10X57.5ML BOT IN",0,10,0,4,0,0,0,0,6,0,10,0,4,0,0,0,0,6,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 8X115ML BOT IN",0,480,0,233,0,0,0,0,247,0,480,0,233,0,0,0,0,247,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 10X1L BOT IN",30,0,0,0,0,0,0,0,30,30,0,0,0,0,0,0,0,30,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 40X250ML BOT IN",14,0,0,10,0,0,0,0,4,14,0,0,10,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 50X100ML BOT IN",7,0,0,0,0,0,0,0,7,7,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR BAG IN",51,0,0,5,0,0,0,0,46,51,0,0,5,0,0,0,0,46,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",29,0,0,10,0,0,0,0,19,29,0,0,10,0,0,0,0,19,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",68,50,0,27,0,0,0,0,91,68,50,0,27,0,0,0,0,91,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 20X500ML BOT IN",13,0,0,9,0,0,0,0,4,13,0,0,9,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",24,0,0,3,0,0,0,0,21,24,0,0,3,0,0,0,0,21,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",20,0,0,16,0,0,0,0,4,20,0,0,16,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 40X250ML BOT IN",35,200,0,6,0,0,0,0,229,35,200,0,6,0,0,0,0,229,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",37,250,0,27,0,0,0,0,260,37,250,0,27,0,0,0,0,260,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X250ML BOT IN",13,100,0,46,0,0,0,0,67,13,100,0,46,0,0,0,0,67,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X500ML BOT IN",12,300,0,56,0,0,0,0,256,12,300,0,56,0,0,0,0,256,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 20X500ML BOT IN",0,300,0,165,0,0,0,0,135,0,300,0,165,0,0,0,0,135,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 40X250ML BOT IN",42,600,0,228,0,0,0,0,414,42,600,0,228,0,0,0,0,414,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 50X100ML BOT IN",29,300,0,21,0,0,0,0,308,29,300,0,21,0,0,0,0,308,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 10X1L BOT IN",7,0,0,0,0,0,0,0,7,7,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 50X100ML BOT IN",30,0,0,25,0,0,0,0,5,30,0,0,25,0,0,0,0,5,0,0,0,0,0,0,0,0,0,"Ok"]
["SURPASS 7517 BGII LOC 20X450GR BAG IN",0,400,0,315,120,0,0,0,205,0,400,0,195,0,0,0,0,205,0,0,0,120,120,0,0,0,0,"Ok"]
["DECIS EC101-2 50X100ML BOX 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"]
["DECIS EC101-2 40X250ML BOT 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"]
["BUONOS SC430 40X250ML BOT IN",34,0,0,18,0,0,0,0,16,34,0,0,18,0,0,0,0,16,0,0,0,0,0,0,0,0,0,"Ok"]
["BUONOS SC430 20X500ML BOT IN",0,20,0,0,0,0,0,0,20,0,20,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 10X1L BOT IN",32,250,0,37,1,0,0,0,246,32,250,0,36,0,0,0,0,246,0,0,0,1,1,0,0,0,0,"Ok"]
["LARVIN (T) WP75 40X100GR 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",{"$f":"SUM(B4:B58)","v":3266},{"$f":"SUM(C4:C58)","v":9770},{"$f":"SUM(D4:D58)","v":0},{"$f":"SUM(E4:E58)","v":6115},{"$f":"SUM(F4:F58)","v":121},{"$f":"SUM(G4:G58)","v":0},{"$f":"SUM(H4:H58)","v":0},{"$f":"SUM(I4:I58)","v":0},{"$f":"SUM(J4:J58)","v":7042},{"$f":"SUM(K4:K58)","v":3266},{"$f":"SUM(L4:L58)","v":9770},{"$f":"SUM(M4:M58)","v":0},{"$f":"SUM(N4:N58)","v":5994},{"$f":"SUM(O4:O58)","v":0},{"$f":"SUM(P4:P58)","v":0},{"$f":"SUM(Q4:Q58)","v":0},{"$f":"SUM(R4:R58)","v":0},{"$f":"SUM(S4:S58)","v":7042},{"$f":"SUM(T4:T58)","v":0},{"$f":"SUM(U4:U58)","v":0},{"$f":"SUM(V4:V58)","v":0},{"$f":"SUM(W4:W58)","v":121},{"$f":"SUM(X4:X58)","v":121},{"$f":"SUM(Y4:Y58)","v":0},{"$f":"SUM(Z4:Z58)","v":0},{"$f":"SUM(AA4:AA58)","v":0},{"$f":"SUM(AB4:AB58)","v":0}]