Some syntax for pulling data from Excel into FRx
This is the syntax for specifying a specific worksheet (tab) name in an Excel workbook:
But note that you’ll probably use universal pathing in which the server name is specified:
\\servernameyadayada in place of the local c drive!
Pulling data from Excel into FRx
RevPAR (revenue per available room), Occupancy Rates, Census, Revenue per Employee, RPU (revenue per user), Utilization, Realization Rate, Per Client Profitability…these are just a few of the many performance metrics that can be measured using FRx. Every industry has its own measures of performance, and all are handled using FRx calculations.
The calculations depend on whether the statistical data lives in the GL or in Excel. For the purposes of this explanation, we’ll assume it is maintained in Excel. (For what it’s worth, I much prefer to see it in the GL, but that’s another story.)
So here’s how to pull that statistic in from Excel. There are two different ways to use Excel with FRx, and we’ll focus on the one that’s most commonly used with a single statistic, the Combined Method. [click to continue…]