"""Formulas from sheet 'Schedule' of 'pricing_calculator.xlsx' (pandas target).

Generated by Power Migrate 0.1.0a1. Copied formulas are column, row or
table operations on the sheet's DataFrame; other blocks run cell by cell over
the same frame. ``model.compute`` runs them in dependency order.
"""

from .. import xl
from ..frames import FrameBook, abs_, across, and_, average, averageif, averageifs, ceiling, cells, choose, col, concat, concatenate, count, counta, countblank, countif, countifs, date, datedif, day, div, edate, eomonth, eq, exact, exp, find, floor, fv, ge, gt, hlookup, iferror, ifna, ifs, index, int_, ipmt, irr, isblank, iserr, iserror, islogical, isna, isnumber, istext, le, left, len_, ln, log, log10, lower, lt, match, max_, maxifs, mid, min_, minifs, mod, month, n, ne, networkdays, not_, nper, npv, num, or_, pi, pmt, power, ppmt, product, proper, pv, rate, rept, right, round_, rounddown, roundup, search, shifted, sign, sqrt, substitute, sum_, sumif, sumifs, sumproduct, switch, text, textjoin, trim, trunc, upper, value, vlookup, weekday, where, workday, xlookup, xor, year, yearfrac


def date_b2(book: FrameBook) -> None:
    r"""Date

    Schedule!B2 (one cell).
    Excel (B2): =StartDate
    Reads: Inputs!B7, name StartDate
    """
    schedule = book['Schedule']
    schedule["B2"] = book.name('StartDate')


def closing(book: FrameBook) -> None:
    r"""Closing

    Schedule!G2 (one cell).
    Excel (G2): =Financed
    Reads: Inputs!B16, name Financed
    """
    schedule = book['Schedule']
    schedule["G2"] = book.name('Financed')


def cashflow(book: FrameBook) -> None:
    r"""Cashflow

    Schedule!I2 (one cell).
    Excel (I2): =-Financed+Inputs!B8
    Reads: Inputs!B8, Inputs!B16, name Financed
    """
    schedule = book['Schedule']
    inputs = book['Inputs']
    schedule["I2"] = (-book.name('Financed')) + inputs["B8"]


def date_b3(book: FrameBook) -> None:
    r"""Date

    Schedule!B3:B74 (72 rows, copied down).
    Excel (B3): =EDATE(StartDate,A3)
    Pattern (R1C1): =EDATE(StartDate,RC[-1])
    Reads: Inputs!B7, Schedule!A3, name StartDate
    """
    df = book.frame('Schedule')
    rows = slice(3, 74)
    df.loc[rows, 'B'] = edate(book.name_table('StartDate'), col(df, 'A', rows))


def opening(book: FrameBook) -> None:
    r"""Opening

    Schedule!C3 (one cell).
    Excel (C3): =IF(A3<=TermMonths,G2,"")
    Reads: Inputs!B5, Schedule!G2, Schedule!A3, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C3"] = xl.IF(schedule["A3"] <= book.name('TermMonths'), schedule["G2"], '')


def payment(book: FrameBook) -> None:
    r"""Payment

    Schedule!D3:D74 (72 rows, copied down).
    Excel (D3): =IF(A3<=TermMonths,-PMT(MonthlyRate,TermMonths,Financed,-Balloon),"")
    Pattern (R1C1): =IF(RC[-3]<=TermMonths,-PMT(MonthlyRate,TermMonths,Financed,-Balloon),"")
    Reads: Inputs!B5, Inputs!B16, Inputs!B17, RateCard!B13, Schedule!A3, name Balloon, name Financed, name MonthlyRate, name TermMonths
    """
    df = book.frame('Schedule')
    rows = slice(3, 74)
    df.loc[rows, 'D'] = where(le(col(df, 'A', rows), book.name_table('TermMonths')), (-pmt(book.name_table('MonthlyRate'), book.name_table('TermMonths'), book.name_table('Financed'), (-num(book.name_table('Balloon'))))), '')


def interest(book: FrameBook) -> None:
    r"""Interest

    Schedule!E3:E29 (27 rows, copied down).
    Excel (E3): =IF(A3<=TermMonths,-IPMT(MonthlyRate,A3,TermMonths,Financed,-Balloon),"")
    Pattern (R1C1): =IF(RC[-4]<=TermMonths,-IPMT(MonthlyRate,RC[-4],TermMonths,Financed,-Balloon),"")
    Reads: Inputs!B5, Inputs!B16, Inputs!B17, RateCard!B13, Schedule!A3, name Balloon, name Financed, name MonthlyRate, name TermMonths
    """
    df = book.frame('Schedule')
    rows = slice(3, 29)
    df.loc[rows, 'E'] = where(le(col(df, 'A', rows), book.name_table('TermMonths')), (-ipmt(book.name_table('MonthlyRate'), col(df, 'A', rows), book.name_table('TermMonths'), book.name_table('Financed'), (-num(book.name_table('Balloon'))))), '')


def principal(book: FrameBook) -> None:
    r"""Principal

    Schedule!F3:F74 (72 rows, copied down).
    Excel (F3): =IF(A3<=TermMonths,-PPMT(MonthlyRate,A3,TermMonths,Financed,-Balloon),"")
    Pattern (R1C1): =IF(RC[-5]<=TermMonths,-PPMT(MonthlyRate,RC[-5],TermMonths,Financed,-Balloon),"")
    Reads: Inputs!B5, Inputs!B16, Inputs!B17, RateCard!B13, Schedule!A3, name Balloon, name Financed, name MonthlyRate, name TermMonths
    """
    df = book.frame('Schedule')
    rows = slice(3, 74)
    df.loc[rows, 'F'] = where(le(col(df, 'A', rows), book.name_table('TermMonths')), (-ppmt(book.name_table('MonthlyRate'), col(df, 'A', rows), book.name_table('TermMonths'), book.name_table('Financed'), (-num(book.name_table('Balloon'))))), '')


def closing_g3(book: FrameBook) -> None:
    r"""Closing

    Schedule!G3 (one cell).
    Excel (G3): =IF(A3<=TermMonths,C3-F3,"")
    Reads: Inputs!B5, Schedule!A3, Schedule!C3, Schedule!F3, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G3"] = xl.IF(schedule["A3"] <= book.name('TermMonths'), schedule["C3"] - schedule["F3"], '')


def cumulative_interest(book: FrameBook) -> None:
    r"""Cumulative interest

    Schedule!H3 (one cell).
    Excel (H3): =IF(A3<=TermMonths,E3,"")
    Reads: Inputs!B5, Schedule!A3, Schedule!E3, name TermMonths
    """
    schedule = book['Schedule']
    schedule["H3"] = xl.IF(schedule["A3"] <= book.name('TermMonths'), schedule["E3"], '')


def cashflow_i3(book: FrameBook) -> None:
    r"""Cashflow

    Schedule!I3:I74 (72 rows, copied down).
    Excel (I3): =IF(A3<=TermMonths,D3+IF(A3=TermMonths,Balloon,0),0)
    Pattern (R1C1): =IF(RC[-8]<=TermMonths,RC[-5]+IF(RC[-8]=TermMonths,Balloon,0),0)
    Reads: Inputs!B5, Inputs!B17, Schedule!A3, Schedule!D3, name Balloon, name TermMonths
    """
    df = book.frame('Schedule')
    rows = slice(3, 74)
    df.loc[rows, 'I'] = where(le(col(df, 'A', rows), book.name_table('TermMonths')), (num(col(df, 'D', rows)) + where(eq(col(df, 'A', rows), book.name_table('TermMonths')), book.name_table('Balloon'), 0)), 0)


def opening_c4(book: FrameBook) -> None:
    r"""Opening

    Schedule!C4 (one cell).
    Excel (C4): =IF(A4<=TermMonths,G3,"")
    Reads: Inputs!B5, Schedule!G3, Schedule!A4, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C4"] = xl.IF(schedule["A4"] <= book.name('TermMonths'), schedule["G3"], '')


def closing_g4(book: FrameBook) -> None:
    r"""Closing

    Schedule!G4 (one cell).
    Excel (G4): =IF(A4<=TermMonths,C4-F4,"")
    Reads: Inputs!B5, Schedule!A4, Schedule!C4, Schedule!F4, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G4"] = xl.IF(schedule["A4"] <= book.name('TermMonths'), schedule["C4"] - schedule["F4"], '')


