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.
 

Manufacturing Formula for Excel Users - A bounty is offered.

First post
Author
Previous Topic Next Topic
Barrett Wynn
Eve Industrial Organiser
#1 - 2015-10-14 17:36:05 UTC  |  Edited by: Barrett Wynn
I would very much like to know what the proper format for the formula is.

In what order are the reductions calculated, are they stacked as in ME + Facility Efficiency or calculated with the ME reduction first or the Facility Efficiency first?

If anyone can provide a screen shot of a working excel formula with no rounding issues, Isk will very probably be involved.

Updated.

I've also noticed that when building items with the exact requirements I'm left with one or two units extra, that I needed to start the job, but wasn't used. I believe this is because the UI is displaying the rounded up whole number.

If it's not going to use the material it shouldn't be displayed or required to start a job.
Hochopepa
Creative Research and Production Services
#2 - 2015-10-14 17:38:56 UTC  |  Edited by: Hochopepa
Check here: Formulae for industry


so, what it should look like is:

required = max(runs, ceil(round(runs ∗ baseQuantity ∗ (ME Modifier * Installation Modifier), 2))
Zifrian
The Frog Pond
Ribbit.
#3 - 2015-10-14 17:58:01 UTC
Spreadsheets suck! P

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Barrett Wynn
Eve Industrial Organiser
#4 - 2015-10-14 17:58:53 UTC
Hochopepa wrote:
Check here: Formulae for industry


so, what it should look like is:

required = max(runs, ceil(round(runs ∗ baseQuantity ∗ (ME Modifier * Installation Modifier), 2))



That only ever gives me the result of 1 when applying the discount to tritanium for a Vexor ME 8 Facility Efficiency 5%.

You've also used ceiling and rounding but only expressed the precision for the round function.

There is also the issue of not subtracting the above result from the base quantity.
Barrett Wynn
Eve Industrial Organiser
#5 - 2015-10-14 18:00:45 UTC
Zifrian wrote:
Spreadsheets suck! P


Eve Isk Per hour is an option but the layout is far too busy for me to deal with. Hence the excel design preference.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2015-10-14 18:35:57 UTC  |  Edited by: Steve Ronuken
Barrett Wynn wrote:
Hochopepa wrote:
Check here: Formulae for industry


so, what it should look like is:

required = max(runs, ceil(round(runs ∗ baseQuantity ∗ (ME Modifier * Installation Modifier), 2))



That only ever gives me the result of 1 when applying the discount to tritanium for a Vexor ME 8 Facility Efficiency 5%.

You've also used ceiling and rounding but only expressed the precision for the round function.

There is also the issue of not subtracting the above result from the base quantity.




required = max(runs,ceiling(round(runs*(baseQuantity*ME Modifier*Installation Modifier),2),1))

So, for a Vexor, that would be a base of 622222

ME modifer of 0.92

Facility modifer of 0.95

=MAX(1,CEILING(ROUND(1*(622222*0.95*0.92),2),1))

Or 543823


(should be added, you save more, the more you make. normally)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Hochopepa
Creative Research and Production Services
#7 - 2015-10-14 18:52:34 UTC
Steve Ronuken wrote:
Barrett Wynn wrote:
Hochopepa wrote:
Check here: Formulae for industry


so, what it should look like is:

required = max(runs, ceil(round(runs ∗ baseQuantity ∗ (ME Modifier * Installation Modifier), 2))



That only ever gives me the result of 1 when applying the discount to tritanium for a Vexor ME 8 Facility Efficiency 5%.

You've also used ceiling and rounding but only expressed the precision for the round function.

There is also the issue of not subtracting the above result from the base quantity.




required = max(runs,ceiling(round(runs*(baseQuantity*ME Modifier*Installation Modifier),2),1))

So, for a Vexor, that would be a base of 622222

ME modifer of 0.92

Facility modifer of 0.95

=MAX(1,CEILING(ROUND(1*(622222*0.95*0.92),2),1))

Or 543823


(should be added, you save more, the more you make. normally)


Got to it before I did... doh!
Barrett Wynn
Eve Industrial Organiser
#8 - 2015-10-14 19:12:32 UTC
Steve Ronuken wrote:
Barrett Wynn wrote:
Hochopepa wrote:
Check here: Formulae for industry


so, what it should look like is:

required = max(runs, ceil(round(runs ∗ baseQuantity ∗ (ME Modifier * Installation Modifier), 2))



That only ever gives me the result of 1 when applying the discount to tritanium for a Vexor ME 8 Facility Efficiency 5%.

You've also used ceiling and rounding but only expressed the precision for the round function.

There is also the issue of not subtracting the above result from the base quantity.




required = max(runs,ceiling(round(runs*(baseQuantity*ME Modifier*Installation Modifier),2),1))

So, for a Vexor, that would be a base of 622222

ME modifer of 0.92

Facility modifer of 0.95

=MAX(1,CEILING(ROUND(1*(622222*0.95*0.92),2),1))

Or 543823


(should be added, you save more, the more you make. normally)



Winner!

My mistake was in not turning the 5% in to .95 etc. It is however now fixed and would like this thread stickied to enable more people to view the formula.
Thomas Lot
School of Applied Knowledge
Caldari State
#9 - 2015-10-15 12:56:27 UTC
No need to sticky this. Just throw some Isk at Steve and bookmark his site. Fuzzwork is one of the first sites I have up during a play session.
Vir Aurilen
The Scope
Gallente Federation
#10 - 2015-10-16 03:43:42 UTC
One thing worth adding. If you calculate mats by more than 1 unit per run remember to execute it as such otherwise parsing it up into smaller jobs when executing could mess up your mats requirements due to rounding differences.

“I think a lot of psychopaths are just geniuses who drove so fast that they lost control.”
Barrett Wynn
Eve Industrial Organiser
#11 - 2015-10-16 09:34:07 UTC
Vir Aurilen wrote:
One thing worth adding. If you calculate mats by more than 1 unit per run remember to execute it as such otherwise parsing it up into smaller jobs when executing could mess up your mats requirements due to rounding differences.


Yes I know where 1 unit is required there is no reduction.

Ram blueprints used to have a damage factor where x amount were required to start a job, however you'd get a few back due to not being 100% consumed in the process.

I have not as yet thrown some isk at the awesome Steve Ronuken, but I intend to and will.
Vir Aurilen
The Scope
Gallente Federation
#12 - 2015-10-16 13:19:27 UTC
Good. My recommendation is to plan small or individual batches at a time to give you plenty of flexibility when executing jobs especially when poses, multiple characters, and vertically integrated construction is involved. It will help you keep your sanity. Hope this helps folks.

“I think a lot of psychopaths are just geniuses who drove so fast that they lost control.”