{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "ncua-cecl-warm-2026-q3",
    "name": "NCUA Simplified CECL WARM — 2026 Q3",
    "description": "Source-preserving 13-segment allowance mapping. See catalog manifest runtimePreparation for Table5 import repair.",
    "workbook": {
      "uri": "Simplified CECL Model_V23a.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "credit_union_number",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C5"
      },
      "schema": {
        "type": "string"
      },
      "default": "Blank",
      "description": "Baseline literal Blank selects externally supplied loss-rate assumptions. Numeric CU charter selection requires cellOverrides on Tab 0 - Input!C5; numeric strings do not match numeric Data keys."
    },
    {
      "id": "total_assets",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C7"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      }
    },
    {
      "id": "credit_cards_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C10"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Unsecured Credit Card Loans"
    },
    {
      "id": "credit_cards_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B5"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "credit_cards_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D5"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "credit_cards_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C5"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "credit_cards_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E5"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "payday_alternative_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Payday Alternative Loans (PALs I and PALs II) (FCU Only)"
    },
    {
      "id": "payday_alternative_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B6"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "payday_alternative_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D6"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "payday_alternative_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C6"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "payday_alternative_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E6"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "student_loans_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C12"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Non-Federally Guaranteed Student Loans"
    },
    {
      "id": "student_loans_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B7"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "student_loans_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D7"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "student_loans_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C7"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "student_loans_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E7"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_unsecured_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C13"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "All Other Unsecured Loans/Lines of Credit"
    },
    {
      "id": "other_unsecured_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B8"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "other_unsecured_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D8"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "other_unsecured_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C8"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_unsecured_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E8"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "new_vehicle_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C14"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "New Vehicle Loans"
    },
    {
      "id": "new_vehicle_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B9"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "new_vehicle_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D9"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "new_vehicle_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C9"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "new_vehicle_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E9"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "used_vehicle_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C15"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Used Vehicle Loans"
    },
    {
      "id": "used_vehicle_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B10"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "used_vehicle_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D10"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "used_vehicle_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C10"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "used_vehicle_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E10"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "leases_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C16"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Leases Receivable"
    },
    {
      "id": "leases_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "leases_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D11"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "leases_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C11"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "leases_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E11"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_secured_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C17"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "All Other Secured Non-Real Estate Loans/Lines of Credit "
    },
    {
      "id": "other_secured_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B12"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "other_secured_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D12"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "other_secured_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C12"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_secured_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E12"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "first_lien_residential_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C18"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Secured by 1st Lien on a single 1- to 4-Family Residential Property"
    },
    {
      "id": "first_lien_residential_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B13"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "first_lien_residential_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D13"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "first_lien_residential_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C13"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "first_lien_residential_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E13"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "junior_lien_residential_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C19"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Secured by Junior Lien on a single 1- to 4-Family Residential Property"
    },
    {
      "id": "junior_lien_residential_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B14"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "junior_lien_residential_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D14"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "junior_lien_residential_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C14"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "junior_lien_residential_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E14"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_real_estate_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C20"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "All Other (Non-Commercial) Real Estate Loans/Lines of Credit "
    },
    {
      "id": "other_real_estate_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B15"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "other_real_estate_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D15"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "other_real_estate_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C15"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "other_real_estate_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E15"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "commercial_real_estate_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C21"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Commercial Loans/Lines of Credit Real Estate Secured"
    },
    {
      "id": "commercial_real_estate_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B16"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "commercial_real_estate_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D16"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "commercial_real_estate_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C16"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "commercial_real_estate_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E16"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "commercial_other_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 0 - Input'!C22"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "constraints": {
        "min": 0
      },
      "units": {
        "currency": "USD"
      },
      "description": "Commercial Loans/Lines of Credit Not Real Estate Secured"
    },
    {
      "id": "commercial_other_q_factor",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!B17"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive annual loss-rate adjustment as a decimal (0.01 = one percentage point). With Blank CU, this supplies the annual rate."
    },
    {
      "id": "commercial_other_warm_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!D17"
      },
      "schema": {
        "type": "number"
      },
      "default": 0,
      "description": "Additive adjustment to peer WARM, in years; signed."
    },
    {
      "id": "commercial_other_q_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!C17"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "commercial_other_warm_justification",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adjustments'!E17"
      },
      "schema": {
        "type": "string"
      },
      "default": null,
      "constraints": {
        "nullable": true
      },
      "description": "Baseline is an empty source cell."
    },
    {
      "id": "individual_loans",
      "dir": "in",
      "shape": "table",
      "location": {
        "table": {
          "name": "Table5",
          "area": "body"
        }
      },
      "schema": {
        "kind": "table",
        "columns": [
          {
            "name": "Column1",
            "type": "string"
          },
          {
            "name": "Column2",
            "type": "string"
          },
          {
            "name": "Column6",
            "type": "string"
          },
          {
            "name": "Column3",
            "type": "number"
          },
          {
            "name": "Column4",
            "type": "number"
          }
        ]
      },
      "default": [
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        },
        {
          "Column1": null,
          "Column2": null,
          "Column6": null,
          "Column3": null,
          "Column4": null
        }
      ],
      "constraints": {
        "nullable": true
      },
      "description": "Fixed 66-row table body, source Table5 input columns A:E. Supply all rows (pad unused rows with nulls); F remains the source formula. Exact segment text must match Tab 2 A6:A18. Note numbers are text. No resizing."
    },
    {
      "id": "total_loan_balance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!B19"
      },
      "schema": {
        "type": "number"
      }
    },
    {
      "id": "individual_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!C19"
      },
      "schema": {
        "type": "number"
      }
    },
    {
      "id": "pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D19"
      },
      "schema": {
        "type": "number"
      }
    },
    {
      "id": "total_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!E19"
      },
      "schema": {
        "type": "number"
      }
    },
    {
      "id": "reserve_ratio",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!F19"
      },
      "schema": {
        "type": "number"
      }
    },
    {
      "id": "allowance_summary",
      "dir": "out",
      "shape": "record",
      "location": {
        "a1": "'Tab 1 - Summary'!B19:F19"
      },
      "schema": {
        "kind": "record",
        "fields": {
          "total_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B19"
            }
          },
          "individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C19"
            }
          },
          "pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D19"
            }
          },
          "total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E19"
            }
          },
          "reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F19"
            }
          }
        }
      }
    },
    {
      "id": "segment_summary",
      "dir": "out",
      "shape": "record",
      "location": {
        "a1": "'Tab 1 - Summary'!A6:F18"
      },
      "schema": {
        "kind": "record",
        "fields": {
          "credit_cards_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A6"
            }
          },
          "credit_cards_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B6"
            }
          },
          "credit_cards_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C6"
            }
          },
          "credit_cards_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D6"
            }
          },
          "credit_cards_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E6"
            }
          },
          "credit_cards_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F6"
            }
          },
          "payday_alternative_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A7"
            }
          },
          "payday_alternative_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B7"
            }
          },
          "payday_alternative_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C7"
            }
          },
          "payday_alternative_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D7"
            }
          },
          "payday_alternative_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E7"
            }
          },
          "payday_alternative_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F7"
            }
          },
          "student_loans_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A8"
            }
          },
          "student_loans_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B8"
            }
          },
          "student_loans_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C8"
            }
          },
          "student_loans_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D8"
            }
          },
          "student_loans_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E8"
            }
          },
          "student_loans_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F8"
            }
          },
          "other_unsecured_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A9"
            }
          },
          "other_unsecured_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B9"
            }
          },
          "other_unsecured_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C9"
            }
          },
          "other_unsecured_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D9"
            }
          },
          "other_unsecured_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E9"
            }
          },
          "other_unsecured_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F9"
            }
          },
          "new_vehicle_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A10"
            }
          },
          "new_vehicle_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B10"
            }
          },
          "new_vehicle_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C10"
            }
          },
          "new_vehicle_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D10"
            }
          },
          "new_vehicle_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E10"
            }
          },
          "new_vehicle_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F10"
            }
          },
          "used_vehicle_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A11"
            }
          },
          "used_vehicle_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B11"
            }
          },
          "used_vehicle_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C11"
            }
          },
          "used_vehicle_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D11"
            }
          },
          "used_vehicle_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E11"
            }
          },
          "used_vehicle_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F11"
            }
          },
          "leases_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A12"
            }
          },
          "leases_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B12"
            }
          },
          "leases_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C12"
            }
          },
          "leases_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D12"
            }
          },
          "leases_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E12"
            }
          },
          "leases_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F12"
            }
          },
          "other_secured_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A13"
            }
          },
          "other_secured_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B13"
            }
          },
          "other_secured_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C13"
            }
          },
          "other_secured_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D13"
            }
          },
          "other_secured_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E13"
            }
          },
          "other_secured_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F13"
            }
          },
          "first_lien_residential_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A14"
            }
          },
          "first_lien_residential_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B14"
            }
          },
          "first_lien_residential_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C14"
            }
          },
          "first_lien_residential_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D14"
            }
          },
          "first_lien_residential_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E14"
            }
          },
          "first_lien_residential_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F14"
            }
          },
          "junior_lien_residential_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A15"
            }
          },
          "junior_lien_residential_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B15"
            }
          },
          "junior_lien_residential_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C15"
            }
          },
          "junior_lien_residential_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D15"
            }
          },
          "junior_lien_residential_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E15"
            }
          },
          "junior_lien_residential_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F15"
            }
          },
          "other_real_estate_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A16"
            }
          },
          "other_real_estate_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B16"
            }
          },
          "other_real_estate_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C16"
            }
          },
          "other_real_estate_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D16"
            }
          },
          "other_real_estate_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E16"
            }
          },
          "other_real_estate_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F16"
            }
          },
          "commercial_real_estate_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A17"
            }
          },
          "commercial_real_estate_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B17"
            }
          },
          "commercial_real_estate_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C17"
            }
          },
          "commercial_real_estate_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D17"
            }
          },
          "commercial_real_estate_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E17"
            }
          },
          "commercial_real_estate_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F17"
            }
          },
          "commercial_other_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 1 - Summary'!A18"
            }
          },
          "commercial_other_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!B18"
            }
          },
          "commercial_other_individual_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!C18"
            }
          },
          "commercial_other_pooled_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!D18"
            }
          },
          "commercial_other_total_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!E18"
            }
          },
          "commercial_other_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 1 - Summary'!F18"
            }
          }
        }
      },
      "description": "13 source portfolio segments; reserve ratio is a decimal. Field prefixes identify the 13 source segments. Fixed rows exclude total/check status/notes."
    },
    {
      "id": "individual_summary",
      "dir": "out",
      "shape": "record",
      "location": {
        "a1": "'Tab 2 - Individual Basis'!A6:E18"
      },
      "schema": {
        "kind": "record",
        "fields": {
          "credit_cards_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A6"
            }
          },
          "credit_cards_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B6"
            }
          },
          "credit_cards_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C6"
            }
          },
          "credit_cards_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D6"
            }
          },
          "credit_cards_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E6"
            }
          },
          "payday_alternative_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A7"
            }
          },
          "payday_alternative_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B7"
            }
          },
          "payday_alternative_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C7"
            }
          },
          "payday_alternative_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D7"
            }
          },
          "payday_alternative_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E7"
            }
          },
          "student_loans_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A8"
            }
          },
          "student_loans_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B8"
            }
          },
          "student_loans_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C8"
            }
          },
          "student_loans_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D8"
            }
          },
          "student_loans_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E8"
            }
          },
          "other_unsecured_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A9"
            }
          },
          "other_unsecured_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B9"
            }
          },
          "other_unsecured_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C9"
            }
          },
          "other_unsecured_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D9"
            }
          },
          "other_unsecured_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E9"
            }
          },
          "new_vehicle_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A10"
            }
          },
          "new_vehicle_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B10"
            }
          },
          "new_vehicle_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C10"
            }
          },
          "new_vehicle_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D10"
            }
          },
          "new_vehicle_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E10"
            }
          },
          "used_vehicle_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A11"
            }
          },
          "used_vehicle_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B11"
            }
          },
          "used_vehicle_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C11"
            }
          },
          "used_vehicle_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D11"
            }
          },
          "used_vehicle_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E11"
            }
          },
          "leases_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A12"
            }
          },
          "leases_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B12"
            }
          },
          "leases_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C12"
            }
          },
          "leases_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D12"
            }
          },
          "leases_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E12"
            }
          },
          "other_secured_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A13"
            }
          },
          "other_secured_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B13"
            }
          },
          "other_secured_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C13"
            }
          },
          "other_secured_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D13"
            }
          },
          "other_secured_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E13"
            }
          },
          "first_lien_residential_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A14"
            }
          },
          "first_lien_residential_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B14"
            }
          },
          "first_lien_residential_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C14"
            }
          },
          "first_lien_residential_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D14"
            }
          },
          "first_lien_residential_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E14"
            }
          },
          "junior_lien_residential_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A15"
            }
          },
          "junior_lien_residential_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B15"
            }
          },
          "junior_lien_residential_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C15"
            }
          },
          "junior_lien_residential_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D15"
            }
          },
          "junior_lien_residential_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E15"
            }
          },
          "other_real_estate_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A16"
            }
          },
          "other_real_estate_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B16"
            }
          },
          "other_real_estate_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C16"
            }
          },
          "other_real_estate_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D16"
            }
          },
          "other_real_estate_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E16"
            }
          },
          "commercial_real_estate_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A17"
            }
          },
          "commercial_real_estate_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B17"
            }
          },
          "commercial_real_estate_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C17"
            }
          },
          "commercial_real_estate_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D17"
            }
          },
          "commercial_real_estate_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E17"
            }
          },
          "commercial_other_segment": {
            "type": "string",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!A18"
            }
          },
          "commercial_other_loan_balance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!B18"
            }
          },
          "commercial_other_allowance": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!C18"
            }
          },
          "commercial_other_reserve_ratio": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!D18"
            }
          },
          "commercial_other_loan_count": {
            "type": "number",
            "location": {
              "a1": "'Tab 2 - Individual Basis'!E18"
            }
          }
        }
      },
      "description": "Includes COUNTIF(Table5[Column6],segment); requires restoration of source Table5 metadata in this WASM build. Field prefixes identify the 13 source segments. Fixed rows exclude total/check status/notes."
    },
    {
      "id": "pooled_balances",
      "dir": "out",
      "shape": "range",
      "location": {
        "a1": "'Tab 3 - Pooled Basis'!C6:E18"
      },
      "schema": {
        "kind": "range",
        "cell_type": "number"
      },
      "description": "Columns: total balance, individual balance, pooled balance."
    },
    {
      "id": "loss_rates",
      "dir": "out",
      "shape": "range",
      "location": {
        "a1": "'Tab 3 - Pooled Basis'!G6:I18"
      },
      "schema": {
        "kind": "range",
        "cell_type": "number"
      },
      "description": "Columns: historical annual loss rate, Q adjustment, applicable annual rate."
    },
    {
      "id": "warm_schedule",
      "dir": "out",
      "shape": "range",
      "location": {
        "a1": "'Tab 3 - Pooled Basis'!K6:M18"
      },
      "schema": {
        "kind": "range",
        "cell_type": "number"
      },
      "description": "Columns: peer WARM years, adjustment years, applicable WARM years."
    },
    {
      "id": "pooled_loss_components",
      "dir": "out",
      "shape": "range",
      "location": {
        "a1": "'Tab 3 - Pooled Basis'!O6:Q18"
      },
      "schema": {
        "kind": "range",
        "cell_type": "number"
      },
      "description": "Columns: quantitative, qualitative, combined lifetime loss."
    }
  ]
}
