[X] My Assistant

[DamienKnight]

I just finished removing Clout and fixing Magic costs for Essence Drain Infected who are Magic and then gain their infection status AFTER character creation.

Now when you become a vampire, nosferatu, etc. after character creation there is a spot below Magic where you can specify what your Initiation Grade was at the time of infection. It then calculates your new magic rating based on the Essence loss rules.

(If you are a grade 1 initiate, when you become a vampire your essence is temporarily dropped to 1, causing your max magic to be 2, so any magic built up past 2 will be lost at the point of infection.)

I also fixed error highlighting for the Post-Infection traits.

I am anxious to get this fix, and the fix to skill costs out, so I will likely be releasing a new version within a few days. If anyone has any requests or fixes they want put into version o, let me know asap.

[SpellBinder]

I must have missed the earlier post; thanks for the fix on that, Spellbinder. My cursory examination had shown me that cell, but I was afraid I might break something else and so didn't fiddle with the darn thing. Appreciate your quick response.

No worries there. And there's a simple way around the worry about breaking this (or any) spreadsheet when you start tweaking with the formulas. Always "Save As..." under a different file name than the original. I'll typically put "Test" at the end of the file name when I'm doing extended experimentation on this one. Oh, and you might want to turn off the auto save, or save the file under a new name right away else you'll run the risk of really messing up the sheet.

Then, you can also re-download the latest.

[Draco18s]

(If you are a grade 1 initiate, when you become a vampire your essence is temporarily dropped to 1, causing your max magic to be 2, so any magic built up past 2 will be lost at the point of infection.)

Just FYI, you might want a house-rule toggle on that. While I agree with the above, I have seen (and understand) the argument for having your prior magic attribute (altered by the new max essence of 5), due to the wording "has a magic of 1, or what the character had prior, whichever is higher."

[DamienKnight]

Just FYI, you might want a house-rule toggle on that. While I agree with the above, I have seen (and understand) the argument for having your prior magic attribute (altered by the new max essence of 5), due to the wording "has a magic of 1, or what the character had prior, whichever is higher."

They do keep their magic before, the full rating. Transforming into a Vampire does not inherently drop your magic rating at all.

However, having an essence of 1 until you feed could potentially drop your magic rating. The books explicitly define magic loss rules for any creature with essence loss.

These are not conflicting rules. They go hand in hand. Just make sure you initiate before getting bit.

Players who want to ignore essence loss can award themselves karma in the Karma_Log to compensate for the cost of buying their magic back up to what it was before infection. Or they can put '10000' in the new 'Initiate Grade at Infection' area, then hide the text.

[MaxHunter]

Maybe I am not reading things right, but I find that orthoskin armor bonus is not added to armor jacket or similar in the character sheet tab.

Cheers!

Max

[DamienKnight]

Maybe I am not reading things right, but I find that orthoskin armor bonus is not added to armor jacket or similar in the character sheet tab.

Cheers!

Max

You are right, cyberware does not automatically get added to armor values. This is mainly because Armor stacking rules allow for alot of mix-matching gear, so armor lists can get complicated.

Handling armor is half the reason I want a sheet to calculate for me. Its just a pain on my own... so I have spent alot of time developing the Armor Outfits functionality of the sheet.

1. Select orthoskin (i did it at rating 3 for my test)
2. Go the the gear page and in the Armor section select Armor Jacket. Armor is now 8/6
3. Add another piece of armor from the bottom of the list called 'Cyber/Bio Armor'. This will have 3/3 armor value.

Now you have on your printable character sheet 2 different pieces of armor, Armor Jacket 8/6 and Cyber/Bio 3/3. If you want to see these together as a single item on the sheet, put them together in an outfit.

4. In the 'Outfit Name' column on the Gear page, put the words 'Armor Jacket' for your Armor Jacket.
5. In the 'Outfit Name' column on the Gear page, put the words 'Armor Jacket' for your Cyber/Bio Armor.

Now go back to your Character Sheet. You will see a single piece of armor listed called 'Armor Jacket' with a rating of '11/9 [8]'. This means your total outfit provides 11 ballistic, 9 impact, and counts for only 8 towards encumberance. (Armor jacket has 8 encumberance, orthoskin has 0).

Lets say later you want to include a helmet in your outfit.

6. Add a 'Helmet' to your Armor section of the Gear page and give it the outfit name 'Armor Jacket'.

Now your character sheet still only shows a single item, 'Armor Jacket' but it contains the third piece of the set, the helmet. Total rating of 12 ballistic (8 from armor jacket, 3 from orthoskin and 1 from the helmet) and 11 impact (6 from armor jacket, 3 from Orthoskin and 2 from helmet) with [9] encumberance (jacket + helmet = 9/8 = 9 encumbrance).

