Topic: Homage the Bitcointalk Heroes - monthly spotlight to local quality posters (Read 619 times)

I do use the @DdmrDdmr Merit Dashboard as a kind of search engine for quality posts which might be worth reading.

I can only recommend you to try it yourself using Most merited Posts/Threads

I came across your post  in our LB and I must say you did well on summing up post, sometimes I imagine how come you manage to seek all those quality post or despite they aren't your language. Do you used a kind of translator to read and study how quality those posts are, except for my local board that are mostly being mixed with simple english that can be readable by anyone if not in Pidgin language which I know many people from external board are becoming more familiar to read them since some of our brothers often translate it to simple english.

I took me a while on finding out my way to go. First evaluation was made for August, when Ratimov was international highscorer. I switched then to evaluation for local boards because of redundance to bitcointalks internal meta statistics.

Finally i decided to rank the local leaderbords depending on merit/post ratio to present some more unknown names.
The evaluations for october is the final stand for now.

Hadn't notice this thread before, and it's a nice tribute to merit-earners on the local boards.  It's not like it keeps me up at night, but I've often worried that there hasn't been enough merits circulating in them, and the problem when that happens is that members with lousy English skills start making posts in the main sections that are of generally low quality. 

Just curious since I have now seen the list(s) here: Ratimov being at the top, is that now going to be considered highly controversial or what?  I'm also wondering if, after the various threads that have been created about him as of late, whether he's going to continue to be a top merit earner or not.  Time will tell, and this isn't the thread to start a discussion about that but I think it's more than appropriate to ask the question here.

Props, OP.

With a little delay i started my evaluations for October for 3 major local boards:
Pyccкий (Russian)
Deutsch (German)
Nigeria (Naija)

Thanks again, everything works fine!
I wondered that it works even without table .. /table at the beginning / end.

Anyway i am ready now to provide some more / better local evaluations for September when the month is over.

You can create a trailing column in Excel that creates each row, concatenating all the BBCode and fields per row.

i.e.
The above would be the constructor (Excel formula) for a given row on your last table, rendering the following result when extended to the first four rows + hearers in Excel (which I then copied here):

Rank	Username	|	local Merit	local Posts	Merit/Post	|	(all Merits)
______	__________	|	__________	_________	__________	|	__________
1.	Ratimov	|	221	249	0,8876	|	(450)
2.	jokers10	|	124	195	0,6359	|	(182)
3.	internetional	|	121	92	1,3152	|	(121)
4.	klarki	|	100	173	0,578	|	(100)

Just use the formula in the code structure and adapt it at will. Then extend it to all the column in Excel. The only additional things you’d need to do are:

-   Use the account’s url instead of the name I used (as you did before in your table) -> Column A
-   Add the table constructors at the beginning and end (perhaps manually when creating the post itself)
-   You may have to play around with the numbers enclosed in parenthesis, in order to avoid Excel displaying them in the extra column as negative numbers when using the above formula.

Thanks a lot @DdmrDdmr , that was a big step forward.

The tables now look like this:

Rank	Merit	Author	Post
______	______	_____________	____________________________________________________________
1.	59	Ratimov	Энциклoпeдия No-KYC Exchange
2.	28	Apytioh	Re: WorldCoin - нoвый xaйп или лoxoтpoн?
3.	22	delfastTions	Bitget - биpжa дepивaтивoв
4.	22	UniJoin	Re: 👤 [banned mixer] | Baшa aнoнимнocть - нaш пpиopитeт | CoinJoin 👤
5.	22	internetional	Re: Пoтpeбитeльcкиe cвoйcтвa биткoинa
6.	22	zasad@	tornado.cash aнoнимнocть ETH
7.	22	jokers10	Бayнти для биткoйн-paзpaбoтчикoв
8.	22	sompitonov	Дaшбopды для RetroHunt'a
9.	22	witcher_sense	ЦБ PФ зaщитит poccиян oт Биткoинa
10.	17	safar1980	eXch-мгнoвeнный oбмeн BTC / XMR / LTC / ETH / ERC20
11.	15	GrLinkey	Paccyждeния o вeчнocти биткoинa
12.	14	TopTort777	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
13.	12	Ratimov	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
14.	12	tvplus006	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
15.	12	icopress	Re: Taблицa Пoдпиcныx Кaмпaний зa Bitcoin
16.	11	light_warrior	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
17.	11	sompitonov	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
18.	11	xandry	TRON - дeцeнтpaлизoвaнный интepнeт
19.	11	jokers10	Бyмaжныe биткoйны. Биткoйнoв бoльшe, чeм 21 м
20.	10	klarki	Re: PokerTon - игpaй в пoкep бeз KYC! Eжeнeдeльный фpиpoлл
21.	10	The0ldl_lser	Re: Myзыкa
22.	10	FS2018	Re: Пpocтaя cтpaтeгия тopгoвли кpиптoй
23.	10	FS2018	Пpocтaя cтpaтeгия тopгoвли кpиптoй
24.	9	internetional	LNP2PBOT - oбмeны p2p нa мoлнии (Lightning Network)
25.	8	internetional	Kucoin oткpывaeт тopги
26.	8	internetional	Re: Пoтpeбитeльcкиe cвoйcтвa биткoинa
27.	7	jokers10	Ark — пpoтoкoл втopoгo ypoвня для биткoйнa
28.	7	Cryptmuster	Merit Circle - нoвaя экoнoмикa в мeтaвceлeннoй
29.	7	jokers10	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!
30.	7	Etranger	Re: [ЛOГ] Пoльзoвaтeли, пoвыcившиe cвoй paнг - Пoздpaвлeния!

