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

[Korwin]

The Spirit Pact Quality is only possible with 1 Edge? Why?
Would it be possible to get the Spirit into the Excel?
So we can see, how much Edge the Spirit needs to be able to grant his pact bonus.
(Using the Street Magic rules)

[Korwin]

Martial Arts should come with Maneuvers included, right? (2 per 5 BP)
Currently it subtracts 1 BP per Maneuver. I think it comes from the optional rule (MA is not an Quality).

[DamienKnight]

Martial Arts should come with Maneuvers included, right? (2 per 5 BP)
Currently it subtracts 1 BP per Maneuver. I think it comes from the optional rule (MA is not an Quality).

Please see Arsenal P. 158. The sheet uses the rules there for Martial Art Styles and Maneuver costs. The only thing the 'MA is not a Quality' optional rule does is allow the player to purchase martial arts qualities without it counting against their quality limit.

[Korwin]

I see it now, the cost gets shifted from Qualitiy to Skill, since I use an HR where Skills cost are halfed, I got an discrepancy.

Need to reread Arsenal (german edition), I was pretty shure two techniques (per 5 GP) where included in Martial Arts.

[Mäx]

Need to reread Arsenal (german edition), I was pretty shure two techniques (per 5 GP) where included in Martial Arts.

Nope, you just can buy to maneuvers per one martial art quality costing 2BP per maneuver.

[Korwin]

Would it be viable/possible to seperate the mods and accesories for customizing weapons?
At the moment I only get confused if I try to see what I did to a weapon.

Another question in this vein.
Is it working as intended, that some Mods show up as needing Slots, but not all get counted in the Slots used field?
(like Metahuman Customization)

Ah, the first 5 are counted, the ones afterwards are not...

[DamienKnight]

Would it be viable/possible to seperate the mods and accesories for customizing weapons?
At the moment I only get confused if I try to see what I did to a weapon.

Another question in this vein.
Is it working as intended, that some Mods show up as needing Slots, but not all get counted in the Slots used field?
(like Metahuman Customization)

Ah, the first 5 are counted, the ones afterwards are not...

Fixed in version u so that all weapon mods count against slots used. Thanks for finding this!

[Draco18s]

My mage is unable to select Shielding as a metamagic. I've traced this down to the metamagic having the designation S (for Spellcaster) where the metamagic's cell's formatting checks to see if AB38 <> AB37 (AB37 is M for mage and can never be an S). So when M isn't S, it sets the cell to be yellow.

Bwuh?

[Makki]

Free Knowledge points and free Connection points (with house rule) should be calculated with the original attributes from chargen. Instead they use the values that might have been increased after creation with karma during char development.
Might be a problem with creation mode on/off

[Draco18s]

Might be a problem with creation mode on/off

It is, I just raised my logic from 2 to 4 under the "raise" column with karma and my KSBP stayed the same.

[DamienKnight]

Free Knowledge points and free Connection points (with house rule) should be calculated with the original attributes from chargen. Instead they use the values that might have been increased after creation with karma during char development.
Might be a problem with creation mode on/off

This is a result of the multi-purpose nature of Cells Q3 - Q12 on the Main Sheet. The original character generator this one was based off of simply catered to the BP system, which meant any values in Q3-12 were karma raises after character creation. When I upgraded the sheet to allow for building with the Karma Gen system I repurposed the Karma raise column to also serve as the karma base column.

If I were to design a new sheet from scratch, I would create a page dedicated to attributes which had dozens of columns, allowing players to track the history of changes to attributes over time. As the sheet is in its current iteration, there is no way to distinguish between base attributes and raised attributes when building with the karmagen system.

As far as BP building is concerned, the free knowledge points will not be affected by Karma raises after character creation. I updated the free contacts so they will do the same, in the BP system they will not change when attributes raise.

The only possible solution (aside from a redesign of the attributes area) is to have a cell that contains your free knowledge points, which gives the player an opportunity to override the default values with a static amount, so it is not changed after character creation.

For now, if you are concerned about free knowledge points changing, you can unhide the MISC_DATA page and edit the Free_knowledge_BP cell with whatever value you like.

[Draco18s]

Any word on this, Damien?

My mage is unable to select Shielding as a metamagic. I've traced this down to the metamagic having the designation S (for Spellcaster) where the metamagic's cell's formatting checks to see if AB38 <> AB37 (AB37 is M for mage and can never be an S). So when M isn't S, it sets the cell to be yellow.

Bwuh?

Fiddling around, looks like it needs to be OR(AB38 <> AB37, AB38 = "S")

[DamienKnight]

My mage is unable to select Shielding as a metamagic. I've traced this down to the metamagic having the designation S (for Spellcaster) where the metamagic's cell's formatting checks to see if AB38 <> AB37 (AB37 is M for mage and can never be an S). So when M isn't S, it sets the cell to be yellow.

