Your autoamted team calendar!
Have you ever been annoyed by copy-pasting your absenteeism information to multiple spreadsheets? Your deparments absenteeism-tracker, the projects absenteeism-tracker, ...? And all this extra effort even though your maintain the information perfectly fine in your Google Calendar™?!
AutoTeamCal is the solution you are looking for! Just maintain your Google Calendar™ as usual, insert your name in the spreadsheet and the AddOn will take care of all the update. No more copy/paste! And this works with as many shared spreadsheets you can think of and with all other persons whoms calendars you can see.
Sometimes, "Out-of-Office" events are already nice to know, but you need more: that's where Google's "Working-Locations" enter the game. Those are considered as well and automatically trasfered to the spreadsheet.
You can go even further and create your own event categories by using key-words.
Planing vacation for the next year and wondering how much vacation days are left? No problem, use custom functions to count how often you will be off or calculate whatever your want using standard Google Sheets™ formulas.
Last but not least, adjust the style of your automated team calendar to fully fit your need.