Latest Version Information:

19 March, 2009

Version 11f of the Dark Heresy Character Sheet is now available only one change:

• Corrected cost for Agility in the Assassin Characteristic Advance Table.

Please let me know if you have any problems.

Redeucer said:

Sorry & thanks.

Thanks for a fantastic tool. It is helping me so much in my game prep.

Sorry because I've seen the underlying problem. I think the stats for the Assasin have been mixed up with the Arbitrator. Maybe a copy and paste went astray but I think the Assasins stats are still off... apart from Agility!

Baldrick

Baldrick said:

You're right. Corrected and uploading now.

Latest Version Information:

19 March, 2009

Version 11g of the Dark Heresy Character Sheet is now available with the following change:

• Corrected the rest of the Assassin Characteristics costs

First, let me say that this is a wonderful resource and as a new player to Dark Heresy, I truly appreciate the effort it went into creating this.

In using your spreasheet, I did notice a few errors in some of the formulas.

1. Armor Notes (Character Sheet AB44, AB46, AB48, AB50, AB52, AB54) reference the incorrect column

=IF(L44="","",VLOOKUP(L44,ArmorTable,12)) should be =IF(L44="","",VLOOKUP(L44,ArmorTable,13))

2. Armor Weight (Character Sheet AB44, AB46, AB48, AB50, AB52, AB54) reference the incorrect column

=IF(L44="","",VLOOKUP(L44,ArmorTable,11)) should be =IF(L44="","",VLOOKUP(L44,ArmorTable,14))

3. Weight reduction for weapon upgrades is not calculating correctly

Data2 Weapons Calculation table

=IF($C446="","",IF($C446=$C$411,-$P$444/2,IF($C446=$C$414,$P$444/3,VLOOKUP($C446,AmmoUpgradeTable,14))))

IF($C446=$C$411,-$P$444/2 - If Compact is selected, this calculates a negative number that is half the base weight. I thought the Compact option simply reduced the weapons weight by 0.5 kg?

Also, the absolute reference of $P$444 does not change between weapon tables, so all 13 weapon tables are based on the weight of the first weapon.

Thanks again, and I hope the feedback helps.

this is wonderful and very helpful! Thanks!

Could you also add different background packages? (from IH, for example battlefleet calixis etc)

I don't know if this is a mistake or not, but the Electro Graft Use Talent bumps up Tech Use, Inquiry, and Common Lore skills +10% in the skills list. I think it's only supposed to do that if you're hooked up to a data port.

Sorry for how garbled this is, but I had a problem replying...

evil_bryan wrote:

First, let me say that this is a wonderful resource and as a new player to Dark Heresy, I truly appreciate the effort it went into creating this.
In using your spreasheet, I did notice a few errors in some of the formulas.
1. Armor Notes (Character Sheet AB44, AB46, AB48, AB50, AB52, AB54) reference the incorrect column
=IF(L44="","",VLOOKUP(L44,ArmorTable,12)) should be =IF(L44="","",VLOOKUP(L44,ArmorTable,13))
2. Armor Weight (Character Sheet AB44, AB46, AB48, AB50, AB52, AB54) reference the incorrect column
=IF(L44="","",VLOOKUP(L44,ArmorTable,11)) should be =IF(L44="","",VLOOKUP(L44,ArmorTable,14))
...
Thanks again, and I hope the feedback helps.

Absolutely it helps! I don't always catch everything when I make a change, so it's always nice to have anyone give me feedback and help me find things like this. I have fixed these and will have an update maybe today, but more probably Monday. These are easy fixes and you absolutely diagnosed them correctly. I changed the table layout and forgot to go back and check these. Thanks for catching this!

evil_bryan wrote:

3. Weight reduction for weapon upgrades is not calculating correctly
Data2 Weapons Calculation table
=IF($C446="","",IF($C446=$C$411,-$P$444/2,IF($C446=$C$414,$P$444/3,VLOOKUP($C446,AmmoUpgradeTable,14))))
IF($C446=$C$411,-$P$444/2 - If Compact is selected, this calculates a negative number that is half the base weight. I thought the Compact option simply reduced the weapons weight by 0.5 kg?
Also, the absolute reference of $P$444 does not change between weapon tables, so all 13 weapon tables are based on the weight of the first weapon.

Actually, according to the rules:

This upgrade halves the weight of the weapon but also halves its clip size and range as well as reducing its Damage by 1

So that is correct, but I noticed that I didn't half the range like it says. So that will be corrected in the next version as well. Don't know how I missed that one. I also fixed the absolute reference cell. Looks like I took old code for that. I thought I had that fixed a couple revs ago. Oh well. Fixed now. If you know what you are doing in Excel (which you seem to) and you want to fix it before I get the update out, you can do it yourself. Just highlight each block of five (e.g. P456...P460) and do a "replace all" with 10 more than the previous block (so for example replace $444 with $454 for weapon 2, $464 for weapon 3, $474 for weapon 4, etc.). Otherwise, I'll have the fix out in the next rev.

Skie Wrote:

this is wonderful and very helpful! Thanks!
Could you also add different background packages? (from IH, for example battlefleet calixis etc)

The problem with the background packages in IH is that it changes the starting packages. So if you want to take them, you just need to use the drop downs to select the Traits, Talents, etc., that come with that package. They will overwrite the ones that are generated by default depending on what you started with. I haven't found an easy way to do this that is supported by both Excel and Open Office so it is what I had to resort to. All you need to do is use the drop down to select the ones that go for that background and the originals will be overwritten. All the Traits, Talents, etc. from IH are in there (I think...). If I missed any let me know. I haven't given up finding a good way to fix this that will work in both Excel and Open Office.

bogi_khaosa wrote:
I don't know if this is a mistake or not, but the Electro Graft Use Talent bumps up Tech Use, Inquiry, and Common Lore skills +10% in the skills list. I think it's only supposed to do that if you're hooked up to a data port.

Yes. I currently have that auto-calculated to add the bonus in. That's why on the Data1 page it is highlighted green, and you will note that when you select the Talent, the note in it says:

"+10 bonus to Inquiry, Tech Use, Common Lore (calc) ."
[bolding and underlining my addition]

I debated on how to handle this and probably wasn't as consistent on this as I should be. I tried to only calculate the ones that happened consistently, but didn't always. This one may not happen all the time so I probably shouldn't have done the auto-calculation on it. I'll take it out in the next version.
Hmm.... Maybe I should add a calculate selection by these so it can be turned on/off. I may take a look at that. Thanks for a great idea!

Latest Version Information:

31 March, 2009

Version 11h of the Dark Heresy Character Sheet is now available with the following changes:

• Fixed Armor Notes and Weight calculations on the character sheet
• Fixed weapon weight calculation
• Removed automatic calculation of Electro Graft Use
  

28/4/2009

Version 11k of the Dark Heresy Character Sheet is now available HERE . The following features are added in this version:

• Added 3.0 Errata

The main changes here are to the weapons and the calculations for the Targeter weapon upgrade. I think I caught everything in the 3.0 Errata, if I missed something, please let me know.