I was using this sheet since the 1d/1h versions, and the last one I have is 1v.

I grabbed the latest version for a new character, and man what happened to the settings sheet? The one that let you change all the useful data, like karmagen?

It's still there. Just left of the main sheet.

so I converted "W" to Office 2010 and until recently I thought nothing was wrong, however i have found that when "In Debt" is selected it no longer adds the benefit to the monitary section. I also noticed that when the Magician quality is selected a tradition. I have it saved as a xlsm. I will try to save it as xlsb when I get home and see if I have any better results with those 2 errors.

I believe that is a setting in the Options tab. DK I believe has it set to NOT grant actual cash, because that would be cheating.*

*(That is: you get both money AND bp for that quality)

Runners Companion PG 105

That's the actual point behind the negative quality. You can get a little more money but you're in debt so have to pay interest every month and can't get rid of it till you pay the debt off AND pay the karma cost off.

Hey Folks, long time sheet user and advocate, new poster. I saw that there were not many request coming in and that a new request might be welcome. I see that the conversion to 2010 is forth coming and the thought that I had as an improvement would be a migration tool. To move from an older sheet to a newer sheet is time consuming, but being able to export a character, then import to a newer version of the sheet would be an anwesome feature, especially now that 5th Ed has been announced.

It's been years since I've used the sheet last (version b post-rename, I think, from late 2009), but since I'm just about to start a new PbP game (hopefully), I grabbed the most recent version (w) and rolled up two mages. I've got some random feature requests to throw out there, based on that experience.

• The amount of free contact points (from the house rule) you've used is not indicated anywhere - should be X/Y like free knowledge points, or a negative value in the Contacts cost field (not just next to it, because that shows "0 (-4)" even after I've spent 4).
• There should be a spot to input which type of spell a given focus is for (or which weapon is the weapon focus)
• The rule for Maximum Armor Modifications (Maximum rating points equal to MAX(6, Ballistic * 1.5, Impact * 1.5) ) is not implemented for items which have a capacity. This rule appears to be entirely separate from the rule about armor suit capacity, so it should display both for items like the Urban Explorer Jumpsuit.
• You also have an obsolete message about Street Magic spells on the Magic tab.

I'm really impressed by how far the sheet has come since I've seen it last. Not that it was bad before, but it's now at a level I didn't even realize Excel was capable of!

You would be correct, but DK's table doesn't play that way, and the sheet's default settings are what he uses at his table.
Go into the settings tab and just change it.

when ever a player takes this Quality I have a House Rule that it when you buy it off not only do you pay 2x Karma but 2x Cash as well...it balances

The quality is bad as written. Having to pay more would only make it less attractive. The most you can get out of it at chargen is cash worth 1-3 runs (depending on payout), but you can only spend it on items of availability 12 or less. It is a bad deal already.

Don't forget that the 10% per month does not reduce the amount owed at all. To reduce it you would have to pay more than that each month until it is gone.

Yep...10% is interest only but even with the house rule...my players take the quality all the time. I have to agree with Draco18s
that it is a bit broken in character generation

Whether or not it's broken mostly depends on whether or not the first couple of runs allows the runner to buy it off right away. Having to worry about making rent *and* paying off your loans means it can be interesting.

Unless you get 7500¥ to 45000¥ and 10 to 60 Karma in the first month you cannot buy it off. Just reducing the debt to zero and getting new negative qualities from the GM probably is not a good idea either.

@Misdemeanor: Ask your players why they think they need the extra NuYen. There are better options to get more money at chargen than In Debt. Born Rich is pretty much worry free and you can get up to 50k¥ not just 30k¥

But it uses positive quality BP limits, rather than being a minor inconvenience towards the negative quality limit.

(That is: someone might take it for the BP and just throw money at the problem during play, because the monetary cost is small compared to other negative qualities)

Another bug report: Spells in slots B24 or lower don't cost BP to buy.

Well, by the rules, there is no way to start with more than 14 spells anyways (Spellcasting 7 * 2)

I think the question raised makes a good point. Having the settings sheet be the first sheet you see when you open a new version makes things simpler for new (or returning) users.



The quality is no doubt broken, but the sheet supports the normal rule and the house-ruled version. I think I need to either:
Set the sheet to use book rules as a default, no matter my opinion of them
or
Add a hard to miss blerb at the top of the settings page that discusses the changes I have made and why, and explains how to change the settings for new users.

If I conducted a vote, I suspect the overwhelming majority would select the first option. Since my SR group has not be active for awhile, I am growing more inclined to agree. I enjoyed using the sheet as a platform to preach my opinions on the rules to people, but as the sheet grows closer and closer to artifact status (fifth edition looms brightly in The Shadows) I desire to clean the sheet up and leave it untarnished by the ebb and flow of my own personal house rulings.



