Timesheet Editor

01Overview

The Re-Lax Timesheet Editor is a desktop web application that allows managers to load, review, correct, and save technician timesheets stored on SharePoint. It is intended as a companion tool to the Re-Lax Time Tracker used by field technicians.

Key capabilities:

• Load any technician's timesheet for any month directly from SharePoint
• Edit existing entries — correct dates, times, client, description, or service type
• Add new entries that were missed or need to be added manually
• Delete entries that were logged in error
• Automatic after-hours detection (weekends, US holidays, before 6 AM / after 7 PM)
• Hours Exact, Hours Billed, and Hours Paid recalculate automatically as you edit
• Save the corrected timesheet back to SharePoint in the same format techs produce

02Requirements

Before You Begin

Files Needed

The following files should be kept together in the same folder:

• TimesheetEditor.html — the main application
• Launch TimesheetEditor.bat — Windows launcher (double-click to start)
• Launch TimesheetEditor Mac.command — macOS launcher (double-click to start)
• server.ps1 — local web server script (used automatically by the Windows launcher)

03Launching the Application

Windows

1. Double-click Launch TimesheetEditor.bat

A black server window will appear with the message "Timesheet Editor Server." This window must stay open while you use the app.

2. Your browser opens automatically

The app opens at http://localhost:8080/TimesheetEditor.html. If it does not open automatically, type that address into your browser manually.

3. When finished, close the server window

Closing the "Timesheet Editor Server" window shuts down the local web server. You can then close the browser tab.

macOS

1. First-time only: make the launcher executable

Open Terminal and run:

chmod +x "/path/to/Launch TimesheetEditor Mac.command"

2. Double-click Launch TimesheetEditor Mac.command

Terminal opens and the server starts. The browser opens automatically to the app.

3. Keep Terminal open while using the app

Close Terminal when you are done to stop the server.

04Signing In

The app opens with a lock screen. Click the Sign In with Microsoft button and authenticate using your Re-Lax O365 account.

After sign-in, the lock screen disappears and two things load automatically:

• Tech list — all technician names pulled from the Contractors folder on SharePoint
• Client list — loaded from TemplateClientList.xlsx on SharePoint (cached for 4 hours)

05Loading a Timesheet

Select a Tech and Period

Use the toolbar at the top of the screen:

What Happens After Loading

• If a timesheet exists: all entries appear in the editable table below
• If no timesheet exists yet: the table is empty and you can add new entries from scratch

06Editing Entries

The Entry Table

Each row in the table represents one time entry. All fields are editable — simply click a cell to make changes.

After-Hours Auto-Detection

When you enter or change a date or start time, the app automatically checks whether the entry qualifies as after-hours and checks the box if any of the following apply:

• The date falls on a Saturday or Sunday
• The date is a US federal holiday
• The start time is before 6:00 AM
• The start time is at or after 7:00 PM

Row Highlighting

07Adding and Deleting Entries

Adding a New Entry

Click the + Add Entry button in the toolbar. A new green-highlighted row appears at the bottom of the table, defaulting to the first day of the selected period. Fill in all required fields (marked with *): Date, Start, End, and Client.

Deleting an Entry

Click the ✕ button on the right side of any row. A confirmation prompt appears before the row is removed.

Removing Unsaved New Rows

If you added rows by mistake, the Clear New Rows button appears in the table header. Click it to remove all newly-added (unsaved) rows at once, restoring the table to its loaded state.

08Summary Bar

The summary bar at the bottom of the page shows totals across all entries currently in the table:

09Saving to SharePoint

When you are satisfied with your edits, click the Save to SharePoint button (green, top-right of toolbar).

What Happens on Save

1. The app validates that all entries have a Date, Start, End, and Client. Any rows missing required fields will trigger an error message.
2. The timesheet is rebuilt as an XLSX file in the same column format produced by the Time Tracker.
3. The file is uploaded to SharePoint at the path:

Public/Billing/Contractors/{TechName}/{TechName}_{Month}{Year}_Timesheet.xlsx

1. If a file already exists at that path it is overwritten. No version history is created automatically.
2. New rows turn from green to normal after a successful save.

10Troubleshooting

11SharePoint File Reference

All timesheet files follow this naming and path convention on SharePoint:

Public/Billing/Contractors/{TechName}/{TechName}_{Month}{Year}_Timesheet.xlsx

Example:

Public/Billing/Contractors/Chris/Chris_March2026_Timesheet.xlsx

The Client List used to populate the client dropdown:

Public/Billing/Contractors/TemplateClientList.xlsx

12Billing Calculation Notes

Hours Billed

Hours Billed = Hours Exact rounded up to the nearest 15-minute increment, plus half of any travel hours entered.

Hours Billed = ceiling(raw hours × 4) / 4 + (travel hours × 0.5)

Hours Paid (Tech)

Hours Paid is what the technician earns. After-hours entries are paid at 1.5× the standard rate.

Hours Paid = (Hours Billed × 1.5 if after-hours, else × 1) + (travel hours × 0.5)

Overnight Shifts

If the end time is earlier than the start time, the app automatically adds 24 hours to calculate the correct elapsed time (e.g., 11:00 PM to 3:00 AM = 4 hours).

13Support

For technical issues with the Timesheet Editor, contact your Re-Lax IT administrator.

Re-Lax US LLC | walter@pnw.com