Hm, strange. I gave a 1000 vitality boost (instead of -50) to CasualNPC and get about 1700 hp for the training legionnaires in Cyseal (previous 77), so that's quite okay. Anyway, it seems to work for you now.
What Sniper meant, regarding the excel files: they're just there to create .txt files (the engine won't read data from xlsm files), but they're very useful if you aren't familiar with all the different type of data you can edit.
Well, when I save excel file as txt, it shows a very weird format and its very different than the normal character.txt file.