GW2 DR% data collection spreadsheet

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

I create this topic as to not fill the “Share your data about perceived strange drop behavior here!” topic with -related- material.

Lots of people with personal experiences on their drop rates with no real data to support it. I’ve completed the layout for my DR on a excel spreadsheet and will begin filling it out. It’s fairly basic but will log my hours played based on /age in game. it keeps dynamic events separate from world exploring, dungeons, and even dragon events. Also including the number of time i participate in the things mentioned. (Perhaps a section for load stones could be put in)The idea is to log how many of each class of item i get from each event to create the DR%.
Perhaps over 100 hours in game…
No intentions to do difference between 0% MF and x% MF.. too much time required for just me.

Now then. the idea here is to collect your accurate, concrete data that is asked for in the “Share your data about perceived strange drop behavior here!” topic and then to post your data there.

(edited by Meowwilson.5106)

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Hawkmoon.5849

Hawkmoon.5849

Should put it up on google docs, then people could download a copy without messaging you.

Just a thought.

Hope is the carrot dangled before the draft horse that plods along in the vain attempt to reach it

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

Should put it up on google docs, then people could download a copy without messaging you.

Just a thought.

yeah. gonna do that later. can’t access that right now.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Ayrilana.1396

Ayrilana.1396

How are you accounting for times where you get no drop or a drop that doesn’t fit in those categories?

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Jrunyon.3012

Jrunyon.3012

Nothing like this will ever work ever. Whats stopping me from saying that I got 2 exotics from 1 event? Can you disprove it? You can say it’s impossible, but its not. You can say I must be lying, but I can come right back and say you’re lying about not receiving an exotic in 500 hours.

As much as I wish to see the results of it, community reports on such a small scale simply can’t be used as a definite, concrete measure.

Nesmee – Thief
[OHai] – Northern Shiverpeaks

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

oh man.. you put no drops in there.. then you need # of kills… could certainly add those. that would increase hours in game significantly without secondary monitor at the least. paper/pencil would suffice. very difficult to track kills in dynamic events though.

items that do not fall under the categories listed? is that like a loot bag(moldy bag)? if so my intention would be to open them and categorize from there.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

Nothing like this will ever work ever. Whats stopping me from saying that I got 2 exotics from 1 event? Can you disprove it? You can say it’s impossible, but its not. You can say I must be lying, but I can come right back and say you’re lying about not receiving an exotic in 500 hours.

As much as I wish to see the results of it, community reports on such a small scale simply can’t be used as a definite, concrete measure.

there is a think called integrity.
i could have 500 hours of video evidence and people could still say it is altered/fake..
but hey, here is some way to help out and add to the cause.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Jrunyon.3012

Jrunyon.3012

there is a think called integrity.

With the internet and anonymity, the concept of integrity goes out the window in a lot of cases. While I agree that your idea would be good, there is just far too many people that will use this to try and bolster their own biased opinion. Unfortunately, this makes the actual people with integrity suffer due to their findings having no merit.

Nesmee – Thief
[OHai] – Northern Shiverpeaks

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

If i did kill count i would go on that instead of in game hours(hard as it may be.). I think i’ll do that actually and make the spreadsheet for that. I will also add wvw in there. perhaps also the number of chests opened.

With the internet and anonymity, the concept of integrity goes out the window in a lot of cases. While I agree that your idea would be good, there is just far too many people that will use this to try and bolster their own biased opinion. Unfortunately, this makes the actual people with integrity suffer due to their findings having no merit.

very true. I enjoy doing stuff like this sometimes though and I’m most likely not the only one. Thus i leave this up for those other people who also like it and would actually spend the time to provide other with the most accurate data they can manage.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: plasmacutter.2709

plasmacutter.2709

ANET has the capacity to log the rarity count of non-upgrade-component items from corpses and chests easily and associate them with account numbers.

Why they don’t do this yet is beyond me, if it’s not supported yet in the code it would literally be one tiny method added to the loot generation algorithm.