and this:

Rank	Username	|	local Merit	local Posts	Merit/Post	|	(all Merits)
______	__________	|	__________	_________	__________	|	__________
1.	Ratimov	|	221	249	0,8876	|	(450)
2.	jokers10	|	124	195	0,6359	|	(182)
3.	internetional	|	121	92	1,3152	|	(121)
4.	klarki	|	100	173	0,5780	|	(100)
5.	sompitonov	|	99	39	2,5385	|	(100)
6.	light_warrior	|	54	50	1,0800	|	(151)
7.	witcher_sense	|	49	70	0,7000	|	(52)
8.	Julien_Olynpic	|	47	196	0,2398	|	(47)
9.	zasad@	|	46	39	1,1795	|	(60)
10.	FS2018	|	45	52	0,8654	|	(45)
11.	delfastTions	|	43	69	0,6232	|	(52)
12.	Etranger	|	40	92	0,4348	|	(76)
13.	Smartprofit	|	39	308	0,1266	|	(40)
14.	safar1980	|	38	101	0,3762	|	(41)
15.	Apytioh	|	36	25	1,4400	|	(36)
16.	Cryptmuster	|	32	40	0,8000	|	(35)
17.	tw0.625	|	30	458	0,0655	|	(32)
18.	Inwestour	|	29	99	0,2929	|	(30)
19.	Polkeins	|	27	65	0,4154	|	(27)
20.	TopTort777	|	27	20	1,3500	|	(32)
21.	baeva	|	25	45	0,5556	|	(25)
22.	madnessteat	|	25	40	0,6250	|	(25)
23.	satscraper	|	25	26	0,9615	|	(56)
24.	The0ldl_lser	|	24	150	0,1600	|	(24)
25.	UniJoin	|	23	3	7,6667	|	(80)
26.	Unsoldier	|	23	38	0,6053	|	(23)
27.	xandry	|	23	13	1,7692	|	(27)
28.	dwyane36	|	22	51	0,4314	|	(22)
29.	BVeyron	|	21	30	0,7000	|	(21)
30.	Goran_	|	20	32	0,6250	|	(20)

Now i can copy data into excel and the tables are generated by itself.

Last step is the conversion from excel to html tables for bitcointalk.
Is there maybe a smart way to do this within excel itself, so that 3rd party excel-html converter are not necessary?

You can use VLOOKUP in Excel to do the matching. For example, I’ve copied the data from your table above and pasted it into Excel, and the added a trailing column with the following formula (inserted in cell I2, and then extended throughout all the I column):
The column will display the number of posts for each entry in column F (second Name column).

What it does is search for value of cell F2 (Ratimov in the second Name column) within the range of data conformed by columns B (Name) and C (Number of posts). If it finds a match, it returns the value on column C (second column in the range B:C, thus the 2 in the formula) related to the match (249 posts). False performs an exact match. The IfError function returns a blank if no match is found.

Of course, using the data from your table, it only matches about 50% of the entries (those that are matchable).

See for example: https://www.perfectxl.com/excel-glossary/how-to-use-vlookup-excel/


In Ninjastic, you can ask for the UserId to be part of the post count output:
Then simply create a column in your Excel that concatenates the UId column to a fixed value of:
"https://bitcointalk.org/index.php?action=profile;u="

Okay, now I know where's your issue. You are taking both sets of data from different sites (ninjastic.space and Merit Dashboard) and since each data point is in a different "position" in your Excel file, it's extremely difficult to link these data points.
Probably, it's best to keep your table as it is but not sure here, if it's just too time consuming anyways. It's up to you if you want to offer such a table as it is (from your example above).
  

Unfortunately, I'm not a coder, so I can't help. 
But maybe a coder will chime in here and give his opinion how to solve it. 

Ok, lets dive into the process using the example of the russian Board:

