{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["summary","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"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":"summary","index":0,"n_rows":17,"n_cols":34,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,5,1,8],[2,6,3,6],[1,0,3,0],[1,1,3,1],[1,19,3,19],[2,18,3,18],[0,0,0,19],[1,17,1,18],[2,17,3,17],[1,4,3,4],[2,13,2,16],[2,9,2,12],[1,2,3,2],[1,3,3,3],[2,5,3,5],[1,9,1,16],[2,7,3,7],[2,8,3,8]]}
["Individual Scorecard ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trainee Analyst","Junior Analyst","Analyst","Senior Analyst","AM"]
["Region","Location","Week #","Name","designation","Productive Hrs",null,null,null,"Accuracy",null,null,null,null,null,null,null,"TAT",null,"Score ",null,null,null,null,"Emp ID","Date of Joining"]
[null,null,null,null,null,"Target Hrs","Actual Hrs.","Score 1","Score 2","Internal Errors",null,null,null,"External Errors",null,null,null,"Miss","Score"]
[null,null,null,null,null,null,null,null,null,"H","M","L","Score","H","M","L","Score"]
["UK","b",30,"sonia","AM",64,48.5,{"$f":"G5/F5","v":0.7578125},{"$f":"(3/MAX($H$5:$H$10)*H5)","v":{"$error":"#DIV/0!"}},0,2,0,{"$f":"IF((1-(J5*1+K5*0.7+L5*0.3))<0,0,IF(G5=0,\"NA\",1-(J5*1+K5*0.7+L5*0.3)))","v":0},0,0,2,{"$f":"IF(G5=0,\"NA\",4-(N5*1.5+O5*1.05+P5*0.45))","v":3.1},"HIT",{"$f":"IF(G5=0,\"NA\", IF($R5=\"Hit\",1,0))","v":1},{"$f":"IF(G5=0,\"NA\", IF(SUM(I5+M5+Q5+S5)<0, 0, SUM(I5+M5+Q5+S5)))","v":{"$error":"#DIV/0!"}},null,null,null,null,202845,"2013-09-10","Associate",{"$f":"TODAY()-Z5","v":350},{"$f":"IF(AND(AA5=\"Associate\",AB5<181),\"Learning Curve\",AA5)","v":"Associate"}]
["UK","b",30,"rahul","DM",64,51.70000000000001,{"$f":"G6/F6","v":0.80781250000000016},{"$f":"(3/MAX($H$5:$H$10)*H6)","v":{"$error":"#DIV/0!"}},6,0,0,{"$f":"IF((1-(J6*1+K6*0.7+L6*0.3))<0,0,IF(G6=0,\"NA\",1-(J6*1+K6*0.7+L6*0.3)))","v":0},0,5,0,{"$f":"IF(G6=0,\"NA\",4-(N6*1.5+O6*1.05+P6*0.45))","v":-1.25},"HIT",{"$f":"IF(G6=0,\"NA\", IF($R6=\"Hit\",1,0))","v":1},{"$f":"IF(G6=0,\"NA\", IF(SUM(I6+M6+Q6+S6)<0, 0, SUM(I6+M6+Q6+S6)))","v":{"$error":"#DIV/0!"}},null,null,null,null,53972,"2005-01-03","DM",{"$f":"TODAY()-Z6","v":3522},{"$f":"IF(AND(AA6=\"Associate\",AB6<181),\"Learning Curve\",AA6)","v":"DM"}]
["UK","b",30,"rohit","GM",64,47.25,{"$f":"G7/F7","v":0.73828125},{"$f":"(3/MAX($H$5:$H$10)*H7)","v":{"$error":"#DIV/0!"}},2,2,8,{"$f":"IF((1-(J7*1+K7*0.7+L7*0.3))<0,0,IF(G7=0,\"NA\",1-(J7*1+K7*0.7+L7*0.3)))","v":0},9,0,0,{"$f":"IF(G7=0,\"NA\",4-(N7*1.5+O7*1.05+P7*0.45))","v":-9.5},"HIT",{"$f":"IF(G7=0,\"NA\", IF($R7=\"Hit\",1,0))","v":1},{"$f":"IF(G7=0,\"NA\", IF(SUM(I7+M7+Q7+S7)<0, 0, SUM(I7+M7+Q7+S7)))","v":{"$error":"#DIV/0!"}},null,null,null,null,53972,"2005-01-03","DM",{"$f":"TODAY()-Z7","v":3522},{"$f":"IF(AND(AA7=\"Associate\",AB7<181),\"Learning Curve\",AA7)","v":"DM"}]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]
[null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"NA",null,null,null,"NA",null,"NA","NA",null,null,null,null,53972,"2005-01-03","DM",3522,"DM"]

{"sheet":"Sheet1","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["eName ",null," Range(\"D\" & c.Row)"]
["eDesg ",null," Range(\"E\" & c.Row)"]
["eTgtHrs ",null," Range(\"F\" & c.Row)"]
["eActHrs ",null," Range(\"G\" & c.Row)"]
["ieH ",null," Range(\"J\" & c.Row)","sonia"]
["ieM ",null," Range(\"K\" & c.Row)"]
["ieL ",null," Range(\"L\" & c.Row)"]
["eeH ",null," Range(\"N\" & c.Row)"]
["eeM ",null," Range(\"O\" & c.Row)"]
["eeL ",null," Range(\"P\" & c.Row)"]
["tgt ",null," Range(\"R\" & c.Row)"]