Thanks, I'm glad that you take some time to look at it and give there remarks.
To compute the MVP value of a girl, I remove her from the team and see how the team is affected.
I compute the difference between the damage done by the full team and the damage done by a 4 girl team, and this for all girls. The result is scaled with the average for easier reading.
This value show how much the team is affected if you remove her, so if you want to change a girl in your team, start with the lowest MVP value.
New ideas are welcome to improve this.
Here, the pests have no HP (or infinite HP if you prefer). It's like you are against a Raid Boss, or in "Endless melee" mode.
This way I can compare the end damages.
You can also change the maximum duration of the fight ("Number of turns")
This is the first thing I will change.
You can also test and give the ability 302 (1.2x Battle Skill activation rate for all Squad members on the 3rd turn.) to two girls.
You can already have up to 5 enemies, just change the "Pest number". I think this label is bad but I don't know how to change it.
In the example there is 3 enemies: 1 Boss and 2 pests (you can check the Pest team just below the title).
Again, thank you your time and remarks.
I am aware that it's not perfect, and I will try to improve it.
I also want to say that excel is not always suited for these computation (some formula have a lot of conditions and are quite complex : take a look at the "Total damage to Team" in the "Team" tab ) so I will be limited.
- - - Updated - - -
I know it's not the right thread, but I will post my new garden here.
The title:
For the ceremony, bring roses and lilies.