SR4 Excel Character Creator Spreadsheet, v0.9 - almost final version Options

[DarkSeven]

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.

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

fixed version will follow in a few hours...

[DarkSeven]

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

[cyberDrake]

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.

[DarkSeven]

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.

[Astartus]

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)

[cyberDrake]

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.

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)

[DarkSeven]

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

[risingstar]

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

[cyberDrake]

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.

[Wizdoc]

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.

[cyberDrake]

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

[Astartus]

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.

[Kentaro]

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

[Blackbot]

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.

[Kentaro]

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)

[Kentaro]

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

[Jamz]

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

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

[AJCarrington]

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

AJC

[Jamz]

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.

[AJCarrington]

Cool - now we just need the spell cards as well... (IMG:style_emoticons/default/grinbig.gif)

AJC

[Jamz]

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

[AJCarrington]

Not really - I just like the look of the cards...  (IMG:style_emoticons/default/rotfl.gif)

AJC

[cndblank]

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?

[Jamz]

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?

[cndblank]

How about putting up an Excel 97 or 2003 version?

Thanks