Using conditional formatting in Excel to fool with FRx budget variances Well, here's where we're going to go today: 'stoplights', or red color coding, for unfavorable budget variances. You do know we're going to Excel for this, right? Here's the initial budget variance report … [Read more...]
FRx Currency Translation with Excel
Overview of FRx currency translation using Excel This is going to be just a brief overview! There are a couple of ways to handle currency translation with FRx. One way is by linking to an Excel worksheet. (I had to do this in London a few years back...tough job but someone's … [Read more...]
Specify a Worksheet Name when Linking FRx to Excel
Some syntax for pulling data from Excel into FRx This is the syntax for specifying a specific worksheet (tab) name in an Excel workbook: c:\frxtrain\io_data\[tutorial.xls]corp But note that you'll probably use universal pathing in which the server name is … [Read more...]
Link FRx to Excel to Calculate Statistics
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 … [Read more...]
Graphing with FRx
Using FRx with Excel to create financial charts and graphs While FRx doesn’t exactly have any inherent graphing capabilities, it can be used in conjunction with Excel to create a graph that automatically updates when the FRx report is refreshed. Here’s how. 1. First, choose or … [Read more...]