This challenge is based on the Holiday Destinations Challenge by Oz du Soleil on LinkedIn Learning. We have spiced it up somewhat!
This is a screenshot from Oz’s challenge.
This Challenge is Different!
A global corporation has offices all over the world.
In order to promote better inter-office co-operation and bonding the Chairman wants to introduce a new programme – Travel Mates.
Staff are encouraged to visit a regional office once a year, all expenses paid. They are encouraged to travel in groups of (typically) 4-5, or any number.
There are two types of people:
- Type B – Those who want to visit a City they have been to before.
- Type A – Those who want to visit a City they have never been to before.
Staff have listed where they have already been to. They will constantly update that list.
Your job is to create an Excel model to make it easy for staff to decide where they want to go next.
You are given these:
- A list of Destinations.
- A spreadsheet list for each member of staff, indicating which Type they are (A or B). They may add to this list. Currently there are approximately 35 staff joined in this scheme. It will become more popular and it is expected that more will join.
Note
- The system must be easily updatable with new staff joining, and new Destinations being added.
- The model must work intuitively. No staff training should be required.
- The model must work from anywhere in the world, within the corporate network.
- The process must not need to have an administrator. It must run itself, indefinitely.
- Finally, it must be easy to verify that the results of the model are correct. Quality assurance.
- It must be built with Excel.
- No spreadsheets are to be emailed to each other, if at all possible.
- Bonus points if you solve it following it with Oz’s basic principle in his Data Model. (Video will be posted here TBA)
Add comment