{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DASHBOARD","RAW DATA"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":4},"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":"DASHBOARD","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[true,null,null,true,null,null,true,null,null,true]
[]
["Sales Executive","Total Sales ",null,"Sales Executive","Total Sales ",null,"Sales Executive","Target Hit % wise",null,"Sales Executive","Away From Target % wise"]
["Anikuttan",382,null,"Jyoti Tulsani",228,null,"Anikuttan",0.76400000000000001,null,"Jyoti Tulsani",0.54400000000000004]
["Bhagwat Singh",327,null,"Mubeen Khan",209,null,"Bhagwat Singh",0.65400000000000003,null,"Mubeen Khan",0.58200000000000007]
["ManjuTiwari Lab",318,null,"Praveen Kumar",166,null,"ManjuTiwari Lab",0.63600000000000001,null,"Praveen Kumar",0.66799999999999993]
["Rashid",340,null,"Sanjiv Subherwal",223,null,"Rashid",0.68,null,"Sanjiv Subherwal",0.55400000000000005]
["Ritu Bhatnagar",371,null,"Sushma Khandelwal",213,null,"Ritu Bhatnagar",0.74199999999999999,null,"Sushma Khandelwal",0.57400000000000007]

{"sheet":"RAW DATA","index":1,"n_rows":142,"n_cols":12,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
["Emp Code","Sales Executive","Region","Day1","Day2","Day3","Day4","Day5","Total Sales","Target","Target Hit %","Away From Target %"]
["Mum-TCL001","Raj Verma","Mumbai",49,84,98,67,41,{"$f":"SUM(D2:H2)","v":339},500,{"$f":"I2/J2","v":0.67800000000000005},{"$f":"100%-K2","v":0.32199999999999995}]
["Mum-TCL002","Tanuja Kale","Delhi",44,85,47,15,48,{"$f":"SUM(D3:H3)","v":239},500,{"$f":"I3/J3","v":0.47799999999999998},{"$f":"100%-K3","v":0.52200000000000002}]
["Mum-TCL003","Arvind Sharma","Nagpur",45,79,88,73,94,379,500,0.75800000000000001,0.24199999999999999]
["Mum-TCL004","Tahira Qureshi","Chennai",52,99,13,95,29,288,500,0.57599999999999996,0.42400000000000004]
["Mum-TCL005","Anuj Sharma","Pune",35,54,49,26,49,213,500,0.42599999999999999,0.57400000000000007]
["Mum-TCL006","Syed Sohail","Patna",86,31,23,48,77,265,500,0.53,0.47]
["Mum-TCL007","Syed Saqib","Ranchi",84,28,98,80,79,369,500,0.73799999999999999,0.26200000000000001]
["Mum-TCL008","Syed Naved","Surat",73,97,38,24,53,285,500,0.56999999999999995,0.43000000000000005]
["Mum-TCL009","Swarnlata Borse","Mumbai",54,26,53,36,20,189,500,0.378,0.622]
["Mum-TCL010","Sushma Khandelwal","Delhi",52,52,19,53,37,213,500,0.42599999999999999,0.57400000000000007]
["Mum-TCL011","Surendranath Thakur","Nagpur",63,17,40,48,51,219,500,0.438,0.56200000000000006]
["Mum-TCL012","Surendra Kumar","Chennai",79,99,95,12,91,376,500,0.752,0.248]
["Mum-TCL013","Sunita Madnani","Pune",95,88,11,78,60,332,500,0.66400000000000003,0.33599999999999997]
["Mum-TCL014","Sunita Chawla","Patna",83,77,66,22,40,288,500,0.57599999999999996,0.42400000000000004]
["Mum-TCL015","Sunil Kumar","Ranchi",78,58,34,84,31,285,500,0.56999999999999995,0.43000000000000005]
["Mum-TCL016","Sudhir Kumar","Surat",14,25,45,70,45,199,500,0.39800000000000002,0.60199999999999998]
["Mum-TCL017","Sudama Kumar","Mumbai",37,69,96,66,38,306,500,0.61199999999999999,0.38800000000000001]
["Mum-TCL018","Sonaram Munda","Delhi",11,46,91,98,45,291,500,0.58199999999999996,0.41800000000000004]
["Mum-TCL019","Sneh Khan","Nagpur",19,34,64,65,70,252,500,0.504,0.496]
["Mum-TCL020","Shyamal Malakar","Chennai",93,84,13,45,18,253,500,0.50600000000000001,0.49399999999999999]
["Mum-TCL021","Shubhanjali Joshi","Pune",68,73,97,76,53,367,500,0.73399999999999999,0.26600000000000001]
["Mum-TCL022","Shivji Prasad","Patna",99,17,48,44,93,301,500,0.60199999999999998,0.39800000000000002]
["Mum-TCL023","Shephali Jain","Ranchi",57,28,31,34,52,202,500,0.40400000000000003,0.59599999999999997]
["Mum-TCL024","Sheena Joseph","Surat",40,22,18,11,92,183,500,0.36599999999999999,0.63400000000000001]
["Mum-TCL025","Sheeba Joseph","Mumbai",47,99,94,75,29,344,500,0.68799999999999994,0.31200000000000006]
["Mum-TCL026","Shashikant Tiwari","Delhi",16,71,80,76,33,276,500,0.55200000000000005,0.44799999999999995]
["Mum-TCL027","Shankar Attendant","Nagpur",72,87,92,72,34,357,500,0.71399999999999997,0.28600000000000003]
["Mum-TCL028","Shailendra Barge","Chennai",30,38,70,89,97,324,500,0.64800000000000002,0.35199999999999998]
["Mum-TCL029","Shailaja Kamal","Pune",65,90,91,85,10,341,500,0.68200000000000005,0.31799999999999995]
["Mum-TCL030","Saroj Parita","Patna",83,46,99,36,89,353,500,0.70599999999999996,0.29400000000000004]
["Mum-TCL031","Sapna Sharma","Ranchi",10,66,40,22,38,176,500,0.35199999999999998,0.64800000000000002]
["Mum-TCL032","Santosh Kumar","Surat",37,30,19,77,67,230,500,0.46,0.54]
["Mum-TCL033","Sanju Ramdas","Mumbai",83,46,17,94,92,332,500,0.66400000000000003,0.33599999999999997]
["Mum-TCL034","Sanjiv Subherwal","Delhi",84,59,41,17,22,223,500,0.44600000000000001,0.55400000000000005]
["Mum-TCL035","Sanjay Hire","Nagpur",82,54,79,61,47,323,500,0.64600000000000002,0.35399999999999998]
["Mum-TCL036","Salim","Chennai",47,23,19,64,61,214,500,0.42799999999999999,0.57200000000000006]
["Mum-TCL037","Sajid Naqvi","Pune",91,13,79,85,67,335,500,0.67,0.32999999999999996]
["Mum-TCL038","Roohi Haider","Patna",66,59,25,55,59,264,500,0.52800000000000002,0.47199999999999998]
["Mum-TCL039","Roma Rastogi","Ranchi",70,18,88,46,52,274,500,0.54800000000000004,0.45199999999999996]
["Mum-TCL040","Roli Bhatnagar","Surat",37,60,44,61,30,232,500,0.46400000000000002,0.53600000000000003]
["Mum-TCL041","Rohit Nishchal","Mumbai",16,46,33,54,58,207,500,0.41399999999999998,0.58600000000000008]
["Mum-TCL042","Ritu Bhatnagar","Delhi",47,97,74,97,56,371,500,0.74199999999999999,0.25800000000000001]
["Mum-TCL043","Renu Pratap","Nagpur",86,22,10,60,28,206,500,0.41199999999999998,0.58800000000000008]
["Mum-TCL044","Rekha Jain ","Chennai",74,17,45,64,13,213,500,0.42599999999999999,0.57400000000000007]
["Mum-TCL045","Rekha Gupta","Pune",80,51,15,97,42,285,500,0.56999999999999995,0.43000000000000005]
["Mum-TCL046","Rekha Agarwal","Patna",49,82,95,46,78,350,500,0.7,0.30000000000000004]
["Mum-TCL047","Ravinder Kaur","Ranchi",17,88,12,54,21,192,500,0.38400000000000001,0.61599999999999999]
["Mum-TCL048","Ravi Kumar","Surat",74,16,74,36,33,233,500,0.46600000000000003,0.53400000000000003]
["Mum-TCL049","Rashmi Gajbe","Mumbai",73,72,38,19,90,292,500,0.58399999999999996,0.41600000000000004]
["Mum-TCL050","Rashid","Delhi",17,84,90,77,72,340,500,0.68,0.31999999999999995]
["Mum-TCL051","Ramji Prasad","Nagpur",52,36,84,41,57,270,500,0.54,0.45999999999999996]
["Mum-TCL052","Rakhi Jodhani","Chennai",65,67,72,22,23,249,500,0.498,0.502]
["Mum-TCL053","Rajshree Dhabekar","Pune",88,39,25,99,71,322,500,0.64400000000000002,0.35599999999999998]
["Mum-TCL054","Raji Abraham","Patna",23,14,15,58,79,189,500,0.378,0.622]
["Mum-TCL055","Rajesh Sharma","Ranchi",15,67,48,95,35,260,500,0.52,0.48]
["Mum-TCL056","Rajesh Kumar","Surat",18,35,82,31,26,192,500,0.38400000000000001,0.61599999999999999]
["Mum-TCL057","Rajendra Prasad","Mumbai",57,60,42,81,44,284,500,0.56799999999999995,0.43200000000000005]
["Mum-TCL058","Rajendra Kumar","Delhi",34,97,66,45,50,292,500,0.58399999999999996,0.41600000000000004]
["Mum-TCL059","Rajendra Gupta","Nagpur",83,12,70,83,52,300,500,0.6,0.4]
["Mum-TCL060","Rajeev Kumar","Chennai",76,55,56,16,61,264,500,0.52800000000000002,0.47199999999999998]
["Mum-TCL061","Rajeev Garg","Pune",40,70,19,36,52,217,500,0.434,0.56600000000000006]
["Mum-TCL062","Raj Kumar","Patna",44,60,71,34,37,246,500,0.49199999999999999,0.50800000000000001]
["Mum-TCL063","Rachna Chauhan","Ranchi",43,78,15,98,33,267,500,0.53400000000000003,0.46599999999999997]
["Mum-TCL064","Rachita Anupam","Surat",75,75,89,97,49,385,500,0.77,0.22999999999999998]
["Mum-TCL065","Rachel Mathew","Mumbai",74,51,97,73,33,328,500,0.65600000000000003,0.34399999999999997]
["Mum-TCL066","Praveen Kumar","Delhi",44,36,11,45,30,{"$f":"SUM(D67:H67)","v":166},500,{"$f":"I67/J67","v":0.33200000000000002},{"$f":"100%-K67","v":0.66799999999999993}]
["Mum-TCL067","Prasannakumari S","Nagpur",87,79,46,65,65,342,500,0.68400000000000005,0.31599999999999995]
["Mum-TCL068","Pramod Tiwari","Chennai",70,52,80,43,48,293,500,0.58599999999999997,0.41400000000000003]
["Mum-TCL069","Prabha Desikan","Pune",45,26,27,14,59,171,500,0.34200000000000003,0.65799999999999992]
["Mum-TCL070","Partha Sarathi","Patna",51,26,58,83,11,229,500,0.45800000000000002,0.54200000000000004]
["Mum-TCL071","Pankaj Shelkey","Ranchi",68,36,15,20,17,156,500,0.312,0.68799999999999994]
["Mum-TCL072","Owais Mohd","Surat",32,74,18,33,51,208,500,0.41599999999999998,0.58400000000000007]
["Mum-TCL073","Omprakash O","Mumbai",41,11,46,35,10,143,500,0.28599999999999998,0.71399999999999997]
["Mum-TCL074","Om Prakash","Delhi",41,17,82,75,39,254,500,0.50800000000000001,0.49199999999999999]
["Mum-TCL075","Nitin Bhatia","Nagpur",12,97,45,29,41,224,500,0.44800000000000001,0.55200000000000005]
["Mum-TCL076","Nikita Panwalkar","Chennai",19,72,87,82,27,287,500,0.57399999999999995,0.42600000000000005]
["Mum-TCL077","Neeru Mehta","Pune",98,15,72,67,34,286,500,0.57199999999999995,0.42800000000000005]
["Mum-TCL078","Neeraj Saxena","Patna",50,44,46,13,92,245,500,0.49,0.51]
["Mum-TCL079","Narayan Singh","Ranchi",40,82,72,42,45,281,500,0.56200000000000006,0.43799999999999994]
["Mum-TCL080","Nandu Kumar","Surat",23,83,63,65,83,317,500,0.63400000000000001,0.36599999999999999]
["Mum-TCL081","Mukesh Nagar","Mumbai",71,94,45,95,46,351,500,0.70199999999999996,0.29800000000000004]
["Mum-TCL082","Mubeen Khan","Delhi",48,49,68,23,21,209,500,0.41799999999999998,0.58200000000000007]
["Mum-TCL083","Mohd Rafi","Nagpur",77,83,64,53,13,290,500,0.57999999999999996,0.42000000000000004]
["Mum-TCL084","Miny Mole","Chennai",81,63,88,89,63,384,500,0.76800000000000002,0.23199999999999998]
["Mum-TCL085","Mercy Thampi","Pune",39,87,62,80,81,349,500,0.69799999999999995,0.30200000000000005]
["Mum-TCL086","Mehnaz Khan","Patna",46,19,59,58,33,215,500,0.43,0.57000000000000006]
["Mum-TCL087","Meena Zinjare","Ranchi",34,15,43,63,54,209,500,0.41799999999999998,0.58200000000000007]
["Mum-TCL088","Masroor Adil","Surat",32,79,65,57,73,306,500,0.61199999999999999,0.38800000000000001]
["Mum-TCL089","Manoj Kumar","Mumbai",72,82,58,36,33,281,500,0.56200000000000006,0.43799999999999994]
["Mum-TCL090","ManjuTiwari Lab","Delhi",11,69,49,90,99,318,500,0.63600000000000001,0.36399999999999999]
["Mum-TCL091","Manjusha Sinha","Nagpur",80,73,21,72,54,300,500,0.6,0.4]
["Mum-TCL092","Manisha Shrivastava","Chennai",93,42,38,98,10,281,500,0.56200000000000006,0.43799999999999994]
["Mum-TCL093","Mangal Singh","Pune",18,80,20,32,95,245,500,0.49,0.51]
["Mum-TCL094","Lilly Lucy","Patna",96,14,20,31,44,205,500,0.41,0.59000000000000008]
["Mum-TCL095","Leena George","Ranchi",37,60,50,68,19,234,500,0.46800000000000003,0.53200000000000003]
["Mum-TCL096","Kunj Bihari","Surat",35,79,17,85,16,232,500,0.46400000000000002,0.53600000000000003]
["Mum-TCL097","Krishana Kumar","Mumbai",31,48,56,85,25,245,500,0.49,0.51]
["Mum-TCL098","Kisun Sah","Delhi",23,83,86,69,25,286,500,0.57199999999999995,0.42800000000000005]
["Mum-TCL099","Kiran Khubchandani","Nagpur",17,97,81,32,76,303,500,0.60599999999999998,0.39400000000000002]
["Mum-TCL100","Kavita Sharma","Chennai",92,45,43,91,47,318,500,0.63600000000000001,0.36399999999999999]
["Mum-TCL101","Kamini Tiwari","Pune",49,77,18,69,55,268,500,0.53600000000000003,0.46399999999999997]
["Mum-TCL102","Kamini Kumar","Patna",81,88,19,95,39,322,500,0.64400000000000002,0.35599999999999998]
["Mum-TCL103","Kalpana Agrawal","Ranchi",55,14,41,40,70,220,500,0.44,0.56000000000000005]
["Mum-TCL104","Kailash Nath","Surat",86,13,99,25,83,306,500,0.61199999999999999,0.38800000000000001]
["Mum-TCL105","Kahkasha Parveen","Mumbai",88,96,16,65,86,351,500,0.70199999999999996,0.29800000000000004]
["Mum-TCL106","Jyoti Tulsani","Delhi",61,73,34,30,30,228,500,0.45600000000000002,0.54400000000000004]
["Mum-TCL107","Julie S","Nagpur",61,91,53,78,91,374,500,0.748,0.252]
["Mum-TCL108","John D'Costa","Chennai",75,53,27,26,30,211,500,0.42199999999999999,0.57800000000000007]
["Mum-TCL109","Jitendra Kumar","Pune",24,31,41,57,83,236,500,0.47199999999999998,0.52800000000000002]
["Mum-TCL110","Janardan Mishra","Patna",83,62,32,83,95,355,500,0.71,0.29000000000000004]
["Mum-TCL111","Jairaj Vatham","Ranchi",39,52,72,99,58,320,500,0.64,0.36]
["Mum-TCL112","Jagdish Chandra","Surat",93,74,85,47,90,389,500,0.77800000000000002,0.22199999999999998]
["Mum-TCL113","Indra Singh","Mumbai",43,88,35,54,91,311,500,0.622,0.378]
["Mum-TCL114","Indra Pal","Delhi",87,15,11,42,88,243,500,0.48599999999999999,0.51400000000000001]
["Mum-TCL115","Heeramani Choudhary","Nagpur",45,45,61,11,52,214,500,0.42799999999999999,0.57200000000000006]
["Mum-TCL116","Hari Kumar","Chennai",71,42,17,57,96,283,500,0.56599999999999995,0.43400000000000005]
["Mum-TCL117","Dinesh Kumar","Pune",26,65,17,28,30,166,500,0.33200000000000002,0.66799999999999993]
["Mum-TCL118","Deepika Nigam","Patna",26,61,89,71,33,280,500,0.56000000000000005,0.43999999999999995]
["Mum-TCL119","Deepak Kumar","Ranchi",93,11,93,31,30,258,500,0.51600000000000001,0.48399999999999999]
["Mum-TCL120","Daleep Singh","Surat",65,92,48,96,15,316,500,0.63200000000000001,0.36799999999999999]
["Mum-TCL121","Bindu Nair","Mumbai",91,38,33,55,83,300,500,0.6,0.4]
["Mum-TCL122","Bhagwat Singh","Delhi",20,94,45,70,98,327,500,0.65400000000000003,0.34599999999999997]
["Mum-TCL123","Azam","Nagpur",25,83,26,68,22,224,500,0.44800000000000001,0.55200000000000005]
["Mum-TCL124","Atul Kumar","Chennai",26,16,61,92,50,245,500,0.49,0.51]
["Mum-TCL125","Ashok Mahto","Pune",31,55,75,66,75,302,500,0.60399999999999998,0.39600000000000002]
["Mum-TCL126","Ashok Kumar","Patna",41,66,48,70,48,273,500,0.54600000000000004,0.45399999999999996]
["Mum-TCL127","Ashish Kumar","Ranchi",60,92,32,60,78,322,500,0.64400000000000002,0.35599999999999998]
["Mum-TCL128","Arun Kumar","Surat",42,24,19,82,16,183,500,0.36599999999999999,0.63400000000000001]
["Mum-TCL129","Anubhuti Gupta","Mumbai",26,85,75,83,37,306,500,0.61199999999999999,0.38800000000000001]
["Mum-TCL130","Anoop Raj","Delhi",81,68,74,72,12,{"$f":"SUM(D131:H131)","v":307},500,{"$f":"I131/J131","v":0.61399999999999999},{"$f":"100%-K131","v":0.38600000000000001}]
["Mum-TCL131","Anoop Narayan","Nagpur",90,79,99,60,27,355,500,0.71,0.29000000000000004]
["Mum-TCL132","Annu Latika","Chennai",71,21,70,53,49,264,500,0.52800000000000002,0.47199999999999998]
["Mum-TCL133","Anjali Sahay","Pune",86,60,59,51,90,346,500,0.69199999999999995,0.30800000000000005]
["Mum-TCL134","Anjali Deoram","Patna",68,61,12,41,35,217,500,0.434,0.56600000000000006]
["Mum-TCL135","Anita Ghore","Ranchi",65,34,15,86,71,271,500,0.54200000000000004,0.45799999999999996]
["Mum-TCL136","Anita Dixit","Surat",91,21,59,85,60,316,500,0.63200000000000001,0.36799999999999999]
["Mum-TCL137","Anil Kumar","Mumbai",73,67,49,56,43,288,500,0.57599999999999996,0.42400000000000004]
["Mum-TCL138","Anikuttan","Delhi",72,49,93,95,73,382,500,0.76400000000000001,0.23599999999999999]
["Mum-TCL139","Anamika Gupta","Nagpur",85,43,74,26,88,316,500,0.63200000000000001,0.36799999999999999]
["Mum-TCL140","Afzal Husain","Chennai",77,81,10,65,83,316,500,0.63200000000000001,0.36799999999999999]
["Mum-TCL141","Abdul Hamid","Pune",46,52,57,67,64,286,500,0.57199999999999995,0.42800000000000005]