SOLIDWORKS design tables help you to efficiently create and manage model configurations. Leveraging the capabilities of Microsoft Excel, you can easily control design parameters—such as dimensions, suppression states, and materials—through cells in a spreadsheet. Once you have your model fully constructed though, there comes the question of how to clearly represent these distinct configurations in a drawing. A tabulated drawing is one popular method to detail a family of similar parts. In this kind of document, varying dimension values are […]
Design tables are a commonly used feature in SOLIDWORKS in order to manage configurations. A common issue that users call into support with is being unable to create a design table. Symptom: When creating a design table, nothing happens or SOLIDWORKS crashes. Solutions: When experiencing this issue there are three common solutions that will resolve most cases. I will list them here then elaborate further on the process for each: Optimize for Compatibility – An option found in Microsoft Excel […]
Everyone loves SOLIDWORKS PDM’s data cards, they are used in so many ways. One limitation though is their values in drop-lists is rather limited. You can control the lists based on one other variable, but if you need something more advanced you are going to need PigeonHole. It can make your drop-lists significantly more advanced. A lot of people like PigeonHole for its ability to have SOLIDWORKS PDM Pro’s droplists filter each other. As an example if you were selecting a […]
SOLIDWORKS released SOLIDWORKS Inspection just over a month ago, so have you looked at it? If you need to do any type of manufacturing validation and create inspection sheets for First Article Inspection then you should be using this tool. SOLIDWORKS Inspection has 2 versions: Standard and Professional. If you want the ability to import CMM data or manually enter measured values to keep everything in one project then Professional is the version you need. Every […]
Last week I posted links to tips for using Microsoft® Excel and SolidWorks. Here is a link to an additional 6 videos to help you use Excel with SolidWorks. Watch Videos – SOLIDWORKS Tips for Microsoft Excel Part 2 Microsoft® Office Excel helps designers and engineers organize their design data, manage design information, and communicate statistics and ideas. Excel can also help solve difficult design problems. It can accelerate calculations as well as control all aspects of a SOLIDWORKS model. […]
One of the most popular, yet under-utilized, engineering tools is Microsoft® Office Excel. Excel is far more robust than most people think. Are you missing a chance to improve your design productivity? Excel can accelerate calculations as well as control all aspects of a SolidWorks® model. SOLIDWORKS has put together a set of tips, in the form a few short videos, to help you use Excel to automate some of your daily engineering tasks. Watch the Videos. Video Highlights: input […]
If you work with rubber and plastic materials frequently, you more than likely have access to a stress-strain curve for use in Simulation. What can you do, though, if you don’t have all the required material properties for analysis? If you’ve ever searched for material properties via MatWeb, IDES or other sources, you’ll likely find the hardness of plastics and rubbers listed in Shore-A or Shore-D – and no Young’s Modulus. Fear not! There is a simple calculation to convert […]
Use Excel as your DriveWorksXpress equation editor.
This week I have working on a rather interesting DriveWorks project where I had to select the proper size of schedule 40 pipe that a given shaft coupler could just fit inside. As an example, if I had a coupler that has an 1.4″ outside diameter, I would choose the 1-1/2″ size pipe. (From the first table below.) The problem is that if I use VLOOKUP to search the table, VLOOKUP returns the next size smaller from the table. Thus […]
Are you an Excel novice but too embarrassed to admit it? SOLIDWORKS has a nice little video I think you will enjoy.