-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jun 08, 2005 at 10:02:34AM +1000, Grant Parnell - slug wrote:
Essentially we agree on only looking at times of the day where packing
activity is occurring. The jury is out on whether you can assume the
orders were processed sequentially
Looking at the average over a day is probably the most meaningful
figure you can get.
Almost true. By itself, it gets you a ballpark figure, but you really want the
standard deviation to tell you how big the park is, and (ideally) the type of
distribution to tell you what kind of ballpark
My god... there's some good ideas there. For now I opted for processing
outside of SQL by basically breaking the day into 1 minute time slots and
looking at how many orders were currently being processed in each time
slot. Next I iterated again and counted up the minutes for each order such
On Wed, 2005-06-01 at 19:59 +1000, Grant Parnell - EverythingLinux
wrote:
I'm trying to do some metrics on how long it takes to process an order in
our system based on time between printing the picking slip and bagging the
goods for dispatch. The aim is to determin the maximum performance if
I'm trying to do some metrics on how long it takes to process an order in
our system based on time between printing the picking slip and bagging the
goods for dispatch. The aim is to determin the maximum performance if we
were to have one guy do nothing but pick pack orders.
At first glance
Grant
I'm not sure that what you have is really a SQL syntax problem.
It looks like an Operations research queuing problem. Googling on
this should help - or confuse.
hope this is relevant
Steven O'Reilly
On 6/1/05, Grant Parnell - EverythingLinux [EMAIL PROTECTED] wrote:
I'm trying to
On Thu, 2005-06-02 at 09:46 +1000, Steven O'Reilly wrote:
Grant
I'm not sure that what you have is really a SQL syntax problem.
It looks like an Operations research queuing problem. Googling on
this should help - or confuse.
Or talk to Andrew Cowie whom I believe has some expertise in
Grant Parnell - EverythingLinux wrote:
I'm trying to do some metrics on how long it takes to process an order in
our system based on time between printing the picking slip and bagging the
goods for dispatch. The aim is to determin the maximum performance if we
were to have one guy do nothing