The calculator will be structured into 4 worksheets:
This function is essential for calculating the Measurement Over Balls. The Excel calculator must solve for the specific pressure angle at the point of contact with the measuring ball. This requires an iterative calculation (Goal Seek or Solver) unless you use an approximation formula, but for high precision, an iterative macro or circular reference is best. din 5480 spline calculator excel new
The math involves iterative calculations for major diameter, minor diameter, form diameter, and measurement over balls/wires. Doing this manually invites errors. The calculator will be structured into 4 worksheets:
' --- 6. Output to Sheet --- ws.Range("B9").Value = d ws.Range("B10").Value = db ws.Range("B11").Value = dp ws.Range("B12").Value = "See Note" ' Form diameter requires complex tool data ws.Range("B13").Value = da ws.Range("B14").Value = df but for high precision