Great White Games/Pinnacle Entertainment Group

orclord · Last edited by orclord on Thu Jan 25, 2007 12:50 am; edited 15 times in total

DEADLANDS CHARACTER GENERATOR - Version 1.0

I have now created a DLR Character Generator in Excel. It works fairly solidly and should be 99% to 100% error free. It is only designed for DLR, although it could possibly be used to create some basic SW's characters in a pinch. It largely makes automatic calculations for edges & hindrances.

I have gone with a "points" approach to creating the characters which I think works well but I guess I'll see how others feel it works.

The sheet consists of 7 worksheets (the tabs at the bottom left for you non-excel lingoists.)

Worksheets:

Creation: This is where you choose all your Attributes, Edges, Hindrances, Skills and Powers. The only important thing to note, is that Edges do not check to see if the Pre-requisites for the selected edge have been met (other than rank). A future version of this sheet will likely display which pre-req's have not been met.

Gear: Here you can buy gear, weapons and ammunition.

Summary: This is the printable summary for the character which can double as a character sheet.

Edges: This is just a reference sheet, allowing you to scan through the available edges and their brief descriptions, and are sorted in a variety of ways.

Hindrances: This is just a reference sheet, allowing you to scan through the available hindrances and their brief descriptions.

Powers: This is just a reference sheet, allowing you to scan through the available powers and their brief descriptions, and are sorted in a variety of ways.

