View Single Post
Old 01-05-2023, 11:03 AM   #40
JWDixon120
Rookie
 
JWDixon120's Arena
 
OVR: 0
Join Date: Jul 2012
Posts: 615
Re: JWDixon's All Inclusive Franchise Spreadsheet

Quote:
Originally Posted by JWDixon120
I can definitely add this in. The math on it wouldn’t be too hard to figure out.

Would just take a lot of user input to input each teams WL for their past 10

Update on this. I was able to add in power rankings that takes into account each teams overall win %, last 10, and Overall Run Diff

User just has to input each teams Wins/Losses, and RS/RA

Also they will need to add in each teams Last 10 in the format of 6-4 or 2-8 etc. I have formulas that break out this format and generate power rankings.

Just waiting on one of my buddies to format the sheet to make it look really slick.


For example, here are the Power Rankings it generated using the end of last seasons data. As you can see, the format is pretty ugly but it will look incredible once my friend has it finished!
JWDixon120 is offline  
Reply With Quote