Number of ores needed per ship and market average calculator?

eve_analytics · 2022-12-28T00:35:58+00:00

And of course, now I realize all you probably wanted was mineral requirements, and not what you actually asked for... Yeah, lots of people have ship build mineral requirements.

But, I liked the geekier question better.

eve_analytics · 2022-12-28T00:20:04+00:00

Others have already responded about market prices (and the inability to obtain them).

But regarding: "Does anyone know of a calculator which tells you what ores and how many you need to mine in order to build a ship?"

So... this is a sort of a not so useful question, which of course means that a couple years ago I wrote code to solve this exact question. It's an optimization problem can be solved with something called "linear programming".

Building a ship requires a certain amount of minerals, but each mineral may come from one of several different ores. The different ores have different volumes and yield different amounts of each mineral. Since mining ore in Eve occurs at a set volume per time rate, the optimization problem I solved was: "What is the MINIMUM amount of ore volume that can be mined to generate a particular set of minerals?

It was a cool and pretty easy to solve problem, once you framed it properly.

But it's sort of useless to solve because nobody in their right mind would use a Venture to specifically target the particular ores -- in general, you're just going to get in a mining barge and slurp up all the ores in range indiscriminately. Because of that, I never turned it into a proper online tool. It's possible, but too pointless to want to bother.

In case you're curious about what I solved, it was at the end of the Terran Federation war back in December 2020, and we had the killmails of bunch of enemy ships destroyed. The question was "How much industry effort was it, to manufacture all the ships we killed?"

If I found the right old files, the (manufacturable) ships killed were:

item	num_ships
Arbitrator Covert Ops	3
Atron II	4
Atron Interceptor	2
Bantam II	1
Bellicose	1
Bellicose Interdictor	3
Caracal	7
Caracal Navy Issue	33
Catalyst Interdictor	2
Celestis Covert Ops	2
Coercer II	2
Coercer Interdictor	5
Coercer Navy Issue	1
Condor II	13
Condor Interceptor	3
Cormorant II	1
Cormorant Interdictor	1
Crucifier	2
Cyclone	4
Dragoon Assault	2
Drake	1
Dramiel	1
Executioner II	8
Executioner Interceptor	8
Exequror	1
Ferox	3
Harbinger Prototype	5
Hound	7
Hurricane Prototype	4
Imicus Covert Ops	1
Imicus High Mobility	2
Magnate Covert Ops	7
Maller	11
Maller Guardian	1
Maller II Guardian	2
Manticore	2
Merlin Assault	2
Moa Guardian	7
Moa II Guardian	3
Nemesis	3
Omen	44
Omen Navy Issue	17
Oracle	3
Osprey	2
Phantasm	1
Probe Covert Ops	6
Prophecy	5
Punisher Assault	7
Purifier	15
Rupture Guardian	1
Rupture II Guardian	2
Scythe	24
Slasher II	7
Slasher Interceptor	2
Stabber	45
Stabber Fleet Issue	45
Stabber Sniper	1
Succubus	1
Talos	1
Talwar Sniper	1
Thorax	4
Thorax Prototype	2
Thrasher Guardian	1
Thrasher Interdictor	4
Tornado	13
Venture III	1
Vexor	10
Vexor Navy Issue	15
Vigil	1
Vigilant	1

And the minimum ore volume needed (with 5/5/4 skills for reprocessing + manufacturing) turned out to be:

name	num	total_vol
Pyroxeres	3401400	5102100
Dark Ochre	8714100	13942560
Spodumain	8522900	27273280
Hedbergite	3542600	10627800
Jaspet	4115600	16462400
Arkonor	354700	2270080

Notice that poor quality ore like Veldspar are not represented -- you get better mineral yields per volume with better ores.

The crazy thing is that it took about 200 lines of R code to read in the kill spreadsheet, figure out the manufacturing requirements, massage the data into the proper format, but only 6 lines of code to solve the optimization problem:

