Production plan on Gant chart

[boryspower]

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...

[boryspower]

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

[hic · Accepted solution]

But a graphical solution looks nicer...

[boryspower]

GREAT! Thanks!

[RedSky001]

Just used this, thanks!