View Single Post
Old 06-03-2003, 04:29 AM   #2 (permalink)
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver
Posts: 7,623
Thanks: 281
Thanked 332x in 190 posts
Update History:

5.21
-Significantly improved processing time, especially for large leagues, by improving the deleterows VB code
-Added the ability to change the CSVs path
-Increased the # of rows to process for the advanced filter procedures. Some large leagues had more players fitting the criteria than I had allowed for, but now even leagues with the max of 40 teams should be ok.
-Edited the directions
-Added troubleshooting, contact info, and wish list sections.
-Reorganized the home sheet.
-Shrunk size by deleting blank cells shown by scrollbar

5.20
-Redid the VB code for it to also work with Excel 97
-Added sheet links on the home sheet
-Changed sheet names to be more intuitive
-Added Glossary (below)
-Fixed problem with RL stat
-Fixed TRST Averages and Ranks for expansion teams

5.12
-Fixed a problem with the year data caused by 5.11

5.11
-Took away ability to change the path of the CSVs. Until, I find a better workaround, put the exported CSVs into c:\CSVs.

5.10
-Added buttons to add new years: 1) without career stats and 2) with only career stats (Please note that doing 1 of these may screw up something (the ATm sheet, etc) that uses the # of years added data. To fix it, manually change it in the references sheet.)
-Optimized the career sheets' code
-Added sort buttons to career sheets
-Added sheets: ATm, APn, Avgs
-Added button to initialize workbook (deletes all added data)
__________________
Useful Links: Manuals | Downloads | Newsletters | Knowledge Base | New Tech Support | Updated Forum Rules

Interactive Online League Directory - find or advertise a league today!
Canadian Baseball League - uses OOTP11, running steadily since April 2002
kq76 is offline