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.
 

Manufactoring Formulas and Citadel

First post
Author
Previous Topic Next Topic
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#1 - 2017-02-24 00:00:02 UTC
Hello

my sheet since EG is always off by a few unit in the needed amount

I dont know where i'm making my error

The current citadel has rig (4.2%) and bonus from hull

My formula to calculate the amount needed is "=if(MatNeed=1,1,Matneed*(1-0.1)*(1-0.042-0.01)"

after i get the value i multiple by the number of round and do a round up with zero decimal. so i get a integer

But i get the wrong value if i compare with fuzzwork

Could some one help me with the correct formula so i can start getting the correct values?

Regards
Tim
Fat Buddah
Federal Navy Academy
Gallente Federation
#2 - 2017-02-24 05:27:35 UTC
Bonuses get applied per jobs, not per run.
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#3 - 2017-02-24 12:48:25 UTC  |  Edited by: Timcanpy Yvormes
"x=if(MatNeed=1,1,Matneed*(1-ME value)"

x*numberrun* (1-0.042-0.01).

And end it by roundup the final value?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2017-02-24 12:56:36 UTC
Each bonus is applied separately.

So you have the me bonus, the rig bonus, and the hull bonus.

So ME 10, the 4.2 rig, and an ec hull, that's 0.9*0.958*0.99



There's also a potential floating point error, so it's recommended to first round the result to 4 decimal places (regular rounding) then ceiling it. (so you don't have a 42.00000000000000000001 becoming 43. floating point math is fun :D)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#5 - 2017-02-24 14:04:40 UTC
Steve Ronuken wrote:
Each bonus is applied separately.

So you have the me bonus, the rig bonus, and the hull bonus.

So ME 10, the 4.2 rig, and an ec hull, that's 0.9*0.958*0.99



There's also a potential floating point error, so it's recommended to first round the result to 4 decimal places (regular rounding) then ceiling it. (so you don't have a 42.00000000000000000001 becoming 43. floating point math is fun :D)


i'm trying to build Fernite Carbide Composite Armor Plate x71760

Atm i'm getting
Fernite Carbide - Original 44 - Calculated value 37.5574
Sylramic Fibers - Original 11 - Calculated Value 9.3894

=if(OrignalValue=1,1,round(OrignalValue*ME*RigBonus*HullBonus,4))

ME=1-10/100=0.9
Rig =1-4.2/100=0.9580
Hull=1-1/100=0.99

after i multiple by the total runs i do a roundup to zero decimal.

the value i get are
Fernite Carbide 2695120
Sylramic Fibers 673784

Near your site but no the same. Where i'm missing something?
Fat Buddah
Federal Navy Academy
Gallente Federation
#6 - 2017-02-24 14:50:12 UTC  |  Edited by: Fat Buddah
You have to muliply by runs before applying the bonuses

Let's say you have a BP that requires 1 Trit.
1 Trit * 10 runs = 10 Trit
This is your job requirement. The bonuses are apllied to this figure, not per run BP requirement.
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#7 - 2017-02-24 15:44:21 UTC
Thank for the help guys

Now i'm getting the correct value and now i got what u said Fat Buddah

Also thanks Steve Ronuken

I will have to remake my sheet to do the mat like that instead of the way i have it.

It can be closed the post