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.
 

Blueprint Material Level Calculation
Author
Previous Topic Next Topic
Brock Nelson
#1 - 2012-04-15 05:51:34 UTC
Just revisiting some of my spreadsheets and found that a few of my resources have disappeared.

This is what I've found by digging up some old threads

Wastage Factor (ME >=0) = round(BaseMaterial x (BaseWaste/100) x (1 / (ME+1)),0)

Wastage Factor (ME <0) = round(BaseMaterial x (BaseWaste/100) x (1-ME),0)

Material Requirements = round((BaseMaterial + (BaseMaterial x (0.25 - (0.05 * 5))) + (5 x WastageFactor/100)),0)

However, punching in the numbers for Raven blueprint, the numbers that I get from the above formula doesn't match what I get ingame.

Where is the formula wrong?

Signature removed, CCP Phantom
Haulie Berry
#2 - 2012-04-15 06:22:14 UTC  |  Edited by: Haulie Berry
Try:

WF = BWF/(ME+1)

Required = Round(Basematerial * (1+ WF))

So for a raven with ME 12

BWF = .1
WF = .1/13 =0.00769230769230769230769230769231


Base tritanium: 7577632

Trit needed: 7577632 * 1.0076923076923076923076923076923) = 7,635,921.476923076923076923076923

Should come out to 7635921


No need to include base material in your WF calc - just the base wastage factor and the ME.
Aluka 7th
#3 - 2012-04-15 06:28:15 UTC  |  Edited by: Aluka 7th
Use this for last calculation:
Required_Amount = Round(Base_Amount * ((1 + (Default_Blueprint_Waste_Factor / (1 + Blueprint_Material_Level))) + (0.25 - (0.05 * Production_Efficiency_Skill_Level))), 0)

Basically this site has eq you need:
http://wiki.eve-id.net/Equations
Tau Cabalander
Retirement Retreat
Working Stiffs
#4 - 2012-04-15 08:58:22 UTC  |  Edited by: Tau Cabalander
The most common mistake is to not use the correct base material values. The materials on a ME 0 BPO include base waste. The database dump only has base values.

Base Material = ROUND(Amount on ME 0 BP / (1 + Base Waste on ME 0 BPO))

Total Material = ROUND(Base Material * (1.25 + Base Waste / (1 + ME Level) - Production Efficiency Skill * 0.05))

Perfect ME = FLOOR(Largest Amount of Material on ME 0 BPO / ((1 + Base Waste) / (2 * Base Waste)))
Brock Nelson
#5 - 2012-04-15 16:00:08 UTC
How would the formula be adjusted for invented bpcs?

Signature removed, CCP Phantom
Haulie Berry
#6 - 2012-04-15 16:20:47 UTC
Brock Nelson wrote:
How would the formula be adjusted for invented bpcs?



Personally, I'm pretty lazy, and the number of negative ME values is so small that when I did my spreadsheets I just hardcoded the negative ME wastage factors.

You can get WF for negatives, though, with WF = BWF - ME/10

And then 1+WF is the multiplier to determine wasted material.
Tau Cabalander
Retirement Retreat
Working Stiffs
#7 - 2012-04-15 19:37:15 UTC
Brock Nelson wrote:
How would the formula be adjusted for invented bpcs?

Negative ME is a multiplier of the base waste, rather than a divisor.

For ME Level < 0
Total Material = ROUND(Base Material * (1.25 - Base Waste * ME Level - Production Efficiency Skill * 0.05))

Of course there is also extra materials which are not affected by waste.
Megos Adriano
Aliastra
Gallente Federation
#8 - 2012-04-16 02:23:47 UTC
http://zofu.no-ip.de/bpo

And boom goes the dynamite.