Switch Theme:

Grey Knight Excel Spread sheet Army Creation tool  [RSS] Share on facebook Share on Twitter Submit to Reddit
»
Author Message
Advert


Forum adverts like this one are shown to any user who is not logged in. Join us by filling out a tiny 3 field form and you will get your own, free, dakka user account which gives a good range of benefits to you:
  • No adverts like this in the forums anymore.
  • Times and dates in your local timezone.
  • Full tracking of what you have read so you can skip to your first unread post, easily see what has changed since you last logged in, and easily see what is new at a glance.
  • Email notifications for threads you want to watch closely.
  • Being a part of the oldest wargaming community on the net.
If you are already a member then feel free to login now.




Made in us
Ultramarine Land Raider Pilot on Cruise Control






Plano, Texas

Hey Dakkaites!

I'm just letting y'all know about the army creation tool that I just made using excel. It's rather basic but it gets the job done until the GW embargo is lifted in 2 months for army builder.

Hope y'all enjoy!
 Filename GK 2.xls [Disk] Download
 Description Excel army creation spreasheet
 File size 42 Kbytes


DR:80+S+++G+++M+++B++++I+Papoc97#+D++A+++/areWD190R++++T(m)DM+++

Ultramarines army Profile

Inquisition army profile

My Titan PLOG

My Imperial PLOG


 
   
Made in ca
Sure Space Wolves Land Raider Pilot





Montreal

What about battlescribe? Though their lists are buggy (5 Wolf Scouts can only bring -5 CCW and Range weapons?) I would assume they don't care about embargos. Though I've gotten use to a good old calculator and some paper.

Also your list is awesome but could use some labeling. As a programmer I've learnt that comments are king!

500

DA:90-SG-M--B--I+Pw49k10#----D+A--/fWD371R----T(S)DM+ 
   
Made in ca
Renegade Inquisitor with a Bound Daemon





Tied and gagged in the back of your car

Looks pretty cool, but you might want to set all the unit and upgrade quantities to zero before you upload it.
   
Made in us
Ultramarine Land Raider Pilot on Cruise Control






Plano, Texas

Fafnir - Thanks. I left those in as an example on how to use it.

Portaljacker - I use army builder and that is because it is compiled by multiple people which allows for a minimal amount of error. If an error is found it is easily reported and changed in the next update. This is just a stop gap for those who can't wait another 2 months after waiting nearly 10 years already.

DR:80+S+++G+++M+++B++++I+Papoc97#+D++A+++/areWD190R++++T(m)DM+++

Ultramarines army Profile

Inquisition army profile

My Titan PLOG

My Imperial PLOG


 
   
Made in ca
Sure Space Wolves Land Raider Pilot





Montreal

True, I'm just nit are if paying for Army builder is worth it. What's their situation with GW? How are they allowed to exist? What are some real benefits tO using their program?

500

DA:90-SG-M--B--I+Pw49k10#----D+A--/fWD371R----T(S)DM+ 
   
Made in us
Stone Bonkers Fabricator General






A garden grove on Citadel Station

Portaljacker wrote:True, I'm just nit are if paying for Army builder is worth it. What's their situation with GW? How are they allowed to exist? What are some real benefits tO using their program?
They do not release 40k files officially, but rather the fans do. This lets them steer clear of trouble.

ph34r's Forgeworld Phobos blog, current WIP: Iron Warriors and Skaven Tau
+From Iron Cometh Strength+ +From Strength Cometh Will+ +From Will Cometh Faith+ +From Faith Cometh Honor+ +From Honor Cometh Iron+
The Polito form is dead, insect. Are you afraid? What is it you fear? The end of your trivial existence?
When the history of my glory is written, your species shall only be a footnote to my magnificence.
 
   
Made in au
Devestating Grey Knight Dreadknight





I wouldn't be happy to not anti link people to a place where they can't get the codex online if they dont politely pm me.


Automatically Appended Next Post:
(Dont worry guys, I have every intention of buying the real thing, How else do I look legit when I walk into gw to play a game with someone?)

This message was edited 1 time. Last update was at 2011/03/20 11:00:19


 
   
Made in us
Ultramarine Land Raider Pilot on Cruise Control






Plano, Texas

ph34r wrote:
Portaljacker wrote:True, I'm just nit are if paying for Army builder is worth it. What's their situation with GW? How are they allowed to exist? What are some real benefits tO using their program?
They do not release 40k files officially, but rather the fans do. This lets them steer clear of trouble.

They also have to wait 1 month after the codex's official release date.
The benefit is it's so widely used that most tournaments accept an army builder print off as proof that your list is correct.

DR:80+S+++G+++M+++B++++I+Papoc97#+D++A+++/areWD190R++++T(m)DM+++

Ultramarines army Profile

Inquisition army profile

My Titan PLOG

My Imperial PLOG


 
   
Made in ca
Sure Space Wolves Land Raider Pilot





Montreal

Ah, ya, battlescribe is screwy, it was missing options for stuff in DE even though it had been updated for the new codex, as well as that issue with SW that I had.

500

DA:90-SG-M--B--I+Pw49k10#----D+A--/fWD371R----T(S)DM+ 
   
Made in gb
Guard Heavy Weapon Crewman





BattleScribe does still have some bugs lurking in there, but is generally pretty good now (the "-5 selections from" issue is still there, but I've got it on my list for the next release). If you do find a bug, or want to ask for a new feature, please let me know over at http://battlescribe.uservoice.com. Often however, a lot of problems such as incorrect points values, selection limits and error messages are down to the data files being wrong.

The data files over at http://knowledgeforge.net/bsdata/ are also fan submitted for the same reasons as ArmyBuilder. If you find a problem with one, it's usually a quick fix - the data file editors come with BattleScribe. You can let us know about problems, or post fixed data files in the issue tracker here: http://www.battlescribe.net/forum/tracker.php?p=3

Any help with data files is always appreciated!

++ Jonskichov ++
+ Developer of BattleScribe +

++ Contact ++
+ Twitter | Facebook | Google+
   
Made in gb
Sneaky Sniper Drone






Kent, UK, Terra, The Milky Way

how do you use this? i've downloaded it but i'am quite confused. can someone help? thx

Tau mate 
   
Made in us
Ultramarine Land Raider Pilot on Cruise Control






Plano, Texas

Just follow the example included in the sheet.
If you want a librarian put a 1 below his points cost, if you want 2 powers put a 2 below their points cost.

It does not error check or explain what every thing does so you have to do that on your own.

DR:80+S+++G+++M+++B++++I+Papoc97#+D++A+++/areWD190R++++T(m)DM+++

Ultramarines army Profile

Inquisition army profile

My Titan PLOG

My Imperial PLOG


 
   
Made in gb
Sneaky Sniper Drone






Kent, UK, Terra, The Milky Way

Thanks I found my list is 615 points. Thx

Tau mate 
   
Made in us
Lone Wolf Sentinel Pilot






Philadelphia

A couple things foda:

-Try underlining and bolding all the actual text in the spreadsheet. I makes it a lot easier to distinguish from the numbers.

-This sheet can only accommodate squads equipped identically. For instance, if you want one tac squad with an incinerator and another with a Psilencer, there is no way of distinguishing the two. You can put in for both upgrades, but then it looks like you have one super squad.

I don't expect this to be perfect (really no ones is), but it is a very good home grown sheet.

 
   
Made in us
Been Around the Block




Thank You very Much!

Jumping between adobe and a calculator is annoying sometimes
   
Made in gb
Daemonic Dreadnought





Derby, UK.

Didn't know they were online, never occured to me to look!


I've made excell spreaddies for my necron lists. I'll fire up a blank one and upload it if anyone's interested.

Armies:

(Iron Warriors) .......Gallery: Iron Warriors Gallery
.......Gallery: Necron Gallery - Army Sold
.......Gallery: Crimson Fists Gallery - Army Sold

Iron Warriors (8000 points-ish)

 
   
Made in us
Ambitious Acothyst With Agonizer





Murfreesboro, TN

PraetorDave wrote:A couple things foda:

-Try underlining and bolding all the actual text in the spreadsheet. I makes it a lot easier to distinguish from the numbers.

-This sheet can only accommodate squads equipped identically. For instance, if you want one tac squad with an incinerator and another with a Psilencer, there is no way of distinguishing the two. You can put in for both upgrades, but then it looks like you have one super squad.

I don't expect this to be perfect (really no ones is), but it is a very good home grown sheet.


All you have to do is copy and paste the squad you want to make different below the rest of the sections, make the changes you want, and the calculations are done.

And Foda, thank you for making this!

This message was edited 3 times. Last update was at 2011/03/24 14:57:04


I'm currently taking commissions.
Phil's Minis.
Contact me at my site.
Phil's Minis
Use coupon code NWSTRT5 for 5% off EVERYTHING! 
   
 
Forum Index » 40K General Discussion
Go to: