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 [?]


Author	Thread Statistics \| Show CCP posts - 0 post(s)
Fubar Eagle Eye Inc.	Posted - 2009.02.20 14:36:00 - [1] Originally by: Akita T So where exactly in the database dump DO you find the attribute that says wether a material is "raw" or "extra" for each specific blueprint (or item) ? I only ask because I can't find it... or see it but don't realize it's that. An attribute does not exist but you can determine whether a material is raw or extra by examining table typeActivityMaterials in the data dump. The data we need to look at is activityID 1 for the blueprintTypeID and activity 6 for the productTypeID that the blueprint in question produces. A material is raw if the activity 6 qty is greater than or equal to the activty 1 qty. A material is extra if activity 6 does not exist for the activity 1 typeID. Ignore any activity 6 typeIDs that don't have an activity 1 counterpart. Now for the fun part.... In the case of bombs we have minerals that qualify as both raw and extra. Lets look at the Electron Bomb. blueprintTypeID=27921 productTypeID=27920. typeID=27921 activityID=1 requiredTypeactivityquantity Tritanium 1 1362069 Pyerite 1 623994 Mexallon 1 60231 Isogen 1 9381 Nocxium 1 2370 Zydrine 1 1419 Megacyte 1 365 typeID=27920 activityID=6 requiredTypeactivityquantity Tritanium 6 10000 Pyerite 6 100 Mexallon 6 10 Isogen 6 10 Nocxium 6 10 Zydrine 6 10 Megacyte 6 10 The activity 6 quantities are smaller than the activity 1 quantities. So the activity 6 quantity is classified as raw and the activity 1 quantity minus the activity 6 quantity is classifed as extra. For example... requireType Quantity Mineral Type Waste Applied? Tritanium 10000 Raw 1 Tritanium 1352069 Extra 0 Pyerite 100 Raw 1 Pyerite 623894 Extra 0 Mexallon 10 Raw 1 Mexallon 60221 Extra 0 Isogen 10 Raw 1 Isogen 9371 Extra 0 Nocxium 10 Raw 1 Nocxium 2360 Extra 0 Zydrine 10 Raw 1 Zydrine 1409 Extra 0 Megacyte 10 Raw 1 Megacyte 355 Extra 0 And in case you don't want to compile your own data here is mine. Fubars_Manufacturing_Data.csv Hope this helps.
Fubar Eagle Eye Inc.	Posted - 2009.02.20 15:04:00 - [2] Originally by: Pwett Edited by: Pwett on 20/02/2009 14:45:58 Back to the original mag stab II problem, there is no activityID 6 Sure there is no activityID 6 for id 10191 (the blueprint) but there is for id 10190 (the finished product). select * from typeActivityMaterials where (typeID = 10191 or typeID = 10190) and ( activityID = 1 OR activityID = 6) order by activityID 10191134227510 1019113535210 10191138210 1019113380500 1019113689510 1019119842210 1019119944111 10191111399310 10191111452100 10191111453100 1019111148310.150 10191111540510 10190634952010 10190635166510 10190638210 And then how about the Large Remote Armor Repair System II. bpID=26915 product=26914 select * from typeActivityMaterials where (typeID = 26915 or typeID = 26914) and ( activityID = 1 OR activityID = 6) order by activityID 2691513456610 2691513511510 2691513624410 269151373010 2691513380500 2691519848810 26915111359111 26915111399510 26915111442100 26915111452100 2691511147510.20 26915111539410 26914634445210 26914635304510 2691463624510 269146373010 26914611399510 26914611539410 Nanoelectrical Microprocessors are typeID 11539
Fubar Eagle Eye Inc.	Posted - 2009.03.27 15:24:00 - [3] Edited by: Fubar on 27/03/2009 15:26:59 Originally by: Kane Tabor So, here's the question: am I misunderstanding Fubar's formula, was it always wrong, or did Apocrypha change it? Basically it comes down to you can't trust the show info bill of materials. See Linkage. The picture shows the show info window next to the quote window. The bp does still requires 1363069 (1352069+10000+1000) of trit per batch on a ML0 bp. Edit: Corrected the last line.
Fubar Eagle Eye Inc.	Posted - 2009.04.28 11:06:00 - [4] Originally by: Epitrope How do you square this with types such as the Crystalline Carbonide Armor Plate (typeID 11545, blueprintTypeID 17323)? 11545 has no entries in the typeActivityMaterials table, but I can confirm that both of the types required to build it are affected by waste. Kane Tabor's idea of basing it on category 4 is good, and perhaps better than what I was doing (individually assigning all the composites to be base instead of extra), but I'm a little bit uncomfortable with just mangling the data like that. Good point. After you use the previous method you run an update query that updates the waste on the Construction Components and Advanced Capital Construction Components blueprints.
Fubar Eagle Eye Inc.	Posted - 2009.05.17 22:03:00 - [5] 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 - [6] 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
Fubar Eagle Eye Inc.	Posted - 2009.05.19 12:46:00 - [7] 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.

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.