It is currently Fri May 24, 2013 3:48 pm


All times are UTC




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Having Fun With Spreadsheets
PostPosted: Fri Sep 21, 2012 11:05 am 
Duck-Billed Mongoose

Joined: Sun Dec 21, 2008 11:29 pm
Posts: 2445
Location: UK
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!")

_________________
Hypnotist, Dreamer, Plainclothes Clown, Agitator, Author


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Fri Sep 21, 2012 12:10 pm 
Banded Mongoose

Joined: Fri Apr 01, 2011 9:19 am
Posts: 202
Wheel, meet Alex.

_________________
My Getting Started with Legend file including a suggested starting adventure.

My Romano-British Game setting.


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Fri Sep 21, 2012 12:58 pm 
Shrew

Joined: Wed May 06, 2009 5:46 am
Posts: 15
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.


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Fri Sep 21, 2012 1:50 pm 
Duck-Billed Mongoose

Joined: Sun Dec 21, 2008 11:29 pm
Posts: 2445
Location: UK
strega wrote:
Wheel, meet Alex.

You misspelled "Axle." :P :D

_________________
Hypnotist, Dreamer, Plainclothes Clown, Agitator, Author


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sat Sep 22, 2012 12:34 pm 
Duck-Billed Mongoose

Joined: Sun Dec 21, 2008 11:29 pm
Posts: 2445
Location: UK
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.

_________________
Hypnotist, Dreamer, Plainclothes Clown, Agitator, Author


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sat Sep 22, 2012 10:36 pm 
Greater Spotted Mongoose

Joined: Thu Oct 13, 2005 3:41 am
Posts: 838
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.


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sat Sep 22, 2012 11:07 pm 
Greater Spotted Mongoose

Joined: Mon Aug 14, 2006 11:41 am
Posts: 1475
Location: Birmingham, UK
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


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sat Sep 22, 2012 11:22 pm 
Duck-Billed Mongoose

Joined: Sat Jan 01, 2005 2:36 am
Posts: 2097
Location: Spokane, WA
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... is that a new game on the shelf? M-U-S-T... B-U-Y... G-A-M-E !"
Image


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sun Sep 23, 2012 10:13 am 
Shrew

Joined: Wed May 06, 2009 5:46 am
Posts: 15
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


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sun Sep 23, 2012 2:14 pm 
Mongoose

Joined: Tue Dec 20, 2011 12:55 pm
Posts: 188
Location: Wiltshire, UK
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


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sun Sep 23, 2012 6:35 pm 
Shrew

Joined: Wed May 06, 2009 5:46 am
Posts: 15
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.


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sun Sep 23, 2012 8:19 pm 
Mongoose

Joined: Tue Dec 20, 2011 12:55 pm
Posts: 188
Location: Wiltshire, UK
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


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sat Sep 29, 2012 10:48 pm 
Lesser Spotted Mongoose

Joined: Wed Jun 27, 2007 3:26 pm
Posts: 785
Location: Pottsboro, TX area
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 RQ/BRPS/Traveller since 1978


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Sun Sep 30, 2012 6:50 pm 
Shrew

Joined: Wed May 06, 2009 5:46 am
Posts: 15
Excel 2010, in older versions at least the Iferror function is missing.


Top
Offline Profile  
 
 Post subject: Re: Having Fun With Spreadsheets
PostPosted: Fri Nov 30, 2012 9:47 am 
Greater Spotted Mongoose

Joined: Sun Sep 24, 2006 9:45 pm
Posts: 1452
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.

_________________
Phil Hibbs. (wiki)


Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Moderator: lastbesthope Go to page 1, 2  Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Theme created StylerBB.net