Your voices are heard. I have added 'Racial Attributes Easy Raise' as a houserule. This will do as above, factoring out racial mods to attributes before calculating karma cost. It does the same for infection attribute bonuses. Look for this feature in the upcoming version 1u.

Awesome. Thank you.

A question: The bonding cost for weapon foci have been set to Force x 5. I've done some googling and can't seem to find when this was done. Is this an official errata or change? Where is it from?

In SR3 and SR4 the bonding cost for weapons was 3 + weapon reach x force. In s4a they changed that to simply 3 x force. Not sure why the sheet is Force x 5, but I have fixed that for the next version.

Due to a post I made over on the other side, could we get a checkbox/thingy for if a spell has a fetish? I've been using the notes system inside excel to keep track of it, but it would be nice if it was just a checkbox there on the sheet that would also take care of the cost too (rather than taking space on the gear sheet).

Good idea. Added a spot to mark it on the Magic sheet, and the Charsheet will show (Fetish) next to the spell. Done in version u.

Awesome.

Was there anything else? *Think think*
Oh, I noticed a weird issue (but haven't tried to repro it) with paying off debts. If you put in the full amount of the debt owed, the boxes hide themselves (this is fine), but if you then edit the paid amount below the owed again, the debt box doesn't re-show itself.

Might've been a fluke, I didn't look into it very closely

I'd also suggest some kind of debt tracking...thingy, but I don't think it's possible, due to the fact that the interest would be arbitrary based on the amount paid off (arbitrary amounts over time). So I've been using the karma sheet for the interest payments.

Only other thing I can think of is a similar box to the fetish checkbox that's filled in based on mentor spirit, as the mentor spirit is off the page for most monitors (requiring scrolling), but not a terribly critical.

Actually, Excel has been used for calculating things like loans and mortgages for *years*. I think even the MS Works spreadsheet is able to do it

That does sound like a fluke, as the conditional formatting is based on the status of your repayment, so any changes would revert the formatting back to show your debt.

I dont know about checkboxes... maybe I could track what types of spells you have bonuses for and reflect that on the charsheet?

Not in a single box it doesn't.

For example, try reflecting "current debt balance" based on the initial debt value (single box), plus "number of months rent" (single box) and "amount paid off" (single sum).

You can't. If you have 10,000 debt, pay of 2000, then a month of time passes (the player increments "months passed" in their lifestyle sheet from 0 to 1), the debt is now 8800. Now I pay off 600 (8200), and increment the "months passed" counter.

The correct value on the debt will be 9020, but there's no way for the sheet to calculate that. It'd have to know that 2 grand was paid off prior to any interest, and 600 was paid off with 1 interest calculation, and all the sheet knows is that intrest has to be calculated twice and that a total of 2600 was paid back (encompasses all values between 8954 and 9500, inclusive).



Figured.



Whatever works for you. I don't use the printable sheets.

You didn't specify using a single cell to do it, did you?

Damien, might I suggest adding a page to the workbook *just* for finances, such as debts, savings, investments, etc, kind of like Wordman's character sheets had?

The areas in question are already single cells and I noted that I was tracking it manually via the karma page, which is laid out for such things and that I desired it to be "more automated."

Awesome feedback culture here, Damien.
Something i always found was missing were the "Code of Conduct" qualities out of RC, like Semper Paratis. Did you leave them out intentionally?

Does anyone have information on this?

I think SG is the Street Grimoire.

Actually, it's Logic. Intuition is coupled with Reaction.

I'm not aware of an SR4 book named that. There's Digital Grimore and Street Magic, but no Street Grimoire that I'm aware of.

A typo in the gun list: the Defiance EX Shocker (SR4A, p. 317) fires in SS mode, not SA.

Spy Games?

Bingo!

Added Dassault Paynal. I had not added any vehicles from Mil Spec Tech yet. I added about 5 of them in version u, including the one requested. Can your runners afford these vehicles!?

sg = Spy Games

Yeah, one of my players noticed the mind over matter issue, it is fixed in the next version. Also, the sheet now calculates the difference between your base attributes and gives you a physad bonus to make the Mind over Matter abilities actually show their effect on your modified stats.

Fixed in version u. Thanks for noticing this.

Added all code of conduct in version u.

Anything about this?

Go me. Derp.

Hehe, no. I'm trying to get a game going and the character I'm playing is putting money towards buying one and fixing it up.

Thank you for adding it

Good luck with figuring out the type of those vehicles Would be nice if they put in a note about that... I took me a while to realize the tanks in mil spech tech are LAVs. That is pretty awesome.

Shameless plug: They still do. Check my link in my sig. I updated them after getting his permission.

Back to topic: Thanks for keeping up the amazing work, DK.

Love the sheet! Have been using it for a couple years now. Question/suggestion; is it possibile to put on the magic tab a section for sustained spells that adds into the character sheet much like cyberware or adept abilities? I have a mage that uses a sustaining foci to keep increase reflexes up while on runs and have just been writing it in. Just a thought.

Ooh, that's a good one.

This is a good idea. I think I would want to add in a general purpose area for mods, that had a spot for a short description. This way it could be used for spell effects, spirit effects, adrenaline temporary effects, adept attribute boost effects, or even drug effects. Since this just affects your charsheet temporarily, Ill probably add it on the charsheet page.

My players thank you as my scrawled notes have the appperance of a crippled chicken having walked through ink and onto the paper.

You must write in fairly large letters.
(I have cheekens, I knows how beeg their feets are)

I noticed that the sheet lets me take the Ascetism ordeal on two consecutive initiations. As per Street Magic, page 51, "Asceticism may not be taken on two consecutive initiation rites."

Fixed in version u. Thanks for the find.

Version u is now available.

http://www.mediafire.com/file/pauqkkhx6sk6...SR4CG_DK_1u.xls (thanks for the upload Xenefungus)

New Features:

Added prices to some software in the Gear page
Added option to Spoof the first lifestyle on the lifestyle page if Spoof Program is 5 or greater and Commlink is > average rating 3
Added movement modifier for Cyberskates
Fixed formatting issue on selected metamagic on the magic sheet
Fixed Book/page reference on adept abilities that contain custom text
Fixed weapon focus karma bonding cost
Added magical compounds from the Street Magic book
Added houserule allowing attribute karma cost to ignore racial and infection modifiers
Added option for marking spells as 'Fetish' spells.
Added error checking for consecutive Asceticism ordeals select in Initiation on the Magic Sheet
Added Situational Modifiers to the CharSheet Page to the right of the first charsheet.

The Situational Modifiers allows for attribute mods, pain resist mods (great for the drug users out there) and Run Speed mods. (Spirit movement power HOOOOO!!). You select the type, enter the bonus amount, and then put a note to describe the source (spell, armor, spirit channelling, etc.)

If someone would like to upload this to a more permanent upload site, I will link it.

Awesome Damien, thanks a bunch!

Reupped the file both at Mediafire and to my personal Dropbox for everyone's convenience.

Keep it coming!

And the first bugreport
Just wanted to try a Bear Shifter now with the cool new Attribute cost option - does not work, new value *5 is calculated still. For other races I've tried, it works though.

I'm a little curious about something.

On the Vehicles Tab, you can select sensors to add to vehicles. What does the "Def:" designation mean?

That is a question for Zsolt Guthy. He created a spreadsheet for Vehicles, and I used it as a template for adding vehicle mods to this sheet. All the mod data originated with him, with only a few additions from me since then. I dont know much about vehicle sensors, maybe an vehicle modding expert can look at the sensors and recommend some changes to the sheet?

I am not able to duplicate this issue. Can you specifically tell me which attribute you are raising, and what value you have the custom attributes set to?

By the way, this is not a new feature... it has been out for the last 4 or 5 releases.

After downloading it is saying it is not a complete zipfile. Is anyone else having this issue?

Try the mediafire link instead. It is unzipped and works.

I also noticed that you cant add Program Options to Technomancer's Complex Forms (In Unwired, it says you can add them for 2 Karma or 1 BP)

Could that be added in the next edition?

Sure. Does the book provide a list of which program options are compatible with technomancer forms?

YAY! I love me some Technomancer options

Unwired Pg 136
"Complex Forms and Program Options: Options for complex forms must be purchased at a cost of 2 Karma per program option or program option rating (1 BP per option or point at character creation). A complex form can be equipped with a number of options equal to half its rating. For threading of program options, see p. 148. Once an option is purchased, the technomancer can choose whether or not to use that option each time he uses the complex form."

Also, I noticed that High Power Chambering isnt on the list of weapon modifications.

I meant the definetely new feature "Added houserule allowing attribute karma cost to ignore racial and infection modifiers" that is called "Racial Attribute easy raise" in the sheet.

With this activated (and in KarmaGen of course), choose (Bear-)shifter as your race. Then raise your Body by one point (from 7 to . it stills costs 40, whereas it should only cost 10 because its the first point.

For normal races (like Trolls) it works exactly as expected though.

Can you reproduce that?

Maybe Shapeshifter Attributes are not stored as "racial" mods?

Quick bug report: I created a Technomancer with Karma Gen and I picked up a couple of the Common Complex Forms. On the PDF, they display as being there but at a 0 rating

Ah, I understand now. Yeah, it seems I was using the racial modifier for your attribute, instead of your Modified Minimum Attribute - 1.

Fixed. Btw, this problem was affecting any shifter with different min/max mods and infected.

Also, while I was in there tinkering around I changed Shifter to be in the Infection drop down, so you can now pick your humanoid shifted form to be any race.

I am unable to replicate this issue:
Switched to karma gen
Added 'Technomancer' quality. (kept as human)
Raised Resonance to 5.
Went and selected 5 complex forms from the 'common' category, at ratings 1 - 5.
On the Printable page it correctly displayed the ratings.

What are you doing different from me?

The metatype I had was Elf and the ratings were all 6's.

Still cant reproduce the problem. What spreadsheet program are you using?

Here's the generator I'm using, all filled out and everything.

http://www.mediafire.com/?w5aoeobrbprbq77

Any chance the Cyborg/Cyberzombie negative qualities can get added? (I've just started up a new game, and I've got one PC with Delusions and another with Claustrophobia)