OppScore

Note: There is also a friendly web version runnin here: https://jpcarrascal.com/OppScoreWeb/ (repo: https://github.com/jpcarrascal/OppScoreWeb)

Yet another R script for calculating opportunity scores and plotting the Opportunity Map / Landscape.

UPDATE: OppScore calculation was yielding wrong values! It's fixed now.

This one does not require anything beyond base R. A sampledata.csv file is included for testing purposes.

How to use:

1. Format your data as a CSV file. It should have at least 3 columns: outcome, importance and satisfaction. Additional columns will be ignored. Here is an example of how your .CSV file should look like:

| *subject | outcome | importance | satisfaction | | --- | --- | --- | --- | | student1 | Passing exams | 5 | 3 | | student2 | Passing exams | 4 | 3 | | student3 | Passing exams | 5 | 2 | | student1 | Hiding from professors | 4 | 4 | | student2 | Hiding from professors | 2 | 1 | | student3 | Hiding from professors | 2 | 3 | | student1 | Getting submission accepted | 5 | 2 | | student2 | Getting submission accepted | 5 | 3 | | student3 | Getting submission accepted | 4 | 5 | | ... | ... | ... | ...|

(*the "subject" column will be ignored)

3. Optionally, if your input scale is not 1-5, modify the midpoint parameter in the script. It should be equal to the middle point of the scale. E.g., for a 1-5 scale midpoint should be 3. If your scale is 1-7, then it should be 4 and so on. (Values above the midpoint parameter (either importance or satisfaction) will be considered positive. This is an important consideration when computing the score. Note that using a scale other than 1-5 deviates from Ulwick's recommendation.)
4. Make sure the data and the script are in the same folder.
5. Run the whole script. Voila.

References:

• Ulwick, Anthony. What customers want. McGraw-Hill Professional Publishing, 2005. This is the main source for the Opportunity Score method.
• Function to round numbers in data frame that contains non numeric data by Jeromy Anglim.