new user question

VBA and general Excel Q&A and examples

Moderator: DPlotAdmin

Post Reply
jason lake
Posts: 3
Joined: Wed Sep 03, 2008 12:29 pm

new user question

Post by jason lake »

Hi there,

I am working working with displacement data and using dplot to differentiate this data to generate velocity, smooth and then differentiate to generate acceleration data.

My question is, is there a way to calculate the objects force from the acceleration curve using the following formula: ((g [9.81]*mass [say 20kg])+(mass[say 20kg]*acceleration)).

If this were possible the velocity curve could then be multiplied by the force data to obtain mechanical power output.

Up until now I have been copying the data over to excel to perform these calculations but was wondering if there was perhaps a quicker way.

Many thanks,

Jason.
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

Jason,
You can perform whatever manipulations you want to on your data within DPlot using Edit>Operate on Y. If you want to preserve the curve you'll be operating on then make a copy of it first: Edit>Copy>Data values, Edit>Paste.
Visualize Your Data
support@dplot.com
jason lake
Posts: 3
Joined: Wed Sep 03, 2008 12:29 pm

Post by jason lake »

Thank you for your swift response.

That works perfectly in answering my first questioning.

However, I'm a bit stuck with regard to my second... can I multiply one y curve by another.

From your answer it seems that I can but I'm having trouble figuring it out.

Many thanks for your help,

Jason.
User avatar
DPlotAdmin
Posts: 2312
Joined: Tue Jun 24, 2003 9:34 pm
Location: Vicksburg, Mississippi
Contact:

Post by DPlotAdmin »

Yes, use Generate>Y=f(X,Y1,Y2,...)

For example to multiple the amplitudes of the 2nd curve by the amplitudes of the 3rd curve, use Y=Y2*Y3
Visualize Your Data
support@dplot.com
jason lake
Posts: 3
Joined: Wed Sep 03, 2008 12:29 pm

Post by jason lake »

Hi David...

that's excellent, worked perfectly.

Thank you very much for your help.

Kind regards, Jason.
Post Reply