MS Excel lift table

[Todd84]

I get lift tables for camshaft lobe profiles. I don't do cams very often. Does anyone translate lift tables in MC to get a lobe profile? The lift tables have degrees in colum A and amount of lift in Colum B. You also have a base circle dia to go off of.

 

Ex. Base circle of 1.5

 

-68 0

-67 0.0000000

-66 0.0016172

-65 0.0064698

-64 0.0145564

-63 0.0258071

-62 0.0405157

-61 0.0580948

-60 0.0769355

-59 0.0956102

-58 0.1144759

-57 0.1347069

-56 0.1579777

-55 0.1859971

-54 0.2203049

-53 0.2621679

-52 0.3125459

-51 0.3720894

-50 0.4411572

 

Any ideas would be greatly appreciated.

[mgsanchez]

I haven't done what you are trying, but I have imported X,Y,Z co-ordnates from Excel into Mastercam.

 

What I have done is to export the Excel file as a ASCII file (*.txt), then import into Mastercam as an ASCII file. This will get you points that you can create arcs from 3 points. You will have to play with your export formatting, i.e. (1.000, 1.000, 0.000), with X first, Y second, Z third and so on.

 

Hope this points you in the right direction.

Mike

[mgsanchez]

One more thought, in Excel, you will have to write a trig formula to get your XYZ position (something like you would do to find XY positions for a bolt circle). In your formula you will also have to add your base circle to your lift. All that is left is to export XY numbers from Excel, and import into Mastercam.

 

Hope this helps,

Mike

[Roger Martin from CNC Software]

ASCII import is -> X,Y,Z

 

Todd as Angle, Distance (+ an additional value needed to be tacked onto each distance).

 

As you mention, you could do a formula in Excel to calculate/convert this data. But I'm not sure about handling for multiple rows, unless you repeated the formula?

(I'm certainly not an Excel expert)

 

No worries though -

I've contacted Todd and it appears that we have it under control.

[Todd84]

Thank you for your help

[mgsanchez]

quote:

---

As you mention, you could do a formula in Excel to calculate/convert this data. But I'm not sure about handling for multiple rows, unless you repeated the formula?

(I'm certainly not an Excel expert)

---

Roger,

 

It's not difficult to do in Excel. Once you write your formula, it's pretty much cut and paste after that, including the formatting for multiple rows.

 

It's amazing what can be done with a spreadsheet.

Mike

[rythan]

What if I have a part only giving me the X, Y, and R coordinates. Is it possible to import the R coordinates?

[John Summers]

Todd: I have a special program to do this. If you send me your whole offset file, I will run it for you. I'll send you the program anyway, but I want to make sure my program runs with your data. I'm assuming a flat cam follower. If it's a roller follower, you'll have to tell me. Basically, the program intersects a bunch of lines which represents the follower as it rotates about the stationary cam.

[John Summers]

MIKE@RYTHAN: Usually, X and Y determines R, so most files are X,Y or A,R (angle and radius). Maybe you could come up with more information as to what X,Y and R represent.