Netflix Traffic update for June 2006

Not a bad month. Nine DVDs, one was damaged. Average return time was 7.27 hours; longest time was 10.68 hours, quickest was 5.28.

Netflix Analysis

I also have a new chart, the ten dvd moving average. This chart shows the ten dvd moving average of the amount of time it takes to send the next disc to me. By averaging out the time over the most recent ten discs, that would minimize the amount of damage a single delayed shipment would have on the chart. This shows that early 2005, late 2005, and early 2006 I was either being throttled, or Netflix was having problems in their shipping centers. Since February 2006, things are looking ok.

Netflix Analysis Ten Dvd Average

Someone asked me how I calculate these numbers. I have a spreadsheet that I enter in the times from the emails I receive. Netflix sends out an email when they receive a DVD, and when they mail one. Yes, Netflix could game the system, but hopefully they won’t do that.

There are three columns of data I enter:

Column 1: Time Netflix Receives a DVD
Entered in military time. This is almost always before noon. There have only been 15 discs received after 10am, of the 326 I’ve sent back.
Column 2: Time Netflix Mails a DVD
Entered in military time.
Column 3: Extra Day
zero or one. If the next DVD is mailed the same day one was received, enter a zero (or simply leave blank). If the next disc is mailed the next day, enter a one. I have only once had a disc get returned on Friday, and have the next disc mailed on Monday, after the weekend. I counted that as a one, but I could count it as a two, since there was a delay of two mailing days. Twice I have had the disc mailed the next day, but earlier than the time it was received. So for those I enter a zero, but the time ends up as around 20 hours.

There are six columns that the spreadsheet calculates:

Column 4: Subtract Column 1 from Column 2
This will tell you how many hours and minutes have elapsed. I format this as a time, not as a number.
Column 5: Hours
I extract the hours from Column 4. The Excel formula is =HOUR(Column4)
Column 6: Minutes
I extract the minutes from Column 4. The Excel formula is =MINUTE(Column4)
Column 7: Total Hours
Add in the extra hours for any shipments that were done the next day. The Excel formula is =Column5 + (24 * Column3)
Column 8: Decimal portion of an hour
What fraction of an hour was the minutes? 30 minutes = 50%. The Excel formula is =(Column6 / 60). I format this to two decimal places.
Column 9: Total time
How long was between Netflix receiving a disc, and mailing the next? Simply add Column 7 and 8.

At the end of the month, I simply use these three formulas to get the data that I chart.

Column 10: Average time
=AVERAGE(Column9 range for the month)
Column 11: Maximum time
=MAX(Column9 range for the month)
Column 12: Minimum time
=MIN(Column9 range for the month)

Does all that makes sense? Just ask if I’ve muddled the waters more than cleared things up.

3 Comments

  1. I have noticed that NetFlix Receiving performance (time you hand over to post office to the time you get the email stating DVD has been received) varies based on the office you send it to. Here’s what I think so far of sneding DVDs from CT:

    Hartford, CT = 3 days
    Wochester, MA = 1 day
    Sometown, NH = 1 day

    Tip: the closest office may not be the fastest, so when you get an envelope from another office, try them out and pay attention to which is the fastest.

  2. I’m having the same problem. Returns to Hartford take two days. Worcester, White R Junction, Tucson, & Phoenix are just a day. Do you have any idea what is happening in Hartford?

    When I use envelopes w non-Hartford addresses they take two days and may be going to Hartford, the nearest Netflix. When I mail from MA, VT, AZ even tho the envelope says Hartford it seems to go to the nearest Netflix.

  3. I have gotten one day service by using an envelop from another Netflix PO (often Worcester, Mass). I put labels over the back of the envelop which is red. I cover the note that says “nearest Netflix Shipping Facility”. And I cover the red Netflix “return address”. This seems to route the envelop to the barcode (for Worcester) which is on the bottom of the envelop. It gets to Worcester in ONE day.

    My guess is that the Netflix Hartford receiving facility does not exist. Mail to their PO Box is forwarded to another facility (prob Worcester) adding a day to the time it takes them to receive the DVDs.

Comments are closed.