{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ksu-crop-budgets-leasing-2026",
    "name": "Kansas State 2026 Crop Budgets and Flexible Leases",
    "description": "Compare Kansas publisher crop budgets, cash/share returns and a deterministic price-flex lease scenario. Monte Carlo distributions and simulation summaries are excluded.",
    "workbook": {
      "uri": "ksu-crop-budgets-2026.xlsm",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "crop_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E5"
      },
      "schema": {
        "type": "string"
      },
      "description": "Exact publisher budget name; trailing underscore is significant Default: Corn - North Central KS_.",
      "default": "Corn - North Central KS_",
      "constraints": {
        "enum": [
          "None",
          "Alfalfa - Northwest KS_",
          "Alfalfa - Southeast KS_",
          "Alfalfa - Southwest KS_",
          "Alfalfa - Western KS_Irrigated",
          "Canola - South Central KS_",
          "Canola - Southwest KS_Irrigated",
          "Corn - North Central KS_",
          "Corn - North Central KS_Irrigated",
          "Corn - Northeast KS_",
          "Corn - Northwest KS_Irrigated",
          "Corn - Northwest KS_W-C-F rotation",
          "Corn - South Central KS_",
          "Corn - South Central KS_Irrigated",
          "Corn - Southeast KS_",
          "Corn - Southwest KS_Irrigated",
          "Corn - Southwest KS_W-C-F rotation",
          "Corn Silage - Northeast KS_",
          "Cotton - South Central KS_",
          "Cotton - Southeast KS_Irrigated",
          "Cotton - Southwest KS_Irrigated",
          "Cotton - Southwest KS_W-CT-F rotation",
          "Forage Sorghum Hay - Western KS_W-H-F",
          "Forage Sorghum Silage - South Central KS_",
          "Grain Sorghum - North Central KS_",
          "Grain Sorghum - North Central KS_Irrigated",
          "Grain Sorghum - Northeast KS_",
          "Grain Sorghum - Northwest KS_Irrigated",
          "Grain Sorghum - Northwest KS_W-S-F rotation",
          "Grain Sorghum - South Central KS_",
          "Grain Sorghum - South Central KS_Irrigated",
          "Grain Sorghum - Southeast KS_",
          "Grain Sorghum - Southwest KS_Irrigated",
          "Grain Sorghum - Southwest KS_W-S-F rotation",
          "Soybeans - North Central KS_",
          "Soybeans - North Central KS_Irrigated",
          "Soybeans - Northeast KS_",
          "Soybeans - Northwest KS_Irrigated",
          "Soybeans - Northwest KS_W-SB_F rotation",
          "Soybeans - South Central KS_",
          "Soybeans - South Central KS_Irrigated",
          "Soybeans - Southeast KS_",
          "Soybeans - Southeast KS_Double crop",
          "Soybeans - Southwest KS_Irrigated",
          "Soybeans - Southwest KS_W-SB-F rotation",
          "Sunflower (confectionary) - Double crop - Western KS_Irrigated - double crop",
          "Sunflower (Confectionary) - Western KS_Irrigated",
          "Sunflower (Confectionary) - Western KS_W-SF-F rotation",
          "Sunflower (oil-type) - Central and Eastern_Double crop",
          "Sunflower (oil-type) - Double crop - Western KS_Irrigated - double crop",
          "Sunflower (oil-type) - Eastern KS_",
          "Sunflower (oil-type) - Western KS_Irrigated",
          "Sunflower (oil-type) - Western KS_W-SF-F rotation",
          "Wheat - North Central KS_Continuous",
          "Wheat - North Central KS_Rotation",
          "Wheat - Northeast KS_Continuous",
          "Wheat - Northeast KS_Rotation",
          "Wheat - Northwest KS_W-F rotation",
          "Wheat - Northwest KS_W-S_C-F rotation",
          "Wheat - South Central KS_Continuous",
          "Wheat - South Central KS_Rotation",
          "Wheat - Southeast KS_",
          "Wheat - Southwest KS_W-F rotation",
          "Wheat - Southwest KS_W-S_C-F rotation",
          "Wheat - Western KS_Irrigated",
          "Wheat, Durum - Western KS_",
          "Wheat, Durum - Western KS_Irrigated",
          "None"
        ]
      }
    },
    {
      "id": "crop_1_acres",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!C5"
      },
      "schema": {
        "type": "number"
      },
      "description": "Planted acres, positive acreage required Default: 1.",
      "default": 1,
      "constraints": {
        "min": 0.01
      }
    },
    {
      "id": "yield_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!F16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Yield override in crop units per acre (corn: bushels/acre); null retains publisher budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "price_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!F17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Selling price override in USD per crop unit; null retains budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "cash_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!C58"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD per acre cash rent Default: 70.",
      "default": 70,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "operating_interest_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!W3"
      },
      "schema": {
        "type": "number"
      },
      "description": "Annual decimal fraction applied to half direct costs Default: 0.076.",
      "default": 0.076,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "tenant_share",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!Z6"
      },
      "schema": {
        "type": "number"
      },
      "description": "Tenant crop share decimal fraction Default: 0.66.",
      "default": 0.66,
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "seed_cost_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!F22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Seed expense override USD/acre; null retains budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "fertilizer_cost_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!F23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Fertilizer expense override USD/acre; null retains budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "lease_base_rent",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Flex leases'!D46"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/acre base rent for price-flex contract Default: 70.",
      "default": 70,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "lease_base_price",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Flex leases'!D51"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/unit base price, must be positive Default: 5.5.",
      "default": 5.5,
      "constraints": {
        "min": 0.01
      }
    },
    {
      "id": "lease_actual_price",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Flex leases'!W6"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD/unit actual scenario price; deterministic single draw replaces Monte Carlo Default: 3.",
      "default": 3,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "lease_allow_downward_price",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Flex leases'!D48"
      },
      "schema": {
        "type": "string"
      },
      "description": "Exact y/n allowing price-flex rent below base Default: n.",
      "default": "n",
      "constraints": {
        "enum": [
          "y",
          "n"
        ]
      }
    },
    {
      "id": "crop_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E6"
      },
      "schema": {
        "type": "string"
      },
      "description": "Exact second publisher budget name or None Default: None.",
      "default": "None",
      "constraints": {
        "enum": [
          "None",
          "Alfalfa - Northwest KS_",
          "Alfalfa - Southeast KS_",
          "Alfalfa - Southwest KS_",
          "Alfalfa - Western KS_Irrigated",
          "Canola - South Central KS_",
          "Canola - Southwest KS_Irrigated",
          "Corn - North Central KS_",
          "Corn - North Central KS_Irrigated",
          "Corn - Northeast KS_",
          "Corn - Northwest KS_Irrigated",
          "Corn - Northwest KS_W-C-F rotation",
          "Corn - South Central KS_",
          "Corn - South Central KS_Irrigated",
          "Corn - Southeast KS_",
          "Corn - Southwest KS_Irrigated",
          "Corn - Southwest KS_W-C-F rotation",
          "Corn Silage - Northeast KS_",
          "Cotton - South Central KS_",
          "Cotton - Southeast KS_Irrigated",
          "Cotton - Southwest KS_Irrigated",
          "Cotton - Southwest KS_W-CT-F rotation",
          "Forage Sorghum Hay - Western KS_W-H-F",
          "Forage Sorghum Silage - South Central KS_",
          "Grain Sorghum - North Central KS_",
          "Grain Sorghum - North Central KS_Irrigated",
          "Grain Sorghum - Northeast KS_",
          "Grain Sorghum - Northwest KS_Irrigated",
          "Grain Sorghum - Northwest KS_W-S-F rotation",
          "Grain Sorghum - South Central KS_",
          "Grain Sorghum - South Central KS_Irrigated",
          "Grain Sorghum - Southeast KS_",
          "Grain Sorghum - Southwest KS_Irrigated",
          "Grain Sorghum - Southwest KS_W-S-F rotation",
          "Soybeans - North Central KS_",
          "Soybeans - North Central KS_Irrigated",
          "Soybeans - Northeast KS_",
          "Soybeans - Northwest KS_Irrigated",
          "Soybeans - Northwest KS_W-SB_F rotation",
          "Soybeans - South Central KS_",
          "Soybeans - South Central KS_Irrigated",
          "Soybeans - Southeast KS_",
          "Soybeans - Southeast KS_Double crop",
          "Soybeans - Southwest KS_Irrigated",
          "Soybeans - Southwest KS_W-SB-F rotation",
          "Sunflower (confectionary) - Double crop - Western KS_Irrigated - double crop",
          "Sunflower (Confectionary) - Western KS_Irrigated",
          "Sunflower (Confectionary) - Western KS_W-SF-F rotation",
          "Sunflower (oil-type) - Central and Eastern_Double crop",
          "Sunflower (oil-type) - Double crop - Western KS_Irrigated - double crop",
          "Sunflower (oil-type) - Eastern KS_",
          "Sunflower (oil-type) - Western KS_Irrigated",
          "Sunflower (oil-type) - Western KS_W-SF-F rotation",
          "Wheat - North Central KS_Continuous",
          "Wheat - North Central KS_Rotation",
          "Wheat - Northeast KS_Continuous",
          "Wheat - Northeast KS_Rotation",
          "Wheat - Northwest KS_W-F rotation",
          "Wheat - Northwest KS_W-S_C-F rotation",
          "Wheat - South Central KS_Continuous",
          "Wheat - South Central KS_Rotation",
          "Wheat - Southeast KS_",
          "Wheat - Southwest KS_W-F rotation",
          "Wheat - Southwest KS_W-S_C-F rotation",
          "Wheat - Western KS_Irrigated",
          "Wheat, Durum - Western KS_",
          "Wheat, Durum - Western KS_Irrigated",
          "None"
        ]
      }
    },
    {
      "id": "crop_2_acres",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!C6"
      },
      "schema": {
        "type": "number"
      },
      "description": "Planted acres for second crop; blank source treated as zero Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "yield_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!I16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Second crop yield override in crop units/acre; null retains budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "price_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!I17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Second crop price override USD/crop unit; null retains budget Default: None.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "fallow_acres",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!C10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Fallow acres included in tillable denominator Default: 0.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "crop_1_revenue",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Gross crop revenue USD/planted acre"
    },
    {
      "id": "crop_1_direct_cost",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E45"
      },
      "schema": {
        "type": "number"
      },
      "description": "Direct expenses including interest USD/planted acre"
    },
    {
      "id": "crop_1_total_cost",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E61"
      },
      "schema": {
        "type": "number"
      },
      "description": "Total specified costs USD/planted acre"
    },
    {
      "id": "crop_1_net_return",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E65"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed return above specified costs USD/planted acre"
    },
    {
      "id": "crop_1_breakeven_price",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!E68"
      },
      "schema": {
        "type": "number"
      },
      "description": "Breakeven USD/crop unit"
    },
    {
      "id": "price_flex_rent",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Calc for flex leases'!H36"
      },
      "schema": {
        "type": "number"
      },
      "description": "Price-flex landlord rent USD/tillable acre for supplied deterministic actual price"
    },
    {
      "id": "farm_cash_net_return",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!V65"
      },
      "schema": {
        "type": "number"
      },
      "description": "Cash-lease tenant signed return USD/tillable acre"
    },
    {
      "id": "share_tenant_net_return",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!Z65"
      },
      "schema": {
        "type": "number"
      },
      "description": "Share-lease tenant signed return USD/tillable acre"
    },
    {
      "id": "share_landlord_net_return",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!AA65"
      },
      "schema": {
        "type": "number"
      },
      "description": "Share-lease landlord signed return USD/tillable acre"
    },
    {
      "id": "crop_2_revenue",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!H19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Second crop gross revenue USD/planted acre; zero when inactive"
    },
    {
      "id": "crop_2_net_return",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Budgets'!H65"
      },
      "schema": {
        "type": "number"
      },
      "description": "Second crop signed net return USD/planted acre; zero when inactive"
    }
  ]
}
