CGC Grading Contest Awards Based on Cumulative Performance Through Contest #9 4 4

[Superman2006]

On 4/21/2024 at 4:11 PM, Superman2006 said:

On 4/21/2024 at 3:55 PM, AnthonyTheAbyss said:

May I ask what you use to analyze the data?  Excel?  Pen/Paper/Caluclator?  Just wondering if there's a way to make this easier or automated since this is great information to have and I would hate to see it stop.

 

***I love excel

I use Excel. I'm a big fan of Excel and I've been using it forever; well at least since I switched over to it from Lotus 123 back in the late 90's.

It doesn't take that long to put together; I think it took about 2.5 to 3 hours to prepare from start to finish this past time, which I don't think is that bad (I have a lot of checks that I perform to ensure accuracy). It is a fairly automated process already; there are some minor things that could be done to speed it up (data wise, and preparation wise), but probably not enough time savings to make it worth the additional effort.

Since it sounds like you and a number of folks would like me to continue publishing the cumulative rankings, I'll plan to keep doing so going forward. 

For anyone not interested in how the sausage is made, feel free to skip this post  

For AnthonyTheAbyss and any others that are interested in my process, the following covers most of my cumulative rankings update steps:

(a) locate the prior rounds results threads (I'll probably do that right after each round going forward)

(b) copy and paste the data into Excel, with one tab for each round,

(c) then reformat all names to remove any trailing spaces, etc., identify new participants, check them against participants through the first 8 rounds, and make sure that there weren't any inadvertent name changes in the contest summaries (e.g. in the past, "TheGeneral" might have participated in past contests, but then one contest there might have been an entrant of "The General", which was really the same entrant, and so when that was brought to my attention, I tweaked the checks that I was performing for any new entrants to make sure the name didn't have a typo in it, and I fixed the typo in my spreadsheet. I can't remember for sure if it was TheGeneral or some other name with a space issue in the middle of the name, but you get the idea; there weren't any name issues like that this past contest and maybe not in other recent contests, but I still check for it)

(d) for each round, given everyone's grades by book, I calculate my own scores for each participant and check the totals Mike comes up with

(e) compile all results for the current contest into a single tab, with one row for each entrant, regardless of whether they completed 1 round or 4 rounds in the current contest (this and all other steps are fairly automated; since CGC Mike started posting results in a format that I can copy / paste into Excel there isn't any manual data entry; just the occasional manual data correction, but even that is rare in recent contests.  Any manual inputs I performed to pull in some of the results from the early contests were double-checked for accuracy, plus like I mentioned earlier, I calculate everyone's scores in my spreadsheet, and so I then checked my totals against Mike's totals for everyone).

(f) bring in results for all participants for the current round into an aggregate tab that includes results for all participants to date for every book / round / contest to date. This is the tab that I then use to apply filters / prepare rankings, etc.

 

 

Edited April 21 by Superman2006
minor tweak

[Lninefingers]

This is really cool to see, thanks. 

Looks like I just missed the cut with only 16 rounds completed, but maybe if I can keep my head above water (dubious, given how I feel about this first round) this contest I can make the list next time. 

[Kramerica]

On 4/20/2024 at 5:47 PM, Superman2006 said:

Thanks, buddy!

It takes a few hours to put it all together with a lot of data checks throughout to account for any data issues (there haven't been many in recent contests thanks to good work by CGC Mike and Get Marwood & I) and to perform other cross-checks, so it's not an incredible amount of work. Maybe I'll keep updating it in the future, if more people want it than not.  Holding off on publishing it until the start of the next contest like I did this time does give me more freedom to update it at my convenience.

 

This is so cool. Thanks Supes! I for one would love you to continue to do this and I think that we - those who participate in the grading contest - should start a fund for you as a way of saying thanks. Enough for you to go buy something nice for yourself in the Marketplace here 

[Superman2006]

On 4/22/2024 at 4:32 PM, Kramerica said:

On 4/20/2024 at 8:47 PM, Superman2006 said:

Thanks, buddy!

It takes a few hours to put it all together with a lot of data checks throughout to account for any data issues (there haven't been many in recent contests thanks to good work by CGC Mike and Get Marwood & I) and to perform other cross-checks, so it's not an incredible amount of work. Maybe I'll keep updating it in the future, if more people want it than not.  Holding off on publishing it until the start of the next contest like I did this time does give me more freedom to update it at my convenience.

 

This is so cool. Thanks Supes! I for one would love you to continue to do this and I think that we - those who participate in the grading contest - should start a fund for you as a way of saying thanks. Enough for you to go buy something nice for yourself in the Marketplace here 

Thanks, Kramerica!

I had recalled at least one negative comment in the past from someone that didn't care for some of my cumulative rankings (and sometimes for every one complaint there are more that feel the same way), but based on the feedback in this thread, I plan to continue updating the cumulative rankings going forward. It's worth the effort to me since it sounds like more people enjoy the rankings and other stats I provide than not. 

I really appreciate the gesture, but I would request that no fund be started on my behalf. Similar to the efforts from @CGC Mike, @Get Marwood & I and @zzutak, and everyone that comment in the grading threads (I'm usually more of a reader than a commenter lol), I'm just trying to chip in, in some way. Just consider this my little contribution to the boards!

Edited April 22 by Superman2006

[boron]

I appreciate the effort - thanks for the stats !

 

[Axelrod]

Where would I be if I had skipped out on that one really bad contest!

Or, maybe it was more than one bad one actually.  I can't even remember. 

I usually have (at least) one really bad round, I remember that!

Still, these are fun!

[Superman2006]

On 4/22/2024 at 9:25 PM, Axelrod said:

Where would I be if I had skipped out on that one really bad contest!

Or, maybe it was more than one bad one actually.  I can't even remember. 

I usually have (at least) one really bad round, I remember that!

Still, these are fun!

You'd have a 22.5 average if not for your worst two rounds of 35 (rounds 2 and 7).

Your best score was a 2 (in contest #1 and again in contest #8); your worst was a 15 in contest #7. Your 2nd worse was a 13 in in contest #4; you had just 11 total points across the other 3 rounds in that contest!

[Superman2006]

I only started publishing Rookie of the Year winners after Contest #8, if I recall correctly.

Here are the Rookie of the Year winners for all contests to date:

Honorable mention to others that did well in their first outing, especially those in the first contest (including @Motor City Rob who had a 14) as that was the toughest contest to win RoY, as it included the legendary @Squirrel Guy (who would be ranked first overall if he had enough qualifying rounds and maintained his current average over 3 rounds), and many other top ranked graders, including three that are currently in the top ten cumulative rankings (@jbpez, @Point Five and @zzutak).