The sheet automatically determines how armor outfits should stack according to the expanded armor stacking rules in the Cannon Companion.

You can have multiple different outfits. Once an Item is part of an outfit it will no longer appear in the Printable Character Sheet.

Oh, and Armor Mods (built in and Aftermarket) will also stack up in the outfit.

You can stack other types of armor such as Mystic Armor, Granite Skin, etc. by selecting them from the bottom of the Armor dropdown. They will not appear on the list until after you have purchased the Ware/Power/Quality etc.

[Tyro]

<awesomesauce>
The sheet automatically determines how armor outfits should stack according to the expanded armor stacking rules in the Cannon Companion.
<awesomesauce>

I think you mean the Runner's Companion (IMG:style_emoticons/default/nyahnyah.gif)

Cannon Companion was 3e (IMG:style_emoticons/default/wobble.gif)

Unless you're using 3e stacking rules? In that case, my apologies.

[Dakka Dakka]

He is talking about Arsenal, the SR4 Weapons&Gear book.

About Encumbrance: I don't remember, if I wrote this already, but both amror value contribute to encumbrance not just the highest one. In certain situations this may give you a higher dice pool penalty.
Example: Armor Jacket (Encumbrance 8/6) worn by someone with BOD 2:
The wearer gets -2 because his ballistic Armor is 4 higher than twice his BOD and another -1 because his Impact Armor is 2 higher than twice his BOD.
Encumbrance of [8] would only give you a -2, unless you interpret it as [8/8], which would be worse (-4).

As always thanks for the sheet and keep up the good work.

[Fyndhal]

Hi, DK, found a couple more small issues.

1) Non-Explosive Throwing Weapons don't include the +1 DV from the Adept Power Missile Mastery.
2) The Adept Power "Power Throw" has a listed max rank of 3 in your sheet, but in the book it is limited to Magic Rating in ranks.
3) If you build a Custom Shuriken, the DV does not include any bonus strength from "Power Throw."

I love this tool. Thanks so much for making it and, even more for keeping it updated!

[SpellBinder]

2) Check the Street Magic errata. Power Throw is capped at a maximum of 3.

[Fyndhal]

2) Check the Street Magic errata. Power Throw is capped at a maximum of 3.

Good catch, thanks. I guess I DO have the points to pick up Motion Sense, then. (IMG:style_emoticons/default/smile.gif)

[DamienKnight]

He is talking about Arsenal, the SR4 Weapons&Gear book.

Yeah, good call Dakka. I have played since 2nd edition and sometimes get my book names flubbed (IMG:style_emoticons/default/smile.gif)

About Encumbrance: I don't remember, if I wrote this already, but both amror value contribute to encumbrance not just the highest one. In certain situations this may give you a higher dice pool penalty.
Example: Armor Jacket (Encumbrance 8/6) worn by someone with BOD 2:
The wearer gets -2 because his ballistic Armor is 4 higher than twice his BOD and another -1 because his Impact Armor is 2 higher than twice his BOD.
Encumbrance of [8] would only give you a -2, unless you interpret it as [8/8], which would be worse (-4).

I had not interpreted the rules that way, but it certainly makes sense. Maybe you only used the highest rating of either ballistic or Impact in 3rd edition, and I was expecting that in 4th so my eyes glazed over when I read that part.

Either way, it makes more sense that a suit with lots of ballistic but no impact would have less encumbrance than a suit with lots of ballastic AND lots of impact.

I will revise the sheet to calculate encumbrance seperately for ballistic and impact, and display both values. Yay 4th edition for having more realistic encumbrance rules!

1) Non-Explosive Throwing Weapons don't include the +1 DV from the Adept Power Missile Mastery.
...
3) If you build a Custom Shuriken, the DV does not include any bonus strength from "Power Throw."

Added a variable called 'Has_Missile_Mastery'. Added a check to all throwing weapons to add +1 power if the character has missile mastery, including the 'Throwing Weapon' and 'Aerodynamic Throwing Weapon' weapon bases.

[SpellBinder]

Regarding Armor & Encumbrance, might want to make it an option like a house rule. SR4a, page 161 and Arsenal, page 44 both do state you use the higher of either Ballistic or Impact to calculate encumbrance against your Agility and Reaction. I haven't seen any errata sheets to say otherwise, and even if it's in a FAQ I wouldn't trust it.

Granted it makes sense the other way, but not everyone is going to use it that way.

[Fyndhal]

