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.
in that example i worked for 6,43 minutes which should give me a total of $7720,00 (6,43x1200 which is the average rate), in that time i produced, with my specific technique, diamonds, redstone, iron, gold, andesite, gravel, etc. what im trying to accomplish is divide that 7720 in value between the diverse types of items so i can put a price tag in them.
if i do as you said, with proportion based on the amount of items acquired compared to the total amount of items the diamonds would be really cheap, and things with a lot of items acquired like redstone would be expensive. i currently set my own proportions manually so the value is distributed more to the rare items and less to the common items like gravel. I need to sell them after all, no one will buy redstone with 5x the price of a diamond.