Excel Army List for Tau Army
Version Update: Eal'ta Release 1.25 is out!


Please see below for changes to Eal'ta.

Changes from Release 1.21:

Centurion is already used as the Aurora config
Fixed: Checks with Elite/Troops (some bad references) - Stealth Ui / TL
Fixed: Checks with reducing Unit size when a Teamleader is selected/deselected
Fixed: Minimum size of some Units was not accounted for properly
Fixed: Bad references in Unit combination checks
Fixed: Vespid / Strain Leader combination Unit Size checks were counting incorrectly
Fixed: Kroot +6 save was not coming up in some sections when Shaper was added
Fixed: Shield generator was showing with Sniper Drone Team instead of Stealth Field generator
Added: Checks for Strain Leader / Pathfinder 'Ui without their teams
Added: Minor formatting into phpBB export
Added: Disruption pod to Tetra as mandatory

To-Do list:

Add: Devilfish to Ethereal Bodyguard squad
Add: 2x Seeker Missile option and also 2x Drone options
Add: Reset Button to Army List
Add: Gue'vesa units
Add: Shas'o R'myr
Add: special characters from Codex: Tau Empire

Links
Excel 2003 Version (only tested in that one, unfortunately Open Office can't handle the complex calculations (yet))

http://joeyeti.googlepages.com/Ealta_1.25.zip

Please test and tell me if it is working correctly and if you see any issues!

Joe

One thing that I just realised is that units with EMP and Photon grenades cant select them both at once... will be corrected

Joe

Hm, forty Tau have read this and from the silence I guess they are testing furiously

Joe

Don't take it the wrong way, we appreciate the effort, but there's one of these around already, tau_munkey made one I think. And I have Army Builder. But thanks, i'm sure some of the guys will really like it!

Thanks Joe, appreciate your effort. I am sure some other comments will float in, but yes, we have maybe two of these up already.

For me the Tau list is pretty simple and I can tally up a 1500pt list in my head.

Wait a sec, all army lists are like that...

Of course, I am patient

And WANT any criticism you can get out of your blue heads cause I want to improve it if I can.

Inbetween from the BETA release I corrected the error that Devilfish could not be selected for Pathfinders (and it is compulsory!) and also that Weapons/Equipment fields were not resetting to blanks when user changed the Unit.

Planning to correct also the EMP/Photon Grenade thing (as I somehow overlooked that they can be taken simultaneously).

Joe

Actually after you said that everybody was testing it, I decided to give it a try. I liked it a lot, mostly because I was impressed. I have never seen this sort of Excel document before, so I was drooling over it for a while.

It worked perfectly for me, but since I'm completely new at list-making I can't say that I tested every "feature."

Thanks for taking the time to create something that I can use without needing to open a webpage.

HM

Version Update:

BETA 2 is out!

Changes from BETA:

Pathfinder / Devilfish compulsory choice added
EMP / Photon grenades are now available together
Weapons/Equipment now reset to blank if user changes Unit

To-Do list:

Placing default weapons when particular Unit is selected
Nice output via copying to another sheet for printing

Links
Two versions - Excel 2003 and earlier:

http://joeyetijoe.szm.com/wh40k/Army_Li ... _BETA2.zip

Test and comment pls!

Joe

Fellow Tau,

I am also planning to add standard Crisis Suit configurations to the Unit dropdown lists. The Table would then fill in Weapons and Equipment for them.

What do you say?

If so, then I would need all configs you know listed here with this format (pls )

NAME - xxx
Weapons - 111, 222, 333, ...
Equipment - aaa, bbb, ccc, ddd, ...

Just copy below and fill in pls:

Joe

Its looking good although i havent tried all of it out yet. I personally like it because im quite new to 40K and its a good way for me to see the different settings I can use with my army.

Thanks

Gillper

Can someone please link to the one tau_munkey made.

I have used search and can't seem to find it.

Thanks in advance!

@ HerrRorgor: my site with the army point calculators for every race is www.alice40k.tripod.com

As for Joe's army builder, all I can say is Wow.
My sheet simply adds the point but yours adds the points and associates each unit with it's wargear! And it all looks very good too.
Missing the entry for XV8 team leader if you didn't already know.
When this is finished give me a call as I would like to add this to the extensive resources of my website, and everyone will be notified that it was your brilliant work.

This combined with Godshead calculator makes for some handy tools. This proves once again how talented our members are.

Thanx fellow Tau!

I am happy when you are happy!



Where exactly? He is available as a Leader choice in Elite slot... Does he have to be elswhere yet?

Joe

Version Update:

BETA 3 is out!

Changes from BETA2:

Added +6 save to Kroot (to be selectable only if Shaper is selected as a Leader)
Added default weapons/equipment for units that have them (filled when the Unit is selected)
Added Crisis Suit common configurations (always welcome to new ones, which the Tau folk use...)

To-Do list:

Nice output via copying to another sheet for printing

Links
Excel 2003 Version (until we find out what the problem with MAC users is...)

http://joeyetijoe.szm.com/wh40k/Ealta_BETA3.zip

Test and comment pls!

Joe

Hmm, yeah, the drop down menus aren't working on the Mac. I'll boot up in PC mode in a bit and give it another try

I'd be interested in having the Forgeworld unit entries added as well. Do you have access to a copy of IA3?

Taros campaign... I will have a look...

But I guess they could be added.

Joe

Version Update:

Eal'ta Release 1.0 is out!

With features that are in this Utility now, consider this to be the release version. Minor features may (and probably also will) change in the future, as well as additional data may be added or possible overlooked bugs removed, but 99% of what is in here, is functional as desired on the beginning.

Changes from BETA3:

Added printing feature via a Button - the Print sheet gets populated from the Army List
Fixed erasing also the Number of Units when User changes Unit
Cosmetic changes to look (italics here, bold there...)

Example of Print output:



To-Do list:

Add additional Units from Taros Campaign and possible other sources (subject to Authors own will and persuasive power of other Users )

Links
Excel 2003 Version (until we find out what the problem with MAC users is...)

http://joeyetijoe.szm.com/wh40k/Ealta_1.0.zip

Test and comment pls!

Joe

I get an out of range error when using the Print button. I'm running Excel 2000 in this case.

thanks again for the hard work.

PS: If this is the final release you may want to update the Beta claim in the intro sheet.

It looks good so far and I will post some comments once I get a list together.