How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:05


Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that

 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent. Then I have
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent. Then I have to
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent. Then I
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent.
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:06

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MRM » Sun, 13 Jan 2008 04:10:07

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent. Then
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by Weiyua » Sun, 13 Jan 2008 06:40:05

This is a demo of reading the data.   You can use it as a reference.  It only read the time disregard of AM.


test.xls:
http://www.yqcomputer.com/


test_read_xls.vi:
http://www.yqcomputer.com/
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by Haider Abb » Thu, 17 Jan 2008 17:40:09

Your need to do Differeciation . and use differenciator fuction to do the same
will help a lot
 
Haider
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by Ravens Fa » Fri, 18 Jan 2008 00:10:05


Your need to do Differeciation . and use differenciator fuction to do the same
will help a lot
 
Haider


Okay, that must be a new word.  What is a "differeciation" or "differenciator" function?:smileyvery-happy:
 
 
 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Post by MikeS8 » Fri, 18 Jan 2008 16:10:06

Hello
you can simple subtract one time from the other one and so you get the difference. -> Example
Mike


Unbenannt 2.vi:
http://www.yqcomputer.com/