+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445

JANUARY 2013 Applicants - JOIN HERE!

Barbara Baraka

Star Member
Jan 4, 2013
121
2
Egypt
Category........
Visa Office......
Cairo
Job Offer........
Pre-Assessed..
App. Filed.......
01/22/2013
AOR Received.
02/19/2013
File Transfer...
03/15/2013
Med's Request
extend for 6 months
Med's Done....
05/13/2012
Interview........
05/19/2013
Passport Req..
05/19/2013
VISA ISSUED...
5/20/2013 & received on 5/23/2013
LANDED..........
ISA by July 18th, 2013

GulzarND

Hero Member
Jan 16, 2013
254
17
Category........
Visa Office......
NEW DELHI
Job Offer........
Pre-Assessed..
App. Filed.......
10 JAN, 2013
AOR Received.
25 JAN, 2013
File Transfer...
25 JAN, 2013
Med's Done....
04 JAN, 2013
Interview........
WAIVED
Passport Req..
11 MAR, 2013
LANDED..........
VERY SOON.
amikety said:
Okay, you're in. I'm new at using the spreadsheet and never had to insert a line before...... congrats it didn't take me all day and I didn't have to ask for help! Hehehe :D
Thanks Dear !!!

But please correct the spelling of Visa office - it is NEW DELHI !!!

I will be obliged.
 

amikety

VIP Member
Dec 4, 2011
4,905
143
Calgary
Category........
Visa Office......
CPP-O
Job Offer........
Pre-Assessed..
App. Filed.......
15-01-2013
AOR Received.
2-2-2013
Med's Done....
12-10-2012
Passport Req..
9-07-2013
VISA ISSUED...
7-08-2013
LANDED..........
7-08-2013
GulzarND said:
Thanks Dear !!!

But please correct the spelling of Visa office - it is NEW DELHI !!!

I will be obliged.
Sorry! I can blame my cat right? She's sitting on my laptop while I'm trying to type.... ;D

Nah, I'm an airhead........... hahaha sorry sorry sorry!
 

GulzarND

Hero Member
Jan 16, 2013
254
17
Category........
Visa Office......
NEW DELHI
Job Offer........
Pre-Assessed..
App. Filed.......
10 JAN, 2013
AOR Received.
25 JAN, 2013
File Transfer...
25 JAN, 2013
Med's Done....
04 JAN, 2013
Interview........
WAIVED
Passport Req..
11 MAR, 2013
LANDED..........
VERY SOON.
amikety said:
Sorry! I can blame my cat right? She's sitting on my laptop while I'm trying to type.... ;D

Nah, I'm an airhead........... hahaha sorry sorry sorry!
No need of Sorry. It is okay.
Thanks again.
 

GulzarND

Hero Member
Jan 16, 2013
254
17
Category........
Visa Office......
NEW DELHI
Job Offer........
Pre-Assessed..
App. Filed.......
10 JAN, 2013
AOR Received.
25 JAN, 2013
File Transfer...
25 JAN, 2013
Med's Done....
04 JAN, 2013
Interview........
WAIVED
Passport Req..
11 MAR, 2013
LANDED..........
VERY SOON.
amikety said:
Sorry! I can blame my cat right? She's sitting on my laptop while I'm trying to type.... ;D

Nah, I'm an airhead........... hahaha sorry sorry sorry!
Because you are doing a great social work. It was human error. That's it.
 

fandv

Hero Member
Aug 8, 2011
778
11
Category........
Visa Office......
Singapore
Job Offer........
Pre-Assessed..
App. Filed.......
22 Jan 2013
AOR Received.
CPC-M: None. Singapore: 25 Apr 2013
File Transfer...
17 Apr 2013
Med's Request
2nd request: 5 Feb 2014
Med's Done....
1st: 12 Dec 2012. 2nd: 11 Feb 2014
Interview........
Waived
Passport Req..
14 Feb 2014 and also e-CAS changed to "In Process" on that day. Passport got to Singapore: 12 Mar '14
VISA ISSUED...
Decision Made on eCAS: 12 April 2014. Visa n COPR issued 8 April 2014, received 16 May 2014.
LANDED..........
20 May 2014. PR card arrived on 29 July 2014.
amikety said:
Okay you're added :D Nice date for Medical 12/12/12 hehe!
Nice date indeed eh...!! ;)


Just a little tip to eliminate the unsightly "41,296" and similar numbers:

As an example let's take cell F4, which is Kiri's # of days since app received.

Currently the formula for F4 is:
=TODAY()-E4

