{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Strenghts","Weaknesses","Opportunities","Threats","Basesline","Recommendations"],"not_rendered":{"charts":5},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Strenghts","index":1,"n_rows":46,"n_cols":9,"rows_kept":46}
{"$rows_empty":29}
["QID","Question","Response","Disagree","Neither","Agree","Strength Rating","Category","SCALE"]
["SQ-001-01","We have a high level of competence ","Agree",{"$f":"IF(C31=$I$31, 1, 0)","v":0},{"$f":"IF(C31=$I$32, 1, 0)","v":0},{"$f":"IF(C31=$I$33, 1, 0)","v":1},{"$f":"(D31*1)+(E31*2)+(F31*3)","v":3},"Competence","Disagree"]
["SQ-001-02","We have competitive skill","Agree",0,0,1,{"$f":"(D32*1)+(E32*2)+(F32*3)","v":3},"Competitive Skill","Neither Agree or Disagree"]
["SQ-001-03","We are ahead on the experience curve","Agree",0,0,1,3,"Experience Curve","Agree"]
["SQ-001-04","We have adequate finance resources","Disagree",1,0,0,1,"Financial Resources"]
["SQ-001-05","We have a good reputation with buyers","Neither Agree or Disagree",0,1,0,2,"Reputation"]
["SQ-001-06","We are an acknowledged market leader","Neither Agree or Disagree",0,1,0,2,"Market Leadership"]
["SQ-001-07","We have well-conceived functional areas","Neither Agree or Disagree",0,1,0,2,"Organizational Design"]
["SQ-001-08","We have access to economies of scale","Disagree",1,0,0,1,"Economies of Scale"]
["SQ-001-09","We are somewhat insolated from strong competitive pressures","Disagree",1,0,0,1,"Competititve Pressure"]
["SQ-001-10","We have proprietary technology","Neither Agree or Disagree",0,1,0,2,"Proprietary Technology"]
["SQ-001-11","We have better advertising campaigns than the competition","Neither Agree or Disagree",0,1,0,2,"Marketing Effectiveness"]
["SQ-001-12","We are good at creating new products","Agree",0,0,1,3,"Product Development"]
["SQ-001-13","We have strong management","Neither Agree or Disagree",0,1,0,2,"Management"]
["SQ-001-14","We have superior /technological/technical skills","Agree",0,0,1,3,"Technical Skills"]
["SQ-001-15","We have a cost/price advantage","Neither Agree or Disagree",0,1,0,2,"Cost/Price"]
[null,"Total",null,{"$f":"SUM(D31:D45)","v":3},{"$f":"SUM(E31:E45)","v":7},{"$f":"SUM(F31:F45)","v":5},{"$f":"(D46*1)+(E46*2)+(F46*3)","v":32}]

{"sheet":"Weaknesses","index":2,"n_rows":44,"n_cols":9,"rows_kept":44}
{"$rows_empty":29}
["QID","Question","Response","Disagree","Neither","Agree","Weakness Rating","Category","SCALE"]
["SQ-001-31","We have no clear strategic direction","Agree",{"$f":"IF(C31=$I$31, 1, 0)","v":0},{"$f":"IF(C31=$I$32, 1, 0)","v":0},{"$f":"IF(C31=$I$33, 1, 0)","v":1},{"$f":"(D31*1)+(E31*2)+(F31*3)","v":3},"Strategy","Disagree"]
["SQ-001-32","Our facilities are obsolete","Neither Agree or Disagree",0,1,0,2,"Facilities","Neither Agree or Disagree"]
["SQ-001-33","We are lacking managerial depth and talent","Neither Agree or Disagree",0,1,0,2,"Management","Agree"]
["SQ-001-34","We are missing key skills or competencies","Agree",0,0,1,3,"Key Competencies"]
["SQ-001-35","We have a poor track record in implementing strategy","Neither Agree or Disagree",0,1,0,2,"Strategy Implementation"]
["SQ-001-36","We are plagued with internal operating problems","Disagree",1,0,0,1,"Internal Operations"]
["SQ-001-37","We are falling behind on Research & Development","Disagree",1,0,0,1,"R&D"]
["SQ-001-38","We have a narrow product line","Agree",0,0,1,3,"Product/Service Line"]
["SQ-001-39","We have a weak market image","Agree",0,0,1,3,"Market Image"]
["SQ-001-40","We have below average marketing skills","Disagree",1,0,0,1,"Marketing Skills"]
["SQ-001-41","We are unable to finance needed strategy changes","Agree",0,0,1,3,"Financial Resources"]
["SQ-001-42","We have higher overall costs relative to our key competitors","Neither Agree or Disagree",0,1,0,2,"Cost Structure"]
["SQ-001-43","We have subpar profitability","Neither Agree or Disagree",0,1,0,2,"Profitability"]
[null,"Total",null,{"$f":"SUM(D31:D43)","v":3},{"$f":"SUM(E31:E43)","v":5},{"$f":"SUM(F31:F43)","v":5},{"$f":"(D44*1)+(E44*2)+(F44*3)","v":28}]

