EVE Search - T2 Wastage Factor

All Channels

Science and Industry

T2 Wastage Factor

» 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)
Exarch Rakanis	Posted - 2011.02.11 11:52:00 - [1] Hi, i'm trying to append some of my speadsheets to account for wastage factor based on ME level of a blueprint, but i am having trouble understanding how to use the formula correctly as wasted factor is in per cent but ME level is an intiger and i would like an output as a decimal. I have found the following formula: For Me Levels LESS than 0 [Calculated Waste Factor]=([Waste Factor]-[Blueprint ME Level]+1)/10) Basically i don;t know how to do ([10% +4] + 1)/10 for example of an ME of -4 Ideally i would like an output value as a decimal over 1, Where i could put in ME 0 material cost and then calculate the required amount at different MEs.. however at the base ME of zero, the wastage factor is already 10%, so i would have to take this into account in my forumla. as an example if the wastage factor were 40% could i just put in: Total Material req = 1.4 x [(ME0 Material req/110) x 100]? But how do i get the first formula to output either a value in % or a decimal value showing me the wastage factor? Thanks to any math guys out there who can help me
Greg Huff	Posted - 2011.02.11 13:39:00 - [2] Originally by: Exarch Rakanis [Calculated Waste Factor]=([Waste Factor]-[Blueprint ME Level]+1)/10) The "[Waste Factor]" would be 1.1 (or 110%)
Exarch Rakanis	Posted - 2011.02.11 13:54:00 - [3] Originally by: Greg Huff Originally by: Exarch Rakanis [Calculated Waste Factor]=([Waste Factor]-[Blueprint ME Level]+1)/10) The "[Waste Factor]" would be 1.1 (or 110%) So, for ME -4 i'd have, (1.1+4+1)/10 = 6.1/10 = 0.61 Waste factor (at ME -4) .. that isn't right, is it?
Zircalla	Posted - 2011.02.11 14:12:00 - [4] I calculate waste factor for T2 ships in a cost analysis spreadsheet. Since it is just T2 stuff, I don't worry about regular ME and simply use: Waste = (5 - (decryptor adj)) / 10 [in percent] So, w/o decryptor, the waste is (5-0)/10 = 50% If your decryptor has a -2 ME adjustment, your waste is: (5-(-2)/10 = 70% If your decryptor is +3 ME, your waste is: (5-3)/10 - 20% This is all from memory (I am not looking at it right now), but I think that is the right formula I used and tested extensively.
Greg Huff	Posted - 2011.02.11 14:36:00 - [5] Originally by: Exarch Rakanis Originally by: Greg Huff Originally by: Exarch Rakanis [Calculated Waste Factor]=([Waste Factor]-[Blueprint ME Level]+1)/10) The "[Waste Factor]" would be 1.1 (or 110%) So, for ME -4 i'd have, (1.1+4+1)/10 = 6.1/10 = 0.61 Waste factor (at ME -4) .. that isn't right, is it? Sorry... My brain still wasn't awake yet. Positive ME: Actual Material = Base Material * (1 + 0.1 / (ME + 1)) * (1.25 - 0.05 * Production Efficiency Skill) Negative ME: Actual Material = Base Material * (1 + 0.1 - ME / 10) * (1.25 - 0.05 * Production Efficiency Skill) ME -4 would be (1 + 0.1 - -4/10), since you do the division first you get (1 + 0.1 - -0.4) or 1.5
Exarch Rakanis	Posted - 2011.02.11 15:09:00 - [6] Originally by: Greg Huff Originally by: Exarch Rakanis Originally by: Greg Huff Originally by: Exarch Rakanis [Calculated Waste Factor]=([Waste Factor]-[Blueprint ME Level]+1)/10) The "[Waste Factor]" would be 1.1 (or 110%) So, for ME -4 i'd have, (1.1+4+1)/10 = 6.1/10 = 0.61 Waste factor (at ME -4) .. that isn't right, is it? Sorry... My brain still wasn't awake yet. Positive ME: Actual Material = Base Material * (1 + 0.1 / (ME + 1)) * (1.25 - 0.05 * Production Efficiency Skill) Negative ME: Actual Material = Base Material * (1 + 0.1 - ME / 10) * (1.25 - 0.05 * Production Efficiency Skill) ME -4 would be (1 + 0.1 - -4/10), since you do the division first you get (1 + 0.1 - -0.4) or 1.5 Thanks, that clears it up, it looks like the formula i was using had a bracket in the wrong place. Just to confirm, if i were to have a ME of -1, i would have a wastage factor of 20%? And also if i were to Calculate the material Requirements by using ME 0 as a base i could take the 0.1 out of the formula and multiply this number by the ME0 Material cost? E.g. i could do this.. Actual Material = ME0 material * (1 - ME/10) Right? Thanks for helping with this
Greg Huff	Posted - 2011.02.11 15:30:00 - [7] Originally by: Exarch Rakanis Originally by: Greg Huff Sorry... My brain still wasn't awake yet. Positive ME: Actual Material = Base Material * (1 + 0.1 / (ME + 1)) * (1.25 - 0.05 * Production Efficiency Skill) Negative ME: Actual Material = Base Material * (1 + 0.1 - ME / 10) * (1.25 - 0.05 * Production Efficiency Skill) ME -4 would be (1 + 0.1 - -4/10), since you do the division first you get (1 + 0.1 - -0.4) or 1.5 Thanks, that clears it up, it looks like the formula i was using had a bracket in the wrong place. Just to confirm, if i were to have a ME of -1, i would have a wastage factor of 20%? And also if i were to Calculate the material Requirements by using ME 0 as a base i could take the 0.1 out of the formula and multiply this number by the ME0 Material cost? E.g. i could do this.. Actual Material = ME0 material * (1 - ME/10) Right? Thanks for helping with this No, ME0 is considered a positive ME. ME0 = (1 + 0.1/(0 + 1)) or 10% ME1 = (1 + 0.1/(1 + 1)) or 5% ME-1 = (1 + 0.1 - -1/10) or 20%
Exarch Rakanis	Posted - 2011.02.11 15:46:00 - [8] Edited by: Exarch Rakanis on 11/02/2011 15:52:03 Originally by: Greg Huff Originally by: Exarch Rakanis Originally by: Greg Huff Sorry... My brain still wasn't awake yet. Positive ME: Actual Material = Base Material * (1 + 0.1 / (ME + 1)) * (1.25 - 0.05 * Production Efficiency Skill) Negative ME: Actual Material = Base Material * (1 + 0.1 - ME / 10) * (1.25 - 0.05 * Production Efficiency Skill) ME -4 would be (1 + 0.1 - -4/10), since you do the division first you get (1 + 0.1 - -0.4) or 1.5 Thanks, that clears it up, it looks like the formula i was using had a bracket in the wrong place. Just to confirm, if i were to have a ME of -1, i would have a wastage factor of 20%? And also if i were to Calculate the material Requirements by using ME 0 as a base i could take the 0.1 out of the formula and multiply this number by the ME0 Material cost? E.g. i could do this.. Actual Material = ME0 material * (1 - ME/10) Right? Thanks for helping with this No, ME0 is considered a positive ME. ME0 = (1 + 0.1/(0 + 1)) or 10% ME1 = (1 + 0.1/(1 + 1)) or 5% ME-1 = (1 + 0.1 - -1/10) or 20% This is getting a bit complicated.. ME0 is 10% or 0.1 So by taking out the 0.1 in the part Bolded: Actual Material = Base Material * (1 + 0.1 - ME / 10), and adding it to the "Base Material" ... it would be the same thing, no? I.e. This formula (for negative ME) Actual Material = *Base Material 1.1** * (1 -ME/10), Where Base Material * 1.1 = ME0 Material cost Finally giving, Actual Material Cost = ME0 Material cost * (1 - ME/10) I am not sure where i went wrong ... Even if ME0 is positive is 10% just by taking out of the left and putting it on the right it should work no? BMC * (1 + 0.1 - Me/10) = 1xBMC + 0.1xBMC - BMCx(ME/10), right? errm, i'm getting a bit confused with this.. looks like something i have done is wrong. I really just need a formula that gives a total material cost from ME0 material cost for Neg ME blueprints. [Edit] ok i think i know where i went wrong, The formula should be this, right? Final Material Cost = ME0 Material cost - (ME0 Material cost/1.1)*(ME/10)
Greg Huff	Posted - 2011.02.11 15:55:00 - [9] Originally by: Exarch Rakanis Originally by: Greg Huff Originally by: Exarch Rakanis Originally by: Greg Huff Sorry... My brain still wasn't awake yet. Positive ME: Actual Material = Base Material * (1 + 0.1 / (ME + 1)) * (1.25 - 0.05 * Production Efficiency Skill) Negative ME: Actual Material = Base Material * (1 + 0.1 - ME / 10) * (1.25 - 0.05 * Production Efficiency Skill) ME -4 would be (1 + 0.1 - -4/10), since you do the division first you get (1 + 0.1 - -0.4) or 1.5 Thanks, that clears it up, it looks like the formula i was using had a bracket in the wrong place. Just to confirm, if i were to have a ME of -1, i would have a wastage factor of 20%? And also if i were to Calculate the material Requirements by using ME 0 as a base i could take the 0.1 out of the formula and multiply this number by the ME0 Material cost? E.g. i could do this.. Actual Material = ME0 material * (1 - ME/10) Right? Thanks for helping with this No, ME0 is considered a positive ME. ME0 = (1 + 0.1/(0 + 1)) or 10% ME1 = (1 + 0.1/(1 + 1)) or 5% ME-1 = (1 + 0.1 - -1/10) or 20% This is getting a bit complicated.. ME0 is 10% or 0.1 Yes. 0.1 is the decimal representation of 10%. i.e. 10% = 0.1 ... and you completely confused me after that. Are you trying to get one equation that will work for both positive and negative ME's (i.e. ME0 and ME-1)? Or are you trying to get an equation to show you the difference between ME0 and ME-1?
Exarch Rakanis	Posted - 2011.02.11 16:10:00 - [10] Sorry, the 10% or 0.1 was part of my explanation. I'm trying to get a Final Material cost of negative ME blueprints based on their ME 0 Material requirements, rather than based on their Base material requirements.
Greg Huff	Posted - 2011.02.11 16:20:00 - [11] Originally by: Exarch Rakanis Sorry, the 10% or 0.1 was part of my explanation. I'm trying to get a Final Material cost of negative ME blueprints based on their ME 0 Material requirements, rather than based on their Base material requirements. Ok It's going to be [Negative ME Waste Factor]-10% Waste Factor = (1 + 0.1 - (ME/10)) - 0.1 Waste Factor = 1 + 0.1 - (ME/10) - 0.1 Waste Factor = 1 + ~~0.1~~ - (ME/10) - ~~0.1~~ Waste Factor = 1 - (ME/10)
Exarch Rakanis	Posted - 2011.02.11 16:44:00 - [12] Originally by: Greg Huff Originally by: Exarch Rakanis Sorry, the 10% or 0.1 was part of my explanation. I'm trying to get a Final Material cost of negative ME blueprints based on their ME 0 Material requirements, rather than based on their Base material requirements. Ok It's going to be [Negative ME Waste Factor]-10% Waste Factor = (1 + 0.1 - (ME/10)) - 0.1 Waste Factor = 1 + 0.1 - (ME/10) - 0.1 Waste Factor = 1 + ~~0.1~~ - (ME/10) - ~~0.1~~ Waste Factor = 1 - (ME/10) Sorry, i'm not following. Could you help me with an Example? say, if the ME0 Material Requirement for "tritanium" was 10 units, how could i get the Final Material cost using that formula, for a -4ME BP?
Exarch Rakanis	Posted - 2011.02.11 17:07:00 - [13] Originally by: Exarch Rakanis E.g. i could do this.. Actual Material = ME0 material * (1 - ME/10) Right? So this is correct? I better get out my calculator and compare some blueprints to check
Greg Huff	Posted - 2011.02.11 17:32:00 - [14] AM = Actual Materials BM = ME0 Required Material ME = ME level of Blueprint If you have PE skill of 5: AM = (BM/1.1) * (1.1-(ME/10)) This should give you a pretty close answer.
Exarch Rakanis	Posted - 2011.02.12 07:34:00 - [15] Thanks, it works out pretty well. it looks like is miscalculates by an extra component here and there, but it'll do. Also that is the same as the formula i quoted above

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.