Sorry that I disappeared so abruptly 18 months ago.

Anyway, I've gotten ahold of Augmentation, and since it allowed me to do some of my old character concepts justice, I've been inspired to update the old character generating excel file that I used regularly. This is the one created by Autarkis and updated by Blakkie through Street Magic. I've added pretty much everything in Augmentation at this point, but I certainly won't guarantee it's error-free!

All files are hosted on Mediafire, so you'll have to view some adds to get them. Feel free to mirror these elsewhere if you like!

*New Versions Available as of 12/05/2007 (draft 7)*
The update notes are a bit further down the thread.

For those of you who have the latest software (Excel 2007, can open .rar files), use this link:
SR4Chargen (xlsx)

For those of you with older versions of Excel (and who still use zip), use this link:
SR4Chargen (xls) (not guaranteed to even be as error-free as the xlsx file)

Previous Versions still available in the spoiler:


Lastly, just in case anyone was still interested in my dice roller after all this time, here's a link for that too:
Die

File Notes:

..I'll have to download the update when I get home.

Sweet.

Huh, when I try to download it gives me 0 kb .zip and .rar files.

Chris

I approve! Well I will when I get a chance to look through it.

Thanks for doing this Feshy. I might even tweak it a bit further to address the parts that have been left out if I can figure out how to easily add a good interface for them. BTW I don't have access to the website where the old version (linked in my sig) is kept. But a quick email to the owner of that website would likely get the new version posted in it's place.

EDIT: Crap, it looks like he's reorganized his page a bit. But I can't edit my sig because the board is busted. Here is the new link: http://pavao.org/shadowrun/generators/ You'll have to scroll down to the bottom of the page manually because he removed the # labels from the HTML. Also when you send it make sure to ask him to add your name to the description.

I just thought I'd note that currently, the sheet adds essence cost multipliers together, rather than multiplying them. For instance, Second-Hand Alphaware would have a multiplier of 1 (.2 - .2) rather than .96 (1.2 * .8). Apparently, Augmentation has an example directly contradicting this, so I may change the way this is handled in the future. Also, I haven't actually added "second-hand alphaware" as a grade choice yet...

I noticed that you can't clear the drop-down list fields other than by selecting a blank line -- backspacing doesn't work, but would be so much more convenient. Do you think you could change that?

Would someone mind PMing me these files? For some reason whenever I download from MediaFire I get a 0kb file that is completely useless. It is quite annoying and I cannot figure out why. Also, suggestions to fix this would be nice.

Thanks,
Chris

It doesn't look like you can send files via PM, unfortunately. If you PM me an e-mail address, I'd be happy to send it to you. I'll do the same for anyone else having trouble with Mediafire as well.

Heyo Fleshy,

Quick question. Some of the genetic customizations seemed to have particularly high avail ratings on your sheet. Genetic Optimization for one sticks in my head as showing as 20 on the excel sheet but when I checked the hardcopy it was only listed as a 10. Was there an errata I missed somewhere that had adjusted avail ratings or were you using a house rule for the availability?

Mr. Black:

I looked at the phenotype adjustment section, and looked at what I typed, and it took me a few minutes to figure out just what happened. Apparently, when I typed them in, my fingers where one key off -- thus, 12 became 23, and 10 became 20 (because the zero was with the other hand...)

Good catch! If you want to fix it yourself, you can unhide and unprotect the "ware list" sheet (no password for the protection) and change it. I'll be uploading a revised sheet with the few other errors I've found probably in the near future, too.

Thanks for finding that!

I managed to get a copy from bibliophile and it looks really good. Thanks.

Chris

Will do Fleshy.

Just wanted to make certain I hadn't missed some offical errata on that.

Thanks for the great work on the sheet.

As far as I know, there is no official errata on Augmentation yet. If there are, please send them my way and I'll incorporate them!

I've updated the files to a new draft (edited the first post with the links). There's a few bug fixes (like the one pointed out by Mr. Black), but the biggest change is just that I've changed the way having more than one essence reducing effect works. According to an example in Augmentation, it should be handled via multiplication -- that is, if you have Biocompatability, and install Alphaware, the total reduction should be:

