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.
 

Mineral to Ore calculator?

First post
Author
Previous Topic Next Topic
Nalera MowTow
MowTow Holdings
#1 - 2016-11-22 04:13:35 UTC
So I've been trying to build a spreadsheet that determines the cheapest way to reprocess a set of minerals from compressed ore, and I've realized that my excel foo isn't quite strong enough

Are there any tools out there that already do this? I've tried the compressed ore calculator on fuzzworks, but it only spits out least volume.
Or if there isnt one out there does anyone know how I could make one?

Thanks
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-11-22 12:55:47 UTC
You want to do some linear programming.

Look up the Diet problem. Ore compression, or what you want, is just a reworded version.

(Where the ore is the kind of food, and the nutrients are the the various minerals)

http://www.linearprogramming.info/diet-problem-in-linear-programming-solved-with-excel-solver/

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kousaka Otsu Shigure
#3 - 2016-11-22 16:28:27 UTC
...and thats why we voted you up Steve.

Thanks for the continued support of the community! :)

Archiver, Software Developer and Data Slave

Current Project Status: What can I make with these minerals?
Nalera MowTow
MowTow Holdings
#4 - 2016-11-23 04:09:51 UTC
Awesome! thats exactly what I was looking for, thanks for all the help. As well as all you other tools :)