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

[Caadium]

As a mystic adept, your Adept powers are listed in the multi-purpose box in the CharSheet. The level you have in '--Mystic Adepts-- Sorcery/Conjuring' should tell you how much magic is available for spellcasting. The only other factor may be Power or Spell foci that are bonded, but which may or may not be active.

What he's talking about is having the value from that "Mystic Adepts -- Sorcery/Conjuring" show in the main page and the charsheet. These are what he uses when playing and he has misrolled because he just looked at the Magic Attribute, but thats what what is rolled for spell-casting.

On the CharSheet it might not be as big of a deal, because you can see the listed adept powers and thus the number of points put into this. He is mostly talking from the standpoint of someone that doesn't print the character out, but use a laptop (or something) to use the excel file as a charsheet in game. With that in mind, he put a box on the main page to see what his magic rating is for the purposes of spellcasting and also a box to track current edge.

At least that is my understanding of his request.

[DamienKnight]

Version 1h is available here.

Version 1h includes:
- Adapsin support
- Phenotype adjustments, including a functional Genetic Optimization for all attributes
- Fixed issue with Vehicle speed/accel mods not stacking correctly
- support for Lingo's in the Language/Knowledge area
- Home Node in the Lifestyles area for AI Characters
- a printable Technomancer Sheet!

Please try out these new features and let me know what you think.

Lingos can be placed under Languages or Knowledge skills. Simply include the word 'Lingo' in the skill name, and select BP spec or Karma spec to denote how the Lingo was purchased.

Adapsin should only affect cyberware installed AFTER the Character underwent the adapsin treatment. To specify which wares were installed POST adapsin, a new column will appear on the Cyberware/Bioware page when Adapsin is added. Place an 'x' in the new column to denote wares installed AFTER the Adapsin treatment to get a 10% essence discount!

Credit for this upgrade goes completely to the community. Everything added was in response to posts in this Thread. Thanks Dumpshock!

[SpellBinder]

Wow, way faster than I expected. Thanks!

[Tachi]

can anyone tell me if it's possible to make the skills list print more skills on the actual character sheet - or print in columns?
one of my guys is playing a skills heavy advisor/face character and there's just not enough room

The only way I've found so far is to use a smaller font in that particular field. 4pt is about the minimum at which you can still read it when printed. Yes, I realize that MS Office 2007 doesn't list the font down to 4pt, just type it in manually instead of selecting it from the drop box while the field is selected. I have yet to find a way to make it into columns.

[Tachi]

DK

Sorry i skipped out after our earlier discussion on character sheet changes. I've been offline and writing term-papers. Just downloaded, 1h, give me a few days to play with it and I'll get back to you with some ideas.

BTW

Some of the changes I've been using are:

In the Damage resistance fields of the charsheet,

in # + Armor I changed the script to:
=modBody+Cyberware_Bioware!$O$34+modNaturalDamageResist&" + Armor"

and in the detail listing right after it I changed the scripts to:
=CONCATENATE("Body(",modBody,")+Ware Dmg Rst(",Cyberware_Bioware!$O$34,")","+Nat Dmg Rst(",modNaturalDamageResist & ")")

If you reduce the font size slightly, it fits just fine, and I think it's calculating correctly.

I changed the last line of the armor table to show the total cyber/bio armor.
First field just displays "Cyberware/Bioware Armor"

The second field, Bal/Imp, uses the following script:
=(Cyberware_Bioware!$Z$34)&" / "&(Cyberware_Bioware!$Y$34)

And the third field just displays "Adds to armor values above"

I'm not sure if you can use these in Office 2003 (I'm using 2007), but I just thought I'd show you some of my changes that I've been pasting into the charsheet. Honestly, I'm being kinda lazy, if you use them I no longer have to paste them into each new version. (IMG:style_emoticons/default/grinbig.gif)

[Tachi]

Will to Live positive quality is still not activating from the drop down list, you have to turn it on (TRUE it) from the data sheet. At least I do.

1h is looking pretty good so far.

[DamienKnight]

In the Damage resistance fields of the charsheet,

in # + Armor I changed the script to:
=modBody+Cyberware_Bioware!$O$34+modNaturalDamageResist&" + Armor"

