8 Replies Latest reply on Apr 10, 2015 10:42 AM by jason van clark

"Gauge" property from "Thickness" property

Jonny Levelius Apr 2, 2015 4:38 PM

I have been looking all day long and still haven't found a clear way to get the actual gauge as a custom property instead of just the thickness property. I was just wondering if anyone had a good idea? Whether it be through a design table or linking it to the gauge table or some sort of API. I am about to give up on this one.

Re: "Gauge" property from "Thickness" property

Ingvar Magnusson Apr 3, 2015 10:03 AM (in response to Jonny Levelius)

Can you please be more specific ?
Moving this thread to "sheet metal" under "modeling and assemblies" might be beneficial to you to get answers.
Like Show 0 Likes(0)

Actions
- Re: "Gauge" property from "Thickness" property
  
  Jonny Levelius Apr 6, 2015 12:13 PM (in response to Ingvar Magnusson)
  
  I would like to be able to get a custom property that shows the sheet metal gauge of the part. Right now I have a thickness custom property that shows a decimal thickness of the part. I thought that there might be a way to use my gauge table that links the thickness property(in decimals) to the column that lists the actual gauges (7ga, 10ga, 22ga, etc.). The end result for what I want to do is be able to link a note to a part and it will show the gauge (7GA) instead of the thickness (0.1875).
  
  Like Show 0 Likes(0)
  
  Actions
Re: "Gauge" property from "Thickness" property

jason van clark Apr 3, 2015 10:22 AM (in response to Jonny Levelius)

You have to access the sheet metal gage table to do this. You will need a macro

cannot get bend table k factor

Jason
Like Show 1 Likes(1)

Actions
- Re: "Gauge" property from "Thickness" property
  
  Jonny Levelius Apr 6, 2015 2:41 PM (in response to jason van clark)
  
  Could you please explain what that macro does or where to insert it? I am a little familiar in Excel VBA but this SolidWorks coding seems like a different planet to me.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: "Gauge" property from "Thickness" property
    
    jason van clark Apr 7, 2015 11:48 AM (in response to Jonny Levelius)
    
    The code goes into a solidworks macro (the code is for a .net environment). You could duplicate the code in Solidworks VBA if you want. Essentially you will tie this to a button. When the button is pressed:
    the excel sheet is opened,
    the gage number is retrieved (based on thickness),
    the excel sheet is closed,
    the gage number is written to a dimension in the base sketch
    A custom property that is tied to the gage number dimension is updated
    I have mine running in a 'listener' dll that is constantly waiting for me to update my sheet metal thickness, so this happens automatically, but that's a story for a different thread
    
    Jason
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: "Gauge" property from "Thickness" property
      
      Jonny Levelius Apr 10, 2015 10:29 AM (in response to jason van clark)
      
      That seems to be what I need if I can get it to work. How do you link the thickness chosen when converting to sheet metal to the thickness on the excel sheet?
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: "Gauge" property from "Thickness" property
        
        jason van clark Apr 10, 2015 10:42 AM (in response to Jonny Levelius)
        
        Create a base flange in a new file
        2015 SOLIDWORKS Help - Creating a Base Flange
        
        Edit the Sheet-Metal1 feature that is created. Make sure the 'Use Gauge table' option is checked. Select the gage table you want
        
        Doing so will set the available thicknesses
        
        Select your thickness, press the green check mark and then run your macro
        
        Like Show 0 Likes(0)
        
        Actions
Re: "Gauge" property from "Thickness" property

Mike Pogue Apr 6, 2015 5:38 PM (in response to Jonny Levelius)

If you are familiar with excel, this would be pretty straightforward to do in a design table. Here isa formula that could be quickly turned to this purpose. Finding the first number larger than .... - Excel User Group
Like Show 0 Likes(0)

Actions