How to convert data in Excel to a Revit Model using Revit Extension InstaCrete 2.0 | An Easy Way
Revit Extension InstaCrete 2.0 helps to convert the data in Excel to a Revit model.
Use the arrow sign on the left side of the page to open the video tutorial index.
Table of Contents
Revit add-ins -InstaCrete resources
Revit modelling vs InstaCrete modelling Part I
Grid, Level & Foundations.
Revit modelling vs InstaCrete modelling Part III
Beam tool comparison.
Revit modelling vs InstaCrete modelling Part V
Wall tool comparison.
Download InstaCrete – from Autodesk App store
Revit modelling vs InstaCrete modelling Part II
Columns tool comparison
Revit modelling vs InstaCrete modelling Part IV
Structural floor tool comparison
Revit Tutorial 2020 – Stair modelling
How to get a smooth join between the stair & the waist slab?
Converting the Excel data to a Revit model
Hello everyone, today I am going to show you how you can convert your Excel data to floor plans. And to do that we are going to use our Revit plug-in InstaCrete 2.0
I will be covering –
Excel data to the Revit model in more details.
Then I am going to talk about the floor plans & automatic tagging feature.
Then we will see converting 3d model to Analytical model.
Next, I will show you how it’s easy to edit the model using InstaCrete.
As you can see we are going to cover a lot many things, so let’s dive straight into it.
In this Revit file, we can see a few foundations. These foundations are placed using this Excel file. Now, I am going to add a few more foundations. I have added those foundations in the Excel file. Let’s run this Excel file. Let the row number be 8.
Hit the okay button.
This message says, there are foundations on these grid points. Hence InstaCrete will not place new footings at these places.
This means InstaCrete identifies existing structural members like footings, columns & beams & avoid those grid points to place the new objects. Helpful feature Indeed.
Here is another scenario you may come across. You are tackling a large project. You have very large Excel data. Naturally, to run such excel files the system requires more time. In such a situation you can insert a blank row & run the Excel file step by step.
You can see in this file I am going to insert a row after 17th row. InstaCrete begins reading the data from row number 8 & stops at row number 17.
This way you can insert rows at small intervals. Then run this Excel file number of times to build a very large model easily.
This means that very large models can be built by running the Excel files without any work in the graphics window. I love this.
InstaCrete 2.0 comes with a new automatic tagging feature. So, whenever you build the model of the structural member, it comes with a tag. That means you need not run tag command separately.
Not only you can add tags while modelling. But, you can place them at a predefined distance & the direction.
This can be done by using this new tag setting tool. This tool helps you to set the distance & the direction of the tag from the structural member.
The result can be seen on any floor plan. The floor tag by default is at the centre of the floor. For example, this tag states that this floor thickness is 250 & it is a sunk slab at a minus 25-millimetre distance.
These are the column & beam tags. They show the size & grid position.
Now let us observe this foundation plan. It comes with the grid lines, it’s dimensioning, footings & columns along with their tags.
Hurray! Now, I can draw floor plans while having a cup of coffee.
Once the 3d model is ready you can convert that to an analytical model.
Now you can use it for the structural analysis purpose.
Once that is done & you arrive at the final sizes, editing model with InstaCrete is a child’s job.
Let’s assume that the footing size at E 3 has changed.
So to edit the footing, open the foundation manager.
In the select grid box, type E, scroll down to E 3. Change the foundation size & hit the okay button. InstaCrete does the job for you.
Suppose that the column size at E 3 has changed. Also, it has moved down the base level by 750 millimetres.
This is the column tag before making any changes.
Open the column manager. Select base level one & the grid E. Scroll down to E 3. Change the column size & type the negative 750 value.
You can see the change in the column & foundation tags.
Now, let’s change the beam size on the fourth floor. The beam is located at the grid points E4-E5.
Open the beam manager. Select the reference level as 4. Type “e” in the beam position box. Scroll down to E4-E5. Change the size. Hit the okay button.
Open the fourth-floor plan & observe the change.
InstaCrete is a next-generation fully automated tool for structural modelling.
The model is built by “selection” method. Hence, the time wasted while zooming, panning, copying, regeneration is saved.