The FKG Fight Simulator Project !

[flink]

A Team power is more than just TP.
So I have been working on a special project to test team composition :
The FKG Fight Simulator Project !

Basically it's an excel which simulate a team fight, including skill and ability effects.
You can find informations and examples of team composition in this thread : Team Tactics (http://harem-battle.club/flower-knight-girl/2220-team-tactics.html)

You can download the file here :
http://s000.tinyupload.com/?file_id=02131311056617999655



How to use it :

Download the file and unzip it.
In the TEAM SETUP part of the excel, put the stats, skill and abilities of your Waifus. That's all.
For the abilities, use the ID (found just below TEAM SETUP).
You can also edit the Pest Team.


Important :

DO NOT CHANGE the RED parts. They are used for computation and automatically updated.
The parts you can edit are in blue.
Also, you can use copy/paste, but avoid cut : it can mess the cell references.


Special Tips :

> The Pests have infinite HP :(
But you can setup the duration of the fight with the parameter "Number of turns"

> Parameter "Target weakest":
0 : the pests will attack "randomly"
1 : the pests will mainly focus on the knight with the less HP

> For HP drain skills (Rogue Edge, Death Waltz...), the "Skill Target" value is 1.5

> For Multi-Hit skills (Double Thrust, Triple Drill..), the "Skill Target" value is 2.5 or 3.5


I am waiting for your remark and comments.:)

[furude20]

Cause its late at night here so I try with the given characters that you have placed already first. I'll try more the next morning to give a more detailed report.

Firstly, I would like to know what is the MVP ranking. How is it being judged and calculated? How does it compare to anything?

2ndly, I would like to know what is the remaining hp of pests per turn. Giving the amount of dmg of each girls to the pests does not give much help because the pests can die by any turn which I have no idea of. I believe for the graphs, the x-axis is the number of turns but there are no labeling for this. I suggest adding the numbers for the graphs will be a huge help as the abilities of some girls are activated by the 3rd turn which may changed the battle quite drastically. This will definitely help the player a lot in many ways in planning and knowing the value of the said girl.

Furthermore, I realised the total amount of damage that the team makes is more than the total HP of the boss and the pest. It does not make any use to us to know anything beyond the turns when all the pests have died. In addition, maybe you should add an option to edit a Pest Number 3 since commonly 3 enemies rather than just one.

That's all for now. I'll make an even more detailed report the next day. I have to add though, this is a nice idea. I like it only a bit but there's still some things that's clearly and have no time for me to mention at the moment that need to work out.

[flink]

Cause its late at night here so I try with the given characters that you have placed already first. I'll try more the next morning to give a more detailed report.Thanks, I'm glad that you take some time to look at it and give there remarks. :)


Firstly, I would like to know what is the MVP ranking. How is it being judged and calculated? How does it compare to anything?
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.


2ndly, I would like to know what is the remaining hp of pests per turn. Giving the amount of dmg of each girls to the pests does not give much help because the pests can die by any turn which I have no idea of.
[...]
Furthermore, I realised the total amount of damage that the team makes is more than the total HP of the boss and the pest. It does not make any use to us to know anything beyond the turns when all the pests have died.
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")


I believe for the graphs, the x-axis is the number of turns but there are no labeling for this. I suggest adding the numbers for the graphs will be a huge help as the abilities of some girls are activated by the 3rd turn which may changed the battle quite drastically. This will definitely help the player a lot in many ways in planning and knowing the value of the said girl.
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.;)


In addition, maybe you should add an option to edit a Pest Number 3 since commonly 3 enemies rather than just one.
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).


That's all for now. I'll make an even more detailed report the next day. I have to add though, this is a nice idea. I like it only a bit but there's still some things that's clearly and have no time for me to mention at the moment that need to work out.

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 :eek:) so I will be limited.

- - - Updated - - -

I know it's not the right thread, but I will post my new garden here.:p

The title:
For the ceremony, bring roses and lilies.

http://i.harem-battle.club/images/2016/12/20/GqDbRJcN.png

2967