Very nice, looks like an easy to tool to make army lists when I'm not home and not carrying the books for point costs.
just a tip.
group the rows for HQ's. (function is called group, it's the function where you get a +/- to expand/collapse)
makes you able to not scroll down for heamys or succubus.
group collums and rows in troop,fast and heavy to prevent sideways scrolling
Lock all cells, except the ones you can edit to precent accidental formula overwrite.
than protect the sheet and don't fill in a password (you might want to tell people the password is simple nothing, or make a simpel password)
Things that might be nice to add on the overview page:
since we aren't strong, you might want to prevent deathstars, but prefer to spread the points.
calculated the percentage per section (troop/fast/HQ/heavy) and maybe in the troop section points percentage per squad.
another nice thing for the overview would be number of models and percentage pick anything relevant.
infantry, cavalry,beast,jump,bike,monstrious,vehicle or <= my preference
movement range 6"/12"/2D6/24"/36"
I do not want to sound like an ass complaining about something you put a lot of work. The excell sheet is absolulty briljant and very usefull, I merely want to give my opinion on how to improve it even further
I was working on it my self, right now I have the HQ page formated to expand and collapse, also added the option for the dias. PM me your mail if you want it.