Dungeons and Dragons DM Tools: Gem Generator

Dungeons and Dragons DM Tool

The Gem Generator


This generator created to give great clarity, detail and value to all the different types of gems found in a D&D game.
This generator has a lot of information compiled from the Magica Encyclopedia Vol II, but there also is a lot of field research and custom info.

Though this was originally designed while playing the Dungeons and Dragons 3.5 System this actually has no RPG specific in it, so you could use this generator with any D20 or RPG system as long as copper, silver, gold, and platinum were the currency or you would just have to update the spreadsheet currency names to match your own RPG platform.

Here is video on how to use and about the generator:


How to Use:

  • Click on the Generator Tab
  • Enter the # of Gems you wish to generate (1-20)
  • Select the type of gems (Small, Moderate, Large, Random).
  • Voila.

It will calculate Type of Gem, Carat Weight, and Cut for you. In addition it calculates retail value of the gem.

Latest Update: Increased all gem sizes a little to reflect that there are no gems under 1ct anymore, also there is now many more random gem sizes.

Also increased amount of uncut gems (which can be cut for between 1-10x more value)

Click here > Gem Generator to download the spreadsheet, it is in Excel .xls format but is zipped.  None of my files have anything hidden, or embedded and include how to instructions in the excel spreadsheet.


This Generator was Created by Justin R. Germino

Justin Germino
I have been obsessed with computers, tech, gadgets and games since the early 1980's having grown up on the Commodore 64 and Amiga computers. By day I work in the IT Security Industry and have been in IT for over 20 years. On my spare time I am a Vlogger, Blogger, Streamer, Gadget Reviewer, affiliate marketer, influencer and entertainer. I am also an avid movie fan, TV Show fan, Anime fan, video game fan and fan of trying anything and everything new.
Justin Germino


Influencer / Reviewers / Live Streamers - Get in Touch https://t.co/DwhaTltp6U
We are now Live Streaming on the Dragon Blogger Channel, come check us out and say hi and see what is streaming now… https://t.co/KXyVgWxNYk - 38 mins ago
Justin Germino
Justin Germino
Share Feedback We Want to Hear From You