ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating Machine shop part schedule using Excel (https://www.excelbanter.com/excel-discussion-misc-queries/44688-creating-machine-shop-part-schedule-using-excel.html)

Amear

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


Ron P


"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.



All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com