Found another one.

On the Magic Tab, cell Y2 concatenates Y4-Y7, Y10-Y19 -- somehow Y8 and Y9 got left out.

[Socinus]

Second level of Gearhead is missing

[Dakka Dakka]

Regarding Armor & Encumbrance, might want to make it an option like a house rule. SR4a, page 161 and Arsenal, page 44 both do state you use the higher of either Ballistic or Impact to calculate encumbrance against your Agility and Reaction. I haven't seen any errata sheets to say otherwise, and even if it's in a FAQ I wouldn't trust it.

If either of a character’s armor ratings exceeds his Body x 2, apply a –1 modifier to Agility and Reaction for every 2 points (or fraction thereof ) that his Body x 2 is exceeded.

I don't see how you come to the conclusion that only the highest armor type's penalty applies even if both exceed the character's BOD*2

[Draco18s]

I don't see how you come to the conclusion that only the highest armor type's penalty applies even if both exceed the character's BOD*2

Its a question of OR vs. XOR. English is not very clear in that regard, but most people who speak it assume that an "or" question is one of the XOR variety.

"Would you like cake or pie?" generally doesn't evaluate to "yes" unless you're trying to confuse someone (although valid, meaning "I'd like both").

"Either...or..." questions in the English language are almost always of the XOR kind.

"Either empty the dishwasher or clean your room."

Although I will admit that it makes sense.

If you're at 8/6 and encumbered for -1 (body 3) putting on a helmet for +0/+2 should slow you down more.

[ShadowWalker]

"Would you like cake or pie?" generally doesn't evaluate to "yes" unless you're trying to confuse someone (although valid, meaning "I'd like both").

I answer "yes" to that question every time I'm asked it. (IMG:style_emoticons/default/smile.gif)

[Draco18s]

I answer "yes" to that question every time I'm asked it. (IMG:style_emoticons/default/smile.gif)

And most people look at you and say, "Cake or pie?" don't they?

[Dakka Dakka]

I know that it is a question of OR and XOR. For me it does not make sense that once one Armor type has exceeded BOD*2 you can load up on lots of the other type without being encumbered further. Up to the point where the other type is larger than the first.

[Draco18s]

Although I will admit that it makes sense.

If you're at 8/6 and encumbered for -1 (body 3) putting on a helmet for +0/+2 should slow you down more.

[SpellBinder]

I don't see how you come to the conclusion that only the highest armor type's penalty applies even if both exceed the character's BOD*2

Just something I recalled reading, that only the higher of the two applied. Guess I misread.

[DamienKnight]

Regarding Armor & Encumbrance, might want to make it an option like a house rule. SR4a, page 161 and Arsenal, page 44 both do state you use the higher of either Ballistic or Impact to calculate encumbrance against your Agility and Reaction. I haven't seen any errata sheets to say otherwise, and even if it's in a FAQ I wouldn't trust it.

Granted it makes sense the other way, but not everyone is going to use it that way.

There is no optional rule required. The sheet tells you your highest encumbrance rating currently. After the update it will show your encumbrance for Ballistic and Impact separately. How you use those numbers is up to you.

IE. Encumbrance of [8/6] means you have 8 ballistic encumbrance and 6 impact encumbrance. If your attribute is 2, so 2 * 2 = unencumbered limit, then you have 2 choices:

Take the highest, 8, so 8-4 would be 4 points of encumbrance. Or take both 8 and 6 so (8-4)+(6-4) = 6 encumbrance points.

[Wizard_Thoarin]

Is there a way to export entered data from previous version of the sheet to newer ones? It would be nice to export a character from 1n and import it into 1o when it comes out, but I'm not seeing it unless there is something I'm missing on the hidden export_data sheet or some other sheet. Or is it an issue with Office 2007?

If there is no way to do that now, it would be nice to have that ability for future upgrades of the sheet.

Oh, and thanks for the sheet it sure makes character creation a lot easier.

[DamienKnight]

Is there a way to export entered data from previous version of the sheet to newer ones? It would be nice to export a character from 1n and import it into 1o when it comes out, but I'm not seeing it unless there is something I'm missing on the hidden export_data sheet or some other sheet. Or is it an issue with Office 2007?

If there is no way to do that now, it would be nice to have that ability for future upgrades of the sheet.

Oh, and thanks for the sheet it sure makes character creation a lot easier.

I tinkered with excel's built in XML import export features. There is even a sheet with a somewhat working version of it in the Beta versions.

What I discovered was that while the exporting worked fine, importing had a tendency to not just import cell values, but overwrite or reset their formatting or values restrictions, basically killing the sheet.