How to edit Lookup Tables using import / export macro and Excel (MEP)

Luke Johnson

I have previously described how you can Link Excel spreadsheet data into Revit (through AutoCAD).

But what if you want to semi-automate the process of editing Lookup Tables using Excel?  The blog http://www.revitmep.es/ shows you how:

We explain how to create a lookup table for the families…
The biggest impediment there is import and export these files, we use a macro in Excel to streamline these tasks.
via
Google Translate

of

Original Post

And here is a direct link to the macro-enabled Excel file:
Editor Lookup Tables.xlsm

 

Revit Array with adjustable Group Types for Array members

Luke Johnson

This video demonstrates a peculiar workflow, in which Revit allows you to change the Type of an Array member without breaking the array.

This example uses a Polar array based on a copy-to-2nd method. You will notice that the reliability of this method actually depends on how far the array is pushed. In general terms though, this hack may prove useful in some situations.

Free Plugin – Level Generator for Revit

Luke Johnson

As the plugin’s name suggests, this plugin can be used to generate multiple adjacent levels with one command. It is compatible with Revit Architecture 2012.
// Download Level Generator for Revit Architecture via Autodesk Labs

Read more and via:
February’s free ADN Plugin of the Month: Level Generator for Revit Architecture Now Available – It is Alive in the Lab

More on the Revit UI Toolkit

Luke Johnson

A UI Toolkit is essentially a tool used by developers to create the user interface for a program.

I previously posted about the apparent limitations of the current Revit UI Toolkit.

In David Conant’s post on Inside the Factory, we get a similar insight into this fundamental yet apparently weak element of Revit development.

Some are the result of constraints imposed by current interface tools, others reflect deeper issues in the Revit data structure and regeneration engines.

via
Inside the Factory: Revit Schedules: A Love Hate relationship