Jump to content

RQG Character Creation Spreadsheet (multi-lingual) now includes Hungarian (Magyar)!


PhilHibbs

Recommended Posts

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.

This link is READ ONLY: it links to my master that everyone copies, you will need to make your own copy of the sheet in order to use it. File➔Make a copy...

Also in that vein I recommend that you make your own "master copy" that you then clone every time you make a new character. Keep checking back to this thread if you want to update your master copy to the latest version.

RECOMMENDED VERSION
v1.9.10 Beta 2:

https://docs.google.com/spreadsheets/d/1w2bKX5TrR8tSz0_SSVvYEypbakHJ1b9e-mHQ5I2kVbE

  • Fixed Rapier base skill, 10 instead of 5.

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 image.png.cf661c95914571baaa022bf374d06d69.png) in column F to set up the dice to roll. Until you select a race, such as Human, and click this button, all stats will be 3D6.
  3. Click the D6 icon to roll a set of stats.
  4. Click the "Fill" buttons in columns (which may change with versions) AZ (Skill Detail), BG (Culture), BH (Occupation) & BI (Cult), (wait for each one to finish before clicking the next!) to populate all the character creation skills. There will be some pop-up messages indicating where choices need to be made that are not automated, remember these and act accordingly. Remember that this tool is designed to take most - but not all - of the work out, to automate the majority of the process.
  • The AZ column button is for race skills, typically just Insight, but also Darksense, Earthsense, Elfsense.

To translate, currently into Spanish, German, or French, select the language in Cell A11 and click the Translate! button to translate everything. Wait for it to finish, it takes a while!

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.

Known bugs:

  • When selecting Dwarf as race, and clicking the image.png.a58193144628fff5cb8ae1729dfe47f7.png button in the "Assign" column, the wrong Perception skill section is swapped into the CharSheet, and you will not end up with the Earthsense variants of Scan and Search.
  • Most scripted actions do not work on the first time, if you had to grant permissions to run the code. If it appears to do nothing, and "Running script" did not appear, try doing it again.
  • 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. I think it happens if you scroll the page before the graphic loads in.
  • 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.
  • If you sort the skills into alphabetical order and you have skill tick boxes checked, those skill ticks will not move around with the skills.
  • 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. Not seen this one for a long time, so I think Google have fixed it.

More features on the backlog:

  • Automatic rolling of skill checks? Not sure if people would want this feature.

image.png

Edited by PhilHibbs
v1.9.10 Beta 1
  • Like 11
  • Thanks 2
Link to comment
Share on other sites

  • PhilHibbs changed the title to RQG Character creation spreadsheet

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.10 Beta 1:
https://docs.google.com/spreadsheets/d/1kL8JXJHD0J39tUDJHYRWRdrZj1wk_Ho0hYD_HDBtk3I

  • Fixed the skill tick boxes in knowledge and perception skill sections. If you have used the bugged version, just paste a tick box copied from somewhere else over each one.
  • Thrown damage bonus is now calculated and included.

v1.9.9 Beta 1:
https://docs.google.com/spreadsheets/d/1b-qkTHA3LUTpQ_SlOTjhVyazPKDZpjRwSo_WDNmL5FU

  • Hungarian (Magyar) support is complete, thanks László Bakk!
  • Translation now supports the RuneQuest menu, although I have not yet entered translation terms for those. If anyone is interested in contributing translations for French, German, or Spanish, please let me know. I also still need the spell list translating into Spanish.

v1.9.8https://docs.google.com/spreadsheets/d/1hQa5Zwx4FiTDNqSEbwDjNOyId-M359CDGtsCXF3vOuw/edit?usp=sharing

  • Fixed the filling in of skill details e.g. Speak, Insight, Read/Write. Broke this while fixing the sorting, oops!

v1.9.8 Beta 1https://docs.google.com/spreadsheets/d/1JtuxWOaioNvRk1iNpm49_hI0L0QONCci38FkEfaHZfg

  • Fixed the skill sorting! If you translate the sheet into another language, you can click the button at the top of the "Skill" column (BG) and get them sorted into your language's alphabetical order. Works for all the racial variant skill lists such as the Darksense, Earthsense, and Elfsense skills. WARNING: Pick the race and click the button in column F BEFORE you sort them.
  • Extended the CharSheet to fit two pages of A4, and added a section for a companion. Derived attributes are not calculated automatically, and there's space for 8 skills which could also be used for spells or runes.
  • Added a few "OH" weapon variants for off-hand weapons, feel free to add any more like this to the Weapons tab if for example you want to have an off-hand club skill or something like that, just copy the regular one and set the base to 5%. 

v1.9.7: https://docs.google.com/spreadsheets/d/1DPApzUVKddacBunoLdQ2JwVPsrd7TETqmb1YpEc_2tE

  • Disabled the sorting of skills until I can fix it properly.

