<HTML><HEAD><TITLE>XML DOM Scripting</TITLE>
<XML ID="BaseballSource" SRC="MVP.xml"></XML>
<SCRIPT>
function AvgStat(Doc, Which)
    {
    var Total = 0;
    var PlayerCount = 0;
    var Hits = 0;
    var AtBats = 0;
    var Highest = 0;
    var Lowest = 1;
    var HighestLastName = "";
    var HighestFirstName = "";
    var LowestLastName = "";
    var LowestFirstName = "";

    var Player = Doc.documentElement.firstChild;
    while (Player != null)
        {
        Hits = parseInt(Player.selectSingleNode("hits").text)
        AtBats = parseInt(Player.selectSingleNode("atbats").text)
        LastName = Player.selectSingleNode("last").text
        FirstName = Player.selectSingleNode("first").text

        if (AtBats != 0)
            {
            Avg = Hits / AtBats;
            if (Avg > Highest)
                {
                Highest = Avg;
                HighestFirstName = FirstName;
                HighestLastName = LastName;
                }
            if (Avg < Lowest)
                {
                Lowest = Avg;
                LowestFirstName = FirstName;
                LowestLastName = LastName;
                }
            }
        else
            Avg = 0

        Total += Avg
        Player = Player.nextSibling;
        PlayerCount++;
        }
    if (Which == "avg")
        return Total/PlayerCount;
    else if (Which == "high")
        return HighestFirstName + " " + HighestLastName + " hit " + Highest;
    else if (Which == "low")
        return LowestFirstName + " " + LowestLastName + " hit " + Lowest;
    }

var NameArray = new Array();
var TeamArray = new Array();
var YearArray = new Array();

function LoadArrays(Doc)
    {
    var Count = 0;
    var LastName;

    var Player = Doc.documentElement.firstChild;
    while (Player != null)
        {
        LastName = Player.selectSingleNode("last").text
        FirstName = Player.selectSingleNode("first").text
        Team = Player.selectSingleNode("team").text
        Year = Player.selectSingleNode("year").text

        NameArray[Count] =  "<TD>" + LastName + ", " + FirstName + "</TD>"
        NameArray[Count] += "<TD>" + Team + "</TD>"
        NameArray[Count] += "<TD>" + Year + "</TD>"
        TeamArray[Count] =  "<TD>" + Team + "</TD>"
        TeamArray[Count] += "<TD>" + LastName + ", " + FirstName + "</TD>"
        TeamArray[Count] += "<TD>" + Year + "</TD>"
        YearArray[Count] = "<TD>" + Year + "</TD>"
        YearArray[Count] += "<TD>" + LastName + ", " + FirstName + "</TD>"
        YearArray[Count] +=  "<TD>" + Team + "</TD>"
        Count++;
        Player = Player.nextSibling;
        }
    }

function SortStats(How)
    {
    var Result = "";
    var Prev = "";

    Result += "<TABLE>"

    if (How == "player")
        {
        NameArray.sort();
        for (i = 0; i < NameArray.length; i++)
            {
            Result += "<TR>" + NameArray[i] + "</TR>"
            Prev = NameArray[i];
            }
        }

    if (How == "team")
        {
        TeamArray.sort();
        for (i = 0; i < TeamArray.length; i++)
            {
            Result += "<TR>" + TeamArray[i] + "</TR>"
            Prev = TeamArray[i];
            }
        }

    if (How == "year")
        {
        YearArray.sort();
        for (i = 0; i < YearArray.length; i++)
            {
            Result += "<TR>" + YearArray[i] + "</TR>"
            Prev = YearArray[i];
            }
        }

    Result += "</TABLE>"
    return Result;
    }
</SCRIPT>
</HEAD>
<BODY STYLE="font-family:Verdana;" ONLOAD="LoadArrays(BaseballSource)">

<TABLE><TR>
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Highest Avg" ONCLICK="ResultDiv.innerHTML = 'Highest Average: ' + AvgStat(BaseballSource, 'high')"/>
&nbsp;
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Lowest Avg" ONCLICK="ResultDiv.innerHTML = 'Lowest Average: ' + AvgStat(BaseballSource, 'low')"/>
&nbsp;
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Average Avg" ONCLICK="ResultDiv.innerHTML = 'Average Average: ' + AvgStat(BaseballSource, 'avg')"/>
</TR><TR>
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Sort by Player" ONCLICK="ResultDiv.innerHTML = SortStats('player')"/>
&nbsp;
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Sort by Team" ONCLICK="ResultDiv.innerHTML = SortStats('team')"/>
&nbsp;
<TD ALIGN=CENTER><INPUT TYPE=BUTTON VALUE="Sort by Year" ONCLICK="ResultDiv.innerHTML = SortStats('year')"/>
</TR></TABLE>
<BR>
<DIV ID=ResultDiv></DIV>
</BODY>
</HTML>