Today is...
Friday, December 14, 2018
Welcome to Control.com, the global online
community of automation professionals.
Featured Video...
Featured Video
EtherCAT with CTC’s master lets your multivendor network play well together...
Our Advertisers
Help keep our servers running...
Patronize our advertisers!
Visit our Post Archive
How to Use Time Series Data in Excel?
Derivative function simulate in Excel with Time Series Data Input

Hi all,

I have struggling on my first trial data simulation by using function block algorithm Lead (LD) block. The function block equation is transferred from s-domain to time domain and using time domain equation to simulate in Excel. The result is output are trending into the same direction, but my output signal is difference from real output in DCS even are the same gain, derivative time, and real data input. Please have a look details in the link below:

https://1drv.ms/x/s!AhRz0jmsT5ahqWxYdAgxuMOLseol

I am appreciate if anyone can advise me how to do correctly.

Regards,
Latsany

Moderator’s Note: You will need to copy and paste this URL.

The derivative action is achieved by multiplying the Fouier amplitude by frequency and then taking the inverse.

Good luck