{"sheet":"Opportunities","index":3,"n_rows":40,"n_cols":9,"rows_kept":40}
{"$rows_empty":29}
["QID","Question","Response","Disagree","Neither","Agree","Opportunity Rating","Category","SCALE"]
["SQ-001-34","There are additional customer groups that we could serve","Yes",{"$f":"IF(C31=$I$31, 1, 0)","v":0},{"$f":"IF(C31=$I$32, 1, 0)","v":0},{"$f":"IF(C31=$I$33, 1, 0)","v":1},{"$f":"(D31*1)+(E31*2)+(F31*3)","v":3},"Prospects","No"]
["SQ-001-35","There are new markets or market segments to enter","Yes",0,0,1,3,"Markets","Maybe"]
["SQ-001-36","We can expand our products/service line to meet customer needs","Yes",0,0,1,3,"Product/Service Enhancement","Yes"]
["SQ-001-37","We can diversify into related products","Maybe",0,1,0,2,"Product Line Expansion"]
["SQ-001-38","We can control sourcing or supply activities (vertical integration)","Yes",0,0,1,3,"Vertical Integration"]
["SQ-001-39","Falling trade barriers are opening foreign markets to us","Maybe",0,1,0,2,"Foreign Trade"]
["SQ-001-40","Our rivals are becoming complacent","Maybe",0,1,0,2,"Rival Complacency"]
["SQ-001-41","The market is growing faster than in the past","Yes",0,0,1,3,"Market Growth"]
["SQ-001-42","Fewer regulatory requirements will make doing business easier for us","Maybe",0,1,0,2,"Regulatory Overhead"]
[null,"Total",null,{"$f":"SUM(D31:D39)","v":0},{"$f":"SUM(E31:E39)","v":4},{"$f":"SUM(F31:F39)","v":5},{"$f":"(D40*1)+(E40*2)+(F40*3)","v":23}]

{"sheet":"Threats","index":4,"n_rows":42,"n_cols":9,"rows_kept":42}
{"$rows_empty":29}
["QID","Question","Response","Disagree","Neither","Agree","Threat Rating","Category","SCALE"]
["SQ-001-43","Low-cost foreign competitors are entering the market","No",{"$f":"IF(C31=$I$31, 1, 0)","v":1},{"$f":"IF(C31=$I$32, 1, 0)","v":0},{"$f":"IF(C31=$I$33, 1, 0)","v":0},{"$f":"(D31*1)+(E31*2)+(F31*3)","v":1},"Foreign Competition","No"]
["SQ-001-44","Sales of substitute product/services are rising","Maybe",0,1,0,2,"Substitute Products","Maybe"]
["SQ-001-45","The market is growing more slowly than we expected","Maybe",0,1,0,2,"Market Growth","Yes"]
["SQ-001-46","There are adverse shifts in foreign exchange rates and/or trade policies","No",1,0,0,1,"Foreign Trade Environment"]
["SQ-001-47","Regulatory requirements are becoming onerous","No",1,0,0,1,"Regulatory Overhead "]
["SQ-001-48","We are vulnerable to changes in the business cycle or to recessions","Yes",0,0,1,3,"Business Cycle/Climate"]
["SQ-001-49","Our customers and/or suppliers are enjoying growing bargaining power","Yes",0,0,1,3,"Buyer/Supplier Power"]
["SQ-001-50","Buyer's needs and tastes are changing in directions that point away from our current expertise","Maybe",0,1,0,2,"Market Requirements"]
["SQ-001-51","Demographic changes are having a negative impact on business","Maybe",0,1,0,2,"Demographics"]
["SQ-001-52","It's easy to enter this industry (very low barriers to entry)","Yes",0,0,1,3,"Entry Barriers"]
["SQ-001-53","Technology could change this industry with little or no warning","Yes",0,0,1,3,"Technology"]
[null,"Total",null,{"$f":"SUM(D31:D41)","v":3},{"$f":"SUM(E31:E41)","v":4},{"$f":"SUM(F31:F41)","v":4},{"$f":"(D42*1)+(E42*2)+(F42*3)","v":23}]

