Found a missing entry in the spells where the [Critter] Form (Physical) spell doesn't have it's abbreviation in the Magic_Data sheet. Comes up with #N/A for Drain without it. Don't know if any other spells are missing this at the moment.

Weapons - Custom Ranged Weapons: Underbarrel Weapon modification is supposed to halve ammo capacity in the weapon it is applied to, as it is intended to "rebuild a specific weapon into an underbarrel weapon" (Arsenal p.153) rather than to add an underbarrel weapon mounting. As of version 1m, it does not modify ammo capacity - and looking at Gear_Data, it's marked to take up an underbarrel weapon mount as well. Suggested changes to Gear_Data: Unmark CH104, add "0.5" to CR104, add "Modified into underbarrel weapon (AR p.153)" to CU104.

Main Sheet - Martial Arts: The Firefight advantage "+1 die to Defense Tests to dodge Ranged Attacks if engaged in melee.", found in the Arsenal errata document, isn't available. Suggested wording: "+1 Ranged Defense if in melee"

I would like to see some notes sections where you could enter a custom Magic Tradition or put some notes to expand on your negative Qualities.

Just a couple sections on each worksheet where you could makes some notes to provide a reminder, set up some thing custom, or help explain some thing to the GM.

Be very helpful for a GM working on a master villain.



Thanks for all your work.

If you know anythink about using excel, you can just unhide the magic tab and add a new line in the tradions list and then write you custom tradition there in same format as the other tradition are.

But it is a Microsoft product.

And it only took me an hour to figure out I had to change the range values four different places (Microsoft and my fault).

But it is working now.

Sorry if this has been brought up and answered before, but is there a way to make the top of the main page scroll normally? I'm currently using a netbook with a screen too small to use the sheet as-is; the top bit dominates 95% of the screen, and I can't get anything done

Both Excel & OO instructions would be most appreciated ^_^

Taken from the Main_Sheet itself, the comment found on a cell on the very far left (look for a little red triangle near the skills list).

I have trouble with the Cyberware_Bioware worksheet. It crashes the program every time. In previous versions, I didn't have this problem. I am using Excel 2004 on a Mac.

For the custom Lifestyle Positive Quality, Inconspicuous Housing, there's a differentiation between Matrix and Physical. I've edited my list and wonder if other users might benefit from such an amendment to a future version.

Also, I wonder why Martial Arts is a Positive Quality in the Arsenal handbook but in the Excel program, it's listed as a Skill. I would have classified it as a Skill, but since the rulebook says otherwise, I think it is best to follow suit. Anyone else have an opinion on the matter?

I enjoy using this software and am thankful to all the people who've devoted their time and energy towards it.

Any idea if/when the War! rules will be added?

Not sure. DK hasn't been on (signed in) in over a month now.

I am still alive! I have been bombarded with a combination of Baby (she is almost 5 months old and does NOT sleep through the night like the first!), a big project at work that requires extra hours, and the holiday season craziness. Also, my gaming group exclusively plays Magic now, and have not roleplayed a bit in over a month... UGGGHh! I am still here, and will make time to do some changes this month.


Yeaaaah. Dont have the book yet. Until my group starts playing shadowrun again, I am not sure I will be buying it. If there were any specific lists of items/wares/weapons etc. that someone wanted added to the sheet, just post them here and I will toss them in, trusting the community to check it for validity.



Crashing: The sheet crashes as soon as you select the Cyberware/Bioware tab, or does it not crash until you update the page? What exactly are you doing in the spreadsheet when it poops out?

Martial Arts: Uhh.. wha? It is a positive quality, not a skill. Well, the book has it as both. You have an unarmed skill, that can specialize in a certain style of martial arts (or a certain type of move like kick, sweet, etc). EDIT: Although they are sweet, I meant to say 'sweep')

Then there is a positive quality, which does not give you any skill in Martial Arts, but gives you access to new Martial Arts Maneuvers, and special Martial arts qualities which enhance your fighting in different ways, such as give you an extra die when disarming, or allowing you to draw weapons/items with a free action, etc.

It is possible to have Unarmed specialized in a martial arts style, but without actually having the positive quality. You still get the specialization bonus to your unarmed tests, you simply must fight using an identifiable style, which I suppose could be used to recognize you, but without the qualities you dont get any of the nifty Martial Arts Style Qualities.

Also, there is an optional rule called 'Martial Arts is not a Quality' on the Settings page. When this is activated, Martial Arts Qualities will still cost the same amount of BP/Karma, but they will not count toward your characters limit of starting Qualities (35 BP/70Karma).

The program crashes whenever I attempt to select a piece of cyber/bioware on the Cyberware_Bioware worksheet. I've never had any other problems with the software and I don't recall ever having any problems with previous versions but it is possible that I missed an update or two before this current version.

It was confusing to me that Martial Arts is listed as both a Positive Quality and a Skill. I read DamienKnight's previous post, looked at the books some more, and was able to figure out what I was getting wrong. I'm sorry and thanks for helpin' me out.

Bugger ... double post.

Added it to N. Thanks for finding that.



Wow, thanks for the specific fix instructions, they came in handy. Added both to N.

I can't help myself, I like being accurate, and if it means this already-fantastic sheet gets even better? Well then by god, I'll become a pedantic asshat if I have to!

Using version M, noticed that if I have more cyber than bio, and then add muscle toner, it uses half the rating to add to my stats, instead of the full rating.

EDIT: Yeah, I'm an idiot. Had rating 4 agility cyberarms. Nevermind.

Good catch. Changed Hardliner Gloves to 'P' type damage.



Added the bone spike damage into the unarmed damage calculation.

Currently I do not have Unarmed Weapons set to include Critical Strike Damage. It was my impression that they could not be stacked. If you can add 12 STR worth of DV to spiked knuckles, why cant you add that DV to a knife. If you can add it to a knife, why not add it to a sword?

The line must be drawn somewhere. If someone can find a reference in a book that elaborates on the relationship between Adept's critical strike and the damage of Unarmed w/ Weapons then I will gladly change it. Until I am convinced otherwise, Unarmed Weapons will be boosted by Martial Arts DV bonus only.



The pound (#) signs are the spreadsheets way of telling you that the new values will not not fit in the space provided. The succinct nature of the charsheet page allows only for a very small area for your run speed, which is inadequate for 3 digit speeds.

I fixed the issue by formatting the movement speed cells on the Charsheets. I changed them to a number type with 0 decimal places, forcing them to round the speed up. Then I centered the text, and choose 'shrink to fit'. Finally I changed the font from Arial 9 to 'Agency FB 10', which displays a readable narrow font.



The efficient dice roller does not count glitches. Good point, I will add that feature.

As for your odd luck... blame the computer. I double checked and all of the dice rolling scripts are using the same logic, which contains a loop that re-Randomizes the random number generator for each die roll. The dice will be about as random as you can get on vbscript.

Fixed the mispelling on the Initiation page. Thanks for the error reporting!

Where'd the Chameleon Cloak come from in your character generator?

IIRC It's a houserule item. I thought it had the camouflage properties of the chameleon suit but without the armor, so that you could wear it over every other clothing/armor.
But it seems to be the same thing as the suit in cloak form.

Yes, its basically a flavor item. Offers the exact same as the suit, but in cloak form. Fine for people willing to walk around in cloaks, but a little campy for most. We also houserule that characters performing stunts/acrobatics cannot receive the full effect of the cloak, but you can load more gear under a cloak(like an SMG) so its a tradeoff.

Hello chaps!

Just started using this sheet for a new campaign, so thanks for a great resource!

Maybe I’m just missing something, but here is quick query;

When building a free spirit character, how do you make the spirit powers appear on the character sheet? I see it’ll work if you select Adept or Mystic Adept from the “special” drop down box on the main sheet, but is there a more legitimate way of doing so?

Thanks again!

I've been looking at the data in order to try and understand how the mechanics of this sheet work and I've found some items with the race data that I don't understand.

The following races have two attribute values listed for the corresponding attribute:
Pixie: Edge: 0/1
Eagle Shifter: Willpower: 2/3
Leopard Shifter: Agility: 4/2
Jaguar Shifter: Agility: 4/2
Tiger Shifter: Agility: 4/2
Lion Shifter: Agility: 4/2
Bear Shifter: Body: 6/7
Bear Shifter: Strength: 6/7
Free Spirit: Body: 1/0
Free Spirit: Agility: 1/0
Free Spirit: Reaction: 1/0
Free Spirit: Strength: 1/0
Free Spirit: Charisma: 1/0
Free Spirit: Intuition: 1/0
Free Spirit: Logic: 1/0
Free Spirit: Willpower: 1/0
Free Spirit: Edge: 1/0

I can't find any mention of two values in the Runners Companion. I can certainly understand the shifters having some none animal form attributes being higher in their non-animal form. I just can't find any mention of it in the rules. So is there some other reason for these values being present?

Normal attributes have a six point range, running from 1 to 6 for humans and most other attributes for others for example. If there's just a single digit there, it modifies the minimum attribute and sets the maximum six points higher for a normal range. If it's fractional, it sets the minimum up by one plus the denominator but sets the maximum up by six plus the numerator instead of strictly six points higher than the minimum. Since attributes are a minimum of 1, negative numbers reduce the maximum attribute instead.

It's a mechanic of how DK has the sheet so it works, and not something you'll find in the books.

ok, so I just found the bit about edge. All Sapient critters have a max 5 of except pixies which have a 7. It doesn't say anywhere that they get a -1, or a +1 like it does for humans.
So Centaurs, Naga and Sasquatch all start with 1 edge, and have a max of 5, but pixies start with 1 and have a max of 7?
And for the Shapeshifters, using the Eagle as an example it gets +2 to willpower, but it's max gets +3? Is this the correct way of reading it?

Do the Shapeshifter or Draco Form attributes change at all when they are in their different forms? I know some powers are not accessible, equipment etc, but do the attributes themselves change?

The free spirit one doesn't make sense at all though. They start with a force of 2, and all attributes are equal to the force, and if I understood what I read they then have to increase force with BP to then be allowed to increase each attribute individually.

Again it's the mechanics of how the sheet works for some of this. And per Runner's Companion, yes, sapient critters have an Edge range of 1 to 5, except the Pixie which has a range of 1 to 7 (see page 84). The -1 you see in the Race_Data modifies the maximum Edge down, while the 0/1 for the Pixie modifies just the maximum Edge up. If the Pixie was set to 1, it would have a range of 2 to 7 for Edge, just like a human does.

As for your example of the Eagle, it sounds like you're getting on the right track.

Per Runner's Companion, page 86, the attributes of shapeshifters don't change between their human or animal forms. Dracoforms, however, do gain a bonus to some of their actual physical attributes when in dragon form and you'll see a new column appear on the Main_Sheet when you choose a dracoform type that gives you the modified numbers. You'll find those numbers in Misc_Data.

I've honestly not messed a whole lot with free spirits in general. For certain they don't follow normal character creation.

Thanks, figured most of this out, even figured out where the dracoform attribute bonuses were hiding.
Do those bonuses add to current stats increasing ones maximum as well as augmented max? How about a troll/western would it be larger and have +2 reach or +1? Playing with the sheet it looks like 2.

It definitely gets a +2 reach. And ends up with pretty stats. I think there was another topic somewhere that said the changes carry over, because not only are you a western drake, but a troll western drake. So, yeah.

Drakes get a bonus that is not an augmentation, but does exceed racial maximums. Think of it as being the same as a human "shapeshifting" into a troll: current, maximum, and augmented all rise.

setting the sheet to troll/western it doesn't look like the augmented max increases. The base numbers are 5/10 9[9] 5/15. I'm guessing that the augmented for draco form is just not showing, as you would need a 4th column for that.

If the character has any kind of augmentations, like from bodyware cyberware, bioware, or adept powers, the augmented physical attributes show up in the braces. Thus a troll/western Adept with the Improved Attribute (Body) power at level one would have a Body of 9 [10] in the dracoform column (which is what you would use while actually in your dracoform).

Small typos in the background tab:

out (question 1, word 5) should be our.
hight (question 1, sentence 2, word 5) should be height.
likley (question 4, sentence 2, word 2) should be likely.

Have some Qualities been left out for some reason? Because I can't find Trust Fund (Runner's Companion, p101) anywhere.

