Hello all,
I work for a food manufacturing business which still operates a largely paper based reporting system. At present the business is unwilling to invest in dedicated software so I am hoping to utilise excel in an attempt to reduce some process.
At the moment, 4 departments hand write a log of production for the day. These have column headings start time, finish time, product, units planned, units produced, staff used and waste. This is passed to a factory manager who types up the results into a weekly workbook for the whole factory, broken down into daily sheets. There is a summary sheet for the whole week.
Each department has a computer, so I am proposing they type their log themselves, linking the 4 workbooks to the weekly workbook, keeping it simple with =Cell rather than lookup formula.
The weekly workbooks daily sheet would look something like the below with column headings as described above.
Department 1
Row 2
-
Row 10
Department 2
Row 12
-
Row 20 .....and so on
A possible issue with this is the requirement for extra rows. I could work around this by making the range for each department much larger than needed.
My question is, how would you approach this task? What problems do you see with this?
I work for a food manufacturing business which still operates a largely paper based reporting system. At present the business is unwilling to invest in dedicated software so I am hoping to utilise excel in an attempt to reduce some process.
At the moment, 4 departments hand write a log of production for the day. These have column headings start time, finish time, product, units planned, units produced, staff used and waste. This is passed to a factory manager who types up the results into a weekly workbook for the whole factory, broken down into daily sheets. There is a summary sheet for the whole week.
Each department has a computer, so I am proposing they type their log themselves, linking the 4 workbooks to the weekly workbook, keeping it simple with =Cell rather than lookup formula.
The weekly workbooks daily sheet would look something like the below with column headings as described above.
Department 1
Row 2
-
Row 10
Department 2
Row 12
-
Row 20 .....and so on
A possible issue with this is the requirement for extra rows. I could work around this by making the range for each department much larger than needed.
My question is, how would you approach this task? What problems do you see with this?
