Page 1 of 5 1 2 3 ... LastLast
Results 1 to 20 of 87

Thread: Imperial Guard Army List Calculator (Excel Sheet)

  1. #1
    Commander b4z's Avatar
    Join Date
    Jun 2007
    Location
    London, UK
    Posts
    605

    Imperial Guard Army List Calculator (Excel Sheet)

    ZIP PASSWORD: b4z

    Using the new Imperial Guard Codex I have created an entirely comprehensive Excel Sheet system and I have taken an absolute AGE to produce this.. well over 100 hours, so please try it out.

    Each entry has formulas to accept the below inputs and will calculate the individual/upgrade cost, the overall unit cost, and the overall squad/squadron cost and the total army cost.

    The two Basic Instructions are as follows;

    only edit values in
    Column A - (either 0 or 1) - for taking or not taking units.
    and
    Column G - (either 0 or 1 [or more depending on the possible number of the same upgade] - for taking upgrades.

    It should be pretty Intuitive.

    Take a look at the screenshots, then download it and have a go.

    Tell me what you guys think about it.

    Thanks,

    b4z
    Last edited by b4z; 16-06-2009 at 20:22.

  2. #2
    Marine
    Join Date
    May 2008
    Location
    Blackbird, Delaware
    Posts
    21

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Very interesting, just got done looking over most of it.



    There's only one typo that I found, its on the third page where you're comparing new point costs with the old. You had multi-melta when I'm sure you meant meltagun.

  3. #3
    Librarian Eldorad's Avatar
    Join Date
    May 2008
    Location
    Birmingham, UK
    Posts
    315

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    That is very nice and useful. You obviously worked hard on it!
    Last edited by Eldorad; 11-08-2009 at 15:53. Reason: Obviously is allowed!

  4. #4
    Chapter Master Zanzibarthefirst's Avatar
    Join Date
    Dec 2006
    Location
    Gateshead, UK
    Posts
    2,611

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    That certainly is impressive though I think I'll stick with using the book once its out, seems like it'll be a bit easier. Excellent effort none the less

  5. #5

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Very Impressive and I can definitely see some utility!

    Only issue I can see is: since free upgrades are well, free, there's no way to indicate what they are in the sheet.

  6. #6
    Chaplain
    Join Date
    Jul 2007
    Location
    London
    Posts
    208

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Looks awesome. Thanks. Careful w/t IP infringement though!

  7. #7
    Chapter Master SPYDER68's Avatar
    Join Date
    Jul 2005
    Location
    Missouri
    Posts
    4,201

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    I doubt he will get introuble for point costs due to Armybuilder does the same thing :P

  8. #8

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    nice... i just built my army using it

  9. #9
    Chapter Master Alessander's Avatar
    Join Date
    Jul 2005
    Location
    USA
    Posts
    1,610

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    dear god, 3380 rows? even with a lot of duplication, that's impressive.
    You know that you've been spending too much money on GW products when the number in "Warhammer 40,000" refers to the points total for one of your armies…

    Alessander's Laser-cut Eldar Terrain thread - http://www.warseer.com/forums/showthread.php?t=210451

    Laser-Cut Terrain and Game counters at http://www.silvercompassdesigns.com

  10. #10
    Chaplain
    Join Date
    Mar 2005
    Location
    Australia, SA
    Posts
    169

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    thank you, this will be very usefull

  11. #11
    Commander
    Join Date
    Sep 2007
    Location
    maryland
    Posts
    821

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Thank you! I have Army Builder, but until they update the Guard Codex, this will be very useful!

  12. #12
    Chapter Master cleansingfury's Avatar
    Join Date
    May 2007
    Location
    vancouver
    Posts
    1,217

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    First off, OH MY GOD I LOVE YOU!
    Got my new codex and it is great and all... but this... is god like!
    The time you put into this is greatly appreaciated by everyone!
    Quote Originally Posted by rmthedude View Post
    If Necrons come out next year I will eat my lord's hat!

  13. #13
    Commander onnotangu's Avatar
    Join Date
    Apr 2005
    Location
    Detroit, MI
    Posts
    724

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    thanks for this. it will making figuring out a list from the current slew of models easy.
    "Your tongues can't repel flavor of that magnitude!"

  14. #14
    Chaplain
    Join Date
    Jan 2009
    Location
    West Yorkshire
    Posts
    162

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    I think it would work a little better if you had different FOC slots on different sheets, since it is a HUGE! excel chart. Also, no special characters does make me a little sad..

  15. #15
    Librarian hereticdave's Avatar
    Join Date
    Jun 2006
    Location
    Calgary, AB, Canada
    Posts
    301

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Awesome sheet - my only suggestion would be to alter the way column I works. Right now we refer to H and reinsert that same value into I to take it. Why not have I as a 1/0 column to save retyping it every time?

    That way wherever the total is you could do a sum like the following:

    =sum(50+(I12*H12)+(I13*H13)....etc)

  16. #16
    Chapter Master cleansingfury's Avatar
    Join Date
    May 2007
    Location
    vancouver
    Posts
    1,217

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Quote Originally Posted by Bekenel View Post
    I think it would work a little better if you had different FOC slots on different sheets, since it is a HUGE! excel chart. Also, no special characters does make me a little sad..
    This is my only problem with the sheet... I am not gonna print 48 pages when ever I want to use my list... gonna experiment to see if removing columns jacks up the list but keeping a backup...

    Again, you rock!

    EDIT: Removing rows does not work... it causes a #### to appear in both the FOC slot cost and the total cost... so guess I am just gonna have to copy and paste into a different sheet to get the list. No big loss!
    Last edited by cleansingfury; 30-04-2009 at 14:45. Reason: update
    Quote Originally Posted by rmthedude View Post
    If Necrons come out next year I will eat my lord's hat!

  17. #17
    Commander noobzilla's Avatar
    Join Date
    Dec 2008
    Location
    Milwaukee, WI
    Posts
    677

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Absolutely awesome to toy around with my list prior to actually getting the New 'dex. Now I know exactly how much my squads cost. Thanks a lot!
    Quote Originally Posted by Cognitave View Post
    Dear GW,
    Paper is overpowered. Scissors is fine.

    Signed,
    Rock.
    Check out my band Brotherhood Sidekicks on Soundcloud!

  18. #18
    Chapter Master cleansingfury's Avatar
    Join Date
    May 2007
    Location
    vancouver
    Posts
    1,217

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Hope you get that glitch fixed soon!
    You have inspired me to do this with all of my codexs that I own... seeing as you did one for my new guard codex that is one down! You are a genius and a merit to the wargamer type!
    Quote Originally Posted by rmthedude View Post
    If Necrons come out next year I will eat my lord's hat!

  19. #19
    Chapter Master RCgothic's Avatar
    Join Date
    Jan 2008
    Posts
    3,298

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    The only other thing I can think of to improve the sheet is if it told you if you made an illegal selection, such as five special weapons when you only have 4 guardsmen in a squad. I appreciate how much work that would be however.
    RC'S IMPERIAL LOG
    Legio Astorum, Ultrahawks Chapter and the Cadian 957th Brigade

    MOST RECENT PROJECT: Repurposing a squad of 4th ed HQ Veteran Marines
    WANTED: Attack Bike or Landspeeder Multimeltas. Please pm.

  20. #20
    Commander noobzilla's Avatar
    Join Date
    Dec 2008
    Location
    Milwaukee, WI
    Posts
    677

    Re: Imperial Guard Army List Calculator (Excel Sheet)

    Question, under the Platoon Commander's options, it lists a "Power Pistol" Do you mean Plasma Pistol?
    Quote Originally Posted by Cognitave View Post
    Dear GW,
    Paper is overpowered. Scissors is fine.

    Signed,
    Rock.
    Check out my band Brotherhood Sidekicks on Soundcloud!

Page 1 of 5 1 2 3 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •