Librarium Online Forums banner

Chaos Excel Spreadsheet

17K views 83 replies 36 participants last post by  Rabbit 
#1 · (Edited by Moderator)
:::MOST RECENT VERSION BELOW:::
http://peecee.dk/upload/view/180899

After seeing the power of Excel in a thread found in the Necron subforum (linkage - http://www.librarium-online.com/forums/showthread.php?t=101424), I decided to follow Moozie's lead and take a stab at creating a quick and dirty army creation utility for the new Chaos Codex.

This is not a project to create an army builder replacement. It is simply a fun way for me to teach myself the lesser known abilities of Excel. That being said, I'm quite proud of what it looks like so far.

I've only done part of the HQ section at the moment. You can only build a single HQ choice, and special characters are not included, but it does include smart math and error correcting. Looking at the HQ section, you can sort of see what I have planned for the rest of the Workbook.

You will need Excel or OpenOffice to read it. I promise you that it is not a virus, no matter what your firewall or anti-virus might tell you. :))


Edit -
Most current link to file:
http://www.dynamicpics.com/New_Chaos_Worksheet.xls
 
See less See more
#4 ·
:geek: Ebert and Roeper give this 2 Thumbs Up! :geek:

Awesome work!
 
#5 ·
Latest incarnation of the Workbook. HQ is completely done, with support for 2 choices (1 being mandatory), including Special Characters. Elites are also finished, though due to a ton of options for Chosen, you might have to scroll down to spot the Dreadnought entry. Oh well, nobody takes them anyways. :p

Troops are WIP. Troops #1 works perfectly as far as I can tell, with support for all five choices and even Enhanced Warriors on the Chaos Marines. Next step is to allow up to six Troops options (two mandatory), and then work on Fast Attack and finally Heavy Support.


(Link broken, see post #11)

Once again - I promise that it is not a virus. :)
 
#11 · (Edited)
onodera said:
I bet one couldn't do this with our old Codex. Oh, version 3.5, I miss your complexity so much...
No chance. The armoury would have screwed it all up.

Thanks to Onlainari, I've been able to acquire a few new tricks that saved me tons of time. Because of that, well, I'm finished!

RapidShare: 1-Click Webhosting

Includes support for Special Characters, daemons, and gives you percentage ratings and model count figures. Please pay special attention to the first note in the 'Overall' tab - it's very important.

I think the next step will be to fix the Workbook so that cells don't vanish and reappear based on your selection - instead, the cells will just conform to whatever options you selected. In other words, I aim to remove the scrolling down in order to find the options for the unit that you selected. That's a bit more advanced than I intended when I started this project, so might take me awhile to figure out.

But for now, everyone enjoy! Please be sure to speak up if you spot an error, like I forgot to unlock a cell somewhere, or the math fudges up in places.
 
#13 · (Edited)
Damn... that was fast. However, you cannot change the total point cost on the overall sheet.

Also the % total uses the points remaining # instead of the total army size.

Cannot change lesser daemon # in troop choices.

Pair of lightning claws option for termies does not add pt. cost.

( I'll keep bug testing til I need to work )
 
#14 ·
Also the % total uses the points remaining # instead of the total army size.

Pair of lightning claws option for termies does not add pt. cost.
Fixed these two issues.

However, you cannot change the total point cost on the overall sheet.

Cannot change lesser daemon # in troop choices.
Was not able to replicate these two issues. Those particular input boxes (As well as the Chaos Spawn) aren't drop down lists like the rest - they require user input, and worked fine in my version. Not sure why it won't work in yours.

I've updated the link found in Post #11 with the corrected version. Thanks for the bug feedback, keep it coming. :)
 
#15 ·
Just downloaded it. I took the program for a spin and so far, it looks to be performing just fine. I did, however, notice that on the daemon prince and sorcerer, you do not have to have the cult-specific mark in order to take the cult-specific psi power. In other words, a non-marked prince can take cult-specific psi powers. Just thought I'd bring this up.

Great work. I'll be using it from now on.
 
#16 ·
Just downloaded it. I took the program for a spin and so far, it looks to be performing just fine. I did, however, notice that on the daemon prince and sorcerer, you do not have to have the cult-specific mark in order to take the cult-specific psi power. In other words, a non-marked prince can take cult-specific psi powers. Just thought I'd bring this up.
That is true, due to the way that I created the drop down lists. I'm sure there's a better way of making the lists populate dependent upon a different cell's value, but that's beyond me at the moment.

However, by taking a cult power without the appropriate mark, you should set off the Error check at the bottom of the HQ Worksheet.

Edit -
Found another mistake. Special Characters won't work in HQ Slot #1. Fixed and re-updated the link in Post #11 (sorry about that, those who've already DL'd it multiple times!)
 
#19 · (Edited)
Gah... with excel 2007 I'm having problems where options won't pop up or won't go away once I choose to discard a unit. This is however cured by highlighting the affected area. ( This may be a lag issue since it is also fixed if you switch back and forth between sheets )

HQ 2) The second psychic ability granted by a mark of tzeentch on a daemon prince isn't working. None of the 2nd abilities chosen add to the point cost.
 
#23 ·
Hey Cal... Great work on this! It makes things much easier for us chaos-aholics.

The one thing I noticed is that there is something wrong with the math for terminators.

I entered a squad of 5 termis w/ MoK, 1x Chain fist, 1x RAC

It is supposed to be 220 pts but the sheet said it was 240 pts.

Thanks again for taking this on! :happy:
 
#25 ·
The one thing I noticed is that there is something wrong with the math for terminators.
The Chainfist is incorrectly reporting a cost of +10 points than what it should be. Your unit should cost 230.

Thanks for the bugs everyone. Instead of just updating it every time someone reports a new one, I'll be saving them all up and uploading a fixed version on Friday.
 
#27 ·
All reported issues have been fixed, along with a couple that I found on my own. Thanks to all of the 'Beta testers' so far, and if you still happen to find errors, please let me know.

Newest version of the Workbook can be found in post #1, for everyone's convenience.
 
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top