Graphical display based on generated BOM

Our take

Introducing a graphical display for your Bill of Materials (BOM) can enhance your product configurator by providing visual context alongside quotes. By layering images of various components—such as tow straps with options for size, color, and end fittings—you can create a composite picture that simplifies understanding for users. While implementing this feature may require some VBA programming, there are resources available to help you get started. Look for tutorials and guides that focus on VBA for Excel to empower your project with engaging visuals.

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.

submitted by /u/J0ne5
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#Excel compatibility#Excel alternatives#rows.com#cloud-based spreadsheet applications#AI-driven spreadsheet solutions#product configurator#BOM#quote#VBA#2D picture#Excel#drop down#materials#composite picture#library#screenshot