Data capture from a production line

Hi there I was hoping someone would be able to help me with a data analysis problem I have.

I work for a caravan company that is in the process of some much needed expansion and updating unfortunately the data capture side is not as much of a priority which is where I sit.

At the end of our production line is a "hand written" logbook with all the faults recorded on each van that comes off the line. for example; line dents, scratches, Out of stock (OOS) GAPs creases in material, damaged parts and faulty parts.
I have tallied all these up and generated Pareto graphs for these and a histograph for management.

Now they want to know the locations of the faults on the vans also for example; near side Off side (NS OS) Front Back top bottom (F Bk t b) toilet cabin (TC) etc

I want to create a pivot table that I can put on a terminal at the end of the line and try an modernise a bit and get our data capture time down to under 24Hrs yes I know an MRP would be the best option but that's not happening anytime soon I am afraid.

Any help with this would be greatly appreciated.

Attachment 467168

Personally I would start by setting up a data page with columns for each "detail", so things like production number, make/model, date of production/inspection, fault type, fault location, full description etc.

Then think about what can be standardised in that list allowing you to use drop down lists for selection rather than free text (this is the bane of any number cruncher's life!) and draw up lists of possible values for each of these. Fault location could be one of those lists for example. If set up well in the first place these can be added too quite easily without need to amend formulas etc.

Next is thinking about what details the management want to see. The graphs you mention are one example, but occasionally a numeric table may be a more effective way of showing detail as not all things lend themselves well to graphs.

Once you have all that worked out you can build a "dashboard" so you can just keep adding details to the list and all the charts and tables will automatically update. You can have time scale selectors and other fancy things to restrict data and the ability to export certain parts and email it to management. That way your data capture can take less time than your current logbook requires and all the figures are ready all the time.

If that sounds like something you may be able to work with then I'm more than happy to help you with it.

BSB