Version 1.1

This version of the toolbar has significant updates from the previous version. This primary focuses on the use of a local database to manage the data in addition to the excel file. 


Any files used with the 1.0 version will automatically update when opened in the 1.1 toolbar.


Updating from 1.0


Before updating from the 1.0 to 1.1 to make sure to update to the latest excel template to prevent any template issues.


To do this click "Update Template" button on the toolbar.



Once that is done open in the file in the 1.1 toolbar and the following prompt will appear.  Press the update button to start the update.

*Running this update process creates a copy of the file. The original file remains unedited.*



When the update starts a progress bar will appear that displays the progress of the update. 



Once the update is complete you can use the file as normal. You will need to recalculate each profile which is outlined below.


Version 1.1.xx.xx Improvements


Recalculate Mappings


Once you select your profile the "Calculate Mappings" button becomes available.

In this version when you select it you will be able to calculate individual months.

*The first time you run this file you will need to recalculate all the available months then going forward can select what gets calculated"



When calculating a month a progress bar will display the progress.



Once the process is complete you will get a notification indicating how long it took.


Saving The File


When you press save in excel data from the local database will be saved into the excel file.

"If you make changes to the data but don't save the file they will still be saved in the local database."