Graphical display based on generated BOM
Our take
In the evolving landscape of data management, the integration of graphical displays into tools like Excel-based product configurators represents a significant step forward in enhancing user experience and operational efficiency. The article by J0ne5 highlights a common challenge faced by many businesses: the need to visualize complex data, specifically through the creation of a Bill of Materials (BOM) that now includes a layered 2D graphic. This initiative not only aims to streamline the quoting process but also positions the configurator as a more intuitive tool for users, reflecting a growing demand for visual aids in data-driven environments. This evolution is echoed in similar discussions, such as those found in articles like Creating a graphic with custom located cells populated by a pivot table and Excel to digital asset manager?, where the need for visual representation in data management is underscored.
The shift towards incorporating graphics into a BOM system underscores a progressive vision for data management that prioritizes user engagement and accessibility. By layering images based on user-selected variables—such as size, color, and end fittings, as illustrated in the example of a tow strap—users can derive a more comprehensive understanding of their configurations. This transformation is not merely aesthetic; it enhances productivity by allowing users to visualize their choices, fostering a more intuitive interaction with the data. Such a user-centric approach aligns with the insights from another article, I built an Excel VBA tool that combines multiple supplier catalogs and generates quotations instantly – looking for feedback, which emphasizes the importance of usability in automation tools.
However, the journey towards implementing these graphical features, particularly with the use of VBA, can be daunting for many users, especially those with limited technical expertise. J0ne5’s request for guidance on VBA reflects a broader struggle within the community to adapt to increasingly sophisticated tools without feeling overwhelmed. This points to the necessity for accessible educational resources and community support to empower users to explore these innovations confidently. As the demand for such integrations grows, companies should prioritize creating supportive content that breaks down complex processes into manageable steps, enabling users to harness the full potential of their tools.
Looking ahead, the future of data management lies in the seamless integration of visual and functional elements that enhance user experience. As more organizations recognize the value of graphical interfaces in facilitating user engagement, we can anticipate a trend where visual data representation becomes a standard rather than an exception. This evolution invites a crucial question: How can businesses ensure that their teams are equipped not just to adapt to these changes but to thrive in a landscape increasingly defined by innovation? As we continue to explore and implement transformative solutions, the focus must remain on empowering users to take action, fostering an environment where innovation and accessibility go hand in hand.
We have created a fairly complex Excel based product configurator. We have been using it successfully for about 9 months now, and as with all projects scope create is happening. Currently it is drop down driven to create a BOM of materials that is then used to generate a quote. Now we are wanting to implement a very basic generic 2d picture to go along with the quote. I'm thinking just a library of screen shots of the various BOM options that could be layered overtop each other to create a composite picture. A close example would be a tow strap that has the following variables that I would need account for. Size (1"-4"), Color, End Fitting (loop, hook, chain, etc), plus a couple more.
I'm assuming I would need to utilize VBA for this. However I have very limited experience with VBA thus far. I would appreciate if someone could point me in the right direction for to search for, or tutorial videos to watch. I haven't had much luck finding diy info, just companies wanting to offer their services to build the graphics for us.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Creating a graphic with custom located cells populated by a pivot tableI want to create a graphic with drop down menus that work off of each. So, I select the "Bore size" and the "Class". After I want custom placed cells to populate with the appropriate information based on a separate worksheet that has all of the information for each value. (First Picture Below) Red represents my drop down menus. Once I have populated that, I have a separate spreadsheet (pictured below) with the columns detailed for which variable they are to fill, and it will give me my values accordingly. What terms and capabilities with Excel should I be researching to be able to achieve this? I'm assuming "Pivot Tables" for referencing the information from Sheet 2 to Sheet 1, but I don't know how to get the information to place itself appropriately into the blue sections. Do I have to merge cells to fit there, or can I draw custom cell placement? TIA Also, does anyone know what you would call this type of chart in Excel? The best answer I have so far is "Lookup-Driven Dashboard". Sheet 1 https://preview.redd.it/o4ptbz0ayvmg1.png?width=1325&format=png&auto=webp&s=bddd06bc28023fba707942fd7bdade6341447e7d Sheet 2 https://preview.redd.it/3odfm92ryvmg1.png?width=472&format=png&auto=webp&s=a7c3c27880a79f63916ccc8ff5a1064458bcd239 submitted by /u/West-Doubt6824 [link] [comments]
- Excel to digital asset manager?Hi. I have something like 10,000 entries of designs that my company uses all in 8 spreadsheets with multiple tabs of each. This is how they started organizing and tracking designs long before I started working here. However, these spreadsheets are highly unstable as we have multiple users adding to them daily and the legacy spreadsheets have jpgs and not pngs. They often crash, or worse, one user will log a design, inserted as a PNG, along with a few columns of descriptions, and when another user opens the spreadsheet, that entry or multiple entries don't carry over. We have explored ways to avoid this – turning off autosave did help. But it does keep happening. It seems that because we have thousands of images, sometimes copied into a cell and not inserted, we need to find a new method to catalogue our work. I tried to set up airtable but it requires manual import of each image. So, I'm wondering if you smart people could recommend a solution, away from Excel, to make something like this work. A paid service, app or platform is fine Thanks https://preview.redd.it/y6658b8hfolg1.png?width=1190&format=png&auto=webp&s=a2bb3bb6f41984701040b7dcb5df9064dbc4dfc6 submitted by /u/air621 [link] [comments]
- I built an Excel VBA tool that combines multiple supplier catalogs and generates quotations instantly – looking for feedbackI often deal with multiple supplier Excel sheets when preparing quotations. Each supplier has a different format, different product lists, and different pricing structures. Preparing a quotation meant constantly switching between spreadsheets. So I built a small Excel VBA tool to solve this. The idea is simple: • Combine multiple supplier catalogs in one place • Search items quickly • Add them to a quotation • Generate a professional quote automatically Here are some screenshots of the workflow. https://preview.redd.it/8g8ixybxh0pg1.png?width=1280&format=png&auto=webp&s=773323e7852f8938b4d6a982ad5994666a5d3ae6 https://preview.redd.it/n42zjwqzh0pg1.png?width=1122&format=png&auto=webp&s=29ca58bedb239714213b4a0fa2de6b755b7c1756 https://preview.redd.it/4lrytrw0i0pg1.png?width=629&format=png&auto=webp&s=ed12867c4517724efc559bcf83c0945893418944 The goal was to make quotation creation faster for small businesses that already work in Excel. I would really appreciate feedback from people who regularly use Excel: • Does this workflow make sense? • What features would you expect in a tool like this? • What would you improve? Thanks! submitted by /u/ShahSavareKianee [link] [comments]