Equipment Utilization Tracker: User Manual

Introduction

Welcome to the Equipment Utilization Tracker! This tool is designed to provide a simple, visual, and intelligent way to log, track, and analyze equipment downtime. It replaces manual logbooks and complex spreadsheets with an interactive timeline and a powerful backend, enabling maintenance planners, supervisors, and operations teams to gain clear insights into their equipment's performance.

This manual will guide you through all the features of the application, from basic downtime booking to advanced AI-powered analysis and configuration.

Section 1: Getting Started - The Tracker View

The Tracker is the main screen and your primary workspace for logging downtime.

1.1 The Timeline Interface

Equipment List: On the left, you'll see a list of all configured equipment.
24-Hour Timeline: Each piece of equipment has a corresponding 24-hour timeline, divided into Day Shift (06:00 - 18:00) and Night Shift (18:00 - 06:00).
Time Blocks: The timeline is composed of 5-minute blocks. The header above the timeline indicates the hours.
Changing Views: Use the "View" dropdown at the top-left to switch between the full 24 Hour View, a focused Day Shift view, or a focused Night Shift view.

1.2 Booking Your First Downtime Event

Booking downtime is an intuitive click-and-drag process.

Navigate to the row of the equipment you want to book downtime for.
Click and hold the left mouse button on the 5-minute time block where the downtime started.
Drag your mouse across the timeline to cover the entire duration of the downtime. The selected blocks will be highlighted in blue.
As you select, a small information box will appear at the top-right of the screen, showing the selected equipment and the start/end times.
Release the mouse button. The "Add Equipment Booking" modal window will automatically appear.

1.3 The Booking Modal

This form is where you provide the details for the downtime event. The form is intelligent and will only show you options relevant to the equipment you selected.

Equipment: This is pre-filled based on your timeline selection.
System Type: Click on the system that was affected (e.g., 'Conveyor', 'Pump'). The options available are determined by the relations you set up in the Admin panel.
Responsible Section: Select the team responsible for the repair (e.g., 'Mechanical', 'Electrical'). The options here are filtered based on the System Type you selected.
Fault Type: Select the specific reason for the downtime (e.g., 'Trip', 'Leakage'). These options are filtered based on the System Type.
Comments: Add any relevant notes or details.
Click Save to confirm the booking. The event will now appear on the timeline, colored according to the responsible section. Click Cancel to discard.

1.4 Viewing Booking Details

To see the details of an existing event, simply click on the colored booking on the timeline. The "Booking Details" modal will appear, showing all the saved information in a read-only view.

Section 2: The Meeting View

The Meeting View tab provides a condensed, high-level overview of all logged events, perfect for daily stand-up meetings or operational reviews.

Summary Bars: Instead of individual blocks, each booking is shown as a single, continuous bar.
View Details: Hover over a summary bar to see a tooltip with key details. Click on the bar to open the full "Booking Details" modal.
Export as TXT: Click this button to download a simple text file summarizing all the day's bookings, ready to be shared or archived.
Clear All: Click this button to permanently delete all bookings from the tracker. A confirmation prompt will appear to prevent accidental deletion.

Section 3: The Auto Booker (AI-Powered Booking)

The Auto Booker tab uses Google's Gemini AI to analyze raw data and automatically generate booking suggestions, saving you significant time on manual entry.

3.1 Method 1: From CSV File

Go to the Auto Booker tab and ensure the From CSV sub-tab is selected.
Prepare your CSV file. It must have a header row with 'Time' as the first column, followed by the names of your equipment. Each subsequent row should contain a timestamp and the corresponding values. A non-zero value indicates a downtime event.
Click the "Choose File" button and select your CSV.
Click Analyze CSV.

3.2 Method 2: From Historian Tags

Go to the Auto Booker tab and select the From Historian Tags sub-tab.
Paste a list of raw historian alarm tags into the large text area.
Optionally, set the Event Time for the alarms. If left blank, it will default to the current time.
Click Analyze Tags.

3.3 Reviewing and Confirming AI Suggestions

After analysis, the "Booking Preview" section on the right will populate with the AI's suggestions.

The AI will match the data to the equipment, systems, sections, and faults configured in your Admin panel.
Review the list of potential bookings. Use the checkboxes on the left to select the ones you want to create. You can use the "select all" checkbox in the header row.
Click Book Selected to add the checked items to your timeline.
Click Clear to discard the preview and start over.

Note: If the AI identifies equipment from your data that isn't in your system, it will be automatically added to your Equipment List in the Admin panel.

Section 4: The Admin Panel - Configuring Your Workspace

The Admin panel is the heart of the application. Here, you define all the data and relationships that power the tracker's intelligent features. It is divided into two main areas: Relations Manager and Data & Builder.

4.1 Part 1: Managing Your Core Data (Data & Builder Tab)

This is where you manage the foundational lists for your operation.

Equipment Management: Add, edit, or delete pieces of equipment. When adding or editing, you can include specific Historian Tags associated with that equipment. This is crucial for improving the accuracy of the Auto Booker.
System Types Management: Manage your list of broad system categories (e.g., Conveyor, Pump, Motor).
Fault Types Management: Manage your list of specific faults (e.g., Trip, Blockage, Scheduled Maintenance).
Responsible Section Management: Manage the teams or departments responsible for maintenance (e.g., Mechanical, Electrical). You can assign a unique color to each section, which will be used to color-code the bookings on the timeline.

4.2 Part 2: Creating Intelligent Connections (The Data & Builder Tab)

The Relations Builder is where you connect your data, creating the logic that makes the booking modal smart.

Understanding Relations: There are two types of relations:

Equipment ➞ Systems: Links a specific piece of equipment to the system types it contains.
- Example: GG1 Conveyor is linked to the Conveyor system type.
System ➞ Details: Links a system type to its corresponding responsible section and possible faults.
- Example: The Conveyor system is handled by the Mechanical section and can have faults like Trip or Conveyor Torn.

Using the Builder:

Select the Relation Type you want to create or edit.
For Equipment ➞ Systems: Select a piece of equipment and check all the system types that apply to it.
For System ➞ Details: Select a system type, assign a responsible section, and check all the fault types that can occur with that system.
A preview of your relation will appear in the Preview box.
Click Save Relation.

4.3 Part 3: Managing All Relations (Relations Manager Tab)

This tab gives you a complete overview of all the relations you've built.

Relations Grids: You can see all your Equipment ➞ System and System ➞ Details relations in two separate tables.
Search & Filter: Use the search bar and dropdowns to quickly find specific relations.
Actions:
- Edit: Click the Edit button on any relation to load it into the Builder for modification.
- Delete: Permanently remove a relation.
Add New: This button is a shortcut that takes you to a blank form in the Builder.

Section 5: Data Portability - Import & Export

Located in the Relations Manager tab, these features allow you to back up and share your entire application setup.

Export: Click the Export button to download a single .json file. This file contains everything: your equipment lists, all relations, and even all current bookings. Store this file as a backup.
Import: Click the Import button and select a previously exported .json file. This will overwrite all existing data in the application with the data from the file. This is useful for restoring from a backup or setting up a new instance with a pre-built configuration.
Sample json files at: Google Drive