It should be 11/9 [8].
FFBA encumbers as [3/1] the rest counts full, so Aces High [3/3], PPP leg&arm castings [+1/+1], PPP vitals protector [+1/+1], PPP forearm guards [+0/+1], PPP shin guards [+0/+1]
Altogether that is [8/8] or [8] for short.

OK, I see it now for some reason I was adding it all together.

Thanks,

Hey Folks,

First DK let it be known that without this sheet I could not GM for Shadowrun!! It makes my life so much easier! So THANKS!!!

Ok on to the question, the last few points talk about the sheet calculating the total armor value for "stacking" armor. Where the heck on the sheet does it display this (the total that is)? I can't find it to save my life.

Thanks

On the Gear sheet in the armor section there is an outfit column. If you give all the items to be worn at the same time the same name, they will be displayed as an ensemble of that name on the CharSheet.

Thank you very much!!

Regarding this, I really think this kind of sheet needs a tab all dedicated to explaining the most obscure passages. Things that are probably present in one or more comments in other tabs, but that one way or another someone always misses. What do you think?

EDIT: Sorry, I forgot a question.

Damien, how much is your sheet compatible with SR4A? Is there anything I should watch out for?
I'm still pretty new to the game, I haven't played it and I'm planning to begin a Play by Forum - your sheet would be a wonderful tool.

I think there are so many features on the sheet that it could be harrowing for a new user to try and understand it all. Perhaps a tutorial could be written? Maybe there just needs to be a few sample sheets release with examples of how to implement the more complicated features?

I do not believe there is a solution that should be integrated into the existing sheet itself, beyond cleaning up comments, or adding more of them. A tutorial would need to be a separate document available to download with the sheet, but a separate file from the sheet. Adding a tutorial is an ideal task for community involvement. Anyone with some free time and ambition could come up with an .html tutorial, or even a Word document. I would highly recommend including screen shots. A text read me would not be much more useful than the comments themselves...

If anyone has suggestions relating to Help documentation, please speak up. Anyone wanting to take a whack at it, let us know what we can do to support your efforts.


I believe very compatible with SR4A. The sheet began prior to SR4A, but with help from the Dumpshock Community I have been making appropriate updates when asked. If you find anything that doesn't jive with the Anniversary content, please point it out here in this forum and I will do my best to include a fix for it in the next update.

Documentation:
The problem with comments is that there are so many, and you have to read them one at a time, so for instance if you rember you've read domething somewhere, you can spend a lot of time searching for the right comment (especially if you're not sure on which tab it is).
Screenshots are a good idea, if you/we go that way, an external document is a must.

