Bitcoin Forum
September 17, 2019, 03:27:10 AM *
News: Latest Bitcoin Core release: 0.18.1 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: A useful user statistic to show - Magic Dust or Emep?  (Read 214 times)
d_eddie
Hero Member
*****
Offline Offline

Activity: 812
Merit: 673



View Profile
April 23, 2018, 11:58:47 PM
Merited by InvoKing (1)
 #1

If I could get heard by the mighty Theymos, I would very much like to ask if we could get more statistics. We need something like "Imagination", "Magic Dust" or "Emep", which might stand for "Earned Merit per Eligible Post (ratio)".

The first has been implemented, but we saw it didn't work out. Could we have the other two? Or just the last, maybe? It actually could give us a useful view of someone's history here.

Or some other number/bucket system like that, perhaps. I'm sure several tweaks could be twoken to fuzzy it up a bit if deemed appropriate.
1568690830
Hero Member
*
Offline Offline

Posts: 1568690830

View Profile Personal Message (Offline)

Ignore
1568690830
Reply with quote  #2

1568690830
Report to moderator
1568690830
Hero Member
*
Offline Offline

Posts: 1568690830

View Profile Personal Message (Offline)

Ignore
1568690830
Reply with quote  #2

1568690830
Report to moderator
1568690830
Hero Member
*
Offline Offline

Posts: 1568690830

View Profile Personal Message (Offline)

Ignore
1568690830
Reply with quote  #2

1568690830
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
InvoKing
Legendary
*
Offline Offline

Activity: 1386
Merit: 1064


View Profile
April 24, 2018, 12:35:56 AM
 #2

If I could get heard by the mighty Theymos, I would very much like to ask if we could get more statistics. We need something like "Imagination", "Magic Dust" or "Emep", which might stand for "Earned Merit per Eligible Post (ratio)".

The first has been implemented, but we saw it didn't work out. Could we have the other two? Or just the last, maybe? It actually could give us a useful view of someone's history here.

Or some other number/bucket system like that, perhaps. I'm sure several tweaks could be twoken to fuzzy it up a bit if deemed appropriate.

A little bit confused about the relation between these three. Imagination was used in April 1, and I don't think enabling it will be that useful.
For Emep, how could you tell if a post deserves to be merited or not? If there is a like button and crossing likes vs merit then it might be possible, otherwise, I don't see how.
Sr+ Wink
actmyname
Copper Member
Legendary
*
Offline Offline

Activity: 1512
Merit: 1731


hubris of vanity


View Profile WWW
April 24, 2018, 12:39:21 AM
 #3

Go to your profile information page. Turn on post count.

Now you have merit and the number of posts. Divide.
What's the point of adding this in? It's not a good quantifier of post quality. Though unfortunate, a user may not receive as much merit as they deserve. Or they may receive more merit than they deserve (e.g. peloso meriting me)

InvoKing
Legendary
*
Offline Offline

Activity: 1386
Merit: 1064


View Profile
April 24, 2018, 12:47:04 AM
 #4

Go to your profile information page. Turn on post count.

Now you have merit and the number of posts. Divide.
What's the point of adding this in? It's not a good quantifier of post quality. Though unfortunate, a user may not receive as much merit as they deserve. Or they may receive more merit than they deserve (e.g. peloso meriting me)

Dividing all posts / merit could be useful for new users that joined after merit implementation, however the OP means from what i understood
Quote
Maybe by "Eligible post" I meant "Activity since the Merit System" rather than "Actual posts since the Merit System"
https://bitcointalk.org/index.php?topic=178336.msg35430725#msg35430725

Kind of neutral this time to the propositions, however, i still recommend a like button..
theymos
Administrator
Legendary
*
Offline Offline

Activity: 3514
Merit: 6233


View Profile
April 24, 2018, 01:07:40 AM
 #5

I tried two or three different metrics for things like "emep", but they all had poor results, mainly because so many posts were made pre-merit and there's so much difference between users on the various input variables. If people have ideas for stats in this vein, give me an exact formula with preferably only a few input variables. I might at least post some global stats, though maintaining an up-to-date stat for each user might be too slow.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
d_eddie
Hero Member
*****
Offline Offline

Activity: 812
Merit: 673



View Profile
April 24, 2018, 03:10:12 AM
Last edit: April 24, 2018, 08:28:25 PM by d_eddie
 #6

I tried two or three different metrics for things like "emep", but they all had poor results, mainly because so many posts were made pre-merit and there's so much difference between users on the various input variables. If people have ideas for stats in this vein, give me an exact formula with preferably only a few input variables. I might at least post some global stats, though maintaining an up-to-date stat for each user might be too slow.


