{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Client Prioritization","Client Ranking","Client Relationship Grades"],"not_rendered":{"images":1},"read":"whole","date_system":"1904"}

{"sheet":"Client Prioritization","index":0,"n_rows":16,"n_cols":3,"rows_kept":16}
["Order/Client         Prioritization Worksheet"]
[]
["Prospect/Client Name:"]
[]
["Criteria","Score"]
["How many other staffing/recruiting firms are working on the position?","Exclusive",{"$f":"IF(B6=\"Exclusive\",4,(IF(B6=\"1 other firm\",2,(IF(B6=\"2-3 other firms\",1,0)))))","v":4}]
["Does the client have reasonable expectations for the skills and experience they are looking for?","Yes",{"$f":"IF(B7=\"Yes\",4,(IF(B7=\"Mostly\",2,(IF(B7=\"Somewhat\",1,0)))))","v":4}]
["Is the skill set a core competency for us?","Primary Skill",{"$f":"IF(B8=\"Primary Skill\",4,(IF(B8=\"Regularly Fill\",3,(IF(B8=\"Sometimes Fill\",1,0)))))","v":4}]
["Is their compensation competitive or above market?","Market Leading",{"$f":"IF(B9=\"Market Leading\",4,(IF(B9=\"Above Market\",3,(IF(B9=\"At Market\",1,(IF(B9=\"Below Market\",0,-1)))))))","v":4}]
["How sellable is the company?","Excellent",{"$f":"IF(B10=\"Excellent\",4,(IF(B10=\"Good\",2,(IF(B10=\"Average\",1,(IF(B10=\"Below Average\",0,-1)))))))","v":4}]
["How sellable is the position?","Excellent",{"$f":"IF(B11=\"Excellent\",4,(IF(B11=\"Good\",2,(IF(B11=\"Average\",1,(IF(B11=\"Below Average\",0,-1)))))))","v":4}]
["Is the client responsive to candidate submissions and scheduling interviews?","Always",{"$f":"IF(B12=\"Always\",4,(IF(B12=\"Usually\",2,(IF(B12=\"Sometimes\",1,0)))))","v":4}]
["Does the client provide immediate feedback on submissions and interviews?","Always",{"$f":"IF(B13=\"Always\",4,(IF(B13=\"Usually\",2,(IF(B13=\"Sometimes\",1,0)))))","v":4}]
["What are our terms (pricing, conversion hours and fees, etc)? ","Excellent",{"$f":"IF(B14=\"Excellent\",4,(IF(B14=\"Good\",3,(IF(B14=\"Average\",1,(IF(B14=\"Below Average\",0,-1)))))))","v":4}]
["How much additional opportunity is there with this company? (Annual Revenue)","$1 million +",{"$f":"IF(B15=\"$1 million +\",4,(IF(B15=\"$500k - $1 mm\",3,(IF(B15=\"$250-$500k\",2,(IF(B15=\"$100-$250k\",1,0)))))))","v":4}]
["Order Priority Rating",{"$f":"IF(C16>25,\"A\",(IF(C16<15,\"C\",\"B\")))","v":"A"},{"$f":"SUM(C6:C15)","v":40}]

{"sheet":"Client Ranking","index":1,"n_rows":26,"n_cols":9,"rows_kept":26}
[]
[]
["Client Ranking and Action Scoresheet"]
[]
["Client","Client Prioritization Score (A,B,C)","GP%","GP$ per hour","Annual Revenue","Avg. Aging","Average Length of Assignment (hours)","Avg. GP$ per Assignment","Action Plan"]
[null,"A",{"v":0.21,"d":"21.00%"}]
[null,"B",{"v":0.16,"d":"16.00%"}]
[null,"C",{"v":0.12,"d":"12.00%"}]
{"$rows_empty":14}
["Criteria"]
["Green","A",">20%",">$5.00","> $500k","<= 30 days","> 60 days","Low"]
["Yellow","B","16-19.9%","$3.00 - 5.00","$100-500k","31-60","30 - 60 days","Medium"]
["Red","C","<16%","<$3.00","< $100k"," > 60 days","< 30 days","High"]

{"sheet":"Client Relationship Grades","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"merged":[[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,8,3],[9,0,11,0],[9,1,11,1],[9,2,11,2],[9,3,11,3],[12,0,14,0],[12,1,14,1],[12,2,14,2],[12,3,14,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[18,0,20,0],[18,1,20,1],[18,2,20,2],[18,3,20,3],[21,0,23,0],[21,1,23,1],[21,2,23,2],[21,3,23,3],[24,0,26,0],[24,1,26,1],[24,2,26,2],[24,3,26,3],[27,0,29,0],[27,1,29,1],[27,2,29,2],[27,3,29,3]]}
["Client Relationship Grades"]
[]
["Client","Our Annual Revenue","Est. Total client spend","Total Staffing Firms being utilized","Client Contact","Contact Title","Contact Level","Primary Assigned Contact","Current Relationship Grade","Target Relationship Level","Action Plan","Next Step","Next Step Date"]
["ABC Company",{"v":150000,"d":"$150,000"},{"v":750000,"d":"$750,000"},6,"John Jamison","Hiring Manager","Client Service","Sam Stephens","B","A"]
[{"$nulls":4},"Jill Johnson","HR Director","Management","Sally Sloane","C","B"]
[{"$nulls":4},"Jane Jones","Chief Operating Officer","Executive/Sales","Steve Sampson","D","A"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]
[{"$nulls":6},"Client Service"]
[{"$nulls":6},"Management"]
[{"$nulls":6},"Executive/Sales"]