I made this spreadsheet to calculate minecraft item prices based on the time it takes to produce them but im having trouble to select the proportion of each item to divide the time (and value) between them, i need to be sure that each item is at least the average price for that item in the market. if they cant it means i dont produce with an average technique.
Ah, sorry. I didn’t realise this was an excel (help) community.
I was just about to ask about the proportion…
Also, I’m not an excel person, but feel I have to help!
Based on your research, there will be a total number of blocks mined which you need to account for.
So, total up the number of blocks mined (*) and divide that by the number of blocks found.
This will give you the ratio of diamond ore blocks to total blocks.
I feel like you must be doing something similar for the value?
*: worth having this total near the top in static rows, so you don’t have to do strange cell references.
This also allows you to expand your sheets to have further seeds/research-projects which can give a summary view of the average (maybe multiple summaries for different depths)