Both Desktop Forges come up as costing 0. Should be 15000 for the small and 150,000 for the large.

Ah, I see what your talking about and its a big problem! The overflow cells are calculating off of the characters Base Body Attribute rather than their Modified Attribute. I suspect this is an artifact from long ago when the sheet did not have a seperate 'Damage Resist' modifier, so Dermal Plating and other Damage resist mods were going into modBody.

Anyway, it is now fixed in version w. If you want to do a quick fix on your existing sheet you can change the formula on the Overflow cells in the CharSheet tab to use 'modBody' instead of 'baseBody'.

Thanks for finding this one Dakka!

Description error on bioware: Reception Enhancer. It adds +1 to Perception per rating, not Reception.

Only in the sense that the Anniversary edition incorporates all earlier errata.

Not sure how its related, but when I read this I thought about the first time I visited a gaming store as a teenager. I had been gaming for years but we never had a gaming store... we ordered our D&D and shadowrun books through Walden Books at the Mall in the next town over.

So the gaming store was a big deal. I parused a bit, then took a book and sat at a table to skim through it. There was another gamer there, someone I had not met before. He was heavyset and had long greasy hair. If his nerdy glasses had tape in the middle the Gamer Geek Stereo type wouldve been perfect.

I asked him about the obscure book he was reading.. I think it was Swords and Sorcery? Anyway, got him talking about it and I asked, 'Oh, so that stat is like THACO in D&D?'

He pushed his glasses up his nose with his index finger and replied in a nasally accusatory tone, 'What!? There is no THACO in D&D. I think you MAY be referring to 'To Hit Armor Class 0'. If you were to say it then you maybe could say 'THAC-ZERO', but there IS NO THACO in D&D!'

Anyway, I still think your great Max but your comment brought up that memory and I thought I would share

When making a free spirit character, there is no option to choose Enhanced Sense: Scent in the list of critter powers.
Additionally, there is no option to gain a critter power point instead of a metamagic when initiating as a free spirit character.

Is there plans to add the information from Spy Games or Attitude in the works?

I notice that the last post to this topic was over a month ago. Is DamienKnight no longer working on this project? He mentioned a version W, but the latest version I see on his sig line is version V.

I'm trying to figure out how to add a custom Magic Tradition to the drop-down list on the Magic sheet, using OpenOffice.

I've added the appropriate entries in the (hidden) Magic_Data sheet, but I can't figure out how the stuff from there gets populated into the drop-down list (or any other drop-down list, for that matter) - I'm guessing there must be somewhere a range of cells is specified with which to fill the list, but I'm stumped as to where to look.

Any spreadsheet experts out there who can give me a clue?

It looks like named lists are used for the dropdown lists, so you'd need to update the "Magic_Traditions_List" and "Complete_Magic_Traditions_Table" lists to include the row(s) you've added. If you added one row, Complete_Magic_Traditions_Table would change from "=Magic_Data!$K$2:$Q$26" to "=Magic_Data!$K$2:$Q$27", and Magic_Traditions_List would change from "=Magic_Data!$K$2:$K$26" to "=Magic_Data!$K$2:$K$27". Unfortunately I have no idea where you'd find this in OpenOffice as I've never used it, but it obviously supports it so there must be a way. In Excel 2007, it's found by selecting Formulas > Name Manager from the ribbon. With any luck that might at least give you an idea as to what you're looking for in OpenOffice.

Again using Excel 2007 but hopefully having some equivalent in OpenOffice, you can find the name of the list that is being used by a particular dropdown by selecting it, then selecting Data > Data Validation > Data Validation... from the ribbon. The name of the list is found in the Source field.

I was wondering why the bows in the weapons tab only go up to Strength minimum of 11, when SR4A, page 316 lists the maximum Strength rating of a bow at 12.

Is the Savoir Medkit missing or did i just look at the wrong spots for it ?
Augmentation page 115 / Bodytech page 120

Might that have something to do with it?

Short answer: No.
Longer Answer: All bows have a minimum strength. A character with less strength than the minimum cannot draw the bow completely and suffers a dice pool penalty (-2 per point of strength below the minimum IIRC). On the other hand even the futuristic materials of SR can only do so much. The highest possible minimum strength for a bow is 12.

Interesting, might he have gotten a job at Hero Labs for the generator there? (1010% Pure SPeculative Bulldrek on my part ) More than likely he had RL issues (He does do this for free).

GM-Nissan Doberman Medium Drone lists that comes with an LMG and autosofts in the book but the generator does not make note of them. Is this an error? Additionally, the availability of the drone is 6 while the LMG it comes with is 12F? Seems kinda strange.

The Doberman does not come with any weapons. The SR4 book only says that the weapon mount it comes with is capable of mounting an LMG. Arsenal's brief list of upgrades for the Doberman doesn't add any weapons either. The updated SR4 FAQ also clarifies this:

I had a feeling I missed something. I appreciate you feeding the noob. XD

First I want to say, if I started working for a gaming related company in any capacity, especially one related to shadowrun, you all would be the first to know. I would probably wear everyone out with posts gushing my excitement in borderline inappropriate ways!

There is a newer version of the sheet I was working on. My group stopped playing SR, and my workload at the office increased, so the sheet fell by the wayside. I need to get version W out there.. I believe it is mostly just small fixes to problems noted in the forums here.

Ill see about cleaning up version W and getting it released. I will probably not do any more serious upgrades to the sheet so long as my group is not gaming. As always the sheet is unprotected and available for anyone to modify/upgrade, so if anyone wants to start making changes themselves feel free. Drop me a PM if you have any questions about how the sheet works, I am happy to nerd out talking about the mechanics behind the sheet.

