True ... as good as corrected ... and also there is an issue in the melee weapon lookup...

fixed version will follow in a few hours...

I am sorry ... this was a pretty buisy day and I've had to take care of other things around.

Never the less, I've corrected all issues reportet so far (not only those here on dumpshock).

An extension of the program sec. is still outstanding same as a function to break out skills from a group (or combine single skills to a group).

Actual Version:
ZIP (5.0Mb): http://uploaded.to/?id=1mm31x
RAR (1.6Mb): http://uploaded.to/?id=r5d20v

... I've just saw that I've forgot to remove -116 KP mod in the karma break-down ... need to add this to the clear macro

With my adept I can add Attributes with Magic just fine, but adding to skills seems to not work. I added pistols at 6, specialization Ares Predator, Athletics group at 4, Improved Ability, Combat Skills and Improved Ability, Physical skills. my Agility is at 10. Pistols show as 16 (+2 for spec.) and athletics skill checks are at 7.

I am sorry I don't get it completly ... Can you provide me some more details what you've chosen exactly and are you working with the most recent version?

You're augmented aggility is at 10 with a pistol skill of 6 this would be 16 ... seems to be fine so far and when you choose the spec. for "semi automatics" it should display 18 in the combat section on the output-sheet. In regads to the Athletics Skillgroup, the group is linked to "Strenght" as "Gymnastics" is the only skill that is linked to Aggility.

Just found out about this really handy excel sheet, and it really is awesome. But playing around with it I had the feeling the following was missing:

- Shotguns
No entry for the Remington 990

- Bioware
Orthoskin has only one general entry (Orthoskin (1-3)) and you would have to chooose it several times if you take a higher level to make it calculate correctly. It would be nice to have the different level options like the other Bioware items.

And just a quick question:
I used this tool to create a new character buy his starting gear, lifestyle etc. , and when I had selected everything, I clicked the "Finish & Advance Character". All gear and cyberware etc is correctly transfered to the "Advancement" table, but so is their cost (that I had paid during the character creation). So now, if I want to print the character sheets, my character would start with tons of negativ cash. Is this working as intended.

(German reply via PM is possible)

The adept power "Improved Combat Skills", when taken for the pistol skill (just looked it up last night and found that it had to be applied to a specific skill) should add to that pool a number of dice equal to its level. (so, if i have 4 points in Improved Combat Skills (Pistol) In addition to everything above, I should have a DP of 22 = 10 + 6 + 2 + 4 )

The same applies to the Adept power Improved Physical Skills.

Hope this helps ^_^

(and yes this is the most recent version)

@cyberDrake: Okay now I get it ... this is not implemented but definatly a good thing to add, I will walk it thru and add the required changes to make this work. At all I think I need to do re-organization of the calculation tables ...

@Astartus: Normaly every subtotal from the build sheet should be subtract from the subtotal on the advancment sheet (I know not the best way to make this but it works ) but during the cyberware sec. re-designed I missed this. will be corrected in the next version, in the mean time you can add this amount of money in the breakdown sec.
Shotgun will be added same as the Orthoskin for the next re-lease on Saturday/Sunday

In regards to the inventory I will add also a sheet dedicated for accruals so you can remove hardware that was used and should not be available for usage any more without blasting the balance

After going through the Character generator a few times I noticed that when you select what Martial Arts styles you want and their associated advantages that it costs you 5 Bp on top of what you've already paid for the Martial Arts Positive Quality. The only thing that should cost extra is the maneuvers.

-Risingstar

