FreeTstar

BEGIN{

printf "\t\t\t     ***FIRST QUARTERLY REPROT***\t\t\t\n"

printf "\t\t\t   ***CAMPAIGN  1998  CONTRIBUTIONS***\t\t\t\n"

printf "————————————————————————————–\n"

printf "NAME\t\t\t    PHONE\t\tJan  |   Feb   |  Mar    |  Total.Donated\n"

printf "————————————————————————————–\n"

FS="[ :]"

}

#compute the max donation and donor's name

#print the donate status

#print the average

#put the record into the matrix

{

while(count<NR){count++;$8=$5+$6+$7;sum+=$8;if($8>max){max=$8;name=$1}}

printf "%-10s %10s    %s %s    %6.2f    %6.2f     %6.2f      %6.2f \n",$1,$2,$3,$4,$5,$6,$7,$5+$6+$7

average=int(sum/1200)*100

for(i=1;i<=4;i++)

{

if($8>500) matrix[NR,i] = $i

}

}

END{

printf "—————————————————————————————\n"

printf "\t\t\t\t\t\ SUMMARY \t\t\t\t\t\t\t\n"

printf "—————————————————————————————\n"

printf "THe campaign recevied a total of $%6.2f for this quaiter\n",sum

printf "The average donation for the 12 contributions was $%6.2f\n",sum/12

printf "The highest total contribution was %6.2f made by %s \n ", max,name

printf "                      ***THANKS %s ***         \n",name

printf "The following people donated over $%6.2f to the campaign\n",average

printf "They are eligible for the quarterly drawing \n"

printf "Listed are their names (sorted by last names) and phone numbers:\n"

for(i=1;i<=NR;i++)

{

for(j=1;j<=4;j++)

{

if(matrix[i,j]) printf " %s", matrix[i,j]

if(matrix[i,j] && j==2) printf "–"

if(matrix[i,j] && j==4) printf "\n"

}

}

printf "\t\t Thanks to all of you for your continued support!!\n"

}