Fleet Management Planner

Databases & SQL — incorrectly specified categories?

111 USD

Project translated automatically. Log in or register, to view the original

Excel file “Machine and Driver Planner”

It is necessary to create a convenient Excel file for planning the work of machines and drivers.

What should be in the file:

Machine directory:
- Machine number, type, status (in operation / under repair / free), notes.
Driver directory:
- Name, ID, cadence (start and end date), possible shifts.
Schedule by days:
- Each row — machine.
- By dates (for example, calendar of the month) it shows who is working on it.
- Shifts can be specified (day / night / day off).
- Automatic highlighting of free machines and overlaps.
Functionality:
- Display of occupied and free machines by date.
- Ability to filter: “Show all free machines on 15.09.2025”.
- Calculation of the number of shifts, trips, days for each machine and driver.
- Check for overlaps (if one driver is assigned to 2 machines on one day — it is highlighted).
Additionally:
- Connection with the payroll file (by driver ID or machine number).
- Power Query or simple formulas (without VBA, so everything updates safely).
- 6. Analytics

Proposals 3 Rejected 1

Vitaly B.

20 1

Projects 20
Rating -
Rating 1 213

Budget: 5000 UAH Deadline: 5 days

Hello, I developed a similar project for Scania.
Write to me in private, we will discuss the details, I will show a demo)

Oleksandr Chinnik

0 1

Projects -
Rating -
Rating 255

Budget: 5000 UAH Deadline: 5 days

Hello! 👋
I can create a convenient and fully automated Excel planner for vehicles and drivers without VBA, using only formulas, tables, and Power Query – so that everything is safe and easy to update.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Maksym O.

5 0

Budget: 5000 UAH Deadline: 1 day

Hello, I worked on **Fleet Planning** — created an Excel file with 50 cars and 30 drivers for schedules + automatic highlighting. Is it important for you that the file works without VBA, only with formulas?

I suggest we get in touch, I will consult you for free on the technical side and we will create a development plan + I will tell you about my team!

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 16 proposals 31 July

Not specified
Construction of an automatic scheme for the movement of goods and monetary flows

35 proposals 30 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 41 proposals 27 July

178 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Iryna Ileiko
Kyiv, Ukraine

Projects 1
Rating -
Rating 36

Vitaly B.

Oleksandr Chinnik

Proposals are currently absent

Maksym O.

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Construction of an automatic scheme for the movement of goods and monetary flows

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Development of an analytical system with a dashboard