[X] My Assistant

[SpellBinder]

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.

[Thirty Second Ar...]

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"

[cndblank]

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.

[Mäx]

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.

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.

[cndblank]

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.

[Tyro]

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 (IMG:style_emoticons/default/frown.gif)

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

[SpellBinder]

If you hate freeze panes, you can disable them.

In MS Excel 2003:
Window->Unfreeze Pane

In OpenOffice:
Window->Freeze (to uncheck the option)


In MS Excel 2007:
Review->Unprotect (if sheet is protected)
View->Freeze Panes->Unfreeze

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

[Trisha_Nixon]

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.

This post has been edited by Trisha_Nixon: Dec 28 2010, 09:05 PM

[bobbaganoosh]

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

[SpellBinder]

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

[DamienKnight]

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.

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

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.

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.

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

[Trisha_Nixon]

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.

[Trisha_Nixon]

Bugger ... double post.

This post has been edited by Trisha_Nixon: Jan 6 2011, 04:35 AM

[DamienKnight]

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.

Added it to N. Thanks for finding that.

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"

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

[Thirty Second Ar...]

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! (IMG:style_emoticons/default/grinbig.gif)

[Jhaiisiin]

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.

[DamienKnight]

For one, Hardliner Gloves should deal physical damage, not stun.

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

I am making a Class III Changeling Troll Common Drake Adept. [...] I think that there are some issues with calculating Unarmed Combat damage, because I have a strength of 5 (11 in dracoform), +2 from bone spikes, +1 from martial arts, and critical strike 6. The reach and AP are both correct, but the damage is listed as 10S and 13P in dracoform, when it should be 12S (or 13P with Hardliner Gloves on, which are listed separately on the sheet as doing 5S) and 17P in dracoform.

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.

There also seems to be a bit of difficulty calculating my move speed. I also have the Celerity quality, so my move speed should be 15/25 * 1.5 (round down) as a troll, and 15/25 * 3 in dracoform. Unfortunately, the only speed it gives me is 22.5 for the troll walking speed. The rest are simply replaced with "##.##".

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.

Started playing with it today and couldn't get the "Efficient Dice Roller" to roll a glitch with 2 dice (which should be pretty common). I tried ... well I don't want to tell you how much time I wasted trying ... many times w/o success. The verbose roller seemed to work fine. Also, it could have been odd luck, but it was rolling an inordinate amount of successes when I chose 2 dice: over half my rolls were 2 out of 2 with the efficient dice roller. When I chose 100 dice, however, it seemed to work just right (about 1/3).

Tab "Initiation_Group", Cell F17 there is a typo "Max Initiaion Level" should read "Max Initiation Level"

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!

[Mickle5125]

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

[Dakka Dakka]

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.

[DamienKnight]

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.

[Magusinvictus]

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!

[ShadowWalker]

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?

[SpellBinder]

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.

[ShadowWalker]

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.

[SpellBinder]

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.