Hi all,

I have a plot that looks like the one in the image below:

TEST_14.jpg

Basically, here's what I need to get accomplished:

1. Determine the initialslope(i.e. m1) of the curve.

2.Translatethe slope two (2) units along the horizontal axis to get m2.

3. From theintersectionbetween the slope m2 and the original curve, I need to obtain the y- (Bending moment) and x- (Angle of rotation) values at that point.

Is it possible to perform such operations in MS Excel? If it is, how do I go about doing it? The data file for the plot is included in the attachment.

Thanks!

## Bookmarks