Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create an advanced Excel system for managing crew cleaning schedules on a cruise ship.
- Company: Join a dynamic team focused on optimising operational efficiency in the cruise industry.
- Benefits: Gain hands-on experience with advanced Excel and VBA automation in a real-world setting.
- Why this job: Make a tangible impact by improving and stabilising essential scheduling systems.
- Qualifications: Expertise in advanced Excel formulas and VBA coding required.
- Other info: Opportunity to work on a critical project with potential for future collaboration.
The predicted salary is between 36000 - 60000 £ per year.
I am building an advanced Excel system for managing crew cabin cleaning schedules on a cruise ship. The workbook already contains:
- MASTER sheet (all cabins + fixed cleaning weekday + points + early eligibility)
- DAGSPLAN sheet (daily schedule generated via formulas)
- ROSTER (active crew per week)
- AVVIK (override cleaning date)
- LOGG (history)
- PRINT sheets per crew
The system must:
- Automatically generate a daily list based on fixed weekday.
- Allow manual overrides (AVVIK) that temporarily move a cabin to a different date.
- Automatically deactivate overrides once used.
- Auto-distribute cabins to Crew 1–5: Max 12 points per crew.
- Keep corridor grouping as intact as possible.
- Avoid mixing port/starboard on same deck.
- Distribute fairly when exact balance is impossible.
- Handle "Early cleaning" separately (own print list).
- Be stable even with 150+ rows.
What I Need
I need someone highly experienced in:
- Advanced Excel formulas (INDEX, AGGREGATE, SUMPRODUCT, dynamic filtering)
- VBA (robust, clean, well-structured code)
- Logic building and distribution algorithms
- Error handling and performance optimization
This is NOT a beginner Excel task. The file has working parts but needs:
- Debugging
- Clean restructuring
- More robust logic
- Simplification where possible
Important
This system is used operationally in a real work environment. It must be stable and reliable.
I am not looking for:
- Over-engineered Power BI solutions
- Python rewrites
- "Let's rebuild everything from scratch"
I want to improve and stabilize the current Excel/VBA structure.
Deliverables
- Clean, structured VBA modules
- Optimized formulas
- Clear logic explanation
- Commented code
- Final tested working version
Please Include
- Examples of similar Excel automation work
- Experience with distribution/optimization logic
- Your approach to debugging complex Excel systems
- Contract duration of less than 1 month.
Mandatory skills: Microsoft Excel, Automation, Spreadsheet Software
Advanced Excel + VBA automation – Crew cleaning scheduling system employer: FreelanceJobs
Contact Detail:
FreelanceJobs Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Advanced Excel + VBA automation – Crew cleaning scheduling system
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry and let them know you're on the hunt for opportunities. You never know who might have a lead on a role that fits your skills perfectly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your advanced Excel and VBA projects. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on common Excel and VBA questions. Practice explaining your thought process when tackling complex problems, as this will demonstrate your expertise and logical thinking.
✨Tip Number 4
Don't forget to apply through our website! We often have exclusive roles listed there, and applying directly can sometimes give you an edge over other candidates. Plus, it shows you're genuinely interested in joining us!
We think you need these skills to ace Advanced Excel + VBA automation – Crew cleaning scheduling system
Some tips for your application 🫡
Show Off Your Excel Skills: Make sure to highlight your advanced Excel skills in your application. We want to see examples of your work with complex formulas and automation, so don’t hold back on showcasing your expertise!
VBA is Key: Since this role heavily relies on VBA, include specific examples of your clean and robust code. We’re looking for someone who can demonstrate their ability to build structured modules, so share your best projects!
Explain Your Logic: When you describe your past experiences, be sure to explain the logic behind your distribution algorithms and error handling. We love a clear thought process, so make it easy for us to understand your approach.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to keep track of your application and ensure it gets the attention it deserves. We can’t wait to see what you bring to the table!
How to prepare for a job interview at FreelanceJobs
✨Know Your Excel Inside Out
Make sure you’re well-versed in advanced Excel formulas like INDEX, AGGREGATE, and SUMPRODUCT. Brush up on dynamic filtering techniques too, as these will be crucial for the role. Practising with real-life scenarios can help you demonstrate your skills effectively.
✨Show Off Your VBA Skills
Prepare to discuss your experience with VBA automation. Bring examples of clean, structured code you've written in the past. Be ready to explain your logic building and how you handle error management, as this will show your depth of knowledge.
✨Understand the Project Requirements
Familiarise yourself with the specific needs of the crew cleaning scheduling system. Think about how you would approach debugging and restructuring the existing workbook. Showing that you understand the operational importance of stability and reliability will impress the interviewers.
✨Prepare for Problem-Solving Questions
Expect questions that test your problem-solving abilities, especially around distribution algorithms and performance optimisation. Practice explaining your thought process clearly, as this will demonstrate your analytical skills and ability to simplify complex issues.
