{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,5,0],[0,0,0,19]]}
["The Retail Management Formula"]
["Candidate Assessment Form"]
[]
["Candidate Name:"]
[null,null,null,"Interviewer:",null,null,null,"Interviewer:",null,null,null,"Interviewer:",null,null,null,"Interviewer:",null,null,null,"Average:"]
[]
[]
[null,"Weight",null,"Score",null,null,null,"Score",null,null,null,"Score",null,null,null,"Score",null,null,null,"Score"]
[null,{"$f":"B11+B16+B21+B27","v":1},null,{"$f":"D11+D16+D21+D27","v":0},null,null,null,{"$f":"H11+H16+H21+H27","v":0},null,null,null,{"$f":"L11+L16+L21+L27","v":0},null,null,null,{"$f":"P11+P16+P21+P27","v":0},null,null,null,{"$f":"W9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"W11+W16+W21+W27","v":{"$error":"#DIV/0!"}}]
[]
["Personal Characteristics",{"$f":"B12+B13+B14+B15","v":0.30000000000000004},null,{"$f":"F12+F13+F14+F15","v":0},null,null,null,{"$f":"J12+J13+J14+J15","v":0},null,null,null,{"$f":"N12+N13+N14+N15","v":0},null,null,null,{"$f":"R12+R13+R14+R15","v":0},null,null,null,{"$f":"W11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"W12+W13+W14+W15","v":{"$error":"#DIV/0!"}}]
["    Responsibility",0.1,null,null,{"$f":"IF(D12=$Y$15,4,IF(D12=$Y$14,3,IF(D12=$Y$13,2,IF(D12=$Y$12,1,\"\"))))","v":""},{"$f":"IF(E12=\"\",0,E12*$B12)","v":0},null,null,{"$f":"IF(H12=$Y$15,4,IF(H12=$Y$14,3,IF(H12=$Y$13,2,IF(H12=$Y$12,1,\"\"))))","v":""},{"$f":"IF(I12=\"\",0,I12*$B12)","v":0},null,null,{"$f":"IF(L12=$Y$15,4,IF(L12=$Y$14,3,IF(L12=$Y$13,2,IF(L12=$Y$12,1,\"\"))))","v":""},{"$f":"IF(M12=\"\",0,M12*$B12)","v":0},null,null,{"$f":"IF(P12=$Y$15,4,IF(P12=$Y$14,3,IF(P12=$Y$13,2,IF(P12=$Y$12,1,\"\"))))","v":""},{"$f":"IF(Q12=\"\",0,Q12*$B12)","v":0},null,{"$f":"V12","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(E12,I12,M12,Q12)","v":{"$error":"#DIV/0!"}},{"$f":"V12*$B12","v":{"$error":"#DIV/0!"}},null,"1-Weak"]
["    Empathy",0.08,null,null,{"$f":"IF(D13=$Y$15,4,IF(D13=$Y$14,3,IF(D13=$Y$13,2,IF(D13=$Y$12,1,\"\"))))","v":""},{"$f":"IF(E13=\"\",0,E13*$B13)","v":0},null,null,{"$f":"IF(H13=$Y$15,4,IF(H13=$Y$14,3,IF(H13=$Y$13,2,IF(H13=$Y$12,1,\"\"))))","v":""},{"$f":"IF(I13=\"\",0,I13*$B13)","v":0},null,null,{"$f":"IF(L13=$Y$15,4,IF(L13=$Y$14,3,IF(L13=$Y$13,2,IF(L13=$Y$12,1,\"\"))))","v":""},{"$f":"IF(M13=\"\",0,M13*$B13)","v":0},null,null,{"$f":"IF(P13=$Y$15,4,IF(P13=$Y$14,3,IF(P13=$Y$13,2,IF(P13=$Y$12,1,\"\"))))","v":""},{"$f":"IF(Q13=\"\",0,Q13*$B13)","v":0},null,{"$f":"V13","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(E13,I13,M13,Q13)","v":{"$error":"#DIV/0!"}},{"$f":"V13*$B13","v":{"$error":"#DIV/0!"}},null,"2-Average"]
["    Authenticity",0.09,null,null,{"$f":"IF(D14=$Y$15,4,IF(D14=$Y$14,3,IF(D14=$Y$13,2,IF(D14=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E14,I14,M14,Q14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"3-Strong"]
["    Fortitude",0.03,null,null,{"$f":"IF(D15=$Y$15,4,IF(D15=$Y$14,3,IF(D15=$Y$13,2,IF(D15=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E15,I15,M15,Q15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"4-Outstanding"]
["Skills",{"$f":"B17+B18+B19+B20","v":0.24000000000000002},null,{"$f":"F17+F18+F19+F20","v":0},null,null,null,{"$f":"J17+J18+J19+J20","v":0},null,null,null,{"$f":"N17+N18+N19+N20","v":0},null,null,null,{"$f":"R17+R18+R19+R20","v":0},null,null,null,{"$f":"W16","v":{"$error":"#DIV/0!"}},null,null,{"$f":"W17+W18+W19+W20","v":{"$error":"#DIV/0!"}}]
["    Communication",7.0000000000000007E-2,null,null,{"$f":"IF(D17=$Y$15,4,IF(D17=$Y$14,3,IF(D17=$Y$13,2,IF(D17=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E17,I17,M17,Q17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Organization",0.04,null,null,{"$f":"IF(D18=$Y$15,4,IF(D18=$Y$14,3,IF(D18=$Y$13,2,IF(D18=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E18,I18,M18,Q18)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Judgment",0.09,null,null,{"$f":"IF(D19=$Y$15,4,IF(D19=$Y$14,3,IF(D19=$Y$13,2,IF(D19=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E19,I19,M19,Q19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Coaching",0.04,null,null,{"$f":"IF(D20=$Y$15,4,IF(D20=$Y$14,3,IF(D20=$Y$13,2,IF(D20=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E20,I20,M20,Q20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Influencing Ability",{"$f":"B22+B23+B24+B25","v":0.16},null,{"$f":"F22+F23+F24+F25","v":0},null,null,null,{"$f":"J22+J23+J24+J25","v":0},null,null,null,{"$f":"N22+N23+N24+N25","v":0},null,null,null,{"$f":"R22+R23+R24+R25","v":0},null,null,null,{"$f":"W21","v":{"$error":"#DIV/0!"}},null,null,{"$f":"W22+W23+W24+W25","v":{"$error":"#DIV/0!"}}]
["    Wisdom",0.03,null,null,{"$f":"IF(D22=$Y$15,4,IF(D22=$Y$14,3,IF(D22=$Y$13,2,IF(D22=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E22,I22,M22,Q22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Focus",0.03,null,null,{"$f":"IF(D23=$Y$15,4,IF(D23=$Y$14,3,IF(D23=$Y$13,2,IF(D23=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E23,I23,M23,Q23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Action Orientation",0.08,null,null,{"$f":"IF(D24=$Y$15,4,IF(D24=$Y$14,3,IF(D24=$Y$13,2,IF(D24=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E24,I24,M24,Q24)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["    Vision",0.02,null,null,{"$f":"IF(D25=$Y$15,4,IF(D25=$Y$14,3,IF(D25=$Y$13,2,IF(D25=$Y$12,1,\"\"))))","v":""},0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$f":"AVERAGE(E25,I25,M25,Q25)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
["Job Specific Capabilities",{"$f":"B28+B29+B30+B31+B32+B33","v":0.30000000000000004},null,{"$f":"F28+F29+F30+F31+F32+F33","v":0},null,null,null,{"$f":"J28+J29+J30+J31+J32+J33","v":0},null,null,null,{"$f":"N28+N29+N30+N31+N32+N33","v":0},null,null,null,{"$f":"R28+R29+R30+R31+R32+R33","v":0},null,null,null,{"$f":"W27","v":{"$error":"#DIV/0!"}},null,null,{"$f":"W28+W29+W30+W31+W32+W33","v":{"$error":"#DIV/0!"}}]
["    Operational tasks",0.09,null,null,{"$f":"IF(D28=$Y$15,4,IF(D28=$Y$14,3,IF(D28=$Y$13,2,IF(D28=$Y$12,1,\"\"))))","v":""},{"$f":"IF(E28=\"\",0,E28*$B28)","v":0},null,null,{"$f":"IF(H28=$Y$15,4,IF(H28=$Y$14,3,IF(H28=$Y$13,2,IF(H28=$Y$12,1,\"\"))))","v":""},{"$f":"IF(I28=\"\",0,I28*$B28)","v":0},null,null,{"$f":"IF(L28=$Y$15,4,IF(L28=$Y$14,3,IF(L28=$Y$13,2,IF(L28=$Y$12,1,\"\"))))","v":""},{"$f":"IF(M28=\"\",0,M28*$B28)","v":0},null,null,{"$f":"IF(P28=$Y$15,4,IF(P28=$Y$14,3,IF(P28=$Y$13,2,IF(P28=$Y$12,1,\"\"))))","v":""},{"$f":"IF(Q28=\"\",0,Q28*$B28)","v":0},null,{"$f":"V28","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(E28,I28,M28,Q28)","v":{"$error":"#DIV/0!"}},{"$f":"V28*$B28","v":{"$error":"#DIV/0!"}}]
["    Provide great service",0.09,null,null,"",0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["    Needs-based selling",0.09,null,null,"",0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["    External business development",0.03,null,null,"",0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"",0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$f":"V32","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"",0,null,null,"",0,null,null,"",0,null,null,"",0,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"©2017 by Jon Dario"]