def opening_c5(book: FrameBook) -> None:
    r"""Opening

    Schedule!C5 (one cell).
    Excel (C5): =IF(A5<=TermMonths,G4,"")
    Reads: Inputs!B5, Schedule!G4, Schedule!A5, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C5"] = xl.IF(schedule["A5"] <= book.name('TermMonths'), schedule["G4"], '')


def closing_g5(book: FrameBook) -> None:
    r"""Closing

    Schedule!G5 (one cell).
    Excel (G5): =IF(A5<=TermMonths,C5-F5,"")
    Reads: Inputs!B5, Schedule!A5, Schedule!C5, Schedule!F5, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G5"] = xl.IF(schedule["A5"] <= book.name('TermMonths'), schedule["C5"] - schedule["F5"], '')


def opening_c6(book: FrameBook) -> None:
    r"""Opening

    Schedule!C6 (one cell).
    Excel (C6): =IF(A6<=TermMonths,G5,"")
    Reads: Inputs!B5, Schedule!G5, Schedule!A6, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C6"] = xl.IF(schedule["A6"] <= book.name('TermMonths'), schedule["G5"], '')


def closing_g6(book: FrameBook) -> None:
    r"""Closing

    Schedule!G6 (one cell).
    Excel (G6): =IF(A6<=TermMonths,C6-F6,"")
    Reads: Inputs!B5, Schedule!A6, Schedule!C6, Schedule!F6, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G6"] = xl.IF(schedule["A6"] <= book.name('TermMonths'), schedule["C6"] - schedule["F6"], '')


def opening_c7(book: FrameBook) -> None:
    r"""Opening

    Schedule!C7 (one cell).
    Excel (C7): =IF(A7<=TermMonths,G6,"")
    Reads: Inputs!B5, Schedule!G6, Schedule!A7, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C7"] = xl.IF(schedule["A7"] <= book.name('TermMonths'), schedule["G6"], '')


def closing_g7(book: FrameBook) -> None:
    r"""Closing

    Schedule!G7 (one cell).
    Excel (G7): =IF(A7<=TermMonths,C7-F7,"")
    Reads: Inputs!B5, Schedule!A7, Schedule!C7, Schedule!F7, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G7"] = xl.IF(schedule["A7"] <= book.name('TermMonths'), schedule["C7"] - schedule["F7"], '')


def cell_c8(book: FrameBook) -> None:
    r"""Schedule!C8

    Schedule!C8 (one cell).
    Excel (C8): =IF(A8<=TermMonths,G7,"")
    Reads: Inputs!B5, Schedule!G7, Schedule!A8, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C8"] = xl.IF(schedule["A8"] <= book.name('TermMonths'), schedule["G7"], '')


def cell_g8(book: FrameBook) -> None:
    r"""Schedule!G8

    Schedule!G8 (one cell).
    Excel (G8): =IF(A8<=TermMonths,C8-F8,"")
    Reads: Inputs!B5, Schedule!A8, Schedule!C8, Schedule!F8, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G8"] = xl.IF(schedule["A8"] <= book.name('TermMonths'), schedule["C8"] - schedule["F8"], '')


def cell_c9(book: FrameBook) -> None:
    r"""Schedule!C9

    Schedule!C9 (one cell).
    Excel (C9): =IF(A9<=TermMonths,G8,"")
    Reads: Inputs!B5, Schedule!G8, Schedule!A9, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C9"] = xl.IF(schedule["A9"] <= book.name('TermMonths'), schedule["G8"], '')


def cell_g9(book: FrameBook) -> None:
    r"""Schedule!G9

    Schedule!G9 (one cell).
    Excel (G9): =IF(A9<=TermMonths,C9-F9,"")
    Reads: Inputs!B5, Schedule!A9, Schedule!C9, Schedule!F9, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G9"] = xl.IF(schedule["A9"] <= book.name('TermMonths'), schedule["C9"] - schedule["F9"], '')


def cell_c10(book: FrameBook) -> None:
    r"""Schedule!C10

    Schedule!C10 (one cell).
    Excel (C10): =IF(A10<=TermMonths,G9,"")
    Reads: Inputs!B5, Schedule!G9, Schedule!A10, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C10"] = xl.IF(schedule["A10"] <= book.name('TermMonths'), schedule["G9"], '')


def cell_g10(book: FrameBook) -> None:
    r"""Schedule!G10

    Schedule!G10 (one cell).
    Excel (G10): =IF(A10<=TermMonths,C10-F10,"")
    Reads: Inputs!B5, Schedule!A10, Schedule!C10, Schedule!F10, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G10"] = xl.IF(schedule["A10"] <= book.name('TermMonths'), schedule["C10"] - schedule["F10"], '')


def cell_c11(book: FrameBook) -> None:
    r"""Schedule!C11

    Schedule!C11 (one cell).
    Excel (C11): =IF(A11<=TermMonths,G10,"")
    Reads: Inputs!B5, Schedule!G10, Schedule!A11, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C11"] = xl.IF(schedule["A11"] <= book.name('TermMonths'), schedule["G10"], '')


def cell_g11(book: FrameBook) -> None:
    r"""Schedule!G11

    Schedule!G11 (one cell).
    Excel (G11): =IF(A11<=TermMonths,C11-F11,"")
    Reads: Inputs!B5, Schedule!A11, Schedule!C11, Schedule!F11, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G11"] = xl.IF(schedule["A11"] <= book.name('TermMonths'), schedule["C11"] - schedule["F11"], '')


def cell_c12(book: FrameBook) -> None:
    r"""Schedule!C12

    Schedule!C12 (one cell).
    Excel (C12): =IF(A12<=TermMonths,G11,"")
    Reads: Inputs!B5, Schedule!G11, Schedule!A12, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C12"] = xl.IF(schedule["A12"] <= book.name('TermMonths'), schedule["G11"], '')


def cell_g12(book: FrameBook) -> None:
    r"""Schedule!G12

    Schedule!G12 (one cell).
    Excel (G12): =IF(A12<=TermMonths,C12-F12,"")
    Reads: Inputs!B5, Schedule!A12, Schedule!C12, Schedule!F12, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G12"] = xl.IF(schedule["A12"] <= book.name('TermMonths'), schedule["C12"] - schedule["F12"], '')


def cell_c13(book: FrameBook) -> None:
    r"""Schedule!C13

    Schedule!C13 (one cell).
    Excel (C13): =IF(A13<=TermMonths,G12,"")
    Reads: Inputs!B5, Schedule!G12, Schedule!A13, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C13"] = xl.IF(schedule["A13"] <= book.name('TermMonths'), schedule["G12"], '')


def cell_g13(book: FrameBook) -> None:
    r"""Schedule!G13

    Schedule!G13 (one cell).
    Excel (G13): =IF(A13<=TermMonths,C13-F13,"")
    Reads: Inputs!B5, Schedule!A13, Schedule!C13, Schedule!F13, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G13"] = xl.IF(schedule["A13"] <= book.name('TermMonths'), schedule["C13"] - schedule["F13"], '')


def cell_c14(book: FrameBook) -> None:
    r"""Schedule!C14

    Schedule!C14 (one cell).
    Excel (C14): =IF(A14<=TermMonths,G13,"")
    Reads: Inputs!B5, Schedule!G13, Schedule!A14, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C14"] = xl.IF(schedule["A14"] <= book.name('TermMonths'), schedule["G13"], '')


def cell_g14(book: FrameBook) -> None:
    r"""Schedule!G14

    Schedule!G14 (one cell).
    Excel (G14): =IF(A14<=TermMonths,C14-F14,"")
    Reads: Inputs!B5, Schedule!A14, Schedule!C14, Schedule!F14, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G14"] = xl.IF(schedule["A14"] <= book.name('TermMonths'), schedule["C14"] - schedule["F14"], '')


