Jump to content



Photo

Deathwatch Character Sheet Generator


  • Please log in to reply
252 replies to this topic

#1 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 15 March 2011 - 11:01 AM

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...



#2 sgtgrarm

sgtgrarm

    Member

  • Members
  • 66 posts

Posted 15 March 2011 - 12:07 PM

 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.



#3 LemmingStampede

LemmingStampede

    Member

  • Members
  • 2 posts

Posted 15 March 2011 - 12:50 PM

 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.



#4 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 15 March 2011 - 09:30 PM

Living Errata will be incorporated ASAP.

Will look into Techmarine issue right now.

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



#5 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 15 March 2011 - 09:37 PM

Techmarine issue resolved.



#6 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 16 March 2011 - 05:23 AM

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


#7 sgtgrarm

sgtgrarm

    Member

  • Members
  • 66 posts

Posted 16 March 2011 - 05:27 AM

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



#8 Tattoedbikerdude

Tattoedbikerdude

    Member

  • Members
  • 24 posts

Posted 16 March 2011 - 09:09 AM

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.



#9 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 18 March 2011 - 05:39 AM

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



#10 Frostfire

Frostfire

    Member

  • Members
  • 182 posts

Posted 18 March 2011 - 10:28 AM

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)



#11 Brolthemighty

Brolthemighty

    Member

  • Members
  • 117 posts

Posted 18 March 2011 - 04:11 PM

 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?



#12 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 18 March 2011 - 11:47 PM

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.



#13 Brolthemighty

Brolthemighty

    Member

  • Members
  • 117 posts

Posted 19 March 2011 - 11:12 AM

 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!



#14 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 22 March 2011 - 12:06 PM

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...



#15 Brolthemighty

Brolthemighty

    Member

  • Members
  • 117 posts

Posted 22 March 2011 - 10:43 PM

 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."



#16 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 23 March 2011 - 05:44 AM

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.



#17 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 23 March 2011 - 11:34 AM

New version available.

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

Feedback appreciated.



#18 Raven1man

Raven1man

    Member

  • Members
  • 11 posts

Posted 24 March 2011 - 10:59 AM

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



#19 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 26 March 2011 - 05:07 AM

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



#20 Tricky110974

Tricky110974

    Member

  • Members
  • 132 posts

Posted 26 March 2011 - 11:09 AM

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.






© 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