The results, especially if logged with player chat and zone activity ("did this person chat, did this person leave “xyz general sub-area”) would QUICKLY show buggy DR affecting roughly half the accounts out there, while the other half have amazing drop rates.. both sides of this happening consistently!

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Nuka Cola.8520

Nuka Cola.8520

i will predict what will happen. From today we will have DR until about a month or two of their first expansion launch (that’s right, another year or more), anet will lose tones of players and their next big thing they’ll tell us that “we get rid of bots and can now remove DR” just to gain back the gamers they lost to buy their new expansion… This is the patheticness that WILL happen, watch and see.

Fact: every Thief tells you to “l2p” when the subject is to nerf stealth.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Clark Skinner.4902

Clark Skinner.4902

I won’t be taking part. I don’t believe they are actually interested in our data. I believe the loot rates were intentionally decreased dramatically despite how much we would hate it. I believe the thread asking us to “prove it” is a way to make us feel like giving up complaining, because there’s no way to prove it concretely.

If I was going to dedicate my time to logging all of this loot (which Anet can definitely log themselves), I would only do it if I knew it wasn’t going to be tossed in the trash without being read.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Valandil Dragonhart.2371

Valandil Dragonhart.2371

I won’t be taking part. I don’t believe they are actually interested in our data. I believe the loot rates were intentionally decreased dramatically despite how much we would hate it. I believe the thread asking us to “prove it” is a way to make us feel like giving up complaining, because there’s no way to prove it concretely.

If I was going to dedicate my time to logging all of this loot (which Anet can definitely log themselves), I would only do it if I knew it wasn’t going to be tossed in the trash without being read.

This.

+1… well said sir.

Of course they can do it themselves, if they can change the loot drops on the fly (nerfing them), then OF COURSE they can increase them again. The just won’t because this game is money-driven and we’re not allowed too much of their precious loot. We can’t feel like we’re getting ahead in the game, for reasons unbeknownst to most of us.

Anet here’s some constructive advice for you… make the loot drops the same as they were before the dreaded 15th of November catastrophe. You’re losing players hand over fist right now because they’re not getting the satisfaction of the reward for their time input into the game. No one wants junk and blues everytime we’re out somewhere, regardless of where or doing what, fix the loot before this game you’ve created self-implodes.

The old-school Arrow-Key warrior.
“Obtaining a legendary should be done through legendary feats…
Not luck and credit cards.”

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: tigirius.9014

tigirius.9014

I won’t be taking part. I don’t believe they are actually interested in our data. I believe the loot rates were intentionally decreased dramatically despite how much we would hate it. I believe the thread asking us to “prove it” is a way to make us feel like giving up complaining, because there’s no way to prove it concretely.

If I was going to dedicate my time to logging all of this loot (which Anet can definitely log themselves), I would only do it if I knew it wasn’t going to be tossed in the trash without being read.

Exactly my thoughts at this point. I’ve reported my findings twice already, they don’t seem to care. ( 5 times in a 1200 post thread deleted and 4 times in the “it’s all your perception” thread they have open now ), You know I’m not so worried about it now, I’m watching to see if they correct it but if they don’t they’ll just be losing more players in the end. Happened to D3 it’s only a matter of time on this one too. There’s other titles that are coming out that appreciate legit farmer players without demanding data from them or ignore them entirely when something’s wrong for months at a time.

Balance Team: Please Fix Mine Toolbelt Positioning!

(edited by tigirius.9014)

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

ouh. i did forget junk items. will add that also.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Kid Taylor.5479

Kid Taylor.5479

I have a question about the criteria for this. Do low value rares like tonics count as a rare? If so, does that skew the numbers one way or another? If not, why is a “rare” tonic not considered rare?

I’m not sure if DR affects chest drops. Does this count? Do crafting materials count as one count in the table?

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

hmmmmmm. my plan is just to take every item i get and count it. no matter where it is from. But i will keep track of how many chest I open and all that. i could add a row for chests…. i think i will.

i did just remember also that my guild basically always has 10% MF buff on.. so yeah, that alters the data.. i can factor that and take it out afterwords

OK now the thing is, i separate chests from kills and that makes a lot of m categories pretty… useless. Working on a simplified version with

  • Dungeons
  • Fractals (for the ascended)
  • Tyria
  • WvW(just remember that one)

Im just going to go with this .. cause the other ones.. i look at and it just seems like it would take so long. not like this one is not going to be time consuming.

and finally here be the link to google dox, i set viewing to all.. but if you have issues opening it and want to get it please tell me.

https://docs.google.com/spreadsheet/ccc?key=0AgyVGyvolSX8dFFDcW1IeTVMbkZncG00S2xOcGsycWc

go to file>download as> (whatever you use.)

This thread was meant to be a constructive thread. thought it would be nice to provide people with a excel spreadsheet and maybe even compile our data to get some mostly accurate data on drop rates. I know if i did this myself it would not be -conclusive data-

If you intend to use this to provide falsified data then i urge you to use some self control and not.

(edited by Meowwilson.5106)

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Death Reincarnated.3570

Death Reincarnated.3570

You will need to look into the following parameters:

- Zone played in
- Time of play (GMT)
- Time spent in zone
- Activities undertaken

In the end there are too many variables to look into to make this experiment as accurate as possible. What you will get from your table is the average. What you need to get out of your data is clearly showing the variables that control DR and when it kicks in; this has been already pointed out several times.

Basically, DR kicks in because of repetition of a particular gameplay style. Your best chance is to keep changing your game play, especially in line withe the ones I wrote above.

Proud member of Legion of Honour XIII

Do not click this link!

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Infernia.9847

Infernia.9847

Actually you need a control where you don’t move around, don’t change mob types and stay there for the same amount of time that you were participating in the experimental phase.
It gives you a baseline to compare your ‘moving about & playing your normal style’ to.

I think Anet would have shown a lot more validity by asking users permission to observe the account activity of each of the members that posted. Basically give us a ‘sign up’ thread to participate in their observations. At least then they could take our information and compare it to the averages they are seeing. I know they could look into any account they want but it would have been a show of good faith with the community who felt something was amiss.

Good luck with this Meowwilson

Blackgate : Level 80 Ranger, Necro, Guardian, Warrior
Devs: Trait Challenge Issued

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Red Falcon.8257

Red Falcon.8257

There are 2 guaranteed things in life: one is death and the other is people lie about their loots.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

Alright. i realized that there are way to many variables to consider for a 100% accurate DR record. So i am settling with my play style and the drop i receive from it. I am a big dungeon runner. mostly AC, COE, COF, SE and TA.. not so much the others but do still run them occasionally. I finally got to fractals level 2 after 9 different runs since the release.. but just in that i got 1 ascended craft item.^^ I also partake in the dragon events because i heard they drop pre-coursers. I’ve been getting into WvW.. and also do some of the events in orr when friends ask for help. So.. yeah, that is what my data is going to be on. from memory I get quite a few rare drops.. some days upwards of 5 and other days 0. going to be interesting to log my loot.. haha.

thanks infernia.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Ayrilana.1396

Ayrilana.1396

There was a reason why I brought up that instances where no drops or drops that don’t fit into the categories. If you don’t include those then all you’re doing is comparing the percentage of one category to another. You’re not really finding DR.

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Meowwilson.5106

Meowwilson.5106

There was a reason why I brought up that instances where no drops or drops that don’t fit into the categories. If you don’t include those then all you’re doing is comparing the percentage of one category to another. You’re not really finding DR.

? my spreadsheet goes off a formula that starts with the % of drop/no drop from kills. say you have a 75/100 (lootable/kills) then it catagorizes the loot into % of that … simpler version … 2 kills.. only 1 of the 2 you get loot from. you get 2 items 1 junk and 1 basic. your drop rate is 25 junk and 25% basic.

(if i’m still missing the point… do you mind giving me the dumbed down version so i can understand… lol.. sorry)

GW2 DR% data collection spreadsheet

in Guild Wars 2 Discussion

Posted by: Ayrilana.1396

Ayrilana.1396

There was a reason why I brought up that instances where no drops or drops that don’t fit into the categories. If you don’t include those then all you’re doing is comparing the percentage of one category to another. You’re not really finding DR.

? my spreadsheet goes off a formula that starts with the % of drop/no drop from kills. say you have a 75/100 (lootable/kills) then it catagorizes the loot into % of that … simpler version … 2 kills.. only 1 of the 2 you get loot from. you get 2 items 1 junk and 1 basic. your drop rate is 25 junk and 25% basic.

(if i’m still missing the point… do you mind giving me the dumbed down version so i can understand… lol.. sorry)

Oh that’s better then. I just didn’t see that you had it in the screenshots before they were taken down.