Another thing that I have noticed is the sheet breaks in openoffice. Since that is all I have at home, it would be nice if it worked in OpenOffice(http://www.openoffice.org/) as well.

Whoa. People keep still developing this - and mailing me questions about it. A small notice:

IMPORTANT NOTE: I am no longer developing this particular character sheet. Other people have graciously continued my work, but I still continue to receive e-mails asking questions about this. This sheet has changed (and improved) so much since I worked on it, I can't really help anyone asking particulars how stuff in it works anymore, as I have pretty much lost track of how everything goes together myself. Sorry.

So - I can't respond to any queries or questions about the character sheet anymore!

Thanks for understanding, and keep up the great work you folks have done to it.

*looks around*

well, we got a lot of dev work done for a bit, but it seems to have stopped now. Have people given up on this sheet? I will contribute as soon as I can.

Is anyone still working on this file? The last update was said to appear last month but nothing has happened since then.

I just noticed (after thoroughly readying the Core Rulebook) theat there seems to be an error in calulation Knowledge Skill Points and Free Knowledge Skills Points.

When creating a character, you get (Int + Log)*3 free skill points, but in the file, it is labeled (and calculated) as free Build points which is wrong. The rating points should be compared to the free skill points and be substracted from them and only the overflowong ratings (or specialisations) should be substracted from the amount of build points.

I hope the minor bump is ok....I tried the other character builders, but some of them lack books that my group uses, and others I didn't like the output format so I decided to fiddle with this one a little bit.

Unfortunately, I don't quite understand (yet) how "SVERWEIS" works in Excel, but I'll work on that later.

Please let me know what else is missing or mistakes I made, etc.

The sheet is editted / modified in Excel 2007. There are addons for Excel 97-2003 to view Excel 2007 files. I have no idea if it works with open office or not.

I'm always open for more ideas or missing things that need to be added. preferably with rules (e.g. I have very little knowledge about magic, my chars are adepts most of the time)

Download link

• Cyberware compatibility is now properly calculated - Cyberware compatibility was not being considered
• "In Debt" is now implemented into Nuyen calculation
• Workaround: Free BPs for Knowledgeskills: it's now 1 "BP" per level
• added Cybersuite-modifier for cyberware (essence and nuyen are only 90%)
• Industrial Mechanic is now calculated
• Lifestyle builder is now deducted per month (the multiplicator was missing)
• Powered Slide now works (weapon add on)
• Attribute costs are now *5, not *3 (according to SR 4 E) To change this, go to Tables!AG1 and edit
• Activesofts are now 10000 per level (according to SR 4 E) To change this, go to Tables!C1426 and change the value
• Weapon Mod now automatically takes the weapons from your inventory to mod
• Armor Mod: has now armor X 1.5 Capacity or 6, whichever is higher.
• Armor Mod: Some modifications have been modified to reflect the rules, e.g. Fire resistance is always 1 Point regardless if it's level 1, 2, or 3 and always 2 points for any rating above 3 To that extend, the capacity "costs" have odd numbers like 0,6 which I needed to multiply and round with. I'm working on a better formula.
• Nuyen: Some formulas didn't work as intended, your starting cash is now much closer near 0 than it was before. Also removing Start-Character cyber or bioware no longer doubles the Nuyen
• Added houserule: 50 BP for "round characters": you can buy more skills and knowledge skills to build a "rounder" character. These skills may not be used for essentials like shooting, but rather for things like: cooking, hobbies, and the like. To remove that, simply edit Build!K2. The Character sheet itself *should* only show the starting BPs you selected.
• Advancement: Martial arts is now calculated with the active skills. I couldn't find where to add the value itself, for some reason it was always omitted. Even though the Karma invested in Martial arts is added to both the MA tab AND the active skill tab, it's only calculated once.

Edit: Sept. 12 - 2009

• Cyberware: new calculation, formerly, I multiplied all modificators, so 0.9 and 0.9 would be 0,81. it is now 0.8.
• Cyberware: added calculation for Adapsin in the Advancement field for future cyberware. Selecting "Yes" will add an additional 0.9 multiplicator
• Bioware: added bioware compatibility positive trait into the calculation
• Bioware: You get one free Genetic enhancement with "Genetic Heritage", I added a "Free?" choice to reflect that. selecting "Free" means no Nuyencosts, but essence will still be deducted.

I still need to check cyberware and bioware essence costs, some things seem to be wrong. If you notice something out of line, let me know

End edit

When purchasing a SIN, the availability is calculated with Rating x 4. It should Rating x 3. Was mentioned in both Errata and SR4A.
The Drain of "Detox" is given as Toxin DV - 2, it should be Toxin DV - 4.
Great Spreadsheet, I love it.

Download link

Changes:

• Fixed Output into Character sheets. I made an oopsie and the result was that ALL skills were transferred, not just those you actually learned. The oopsie has been adressed and removed.
• Added Remingtom 990
• Changed fake sin availability from 4x to 3x rating
• Changed Drain of "Detox" from Toxin DV -2 to Toxin DV -4
• Changed range modifier for firearms to -1 (short) -3 (long) -6 (extreme), to be in line with SR 4E - this is just a cosmetical change, you can revert it back to -1 -2 -3 by changing the numbers in the appropriate sheets. (Basic Main, Basic Alt, Combat)

Download link

Changes:

• Armor Mod: Differs now between capacity for armor suits (like military suits) and maximum weapon mod capacity (e.g. coats). You will, however, have to enter the maximum capacity yourself in the appropriate field. Leave the field empty if you're not using armor suits.
• Some cosmetic changes that I can't remember

Hey guys, I'm back!

I'm glad to see the Character Sheet has seen some GREAT progress! I can't thank DarkSeven & Kentaro for all the great work they've done to improve the sheet!

It also looks like our group is finally going to play some SR4 after our long break from it and I'm playing a Hacker (after YEARS of playing a Mage, all the way back to SR1!) so I've been reading those rules a lot lately and it looked like there were some errors in how some of the dice pools were calculated (or wrong skills grouped with the programs). So I've updated both Character Output sheets (and WOW, awesome job on those! I love all the different sheets, the Cyberware one is so pretty! )

Anyway, I digress. I hope Kentaro doesn't have any major changes since his last post? (It's what I used and built off of that). I've posted the updated version on my site along with a little gift to the other hackers (I made some cheat sheet cards, and anyone familiar with the old CCG may notice, well, some <ahem> artwork lol) I make similiar cards for all the games I play (Earthdawn, WoD (VtR, WtF, MtA), Scion, etc) so I'm getting pretty fast at it lol (Mail Merge + Publisher + Database FTW!)

Anyway, as usual, you can find the material at http://shadowrun.nerps.net

Direct Download Links:
http://shadowrun.nerps.net/Shadowrun_4th_E...ator_v2.0.0.zip
http://shadowrun.nerps.net/Hacker_Program_Cards.pdf

PS If anyone needs me to host alternate versions or any other SR material, let me know, I have plenty of room and never plan to give up my DNS host name!
PSS Also, if anyone finds any errors, post, PM, or email me and I'll get it fixed as soon as I can...

Thanks for these - the cards in particular are great!!

AJC

Thanks! It was out of self ignorance I had to make those lol I have to say, running a Mage is much easier than a Hacker! I figured I could use them to track what programs I currently have "loaded".

I used the same principle running a Nethermancer in Earthdawn to track spells in my Matrix and it worked pretty well.

Cool - now we just need the spell cards as well...

AJC

Are spells really that complicated in SR4 though? Never felt the need for any info outside of the character sheet personally.

Not really - I just like the look of the cards... 

AJC

I'm using open office 3.1 and when I open up the SR Character Creator and try to select a race, all I get is a zero.


Same for any thing else with a dropdown box.

Any suggestions?

Sorry, I only support Excel (never tested open office). With the macros and complicated formulas, it's usually a lost cause to get these spreadsheet generators to work on both excel in open office.

Maybe someone else on the boards is an open office wiz?

How about putting up an Excel 97 or 2003 version?

Thanks

Just tried to save the sheet in the 97/2003 format and (as suspected), got a whole bunch of warnings re loss of functionality and fidelity. Pretty sure that this means "converting" to the older format would mean a major overhaul/re-write.

