Sure I may be able to help you out
First of all you will need to think about what sort of information you will need for the spreadsheet, typing it in manually or make it collect the info with API or from other website.
The information (Columns) needed may be :
- List of a Ores, Compressed and maybe even uncompressed versions.
- Price for each type of Ore.
- Column for user input.
- Finally column with the calculated price (by formula)
- number of Units of Ore * price ( Cell1 * Cell2 )
- Cell with the Grand Total (SUM) of prices (again formula).
- =SUM(Range)
Finally you want to protect your spreadsheet from being edited, except the Cells that is for ‘User Input’