In part:Then repeat for the other datatools links changing the Category for COLORS_proengineer, COLORS_INVENTOR, and COLORS_User Data.

Then after the profiles are set up, you can click Run in the appearance profiler, and the colors will change according to color properties that are being pulled from the excel file.

I’ve attached the Excel file, Appearance Profiles dat file to import, and the NWF with the datatools links setup. If you drop the three files in the folder with your models, open the NWF, import the .DAT file into the appearance profiler tool and run it, it should change the items in the models to either red or blue based off of the colors specified in the excel file.

This example has colors specified in the excel file, but you could use some other property in the database such as “Out of Service” column with a value of either yes or no and create an appearance profile that checks if that property is yes, and if so, set the color of those items red.

With the appearance profiler, you need to actively run the appearance profiler to set the colors if the excel file is updated. If you wanted more automation, then you may wish to look into the Navisworks API. …

Ever pressed Cancel or No when prompted to save an Excel spreadsheet? Lost your work? How about this backup task… it basically copies Excel backup files to another location so that Excel can’t delete them when it closes.

Open Task Scheduler (tap Windows Key; start typing “task scheduler”, press enter/click on it when result is at top of Start Menu).

Click Action – Create Basic Task

Give it a name and click Next

Select “When I log on” as the Trigger

Select “Start a Program” and click Next

Type “Powershell” in the Program Name, then

in the “Add arguments (optional):” box, type “% {Copy-Item -path C:UsersusernameAppDataRoamingMicrosoftExcel -recurse -force -destination D:BackupExcelAutosave}” (changing the username to your username obviously, and also modify the destination directory if you want), then click Next

Then tick the box “Open the Properties dialog for this task when I click Finish”, then click Finish.

Under the “Triggers” tab, double click the “At log on” trigger, then tick the box “Repeat task every:” select an interval (i have 1 hour) and duration (i have 12 hours), make sure “Enabled” is selected, then click OK, then OK on the properties box.

Daniel Monsén has created one of those addins where you just have to say “this makes sense”. The key feature of Bimframe Connect? It allows users to import and export data from Revit to a Google Spreadsheet.

The overall concept is that you can export data to a Google Spreadsheet, collaborate using a web client or mobile device, then import the data and update the Revit model. Collaborators obviously don’t need Revit – just access to the Google spreadsheet.

Personally, I love the idea. The more transparent the Revit building database is, the easier it is to add intelligence to the model, share the model, and detect design problems.

Overview:

The above video includes the following info:Email: daniel@bimframe.com to get trial key.

WhiteFeet Tools for Revit is a powerful set of add-ins that can make the impossible, possible. I have posted about them before. In this brief post, we look at how you can effectively Schedule the Reference Planes you have in a model.

On the Add-ins Ribbon, choose Utility Tools – Schedule Tools:

Pick Write Category to Excel, then select the Reference Plane category, All Elements in Model:

After you press Write Data, you will get something like this:

You can then sort the Data to find the unnamed versions, and then use the Element ID to select and name those Reference Planes, if you so desire. In our office, an unnamed Reference Plane is fair game for deletion…

Also, some of you may have picked up that you can use this same process to export data from ANY CATEGORY in Revit – including those that you cannot schedule!

Nathan Miller strikes again: I am creating a strange ‘catenary’ surface with Kangaroo and Grasshopper. I am then feeding the information into an Excel spreadsheet and reconstructing the shape using Adaptive Components via RevitPythonShell. Note how I am also able to adjust the radius parameter of the pipe members within Revit to reflect the ‘force’ diagram created in Kangaroo.

This post looks at the post-processing side of the energy modeling workflow. Often, a spreadsheet tool like Excel is a first choice for many analysis tasks. This is great for simple cases, but if the number of files or the amount of data is large or complex, Excel will cost you time and lead to errors. This is where you should turn to Python!