PhilHibbs 488 Report post Posted June 2, 2018 (edited) 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. Pick your Race, Culture, Occupation, and Cult in the drop-downs in Column A. Click the "Fill" button (dotted down-arrow) in column F to set up the dice to roll. Click the D6 icon to roll a set of stats. Click the "Fill" buttons in columns AW, BD, BE & BF, (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.4 Beta 1: 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 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. Cult Lore has a tick box, which it should not have. 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. Automatic rolling of skill checks? Not sure if people would want this feature. Edited November 16, 2018 by PhilHibbs v1.7 Bestiary support 10 2 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 2, 2018 (edited) 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.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 November 1, 2018 by PhilHibbs 1 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 2, 2018 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 2, 2018 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 1 Share this post Link to post Share on other sites
mallion 4 Report post Posted June 3, 2018 Thak you ! It is very useful. 1 Share this post Link to post Share on other sites
jenh 4 Report post Posted June 3, 2018 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. 1 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 3, 2018 (edited) 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 Share this post Link to post Share on other sites
styopa 988 Report post Posted June 3, 2018 (Sigh) for the retention of break point laden skill mods. 😕 Share this post Link to post Share on other sites
trystero 157 Report post Posted June 5, 2018 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). Share this post Link to post Share on other sites
Scott A 44 Report post Posted June 5, 2018 (edited) 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 Share this post Link to post Share on other sites
simonh 341 Report post Posted June 5, 2018 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 1 Share this post Link to post Share on other sites
nerfherder 0 Report post Posted June 5, 2018 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 5, 2018 (edited) 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 Share this post Link to post Share on other sites
Hrafna 0 Report post Posted June 6, 2018 I like this - very useful when trying out some concepts for my next character. Thank you for creating this. Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 6, 2018 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. Share this post Link to post Share on other sites
styopa 988 Report post Posted June 6, 2018 For those who have campaigns outside Dragon Pass, I'd recommend http://www.pbegames.com/lifepath/ for character history. It's pretty wild. Share this post Link to post Share on other sites
Joerg 1,752 Report post Posted June 6, 2018 (edited) 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 1 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 8, 2018 (edited) 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 8, 2018 (edited) 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 1 1 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 8, 2018 (edited) 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 8, 2018 (edited) 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 9, 2018 (edited) 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 Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 12, 2018 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. Share this post Link to post Share on other sites
PhilHibbs 488 Report post Posted June 14, 2018 (edited) 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 3, 2018 by PhilHibbs Tally ho Share this post Link to post Share on other sites
Psullie 232 Report post Posted June 14, 2018 Phil, superb work here, thanks! 1 Share this post Link to post Share on other sites