Thread: excel-inventor
View Single Post
  #3   Spotlight this post!  
Unread 18-05-2004, 16:15
Greg McCoy's Avatar
Greg McCoy Greg McCoy is offline
boiler up!
FRC #3940 (CyberTooth)
Team Role: Engineer
 
Join Date: Feb 2002
Rookie Year: 2002
Location: Kokomo, IN
Posts: 484
Greg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond reputeGreg McCoy has a reputation beyond repute
Send a message via AIM to Greg McCoy
Re: excel-inventor

Yes!

It is totally possible. I used this for school and on some projects it makes life a lot easier, I'll try and post an example tommorow.

I set up a sheet that Inventor sees as the first sheet in a workbook. I believe it only views the first sheet in a workbook when you use the Link button on the parameters page. The columns in this first sheet include (at least) variable name, value, and unit type. To do the actual calcuation I used other sheets in the workbook and then simply made the cells on the first "Inventor" sheet equal to the proper values.

<edit>
Thanks for the screenshot Clark, I didn't realize you'd posted. After you link the spreadsheet to Inventor you then type the "variable name" which you place in each row of the spreadsheet in the equation field on the parameters dialog box. I think that all of this is explained more clearly in the Inventor help.

Anyway, I'll try to post the spreadsheet tommorow...

Last edited by Greg McCoy : 18-05-2004 at 16:23.