Science & Industry

Hi, I've been trying to set up a spreadsheet for reprocessing and I'm encountering an issue that doesn't seem to have been answered on the forum. The issue is with the formula which I took from here http://eve-industry.org/export/IndustryFormulas.pdf

Rate = Facility Modifier * (1 + 0.03 * Reprocessing) * (1 + 0.02 * Reprocessing Efficiency) * (1 + 0.02 * Ore Specific Skill) * Implant Modifier * (1 - Station Tax)

Station Tax = 5% - (0.75% * Corporation Standing)

Facility Modifier 0.50
Implant Modifier 1.00
Reprocessing 5.00
Reprocessing Efficiency 4.00
Ore Specific Skill 0.00
Corporation Standing 0.52

Scordite exemplifies my issue (Base units / In-Game reprocess amount / Spreadsheet reprocess amount):

Tritanium 346 || 204 || 205
Mexallon 173 || 102 || 102

What is basically bugging me is that extra Tritanium that my spreadsheet calculates (OCD much?). I am not sure what is causing it but I tried approaching it as the game does. I tried the following:

Final results = Base Units - round (Unrecoverable) - round((Reprocessed)) * Tax)

Reprocessed = Base Units - round (Unrecoverable)

Scordite______Tritanium____ Mexallon
Base__________346_______173
Unrecoverable___132________66
Reprocess______214_______107
Tax_____________10_________5
Final___________204_______102


If I try it this way it seems to give me the same results as in-game. Can someone point the error of my ways?

Thanks!

It is my understanding that for POS you round down and for NPC Station you round to the next integer. Either way it doesn't change anything if I use a different round function. In the example I just used round(). Doesn't this function the same as floor?

Hah true. That is besides the point though. The numbers are correct I just forgot to change the column header.

The formula posted by the OP is flawed. Velicitia in the example given (Scordite) you are correct, you reached the correct value but only by chance. Here is the example of Kernite using your method and my own:

http://gyazo.com/1fe769174d09057c7739fc71c2b8118f

The normal formula yields a difference of 1 for the second material (difference from in game final values).

I've tested all the ores and ice in station and at a POS. My method seems to give the correct answers.

Rate = Facility Modifier * (1 + 0.03 * Reprocessing) * (1 + 0.02 * Reprocessing Efficiency) * (1 + 0.02 * Ore Specific Skill) * Implant Modifier

Net Yield = floor(Rate * Base Units) - round [ floor(Rate * Base Units) * Station Tax ]

Station Tax = max(0, 5% - (0.75% * Corporation Standing)

The problem seems to be with the fact that in order to calculate the final yield you first calculate yield based on skills/implants/station attributes, hence the "Rate". Out of that value, that must be rounded using floor(), we substract the station tax which again must be rounded() and we reach the final value.

This is the only way I managed to reach the same numbers seen in game.

Don't wanna disagree but there is a difference as I exemplified in the provided link. I typed the exact same formula you mentioned and it gives a different result than in game.

I might be missing something but I don't see what since it works perfectly.

Here is the same example with more info (the final Tax and Skills rows are for your formula) http://gyazo.com/5b07cd9ae1dbd0ac99713c6cc2bf78ac

floor( 158.16) is not equal to floor(165.80) - round (7.64) = and the latter gives the correct answer.

Sorry, forgot to check back :)). i tried doing it the way regnar described and it works! Thanks for the input guys.