[kq76]

Update History:

5.43
-Completely redid the YLTF (finances) sheet yet again to give people more information to help in budgeting, including "Actual Year To Date", "Forecasted Current Year End", and "Forecasted Next Year Start"
-Fixed the problem of not copying the data of the last few players in the stats and ratings sheets
-Fixed finding ExporterDir for archive.bat
-Added day and month to date
-Fixed some formatting
-Changed sorting of batter stats to XR
-Updated Exporter link again

5.42
-Completely re-worked team finances sheet (now has much more info and room for info not tracked by CSVs)
-Added FA, Arb El, and Auto Renew flags
-Fixed TY Player Expenses (Profit is now also fixed as a result)
-Updated Exporter link
-Changed division IDs to #s

5.41
-Added Change CSVs Folder button as a possible fix (listed in the troubleshooting section) to the problem that was happening for some people with v5.3#.
-Fixed the CSVs folder path from not being fully replaced (lengthy paths caused them not to be replaced in some formulas)
-Fixed the copying of the ratings and post season sheets to the archive
-Added the ability to customize what sets of sheets to process
-Reworked Refs and Arrays sheets into 2 Refs sheets and only the league specific refs, Refs2, gets copied to the archive
-Separated regular season and post season stats processing groups
-Added Generate CSVs button for times when all you want to do is generate CSVs or change the CSVs folder (I'd make a separate one for it, but it would depend on some of the answers to the generate CSVs macro)
-Added Delete Archive button to delete archive
-Added the ability for "N/A" to be marked beside some ref info folders for when those options are rejected. Now, if later those options are accepted, the last selected folders can be reused
-Fixed minor problems with the ATTT, ATTA, YLTS, and YLTF sheets
-RARs now show as 0 instead of divide by 0 error
-Extra (non-raw) stats in Stats sheets are now value pasted instead of formula pasted
-Added the DH
-Fixed some column widths
-Redid the Directions section
-Redid the Notes section, including an explanation of RAR

5.40
-Reworked setup directions
-Added ability to generate CSVs from utility
-Added error checks
-Added confirmations of locations
-Added ability to select what groups of sheets to process
-Added batting and throwing handedness
-Added team cities and nicknames
-Separated Stats and Ratings sheets
-Replaced multiple processing sheets with Clips, Fill and Fill2 sheets
-Added back Post Season sheets
-Sheets (except for fielding) pre-sorted from best to worst
-Added P% (Pythagorean %) and WD (Win Differential, W%-P%) stats
-Added RAR (Runs Above Replacement) stat for batting and pitching
-Added ERC (Earned Runs Component) stat
-Added numerous pitching rate stats
-Added TB/H batting stat which can be thought of as a pure power stat
-Added PP (Primary Position) to fielding sheets to differentiate from Pn
-Rearranged Refs sheet
-Added AFC sheet directions
-Simplified directions on Home sheet
-Added web links

5.35
-Commented out numerous calls in the VB code that are only needed for running one procedure at a time as they were apparently causing the utility to not work for some people. They are needed to run many procedures by themselves and saved me a great deal of time in testing the utility. But most people will only use the add new year macro, so they are not necessary. Doing this should also speed up the utility.
-Optimized some VB code
-Fixed some column widths and decimal places
-Replaced the division abbreviations with number codes as they were often not unique
-Fixed a minor backward compatibility issue with Excel 2000. The utility should now work for most people using Excel 2000 and 2002/XP. There is an issue with Excel 97, but I doubt many people still use it so I'm not going to bother finding workarounds that will probably lead to code that is not as good as what the later versions allow for.
-Edited the ReadMe, especially the Features and Troubleshooting sections

5.34
-Updated and tested with Excel 2002
-Added team finances
-Added player contracts
-Added player ratings (current & potential)
-Added team and league statistics
-Added columns for user-defined stat formulas (UD#)
-Added the archive file to shrink file sizes and increase file integrity
-Changed the utility's name from OOTP5 Excel History to OOTP5 Archive to distinguish it from Cato's History utility
-Removed the Top / Best sheets as it is possible to get this info from sorting the player sheets
-Renamed sheets for better clarity
-Added the Links sheet
-Cleaned up the Home sheet
-Optimized the VB code
-Changed the ReadMe to HTML

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)