Learn how to work with higher-level calculations.
- [Instructor] Once you have a part designed using a design table, we can now jump back in that design table and really make a lot of adjustments. We can add new parts in, and we can do some fairly complex calculations. Let me show you how we can do that. Let's go over here to the design table. Under Configuration Manager, you can see here, we've got a folder called Tables. Under there, let's go ahead and click on the Design Table, and let's go ahead and right-click on it and say Edit Table. Now, I've made a few adjustments to this part since the last time we opened up the table, and I've changed the color, I've added a description.
In fact, I've added that hole in the center of the part. So now I've got all these other parameters that I can bring in. For instance, here I've got color. Hold down Control, description, all these other things like material, part number, and so on. Let's go ahead and just bring these all in, just for fun. Click on OK, and now those will be added into my design table. Let's go ahead and click on this corner down here on the bottom right, and let's go ahead and drag that table out. And now I'm going to go ahead and just kind of expand some of these rows a little bit here or these columns so I can see it a little bit better.
All right, so now you can see here, because I originally had these dimensions here, now I also have a color or, like, a Pantone color. I can adjust this if needed. In fact, if you click in here, you can just type in whatever number you want. Generally, you have to go back and look and see what the right color number is. I mean, obviously, typing in a random number's probably not going to be the best bet for that, but if you find out one of those color systems, you can type that number in here. As far as my description, I haven't really done anything really great there yet, but this is where you can really start refining your design and your individual configurations of this part a little bit better.
Over here, as far as material, what's cool about material, if you click on this, you can actually choose the drop-down here, and you can choose any of the available favorite materials pretty quick and easy there. And then over here under these under categories, notice if you see something like a part number, for instance, like this one over here. You can click on the drop-down. You can also link this to something else like a document or parent configuration. And over here, you see the S. If you see an S, it means it's suppressed. If you see a U, it means it's unsuppressed.
And it gives you a little bit of a heads up display showing you exactly that. You can either do an S or a U, or a 1 a 0, to suppress or unsuppress something. Now, if you want to create a brand new configuration, it's pretty easy. Just go ahead and just start, let's say, new 4 down here. And now, as far as the dimensions, now, we can just obviously type in the numbers if we want to, but we can also create an equation. So down here, if you just hit Equal, this is very standard for working in Excel. I'm going to create an equation and hit the Equal sign first, and now you can link to other boxes.
For instance, here I'll say this is equal to this box here minus this box over here plus this box over here. It doesn't really matter, you can choose any box you want. The whole point is that we're just linking to other values. Hit enter, and it'll calculate what that value is and put the number in. For the next one over here, if you hit Equals again, instead of just typing the value, you can also choose something like an equation. So you can use any of the built-in equation solvers inside of Excel, like SUM, AVERAGE, and so on.
You can also choose, like, Financial. You can do Math and Trigonometry if you wanted to find the cosine or the sine of something, you could create an equation with this. You can do conditionals like IF, THEN, ELSE statements, logical things down here. And you're pretty much writing the entire program defining the shape of your object here. In fact, you can also even reference other database tables and pull that data into Excel right here. So you really have quite a bit of power by using Excel to drive your part inside of SOLIDWORKS.
Once you've created your equation, of course, just either hit OK or Cancel. In this case, let's just go ahead and put a couple typed in values here, just to illustrate it. Down here, if you want to make a new row, you can use the fill down function. So you can say Fill, Down pretty quickly, and you can create a whole bunch of rows that way. The one requirement, though, is that you do need to fill out every one of these fields. You can't fill out a couple dimensions here and leave the other ones blank. So if you've added those other items in, you have to fill out something that makes sense for all those other fields, so keep that in mind.
Now, if you want to do other things like create graphs or use other space for calculations, if you skip either a row or a column, anything you do out here in this space over here, or if you choose a row, anything below this space down here, you can use that for any other calculations you want. SOLIDWORKS looks for a space, so it finds a space, or an empty row, or an empty column. It won't look any further than that, and so anything you do outside of that is free working space. So anyways, that's basically how you work in Excel and add those features into your SOLIDWORKS part.
When you're happy with what you have, click anywhere outside of that window, and it'll take you back into SOLIDWORKS. In this case, here it's saying we're adding a new material. We're adding a new configuration, which is great. Here's our new configuration number four. Click on that one there, and you can see, we switched over and now we have a little block. So you can easily switch back and forth between any of those configurations. And if you want to make some modifications, it's pretty easy just to jump right back into this design table, hit Edit Table, and make any adjustments you need, and away you go.
First, see how to how to use the sketch tools to create two-dimensional sketches that become the foundation for 3D objects. Next, look at extruding and revolving 3D features; creating complex objects using the Sweep, Loft, and Surface tools; and modifying parts. Learn how to create uniform holes with the Hole Wizard, and explore more advanced modeling techniques using equations, mirroring, and pattern tools. Then review best practices for putting parts together in assemblies and building robust structures. The course wraps up tips for creating detailed drawings that relate the final parts and assemblies to a manufacturer, complete with an itemized bill of materials and drawing notes.
- Working with templates
- Creating sketches
- Extruding and revolving features
- Applying materials
- Sketching lines, shapes, and polygons
- Trimming, extending, and transforming geometry
- Adding fillets and chamfers
- Working with planes and coordinates
- Creating patterns
- Modeling advanced parts
- Making holes
- Designing with blocks
- Building assemblies
- Mating parts
- Linking sketches
- Using design tables
- Creating part and assembly drawings
- Creating dimensions
- Adding annotations