IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Chargen XLS workbook to tide you over, Rough and tumble
blakkie
post Sep 21 2005, 10:40 PM
Post #1


Dragon
********

Group: Members
Posts: 4,718
Joined: 14-September 02
Member No.: 3,263



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.
Go to the top of the page
 
+Quote Post
blakkie
post Sep 21 2005, 11:39 PM
Post #2


Dragon
********

Group: Members
Posts: 4,718
Joined: 14-September 02
Member No.: 3,263



Er, I guess a link would be good. :wobble:

http://www.shadowgames.us/shadowruntools/B...sSR4Chargen.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.
Go to the top of the page
 
+Quote Post
Ranneko
post Sep 22 2005, 04:38 AM
Post #3


Moving Target
**

Group: Members
Posts: 349
Joined: 16-January 05
Member No.: 6,984



Negative qualities are not appearing to be added up at the top, also there isn't any place for Complex forms =(
Go to the top of the page
 
+Quote Post
blakkie
post Sep 22 2005, 05:29 AM
Post #4


Dragon
********

Group: Members
Posts: 4,718
Joined: 14-September 02
Member No.: 3,263



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").
Go to the top of the page
 
+Quote Post
blakkie
post Sep 26 2005, 04:43 PM
Post #5


Dragon
********

Group: Members
Posts: 4,718
Joined: 14-September 02
Member No.: 3,263



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.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

 



RSS Lo-Fi Version Time is now: 16th September 2025 - 01:55 PM

Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.