Jump to content



Photo

Excel based Character Sheet


  • Please log in to reply
849 replies to this topic

#1 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 14 May 2010 - 11:48 PM

My group is starting a rogue trader campaign next week and, having some spare time, I have created an all singing and dancing spreadsheet to aid with character creation and subsequent advancement. It supports all careers, origin path, skills and talents and tracks XP spent.

It is written in Excel (2007) and mostly works in 2003. There is a printable custom character sheet (2 landscape pages) and a fully functional front and back sheet that print with the official character sheet image as a watermark. However due to a bug with image scaling in Excel 2003, this part only works in 2007.

I could do with some "play testers" to find any bugs and a place to post it on the internet.

Any recommendations for internet file stores or volunteers for testing?



#2 Iku Rex

Iku Rex

    Member

  • Members
  • 242 posts

Posted 15 May 2010 - 12:01 AM

Dark Reign?  



#3 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 15 May 2010 - 01:14 AM

 I will definitely check it out once you have uploaded it somewhere. Sounds great!



#4 E.X.A.-Puggy

E.X.A.-Puggy

    Member

  • Members
  • 29 posts

Posted 15 May 2010 - 02:28 PM

Looking at it now i must say good job, I haven't done a run-through yet but it looks like it's clean and in order. If i find any issues i'll let you know.

 

[Edit]

On the talent's page after i select a talent and attempt to place a value in the box for XP i get a read only error that states that it is protected. I un-protect the sheet and (I'm assumeing that the math is sopousto be automatic) the math does nothing.

 

The talents list there is a space of 7-8 lines with out a drop down menu. after the first.

 

Some of the talents have the bonouses or explanations to them, but not all, and not both. EX: Armor of contempt "resistant to corroupton" Should read "Reduces Corrouption points by 1, WP test to ignore all Corrouption points for 1 round" Or something like that.

 

When Printing the sheet (Front) the checks for the skills are off about 1/4 inch to the right, and 1/16th of an inch down, (Left side of the sheet) Same with the stats at the top of the page. And the skills need to come down 1/16th and over 1/16th on the right side of the skill list. Psychic Disciplines print out is about 1/2 inch too high, Psychic Techniques is off too the same, (And there is not enough room, No your fault)  Most of this could be because of my printer settings and wanting to use all of the real-estate on my 81/2 X 11 pages.



#5 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 15 May 2010 - 08:18 PM

Hi all

Thanks for your feedback. As some of you have noticed, the spreadsheet is now available on the Dark Reign site

http://darkreign40k....id=38&Itemid=39

I will address all issues posted here over the next few days and then publish a new release.

 



#6 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 15 May 2010 - 10:26 PM

 It looks really good!

As other have pointed out there is a problem with the Talents page. The down menu only works for the first line. Other features I would like is the possibility to pay xp for other things than talents and skills. As an explorator you can pay 200xp to upgrade your bionics and cybernetics at character creation. This could easily be done with the option of typing some of the talents yourself. Would be good if xp spend like this would add to the total.

Also a way to display unnatural stats would be great. Maybe have a box to check off if you have an unnatural strength or whatever and make it appear on the finished sheet.

Thanks for the great work. 



#7 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 16 May 2010 - 07:20 AM

I have submitted a new release to Dark Reign (version 2.1) that addresses the following issues.

  1. The protected cells on the talent sheet
  2. The Lack of pulldown menu on lines 2-8 on the talent sheet
  3. The font in the gear section now matches the image backsize
  4. Rank did not display until 5000 xp was spent
  5. Armour type can now be entered and displayed
  6. XP spent on bionic upgrades can now be entered
  7. Support for unnatural talents

I am aware that the backsizing may be an issue for no A4 paper sizes so I have added a release notes section on how to tweak the settings as well as how to update the description of each talent. I took these from the summary in the manual and as E.X.A said, these are not always very descriptive.

If someone has a better list, let me know and I will incorporate them. My email address is in the spreadsheet.

Note: It may take some time to for the upload to become available so check you are getting release version 2.1 (not 2.01)
 



#8 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 16 May 2010 - 09:38 AM

 There is a list of the talents with a better description on DarkReign called RT Talent List Table (Printer Friendly)

 

For some reason I cannot paste the adress but you can find it in the download section, Gaming Aids page 4. Hope this helps.

 



#9 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 16 May 2010 - 09:21 PM

 xp used on talents don't add to anything.

This is, by the way, the best sheet I have seen so far.



#10 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 17 May 2010 - 02:10 AM

Hi all

Thanks again for the feedback, I have managed to address most of the issues mentioned on this forum (and a few others from my gaming group).

