These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Post Crius reduction in materials math question

First post
Author
Previous Topic Next Topic
Lustful God
Perihelion Logistica
Olde Guarde Historical Preservation Society
#1 - 2015-02-21 17:56:53 UTC
I've been building my own spreadsheet to calculate my needs as a cap builder, however, as a friend is also using my sheet but has different ME prints, I was working on trying to create a variable system that I could just select the ME from a drop down menu and it would calculate the proper number of materials required.

The only problem im running into is with hull prints where there may only be 8 or 9 required units to build off an unresearched print. In this instance I get a rounding error that decrement the number of units required correctly.

The equation that im using came from a PDF I'd found a while back and is:

ceiling(round(Base material required * Research Modifier),2),1)

If you've got input on this, feel free to help me or PM me if need be.

Thanks in advance
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-02-21 18:25:11 UTC
https://www.fuzzwork.co.uk/blueprint/ Blink

Anyway:

Materials have a floor of one per run. You cannot reduce it below that. (so you'll want to wrap a material calculation in a max(runs,everything else)

Materials at increased to the next whole integer at the job level, rather than at the run level.
i.e. one run takes 1.1, so you have to use 2. A job of 10 runs takes 11, rather than 20.

Each modifier is multiplied in, rather than added, then multiplied.

So, building in a POS, with a 2% reduction, on a ME 10 blueprint, would be a 0.882 multiplier, rather than a 0.88 multiplier.


So you know, the reason for the round, then the ceil, is to get round a nasty little floating point math error, which occasionally leads to a number coming out at X.000000000000000001, where it should just be X. ceil would then take it to X+1, rather than X.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter