We're trying to create a life safety sheet for future projects that will show a room schedule with the occupancy type of each room, the area of each room, occupancy type, number of occupants allowed by code, etc.
What we need to have is some kind of formula that will say okay if this room is Assembly occupancy, take the area and divide by 15. If it's a different occupancy, take the area and divide by some other number, etc. Is there a way to do this?
Right now we just have columns for every type of occupancy, so the table ends up showing the number of occupants for each occupancy type, for EVERY room. We thought we might do filled regions to block out the unwanted numbers for each occupancy but apparently a filled region won't obscure a schedule and it's data. We would rather have just one column labled "Occupancy" that would divide the area by the correct number, based on the occupancy assignment of that room.
Anyone know of a way to do this?