For all those of you who noticed that the amount of eve echoes isk assets not changing when changing blueprints, put this formula in cell G14 and haul it on the remaining part of the mineral cells to the right to get the correct quantities. (also, remove the space after"Tritanium" at G13)For some reason that isn't working for me. I just receive a message that Tritanium isn't found, which is bizarre because it's right there at the hidden sheet. Seems like Google sheets is getting a bad day?
If you all use the updated link above you need to find a copy of the newest version. Give it a minute to load the scripts and then you should be good to go without any changes necessary.The material efficiency cell is what you are searching for. Change it into the percentage based on your skills and the mineral and planetary resource values will update appropriately.I'm also curious why you determine value by averaging the buy price, sell price, and lowest cost?
I'm averaging the market and lowest sell because on average the market column seems to be inflated and so the typical seems to give more accurate results. Obviously these are all quotes and your mileage may vary depending on the local market in your area. I will continue to keep an eye on the prices and adjust the calculations when there seems to be better pattern.
Might it be feasible to make some type of filter here to drop from calculation ores which I don't have wide access to? For example, if I constantly mine pyroxeres, discard it from the sheet and rely only on other ores while calculating m3 efficiency.Ooo that's actually a good idea, I can not guarantee anything but I will definitely look into that!
I would also include the Eve Lowest Compare price. The current market is quite competitive and things generally do not sell in the Eve-Echoes-Market price. Also some items have a 3-4 hour window until they are updated. Considering that the market is very volatile it creates for list the correct prices difficult without needing to open the industry page to look at the present competitive selling price.
I'm using the average of the sell and lowest sell columns because this seems to give the best overall results. The problem with just taking the lowest sell is that it makes it easy for one person to try to steer the market by selling a single item with a very low price. Keep in mind that this tool is only going to give you estimates and you should verify pricing before making conclusions. I will continue to keep an eye on the costs and adjust the weights if things seem not to EVE Mobile ISK For Sale be working well.