iPart - Adding a calculation to the spreadsheet

iPart - Adding a calculation to the spreadsheet

isocam
Collaborator Collaborator
574 Views
2 Replies
Message 1 of 3

iPart - Adding a calculation to the spreadsheet

isocam
Collaborator
Collaborator

Can anybody help???

 

I have an iPart (for testing) that has three values.

 

The first two values are: ChainPitch = 50 & NumberOfTeeth = 8.

 

I need the third value (shown in yellow) to be calculated using the formulea: ChainPitch/SIN(PI/NumberOfTeeth)

 

Is it possible to add the above calculation to the spreadsheet in the yellow column?

 

Many thanks in advance!!!

 

Darren

0 Likes
575 Views
2 Replies
Replies (2)
Message 2 of 3

imajar
Advisor
Advisor

Set up the equation in the parameters first, then it will automatically fill in the ipart author and work.

 

Capture.JPGCapture1.JPG


Aaron Jarrett, PE
Inventor 2019 | i7-6700K 64GB NVidia M4000
LinkedIn

Life is Good.
0 Likes
Message 3 of 3

johnsonshiue
Community Manager
Community Manager

Hi! Another approach similar to Aaron's is to link the cells in Excel. Edit the table in Excel and write the equation by linking columns.

Many thanks!



Johnson Shiue (johnson.shiue@autodesk.com)
Software Test Engineer
0 Likes