Agilicious - Part 7

After the events in my third blog post, I worked on creating a tier of stats for one of the classes, the Investigator. The tiers of stats would have a low-value set, along with a medium and high set. If the game was running slow, or if we were plowing through it too fast, it would give us different sets to tweak the pace of the game by increasing or decreasing each classes' stats. Along with this, I would need to create a special ability that is unique to the Investigator class.

I was pretty excited to work on my class' stats. At work, I'm gradually learning some advanced Excel techniques from my boss, who has been an Excel power user since the 90s! I do a lot of data parsing, graphing out thermostat data and comparing different sets to one another. I knew I could apply that skill, along with some handy Google Sheets formulas.

Working off a team member's set of stats for each class, I created a spreadsheet that allowed a user to plug in modifiers for the base stats. A set of five rates allowed a user to quickly generate various tiers of stats. Since applying formulas to multiple cells is so easy, I even included all of the other classes in it too! As a user generates these stats, another tabs has graphs that allow you to visually compare how each class is doing compared to one another. It was a lot of fun!

Featured Picture: A sample of the graphs I created