Upgraded Character Generator, Updated Generator Based on work from Autarkis and Blakkie Options

[Inpu]

Thanks! I know just enough Excel to get into trouble.

[Draco18s]

Thanks! I know just enough Excel to get into trouble.

My friend knows just enough Exccel to get fired (took him two and a half months to macro his job, two months of which was learning VBScript; had he had Workspace Macro he could have done it in 20 seconds). And he got fired not for having automated his job, but using it. Or rather, they wanted to fire him, but at the same time they didn't ("please, come back, you're the only person we have who's any good." "Only if I get to work from home").

[Traul]

If I may request a feature: Millspec armors deserve their own sheet. There are not enough slots for enhancements on the general armor list (IMG:style_emoticons/default/cyber.gif)

[SpellBinder]

Could it be possible to get Neoteny as availebul quality to those infected with immunity(age)

Edit: taking a look at your qualites tab, i guess the answer is no as that would reguire differenting between infcted with that quality and those who dont have it.
Propably too much work for little gain, its probaply easier for those that ruly need that to just enable neoteny for infected on that specific copy of the sheet.

I guess i should take a look myself first next time before asking stupid questions. (IMG:style_emoticons/default/smile.gif)

Maybe not as difficult as you might think. I did a quick test and found a not too hard way to get Neoteny available to those infected that are immune to aging. In the Qualities_Data tab in the row for Neoteny and that N that designates it not an Infected quality (cell J451), replace the N with =IF(OR(Infection="Banshee",Infection="Nosferatu",Infection="Vampire",Infection="Wendigo"),"Y","N"). The quality shows up at the very bottom of the list if you're of the correct infected type and works like it is supposed to. I just went off of RC, so if there are any other infected types that are also immune to aging, they'd just have to be added to the inside of the OR() part of the code.

I tried adding Neoteny at the end of the list with the Infected Qualities, but found the Selectable_Qualities_List & Selectable_Negative_Qualities_List ranges need to extend one more cell down than they really do so the quality will actually show up in the Main_Sheet. Also, the Selectable Qualities List seems to have an issue looking up the very last quality regardless of what the cell entry is, though this could be an odd glitch in my copy of Excel 2007. Never noticed this before since I've not really messed with any of the Infected qualities.

However, if you'd rather not edit the Qualities_Data tab at all then you can just manually type Neoteny into the qualities area in the Main_Sheet and it'll still work.

[SpellBinder]

If I may request a feature: Millspec armors deserve their own sheet. There are not enough slots for enhancements on the general armor list (IMG:style_emoticons/default/cyber.gif)

In the gear section there's an entry (Mods) near the bottom of the list that you can choose to expand upon the available mods for Millspec (and other) suits of armor. Everything runs from the named suit above, so you can choose it two or three times for one piece of armor if necessary.

And sorry for the double post.

[Traul]

In the gear section there's an entry (Mods) near the bottom of the list that you can choose to expand upon the available mods for Millspec (and other) suits of armor. Everything runs from the named suit above, so you can choose it two or three times for one piece of armor if necessary.

And sorry for the double post.

Thanks.

I get a small bug when stacking more than 1 (Mods) line: the third line starts from the Capacity of the second line, not the total of the first 2.

Example:

First line: Heavy millspec armor with 5 Capacity enhancements
Second line: add mods for 8 Capacity, total 13
Third line: add mods for 7 Capacity, total 20

When the third line is empty, it displays a total 8 instead of 13. When it is full it displays 15 instead of 20. It might come from OpenOffice.

Also, there is a typo with the non-linear junction detector: the price should be Rx100Y, not Rx1000.

[Thirty Second Ar...]

Just noticed something in the weapon modifications section: Adv. Safety Electro Shocker does 5S(e) damage, not 5P(e).

Edit: And for some reason it seems the integral recoil comp on the Savalette Guardian isn't stacking with any other form of recoil comp. I don't believe this is right, but if there's some erratta that says otherwise then feel free to enlighten me.

[Mäx]

Maybe not as difficult as you might think. I did a quick test and found a not too hard way to get Neoteny available to those infected that are immune to aging. In the Qualities_Data tab in the row for Neoteny and that N that designates it not an Infected quality (cell J451), replace the N with =IF(OR(Infection="Banshee",Infection="Nosferatu",Infection="Vampire",Infection="Wendigo"),"Y","N"). The quality shows up at the very bottom of the list if you're of the correct infected type and works like it is supposed to. I just went off of RC, so if there are any other infected types that are also immune to aging, they'd just have to be added to the inside of the OR() part of the code.

Anyway you could try coming up with an easy way to make it so that mystic-adepts can take an extra power point instead of a metamagic, i managed to do a hack job and get it for my mystic adept by copying and modifieng the if statemend of an other metamagic, but that makes it availebul to all magic types (IMG:style_emoticons/default/dead.gif)
And that where my excell skills ended.
I'll be very thankfull if you can even just take a look at this and give few pointers, ofcource it would be nice to get this change to official version too. (IMG:style_emoticons/default/wink.gif)

[SpellBinder]

