Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Timcanpy Yvormes
Omni Galactic Central Omni Galactic Group
2
|
Posted - 2017.02.24 00:00:02 -
[1] - Quote
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
35
|
Posted - 2017.02.24 05:27:35 -
[2] - Quote
Bonuses get applied per jobs, not per run. |
Timcanpy Yvormes
Omni Galactic Central Omni Galactic Group
2
|
Posted - 2017.02.24 12:48:25 -
[3] - Quote
"x=if(MatNeed=1,1,Matneed*(1-0.1)"
x*numberrun* (1-0.042-0.01).
And end it by roundup the final value? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6495
|
Posted - 2017.02.24 12:56:36 -
[4] - Quote
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
Omni Galactic Central Omni Galactic Group
2
|
Posted - 2017.02.24 14:04:40 -
[5] - Quote
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
35
|
Posted - 2017.02.24 14:50:12 -
[6] - Quote
You have to muliply by runs before applying the bonuses |
Timcanpy Yvormes
Omni Galactic Central Omni Galactic Group
2
|
Posted - 2017.02.24 15:44:21 -
[7] - Quote
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 |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |