Pulling % values from total Square Footage to Equal 100%

This might be a little confusing but I’m going to do my best at explaining it. I have a total building square of 97,568sf. This building has 7 different program types within that square footage. No matter how I split the program % up, it needs to equal that 97,598sf. For example, I’m trying to show the client that if I move Office % up to 20% the other 6 programs’ square footage will adjust automatically.

If 97,568sf = 100%, I need all other % to equal 100 no matter how I split it. Maybe its a ratio thing. I’m really not sure at this point. It’s one of those things where I’ve been looking at it for so long that I need a pair of outside eyes.

Any recommendations??
Thank you in advance

1 Like

Check out this thread also :


This thread was just what I needed! Thank you for the help. This is going to work wonderfully.