#!/usr/bin/gawk -f BEGIN { FS = OFS = ",";} NR == 1 { name="rely"; table[name,0]=0; table[name,1]=0.82; table[name,2]=0.92; table[name,3]=1.00; table[name,4]=1.10; table[name,5]=1.26; table[name,6]=0; name="data"; table[name,0]=0; table[name,1]=0; table[name,2]=0.90; table[name,3]=1.00; table[name,4]=1.14; table[name,5]=1.28; table[name,6]=0; name="cplx"; table[name,0]=0; table[name,1]=0.73; table[name,2]=0.87; table[name,3]=1.00; table[name,4]=1.17; table[name,5]=1.34; table[name,6]=1.74; name="ruse"; table[name,0]=0; table[name,1]=0; table[name,2]=0.95; table[name,3]=1.00; table[name,4]=1.07; table[name,5]=1.15; table[name,6]=1.24; name="docu"; table[name,0]=0; table[name,1]=0.81; table[name,2]=0.91; table[name,3]=1.00; table[name,4]=1.11; table[name,5]=1.23; table[name,6]=0; name="time"; table[name,0]=0; table[name,1]=0; table[name,2]=0; table[name,3]=1.00; table[name,4]=1.11; table[name,5]=1.29; table[name,6]=1.63; name="stor"; table[name,0]=0; table[name,1]=0; table[name,2]=0; table[name,3]=1.00; table[name,4]=1.05; table[name,5]=1.17; table[name,6]=1.46; name="pvol"; table[name,0]=0; table[name,1]=0; table[name,2]=0.87; table[name,3]=1.00; table[name,4]=1.15; table[name,5]=1.30; table[name,6]=0; name="acap"; table[name,0]=0; table[name,1]=1.42; table[name,2]=1.19; table[name,3]=1.00; table[name,4]=0.85; table[name,5]=0.71; table[name,6]=0; name="pcap"; table[name,0]=0; table[name,1]=1.34; table[name,2]=1.15; table[name,3]=1.00; table[name,4]=0.88; table[name,5]=0.76; table[name,6]=0; name="pcon"; table[name,0]=0; table[name,1]=1.29; table[name,2]=1.12; table[name,3]=1.00; table[name,4]=0.90; table[name,5]=0.81; table[name,6]=0; name="apex"; table[name,0]=0; table[name,1]=1.22; table[name,2]=1.10; table[name,3]=1.00; table[name,4]=0.88; table[name,5]=0.81; table[name,6]=0; name="plex"; table[name,0]=0; table[name,1]=1.19; table[name,2]=1.09; table[name,3]=1.00; table[name,4]=0.91; table[name,5]=0.85; table[name,6]=0; name="ltex"; table[name,0]=0; table[name,1]=1.20; table[name,2]=1.09; table[name,3]=1.00; table[name,4]=0.91; table[name,5]=0.84; table[name,6]=0; name="tool"; table[name,0]=0; table[name,1]=1.17; table[name,2]=1.09; table[name,3]=1.00; table[name,4]=0.90; table[name,5]=0.78; table[name,6]=0; name="site"; table[name,0]=0; table[name,1]=1.22; table[name,2]=1.09; table[name,3]=1.00; table[name,4]=0.93; table[name,5]=0.86; table[name,6]=0.80; name="sced"; table[name,0]=0; table[name,1]=1.43; table[name,2]=1.14; table[name,3]=1.00; table[name,4]=1.00; table[name,5]=1.00; table[name,6]=0; #Scale factors: name="prec"; table[name,0]=0; table[name,1]=6.20; table[name,2]=4.96; table[name,3]=3.72; table[name,4]=2.48; table[name,5]=1.24; table[name,6]=0; name="flex"; table[name,0]=0; table[name,1]=5.07; table[name,2]=4.05; table[name,3]=3.04; table[name,4]=2.03; table[name,5]=1.01; table[name,6]=0; name="resl"; table[name,0]=0; table[name,1]=7.07; table[name,2]=5.65; table[name,3]=4.24; table[name,4]=2.83; table[name,5]=1.41; table[name,6]=0; name="team"; table[name,0]=0; table[name,1]=5.48; table[name,2]=4.38; table[name,3]=3.29; table[name,4]=2.19; table[name,5]=1.01; table[name,6]=0; name="pmat"; table[name,0]=0; table[name,1]=7.80; table[name,2]=6.24; table[name,3]=4.68; table[name,4]=3.12; table[name,5]=1.56; table[name,6]=0; for (field = 1; field <= NF-2; field++) names[field] = $field; print $0; } NR > 1 { for (field = 1; field <= NF-2; field++) printf("%s,",table[names[field],$field]); print $(NF-1),$NF; }