So you can try the following formula instead for F4:
=IF(E4="", "", TODAY()-E4)

Basically, it's an if statement which checks whether E4 is empty as follows:

If E4 is empty: the formula will return a blank on F4 (instead of a weird number such as "41,296")

If there's a date on E4: the formula calculates the number of days since app received.


Then you'll just need to copy the formula to the whole column F.


The same principal also works for columns H and J :)
 

amikety

VIP Member
Dec 4, 2011
4,905
143
Calgary
Category........
Visa Office......
CPP-O
Job Offer........
Pre-Assessed..
App. Filed.......
15-01-2013
AOR Received.
2-2-2013
Med's Done....
12-10-2012
Passport Req..
9-07-2013
VISA ISSUED...
7-08-2013
LANDED..........
7-08-2013
I really know nothing about the spreadsheet - I didn't even make it :p

I have no idea how to apply your formula - I looked, but can't find where it goes.

It's a small miracle I haven't deleted the whole thing yet.
 

Sweden

VIP Member
Mar 31, 2012
4,186
179
Category........
Visa Office......
London
Job Offer........
Pre-Assessed..
App. Filed.......
12/04/2012
File Transfer...
13/07/2012
Med's Done....
02/02/2012
Interview........
Waived
Passport Req..
Exempt
VISA ISSUED...
05/11/12, received in Canada 19/11/12
LANDED..........
24/11/12, PR card received 30/01/12
fandv said:
Nice date indeed eh...!! ;)
Just a little tip to eliminate the unsightly "41,296" and similar numbers:
As an example let's take cell F4, which is Kiri's # of days since app received.
Currently the formula for F4 is:
=TODAY()-E4
So you can try the following formula instead for F4:
=IF(E4="", "", TODAY()-E4)
Basically, it's an if statement which checks whether E4 is empty as follows:
If E4 is empty: the formula will return a blank on F4 (instead of a weird number such as "41,296")
If there's a date on E4: the formula calculates the number of days since app received.
Then you'll just need to copy the formula to the whole column F.
The same principal also works for columns H and J :)
thanks - Somehow I tried that before but must have gotten something wrong because could not make it work, but now I changed it in the spreadsheet, and it should be working - and it only reads blank and not weird number anymore...

Amikety - nothing changed for you, I modified the spreadsheet's formula but you can keep on filling the dates etc. also added the formula for GulzarND so it calculates automatically - good job at updating it!
thanks,
Sweden
 

amikety

VIP Member
Dec 4, 2011
4,905
143
Calgary
Category........
Visa Office......
CPP-O
Job Offer........
Pre-Assessed..
App. Filed.......
15-01-2013
AOR Received.
2-2-2013
Med's Done....
12-10-2012
Passport Req..
9-07-2013
VISA ISSUED...
7-08-2013
LANDED..........
7-08-2013
Sweden said:
thanks - Somehow I tried that before but must have gotten something wrong because could not make it work, but now I changed it in the spreadsheet, and it should be working - and it only reads blank and not weird number anymore...

Amikety - nothing changed for you, I modified the spreadsheet's formula but you can keep on filling the dates etc. also added the formula for GulzarND so it calculates automatically - good job at updating it!
thanks,
Sweden
Awesome! Thanks :D
 

Kiri

Hero Member
Jan 31, 2012
453
13
124
Hamilton, Ontario
Category........
Visa Office......
Ottawa
Job Offer........
Pre-Assessed..
App. Filed.......
18-05-2012 App. Return....: 30-8-2012 App. Refiled....: 02-01-2013
Doc's Request.
24-01-2013
AOR Received.
23-01-2013 Mississauga 10-05-2013 Ottawa
File Transfer...
19-02-2013
Med's Request
23-07-2013 (New XRay)
Med's Done....
11-05-2012
Interview........
Waived
Passport Req..
Decision Made 03-09-2013 without PPR
VISA ISSUED...
27-09-2013
LANDED..........
04-12-2013
Holy crap!

Yayyy!! We received AOR (Acknowledgement of Receipt) today!! Surprising since they say they are still working on November cases. *does a dance*

So AOR for me on spreadsheet :)
 

Sweden

VIP Member
Mar 31, 2012
4,186
179
Category........
Visa Office......
London
Job Offer........
Pre-Assessed..
App. Filed.......
12/04/2012
File Transfer...
13/07/2012
Med's Done....
02/02/2012
Interview........
Waived
Passport Req..
Exempt
VISA ISSUED...
05/11/12, received in Canada 19/11/12
LANDED..........
24/11/12, PR card received 30/01/12
Kiri said:
Holy crap!

