Displacement generally refers to the volume of water displaced when an object
is put in its container.

Given the numbers you have below, I would start with the relation 1001bs
displaces .5 cubic feet of water. Presumably 200lbs discplaces a cubic foot
of water, which, by your relation 8 gallons = 1 cubic foot, you know that a
200 lb person displaces 8 gallons of water.

You have the information you need; you just need to work through it. I
don't know what the dimensions of a tub would get you, and I'm not sure why
you would need a person's height.

Dave
--
Brevity is the soul of wit.


"Darryl" wrote:

Hello.

Excel Newbie here. I've been asked to create a spreadsheet that will
calculate the gallons of water needed based on the Height and weight of
a person going into a walk-in bathtub with a door. It is really to
determine how large of a tub to put in for a person based on their
size.

I'm guessing you will need information on the dimensions of the tub?
The client mentioned water displacement, and the numbers that follow

Here is what he told me he found out about water displacement

63 lbs will displace w62lbs of water
100lbs displaces ½ cubic feet of water
1 gallon weighs 8lbs
8 gallons = 1 cubic foot

I'm not sure where to EVEN start with this. Am I over my head, or do I
even have enough information?

Thanks for the help.