amq10
asked on
Seprate the queuing time from the process time
Hi,
I have data for a process in such system which has is like that
Arrival time end of process time
I have calculate the inter-arrival time between arrives and time between process and arrival which represents the waiting and process time. My question is how to know the process time and waiting time for each task.
Example for ten tasks:
inter-arrival time in hours waiting process time between arrivals and end of process
0 0 2.18 (as first one) 2.18
0.73 ? ? 1.50
0.03 ? ? 9.04
0.72 ? ? 3.79
0.13 9.31
0.17 1.94
0.53 0.94
0.74 4.32
2.93 3.93
1.47 4.45
how to calculate proceed and waiting time for each task ?
I have data for a process in such system which has is like that
Arrival time end of process time
I have calculate the inter-arrival time between arrives and time between process and arrival which represents the waiting and process time. My question is how to know the process time and waiting time for each task.
Example for ten tasks:
inter-arrival time in hours waiting process time between arrivals and end of process
0 0 2.18 (as first one) 2.18
0.73 ? ? 1.50
0.03 ? ? 9.04
0.72 ? ? 3.79
0.13 9.31
0.17 1.94
0.53 0.94
0.74 4.32
2.93 3.93
1.47 4.45
how to calculate proceed and waiting time for each task ?
ASKER
Hi John,
Thanks for your comment. The deference between end of process and arrival will gives the process time and waiting time together. I need to know long the task takes in the process and in the waiting queue.
Please find the attached, which is a sample of the original data. Please note that the difference there are holidays and weekends between arrival and process have been removed in the processed times in the last two columns .
Thanks
Abdul
Thanks for your comment. The deference between end of process and arrival will gives the process time and waiting time together. I need to know long the task takes in the process and in the waiting queue.
Please find the attached, which is a sample of the original data. Please note that the difference there are holidays and weekends between arrival and process have been removed in the processed times in the last two columns .
Thanks
Abdul
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have add the solution as I found it and selected it as the best solution. Although, the expert solution it doesn't work, I gave his the point as I respect his effort with me.
If I understand what you are asking, it is easier done with the Arrival time and End of Process time.
Can you post the original data?
John