//=IF(F6=2,1.78,IF(F6=3,1.81,IF(F6=4,1.91,IF(F6=5,1.64,IF(F6=6,1.9,IF(F6=7,1.86,IF(F6=8,1.55,IF(F6=9,1.71,1))))))))
var arrAggregateType1 = new Array(1,1.78,1.81,1.91,1.64,1.9,1.86,1.55,1.71,1,1,1,1,1);
//=IF(F6=10,1.75,IF(F6=11,1.51,IF(F6=12,1.76,IF(F6=13,1.8,IF(F6=14,1.68,1)))))
var arrAggregateType2 = new Array(1,1,1,1,1,1,1,1,1,1.75,1.51,1.76,1.8,1.68);
//=IF(B6,IF(F6=2,B6*1000,IF(F6=3,B6*10,IF(F6=4,(B6*0.3048)*1000,IF(F6=5,(B6*0.9144)*1000,IF(F6=6,B6*25.4))))))
var arrConvert = new Array(1000,10,1000*0.3048,1000*0.9144,25.4);
$(document).ready(function()
{
	if($("#Length_number").length > 0 && $("#AggregateType").length == 0)
	{
	$("#Length").change(function(){
		setSum();
	});
	$("#Width").change(function(){
		setSum();
	});
	$("#Depth").change(function(){
		setSum();
	});
	$("#Length_number").change(function(){
		setSum();
	});
	$("#Width_number").change(function(){
		setSum();
	});
	$("#Depth_number").change(function(){
		setSum();
	});
	setSum();
}
});

function setSum()
{
	if($("#Length_number").length > 0 && $("#AggregateType").length == 0)
	{
	var Length_number = $("#Length_number").val();
	var Width_number = $("#Width_number").val();
	var Depth_number = $("#Depth_number").val();
	
	var indexLength = $("#Length").get(0).selectedIndex;
	var Length = arrConvert[indexLength]*Length_number;
	
	var indexWidth = $("#Width").get(0).selectedIndex;
	var Width = arrConvert[indexWidth]*Width_number;
	
	var indexDepth = $("#Depth").get(0).selectedIndex;
	var Depth = arrConvert[indexDepth]*Depth_number;
	
	
	//=IF(F10=2,(H6*H8*H10),IF(F10=3,(H6*H8*H10),IF(F10=4,(H6*H8*H10),IF(F10=5,(H6*H8*H10),IF(F10=6,(H6*H8*H10),IF(F10=7,(H6*H8)))))))
	var temp1= 0;
	if(indexDepth == 5) temp1 = Length*Width;
	else temp1 = Length*Width*Depth;
	
	//=IF(F10=2,ROUNDUP((H12/1000000000),0),IF(F10=3,ROUNDUP((H12/1000000000),0),IF(F10=4,ROUNDUP((H12/1000000000),0),IF(F10=5,ROUNDUP((H12/1000000000),0),IF(F10=6,ROUNDUP((H12/1000000000),0),IF(F10=7,ROUNDUP((H12/1000000),0)))))))
	
	var rst = 0;
	if(indexDepth == 5) rst =  roundup((temp1/1000000),0);
	else rst = roundup((temp1/1000000000),0);
	$("#span_result").html(rst);
	}
}

function  roundup(n,f){ 
    n   =   n   *   Math.pow(10,f); 
    n   =   Math.ceil(n)   /   Math.pow(10,f); 
    return   n; 
}