Armed Polite Society
Main Forums => The Roundtable => Topic started by: Hawkmoon on November 06, 2018, 10:07:56 AM
-
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.
-
Send it! I'll do it.
-
I'll have a look at it. Addy inbound.
-
Got it. I think it's going to be easier than you think, but I need to grasp what's going on a bit clearer. I'll get some time to look at it closer tomorrow.
-
Just put in a 14' wide rollup for each room. Anything smaller and some moron will block it to answer a text.
"Now livestreaming from the primary fire exit at the burning plastics factory."
-
@Hawkmoon, I'm still looking at this but I too need your input. I messaged ya my number. Gimme a call and I will get this done. Would have hollered sooner but I've been fighting migraines. Sorry bud.
-
Looks like this is what ya were looking for:
In Cell G13
=IF($D13="","",IF(LOWER($O$6)="n",VLOOKUP($D13,$AA$13:$AE$35,2,FALSE),VLOOKUP($D13,$AA$13:$AE$35,4,FALSE)))
In Cell I13
=IF($D13="","",IF(LOWER($O$6)="n",VLOOKUP($D13,$AA$13:$AE$35,3,FALSE),VLOOKUP($D13,$AA$13:$AE$35,5,FALSE)))
And copy that same formula down by COLUMN. I can send ya the complete sheet back.
NOTE: ROW 19 gets #N/A errors because the D19 value of "A-3" does not exist in the lookup table.
:old:
-
Looks good, Sir. My respects to your Excel prowess. You tossed in a couple of functions I wouldn't have known to even think about using.
-
Any time bud!