{"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,"Bhagwati Fertilizers"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 30-Jun-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Bhagwati Fertilizer"]
["Shop No.197A New Green Markit"]
["Kurukshetra"]
["Pest.Licence No. 2021/p"]
["Ferti.Licence No.2371/R/KKR"]
["SEED LICENCE NO.1145/SEED/KKR"]
["GST/UIN- 06AAKFB2076R1ZY"]
["Contact : 9466368300"]
["BAYER"]
["Stock Summary"]
["1-Apr-2021 to 30-Jun-2021"]
["","BAYER"]
["","Bhagwati Fertilizer"]
["Particulars","1-Apr-2021 to 30-Jun-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["ANTRACOL 1 KG",0,100,0,100]
["ANTRACOL 500 GM",22,0,16,6]
["BELT EXPERT 100 ML",0,50,0,50]
["BUONOS 1 LTR",35,0,0,35]
["BUONOS 500 ML",6.5,0,0,6.5]
["COUNCIL ACTIV 90 GM",0,60,0,60]
["DECIS 100 250 ML",0.75,0,0,0.75]
["ETHREL 100 ML",0,50,0,50]
["FAME 100 ML",3.6,0,3.6,0]
["GLAMORE 100 GM",28,0,28,0]
["GLAMORE 250 GM",8,0,8,0]
["GLAMORE 50 GM",22,0,22,0]
["GOUCHO 100 ML",50,0,0,50]
["LAUDIS 115 ML",5,0,3,2]
["LESENTA 100 GM",13.5,0,13,0.5]
["MOMI JI",67,0,67,0]
["MONCERN 1 LTR",10,0,10,0]
["MONCERN 500 ML",29,0,29,0]
["MOVENTO 250 ML",5,0,5,0]
["NATIVO 1 KG",68,0,5,63]
["NATIVO 500 GM",36,0,0,36]
["RAXIL EASY 13.4 ML",420,0,0,420]
["REGENT GR 5 KG",1100,11500,2155,10445]
["REGENT SC 500 ML",30,0,0,30]
["REGENT ULTRA 4 KG",1796,1040,748,2088]
["RICE STAR 500 ML",17,0,0,17]
["SENCORE 100 GM",104.4,0,34.4,70]
["SENCORE 500 GM",39.5,0,39.5,0]
["SIMBOLA 250 GM",2.25,0,0,2.25]
["SIMBOLA 500 GM",2.5,0,0,2.5]
["SOLOMON 1 LTR",0,20,0,20]
["SOLOMON 500 ML",0,10,0,10]
["Grand Total",{"$f":"SUM(B17:B48)","v":3921},{"$f":"SUM(C17:C48)","v":12830},3186.5,13564.5]

{"sheet":"Dealer Report working","index":2,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["ANTRACOL 1 KG",0,100,0,100,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["ANTRACOL 500 GM",22,0,16,6,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",0,100,0,100]
["BELT EXPERT 100 ML",0,50,0,50,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",22,0,16,6]
["BUONOS 1 LTR",35,0,0,35,"BUONOS SC430 10X1L BOT IN",null,null,null,"BELT EXPERT SC480 50X100ML BOT IN",0,50,0,50]
["BUONOS 500 ML",6.5,0,0,6.5,"BUONOS SC430 20X500ML BOT IN",null,null,null,"BUONOS SC430 10X1L BOT IN",35,0,0,35]
["COUNCIL ACTIV 90 GM",0,60,0,60,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,"BUONOS SC430 20X500ML BOT IN",6.5,0,0,6.5]
["DECIS 100 250 ML",0.75,0,0,0.75,"DECIS EC101-2 40X250ML BOT IN",null,null,null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,60,0,60]
["ETHREL 100 ML",0,50,0,50,"ETHREL SL39 50X100ML BOT IN",null,null,null,"DECIS EC101-2 40X250ML BOT IN",0.75,0,0,0.75]
["FAME 100 ML",3.6,0,3.6,0,"FAME (T) SC480 20X100ML BOT IN",null,null,null,"ETHREL SL39 50X100ML BOT IN",0,50,0,50]
["GLAMORE 100 GM",28,0,28,0,"GLAMORE WG80 20X100GR BOT IN",null,null,null,"FAME (T) SC480 20X100ML BOT IN",3.6,0,3.6,0]
["GLAMORE 250 GM",8,0,8,0,"GLAMORE WG80 8X250GR BAG IN",null,null,null,"GAUCHO FS600 50X100ML BOT IN",50,0,0,50]
["GLAMORE 50 GM",22,0,22,0,"GLAMORE WG80 40X50GR BOT IN",null,null,null,"GLAMORE WG80 20X100GR BOT IN",28,0,28,0]
["GOUCHO 100 ML",50,0,0,50,"GAUCHO FS600 50X100ML BOT IN",null,null,null,"GLAMORE WG80 40X50GR BOT IN",22,0,22,0]
["LAUDIS 115 ML",5,0,3,2,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"GLAMORE WG80 8X250GR BAG IN",8,0,8,0]
["LESENTA 100 GM",13.5,0,13,0.5,"LESENTA WG80 50X100GR BAG IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN",5,0,3,2]
["MOMI JI",67,0,67,0,"MOMIJI WG85 50X60G BOT IN",null,null,null,"LESENTA WG80 50X100GR BAG IN",13.5,0,13,0.5]
["MONCERN 1 LTR",10,0,10,0,"MONCEREN SC250 10X1L BOT IN",null,null,null,"MOMIJI WG85 50X60G BOT IN",67,0,67,0]
["MONCERN 500 ML",29,0,29,0,"MONCEREN SC250 20X500ML BOT IN",null,null,null,"MONCEREN SC250 10X1L BOT IN",10,0,10,0]
["MOVENTO 250 ML",5,0,5,0,"MOVENTO OD150 40X250ML BOT IN",null,null,null,"MONCEREN SC250 20X500ML BOT IN",29,0,29,0]
["NATIVO 1 KG",68,0,5,63,"NATIVO WG75 10X1KG BAG IN",null,null,null,"MOVENTO OD150 40X250ML BOT IN",5,0,5,0]
["NATIVO 500 GM",36,0,0,36,"NATIVO WG75 20X500GR BAG IN",null,null,null,"NATIVO WG75 10X1KG BAG IN",68,0,5,63]
["RAXIL EASY 13.4 ML",420,0,0,420,"RAXIL EASY FS60 10X(20X13.4ML) BOT IN",null,null,null,"NATIVO WG75 20X500GR BAG IN",36,0,0,36]
["REGENT GR 5 KG",1100,11500,2155,10445,"REGENT GR0 3 4X5KG BAG IN",null,null,null,"RAXIL EASY FS60 10X(20X13.4ML) BOT IN",420,0,0,420]
["REGENT SC 500 ML",30,0,0,30,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,"REGENT (T) SC50 20X500ML BOT IN",30,0,0,30]
["REGENT ULTRA 4 KG",1796,1040,748,2088,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,"REGENT GR0 3 4X5KG BAG IN",1100,11500,2155,10445]
["RICE STAR 500 ML",17,0,0,17,"RICESTAR EC69 20X500ML BOT IN",null,null,null,"REGENT ULTRA GR0 6 5X4KG BAG IN",1796,1040,748,2088]
["SENCORE 100 GM",104.4,0,34.4,70,"SENCOR WP70 60X100GR BAG IN",null,null,null,"RICESTAR EC69 20X500ML BOT IN",17,0,0,17]
["SENCORE 500 GM",39.5,0,39.5,0,"SENCOR WP70 20X500GR BOX IN",null,null,null,"SENCOR WP70 20X500GR BOX IN",39.5,0,39.5,0]
["SIMBOLA 250 GM",2.25,0,0,2.25,"SIMBOLA (T) SG20 20X250G BOT IN",null,null,null,"SENCOR WP70 60X100GR BAG IN",104.4,0,34.4,70]
["SIMBOLA 500 GM",2.5,0,0,2.5,"SIMBOLA (T) SG20 10X500G BOT IN",null,null,null,"SIMBOLA (T) SG20 10X500G BOT IN",2.5,0,0,2.5]
["SOLOMON 1 LTR",0,20,0,20,"SOLOMON OD300 10X1L BOT IN",null,null,null,"SIMBOLA (T) SG20 20X250G BOT IN",2.25,0,0,2.25]
["SOLOMON 500 ML",0,10,0,10,"SOLOMON OD300 20X500ML BOT IN",null,null,null,"SOLOMON OD300 10X1L BOT IN",0,20,0,20]
[null,null,null,null,null,null,null,null,null,"SOLOMON OD300 20X500ML BOT IN",0,10,0,10]
[null,null,null,null,null,null,null,null,null,"Grand Total",3921,12830,3186.5,13564.5]

{"sheet":"Master","index":3,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["ANTRACOL 1 KG","ANTRACOL (T) WP70 10X1KG BAG IN"]
["ANTRACOL 500 GM","ANTRACOL (T) WP70 20X500GR BAG IN"]
["BELT EXPERT 100 ML","BELT EXPERT SC480 50X100ML BOT IN"]
["BUONOS 1 LTR","BUONOS SC430 10X1L BOT IN"]
["BUONOS 500 ML","BUONOS SC430 20X500ML BOT IN"]
["COUNCIL ACTIV 90 GM","COUNCIL ACTIV WG30 12X(5X90GR) BOX IN"]
["DECIS 100 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"]
["GLAMORE 100 GM","GLAMORE WG80 20X100GR BOT IN"]
["GLAMORE 250 GM","GLAMORE WG80 8X250GR BAG IN"]
["GLAMORE 50 GM","GLAMORE WG80 40X50GR BOT IN"]
["GOUCHO 100 ML","GAUCHO FS600 50X100ML BOT IN"]
["LAUDIS 115 ML","LAUDIS SC630 8X115ML BOT IN"]
["LESENTA 100 GM","LESENTA WG80 50X100GR BAG IN"]
["MOMI JI","MOMIJI WG85 50X60G BOT IN"]
["MONCERN 1 LTR","MONCEREN SC250 10X1L BOT IN"]
["MONCERN 500 ML","MONCEREN SC250 20X500ML BOT IN"]
["MOVENTO 250 ML","MOVENTO OD150 40X250ML BOT IN"]
["NATIVO 1 KG","NATIVO WG75 10X1KG BAG IN"]
["NATIVO 500 GM","NATIVO WG75 20X500GR BAG IN"]
["RAXIL EASY 13.4 ML","RAXIL EASY FS60 10X(20X13.4ML) BOT IN"]
["REGENT GR 5 KG","REGENT GR0 3 4X5KG BAG IN"]
["REGENT SC 500 ML","REGENT (T) SC50 20X500ML BOT IN"]
["REGENT ULTRA 4 KG","REGENT ULTRA GR0 6 5X4KG BAG IN"]
["RICE STAR 500 ML","RICESTAR EC69 20X500ML BOT IN"]
["SENCORE 100 GM","SENCOR WP70 60X100GR BAG IN"]
["SENCORE 500 GM","SENCOR WP70 20X500GR BOX IN"]
["SIMBOLA 250 GM","SIMBOLA (T) SG20 20X250G BOT IN"]
["SIMBOLA 500 GM","SIMBOLA (T) SG20 10X500G BOT IN"]
["SOLOMON 1 LTR","SOLOMON OD300 10X1L BOT IN"]
["SOLOMON 500 ML","SOLOMON OD300 20X500ML BOT IN"]
["ALIETTE 250 GM","ALIETTE WP80 20X250GR BAG IN"]
["CLODINA-LUCIFER","LUCIFER (T) WP15 25X160GR BAG IN"]
["DECIS 2.8 1 LTR","DECIS EC 28 10X1L BOT IN"]
["FAME 250 ML","FAME (T) SC480 8X250ML BOT IN"]
["FAME 500 ML","FAME (T) SC480 4X500ML BOT IN"]
["FAME 50 ML","FAME (T) SC480 40X50ML BOT IN"]
["Folicure 1 Ltr","FOLICUR (T) EC250 10X1L BOT IN"]
["Folicure 500 Ml","FOLICUR (T) EC250 20X500ML BOT IN"]
["GOUCHO 50 ML","GAUCHO FS600 100X50ML BOT IN"]
["LAUDIS","LAUDIS SC630 8X115ML BOT IN"]
["Momiji","MOMIJI WG85 50X60G BOT IN"]
["Nativo 250 Gm","NATIVO WG75 40X250GR BAG IN"]
["REGENT GOLD 100 ML","REGENT GOLD SC200 50X100ML BOT IN"]
["REGENT SC 250 ML","REGENT (T) SC50 20X250ML BOT IN"]
["REGENT ULTRA","REGENT ULTRA GR0 6 1X20KG BAG IN"]
["Ricestar 500 Ml","RICESTAR EC69 20X500ML BOT IN"]
["Sancore 100 Gm","SENCOR WP70 60X100GR BAG IN"]
["Simbola 100 Gm","SIMBOLA (T) SG20 50X100G BOT IN"]
["Solomon 250 Ml","SOLOMON OD300 40X250ML BOT IN"]
["WHIPSUPER 100 ML","WHIPSUPER (T) EC90 50X100ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":35,"n_cols":14,"rows_kept":35,"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,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,0,100,0,0,0,0,0,0,100]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,22,0,0,16,0,0,0,0,6]
[null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,0,50,0,0,0,0,0,0,50]
[null,"BUONOS SC430 10X1L BOT IN",null,null,null,35,0,0,0,0,0,0,0,35]
[null,"BUONOS SC430 20X500ML BOT IN",null,null,null,6.5,0,0,0,0,0,0,0,6.5]
[null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,0,60,0,0,0,0,0,0,60]
[null,"DECIS EC101-2 40X250ML BOT IN",null,null,null,0.75,0,0,0,0,0,0,0,0.75]
[null,"ETHREL SL39 50X100ML BOT IN",null,null,null,0,50,0,0,0,0,0,0,50]
[null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,3.6,0,0,3.6,0,0,0,0,0]
[null,"GAUCHO FS600 50X100ML BOT IN",null,null,null,50,0,0,0,0,0,0,0,50]
[null,"GLAMORE WG80 20X100GR BOT IN",null,null,null,28,0,0,28,0,0,0,0,0]
[null,"GLAMORE WG80 40X50GR BOT IN",null,null,null,22,0,0,22,0,0,0,0,0]
[null,"GLAMORE WG80 8X250GR BAG IN",null,null,null,8,0,0,8,0,0,0,0,0]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,5,0,0,3,0,0,0,0,2]
[null,"LESENTA WG80 50X100GR BAG IN",null,null,null,13.5,0,0,13,0,0,0,0,0.5]
[null,"MOMIJI WG85 50X60G BOT IN",null,null,null,67,0,0,67,0,0,0,0,0]
[null,"MONCEREN SC250 10X1L BOT IN",null,null,null,10,0,0,10,0,0,0,0,0]
[null,"MONCEREN SC250 20X500ML BOT IN",null,null,null,29,0,0,29,0,0,0,0,0]
[null,"MOVENTO OD150 40X250ML BOT IN",null,null,null,5,0,0,5,0,0,0,0,0]
[null,"NATIVO WG75 10X1KG BAG IN",null,null,null,68,0,0,5,0,0,0,0,63]
[null,"NATIVO WG75 20X500GR BAG IN",null,null,null,36,0,0,0,0,0,0,0,36]
[null,"RAXIL EASY FS60 10X(20X13.4ML) BOT IN",null,null,null,420,0,0,0,0,0,0,0,420]
[null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,30,0,0,0,0,0,0,0,30]
[null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,1100,11500,0,2155,0,0,0,0,10445]
[null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,1796,1040,0,748,0,0,0,0,2088]
[null,"RICESTAR EC69 20X500ML BOT IN",null,null,null,17,0,0,0,0,0,0,0,17]
[null,"SENCOR WP70 20X500GR BOX IN",null,null,null,39.5,0,0,39.5,0,0,0,0,0]
[null,"SENCOR WP70 60X100GR BAG IN",null,null,null,104.4,0,0,34.4,0,0,0,0,70]
[null,"SIMBOLA (T) SG20 10X500G BOT IN",null,null,null,2.5,0,0,0,0,0,0,0,2.5]
[null,"SIMBOLA (T) SG20 20X250G BOT IN",null,null,null,2.25,0,0,0,0,0,0,0,2.25]
[null,"SOLOMON OD300 10X1L BOT IN",null,null,null,0,20,0,0,0,0,0,0,20]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,0,10,0,0,0,0,0,0,10]
[null,"Grand Total",null,null,null,3921,12830,0,3186.5,0,0,0,0,13564.5]

{"sheet":"Zylem SNS Report","index":5,"n_rows":57,"n_cols":13,"rows_kept":57,"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 30-Jun-2021"]
["Generated on 7/20/2021 6:10:35 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Bhagwati Fertilizers,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Bhagwati Fertilizers",3809623,"ALIETTE WP80 20X250GR BAG IN",3822358,20,0,0,0,0,0,0,0,20]
["Bhagwati Fertilizers",3809623,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,6,100,0,0,0,0,0,0,106]
["Bhagwati Fertilizers",3809623,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,16,0,0,16,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"BELT EXPERT SC480 50X100ML BOT IN",79722869,0,50,0,0,0,0,0,0,50]
["Bhagwati Fertilizers",3809623,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",80882629,0,60,0,0,0,0,0,0,60]
["Bhagwati Fertilizers",3809623,"DECIS EC 28 10X1L BOT IN",3823303,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"ETHREL SL39 50X100ML BOT IN",4299026,0,50,0,0,0,0,0,0,50]
["Bhagwati Fertilizers",3809623,"FAME (T) SC480 20X100ML BOT IN",79266197,0,0,0,3.6,0,0,0,0,-3.6]
["Bhagwati Fertilizers",3809623,"FAME (T) SC480 40X50ML BOT IN",79224699,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"FAME (T) SC480 4X500ML BOT IN",80554966,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"FAME (T) SC480 8X250ML BOT IN",80183291,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"FOLICUR (T) EC250 10X1L BOT IN",79504438,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"FOLICUR (T) EC250 20X500ML BOT IN",79652933,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"GAUCHO FS600 100X50ML BOT IN",80034733,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"GAUCHO FS600 50X100ML BOT IN",79664141,50,0,0,0,0,0,0,0,50]
["Bhagwati Fertilizers",3809623,"GLAMORE WG80 20X100GR BOT IN",79985312,28,0,0,28,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"GLAMORE WG80 40X50GR BOT IN",79973772,22,0,0,22,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"GLAMORE WG80 8X250GR BAG IN",80556810,8,0,0,8,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"LAUDIS SC630 8X115ML BOT IN",80491085,5,0,0,3,0,0,0,0,2]
["Bhagwati Fertilizers",3809623,"LESENTA WG80 50X100GR BAG IN",80503385,13.5,0,0,13,0,0,0,0,0.5]
["Bhagwati Fertilizers",3809623,"LUCIFER (T) WP15 25X160GR BAG IN",79383789,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"MONCEREN SC250 10X1L BOT IN",5949571,10,0,0,10,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"MONCEREN SC250 20X500ML BOT IN",5979454,29,0,0,29,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"MOVENTO OD150 40X250ML BOT IN",81714150,5,0,0,5,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"NATIVO WG75 10X1KG BAG IN",80525346,68,0,0,5,0,0,0,0,63]
["Bhagwati Fertilizers",3809623,"NATIVO WG75 20X500GR BAG IN",79198698,36,0,0,0,0,0,0,0,36]
["Bhagwati Fertilizers",3809623,"NATIVO WG75 40X250GR BAG IN",79237790,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"REGENT (T) SC50 20X250ML BOT IN",5976951,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"REGENT (T) SC50 20X500ML BOT IN",5987678,30,0,0,0,0,0,0,0,30]
["Bhagwati Fertilizers",3809623,"REGENT GOLD SC200 50X100ML BOT IN",84133965,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"REGENT GR0 3 4X5KG BAG IN",80018703,1100,11500,0,2155,0,0,0,0,10445]
["Bhagwati Fertilizers",3809623,"REGENT ULTRA GR0 6 5X4KG BAG IN",84093394,0,1040,0,748,0,0,0,0,292]
["Bhagwati Fertilizers",3809623,"RICESTAR EC69 20X500ML BOT IN",79511655,17,0,0,0,0,0,0,0,17]
["Bhagwati Fertilizers",3809623,"SENCOR WP70 20X500GR BOX IN",79052375,39.799999999999997,0,0,39.5,0,0,0,0,0.3]
["Bhagwati Fertilizers",3809623,"SENCOR WP70 60X100GR BAG IN",3825578,104.4,0,0,34.4,0,0,0,0,70]
["Bhagwati Fertilizers",3809623,"SIMBOLA (T) SG20 10X500G BOT IN",85776576,2.5,0,0,0,0,0,0,0,2.5]
["Bhagwati Fertilizers",3809623,"SIMBOLA (T) SG20 20X250G BOT IN",85758136,2.25,0,0,0,0,0,0,0,2.25]
["Bhagwati Fertilizers",3809623,"SIMBOLA (T) SG20 50X100G BOT IN",85767860,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"SOLOMON OD300 10X1L BOT IN",79637365,0,20,0,0,0,0,0,0,20]
["Bhagwati Fertilizers",3809623,"SOLOMON OD300 20X500ML BOT IN",79987870,0,10,0,0,0,0,0,0,10]
["Bhagwati Fertilizers",3809623,"SOLOMON OD300 40X250ML BOT IN",79706723,0,0,0,0,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"WHIPSUPER (T) EC90 50X100ML BOT IN",5994151,129,0,0,0,0,0,0,0,129]
["Bhagwati Fertilizers",3809623,"DECIS EC101-2 40X250ML BOT IN",3823281,0.75,0,0,0,0,0,0,0,0.75]
["Bhagwati Fertilizers",3809623,"MOMIJI WG85 50X60G BOT IN",86271389,67,0,0,67,0,0,0,0,0]
["Bhagwati Fertilizers",3809623,"REGENT ULTRA GR0 6 1X20KG BAG IN",81749485,1796,0,0,0,0,0,0,0,1796]
["Bhagwati Fertilizers",3809623,"RAXIL EASY FS60 10X(20X13.4ML) BOT IN",84911186,420,0,0,0,0,0,0,0,420]
["Bhagwati Fertilizers",3809623,"BUONOS SC430 10X1L BOT IN",86202247,35,0,0,0,0,0,0,0,35]
["Bhagwati Fertilizers",3809623,"BUONOS SC430 20X500ML BOT IN",86254468,6.5,0,0,0,0,0,0,0,6.5]
["GRANDTOTAL",null,null,null,4066.7,12830,0,3186.5,0,0,0,0,13710.2]

{"sheet":"OPG","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ADORA (T) SC100 50X100ML BOT IN",{"$f":"VLOOKUP(A1,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":21},0]

{"sheet":"Reco","index":7,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -01-Apr-2021 TO 30-Jun-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2021 TO 30-Jun-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"]
["ALIETTE WP80 20X250GR BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"B4-K4","v":0},0,0,0,0,0,0,0,{"$f":"S4-J4","v":0},"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",0,100,0,0,0,0,0,0,100,0,100,0,0,0,0,0,0,100,{"$f":"B5-K5","v":0},0,0,0,0,0,0,0,{"$f":"S5-J5","v":0},"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",22,0,0,16,0,0,0,0,6,22,0,0,16,0,0,0,0,6,0,0,0,0,0,0,0,0,0,"Ok"]
["BELT EXPERT SC480 50X100ML BOT IN",0,50,0,0,0,0,0,0,50,0,50,0,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,60,0,0,0,0,0,0,60,0,60,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 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"]
["ETHREL SL39 50X100ML BOT IN",0,50,0,0,0,0,0,0,50,0,50,0,0,0,0,0,0,50,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 20X100ML BOT IN",3.6,0,0,3.6,0,0,0,0,0,3.6,0,0,3.6,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"]
["FAME (T) SC480 4X500ML 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"]
["FAME (T) SC480 8X250ML 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 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"]
["FOLICUR (T) EC250 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"]
["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"]
["GAUCHO FS600 50X100ML BOT 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"]
["GLAMORE WG80 20X100GR BOT 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"]
["GLAMORE WG80 40X50GR BOT IN",22,0,0,22,0,0,0,0,0,22,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["GLAMORE WG80 8X250GR BAG IN",8,0,0,8,0,0,0,0,0,8,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 8X115ML BOT IN",5,0,0,3,0,0,0,0,2,5,0,0,3,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["LESENTA WG80 50X100GR BAG IN",13.5,0,0,13,0,0,0,0,0.5,13.5,0,0,13,0,0,0,0,0.5,0,0,0,0,0,0,0,0,0,"Ok"]
["LUCIFER (T) WP15 25X160GR 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"]
["MONCEREN SC250 10X1L 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"]
["MONCEREN SC250 20X500ML BOT IN",29,0,0,29,0,0,0,0,0,29,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["MOVENTO OD150 40X250ML BOT 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"]
["NATIVO WG75 10X1KG BAG IN",68,0,0,5,0,0,0,0,63,68,0,0,5,0,0,0,0,63,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 20X500GR BAG IN",36,0,0,0,0,0,0,0,36,36,0,0,0,0,0,0,0,36,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR 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 (T) SC50 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"]
["REGENT (T) SC50 20X500ML 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"]
["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"]
["REGENT GR0 3 4X5KG BAG IN",1100,11500,0,2155,0,0,0,0,10445,1100,11500,0,2155,0,0,0,0,10445,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT ULTRA GR0 6 5X4KG BAG IN",1796,1040,0,748,0,0,0,0,2088,1796,1040,0,748,0,0,0,0,2088,0,0,0,0,0,0,0,0,0,"Ok"]
["RICESTAR EC69 20X500ML BOT IN",17,0,0,0,0,0,0,0,17,17,0,0,0,0,0,0,0,17,0,0,0,0,0,0,0,0,0,"Ok"]
["SENCOR WP70 20X500GR BOX IN",39.5,0,0,39.5,0,0,0,0,0,39.5,0,0,39.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SENCOR WP70 60X100GR BAG IN",104.4,0,0,34.4,0,0,0,0,70,104.4,0,0,34.4,0,0,0,0,70,0,0,0,0,0,0,0,0,0,"Ok"]
["SIMBOLA (T) SG20 10X500G BOT IN",2.5,0,0,0,0,0,0,0,2.5,2.5,0,0,0,0,0,0,0,2.5,0,0,0,0,0,0,0,0,0,"Ok"]
["SIMBOLA (T) SG20 20X250G BOT IN",2.25,0,0,0,0,0,0,0,2.25,2.25,0,0,0,0,0,0,0,2.25,0,0,0,0,0,0,0,0,0,"Ok"]
["SIMBOLA (T) SG20 50X100G 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,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"]
["SOLOMON OD300 20X500ML BOT IN",0,10,0,0,0,0,0,0,10,0,10,0,0,0,0,0,0,10,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"]
["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"]
["DECIS EC101-2 40X250ML BOT IN",0.75,0,0,0,0,0,0,0,0.75,0.75,0,0,0,0,0,0,0,0.75,0,0,0,0,0,0,0,0,0,"Ok"]
["MOMIJI WG85 50X60G BOT IN",67,0,0,67,0,0,0,0,0,67,0,0,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT ULTRA GR0 6 1X20KG 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"]
["RAXIL EASY FS60 10X(20X13.4ML) BOT IN",420,0,0,0,0,0,0,0,420,420,0,0,0,0,0,0,0,420,0,0,0,0,0,0,0,0,0,"Ok"]
["BUONOS SC430 10X1L BOT IN",35,0,0,0,0,0,0,0,35,35,0,0,0,0,0,0,0,35,0,0,0,0,0,0,0,0,0,"Ok"]
["BUONOS SC430 20X500ML BOT IN",6.5,0,0,0,0,0,0,0,6.5,6.5,0,0,0,0,0,0,0,6.5,0,0,0,0,0,0,0,0,0,"Ok"]
["TOTAL",{"$f":"SUM(B4:B51)","v":3921},12830,0,3186.5,0,0,0,0,{"$f":"SUM(J4:J51)","v":13564.5},{"$f":"SUM(K4:K51)","v":3921},12830,0,3186.5,0,0,0,0,13564.5,0,0,0,0,0,0,0,0,0,"Ok"]