{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Questionnaire","Score","1-5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":"Questionnaire","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,1,38,1],[10,1,10,2],[9,1,9,2],[0,0,0,2]]}
[]
[null,"Outsourcing Qualification"]
[]
[null,"On a scale from 1 to 5, please rate your response, where:"]
[null,"1. Strongly disagree"]
[null,"2. Disagree"]
[null,"3. Neither agree nor disagree"]
[null,"4. Agree"]
[null,"5. Strongly agree"]
[null,"The \"opportunity\" can be either a limited duration project with specific deliverables, for example, application development, or some specific set of ongoing activities, such as break/fix, with no set time limit (more oriented toward BPO)."]
[null,"OPPORTUNITY NAME: "]
[null,null,"Please select a value"]
[]
[{"$f":"A12+1","v":1},"My opportunity is well-defined.","-- Select value --"]
[null,"Organizational, functional, and workflow inputs, outputs, and boundaries are well-understood and documented. Scope, key risks, key assumptions have all been identified."]
[]
[{"$f":"A14+1","v":2},"My environment is stable.","-- Select value --"]
[null,"Technology in use is not changing, minimal changes to applications and business workflow. Predictable and well-understood."]
[]
[{"$f":"A17+1","v":3},"My opportunity involves new technology.","-- Select value --"]
[null,"Substantially changes hardware and/or software in use in the department/organization."]
[]
[{"$f":"A20+1","v":4},"My opportunity involves a mission-critical function.","-- Select value --"]
[null,"The workflow impacted by this opportunity is key to the organization and/or the enterprise. There is an immediate negative business impact in the event of outages or errors. This function is visible to Pearson customers and/or the market at large. Pearson's reputation can suffer as the result of a mistake or failure. All functions are \"important,\" please rate based on risk exposure to Pearson."]
[]
[{"$f":"A23+1","v":5},"My opportunity significantly changes business workflow.","-- Select value --"]
[null,"Substantially changes the order and/or flow of work within the deparment and/or organization, and/or eliminates and/or introduces new workflows."]
[]
[{"$f":"A26+1","v":6},"My opportunity is strategic.","-- Select value --"]
[null,"Aside from other considerations of major impact (technology, workflow), and apart from current \"importance\" in the organization, represents an oppportunity to gain a significant competitive business advantage (scale, economy, uniqueness)."]
[]
[{"$f":"A29+1","v":7},"My opportunity is highly complex.","-- Select value --"]
[null,"Addresses factors such as technology complexity (application logic, complexity of data feeds,...) and workflow complexity (management of, large number of inputs and outputs, complex decision trees implemented in automated and/or manual workflow,...)."]
[]
[{"$f":"A32+1","v":8},"My opportunity and environment are self-contained.","-- Select value --"]
[null,"Minimal, small-scale, and well-managed interactions with the \"outside world\": applications minimally \"talk\" to other applications, minimally connect to customers or other internal organizations for inputs and outputs. Workflows are largely contained within departmental/organizational boundaires. Impact of changes limited primarily to department and/or organization."]
[]
[null,"\n Please finish scoring first"]
[null,null,"To enable running the\n\"Check Opportunity\" macro, set Tools... Macro... Security... to \"Medium\" (the default of \"High\" disables all unsigned macros)"]

{"sheet":"Score","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Score"]
[null,"Response","Value","Best is","Normalize","Comments"]
["Well-defined",{"$f":"Q_defined","v":"-- Select value --"},{"$f":"IF(ISERROR(FIND(\".\",B3)),\"no value\",VALUE(MID(B3,1,FIND(\".\",B3)-1)))","v":"no value"},5,{"$f":"IF(ISNUMBER(C3),IF(D3=5, C3, 6-C3),\"no value\")","v":"no value"},"The better defined, the more highly rated"]
["Stable",{"$f":"Q_stable","v":"-- Select value --"},{"$f":"IF(ISERROR(FIND(\".\",B4)),\"no value\",VALUE(MID(B4,1,FIND(\".\",B4)-1)))","v":"no value"},5,{"$f":"IF(ISNUMBER(C4),IF(D4=5, C4, 6-C4),\"no value\")","v":"no value"},"The more stable, the more highly rated"]
["New technology",{"$f":"Q_technology","v":"-- Select value --"},"no value",1,"no value","New technology counts toward a lower rating"]
["Mission-critical",{"$f":"Q_critical","v":"-- Select value --"},"no value",1,"no value","Mission-critical  counts toward a lower rating"]
["New workflow",{"$f":"Q_workflow","v":"-- Select value --"},"no value",1,"no value","New workflow counts toward a lower rating"]
["Strategic",{"$f":"Q_strategic","v":"-- Select value --"},"no value",1,"no value","Strategic counts toward a lower rating"]
["Complex",{"$f":"Q_complex","v":"-- Select value --"},"no value",1,"no value","Complexity counts toward a lower rating"]
["(Self-) Contained",{"$f":"Q_contained","v":"-- Select value --"},"no value",5,"no value","The more self-contained, the mroe highly rated"]
[]
["Calculations","Average",null,null,{"$f":"IF(COUNTIF(EVAL_normalized_values,\"=no value\"),0,AVERAGE(E3:E10))","v":0}]
[null,"Standard Deviation",null,null,{"$f":"IF(COUNTIF(EVAL_normalized_values,\"=no value\"),0,STDEV(E3:E10))","v":0}]
[null,"Confidence (@99%)",null,null,{"$f":"IF(E13<>0,CONFIDENCE(0.01,E13,COUNT(E3:E10)),0)","v":0}]
[null,"-> Confidence interval low",null,null,{"$f":"E12-E14","v":0}]
[null,"-> Confidence interval high",null,null,{"$f":"E12+E14","v":0}]
[null,"Ratings <= 3",null,null,{"$f":"COUNTIF(EVAL_normalized_values,\"<=3\")","v":0}]
[]
[null,"Data","Test","Value","Eval","Description"]
["Gates",{"$f":"B12","v":"Average"},">=",3.5,{"$f":"COUNTIF(E12,CONCATENATE(C20, TEXT(D20,\"0.000\")))=1","v":false},"At least halfway to \"Agree\""]
["\"pass\" =",{"$f":"B13","v":"Standard Deviation"},">=",0,true,"any value OK"]
["all TRUE",{"$f":"B14","v":"Confidence (@99%)"},"<",1,true,"Statistically, check the spread of values (less than # away from average in 99% of expected cases)"]
[null,{"$f":"B15","v":"-> Confidence interval low"},">",2.5,false,"Statistically, check we're not voting too low (that is, we would expect more \"data points\" in the low range based on current values)"]
[null,{"$f":"B16","v":"-> Confidence interval high"},">=",4,false,"Statistically, check we're voting high enough (that is, what's the highest we'd expect based on current values should voting continue similarly)."]
[null,"Low or on-the-fence ratings","<=",3,true,"Statistical \"quality\" aside, don't let enough sufficiently positive ratings to pull \"neither positive nor negative\"  into the \"good candidate\" range"]

{"sheet":"1-5","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["-- Select value --"]
["1. Strongly disagree"]
["2. Disagree"]
["3. Neither agree nor disagree"]
["4. Agree"]
["5. Strongly agree"]