#!/bin/sh

while read x machine trunk
do
  cat trunk-$trunk/reports-$machine/index.html \
  | grep '<td class=.name' \
  | sed 's/<a /<a_/g' \
  | sed 's/<td /<td_/g' \
  | sed 's/<tr /<tr_/g' \
  | sed 's/^ *//' \
  | sed 's/ /$/g' \
  | sed 's/,/_/g' \
  | sed 's/<\/td/,</g' \
  | sed 's/<[^>]*>//g' \
  | awk -F, '
    BEGIN { OFMT="%.2f" }
    {
      what=$3"."$1
      if (!(what in done)) {
        done[what] = 1
        print "cipher40k","'$machine'",what,$7+$12/40+0.00001
        print "cipher40","'$machine'",what,$7+0.00001
        print "cipher576","'$machine'",what,$8+0.00001
        print "cipher1500","'$machine'",what,$9+0.00001
        print "cipheragility","'$machine'",what,$11+0.00001
        print "cipherlong","'$machine'",what,$6+0.00001
      }
    }
  ' \
  | tr -cd '[A-Z][a-z][0-9].\012 '
done < machines.txt > olddatabase.txt