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 and to thwart the plans of villains within the area. Adventurers will be fighting monsters, solving the secrets of locations, gaining experience and collecting riches on your behalf. The game is being developed in Unity, which I can highly recommend to any budding game developers!

Excel Examples Game Dev

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 done is by using the SUMIFS function, and structuring our data to be compatible with the SUMIFS function.

How to How to... Excel

HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes


Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don’t know where to start. Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touch of a button. I have a few pet peeves with Pivots however, mainly being that they require data be in a particular layout; that they can be restrictive on the type and layout of the output they produce (although they do provide a good level of options); and when updating or changing data within a spreadsheet Pivoted data does not refresh unless it’s explicitly told to (which can create a jarring experience when handling and presenting larger data sets).

How to How to... Excel

How Cryptocurrencies are Shaking Up the World of Big Data

Following the hubbub of Bitcoin reaching $10,000 (and shortly thereafter $11,000) per coin, the cryptocurrency world piqued my interest. After following a variety of subreddits regarding cryptocurrency, and doing a lot of reading around the subject I came across a really interesting new development – IOTA, the non-blockchain based cryptocurrency.

Data News

Splatfest Analysis (Part 3)

In this final Splatfest Analysis, we will be taking a closer look at the distributions of the 9 games I had with the Splattershot to determine whether its consistent place in the top 3 was due to me consistently playing well with the weapon, or whether the averages were skewed by particularly high leverage outliers.


Zipf’s Law

After watching a long session of ‘VSauce’ videos (great brain food videos, albeit very addictive!), I came across this video discussing ‘Zipf’s Law’. Zipf’s law states that in any corpus of natural language, the frequency of any word is inversely proportional to its rank in the frequency table. This Zipfian distribution applies to many different types of data studied across a variety of fields (the video discusses a large variety of these instances). Zipfian distributions also follow the ‘Pareto Principle’, the 80-20 rule. 80% of the words used in any corpus are only 20% of the unique words used.

After being utterly captivated by this phenomenon, I decided it would be fun to check whether my blog, being a corpus of natural language, followed Zipf’s law.

General Write-Up

Splatfest Analysis (Part 1)

Splatoon 2 came out on the Nintendo Switch a couple weeks back, and they’ve had their first ‘Splatfest’ since the game was released. ‘Splatfests’ are worldwide events that pit two similar things against each other in an opinion poll (for this Splatfest it was Mayo vs Ketchup). After voting for your favourite, you’ll then be playing the game mode ‘Turf War’ against members of the opposite team, to determine which side is the best at Splatoon. I picked Ketchup, and I battled valiantly to prove that Mayo is bad and everyone who likes it deserves to lose at Splatoon.

During this Splatfest, I used Nintendo’s phone app to collect the data of my Splatfest matches in order to analyse my performance over the 24-hour event. I’ll be using this data for a multi-part analysis, covering a variety of sections like which weapons was I best with, what stages I was better at and more!