Lordabdul Posted April 18, 2021 Share Posted April 18, 2021 3 hours ago, PhilHibbs said: What version, what cult? It was version 1.9.7 alpha 4, with both a 7 Mothers Lunar Tarshite, and a Dark Troll Zorak Zorani. Quote Ludovic aka Lordabdul -- read and listen to The God Learners , the Gloranthan podcast, newsletter, & blog ! Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 18, 2021 Author Share Posted April 18, 2021 6 hours ago, lordabdul said: It was version 1.9.7 alpha 4, with both a 7 Mothers Lunar Tarshite, and a Dark Troll Zorak Zorani. Works fine for me with that version and those two cults. Can you pm me a share link and I'll take a look? Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 20, 2021 Author Share Posted April 20, 2021 I was just about to release 1.9.7 Beta 2 when I found a couple of bugs bugs. Plant rune does not swap in in place of Beast rune for Aldryami characters. Yelm does not get the Spirit and Rune spell pick lists populated. You can work around this by setting the Cult to "Yelm" first and clicking the button to get the skills, then change it to "Yem" and click again to populate the spells, then change it back to "Yelm" again. Or, un-hide the "CultSpells" tab and fix it there. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 21, 2021 Author Share Posted April 21, 2021 (edited) 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, 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. Edited April 21, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 21, 2021 Author Share Posted April 21, 2021 (edited) Oops I just realised dwarfs need their own Earthsense variant skill section... fixed now. Edited April 21, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 26, 2021 Author Share Posted April 26, 2021 Bug. Sorting skills messes up in the Knowledge and Perception sections. This is because I have space for 7 Lore skills in the CharGen tab, but a variable number in the CharSheet depending on which Perception section is in use. Humans have space for all the Lore skills, Aldryami need to skip one to make space for Special (Elfsense), Uz and Mostali need to skip two to make sense for the two Darksense and Earthsense skills. Lining up which skills are skipped is tricky and breaks when the translation is done, as it is positional. For now I recommend not using the sorting feature. If you look at the cell references in the Knowledge and Perception sections, then you might be able to fix it yourself. Each skill name is just a cell reference to the CharGen tab, so you can just pick which cell shows which skill. I will have a think about how I can fix the sorting and readjust the skill cell references automatically. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted April 26, 2021 Author Share Posted April 26, 2021 (edited) v1.9.7: https://docs.google.com/spreadsheets/d/1DPApzUVKddacBunoLdQ2JwVPsrd7TETqmb1YpEc_2tE Disabled the sorting of skills by removing the button until I can fix it properly. Edited April 26, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 2, 2021 Author Share Posted May 2, 2021 (edited) 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%. Edited May 2, 2021 by PhilHibbs 1 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 6, 2021 Author Share Posted May 6, 2021 SORRY! v1.9.8 Beta 1 is broken. Skills like language and culture are not being filled in correctly. Fixing it now... Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 6, 2021 Author Share Posted May 6, 2021 (edited) 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! Edited May 9, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 9, 2021 Author Share Posted May 9, 2021 (edited) v1.9.9 Beta 1: https://docs.google.com/spreadsheets/d/1b-qkTHA3LUTpQ_SlOTjhVyazPKDZpjRwSo_WDNmL5FU Hungarian (Magyar) support is complete for all game terms, thanks László Bakk! The only things that will not be translated yet are the family history events, and some of the instructions. 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, Spanish, or Hungarian, please let me know. I also still need the spell list translating into Spanish. Edited May 9, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 11, 2021 Author Share Posted May 11, 2021 I have just made some corrections to the Spanish translation of skill names based on the official character sheet. I made these corrections into v1.9.9 Beta 1, so get a fresh copy of that version if you are using it for Spanish. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 11, 2021 Author Share Posted May 11, 2021 Something that I've been aware of for some time, but never really mentioned or fixed, is that the "half damage bonus for thrown weapons" is not implemented at all. I need to do something about that. I will add it as a "known bug". Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 11, 2021 Author Share Posted May 11, 2021 (edited) A warning for anyone using the Spanish translation, and who is using the "Copy from previous versions". The older version of the sheet had different translations for the skill names, e.g. Fast Talk was "Habla Fluida", but the official translation is "Charlatanería". If you have translated the sheet, and sorted the skills into Spanish alphabetical order, and you use the "Copy from previous version", then the skill values will not be transferred. This is because they are done by position, not by name. Workaround: Translate both sheets back into English. Sort the skills alphabetically. Use the "Copy from previous version" to transfer the skills to the new version of the sheet. Translate into Spanish. Sort the skills. Edited May 11, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 13, 2021 Author Share Posted May 13, 2021 Bug: 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. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 18, 2021 Author Share Posted May 18, 2021 (edited) v1.9.10 Alpha 1: https://docs.google.com/spreadsheets/d/16HvMd27ag2x21cmEpD5a5eoo_7l47SaBYzp7zOUFp98 Thrown weapons now have half damage bonus calculated in. Every weapon in the Weapons tab now has a damage bonus type, indicating which one to include, "Damage Bonus" or "Damage Bonus Thrown". Dwarf perception skill block fixed. Edited May 18, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 31, 2021 Author Share Posted May 31, 2021 (edited) Bug in 1.9.9, don't know if 1.9.10 is affected: There's something wrong with skill tick boxes. Sometimes they get overwritten with numbers, and if the skills are sorted in another language, some of the tick boxes don't work. Edited May 31, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 31, 2021 Author Share Posted May 31, 2021 (edited) Yes, it did affect 1.9.10 Alpha 1. Fixed! v1.9.10 Alpha 2: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. Edited May 31, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted July 27, 2021 Author Share Posted July 27, 2021 Looks like I forgot to announce 1.9.10 Beta 1, which is the same as Alpha 2 with the same link. Thrown damage bonus is now calculated and included. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted August 23, 2021 Author Share Posted August 23, 2021 (edited) v1.9.10 Beta 2: https://docs.google.com/spreadsheets/d/1w2bKX5TrR8tSz0_SSVvYEypbakHJ1b9e-mHQ5I2kVbE Fixed Rapier base skill, 10 instead of 5. Edit this value on the Weapons tab if you're using a rapier with an existing sheet. Edited August 23, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
Nick Underwood Posted August 24, 2021 Share Posted August 24, 2021 10? There's a 10?! I'm still using 1.9.5... Let me see what Excel goodness have I been missing... Thanks Phil, I love the generator. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted August 24, 2021 Author Share Posted August 24, 2021 (edited) Bugs If a cell is filled in with a value such as "1-3", e.g. for the number of Rune Points that can be used to cast a spell, then this becomes a date such as 1/3/2021 if it is copied across to a newer version of the sheet. (Actually, in my case it was always a date but the format was set to d-m so I never noticed!) Location AP are not transferred when copying across to a newer version of the sheet. Edited August 24, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
Nick Underwood Posted August 25, 2021 Share Posted August 25, 2021 14 hours ago, PhilHibbs said: If a cell is filled in with a value such as "1-3", e.g. for the number of Rune Points that can be used to cast a spell, then this becomes a date such as 1/3/2021 if it is copied across to a newer version of the sheet. (Actually, in my case it was always a date but the format was set to d-m so I never noticed!) If you enter "1-3" in a cell, the value is converted to an int for the date. (If you c&p values only you will get the int.) You can stop the conversion to an int by entering "'1-3" with a single quote before the text to display. (The initial single quote does not display.) And should then be able to c&p as a text string. (In Excel you can also set the cell format to text (not general) before entering the "1-3" but I've found it unpredictable. Don't know if that works for Google sheets.) Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted August 26, 2021 Author Share Posted August 26, 2021 On 8/25/2021 at 12:28 PM, Nick Underwood said: If you enter "1-3" in a cell, the value is converted to an int for the date. (If you c&p values only you will get the int.) You can stop the conversion to an int by entering "'1-3" with a single quote before the text to display. (The initial single quote does not display.) And should then be able to c&p as a text string. (In Excel you can also set the cell format to text (not general) before entering the "1-3" but I've found it unpredictable. Don't know if that works for Google sheets.) Yes I should have entered it as '1-3 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted December 13, 2021 Author Share Posted December 13, 2021 (edited) v1.19.10 Beta 3: https://docs.google.com/spreadsheets/d/1uN0KAhyP5jCQMhJHZjeFFKL9-3NTKy4Ir5E-_vz35V0 Added Arms & Equipment weapons, including translations for French, German, & Spanish. 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. Known Issues: Some translations are still missing. Stats for shields from Arms & Equipment are missing, as the PDF currently lacks the table. Edited December 13, 2021 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
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.