and in the detail listing right after it I changed the scripts to:
=CONCATENATE("Body(",modBody,")+Ware Dmg Rst(",Cyberware_Bioware!$O$34,")","+Nat Dmg Rst(",modNaturalDamageResist & ")")

Can you provide an example where your formula provides a different total than the existing formula?

I changed the last line of the armor table to show the total cyber/bio armor.
First field just displays "Cyberware/Bioware Armor"

The second field, Bal/Imp, uses the following script:
=(Cyberware_Bioware!$Z$34)&" / "&(Cyberware_Bioware!$Y$34)

The sheet previously had a hardcoded cyberware/bioware field in the armor list. This worked fine, except when characters had armor from Qualities or Mystic armor. I replaced the hard-coded armor fields with a new system.

Go to Gear, select from the bottom of the dropdown list 'Cyber/Bio Armor'. Now you can leave it that way and it lists by itself, or you can make it part of an Outfit, or simply rename it.

You can use this same method to add Mystic Armor, Dragon Skin, Bark Skin etc to the armor list, and group them up however you want.

Will to Live positive quality is still not activating from the drop down list, you have to turn it on (TRUE it) from the data sheet. At least I do.

Thanks for pointing this out. It seems the switch is not getting flipped because the quality is named 'Will to Live 1' and the switch on Misc_Data is looking for 'Will to Live (1)'. In 1i I removed the parenthesis from the Misc_Data page's reference, and Will to Live is calculating properly now.

Wow, way faster than I expected. Thanks!

My Shadowrun group is starting a new campaign and they were making characters, so I spent a little extra time on it.

[Draco18s]

What he's talking about is having the value from that "Mystic Adepts -- Sorcery/Conjuring" show in the main page and the charsheet. These are what he uses when playing and he has misrolled because he just looked at the Magic Attribute, but thats what what is rolled for spell-casting.

On the CharSheet it might not be as big of a deal, because you can see the listed adept powers and thus the number of points put into this. He is mostly talking from the standpoint of someone that doesn't print the character out, but use a laptop (or something) to use the excel file as a charsheet in game. With that in mind, he put a box on the main page to see what his magic rating is for the purposes of spellcasting and also a box to track current edge.

At least that is my understanding of his request.

Correct.

[DamienKnight]

Correct.

Added a bracketed number next to Magic Rating on the MainSheet and CharSheet which represented a Mystic Adepts Spellcasting_Rating. This basically is just a count of their Sorcery/Conjuring Adept power. Look for this new feature in 1i.

Please note, in version 1h and several previous, the printable Magic sheet lists a Mystic Adept's effective spellcasting/summoning Magic Rating at the top.

[Mickle5125]

I'm not seeing the stone Homunculus, plasteel homunculus, or wicker man in the gear lists

[Brol_The_Mighty]

Just a quick note. The only reason I had brought up the perma infusions, was from the Mysterious Implant quality options listed on pg. 106 of RC

[estradling]

Thank you for all you work on this DamienKnight.

I found a few things on the Hacking Tab. Under Common Use Programs.

The Purge Program Cost is not included in the Programs Cost Summary Cell

For all Common Use Programs except Purge (Could not test it) the cost of the Option 1 is incorrect

For example if you buy Analyze at 6 it cost 600. If you and something like Ergonomic it should only up by 300 more for a total of 900. However it goes to 1400.

[Dwight]

Wow, this thing is still going? Glad people are still getting use out of it. Thanks to everyone that picked up the torch to keep it up-to-date.


EDIT: To be clear, I'm 'blakkie'. I haven't used that handle in a number of years now.

[SpellBinder]

Lots of use, lots of bugs (always an ongoing effort regardless of what your project is (IMG:style_emoticons/default/wink.gif) ), and lots of ideas.

And DK, any chance of having the metagenic quality Impaired Attribute expanded upon to actually reduce a select attribute's maximum by 1?

[Draco18s]

Added a bracketed number next to Magic Rating on the MainSheet and CharSheet which represented a Mystic Adepts Spellcasting_Rating. This basically is just a count of their Sorcery/Conjuring Adept power. Look for this new feature in 1i.