I liked the alternative talent descriptions, however they were too long to fit into the space available on the sheet so I have not implemented them.
I have added a rules summary to the talents sheet, and this can now be printe alongside the talents which provides good background on the rules, talents and traits for new players. I expanded the talents section (some backgrounds had more free talents than fitted) and added a free form section at the bottom for special abilities and any other traits/talents acquired that are not on in the standard rules.

The armour type is now correctly displayed on the offical sheets and all unnatural characteristics are applied to the approriate skills (movement speeds, wounds, lifting weights etc.)

The bug with xp on the talents sheet has been fixed.

I hope this will be the last release (for a while at least)

The latest release is 2.12 and is availalbe for download on the Dark Reign site www.darkreign40k.com/drjoomla/index.php

It is in the Character Sheet section, titled Rogue Trader Character Sheet 2.12

Enjoy.



#11 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 17 May 2010 - 10:33 AM

 Looks very great. Thanks a lot for this sheet.

I don't see that the armor type is being displayed at the main sheet? Not that it matters much, but you did write something about it should be displayed. I take it that it should say Carapace somewhere?

And thanks for all your work. This is exactly the kind of sheet I have been looking for =D



#12 venture6

venture6

    Member

  • Members
  • 6 posts

Posted 18 May 2010 - 06:22 AM

This is a fantastic sheet - thank you for your hard work Memetix!!



#13 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 18 May 2010 - 12:25 PM

 Sorry the armor type works fine. I was looking at the wrong sheet. I am planning on using the Character Sheet as it has room for more description of talents etc. 

Only thing I have found so far is when you type the 3rd special ability description this doesn't appear on the character sheet. Other than that everything works perfect for me.

Thanks again Memetix!



#14 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 20 May 2010 - 02:07 AM

Now even better!

Release 3.0 includes a more intuitive talent sheet that knows all talents for your career and rank and whether you meet the prerequisites.

Also support support for the "talented" talent, all psychic techniques and navigator powers. Sound constitution is now summarised in the talents section to save space (i.e. if you take 3 sound constitutions it displays as "Sound Constitution x 3"

Added all Secret tongues in skill list. Fixed the fonts on the character sheet to be compatible with Excel 2003 and bugs with jump length and initial wounds.

Version 3.0 is now on the Dark Reign site.

http://www.darkreign...8&Itemid=39

 



#15 Iku Rex

Iku Rex

    Member

  • Members
  • 242 posts

Posted 20 May 2010 - 03:44 AM

(In case anyone's wondering, it doesn't work in OpenOffice Calc.) 



#16 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 01 June 2010 - 10:18 AM

I have a new version of the spreadsheet 3.15.

This contains VB code to load and save your characters which means that any future updates to the base sheet will not require you to re-enter your character data. If you don't enable macros in the sheet, these buttons will not work.

It also includes full support for all skills according to your rank and career.

I am trying to upload the new version to Dark Reign but there seems to be a problem with the upload process at the moment, so keep an eye on site for an update.



#17 FoxPhoenix135

FoxPhoenix135

    Member

  • Members
  • 99 posts

Posted 01 June 2010 - 11:47 AM

It works fine for me in Open Office Calc, though I haven't tried to print it on the actual sheet. So far this sheet has been invaluable to me for creating characters and NPCs quickly and efficiently. I wish there was one for Dark Heresy that would work with the Radical's Handbook!

As for the utility itself- I found a minor problem with the way the new talent sheet works:

I am trying to create an Astropath to act as a nemesis for my PCs. At one point in his origin path, he was tainted with mutation, resulting in the Wyrdling trait (boosting his starting psy rating and giving him extra psychic techniques.) I can add in the extra techniques manually, but I am having problems adjusting the Psy Rating. Any suggestions on how to do that, or are you going to update the sheet for instances such as this in the future? Also, I've only been able to add in the modifiers to the Origin path characteristic modifiers manually. What am I doing wrong?



#18 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 02 June 2010 - 09:16 PM

Version 3.17 now available at Dark Reign

Fixes a bug in the loader that affects the tick boxes on the talents sheet and the non-standard armour type from previous saves files

Also allows override of the XP for rank 2 characters (default is 7000). In our campaign the GM allows us to level up at 6000 so this is now a house rule option on the data entry sheet.



#19 Zero

Zero

    Member

  • Members
  • 51 posts

Posted 03 June 2010 - 07:05 AM

 Seems the forge world origin adds 3 to Will Power.



#20 Memetix

Memetix

    Member

  • Members
  • 438 posts

Posted 04 June 2010 - 06:47 AM

Thanks for your feedback.

FoxPhoenix - I have no plans (as yet) to support all the mutation types so I'm afraid you'll need to add the Mutation bonuses in the elite advances section in the mean time. Alternatively, you can tick a greyed out advance, so you could tick the Psy rating 3 talent and adjust the XP cost to 0.

Zero - I can't replicate your bug. Can you email me your saved character (The .rtc file) please?






© 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