For those who noticed that the number of eve echoes isk assets not changing when switching blueprints, put this formula in cell G14 and drag it over the remaining part of the mineral cells to the right to get the right quantities. (additionally, remove the space after“Tritanium“ at G13)For some reason that is not working for me. I just receive a message which Tritanium isn’t discovered, which is weird because it’s right there in the hidden sheet. I tried both Firefox and Chrome. Seems like Google sheets is getting a bad day?
If you all use the updated link above you need to get a copy of the newest version. Give it a moment to load the scripts then you ought to be good to go with no adjustments necessary.The material efficiency cell is what you are searching for. Change it into the percentage based on your abilities and the nutrient and planetary resource values will update appropriately.I’m also curious why you decide value by averaging the purchase price, sell price, and lowest buy price? I am averaging the market and lowest market since on average the sell column seems to be inflated and therefore the typical seems to provide more precise results. Of course these are all estimates and your mileage might vary based upon the local market in your area. I will continue to keep an eye on the prices and fix the calculations if there seems to be better pattern.
Is it possible to make some type of filter here to fall from calculation ores that I do not have broad access to? For example, if I cant constantly mine pyroxeres, discard it in the sheet and count only on other ores while calculating m3 efficiency.Ooo that’s really a good idea, I can’t promise anything but I will certainly look into that!
I would also include the Eve Lowest Sell price. The current market is quite competitive and items generally do not sell in the Eve-Echoes-Market cost. Likewise some items have a 3-4 hour window before they are updated. Considering that the market is very volatile it makes for list the correct prices difficult without having to start the industry page to check out the present competitive selling cost.
I am using the average of this sell and lowest sell columns since this seems to provide the best overall results. The problem with just taking the lowest sell is that it makes it effortless for one person to try to steer the marketplace by selling just one item with a really low price. Keep in mind that this tool is only going to give you quotes and you should verify pricing before making decisions. I will keep an eye on the costs and fix the weights if items appear to buy EVE Echoes Items not be working nicely.
