{"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":3,"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,"Sunil Krishi Kendra"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 31-Jul-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Sunil Krishi Kendra"]
["Village Suwartala Block-Saza"]
["District - Bemetara"]
["BAYER CROP SCIENCE"]
["Stock Category Summary"]
["1-Apr-2021 to 31-Jul-2021"]
["","BAYER CROP SCIENCE"]
["","Sunil Krishi Kendra - (from 1-Apr-2020)"]
["Particulars","1-Apr-2021 to 31-Jul-2021"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity",null,"sapl sale","status","sapl pur","status","clsoig sapl ","stauts"]
["ADMIRE WG70 125X(8X2)GR",null,2,null,2,{"$f":"TRIM(A12)","v":"ADMIRE WG70 125X(8X2)GR"},{"$f":"IFERROR(VLOOKUP(F12,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},{"$f":"G12=D12","v":true},{"$f":"IFERROR(VLOOKUP(F12,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":2},{"$f":"I12=C12","v":true},{"$f":"B12+I12-G12","v":2},{"$f":"K12=E12","v":true}]
["ADORA 20X200 ML",-43,20,null,-23,{"$f":"TRIM(A13)","v":"ADORA 20X200 ML"},{"$f":"IFERROR(VLOOKUP(F13,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},{"$f":"G13=D13","v":true},{"$f":"IFERROR(VLOOKUP(F13,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":20},{"$f":"I13=C13","v":true},{"$f":"B13+I13-G13","v":-23},{"$f":"K13=E13","v":true}]
["ADORA 4X1 LTR",-20,8,null,-12,"ADORA 4X1 LTR",{"$f":"IFERROR(VLOOKUP(F14,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F14,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":8},true,-12,true]
["ADORA 50X100 ML",-46,10,null,-36,"ADORA 50X100 ML",{"$f":"IFERROR(VLOOKUP(F15,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F15,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":10},true,-36,true]
["ADORA 8X500 ML",-13,20,null,7,"ADORA 8X500 ML",{"$f":"IFERROR(VLOOKUP(F16,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F16,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":20},true,7,true]
["ALIETTE 40X100GR",null,4,null,4,"ALIETTE 40X100GR",{"$f":"IFERROR(VLOOKUP(F17,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F17,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":4},true,4,true]
["ANTRACOL 10X1 KG",255,250,14,491,"ANTRACOL 10X1 KG",{"$f":"IFERROR(VLOOKUP(F18,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":14},true,{"$f":"IFERROR(VLOOKUP(F18,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":250},true,491,true]
["ANTRACOL 40X250 GR",156,250,null,406,"ANTRACOL 40X250 GR",{"$f":"IFERROR(VLOOKUP(F19,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F19,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":250},true,406,true]
["ANTRACOL WP 70 20X500GM",520,300,15,805,"ANTRACOL WP 70 20X500GM",{"$f":"IFERROR(VLOOKUP(F20,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":15},true,{"$f":"IFERROR(VLOOKUP(F20,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":300},true,805,true]
["ARIZE 6444 GOLD 10X3 KG",null,4500,4152.5,347.5,"ARIZE 6444 GOLD 10X3 KG",{"$f":"IFERROR(VLOOKUP(F21,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":4152.5},true,{"$f":"IFERROR(VLOOKUP(F21,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":4500},true,347.5,true]
["ARIZE AZ 8433 10X3 KG",-300,6420,3875,2245,"ARIZE AZ 8433 10X3 KG",{"$f":"IFERROR(VLOOKUP(F22,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":3875},true,{"$f":"IFERROR(VLOOKUP(F22,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":6420},true,2245,true]
["ARIZE AZ 8433 6X5 KG",null,300,null,300,"ARIZE AZ 8433 6X5 KG",{"$f":"IFERROR(VLOOKUP(F23,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F23,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":300},true,300,true]
["DECIS 40X250ML",null,20,null,20,"DECIS 40X250ML",{"$f":"IFERROR(VLOOKUP(F24,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F24,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":20},true,20,true]
["DECIS 50X100ML",null,10,null,10,"DECIS 50X100ML",{"$f":"IFERROR(VLOOKUP(F25,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F25,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":10},true,10,true]
["GAUCHO 50X100ML",null,5,5,null,"GAUCHO 50X100ML",{"$f":"IFERROR(VLOOKUP(F26,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":5},true,{"$f":"IFERROR(VLOOKUP(F26,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":5},true,0,true]
["GAUCHO FS600 100X50ML",null,15,15,null,"GAUCHO FS600 100X50ML",{"$f":"IFERROR(VLOOKUP(F27,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":15},true,{"$f":"IFERROR(VLOOKUP(F27,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":15},true,0,true]
["LARVIN 20X500 ML",null,20,null,20,"LARVIN 20X500 ML",{"$f":"IFERROR(VLOOKUP(F28,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F28,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":20},true,20,true]
["LARVIN WP75 20X250 GR",null,25,null,25,"LARVIN WP75 20X250 GR",{"$f":"IFERROR(VLOOKUP(F29,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F29,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":25},true,25,true]
["NATIVO 100X50 BAG",null,null,null,null,"NATIVO 100X50 BAG",{"$f":"IFERROR(VLOOKUP(F30,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F30,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":0},true,0,true]
["REGENT SC50 20X250ML",5,5,5,5,"REGENT SC50 20X250ML",{"$f":"IFERROR(VLOOKUP(F31,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":5},true,{"$f":"IFERROR(VLOOKUP(F31,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":5},true,5,true]
["REGENT SC 50X100 ML",1,10,1,10,"REGENT SC 50X100 ML",{"$f":"IFERROR(VLOOKUP(F32,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":1},true,{"$f":"IFERROR(VLOOKUP(F32,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":10},true,10,true]
["WHIPSUPER 10X1 LTR",2,200,2,200,"WHIPSUPER 10X1 LTR",{"$f":"IFERROR(VLOOKUP(F33,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":2},true,{"$f":"IFERROR(VLOOKUP(F33,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":200},true,200,true]
["WHIPSUPER 20X500 ML",-17,150,null,133,"WHIPSUPER 20X500 ML",{"$f":"IFERROR(VLOOKUP(F34,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F34,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":150},true,133,true]
["WHIPSUPER 50X100 ML",null,25,null,25,"WHIPSUPER 50X100 ML",{"$f":"IFERROR(VLOOKUP(F35,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,{"$f":"IFERROR(VLOOKUP(F35,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":25},true,25,true]
["WHIPSUPER T  EC90 40X250ML",30,20,30,20,"WHIPSUPER T EC90 40X250ML",{"$f":"IFERROR(VLOOKUP(F36,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":30},true,{"$f":"IFERROR(VLOOKUP(F36,'[2]pivot pur'!$E$4:$F$27,2,0),0)","v":20},true,20,true]
["Grand Total",null,null,null,null,"Grand Total",{"$f":"IFERROR(VLOOKUP(F37,'[2]pivot sale'!$E$4:$F$13,2,0),0)","v":0},true,null,true,0,true]

{"sheet":"Dealer Report working","index":2,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["ADMIRE WG70 125X(8X2)GR",null,2,null,2,"ADMIRE WG70 125X(8X2GR) BAG IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["ADORA 20X200 ML",-43,20,null,-23,"ADORA (T) SC100 20X200ML BOT IN",null,null,null,"ADMIRE WG70 125X(8X2GR) BAG IN",null,2,null,2]
["ADORA 4X1 LTR",-20,8,null,-12,"ADORA (T) SC100 4X1L BOT IN",null,null,null,"ADORA (T) SC100 20X200ML BOT IN",-43,20,null,-23]
["ADORA 50X100 ML",-46,10,null,-36,"ADORA (T) SC100 50X100ML BOT IN",null,null,null,"ADORA (T) SC100 4X1L BOT IN",-20,8,null,-12]
["ADORA 8X500 ML",-13,20,null,7,"ADORA (T) SC100 8X500ML BOT IN",null,null,null,"ADORA (T) SC100 50X100ML BOT IN",-46,10,null,-36]
["ALIETTE 40X100GR",null,4,null,4,"ALIETTE WP80 40X100GR BAG IN",null,null,null,"ADORA (T) SC100 8X500ML BOT IN",-13,20,null,7]
["ANTRACOL 10X1 KG",255,250,14,491,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"ALIETTE WP80 40X100GR BAG IN",null,4,null,4]
["ANTRACOL 40X250 GR",156,250,null,406,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",255,250,14,491]
["ANTRACOL WP 70 20X500GM",520,300,15,805,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",520,300,15,805]
["ARIZE 6444 GOLD 10X3 KG",null,4500,4152.5,347.5,"ARIZE AZ 8433 DT LOC 10X3KG BAG IN",null,null,null,"ANTRACOL (T) WP70 40X250GR BAG IN",156,250,null,406]
["ARIZE AZ 8433 10X3 KG",-300,6420,3875,2245,"ARIZE AZ 8433 DT LOC 10X3KG BAG IN",null,null,null,"ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",null,300,null,300]
["ARIZE AZ 8433 6X5 KG",null,300,null,300,"ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",null,null,null,"ARIZE AZ 8433 DT LOC 10X3KG BAG IN",-300,10920,8027.5,2592.5]
["DECIS 40X250ML",null,20,null,20,"DECIS EC 28 40X250ML BOT IN",null,null,null,"DECIS EC 28 40X250ML BOT IN",null,20,null,20]
["DECIS 50X100ML",null,10,null,10,"DECIS EC 28 50X100ML BOT IN",null,null,null,"DECIS EC 28 50X100ML BOT IN",null,10,null,10]
["GAUCHO 50X100ML",null,5,5,null,"GAUCHO FS600 50X100ML BOT IN",null,null,null,"GAUCHO FS600 100X50ML BOT IN",null,15,15]
["GAUCHO FS600 100X50ML",null,15,15,null,"GAUCHO FS600 100X50ML BOT IN",null,null,null,"GAUCHO FS600 50X100ML BOT IN",null,5,5]
["LARVIN 20X500 ML",null,20,null,20,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,"LARVIN (T) WP75 20X250GR BAG IN",null,25,null,25]
["LARVIN WP75 20X250 GR",null,25,null,25,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,"LARVIN (T) WP75 20X500GR BAG IN",null,20,null,20]
["NATIVO 100X50 BAG",null,null,null,null,"NATIVO WG75 100X50GR BAG IN",null,null,null,"NATIVO WG75 100X50GR BAG IN"]
["REGENT SC50 20X250ML",5,5,5,5,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,"REGENT (T) SC50 20X250ML BOT IN",5,5,5,5]
["REGENT SC 50X100 ML",1,10,1,10,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,"REGENT (T) SC50 50X100ML BOT IN",1,10,1,10]
["WHIPSUPER 10X1 LTR",2,200,2,200,"WHIPSUPER (T) EC90 10X1L BOT IN",null,null,null,"WHIPSUPER (T) EC90 10X1L BOT IN",2,200,2,200]
["WHIPSUPER 20X500 ML",-17,150,null,133,"WHIPSUPER (T) EC90 20X500ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 20X500ML BOT IN",-17,150,null,133]
["WHIPSUPER 50X100 ML",null,25,null,25,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 40X250ML BOT IN",30,20,30,20]
["WHIPSUPER T  EC90 40X250ML",30,20,30,20,"WHIPSUPER (T) EC90 40X250ML BOT IN",null,null,null,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,25,null,25]
[null,null,null,null,null,null,null,null,null,"Grand Total",530,12589,8114.5,5004.5]

{"sheet":"Master","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["ADMIRE WG70 125X(8X2)GR","ADMIRE WG70 125X(8X2GR) BAG IN"]
["ADORA 20X200 ML","ADORA (T) SC100 20X200ML BOT IN"]
["ADORA 4X1 LTR","ADORA (T) SC100 4X1L BOT IN"]
["ADORA 50X100 ML","ADORA (T) SC100 50X100ML BOT IN"]
["ADORA 8X500 ML","ADORA (T) SC100 8X500ML BOT IN"]
["ALIETTE 40X100GR","ALIETTE WP80 40X100GR BAG IN"]
["ANTRACOL 10X1 KG","ANTRACOL (T) WP70 10X1KG BAG IN"]
["ANTRACOL 40X250 GR","ANTRACOL (T) WP70 40X250GR BAG IN"]
["ANTRACOL WP 70 20X500GM","ANTRACOL (T) WP70 20X500GR BAG IN"]
["ARIZE 6444 GOLD 10X3 KG","ARIZE AZ 8433 DT LOC 10X3KG BAG IN"]
["ARIZE AZ 8433 10X3 KG","ARIZE AZ 8433 DT LOC 10X3KG BAG IN"]
["ARIZE AZ 8433 6X5 KG","ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN"]
["DECIS 40X250ML","DECIS EC 28 40X250ML BOT IN"]
["DECIS 50X100ML","DECIS EC 28 50X100ML BOT IN"]
["GAUCHO 50X100ML","GAUCHO FS600 50X100ML BOT IN"]
["GAUCHO FS600 100X50ML","GAUCHO FS600 100X50ML BOT IN"]
["LARVIN 20X500 ML","LARVIN (T) WP75 20X500GR BAG IN"]
["LARVIN WP75 20X250 GR","LARVIN (T) WP75 20X250GR BAG IN"]
["NATIVO 100X50 BAG","NATIVO WG75 100X50GR BAG IN"]
["REGENT SC50 20X250ML","REGENT (T) SC50 20X250ML BOT IN"]
["REGENT SC 50X100 ML","REGENT (T) SC50 50X100ML BOT IN"]
["WHIPSUPER 10X1 LTR","WHIPSUPER (T) EC90 10X1L BOT IN"]
["WHIPSUPER 20X500 ML","WHIPSUPER (T) EC90 20X500ML BOT IN"]
["WHIPSUPER 50X100 ML","WHIPSUPER (T) EC90 50X100ML BOT IN"]
["WHIPSUPER T  EC90 40X250ML","WHIPSUPER (T) EC90 40X250ML BOT IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"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 WG70 125X(8X2GR) BAG IN",null,null,null,0,2,0,0,0,0,0,0,2]
[null,"ADORA (T) SC100 20X200ML BOT IN",null,null,null,-43,20,0,0,0,0,0,0,-23]
[null,"ADORA (T) SC100 4X1L BOT IN",null,null,null,-20,8,0,0,0,0,0,0,-12]
[null,"ADORA (T) SC100 50X100ML BOT IN",null,null,null,-46,10,0,0,0,0,0,0,-36]
[null,"ADORA (T) SC100 8X500ML BOT IN",null,null,null,-13,20,0,0,0,0,0,0,7]
[null,"ALIETTE WP80 40X100GR BAG IN",null,null,null,0,4,0,0,0,0,0,0,4]
[null,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,255,250,0,14,0,0,0,0,491]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,520,300,0,15,0,0,0,0,805]
[null,"ANTRACOL (T) WP70 40X250GR BAG IN",null,null,null,156,250,0,0,0,0,0,0,406]
[null,"ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",null,null,null,0,300,0,0,0,0,0,0,300]
[null,"ARIZE AZ 8433 DT LOC 10X3KG BAG IN",null,null,null,-300,10920,0,8027.5,0,0,0,0,2592.5]
[null,"DECIS EC 28 40X250ML BOT IN",null,null,null,0,20,0,0,0,0,0,0,20]
[null,"DECIS EC 28 50X100ML BOT IN",null,null,null,0,10,0,0,0,0,0,0,10]
[null,"GAUCHO FS600 100X50ML BOT IN",null,null,null,0,15,0,15,0,0,0,0,0]
[null,"GAUCHO FS600 50X100ML BOT IN",null,null,null,0,5,0,5,0,0,0,0,0]
[null,"LARVIN (T) WP75 20X250GR BAG IN",null,null,null,0,25,0,0,0,0,0,0,25]
[null,"LARVIN (T) WP75 20X500GR BAG IN",null,null,null,0,20,0,0,0,0,0,0,20]
[null,"NATIVO WG75 100X50GR BAG IN",null,null,null,0,0,0,0,0,0,0,0,0]
[null,"REGENT (T) SC50 20X250ML BOT IN",null,null,null,5,5,0,5,0,0,0,0,5]
[null,"REGENT (T) SC50 50X100ML BOT IN",null,null,null,1,10,0,1,0,0,0,0,10]
[null,"WHIPSUPER (T) EC90 10X1L BOT IN",null,null,null,2,200,0,2,0,0,0,0,200]
[null,"WHIPSUPER (T) EC90 20X500ML BOT IN",null,null,null,-17,150,0,0,0,0,0,0,133]
[null,"WHIPSUPER (T) EC90 40X250ML BOT IN",null,null,null,30,20,0,30,0,0,0,0,20]
[null,"WHIPSUPER (T) EC90 50X100ML BOT IN",null,null,null,0,25,0,0,0,0,0,0,25]
[null,"Grand Total",null,null,null,530,12589,0,8114.5,0,0,0,0,5004.5]

{"sheet":"Zylem SNS Report","index":5,"n_rows":32,"n_cols":13,"rows_kept":32,"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-Jul-2021"]
["Generated on 8/18/2021 6:26:56 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Sunil Krishi Kendra,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Sunil Krishi Kendra",3925954,"ADMIRE WG70 125X(8X2GR) BAG IN",6101665,0,2,0,0,0,0,0,0,2]
["Sunil Krishi Kendra",3925954,"ADORA (T) SC100 20X200ML BOT IN",79997752,-43,20,0,0,0,0,0,0,-23]
["Sunil Krishi Kendra",3925954,"ADORA (T) SC100 4X1L BOT IN",80048807,-20,8,0,0,0,0,0,0,-12]
["Sunil Krishi Kendra",3925954,"ADORA (T) SC100 50X100ML BOT IN",84399086,-46,10,0,0,0,0,0,0,-36]
["Sunil Krishi Kendra",3925954,"ADORA (T) SC100 8X500ML BOT IN",79981201,-13,20,0,0,0,0,0,0,7]
["Sunil Krishi Kendra",3925954,"ALIETTE WP80 40X100GR BAG IN",3822331,0,4,0,0,0,0,0,0,4]
["Sunil Krishi Kendra",3925954,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,255,250,0,14,0,0,0,0,491]
["Sunil Krishi Kendra",3925954,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,520,300,0,15,0,0,0,0,805]
["Sunil Krishi Kendra",3925954,"ANTRACOL (T) WP70 40X250GR BAG IN",6112179,156,250,0,0,0,0,0,0,406]
["Sunil Krishi Kendra",3925954,"ARIZE AZ 8433 DT LOC 10X3KG BAG IN",85363271,-300,10920,0,8027.5,0,0,0,0,2592.5]
["Sunil Krishi Kendra",3925954,"DECIS EC 28 40X250ML BOT IN",3823346,0,20,0,0,0,0,0,0,20]
["Sunil Krishi Kendra",3925954,"GAUCHO FS600 100X50ML BOT IN",80034733,0,15,0,15,0,0,0,0,0]
["Sunil Krishi Kendra",3925954,"GAUCHO FS600 50X100ML BOT IN",79664141,0,5,0,5,0,0,0,0,0]
["Sunil Krishi Kendra",3925954,"LARVIN (T) WP75 20X250GR BAG IN",6003167,0,25,0,0,0,0,0,0,25]
["Sunil Krishi Kendra",3925954,"LARVIN (T) WP75 20X500GR BAG IN",6005291,0,20,0,0,0,0,0,0,20]
["Sunil Krishi Kendra",3925954,"REGENT (T) SC50 20X250ML BOT IN",5976951,5,5,0,5,0,0,0,0,5]
["Sunil Krishi Kendra",3925954,"REGENT (T) SC50 50X100ML BOT IN",5975343,1,10,0,1,0,0,0,0,10]
["Sunil Krishi Kendra",3925954,"WHIPSUPER (T) EC90 10X1L BOT IN",5972697,2,200,0,2,0,0,0,0,200]
["Sunil Krishi Kendra",3925954,"WHIPSUPER (T) EC90 20X500ML BOT IN",5955989,-17,150,0,0,0,0,0,0,133]
["Sunil Krishi Kendra",3925954,"WHIPSUPER (T) EC90 40X250ML BOT IN",5966131,30,20,0,30,0,0,0,0,20]
["Sunil Krishi Kendra",3925954,"WHIPSUPER (T) EC90 50X100ML BOT IN",5994151,0,25,0,0,0,0,0,0,25]
["Sunil Krishi Kendra",3925954,"DECIS EC 28 50X100ML BOT IN",3823311,0,10,0,0,0,0,0,0,10]
["Sunil Krishi Kendra",3925954,"ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",86924617,0,300,0,0,0,0,0,0,300]
["GRANDTOTAL",null,null,null,530,12589,0,8114.5,0,0,0,0,5004.5]

{"sheet":"OPG","index":6,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["ADMIRE WG70 125X(8X2GR) BAG IN",{"$f":"VLOOKUP(A1,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":16},0]
["ADORA (T) SC100 20X200ML BOT IN",{"$f":"VLOOKUP(A2,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":19},-43]
["ADORA (T) SC100 4X1L BOT IN",{"$f":"VLOOKUP(A3,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":20},-20]
["ADORA (T) SC100 50X100ML BOT IN",{"$f":"VLOOKUP(A4,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":21},-46]
["ADORA (T) SC100 8X500ML BOT IN",{"$f":"VLOOKUP(A5,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":23},-13]
["ALIETTE WP80 40X100GR BAG IN",{"$f":"VLOOKUP(A6,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":35},0]
["ANTRACOL (T) WP70 10X1KG BAG IN",{"$f":"VLOOKUP(A7,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":42},255]
["ANTRACOL (T) WP70 20X500GR BAG IN",{"$f":"VLOOKUP(A8,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":43},520]
["ANTRACOL (T) WP70 40X250GR BAG IN",{"$f":"VLOOKUP(A9,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":44},156]
["ARIZE AZ 8433 DT LOC 10X3KG BAG IN",{"$f":"VLOOKUP(A10,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":76},-300]
["DECIS EC 28 40X250ML BOT IN",{"$f":"VLOOKUP(A11,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":126},0]
["GAUCHO FS600 100X50ML BOT IN",{"$f":"VLOOKUP(A12,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":179},0]
["GAUCHO FS600 50X100ML BOT IN",{"$f":"VLOOKUP(A13,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":182},0]
["LARVIN (T) WP75 20X250GR BAG IN",{"$f":"VLOOKUP(A14,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":205},0]
["LARVIN (T) WP75 20X500GR BAG IN",{"$f":"VLOOKUP(A15,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":206},0]
["REGENT (T) SC50 20X250ML BOT IN",{"$f":"VLOOKUP(A16,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":325},5]
["REGENT (T) SC50 50X100ML BOT IN",{"$f":"VLOOKUP(A17,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":327},1]
["WHIPSUPER (T) EC90 10X1L BOT IN",{"$f":"VLOOKUP(A18,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":403},2]
["WHIPSUPER (T) EC90 20X500ML BOT IN",{"$f":"VLOOKUP(A19,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":404},-17]
["WHIPSUPER (T) EC90 50X100ML BOT IN",{"$f":"VLOOKUP(A20,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":406},0]
["DECIS EC 28 50X100ML BOT IN",{"$f":"VLOOKUP(A21,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":928},0]
["ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",{"$f":"VLOOKUP(A22,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":1796},0]
["NATIVO WG75 100X50GR BAG IN",{"$f":"VLOOKUP(A23,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":289},0]
["WHIPSUPER (T) EC90 40X250ML BOT IN",{"$f":"VLOOKUP(A24,'[3]Product Master Sheet'!$B$2:$F$1506,5,0)","v":405},30]

{"sheet":"Reco","index":7,"n_rows":28,"n_cols":29,"rows_kept":28,"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-Jul-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2021 TO 31-Jul-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"]
["ADMIRE WG70 125X(8X2GR) BAG IN",0,2,0,0,0,0,0,0,2,0,2,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,"Ok"]
["ADORA (T) SC100 20X200ML BOT IN",-43,20,0,0,0,0,0,0,-23,-43,20,0,0,0,0,0,0,-23,0,0,0,0,0,0,0,0,0,"Ok"]
["ADORA (T) SC100 4X1L BOT IN",-20,8,0,0,0,0,0,0,-12,-20,8,0,0,0,0,0,0,-12,0,0,0,0,0,0,0,0,0,"Ok"]
["ADORA (T) SC100 50X100ML BOT IN",-46,10,0,0,0,0,0,0,-36,-46,10,0,0,0,0,0,0,-36,0,0,0,0,0,0,0,0,0,"Ok"]
["ADORA (T) SC100 8X500ML BOT IN",-13,20,0,0,0,0,0,0,7,-13,20,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,"Ok"]
["ALIETTE WP80 40X100GR BAG IN",0,4,0,0,0,0,0,0,4,0,4,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 10X1KG BAG IN",255,250,0,14,0,0,0,0,491,255,250,0,14,0,0,0,0,491,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",520,300,0,15,0,0,0,0,805,520,300,0,15,0,0,0,0,805,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 40X250GR BAG IN",156,250,0,0,0,0,0,0,406,156,250,0,0,0,0,0,0,406,0,0,0,0,0,0,0,0,0,"Ok"]
["ARIZE AZ 8433 DT LOC 10X3KG BAG IN",-300,10920,0,8027.5,0,0,0,0,2592.5,-300,10920,0,8027.5,0,0,0,0,2592.5,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 40X250ML BOT IN",0,20,0,0,0,0,0,0,20,0,20,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["GAUCHO FS600 100X50ML BOT IN",0,15,0,15,0,0,0,0,0,0,15,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["GAUCHO FS600 50X100ML BOT IN",0,5,0,5,0,0,0,0,0,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X250GR BAG IN",0,25,0,0,0,0,0,0,25,0,25,0,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,"Ok"]
["LARVIN (T) WP75 20X500GR BAG IN",0,20,0,0,0,0,0,0,20,0,20,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 20X250ML BOT IN",5,5,0,5,0,0,0,0,5,5,5,0,5,0,0,0,0,5,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT (T) SC50 50X100ML BOT IN",1,10,0,1,0,0,0,0,10,1,10,0,1,0,0,0,0,10,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 10X1L BOT IN",2,200,0,2,0,0,0,0,200,2,200,0,2,0,0,0,0,200,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 20X500ML BOT IN",-17,150,0,0,0,0,0,0,133,-17,150,0,0,0,0,0,0,133,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 40X250ML BOT IN",30,20,0,30,0,0,0,0,20,30,20,0,30,0,0,0,0,20,0,0,0,0,0,0,0,0,0,"Ok"]
["WHIPSUPER (T) EC90 50X100ML BOT IN",0,25,0,0,0,0,0,0,25,0,25,0,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,"Ok"]
["DECIS EC 28 50X100ML BOT IN",0,10,0,0,0,0,0,0,10,0,10,0,0,0,0,0,0,10,0,0,0,0,0,0,0,0,0,"Ok"]
["ARIZE AZ 8433 DT (LOC) 6X5KG BAG IN",0,300,0,0,0,0,0,0,300,0,300,0,0,0,0,0,0,300,0,0,0,0,0,0,0,0,0,"Ok"]
["NATIVO WG75 100X50GR 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"]
["Total",530,12589,0,8114.5,0,0,0,0,5004.5,530,12589,0,8114.5,0,0,0,0,5004.5,0,0,0,0,0,0,0,0,0]