Printable Version of Topic

Click here to view this topic in its original format

Dumpshock Forums _ Community Projects _ Chargen XLS workbook to tide you over

Posted by: blakkie Sep 21 2005, 10:40 PM

It doesn't print pretty. There are a lot of things it doesn't handle directly, primarily Specializations on Language and Knowledge Skills and use of capacity for adding cyberware other than limbs/skull/torso. You also are not prevented from or warned about some illegal character build, mainly cyber/bio interaction.

But overall it works ok and should allow for some assistance is chargen until a proper SR4 chargen is built.

P.S. My name is part of the file, but that isn't by my choice. The original author is Autarkis and some of the data comes from the NSRCG, particularly Knowledge and Language Skill lists. I'm just the last person to make changes, so it was posted with the qualifier of my name by the person hosting it, Shadow.

Posted by: blakkie Sep 21 2005, 11:39 PM

Er, I guess a link would be good.

http://www.shadowgames.us/shadowruntools/BlakkiesSR4Chargen.xls

Note that the maximum Attribute and Attribute costs are correctly adjusted for Exceptional Attribute as well as Lucky. The essense loss from cyberware is also calculated correctly for the Sensitive System (as well as having it's interaction with Bioware essense loss calculated correctly).

However the Aptitude Quality does not allow you to enter the name of the Skill it is for, nor does it raise the natural maximum for any Skill.

EDIT: I also have not tried to use this with Open Office, so results there may be sporatic.

Posted by: Ranneko Sep 22 2005, 04:38 AM

Negative qualities are not appearing to be added up at the top, also there isn't any place for Complex forms =(

Posted by: blakkie Sep 22 2005, 05:29 AM

QUOTE (Ranneko @ Sep 21 2005, 10:38 PM)

Negative qualities are not appearing to be added up at the top

Yes, apparently i emailed the file to Shadow before i saved the last time in Excel.

The Qualities work in some slots i believe, just not all of them. Some of the formulas in the hidden cells got humped during a rearranging of rows in the Qualities section. I emailed Shadow a file that works properly earlier this evening, but he's likely asleep right now. I expect it'll be updated some time in the morning.

Apologies for the mix-up.

QUOTE

, also there isn't any place for Complex forms =(

Sorry, Techo support is for crap right now. Apparently Autarkis didn't have Technos is mind when he put it together. Anyone that wants to take this XLS and run with it is likely more than welcome to. Just make sure to let Autarkis know what is up because eventually he'll be making some changes too. Think of this as a primative Open Source project.

Adding a Complex Form sheet would be be really easy. Basically type in the list, and set up an area where you select the Complex forms and assign ratings to them. Total all the ratings assigned and add that to the "Magic" sum under "Build Points" on the first sheet (yeah, that name should toggle between Magic and Resonance just like it does under "Stats").

Posted by: blakkie Sep 26 2005, 04:43 PM

A new version will be posted some time soon (email has been sent to Shadow). It will have the date of September 25, 2005 in the top right of the first sheet, above the Legend, to let you know you have the newest one.

This fixes some issues regarding Attribute limits. It now goes red on yellow if you try to purchase a natural Attribute higher than the maximum your race is allowed at chargen. Internally it also calculates the cost for an Attribute in a simplier, more elegant way than previous versions. As a user you won't really see a difference there except that it corrects an error that can occur in calculating the cost for an Attribute you have the Exceptional Attribute or Lucky Quality for.