Inventor General Discussion

## Inventor General Discussion

*Yeandle, Laurence
Message 1 of 6 (54 Views)

# iParts for begineers

54 Views, 5 Replies
11-22-2002 12:29 AM
I have done well almost the "Introduction to iParts" of Sean's. I get to the
excel sheet and I am stumped. Firstly there is a mention of the bore
dictating the length? I understand the logic in this but there is no
mention of the connection till now? You are not told to equate between them.
I have one row completed which is taken from the model? How do I fill in
other rows? I do understand that if bore is stated and length connected by
equation then the rest of the sizes will follow if equated.
My problem is that there does not appear to be any equations in the excel
sheet so how can you fill in the sheet without filling and calculating every
cell? When I did place a size in a cell to see the result, I saved the sheet
and on returning to model which gave me a error box which was off the page
empty cells blaa etc. Problem was that the box with the OK button was off
the page and you could not proceed at all so its task manager (
I have a basic knowledge of excel, understanding the connections of
equations
but not advanced enough for either or blaa. Sorry for a question on basic
iPart theory but this is where I am meant to start? And I would of thought I
could make it through an intro at least. TIA

--
Laurence,

Power is nothing without Control
---
*Germer, Ole
Message 2 of 6 (54 Views)

# Re: iParts for begineers

11-22-2002 12:50 AM in reply to: *Yeandle, Laurence
See below!!
Don't give up. I may be able to help. Send my you excel sheet and model.

--
Ole Germer
Mechanical Machine Design and Drafting Service
http://www3.sympatico.ca/ole.germer/index.html

"Laurence Yeandle" wrote in message
> I have done well almost the "Introduction to iParts" of Sean's. I get to
the
> excel sheet and I am stumped. Firstly there is a mention of the bore
> dictating the length? I understand the logic in this but there is no
> mention of the connection till now?
The columns are created by the table maker. First you create the feature.
Then go to the parameter list and change the names to something that makes
sense. Then go to the table maker and pick from the parameters that was
just created.

You are not told to equate between them.
> I have one row completed which is taken from the model? How do I fill in
> other rows?
To fill in other rows-- logically. If you have a parameter called
"diameter" and the forgoing value is 1.25 the next one under could be 1.5 or
.75 or whatever makes sense.

I do understand that if bore is stated and length connected by
> equation then the rest of the sizes will follow if equated.
If you have created an equation in your parameter table to dictate the
diameter from above. Something like "diameter" has a value of d12*0.75.
You can stick those equation into the parameter table to get another value
that can be used in your excel sheet even though it is not shown. It can be
shown. Normally you format your excel sheet to shown no in or mm after each
value. If you insert an equation like diameter*0.75 , there has to be a in
or mm after the "diameter".

> My problem is that there does not appear to be any equations in the excel
> sheet so how can you fill in the sheet without filling and calculating
every
> cell? When I did place a size in a cell to see the result, I saved the
sheet
> and on returning to model which gave me a error box which was off the page
> empty cells blaa etc. Problem was that the box with the OK button was off
> the page and you could not proceed at all so its task manager (
> I have a basic knowledge of excel, understanding the connections of
> equations
> but not advanced enough for either or blaa. Sorry for a question on basic
> iPart theory but this is where I am meant to start? And I would of thought
I
> could make it through an intro at least. TIA
>
> --
> Laurence,
>
> Power is nothing without Control
> ---
>
>
>
>
*Dotson, Sean
Message 3 of 6 (54 Views)

# Re:

11-22-2002 01:03 AM in reply to: *Yeandle, Laurence
I can't seem to find the original thread for this but Laurence I'd be
interested what part of the tutorial you found confusing. If it is indeed
confusing I'd like to rewrite it. Feel free to email me directly with your

--
Sean Dotson, PE
http://www.sdotson.com
...sleep is for the weak..
-----------------------------------------
"Ole Germer" wrote in message
> See below!!
> Don't give up. I may be able to help. Send my you excel sheet and model.
>
>
> --
> Ole Germer
> Mechanical Machine Design and Drafting Service
> http://www3.sympatico.ca/ole.germer/index.html
>
>
> "Laurence Yeandle" wrote in message
> > I have done well almost the "Introduction to iParts" of Sean's. I get to
> the
> > excel sheet and I am stumped. Firstly there is a mention of the bore
> > dictating the length? I understand the logic in this but there is no
> > mention of the connection till now?
> The columns are created by the table maker. First you create the
feature.
> Then go to the parameter list and change the names to something that makes
> sense. Then go to the table maker and pick from the parameters that was
> just created.
>
> You are not told to equate between them.
> > I have one row completed which is taken from the model? How do I fill in
> > other rows?
> To fill in other rows-- logically. If you have a parameter called
> "diameter" and the forgoing value is 1.25 the next one under could be 1.5
or
> .75 or whatever makes sense.
>
> I do understand that if bore is stated and length connected by
> > equation then the rest of the sizes will follow if equated.
> If you have created an equation in your parameter table to dictate the
> diameter from above. Something like "diameter" has a value of d12*0.75.
> You can stick those equation into the parameter table to get another value
> that can be used in your excel sheet even though it is not shown. It can
be
> shown. Normally you format your excel sheet to shown no in or mm after
each
> value. If you insert an equation like diameter*0.75 , there has to be a
in
> or mm after the "diameter".
>
> > My problem is that there does not appear to be any equations in the
excel
> > sheet so how can you fill in the sheet without filling and calculating
> every
> > cell? When I did place a size in a cell to see the result, I saved the
> sheet
> > and on returning to model which gave me a error box which was off the
page
> > empty cells blaa etc. Problem was that the box with the OK button was
off
> > the page and you could not proceed at all so its task manager (
> > I have a basic knowledge of excel, understanding the connections of
> > equations
> > but not advanced enough for either or blaa. Sorry for a question on
basic
> > iPart theory but this is where I am meant to start? And I would of
thought
> I
> > could make it through an intro at least. TIA
> >
> > --
> > Laurence,
> >
> > Power is nothing without Control
> > ---
> >
> >
> >
> >
>
>
*Yeandle, Laurence
Message 4 of 6 (54 Views)

# Re:

11-23-2002 07:24 AM in reply to: *Yeandle, Laurence
Ole/Sean, thanks for the replies, I am still confused, there is no excel
sheet with the file I have made ? You can RMB on table "edit via spread
sheet...." and it appears by magic but the sheet doesn't seem to exist any
where? So I downloaded file bearing from CBliss web site to see if I could
clear things up. I suppose to understand how it all works I need to know
where the excel sheet comes in to play, this is where in the tutorial where
it is explained how to fill out sheet I come to a dead end. I have posted my
file in CF so you can look and maybe I have missed some thing fundamental?
If the model has parameters which are linked by equations to each other and
the excel sheet is meant to be a copy of the parameters list but the excel
sheet contains no equations then were do you fill in extra rows for
different model sizes? The whole idea of equation linked parameters is so
you don't have to work out all the dimensions, so filling in the sheet seems
backwards to me anyway that's where I am at stuck. My model gives errors
when you try to edit sheet this is where there is a problem no doubt.
Meanwhile I will go over the tutorial again to see what I have missed .
Thanks again.

--
Laurence,

Power is nothing without Control
---

"Sean Dotson" wrote in message
> I can't seem to find the original thread for this but Laurence I'd be
> interested what part of the tutorial you found confusing. If it is indeed
> confusing I'd like to rewrite it. Feel free to email me directly with
your
>
> --
> Sean Dotson, PE
> http://www.sdotson.com
> ...sleep is for the weak..
> -----------------------------------------
> "Ole Germer" wrote in message
> > See below!!
> > Don't give up. I may be able to help. Send my you excel sheet and
model.
*Keller, Kent
Message 5 of 6 (54 Views)

# Re:

11-23-2002 09:38 AM in reply to: *Yeandle, Laurence
Laurance. When you RMB on the table and choose edit table and the fancy
Inventor table thing comes up you are really just getting a pretty cover
on Excel. When you right click on it and select edit via spreadsheet, you
are getting the same thing, which is a sort of special embedded table that
doesn't show up in the normal embedded folder.

Your table as it sits has a couple of columns that have no value iParts
don't like that and will complain. That is the errors you are seeing. Just
say ok and edit it.

So Right click on the table and choose to edit in in Excel
Make sure every cell in Row2 that has a column title in Row 1 has value a
value
To make more sizes, add the values to Row3 ~ as many rows as you need. Keep
in mind each cell needs a value. For instance if you have 10 columns and 6
rows, every cell in that 10x 6 area needs some value If every cell in a
column ends up being the same value then there is little reason to leave it
in the table. For instance if the material is common in all the bushings,
and they are all the same color then don't add Display style and Material
columns.

Good luck

--
Kent Keller
Member of the Autodesk Discussion Forum Moderator Program

"Laurence Yeandle" wrote in message
> Ole/Sean, thanks for the replies, I am still confused, there is no excel
> sheet with the file I have made ? You can RMB on table "edit via spread
> sheet...." and it appears by magic but the sheet doesn't seem to exist any
> where? So I downloaded file bearing from CBliss web site to see if I could
> clear things up. I suppose to understand how it all works I need to know
> where the excel sheet comes in to play, this is where in the tutorial
where
> it is explained how to fill out sheet I come to a dead end. I have posted
my
> file in CF so you can look and maybe I have missed some thing fundamental?
> If the model has parameters which are linked by equations to each other
and
> the excel sheet is meant to be a copy of the parameters list but the excel
> sheet contains no equations then were do you fill in extra rows for
> different model sizes? The whole idea of equation linked parameters is so
> you don't have to work out all the dimensions, so filling in the sheet
seems
> backwards to me anyway that's where I am at stuck. My model gives errors
> when you try to edit sheet this is where there is a problem no doubt.
> Meanwhile I will go over the tutorial again to see what I have missed .
> Thanks again.
>
> --
> Laurence,
>
> Power is nothing without Control
> ---
>
>
> "Sean Dotson" wrote in message
> > I can't seem to find the original thread for this but Laurence I'd be
> > interested what part of the tutorial you found confusing. If it is
indeed
> > confusing I'd like to rewrite it. Feel free to email me directly with
> your
> >
> > --
> > Sean Dotson, PE
> > http://www.sdotson.com
> > ...sleep is for the weak..
> > -----------------------------------------
> > "Ole Germer" wrote in message
> > > See below!!
> > > Don't give up. I may be able to help. Send my you excel sheet and
> model.
>
>
*Dotson, Sean
Message 6 of 6 (54 Views)

# Re:

11-23-2002 10:39 PM in reply to: *Yeandle, Laurence
What Kent said...

I got your email Laurence and I'll respond to it at the beginning of this
week. Stick with it, it'll make sense one day

-Sean

"Kent Keller" wrote in message
> Laurance. When you RMB on the table and choose edit table and the fancy
> Inventor table thing comes up you are really just getting a pretty
cover
> on Excel. When you right click on it and select edit via spreadsheet, you
> are getting the same thing, which is a sort of special embedded table that
> doesn't show up in the normal embedded folder.
>
> Your table as it sits has a couple of columns that have no value iParts
> don't like that and will complain. That is the errors you are seeing. Just
> say ok and edit it.
>
> So Right click on the table and choose to edit in in Excel
> Make sure every cell in Row2 that has a column title in Row 1 has value a
> value
> To make more sizes, add the values to Row3 ~ as many rows as you need.
Keep
> in mind each cell needs a value. For instance if you have 10 columns and
6
> rows, every cell in that 10x 6 area needs some value If every cell in a
> column ends up being the same value then there is little reason to leave
it
> in the table. For instance if the material is common in all the bushings,
> and they are all the same color then don't add Display style and Material
> columns.
>
> Good luck
>
> --
> Kent Keller
> Member of the Autodesk Discussion Forum Moderator Program
>
>
> "Laurence Yeandle" wrote in message
> > Ole/Sean, thanks for the replies, I am still confused, there is no excel
> > sheet with the file I have made ? You can RMB on table "edit via spread
> > sheet...." and it appears by magic but the sheet doesn't seem to exist
any
> > where? So I downloaded file bearing from CBliss web site to see if I
could
> > clear things up. I suppose to understand how it all works I need to know
> > where the excel sheet comes in to play, this is where in the tutorial
> where
> > it is explained how to fill out sheet I come to a dead end. I have
posted
> my
> > file in CF so you can look and maybe I have missed some thing
fundamental?
> > If the model has parameters which are linked by equations to each other
> and
> > the excel sheet is meant to be a copy of the parameters list but the
excel
> > sheet contains no equations then were do you fill in extra rows for
> > different model sizes? The whole idea of equation linked parameters is
so
> > you don't have to work out all the dimensions, so filling in the sheet
> seems
> > backwards to me anyway that's where I am at stuck. My model gives errors
> > when you try to edit sheet this is where there is a problem no doubt.
> > Meanwhile I will go over the tutorial again to see what I have missed .
> > Thanks again.
> >
> > --
> > Laurence,
> >
> > Power is nothing without Control
> > ---
> >
> >
> > "Sean Dotson" wrote in message
> > > I can't seem to find the original thread for this but Laurence I'd be
> > > interested what part of the tutorial you found confusing. If it is
> indeed
> > > confusing I'd like to rewrite it. Feel free to email me directly with
> > your
> > >
> > > --
> > > Sean Dotson, PE
> > > http://www.sdotson.com
> > > ...sleep is for the weak..
> > > -----------------------------------------
> > > "Ole Germer" wrote in message
> > > > See below!!
> > > > Don't give up. I may be able to help. Send my you excel sheet and
> > model.
> >
> >
>
>

### You are not logged in.

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.

### Maintenance Subscription Resources

Upgrading to a 2015 product? Make sure to check these out 1st!

### 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.