Rank	Name	Number of Posts	|	Rank	Name	RU Merits	(all Merits)
______	______________	______________	|____	______	______________	____________	__________
1.	tw0.625	[458]	|	1.	Ratimov	221	(450)
2.	Smartprofit	[308]	|	2.	jokers10	124	(182)
3.	Ratimov	[249]	|	3.	internetional	121	(121)
4.	Julien_Olynpic	[196]	|	4.	klarki	100	(100)
5.	jokers10	[195]	|	5.	sompitonov	99	(100)
6.	klarki	[173]	|	6.	light_warrior	54	(151)
7.	The0ldl_lser	[150]	|	7.	witcher_sense	49	(52)
8.	Snork1979	[147]	|	8.	Julien_Olynpic	47	(47)
9.	fruktik	[120]	|	9.	zasad@	46	(60)
10.	bonfire66	[110]	|	10.	FS2018	45	(45)
11.	safar1980	[101]	|	11.	delfastTions	43	(52)
12.	Inwestour	[99]	|	12.	Etranger	40	(76)
13.	Etranger	[92]	|	13.	Smartprofit	39	(40)
14.	internetional	[92]	|	14.	safar1980	38	(41)
15.	leonello	[92]	|	15.	Apytioh	36	(36)
16.	be.open	[91]	|	16.	Cryptmuster	32	(35)
17.	3meek	[73]	|	17.	tw0.625	30	(32)
18.	witcher_sense	[70]	|	18.	Inwestour	29	(30)
19.	delfastTions	[69]	|	19.	Polkeins	27	(27)
20.	Polkeins	[65]	|	20.	TopTort777	(32)	(14)
21.	Olgacom	[61]	|	21.	baeva	25	(25)
22.	Klyubov 86	[60]	|	22.	madnessteat	(25)	(13)
23.	bakasabo	[59]	|	23.	satscraper	(56)	(11)
24.	mak013	[59]	|	24.	The0ldl_lser	24	(24)
25.	Warrior Dance	[57]	|	25.	UniJoin	23	(80)
26.	TrinityS	[56]	|	26.	Unsoldier	(23)	(156)
27.	lutik378	[55]	|	27.	xandry	(27)	(10)
28.	Zesarius	[53]	|	28.	dwyane36	22	(22)
29.	FS2018	[52]	|	29.	BVeyron	21	(21)
30.	olgakyzmina	[52]	|	30.	Goran_	20	(20)

Within this table there are 3 different Leaderboards:
- russian post leaderboard comes from ninjastic.space
- russian merit leaderbord comes from merit dashboard
- to get the last column i need to feed the merit dashboard with the names from the 2nd leaderboard and switch to all boards, the names are now the same but the order is different (sorted downwards by all merits) -> i need to reorder them manually which took me nearly as much time as getting the data for 1st + 2nd leaderbord

With merit/post ratio it would be even worse. Imagine a range from shitposter (Top10 per post but >100 by merit) to quality poster (Top10 by merit but >50 by postrate). To get a Top30 list you need to go down until maybe 100 in the other list to find everyone, which means beetween the matches you have twice as much names to sort out. The problem here is that data is linked one by one which is very time consuming adding not much additional value. I don't know, maybe it is possible with excel to match the names atomaticly?

Same with profile link which i need to gather manually one by one by clicking each post. Of course i would apreciate to provide those data too, but within my process these are the data with the least automation.    

If you can help me to improve my process and solve those problems, i will enjoy to implement some more columns or data.

Great work and good effort, thank you for it. It is good to have a Leaderboard for Bitcoin Talk heroes who provided the best constructive posts during the month. This will be a strong incentive for all members to give their best to be on the Leaderboard.

It can be improved slightly by adding the profile link as mentioned above, as well as adding a column next to each hero showing the number of posts during the month, and if possible also the post that received the highest merit for each hero.

It would also be helpful to make a Leaderboard similar to local boards.

Of course, I can totally understand you because I can imagine it is really difficult...
I just meant an additional column for Merit per post ratio for that specific board.
I don't know if it's possible to copy it from Excel because in Excel itself, it's possible to calculate Merit/Post [=[column number of merit]/[column number of posts]] easily.


Interesting idea. 
Maybe people can request statistics for their local board here, always assuming it's not too much work for you because we have quite a lot of local boards on Bitcointalk...

I tried to implement it here as well, but as i am not a programmer i am limited to the data of @DdmrDdmr Merit Dashboard and @TryNinja Ninjastic.space

Regarding the post count leaderbord, it's possible for local boards but in the international area Bitcoin Diskussion, Marketplace, Development & technical Discussion, Economics and Trading Discussion each count as different Boards in Ninjastic.space which i can't easily join together.

---

Taking your feedback into account i guess these kind of evaluation adds most additional value if it's done for the different local boards, because:
- then it is not redundant with meta statistics
- i can easily add post count leaderbord
- it spotlights local quality posters and not only the "big names"

