Search the Forums
Options
Keywords search:


Search in Forum...

Search within...

Match...

Antiquity...

Player messages...
You are here: FFG Forums /  Roleplaying Games /  Deathwatch

Deathwatch
Join a brotherhood of the finest warriors in the universe
Moderator: FFG Andy FischerFFGAntonGeckoThe Spaniard Topics: 1403 | Posts: 27522
Deathwatch Character Sheet Generator
Published on 15 March 2011 - 02:35:46

I'm developing a Character Sheet Generator using Microsoft Excel and Visual Basic (for Applications), i.e. a macro running spreadsheet.

I've got a fair bit done now. Equipment is the only real bit missing, although there are a few minor things to still add (elite advances, past events, etc.)

Not sure if anyone is interested, but happy to share what I've done (and what will be done).

Features:

  • MS Forms input - nothing is entered manually into spreadsheet.
  • Allows random characteristics, points buy and manual entry
  • Choose chapter and specialty
  • Buy advances
  • Random or manual entry for Wounds and Fate Points
  • Enter other details (name, demeanour)
  • Generates page 1 of the character sheet
  • Although developed on Excel 2010, it is saved as Excel 97-2003 compatible, but you will need to enable macros.

I will be working on adding equipment and Page 2 of the character sheet next.

I've saved a copy here: cid-7bc6fd6adf10c0b1.office.live.com/self.aspx/Public

Let me know what you think...

Deathwatch Character Sheet Generator

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

Page 1 of 15 (212 messages) 1 2 3 4 5 ...Last page »
Reply #1 | Published on 15 March 2011 - 18:07:39

 so far man, looks pretty sweet - nice n easy to use.

One thing to note is that when you update it next you might want to look through the living errata info as i noticed a few talents and skills in the lists that have had their xp costings changed (whereas the ones in the generator reflect the old values) i.e. "Hardy" for the Apothecary.

Aside from that looking good n looking forward to see what the rest looks like.

Live long & Die fast.

Reply #2 | Published on 15 March 2011 - 18:50:19
0
0

 Looks really good. Although everytime I try and create a Techmarine, I get an error: Run-time error '1004': Application-defined or object-defined error. 

 

I'm running Excel 2003 SP3 if that helps.

Without Signature

Reply #3 | Published on 16 March 2011 - 03:30:26

Living Errata will be incorporated ASAP.

Will look into Techmarine issue right now.

Thanks for feedback - it's what I've been wanting.

Deathwatch Character Sheet Generator

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

Reply #4 | Published on 16 March 2011 - 03:37:00

Techmarine issue resolved.

Deathwatch Character Sheet Generator

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

Reply #5 | Published on 16 March 2011 - 11:23:19

Fixes:

  • Living Errata now incorporated
  • Techmarine now selectable

New Features:

  • Page 2 now developed - Talents & Traits, Psychic Powers and XP

To Do:

  • Equipement (incl. PA History)
  • Renown
  • Elite Advances
  • Past History
  • Specialty ability choice

Deathwatch Character Sheet Generator

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

Reply #6 | Published on 16 March 2011 - 11:27:05

sweet, will have another looky when i get chance later.

Live long & Die fast.

Reply #7 | Published on 16 March 2011 - 15:09:44

That's Awsome!

I spend ages creating a similar one for the original WFRP authough it's not any where near as good as this.

Thanks for posting it. I'll try it out with our group and let you know how we get on.

Without Signature

Reply #8 | Published on 18 March 2011 - 11:39:11

New version up with the start of the equipment tab present. 

Deathwatch Character Sheet Generator

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

Reply #9 | Published on 18 March 2011 - 16:30:48

Ugh.  Why does everybody flock to excel?  Something that could be potentially full of macros and viruses? 

 

No offense. But why can't anybody make a simple javascript one?

 

(PS.  Where I used to work made me engraned to hate excel. I just do, sorry)

JerichoReach.com  Because I shamefully advertise.  Also Apocrypha

Reply #10 | Published on 18 March 2011 - 22:11:11

 Looks like it's coming along great!  I'm having a hard time manually putting in my rolled stats though.  Also, there are Chapters, but not RoB Chapters/Successors.  Is there a plan to implement these?

Without Signature
Reply #11 | Published on 19 March 2011 - 05:47:05

Frostfire: Excel and VBA is what I know. If anyone has Java skills, then I'd happily look at what they could do. No offense taken

Brolthemighty: I'm simly working in order of release at the moment. Once all of the Core Rulebook is implemented then I will move onto RoB - helps me keep track of what I've done. Can you explain what difficulty you are having with rolled stats - will happily make improvements from feedback.

Work on equipment is progressing nicely, but I'm trying to work out best way acquire and show on sheet - specifically: weapons, upgrades and ammo.

Deathwatch Character Sheet Generator

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

Reply #12 | Published on 19 March 2011 - 17:12:53

 NVM, I got it working.  The only downside I see (and again, I could be missing something) is that once you make a choice in the generator, there's no real way to see the list of choices (in regards to talents) you've made without exiting the generator and looking at your sheet.  So if you come up with an off amount of xp, you can't really say where it came from or went to.

Other than that, it's coming along nicely, and some really great work has been done!  I can't wait to be able to use it!

Without Signature
Reply #13 | Published on 22 March 2011 - 18:06:33

Just a quick update:

A new version is available, although it is more of a work-in-progress with the Equipment tab. I got the equipment list built, but still working on how it populates the printed sheet.

Brolthemighty: The Advances tab shows what Talents have been chosen, but skill advances are only visible on printed sheet. Are you suggesting a more comprehensive tracker of XP showing all advances purchased?

Keep the feedback coming...

Deathwatch Character Sheet Generator

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

Reply #14 | Published on 23 March 2011 - 04:43:51

 Yes, on the sheet you can see what was purchased, however in the actual Generator, there's no box showing what has already been purchased.  I think it might be a nice addition to have a 5th box showing what you've already purchased, as well as the xp cost....with the ability to double click it again to remove it from "Purchased."

Without Signature
Reply #15 | Published on 23 March 2011 - 11:44:39

I'll look into adding a 5th box.

I need to work on an undo feature for all stages and so this will come a little later.

Deathwatch Character Sheet Generator

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

Page 1 of 15 (212 messages) 1 2 3 4 5 ...Last page »
You are here: FFG Forums /  Roleplaying Games /  Deathwatch

© 2013 Fantasy Flight Publishing, Inc. Fantasy Flight Games and the FFG logo are ® of Fantasy Flight Publishing, Inc.  All rights reserved.
Privacy Policy | Terms of Use | Contact | User Support | Rules Questions | Help | RSS