I am currently montioring pressure changes (via ADC-11 & Picolog). I have tried the =PLW|current|value command in Excel, and it DOES work.
However, I would like to have a cell within Excel that does a real time calculation to determine the rate of change.
For example, the current cell (A1) changes every second. I'd like a neighboring cell (B1) to be able to take the current A1 value and subtract it from the previous A1 value - thus giving me a real-time, per second rate of increase/decrease.
Is there anyway to perform this using Excel? I know I can do it from a saved table, but that's not real time. Any suggestions would be very much welcome!!
Another question relating to DDE - is it possible to specify which channel is the "current" value? I have three channels, and would like all three in the Excel sheet. Can this be done as well.