Posted on 01/28/2022 12:52:19 PM PST by Impy
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.
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?
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.
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?
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
You and mmichaels are tied for 7th at 58%. See Post #218.
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.
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.
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.
From whence do I do that? Where on my Google Chrome Excel spreadsheet do I right click? I couldn't find "view page source".
Hit control u and see if that helps
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.
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.
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.
I’ll take the Rams over the Bengals in the Super Bowl.
I leave Sunday for a business trip, so will be missing it.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.