SpreadsheetWEB introduces the new generation of business intelligent dashboards for hotel operators and management companies all over the world. SpreadsheetWEB Hotel Dashboard is exclusively designed to collect the essential data of hotel engagements, analyze them in depth and visualize them interactively for the correct observations. It is user-friendly to cope with complex information and visually enriched with flexible graphics.
The user will find three sheets within the template after opening it in Microsoft Excel. One of them is particularly prepared to enter the raw data into the system. This raw data consists of some items essential for hotel management such as “the number of rooms sold”, “rooms available”, “revenue per available room” (RevPAR), “average daily rate per occupied room” (ADR), “occupancy rate” and the revenues of food & beverage, telephone and other likely services.
Figure 1. Raw Data
In the second sheet, labeled “Calculations”, given data is calculated and it appears in appropriate cells like seen below.
Figure 2. Calculations
When the user enters the data manually, let’s say, in a traditional file environment, calculation works exactly like seen in screenshots. However, once the raw data sheet is converted to a web application via SpreadsheetWEB, the user continues to work only with relevant cells and see the results instantly after hitting the “Calculate” button. See the screenshot below.
Figure 3. Hotel Data Form in the web broswer
In this sense, the user will just be adding a few data entries on daily basis and viewing the result in the web browser, a plain white page without the redundancies.
Just type:
- The number of rooms sold/available, taxable/nontaxable
- The revenue per room
- The revenues of food & beverage, telephone and other services
And quickly see the results for ADR, RevPAR and the occupancy rate.
On the other hand, there is the dashboard sheet which still remains unveiled. Now let’s turn back to our Excel file and examine how the sections on dashboard layout change, depending on the data processed in side sheets or via SpreadsheetWEB.
The dashboard will normally display the following graphs:
- On the upper left, monthly revenues of rooms, food & beverage, telephone and other services are indicated in numbers. Same rates are demonstrated in an additional chart, a cake chart in the middle.
- Average ratios like ADR and RevPAR and the occupancy rate for each day in the week are projected in two extra boxes.
- On the right side, a chart reflects the changes in food & beverage, telephone and other revenues from day to day in line graphs, and the three charts below that do the same for ADR, RevPAR and the occupancy rate.
- Figure 4. Hotel Dashboard in Excel
Obviously, this hotel dashboard gives the best result when used via SpreadsheetWEB.
Because with SpreadsheetWEB,
- The user may customize the dashboard creating preferred web forms and applications, manage them by inputting new data to the system and monitor the outcome in the web brower.
- Instead of adding the data into the Excel file manually, the user is prompted to set up an online customized database and have the data feed the content in real time and automatically.
- It is easy-to-use and feature-rich in both implementation and presentation. The user may put extra images like the company logo on dashboard page.
- Figure 5. Hotel Dashboard as web application
- The user has file-sharing capability with others in a secure environment. That is to say, the user may authorize the others to work on the same file, modify the content, and send it back and forth between one another. It is flexible to license.
- It is fast and cost-effective to work the things out.
- Only basic Excel knowledge is required to use it.
