Comp Time Tracker
Google Sheets (Beta)
Set Up the 2026–27 Comp Time Tracker
The 2026–27 Comp Time Tracker is a Google Sheets-based tool that automatically calculates your comp time balance throughout the fiscal year. During the initial setup, you'll create your own copy of the tracker, authorize the Apps Script, and enter your starting balance and standard workweek hours.
Estimated time: 2–3 minutes (first-time setup only)
Before You Begin
You will need:
- Your Thompson School District Google account
- Your FY26 ending comp time balance (carryover hours)
- Your standard workweek hours (typically 37.5 or 40)
Note: Your carryover balance should match your approved ending balance from the previous fiscal year.
Step 1: Create Your Personal Copy
- Open the 2026-27 Comp Time Tracker template.
- Click Make a copy.
The spreadsheet and all automation will be copied into your own Google Drive.
Step 2: Authorize the Script
The first time you open your copy:
- Click Comp Time in the menu bar.
- Select Setup Tracker.
Google will display an Authorization required message.
- Click OK.
- Select your TSD Google account.
- Review the requested permissions.
- Click Continue (or Allow, if prompted).
These permissions allow the tracker to:
- Create and update the linked Google Form
- Write responses into your personal spreadsheet
- Run the custom menu and automation
This authorization only needs to be completed once.
Step 3: Enter Your Carryover Balance
The setup wizard begins by asking for your carryover balance.
Enter the number of approved comp hours you are bringing into the new fiscal year.
Example:
- 0
- 4.5
- 12.75
Click OK.
Step 4: Enter Your Standard Workweek
Next, you will be prompted to enter your normal work hours, which are used to calculate your comp time accrual. The default is 40 hours for full-time employees working 8 hours. If your position is 7.5 hours per day and you are full-time, enter 37.5 in the box.
Click OK.
Step 5: Setup Complete
When setup finishes, you'll see a confirmation message showing:
- Your name
- Carryover hours
- Standard workweek hours
Select View Form to open your personal Comp Time Entry Form.
You may also bookmark this form for quick access throughout the year.
Recording Comp Time
All comp time must be approved prior to receiving and using it. Please see the Classified Handbook for more details. Whenever you need to record time:
-
Open your bookmarked Comp Time Entry Form.
-
Complete the fields:
- Date
- Leave Taken (if applicable): If you are off for a holiday, a non-work day, or taking leave, enter the non-working hours in this field so that the ledger accurately calculates your comp time for that week.
- Comp Taken (if applicable)
- Extra Hours Worked (if applicable): Enter the number of extra hours worked. Please round up to the nearest quarter hour.
- Reason
-
Click Submit.
Your ledger will update automatically after the form is submitted. For best results, use the form to record time and do not edit the Ledger sheet directly.
Viewing Your Current Balance
The spreadsheet will automatically calculate the number of comp hours you are earning based on your specific number of hours a week. At any time:
- Open your Comp Time Ledger.
- Select Comp Time → Show Current Balance.
A dialog box displays your current comp time balance.
You can also launch the entry form directly from this window by selecting Submit Comp Time Entry.
Understanding the Ledger
Your ledger automatically tracks:
| Column | Description |
|---|---|
| Date | Date of the entry |
| Leave Taken | Annual leave, vacation, or non-workday hours |
| Comp Taken | Comp time used |
| Extra Hours | Additional approved hours worked |
| Reason / Notes | Description of the entry |
| Workweek Beginning | Week used for calculations |
| Running Comp Balance | Your current comp time balance |
The first row records your FY26 carryover balance.
For best results, use the form to record time and do not edit the Ledger sheet directly.
Troubleshooting
I receive an "Authorization required" message.
This is normal the first time you use the tracker.
Choose OK, sign in with your TSD account, and approve the requested permissions.
The Comp Time menu doesn't appear.
Refresh the spreadsheet after making your copy. If it still doesn't appear, close and reopen the spreadsheet.
My balance isn't updating.
Verify that:
- You submitted the Google Form, not the spreadsheet directly.
- The form submission completed successfully.
- You are using your own copied tracker, not the shared template.
I accidentally edited the ledger.
Only record entries through the Google Form. Direct edits to the ledger may affect calculations.
I can't access the tracker.
Make sure you are signed into your Thompson School District Google account and are working from your copied version of the spreadsheet—not the original template.
Need Help?
If you have questions about using the tracker or experience technical issues, please contact the Classified Staffing Specialist at 970-613-5773.
Excel Spreadsheet (Legacy)
Instructions for using the Comp Time Tracker
- Download the 2026-27 Comp Time Tracker Excel workbook. This document is not accessible; please use the Google Sheets version for a more accessible workflow.
- Enter your normal work hours on the tracker under the July tab, this will now be reflected on all spreadsheets. The default is 40 hours for 8-hour full-time employees. If your position is 7.5 hours a day, and you are full time, you will enter 37.5 in the box.
- All comp time must be approved prior to receiving and using it. (Please see page 18 of the Classified Handbook for more details)
- When extra hours are worked, enter the number of hours in the "xtra hours" box and enter the reason in the box below. Please round up to the nearest quarter hour.
- The spreadsheet will automatically calculate the number of comp hours you are earning based on your specific number of hours a week. See "Month End Total" to see the total. The total will automatically carry over to the next month.
- Note: Please do not type any time earned in column W. The spreadsheet uses formulas in that column to add up your time.
- If you are off for a holiday, non-work day or taking leave, enter that on the box "leave taken /non-work day" so the spreadsheet will calculate your comp time correctly for that given week.
If you have any questions on how to use the tracker or run into a problem, please contact the Classified Staffing Specialist at 970-613-5773.