Q
QSM_Rick
I found an inconsistency in our document control scheme. Some of our Excel forms are multiple tabs. These different tabs are essentially a packet. One tab is one portion of the form, another performs a different task, so on. Is it a requirement that, since each tab performs a different sub-task of the overall process that's being addressed, that each tab must instead be a stand-alone form?
One such example:
F-136 Quote Sheet
First tab: 100. This tab explains what components we're going to need. Think of it as a Bill of Materials.
Second Tab: Route Sheet. This tab explains what work is to be done, in what order, and at what time duration for each task.
Third tab: Labor Quote. How much is each task going to cost?
Fourth tab: Quote Calc. This tab brings all the others together and presents the math results by bottom line and itemized.
The question originates from the desire for what I'm calling "conversion data". How much does each employee need to accomplish per hour to achieve 100% efficiency? That figure will be included somewhere in the documentation on the production floor. Since these figures will be used in production, the document must be controlled. Since they're going to be on the floor, it'll be printed. Since it'll be printed, the entire packet must be printed and find its way to the floor. Should it be acceptable to keep it all as a workbook, the formulas within the file would remain intact. Should the file be broken apart into different stand-alone forms, those formula dependencies are going to be broken.
I know this is long-winded, but we've seem to have found ourselves in a rabbit hole. Thank you for time and guidance.
One such example:
F-136 Quote Sheet
First tab: 100. This tab explains what components we're going to need. Think of it as a Bill of Materials.
Second Tab: Route Sheet. This tab explains what work is to be done, in what order, and at what time duration for each task.
Third tab: Labor Quote. How much is each task going to cost?
Fourth tab: Quote Calc. This tab brings all the others together and presents the math results by bottom line and itemized.
The question originates from the desire for what I'm calling "conversion data". How much does each employee need to accomplish per hour to achieve 100% efficiency? That figure will be included somewhere in the documentation on the production floor. Since these figures will be used in production, the document must be controlled. Since they're going to be on the floor, it'll be printed. Since it'll be printed, the entire packet must be printed and find its way to the floor. Should it be acceptable to keep it all as a workbook, the formulas within the file would remain intact. Should the file be broken apart into different stand-alone forms, those formula dependencies are going to be broken.
I know this is long-winded, but we've seem to have found ourselves in a rabbit hole. Thank you for time and guidance.