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.
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.
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.