Could you make it such that all non-standard rules are clearly marked as House Rules, so a less forum-savvy player can work out what those settings options mean?

Thanks, -- N

The first tab on the sheet is "Settings." Under that you can clearly see the optional rules put into the sheet and you can turn them on, off, or tweak them as needed. Their fairly easy to find as is, and while I don't use all of the rules that the program defaults to, I've never had a hard time setting it the way I do play.

The thing is that not every rule mentions which setting is the houserule.

They are all optional/houserules. Hence the name "optional" rules.

EDIT: To clarify: FALSE should be the default setting on all of them.

a) There are optional, as in proposed by the books, rules and fan-created houserules. Not all houserules are designated as such.
b) There has been a lot of discussion whether averaging cyberlimb armor is a houserule. I try to express this as neutrally as possible since I disagree with DamienKnight on that point.

Just wanted to chime in and say thanks for the spreadsheet. It helped a ton with character gen for my group. After tinkering with it, I had a couple of questions:

1) The cyber spur is displaying a reach of 1. I thought it didn't have a reach.
2) How do you properly display purchased ammo magazines on the character sheet (i.e. purchased a smg and want to purchase 10 full magazines of regular ammo for it)? I saw where it will show ammo purchased by rounds. Just didn't know how to input it to show full mags.

You can't, AFAIK.

For the record, and since I've stated it elsewhere: as of SR4A cyberlimb armor is not averaged. The only point that needs errata is the fact that partial limbs (like hands and feet) cannot recieve more than 1 Armor enhancement.

What you can do is buy spare "clips" [sic]. I think they are in the accessory section, away from sheet atm. They only show up in the gear section however.
If someone does a weapons sheet the ability to strike off magazines and individual ptrojectiles, similar to the condition monitors would be nice. The normal sheet however does not have the room for it and DamienKnight does not want do much layouting IIRC.

My thoughts exactly, Synner.

Nice to see this thing is still going. I'll have to check the latest update.

Hi,

Would it be possible to set a default grade for cyber parts (most likely Standard)? This looks like the only place where an explicit grade is needed: it is used to set the price for cyber accessories. With OpenOffice, the accessory price does not display before I select a grade for the limb.

Not sure if I'm screwing up, but I ran into a couple of minor problems.

First off, the houserule of getting 6 points of contacts for free is turned on as downloaded around noon today. I actually like that rule and will be using it myself, but it's not canon.

