GregR_2
Footballguy
It's pretty easy to do in excel. Assuming you have a report of weekly scores, just dump them into excel in this form:..........A............B.............C...........D..............E1 ... Team1 ... week1 ... week2 ... week3 ... week4 (etc)2 ... Team2 ... week1 ... week2 ... week3 ... week4 3 ... (etc)...14... Team1 ... formula ... formula ...15... Team2 ... formula ... formula ...In the formula part in rows 14 and down you have formulas for each team that will give you the number of all play wins that week. Here's one for a 12 team league and the format I showed: =12-RANK(B1,B$1:B$12) Where 12 means it is a 12 team league, and B1 to B12 are the cells where the league's week 1 scores are at. The $ is there so you can copy and paste the formula and it will keep the range of weekly scores correct when you do it.Just copy the formula to all teams for all weeks and you have a list of wins for each team by week. Sum them up and you get the total # of wins from the all play record. Subtract the total number of games to get the number of losses.ETA: Or, you could just switch to MFL where they put this in their power rank report.BTW All-play is interesting but I would have to calculate that myself. Could be a pain but something I might consider introducing next year.

Last edited by a moderator: