LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how tom take an average of file when i have three different values

Solved!
Go to solution

Dear all,

 

I have a file with five column,                                                              
A    B                      C    D    E               
2    1.23375E+17    30    31    2              
2    2.04196E+17    0      32    2               
2    2.31994E+17    0      33    2               

2    2.01626E+17    30    33    2       

2    1.79445E+17    0      34    2          

 

I want to take an average of  B for D= 0 to 15,,, 16 to 30, ,, 31 to 45, 46 to 59,, anf E= 0 ,2,3,4,5,........ 23,

 

for A = 2, 3, 4, 5, ......32..

 

here is programme and file.

Download All
0 Kudos
Message 1 of 5
(2,354 Views)
Solution
Accepted by topic author Julian_prince

Not sure what you are doing in the program nor am I certain about your question.

Here is something that may be a start (hopefully!)

average.png


CLA CTAChampionI'm attending the GLA Summit!
Subscribe to the Test Automation user group: UK Test Automation Group
0 Kudos
Message 2 of 5
(2,337 Views)

Duplicate post?  Continue the discussion in your original thread.  Or is this a different problem altogether?

 

http://forums.ni.com/t5/LabVIEW/how-to-put-3-condition-in-two-files/td-p/1828325

-----------------------------------------------------------------------------------------
Reese, (former CLAD, future CLD)

Some people call me the Space Cowboy!
Some call me the gangster of love.
Some people call me MoReese!
...I'm right here baby, right here, right here, right here at home
0 Kudos
Message 3 of 5
(2,316 Views)

this is slight different problem, in that post there was two files . in this problem i have to use only one file.

 

 

0 Kudos
Message 4 of 5
(2,303 Views)

I aapreciate with you sir,

 

 acually my problem is differenet, i repeat it belowe.

 

A    B                      C    D    E               
2    1.23375E+17    30    0    0              
2    2.04196E+17    0      1    0              
2    2.31994E+17    0      2    0              

2    2.01626E+17    30    3    0      

2    1.79445E+17    0      4    0        

1-Column A having the value of no of system which start from 2 to 32,,

2- colum D having the minutes which is start from 0 to 59.

3- colum E is hour Which varies from 0 to 23.

 

now i want to keep system (Column A) constant at 2 and for 0 hour ( Column E).. and want to take the average of Values (Column B). For 0 to 15 , 16to 30 , 31 to 45, 46 to 59 ,,,minute (column C).

 

Means I will have 4 value for each hour,

 

means i want to put first lup where Column A is constant for 2, at the same time second lup inside the first lup Having the constant value of Column 2.  and at third lup  take the avergae of value B for each 0 to 15, 16 to 30, 31 to 45, 46 to 59,..

 

hope you will help me regarding this,

0 Kudos
Message 5 of 5
(2,274 Views)