Game Sale Quality Calculator

In my spare time, I crafted a spreadsheet calculator (with lots of pretty colors with conditional formatting!) that uses a variety of measurements to help you decide how good a deal is. All you need is to enter the game name, regular price, sale price, and OpenCritic and SteamDB scores. Other critic or community scores will work just fine if the game you're inputting doesn't have OpenCritic or SteamDB scores; I just prefer those sites whenever possible as I personally find them to be the most accurate for those metrics.

If a game doesn't have scores from critics and/or the community, you can use the 50th percentile values I provided for OpenCritic or SteamDB, or leave it blank. Do note that if one score is left blank it can adversely affect the accuracy of the measurements, especially as the other score veers away from the 50th percentile value. I have not yet had a situation where I couldn't find both critic and community scores, but if this is the case, just use the 50th percentile values for both to get a calculation. The more data points you have, the more accurate the measurements will be -- but nearly every AAA game and most indie games have at least one of these scores available.

Here is the link to the template:
https://docs.google.com/spreadsheets/d/1tlwKhTfY6jHj900kP6eFTtYj9jFOHq5d5lhpSPENMTc/template/preview

Constructive criticism is fine, but I'm not really willing to change the overarching format of the project at the moment. Since this is a template, you can of course make a copy for yourself and mess around the formulas and such. I didn't implement this for my purposes, but for example, you could adjust how the combined rating is calculated -- currently, it is a simple average, but you can adjust the ratio if you use different ratios to multiply with the ratings and IF statements (which you need in case one is empty, as multiplying by zero will result in a combined 0% rating instead of an average).

One final note, one thing I'm looking to integrate for my own usage is importing game info from my IsThereAnyDeal waitlist and potentially other rating sites into a separate sheet that I can then import appropriately into my own template. I couldn't figure this out myself as that's a bit above my own knowledge, but if anyone has any ideas how this could work, feel free to let me know.

Hope you find some use out of it! :)