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

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

Wormholes

 
  • Topic is locked indefinitely.
12Next page
 

[Google Doc] September Monthly Killboard Comparison
Author
Previous Topic Next Topic
NoobMan
Perkone
Caldari State
#1 - 2014-10-01 12:33:34 UTC  |  Edited by: NoobMan
[Google Doc] Wormhole Monthly Killboard Comparison (Sept)

Operations Director of Hard K(n)ocks Inc.
chris elliot
Lazerhawks
L A Z E R H A W K S
#2 - 2014-10-01 13:37:07 UTC
Now filter out the k-space kills from the w-space kills.
Aiyshimin
Shiva Furnace
#3 - 2014-10-01 13:39:10 UTC
AdAstra seem to be the sovereign kings of w-space, awesome work guys!
umnikar
Fishbone Industries
#4 - 2014-10-01 13:47:50 UTC
Aiyshimin wrote:
AdAstra seem to be the sovereign kings of w-space, awesome work guys!



^^ this
Wondering why it's sorted by $ destroyed at default...or why such calculations are there anyway Question
Alundil
Rolled Out
#5 - 2014-10-01 13:54:52 UTC
Thanks, as always, noobman.

I'm right behind you
Jack Miton
School of Applied Knowledge
Caldari State
#6 - 2014-10-01 14:00:44 UTC
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.


^^^this

There is no Bob.

Stuck In Here With Me:  http://sihwm.blogspot.com.au/

Down the Pipe:  http://feeds.feedburner.com/CloakyScout
Natasha Donnan
Deep Core Mining Inc.
Caldari State
#7 - 2014-10-01 14:12:11 UTC
Jack Miton wrote:
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.


^^^this


I've got this data if people are interested. Noobman, not trying to steal your thunder or anything here.

Out of interest there also seems to be an issue with the stats page on zkillboard, if a corp member gets on your kill mail then it seems to appear in the stats page as a kill for your corp rather than a loss. This hopefully explains the difference between some of the figures on Noobmans sheet and mine.

here

Creator of the W-Space KB Comparison

CivilWars
Half Empty
xqtywiznalamywmodxfhhopawzpqyjdwrpeptuaenabjawdzku
#8 - 2014-10-01 14:44:39 UTC
Nice work Noob, as usual.

Natasha, love it. Can I request a column be added to show % of kills in w-space? I know I can get a general idea, but effort.

Hidden Fremen liked your forum post:

Jack Miton liked your forum post:
Juan Diolosa
State War Academy
Caldari State
#9 - 2014-10-01 14:50:43 UTC
BAM!

Made a list and we are not even commies.

Thanks, Noobman.

KRAB Radio
Rek Seven
University of Caille
Gallente Federation
#10 - 2014-10-01 15:14:34 UTC  |  Edited by: Rek Seven
Does this just show wormhole kills or all kills? ... I suppose it would be pretty pointless if it was all kills.

edit:
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.

Ah okay, i guess that answers that one.

The wishlist is pretty much complete...
Judas Lonestar
Stryker Industries
Stryker Group
#11 - 2014-10-01 16:27:39 UTC  |  Edited by: Judas Lonestar
Aiyshimin wrote:
AdAstra seem to be the sovereign kings of w-space, awesome work guys!



You mean nullsec right? A quick breeze through their Sept killboard (Which is EXTENSIVE) shows a distinct lack of "J" as the starting system number.

EDIT: I personally think a list showing only W-space kills and only those kills which are (were) ships (Not pos modules and stuff) would be far more telling as whos actually active in W-space.

Of course, that would make me simply cease to exist on killboards I suppose. :)
Andrew Jester
Collapsed Out
Pandemic Legion
#12 - 2014-10-01 16:57:39 UTC
Natasha Donnan wrote:
Jack Miton wrote:
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.


^^^this


I've got this data if people are interested. Noobman, not trying to steal your thunder or anything here.

Out of interest there also seems to be an issue with the stats page on zkillboard, if a corp member gets on your kill mail then it seems to appear in the stats page as a kill for your corp rather than a loss. This hopefully explains the difference between some of the figures on Noobmans sheet and mine.

here


