For those who are into such things ... D (decision), M (major), T (tech fall), F (fall, MFF, inj. def., ect.) are the codes to advance the winners in the bracket
Big 10 Interactive Bracket
- Thread starter regularfan
- Start date
I always look forward to these. Thx for doing this every year!
Download it and open it in Excel.
Then you can play all the "what ifs" you want.
I can't say I am an expert on the subject but on my phone it opens all of my excel files as a PDF and so I can't edit them (only view). I am not sure if excel has a mobile program or not.
On my iPhone, I get all the way to clicking "download", then the phone hangs there (looks like it's working), and doesn't load the spreadsheet. Note: Waited about 5 minutes to be sure before posting this.
You can open this in Google Sheets, if you've got that on your phone, but it reads much easier on a computer. It's a bit unwieldy on a phone, but so is nearly any multi-sheet spreadsheet.
You can also hit "make a copy" under file on google docs. Your copy will allow you to run the sheet.
Thanks for setting this up.
Thanks for setting this up.
I can't tell you how awesome this is. How did you embed a spreadsheet? I modified your spreadsheet to spit out KYPSW output in the preferred format to copy paste into the thread if you fill out all of the brackets. I would upload that in here, but I don't see how to upload a spreadsheet. Thanks.
How are you extracting the bonus points? Would love to see your work.
I think you can embed if you upload the .xlsx to google drive (dont' convert to sheets), then paste the "share" URL in a post.
I just uploaded that to a google drive. Right click on the document and hit "preview." From that hit "open in new windwo" and then just copy that link into the message.
The only thing it doesn't do is return a place if the PSU wrestler is not in the top 8 since this is only set up to determine top 8. You'll have to type your guess for that manually.
I think this is because the brackets for 9th place etc don’t count in the scoring for the tournament. I believe the weights that will have these will be reseeded among the 6 guys that were not in the final 8.
Right. I get that. I’m just saying, if you want to use my modification to generate your KYPSW entry, you’ll have to manually add any placing below 8. Otherwise, my modification spits out the KYPSW entry in the preferred format to copy/paste (paste as plain text…) if you fill out the bracket for each weight.
Thanks that should be updated. All you need to do is switch the 7 & 8 seeds on the 174R page. That automatically updates the bracket and the projected team scores where NW gains a point and Purdue drops a point.
I tried to make this sheet formula heavy so that small tweaks can be made easily and they update the whole document.
