New version available.

Altered the Advances tab to better show what Advances have been chosen.

Feedback appreciated.

Hey Tricky110974 I use Open Officetrying running it but its not doing anything. Do you have it so that it will only work in excel? thanks

Raven1man: I have to admit that I have not tried Open Office, but the sheet uses VBAthere are passwords which may prevent it working.

New version available.

New functions:

• Reset Chapter, Specialty
• Unchoose Advances
• Unchoose equipment

Need to work on getting last few generation elements: Description, Past Event, PA History.

Made some updates. Final elements are now in, although need to build option to choose PA History (can only generate random at the moment).

Need to work on removing Advances to ensure they also remove attribute effects; e.g. Sound Constitution removes Wounds.

If anyone is wondering to how to remove Advances (or Equipment), simply double-click on the list.

 Great additions Tricky!  Glad to see how quickly you're advancing this, very impressive indeed.  Makes Generating a character quickly and....fairly painless.  I can't wait for the RoB stuff to be added :D

Dare I say it... nearing a point where I can call the tool version 0.1!

I believe I have most of the functionality I was aiming for at the start.

To Do:

• Specialty ability choices
• Standard equipment choices (including Storm Wardens option to swap combat knife)
• Chapter Trappings to be added
• Any bug fixes that are needed
• Rites of Battle content to be added

Feedback at this stage would be most appreciated to help in identifying bugs and user-friendliness (or not).

Check out the link in the opening post to grab a copy.
 

Rites of Battle, here I come..!

It has taken a month to get this far. I think that I have all the Core Rules now incorporated (including Elite Advances). The only things that aren't present are Solo/Squad mode abilities. However, I feel I should point out that the intention was to create a nicely printed character sheet, and Solo/Squad modes are on a seperate sheet. That said, the generator does ask for Special Ability choices (from Specialties) and these are not actually on the sheet.

I was wondering whether to add a Misc. tab so that you can enter other details, such as current wounds, insanity, etc. There is also some space left on the bottom of page 2 and this could be used to show Special Abilities and Solo/Squad mode. Happy to hear thoughts.

And so now I'm looking at RoB, and this creates a new To Do list:

• New Chapters (The Imperial Fists, successor chapters)
• Deeds
• Distinctions
• Advanced Specialties
• Expanded Wargear
• Honours
• New Talents and Traits

If anyone has a preference for what they'd like to see first, then speak up. I'm not expecting any major issues implementing the new content, although Advanced Specialties will need some work, just because of amount of information.

The lastest version (v0.1) is called 'DW_Character_Sheet_Generator_v01', and I guess is the first "official" release.

New version available.

I've left version 0.1 on the server and have added version 0.2 (01 April 2011). New version has Rites of Battle chapters. I also fixed what appeared to a bug where Ultramarines were getting a +5 Strength modifier as standard.

This looks exactly like what I am looking for.

Too bad it's completely non-functional in Open Office.   If that could get fixed you'd be my hero.

Killbeggar said:

I am downloading OpenOffice 3.3 and will see if I can sort something. I'm not that hopeful as I think that OpenOffice does not work with Visual Basic for Applications (VBA) and 90% of the Generator is coded using VBA.

Tricky110974 said:

One of my favorite excel character generators was written in VB and somehow it got converted over to Open Office. So I think it's possible with proper appeasement of the machine spirits. But if not thank you anyway.

New version available!

Expanded wargear is now in with the exception of multiple power armour history rolls. Also a couple more bug fixes.

Next up is Advanced Specialties and I am working on a way to enter custom Skill/Talent Groups. This came about with some new groups in RoB and the current need to hard code them in. Thought it would be better if you could pick from a list or create a new one. The list would represent what has been presented in published products, but you could still add your own if you need to.

Have had a look at OpenOffice and there are some serious issues - can't find the forms I've created and the code will need to assessed line by line.

I've added some images to my public folder for those wanting to see what I'm working on without downloading the Excel file.

cid-7bc6fd6adf10c0b1.office.live.com/embedicon.aspx/Public

I'm using the latest version of your Character Generator (20110404) and as I'm going through the character generation process I have seen a few small errors so far.

1.  Under Dark Angels Advances -  It goes directly to Interrogation +20 without listing Interrogation or Interrogation +10.

2.  Under Dark Angels Advances -  Talent: Talented (Pilot (Personal)) should be listed as Talent: Talented (Pilot).

3.  Under Deathwatch Advances -  Skill: Hunter of Aliens should be listed as Talent: Hunter of Aliens.

4.  Under Chosen Advances (because it's given for free to start with) -  Lore: Scolastic (Codex Astartes) should be spelled Scholastic.

5.  Concealment should be a beginning free trained skill (it's currently listed under General Space Marine Advances).

6.  Under movement, the calculator should be adding 1 to the base Agility bonus when calculating movement rates, right now it's just using the base.

7.  I made the same character twice, with the same list of advances, but one got a mysterious +10 advancement bonus to Ballistic Skill (that it should not have gotten) where the other did not.  I'm trying to pin down what caused it, but it's a sneaky bugger.

A couple of more notes for the character creator...

A.  Strength needs a touch-up, right now my strength damage is calculated as double my base, but it should be double +2 because of the armor.

B.  On the front character sheet there is no spot for Ciphers: Chapter Runes (and with this spreadsheet it could say your chapter name there too).

C.  You might try to find a way to incorporate the negatives to Concealment (-40) [-30 Armor Rating of 7+, -10 size] and Silent Move (-30) [Armor Rating] on the front skills list.

D.  Under Elite Advances you missed Lore: Forbidden (Adeptus Astartes) and jumped straight to +10 and +20.

E.  Under Elite Advances you added Lore: Scholastic (Codex Astartes) where it's not needed since it's a free trained skill at creation. [+10 and +20 are still needed obviously]