The door schedule lists the door numbers as follows:
A200A
A201.1A
A201.1B
A201A
A202A
A202B
etc...
The first letter is for area designation (Prefix)
The number is the room number
The last letter is the door designation (Suffix)
The Prefix is set under room object definition (Format - Case Upper)
The number is set under room object definition (Format - Number Object)
Then compiled using a formula definition under room object definition (Format - Case Upper)
Thus you have A201
Then under door objects the door number references the compiled room object definition (Format - Case Upper)
The suffix is set under door object definition (Format - Case Upper)
Then compiled using a formula definition under door object definition (Format - Case Upper)
Thus you have A201A
How do I get the numbers to sort correctly with decimal points?
Solved! Go to Solution.
Solved by David_W_Koch. Go to Solution.
Solved by David_W_Koch. Go to Solution.
Here is the sample file on which I was working, done in ACA 2014. If you have ACA 2014 or 2013, you can take a look at the Door Schedule Table on the right, particularly the Columns and Sorting tabs of the Schedule Table Style, to see how the sorting was done.
David,
Thanks for looking into this. I came to about the same conclusion.
The door number was referencing a formula to add the prefix and the number together under room objects. I guess this changed the way autocad sorts placing the "." before whole numbers.
What I did was reference the door object prefix to the roomobject prefix; the door object number to the room object number and create a compilation formula under door object.
Added the hidden columns to the schedule and used sort order to finish it out.
Thank you for your help,
Josh
ACA 2014
Can't find what you're looking for? Ask the community or share your knowledge.