Yeah, I sent them to Jamz - at - nerps etc.

Basically it said that the equation to the right of the skill groups' table needed to be edited to read "sorcery" instead of "sorcery skill group". After finalizing I saw that a lot of the questions I had were taken care of on the finalized character sheets.

Nice little storage setup as well. Pretty much unlimited NPC fun!

Also, good point about the multiple focus/on-off issue. I typically get a power focus at chrgen and it stays on (GM is not a stickler for tracking, wards, etc.), so I wouldn't mind seeing it. I suppose if there was a list of the foci on the magic sheet near the spells that would take care of it.

Thanks for your work on this.

sweetness.. we just decided to reanimate our sr group and switched to sr4, so your sheet is a great help! just downloaded it...

but wouldn't it be better to edit the first post and add the most recent downloadlink? ^.^

Anything new? *curious*

Uhhhm,

This may be because it's after midnight and I'm just being slow, but I can't download the sheet.

I can link to zUpload.com, but from there I can't do anything except link to several pages for webhosting, or endlessly loop back to zUpload.com.

If I right-click on the "Download File" link and select "save target as...", I can only download "download.htm"

What the hell am I doing wrong here??

I just downloaded it from the link, DragonMech. All I did was left click on the "download file" header at the top of the page. Perhaps there were server issues when you tried?

God must just really dislike me then.

I've just tried again and I get the same thing.

I do use a download accelerator, but I get the same results with that disabled anyway.

I'll get a fried to download it and email it to me.

Thanks anyway.

Couple things:

1. I'm NOT the original author so I can't edit the first post etc. Also please give all props to WizDoc for all the hard original work!

2. RL got in the way but I put up what I have so far. It DOES have some bugs and not complete though. Most bugs are display only bugs and so all calcs should be correct to best of my knowledge.

3. I plan to make at least a few updates to at least get it finished. After that, I'm going to look into a new product from LoneWolf. They are the ones who created ArmyBuilder and are now making a Generic Character Generation program and plan on having modules for d20 and SR4!

4. Here's the link for the latest build: http://shadowrun.nerps.net

I probably should add...

When you are done "Building" your character on the build sheet, you MUST click the "Finish & Advance" button for any data to show on the character sheets.

You can finish & build multiple times also if you need. It basically copies several fields from the basic sheet to the advancement sheet.

^ I haven't used it yet, but it looks pretty and more complete than the .9 version.

