function calculate(columnName,rowCount){
	//alert(document.workSheetForm[firstVal].value);
	var total = 0;
	for (i = 1; i<rowCount+1;i++)
	{
		if(isNaN(document.workSheetForm[columnName+i].value) || (document.workSheetForm[columnName+i].value=="") || (document.workSheetForm[columnName+i].value < 1)|| (document.workSheetForm[columnName+i].value > 5)){
			total += 0;
		} else {
			total += parseInt(document.workSheetForm[columnName+i].value);
		}
	}
	document.workSheetForm[columnName+'Total'].value = (total);
	calculateSiteSelectionTotal();
}

function calculateBudgetInitial(columnName,rowNumber){
	var total = 0;
	var multiplier = 1;
	var rate = 1;
	var forNumber = 1;
	
	if ((document.budgetPlannerForm[columnName+'Multiple'+rowNumber]) && (document.budgetPlannerForm[columnName+'Multiple'+rowNumber].value != "")) {
		multiplier = document.budgetPlannerForm[columnName+'Multiple'+rowNumber].value;
	}
	if ((document.budgetPlannerForm[columnName+'Rate'+rowNumber]) && (document.budgetPlannerForm[columnName+'Rate'+rowNumber].value != "")) {
		rate = document.budgetPlannerForm[columnName+'Rate'+rowNumber].value;
	}
	if ((document.budgetPlannerForm[columnName+'For'+rowNumber]) && (document.budgetPlannerForm[columnName+'For'+rowNumber].value != "")) {
		forNumber = document.budgetPlannerForm[columnName+'For'+rowNumber].value;
	}
	
	total += multiplier * rate * forNumber;
	
	document.budgetPlannerForm[columnName+rowNumber].value = (total);
}

function calculateBudget(columnName,rowCount){
	var total = 0;
	var summaryFixedCostsTotal = 0;
	var summaryIncomeTotal = 0;
	var multiplier = 1;
	var variableContTotal = 0;
	for (i = 1; i<rowCount+1;i++)
	{
		if ((document.budgetPlannerForm[columnName+'Multiple'+i]) && (document.budgetPlannerForm[columnName+'Multiple'+i].value != "") && !(document.budgetPlannerForm[columnName+'Rate'+i]) && !(document.budgetPlannerForm[columnName+'For'+i])) {
			multiplier = document.budgetPlannerForm[columnName+'Multiple'+i].value;
		}
		if(isNaN(document.budgetPlannerForm[columnName+i].value) || (document.budgetPlannerForm[columnName+i].value=="") || (document.budgetPlannerForm[columnName+i].value < 1)){
			total += 0;
		} else {
			total += parseInt((document.budgetPlannerForm[columnName+i].value) * multiplier);
		}
		multiplier = 1;
	}
	document.budgetPlannerForm[columnName+'Total'].value = (total);
	document.budgetPlannerForm[columnName+'SummaryTotal'].value = (total);
	
	
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.roomHireSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.officeExpensesSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.printingSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.techincalPapersSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.transportSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.guestsSummaryTotal.value);
	summaryFixedCostsTotal += parseInt(document.budgetPlannerForm.stagingSummaryTotal.value);
	
	summaryIncomeTotal += parseInt(document.budgetPlannerForm.sponsorshipTotal.value);
	
	variableContTotal += parseFloat(document.budgetPlannerForm.variableCostSummaryTotal.value * 0.1);
	
	document.budgetPlannerForm.summaryFixedCostsTotal.value = (summaryFixedCostsTotal);
	document.budgetPlannerForm.summaryIncomeTotal.value = (summaryIncomeTotal);
	document.budgetPlannerForm.summaryVariableCosts2.value = (variableContTotal);
	
}

function calculateCostPerHead(number1,number2){
	var total = 0;
	if (isNaN(number1) || number1=="" || number1 < 1 || isNaN(number2) || number2=="" || number2 < 1 || (parseInt(number1) < parseInt(number2))){
		total += 0;
	} else {
		total += parseInt(number1 / number2);
	}
	document.budgetPlannerForm.sponsorshipSummaryTotal.value = (total);
	
}

function calculateTotalVariableCosts(columnName,rowCount){
	var total = parseFloat(document.budgetPlannerForm.variableCostSummaryTotal.value) + parseFloat(document.budgetPlannerForm.summaryVariableCosts2.value);
	for (i = 3; i<rowCount+1;i++)
	{
		if((document.budgetPlannerForm[columnName+i].value=="") || (document.budgetPlannerForm[columnName+i].value < 0)){
			total += 0;
		} else {
			total += parseFloat(document.budgetPlannerForm[columnName+i].value);
		}
	}
	document.budgetPlannerForm[columnName+'SummaryTotal'].value = (total);
	
}

function calculateYesNo(columnName,rowCount){
	//alert(document.workSheetForm[firstVal].value);
	var total = 0;
	for (i = 1; i<rowCount+1;i++)
	{
		if(!isNaN(document.workSheetForm[columnName+i].value) || (document.workSheetForm[columnName+i].value=="")){
			total += 0;
		} else {
			if(document.workSheetForm[columnName+i].value.toLowerCase() == 'yes'){
				total += 1;
			} else {
				total += 0;
			}
		}
	}
	document.workSheetForm[columnName+'Total'].value = (total);
	
	calculateSiteSelectionTotal();
}

function calculateSiteSelectionTotal(){
	var total = 0;
	var venueOneOverallTotal = 0;
	var venueTwoOverallTotal = 0;
	var venueThreeOverallTotal = 0;
	
	
	document.workSheetForm['venueOneOverallTotal'].value = (total);
	document.workSheetForm['venueTwoOverallTotal'].value = (total);
	document.workSheetForm['venueThreeOverallTotal'].value = (total);
	
	
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneAccessTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneCheckInTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneMeetingTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneAudioTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneBanquetingTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneImpressionTotal.value);
	venueOneOverallTotal += parseInt(document.workSheetForm.venueOneGeneralTotal.value);
	
	
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoAccessTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoCheckInTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoMeetingTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoAudioTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoBanquetingTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoImpressionTotal.value);
	venueTwoOverallTotal += parseInt(document.workSheetForm.venueTwoGeneralTotal.value);
	
	
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeAccessTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeCheckInTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeMeetingTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeAudioTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeBanquetingTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeImpressionTotal.value);
	venueThreeOverallTotal += parseInt(document.workSheetForm.venueThreeGeneralTotal.value);
	
	
	
	document.workSheetForm.venueOneOverallTotal.value = (venueOneOverallTotal);
	document.workSheetForm.venueTwoOverallTotal.value = (venueTwoOverallTotal);
	document.workSheetForm.venueThreeOverallTotal.value = (venueThreeOverallTotal);
	
}