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.

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!

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

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!

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

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.

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.

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

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.

The Autoinjector seems to be missing from the Cyberware category

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.

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

I'm using Linux and OpenOffice.

The specialization option (x) does not work.

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

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.

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


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


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.


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)?

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.

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.

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.

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

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

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

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

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?

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.

All the above problems are now fixed in version 9n.


You need to disable Validation. Select the cell where you are trying to modify the skill value. Goto Data->Validation->Allow:Any Value


- Krav Maga has this power, it is called 'quick draw' so that it will fit in the martial arts area.
- Talk to Microsoft about 2007. I do not have it so I cannot troubleshoot for it, the sheet works fine in 2003.
- You want the race description on the CharSheet? No thanks, takes up too much room. Perhaps I will work on a character background/description charsheet that can list extraneous data like that.
- Indeed, they cannot. Were you wanting a smartlink on your Nunchuks? Or maybe a lasersight on your sword? Seriously though, what mods are available to melee weapons? Make me a list with page references and I will work on adding these in.

I know it is kind of quick, but I fixed quite a few bugs and will develope as quickly as I can continue to receive feedback.

Version 9n is now available.

Added a few items from the latest Errata. Also added a 3rd character sheet, which is not as pretty but holds a little more data.

Also, the dice rolling scripts now include Glitches and Critical Glitches.

It is a plausible approximation but Quick Draw is something else. With Quick Draw you have to roll to see if the character can ready and shoot a weapon with the same simple action. Unless some other advantage is purchased this only works with pistol sized weapons. The advantage of Krav Maga is that you spend your Free Action to ready any weapon. Afterwards you could even use one of your simple actions to ready and shoot another weapon with Quick Draw.

My bad, it was on the MainSheet. I just thought this was a nice touch. You're right about it taking up too much room on the CharSheet.
Personalized Grip (Arsenal p. 152) and Under"barrel" weapon (Arsenal p. 153) are specifically also allowed for melee weapons. There may be others but I don't remember.
I can't see any reason why Chameleon Coating (p.150), Custom Look (p. 150) and Gecko Grip (p. 152) shouldn't work with melee weapons.

In 9n the armor cells on the Gear Table work but the CharSheet only displays items one through three correctly. Where is MilSpec Armor? I only found the MilSpec upgrades.

On the Cyberware_Bioware sheet it should be "Essence" not "Essense".

If you create a character in the BP-System and want to add spells with karma the sheet adds BP, Karma remains untouched

The fourth armor cell in the character sheet has a simple misprint, unprotect the sheet, pick the fourth cell, and change the formula from =IF(Gear!$D$7<>"",Gear!$D$7,"") to =IF(Gear!$C$7<>"",Gear!$C$7,"") The last two cells are working correctly, however cell 5 displays the information should a physical/mystic adept have the mystic armor power, and cell 6 displays what ever armor mods a characters cyberware bestows.

Anyways Ive discovered a minor error, that I can't quite figure out how to correct. For throwing weapons, the concealability modifier isn't being properly displayed, all I'm seeing is #N/A.

In OpenOffice: If you want to change from Karma Creation System to BP Creation System, you can't make a selection in the drop down box because it's covered by another menu. I had to cut and paste the Karma/BP drop down menu to make it work.

Second minor bug I discovered i that the sheet output is corrupted if you have an empty row within your skills.

Just wanted to let you know.

Great program!

Yeah, I know they are different. It doesnt seem that using an abbreviated name there is causing alot of confusion to me. I can change it to 'Quick Draw Free Action' to help with the slower folk who easily confuse Martial Arts Advantages with Phys Ad powers and innate abilities.

You can always add race notes to your concept, which appears on the final CharSheet.

Added weapons mods, as you suggested. Only one mod spot per line in weapons area, but added the $0 cost (add mod) option on the weapon sheet, so you can have mods on the lines after a weapon, should you want to stack on the mods.

