Google Apps Script Revision for Travel Quotation

### **? Job Title:**
**Google Apps Script Expert Needed to Fix Extra Bed & Child Pricing in Travel Quotation Sheet**

### **? Job Description:**
I have a **Google Sheet with a dynamic hotel & room selection system** built using Google Apps Script. The script is mostly working, but I need help with **specific pricing calculations.**

### **✅ What’s Working Correctly:**
✔️ **Hotel selection updates available Room Types**
✔️ **Room Type selection fetches Meal Plan & Max Occupancy**
✔️ **Room price is correctly calculated based on selection**

### **❌ Issues That Need Fixing:**
1️⃣ **Max Occupancy does not update correctly when Room Type is selected.**
2️⃣ **Extra Bed & Child Without Bed pricing is NOT being added to the total cost.**
3️⃣ **Total Room Cost should correctly sum:**
- ✅ Room price (already working)
- ❌ Extra Bed price (multiplied by the number of extra adults & nights)
- ❌ Child Without Bed price (multiplied by the number of children & nights)

### **? Requirements:**
✔️ Experience with **Google Apps Script (GAS) for Google Sheets automation**
✔️ Strong understanding of **VLOOKUP/INDEX-MATCH formulas** inside GAS
✔️ Ability to **debug & fix existing script without breaking working functions**

I will provide:
? **The existing script**
? **A sample Google Sheet with test data**
?️ **A detailed breakdown of the required fixes**

? **Budget:** Open to fair quotes based on experience
⏳ **Deadline:** ASAP

---

### **How to Apply:**
? Send a proposal with:
- Your **experience with Google Apps Script**
- Examples of **similar projects you've completed**
- Your **estimated timeline & cost** to fix these issues