
Originally Posted by
Aussiebear
The midpoint of half circle HC1 will sit somewhere on the horizontal leg providing the arc is always contained within the Area of the Quadrant.
1. For the purpose of this exercise, the radius of the HC1 just happens to be 3m which puts it at the midpoint of the Quadrant horizontal radius.
<snip>
Thus the area remaining in the quadrant is 28.27433388 - 14.13716694 - 6.283185306. = 7.853981634 sq mtrs.
Since we are having difficulty in creating a Function, can somebody confirm that my maths is correct and is there a way to write to correct formulas into excel. Once I'm able to move past this point then I shall concentrate on a Function to do the same thing.