Try selecting a SINner negative quality first. It is a requirement of the quality.

Thanks, didn't think of that. Thought it'd just highlight Trust Fund as an error til you took the SINner quality.

Rumor has it that Hero Builder is adding support for Shadowrun 4th edition. If anybody gets a chance to try it out, please post your thoughts. Maybe they will have a full featured program and we wont need this bulky spreadsheet anymore!




When you select 'Free Spirit' for race and 'None' for Special, you should be able to select free spirit powers from the Magic Page.

They have stated the first incarnation will only have the sr4a book, and the other books will be added over time.

But I like your sheet!

Seconded - and, this spreadsheet? It can be user-modified with only minimal hassle! =D

It will most likely take at least a year, possibly even more, before Hero builder is in an usable condition.
The initial release only includes the core book, IIRC.

I just noticed the link to my sample character archive redux on the Settings page. I'm honored.

I do intend to get back to that project, by the way; my personal life has been... interesting of late.

[Edit:] Sangrey Acero should be Sangre y Acero (Blood and Steel).

Found an error in the naga stats. Its reaction in your sheet is listed as 1/5, but in RC pg 84 it lists the range for a naga's reaction attribute as 2/7.

Ideally I wanted to change the mobile sheet to match a format used for character posting in forums. Seems redundant to have to retype your char information into a post after having it in a spreadsheet.

Your thread is great. Making characters is what the sheet is all about.

Also, updated Sangre y Acero, thanks for the edit.



Good catch. Fixed in upcoming version n.

That means a lot, coming from you. I've been building characters as a hobby for years, all the way back to AD&D as a kid. Your sheet has made my hobby much easier and more enjoyable than it otherwise would have been.

