Complex Math Problem (For Me) dealing with square footage

[JeremyA1976]

Hello all. Hope someone out there can at least help me find the right path. I am trying to solve for one of the following problems. Let me try to explain:

I am a sheet metal worker.
I am trying to find the square footage for a typical fitting we produce.
The fitting is a radius heel, radius throat, "width change", rectangular elbow (not to exceed 90 degrees).
The depth of the fitting will remain constant. (determined by user)
The width can change, but W1 (Width-1) must always be larger than W2 (Width-2). *within reason base on geometry

The user will input the following variables:
-Angle
-Throat Radius
-Width-1 *Larger if not equal
-Width-2
-Depth *Not required on cheek, but will need for heel and throat stretchout

In my worksheet, I need to solve for the cheek square footage. Below I have attached an example of a 45 degree rectangular change elbow *Cheek Shown

https://drive.google.com/file/d/0ByOvfJFPzxKPOExiU2RGVXlueUE/view?usp=sharing

just to give you a basis of what i am looking for.

The example I am showing is a 16" Width-1 to a 10" Width-2 @ 45 degrees and a throat radius of 10".

I have been able to figure out some pretty complex math formulas, but what is throwing me for a loop is trying to find out the "Heel Radius Offset HR1", "Heel Radius HR", "Heel Straight Length HSL" or "Width 2 Offset W2O". Any one of these solutions will help me find the rest, but I can't find a common connection to formulate it out. With a change elbow, the less degree you have, the more straight/ smaller heel radius you will have. It might be pretty easy for someone to figure this out, but I have been fighting this a few days and its driving me crazy. lol. crazier. Any questions I can answer to help explain? Thanks in advance for taking a look. Any advice is appreciated

https://drive.google.com/file/d/0ByOvfJFPzxKPdVhzX2dNM2w2bVU/view?usp=sharing

 

[FDibbins]

I cannot view images or access file-hosting sites

How would you do this calc manually?

 

[JeremyA1976]

crap. sorry FD. Im not sure how to change that.

I have no idea! If I had a piece of metal, and normal layout tools, it is easy. I don't know how to translate to excel. Is there another way to share these images?? They will greatly help explain what I am looking for. I am not really new to mrexcel, but i am rough around the edges with this forum. I posted those images to my gmail account and enabled sharing. Am I missing a setting I need to toggle on?

 

[JeremyA1976]

I changed my settings on sharing. let me know if that helped

 

[FDibbins]

No, the problem is not your end, it is my side. I am at work, and the server does not allow that

 

[JeremyA1976]

Gotcha, if you get a chance to check it out later on your personal time, I would appreciate it.

I have been solving for the blank off piece (metal end to end) and subtracting what i could. Once you see the pics, it might help explain where the formula can get a bit wonky

 

[FDibbins]

What would the manual formula be?

 

[JeremyA1976]

The "Formula" I speak of is a worksheet which contains a bunch of functions that trim down the if statements and funnel the correct answer. Is there a way to post that worksheet on here for you to see?