Second-Hand Standard cyberware uses up more essence. But according to Augmentation, Second-Hand is also available in Alphaware.

The example given in the book (on page 32) that specifically includes Second-Hand Alphaware multiplies the two essence costs of 1.2 and 0.8, and gets < 1. This is why I included both possibilities in the spreadsheet. Synner says they should be added, but as printed, the book says multiply. Once there is an official errata, we can probably remove the option (or at least switch which one is the house rule), but for now, I figure it's best to let people do both.

Meh. The example on page 32 is wrong, and Nicola's Essence cost for that used Muscle Replacement (why?) should be 2.

I use muscle replacement. One of the characters I am playing here on the forms is an ex ganger from Caracas who had very limited access to both 'ware and nuyen and therefore has muscle replacement 1 as his only combat related cyber. The sprawl ganger archetype also uses muscle replacement. (I drew heavily from that when making my character.)

Also: great sheet, I'm a big fan. I'd also like (if possible) to have future releases continue to be Open Office compatible. My excel free trail ran out recently so I can only use the pull down options to edit fields in excel , but OO works like a champ.

Checking: Feshy, is there a maximum number of downloads from MediaFire? Because I just directed a very large number of people in it's direction.

None of their stuff when you join mentions anything of the sort, they seem to be a "more downloads the better" type site.

Chris

I'm getting a wierd error with draft 4. On the Cyberware_Bioware tab, all the values in the Cybr Ess. column are twice what they should be (according to the BBB, I don't have Aug). Note: bioware essence costs are unaffected. This occurs seemingly regardless of Grade.

An example: Datajack: 0.2, Wired III: 10
Hope this is just one error on an otherwise magnificent sheet.
Edit: alpha grade only takes off 10% of the listed essence cost (the normal amount it should, not twice the amount it should) e.g. Alpha eye recording unit: 0.18 ess, 4,000 nuyen.

No wonder my essence costs seemed high!

A temp fix for everyone until someone works out the underlying cause. Change the formula in row E to

=IF($A6="","",IF(VLOOKUP($A6,Complete_Ware_Table,2,FALSE)<>"Cyber",0,(VLOOKUP($A6,Complete_Ware_Table,3,FALSE))*(IF($C6="",1,(VLOOKUP($C6,Grade2,2,FALSE)))+Cyber_Essence_Reduction))*(IF($B6="",1,IF(ISERROR(FIND("E",VLOOKUP($A6,Complete_Ware_Table,5,FALSE))),$B6,1)))/2)

thats a total bodgy fix until someone can figure out the problem.

