1. Hotel Selection
1.1. Available Hotel Details
1.1.1. Available rooms
1.1.1.1. Room types
1.1.2. Available dates
1.1.3. Hotel Location (city)
1.1.4. Hotel Location (address)
1.1.5. Hotel Name
1.2. Things Required to Determine
1.2.1. Room Requirements per band
1.2.2. Proximity of hotel to festival
1.2.3. Star rating of each hotel
1.2.4. Hotel List
1.2.5. Sideshows
1.2.6. Festival Timetable
1.3. Need a visual way to allocate hotels
2. Raw Info Inputted/Provided
2.1. Darren (Festival Manager)
2.2. Travel Agents
2.2.1. Agents may have issue as they use their spreadsheets for costing
3. Selection of Flights
3.1. Available Flt Details
3.1.1. Flt Number
3.1.2. Date
3.1.3. Available Pax
3.1.3.1. Business Class Pax
3.1.3.2. Economy Class Pax
3.1.4. Flt Arrival Time
3.1.5. Flt Departure Time
3.1.6. Arrival City
3.1.7. Departure City
3.1.8. Potentially Cost per each seat
3.2. Things Required to Determine
3.2.1. minimum time needed before stage
3.2.2. enough Local reps??
3.2.3. Promo Schedules
3.2.4. Sideshows
3.2.4.1. Venue
3.2.4.2. City
3.2.4.3. Date
3.2.5. Festival Timetable
3.3. Need a visual way to allocate flights
4. Data Supplied to Transport That Does Not Require Us to Make Decisions
4.1. Package
4.1.1. Promoter rep
4.1.1.1. Home City
4.1.1.2. Email
4.1.1.3. Phone Number
4.1.2. Bands
4.1.2.1. Pax Numbers
4.1.2.2. Artist Names
4.1.2.3. Position
4.1.2.4. Food Preferences
4.1.2.5. Flight and Hotel Class Requirements
4.2. Festival
4.2.1. City
4.2.2. Address
4.3. Festival Timetable
4.4. Flight Details (once confirmed by Travel Agents)
4.4.1. Date
4.4.2. Time
4.4.3. Band
4.4.4. Flt Arrival Time
4.4.5. Flt Departure Time
4.4.6. Arrival City
4.4.7. Departure City
4.4.8. Flt Number
4.5. Hotel Details (once confirmed by Travel Agents)
4.5.1. Band
4.5.2. Hotel Name
4.5.3. Address
4.5.4. Room Allocation
4.5.4.1. Band Name
4.5.4.2. Artists Names
4.5.4.3. Room Type
4.5.4.4. Potentially Cost per each room
4.6. Sideshows
4.6.1. City
4.6.2. Date
4.6.3. Bands
4.6.4. Venue
5. Sharing Requirements
5.1. Must have multiple users connected and editing data at once
5.2. Data must be able to be locked off at a certain date and then changes will automatically highlight through all reports/sheets
6. Output Reports
6.1. For Darren
6.1.1. Flight selection output
6.1.1.1. Flight Info
6.1.1.1.1. Flight
6.1.1.1.2. Arrival Time
6.1.1.1.3. Departure Time
6.1.1.1.4. Arrival City
6.1.1.1.5. Departure City
6.1.1.1.6. Date
6.1.1.1.7. Flt Number
6.1.1.2. Band Info
6.1.1.2.1. Artist Position
6.1.1.2.2. Artist Names
6.1.1.2.3. Flight and Hotel Class Requirements
6.1.1.2.4. Local Rep
6.1.1.2.5. Package Number
6.1.1.2.6. Band Name
6.1.1.3. Festival Info
6.1.1.3.1. Playing Time
6.1.1.3.2. Sideshows per Band
6.1.2. Individual Band Travel Summary
6.2. For Travel Agents
6.2.1. Flights
6.2.2. Hotels
6.2.3. Cars
7. Master Travel Summary
7.1. Expandable Info for each category
7.2. Simple version on first glance
7.3. Click on any category to get a full breakdown
7.3.1. Coaches
7.3.2. Flights
7.3.3. Hotels
8. Ground Transport Requirements (Once Flights and Hotels completed)
8.1. Cars
8.1.1. Vehicle
8.1.2. Vehicle Name
8.1.3. Vehicle Type
8.1.4. Date Out
8.1.5. Time Out
8.1.6. Date In
8.1.7. Time In
8.1.8. Potentially Cost
8.1.9. Confirmed?
8.2. Coaches
8.2.1. Coach Type
8.2.2. Date Booked
8.2.3. Time Booked
8.2.4. Pax
8.2.5. Potentially Cost
8.2.6. Confirmed?