inserting part/axis according to true/false parameter

[mlhaus]

Bye to all,

I'm trying to figure out whether it's possible to insert a part/subassistance into a main-group, using a parameter defined in a excel sheet.

Basically:
- if the "existence" parameter is set to "true" (or "1") in the excel sheet, the part/subassieme must be present in the main axieme and is bound according to its parameters;
- if the "existence" parameter is set to "false" (or "0") value, the part/subassieme must be deleted, or even not to be inserted.

I found some examples of the series, one is here http://www.3dnow.it/img3dnow/creator03%20gennaio07_tutorial.pdfbut nothing related to the specific case of existence/non-existence of a component.

Can anyone enlighten me?
Thank you.

 

[Catafratto]

try to look/search the iassembly, which are precisely configurable assemblies. I don't think they're exactly what you're looking for, but they're approaching.

 

[mlhaus]

thanks to your straight I solved, although perhaps in the most elegant way, giving up something.

in practice I converted the axieme into iassembly, I put as a key the parameter "include/excluding"; I have left a single line/representation of iassembly, whose table however must be modified keydx+"change by spreadsheet".
I had to rewrite the formulas in this new sheet, because the conversion disconnected the sheet which, before, contained the parameters, so that now both formulas, and the parameters are all in the xls of the iassembly.

the "include/excluding" parameter consists of a conditional formula if (true; "include"; "excluding").

In fact, it tells me of the errors related to the fact that in the cells there are values and not, at the same time, also the unit of measurement (that is, he instead "2" would like to find written "2 on" or "2 m" according to the cases).
doing that correction in excel is quite laborious, for the fact that the cells recall themselves, then fly and accept the fatigue of clicking ok to each update.

for the moment I thank you for the help, if someone had improvements on the solution, they are welcome.