I think I found a bug. It seems to calculate the special attributes (ones that don't count toward the 200 point cap) as normal attributes. Namely Magic - as I make a magician it counts the points put into magic as those applying to the cap. Which I fixed by modifying thr formula to not include those cells.

That's really good!
The only thing i don't like is that it's quite hard to add new content, say, new spells from Street magic, because it messes up the tables...

Finally managed to add a spell...had to modify several lists, copy formulas.. it's long and i'm sure i'll forget everything in an hour :x

Great work continuing the spreadsheet Jamz. Just wanted to add that if you do a "Save As" instead of a save the next time you work on the spreadsheet, you can remove about 3 megs of bloat in the file. Knowing that these excel files can get bloated like that, after I downloaded your file and unzipped it, I used "Save as" to reduce the file to 1.35 Meg from 5.27 Meg.

Also, I've noticed that when you use Stick and Shock ammo on a weapon, the sheet adds the power of the weapon and the power of the ammo (6S(e)) together to get a final value instead of just replacing the value with 6S(e).

Thanks for the great work.

Robert

Started messing around with this, but it seems some gear is missing, or am I incorrect?


Specifically, I can't find where to modify armor, or where to purchase magical supplies such as Fetishes.

Looks sharp tho!

<edit: Oh, it also calculates Availability for Power foci incorrectly, should be 5xforce, not 4xforce>

Maybe an Open Office problem, but the buttons do not work for me, (print, finalize, etc.) I get a script error.

There's a bug wehn you buy titanium bone lacing, that it doesn't correctly calculate the body bonus.

Hey, Jamz, is there any chance that the d/l link gets fixed? Pretty please?

Because right now its a dead link.

I'd love to see this and see if it's more contentedly running on Office 2004 (OSX) than the older version I tried......if only the link weren't broken......sounds like some great ideas and changes all in all.....

Can do. Will send you a PM.

Robert

ok, for anyone who wants this (with robertb's updates per rules clarifications and updates) it's downloadable from jamz character builder for now...once he gets back and has fixed the link for his I'll delete my copy, or, will set it up to redirect to his site.


---edit---
disregard previous edit.....SOMEONE needs to make it flag larger when it decides not to calculate your skills because you've exceeded the 1@6/2@5 thing....(when you're building a character that's slightly advanced or has the aptitude trait you do actually get around that) and it doesn't calculate the skill points anymore.....

Nice Sheet.

Very helpful. Thank you to all involved.

Two questions

One is there a database of characters that could be used as a template?

And two, if you have a skill group of 4 and you want to add a specialization or decide to raise one skill to 5 then how do you break the skills group back up in to the separate skills?


Thanks.

Any work on this being done anymore? It would be killer if Arsenal, Augmentation and Street Magic were in it.

Hey all, sorry for the um, year long afk...

Basically, our group rotate games every 3-4 months, we're currently on Earthdawn (woot!) and making our way back to SR lol. The link should be working now at http://shadowrun.nerps.net

I don't have most of the latest books but it looks like someone above added some stuff? If someone has modified my sheet and wants me to incorporate it, send it my way and I'll host it.

I probably wont be making many changes to the sheet until we next play, but if you email me, I'll see about correcting any bugs. I can also answer any questions if anyone wants to know how to modify the sheet. It uses a lot of the same principles as my Earthdawn sheet. It's been a while but it shouldn't be that hard to add new items/spells etc. I'm always looking for data monkeys lol

Lastly, I'm on Office 2007 now, but if you all need me to, I can host a 97-2003 compatible version as well if I make any changes.

Jamz, I was wondering if you had done any updates to your spreadsheet lately?

Sorry, no I have not. We've been playing Earthdawn (Redbrick's) lately and have spent most of my time working on that spreadsheet and some other projects.

If anyone has added to the sheet and need me to host it, I'm more than willing.

This was one of my favorite character creators back when I first started playing Shadowrun. I'm thinking about starting a new group up and I'm hoping to come back to this same creator, maybe. Any updates?

This is my favorite sheet also since it produces such nice looking printable sheets. There haven't really been any updates to this sheet in a long time. What I've been doing is adding equipment, cyberware, etc. as needed for my character as new books come out.

I know a lot of work is going on with that other excel spreadsheet, but I don't think the output is as nice.

Robert (aka Spanner)

The two projects really should unite their forces and add to them that gear builder from the other thread. That would be the ultimate SR4 character builder.

Hello together,

A little while I ago I discovered this chargen and from the first moment I was hooked up

I think the idea behind this chargen is the best especially as it produces such nice looking, handy and ready to use char-sheets. I thought that there where some functions missing and there should be more ways to get data on the sheet or screen and as there haven't been an update for more than one year I've planned to update it on my self.

Now I've got a week of time so I took my rusty excel skills (not as advance as some other guys here) and started working on. Now that I've got a first (beta)version ready I want to share it with you. Regretfully I wasn't that familiar with the macro functions that have been used in the original sheet so I replaced them with my own (not that cool but they are working). I've added some function and I was forced to re-design the first two pages so I gave them another design (I think it is a little bit more user friendly). I've created some more output pages and changed the theme to blue (I don't like the green looking style )

I hope that everyone worked on this in the past is fine with what I'e done, you've done a really great job and I just followed your ideas and added some of my own! (If not let me know and I will remove the file immediately).

This version is still in beta testing as there a lot of functions and formulas that don't work 100% (not even 95% ).

