I have some tables of jobs and schedules in my MIS system. I want to pull the data using Zapier and port it into my Google sheets tables PressWiseSource-01 to GoogleSheet-01 and GoogleSheet-02. These tables are now manually typed daily, then the updates are manual to clarify status of jobs.
Then, I have a GoogleSheets-02 Gantt Chart that I need to improve from daily UOM increments to an hourly gantt allowing fractions of hours as the UOM. with this schedule data integrated into that. The Gantt Chart needs some heavy mods and upgrades to fit what I want to do with it. On that GanttChart I need to improve its function and fit. Many dates will need to be formulated using the earliest start date then incrementing the time required that creates the cascade of dates. Many jobs are 10 minutes, not 1 day, etc.
I want to work by fixed milestones and fixed cost series of scoped stages.