"""Formulas from sheet 'RateCard' of 'pricing_calculator.xlsx'.

Generated by Power Migrate 0.1.0a1 (no-AI mode). One function per
logic block, in the order they appear on the sheet; ``model.compute``
runs them in dependency order.
"""

from .. import xl
from ..xl import Book


def selected_margin_bps(book: Book) -> None:
    r"""Selected margin (bps)

    RateCard!B10 (one cell).
    Excel (B10): =INDEX(B3:F7,MATCH(Inputs!B9,A3:A7,0),MATCH(Inputs!B5,B2:F2,0))
    Reads: Inputs!B5, Inputs!B9, RateCard!B2:F2, RateCard!A3:A7, RateCard!B3:F7
    """
    rate_card = book['RateCard']
    inputs = book['Inputs']
    rate_card["B10"] = xl.INDEX(rate_card["B3:F7"], xl.MATCH(inputs["B9"], rate_card["A3:A7"], 0), xl.MATCH(inputs["B5"], rate_card["B2:F2"], 0))


def base_rate(book: Book) -> None:
    r"""Base rate

    RateCard!B11 (one cell).
    Excel (B11): =_xlfn.XLOOKUP(Inputs!B5,H3:H7,I3:I7,"n/a")
    Reads: Inputs!B5, RateCard!H3:H7, RateCard!I3:I7
    """
    rate_card = book['RateCard']
    inputs = book['Inputs']
    rate_card["B11"] = xl.XLOOKUP(inputs["B5"], rate_card["H3:H7"], rate_card["I3:I7"], 'n/a')


def customer_apr(book: Book) -> None:
    r"""Customer APR

    RateCard!B12 (one cell).
    Excel (B12): =B11+B10/10000
    Reads: RateCard!B10, RateCard!B11
    """
    rate_card = book['RateCard']
    rate_card["B12"] = rate_card["B11"] + rate_card["B10"] / 10000


def monthly_rate(book: Book) -> None:
    r"""Monthly rate

    RateCard!B13 (one cell).
    Excel (B13): =B12/12
    Reads: RateCard!B12
    """
    rate_card = book['RateCard']
    rate_card["B13"] = rate_card["B12"] / 12