Maica Roster Costing Calculator

Configure rate overrides, data issues and validation rules

API Connection

The calculator loads award data from the backend API. When running the frontend locally (without the backend), set the base URL of the deployed API here. Leave blank when the frontend is served by the FastAPI backend itself (e.g. on Railway).

Rate Mappings

Define classification and penalty rate mappings. These override values from the database tables.

2.1 Award-Classification Mapping

Award Code Classification Rate Type Base Rate Calculated Rate Actions
No mappings defined. Data will use database values.

2.2 Penalty Rate Mappings

Common fixes:
  • Sunday rate: Description: "Sunday" or "Sunday - ordinary hours", Rate: $39.83 (for $26.55 base × 1.50)
  • Saturday flat rate: Description: "Saturday - ordinary hours", Rate: $33.19 (for $26.55 base × 1.25)
Award Classification Description Rate ($/hr) Source Actions
No overrides defined. Using database values.

Data Issues & Fixes

Review and fix data validation issues detected by the system.

Quick Fix Guide:
  • Sunday rate wrong: Click "Fix" button on the warning, or manually override in Section 4.2
  • Saturday using tiered rates: Override "Saturday - ordinary hours" to use flat ×1.25 rate ($33.19/hr for $26.55 base)
  • After fixing: Reload the main calculator page to see changes
  • No issues detected

    Run a calculation to detect data issues.

Rate Overrides

Manually override rates when database values need adjustment.

4.1 Classification Rate Overrides

Award Classification Rate Type Original Rate Override Rate Actions
No overrides defined.

4.2 Penalty Rate Overrides

Override specific penalty rates for award/classification combinations.

Validation Rules

Configure validation rules and thresholds for data quality checks.

Rate Validation

Minimum Engagement

Export / Import Configuration

Export your configuration to a JSON file or import from a previously saved configuration.