I was wondering if there was any way to be able to create a custom property for sheet metal parts that will be able to pull in the numeric gauge automatically, such as 11 Gauge and so forth.
I have done this with Excel.
Copy the "Gauge No." column to the right of the bend rad column.
In the "Gauge No." column, enter the formula =D8&" ("&B8&")" and copy down:
Is this what you had in mind?
EDIT: On revisiting, this is display only thing.
I don't believe you can get the gauge from the table.
Perhaps insert a design table that looks up the thickness global variable and assigns a gauge from that.
The way that I read the question was that Eric wanted to be able to "pull" the gauge over into his custom properties - probably so that he could have a property for thickness that read as "12 gauge" instead of ".1046"
I think this would be nice as well, because at one time I wanted to pull the K-Factor from a gauge table.
Kevin Chandler - Your tip is fantastic! I am going to use that!
EDIT: Looks like Kevin was editing as I was typing . . .
You're right though. I wasn't on the right bus.
For your k-factor, the only way I know of to automatically display it is in a cut list properties note linked to a flat pattern drawing view.
Two great tips in a single thread - Thanks Kevin!
I must correct myself again.
You can access your k-factor and assign to a property to be displayed as a linked note on the drawing.
Caeat: You must have a base flange created (for the sheet metal to be present) in order to avoid recreating the below.
So, I suggest creating a sheet metal template with these added, plus with your favorite gauge table selected and at the most common gauge.
With a base flange created, there's a dim you can assign to a GV
Which is then assigned to a property (GVs & properties can't share the same name):
Kevin Chandler wrote: Hello, I must correct myself again.You can access your k-factor and assign to a property to be displayed as a linked note on the drawing.Caeat: You must have a base flange created (for the sheet metal to be present) in order to avoid recreating the below.So, I suggest creating a sheet metal template with these added, plus with your favorite gauge table selected and at the most common gauge.That typed...With a base flange created, there's a dim you can assign to a GVWhich is then assigned to a property (GVs & properties can't share the same name): Cheers, Kevin
Kevin Chandler wrote:
There is something to be said about great minds . . . This is almost EXACTLY what I did a while back when I added the K-Factor to our part template. (As much as I love GVs, I can't believe I didn't use your approach!)
It wasn't an "ideal" set up, and we really aren't using it right now. I had wanted to pull it from the gauge table, but was unable to find a way to do that. This was just a "Band-Aid" - I'm hoping to put some more time into it this year!
The only way i know of for this, and I know it is not what you want, is to create separate start part templates that have the gage pre set. We do use a Macro started by the late Great Wayne Tiffany but edited by us that calculates the bounding box area, determines the thickness and based on the thickness enters the material part number and description.
I will attach it.
Now that I'm on the correct bus, see attached part that uses a design table to lookup gauge text based on GV thickness.
It's material dependent, so templates must be created accordingly.
Reminder: With design table, properties are config specific.
Let me know if this is what you're looking for,
EDIT: Same methodology may be used to look up K-factor based on the material property. (I think )
This might work, we have out bend tables split up by aluminum, steel, and stainless steel.
So essentially you have a separate section that lists all the gauge numbers by thicknesses, then have a box that will auto populate the thickness dimension which will then have another box that will auto populate the gauge number based on the thickness?
Thinking on this last night, I came up with a method to use one design table for all material types.
It would determine the material from the thickness and will also tell you when there is a mismatch between the gauge table and the assigned SW material (currently, there's no linkage to keep these in sync or an indication when they're not).
It was also notify you if the material isn't specified at all.
If needed, I think I can also modify the k-factor based on the selected SW material.
This may be useful for situations where the material grade changes, but the gauge table (and its one K) doesn't.
For example, if you have only one aluminum gauge table and you use 505X and 6061 grades, you must use different K-factors.
When I have time later today, I'll try to get it kitted up and uploaded.
THAT WOULD BE AWESOME!
Then i would imagine i could write a macro to add any equations necessary to make this a value that can be called for in the custom properties to auto populate.
I ran out of time today to implement everything I was wanting to, but I got most of it and my theory proved out, so I can continue on my path.
I didn't get around to driving the K factor, but it uses the lookup logic, searching by material name and return the corresponding value (made up numbers in this table) in the K column which would be assigned to a property and back drive the design accordingly.
Anyhow, I'm out of time for today (and I may be out tomorrow), but give it a look see, if interested, and let me know what you think.
SW2017 files included.
EDIT: BTW everyone, you can implement the no material note using properties and GVs.
A design table isn't needed for this.
I only added it to this table because I was doing the gauge table mismatch scenario and no material was an easy add.
The Caveats are the problem for me. We use 1/8" carbon flat bar, 1/8" carbon diamond plate, and 1/8" aluminum. And each displayes differently. Sometimes 1/8" material is purchased as 11 gauge, sometimes as 1/8" plate (AL), Sometimes as 1/8" flat bar.
And this is just one example. There are many cases where I need the actual gauge to display. The work around is to have a material for each gauge. This is what I am trying to avoid. Being able to pick a wrong material for the gauge being used. Solutions that require more choices than just gauge or with my current work around, gauge and material. Are just extra work.
Retrieving data ...