ok, for some reason it changed when I selected and then unselected one of the Exceptional Attribute qualities. So I guess, never mind.

Technically the Fomori should not have 6 min 11 max as a racial limit, but instead have 5/10 like a troll, then have Metagenetic Improvement (Body) attribute, which then raises their body to min 6 max 11.

When I introduced metavarients to the spreadsheet I did not have a dynamic Quality list that could hide/show options based on legal availability to your character, and I did not have an awesome list of Sheet Affecting qualities on the Misc page that was driving calculations.

Now that I do, I could go back and change it to work like the book. The only real problem with the current way that it works is that technically a Fomori could take the Metagenetic Improvement (Body) if they were surge and it would stack on the sheet. According to the rules they should already have that quality, so it should not be selectable.

Thanks for pointing this out Thoarin.

Edit: Fixed in version p. Also fixed error that let you select multiple "Exceptional" Attributes.

All of the weapons could do with a Book/Page reference. Anyone wanna pony up and produce a list of all items w/ book/page #?


Good idea! Done in version p.

Yes, the third was showing 0. Changed them ALL to show 'Current Nuyen', or when it is 0, 'Nuyen Remaining'.

Also, it seems Stealth, Track and ECCM were not displaying on the charsheets. Fixed in version p.


Added all bioware to the Selectable Pets Wares list. Working on coding the essence logic.

At the bottom of the Ally Spirit page is a section for 'Vessel'. Fill out the spirits Physical Attributes here, and any abilities related to the form can be added to the Vessel Notes section.

When you select the Adept power 'Improved Active Skill [Skill]', the text in the Square Brackets[] can be replaced with whatever custom text you like, without breaking the formulas. So you would select 'Improved Active Skill [Skill]' then change it to say 'Improved Active Skill [Unarmed Combat]' for example. The reflex recorder is the only ware to require custom text as far as I can tell, so it may be awhile before I spend the time coding the custom text option for it.

For now I suggest you note this in your skills section. Under you Unarmed Combat (or whatever skill you have a reflex recorder for) simply put in a skill that says 'Reflex Recorder (Unarmed Combat) +1' or perhaps 'Unarmed +1 (ReflexRecorder)'. That will put the note in a good place on your printable sheet, and leaving the skill at 0 will allow you to not have any extra karma/BP cost.

I believe this is managed (for most of sourcebooks) by Compiled Tables from Runner's Toolkit. PDF's are laying around on web...

How hard would it be to implement software bundles? Or cyberware suites, for that matter?

Cyberware suites are already implemented. On the Cyberware_Bioware sheet there's a freeform column titled "Suite" between Grade & Avail. On the Cyberparts sheet, there's a similar column just to the right of the Attributes/Armor table. You can fill in the boxes with the name of the installed suite, or just peg it with an "X" or whatever.

I'm not that familiar with software bundles at the moment, but first impression is that something similar could be done.

Thanks for the reply SpellBinder. Bobba, let me know if you need any more explanation of how to use Cyberware suites on the sheet, or if perhaps there is a way I could make it easier to notice or improve cell comments that explain how to use it.

I am not sure if I have posted anything mentioning it, but version P now has Common Use Program Suites built in.

Are there more software bundles I need to include? Please point me to a book/page and I will look into it.

Version 1p is here.

http://www.mediafire.com/file/uhzw6fpo91cp...G_DK_1p_fix.zip

Alot of neat updates available in this version, including easier cyberware selection, more modification slots on custom weapons and Bioware for pets! Please check it out and let me know what you think.

Added Category Selection to Cyberparts
Added prices for chemistry kit, shop, facility
Added Missile Launchers from Arsenal
Fixed max rating for Freeze Foam and C-Squared
Added 4 modification slots to custom weapons on the Weapons sheet
Added onroad vs offroad handling to Vehicles page
Fixed Offroad tires and suspension
Fixed some costs and ratings in the Gear Data
Added Programming Suites for Common Use Programs
Added the notation 'Houserule' in the 'Weapon Bases' section
Fixed Metavarient attributes, now they have 'Metagenetic Improvement' for attribute improvements, ie. see Fomoroi, Cyclops, Menehume, etc.
Added Bioware for Pets.

