Understanding Cleaner Efficiency: A Comparison Tool

Purpose: This tool helps cleaning companies see how much time their cleaners take on jobs and find ways to improve efficiency.

Analysis Process:

• The tool calculates the average cleaning time for each customer's home, considering all recorded cleaning sessions and excluding outliers.
• It identifies efficient cleaning times, usually achieved by cleaners who clean the same home regularly.
• By comparing the average cleaning time with these efficient times, the tool shows the benefits of consistency and experience.

Result Interpretation:

• Overall Average Percentage Difference: Shows how much faster consistent, experienced cleaning is compared to the average.
• Customer-Specific Analysis: Detailed analysis for each customer includes average cleaning time, efficient cleaning time, and the percentage difference between them.

Advantages:

• Identify training opportunities to help all cleaners become more efficient.
• Schedule the most efficient cleaners for repeat jobs to save time and increase customer satisfaction.
• Understand the value of consistency and experience in their workforce, leading to better management and improved performance.

Guide for Organizing Cleaning Data for Upload

Data Format: Excel (.xlsx) with multiple sheets, each named after a customer.

Sheet Structure:

• Date: Date of cleaning (e.g., MM/DD/YYYY)
• First: First name of the cleaner
• Actual Time: Cleaning time in decimal format (e.g., 2.5 for 2 hours 30 minutes)

Example Data:

Sheet Name: Customer1

Sheet Name: Customer2

Important Notes:

• Use exact column names: Date, First, Actual Time.
• Remove blanks and ensure no missing values.
• Pre-screen to remove obvious outliers.

Upload Process:

• Prepare your Excel file.
• Click "Choose File" and select your file.
• Click "Upload" to submit for analysis.