For the merit rate, I was thinking of something like
Code:
(1) EMEP = merit_earned / posts_since_merit_system
where merit_earned = merit - merit_airdropped_for_rank,
trying to capture how many rewards were earned for posts made after merit was introduced.

Alternatively,
Code:
(2) EMEA = merit_earned / activity_since_merit_system
which might have some advantage I can't see.

Both metrics would indirectly provide info as to the posters' rank at the time of merit introduction, or to their activity since then. If this is undesired, larger buckets could be provided for the merit rate:

Code:
(3)
# MP = EMEP, EMEA, or similar quantity.
if (MP >= 1.0) return 'A'
if (MP > 0.5) return 'B'
if (MP > 0.3) return 'C'
...
if (all else fails) return 'Z'

A useful statistic can be computed without reference to the actual number of posts - e.g., something like
Code:
(4) latest_merit_increment/latest_activity_increment
where both increments are within the same 14-day period.

If the metric needs to smoothed out against volatility, it could be implemented with some time quantization, , possibly a time moving average (exp decay?).

This is off the top of my head. I haven't given the matter serious thought, honestly. If anything sensible pops up, I'll add to this thread. I was hoping to stir some rational discussion, so I'm happy the mighty were indeed listening. Thank you!

(@InvoKing: thank you too  Wink)
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 616
Merit: 2659

There are lies, damned lies and statistics. MTwain


View Profile WWW
April 24, 2018, 02:07:18 PM
 #7

<...>

The way I see it, I think your EMEP proposal would be a better measure than EMEA, since it covers all post and not just a pondered fortnight count on them. In either case, as you say, only post posted since merit system kick-off should be considered for this indicator, avoiding the effect theymos mentions when pondering all the post history.

Another possible personal indicator would be something in the line of MPEP:
Code:
100 * (Nº of distinct Merited Posts / Nº of Posts)
The MPEP indicator should again only consider post merit kick-off posts.

The two are in fact complementary. I could have made 1 good post out of 50 and receive 50 sMerits for it, or I could have posted 50 posts and received 1 sMerit for each post. In either case, My Merit Counter would have been incremented by 50.

In the first case I would have   EMEP: 50/50 =1       and MPEP: 100 * (1/50) =2%
In the second case I would have   EMEP: 50/50 =1   and MPEP: 100 *50/50 =100%

EMEP stated that both cases have the same ratio, but MPEP gives as insights as to how the earned merits are spread out over all posts belonging to the user. The latter is a better poster overall in theory.

