Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 229
- Office Version
- 365
- Platform
- Windows
I am working on a Visual management sheet that will use pictures of a part to show how often a specific component on the part is replaced. I worked out the math formulas and conditonal formatting.
right now i am using the linked Camera tool to take pictures of each formula result and laying it over the component. The idea is highlight what areas to focus improvements to reduce replacements.
The idea is as we populate a record sheet with data the image maps which we want showing on a monitor on the floor will update in thier numbers over each component.
what should i be mindful or is there any VBA or Options i should consider to make this process to work smoothly with out having too many sheets open at once or being too resource heavy (slow performing work sheet)
to give you an idea of data flow.
we have 1 workbook where the data will be entered by the group that will perform the tasks. i then use another workbook to reference that one (because its 58 megabtes and 40 tabs with pictures) to do a bunch of count ifs with conditional formatting. i will then add tabs to this new work book to include simpler imagers with the linked cells.
what we had done on the floor before is use power point to run a slide show of data. because we want the different parts to cycle through over time for team members to review. so i set up a simple power point with an excel object. so far it seams all work sheets have to be open for everthing to work but is there a better way?
right now i am using the linked Camera tool to take pictures of each formula result and laying it over the component. The idea is highlight what areas to focus improvements to reduce replacements.
The idea is as we populate a record sheet with data the image maps which we want showing on a monitor on the floor will update in thier numbers over each component.
what should i be mindful or is there any VBA or Options i should consider to make this process to work smoothly with out having too many sheets open at once or being too resource heavy (slow performing work sheet)
to give you an idea of data flow.
we have 1 workbook where the data will be entered by the group that will perform the tasks. i then use another workbook to reference that one (because its 58 megabtes and 40 tabs with pictures) to do a bunch of count ifs with conditional formatting. i will then add tabs to this new work book to include simpler imagers with the linked cells.
what we had done on the floor before is use power point to run a slide show of data. because we want the different parts to cycle through over time for team members to review. so i set up a simple power point with an excel object. so far it seams all work sheets have to be open for everthing to work but is there a better way?