Love the spreadsheet, absolutely best chargen setup I've seen yet! Thanks for it.


That said, here is a quick bug report as I did find a problem in the spells list in the latest 'p' version as well as a couple simple formatting issues:

BUG 1: "Magic Sheet", "Spells_Selected" cell:
Current Contents: =CONCATENATE(I4;I5;I6;I7;I10;I11;I12;I13;I14;I15;I16;I17;I18;I19;I20;I21;I22;I23
)
Corrected Contents: =CONCATENATE(I4;I5;I6;I7;I8;I9;I10;I11;I12;I13;I14;I15;I16;I17;I18;I19;I20;I21;I
22;I23)
Effect: The mystery of the missing spells in the CS is solved. It was old man Jenkins the whole time.

BUG 2: AB152-154,AC152-154
Style Issue: Remove 'in between' borders.

Bug 3: H178-183
Style Issue: Add 'right' border.

Additional information: I use OpenOffice 3.3.0.

Bug: CS selection option boxes do not have any effect, print only prints the script decided 'proper' CS for your character.
Workaround: While in CharacterSheet tab, go to the coordinate dropdown box, select 'CharacterSheet#' (# being 1-6) to highlight the desired CS. File->Print. Print 'selected cells'.

I have not gone in and tried to find out the plumbing on this one, but thought I best report it anyways.

Bug 1: Good catch. Fixed.

Bug 2 & 3: What page are you referring to? The H178-183 range makes me think you mean one of the printable character sheets, but I do not see an issue in the sheet. Are you using Open Office to view this? I went and redid some of the borders on the charsheet, maybe that will fix the issue?




That is because those option buttons trigger macros, which were written in Excel 2003 vba, and are not compatible with Open Office's 'OOBasic' macro language. This is why I removed most of the macros from the sheet: They are not compatible across different spreadsheet programs.

Anyone not using Excel can simply select the area you want to print and 'Print Selection'.

I am indeed using OpenOffice 3.3.0.

Bug 2/3 was indeed the CS sheet style. I do not have Excel to compare with, but in OpenOffice the borders were missing in those places. Easily fixed.


Just passing it along, but the group I introduced the sheet to has fallen in love with it. Thanks again!

Indeed

Thanks Teal'c, er, ahem, Timelord.

An idea for a feature sometime in the future: A sourcebook checklist. I know it would be a lot of work, but if you get really bored and feel like working on something insanely complex, this would certainly fit the bill ^_^

It would be very handy for people in groups where certain books are banned.

Alternatively, updating all the book and page number citations to be accurate, and possibly adding them on sheets where they currently aren't (IIRC the hacking tab doesn't have them, for example).

The second option seems more likely.

I don't mind updating the sheet to show Book/Page reference numbers, but I do not want to dig through .pdfs and do data entry to put all of the reference #'s into the spreadsheets data pages.

Anyone can post or PM me a file with a list of book/page #s for programs and I will make it happen in the sheet. If you want me to update references for existing data, pull a list of the items from data pages in the sheet then add book/page to it.

If you pick up a negative quality after character creation, how to you note that it's not worth Build points?

How do you do a Latent Technomancer?
Do I need to drop the Latent Technomancer quality from the listed qualities and then set the special to Technomancer once the Techomancer abilities are accessible?
If I leave the Latent Technomancer quality in the list of qualities and change the Special to Technomancer it increases the Qualities BP by 5. Not having the Special set to Technomancer has an affect on the Technomancer sheet.
How do you denote the 3 free complex forms at rating 1?

If you have the quality Genetic Heritage how to do specify which genetech is the one associated with this quality?

How do you enter a custom comlink? One built by the character, not one bought off the shelf and upgraded?

I've been meaning to go through the gear section in its entirety. With book and page numbers now, that should help make it a bit easier.

For instance, Under Ammo - Mortar rounds, the Seeker entry should be gone and the White Phosphorous round should be avail 20 instead of avail 12.

There's... just... so... much.. stuff.

