PDM Pro Droplists Connected to Excel

EmailFacebookLinkedInTwitterShare

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 […]

Read More

Have you “Inspected” SOLIDWORKS Inspection yet?

EmailFacebookLinkedInTwitterShare

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 […]

Read More

More SOLIDWORKS Tips for Microsoft Excel

EmailFacebookLinkedInTwitterShare

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. […]

Read More

SOLIDWORKS Engineering Tips for Microsoft Excel

EmailFacebookLinkedInTwitterShare

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 […]

Read More

Convert Durometer to Young’s Modulus

EmailFacebookLinkedInTwitterShare

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 […]

Read More

VLOOKUP going to next larger number

EmailFacebookLinkedInTwitterShare

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 […]

Read More