Merit Data from 503 Randomly Selected Altcoin Bounty Hunters
I scraped the earned merit data of 503 random[1] people participating in altcoin bounty signature campaigns, just for fun and because I was curious to see how many of them would have no merits. The data I got was similar to what I expected (398 of them had 0 merit). Here is the raw merit data in the format Earned Merit | Profile URL.
Those members have:
Chart excludes 2 outliers: pitipawn with 433 earned merits, and temmuz with 159 earned merits. Stats above do include these outliers.
Why?
My reason for doing this was curiosity - I plan on rechecking this sample sometime in the future, and maybe getting a sample of Bitcoin signature campaign participants[2] (might be harder as pretty much every manager doesn't have direct profile links, myself included) to compare with. Draw your own conclusions from the data. Some points might be:
Also to farm merits - gotta rank up to the Super Uber Legendary Cash rank
How?
I'm scraping merit data using Google Sheets, with this formula:
It grabs their merits, subtracts how much merit they would have been given at the start of the system based on current rank, and returns the result. Does not work if they have ranked up, ranked down, are Hero Members who were given 1000 initally or with Copper Members. You need to subtract/add the correction manually, and it's pretty easy to spot errors. This formula grabs their current merit count:
Be warned: You will get rate limited eventually. My original plan was to grab 1000 users worth of data, but it was getting really slow.
Edit: The D2 in the formula is a link to the user's profile. Data will automatically update as long as the formula is present.
[1] By random, I mean I picked a few random bounties, and took the profile links of those who applied.
[2] I am tracking ChipMixer campaign stats, but it's a much smaller sample.
Those members have:
- Received 1129 merits
- Average of 2.24 merits earned
- Excluding those who have no merits, earned, the remaining 105 have earned an average 10.75 merits
Chart excludes 2 outliers: pitipawn with 433 earned merits, and temmuz with 159 earned merits. Stats above do include these outliers.
Why?
My reason for doing this was curiosity - I plan on rechecking this sample sometime in the future, and maybe getting a sample of Bitcoin signature campaign participants[2] (might be harder as pretty much every manager doesn't have direct profile links, myself included) to compare with. Draw your own conclusions from the data. Some points might be:
- Lack of merit sources in Altcoin sections?
- More spam in Altcoin sections?
Also to farm merits - gotta rank up to the Super Uber Legendary Cash rank
How?
I'm scraping merit data using Google Sheets, with this formula:
Code:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(IMPORTXML(D2,"//*[@id=""bodyarea""]"), FIND("Merit:", IMPORTXML(D2,"//*[@id=""bodyarea""]")) + 6, 4), "P", ""), "o", ""), "s", "")-LOOKUP(MID(IMPORTXML(D2,"//*[@id=""bodyarea""]"), FIND("Position", IMPORTXML(D2,"//*[@id=""bodyarea""]"))+9, 2),{"Co","Fu","He","Jr","Le","Me","Ne","Sr"},{"0","100","500","0","1000","10","0","250"})-0
It grabs their merits, subtracts how much merit they would have been given at the start of the system based on current rank, and returns the result. Does not work if they have ranked up, ranked down, are Hero Members who were given 1000 initally or with Copper Members. You need to subtract/add the correction manually, and it's pretty easy to spot errors. This formula grabs their current merit count:
Code:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(IMPORTXML(D2,"//*[@id=""bodyarea""]"), FIND("Merit:", IMPORTXML(D2,"//*[@id=""bodyarea""]")) + 6, 4), "P", ""), "o", ""), "s", "")
Be warned: You will get rate limited eventually. My original plan was to grab 1000 users worth of data, but it was getting really slow.
Edit: The D2 in the formula is a link to the user's profile. Data will automatically update as long as the formula is present.
[1] By random, I mean I picked a few random bounties, and took the profile links of those who applied.
[2] I am tracking ChipMixer campaign stats, but it's a much smaller sample.