Hoorj, more bug reports for version 1M. Mostly missing prices and a handful of spelling errors.

Gear: Survival - Toxic Environment
• Mitsuhama EE Suit has no cost, should cost 1500¥.
• Radiation Film Badge should cost 25¥.

Gear: Survival - Space
• Evo HEL Suit has no cost, should cost 3000¥.
• Secuirty Spacesuit has security misspelled, and should cost 25000¥.
• Spacesuit Maneuvering Unit has no cost, should cost 2500¥.

Gear: Security - Equipment
• Barbed Wire 1 roll 10m has no cost, should cost 15¥.
• Concertina Wire 1 roll 10m has no cost, should cost 20¥.
• Electric Wire 10m has no cost, should cost 10¥.
• Laser Trip Beam, Infared has infrared misspelled, and should cost 50¥.
• Laser Trip Beam, Visible has no cost, should cost 25¥.
• Monowire 1m has no cost, should cost 1000¥.
• Pressure Mesh/Pads 10 sq m has no cost, should cost 200¥.
• Proximity Wire 1 doorway has no cost, should cost 500¥.
• Security Lighting,Active Infared is missing a space, has infrared misspelled, and should cost 50¥.
• Security Lighting,Regular Lamps is missing a space and should cost 25¥.
• Security Lighting,Ultraviolet is missing a space and should cost 30¥.

Gear: Sensors
• Barometric has no cost, should cost 200¥.
• Liquid Analyzer has no cost, should cost 2000¥.
• Radiation has no cost, should cost 100¥.
• Thermometric has no cost, should cost 20¥.

Gear: Survival - Parachutes
• HALO has no cost, should cost 2000¥.
• Low Altitude has no cost, should cost 120¥.
• Standard has no cost, should cost 500¥.

Gear: Electronics - Options
• Chemical Seal has no cost, should cost 200¥.
• Datalock Module has no cost, should cost 50¥.
• Fiberoptic Cable 1m has no cost, should cost 5¥.
• Hardening R (1-6) is highlighting as incompatible with Electronics - Options, and is listed on Unwired p.199 as a commlink modification.
• Mesh Tags has no cost, should cost 2¥.
• Optical Tap has no cost, should cost 100¥.
• Simdeck has no cost, should cost 1000¥ - though Unwired lists the cost as 1000¥+, entering this verbatim would throw off calculations in the sheet.
• Skinweb Array has no cost, should cost 200¥.
• Wireless Adapter has no cost, should cost 150¥.

Gear: Nexus - Hardware/Software
• All options are throwing #VALUE! for cost, due to how cost is calculated for these options.
• All firewall and system options are throwing #VALUE! for availability, due to how availability is calculated for these options.
• My personal suggestion would be to move this whole group from Gear to Hacking, either as additional cells below where an AI's innate programs are displayed, or as a second hardware column to the right of the Comlink dropdowns. Either way, this may be beyond the scope of an incremental version upgrade. Edit: I can't rejigger the calculations or anything, what with my lack of experience with Excel, but if anyone would like a layout to work calculations into? What I have so far is on Megaupload. Note that this is a NON-FUNCTIONAL EXAMPLE, and should NOT be considered a final version of anything.

Gear: Nexus - Pre-packaged
• Evo Mobile Terminus has no cost, should cost 10000¥.
• MCT Sentinel has no cost, should cost 30000¥.
• NeoNET Office Genie has no cost, should cost 15000¥.
• Renraku Hotspot has no cost, should cost 5000¥.
• Renraku Retailer Hub has no cost, should cost 6000¥.

Gear: PAB Units
• DocWagon Cleansweep has no cost, should cost 8000¥.
• Interneurox G_Series Memory Master has no cost, should cost 13000¥. That underscore should be a dash, by the way.
• MCT MemEdit III Suite has no cost, should cost 10000¥.
• Renraku MR-X ASIST Reprogrammer has no cost, should cost 20000¥.
• Sony 800AL Field PAB Unit has no cost, should cost 6000¥.
• Transys-Neuronet MES Grand has no cost, should cost 16000¥.

I think I'll call it quits for the night on the bug-hunting. So freaking tedious, but worth it in the long run.

As an avid user of the sheet, many thanks!

Well, I just used this program to make the Mark I character for a game that will hopefully happen. I use OpenOffice.org Office Suite, and have had few, if any troubles. Aside from having no idea how to print out an actual sheet rather than a whole podge of everything. ('Coruse, I don't use that part of the suite that often, so it might be something simple.).

Much thanks to the creators and updaters and all the other folks involved in this project!

There's a good fillable PDF character sheet here if you don't mind re-entering information.

I'll just put it into a paper character sheet.

Luddite

Pencil is easier to adjust than laser toner.