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

Automatic FOC organizer/compiler - UPDATED!
Reply
Old 07 Jul 2008, 01:26   #1 (permalink)
Kroot Shaper
 
Join Date: Dec 2007
Location: Canada
Posts: 93
Default Automatic FOC organizer/compiler - UPDATED!

I made a tool in Microsoft Excel for building your own Force Organization Chart. This document allows you to electronically keep track of your Division and updates all the points changes in real time as you add (or take away) units, doctrines, upgrades, and is formatted for easy printing. A very handy tool if you're planning to add more to your army, or are starting a new one and haven't decided on what to get yet!

This version v1.0, contains a handy-dandy tutorial (with no GW Intellectual Property) and some instructions to go with it.

You will need Microsoft Excel 2003 to open this document. Please let me know if you have any problems with it, and happy organizing!


UPDATE
- as of June 08, v2.0 has been released. Check it out! Scroll down to the bottom, this version is now out of date.

UPDATE - August 13th, v2.5 has been released. A new thread has been posted at http://forums.tauonline.org/index.php/topic,87489
__________________
My EZ-FOC Builder Spreadsheet! - Version 2.5 released! Updated August 13th, 2009! Download it now!
Machine Head is offline   Reply With Quote
Old 07 Jul 2008, 03:37   #2 (permalink)
Shas'O
 
Join Date: Jan 2006
Posts: 7,926
Default Re: Automatic FOC organizer/compiler

Pretty slick. Certainly better than my crappy excel sheets. :P
__________________
*Doh!-Nuts DarkWand3r3r Msg Player 04-08-2009 17:51:32
Moral of this story... in real life or in a pen and paper game... do not piss off Delpheus or he will OMGWTFBBQPWN your face with a uber hit.
DELPHEUS is offline   Reply With Quote
Old 07 Jul 2008, 04:31   #3 (permalink)
Shas'Ui
 
Join Date: Jul 2007
Location: Inside Your Head
Posts: 562
Default Re: Automatic FOC organizer/compiler

could do with extra slots for multiple HQ choices, but other than that, this is about the most useful FOC tool anyone's ever come up with. i'm sure this will be a great help to many. great work Machine Head!

==Arn==
__________________
Quote:
I'm the voice inside your head
That you refuse to hear
I'm the face that you have to face
Mirrored in your stare
I'm what's left, I'm what's right
I'm the enemy
I'm the hand that'll take you down,
Bring you to your knees.
Arnorath is offline   Reply With Quote
Old 08 Jul 2008, 03:31   #4 (permalink)
Shas'O
 
Join Date: Feb 2005
Location: Brampton Ont. Canada
Posts: 6,441
Default Re: Automatic FOC organizer/compiler

Had a chance to play around with this today Machine Head. A handy tool for those of us who don't have access to fancy programs like army builder.

Have a cookie
__________________
Quote:
Originally Posted by Mitch: the noob
Is it just me, or does Fish Ead really love to use a Dreadsock?...
I'd hate to get on his bad side... >
Quote:
Originally Posted by Tiwaz
Fishy has just proved to me that Canadians CAN be scary...
Fish Ead is offline   Reply With Quote
Old 08 Jul 2008, 12:47   #5 (permalink)
Kroot Shaper
 
Join Date: Dec 2007
Location: Canada
Posts: 93
Default Re: Automatic FOC organizer/compiler

Thanks guys! And thanks for the Karma point!

Quote:
Originally Posted by Arnorath
could do with extra slots for multiple HQ choices, but other than that, this is about the most useful FOC tool anyone's ever come up with. i'm sure this will be a great help to many. great work Machine Head!
Good idea, I've added some extra slots for more HQ choices in this update. Thanks!

Anything else? Here's v2.0, which is a little more straightforward and easier to use. I added a separate 'Amt.' column so now there is no need to type it in on the other column.
__________________
My EZ-FOC Builder Spreadsheet! - Version 2.5 released! Updated August 13th, 2009! Download it now!
Machine Head is offline   Reply With Quote
Old 09 Jul 2008, 01:12   #6 (permalink)
Shas'Ui
 
Join Date: Jul 2007
Location: Inside Your Head
Posts: 562
Default Re: Automatic FOC organizer/compiler - UPDATED!

nice update. the HQ section is still a little unwieldy for my liking - perhaps you could made the HQ slots in the fashion of the other slots, ie. HQ selection 1, HQ selection 2, HQ selection 3, with a total for each selection and a figure for the total points cost of all the HQ slots combined. that way it would be easier to differentiate one HQ and his upgrades from the others, ie. the librarian and his command squad would have a section of the chart entirely separate from the chaplain with a plasma pistol. also, extra pages for multiple divisions like you had in v1.0 seem to have been left out in this version - maybe you could throw them in, and also have an 'Army total' box which displays the combined points cost of all divisions.

keep up the good work!

==Arn==
__________________
Quote:
I'm the voice inside your head
That you refuse to hear
I'm the face that you have to face
Mirrored in your stare
I'm what's left, I'm what's right
I'm the enemy
I'm the hand that'll take you down,
Bring you to your knees.
Arnorath 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
updated AGAIN? Super heavy gunner Space Marines 1 29 May 2010 17:19
home security systems VS the automatic Clip_II Serious Debate and Discussion 137 20 Jun 2008 15:23
Need a free C compiler GeekyGator Computers, Science and Technology 6 08 Mar 2008 22:32
Updated GW W40K Website - Updated FAQ's mace General 40K 9 29 Aug 2004 14:50