This tool's functionality can be seen here on youtube
All of the tresure tables are generated using the rules in Trials & Treasure 179-182 but rather than us GM types needing to pull out dice & note/cross referene a bunch of stuff we can just hit f9 a few times to generate new lists till we find ones we like for our group.
The "Armor shop" sheet was written before I was able to start using lambda functions & you can compare the code in there to the code in the weapon shop sheet for an example of how drastically it simplifies & improves readability.
This makes extensive use of the lambda function in excel to make the code not require proficiency in lovecraftian eldergod to write. Unforthately that puts a pretty significant limit on who is capable of running it. In order to run this YOU MUST BE IN OFFICE INSIDER BETA CHANNEL builds of excel until lambda functions are moved down into preview & public channels. See the url below for details on how to change that setting in excel
insider.office.com
All of the tresure tables are generated using the rules in Trials & Treasure 179-182 but rather than us GM types needing to pull out dice & note/cross referene a bunch of stuff we can just hit f9 a few times to generate new lists till we find ones we like for our group.
The "Armor shop" sheet was written before I was able to start using lambda functions & you can compare the code in there to the code in the weapon shop sheet for an example of how drastically it simplifies & improves readability.
This makes extensive use of the lambda function in excel to make the code not require proficiency in lovecraftian eldergod to write. Unforthately that puts a pretty significant limit on who is capable of running it. In order to run this YOU MUST BE IN OFFICE INSIDER BETA CHANNEL builds of excel until lambda functions are moved down into preview & public channels. See the url below for details on how to change that setting in excel
Office Insiders
Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.