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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Some Maths questions!

First post
Author
Previous Topic Next Topic
CJ Alland
CB Trading
#1 - 2015-01-04 17:24:11 UTC
I need to get my spreadsheet to do the same calculations this page does https://www.fuzzwork.co.uk/compression/

http://i.gyazo.com/dd8c779257b4a2f0c2e0727c60f8ad3a.png

I have the high sec compressed ore and now I just need to make a formula to dictate which compressed ore to buy to meet the requirements, in this case I made it 5,000,000 Trit and 1,000,000 Pyerite

Anyone got any ideas?
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#2 - 2015-01-04 18:18:43 UTC
idea #1

post in science and industry

@JerryTPepridge
CJ Alland
CB Trading
#3 - 2015-01-04 19:10:15 UTC
uh, but it's sooo far.... Forum, admin! ^^^^
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-01-04 19:39:02 UTC
Hi :)

This is, basically, the Diet problem, for linear programming.

http://googledevelopers.blogspot.co.uk/2014/09/sudoku-linear-optimization-and-ten-cent.html

Your constraints are the various mineral types. With a lower bound of the quantity of the mineral you want.

Your variables are the various ore types.

You want to minimize the objective coefficient (that's the volume of the ore type)

The type of variable is an Integer. (so you don't get 0.5 units of compressed ore)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
CJ Alland
CB Trading
#5 - 2015-01-04 20:10:14 UTC
Steve Ronuken wrote:
Hi :)

This is, basically, the Diet problem, for linear programming.

http://googledevelopers.blogspot.co.uk/2014/09/sudoku-linear-optimization-and-ten-cent.html

Your constraints are the various mineral types. With a lower bound of the quantity of the mineral you want.

Your variables are the various ore types.

You want to minimize the objective coefficient (that's the volume of the ore type)

The type of variable is an Integer. (so you don't get 0.5 units of compressed ore)



Yeah, I still have no idea what I'm doing with all these different options.

I understands what you are staying just have no idea how to set it up :(
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2015-01-04 20:22:33 UTC
I'll see about putting together a example (at some point. ugg. data entry).

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Hel O'Ween
Men On A Mission
#7 - 2015-01-05 16:16:18 UTC
CJ Alland wrote:
uh, but it's sooo far.... Forum, admin! ^^^^


Hint: reporting your own post and asking to have it moved to the appropriate forum is a viable and suggested solution to your dilemma.

EVEWalletAware - an offline wallet manager.
Mireilee Aldes
Viziam
Amarr Empire
#8 - 2015-01-06 00:19:45 UTC  |  Edited by: Mireilee Aldes
Once you have your spreadsheet set with all mineral values of the ores, you have to sit and think: what is the lowest bound on each ore? In this case what i mean is "what mineral is unique to what ore and we will define those minerals first" For example: i need 1000 of trit, 600 pye, 400 mex, 200 iso, 100, noc for whatever reason. First I look at noc: i need 100 of them. Lets say with my refining skills i need 100/105/110 units of pyroxeres to get 100 noc. But having those 100/105/110 units also gives x trit, y pye, z mex which we subtract from each total of 1000/600/400. Now into isogen: its only in kernite and i need 200 units of isogen. Find out how many units of kernite i need and all other minerals from kernite get subtracted from original need. Need pyerite? Optimize scordite. Need Trit? Optimize Veldspar.

Hope this helps!
Argent Rotineque
The Scope
Gallente Federation
#9 - 2015-01-06 16:11:09 UTC
Most spreadsheet programs have a problem solver that will automate these (though because of the nature of these tools they must be run each time an input changes). Excel's is an add-in called solver, I'd suggest running through a simple scenario first. The tricky part is learning how to input the constraints to get the output you want (usually cost or space).