#!/bin/sh

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