Can it be done.... Master scheduler

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.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,224,816
Messages
6,181,143
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top