Weight range

[caters]

I want to have the weight range be random but age dependent.

Ideally I would want a BMI function dependent on age and then from that and height, calculate weight.

If you are wondering why, I am making a spreadsheet of 200 humanoids(100 male and 100 female) and wanting to calculate their muscularity index.

The muscularity index you might wonder what it is. It is a scale from -3 to 3 based on muscle to fat ratio(Negatives mean more fat, 0 means average, and positives mean more muscle).

With muscularity and BMI I can deduce where a certain humanoid would be on the muscularity index.

So anyway, I have set a few of the columns.

The first one is just numbers from 1 to 200 to keep track of the different humanoids.

The second one is gender. I have the first 100 being male and the rest being female.

The third one is height. This is in inches and goes between 48 inches(4 feet) and 84 inches(7 feet). This is the first random function. Again, maybe later on I will add heights below and above that but for now, this is my height range.

The fourth one is age. This is the second random one. I set it so it would be random and between 15 years(beginning of adolescence for my humanoids) and 120 years(Even though I could theoretically go out to 1000 years since my humanoids can't die of old age. But I just wanted to go to 120(maximum natural human lifespan) to simplify things. Later on I might want to do it for something like 1 million humanoids and for that I would need code. Then I might go to 1000 years or close to it.

The other columns for muscularity and weight I have nothing in yet because I am still working on it.

The weight is something that I am having trouble figuring out a formula for. I might want to put the muscularity before the weight now that I think about it but I also want it to be age dependent.

So I was wondering if you might be able to help me figure it out.

Here is the file I am working on.