ChiefsPlanet - View Single Post - ChiefsPlanet New Feature: Up/Down Voting Posts

**DaFace** · 06-25-2023, 09:58 AM

I've been using ChiefsPlanet to practice some newfound SQL "skills" (using ChatGPT as a crutch), and I thought it might be fun to dig into the Helpful Answers votes. So here are a bunch of "Top (or bottom) 10 Lists" based on various criteria. All of these are filtered to only include people who have posted at least 100 times in the past year, and all figures only look at posts made in the past year.

Most active givers (total votes given):

Code:

htismaqe		23668
MarkDavis'Haircut	15245
DRM08			8172
Chris Meck		6739
Lzen			6469
Bowser			5659
Chief Ten Beers		4797
TEX			4738
Imon Yourside		4020
Spott			4003

Most active receivers (total votes received):

Code:

Hammock Parties	6645
DJ's left nut	5868
smithandrew051	5529
staylor26	5488
The Franchise	4837
Bearcat		4801
htismaqe	4774
Jewish TLO	4676
Rain Man	4534
TwistedChief	4241

Highest positivity ratio (% of votes that are positive):
This isn't SUPER interesting since a lot of these folks just haven't posted enough to be controversial, but I did restrict this to people who have received at least 100 votes, so it at least is an indication of people who generally don't suck.

Code:

TinyEvel		100.00%
Perineum Ripper		100.00%
PattyFlakes		100.00%
AustinChief		100.00%
Shiver Me Timbers	100.00%
Mosbonian		100.00%
Nightfyre		100.00%
IA_Chiefs_fan		100.00%
Peter Gibbons		99.72%
Bwana			99.63%

Lowest positivity ratio (% of votes that are positive):

Code:

straycash	8.58%
Quesadilla Joe	9.83%
GROB		10.39%
oaklandhater	17.48%
bsroyals54	25.00%
JustDiqLix	25.28%
dolphinsneu	40.29%
R8RFAN		43.00%
rfaulk34	43.19%
UChieffyBugger	48.28%

Highest "signal-to-noise" ratio (net votes per post):

Code:

Jewish TLO	2.11
LoneWolf	1.75
TwistedChief	1.60
FAX		1.48
TinyEvel	1.47
HayWire		1.40
kysirsoze	1.39
OnTheWarpath15	1.37
DaFace		1.33
Dartgod		1.31

Lowest "signal-to-noise" ratio (net votes per post):
There's a bit of a caveat here that you can't vote on posts in DC, so this is pretty much just a list of DCers who never post anything of value outside of that. Still, I think it's interesting to see...

Code:

Snopes Hammer	0.00
Over Yonder	0.00
NinerDoug	0.00
Taco John	0.01
True North	0.01
El Lobo Gordo	0.01
Just Passin' By	0.01
Pogue		0.01
Loneiguana	0.01
Pennywise	0.02

Anyway, this is just for fun, but I do think some of it's interesting...

06-25-2023, 09:58 AM	#275
DaFace Kind of a mod Join Date: Aug 2005 Location: Donkey Land Casino cash: $1966899	I've been using ChiefsPlanet to practice some newfound SQL "skills" (using ChatGPT as a crutch), and I thought it might be fun to dig into the Helpful Answers votes. So here are a bunch of "Top (or bottom) 10 Lists" based on various criteria. All of these are filtered to only include people who have posted at least 100 times in the past year, and all figures only look at posts made in the past year. Most active givers (total votes given): Code: htismaqe 23668 MarkDavis'Haircut 15245 DRM08 8172 Chris Meck 6739 Lzen 6469 Bowser 5659 Chief Ten Beers 4797 TEX 4738 Imon Yourside 4020 Spott 4003 Most active receivers (total votes received): Code: Hammock Parties 6645 DJ's left nut 5868 smithandrew051 5529 staylor26 5488 The Franchise 4837 Bearcat 4801 htismaqe 4774 Jewish TLO 4676 Rain Man 4534 TwistedChief 4241 Highest positivity ratio (% of votes that are positive): This isn't SUPER interesting since a lot of these folks just haven't posted enough to be controversial, but I did restrict this to people who have received at least 100 votes, so it at least is an indication of people who generally don't suck. Code: TinyEvel 100.00% Perineum Ripper 100.00% PattyFlakes 100.00% AustinChief 100.00% Shiver Me Timbers 100.00% Mosbonian 100.00% Nightfyre 100.00% IA_Chiefs_fan 100.00% Peter Gibbons 99.72% Bwana 99.63% Lowest positivity ratio (% of votes that are positive): Code: straycash 8.58% Quesadilla Joe 9.83% GROB 10.39% oaklandhater 17.48% bsroyals54 25.00% JustDiqLix 25.28% dolphinsneu 40.29% R8RFAN 43.00% rfaulk34 43.19% UChieffyBugger 48.28% Highest "signal-to-noise" ratio (net votes per post): Code: Jewish TLO 2.11 LoneWolf 1.75 TwistedChief 1.60 FAX 1.48 TinyEvel 1.47 HayWire 1.40 kysirsoze 1.39 OnTheWarpath15 1.37 DaFace 1.33 Dartgod 1.31 Lowest "signal-to-noise" ratio (net votes per post): There's a bit of a caveat here that you can't vote on posts in DC, so this is pretty much just a list of DCers who never post anything of value outside of that. Still, I think it's interesting to see... Code: Snopes Hammer 0.00 Over Yonder 0.00 NinerDoug 0.00 Taco John 0.01 True North 0.01 El Lobo Gordo 0.01 Just Passin' By 0.01 Pogue 0.01 Loneiguana 0.01 Pennywise 0.02 Anyway, this is just for fun, but I do think some of it's interesting...
Posts: 51,814	8 0