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
|