Version 5 is finally ready for release - thanks for your patience and special thanks to those who offered to help with the testing and future data entry.

The new release is fully backwards compatible with your saved characters (.rtc files), however in almost every other way it is a complete rewrite in order to support Ascension, Inquisitors Handbook and Into the Storm.

The new sheet will be easy to extend as and when new material is released, it has been thoroughly tested, however I suspect that as people use it more in anger, bugs will be found. Please feel free to email me any issues, or post questions on this forum.

I hope the sheet continues to help your enjoyment of roleplaying in the 40K universe.

Version 5 doesn't work for me. I can't choose a profession or anything (homeworld...). The drop-down choices are all error messages (#Bezug -> #reference) - I am using a german version of Excel 2007 (in compatibility mode). The older versions (4.1 - 4.71) worked without a problem. Did you change something in how you used references? Or is it a language problem?

I hope this can be fixed - I really like your sheet and would like to use the "Into the Storm" stuff.

 Joerg

Sorry to hear there are problems. I suspect this will be a problem with Language compatibility as it seems to be working fine for other users.
All the down menus are calculated in the hidden sheet called "Menus".

I don't know how good your Excel skills are. If you could unhide the Menus sheet (Right click on a sheet tab and unhide)  and have a look at the far right hand columns where the menus are calculated it would be really useful to know what you find.

The other place to look is on the Character Generation sheet itself. There are some hidden columns to the right of the input area. If you unhide them and look at the tables where the names of the down menus are created you should be able to check that the named area actually exist in your spreadsheet.

It might be easier to debug this if you can email the results, possibly with screen shots plus translations of the error messages.

I get the #Bezug error (illegal Reference #Ref)  in the Lookup and Menu columns. Excel says, that the "Indirect" part of the equation produces the error - I think the problem exists because german Excel expects a ZnSm (for "Zeile"=Row and "Spalte"=Column in german) format of indirect references while english excel uses RnCm.

Curse Microsoft for translating everything else in their Makro language but leaving this part to trip the user.

I found this page to explain the problem. Maybe you could implement one of the suggested solutions?

I tried to change my Windows language to english but this doesn't seem to be possible with Windows 7 Home. Another reason I should have gotten the Professional version.

Joerg

Can you send me an email - I think I have a fix and I'd like to send you a copy for testing.

Thanks

PS. My email address is at the bottom of the Instructions sheet

it is very nice!

Thanks M8te!

 Very much appreciated, and many thanks.

Small oddities, though.  It seems that the sheet is charging 1 XP for the Trials and Trivails: The Hand of War Hatred choice in Rogue Trader.  Likewise the Motivation: Exhilaration: The Thrill of Warr appears to have a cost of 202 XP.

Actually, going through, several options on the origin path seem to have these odd. costs.

Is anybody else seeing the same xp anomalies as Darth?

I can't reproduce them myself.

Darth - what version of XP are you running?

 Sorry - I meant what version of Excel are you running?

 Excel 2007 on Vista.

And now it's not doing it.  Odd.  Very bloody odd.

 After further prodding, it only seems to turn up when the career is set to Arch-Militant.  Flipping the career to anything else seems o make the problem go away.

I can confirm this issue with the arch-millitant and hand of war.

Is the gothic sheet design of your own creation?  I ask because i would like to find out if that view can be submitted to the myth-weavers website as a template for their online character sheets.  They run a play by post website that allows (amongst other things) die rolls within the posts.

Is your layout for the gothic sheet something I can submit?

OK - found and fixed the xp bug, it occurs when you gain 12 or more starting talents.

I've also fixed a few of the origin path options that were not granting the chosen talent correctly or not showing the correct down menu.

I'll do some testing then post an update today.

cd8dman - the sheet is my own design and I'm happy for you to post it along with a link back to the dark reign site so people can download it.

 Homeworld traits in the final sheet are marked as "acquisitions" in DH mode, unless I just did something wrong (on a mac, for reference)