# \[spread the sh¡t\] values of ore

**URL:** <https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089>\
**Category:** Mining & Extraction\
**Tags:** ore\
**Created:** [August 11, 2017, 1:11pm UTC](https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089 "2017-08-11T13:11:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![guigui\_lechat](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guigui_lechat/32/284497_2.png) [@guigui\_lechat](https://forums.eveonline.com/u/guigui_lechat)\
**Post date:** [August 11, 2017, 1:11pm UTC](https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089/1 "2017-08-11T13:11:06Z")

</div>

Hello fellow capsuleers. I made a spreadsheet to check what are the ores worth mining, according to where you sell the stuff.

It gets BO/SO values from eve central and colors the cubic BO and cubic SO  
It lists every compressed/uncompressed variation of ore.  
Mercoxit is not considered for colors as its cubic extraction is different.  
Ice is not considered either, because I don’t want to.

Only Jita and amarr ATM, just change the region id cell if you want.

opendocumentformat : [https://www.dropbox.com/s/xxivzdghin4l4ko/ore.ods?dl=0](https://www.dropbox.com/s/xxivzdghin4l4ko/ore.ods?dl=0)  
excel : [https://www.dropbox.com/s/1eu8hm2l9zrnx6f/ore.xlsx?dl=0](https://www.dropbox.com/s/1eu8hm2l9zrnx6f/ore.xlsx?dl=0)

---

<div class="post-metadata">

**Author:** ![Donkyhotay](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/donkyhotay/32/176726_2.png) [@Donkyhotay](https://forums.eveonline.com/u/Donkyhotay)\
**Post date:** [August 11, 2017, 5:33pm UTC](https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089/2 "2017-08-11T17:33:34Z")

</div>

Nice, how do you get a spreadsheet to import data from eve central? I’ve been working on my own spreadsheet using libreoffice that calculates mining rates for me and being able to automatically include ore costs like yours does would be extremely useful and the online guides I found don’t seem to work. I could just merge them together but I’d prefer to understand how it’s done.

---

<div class="post-metadata">

**Author:** ![guigui\_lechat](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guigui_lechat/32/284497_2.png) [@guigui\_lechat](https://forums.eveonline.com/u/guigui_lechat)\
**Post date:** [August 11, 2017, 7:04pm UTC](https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089/3 "2017-08-11T19:04:21Z")

</div>

loot at the formula in the tables. It’s pretty simple once you understand. I would spend more time explaining than you trying to understand and that’s not the subject of the topic. basically

- get region ID and items id
- make a request to evecentral in a cell
- for each id, get the corresponding line in the cell.

---

<div class="post-metadata">

**Author:** ![guigui\_lechat](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/guigui_lechat/32/284497_2.png) [@guigui\_lechat](https://forums.eveonline.com/u/guigui_lechat)\
**Post date:** [August 11, 2017, 7:21pm UTC](https://forums.eveonline.com/t/spread-the-sh-t-values-of-ore/16089/4 "2017-08-11T19:21:14Z")

</div>

> **[Importing price data into spreadsheets - Fuzzwork Enterprises](https://www.fuzzwork.co.uk/2013/06/22/importing-price-data-into-spreadsheets/)**
>
> Importing up to date price data into your spreadsheets is a large part of being a successful manufacturer or trader in Eve online. Some bypass it by using tools, but the tolls will still have to do it. I’ve posted about how to load the data from eve...