Originally Posted by BuckeyeKaptn
: Nice job on the update. However, I found a couple of problems that I made a quick fix for. If you have updated for today (April 5th) you will see in the Nyy/Tor game that both pitchers are Dickey. This is because Dickey has periods in his first name. This causes a problem for your formula in Col Z of the Schedule tab.
If you change the formula to:
...don't forget the period after vs. and change Col AA to:
this will fix that problem.
The other problem I saw was that pitchers for the respective teams are backward. On Col G of the Summary tab, in the Away pitcher formula the Col should be AD not U and the opposite for Home pitcher...U not AD.
Please Reupload the spreadsheet