Comprehensive Safety Inspection Task Tracker
Budget: $30 – $250 USD
Objective:
I need an Excel-based task tracker designed specifically for safety inspections. The file should consist of four interconnected sheets with formulas, rating logic, and a dashboard to monitor Safety Report Quality Score (SRQS), support task progress, and inspector performance.
⸻
Sheet 1: Inspection Log
This is the main entry sheet for safety inspection data. It should include the following columns:
• Date
• Inspector Name
• Location
• Status (Open/Closed)
• SRQS (auto-filled from Sheet 2)
• Remarks
⸻
Sheet 2: SRQS (Safety Report Quality Score) Calculation
This sheet should calculate the SRQS based on five weighted criteria:
• Completeness (20%)
• Accuracy (20%)
• Timeliness – On-time submission (20%)
• Clarity (20%)
• Practical Value (20%)
The total score should be calculated automatically and linked back to the SRQS column in Sheet 1.
Scoring and Rating System:
• If the total SRQS score is between 90% and 100%, the report is rated as Excellent Quality. The recommended action is to recognize the report or use it as a best practice example.
• If the score is between 75% and 89%, it is considered Good Quality. The action here is to maintain the current standard but provide coaching for further improvement.
• If the score falls between 60% and 74%, it is rated as Fair. The recommendation is to review the report and provide retraining where necessary.
• If the score is below 60%, it is classified as Poor. In this case, the report should be rejected, and the inspector must undergo retraining.
⸻
Sheet 3: Support Task Tracker
This sheet will be used to track follow-up or support tasks. It should include the following columns:
• Task Description
• Assigned To (Name)
• Target Date
• Progress (%)
• Status (Not Started / In Progress / Completed)
• Remarks
⸻
Sheet 4: Dashboard
The final sheet should be a user-friendly dashboard summarizing the following metrics with charts and visuals:
• Total number of inspections: Open vs. Closed
• Number of inspections completed per location
• Inspector performance: total inspections completed and average SRQS score
• Support task progress: e.g., completion percentage and overdue tasks
I need an Excel-based task tracker designed specifically for safety inspections. The file should consist of four interconnected sheets with formulas, rating logic, and a dashboard to monitor Safety Report Quality Score (SRQS), support task progress, and inspector performance.
⸻
Sheet 1: Inspection Log
This is the main entry sheet for safety inspection data. It should include the following columns:
• Date
• Inspector Name
• Location
• Status (Open/Closed)
• SRQS (auto-filled from Sheet 2)
• Remarks
⸻
Sheet 2: SRQS (Safety Report Quality Score) Calculation
This sheet should calculate the SRQS based on five weighted criteria:
• Completeness (20%)
• Accuracy (20%)
• Timeliness – On-time submission (20%)
• Clarity (20%)
• Practical Value (20%)
The total score should be calculated automatically and linked back to the SRQS column in Sheet 1.
Scoring and Rating System:
• If the total SRQS score is between 90% and 100%, the report is rated as Excellent Quality. The recommended action is to recognize the report or use it as a best practice example.
• If the score is between 75% and 89%, it is considered Good Quality. The action here is to maintain the current standard but provide coaching for further improvement.
• If the score falls between 60% and 74%, it is rated as Fair. The recommendation is to review the report and provide retraining where necessary.
• If the score is below 60%, it is classified as Poor. In this case, the report should be rejected, and the inspector must undergo retraining.
⸻
Sheet 3: Support Task Tracker
This sheet will be used to track follow-up or support tasks. It should include the following columns:
• Task Description
• Assigned To (Name)
• Target Date
• Progress (%)
• Status (Not Started / In Progress / Completed)
• Remarks
⸻
Sheet 4: Dashboard
The final sheet should be a user-friendly dashboard summarizing the following metrics with charts and visuals:
• Total number of inspections: Open vs. Closed
• Number of inspections completed per location
• Inspector performance: total inspections completed and average SRQS score
• Support task progress: e.g., completion percentage and overdue tasks