Ideate BIMLink: Customizing Document Issue Records

We have had an Ideate BIMLink revision workflow for Revit for quite some time. A blog post by my colleague Sash Kazeminejad explains the process quite well.


We even have an in-depth topic in our online Help that explains the process quite thoroughly. As a bonus to Ideate BIMLink customers, they can request an Excel macro template and dataset that supports the automation of a Document Issuance Record. The resultant Excel file is organized as a matrix with the Sheets as Rows with the Revision dates and per Sheet numbering as the Columns.


We recently had an excellent question from one of our customers, KEO International Consultants, regarding that specific Excel macro template. He was trying to add custom columns to the Excel template immediately to the left of the Ideate BIMLink generated sequence data. We have instructions and setup within the Excel document to explain that the number of columns needs to be set to the left of the sequence data. This number will be set based on the added columns or properties, but we failed to mention that the columns also need to be added to the DIR tab within the Excel spreadsheet. With that little tidbit of information, KEO International Consultants was in Revit Revision heaven, if there is such a place!


“I added the additional columns to the DIR sheet and now it is working as expected. Thank you for the great support and the fantastic software.”
~ Robert L. Fernandez, BIM Manager – Design, KEO International Consultants


Thank you Robert for bringing this question to us! We have now added this important step to our process. 


Here’s the process:


On the setup tab of the Excel Macro, the columns left of Sequence Data will calculate the proper number based on the columns to the left of the sequence data.

Ideate BIMLink: Customizing Document Issue Records

In my example, I’ve added 4 properties before the sequence data, so the Columns Left of Sequence Data will automatically be set to 4. (A quick way to think about this is that EACH property is a column within Excel.)

Ideate BIMLink: Customizing Document Issue Records

Now here is the critical part. For my example, the Sheet Number, Sheet Name, Checked By, and Current Owner MUST be added to the DIR Excel tab as columns in order for the Excel file to work properly.

Ideate BIMLink: Customizing Document Issue Records

Explore recent posts

Fast-Tracking Data-Driven Design with ZGF Architects
October 15, 2025
CLIENT TESTIMONIAL - ARTICLE | ZGF Architects, a leading North American design firm focused on sustainable architecture, used Ideate Software for Revit to streamline workflows and meet strict UK BIM standards on two major Canadian hospital projects while managing over 1,300 sheets across 11 Revit models.
Revit Documentation Reinvented: Smarter Workflows for Better Project Outcomes
October 15, 2025
TRAINING - VIDEO | In this webinar recording, we’ll show you how to elevate your modeling and documentation workflows using Ideate Software. Learn how to keep your Revit files clean, eliminate model clutter, and streamline project management — all while saving serious time and reducing frustration.
HKR Success Story for Ideate Automation
September 11, 2025
CLIENT TESTIMONIAL - ARTICLE | Faced with nearly 1,000 models requiring rigorous quality checks, the HKR team turned to Ideate Automation and the Ideate Software suite of Revit plugins to streamline their workflows.
Batch Create Parameters for Revit Families with Ideate Automation
July 18, 2025
TRAINING - VIDEO | Batch Update Revit Families—The Smart Way. Speed up your Revit family management with Ideate Automation + Ideate BIMLink! In this new workflow, you can batch update RFA files, create parameters from Excel, and generate detailed reports—no manual editing needed.
Show More