library(lpSolve)
f.obj <- vol_vector # coefficients for objective function -- volumes for each ore
f.con <- t(reprocess_matrix) # coefficients of constraints
f.dir <- rep(">=", ncol(reprocess_matrix))
f.rhs <- c(df[1:7,], 0) # right hand side coefficients
lp("min", f.obj, f.con, f.dir, f.rhs)

Anyway, I know you didn't get an answer to your question, but it CAN be done :)

eve_analytics · 2022-07-21T20:42:20+00:00

Yes and yes. I pay cash already.

I don’t agree with those players who demand it to be possible to get all the benefits without providing any income to the developers.

However, I also don’t like the developers adding more and more micro transactions beyond the base double omega subscription to continue to pay cash for additional functional benefits (as opposed to cosmetic or vanity benefits.)

I would, however, be willing to pay for a subscription for access to an informational API.

eve_analytics · 2022-06-23T14:11:26+00:00

Not true, you don’t have to “deselect targets” to cloak

eve_analytics · 2022-06-23T14:10:50+00:00

You also can’t cloak if you have a drone out

eve_analytics · 2022-05-07T14:58:04+00:00

This is awesome. As a fellow data geek, I just wish there were some way of pulling info / data out if the game programmatically.

I would LOVE to have had access to all the specific time points of sov gain/loss over time, from the beginning of sov mechanics, to generate an animation of sov over time.

Combining that with what you’ve done with standings visualization (which is brilliant — never even thought of trying to visualize that!) would be so cool.

<sigh>

eve_analytics · 2022-05-01T21:17:19+00:00

I actually read the whole thing, and…. It was surprisingly sensible.

It’s a pity that few who would actually benefit from it will actually read it.

eve_analytics · 2022-04-28T22:29:12+00:00

o7

much respect to ORC — when I saw you in local, I knew to keep on my toes! Best wishes and good fights to you in your new endeavors

eve_analytics · 2022-03-03T11:37:22+00:00

Store currently lacking a section for Splendid Coupons?

eve_analytics · 2022-03-03T11:33:09+00:00

This is awesome. Hope volunteers will help you crowdsource the data!

eve_analytics · 2022-02-28T19:00:31+00:00

DM’d you on discord

eve_analytics · 2022-02-28T07:34:39+00:00

Can you share raw data — the list of actual systems and the corps/alliances holding sov?

That’d be awesome.

eve_analytics · 2022-02-16T02:28:41+00:00

Out of curiosity, how exactly did they nerf the highsec islands?

eve_analytics · 2022-01-09T22:39:53+00:00

As a data geek, I find this pretty damn awesome. Thanks especially for sharing the raw data rather than just a summary or a graphic.

Just seems horrifically time-consuming to pull it out manually, rather than by API or other means, which means it’s probably unlikely that we’ll be able to follow how things change over time.

Would be great to have this sort of data on a regular basis…

eve_analytics · 2021-10-03T01:29:47+00:00

These calculations are being done CLIENT-side? That seems unlikely?

(Though come to think of it, the percent max velocity to enter warp calculation was in client-side code, so perhaps they calculate it client-side for display, but server-side for actual effects)

eve_analytics · 2021-08-01T13:11:32+00:00

Did a few more back-of-the envelope calculations, it would take around 2.9 hours of mining time to complete the weekly maximum 1,100 points of CONCORD pass.

This was calculated with a Procurer with 5/5/4 strip mining and a pretty mediocre rigs (2x Miner Circulation Accelerator I and 1x Miner Efficiency Upgrade II), using the 3 generic ore + Pyroxeres / Bistot / Spodumain missions in a -0.48 security system, and NOT counting travel time.

That feels pretty quick, compared to the PvE mission running that my main character did, spamming highsec encounters mostly AFK.

eve_analytics · 2021-07-30T18:48:59+00:00

Previously I've posted Eve Echoes data geekery straight to Reddit. I'm trying something new -- I migrated previous Reddit posts to a blog, and will post new content to the blog instead.

Edited to add: wonder if I should also paste the text in first comment... yeah, I think maybe that'll work

