Quote:
Originally Posted by Cobby
VBA stands for Visual Basic for Applications. In this case it's just a way to create a program for manipulating the data in a spreadsheet.
I can post screenshots from the spreadsheets if you are interested (let me know), but there are a number of problems in making the spreadsheet itself available:
First, it's about the most opposite of user friendly as you can get, so it would take quite a learning curve for anyone else to use.
Also, it requires a high end computer - I once tried to run it on a mid-range laptop while my main laptop was being repaired and found it to be completely unusable. The spreadsheet took forever to calculate and the VBA code took seemingly more than forever to run on that laptop.
And finally, if you have a large league - or even just a modern MLB setup with full minors - then you get the dreaded page selectors because the number of players in your universe will be greater than 4095. When you reach that point, exporting the data to the spreadsheet becomes difficult (or impossible?) (I periodically complain to the developers about this and Markus has told me that they will fix this at some point, but it appears to be a very low priority for them) (although I haven't tried the recent patch yet - hope springs eternal). But in the meantime this will only work for smaller leagues where the number of players stays under 4095.
|
Gotcha....thanks for the explanation and i think I will pass on destroying my laptop with a spreadsheet i need to go to MIT to understand
. I like the theory and all, but i spend enough time as it is on OOTP so i think id need a divorce attorney before spreadsheet help if i unloaded more time to this. thanks a bunch for the info!!!!