MS Excel Weight Watchers Spreadsheet
FLEX Plan
Version: 10/4/2009 Ver. 2.3 FLEX
Version History
10/4/2009
- Fixed formatting error on Sunday daily sheet.
- Fixed formatting error in quantity column of daily sheets.
- Changed calculation of points allowance to a minimum of 18, maximum of 44 per Weight Watchers plan.
- Fixed formatting of Daily Points Remaining cell on Daily Sheets.
- Minor cosmetic change on Color Selector form.
7/22/2009
- Fixed error in Recipe Calculator which caused another error when recipe data transferred to Data Sheet.
6/23/2009
- Fixed About button link on WWToolbar.
- Corrected spelling/wording on BMI Calculator.
- Widened Category and Food Item columns of the Data Sheet.
- Adjusted chart label locations on Summary sheet.
- Formatted data column widths so all sheets are uniform width.
- Added "Made In The USA" under flag on Summary sheet.
- Added week #'s to weekly weight rows on the Summary sheet.
- Fixed formatting errors on Instructions sheet.
- Changed format of the "POINTS" word in cell C2 on the daily sheets.
- Changed BMI chart image.
- Fixed bug in Activity Points Calculator form.
- Added a confirmation before resetting menu data is performed.
- Changed shortcut for points calculator to Ctrl+q from Ctrl+n.
- Fixed a formatting error on the daily sheets.
- Fixed typo on the Instructions sheet.
2/22/2009
- Fixed a number rounding issue on the Recipe Calculator worksheet.
- Fixed a problem with the sort functions on the Data worksheet.
- Redesigned the Color Selector form.
- Redesigned the About form.
- Made several minor format/cosmetic changes.
2/12/2009
- Rearranged the daily points tracking on each Daily worksheet and enlarged the font size making the numbers easier to read.
- Enlarged the weight graph size. Changed the lower and upper limit of the Weight axis to automatically adjust to the Goal weight on the Summary sheet as the lower limit and the first entry of the Weight column on the Summary sheet as the upper limit.
- On the Data worksheet, Category and Filling Foods columns have been added allowing for more sorting options. In addition, buttons were added above each column where the data can be sorted.
- Added the ability to transfer food info from the Data worksheet to the Recipe worksheet via the Food Data number lookup feature.
- Added a Body Mass Index calculator accessed from Summary worksheet.
- Fixed a couple calculation bugs and made several other small cosmetic and formatting changes.
- Edited the Instructions worksheet to reflect new features.
2/2/2009
- Minor changes and updates.
1/14/2009
- Added the ability to search the database not only from the database worksheet but from the daily worksheets.
- Added a weight loss chart and graph.
- Added the ability to transfer food item information, i.e., servings size, calories, fiber, etc, from the database to the daily worksheets by simply entering a corresponding number listed in the database onto the daily worksheet.
- Added a popup window Quick Points calculator accessible from any worksheet in the workbook.
- A custom Excel toolbar has been added with links to many features and worksheets within the workbook.
- Many other small changes.