Ship Date Tracking Spreadsheet - Pagina 36 – General discussion, announcements and releases

ben.t7

(@ben-t7)

Trusted Member

Re: Ship Date Tracking Spreadsheet

Sadly looks like mine is being held up due to that commercial invoice thing as well. Hopefully it does not take long for it to get cleared up.

Postato : 11/02/2018 4:16 am

Hotrian

(@hotrian)

Trusted Member

Re: Ship Date Tracking Spreadsheet

Sadly looks like mine is being held up due to that commercial invoice thing as well. Hopefully it does not take long for it to get cleared up.

You mean "A missing commercial invoice is causing a delay."? Mine was stuck that way for about 24 hours, then it got moving along. Now it's stuck in Germany, but I suspect it will be moving along in the next 18 hours or so, as it will be Monday business hours there soon :).

Mine is heading to Washington, USA:

Edit: My package has now departed Germany, and I've updated the image below for future reference.

My package was held in Koeln, Germany for ~36 hours awaiting clearance.

Postato : 12/02/2018 1:26 am

LordGarth6

(@lordgarth6)

Eminent Member

Re: Ship Date Tracking Spreadsheet

Hey, does anyone know if their ahead or behind schedule?

Postato : 12/02/2018 1:30 am

Hotrian

(@hotrian)

Trusted Member

Re: Ship Date Tracking Spreadsheet

Hey, does anyone know if their ahead or behind schedule?

Pretty much right on schedule. When I ordered mine it said Jan 2018 for new orders, and very shortly after it changed to Feb 2018. Since then, they have continued to promise Late Jan/Early Feb for mine. Mine shipped 2/8 with a label printed the day prior on 2/7, so that's right on target for what I've been expecting the whole time. It's a little bit off for Assembled units, and units Black printed parts, but for Orange Kits it's pretty much spot on the original and estimates.

I ordered on 11/15 (IIRC). I'm expecting to get mine sometime between 2/13 and 2/16. It was originally planned for 2/13 but it seems an invoice is missing from my package so clearance is taking a bit longer than typical.

Edit: It's back on track again for 2/13 delivery :)!

Postato : 12/02/2018 2:07 am

Martin Stoufer

(@martin-stoufer)

Estimable Member

Re: Ship Date Tracking Spreadsheet

What's up with that big dip in the Fulfillment History?

I was digging back through the older orders on the spreadsheet and see that there is a good deal of orders placed that had no action them. I made a
minor enhancement to the copyFullfillment script to now only track those 'Preorders' who actually have a non-None request associated with them. Otherwise, they are in a yet-to-be-plotted 'Abandoned' data set.

Is this something worth keeping moving forward, or is the running list of all unfulfilled orders before the cutoff date still relevant?

Postato : 12/02/2018 4:33 am

Peter

(@peter-12)

Estimable Member

Re: Ship Date Tracking Spreadsheet

What's up with that big dip in the Fulfillment History?

I was digging back through the older orders on the spreadsheet and see that there is a good deal of orders placed that had no action them. I made a
minor enhancement to the copyFullfillment script to now only track those 'Preorders' who actually have a non-None request associated with them. Otherwise, they are in a yet-to-be-plotted 'Abandoned' data set.

Is this something worth keeping moving forward, or is the running list of all unfulfilled orders before the cutoff date still relevant?

Ah, good you are here as well. I just posted a bunch of comments in an unrelated comment chain in the spreadsheet, hoping to catch you.

The dip is because you added a tracked state to the script without adding it to the output map or the sheet which tracks the data. We can fix it, but it will mean that a sudden block of color appears in the graph with no apparent relation to any other block. I'd suggest we make a different script and different chart tracking "data accuracy" as % fulfilled orders as a function of date. The fulfillment history graph should probably keep tracking the data accurately without us making guesses as to why that data doesn't follow the expected norm.

Postato : 12/02/2018 10:42 am

Martin Stoufer

(@martin-stoufer)

Estimable Member

Re: Ship Date Tracking Spreadsheet

What's up with that big dip in the Fulfillment History?

I was digging back through the older orders on the spreadsheet and see that there is a good deal of orders placed that had no action them. I made a
minor enhancement to the copyFullfillment script to now only track those 'Preorders' who actually have a non-None request associated with them. Otherwise, they are in a yet-to-be-plotted 'Abandoned' data set.

Is this something worth keeping moving forward, or is the running list of all unfulfilled orders before the cutoff date still relevant?

Ah, good you are here as well. I just posted a bunch of comments in an unrelated comment chain in the spreadsheet, hoping to catch you.

The dip is because you added a tracked state to the script without adding it to the output map or the sheet which tracks the data. We can fix it, but it will mean that a sudden block of color appears in the graph with no apparent relation to any other block. I'd suggest we make a different script and different chart tracking "data accuracy" as % fulfilled orders as a function of date. The fulfillment history graph should probably keep tracking the data accurately without us making guesses as to why that data doesn't follow the expected norm.

Thanks Zaz, I left a reply to the Comment from Peter H. in the spreadsheet (is that you?) that I will back out my changes in the script so things get back to normal. I'm up for creating an ancillary plot that tracks 'None' orders older than the cutoff day that have no action on them. This will at least give us something to compare and then determine if/how to merge.

Postato : 12/02/2018 4:57 pm

Peter

(@peter-12)

Estimable Member

Re: Ship Date Tracking Spreadsheet

Thanks Zaz, I left a reply to the Comment from Peter H. in the spreadsheet (is that you?) that I will back out my changes in the script so things get back to normal. I'm up for creating an ancillary plot that tracks 'None' orders older than the cutoff day that have no action on them. This will at least give us something to compare and then determine if/how to merge.

Yes, that's me.

I'm still of the opinion that the chart should reflect the reported data, and since the reported data includes "forgotten" entries, so should the chart include "forgotten" entries. We have the exact same issue with all the other charts as well, like the chart tracking fulfillment by order week. The bars will never reach 100% fulfillment, and that is the way it is supposed to be. If we wish to "wash" the data - which, again, I don't agree with - we could either try to hunt down the people that entered the forgotten entries and ask them to update, or we could delete the entries altogether. Basically what we decide in that case is that the statistical data we have collected should be modified to fit our preconceived notion of what model the data should fit to.

But I digress.

This is what you need to add to the script to make it merge properly.

The edits you did to calculateRow create a new category, and place some number of entries into this new category, this is a good start.

There should probably be some sort of sliding window rule for this new category. Currently it just picks "all preorders" which is a bit static. In a few months, if the spreadsheet is still alive at that time, that won't be a useful filter anymore. Better to add some sort of rule like "if a row contains an order that is over 150 days old and has no special requests" or similar.

Then we must use this new category to the output of the script. That is, add statusMap["abandoned"] to the "newDataRow" array at the bottom of the copyFulfillment function.

Then we add another column to the Fulfillment history sheet, so the new category has somewhere to be written to.

Then we backfill numbers into the new column to make sure the new category doesn't show up like a step function in the graph. If we select a filter that doesn't contain any orders _today_ but will start containing orders _tomorrow_ we can just backfill the entire column with zero, otherwise we have to do some slight arithmatic to figure out somewhat correct numbers. Or we just pick numbers that make the graphs look good. Note that if we enter numbers that are not zero, we have to adjust some other column - most likely the preorder column - to keep the total number of orders correct.

Then we extend the source data for the graph to also contain the new column, and decide on colors for the new segment, and make sure it is placed horizontally where it looks good.

Done.

It sounds like a lot, but it really isn't that much work. I'd probably argue that the easiest would be to add the 150 days old filter and let the graph fix its own numbers, to avoid having to have to retroactively match historical data to some new rule.

Postato : 12/02/2018 10:17 pm

ibd

(@ibd)

Active Member

Re: Ship Date Tracking Spreadsheet

Am I reading this spreadsheet right? If I order now, I could expect the mk3 kit to be shipped in around 3 months' (90 days) time?

From your experience, is this delay time likely to go down anytime soon?

Postato : 12/02/2018 10:53 pm

Martin Stoufer

(@martin-stoufer)

Estimable Member

Re: Ship Date Tracking Spreadsheet

Thanks Zaz, I left a reply to the Comment from Peter H. in the spreadsheet (is that you?) that I will back out my changes in the script so things get back to normal. I'm up for creating an ancillary plot that tracks 'None' orders older than the cutoff day that have no action on them. This will at least give us something to compare and then determine if/how to merge.

Yes, that's me.

I'm still of the opinion that the chart should reflect the reported data, and since the reported data includes "forgotten" entries, so should the chart include "forgotten" entries. We have the exact same issue with all the other charts as well, like the chart tracking fulfillment by order week. The bars will never reach 100% fulfillment, and that is the way it is supposed to be. If we wish to "wash" the data - which, again, I don't agree with - we could either try to hunt down the people that entered the forgotten entries and ask them to update, or we could delete the entries altogether. Basically what we decide in that case is that the statistical data we have collected should be modified to fit our preconceived notion of what model the data should fit to.

