{"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,"Proneeds Solutions"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-May-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["PRONEEDS SOLUTIONS"]
["1-1-298/3 ,"]
["STREET NO.1, ASHOK NAGAR"]
["HIMAYATH NAGAR , HYDERABAD"]
["Contact : 9581865599,8367509465"]
["www.proneedssolutions.com"]
["BAYER"]
["Stock Summary"]
["1-Apr-2021 to 31-May-2021"]
["","BAYER"]
["","PRONEEDS SOLUTIONS - (from 1-Apr-2021)"]
["Particulars","1-Apr-2021 to 31-May-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["AGENDA EC25 20X500ML BOT IN",56,0,1,55]
["KINGFOG 1.25 ULV 12X1L",19,0,null,19]
["K-OBIOL WP2,5 10X1KG BOT IN",20,0,null,20]
["K-OTHRINE SC25,5 15X1L",8,0,1,7]
["MAXFORCE FORTE RB0,05X(4X30GR) APL IN",133,0,28,105]
["MAXFORCE QUANTUM 30 GMS",40,0,36,4]
["PREMISE SC350 10X1L BOT IN",11,0,5,6]
["PREMISE SC350 40X250ML BOT IN",114,0,4,110]
["RACUMIN SURE RB0,005 10X(20X100G) BAG IN",304,0,5,299]
["RESPONSAR SC25 10X1L BOT IN",51,0,null,51]
["SOLFAC 1LIT",null,0]
["SOLFAC EW50 50X100ML BOT IN",49,0,2,47]
["TEMPRID SC365.4 100X50ML BOT IN",193,0,4,189]
["TEMPRID SC365.4 20X500ML BOT IN",59,0,20,39]
["Grand Total",{"$f":"SUM(B15:B28)","v":1057},{"$f":"SUM(C15:C28)","v":0},{"$f":"SUM(D15:D28)","v":106},951]

{"sheet":"Dealer Report working","index":2,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["AGENDA EC25 20X500ML BOT IN",56,0,1,55,"AGENDA EC25 20X500ML BOT IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["KINGFOG 1.25 ULV 12X1L",19,0,null,19,"KINGFOG UL10 12X1L BOT IN",null,null,null,"AGENDA EC25 20X500ML BOT IN",56,0,1,55]
["K-OBIOL WP2,5 10X1KG BOT IN",20,0,null,20,"K-OBIOL WP2 5 10X1KG BOT IN",null,null,null,"KINGFOG UL10 12X1L BOT IN",19,0,null,19]
["K-OTHRINE SC25,5 15X1L",8,0,1,7,"K-OTHRINE SC25 5 15X1L BOT IN",null,null,null,"K-OBIOL WP2 5 10X1KG BOT IN",20,0,null,20]
["MAXFORCE FORTE RB0,05X(4X30GR) APL IN",133,0,28,105,"MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN",null,null,null,"K-OTHRINE SC25 5 15X1L BOT IN",8,0,1,7]
["MAXFORCE QUANTUM 30 GMS",40,0,36,4,"MAXFORCE QUANTUM RB 40X30G BOX IN",null,null,null,"MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN",133,0,28,105]
["PREMISE SC350 10X1L BOT IN",11,0,5,6,"PREMISE SC350 10X1L BOT IN",null,null,null,"MAXFORCE QUANTUM RB 40X30G BOX IN",40,0,36,4]
["PREMISE SC350 40X250ML BOT IN",114,0,4,110,"PREMISE SC350 40X250ML BOT IN",null,null,null,"PREMISE SC350 10X1L BOT IN",11,0,5,6]
["RACUMIN SURE RB0,005 10X(20X100G) BAG IN",304,0,5,299,"RACUMIN SURE RB0 005 10X(20X100G) BAG IN",null,null,null,"PREMISE SC350 40X250ML BOT IN",114,0,4,110]
["RESPONSAR SC25 10X1L BOT IN",51,0,null,51,"RESPONSAR SC25 10X1L BOT IN",null,null,null,"RACUMIN SURE RB0 005 10X(20X100G) BAG IN",304,0,5,299]
["SOLFAC 1LIT",null,0,null,null,"SOLFAC EW50 10X1L BOT IN",null,null,null,"RESPONSAR SC25 10X1L BOT IN",51,0,null,51]
["SOLFAC EW50 50X100ML BOT IN",49,0,2,47,"SOLFAC EW50 50X100ML BOT IN",null,null,null,"SOLFAC EW50 10X1L BOT IN",null,0]
["TEMPRID SC365.4 100X50ML BOT IN",193,0,4,189,"TEMPRID SC365.4 100X50ML BOT IN",null,null,null,"SOLFAC EW50 50X100ML BOT IN",49,0,2,47]
["TEMPRID SC365.4 20X500ML BOT IN",59,0,20,39,"TEMPRID SC365.4 20X500ML BOT IN",null,null,null,"TEMPRID SC365.4 100X50ML BOT IN",193,0,4,189]
[null,null,null,null,null,null,null,null,null,"TEMPRID SC365.4 20X500ML BOT IN",59,0,20,39]
[null,null,null,null,null,null,null,null,null,"Grand Total",1057,0,106,951]

{"sheet":"Master","index":3,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["AGENDA EC25 20X500ML BOT IN","AGENDA EC25 20X500ML BOT IN"]
["KINGFOG 1.25 ULV 12X1L","KINGFOG UL10 12X1L BOT IN"]
["K-OBIOL WP2,5 10X1KG BOT IN","K-OBIOL WP2 5 10X1KG BOT IN"]
["K-OTHRINE SC25,5 15X1L","K-OTHRINE SC25 5 15X1L BOT IN"]
["MAXFORCE FORTE RB0,05X(4X30GR) APL IN","MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN"]
["MAXFORCE QUANTUM 30 GMS","MAXFORCE QUANTUM RB 40X30G BOX IN"]
["PREMISE SC350 10X1L BOT IN","PREMISE SC350 10X1L BOT IN"]
["PREMISE SC350 40X250ML BOT IN","PREMISE SC350 40X250ML BOT IN"]
["RACUMIN SURE RB0,005 10X(20X100G) BAG IN","RACUMIN SURE RB0 005 10X(20X100G) BAG IN"]
["RESPONSAR SC25 10X1L BOT IN","RESPONSAR SC25 10X1L BOT IN"]
["SOLFAC 1LIT","SOLFAC EW50 10X1L BOT IN"]
["SOLFAC EW50 50X100ML BOT IN","SOLFAC EW50 50X100ML BOT IN"]
["TEMPRID SC365.4 100X50ML BOT IN","TEMPRID SC365.4 100X50ML BOT IN"]
["TEMPRID SC365.4 20X500ML BOT IN","TEMPRID SC365.4 20X500ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":17,"n_cols":14,"rows_kept":17,"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,"AGENDA EC25 20X500ML BOT IN",null,null,null,56,0,0,1,0,0,0,0,55]
[null,"KINGFOG UL10 12X1L BOT IN",null,null,null,19,0,0,0,0,0,0,0,19]
[null,"K-OBIOL WP2 5 10X1KG BOT IN",null,null,null,20,0,0,0,0,0,0,0,20]
[null,"K-OTHRINE SC25 5 15X1L BOT IN",null,null,null,8,0,0,1,0,0,0,0,7]
[null,"MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN",null,null,null,133,0,0,28,0,0,0,0,105]
[null,"MAXFORCE QUANTUM RB 40X30G BOX IN",null,null,null,40,0,0,36,0,0,0,0,4]
[null,"PREMISE SC350 10X1L BOT IN",null,null,null,11,0,0,5,0,0,0,0,6]
[null,"PREMISE SC350 40X250ML BOT IN",null,null,null,114,0,0,4,0,0,0,0,110]
[null,"RACUMIN SURE RB0 005 10X(20X100G) BAG IN",null,null,null,304,0,0,5,0,0,0,0,299]
[null,"RESPONSAR SC25 10X1L BOT IN",null,null,null,51,0,0,0,0,0,0,0,51]
[null,"SOLFAC EW50 10X1L BOT IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SOLFAC EW50 50X100ML BOT IN",null,null,null,49,0,0,2,0,0,0,0,47]
[null,"TEMPRID SC365.4 100X50ML BOT IN",null,null,null,193,0,0,4,0,0,0,0,189]
[null,"TEMPRID SC365.4 20X500ML BOT IN",null,null,null,59,0,0,20,0,0,0,0,39]
[null,"Grand Total",null,null,null,1057,0,0,106,0,0,0,0,951]

{"sheet":"Zylem SNS Report","index":5,"n_rows":23,"n_cols":13,"rows_kept":23,"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 31-May-2021"]
["Generated on 7/26/2021 11:54:51 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Proneeds Solutions,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Proneeds Solutions",4597115,"AGENDA EC25 20X500ML BOT IN",81749329,56,0,0,1,0,0,0,0,55]
["Proneeds Solutions",4597115,"K-OBIOL WP2 5 10X1KG BOT IN",84472255,20,0,0,0,0,0,0,0,20]
["Proneeds Solutions",4597115,"K-OTHRINE SC25 5 15X1L BOT IN",79551894,8,0,0,1,0,0,0,0,7]
["Proneeds Solutions",4597115,"KINGFOG UL10 12X1L BOT IN",3824342,19,0,0,0,0,0,0,0,19]
["Proneeds Solutions",4597115,"MAXFORCE QUANTUM RB 40X30G BOX IN",85399330,40,0,0,36,0,0,0,0,4]
["Proneeds Solutions",4597115,"PREMISE SC350 10X1L BOT IN",84924253,11,0,0,5,0,0,0,0,6]
["Proneeds Solutions",4597115,"PREMISE SC350 40X250ML BOT IN",80213867,114,0,0,4,0,0,0,0,110]
["Proneeds Solutions",4597115,"RACUMIN SURE RB0 005 10X(20X100G) BAG IN",80890192,304,0,0,5,0,0,0,0,299]
["Proneeds Solutions",4597115,"RESPONSAR SC25 10X1L BOT IN",3826558,51,0,0,0,0,0,0,0,51]
["Proneeds Solutions",4597115,"SOLFAC EW50 10X1L BOT IN",79271972,0,0,0,0,0,0,0,0,0]
["Proneeds Solutions",4597115,"SOLFAC EW50 50X100ML BOT IN",84454516,49,0,0,2,0,0,0,0,47]
["Proneeds Solutions",4597115,"TEMPRID SC365.4 100X50ML BOT IN",84952184,193,0,0,4,0,0,0,0,189]
["Proneeds Solutions",4597115,"TEMPRID SC365.4 20X500ML BOT IN",84933619,59,0,0,20,0,0,0,0,39]
["Proneeds Solutions",4597115,"MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN",79648677,133,0,0,28,0,0,0,0,105]
["GRANDTOTAL",null,null,null,1057,0,0,106,0,0,0,0,951]

{"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":18,"n_cols":29,"rows_kept":18,"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-May-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2021 TO 31-May-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"]
["AGENDA EC25 20X500ML BOT IN",56,0,0,1,0,0,0,0,55,56,0,0,1,0,0,0,0,55,0,0,0,0,0,0,0,0,0,"Ok"]
["K-OBIOL WP2 5 10X1KG BOT IN",20,0,0,0,0,0,0,0,20,20,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["K-OTHRINE SC25 5 15X1L BOT IN",8,0,0,1,0,0,0,0,7,8,0,0,1,0,0,0,0,7,0,0,0,0,0,0,0,0,0,"Ok"]
["KINGFOG UL10 12X1L BOT IN",19,0,0,0,0,0,0,0,19,19,0,0,0,0,0,0,0,19,0,0,0,0,0,0,0,0,0,"Ok"]
["MAXFORCE QUANTUM RB 40X30G BOX IN",40,0,0,36,0,0,0,0,4,40,0,0,36,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["PREMISE SC350 10X1L BOT IN",11,0,0,5,0,0,0,0,6,11,0,0,5,0,0,0,0,6,0,0,0,0,0,0,0,0,0,"Ok"]
["PREMISE SC350 40X250ML BOT IN",114,0,0,4,0,0,0,0,110,114,0,0,4,0,0,0,0,110,0,0,0,0,0,0,0,0,0,"Ok"]
["RACUMIN SURE RB0 005 10X(20X100G) BAG IN",304,0,0,5,0,0,0,0,299,304,0,0,5,0,0,0,0,299,0,0,0,0,0,0,0,0,0,"Ok"]
["RESPONSAR SC25 10X1L BOT IN",51,0,0,0,0,0,0,0,51,51,0,0,0,0,0,0,0,51,0,0,0,0,0,0,0,0,0,"Ok"]
["SOLFAC EW50 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"]
["SOLFAC EW50 50X100ML BOT IN",49,0,0,2,0,0,0,0,47,49,0,0,2,0,0,0,0,47,0,0,0,0,0,0,0,0,0,"Ok"]
["TEMPRID SC365.4 100X50ML BOT IN",193,0,0,4,0,0,0,0,189,193,0,0,4,0,0,0,0,189,0,0,0,0,0,0,0,0,0,"Ok"]
["TEMPRID SC365.4 20X500ML BOT IN",59,0,0,20,0,0,0,0,39,59,0,0,20,0,0,0,0,39,0,0,0,0,0,0,0,0,0,"Ok"]
["MAXFORCE FORTE RB0 03 5X4X(35GR) TUB IN",133,0,0,28,0,0,0,0,105,133,0,0,28,0,0,0,0,105,0,0,0,0,0,0,0,0,0,"Ok"]
["Total",1057,0,0,106,0,0,0,0,951,1057,0,0,106,0,0,0,0,951,0,0,0,0,0,0,0,0,0]