Are you looking at it from just the stats page, or are you pulling all kills and parsing from there? If you're parsing, then in that function, just run a check on system and if it's j followed by numbers (can't be ****** to make this regex sorry), then class it as a WH kill.

If thuggin' was a category I'd win a Grammy
Judas Lonestar
Stryker Industries
Stryker Group
#13 - 2014-10-01 17:14:17 UTC
Andrew Jester wrote:
Natasha Donnan wrote:
Jack Miton wrote:
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.


^^^this


I've got this data if people are interested. Noobman, not trying to steal your thunder or anything here.

Out of interest there also seems to be an issue with the stats page on zkillboard, if a corp member gets on your kill mail then it seems to appear in the stats page as a kill for your corp rather than a loss. This hopefully explains the difference between some of the figures on Noobmans sheet and mine.

here


Are you looking at it from just the stats page, or are you pulling all kills and parsing from there? If you're parsing, then in that function, just run a check on system and if it's j followed by numbers (can't be ****** to make this regex sorry), then class it as a WH kill.


This is assuming every nullsec system name has a dash in it, but if so you could simply check for the "-" in the system name and skip it when tallying up the kills.
Natasha Donnan
Deep Core Mining Inc.
Caldari State
#14 - 2014-10-01 17:25:01 UTC
Andrew Jester wrote:
Natasha Donnan wrote:
Jack Miton wrote:
chris elliot wrote:
Now filter out the k-space kills from the w-space kills.


^^^this


I've got this data if people are interested. Noobman, not trying to steal your thunder or anything here.

Out of interest there also seems to be an issue with the stats page on zkillboard, if a corp member gets on your kill mail then it seems to appear in the stats page as a kill for your corp rather than a loss. This hopefully explains the difference between some of the figures on Noobmans sheet and mine.

here


Are you looking at it from just the stats page, or are you pulling all kills and parsing from there? If you're parsing, then in that function, just run a check on system and if it's j followed by numbers (can't be ****** to make this regex sorry), then class it as a WH kill.


Erm, not quite following what you are saying. My spreadsheet does split out k-space and w-space kills (and losses) granted it doesn't make a differentiation between hisec lowsec and 00 but i dont think people are that bothered about that.

FYI I am trawling every kill and adding up the stats manually and am checking for caps, and the system that the kill occurred to produce the data.

Creator of the W-Space KB Comparison

Andrew Jester
Collapsed Out
Pandemic Legion
#15 - 2014-10-01 19:28:54 UTC
Judas Lonestar wrote:

This is assuming every nullsec system name has a dash in it, but if so you could simply check for the "-" in the system name and skip it when tallying up the kills.


No you obviously know nothing about regex. Match starting character to j and accept 6 characters after that are only numbers 0-9. That matches only WHs.

Natasha Donnan wrote:

Erm, not quite following what you are saying. My spreadsheet does split out k-space and w-space kills (and losses) granted it doesn't make a differentiation between hisec lowsec and 00 but i dont think people are that bothered about that.

FYI I am trawling every kill and adding up the stats manually and am checking for caps, and the system that the kill occurred to produce the data.


Is your spreadsheet making API calls or are you doing it by hand? If you're doing it by hand I'm so sorry. You can make API calls per corp per day, but you'll hit your limit pretty fast. If you do it one time then you'll be fine, but you may need to spread the calls out over two days...

If thuggin' was a category I'd win a Grammy
Natasha Donnan
Deep Core Mining Inc.
Caldari State
#16 - 2014-10-01 19:35:50 UTC
Andrew Jester wrote:
Judas Lonestar wrote:

This is assuming every nullsec system name has a dash in it, but if so you could simply check for the "-" in the system name and skip it when tallying up the kills.


No you obviously know nothing about regex. Match starting character to j and accept 6 characters after that are only numbers 0-9. That matches only WHs.

Natasha Donnan wrote:

Erm, not quite following what you are saying. My spreadsheet does split out k-space and w-space kills (and losses) granted it doesn't make a differentiation between hisec lowsec and 00 but i dont think people are that bothered about that.

FYI I am trawling every kill and adding up the stats manually and am checking for caps, and the system that the kill occurred to produce the data.


Is your spreadsheet making API calls or are you doing it by hand? If you're doing it by hand I'm so sorry. You can make API calls per corp per day, but you'll hit your limit pretty fast. If you do it one time then you'll be fine, but you may need to spread the calls out over two days...


Of course I am not doing it by hand :) the spreadsheet is making the api calls and adding up the values. It all works absolutely fine, it caches data for x amount of time, blah blah, I know how to program :P

Btw you can't use regex on system names from the zkb api, it gives you the system id rather than the system name. All you actually need to do is check that the system id is over a certain number.

Creator of the W-Space KB Comparison

Andrew Jester
Collapsed Out
Pandemic Legion
#17 - 2014-10-01 19:37:18 UTC
Natasha Donnan wrote:
Andrew Jester wrote:
Judas Lonestar wrote:

This is assuming every nullsec system name has a dash in it, but if so you could simply check for the "-" in the system name and skip it when tallying up the kills.


No you obviously know nothing about regex. Match starting character to j and accept 6 characters after that are only numbers 0-9. That matches only WHs.

Natasha Donnan wrote:

Erm, not quite following what you are saying. My spreadsheet does split out k-space and w-space kills (and losses) granted it doesn't make a differentiation between hisec lowsec and 00 but i dont think people are that bothered about that.

FYI I am trawling every kill and adding up the stats manually and am checking for caps, and the system that the kill occurred to produce the data.


Is your spreadsheet making API calls or are you doing it by hand? If you're doing it by hand I'm so sorry. You can make API calls per corp per day, but you'll hit your limit pretty fast. If you do it one time then you'll be fine, but you may need to spread the calls out over two days...


Of course I am not doing it by hand :) the spreadsheet is making the api calls and adding up the values. It all works absolutely fine, it caches data for x amount of time, blah blah, I know how to program :P

Btw you can't use regex on system names from the zkb api, it gives you the system id rather than the system name. All you actually need to do is check that the system id is over a certain number.


That or match system ID to the data dump/api call from CCP, but have checking if the number is over a different one would be vastly more efficient.

If thuggin' was a category I'd win a Grammy
Aiyshimin
Shiva Furnace
#18 - 2014-10-01 21:26:53 UTC
Judas Lonestar wrote:
Aiyshimin wrote:
AdAstra seem to be the sovereign kings of w-space, awesome work guys!



You mean nullsec right? A quick breeze through their Sept killboard (Which is EXTENSIVE) shows a distinct lack of "J" as the starting system number.

EDIT: I personally think a list showing only W-space kills and only those kills which are (were) ships (Not pos modules and stuff) would be far more telling as whos actually active in W-space.

Of course, that would make me simply cease to exist on killboards I suppose. :)


