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.
 

Compressed Ore Calculator?

First post
Author
Previous Topic Next Topic
Cy4n1d
Doomheim
#1 - 2017-02-12 04:50:46 UTC
Hi,

i search a Compressed Ore Calculator like the one from Fuzzwork but only for 0,0. Ore.

Anyone know a Site/Spreadsheet/Tool maybe?
Zappettet Krest
Science and Trade Institute
Caldari State
#2 - 2017-02-12 13:39:13 UTC
Hello Guys.

i search too.

Thx
Mark O'Helm
Fam. Zimin von Reizgenschwendt
#3 - 2017-02-16 23:59:58 UTC  |  Edited by: Mark O'Helm
Compressed ore gives the same amount of minerals then uncompressed ore.

But the compressed ore needs less cargo space the uncompressed ore or the minerals.

It's different with ice though . Even with max. refining skills, the ice-materials take less space then the compressed ice. At least that is the case for blue ice. Other ice maybe differ.

"Frauenversteher wissen, was Frauen wollen. Aber Frauen wollen keine Frauenversteher. Weil Frauenversteher wissen, was Frauen wollen." (Ein Single)

"Wirklich coolen Leuten ist es egal, ob sie cool sind." (Einer, dem es egal ist)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2017-02-17 12:54:55 UTC
What you want to do is build a spreadsheet using a linear programming solver.

Both excel and google sheets can do this.

Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Cy4n1d
Doomheim
#5 - 2017-02-18 12:54:05 UTC
Steve Ronuken wrote:
What you want to do is build a spreadsheet using a linear programming solver.

Both excel and google sheets can do this.

Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.


Thx for the help, after a short search i found some instructions for a spreadsheet.

Here the Link to the Instructions:

https://developers.google.com/optimization/lp/add-on
Perkin Warbeck
Higher Than Everest
#6 - 2017-02-24 22:42:41 UTC
Steve Ronuken wrote:
What you want to do is build a spreadsheet using a linear programming solver.

Both excel and google sheets can do this.

Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.



But what happens if you stopped paying attention to maths at age 15 and now its just too late to start again? I too would like to solve this mythical diet problem.
Mark O'Helm
Fam. Zimin von Reizgenschwendt
#7 - 2017-02-24 22:49:57 UTC
Perkin Warbeck wrote:
Steve Ronuken wrote:
What you want to do is build a spreadsheet using a linear programming solver.

Both excel and google sheets can do this.

Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.



But what happens if you stopped paying attention to maths at age 15 and now its just too late to start again? I too would like to solve this mythical diet problem.

There is no problem with compression. It's very helpful for ore ransport and it gives you the same amount of minerals trough reproccessing then normal ore.

Maybe that you cannot decompress it. But that is just a nitpic.

"Frauenversteher wissen, was Frauen wollen. Aber Frauen wollen keine Frauenversteher. Weil Frauenversteher wissen, was Frauen wollen." (Ein Single)

"Wirklich coolen Leuten ist es egal, ob sie cool sind." (Einer, dem es egal ist)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2017-02-24 23:40:45 UTC
Perkin Warbeck wrote:
Steve Ronuken wrote:
What you want to do is build a spreadsheet using a linear programming solver.

Both excel and google sheets can do this.

Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.



But what happens if you stopped paying attention to maths at age 15 and now its just too late to start again? I too would like to solve this mythical diet problem.



Literally:

Find a tutorial about the diet problem, in your chosen spreadsheet. follow it, but fill in ore details instead of food details.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mark O'Helm
Fam. Zimin von Reizgenschwendt
#9 - 2017-02-25 00:25:08 UTC
Steve Ronuken wrote:

Find a tutorial about the diet problem, in your chosen spreadsheet. follow it, but fill in ore details instead of food details.

I think, i miss something here. What exactly is the diet problem here?

"Frauenversteher wissen, was Frauen wollen. Aber Frauen wollen keine Frauenversteher. Weil Frauenversteher wissen, was Frauen wollen." (Ein Single)

"Wirklich coolen Leuten ist es egal, ob sie cool sind." (Einer, dem es egal ist)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#10 - 2017-02-25 01:15:08 UTC
Mark O'Helm wrote:
Steve Ronuken wrote:

Find a tutorial about the diet problem, in your chosen spreadsheet. follow it, but fill in ore details instead of food details.

I think, i miss something here. What exactly is the diet problem here?



The Stigler diet problem. https://en.wikipedia.org/wiki/Stigler_diet

It was someone trying to work out the cheapest diet, which had certain nutrient requirements. You have a list of foods which provide various nutrients in various amounts, for a price. You have requirements for those nutrients. Its solved to provide the lowest cost, which provides those nutrients.

https://docs.google.com/spreadsheets/d/1XWJLkAwch5GXAt_7zOFDcg8Wm8Xv29_8PWuuW15qmAE/edit#gid=0

is a sheet they have which can show it.

tbh, it's a bad example though, because they have it as continous (you'd want integer) and the objective coefficient is 1. you'd want that to be the volume of the compressed ore.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mark O'Helm
Fam. Zimin von Reizgenschwendt
#11 - 2017-02-25 04:05:01 UTC
Steve Ronuken wrote:
Mark O'Helm wrote:
Steve Ronuken wrote:

Find a tutorial about the diet problem, in your chosen spreadsheet. follow it, but fill in ore details instead of food details.

I think, i miss something here. What exactly is the diet problem here?



The Stigler diet problem. https://en.wikipedia.org/wiki/Stigler_diet

It was someone trying to work out the cheapest diet, which had certain nutrient requirements. You have a list of foods which provide various nutrients in various amounts, for a price. You have requirements for those nutrients. Its solved to provide the lowest cost, which provides those nutrients.

https://docs.google.com/spreadsheets/d/1XWJLkAwch5GXAt_7zOFDcg8Wm8Xv29_8PWuuW15qmAE/edit#gid=0

is a sheet they have which can show it.

tbh, it's a bad example though, because they have it as continous (you'd want integer) and the objective coefficient is 1. you'd want that to be the volume of the compressed ore.


I think, that i get now, what you are talking about. You want a more easy calculatable ore compressrate, like ice have, right?

"Frauenversteher wissen, was Frauen wollen. Aber Frauen wollen keine Frauenversteher. Weil Frauenversteher wissen, was Frauen wollen." (Ein Single)

"Wirklich coolen Leuten ist es egal, ob sie cool sind." (Einer, dem es egal ist)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#12 - 2017-02-25 15:26:11 UTC
_I_ don't, no.

After all, I've already implemented an ore compression calculator. It's just mine covers all ore, not just the 0.0 ore, as per the OP's request.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter