Technical Task
Project
BOLT_CARS.xlsm
A simple and fast program for a car service in Microsoft Excel 2007+ (Windows, Ukrainian language) needs to be created.
The main requirement is stable operation, not complex design.
Sheets
- Order
- Clients
- Cars
- Works
- Spare Parts
- Archive
Sheet "Clients"
Fields:
No ID.
Sheet "Cars"
Fields:
- Owner (client)
- Brand
- Model
- Engine
- Year
VIN, license plate, color, and mileage are not required.
Sheet "Works"
Fields:
Sheet "Spare Parts"
Fields:
Sheet "Order"
Fields:
- Order No.
- Date
- Client
- Phone (automatically)
- Car
Next:
Works
6 rows
Columns:
Spare Parts
30 rows
Columns:
- Spare Part
- Quantity
- Price
- Total
At the bottom:
- Total works
- Total spare parts
- Grand total
Logic
Client
After selecting a client:
- automatically fill in the phone;
- the list of cars should show only the cars of this client.
Car
If there is no new car:
it can be entered manually.
After pressing "Save"
it is automatically added to the database of this client's cars.
Works
After selecting a work:
the price is automatically filled in.
The price can be changed manually.
Spare Parts
After selection:
the price is automatically filled in.
Quantity is entered manually.
Total is calculated automatically.
Archive
After pressing "Save"
the order is recorded in the archive.
After that:
- the form is cleared;
- a new number is created;
- the current date is set.
Print
A4 format.
The entire invoice must fit completely on one sheet.
Buttons
On the "Order" sheet:
All buttons must work without errors.
VBA Requirements
- No
Select - No
Activate - Code broken down by modules
- Comments in Ukrainian
- Simple code that is easy to maintain
Interface
- Light design.
- Only necessary fields.
- Large input fields.
- Clear labels.
- Maximally simple interface.
Main Requirement
The program must be simple and stable.
Sequence of actions:
- Open the file.
- Press "New Order".
- Select a client.
- Automatically get the list of their cars.
- Select a car.
- Add works.
- Add spare parts.
- Press "Save".
- Press "Print".
No unnecessary actions.
What needs to be delivered
- The finished file BOLT_CARS.xlsm.
- All macros must already be connected.
- All buttons must work.
- The project must be tested before delivery.
- Excel 2007+ (Windows).
- Ukrainian language.