{"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,"Guru Kirpa Seeds Company"]
[null,null,null,null,null,null,null,null,null,null,null,"Stock and Sales FOR THE PERIOD 01-Apr-2021 TO 30-Jun-2021"]

{"sheet":"Dealer Report","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["M/s Guru Kirpa Seeds Co."]
["Opp. Goshala, Kaithal Road, Cheeka (Kaithal) 136034"]
["Contact : Avtar Singh - 9466621272, Balkar Singh- 9416782611"]
["Bayer"]
["Stock Category Summary"]
["1-Apr-21 to 30-Jun-21"]
["","Bayer"]
["","M/s Guru Kirpa Seeds Co."]
["Particulars","1-Apr-21 to 30-Jun-21"]
["","Opening Balance","Inwards","Outwards","Closing Balance"]
["","Quantity","Quantity","Quantity","Quantity"]
["Antracol 1kg",10,30,10,30]
["Antracol 500g",0,20,9.5,10.5]
["Council Activ 90g",0,120,55,65]
["Fame 50 Ml",0,40,0,40]
["Jump 2 Gm",0,1600,917,683]
["Laudis 115 Ml",0,32,28,4]
["Regent GR0 5kg",0,1000,1000,0]
["Regent Ultra 4kg",0,2600,400,2200]
["Grand Total",{"$f":"SUM(B12:B19)","v":10},5442,2419.5,3032.5]

{"sheet":"Dealer Report working","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Particulars","Opening Qty","Purchase Qty","Sales Qty","CLSG","Master Name",null,null,null,null,"Values"]
["Antracol 1kg",10,30,10,30,"ANTRACOL (T) WP70 10X1KG BAG IN",null,null,null,"Row Labels","Sum of Opening Qty","Sum of Purchase Qty","Sum of Sales Qty","Sum of CLSG"]
["Antracol 500g",0,20,9.5,10.5,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,"ANTRACOL (T) WP70 10X1KG BAG IN",10,30,10,30]
["Council Activ 90g",0,120,55,65,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,"ANTRACOL (T) WP70 20X500GR BAG IN",0,20,9.5,10.5]
["Fame 50 Ml",0,40,0,40,"FAME (T) SC480 40X50ML BOT IN",null,null,null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,120,55,65]
["Jump 2 Gm",0,1600,917,683,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,"FAME (T) SC480 40X50ML BOT IN",0,40,0,40]
["Laudis 115 Ml",0,32,28,4,"LAUDIS SC630 8X115ML BOT IN",null,null,null,"JUMP WG80 160X(10X2GR) BAG IN",0,1600,917,683]
["Regent GR0 5kg",0,1000,1000,0,"REGENT GR0 3 4X5KG BAG IN",null,null,null,"LAUDIS SC630 8X115ML BOT IN",0,32,28,4]
["Regent Ultra 4kg",0,2600,400,2200,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,"REGENT GR0 3 4X5KG BAG IN",0,1000,1000,0]
[null,null,null,null,null,null,null,null,null,"REGENT ULTRA GR0 6 5X4KG BAG IN",0,2600,400,2200]
[null,null,null,null,null,null,null,null,null,"Grand Total",10,5442,2419.5,3032.5]

{"sheet":"Master","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Item Details","Master Name"]
["Antracol 1kg","ANTRACOL (T) WP70 10X1KG BAG IN"]
["Antracol 500g","ANTRACOL (T) WP70 20X500GR BAG IN"]
["Council Activ 90g","COUNCIL ACTIV WG30 12X(5X90GR) BOX IN"]
["Fame 50 Ml","FAME (T) SC480 40X50ML BOT IN"]
["Jump 2 Gm","JUMP WG80 160X(10X2GR) BAG IN"]
["Laudis 115 Ml","LAUDIS SC630 8X115ML BOT IN"]
["Regent GR0 5kg","REGENT GR0 3 4X5KG BAG IN"]
["Regent Ultra 4kg","REGENT ULTRA GR0 6 5X4KG BAG IN"]

{"sheet":"Final Dealer Work","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"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,10,30,0,10,0,0,0,0,30]
[null,"ANTRACOL (T) WP70 20X500GR BAG IN",null,null,null,0,20,0,9.5,0,0,0,0,10.5]
[null,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",null,null,null,0,120,0,55,0,0,0,0,65]
[null,"FAME (T) SC480 40X50ML BOT IN",null,null,null,0,40,0,0,0,0,0,0,40]
[null,"JUMP WG80 160X(10X2GR) BAG IN",null,null,null,0,1600,0,917,0,0,0,0,683]
[null,"LAUDIS SC630 8X115ML BOT IN",null,null,null,0,32,0,28,0,0,0,0,4]
[null,"REGENT GR0 3 4X5KG BAG IN",null,null,null,0,1000,0,1000,0,0,0,0,0]
[null,"REGENT ULTRA GR0 6 5X4KG BAG IN",null,null,null,0,2600,0,400,0,0,0,0,2200]
[null,"Grand Total",null,null,null,10,5442,0,2419.5,0,0,0,0,3032.5]

{"sheet":"Zylem SNS Report","index":5,"n_rows":17,"n_cols":13,"rows_kept":17,"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 30-Jun-2021"]
["Generated on 7/29/2021 5:09:48 AM"]
["DISTRIBUTOR PRODUCTWISE"]
["OUTPUT IN : PIC,DETAILS AS : Column,CONSIDER : Voucher Date,INCLUDE VALIDATION : False"]
["DISTRIBUTOR:Guru Kirpa Seeds Company,"]
["DISTRIBUTOR","SAPCODE","PRODUCT","ITEMALIAS","Opening Qty","Purchase Qty","Purchase Return Qty","Sales Qty","Sales Return Qty","Transfer Qty","Consignment Qty","Adjustment Qty","CLSG"]
["Guru Kirpa Seeds Company",4532729,"ANTRACOL (T) WP70 10X1KG BAG IN",6077322,10,30,0,10,0,0,0,0,30]
["Guru Kirpa Seeds Company",4532729,"ANTRACOL (T) WP70 20X500GR BAG IN",5999978,0,20,0,9.5,0,0,0,0,10.5]
["Guru Kirpa Seeds Company",4532729,"COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",80882629,0,120,0,55,0,0,0,0,65]
["Guru Kirpa Seeds Company",4532729,"FAME (T) SC480 40X50ML BOT IN",79224699,0,40,0,0,0,0,0,0,40]
["Guru Kirpa Seeds Company",4532729,"JUMP WG80 160X(10X2GR) BAG IN",79215304,0,1600,0,917,0,0,0,0,683]
["Guru Kirpa Seeds Company",4532729,"LAUDIS SC630 8X115ML BOT IN",80491085,0,32,0,28,0,0,0,0,4]
["Guru Kirpa Seeds Company",4532729,"REGENT GR0 3 4X5KG BAG IN",80018703,0,1000,0,1000,0,0,0,0,0]
["Guru Kirpa Seeds Company",4532729,"REGENT ULTRA GR0 6 5X4KG BAG IN",84093394,0,2600,0,400,0,0,0,0,2200]
["GRANDTOTAL",null,null,null,10,5442,0,2419.5,0,0,0,0,3032.5]

{"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":12,"n_cols":29,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18],[0,19,0,27]]}
[null,"Zylem Report -01-Apr-2021 TO 30-Jun-2021",null,null,null,null,null,null,null,null,"Dealer Report -01-Apr-2021 TO 30-Jun-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",10,30,0,10,0,0,0,0,30,10,30,0,10,0,0,0,0,30,0,0,0,0,0,0,0,0,0,"Ok"]
["ANTRACOL (T) WP70 20X500GR BAG IN",0,20,0,9.5,0,0,0,0,10.5,0,20,0,9.5,0,0,0,0,10.5,0,0,0,0,0,0,0,0,0,"Ok"]
["COUNCIL ACTIV WG30 12X(5X90GR) BOX IN",0,120,0,55,0,0,0,0,65,0,120,0,55,0,0,0,0,65,0,0,0,0,0,0,0,0,0,"Ok"]
["FAME (T) SC480 40X50ML BOT IN",0,40,0,0,0,0,0,0,40,0,40,0,0,0,0,0,0,40,0,0,0,0,0,0,0,0,0,"Ok"]
["JUMP WG80 160X(10X2GR) BAG IN",0,1600,0,917,0,0,0,0,683,0,1600,0,917,0,0,0,0,683,0,0,0,0,0,0,0,0,0,"Ok"]
["LAUDIS SC630 8X115ML BOT IN",0,32,0,28,0,0,0,0,4,0,32,0,28,0,0,0,0,4,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT GR0 3 4X5KG BAG IN",0,1000,0,1000,0,0,0,0,0,0,1000,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Ok"]
["REGENT ULTRA GR0 6 5X4KG BAG IN",0,2600,0,400,0,0,0,0,2200,0,2600,0,400,0,0,0,0,2200,0,0,0,0,0,0,0,0,0,"Ok"]
["Total",10,5442,0,2419.5,0,0,0,0,3032.5,10,5442,0,2419.5,0,0,0,0,3032.5,0,0,0,0,0,0,0,0,0]