# Project Tracker Management

> Worked on developing a Project Tracker in Google Sheets to allocate tasks, track project milestones, and monitor team performance, complete with real-time updates and visual dashboards for easy interpretation.

Section: Google Apps Script

Page: https://mburhan.com/case/gas-project-tracker-management

## Project Overview

This project involved developing a Project Tracker in Google Sheets to help manage tasks, monitor project milestones, and track team performance. The tracker includes real-time updates and visual dashboards for easier interpretation of project schedules and progress.

**Tools:** Google Apps Script and Google Sheets.

## 01. Project Objectives

The tracker was developed to support three main activities:

- **Task Allocation:** Organize and allocate project tasks.
- **Milestone Tracking:** Track project milestones and schedules.
- **Team Performance Monitoring:** Monitor team performance through the tracker.

## 02. The Solution

A project tracking system was developed in Google Sheets, with real-time updates and visual dashboards to make project information easier to understand.

## 03. Project Schedule Visualization

The tracker includes a Gantt-style project schedule generated directly in Google Sheets. The schedule displays task start and end dates across a timeline, making it easier to view project durations and overlapping activities.

Image: A Gantt-style project schedule generated directly in Google Sheets. (https://mburhan.com/case-content/google-apps-script-portfolio/image13.png)

## 04. Key Features

- Task allocation and organization
- Project milestone tracking
- Team performance monitoring
- Real-time updates
- Visual dashboards for interpreting project information
- Gantt-style schedule visualization in Google Sheets

## 05. Tools and Technologies

- **Google Sheets:** Provides the project tracking spreadsheet, schedule, and visual dashboard.
- **Google Apps Script:** Listed as a technology used in the project.

## 06. Outcome

The Project Tracker provides a centralized way to allocate tasks, track milestones, and monitor team performance through Google Sheets, supported by visual scheduling and dashboard features.
