On Sunday, December 3, 2017, 9:48:17 PM CST, Jon LaBadie <jonfu@jgcomp.com> wrote:

Antonio,

Do you have control over the contents (format) of the data?
Here that would be "Soccer.dat".

If yes I'd suggest a format change.  Separate the goals with
dashes (-) or commas (,) or whatever, just no something that
makes you think of them as numbers but as strings to be
converted to numbers later.

Assuming you used dashes teams 2 and 8 would be:

    Team2 1 1-2
    Team8 2-0-1 2-0-3

Your code could then use split(...) to put the goal counts into
an array.  For example.

    split($2, GF, "-")
    split($3, GA, "-")

You would now have two arrays GF (Goals For) with up to 3 elements.
The first would be regulation, second overtime, third penalty kicks.
And of course the same for GA.

This would also eliminate a potential, but very rare problem,
Some team scores 10 goals in overtime.  Your scheme would make
it look like 1 goal and 0 penalty kicks.

Jon

On Sun, Dec 03, 2017 at 12:46:16PM +0000, Antonio Olivares wrote:
> Dear Fedora users,
>
> I have a question regarding a set of data and an awk script that performs some actions, it calculates a GF(goals in favor) GA(goals against), and PTS for each game.  Suppose the data is as follows:
>
> Soccer.dat
> Team. GF GA
> Team1 1 2
> Team2 1 1.2
> Team3 2 4
> Team4 3 0
> Team5 4 0
> Team6 3 2
> Team7 1 3
> Team8 2.01 2.03
> Team9 3.03 3.04
> Team10 0 7
> Team11 0.1 0.3
>
> In district play, if a team wins in regulation they earn 3 pts, if you lose 0 pts, if both teams tie in regulation, they play overtime, if they are still tied then penalty kicks decide the outcome of the game.  The winners in OT/PKS get 2 pts, the loser get 1 pt. 
>
> In Team2 we tied at 1 in regulation, but in OT, the other team scored 2 goals and beat us 3 to 1.  The awk script attached inline calculates this, but outputs 1 2 when it should output 1 3.  If there is another number in the hundredths place is we shot penalty kicks.  I cannot copy the awk script.  I will have to attach it.  I would like to improve it by tallying a running total per column of GF GA PTS .  Ideas are appreciated. 
>
> The awk script creates a new integer from the decimal number given.  The integer part and the fractional part are used to create the new numbers that end up in GF and GA. 
>
> In one case when I put 1 1.2 the output should be 1 3 but it gives me 1 2.  This is one of my questions.  On the other hand if I put 0.1 and 0.3 it outputs 1 to 3 correctly.  Do I have a mistake in my function?  I use int($1) to get integer part and ($1-int($1)) to get fractional part. 
>
>
> Best Regards,
>
>
> Antonio

> #!bin/sh
>
> # Check for arguments
> if [ $# -eq 0 ]; then
>    echo "Usage: $(basename $0) filename"
>    exit 1
> fi
>
> if [ ! -f $1 ]; then
>    echo "File "$1" doesn't exist!"
>    exit 0
> fi
>
> NR == 1 {
>      f[1]=-14; f[2] = f[3] = f[4] = f[5] = 3
>        printf "%-14s %-3s %-3s %-3s %-3s\n",
>        "OPPONENT", "GF", "GA", "DIF", "PTS"
> }
>
> NR >= 1 {
> F=$2+10*($2-int($2))-($2-int($2));
> A=$3+10*($3-int($3))-($3-int($3));
> tdif=F-A;
> dif=$2-$3
> difb=int($2)-int($3);
> if (dif >= 1 && int(dif) >= 1)
>    pts=3;
> else if (dif > 0 && int(difb) >= 0)
>    pts=2;
> else if (dif > -1 && int(difb) >= -1)
>    pts=1;
> else
>    pts=0; 
>        printf "%-14s %-3d %-3d %-3d %-3d \n",
>        $1, F, A, tdif, pts }' $1

> _______________________________________________
> users mailing list -- users@lists.fedoraproject.org
> To unsubscribe send an email to users-leave@lists.fedoraproject.org

>>> End of included message <<<

--
Jon H. LaBadie                  jonfu@jgcomp.com