Thanks Damien.

Please note, in version 1h and several previous, the printable Magic sheet lists a Mystic Adept's effective spellcasting/summoning Magic Rating at the top.

I haven't opened my sheet in a while to check, but I don't recall ever having seen it before--guess I don't use that page often enough.

[DamienKnight]

Wow, this thing is still going? Glad people are still getting use out of it. Thanks to everyone that picked up the torch to keep it up-to-date.

EDIT: To be clear, I'm 'blakkie'. I haven't used that handle in a number of years now.

You should check out the most recent copy, its groovy.

Any chance of having the metagenic quality Impaired Attribute expanded upon to actually reduce a select attribute's maximum by 1?

Good idea, will do.

[Tachi]

Can you provide an example where your formula provides a different total than the existing formula?

I looked at it and found that you were right (I forgot to account for the maximum limit of 1/2 Body) in every way but one, you might want to change the "D8" in the right hand cell to "modBODY" so that it displays the modified body score from things like the Suprathyroid. Right now it just shows the natural body score and the numbers don't actually add up correctly, though the left cell (# + Armor) calculates it correctly, it just looks wrong because the right cell with the numbers listed seperately shows numbers that won't add up to that number.

For example:
=CONCATENATE("Body (",modBody,") + Cyber/Bio (",Cyberware_Bioware!$O$34,")"," + Dmg.Rst. (",modNaturalDamageResist & ")")

The sheet previously had a hardcoded cyberware/bioware field in the armor list. This worked fine, except when characters had armor from Qualities or Mystic armor. I replaced the hard-coded armor fields with a new system.

Go to Gear, select from the bottom of the dropdown list 'Cyber/Bio Armor'. Now you can leave it that way and it lists by itself, or you can make it part of an Outfit, or simply rename it.

You can use this same method to add Mystic Armor, Dragon Skin, Bark Skin etc to the armor list, and group them up however you want.

Ok, I found it. I never noticed it before, but yeah, that's a good way to do it. However, are mystic armor and cyber armor supposed to add to Encumberance?

Thanks for pointing this out. It seems the switch is not getting flipped because the quality is named 'Will to Live 1' and the switch on Misc_Data is looking for 'Will to Live (1)'. In 1i I removed the parenthesis from the Misc_Data page's reference, and Will to Live is calculating properly now.

No problem, punctuation can be a bitch sometimes.

[Tachi]

Also, is there a way to add a peice of armor, or cyber/mystic armor to all outfits?

[Dwight]

You should check out the most recent copy, its groovy.

Indeed, I saw the feature list. You've been busy. (IMG:style_emoticons/default/smile.gif) Though I'm a bit out of my element with some aspects of it since I haven't used the SR 4e system in some time and am not on the bleeding edge of supplement book rules.

The Karma build system that allows for a relatively easy living character character generator sure is something I had dreamed of back when working on that spreadsheet. Nice to see it come to fruition!

[SpellBinder]

Regarding the Adapsin, it's great that it's working now, though there's a few bugs with the current setup. One is that it seems to automatically adjusts all cyberware essence loss on the Cyberware_Bioware sheet, and the fields for the X is not selectable. Also, the essence loss for cyberware in the Cyberparts sheet does not adjust and is not adjustable in relation to the Adapsin.

Kinda why I had suggested adding it to the drop down for the "Grade" list as an extra set of options. Though it doubles the length of that list, at least it will show up for the Cyberparts sheet as well as the Cyberware_Bioware sheet. If I had known it'd be this easy to modify that part of the sheet I'd've just done it myself a good while ago. The only trick would be having the Adapsin options show up after the gene treatment. That's still beyond what I can figure at the moment.

Also, the Neoteny metagenic quality reduces a character's base body score from 8 to 6. This is not reflected in the character sheets, though I think I can write a fix for myself on this one.

Added: Complete success in fixing Neoteny/Gnome Physical Condition modifier.

Added: Dug deeper and found where the Adapsin error is. The cells for cyber essence loss check for the presence of Adapsin and re-calculate rather than trying to check the cells off to the side. Found it surprisingly easy for me to fix, and employ to the cyberparts sheet as well.

