# Compressed Material Requirements

**URL:** <https://forums.eveonline.com/t/compressed-material-requirements/100861>\
**Category:** Science & Industry\
**Created:** [August 26, 2018, 12:53pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861 "2018-08-26T12:53:31Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gonzo\_Zirud](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gonzo_zirud/32/59092_2.png) [@Gonzo\_Zirud](https://forums.eveonline.com/u/Gonzo_Zirud)\
**Post date:** [August 26, 2018, 12:53pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/1 "2018-08-26T12:53:31Z")

</div>

I am looking to calculate in Excel the amount of compressed ore needed to fulfill X minerals.

It can be either null or high sec materials.

I know there is a method using solver but it might be beyond my knowledge to make it work on this scale.

I also know there are websites that can calculate this but want to add it to my spreadsheet for manufacturing,

Can any one help with this one?

---

<div class="post-metadata">

**Author:** ![Anderson\_Geten](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/anderson_geten/32/390041_2.png) [@Anderson\_Geten](https://forums.eveonline.com/u/Anderson_Geten)\
**Post date:** [August 26, 2018, 2:57pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/2 "2018-08-26T14:57:03Z")

</div>

lulwath ?

You want to know the optimum quantity of compressed ore to reprocess into X minerals, with lowest possible isk cost including hauling.  
In a spreadsheet ?  
Without a solver ?

Is that so ?

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [August 26, 2018, 3:43pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/3 "2018-08-26T15:43:38Z")

</div>

That will require very complex math with many variables, there are 16 types of Ore, 14 if you ignore Mercoxit and Veldspar, which each has 1-4 types of minerals, so 16 \* 4 = 64 (max) variables from the Ore alone, then you have the variables connected to your reprocessing yield which adds another 5 or so.

It would be fairly simple if you were only looking for 1 type of Mineral, but since you probably looking for it to be for all 7-8 types of minerals… well even with my high understanding of math, I would still not attempt this.

---

<div class="post-metadata">

**Author:** ![Giddy\_McFee](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/giddy_mcfee/32/375711_2.png) [@Giddy\_McFee](https://forums.eveonline.com/u/Giddy_McFee)\
**Post date:** [August 26, 2018, 4:19pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/4 "2018-08-26T16:19:37Z")

</div>

Is this what you need? [https://www.fuzzwork.co.uk/compression/](https://www.fuzzwork.co.uk/compression/)

Why create your own when it is already out there

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [August 26, 2018, 4:47pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/5 "2018-08-26T16:47:20Z")

</div>

> [@Giddy\_McFee](#):
>
> Is this what you need? [https://www.fuzzwork.co.uk/compression/](https://www.fuzzwork.co.uk/compression/)
> 
> Why create your own when it is already out there

It may be usable, but it does not try to minimize the excess minerals you will get, if you put in 25 million for all but Morphite, you will end up with more than 1 billion excess Tritanium, not to mention the rest that are in excess.

OP wanted to know the amount that would generate the least amount of excess minerals, or am I wrong @Gonzo_Zirud?

---

<div class="post-metadata">

**Author:** ![Gonzo\_Zirud](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gonzo_zirud/32/59092_2.png) [@Gonzo\_Zirud](https://forums.eveonline.com/u/Gonzo_Zirud)\
**Post date:** [August 26, 2018, 11:12pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/6 "2018-08-26T23:12:26Z")

</div>

Thanks, I want it in my spreadsheet so when calculating the build and buy requirements it gives me a total to purchase ideally with minimum wastage.

There are a few online websites but I would like to create it in excel to minimise the using / reliance of other tools

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [August 27, 2018, 10:50am UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/7 "2018-08-27T10:50:31Z")

</div>

It is possible but you will probably have to use a separate “sheet” for that (I’m not meaning a new document/file), you can use the “Problem Solver”, it’s not activated by default so you’ll have to activate it.

> How to activate Problem Solver in _MS Excel_  
> To activate _Problem Solver_ go to Options \> Add ins \> on right-hand side in the bottom you will see Administrate: Excel add-ins, click the “execute” (or what ever it says) \> in the dialog box that comes up tick in “Add-in Problem Solver” and press “Ok”

> ❕ **WARNING** ❕ - The Problem Solver may take a long time to find a solution.

you will need:

- A cell with your Reprocessing Yield %.
- A column with list of quantity of compressed ore you will need to achieve your requirements.
- A column with list of compressed ore types.
- A column with list of volume per unit.
- A cell calculating the total _volume_. (will be needed for the _Problem Solver_)
- A row with list of mineral types.
- A matrix with all the yields
- A row with list of required minerals.
- A row with list of excess minerals
- A cell that show total quantity of excess mineral (will be needed for _Problem Solver_)

Here is an example:

 ![058150c1feadabc0e334a4c0a5e67948](https://global.discourse-cdn.com/eveonline/original/3X/3/d/3d39ab1ea18a33fee4698e21f24516108e0ec167.png)

Now for the Problem Solver:

- Set Objective: A cell in the sheet.
- Set your goal (for objective), Max, Min or Specific Value.
- Set Adjustable Variable(s): can be one or more cells.
- Add your constraints.

Like here (sorry about the language, if you can’t read it):

 ![69b78aea36d6dbb8a194e21150f4038c_WithEnglishText](https://global.discourse-cdn.com/eveonline/original/3X/a/3/a3dc1110c45849f3f3eef8c185f4497b8f5325f0.png)

---

<div class="post-metadata">

**Author:** ![Gonzo\_Zirud](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gonzo_zirud/32/59092_2.png) [@Gonzo\_Zirud](https://forums.eveonline.com/u/Gonzo_Zirud)\
**Post date:** [August 27, 2018, 12:33pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/8 "2018-08-27T12:33:18Z")

</div>

With a little playing it worked perfectly, thanks for the guide it was really helpful.

No way would I have figured that out any time soon.

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [August 27, 2018, 2:55pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/9 "2018-08-27T14:55:22Z")

</div>

Happy it worked out for you, as you probably have guessed you can optimize it for:

- Minimizing the Excess Minerals. - _This is what I’ve use in the example_.
- Minimizing the Compressed Ore Volume
- Minimizing the Quantity of Compressed Ore.
- Minimizing the total Value of excess minerals - _This will need some additional row(s) for input and calculations_.

---

<div class="post-metadata">

**Author:** ![Anderson\_Geten](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/anderson_geten/32/390041_2.png) [@Anderson\_Geten](https://forums.eveonline.com/u/Anderson_Geten)\
**Post date:** [August 27, 2018, 9:20pm UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/10 "2018-08-27T21:20:07Z")

</div>

- minimize the total cost, including freight

that’s what he actually wants 😉

total\_cost = buycost\*(1+freighttax)+freightvolcost  
buycost = sum[ore] (quantity(ore) \* price(ore) )  
freightvolcost = sum[ore] (quantity(ore) \* vol(ore)) \* volprice

volprice is the price your freighter charges to move 1 m³  
freighttax is the collateral tax your freighter charges (eg 2%)

eg if you use [karkinos](https://www.karkinos.ga/courier_calculator) from jita to o-v, the freighttax is 0.015 and the volumic price is 420

basically you need two more columns, one for the price of the compressed ore, one for the volume, and a third cell for total price.

---

<div class="post-metadata">

**Author:** ![ham\_Norris](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ham_norris/32/468804_2.png) [@ham\_Norris](https://forums.eveonline.com/u/ham_Norris)\
**Post date:** [November 7, 2018, 4:20am UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/11 "2018-11-07T04:20:55Z")

</div>

Do you know of a Google sheet way of running a solver?

---

<div class="post-metadata">

**Author:** ![ISD\_Sakimura](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/isd_sakimura/32/382213_2.png) [@ISD\_Sakimura](https://forums.eveonline.com/u/ISD_Sakimura)\
**Post date:** [November 7, 2018, 5:13am UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/12 "2018-11-07T05:13:27Z")

</div>

> [@ham\_Norris](#):
>
> Do you know of a Google sheet way of running a solver?

Haven’t found a usefull way, yet.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [February 5, 2019, 5:13am UTC](https://forums.eveonline.com/t/compressed-material-requirements/100861/13 "2019-02-05T05:13:30Z")

</div>

Closed on February 5, 2019, 5:13am UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
