For Hotel Revenue Managers ·
What you'll need
Click the Gemini icon (sparkle/star icon) in the top-right toolbar, or go to Extensions > Gemini in Sheets. The Gemini panel opens on the right.
Type your request in plain language:
"I have pickup data in Sheet1 with columns: Arrival Date (A), Rooms On Books Today (B), Rooms Same Date Last Year (C), Budget Rooms (D), ADR (E). Help me create a summary dashboard in a new sheet that shows: pace variance vs last year as a %, pace variance vs budget as a %, and a status column that says AHEAD, ON TRACK, or BEHIND based on whether variance is above +5%, between -5% and +5%, or below -5%."
Gemini will suggest formulas for each column. A typical response will give you:
Pace vs LY (%): =(B2-C2)/C2*100
Pace vs Budget (%): =(B2-D2)/D2*100
Status column: =IF((B2-C2)/C2*100>5,"AHEAD",IF((B2-C2)/C2*100<-5,"BEHIND","ON TRACK"))
Copy each formula into the appropriate column of your dashboard sheet.
Ask Gemini: "How do I apply conditional formatting to the Status column so AHEAD is green, ON TRACK is yellow, and BEHIND is red?"
Gemini will give you step-by-step instructions:
Ask Gemini: "Add a row at the top that calculates the average pace variance vs last year for arrival dates in the next 30 days only."
Gemini generates an AVERAGEIFS formula: =AVERAGEIFS(E2:E100,A2:A100,">="&TODAY(),A2:A100,"<="&TODAY()+30)
Once your dashboard is working: