Tutorials

  • relations ×

Designing Approximate Spur Gear in CATIA V5 (Method 2 of 4: Design Table from MS Excel)

William Harbin
in Modeling
2 0 Intermediate
This BND TechSource video shows how to create a “template” part for an Approximate Spur Gear. The difference is; this template is controlled via an MS Excel spreadsheet. This part may be modified by simply changing the parameters of any/all of the following four formulae on the spreadsheet: z - number of teeth // real parameter [z = input] Rpa - Ref Pressure Angle // angle parameter [Rpa = input] m - module // length parameter [m = input] a – center to center distance [a = input] Next we will look at using Import Parameters (from .xls(x) or.txt file) to feed the parameter data and update the Spur Gear. https://bndtechsource.wixsite.com/home Excel Design Table: https://docs.google.com/spreadsheets/d/1cqqmNE9dxuM0XimnIWZSYKZfxsS0zwhj/edit?usp=sharing&ouid=114849995441101610372&rtpof=true&sd=true
CATIA relations parameters table design v5 catia

Designing Approximate Spur Gear in CATIA V5 (Method 3 of 4: import data from .xls(x) or .txt file)

William Harbin
in Modeling
0 0 Intermediate
This BND TechSource video shows how to create a “template” part for an Approximate Spur Gear. The difference is; this template is based upon a one time feed of data via an .xls(x) or .txt file and must be re-imported for every modification. This part may be modified changing the parameters of any/all of the following three formulae on the .xls(x) or .txt file: z - number of teeth // real parameter [z = input] Rpa - Ref Pressure Angle // angle parameter [Rpa = input] m - module // length parameter [m = input] Next we will look at using CATIA Macro + Import Parameters (from .xls(x) or.txt file) to feed the parameter data and update the Spur Gear. https://bndtechsource.wixsite.com/home .xlsx file: https://docs.google.com/spreadsheets/d/1cqqmNE9dxuM0XimnIWZSYKZfxsS0zwhj/edit?usp= .txt file - [m_3-Rpa_20-z_40]: https://drive.google.com/file/d/1t42oaimtwS7LBc7eos5YS9bWjcmjcfeq/view?usp=sharing .txt file - [m_3-Rpa_20-z_25]: https://drive.google.com/file/d/1csdQHt3jfLTE04kCkv03itM05oj0OYQc/view?usp=sharing
CATIA relations parameters data import v5 catia

Designing Approximate Spur Gear in CATIA V5 (Method 1 of 4: manual input)

William Harbin
in Modeling
0 2 Intermediate
This BND TechSource video shows how to create a “template” part for an Approximate Spur Gear. This part may be modified by simply changing the parameters of any/all of the following three formulae: 1) z - number of teeth // real parameter [z = input] 2) Rpa - Ref Pressure Angle // angle parameter [Rpa = input] 3) m - module // length parameter [m = input] Next we will look at using Design Table (from MS Excel) to feed the parameter data and update the Spur Gear. https://bndtechsource.wixsite.com/home
CATIA relations parameters gear spur v5 catia
White Stratasys Logo White GrabCAD Logo
© 2025 Stratasys Inc.
ABOUT US
RESOURCES
Support
SOCIAL
Streamline Pro
Control
Print
Pro
Shop
PARTNERS
COMMUNITY
Contact Us Website Terms of Use Software Terms of Use Privacy policy Trademarks Your Data on GrabCAD
The Computer-Aided Design ("CAD") files and all associated content posted to this website are created, uploaded, managed and owned by third-party users. Each CAD and any associated text, image or data is in no way sponsored by or affiliated with any company, organization or real-world item, product, or good it may purport to portray.