Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating Machine shop part schedule using Excel
Hello, my name is Alex Barker and I am working for a company in Ontaro Canada called Knoch Manufacturing. I am experienced with Excel, but not quite capable enough to complete the project given. We are a machine shop that has 14 different CNC machines. We keep track of Queued, Pending , and Distant jobs for each machine Queued- ready to run Pending- one more operation then ready to run Distant- 2 or more operations becure ready to run This information also comes along with a due date and hours remaining on operation What we are looking for is a program that schedules this information into a calander in priority of due date. We have 3 shifts a day and this information changes daily. Some parts have multiple operations and then switch machines and a part can be running on the same machine for a shift to a week at a time. Is this at all possiable for your company to handle? Ive spent the past week staring at a computer screen and at the point right now of getting outside help. I have a data base of information that I have transfered into excel and is capable of being updated almost instantly. ANY IDEAS ARE WELCOME Regards, Alex Barker -- Amear ------------------------------------------------------------------------ Amear's Profile: http://www.excelforum.com/member.php...o&userid=27124 View this thread: http://www.excelforum.com/showthread...hreadid=466360 |
#2
|
|||
|
|||
"Amear" wrote in message ... Hello, my name is Alex Barker and I am working for a company in Ontaro Canada called Knoch Manufacturing. I am experienced with Excel, but not quite capable enough to complete the project given. We are a machine shop that has 14 different CNC machines. We keep track of Queued, Pending , and Distant jobs for each machine Queued- ready to run Pending- one more operation then ready to run Distant- 2 or more operations becure ready to run This information also comes along with a due date and hours remaining on operation What we are looking for is a program that schedules this information into a calander in priority of due date. We have 3 shifts a day and this information changes daily. Some parts have multiple operations and then switch machines and a part can be running on the same machine for a shift to a week at a time. Is this at all possiable for your company to handle? Ive spent the past week staring at a computer screen and at the point right now of getting outside help. I have a data base of information that I have transfered into excel and is capable of being updated almost instantly. ANY IDEAS ARE WELCOME Regards, Alex Barker You might want to consider using software like Project (Microsoft) for this kind of thing. -- Ron P Just remember....if the world didn't suck, we'd all fall off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Corrupted Excel file - but on only one machine? | Excel Discussion (Misc queries) | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |