Project management - Excel-lence

    
        Custom VBA applications for         
            project management

Context

Regardless of the size of your organization and the sector in which you operate, managing a portfolio of projects can quickly become a nightmare without the right tools. In the market, there are various standard IT solutions dedicated to project management, allowing for the control of different phases in the project life cycle:

Initiation
Planning, execution
Monitoring and closure

Existing Solutions

However, these solutions start to show shortcomings as soon as you want to move beyond the theoretical realm and establish a customized process that takes into account the specificities of your industry and environment. It is at this point that companies reach out to us to design and implement bespoke solutions, enabling them to manage their projects end-to-end with their methods and philosophies while adhering to universal project management standards. Contact our experts. We will provide two examples of our achievements:

Example 1 of a custom VBA project management application

- Our client is a multinational company that manufactures and assembles machines in the pharmaceutical sector. They have 11 sites across four continents. Construction project management needs to be centralized in a single, multi-user, and multi-site tool. The client already had their simple Excel file-based management system, which was the result of several years of experience. Our mission was to design a custom Excel VBA application that would both organize the work method, structure the data, and maintain the existing operational approach.

Use Cases

The outcome was very satisfactory; the application allows for:
a. Creating, modifying, and deleting multi-site projects.
b. Assigning resources (people & machines) to each project.
c. Visualizing a workload plan according to various criteria.
d. Visualizing a Gantt chart according to various criteria.
e. Managing the purchase of machines.
f. Visualizing a comprehensive dashboard based on various analysis criteria (site, date range, professions, expertise)

Example 2 of a custom VBA project management application

- Our client is an organization that manages artistic events, such as concerts. Their activity is very specific. The application to be developed will be used by 40 people, and the Excel database must be accessible via the internet. The client already had their simple Excel file-based management system, which was the result of several years of experience. Our mission was to design a custom Excel VBA application that would both organize the work method, structure the data, and maintain the existing operational approach. The outcome was very satisfactory.

Application Usage

The application allows for:
a. Creating, modifying, and deleting events.
b. Controlling overlaps between different events.
c. Tracking the budget for each project (planned, actual, and variance).
d. Visualizing a budget summary by cost center, department, and project.
e. Creating a detailed schedule for each project (schedule for equipment transport, sound, lights, and venues).
f. Assigning teams to each project.

Custom VBA applications for project management