EVE Search - Manufactoring Formulas and Citadel

All Channels

Science and Industry

Manufactoring Formulas and Citadel

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

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
Timcanpy Yvormes Omni Galactic Central Omni Galactic Group 2	Posted - 2017.02.24 12:48:25 - [2] - Quote "x=if(MatNeed=1,1,Matneed(1-0.1)" xnumberrun* (1-0.042-0.01). And end it by roundup the final value?
Timcanpy Yvormes Omni Galactic Central Omni Galactic Group 2	Posted - 2017.02.24 14:04:40 - [3] - 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.90.9580.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(OrignalValueMERigBonus*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?
Timcanpy Yvormes Omni Galactic Central Omni Galactic Group 2	Posted - 2017.02.24 15:44:21 - [4] - 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

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.