Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Excel extensions for managing family type catalog - does this interest you?

2 ANTWORTEN 2
Antworten
Nachricht 1 von 3
MuirEng
554 Aufrufe, 2 Antworten

Excel extensions for managing family type catalog - does this interest you?

Hello, I have developed for internal use a set of extensions that operate within MS Excel designed to speed up the process of creating, managing and editing family type catalogs. We use this for electrical content development but it is generic in nature and if there is sufficient interest I will develop it further and then make it available. I do want to charge a reasonable amount for the tool because I spend a lot of non billable hours on it. 

 

The tool is presently capable of loaded a .txt based type catalog directly into excel. Once loaded the user is able to edit the catalog directly in excel or take advantage of the following macros: 

1.  Save the catalog - writes the catalog out as a text file which can then be loaded with Revit - import family types

2. Renaming Wizard - defines a new name for each family type based on the parameter selections, prefix values, and suffixes. For example the name "Birch - Solid Stained Low Gloss 850x2500 was assembled using parameters door material, width, and height along with some prefix and suffix values. 

3. Parameter bulk load: user chooses a parameter and a value. The value is loaded into that parameter across all types. 

4. Parameter assembler. Similar to #2 but operates using a parameter as the target

5. Delete type.  Allows user to quickly delete one or more sequential types

6. Filter parameters: User can hide or show parameters. Really helpful when the family has lots of parameters but the user cares about only a few.

The tool automatically identifies and hides by default parameters that are duplicated across all types!

7. Type builder. User selects up to five parameters. For each user enters a list of values separated by commas. The macro will create new types by looping through all possible combinations. 

example if these inputs selected: 

  Material: Birch, Oak, Maple, Mahogany.   

  Height 2500,2750,3000

  Width 850, 1000

Then the routine will generate 4 x 3 x 2 = 24 new types. Use the naming tool #2 to fix the names. 

8. (in development) Tools for loading a second family catalog and copying types over to the primary catalog. 

 

Please reply or send me PM if you are interested. If you like you can send me a type catalog and a use case and I run it through the tool and send you back an updated catalog. 

Sample screen shots. 

ribbon.PNG

Capture.PNG

filter.PNG

 

 

 

Brian Muir, P.Eng, Muir Engineering
2 ANTWORTEN 2
Nachricht 2 von 3
jmqrsq
als Antwort auf: MuirEng

Will you be releasing this to the public at all?

Nachricht 3 von 3
spinckney
als Antwort auf: MuirEng

If this is available I would like to try it. My main issue is filtering the parameters to eliminate the ones I don't need. 

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report