Spirit Stone Calculator v1

ajoalex

Hi All,
Since I am seeing many people asking and enquiring how to get their spirit stones right, I am sharing this with you all. I had created this simple calculator so that it would assist me in adding the spirit stones in the right place. Download this and use it if you think it would help you.



How to use-

- Name your players in the place where its mentioned "Player 1", "Player 2" etc
- Enter the level of the stones that you are using for your player in the appropraite list.
  eg if your Main has level 3 strength stone in his headband, then under Strength and next to Main, headband click the dropdown and select lvl 10
  

  after you select the level of the spirit stone, it will calculate the % of that attribute for your player.
  eg: say i filled strength spirit stones of level 2 and level 3, three of each for Main, then it will calculate the total and print on top , and it shows that total strength % due to strength stones on Main is 22.5%
  

-Its as simple as that, on the right most side you will find the number of stone slots available for a player and the number of stones for each equipment.
eg, so for the above case it shows this, column N. So N4 shows 30 which means that you can equip 30 more stones . N5-N10 shows that the 6 equipments for MAIN are equiped with only 1 stone and that you can equip 5 more in each equipment.



Its using the % value for the stones defined here( I am not sure about the values of the rest, if someone can give i can update it accordingly, the ones from 6-9 i have searched it by seeing other player's stone).There are two categories here, green and yellow, just to imply that the yellow ones doesn't offer a significant increase of % with its higher stones.


So yes, this can be used to think about which stone to keep where, and which player's stones can be upgraded from where and all that stuff.

And yes, if you are using this then don't forget to make the changes in the spreadsheet whenever you change stones. I usually do the stone calculation at once and not one stone a day or so. In that way i get to calculate and do them accordingly.

Do try it out and let me know.

Cheers

Updated v1.1
- calculate how many level stones you need to synthesize to get an output level stone
  eg, how many level stones needed to get 3 lvl 6 stone
  so you select the output level you need ie level 6, so select lvl 6 from dropdown in B60, then the values are calculated and shown that you need 32lvl1 to get a level 6 stone or 16lvl2 to get a level 6 stone etc.
  now you can enter the number of level 6 stones you want at B62, here if you want 3 of level 6 stones, then you enter 3 and you will see the corresponding level stones


Updated v1.2
- calculate how much gold is needed to buy a specific level stone (for VIP6 below and VIP6 above players)
eg to know the gold needed to get 6 level 6 stones
--for a free player upto VIP5, s/he would need to spend 2880 gold to buy 24 level 4 stones. s/he can also spend the same gold to buy 192 level 1 stones.
--for a VIP6 player and above, s/he would need to spend only 2304 gold to buy 192 level 1 stones. a VIP6+ player need to spend gold only for level 1 stones as its cheaper(See image)

[email protected]

Amazing thanks.

Brahmastra

Nice, GJ.  

frtommy

I'll try it.
Thank you very much for your work.


P.s.= Don't understand if this function it's already in.  Will be nice calculate how many lvl1 spirit stone u need for Synthesize a Lvl3 etc...

Example: I have in my backpack 1xlvl1 strenght stone, 3xlvl2 strenght stones, 1x lvl5 strenght stone.
I want to make 3x Lvl 6 Strenght spirit stones.  Will be nice if there was a box told us u need 20x lvl1 strenght stones or 10x lvl2 strenght stones.  This is an example, the results are not calculated well

I hope u understand my bad english XD

ajoalex

frtommy replied at 2014-10-21 11:11
I'll try it.
Thank you very much for your work.

I actually have it in my spreadsheet, i didn't add it .

I can add it and upload it . Will let you know.

thanks guys

ajoalex

frtommy replied at 2014-10-21 11:11
I'll try it.
Thank you very much for your work.

I have uploaded a newer version with the feature you wanted. Do take a look and let me know.

thanks

frtommy

ajoalex replied at 2014-10-21 13:20
I have uploaded a newer version with the feature you wanted. Do take a look and let me know.

tha ...

Downloading
Thx

ajoalex

I have added another update, one can calculate the number of gold needed to buy any number of spirit stones, for a VIP6 and above or below player too.

Do check and let me know.

Thanks

ksjkb96

fast update thanks

ajoalex

I have now added gifs instead of images. Easier to understand.

thanks