The leaderbord for Top-merited recent replies would look the same.
As an example what the leaderbord for Users regarding post count and received merits looks like i want to add this part from my last evaluation for the local german board:

Rank	Name	Number of Posts	|	Rank	Name	DE Merits	(all Merits)
______	______________	______________	|____	______	______________	____________	__________
1.	Turbartuluk	[141]	|	1.	Turbartuluk	129	(133)
2.	bullrun2020bro	[132]	|	2.	bullrun2020bro	90	(214)
3.	cygan	[96]	|	3.	1miau	62	(111)
4.	Lakai01	[72]	|	4.	Real-Duke	55	(55)
5.	5tift	[70]	|		virginorange	55	(55)
6.	1miau	[65]	|	6.	Lakai01	54	(54)
	Buchi-88	[65]	|	7.	icopress	49	(280)
8.	Real-Duke	[64]	|	8.	cygan	43	(196)
9.	bct_ail	[57]	|	9.	willi9974	35	(35)
10.	willi9974	[48]	|	10.	seek3r	33	(53)
11.	Unknown01	[47]	|	11.	MinoRaiola	29	(29)
12.	Soonandwaite	[40]	|	12.	Buchi-88	22	(23)
13.	MinoRaiola	[38]	|	13.	5tift	21	(21)
14.	AHOYBRAUSE	[35]	|	14.	AHOYBRAUSE	20	(31)
15.	Koal-84	[34]	|		d5000	20	(90)
16.	seek3r	[33]	|	16.	sam00	19	(19)
17.	Lafu	[27]	|	17.	Koal-84	18	(18)
18.	lassdas	[19]	|	18.	Cricktor	17	(52)
19.	mole0815	[18]	|		Lafu	17	(22)
	virginorange	[18]	|	20.	Danydee72	14	(14)
21.	d5000	[16]	|	21.	bct_ail	13	(14)
22.	Etranger	[13]	|		mole0815	13	(13)
23.	mv1986	[13]	|	23.	Soonandwaite	11	(11)
24.	Danydee72	[12]	|	24.	lassdas	8	(8 )
25.	Cricktor	[9]	|	25.	Etranger	7	(21)
	nullCoiner	[9]	|		GazetaBitcoin	7	(156)
27.	Kryptowerk	[8]	|	27.	mv1986	6	(10)
	WillyAp	[8]	|		nullCoiner	6	(6)
	citb0in	[8]	|		Pascal Parvex	6	(6)
30.	Acura3600	[7]	|		Serpens66	6	(6)
					Unknown01	6	(6)

---

If you find those evaluations somewhat helpful, i could offer that for your local board as well.

PS: Title of OP was renamed to correct orientation of the thread.

It may be correct to rename the title of OP to make it capture that the statistics is monthly and then you can try to be updating this thread monthly. It is a nice thread and people who are at the top of the list are well known contributors in the forum. No doubt they are quality posters. I would have appreciated the thread more if it was intended to discover newbie quality posters but good enough LoyceV has a thread that discovers newbie quality posters. He named it "The future of bitcointalk "

In general any post that encourages quality posts is encouraging and as long as I know 1miau is know for making such kinds of post.

Ok, I didn't know it's for the last 30 days because it's still not working for me to load (most of) Bitcointalk's internal statistics for whatever reason. 
From what you've posted in our German sectionI really liked your additional column (in your second table) of how many posts each member made during that period (it's a good indicator of Merit per post ratio).
I don't know how much work it is to do, maybe it's also an idea to add some more columns here as well but on the other hand, it might get messy quickly and is mostly suited for our German section.

Okay good then, though never knew you already  noticed to add them but just what i saw decided to share idea but since you said of editing then the is good.

Both suggestions i had in mind before but due to limited time yesterday i classified them als "nice to have".
Maybe i will edit opening post to add them later.


Thanks for the hint, i did not know these statistics. The Top-merited users, recent merit works with the last 30 days, so this TOP-50 leaderbord is some kind redundant to the leaderboard presented here (the latter one could be seen as some kind of dokumentation).

I guess it's the same for Top-merited recent replies.  

As said in our German section already, where Turbartuluk has presented it as well, it's a nice list of recently most merited posts.

We have also some interesting stats here, in Meta statistics: https://bitcointalk.org/index.php?action=merit;stats
(as far as I know, "recent" means 120 days, for some reason site doesn't load currently...)

Unfortunately, I can't send enough Merit to OP because Turbartuluk is one of the few members of our German board, who's contantly delievering quality posts and reached his limit of 50 Merit already:

But it's noted and will be taken care of later. 

Hey Turbartuluk nice highlight, i want to suggest you also includes their profile link to those people mentioned about and also includes that of those who got the top 50 quality post this makes it easier for people to identify those with quality posts eve without having to click on their posts directly so other user can easily take note of them as i know this could also enable some people take records of those users.