Bleach Online Forum

Title: Spirit Stone Calculator v1 [Print this page]

author: ajoalex time: 2014-10-21 09:37:40 Title: Spirit Stone Calculator v1

Edited by ajoalex at 2014-10-22 04:07

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.

[attach]2233[/attach]

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
  [attach]2234[/attach]

  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%
  [attach]2235[/attach]

-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.
[attach]2236[/attach]

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.
[attach]2237[/attach]

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
[attach]2263[/attach]

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)
[attach]2282[/attach]

author: [email protected] time: 2014-10-21 11:32:39

Amazing thanks.

author: Brahmastra time: 2014-10-21 11:41:37

Nice, GJ.

author: frtommy time: 2014-10-21 12:11:43

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

author: ajoalex time: 2014-10-21 13:08:48

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

author: ajoalex time: 2014-10-21 14:20:56

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

author: frtommy time: 2014-10-22 03:22:47

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

author: ajoalex time: 2014-10-22 04:29:04

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

author: ksjkb96 time: 2014-10-22 04:47:29

fast update thanks

author: ajoalex time: 2014-10-22 05:06:33

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

thanks

author: Leitzur time: 2014-10-22 07:43:48

thanks for sharing, i will try it

author: [email protected] time: 2014-10-22 10:59:50

Very neat calculator
Will be very helpful, thanks

author: ajoalex time: 2014-10-22 11:12:17

thanks, do check it out and let me know if there is anything that needs to be updated, i will try to get that added.

author: LadyKyojin time: 2014-10-22 16:01:24

thank you, i was going to do one but you saved me the time and its pretty good, good job

author: Leitzur time: 2014-10-22 23:19:30

ajoalex replied at 2014-10-22 10:12
thanks, do check it out and let me know if there is anything that needs to be updated, i will try to ...

o yeah just another idea, if you add more feature it will be awesome:
1. calculate amount of gold needed to get lv. 5,6,7,etc spirit stone packs from shop or events
2. or new functional calculator such as calculating atk,def, etc we get from hogu, hogyoku, zanpakuto etc by inserting own character's pure base status (unequipped) >> maybe way later because it is so complicated

basic fury can't yet be calculated, is it because lack of datas?
for higher lvl of spirit stones maybe we have to check at CN server for reference

author: ahhhsome time: 2014-10-23 00:15:59

i think this guy deserves some free shyt for makin this lol

author: ajoalex time: 2014-10-23 00:36:44

Leitzur replied at 2014-10-22 22:19
o yeah just another idea, if you add more feature it will be awesome:
1. calculate amount of gold ...

Hi,

1)if you can give me the data for lvl 5+ stones from shop for below VIP6 and VIP6 above players, i would be glad to add that.

2)regarding the functional calculator, i have one with me which has all that you mentioned, just that it doesn't add up to the main stats displayed so i was thinking what all i am missing.

3)basic fury i haven't added the details, i only know of level 4 , if you can provide me with details with the higher levels i can definitely add that.

PS- I am thinking of making an entirely complete calculator with separate sheets for separate characters etc. just that i would need sometime, busy this week for that. But i should be able to get the spirit stone stuff in today if anyone needs any update to it.

thanks guys

author: ajoalex time: 2014-10-23 01:16:22

ahhhsome replied at 2014-10-22 23:15
i think this guy deserves some free shyt for makin this lol

haha, arigato ;)

author: Leitzur time: 2014-10-23 02:19:57

i get this from CN, you have all the data up to lv9 spirit stones right? here is some lv10 and lv11.
10 stam= 20%
10 counter/agi/str/wis=30%

11 str/wis/agi= 37.5%

spirit stone (idk which lv, just grade, and since i don't have any fury stone, i don't know the correct name for grades, just direct translation from chinese)

slightly below super >> intermediate? 16%
super quality 18%

if i find anything more i will give the data, or if anyone can provide more will be appreciated

author: ajoalex time: 2014-10-23 04:37:10

Leitzur replied at 2014-10-23 11:19
i get this from CN, you have all the data up to lv9 spirit stones right? here is some lv10 and lv11. ...

thanks for the data, i will update it once i get a handful of the stats

meanwhile others are free to provide more data so that i can add it to the calculator.

author: [email protected] time: 2015-2-11 09:17:18

..........................................................................

author: [email protected] time: 2015-2-18 17:08:30

................................................

author: ajoalex time: 2015-2-18 23:13:24

i will be adding a fury calculator. any other requests, do let me know

author: angelswetha time: 2015-3-28 02:41:32

nice work well done and thanks

author: NinjaKeyho time: 2015-3-28 22:10:31

I downloaded your calculator and it's amazing. The only problem is that I don't understand it. So could anyone please explain to me?

author: KrisKingOfLegend time: 2015-3-28 22:42:06

i don't have microsoft spreadsheet thingy

can you use some other program please/?

author: ajoalex time: 2015-3-29 00:46:36

KrisKingOfLegend replied at 2015-3-29 07:42
i don't have microsoft spreadsheet thingy

can you use some other program please/?

you can upload it into google drive and it will be opened using google spreadsheets, if you dont have a spreadsheet software in your machine

author: ajoalex time: 2015-3-29 00:47:53

NinjaKeyho replied at 2015-3-29 07:10
I downloaded your calculator and it's amazing. The only problem is that I don't understand it. So co ...

Hey, did you check the first post, i have added gif images on how to start off with it on a basic level. let me know if there is something you need to know on how to using this after going through those images.

author: KrisKingOfLegend time: 2015-3-29 01:23:44

ajoalex replied at 2015-3-28 23:46
you can upload it into google drive and it will be opened using google spreadsheets, if you dont h ...

oh yeah i forgot about that

author: NinjaKeyho time: 2015-3-29 10:12:34

ajoalex replied at 2015-3-29 00:47
Hey, did you check the first post, i have added gif images on how to start off with it on a basic ...

I've finished putting in the info. But I just don't understand it really. Like what are the green and orange boxes for? Or what do these numbers mean? I just need clarification.

author: ajoalex time: 2015-3-29 13:05:25

NinjaKeyho replied at 2015-3-29 19:12
I've finished putting in the info. But I just don't understand it really. Like what are the green ...

the green and orange are the values for those stones. you dont need to change them . you just need to change the output level and amount needed box.

author: frtommy3 time: 2015-7-29 03:44:52

up. Maybe some new player need this

author: frtommy3 time: 2015-10-4 05:52:28

Bumpppppppppppp

author: SeptaTK time: 2015-10-5 19:34:19

Bump , nice work!

Respect for the love of the game to actually help players

author: erlonr time: 2015-10-5 20:01:39

It's great dude!Thanks!

author: [email protected] time: 2016-1-9 15:15:05

Edited by [email protected] at 2016-1-9 13:07

hey, wanna try it, but when try 2 dl it says: can't read attach... was it taken down? can u repost? or is it that I'm novice & can't access sum stuff?

Welcome to Bleach Online Forum (http://forums.gogames.me/)