{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Competitive Analysis Matrix","Opportunity Analysis Template","Risk vs. Benefit Decision Scale"],"not_rendered":{"images":79,"macros":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Competitive Analysis Matrix","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"merged":[[0,0,0,10],[2,0,2,3],[2,4,2,6],[2,7,2,8],[2,9,2,10],[3,0,3,3],[3,4,3,6],[3,7,3,8],[3,9,3,10],[4,0,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[5,0,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[9,0,9,10],[11,1,11,10],[12,2,12,10],[13,2,13,10],[14,3,14,10],[15,3,15,10],[16,3,16,10],[17,2,17,10],[18,2,18,10],[19,2,19,10],[20,2,20,10],[21,1,21,10]],"flags":["formulas_cached_only"]}
["Opportunity Analysis and Risk Versus Benefits Templates"]
[]
["Project Name",{"$nulls":3},"Project Reference Number",null,null,"Prepared By (print)",null,"Preparer's Initials"]
[]
["Customer",{"$nulls":3},"Contact",null,null,"Contact's Phone #",null,"Date Prepared"]
[]
[]
["Instructions:"]
[]
["This tool has two parts:  (1) the Opportunity Analysis Template and (2) the Risk Versus Benefit Decision \nScale."]
[]
["n ","Use the Opportunity Analysis Template to assign a quantitative value to the key risks and benefits you have identified for the opportunity."]
[null,"1.","For each potential benefit and risk identified, determine whether the probability of occurrence and the impact on the project is high, medium, or low."]
[null,"2.","Assign separate scores for the probability of occurrence and for the impact on the project as follows: "]
[{"$nulls":3},"n High = 10 points"]
[{"$nulls":3},"n Medium = 5 points"]
[{"$nulls":3},"n Low = 2 points"]
[null,"3.","Total the points for probability of occurrence and for impact on the project for the benefits."]
[null,"4.","Add the score for probability of occurrence to the score for impact on the project to determine the total score for benefits."]
[null,"5.","Total the points for probability of occurrence and for impact on the project for the risks."]
[null,"6.","Add the score for probability of occurrence to the score for impact on the project to determine the total score for risks. "]
["n ","Locate the risk and benefit scores on the Risk Versus Benefit Decision Scale. Use the decision scale to guide your decision."]

{"sheet":"Opportunity Analysis Template","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[0,0,0,6],[1,0,1,1],[1,2,1,9],[3,4,4,5],[3,7,4,8],[5,0,7,3],[8,0,10,3],[11,0,13,3],[14,0,16,3],[17,0,19,3],[20,0,22,3],[23,0,25,3],[26,0,26,3],[26,4,26,5],[26,7,26,8],[27,0,27,9],[28,0,29,3],[28,4,29,5],[28,7,29,8],[30,0,32,3],[33,0,35,3],[36,0,38,3],[39,0,41,3],[42,0,44,3],[45,0,47,3],[48,0,48,3],[48,4,48,5],[48,7,48,8],[49,0,49,9]],"flags":["formulas_cached_only"]}
["Part 1:  Opportunity Analysis Template"]
["Opportunity:"]
[]
[{"$nulls":4},"Probability of Occurrence",null,null,"Impact on Project"]
["BENEFITS of pursuing the opportunity",{"$nulls":5},"Score",null,null,"Score","Totals"]
["Meets organization’s strategic objectives",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Customer prefers our organization",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Expands organization’s experience base",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Improves organization’s market share",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Uses organization’s underutilized resources",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Customer will serve as a reference site",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Potential for additional business",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Scores for Probability and Impact"]
["TOTAL SCORE FOR BENEFITS",{"$nulls":9},0]
["RISKS—cost, schedule, or performance problems in these areas",{"$nulls":3},"Probability of Occurrence",null,null,"Impact on Project"]
[{"$nulls":6},"Score",null,null,"Score","Totals"]
["Customer relationship",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Customer readiness to undertake this project",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Changing requirements",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Customer financial issues",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Availability of resources",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Resource skill level or certification status",{"$nulls":4},"High",0,null,"High",0,null,false,false]
[{"$nulls":5},"Medium",0,null,"Medium",0,0,false,false]
[{"$nulls":5},"Low",0,null,"Low",0,null,false,false]
["Scores for Probability and Impact"]
["TOTAL SCORE FOR RISKS",{"$nulls":9},0]

{"sheet":"Risk vs. Benefit Decision Scale","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"merged":[[0,0,0,9]],"flags":["formulas_cached_only"]}
["Part 2:  Risk Versus Benefit Decision Scale"]
[]
[]
[null,null,0,{"$nulls":4},0]