I work in the automotive industry. We have to conduct Layered Process Audits. Simply put, we do audits at various steps in the production of a piece. In theory, there can be generic questions asked and specific questions asked. The generic questions can be asked of all parts we produce. Specific questions, however, are individualized for each part (of which we make hundreds).
Every audit, which is done daily, should not contain hundreds of questions to ask, thus why I want them randomized. There needs to be a certain number of questions asked per category–let’s say 2. But, if my pool for that category contains 8 questions, I have to know which question was asked. The answer choices are always the same “Yes” “No” “N/A”. The idea is so that our auditors and supervisors don’t get into a “rut” always asking the same questions AND not looking for other issues. “I didn’t know to look for that, you never asked.”
Does that help explain the Why a little better?
I am going to provide the structure of the question pool via a screenshot in a second. Let me explain a little of what you are about to see.
In addition to randomizing questions, I need to be able to track anything that gets marked as a “No.” (Column H) That means we did something wrong and that question for that part should be asked again every day for the next 30 days. We want to ensure that we have truly corrected the problem. (Column G will record when the part was last audited no matter the answer.)
In addition, a “No” answer will trigger a Reaction Plan specific for that question. (Column F). What I need to exactly do with that column? I don’t know at this time. It is incomplete with data anyway. But it will be incorporated at a later date.
I wasn’t sure if that was the best table of my spreadsheet to capture the dates, so I also included it on the Parts table. Because I will want to know the last time a question was asked AND the part. So I may actually have to concatenate the Part and Question and Answer to best track the date. (Here is the data structure as it exists right now, however.)
Structure for main app page:
I hope that provides a clearer picture of what I am looking to do.
Thank you. I appreciate the help.