I'm looking for some advice on how to most effectively present the following information and recorded data in a spreadsheet.
I've been asked to create a spreadsheet where the following information is recorded daily (for an indeterminate number of weeks): Date, Batch quantity, production time, Processors, Productivity % (calculated from the 3 previous values)
The above information is then recorded for the following products:
Product Group1: product a, b, c, d, e, f
Product Group 2: product a, b, c, d, e, f, g,h, i
Product Group 3: product a, b, c, d, e, f, g
In other words, the Date, Batch quantity, production time, Processors, and Productivity % are recorded for 22 products once per day, every day.
I need to understand the best way to efficient record this information and present it.
I am thinking that the first tab can be dedicated to a summary of the average productivity %, perhaps also show the average for each day of the week. The summary tab seems like the easy part...
But what is the best way to position the spreadsheet for data entry? Separate tabs for all 22 products is not going to be practical... Ideally, this should all fit into a single page with the daily values entered vertically (oldest first).
Perhaps I am answering my own question... but your opinion matters:
How about like this...
product a | Batch quantity | production time | Processors |Productivity % | product b | repeat the columns...
day 1 22 2h 3 [calc] ...
My only concern is that doing it this way makes it cumbersome to scroll across 110 (22 x 5) columns in order to enter each day's data!
Any other ideas?
Thanks so much,