After character creation, build points are irrelevant. Add technomancer and ignore your build points. I would leave Latent Dracomorphosis.

For Free Complex forms, could you provide a book/page #? I have never played a Technomancer and dont know much about them.

For the nuyen cost of a transgenetic enhancement from Genetic Heritage, you need to go to your Karma_Log page, and make an entry:

Reason: Genetic Heritage, Nuyen: [add cost of selected enhancement here]


Somehow the BP/Karma total retained some CLout references in the latest version. I have replaced all links with version p_fix

Regarding the free complex forms thing, it's in the "Latent Technomancer" quality entry in Unwired, page 37, 4th paragraph of the quality:


Honestly, if using the BP system it's as easy as selecting the three complex forms and assigning them a rating of 1 in the BP column. For karmagen, just make a suitable entry in the Karma_Log for 6 karma points.

I'm pretty sure technomancer and latent drake are incompatible

You can find the rules for the free complex forms in Unwired on page 37 under Latent Technomancer. It's in the second to last paragraph.

Yeah, they are. Can't take a quality that grants a Resonance attribute when you've also got one that grants a Magic attribute, and vice versa. This goes the same for those that give you one or the other after character creation, either.

But I think DK mentioned Latent Dracomorphosis as it works a bit differently in the character sheet. Being a latent TM and taking the TM quality are the same BP cost, but Latent Dracomorphosis and actually being a Drake have different BP costs. There's a toggle box to select if you express as a Drake after character creation so it sucks up the relevant amount of karma to make up for it, and probably why DK suggested to leave it alone.

Note the

"Latent Dracomorphosis" should have been "Latent Technomancer"

I did. Just didn't really register as having any meaning.

Just me and my analytical mind.

Yeah, lack of context. Fair. Dumpshock doesn't like doing quote pyramids.

Okay, let's see here. Version P, huh? Neat. So, on to bughunting! In MS Excel 2007, no less!

CharSheet tab:

• Cell X11 pitches a #REF! error. This occurs with both regular and outfit-grouped armor.

Weapons tab:

• The following cells in the AC column fail to highlight properly when the first custom weapon does not have a smartlink: 38, 58, 78, 98, 118, 138, 158, 178, 198. This does not occur if the first custom weapon has a smartlink, if any other weapons do not have smartlinks, or if the first custom weapon is blank.
• The four additional modification slots in every custom weapon slot are not adding their costs to the weapon's total, while adding their effects to the weapon - for example, a Gyro Stabilization addition will still add six points of recoil compensation without adding an additional 3000 to the weapon's price.

Weapons_Data tab:

• The Defiance EX Shocker is listed as being a SA weapon. As per SR4A p.317, it is a SS weapon. If there is errata otherwise, then please feel free to inform me.

I'm sure I'll probably find more tiny little missed details the further I dig into it, but for now? That's it. The only things I can offer as suggestions would be to freeze-pane rows 1 and 2 and default the zoom level at 100% on the Weapons tab, to have the "prepackaged" Settings tab options be Creation Mode: TRUE and Preset Configurations: Raw, and to ensure there's no data left over in the rest of the un-hidden sheets from self-testing. But that's just, like, my opinion, man.

Apparently I started changing the encumberance value to calculate for both Ballistic and Impact, and never finished (see page 78 of the thread to know what I am going for here).

Fixed in version q.


Tricky static cell references. Fixed in q.


Fixed in q.


Fixed in q.

Fantastic bugfinding Artbomb!

I checked out the entry. Since the three free complex forms at rating 1 are only applicable to Latent technomancers, then Spellbinders suggestion works fine. I see no need to alter the sheet.



I meant to say Latent Technomancer. What you have read into it is a good point though...

Still love this thing, DK. Only issue I have these days is porting over my data to a new sheet each time. I just don't trust copy/paste to not jack up your work.

Eventually the Chummer sheet will get a full array of features and we can put this spreadsheet to rest. For now, you get to enjoy data entry practice every so often

What Chummer Sheet?

I simultaneously laughed out loud and grumbled at you, DK.

Ditto.

