Tau Empire Codex 2013 | Army Builder Program
Dark Angels Codex 2013
Chaos Daemons Codex 2013
Chaos Space Marines Codex 2012

Warhammer 40k Forum Tau Online

 

Warhammer 40K Forum

Excel Army List for TAU Army - (WIP)
Reply
Old 03 Apr 2007, 08:51   #1 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Excel Army List for TAU Army - (WIP)

I am currently working on a customizable Excel Sheet Army List.


Version Update:
2008/03/18

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, unofrtunately Open Office can't handle the complex calculations (yet))
Please test and tell me if it is working correctly and if you see any issues!

Joe
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 03 Apr 2007, 09:19   #2 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Re: Excel Army List for TAU Army - (WIP)

First advice I need:
is the following list correct as to what the XV8 'Ui and XV8 'Ui TeamLeader can take as per Codex?

XV8 Shas'ui
Blacksun filter
Burst cannon
Drone controler
Flamer
Fusion blaster
Missile pod
Multi-tracker
Plasma rifle
Shield generator
Target lock
Targeting array
TL Burst cannon
TL Flamer
TL Fusion blaster
TL Missile pod
TL Plasma rifle

XV8 Shas'ui TL
Blacksun filter
Bonding knife
Burst cannon
Drone controler
Flamer
Fusion blaster
Gun Drone
HW BS filter
HW Drone contr.
HW Multi-tracker
HW Target lock
Marker Drone
Missile pod
Multi-tracker
Plasma rifle
Shield Drone
Shield generator
Target lock
Targeting array
TL Burst cannon
TL Flamer
TL Fusion blaster
TL Missile pod
TL Plasma rifle
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 03 Apr 2007, 13:12   #3 (permalink)
Shas'La
 
Join Date: Sep 2006
Location: Wah-Shing-Ton
Posts: 281
Default Re: Excel Army List for TAU Army - (WIP)

What about the special weapoins and kit like the CIB, AFP, IA and so on? Shouldn't they be on your list?

Oh and it is Controller. Two Ls.
__________________
Show me on the hobbit where the bad man touched you.
Kugelblitz is offline   Reply With Quote
Old 03 Apr 2007, 13:19   #4 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Re: Excel Army List for TAU Army - (WIP)

Quote:
Originally Posted by Kugelblitz
What about the special weapoins and kit like the CIB, AFP, IA and so on? Shouldn't they be on your list?

Oh and it is Controller. Two Ls.
1. CIB, AFP and IA are all Special Issue, thus for Shas'vre, if I am not mistaken...
2. The other part I dont understand, sorry... Could you rephrase plz?
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 04 Apr 2007, 02:06   #5 (permalink)
Shas'Ui
 
Join Date: Feb 2007
Location: Lynnwood
Posts: 819
Send a message via MSN to Damian_Alpha
Default Re: Excel Army List for TAU Army - (WIP)

He was correcting your spelling of Controller (you spelled it with one 'l&#39.

My suggestions:
Figure out a way to link each drop-down option with a value for how many hard-points it uses, as the suit can only ever fill three of these points. Wargear and hard-wired systems as zero, normal weapons and support systems as one, and twin-linked weapons as two. As well, make sure that they don't have the option to take hard-wired versions of hard-point mounted systems. Better yet, if you can set up a background diagram, and have three menus to represent each of the hard points and then just a series of check-boxes for wargear, that might be pretty sweet.
__________________
"I have exactly one-hundred men under my command counting on ME to lead that charge, you two-bit mechanic. I have five seige tanks, eight APC's, an artillery platform and a light mech that need resupply and repair by dusk. I need remote mines set, trenches dug, and my men fed and rested, or those Marines are going to be using us for toothpicks. Get it done, Fio'vre." Officer Sherwin Jackson, 13th Dal'yth Company, to Fio'vre D'nan

"Feed well, my Bretheren. You are what you eat, and we have devoured the mighty." Master Shaper Korl Muur
Damian_Alpha is offline   Reply With Quote
Old 04 Apr 2007, 07:47   #6 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Re: Excel Army List for TAU Army - (WIP)

Thx Damian_Alpha (and Kugelblitz) for the Typo, will correct it! 8)

