Target Calculation System

A cloud-based web application specifically designed to help Team Leaders manage, schedule, and dynamically distribute daily tasks (matches) fairly among employees. It relies on a smart algorithm that prevents the accumulation of artificial deficits and calculates performance with extreme accuracy.

Core Functions & Value:

The tool primarily serves work environments that require daily or weekly target distribution. It performs 4 main roles:

Explicit Attendance Management: Eliminates "blind assumptions" of attendance. The system does not calculate targets or working days for any employee until the leader explicitly opens the week and confirms the shift schedule (Present / Off).

AI-Powered DP Engine: When the leader inputs the available matches for the day, the algorithm distributes them among the present employees based on three factors: the employee's base target, their accumulated historical deficit/surplus, and their remaining working days in the week.

Transparent Reporting (History & Summary): Maintains a complete log of daily distributions and generates an aggregated Summary report that compares the required target with the actual achievement, calculating the exact performance percentage.

Multi-Tenant Architecture: Serves dozens of teams simultaneously. Each team has a completely isolated database and a unique password for maximum security.

Tech Stack (How it's built):

The system is built entirely on the Google Workspace ecosystem to ensure speed and zero-cost hosting. It is divided into 3 layers:

Database: Powered by Google Sheets. Divided into a Master Sheet (manages team routing and passwords) and Sub-Databases (an independent spreadsheet for each team containing their collectors, schedules, and distribution history).

Backend: Programmed using Google Apps Script (JavaScript). It houses all the complex logic, mathematical algorithms (like Dynamic Urgency and Hard Caps), and handles automated database interactions.

Frontend: A modern, highly responsive interface built with HTML, Tailwind CSS (with full Dark Mode support), and Vanilla JS. It utilizes asynchronous calls (google.script.run) to operate seamlessly as a Single Page Application (SPA) without page reloads.