Analyse Booking information from Bookster and Bookster Pro

Yo get a better picture of your bookings it is useful to manipulate bookings in a spreadsheet application like Excel or Open Office.

Under the "My Bookings" tab in Bookster Self Catering, there is the ability to download booking data as an Excel Spreadsheet. This information is easily imported into many other spreadsheet applications.

As I don't have Excel and Open Office is free, I am using Open Office for this example.

I have used the "Data Pilot" feature in Open Office to produce some summaries of booking data.

Some useful tips:

• To change any of the summaries, right-click anywhere in the table and click "start", this will bring up the Data Pilot interface
• Grouping of dates into years, months etc. can be done by moving the spreadsheet active box to the date zone and selecting the menu item "Data -> Group and Outline -> Group"

» more information on support.tribalogic.net