EVE Search - ME formula

All Channels

Science and Industry

ME formula

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

Monitor this thread via RSS [?]

Pages: [1] :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
DrWh0 Gallente The Scope	Posted - 2008.11.18 07:34:00 - [1] Hi, I am making a spreadsheet for the ships i produce to give me all my little bits of info, its only for 5 ships but im stuck on the negative -ME side of it. I am trying to work it out based on the wastage percentage, say i have a cerb print with -6 ME and a wastage factor of 70% would this be: base amount + 70% ? as everytime i try this it comes out with a slightly bigger amount of materials than eve meep anyhelp ta DrWh0
RaTTuS BIG Libertas Fidelitas	Posted - 2008.11.18 08:06:00 - [2] from the top of my head round([amount from the Item db] (1.1+0.1-[ME value]),0)
SeismicForce Terra Incognita Vanguard.	Posted - 2008.11.18 08:53:00 - [3] It's definatly base + 70% in this case. Are you sure your component BPO's (if you use them) are calculating correctly? Originally by: Allisie In a recent interview, a dev mentioned that ships and skills cause lag and will be removed in EVE 2.
DrWh0 Gallente The Scope	Posted - 2008.11.18 09:18:00 - [4] Edited by: DrWh0 on 18/11/2008 09:18:18 Originally by: SeismicForce It's definatly base + 70% in this case. Are you sure your component BPO's (if you use them) are calculating correctly? In evemeep i get the following figures ME 0 = 110 -ME 6 = 170 If i try and work it out like i thought it would be ( base + 70% ) and i get -ME 6 = 187 on paper this seems simple 70 % of 110 is: 110/100*70 = 77 added to the original 110 = 187 but evemeep kicks out 170 still confused even trying to get the other formula to work from the other post
RaTTuS BIG Libertas Fidelitas	Posted - 2008.11.18 10:18:00 - [5] from my sheet I use for example base value 100 so ME 0 = 110 ME -6 = 170 from :- Round ( 100 * ( 1.1 + 0.1(-ME Value) ),0 ) also Round ( 100 ( 1.1 - 0.1*(ME Value) ),0 ) gets the same or am I barking up the wrong tree -- BIG Lottery, BIG Deal, InEve
DrWh0 Gallente The Scope	Posted - 2008.11.18 11:29:00 - [6] Originally by: RaTTuS from my sheet I use for example base value 100 so ME 0 = 110 ME -6 = 170 from :- Round ( 100 * ( 1.1 + 0.1(-ME Value) ),0 ) also Round ( 100 ( 1.1 - 0.1*(ME Value) ),0 ) gets the same or am I barking up the wrong tree Thanks for your help but I must be having a really bad start to the day as I still cant get the formula to work as intended in openoffice
RaTTuS BIG Libertas Fidelitas	Posted - 2008.11.18 12:11:00 - [7] In open office =round(100 (1.1-0.1-6)) -- BIG Lottery, BIG Deal, InEve
DrWh0 Gallente The Scope	Posted - 2008.11.18 12:15:00 - [8] Originally by: RaTTuS In open office =round(100 (1.1-0.1-6)) thanks again for that mate.. its all tip top
RaTTuS BIG Libertas Fidelitas	Posted - 2008.11.18 12:24:00 - [9] np - I was using a google sheets one that came from excel ... so the syntax had changed ... but I have open office on this machine and may re-do mine to be more nice and funky - so I can work out many build with differnt me levels etc... -- BIG Lottery, BIG Deal, InEve
Jurgen Cartis Caldari Interstellar Corporation of Exploration	Posted - 2008.11.18 18:16:00 - [10] Originally by: DrWh0 Edited by: DrWh0 on 18/11/2008 09:18:18 Originally by: SeismicForce It's definatly base + 70% in this case. Are you sure your component BPO's (if you use them) are calculating correctly? In evemeep i get the following figures ME 0 = 110 -ME 6 = 170 If i try and work it out like i thought it would be ( base + 70% ) and i get -ME 6 = 187 on paper this seems simple 70 % of 110 is: 110/100*70 = 77 added to the original 110 = 187 but evemeep kicks out 170 still confused even trying to get the other formula to work from the other post Found the problem, you're assuming that ME 0 = Base Value. ME 0 is Base Value + 10%, if you take the ME 0 value and get the base value from there (ME 0 / 1.1, round to nearest), it will work.
DrWh0 Gallente The Scope	Posted - 2008.11.18 19:57:00 - [11] Originally by: Jurgen Cartis Found the problem, you're assuming that ME 0 = Base Value. ME 0 is Base Value + 10%, if you take the ME 0 value and get the base value from there (ME 0 / 1.1, round to nearest), it will work. yea thanks for that , for those who didnt have it i used this to get the figure A = base value (true value with no wastage) B = ME value =ROUND(A/100(B(-10)+10)+A) this spits out the right figure so im pleased o7 DrWh0

Pages: [1] :: one page
First page \| Previous page \| Next page \| Last page

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.