Tuesday, February 22, 2011

Copy Cells from Excel to Revit Schedule

***********
This utility has been updated for Revit 2012 and for 64bit version for 2011 Revit.
***********
I had created a script to Copy Cell values from Excel to Revit Schedule view. I updated the script for 2011. The evaluation copy of the updated script for Revit 2011 and 2012 is available at:
http://bim.nichitecture.com/copyexcel.html
I hope this is helpful.
The script works with both Microsoft Excel and Open Office.org Calc.
The script copies a bunch of cells (rows x columns) and pastes them into a revit schedule (contiguous rows x columns).

  1. The script works well if all the fields in Revit schedule are EDITABLE. (A normal schedule has lots of ‘read-only’ fields like Family name, Area, etc where this script will fail.) The cells also need to be 'instance' driven cells (as compared to 'type' driven cells)
  2. The script does not create blank rows for data in Revit (yet). You need to create as many rows as you might need using this button in the Revit option bar before running the script.

Monday, February 21, 2011

Project Vasari

Autodesk has introduced (sometime back) a, kind of rival to Sketch up. It is free and can be downloaded from here or
http://labs.autodesk.com/utilities/vasari/
Really nice program. You can keep it in your thumbdrive and take it whereever you go. It does not have to be installed like traditional apps.
Even creating a sphere or a dome is a pain in sketchup. Vasari can do it very easily. Also it has levels, from which you can get all the floor areas and can be directly imported into Revit. In fact, the file format is RVt and so can be directly OPENED in Revit. Very nice.
(I hope autodesk keeps this software FREE!!!!)