Hitech remains fully operational amidst the Covid-19 challenges. Our business continuity plan is fully in place and allows our teams to conduct 'business as usual' remotely and safely. For any questions, please connect with Bachal Bhambhani (USA) +1 408 338 8047 or Brett Parnham (UK/Europe) +44 782 436 5444.
Back to Case Studies

Excel based SolidWorks Configurator for Custom Door and Frame Design, Australia

Design Automation Case Studies2 min read
Automated Door Design Customization

Project Overview

Client Profile
Doors and Frames Manufacturer
Location
Australia
Industry
Sheet Metal Building Products Manufacturing
Inputs
Custom design needs and database
Deliverables
2D drawings PDFs, DXFs, Bill of Materials (BoMs)
SolideWorks Logo

Business Needs

Develop a tool to automate the door design customization by sales teams or by the customer when design specifications are defined.

Challenges

  • 30-35 customized product designs each having numerous variants causing hassle during design customization
  • Difficulties in managing data-base of input/output design and drawings
  • Time consuming and error-prone repetitive tasks

Our Solutions & Approach

Created MS Excel spreadsheet with VBA scripts to automatically generate standard files, parts, assemblies, drawings, DXF files, BOMs, etc.

Share Your Thoughts

Owing to our strong pre-existing portfolio in the domain, Australia based manufacturing firm approached Hitech teams to develop an automation tool and reduce design cycle time. Automation team working on the project initially studied the SolidWorks models and drawings shared by the client to identify the scope for automation.

  • Primary investigation led the project team to advice manufacturer to create an Excel based configurator for implementing automation at various stages of design and modelling.
  • The user can enter custom specifications in the master Excel sheet which is in turn connected to SolidWorks with VBA API.
  • All the design specifications received from the end-user will be fetched from the CAD library and opened in SolidWorks.
  • User only needs to select the product number and enter data in Excel rows such as require dimensions, end client data, project name, option for generate DXFs and┬áRevisions etc.
  • The final output of assembly models with all technical documents will be created from the master models based on input design specifications.
Excel based SolidWorks Configurator
Excel based SolidWorks Configurator

At the end of project duration a structured MS Excel spreadsheet with VBA scripts were shared with the client capable to automatically generate standard files, parts, assemblies, drawings, DXF files, BOMs, etc.

Business Impact

Project Samples

Design Specifications Received from the CAD Library
Design Specifications Received from the CAD Library
Automated Door Design Customization
Automated Door Design Customization
Email usinfo@hitechcaddservices.com