#!/bin/sh

awk '{print $3}' < olddatabase.txt \
| sort \
| uniq -c \
| sort -rn \
| awk '{if (num == 0 || $1 == num) { num = $1; print "cipher "$2 }}' \
| cat - olddatabase.txt \
| awk '
  /^cipher / { wantcipher[$2] = 1; next }
  { if ($3 in wantcipher) { q[$2] += log($4); qnum[$2] += 1 } }
  END { for (i in q) print "machinespeed",i,exp(q[i]/qnum[i]) }
' \
| sort -n +2 > machinespeed.txt