//javascript for the calculator
function CurrencyFormatted(amount)
{
	var i = parseFloat(amount);
	if(isNaN(i)) { i = 0.00; }
	var minus = '';
	if(i < 0) { minus = '-'; }
	i = Math.abs(i);
	i = parseInt((i + .005) * 100);
	i = i / 100;
	s = new String(i);
	if(s.indexOf('.') < 0) { s += '.00'; }
	if(s.indexOf('.') == (s.length - 2)) { s += '0'; }
	s = minus + s;
	return s;
}

function isNumeric(numValue){
	var numericExpression = /^[0-9]+$/;
	if (numValue.match(numericExpression)){
		return true;
	}else{
		return false;
	}
}


function updateCalc(cellName, cellValue){
	var cellNum = cellName.split("-");
	var avgnet = 'avgnet';
	var totalnet = 'totalnet';
	var totalogrnet = 0;
	
	var totalTrays = 0;
	var exportReturn = 0;
	var averageSize = 0;
	
	//calculate total ogr net per t/e
	if (isNumeric(cellValue)){	
		totalogrnet = parseFloat(document.getElementById(avgnet + cellNum[1]).innerHTML.replace('$', '')) * parseInt(cellValue);	
		document.getElementById(totalnet + cellNum[1]).innerHTML = '$' + CurrencyFormatted(totalogrnet);
	}else{
		document.getElementById(totalnet + cellNum[1]).innerHTML = '$0.00';
	}
	
	//calculate total trays + export return
	for(i = 1; i <= 10; i++){
		//trays
		var trayQty = document.getElementById('yourtrays-' + i).value;
		//total ogr
		var runtotal = document.getElementById('totalnet' + i).innerHTML.replace('$', '');
		if (isNumeric(trayQty)){
			totalTrays += parseInt(trayQty);
			if (trayQty > 0){
				averageSize += parseInt(document.getElementById('size' + i).innerHTML) * trayQty;
			}
		}		
		exportReturn += parseFloat(runtotal);		
	}	
	document.getElementById('totaltrays').innerHTML = totalTrays;	
	document.getElementById('exportreturn').innerHTML = '$' + CurrencyFormatted(exportReturn);
	
	//calculate ave ogr t/e			
	document.getElementById('avgogr').innerHTML = '$' + CurrencyFormatted((exportReturn / totalTrays));
	///
	
	//calculate average size
	document.getElementById('averagesize').innerHTML = CurrencyFormatted((averageSize / totalTrays));
	
	
	
}








/*
for(i = 0; i < form.elements.length; i++){
		if(form.elements[i].value == "" || form.elements[i].value == " "){			
			empty++;
		}
		if (form.elements[i].name == "hp_email"){
			emailtext = form.elements[i].value;
		}
	}	
*/