//=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(F10=1,C10,IF(F10=2,C10*1000,IF(F10=3,C10*25.4,IF(F10=4,C10*304.8,IF(F10=5,C10*914.4,"N/A")))))
var arrConvert1 = new Array(1,1000,25.4,304.8,914.4);
$(document).ready(function()
{
	if($("#Length_number").length > 0  && $("#AggregateType").length > 0)
	{
	$("#AggregateType").change(function(){
		setSum1();
	});
	$("#Length").change(function(){
		setSum1();
	});
	$("#Width").change(function(){
		setSum1();
	});
	$("#Depth").change(function(){
		setSum1();
	});
	$("#Length_number").change(function(){
		setSum1();
	});
	$("#Width_number").change(function(){
		setSum1();
	});
	$("#Depth_number").change(function(){
		setSum1();
	});
	setSum1();
	}
});

function setSum1()
{
	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 = arrConvert1[indexLength]*Length_number;
	
	var indexWidth = $("#Width").get(0).selectedIndex;
	var Width = arrConvert1[indexWidth]*Width_number;
	
	var indexDepth = $("#Depth").get(0).selectedIndex;
	var Depth = arrConvert1[indexDepth]*Depth_number;
	
	var indexAggregateType = $("#AggregateType").get(0).selectedIndex;
	var AggregateType1 = arrAggregateType1[indexAggregateType];
	var AggregateType2 = arrAggregateType2[indexAggregateType];
	//=H14*H12*H10
	var temp1 = Length*Width*Depth;
	//=+H15*H6*I6
	var temp2 = temp1*AggregateType1*AggregateType2;
	var rst = parseFloat(temp2/1000000000).toFixed(1);
	$("#span_result").html(rst);
	}
}