It is currently Thu Jul 31, 2014 5:21 am


All times are UTC




Post new topic Reply to topic  [ 32 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Character Generator
PostPosted: Fri Feb 26, 2010 11:17 am 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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

_________________
My 50 pence


Last edited by Denalor on Tue Jun 22, 2010 1:47 pm, edited 16 times in total.

Top
Offline Profile  
 
 Post subject:
PostPosted: Fri Feb 26, 2010 12:02 pm 
Weasel

Joined: Thu Jan 28, 2010 11:53 am
Posts: 25
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!


Top
Offline Profile  
 
 Post subject:
PostPosted: Fri Feb 26, 2010 12:16 pm 
Weasel

Joined: Thu May 29, 2008 9:30 am
Posts: 49
Location: UK
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Sun Feb 28, 2010 10:00 am 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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

_________________
My 50 pence


Last edited by Denalor on Mon Mar 01, 2010 8:34 am, edited 1 time in total.

Top
Offline Profile  
 
 Post subject:
PostPosted: Mon Mar 01, 2010 8:26 am 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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

_________________
My 50 pence


Last edited by Denalor on Tue Mar 02, 2010 6:15 am, edited 1 time in total.

Top
Offline Profile  
 
 Post subject:
PostPosted: Mon Mar 01, 2010 9:19 am 
Mongoose

Joined: Sun Jun 21, 2009 12:37 pm
Posts: 167
Location: FRANCE
Great job! and very usefull ! Thanks :D

I saw only a little bug with the magic points, they are always at 0 !


Top
Offline Profile  
 
 Post subject:
PostPosted: Mon Mar 01, 2010 3:15 pm 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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

_________________
My 50 pence


Last edited by Denalor on Thu Mar 11, 2010 12:26 pm, edited 2 times in total.

Top
Offline Profile  
 
 Post subject:
PostPosted: Tue Mar 02, 2010 9:31 am 
Stoat

Joined: Tue Nov 27, 2007 12:21 pm
Posts: 81
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Tue Mar 02, 2010 2:55 pm 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Tue Mar 02, 2010 9:00 pm 
Banded Mongoose

Joined: Mon Feb 22, 2010 5:20 pm
Posts: 256
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Tue Mar 02, 2010 10:45 pm 
Stoat

Joined: Tue Mar 02, 2010 10:38 pm
Posts: 54
Location: Dublin, Ireland
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.


Top
Offline Profile  
 
 Post subject:
PostPosted: Wed Mar 03, 2010 6:27 am 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
Quote:
taking me to 'adult-oriented' advertising

Quote:
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Wed Mar 03, 2010 7:13 am 
Stoat

Joined: Tue Oct 09, 2007 8:53 pm
Posts: 53
I recommend 4shared.com


Top
Offline Profile  
 
 Post subject:
PostPosted: Wed Mar 03, 2010 5:45 pm 
Mongoose

Joined: Thu Oct 26, 2006 5:41 pm
Posts: 156
Location: Middle England
How about the MRQ Wiki?

elgrin

_________________
The Universe is full of magical things waiting for our wits to grow sharper


Top
Offline Profile  
 
 Post subject:
PostPosted: Tue Mar 09, 2010 8:06 pm 
Banded Mongoose

Joined: Fri May 29, 2009 6:29 pm
Posts: 233
Hmm... it doesn't seem to work in open office very well.


Top
Offline Profile  
 
 Post subject:
PostPosted: Wed Mar 10, 2010 12:46 am 
Banded Mongoose

Joined: Wed Jun 03, 2009 2:16 am
Posts: 233
Location: Calydonian Boar Hunt
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/


Top
Offline Profile  
 
 Post subject:
PostPosted: Wed Mar 10, 2010 6:20 am 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
Quote:
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.

Quote:
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


Top
Offline Profile  
 
 Post subject:
PostPosted: Thu Mar 11, 2010 12:22 pm 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
Quote:
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...

Quote:
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

_________________
My 50 pence


Last edited by Denalor on Thu Mar 11, 2010 3:36 pm, edited 1 time in total.

Top
Offline Profile  
 
 Post subject:
PostPosted: Thu Mar 11, 2010 1:28 pm 
Lesser Spotted Mongoose

Joined: Mon Aug 28, 2006 2:44 pm
Posts: 532
Location: Valencia, Spain
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)


Top
Offline Profile  
 
 Post subject:
PostPosted: Thu Mar 11, 2010 3:35 pm 
Mongoose

Joined: Fri Oct 10, 2008 8:31 am
Posts: 172
Location: Karlsruhe/Germany
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

_________________
My 50 pence


Last edited by Denalor on Tue Jun 22, 2010 1:45 pm, edited 1 time in total.

Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 32 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