Fixed the display problem on armor on the CharSheet. Added Military Grade armors and Environmental Armors to the Armor list.
Fixed the spelling error. I can spell, I swear... that problem apparently has been there since the original Character Generator was created... But no longer! Thank you Dakka, our english hero!

There is a concealment table on the Gear_Data page, which is linked to the weapon type. I changed the entry in the Concealment table to read 'Throwing' like the weapons are listed as, instead of 'Throwing Weapons'. Fixed in 9o.

I have not tested this sheet in Open Office much. I do not see either of these problems in excel 2003. Perhaps I will put version O on the Open Office on my laptop and see if I can sort this out. In the mean time, I am going to release version 9o. And that is 'o' for 'ooooooh man, this is good!'. You'll see

Version 9o is released!

- You can now play as a Free Spirit!
- Milspec and Environment Hazard Armor
- BP Build System users can now flag spells as 'Karma purchased' spells.
- Corrected various issues with Karma/BP costs

Free Spirits can purchase their Spirit Powers from the Adept Powers section of the Magic sheet.

Don't forget that there is a new CharSheet option #3. Please check it out and let me know what you think.

Doh! I forgot to point this out in my last post, but bolos don't have a range set for them! (heh they are what clued me in that the concealability rating was missing to! doh!) on my sheet I just fixed it and forgot about it.

Some other minor omissions and errors: some of the shotgun's are missing their weapon type so don't display correctly, and the street Sweeper isn't using taser ranges.

most of the time when I find a problem, they are just minor typos so I fix them myself and forget about them. You and your predecessors have done a phenomenal job on this thing.

I definitely like this chargen over most others. However, is there any chance of adding the Commlink mods as listed in Unwired (i.e. Hardened Case or Response Enhancer)?

Ill clean up the weapons in version 9p. Thanks for the tip.


Thats a fantastic idea. I have not read unwired but I have it. I will go through and add these in for version 9n.

Also, everyone note the revised knowledge skills (if that is not in 9o, you will see it in 9n). I have removed all of the old knowledge skills (3rd edition junk) and added in ones from 4th edition examples. Its alot shorter list, but alot cleaner. Let me know if there are any standard knowledge skills you all think I need to add in to the sheet.

Do you need someone to correct all the 0 values and other data set issues, good example, like the gillie suite and slap patches. There are more but I don't have the character I made with all the 0 values with me right now. Also some things like that ratings are wrong too. For instance, for activesofts it gives a rating of 1-6 but it is only 1-5. I can give you a full list later today.

If you need someone let me know, and I can correct them for you and send you updated sheets with the correct values. I would start out with just simple things like just making sure the cost is correct.

@Dakka Dakka: I took a look at SR4A and I didn't realize it was just all current errata with an excerpt from Unwired. For some reason I thought there was much more to it.

Mage Sight Goggles issues continue, although I like the current issue. They're free

Just PM me a complete list of the specific corrects I need to make. I usually start modding a new version so quickly that I would have to merge with a sheet you changed, so it will be easier to just make the updates myself on the current Dev copy.

Alright, will do.

Finished adding Comlink upgrades. Added VR Initiative and Passes, which is modified by Simsence Accelerator and Simsense Booster. This is your hot-sim VR # of passes.

Added cost to Magesight Goggles. I see alot of free stuff there. Aid with this data entry is appreciated.

*EDIT*
Found the problem. For some reason it switched to Karma Build and screwed me up.

Version 9p is now available.

Includes:

- Completed list of Advanced Metamagics, with prerequisite functionality
- Added missing drug and magical compound prices. Still alot of missing prices in Gear table.
- Revised Charsheet: Fixed custom gear not appearing error
Revised combo area for Powers/Spells/Wares/Programs/Forms!
Note that Charsheet option 3 has a very large combo area, perfect for the heavily cybered.
- Other various tweaks and fixes

Thanks for all the help with troubleshooting!

when I was playing with version 9o, I noticed that after switching to build points, when I put points in knowledge skills or languages, it didn't add on the upper right totaling area... did I do something wrong? previous versions did that, but not sure if I needed to turn a feature on or off.

second observation: When working with weapon customizations and adding things like heavy barrel or gas vent, it turns yellow and doesn't add recoil modifiers... no recoil modifier for personalized grip either... again, is there something I should be doing differently?

Also, not sure if this is possible, but would be nice to see a 'used' option in vehicles to allow for a discount on base vehicle price in some future change.

Is there a way to turn off the building aspect of the sheet? for example, if you pick up a gun off a dead guy in a gaming session, but try to add it to your list, you can't do it without it forcing the money from your balance. Or, if you recover a commlink with programs or agents and have a hacker friend transfer them to your commlink, you can't select a way to reduce the price to 0 to list it as loot... maybe if there was a column in pricing areas that allowed you to put an 'x' in it to classify it as loot and remove the price from calculations?

I'm still new to playing with the generator, so don't know if I'm finding errors or if I just don't know what i'm doing

Thanks for all the work, it's awesome!

In Beta version 9p the positive quality "Born Rich" Reports its cost as 20 Actual cost is 10. Thanks and keep up the awesome. And keep up the awesome work too.

1. When using the building point system, you get a number of free knowledge skill points based on your logic and intuition attributes. Until you surpass those free points, you are not costing yourself any BP so no tally is shown on the totals on the right.

2. Your right, many weapon customizations are not working correctly. I need to fix concealment and recoil modifiers.

3. Your right... players should be allowed to buy used cars. Anyone have any suggestions on what kind of price multiplier should be given to used vehicles? Also, at what rate would the vehicle decrease its speed/accell/handling/body? I could add a vehicle mod called 'Slightly Used' that lowers price... another called 'Used' which lowers speed/accel slightly, then one called 'Old beaten wreck', which includes penalties to handling, speed/accel, and armor? Input is appreciated.

4. No, there is no Building mode/playing mode on the sheet. This really only affects Money. My recommendation is that once the character is created, you must keep track of his money manually. There is a spot for putting their 'Current Nuyen'. Once they are built, simply ignore the 'Remaining' number. Maybe I should make it so that once you have entered something into the 'Current Nuyen' field, the Starting/Remaining fields grey out.


Ill check that out, thanks for pointing that out.

*Edit:
Actually, the BP cost of Born Rich is 10, so the character sheet will report 20 when you are using the Karma Build System. You can flip Karma Build System on and off on the upper right of the Main Page.

That is a nice idea, however this does not help with items that have been "found" on runs. How about using a field that contains the fraction of the base price the item has really cost. 1 should be standard, but you could put in anything from 0 to infinity. The end price would then be modifier cell * baseprice cell. Adding all the possibilites that change the street price (SR4 p.303/SR4A p.312) as distinct mods to me is a lot of work for little gain. Just let the user enter the net modifier for the price. You might want to consider making cells for modified handling/speed/acceleration so that the user can decide just how busted the vehicle is. AFAIK there are no guidelines in the books as to how to simulate used vehicles so the modifiers will probably vary from game table to gametable anyways.

A good idea IMHO

'Found on Run' does not apply to the charsheet. It is intended for tracking starting money, but the only way it helps you with money post character creation is to provide a cell for you to track the money your character has yourself.

I was thinking the same thing on the Used parts for vehicles... maybe a box for used, and when you put an x in it, it opens another where you put the percentage of total price paid, so if its loot, it's 0, or if you bought it used, it's 50-80? (which would be 20%-50% discount

Again, thanks for the superb work, heh, just playing around with character creation has become fun using this as the way to find balances.

Oh, found something cyber/bio/nano stuff... the nanohive, from what I've gathered reading RAW and the boards, the capacity is 2 regardless of the level of the implant. Current calculations on the spreadsheet make this where the capacity is increased by a multiplier of the rating you select from the drop down menu. So a nanohive rating 6 ends up being 12 capacity instead of staying at 2 capacity.

oops. doubleposted