An Excel Eldar army calculator

[Gapow]

Hi guys, had a bit (a lot) of spare time at work, so made this quick spread sheet to help quickly work out the points for an Eldar army.

You will still need a codex to plan out your army, then just enter the quantities for units and any extras, then it will work it all out for you.

I\'ve left my example army filled in, so you can see how it works, feel free to ask any questions or leave comments.

It is basic but thought I\'d share it anyway, as I\'ve found it useful
http://www.gapow.co.uk/EldarArmyCalculator.xls

p.s You may notic I appear to have 3 HQ choices, but the Warlock is part of the Guardian squad

 

[Dragonsreach]

Probably a better place for this than an article as here you can get alteration suggestions and easier access to trial.
Good Idea by the way.
I tried something like it using an Access Database worked for me, but not suitable for everyone.

 

[Gapow]

I\'m sure it would look better in Access, I\'ll have to dig my book out as I haven\'t used it since college (about 12yrs ago,lol). I tried doing one for my Marines with drop down lists for HQ1, HQ1, troop1-6 etc, but got stuck assigning values. Think they\'re a bit more awkward as you get free weapons with the 10 man squads

I\'m sure I can make it look a lot prettier in Excel too

 

[evil tendencies]

Cool man! I\'ll show it to my wife. She\'s our local, very experienced, Eldar player and is ace with Excel to boot.

Are there any improvements you\'d like to make but have been stuck on?

 

[Gapow]

Originally posted by evil tendencies
Are there any improvements you\'d like to make but have been stuck on?

TBH I just did it when I was bored at work, but it obviously could do with looking a bit better. I\'m sure someone more experienced on Excel could do something with it. Feel free to do whatever, any improvemnets would be appreciated