#!/bin/sh

gawk '
@include "scripts/getcls.awk"

BEGIN {
	FS = "\t"
}

$1 == "TN" {
	i++
	col[i][0] = $2
	col[i][1] = $3
	col[i][2] = $4
}

END {
	for (i = 1; i <= length(col); i++) {
		printf "trX {td .missing colspan=\"1\" {-€%s}"\
			"td .%s colspan=\"6\" {-%s}}\n",
			col[i][0], getcls(col[i][2]), col[i][1]
	}
	print "__MARKER__"
}
' data/notes \
| scripts/last-of-design.sed