Science & Industry

This may or may not already exist being that mining has existed since the beginning of EVE time. So if you start to read this and already know some type of program or spreadsheet where this already exists, please let me know and just skip to the bottom marked 'Issue'.

I would like to solicit a question to the math geniuses of New Eden to help me figure something out which caveats off of the following:

I've calculated a formula in which you can figure out when you need to start watching the cycle meter on your lasers before the ore depletes based on the ore already in your hold without having to sit there and count each cycle as it goes down to the thousandths rounded up. Unfortunately there's no numbers on the icons to let you know where you're at, so you're always guessing. But at least it gives you a better idea of where you can stop the rotation. This formula can easily be plugged into a spreadsheet as well.

Formula

Ore in Asteroid / Extraction Rate per Cycle = Required Cycles
Drop the # left of the decimal point and multiply the remaining .xxx result by the extraction rate to = ore obtainable in .xxx (called the factor)
Subtract the factor result from the ore in the asteroid to obtain the amount of ore that will be in your hold before you need to start watching your cycle meter. The number to the right of the decimal point after you obtain the required cycles in bullet A is the point in the cycle you need to stop. I.E. - .450 being just before the half way mark.

My spreadsheet looks like this with the above formulas plugged in:

Spreadsheet

My Issue

It's nice and all that I have this figured out for all lasers on one rock. But I want to turn this into a sheet where I can keep track of the cycles in the same fashion with multiple lasers on multiple rocks of the same type. The problem comes in when I have to keep track of each laser cycle and the ore is stacking because it's the same type of rock. Does anyone have any idea how to formulate that on a spreadsheet?

your going to run into two major problems.

1) not all roid types have the same amount of m3. Also as a roid isn't mined it increases in m3 amount, this mea s some roids will have more m3 and last longer in cycles.

2) some people will mine a roid down to less then a cycle, or just a specific roid ina belt, meaning you will have some roids that will and some that wont follow a patten you will be expecting

Seems like an awful lot of messing about for saving a minute or so on a wasted cycle if that's what you're bothered about.

As for keeping rocks alive, unless you're the sole miner in the system then it's pretty pointless trying this, since someone else will probably come along, see a nice rock that you've kept alive, not bother scanning it, point, fire the lazors and kill it in the first cycle.

or am I missing the point?

complete waste of time, you're honestly better off just tabbing out until you hear "asteroid depleted".

Would have been great if I could extract the formula from his program.

Thank you, Musashi. I'm going to wrap my head around that for a bit and let you know how that works out for me.

Back to your bridge you evil troll. You have no powers here.

Something to consider:

If you are mining in 1.0 and 0.9 solo or mining in a fleet that has orca killing rats:

Use mining drones to mop up the small stuff.
Have ship tight orbit what the drones are working on.
Quick turn around time and hard to be bumped out of range.

Use survey scanner and put your lasers on the fat roids.
The kind that you know will last atleast 2 cycles.
Do similar with drones if you want to walk away.

Shut cycle off near the end to save cap.
So they don't start a cycle that you didn't want to use cap on.

Switch to other fat roids and let drones mop up the now almost depleted voids.

You get to walk way for 2 cycles and that is the only timer you need to worry about.

I'm not seeing the point of all this math.
Is it an OCD thing where you can't warp to next belt until every last piece is gone even if all the things worth full cycles are gone?

There may be some merit in it for a solo miner, to maximise yield per hour, but I think the last time I ore mined, I had 4 miners, an orca boost and an orca hauling, so would have been near impossible to keep up with filling figures in, just had a variety of crystals in the hold and waited for the asteroid is depleted to swap to another roid :)

Honestly, if you're into micromanagement and dedicating so much attention to mining, you're probably better off doing something more profitable per hour than mining, mining is poorly paid because it requires little attention compared to higher paid activities (especially since they've tweaked the NPC AI)

Good luck with the project though :) I dare say that the people who created evemon were first told "Why do you want to do that, waste of time, doesn't do anything useful....."