
1. Re: Simple Calculation. ADR
Alex Kerin Sep 26, 2013 7:55 AM (in response to Brandon Avants)What's wrong about it  what should the value for Residence Inn be for example?

2. Re: Re: Simple Calculation. ADR
Brandon Avants Sep 26, 2013 8:16 AM (in response to Alex Kerin)Now I believe I have some simple math mistake. Attached is just RI rates, gross and nights.
If my ADR is never for any given row less than $90.625 how can the total be less than the rows at $20.93697?
Maybe it's way too early

ADR.xlsx 9.9 KB


3. Re: Simple Calculation. ADR
Alex Kerin Sep 26, 2013 8:49 AM (in response to Brandon Avants)Your math is wrong. You need a per row calculation for nights *rooms, sum this and use it to divide out the cost. The ADR is 129.32

4. Re: Simple Calculation. ADR
Brandon Avants Sep 26, 2013 9:20 AM (in response to Alex Kerin)Thanks buddy!!!

5. Re: Simple Calculation. ADR
Brandon Avants Sep 26, 2013 4:39 PM (in response to Brandon Avants)
Just to clairify just incase someone else googles this. ADR is average daily rate. The following calc is bad to start with.sum([No of nights]) * sum([No of Rooms])
sum([Net Transaction Spend]) / ([Total Room Nights])
It needs to be just
sum({net transaction sped})/([No of nights]). No of nights in this case was all room nights so you would never double do and do no of nights times no of rooms.