BTW, would it be possible to have gear (etc) from War! marked as such? Some groups (such as my own) won't be using the book, due to it's questionable nature.

It is.

Just checking. So much stuff that is outright broken (cough, Softweave armor, Slow spell) that if it's going to be in the sheet should be obviously labeled.

The Burnout's Way does not work. There's a #N/A in Magic!M23 and Magic!M34
Also, it lacks the choice (and effect) of either Cyber- or Bioware discount. It's supposed to function the same way Biocompatability does.

in Wares_Data T448 and U448, the values for cyberlimb armor are wrong. They say 6, but should be 1 !?
in Cyberparts!O11 and O12 it should not say ROUND. Cyberlimb armor is not rounded like cyberlimb attributes. It counts with its complete, summed value.

Ill look into the Burnouts Way.

Since the system divides by 6, 6 = 1. I have left the individual limb armors because the printable Sheet displays the armor per limb (in addition to showing the total in Armor area) for called shot purposes.

The price for Autosofts isn't being calculated properly. As it is, the price is rating * 500, for all ratings. It should be rating * 500 for ratings 1 to 3, and rating * 1000 for ratings 4 to 6 (howerver, autosofts have a maximum rating of 4).

There is something really weird going on in the recoil compensation for custom firearms.

Take an Ares Alpha (RC: 2)
Add a foregrip (RC: 1) then a personalized grip (RC: 1).
Total RC: 4, so far so good.

Take an Ares Alpha (RC: 2)
Add a personalized grip (RC: 1) then a foregrip (RC: 1).
Total RC: 3

Not sure what's going on for you, Traul, but I just did the same as you described on a sheet and the RC still came up as 4 on both; order of the mods didn't matter. Might want to double check your copy is fully up to date, and if it is try closing and relaunching the program and try this again from scratch.

I am using version t and double checked. If you don't get this bug, then it must be a compatibility problem with OpenOffice.

Awe crap, just realized I responded to the wrong thread.

Added: Well, I honestly don't know if it's going to be version t or OpenOffice as I still have version p (haven't updated since switching to Chummer) & use Excel 2007. Anyway, I still could not duplicate your issue as both Ares Alphas came up with an RC of 4 in every single box for custom ranged weapons regardless of which order Foregrip and Personalized Grip were added.

Just tried with versions K and L that I still had somewhere, and could not reproduce the bug with them either.

However I have just downloaded a new copy of version T to make sure and I still get the bug with this one.

Well then, it is looking to me that it's version t that's causing this. Can't confirm this as I won't submit an e-mail address to download a copy of version t from the current host.

The autosofts are correct on the Vehicles page, but apparently the Gear page autosofts were all crazy. Anyway, fixed in the next version.

Not a safe assumption, as I do not think I changed any weapon mods functionality in version t.

Sorry about the download email thing. Like I said before, Mediafire and Filedropper stopped working from my worksite. If someone is feeling extra helpful, they could upload a copy of the file to Mediafire and provide the link.

Also, this is what junk email accounts are for. I have a real email address at gmail that I give out sparingly, then a total junk email address at hotmail that I use for BS like this. Its really easy to do, and really a must if you want to avoid spam.

I am not claiming it comes from version T. It could have been introduced in an earlier one. As I said, the latest version I had before was L, so that's a large gap.

Could you reproduce the bug?


And one for running?

Yeah, I saw that about the hosting and all. And though it's not a safe assumption, the only other is OpenOffice, but when prior versions of the sheet work fine in the same program it's the only thing that makes sense with the info I have at hand.

http://mailinator.com/

THen you are missing on a lot of good stuff in the process, like mines and battle rifles(both very welcome additions to the game).

Cyberskates (Augmentation, p. 45) seem to be missing in the movement rate formulas.

My games are overpowered enough as it is, we don't need to add 2 to everyone's DV and 6 to everyone's armor. We don't need monofilament grenades and slow spells. We're already rocking it with the best of them.

That's kind of unfair. You're banning everything from War! because some things from War! are broken?

Isn't it enough that you can not take the Slow spell because it's the Slow spell. Do you really need a special 'War!' tag just so you can specifically discriminate against the content in it, not on its individual merits, but because of what book it's in?

Like, hypothetically, if you were my GM, I couldn't have an Ares Bravo or an Ares Sierra because you hate Slow and Softweave?

If for some reason this character generator is marking the name of the book that EVERY option is found in than....disregard this silly post entirely. But if this is some kind of special yellow star (lol Godwin's) for options introduced in War! than the post stands.

There's absolutely no way to do this in WAR.
If you mean High Power Chambering, then thats stop you from using anythink other then High Power Ammo.

Actually now that i looked around in the generator, i don't seem to be able to find mines anywhere.

We've banned the book because we pretend it doesn't exist. It was poorly written, has several items that are clearly nothing other than power creep, among other things.

"Please provide a valid e-mail address."

I set up a gmail account for this in case anyone wants to use it.

login = filehosting.orgcansuckafatone@gmail.com
password = tothehilt

thisisbullshit@mailinator.com is a valid email address.
(Interestingly enough, it has email. "Saturn: Onlineshop geht bereits im Oktob")

Cyberskates are a situational modifier, so I left them out. I suppose I could write it so the walk/run/FLY would replace FLY with SKATE... Ill look into this.

Edit: Added this in. Sheet now has a 'modSkate' value of running movement x 1.5 if you have cyberskates. This stacks with Raptor Cyberleg movement mods if the character has both.

The charsheets have three spots for movement, walk/Run/ and other, which is either Fly or Swim. Now Skate is an alternative, but the sheet checks for the ability to fly or swim FIRST, and only displays Skate speeds if the character cannot already Fly or Swim. The priority of which type of alternative movement it displays can be changed on the charsheets themselves, in the cells that display the alternative movement type and its speed.

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)

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.

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.

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

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!

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?

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

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

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.

Any word on this, Damien?



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

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).

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)

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?

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



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.



MS Office 2007.

*Current sheet references AA37/AA38

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.

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 Anyway, thanks for providing this for the community, can only imagine how much work has gone into it.

Just keeps getting better and better 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.

Actually, this i a great rule everyone should at least consider. I would appreciate implementation as well

+1

Wrong thread, oops.



-k

Let's make it +2. Great houserule.

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.