Upgraded Character Generator, Updated Generator Based on work from Autarkis and Blakkie Options

[DamienKnight]

Sorry for my absence. When I first started this sheet my SR group stopped playing, and I have only played once since. The sheet in itself was very rewarding to work on, but as the fixes became more tedious, I found other hobbies, and the months since my last SR session increased, my motivation waned.

A member of my old group started playing again and complemented the sheet, so I am feeling motivated enough to do at least one more version.

This new version aims to be more OO compliant (since I will be working on it in OO rather than Excel). I do not intend to add any more new features, simply add some tweaks and try and get some Open Office Stability restored.

Till then, thanks for the support and feedback. I would not have done half as much if not for the motivation you all give me.

[deek]

Thanks for your efforts! While I've only been using the sheet recently, it a huge help to my campaign planning and to my players!

[cndblank]

Ditto.

Keep up the good work.

Having a way to send the entire character to text would be helpful for both the GM and the players.

It could be edited to create NPCs or used as a character sheet.

Just being able to print off the gear would help.



Thanks

[Warlordtheft]

I hope to get off my butt at some point (maybe publicly stating so would help do that) and take the SR3 Character Dossier that Wizkids put out and use it as a guide to take the character generator here and incorporate it into the file. Fortunately with all the core books out, it looks like the background books are going to be comming out next. So there shouldnt be much in the way of adding to the character generator (gear abilities and such).

??-I'd like to keep it OO compatible so tips of things to avoid would be nice.

Damien---great work!

[limejello10512]

BEAUTIFUL!!!!!!!!!!!!!!!!!!!!

But three things I noticed that were missing: level 3 improved reflexes costs 5 magic (it was supposed to be 4 since the update), uneducated does not double the cost of a new tech skill, also the TKD bonuses seem to be missing... I entered it in myself but I'm not sure it will show up in the unarmed damage (did it to begin with?)

Any advice on how to fix these?

btw:
"the months since my last SR session increased, my motivation waned."

ADAM PAY HIM MONEY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Malachi]

The check for the limit on the Improved Ability Adept Power doesn't let me but any sort of level into the box. Regardless of the value of my Magic attribute or the level of the power I always get the message that it is too high.

Great job on the sheet, though damien! I'm looking forward to the OO compliant version.

[deek]

Bug I found last night:

When adding gear, the eyeware didn't allow me to add ratings. For contacts, I should be able to pick rating 1-3 and goggles 1-6. I was only able to pick the item, assumably at rating 1.

[Dakka Dakka]

AFAIK these are the rules of SR4A. I don't recall that the rule changes and additions are implemented yet.

[Socinus]

I dont know if it's already on the slate yet but its somewhat important. Creating an AI character is a little difficult as things like condition monitors dont change and many of the AI qualities arent there and adding your own prevents you from setting a cost.

[Socinus]

The Autoinjector seems to be missing from the Cyberware category

[DamienKnight]

First minor update.

Version 9k is now available.

I am getting a group together and we started making characters on the spreadsheet. I went through and fixed several problems I found:

- Fixed Attribute maximums for infected characters.
- Revised Adept Power namefinder code (used to complete lookups when custom name is used, such as Element [Electricity])
- Added namfinder code for spells to allow custom spell drain lookup (ie. [Element] Aura works as [Flame] Aura, etc)
- Fixed martial arts costs for Karma Build System, renamed Sweet to Sweep
- Added Mystic Armor to Charsheet Armor area, added Martial Arts DV bonuses to Unarmed and weapon values, other minor tweaks

I found that a lot of issues with ratings were related to cells being converted to Text format instead of Number (0 decimal) format. I changed all of the ones that I found, and removed the xml portion from the spreadsheet.

I still have a copy of the sheet with .xml, I can email it to anyone that wants it, just send me a PM to request it. It was an interesting proof of concept, but it causes maintenance issues with the sheet, and adds quite a bit of size to it.

I have not tested the spreadsheet in office 2007 or open office. I have removed some confusion the Main_Page had with cell IV, which may make the sheet work on office 2007. Removing XML and many of the scripts may allow the sheet to work better in open office... let me know how it works.

Also, I do not play as AI, and neither does anyone in my group, so I have little to no motivation to expand the functionality of AI. If anyone wants better AI support, they need to post a detailed list of changes that need to be made, including a list of each skill/quality they want added, and the quality cost.

[betterwatchit]

Found a problem: I mark the skill specialisation box, write something underneath it, and the BP total goes wrong.

[10gauge]

I'm using Linux and OpenOffice.

The specialization option (x) does not work.

[Socinus]

There are some problems with the math, Qualities like Infirm and Trustworthy are now double their original cost. This extends to several other qualities that I've found thus far

[Daikuma]

Can we get an output sheet that doesn't lock you into Adept OR Bio/Cyberware, but in fact can handle both?

As long as I have been playing, adepts often dabble in the digital. Be a shame if the character sheet cannot reflect that.

Also, from what I can tell, ALL qualities are doubled in cost, either way.

D.

[DamienKnight]

Bug I found last night:

When adding gear, the eyeware didn't allow me to add ratings. For contacts, I should be able to pick rating 1-3 and goggles 1-6. I was only able to pick the item, assumably at rating 1.

Could you direct me to the book/page where contact lense and google ratings are described?

