Game Dev: Balancing Adventurer Guild Simulator

For the past 2 weeks I’ve been working on developing a game in my spare time: it’s tentatively titled ‘Adventurer Guild Simulator’, as it’s about running an adventurer guild in a fantasy setting (think Dungeons and Dragons). In the game you’ll be hiring adventurers to go on quests to raise the reputation of the guild … Continue reading Game Dev: Balancing Adventurer Guild Simulator

Nintendo Console Dashboard

If it weren't apparent enough from my Splatoon 2 analyses, I love Nintendo. So, of all the things one can make a Dashboard about, of course I went ahead and created a Dashboard using data about Nintendo's array of home consoles. https://gfycat.com/BigheartedGrimyInexpectatumpleco This was done using Excel - but I'm really interested in working on … Continue reading Nintendo Console Dashboard

HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table

This is a continuation of the previous tutorial. Due to the volatility of the INDIRECT function, it may be necessary to avoid using it when trying to create large dashboards which will be handling and outputting large amounts of data. So, we’ll need an alternative in these cases. One of the ways this can be … Continue reading HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table