November:
Newsletter Home  |  Online Survey |  Product News  |  Tips and Techniques  |  Featured Story 
|  ProModel Home

Tips and Techniques

ProModel MedModel ServiceModel Technique


Technique: Gantt Chart Program

Generic Gantt Chart Program.xls

A few things you should know about the data formatting in the table below the Gantt chart. The data is exported from ProModel using the Array Export Feature.

1. It is in what I call Military Decimal format that is, 19.3 is really 7:18 pm. Each decimal is 6 minutes. 7.95 is really 7:57 AM and so on.
2. I have a simple ProModel Subroutine that I wrote that converts ProModel Clock time to this format, it is shown below:

Suppose you want to store the current time as the start time of Bar 1 in your export array. You would call the subroutine in your code like this:

GanntChartArray[NextRecord,4] = S_ChangeToRelativeHrs(Clock(hr)) - It has one parameter (type = real) called Value in the code below

The code in the above subroutine is only one line long:
Return Value @ 24 + Value - Trunc(Value) // Changes to relative clock time 0-24 hrs

I'm making the Gantt Chart Program Open Source (like Linux) so feel free to modify the Gantt Chart Program and email it back to me for myself and others to enjoy the improvements you have made.

Steve Courtney
ProModel Solutions
972-462-0428
SteveC@ProModel.com