Science & Industry

Hello,

I'm trying to figure out how to calculate my own BoMs for BPOs based on varying ME levels. I'm aware that wastage = 10/(1+ME), and that BPOs off the market start at 10% wastage. So the issue is how to properly calculate any ME level BoM from that point. Rounding becomes the main issue. Ie, when do I round, and how (round up? Down? Just round to closest whole number?).

If someone could give me an example of starting with an ME 0 BPO BoM and working to (for the sake of arguement) an ME 15 BoM of something simple. Preferably small numbers in the BoM (that's where rounding errors have the largest effect).

Thanks!

Thank you, although I'm aware of the math, and of the tools available if I want to use someone else's tool. But I have my own tools. The one thing that's always annoyed me is having to manually enter amounts on the BoM for different ME levels. I'd much rather just change the ME as an input on my own tool and have the BoM's update automatically.

I'll work out an example below of what's going wrong for me (it'll take some time... so I'll just edit this post over the next few minutes)



An archon BP with 0 ME has the following BoM:
Cap Armor plates - 11
Cap capacitor battery - 11
Cap computer system - 4
Cap construction parts - 9
Cap corporate hangar bay - 11
Cap drone bay - 44
Cap jump drive - 11
Cap power generator - 11
Cap propulsion engine - 7
Cap sensor cluster - 4
Cap shield emitter - 4
Cap ship maint. bay - 11

Ideal ME is 2, at which point the BoM is now as follows:
Cap Armor plates - 10
Cap capacitor battery - 10
Cap computer system - 4
Cap construction parts - 8
Cap corporate hangar bay - 10
Cap drone bay - 41
Cap jump drive - 10
Cap power generator - 10
Cap propulsion engine - 7
Cap sensor cluster - 4
Cap shield emitter - 4
Cap ship maint. bay - 10

I can achieve this result with the following: Start with the known 10% waste in mind. divide the starting #'s by 1.10, then multiply that value by 1 + wastage. In other words:

Let Nap,0 = number of armor plates at ME = 0
Nap,2 = number of armor plates at ME = 2

Nap,2 = Nap,0/1.1 *(1+ (10/(1+ME)))

so Nap,0 = 11
ME = 2

Nap,2 = 10.333

I've discovered that for this particular BoM, simply rounding Nap,2 works perfectly. It works for all components of the archon BP. Unfortunately, if I go to build say, a rokh, I wind up being off the actual value about half the time by 1 unit. I know these units of minerals are inconsequential in terms of actual costs, (OH NOES! 83833 units instead of 83832 units of pyrite!) but what concerns me is when I use this tool to build a cap ship and I'm off by 1 cap ship component or something. That's not cool at all.

I want to perfect my super internet spaceship spreadsheet! Please help me solve this problem if you know how.

To get the actual numbers you must first get the base value.

The values in the database dump are the base numbers already.
If you base your numbers off the Show Info of a ME 0 BPO, then you must first divide them by 1.1 (drones have only a base waste of 5%!!) and round. Rounding is always done to the closest integer.

To calculate the values for waste on any given ME level, use this formula:

Base Materials * waste factor * ( 1 / ( 1 + ME ))

This works for every ME level >= 0

For more info on negative ME or skill waste see http://wiki.eve-id.net/Equations