AJC

Your wish is my command! I'm now hosting 3 versions of the sheets at http://shadowrun.nerps.net

I need volunteers to test them. The 97-2000 had several warnings so not sure how it will open in previous versions of Excel.

The ODS version is saved in Open Document version! (I missed that announcement, apparently in Office SP2, they added Open Document support! yeah!) So all you Open Office people, give this version a try and let me know if it works?

Added:
http://shadowrun.nerps.net/Shadowrun_4th_E...0.0_97-2000.zip
http://shadowrun.nerps.net/Shadowrun_4th_E..._v2.0.0_ODS.zip

Thank you very much.

The Open Office version had issues as well as the Excel 97 version, but then I opened the Excel 97 with Open Office and it worked great so far.

That's interesting... At least it's working at some level. What sort of issues does the ODS version have? (ie completely doesn't work or same issue as before with dropdown lists?)

I wonder if I take the 97 version and save that as ODS?

So I may be silly, but shouldn't it keep track of my points? It's not adding anything up.
I tried both excel versions.

Yes, it tracks BP and Karma spent as well as NuYen. What version of Excel are you using?

You may have to accept the "Certificate" install and "Trust" it for Macros to work properly.

Thanks for proving me delightfully wrong...

AJC

You need to install the certificate to be able to progress your character.

I found some problems, so ill list them here, and ill keep doing that with things found in the future.
(im using the regular version, aka. excel 07)

1. in the BP column of knowledge skills (sheet: build) two of the lines says 3 instead of the calculation thats supposed to be there, effectively lowering your free knowledge points by 6.
2. Missing from the list of gear is the anti MAD scanners from runners companion page 34-35
3. on the advancement sheet you are set as having matrix jargon speciality for your native language, making you start with -1 karma. clearing sheet does not help (leaving me to suspect that its incapable of clearing that field)
4. on "basics main" and "basic alt" sheets all ranged weapons have their ammo pointing at "Advancement!$F$316" when in fact they should point to 316, 317, 318 and so forth.
5. the printable sheets have no capability to reflect that i own more than one vehicle. this quickly becomes a problem for some characters.
6. the drone sheet picks its data form line 603 in the advancement sheet. that is my second vehicle, certainly not three drones.

Keep up the good work, its a great sheet. I can fix some of the problems myself, but not all (i dont know how to make a dropdown list or macro, but i can fix numbers and copy paste!)

Thanks! I've been discovering several of these as well as other hard-coded values left over from who ever used the sheet from when I picked it up. I'm tracking em down as I find em!

1. Already Fixed
2. I'll add this in
3. Correct, it's not clearing that out properly, I'll get that fixed as well
4. Think I have that fixed
5. You could use the drone sheet? Vehicles and Drones are interchangeable
6. I didn't do those sheets but I'll take a look at it. I'm still trying to figure them out as well

Would you like me to copy the Drone Sheet and make a Vehicle Sheet and then make a seperate section for each allowing you to basically have/customize 3 vehicles and 3 drones?

One issue that I have found is Chemistry is not listed in the Technical skills section.

Odd, and that's probably been missing for 2 years and your the first one to mention it!

I'll fix it for the next release.

OK, version 2.0.3 is up. I've fixed all the errors reported I believe.

As usual, you can grab the updated version at http://shadowrun.nerps.net

-------------------------------------------

v2.0.3
Jamz: Removed various Hard Coded values left on from previous owner
Jamz: Added Skill Specialization Dropdown selections
Jamz: Fixed Cyber Right Leg & Foot copy from Build to Advance sheet
Jamz: Added Anti-Mad Systems, Chem-Sniffer Defense, and Renraku Infilitrator Drone (all from Runner's Companion page 34-35
Jamz: Fixed ammo on Basic's Main and Basics Alt sheets
Jamz: Added the ever missing Chemistry Skill. (anarchists rejoice!)
Jamz: Fixed Drone Output Sheet
v2.0.2
Jamz: Fixed Knowledge Skill calcs on Build Sheet
Jamz: Fixed WeaponMod and Armor mod page errors

I have not been able to open any of the latest version. I am running Excel 2000. It will not recognize the ODS version, and it tells me too many different cell formats when I try to open either of the excel versions. Any suggestions? I enjoyed working with some of the older versions of the sheet, and was hoping to use this one.

Hmm, 2000 eh? There isn't anyway for me to test it myself to try and correct it, sorry.

Maybe try and install OpenOffice, it's probably much better than Excel 2000 anyway.

Uh, I am uncertain if you have implemented Unwired fully into the chargen, but you maybe missing More than Metahuman.

I didn't enter the Unwired data, so not sure why some of it's there and some isn't, so post anything you find missing!

I've entered the following missing Qualities for the next release:
- More than Human
- Obscure
- Resonance Bond
- AIPS
- Data Shadow
- Media Junkie
- Virtual Personality

Also added Full Immersion Lifestyle.

I've been puzzled as to why a gnome with control rig and datajack upon advancement is 4(5) for the agility attribute.
Upon advancement under the nuyen section, I should have zero however, I have excess funds.

That is how much you bought gear for i believe, i am not completely sure why you would want it there, but it shows on the top of many of the printable sheets aswell.

Hey! Great work so far, you surpassed everything I tried to do from your older sheet by far!

A couple of things I'd like to see here that I'd just added when I found out you'd continued this sheet:

Submersion costs: The costs seem to be missing group and ordeal modifiers (like Group Submersion discount + Ordeal like Great Hack for instance). Can you throw those on the next version?
Optional Rule: Additional Metamagic/Echos. In Unwired it gives an optional rule for purchasing an additional echo per Submersion level. I assume it's the same for initiation.
Is there a way to navagate the sheets more quickly? Or at least print them all more quickly? Maybe a new sheet that says PRINT and with check marks to print each sheet (for those who don't want to laptop it to a game). That way you could click the Print page (right after Nuyen/Karma for example) and then select Basic, TM, Veh, Combat, ect... and get the sheets you want printed...well, printed. It would be a bit easier for the user, not sure how easy for you the coder though.

I didn't see it in this version (may have missed it) but I'd just started working on adding Custom Complex Forms/Programs to the sheet I was working on. Somewhere where you can type in a custom entry and rating and then it would appear on the Hacker/TM sheet for printout (examples of what people would use this with are like TacSoft CF's or Biowire linked ActiveSoft CFs).



This is a GREAT sheet and I've started using the hell out of it, thanks so much for picking this back up Jamz!

Okay, this is likely an idiot question, but when I open up this sheet all I see are the formulas, not the drop down lists. I changed my macro security, but I still only see formulas. What idiot thing am I doing wrong here?

I'm seeing the samething in OO 3.1

Hi Jamz,

first of all I love your great work.

One thing I'm missing is ... it is "only" English.
I thought it would be really great if this would be multi language...
Yes I know that is a lot of work. But if possible could you make all fields variable?
I'm thinking of a translation table where all text is listed.
Each column one language.
And a dropdown to select the active language
if there is no translation the English word is used.
So anyone could translate what is needed.
By time we would get full translation.
And the actual translation does not have to be done by you.

If this ist to much work for you I would ask if you have a modified version not jet published?
If not i would start this work on version 2.0.3.
But I only use OpenOffice so I do not know if there are issuse than.
OO opens the 2003 version with no problems only some conditional formats and colors are missing as I noticed.

Tanks a lot.

None of the three downloads will work on my computer!

On one of 'em it says, "Too many different cell formats." What the frag does that mean?

This means that Konditional Format are lost wenn working with this sheed.
Excel pre 2007 only allowed 3 Formats per Cell.

I started with the translation feature... I will post ist on the weekend...