spotmarket Graph Sample

What’s data without some graphs? Here is a small snip of the graphing that is currently in the spotmarket project.

Data

Jumps
2016-01-13 to 2016-06-07
17,802,640 Rows

Kill
2016-01-13 to 2016-06-07
9,819,421 Rows

Graphs

Jumps in Trade Hubs

2016-06-06_trade_hubs

Jumps and NPC Activity in The Northern Regions

2016-06-06_world_war_bee

Gurista Ratting Rates

2016-06-06_guristas

NPC Universe Overview

2016-06-06_universe_kills

Outer Ring

First pass at a map using D3.js inspired by HelicityBoson at http://www.machine9.net/?p=1111.

2016-06-06_outer_ring

Advertisements

Empires of Eve

My copy of Empires of Eve arrived today so here are some unboxing shots. If you can get the hardcover edition, purchase it. The finish quality and artwork really stands out.


3 Months of Manufacturing Index Changes for Deklein

I’ve started to accumulate a decent amount of daily index data and have started to use it to look at larger trends. Here’s a snapshot of Deklein region over the past 97 days.

2014-10-28_deklein_manufac_index_changes


One Month of Nullsec Manufacturing Index Changes

tl;dr The amount of Nullsec manufacturing has increased from July 23rd to August 23rd.

The evolution towards independent, self-sustainable manufacturing in Nullsec is an area of high interest to me. I want trade and manufacturing hubs to develop beyond what we have today, but given the need to import materials for invention and Tech 2 production, I don’t see it happening given the current industrial framework.

I wanted to see if the steps taken in Crius were moving us in the right direction so I turned to my data. I’ve been recording the system Index data from the API on an almost daily basis so I joined this data with sovereignty data to see if Nullsec manufacturing has been increasing.

The top 50 corporations by sum of their production have shown an increase on average of 46%. The overall change for all corporations has been 114%.

The full table is available below with conditional formatting placed on a narrow band excluding outliers to better visualize the changes.

2014-08-26-one_month_manufac_index_changes_nullsec


Capital Production Paused

After waiting for a few research jobs to finish up, I tore down the Highsec research POS and consolidated all the materials used for capital production. I am not sure about the viability of Lowsec capital production with the upcoming changes in the Crius expansion slated for July 22nd.

Presently I have more questions than answers.

  1. How is the mandated refine differential between High-Low-Null going to affect build prices?
  2. Will Low-Null mining become a profession that can compete with ore import costs from Highsec?
  3. How will the general population buy capitals if the majority of them start to be delivered in sovereign Nullsec space?
  4. Are the logistics of moving compressed ore from Highsec into Low-Null going to be worth the ::effort::?
  5. Will capital prices eventually trend upward due to the lack of construction in Lowsec and cause Lowsec operations to become competitive with Nullsec?
  6. Will Nullsec entities provide protection for large-scale mining operations in their space?
  7. Will a competitive NPC Nullsec-Lowsec market spring up around major construction hubs?

I haven’t had the time or inclination to research these topics in depth; I hope to become motivated when the Crius changes start to hit the test server.

2014-06-08_idle_capital_bpos

 

2014.06.04.20.38.36-1


Kronos Change List

Release date: Tuesday, June 3rd, 2014.

Patch Notes

[eveonline.com]

Dev Blogs

These changes have been pushed to the Crius release on July 22nd.

  1. Building Better Worlds
  2. Industry UI
  3. Researching, the Future
  4. The Price of Change
  5. Team Up: Industry Work Teams
  6. Fortune Favors the Bold

Balance Changes

  1. Drone Changes [devblog]
  2. POS gunning skill to only require Anchoring 4 instead of Anchoring 5 [reddit] [dev post]
  3. FW Plex Cloaking Change [reddit] [dev post]
  4. Phoenix and Citadel Missiles Change [reddit] [dev post] [fanfest slide]
  5. Freighter and Jump Freighter Rigging [reddit]
  6. POS ME Bonus [dev post]
  7. POS Changes [dev post]
  8. Factional Warfare Complex Improvements [reddit] [dev post] [dev post update]
  9. More lowsec K-K wormholes [dev post]
  10. Hull Rigs [dev post]
  11. Exploration loot spew removal [dev post]
  12. Faction drone modules [reddit] [imgur]
  13. Dreadnought Signature Radius increase [dev post]
  14. Freighter and Jump Freighter [reddit] [dev post]
  15. Blockade Runner [reddit] [dev post]
  16. Medium Micro Jump Drives [reddit] [dev post]
  17. Loot Scattering removed [reddit] [dev post]
  18. Pirate Implants [reddit] [dev post]
  19. Hyperspatial Accelerators Modules [reddit] [pastebin]
  20. Active mid slot scanning modules [reddit]
  21. Supercarrier changes [reddit] [news post]

UI/UX

  1. Right-click Menu Update [reddit] [youtube]
  2. Warp in/out animations [reddit] [gif]
  3. Faction Station Skins
  4. Team Pirate Unicorns Tooltip changes [dev post]
  5. Lens Flare Adjustments [dev post]
  6. UI Little Things [dev post]
  7. Audio Customization [dev post]

Ships

  1. Dominix redesign [reddit] [imgur]
  2. Moa redesign [reddit]
  3. Typhoon redesign [reddit]
  4. Condor / Crow / Raptor redesign [reddit]
  5. Mordus Legion [dev post]
    1. Frigate – Garmur
    2. Cruiser – Orthus
    3. Battleship – Barghest [reddit] [imgur]
  6. Prospect [reddit] [dev blog]
  7. 20 Ship Skins [dev post]
  8. Alliance Tournament XII Ships
    1. Chameleon
    2. Whiptail
  9. New skins [imgur]

Internal Code

  1. Dogma, the name for the system that calculates ship bonuses, refactoring to improve performance

Historical Profits by Solar System

Overview

CCP has released two out of the six Devblog posts aimed at industrialists detailing changes for the upcoming Summer expansion. We’re seeing sweeping changes to the way logistics are done for capital ships, station research, POS anchoring limitations, BPO security concerns, and how inventors are going to be given a boost with BPC copy rates. Lockefox has a great summary of the concerns in his Everything Is Changing post.

Given the ideology coming out of the Dev Blogs to empower Nullsec industrialists while kicking Lowsec in the knees, I wanted to see how much of my industrial gameplay occurs in Lowsec — Is CCP killing my game?

Data Data

Summary of profit grouped by solar system with profit numbers obfuscated.

— Get Profit per Station By Solar System including Region
SELECT SUM(profit), mapDenormalize.itemName, mapSolarSystems.solarSystemName, mapRegions.regionName, AVG(mapDenormalize.security)
FROM wallet
JOIN mapDenormalize
ON (wallet.stationID = mapDenormalize.itemID)
JOIN mapRegions
ON (mapDenormalize.regionID = mapRegions.regionID)
JOIN mapSolarSystems
ON (mapDenormalize.solarSystemID = mapSolarSystems.solarSystemID)
GROUP BY wallet.stationID
ORDER BY sum(profit) DESC

2014-04-18_profits_by_solar_system

It turns out that Lowsec only accounts for 7% of our profits to date so I can’t complain about the nerf that is going to hit Lowsec capital builders given the upcoming compression changes.

2014-04-18_profits_by_solar_security

Conclusion

The changes to compression are a welcomed change, even if it means retiring or heavily modifying the logistical chain for Lowsec capital production. I have a feeling that there are going to be more major changes in the next four upcoming Devblog posts. Stay tuned.