Okay this should not be too difficult but a simple lookup table looks like the right solution. I am struggling in how to best organize the data because it seems like it would be a huge table.
I have separated four tables here in the spreadsheet, where team would be the index.One table would hold the numerical ratings, one table with the distance, one table with the number of downs, and another with the playcall. To calculate every scenario between every team with each down and distance combo and playcall would be a massive table ???