{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ri-eli-subsidy-projection-2026",
    "name": "RIHousing ELI One-Bedroom Subsidy Projection",
    "workbook": {
      "uri": "2026-Section-14.b-RIH-ELI-projection-grid-for-2025-RFP.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "ces_units",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!C9"
      },
      "schema": {
        "type": "integer"
      },
      "description": "Count of one-bedroom units with Coordinated Entry System referrals, nonnegative integer. Other bedroom sizes remain publisher blank.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "ces_rent_30",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!D9"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month: current local 30% AMI rent limit for CES one-bedroom units, nonnegative. Supply with ces_units and ces_rent_60.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "ces_rent_60",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!F9"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month: current local 60% AMI rent limit for CES one-bedroom units, nonnegative. Supply with ces_units and ces_rent_30.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "nonces_units",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!C16"
      },
      "schema": {
        "type": "integer"
      },
      "description": "Count of one-bedroom units without CES referrals, nonnegative integer. Other bedroom sizes remain publisher blank.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "nonces_rent_30",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!D16"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month: current local 30% AMI rent limit for non-CES one-bedroom units, nonnegative. Supply with nonces_units and nonces_rent_50.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "nonces_rent_50",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!E16"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per unit per month: current local 50% AMI rent limit for non-CES one-bedroom units, nonnegative. Supply with nonces_units and nonces_rent_30.",
      "constraints": {
        "min": 0
      },
      "default": 0
    },
    {
      "id": "total_units",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!C23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Count of requested one-bedroom units; all other bedroom rows remain blank."
    },
    {
      "id": "deficit_year1",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calculate cumulative assistnce'!B3"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD first-year rent deficit, positive when higher AMI rents exceed 30% rents."
    },
    {
      "id": "deficit_5_years",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calculate cumulative assistnce'!B7"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD cumulative nominal rent deficit over 5 years, 3% annual escalation after year 1, no discounting."
    },
    {
      "id": "deficit_15_years",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Request Summary'!B24"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD cumulative nominal rent deficit over 15 years, 3% annual escalation after year 1, no discounting."
    }
  ]
}
