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.
 

Ore Spreadsheet
Author
Previous Topic Next Topic
Kisara Anne Catal
Cerberus Acquisitions Group
#1 - 2013-07-01 03:19:01 UTC
o7 Can someone critique this spreadsheet I've made for ore profitability? It works based on the mineral value of each ore at perfect refine. Values are from Grismar's ore chart and have been updated to reflect the Odyssey changes to null ore. Isk/hour column is based on input values for m3/cycle, harvester numbers, and cycle times.

Linky
Del Monkan
Azure Nomads
#2 - 2013-07-01 09:25:03 UTC  |  Edited by: Del Monkan
Just had a quick look, you need to round the mineral yield on the +5% and +10% ore variants.

Is this spreadsheet for personal use only?

Current formula to calculate ISK/hour:

=((($C$51*$C$52)/3)*60)*N2
i.e
(((m3/cycle * harvesters) / 3) * 60) * isk/m3)
which is fine if you don't receive boosts where the laser optimisation link is run

If you change this to:

(((m3/cycle * harvesters) / cycle time) * 3600) * isk/m3)
=((($C$51*$C$52)/$C$53)*3600)*N2
It will give you the yield based on the cycle time as well...

The race is long, and in the end, it's only with your own inability to unsubscribe.
Kisara Anne Catal
Cerberus Acquisitions Group
#3 - 2013-07-01 16:52:46 UTC
Yes, it's mainly for personal use and the toon does not receive boosts. I'll add the formula you suggested so as to calculate based on boosts often found on my Nullsec toons. Thanks for the critique!
Cecil Oppenheimer
Uti Possidetis
#4 - 2013-07-03 02:46:12 UTC
Two comments:

You're assuming that the best profit is available from refining the ore. This isn't always so.

For example: Pyroxeres at Jita

Ore sale price per batch of 333 = 18k+

Minerals sale price for a refined batch = 9k+

You need to take the max of these 2 values as the basis of your ISK/hr calcs.

Tip: if you lookup all the ore and mineral prices you will exceed the 50 ImportXML limit per spreadsheet for Google docs. Put all your ore lookups on a separate sheet and refer to them using ImportRange function. You can then refer to the ore lookups sheet anytime for new projects.


Also, if you add a refresh statement to your price lookup, it will automatically refresh every minute.

E.g. =ImportXML("http://api.eve-central.com/api/marketstat?typeid="&TRIM(B10)&"&usesystem="&TRIM($E$1)&"&refresh="&GoogleClock(), "/evec_api/marketstat/type/sell/min")


CO
Ljuvi
#5 - 2013-07-08 06:40:42 UTC
Good work
Killandre Sylvain
Sebiestor Tribe
Minmatar Republic
#6 - 2013-07-10 09:56:02 UTC
Looks awesome. I have a similar spreadsheet that I wanted to get started for an ore buyback program for my corp. Just wanted to note that you can freeze the top and left column/row so that it doesn't move whne you scroll. That way you don't have to have the ore name on both the left and the right. It looks great though, and organized much better than the one I created for myself.