What’s New
Version 3.08 Released Feb 21, 2017
Stability and bug fixes
Updated import file handling so that successor dates are updated if a macro in either the start or finish date field triggers a date update since the last time the project was loaded
Updated the date fields if the project loaded uses a different scaling for the date than the scaling that was set for the gantt page
Version 3.07 Released Feb 12, 2017
New Feature – Display Baseline data in Labour Curve Chart
If baseline data is present, then it can be displayed as a series for the labour chart to compare current and baseline demand. Display of the series is configurable via the GanttDiva options dialog
New Feature – external references can be used for multi-project file links
Links can now be added between project schedule files so that dates from other files can be linked to the current schedule. Now large projects can be broken down in a master project linked to many sub-projects.
Useability enhancements
Formulas can now be used in the start and finish fields. If the formula does not result in a plausible date, the original contents of the field will be automatically restored.
Updated handling of the options dialog pulldown list user to select whether a field is hidden or visible. After any change the list cursor will be automatically updated to the next location
Stability and bug fixes
Corrected a calculation error in the labour chart.
Updated date handling in the options dialog to correctly handling UK date format
Version 3.06 Released Sept 19, 2016
Stability and bug fixes
Fixed calculation of start date for an activity with a predecessor FF relationship
Version 3.05 Released Aug 14, 2016
Stability and bug fixes
Resolved exception that could occur during some file imports when logical connectors are enabled
Resolved error in burndown calculation which occurred with some activities where the activity duration was less than the selected interval
When showing baseline data, don’t show baseline labels on the chart to avoid excessive screen clutter
Useability enhancements
Improved algorithm for placement of text after shapes on the Gantt chart
Significantly increased performance for loading large files into the Gantt chart
Added notification when a new version of GanttDiva is available
New Feature – Print Selection Command
Added a new command so that the user can print selections of the Gantt chart from GanttDiva
Version 3.04 Released Mar 10, 2016
Stability and bug fixes
Fixed bug “Compile error in hidden module dConstants” that occurred in some versions of Excel for Version 3.03
Fixed bug related to change in weekend definition via the Calendar dialog. This resulted in implausible date calculations.
Fixed bug related to Pert Chart handling when option is set to “don’t show duration”
Version 3.03 Released Mar 5, 2016
Useability enhancements
Formatting of date field is updated so that when a period of 1 month or greater is shown, only the month information is shown, not month and day.
Colour overrides now also override the default colour for a milestone.
Stability and bug fixes
When selecting multiple columns in the gantt chart are outside of the gantt fields and exception was triggered. This has been resolved
New Feature – Display text on the Gantt Chart
New configuration options have been added so that the task title can be displayed next to the task or milestone directly on the Gantt Chart
Enabling text will result in a Gantt Chart with text as shown below:
Version 3.02 Released Feb 20,2016
Useability enhancements
After loading a project file, the excel save command can be used to save any changes you make to the file. It is no longer necessary to use the Export Project command save your changes.
Version 3.01 Released Feb 15, 2016
Stability and bug fixes
Corrected clearing of the Project Title field in the current session when a new project is loaded
Fixed a problem that can occur with calculation of hammock duration after an insert task range operation
Update hammock handling so that hammock duration will be recalculated even if it has progress reported
Minor performance improvement for excel versions > 2007 in loading of project files
Version 3.00 Released Jan 30, 2016
Major New Feature – GanttDiva Options Dialog
The new GanttDiva Options Dialog changes the way that you work with GanttDiva. It has been created to control all configuration options and replaces the Configuration worksheet. It can be accessed from the GanttDiva Ribbon and any configuration changes are effective as soon as the Dialog is closed. This Dialog offers greater flexibility over the previous version, with several new configuration parameters. A comprehensive update to the Help file describing all of the new capabilities is also included.
Useability enhancements
Project Name will now appear in chart titles
All Charts can now be configured to include data tables at the bottom of the chart
The Burndown chart now has an option to display Burndown in hours or in %
Improved performance for updating dates for activities after the project calendar is updated
Stability and bug fixes
Updated correct colour of milestones after a predecessor update
Corrected error where hammock doesn’t update when dependent activity was updated via direct entry on the Gantt page rather than via the dialog
Corrected handling for burndown calculation when an activity with a future start date has progress reported
Resolved issue where formula in the ETC field will be overwritten when a budget update occurs.
Corrected an issue where an imported project containing macros had the macro replaced by its equivalent value
Version 2.03
Enhancements
Now able to select all cells on a row in order to update formatting information.
Improved speed of update after a calendar update.
Stability and bug fixes
Fixed issues related to calendar handling.
Corrected handling of hammock data entry on the Gantt page.
Corrected hammock predecessor logic handling when predecessor date is changed and falls on a holiday.
Correct several bugs related to handling of macros.
Version 2.02
Stability and bug fixes
Fixed bug where file open and save dialogs on some computers with 64 bit version of Excel triggered a halt. This fix required a change to a new license handler, so existing users who upgrade to this version will need to get a new license (at no additional cost).
Corrected user entry scenario where row height was changed when a new row was created.
Corrected bug where data series are removed from the cash chart when it is visible and a filter is applied.
Fixed bug where a label > 80 characters can trigger an exception when a Timeline chart is created.
New Features – Filter on Task Logic
Filter only the current task and its immediate predecessors and successors. This command is available via the ribbon bar or by right-clicking on a cell on the Gantt page.
New Features – New Commands to Get and Save GanttDiva Settings
You can now save and restore your GanttDiva configuration, including all colours, calendar settings, etc using the Get and Save GanttDiva Settings commands. You can share your configuration with other users so that everyone will have exactly the same settings.
Version 2.0
Performance!
GanttDiva is now significantly faster, and the maximum project size has been increased from 1500 to 3000 tasks
Productivity
GanttDiva now supports multiple cell selection in all fields. Effortless copy and paste both within the Gantt page and from other files to the Gantt page.
New Fields
Two new fields available for user purposes for a total of five user customizable fields
A new field for holding cash values, used in the new Cash Milestone chart
Useability enhancements
Field titles can be configured by the user
GanttDiva remembers the last directory accessed by the user, even between sessions
Comments in fields can be exported in project files.
Fractional values can now be entered for budget, actuals, etc.
Stability
Numerous bug fixes and stability improvements have been incorporated
New Features – Multi Cell copy and paste with full GanttDiva support
Copy data either from within GanttDiva or another file and paste into GanttDiva. If the data is pasted into the Title field, then new tasks will be created automatically. The paste operation won’t change any fields that are hidden by an active filter or overwrite existing data if plausibility checks don’t pass. Copy and paste operations can be performed on any GanttDiva field.
New Features – Cash Milestone Chart
Track Cash flow for your project. Associate a cash value with any task or milestone and chart both current and baseline cash flow for your project via the new Cash Milestone Chart. You must first create a baseline for your schedule using the Set Baseline command in order to see a baseline cash data series.
New Features – Display Baseline Information on the Gantt Chart
Show baseline information for any task in your project. Baseline information can be displayed or hidden via two new GanttDiva commands: Show Baseline Info and Hide Baseline Info
New Features – A new Timeline Chart Style
A fifth Timeline chart style has been added that lets you see the relationship between your activities. This new style provides a Pert Chart style view of your tasks, illustrating the relationship between tasks
New Features – Enhanced Sort Capabilities
Now all the criteria for sorting your data are user selectable via a new dialog
Version 1.36
GanttDiva 1.36 has been updated with two bug fixes
- If either the Project or RES fields were hidden, the “Copy to Clipboard” command encountered an error and would not copy data to the clipboard – this has been resolved
- On some systems, background fill updates to a chart would not be persistent between GanttDiva sessions – this have been resolved
Version 1.35
GanttDiva now supports Excel 2013!
GanttDiva 1.35 has again been updated with a great new set of features:
- The ability to customize colours and background patterns for individual tasks. Any colour in the Excel Palette is available!
- A major update to the Timeline Charting feature with 4 predefined styles and much more customization to allow you to completely customize its appearance. A new command is also included to make it easier for you to drag and drop changes on your chart and capture the updates
- The Free version of GanttDiva has now been integrated into the release.
- The help file has been updated to fully describe the new features
- GanttDiva also has some additional bug fixes to further improve its stability.
Version 1.34
GanttDiva 1.34 has been updated with a great new set of features:
- A new 3D look for the shapes
- Two new reports:
- Burn-down (or S-Curve) to track project progress and generate project metrics such as CPI and SPI
- Timeline to create a chronological single page chart of your project
- New fields and commands to set and clear a baseline for your project
- Updated copy to Clipboard command
- New copy, paste handling for blocks of tasks with automatic update of predecessor links
- Backward compatibility to earlier file formats
- Updates to the help file to fully describe all of the new features
GanttDiva has also been updated with bug fixes to further improve its stability.
As of Version 1.34, updates for versions earlier than Excel 2007 are no longer available.
Version 1.33
- corrected handling for update of Project Title, Manager, baseline date
- improved plausibility checking for Configuration data
- resolved several Excel 2010 64bit version compatibility issues
- added additional sample files
- added new message when labour demand chart command is selected but no tasks have ETC > 0
Version 1.31
- corrected error when using the Load Project command
- added command to ‘save GanttDiva contents” to the Excel XP/2003 menu
Version 1.30
- enable undo operation after a line is inserted
- update cells with correct cell background information after all operations including sorting, import, range deletion, undo operation, etc.
Version 1.29
- replaced Excel file dialog with Windows file dialog as the license manager runtime module can crash when using the Excel file dialog
Version 1.28
- Don’t quit the application when quitting GanttDiva if other workbooks are open
Version 1.27
- Updated calculation of auto filter range to match max area defined by the configuration, regardless of inserts or deletes
Version 1.26
- Updated plausibility checking for duration so that a duration greater than the calendar max can not be entered
Version 1.25
- Updated to work with latest version of Locking program, which hides the VBA code. Update to load configuration data and current Gantt Page contents from an external configuration file and to save this data when the program is closed
- Updated handling of the application caption to display the name of a project loaded into the work-space via the Open Project command, or to update the caption when the entire work-space contents are exported to a project file
- provide a new command to allow the user to save the configuration data and Gantt Page workspace contents
- Add a configuration parameter that allows the user to select whether logical links between tasks are hidden or visible
- intercept the Excel save and save as commands. The save command invokes a saving of the project space and configuration data
Version 1.20
- add an event handler to open a task dialog when the user clicks on any of the following shapes: task, milestone, goalpost, hammock, progress bar
- handle the case where a task has a milestone predecessor and another non milestone predecessor with the same finish date
- disable events while deleting a range of rows
- correctly undo a change in progress without affecting the format information for the date fields
- disable events when opening an import file to prevent error messages
- if scale is 1 day/column, position milestones so that they are centred in the middle of a column
- correct labour demand calculation error when scale is set to 1 day/column
- display hourglass when recalculating dates after a calendar update
Version 1.19
- correct handling in the detailed task dialog when a task is deleted, another task added, its logic changed and then another task is selected.
- remove the ‘Update” button from the predecessor tab of the task dialog form
- allow multiline text entry into the comment field of the detailed task dialog
- if the date scale is set to 1 day/column, highlight weekend days, days off and holidays as per the calendar definition
- in the redraw handling, update successors for a task if a calendar change causes the dates for the initial task to change
- redraw the ‘today’ bar after clearing the gantt page workspace
- correct a bug in handling the undo of a new task creation
- add keyboard short cuts to insert a task, delete a task, open the task dialog. Also update the help file with the list of shortcuts
Version 1.17
- corrected calculation of maximum row count when importing a file. After an import operation is aborted, re-enable event handling
- disable the compatibility checking dialog for excel 2007 and greater when exporting a project
- handle boundary condition where import file row count exactly matches the maximum row count
- handle the double-click handling on a field that may be disabled in the task dialog for the current task type without outputting an error message
- increase max line limit for an import file to 1000 rows
- output row# of the task that has a parsing problem with its predecessor field data
- resync the gantt array with the gantt page contents before opening the task dialog to capture any changes that may have been driven by a formula
Version 1.15
- clear the project manager, title and baseline date fields when all projects are cleared
- allow the user to make changes on rows past the Gantt fields (up to column 21) without triggering an exception. This data will not be exported
- when a cell is double-clicked, the task dialog will open with focus on the appropriate field
- restored formatting information with undo operations
Version 1.14
- updated handling to manage computers that have system time as dd-mm-yy or mm-dd-yy
Version 1.12
- changed colour of selected cell on calendar controls to red to have better contrast on graphic cards that have less distinction between colours
Version 1.11
- updated width of labels on the calendar control by several pixels to display correctly on lower resolution monitors
Version 1.10
- addressed problem in ‘save project’ in which a line reference 1 less than start of the block of lines to be exported was accepted
- addressed a problem in ‘save project’ in which data was saved to the same file name repeatedly. Previous data was not completely cleared before the new
- data was written
- updated messages that the user sees when saving a selection for the save project command
- updated handling after a calendar update. Now any task which is changed will trigger updates to its successors
- Updated handling for import and export project to import and export formulas
- Corrected handling of circular references by the detailed task dialog – only one message will be output
- Corrected handling of circular references when entered directly onto the Gantt page.
- updated handling to restore formulas as well as cell contents for GanttDiva fields where a formula is permitted
- several minor fixes to get rid of messages upon undo command
- added “Change Column width” to the menu
- added gantt view start date initialization from an open project file
- transfer formatting information from the import project t0 the Gantt page
- restored formatting when undoing a change to a cell