Exporting Data to Excel

[Uni Phil]

I'm 100% sure where to put this post but thought this section best suited it.

I have a linkage mechanism which I want to run through like an animation but export the data into an excel document.
The idea behind it is so that I can see how much travel is achieved at one end to the amount at the other, but see this throughout the travel of the linkage.

Is there a way to do this and if so, how?

Cheers

 

[jayanta.diff]

Make some parameter according to ur derived result and link among them make a drawing file of ur product and make a bill of material into whic u can add any parameter and later u can export it into excell format. ope this will work.

Jayanta Sarkar


Senior Application Executive


RHS Engineering Services


WWW.rsh-services.com

 

[dbqq]

Phil,


This probably would have gotten more response in the Mechanism Design Forum. What you need to do is create an Analysis feature in your assembly (between the two objects or datums (etc.) you are trying to track). Then run your mechanism. After running your mechanism, click on the graph icon and load your 'pbk' (playback) file. Highlight both the Analysis feature you created (should see it in 'Measure') and the 'pbk' file (should see it in "Result Set') then plot them. Graphtool will come up. Goto file-->export Excel and save it to disk. Open it up in Excel and you'll see your data. This works for MDO, not sure if it works for MDX.


HTH.


Paul

 

[Uni Phil]

does anyone have a tutorial on mechanism analysis?

 

[Uni Phil]

At last.....We found a use for our maintenance charge!!!!

Managed to find a video tutorial on the PTC website and logged in and looked at that.

dbqq:- Cheers for the heads up on that. I walked through that with no problems what so ever. Worked a treat

Cheers

 

[Mloew]

I had put together this FAQ a while ago on the eng-tips site.

Using Microsoft Excel with Pro/ENGINEER