import type { SheetPortClient, TablePortInput, SheetPortEvaluateOptions, SheetPortEvaluateResult } from 'formualizer/cloudflare'; export interface Inputs { "credit_union_number"?: string; "total_assets"?: number; "credit_cards_balance"?: number; "credit_cards_q_factor"?: number; "credit_cards_warm_adjustment"?: number; "credit_cards_q_justification"?: string | null; "credit_cards_warm_justification"?: string | null; "payday_alternative_balance"?: number; "payday_alternative_q_factor"?: number; "payday_alternative_warm_adjustment"?: number; "payday_alternative_q_justification"?: string | null; "payday_alternative_warm_justification"?: string | null; "student_loans_balance"?: number; "student_loans_q_factor"?: number; "student_loans_warm_adjustment"?: number; "student_loans_q_justification"?: string | null; "student_loans_warm_justification"?: string | null; "other_unsecured_balance"?: number; "other_unsecured_q_factor"?: number; "other_unsecured_warm_adjustment"?: number; "other_unsecured_q_justification"?: string | null; "other_unsecured_warm_justification"?: string | null; "new_vehicle_balance"?: number; "new_vehicle_q_factor"?: number; "new_vehicle_warm_adjustment"?: number; "new_vehicle_q_justification"?: string | null; "new_vehicle_warm_justification"?: string | null; "used_vehicle_balance"?: number; "used_vehicle_q_factor"?: number; "used_vehicle_warm_adjustment"?: number; "used_vehicle_q_justification"?: string | null; "used_vehicle_warm_justification"?: string | null; "leases_balance"?: number; "leases_q_factor"?: number; "leases_warm_adjustment"?: number; "leases_q_justification"?: string | null; "leases_warm_justification"?: string | null; "other_secured_balance"?: number; "other_secured_q_factor"?: number; "other_secured_warm_adjustment"?: number; "other_secured_q_justification"?: string | null; "other_secured_warm_justification"?: string | null; "first_lien_residential_balance"?: number; "first_lien_residential_q_factor"?: number; "first_lien_residential_warm_adjustment"?: number; "first_lien_residential_q_justification"?: string | null; "first_lien_residential_warm_justification"?: string | null; "junior_lien_residential_balance"?: number; "junior_lien_residential_q_factor"?: number; "junior_lien_residential_warm_adjustment"?: number; "junior_lien_residential_q_justification"?: string | null; "junior_lien_residential_warm_justification"?: string | null; "other_real_estate_balance"?: number; "other_real_estate_q_factor"?: number; "other_real_estate_warm_adjustment"?: number; "other_real_estate_q_justification"?: string | null; "other_real_estate_warm_justification"?: string | null; "commercial_real_estate_balance"?: number; "commercial_real_estate_q_factor"?: number; "commercial_real_estate_warm_adjustment"?: number; "commercial_real_estate_q_justification"?: string | null; "commercial_real_estate_warm_justification"?: string | null; "commercial_other_balance"?: number; "commercial_other_q_factor"?: number; "commercial_other_warm_adjustment"?: number; "commercial_other_q_justification"?: string | null; "commercial_other_warm_justification"?: string | null; "individual_loans"?: TablePortInput<{ "Column1": string; "Column2": string; "Column6": string; "Column3": number; "Column4": number }>; } export interface Outputs { "total_loan_balance": number; "individual_allowance": number; "pooled_allowance": number; "total_allowance": number; "reserve_ratio": number; "allowance_summary": { "total_loan_balance": number; "individual_allowance": number; "pooled_allowance": number; "total_allowance": number; "reserve_ratio": number }; "segment_summary": { "credit_cards_segment": string; "credit_cards_loan_balance": number; "credit_cards_individual_allowance": number; "credit_cards_pooled_allowance": number; "credit_cards_total_allowance": number; "credit_cards_reserve_ratio": number; "payday_alternative_segment": string; "payday_alternative_loan_balance": number; "payday_alternative_individual_allowance": number; "payday_alternative_pooled_allowance": number; "payday_alternative_total_allowance": number; "payday_alternative_reserve_ratio": number; "student_loans_segment": string; "student_loans_loan_balance": number; "student_loans_individual_allowance": number; "student_loans_pooled_allowance": number; "student_loans_total_allowance": number; "student_loans_reserve_ratio": number; "other_unsecured_segment": string; "other_unsecured_loan_balance": number; "other_unsecured_individual_allowance": number; "other_unsecured_pooled_allowance": number; "other_unsecured_total_allowance": number; "other_unsecured_reserve_ratio": number; "new_vehicle_segment": string; "new_vehicle_loan_balance": number; "new_vehicle_individual_allowance": number; "new_vehicle_pooled_allowance": number; "new_vehicle_total_allowance": number; "new_vehicle_reserve_ratio": number; "used_vehicle_segment": string; "used_vehicle_loan_balance": number; "used_vehicle_individual_allowance": number; "used_vehicle_pooled_allowance": number; "used_vehicle_total_allowance": number; "used_vehicle_reserve_ratio": number; "leases_segment": string; "leases_loan_balance": number; "leases_individual_allowance": number; "leases_pooled_allowance": number; "leases_total_allowance": number; "leases_reserve_ratio": number; "other_secured_segment": string; "other_secured_loan_balance": number; "other_secured_individual_allowance": number; "other_secured_pooled_allowance": number; "other_secured_total_allowance": number; "other_secured_reserve_ratio": number; "first_lien_residential_segment": string; "first_lien_residential_loan_balance": number; "first_lien_residential_individual_allowance": number; "first_lien_residential_pooled_allowance": number; "first_lien_residential_total_allowance": number; "first_lien_residential_reserve_ratio": number; "junior_lien_residential_segment": string; "junior_lien_residential_loan_balance": number; "junior_lien_residential_individual_allowance": number; "junior_lien_residential_pooled_allowance": number; "junior_lien_residential_total_allowance": number; "junior_lien_residential_reserve_ratio": number; "other_real_estate_segment": string; "other_real_estate_loan_balance": number; "other_real_estate_individual_allowance": number; "other_real_estate_pooled_allowance": number; "other_real_estate_total_allowance": number; "other_real_estate_reserve_ratio": number; "commercial_real_estate_segment": string; "commercial_real_estate_loan_balance": number; "commercial_real_estate_individual_allowance": number; "commercial_real_estate_pooled_allowance": number; "commercial_real_estate_total_allowance": number; "commercial_real_estate_reserve_ratio": number; "commercial_other_segment": string; "commercial_other_loan_balance": number; "commercial_other_individual_allowance": number; "commercial_other_pooled_allowance": number; "commercial_other_total_allowance": number; "commercial_other_reserve_ratio": number }; "individual_summary": { "credit_cards_segment": string; "credit_cards_loan_balance": number; "credit_cards_allowance": number; "credit_cards_reserve_ratio": number; "credit_cards_loan_count": number; "payday_alternative_segment": string; "payday_alternative_loan_balance": number; "payday_alternative_allowance": number; "payday_alternative_reserve_ratio": number; "payday_alternative_loan_count": number; "student_loans_segment": string; "student_loans_loan_balance": number; "student_loans_allowance": number; "student_loans_reserve_ratio": number; "student_loans_loan_count": number; "other_unsecured_segment": string; "other_unsecured_loan_balance": number; "other_unsecured_allowance": number; "other_unsecured_reserve_ratio": number; "other_unsecured_loan_count": number; "new_vehicle_segment": string; "new_vehicle_loan_balance": number; "new_vehicle_allowance": number; "new_vehicle_reserve_ratio": number; "new_vehicle_loan_count": number; "used_vehicle_segment": string; "used_vehicle_loan_balance": number; "used_vehicle_allowance": number; "used_vehicle_reserve_ratio": number; "used_vehicle_loan_count": number; "leases_segment": string; "leases_loan_balance": number; "leases_allowance": number; "leases_reserve_ratio": number; "leases_loan_count": number; "other_secured_segment": string; "other_secured_loan_balance": number; "other_secured_allowance": number; "other_secured_reserve_ratio": number; "other_secured_loan_count": number; "first_lien_residential_segment": string; "first_lien_residential_loan_balance": number; "first_lien_residential_allowance": number; "first_lien_residential_reserve_ratio": number; "first_lien_residential_loan_count": number; "junior_lien_residential_segment": string; "junior_lien_residential_loan_balance": number; "junior_lien_residential_allowance": number; "junior_lien_residential_reserve_ratio": number; "junior_lien_residential_loan_count": number; "other_real_estate_segment": string; "other_real_estate_loan_balance": number; "other_real_estate_allowance": number; "other_real_estate_reserve_ratio": number; "other_real_estate_loan_count": number; "commercial_real_estate_segment": string; "commercial_real_estate_loan_balance": number; "commercial_real_estate_allowance": number; "commercial_real_estate_reserve_ratio": number; "commercial_real_estate_loan_count": number; "commercial_other_segment": string; "commercial_other_loan_balance": number; "commercial_other_allowance": number; "commercial_other_reserve_ratio": number; "commercial_other_loan_count": number }; "pooled_balances": number[][]; "loss_rates": number[][]; "warm_schedule": number[][]; "pooled_loss_components": number[][]; } export type Client = SheetPortClient; export declare const invokeSheetPort: (workbook: Client, inputs: Partial, options?: SheetPortEvaluateOptions) => Promise>; declare module 'formualizer/cloudflare' { interface WorkbookCatalogRegistry { "ncua-cecl-warm@2026-Q3": { inputs: Inputs; outputs: Outputs } } } // Named Flow Type Projections export type QuickAllowanceCheckInputs = Pick; export type QuickAllowanceCheckOutputs = Pick; export type FullPortfolioWarmScheduleInputs = Pick; export type FullPortfolioWarmScheduleOutputs = Pick; declare module 'formualizer/cloudflare' { interface WorkbookCatalogRegistry { "ncua-cecl-warm": { inputs: Inputs; outputs: Outputs }; } }