So I'm making a design table driven sprocket and I'm having difficulty getting the "caliper measurement". That's when you measure a sprocket from low point to low point while its still on a shaft.

> If it was always an even or odd number that's easy but I plan to have both in my sprocket

> I cant make a sketch after the circular pattern because the number of teeth change.

I cannot for the life of me figure out the equation or geometry to set this up. Please help?

SW 2017 SP5

Matt Peneguy wanna compare notes?

As you say, it is "easy" if it is either even or odd numbers of teeth. Well it is just trigonometry so it is doable.

Why not use the "if" formula in your equation? Something like:

=if(("tooth count" / 2) - int("tooth count" / 2)=0, something_if_even, somthing_else_if_odd)

It might transform to IIF, but that doesn't matter.