Something similar ratios could be though out from the awarding point of view (how much do I award?, Do I award evenly or not (by looking at the standard deviation for example vs mean).


The thing is, figuring out what to do with these indicators and what operational use they have. For example, should they be placed on the user profile and could be a way to create self-challenge for improvement of the values of the indicators?
They could also be placed on the user information area by the posts, so everyone could see them, but could be too easily taken as indicators for awarding/ingoring the user’s posts (this could be both good and bad, depending where our indicator values lie).
Or they could conform a general stat to the forum.

I’m not sure if the OPs intention in this post is limited to personal indicators, or global stats too. Some simple global indicators in addition to the currently shown could be in the line of:



These indicators help monitor sMerit overall flow and are both beneficial and potentially controversial. The interesting new columns that I haven’t seen around before are nFromNew (number of new users that award sMerit and have not done it on previous weeks) and nToNew (number of users that receive sMerit for the first time). Positive news here is that roughly 30++% of awarded users are "new", that is, they receive their first sMerit, so it is not all going to consolidated users. Quantity is small though.

Note: Week is natural monday to sunday (the last week (16th) is therefore partial since sMerit.txt file goes up to early friday morning.



theymos
Administrator
Legendary
*
Offline Offline

Activity: 3514
Merit: 6233


View Profile
April 24, 2018, 06:28:45 PM
 #8

Code:
+------------------------+----------+
| User                   | EMEP     |
+------------------------+----------+
| GameKyuubi             | 172.0000 |
| BiPolarBob             |  52.0000 |
| roll on                |  52.0000 |
| negeroy                |  51.0000 |
| mthcl                  |  50.0000 |
| TrollCoins             |  50.0000 |
| lfloorwalker           |  50.0000 |
| Sunderland             |  46.0000 |
| nonnakip               |  42.0000 |
| aledesousa             |  40.0000 |
| Dropper                |  32.0000 |
| TheBobyHunter          |  30.5000 |
| synace                 |  28.0000 |
| popshot                |  27.0000 |
| pitipawn               |  26.5556 |
| Errror                 |  25.0000 |
| ParkByte               |  25.0000 |
| Eclipse2021            |  25.0000 |
| k453345                |  24.0000 |
| Evil-Knievel           |  20.2857 |
| hephaist0s             |  20.0000 |
| eBunny6                |  20.0000 |
| davidrus123            |  20.0000 |
| Two-faced              |  20.0000 |
| adhd_                  |  20.0000 |
| unknownids             |  18.3333 |
| Yaremi                 |  18.0000 |
| romanornr              |  17.1111 |
| gmaxwell               |  16.6364 |
| theymos                |  15.4574 |
| grue                   |  15.1111 |
| totwotoo2              |  15.0000 |
| QuiveringGibbage       |  14.0000 |
| Georgiano              |  14.0000 |
| spartak_t              |  12.8750 |
| monocolor              |  12.7500 |
| John (John K.)         |  12.6000 |
| baritus                |  12.5000 |
| fedor3327              |  11.5000 |
| koinsever              |  11.0000 |
| barisbilgili           |  11.0000 |
| vfrcbv911              |  11.0000 |
| Deathwing              |  10.2000 |
| AStephen2011           |  10.0000 |
| Nerull                 |  10.0000 |
| BigWait                |  10.0000 |
| kenzie95               |  10.0000 |
| Mr_SeLeNiO             |  10.0000 |
| Dexon                  |  10.0000 |
| winterrose             |  10.0000 |
| MikkiRefur             |  10.0000 |
| luckyluckybear         |  10.0000 |
| hasu                   |  10.0000 |
| Kumbopulus             |  10.0000 |
| Camille_               |  10.0000 |
| SMFSMF5555             |  10.0000 |
| Bitcze                 |  10.0000 |
| Sergio_Demian_Lerner   |   9.0000 |
| dogie                  |   9.0000 |
| rby                    |   9.0000 |
| Str1x                  |   9.0000 |
| VashStampede           |   9.0000 |
| semux                  |   8.8667 |
| Battlestar_Coin        |   8.6667 |
| gruve_p                |   8.3333 |
| SA Bitcoin Brothers    |   8.0000 |
| allahabadialt          |   8.0000 |
| God Fist               |   7.5000 |
| cryptimus prime        |   7.2857 |
| alex bond              |   7.2353 |
| analema                |   7.1429 |
| Aleksabit              |   7.1429 |
| Wingzcrypto2018        |   7.1429 |
| UdjinM6                |   7.0000 |
| publicjud1             |   7.0000 |
| orangepeel             |   7.0000 |
| videotek               |   7.0000 |
| abegzad                |   6.6667 |
| CipherUno              |   6.6667 |
| EnF0Rc3r               |   6.5000 |
| Ajpa94                 |   6.5000 |
| CryptoBridge           |   6.2500 |
| tonych                 |   6.0270 |
| jl777                  |   6.0000 |
| gonnafly               |   6.0000 |
| wosch76                |   6.0000 |
| charlescoin            |   6.0000 |
| ChatBotv2              |   6.0000 |
| batuh007               |   6.0000 |
| cmacwuz                |   6.0000 |
| ANNBumping_needed      |   6.0000 |
| ErisDiscordia          |   5.8571 |
| fengxia                |   5.6522 |
| mistercashking         |   5.5556 |
| FrozenChaos            |   5.5556 |
| Dario3000              |   5.5000 |
| redpepper              |   5.5000 |
| Paedy                  |   5.5000 |
| bitrails               |   5.5000 |
| GrowGuildD             |   5.4000 |
| Fatanut                |   5.2000 |
| Xian01                 |   5.0000 |
| bushstar               |   5.0000 |
| cloverme               |   5.0000 |
| boondogger             |   5.0000 |
| sp383                  |   5.0000 |
| Financisto             |   5.0000 |
| Fuserleer              |   5.0000 |
| LucD88                 |   5.0000 |
| daniobg                |   5.0000 |
| unicornflex            |   5.0000 |
| Trukkur                |   5.0000 |
| Neo Baudrillard        |   5.0000 |
| PokemonGoArena         |   5.0000 |
| sherlock_h             |   5.0000 |
| Nathan Graves          |   5.0000 |
| secretservice          |   5.0000 |
| JacquesLeGrande        |   5.0000 |
| packetsmurf            |   5.0000 |
| plucking23             |   5.0000 |
| bennypagulayan         |   5.0000 |
| VazLorde               |   5.0000 |
| Delirium07             |   5.0000 |
| haltingprobability     |   5.0000 |
| AllarDallar            |   5.0000 |
| Msharim                |   5.0000 |
| Tobi97l                |   5.0000 |
| MetropolisHastings12   |   5.0000 |
| flickernetwork         |   5.0000 |
| kryptoholik            |   5.0000 |
| CryptoMaps             |   5.0000 |
| jooj                   |   4.7619 |
| RichDaniel             |   4.6393 |
| minerbro               |   4.6250 |
| Corrosive              |   4.6250 |
| Arczimedes             |   4.5455 |
| thefiniteidea          |   4.5000 |
| ahmedjamal1998         |   4.5000 |
| FIFA worldcup          |   4.5000 |
| anjho.ace              |   4.5000 |
| hassan.shakeel.rajpoot |   4.5000 |
| everton-1888           |   4.5000 |
| nemgun                 |   4.4000 |
| costis                 |   4.4000 |
| thisisntbic            |   4.2857 |
| swordfish6975          |   4.2500 |
| DigiByte               |   4.2500 |
| LongAndShort           |   4.1667 |
| _church                |   4.1667 |
| SeverusSnegg           |   4.0870 |
| shorena                |   4.0556 |
| ziomik                 |   4.0000 |
| No_2                   |   4.0000 |
| Steepdev               |   4.0000 |
| Pesmand                |   4.0000 |
| kimkibu                |   4.0000 |
| Hypocritus             |   4.0000 |
| ammo121810             |   4.0000 |
| LindaQ                 |   4.0000 |
| renriyon               |   4.0000 |
| tizzle81               |   4.0000 |
| syavca                 |   4.0000 |
| Tunjevina              |   4.0000 |
| Cryptobitminer         |   4.0000 |
| Marec4                 |   3.9375 |
| batesresearch          |   3.9286 |
| brianmct               |   3.9231 |
| Seapork                |   3.9091 |
| Dr.Mann                |   3.8065 |
| AZwarel                |   3.7500 |
| BitcoinHomework        |   3.7500 |
| NLNico                 |   3.7391 |
| marlais                |   3.6667 |
| Shymko                 |   3.6000 |
| maldini                |   3.5714 |
| tam31                  |   3.5000 |
| CryptoSangria          |   3.5000 |
| saulzaents             |   3.4861 |
| truckinusa44           |   3.4375 |
| heratys111             |   3.3889 |
| dorianm421             |   3.3333 |
| jl2012                 |   3.3333 |
| jayeeyee               |   3.3333 |
| erik m.                |   3.3333 |
| vegito                 |   3.3333 |
| co0ler                 |   3.3333 |
| veneg                  |   3.3333 |
| star citizen           |   3.3333 |
| Hagane                 |   3.3333 |
| Freedom Force          |   3.3333 |
| Star_Bucks             |   3.3333 |
| flymnb                 |   3.3333 |
| smartash               |   3.3333 |
| jackmoon               |   3.3333 |
| Brzina                 |   3.3333 |
| Revenant 02            |   3.3333 |
| jamesburrell2          |   3.3333 |
| Linleyi                |   3.3333 |
| ozma03                 |   3.3333 |
| pasecka                |   3.3333 |
| avatar_gr              |   3.3333 |
| wheresthecurve         |   3.3333 |
| cryptolous             |   3.3333 |
| zcroc1                 |   3.3333 |
| TheBrute               |   3.3000 |
| Annon001               |   3.2857 |
| nanze                  |   3.2500 |
| explorder              |   3.2130 |
| theXcode               |   3.1667 |
| J. Becker              |   3.1667 |
| Clocktick              |   3.1429 |
| growarijo              |   3.0909 |
| bitpop                 |   3.0000 |
| randzzz                |   3.0000 |
| yabtcl                 |   3.0000 |
| deadsea33              |   3.0000 |
| walletrecoveryservices |   3.0000 |
| w0lverine              |   3.0000 |
| vindyne8               |   3.0000 |
| Videodrome             |   3.0000 |
| HakanYAZICI            |   3.0000 |
| MrChicken1987          |   3.0000 |
| poopbread              |   3.0000 |
| vezt                   |   3.0000 |
| hodlercoasterguy       |   3.0000 |
| asiat123098            |   3.0000 |
| shroomDance            |   3.0000 |
| idrisi33               |   3.0000 |
| KingBT                 |   3.0000 |
| darecky                |   3.0000 |
| Triple_X               |   3.0000 |
| Justin-Checqit         |   3.0000 |
| MrGGates               |   3.0000 |
| m0rph3us7              |   3.0000 |
| chain_architect        |   3.0000 |
| techtipspt             |   3.0000 |
| MtGotts                |   3.0000 |
| TheCryptoguyX          |   3.0000 |
| 0Alvaren0              |   3.0000 |
| yla1974                |   2.9459 |
| vanessa81              |   2.9412 |
| HCLivess               |   2.9048 |
| jackielove4u           |   2.8889 |
| kaar                   |   2.8750 |
| Craige288              |   2.8571 |
| Mysticus               |   2.8333 |
| Nomad88                |   2.8095 |
| mnemonicsoup           |   2.8000 |
| BitPanda.com           |   2.7778 |
| wnj4                   |   2.7778 |
| kaptkrunch             |   2.7778 |
| cryptodevil            |   2.7500 |
| AlexSimion             |   2.7500 |
| tongokongo             |   2.7500 |
| crypflash              |   2.7500 |
| Lutpin                 |   2.7391 |
| maccaspacca            |   2.6667 |
| kupido14               |   2.6667 |
| Vitacplus              |   2.6667 |
| NoSkyLimit             |   2.6667 |
| DecentralizeEconomics  |   2.6429 |
| stoffu                 |   2.6000 |
| cinnamon_carter        |   2.5714 |
| LZ                     |   2.5000 |
| georgewilliams         |   2.5000 |
| Enkel                  |   2.5000 |
| Xandrah                |   2.5000 |
| xwtfx                  |   2.5000 |
| BetcoinCasino          |   2.5000 |
| Alondre                |   2.5000 |
| proletariat            |   2.5000 |
| IngerDev               |   2.5000 |
| fortress               |   2.5000 |
| The Legendary          |   2.5000 |
| yoseff                 |   2.5000 |
| qrhyxelle              |   2.5000 |
| Obi-Wan Coinob1        |   2.5000 |
| XMR2020                |   2.5000 |
| Fredista               |   2.5000 |
| joejoemister           |   2.5000 |
| BitCunha               |   2.5000 |
| PandapoolNL            |   2.5000 |
| F0ME                   |   2.5000 |
| B!tco!n$               |   2.5000 |
| Bitlinguist            |   2.5000 |
| rampantparanoia        |   2.4615 |
| coinminter22           |   2.4444 |
| exus                   |   2.4390 |
| lillo                  |   2.4000 |
| Joe-Niner              |   2.3684 |
| Tranz                  |   2.3636 |
| umine                  |   2.3571 |
| Irchus                 |   2.3529 |
| sickpig                |   2.3333 |
| blissz                 |   2.3333 |
| Jacky_Chan             |   2.2727 |
| jochemin               |   2.2500 |
| grtthegreat            |   2.2500 |
| dietmarfritz59         |   2.2500 |
| seethernac             |   2.2500 |
+------------------------+----------+

Code:
+------------------------+---------+
| User                   | MPEP    |
+------------------------+---------+
| roll on                | 19.0000 |
| nonnakip               |  3.0000 |
| Yaremi                 |  3.0000 |
| gmaxwell               |  2.6364 |
| vfrcbv911              |  2.5000 |
| AStephen2011           |  2.0000 |
| dacoinminster          |  2.0000 |
| Sergio_Demian_Lerner   |  2.0000 |
| smoothie               |  2.0000 |
| Sunderland             |  2.0000 |
| BiPolarBob             |  2.0000 |
| negeroy                |  2.0000 |
| koinsever              |  2.0000 |
| sherlock_h             |  2.0000 |
| SA Bitcoin Brothers    |  2.0000 |
| Aymaro                 |  2.0000 |
| hula hula              |  2.0000 |
| KingBT                 |  2.0000 |
| Kumbopulus             |  2.0000 |
| Tunjevina              |  2.0000 |
| Triple_X               |  2.0000 |
| Camille_               |  2.0000 |
| dogie                  |  1.8000 |
| erik m.                |  1.6667 |
| Freedom Force          |  1.6667 |
| embii                  |  1.5000 |
| Nathan Graves          |  1.5000 |
| secretservice          |  1.5000 |
| tam31                  |  1.5000 |
| God Fist               |  1.5000 |
| haltingprobability     |  1.5000 |
| Star_Bucks             |  1.4667 |
| vegito                 |  1.3333 |
| Hagane                 |  1.3333 |
| kupido14               |  1.3333 |
| Linleyi                |  1.3333 |
| kaspersky15            |  1.3333 |
| idrisi33               |  1.3333 |
| cryptodevil            |  1.2500 |
| fortress               |  1.2500 |
| John (John K.)         |  1.2000 |
| pitipawn               |  1.1667 |
| jimbobway              |  1.0000 |
| Dervish                |  1.0000 |
| Drasek                 |  1.0000 |
| danuker                |  1.0000 |
| Stemby                 |  1.0000 |
| 2GOOD                  |  1.0000 |
| tfeagle                |  1.0000 |
| ziomik                 |  1.0000 |
| promankirov            |  1.0000 |
| notme                  |  1.0000 |
| ElectricMucus          |  1.0000 |
| randzzz                |  1.0000 |
| Xian01                 |  1.0000 |
| bushstar               |  1.0000 |
| DoktorKopf             |  1.0000 |
| DanielBTC              |  1.0000 |
| thefiniteidea          |  1.0000 |
| obit33                 |  1.0000 |
| hephaist0s             |  1.0000 |
| QuiveringGibbage       |  1.0000 |
| No_2                   |  1.0000 |
| Dimitry                |  1.0000 |
| yabtcl                 |  1.0000 |
| lavajumper             |  1.0000 |
| binaryFate             |  1.0000 |
| nov                    |  1.0000 |
| BitChick               |  1.0000 |
| Petr1fied              |  1.0000 |
| deadsea33              |  1.0000 |
| boondogger             |  1.0000 |
| sp383                  |  1.0000 |
| ghibly79               |  1.0000 |
| Fuserleer              |  1.0000 |
| walletrecoveryservices |  1.0000 |
| mogrith                |  1.0000 |
| tobasco                |  1.0000 |
| idoB                   |  1.0000 |
| Nerull                 |  1.0000 |
| kuroman                |  1.0000 |
| mthcl                  |  1.0000 |
| hunterwolf             |  1.0000 |
| daniobg                |  1.0000 |
| jl777                  |  1.0000 |
| metamorphin            |  1.0000 |
| Thingamajig            |  1.0000 |
| Mares                  |  1.0000 |
| synace                 |  1.0000 |
| popshot                |  1.0000 |
| TrollCoins             |  1.0000 |
| Errror                 |  1.0000 |
| rby                    |  1.0000 |
| lfloorwalker           |  1.0000 |
| dihydrogenmonoxide     |  1.0000 |
| BigWait                |  1.0000 |
| daschmidty             |  1.0000 |
| Cebuu                  |  1.0000 |
| rock_collector         |  1.0000 |
| Nefritox               |  1.0000 |
| svetoch                |  1.0000 |
| cryptobullion.io       |  1.0000 |
| 2tejszy                |  1.0000 |
| miguelmorales85        |  1.0000 |
| dive                   |  1.0000 |
| Mr_SeLeNiO             |  1.0000 |
| ParkByte               |  1.0000 |
| xxxxxzzzzz             |  1.0000 |
| avlarin56              |  1.0000 |
| bit22gen               |  1.0000 |
| Sniper44               |  1.0000 |
| grnqrtr                |  1.0000 |
| Unread                 |  1.0000 |
| 86-                    |  1.0000 |
| Phi-Coin               |  1.0000 |
| Videodrome             |  1.0000 |
| Alex4J                 |  1.0000 |
| obusco                 |  1.0000 |
| barisbilgili           |  1.0000 |
| Neo Baudrillard        |  1.0000 |
| drakonka               |  1.0000 |
| RedsC                  |  1.0000 |
| Pesmand                |  1.0000 |
| MikkiRefur             |  1.0000 |
| PokemonGoArena         |  1.0000 |
| TheBobyHunter          |  1.0000 |
| luckyluckybear         |  1.0000 |
| coinsmanager           |  1.0000 |
| co0ler                 |  1.0000 |
| efeaydin               |  1.0000 |
| star citizen           |  1.0000 |
| alex_mercer            |  1.0000 |
| ranacond               |  1.0000 |
| KualaBit               |  1.0000 |
| HakanYAZICI            |  1.0000 |
| dashxplorer            |  1.0000 |
| liubeibei520           |  1.0000 |
| theguy217              |  1.0000 |
| Hypocritus             |  1.0000 |
| charlescoin            |  1.0000 |
| packetsmurf            |  1.0000 |
| bruboi                 |  1.0000 |
| mararn1618             |  1.0000 |
| berkatmendrofa         |  1.0000 |
| Camineet               |  1.0000 |
| squishthedish          |  1.0000 |
| Hernandezz             |  1.0000 |
| silverbu11et           |  1.0000 |
| eBunny6                |  1.0000 |
| BaBaGucci              |  1.0000 |
| smcalister91           |  1.0000 |
| MrChicken1987          |  1.0000 |
| treather               |  1.0000 |
| robinson79             |  1.0000 |
| lorddefenser           |  1.0000 |
| SashaK                 |  1.0000 |
| flymnb                 |  1.0000 |
| smartash               |  1.0000 |
| Simon123               |  1.0000 |
| ilovestroberi          |  1.0000 |
| archer1969             |  1.0000 |
| Dropper                |  1.0000 |
| frenchBulle            |  1.0000 |
| Merderion              |  1.0000 |
| stoicphoenix           |  1.0000 |
| Mendrofa               |  1.0000 |
| Bumidinasty            |  1.0000 |
| kukurikapu             |  1.0000 |
| LindaQ                 |  1.0000 |
| jomidasma              |  1.0000 |
| appleffi               |  1.0000 |
| ragnar0k               |  1.0000 |
| kbdwarrior             |  1.0000 |
| vezt                   |  1.0000 |
| posmonkey              |  1.0000 |
| Str1x                  |  1.0000 |
| traktorbang            |  1.0000 |
| DeeMiner               |  1.0000 |
| e360                   |  1.0000 |
| berkatjunior           |  1.0000 |
| AlexPechkin            |  1.0000 |
| bennypagulayan         |  1.0000 |
| Kimyo                  |  1.0000 |
| Simonetta              |  1.0000 |
| Hunter#12              |  1.0000 |
| icoinspector           |  1.0000 |
| VazLorde               |  1.0000 |
| renriyon               |  1.0000 |
| Krypto Krecik          |  1.0000 |
| OliverChassa           |  1.0000 |
| Dextord                |  1.0000 |
| getzer                 |  1.0000 |
| TooSmartForBitcoin     |  1.0000 |
| crypto_flair           |  1.0000 |
| declan-                |  1.0000 |
| homi4oka               |  1.0000 |
| ICAMerlin              |  1.0000 |
| dogrutamamyaparimusta  |  1.0000 |
| LotusPetal             |  1.0000 |
| ennafa                 |  1.0000 |
| vadiara50              |  1.0000 |
| Derloda                |  1.0000 |
| Salranax               |  1.0000 |
| walhalla007            |  1.0000 |
| Pochakytek             |  1.0000 |
| Miningfarmer           |  1.0000 |
| arnew1                 |  1.0000 |
| monote                 |  1.0000 |
| Bitshare Hashaway      |  1.0000 |
| seanreit               |  1.0000 |
| diaahussein            |  1.0000 |
| Marteloto              |  1.0000 |
| hodlercoasterguy       |  1.0000 |
| vvoin                  |  1.0000 |
| Bapt07                 |  1.0000 |
| asiat123098            |  1.0000 |
| Rokhim                 |  1.0000 |
| davidrus123            |  1.0000 |
| batuh007               |  1.0000 |
| MaxKordek              |  1.0000 |
| spiffy_tycoon          |  1.0000 |
| CryptoTesla            |  1.0000 |
| totwotoo2              |  1.0000 |
| Mega2017               |  1.0000 |
| merszxc                |  1.0000 |
| hassan.shakeel.rajpoot |  1.0000 |
| Conquermountains       |  1.0000 |
| tizzle81               |  1.0000 |
| ANNBumping_needed      |  1.0000 |
| CryptozKeeper          |  1.0000 |
| Georgiano              |  1.0000 |
| BitcoinAtom            |  1.0000 |
| polza                  |  1.0000 |
| syavca                 |  1.0000 |
| CanadianMiner          |  1.0000 |
| publicjud1             |  1.0000 |
| mysonkovbereslava      |  1.0000 |
| Cointach               |  1.0000 |
| mahirovic              |  1.0000 |
| darecky                |  1.0000 |
| ThorbenS               |  1.0000 |
| kreeoz                 |  1.0000 |
| everton-1888           |  1.0000 |
| nasuhdede              |  1.0000 |
| orangepeel             |  1.0000 |
| DarkoReborn            |  1.0000 |
| coinshido              |  1.0000 |
| RonanLTC58             |  1.0000 |
| Cryptostrong           |  1.0000 |
| forward777             |  1.0000 |
| cryptosk8boreder       |  1.0000 |
| gexaha                 |  1.0000 |
| alan296                |  1.0000 |
| chessentric            |  1.0000 |
| Tobi97l                |  1.0000 |
| Milan_P                |  1.0000 |
| Scwimer                |  1.0000 |
| mswjec                 |  1.0000 |
| Wys-addict             |  1.0000 |
| MrGGates               |  1.0000 |
| DavidLutz              |  1.0000 |
| Cryptobitminer         |  1.0000 |
| aburnie                |  1.0000 |
| apolonn                |  1.0000 |
| Arpad977               |  1.0000 |
| Atalol                 |  1.0000 |
| m0rph3us7              |  1.0000 |
| flawlicious            |  1.0000 |
| kovaaz                 |  1.0000 |
| k453345                |  1.0000 |
| macioch                |  1.0000 |
| nicholashscott         |  1.0000 |
| MetropolisHastings12   |  1.0000 |
| rrgarcia555            |  1.0000 |
| Red Right Hand         |  1.0000 |
| chiquinho              |  1.0000 |
| abihey269              |  1.0000 |
| urBTCisMine            |  1.0000 |
| SMFSMF5555             |  1.0000 |
| EtherAndy              |  1.0000 |
| sky_rocker             |  1.0000 |
| AAIX                   |  1.0000 |
| abh1manyu              |  1.0000 |
| FlyingAce              |  1.0000 |
| I.Meet.Ya              |  1.0000 |
| mandymiller            |  1.0000 |
| EgonSpengler           |  1.0000 |
| MrFoxDeveloper02       |  1.0000 |
| rickybobby856          |  1.0000 |
| Tankie                 |  1.0000 |
| ChampionGold           |  1.0000 |
| RedSlayerX             |  1.0000 |
| Two-faced              |  1.0000 |
| Gordon___123           |  1.0000 |
| bbritva                |  1.0000 |
| prunsebas              |  1.0000 |
| OutSmartm              |  1.0000 |
| toxicpyjamas           |  1.0000 |
| bitrails               |  1.0000 |
| tenderwall             |  1.0000 |
+------------------------+---------+

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

The weekly tracking is an interesting idea.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 616
Merit: 2659

There are lies, damned lies and statistics. MTwain


View Profile WWW
April 24, 2018, 07:00:55 PM
 #9

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

The weekly tracking is an interesting idea.

If you need anything when you move on, let us know.

The weekly stat is straight from the merit.txt file. For now it is still all included in the 120 day range of the file, although I guess you work directly on the DB so the 4 month limit is not an issue.  The mayor difficulty is calculating the nFromNew and nToNew.

In SQL it would be something like:

Code:
select datepart(week,converted_date) Week, sum(amount) nMerit, count(*) nTx, count(distinct user_from) nFrom, t2.nFromNew, count(distinct user_To) nTo, t1.nToNew
from MERIT m1,
(
select datepart(week,converted_date) Week, count(distinct user_To) nToNew
from MERIT m1
where not exists (select 1 from MERIT m2 where m2.user_to = m1.user_to  and  datepart(week,m2.converted_date) <  datepart(week,m1.converted_date))
group by  datepart(week,converted_date)
) t1,
(
select datepart(week,converted_date) Week, count(distinct user_from) nFromNew
from MERIT m1
where not exists (select 1 from MERIT m2 where m2.user_from = m1.user_from  and  datepart(week,m2.converted_date) <  datepart(week,m1.converted_date))
group by  datepart(week,converted_date)
) t2
where datepart(week,m1.converted_date) = t1.week
and t1.week = t2.week
group by  datepart(week,converted_date) , t1.nToNew, t2.nFromNew
order by 1 desc

That's the base. The % ratios are derived in my excercise on the worksheet.

You're right. sMerit awarded to posts existing prior to merit kick off would be a bummer and should probably be excluded from calculations, although then it won´t read all the reality to a 100% degree of accuracy.

d_eddie
Hero Member
*****
Offline Offline

Activity: 812
Merit: 673



View Profile
April 24, 2018, 08:30:06 PM
 #10

I’m not sure if the OPs intention in this post is limited to personal indicators, or global stats too. Some simple global indicators in addition to the currently shown could be in the line of:

I was thinking of a personal indicator to be shown under the user's name, along with username, rank, activity and merit. This could be useful both to gauge new faces popping up in discussion, and as an incentive to self improvement.

A major statistical difficulty which I remembered when gathering these is that a lot of people receive merit for pre-merit posts. (Though people who made zero post-merit posts were excluded in the above stats.)

Gathering these stats is slow. It could be tracked live per user, but I'd have to add a lot of caching at various points. I'm probably not going to do it.

Speaking for myself, I'd be glad to suffer some inaccuracy as a tradeoff for server load. Posts created before merit inception should asymptotically go to zero significance anyway. And any 1-D statistic is bound to be inaccurate under the right (wrong?) circumstances. I imagine striking a balance between ease of gathering/computation and capture of useful data is a difficult job in this case.

The weekly tracking is an interesting idea.

It is, even if it only speaks about the overall flow, not about single users. I brought up the last statistic
Code:
(4) latest_merit_increment/latest_activity_increment
(where both increments are within the same 14-day period)

just because I thought that, even if packing less insight, it wouldn't burden the server as much as EMEP. If the number of posts in that period is easy to determine, it would make for a better denominator IMO.

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!