algebra by excel
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, |
algebra by excel
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, |
algebra by excel
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, |
algebra by excel
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, |
All times are GMT +1. The time now is 05:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com