It doesn´t "work" because the listed stats for the LoneStar-Suite already incorporate the Suite Modifier. The sheet would need an alternative alphaware-modifier of 7/9 that only applies for suites. 9/10*8/10 = 72/100, not 70/100. That´s either another case separation or a different table structure.

The ones I posted already have the Cyberwear Suite modifier included.

Since some of the suites have more gear included than the first in the series it is easier for me to just have all the suites listed out, then the user just choses the cyber ware suite that he wants.

WMS

Is there someplace I can upload the additions/revisions I made so far to this spreadsheet?

WMS

Can you use the IO drop that is linked in the first post of this thread? I didn't have any admin access or password at the time and was able to upload just fine.

Great character sheet. I should have done more searching before posting a quick reply in another thread.

Something I noticed, however, is that some of the SURGE qualities that should be available aren't listed. On page 110 of Runner's Companion it indicates:
"Other Metagenic Qualities

In addition to the metagenetic qualities introduced below, the following qualities available in Shadowrun, Fourth Edition qualify as Metagenetic qualities (see Qualities, p. 77, SR4; New Awakened Qualities, pp. 24–28, Street Magic; and Augmented Qualities, pp. 20–22, Augmentation). Other Positive Qualities: Astral Sight, Biocompatibility, Double Jointed, High Pain Tolerance, Magic Resistance, Natural Hardening, Natural Immunity, Quick Healer, Resistance to Pathogens/Toxins, Spell/Spirit Knack, Toughness.

Other Negative Qualities: Allergy, Asthma, Albinism, Biosystem Overstress, Disease Carrier, Gene Freak, Low Pain Tolerance, Nano Intolerance, Reduced (Sense), Sensitive System, Uncontrolled Metastasis, Weak Immune System."

I wanted to do a quick run-through of a SURGE 1 with both Type O System and Biocompatibility, but couldn't pick-up Bio since it wasn't listed as a qualifying positive SURGE ability.

Otherwise, especially as a newbie to SR4, I'm really enjoying your spreadsheet. Keep up the good work.

What I mean by this is the character sheet has all the skills in one merged cell and all the ratings in another which means you can't really cut and paste them if you want to post them up on the web.

And Thanks for a great time saver.

So I've been using this sheet for sometime and finally I started adding some things. Last night I added the program options. but I started to add today for the availability to highlight like it does in other places. Using the Conditional Formatting like the other sheets but it's not working for some reason I'm using the same formula and I've tried others too with no luck. I was going to upload it to the Drop.io site so I can have people check it. Plus I'm trying to get the pirated price reduction to work too but with no luck.

Any help would be great.

Brent

Edit: Break Through!!! figured it out.