Excel integration - shtirlitsDva/Revit-PCF-Exporter GitHub Wiki

Overview

The add-in uses an EXCEL file to read the data with which to populate the PCF parameters. The elements are identified by their family and type and the parameters are populated according to the data stored in the file. The file is intended to be used as a specification sheet containing all of your families and types and the add-in will only pull the data needed for elements present in the model.

First time run

When starting for the first time, it is advisable to make use of the "Export schedule to EXCEL" function in the "Setup" tab. This way the add-in exports a list of all your families and types present in the project. Please note that means elements that are modelled, families yet to be placed are ignored. This also means that to create a full specification sheet you would need to create a model where you would place all of your families and types you are using to create your piping projects.

The file exported from a yet to be configured model looks like following:

Populating the spreadsheet

The EXCEL file then needs to be populated with PCF compliant values. Each column (except the first) with a parameter name in the first row needs to be filled out with appropriate data. For explanation about parameter names and PCF valid input see PCF Compliance. The final product looks like the following (not all columns are shown):