Fleet Command Center EctiveGlobal

A professional Excel-based fleet management system designed for logistics companies, government agencies, car rental services, and businesses managing vehicles. This tool helps you track vehicles, drivers, fuel usage, maintenance, and expenses—all in one place.

✅ What’s Included

Vehicles Database

Vehicle ID, Model, Car Type, Department

Fuel Limit & Fuel Used

Exceed Status (auto-flags “EXCEED by X L” in red if limit is surpassed)

Reorder alerts for critical supplies

Fuel Log

Fuel entries per trip

Driver PIN (for accountability & tracking)

Auto-calculations for fuel costs & usage

Drivers

Driver ID, Name, Contact, Region

PIN Issued (Yes/No)

Links to trips & assigned vehicles

Temporary Drivers Sheet

Records of temp drivers & their department

Trip Authority Number for security approval

Vehicle assigned, contact info, assignment period

Trips & Expenses

Trip records with distances, fuel used, and costs

Maintenance & other operating expenses

Dashboard (Interactive)

KPIs:

Total Vehicles

Total Trips

Fuel Usage vs. Fuel Limit (with exceed count 🚨)

Total Expenses & Net Profit

Charts:

Bar Chart → Fuel Usage vs. Fuel Limit per Vehicle

Pie Chart → Expense Breakdown by Category

What's included (quick summary)

• Vehicles, Drivers, TempDrivers, Trips, Maintenance, Expenses sheets (tables + sample data)
• Dashboard with KPIs (Total Vehicles, Total Trips, Fuel Used, Exceed Count, Total Expenses, Net Profit)
• Formulas (SUMIFS, COUNTIF, IF, TEXT) that auto-calculate FuelUsed per vehicle and Exceed status.
• Conditional formatting highlights vehicles that EXCEED fuel limits.
• Simple bar & pie charts on the Dashboard.
• Freeze panes, auto column widths, and table formatting for easy editing.
• Offline & editable — no external services required.