amellwind

MH Traveling Merchant Generator

Added 2021-08-31 23:19:33 +0000 UTC

Update: This has now left early access for anyone who wanted to grab it :D

Hello Everyone,

You will have to make a copy of the google sheet to be able to use the generator.

The first thing I want to do is thank my patrons that helped me create this document. It took a ton of time and would have taken longer with out them. Autonomous was a huge help with formatting and scripting this massive google sheet (along with his anonymous reddit friend). Heavy & Mike and Ike both helped me input the data of every single monsters loot tables. You are awesome and I love you all :D

I apologize for this coming at the very end of the month. The last week or two of coding this monster of a Google Sheet. Without further ado, I present the Monster Hunter Traveling Merchant Generator.

This generator rolls not only random monster materials, but may also roll random resources and adventuring gear/MH items in addition to the materials. Even better? You can set your parties level before generating your merchant and it will roll materials from creatures that are appropriate for their level. This way you don't have a level 3 party having the ability to purchase the CR 25 Shagaru Magala materials (though they couldn't afford it anyways).

Resources are the same, if a party is below a certain level, they won't be able to obtain resources that are far beyond their ability. For example a group of level 2's can only find common and uncommon resources, but a level 5 group can find rare resources, and a level 10 group has the chance to get very rare and legendary materials. The quantity of each material varies by its rarity. In general, the higher the rarity, the less the merchant will have.

Adventuring Gear/MH Items are completely random though. There is always a chance to have an ancient potion as much as it is to find a hammer. The merchant also always has a quanity of each item between 1-4, if he has any at all.

Now Pricing. The prices are set by me based on the downtime Sell Materials sell value. Most materials range between 2-10x that amount depending on how powerful they are. You might even see the same effects cost more on a creature than another due to that fact that their materials have a higher sell value. At higher levels this varies a bit more and we run into those insanely powerful material effects, but there are still some that you could afford easily enough by selling a material or two.

How This Generator Works

The traveling merchant generator works by running a script behind the google sheet that handles all the complicated math and formatting. Because of how google sheets work and googles script application, you do have to allow it access to edit your google sheet. To get the script prompt to allow access all you have to do is click the "Run" button at the top of the sheet.

If you do not, then the generator cannot function.

Now this google sheet is extremely user friendly. Here are the steps to using it.

1. Open the MH Traveling Merchant Generator.

2. Enter your parties average level next to the run button.

3. Deselect the average party cell

4. Click Run and wait about 30 seconds for it to populate.

5. Enjoy telling your players what the merchant has!

Note: There is currently a bug that if you change anything on the sheet, it will change the prices of the merchant. Also never delete anything out of the sheet or you may mess up the excel coding in the cells.

Overall I hope you are all excited to have this DM tool in your hands. I will notify you in this post when I update the document so that you can make a new copy of it with the new changes. You will also see this is in early access. In the future (probably next month) I will be updating a different version of this sheet to include all the subspecies in it. That version will be patron only, but of course you will still have access to the version you copied (so long as you don't delete it) even if you aren't able to be a patron anymore.