Calculate average, azimut and distance


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Calculate average, azimut and distance
# 8  
Old 03-08-2016
How about
Code:
awk '
BEGIN           {LC[1] = LC[2] = LC[3] = 0
                 AC[1] = AC[2] = AC[3] = 0
                 DGARC  = 180 / (atan2(1,1) * 4)
                }
function GETCOORD(C)
                {C[1] = substr($0, 57, 8)
                 C[2] = substr($0, 66, 9)
                 C[3] = substr($0, 76, 5)
                }

NR%2            {GETCOORD (LC)
                 RT = substr($0, 1, 56)
                 next
                }
                {GETCOORD (AC)
                 AVX  = (AC[1] + LC[1]) / 2
                 AVY  = (AC[2] + LC[2]) / 2
                 AVZ  = (AC[3] + LC[3]) / 2
                 DX   = AC[1] - LC[1]
                 DY   = AC[2] - LC[2]
                 DZ   = AC[3] - LC[3]
                 DIST = sqrt(DX ^ 2 + DY ^ 2 + DZ ^ 2)
                 AZI  = (atan2(DY, DX) * DGARC + 180 ) % 180
                 print RT, AVX, AVY, AVZ, $(NF-3), $(NF-2), $(NF-1), $NF, DIST, AZI
                }
' OFMT="%9.1f"  file
A         35089.0 50345.016 9 75   1   2101774 77 70 79   483911.7 2380112.5     137.4 1 1 6 1      11.2      89.5
A         35089.0 50357.016 9 75   1   2111674 77 70 79  484062 2380112.5     136.4 2 1 6 1      11.3      87.0
A         35089.0 50369.016 9 75   1   2 91574 77 69 81   484212.8 2380111.2     136.4 3 1 6 1      11.2      89.5
A         35089.0 50381.016 9 75   1   2 91574 77 71 78   484361.8 2380112.2     135.2 4 1 6 1      11.3      89.0

This User Gave Thanks to RudiC For This Post:
# 9  
Old 03-08-2016
RudiC,

Great,, Thanks a lot it is wonderful.. works perfect.

Thanks again
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calculate the average per block.

My old school way is a one liner. And will search for average from SAR, to get the data receive rate. But, I dont think it is practical or accurate,. Because it calculates to off peak hours. I am planning to change it. My cron runs every 30 mins. When my cron runs, and my time is 14:47pm,, it will... (1 Reply)
Discussion started by: invinzin21
1 Replies

2. Shell Programming and Scripting

Calculate average for repeated ID within a data

I have an awk script that gives the following output: Average end-to-end transmission delay 2.7 to 5.7 is 0.635392 seconds Average end-to-end transmission delay 2.1 to 5.1 is 0.66272 seconds Average end-to-end transmission delay 2.1 to 5.1 is 0.691712 seconds Average end-to-end transmission... (4 Replies)
Discussion started by: ENG_MOHD
4 Replies

3. Shell Programming and Scripting

Calculate Average AWK

I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall: Example file: File 1 001 0.046 0.667267 001 0.047 0.672028 001 0.048 0.656025 001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies

4. Shell Programming and Scripting

AWK novice - calculate the average

Hi, I have the following data in a file for example: P1 XXXXXXX.1 YYYYYYY.1 ZZZ.1 P1 XXXXXXX.2 YYYYYYY.2 ZZZ.2 P1 XXXXXXX.3 YYYYYYY.3 ZZZ.3 P1 XXXXXXX.4 YYYYYYY.4 ZZZ.4 P1 XXXXXXX.5 YYYYYYY.5 ZZZ.5 P1 XXXXXXX.6 YYYYYYY.6 ZZZ.6 P1 XXXXXXX.7 YYYYYYY.7 ZZZ.7 P1 XXXXXXX.8 YYYYYYY.8 ZZZ.8 P2... (6 Replies)
Discussion started by: alex2005
6 Replies

5. Shell Programming and Scripting

Calculate distance and azimuth

Hi all, I have a data file like this lat lon lat lon 12.000 25.125 14.235 25.012 14.200 81.000 25.584 25.014 45.023 25.365 25.152 35.222 I want to calculate distance and azimuth between this points eg:- 12.000,25.125 and 14.235,25.012 I want to use awk programming... (3 Replies)
Discussion started by: chamara
3 Replies

6. Programming

Converting distance list to distance matrix in R

Hi power user, I have this type of data (distance list): file1 A B 10 B C 20 C D 50I want output like this # A B C D A 0 10 30 80 B 10 0 20 70 C 30 20 0 50 D 80 70 50 0 Which is a distance matrix I have tried... (0 Replies)
Discussion started by: anjas
0 Replies

7. Programming

calculate average

I have a file which is 2 3 4 5 6 6 so i am writing program in C to calculate mean.. #include<stdio.h> #include<string.h> #include <math.h> double CALL mean(int n , double x) main (int argc, char **argv) { char Buf,SEQ; int i; double result = 0; FILE *fp; (3 Replies)
Discussion started by: cdfd123
3 Replies

8. Shell Programming and Scripting

program to calculate distance between 5 atoms

Hello, I am a beginner with perl. I have a perl program to calculate the distance between 5 atoms or more. i have an array which looks like this: 6.324 32.707 50.379 5.197 32.618 46.826 4.020 36.132 46.259 7.131 38.210 45.919 6.719 38.935 42.270 2.986 39.221 ... (1 Reply)
Discussion started by: annie_singh
1 Replies

9. UNIX for Dummies Questions & Answers

Use awk to calculate average of column 3

Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies

10. UNIX for Dummies Questions & Answers

calculate average of column 2

Hi I have fakebook.csv as following: F1(current date) F2(popularity) F3(name of book) F4(release date of book) 2006-06-21,6860,"Harry Potter",2006-12-31 2006-06-22,,"Harry Potter",2006-12-31 2006-06-23,7120,"Harry Potter",2006-12-31 2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Discussion started by: onthetopo
0 Replies
Login or Register to Ask a Question