Here's the creating combat document:
https://1drv.ms/w/s!AqX6ORoY5-DlgmG0j7xQPx56TrtC
On another note, the child entry doesn't seem to override the parent's stats(Or maybe I am doing something wrong). I have modified the vitality value for HardcoreNPC to be "2000"(so now chicken, rats etc have a very high vitality).
If the child entry has a blank space in a column it will take whatever is filled in from the parent.
So I'm guessing those chickens and rats have nothing filled in for vitality (because they usually just use constitution like I mentioned). Basically you did give them 2000 vitality :P.
It is NOT the HP value, Vitality is the multiplier for the base HP, which are calculated from constitution and Act Part.
Test it in a game, you can even test it with a player, it is the percentage that is shown as 'Boost' in the tooltip of the character's HP.
To reduce these animals' individual vitality, I tried changing it from the individual entry, but that doesn't seem to work.
Did you run the macro after making changes? For simplicity just use the all.xlsm macro.
Also the excel files should go in Public\<YOUR MOD>\Stats
The excel files generate txt files which end up in the Public\<YOUR MOD>\Stats\Generated folder.
With a value of 2000, he changed the multiplier from 120% (default 20 for Tactician in the meta entry) to 2100.
Standard entries have the base value of 100 from 'using' _Base or an entry that is 'using' _Base.
Of course does changing individual entries to lower value hardly have any effect, changing individual Vita to 50 only brings the overall multiplier percentage down from 2100 to 2050 (2100% to 2050%), which is hardly any difference.
In one case, base HP is multiplied by 21, in the other by 20.5.
Edit- I have another question. In the excel file, is it okay to change the "using" part or manually add parent entries? Is it possible to add "custom" parent entries?
As far as I know, yes to all of those.
Yes, anything can be used in the 'using' part, as long as it exists.