I have two curves as shown in the attached file. The first one is a two-point straight line. The second is a series of straight lines. The missing values in the second one to be interpolated.
I need the total area between the two lines, the areas above and below to be returned separately. The area is also bounded by vertical lines through the end points of the first line.
I had asked this question earlier and the expert provided an approximate numerical method which takes a long time if the precision is increased.
I have provided a file showing the calculation steps which I am looking for. Can someone provide VBA code for the same?