Data: This sheet pulls in all the data for the spreadsheet to work. Its an ugly mess and well shows my work in progress as I began learning all the needed codes and functions that makes Excel work so well. (In short, I'm a beginner to intermediate Excel user and this sheet really tested my knowledge).

I invite all interested parties to download the sheet and let me know how it works for you. Please let me know if you find any errors or have any suggestions.

LATEST VERSION: www.orcs.ca/dlrchargen.xls

Any revisions, or other news I have about this sheet will be posted in this thread.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.1

Revised the character summary into a character sheet. Next version will allow you to select from all gear and weapons available in DLR.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.2

Added selectable gear on a new worksheet. Tweaked the character sheet, including re-enabling the powers to display which I apparently broke on Version 1.1

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.3

Fixed Edges not showing up as modifiers under appropriate traits.
Increased price of Gatling pistol to $800. (For some reason people thought .08 cents was too cheap?)
Attractive Edge now shows as "Attractive" under Charisma, as opposed to "Weapon Master".

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.4

Fixed commas not showing up between Edges and Hindrances listed as trait modifiers on the Character Summary. (And commas showing in places they shouldn't).

Changed the weight of dynamite to .5 lbs.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.5

Several little tweaks on things I noticed (A couple hindrances not flagging right, Edges check for rank requirement was broke, etc). Also I buggered up Kung Fu / Chi Mastery pretty good -- its all fixed now.

Also, as requested, an option for making harrowed characters has been added.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.6

Fixed Intimidation skill calculation error, and allowed for Reputation to give a positive bonus for a negative Charisma.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.7

Fixed a display error when Elderly Hindrance was chosen.

Changed how edges/hindrances display on the modifier areas of the Character Sheet.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.8

Fixed Chi Mastery so that its powers properly display on the Skills area for assigning die types.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.9

Chi powers cost fixed.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.10 - October 13, 2006

Added selections for specific Veteran o' the Weird West and Knack edges.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.11 - October 31, 2006

Updated sheet as per recent Errata. Descriptions / stats affected: scattergun, whip, Eagle Claw, Wing Chung, Sanctify.

Weapon shot tracker now pulls up tracking markers for all 6 weapons, including weapons of only 1 shot.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.12 - November 12, 2006

Fixed problem with first 3 Miracles spells not pulling into powers display.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Version 1.13 - January 24, 2007

Removed the penalty that Clueless was applying to all Knowledge skills.

Yuri · Posted: Wed Aug 16, 2006 12:39 pm Post subject:

This is pretty nifty. I made a couple of characters with it... seems to work fine.

Yuri
_________________
I think we're property - Charles Fort

Yuri · Posted: Wed Aug 16, 2006 3:59 pm Post subject:

One thing I noticed, there is not a place for gear.

Maybe the next version?

Yuri
_________________
I think we're property - Charles Fort

orclord · Posted: Wed Aug 16, 2006 7:04 pm Post subject:

Yep, next version I will be concentrating on converting the Character Summary pages into more of a Character Sheet, which will include areas for recording gear, weapons, armor, wounds and notes. Trying to do that all in 2 pages is going to be a challenge Smile

orclord · Posted: Sat Aug 19, 2006 3:00 pm Post subject:

I have now updated the sheet to Version 1.1

I have revised the summary sheet into a Character Sheet.

The same download link on the first post of this thread will download the latest version.

orclord · Posted: Sun Aug 20, 2006 4:01 am Post subject:

Version 1.2 is now available.

You can now buy gear while making your character.

Did a few tweaks to the character sheet, including re-enabling powers to appear.

This spreadsheet is pretty much done now.

Chaos Steve · Posted: Wed Aug 23, 2006 11:08 am Post subject:

Nicely done, orclord! I've already got my players using it to easily create their new DL characters.

Shameless enhancement request...
I did notice that taking the True Grit edge doesn't change the character's grit on the summary sheet. Any chance of an enhancement to your already monumental time saving excel sheet? Smile

_________________

Piotr Korys · Posted: Wed Aug 23, 2006 11:17 am Post subject:

Well, I love it. Really Smile

Shameless enhancement request...
I like the price of Gatling Pistol. With Filthy Rich I could a lot of them...
_________________
Piotr "Ramel" Korys
Savage Worlds Line Editor
Pinnacle Entertainment Group

Clint · Site Admin Joined: 13 May 2003 Posts: 12004

The True Grit thing seems to affect several of the Edges. Apparently, on the Data sheet, they are looking for references under the cells designated for Hindrances instead of the cells for Edges.

The Gatling pistol price is an easy fix. Just unprotect the Data sheet, and go down and enter the correct price. Resave the sheet, and it's set.

Edit: Hmm, I just realized if you take Attractive it lists the Charisma modifier on the sheet as "Weapon Master." I suppose you could look at it that way. Wink

By the way, these are all extremely minor things compared to the obvious work that went into this sheet. Most impressive indeed.
_________________
Clint Black
Savage Worlds Core Rules Brand Manager

www.peginc.com

Chaos Steve · Posted: Wed Aug 23, 2006 1:09 pm Post subject:

Piotr Korys · Posted: Wed Aug 23, 2006 1:15 pm Post subject:

orclord · Posted: Wed Aug 23, 2006 6:57 pm Post subject:

Thanks all for taking a look at the sheet and putting it through its paces. Dang Gremlins seemed to have gotten into my sheet!

I try to test most everything so I can't believe I missed some of those glaring errors.

New sheet is available for download. (Version 1.3).

Gatling Pistol will no longer be sold at the Nickel & Dime store.

Attractive people will now have to rely on their looks to impress people rather than their big shiny gun / knife.

All the Edges that affect certain traits should now show up in the appropriate modifier area. (I really butchered that part).

Thanks again all for catching those glitches.

orclord · Posted: Wed Aug 23, 2006 7:24 pm Post subject:

Version 1.4 now available. (Just a few small oops') All is good now!

Edit: Also I changed the weight of dynamite to 0.5 lbs under Gear.

Magog777 · Novice Joined: 15 May 2005 Posts: 21

Pretty slick! are you planning to add Harrowed stuff to it?

orclord · Posted: Sat Aug 26, 2006 5:32 pm Post subject:

I hadn't thought about it.. but it wouldn't take much to add it in, so sure why not. I will add it in, in a few days.

orclord · Posted: Sun Sep 03, 2006 12:31 am Post subject:

Version 1.5 now available.

I fixed a few minor things, and did a major fix on Chi Mastery Powers and Kung Fu Styles.

A harrowed character selection has been added.

orclord · Posted: Sun Sep 03, 2006 1:01 pm Post subject:

Version 1.6 available.

Fixed an error with Intimidation skill, and added in a positive bonus for a negative Charisma for the Reputation edge.

forlorn1 · Novice Joined: 05 Jul 2005 Posts: 25

orclord · Posted: Mon Oct 09, 2006 1:39 pm Post subject:

Hi Forlorn,

The Superior Kung Fu edge is there, but it won't show up until you have selected the "Arcane Background (Chi Mastery) edge. When you do select this edge, then all the different styles of the Superior Kung Fu edge will appear at the bottom of the list of Edges, under the header of "DL ARCANE EDGES". (In prior versions to 1.5, I really butchered the Chi Mastery area, but it should all be working now).

Glad to hear this sheet is helpful for you.

forlorn1 · Novice Joined: 05 Jul 2005 Posts: 25