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.
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:
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.)
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.
Replies
=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.)