Automated Credit Risk Scoring Model with Pandas Sheets

Create a Python script that uses pandas to dynamically parse complex loan application spreadsheets, implementing a machine learning-based credit risk scoring model. The script should handle multiple sheet formats from different banks, extract key financial ratios, clean inconsistent data, and generate a standardized risk assessment report with confidence intervals. Implement error handling for non-standard Excel formats and include logging for tracking data transformations.