Bwuh?

When I create a Magician I am able to select shielding. Did you create a Conjurer?

A = Adept Only. Only Adepts can select this MetaMagic
S = Spellcasters Only. Only Mystic Adepts, magicians, or anyone who has Spellcasting ability can select this metamagic.
C = Conjurers Only. Only Mystic Adeppts, magicians, Conjurers or anyone who has the ability to Conjure can select this Metamagic.
M = Magician Only. Physical Adpets cannot select this power, only Magicians, Mystic Adepts or other magician types can select this power, regardless of Spellcasting/Conjuring ability.

Can you describe your magic type, any qualities related to that, and what other metamagics you have already selected? I cannot recreate your error.

[Draco18s]

When I create a Magician I am able to select shielding. Did you create a Conjurer?

A = Adept Only. Only Adepts can select this MetaMagic
S = Spellcasters Only. Only Mystic Adepts, magicians, or anyone who has Spellcasting ability can select this metamagic.
C = Conjurers Only. Only Mystic Adeppts, magicians, Conjurers or anyone who has the ability to Conjure can select this Metamagic.
M = Magician Only. Physical Adpets cannot select this power, only Magicians, Mystic Adepts or other magician types can select this power, regardless of Spellcasting/Conjuring ability.

Can you describe your magic type, any qualities related to that, and what other metamagics you have already selected? I cannot recreate your error.

I did not take aspected magician.

I am a shapeshifter (eagle), with the magician quality, and the Path of the Wheel mentor spirit (bonus to combat and health spells). My spellcasting skill is 4 (conjuring 1).

