AutoTeamCal

Your automated team calendar! Have you ever been annoyed by having to copy your absence data into several spreadsheets? Your departmental absence tracker, the project absence tracker, ...? And all this extra effort, even though you manage the information in your Google Calendar™ perfectly...! AutoTeamCal is the solution you are looking for! Just maintain your Google Calendar™ as usual, add your name to the table and the add-on will take care of all the updates. No more copy/paste! And it works with as many shared spreadsheets as you can imagine, and with anyone else whose calendar you can see. Sometimes “out-of-office” events are already good to know, but you need more: this is where Google Calendar™'s “work locations” come into play. These are also taken into account and automatically transferred to the spreadsheet. You can go even further and create your own event categories using keywords. Planning your vacation for next year and wondering how many vacation days are left? No problem, use custom functions to count how many times you'll have off, or calculate whatever you want using Google Sheets™ standard formulas. Last but not least, you can customize the style of your automated team calendar to suit your needs.