Changelog

Cake Pricer Changelog

cakepricer V3.1.4.10

Released on 04/5/2024

  • Bug fix: CakePansDB & CCPansDB formulas not working properly.
  • Minor Bug fix: fixed Column AD on CakePansDB to be unprotected.
  • Minor Bug fix: Admin, Company Preferences, corrected number of rows visible when clicked from any of the other preferences vertical tabs.

 

cakepricer V3.1.4.9

Released on 03/21/2024

  • Removed SE from the name of the program. Originally there were going to be multiple versions of Cake Pricer with different prices. There will now only be 1 version and all new features will be added.
  • Fixed Build A Quote DELETE macro.
  • Changed location of Theme Colors so all users can utilize the Change Color Scheme button in the Company Preferences.
  • NEW SHEET! Calculators. Contains manual calculators for Cake Tiers, Delivery Charges, Fondant, Ganache, Ribbon, & Handmade Decorations.
  • Changed Contacts Ribbon group. Now all icons in 1 group.
  • Added Qty on Hand column to Baking Pans and Tools databases. You can now keep track of how many of each tool that you own.
  • Changed Tools Database button on Ribbon to Tools DB for consistency with other DB sheets.
 
cakepricer se 3.0.4.8

Released on 03/13/2024

  • Fixed Baking Pans SAVE/UPDATE & Delete Pan macros.
  • Fixed various macros on Entry sheets regarding saving and copying jobs.
  • Removed Print to PDF buttons from Ribbon. Moved to individual sheets to avoid errors when printing.
  • Added Font & Alignment groups to Excel Shortcuts tab on Ribbon.
  • Changed Drop-down for Venues on Quote Form. It is located in different off-print area location.
  • Corrected Templates columns (deleted duplicate Tools columns, inserted missing columns on Main Board section.
  • Added Excel Status Bar info in macros that take a long time. (Except on the Restore macros).
  • Corrected sort after refresh on Admin sheet for Ingredients & Tools Categories.
  • Corrected various macros that ended on the corresponding DB sheet instead of the Manager sheet.

 

cakepricer se 3.0.4.7

Released on 01/17/2024

  • Added Simple Syrup lines for each cake flavor on Cake Entry
  • Added Icing Dam line for each filling layer on Cake Entry
  • Corrected VBA showing run time for certain macros
  • Corrected formulas for # servings per tier on Cake Entry
  • Changed drop-down choices for Pan Selection/Dummy Size in Cake Entry Tiers section (Row 40) (now only shows dummy sizes for dummy tiers and only cake pans for non-dummy tiers.)
  • Changed Cake Pan database list to filter the default “Sample” row to the end of the pan list.
  • Corrected Contact Search. Was searching wrong column for name.
  • Removed some Yes/No questions on Cake Entry Tiers sections.
  • Corrected Pictures scroll feature. Now only scrolls if more than 1 image.

 

cakepricer se 3.0.3.6

Released on 11/08/2023

  • Fixed Box type not saving to CakeTabsDB, CCTabsDB,& CookTabsDB.
  • Fixed ToolsCategory named range.
  • Added save/update buttons to Pricing Details sheet.
  • Added Add’l Description field for each tier on Cake Entry & Cake Summary.
  • Corrected formula for Tier/Flav # on Cake, CC, Cookies Entry (A18).

 

cakepricer se 3.0.2.5

Released on 10/13/2023

  • Added Flavor Additional Description Field to Cupcakes Entry & Cookies Entry
  • Added Flavor Additional Description Field to Summaries sheet for CC & Cookies
  • Changed formatting on Flavors section of Cupcakes Summary to match Cookies Summary
  • Added Price per CC & Price per Cookie to Summary sheet
  • Added fondant measurement to Main Board section of Summary sheet
  • Added error handling for Quote Form address formulas
  • Added ability to change spreadsheet colors & restore to default colors
  • Fixed Backup/Restore to run more smoothly with less input from user
  • Added Tier Height to each tier on Cake Summary

 

cakepricer se 3.0.1.4

Released on 09/22/2023

  • Cake Entry sheet, corrected formulas for Other Recipes U/M
  • Cake Entry sheet, corrected conditional formatting on Tier 2 Crumbcoat recipe field.
  • CakePansDB, corrected formulas for crumbcoat & filling for Non-US values.
  • CCPansDB, corrected formulas for crumbcoat & filling for Non-US values.
  • Corrected Save/Load function for TierN (FlavorN) on Cake, CC, & Cookies Entry sheets.
  • RecipeDB, Corrected copied formulas to SAMPLE row (row 4).
  • Cake Summary, corrected formula for Icing Dam row on Tiers 1-4.
  • CakeTabsDB, corrected load quote field names for Other Info/Time section (Changed HJ items to HI)
  • Pricing Details, corrected formatting of Tools section (merge/center second line)
  • Corrected formulas on Restore Defaults Template.
 
cakepricer se 3.0.1.3

Released on 09/14/2023

  • Added option to Backup Custom Data when closing application.
  • Corrected Conditional Formatting for CHF & Euro currencies
  • Changed Recipe Cost field to match correct currency format
 
cakepricer se 3.0.0.2

Released on 09/09/2023

  • Fixed Recipe Select giving error “Please select a Recipe to display” when Recipe(s) clicked.
  • Fixed wrong recipe ingredients loading when Recipe selected on Recipes sheet.
  • Fixed Currency Conditional Formatting on Admin sheet. Non $ currencies not included on all necessary fields.
  • Fixed formulas for NonUS thickness fields in Cake & CC Preferences sections of Admin sheet.
  • Fixed backup template, Admin sheet, conditional formatting.

 

cakepricer se 3.0.0.1

Released on 09/04/2023

  • Changed Dummy Tier/Cake Flavor 1 on Cake Entry to remove Dummy Cake from the RecipesDB.
    • Eliminates the possibility of the name “Dummy Cake” being changed by the user.
  • Removed “Recipe #” from Tiers & Flavor Combos on Entry sheets.
  • Changed conditional formatting on Cake Tiers based on “Dummy Tier?” field.
  • Minor bug fixes.

 

cakepricer se 3.0.0.0 – MAJOR RELEASE

Released on 08/16/2023

  • WORKS ON EXCEL 2019 OR HIGHER OR MICROSOFT 365 ONLY!!!
  • Totally redesigned look and functionality.
  • New Sheet: Admin (Combined Company Info, Categories, & Preferences to 1 sheet)
  • New Sheets: Cookies (Entry & Summary sheets)
  • New Sheets: Contacts Database (Keep track of Customers  & Venues)
  • New Sheet: Quote Terms & Conditions, now fully customizable
  • Easier cake tiers entry for multiple tiers with same cake, filling, and icing on all tiers.
  • Cake tiers can have multiple cake flavors per tier.
  • New Job Database. No longer have to save cake builds in separate files.
  • Recipes no longer limited to 16 lines of ingredients. Now have up to 38 lines for longer recipes.
  • New Recipes Entry sheet & Database
  • Reformatted Pricing Details Sheet and added Details for Cookies
 
cakepricer se 2.0.6.4

Released on 09/05/2023

  • Fixed metric formula for the following fields on the Preferences sheet:
    • Typical cake tier finished height
    • Typical sheet cake finished height
    • Preferred Filling Height
    • Preferred Crumbcoat Thickness
 
cakepricer se 2.0.6.3

Released on 10/13/2021

  • Fixed Conditional Formatting on Cake Entry sheet, Reusable Supports for Cake Topper.
  • Increased speed on several processes.
  • Fixed formula on SUMMARY – Cake Information: Main Board, third field

 

cakepricer se 2.0.6.2

Released on 07/12/2021

  • Corrected an incorrect formula on the Recipes sheet concerning the default setting for “Cake” recipes with a conversion factor for the amount of batter to fill a pan. This formula was only calculating incorrectly if the user left the field blank.

 

cakepricer se 2.0.6.1

Released on 03/23/2021

  • Corrected an incorrect price calculation on the Recipes sheet. Correction only needed for items listed in volume measurement on the Master Ingredients sheet, but weight measurement on the Recipes sheet.
  • Corrected the name field on Recipe #72 not transferring to recipes lists correctly.
  • Changed names of Restore Buttons in Backup-Restore group on Ribbon.
  • Added new group to Excel Shortcuts on Ribbon to allow user to change the way formulas are calculated on the worksheet.

 

cakepricer se 2.0.6.0

Released on 03/16/2021

  • Added R currency symbol (South Africa ZAR)

 

cakepricer se 2.0.5.0

Released on 02/09/2021

  • Added field to Preferences sheet to allow user to set the thickness of their crumbcoat. Allows for more accurate recipes needed for crumbcoat.
  • Added field to Preferences sheet to allow user to set the usual height of a single tier. Used in calculation of crumbcoat thickness.
  • Added field to Preferences sheet to allow user to set the usual height of a sheet cake. Used in calculation of crumbcoat thickness.
  • Added column to Baking Pans sheet used for calculating crumbcoat thickness.
  • Changed “Cake Pricer Help” tab on Ribbon to include separate buttons for reloading custom entries into new version from old version and from reloading from existing version.

 

cakepricer se 2.0.4.0

Released on 12/18/2020

  • Added “Recipe Pan Fill” field to Recipes Entry field. Allows more accurate calculation of batter amounts needed for an order.
  • Added “Cake Name” field to Cake Entry sheet. Transfers to Cake Summary sheet when printed to PDF.
  • Added “Cupcakes Name” field to Cupcakes Entry sheet. Transfers to Cupcakes Summary sheet when printed to PDF.
  • Changed drop-down lists to have option of larger font and easier entry. Original method still works if preferred. Double-click in any drop-down field to see list with larger font and also for more predictive fill-in.

 

cakepricer se 2.0.3.4

Released on 11/06/2020

  • Minor bug fix
 
cakepricer se 2.0.3.3

Released on 10/22/2020

  • Fixed #NAME? errors in various cells.
  • Fixed conditional formatting on Cupcakes Entry sheet.
  • Fixed conditional formatting on Cake Entry sheet.
  • Removed cell for manually adjusting time on Cupcakes Entry sheet.
  • Added auto-calculated total for all time on Cupcakes Entry sheet.
 
cakepricer se 2.0.3.2

Released on 09/14/2020

  • Corrects problems associated with the Windows 10 Update, version 2004, OS build #19041.508.

 

cakepricer se 2.0.3.1

Released on 07/09/2020

  • Added new button to Cake Pricer Help tab. Allows entry of  new Activation Code for extension of trial period (special circustances) or switching the code to the Registered Version code before the trial period expires.
  • Fixed conditional formatting on Cake Entry sheet for 1 tier, cell E49
 
cakepricer se 2.0.3.0
Released on 12/17/2019
  • Added Quote page to Backup-Restore so that custom changes to the terms & conditions backs up and user doesn’t have to re-type it if it has to be restored.
  • Added Quote page to Quote Save so actual Quote with Quote# and Revision# stored.

 

cakepricer se 2.0.2.0
Released on 12/04/2019
  • Added Revision # line on Quote Form.
  • Changed some wording on Terms & Conditions of Quote Form & reformatted printing to account for added line above.
  • Changed formulas on Cupcakes Pricing Details to give more accurate pricing for icing & cake batter.
  • Added a field for a manual adjustment of calculated preparation time.

 

cakepricer se 2.0.1.5
Released on 11/17/2019
  • Changed Cake/Cupcakes Entry section for gumpaste flowers to be drop-down list from Main Materials Lists.
  • Adjusted SORT macros to work for Excel 2010

 

cakepricer se 2.0.1.4
Released on 11/15/2019
  •  Formatted columns on Baking Pans screen to be narrower.
  • Formatted Summary-Cake Information (1-4 tiers) to print on only 1 page.
  • Added conditional formatting to Extra Flavors section of Preferences page.
  • Added Kz currency symbol (Portuguese-Brazil)

 

cakepricer se 2.0.1.3
Released on 10/26/2019
  • Fixed conditional formatting on Cupcakes Entry sheet (rows 28 & 32)
  • Fixed conditional formatting on Summary-Recipes Entry (row 9)
  • Changed “Non-disposable” to “Reusable” on Cake Entry & Cake Pricing Details sheets.

 

cakepricer se 2.0.1.2
Released on 10/23/2019
  • Fixed locked cells on Recipe #46 & #86 in spreadsheet and on Backup Template

 

cakepricer se 2.0.1.1
Released on 10/15/2019
  • Fixed Quote Form footer on second page. Now contains formula like first page of quote.
  • Fixed Quote Form Terms & Conditions section to show all verbiage. Was previously obscured.

 

cakepricer se 2.0.1.0
Released on 10/06/2019
  • Bug fixes (conditional formatting) on Cake Entry page.

 

cakepricer se 2.0.0.0
Released on 09/01/2019 – Major Update
  • Added new Ribbon for better navigation.
  • Removed all old navigation links.
  • Added new macros to simplify backups & restores.
  • Removed # of layers calculation on Cake Entry page & Preferences page. It is now a manual entry on each tier. This made it usable for more people and made more sense.
  • Added macro to copy mailing address to delivery address section.
  • Changed conditional formatting on Filling drop-downs to be more accurate based on Preferences page.

 

cakepricer se 1.3.1.2
Released on 06/15/2019
  •  Changed trial validation to 1 time per day instead of at random.
  • Removed custom Excel tab in ribbon.
  • Added access to Excel’s normal ribbons & controls.

 

cakepricer se 1.3.1.1
Released on 04/01/2019
  • Corrected named range for Rectangle Cake Drums
  • Centered cells for color of cake drums
  • Removed erroneous drop-down for cake drums (should have been an empty cell.)

 

cakepricer se 1.3.1.0
Released on 03/12/2019
  • Fixed formula on Lists page to include all Icing recipes correctly.
  • Added Color field for Cake Drums (drop-down list).
  • Added Color information for Cake Drums to Cake Summary Sheet.
  • Changed field for Wrapping Paper on Cake Entry page to automate the measurement based on Preferences choice.
  • Added Wrapping Paper to Contact Paper list on Master Materials page.
  • Added previously omitted Wrapping Paper calculation to Main Board section of Pricing Details page.
  • Added Color drop-down selection for Cake Drums on Cake Entry page.
  • Added Cake Drum Color information to SUMMARY-Cake page.
  • Added sample wrapping paper to Main Materials page…Floral Fancy Foil, Red.
  • Corrected formula for Unit Cost of Contact Paper/Wrapping paper on Main Materials page.
  • Corrected various conditional formatting on Cake Entry and Cupcake Entry pages.

 

cakepricer se 1.3.0.1
Released on 02/13/2019
  • Changed font on Quote Form to larger size

 

cakepricer se 1.3.0.0
Released on 12/21/2018
  • Added “Undo” button to Cake Pricer SE tab on ribbon.
  • Added “Back-up” button for custom entries.
  • Added “Restore” button for custom entries.
  • Added “Get Version #” button to easily see what version of the spreadsheet is running.
  • Changed copy/paste capabilities to allow for copying and pasting custom information back to sheet from back-up if needed.
  • Batter-Icing Amounts Sheet
    A. Changed several entries to give more accurate quantities.
    B. Changed instructions at top of page.
    C. Changed order of columns
    D. Changed name of Column C to “Pan code for sorting” to allow for easier sorting of cake/cupcake pans.
  • Changed Tools sheet to table and added rows to 1100
  • Added rows to Main Ingredients sheet to 1200

 

cakepricer se 1.2.3
Released on 11/02/2018
  • fixed Batter & Icing Amounts # of dowels needed for dummy tiers to give correct # of dowels for a real cake underneath a dummy cake.
  • changed “Choose your currency symbol” to be mandatory entry.

 

cakepricer se 1.2.2
Released on 11/01/2018
  • fixed #VALUE error on calculated time for Cake Entry & Cupcakes Entry, corrected conditional formatting errors

 

cakepricer se 1.2.1
Released on 10/20/2018
  • Fixed “Additional Information” field not accessible on Cake Summary; corrected various conditional formatting errors

 

cakepricer se 1.2.0
Released on 10/15/2018
  • Added “Other Recipe” options to Cake Entry & Cupcakes Entry with formula links

 

cakepricer se 1.1.1
Released on 10/05/2018
  • corrected items on conversion chart; corrected various conditional formatting errors

 

cakepricer se 1.1.0
Released on 10/01/2018
  • Added International currency symbols & conversions; minor bug fixes

 

cakepricer se 1.0.1
Released on 09/15/2018
  • Minor bug fixes

 

cakepricer se 1.0.0
Released on 09/07/2018
  • Initial release
  •