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 Yield Spreadsheet
Author
Previous Topic Next Topic
Digital Messiah
Center for Advanced Studies
Gallente Federation
#1 - 2012-11-23 05:26:57 UTC
So I am currently working out how much I can make per hour mining. The formula I am using is...
Oreyield: 1961.0365
Duration: 121.78136 / 3600 = 29.5611742223933

Ex.
1961.0365 * 3 = 5883.1095 "all three strips."

5883.1095 / 0.1 = 58831.1 "the amount of veldspar in this case per cycle."

29.5611742223933 * 58831.1 = 1739116.25 "The amount of veldspar that can be mined in one hour."

So a few questions.
1. Does eft accurately show the proper yield per strip. Or should I use the yield shown per minute and change the formula.
2. Is my math ok?
3. Thank you for taking your time to answer a question about a spreadsheet.

Something clever
Matt Ellis
Caldari Provisions
Caldari State
#2 - 2012-11-23 09:18:09 UTC  |  Edited by: Matt Ellis
Has EFT been updated since the mining barge update? if not, then it will not show the right amount... you're best off right clicking your strips on each char, and see what the yield is(and then x it by the number of miners on the ship)... That's your best way of checking, if you ask me... EFT has been wrong about my DPS, Cap and Tank before, so i never trust it....

In regards to your maths... your 3 chars might rake in at different rates depending on skills... i would repeat the above steps on each one, and then add them together... rather than just multiplying the value by 3...

and what is this line about?

Duration: 121.78136 / 3600 = 29.5611742223933

I guess: Cycle Time / ?? = Duration... What is the 3600? cycles per hour?

In which case.. maths seems solid to me..
Liro Jedran
Boiled in Soup
#3 - 2012-11-23 14:59:06 UTC
The 3600 refers to the number of seconds in the hour. The formula shows you can do 29.5 cycles per hour.
Matt Ellis
Caldari Provisions
Caldari State
#4 - 2012-11-23 15:05:40 UTC
Liro Jedran wrote:
The 3600 refers to the number of seconds in the hour. The formula shows you can do 29.5 cycles per hour.


yeah... already worked that out.. thanks anyway
Musashi Date
#5 - 2012-11-23 15:54:14 UTC
Use yield per cycle/3minutes/180 seconds. The value for the mining amount when you look at your strip miner (undocked value i think; iirc, when im docked it doesnt show the proper value) will be the most accurate figure.

The third party program Isk Per Hour gives good calculations for your mining needs. Check out the forum thread link below, it is highly recommended. It will give you estimates on total raw yield, total ore/hour, and pricing. It even has this reverse calculation that builds the mineral components of an ore, pricing it according to mineral price and not per unit ore.

EVE IPH Industry Calculator Version 2.2 - Inferno 1.2 and More!
https://forums.eveonline.com/default.aspx?g=posts&t=63663&find=unread7
Dave Stark
#6 - 2012-11-23 16:41:25 UTC
Digital Messiah wrote:
So I am currently working out how much I can make per hour mining. The formula I am using is...
Oreyield: 1961.0365
Duration: 121.78136 / 3600 = 29.5611742223933

Ex.
1961.0365 * 3 = 5883.1095 "all three strips."

5883.1095 / 0.1 = 58831.1 "the amount of veldspar in this case per cycle."

29.5611742223933 * 58831.1 = 1739116.25 "The amount of veldspar that can be mined in one hour."

So a few questions.
1. Does eft accurately show the proper yield per strip. Or should I use the yield shown per minute and change the formula.
2. Is my math ok?
3. Thank you for taking your time to answer a question about a spreadsheet.


1. no idea, i use pyfa.

2. no. after calculating the yield for 1 strip miner, truncate it.. ore is harvested in units hence you get less m3 per cycle than the tooltip as it won't harvest a part of a unit of ore. time values need not be truncated. you will always mine *slightly* less than the tooltip shows, hence why mining drone rigs aren't that popular when mining things like arkonor that take up 16m3 per unit as the bonuses aren't enough to add an extra unit of ore to the yield.

3. sadly, i like numbers...

generally, other than truncating your yield based on what you're mining, it seems ok.
Digital Messiah
Center for Advanced Studies
Gallente Federation
#7 - 2012-11-24 06:44:27 UTC
I am factoring in ore size effecting the yield giving different numbers. Did not think about the drones and large ores factor.... Good to know.

I am not multiplying by 3 of my characters either. Each strip miner has a yield of 1960 something so all 3 make up the total value i used. I also have my own google documents spreadsheet that calculates refining values, cuts for boost / hauling, value from what ever region i set, and factors in 5-10% variations of ore. So I really just need to get the math right on my ore per hour.

Do you guys know the current best m3 a cycle on a hulk?

Something clever
Dave Stark
#8 - 2012-11-24 08:59:37 UTC
Digital Messiah wrote:
Do you guys know the current best m3 a cycle on a hulk?


perfect skills, t2 crystals, all mlu IIs in the lows, 2x 5% implants and 15% fleet bonus...

1961.036561 m3 per cycle per strip.
412nv Yaken
Caldari Provisions
Caldari State
#9 - 2012-11-26 05:19:22 UTC
Digital Messiah wrote:
So I am currently working out how much I can make per hour mining. The formula I am using is...
Oreyield: 1961.0365
Duration: 121.78136 / 3600 = 29.5611742223933

Ex.
1961.0365 * 3 = 5883.1095 "all three strips."

5883.1095 / 0.1 = 58831.1 "the amount of veldspar in this case per cycle."

29.5611742223933 * 58831.1 = 1739116.25 "The amount of veldspar that can be mined in one hour."

So a few questions.
1. Does eft accurately show the proper yield per strip. Or should I use the yield shown per minute and change the formula.
2. Is my math ok?
3. Thank you for taking your time to answer a question about a spreadsheet.


What ship/System you mining in though?

Is it just normal veldspar?

A True Champion of High Security Space
Digital Messiah
Center for Advanced Studies
Gallente Federation
#10 - 2012-11-26 05:46:49 UTC
412nv Yaken wrote:
Digital Messiah wrote:
So I am currently working out how much I can make per hour mining. The formula I am using is...
Oreyield: 1961.0365
Duration: 121.78136 / 3600 = 29.5611742223933

Ex.
1961.0365 * 3 = 5883.1095 "all three strips."

5883.1095 / 0.1 = 58831.1 "the amount of veldspar in this case per cycle."

29.5611742223933 * 58831.1 = 1739116.25 "The amount of veldspar that can be mined in one hour."

So a few questions.
1. Does eft accurately show the proper yield per strip. Or should I use the yield shown per minute and change the formula.
2. Is my math ok?
3. Thank you for taking your time to answer a question about a spreadsheet.


What ship/System you mining in though?

Is it just normal veldspar?


In this particular circumstance I calculated for a hulk, and all veldspar / variations have the same m3 they just refine at a higher yield.

Something clever