Read More

Hey everyone! I wanted to announce something I’ve got coming up that I’m really excited about!

On June 24th, 2017 around 9AM EST, I will be starting a blindfolded playthrough of Ocarina of Time. I will be attempting to beat the game from start to finish, without any glitches (the idea is to go through all of the rooms). I expect this to be around 24 hours as I navigate through all of the puzzles and enemies, completely blindfolded!

In addition, I will be raising money throughout the stream for a charity! I’ll have more details in the next week, and I’ll also be experimenting with some things on my stream in the next week that I don’t normally have (donation alerts, bits, etc.) just so that I am sure that everything works the way I want. So expect some more streams from me in the next week. Everything I make in the month of June from Twitch (subscriptions, ad revenue, bits, and donations) I will also put towards the charity. There will be donation incentives and prizes, so you’ll definitely want to check it out.

Thanks for reading and I hope to see you there!

I’ve been fascinated with collecting bingo stats for quite some time. I like thinking about questions like, “How often does ‘Two Fairy Spells’ show up on the boards, and how often is it picked? How often does it win? What is that particular item’s average bingo time?” Things like this are part of why I became an engineer.

Back on version 7 of bingo, I started to manually collect some bingo information. Who won, what the card was, what the top times were, etc. This was a tedious process to input into excel, and I grew very dreadful of the days I’d get behind and have to enter a lot of manual data entry. But the end result was kinda nice, I could look at a glance and answer some of the above questions. I could see if there were any items that were repeatedly winning and take advantage of those, but also report them to the guys like Gombill who fix them for future versions.

After version 8, I decided I didn’t want to manually enter info anymore, and got in contact with Saltor06. He helped me so much, and made a python script that would scrape through SRL’s results page and spit out all the raw bingo data in a csv excel file. I then did my excel magic, a little bit of VBA code, and had a very powerful tool to analysis particular players and items for bingo. It was very fun to update after every few bingos and see the stats and how they changed, look at trends, try and spot patterns. Below is a link to the ‘final’ product for Version 8.5 of bingo:

out8_5

A few things to note:

• This is a .xlsm file, meaning it is an excel file that uses macros. You will need excel and might have to enable macros from a security feature. You can go in and check my VBA code if you know what you are doing, but note that I’m not a programmer by trade and so my code is certainly very poorly written. But hey, it gets the job done.
•  You don’t actually have to run any scripts or macros…those were just to take the “out” tab and filter and move the data around. The excel file should be just fine to view as is.
• That said, you are also free to try and expand and make new tables, charts, etc. if you choose, I’d love to see what you come up with!
• The tabs at the bottom should be fairly self explanatory, ‘out’ is the raw data, the others are usually split either into player stats or item stats. I have it set to sort and filter a bunch of stats.
• The pivot tables tab was kinda an experiment, I haven’t messed with pivot tables much but I did use some of them
• PlayerStats tab is a cool way to look at a particular player.
• Some of the stats are straightforward, others aren’t.
• On the PlayerOverview Tab:
  • BBWins is “big boy wins”, a winning bingo where 3 or more players in the race were ranked over 900
  • WinRow is if the player picked the winning row, even if they did not win the race.
  • Snipes/Sniped means you won/lost to someone else (not necessarily for the win, but could be 2nd over 3rd, etc) by 10 seconds or less
  • Blank means that player did not declare their row in the comment, and I shame them for not giving as much info and stats as possible!!!
• On ItemOverview Tab:
  • The ratio of appeared:used can be over 1, because if it appears once and 5 players picked it, that obviously will play a factor.
  • 900 stats filters for only players that had over 900 ranking (basically top 15 players on SRL)

I hope you guys enjoy some of these stats! Note that I don’t have anything currently going for V9.0, it was pretty crazy at release, and updated several times already to fix some pretty big bugs. So it wouldn’t have a very congruent set. However, V9.1 is coming out soon, and I very much hope it’s rock solid and stable, and Saltor06 can help work with me to get this back up and running. I’d love to start to get some stats again, it’s a fun thing to share with the stream and it honestly motivates me to improve and do more bingos.