I'm using Linux and OpenOffice.

The specialization option (x) does not work.

There were problems with this in all versions. I believe I have it fixed in version 9m.

Can we get an output sheet that doesn't lock you into Adept OR Bio/Cyberware, but in fact can handle both?

As long as I have been playing, adepts often dabble in the digital. Be a shame if the character sheet cannot reflect that.

Also, from what I can tell, ALL qualities are doubled in cost, either way.

D.

I will see about this. I am hoping to make more customizable character sheets soon

Qualities costs are not doubled inappropriately. Unlike previous versions, I believe the last release had Karma_Build_System set as TRUE as a default. Change that to false and you should see normal Qualities costs.

There are some problems with the math, Qualities like Infirm and Trustworthy are now double their original cost. This extends to several other qualities that I've found thus far

See above. These values are correct. I did notice that trustworthy's 5bp versions were not available, so I added those in version 9m. I also added functionality that adds 1 to skills boosted by qualities, reflected on the final Charsheet. This works with Catlike (Infiltration, Shadowing), Outdoorsman (Outdoors group), and Trustworthy (group or individual).

Are there any other skills/wares/etc that raise your actual skill rating (rather than just give bonus die)?

[DamienKnight]

Version 9m

Fixed various issues
Changed Phys Ad Increase Reflex III to cost 4 instead of 5
Fixed Crossbow ranges according to errata
Added Catlike/Trustworthy/Outdoorsman functionality on Charsheet to raise skill by 1

According to errata, qualities that raise skills increase the cost of raising the skill. That can be simulated for BP systems, but not with Karma systems without identifying what the skill was when the quality was chosen, which is going to be a hassle to calculate in. Basically if you raise a skill that is affected by the qualities, it assumes the quality was purchased after the skill was added. There are some situations where this is going to save you some karma, but not many. This can be adjusted for by added negative karma in the karma log, if you are really wanting to be strict with karma costs on skills that are augmented by qualities.

[barrelv]

First off, huge thanks for this. really makes tracking things so much easier.

I wanted to mention that I found a bug on the Cyberparts tab that I didn't see reported here (using the 9m version in Excel 2007)...

In cells AC4 - AC10, there is a reference to Limb1_Parts_Selected in the formulas. It should be Limb2_Parts_Selected - Limb8_Parts_Selected (depending on the row). This is causing the character sheet to repeat all the Accessories selected for the 1st cyberpart to duplicate 8 times and not show any of the selections for 2 - 8.

[Blind Guardian]

In version 9m, the sheet isn't handling the Resonance attribute for technomancers correctly. It is doing the same thing in Excel 2007 and in OpenOffice 3.0. When you select the technomancer quality, a field for Resonance appear, but the box isn't green like it is for the other attributes. There's a little red tab there, which opens a drop down menu when you click it. You can select an attribute, but it shows up in red, and it isn't being correctly deducted from your BP/Karma total. The resonance line in the totals column still shows as zero, and it isn't being added into the total BP spent. However, it affects the line down at the bottom that says "Remaining." If I open a new sheet, select technomancer and select a resonance value of 5, the value of the Remaining field changes from 0 to -42. It does this in Karmagen mode, as well.

[Dakka Dakka]

Once again thanks for your continued efforts.

While playing around with the new sheet I found a few issues with MS Office 2007:

• Only he first three entries in the armor section work correctly
• If you want to update your sheet to the rules of SR4A the cost for Increased Reflexes should be 1.5PP, 2.5PP, 4PP for Levels I, II, III respectively
• Focus bonding costs double if you put an x in the bonded with BP cell.
• Melee weapons cannot be modded.
• If you select a melee weapon on the Weapons Sheet, the remaining reach cells on CharSheet are filled with ####.
• Augmented attributes show up as totals, not as BaseAttribute(AugmentedAttribute)
• I like the mentioning of some Racial Traits on the CharSheet.
• Krav Maga is missing the "Ready Weapon becomes a Free Action" advantage.
• Excel 2007 sometimes crashes

[barrelv]

Noticed something else odd with 9m

When selecting "Magician" from the Main Sheet, nothing comes to life on the Magic tab

nevermind, just noticed it was scrolled over too far to the right...

[Dakka Dakka]

Scroll to the left. The starting point is a little off to the right

[barrelv]

Mage Sight Goggles makes the Gear section freak out. Looks like there are 2 entries in the Gear_Data tab

[Stormdrake]

DK, Love the chargen. Makes tracking player creation a breeze. One thing though, I followed the instructions you gave me a while ago to mod the chargen to allow larger skill pools. The system still gives me a warning though if I input a skill over six and deletes the entry. How do I disable or change the warning so it will accept the modified skill ratings?

[Eleazar]

[list]

[*]If you want to update your sheet to the rules of SR4A the cost for Increased Reflexes should be 1.5PP, 2.5PP, 4PP for Levels I, II, III respectively

Might I say that if possible, it would be best to have a separate set of entries for SR4A and a separate set of entries for Original + Errata. The entries would be switched through a button or dropdown menu on the main sheet. Many people haven't switched to SR4A yet because there are some significant changes in SR4A not everyone in the gaming group is familiar with, nor were their current NPCs/characters made with those changes in mind.

I don't mean this in anyway to be at odds with what you have said Dakka Dakka, I am providing an idea of how this could be accomplished.