Читать книгу Healthcare Systems - Группа авторов - Страница 25

The optimization module described above was developed in Java. We have also developed a basic graphical interface in Excel, which also contains all the data relating to the beneficiaries and the staff of the home care service organization under consideration, as well as the parameters resulting from our case study, which are necessary for the execution of the algorithm. The interface provided allows the user to make changes to the database and software settings and then generate routes.

Thanks to dedicated forms, the user can add new beneficiaries or careworkers, modify those who are already entered in the database or delete them. The distance and travel time calculations between beneficiaries are then calculated automatically from the addresses entered, using the data provided by Google Maps via its geolocation API.

The parameters relating to the rules that are the result of the collective agreements and internal policies of our applied case can also be modified, as well as the sectorization of the territory covered by the company.

The user provides a previously designed, initial schedule. From the database updated with the latest developments in staff and beneficiaries, the prototype recalculates the routes and generates an Excel file with the list of changes that compares to the initial schedule that was supplied as an input. The decision-maker will thus have the list of reassigned interventions with their date, their start and end times (unchanged since they are contractually fixed), the name of the beneficiary and the name of the newly assigned careworker.