EVE Technology Lab

We've all seen plenty of calculators out there that tell you how many minerals to expect from your input quantity of ore... so this isn't one of those calculators.

This calculator allows you to input the desired mineral quantities and it will tell you precisely how many units of ore are needed to fill the desired quantity. Additionally, it will also calculate the approximate time it will take to harvest said ore, based on your efficiency rate and mining laser yield.

Calculator is available here, but cannot be edited. Please download/save it to make your edits and use the calculator.

https://docs.google.com/spreadsheet/ccc?key=0AkVeTVdnaHdhdGFCQkVmMmUwazNmeU5jWm5JVVpIc3c

Instructions on using calculator:
Areas of input:
"Ore Inventory" simply input your inventory levels for each ore type/name.
"Contract Orders" fill in the yellow highlight areas. The remainder are calculations and messing with them will break the sheet. Laser yield should be a cumulative amount based on your entire fleet m³ per minute. Efficiency is more of an estimate than anything else, but some guidelines are: solo = 68% (mine & warp), hauler/hulk = 90% and orca/hulk = 100%

Please note: additional yield (5% and 10%) from named ore is taken into consideration from ore->minerals... but NOT from minerals->ore for units or time calculations. The sheet essentially assumes you only have non-named rocks to mine.

Thoughts:
Yes, I am aware this can be made more robust and comprehensive than its current implementation. Have fun and make changes as you'd like. My version of the sheet is significantly more in-depth than what I am sharing, so I won't be changing the sheet very much.

If anyone finds any errors in the data, please let me know. It was a labor of love over time, and some numbers might need slight adjustments.