v2.0.0

Here's what's new and improved in v2.0.0 of OOTP Utilities:

• Adds an expert system for formatting data, which gives the user more control
  and the ability to both see and enter the most amount of information
• Adds a simple system for formatting data, which displays prompts and reduces
  the amount of data shown for the sake of keeping things simple.
• Overhauled the settings sheet and added new options
• Adds the ability to reformat new data (by using the same format option)
• Adds the ability to enter income (e.g., trades, playoffs, etc.) if desired
• Properly detect "MiLC" contract types
• Optimizations in the code for detecting specific summary rows
• Tweaked alerts for certain situations and user-related errors (read manual!)
• Adds new stylings for summary rows at the bottom of the sheet
• Resolves an error message that was displayed while canceling during prompts
• Canceling a prompt will fail silently, allowing you to manually enter data
• Fixes an issue with recomputing budgets that caused the TREND formula to fail
• Edited the documentation to reflect the changes
• Improved code comments
• Lots of other minor fixes and improvements

v1.0.1

Here's what's changed in v1.0.1:

• This releases resolves an issue where a prompt for the previous year's budget was being incorrectly used and was completely unnecessary. To resolve, I removed the prompt for last year's budget entirely, and I reset the TREND formula to use data from those three years only.

v1.0.0

This is the v1.0.0 releases of OOTP Utilities.

The final code has been completed, the documentation has been properly updated, and visual guides for installation and usage have been added.

v0.6.0

New in this version:

• Adds all-in-one functionality, and updates the menu to support those workflows
• Adds the ability to add color while performing major functions (see the "(With Color)" menu options)
• Optimizes the code — removes unnecessary code, and updates the code to make it more readable
• Heavily modifies the menu to enable more options at the click of a user's mouse
• Adds/updates some code comments
• Other various code fixes and improvements
• Adds the MIT License (feel free to fork/hack/improve)

Note: This should be the final pre-v1.0.0 release that modifies the code base, barring any bugs. Most of the remaining work before v1.0.0 will be with documentation.

v0.5.0

New in this release:

• Generates a settings sheet, pre-populated with default settings, and can be changed by the user
• Functions utilize these settings for reusability and customization by the user (without digging into the code)
• User can now properly cancel budget input
• Fixes a bug with the "REMAINING" function selecting the wrong row
• Other various code fixes

Note: This will likely be the last feature release; the remaining releases will go towards optimizations, UI/UX, and documentation issues.

v0.4.0

New in this version:

• Reshuffles the menu a bit and adds new options for adding and removing color
• New: Color options — before formatting your spreadsheet, you can use the contract designations (auto, P, T, V A, A*, A#, MiLC) to color your cells. Again, do this before formatting your sheet.
• You can now enter in currency symbols, commas, or periods when entering your budget estimates; the function will extract only the numbers.
• Other various code fixes and adjustments

v0.3.0

This version adds the following features:

• Users now have the ability to generate a remaining budget/salary room figure, which will be calculated at the end of the end of the spreadsheet
• If the user has not generated a budget before trying to activate this feature, the user will be prompted to do so

v0.2.0

This release adds the following:

• Updates the menu with new functionality
• Adds the ability to add budgets
• Adds the ability to estimate your budget for the next nine years
• Adds an options sidebar (though it is not yet completed)

This release fixes the following:

• Various code errors, including unnecessary variable statements

v0.1.1

This release adds several improvements to the code to increase readability, while also fixing a few minor code errors (the occasional missed semicolon and whatnot). I also started the beginnings of making the functions currency neutral.

v0.1.0

This is the first, initial release of the project.