def cell_c15(book: FrameBook) -> None:
    r"""Schedule!C15

    Schedule!C15 (one cell).
    Excel (C15): =IF(A15<=TermMonths,G14,"")
    Reads: Inputs!B5, Schedule!G14, Schedule!A15, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C15"] = xl.IF(schedule["A15"] <= book.name('TermMonths'), schedule["G14"], '')


def cell_g15(book: FrameBook) -> None:
    r"""Schedule!G15

    Schedule!G15 (one cell).
    Excel (G15): =IF(A15<=TermMonths,C15-F15,"")
    Reads: Inputs!B5, Schedule!A15, Schedule!C15, Schedule!F15, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G15"] = xl.IF(schedule["A15"] <= book.name('TermMonths'), schedule["C15"] - schedule["F15"], '')


def cell_c16(book: FrameBook) -> None:
    r"""Schedule!C16

    Schedule!C16 (one cell).
    Excel (C16): =IF(A16<=TermMonths,G15,"")
    Reads: Inputs!B5, Schedule!G15, Schedule!A16, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C16"] = xl.IF(schedule["A16"] <= book.name('TermMonths'), schedule["G15"], '')


def cell_g16(book: FrameBook) -> None:
    r"""Schedule!G16

    Schedule!G16 (one cell).
    Excel (G16): =IF(A16<=TermMonths,C16-F16,"")
    Reads: Inputs!B5, Schedule!A16, Schedule!C16, Schedule!F16, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G16"] = xl.IF(schedule["A16"] <= book.name('TermMonths'), schedule["C16"] - schedule["F16"], '')


def cell_c17(book: FrameBook) -> None:
    r"""Schedule!C17

    Schedule!C17 (one cell).
    Excel (C17): =IF(A17<=TermMonths,G16,"")
    Reads: Inputs!B5, Schedule!G16, Schedule!A17, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C17"] = xl.IF(schedule["A17"] <= book.name('TermMonths'), schedule["G16"], '')


def cell_g17(book: FrameBook) -> None:
    r"""Schedule!G17

    Schedule!G17 (one cell).
    Excel (G17): =IF(A17<=TermMonths,C17-F17,"")
    Reads: Inputs!B5, Schedule!A17, Schedule!C17, Schedule!F17, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G17"] = xl.IF(schedule["A17"] <= book.name('TermMonths'), schedule["C17"] - schedule["F17"], '')


def cell_c18(book: FrameBook) -> None:
    r"""Schedule!C18

    Schedule!C18 (one cell).
    Excel (C18): =IF(A18<=TermMonths,G17,"")
    Reads: Inputs!B5, Schedule!G17, Schedule!A18, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C18"] = xl.IF(schedule["A18"] <= book.name('TermMonths'), schedule["G17"], '')


def cell_g18(book: FrameBook) -> None:
    r"""Schedule!G18

    Schedule!G18 (one cell).
    Excel (G18): =IF(A18<=TermMonths,C18-F18,"")
    Reads: Inputs!B5, Schedule!A18, Schedule!C18, Schedule!F18, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G18"] = xl.IF(schedule["A18"] <= book.name('TermMonths'), schedule["C18"] - schedule["F18"], '')


def cell_c19(book: FrameBook) -> None:
    r"""Schedule!C19

    Schedule!C19 (one cell).
    Excel (C19): =IF(A19<=TermMonths,G18,"")
    Reads: Inputs!B5, Schedule!G18, Schedule!A19, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C19"] = xl.IF(schedule["A19"] <= book.name('TermMonths'), schedule["G18"], '')


def cell_g19(book: FrameBook) -> None:
    r"""Schedule!G19

    Schedule!G19 (one cell).
    Excel (G19): =IF(A19<=TermMonths,C19-F19,"")
    Reads: Inputs!B5, Schedule!A19, Schedule!C19, Schedule!F19, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G19"] = xl.IF(schedule["A19"] <= book.name('TermMonths'), schedule["C19"] - schedule["F19"], '')


def cell_c20(book: FrameBook) -> None:
    r"""Schedule!C20

    Schedule!C20 (one cell).
    Excel (C20): =IF(A20<=TermMonths,G19,"")
    Reads: Inputs!B5, Schedule!G19, Schedule!A20, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C20"] = xl.IF(schedule["A20"] <= book.name('TermMonths'), schedule["G19"], '')


def cell_g20(book: FrameBook) -> None:
    r"""Schedule!G20

    Schedule!G20 (one cell).
    Excel (G20): =IF(A20<=TermMonths,C20-F20,"")
    Reads: Inputs!B5, Schedule!A20, Schedule!C20, Schedule!F20, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G20"] = xl.IF(schedule["A20"] <= book.name('TermMonths'), schedule["C20"] - schedule["F20"], '')


def cell_c21(book: FrameBook) -> None:
    r"""Schedule!C21

    Schedule!C21 (one cell).
    Excel (C21): =IF(A21<=TermMonths,G20,"")
    Reads: Inputs!B5, Schedule!G20, Schedule!A21, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C21"] = xl.IF(schedule["A21"] <= book.name('TermMonths'), schedule["G20"], '')


def cell_g21(book: FrameBook) -> None:
    r"""Schedule!G21

    Schedule!G21 (one cell).
    Excel (G21): =IF(A21<=TermMonths,C21-F21,"")
    Reads: Inputs!B5, Schedule!A21, Schedule!C21, Schedule!F21, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G21"] = xl.IF(schedule["A21"] <= book.name('TermMonths'), schedule["C21"] - schedule["F21"], '')


def cell_c22(book: FrameBook) -> None:
    r"""Schedule!C22

    Schedule!C22 (one cell).
    Excel (C22): =IF(A22<=TermMonths,G21,"")
    Reads: Inputs!B5, Schedule!G21, Schedule!A22, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C22"] = xl.IF(schedule["A22"] <= book.name('TermMonths'), schedule["G21"], '')


def cell_g22(book: FrameBook) -> None:
    r"""Schedule!G22

    Schedule!G22 (one cell).
    Excel (G22): =IF(A22<=TermMonths,C22-F22,"")
    Reads: Inputs!B5, Schedule!A22, Schedule!C22, Schedule!F22, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G22"] = xl.IF(schedule["A22"] <= book.name('TermMonths'), schedule["C22"] - schedule["F22"], '')


def cell_c23(book: FrameBook) -> None:
    r"""Schedule!C23

    Schedule!C23 (one cell).
    Excel (C23): =IF(A23<=TermMonths,G22,"")
    Reads: Inputs!B5, Schedule!G22, Schedule!A23, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C23"] = xl.IF(schedule["A23"] <= book.name('TermMonths'), schedule["G22"], '')


def cell_g23(book: FrameBook) -> None:
    r"""Schedule!G23

    Schedule!G23 (one cell).
    Excel (G23): =IF(A23<=TermMonths,C23-F23,"")
    Reads: Inputs!B5, Schedule!A23, Schedule!C23, Schedule!F23, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G23"] = xl.IF(schedule["A23"] <= book.name('TermMonths'), schedule["C23"] - schedule["F23"], '')


def cell_c24(book: FrameBook) -> None:
    r"""Schedule!C24

    Schedule!C24 (one cell).
    Excel (C24): =IF(A24<=TermMonths,G23,"")
    Reads: Inputs!B5, Schedule!G23, Schedule!A24, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C24"] = xl.IF(schedule["A24"] <= book.name('TermMonths'), schedule["G23"], '')


def cell_g24(book: FrameBook) -> None:
    r"""Schedule!G24

    Schedule!G24 (one cell).
    Excel (G24): =IF(A24<=TermMonths,C24-F24,"")
    Reads: Inputs!B5, Schedule!A24, Schedule!C24, Schedule!F24, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G24"] = xl.IF(schedule["A24"] <= book.name('TermMonths'), schedule["C24"] - schedule["F24"], '')


