Time Response question on how to Read data from excel or to output to an Array

[Doki86]

Hey guys, If anyone can show me how i can do this operation i would love you long time :),

So I am using an Omega Module to collect data from an RTD, now From the collected data i save them to an excel file is the .xls extension. from there I am loading the data into an array to find the min and max and calucate the time response.

in this case its the Measured temperature from an external Thermocouple, the formula to get the time response is                                                    (Temperature of Thermcouple - the minimum temperature of the RTD)*.632 + the Minimum Temperature = Stop Temp. 

Since i know how many seconds i am running the program for and how much points per second is collected I want to tell labview to count how many spaces were used from when the Minimum temperature is Greater than the Minimum Temperature to the Greater or Equal to the Stop Temperature.

This might be a little confusing so I put some Psuedo Code below.

Load Data into Array

Calculate Stop Temp i.e.( (TempTC-TempMin)*(0.632) + TempMin) = Temp Stop

Count = Count from when TempMin > TempMin To Temp Stop

Time Response = Count/PointsPersecond ( which is a constant value input by the programmer)

I know this is very Brute of a code but i am Limited to the amount of Controls I have so this is what i have .

I have also attached my Code below for anyone to feel free to look at.

Thank you so much in Advanced 🙂

Chris 

[nyc_(is_out_of_here)]

count spaces?

[Doki86]

For example. In the attached Excel file, I want to basically count how many rows were used till the Stop Value, For example from 24.952 all the way to 31.612 which occupied 1012 Rows then dividing that number by the points per second and getting your time response. How am i able to get labview to Start from the Min > Min Value to the >= Stop Value .

[Doki86]

I think I may have confused some guys with my wording. So I am using an OMEGA DAQ, collecting data over a set time period lets say 10 seconds. The Data then Outputs to an XLS file or Excel spread Sheet. 

I then Load the data from the Excel spread sheet and i Find particular Values that i need to find. In this case for my Calculation of time response I need the Minimum Value, the Temperature the unit under test is exposed to and the Time Constant to read 63.2%,

I.e. 25 degrees C to 100Degrees C w

here DT = 75 and 63.2% of 75 is 47.4

and TC the time when the reading reaches 72.4 = 47.4+25 

So the time response is all the data collected between 25 Degrees C to 72.4 Degrees C. 

the data i collect is compiled in Excel and is populated in the First Column and from my testing for a ten second period there are about 31.2 points of data collected over a second. 

what i want to do is to Start from 25 Degrees C and count how many rows were used to read 72.4 Degrees C and Divide that by the 31.2 Seconds to get a time response.

I really hope that clarify's any confusion.

thanks

-Chris