Working on setting up a rather complicated (for me, at least) spreadsheet. I think what I need is a combination of the VLOOKUP function and the AND function, but I don't know how to combine them to make it work. Here's the deal:
I building codes, the minimum required exit width is a multiplier times the occupant load (number of people occupying the space/floor). The multiplier is different for stairs than it is for doors, ramps, and corridors. There are a number of different occupancy classifications and, while the width multipliers are generally 0.3 inches per person for stairs and 0.2 inches per person for everything else, in a few occupancy classification this changes ... and may also be different if the building doesn't have a sprinkler system.
I'm trying to come up with a spreadsheet in which I can just enter the room names, numbers, and area and have the spreadsheet calculate the required exit width.
[There are similar calculations for required numbers of toilet fixtures based on occupant load, but if I can figure out how to do the egress width I think I can extrapolate to do the fixture count.]
Would any Excel gurus be interested in taking a shot at it? If so, the simplest thing might be for you to send me a PM with an e-mail address and I'll send you the spreadsheet with the lookup table already entered.
