| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | HOW TO USE THIS FILE | |||||||||||||||||||||||||
2 | This classification system database file is accessed by the Autodesk Classification Manager for Revit in order to add classification system values to your Revit elements. This worksheet provides general instructions. The classification system relies on five (5) distinct worksheet categories: Contacts, Facility, Spaces, Products by Instance, and Products by Type. "Contact" is referenced by the Autodesk COBie Extension for Revit Contact List, when installed. "Facility" is referenced by Autodesk COBie Extension for Revit, when installed. "Space" is referenced by Revit Rooms and Spaces. "Element" is referenced by model elements. Each worksheet has a header with information necessary for the Revit Classification Manager. You can edit "Title", "Description", "Version", "Number Parameter", and "Description Parameter". Do not change the "Function" field, or the utility may not function as expected. "Number Parameter" and "Description Parameter" refer to a Revit parameter in your model. This is where the data from the "Number" column and "Description" column will be stored in your Revit elements. The Parameter must already be created and the name must match exactly with what is typed in the field in the Excel Database. If there are multiple parameters with the same name, the utility has no way to distinguish which one to use. We strongly recommend a parameter with a unique name. These parameters MUST be TEXT parameters in Revit. You can have multiple worksheets of each category. Feel free to copy the worksheets in this Excel workbook to create new worksheets to use. You can rename the worksheets to anything that is appropriate for your database. The Classification Manager does not refer to the worksheet names. In each worksheet, do not edit the first row of data under the table head. This is an automatically generated Title, Description, and Level information based on the fields you fill out in the worksheet header. The first column is the Classification Number, and should be of a logical structure. The second column is the Description field. The third column is the Level column; this column determines where in the "hierarchy" this specific category exists. The Classification Manager will read the classes line by line. If it reads a "3" after a "2", it will place that class as a "child" of the level 2 class. Any level 3 class immediately following will be "siblings" to the original level 3. Once the utility finds another "2", it will end the run of 3's and place that class as a "sibling" to the original level 2. The fourth column is the Revit Category column. This field can be filled in with a Revit Family Category Code listed below. This will filter the dropdown in the Classification Manager within Revit and include these classes with the Revit family that you identify in this column. The Contacts, Facility, and Spaces worksheets will ignore this field. | |||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||
6 | ||||||||||||||||||||||||||
7 | REVIT FAMILY CATEGORY CODES | |||||||||||||||||||||||||
8 | Below is a list of the family category codes in Revit. These are used in classification databases - like the ones included with Revit - to filter classification numbers by family category. These are listed as column D in each of the worksheets (tabs) in this database file. Not every line item needs to be assigned a Revit family category code, but when it is, the filter (in the top right of the dialog box) will only show classification numbers for that particular family category, making it easier to find the pertinent ones. | |||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | DISCIPLINE | CODE | REVIT FAMILY CATEGORY | |||||||||||||||||||||||
11 | General | -2002000 | Detail Items | |||||||||||||||||||||||
12 | -2000151 | Generic Models | ||||||||||||||||||||||||
13 | -2000700 | Materials | ||||||||||||||||||||||||
14 | -2003000 | Profiles | ||||||||||||||||||||||||
15 | -2003101 | Project Information | ||||||||||||||||||||||||
16 | -2001350 | Specialty Equipment | ||||||||||||||||||||||||
17 | Architecture | -2003200 | Areas | |||||||||||||||||||||||
18 | -2000127 | Balusters | ||||||||||||||||||||||||
19 | -2001000 | Casework | ||||||||||||||||||||||||
20 | -2000038 | Ceilings | ||||||||||||||||||||||||
21 | -2000100 | Columns | ||||||||||||||||||||||||
22 | -2000170 | Curtain Panels | ||||||||||||||||||||||||
23 | -2000340 | Curtain Systems | ||||||||||||||||||||||||
24 | -2000171 | Curtain Wall Mullions | ||||||||||||||||||||||||
25 | -2000023 | Doors | ||||||||||||||||||||||||
26 | -2001370 | Entourage | ||||||||||||||||||||||||
27 | -2000032 | Floors | ||||||||||||||||||||||||
28 | -2000080 | Furniture | ||||||||||||||||||||||||
29 | -2001100 | Furniture Systems | ||||||||||||||||||||||||
30 | -2003400 | Mass | ||||||||||||||||||||||||
31 | -2000022 | Opening | ||||||||||||||||||||||||
32 | -2001263 | Pads | ||||||||||||||||||||||||
33 | -2001180 | Parking | ||||||||||||||||||||||||
34 | -2001360 | Planting | ||||||||||||||||||||||||
35 | -2000126 | Railings | ||||||||||||||||||||||||
36 | -2000180 | Ramps | ||||||||||||||||||||||||
37 | -2001220 | Roads | ||||||||||||||||||||||||
38 | -2000035 | Roofs | ||||||||||||||||||||||||
39 | -2000160 | Rooms | ||||||||||||||||||||||||
40 | -2001260 | Site | ||||||||||||||||||||||||
41 | -2000120 | Stairs | ||||||||||||||||||||||||
42 | -2001340 | Topography | ||||||||||||||||||||||||
43 | -2000011 | Walls | ||||||||||||||||||||||||
44 | -2000014 | Windows | ||||||||||||||||||||||||
45 | MEP | -2008013 | Air Terminals | |||||||||||||||||||||||
46 | -2008126 | Cable Tray Fittings | ||||||||||||||||||||||||
47 | -2008130 | Cable Trays | ||||||||||||||||||||||||
48 | -2008081 | Communication Devices | ||||||||||||||||||||||||
49 | -2008128 | Conduit Fittings | ||||||||||||||||||||||||
50 | -2008132 | Conduits | ||||||||||||||||||||||||
51 | -2008083 | Data Devices | ||||||||||||||||||||||||
52 | -2008016 | Duct Accessories | ||||||||||||||||||||||||
53 | -2008010 | Duct Fittings | ||||||||||||||||||||||||
54 | -2008015 | Duct Systems | ||||||||||||||||||||||||
55 | -2008000 | Ducts | ||||||||||||||||||||||||
56 | -2001040 | Electrical Equipment | ||||||||||||||||||||||||
57 | -2001060 | Electrical Fixtures | ||||||||||||||||||||||||
58 | -2008085 | Fire Alarm Devices | ||||||||||||||||||||||||
59 | -2008020 | Flex Ducts | ||||||||||||||||||||||||
60 | -2008050 | Flex Pipes | ||||||||||||||||||||||||
61 | -2008107 | HVAC Zones | ||||||||||||||||||||||||
62 | -2008087 | Lighting Devices | ||||||||||||||||||||||||
63 | -2001120 | Lighting Fixtures | ||||||||||||||||||||||||
64 | -2001140 | Mechanical Equipment | ||||||||||||||||||||||||
65 | -2008077 | Nurse Call Devices | ||||||||||||||||||||||||
66 | -2008055 | Pipe Accessories | ||||||||||||||||||||||||
67 | -2008049 | Pipe Fittings | ||||||||||||||||||||||||
68 | -2008044 | Pipes | ||||||||||||||||||||||||
69 | -2008043 | Piping Systems | ||||||||||||||||||||||||
70 | -2001160 | Plumbing Fixtures | ||||||||||||||||||||||||
71 | -2008079 | Security Devices | ||||||||||||||||||||||||
72 | -2003600 | Spaces | ||||||||||||||||||||||||
73 | -2008099 | Sprinklers | ||||||||||||||||||||||||
74 | -2008101 | Switch System | ||||||||||||||||||||||||
75 | -2008075 | Telephone Devices | ||||||||||||||||||||||||
76 | -2008039 | Wires | ||||||||||||||||||||||||
77 | Structural | -2005301 | Boundary Conditions | |||||||||||||||||||||||
78 | -2009013 | Rebar Shape | ||||||||||||||||||||||||
79 | -2009003 | Structural Area Reinforcement | ||||||||||||||||||||||||
80 | -2001327 | Structural Beam Systems | ||||||||||||||||||||||||
81 | -2001330 | Structural Columns | ||||||||||||||||||||||||
82 | -2009030 | Structural Connections | ||||||||||||||||||||||||
83 | -2001300 | Structural Foundations | ||||||||||||||||||||||||
84 | -2001320 | Structural Framing | ||||||||||||||||||||||||
85 | -2009009 | Structural Path Reinforcement | ||||||||||||||||||||||||
86 | -2009000 | Structural Rebar | ||||||||||||||||||||||||
87 | -2001354 | Structural Stiffeners | ||||||||||||||||||||||||
88 | -2001336 | Structural Trusses | ||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | PARAMETERS | |||||||||||||||||||||||||
94 | The Parameters tab can be used to create Shared Parameters in the Revit model. This is functionality for advanced Revit users and should be tested thoroughly to understand how it works and the limitations. Parameters identified here will be automatically created in the Revit model if they are not in there already. Information in Rows 1, 2, and 3 should not be edited. There can only be a single Parameters tab in a Classification Manager database Excel file. The structure of the tab is designed to allow users to copy/paste from an already created Shared Parameters text file. Do not copy any of the "header" information from the Shared Parameters text file. Paste the copied text into cell B4. Only the following data types are accepted: “TEXT”, “INTEGER”, “NUMBER”, “YESNO”, and “URL” Extra information can be added in the first column A - TYPE v INSTANCE. Putting TYPE in this field will add the parameter at the TYPE level. INSTANCE will add it at the INSTANCE level. If no information is here, the parameter will attach at the TYPE level for appropriate categories. Parameters will be bound to all default Classification Manager categories based on the Function of the classification that uses them: Facility classification parameters will bind to Project Information; Spaces classification parameters will bind to Rooms and Spaces; Element classification parameters will bind to the default model categories for Classification Manager. | |||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||