Job description
I will order the preparation of a google sheet or exel if there is no technical possibility in google sheet.
We are a manufacturing company and we need a sheet for production planning.
We want the sheet to be able to enter a new order name/number of pieces/time to produce 1 piece is the data we will enter in the table. We want to be able to select 1 of 5 machines and then have the script mark the total production time of the order on the "calendar". That is, let's assume we want to make 1000 pieces each piece produces 6 minutes making 6000 minutes. Machine 1 will be available from August 5 from 10:00 am so this production will enter from 10 for the next 100h. We expect this to be shown in a spiffy graphic form.