Page 1 of 1

Excel sheets for character creation, I made some.

Posted: Mon Feb 03, 2014 1:31 pm
by Thinyser
So I played around with excel yesterday and made some excel sheets to help make characters. If anybody wants to see them to help me improve them or whatnot let me know (by PM please and include your email) and I'll share them.

Re: Excel sheets for character creation, I made some.

Posted: Mon Feb 03, 2014 11:18 pm
by Thinyser
No interest?
Huh oh well. I Like them! :-)

Re: Excel sheets for character creation, I made some.

Posted: Mon Feb 03, 2014 11:38 pm
by Natasha
For which characters?

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 12:48 am
by Nightmask
Thinyser wrote:No interest?
Huh oh well. I Like them! :-)


Well I don't use Excel so have no way to make use of them or help out with feedback on them.

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 2:24 am
by The Beast
Thinyser wrote:No interest?
Huh oh well. I Like them! :-)


I have a fillable PDF that I find quite adequate.

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 11:34 am
by Thinyser
Natasha wrote:For which characters?
Generic

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 11:35 am
by Thinyser
The Beast wrote:
Thinyser wrote:No interest?
Huh oh well. I Like them! :-)


I have a fillable PDF that I find quite adequate.

These perform calculations for you. :D

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 9:54 pm
by arouetta
Nightmask wrote:
Thinyser wrote:No interest?
Huh oh well. I Like them! :-)


Well I don't use Excel so have no way to make use of them or help out with feedback on them.


OpenOffice makes a spreadsheet program that can open Excel format.

Re: Excel sheets for character creation, I made some.

Posted: Tue Feb 04, 2014 10:21 pm
by Nightmask
arouetta wrote:
Nightmask wrote:
Thinyser wrote:No interest?
Huh oh well. I Like them! :-)


Well I don't use Excel so have no way to make use of them or help out with feedback on them.


OpenOffice makes a spreadsheet program that can open Excel format.


Hmmm, seems I do have that installed. Good to know. Thanks.

Re: Excel sheets for character creation, I made some.

Posted: Wed Feb 05, 2014 12:44 am
by The Beast
Thinyser wrote:So I played around with excel yesterday and made some excel sheets to help make characters. If anybody wants to see them to help me improve them or whatnot let me know (by PM please and include your email) and I'll share them.


Posting here so you don't get bombarded by everyone saying the same thing.

Ok, I just glanced at it so far, but here's a couple things I found:

1 = You spelled alignment as alingment, and for some weird reason, my spell check doesn't seem to recognize it's spelled wrong.

2 = You don't have an option for the different PS scales. Looks like it's just normal PS. If I were to use SNPS, this would be an issue.

Next few things aren't errors, just personal preferences. I think you have too many spots for WPs. Granted someone could make a PC with that many WPs, but most of mine averaged around 6 when I was younger, and tend to have no more than four nowadays. I also think it would make more sense to have the total skill percentage to the far right instead of the far left.

I'm somewhat confused on why you listed some of the combat bonuses twice. You left out a few potential combat bonuses as a result. It might be better to replace those with saving throws, and move HtH stuff to a third page. This would allow you to make a few spots for robot combat as well.

You may wish to include a spot for RCC/OCC powers/abilities/special skills.

Re: Excel sheets for character creation, I made some.

Posted: Wed Feb 05, 2014 9:54 am
by Thinyser
The Beast wrote:
Thinyser wrote:So I played around with excel yesterday and made some excel sheets to help make characters. If anybody wants to see them to help me improve them or whatnot let me know (by PM please and include your email) and I'll share them.


Posting here so you don't get bombarded by everyone saying the same thing.

Ok, I just glanced at it so far, but here's a couple things I found:

1 = You spelled alignment as alingment, and for some weird reason, my spell check doesn't seem to recognize it's spelled wrong.

2 = You don't have an option for the different PS scales. Looks like it's just normal PS. If I were to use SNPS, this would be an issue.

Next few things aren't errors, just personal preferences. I think you have too many spots for WPs. Granted someone could make a PC with that many WPs, but most of mine averaged around 6 when I was younger, and tend to have no more than four nowadays. I also think it would make more sense to have the total skill percentage to the far right instead of the far left.

I'm somewhat confused on why you listed some of the combat bonuses twice. You left out a few potential combat bonuses as a result. It might be better to replace those with saving throws, and move HtH stuff to a third page. This would allow you to make a few spots for robot combat as well.

You may wish to include a spot for RCC/OCC powers/abilities/special skills.
Thanks I'll work on those, (I knew the different strength levels would be an issue), I'm looking at either doing a better nested IF function but this might end up being too much of a pain in the arse. If thats the case I might just do three separate sheets one for normal one for augmented/robotic and one for SuperNatural.

The extra wep prof slots are for weaps that you have and may use but are not proficient with. I have them there so you have them all available at a glance rather than having to go to page 3 (which will be a gear page for assundry stuff). It's also meant if you have different iterations of the same weapons like regular knives and dwarf made knives that have +X to damage and +X to strike and parry. The multiple Combat bonus listings kinda go along with this and are for situational or alternative bonuses. Say you're mounted and get a bonus to parry and dodge while on horseback, or are a juggler and get a bonus to strike when you throw weapons

I wanted the total % right next to the skill name so that it was easier to see what % was for what skill, (the how you got to that % is not really as important unless your GM is a stickler on such things which is why I left those visible at all rather than hiding the cell contents). If you want it at the far right its easy enough to cut and paste it there (but then I would recommend highlight every other row to make them easier to follow from left to right so you dont get your % for one skill mixed up with another because your eyes didn't track right across the page, which tends to happen towards the end of a long game session ;-) ).

Re: Excel sheets for character creation, I made some.

Posted: Wed Feb 05, 2014 11:02 pm
by Thinyser
OK so I decided that the IF statements weren't worth the effort and am just making different sheets for different strength categories. I know that the Palladium strength levels are pretty messed up. Ive got a question about this. In the Rifts main Book, Rifts GMG, and RUE I cannot find the lifting amounts for augmented strength, is it the same as normal (strong) human? ie 17 and higher can carry PSx20 in lbs and lift twice that?

And has the Robot strength of PSx25 for BOTH carry and lift been fixed anywhere so that its x25 carry and then twice that for lift like it should be? Its still this way in RUE and makes no sense to me.

Re: Excel sheets for character creation, I made some.

Posted: Thu Feb 06, 2014 12:43 am
by The Beast
Honestly I don't know.

Re: Excel sheets for character creation, I made some.

Posted: Thu Feb 06, 2014 7:36 pm
by Thinyser
I've improved them significantly. PM me if you wanna check them out!