{
  "spec": "fio",
  "spec_version": "0.3.0",
  "capabilities": {
    "profile": "full-v0"
  },
  "manifest": {
    "id": "fed-scale-cecl-2026",
    "name": "Federal Reserve SCALE CECL Calculator",
    "description": "Estimate source-preserved seven-segment CECL allowances with qualitative, historical and individually assessed loan adjustments.",
    "workbook": {
      "uri": "fed-scale-cecl.xlsx",
      "locale": "en-US",
      "date_system": 1900
    }
  },
  "ports": [
    {
      "id": "construction_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "construction_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "construction_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "commercial_real_estate_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "commercial_real_estate_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "commercial_real_estate_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "residential_real_estate_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "residential_real_estate_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "residential_real_estate_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "commercial_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "commercial_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "commercial_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "credit_cards_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "credit_cards_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "credit_cards_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E26"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "other_consumer_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "other_consumer_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "other_consumer_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E27"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "additional_balance",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD end-of-period loans; blank source default = zero. Individually assessed balances must not exceed this amount.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "additional_proxy_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!J18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative decimal lifetime loss rate: 0.01 = 1%; source default 0. Not an annual rate.",
      "default": 0,
      "constraints": {
        "min": 0
      }
    },
    {
      "id": "additional_q_adjustment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 3 - Qualitative Adjustments'!E28"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed additive decimal lifetime-rate adjustment: 0.005 = +0.5 percentage point; source default 0.",
      "default": 0
    },
    {
      "id": "institution_loss_2007",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2007; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2007",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2007; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2008",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2008; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2008",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2008; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2009",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2009; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2009",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2009; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2010",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2010; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2010",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2010; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2011",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2011; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2011",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2011; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2012",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2012; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2012",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2012; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2013",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2013; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2013",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2013; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2014",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2014; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2014",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2014; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2015",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2015; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2015",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2015; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2016",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C26"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2016; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2016",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F26"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2016; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2017",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C27"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2017; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2017",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F27"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2017; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2018",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C28"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2018; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2018",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F28"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2018; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2019",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C29"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2019; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2019",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F29"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2019; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "institution_loss_2020",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C30"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2020; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "peer_loss_2020",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F30"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed decimal annual net charge-off ratio for 2020; 0.01 = 1%; source default 0. Fourteen annual ratios are averaged without weighting.",
      "default": 0
    },
    {
      "id": "loan_9_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 9; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_9_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M9"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 9; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 10; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_10_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M10"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 10; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 11; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_11_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M11"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 11; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 12; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_12_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 12; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 13; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_13_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 13; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 14; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_14_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 14; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 15; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_15_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 15; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 16; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_16_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 16; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 17; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_17_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 17; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 18; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_18_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 18; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 19; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_19_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M19"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 19; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 20; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_20_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 20; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 21; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_21_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M21"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 21; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 22; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_22_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 22; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 23; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_23_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M23"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 23; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 24; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_24_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 24; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_construction",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!E25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_commercial_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!F25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_residential_real_estate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!G25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_commercial",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!H25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_credit_cards",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!I25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_other_consumer",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!J25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_additional",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!K25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD individual-loan balance, source row 25; blank defaults to zero. Included in segment deductions; row 25 has no source allowance formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "loan_25_collections",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 2 - Individually Assessed'!M25"
      },
      "schema": {
        "type": "number"
      },
      "description": "Nonnegative USD expected collections for source row 25; blank defaults to zero. Loan allowance is max(sum of seven balances minus collections,0), except row 25 has no source formula.",
      "default": null,
      "constraints": {
        "nullable": true,
        "min": 0
      }
    },
    {
      "id": "total_loans",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!D20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Total end-of-period loans, USD."
    },
    {
      "id": "pooled_balance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!H20"
      },
      "schema": {
        "type": "number"
      },
      "description": "Total pooled loans, USD; credit-card source H16 is a constant zero."
    },
    {
      "id": "base_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P20"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD pooled allowance before historical adjustment."
    },
    {
      "id": "historical_adjustment",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P22"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD historical adjustment = pooled balance times institution-minus-peer mean annual loss ratio."
    },
    {
      "id": "individual_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P24"
      },
      "schema": {
        "type": "number"
      },
      "description": "USD individual allowances for rows 9:24 only; source O25 is blank."
    },
    {
      "id": "total_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P26"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD total allowance; source does not floor negative results."
    },
    {
      "id": "reserve_ratio",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P28"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal total allowance / total loans; 0.01 = 1%. Source returns zero when allowance is zero."
    },
    {
      "id": "construction_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P12"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "commercial_real_estate_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P13"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "residential_real_estate_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P14"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "commercial_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P15"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "credit_cards_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "other_consumer_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P17"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "additional_pooled_allowance",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 1 - Summary'!P18"
      },
      "schema": {
        "type": "number"
      },
      "description": "Signed USD source segment allowance. Credit-card pooled balance is hard-coded zero."
    },
    {
      "id": "institution_average_loss",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!C32"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual net charge-off ratio or signed difference; 0.01 = 1%."
    },
    {
      "id": "peer_average_loss",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!F32"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual net charge-off ratio or signed difference; 0.01 = 1%."
    },
    {
      "id": "historical_rate_difference",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Tab 4 - Adj. to Loss Rate'!I32"
      },
      "schema": {
        "type": "number"
      },
      "description": "Decimal annual net charge-off ratio or signed difference; 0.01 = 1%."
    }
  ]
}
