RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

172 Users Online (51 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Linking Revit files to Excel

Search this ThreadSearch this Thread | Page 1 of 1 |

Tue, Jan 21, 2014 at 9:57:17 PM | Linking Revit files to Excel

#1

JoshSwear


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

 

Tue, Jan 21, 2014 at 9:59:41 PM | Linking Revit files to Excel

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 369 Votes


You can export any Revit schedule to a txt and open that in excel.


This user is offline

 

Tue, Jan 21, 2014 at 10:04:16 PM | Linking Revit files to Excel

#3

JoshSwear


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

 

Tue, Jan 21, 2014 at 10:17:18 PM | Linking Revit files to Excel

#4

teafoe5


site moderator|||
teafoe5 Avatar

Joined: Fri, Nov 12, 2010
1749 Posts
4.5 Stars: 45 Votes


If you are looking for areas just make an Area Plan and schedule the areas in Revit.


This user is offline

View Website

Tue, Jan 21, 2014 at 10:28:21 PM | Linking Revit files to Excel

#5

JoshSwear


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

 

Wed, Jan 22, 2014 at 1:14:08 PM | Linking Revit files to Excel

#6

JoshSwear


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

 

Wed, Jan 22, 2014 at 1:18:47 PM | Linking Revit files to Excel

#7

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 369 Votes


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

 

Wed, Jan 22, 2014 at 1:25:56 PM | Linking Revit files to Excel

#8

JoshSwear


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

 

Wed, Jan 22, 2014 at 1:30:25 PM | Linking Revit files to Excel

#9

teafoe5


site moderator|||
teafoe5 Avatar

Joined: Fri, Nov 12, 2010
1749 Posts
4.5 Stars: 45 Votes


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

Wed, Jan 22, 2014 at 1:49:11 PM | Linking Revit files to Excel

#10

JoshSwear


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

 

Wed, Jan 22, 2014 at 1:54:20 PM | Linking Revit files to Excel

#11

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 369 Votes


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:

  1. 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.
  2. Understand room bounding elements that can be turned on/off.
  3. Understand how to add parameters - schedule & project that can be used to combine room areas and total them as teafoe has suggested.
  4. Learn how to add schedule parameters that calculate.
  5. 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

 

Wed, Jan 22, 2014 at 2:47:54 PM | Linking Revit files to Excel

#12

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 369 Votes


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

 

Wed, Jan 22, 2014 at 9:30:36 PM | Linking Revit files to Excel

#13

JoshSwear


active

Joined: Wed, Oct 21, 2009
0 Posts
No Rating


I will try that. Thank you!


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

EXCEL LINKING REVIT MEP 2012

Revit Systems >> Technical Support

Wed, Dec 28, 2011 at 9:06:20 PM

7

Import/Linking Excel Sheets into Electrical Components

Revit Systems >> Tips & Tricks

Wed, May 20, 2009 at 2:45:53 PM

0

EXCEL LINKING!

Revit Building >> Technical Support

Mon, May 8, 2006 at 1:19:56 PM

0

Schedule Sync for importing/exporting Excel files

Workflow & Implementation >> API & Third Party Apps

Wed, Mar 5, 2014 at 5:12:17 PM

2

importing excel files

Revit Building >> Technical Support

Tue, Sep 17, 2013 at 5:50:04 PM

1

Site Stats

Members:

1632456

Objects:

22066

Forum Posts:

151652

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 2.7480

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights