tOfficial 2024 HooplaNation Deadpool Results and Standings Thread

Well, Cale Yarborough couldn’t hang on for one more day, and died this morning. RIP, but gotta update my list now, @Guy Incognito

Jimmy Carter, 10
Pat Boone, 9
Kris Kristofferson, 8
Bobby Allison, 7
Willie Nelson, 6
Alan Jackson, 5
Willie Mays, 4
Bobby Cox, 3
Dick Vitale, 2
Sterling Marlin, 1
I had Bobby Allison. Gets me 3 on the year
 
No one's caught Dole yet, but we do have a shakeup in the standings below him as we near the finish line.


@Dolemite censored, 4, 333, 13
@Illustrious Potentate, 3, 267, 19
@MrFlyingV, 2, 137, 14
@steelerssb, 2, 140, 13
@Handicappers, 2, 141, 12
@huskers1217, 2, 145, 8
@Mofo, 2, 146, 16
@outofyourmind, 2, 150, 9
@GhostRider, 2, 151, 17
@Grant Ward, 2, 187, 10
@ill, 2, 187, 8
@Wingsauce7, 2, 192, 13
@Guy Incognito, 1, 53, 3
@moxie, 1, 53, 3
@Wood20ks, 1, 92, 9
@olympicoscar, 1, 93, 7
@fordman84, 1, 94, 6
@PnkPanther, 1, 94, 2


Everyone on @RP-29's list is still alive and kicking.
 
I just need Britney Spears to do me a solid so I can ice this thing. C'mon Britney!
 
How did you set up the spreadsheet(s)/database?
I put in people's picks, then dump in wikipedia data, move the Wiki data to columns, then vlookup. I try to double check for spelling errors up front, but some slip through.
 
I put in people's picks, then dump in wikipedia data, move the Wiki data to columns, then vlookup. I try to double check for spelling errors up front, but some slip through.


vlookup date of death. I never would have thought about using the wiki data. Nifty.
 
vlookup date of death. I never would have thought about using the wiki data. Nifty.
I match name on the list to wiki names, then pull back ages. My pivot is the poster, celeb name, confidence points, and then age. It can be a pain in the balls dealing with typos or with royalty titles.
 
I'd be inclined to set up a simple database. Chosen names in a table with 1 to many to a table with the selecting posters.
Death dates table in a 1 to 1 with to the chosen names table.

The trick is pulling in the continuing death dates to keep current.
 
I'd be inclined to set up a simple database. Chosen names in a table with 1 to many to a table with the selecting posters.
Death dates table in a 1 to 1 with to the chosen names table.

The trick is pulling in the continuing death dates to keep current.

If that didn't work, I'd try something else.
 
I'd be inclined to set up a simple database. Chosen names in a table with 1 to many to a table with the selecting posters.
Death dates table in a 1 to 1 with to the chosen names table.

The trick is pulling in the continuing death dates to keep current.
I could probably try and figure out how to do API calls to Wiki to update the database, but I'm not that level of nerd.
 
Jimmy Carter brings us a change to the top spot!


@outofyourmind, 4, 303, 26
@Dolemite censored, 4, 333, 13
@MrFlyingV, 3, 237, 24
@steelerssb, 3, 240, 23
@Handicappers, 3, 241, 22
@huskers1217, 3, 245, 18
@Mofo, 3, 246, 26
@GhostRider, 3, 251, 27
@Illustrious Potentate, 3, 267, 19
@Grant Ward, 3, 287, 20
@ill, 3, 287, 10
@Guy Incognito, 2, 153, 13
@moxie, 2, 153, 13
@Wood20ks, 2, 192, 19
@Wingsauce7, 2, 192, 13
@olympicoscar, 2, 193, 17
@fordman84, 2, 194, 15
@PnkPanther, 2, 194, 12
@RP-29, 1, 100, 10
 
Jimmy Carter brings us a change to the top spot!


[td width="48pt"]@outofyourmind, 4, 303, 26[/td] [td]@Dolemite censored, 4, 333, 13[/td] [td]@MrFlyingV, 3, 237, 24[/td] [td]@steelerssb, 3, 240, 23[/td] [td]@Handicappers, 3, 241, 22[/td] [td]@huskers1217, 3, 245, 18[/td] [td]@Mofo, 3, 246, 26[/td] [td]@GhostRider, 3, 251, 27[/td] [td]@Illustrious Potentate, 3, 267, 19[/td] [td]@Grant Ward, 3, 287, 20[/td] [td]@ill, 3, 287, 10[/td] [td]@Guy Incognito, 2, 153, 13[/td] [td]@moxie, 2, 153, 13[/td] [td]@Wood20ks, 2, 192, 19[/td] [td]@Wingsauce7, 2, 192, 13[/td] [td]@olympicoscar, 2, 193, 17[/td] [td]@fordman84, 2, 194, 15[/td] [td]@PnkPanther, 2, 194, 12[/td] [td]@RP-29, 1, 100, 10[/td]

Jimmy Carter brings us a change to the top spot!


[td width="48pt"]@outofyourmind, 4, 303, 26[/td] [td]@Dolemite censored, 4, 333, 13[/td] [td]@MrFlyingV, 3, 237, 24[/td] [td]@steelerssb, 3, 240, 23[/td] [td]@Handicappers, 3, 241, 22[/td] [td]@huskers1217, 3, 245, 18[/td] [td]@Mofo, 3, 246, 26[/td] [td]@GhostRider, 3, 251, 27[/td] [td]@Illustrious Potentate, 3, 267, 19[/td] [td]@Grant Ward, 3, 287, 20[/td] [td]@ill, 3, 287, 10[/td] [td]@Guy Incognito, 2, 153, 13[/td] [td]@moxie, 2, 153, 13[/td] [td]@Wood20ks, 2, 192, 19[/td] [td]@Wingsauce7, 2, 192, 13[/td] [td]@olympicoscar, 2, 193, 17[/td] [td]@fordman84, 2, 194, 15[/td] [td]@PnkPanther, 2, 194, 12[/td] [td]@RP-29, 1, 100, 10[/td]
Can’t read it unless I quote. Think I still suck
 
Jimmy Carter brings us a change to the top spot!


@outofyourmind, 4, 303, 26
@Dolemite censored, 4, 333, 13
@MrFlyingV, 3, 237, 24
@steelerssb, 3, 240, 23
@Handicappers, 3, 241, 22
@huskers1217, 3, 245, 18
@Mofo, 3, 246, 26
@GhostRider, 3, 251, 27
@Illustrious Potentate, 3, 267, 19
@Grant Ward, 3, 287, 20
@ill, 3, 287, 10
@Guy Incognito, 2, 153, 13
@moxie, 2, 153, 13
@Wood20ks, 2, 192, 19
@Wingsauce7, 2, 192, 13
@olympicoscar, 2, 193, 17
@fordman84, 2, 194, 15
@PnkPanther, 2, 194, 12
@RP-29, 1, 100, 10
I have 4. Jimmy Carter, Bobby Allison, Kris Kristofferson and Willie Mays
 
Back
Top