public void Update_owed_CHB(BudgetingMonths budgeting_months)
{
var num_months = budgeting_months.Num_budgeting_months();
var base_amount = _spreadsheet_io.Get_amount(MainSheetNames.Budget_out, Codes.Code003);
var current_amount = _spreadsheet_io.Get_amount(MainSheetNames.Expected_out, Codes.Code003, 2);
var new_amount = current_amount + (base_amount * num_months);
var total_months = (current_amount / base_amount) + num_months;
_spreadsheet_io.Update_amount(MainSheetNames.Expected_out, Codes.Code003, new_amount);
var text = _spreadsheet_io.Get_text(MainSheetNames.Expected_out, Codes.Code003);
if (!String.IsNullOrEmpty(text))
{
var begin_text = text.Substring(0, text.Length - 31);
var month_total = String.Format("{0:00}", total_months);
var start_date = text.Substring(text.Length - 21, 8);
var end_month = budgeting_months.Budgeting_end_date().ToString("MMM", CultureInfo.CurrentCulture);
var end_year = budgeting_months.Budgeting_end_date().Year;
text = $"{begin_text}{month_total} months {start_date} to {end_month} {end_year})";
_spreadsheet_io.Update_text(MainSheetNames.Expected_out, Codes.Code003, text);
}
}
