Seth's Bracket Assist Widget
You will probably have to create your own copy but then you can type in any two teams and make a comparison. Thank you to Kenpom for the data and helpful Google Sheets script writers for helping me calculate distances. Drive times are calculated as 1.3 minutes per mile.
To get a copy:
Follow this link and play around with it on google sheets.
OR
- Follow this link to the spreadsheet.
- Go to "File" and "download as". Choose a format and the rest is up to you.
To use it just put the two teams you're trying to compare and the round (it will return wonky stuff if those two teams aren't able to meet there). It'll show you things like Off and Def rank on Kenpom and a win confidence based on a factor of the average 1 seed will be 100% to beat an average 16 seed. It'll also bring up the site of the game and, new this year, the distance for each team in driving hours. Last it'll show any injuries I knew about when I made it last night.
Enjoy.
Thank you for this, Seth. Now I have to revise all my brackets though.
Thanks Seth. I waited to fill out my brackets hoping this would get posted!
Nice Work Seth! Working through though, I think there is an error in the location formula. It's not looking for the cell that contains the round number.
I think somebody moved a cell. Let me know if it's fixed now.
Come on man. Im calling reverse homerism!
If we end up facing them in the Final Four I guarantee all 100 of their fans will drive the 9 hours to Houston for it. But it'd be a good matchup.
NERDS!
/oldschool
Sent from MGoBlog HD for iPhone & iPad
Just a question for everyone that used this model last year. How well did you do in your brackets? I'm planning on using this in at least one of my paid brackets this year but not entirely sure on if I will yet.
Pretty sure that Spokane is more than 14.5 hours from Duke...
Is only 13.5 hours with 2 children, a dog, and a very slow vehicle.
Just about to make the same point - not sure how they figured that. For me, barring incident, 11 hours comfortably, probably 10.
Sent from MGoBlog HD for iPhone & iPad
thanks Seth!
Thanks Seth!!!
If I go with this from game one to the end will I win?
Use one of the links in this article or on the sheet to download a copy. I can't have everyone using the same spreadsheet or it gets insane.
Check out this bracket I made!
https://docs.google.com/spreadsheets/d/1koT0MijE-GijGExW5WZeJQkrVkVG1G7…
If you'd like to play along, just copy a blank_bracket and fill out the matchups!
March 16th, 2016 at 10:16 PM ^
Sent from MGoBlog HD for iPhone & iPad
March 16th, 2016 at 10:36 PM ^
da man.
Thank you.
This is how I figured out distances:
https://docs.google.com/spreadsheets/d/1qkU9zIPyy1bXErfTMGkF8MFgQ_RkMP2…
That Google Sheet has a script to query Google Maps for a driving distance (or an as-the-crow-fles distance that I used for Hawaii). To avoid repeatedly making those queries I have the formula active in only the top line right now.
Then I took the mileage and multiplied by 1.3, accounting for stops and city driving. It seems that was too much. I'll recalibrate at an average trip speed of 55 mph (right now it's 45).
Why People are Getting Crazy Errors
I only have three possible distances that can show for any given team, for the three possible sites they can play at. If you pull up an impossible matchup (say, Michigan vs Arizona in the 2nd round) it will return the distance to THE ACTUAL SITE of that round.
March 17th, 2016 at 10:11 AM ^
Has anyone filled it out solely based on kenpom, and if so can you share?
March 17th, 2016 at 11:27 AM ^
Very helpful! Just had to tweak Michigan losing to ND...cannot stomach that. Thanks!
March 17th, 2016 at 11:55 AM ^
March 17th, 2016 at 10:46 PM ^
Sent from MGoBlog HD for iPhone & iPad
March 17th, 2016 at 10:46 PM ^
Sent from MGoBlog HD for iPhone & iPad
Comments