def cell_c25(book: FrameBook) -> None:
    r"""Schedule!C25

    Schedule!C25 (one cell).
    Excel (C25): =IF(A25<=TermMonths,G24,"")
    Reads: Inputs!B5, Schedule!G24, Schedule!A25, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C25"] = xl.IF(schedule["A25"] <= book.name('TermMonths'), schedule["G24"], '')


def cell_g25(book: FrameBook) -> None:
    r"""Schedule!G25

    Schedule!G25 (one cell).
    Excel (G25): =IF(A25<=TermMonths,C25-F25,"")
    Reads: Inputs!B5, Schedule!A25, Schedule!C25, Schedule!F25, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G25"] = xl.IF(schedule["A25"] <= book.name('TermMonths'), schedule["C25"] - schedule["F25"], '')


def cell_c26(book: FrameBook) -> None:
    r"""Schedule!C26

    Schedule!C26 (one cell).
    Excel (C26): =IF(A26<=TermMonths,G25,"")
    Reads: Inputs!B5, Schedule!G25, Schedule!A26, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C26"] = xl.IF(schedule["A26"] <= book.name('TermMonths'), schedule["G25"], '')


def cell_g26(book: FrameBook) -> None:
    r"""Schedule!G26

    Schedule!G26 (one cell).
    Excel (G26): =IF(A26<=TermMonths,C26-F26,"")
    Reads: Inputs!B5, Schedule!A26, Schedule!C26, Schedule!F26, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G26"] = xl.IF(schedule["A26"] <= book.name('TermMonths'), schedule["C26"] - schedule["F26"], '')


def cell_c27(book: FrameBook) -> None:
    r"""Schedule!C27

    Schedule!C27 (one cell).
    Excel (C27): =IF(A27<=TermMonths,G26,"")
    Reads: Inputs!B5, Schedule!G26, Schedule!A27, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C27"] = xl.IF(schedule["A27"] <= book.name('TermMonths'), schedule["G26"], '')


def cell_g27(book: FrameBook) -> None:
    r"""Schedule!G27

    Schedule!G27 (one cell).
    Excel (G27): =IF(A27<=TermMonths,C27-F27,"")
    Reads: Inputs!B5, Schedule!A27, Schedule!C27, Schedule!F27, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G27"] = xl.IF(schedule["A27"] <= book.name('TermMonths'), schedule["C27"] - schedule["F27"], '')


def cell_c28(book: FrameBook) -> None:
    r"""Schedule!C28

    Schedule!C28 (one cell).
    Excel (C28): =IF(A28<=TermMonths,G27,"")
    Reads: Inputs!B5, Schedule!G27, Schedule!A28, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C28"] = xl.IF(schedule["A28"] <= book.name('TermMonths'), schedule["G27"], '')


def cell_g28(book: FrameBook) -> None:
    r"""Schedule!G28

    Schedule!G28 (one cell).
    Excel (G28): =IF(A28<=TermMonths,C28-F28,"")
    Reads: Inputs!B5, Schedule!A28, Schedule!C28, Schedule!F28, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G28"] = xl.IF(schedule["A28"] <= book.name('TermMonths'), schedule["C28"] - schedule["F28"], '')


def cell_c29(book: FrameBook) -> None:
    r"""Schedule!C29

    Schedule!C29 (one cell).
    Excel (C29): =IF(A29<=TermMonths,G28,"")
    Reads: Inputs!B5, Schedule!G28, Schedule!A29, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C29"] = xl.IF(schedule["A29"] <= book.name('TermMonths'), schedule["G28"], '')


def cell_g29(book: FrameBook) -> None:
    r"""Schedule!G29

    Schedule!G29 (one cell).
    Excel (G29): =IF(A29<=TermMonths,C29-F29,"")
    Reads: Inputs!B5, Schedule!A29, Schedule!C29, Schedule!F29, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G29"] = xl.IF(schedule["A29"] <= book.name('TermMonths'), schedule["C29"] - schedule["F29"], '')


def cell_c30(book: FrameBook) -> None:
    r"""Schedule!C30

    Schedule!C30 (one cell).
    Excel (C30): =IF(A30<=TermMonths,G29,"")
    Reads: Inputs!B5, Schedule!G29, Schedule!A30, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C30"] = xl.IF(schedule["A30"] <= book.name('TermMonths'), schedule["G29"], '')


def cell_g30(book: FrameBook) -> None:
    r"""Schedule!G30

    Schedule!G30 (one cell).
    Excel (G30): =IF(A30<=TermMonths,C30-F30,"")
    Reads: Inputs!B5, Schedule!A30, Schedule!C30, Schedule!F30, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G30"] = xl.IF(schedule["A30"] <= book.name('TermMonths'), schedule["C30"] - schedule["F30"], '')


def cell_c31(book: FrameBook) -> None:
    r"""Schedule!C31

    Schedule!C31 (one cell).
    Excel (C31): =IF(A31<=TermMonths,G30,"")
    Reads: Inputs!B5, Schedule!G30, Schedule!A31, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C31"] = xl.IF(schedule["A31"] <= book.name('TermMonths'), schedule["G30"], '')


def range_e31_e74(book: FrameBook) -> None:
    r"""Schedule!E31:E74

    Schedule!E31:E74 (44 rows, copied down).
    Excel (E31): =IF(A31<=TermMonths,-IPMT(MonthlyRate,A31,TermMonths,Financed,-Balloon),"")
    Pattern (R1C1): =IF(RC[-4]<=TermMonths,-IPMT(MonthlyRate,RC[-4],TermMonths,Financed,-Balloon),"")
    Reads: Inputs!B5, Inputs!B16, Inputs!B17, RateCard!B13, Schedule!A31, name Balloon, name Financed, name MonthlyRate, name TermMonths
    """
    df = book.frame('Schedule')
    rows = slice(31, 74)
    df.loc[rows, 'E'] = where(le(col(df, 'A', rows), book.name_table('TermMonths')), (-ipmt(book.name_table('MonthlyRate'), col(df, 'A', rows), book.name_table('TermMonths'), book.name_table('Financed'), (-num(book.name_table('Balloon'))))), '')


def cumulative_interest_h4(book: FrameBook) -> None:
    r"""Cumulative interest

    Schedule!H4:H74 (71 rows, copied down).
    Excel (H4): =IF(A4<=TermMonths,H3+E4,"")
    Pattern (R1C1): =IF(RC[-7]<=TermMonths,R[-1]C+RC[-3],"")
    Reads: Inputs!B5, Schedule!H3, Schedule!A4, Schedule!E4, name TermMonths
    """
    schedule = book['Schedule']
    for r in range(4, 75):
        schedule[r, 'H'] = xl.IF(schedule[r, 'A'] <= book.name('TermMonths'), schedule[r - 1, 'H'] + schedule[r, 'E'], '')


def cell_g31(book: FrameBook) -> None:
    r"""Schedule!G31

    Schedule!G31 (one cell).
    Excel (G31): =IF(A31<=TermMonths,C31-F31,"")
    Reads: Inputs!B5, Schedule!A31, Schedule!C31, Schedule!F31, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G31"] = xl.IF(schedule["A31"] <= book.name('TermMonths'), schedule["C31"] - schedule["F31"], '')


def cell_c32(book: FrameBook) -> None:
    r"""Schedule!C32

    Schedule!C32 (one cell).
    Excel (C32): =IF(A32<=TermMonths,G31,"")
    Reads: Inputs!B5, Schedule!G31, Schedule!A32, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C32"] = xl.IF(schedule["A32"] <= book.name('TermMonths'), schedule["G31"], '')


def cell_g32(book: FrameBook) -> None:
    r"""Schedule!G32

    Schedule!G32 (one cell).
    Excel (G32): =IF(A32<=TermMonths,C32-F32,"")
    Reads: Inputs!B5, Schedule!A32, Schedule!C32, Schedule!F32, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G32"] = xl.IF(schedule["A32"] <= book.name('TermMonths'), schedule["C32"] - schedule["F32"], '')


def cell_c33(book: FrameBook) -> None:
    r"""Schedule!C33

    Schedule!C33 (one cell).
    Excel (C33): =IF(A33<=TermMonths,G32,"")
    Reads: Inputs!B5, Schedule!G32, Schedule!A33, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C33"] = xl.IF(schedule["A33"] <= book.name('TermMonths'), schedule["G32"], '')


def cell_g33(book: FrameBook) -> None:
    r"""Schedule!G33

    Schedule!G33 (one cell).
    Excel (G33): =IF(A33<=TermMonths,C33-F33,"")
    Reads: Inputs!B5, Schedule!A33, Schedule!C33, Schedule!F33, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G33"] = xl.IF(schedule["A33"] <= book.name('TermMonths'), schedule["C33"] - schedule["F33"], '')


