4 Replies Latest reply: May 2, 2012 8:40 AM by Mark Sheraton

# Production plan on Gant chart

Hello,

I have a production plan simmilar like on below picture:

 Order Start date Start time Finish date Finish time MO_1 20120101 600 20120101 2400 MO_2 20120101 1200 20120102 335 MO_3 20120102 400 20120103 2351

[start time] is in format HHMM

I'd like to read this table to get a gant chart with production plan for days, like one below (black means production at this time of a day):

 Order DATE 20120101 20120102 20120103 MO_1 ░░███████ MO_2 ░░░░█████ ██░░░░░░░ MO_3 ░░███████ █████████

... or maybe You know other/better way to show production schedule and (the best would be) to be able to export it to excel for more detailed analysis...

• ###### Production plan on Gant chart

Hi,

I will answer on my own problem Maybe someone will find it useful.

I did a part of script like this:

repeat('_',(STDT-20120101)*24+round(MSTI/100)-1) & Repeat('X',(FIDT-20120101)*24+round(MFTI/100)-(STDT-20120101)*24+round(MSTI/100)) as GANT_CHART

Explanation:

STDT = start date,

MSTI = start time,

FIDT = finish date,

MFTI = finish time,

I treated date 20120101 as a beginning of the period I'd like to see.

So as a result my table could look like this:

 Order GANT_CHART MO_1 _________XXXXXXX MO_2 _______________XXXXXXXXXXXXXXXXX MO_3 _____________________XXXXXXXX

Quite nice as for a short piece of code

• ###### Re: Production plan on Gant chart

But a graphical solution looks nicer...

• ###### Production plan on Gant chart

GREAT! Thanks!

• ###### Production plan on Gant chart

Just used this, thanks!