Yayyy!! We received AOR (Acknowledgement of Receipt) today!! Surprising since they say they are still working on November cases. *does a dance*

So AOR for me on spreadsheet :)
Congrats!! that's great to hear... and congrats on being the first one to see movements for January batch!
Sweden
 

Kiri

Hero Member
Jan 31, 2012
453
13
124
Hamilton, Ontario
Category........
Visa Office......
Ottawa
Job Offer........
Pre-Assessed..
App. Filed.......
18-05-2012 App. Return....: 30-8-2012 App. Refiled....: 02-01-2013
Doc's Request.
24-01-2013
AOR Received.
23-01-2013 Mississauga 10-05-2013 Ottawa
File Transfer...
19-02-2013
Med's Request
23-07-2013 (New XRay)
Med's Done....
11-05-2012
Interview........
Waived
Passport Req..
Decision Made 03-09-2013 without PPR
VISA ISSUED...
27-09-2013
LANDED..........
04-12-2013
Yes I'm super happy. Especially after checking out the CPP-Ottawa sheet and seeing that 19 days for AOR is rather rare. I'm seeing 25+ days (with average of 40something/50something). Hopefully this is a good sign for us!
 

fandv

Hero Member
Aug 8, 2011
778
11
Category........
Visa Office......
Singapore
Job Offer........
Pre-Assessed..
App. Filed.......
22 Jan 2013
AOR Received.
CPC-M: None. Singapore: 25 Apr 2013
File Transfer...
17 Apr 2013
Med's Request
2nd request: 5 Feb 2014
Med's Done....
1st: 12 Dec 2012. 2nd: 11 Feb 2014
Interview........
Waived
Passport Req..
14 Feb 2014 and also e-CAS changed to "In Process" on that day. Passport got to Singapore: 12 Mar '14
VISA ISSUED...
Decision Made on eCAS: 12 April 2014. Visa n COPR issued 8 April 2014, received 16 May 2014.
LANDED..........
20 May 2014. PR card arrived on 29 July 2014.
Kiri said:
Holy crap!

Yayyy!! We received AOR (Acknowledgement of Receipt) today!! Surprising since they say they are still working on November cases. *does a dance*

So AOR for me on spreadsheet :)
Congrats Kiri!

Was the AOR sent through (snail) mail or e-mail? :)
 

Kiri

Hero Member
Jan 31, 2012
453
13
124
Hamilton, Ontario
Category........
Visa Office......
Ottawa
Job Offer........
Pre-Assessed..
App. Filed.......
18-05-2012 App. Return....: 30-8-2012 App. Refiled....: 02-01-2013
Doc's Request.
24-01-2013
AOR Received.
23-01-2013 Mississauga 10-05-2013 Ottawa
File Transfer...
19-02-2013
Med's Request
23-07-2013 (New XRay)
Med's Done....
11-05-2012
Interview........
Waived
Passport Req..
Decision Made 03-09-2013 without PPR
VISA ISSUED...
27-09-2013
LANDED..........
04-12-2013
fandv said:
Congrats Kiri!

Was the AOR sent through (snail) mail or e-mail? :)
Email. My hubs forwarded it to me. :)

For those who are not sure what it might look like:

http://i47.tinypic.com/15wxnko.jpg


And after looking at the date.. does that mean the AOR is really the 4th.. o_O; Sweden, any idea why it says the date that it physically arrived?
 

Sweden

VIP Member
Mar 31, 2012
4,186
179
Category........
Visa Office......
London
Job Offer........
Pre-Assessed..
App. Filed.......
12/04/2012
File Transfer...
13/07/2012
Med's Done....
02/02/2012
Interview........
Waived
Passport Req..
Exempt
VISA ISSUED...
05/11/12, received in Canada 19/11/12
LANDED..........
24/11/12, PR card received 30/01/12
Kiri said:
Email. My hubs forwarded it to me. :)

For those who are not sure what it might look like:

http://i47.tinypic.com/15wxnko.jpg


And after looking at the date.. does that mean the AOR is really the 4th.. o_O; Sweden, any idea why it says the date that it physically arrived?
AOR is always by email, and approval can be either email or snail mail.

The date - 4th of January - is the date that your application was received in Mississauga, but they send you an acknowledgement of receipt today - they just confirm that you got your "place in the queue" system from the 4th of January... which is the important part because as long as it doesn't pass the date on the CIC website (the updated part every wednesday) you can not call them to ask about it. However, in your case it probably won't be necessary because most likely you'll get the approval before they get to January on their official website.
Sweden