[Xerxos]

Dynamic Handprints (A257, Wares_Data)
Voice Mimic (A263, Wares_Data)

don't work right: the essence cost and availability should stay the same, while only the price should scale with rating (Wares_Data column F=C)
currently essence, availability and price scale with rating ( as if Wares_Data column F were EAC)

I can send you my the file with the error if you like

[DamienKnight]

Regarding the Adapsin, it's great that it's working now, though there's a few bugs with the current setup. One is that it seems to automatically adjusts all cyberware essence loss on the Cyberware_Bioware sheet, and the fields for the X is not selectable. Also, the essence loss for cyberware in the Cyberparts sheet does not adjust and is not adjustable in relation to the Adapsin.

Kinda why I had suggested adding it to the drop down for the "Grade" list as an extra set of options. Though it doubles the length of that list, at least it will show up for the Cyberparts sheet as well as the Cyberware_Bioware sheet. If I had known it'd be this easy to modify that part of the sheet I'd've just done it myself a good while ago. The only trick would be having the Adapsin options show up after the gene treatment. That's still beyond what I can figure at the moment.

Also, the Neoteny metagenic quality reduces a character's base body score from 8 to 6. This is not reflected in the character sheets, though I think I can write a fix for myself on this one.

Added: Complete success in fixing Neoteny/Gnome Physical Condition modifier.

Added: Dug deeper and found where the Adapsin error is. The cells for cyber essence loss check for the presence of Adapsin and re-calculate rather than trying to check the cells off to the side. Found it surprisingly easy for me to fix, and employ to the cyberparts sheet as well.

Dropdown is easier (hate adding columns for a single piece of ware). Version i will now faciliate Adapsin via the Grade column. If you do not have Adapsin, the Grade dropdown will look as normal. If you do have Adapsin, there will be extra '(Adapsin)' options for each grade. Adding it this way made it automatically compatible with Cyberparts without any extra coding in the formulas. Thanks for the Help Spellbinder.

Also, added support for Neoteny in 1i. Good catch.

Dynamic Handprints (A257, Wares_Data)
Voice Mimic (A263, Wares_Data)

don't work right: the essence cost and availability should stay the same, while only the price should scale with rating (Wares_Data column F=C)
currently essence, availability and price scale with rating ( as if Wares_Data column F were EAC)

I can send you my the file with the error if you like

Fixed those two items. Removed all 'E' characters in 'x Availability' column (This was antiquated by the + Essence column. Corrected the formulas to correctly calculate x Essence x Rating + Essence.

[SpellBinder]

I did find, in messing around to see what was up with the Dynamic Handprints and such, the essence for a Nanohive doesn't calculate correctly. The default I have for version 1h doesn't up the essence at all for the rating, and when try I fix it to calculate the essence loss per rating it adds the 0.5 and 0.25 before multiplying instead of multiplying the 0.25 before adding the 0.5 base.

One last bit on the cyberware for the moment. Would it be possible to add Suite support for the cyberparts? As far as I can put in, the cost and essence reduction works, but I have yet to figure out how to get it to coordinate the suite hardware on the character sheets.

[last_of_the_grea...]

I noticed the karma cost for attributes calculates wrong. It says I spent 365 points when I actually only spent 324.

It's a human with stats of 3, 3, 3, 4, 4, 4, 5, 6 and 8 for edge (he's lucky).

[Dakka Dakka]

In 1h, and in 1f and g as well IIRC, the headers for the Martial Arts Styles and Advantages are swapped, or the columns below are. I'd find it more intuitive to have the style in the left column and the advantage on the right.

Could you implement a way to use armor items in more than one outfit? Especially Armor underwear (FFBA) may well be used with different outfits. FFBA+Suit for social situations or FFBA+Armor Jacket+Helmet when things get messy.

I really like the new settings sheet and the mobile "printout", even though I probably won't use the latter.

You may want to think about a more neutral description for the Super Cyber Tank Armor Rule, something along the lines of "Unless TRUE, Cyberlimb Armor is averaged like Cyberlimb Attributes."

And thanks again for all the work you've done on the sheet.