RQG Character creation spreadsheet

[PhilHibbs 867]

I've updated my character creation and ongoing management spreadsheet! I created this a while back based on an in-development version of the rules (Working draft 2.1). Since then the category mods have become multiples of 5, the skill list has changed quite a bit.

The RQG Wiki has detailed instructions. Aussi en français.

1. Pick your Race, Culture, Occupation, and Cult in the drop-downs in Column A.
2. Click the "Fill" button (dotted down-arrow) in column F to set up the dice to roll.
3. Click the D6 icon to roll a set of stats.
4. Click the "Fill" buttons in columns AW (Skill Detail), BD (Culture), BE (Occupation) & BF (Cult), (wait for each one to finish before clicking the next!) to populate all the character creation skills.

• The AW column button is for race skills, typically just Insight, but also Darksense, Earthsense, Elfsense.

To translate, currently into Spanish or French, select the language in Column A and click the Translate button to translate everything.

The Perception skill Special () is for Elfsense, or any other race-specific sense skill that might arise.
Darksense etc. Scan and Search are handled as specializations, e.g. Search (Darksense), Search (Earthsense), etc. Everyone else gets N/A in these.
The CharGen sheet can track up to 10 melee skills and 5 ranged skills, and you can pick which ones show up on the CharSheet with drop-downs.
I have added "Agimori" and "Morokanth" cultures, which gives them the basic Praxian skills that all the others get e.g. Spirit Combat, Survival.

These links are READ ONLY: they are links to my master copy, you will need to make your own copy of the sheet in order to use it. File➔Make a copy...

v1.9.5: https://docs.google.com/spreadsheets/d/12RHsYJeJw8NtSubDE--MENwd6rhfZVe-9WgFeG52cwM/edit?usp=sharing

• Corrections to French translation based on the quickstart (thanks again @sireRage)
• Beginning of German translation based on the quickstart (thanks @Joerg and @Oracle)
  Only the core game terms are translated to German so far, the instruction text, family background, cultures, occupations, weapons, and spell names are not done yet

Known bugs:

• Running a script for the first time sometimes gives a "Server error", just reload the page and try again. If it persists, try Tools->Script Editor, and click the Save button, and close the tab.
• Sometimes the arrows on the CharGen sheet move around, and occasionally a rune on the CharSheet will move. This is a visual glitch in Google Sheets, just reload the page.
• If a non-Troll joins Kyger Litor, and already has a Speak Own other than Darktongue, they will not get the skill bonus. Add it manually as a Speak (     ) language.
• If a Troll joins Argan Argar, they will get Speak (Darktongue) as a secondary language even though their main language is Darktongue. Just move the bonus to the main language and remove the secondary. Copy and paste another empty Skill Detail entry if you want the (            ) spaces to be filled in correctly.
• Skills can go negative due to category modifiers, this should be capped at zero. I am not entirely clear on when this capping happens, before or after previous experience.

More features on the backlog:

• Sorting skills into alphabetical order for translated sheets - the trick here is to move the tick box with the skill. There's no macro to add a check box but I could use copy/paste, that would lose skill ticks unless I store them before the sort.
• Automatic rolling of skill checks? Not sure if people would want this feature.

Edited April 28 by PhilHibbs
v1.7 Bestiary support

[PhilHibbs 867]

Moving older version list from first post to here:

v1.2 Excel version: https://drive.google.com/file/d/1wkN9vyyeTRjw7CtCn0PejYuiPoK36vhe/view?usp=sharing

Version history:

v1.9.4: https://docs.google.com/spreadsheets/d/1W7_VCCvzULrC2if_U6udGIt6hHK6w4RiZyRAjMN0QOU/edit?usp=sharing