It would be great if you can give me feedback on the work I've done and help me to make the sheet better and serving all needs. Things I am still working on:
- Customs Weapons and Armor (Testing required)
- Vehicle & Drones modifications (most is in, a lot of testing required)
- Advanced Metatypes (nearly all done)
- Infection (infection after generation is missing)
- A lot more I currently can't remember (I should start writing that down)

I've got the issue that I've reached the maximum of possible different cell formats Excel 2003 can handle; there are only 57 possible cell formats left! (If anyone had this already you know that this is a pain in the ass). So currently it won't be possible to create new output pages (I will need to re-design the complete sheet or change to Excel 2007 (for me 2007 is no problem, but I want keep it compatible for everyone). Maybe I will make a 2007 version with different themes (Red, Blue, Green and so on).



The sheet is available as ZIP and RAR (March 14th) - Here:
ZIP (5.0Mb): http://uploaded.to/?id=1mm31x
RAR (1.6;b): http://uploaded.to/?id=r5d20v


P.S.: Please excuse my bad english (I am from Germany)

I can't find the Attention Coprocessor (Augmentation p. 36) or Phenotype Adjustments (Augmentation p. 89). Did I overlook something, or is it not in yet?

Anyway, great chargen!

v0.991 fell out of the Matrix. Must be a hole somewhere.

Anyone have a copy?

Edit: Nevermind, found Jamz version: http://shadowrun.nerps.net/

Progress on this spreadsheet stopped before Augmentation came out. In fact, I believe the only additional core book that's included is Street Magic. Anything else you'll have to add yourself.

Well, DarkSeven's version adds a lot form Augmentation, but it seems Gene Treatments and Headware were not included yet (unless I'm wrong).

Thanks for the feedback

Headware is in but it looks like it wasn't clear how and where you can add it (Correction: it was indeed not possible to chose the headware). I've corrected this and added a few comments and changed the color set in the cyberware section ... now it should be more easy. Gene Treatments are indeed not implemented I will add this to the next release as bioware (should be on tomorrow).

Due to the headware issue I've discovered another open item I need to work on. You can't choose all possible cyberware in the according sub section (will need to re-design the source table), I hope to get this changed for tomorrow!

But first here is the new release for which I've concentrated a lot on the output of the char-sheets.

Changes:
- Added a function to change color set (you can enter RGB values and set the char-sheet to what ever color set you like)
- done complete re-design of the printable sheets to get rid of the "max cell format" issue (this was a realy ugly work ) but for some reasen the sheet is now unpacked 7Mb, I will try to size it down again!
- Slight adjustments to the source tables
- corrected some callculation issues

In regards to the color change feature if you like it and find cool color sets please share the RGB values with me then I will add them as fixed themes (of course with credits ) to the next version so every can take advantage of.

I hope you enjoy:
please see my first and last post for actual verions!

Holy crap! I've been spending the past month working on adding the updated information back in to a 2 year old version of this sheet I had... suppose I should be checking the forums more often... Anyway, great work in my opinion DarkSeven. If you want any specific testing help, send me a PM, I've been working on different implementations of the weapon and vehicle mod stuff and it'd be great to compare notes. Also - while three drones is plenty as backup most of the rigger characters I've played with usually want a lot more, and they're the ones that would most benefit from being able to keep track of their equipment this way. The original size of the positive/negative qualities sections don't really have enough space for tier III changelings, and the gear section is tiny in comparison to the enormous amounts of equipment a lot of runners even start with, let alone accumulate. If all this sounds like nitpicking, it is... but obviously from the work you've put in there's a great attention to detail here. If you don't mind, I have some ideas on making the sheet more scalable in terms of space for both starting and advancing characters without looking too ugly. I'll upload the altered sheets here if anyone wants to see them.

Thank you ... and all you've said is a goog point. Indeed there shoud be more space for qualities (espacilly for changelings and infected people), I thin I should create a second basic sheet with less skills and space for more POS and NEG qualities (devided to two different fields). In regards to the inventory I was planning a dedicated sheet for stuff you can carrier around.

