Plethon's RC Treasure Tool - MS Excel

[plethon]

Hello,

My current Mystara campaign (RC) just passed the one year mark recently. I thought I would offer my excel treasure tool to anyone who is interested. I didn't like any of the options on VoP because none of them were comprehensive of the full treasure tables in RC, Swords and all. I also incorporated Gem Size, Quality, and Starstone/Tristal generation on 5% of Gems. 
Note: it is Lairs Only. All you do is enter the correct letter of the Lair Treasure Type on the top sheet in the space provided and hit enter, or update the workbook (F9) to regenerate.


I recommend downloading to your PC because it doesn't work in-browser:
docs.google.com/spreadsheets/d/1XAjTEvyzF1WrsGS7zeZPUmSqk8xfbenm/edit?usp=sharing&ouid=103982211950399305835&rtpof=true&sd=true

***This only works in post-2016 versions of Excel which contain the IFS function***

EDIT: Added a drop down menu for the treasure type so you don't have to type it in

[hamurai]

Which version of Excel did you use? I'm getting a lot of #NAME? errors, no matter which format I try to save it as.

[plethon]

Yes, I just realized that the IFS function was added in 2016. So this will not work unless you have 2017 or later excel

[hamurai]

I use Office 2019, so I should work. Then I guess it's an issue of getting the Google spreadsheet converted. When I just Save A Copy in my Google Drive, it works perfectly. The issue appears when I'm downloading it.

No matter, thank you for your work and for sharing it!