Autodesk - Tips for Cooking Your First Design Visualization: The Recipe for Success
Showing posts with label Revit How To. Show all posts
Showing posts with label Revit How To. Show all posts
16 August 2011
Tips for Cooking Your First Design Visualization: The Recipe for Succese Recipe for Success
Autodesk - Tips for Cooking Your First Design Visualization: The Recipe for Success
4 August 2011
Exporting Schedules to Excel
After much effort you've developed an amazing schedule in Revit but now that information is needed in another format for another reason. Could be for further development as room data sheets or programming. Following are simple steps for exporting any scheduled information out to Excel.
From the active schedule view browse through File - Export - Reports - Schedule. Assign a name and location for what will be the Delimited text (*.txt) file.
Launch Excel and from the Data tab -From Text browse to the location and file that was created on export from Revit and select Import. I'm sure the next three dialogue boxes offer amazing Excel features but I'm a Revit user not an Office user so I tend to leave these on their default settings.
From the active schedule view browse through File - Export - Reports - Schedule. Assign a name and location for what will be the Delimited text (*.txt) file.
Launch Excel and from the Data tab -From Text browse to the location and file that was created on export from Revit and select Import. I'm sure the next three dialogue boxes offer amazing Excel features but I'm a Revit user not an Office user so I tend to leave these on their default settings.
27 July 2011
Determining Occupancy with Key and Room Schedules
In the previous post we reviewed how to configure a code based key schedule. Now we'll review how that key schedule integrates with a room schedule to determine occupant load based on room area.
Why is it important that the occupancy calculations are integrated with room schedules rather than area schedules? Occupant load is based on the physical area a person can occupy within a room. Room area is defined to the face of bounding elements whereas Areas (defined with area plan) are typically inclusive of wall cavities, plenums, shafts and other building area incorporated in programming by gross-up factors. Occupancy based on Rooms rather than Areas is also important for analysis and determination of air changes and fire protection. Air changes and fire protection calculations are based on volumes of space. Rooms have volumes; Areas do not. It is also useful to define occupancy type and calculate occupant load based on Rooms rather than Areas when using room schedules as the basis for programming room data sheets. The last point to make for using Rooms rather than Areas to calculate occupancy has to do with exiting. I've yet to find a method to integrate occupant load to exit capacity (door width) and exit load (number of occupants divided by number of exits) but verifying this parametrically should be feasible in the near future or when I find someone who can figure out the boolean formula required for this! (And if you can figure that out I'd also like to make travel distance to exits parametric.)
Why is it important that the occupancy calculations are integrated with room schedules rather than area schedules? Occupant load is based on the physical area a person can occupy within a room. Room area is defined to the face of bounding elements whereas Areas (defined with area plan) are typically inclusive of wall cavities, plenums, shafts and other building area incorporated in programming by gross-up factors. Occupancy based on Rooms rather than Areas is also important for analysis and determination of air changes and fire protection. Air changes and fire protection calculations are based on volumes of space. Rooms have volumes; Areas do not. It is also useful to define occupancy type and calculate occupant load based on Rooms rather than Areas when using room schedules as the basis for programming room data sheets. The last point to make for using Rooms rather than Areas to calculate occupancy has to do with exiting. I've yet to find a method to integrate occupant load to exit capacity (door width) and exit load (number of occupants divided by number of exits) but verifying this parametrically should be feasible in the near future or when I find someone who can figure out the boolean formula required for this! (And if you can figure that out I'd also like to make travel distance to exits parametric.)
Key Schedule for Determining Occupancy
A key schedule is a useful way to link occupancy calculations to rooms within Revit. Following are steps for creating a key schedule based on ABC 3.17.1.
Define a key schedule from View - Schedules - Schedule/Quantities. Set the Category as Rooms, name it OCCUPANCY ABC 3.17.1, activate the Schedule keys radio button and set the Key name to Occupancy Classification.
Define a key schedule from View - Schedules - Schedule/Quantities. Set the Category as Rooms, name it OCCUPANCY ABC 3.17.1, activate the Schedule keys radio button and set the Key name to Occupancy Classification.
On the Schedule Properties dialogue window Add Parameter for Area Per Person, Common discipline, Number Type of Parameter and Group parameter under Other.
Subscribe to:
Posts (Atom)