This is a piece of my prices table, from the page I use to calculate the price of things based on their weight, workmanship and specific density. It is sort of a 'base page' that's used to script out items before they're gathered on another page that is cleaned up and simplified for player use.
|I had to post this in three parts|
Basically, this is a small piece of the content I'm making available for a $10 contribution to my Patreon. The table is in construction at the moment, but I've gotten this section on minerals done (more than half of it is polished gems) so I thought I might post it as an idea. Obviously, it's a very big picture and looks much clearer and easier to read in excel.
There are places on the table where the cell has been left blank, such as in the first table where there are no calculations for grey-pink marble, freestone, black marble or red sandstone. That is because these lines are used as placeholders for materials that I know exist somewhere in my world, but are not yet in the area that has been added to the actual trade system: such as knowing that Adeese in my trade system tutorial probably has products that don't exist in Pon but as yet Adeese isn't linked up.
Likewise, the image above is partly unedited. The first table says "Building Stone, Granite" and then lists all types of building stones. That's because I was going to make it several tables and then I didn't, forgetting to fix the heading until just now, seeing the saved image. Also, many of the items and descriptions are cut off by the width of the column. These things can be seen on excel; I'm just keeping the column width deliberately narrow on the page so I don't have to scan left and right constantly when I'm doing calculations.
About the rose highlighting in the jewelry tables: this is just some conditional formatting that tells me when a certain gem size meets a pre-determined value, so that it can be selected and put on the vendor table as that variety and size of gem.
Anyway, I'm updating this weekly for the moment until it is back to working order, which should be some weeks. This is an terrifically complicated evaluation process but it is the means I use to calculate literally everything that exists, from small items like a flint for starting fires to big, multi-component constructions like a gatehouse.