Search results

Try changing your proxy settings and see if it works: Internet Options > Connections > LAN Settings Check "Automatically detect Settings" Uncheck "Use automatic configuration script" Now, try going to google docs.

No, not user form. I think the tabular sheet (TIMELINE) is much better and easy to organize. Unlock all cells, let the user directly enter his/her information. Let this be controlled via strict data validation. Let the user choose only validated drop-down options under each column. Apply a...

Most of them must have been charged. The members who did not update the status probably got carefree to the extent that they care less about updating their status that in turn updates useful statistics.

Rossei, I still feel that we can utilize "Timeline" sheet directly to get user data and completely eliminate "Filter" sheet. This way you won't have to worry about transfering their data to "Timeline" sheet. It may require some additional data validation and some conditional formatting to...

Let me take the liberty to answer on behalf of Rossie. Yes, the "Filter" sheet, as the name suggests" is a mechanism that Rossei utilizes to get direct inputs from forum member for the cleaner and much controlled "Timeline" sheet. He does that to ensure that there is no duplicate or invalid data...

So no more protests outside Purolator's head office or taking them to court All is well that ends well But Purolator did lie

Purolator 9:43 CC Charged (based on $1100 drop in credit. I hadn't been using this card for anything else.) My projection sheet after all stands defeated. I am however happy to say that. The 2 percentages of interest are: 1. The acceptance rate: 10,000 / 15,000 = 65% 2. The population...

Rossei, Could you kindly unlock column "F" of your "Timeline" sheet so that members can directly update it. Thanks, TJD

Absolutely no reason to lose hopes. You are well within the cap. A lot of other applications from the 9:19 batch have been charged already.

Firstly, I hope what you said be right. Secondly, it would be very unrealistic to say that the apps received in 3 days followed a linear trend, such as 8000+4000+2000 In my opinion, and also from the time of delivery data, it is a heavy quadratic trend line if not completely exponential and it...

Look at the "Projection" sheet. Cell C21. I created this sheet to track the progress and performance of what in theory is called a FCFS system. The assumption is that this forum represents a %age of the total population. This is a very reasonable assumption It was a complete failure leading to...

I don't think Purolator was able to deliver before noon on Jan 4. They updated their status at around 2:30 PM with 9:43 AM as their time tag. About 2200 (earlier rumored to be 700+) applications in this category. Good luck to all

very high chance. The 9:43 purolator (that seems to be a wrong time tag) is where we will see a cut-off. Good luck !!

very nicely said. wish you all the best.

Analysis based on Projection sheet, which is based on Timeline sheet's data Jan 4 (AM): 13000 Jan 4 (PM): 400 Jan 5 (AM): 1200 Jan 5 (PM): 80 Jan 6 (AM): 80 Jan 6 (PM): 160 Total 14,000+ And I hope Rossei is right

:) Rossie, you deserve a reward from happy road. We will endorse you. You already have fantastic testimonials. :)

Thanks ! It is very important that the number of forum members = 164 be considered as a representative sample of the total population, otherwise, what is the point of having a google spreadsheet tracking everything. The early (the happy road customers) applicants represent a greater percentage...

10 seconds service time is assumed to be average and normalized. This is surely what one can achieve in a 8 hr day, provided they have a good material handling and racking (if not conveyors) inside their office. Perhaps my calculations were a mere coincidence. Good luck!

I missed the 5000 cap last year, but based on my limited statistical analysis and intuition backed by industrial engineering >operations research > queing theory (no bragging), I am very reasonable with my predictions. For example, when I said, if it takes one person (queue server) an avg of 10...

I have updated the "Projection" sheet in google docs. IF 161 applicants represent 14,000+ applications, 161/15000 = 1.073% AND if a total of 10,000 applications will be retained, AND a strict FCFS is followed, I am afraid to say that not all the purolator's 9:43 am deliveries will be lucky...