def cell_c34(book: FrameBook) -> None:
    r"""Schedule!C34

    Schedule!C34 (one cell).
    Excel (C34): =IF(A34<=TermMonths,G33,"")
    Reads: Inputs!B5, Schedule!G33, Schedule!A34, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C34"] = xl.IF(schedule["A34"] <= book.name('TermMonths'), schedule["G33"], '')


def cell_g34(book: FrameBook) -> None:
    r"""Schedule!G34

    Schedule!G34 (one cell).
    Excel (G34): =IF(A34<=TermMonths,C34-F34,"")
    Reads: Inputs!B5, Schedule!A34, Schedule!C34, Schedule!F34, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G34"] = xl.IF(schedule["A34"] <= book.name('TermMonths'), schedule["C34"] - schedule["F34"], '')


def cell_c35(book: FrameBook) -> None:
    r"""Schedule!C35

    Schedule!C35 (one cell).
    Excel (C35): =IF(A35<=TermMonths,G34,"")
    Reads: Inputs!B5, Schedule!G34, Schedule!A35, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C35"] = xl.IF(schedule["A35"] <= book.name('TermMonths'), schedule["G34"], '')


def cell_g35(book: FrameBook) -> None:
    r"""Schedule!G35

    Schedule!G35 (one cell).
    Excel (G35): =IF(A35<=TermMonths,C35-F35,"")
    Reads: Inputs!B5, Schedule!A35, Schedule!C35, Schedule!F35, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G35"] = xl.IF(schedule["A35"] <= book.name('TermMonths'), schedule["C35"] - schedule["F35"], '')


def cell_c36(book: FrameBook) -> None:
    r"""Schedule!C36

    Schedule!C36 (one cell).
    Excel (C36): =IF(A36<=TermMonths,G35,"")
    Reads: Inputs!B5, Schedule!G35, Schedule!A36, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C36"] = xl.IF(schedule["A36"] <= book.name('TermMonths'), schedule["G35"], '')


def cell_g36(book: FrameBook) -> None:
    r"""Schedule!G36

    Schedule!G36 (one cell).
    Excel (G36): =IF(A36<=TermMonths,C36-F36,"")
    Reads: Inputs!B5, Schedule!A36, Schedule!C36, Schedule!F36, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G36"] = xl.IF(schedule["A36"] <= book.name('TermMonths'), schedule["C36"] - schedule["F36"], '')


def cell_c37(book: FrameBook) -> None:
    r"""Schedule!C37

    Schedule!C37 (one cell).
    Excel (C37): =IF(A37<=TermMonths,G36,"")
    Reads: Inputs!B5, Schedule!G36, Schedule!A37, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C37"] = xl.IF(schedule["A37"] <= book.name('TermMonths'), schedule["G36"], '')


def cell_g37(book: FrameBook) -> None:
    r"""Schedule!G37

    Schedule!G37 (one cell).
    Excel (G37): =IF(A37<=TermMonths,C37-F37,"")
    Reads: Inputs!B5, Schedule!A37, Schedule!C37, Schedule!F37, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G37"] = xl.IF(schedule["A37"] <= book.name('TermMonths'), schedule["C37"] - schedule["F37"], '')


def cell_c38(book: FrameBook) -> None:
    r"""Schedule!C38

    Schedule!C38 (one cell).
    Excel (C38): =IF(A38<=TermMonths,G37,"")
    Reads: Inputs!B5, Schedule!G37, Schedule!A38, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C38"] = xl.IF(schedule["A38"] <= book.name('TermMonths'), schedule["G37"], '')


def cell_g38(book: FrameBook) -> None:
    r"""Schedule!G38

    Schedule!G38 (one cell).
    Excel (G38): =IF(A38<=TermMonths,C38-F38,"")
    Reads: Inputs!B5, Schedule!A38, Schedule!C38, Schedule!F38, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G38"] = xl.IF(schedule["A38"] <= book.name('TermMonths'), schedule["C38"] - schedule["F38"], '')


def cell_c39(book: FrameBook) -> None:
    r"""Schedule!C39

    Schedule!C39 (one cell).
    Excel (C39): =IF(A39<=TermMonths,G38,"")
    Reads: Inputs!B5, Schedule!G38, Schedule!A39, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C39"] = xl.IF(schedule["A39"] <= book.name('TermMonths'), schedule["G38"], '')


def cell_g39(book: FrameBook) -> None:
    r"""Schedule!G39

    Schedule!G39 (one cell).
    Excel (G39): =IF(A39<=TermMonths,C39-F39,"")
    Reads: Inputs!B5, Schedule!A39, Schedule!C39, Schedule!F39, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G39"] = xl.IF(schedule["A39"] <= book.name('TermMonths'), schedule["C39"] - schedule["F39"], '')


def cell_c40(book: FrameBook) -> None:
    r"""Schedule!C40

    Schedule!C40 (one cell).
    Excel (C40): =IF(A40<=TermMonths,G39,"")
    Reads: Inputs!B5, Schedule!G39, Schedule!A40, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C40"] = xl.IF(schedule["A40"] <= book.name('TermMonths'), schedule["G39"], '')


def cell_g40(book: FrameBook) -> None:
    r"""Schedule!G40

    Schedule!G40 (one cell).
    Excel (G40): =IF(A40<=TermMonths,C40-F40,"")
    Reads: Inputs!B5, Schedule!A40, Schedule!C40, Schedule!F40, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G40"] = xl.IF(schedule["A40"] <= book.name('TermMonths'), schedule["C40"] - schedule["F40"], '')


def cell_c41(book: FrameBook) -> None:
    r"""Schedule!C41

    Schedule!C41 (one cell).
    Excel (C41): =IF(A41<=TermMonths,G40,"")
    Reads: Inputs!B5, Schedule!G40, Schedule!A41, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C41"] = xl.IF(schedule["A41"] <= book.name('TermMonths'), schedule["G40"], '')


def cell_g41(book: FrameBook) -> None:
    r"""Schedule!G41

    Schedule!G41 (one cell).
    Excel (G41): =IF(A41<=TermMonths,C41-F41,"")
    Reads: Inputs!B5, Schedule!A41, Schedule!C41, Schedule!F41, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G41"] = xl.IF(schedule["A41"] <= book.name('TermMonths'), schedule["C41"] - schedule["F41"], '')


def cell_c42(book: FrameBook) -> None:
    r"""Schedule!C42

    Schedule!C42 (one cell).
    Excel (C42): =IF(A42<=TermMonths,G41,"")
    Reads: Inputs!B5, Schedule!G41, Schedule!A42, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C42"] = xl.IF(schedule["A42"] <= book.name('TermMonths'), schedule["G41"], '')


def cell_g42(book: FrameBook) -> None:
    r"""Schedule!G42

    Schedule!G42 (one cell).
    Excel (G42): =IF(A42<=TermMonths,C42-F42,"")
    Reads: Inputs!B5, Schedule!A42, Schedule!C42, Schedule!F42, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G42"] = xl.IF(schedule["A42"] <= book.name('TermMonths'), schedule["C42"] - schedule["F42"], '')


def cell_c43(book: FrameBook) -> None:
    r"""Schedule!C43

    Schedule!C43 (one cell).
    Excel (C43): =IF(A43<=TermMonths,G42,"")
    Reads: Inputs!B5, Schedule!G42, Schedule!A43, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C43"] = xl.IF(schedule["A43"] <= book.name('TermMonths'), schedule["G42"], '')


def cell_g43(book: FrameBook) -> None:
    r"""Schedule!G43

    Schedule!G43 (one cell).
    Excel (G43): =IF(A43<=TermMonths,C43-F43,"")
    Reads: Inputs!B5, Schedule!A43, Schedule!C43, Schedule!F43, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G43"] = xl.IF(schedule["A43"] <= book.name('TermMonths'), schedule["C43"] - schedule["F43"], '')


