Having Fun With Spreadsheets

Discover the Legend RPG, Mongoose's fantasy game.
alex_greene
Cosmic Mongoose
Posts: 3786
Joined: Sun Dec 21, 2008 11:29 pm
Location: UK
Contact:

Having Fun With Spreadsheets

Postby alex_greene » Fri Sep 21, 2012 11:05 am

Has anyone else dabbled with using spreadsheets to do things like create tables of all the different combinations of characteristics, e.g. STR+CON, INT+POW, POWx2, POW+CHA and so on, and then created the lists of skills in Legend and used the table to create the base chances of common, advanced and magical skills and combat styles?

Or is it just me?

It's not exactly a character generator - I still have to more or less roll the dice or choose the values to go in - but it's a whole hell of a lot quicker than having to look up each common skill, all the advanced skills and so on.

Beats me why I didn't do this sooner. Like last year. *facepalm* :oops:

(If everybody here's already way ahead of me, then my next post will be titled "Hey Guys, I've Just Invented The Wheel!")
Board moderator. Product List [DriveThruRPG]: Blood Path [Legend]; Cosmopolite [Traveller]; Castrobancla [Traveller]
strega
Banded Mongoose
Posts: 286
Joined: Fri Apr 01, 2011 9:19 am
Contact:

Re: Having Fun With Spreadsheets

Postby strega » Fri Sep 21, 2012 12:10 pm

Wheel, meet Alex.
My Getting started with Legend file including a suggested starting adventure.

My Romano-British Game setting.
WoeRie
Shrew
Posts: 15
Joined: Wed May 06, 2009 5:46 am

Re: Having Fun With Spreadsheets

Postby WoeRie » Fri Sep 21, 2012 12:58 pm

Hm... I did that the first day I decided to do a campaign with MRQ2 :D
I have made a full character sheet with excel, including all the math and stuff.

I's always the first thing I do when I try to learn a new system. It's a good way to remember and understand everything.
alex_greene
Cosmic Mongoose
Posts: 3786
Joined: Sun Dec 21, 2008 11:29 pm
Location: UK
Contact:

Re: Having Fun With Spreadsheets

Postby alex_greene » Fri Sep 21, 2012 1:50 pm

strega wrote:Wheel, meet Alex.
You misspelled "Axle." :P :D
Board moderator. Product List [DriveThruRPG]: Blood Path [Legend]; Cosmopolite [Traveller]; Castrobancla [Traveller]
alex_greene
Cosmic Mongoose
Posts: 3786
Joined: Sun Dec 21, 2008 11:29 pm
Location: UK
Contact:

Re: Having Fun With Spreadsheets

Postby alex_greene » Sat Sep 22, 2012 12:34 pm

An unexpected benefit - after generating the characteristics, I can now look over the skills' base chances and determine which skills the character has a natural aptitude for based on those characteristics I just rolled up. A high DEX character could do well at Evade; a high CHA character excel at Influence; someone with high CHA and POW could have a natural talent for Sing, and so on.

I can thus tailor my character so as to provide the best base chances to open those particular skills with, such as putting my highest points in INT and CON if I want my character to be the best tracker, or POW and CHA if I want my character to have a natural flair for Art, Sing, Oratory, Common Magic and Spirit Binding; and INT as well if I want my character's metiers to lie in Evaluate, Insight, Perception, Commerce, Courtesy, Disguise, Gambling, Healing, Language, Seduction, Teaching, Sorcery (Grimoire), Manipulation, Summon or Concert.
Board moderator. Product List [DriveThruRPG]: Blood Path [Legend]; Cosmopolite [Traveller]; Castrobancla [Traveller]
Prime_Evil
Greater Spotted Mongoose
Posts: 1496
Joined: Thu Oct 13, 2005 3:41 am

Re: Having Fun With Spreadsheets

Postby Prime_Evil » Sat Sep 22, 2012 10:36 pm

It's funny. I've done exactly the same thing too ;)

I used my spreadsheet to help me to quickly design a number of reusable generic NPCs tailored for specific campaign roles (town guard, street merchant, cutpurse, etc). At that point MRQ II was still fairly new and nobody had built a proper character generator. One of the really useful things that the spreadsheet allowed was the rapid design of variants for each NPC type - take a point of the STR of the Man-at-arms and place it into DEX and change the combat style to the longbow and suddenly you've got a feudal archer. The only thing that I needed to do by hand was assigning equipment.
soltakss
Duck-Billed Mongoose
Posts: 1680
Joined: Mon Aug 14, 2006 11:41 am
Location: Birmingham, UK
Contact:

Re: Having Fun With Spreadsheets

Postby soltakss » Sat Sep 22, 2012 11:07 pm

Are you going to post the spreadsheet anywhere?
Simon Phipp - Wallowing in my elitism since 1982.

Merrie England (Medieval RPG): http://merrieengland.soltakss.com/index.html
http://www.soltakss.com/index.html
Alternate Earth: http://alternateearthrq.soltakss.com/index.html
GamerDude
Duck-Billed Mongoose
Posts: 1638
Joined: Sat Jan 01, 2005 2:36 am
Location: Spokane, WA
Contact:

Re: Having Fun With Spreadsheets

Postby GamerDude » Sat Sep 22, 2012 11:22 pm

soltakss wrote:Are you going to post the spreadsheet anywhere?
Let me echo that sentiment.

I love using a spreadsheet based CS to handle all the math for me, like Alex said to give an idea of where the character's aptitudes may lie. It also helps to have it add up as I buy skills and what-not, compute armor, look up armor/weapons when I type the name in and get the stats.