If I understand what you're wanting to do is to take the metamagic feat "Power Point" that gives an adept an additional magic point for adept powers, and make it available to mystic adepts? If that's the case it's actually easier than you might think.

In the Magic_Data sheet, cell AM18 which should be the one that's TRUE or FALSE for the Power Point metamagic feat to be available, just change the cell code to =IF(OR(Is_FreeSpirit,Magic_Type="Adept",Magic_Type="Mystic Adept"),TRUE,FALSE). The yellow's the changed part of the code.

[Mäx]

If I understand what you're wanting to do is to take the metamagic feat "Power Point" that gives an adept an additional magic point for adept powers, and make it available to mystic adepts? If that's the case it's actually easier than you might think.

In the Magic_Data sheet, cell AM18 which should be the one that's TRUE or FALSE for the Power Point metamagic feat to be available, just change the cell code to =IF(OR(Is_FreeSpirit,Magic_Type="Adept",Magic_Type="Mystic Adept"),TRUE,FALSE). The yellow's the changed part of the code.

Thanks, apparently i made some wierd mistake yesterday, as that code is exactly what i tried to do and it didn't work, but know it worked just fine.
So it was just as easy as i thought, but i failed it anyway (IMG:style_emoticons/default/embarrassed.gif)
Now i would be nice if Damien could add that code to the official version, so that i dont have to do that change everytime a new version comes out (IMG:style_emoticons/default/wink.gif)

[SpellBinder]

It helps that I've dug in and really been messing around with excel a lot in this fashion to make similar sheets for Warmachine/Hordes & Alternity.

I really thank DK in his work in his SR4 character generator that has helped.

[Udoshi]

Hey, I don't know if anyone noticed, but this latest version broke the karmagen system. Setting the Attribute rating to 3/4/5 makes attributes cost 1 per level.

[Mäx]

Hey, I don't know if anyone noticed, but this latest version broke the karmagen system. Setting the Attribute rating to 3/4/5 makes attributes cost 1 per level.

No it doesn't, atleast not for me and i have allready made 5 characters with it and had no problems with karmagen.

[BobChuck]

How do skill specializations work?

I'm using the latest version (well, downloaded 3 days ago), and I'm trying to take skill specializations at character creation, using build Points. I put a "1" into any of the skills (say "pistols 2"), and it turns read and the next line gets buggy.

Related question: can you take multiple skill specializations during character creation? I'm having trouble with just one, but I thought I would ask, since that's what one of my players wants to do.

[Traul]

I'm using the latest version (well, downloaded 3 days ago), and I'm trying to take skill specializations at character creation, using build Points. I put a "1" into any of the skills (say "pistols 2"), and it turns read and the next line gets buggy.

It's not buggy: the next line is just there to let you write down which specialization you take.

Related question: can you take multiple skill specializations during character creation? I'm having trouble with just one, but I thought I would ask, since that's what one of my players wants to do.

You mean several specializations for one skill? Neither at chargen, neither after. If you already have a specialization and buy another one, the first one is forgotten.

[BobChuck]

No, i meant just multiple specializations in general. It seems silly to say "only one at character creation" but I didn't see any examples and the sheet was behaving oddly, so I thought I'd ask.

Thanks for explaining! I see that now that I look at the Character Sheet "for printing" page.

[Dumori]

If I may request a feature: Millspec armors deserve their own sheet. There are not enough slots for enhancements on the general armor list (IMG:style_emoticons/default/cyber.gif)

You select mod as the next armour and it will carry the mod slots over.

[DamienKnight]

I get a small bug when stacking more than 1 (Mods) line: the third line starts from the Capacity of the second line, not the total of the first 2.

Example:

First line: Heavy millspec armor with 5 Capacity enhancements
Second line: add mods for 8 Capacity, total 13
Third line: add mods for 7 Capacity, total 20

When the third line is empty, it displays a total 8 instead of 13. When it is full it displays 15 instead of 20. It might come from OpenOffice.

Also, there is a typo with the non-linear junction detector: the price should be Rx100Y, not Rx1000.

Fixed the armor mods thing, and fixed the non-linear junction detector.

Just noticed something in the weapon modifications section: Adv. Safety Electro Shocker does 5S(e) damage, not 5P(e).

Edit: And for some reason it seems the integral recoil comp on the Savalette Guardian isn't stacking with any other form of recoil comp. I don't believe this is right, but if there's some erratta that says otherwise then feel free to enlighten me.

Fixed the notes on Adv. Safety.

Integral recoil comp does not stack with Gas vents, but should stack with some other mods, like custom grip. What exact mods were you taking?

Anyway you could try coming up with an easy way to make it so that mystic-adepts can take an extra power point instead of a metamagic, i managed to do a hack job and get it for my mystic adept by copying and modifieng the if statemend of an other metamagic, but that makes it availebul to all magic types (IMG:style_emoticons/default/dead.gif)
And that where my excell skills ended.
I'll be very thankfull if you can even just take a look at this and give few pointers, ofcource it would be nice to get this change to official version too. (IMG:style_emoticons/default/wink.gif)

