Calculates effin interest

effinInt.EXCEL.yaml

name: effinInt
description: Calculates effin interest
host: EXCEL
api_set: {}
script:
  content: |
    /**
     
    /* @CustomFunction */
    function effIntPayPrd(nom_annaul_rate, num_int_periods, num_pay_periods) {
      let rck = nom_annaul_rate / (num_int_periods * num_pay_periods);
      return Math.pow(1 + rck, num_int_periods) - 1;
    };
  language: typescript
template:
  content: |
    <p class="ms-font-m">Executes a simple code snippet.</p>
    <button id="run" class="ms-Button">
        <span class="ms-Button-label">Run code</span>
    </button>
  language: HTML
style:
  content: ''
  language: CSS
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js
  core-js@2.4.1/client/core.min.js