PhilHibbs Posted January 10, 2022 Author Share Posted January 10, 2022 v1.19.10 Beta 4: https://docs.google.com/spreadsheets/d/13992T3NieCbrHCpz2jGBLgflyMnB0DfBol4kT6HgxEg Added shields from updated A&E 1.01 2 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted February 12, 2022 Author Share Posted February 12, 2022 Thinking about a quicker mechanism for doing NPC statblocks. I could re-use the existing mechanics and add new professions that include everything that you need, but I think it would need a new mechanism for characteristics. A set of pre-rolled numbers with labels like "tough", "wily", "smart", "feeble" etc. I could maybe do that with the races mechanic, so a tough gets 1D8+10 STR SIZ and CON but 1D6+8 INT etc. That would only require: Pick characteristics archetype (tough, wily, smart). Click the Race Apply button. Click the "Roll" dice icon. Pick profession archetype (outlaw, trader, scholar). Click Profession Apply button. Go to the CharSheet and pick the weapons in the drop down lists. I could bundle all of the "click" functions into one. And I could maybe automate populating the weapons into the character sheet. Could I do a cut down character sheet, that only has the skills that a typical statblock would contain? Tricky. Maybe I could implement something that runs down the list of skills in the CharGen sheet and populates anything that is better than base chance into the StatBlock sheet. I think the archetypes should be kept separate from the character creation options, maybe I will add a "rule" that swaps the two out like I have with RQ3/RQG category modifiers. 2 Quote Link to comment Share on other sites More sharing options...
Runesword Posted March 6, 2022 Share Posted March 6, 2022 I think I've spotted a bug in column 5. The probability distribution comes out as "2" to "5" as 1/6 each but "1" has a probability of 1/4 and "6" a probability of 1/12. This is because a value less than <0.5 comes out as 1. 1 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted March 6, 2022 Author Share Posted March 6, 2022 (edited) 56 minutes ago, Runesword said: I think I've spotted a bug in column 5. The probability distribution comes out as "2" to "5" as 1/6 each but "1" has a probability of 1/4 and "6" a probability of 1/12. This is because a value less than <0.5 comes out as 1. I'm not seeing it. I just rolled a bunch of numbers and 6 and 4 came out as the most common die result. I doubled the sample size to just over 200 die rolls and I get this distribution: 1 2 3 4 5 6 35 35 25 40 37 38 Not sure why 3 is so low. I'll keep rolling. Over 500 dice rolled: 1 2 3 4 5 6 83 80 84 89 78 90 When you say "column 5", what do you mean? The die roll result is in column I (9th column) in the current version: Ohhhh are you looking at the v1.2 Excel version? That's super old and I haven't looked at it in years. Still, I can't see a problem with it. Edited March 6, 2022 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
Runesword Posted March 6, 2022 Share Posted March 6, 2022 Sorry, being an idiot. I meant column I. I've gone back and looked at how "Floor" works. It isn't one I usually use in my spreadsheets, and this resolves how the probabilities works. 1 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted May 2, 2022 Author Share Posted May 2, 2022 (edited) v1.19.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! Edited May 2, 2022 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted June 25, 2022 Author Share Posted June 25, 2022 (edited) 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. Known Issues: 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. Edited September 25, 2022 by PhilHibbs 1 Quote Link to comment Share on other sites More sharing options...
TheNemesis Posted September 23, 2022 Share Posted September 23, 2022 So let me start by saying I LOVE the generator. It's amazing! I am making a centaur and had a couple questions though. I don't see any place for the horseshoe weapon that adds +1 dmg to hoof attacks. But much bigger, I noticed in the bestiary that there's an inconsistency, and I'm not sure what the right answer is. In the bestiary, the NPC centaur (page 31) average is listed as having 15 HP and their hit location HP is: Right Hind Leg 01–02 1/6 Left Hind Leg 03–04 1/6 Hindquarter 05–06 1/9 Forequarter 07–08 1/9 Right Foreleg 09–10 1/6 Left Foreleg 11–12 1/6 Chest 13–14 2/9 Right Arm 15–16 2/6 Left Arm 17–18 2/6 Head 19–20 3/7 BUT on page 10 it gives this: Centaurs Right Hind Leg 01–02 4 Left Hind Leg 03–04 4 Hindquarter 05–06 6 Forequarter 07–08 6 Right Foreleg 09–10 4 Left Foreleg 11–12 4 Chest 13–14 6 Right Arm 15–16 4 Left Arm 17–18 4 Head 19–20 6 This is also with 13-15 HP and instructs adding +1 for every 3 add'l HP. So what's the correct deal? Do NPCs get special stat blocks, or is there something weird with the math somewhere? Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 23, 2022 Author Share Posted September 23, 2022 6 hours ago, Nemesis716 said: So let me start by saying I LOVE the generator. It's amazing! 😁 6 hours ago, Nemesis716 said: I am making a centaur and had a couple questions though. I don't see any place for the horseshoe weapon that adds +1 dmg to hoof attacks. I will add it (next week). You can add your own entries to the Weapons tab though. 6 hours ago, Nemesis716 said: But much bigger, I noticed in the bestiary that there's an inconsistency, and I'm not sure what the right answer is... I seem to remember some contradiction, I'll look into it again. Can't do anything until next week though. I can't see any correction so maybe ask in the Q&A topic? Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 23, 2022 Author Share Posted September 23, 2022 In the near future I will be adding the Holiday Glorantha character creation details, and also the Duckpak amendments to durulz creation. Also there is East Isles, which I have. Are there any other character creation details from JC publications that I could add? If I don't own them then I'd either need a paste from the PDF or someone to transcribe the numbers into my sheet layout. If they divert from the standard system (fixed culture, occupation, cult numbers) then I might not be able to cover everything. I will make the JC stuff optional with a button to click to enable them all. Quote Link to comment Share on other sites More sharing options...
Brian Duguid Posted September 23, 2022 Share Posted September 23, 2022 1 hour ago, PhilHibbs said: Are there any other character creation details from JC publications that I could add? There's one for the Hsunchen in The Children of Hykim. Private message me on here if you don't have it and want to take a look. 1 Quote -- The Winter King | An Unofficial Buyer's Guide to RuneQuest and Glorantha | The Voralans | The Children of Hykim Link to comment Share on other sites More sharing options...
Brian Duguid Posted September 23, 2022 Share Posted September 23, 2022 There are also several for the elves, dryads, pixies and voralans of Dorastor in Holiday Dorastor: Woods of Terror. 1 Quote -- The Winter King | An Unofficial Buyer's Guide to RuneQuest and Glorantha | The Voralans | The Children of Hykim Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 23, 2022 Author Share Posted September 23, 2022 15 minutes ago, Brian Duguid said: There are also several for the elves, dryads, pixies and voralans of Dorastor in Holiday Dorastor: Woods of Terror. Ah when I said "Holiday Glorantha" I meant "Holiday Dorastor". 1 Quote Link to comment Share on other sites More sharing options...
TheNemesis Posted September 23, 2022 Share Posted September 23, 2022 12 hours ago, PhilHibbs said: 😁 I will add it (next week). You can add your own entries to the Weapons tab though. I seem to remember some contradiction, I'll look into it again. Can't do anything until next week though. I can't see any correction so maybe ask in the Q&A topic? Good call - I'll check the Q&A thread. Thx! Quote Link to comment Share on other sites More sharing options...
g33k Posted September 24, 2022 Share Posted September 24, 2022 (edited) On 9/23/2022 at 12:50 AM, PhilHibbs said: 😁 ... I can't see any correction so maybe ask in the Q&A topic? It's actually a long-outstanding topic there, AFAIK still unaddressed. Edited September 24, 2022 by g33k Quote C'es ne pas un .sig Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 25, 2022 Author Share Posted September 25, 2022 (edited) On 9/23/2022 at 2:21 AM, TheNemesis said: But much bigger, I noticed in the bestiary that there's an inconsistency, and I'm not sure what the right answer is. The new Q&A has amended the hit chart such that the head gets 1 less HP than my sheet did. Fixing it... If you want to fix it yourself in your sheet, if you have work you don't want to lose, then un-hide the Lookups sheet and change Cell AR7 from 3 to 2. Everything else will flow from this. OOPS no it's worse than that, all the other locations are low by 2 points! Okay, the entire line from AI7 to AR7 needs changing, add 2 to all the numbers except AR7 (head) where you add 1. Edited September 25, 2022 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 25, 2022 Author Share Posted September 25, 2022 On 9/23/2022 at 2:21 AM, TheNemesis said: I am making a centaur and had a couple questions though. I don't see any place for the horseshoe weapon that adds +1 dmg to hoof attacks. Where is this from? Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 25, 2022 Author Share Posted September 25, 2022 (edited) 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. If you are using an older version for a centaur character and don't want to use the transfer feature: Un-hide the Lookups sheet. Amend the range from AI7 to AR7, add 2 to all the numbers except AR7 (head) where you add 1. Optionally, hide the Lookups sheet. Edited September 25, 2022 by PhilHibbs Quote Link to comment Share on other sites More sharing options...
TheNemesis Posted September 25, 2022 Share Posted September 25, 2022 10 hours ago, PhilHibbs said: Where is this from? Weapons and Equipment page 89 1 Quote Link to comment Share on other sites More sharing options...
TheNemesis Posted September 25, 2022 Share Posted September 25, 2022 3 hours ago, PhilHibbs said: 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. If you are using an older version for a centaur character and don't want to use the transfer feature: Un-hide the Lookups sheet. Amend the range from AI7 to AR7, add 2 to all the numbers except AR7 (head) where you add 1. Optionally, hide the Lookups sheet. Thanks! I amended the values and everything looks MUCH more correct. Quote Link to comment Share on other sites More sharing options...
alien_sunset Posted September 25, 2022 Share Posted September 25, 2022 (edited) On 9/23/2022 at 3:59 AM, PhilHibbs said: In the near future I will be adding the Holiday Glorantha character creation details, and also the Duckpak amendments to durulz creation. Also there is East Isles, which I have. Are there any other character creation details from JC publications that I could add? If I don't own them then I'd either need a paste from the PDF or someone to transcribe the numbers into my sheet layout. If they divert from the standard system (fixed culture, occupation, cult numbers) then I might not be able to cover everything. I will make the JC stuff optional with a button to click to enable them all. hello, TheNemisis's GM here, thank you so much for all the work on this, it's been super helpful. I also have a Duck character, so i'm extra excited to have the duck update. thank you again, this is awesome! Edited September 25, 2022 by alien_sunset typos, always teh typos 1 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 26, 2022 Author Share Posted September 26, 2022 Hmmm this is going to be tricky. Homeland is easy, I've got that working already, I just added "Sartar Duck" as an additional homeland. Occupations... there are a lot that are the same name, do I just add a whole set of alternative versions like "Duck Assistant Shaman", "Duck Bandit", "Duck Crafter"? I think that is the only option. The user will then have to pick the appropriate race version of the occupation. The hack that adds the Assistant Shaman's Spirit Combat Damage bonus is going to have to take into account Duck Assistant Shaman as well. Should I go for abbreviated publication names, like "DP" for Duckpac, "HDWOT" for Woods of Terror, etc.? I think that makes sense. So it would be "DP Assistant Shaman", "DP Bandit", etc. Lets hope I don't get an abbreviation name clash! Lets see what we have so far... DP = DuckPac HDSH = Holiday Dorastor: Seven Hills HDSW = Holiday Dorastor: Spider Woods HDWOT = Holiday Dorastor: Woods of Terror PEI = Pirates of the East Isles 1 Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 27, 2022 Author Share Posted September 27, 2022 Okay I think I've implemented the basic functionality. v1.10.1 Alpha 1: https://docs.google.com/spreadsheets/d/1b63OhD7r1mcsHOsfE_ffV1lQ4lwxv73UWPCFsJ9BjjQ Go to the Rules tab Click on the bottom Law icon. Wait for the macro to finish running. "DP Sartar" should now show up as an additional Culture option. If you choose the "Duck" race, and the "DP Sartar" culture, and click the buttons along the top, you should now have the base chances for a duck as per DuckPac including Speak (Beastspeech) and the reduced Speak (Heortling) skill. I have not yet implemented occupations, but from now on it's just a question of mashing in all the numbers. I have done the Speak Own (Heortling) 40% base by giving a -10 cultural value, rather than adding a new DP Duck race with a different base chance. I might change this decision in future, in which case you would need to pick "DP Duck" race and "DP Sartar" culture for the full DuckPac experience. Also I'm not entirely fixed on a single Rule for all JC material. I might have separate rules buttons for DuckPac, Pirates, Holiday Dorastor, etc. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 28, 2022 Author Share Posted September 28, 2022 The other challenge is that anything that I add to the sheet really should be translated into French, German, Spanish, and Hungarian. Quote Link to comment Share on other sites More sharing options...
PhilHibbs Posted September 28, 2022 Author Share Posted September 28, 2022 Known Issues Merchants are not getting the Ride skill bonus +10 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.