{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Navigation","Dealer Report","Dealer Report working","Master","Final Dealer Work","Zylem SNS Report","OPG","Sheet1","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,"Kashmir Agro Centre-9061129"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Aug-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Kashmir Agro Center - (BAYER)"]
["Court Road Badambagh Sopore,193201"]
["9419024183,9419038655"]
["Bayer Cropscience Limited"]
["Stock Group Summary"]
["1-Apr-21 to 31-Aug-21"]
["","Bayer Cropscience Limited"]
["","Kashmir Agro Center - (BAYER)"]
["Particulars","1-Apr-21 to 31-Aug-21"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["Admire 150 Grm (1cs*4.500 Kgs)",0,0,0,0]
["Admire 300grm (1cs* 6 Kg)",0,0,0,0]
["Alanto 1 Ltr (1cs* 10 Ltrs)",249,797,1046,0]
["Alanto 20*500ml(1cs*10ltr)",301.5,918,1129.5,90]
["Alanto 40*250ml(1cs*10 Ltr)",120,897.75,1017.75,0]
["Alanto 50*100ml(1cs*5Ltr)",67.7,429.7,482.4,15]
["Aliette 100 Grm(1cs*4kg)",0,0,0,0]
["Aliette 1 Kg (1cs* 10 Kg)",0,0,0,0]
["Aliette 250 Grm(1cs*5kg)",0,0,0,0]
["Antracol 100 Grm (1cs*5 Kgs)",0,0,0,0]
["Antracol 1kg (1cs*10kg)",85768,60513,108931,37350]
["Antracol 250 Grm (1cs*10 Kgs)",0,0,0,0]
["Antracol 500grm (1cs*10 Kgs)",0,0,0,0]
["Baycor 100 Grm (1cs*5kgs)",0,0,0,0]
["Bayleton 1kg(1cs* 5 Kg)",0,0,0,0]
["Bayliton 100 Grm (1cs*5kg)",0,0,0,0]
["Bayliton 500 Grm (1cs*5kgs)",0,0,0,0]
["Bilzeb 1kg (1cs*10kg)",0,0,0,0]
["Confidor 1ltr (1cs*10 Ltr)",0,0,0,0]
["Ethrel 100 Ml (1cs*5 Ltr)",0,0,0,0]
["Ethrel 1 Ltr(1cs*10 Ltr)",0,0,0,0]
["Ethrel 500 Ml (1cs* 10 Ltr)",0,0,0,0]
["Fame 10ML(1case*200 Bottles)",0,0,0,0]
["Foligure 1 Ltr(1cs* 10 Ltr)",0,0,0,0]
["Luna Experience 100ml (1cs*5 Ltr)",189.7,0,122.1,67.599999999999994]
["Luna Experience 1 Ltr(1cs*10 Ltr)",286,1207,1362,131]
["Luna Experience 250 Ml(1cs*10 Ltr)",100,1196.5,1186.5,110]
["Nativo 1 Kg (1cs*10kgs)",4830,-1100,3589,141]
["Nativo 20*500grm(1cs*10kg)",5996,1000,6426,570]
["Nativo  40*250grm(1cs*10kg)",3372.25,-200,3004.25,168]
["Nativo 50*100grm(1cs*5kg)",841.1,100,906.1,35]
["Oberon 100 Ml (1cs*5ltr)",15,50,61,4]
["Oberon 1 Ltr (1cs*10 Ltr)",0,150,83,67]
["Oberon 200 Ml (1cs*8 Ltr)",-1,248,232,15]
["Oberon 2 Ltr (1cs*10 Ltr)",0,0,0,0]
["Oberon 500 Ml (1cs*10 Ltr)",11.5,348,343.5,16]
["Planofix 100 Ml (1cs* 5ltr)",164.9,2998.8,2679.3,484.4]
["Planofix 1ltr( 1cs*10 Ltr)",0,0,0,0]
["Planofix 250 Ml (1cs*10 Ltr)",276.5,0,276.5,0]
["Planofix 500 Ml (1cs*10 Ltr)",469.5,0,468,1.5]
["Regent 1 Kg (1cs*10 Kgs)",0,0,0,0]
["Top Star 22 Grm (1cs*160 Pouchs)",0,0,0,0]
["Grand Total",10431,69553.75,133345.9,3996]

{"sheet":"Dealer Report working","index":2,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["Admire 150 Grm (1cs*4.500 Kgs)",0,0,0,0,"ADMIRE (T) WG70 30X150GR BOT IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["Admire 300grm (1cs* 6 Kg)",0,0,0,0,"ADMIRE WG70 20X300GR BAG IN",null,null,null,"ADMIRE (T) WG70 30X150GR BOT IN",0,0,0,0]
["Alanto 1 Ltr (1cs* 10 Ltrs)",249,797,1046,0,"ALANTO (T) SC240 10X1L BOT IN",null,null,null,"ADMIRE WG70 20X300GR BAG IN",0,0,0,0]
["Alanto 20*500ml(1cs*10ltr)",301.5,918,1129.5,90,"ALANTO (T) SC240 20X500ML BOT IN",null,null,null,"ALANTO (T) SC240 10X1L BOT IN",249,797,1046,0]
["Alanto 40*250ml(1cs*10 Ltr)",120,897.75,1017.75,0,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,"ALANTO (T) SC240 20X500ML BOT IN",301.5,918,1129.5,90]
["Alanto 50*100ml(1cs*5Ltr)",67.7,429.7,482.4,15,"ALANTO (T) SC240 50X100ML BOT IN",null,null,null,"ALANTO (T) SC240 40X250ML BOT IN",120,897.75,1017.75,0]
["Aliette 100 Grm(1cs*4kg)",0,0,0,0,"ALIETTE WP80 40X100GR BAG IN",null,null,null,"ALANTO (T) SC240 50X100ML BOT IN",67.7,429.7,482.4,15]
["Aliette 1 Kg (1cs* 10 Kg)",0,0,0,0,"ALIETTE WP80 10X1KG BAG IN",null,null,null,"ALIETTE WP80 10X1KG BAG IN",0,0,0,0]
["Aliette 250 Grm(1cs*5kg)",0,0,0,0,"ALIETTE WP80 20X250GR BAG IN",null,null,null,"ALIETTE WP80 20X250GR BAG IN",0,0,0,0]
["Antracol 100 Grm (1cs*5 Kgs)",0,0,0,0,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,"ALIETTE WP80 40X100GR BAG IN",0,0,0,0]
["Antracol 1kg (1cs*10kg)",85768,60513,108931,37350,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",85768,60513,108931,37350]
["Antracol 250 Grm (1cs*10 Kgs)",0,0,0,0,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",0,0,0,0]
["Antracol 500grm (1cs*10 Kgs)",0,0,0,0,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",0,0,0,0]
["Baycor 100 Grm (1cs*5kgs)",0,0,0,0,"DISCOUNTINUE PRODUCT",null,null,null,"ANTRACOL (T) WP70 50X100GR BAG IN",0,0,0,0]
["Bayleton 1kg(1cs* 5 Kg)",0,0,0,0,"BAYFOLAN ALGAE 10X1L BOT IN",null,null,null,"BAYFOLAN ALGAE 10X1L BOT IN",0,0,0,0]
["Bayliton 100 Grm (1cs*5kg)",0,0,0,0,"DISCOUNTINUE PRODUCT",null,null,null,"BAYFOLAN ALGAE 20X500ML BOT IN",0,0,0,0]
["Bayliton 500 Grm (1cs*5kgs)",0,0,0,0,"BAYFOLAN ALGAE 20X500ML BOT IN",null,null,null,"CONFIDOR (T) SL200 10X1L BOT IN",0,0,0,0]
["Bilzeb 1kg (1cs*10kg)",0,0,0,0,"DISCOUNTINUE PRODUCT",null,null,null,"DISCOUNTINUE PRODUCT",0,0,0,0]
["Confidor 1ltr (1cs*10 Ltr)",0,0,0,0,"CONFIDOR (T) SL200 10X1L BOT IN",null,null,null,"ETHREL SL39 10X1L BOT IN",0,0,0,0]
["Ethrel 100 Ml (1cs*5 Ltr)",0,0,0,0,"ETHREL SL39 50X100ML BOT IN",null,null,null,"ETHREL SL39 20X500ML BOT IN",0,0,0,0]
["Ethrel 1 Ltr(1cs*10 Ltr)",0,0,0,0,"ETHREL SL39 10X1L BOT IN",null,null,null,"ETHREL SL39 50X100ML BOT IN",0,0,0,0]
["Ethrel 500 Ml (1cs* 10 Ltr)",0,0,0,0,"ETHREL SL39 20X500ML BOT IN",null,null,null,"FAME (T) SC480 10X(20X10ML) BOT IN",0,0,0,0]
["Fame 10ML(1case*200 Bottles)",0,0,0,0,"FAME (T) SC480 10X(20X10ML) BOT IN",null,null,null,"FOLICUR (T) EC250 10X1L BOT IN",0,0,0,0]
["Foligure 1 Ltr(1cs* 10 Ltr)",0,0,0,0,"FOLICUR (T) EC250 10X1L BOT IN",null,null,null,"LUNA EXPERIENCE SC400 10X1L BOT IN",286,1207,1362,131]
["Luna Experience 100ml (1cs*5 Ltr)",189.7,0,122.1,67.599999999999994,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",100,1196.5,1186.5,110]
["Luna Experience 1 Ltr(1cs*10 Ltr)",286,1207,1362,131,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",189.7,0,122.1,67.599999999999994]
["Luna Experience 250 Ml(1cs*10 Ltr)",100,1196.5,1186.5,110,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,"NATIVO WG75 10X1KG BAG IN",4830,-1100,3589,141]
["Nativo 1 Kg (1cs*10kgs)",4830,-1100,3589,141,"NATIVO WG75 10X1KG BAG IN",null,null,null,"NATIVO WG75 20X500GR BAG IN",5996,1000,6426,570]
["Nativo 20*500grm(1cs*10kg)",5996,1000,6426,570,"NATIVO WG75 20X500GR BAG IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",3372.25,-200,3004.25,168]
["Nativo  40*250grm(1cs*10kg)",3372.25,-200,3004.25,168,"NATIVO WG75 40X250GR BAG IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",841.1,100,906.1,35]
["Nativo 50*100grm(1cs*5kg)",841.1,100,906.1,35,"NATIVO WG75 50X100GR BAG IN",null,null,null,"OBERON (T) SC240 10X1L BOT IN",0,150,83,67]
["Oberon 100 Ml (1cs*5ltr)",15,50,61,4,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 20X500ML BOT IN",11.5,348,343.5,16]
["Oberon 1 Ltr (1cs*10 Ltr)",0,150,83,67,"OBERON (T) SC240 10X1L BOT IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",-1,248,232,15]
["Oberon 200 Ml (1cs*8 Ltr)",-1,248,232,15,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN",15,50,61,4]
["Oberon 2 Ltr (1cs*10 Ltr)",0,0,0,0,"OBERON (T) SC240 5X2L BOT IN",null,null,null,"OBERON (T) SC240 5X2L BOT IN",0,0,0,0]
["Oberon 500 Ml (1cs*10 Ltr)",11.5,348,343.5,16,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,"PLANOFIX SL4 5 20X500ML BOT IN",469.5,0,468,1.5]
["Planofix 100 Ml (1cs* 5ltr)",164.9,2998.8,2679.3,484.4,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",276.5,0,276.5,0]
["Planofix 1ltr( 1cs*10 Ltr)",0,0,0,0,"PLANOFIX SL45 10X1L BOT IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",164.9,2998.8,2679.3,484.4]
["Planofix 250 Ml (1cs*10 Ltr)",276.5,0,276.5,0,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"PLANOFIX SL45 10X1L BOT IN",0,0,0,0]
["Planofix 500 Ml (1cs*10 Ltr)",469.5,0,468,1.5,"PLANOFIX SL4 5 20X500ML BOT IN",null,null,null,"REGENT GR0 3 20X1KG BAG IN",0,0,0,0]
["Regent 1 Kg (1cs*10 Kgs)",0,0,0,0,"REGENT GR0 3 20X1KG BAG IN",null,null,null,"TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN",0,0,0,0]
["Top Star 22 Grm (1cs*160 Pouchs)",0,0,0,0,"TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN",null,null,null,"Grand Total",103057.65,69553.75,133345.9,39265.5]

{"sheet":"Master","index":3,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["Admire 150 Grm (1cs*4.500 Kgs)","ADMIRE (T) WG70 30X150GR BOT IN"]
["Admire 300grm (1cs* 6 Kg)","ADMIRE WG70 20X300GR BAG IN"]
["Alanto 1 Ltr (1cs* 10 Ltrs)","ALANTO (T) SC240 10X1L BOT IN"]
["Alanto 20*500ml(1cs*10ltr)","ALANTO (T) SC240 20X500ML BOT IN"]
["Alanto 40*250ml(1cs*10 Ltr)","ALANTO (T) SC240 40X250ML BOT IN"]
["Alanto 50*100ml(1cs*5Ltr)","ALANTO (T) SC240 50X100ML BOT IN"]
["Aliette 100 Grm(1cs*4kg)","ALIETTE WP80 40X100GR BAG IN"]
["Aliette 1 Kg (1cs* 10 Kg)","ALIETTE WP80 10X1KG BAG IN"]
["Aliette 250 Grm(1cs*5kg)","ALIETTE WP80 20X250GR BAG IN"]
["Antracol 100 Grm (1cs*5 Kgs)","ANTRACOL (T) WP70 50X100GR BAG IN"]
["Antracol 1kg (1cs*10kg)","ANTRACOL (T) WP70 10X1KG BAG IN"]
["Antracol 250 Grm (1cs*10 Kgs)","ANTRACOL (T) WP70 40X250GR BAG IN"]
["Antracol 500grm (1cs*10 Kgs)","ANTRACOL (T) WP70 20X500GR BAG IN"]
["Baycor 100 Grm (1cs*5kgs)","DISCOUNTINUE PRODUCT"]
["Bayleton 1kg(1cs* 5 Kg)","BAYFOLAN ALGAE 10X1L BOT IN"]
["Bayliton 100 Grm (1cs*5kg)","DISCOUNTINUE PRODUCT"]
["Bayliton 500 Grm (1cs*5kgs)","BAYFOLAN ALGAE 20X500ML BOT IN"]
["Bilzeb 1kg (1cs*10kg)","DISCOUNTINUE PRODUCT"]
["Confidor 1ltr (1cs*10 Ltr)","CONFIDOR (T) SL200 10X1L BOT IN"]
["Ethrel 100 Ml (1cs*5 Ltr)","ETHREL SL39 50X100ML BOT IN"]
["Ethrel 1 Ltr(1cs*10 Ltr)","ETHREL SL39 10X1L BOT IN"]
["Ethrel 500 Ml (1cs* 10 Ltr)","ETHREL SL39 20X500ML BOT IN"]
["Fame 10ML(1case*200 Bottles)","FAME (T) SC480 10X(20X10ML) BOT IN"]
["Foligure 1 Ltr(1cs* 10 Ltr)","FOLICUR (T) EC250 10X1L BOT IN"]
["Luna Experience 100ml (1cs*5 Ltr)","LUNA EXPERIENCE SC400 50X100ML BOT IN"]
["Luna Experience 1 Ltr(1cs*10 Ltr)","LUNA EXPERIENCE SC400 10X1L BOT IN"]
["Luna Experience 250 Ml(1cs*10 Ltr)","LUNA EXPERIENCE SC400 40X250ML BOT IN"]
["Nativo 1 Kg (1cs*10kgs)","NATIVO WG75 10X1KG BAG IN"]
["Nativo 20*500grm(1cs*10kg)","NATIVO WG75 20X500GR BAG IN"]
["Nativo  40*250grm(1cs*10kg)","NATIVO WG75 40X250GR BAG IN"]
["Nativo 50*100grm(1cs*5kg)","NATIVO WG75 50X100GR BAG IN"]
["Oberon 100 Ml (1cs*5ltr)","OBERON (T) SC240 50X100ML BOT IN"]
["Oberon 1 Ltr (1cs*10 Ltr)","OBERON (T) SC240 10X1L BOT IN"]
["Oberon 200 Ml (1cs*8 Ltr)","OBERON (T) SC240 40X200ML BOT IN"]
["Oberon 2 Ltr (1cs*10 Ltr)","OBERON (T) SC240 5X2L BOT IN"]
["Oberon 500 Ml (1cs*10 Ltr)","OBERON (T) SC240 20X500ML BOT IN"]
["Planofix 100 Ml (1cs* 5ltr)","PLANOFIX SL4 5 50X100ML BOT IN"]
["Planofix 1ltr( 1cs*10 Ltr)","PLANOFIX SL45 10X1L BOT IN"]
["Planofix 250 Ml (1cs*10 Ltr)","PLANOFIX SL4 5 40X250ML BOT IN"]
["Planofix 500 Ml (1cs*10 Ltr)","PLANOFIX SL4 5 20X500ML BOT IN"]
["Regent 1 Kg (1cs*10 Kgs)","REGENT GR0 3 20X1KG BAG IN"]
["Top Star 22 Grm (1cs*160 Pouchs)","TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":43,"n_cols":14,"rows_kept":43,"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 30X150GR BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ADMIRE WG70 20X300GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ALANTO (T) SC240 10X1L BOT IN",null,null,null,249,797,0,1046,0,0,0,0,0]
[null,"ALANTO (T) SC240 20X500ML BOT IN",null,null,null,301.5,918,0,1129.5,0,0,0,0,90]
[null,"ALANTO (T) SC240 40X250ML BOT IN",null,null,null,120,897.75,0,1017.75,0,0,0,0,0]
[null,"ALANTO (T) SC240 50X100ML BOT IN",null,null,null,67.7,429.7,0,482.4,0,0,0,0,15]
[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 40X100GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,85768,60513,0,108931,0,0,0,0,37350]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ANTRACOL (T) WP70 50X100GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"BAYFOLAN ALGAE 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"BAYFOLAN ALGAE 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"CONFIDOR (T) SL200 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"DISCOUNTINUE PRODUCT",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ETHREL SL39 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ETHREL SL39 20X500ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"ETHREL SL39 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"FAME (T) SC480 10X(20X10ML) 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,"LUNA EXPERIENCE SC400 10X1L BOT IN",null,null,null,286,1207,0,1362,0,0,0,0,131]
[null,"LUNA EXPERIENCE SC400 40X250ML BOT IN",null,null,null,100,1196.5,0,1186.5,0,0,0,0,110]
[null,"LUNA EXPERIENCE SC400 50X100ML BOT IN",null,null,null,189.7,0,0,122.1,0,0,0,0,67.599999999999994]
[null,"NATIVO WG75 10X1KG BAG IN",null,null,null,4830,-1100,0,3589,0,0,0,0,141]
[null,"NATIVO WG75 20X500GR BAG IN",null,null,null,5996,1000,0,6426,0,0,0,0,570]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,3372.25,-200,0,3004.25,0,0,0,0,168]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,841.1,100,0,906.1,0,0,0,0,35]
[null,"OBERON (T) SC240 10X1L BOT IN",null,null,null,0,150,0,83,0,0,0,0,67]
[null,"OBERON (T) SC240 20X500ML BOT IN",null,null,null,11.5,348,0,343.5,0,0,0,0,16]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,-1,248,0,232,0,0,0,0,15]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,15,50,0,61,0,0,0,0,4]
[null,"OBERON (T) SC240 5X2L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"PLANOFIX SL4 5 20X500ML BOT IN",null,null,null,469.5,0,0,468,0,0,0,0,1.5]
[null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,276.5,0,0,276.5,0,0,0,0,0]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,164.9,2998.8,0,2679.3,0,0,0,0,484.4]
[null,"PLANOFIX SL45 10X1L BOT IN",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,"TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Grand Total",null,null,null,103057.65,69553.75,0,133345.9,0,0,0,0,39265.5]

{"sheet":"Zylem SNS Report","index":5,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,0,6,12],[1,0,1,12],[3,0,3,12],[4,0,4,12],[5,0,5,12]]}
[]
["Company Name:-BAYER"]
["Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Aug-2021"]
["Generated on 9/16/2021 11:10:44 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Kashmir Agro Centre (CLOSED),"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Kashmir Agro Centre",9061129,"ALANTO (T) SC240 10X1L BOT IN",80266685,249,797,0,1046,0,0,0,0,0]
["Kashmir Agro Centre",9061129,"ALANTO (T) SC240 20X500ML BOT IN",79934149,301.5,918,0,1129.5,0,0,0,0,90]
["Kashmir Agro Centre",9061129,"ALANTO (T) SC240 40X250ML BOT IN",79915713,120,897.75,0,1027.75,10,0,0,0,0]
["Kashmir Agro Centre",9061129,"ALANTO (T) SC240 50X100ML BOT IN",79901062,67.7,429.7,0,482.4,0,0,0,0,15]
["Kashmir Agro Centre",9061129,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,85768,80513,20000,108931,0,0,0,0,37350]
["Kashmir Agro Centre",9061129,"LUNA EXPERIENCE SC400 10X1L BOT IN",80251904,286,1207,0,1362,0,0,0,0,131]
["Kashmir Agro Centre",9061129,"LUNA EXPERIENCE SC400 40X250ML BOT IN",80549652,100,1196.5,0,1186.5,0,0,0,0,110]
["Kashmir Agro Centre",9061129,"LUNA EXPERIENCE SC400 50X100ML BOT IN",80199414,189.7,0,0,122.1,0,0,0,0,67.599999999999994]
["Kashmir Agro Centre",9061129,"NATIVO WG75 10X1KG BAG IN",80525346,4830,0,1100,3773,184,0,0,0,141]
["Kashmir Agro Centre",9061129,"NATIVO WG75 20X500GR BAG IN",79198698,5996,2800,1800,6860,434,0,0,0,570]
["Kashmir Agro Centre",9061129,"NATIVO WG75 40X250GR BAG IN",79237790,3372.25,1300,1500,3334.25,330,0,0,0,168]
["Kashmir Agro Centre",9061129,"NATIVO WG75 50X100GR BAG IN",79304102,841.1,200,100,976.1,70,0,0,0,35]
["Kashmir Agro Centre",9061129,"OBERON (T) SC240 10X1L BOT IN",80209037,0,150,0,83,0,0,0,0,67]
["Kashmir Agro Centre",9061129,"OBERON (T) SC240 20X500ML BOT IN",80026471,11.5,348,0,343.5,0,0,0,0,16]
["Kashmir Agro Centre",9061129,"OBERON (T) SC240 40X200ML BOT IN",79971362,-1,248,0,232,0,0,0,0,15]
["Kashmir Agro Centre",9061129,"OBERON (T) SC240 50X100ML BOT IN",79998538,15,50,0,61,0,0,0,0,4]
["Kashmir Agro Centre",9061129,"PLANOFIX SL4 5 20X500ML BOT IN",3825136,469.5,0,0,468,0,0,0,0,1.5]
["Kashmir Agro Centre",9061129,"PLANOFIX SL4 5 40X250ML BOT IN",3825128,276.5,0,0,276.5,0,0,0,0,0]
["Kashmir Agro Centre",9061129,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,164.9,2998.8,0,2679.3,0,0,0,0,484.4]
["GRANDTOTAL",null,null,null,103057.65,94053.75,24500,134373.9,1028,0,0,0,39265.5]

{"sheet":"OPG","index":6,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["ALANTO (T) SC240 10X1L BOT IN",{"$f":"VLOOKUP(A1,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":27},249]
["ALANTO (T) SC240 20X500ML BOT IN",{"$f":"VLOOKUP(A2,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":28},301.5]
["ALANTO (T) SC240 40X250ML BOT IN",{"$f":"VLOOKUP(A3,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":29},120]
["ALANTO (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A4,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":30},67.7]
["ANTRACOL (T) WP70 10X1KG BAG IN",{"$f":"VLOOKUP(A5,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":42},85768]
["LUNA EXPERIENCE SC400 10X1L BOT IN",{"$f":"VLOOKUP(A6,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":223},286]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",{"$f":"VLOOKUP(A7,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":225},100]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",{"$f":"VLOOKUP(A8,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":226},189.7]
["NATIVO WG75 10X1KG BAG IN",{"$f":"VLOOKUP(A9,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":290},4830]
["NATIVO WG75 20X500GR BAG IN",{"$f":"VLOOKUP(A10,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":292},5996]
["NATIVO WG75 50X100GR BAG IN",{"$f":"VLOOKUP(A11,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":294},841.1]
["OBERON (T) SC240 10X1L BOT IN",{"$f":"VLOOKUP(A12,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":296},0]
["OBERON (T) SC240 20X500ML BOT IN",{"$f":"VLOOKUP(A13,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":297},11.5]
["OBERON (T) SC240 40X200ML BOT IN",{"$f":"VLOOKUP(A14,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":299},-1]
["OBERON (T) SC240 50X100ML BOT IN",{"$f":"VLOOKUP(A15,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":300},15]
["PLANOFIX SL4 5 20X500ML BOT IN",{"$f":"VLOOKUP(A16,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":305},469.5]
["PLANOFIX SL4 5 40X250ML BOT IN",{"$f":"VLOOKUP(A17,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":306},276.5]
["PLANOFIX SL4 5 50X100ML BOT IN",{"$f":"VLOOKUP(A18,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":307},164.9]
["ADMIRE (T) WG70 30X150GR BOT IN",{"$f":"VLOOKUP(A19,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":14},0]
["ADMIRE WG70 20X300GR BAG IN",{"$f":"VLOOKUP(A20,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":17},0]
["ALIETTE WP80 10X1KG BAG IN",{"$f":"VLOOKUP(A21,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":31},0]
["ALIETTE WP80 20X250GR BAG IN",{"$f":"VLOOKUP(A22,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":33},0]
["ALIETTE WP80 40X100GR BAG IN",{"$f":"VLOOKUP(A23,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":35},0]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A24,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":43},0]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A25,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":44},0]
["ANTRACOL (T) WP70 50X100GR BAG IN",{"$f":"VLOOKUP(A26,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":45},0]
["BAYFOLAN ALGAE 10X1L BOT IN",{"$f":"VLOOKUP(A27,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1798},0]
["BAYFOLAN ALGAE 20X500ML BOT IN",{"$f":"VLOOKUP(A28,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1789},0]
["CONFIDOR (T) SL200 10X1L BOT IN",{"$f":"VLOOKUP(A29,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":113},0]
["DISCOUNTINUE PRODUCT",{"$f":"VLOOKUP(A30,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":993},0]
["ETHREL SL39 10X1L BOT IN",{"$f":"VLOOKUP(A31,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":136},0]
["ETHREL SL39 20X500ML BOT IN",{"$f":"VLOOKUP(A32,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":137},0]
["ETHREL SL39 50X100ML BOT IN",{"$f":"VLOOKUP(A33,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":138},0]
["FAME (T) SC480 10X(20X10ML) BOT IN",{"$f":"VLOOKUP(A34,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":144},0]
["FOLICUR (T) EC250 10X1L BOT IN",{"$f":"VLOOKUP(A35,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":162},0]
["NATIVO WG75 40X250GR BAG IN",{"$f":"VLOOKUP(A36,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":293},3372.25]
["OBERON (T) SC240 5X2L BOT IN",{"$f":"VLOOKUP(A37,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":301},0]
["PLANOFIX SL45 10X1L BOT IN",{"$f":"VLOOKUP(A38,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":308},0]
["REGENT GR0 3 20X1KG BAG IN",{"$f":"VLOOKUP(A39,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":335},0]
["TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN",{"$f":"VLOOKUP(A40,'[2]Product Master Sheet'!$B$2:$F$1506,5,0)","v":397},0]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reco","index":8,"n_rows":44,"n_cols":29,"rows_kept":44,"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-Aug-2021",null,null,null,null,null,null,null,null,"Distributor Report -  01-Apr-2021 TO 31-Aug-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"]
["ALANTO (T) SC240 10X1L BOT IN",249,797,0,1046,0,0,0,0,0,249,797,0,1046,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ALANTO (T) SC240 20X500ML BOT IN",301.5,918,0,1129.5,0,0,0,0,90,301.5,918,0,1129.5,0,0,0,0,90,0,0,0,0,0,0,0,0,0,"Ok"]
["ALANTO (T) SC240 40X250ML BOT IN",120,897.75,0,1027.75,10,0,0,0,0,120,897.75,0,1017.75,0,0,0,0,0,0,0,0,10,10,0,0,0,0,"Ok"]
["ALANTO (T) SC240 50X100ML BOT IN",67.7,429.7,0,482.4,0,0,0,0,15,67.7,429.7,0,482.4,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",85768,80513,20000,108931,0,0,0,0,37350,85768,60513,0,108931,0,0,0,0,37350,0,20000,20000,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 10X1L BOT IN",286,1207,0,1362,0,0,0,0,131,286,1207,0,1362,0,0,0,0,131,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 40X250ML BOT IN",100,1196.5,0,1186.5,0,0,0,0,110,100,1196.5,0,1186.5,0,0,0,0,110,0,0,0,0,0,0,0,0,0,"Ok"]
["LUNA EXPERIENCE SC400 50X100ML BOT IN",189.7,0,0,122.1,0,0,0,0,67.599999999999994,189.7,0,0,122.1,0,0,0,0,67.599999999999994,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 10X1KG BAG IN",4830,0,1100,3773,184,0,0,0,141,4830,-1100,0,3589,0,0,0,0,141,0,1100,1100,184,184,0,0,0,0,"Ok"]
["NATIVO WG75 20X500GR BAG IN",5996,2800,1800,6860,434,0,0,0,570,5996,1000,0,6426,0,0,0,0,570,0,1800,1800,434,434,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",3372.25,1300,1500,3334.25,330,0,0,0,168,3372.25,-200,0,3004.25,0,0,0,0,168,0,1500,1500,330,330,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",841.1,200,100,976.1,70,0,0,0,35,841.1,100,0,906.1,0,0,0,0,35,0,100,100,70,70,0,0,0,0,"Ok"]
["OBERON (T) SC240 10X1L BOT IN",0,150,0,83,0,0,0,0,67,0,150,0,83,0,0,0,0,67,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 20X500ML BOT IN",11.5,348,0,343.5,0,0,0,0,16,11.5,348,0,343.5,0,0,0,0,16,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",-1,248,0,232,0,0,0,0,15,-1,248,0,232,0,0,0,0,15,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",15,50,0,61,0,0,0,0,4,15,50,0,61,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 20X500ML BOT IN",469.5,0,0,468,0,0,0,0,1.5,469.5,0,0,468,0,0,0,0,1.5,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 40X250ML BOT IN",276.5,0,0,276.5,0,0,0,0,0,276.5,0,0,276.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",164.9,2998.8,0,2679.3,0,0,0,0,484.4,164.9,2998.8,0,2679.3,0,0,0,0,484.4,0,0,0,0,0,0,0,0,0,"Ok"]
["ADMIRE (T) WG70 30X150GR 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"]
["ADMIRE WG70 20X300GR 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 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"]
["ALIETTE WP80 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"]
["ANTRACOL (T) WP70 20X500GR BAG IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 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"]
["ANTRACOL (T) WP70 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"]
["BAYFOLAN ALGAE 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"]
["BAYFOLAN ALGAE 20X500ML BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["CONFIDOR (T) SL200 10X1L BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["DISCOUNTINUE PRODUCT",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 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 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"]
["ETHREL SL39 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 10X(20X10ML) BOT IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["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"]
["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 SL45 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 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"]
["TOPSTAR (T) WP80 8X(20X22.5GR) BOX IN",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["Total",103057.65,94053.75,24500,134373.9,1028,0,0,0,39265.5,103057.65,69553.75,0,133345.9,0,0,0,0,39265.5,0,24500,24500,1028,1028,0,0,0,0]