Hour Tracker

Schedule staffing tool used for shift analysis and schedule building.

Table of Contents

• Background
• Usage
• Download
• Developer Setup
  • Requirements and Tools
  • Initial Setup
  • Building the Program
• FAQ
  • Program freezes and takes a while to run
  • The total hours are calculated incorrectly
  • None of the functions work
  • Lunch Data doesn't include lunch shifts
• License
• Maintainer

Background

Staff scheduling at WCCT Global is done via Excel Spreadsheets in a set format. This program aims to quickly analyze the schedule to obtain the following information:

• Holistic overview of what days staff are scheduled and for what times.
• New Excel spreadsheet containing staff names, and their associated shifts.
• New Excel spreadsheet containing a complete list of all shifts, the staff name, their scheduled lunches, and their scheduled hours.

Usage

This tool allows users to analyze a schedule and perform several functions to gain critical data.

Functionality:

• Import (Step 1) In order to perform any of the following functions, the schedule needs to be imported.

• Hour Tracker Tracks staff across the time period of the input schedule. Calculates their total shifted hours for the time period, shifted days, and number of shifted days. Creates a sheet at the end of the input workbook containing the corresponding data.

The created sheet is found at the end of the imported schedule.

• Names Only Creates a new Excel workbook containing the same days as the input schedule. Copies over the staff and their shift times ONLY.

Creates a new Excel document located in the program folder containing the generated Names Only sheet, ready to be sent out.

• Lunch Data Creates a new Excel workbook containing all staff shifted throughout the input schedule, their shift start, shift end, lunch in/out (if input into input schedule), and their shift length in hours. Optionally takes in a staff roster Excel workbook which is used to gather full names.

Optional Roster Import

Creates a new Excel document located in the program folder containing the generated lunch data.

Download

Releases can be found here at Github.

Developer Setup

This document aims to provide information on how to set up and build the source code.

Requirements and Tools

This build utilizes the following:

• Java JDK 16+
• Javafx 11+
• Apache POI 4.1.0+ (for EXCEL API)
• Launch4j (for wrapping as .exe and bundling with jre)
• JRE 1.8.0+ (for bundling)

Initial Setup

In order to run the application:

1. Import Java JDK, JavaFX, and Apache POI.
2. Run 'HourTrackerExe.java'.

Building the Program

Building the application into a .jar file:

1. Compile 'HourTrackerExe.java'.
2. Navigate: Build > Build Artifacts > Build.
3. The .jar file will be located under /out/artifacts/Main_java_jar/Main.java.jar.

Optional 4. Open Launch4j. 5. Open the settings located here: /settings/HourTracker.xml. 6. Tweak the settings as fit. Note: Ensure that the bundled jre is located within the output directory. Ensure directories are correct. 7. Run Launch4j.

FAQ

Program freezes and takes a while to run

The program is running thousands of concurrent calculations. Give it a minute to complete.

The total hours are calculated incorrectly

Ensure that the shifts on the imported schedule follow xxxx-yyyy military time and have no typos (such as 2303 instead of 2330).

None of the functions work

Make sure the imported schedule is the master schedule following the WCCT schedule format and that the times follow military time.

Lunch Data doesn't include lunch shifts

Lunch shifts have to be manually input into the master schedule following the xxxx-yyyy military time format.

License

MIT License Copyright (c) 2021 Shane Gilbert

Maintainer

@ShaneGilbert