Oh, I love figuring it out for myself. ^..^ Learned a lot of fancy tricks doing that.

what book is abbreviated as "sg"?

Spy Games

Download links are broken? Can't download it.

I am at work now and cannot upload any copies of the sheet.

Could someone PM me their email address. I can send the sheet to you as an attachment, then you can upload it and post the link here.

http://www.mediafire.com/?bo5lgr0pau5jrfx for the V version. This is the last version available previously


Version W is here!

http://www.mediafire.com/?9qc2t3v35o50p93 for the W.

Added setting option 'In Debt Quality Benefits', allows none, BP only, Nuyen Only or Both
Added a column on the gear page for denoting items that should not have a cost or availability warning
Fixed issue where Melanin Control was not showing up as a valid discountable power for Adepts who follow the Invisible Way
Added the option for Magicians to create custom traditions on the Magic page, similar to Technomancers options.
Updated Shifter qualities to properly reflect a Shift (race) where race is their shiftable race (rather than always saying shift human)
Fixed overflow on charsheet to use Modified Body rather than Base Body

Enjoy!

So, can we expect version W to be the last one for quite some time now? I always wondered what would come after Z

Why, AA of course!
*Ambiguous alternative interpretations intended*

I have not had any feature requests lately. Not sure what I would do for another version. Any upgrades you are interested in getting into the sheet?

Unfortunately, I haven't played around with the newer sheets (since...U?) as I haven't been in a ShadowRun game in some time.

Have you checked on prices on various items? Last I used the sheet there was a lot of stuff that had a 0.

I update prices as people request them. A friend did a blanket pull from the PDF's into a spreadsheet, which I used for the item table. Due to some tables in the books having different format, alot of items ended up with bad prices. I think I have fixed close to half of them since the item table showed up in the sheet.

Fixing prices is not interesting enough to get me working on the sheet again. I need real bugs or new things to add if I am going to spend time on it.

At any rate, if there is a specific item that is missing a price, or is wrong... or if you want to any any items, post the info here and I will update the sheet.

No worries. I realize it's a lot of really boring work
I just remember that there was a large string of 0 in one section.

Downloaded W, cant wait to make Azeroth, the mad troll.

Unhide the 'Adept_Data' sheet to add custom adept powers. I can recall 3 points for fast healing?

Also, you will have to update the 'Gear_Data' sheet to add Kevlar Speedos...

A question for the new character sheet v. W is if there will be a version that will be created for Office 2010? I know there is an issue with macro in the newer office version and how things work (not a programer or scripter) but I keep having issues in that the marco's dont seem run when I open the sheet even though I have selected for all macros to be allowed. Any thoughts on this from anyone?

I suggest disabling macros. None of the macros are required. I believe the only ones left are the dice rollers and the macro to switch the sheet between production and development modes (unprotects sheets, reveals grid headings). None of them are required to create and maintain characters on the sheet.

Ill probably be getting office 2010 in the next year or so. When that happens I will convert the sheet to 2010, and probably the macros too.

At work so that might be the problem, but I can't access the character sheet and it seems that the commlink tracker isn't on the website anymore? Anyone else having problems? Can anyone send me copies by chance?

Thanks!

Well it was works firewall blocking it.. however, the commlink file appears to not be up anymore. Can I get a copy or is there a better one out there that anyone knows of?

Thanks!

DamienKnight,

I Love your Work! This is the best generator I have used. This Includes the new Hero Labs one That just came out

Is any of the data on SR4CG_DK_1w Editable? It has no real "game impact" but I've noticed that the Trust fund Positive Qualities have been removed. I have several character that require that Quality. I'd like to include the Qualities on my version of SR4CG_DK_1w

Great piece of work. Thanks

Is there a way to print out a text version of this with the BP cost included?

Editing the page is simple... although the pages are locked down, there is no password. Depending on your version of spreadsheet editing program the directions will change, but you need to Turn off Sheet level protection for whatever page you want to change.

Trust Fund Ill have to look into later. Hopefully I will get to that this weekend.

Use the CharSheet pages for printing. If you need to add BP to it, just go to the Main sheet and find the cell that shows BP, and copy the formula over to the Charsheet page. You will need to unprotect both pages.

Misdemeanor, thanks so much for the feedback. Are there any features you think the sheet needs, or anything you would like changed? I have not made any changes to the sheet for a long time, mostly because I am not sure what needs to be added.

Here it is:

http://www.mediafire.com/?u5190gvos6lkvwy



And here is a copy that I think supports pirated software. Someone from dumpshock made this change, I have not really checked it out (my group does not follow degradation rules)

http://www.mediafire.com/?eiyjxyd5j177t62

TitanMachine, Get rid of your Heroforge Blitzcrank build and put the fruit of your brothers labors to use.

Does their sheet cover location based armor stacking? Can you combine outfits into complete sets? You need the DK CG Titan...

I Just Upgraded to Outlook 2010...I've not had the chance to use the sheet since the "Upgrade". I will Let you know what I find

There are 2 New Black Books and the War Book that I would love to see Added to the Generator

What does Outlook have to do with an Excel sheet?

Touch'e...I meant Office 2010

I would love to see a revision of the generated character sheet. Its great but there isnt a lot of room for gear and only having a handful of melee weapons is a little hampering.

Seem to have run into a small error.

Human Adept on Karma-gen, playing around with some Adept powers and a Grade 1 initiation with the Power Point upgrade and suddenly half my Karma disappears.

http://www.mediafire.com/view/?873qmjne5qpcg5c

That character is set to BP-gen.

....I....totally knew that..... >.<

I have got to stop doing complex tasks at 2am.