I work for an agency that has dozens of projects and CAD managers with thousands of drawings and print dates, etc. We are using SharePoint to control the documents, Autodesk included, and we synchronize with a network hard drive(s) and an FTP site for downloads. I am working converting to OneDrive for at least the FTP side, but I am not experienced in how to use one drive to replace our collaboration system, although I want to. Baby steps for now.
My question is this; We have Office 365 accounts and use Outlook calendars and SharePoint Calendars, BUT our schedulers provide us with quarterly .xls spreadsheets with milestones listed. If I were to create a collaboration calendar in SharePoint, I will have to transfer dozens these dates to my site quarterly, and I've been told even then the dates are only vaguely accurate. Does anyone have a good system that works with Office products, that I can tie information together without having to manually touch the data (the calendar dates)? Is this task a "Cat Herding" task?