Excel expert - Automated Rostering and Scheduling Tool for Cruise S...

We are seeking a skilled developer to create an automated rostering and scheduling tool for our cruise ship company. The primary goal is to efficiently assign guides to various trips, taking into account a complex set of criteria.

The tool must be able to:

1.  Manage Guide Profiles: Store and retrieve detailed information for each guide, including their specific skills (e.g., Language proficiency, specialized tour knowledge), availability, personal preferences for certain trips or times, and defined blackout dates.

2.  Manage Trip Requirements: Define the needs for each cruise trip, such as the required number of guides, the specific skills needed for that trip (e.g., A guide fluent in Spanish for a Latin American cruise), and the duration of the trip.

3.  Automated Matching Logic: Implement an algorithm to cross-reference guide data with trip requirements and constraints. This system should intelligently suggest or automatically assign the best-suited guides to each trip, optimizing for preferences while adhering to all mandatory requirements and availability.

4.  Output Generation: Produce a clear, easy-to-read schedule or grid that displays trips and their assigned guides. The output should facilitate quick review and potential manual adjustments.

The ideal candidate will have experience in developing robust scheduling systems and working with complex data sets and constraint-based logic. The solution should aim to streamline our current manual rostering process, reducing administrative overhead and improving guide allocation efficiency.

Category: IT & Programming Subcategory: Desktop apps What is the scope of the project?: Create a new app