{"sheet":"Basesline","index":5,"n_rows":36,"n_cols":7,"rows_kept":36}
{"$rows_empty":19}
[{"$nulls":5},{"$f":"A29","v":"Total Strengths"},{"$f":"B29","v":32}]
[{"$nulls":5},{"$f":"A31","v":"Total Opportunities"},{"$f":"B31","v":23}]
[{"$nulls":5},{"$f":"F29","v":"Total Weaknesses "},{"$f":"G29","v":28}]
[{"$nulls":5},{"$f":"F31","v":"Total Threats "},{"$f":"G31","v":23}]
[]
[]
[]
[]
[]
["Total Strengths",{"$f":"Strenghts!G46","v":32},{"$nulls":3},"Total Weaknesses ",{"$f":"Weaknesses!G44","v":28}]
[]
["Total Opportunities",{"$f":"Opportunities!G40","v":23},{"$nulls":3},"Total Threats ",{"$f":"Threats!G42","v":23}]
[]
["Total Strenght and Opportunity",{"$f":"B29+B31","v":55},{"$nulls":3},"Total  Weaknesses and Threats",{"$f":"G29+G31","v":51}]
[]
[]
["Strategic Baseline ",{"$f":"B33-G33","v":4}]

{"sheet":"Recommendations","index":6,"n_rows":49,"n_cols":7,"rows_kept":49}
["Recommendations",{"$nulls":5},"Compensation Strategies"]
[{"$f":"IF(Strenghts!$G31<=2,$G2, \"\")","v":""},{"$nulls":5},"Identify critical and core competencies needed for business and develop"]
[{"$f":"IF(Strenghts!$G32<=2,$G3, \"\")","v":""},{"$nulls":5},"Reduce cycle time and increase learning to accelerate experience curve or acquire experience staff in key areas"]
[{"$f":"IF(Strenghts!$G33<=2,$G4, \"\")","v":""},{"$nulls":5},"Develop financial strategies to acquire needed funding for operating capital and/or expansion"]
[{"$f":"IF(Strenghts!$G34<=2,$G5, \"\")","v":"Identify key factors effecting business reputation and develop a mitigation plan to address as well as exploit advantages"},{"$nulls":5},"Identify key factors effecting business reputation and develop a mitigation plan to address as well as exploit advantages"]
[{"$f":"IF(Strenghts!$G35<=2,$G6, \"\")","v":"Develop strategic & tactical plans to focus on becoming a market leader in one area and execute  "},{"$nulls":5},"Develop strategic & tactical plans to focus on becoming a market leader in one area and execute  "]
[{"$f":"IF(Strenghts!$G36<=2,$G7, \"\")","v":"Analyze organizational/functional design for efficiency and effectiveness"},{"$nulls":5},"Analyze organizational/functional design for efficiency and effectiveness"]
[{"$f":"IF(Strenghts!$G37<=2,$G8, \"\")","v":"Develop strategies to create economies of scale for key product/service offerings"},{"$nulls":5},"Develop strategies to create economies of scale for key product/service offerings"]
[{"$f":"IF(Strenghts!$G38<=2,$G9, \"\")","v":"Develop strategies to differentiate product/service, sales or distribution to create protected markets "},{"$nulls":5},"Develop strategies to differentiate product/service, sales or distribution to create protected markets "]
[{"$f":"IF(Strenghts!$G39<=2,$G10, \"\")","v":"Determine if patent, copyright and trade secret intellectual property is, can and should developed  "},{"$nulls":5},"Determine if patent, copyright and trade secret intellectual property is, can and should developed  "]
[{"$f":"IF(Strenghts!$G40<=2,$G11, \"\")","v":"Perform a Marketing Audit and Benchmark leading competitor to determine efficiency and effectiveness "},{"$nulls":5},"Perform a Marketing Audit and Benchmark leading competitor to determine efficiency and effectiveness "]
[{"$f":"IF(Strenghts!$G41<=2,$G12, \"\")","v":"Develop and manage a formal ideation and innovation process"},{"$nulls":5},"Develop and manage a formal ideation and innovation process"]
[{"$f":"IF(Strenghts!$G42<=2,$G13, \"\")","v":""},{"$nulls":5},"Develop or acquire management skills"]
[{"$f":"IF(Strenghts!$G43<=2,$G14, \"\")","v":"Develop or acquire technical skills"},{"$nulls":5},"Develop or acquire technical skills"]
[{"$f":"IF(Strenghts!$G44<=2,$G15, \"\")","v":""},{"$nulls":5},"Develop strategies to improve economies of scale, profit margins and efficiencies"]
[{"$f":"IF(Strenghts!$G45<=2,$G16, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G31<=2,$G17, \"\")","v":""}]
[{"$f":"IF(Weaknesses!$G32<=2,$G18, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G33<=2,$G19, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G34<=2,$G20, \"\")","v":""}]
[{"$f":"IF(Weaknesses!$G35<=2,$G21, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G36<=2,$G22, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G37<=2,$G23, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G38<=2,$G24, \"\")","v":""}]
[{"$f":"IF(Weaknesses!$G39<=2,$G25, \"\")","v":""}]
[{"$f":"IF(Weaknesses!$G40<=2,$G26, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G41<=2,$G27, \"\")","v":""}]
[{"$f":"IF(Weaknesses!$G42<=2,$G28, \"\")","v":0}]
[{"$f":"IF(Weaknesses!$G43<=2,$G29, \"\")","v":0}]
[{"$f":"IF(Opportunities!$G31<=2,$G30, \"\")","v":""}]
[{"$f":"IF(Opportunities!$G32<=2,$G31, \"\")","v":""}]
[{"$f":"IF(Opportunities!$G33<=2,$G32, \"\")","v":""}]
[{"$f":"IF(Opportunities!$G34<=2,$G33, \"\")","v":0}]
[{"$f":"IF(Opportunities!$G35<=2,$G34, \"\")","v":""}]
[{"$f":"IF(Opportunities!$G36<=2,$G35, \"\")","v":0}]
[{"$f":"IF(Opportunities!$G37<=2,$G36, \"\")","v":0}]
[{"$f":"IF(Opportunities!$G38<=2,$G37, \"\")","v":""}]
[{"$f":"IF(Opportunities!$G39<=2,$G38, \"\")","v":0}]
[{"$f":"IF(Threats!$G31<=2,$G39, \"\")","v":0}]
[{"$f":"IF(Threats!$G32<=2,$G40, \"\")","v":0}]
[{"$f":"IF(Threats!$G33<=2,$G41, \"\")","v":0}]
[{"$f":"IF(Threats!$G34<=2,$G42, \"\")","v":0}]
[{"$f":"IF(Threats!$G35<=2,$G43, \"\")","v":0}]
[{"$f":"IF(Threats!$G36<=2,$G44, \"\")","v":""}]
[{"$f":"IF(Threats!$G37<=2,$G45, \"\")","v":""}]
[{"$f":"IF(Threats!$G38<=2,$G46, \"\")","v":0}]
[{"$f":"IF(Threats!$G39<=2,$G47, \"\")","v":0}]
[{"$f":"IF(Threats!$G40<=2,$G48, \"\")","v":""}]
[{"$f":"IF(Threats!$G41<=2,$G49, \"\")","v":""}]