v1.9.7 Beta 2: https://docs.google.com/spreadsheets/d/1l0Cm8aeNAjaCbq_Ca9DAhG_TXCUZTmwgapwznVUR0sE

  • Fixed spelling of "Yelm" in the list of values that fills in the pick list of spells.
  • Added "Swap Values" to the RuneQuest menu. Select two cells and run this command, the values will be exchanged.
  • Added a image.png.40e5d8161c9fba5cd3b3bdde98ca3077.png button in a few places. Selecting a cell and clicking this will prompt for a value, and that value will be added to the cell if it is already blank or numeric. So if a cell already contains "37" and you enter "6", it will set the cell to 43. Rejects if a non-numeric cell is selected.
  • Added columns to calculate critical, special, and fumble chances for runes and passions.
  • Race-specific Perception skills area, so Elves get "Special (Elfsense)", Uz get Darksense Search and Scan variants, and others reclaim the space for more Lore skills. WARNING: This does not play well with sorted skill lists. If you sort the skills, then this functionality may well mess up the skills visible on the character sheet. Not much I can do about that. Workaround: Select race first with the sheet in English, click the button above Assign, then translate and sort.
  • Added a column to keep track of temporary bonuses to skills, such as Bladesharp, Sword Trance, or augments. CharGen sheet has columns that calculate the special and critical chances for modified skills.
  • Added a new "Rule" to swap out the Sorcery skill list for a Notes area. Not really a rule, but it uses the same mechanism so I put it with the rule changes.
  • Introduced a new colour. Blue cells are cells that can be entered manually, but also might be calculated or filled in automatically. Green cells are only entered manually, these are the main areas that you will be entering things into. For example, the "Base Roll" values in Column Z are calculated by adding up the dice rolls in Column I, but you can enter your own rolled values instead if you want. Some of the "Skill Detail" values are filled in automatically, based on race or culture, but you can enter others like crafts or languages yourself.

V1.9.7 Beta 1: https://docs.google.com/spreadsheets/d/1Q-jETXJlWzZ7Qxem1NRyPJ3TRfctD4GUMUdKiC_5f5M

  • Treat Disease and Treat Poison now show up on the character sheet.
  • Fumble chances now show as 00 instead of 100.
  • Minor improvements to copy-from-old-version functionality.
  • Sorcery spells are now a drop-down list again.
  • If there is a tie for highest rune or second highest rune, the first rune in the list wins in terms of which characteristic gets the bonus. Previously, no bonus was given. You can still break the tie manually by adding an extra 0.1 or 0.2 to the Adds column.

V1.9.7 Alpha 2: https://docs.google.com/spreadsheets/d/1A9RfzOPgKcigkgC54j2AxTpxI2pPABhm18uK6MjMbSs

  • Fixed translation of Sing skill alternative value in French rule set.
  • Added new column for keeping track of changes to Rune values after character creation (values added in the Extra column will not affect the characteristic bonus, which the Adds column does affect).

V1.9.6 Beta 5: https://docs.google.com/spreadsheets/d/1mtWV2l9ow3J8aeDH78cFkibjbV9o-OXDJ_oLUaOIoQc/edit

  • Apprentice Shaman occupation gives +1 to Spirit Combat Damage Bonus

v1.9.6 Beta 4: https://docs.google.com/spreadsheets/d/1Dd9JcHZN-T2iD1x_ko7mDF4vDGWJDr8DTcIg2HICA84/edit?usp=sharing

  • Fixed a bug where reassigning a rune to a different characteristic did not work on translated sheets.
  • Sorting of skills alphabetically no longer spoils the coloured banding of the skill rows.

v1.9.6 Beta 3: https://docs.google.com/spreadsheets/d/1IvICdOCOdB0p5MP3Y7w6CLKdFD7WyM9ByNuOOU3Ta8o/edit?usp=sharing

  • Corrections to French translation based on the Studio Deadcrows edition of the rules (thanks again @sireRage).
  • Sorting of skills alphabetically (optional separate operation to translation).
  • Implementation of alternative occupation skill percentages from the Studio Deadcrows edition.
  • Implementation of alternative General Hit Points calculation from RQ3.

v1.9.5a: https://docs.google.com/spreadsheets/d/1heO8XgQvGYPe_O8HrUns5qcMV7bN4oCI5ZsMyCwas0M/edit?usp=sharing

  • The following occupation skill values were missing or incorrect and have been changed from and to: Chariot Driver - Whip 0%⮕+25%; Entertainer - Lore (any) 0%⮕+10%, Herder - Cultural Ranged Weapon +10%⮕+30%.

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 (or are just Google Translate placeholders).

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 by PhilHibbs
  • Thanks 1
Link to comment
Share on other sites

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

  • Thanks 1
Link to comment
Share on other sites

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 by PhilHibbs
Link to comment
Share on other sites

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).

— 
Self-discipline isnt everything; look at Pol Pot.”
—Helen Fielding, Bridget Jones: The Edge of Reason

Link to comment
Share on other sites

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 by Scott A
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by PhilHibbs
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by Joerg
  • Like 1

Telling how it is excessive verbis

 

Link to comment
Share on other sites

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 by PhilHibbs
Link to comment
Share on other sites

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 by PhilHibbs
  • Like 1
  • Thanks 1
Link to comment
Share on other sites

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 by PhilHibbs
Link to comment
Share on other sites

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 by PhilHibbs
Link to comment
Share on other sites

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 by PhilHibbs
Tally ho
Link to comment
Share on other sites

  • PhilHibbs changed the title to RQG Character Creation Spreadsheet now with French edition support!
  • PhilHibbs changed the title to RQG Character Creation Spreadsheet (multi-lingual) now includes Hungarian (Magyar)!

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...