Damian, nice ideas, namely the thing with 3 hardpoint entries... That is not hard to do... Means some more tables, but not that much work anyway.

About the HW - nonHW systems check, I will have to figure it out how to implement, I hope some If()'s will solve it. If not, I shall come back to you all asking for help 8)

Joe
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 05 Apr 2007, 21:33   #7 (permalink)
Shas'La
 
Join Date: Nov 2005
Location: U.S.
Posts: 287
Default Re: Excel Army List for TAU Army - (WIP)

Hey, sorry if this a stupid question but.... is there a way I can get this to without making it myself?
__________________
Imagine some Space Marines rapping this, to the tune of Riding Dirty:

They see him rolling,
They hating,
Patroling and trying to fix him with a dark lance,
Trying to fix him with with a dark lance
Trying to fix him with with a dark lance
Fix him with a dark lance,
Try to fix him with a dark lance.

(rap)
Rolling up 'cos I'm a Space Marine,
Heavy armour so it ain't hard to be seen, I ride, ride and they see me lean, Soritas and a TV screen, Yeah the Canoness, she likes cola, Mixed in a stolen drone controller, But then I just try to hold her, One smack and great, I'm in a coma
shashui tarik is offline   Reply With Quote
Old 05 Apr 2007, 22:21   #8 (permalink)
Shas'Saal
 
Join Date: Mar 2007
Posts: 176
Default Re: Excel Army List for TAU Army - (WIP)

Quote:
Originally Posted by shashui tarik
Hey, sorry if this a stupid question but.... is there a way I can get this to without making it myself?
Not at all a stupid question Tarik, but you need to wait a little yet... heavily work in progress! 8)

BTW, anyone know how to make dynamically changing lists in Excel? Meaning if I select a system from a list then the list would shrink so that I cant select that system again?
In my worksheet I have the weapons grouped in Named Ranges which in turn I use for drop-down Lists at the Units.
Thx for advice!

Joe
__________________
Tau army builders - click here: Eal'ta - Excel Army List for Tau Army
Joeyeti is offline   Reply With Quote
Old 05 Apr 2007, 22:53   #9 (permalink)
Shas'O
 
Join Date: Jun 2006
Posts: 6,130
Default Re: Excel Army List for TAU Army - (WIP)

Only way I know of to do that involves using macros...kinda annoying, since its anything but a flexible system. Very VB like.
__________________
Latest Project: Game Design Forums. Register now to get a low user ID, or reserve a forum for your own project.

My various opinions and tacticas, in article form: Ad clicks always appreciated.

Latest article topic: Video game design

Best free webhost Ive found yet: http://www.ultrawebsitehosting.com/2353.html
Tyndmyr is offline   Reply With Quote
Old 06 Apr 2007, 01:46   #10 (permalink)
Shas'O
 
Join Date: Aug 2006
Posts: 9,460
Default Re: Excel Army List for TAU Army - (WIP)

Sounds aweosme.

Yes, GW will hate it.

No, they won't do anything about it.

Ever heard of "The Forge"? They have Stats, special rules, and points for every army out there. Noone goes after them. They've been around since like '01.
GeekyGator is offline   Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting a necron army - 1000 point army and patrol list Devust Necron Army Lists 2 16 Sep 2008 02:50
Chaos apocalypse army 2: current army list and how additions will affect it mamba21500 Chaos Army Lists 5 06 Jun 2008 06:58
Khorne Army: Conversions/army list/deamon codex predictions Death-Merchant Forces of Chaos 16 10 Jan 2008 11:47
I was playing with army builder and made a space marine army list chicop76 Space Marines 10 14 Feb 2006 16:52
Army List Theme Idea-suggestions on army list SMRCommander Forces of Chaos 18 31 Dec 2005 22:37