Mystic adepts do not have the option to get power points instead of Metamagics, and never will on my sheet. They are already powerful enough without giving them a bajillion points to own with.

Hey, I don't know if anyone noticed, but this latest version broke the karmagen system. Setting the Attribute rating to 3/4/5 makes attributes cost 1 per level.

This is working for me.

How do skill specializations work?

I'm using the latest version (well, downloaded 3 days ago), and I'm trying to take skill specializations at character creation, using build Points. I put a "1" into any of the skills (say "pistols 2"), and it turns read and the next line gets buggy.

Related question: can you take multiple skill specializations during character creation? I'm having trouble with just one, but I thought I would ask, since that's what one of my players wants to do.

Put an x next to the skill, then on the next line name the specialization. As per raw, you can only have 1 specialization for a skill at a time. You can spend 2 karma to CHANGE a specialization, but cannot have 2 specializations.



Lots of minor changes out there. I will likely be releasing the new version within the next few weeks. Let me know of any changes now if you want to get them into version L.

[Inpu]

Lots of minor changes out there. I will likely be releasing the new version within the next few weeks. Let me know of any changes now if you want to get them into version L.

Only this, really:

Printed character sheets: I love this feature to death, but I noticed a few small problems with my version. First and foremost, the programs, magic, cyberware, complex forms all goes in one square. This means that if you have a ton of programs and cyberware on the side, you often lose text. I think a good solution for this would be a side page for programs (or cyberware) like you have for the Mage. Less clutter, more likely to not lose text without having to tweak the sheet.

On the same topic, while there is a pet section I'm not seeing a pet print sheet, which can probably be dealt with in a similar fashion to the vehicle sheet. Further, on character sheet 1 and 2 it correctly identifies what lifestyle has been bought and what Docwagon contract you have. All others automatically say Luxury 1 month and Basic Docwagon.

[Dumori]

Integral recoil comp does not stack with Gas vents, but should stack with some other mods, like custom grip. What exact mods were you taking?

Is that with all guns as it should stack with a gasvent on guns that can take them also more slots on the gun mods with the ability to add some more accessory would be nice having to buy my gas vent separately is ok but a tad annoying.

[Gamer6432]

Why doesn't the Guardian's integral recoil compensation stack with Gas Vent systems?


As for features, what about letting Metavariants select Metagenetic Qualities without requiring a SURGE quality?

Only characters that have bought a metavariant
metatype (pp. 70–72) or the changeling quality (p. 73) may
choose qualities from this section.

[Mäx]

As for features, what about letting Metavariants select Metagenetic Qualities without requiring a SURGE quality?

Thats allready in as a optional rule in the options tab, dont know why its in as optional but its there.
Also tho answer your first guestion, thats most likely a house rule of his.

[Dumori]

Yeah is house rules overide every thing. Some aren't even optional.

[Thirty Second Ar...]

Fixed the notes on Adv. Safety.

Integral recoil comp does not stack with Gas vents, but should stack with some other mods, like custom grip. What exact mods were you taking?

I was checking every form of recoil comp I could think of. Foregrips, folding stocks, bi- and tripods, etc., and none of it stacked with the Guardian's integral recoil comp. The FN 5-7C, Ruger Thunderbolt, Ares Alpha, and Ares HVAR - other weapons with integral recoil compensation that is attributed to their design in some way instead of built-in gas-vent or electronic firing systems - are stacking fine. (Side note: While I was checking, I also noticed that both of the Ingram SuperMach 100 entries have their integral RC 3 mentioned in their notes but not included in their RC calculation.)

As for how the recoil should stack? Let's see what the book has to say.

[...]Its recoil decreasing design provides the equivalent of one point of recoil reduction[...]

In fact, this wording is similar to that of the FN 5-7C:

[...]The weapon's efficient design provides 1 point of recoil compensation.

And looking at the rules on Arsenal p.148, the only recoil compensation combinations that don't stack are:

• Auto-adjusting weight, bipod, foregrip, gyromount, sling, tripod, or underbarrel weight (excepting the forgrip+sling combination)
• Folding stock, hip pad, rigid stock, shock pad, or sling
• Multiple gas-vent systems (eg. Gas-Vent 3 + Gas-Vent 3 != +6 RC)
• Electronic firing and personalized grip

There is no mention of recoil-decreasing design, thus I would naturally be led to believe that the Savalette Guardian's integral recoil compensation stacks with all forms of recoil comp available to its class of weapon, in much the same way as the FN 5-7C or other weapons with nonspecific or unavailable-as-accessory-or-modification forms of recoil compensation.



...And I just realized how much of a sperglord I may have come across as. For that, I apologize. My only excuse is wanting to see Consistency! and Accuracy! in this spreadsheet - it's already incredibly useful, and stomping out bugs and filling in missing data will only make it better.

[Gamer6432]

Quick note: There doesn't seem to be a way to allow Shapeshifters to be anything other than Human. Someone posted about this back in 2008, but I didn't see a followup post. Would it be possible to add this? (Perhaps maybe in lieu of an Infection dropdown since Shifters can't be infected?)