1. Phase 1: Foundational Planning & Data Structure
1.1. System Requirements & Workflows
1.1.1. Volunteer Attendance
1.1.1.1. Clock In/Out Method
1.1.1.2. Data to Record
1.1.1.3. Tracking & Summaries
1.1.2. Timesheet Management
1.1.2.1. Time Recording
1.1.2.2. Level of Detail
1.1.2.3. Submission & Approval
1.1.3. Payroll Management
1.1.3.1. Payment Types
1.1.3.2. Payroll Data Needs
1.1.3.3. Processing & Records
1.1.4. Synchronization
1.1.4.1. Data Flow
1.1.4.2. Linking Identifiers
1.1.4.3. Triggers
1.2. Google Sheets Structure
1.2.1. Volunteer Master Data
1.2.1.1. Volunteer ID (Unique)
1.2.1.2. Personal Info
1.2.1.3. Role(s)
1.2.1.4. Pay Rate
1.2.1.5. Bank Details
1.2.2. Attendance Log
1.2.2.1. Timestamp
1.2.2.2. Volunteer ID (FK)
1.2.2.3. Date
1.2.2.4. Time In
1.2.2.5. Time Out
1.2.2.6. Activity/Project (Optional)
1.2.2.7. Location (Optional)
1.2.2.8. Notes (Optional)
1.2.3. Timesheet Log
1.2.3.1. Timestamp
1.2.3.2. Volunteer ID (FK)
1.2.3.3. Date
1.2.3.4. Start Time
1.2.3.5. End Time
1.2.3.6. Task Description
1.2.3.7. Project Code (Optional)
1.2.3.8. Hours Worked (Calculated)
1.2.3.9. Approval Status (Optional)
1.2.4. Payroll Data
1.2.4.1. Payroll Period
1.2.4.2. Volunteer ID (FK)
1.2.4.3. Total Hours (From Attendance/Timesheet)
1.2.4.4. Pay Rate (From Master Data)
1.2.4.5. Calculated Fields (Gross, Net)
1.2.4.6. Payment Details
1.3. Relationships & Unique Identifiers
1.3.1. Volunteer ID as Primary Link
1.3.2. Ensuring Uniqueness
1.4. Initial Data Entry (Test Data)
1.4.1. Populate Master Data
1.4.2. Sample Attendance/Timesheet Data
1.4.3. Matching Volunteer IDs
2. Phase 3: Automation with Apps Script
2.1. Calculate Hours Worked
2.2. Transfer Data Between Sheets
2.3. Generate Payroll Information
2.4. Automate Reports
2.5. Set Triggers
3. Phase 5: Testing & Refinement
3.1. Thorough Testing
3.2. User Feedback
3.3. Iterative Improvements
4. Phase 2: Data Input Mechanisms
4.1. Volunteer Attendance Input
4.1.1. Google Forms?
4.1.2. Direct Sheet Entry?
4.1.3. Other Methods?
4.2. Timesheet Input
4.2.1. Google Forms?
4.2.2. Direct Sheet Entry?
4.2.3. Pre-filled Options?