While working with excel I have found some walls and some muddy spots. Character exporting has proven to be a formidable tar pit. It could be achieved through macros, but they have limited usability across Microsoft Excel versions, and no use for the Open Office advocators out there.

Along with the feeble usability of that solution, it would be a great hassle to maintain. Every cell containing character data would have to be named, and any altering of the sheet would have to be meticulously reviewed for export impact. It would produce a myriad of headaches and I want none of them.



You are correct on the armor capacities/maximum modifications. There are two rules in the books. The maximum modification rule in the SR4a book, and an optional rule for capacity in the Arsenal book. The rule in Arsenal is an alternative to the rules for Maximum modification in the SR4a book. When I implemented capacity, I made a decision that the sheet would use capacity for all gear that the capacity rule was compatible with, and all other gear would use the maximum modification rule.

In hindsight, I agree it makes sense to facilitate both options for Capacity compatible gear, but my current solution is integrated with the armor calculations. The armor section was by far the most complicated and exciting part of the sheet to design. Making armor work was a trying en-devour which I took upon myself with great gusto, fueled by my SR groups need for a better armor solution. Now that my group no longer plays, I have no desire to crack open the maze of armor calculations and attempt a re-design.

The other problems you noted seem simple enough.

My original SR group from my hometown started playing again about a year ago. I am great friends with many of them (including my older brother) and kept them updated on the sheets progress. Ultimately they ended up using Heroforge. After recovering from the blow to my ego, I asked around and have heard that Heroforge's solution for Shadowrun is very complete. It handles most of what one would need for a sheet. I am excited for the Shadowrun gaming community. Finally a professionally maintained sheet is available!

My purpose in working on the sheet was to fill a void at my gaming table. I saw many sheets out there each with their own merit, and yearned for a single sheet that did it all. Without using Heroforge personally, I am still convinced that it has filled that void. With eager gamer eyes softened by the lackluster condition of my formerly inspiring Shadowrun group, I dont see Heroforge as a villain stealing our impetus, but instead the Calvary marching proudly to our fort, relieving a battle weary militia from their noble post.

So question to every one who has worked on this wonderful project,

How will 5th edition be handled? Will the sheet be updated when the new version comes out or will that be that?

So, after some time i will upload my modified Version X. Feel free to use it and please provide feedback.

Changes:
Added setting option 'Day Job Quality Benefits', allows Job and BP or Job only
Added setting options for quality limits
Added a detailed character description sheet
Added a detailed contacts description sheet
Added a printable Matrix Cheat Sheet
Added a new Char Sheet with weapon modification display and a connection sheet
Added Ammo statistics in the weapon mod field, including rockets and grenades (Regular ammo on top, Rockets, grenades and mortar shells on the bottom)
Added Gear and Qualities from Way of the Samurai, selectable if you fulfill the conditions
Added Activesofts and Knowsofts on Main sheet, displays them on the charsheet with [AS], [LS] or [KS] in front
Displays modified Skill Ratings for Active skills/groups if you add them in the brackets (Adept Improved Ability, Reflex Recorder) - use the skill group name without the "(group)" addition (e.g. "Reflex Recorder - SkillGroup [Firearms]") Note: Case-sensitive
Included vehicle modification availability and legality
Included a modable Charisma multiplier for the free Contacts houserule
Increased the Numer of Lifestyles to 9
Sorted Weapon modifications/mods
Weapon range dp penalties change if you select the hawkeye quality
Fixed a ton of bugs, especially in the vehicle sheet
Removed the macros
Removed some vehicles (mostly tanks and flying vehicles)


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

I just had a question about where are the rules behind the drones sensor rating?
In the excel sheet it goes up to 10. Can someone tell me where the rules are to support this?

War! probably.

Actually it is in Arsenal, in the vehicle modification section.

I really hope there are plans to finish off the generator. Of all the SR4 generators I've used, this one is the best so far and I'm not completely sold on the transition to 5th edition.

If there are any missing features or needed fixes for this sheet, please post them here in this forum. Perhaps Fisk or another community member will release a final update to round out the 4th edition sheet.

I obtained my 5th edition book at Gencon and I love it! Fifth has done exciting things to help with character creation, and given us some really great rules to play with. If I spend any more time working on a character generator, it will probably be in 5th edition. I highly recommend picking up the PDF and checking it out (its only $15). The hardback is beautiful though... high quality paper, beautiful artwork (the best compilation of any sourcebook yet!) and even has fold out art pages! Its a very complete book, including everything you would need to get started in SR.

I really hope you make a 5th edition spreadsheet

Ditto!

And thanks!

I know 5th is out now, but I do have two requests for this 4th sheet:

1. I noticed that items from Attitude seem to be missing
2. It's lacking a financial/ID page for managing IDs and investments and the like (see Wordman's character sheets for an example of what I mean)

The smartframe running Mediafire is confused! When I try to download (specifically) SR4CG_DK_Commlink_incPirated.zip ...
Maybe because of the word "pirate" in the file name?