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!