But I digress.

This is what you need to add to the script to make it merge properly.

The edits you did to calculateRow create a new category, and place some number of entries into this new category, this is a good start.

There should probably be some sort of sliding window rule for this new category. Currently it just picks "all preorders" which is a bit static. In a few months, if the spreadsheet is still alive at that time, that won't be a useful filter anymore. Better to add some sort of rule like "if a row contains an order that is over 150 days old and has no special requests" or similar.

Then we must use this new category to the output of the script. That is, add statusMap["abandoned"] to the "newDataRow" array at the bottom of the copyFulfillment function.

Then we add another column to the Fulfillment history sheet, so the new category has somewhere to be written to.

Then we backfill numbers into the new column to make sure the new category doesn't show up like a step function in the graph. If we select a filter that doesn't contain any orders _today_ but will start containing orders _tomorrow_ we can just backfill the entire column with zero, otherwise we have to do some slight arithmatic to figure out somewhat correct numbers. Or we just pick numbers that make the graphs look good. Note that if we enter numbers that are not zero, we have to adjust some other column - most likely the preorder column - to keep the total number of orders correct.

Then we extend the source data for the graph to also contain the new column, and decide on colors for the new segment, and make sure it is placed horizontally where it looks good.

Done.

It sounds like a lot, but it really isn't that much work. I'd probably argue that the easiest would be to add the 150 days old filter and let the graph fix its own numbers, to avoid having to have to retroactively match historical data to some new rule.

That sounds like a plan. I'll pull a copy down of the spreadsheet this week and hack on it and see how good it looks.
Thanks for the feedback.

Postato : 12/02/2018 11:41 pm

Spekkie3D

(@spekkie3d)

Eminent Member

Re: Ship Date Tracking Spreadsheet

Am I reading this spreadsheet right? If I order now, I could expect the mk3 kit to be shipped in around 3 months' (90 days) time?

From your experience, is this delay time likely to go down anytime soon?

Well that's a good question Isaac.
If i break down what i know than it gets down to this:

The original orders took around 3 months to get delivered. (most of the orders shipping now are from the last few weeks of 2017)
I ordered mine on the first Monday of the second week of 2018 so week 2, By week 1 the delivery window for new orders stated to be March of this year. If we look at the official shipping table that you can find in your order history page then we can see that week 1 and 2 are stated for a shipment date of around march 1.
Now the most important bit of information for you, if we look at the main website of Prusa, then we see that new orders should still be shipped in March. We only don't know when in March. So i would assume the worst and suspect the end of March.
By that reckoning then if you order now, then you will not be waiting 3 months to get your printer, but about 6 weeks, of 1.5 months.

To be entirely sure though, i would recommend contacting Prusa live chat and ask them for when new orders will ship, if that is still March or of they have slipped to april yet.

Postato : 13/02/2018 1:47 am

LordGarth6

(@lordgarth6)

Eminent Member

Re: Ship Date Tracking Spreadsheet

yea i think they are starting to speed up processing orders (or just have less of them). my order is on track for 20/2/18 (ordered 12/12/17) so thats about a 2.5 month wait.

Postato : 13/02/2018 2:20 am

david.s86

(@david-s86)

Eminent Member

Re: Ship Date Tracking Spreadsheet

yea i think they are starting to speed up processing orders (or just have less of them). my order is on track for 20/2/18 (ordered 12/12/17) so thats about a 2.5 month wait.

