Quick update and progress report:
Circuit is working with some added safety features that prevent the spindle from starting on its own or if there is a bad cable connection. The motor sounds great with the new bearings but I noticed when it was running on the analog signal from the C41 that it sounded rough, so I scoped the 0-10v output signal and it was pretty ragged.
Attachment 215012
So I cleaned it up with smoothing circuit built with a bank of capacitors (which I may improve with bigger and more capacitors later if needs be):
Attachment 215014
This significantly reduced the analog signal oscillation and the motor sounds so much better and smoother when running.
Attachment 215016
Now the problem is the speed control. After much testing and experimentation I have discovered that there is nothing wrong with my VFD and it in fact does have a very linear frequency to RPM relationship. The problem is the C41 output. It is not linear through most of its range but it is really pronounced at the higher RPM range
Here is the actual motor speed vs commanded speed:
Attachment 215018
And here is output voltage of the C41 vs commanded RPM:
Attachment 215020
If you look the RPM matches the output voltage really well though they are straddling the linear reference lines at different gains. So I have sent a message to CNC4PC to ask how linear this output should be then I will try to get a better card or maybe even make one.
Still waiting on another db9 cable, the supplied one is bad and after countless headaches chasing phantom anomalies in my circuit I discovered it was the cable making bad and intermittent contact.