Project Description

Overview

The goal of this project is to create a structured Report Tracker for department submissions. The spreadsheet will track reports, responsible staff, deadlines, and reviewer feedback, supporting internal monitoring and timely follow-ups.

Scope of Work

The task involves:

• Reviewing shared folders and email chains provided by the client

• Accurately extracting report details and submission information

• Entering data into a structured and clearly labeled spreadsheet

• Ensuring consistency, accuracy, and readability

• Delivering a complete and organized tracker

Required Fields

The spreadsheet should include:

• Report Name

• Assigned Staff

• Due Date

• Status

• Submission Date

• Reviewer Feedback

Additional fields may be added if provided or required by the client.

Client Material Source

All data will be provided by the client, including:

• Shared folders containing reports

• Email chains with submission information

No external research is required.

Deliverables

• One completed Department Report Tracker Spreadsheet

• Format: Excel or Google Sheets, as specified by the client

• Spreadsheet must be clearly labeled, well-formatted, and ready for internal use

Quality Requirements

• Accurate and complete data entry

• Consistent formatting of names, dates, and status

• Professional, easy-to-read layout

Deadline

The final spreadsheet must be delivered on or before 4th February 2026.