Help me complete my Shard to Character guide?

Benpo19
25 posts Member
edited May 2016
I have most of the information but could use some help filling out my table.

Basically I want to make a guide (with a google doc that does the calculations for you) for how many shards you need to max a character based on what you already have and if they are activated or not.

The amounts to move up each level are pretty easy

1 -> 2 = 15 shards
2 -> 3 = 25 shards
3 -> 4 = 30 shards
4 -> 5 = 65 shards
5 -> 6 = 85 shards
6 -> 7 = 100 shards

Each character has a base need to activate them. Do these numbers look right?

New Character Redemption
10 shards - 1 star
25 shards - 2 stars
50 shards - 3 stars
80 shards - 4 stars
145 shards - 5 stars


Also anything you would like to see in the guide to make it more comprehensive?
Post edited by Benpo19 on

Replies

  • Options
    You might find this formula helpful: If 'A2' is the current star level of a character, and 'B2' is the current # of shards they have towards the next level, your formula for 'Shards remaining until Max level' should be:

    =IF(A2=0,330,IF(A2=1,320,IF(A2=2,305,IF(A2=3,280,IF(A2=4,250,IF(A2=5,185,IF(A2=6,100,IF(A2=7,0,N/a))))))))-B2

    It might also be useful to throw in an estimate on how many days you need to get the character up to max shards (based on how many cantina battles they can be found in, 5 cantina energy regen/hr, hard nodes, presuming a 30% drop rate, etc.)
  • Benpo19
    25 posts Member
    Options
    Thanks for the formula I will compare that to how I am currently doing it and see what works better. I had not thought about the estimate for how many days I will for sure add that in.
Sign In or Register to comment.