isidro: I've altered the window size. I've moved the Chosen Advances onto a separate tab along with Psychic Powers.

I have clicked the run generator button, but nothing happens...is there anythijg else I need to do?

Still Coming along nicely. Still havent figured out how to add insanity/corruption. Also when I select chaplain, it doesnt automatically add hatred, litanies of hate, or fearless, no prob though as elite advances work just as well.

Question for you tricky, this is obviously taking a lot of time and work, but what about major changes that are optional, like the new weapon damages?

Dam fine work soldier.

shadoestar said:

Did you allow macros?

Thanks a lot!

Trying new version!

Isidro

Hi again!

1. I've downloaded office 2k3 sp3 (from here javascript:void(0);/*1305897741397*/) and by installing it Excell is now version 11.8169.8172 SP3 and VBA v.6.5.1024. There are no Runtime errors, or the bug with WS that I previously reported (though I experienced that the generator sometimes does not run or makes runtime errors, if I have previously ran some personal macros. So I suggest always restarting excel and build your character).
2. At melee attacks' damage the SB (Strength bonus is not added). Tested with Combat Knife and Chainsword.
3. The weapon damages have changed (live update v1.1 found here javascript:void(0);/*1305898547246*/) eg. Bolt Pistol from 2d10+5,pen5,S/3/- has changed to 1d10+9,pen4,S/2/-. I know it is painful to write again all the tables, so would you like me to make the tables and send them to you?
4. Power Armour history. There are three possibilities: (a) Power Armour improves (or gives penalty) to a characteristic. In this case this could be added by player in characteristic sheet manually, or you could include a new table at equipment under the name "armour history", so to be selected and purchased respectively. (b) Power Armour provides a talent. In this case, the only thing I can think is to add a button at advances "buy without XP cost" in order for the player to select it (c) Power Armour provides something special (eg critical damage or initiative). I think we can ignore it for the time being, or put in the wish list to be printed in the gear section. Maybe I'll get a good idea if I make a table with all the histories, not only the generic from core rulebook.

Cheers,

KoRnio

KoRnio said:

1.  
2. This will go onto my to do list. Shouldn't be too difficult.
3. A question has been asked about this. My thought is too place a check box asking which damage rules you want to use and the 1.1 update is considered optional. This, again, shouldn't be too difficult.
4. a)  There is already capability for Characteristic changes from equipment (this was used to add +20 Strength), so should be able to accommodate this; b) should be able to add a free talent easily enough; c) this could be part of the 'Notes' section that I've created on the bottom of page 2

All above are good points/suggestions. I will get to work on these ASAP.

Thanks for the feedback.

New version: v02_20110520

Fixed:

• Insanity and Corruption - use buttons to add either.

New:

• Improved talents: Chem Geld (1 insanity point) and Enhanced Bionic Frame (additional trait)
• Improved Advanced Specialties: Bonus Talents and Wargear.

Also incorporated v1.1 of errata (except for optional weapon stats).

New version: v02_20110521

Fixed:

• Strength bonus added to Melee weapons

First of all, let me say what an outstanding piece of work you are doing on this very ambitious project. I wish I could use Excel half as well as you. Now for the points I noticed while working on creating my Blood Angel Librarian:

• When selecting the Deed "Assault on Baal Veteran" (300 XP) and then selecting the Psy Power "Blood Lance" (1000 XP), the program first deducts 300 XP correctly for the deed, but after that, it deducts only 700 XP for the Blood Lance, making the cost for the 2 advances equal to the starting xp of the Deathwatch character creation. I don't know if this is a problem with the starting character creation xp in general or if it is exclusive to the deeds since they are in a different section of the sheet.
• Force weapons should also add the Psy Rating of the character to damage and penetration.

Apart from that, great work. Thank you very much for this wonderful tool :)

Kilburn said:

Kilburn:

I created a BA Librarian and selected the deed Assault on Baal. This deducted 300 xp (which does not count towards Rank which is why you don't see your XP Spent increase). I then attempted to select Psychic Power Blood Lance and I got the message that I only had 700 xp and the Advance cost 1000 xp and so was not allowed to acquire. If I understand the rules correctly, then this is correct. I assume this is not what happened for you and you was able to acquire the Advance even though you shouldn't have had enough xp.

I will sort out the Force Weapon damage ASAP.

First of all, thank you for your very fast answer!

Uhm... I guess I need to clarify my original post. Since I've been playing that librarian for some time now, I have already spent 19000 xp on him. First I added 6000 xp and then began to spent them on the advances I have already selected by hand. that leads to the situation I described... in that scenario, Blood Lance deducts only 700 xp and in the end after purchasing 6000 xp worth of advances, I still have 300 xp left, which are the cost of the deed.

When I tried the same with only the starting xp, it worked exactly the same way you described, however as soon as I tried various amounts of added xp, the Blood Lance would end up deducting only 700 xp.

Also, thanks for the heads-up, I hadn't read the part where deeds don't add to the xp for your rank calculation.

Edit: OK, read through the deed rules on p. 74 of RoB and my reading is that the rules don't say that points spent on deeds do not count towards rank. The text states that

"Any adjustments made to the charactrer by by selecting a Deed do not count as advancements for the purpose of increasing your Rank (...)"

which, to me, means that the xp spent on the Deeds go toward Rank as normal, but the improvements granted by the Deed in no way do. Everything else would probably make bookkeeping just more complicated.

Thanks again for the good work.

New version: v02_20110522

Fixed:

• Psy Rating now adds to Force Weapons
• Deed costs now count towards to Rank - Kilburn: this should also fix the Advance Cost issue

OK, I finally got around to trying the new version. I noticed a few points:

• When you hit the button "Enter Fate Points", the program does not simply accept the amount of fatepoints entered, but calculates them as if the amount entered was in actuality the d10 roll
• neither the psychic powers selected nor the psy rating are shown on the actual character sheet
• I'm only halfway through Rank 2 and already running out of space for talents. I realize that this is a design flaw in the original FFG character sheet and I don't really have a solution for it since there are so many other things that are also needed on the sheet, but maybe you can come up with an idea to fix this
• The Psy Rating is only added to the damage of the force sword at the moment. It needs to add to Penetration as well. In addition, when I raised the Psy Rating from 3 to 4, nothing changed in the damage section of the force sword. Maybe has to do with the Psy Rating not being displayed on the sheet.

Apart from that, I think the sheet is coming along nicely... just one more question from the guy with only modest excel experience: how can I cut off the top row with the buttons on the actual sheet in order to print only the sheet without printing the buttons? Normally I would just hide the section in excel, but apparently I can't in your sheet.

Really appreciating the amount of work you're sinking into this.