At all ... currenlty (as long as I don't get stuck again with the cell format issue) there is no problem to add more pages to the sheet and everyone prints what he needs.

Yeah ... would be great to have look to your sheets ... thanks

I am looking at using this sheet to track my Jaguar shifter Gun-fu Adept (yeah yeah I know, kinda cheesy, but I like his story) This sheet puts his racial max agility at 10, but the Runner's Companion puts the racial max at 8.... is the sheet wrong, or is there somewhere else I should look for the stats?

Thanks!

You're right ... I've corrected this and some other attribute values!

@TwiggyTheScrivener: In regards to the Drones ... There is space for one main Vehicle and three modified drones. I could add another page for more drones but in my experience those "replacment" drones don't survive long enough to deserve a digital documentation (including modifications and all that stuff). I would prefer to keep this space for other things (currently I don't have an idea but some one will definalty make a sugestion) as there isn't infinity room for growth in Excel 2003 and again I'm walking on the edge . I will add the drones to the gear sec. so you can add more there (without modifications), would that be a workaround?

And es promised here is the most recent version, regretfully I didn't get as much time today is I wanted so I was not able to do a complete testing (I hope that there are no major bugs in it)

What changed (v1.995 beta):
- Corrected Racial source data and callculation
- Added a character summary page with more space for Qualities (divided to positive and negative)
- Added geneware (no auto callculation, yet!)
- Corrected some cyberware values
- Added more rows to the gear section
- Created extra page for Inventory

please see my first and last post for actual verions!

Thanks for the quick response!

The racial max looks good now, but I think the augmented max is off, is it not? 8 + half 8 = 12

*argh* You're right ...

Here is a corrected version:
please see my first and last post for actual verions!

I hope I am not being annoying. When you choose the invisible way (for example) as your magic tradition, the sheet tells you to choose the adept gift. However, this red warning message does not go away after you do choose the gift in the positive qualities section.

Yes, I noticed that, too. I think he searches for "Adept" and the entry is named "Adept (M)" .

I don't know if this is related but the Adept powers also don't show up on the character sheet.

Yep that's correct ... I've changed some Quality names to make them completly unique and then I forgot to correct this everywhere.

In regards to the adept powers ... I wasn't able to reproduce this issue, please check if the issue still occours with the actual version.


At all ... I've done a lot of testing today and corrected a few major issues and many smaller (cosmetical) things.

The sheet should be currently in version I call usable and stable ... it is still a beta version ... but everything you need should be working.

Until end of the week I will try to spent some time on the modification pages to make them accurate and free of callculation issues.

Regretfully I got stuck again witht he "Max Cell Format Issue" that is just ... ... ... ...

Here is the actual version ... if no one finds issues there will be no further updates for this week:
please see my first and last post for actual verions!

Wow, this definitely is a well executed spreadsheet.

Here's what I've found while playing with the sheet, all on the Build page but possibly carries over to Advancement:
* It doesn't seem to be accounting for the free Knowledge Skill BPs correctly. For example, I should get the first 27 free, and I took exactly that many, but it's still charging me 27 BP in the BP Break-down section.
* The total for Common Gear (at D241) is pointing to the wrong place. It should be pointing to "=F490+C501".
* The Head Cyberware section is a little small. There's a LOT you can add that has no listed capacity. Either I need it expanded, or I need the ability to add non-capacity stuff somewhere else. (Wired-to-the-gills hacker at your service!)
* You're missing the Purge program in the Common section of Programs. Also, a few blank spaces for custom programs would be nifty, but that's a Nice-To-Have.
* You're missing the "Media Junkie (Mild through Burnout)" negative quality from page 37-38 of Unwired. I swear everybody misses this one for some reason! I can use "Addiction (Mild through Burnout)" in its place as it's effectively a specialized version of that and the bonuses are the same, but I'd like to be able to show the real quality.
* Another nice-to-have-but-probably-difficult: being able to break out and individually advance specific skills in Skill Groups without having to go add the negative modifier to the BP/Karma Break-down section.
* Is it possible to get the Combat page to account for specializations when calculating the dice pool? For example, I have Automatics (Assault Rifles) and it doesn't seem to be adding the +2 dice to my FN HAR for my specialization.
* If the Advanced Vehicles Modifications setting is on, the modifications don't seem to get placed on the "Drones" character sheet. If I turn this off, the standard list of mods shows up correctly. When on, it's "0".
* Related to the last note, there's a lot of places where it shows "0" instead of a blank box. Minor but annoying.

