family of similar components

[GDavideVR]

Good morning to all, I am a student at the 4th year of mechanical engineering and recently user solidworks.

I find myself in these days to draw a spindle for centrifugal fan and wanting to associate to the drawing the calculation part made on excel I started using the parametric features.
what I would like to accomplish is a similar rotating family that can be recalled by the configurationmanager with geometry data extracted from the excel table. my idea was to leave a line in the table that takes the data into the input from the spreadsheet, create successive rows by copying the data for each variation from the spreadsheet and associate these lines copied the geometries of the machine family.
given my poor experience I hope I didn't ask a stupid question and an unrealizable idea. Thank you very soon who will want to respond.

greetings to all

 

[MassiVonWeizen]

with excel tables (internal or external) you can paranmetrize all aspects of the part file or together. provided the data you need to manage is already inside the file.
to understand, if you have to manage the diameter of the impeller that quota must be present in the drawing. inside the excel sheet you can obviously do all the calculations you need, use the functions and what else the sheet makes you available.

my idea was to leave a line in the table that takes the data in the calculation sheet

This phrase is not clear to me; I hope you will create it starting from solidworks file and not the opposite (as I hope the tutorial on the data table did so and so know how the excel sheet is created)

 

[GDavideVR]

Hello, thank you for the attention. then the speech is that I can parameterize all the impeller without problems, but I would like to "save" a series of similar impellers obtained by varying the project data and having them always available to be opened by the configurationmanager.

 

[MassiVonWeizen]

I got it.
But how do you parameterize the impeller?
if with excel then from the row that indicates the basic configuration do n° copies of rows that you will fill with new data and will create n° configurations.

 

[marcof]

Hello, thank you for the attention. then the speech is that I can parameterize all the impeller without problems, but I would like to "save" a series of similar impellers obtained by varying the project data and having them always available to be opened by the configurationmanager.

do the tutorial about the data tables and you should clarify all the doubts.
In any case, in the data table that commands the parameters of the various configurations of the part (to tell us what you call "a series of similar impellers obtained by varying the project data") you can insert the values of the individual cells or columns as links to the respective cells of an external excel sheet. because the changes that you attach to the data in the external sheet are applied to the inner sheet of swx you have to open it by entering into "change the table" and the external excel file must be opened and saved. when you close the data table you save all parameters in each configuration
eye inserting cells connected to external sheets then requires some attention in working on the data source file to avoid incans of the same in the data table swx