|
Forums >> Revit Building >> Technical Support >> Linking Revit files to Excel
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
I am trying to generate reports from GLA, total footprint, mezzanine SQFT, and after adding up all the tenants come up with percentages based on the numbers. Is there a way to link the Revit file into an excel spreadsheet to come up with these numbers, or is there a better way to get all of this information calculated without hand typing and calculating each number by hand?
|
This user is offline |
|
 |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
You can export any Revit schedule to a txt and open that in excel.
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
Thank you. Is there a way to make the schedule calculate some of the info that i was looking for on it's own or do I have to hand type the schedule. I only ask becasue if it can be done the need for the excel file would be non-existant.
Thanks
|
This user is offline |
|
|
|
site moderator|||
Joined: Fri, Nov 12, 2010
1749 Posts
 |
If you are looking for areas just make an Area Plan and schedule the areas in Revit.
|
This user is offline |
View Website
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
our leasable area is sometimes different from out overall GLA for spaces, and there are other factors such as Mezzanine. We have them all listed on the drawings under a custom tag that we can manually update aside from the GLA which is assigned. I was hoping they would automatically fill in under categories on the schedule.
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
If they can not automatically fill in I guess I am wondering what the next easiest way to get them all written out would be. Right now we do CAD to Excel and are looking for a speedier process.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Area plans can be automatically sketched or you can alter those or just manually sketch them. This allows you to get what you need.
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
So I will need to duplicate a view with no detailing and create different area boundries to derive the numbers I need? I mean it sounds easy but I was hoping I could possibly create a schedule and i could tie the titles under each space into the different values listed and it will automatically fill the schedule in. Like Excel would do if you create a formula for adding 2 boxes together for a total ya know?
|
This user is offline |
|
|
|
site moderator|||
Joined: Fri, Nov 12, 2010
1749 Posts
|
I'm not sure I follow but it sounds like you want the schedule to add all of the rooms together for a total area.. In the schedule under the format tab there is a checkbox for Calculate Totals that you need to check.
I'm not sure how familiar you are with area plans but the HELP is a good place to start
http://help.autodesk.com/view/RVT/2014/ENU/?guid=GUID-4E0F18E2-1F19-4993-A252-57717A7DB66D
Edited on: Wed, Jan 22, 2014 at 7:32:23 AM
|
This user is offline |
View Website
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
I really appreciate it. I believe you and I are on the same page...essentially there are 4 things to calculate. We manage mall properties and need a breakdown of each spaces SQFT, Mezzanine SQFT, total of SQFT + Mezzanine SQFT, and the frontage to a mall corridor which we have listed as a linear dimension. Then we need to extract each from the area plan we have created them in with parameters that fill in automatically under the customized area tags we created...Now we want to take the values in those tags, along with the dimensional frontage and transfer them to a spreadsheet in list format (ascending by space number &/or tenant name) for the accounting people to do their yearly summaries. Does that break it down better?
|
This user is offline |
|
|
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
You really need to spend some time with your HELP and tutorials to understand area plans/schedules and room areas/schedules. They are not the same and can be used differently. Some of the things you need to pay attention to:
- Room areas and where they are calculated to. By default, Revit computes the room areausing the wall finish as the boundary. You can change the boundary, specifying the wall center, wall core layer, or wall core center.
Note: You cannot change boundary locations separately for each room. All rooms in the project use the new boundary location.
- Understand room bounding elements that can be turned on/off.
- Understand how to add parameters - schedule & project that can be used to combine room areas and total them as teafoe has suggested.
- Learn how to add schedule parameters that calculate.
- Automatic area plans can be set to gross or net but that still may not be what you need.
There is a lot to learn here. It will take some time, but the resulting knowledge will pay big dividends so do it.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Another point to consider.
BOMA's definition of leasable space is to the center of demising walls but the exterior face of exterior walls. Revit's settings for Room areas is for all walls. To get around this, set the area to wall center-lines, turn off room bounding for exterior shell walls & doors then add room separation lines along the exterior face of the structure.
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 21, 2009
0 Posts
No Rating |
I will try that. Thank you!
|
This user is offline |
|
|
|
Search