job scheduling

[Rick46]

I was wondering how people that are in charge of machine scheduling go about setting up a job schedule ie, job numbers, machine it goes on, date its due etc..currently we are using excel to achieve this and it gets the job done but its protected so only the scheduler can modify it and only updates when the scheduler saves it and the operator re opens it. would like to be able to add a comment at end of the job to allow the machinist to enter the current status of the job at machine as well as other info if needed but not sure if it can be done in excel. Just curious how other shops are scheduling there work loads with excel or other software.  maybe examples or does a job shop software need to be put in place here.. thanks.. 

[mkd]

well as a quick fix, you could share the excel file for multiple users.

MS project has more timeline adjustment functionality (because excell has none)

 

sounds like you want an ERP system.

some people here use Job boss.

[themachinist]

Most shops use an ERP system. Your requirements are going to vary based on the size of your company. You can accomplish a lot with Office but the cost of development will quickly outpace the cost of an entry level ERP. However, if someone there has the skillset you may be able to build something useful on top of Microsoft Access that is friendlier to multiple users.

[Guest]

Most shops use an ERP system. Your requirements are going to vary based on the size of your company. You can accomplish a lot with Office but the cost of development will quickly outpace the cost of an entry level ERP. However, if someone there has the skillset you may be able to build something useful on top of Microsoft Access that is friendlier to multiple users.

I second this. I love excel and VBA but for your application MS Access would be a step up. Toss in a little SQL and you can generate some very nice reports on top of the other functionality.