mattchristensen112 53 Report post Posted March 8, 2018 Hey everyone, I am thinking of trying to create a pick'ems bracket for NCAAs using Google Sheets and javascript, but wanted to know if anyone has a template already created in some form. Anyone ever try or have anything? Thanks! Quote Share this post Link to post Share on other sites
pamela 1,334 Report post Posted March 8, 2018 There are websites free online bracket generators that are super easy to use. Generating the wrestleback brackets might be tricky though. Anyway, you'll get a bunch of options by Googling for bracket generator. Quote Share this post Link to post Share on other sites
merr6267 18 Report post Posted March 8, 2018 Check out Hawkeye Report and look for the "Interactive Bracket" thread, or follow this link. https://iowa.forums.rivals.com/threads/interactive-bracket-download-link.224938/#post-5220486 This is not mine. It belongs to LutherAce. Ace, if I'm in the wrong here, I apologize, but I think your work is too good to not share. Phill Quote Share this post Link to post Share on other sites
BooHawk18 4 Report post Posted March 8, 2018 Hey everyone, I am thinking of trying to create a pick'ems bracket for NCAAs using Google Sheets and javascript, but wanted to know if anyone has a template already created in some form. Anyone ever try or have anything? Thanks! I do one every year using google sheets. I have to update it and put in the wrestlers. I can send you a copy when it's done if you'd like. 1 mattchristensen112 reacted to this Quote Share this post Link to post Share on other sites
BigTenFanboy 1,790 Report post Posted March 8, 2018 (edited) LutherAce from HR posted this Props to LutherAce https://www.dropbox.com/s/2o463c2as49hlga/2018ncaaChampionshipsV1-1.xlsx?dl=0 Edited March 8, 2018 by BigTenFanboy 1 mattchristensen112 reacted to this Quote Share this post Link to post Share on other sites
mattchristensen112 53 Report post Posted March 8, 2018 I do one every year using google sheets. I have to update it and put in the wrestlers. I can send you a copy when it's done if you'd like. That would be great if you could! Let me know how you want to send it over. Quote Share this post Link to post Share on other sites
mattchristensen112 53 Report post Posted March 8, 2018 LutherAce from HR posted this Props to LutherAce https://www.dropbox.com/s/2o463c2as49hlga/2018ncaaChampionshipsV1-1.xlsx?dl=0 This also looks pretty good. So do you just manually check the correct picks and manually drop the wrestlers down into the losers bracket? Quote Share this post Link to post Share on other sites
merr6267 18 Report post Posted March 8, 2018 It does it all for you if you simply put a score in each match. A pin is 30 points. 1 mattchristensen112 reacted to this Quote Share this post Link to post Share on other sites
mattchristensen112 53 Report post Posted March 8, 2018 It does it all for you if you simply put a score in each match. A pin is 30 points. Oh I see it now, thanks. Sorry, just one last question, does it have functionality to check picks against the real result and track points like a March Madness competition? Quote Share this post Link to post Share on other sites
BigTenFanboy 1,790 Report post Posted March 8, 2018 It does it all for you if you simply put a score in each match. A pin is 30 points. I went through the spreadsheet and everything works in regards to the team scoring EXCEPT 157. Quote Share this post Link to post Share on other sites
BigTenFanboy 1,790 Report post Posted March 8, 2018 (edited) Found the issue. On the wrestlers section at 157 are not listed with their correct teams. Edited March 8, 2018 by BigTenFanboy Quote Share this post Link to post Share on other sites
BadgerMon 226 Report post Posted March 9, 2018 Regarding this spreadsheet, and Excuse an old duffer for asking, but do you have to copy and paste the winning wrestler's name down to the next bracket? I was hoping that I could just pop the mouse a couple of times and it would transfer? Quote Share this post Link to post Share on other sites
russelscout 1,573 Report post Posted March 9, 2018 Regarding this spreadsheet, and Excuse an old duffer for asking, but do you have to copy and paste the winning wrestler's name down to the next bracket? I was hoping that I could just pop the mouse a couple of times and it would transfer? you have to open the file in a excel spreadsheet I believe and then enter the scores of the matches. The wrestlers automatically move throughout the bracket Quote Share this post Link to post Share on other sites
russelscout 1,573 Report post Posted March 9, 2018 I was very dissapointed to see my picks having psu win. Quote Share this post Link to post Share on other sites
BigTenFanboy 1,790 Report post Posted March 9, 2018 you have to open the file in a excel spreadsheet I believe and then enter the scores of the matches. The wrestlers automatically move throughout the bracket This is correct. Just enter a number in the yellow highlighted cells. The winning wrestler will advance in the bracket. Quote Share this post Link to post Share on other sites
BigTenFanboy 1,790 Report post Posted March 9, 2018 I was very dissapointed to see my picks having psu win. My picks have tOSU squeezing by PSU 1 russelscout reacted to this Quote Share this post Link to post Share on other sites
russelscout 1,573 Report post Posted March 9, 2018 My picks have tOSU squeezing by PSU score was tight and I picked Kollin Moore to lose in the semis. This made me realize how close this thing could be this year. Quote Share this post Link to post Share on other sites
levityrel 4 Report post Posted March 9, 2018 It does it all for you if you simply put a score in each match. A pin is 30 points.How do you enter in a pin? Sent from my Acer Chromebook R11 (CB5-132T / C738T) using Tapatalk Quote Share this post Link to post Share on other sites
merr6267 18 Report post Posted March 9, 2018 A pin is 30, or something. It is in a key in the upper right of the page. Quote Share this post Link to post Share on other sites