def cell_c44(book: FrameBook) -> None:
    r"""Schedule!C44

    Schedule!C44 (one cell).
    Excel (C44): =IF(A44<=TermMonths,G43,"")
    Reads: Inputs!B5, Schedule!G43, Schedule!A44, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C44"] = xl.IF(schedule["A44"] <= book.name('TermMonths'), schedule["G43"], '')


def cell_g44(book: FrameBook) -> None:
    r"""Schedule!G44

    Schedule!G44 (one cell).
    Excel (G44): =IF(A44<=TermMonths,C44-F44,"")
    Reads: Inputs!B5, Schedule!A44, Schedule!C44, Schedule!F44, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G44"] = xl.IF(schedule["A44"] <= book.name('TermMonths'), schedule["C44"] - schedule["F44"], '')


def cell_c45(book: FrameBook) -> None:
    r"""Schedule!C45

    Schedule!C45 (one cell).
    Excel (C45): =IF(A45<=TermMonths,G44,"")
    Reads: Inputs!B5, Schedule!G44, Schedule!A45, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C45"] = xl.IF(schedule["A45"] <= book.name('TermMonths'), schedule["G44"], '')


def cell_g45(book: FrameBook) -> None:
    r"""Schedule!G45

    Schedule!G45 (one cell).
    Excel (G45): =IF(A45<=TermMonths,C45-F45,"")
    Reads: Inputs!B5, Schedule!A45, Schedule!C45, Schedule!F45, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G45"] = xl.IF(schedule["A45"] <= book.name('TermMonths'), schedule["C45"] - schedule["F45"], '')


def cell_c46(book: FrameBook) -> None:
    r"""Schedule!C46

    Schedule!C46 (one cell).
    Excel (C46): =IF(A46<=TermMonths,G45,"")
    Reads: Inputs!B5, Schedule!G45, Schedule!A46, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C46"] = xl.IF(schedule["A46"] <= book.name('TermMonths'), schedule["G45"], '')


def cell_g46(book: FrameBook) -> None:
    r"""Schedule!G46

    Schedule!G46 (one cell).
    Excel (G46): =IF(A46<=TermMonths,C46-F46,"")
    Reads: Inputs!B5, Schedule!A46, Schedule!C46, Schedule!F46, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G46"] = xl.IF(schedule["A46"] <= book.name('TermMonths'), schedule["C46"] - schedule["F46"], '')


def cell_c47(book: FrameBook) -> None:
    r"""Schedule!C47

    Schedule!C47 (one cell).
    Excel (C47): =IF(A47<=TermMonths,G46,"")
    Reads: Inputs!B5, Schedule!G46, Schedule!A47, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C47"] = xl.IF(schedule["A47"] <= book.name('TermMonths'), schedule["G46"], '')


def cell_g47(book: FrameBook) -> None:
    r"""Schedule!G47

    Schedule!G47 (one cell).
    Excel (G47): =IF(A47<=TermMonths,C47-F47,"")
    Reads: Inputs!B5, Schedule!A47, Schedule!C47, Schedule!F47, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G47"] = xl.IF(schedule["A47"] <= book.name('TermMonths'), schedule["C47"] - schedule["F47"], '')


def cell_c48(book: FrameBook) -> None:
    r"""Schedule!C48

    Schedule!C48 (one cell).
    Excel (C48): =IF(A48<=TermMonths,G47,"")
    Reads: Inputs!B5, Schedule!G47, Schedule!A48, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C48"] = xl.IF(schedule["A48"] <= book.name('TermMonths'), schedule["G47"], '')


def cell_g48(book: FrameBook) -> None:
    r"""Schedule!G48

    Schedule!G48 (one cell).
    Excel (G48): =IF(A48<=TermMonths,C48-F48,"")
    Reads: Inputs!B5, Schedule!A48, Schedule!C48, Schedule!F48, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G48"] = xl.IF(schedule["A48"] <= book.name('TermMonths'), schedule["C48"] - schedule["F48"], '')


def cell_c49(book: FrameBook) -> None:
    r"""Schedule!C49

    Schedule!C49 (one cell).
    Excel (C49): =IF(A49<=TermMonths,G48,"")
    Reads: Inputs!B5, Schedule!G48, Schedule!A49, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C49"] = xl.IF(schedule["A49"] <= book.name('TermMonths'), schedule["G48"], '')


def cell_g49(book: FrameBook) -> None:
    r"""Schedule!G49

    Schedule!G49 (one cell).
    Excel (G49): =IF(A49<=TermMonths,C49-F49,"")
    Reads: Inputs!B5, Schedule!A49, Schedule!C49, Schedule!F49, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G49"] = xl.IF(schedule["A49"] <= book.name('TermMonths'), schedule["C49"] - schedule["F49"], '')


def cell_c50(book: FrameBook) -> None:
    r"""Schedule!C50

    Schedule!C50 (one cell).
    Excel (C50): =IF(A50<=TermMonths,G49,"")
    Reads: Inputs!B5, Schedule!G49, Schedule!A50, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C50"] = xl.IF(schedule["A50"] <= book.name('TermMonths'), schedule["G49"], '')


def cell_g50(book: FrameBook) -> None:
    r"""Schedule!G50

    Schedule!G50 (one cell).
    Excel (G50): =IF(A50<=TermMonths,C50-F50,"")
    Reads: Inputs!B5, Schedule!A50, Schedule!C50, Schedule!F50, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G50"] = xl.IF(schedule["A50"] <= book.name('TermMonths'), schedule["C50"] - schedule["F50"], '')


def cell_c51(book: FrameBook) -> None:
    r"""Schedule!C51

    Schedule!C51 (one cell).
    Excel (C51): =IF(A51<=TermMonths,G50,"")
    Reads: Inputs!B5, Schedule!G50, Schedule!A51, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C51"] = xl.IF(schedule["A51"] <= book.name('TermMonths'), schedule["G50"], '')


def cell_g51(book: FrameBook) -> None:
    r"""Schedule!G51

    Schedule!G51 (one cell).
    Excel (G51): =IF(A51<=TermMonths,C51-F51,"")
    Reads: Inputs!B5, Schedule!A51, Schedule!C51, Schedule!F51, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G51"] = xl.IF(schedule["A51"] <= book.name('TermMonths'), schedule["C51"] - schedule["F51"], '')


def cell_c52(book: FrameBook) -> None:
    r"""Schedule!C52

    Schedule!C52 (one cell).
    Excel (C52): =IF(A52<=TermMonths,G51,"")
    Reads: Inputs!B5, Schedule!G51, Schedule!A52, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C52"] = xl.IF(schedule["A52"] <= book.name('TermMonths'), schedule["G51"], '')


def cell_g52(book: FrameBook) -> None:
    r"""Schedule!G52

    Schedule!G52 (one cell).
    Excel (G52): =IF(A52<=TermMonths,C52-F52,"")
    Reads: Inputs!B5, Schedule!A52, Schedule!C52, Schedule!F52, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G52"] = xl.IF(schedule["A52"] <= book.name('TermMonths'), schedule["C52"] - schedule["F52"], '')


def cell_c53(book: FrameBook) -> None:
    r"""Schedule!C53

    Schedule!C53 (one cell).
    Excel (C53): =IF(A53<=TermMonths,G52,"")
    Reads: Inputs!B5, Schedule!G52, Schedule!A53, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C53"] = xl.IF(schedule["A53"] <= book.name('TermMonths'), schedule["G52"], '')


def cell_g53(book: FrameBook) -> None:
    r"""Schedule!G53

    Schedule!G53 (one cell).
    Excel (G53): =IF(A53<=TermMonths,C53-F53,"")
    Reads: Inputs!B5, Schedule!A53, Schedule!C53, Schedule!F53, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G53"] = xl.IF(schedule["A53"] <= book.name('TermMonths'), schedule["C53"] - schedule["F53"], '')


