Inventor General Discussion

Inventor General Discussion

Reply
New Member
codycasale
Posts: 2
Registered: ‎05-02-2012
Message 1 of 6 (373 Views)

Inventor to Excell linking: possible to add more of something?

373 Views, 5 Replies
05-02-2012 11:48 PM

I have a 3d model assembly of a door linked to multiple excell spread sheets. The door has vertical and horizontal members that create the frame.

 

As the door size gets bigger, the frame has more horizontal and vertical members.

 

I can easily change the spreadsheet values, which will then change the length, width and height of the door, but I am trying to figure out a way to link a spreadsheet function to the model that will allow me to change the amount of horizontal or vertical members needed, and have the model automatically update with these members?

 

The frame is built with the frame generator- so the skeleton of the frame is a 2d sketch. I am not simply adding members using the "place" command.

 

I thought that maybe if I went into the sketch, I could create a rectangular pattern in which the value for the amount of features to be patterned could be linked to a spreadsheet value.

 

the problem with this, is that Inventor allows me to "list parameters" in the "count" value box, but once I select a parameter, the count value box turns red because the parameter's title is in letters and not numbers.

 

I tried to then make the title of my parameter a number, but then for some reason inventor wont link a excell value that has a start cell that is a number.

 

Any idea how I could do this?

Distinguished Mentor
swordmaster
Posts: 541
Registered: ‎12-15-2008
Message 2 of 6 (368 Views)

Re: Inventor to Excell linking: possible to add more of something?

05-03-2012 05:25 AM in reply to: codycasale

From what you describe this should be easy to do. Is it possible for you to share your excel spreadsheet.

Also which version of Inventor are you running?

Inventor 2010 Certified Professional
Employee
patrick.miller
Posts: 102
Registered: ‎09-24-2008
Message 3 of 6 (363 Views)

Re: Inventor to Excell linking: possible to add more of something?

05-03-2012 06:19 AM in reply to: swordmaster

You're on the right track using pattern. Without seeing the assembly, I cannot say for sure if you would use pattern sketch, pattern features, or pattern components. 

 

I'm guessing that the Count field is red due to mismatched units (the parameter is length units (mm, in, etc) and count is expecting unitless (ul)). You can specify units in the Excel file, but I would skip the step of using Excel and set count = length / spacing. This will resolve the units issue and eliminate the need for Excel.

 



Patrick Miller
Senior Content Developer
Autodesk, Inc.

New Member
codycasale
Posts: 2
Registered: ‎05-02-2012
Message 4 of 6 (350 Views)

Re: Inventor to Excell linking: possible to add more of something?

05-03-2012 06:58 PM in reply to: patrick.miller

Eliminate the need for excell totally?

 

The reason that we are linking a excell spreadsheet to our model is because we want to be able to update our door size very quickly to produce drawings for clients, and also for non inventor users to be able to do this without having a big knowledge of inventor.

I would like to show my model and excell spreadsheet somehow- is there a good FTP site that I could use to host it online? its about 13MB.

 

It saves so much time to have the model linked- because if a client wants 3d drawings of one of these doors in a different frame breakup or size- to manually build the frame and tracks to the correct length takes a while.

 

I am confused with what you are saying:

 

"but I would skip the step of using Excel and set count = length / spacing. This will resolve the units issue and eliminate the need for Excel."

 

How do I change the count to length/spacing? And what does that mean specifically?Are you saying that you can have the count value = some forum of units? (mm, in etc?) or what?

 

 

Employee
patrick.miller
Posts: 102
Registered: ‎09-24-2008
Message 5 of 6 (344 Views)

Re: Inventor to Excell linking: possible to add more of something?

05-04-2012 04:37 AM in reply to: codycasale

I was stating you did not need Excel to calculate the pattern. It now sounds like you are using it for other reasons, so let's ignore Excel for now.

 

To create the pattern, first create parameters called height (this is the height of the door) and spacing (distance between pattern members). When you create the pattern (sketch, feature, or component), enter "height / spacing" in the Count field and enter "spacing" in the Spacing field.

 

I attached a sample that's in Inventor 2013 (it's all I have installed) and a couple screenshots that hopefully describe it better. 



Patrick Miller
Senior Content Developer
Autodesk, Inc.

Distinguished Mentor
swordmaster
Posts: 541
Registered: ‎12-15-2008
Message 6 of 6 (337 Views)

Re: Inventor to Excell linking: possible to add more of something?

05-04-2012 05:26 AM in reply to: codycasale
just post your excel, that will be a starting point Bruce Sword Autodesk Inventor 2010 Certified Associate Autodesk Inventor 2010 Certified Professional -------------------------------------------------------------------------- CONFIDENTIALITY NOTICE: The information in this e-mail message, including all replies or forwarded messages connected herewith, is confidential, may be legally privileged, and is intended only for the use of the intended recipient(s). If you, the reader of this message, are not an intended recipient hereof, you are hereby notified that you should not further disseminate, distribute, or forward this e-mail message. If you have received this e-mail message in error, please notify the sender as soon as possible by return e-mail message or by telephone at (601) 425-3151. In addition, please delete the erroneously received message and any reply from your system and any device/media where the message is stored. --------------------------------------------------------------------------
Inventor 2010 Certified Professional
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.