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.
 

Ore Yield Math
Author
Previous Topic Next Topic
Diesel Twitch
Blackwater Coalition Forces
Harkonnen Federation
#1 - 2013-03-24 14:40:52 UTC
I'm building a spreadsheet to allow me to pay my corp members on mining ops. I'm running into a little bit of trouble understanding the yield math. In my spread sheet I'm getting a refine rate of 109.4% Oops when really my refine rate in the station is 96.4%

Here's the info I'm using to do it. maybe some one can point out where I've gone wrong
EFY = StationEquip+0.375 * (1+RefineSkill*0.02)*(RefineEffSkill*0.04)*(1+OreSkill*0.05)) Gives me 109.4%

Station Equip = 0.50
Refine Skill = 5
Refine Eff = 5
Ore Skill = 4 (all high sec ores)
My Standing with the station is currently 1.84 (working on this)

Station takes work out to be 3.6%

What am I doing wrong?
Zifrian
The Frog Pond
Ribbit.
#2 - 2013-03-24 15:06:52 UTC
Max refine is 100%. So any calculations after that need to use 100, not greater.

Then you take off the station "take" percentage.
' We Take = (-3/4)*Standing + StationTax
StationTaxes = (StationTax * 100) - (0.75 * StationStanding)

So assuming station tax is 5% you get: StationTaxes = 5 - (1.38) => 3.62

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Velicitia
XS Tech
#3 - 2013-03-25 10:08:50 UTC
Zifrian wrote:
Max refine is 100%. So any calculations after that need to use 100, not greater.

Then you take off the station "take" percentage.
' We Take = (-3/4)*Standing + StationTax
StationTaxes = (StationTax * 100) - (0.75 * StationStanding)

So assuming station tax is 5% you get: StationTaxes = 5 - (1.38) => 3.62



this.

I've found it easier to wrap my raw mining yield calculators in a "min" function so that they get stuck at the right place.

i.e. min([refining yield maths here], 100)

anything less than 100% on yield shows as the refining percentage, else it will lock at 100.

One of the bitter points of a good bittervet is the realisation that all those SP don't really do much, and that the newbie is having much more fun with what little he has. - Tippia
Salpad
Carebears with Attitude
#4 - 2013-03-25 10:43:09 UTC
Diesel Twitch wrote:
My Standing with the station is currently 1.84 (working on this)


Have you trained the Connections skill?
Jay Kreutzer
Caldari Provisions
Caldari State
#5 - 2013-03-25 19:08:25 UTC
It's also important to note that station 'refine yield' value doesn't take into account the ore skill. so even if you have perfect standing and skills, you may not see a 100% refine yield, though if you look in the 'unrecoverable' it'll still say 0.
Connery Domino
Aliastra
Gallente Federation
#6 - 2013-03-26 13:34:25 UTC
You need to download this

EVE ISK PER HOUR (IPH)
http://sourceforge.net/projects/eveiph/

Diesel Twitch
Blackwater Coalition Forces
Harkonnen Federation
#7 - 2013-03-26 21:07:47 UTC
Salpad wrote:
Diesel Twitch wrote:
My Standing with the station is currently 1.84 (working on this)


Have you trained the Connections skill?


I have now! :)
Diesel Twitch
Blackwater Coalition Forces
Harkonnen Federation
#8 - 2013-03-26 21:08:46 UTC
Jay Kreutzer wrote:
It's also important to note that station 'refine yield' value doesn't take into account the ore skill. so even if you have perfect standing and skills, you may not see a 100% refine yield, though if you look in the 'unrecoverable' it'll still say 0.


I thought the formula does account for it. In the equation i posted its the "oreskill" that's the ore specific skill that adds a value to the refine
Elena Thiesant
The Scope
Gallente Federation
#9 - 2013-03-26 21:14:16 UTC
The formula does. The 'refine yield' number on the refine window (top right of the window) does not. Hence you should ignore that number.
Tau Cabalander
Retirement Retreat
Working Stiffs
#10 - 2013-03-26 22:12:49 UTC
Velicitia wrote:
I've found it easier to wrap my raw mining yield calculators in a "min" function so that they get stuck at the right place.

i.e. min([refining yield maths here], 100)

anything less than 100% on yield shows as the refining percentage, else it will lock at 100.

^^This