BEGIN { print("Day Air SST T10 T20 T40 T60 T80 T100 T150 T200 T250 T300"); } (! /^#/ ) { newday = int($1); if ( (newday != day) && (day != 0) ) { printf("%3d", day); for ( i = 0; i < 12; i++ ) { printf( " %6.3f", temp[i]/samples[i] ); temp[i] = 0.0; samples[i] = 0; } printf("\n"); } day = newday; for ( i = 0; i < 12; i++ ) if ( $(i+3) > 0.5 ) { temp[i] += $(i+3); samples[i]++; } } END { printf("%3d", day); for ( i = 0; i < 12; i++ ) printf( " %6.3f", temp[i]/samples[i] ); printf("\n"); }