Ok I didn't parse the locations that much.

Let me rephrase: AdAstra are the best PVPers out of this selection of corps by a fair margin.

Hatshepsut IV
Un.Reasonable
#19 - 2014-10-01 23:58:08 UTC  |  Edited by: Hatshepsut IV
Aiyshimin wrote:
...Let me rephrase: AdAstra are the best PVPers out of this selection of corps by a fair margin.


By the universal standard metric of your opinion?

Public Channel | Un.Welcome
Trinkets friend
Sudden Buggery
Sending Thots And Players
#20 - 2014-10-02 02:39:41 UTC
This is interesting data.

AdAdstra (10%), SnailsAndFrogs (10%), KICK, WH0RE, BAERS all get less than a third of their kill value in WH space. Golf claps all around. That's some amazing wormholing, AdAstra.

The average ISK killed in w-space versus total is 57%.

Excluding capitals, i think it is fair to say that a majority of entities get more numerical kills outside of w-space than inside. QUEX and BU got an average of 94% of ISK killed in w-space.

The median value of WH kills has gone from 25-28 billion per month pre Hyperion down to 21 (across ALL entities) in September. It will be interesting to see if this continues trending lower.

Likewise, the average is trending down from 72B in May, 58 June, 49 in july, 44 in August and 41B in September. As low as April.

Number of kills on average has trended down similarly; 83 in April, 104 in May, 95 June, 90 July, 87 August and 76 in September.
The medium number of total kills per corp follows the same trajectory.

Conclusions?

Well, I guess we have to wait another 5 months but there is a clear trend of wormhole PVP losing out to k-space PVPing. We are seeing, on average and in aggregate, less being killed in terms of ISk and individual kills, by wormholers, since April.

The data doesn't address the issue directly, and capital kills in terms of ISk certainly heavily skew data in wormholes towards a few capital ganks washing out hundreds of BRAVE Atrons and Moas, so it's hard to say if there's even less wormhole PVP being had than this suggests. it's likely, I've certainly not experienced anywhere near the number of random encounters of even POSed up fools in the past 6 weeks.

So, going forward, I hope that Fozzie is reading this and realises that he's got to look at actual hard facts. if he doesn't, well, it doesn't bode well.



~~ Localectomy Blog ~~
12Next page