Worksheet/Door Schedule Ordering

[TomDK]

Hi all, 

 

I feel a bit silly asking this question as it should be fairly simple... Perhaps it is because it is Friday and my brain has already left the office for the weekend! 

 

I am in the middle of creating a door schedule. Our door number system is as follows: D.01.01 (door.first floor.door number). The building I am working on has a basement, lower ground floor and upper ground floor (I am based in the UK for the Americans who call first floor the ground floor) and therefore the numbering system uses B for basement, LG for lower ground and UG for upper ground. 

 

All good on plan and it makes sense. However I am having an issue when it comes to creating the door schedule. the Lower Ground Floor keeps being placed above the Basement Floor. Is there a way I can switch the two so that it runs from Basement, Lower Ground, Upper Ground etc. 

 

Screenshot attached to hopefully make sense of my ramblings! 

 

Thanks!

[Kevin S]

@TomDK Your prefix of '-01-', etc. to the floor name is the culprit. It's sorting based on that prefix. Have you considered changing that?

 

Otherwise another possibility would be to create 3 database rows, with each looking only on the floor you want it to display. You could then show the information in any order that you want.

 

Hope this helps as a possible solution for you.

[Tom W.]

Also I think in this case if you sort based on door number that will give you the order you want...?

[TomDK]

Hi Kevin, 

 

Thanks for the speedy reply. I was thinking that would be the case.

 

The strange thing is, that logic doesn't seem like it follows through completely? If the prefix '-01-' comes before '-02-, that means the minus part of the prefix is ignored. And therefore the -01, -02 ordering is kept. But if that was the case, surely 00 would then come first rather than after the two lower floors. 

 

Perhaps I'm just completely over thinking it!  

 

Strangely @Tom W. that wasn't working either. 

 

I have however managed to force it to order as I want  by adding an asterisk to the start of my Basement Level layer name (which is the first column) and then hiding that column.  

[Kevin S]

8 minutes ago, TomDK said:

The strange thing is, that logic doesn't seem like it follows through completely? If the prefix '-01-' comes before '-02-, that means the minus part of the prefix is ignored. And therefore the -01, -02 ordering is kept. But if that was the case, surely 00 would then come first rather than after the two lower floors. 

 

You're sorting in ascending order, and the dash takes precedence over the number. It is not ignoring the dash.

[Tom W.]

10 minutes ago, TomDK said:

Strangely @Tom W. that wasn't working either. 

 

Did you remove the sorting from B + E first...?

[shorter]

If your layers are set up to list properly, then I would add a column to show the layer, and list in ascending order using the layer name, or part thereof.

 

If you have a logical cad standard and a consistent way of naming layers, and for example, the floor is always in the same place in the layer name and you use the hyphen as a separator, then you can use the formula

 

=substring(L,'-',n) where n is the position of the floor indicator in the layer name, e.g.

 

If the layer was

 

00-Something

 

the formula =substring(L,'-',1) would result in '00'.

 

In fact the '00' in the door number can come from the layer name if you use

 

=concat('Door'.'IDPrefix','.',substring(L,'-',1),'.','Door'.'IDSuffix')

 

This would give you

 

D.00.001

 

i.e. door on layer '00' using the door prefix 'D' and suffix '001'.

 

It can even be linked to the room too, although that's a bit more tricky if the door straddles two rooms.

Edited November 9, 2024 by shorter