Calendars in spreadsheet bar chart
PlanBoard is a software app that retrieves appointments from Google Calendar and combines it in a bar chart in a spreadsheet. A calendar can be from a person or an object. For objects this allows for planning its rental or use, like of boats, ships, apartments, holiday homes, machines, equipment, vehicles, etc. For persons work schedules and rosters can be created from individual calendars.
The software helps you to get a high occupancy rate when scheduling objects and persons:
- The objects/persons and appointments form a bar chart clearly showing the free periods in between.
- The objects/persons are in a fixed self chosen order and are therefore quickly found back in the bar chart.
- The bar chart shows the appointments from a chosen starting date or running with today's date.
- Calendars can be expanded to show the appointments individually, or collapsed as a timeline.
The app is a Google Sheets add-on. Google Calendar itself can also show multiple calendars at once, but the viewing order of the calendars then keeps changing depending on the appointments, making free periods less visible.
The free version shows the appointments from the primary calendar associated with a Google account.
The upgrade version shows all your calendars and the calendars shared with you in a chosen order.
Install the add-on via Google in a spreadsheet:
The upgrade you can try 10 days for free and buy with PayPal in the PlanBoard add-on itself: menu Add-ons > PlanBoard > Upgrade...
The planboard is shown in a spreadsheet consisting of two worksheets. You can share the spreadsheet to show it to others.
This worksheet lists all the calendars your account has access to.
- Primary calendar - the calendar that comes with your account by default
- Added calendar(s) - a calendar that you create yourself and use for a certain purpose
- Shared calendar(s) - a calendar that someone shares with you
If you do not have an upgrade trial or license active, then only your primary calendar is active. With an upgrade trial or license, the other calendars, if you have them, can also be selected. You can adjust the order of the calendars by moving the complete row.
In this worksheet the calendars are shown that have visible 'yes' in the Calendar list and in the order that the calendars are in the Calendar list.
Per calendar the kind of events are shown that are selected in the corresponding column in the Calendar list. This can be events that last all day or start on a specific time or both kinds (default setting).
The start time of the planning board can be set via the sidebar. The sidebar opens with menu Add-ons > PlanBoard > Open sidebar.
The planning board must be refreshed regularly to process changes in the calendar(s). This can be done maually with menu Add-ons > PlanBoard > Refresh planbord. When the sidebar is opened, the planning board is refreshed automatically every 5 minutes.