User blog:Kevsuc/Crystal Calculator - Manage your Crystal Engine

I've created a simple Excel sheet that you can use to manage the Crystal Engine you own. You can know how much average Crystals you should own by math and its maximum, and it's also helpful to gauge if you should try upgrading your engine or not at all.

The file is in here ---> https://www.dropbox.com/s/1mlpc8nf3anqxbl/Crystal%20Calculator.xlsx?dl=0

If you open it, it's very raw. Indeed, I did not protect or hide some part of the important cells. I tested it and it works perfectly but just in case something is wrong, hopefully you'll be the first to know.

Instructions
For treasures not from the Supreme Treasure Chest, because you can only have one of these treasures, just fill the yellow area with the level of each treasure (from 0-9 without the plus sign "+"). If you don't have the treasure just leave it blank.

For treasures from the Supreme Treasure Chest, Click "Select a Chest Treasure" to select from a list (green column), and fill the level of the treasure (yellow column). Repeat the work if you have a same treasure, but with a different level.

You can also merge multiple treasures of a same level by filling the amount on the Qty (cream orange column). Leaving the Qty blank (not 0) while filling the level automatically translates that you have one treasure of it.

Analysis
From my own Crystal Engine, I can conclude that I have an average of 8.44 daily (so getting 24 just like last week was a great, great luck). I saw it's a very low, since (obviously) I need to upgrade more treasures, but which? I can look inside the table to compare percentage or trying to change the number itself to see the change.

Here's an example: I never upgraded Cookie Run 30M Points Certificate, so let's just upgrade. But upgrading to +3 just gave me a 3% increase in the particular treasure, raising the average to be only 8.47 - so it's not very worthy to upgrade (spending 63,000) but better than nothing.

Now, imagine if I'm upgrading my two +8 Crystal Pearl Earring into maximum level. With the calculator, I will get average of 8.54, significantly better than upgrading my certificate treasure. It also less costly 55,000 assuming that I don't fail.

But wait! I have Lv.60 Legends Club Trophy on +5, it has the highest ratio of all, so far. If I'm upgrading to +9, the ratio will significantly increases into 8.89 - a great benefit with risking some coins. But with Coin Farming and Ghost Pirate's Island of Coins, it's an easy bitsy.

I hope the spreadsheet helps anyone building their Crystal Engine.

19:34, June 3, 2015 (UTC)