Continue to Site

Welcome to MCAD Central

Join our MCAD Central community forums, the largest resource for MCAD (Mechanical Computer-Aided Design) professionals, including files, forums, jobs, articles, calendar, and more.

servo motor control with excell

Indusign

New member
Hello All,
This might have been answered previously, but can't seem to find the solution.
I want to control some servo motors in my assembly with excell spreadsheet tables.
If I use only "dumb" numbers in the first to column, all works well, but the numbers Y value must be the result of some calculations. And even if I make a second excell file, with only 2 columns, the first one is the time going from 0 to 100 with a 0.1 step, and the second column is a value copied form a separate spreadsheet with the calculations, it doesn't work anymore.ProE just says : There are no valid XY data pairs in the specified file.
As you can see in the screendump, the table on top has values that are copied from the table in background. I need to keep the link as the values have to be tweaked to obtain max performance.


View attachment 5184
 
I have had no problems with tab delimited files, try
saving the excel files as .txt (tab delimited) then rename
to *.tab and you should be able to open the file direct
from the table menu (wf5)
 

Sponsor

Articles From 3DCAD World

Back
Top