DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Extract interpolation values from a DPlot graph with Excel

 
Post new topic   Reply to topic    DPlot Forum Index -> General discussion
View previous topic :: View next topic  
Author Message
PatrickTotor



Joined: 22 Oct 2021
Posts: 1

PostPosted: Fri Oct 22, 2021 8:38 am    Post subject: Extract interpolation values from a DPlot graph with Excel Reply with quote

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.
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Mon Oct 25, 2021 5:12 am    Post subject: Reply with quote

I'm a little confused about what you want to do. It sounds like you are exporting your data from Excel to DPlot and then using Info>Interpolate (or the InfoInterpolate macro command) to find Y on each curve for a given X. Correct so far? If so, you want to automatically export the results back to Excel? If so, there is no way to do that that is easier than using the Copy button on the Interpolate results window. On the DPlot side you could write a macro to automatically copy the results, but NOT to automatically paste that content into Excel (which it sounds like what you want to do). On the Excel side this is hopeless. I suppose you could write a VBA routine to do everything mentioned up to the point that the answers were copied to the Clipboard. But after that you'd want to parse the results to get the actual values, not just a block of text. To me that sounds like a lot more trouble than simply pasting the results into Excel then manually stripping off the unwanted text parts.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> General discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group