Quote:
Originally Posted by Cobby
Here's what I do - not saying it's the best or only way, but it works for me. First I create a custom view that contains the data I want to manipulate in a spreadsheet. Then under the Report drop-down I select "write report to disk". This doesn't seem to actually write the report to the disk, as far as I can tell. Instead the report appears in my web browser. I then select and copy this data (ctrl-a, ctrl-c) and paste it into an Excel worksheet. From there I can massage the data to my heart's content using other worksheets and VBA scripts that get their input from the pasted data.
I do this routinely as I play the game - I think of my spreadsheet as my "analytics department" and I use it to evaluate players, create projections, evaluate trades and to help manage my depth charts and lineups. (this latter can be a real time-saver when trying to figure out how to juggle one's lineups and depth charts after an injury)
|
If you dont mind, could you pm me the setup of your spreadsheet and maybe explain it? Im curious how using one could affects how you play the game.