{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ky-withholding-tax-2026",
    "name": "Kentucky Withholding Tax Calculator 2026",
    "description": "Calculate Kentucky 2026 employer withholding from taxable wages and exact pay-frequency selections using the publisher's workbook.",
    "workbook": {
      "uri": "ky-withholding-2026.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "pay_frequency",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Calculation of Withholding'!B7"
      },
      "schema": {
        "type": "string"
      },
      "description": "Exact source enum: Monthly (12), Semi Monthly (24), Weekly (52), BI-Weekly (26), Daily (365), Annual (1). Source default blank/null; required with positive wages. No mode switch.",
      "default": null,
      "constraints": {
        "nullable": true,
        "enum": [
          "Monthly",
          "Semi Monthly",
          "Weekly",
          "BI-Weekly",
          "Daily",
          "Annual"
        ]
      }
    },
    {
      "id": "taxable_wages",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Calculation of Withholding'!C7"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD taxable wages for one pay period; source default blank/null treated as zero. Supply taxable wages after applicable payroll exclusions, not annual gross wages.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "employee_names",
      "dir": "in",
      "shape": "range",
      "location": {
        "a1": "'Calculation of Withholding'!A7:A2000"
      },
      "schema": {
        "kind": "range",
        "cell_type": "string"
      },
      "constraints": {
        "nullable": true
      },
      "description": "Optional 1994×1 employee labels; source blank. Labels have no tax effect. Row index 0 corresponds to Excel row 7."
    },
    {
      "id": "frequency_schedule",
      "dir": "in",
      "shape": "range",
      "location": {
        "a1": "'Calculation of Withholding'!B7:B2000"
      },
      "schema": {
        "kind": "range",
        "cell_type": "string"
      },
      "constraints": {
        "nullable": true,
        "enum": [
          "Monthly",
          "Semi Monthly",
          "Weekly",
          "BI-Weekly",
          "Daily",
          "Annual"
        ]
      },
      "description": "1994×1 exact frequency strings or null, rows 7–2000. Allowed nonblank values: Monthly, Semi Monthly, Weekly, BI-Weekly, Daily, Annual. Source cells blank. Positive wages require a frequency in the same row. Do not also set overlapping scalar pay_frequency in the same request."
    },
    {
      "id": "wages_schedule",
      "dir": "in",
      "shape": "range",
      "location": {
        "a1": "'Calculation of Withholding'!C7:C2000"
      },
      "schema": {
        "kind": "range",
        "cell_type": "number"
      },
      "constraints": {
        "nullable": true,
        "min": 0
      },
      "description": "1994×1 nonnegative USD per-period taxable wages or null, rows 7–2000; source blank. Do not also set overlapping scalar taxable_wages in the same request."
    },
    {
      "id": "withholding",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calculation of Withholding'!D7"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD withholding for row 7, unrounded source formula (display formats show cents). Runtime N(originalFormula) converts source display blanks to zero."
    },
    {
      "id": "second_employee_withholding",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calculation of Withholding'!D8"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD withholding for source row 8; full-flow diagnostic."
    },
    {
      "id": "last_employee_withholding",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calculation of Withholding'!D2000"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD withholding for source row 2000; full-flow boundary diagnostic."
    }
  ]
}
