Character Generator

Discover the Legend RPG, Mongoose's fantasy game.
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Character Generator

Postby Denalor » Fri Feb 26, 2010 11:17 am

Hello everybody,

for those interested in EXCEL-tools and in this case a tool concerning the character creation in RQ II, you might want to look at this file:


CharGen_v08

(the link has been updated on 11th March)

Oh, BTW it's specific to Glorantha

Comments, especially in regard to mistakes are always welcome.

Notes:
1) Bard, Courtier and Noble have "Dance" as an Advanced skill. They receive +5 to the common skill instead
2) if you want to repeat the generation of a character either close and open the file again or go for Visual Basic and start the "frmstart" userform
3) The character sheet is probably not to your liking. Whatever sheet you use, you could just copy the value in there.
4) Spells are so varied that to include every possibility would have been the death of me :D
5) Equipment acquisition has also not been included
6) Characteristics are determined randomly. If the sum is less than 80, the whole rolling is repeated (nothing worse than having bad characteristics, s oI went for the minimum point-buy value)


Version History:
V01
Original Version
26th Feb 10

V02
Error removal for start-up procedure
28th Feb 10

V03
Addition of Mercenary, Merchant, Miner, Physician. Correction of Champion
28th Feb 10

V04
Correction in possible MAG choice starting magic. Correction free points cost when buying new advanced skills
01st Mar 10

V05
Calculation of Magic Points
Addition of "Strength" common magic
Allow multiple pacts to be had
01st Mar 10

V06
inclusion of fields to enter names
option to re-roll characteristics without needing to re-start completely
continuation of the generation only when you have applied all 250 free points
option to add up to three new combat styles
addition of 1H Flail, 1H Flail and Shield and 2H Flail combat styles
purchase of armour and weapons (core rules only !)
11th March 2010


V07
Correction in the routines concerning advanced skill purchased with free points, now restricts maximum free points to be allocated to the new skill to 20, rather than 30
11th March 2010

V08
- Civilized characters may now choose "Mechanism"
- You may choose Glorantha or Other for setting. The latter will delete the +30% bonus to common magic, will make common magic an advanced skill and will not allow you to choose common spells at the beginning
- You may now point build your character, however, only humans have been included
- minor mistakes were corrected
- the random characteristic rolls do not longer ascertain than the complete sum is higher than 80 to make this more even with point builders.
22nd June 2010
Last edited by Denalor on Tue Jun 22, 2010 1:47 pm, edited 16 times in total.
My 50 pence
SetentaeBolg
Weasel
Posts: 25
Joined: Thu Jan 28, 2010 11:53 am

Postby SetentaeBolg » Fri Feb 26, 2010 12:02 pm

Hi

Thanks for this. I'm having a problem running it - when I "Generate Character", it crashed out due to an application error when trying to show the skill picker form (immediately after showing stats).

You might want to take a look; it looks like it'll be a very useful tool when up and running!
BenQ
Weasel
Posts: 49
Joined: Thu May 29, 2008 9:30 am
Location: UK

Postby BenQ » Fri Feb 26, 2010 12:16 pm

I'm getting a similar error when generating a character, I get the pop up window with the rolled stats in, but when I click OK it fails
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Sun Feb 28, 2010 10:00 am

Embarassing :oops:

A small mistake there with hiding various sheets.
Well, I now skipped the whole hiding stuff, so you will see all sheets. Just pay attention that you do no not unintentionally delete or add something at the wrong places

-> v02


Gosh !

Sorry, I just saw, that Champion was wrong and that Mercenary, Merchant, Miner and Physician had been forgotten !

-> v03
Last edited by Denalor on Mon Mar 01, 2010 8:34 am, edited 1 time in total.
My 50 pence
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Mon Mar 01, 2010 8:26 am

Well, well, well...

I'm really sorry about this "mess", but I found again some problems myself.

Corrections:
- in V03 the common magic chosen could have MAG higher than 3. Has been corrected
- Acquiring new advanced skills did not cost 10 free points. Has been corrected
Last edited by Denalor on Tue Mar 02, 2010 6:15 am, edited 1 time in total.
My 50 pence
kurgan84
Mongoose
Posts: 167
Joined: Sun Jun 21, 2009 12:37 pm
Location: FRANCE

Postby kurgan84 » Mon Mar 01, 2010 9:19 am

Great job! and very usefull ! Thanks :D

