hello again,

Is there a simpler way to have a short formula?

=IF(A6=A3,B3,IF(A6<A2,(A6-A1)*C1+B1,IF(A6<A4,B3+(MAX(SQRT(D3^2-IF(A6<A4,A6-A3,0)^2)*(IF(A6<A4,A6-A3,0)<0),SQRT(D3^2-IF(A6<A3,A3-A6,0)^2)*(IF(A6<A3,A3-A6,0)<0))-D3),IF(A6<A5,(A6-A4)*C4+B4,"XXX"))))

this is a line+circ.curve+line equation to get elevation...I hope i can
simplify this for easy remembering..

--
regards,

Tell us what the math is (not the Excel)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"driller" wrote in message
...
hello again,

Is there a simpler way to have a short formula?

=IF(A6=A3,B3,IF(A6<A2,(A6-A1)*C1+B1,IF(A6<A4,B3+(MAX(SQRT(D3^2-IF(A6<A4,A6-A3,0)^2)*(IF(A6<A4,A6-A3,0)<0),SQRT(D3^2-IF(A6<A3,A3-A6,0)^2)*(IF(A6<A3,A3-A6,0)<0))-D3),IF(A6<A5,(A6-A4)*C4+B4,"XXX"))))

this is a line+circ.curve+line equation to get elevation...I hope i can
simplify this for easy remembering..

--
regards,

You will need to describe what is stored in the various cells you are
testing against (for example, A2, A3, A4, etc.).

I would like to ask a question though. I see you mentioned Line-Arc-Line to
get an elevation... I was a Civil Engineer in Road Design for some 32+ years
this *almost* sounds like a roadway elevation calculation **except** that
roadway elevations are almost exclusively calculated with a parabolic arc
between tangent lines, not a circular arc. Can you confirm what this
calculation is being used for?

--
Rick (MVP - Excel)


"driller" wrote in message
...
hello again,

Is there a simpler way to have a short formula?

=IF(A6=A3,B3,IF(A6<A2,(A6-A1)*C1+B1,IF(A6<A4,B3+(MAX(SQRT(D3^2-IF(A6<A4,A6-A3,0)^2)*(IF(A6<A4,A6-A3,0)<0),SQRT(D3^2-IF(A6<A3,A3-A6,0)^2)*(IF(A6<A3,A3-A6,0)<0))-D3),IF(A6<A5,(A6-A4)*C4+B4,"XXX"))))

this is a line+circ.curve+line equation to get elevation...I hope i can
simplify this for easy remembering..

--
regards,

Exactly, line-circ.curve-line...
I'm trying to contain all the levels on one calculator-formula based on
assigned
Radius, Lc,gradient slope of lines & chainage of Pts. .
the formula looks long for me to remember.
Do you have a simpler sinlge formula.
Thanks for the reply.

--
regards,



"Rick Rothstein" wrote:

You will need to describe what is stored in the various cells you are
testing against (for example, A2, A3, A4, etc.).

I would like to ask a question though. I see you mentioned Line-Arc-Line to
get an elevation... I was a Civil Engineer in Road Design for some 32+ years
this *almost* sounds like a roadway elevation calculation **except** that
roadway elevations are almost exclusively calculated with a parabolic arc
between tangent lines, not a circular arc. Can you confirm what this
calculation is being used for?

--
Rick (MVP - Excel)


"driller" wrote in message
...
hello again,

Is there a simpler way to have a short formula?

=IF(A6=A3,B3,IF(A6<A2,(A6-A1)*C1+B1,IF(A6<A4,B3+(MAX(SQRT(D3^2-IF(A6<A4,A6-A3,0)^2)*(IF(A6<A4,A6-A3,0)<0),SQRT(D3^2-IF(A6<A3,A3-A6,0)^2)*(IF(A6<A3,A3-A6,0)<0))-D3),IF(A6<A5,(A6-A4)*C4+B4,"XXX"))))

this is a line+circ.curve+line equation to get elevation...I hope i can
simplify this for easy remembering..

--
regards,