I still have to roll the dice make the decisions have the books but this is the kind of thing I would love to have.
Al B. [B-)
Say what's that, a new game? M-U-S-T   B-U-Y G-A-M-E!

Image
The first, Since 9/2008, MGT-Aids@yahoogroups.com
WoeRie
Shrew
Posts: 15
Joined: Wed May 06, 2009 5:46 am

Re: Having Fun With Spreadsheets

Postby WoeRie » Sun Sep 23, 2012 10:13 am

It's a finished character sheet, including all the maths. Though it is an Excel sheet it does not contain any Macros. Meaning you can open it with Open Office.

Have fun: http://riegler.name/Legend_Character_Sheet.zip
Bifford
Banded Mongoose
Posts: 329
Joined: Tue Dec 20, 2011 12:55 pm
Location: Wiltshire, UK
Contact:

Re: Having Fun With Spreadsheets

Postby Bifford » Sun Sep 23, 2012 2:14 pm

This is a very nice crib sheet! :)

The biggest problem I can see is that in your skills list it has "Basic" and "inc" but doesn't have a column for "Culture/Profession/links" .

Therefore if you include those things into the INC box your tally on the right of the amount of "Free Points" is soon going to hit negative numbers. And because the culture and profession numbers are added in before the free points are allocated this would mean you'd still have to do a manual tally of the free points. And then you add in any player link amounts and it compounds things further.

So this a great start, but I do think it needs that extra column.

Bifford
WoeRie
Shrew
Posts: 15
Joined: Wed May 06, 2009 5:46 am

Re: Having Fun With Spreadsheets

Postby WoeRie » Sun Sep 23, 2012 6:35 pm

Ok, I see your problem, but I don't think another column is either needed nor good, as it would waste too much space. Remember, this is a character sheet, designed for playing with, not only something to calculate everything.

You can modify the total number of skill points (in AM27) and you should add in all values from Culture, Profession and Free distribution (depending on the experience of your char). You then first decrease the fix values for Culture & Profession (and special values like the +30 Common Magic for Glorantha), then the correct amount should be left for your free skill point distribution.

Currently it lists 540 points:
210 Culture
50 Profession
30 Common Magic Bonus for Glorantha (I will upload a new version with 510 points only).
250 Free points (for a beginner character)


However at the end of character creation this should be exactly 0. After improving during game, this will get negative (but I think this doesn't matter as it is not printed on the sheet)


BTW: It prints for Din A4, so maybe you get siome problems during the print-out if you are using Letter sized paper.
Bifford
Banded Mongoose
Posts: 329
Joined: Tue Dec 20, 2011 12:55 pm
Location: Wiltshire, UK
Contact:

Re: Having Fun With Spreadsheets

Postby Bifford » Sun Sep 23, 2012 8:19 pm

ah, yes, that would work. nice. okay, that's sweet then :)

Well done that person on creating a nice bit of work!

huzzah.

lol.

Bifford
SSWarlock
Greater Spotted Mongoose
Posts: 1043
Joined: Wed Jun 27, 2007 3:26 pm
Location: Fulacin/Rhylanor/Spinward Marches

Re: Having Fun With Spreadsheets

Postby SSWarlock » Sat Sep 29, 2012 10:48 pm

Which version of Excel was used to create this spreadsheet? I'm getting warnings from my version that it won't support some aspects of the spreadsheet.
Sir Dhaven Hevelin, IOD, Baronet of Fulacin
Owner/Captain - S.S. Warlock

Playing Traveller/RQ/D&D since 1977
WoeRie
Shrew
Posts: 15
Joined: Wed May 06, 2009 5:46 am

Re: Having Fun With Spreadsheets

Postby WoeRie » Sun Sep 30, 2012 6:50 pm

Excel 2010, in older versions at least the Iferror function is missing.
PhilHibbs
Greater Spotted Mongoose
Posts: 1453
Joined: Sun Sep 24, 2006 9:45 pm

Re: Having Fun With Spreadsheets

Postby PhilHibbs » Fri Nov 30, 2012 9:47 am

alex_greene wrote:Has anyone else dabbled with using spreadsheets to do things like create tables of all the different combinations of characteristics, e.g. STR+CON, INT+POW, POWx2, POW+CHA and so on, and then created the lists of skills in Legend and used the table to create the base chances of common, advanced and magical skills and combat styles?
My spreadsheet does that. It doesn't do it with a table, though, it parses the cell text and adds in the appropriate stats. So if the "Stats" cell says "DEX+POW", then it adds in the DEX stat and the POW stat. If it contains "x2" then it doubles the result. So it can't cope with unusual bases like INT+DEXx2, and it doesn't look for multiple occurrences like INT+DEX+DEX.
DamonJynx
Greater Spotted Mongoose
Posts: 1199
Joined: Mon Dec 20, 2010 1:32 am
Location: Sydney, Australia

Re: Having Fun With Spreadsheets

Postby DamonJynx » Mon Dec 03, 2012 1:03 am

Here's my version specifically for NPC's.

It's an Excel 2007 .xlm sheet with macro's. It's specific for Elric re some advanced skills. I haven't bothered with culture, race or profession as for NPC's those are generally redundant (IMO). I just wanted a simple sheet that lets me choose how 'proficient' an NPC is in a given skill.

What I do is copy the "Blank NPC" sheet and then hit "Generate stats" and change the name of the sheet.

Elric NPC
Glory is the reward of valour.

My blog at damonjynx.blogspot.com
Check out, The Blood Path available NOW!
Arcania of Legend available now!
Bedlam in Blackcliffe available now!

Who is online

Users browsing this forum: No registered users and 19 guests