BEGIN {FS=","; OFS=" & "; Scale=2; print "\\begin{tabular}{|rr|r@{~}r@{~}l}\\cline{1-2}"; } {sub(/ID/,"rank"); gsub(/%/,"\\%"); gsub(/deltas/,"compare"); sub(//,"$>$"); sub(/\#rx/,"method"); } NR==1 { print $3,$9,"","","\\\\\\cline{1-2}"; next; } { bar1 = $8 - $7; bar2 = $11 - $10; print $3,$9,-100 "\\%","\\boxplot{"s($7 + 100)"}{"s(bar1)"}{"s(100 + $9)"}{"s($10+100)"}{"s(bar2)"}&100\\%\\\\"; } END { print "\\cline{1-2}\\end{tabular}" } function s(x) {return int(x/Scale) }