def cell_c54(book: FrameBook) -> None:
    r"""Schedule!C54

    Schedule!C54 (one cell).
    Excel (C54): =IF(A54<=TermMonths,G53,"")
    Reads: Inputs!B5, Schedule!G53, Schedule!A54, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C54"] = xl.IF(schedule["A54"] <= book.name('TermMonths'), schedule["G53"], '')


def cell_g54(book: FrameBook) -> None:
    r"""Schedule!G54

    Schedule!G54 (one cell).
    Excel (G54): =IF(A54<=TermMonths,C54-F54,"")
    Reads: Inputs!B5, Schedule!A54, Schedule!C54, Schedule!F54, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G54"] = xl.IF(schedule["A54"] <= book.name('TermMonths'), schedule["C54"] - schedule["F54"], '')


def cell_c55(book: FrameBook) -> None:
    r"""Schedule!C55

    Schedule!C55 (one cell).
    Excel (C55): =IF(A55<=TermMonths,G54,"")
    Reads: Inputs!B5, Schedule!G54, Schedule!A55, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C55"] = xl.IF(schedule["A55"] <= book.name('TermMonths'), schedule["G54"], '')


def cell_g55(book: FrameBook) -> None:
    r"""Schedule!G55

    Schedule!G55 (one cell).
    Excel (G55): =IF(A55<=TermMonths,C55-F55,"")
    Reads: Inputs!B5, Schedule!A55, Schedule!C55, Schedule!F55, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G55"] = xl.IF(schedule["A55"] <= book.name('TermMonths'), schedule["C55"] - schedule["F55"], '')


def cell_c56(book: FrameBook) -> None:
    r"""Schedule!C56

    Schedule!C56 (one cell).
    Excel (C56): =IF(A56<=TermMonths,G55,"")
    Reads: Inputs!B5, Schedule!G55, Schedule!A56, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C56"] = xl.IF(schedule["A56"] <= book.name('TermMonths'), schedule["G55"], '')


def cell_g56(book: FrameBook) -> None:
    r"""Schedule!G56

    Schedule!G56 (one cell).
    Excel (G56): =IF(A56<=TermMonths,C56-F56,"")
    Reads: Inputs!B5, Schedule!A56, Schedule!C56, Schedule!F56, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G56"] = xl.IF(schedule["A56"] <= book.name('TermMonths'), schedule["C56"] - schedule["F56"], '')


def cell_c57(book: FrameBook) -> None:
    r"""Schedule!C57

    Schedule!C57 (one cell).
    Excel (C57): =IF(A57<=TermMonths,G56,"")
    Reads: Inputs!B5, Schedule!G56, Schedule!A57, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C57"] = xl.IF(schedule["A57"] <= book.name('TermMonths'), schedule["G56"], '')


def cell_g57(book: FrameBook) -> None:
    r"""Schedule!G57

    Schedule!G57 (one cell).
    Excel (G57): =IF(A57<=TermMonths,C57-F57,"")
    Reads: Inputs!B5, Schedule!A57, Schedule!C57, Schedule!F57, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G57"] = xl.IF(schedule["A57"] <= book.name('TermMonths'), schedule["C57"] - schedule["F57"], '')


def cell_c58(book: FrameBook) -> None:
    r"""Schedule!C58

    Schedule!C58 (one cell).
    Excel (C58): =IF(A58<=TermMonths,G57,"")
    Reads: Inputs!B5, Schedule!G57, Schedule!A58, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C58"] = xl.IF(schedule["A58"] <= book.name('TermMonths'), schedule["G57"], '')


def cell_g58(book: FrameBook) -> None:
    r"""Schedule!G58

    Schedule!G58 (one cell).
    Excel (G58): =IF(A58<=TermMonths,C58-F58,"")
    Reads: Inputs!B5, Schedule!A58, Schedule!C58, Schedule!F58, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G58"] = xl.IF(schedule["A58"] <= book.name('TermMonths'), schedule["C58"] - schedule["F58"], '')


def cell_c59(book: FrameBook) -> None:
    r"""Schedule!C59

    Schedule!C59 (one cell).
    Excel (C59): =IF(A59<=TermMonths,G58,"")
    Reads: Inputs!B5, Schedule!G58, Schedule!A59, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C59"] = xl.IF(schedule["A59"] <= book.name('TermMonths'), schedule["G58"], '')


def cell_g59(book: FrameBook) -> None:
    r"""Schedule!G59

    Schedule!G59 (one cell).
    Excel (G59): =IF(A59<=TermMonths,C59-F59,"")
    Reads: Inputs!B5, Schedule!A59, Schedule!C59, Schedule!F59, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G59"] = xl.IF(schedule["A59"] <= book.name('TermMonths'), schedule["C59"] - schedule["F59"], '')


def cell_c60(book: FrameBook) -> None:
    r"""Schedule!C60

    Schedule!C60 (one cell).
    Excel (C60): =IF(A60<=TermMonths,G59,"")
    Reads: Inputs!B5, Schedule!G59, Schedule!A60, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C60"] = xl.IF(schedule["A60"] <= book.name('TermMonths'), schedule["G59"], '')


def cell_g60(book: FrameBook) -> None:
    r"""Schedule!G60

    Schedule!G60 (one cell).
    Excel (G60): =IF(A60<=TermMonths,C60-F60,"")
    Reads: Inputs!B5, Schedule!A60, Schedule!C60, Schedule!F60, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G60"] = xl.IF(schedule["A60"] <= book.name('TermMonths'), schedule["C60"] - schedule["F60"], '')


def cell_c61(book: FrameBook) -> None:
    r"""Schedule!C61

    Schedule!C61 (one cell).
    Excel (C61): =IF(A61<=TermMonths,G60,"")
    Reads: Inputs!B5, Schedule!G60, Schedule!A61, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C61"] = xl.IF(schedule["A61"] <= book.name('TermMonths'), schedule["G60"], '')


def cell_g61(book: FrameBook) -> None:
    r"""Schedule!G61

    Schedule!G61 (one cell).
    Excel (G61): =IF(A61<=TermMonths,C61-F61,"")
    Reads: Inputs!B5, Schedule!A61, Schedule!C61, Schedule!F61, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G61"] = xl.IF(schedule["A61"] <= book.name('TermMonths'), schedule["C61"] - schedule["F61"], '')


def cell_c62(book: FrameBook) -> None:
    r"""Schedule!C62

    Schedule!C62 (one cell).
    Excel (C62): =IF(A62<=TermMonths,G61,"")
    Reads: Inputs!B5, Schedule!G61, Schedule!A62, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C62"] = xl.IF(schedule["A62"] <= book.name('TermMonths'), schedule["G61"], '')


def cell_g62(book: FrameBook) -> None:
    r"""Schedule!G62

    Schedule!G62 (one cell).
    Excel (G62): =IF(A62<=TermMonths,C62-F62,"")
    Reads: Inputs!B5, Schedule!A62, Schedule!C62, Schedule!F62, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G62"] = xl.IF(schedule["A62"] <= book.name('TermMonths'), schedule["C62"] - schedule["F62"], '')


def cell_c63(book: FrameBook) -> None:
    r"""Schedule!C63

    Schedule!C63 (one cell).
    Excel (C63): =IF(A63<=TermMonths,G62,"")
    Reads: Inputs!B5, Schedule!G62, Schedule!A63, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C63"] = xl.IF(schedule["A63"] <= book.name('TermMonths'), schedule["G62"], '')


def cell_g63(book: FrameBook) -> None:
    r"""Schedule!G63

    Schedule!G63 (one cell).
    Excel (G63): =IF(A63<=TermMonths,C63-F63,"")
    Reads: Inputs!B5, Schedule!A63, Schedule!C63, Schedule!F63, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G63"] = xl.IF(schedule["A63"] <= book.name('TermMonths'), schedule["C63"] - schedule["F63"], '')


def cell_c64(book: FrameBook) -> None:
    r"""Schedule!C64

    Schedule!C64 (one cell).
    Excel (C64): =IF(A64<=TermMonths,G63,"")
    Reads: Inputs!B5, Schedule!G63, Schedule!A64, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C64"] = xl.IF(schedule["A64"] <= book.name('TermMonths'), schedule["G63"], '')


def cell_g64(book: FrameBook) -> None:
    r"""Schedule!G64

    Schedule!G64 (one cell).
    Excel (G64): =IF(A64<=TermMonths,C64-F64,"")
    Reads: Inputs!B5, Schedule!A64, Schedule!C64, Schedule!F64, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G64"] = xl.IF(schedule["A64"] <= book.name('TermMonths'), schedule["C64"] - schedule["F64"], '')


