[X] My Assistant

[barrelv]

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?

[RobertB]

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)

[bernardo]

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

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.

[DarkSeven]

Hello together,

A little while I ago I discovered this chargen and from the first moment I was hooked up (IMG:style_emoticons/default/wink.gif)

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 (IMG:style_emoticons/default/wink.gif) )

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% (IMG:style_emoticons/default/wink.gif) ).

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)

[Xerxos]

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! (IMG:style_emoticons/default/smile.gif)

[Taral]

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/

[RobertB]

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! (IMG:style_emoticons/default/smile.gif)

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.

[Xerxos]

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

[DarkSeven]

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 (IMG:style_emoticons/default/wink.gif) ) 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 (IMG:style_emoticons/default/wink.gif) ) to the next version so every can take advantage of.

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

[TwiggyTheScriven...]

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.

[DarkSeven]

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

[cyberDrake]

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!

[DarkSeven]

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?

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 (IMG:style_emoticons/default/wink.gif) . 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!

[cyberDrake]

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

[DarkSeven]

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!

[cyberDrake]

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.

[Xerxos]

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.

[DarkSeven]

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 ... (IMG:style_emoticons/default/eek.gif) ... (IMG:style_emoticons/default/spin.gif) ... (IMG:style_emoticons/default/wobble.gif) ... (IMG:style_emoticons/default/rotate.gif)

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!

[Deus Innomen]

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. (IMG:style_emoticons/default/smile.gif) (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. (IMG:style_emoticons/default/smile.gif)
* 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. (IMG:style_emoticons/default/wink.gif)
* 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. (IMG:style_emoticons/default/smile.gif) I'll definitely be watching for updates!

[cyberDrake]

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...

[DarkSeven]

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 (IMG:style_emoticons/default/wink.gif)

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!

[Deus Innomen]

Great, thanks for your work, Dark. (IMG:style_emoticons/default/smile.gif) 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.

[MishMal]

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.

[DarkSeven]

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.

[Deus Innomen]

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.