PDA

View Full Version : Mineral Compression



Mea
April 13 2011, 04:32:44 PM
Just leaving this here.

A spreadsheet i was working on for minera compression, you type in the minerals needed, run the solver plug in and it gives you how much of which item you need to build.

I didnt have a chance to use it since im just a grunt on my current alliance (Anyone need sort of an indy player? haha). Anyway, should be mostly accurate giving me rates of compression of about 90-95%.

Props go to whoever it was that did mineral compression, i stole his table of items and went from there

Anyway, here it is:
Any questions or comments feel free to do so

http://www.mediafire.com/?n29yenv11d6mvk0

Helen
April 13 2011, 05:40:15 PM
I'll check this out thanks.

Sponk
April 13 2011, 11:09:21 PM
needs more google docs.

Mea
April 14 2011, 06:19:57 AM
http://lmgtfy.com/?q=import+excel+google+docs

Sponk
April 14 2011, 06:32:06 AM
http://lmgtfy.com/?q=import+excel+google+docs
http://lmgtfy.com/?q=effort

Rudolf Miller
April 14 2011, 10:32:09 AM
:nostradamus:

Mea
April 14 2011, 06:16:04 PM
Wait, does google docs even have a solver?
Thats the whole reason to use this in excel tbh

kzig
May 2 2011, 08:45:56 PM
Props go to whoever it was that did mineral compression, i stole his table of items and went from there

That would be me. You're welcome - my means of compression have never been a secret. For free, I will also tell you that it is very seldom worth using anything else (ignoring items with identical volume & mineral content, e.g. Tachyons vs. 425s).

This is quite similar to how I started out, but I found that solver isn't really up to dealing with this particular problem. I would wager that given any compression scenario, I can match or beat whatever solver returns, in some cases by a considerable margin.

That said, I applaud the effort you've put into making the sheet and your sincerity in making it public.