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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

I must be doing something wrong
Author
Previous Topic Next Topic
Darryn Lowe
Sebiestor Tribe
Minmatar Republic
#1 - 2014-04-04 00:31:59 UTC
I have a spreadsheet I built myself to allow me to quickly see what I need for manufacturing in terms of minerals and how much ore I need to mine to get said minerals. Standard stuff and has worked out for me reasonably bang on.

However, I've duplicated it and modified the duplicate with all the new details of ore and yields and I'm finding that instead of losing minerals I'm gaining them.

If it actually works out this way in game then the new refining changes are going to work out but if not then what am I doing wrong?

Here's the link for the existing details:

https://www.icloud.com/iw/#numbers/BAKr8fJRTYyNgIKmFaGBz4WK23KvSuHd2iOF/Eve_Mining_Calculator_Old_Details_-_Darryn_Lowe

Here's the link for the new details:

https://www.icloud.com/iw/#numbers/BAJSOIRFMOucJjg8ZdmBJpWscz_rbOWmjSGF/Eve_Mining_Calculator_New_Details_-_Darryn_Lowe

And before you start it's got nothing to do with using Numbers. Blink
Nhanderu Mbaekuaa
Tribal Liberation Force
Minmatar Republic
#2 - 2014-04-04 01:29:25 UTC
In the Blueprints page, lines "needed" and "ore to be mined", how is it that for Pyerite the "to be Miined" is less than "Needed", but for Isogen in is more?
Darryn Lowe
Sebiestor Tribe
Minmatar Republic
#3 - 2014-04-04 01:51:28 UTC
Nhanderu Mbaekuaa wrote:
In the Blueprints page, lines "needed" and "ore to be mined", how is it that for Pyerite the "to be Miined" is less than "Needed", but for Isogen in is more?


You get more Pyerite from Scordite than you do Isogen from Omber? You need 333 units of Scordite to refine but you need 500 units of Omber to refine.
Nevyn Auscent
Broke Sauce
#4 - 2014-04-04 02:44:01 UTC
I haven't looked, but have you accounted for the fact they are also changing the volume of the ore per refining unit?
Darryn Lowe
Sebiestor Tribe
Minmatar Republic
#5 - 2014-04-04 07:08:56 UTC
Nevyn Auscent wrote:
I haven't looked, but have you accounted for the fact they are also changing the volume of the ore per refining unit?

Yep, it's in the Refining workbook.
Nhanderu Mbaekuaa
Tribal Liberation Force
Minmatar Republic
#6 - 2014-04-04 12:22:21 UTC
Darryn Lowe wrote:
Nhanderu Mbaekuaa wrote:
In the Blueprints page, lines "needed" and "ore to be mined", how is it that for Pyerite the "to be Miined" is less than "Needed", but for Isogen in is more?


You get more Pyerite from Scordite than you do Isogen from Omber? You need 333 units of Scordite to refine but you need 500 units of Omber to refine.


Ah, ok... the relationship between minerals and primary ores is not very explicit in that part of the sheet.
Darryn Lowe
Sebiestor Tribe
Minmatar Republic
#7 - 2014-04-04 18:41:43 UTC  |  Edited by: Darryn Lowe
No worries. As I said it was largely for my own use so I kind of worked it for me. The totals in the Blueprints come from the refining and mineral totals and worked from there.

The green bits are all the places where I need to manually enter something just in case you hadn't already worked it out.

I did notice that in the old sheet I had a problem with Omber in that for some reason it was a manual entry in the Station Totals. That's been fixed now.

Like I say, if my results are actually intended then I don't think we miners/refiners have a whole lot to worry about.