Algorithm for measuring gears implemented with general-purpose spreadsheet software

• Published in: Measurement : journal of the International Measurement Confederation 2016-05, Vol.85, p.1-12
• Main Authors: García-Hernández, C., Gella-Marín, R., Huertas-Talón, J.L., Berges-Muro, L.
• Format: Article
• Language: English
• Subjects: Coordinate measuring machine (CMM); Gear measurement; General-purpose software; Manufacturing engineering education; Spreadsheet
• ISSN: 0263-2241; 1873-412X
• DOI: 10.1016/j.measurement.2016.02.013

[Display omitted] •A method for measuring gears with a CMM is presented.•The algorithm is implemented with general-purpose spreadsheet software.•Results were applied to point to point touch machines, with a single probe.•It can be useful for industrial and, especially, for educational purposes.•A continuous touch probe is not required to apply the obtained results. Conventional methods to verify gears are based on manual measurement instruments, such as vernier caliper gauges, gear pitch micrometers, profilometers, among others. The use of these instruments is widely described in technical literature, while in the actual industrial arena the coordinate measurement machines (CMM) are commonly used to obtain, with the appropriate software, all the parameters including the tooth profile. Commercial software for measuring gears with a CMM is usually based on continuous touch of teeth’s flanks. In the educational centres is still common to find single-point probing point to point touch machines. To transform them into continuous touch machines, new software and accessories are required and costs can be excessive for instructional purposes. This paper presents the geometrical and mathematical principles to develop a software application for measuring gears and describes its implementation using general-purpose spreadsheet software. For this purpose, the conventionally used software of the CMM is supported by a spreadsheet that calculates the probe positions and direction of measurement. The communication between the spreadsheet and the CMM software is established by ASCII files. At the end of this process, the spreadsheet displays the measurement results, thanks to its graphical and computing power, making possible to improve the learning process of students or training professionals.