• Implements optional alternative RQ3-style category modifier calculations
• Indicates which rule is currently in effect with a checkbox (don't just check the box manually! Let the button do it!)
• Added all the Spirit and Rune spells to the translation sheet (thanks @AutumnDawn)
• French translations added for all spells (thanks @sireRage)
• Formatted CharSheet for printing and added HP and MP tracks
• Adjusted widths and positioning of spell columns, added points columns for spirit and rune
• Removed Enc 1 for Claw natural weapon

v1.9.2: https://docs.google.com/spreadsheets/d/1byEn5Jg0_IMHKwAjuxMbZqWjp_hIcZujufAapHq41-w/edit?usp=sharing

• Amended a few translations related to language names

v1.9.1: https://docs.google.com/spreadsheets/d/10Fc20ZIOI8ZZk-Bg6twcJHWDPzIH4QY5Y9Oazlwoiao/edit?usp=sharing

• Fixed language skills for non-humans.
• Added Minotaur as a playable race.
• Shortened the names of language skills in French and Spanish.

v1.9: https://docs.google.com/spreadsheets/d/1gLCGxM8OKBOZDDst5tsoYN31jcSqd6mfSRnqqUqJOkY/edit?usp=sharing

• Added French translation. Thanks to @sireRage.
• Streamlined translation process, just select and click.

v1.8.2: https://docs.google.com/spreadsheets/d/1Glh3a30ouY-rYommBLOUshP_vjFeu1cd8jp3ppcKpcs/edit?usp=sharing

• Fixed a few minor issues with Engizi and Yinkin cult skills.

v1.8.1: https://docs.google.com/spreadsheets/d/1-XrVp051-CFFOc8e7Pu6OznSliKHdlqRA1IL5c0bIEU/edit?usp=sharing

Fixed bugs:

• Weapon SR are being calculated incorrectly.
• Aldryami don't get the Plant rune.
• Centaur hit locations are not done.
• Baboon hit locations are not done.
• High Llama tribe are not getting Medium Shield.
• Sable Riders are getting +15 Medium Shield instead of +10.
• Weapon stats for Pole Lasso don't work properly.
• Sorcery spells are not being filled in on the character sheet tab.
• Bison and Sable Riders are getting 1H Javelin as a Ranged weapon instead of Melee.
• Entertainers are not getting Play Instrument.
• Non-human are getting Insight (Human) for various occupations.
• Troll Chanters get Speak (Darktongue) as well as Speak Own (Darktongue).
• Troll Hunter/Gatherers get Sing instead of Sling!
• Troll Noble/Rulers don't get Intimidate.
• Troll Priestesses don't get Dance or Spirit Lore.
• Troll Shamans don't get First Aid.
• All bugs listed further down in the thread are fixed.
• Baboon culture added, giving basic Praxian skills.

New features:

• Minor improvements to translation - getting the number of spaces right for translated passions and skills with specialities so Hablar (        ) has the right length to fit the space available.
• Plant Rune for Aldryami.
• Centaur hit location chart.
• Baboon hit location chart.
• Characteristic bonuses for Praxian tribes.
• Added a Baboon culture that gives the basic Praxian skills.
• Split out Orlanth into two, for Adventurous and Thunderous, as they get an extra cult skill that I had missed out.

v1.7.2: Fixed shield statbox & total SR calculations: https://docs.google.com/spreadsheets/d/1olwhY0MFM1PX_4nJBKCRj5yEOzJsWTdfN6GGB3-QPN0/edit?usp=sharing

v1.7: Full Bestiary race support: https://docs.google.com/spreadsheets/d/1jo6RuY2tEhf4mJR6nbcs0ygzFIEOdAfFOu9dXPfuEko/edit?usp=sharing

1.6 Beta 1: temp damage, DEX based skills, all weapon stats, language translation : https://drive.google.com/open?id=1bXdyGZdblVePiPfJf8x5HdIoMYUadBS2BBL5QxiLFw0

v1.5: Culture, Occupation, and Cult skill auto population: https://docs.google.com/spreadsheets/d/14vaDG5FiDmprN9CZZJT-UZqoijPlnNUOzIMeD6XOgtI/edit?usp=sharing

v1.4: Spirit spell effects, weapon stats: https://docs.google.com/spreadsheets/d/1AX8aq82mLmFaRd8SF-AEhXLSRGNzD1lqRv-2XzAeZE0/edit?usp=sharing

v1.3: Runes!: https://docs.google.com/spreadsheets/d/1PBMrJ66ZBLTs36cLIEhYqk7DLQ9lJuUL6CjdTALJmnk/edit?usp=sharing

v1.2: Added Family History text in drop-down lists, added Chaosium Fan Policy: https://docs.google.com/spreadsheets/d/1x9ZsVpjXlI_IQWc32dddCrEDgwgJKmjAVPVGApiBD1E/edit?usp=sharing

v1.1: Added Move, moved Reputation: https://docs.google.com/spreadsheets/d/1PrqmqNTJuA0XuNP2yTbhEXXbu58EbOkW9oDOHfPks7Q/edit?usp=sharing

v1.0: Added button to roll stats!: https://docs.google.com/spreadsheets/d/1I9uqXXIFuj_ID5B143b8ES2UgNaZ9GM1ekhPWTHNtbY/edit?usp=sharing

v4.6: Fixed spirit combat bonus for INT+POW over 57, fixed a bug with negative modifiers to categories, extended lookup tables to cope with stats up to 100, added a column to enter species maximum characteristics (was previously hard coded at 21): https://docs.google.com/spreadsheets/d/1UUD-NVxgx6FtOgxSmETW8AbPR7OmATsbTdGn1kr3Cmk/edit?usp=sharing

v4.5: Fixed temporary spirit combat damage, added Evaluate, added extra column for skill experience: https://docs.google.com/spreadsheets/d/179pEllnjDoBjLC0e42e_C9ZtGsK31nWrzg6ddqn2HAc/edit?usp=sharing

v4.4: Fixed the SIZ modifier to Agility, fixed modifiers for low stats, and fixed secondary modifiers above 21: https://docs.google.com/spreadsheets/d/1UNfkIklJrrFH8WiS2efka0wu_2V3tcMSnNWRwbBHz4Y/edit?usp=sharing

v4.3: Reorganized weapons to include shields, added an extra passions line, extra spoken language: https://docs.google.com/spreadsheets/d/1zUJmo8XdAN6CLHudH4KH_qb4o9WImQLCxaGyvbu1Boo/edit?usp=sharing

v4.2 Fixed second highest rune stat bonus: https://docs.google.com/spreadsheets/d/1JtZKXngoMuNqDKwykXF1JaJWtvz7pKNQ2VBvXOzqTrA/edit?usp=sharing

v4.1 rearranged elemental rune pentagram: https://docs.google.com/spreadsheets/d/1_5UHh4__XEjMFE4w_ZS2YBI4BNdnbqfQR_AuiOW_2Ng/edit?usp=sharing

v4.0: Initial version with RQG changes over RQ4 Working Draft 2.1: https://docs.google.com/spreadsheets/d/1a33Cgv3b7Cv0LS84IikPaAzVjT4Lm3EwUHhBKs0Ref4/edit?usp=sharing

Edited April 28 by PhilHibbs

[PhilHibbs 867]

Updated: https://docs.google.com/spreadsheets/d/1JtZKXngoMuNqDKwykXF1JaJWtvz7pKNQ2VBvXOzqTrA/edit?usp=sharing

Second highest rune was not correctly figuring in the +1 bonus to the associated stat

[PhilHibbs 867]

I've gone through the whole of Vasana's character creation story and filled in my sheet as closely as I can:

https://docs.google.com/spreadsheets/d/1IhvH1OLspcSurqd-c3YTmfbEZpwYz_5njTTOR0viBXY/edit?usp=sharing

What I have learned:

• Needs another Loyalty passion
• Needs a third spoken language slot
• Needs a fifth weapon line
• Needs lines for shield skills and shield stats
• There's some stuff in the weapon stats section that I can't remember what it is so that needs simplifying

So now there's a new version with those changes: https://docs.google.com/spreadsheets/d/1zUJmo8XdAN6CLHudH4KH_qb4o9WImQLCxaGyvbu1Boo/edit?usp=sharing

[mallion 4]

Thak you ! It is very useful.

[jenh 4]

There seems to be a problem with the category modifier calculation. For agility skills, SIZ is rated too negatively; it should be listed as NEG SEC, not NEG PRI. I haven't checked the others.

[PhilHibbs 867]

4 hours ago, jenh said:

There seems to be a problem with the category modifier calculation. For agility skills, SIZ is rated too negatively; it should be listed as NEG SEC, not NEG PRI. I haven't checked the others.

Good spot - just need to move the "SIZ" in AC2 to AD2. Also I noticed that the secondary bonus calculation has "+5" instead of "+4" so secondary category mods for stats higher than 21 were kicking in at 22, 27, etc. Oh, and low stats had the wrong sign on their modifier, so they behave just like high stats! Ooops!

Fixed: https://docs.google.com/spreadsheets/d/1UNfkIklJrrFH8WiS2efka0wu_2V3tcMSnNWRwbBHz4Y/edit?usp=sharing

If you've started using a sheet and want to fix it, just copy in the contents of the Lookups sheet from the new version, or fix the formula yourself in cells U6:U12.

Edited June 3, 2018 by PhilHibbs

[styopa 1,129]

(Sigh) for the retention of break point laden skill mods.  😕

[trystero 170]

On 6/3/2018 at 2:50 PM, styopa said:

(Sigh) for the retention of break point laden skill mods.  😕

Seconded. I miss my RQ3 category modifiers (and I'm never getting back the brain cells I devoted to learning those).

[Scott A 44]

Great tool! A couple of things I noted:

• The temporary spirit combat damage calculation is currently looking at CON instead of CHA.
• You're missing the Evaluate skill.
• There doesn't seem to be a designated place to keep track of skill advances during play

Thanks for making this

Edited June 5, 2018 by Scott A

[simonh 346]

8 hours ago, trystero said:

Seconded. I miss my RQ3 category modifiers (and I'm never getting back the brain cells I devoted to learning those).

You can always use them for your own game, if you like.

Simon Hibbs

[nerfherder 0]

42 minutes ago, simonh said:

You can always use them for your own game, if you like.

Simon Hibbs

I know that at least one of my players really liked the RQ3 category modifiers, so I was actually going to check whether mechanically they work out similar enough to the RQG modifiers, and just let him use them if they were close enough

[PhilHibbs 867]

8 hours ago, Scott A said:

Great tool! A couple of things I noted:

• The temporary spirit combat damage calculation is currently looking at CON instead of CHA.
• You're missing the Evaluate skill.
• There doesn't seem to be a designated place to keep track of skill advances during play

Thanks for making this

Thanks a lot, fixed: https://docs.google.com/spreadsheets/d/179pEllnjDoBjLC0e42e_C9ZtGsK31nWrzg6ddqn2HAc/edit?usp=sharing

I added an extra skill column "Extra" on the first sheet. Add in anything here, including experience, training, HeroQuest bonuses, etc. You can, of course, use  any of the columns AO-AS for whatever you want once character creation is completed and you no longer need to keep track of where the chunks of skill came from, you can consolidate the original numbers into a single column and use the rest if you want, for example, to keep experience and training separate. I may, for example, want to do my experience rolls by adding the new gains into a blank column, and then summing them up into another column when I'm done. Hmm, I think Google Docs does macros, so I might make that a feature... 

Edited June 5, 2018 by PhilHibbs

[Hrafna 0]

I like this - very useful when trying out some concepts for my next character. Thank you for creating this.

[PhilHibbs 867]

On 6/5/2018 at 11:15 AM, simonh said:

You can always use them for your own game, if you like.

Simon Hibbs

I can even do a custom version of the spreadsheet with the old formulae in if anyone wants, I had it all working before, so it's almost a simple cut and paste.

[styopa 1,129]

For those who have campaigns outside Dragon Pass, I'd recommend http://www.pbegames.com/lifepath/ for character history.  It's pretty wild.

[Joerg 2,152]

13 minutes ago, styopa said:

For those who have campaigns outside Dragon Pass, I'd recommend http://www.pbegames.com/lifepath/ for character history.  It's pretty wild.

I like Paul Jaquay's Central Casting tables, too, but looking at the prices at amazon, that's not a useful suggestion to buy it. Heroes of Legend has provided much of this stuff to my PCs and NPCs in the past, with only slightly more work to make the results fit the setting.

If you remember Martin Laurie's Humakti character Onslaught, I wove him into the background of one of my characters thanks to Central Casting - basically holding a grudge for killing the character's Humakti mentor. It was that incident which made him stop trying to get into the Humakt cult and go to Lhankor Mhy instead (in both cases, through his Truth Rune).

Edited June 6, 2018 by Joerg

[PhilHibbs 867]

Updated v4.6: https://docs.google.com/spreadsheets/d/1UUD-NVxgx6FtOgxSmETW8AbPR7OmATsbTdGn1kr3Cmk/edit?usp=sharing

Fixed spirit combat bonus for INT+POW over 57, fixed a bug with negative modifiers to categories,, extended lookup tables to cope with stats up to 100, added a column to enter species maximum characteristics (was previously hard coded at 21).

"Primary negative" modifiers (i.e. SIZ on stealth) was being treated as "secondary negative". Secondary negative modifiers, such as POW on stealth and SIZ on agility, were being calculated as primary negative. Oops! Deepest apologies for anyone who is using a broken version of the sheet. There's no real easy way to upgrade an existing character from one sheet version to another, copying the formula will not work properly as I have inserted an additional column.

Edited June 8, 2018 by PhilHibbs

[PhilHibbs 867]

Ok, I'm pretty happy with the spreadsheet now, so I'm calling it 1.0 and renaming it to RQG, and I've written a macro to roll the dice!

RQG v1.0: https://docs.google.com/spreadsheets/d/1I9uqXXIFuj_ID5B143b8ES2UgNaZ9GM1ekhPWTHNtbY/edit?usp=sharing

The Roll! macro might pop up some warning and prompt for permission to modify the document.

Clicking the "Roll!" button under most circumstances will roll the dice into the cells in column B, which are automatically assigned to stats. You're done! You can ignore the results below cell B20.

If you select a single result cell in Column B and click Roll!, that individual die is re-rolled.

If your GM lets you re-roll 1s, just select each of the 1s in turn and click Roll!

If you're using "roll one extra and discard the lowest" system, then identify the lowest result for each stat and re-roll that one - if you get a lower number, then revert the roll (Ctrl-Z to undo).

If you are rolling and assigning stats, then re-assign the dice by selecting the stat from the drop down in Column A. Column D keeps track of how many dice have been assigned to each stat, and the cell turns red if it is not the right number of dice for a human.

If you are rolling extra dice and assigning, then pick numbers from the cells below B20 to replace the low results above. Only use the extra dice up to the number that you are allowed, so if you are rolling 25 dice then ignore the last die result. You can add more dice rows if you want, it should all be dynamic!

If you want to protect your character against accidentally pressing the Roll! button and trashing their stats, then copy the resulting numbers in cells N2:N8 and use Crtl-Shift-V or Edit -> Paste Special -> Paste as Values.

Edited June 8, 2018 by PhilHibbs

[PhilHibbs 867]

Just fixed a problem with the range of rolled dice, I didn't make it a new numbered version since it doesn't affect any formulae. The named range needs to be B2:B27 instead of B4:B27. Also I realised I need to add a slot for Reputation, just change one of the passions as a quick fix.

Edited June 8, 2018 by PhilHibbs

[PhilHibbs 867]

Oh good grief I've made a real mess of Knowledge, Manipulation, and Magic skills! I must have deleted a range and not realised it at some point.

Ok I think it's fixed now... 😠

Edited June 8, 2018 by PhilHibbs

[PhilHibbs 867]

I'm working on a new version, with a Family History sheet with drop down selections for all major events. Does not include game system bonuses, but there is space to note them down if you wish.

Added highlight bars to skills to make it easier to see which one you are altering.

Some layout changes to the CharSheet, including space for Reputation and Move Rate.

I will add this to the top post as a new version when I have checked it isn't broken!

Edited June 12, 2018 by PhilHibbs

[PhilHibbs 867]

Ok, v1.1 is ready: https://docs.google.com/spreadsheets/d/1PrqmqNTJuA0XuNP2yTbhEXXbu58EbOkW9oDOHfPks7Q/edit?usp=sharing

I have not yet implemented the drop down lists for family history. The space is there for you to type or paste results yourself.

[PhilHibbs 867]

v1.2: https://docs.google.com/spreadsheets/d/1x9ZsVpjXlI_IQWc32dddCrEDgwgJKmjAVPVGApiBD1E/edit?usp=sharing

Added Family History text (abridged) in drop-down lists
Added Chaosium Fan Policy

Here's what you end up with: https://docs.google.com/spreadsheets/d/1aJVh_S5JeIfRnKfyHeQxzxHMPQcZo_iCxBYOb3S1U1k/edit?usp=sharing
Or as a partial image: https://www.dropbox.com/s/dww02vzphwefwyi/Vasana1.png?dl=0

Oh, it also tallies up how many +5, +10, +15, +20, +25, or +30 entries you have put in each of the skill modifier columns (Culture, Occupation, Cult, Choice). It used to only count the +10 and +25 entries in Choice, now it does a broader tally.

Edited August 4, 2018 by PhilHibbs
Tally ho

[Psullie 275]

Phil, superb work here, thanks!