Nintendo Console Dashboard – Linked Pictures

I was taking a glance around the Excel tag in the WordPress Reader, when I came across the following blog post about Linked Pictures in Excel.

This was a little bit of a revolution to me; when I made the Nintendo console dashboard I struggled to work out a passable fix for including dynamic pictures in VBA, ultimately deciding to scrap the code and just go with no pictures. Now that I know how to use Linked Pictures with named ranges to allow dynamic updates I could easily go back and update the old Dashboard!

Excel Examples

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.

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!

Write-Up