Forum Discussion

RoxyWolf's avatar
RoxyWolf
Copper Contributor
Feb 06, 2020
Solved

help for setting up a formula to calculate monster evolving in Summoners War

Hi. I want to make an excel file that I can use to calculate how many units I can evolve.
Basic info:
for a 2* (2 star) unit to evolve, it needs to be max level, and needs 2 other 2* units (of any level) to become a 3* unit
for a 3* (3 star) unit to evolve, it needs to be max level, and needs 3 other 3* units (of any level) to become a 4* unit

how I want the excel to work is like this:

A1 here I type in the ammount of 2* units I have
A2 here is the formula for how many 2* max level units I need to evolve those units

A3 here is the formula for how many 3* I will get from that
B1 here I type in the ammount of 3* units I have
B2 here is the formula for how many 3* mac level units I need to evolve the 3* units I have typed into B1, and taking the ammount of 3* units I got from evolving 2* units in A3
B3 here is the formula of how many 4* units I will get from that

I will also be having a formula for 4* into 5* but that one I is similar to the 3* one, so I'll be copy pasting that formula and adjust it for 4* instead of 3*

I have basic excel knowledge from school, and using it for simple things from now and then
I know how to use the standard commands like multiplying, adding multiple numbers together and so on.
I do not know how to make advanced formulas like I am trying to do now

  • I found the solution myself. 

    A1 8
    B1 =Rounddown(A1/2,0)

    A2 6

    B2 =Rounddown(A2+B1/3,0)

     

     

    it was a bit simpler than I thought it would be

3 Replies

  • RoxyWolf's avatar
    RoxyWolf
    Copper Contributor

    I found the solution myself. 

    A1 8
    B1 =Rounddown(A1/2,0)

    A2 6

    B2 =Rounddown(A2+B1/3,0)

     

     

    it was a bit simpler than I thought it would be

  • macrordinary's avatar
    macrordinary
    Brass Contributor

    RoxyWolf 

     

    Lemme see if I have this right...

    Say you have 8 2* (non-maxed), 5 2* (maxed), 6 3* (non-maxed), 6 3* (maxed)

    A1 = 8

    B1 = 5

    C1 = MIN(B1,INT(A1/2)) [You can evolve all your maxed 2* or any that you have 2X 2* non-maxed)

    A2 = 6

    B2 = 6

    C2 = MIN(B2,INT((A2+C1)/3)) [You can evolve all maxed 3* or any that you have 3X 3* non-maxed).

     

Resources