Second, I ran into a problem where it kept adding up BP even when I was purchasing my free Knowledge Skills. So I purchased my 66 points worth at the end of everything and suddenly, my BP was at 466. Had to unprotect the page, modify the formula to subtract the BP of the Knowledge Skills (which only works because I didn't go over my free points), then re-protect everything so I didn't screw anything up.

Finally, it will let you go over the limit of 35 BP worth of negative qualities without giving a yellow highlight warning.

As I recall, Damien said a bit ago that the default for the sheet are the default settings that he and his group use. This means that there might be some of the houserules turned on, just check that page in the sheet if you aren't sure.

Also, I don't have access to the sheet at work, but I believe the houserule you are referring to is 2*base Charisma in free BP contacts; not a static 6. You might want to check that out.

Again, since I don't have access to the sheet here I can't comment on your other issues.

Both happen for me too.

I found a weird bug with firearms.

The recoil compensation of mods (namely personalized grip) does not add to a Ruger Thunderbolt L or S, but it works fine with the basic Ruger Thunderbolt. Not such a big deal, though, as long as the price is right.

1. I do not change the settings to cannon before I release the sheet, nor do I ever plan to.

2. The calculation was fried. Fixed in version L.

3. The confitional formatting is looking for negative qualities exceeding 35 or 70, instead of qualities less than -35 or -70. A quick 'Conditional Formatting' fix and it is good to go in version L.


There is a 'Weapons Default Recoil' table for weapons with built in recoil. When I added Thunderbolt L and S I forgot to add them to this table. Fixed in version L.

This issue does not occur in Excel 2003. Any advanced OO users out there who can help Traul with this?

For those who absolutely want to have the sheet defaulted to cannon & RAW, one can always change the settings to such and resave the default sheet. I do that myself for a few personal adjustments (like adding a Task column for Technomancer submersions).

Could also work as a temporary fix for the cyber parts issue, set all the grades to Std. and save the otherwise blank sheet for the default. Don't have OO myself, so sorry I can't help better.

Basically, the issue is that if you start picking accessories for a cyberlimb before you chose the grade it doesn't display the price of the accessories in the lower list, however as soon as you pick a grade, it all fixes itself and stuff.


Also found another error, the custom weapon mods in the custom firearms section that normally have a price based on the weapon are price 0 instead.

Once you know it, it is not such a big deal, as it works fine once the grade is selected. It just took me some time to figure it out the first time.



Thanks

Some more nitpicks with the data:

- the non-mobile emotitoy price should Rating x 100Y, not 1000 (although this might be a fine house-rule...)
- the auto-injector (Augmentation, p. 39) seems to be missing both as cyberware and a cyberlimb accessory
- there are several cyberear accessories available in the sheet that are not listed as such in the rules : biomonitor, datajack, bombs, ultrasound sensor

1. Fixed emotitoy price.
2. Added single dose, 4 dose, and unreusable autoinjector to bodyware and for installing on cyberlimbs
3. A biomonitor cannot be in a cyberear? Why, please explain. Same goes for a datajack, what is the issue?
Bombs should not go in ears, but due to how the sheet is setup, they will stay. Dont use them unless your GM thinks its ok.

Ultrasound sensor could NOT go in EAR? Seriously? Your going to object to putting an audio sensor in your cyber ear? I have no response... I am dumbfounded.

Not that you need it, but just to back you up with some RAW, headware with a capacity cost doesn't have to go in the head, but can go into any cyberlimb with a capacity slot for it. As they do have capacity slots, cyberears and -eyes could be considered legal placement in that regard. Technically, you'd even be able to put a datajack in your cyberEYE, though blinking might pose a bit of a problem.

Cybereyes and ears are not listed among cyberlimbs but with Earware / Eyeware, you can check it in the rulebook. Per RAW, Cyberlimbs are Torso, Skull, Arms and Legs. The problem is that Capacities for cyberlimbs and for cybereyes/ears are on different scales. Otherwise you have to admit that you can fit 8 commlinks or a grenade launcher in an eye, or more disturbingly that an obvious full arm has smaller Capacity than a pair of eyes. Fluffwise, a biomonitor or a datajack could fit in an eye (the Eye datajack even existed in SR3), but definitely not for 1 Capacity, and conversion rules are sadly missing. Or once again you can fit 16 datajacks in your eyes. Where do you find the room for the sockets?

EDIT: if you want a final proof, just look at the large smuggling compartment. If cybereyes count as cyberlimbs, then you can hide 3 normal sized heavy pistols in your eyes. That should settle it.

I suppose the rationale behind the Ultrasound sensor being Headware instead of Earware (or Eyeware, as it is used as a visual device) is that despite its name, it is not just a sensor: there is already the Increased sensitivity Earware to sense ultra and infrasound. It is an active device that emits his own signal and gets a 3D mapping from the reflections. The emission must require heavier hardware, thus more space.

But there is no need to argue much about this: as you said, if I don't want them, I don't have to use them


I had no problem to take them out of my sheet. They are listed among Cyberear accessories, so I could just remove the lines from Ware_data. Or do you generate the accessory lists automatically from the cyberware list?

More issues/omissions:

I tested in OO, and equipment upgrades with a cost derived from something other than the rating end up with a price of 0.

No bioware/geneware/nanoware for pets.

Hi,
Im having y first play with the shadowrun characte generator.
How do I get the points I used on Martial Arts to come off my total?
When I put in muscle aug/toner it seems to be giving me 10% off the cost and essence. Is this a mistake? I dont have any discounts on any other Bioware.


The final character sheet doesnt seem to be picking up the cyberarms strength for any melee attacks primarily made by that limb. It is just using the average.

So, I have have to say, I love this sheet and would like to thank DK for all of this work.

Question, though. Is anyone else having trouble with version K? When I try to open the sheet I get a file error in excel. The file loads, but none of the dropdowns on the main sheet are working. I haven't had this issue with any previous versions of the sheet. I have a pretty old version of office, so I'm wondering if there is a compatibility issue that's tripping me up. Just wondering if anyone else has experienced this issue.

Where do I find version L?

You don't. The points you're talking about are the maneuvers. Having martial arts allows you two maneuvers, it doesn't give them to you for free.

I'll admit the book isn't very clear, but after going over the section several times for one character I interpreted it correctly.

The latest out is Version K. DK's saying that when version L is released, it will have the aforementioned features.

The ArmTech MGL-6 is listed as SS, it is SA

Foam Explosives are 100xrating per kg, not a flat 100.

I made a character with martial arts, and two maneuvers. 9 points in total but they weren't deducted from my total.

I also noticed when adding a customized ingram lmg the end rang band starts at 400 instead of 401. Same with the skr model 100, with the last range band starting at 80

I'm sorry to say this, but that is really really stupid atitude to take when relesing a character generator.
This is an amazing char sheet, thats badly hampered by not being raw as stardard.
House/optional rule togles are a great addition to a charsheet, except when some of them are on as standard and have such a wierd descriptions that even someone who is relativly rule savy has to spent a quite a long time to figure out how to set those options so that the sheet works as RAW.

You don't get it do you? He doesn't do it to 'release' a character generator. He does it for his own personal use. Which his is happy enough to share and take feedback on. If you don't like his stance feel free to do your own. As for me I don't agree with it either but I would much rather spend a few second to change the defaults on the sheet then lose the hours of work he has put into it or spend who know how many hours doing my own

Seconded, though I actually like most of the default settings. RAW contains some very stupid rules, and I for one think some things (like Karmagen) should be RAW.

I may be misunderstanding then, as the sheet counts upwards as you spend points, not downwards. If you mean "deduct" as in "I spent points, but the sheet doesn't seem to think so" that's different from "I should get a refund because this is free and the sheet doesn't think so." Because it should be the former.

You do know that karmagen is RAW, right?
Its in Runners Companion.

It's an optional rule. I think BP should be done away with.

I suppose you run Karmagen, with no free knowledge skills or free contacts, right? Or are you running Karmagen with free knowledge skills and contacts to make some extra munchy characters?

Karmagen, (Log + Int) * 6 Karma for free knowledge skills, no free contacts (though I might reconsider that), and a bunch of other house rules, minor or major, to make things better in various ways. Why do you ask?

Actually its an alternative character generation method and is RAW.

Good call. Fixed in version L.


I am not seeing that problem. Points are deducted properly when I add martial arts and manuevers.

The ranges on the Customized weapons was not adding one for the start of the ranges. Fixed in version L.



Hmph. Well...


Yes.


indeed!


Huh?


Bam.


Agreed.

Hey, if you can fit it into contact lenses, then you should probably be able to stuff it in some cyberears.



Could you elaborate on this. I do not follow...



First, Thanks for using the sheet. I hope you enjoy it!

Martial Arts: Are you saying your group is houseruling that martial arts advantages are free? I dont recommend this. They are really pimped, and should be purchased for 10 karma apeice, plus more for maneuvers. Also, if you dont want the quality counting against your quality max, then enable the option on the 'Settings' page called 'Martial arts is not a Quality'. Just set it to true, and you can purchase advantages and manuevers without it counting as a quality. If you want to redeem points spent on martial arts, try adding an entry into the Karma_Log page.

Not sure about the aug/toner. Try setting the grade to 'Std.' and see if that fixes it. Do you have biocompatiblity?

As for melee damage with cyber arms, you need to calculate it yourself. On the CharSheet page it shows your average strength at the top, and uses that to calculate unarmed. Your cyberlimb specific strength is shown in the Wares area beneath the Limb, so you can calculate the difference and modify your unarmed damage accordingly.

Can't thank you enough! This is such a great generator!

Sorry if this is a dupe:

On the Char Sheet tab, on the Technomancer Sheet:
The complex forms list should be wrapped around.

Also on the Char Sheet tab, on the Character Sheet 3:
Lifestyle reads "Luxury for 1 month. Docwagon Basic" regardless of the character's settings.

Go into weapons or vehicles and add a mod that references weapon cost or vehicle body (internal smartlink, ceramic/plasteel components, vehicle tag eraser, etc.). They all come up as costing 0 instead of the correct value.

[quote name='DamienKnight' date='Jun 14 2010, 11:03 AM' post='94180
Huh?
[/quote]

I was trying to clarify what he meant by "not deducting points" as the sheet increments for expenditures,* so a "deduction" would be a point-refund, which is not how the rules work.

*Buying up Agility from 1 to 3 costs 20 points, and the sheet now lists you as having spent 20/400. Not 380/400 remaining.

If it was even so that the False is the RAW positon on all of them, it wouldn't be so bad.

The lifestyle thing is a dupe, but I had not fixed it yet, so thanks for pointing it out. Good catch with the technomancer sheet too, thanks!

Both problems now fixed in version L.


These things calculate fine for me. What spreadsheet program are you using, and what version?

On a more helpfull note from me, i think that all of the Program packages from Unwired are missing their price and availebilities.
And for the ease of reference


And i seem to suck at using code tacs

Was running Open Office 3.0 with version K. With 3.2 they calculate, but some of them have errors;

Weapons:
Ceramic/Plasteel components all give cost at 0
Large Modification for Fire Selection Change cost (Weapon x 2) + 2000 instead of (Weapon) + 2000

Vehicles:
Missing ECM
Metahuman Adjustment needs a number of seats linked to it (could be done the same as tires)
Off-Road Suspension returns "#VALUE!" which breaks all fields that are linked to it.
No error comes up when applying illegal mods to vehicles (Flying Fox on a Roadmaster, or Hydrofoil on a Nordcapp Zugmaschine)
Weapon Mounts are missing the size selection and are not limited by vehicle's body

I also noticed some cell formatting issues (though only the first is critical);
Cyberparts page - Can't left-click select any cells.
Main_Sheet, CharSheet, Initiation Group, Ally_Spirit, Pets, and Mobile_CharSheet pages - Can left-click select any cell, whether protected or not, while the other pages only allow left-click selecting unprotected cells.
Magic page - Tradition customization cells not highlighted.
Technomancer Sheet - Immursion completion field not highlighted.
Hacking page - Program options fields are not highlighted, and dropdown fields highlighted dark cyan, instead of green.
Gear - Notes are manual entry with grey highlight instead of blue highlight.

Sure. It is the same as the datajack: it should fit, but not for 1 Capacity.