# Capital Ore Calculator

**URL:** <https://forums.eveonline.com/t/capital-ore-calculator/32191>\
**Category:** Science & Industry\
**Created:** [October 17, 2017, 7:50pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191 "2017-10-17T19:50:21Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![le\_mediateur](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/le_mediateur/32/31103_2.png) [@le\_mediateur](https://forums.eveonline.com/u/le_mediateur)\
**Post date:** [October 17, 2017, 7:50pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/1 "2017-10-17T19:50:22Z")

</div>

Hey Hey

Maybe asking the impossible but

Im trying to work out the most efficient way to mine the roids that i need minerals for

Is there such a programme that tells you the precise amounts of ore required if the minerals are  
inputted for e.g.

If i entered 54m trit, 6.6m pyerite, 1.2m mex, 500k isogen etc etc.

The programme would tell me that the optimal ores i need to mine would be for e.g. 1000 spod, 500 bistot, 199, arkonor etc etc ??

Thanks

---

<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:** [October 18, 2017, 9:03am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/2 "2017-10-18T09:03:39Z")

</div>

It is quite simple, each batch of 100 units of the ore (or 1 Compressed) yield Specific amounts of minerals, for example a Batch of Spodumain (as per ‘Show Info’) will yield:

Tritanium (56000 Units)  
Pyerite (12050 Units)  
Mexallon (2100 Units)  
Isogen (450 Units)

So with this information you just need to factor in your Repocessing Yield, lets say it is 85%, then you just multiply the yield by 0.85 and you will know how much you will receive per batch:

Tritanium (47600 Units)  
Pyerite (10242 Units)  
Mexallon (1785 Units)  
Isogen (382 Units)

So now that you know how much you get per batch of Spodumain you can easily calculate how much of it you need to mine by: ‘Minerals needed’ / ‘Minerals from reprocessing’ = ‘number of batches’ \* 100 = units of Spodumain you need to mine to achieve your required minerals.

As a source to figure out which ores to mine to get specific minerals, you can use this 3rd party website [here](https://www.fuzzwork.co.uk/ore/)

---

<div class="post-metadata">

**Author:** ![PJHustle](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/pjhustle/32/387181_2.png) [@PJHustle](https://forums.eveonline.com/u/PJHustle)\
**Post date:** [November 13, 2017, 7:10pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/3 "2017-11-13T19:10:08Z")

</div>

I don’t think that the response above is hitting what the OP was asking for. I have a spreadsheet that utilizes a google sheet add-on called Linear Optimization. You tell the config sheet what you need and what each ore gives you it then can calculate the best way to get to the required materials. There is some tweaking you need to do in order to get the minimal waste product but I have been working on this sheet for a few days and I am happy with the outcome.

I will help you create your own sheet if this is what you are referring to in your post. I have it so you can choose a ship (Capital or T1) and that references my database on build materials, sums it all up after calculating the ME level on the BP’s and dumps the required totals of minerals. You then go to the calculations page (Linear Optimization) and it will then tell you how many units of compressed ores you need to reach your goal.

If this is something you are after I will help create it with you from the information I have forged together on my sheet. I would just give you mine but it is not the most user friendly and may layouts are often disliked 🙂

---

<div class="post-metadata">

**Author:** ![le\_mediateur](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/le_mediateur/32/31103_2.png) [@le\_mediateur](https://forums.eveonline.com/u/le_mediateur)\
**Post date:** [November 24, 2017, 6:00pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/4 "2017-11-24T18:00:10Z")

</div>

Hey. Yes that is exactly what i’m looking for and a bonus that it covers Capital construction and differing ME levels.

I hope you can get in touch

Tnx

---

<div class="post-metadata">

**Author:** ![Sgt\_Ocker](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/sgt_ocker/32/270881_2.png) [@Sgt\_Ocker](https://forums.eveonline.com/u/Sgt_Ocker)\
**Post date:** [November 25, 2017, 2:43am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/5 "2017-11-25T02:43:57Z")

</div>

Try this [https://www.fuzzwork.co.uk/compression/](https://www.fuzzwork.co.uk/compression/) from the same site mentioned by ISD Sakimura but it actually does what you were asking.  
Combine it with [https://docs.google.com/spreadsheets/d/11auy5dot-MjzwQWSNNPJ\_vzI5ajEv1ENOj-pZGBIObk/edit#gid=1841696236](https://docs.google.com/spreadsheets/d/11auy5dot-MjzwQWSNNPJ_vzI5ajEv1ENOj-pZGBIObk/edit#gid=1841696236) and you’re good to go…

---

<div class="post-metadata">

**Author:** ![le\_mediateur](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/le_mediateur/32/31103_2.png) [@le\_mediateur](https://forums.eveonline.com/u/le_mediateur)\
**Post date:** [November 25, 2017, 7:50am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/6 "2017-11-25T07:50:31Z")

</div>

I tested the fuzzwork site by asking for 100000 Trit and it came back suggesting i mine crokite??? Not sure that right LOL and the google spreadsheet wants me to request permissions…

---

<div class="post-metadata">

**Author:** ![le\_mediateur](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/le_mediateur/32/31103_2.png) [@le\_mediateur](https://forums.eveonline.com/u/le_mediateur)\
**Post date:** [November 25, 2017, 7:51am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/7 "2017-11-25T07:51:46Z")

</div>

PJHustle knows what i need by the looks of his answer

---

<div class="post-metadata">

**Author:** ![Betty\_Blap](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/betty_blap/32/148237_2.png) [@Betty\_Blap](https://forums.eveonline.com/u/Betty_Blap)\
**Post date:** [November 26, 2017, 5:52am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/8 "2017-11-26T05:52:23Z")

</div>

> **[Shared Compression Calculator](https://docs.google.com/spreadsheets/d/1LtLuTepdErjrsExI0UWgN3TjldSfFyEkxHjz7X7z0HY/edit?usp=sharing)**
>
> Input
> 
> 
> Tritanium, 100. 00, How to:
> Pyerite, 100. 00, 1-, Input the Minerals you need into the cells to the right.
> Mexallon, 100. 00, 2-, Go to the Liner Optimization Page
> Isogen, 100. 00, 3-, Under Add-ons, click Solve; Make you installed the...

Gives you the cheapest compressed ores to get the best refine for your target minerals

---

<div class="post-metadata">

**Author:** ![Sgt\_Ocker](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/sgt_ocker/32/270881_2.png) [@Sgt\_Ocker](https://forums.eveonline.com/u/Sgt_Ocker)\
**Post date:** [November 26, 2017, 8:59am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/9 "2017-11-26T08:59:05Z")

</div>

you can adjust the fuzzwork calculator by changing how much extra you want. It will then default to “better value” ores.

As for the spreadsheet. If you want to contact me in game I will give you a direct link to the one i use. No permissions needed.

---

<div class="post-metadata">

**Author:** ![von\_Susla](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/von_susla/32/227774_2.png) [@von\_Susla](https://forums.eveonline.com/u/von_Susla)\
**Post date:** [December 26, 2017, 9:53am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/10 "2017-12-26T09:53:24Z")

</div>

wrote for myself  
[https://forest-tales.tk](https://forest-tales.tk)  
allows not only set minerals but also choose items to build and select allowed for using ores

---

<div class="post-metadata">

**Author:** ![Astra\_Roux](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/astra_roux/32/185974_2.png) [@Astra\_Roux](https://forums.eveonline.com/u/Astra_Roux)\
**Post date:** [January 6, 2018, 5:50am UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/11 "2018-01-06T05:50:01Z")

</div>

does [https://forest-tales.tk](https://forest-tales.tk) calculate the best ore to buy? Eg: compressed Veldspar vs Compressed Arkonor because it’s cheaper to buy the velspar?

---

<div class="post-metadata">

**Author:** ![von\_Susla](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/von_susla/32/227774_2.png) [@von\_Susla](https://forums.eveonline.com/u/von_Susla)\
**Post date:** [January 6, 2018, 1:32pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/12 "2018-01-06T13:32:11Z")

</div>

It optimizes result by the lowest cost (At least I think it so)

---

<div class="post-metadata">

**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\
**Post date:** [January 6, 2018, 6:28pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/13 "2018-01-06T18:28:53Z")

</div>

@betty_blap

Thanks for a great tool.

Is this instruction correct? 6- Paste into E3 on this page   
I think it should be "Past into E2 on this page.

---

<div class="post-metadata">

**Author:** ![Ag3nt\_Jita](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ag3nt_jita/32/48115_2.png) [@Ag3nt\_Jita](https://forums.eveonline.com/u/Ag3nt_Jita)\
**Post date:** [January 6, 2018, 6:31pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/14 "2018-01-06T18:31:06Z")

</div>

There was a program called mining\_optimizer that i used in the past. It does what you need dude

---

<div class="post-metadata">

**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\
**Post date:** [January 17, 2018, 5:31pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/15 "2018-01-17T17:31:47Z")

</div>

@Betty_Blap

Thanks for the pointer to this tool. Very powerful. Did you right it?

Please confirm one thing…on the “Output M3” tab is the value in Column A the amount of Column B required to satisfy the requested amount of minerals?

Eg. I ran for 350M Tritanium…Column A is 1,018,593 and Column B is Compressed Dense Veldspar.

---

<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:** [April 17, 2018, 5:32pm UTC](https://forums.eveonline.com/t/capital-ore-calculator/32191/16 "2018-04-17T17:32:33Z")

</div>

Closed on April 17, 2018, 5:32pm UTC

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