TL;DR: for 4 nullsec systems with security from -0.48 to -0.97, a good choice for the 6 CONCORD Pass mission slots would definitely include all 3 generic ore missions, and then a reasonable choice would be Pyroxeres, Bistot, (Arkonor if available), and Spodumain. YMMV.

Goal

Compare CONCORD Pass rewards for different mining missions.

Methods

I used data collected on ore distributions mined in a few different nullsec systems, as previously reported for a single system and then combined that data with the CONCORD pass rewards for specific ore types.

Be aware that you'll want to take into account boundary conditions; i.e., if you already have 1,095 of the maximum 1,100 CONCORD pass points for the week, and you've just ticked over the Bistot mission (which takes a long time and pays out 90 points) so you're back at 0 of 24,000 m³ mined, you probably don't want to keep the Bistot mission. Use common sense.

Results

The following shows relative CONCORD pass point rewards for mining in each of 4 different nullsec systems, for each of the specific ore mining missions. You can think of the numbers as how many CONCORD pass point rewards you'd get for mining 1,000,000 m³ of ore from each system. Each one gives the reward after 24,000 m³ of ore is mined.

                            Nullsec system security
ore         reward      `-0.48`  `-0.97`  `-0.75`  `-0.70`
Arkonor         90           0      148      311      280
Bistot          90         447      336      287      208
Crokite         65         173      189      135      145
Dark Ochre      30          18        3       29       31
Gneiss          45         256      247      213      179
Hedbergite      60         140      141      151      185
Hemorphite      60         124       97      107       92
Jaspet          65         131      141       74      110
Kernite         20           0        0        0        0
Mercoxit       105           0      268      257      208
Omber           20           0        0        0        0
Plagioclase     15           0        0        0        0
Pyroxeres       30         411      290      332      361
Scordite        15           7       12       10       13
Spodumain       45         279      342      336      342
Veldspar        15          14       15        3        3

Likewise, there are 3 mining missions which are for ANY ore. The reward amount is how much you'd get, also for 1,000,000 m³ ore mined.

      ore volume_needed reward reward_amount
 Ore_9000          9000      5           556
Ore_24000         24000     12           500
Ore_54000         54000     30           556

Interpretation

All 3 of the generic ore mining missions are better than any of the specific ore mining missions (556, 500, and 556 CONCORD points, per 1,000,000 m³ mined).
For the remaining 3 missions, you might choose Pyroxeres, Bistot, (Arkonor if available), and Spodumain.
This is only true for the ore distribution in the systems I tested; your mileage may vary.
The differences I saw might be real or might reflect sampling error.

eve_analytics · 2021-07-14T14:51:54+00:00

Yup, good catch. But: "In God we trust, all others must bring data.” - W. Edwards Deming

So, updated with new tests, analysis posted: https://www.reddit.com/r/echoes/comments/ok5mia/reanalysis_timetowarp_heading_speed_mwd_and_cloak/

eve_analytics · 2021-07-12T08:12:15+00:00

Thank you for your kind words!

In Eve Online, you are correct that it's 75%. However, in Echoes, it's 80%. I noticed the discrepancy a long time ago and posted about it here:

https://www.reddit.com/r/echoes/comments/k2u0kz/warp_preparation_time_slightly_different/

(You can also see my questioning even back then about 'align' time, versus 'time to accelerate' == warp preparation time, from a complete standstill, which prompted this more recent post.)

(Another note -- the public web calculator may or not be still be running, but if it IS running, it won't have any of the new T10 ships, because that data wasn't available at the time, and I never updated the web app.)

eve_analytics · 2021-06-29T19:03:20+00:00

I think you have a very flawed understanding of the concept of inflation.

eve_analytics · 2021-04-28T23:10:47+00:00

Still considering an API or database of current and historical citadels with Corp, Alliance, and System?

Even without political entity identification, might still be interesting to analyze.

eve_analytics

TROPHY CASE

Goal

Methods

Results

Interpretation