var sheet3b5 = 0;
var sheet3b6 = 0;
var sheet3b7 = 6.80;
var sheet3b8 = 6.95;
var sheet3b11 = 0;
var sheet3b12 = 0;
var sheet3b13 = 15.92;
var sheet3b14 = 18.90;
var sheet3b17 = 0;
var sheet3b18 = 0;
var sheet3b19 = 17.40;
var sheet3b20 = 0;
var sheet3b21 = 0;
var sheet3b22 = 10.41;
var sheet3b23 = 12.00;
var sheet3b26 = 0;
var sheet3b27 = 0;
var sheet3b28 = 17.90;
var sheet3b29 = 19.90;
var sheet3b32 = 0;
var current_debt = 0;

var credit_card_row_count = 2;
var store_card_row_count = 2;
var unsecured_loans_row_count = 2;
var secured_loans_row_count = 2;

var new_debt_insertion_point;

var new_row_number;

function calculateDebtFreedomDay() {
	var sheet1d5 = parseFloat(document.getElementById("gross_salary").value, 10);
	if (isNaN(sheet1d5)) {
		sheet1d5 = 0
	}
	var sheet2c3 = sheet1d5;
	var sheet2c5 = parseFloat(document.getElementById("secured_loans_1_balance").value, 10);
	if (isNaN(sheet2c5)) {
		sheet2c5 = 0
	}
	var sheet2c6 = parseFloat(document.getElementById("secured_loans_2_balance").value, 10);
	if (isNaN(sheet2c6)) {
		sheet2c6 = 0
	}
	var sheet2c9 = 0;
	var sheet2c10 = 0;
	var sheet2c11 = parseFloat(document.getElementById("credit_card_1_balance").value, 10);
	if (isNaN(sheet2c11)) {
		sheet2c11 = 0
	}
	var sheet2c12 = parseFloat(document.getElementById("credit_card_2_balance").value, 10);
	if (isNaN(sheet2c12)) {
		sheet2c12 = 0
	}
	var sheet2c15 = 0;
	var sheet2c16 = 0;
	var sheet2c17 = parseFloat(document.getElementById("overdraft_balance").value, 10);
	if (isNaN(sheet2c17)) {
		sheet2c17 = 0
	}
	
	var sheet2c18 = 0;
	var sheet2c19 = 0;
	var sheet2c20 = parseFloat(document.getElementById("unsecured_loans_1_balance").value, 10);
	if (isNaN(sheet2c20)) {
		sheet2c20 = 0
	}
	var sheet2c21 = parseFloat(document.getElementById("unsecured_loans_2_balance").value, 10);
	if (isNaN(sheet2c21)) {
		sheet2c21 = 0
	}
	var sheet2c24 = 0;
	var sheet2c25 = 0;
	var sheet2c26 = parseFloat(document.getElementById("store_card_1_balance").value, 10);
	if (isNaN(sheet2c26)) {
		sheet2c26 = 0
	}
	var sheet2c27 = parseFloat(document.getElementById("store_card_2_balance").value, 10);
	if (isNaN(sheet2c27)) {
		sheet2c27 = 0
	}
	var sheet2c30 = 0;
	var sheet2c31 = 0;
	var sheet2c32 = 0;
	if (parseFloat(document.getElementById("secured_loans_1_apr").value, 10) == 0 || document.getElementById("secured_loans_1_apr").value == "") {
		var sheet2d5 = sheet3b7;
	} else {
		var sheet2d5 = parseFloat(document.getElementById("secured_loans_1_apr").value, 10);
		if (isNaN(sheet2d5)) {
			sheet2d5 = 0
		}
	}
	if (parseFloat(document.getElementById("secured_loans_2_apr").value, 10) == 0 || document.getElementById("secured_loans_2_apr").value == "") {
		var sheet2d6 = sheet3b8;
	} else {
		var sheet2d6 = parseFloat(document.getElementById("secured_loans_2_apr").value, 10);
		if (isNaN(sheet2d6)) {
			sheet2d6 = 0
		}
	}
	var sheet2d9 = 0;
	var sheet2d10 = 0;
	if (parseFloat(document.getElementById("credit_card_1_apr").value, 10) == 0 || document.getElementById("credit_card_1_apr").value == "") {
		var sheet2d11 = sheet3b13;
	} else {
		var sheet2d11 = parseFloat(document.getElementById("credit_card_1_apr").value, 10);
		if (isNaN(sheet2d11)) {
			sheet2d11 = 0
		}
	}
	if (parseFloat(document.getElementById("credit_card_2_apr").value, 10) == 0 || document.getElementById("credit_card_2_apr").value == "") {
		var sheet2d12 = sheet3b14;
	} else {
		var sheet2d12 = parseFloat(document.getElementById("credit_card_2_apr").value, 10);
		if (isNaN(sheet2d12)) {
			sheet2d12 = 0
		}
	}
	var sheet2d15 = 0;
	var sheet2d16 = 0;
	if (parseFloat(document.getElementById("overdraft_apr").value, 10) == 0 || document.getElementById("overdraft_apr").value == "") {
		var sheet2d17 = sheet3b19;
	} else {
		var sheet2d17 = parseFloat(document.getElementById("overdraft_apr").value, 10);
		if (isNaN(sheet2d17)) {
			sheet2d17 = 0
		}
	}
	var sheet2d18 = 0;
	var sheet2d19 = 0;
	if (parseFloat(document.getElementById("unsecured_loans_1_apr").value, 10) == 0 || document.getElementById("unsecured_loans_1_apr").value == "") {
		var sheet2d20 = sheet3b22;
	} else {
		var sheet2d20 = parseFloat(document.getElementById("unsecured_loans_1_apr").value, 10);
		if (isNaN(sheet2d20)) {
			sheet2d20 = 0
		}
	}
	if (parseFloat(document.getElementById("unsecured_loans_2_apr").value, 10) == 0 || document.getElementById("unsecured_loans_2_apr").value == "") {
		var sheet2d21 = sheet3b23;
	} else {
		var sheet2d21 = parseFloat(document.getElementById("unsecured_loans_2_apr").value, 10);
		if (isNaN(sheet2d21)) {
			sheet2d21 = 0
		}
	}
	var sheet2d24 = 0;
	var sheet2d25 = 0;
	if (parseFloat(document.getElementById("store_card_1_apr").value, 10) == 0 || document.getElementById("store_card_1_apr").value == "") {
		var sheet2d26 = sheet3b28;
	} else {
		var sheet2d26 = parseFloat(document.getElementById("store_card_1_apr").value, 10);
		if (isNaN(sheet2d26)) {
			sheet2d26 = 0
		}
	}
	if (parseFloat(document.getElementById("store_card_2_apr").value, 10) == 0 || document.getElementById("store_card_2_apr").value == "") {
		var sheet2d27 = sheet3b29;
	} else {
		var sheet2d27 = parseFloat(document.getElementById("store_card_2_apr").value, 10);
		if (isNaN(sheet2d27)) {
			sheet2d27 = 0
		}
	}
	var sheet2d30 = 0;
	var sheet2d31 = 0;
	var sheet2d32 = 0;
	var sheet2e3 = sheet2c3 / 365;
	var sheet2e5 = sheet2c5 * (sheet2d5 / 100);
	var sheet2e6 = sheet2c6 * (sheet2d6 / 100);
	var sheet2e9 = sheet2c9 * (sheet2d9 / 100);
	var sheet2e10 = sheet2c10 * (sheet2d10 / 100);
	var sheet2e11 = sheet2c11 * (sheet2d11 / 100);
	var sheet2e12 = sheet2c12 * (sheet2d12 / 100);
	var sheet2e15 = sheet2c15 * (sheet2d15 / 100);
	var sheet2e16 = sheet2c16 * (sheet2d16 / 100);
	var sheet2e17 = sheet2c17 * (sheet2d17 / 100);
	var sheet2e18 = sheet2c18 * (sheet2d18 / 100);
	var sheet2e19 = sheet2c19 * (sheet2d19 / 100);
	var sheet2e20 = sheet2c20 * (sheet2d20 / 100);
	var sheet2e21 = sheet2c21 * (sheet2d21 / 100);
	var sheet2e24 = sheet2c24 * (sheet2d24 / 100);
	var sheet2e25 = sheet2c25 * (sheet2d25 / 100);
	var sheet2e26 = sheet2c26 * (sheet2d26 / 100);
	var sheet2e27 = sheet2c27 * (sheet2d27 / 100);
	var sheet2e30 = sheet2c30 * (sheet2d30 / 100);
	var sheet2e31 = sheet2c31 * (sheet2d31 / 100);
	var sheet2e32 = sheet2c32 * (sheet2d32 / 100);
	var sheet2e33 = 0;
	var sheet2e34 = sheet2e5 + sheet2e6 + sheet2e9 + sheet2e10 + sheet2e11 + sheet2e12 + sheet2e15 + sheet2e16 + sheet2e17 + sheet2e18 + sheet2e19 + sheet2e20 + sheet2e21 + sheet2e24 + sheet2e25 + sheet2e26 + sheet2e27 + sheet2e30 + sheet2e31 + sheet2e32 + sheet2e33;
	
	if (credit_card_row_count > 2) {
		for (i = 3; i <= credit_card_row_count; i++) {
			if (parseFloat(document.getElementById("credit_card_" + i + "_apr").value, 10) == 0 || document.getElementById("credit_card_" + i + "_apr").value == "") {
				if (document.getElementById("credit_card_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("credit_card_" + i + "_balance").value, 10) * (23.90/100));
				} else {
					sheet2e34 += 0;
				}
			} else {
				if (document.getElementById("credit_card_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("credit_card_" + i + "_balance").value, 10) * (parseFloat(document.getElementById("credit_card_" + i + "_apr").value, 10)/100));
				} else {
					sheet2e34 += 0;
				}
			}
		}
	}
	if (store_card_row_count > 2) {
		for (i = 3; i <= store_card_row_count; i++) {
			if (parseFloat(document.getElementById("store_card_" + i + "_apr").value, 10) == 0 || document.getElementById("store_card_" + i + "_apr").value == "") {
				if (document.getElementById("store_card_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("store_card_" + i + "_balance").value, 10) * (25.90/100));
				} else {
					sheet2e34 += 0;
				}
			} else {
				if (document.getElementById("store_card_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("store_card_" + i + "_balance").value, 10) * (parseFloat(document.getElementById("store_card_" + i + "_apr").value, 10)/100));
				} else {
					sheet2e34 += 0;
				}
			}
		}
	}
	if (secured_loans_row_count > 2) {
		for (i = 3; i <= secured_loans_row_count; i++) {
			if (parseFloat(document.getElementById("secured_loans_" + i + "_apr").value, 10) == 0 || document.getElementById("secured_loans_" + i + "_apr").value == "") {
				if (document.getElementById("secured_loans_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("secured_loans_" + i + "_balance").value, 10) * (8.70/100));
				} else {
					sheet2e34 += 0;
				}
			} else {
				if (document.getElementById("secured_loans_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("secured_loans_" + i + "_balance").value, 10) * (parseFloat(document.getElementById("secured_loans_" + i + "_apr").value, 10)/100));
				} else {
					sheet2e34 += 0;
				}
			}
		}
	}
	if (unsecured_loans_row_count > 2) {
		for (i = 3; i <= unsecured_loans_row_count; i++) {
			if (parseFloat(document.getElementById("unsecured_loans_" + i + "_apr").value, 10) == 0 || document.getElementById("unsecured_loans_" + i + "_apr").value == "") {
				if (document.getElementById("unsecured_loans_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("unsecured_loans_" + i + "_balance").value, 10) * (14.40/100));
				} else {
					sheet2e34 += 0;
				}
			} else {
				if (document.getElementById("unsecured_loans_" + i + "_balance").value != "") {
					sheet2e34 += (parseFloat(document.getElementById("unsecured_loans_" + i + "_balance").value, 10) * (parseFloat(document.getElementById("unsecured_loans_" + i + "_apr").value, 10)/100));
				} else {
					sheet2e34 += 0;
				}
			}
		}
	}
	
	var sheet1f35 = sheet2e34;
	if (isNaN(sheet1f35)) {
		document.getElementById("interest_to_pay").value = "0.00";
	} else {
		var num = new Number(sheet1f35);
		document.getElementById("interest_to_pay").value = num.toFixed(2);
	}
	if (isNaN(sheet1f35 / sheet2e3)) {
		document.getElementById("number_of_working_days").value = "0.00";
	} else {
		document.getElementById("number_of_working_days").value = Math.ceil(sheet1f35 / sheet2e3);
	}
	current_debt = sheet2c5 + sheet2c6 + sheet2c11 + sheet2c12 + sheet2c17 + sheet2c20 + sheet2c21 + sheet2c26 + sheet2c27;
	
	if (credit_card_row_count > 2) {
		for (i = 3; i <= credit_card_row_count; i++) {
			if (document.getElementById("credit_card_" + i + "_balance").value != "") {
				current_debt += parseFloat(document.getElementById("credit_card_" + i + "_balance").value, 10);
			}
		}
	}
	if (store_card_row_count > 2) {
		for (i = 3; i <= store_card_row_count; i++) {
			if (document.getElementById("store_card_" + i + "_balance").value != "") {
				current_debt += parseFloat(document.getElementById("store_card_" + i + "_balance").value, 10);
			}
		}
	}
	if (secured_loans_row_count > 2) {
		for (i = 3; i <= secured_loans_row_count; i++) {
			if (document.getElementById("secured_loans_" + i + "_balance").value != "") {
				current_debt += parseFloat(document.getElementById("secured_loans_" + i + "_balance").value, 10);
			}
		}
	}
	if (unsecured_loans_row_count > 2) {
		for (i = 3; i <= unsecured_loans_row_count; i++) {
			if (document.getElementById("unsecured_loans_" + i + "_balance").value != "") {
				current_debt += parseFloat(document.getElementById("unsecured_loans_" + i + "_balance").value, 10);
			}
		}
	}
	
	var num = new Number(current_debt);
	document.getElementById("current_debt").value =  num.toFixed(2);
	
	document.getElementById("answerrow1").style.visibility = "visible";
	document.getElementById("answerrow2").style.visibility = "visible";
	document.getElementById("answerrow3").style.visibility = "visible";
	document.getElementById("answerrow4").style.visibility = "visible";
	document.getElementById("answerrow5").style.visibility = "visible";
}

function addAnotherDebt(type) {
	
	var debttable = document.getElementById('debttable');
	
	switch (type) {
		case 'credit_card':
			new_debt_insertion_point = 7 + credit_card_row_count;
  			credit_card_row_count++;
			new_row_number = credit_card_row_count;
 			break;
		case 'store_card':
			new_debt_insertion_point = 10 + credit_card_row_count + store_card_row_count;
  			store_card_row_count++;
			new_row_number = store_card_row_count;
 			break;
		case 'secured_loans':
			new_debt_insertion_point = 13 + credit_card_row_count + store_card_row_count + secured_loans_row_count;
  			secured_loans_row_count++;
			new_row_number = secured_loans_row_count;
 			break;
		case 'unsecured_loans':
			new_debt_insertion_point = 16 + credit_card_row_count + store_card_row_count + secured_loans_row_count + unsecured_loans_row_count;
  			unsecured_loans_row_count++;
			new_row_number = unsecured_loans_row_count;
 			break;
	}
	
	var debttablerow = debttable.insertRow(new_debt_insertion_point);
	
	var debttablecolumn1 = debttablerow.insertCell(0);
	debttablecolumn1.innerHTML = "Debt " + new_row_number;
	var debttablecolumn2 = debttablerow.insertCell(1);
	debttablecolumn2.innerHTML = '<label for="' + type + '_' + new_row_number + '_balance">Current balance outstanding</label>';
	var debttablecolumn3 = debttablerow.insertCell(2);
	debttablecolumn3.innerHTML = '<span class="wl_calc_calc_font">&nbsp;&nbsp;&nbsp;</span><input name="' + type + '_' + new_row_number + '_balance" id="' + type + '_' + new_row_number + '_balance" type="text" size="10" />';
	var debttablecolumn4 = debttablerow.insertCell(3);
	debttablecolumn4.innerHTML = '<label for="' + type + '_' + new_row_number + '_apr">APR if known</label>';
	var debttablecolumn5 = debttablerow.insertCell(4);
	debttablecolumn5.innerHTML = '<span class="wl_calc_calc_font">&nbsp;&nbsp;&nbsp;</span><input name="' + type + '_' + new_row_number + '_apr" id="' + type + '_' + new_row_number + '_apr" type="text" size="5" />';
}