gistfile1.txt

for job in $(sacct -a -X --start now-24hours -o jobid,State|grep COMPL|cut -f1 -d' '); do
seff -d $job | awk '
   NR==2 {
   jobID=$3;
   user=$4;
   reqmemGB=$11/1024/1024;
   memGB=$15/1024/1024;
   efficiency=(memGB/reqmemGB)*100;
   printf "%s\t%s\t%.0f%%\t%.0f/%.0f\n", jobID, user, efficiency, memGB, reqmemGB}'
done \
| sort -k3,3n | column -t

$ ./dailyseff
314023  mhalko    77%   6/8
314005  mhalko    81%   6/8
314016  mhalko    83%   7/8
314032  mhalko    84%   7/8
314020  mhalko    85%   7/8
314002  mhalko    87%   7/8
314212  mkuhn     87%   14/16
314213  mkuhn     87%   14/16
314214  mkuhn     87%   14/16
314215  mkuhn     87%   14/16
314218  mkuhn     87%   14/16
314219  mkuhn     87%   14/16
314220  mkuhn     87%   14/16
314222  mkuhn     87%   14/16
314223  mkuhn     87%   14/16
314224  mkuhn     87%   14/16
314225  mkuhn     87%   14/16
314226  mkuhn     87%   14/16
314228  mkuhn     87%   14/16
314006  mhalko    88%   7/8
314210  kclancy   91%   7/8
313999  mhalko    93%   7/8
313947  ebelleau  95%   15/16
314024  mhalko    95%   8/8
314009  mhalko    96%   8/8
314027  mhalko    97%   8/8
314019  mhalko    98%   8/8
314028  mhalko    101%  8/8
313998  mhalko    102%  8/8
314217  jsneider  102%  16/16
314025  mhalko    104%  8/8
314001  mhalko    109%  9/8
314035  mhalko    109%  9/8
314030  mhalko    112%  9/8
314216  jsneider  114%  18/16