def cell_c65(book: FrameBook) -> None:
    r"""Schedule!C65

    Schedule!C65 (one cell).
    Excel (C65): =IF(A65<=TermMonths,G64,"")
    Reads: Inputs!B5, Schedule!G64, Schedule!A65, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C65"] = xl.IF(schedule["A65"] <= book.name('TermMonths'), schedule["G64"], '')


def cell_g65(book: FrameBook) -> None:
    r"""Schedule!G65

    Schedule!G65 (one cell).
    Excel (G65): =IF(A65<=TermMonths,C65-F65,"")
    Reads: Inputs!B5, Schedule!A65, Schedule!C65, Schedule!F65, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G65"] = xl.IF(schedule["A65"] <= book.name('TermMonths'), schedule["C65"] - schedule["F65"], '')


def cell_c66(book: FrameBook) -> None:
    r"""Schedule!C66

    Schedule!C66 (one cell).
    Excel (C66): =IF(A66<=TermMonths,G65,"")
    Reads: Inputs!B5, Schedule!G65, Schedule!A66, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C66"] = xl.IF(schedule["A66"] <= book.name('TermMonths'), schedule["G65"], '')


def cell_g66(book: FrameBook) -> None:
    r"""Schedule!G66

    Schedule!G66 (one cell).
    Excel (G66): =IF(A66<=TermMonths,C66-F66,"")
    Reads: Inputs!B5, Schedule!A66, Schedule!C66, Schedule!F66, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G66"] = xl.IF(schedule["A66"] <= book.name('TermMonths'), schedule["C66"] - schedule["F66"], '')


def cell_c67(book: FrameBook) -> None:
    r"""Schedule!C67

    Schedule!C67 (one cell).
    Excel (C67): =IF(A67<=TermMonths,G66,"")
    Reads: Inputs!B5, Schedule!G66, Schedule!A67, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C67"] = xl.IF(schedule["A67"] <= book.name('TermMonths'), schedule["G66"], '')


def cell_g67(book: FrameBook) -> None:
    r"""Schedule!G67

    Schedule!G67 (one cell).
    Excel (G67): =IF(A67<=TermMonths,C67-F67,"")
    Reads: Inputs!B5, Schedule!A67, Schedule!C67, Schedule!F67, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G67"] = xl.IF(schedule["A67"] <= book.name('TermMonths'), schedule["C67"] - schedule["F67"], '')


def cell_c68(book: FrameBook) -> None:
    r"""Schedule!C68

    Schedule!C68 (one cell).
    Excel (C68): =IF(A68<=TermMonths,G67,"")
    Reads: Inputs!B5, Schedule!G67, Schedule!A68, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C68"] = xl.IF(schedule["A68"] <= book.name('TermMonths'), schedule["G67"], '')


def cell_g68(book: FrameBook) -> None:
    r"""Schedule!G68

    Schedule!G68 (one cell).
    Excel (G68): =IF(A68<=TermMonths,C68-F68,"")
    Reads: Inputs!B5, Schedule!A68, Schedule!C68, Schedule!F68, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G68"] = xl.IF(schedule["A68"] <= book.name('TermMonths'), schedule["C68"] - schedule["F68"], '')


def cell_c69(book: FrameBook) -> None:
    r"""Schedule!C69

    Schedule!C69 (one cell).
    Excel (C69): =IF(A69<=TermMonths,G68,"")
    Reads: Inputs!B5, Schedule!G68, Schedule!A69, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C69"] = xl.IF(schedule["A69"] <= book.name('TermMonths'), schedule["G68"], '')


def cell_g69(book: FrameBook) -> None:
    r"""Schedule!G69

    Schedule!G69 (one cell).
    Excel (G69): =IF(A69<=TermMonths,C69-F69,"")
    Reads: Inputs!B5, Schedule!A69, Schedule!C69, Schedule!F69, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G69"] = xl.IF(schedule["A69"] <= book.name('TermMonths'), schedule["C69"] - schedule["F69"], '')


def cell_c70(book: FrameBook) -> None:
    r"""Schedule!C70

    Schedule!C70 (one cell).
    Excel (C70): =IF(A70<=TermMonths,G69,"")
    Reads: Inputs!B5, Schedule!G69, Schedule!A70, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C70"] = xl.IF(schedule["A70"] <= book.name('TermMonths'), schedule["G69"], '')


def cell_g70(book: FrameBook) -> None:
    r"""Schedule!G70

    Schedule!G70 (one cell).
    Excel (G70): =IF(A70<=TermMonths,C70-F70,"")
    Reads: Inputs!B5, Schedule!A70, Schedule!C70, Schedule!F70, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G70"] = xl.IF(schedule["A70"] <= book.name('TermMonths'), schedule["C70"] - schedule["F70"], '')


def cell_c71(book: FrameBook) -> None:
    r"""Schedule!C71

    Schedule!C71 (one cell).
    Excel (C71): =IF(A71<=TermMonths,G70,"")
    Reads: Inputs!B5, Schedule!G70, Schedule!A71, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C71"] = xl.IF(schedule["A71"] <= book.name('TermMonths'), schedule["G70"], '')


def cell_g71(book: FrameBook) -> None:
    r"""Schedule!G71

    Schedule!G71 (one cell).
    Excel (G71): =IF(A71<=TermMonths,C71-F71,"")
    Reads: Inputs!B5, Schedule!A71, Schedule!C71, Schedule!F71, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G71"] = xl.IF(schedule["A71"] <= book.name('TermMonths'), schedule["C71"] - schedule["F71"], '')


def cell_c72(book: FrameBook) -> None:
    r"""Schedule!C72

    Schedule!C72 (one cell).
    Excel (C72): =IF(A72<=TermMonths,G71,"")
    Reads: Inputs!B5, Schedule!G71, Schedule!A72, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C72"] = xl.IF(schedule["A72"] <= book.name('TermMonths'), schedule["G71"], '')


def cell_g72(book: FrameBook) -> None:
    r"""Schedule!G72

    Schedule!G72 (one cell).
    Excel (G72): =IF(A72<=TermMonths,C72-F72,"")
    Reads: Inputs!B5, Schedule!A72, Schedule!C72, Schedule!F72, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G72"] = xl.IF(schedule["A72"] <= book.name('TermMonths'), schedule["C72"] - schedule["F72"], '')


def cell_c73(book: FrameBook) -> None:
    r"""Schedule!C73

    Schedule!C73 (one cell).
    Excel (C73): =IF(A73<=TermMonths,G72,"")
    Reads: Inputs!B5, Schedule!G72, Schedule!A73, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C73"] = xl.IF(schedule["A73"] <= book.name('TermMonths'), schedule["G72"], '')


def cell_g73(book: FrameBook) -> None:
    r"""Schedule!G73

    Schedule!G73 (one cell).
    Excel (G73): =IF(A73<=TermMonths,C73-F73,"")
    Reads: Inputs!B5, Schedule!A73, Schedule!C73, Schedule!F73, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G73"] = xl.IF(schedule["A73"] <= book.name('TermMonths'), schedule["C73"] - schedule["F73"], '')


def cell_c74(book: FrameBook) -> None:
    r"""Schedule!C74

    Schedule!C74 (one cell).
    Excel (C74): =IF(A74<=TermMonths,G73,"")
    Reads: Inputs!B5, Schedule!G73, Schedule!A74, name TermMonths
    """
    schedule = book['Schedule']
    schedule["C74"] = xl.IF(schedule["A74"] <= book.name('TermMonths'), schedule["G73"], '')


def cell_g74(book: FrameBook) -> None:
    r"""Schedule!G74

    Schedule!G74 (one cell).
    Excel (G74): =IF(A74<=TermMonths,C74-F74,"")
    Reads: Inputs!B5, Schedule!A74, Schedule!C74, Schedule!F74, name TermMonths
    """
    schedule = book['Schedule']
    schedule["G74"] = xl.IF(schedule["A74"] <= book.name('TermMonths'), schedule["C74"] - schedule["F74"], '')