The Medway Handyman :
An awning is attached to a wall at a height "X".

The front edge is lower because the awning slopes by 15 degrees.

Depending on the width, the awning could extend by anything from 1m to 4m.

If I want the front edge at a specific height "Y", what would distance
"X" be?

I want to make up a spreadsheet to calculate this for any height "Y"
and any extension. So, if the client wants the front of the awning 2.1m
off the ground and it extends 2m, how high would "X" be?

The easy way to answer this and similar questions is to make a scale
drawing. It doesn't have to be anything fancy, all you need is pencil,
paper, and ruler.

A spreadsheet would be quicker and more accurate but a drawing would be
accurate enough and would give you a better feel for what the result
would look like.

--
Mike Barnes