If you don't have anything again it, I could start jotting down a skeleton for the tutorial. I will obviously cover only the most basic parts, but then someone else can expand on them.
I think the toutorial should not be character drive ("for this kind of character, do this, this and that") but instead sheet drive ("Tab X, section A, is used in this case and in this way; section B in this case and in this way" ecc) with maybe a few recaps at the end (I'm thinking especially about character advancement after creation).

Re. SR4A:
Nothing specific for the moment, I'll check the conversion manual to see if anything pops to mind. I asked only because sometimes I find missing items and I started blaming this on the different manual. One I used to miss before 1d was the helmet, but I can see it now. Another one is the Stoner-Ares M202 (SR4A, pag 320), still missing.

Forgot something again: yes, sample characters would be really helpful, but that is something that should really wait for an almost-final version, I think.

With the fix (applied to both ballistic AND impact) you will get 11/9[8].

Is it just me, or is the sheet missing all the weapons from pages 31 and 32 of Arsenal?

When choosing the "Weapon Accessories" category on the Gear tab, nothing is available in the Gear pulldown.

On the Gear tab, the "Recoil Accessories" category should be "Recoil Compensators," per the heading on page 34, Arsenal. AMP should be removed from that category. [It belongs in Manatech, but that one's already there.]

On the "Vehicles" tab, there's an entry for "ECM" and "Electronic Warfare" drone autosofts [below "Available Cash"]. Where are these located in the books?

Thanks!

Try "Firearm Accessories" instead of "Weapon Accessories"; you might find what you're looking for there.

As for SR4a compatibility, the costs for two types of Skillsofts got jacked up. Activesofts are 10,000 per rating now, and Knowsofts are 2,000 per rating.

Also, the last three cells still appear to not recognize any of the negative metagenic qualities.

And great work on this monolithic project, DamienKnight.

Added: Haven't looked in SR4, but "Electronic Warfare" drone autosoft is on page 246 of the SR4a book. Based on its description, I'd wager this would be the same as an "ECM" autosoft.

I checked, and all the missing stuff is in the Gear_Data worksheet, but isn't appearing in the pulldown. Maybe it's a problem on my end: is anyone else able to choose anything from the Firearm Accessories category on the Gear tab?


Aha! There's the Electronic Warfare autosoft. Thank you! Now, if I can just figure out what the ECM Drone Autosoft is...

Firearm Accessories works for me.

My fault: I mean "Weapons Accessories."

Yes, it turns out the formulas I was using to calculate the dropdowns was weak, and was not working properly for any category at the bottom of the list. I reworked the formulas using Range math and its works better now.

Excellent. Good to know it's not just me!

You don't have to respond to any of my other posts - please don't: if you responded to every bug report, you'd never have any time to fix bugs! - but if you could let me know where you're getting the ECM Drone Autosoft from, I'd hugely appreciate it. Thanks for everything, Damien!

Hello everyone, today I tried to start a documentation file, please Damien Let me know what you think.

SR4 Character Generator.doc

Some questions that arose while doing this:

Damien, I've seen that when you enter something in the Current Resources cell, the Resources cell (which is used only during character creation) greys out. This is really interesting, you could apply that for other areas, stats for example: when you enter a stat in the Raise column, you could grey out all the Base stats column. What do you think?

I've noticed that none of the sample characters on the base handbook have a specialization in their natural language. I'm not sure a natural english speaker should not need a specialization in cityspeak if he wants to speak it perfectly. Anyway, the specialization in your natural language is not visualized correctly in the CharSheet, please either remove the possibility to specialize in it, or fix visualization.

- Also, it would be wonderful if the language and knowledge specializations were visualized on the Main_Sheet tab just like the ones for Active Skills: the color is still black instead of green, and "/ 6" for the max should disappear.

- How do you specify what kind of addiction/allergy/etc do you have?

- Is it right that when I choose a Banshee Elf Technomancer, the sheet says I have Magic and no Resonance? Note that Magic and Technomancer sheets are still working correctly for a Technomancer.

- how do you add a spirit ally? (I mean, what do I have to do to make it appear? At the moment the tab is blank.)

HMHVV makes you lose any previously existing Resonance, the background is that Magic and Resonance are >100% incompatible.


Learn the Ally Conjuration metamagic

There'd really be no need for someone to have a specialization in their native tongue. For other languages, though rating 3 is considered conversational, you still effectively have to make skill checks to see how much you understand; you never need to make such checks for your native tongue. Specializations in secondary languages essentially means you're good with a particular dialect of that language.

For example, someone from an English speaking nation (like Australia, Canada, England, or the United States) most likely would have "English N". Understanding the various dialects, even those within the United States alone, isn't too difficult for anyone from those respective countries.

Now take someone from a vastly different country, like Brazil, Iraq, or Japan, where English isn't the primary language. Someone from there will likely have a harder time understanding American Southern drawl if they were specialized in Ebonics for some reason (something like "English 2; Ebonics").

I'm not so sure about that. Especially if the speaker from another region uses regional expressions. An example which probably most of you will understand: truck/lorry, or the connotations the word bloody has in British English.

In SR4 there is no penalty for using a skill outside the specialty, that is a thing of past editions. You simply do not get the two bonus dice. Unless you are conversing in Ebonics English(Ebonics) 2(+2) is the same as English 2.

So what SpellBinder is trying to say is that, basically, anyone that comes form an english speaking nation can:
- Understand anyone speaking in any variation of English, be it australian, ebonic, cityspeak, ghetto slang, southern drawl, or anything else. And all this without any kind of training or roll.
- Fake his own variation to pass as a genuine talker of one of the many variations. This, too, requires no roll.

Regarding point one, I suppose then that the glossary of cityspeak present in the handbook was presented for the commodity of foreign players, since all american ones can already understand it without problems.
Point two, I hope it is self explanatory.

In Italy, we have about one dialect for each region. While we chose Tuscany's dialect to be defined 'Italian' a couple of centuries ago (thanks to Dante Alighieri), the dialects are much older and only neighboring ones can understand each other, sometimes barely. Still, I wouldn't go as far as saying that they are different languages, but still saying that your natural language gives you access to every dialect, both in understanding and in speaking, is impossible.

You pretty much got what I was trying to say, Vittek.

And just to say before someone goes off on a "that's not how it is in the real world" line, please do remember that pretty much all RPGs don't mirror life 100%. That's what real life is for.

Good suggestions Vittek. I will look into implementing each of them.

As far as Qualities details, I will need to implement a translation formula similar to what I am using on Physical Adepts. This is a known issue that I need to address. Thanks for the reminder.

Also, thanks for the assist Sengir. Who better to answer an infection question than a vampire?


This discussion is interesting and should be shared with the rest of the community. Please post your ideas on language specialization in the main Shadowrun discussion forum. If the community seems to have a concesus on a house rule addressing this, I will consider adding it to the sheet.

Found another glitch in the vehicle page. The first vehicle calculates the speeds correctly for the engine customizations, turbocharger, and smart & racing tires, but at least the second one does not (and maybe the rest; haven't tested yet).

Prerevisionist vampire, that sucks for rules questions

So here are a few things I stubled upon while playing around with the character concepts (which is a nice pasttime thanks to your efforts):
- [bug] The first drone has an Adaptability 4 Autosoft, that number does not even come from a formula but you somehow left a 4 in that cell
- [feature] an extra column to define the base values of drone autosofts would be nice, at least until those values are included for each drone
- [feature] Living Persona values on the charsheet
- [feature] Cyberparts as part of cyber suites
- [bug] The preset descriptions for vehicles are doubled, or is this because I'm stuck with OO right now?
- [both?] Selecting Spell/Spirit Knack in the "special" box does not cost BP. Selecting it as a quality costs BP but does not grant a magic attribute. I suggest moving everything that grants Magic/Resonance to the special selection and only there. That would also include Latent Awakening/Emergence and Wild TM, which are currently missing in that list.

One of the issues I encountered was when using shapeshifters. Small ones, but still. On the CharSheet, the severity of the Allergy(Silver) is not listed. Severe, obviously, but still. When selecting a shapeshifter, you can develop the magic attribute as you wish[RAW], but unless you have selected a magical quality on your program, the magic attribute disappears. [I'm sure it's not a big deal for most players, considering they will usually choose to have the magical quality anyways, but still...]. Also, when choosing a shapeshifter, selecting "Technomancer" won't give you the yellow box of doom. Seems the setup is reading it as a compatible combination.

Heh, sorry. Thanks for this great program. IMO, it's better than Deagann's CharGenSR4 program.

*edit* Also noticed the description of Critical Strike changes based upon how many levels. I.E. 1 level, +1DV per level; 2 levels, +2DV per level; etc... Not sure if this escaped notice or not.

Downloaded version......."SR4CG_DK_1d" and making a human featered drake (and doing nothing else) results in a circular reference. I don't understand the sheet well enough to know why.

Oh, wait, no, I found it.

This bit:

Tail Venom Rtg "&Main_Sheet!$R$12,br,"

in the Feather'd Drake's race data.

Magic rating is based on being a drake, being a drake has a power based on magic rating and the sheet interprets it as circular because of the way you have the cells set up to read the data.

Maglock Passkey, Keycard Copier, and sequencer, which are all rating (1-6) objects have a datafield "max rating" of 1. This produces a warning when attempting to buy a rating 2+ of any of these devices.

Just a quick word: I have started a wave (as in, Google Wave) about the documentation. It seems a nice way to work on this.

Found some more.
The Prepackaged Nexi have no cost. Editing the relevant data by hand it appears that MPSs, ARE Software, Matrix Program Packages, PAB Units, Parachutes, Passkeys, Security Equipment, Skilldoft Clusters, Nanotech, and some other scattered items don't either (except hacker nanites).
Customized Interface also has a cost 0 (should be 250).



Link.

Sorry, I don't think it works this way. You need to register to Google Wave, then you can give me your contact so I can add you to the wave. If anyone needs and Invite, send me a PM, I have 8 invites left. Please refer to the Google Wave thread in the Community Projects section.

Is the link in the first post the latest update for this?

If you're looking for the most up to date Excel file character generator, best is to look for any post by DamienKnight (or even in his profile). He keeps an updated link in his signature.

I have a wave account. Draco18s@

(Which once again highlights for me how dumb the ability to find new waves is: someone in the wave has to add you to their contacts list,* then manually add you to the wave)

*Which isn't even done through google wave, but gmail.


On the topic of the sheet, I ran into another error.

When attempting to buy spell design formulas, the "gear category" macro field shows "fetish" not "spell formula," so the cost is wrong and the user entered category and items are WARN-ed. This has to do with the fetish: [type] and spell formula: [type] entries being identical, so the lookup function grabs the first one.

Instruction costs for spell designs should not have a max rating 1. They do have a rating modifier, which is based on the instruction skill of the instructor (1000*Instructor's Skill Rating).

It's entirely possible to create a link to a wave and have the wave be public - I've found at least one wave that way. I *think* you need to add "public@a.gwave.com" as a contact to the wave (even if it says it's not a valid contact).

Which is why I asked for one.



Its a (special gwave) robot, I think.

I added you, draco18s, to the wave, and also the bot.
As I said, I thought linking was not possible, I'm sorry I was wrong, but I still haven't found a way to link a wave.
Anyway, last post on how to use waves in this thread, please comment the wave itself if you want.
Sorry again.

For shits and giggles I wonder if that works.

It should navigate to the wave, though I suspect you'll need a gwave account to see it (and if its not public you won't see it even then, but that wave should be). URL nabbled by adding the wave to another wave then copying the link's URL via right click.

No good. It opened gWave but I only saw my own.

This need a fix:

Attunement (Animal), the adept metamagic calls for an additional investment of karma that depends on the essense of the animal attuned to. Typically 6, i would assume. It would be neat if attunement opened an additional column that allowed a variable karma amount for the essence of the attuned creature.

Thanks for all your hard work in this DK!

AI Qualities not implemented. The Rating should be an average and should not take BPs.

--- Edit ---
@otakusensei : It opens a wave that you have to follow . Else it goes back into limbo !

Seeing as there is a reasonable work around (manually entering the karma cost on the Karma page) this is an upgrade. I will look into including it in version f.



Good point. It seems the max was going off the calculated average (though it was rounding up only in the presentation, not in the data itself). This is fixed now in version 1e.

Unless I'm blind the two stock flamethrowers (Aztechnology F3A, Shiawase Blazer)are missing on the weapons page. There is only the template, which is the blazer IIRC.

I think the whole file has not been updated with SR4A yet, right ?

Grenades:
The "Esprit "Petite Brume"" grenade is listed as having no price and the listed page number (AR 67) is incorrect. It isn't even in Arsenal at all as far as I can tell.

The Geas quality is listed as sr4 with no page number; the correct citation is SM 27 or SM 27-28.

Missing the spells from the Digital Grimoire.

It has been.


You are correct, it does not have the price. It IS in the Arsenal book. Description page 64, listing at the bottom of page 67.



Fixed Geas. Digital Grimoire Phys ad powers are present, but spells not added yet. Maybe in version f.

The Phys Ad power (Reflex) is still at SR4 cost.
Sorry my bad ! Was not using the good xls chargen ... Your's ok !

Not true. 1D has a cost of 1.5, 2.5, 4 and it has been that way for several versions.

Sorry started typing before your edit.

Did I do something wrong or do armor enhancements not add to the cost of the item?

I just found out that this is only the case for enhancements without different ratings and if you add a 1 in the rating cell the cost is calculated.