ref: debb5dccc7b87c897de9d6167e8af3e7e4b8fbb8
dir: /bin/formatdata.awk/
#!/bin/awk -F '\t' -f
BEGIN {
print ".TS"
print "expand linesize(5);"
print "l l l l l"
print "l n n n n"
print "."
print "_"
printf "Name\tCount\tPrice\tTax\tTotal\n"
print "="
}
!/^#/ && NF >= 4 {
number = $1
single = $2
vat = $3
name = $4
total = number * single
vats[vat] += total
final += total
vv = "\\R-"
if (vat > 0)
vv = sprintf("%.2f %%", vat);
printf "%s\t%.2f\t%.2f\t%s\t%.2f EUR\n", name, number, single, vv, total
}
END {
print "_"
# net sum
printf "Sum\t\t\t\t%.2f EUR\n", final
print "_"
for (i in vats) {
if (i == 0)
continue;
v = vats[i] * i / 100.
printf "VAT / MwSt. %.2f %%\t\t\t\t%.2f EUR\n", i, v
final += v
}
print "_"
print ".B"
printf "Total\t\t\t\t%.2f EUR\n", final
print "_"
print ".TE"
}