You say this...but...mine should've been shipped yesterday, according to their status updated February 1st. No movement yet. Sadly. Here's to hoping mine gets shipped out this week, though. Sadly, it won't be here in time for me to build it this weekend, no matter what, now. :'(

Edit: Talked to support - they're a few days behind this week, but should have the 2/12 shipping out by the end of the week, apparently. 🙂

Postato : 13/02/2018 2:36 pm

PeterA

(@petera-2)

New Member

Re: Ship Date Tracking Spreadsheet

yea i think they are starting to speed up processing orders (or just have less of them). my order is on track for 20/2/18 (ordered 12/12/17) so thats about a 2.5 month wait.

You say this...but...mine should've been shipped yesterday, according to their status updated February 1st. No movement yet. Sadly. Here's to hoping mine gets shipped out this week, though. Sadly, it won't be here in time for me to build it this weekend, no matter what, now. :'(

Edit: Talked to support - they're a few days behind this week, but should have the 2/12 shipping out by the end of the week, apparently. 🙂

I ordered my kit the 22/11 and it has not been shipped. The status of my order has been "Order being packed" since last Friday (9/2) 🙄
I doubt they will be shipping the 2/12 by the end of the week.....

Postato : 13/02/2018 9:31 pm

Dewey79

(@dewey79)

Honorable Member

Re: Ship Date Tracking Spreadsheet

I haven't received a shipping notice yet and others' that ordered after me 11/20/2017 are seeing notices. On the ride into work I remember I told them not to ship my printer until it had the new MK52 bed.
This may be why mine hasn't shipped. Did anyone else tell PRUSA not to send the printer until the new bed is shipped with it?

I've heard that the new MK52 beds are delayed, but I don't know how long.

Postato : 13/02/2018 11:00 pm

Scincidae

(@scincidae)

Utenti

Re: Ship Date Tracking Spreadsheet

I haven't received a shipping notice yet and others' that ordered after me 11/20/2017 are seeing notices. On the ride into work I remember I told them not to ship my printer until it had the new MK52 bed.
This may be why mine hasn't shipped. Did anyone else tell PRUSA not to send the printer until the new bed is shipped with it?

I've heard that the new MK52 beds are delayed, but I don't know how long.

They're delayed until at least the end of February, there are quite a few people who requested that as well. I ordered January 8th and support said mine should have the new bed so I didn't think I would need to tell them to hold it for the bed but I would rather wait.

Postato : 14/02/2018 1:12 am

Spekkie3D

(@spekkie3d)

Eminent Member

Re: Ship Date Tracking Spreadsheet

And the original shipping table has been updated again. But i'm afraid the delay mentioned is resulting in a delay across the board.
Week 1 and 2 were planned for March 1st and are now stated for March 5th. So a few extra days.

I can't really remember the other parts of the old schedule to compare, but the most noticeable to me is that they are back at a shipments from Monday only. So no longer a shipment window on Monday and then an other of Thursday. I guess the suppliers can't keep up to allow the ramping up Prusa wanted.

Oh well, a few extra days to hang out on the forums it is 😆

Postato : 14/02/2018 11:46 am

rkayakr

(@rkayakr)

Trusted Member

Re: Ship Date Tracking Spreadsheet

Ordered 11/25, got tracking # 2/13, shipped 2/14 BUT UPS site says:

02/13/2018 6:40 P.M. A missing commercial invoice is causing a delay. / Your package was released by the clearing agency.
Prague, Czechia 02/13/2018 5:59 P.M. A missing commercial invoice is causing a delay.
02/13/2018 5:59 P.M. Your package is being processed at the clearance agency.
02/13/2018 5:59 P.M. Your package is being processed at the clearance agency. / Your package was released by the clearing agency.
Prague, Czechia 02/13/2018 2:17 P.M. Pickup Scan
Czechia 02/13/2018 10:47 A.M. Order Processed: Ready for UPS

Postato : 14/02/2018 1:07 pm

billw

(@billw)

Active Member

Re: Ship Date Tracking Spreadsheet

Ordered 11/25, got tracking # 2/13, shipped 2/14 BUT UPS site says:

02/13/2018 6:40 P.M. A missing commercial invoice is causing a delay. / Your package was released by the clearing agency.
Prague, Czechia 02/13/2018 5:59 P.M. A missing commercial invoice is causing a delay.
02/13/2018 5:59 P.M. Your package is being processed at the clearance agency.
02/13/2018 5:59 P.M. Your package is being processed at the clearance agency. / Your package was released by the clearing agency.
Prague, Czechia 02/13/2018 2:17 P.M. Pickup Scan
Czechia 02/13/2018 10:47 A.M. Order Processed: Ready for UPS

It took 36 hours from that notice to arrival in the states for mine. Delivery is scheduled for tomorrow. Be patient, it will get through. 🙂

Postato : 14/02/2018 3:49 pm

ben.t7

(@ben-t7)

Trusted Member

Re: Ship Date Tracking Spreadsheet

Well that's not what I wanted to wake up to this morning 🙁 was originally looking like a Friday delivery but I hope it doesn't get pushed back to Monday.

02/14/2018 4:42 A.M. A mechanical failure has caused a delay. We will update the delivery date as soon as possible. / Your package was released by the clearing agency.
Louisville, KY, United States 02/14/2018 4:40 A.M. A mechanical failure has caused a delay. We will update the delivery date as soon as possible.

Postato : 14/02/2018 4:10 pm