Operations DashboardREAL-TIME MAINTENANCE OVERVIEW
Work Orders by Type
Status Distribution
Recent Work Orders
Activity Feed
📅 Upcoming Preventive Maintenance
View all →
Work OrdersMAINTENANCE NOTICES MANAGEMENT
Equipment RegistryINSTRUMENTS, COMPONENTS & DEVICES
| Tag | Name | Category | Location | Manufacturer | Model | Status | Actions |
|---|
Maintenance ReportsKPIs, RELIABILITY & PERFORMANCE INDICATORS
RELIABILITY INDICATORS
Overall Progress0%
0
COMPLETED
0
IN PROGRESS
0
OPEN
Failure Causes
🔥 Most Failed Equipment
Failure Modes Distribution
MTBF / MTTR by Equipment
Mean Time Between Failures & Mean Time To Repair
| Equipment | Failures | MTBF (days) | MTTR (hrs) | Downtime (hrs) | Availability % | Last Failure |
|---|
Work Orders Detail
Statistical AnalysisMAINTENANCE PERFORMANCE INDICATORS
Monthly Trend
Priority Distribution
Avg Progress by Type (%)
Equipment Status
Drive FilesATTACHMENTS FROM ALL WORK ORDERS
🔍
—
CatalogsFAILURE CAUSES, MODES & MAINTENANCE TYPES
Failure Causes
Failure Modes
User ManagementTECHNICIANS & ADMINISTRATORS
| Name | Username | Role | Phone | Status | Actions |
|---|
System SettingsCONFIGURATION & INTEGRATIONS
Cloud Connection
Google Sheets is the primary database. All devices share the same data automatically. Files are stored in Google Drive.
Handles Work Orders, Equipment, Users sync
Handles file & image uploads to Google Drive
Appearance
Dark / Light mode
Data Management
—
Download all data locally
Google Apps Script
⚡ Setup Steps
1. Go to script.google.com → New Project
2. Paste script → replace
3. Deploy → New Deployment → Web App
Execute as: Me · Who has access: Anyone
4. Copy the
⚠ Every script edit needs a new Deployment to take effect.
2. Paste script → replace
YOUR_SPREADSHEET_ID_HERE3. Deploy → New Deployment → Web App
Execute as: Me · Who has access: Anyone
4. Copy the
/exec URL → paste above → Save & Reload⚠ Every script edit needs a new Deployment to take effect.