Using Linked Pictures to update my Nintendo Console Dashboard.
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
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
This is a follow-up to the last tutorial. Thanks to reddit user /u/small_trunks for noticing my blunder! Unfortunately, 'SUMIFS' couldn't be used on its own to create the dynamic data tables. But don't fret! I have another solution up my sleeve that doesn't rely on volatile functions like 'INDIRECT' and 'OFFSET'! It relies entirely on … Continue reading HOW TO… Excel: A Truly Non-Volatile Solution for Dynamic Data Tables
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
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 … Continue reading HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes
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. What particularly interested me with … Continue reading How Cryptocurrencies are Shaking Up the World of Big Data
The third and final part of my three part blog series on statistically analysing my performance in the Ketchup vs. Mayo splatfest. Here we use box and whisker plots to look at my performance with the Splattershot.
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 … Continue reading Zipf’s Law
The second part of my three part blog series on statistically analysing my performance in the Ketchup vs. Mayo splatfest. In this part we look at win/loss ratios on the different weapons used.