Good day all,
I manage a busy cabinet manufacturing facility in Charleston, SC and we are using Office 365 Excel. In the coming days I am going to be gifted with a new capability from our cabinet design software (a CSV file) that will contain data for each of our upcoming jobs. This CSV will be imported into Excel to calculate labor times, basically.
I'm confident in my ability to use Excel to get that data.
My next step will be using the labor times from that CSV file to create a small MOUNTAIN of Google Calendar entries that are production scheduling. Currently I'm calculating these labor times by hand and making these calendar entries by hand.
Is there a way to link Excel on my PC to the Google Account I'm using so that Excel can create calendar entries for me?
I would want excel to create the calendar entry, name the event using data from the data file, and place the task on the calendar on a date that is based off of date in that data file.
For example, to help clarify. Let's consider cabinet assembly. The data file will already know the following (in cell data)
Job Task-- Assembly
Job Name-- Smith
Job Room --- Kitchen
Cabinet count-- 15 cabinets
Cabinet assembly hours-- 18 labor hours
Job Begin Date: March 1, 2020
Cabinet assembly begins 10 days after Job begin date.
Thus, Excel would create an event on Google Calendar named " Assembly Smith Kitchen 15 cabinets 18 hours" on March 10th.
This sounds like I'm asking a lot, and I know I can do SOME of this in FileMaker (I've integrated FileMaker and Asana for certain tasks) but I'm hoping to avoid spending days writing a database in Filemaker to do this. Other than the creation of Google Calendar entries, the Excel spreadsheet is by FAR the simplest way to handle this data.
Bookmarks