Spreadsheet Tips
April 11, 2005
If you work with the WPA spreadsheet, here are a few tips:
- Don’t save the spreadsheet under a name other than WinExp.xls if you want the macros to work. I generally use the spreadsheet as is when logging a game, then save it under a different name when done. Remember, the macros won’t work if you save it under a different name.
- Make sure your Macro security is set to “Medium.” Otherwise, they won’t work.
- The macros don’t seem to work on a Mac. Don’t know why.
If you do log a game, be sure to enter the info in the “Start” page, as well as the pitchers in the “Front End” page. Then, when logging a game, you should enter each difference in score, inning, outs, and base situation, then note each of the following in the four yellow description boxes:
- Play description
- Offensive Player involved.
- Percent of play to be allocated to pitcher
- The name of the fielder, if any has WPA credited to him.
It probably works best if you save the file in two places: one with the original WinExp file, then store it in another directory, which you use to log a game. This way, if you change something in the file, it won’t affect the original one.
| <<Previous Article: WPA Central | Next Article: Blue Jays' WPA>> |