algebra by excel

D

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

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?
 
D

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,



Rick Rothstein said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top