Inventor General Discussion

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

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

357 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: 538
Registered: ‎12-15-2008
Message 2 of 6 (352 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: 98
Registered: ‎09-24-2008
Message 3 of 6 (347 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 (334 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: 98
Registered: ‎09-24-2008
Message 5 of 6 (328 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: 538
Registered: ‎12-15-2008
Message 6 of 6 (321 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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube