Clash Royale, Part 2

Just an update to the spreadsheet: added Card Level Data tab, with leveled data for every card, and a Card Comparison tab, where you can compare two cards, setting a level for each.

At the final lines there is a comparison of hitpoint and damage per elixir cost. I added an exponential factor for the elixir cost because too expensive cards mean too much time waiting for the amount of elixir needed; if the opposing player attacks, you have to decide between waiting further and risking the loss of a tower, or using a defensive card and having to wait for the elixir again.

Any input on improvements would be much appreciated.

Here is the link:
https://docs.google.com/spreadsheets/d/1VTsbsUSjqN7hDjrB5EiSsNu79br3OW0HUK3I1VEV5WQ/edit?usp=sharing

Clash Royale, part 1

The whole idea for this blog started with the data I'm collecting for Clash Royale. This is not the first time I do it, of course, but on Royale things are starting to get serious.

This spreadsheet is quite detailed. It is public, so most of the pages are locked. I'll prepare another sheet to get public data on chests, stay tuned.

These are the pages:

• Questions - questions I'll try to answer with the sheet data. Or from my experience.
• Referenced Values - values referenced by other pages. There you can mess with the value ratio for common, rare, epic and legendary cards, and calculate how many gems are needed to get an amount of gold.
• Chest Data - how many cards you get on the chests, and how much they are worth.
• Card Data - data on every card in the game. I'm still trying to figure out a generic formula to calculate hit point and damage increase per level. So far, increasing 10% per level and rounding gives a small error compared to the actual in-game numbers. Any info would be appreciated. If no formula is found then the next step in this is adding a page with all the variable data for the cards, copied from the wiki.
• Card Costs - the costs of buying cards in the shop, in gold and gems.
• Chest sequence - the sequence of chests you get from winning battles.
• Updates - a list of updated values, no use so far.

I'm planning a few future features for the data on this game:

• Public chest result input form, to get stats on card chances, etc;
• Card comparison, with card stats per level
• Counter-card list

Any suggestions and corrections would be appreciated.

Without further ado, here is the link for the spreadsheet:

https://docs.google.com/spreadsheets/d/1VTsbsUSjqN7hDjrB5EiSsNu79br3OW0HUK3I1VEV5WQ/edit?usp=sharing

Sources on chest data, card data, card values, etc: http://clashroyale.wikia.com/
Everything else is credited on the spreadsheet itself.

Inauguration Speech

Hello, world.

As the blog title says, I consider myself a gamer. Being a gamer is somewhat like being a lady: if you have to say it, you aren't. I know, I just said it. Video games have been a passion for me since I got my first device. I think it was one of those cheap electronic games with fixed sprites (a cheap clone of a Game&Watch, probably). This small gadget got me hooked instantly. After a few years (1994, IIRC), it was my first PC, a 486, 25MHz, 4MB of RAM, 150MB hard disk. It still worked a few years ago. To show how far we got, I still keep a much cherished copy of it's hard drive, in my phone, and I can emulate all of the games on an Android port of DosBox. Anyway, this just paved the way for the future. Although I never owned a video game console, emulators are addressing this flaw quickly. I'm a hardcore player, that longs to explore games to their very end. I'm one of the few among my friends that like game so much, and a lot of them share my Computer Science degree. In short, I consider myself a gamer, but I'll let you be the judge of that.

As the blog title also says, I happen to like spreadsheets. Not just spreadsheets, mind you: data management, databases, big data, data scraping... along with math, statistics, and a healthy dose of obsession for tracking data.

Mix all this, plus the huge amount of trackable data on today's (and why not yesterday's) games, and you get me. A game & math nerd, with a passion for efficiency planning, using sheets, databases and math to get an (honest) edge on the games I play.

Welcome to my blog =)