var prefix = "/allegati/gas/bonus/";

		//Nomi dei file contenenti i dati
  		var fileProvincie   = prefix + "provincie.csv";
  		var fileZone        = prefix + "zoneClimatiche.csv";
  		var fileConsumi     = prefix + "consumi.csv";
		var fileConsumi2012     = prefix + "consumi2012.csv";
  		var fileConsumi2009 = prefix + "consumi2009.csv";
		var fileConsumi2010 = prefix + "consumi2010.csv";

  		//Array dove vengono caricati i dati letti
  		var arrayZC= new Array();
  		var arrayConsumi= new Array();
  		var arrayConsumi2009 = new Array();
		var arrayConsumi2010 = new Array();

  		//Funzione che carica i dati dai file CSV
	  	function loadCsvData() {
	  		    jQuery.get(fileProvincie,   function(data) { arrayProvincie   = jQuery.csv(";")(data); caricaProvincie(arrayProvincie);});
				jQuery.get(fileZone,        function(data) { arrayZC          = jQuery.csv(";")(data); });
				jQuery.get(fileConsumi2012,     function(data) { arrayConsumi2012     = jQuery.csv(";")(data); });

				jQuery.get(fileConsumi,     function(data) { arrayConsumi     = jQuery.csv(";")(data); });
				jQuery.get(fileConsumi2009, function(data) { arrayConsumi2009 = jQuery.csv(";")(data); });
				jQuery.get(fileConsumi2010, function(data) { arrayConsumi2010 = jQuery.csv(";")(data); });
			}
			

			//Funzione che effettua i calcoli ed imposta i dati nella pagina
	  	function calcola() {
  			//Cerca il tolale consumi
	  		var chiaveConsumi = "";
			totConsumi0     = 0;
			totConsumi00     = 0;
			totConsumi000     = 0;

	  		totConsumi1     = 0;
	  		totConsumi2     = 0;
	  		totConsumi3     = 0;
	  		totConsumi12009 = 0;
	  		totConsumi22009 = 0;
	  		totConsumi32009 = 0;
	  		totConsumi12010 = 0;
	  		totConsumi22010 = 0;
	  		totConsumi32010 = 0;
	  		zona = document.formZoneClimatiche.comune[document.formZoneClimatiche.comune.selectedIndex].value;
	  		chiaveConsumi = zona + document.formZoneClimatiche.componenti[document.formZoneClimatiche.componenti.selectedIndex].value;

	  		for (i = 0; i < arrayConsumi2012.length; i++) {
		  		if (arrayConsumi2012[i][0] == chiaveConsumi) {
		  			totConsumi0   = parseInt(arrayConsumi2012[i][1]);
		  			totConsumi00   = parseInt(arrayConsumi2012[i][2]);
		  			totConsumi000   = parseInt(arrayConsumi2012[i][3]);

		  			totConsumi1     = parseInt(arrayConsumi[i][1]);
	  				totConsumi2     = parseInt(arrayConsumi[i][2]);
	  				totConsumi3     = parseInt(arrayConsumi[i][3]);
		  			totConsumi12009 = parseInt(arrayConsumi2009[i][1]);
	  				totConsumi22009 = parseInt(arrayConsumi2009[i][2]);
	  				totConsumi32009 = parseInt(arrayConsumi2009[i][3]);
		  			totConsumi12010 = parseInt(arrayConsumi2010[i][1]);
	  				totConsumi22010 = parseInt(arrayConsumi2010[i][2]);
	  				totConsumi32010 = parseInt(arrayConsumi2010[i][3]);
		  		}
	  		}

  			usoGas = document.formZoneClimatiche.usoGas[document.formZoneClimatiche.usoGas.selectedIndex].value;
  			if (usoGas == 1) {
				totConsumi00    = 0;
  				totConsumi2     = 0;
  				totConsumi22009 = 0;
				totConsumi22010 = 0;
  			}	else if (usoGas == 2) {
				totConsumi0 	= 0;
  				totConsumi1     = 0;
  				totConsumi12009 = 0;
				totConsumi12010 = 0;
  			}
  			
			document.formZoneClimatiche.zona.value = zona;
			document.formZoneClimatiche.tot0.value	=totConsumi0;
			document.formZoneClimatiche.tot00.value	=totConsumi00;
			document.formZoneClimatiche.tot000.value	=totConsumi00 + totConsumi0;
  			
  			document.formZoneClimatiche.tot1.value     = totConsumi1;
  			document.formZoneClimatiche.tot2.value 	   = totConsumi2;
  			document.formZoneClimatiche.tot3.value 	   = totConsumi2 + totConsumi1;
  			document.formZoneClimatiche.tot12009.value = totConsumi12009;
  			document.formZoneClimatiche.tot22009.value = totConsumi22009;
  			document.formZoneClimatiche.tot32009.value = totConsumi22009 + totConsumi12009;
  			document.formZoneClimatiche.tot12010.value = totConsumi12010;
  			document.formZoneClimatiche.tot22010.value = totConsumi22010;
  			document.formZoneClimatiche.tot32010.value = totConsumi22010 + totConsumi12010;

			}

			function caricaProvincie(arrayProvincie) {
	  		for (i = 0; i < arrayProvincie.length; i++) {
				  	appendOptionLast(document.formZoneClimatiche.provincie,arrayProvincie[i][0],arrayProvincie[i][1]);
	  		}
	  		sortOptions(document.formZoneClimatiche.provincie);
	  		document.formZoneClimatiche.provincie.selectedIndex = -1;
			}

			function caricaComuni() {
				document.formZoneClimatiche.comune.length = 0;
	  		//Cerca il comune ed imposta la zona
	  		for (i = 0; i < arrayZC.length; i++) {
	  			if (arrayZC[i][3].toUpperCase() == document.formZoneClimatiche.provincie[document.formZoneClimatiche.provincie.selectedIndex].value) {
	  				appendOptionLast(document.formZoneClimatiche.comune,arrayZC[i][7],arrayZC[i][4]);
	  			}
	  		}
	  		document.formZoneClimatiche.comune.selectedIndex = -1;
	  		document.formZoneClimatiche.zona.value = "";
  			document.formZoneClimatiche.tot0.value = "";
  			document.formZoneClimatiche.tot00.value = "";
  			document.formZoneClimatiche.tot000.value = "";

  		}

			function appendOptionLast(elSel,valore,testo)
			{
			  var elOptNew = document.createElement('option');
			  elOptNew.text = testo;
			  elOptNew.value = valore;

			  try {
			    elSel.add(elOptNew, null); // standards compliant; doesn't work in IE
			  }
			  catch(ex) {
			    elSel.add(elOptNew); // IE only
			  }
			}

			function compareOptionText(a,b) {
				return a.text!=b.text ? a.text<b.text ? -1 : 1 : 0;
			}

			function sortOptions(list) {
				var items = list.options.length;
				// create array and make copies of options in list
				var tmpArray = new Array(items);
				for ( i=0; i<items; i++ )
					tmpArray[i] = new Option(list.options[i].text,list.options[i].value);
				// sort options using given function
				tmpArray.sort(compareOptionText);
				// make copies of sorted options back to list
				for ( i=0; i<items; i++ )
					list.options[i] = new Option(tmpArray[i].text,tmpArray[i].value);
			}