algebra by excel

[driller]

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..

 

[Bernard Liengme]

Tell us what the math is (not the Excel)
best wishes

 

[Rick Rothstein]

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?

 

[driller]

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,

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?