Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Barrett Wynn
Garoun Investment Bank Gallente Federation
0
|
Posted - 2015.10.14 17:36:05 -
[1] - Quote
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.
|
Hochopepa
POS Consultants Group LLC
9
|
Posted - 2015.10.14 17:38:56 -
[2] - Quote
Check here: Formulae for industry
so, what it should look like is:
required = max(runs, ceil(round(runs Gêù baseQuantity Gêù (ME Modifier * Installation Modifier), 2)) |
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1670
|
Posted - 2015.10.14 17:58:01 -
[3] - Quote
Spreadsheets suck!
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Barrett Wynn
Garoun Investment Bank Gallente Federation
0
|
Posted - 2015.10.14 17:58:53 -
[4] - Quote
Hochopepa wrote:Check here: Formulae for industryso, what it should look like is: required = max(runs, ceil(round(runs Gêù baseQuantity Gêù (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
Garoun Investment Bank Gallente Federation
0
|
Posted - 2015.10.14 18:00:45 -
[5] - Quote
Zifrian wrote:Spreadsheets suck!
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
5629
|
Posted - 2015.10.14 18:35:57 -
[6] - Quote
Barrett Wynn wrote:Hochopepa wrote:Check here: Formulae for industryso, what it should look like is: required = max(runs, ceil(round(runs Gêù baseQuantity Gêù (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 X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Hochopepa
POS Consultants Group LLC
9
|
Posted - 2015.10.14 18:52:34 -
[7] - Quote
Steve Ronuken wrote:Barrett Wynn wrote:Hochopepa wrote:Check here: Formulae for industryso, what it should look like is: required = max(runs, ceil(round(runs Gêù baseQuantity Gêù (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
Garoun Investment Bank Gallente Federation
0
|
Posted - 2015.10.14 19:12:32 -
[8] - Quote
Steve Ronuken wrote:Barrett Wynn wrote:Hochopepa wrote:Check here: Formulae for industryso, what it should look like is: required = max(runs, ceil(round(runs Gêù baseQuantity Gêù (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
Mechanical Engineers
14
|
Posted - 2015.10.15 12:56:27 -
[9] - Quote
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
Radical Astronauts Plundering Eve WormHole Occupation and Resource Exploitation
0
|
Posted - 2015.10.16 03:43:42 -
[10] - Quote
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.
Don't have a bad day, stay on the trigger side of the pew.
|
|
Barrett Wynn
Garoun Investment Bank Gallente Federation
0
|
Posted - 2015.10.16 09:34:07 -
[11] - Quote
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
Radical Astronauts Plundering Eve WormHole Occupation and Resource Exploitation
0
|
Posted - 2015.10.16 13:19:27 -
[12] - Quote
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.
Don't have a bad day, stay on the trigger side of the pew.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |