Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Link Area parameters to spreadsheet

3 ANTWORTEN 3
Antworten
Nachricht 1 von 4
Anonymous
437 Aufrufe, 3 Antworten

Link Area parameters to spreadsheet

I am looking to do some number crunching a bit beyond what Revit's scheduling functions are capable of. I have a spreadsheet set up for analysis of building areas which we are using to submit for a building permit. I know Revit can extract areas from Area or Room Boundaries to a schedule and then add them up to create a total. The problem is I need to create a matrix which shows all of the areas which contribute to the overall building area, but I need to separate them into columns of areas which the city counts toward GFA and areas which it doesn't.

 

Ideally I'm trying to find a method of linking a specific area value parameter, say from an Area Boundary or a Filled Region, to a cell (could be in excel or in a Revit schedule, I don't really care) which I can then arrange in an editable matrix to create the values I need to inform our submission. I'm a bit of a novice so forgive me in advance if I need extra-detailed instructions.

 

I've attached a sample image of the matrix I'm building to help illustrate.1635 Areas.jpg

3 ANTWORTEN 3
Nachricht 2 von 4
ToanDN
als Antwort auf: Anonymous

Looks like it can be done easily in Revit by placing 2 schedules next to each other or am I missing something?

Nachricht 3 von 4
Anonymous
als Antwort auf: ToanDN

I think that could work for this particular stage, but I may have made the example overly simplistic. At a further stage I will need to be able to add Columns 1&2 and Columns 3&4 for building code analysis. I will also need to prepare a matrix with site area information which will require adding several yard areas and multiplying the yard areas by certain by-law mandated percentages to ensure we are achieving soft landscaping requirements.
I'm finding the schedule function is fine for extracting a series of single values and adding those values to get a single total. But ultimately I need a tool which can combine certain totals and feed them through the city's and the building codes required formulas. I'm not expecting Revit to provide this level of functionality as a standard but if there's a way to link the values to a spreadsheet program (through a plug-in, maybe?), that would help take my BIM work to the next level.
Nachricht 4 von 4
ToanDN
als Antwort auf: Anonymous

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report