panasonic2019
New Member
- Joined
- Sep 2, 2019
- Messages
- 1
Slightly complex and due to restraints i only have Excel to play with. I Want something like this:
Tab 1: Data of jobs to be done
Tab 2: All staff with how many minutes they work per day
Tab 3: All product families we build and how long a batch will take to build in minutes then how many days that will spread across. For example one job will take two days but your only be working on it for an hour, cure times are a day. so meanwhile you could be working on other jobs.
Tab 4: The above information show in a graph
Where would i best be looking to find information on how to do this? Any YouTube links or other forum links? I'm no excel genius but can learn quickly and know the ins and outs. If you fancy showing off skills feel free to help- if you can, i'm guessing it will take a genius
Thanks! Have a good day people.
Tab 1: Data of jobs to be done
Tab 2: All staff with how many minutes they work per day
Tab 3: All product families we build and how long a batch will take to build in minutes then how many days that will spread across. For example one job will take two days but your only be working on it for an hour, cure times are a day. so meanwhile you could be working on other jobs.
Tab 4: The above information show in a graph
Where would i best be looking to find information on how to do this? Any YouTube links or other forum links? I'm no excel genius but can learn quickly and know the ins and outs. If you fancy showing off skills feel free to help- if you can, i'm guessing it will take a genius
Thanks! Have a good day people.