Process cockpit board

[mikkisbee]

Hello,

I'm currently interning at a big machining workshop. The workshops process is heavy duty, and cycle times in phases are usually counted as days.

cockpit.JPG

We are currently collecting cycle time data from the process. Everytime a piece gets trough a phase, the finish date gets registered in to an Excel file. The upper side of the picture attachment is a simplification of it.

I'm now looking for a way to form a visualization of the process situation, something like the lower part of the picture attached. The "piece" -shapes would process forward and get organised one on the other everytime a new phase finish date is registered. The shapes would disappear in the end of the process, and new ones created when a new piece is registered to the system. Later on there could be all kinds of visual formattings and warnings and stuff on the shapes based on deadlines or other matters.

I'm not expecting someone to give me a finished solution or answer, but i'm looking for tips and ideas on where to get started. I'm familiar to basics of VBA, and I'd be keen to master it.

What do you think would be the best way to get started on creating a shape-based visualization?

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)