With having Excel myself already I've been able to write sheets for a few other games to try and help make things easier for me with them. If it weren't for your continued work on this sheet, DK, I'd've never even gotten off the ground.

In the very least, after having already peeked at the next generation it looks like I'll be able to make some editing for any personal needs (honestly I think it'd be easier in Excel for most things at the moment). Might even get me to expand on my programming skills some more.

Portability is the issue with characters from a spreadsheet. There is no easy to way export the character data from excel, short of writing a macro, which would then only work for certain versions of excel.

I want to be able to export character data into XML format, then import it into any other program, or import it into a newer version of the character generator, etc.

I dont mean to sound nihilistic, but the spreadsheet character generator is a quick fix to hold people over until a real program is written. Remember NSRCG anyone?

NSRCG was awesome ^_^

Honestly, never heard of NSRCG.

It was THE character generator program for SR 3rd edition.

Still is

I'd hardly call DK's work some sort of quick-fix, given the months of work he's put into this.

Not just me, but the whole community, and not just months, but years.

Neat! Sounds like it could be useful once it's done.

Hey, I figure all that time I've spent filing bug reports for beta MMOs has to be good for something. I'm just glad I can help.

It's extremely annoying that you can't put in custom values for contacts.

[Edit:] I'm not sure if I mentioned this already, but it's been bugging me for a while. In OO, when I enter a value for the first time in the cyberware or gear columns, and possibly elsewhere (I haven't checked thoroughly), the row height changes to .35 (from .18). Also, some cells (most notably at the top of some tabs) will sometimes become much larger than that. Once fixed manually, they stay fixed.

DK, the tooltip for the Karma Generation metatype cost still refers to Norma, Reduced and Free, when you've changed the dropdown to be High, Normal and Free.

One thing that one of my players found was there wasn't enough room for all of the gear he bought on the printout (even with the expanded gear option). Not sure if this is something other folks have found

O.o

Along the same veins, could you change the concept box on the printable sheet to be word-wrapped? Right now it extends behind the shadowrun logo.

I cannot replicate this problem in Excel. I removed some of the validation flags on the contacts with version O or P, but if the latest version of the sheet is still giving you problems with contacts there is not a thing I can do about it. Sorry


No problem. That is how they were meant to be. Fixed in version q.



This is no surprise. Most runners eventually outgrow this gear area.

For most of my characers, I just make sure to place the gear they wear at the top of the gear area so it makes it into the Gear section on the printable sheet.

If you have alot of gear and need a comprehensive list, I recommend printing the gear page. You may want to shrink the font a bit and remove highlighting, but it may be the simplest solution.

Also, you can create a very large merged cell if you like, turn on word wrapping, then set its contents to '=Selected_Gear'. This will make it display the same as the character sheets gear section, but you can enlarge it.

Also, remember that since this is a non-protected spreadsheet, you are free to resize the printable sheets. Or redesign them! In fact, if you come up with a handy design, send it to me and I will add it to the printable character sheets area.

Connection isn't allowed to exceed 6; this makes most group contacts impossible to enter.

Contacts below a certain cell don't cost anything; the sheet doensn't register Loyalty and Connection entries.

Much thanks to all involved for taking the time to produce this character sheet, it’s a really great resource!

My group’s characters consist of a fairly eclectic bunch of PCs, and in writing them to the spreadsheet, a few apparent little errors have come to light so far. Without wading through a large number of posts I don’t know if they’ve already been raised. But anyway;

• According to Runners’ Companion, Sasquatches (and other sapient critters) should receive an automatic magic rating of 1. This doesn’t appear when selecting these races on the spreadsheet.

• When building a Free Spirit, their spirit powers do not appear on the printable character sheet.

• The paranoia negative quality awards -5 BP, not -10 BP, as in the R.C.

• The uneducated negative quality is meant to double the costs of technical, academic knowledge, and professional knowledge skills. However, on the spreadsheet if appears to also effect the cost of interest knowledge and street knowledge skills too.

I hope my query helps a little way in the development of this sheet. Keep up the good work chaps; I’m really looking forward to ever more improvements to this great sheet!

Thanking you …
M

Yeah, I know....two words: turtle decker.