That's what I see at a glance. None of this really prevented me from using the sheet, though, and the resulting character sheets are simply fantastic. I'll definitely be watching for updates!

This sheet rocks!

The thing that i noticed, and this is probably not a bug, but a request for improvement, is the Metagenetic Qualities don't all seem to affect the stats they should (for example MetaGenetic Improvement (Ability) )

Also, certain adept powers fail to be calculated in on the char sheet, like Improved Ability, Combat Skills or Improved Ability, Physical Skills

Keep up the awesomeness, man!

-EDIT-

I noticed that the changeling quality is missing as well...

First of all ... thanks for the feedback ...

@Deus Innomen:
- I can't find a issue with the Free Skill BP callculation ... If you like, send me a copy of your char-sheet and I will take a look.
- Common Gear callculation was indeed pointing to the false cells (CORRECTED)
- I've done re-design of the Cyberware section and enlarged the headware space
- Purge and Custom programs ... Indeed correct/true ... I will need to re-design the Matrix sheet for this (Will be done for the next release)
- "Media Lunkie" has been added (If I missed something else, please let me know)
- The breakout of Skills from a skill groups and the other way arround is indeed not easy to reallize, I was thinking about this already ... I hope that I will get some more time in the next week to write a macro that can handle this function.
- Rangedweapon spec. are now tkane onto account (melee to follow with next release)
- There was indeed a formular error in the Vehicle section (CORRECTED)
- I'v exchanged many of the "0"s with "-" and indeed it looks better now!

@cyberDrake:
- Metagenetic Qualities have been taken onto auto callculation (and also the Genware mods)
- In regards to the adept power callculation, I could not find any issue ... maybe you can send me you'r char-sheet and I will take a looks.

@Xerxos:
Danke für deinen Hinweis ... habe Ich korregiert

Thank's to Xerxos who pointed me to a issue in the gear copy function that screws up the macro. This has been corrected, now you can add the geartype names as headlines to your gear sheet.

Other things I've corrected/changed:
- Wokred on the Adeptpower Magic split for Mystic Adepds
- Streamlininging of the Atribute Callculation
- Corrected minor source issues.

Regretfully I didn't got as much time as I wanted to ... so I was not able to work on the Weapons and Vehicles modifications! ... Hopfully tomorrow ...
...

please see my first and last post for actual verions!

Great, thanks for your work, Dark. I'll grab the new version and start playing with it, and will let ya know if I encounter anything else. I think I figured out the skill points thing, though, and it looks like it was my fault in the "first character ever" sense.

I'm not sure if I'm missing something simple but when i open the spreadsheet i have an augmented agility and reaction of 2.
I'm not sure what is giving these bonuses.

You're right, I've just received a PM from "Xerxos" reporting the same issues. This is related to modifikator that I missed to rest. You can find it on the "Basic_Main" sheet, it's called "PEN" and you will need to replace the "1" with a "0". This value is designed to modifiy the penalties by to much armor.

For the next release I will add this to the reset macro.

@cyberDrake:
Totally forgot ... Changling (SURGE) is now implemented more completly with callculation of the received free BP.

Looks like TotalEssence is calculating the cost of your cyberlimbs twice.

In TotalEssence: "=ROUND(MAX(D368+D439,D462)+MIN(D368+D439,D462)/2,2)"
In D439: "=SUM(D372:D438)*IF(Tables!D43,2,1)+D368*IF(Tables!D45=1,0.9,1)"

Bolded the cost of cyberlimbs. I think your easiest solution is to take D368 out of the TotalEssence equation, but it's your call.