I think your posted formula will only work for row 6. Also I don't think it will solve the problem with the alphaware costs. (and beta- and delta-). I think the formula fix should be to subtract the original value of the essence cost (the standard cost) of course if you knew that you could just calculate the essence costs based off of that....
Note: Sensitive system (and I am assuming the other essence affecting qualities from Augmentation) doubles the essence cost as it should, but on its own line in the totaling section of the spreadsheet. (I therefore suspect that the glitch isn't quality related)

Oh yeah, change the first row of col E to that, then use the excel 'formula drag' to copy it down the entire Col, that will fix the entire Col by incrementing the values as required.

Also, it correctly does alpha/beta/delta costs. (try it!)

It's just a not very elegant way of doing it, but it does behave correctly in the cases I tested.

Doh! Somehow an old version of the formula got put in there; the one that doesn't properly handle the addition vs multiplication issue.

I'll have it fixed and uploaded in a few minutes. Sorry about that, I know I tested it before I sent it, so I'm not sure how I missed that. It's okay, I know what the formula should be, because I already wrote it once and had it working. Must have accidentally grabbed an older copy during one of the updates.

As a bonus, I've got some experimental karma calculations on the sheet now too!

It should be fixed now. Sorry to all those of you who downloaded it with such a big bug. I know I checked the results of that formula at some point before zipping it up and posting it, but I must have made some change to it afterwards to revert it.

I guess my quality control process needs a bit of work. But then, with a toddler and an infant, both of whom like to "help" daddy type, that's not a surprise...

New version is linked in the first post, as always.

The zip file for older versions of excel contains an .xlsx file, not an .xls file.

What a surprise, I've found another error in the sheet that's still a holdover from draft 5. The transgenic costs are twice what they should be, unless "Multipliers are handled additively" is checked.

Also, somehow the draft that got saved was one where I was only halfway through the karma cost section, and it's blank.

I've got a fixed sheet, I'll upload it again soon. Anyone else have any bugs to chime in about, so I can fix those too before I do?

Allowing to delete cyberwear by backspacing when you want to clear up the sheet would be nice.

Um sorry to point this out after you went and fixed stuff again, but:
I noticed that the formulas for the bonuses due to adept powers are not the same for each row. The first row is different (and seems to work properly). In the rest of the rows I just get "####" in each of the columns. This in turn causes (I think) the augmented stats display on the main page to display "###" for each of the physical stats, there is also an entry right next to the augmented stats column (I believe it is normally where you kept track of extra dice for damage resistance) that displays something like "Error: 502."

Thanks for the great sheet otherwise!

@Narse
Excel sometimes hides information behind pound signs (#) when there's not enough room in a column to display the full information. Try increasing the width of the columns with the #'s in them and see if that clears things up.

I'm using OpenOffice 2.3. All the fields that were previously "###" resolved into "Err:502" when I expanded the column width. So that includes the bonuses' fields on the adept power sheet (it doesn't seem to vary with power, all the powers I used outside of the first row give the same result) the modified attributes column for all physical attributes on the main sheet as well as the fields for initiative, IPs and damage resistance bonuses. Note that of the adept powers, those powers that should populate those fields (improved physical attribute, improved reflexes, mystic armor [I tested all of these, and all of the powers sequentially until the ones starting with I]) do populate the appropriate fields with the proper number (improved reflexes 3 puts a 3 in reaction and a 3 in IPs), but the rest of the columns still list "Err: 502".

Hope this helps.

Note: the zero's display as spaces in the first row on my sheet.

Okay, Draft 8 is now up, with genetech properly excluded from the list of bioware that is affected by grades, Type O, or Biocompatability. It is still affected by "Sensitive System" -- but I feel that is appropriate. Enjoy, and keep an eye out for more bugs.

Sensitive System actually only affects the Essence cost of Cyberware, not Bioware or Geneware in any way.

Love this spreadsheet. Awesome job to all who contributed to this! I'm certainly no Excel wizard like the rest of you, but I have made a couple modifications. First, I added Submersion and Max Resonance cells to the Technomancer worksheet. The Max Resonance cell will add the Submersion cell results to the result of cell B1. The formula I used was =IF(Technomancer!B1=Main_Sheet!M11,B1+G1, "")

You can see the screenshot here:

http://img.photobucket.com/albums/v401/Ang...r_Worksheet.png

I also modifed the gear worksheet to include specific information for weapons, explosives, armor, and equipment. I made a small change to the formula in the cell for total gear cost. The new formula is =SUM(A2:A31)+SUM(E2:E16)+SUM(E18:E24)+SUM(E26:E31)

I don't know how to add gear to drop down menus like you have with skills on the main sheet. If you can teach me, I would be willing to do it.

You can see the screenshot here:

http://img.photobucket.com/albums/v401/Ang...r_Worksheet.png

Looks *GREAT*! I'll send you a PM with some instructions. To be honest, I hadn't known a thing about Excel when I started this update project either - but it was a great way to learn!

...mmmmmm Explosives.

Looks good, finally a gear list I won't run out of lines on.

One possible adjustment. Maybe take part of the weapons list & designate it for Weapon Accessories and extra ammo. This way it will be right there with the character's guns & such and not use up lines from the general gear list.

Also a place to record Armour Mods such as Chem Treatment, Non Conductive etc. would be helpful.