What is the Opportunity Score? (And how to calculate it) — Part II
In my previous post I summarized what the Opportunity Score is and provided a tool to put it into practice. The tool I proposed, an R script, allows to calculate the Opportunity Score and also to generate the Opportunity Landscape/Map. It is relatively simple to use, but you still need to install R to run it, and some basic R knowledge if you want to customize it.
After discussion with some of my teammates, I realized the R approach creates more trouble than it solves, and that we needed an easy-to-use tool for people interested in applying the method. So without further fanfare, here is OppScoreWeb:
OppScore is an open-source Web application (here’s the URL: https://jpcarrascal.github.io/OppScoreWeb/) that allows you to calculate the scores, generate the map/landscape, and export the data so you can use them in your report, all from a Web browser.
When you open the tool in your browser, it will load a sample dataset. You can play around with it to see how the tool works: click on Map Data to generate the scores and map; the Copy Scores button copies the scores as a tab-separated text table to the clipboard (so you can easily paste it into Excel); and hit Export landscape/map to download a PNG file with the map. Start fresh by clicking the Clear data button.
To import your own data, you have two options:
- Paste your scores from a CSV or TSV file (including Excel). Make sure the data contains 3 columns, first one with Outcome labels, second with Importance values, and third with Satisfaction values. The tool will remove incomplete rows and most garbled data, but it behaves best if your data is consistent.
- Import a CSV file with headers. It doesn’t matter how many columns it has, as long as it has the 3 required ones (again, Outcome, Importance and Satisfaction).
This is an open-source tool (currently in beta), and here is the GitHub repository: https://github.com/jpcarrascal/OppScoreWeb. It uses these external packages:
- D3.js
- Save SVG as PNG: https://github.com/exupero/saveSvgAsPng
- CSV parser: https://github.com/d3/d3-dsv
It might still have some bugs (thank you Irina Smoke for alpha-testing it), so do get in touch with me or file issues in GitHub if you find bugs. Questions and suggestions are also welcome.
I hope you find it useful!
