PhilHibbs Posted June 2, 2018 Posted June 2, 2018 (edited) Quote "It's not perfect, but it is free and it works." - Evan Franke This is a character creation and ongoing management spreadsheet for RuneQuest: Adventures in Glorantha, also called "RQG", the fourth Chaosium edition of the legendary RuneQuest roleplaying game. PLEASE DO NOT REQUEST TO EDIT! 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.11.2 Beta 3 https://docs.google.com/spreadsheets/d/18si1kVJiPrAV5rx4JSIATJj_5jF5Tn5VSp6LAIYtUEs Fixed the double-counting of the Extra column for runes. Fixed the Man/Beast calculation when Plant, Dragonewt, Spirit, Chaos are filled in. Extra values for Plant, Dragonewt, Spirit, and Chaos are deducted from Beast. To deduct them from Man instead, just put a corresponding increase against Beast. Instructions 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. Until you select a race, such as Human, and click this button, all stats will be 3D6. Click the D6 icon to roll a set of stats. Click the "Fill" buttons in columns (which may change with versions) BF (Skill Detail), BN (Culture), BO (Occupation) & BP (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 BF 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", "Baboon", and "Morokanth" cultures, which gives them the basic Praxian skills that all the others get e.g. Spirit Combat, Survival. Known Issues: RQ3 hit location calculation is patchy for some races, some of them have the RQG calculation, I need to go through and figure out what the 0.25, 0.33, 0.4 factors are for pixies, spiderlings, etc. Skill sorting functionality has been disabled, I don't think it works correctly with some character sheet layouts. Jonstown Compendium character creation does not include the famiily history. Not sure if I am going to add that. There's nothing to stop you from entering whatever text you like against each year, rather than picking only from the drop down list. I have added a few blank years (with no drop down list), particularly because 1614 is a Duck Hunt year and could be important. I might add an entirely new Duck Family History sheet with all the options selectable. Transfer from Old Version is a bit broken. The feature relies on the skill list remaining consistent. At some point I added a second line for Cult Lore, so now when transferring data from a version before that change to one after it, everything from that point onwards ends up on the wrong line. The "Extra" column in the Runes box is supposed to track experience after character generation. However, this column is after and not included in the opposing runes calculation, so experience in for example Death does not figure in to the Fertility rune calculation as a negative. When selecting Dwarf as race, and clicking the 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. Some translations are still missing, but mostly just Jonstown Compendium stuff. Fetch POW is not tracked, and so is not taken into account in any of the places that it should be. According to The Well corrections, it should be incorporated into all kinds of places, so if you want that, just put the fetch POW in the "Temp Adds" column and use the small numbers. More features on the backlog: Automatic rolling of skill checks? Not sure if people would want this feature. Just want a blank sheet? Here you go: https://docs.google.com/spreadsheets/d/1fLrPnwqiePJ2JnkvNAVexjKIXzVjMFvvHg5ST_r2xYM Edited 12 hours ago by PhilHibbs v1.11.2 Beta 3 13 4 Quote
PhilHibbs Posted June 2, 2018 Author 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.11.2 Beta 2: https://docs.google.com/spreadsheets/d/1CZ0fw53X8YO3Nmfp3UeNU20RWuooBR78NYtg3pwvpHk Removed experience check box from Read/Write skills. v1.11.2 Beta 1: https://docs.google.com/spreadsheets/d/1v5oKKc_XIiXexiJmU0XVcRz26InEin8C3H_IQ52ZXiM Added in Lands of RuneQuest: Dragon Pass Occupations. Added Newtlings. Minor correction to some location hit points for very low values. Filled in a few translations that were missing. Probably some new Jonstown Compendium stuff but that might not be finished... v1.11.1 Beta 4: https://docs.google.com/spreadsheets/d/1jE-LXVEtQaBlnd5qgZafyQUPwBtFCyERakvHmT8WKhI Fixed some skills not being filled in (Ski, Swim, Voice Mimicry, Treat Poison, Play Instrument, Sleight, Speak Silently) v1.11.1 Beta 3: https://docs.google.com/spreadsheets/d/1jwlqQO1nndMARvYmJnRTX3VVshC09AKliWuIIWoTSkM Fixed Uzdo DEX. v1.11.1 Beta 2: https://docs.google.com/spreadsheets/d/15ehFG_vz0Yd-C68jzCGvNOq9rSSwaXATiQw5MQ6dwXA Preliminary translation to Japanese is complete. All the game terms should be pretty much stable, a few things like obscure spell names or deities might be subject to revision before the core rule book and official character sheet are finished. The instruction text and prompts presented for culture, occupation, and cult skills might be a little rough (a mixture of Goole Translate and AI-assistance, and some official translator input). The upshot of this is that if you use this sheet, translate it into Japanese, and then transfer it into a future version, it might not translate fully back to English or to another language if some of the translations change. Jonstown Compendium stuff is not all translated. Normally, I hide the Translation tab. But for now, I'm leaving it visible so anyone interested in the Japanese translation can see what it is and let me know if they have any suggestions for improvement! Pre-translated versions Some people have reported the translation not working, so here are some pre-translated versions. Known issues Spell list (for the drop-down list) for your selected cult does not get translated. v1.10.1 Beta 3: https://docs.google.com/spreadsheets/d/1iXn3LG-M8Y49Ax62YMSidzELWiqqn96aKwKgP90-3tw Added Adventurers from the Lunar Provinces content (ALP) to the JC extensions (needs to be enabled on the Rules tab). Changed the way that skills and runes are added up so that copying and pasting no longer breaks the formulae. Note that where a homeland gives more than one possible rune bonus, you will be given all of them. Delete the ones that are not appropriate. v1.10.1 Beta 2: https://docs.google.com/spreadsheets/d/1TOTPT3xOP6FLSXHwfUmvdahwrjPcy0YJenrp4-_mIYQ Added Children of Hykim character creation content. Changed the Man and Beast calculations to take into account other form runes. If your Dragonewt rune goes up by 10, your Man Rune will go down by 10. If you want to lose the points off Beast instead, then put a +10 in Man or -10 in Beast, or 5 to split the change. v1.10.1 Beta 1: https://docs.google.com/spreadsheets/d/19La9QBPec0uhI8RcPsVccJa4UXY5AhS87i8Lo2gCiZ8 Added all the Jonstown Compendium character creation options. Use the Rules tab to enable them, then pick the options with a two or three letter prefix, e.g. "DP", "PEI" etc. at the end of the lists. DP = DuckPac PEI = Pirates of the East Isles HD = Holiday Dorastor In order to facilitate extending the list with JC publication weapons, I have split out the Weapons sheet into the three types. Implemented new menu option, "Fill Spell Picks". This checks both cults in the CharSheet on rows 85 and 86 and adds all the spirit and rune spells to the drop down selection lists. With this feature, you can pick a main cult (or dojo from Pirates of the East Isles), get the skills and spells with the fill button on the CharSheet, then add a second cult and select this new menu option. The two spell lists from the cults will be merged into the drop down lists. Added all the core runes to the CharGen tab. When changing race to one with a different opposing Man Rune, the two rune names get swapped (but at present it doesn't swap any numbers apart from automatic cultural bonuses, because you really should do that before creating the character). v1.9.10 Beta 9: https://docs.google.com/spreadsheets/d/13cBXwit2gOqsE7FxhcTXebV5sY3kwGQkE7RyIGvQcnk Added all the elder race Lore skills with base 5%. Added in the weapons from the Glorantha Bestiary (hesh, whipstick, klanth, utuma, etc.) v1.9.10 Beta 8: https://docs.google.com/spreadsheets/d/1EOjYGvCPRbh-kACAbGt7iGEWPypZel1mFlvfXb3zSe8 Fixed Merchant occupation getting +10 Ride. v1.9.10 Beta 7: https://docs.google.com/spreadsheets/d/1HW7cgx24Xj9Aew7pzMr7AmNz3u_Tdd_z_HDyXzadDYc Fixed Centaur hit points per location according to latest Q&A clarifications. v1.9.10 Beta 6: https://docs.google.com/spreadsheets/d/1NdXB2nvsZIUPGYBMP547Kek9Y2Z-6Az6wDBmING9QD8 If you change the Occupation to "Shaman", then you will get the +3 to Spirit Combat Damage that shamans get. v1.9.10 Beta 5: https://docs.google.com/spreadsheets/d/1d7HumuZspiIdT79ECeHhS_jv4QGVNkdyz2VXRpsZ01M Fixed a bug where Bison and Impala Riders do not get the cultural modifier to SIZ. Any culture that got a modifier to STR, CON, or SIZ would not automatically get it (there are no others though, just those two Praxian tribes). WAHA! v1.9.10 Beta 4: https://docs.google.com/spreadsheets/d/13992T3NieCbrHCpz2jGBLgflyMnB0DfBol4kT6HgxEg Added shields from updated A&E 1.01 v1.9.10 Beta 3: https://docs.google.com/spreadsheets/d/1uN0KAhyP5jCQMhJHZjeFFKL9-3NTKy4Ir5E-_vz35V0 Added Arms & Equipment weapons, including translations for French, German, & Spanish. Changed some of the German translations for core rules weapons, which might affect translating back and forth between languages. Fixed an issue where translating from one language to another to another would leave some terms in the last language for which I have a translation. It now leaves them in English. Mostly affects weapons in Hungarian and spells in Spanish. v1.9.10 Beta 2: https://docs.google.com/spreadsheets/d/1w2bKX5TrR8tSz0_SSVvYEypbakHJ1b9e-mHQ5I2kVbE Fixed Rapier base skill, 10 instead of 5. 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.8: https://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 1: https://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 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 12 hours ago by PhilHibbs 2 Quote
PhilHibbs Posted June 2, 2018 Author 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 Quote
PhilHibbs Posted June 2, 2018 Author 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 Quote
jenh Posted June 3, 2018 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 Quote
PhilHibbs Posted June 3, 2018 Author 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 Quote
styopa Posted June 3, 2018 Posted June 3, 2018 (Sigh) for the retention of break point laden skill mods. 😕 Quote
trystero Posted June 5, 2018 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). Quote — “Self-discipline isn’t everything; look at Pol Pot.”—Helen Fielding, Bridget Jones: The Edge of Reason
Scott A Posted June 5, 2018 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 Quote
simonh Posted June 5, 2018 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 Quote Check out the Runequest Glorantha Wiki for RQ links and resources. Any updates or contributions welcome!
nerfherder Posted June 5, 2018 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 Quote
PhilHibbs Posted June 5, 2018 Author 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 Quote
Hrafna Posted June 6, 2018 Posted June 6, 2018 I like this - very useful when trying out some concepts for my next character. Thank you for creating this. Quote
PhilHibbs Posted June 6, 2018 Author 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. Quote
styopa Posted June 6, 2018 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. Quote
Joerg Posted June 6, 2018 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 Quote Telling how it is excessive verbis
PhilHibbs Posted June 8, 2018 Author 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 Quote
PhilHibbs Posted June 8, 2018 Author 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 Quote
PhilHibbs Posted June 8, 2018 Author 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 Quote
PhilHibbs Posted June 8, 2018 Author 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 Quote
PhilHibbs Posted June 9, 2018 Author 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 Quote
PhilHibbs Posted June 12, 2018 Author 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. Quote
PhilHibbs Posted June 14, 2018 Author 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 1 Quote
Recommended Posts
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.