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.
i think i found a solution to my problem: you add 3 more collumns, social unit val, calculated proportion and total adjacent, like the picture. with them, you put the average social prices of items you produced in “social unit val”, that will result in proportions in “calculated proportions”, which are the maximum values you should put in “proportion”; then you look at the “total adjacent” which should inform you what value of proportion you can deduct from your proportions in order to get prices to go down and the total sum still be your “total added” (you can deduct only that value for all items, not for each item, so you may divide that between all type of items if you want to lower the price of all items). if the value is negative you cant produce at an socially average value (you cant produce the items and you be better buying from others who have the lower price).
