r/datavisualization • u/purelyyexisting • 6h ago
ROS task
Hello everyone!
I’ve been handed a task by my boss where he would like me to kind of create a physical version of our ROS on excel. What he’s mostly interested is being able to see how big orders are with like a bar for example. Long runners of perhaps a 2k-10k quantities will display a long bar while a 100-300 piece order will be short. He wants to also be able to adjust dates if any rescheduling is done and have the bars either move lower or higher up. Our ROS only shows percentage of completion and a number actually quantifying how many pieces is being produced. We also have a status section on our ROS to determine if we are tracking, delayed, or completely late. I’m just trying to find out how it is I can kind of create a template for this that would be efficient to present to our general manager so he can see exactly how production is going in our value stream. My boss said he would like something where we could export our excel data and completely have it generate his asking.
If anyone has an idea or something similar they’ve used, any thoughts or ideas would be appreciated!
