I have a spreadsheet (attached) that I will be using to track some machines. I have filled out a few lines to show how it works as well as the pivot table and the chart that will capture a snapshot of the machines and their productivity. However, what I am currently using is not as deep as I'd like it to be.
So, for activities such as "Standby" I'd like to zoom in on it and say WHY it is on standby. Such as: weather caused the unit to be down, or our client did not allow access, or other. Is there a way for excel to either calculate it or show another part of the sheet that will convey the number to the correct column
my end plan is to have the pivot table create a report that has all the regular headings but as well have the focused ones such as "Standby->Weather related" or "Standby-> Client related" or have it go to the depth of having "Maintenance->operator related->years of experience".
What is the easiest way to do this? manually input the data every day into each column and choose which activity is the best (I prefer this not to be the case as the people working in my office would then cause my data integrity to decrease because they can choose whatever column they want) or would excel help the employee out with showing options without making the spreadsheet take half an hour to open.
Thanks!
Bookmarks