Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Ron P
 
Posts: n/a
Default


"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
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 08:58 PM
Creating a Date Selector in Excel VBA? Mark Excel Discussion (Misc queries) 0 November 25th 04 11:59 PM


All times are GMT +1. The time now is 02:10 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"