📞 Conference Booking System

Centralized Excel-based room & conference booking system with automated calendar management, booking tracking, and draft email generation for office receptions and facility managers.

📋 What This Does

Solves the problem: How to manage conference room bookings across multiple offices, prevent double bookings, track all reservations, and automatically generate confirmation emails.

Key Benefits:

• Centralized booking system for all offices
• Multi-room/space booking support
• Calendar view to check availability
• Automatic "Booked" status indicator
• Draft email generation for confirmations
• Time-based booking (from/to times)
• Automatic total hours calculation
• Booking history tracking
• VBA macro automation
• No double bookings possible

📸 View the File

Access Conference Booking System

Password: 123 Enable Macros for VBA functionality

---

📸 System Screenshots

Conference Room Booking Form

Professional booking form with date selection, office dropdown, location selection, check-in/out times, and automatic total hours calculation.

Monthly Availability Calendar

Interactive calendar displaying full month with booked slots highlighted for quick availability reference.

Validation & Configuration Sheet

System validation sheet with all office names, available room types, and working hours configuration.

---

✨ Main Features

1. Booking Form

• Date entry (DD-MM-YYYY format)
• Auto-calculated Month & Day
• Office Name dropdown (validated list)
• Booking For (meeting/project name)
• Location dropdown (Conference Room, Training Room)
• Booking Timing IN (start time HH:MM)
• Booking Timing OUT (end time HH:MM)
• Auto-calculated Total Hours
• Booking By (person name)
• Admin Coordinator Contact Number
• Save button to record booking

2. Booking Tracking Sheet (Working Sheet)

• Complete list of all bookings
• Serial Number for each booking
• Office Name & Location details
• Booking purpose & requester info
• Check-in & check-out times
• Total hours (auto-calculated)
• Admin coordinator details
• "Send Mail" button for each booking
• Auto "Booked" status display

3. Calendar View

• Full monthly calendar display
• Booked dates are visually highlighted
• Available slots clearly shown
• "Back To Home" button for navigation
• Quick reference for scheduling
• Prevents double bookings

4. Draft Email Generator

• Auto-generates booking confirmation emails
• Uses HYPERLINK function
• DraftMail button on each booking
• Auto-populates with booking details
• CC/BCC functionality
• Easy recipient management
• One-click email sending

5. System Validation

• Office name dropdown (prevents errors)
• Location validation (approved rooms only)
• Working hours configuration
• Time format validation
• Prevents unauthorized office entries
• Configurable office list

6. VBA Macro Automation

• Auto email generation
• Hyperlink functionality
• Calendar navigation buttons
• Booking status auto-update
• Time calculations
• Form data automation

🚀 How to Use

Step 1: Enable Macros

1. Download file from link
2. Open in Microsoft Excel
3. Enable Macros when prompted
4. VBA features now active

Step 2: Book a Conference Room

1. Go to "Book_Office_Room" sheet
2. Enter booking date
3. Select Office Name (dropdown)
4. Enter "Booking For" (purpose)
5. Select Location (room type)
6. Enter Booking Timing IN (start)
7. Enter Booking Timing OUT (end)
8. Total Hours auto-calculates
9. Enter Booking By (name)
10. Enter Admin Contact Number
11. Click "Save" button

Step 3: Check Room Availability

1. Click "Calander" button
2. View monthly calendar
3. See booked dates highlighted
4. Identify available time slots
5. Click "Back To Home" to return

Step 4: Send Confirmation Email

1. Go to "Working Sheet"
2. Find your booking row
3. Click "DraftMail" button
4. Email auto-generates
5. Add recipient in TO section
6. Click send

Step 5: Manage System

1. Open "Validation_Sheet"
2. Update office names if needed
3. Update room types if needed
4. Modify working hours if needed
5. Changes apply to all bookings

📊 Real-World Usage

Corporate Office Booking:

Date: 15-Jan-2025
Office: WTC Office
Location: Conference Room
Booking IN: 10:00 AM
Booking OUT: 1:30 PM
Total Hours: 3:30
Booking By: John Smith
Status: Booked (auto-confirmed)
Email: Auto-sent to recipients

Training Session:

Date: 20-Jan-2025
Office: WTC Office
Location: Training Room
Booking IN: 2:00 PM
Booking OUT: 5:30 PM
Total Hours: 3:30
Booking By: Sarah Johnson
Calendar: Updated automatically
Conflicts: None (checked automatically)

💡 Key Benefits

✅ Centralized Management: All bookings in one system
✅ Conflict Prevention: No double bookings possible
✅ Visual Availability: Calendar shows open slots
✅ Auto Confirmations: Email generation
✅ Time Tracking: Total hours calculated
✅ Multi-Office Support: Manage all locations
✅ Professional Form: Easy user interface
✅ Booking Status: Auto "Booked" indicator
✅ Data Validation: Prevents errors
✅ VBA Automation: Smart operations

🔧 Customization

Add New Office:

1. Open "Validation_Sheet"
2. Add office name & working hours
3. Auto-available in form dropdown

Add New Room Type:

1. Open "Validation_Sheet"
2. Add office space name
3. Available in Location dropdown

Change Working Hours:

1. "Validation_Sheet" → Update hours
2. Reflects in all new bookings

Modify Email Recipients:

1. "Working Sheet" → Find booking
2. Click DraftMail
3. Add recipients in TO/CC
4. Send email

📞 Contact

• GitHub
• Email: suubhamghadge@gmail.com
• LinkedIn

📄 License

MIT License - Free to use and modify

---

🌟 Project Stats

---

📞 Centralized Booking - No Conflicts - Auto Confirmations - Easy Management

⭐ If this helps your office operations, please star this repository!

Password: 123 | Enable Macros | VBA Enabled