I saw only a little bug with the magic points, they are always at 0 !
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Mon Mar 01, 2010 3:15 pm

Ominous voice in the background:

"And never again shall he put an Excel-tool on a forum before it is really finished !"

Sad but true, I honestly had thought the tool was finished, but I keep finding mistakes in it... Sigh, believe me that is more annoying for me that it is for anybody else !

Thing is, I hadn't forseen all possibilities, in this case the choice to have multiple pacts at the beginning.
Please do note, however, that only Priest, Sorcerers, Alchemists, Shamans and Witches actually start with any spells/spirits.
If you choose magical skill from your free points you will not be allowed to have these... that is, of course, something of a house rule...

(edit 02nd Mar. Obviously, people have lost faith, as it has not yet been dowloaded... or perhaps no one has realized that the above link in the first thread has been updated already. Anyway, here's - for convenience sake, the fifth - and I believe last - version)

-> v05
Last edited by Denalor on Thu Mar 11, 2010 12:26 pm, edited 2 times in total.
My 50 pence
Ssendam
Stoat
Posts: 81
Joined: Tue Nov 27, 2007 12:21 pm

Postby Ssendam » Tue Mar 02, 2010 9:31 am

Don't lose faith!

My comments ...

I wasn't sure what the red cells were when you allocated skill points.

When allocating skill points the total just went up and then red when it was too much. Could it possibly count down, so you can see what you have left. Also I think it let me finish without using all the points.

Could we have drop down boxes to select weapons?

A great application of this would be to Auto Generate Mooks, is that possible for a later revision?

Just my thoughts, great work and great Excel skills
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Tue Mar 02, 2010 2:55 pm

Holy Moly ! You're breaking my heart ! :shock:

The cells become red when you allocate more than 30 points to a single skill, as that is not allowed for starting chars.
It's just a warning that you did sométhing wrong, but it is true that you may still continue... :(

And yes, you can actually continue without having spent all 250 free points... honestly, the requirement for enabling the "finish" button is causing me some problems, so I'll see what I can do... no promises there though :D

Drop down menues for weapons. Well, that is a major issue since it would be awesomely dependent on the combat styles you wish to use. Even the styles I have used are simply drawn from MRQI... and actually "1H Flail" and "2H Flail" have been deleted and now probably count as "1H Hammer" etc.
As the RQII rulebook has omitted the categories - presumably on purpose because of the combat styles idea - this would be a very specific - custom-tailored - list.
I will probably - most likely :lol: - do it myself, but you know: Your Glorantha will vary, so...
Also, there is the H U G E issue of the forthcoming Arms & Equipment.

I'm not sure what you mean by "Auto Generate Mooks"... are we talking about NPCs ? Guess it will be unlikely for me to do something like that. All examples I've ever seen (regardless of the system) have shown major issues since you cannot possibly generate "sensible" random skill allocations. I believe NPCs need to be custom-tailored to the group and thus I'm personally not too fond of random generation, so...
My 50 pence
sdavies2720
Banded Mongoose
Posts: 256
Joined: Mon Feb 22, 2010 5:20 pm

Postby sdavies2720 » Tue Mar 02, 2010 9:00 pm

Denalor wrote:...(edit 02nd Mar. Obviously, people have lost faith, as it has not yet been dowloaded... or perhaps no one has realized that the above link in the first thread has been updated already. Anyway, here's - for convenience sake, the fifth - and I believe last - version)

CharGen_RQII-Glorantha_v05
I've got to say, having tried 3 times to download it, being told repeatedly that my download will be available in 30 seconds, then having likely links I clicked taking me to 'adult-oriented' advertising, I DID give up.

Pitty, I was hoping to look at it.

Steve
Raegenhere (Huscarl)
Stoat
Posts: 54
Joined: Tue Mar 02, 2010 10:38 pm
Location: Dublin, Ireland

Postby Raegenhere (Huscarl) » Tue Mar 02, 2010 10:45 pm

Hi,

I'm worried about enabling the macros after getting the F***book website popping up after the download link came up.

Has anyone else enabled the macros?

Is there anyway the file could perhaps be taken down from a download section on this site?

R.
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Wed Mar 03, 2010 6:27 am

taking me to 'adult-oriented' advertising

after getting the F***book website popping up


Huh ? Do I get that right, you are being relayed to most dubious websites after or while dowloading this file ???
:oops:
I'm really sorry, I didn't know that, I honestly didn't.
As it is, I don't really know download sites, I was hinted at that one via the "Songs of Ice and Fire" (Green Ronin) Forum.

Anyway, I'd gladly put it somewhere else, could you please provide me with the address of a proper site ?
I certainly do not intend to further this kind of behaviour, in fact, I definitley need to look for another site for the other tools, too.

Anyway, if you do not enable the macros, the whole thing is for nothing, 'cause macros is what this generator is all about :lol:
You will not get any result at all if you do not enable them.
But I can see your qualms after reading the disturbing news of those threads above.

BTW: when I downloaded it myself, I was not relayed to a dubious site. You're sure it was from this site ?
My 50 pence
NulSyn
Stoat
Posts: 53
Joined: Tue Oct 09, 2007 8:53 pm

Postby NulSyn » Wed Mar 03, 2010 7:13 am

I recommend 4shared.com
elgrin
Mongoose
Posts: 156
Joined: Thu Oct 26, 2006 5:41 pm
Location: Middle England

Postby elgrin » Wed Mar 03, 2010 5:45 pm

How about the MRQ Wiki?

elgrin
The Universe is full of magical things waiting for our wits to grow sharper
mwsasser
Banded Mongoose
Posts: 233
Joined: Fri May 29, 2009 6:29 pm

Postby mwsasser » Tue Mar 09, 2010 8:06 pm

Hmm... it doesn't seem to work in open office very well.
Ultor
Banded Mongoose
Posts: 233
Joined: Wed Jun 03, 2009 2:16 am
Location: Calydonian Boar Hunt
Contact:

Postby Ultor » Wed Mar 10, 2010 12:46 am

It always seems to generate the same characteristic scores. Do I need to do something to get it to randomize properly?
Still waiting for Games Workshop's contribution to Questworld

The Rune Under Water: an occasional Runequest blog http://runeunderwater.blogspot.com/
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Wed Mar 10, 2010 6:20 am

it doesn't seem to work in open office very well.


What exactly happens ? Or where are the faults ? This is rather vague, so I cannot do anything about it.

It always seems to generate the same characteristic scores. Do I need to do something to get it to randomize properly?


How do you re-start ? You need to initiate the userform frmStart (which automatically starts when opening the excel-file) and then push "Generate Character" and not "Just take a look" if you want to generate new characteristics. The macro then initiates the Module->Characteristics->DetermineCharacteristics

I'm currently woorking on another version, but I'm pretty busy (up to the nose) with work, so it takes a while.
The new version (06) will include:
- inclusion of fields to enter names
- option to re-roll characteristics without needing to re-start completely
- continuation of the generation only when you have applied all 250 free points
-option to add up to three new combat styles
-addition of 1H Flail, 1H Flail and Shield and 2H Flail combat styles
- purchase of armour and weapons (core rules only !)

Cheers
My 50 pence
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Thu Mar 11, 2010 12:22 pm

How about the MRQ Wiki?


Only allows 150k and this file is around 700k.
Also is that site actually still active ? Only deals with MRQ, not MRQII...

4shared.com

Well, guess I'll have to log in every 29 days or all files are lost.
So, just in case, if you're interesetd in this file, make sure you download it latest on 19th April :wink:

Here it is, Version 6: (the link on the very first thread has been updated, too !)

-> 06
If it doesn't work, drop a note here
Last edited by Denalor on Thu Mar 11, 2010 3:36 pm, edited 1 time in total.
My 50 pence
gran_orco
Lesser Spotted Mongoose
Posts: 532
Joined: Mon Aug 28, 2006 2:44 pm
Location: Valencia, Spain

Postby gran_orco » Thu Mar 11, 2010 1:28 pm

It is very good!!
I have seen only one error. When you purchase a new advanced ability, you can add +30 without any advertising. You can only apply +20 (you must spend 10 points to gain the new ability)
Denalor
Mongoose
Posts: 172
Joined: Fri Oct 10, 2008 8:31 am
Location: Karlsruhe/Germany

Postby Denalor » Thu Mar 11, 2010 3:35 pm

Thank you.

And thanks for the marvellous observation !
You are absolutely right ! The routine did include the cost of 10 free points but there was no prevention of applying another 30 free points to that new skill.

It has been corrected immediately:

-> V07
Last edited by Denalor on Tue Jun 22, 2010 1:45 pm, edited 1 time in total.
My 50 pence

Return to “Legend”

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests