Power Rankings
What do you guys use to do power rankings throughout the year? I found something on here once but don't remember where it was
Posted May 21, 2019, 6:30 PM UTC
56
I got this one from another thread last year. I have a 10 team, 12 team, and 16 team one. Just let me know which size you need! All you have to do is make a copy of the spreadsheet.
https://docs.google.com/spreadsheets/d/1SfbXTBJ-xh9e0MRvRMwTnN1oN92fGTt3sz9DRkHVu_o/edit?usp=sharing
3
I really tried and googled a lot to switch this awesome doc to a 14Teams 0 devisions spreadsheet but it didn’t work. Any tips you can give? By the way...really great work!!!
1
You'll have to ask u/floydman726 for that. I got the spreadsheet from them!
2
Thanks, looking at the one you have and the "to do each week" page it says update reference page. Where is that? Is it missing?
1
I'm the OP of the spreadsheet. the formula on the week 2 page in cell C14 is ='Week 1'!C13-C13. When you create a copy of the tab for the following week, that formula has to be updated to show the previous week. For example: on the week 3 tab, the formula for cells C thru N in row 14 should read ='Week 2'!C13-C13. on the week 4 tab, the formula for cells C thru N in row 14 should read ='Week 3'!C13-C13. and so on. I hope this helps.
3
I actually just did a dynasty start up. I had my league mates all go through and rank the teams based on preference. Then I just took the average of each team and put them in order. I’m going to do another one before the season starts, probably in the preseason. Then maybe another halfway through the season. It’s interesting to see how other teams value positions and players and also it’s helpful for everyone to learn each other’s teams.
1
I've used this the past few years and it's been great. I've even adapted it to an association of leagues with 108 teams across different leagues.
https://www.reddit.com/r/FFCommish/comments/523nfz/i_made_a_power_ranking_excel_sheet_for_use_in/?utm_source=share&utm_medium=web2x