Industry and Trading MatrixPosted: 2012-06-06 Filed under: industry, market, nullsec | Tags: c-level, excel, stats 9 Comments
Numbers > Words
If you can’t tell, I’m a very quantifiable person. Using numbers to guide decisions is a method of problem solving that I have cultivated as my professional career has grown.
I remember this one particular insiadent that really stood out where the numbers really proved valuable.
A few years ago when a group of difficult C-level people were up for a laptop refresh, I sent them a simple survey with a list of considerations for their new machines. Each person had rate weight, speed, storage capacity, ruggedness, maximum resolution, monitor size, etc on a scale of 1-3 (3 being the highest priority).
I then took these results and found the general need of the group. The data told me what machine to buy. I wan’t trying to tailor a machine to their needs, their needs dictated the selection. No fights were had when the machines arrived because they all knew that I had properly weighed everyone’s opinions.
To the Spreadsheets!
Since I have performed a number of industry and trading activities in Eve, I felt that the same type of analysis would offer some insight to the greater community.
I made a list of negative and positive factors and applied a value to each of them. The total value has a little bit of logic built into it to help produce a more meaningful result.
Total =(-(Sum all the bad things)+(Sum all the good things))
The English equivalent of this would be something along the line of, “Considering all the bad and good things, what is the best thing I should be doing to make money in Eve?”
(Yes the scale is 1-3, but the sheer amplitude of risk and profitability of Patch Speculation made me weight it with a 4. The external factor of CCP changing a loot table or rebalancing something on the fly is an enormous risk when speculating)
Note that these weights are based on my experiences and therefore you would most likely apply different values to each activity. Just like with the difficult C-level people, getting a larger survey group would help normalize the data and CYA.
Nullsec Alliance Growth and DeclinePosted: 2011-09-15 Filed under: eveonline, history | Tags: alliance, drf, graphs, nc, nullsec, providence, russians, stats 14 Comments
One of Eve’s tenets is that anything created can also destroyed. With the passage of enough time, anything will eventually crumble as the universe is slowly heading towards a state of ever increasing entropy.
Players in Eve can be an agent of this entropy. Given enough time you can gain trust within your corporation, perhaps even eventually becoming an identifiable leader figure. If you choose to become involved at a higher level, you could propel yourself into alliance politics. Over time you could leverage your alliance clout to move into a leadership role and thus gain valuable privileges at the alliance level. Access to information, privileges to disband, and access to assets and money could all be yours.
Perhaps you will use that type power to hone the military might of your alliance into a campaign of territory conquest, or perhaps your goal is to engage in a take-the-money-and-run scam.
We’ve seen both scenarios play out and as shown in the Causality video, major events can be enacted by just one person. Large, influential alliance have formed out of nothing — TEST, while major contenders have declined and reformed again and again — BoB to KenZoku to IT to Raiden.
All Good Things…
Things ebb; Delve Dysprosium and Northern Technetium fortresses have fallen and changed hands. When I started playing Eve in 2008 people were using plate sniper Megathrons to wage war in nullsec and BoB was king; nothing could topple them. If you follow Eve politics, take a second to reflect on what has changed.
Visualizing the change of power can be done through the membership growth and decline rates of major alliances.
In order to graph alliance changes, I needed access to a lot of historical data regarding member counts. The alliance API only returns the current statistics so I reached out to a high profile member of the Eve community for assistance.
A special thanks to Wollari at Dotlan for providing me with the historical data for analysis. This post would not be possible without his data, which he so generously reproduced a few times after corrections to my source query were needed.
- Ranges from 2007-06-26 to 2011-09-15.
- Contains alliances that were in the Dotlan top 100 list on 2011-09-15.
- Added BoB, KenZoku, and IT Alliances to the query since they are historically significant.
- Anomaly on 2009-10-28 where the majority of member counts were inaccurate. The data points for this day has been removed.
- 87,543 rows of membership information for 114 alliances.
Grown and decline of the Northern Coalition next to the rapid growth of the Drone Russian Federation over the past year.
Combined numbers for the NC and Deklein Coalitions.
On 20010-02-03 GoonSwarm (OHGOD) forgot to pay soverignty bills and lost all of their claimed nullsec space. They have since reformed under Goonswarm Federation (CONDI). Test is still smaller than the current incarnation of the Goons.
The above stacked graph shows the Big 10 (12) alliances over time. It looks as if there were only a few major powers back in 2007. Note that this shows how the current big 10 have changed and does not show who was the big 10 over time.
BoB transitioning into KenZoku seems to be an almost one to one member switchover while the formation of IT Alliance brought in a lot of new member corporations.
The fall of IT Alliance seems to have fractured the group. Corporations that were in IT Alliances are now in Black Star, Cartel, Nulli Tertius, Executive Outcomes, Northern Coalition., AAA, Razor, Cascade Imminent, and the Initiative. Only 33.2% of the members moved into Raiden.
Sev3rance is an interesting entity as they have been moving around a lot. Historically they have been the guardians to one of the entrance routes (KBP7-G) to Providence. Having lost their constellation systems in 2010-03 to Ushra’Khan, they found a home in the NC in Pure Blind and Cloud Ring only to move back to Providence in 2011-07.
Messy stacked graph of all 114 alliances in my data set. It does look like there is definite stagnation in nullsec in 2011.
If you would like to see additional graphs or a separate post on how I transformed the data set, please let me know. I only created a few graphs that I thought would be interesting for the vast majority of the Eve audience. Additionally, my nullsec political knowledge may be lacking and I am open to corrections. Again thanks to Wollari for letting me work with his data.