Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Experts:

Please find attached spreadsheet that provides an illustration for calculation the are of a cone.

I have provided some assumptions for known values... in the event other values are required, the assumption is that those values are also known or can be obtained.

The triangles are not drawn to scale... scale is not really important at this moment though.

My questions... based on the calculation of the two triangles (at intersection), how can the area for the large "red cone" be calculated?

Thank you,

EEH

Area-calculation.xlsx

Please find attached spreadsheet that provides an illustration for calculation the are of a cone.

I have provided some assumptions for known values... in the event other values are required, the assumption is that those values are also known or can be obtained.

The triangles are not drawn to scale... scale is not really important at this moment though.

My questions... based on the calculation of the two triangles (at intersection), how can the area for the large "red cone" be calculated?

Thank you,

EEH

Area-calculation.xlsx

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with premium.
Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

If this really is a 3D problem, the the shape is properly called a

If the area you want in Q2 is one the surface of the sea, then you have a 1D problem with triangles and trapezoids.

If the area you want is a giant, expanding circular tunnel (half above the water and half below), then you have cones and frustums.

>> If the area you want in Q2 is one the surface of the sea, then you have a

Here is the similar triangle solution.

This drawing is to scale, with

There are three similar triangles:

The smallest includes the target and the intersection point.

The next largest includes the intersection point and the box.

Since the triangles are similar, the distances to the intersection point will be in the ratio 3:1

I don't know how you want to define the largest triangle, but if you know either the range or the width, you can solve for the other data since this triangle is similar to the first two.

This will let you find the area of the trapezoid.

What are the two triangles in question?

Are the three sided of one triangle formed by the two red lines and the yellow box?

Are the three sided of the other triangle formed by the two red lines and some other line?

Are the two red lines supposed to be tangent to the green circle?

Do you need the area to greater precision than the approximation cosine(1 ft/1 mile)=1 ?

Where are the grey triangles?

You're spot on with your questions... here's a response to your comments:

1. Yes... it's a trapezoid.

2. Distance from intersection to figure (green circle)... I'm not sure. I only know the distance from boat to green circle as well as width of the yellow rectange. I hope this can be computed.

3. 3D vs. 2D. Green circle may be on either surface (as illustrated) or airborne. This would make it a 3D; however, I am not concerned about sub-surface. Thus, it'll be only a half of the 3D, right?

How can this be computed in Excel? Thank you in advance!!

EEH

A trapezoid is not a 3D figure, are you talking about the area bounded by the dotted lines and the lines labeled 3FT and 6FT in d-glitch's http:#a40686044 diagram? I don't see a 6FT label in your http://filedb.experts-exchange.com/incoming/2015/03_w13/905001/Area-calculation.xlsx diagram, so how is the right side defined?

If the green circle is actually a 3D sphere, is the yellow box actually a disk? and do you want the surface area of the frustrum formed by rotating d-glitch's trapezoid around the axis formed by the bisector of the two red lines passing through the yellow box and green circle?

If so, and if the base of the trapezoid is actually 6FT, then the height of the trapezoid would be distance from boat to green circle * diameter of green circle / (diameter of green circle+width of the yellow rectangle) * (6FT+3FT)/3FT

The surface area of the side of frustrum, not counting the circular ends, would be pi*(6FT+3FT)*sqrt((6FT-3FT

The area of the 3FT diameter circle would be pi*(3FT)^2/4 and the area of the 6FT diameter circle would be pi*(6FT)^2/4

That is good, but we still need one more piece of information:

>> What is the distance from the point of intersection to right side of the figure?

From the circle to the right, there is no information.

This is also what ozo was asking.

I arbitrarily set it to four miles in my drawing. The lines go on to infinity if you don't limit them.

What are you trying to do? Why does the area matter?

The geometry can be perfect, but it may not be practical. Do you really think you can see a 1 FT target at a range of 2 miles?

Yes, I imagine that more information is needed. Right now, the assumption is that all required values are known to an operator. So, plugging in any required is fair game right now.

Right now, the purpose of this "red trapezoid" is to determine the a "danger zone" (as part of a fundamental military application). Things are very conceptual right now so I may not have all the answers at this time.

With respect to seeing a "1 FT target at a range of 2 miles"... the answer is "yes".... however, I can't go into details here as to why/what.

Again, right now this is more conceptual... I'm just trying to gauge whether or not this could be calculated in Excel (i.e., instead of using a modeling tool). Thank you in advance!

EEH

"If the green circle is actually a 3D sphere,"

- Not it could be any surface... no matter what shape, the left/right boundaries will determine the angle (from boat).

"Is the yellow box actually a disk"

- View it as a surface...

Not sure if I track the proposed math. Any chance this could be put into Excel to compute the area (2D... surface to surface is fine for right now).

EEH

If you miss because you didn't aim properly, then the danger zone will be bigger.

So the missing piece of information is the range of your weapon. The drawing I posted earlier solves the problem approximately for a range of 4.5 miles.

The midpoint of the 6 ft line is 4.5 mi from boat. So the ends of the line are a little further away.

We can agree on 3 ft box, 1 ft target, 2 mi distance.

Tell us what do you want to use for a range.

some formulas to calculate area of a trapezoid in Excel

ee20150325-trapezoid.xlsx

ee20150325-trapezoid.xlsx

You might be better off to do everything in either meters, feet, or miles.

Danger-Zone.xls

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trialor the more relevant area may be the area of the sea surface within the frustrum

Aiming at a target 2 miles away, I would think there would be danger from a red line missing the target by a few inches as well as danger from a red line tangent to the circle.

And if the target can move, then the circle should cover all places the target could be, or where the operator of the weapon might think it could be.

Both solutions work great... I appreciate the insights and spreadsheets for calculations!!!

EEH

Math / Science

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with premium.
Start your 7-day free trial.

The final shape for calculation 2b is a trapezoid.

What is the distance from the point of intersection to right side of the figure?

What determines it? Is it a fixed range. or something else?

You may be able to find all the distances (and all the areas) from similar triangles.