EVE Search - Which components of T2 production are subject to waste?

Check My IP Information

All Channels

Science and Industry

Which components of T2 production are subject to waste?

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

Monitor this thread via RSS [?]

Pages: 1 [2] :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Fubar Eagle Eye Inc.	Posted - 2009.05.17 22:03:00 - [31] I have created a set queries to use in the program Microsoft SQL Server Management Studio Express to create a manufacturing build requirements table that properly identifies which materials require waste calculations. The table is accurate as far as I know. Comments, corrections, and suggestions are welcome. Apocrypha_1.1.0.86756_db_CreateBuildReqs.zip
Fubar Eagle Eye Inc.	Posted - 2009.05.17 22:07:00 - [32] Originally by: Shawn Gallentino Wow, All of this complexity and I still have questions. This one is simple though. At which point in the madness does the Assembly's material modifier take effect? Does it take effect prior to the material mat (i.e. Base Material * Assembly Mod) or is it after (Final Material * Assembly Mod). I use the following logic to determine waste per run. If bpMaterialLevel >= 0 Then wasteMod = ((wasteFactor/100) / (bpMaterialLevel + 1)) Else wasteMod = (-bpMaterialLevel + 1) / 10 End If SkillBonus = 1.25 - (0.05 * CharSkillLevel) StationBonus = StationMaterialModifier - 1 BPMLWaste = BaseMaterialReq * wasteMod SkillWaste = BaseMaterialReq * (SkillBonus - 1) StationWaste = BaseMaterialReq * (SkillBonus * StationBonus) Waste = Round(BPMLWaste + SkillWaste + StationWaste, 0) You should make sure you are not using bankers rounding(ie Round-to-even method). The required materials would then be (BaseMaterialReq + Waste) * Runs
Sidrat Flush Caldari Life is Experience	Posted - 2009.05.18 15:48:00 - [33] How do you know if Excel is using Bankers rounding and how do you stop it doing so? EXP-L Eve Industrial Organiser
Sidrat Flush Caldari Life is Experience	Posted - 2009.05.18 17:32:00 - [34] Can anyone provide the access version of the SQL needed to create a cross table view that has activity 1 items then activity 6 items running across the top line? Why does it have to be so darn complicated? EXP-L Eve Industrial Organiser
Fubar Eagle Eye Inc.	Posted - 2009.05.19 12:46:00 - [35] Originally by: Sidrat Flush How do you know if Excel is using Bankers rounding and how do you stop it doing so? The round function in Excel workbooks uses the proper rounding method (Asymmetric Arithmetic Rounding or Round-Half-Up). The round function in Excel and Access VBA uses bankers rounding.
Sidrat Flush Caldari Life is Experience	Posted - 2009.05.19 13:45:00 - [36] Just got the numbers but they're reporting differently to what they should be presented as, I'm currently downloading the 1.2 apoc access datadump version to see if they've changed it again, if so and the numbers are correct as reported then I'll be able to figure out the formulaes for calculating waste. I've never added in a station modifier at all, and that'll be just a cell you enter 1 or 0 into, annoying though, as people may be building items at multiple stations with and without the bonus modifier. Thankfully it won't take too long to update the data I already have on the spreadsheet, at least I hope it won't. EXP-L Eve Industrial Organiser
Sidrat Flush Caldari Life is Experience	Posted - 2009.05.19 17:32:00 - [37] Select Distinct helped. It would be very very useful if it could be turned into a crosstable query with the activity 1 and 6 materials side by side That way the formulae becomes activity 1+(activity 6+waste), where all the waste requirements are calculated by activity 6 amount. But I'm sure that's not right? EXP-L Eve Industrial Organiser
Sidrat Flush Caldari Life is Experience	Posted - 2009.05.19 18:29:00 - [38] Yeah!! done it in a crosstable query. Just so that I know, the waste calculation is applied to the activity 6 numbers if they're the same or below the Activity 1 numbers, if activity 6 is higher than what do we do? Should I assume that activity 6 is present in all cases? What a pita. EXP-L Eve Industrial Organiser
Knitted Character	Posted - 2009.05.21 16:08:00 - [39] Originally by: Sidrat Flush Yeah!! done it in a crosstable query. Just so that I know, the waste calculation is applied to the activity 6 numbers if they're the same or below the Activity 1 numbers, if activity 6 is higher than what do we do? Should I assume that activity 6 is present in all cases? What a pita. I don't think you need to do anything. Activity 6 will be greater than activity 1 for Tech 2 items most of the time, since you need to factor in the tech 1 item materials that go into the Tech 2 item as a component. EG - it takes 194 Tritanium to make a Gyrostabilizer II (with 0 waste). If you reprocess a Gyrostabilizer II you'll get 194 Tritanium PLUS the 696 Tritanium from the Gyrostabilizer I used in it's creation. For the Gyro II, the activity 1 value for material 34 (Trit) is 194, but the activity 6 value is 890 (194+696).
Shawn Gallentino	Posted - 2009.05.24 15:05:00 - [40] Than you fubar

Sidrat Flush Caldari Life is Experience	Posted - 2009.05.25 07:57:00 - [41] Originally by: Knitted Character Originally by: Sidrat Flush Yeah!! done it in a crosstable query. Just so that I know, the waste calculation is applied to the activity 6 numbers if they're the same or below the Activity 1 numbers, if activity 6 is higher than what do we do? Should I assume that activity 6 is present in all cases? What a pita. I don't think you need to do anything. Activity 6 will be greater than activity 1 for Tech 2 items most of the time, since you need to factor in the tech 1 item materials that go into the Tech 2 item as a component. EG - it takes 194 Tritanium to make a Gyrostabilizer II (with 0 waste). If you reprocess a Gyrostabilizer II you'll get 194 Tritanium PLUS the 696 Tritanium from the Gyrostabilizer I used in it's creation. For the Gyro II, the activity 1 value for material 34 (Trit) is 194, but the activity 6 value is 890 (194+696). When it comes to manufacturing however, it's only applied IF activity6<=activity 1,(equal to or less than) otherwise, it's the normal calculation for waste (where waste is applied of course) - not on t1 items as part of the t2 ingredient. What I'm wondering though is what do you do with negative activity 1 numbers, ahhh but of course, that would be the units required to make the T1 ingredient right, and NOT what you get out of the t2 item when refining (activity 6). EXP-L Eve Industrial Organiser


Pages: 1 [2] :: 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.