Data Upload & Data Quality
Drop one workbook containing all LOB sheets. Each sheet is detected automatically and stored as its own raw dataset — nothing is merged at source.
Upload workbook
Supported: .xlsx, .xls, .csv — the dashboard refreshes automatically once processing completes
Drag & drop your workbook here
Forecasting sheets: CSG In Warranty · CSG OOW · ESG DB & OSP · HES · Care · IBP · Field
Capacity planning sheets: CSG Capacity Planning · ISG Capacity Planning · Care Capacity Planning · IBP Capacity Planning · Field Capacity Planning
Exclude duplicate queue-week records from analytics
Duplicates stay in the raw sheets; this only affects the analytical layer.
Capacity Planning Sheets
One capacity sheet per business line — until a sheet is uploaded, the capacity ledger uses the sample staffing model
CSG Capacity Planning
Expected columns: Region, Sub Region, Forecast Name, Demand, Required HC, Capacity Plan, Scheduled Capacity, Actual Capacity, Service Level Adh
Status: No data — sample model in use
ISG Capacity Planning
Expected columns: Region, Sub Region, Forecast Name, Demand, Required HC, Capacity Plan, Scheduled Capacity, Actual Capacity, Service Level Adh
Status: No data — sample model in use
Care Capacity Planning
Expected columns: Region, Sub Region, Forecast Name, Demand, Required HC, Capacity Plan, Scheduled Capacity, Actual Capacity, Service Level Adh
Status: No data — sample model in use
IBP Capacity Planning
Expected columns: Region, Sub Region, Forecast Name, Demand, Required HC, Capacity Plan, Scheduled Capacity, Actual Capacity, Service Level Adh
Status: No data — sample model in use
Field Capacity Planning
Expected columns: Region, Sub Region, Forecast Name, Demand, Required HC, Capacity Plan, Scheduled Capacity, Actual Capacity, Service Level Adh
Status: No data — sample model in use
Expected Sheet Structure
Column names the parser looks for in each sheet
CSG In Warranty
Sheet name must contain: csg in warranty
Required columns: Fiscal_Week, Forecast_name, Actual_Offered, Forecast
Status: No data
CSG OOW
Sheet name must contain: csg oow
Required columns: Fiscal_Week, Forecast_name, Actual, Forecast
Status: No data
ESG DB & OSP
Sheet name must contain: esg ml db and osp
Required columns: Combined_Queue_Name, fiscal_week, act_offered, Fcst Offered | Forecast
Status: No data
HES
Sheet name must contain: hes
Required columns: LOB, fiscal_week, Sum of Actuals, Sum of Forecast
Status: No data
Care
Sheet name must contain: care ml
Required columns: Combined Queue Name, QWK, Actual Offered, FCST Offered
Status: No data
IBP
Sheet name must contain: ibp ml
Required columns:
Status: No data
Field
Sheet name must contain: field ml
Required columns:
Status: No data