LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Amear
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a week by week skill training schedule in excel? davidwatts Excel Discussion (Misc queries) 0 June 16th 05 11:32 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Corrupted Excel file - but on only one machine? k Excel Discussion (Misc queries) 2 May 31st 05 01:12 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
Creating a Date Selector in Excel VBA? Mark Excel Discussion (Misc queries) 0 November 25th 04 10:59 PM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"