Log In
Register
Home
Active Member
July 9, 2021
Offline
To anyone who can help!!??
Very new to excel but I know its magic (with the right person creating it).
So at my place of work, the first thing I do in the morning is print out all the jobs for each machine we have. Each machine may have 20+ jobs on (11machines in total). I then manually time up each job on the machine to be able to give transport a time when we expect the job to be ready. Its a 24/7 site with each shift starting a 6am, not starting the machine up till 6.30am and finishing 5.30pm to clean up. EXAMPLE: 16000 pieces @ 8000ph average run speed, would take 2 hours, plus 10mins for this particular machine (each machine has different run speeds and set up time) would mean they would finish 8.40am.
I can export my plan into an Excel spreadsheet.
Ideally I would like to drop this into a spreadsheet and it be able to calculate and say when each job will be off the machine. Job A: 8.20 Job B: 11.30 and so on.
Any help 
VIP
Trusted Members
December 7, 2016
Offline
Hello Benn,
Welcome to this forum. It is not a small thing you ask help with, but let’s give it a try.
I suggest you build a lookup table first, in which you have all needed information of your 11 machines. Based on the information in this table you can make lookups and calculations. Do make this and all other lookup tables in a tabular format, it makes things a lot easier. And do make sure you have a unique identifier for each machine/row.
Then you would need another lookup table, this time for all the jobs for each machine. Also here you need a unique ID for each row.
With these tables in place you have a good starting point to begin to build your report view.
And I can suggest you to look into taking a course or two. I have taken a few courses here at MOTH and they have helped me a lot.
Br,
Anders
Active Member
July 9, 2021
Offline
Thankyou!
So now I'm stuck again ! How would I automatically add lunch breaks into this schedule?
Its fairly simple how I've created it.
Start time at 0600.
Feeds/average speed = minutes. Then add these minutes onto the time and so forth.
How i do create a formula where I will not allow the feeds to continue for 15mins or 30mins every 2 hours?
VIP
Trusted Members
December 7, 2016
Offline
Can you share your file?
Active Member
July 9, 2021
Offline
Below is the file
Active Member
July 9, 2021
Offline
If the file doesn't work here's a screenshot 
VIP
Trusted Members
December 7, 2016
Offline
Hello Benn,
Do try to upload your file again, do remove the %20 in the file name first.
Br,
Anders
Active Member
July 9, 2021
Offline
Fingers crossed it works this time
VIP
Trusted Members
December 7, 2016
Offline
Hello Benn,
Your file was uploaded. I am soon leaving home for a short vacation trip, but it means I will be offline till Friday. Let’s see if someone else can try to help you out in the meantime.
Br,
Anders
VIP
Trusted Members
December 7, 2016
Offline
Hello Benn,
In attached file I have created a minor example of the approach I suggested earlier. I don't know if this approach suits you or not, but it might perhaps give you some guidance on the way to your own solution.
Regarding the 24/7 operations I made some assumptions that you have two 12 hours shifts with start/end at 6 am and 6 pm and also that breaks are taking every 2 hours with 30 minutes lunch break and 15 minutes coffee breaks. I also assume that when it's time for the break the machines are stopped, thus adding the break times to the jobs end time. Just so you know how I have based my break time calculations.
I hope this gives you some help.
Br,
Anders
1 Guest(s)
