Control of the number of occurrences of a repetition function in excel file to create a part family

Out of category
1

Hello

I can't manage the number of occurrences of the repetition functions in my Excel table intended for the constitution of a family of parts!

Example:

depending on a value in my Excel table, I want to be able to associate a hole Ø and a hole number / 360° (in circular repetition).

For the hole Ø, it's ok but for the circular repetition of a desired number of holes, I dry !!

Thank you in advance for your help.

2

Hello

The 3 values you indicate are considered dimensions and therefore can be controlled by your Excel file. I don't see the problem. Just do the operations in the Excel cells .

Do you have a special case?

Can you attach your SOLIDWORKS file?

Kind regards

4 Likes
3

Hello

I think you want to have a certain number of holes depending on the diameter he places his hole on?

If that's not it; There is nothing complicated when you know how to do it.

4

Good evening, if these values are considered as odds, what are the labels of the excel file? Example: I have a circular repetition function that I name "REPCIR", to point to the "number of occurrences" parameter of the "REPCIR" function, how should the excel header cell be labeled?

5

Hello

In theory: D2@REPCIR or D1@REPCIR.

Look in the equations for the names of the coasts.

6

When you are in the excel file, click in the said box and you just have to click on the circular repetition function of your piece and there the dimensions appear, then you click on the number and it's set or you can edit the function above where you have entered the number, there will be an address like répétition@...; You copy and paste it into the Excel file box to create the link.

1 Like
7

@ac cobra said it all. You have all the cards in your hand to get out of it!

Cheer up!

3 Likes
8

Here is an image capture with the Excel table and the dimensions. If you renamed the call numbers before the part family was created, you will have these names instead of D1, D2,... of my example.

Kind regards


famille_de_piece.png
3 Likes
9

Hi all

PB solved, by clicking on Tools/Equations... "Side view", we can see the labels of the functions. In this case, the labels I was looking for were D1@.. and D3@..

I found my young people, as they say at home! Thank you

Slts, have a good day