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

[DamienKnight]

Edit: Dec 2020 I am making the source folder available here. I have been tweaking the sheet a bit lately and will put newer versions here.

I am a big fan of the Character Generator spreadsheet created by Autarkis, and updated by blakkie. My SR group started using this sheet, and I began making small revisions. After awhile it turned into a bit of a pet project and the spreadsheet has come a long way. Since releasing the beta to Dumpshock we have reviewed and upgraded this sheet through several major versions and its looking great!

Features:

- Classic Character Generator by Autarkis and Blakkie as the basis
- Added a formatted printable Character Sheet, inspired by Harri Tusa's Wizdoc.
- Added full list of cyberware/bioware from the Augmentation book.
- Added a Hacking sheet for tracking Comlink and programs.
- Added a Vehicles page for tracking Vehicles, including Mounting turrets and other mods. Vehicle mods data and design inspired by Vehicle_SR4 by Zsolt Guthy.
- Added a complete list of weapons (as described in the back of Arsenal) in the Gear_Data page.
- Added Melee and Ranged Weapon details in the Gear page, along with armor and armor mods.
- Added a Custom_Weapons page, which allows up to three custom modded weapons as per Arsenal rules.
- Added in Metavarients, Drakes, Sapient Critters and Infected races from the Runners Companion. Standard races now list racial abilities in the Qualities area of the CharSheet.
- Added the Karma Build System, and Karma Upgrades for BP created characters. If you create your character with BP, you can raise skills/attributes with Karma for post-creation upgrades. You can also elect to build with the Karma Build System, as described in Runners Companion.
- Traditions and Adept paths by Kairo.
- Initiation w/ Ordeals/Metamagic
- Submersion, Paragons, Streams and Living Persona for Technomancers
- Changelings and Metagenic qualities for Surge or Metavarient characters.
- Sample of a sheet used for outputting the character data as a text file.
- Revised Cyberparts page
- Fully working Qualities Selection Dropdown that only lists qualities currently valid for your character (Metagenic, Infected qualities)
- Modular Cyberlimb support
- Stack armor into Outfits and display Calculated Armor/Encumberance and Mods nicely on the printable CharSheet page.
- Pets!!!!

(Edit: Now links to SR4CG DK Version 1w)
Click Here to Download the New Character Generator

Click here for a standalone commlink tracker. Perfect for the runner with multiple commlinks!

Please check it out and tell me what you think. I would love to hear of any suggestions/requests/bugs.

And thanks again to Autarkis, Blakkie, Harri Tusa, and others who have created part of this or inspired my work. See the Credits sheet for a complete list.

[Fyndhal]

Very nice! The one thing I found lacking in the sr4chargenbasebeta7c.xls version of this sheet was a nice printable version. This looks like it addresses that shortcoming nicely.

[cryptoknight]

It's got the metavariants... but not the changelings/surge characteristics...

However... this is awesome!

[DamienKnight]

Yeah, I just added metavarients/infected today, and decided to leave drakes and free spirits out for the moment. I believe they will earn their own sheet since they have selectable options.

[venenum]

I have but one suggestion... Do you think it would be possible to make it so you can have a meta varient infected?

P.S. What does clout attribute do I can't read the tag. Must have to do with Open Office

[Alieth]

Hey, I downloaded the file and opened it using OpenOffice, and I have error 502 in a few places. Is there anything that can solve this?

[Beetle]

Hey, I downloaded the file and opened it using OpenOffice, and I have error 502 in a few places. Is there anything that can solve this?

it's an error related to a Macro. Just something OO can't read. Better off sending in a bug report to the people that make Open Office and seeing if they can help you.
Running 2.2.3 on a Mac.

what I've played around with works great so far. Haven't dove into the gear sections yet though.

[Alieth]

it's an error related to a Macro. Just something OO can't read. Better off sending in a bug report to the people that make Open Office and seeing if they can help you.
Running 2.2.3 on a Mac.

what I've played around with works great so far. Haven't dove into the gear sections yet though.

Thanks.

[cndblank]

Sweet!

Nice job.

[Kurious]

Outstanding work, W (IMG:style_emoticons/default/smile.gif) W!

And thank you for releasing it)

If I find any errors I will definitely let you know, but at this point: pure gold, $$

[Kurious]

Damn, I may have found an error (omission); though it may be my excel sheet.

Where are the adept powers (and spells, if any) listed at?

I see them on the character sheet, but not in the actual 'chargen' tabs.

[Beetle]

Thanks.

You're welcome. I ran across the 502 errors once I plugged in Adept in a couple of places. Updated to the latest stable build (2.4.1) and I still have the error. C'est la vie. Though I did adjust my security setting to allow for macros, it didn't solve the problem. I'll let you know if I find a work around for Open Office.

[gtjormungand]

Unless Unwired changed things, the Firewall attribute for vehicles should not be dependent on its Pilot program or your commlink. The firewall attribute from pilot rating only applies for Agents and IC, which a vehicle pilot is not. Instead, it should default to the vehicle's device rating or allow one to buy a firewall increase for each vehicle.

The price to improve Agents/IC/Pilot attributes should be the new cost with no refund for the original.

If any of these assumptions are actually incorrect, please let me know with specific references.

Vehicle/drone modifications would also be cool, but otherwise looks nice.

[cryptoknight]

When using Karma to improve stats... it acts very odd when improving magic.

i.e. Soft cap magic to 5... add karma to the karma log... spend karma to increase magic to 6.

When you do that... suddenly it spends build points AND Karma.

And how do I split a skill group after character creation without screwing up the original build points?

[merashin]

is it just me, or are martial arts and milspec missing? besides that this is just awesome, thanks for making it

[WearzManySkins]

is it just me, or are martial arts and milspec missing? besides that this is just awesome, thanks for making it

Many things are missing not just those.....

WMS

[raverbane]

I hope it just isnt because I am half asleep from staying up all night. But, I cant seem to find the Magic tab..

Am I missing something?

[sinthalix]

I can't find a magic tab either...

[Gamble]

Yup. It's not because my eyes are slanted. I can't find the magic tab either.

[Waya]

The magic tab only shows up if you select magician in the special box on the main sheet.

[Gamble]

Well I'll be a monkey's uncle...you're right...

Actually...it still didn't show up.

[raverbane]

Ok, I figured it out. The tab for magic is run on a script.

I have the most recent version of Excel. I had to enable scripting to get the Magic tab to come up.

My roomie has Excel 2002. He can't see it, regardless of what he sets or how low he makes the security,

So, if you wanna use the Magic tab, better fork out 150 for the most recent version of Office... hehe.

or visit your local Warez site... lol

[Gamble]

Stupid question: how did you enable the script?

[raverbane]

Stupid question: how did you enable the script?

On my far-too-expensive new version of Excel. A bar appears right above the sheet, but below the toolbars.

Has a little red shield symbol and next to it " SECURITY WARNING Some active content has been disabled " And then next to that is a button that says 'options'

Click the button and click 'enable this content'

[Gamble]

Wonder if there is a solution for us poor bastids with an older version of Excel...