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

{"sheet":"Dealer Report","index":1,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Rohini Agro Agencies"]
["D.No 3-216, Old Market Yard,"]
["Shabhu Nagar, Miryalaguda."]
["Nalgonda District"]
["A-84/2020"]
["Contact : 9502882773"]
["BAYERCROPSCIENCE LTD HYD"]
["Stock Summary"]
["1-Apr-2020 to 31-Mar-2021"]
["","BAYERCROPSCIENCE LTD HYD"]
["","Rohini Agro Agencies - 2020-21"]
["Particulars","1-Apr-2020 to 31-Mar-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["Antracol-250 Grames",null,600,520,80]
["Antracol 500 Grames",null,800,660,140]
["Anttrocal 1 Kgs",null,350,290,60]
["BUONOS 250ML",null,320,320]
["COUNCILACTIV 45GRMS",null,3840,3780,60]
["COUNCILACTIV 90gms",null,1860,1860]
["DECIS100ML",null,150,150]
["DECIS250ML",null,160,160]
["FENOS QUICK 100ML",null,1000,950,50]
["NATIVO 100GM",null,1050,1050]
["NATIVO 1 KG",null,30,30]
["NATIVO 250 GRMS",null,960,960]
["NATIVO 50GMS",null,200,200]
["OBERON100ML"]
["OBERON200ML",null,80,40,40]
["PLANOFIX100ML",null,500,200,300]
["PLANOFIX250ML",null,200,200]
["Regentaltra-4 Kgs",null,800,735,65]
["SOLOMON 100ml",null,100,100]
["SOLOMON 1 Lts",null,110,110]
["SOLOMON 250ml",null,480,480]
["SOLOMON 500ML",null,200,200]
["Grand Total",{"$f":"SUM(B15:B36)","v":0},13790,12995,795]

{"sheet":"Dealer Report working","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["Antracol-250 Grames",null,600,520,80,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"Row Labels","Count of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["Antracol 500 Grames",null,800,660,140,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,350,290,60]
["Anttrocal 1 Kgs",null,350,290,60,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,800,660,140]
["BUONOS 250ML",null,320,320,null,"BUONOS SC430 40X250ML BOT IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,600,520,80]
["COUNCILACTIV 45GRMS",null,3840,3780,60,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,null,null,"BUONOS SC430 40X250ML BOT IN",null,320,320]
["COUNCILACTIV 90gms",null,1860,1860,null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,1860,1860]
["DECIS100ML",null,150,150,null,"DECIS EC 28 50X100ML BOT IN",null,null,null,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,3840,3780,60]
["DECIS250ML",null,160,160,null,"DECIS EC 28 40X250ML BOT IN",null,null,null,"DECIS EC 28 40X250ML BOT IN",null,160,160]
["FENOS QUICK 100ML",null,1000,950,50,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,"DECIS EC 28 50X100ML BOT IN",null,150,150]
["NATIVO 100GM",null,1050,1050,null,"NATIVO WG75 50X100GR BAG IN",null,null,null,"FENOS QUICK SC150 50X100ML BOT IN",null,1000,950,50]
["NATIVO 1 KG",null,30,30,null,"NATIVO WG75 10X1KG BAG IN",null,null,null,"NATIVO WG75 100X50GR BAG IN",null,200,200]
["NATIVO 250 GRMS",null,960,960,null,"NATIVO WG75 40X250GR BAG IN",null,null,null,"NATIVO WG75 10X1KG BAG IN",null,30,30]
["NATIVO 50GMS",null,200,200,null,"NATIVO WG75 100X50GR BAG IN",null,null,null,"NATIVO WG75 40X250GR BAG IN",null,960,960]
["OBERON100ML",null,null,null,null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,"NATIVO WG75 50X100GR BAG IN",null,1050,1050]
["OBERON200ML",null,80,40,40,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,"OBERON (T) SC240 40X200ML BOT IN",null,80,40,40]
["PLANOFIX100ML",null,500,200,300,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,"OBERON (T) SC240 50X100ML BOT IN"]
["PLANOFIX250ML",null,200,200,null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,"PLANOFIX SL4 5 40X250ML BOT IN",null,200,200]
["Regentaltra-4 Kgs",null,800,735,65,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,"PLANOFIX SL4 5 50X100ML BOT IN",null,500,200,300]
["SOLOMON 100ml",null,100,100,null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,800,735,65]
["SOLOMON 1 Lts",null,110,110,null,"SOLOMON OD300 10X1L BOT IN",null,null,null,"SOLOMON OD300 10X1L BOT IN",null,110,110]
["SOLOMON 250ml",null,480,480,null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,"SOLOMON OD300 20X500ML BOT IN",null,200,200]
["SOLOMON 500ML",null,200,200,null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,"SOLOMON OD300 40X250ML BOT IN",null,480,480]
[null,null,null,null,null,null,null,null,null,"SOLOMON OD300 50X100ML BOT IN",null,100,100]
[null,null,null,null,null,null,null,null,null,"Grand Total",null,13790,12995,795]

{"sheet":"Master","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["Antracol-250 Grames","ANTRACOL (T) WP70 40X250GR BAG IN"]
["Antracol 500 Grames","ANTRACOL (T) WP70 20X500GR BAG IN"]
["Anttrocal 1 Kgs","ANTRACOL (T) WP70 10X1KG BAG IN"]
["BUONOS 250ML","BUONOS SC430 40X250ML BOT IN"]
["COUNCILACTIV 45GRMS","COUNCIL ACTIV WG30 8X(10X45GR) BOX IN"]
["COUNCILACTIV 90gms","COUNCIL ACTIV WG30 12X(5X90GR) BOX IN"]
["DECIS100ML","DECIS EC 28 50X100ML BOT IN"]
["DECIS250ML","DECIS EC 28 40X250ML BOT IN"]
["FENOS QUICK 100ML","FENOS QUICK SC150 50X100ML BOT IN"]
["NATIVO 100GM","NATIVO WG75 50X100GR BAG IN"]
["NATIVO 1 KG","NATIVO WG75 10X1KG BAG IN"]
["NATIVO 250 GRMS","NATIVO WG75 40X250GR BAG IN"]
["NATIVO 50GMS","NATIVO WG75 100X50GR BAG IN"]
["OBERON100ML","OBERON (T) SC240 50X100ML BOT IN"]
["OBERON200ML","OBERON (T) SC240 40X200ML BOT IN"]
["PLANOFIX100ML","PLANOFIX SL4 5 50X100ML BOT IN"]
["PLANOFIX250ML","PLANOFIX SL4 5 40X250ML BOT IN"]
["Regentaltra-4 Kgs","REGENT ULTRA GR0 6 5X4KG BAG IN"]
["SOLOMON 100ml","SOLOMON OD300 50X100ML BOT IN"]
["SOLOMON 1 Lts","SOLOMON OD300 10X1L BOT IN"]
["SOLOMON 250ml","SOLOMON OD300 40X250ML BOT IN"]
["SOLOMON 500ML","SOLOMON OD300 20X500ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"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,350,0,290,0,0,0,0,60]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,0,800,0,660,0,0,0,0,140]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,0,600,0,520,0,0,0,0,80]
[null,"BUONOS SC430 40X250ML BOT IN",null,null,null,0,320,0,320,0,0,0,0,0]
[null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,0,1860,0,1860,0,0,0,0,0]
[null,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",null,null,null,0,3840,0,3780,0,0,0,0,60]
[null,"DECIS EC 28 40X250ML BOT IN",null,null,null,0,160,0,160,0,0,0,0,0]
[null,"DECIS EC 28 50X100ML BOT IN",null,null,null,0,150,0,150,0,0,0,0,0]
[null,"FENOS QUICK SC150 50X100ML BOT IN",null,null,null,0,1000,0,950,0,0,0,0,50]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,0,200,0,200,0,0,0,0,0]
[null,"NATIVO WG75 10X1KG BAG IN",null,null,null,0,30,0,30,0,0,0,0,0]
[null,"NATIVO WG75 40X250GR BAG IN",null,null,null,0,960,0,960,0,0,0,0,0]
[null,"NATIVO WG75 50X100GR BAG IN",null,null,null,0,1050,0,1050,0,0,0,0,0]
[null,"OBERON (T) SC240 40X200ML BOT IN",null,null,null,0,80,0,40,0,0,0,0,40]
[null,"OBERON (T) SC240 50X100ML BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"PLANOFIX SL4 5 40X250ML BOT IN",null,null,null,0,200,0,200,0,0,0,0,0]
[null,"PLANOFIX SL4 5 50X100ML BOT IN",null,null,null,0,500,0,200,0,0,0,0,300]
[null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,0,800,0,735,0,0,0,0,65]
[null,"SOLOMON OD300 10X1L BOT IN",null,null,null,0,110,0,110,0,0,0,0,0]
[null,"SOLOMON OD300 20X500ML BOT IN",null,null,null,0,200,0,200,0,0,0,0,0]
[null,"SOLOMON OD300 40X250ML BOT IN",null,null,null,0,480,0,480,0,0,0,0,0]
[null,"SOLOMON OD300 50X100ML BOT IN",null,null,null,0,100,0,100,0,0,0,0,0]
[null,"Grand Total",null,null,null,0,13790,0,12995,0,0,0,0,795]

{"sheet":"Zylem SNS Report","index":5,"n_rows":31,"n_cols":13,"rows_kept":31,"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-2020 TO 31-Mar-2021"]
["Generated on 7/13/2021 10:24:23 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Rohini Agro Agencies,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Rohini Agro Agencies",4601131,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,0,350,0,290,0,0,0,0,60]
["Rohini Agro Agencies",4601131,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,0,800,0,660,0,0,0,0,140]
["Rohini Agro Agencies",4601131,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,0,600,0,520,0,0,0,0,80]
["Rohini Agro Agencies",4601131,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",80882629,0,1860,0,1980,120,0,0,0,0]
["Rohini Agro Agencies",4601131,"COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",80861729,0,3840,0,4080,300,0,0,0,60]
["Rohini Agro Agencies",4601131,"DECIS EC 28 40X250ML BOT IN",3823346,0,200,40,160,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"FENOS QUICK SC150 50X100ML BOT IN",80942990,0,1000,0,1000,50,0,0,0,50]
["Rohini Agro Agencies",4601131,"NATIVO WG75 100X50GR BAG IN",80580061,0,400,200,300,100,0,0,0,0]
["Rohini Agro Agencies",4601131,"NATIVO WG75 10X1KG BAG IN",80525346,0,30,0,30,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"NATIVO WG75 40X250GR BAG IN",79237790,0,1000,40,1032,72,0,0,0,0]
["Rohini Agro Agencies",4601131,"NATIVO WG75 50X100GR BAG IN",79304102,0,1050,0,1050,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"OBERON (T) SC240 40X200ML BOT IN",79971362,0,240,160,80,40,0,0,0,40]
["Rohini Agro Agencies",4601131,"OBERON (T) SC240 50X100ML BOT IN",79998538,0,200,200,0,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"PLANOFIX SL4 5 40X250ML BOT IN",3825128,0,200,0,200,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"PLANOFIX SL4 5 50X100ML BOT IN",3825098,0,500,0,200,0,0,0,0,300]
["Rohini Agro Agencies",4601131,"REGENT ULTRA GR0 6 5X4KG BAG IN",84093394,0,800,0,735,0,0,0,0,65]
["Rohini Agro Agencies",4601131,"SOLOMON OD300 10X1L BOT IN",79637365,0,110,0,110,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"SOLOMON OD300 20X500ML BOT IN",79987870,0,200,0,200,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"SOLOMON OD300 40X250ML BOT IN",79706723,0,600,120,480,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"SOLOMON OD300 50X100ML BOT IN",79641931,0,350,250,100,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"DECIS EC 28 50X100ML BOT IN",3823311,0,250,100,150,0,0,0,0,0]
["Rohini Agro Agencies",4601131,"BUONOS SC430 40X250ML BOT IN",86224801,0,400,80,320,0,0,0,0,0]
["GRANDTOTAL",null,null,null,0,14980,1190,13677,682,0,0,0,795]

{"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":26,"n_cols":29,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -01-Apr-2020 TO 31-Mar-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-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"]
["ANTRACOL (T) WP70 10X1KG BAG IN",0,350,0,290,0,0,0,0,60,0,350,0,290,0,0,0,0,60,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",0,800,0,660,0,0,0,0,140,0,800,0,660,0,0,0,0,140,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",0,600,0,520,0,0,0,0,80,0,600,0,520,0,0,0,0,80,0,0,0,0,0,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,1860,0,1980,120,0,0,0,0,0,1860,0,1860,0,0,0,0,0,0,0,0,120,120,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 8X(10X45GR) BOX IN",0,3840,0,4080,300,0,0,0,60,0,3840,0,3780,0,0,0,0,60,0,0,0,300,300,0,0,0,0,"Ok"]
["DECIS EC 28 40X250ML BOT IN",0,200,40,160,0,0,0,0,0,0,160,0,160,0,0,0,0,0,0,40,40,0,0,0,0,0,0,"Ok"]
["FENOS QUICK SC150 50X100ML BOT IN",0,1000,0,1000,50,0,0,0,50,0,1000,0,950,0,0,0,0,50,0,0,0,50,50,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR BAG IN",0,400,200,300,100,0,0,0,0,0,200,0,200,0,0,0,0,0,0,200,200,100,100,0,0,0,0,"Ok"]
["NATIVO WG75 10X1KG BAG IN",0,30,0,30,0,0,0,0,0,0,30,0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 40X250GR BAG IN",0,1000,40,1032,72,0,0,0,0,0,960,0,960,0,0,0,0,0,0,40,40,72,72,0,0,0,0,"Ok"]
["NATIVO WG75 50X100GR BAG IN",0,1050,0,1050,0,0,0,0,0,0,1050,0,1050,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["OBERON (T) SC240 40X200ML BOT IN",0,240,160,80,40,0,0,0,40,0,80,0,40,0,0,0,0,40,0,160,160,40,40,0,0,0,0,"Ok"]
["OBERON (T) SC240 50X100ML BOT IN",0,200,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,200,200,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 40X250ML BOT IN",0,200,0,200,0,0,0,0,0,0,200,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["PLANOFIX SL4 5 50X100ML BOT IN",0,500,0,200,0,0,0,0,300,0,500,0,200,0,0,0,0,300,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT ULTRA GR0 6 5X4KG BAG IN",0,800,0,735,0,0,0,0,65,0,800,0,735,0,0,0,0,65,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 10X1L BOT IN",0,110,0,110,0,0,0,0,0,0,110,0,110,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 20X500ML BOT IN",0,200,0,200,0,0,0,0,0,0,200,0,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 40X250ML BOT IN",0,600,120,480,0,0,0,0,0,0,480,0,480,0,0,0,0,0,0,120,120,0,0,0,0,0,0,"Ok"]
["SOLOMON OD300 50X100ML BOT IN",0,350,250,100,0,0,0,0,0,0,100,0,100,0,0,0,0,0,0,250,250,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 50X100ML BOT IN",0,250,100,150,0,0,0,0,0,0,150,0,150,0,0,0,0,0,0,100,100,0,0,0,0,0,0,"Ok"]
["BUONOS SC430 40X250ML BOT IN",0,400,80,320,0,0,0,0,0,0,320,0,320,0,0,0,0,0,0,80,80,0,0,0,0,0,0,"Ok"]
["Total",0,14980,1190,13677,682,0,0,0,795,0,13790,0,12995,0,0,0,0,795,0,1190,1190,682,682,0,0,0,0]