BEGIN {MaxL= MaxD = -10000000 What=2 MinL = MinD = 100000000} Pass==1 && /^[0-9]/ && NF==3 {$What = $What > 0 ? $What : 0; Dall += $1 Lall += $3 MaxD = $What > MaxD ? $What : MaxD MinD = $What < MinD ? $What : MinD MaxL = $3 > MaxL ? $3 : MaxL MinL = $3 < MinL ? $3 : MinL} Pass==2 && /^[0-9]/ && NF==3 {$What = $What > 0 ? $What : 0; D=($What - MinD)/(MaxD-MinD) L=($3 - MinL)/(MaxL-MinL) #Alpha = What==2 ? 0 : 1 Alpha = 1 Beta=3 Pos= sqrt(Alpha*D^2 + Beta*(1-L)^2)/sqrt(Alpha+Beta) OFS=","; print $1,$2,$3, Pos, Dall,Lall| "sort -t, -r -n -k 4" }