{"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,"Ved Agro Fertilizers"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Jan-2020 TO 31-Mar-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["VED AGRO FERTILIZERS"]
["Umreth Sarsa Road,"]
["Nr.Navapura Bus Stand, ODE"]
["Bayer"]
["Stock Summary"]
["1-Jan-2020 to 31-Mar-2021"]
["","Bayer"]
["","VED AGRO FERTILIZERS - (1-4-16/17)"]
["Particulars","1-Jan-2020 to 31-Mar-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["Alanto-250ml"]
["Aliette 100 Gm",-4,4]
["Aliette 1kg"]
["Aliette 250g"]
["Aliette 500gm",null,80,60,20]
["Ambition 1l",35,10,45]
["Ambition-250gm"]
["Ambition-500ml",62,20,82]
["Antracol-1kg",3,540,543]
["Antracol-250gm",41,280,321]
["Antracol-500gm",27,600,627]
["Basta-1 Liter",12,null,null,12]
["Bayleton-100gm"]
["Bayleton 500g"]
["Belt Expert 100ml"]
["Confidor-100ml"]
["Confidor-250ml"]
["Confidor-500ml"]
["Confidorsuper 100ml",3,350,343,10]
["Confidor Super-1liter"]
["Confidor Super 250ml",2,17,19]
["Confidor Super 500ml",-1,41,40]
["Decis-100ml"]
["Fem Sc"]
["Fitrest 100gm"]
["Fitrest-250gm"]
["Folicur-1liter"]
["Gaucho-100ml",-3,3]
["Larvin-100gm",27,80,107]
["Larvin-1kg",53,100,153]
["Larvin-250gm",22,500,500,22]
["Larvin-500gm",5,299,292,12]
["Laudis-115ml"]
["Lesenta 100gm",11,null,11]
["Lesenta 40gm",30,null,30]
["Luna Ex-100ml",4,100,99,5]
["Luna Ex-1liter",-1,30,29]
["Luna Ex-250ml",4,120,124]
["Movento-100ml",-1,403,386,16]
["Movento -1liter",3,180,182,1]
["Movento-250ml",13,1040,1053]
["Movento Energy 1l"]
["Movento Energy 250ml"]
["Nativo-100gm",39,250,255,34]
["Nativo-1kg"]
["Nativo-250gm",38,2,39,1]
["Nativo-500gm"]
["Oberon-1 Liter",-1,1]
["Oberon-200ml",4,null,4]
["Oberon-2 Lit"]
["Oberon-500ml",2,null,2]
["Planofix-100ml"]
["Quintal 200gm"]
["Quintal-500gm"]
["Regent-100ml",null,100,80,20]
["Regent 1 Lit"]
["Regent 500ml",-1,1]
["Regent G (1kg)"]
["Regent G (5kg)",-5,5]
["Regent Gold-100ml",null,198,198]
["Regent Gold 500ml",null,100,100]
["Regent Gr 25kg"]
["Regent Ultra 1kg",-3,10,7]
["Regent Ultra 4kg",1,80,56,25]
["Sectin-100gm"]
["Sectin-600gm"]
["Senkur-100gm",null,60,60]
["Sivanto-100ml",-4,504,496,4]
["Sivanto 1-Liter",1,160,161]
["Sivanto-250ml",14,600,614]
["Sivanto-500ml",11,303,314]
["Solomon-100ml",null,50,50]
["Solomon-1liter"]
["Solomon-250ml"]
["Solomon-500ml"]
["Spintor-75ml"]
["Velum Prime-250",34,80,91,23]
["Velum Prime-500",null,260,252,8]
["Grand Total",{"$f":"SUM(B12:B89)","v":477},{"$f":"SUM(C12:C89)","v":7561},7825,213]

{"sheet":"Dealer Report working","index":2,"n_rows":79,"n_cols":14,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["Alanto-250ml",null,null,null,null,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["Aliette 100 Gm",-4,4,null,null,"ALIETTE WP80 40X100GR BAG IN",null,null,null,"ALANTO (T) SC240 40X250ML BOT IN"]
["Aliette 1kg",null,null,null,null,"ALIETTE WP80 10X1KG BAG IN",null,null,null,"ALIETTE WP80 10X1KG BAG IN"]
["Aliette 250g",null,null,null,null,"ALIETTE WP80 20X250GR BAG IN",null,null,null,"ALIETTE WP80 20X250GR BAG IN"]
["Aliette 500gm",null,80,60,20,"ALIETTE WP80 20X500GR BAG IN",null,null,null,"ALIETTE WP80 20X500GR BAG IN",null,80,60,20]
["Ambition 1l",35,10,45,null,"AMBITION 10X1L BOT IN",null,null,null,"ALIETTE WP80 40X100GR BAG IN",-4,4]
["Ambition-250gm",null,null,null,null,"AMBITION 40X250ML BOT IN",null,null,null,"AMBITION 10X1L BOT IN",35,10,45]
["Ambition-500ml",62,20,82,null,"AMBITION 20X500ML BOT IN",null,null,null,"AMBITION 20X500ML BOT IN",62,20,82]
["Antracol-1kg",3,540,543,null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"AMBITION 40X250ML BOT IN"]
["Antracol-250gm",41,280,321,null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",3,540,543]
["Antracol-500gm",27,600,627,null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",27,600,627]
["Basta-1 Liter",12,null,null,12,"DISCOUNTINUE PRODUCT",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",41,280,321]
["Bayleton-100gm",null,null,null,null,"DISCOUNTINUE PRODUCT",null,null,null,"BELT EXPERT SC480 50X100ML BOT IN"]
["Bayleton 500g",null,null,null,null,"DISCOUNTINUE PRODUCT",null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN"]
["Belt Expert 100ml",null,null,null,null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,"CONFIDOR (T) SL200 20X500ML BOT IN"]
["Confidor-100ml",null,null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,"CONFIDOR (T) SL200 50X100ML BOT IN"]
["Confidor-250ml",null,null,null,null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 10X1L BOT IN"]
["Confidor-500ml",null,null,null,null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",2,17,19]
["Confidorsuper 100ml",3,350,343,10,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",-1,41,40]
["Confidor Super-1liter",null,null,null,null,"CONFIDOR SUPER (T) SC350 10X1L BOT IN",null,null,null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",3,350,343,10]
["Confidor Super 250ml",2,17,19,null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,"DECIS EC 28 50X100ML BOT IN"]
["Confidor Super 500ml",-1,41,40,null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,"DISCOUNTINUE PRODUCT",12,null,null,12]
["Decis-100ml",null,null,null,null,"DECIS EC 28 50X100ML BOT IN",null,null,null,"FAME (T) SC480 20X100ML BOT IN"]
["Fem Sc",null,null,null,null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,"FITREST SG5 16X250GR BOT IN"]
["Fitrest 100gm",null,null,null,null,"FITREST SG5 40X100GR BOT IN",null,null,null,"FITREST SG5 40X100GR BOT IN"]
["Fitrest-250gm",null,null,null,null,"FITREST SG5 16X250GR BOT IN",null,null,null,"FOLICUR (T) EC250 10X1L BOT IN"]
["Folicur-1liter",null,null,null,null,"FOLICUR (T) EC250 10X1L BOT IN",null,null,null,"GAUCHO FS600 50X100ML BOT IN",-3,3]
["Gaucho-100ml",-3,3,null,null,"GAUCHO FS600 50X100ML BOT IN",null,null,null,"LARVIN (T) WP75 10X1KG BAG IN",53,100,153]
["Larvin-100gm",27,80,107,null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,"LARVIN (T) WP75 20X250GR BAG IN",22,500,500,22]
["Larvin-1kg",53,100,153,null,"LARVIN (T) WP75 10X1KG BAG IN",null,null,null,"LARVIN (T) WP75 20X500GR BAG IN",5,299,292,12]
["Larvin-250gm",22,500,500,22,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,"LARVIN (T) WP75 40X100GR BAG IN",27,80,107]
["Larvin-500gm",5,299,292,12,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN"]
["Laudis-115ml",null,null,null,null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"LESENTA WG80 100X40GR BAG IN",30,null,30]
["Lesenta 100gm",11,null,11,null,"LESENTA WG80 50X100GR BAG IN",null,null,null,"LESENTA WG80 50X100GR BAG IN",11,null,11]
["Lesenta 40gm",30,null,30,null,"LESENTA WG80 100X40GR BAG IN",null,null,null,"LUNA EXPERIENCE SC400 10X1L BOT IN",-1,30,29]
["Luna Ex-100ml",4,100,99,5,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",4,120,124]
["Luna Ex-1liter",-1,30,29,null,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",4,100,99,5]
["Luna Ex-250ml",4,120,124,null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 10X1L BOT IN",3,180,182,1]
["Movento-100ml",-1,403,386,16,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",13,1040,1053]
["Movento -1liter",3,180,182,1,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,"MOVENTO ENERGY SC240 50X100ML BOT IN",-1,403,386,16]
["Movento-250ml",13,1040,1053,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"NATIVO WG75 10X1KG BAG IN"]
["Movento Energy 1l",null,null,null,null,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,"NATIVO WG75 20X500GR BAG IN"]
["Movento Energy 250ml",null,null,null,null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",38,2,39,1]
["Nativo-100gm",39,250,255,34,"NATIVO WG75 50X100GR BAG IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",39,250,255,34]
["Nativo-1kg",null,null,null,null,"NATIVO WG75 10X1KG BAG IN",null,null,null,"OBERON (T) SC240 10X1L BOT IN",-1,1]
["Nativo-250gm",38,2,39,1,"NATIVO WG75 40X250GR BAG IN",null,null,null,"OBERON (T) SC240 20X500ML BOT IN",2,null,2]
["Nativo-500gm",null,null,null,null,"NATIVO WG75 20X500GR BAG IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",4,null,4]
["Oberon-1 Liter",-1,1,null,null,"OBERON (T) SC240 10X1L BOT IN",null,null,null,"OBERON (T) SC240 5X2L BOT IN"]
["Oberon-200ml",4,null,4,null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN"]
["Oberon-2 Lit",null,null,null,null,"OBERON (T) SC240 5X2L BOT IN",null,null,null,"REGENT (T) SC50 10X1L BOT IN"]
["Oberon-500ml",2,null,2,null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,"REGENT (T) SC50 20X500ML BOT IN",-1,1]
["Planofix-100ml",null,null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 50X100ML BOT IN",null,100,80,20]
["Quintal 200gm",null,null,null,null,"DISCOUNTINUE PRODUCT",null,null,null,"REGENT GOLD SC200 20X500ML BOT IN",null,100,100]
["Quintal-500gm",null,null,null,null,"DISCOUNTINUE PRODUCT",null,null,null,"REGENT GOLD SC200 50X100ML BOT IN",null,198,198]
["Regent-100ml",null,100,80,20,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,"REGENT GR0 3 1X25KG BOX WW"]
["Regent 1 Lit",null,null,null,null,"REGENT (T) SC50 10X1L BOT IN",null,null,null,"REGENT GR0 3 20X1KG BAG IN"]
["Regent 500ml",-1,1,null,null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,"REGENT GR0 3 4X5KG BAG IN",-5,5]
["Regent G (1kg)",null,null,null,null,"REGENT GR0 3 20X1KG BAG IN",null,null,null,"REGENT ULTRA GR0 6 20X1KG BAG IN",-3,10,7]
["Regent G (5kg)",-5,5,null,null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,"REGENT ULTRA GR0 6 5X4KG BAG IN",1,80,56,25]
["Regent Gold-100ml",null,198,198,null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,"SECTIN WG60 20X600GR BAG IN"]
["Regent Gold 500ml",null,100,100,null,"REGENT GOLD SC200 20X500ML BOT IN",null,null,null,"SECTIN WG60 50X100GR BAG IN"]
["Regent Gr 25kg",null,null,null,null,"REGENT GR0 3 1X25KG BOX WW",null,null,null,"SENCOR WP70 60X100GR BAG IN",null,60,60]
["Regent Ultra 1kg",-3,10,7,null,"REGENT ULTRA GR0 6 20X1KG BAG IN",null,null,null,"SIVANTO PRIME SL200 10X1L BOT IN",1,160,161]
["Regent Ultra 4kg",1,80,56,25,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,"SIVANTO PRIME SL200 20X500ML BOT IN",11,303,314]
["Sectin-100gm",null,null,null,null,"SECTIN WG60 50X100GR BAG IN",null,null,null,"SIVANTO PRIME SL200 40X250ML BOT IN",14,600,614]
["Sectin-600gm",null,null,null,null,"SECTIN WG60 20X600GR BAG IN",null,null,null,"SIVANTO PRIME SL200 50X100ML BOT IN",-4,504,496,4]
["Senkur-100gm",null,60,60,null,"SENCOR WP70 60X100GR BAG IN",null,null,null,"SOLOMON OD300 10X1L BOT IN"]
["Sivanto-100ml",-4,504,496,4,"SIVANTO PRIME SL200 50X100ML BOT IN",null,null,null,"SOLOMON OD300 20X500ML BOT IN"]
["Sivanto 1-Liter",1,160,161,null,"SIVANTO PRIME SL200 10X1L BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN"]
["Sivanto-250ml",14,600,614,null,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,"SOLOMON OD300 50X100ML BOT IN",null,50,50]
["Sivanto-500ml",11,303,314,null,"SIVANTO PRIME SL200 20X500ML BOT IN",null,null,null,"SPINTOR SC495 20X75ML BOT IN"]
["Solomon-100ml",null,50,50,null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"VELUM PRIME SC400 20X500ML BOT IN",null,260,252,8]
["Solomon-1liter",null,null,null,null,"SOLOMON OD300 10X1L BOT IN",null,null,null,"VELUM PRIME SC400 40X250ML BOT IN",34,80,91,23]
["Solomon-250ml",null,null,null,null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"Grand Total",477,7561,7825,213]
["Solomon-500ml",null,null,null,null,"SOLOMON OD300 20X500ML BOT IN"]
["Spintor-75ml",null,null,null,null,"SPINTOR SC495 20X75ML BOT IN"]
["Velum Prime-250",34,80,91,23,"VELUM PRIME SC400 40X250ML BOT IN"]
["Velum Prime-500",null,260,252,8,"VELUM PRIME SC400 20X500ML BOT IN"]

{"sheet":"Master","index":3,"n_rows":79,"n_cols":2,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["Alanto-250ml","ALANTO (T) SC240 40X250ML BOT IN"]
["Aliette 100 Gm","ALIETTE WP80 40X100GR BAG IN"]
["Aliette 1kg","ALIETTE WP80 10X1KG BAG IN"]
["Aliette 250g","ALIETTE WP80 20X250GR BAG IN"]
["Aliette 500gm","ALIETTE WP80 20X500GR BAG IN"]
["Ambition 1l","AMBITION 10X1L BOT IN"]
["Ambition-250gm","AMBITION 40X250ML BOT IN"]
["Ambition-500ml","AMBITION 20X500ML BOT IN"]
["Antracol-1kg","ANTRACOL (T) WP70 10X1KG BAG IN"]
["Antracol-250gm","ANTRACOL (T) WP70 40X250GR BAG IN"]
["Antracol-500gm","ANTRACOL (T) WP70 20X500GR BAG IN"]
["Basta-1 Liter","DISCOUNTINUE PRODUCT"]
["Bayleton-100gm","DISCOUNTINUE PRODUCT"]
["Bayleton 500g","DISCOUNTINUE PRODUCT"]
["Belt Expert 100ml","BELT EXPERT SC480 50X100ML BOT IN"]
["Confidor-100ml","CONFIDOR (T) SL200 50X100ML BOT IN"]
["Confidor-250ml","CONFIDOR (T) SL200 20X250ML BOT IN"]
["Confidor-500ml","CONFIDOR (T) SL200 20X500ML BOT IN"]
["Confidorsuper 100ml","CONFIDOR SUPER (T) SC350 50X100ML BOT IN"]
["Confidor Super-1liter","CONFIDOR SUPER (T) SC350 10X1L BOT IN"]
["Confidor Super 250ml","CONFIDOR SUPER (T) SC350 20X250ML BOT IN"]
["Confidor Super 500ml","CONFIDOR SUPER (T) SC350 20X500ML BOT IN"]
["Decis-100ml","DECIS EC 28 50X100ML BOT IN"]
["Fem Sc","FAME (T) SC480 20X100ML BOT IN"]
["Fitrest 100gm","FITREST SG5 40X100GR BOT IN"]
["Fitrest-250gm","FITREST SG5 16X250GR BOT IN"]
["Folicur-1liter","FOLICUR (T) EC250 10X1L BOT IN"]
["Gaucho-100ml","GAUCHO FS600 50X100ML BOT IN"]
["Larvin-100gm","LARVIN (T) WP75 40X100GR BAG IN"]
["Larvin-1kg","LARVIN (T) WP75 10X1KG BAG IN"]
["Larvin-250gm","LARVIN (T) WP75 20X250GR BAG IN"]
["Larvin-500gm","LARVIN (T) WP75 20X500GR BAG IN"]
["Laudis-115ml","LAUDIS SC630 8X115ML BOT IN"]
["Lesenta 100gm","LESENTA WG80 50X100GR BAG IN"]
["Lesenta 40gm","LESENTA WG80 100X40GR BAG IN"]
["Luna Ex-100ml","LUNA EXPERIENCE SC400 50X100ML BOT IN"]
["Luna Ex-1liter","LUNA EXPERIENCE SC400 10X1L BOT IN"]
["Luna Ex-250ml","LUNA EXPERIENCE SC400 40X250ML BOT IN"]
["Movento-100ml","MOVENTO ENERGY SC240 50X100ML BOT IN"]
["Movento -1liter","MOVENTO ENERGY SC240 10X1L BOT IN"]
["Movento-250ml","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["Movento Energy 1l","MOVENTO ENERGY SC240 10X1L BOT IN"]
["Movento Energy 250ml","MOVENTO ENERGY SC240 40X250ML BOT IN"]
["Nativo-100gm","NATIVO WG75 50X100GR BAG IN"]
["Nativo-1kg","NATIVO WG75 10X1KG BAG IN"]
["Nativo-250gm","NATIVO WG75 40X250GR BAG IN"]
["Nativo-500gm","NATIVO WG75 20X500GR BAG IN"]
["Oberon-1 Liter","OBERON (T) SC240 10X1L BOT IN"]
["Oberon-200ml","OBERON (T) SC240 40X200ML BOT IN"]
["Oberon-2 Lit","OBERON (T) SC240 5X2L BOT IN"]
["Oberon-500ml","OBERON (T) SC240 20X500ML BOT IN"]
["Planofix-100ml","PLANOFIX SL4 5 50X100ML BOT IN"]
["Quintal 200gm","DISCOUNTINUE PRODUCT"]
["Quintal-500gm","DISCOUNTINUE PRODUCT"]
["Regent-100ml","REGENT (T) SC50 50X100ML BOT IN"]
["Regent 1 Lit","REGENT (T) SC50 10X1L BOT IN"]
["Regent 500ml","REGENT (T) SC50 20X500ML BOT IN"]
["Regent G (1kg)","REGENT GR0 3 20X1KG BAG IN"]
["Regent G (5kg)","REGENT GR0 3 4X5KG BAG IN"]
["Regent Gold-100ml","REGENT GOLD SC200 50X100ML BOT IN"]
["Regent Gold 500ml","REGENT GOLD SC200 20X500ML BOT IN"]
["Regent Gr 25kg","REGENT GR0 3 1X25KG BOX WW"]
["Regent Ultra 1kg","REGENT ULTRA GR0 6 20X1KG BAG IN"]
["Regent Ultra 4kg","REGENT ULTRA GR0 6 5X4KG BAG IN"]
["Sectin-100gm","SECTIN WG60 50X100GR BAG IN"]
["Sectin-600gm","SECTIN WG60 20X600GR BAG IN"]
["Senkur-100gm","SENCOR WP70 60X100GR BAG IN"]
["Sivanto-100ml","SIVANTO PRIME SL200 50X100ML BOT IN"]
["Sivanto 1-Liter","SIVANTO PRIME SL200 10X1L BOT IN"]
["Sivanto-250ml","SIVANTO PRIME SL200 40X250ML BOT IN"]
["Sivanto-500ml","SIVANTO PRIME SL200 20X500ML BOT IN"]
["Solomon-100ml","SOLOMON OD300 50X100ML BOT IN"]
["Solomon-1liter","SOLOMON OD300 10X1L BOT IN"]
["Solomon-250ml","SOLOMON OD300 40X250ML BOT IN"]
["Solomon-500ml","SOLOMON OD300 20X500ML BOT IN"]
["Spintor-75ml","SPINTOR SC495 20X75ML BOT IN"]
["Velum Prime-250","VELUM PRIME SC400 40X250ML BOT IN"]
["Velum Prime-500","VELUM PRIME SC400 20X500ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":75,"n_cols":14,"rows_kept":75,"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,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ALIETTE WP80 10X1KG BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ALIETTE WP80 20X250GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ALIETTE WP80 20X500GR BAG IN",null,null,null,0,80,0,60,0,0,0,0,20]
[null,"ALIETTE WP80 40X100GR BAG IN",null,null,null,-4,4,0,0,0,0,0,0,0]
[null,"AMBITION 10X1L BOT IN",null,null,null,35,10,0,45,0,0,0,0,0]
[null,"AMBITION 20X500ML BOT IN",null,null,null,62,20,0,82,0,0,0,0,0]
[null,"AMBITION 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,3,540,0,543,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,27,600,0,627,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,41,280,0,321,0,0,0,0,0]
[null,"BELT EXPERT SC480 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 20X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",null,null,null,2,17,0,19,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",null,null,null,-1,41,0,40,0,0,0,0,0]
[null,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",null,null,null,3,350,0,343,0,0,0,0,10]
[null,"DECIS EC 28 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"DISCOUNTINUE PRODUCT",null,null,null,12,0,0,0,0,0,0,0,12]
[null,"FAME (T) SC480 20X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FITREST SG5 16X250GR BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FITREST SG5 40X100GR BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FOLICUR (T) EC250 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"GAUCHO FS600 50X100ML BOT IN",null,null,null,-3,3,0,0,0,0,0,0,0]
[null,"LARVIN (T) WP75 10X1KG BAG IN",null,null,null,53,100,0,153,0,0,0,0,0]
[null,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,22,500,0,500,0,0,0,0,22]
[null,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,5,299,0,292,0,0,0,0,12]
[null,"LARVIN (T) WP75 40X100GR BAG IN",null,null,null,27,80,0,107,0,0,0,0,0]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"LESENTA WG80 100X40GR BAG IN",null,null,null,30,0,0,30,0,0,0,0,0]
[null,"LESENTA WG80 50X100GR BAG IN",null,null,null,11,0,0,11,0,0,0,0,0]
[null,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,-1,30,0,29,0,0,0,0,0]
[null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,4,120,0,124,0,0,0,0,0]
[null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,4,100,0,99,0,0,0,0,5]
[null,"MOVENTO ENERGY SC240 10X1L BOT IN",null,null,null,3,180,0,182,0,0,0,0,1]
[null,"MOVENTO ENERGY SC240 40X250ML BOT IN",null,null,null,13,1040,0,1053,0,0,0,0,0]
[null,"MOVENTO ENERGY SC240 50X100ML BOT IN",null,null,null,-1,403,0,386,0,0,0,0,16]
[null,"NATIVO WG75 10X1KG BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"NATIVO WG75 20X500GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,38,2,0,39,0,0,0,0,1]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,39,250,0,255,0,0,0,0,34]
[null,"OBERON (T) SC240 10X1L BOT IN",null,null,null,-1,1,0,0,0,0,0,0,0]
[null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,2,0,0,2,0,0,0,0,0]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,4,0,0,4,0,0,0,0,0]
[null,"OBERON (T) SC240 5X2L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT (T) SC50 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT (T) SC50 20X500ML BOT IN",null,null,null,-1,1,0,0,0,0,0,0,0]
[null,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,0,100,0,80,0,0,0,0,20]
[null,"REGENT GOLD SC200 20X500ML BOT IN",null,null,null,0,100,0,100,0,0,0,0,0]
[null,"REGENT GOLD SC200 50X100ML BOT IN",null,null,null,0,198,0,198,0,0,0,0,0]
[null,"REGENT GR0 3 1X25KG BOX WW",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT GR0 3 20X1KG BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,-5,5,0,0,0,0,0,0,0]
[null,"REGENT ULTRA GR0 6 20X1KG BAG IN",null,null,null,-3,10,0,7,0,0,0,0,0]
[null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,1,80,0,56,0,0,0,0,25]
[null,"SECTIN WG60 20X600GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SECTIN WG60 50X100GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SENCOR WP70 60X100GR BAG IN",null,null,null,0,60,0,60,0,0,0,0,0]
[null,"SIVANTO PRIME SL200 10X1L BOT IN",null,null,null,1,160,0,161,0,0,0,0,0]
[null,"SIVANTO PRIME SL200 20X500ML BOT IN",null,null,null,11,303,0,314,0,0,0,0,0]
[null,"SIVANTO PRIME SL200 40X250ML BOT IN",null,null,null,14,600,0,614,0,0,0,0,0]
[null,"SIVANTO PRIME SL200 50X100ML BOT IN",null,null,null,-4,504,0,496,0,0,0,0,4]
[null,"SOLOMON OD300 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,0,50,0,50,0,0,0,0,0]
[null,"SPINTOR SC495 20X75ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"VELUM PRIME SC400 20X500ML BOT IN",null,null,null,0,260,0,252,0,0,0,0,8]
[null,"VELUM PRIME SC400 40X250ML BOT IN",null,null,null,34,80,0,91,0,0,0,0,23]
[null,"Grand Total",null,null,null,477,7561,0,7825,0,0,0,0,213]

{"sheet":"Zylem SNS Report","index":5,"n_rows":53,"n_cols":13,"rows_kept":53,"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-Jan-2020 TO 31-Mar-2021"]
["Generated on 5/11/2021 4:34:54 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Ved Agro Fertilizers,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Ved Agro Fertilizers",1955218,"ALIETTE WP80 20X500GR BAG IN",3822366,0,80,0,60,0,0,0,0,20]
["Ved Agro Fertilizers",1955218,"ALIETTE WP80 40X100GR BAG IN",3822331,-4,0,0,0,0,0,0,-4,0]
["Ved Agro Fertilizers",1955218,"AMBITION 10X1L BOT IN",86212544,35,10,0,43,0,0,0,2,0]
["Ved Agro Fertilizers",1955218,"AMBITION 20X500ML BOT IN",86228564,62,20,0,82,1,0,0,1,0]
["Ved Agro Fertilizers",1955218,"AMBITION 40X250ML BOT IN",86232308,0,0,0,1,1,0,0,0,0]
["Ved Agro Fertilizers",1955218,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,3,540,0,537,1,0,0,7,0]
["Ved Agro Fertilizers",1955218,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,27,600,0,627,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,41,280,0,321,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"CONFIDOR SUPER (T) SC350 20X250ML BOT IN",79710852,2,17,0,18,0,0,0,1,0]
["Ved Agro Fertilizers",1955218,"CONFIDOR SUPER (T) SC350 20X500ML BOT IN",79734727,-1,40,0,40,0,0,0,-1,0]
["Ved Agro Fertilizers",1955218,"CONFIDOR SUPER (T) SC350 50X100ML BOT IN",79735219,3,350,0,346,3,0,0,0,10]
["Ved Agro Fertilizers",1955218,"GAUCHO FS600 50X100ML BOT IN",79664141,-3,0,0,0,0,0,0,-3,0]
["Ved Agro Fertilizers",1955218,"LARVIN (T) WP75 10X1KG BAG IN",6005062,53,100,0,153,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"LARVIN (T) WP75 20X250GR BAG IN",6003167,22,500,0,506,6,0,0,0,22]
["Ved Agro Fertilizers",1955218,"LARVIN (T) WP75 20X500GR BAG IN",6005291,5,299,0,292,0,0,0,0,12]
["Ved Agro Fertilizers",1955218,"LARVIN (T) WP75 40X100GR BAG IN",5980436,27,80,0,97,0,0,0,10,0]
["Ved Agro Fertilizers",1955218,"LESENTA WG80 100X40GR BAG IN",80500823,30,0,0,0,0,0,0,30,0]
["Ved Agro Fertilizers",1955218,"LESENTA WG80 50X100GR BAG IN",80503385,11,0,0,0,0,0,0,11,0]
["Ved Agro Fertilizers",1955218,"LUNA EXPERIENCE SC400 10X1L BOT IN",80251904,-1,30,0,29,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"LUNA EXPERIENCE SC400 40X250ML BOT IN",80549652,4,120,0,121,0,0,0,3,0]
["Ved Agro Fertilizers",1955218,"LUNA EXPERIENCE SC400 50X100ML BOT IN",80199414,4,100,0,101,2,0,0,0,5]
["Ved Agro Fertilizers",1955218,"MOVENTO ENERGY SC240 10X1L BOT IN",79556837,3,180,0,182,2,0,0,2,1]
["Ved Agro Fertilizers",1955218,"MOVENTO ENERGY SC240 40X250ML BOT IN",79679505,13,1040,0,1046,2,0,0,9,0]
["Ved Agro Fertilizers",1955218,"MOVENTO ENERGY SC240 50X100ML BOT IN",79722605,-1,400,0,390,4,0,0,-3,16]
["Ved Agro Fertilizers",1955218,"NATIVO WG75 40X250GR BAG IN",79237790,38,40,40,39,0,0,0,-2,1]
["Ved Agro Fertilizers",1955218,"NATIVO WG75 50X100GR BAG IN",79304102,39,250,0,258,3,0,0,0,34]
["Ved Agro Fertilizers",1955218,"OBERON (T) SC240 10X1L BOT IN",80209037,-1,0,0,0,0,0,0,-1,0]
["Ved Agro Fertilizers",1955218,"OBERON (T) SC240 20X500ML BOT IN",80026471,2,0,0,0,0,0,0,2,0]
["Ved Agro Fertilizers",1955218,"OBERON (T) SC240 40X200ML BOT IN",79971362,4,0,0,0,0,0,0,4,0]
["Ved Agro Fertilizers",1955218,"REGENT (T) SC50 20X500ML BOT IN",5987678,-1,0,0,0,0,0,0,-1,0]
["Ved Agro Fertilizers",1955218,"REGENT (T) SC50 50X100ML BOT IN",5975343,0,100,0,80,0,0,0,0,20]
["Ved Agro Fertilizers",1955218,"REGENT GOLD SC200 20X500ML BOT IN",81741565,0,100,0,80,0,0,0,20,0]
["Ved Agro Fertilizers",1955218,"REGENT GOLD SC200 50X100ML BOT IN",84133965,0,100,0,198,0,0,0,-98,0]
["Ved Agro Fertilizers",1955218,"REGENT GR0 3 4X5KG BAG IN",80018703,-5,0,0,0,0,0,0,-5,0]
["Ved Agro Fertilizers",1955218,"REGENT ULTRA GR0 6 20X1KG BAG IN",84120863,-3,0,0,10,3,0,0,-10,0]
["Ved Agro Fertilizers",1955218,"REGENT ULTRA GR0 6 5X4KG BAG IN",84093394,1,80,0,53,0,0,0,3,25]
["Ved Agro Fertilizers",1955218,"SENCOR WP70 60X100GR BAG IN",3825578,0,60,0,60,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"SIVANTO PRIME SL200 10X1L BOT IN",80894104,1,170,10,162,1,0,0,0,0]
["Ved Agro Fertilizers",1955218,"SIVANTO PRIME SL200 20X500ML BOT IN",80845782,11,323,20,314,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"SIVANTO PRIME SL200 40X250ML BOT IN",80895909,14,600,0,618,4,0,0,0,0]
["Ved Agro Fertilizers",1955218,"SIVANTO PRIME SL200 50X100ML BOT IN",80961197,-4,497,0,506,10,0,0,-7,4]
["Ved Agro Fertilizers",1955218,"SOLOMON OD300 50X100ML BOT IN",79641931,0,50,0,50,0,0,0,0,0]
["Ved Agro Fertilizers",1955218,"VELUM PRIME SC400 20X500ML BOT IN",84407038,0,260,0,255,3,0,0,0,8]
["Ved Agro Fertilizers",1955218,"VELUM PRIME SC400 40X250ML BOT IN",84474886,34,80,0,103,12,0,0,0,23]
["GRANDTOTAL",null,null,null,465,7496,70,7778,58,0,0,-30,201]

{"sheet":"OPG","index":6,"n_rows":72,"n_cols":3,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["ALIETTE WP80 20X500GR BAG IN",{"$f":"VLOOKUP(A1,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":34},0]
["ALIETTE WP80 40X100GR BAG IN",{"$f":"VLOOKUP(A2,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":35},-4]
["AMBITION 10X1L BOT IN",{"$f":"VLOOKUP(A3,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":39},35]
["AMBITION 20X500ML BOT IN",{"$f":"VLOOKUP(A4,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":40},62]
["AMBITION 40X250ML BOT IN",{"$f":"VLOOKUP(A5,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":41},0]
["ANTRACOL (T) WP70 10X1KG BAG IN",{"$f":"VLOOKUP(A6,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":42},3]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A7,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":43},27]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A8,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":44},41]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",{"$f":"VLOOKUP(A9,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":118},2]
["CONFIDOR SUPER (T) SC350 20X500ML BOT IN",{"$f":"VLOOKUP(A10,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":119},-1]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",{"$f":"VLOOKUP(A11,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":120},3]
["GAUCHO FS600 50X100ML BOT IN",{"$f":"VLOOKUP(A12,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":182},-3]
["LARVIN (T) WP75 10X1KG BAG IN",{"$f":"VLOOKUP(A13,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":204},53]
["LARVIN (T) WP75 20X250GR BAG IN",{"$f":"VLOOKUP(A14,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":205},22]
["LARVIN (T) WP75 20X500GR BAG IN",{"$f":"VLOOKUP(A15,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":206},5]
["LARVIN (T) WP75 40X100GR BAG IN",{"$f":"VLOOKUP(A16,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":207},27]
["LESENTA WG80 100X40GR BAG IN",{"$f":"VLOOKUP(A17,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":215},30]
["LESENTA WG80 50X100GR BAG IN",{"$f":"VLOOKUP(A18,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":219},11]
["LUNA EXPERIENCE SC400 10X1L BOT IN",{"$f":"VLOOKUP(A19,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":223},-1]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A20,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":225},4]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",{"$f":"VLOOKUP(A21,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":226},4]
["MOVENTO ENERGY SC240 10X1L BOT IN",{"$f":"VLOOKUP(A22,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":271},3]
["MOVENTO ENERGY SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A23,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":273},13]
["MOVENTO ENERGY SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A24,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":274},-1]
["NATIVO WG75 40X250GR BAG IN",{"$f":"VLOOKUP(A25,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":293},38]
["NATIVO WG75 50X100GR BAG IN",{"$f":"VLOOKUP(A26,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":294},39]
["OBERON (T) SC240 10X1L BOT IN",{"$f":"VLOOKUP(A27,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":296},-1]
["OBERON (T) SC240 20X500ML BOT IN",{"$f":"VLOOKUP(A28,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":297},2]
["OBERON (T) SC240 40X200ML BOT IN",{"$f":"VLOOKUP(A29,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":299},4]
["REGENT (T) SC50 20X500ML BOT IN",{"$f":"VLOOKUP(A30,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":326},-1]
["REGENT (T) SC50 50X100ML BOT IN",{"$f":"VLOOKUP(A31,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":327},0]
["REGENT GOLD SC200 20X500ML BOT IN",{"$f":"VLOOKUP(A32,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":330},0]
["REGENT GOLD SC200 50X100ML BOT IN",{"$f":"VLOOKUP(A33,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":332},0]
["REGENT GR0 3 4X5KG BAG IN",{"$f":"VLOOKUP(A34,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":336},-5]
["REGENT ULTRA GR0 6 20X1KG BAG IN",{"$f":"VLOOKUP(A35,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":338},-3]
["REGENT ULTRA GR0 6 5X4KG BAG IN",{"$f":"VLOOKUP(A36,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":339},1]
["SENCOR WP70 60X100GR BAG IN",{"$f":"VLOOKUP(A37,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":353},0]
["SIVANTO PRIME SL200 10X1L BOT IN",{"$f":"VLOOKUP(A38,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":359},1]
["SIVANTO PRIME SL200 20X500ML BOT IN",{"$f":"VLOOKUP(A39,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":360},11]
["SIVANTO PRIME SL200 40X250ML BOT IN",{"$f":"VLOOKUP(A40,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":361},14]
["SIVANTO PRIME SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A41,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":362},-4]
["SOLOMON OD300 50X100ML BOT IN",{"$f":"VLOOKUP(A42,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":370},0]
["VELUM PRIME SC400 20X500ML BOT IN",{"$f":"VLOOKUP(A43,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":400},0]
["VELUM PRIME SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A44,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":401},34]
["ALANTO (T) SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A45,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":29},0]
["ALIETTE WP80 10X1KG BAG IN",{"$f":"VLOOKUP(A46,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":31},0]
["ALIETTE WP80 20X250GR BAG IN",{"$f":"VLOOKUP(A47,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":33},0]
["BELT EXPERT SC480 50X100ML BOT IN",{"$f":"VLOOKUP(A48,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":111},0]
["CONFIDOR (T) SL200 20X250ML BOT IN",{"$f":"VLOOKUP(A49,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":114},0]
["CONFIDOR (T) SL200 20X500ML BOT IN",{"$f":"VLOOKUP(A50,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":115},0]
["CONFIDOR (T) SL200 50X100ML BOT IN",{"$f":"VLOOKUP(A51,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":116},0]
["CONFIDOR SUPER (T) SC350 10X1L BOT IN",{"$f":"VLOOKUP(A52,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":117},0]
["DECIS EC 28 50X100ML BOT IN",{"$f":"VLOOKUP(A53,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":928},0]
["DISCOUNTINUE PRODUCT",{"$f":"VLOOKUP(A54,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":993},12]
["FAME (T) SC480 20X100ML BOT IN",{"$f":"VLOOKUP(A55,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":145},0]
["FITREST SG5 16X250GR BOT IN",{"$f":"VLOOKUP(A56,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":154},0]
["FITREST SG5 40X100GR BOT IN",{"$f":"VLOOKUP(A57,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":155},0]
["FOLICUR (T) EC250 10X1L BOT IN",{"$f":"VLOOKUP(A58,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":162},0]
["LAUDIS SC630 8X115ML BOT IN",{"$f":"VLOOKUP(A59,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":212},0]
["NATIVO WG75 10X1KG BAG IN",{"$f":"VLOOKUP(A60,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":290},0]
["NATIVO WG75 20X500GR BAG IN",{"$f":"VLOOKUP(A61,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":292},0]
["OBERON (T) SC240 5X2L BOT IN",{"$f":"VLOOKUP(A62,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":301},0]
["PLANOFIX SL4 5 50X100ML BOT IN",{"$f":"VLOOKUP(A63,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":307},0]
["REGENT (T) SC50 10X1L BOT IN",{"$f":"VLOOKUP(A64,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":324},0]
["REGENT GR0 3 1X25KG BOX WW",{"$f":"VLOOKUP(A65,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":333},0]
["REGENT GR0 3 20X1KG BAG IN",{"$f":"VLOOKUP(A66,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":335},0]
["SECTIN WG60 20X600GR BAG IN",{"$f":"VLOOKUP(A67,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":345},0]
["SECTIN WG60 50X100GR BAG IN",{"$f":"VLOOKUP(A68,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":346},0]
["SOLOMON OD300 10X1L BOT IN",{"$f":"VLOOKUP(A69,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":365},0]
["SOLOMON OD300 20X500ML BOT IN",{"$f":"VLOOKUP(A70,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":366},0]
["SOLOMON OD300 40X250ML BOT IN",{"$f":"VLOOKUP(A71,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":368},0]
["SPINTOR SC495 20X75ML BOT IN",{"$f":"VLOOKUP(A72,'[2]Product Master Sheet'!$B$2:$F$506,5,0)","v":373},0]

{"sheet":"Reco","index":7,"n_rows":75,"n_cols":29,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report - 01-Jan-2020 TO 31-Mar-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Jan-2020 TO 31-Mar-2021",null,null,null,null,null,null,null,null,"Difference (+/-)"]
[]
["DEALER CODE","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG","Opening Stock Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustments Qty","CLSG","Remark"]
["ALIETTE WP80 20X500GR BAG IN",0,80,0,60,0,0,0,0,20,0,80,0,60,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 40X100GR BAG IN",-4,0,0,0,0,0,0,-4,0,-4,4,0,0,0,0,0,0,0,0,-4,0,0,0,0,0,-4,0,"Ok"]
["AMBITION 10X1L BOT IN",35,10,0,43,0,0,0,2,0,35,10,0,45,0,0,0,0,0,0,0,0,-2,0,0,0,2,0,"Ok"]
["AMBITION 20X500ML BOT IN",62,20,0,82,1,0,0,1,0,62,20,0,82,0,0,0,0,0,0,0,0,0,1,0,0,1,0,"Ok"]
["AMBITION 40X250ML BOT IN",0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",3,540,0,537,1,0,0,7,0,3,540,0,543,0,0,0,0,0,0,0,0,-6,1,0,0,7,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",27,600,0,627,0,0,0,0,0,27,600,0,627,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",41,280,0,321,0,0,0,0,0,41,280,0,321,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X250ML BOT IN",2,17,0,18,0,0,0,1,0,2,17,0,19,0,0,0,0,0,0,0,0,-1,0,0,0,1,0,"Ok"]
["CONFIDOR SUPER (T) SC350 20X500ML BOT IN",-1,40,0,40,0,0,0,-1,0,-1,41,0,40,0,0,0,0,0,0,-1,0,0,0,0,0,-1,0,"Ok"]
["CONFIDOR SUPER (T) SC350 50X100ML BOT IN",3,350,0,346,3,0,0,0,10,3,350,0,343,0,0,0,0,10,0,0,0,3,3,0,0,0,0,"Ok"]
["GAUCHO FS600 50X100ML BOT IN",-3,0,0,0,0,0,0,-3,0,-3,3,0,0,0,0,0,0,0,0,-3,0,0,0,0,0,-3,0,"Ok"]
["LARVIN (T) WP75 10X1KG BAG IN",53,100,0,153,0,0,0,0,0,53,100,0,153,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X250GR BAG IN",22,500,0,506,6,0,0,0,22,22,500,0,500,0,0,0,0,22,0,0,0,6,6,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X500GR BAG IN",5,299,0,292,0,0,0,0,12,5,299,0,292,0,0,0,0,12,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 40X100GR BAG IN",27,80,0,97,0,0,0,10,0,27,80,0,107,0,0,0,0,0,0,0,0,-10,0,0,0,10,0,"Ok"]
["LESENTA WG80 100X40GR BAG IN",30,0,0,0,0,0,0,30,0,30,0,0,30,0,0,0,0,0,0,0,0,-30,0,0,0,30,0,"Ok"]
["LESENTA WG80 50X100GR BAG IN",11,0,0,0,0,0,0,11,0,11,0,0,11,0,0,0,0,0,0,0,0,-11,0,0,0,11,0,"Ok"]
["LUNA EXPERIENCE SC400 10X1L BOT IN",-1,30,0,29,0,0,0,0,0,-1,30,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",4,120,0,121,0,0,0,3,0,4,120,0,124,0,0,0,0,0,0,0,0,-3,0,0,0,3,0,"Ok"]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",4,100,0,101,2,0,0,0,5,4,100,0,99,0,0,0,0,5,0,0,0,2,2,0,0,0,0,"Ok"]
["MOVENTO ENERGY SC240 10X1L BOT IN",3,180,0,182,2,0,0,2,1,3,180,0,182,0,0,0,0,1,0,0,0,0,2,0,0,2,0,"Ok"]
["MOVENTO ENERGY SC240 40X250ML BOT IN",13,1040,0,1046,2,0,0,9,0,13,1040,0,1053,0,0,0,0,0,0,0,0,-7,2,0,0,9,0,"Ok"]
["MOVENTO ENERGY SC240 50X100ML BOT IN",-1,400,0,390,4,0,0,-3,16,-1,403,0,386,0,0,0,0,16,0,-3,0,4,4,0,0,-3,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",38,40,40,39,0,0,0,-2,1,38,2,0,39,0,0,0,0,1,0,38,40,0,0,0,0,-2,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",39,250,0,258,3,0,0,0,34,39,250,0,255,0,0,0,0,34,0,0,0,3,3,0,0,0,0,"Ok"]
["OBERON (T) SC240 10X1L BOT IN",-1,0,0,0,0,0,0,-1,0,-1,1,0,0,0,0,0,0,0,0,-1,0,0,0,0,0,-1,0,"Ok"]
["OBERON (T) SC240 20X500ML BOT IN",2,0,0,0,0,0,0,2,0,2,0,0,2,0,0,0,0,0,0,0,0,-2,0,0,0,2,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",4,0,0,0,0,0,0,4,0,4,0,0,4,0,0,0,0,0,0,0,0,-4,0,0,0,4,0,"Ok"]
["REGENT (T) SC50 20X500ML BOT IN",-1,0,0,0,0,0,0,-1,0,-1,1,0,0,0,0,0,0,0,0,-1,0,0,0,0,0,-1,0,"Ok"]
["REGENT (T) SC50 50X100ML BOT IN",0,100,0,80,0,0,0,0,20,0,100,0,80,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT GOLD SC200 20X500ML BOT IN",0,100,0,80,0,0,0,20,0,0,100,0,100,0,0,0,0,0,0,0,0,-20,0,0,0,20,0,"Ok"]
["REGENT GOLD SC200 50X100ML BOT IN",0,100,0,198,0,0,0,-98,0,0,198,0,198,0,0,0,0,0,0,-98,0,0,0,0,0,-98,0,"Ok"]
["REGENT GR0 3 4X5KG BAG IN",-5,0,0,0,0,0,0,-5,0,-5,5,0,0,0,0,0,0,0,0,-5,0,0,0,0,0,-5,0,"Ok"]
["REGENT ULTRA GR0 6 20X1KG BAG IN",-3,0,0,10,3,0,0,-10,0,-3,10,0,7,0,0,0,0,0,0,-10,0,3,3,0,0,-10,0,"Ok"]
["REGENT ULTRA GR0 6 5X4KG BAG IN",1,80,0,53,0,0,0,3,25,1,80,0,56,0,0,0,0,25,0,0,0,-3,0,0,0,3,0,"Ok"]
["SENCOR WP70 60X100GR BAG IN",0,60,0,60,0,0,0,0,0,0,60,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 10X1L BOT IN",1,170,10,162,1,0,0,0,0,1,160,0,161,0,0,0,0,0,0,10,10,1,1,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 20X500ML BOT IN",11,323,20,314,0,0,0,0,0,11,303,0,314,0,0,0,0,0,0,20,20,0,0,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 40X250ML BOT IN",14,600,0,618,4,0,0,0,0,14,600,0,614,0,0,0,0,0,0,0,0,4,4,0,0,0,0,"Ok"]
["SIVANTO PRIME SL200 50X100ML BOT IN",-4,497,0,506,10,0,0,-7,4,-4,504,0,496,0,0,0,0,4,0,-7,0,10,10,0,0,-7,0,"Ok"]
["SOLOMON OD300 50X100ML BOT IN",0,50,0,50,0,0,0,0,0,0,50,0,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["VELUM PRIME SC400 20X500ML BOT IN",0,260,0,255,3,0,0,0,8,0,260,0,252,0,0,0,0,8,0,0,0,3,3,0,0,0,0,"Ok"]
["VELUM PRIME SC400 40X250ML BOT IN",34,80,0,103,12,0,0,0,23,34,80,0,91,0,0,0,0,23,0,0,0,12,12,0,0,0,0,"Ok"]
["ALANTO (T) SC240 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"]
["ALIETTE WP80 10X1KG 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"]
["ALIETTE WP80 20X250GR BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["BELT EXPERT SC480 50X100ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X250ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 20X500ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 50X100ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR SUPER (T) SC350 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"]
["DECIS EC 28 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"]
["FAME (T) SC480 20X100ML 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"]
["FITREST SG5 16X250GR 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"]
["FITREST SG5 40X100GR 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"]
["LAUDIS SC630 8X115ML 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"]
["NATIVO WG75 10X1KG BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 20X500GR BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 5X2L 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"]
["PLANOFIX SL4 5 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 (T) SC50 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"]
["REGENT GR0 3 1X25KG BOX WW",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 20X1KG 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"]
["SECTIN WG60 20X600GR 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"]
["SECTIN WG60 50X100GR 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"]
["SOLOMON OD300 10X1L BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 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"]
["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"]
["SPINTOR SC495 20X75ML 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",465,7496,70,7778,58,0,0,-30,201,465,7561,0,7825,0,0,0,0,201,0,-65,70,-47,58,0,0,-30,0]