For Hotel Revenue Managers ·
What you'll need
Open the Google Sheet containing your data. For formula help, your data should have labeled column headers in row 1 (e.g., "My RevPAR," "Comp Set RevPAR," "Occupancy %," "ADR").
Two ways to access it:
= to start a formula, then look for the "Help me with this formula" prompt that appears in the formula barIn the Gemini sidebar or formula prompt, type exactly what you want the formula to calculate. Be specific about which columns your data is in.
Example requests:
The AI will generate a formula and explain what each part does. It will look something like:
=(B2/C2)*100
Or for more complex calculations:
=AVERAGEIF(E2:E100,">85%",D2:D100)
Read the explanation to confirm it matches your intent before using it.
Click "Insert formula" or copy the formula into your cell. Test it with a row where you know the correct answer — for example, if your RevPAR is $142 and comp set is $128, a RevPAR index of 110.9 tells you the formula is working correctly.
Once the formula works in one cell, drag the fill handle (small square in the bottom-right corner of the cell) down to apply it to all rows.