Pages: 1 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Wille Sanara
Zakarum Industries Exiliar Syndicate
12
|
Posted - 2015.01.02 20:36:36 -
[1] - Quote
Hi. I am still struggling with the material requirements in the new system. I am in need of a precise material calculation formula with all the variables and constants and where to find them. The formula I am currently using is from the Formulas of EVE industry sheet by Qoi and it says:
required = max(runs, ceil(round(runs *baseQuantity *materialModifier, 2))
where material modifier is BPO modifier*team modifier*installation modifier, i.e. for ME10 BPO its 0.9, for team with 3% reduction in ME its 0.97 and for most POS arrays installation material modifier is 0.98.
Can please someone tell me, if the formula is correct?Or is there some catch in the implementation of ceil and round function in google docs? If it is correct, then I am probably doing some mistakes in the baseQuantity. Can someone please kindly tell me where to take it from? Should I just view the BPO ingame and use the number? But BPOs ingame show already numbers influenced by skills and their location, right? Should I take numbers from EVEmon? From somewhere else? Currently the calculations I am doing are for some prints correct, for some prints they are not. Thank you very much good sirs
|
Velicitia
XS Tech
2677
|
Posted - 2015.01.02 21:05:04 -
[2] - Quote
Looks right, except for teams, which have been removed for the time being.
What are you taking as the "baseQuantity"?
One of the bitter points of a good bittervet is the realisation that all those SP don't really do much, and that the newbie is having much more fun with what little he has. - Tippia
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4631
|
Posted - 2015.01.02 21:10:26 -
[3] - Quote
https://www.fuzzwork.co.uk/dump/latest/industryActivityMaterials.xls.bz2 (7zip will uncompress this) contains all the materials needed for something (you'll want activityid 1)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Wille Sanara
Zakarum Industries Exiliar Syndicate
12
|
Posted - 2015.01.03 12:32:52 -
[4] - Quote
Yeah, teams are being removed, but some of them are still ingame. Anyway, while teams gone, I can just use material modifier equl to 1. For baseQuantity I am using the numbers from EVEmon. I look up the BPO, see materials needed and there are 2 columns: some general materials needed and material needed by the character selected. I use the general material needed, althought the material needed by my char are almost the same (very little difference). Can someone possibly explain me how my character can influence on its own materials needed? I think all skills now do not influence ME. Another problem is that those numbers from EVEmon do not correspond to numbers when I view BPO ingame :-[ Again, some little difference. Any idea why?
Thanks for link, Steve, but it seems your webpage is unavailable. Can someone confirm it please? I cannot open it. |
Velicitia
XS Tech
2680
|
Posted - 2015.01.03 13:26:42 -
[5] - Quote
OK, The evemon materials might not actually BE the base materials (i.e. it's calculating your needs based on skills, etc. already).
For example, the Atron ME10 / PE 20 with 5/5/5 skills (one run).
Material -- Initial Quantity per run -- Reduced Quantity -- Job Quantity Tritanium -- 20556 -- 18500.4 -- 18501 Pyerite -- 3889 -- 3500.1 -- 3501 Mexallon -- 2222 -- 1999.8 -- 2000 Isogen -- 278 -- 250.2 -- 251 Nocxium -- 56 -- 50.4 -- 51 Zydrine -- 6 -- 5.4 -- 6
"Initial Quantity" is the base materials "Reduced Quantity" is the exact need based on skills and BP ME. "Job Quantity" is what you actually need to use after running Ceil(reducedQty * runs); which in our case for Zydrine is Ceil (5.4*1) = Ceil(5.4) = 6.
confirming Steve's site works.
One of the bitter points of a good bittervet is the realisation that all those SP don't really do much, and that the newbie is having much more fun with what little he has. - Tippia
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4633
|
Posted - 2015.01.03 16:53:56 -
[6] - Quote
http://downforeveryoneorjustme.com/www.fuzzwork.co.uk
works for me. Haven't had any reported issues for several weeks.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Wille Sanara
Zakarum Industries Exiliar Syndicate
12
|
Posted - 2015.01.03 18:46:30 -
[7] - Quote
I am sorry, for some weird reason I am unable to connect to websites ending co.uk. Is it possible to view the mentioned file on any other webpage? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4633
|
Posted - 2015.01.03 18:54:20 -
[8] - Quote
Wille Sanara wrote:I am sorry, for some weird reason I am unable to connect to websites ending co.uk. Is it possible to view the mentioned file on any other webpage?
https://www.dropbox.com/s/79vb14r7u5mdqgw/industryActivityMaterials.xls.bz2?dl=0
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Wille Sanara
Zakarum Industries Exiliar Syndicate
12
|
Posted - 2015.01.03 19:05:10 -
[9] - Quote
Thank you very much. From the brief look it looks like it might be what I need. I wanted to check out mainly hybrid component material requirements, as I am building manufacturing sheets for those. It seems hybrid component manufacturing requirements are not listened in this document, for example typeIDs 29996 30002 30476 30464 30474 30470 (some hybrid components) are missing. Any idea where I might find the baseQuantity numbers for hybrid components? (I.e. how many fullerenes, ancient salvage etc do I need without any skills, ME, installation etc) |
Wille Sanara
Zakarum Industries Exiliar Syndicate
12
|
Posted - 2015.01.04 13:56:19 -
[10] - Quote
Problem hopefully solved - found a mistake in some legacy formulas in my sheets. Problem with UK pages not loading solved with change of DNS server. Thx everyone |
|
|
|
|
Pages: 1 :: [one page] |