Job Title: Create Google Form + Sheet System for Staff Attendance with Location Restriction and Overtime Tracking Project Description: We are a small architectural and design firm seeking a Google Apps Script / Automation Engineer to develop a simple yet efficient attendance and overtime tracking system using Google Forms and Google Sheets. The system should allow staff to log in and log out via their mobile phones, but only when they are physically present at our office location (verified via GPS coordinates). It should also automatically calculate work duration, overtime hours, and salary based on defined rules. Project Requirements: 1. Google Form (Mobile-friendly): Fields: Employee Name, Employee ID, Action (Login / Logout), Auto Timestamp. Automatically capture GPS location (latitude & longitude). Prevent form submission if location is outside defined office radius (~200m). 2. Google Sheet (Backend): Record all form submissions (Name, Timestamp, Location, etc.). Automatically validate entries (mark “Outside Office” if beyond radius). Pair Login & Logout records to calculate total work duration. Calculate overtime (if duration > 9 hours). Generate daily, weekly, and monthly summary reports. 3. Automation / Scripts: Auto delete or flag invalid (offsite) submissions. Send email alerts to admin for abnormal