Tips for 2016 (Future) PGP Applicants

[dchoudh]

I made another column Total Rejected in the Statistics page of the SS so that we know how many applications are still pending (for various reasons you already mentioned with which I agree) from Jan 4 and onward.

Date-Time Total Received Total Accepted Total Rejected
Day1 (08:01-10:00) 299 251 5
Day1 (10:01-12:00) 36 24 0
Day1 (12:01-16:00) 14 11 0

So, it's actually 63 - 5 = 58 from Jan 4 which is still a lot considering 20 getting charged from Jan 5.

Rossei...question for you...might be dumb and probably somewhere you have already mentioned...

What is the purpose of the worksheet "Filter" though almost the same data/information is also present in "Timeline" worksheet? Just curious...

 

[Dhillon88]

What does "DD" mean?

Demand Draft

 

[tjd]

Rossei...question for you...might be dumb and probably somewhere you have already mentioned...

What is the purpose of the worksheet "Filter" though almost the same data/information is also present in "Timeline" worksheet? Just curious...

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 that may cause other sheets to malfunction.
Apparently, this is the best way to maintain this online workbook.
I hope I answered the question.

 

[tjd]

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 that may cause other sheets to malfunction.
Apparently, this is the best way to maintain this online workbook.
I hope I answered the question.

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 highlight duplicate or illegal entries. What do you say... ?

 

[dchoudh]

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 that may cause other sheets to malfunction.
Apparently, this is the best way to maintain this online workbook.
I hope I answered the question.

You might be right...but I thought and was aware that the "New Entry" sheet is for the forum members to provide their input and from there...Rossei copies it to the "Timeline" and other sheets...I never updated the "Filter" sheet...but my entries are there in all the sheets including "Filter"...I always update the "New Entry" sheet...whenever there is anything new for me to update...does that make sense?

 

[digandhi]

Hello,

Any AOR news/udate form whose CC got Charged between 1 to 10 March - mine one is on 7 March? ;D ;D ;D

 

[cdnrics]

Hi Rosie !!
Mine was fedex 4th Jan, CC charged 10th March, I don't know how to update on SS.
Thanks
Cdnrics

 

[rg1234]

Hello Admin,

Could you please add mine info in the spreadsheet

Application for Mom
Sent via courier Fedex
Received on Jan 5th at 10:01 am by Sanpaul
CC Charged on Mar 30

Thanks in advance

 

[Rossei]

Hi Rosie !!
Mine was fedex 4th Jan, CC charged 10th March, I don't know how to update on SS.
Thanks
Cdnrics

Done.

For future reference, please use NEW ENTRY sheet of the SS.

 

[Rossei]

Hello Admin,

Could you please add mine info in the spreadsheet

Application for Mom
Sent via courier Fedex
Received on Jan 5th at 10:01 am by Sanpaul
CC Charged on Mar 30

Thanks in advance

For now, I've added you to the TIMELINE sheet under rg1234 username. But I would highly insist you on updating your info yourself by using NEW ENTRY sheet of the SS. All instructions are given on the first tab. Thanks.

 

[dchoudh]

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 that may cause other sheets to malfunction.
Apparently, this is the best way to maintain this online workbook.
I hope I answered the question.

I think I got it now...after reading the Introduction sheet...

Its says what all the work sheets including "Filter" sheet is all about...

New Entry: (read /write): This is for users to enter new data or update existing data
TIMELINE: (read only): Contains all 2016 PGP applications' status (all stages)
Filter: (partially locked):This is a plain view of TIMELINE sheet for users to apply different filters. Choose 'PGP' filter from Filter menu. Then you can filter the list by any heading.

 

[Rossei]

I think I got it now...after reading the Introduction sheet...

Its says what all the work sheets including "Filter" sheet is all about...

New Entry: (read /write): This is for users to enter new data or update existing data
TIMELINE: (read only): Contains all 2016 PGP applications' status (all stages)
Filter: (partially locked):This is a plain view of TIMELINE sheet for users to apply different filters. Choose 'PGP' filter from Filter menu. Then you can filter the list by any heading.

Right. For example, if you want to see the progress of applications with same received time-stamp, you can do so in FILTER sheet. I've created PGP filter view which will enable all headings with drop-down options to choose from. Alternatively, you can create your own customized filter view (which you will often view) and save it for future use.

I have some other use of it as Tjd said. I could have done same thing on TIMELINE sheet. But I wanted full restrictions for it, hence made the FILTER sheet.

 

[Rossei]

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 highlight duplicate or illegal entries. What do you say... ?

Are you for USER FORM? I didn't want to create one for such big entry (too many fields). It's perfect for small entries.

Alternatively, I could still use a separate sheet (i.e. NEW ENTRY) to populate TIMELINE directly/automatically. But that conflicts with my customized sorting. I've done this before, didn't go very well.

Let me know if you have other plans. I can eliminate 'FILTER' anytime I want.

 

[myYahoo]

ECAS Activated, card charged on 12th Mar

 

[canam3]

For me too, ECAS Activated. Card was charged on 11th Mar