open All Channels
seplocked Science and Industry
blankseplocked Help with a spreadsheet (calculating BPO waste)
This thread is older than 90 days and has been locked due to inactivity.

Author Topic

Rusty Gank
Posted - 2011.08.21 23:28:00 - [1]

I have been working on making myself a spreadsheet to view costs of producing different BPO's that I own (or plan to own). Atm, I ONLY have the basic, no-waste formulas. How do I add in BPO waste (assuming it's not perfect ME). Do I use the base number of minerals or the amount of minerals atfer PE5 is trained. I am assuming it's base minerals, but I am really not sure on this. Any help guys?

Deep Space Innovations
Posted - 2011.08.22 00:35:00 - [2]

You would probably get more help if you posted in the EVE Technology Lab forum than here. But this thread might help you out some. This is where I went to figure out how to calculate waste.

Basically you add waste after you calculate the minerals and apply PE there. But there is a twist with how the mats are calculated from reprocessing. That's what the thread was about back when they changed to this new logic.

It can get confusing after a bit but if you decide you don't want to mess with it any more, there are several programs and spreadsheets out there that do this for you already. I wrote one (Here), there is Dedaf's sheet, Akita T has one, and there is EVE Meep. I think there are others as well but those are the ones I know of.

Hope that helps.

Rusty Gank
Posted - 2011.08.22 01:00:00 - [3]

Been messing around with your program. I like it. I think I'll call it quits on my spreadsheet lol

Tau Cabalander
Posted - 2011.08.22 19:08:00 - [4]

Edited by: Tau Cabalander on 22/08/2011 19:13:00

Base waste and material can be looked-up in the database (database values are base values), or they can be discovered by looking at an ME 0 BPO in-game:

base_waste = waste_on_ME_0_BPO
base_material = ROUND(material_on_ME_0_BPO / (1 + base_waste))

Total Material = ROUND(base_material * (1.25 + base_waste / (1 + ME_Level) - Production_Efficiency_Skill * 0.05))

Assuming Production Efficiency 5 skill:

Perfect_ME >= FLOOR(2 * base_waste * largest_quantity_base_material)
Perfect_ME >= FLOOR(2 * waste_on_ME_0_BPO * largest_quantity_material_on_ME_0_BPO / (1 + waste_on_ME_0_BPO))
Perfect ME >= largest_quantity_material_on_ME_0_BPO / ((1 + waste_on_ME_0_BPO) / (2 * waste_on_ME_0_BPO ))

I like to use the last one, as the divisor is a non-repeating decimal and easy to remember:
* Perfect ME on 10% base waste BPO: divide largest material quantity shown in-game on ME 0 BPO by 5.5
* Perfect ME on 5% base waste BPO: divide largest material quantity shown in-game on ME 0 BPO by 10.5
In both cases the fractional part is dropped by FLOOR() not rounded.

There is no such thing as perfect PE. It uses a similar formula with 25% time waste, but it doesn't round, so the fractions of a second add-up the more runs in the manufacturing job.

On most base 10% waste BPO, I like to research ME to 20 (<0.5% material waste) and PE to 25 (<1% time waste), unless that takes too long to research. Ammo BPO are the only ones I recommend researching to perfect ME and high PE, as many thousands of runs are manufactured, and the research time isn't unreasonable.


This thread is older than 90 days and has been locked due to inactivity.


The new forums are live

Please adjust your bookmarks to

These forums are archived and read-only