Bender2 Memorial Pigskin Pickem Thread, Conference Championships

1-28-2022

[Jim W N]

Thanks to WhoisAlanGreenspan? for compiling the data. I just recalculated and sorted based on all playoff games played. Thought some would be interested.

Good going Tommy Revolts, DoodleDawg and Repealthe17thAmendment for sharing first place so far.

[Jim W N]

Save what’s on EXCEL as an image?

I know how to upload an image as <img src= but how do you save an EXCEL spreadsheet as an image?

[WhoisAlanGreenspan?]

No no, I just simplified it to only the conference finals for the conference final thread, it's only two games. The prior threads; regular season last game, wildcard round, divisional round all have a html table for the results at that time, in those threads. Like you mentioned how can you compare someone like cwa78 who came in to the conference finals and won the only two games he called. Awesome but after I had a reasonably good regular season picking something like 16 games for 17 weeks but then blew out completely in the playoffs, it's just hard to compare the results or imagine results on some sort of weighted platform.

We had twenty three regular season players, most of whom played each week, we had four new players join in for the wildcard round, ten new players join for the divisional round, and one joined for the conference round.

I had some fun working on this spread sheet the past several weeks. As I said earlier I'm willing to share if anyone is interested, but only to established time tested FR'ers no newbys. I could probably sell it. Nah. But it does simplify the whole thing.

If I didn't already mention it I won't be available for Super Bowl weekend. It's our absolutely wonderful 30 year marriage anniversary, 2/14/22 just sayin I'm a lucky man, and she's one of the best blessings of my life. Afterthought, no she doesn't read FR, and has no idea what I'm doing here.

[Jim W N]

OK, but the numbers on your spreadsheet on Post #209 are accurate for all the “wins” (correct guesses) for all the playoffs right? That’s what I used to calculate the “Leader Board”.

If so, unless Impy does, I’ll try to add the last guess - Super Bowl - to the numbers for a final spreadsheet.

What are the steps to getting an EXCEL spreadsheet on a clean copy on FR?

Congratulations on your 30-year marriage and have fun on your annivaersary. Where are you going?

[teeman8r]

my congrats to whoever picked the bengals... they should win it all.

thanks to all for a wonderful season and my hat tip to mmichaels for finishing ahead of me... alphabetically of course.

hehehe

tthanks everyone for a tremendously fun ride.

enjoy the super bowl.

t

[Jim W N]

You and mmichaels are tied for 7th at 58%. See Post #218.

[Jim W N]

Hey dfwgator, I didn’t see you in the rollup of Playoff choices. Don’t you do that? It’s a kick in the butt. Use the stats I use to help if you want.

[WhoisAlanGreenspan?]

From any browser you can right click and select "view page source", that opens a new tab that shows you all the html. If you go to my post #209 you'll see where the html table begins with the table border="1" everything in that one single line is the whole table.

It's difficult to look at in that view, but you can copy the whole thing and paste it into excel, where you can get an idea. Use a search engine to learn about "html tables" if you need.

Excel works great for doing the math and tracking the players picks, but you have to do some more work to go from excel into the html table.

[teeman8r]

yes...we had a friendly wager at the beginning of the season as to who would finish ahead of whom... he has won, by alphabetical listing.

[Jim W N]

right click and select "view page source"

From whence do I do that? Where on my Google Chrome Excel spreadsheet do I right click? I couldn't find "view page source".

[deport]

Hit control u and see if that helps

[WhoisAlanGreenspan?]

No you need to go to the FreeRepublic.com page that has my post #209 (the one with the html table of conference final results). That's where you view page source.

[WhoisAlanGreenspan?]

It's a little bit confusing at first but if you keep scrolling down you'll see stuff that is on the freerepublic forum thread. You should also be able to find where the post numbers are
(a name="209") replace the () parentheses with <>right left arrows. Everyone here knows what's between the arrows is html

Actually it's on line number 263 far left edge of page. Every line has a number.

I checked; I have Brave, Firefox, and Microsoft Edge, all of them have line numbers.

[WhoisAlanGreenspan?]

screen name	Regular Season		Wildcard		Divisional		Conference		Super Bowl
	wins	pct	wins	pct	wins	pct	wins	pct	wins	pct
38special					2	.5oo	1	.5oo	0
al_c	152	0.561	4	0.667	2	.5oo	1	.5oo	0
Alas Babylon!	156	0.576							0
big'ol_freeper	162	0.598	4	0.667	1	.25o	1	.5oo	0

Here's an example of what could be done, it's fun to play with but this shows the problems as well. Imagine a final weighted column that attempts to compare all the picks. al_c lost 10 more regular season games than big'ol_freeper if you simply average the regular season, wildcard, division, and conference percentages al_c wins by more than .05 even though he lost 10 more reg. season and only won 1 more divisional. Even if you multiply regular season wins by 10 big'ol_freeper wins but he doesn't best Alas Babylon! who didn't risk anything in the playoffs.

Again I'm thinking it's best to just list the players alphabetically and list the results of the various rounds as something of a curiosity.

[Jim W N]

Hey Impy, I’m ready to tally the final Super Bowl votes with the rest of the Playoff Votes to get the final Leaderboard. I don’t see the Super Bowl thread.

Bring it on, Baby.

[big'ol_freeper]

I’ll take the Rams over the Bengals in the Super Bowl.

I leave Sunday for a business trip, so will be missing it.