Extract interpolation values from a DPlot graph with Excel
Posted: Fri Oct 22, 2021 8:38 am
Hello guys,
I bought this software some time ago already and I would like to truly get started with it. I used it mostly with digitizelt to transform old data curves to interpolable curves.
But now I would like to really earn a lot of time, and I don't want to do the interpolations by myself anymore:
I have an excel file with my graphs path on my computer, and thanks to an input section, I know on which one I need to go. In these graphs, I have 4 curves, and I would need to get the Y result of the interpolation of these curves for a X value given in input.
I feel like it should be the absolute basis that can be done but I don't know how. I started browsing the Excel forum section but as I don't know how to search for it, I don't find an answer. I think I may need to use VBA commands but I am not sure.
Does someone know how to do this or is there a post where a related question was asked ?
Thank you,
Patrick.
I bought this software some time ago already and I would like to truly get started with it. I used it mostly with digitizelt to transform old data curves to interpolable curves.
But now I would like to really earn a lot of time, and I don't want to do the interpolations by myself anymore:
I have an excel file with my graphs path on my computer, and thanks to an input section, I know on which one I need to go. In these graphs, I have 4 curves, and I would need to get the Y result of the interpolation of these curves for a X value given in input.
I feel like it should be the absolute basis that can be done but I don't know how. I started browsing the Excel forum section but as I don't know how to search for it, I don't find an answer. I think I may need to use VBA commands but I am not sure.
Does someone know how to do this or is there a post where a related question was asked ?
Thank you,
Patrick.