It is also my first metamagic (I haven't earned it yet, I was pre-planning, working on the ordeal right now; no group).

The AB38(?) cell that says what magic user I *am* is an M (the metamagic is an S).

[Draco18s]

I did not take aspected magician.

I am a shapeshifter (eagle), with the magician quality, and the Path of the Wheel mentor spirit (bonus to combat and health spells). My spellcasting skill is 4 (conjuring 1).

It is also my first metamagic (I haven't earned it yet, I was pre-planning, working on the ordeal right now; no group).

The AB38(?) cell that says what magic user I *am* is an M (the metamagic is an S).

Downloaded the latest sheet, just to make sure that it still had this issue. It did, so here.

For the rest of you:
I was kind enough to drop this on megaupload.

Seriously. Free anonymous email accounts are not that hard to get.
(I previously mentioned mailinator, but apparently the site DK used filters them, so I used Hide My Ass)

[DamienKnight]

I did not take aspected magician.
I am a shapeshifter (eagle), with the magician quality, and the Path of the Wheel mentor spirit (bonus to combat and health spells).
My spellcasting skill is 4 (conjuring 1).

It is also my first metamagic (I haven't earned it yet, I was pre-planning, working on the ordeal right now; no group).

The AB38(?) cell that says what magic user I *am* is an M (the metamagic is an S).

First, I updated the link in my signature to point to your megaupload link. Thanks for that.

Where are you getting that cell AB38 determines your magic type? What sheet are you seeing that on?

The Metamagic list on the Magic_Data page does not compare the required code to another code, it tests against status variables:

=IF(AN22=TRUE,FALSE,IF(AND(AM22="",AP22),TRUE,IF(AND(AP22,AM22="A",Is_Adept),TRUE,
IF(AND(AM22="S",Is_Spellcaster),TRUE,IF(AND(AM22="C",Is_Summoner),TRUE,
IF(AND(AM22="M",OR(Is_Spellcaster,Is_Summoner,Is_FreeSpirit)),TRUE,FALSE))))))

When I created a character with the details you listed above:

Is_Adept = FALSE
Is_Spellcaster = TRUE
Is_Summoner = TRUE

I was able to select the shielding metamagic without any trouble. What program are you using to open the sheet?

[Draco18s]

First, I updated the link in my signature to point to your megaupload link. Thanks for that.

Where are you getting that cell AB38 determines your magic type? What sheet are you seeing that on?

Magic sheet, AB38* is cell used for the conditional formatting of the first metamagic cell color (along with AB37).

The Metamagic list on the Magic_Data page does not compare the required code to another code, it tests against status variables:

=IF(AN22=TRUE,FALSE,IF(AND(AM22="",AP22),TRUE,IF(AND(AP22,AM22="A",Is_Adept),TRUE,
IF(AND(AM22="S",Is_Spellcaster),TRUE,IF(AND(AM22="C",Is_Summoner),TRUE,
IF(AND(AM22="M",OR(Is_Spellcaster,Is_Summoner,Is_FreeSpirit)),TRUE,FALSE))))))

When I created a character with the details you listed above:

Is_Adept = FALSE
Is_Spellcaster = TRUE
Is_Summoner = TRUE

I will take a look at that cell here in a minute.

Edit:
This cell is performing correctly, this is not the issue. This cell says whether or not a metamagic is selectable (and false if it has already been selected). The problem is with the conditional formatting of the metamagic choice dropdown, which eventually references column AM of the Magic_Data sheet (through the conditional formatting on cell P38 of the Magic sheet, checking cells AA38 and AA37).

The rule on the relevant conditional formatting (the first of the three that cause it to go yellow-background) is thus:

=AND($J$36<>"",U38<>"",AA38<>"",$AA$37<>"",AA38<>$AA$37)

AA37 reads:
=IF($M$24="Magician","M",IF($M$24="Adept","A",""))
Which is a problem, as it only accounts for 2 possibilities (its value is "M"), and then compares to AA38, which reads:
=IF(P38="","",IF(VLOOKUP(P38,Complete_Metamagic_Table,2,FALSE)="","",VLOOKUP(P38,Complete_Metamagic_Table,2,FALSE)))
It's value computes to "S"

Thus the conditional formatting sees AA38<>$AA$37 and computes to FALSE.

I was able to select the shielding metamagic without any trouble. What program are you using to open the sheet?

MS Office 2007.

*Current sheet references AA37/AA38

[DamienKnight]

I did not realize it was a formatting issue. I thought the Shielding option was not available in the drop down. LoL!

Fixed in version u.

[Draco18s]

I did not realize it was a formatting issue. I thought the Shielding option was not available in the drop down. LoL!

Fixed in version u.

Oh, no. I must not have been clear on that. Sorry for the confusion.

[Suicide King]

Very nice sheet, makes character generation about a billion times easier. Thanks for making this!

I have one suggestion for a house rule that can be switched on or off.
Some people, us anyway, play with a rule where racial attribute bonuses are ignored for the purpuse of increasing attributes. Ie instead of it costing 15 karma for a human to raise his/her edge to 3 from 2, it only costs 10. The same as from 1 to 2. If this could be switched on or off in both karma character generation and advancement, that would be really nice.

I think it's a bit of niche request, I don't know how many people play with this rule (IMG:style_emoticons/default/smile.gif) Anyway, thanks for providing this for the community, can only imagine how much work has gone into it.

[Socinus]

Just keeps getting better and better (IMG:style_emoticons/default/smile.gif) Fantastic work, as always, Damien.

I cant seem to find the Dassault Paynal from Mil Spec Tech, did that get missed or is Mil Spec Tech not included yet?

And what is the "sg" abbreviation for the Books column?

EDIT: Found a small typo. For the Adept Power Mind Over Matter (INT for AGI), the description says "Use Intelligence instead of Agility" However Shadowrun uses Intuition instead of Intelligence.

[Xenefungus]

I have one suggestion for a house rule that can be switched on or off.
Some people, us anyway, play with a rule where racial attribute bonuses are ignored for the purpuse of increasing attributes. Ie instead of it costing 15 karma for a human to raise his/her edge to 3 from 2, it only costs 10. The same as from 1 to 2. If this could be switched on or off in both karma character generation and advancement, that would be really nice.

I think it's a bit of niche request, I don't know how many people play with this rule (IMG:style_emoticons/default/smile.gif) Anyway, thanks for providing this for the community, can only imagine how much work has gone into it.

Actually, this i a great rule everyone should at least consider. I would appreciate implementation as well (IMG:style_emoticons/default/smile.gif)

+1

[KarmaInferno]

Wrong thread, oops.



-k

[Traul]

Very nice sheet, makes character generation about a billion times easier. Thanks for making this!

I have one suggestion for a house rule that can be switched on or off.
Some people, us anyway, play with a rule where racial attribute bonuses are ignored for the purpuse of increasing attributes. Ie instead of it costing 15 karma for a human to raise his/her edge to 3 from 2, it only costs 10. The same as from 1 to 2. If this could be switched on or off in both karma character generation and advancement, that would be really nice.

I think it's a bit of niche request, I don't know how many people play with this rule (IMG:style_emoticons/default/smile.gif) Anyway, thanks for providing this for the community, can only imagine how much work has gone into it.

Let's make it +2. Great houserule.

[Seerow]

The Rocket Booster mod from Arsenal is not in the version of the spreadsheet I have. I haven't downloaded the newest version put up to check if it's there yet, but I thought I'd point this out.

It would also be nice to have a way to add cyberlimb mods on vehicle limbs such as legs for walker drones/vehicles and arms for vehicles with mechanical arms. Though I'm not sure of how you could do it without making the page really ugly.


edit: Just checked the most recent version, it doesn't seem to be there either.