Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
But a graphical solution looks nicer...
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
But a graphical solution looks nicer...
GREAT! Thanks!
Just used this, thanks!