var xmlDoc=null;
var error = "";
var file = "http://www.shoppingconsortium.co.uk/data/school_data.xml";
try //Internet Explorer
{
 xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
 xmlDoc.async=false;
 xmlDoc.load(file);
}
catch(ett)
{
 try //Firefox, Mozilla, Opera, etc.
 {
  xmlDoc=document.implementation.createDocument("","",null);
  xmlDoc.async=false;
  xmlDoc.load(file);
 }
 catch(ett)
 {
  try //Google Chrome
  {
   var xmlhttp = new window.XMLHttpRequest();
   xmlhttp.open("GET",file,false);
   xmlhttp.send(null);
   xmlDoc = xmlhttp.responseXML.documentElement;
  }
  catch(ett)
  {
   error=ett.message;
  }
 }
}
var totalFunds = 0;
var x=xmlDoc.getElementsByTagName("Row");
for (i=0;i<x.length;i++)
{
if (x[i].hasChildNodes())
{
var fundsRaised = x[i].getElementsByTagName("FUNDS_RAISED")[0].childNodes[0].nodeValue;
if (fundsRaised){
var totalFunds = totalFunds + parseFloat(fundsRaised);
}
}
}

var totalResult=Math.round(totalFunds*100)/100;
// paste this on page to display result:
// document.write("&pound;<strong>"+totalResult+"</strong>");