These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Mining Efficiencies Spreadsheet
Author
Previous Topic Next Topic
Neugeniko
Insight Securities
#1 - 2012-11-06 04:42:52 UTC  |  Edited by: Neugeniko
Howdy,

I recently got back into mining after not having done it seriously before. By seriously I mean I made a spreadsheet
to help me choose ships and what ore to mine. The spreadsheet covers the major mining efficiencies.


  • Cycle Efficiency - When not short cycling lasers - Defined by Time laser is mining/Time laser is ON.
  • Hauling Efficiency - Time Spent Mining/(Time Spent Hauling+Mining)
  • Boost Efficiency - Average Volume per unit time/Boosted Volume per unit time


Mining Efficiencies Spreadsheet V1.2

If you have any questions on what each cell means see the help sheet or post here. Suggestion would be most welcome
and help with my todo list would be awesome.

Cheers.

Neug.

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Every One
Triglavian Directive
S h a d o w
#2 - 2012-11-06 07:06:56 UTC
Seems...complex and I like complex stuff. However I don't understand most of the column headers, starting with "Number". Maybe describe a bit what they all mean?

Cheers
Neugeniko
Insight Securities
#3 - 2012-11-06 08:03:05 UTC
Every One wrote:
Seems...complex and I like complex stuff. However I don't understand most of the column headers, starting with "Number". Maybe describe a bit what they all mean?

Cheers


There is a sheet called help which explains the columns.
Number is the number of asteroids for that type of ore, a survey
scanner will tell you the number. Min ore and max ore is the minimum
and maximum ore quantities for asteroids of that type, again from the
survey scanner result.

Yield per laser per cycle can be found by
show info on your mining laser module under ore
amount. As can the cycle time which is usually 180 secs.

Yield bonus and cycle reduction are fleet bonii.

Cargo is the cargo space or ore hold of you or your
dedicated hauler.

Trip time is the time to get to a belt and back from the
station you are dropping ore in. And hauler is TRUE if
you have another ship hauling for u.

That's all the input fields. Important output fields are
Isk per hour in green.

Hope this help.

Neug.

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Musashi Date
#4 - 2012-11-06 12:30:45 UTC
Hmm, try to factor in the variable X.... laziness. Usually it's affected by the number of trips, and time spent daily. It's okay for me to lose say 2~3M for 12 roundtrips against and odd 20+ trips back and forth. Mining is soooo repetitive.. so that variable X will help somewhat.

The third party program EvE Isk Per Hour has a mining function that is very useful, check it out. It has this reverse pricing system where you input current mineral prices and it will give you what an ore type should be priced as an equivalent, nifty if you can incorporate it into spreadsheet.

Oh, with the current prices of minerals nowadays, it is more lucrative to move into minerals instead of just trading with ores. One of my month old spreadsheet tells me its around 6~11% more (though this will be regional and always a holiday/weekend peak price estimation). It will also be much easier for you to transport minerals against ores. So I suggest you extend your ore sheet to a mineral sheet (then a BPO sheet, then a manufacturing sheet, ... heh)
Neugeniko
Insight Securities
#5 - 2012-11-06 17:49:53 UTC
Musashi Date wrote:
Hmm, try to factor in the variable X.... laziness. Usually it's affected by the number of trips, and time spent daily. It's okay for me to lose say 2~3M for 12 roundtrips against and odd 20+ trips back and forth. Mining is soooo repetitive.. so that variable X will help somewhat.

The third party program EvE Isk Per Hour has a mining function that is very useful, check it out. It has this reverse pricing system where you input current mineral prices and it will give you what an ore type should be priced as an equivalent, nifty if you can incorporate it into spreadsheet.

Oh, with the current prices of minerals nowadays, it is more lucrative to move into minerals instead of just trading with ores. One of my month old spreadsheet tells me its around 6~11% more (though this will be regional and always a holiday/weekend peak price estimation). It will also be much easier for you to transport minerals against ores. So I suggest you extend your ore sheet to a mineral sheet (then a BPO sheet, then a manufacturing sheet, ... heh)


Thanks for the suggestion. I'll put a refining calculator in for ore equivalent
prices thou I'll get the sheet to automatically grab mineral price from eve central.
Just wondering if I can get a refining table somewhere, as it's probably several hundred
data points that I'd rather not punch in.


Neug

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Musashi Date
#6 - 2012-11-06 19:21:13 UTC
Hmm, I have forgotten to include that the 6~11% bump is only realized at 100% refining.
Neugeniko
Insight Securities
#7 - 2012-11-07 04:36:15 UTC
Musashi Date wrote:
Hmm, I have forgotten to include that the 6~11% bump is only realized at 100% refining.


Ill put in a cell for refining %, that should make the sheet atleast as useful
as most of the programs/websites around.

Neug.

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Every One
Triglavian Directive
S h a d o w
#8 - 2012-11-07 06:56:40 UTC
Neugeniko wrote:


Hope this help.

Neug.



It sure did, will look more into it when I have the time, cheers!
Neugeniko
Insight Securities
#9 - 2012-11-08 23:40:18 UTC
Added a cell for refining efficiency. Sheet now calculates isk per hour
for both selling ore and refined minerals.


Neug.

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Neugeniko
Insight Securities
#10 - 2012-11-10 04:05:30 UTC
I'm adding drones to my sheet. If I put drones
on a nearly empty roid do they still cycle for
60 secs before returning?

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Neugeniko
Insight Securities
#11 - 2012-11-10 10:16:19 UTC
Updated to Version 1.2, includes drones.

I did a comparison between -

Setup 1
Orca (140k cargo + Foreman Mindlink + T2 Mining Drones)
Hulk (5% implant + 3 MLU + T2 Mining Drones)

Setup 2
Mackinaw (Foreman Mindlink + 3 MLU + T2 Mining Drones)
Mackinaw (5% implant + 3 MLU + T2 Mining Drones)

Without Short Cycling your lasers.

Setup 1 wins for trip times greater than 2 mins.

With Perfect Cycling.

Setup 1 wins for trip times greater than 2mins 30 secs.

In both circumstances I use a docked time (docking/unloading/undocking) of 20 secs.

Indices/Mining Simulator V6.41 UPDATED*

Daily Forge Mineral Sales Summary V1.5

Neug's Prime Industrial Real Estate V1.3
Musashi Date
#12 - 2012-11-15 14:18:37 UTC
Kudos on trying to make sense out of mining drones.. I've long given up on how to get good estimates on how they contribute. In my experience they roughly deposit twice per three minutes. Your spreadsheet is a whole lot bigger than mine now haha lotsa numbers there. But its good to see some stats are reflecting on what I also have..