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

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