SAVING SOLIDWORKS GENERATED BOM TO EXCEL FILE

Blog - Solidworks

In a manufacturing Industy  producing a certain unit or product ,BOM is used for communication between manufacturing partners or confined to a single manufacturing plant containing  all components Description,Part Number, Quantity, Materials, etc..If there are many Sub-assembly, It is easy to have BOM in excel file to display  all the parts in  the assembly for easy navigation of components.

In Solidworks, there are templates for computed BOMS, weldment BOMs, and weldment cut lists. Each BOM template can have different data variables displayed in the BOM columns depends on the needs of the user. Just insert all the property or data need before saving as excel file.
For example, a BOM for engineers or designers might have the following columns:

  • Part Number
  • Description
  • Part Number
  • Quantity
  • Material

A BOM for purchasing managers might have the following columns:

  • Vendor
  • Cost
  • Material
  • Part Name
  • Part Number
  • Quantity
  • Unit of Measure

From the Bom Created in Solidworks  just Single Click the BOM so it is selected and then go to file-Save As ( or right-click on the BOM and choose Save As.) . Select save as file type Excel (.xls.).


 
 
 
 
 
 
 
 
 
 
 

How to Create a Screw Thread Flute in Solidworks

Blog - Solidworks

Solidworks usually give us the standard sizes of thread through toolbox. And from smart fastener command we can easily create screws, nuts and washers we need. Screws from toolbox are configured in different standard sizes defends of what we choose during creation.

But do solidworks will give us the screw with correct flute? Or a well detailed screw? Of course not! Because the program need to save memory, simply means creating additional feature means additional memory to be consumed. And this really affects the speed of the program.

It is a fact that in cad designing we do not need a well detailed screw to have a good design. But as wealways say – there is always an exemption.  Sometimes we need to show thread flute for presentation or maybe there is a need for us to show it due to some reasons. This article is just a little tutorial on how to
create a thread flute on a screw we got from solidworks toolbox.

Figure 1 shows a standard socket head cup screw (M5x0.8mm) from toolbox.

Figure: 1

 

Before proceeding, here are the things we need to know before we can create an exact screw threadflute: (1) Type of thread (2) Major diameter (3) Pitch (4) Root depth

 

 

Below is the procedure in creating a thread flute:

1. Create a reference plane. Plane distance should be the equal to thread pitch.

 

 

2 . Sketch a profile based on the prefer thread type.

 

3. Make a cut for thread root diameter

 

4. Create a helix. Helix pitch should be the same on thread pitch.

 

 

5. Make a sweep using the previously created thread profile and the helix as a guide curve.

 

 

6. Cut to make a chamfer on screw end

 

 

After the 6 steps are done you can now see the thread flute on screw from solidworks toolbox .

(figure2)

 
 
 
 
 
 
 
 
 
 
 

Solidworks Photo View 360

Blog - Solidworks

One of the feature of Solid works is the Photo View 360 the visualization and rendering solution, it is easy and lot of fun to work in rendering design parts to make it more realistic with greater accuracy and appeal than ever before that can used for client presentation. It’s a highly interactive environment for viewing designs as well as for creating photorealistic renderings that can use for showcasing designs. It’s as easy as applying the appearances and scenes just drag and drop it onto that part. To change the color, pick on the parts and go to the advanced tab of the material and pick the color in the color options quickly to get some great looking and very appealing images of the design.

 

 

 

 
 
 
 
 
 
 
 
 
 
 

SolidWorks Packages and Enhancements

Blog - Solidworks

 

SolidWorks Standard

SolidWorks Standard has most of the functionalities of part and assembly modeling (such as 3D solid modeling, advanced surfacing, sheet metal, mold design, direct model modification, etc.), 2D drawings (such as dimensioning, annotation, international standards support, drawing compare, etc.), design reuse and validation (such as SolidWorks search, design automation, configurations, design library, 3D models from suppliers, etc.), animations and renderings (such as assembly animation and walk-through/fly-through animations), design validation and simulation (such as collision and interference detection, hole alignment checks, check manufacturability, fluid flow simulation, sustainability, and draft and undercut analysis), and collaborating and sharing (such as import/export, 3D for rapid prototyping, eDrawings, etc.). Some functionality was recently added to SolidWorks Standard 2011 such as the appearance functionalities (controls in PhotoView or PhotoWorks) and decals.

SolidWorks Professional

SolidWorks Professional has all the capabilities of SolidWorks Standard and additional functionalities such as standards checking for 2D drawings, standard component library and task scheduler for design reuse and validation, and eDrawings Professional for collaborating and sharing.

SolidWorks Premium

SolidWorks Premium has the capabilities of SolidWorks Professional plus additional features such as piping/tubing design and electrical cable/harness design for part and assembly modeling; flattened harness drawings for 2D drawings; tolerance and stack-up analysis, kinematic motion simulation, and structural validation for design validation and simulation; and importing scanned data for collaborating and sharing. Both SolidWorks Professional and SolidWorks Premium now have PhotoView 360 which serves as SolidWorks standard photorealistic rendering solution.

SolidWorks 2011 Enhancements

For SolidWorks 2011, there have been enhancements in assemblies (ex: fillets and chamfers), drawings and detailing (ex: dual unit support), enterprise PDM (ex: enterprise PDM menus), model display (ex: DisplayManager), parts and features (ex: defeature for parts), simulation (ex: new 2D simplification study), and weldments (ex: weld beads).


References

  • “3D Design Product Matrix.” SolidWorks. Dassault Systèmes, 2011. Web. 2 Feb. 2011.
  • “What’s New: Highlights of SolidWorks 2011.” SolidWorks. Dassault Systèmes, 2011. 2 Feb 2011.
 
 
 
 
 
 
 
 
 
 
 

Repairing Surface in Solidworks:

Solidworks

Have you ever encountered a surface in solidworks that is deformed or not smooth enough? This usually happen when converting it into a different file format. Well I have a sample that needed some work because some faces are not the way they should be.

(See fig .1)

1. First we should identify what causes the surface to deform, like the tangency of the curves.

Fig. 1

2. After knowing the problem which is the tangency of the curve use before, we should now create a new curve.

As you can see in (fig. 2.1) the difference between the new curves form the old. You could use any of the “curves command” like composite curve or curve through points. After creating the curve you can now delete the surface to be replaced by using the command “Delete Face”.


3. Now that the curves are all done we can now create a new face. We can now do the other faces

4. You could do it in the half part so we could just mirror it and knit it.

• All done!

 
 
 
 
 
 
 
 
 
 
 
More Articles...