#!/usr/bin/gawk -f

BEGIN {
	line=1;
	line2=1;

	while(getline x < F) {
		split(x, lines,",");
		##if(line2%2==1) {
			datas[line,0]=line;
			datas[line,1]=lines[1];
			datas[line,2]=lines[2];
		##}
		##else {
		##	datas[line,3]=lines[1];
		##	datas[line,4]=lines[2];
		##	datas[line,5]=lines[3];
		##	datas[line,6]=lines[4];
			line++;
		##}

		##line2++;
	}

	line3=0;
	close(F);

	while(getline y < G) {
		split(y, lines2, ",");
		if(line3>0) {
			datas[line3,7]=lines2[4];
			datas[line3,8]=lines2[5];
			datas[line3,9]=lines2[6];
			datas[line3,10]=lines2[7];
		}
		line3++;
	}

	print "#era cost attain medcostK cspreadK medattK aspreadK";

	for(i=1;i<line3;i++)
	{
		if(i<(line-1)) {
			print datas[i,0]" "datas[i,1]" "datas[i,2]" "datas[i,7]" "datas[i,8]" "datas[i,9]" "datas[i,10];
		}
		else {
			print i" "datas[(line-2),1]" "datas[(line-2),2]" "datas[i,7]" "datas[i,8]" "datas[i,9]" "datas[i,10];
		}
	}
	close(G);
}