How to calculate DOA delivery

[mikebres]

Hi Folks, I am trying to find a way to calculate when a package is DOA. I
have a scan date and time in text format. In the scan data is a barcode with
a character that defines the Day of Delivery (DOD) of the week, i.e. Mon,
Tue, etc.. Except it starts on Monday with 1=Mon, 2=Tue, etc.. Processing
for these packages starts at 0700 on one day and ends at 0659 the next day.
So a processing day runs overnight.

Now if I am looking at the scan data for Wed to Thu, with Thu being the
delivery day, how would I calculate if the package is DOA? I intially
thought about checking if the DOD in the barcode is smaller than the intended
delivery day, but I realized that at the end of the week the next weeks
Monday would show as DOA.

So, any ideas?
Thanks
Mike

 

[mikebres]

I forgot to mention that the scanned barcodes ususally show about five days
worth of DOD. Two days prior and two days after the current day.

Thanks
Mike

 

[Bob I]

DOA normally means it didn't survive the trip. Dead on arrival. Perhaps
you could supply your meaning.

 

[mikebres]

HI Bob,

DOA in this instance is used to identify a delivery that is late to the
destinating facility so that it couldn't be delivered to the customer on
time. For example mail going from St Louis to Denver that is supposed to be
delivered on Wed, 3/25/09, doesn't arrive in Denver until Thu 3/26/09. That
mail is identified as DOA since it was already Dead (figurativley) when it
got to Denver. It is impossible for the folks in Denver to deliver this mail
on time since they recieved it after the intended delivery day.

Mike

 

[Bob I]

MIA(missing in action), LIT(lost in transit) are a couple of common ones
for that. ;-) As to when is it officially late? You would have to supply
the desired "delay after ETA(estimated time of arrival)" for the program
to make that call. Also if you are only using the weekday as an
identifier you aren't suppling enough info to make that determination.
I'd suggest using the date date instead.

 

[mikebres]

As to when is it officially late?

Well the barcode only has a Day of Delivery, i.e. Mon, Tue, etc. But
certain assumptions can be made. We either have a 2 or a 3 Day delivery
requirement. The expectation is that 2 Day commitment will make it to the
destination facility in 1 Day and the 3 Day commitment will take 2 Days to
get there. Then the destination facility has that next day to sort and
deliver it. So when a barcode comes across the scanner on Mon/Tue the
assumption is that it will be delivered on Tuesday. When I see a barcode
with a DOD of SAT on Monday night I know that this mail is delayed. We
should have had it on Friday night. This is easy to see if a you look at the
data yourself, but I want the computer to do the work and when I tried to
calculate this I run into a problem when the days wrap around to the next
week.

I am at the destinating facility so the scan date and time should be the day
prior to the DOD or the same day prior to 0700 of the DOD. Using the
previous example the barcode with a DOD of TUE should be seen by our scanner
somewhere between 0700 on Monday and 0659 on Tuesday.

Also if you are only using the weekday as an
identifier you aren't suppling enough info to make that determination.
I'd suggest using the date instead.

I wish it were that easy. The date is from the scan at the destination.
The barcode only has the Day of Delivery in it, not the date.

So with all of that, does anyone have a way to do this calculation? The
issue as I see it is the limit of working with the weekday. I have the scan
date/time with the assumption that the package should be delivered on the
weekday in the barcode. How would I handle the wrap around into the next
week?

Thanks
Mike