Eltadamun Fleet System
Screens are faithful reconstructions of an archived system, rebuilt from its real data model.
Replaced fragile spreadsheets with a system that schedules vehicles, blocks double-bookings automatically, and does the financial math on its own.
An oil company scheduled its fleet on spreadsheets: overlapping assignments slipped through, and splitting a vehicle’s costs across the departments that used it meant manual math nobody fully trusted.
Double-bookings rejected at the door
The assignment scheduler detects overlapping assignments before they save: a 9-day overlap is caught, named and refused, not discovered in the field.
Money split by actual use
The prorated engine allocates one expense across departments by how long each actually held the vehicle, to three decimal places.
Permits flagged before they lapse
Oil permits are tracked per vehicle with expiry warnings surfacing in the fleet view. Renewals happen on time, not after a stop at a checkpoint.
Reports the finance office accepts
A report builder with Excel and PDF export, backed by the activity log. The numbers leave the system the way accountants need them.
The two engines the client actually hired me for: an assignment scheduler that detects and rejects overlapping assignments before they’re saved, and a prorated financial engine that allocates an expense across departments by assignment duration, to three decimal places.
Scheduling conflicts are rejected before they're saved.
The financial split computes itself, to three decimal places.
Oil permits are flagged before they expire.
Delivered
