+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445
Here is SS god @Chi2Van. :)

I've been thinking about this... the spreadsheet functioned very well until the October 3/5 crush. As there isn't going to be a mad rush for next year I think we can get away with creating a fresh 2018 spreadsheet. I'm hesitant to start creating spreadsheets for each month as it's hard enough to keep linkages within one spreadsheet working properly.
 
  • Like
Reactions: hfinkel and vasvas
I just received QA (RQ) letter, good timing though have a week between Xmas and new year's eve off from my company to prepare the copies and docs.
 
Last edited:
  • Like
Reactions: jsm0085
I've been thinking about this... the spreadsheet functioned very well until the October 3/5 crush. As there isn't going to be a mad rush for next year I think we can get away with creating a fresh 2018 spreadsheet. I'm hesitant to start creating spreadsheets for each month as it's hard enough to keep linkages within one spreadsheet working properly.

I second this. One spreadsheet with data flowing is a good idea. Thanks for your help Chi2Van and other admins for the great work!
 
Test invite is it an email or change online on status or both ??

Test is usually a mail(snail) to your correspondence address. Online there is an update on ECAS with the date of the test. The mail will tell you the location.
 
I've been thinking about this... the spreadsheet functioned very well until the October 3/5 crush. As there isn't going to be a mad rush for next year I think we can get away with creating a fresh 2018 spreadsheet. I'm hesitant to start creating spreadsheets for each month as it's hard enough to keep linkages within one spreadsheet working properly.
Working with the spreadsheet online in the web browser is impossibly slow. I always download the spreadsheet as an excell file, then work with it locally on my computer. All data processing is instantaneous.
 
I've been thinking about this... the spreadsheet functioned very well until the October 3/5 crush. As there isn't going to be a mad rush for next year I think we can get away with creating a fresh 2018 spreadsheet. I'm hesitant to start creating spreadsheets for each month as it's hard enough to keep linkages within one spreadsheet working properly.

True. True. Can we not make one more workbook from Jan 2018 onwards. No additional worksheets in existing one maybe if that works. Just a suggestion.
 
Summary (by Date Delivered) of October 2017 applicants as per Google spreadsheet:

Date Delivered- #AOR- #Delivered- %AOR--- #Awaiting AOR- #In-Process-%In-Process
2-Oct-17-------4-------4-----------100.0%-----0--------------4-------------100%
3-Oct-17-------2-------2-----------100.0%-----0--------------2-------------100%
4-Oct-17-------1-------1-----------100.0%-----0--------------1-------------100%
5-Oct-17-------2-------2-----------100.0%-----0--------------2-------------100%
6-Oct-17-------7-------7-----------100.0%-----0--------------5-------------71.4%
10-Oct-17------6-------6-----------100.0%-----0--------------4-------------66.7%
12-Oct-17------22-----22----------100.0%----0--------------13------------59.1%
13-Oct-17------80-----87----------92.0%------7--------------49------------56.3%
16-Oct-17------235---254--------92.5%------19-------------118----------46.5%
17-Oct-17------40-----48----------83.3%------8--------------18------------37.5%
18-Oct-17------47-----51----------92.2%------4--------------14------------27.5%
19-Oct-17------64-----83----------77.1%------19-------------21-----------25.3%
20-Oct-17------37-----54----------68.5%------17-------------14-----------25.9%
23-Oct-17------16-----30----------53.3%------14-------------5-------------16.7%
24-Oct-17------2-------5-----------40.0%------3---------------0-------------0.0%
25-Oct-17------11-----17----------64.7%------6--------------3-------------17.6%
26-Oct-17------20-----28----------71.4%------8--------------4-------------14.3%
27-Oct-17------7-------11---------63.6%------4---------------2-------------18.2%
30-Oct-17------11-----15---------73.3%------4---------------0-------------0.0%
31-Oct-17------4-------8-----------50.0%------4--------------0--------------0.0%

Total-----------618----735--------84.1%------117----------279-----------38.0%


Weekly Summary of October 2017 applicants as per Google spreadsheet:

Week of (Mon-Sun)-- #AORs-- #In-Proccess-- #Test invites
Oct 23 - Oct 29-------13-------0--------------0
Oct 30 - Nov 05-------62-------1--------------0
Nov 06 - Nov 12------76-------1--------------0
Nov 13 - Nov 19------109-----21-------------0
Nov 20 - Nov 26------146-----52-------------0
Nov 27 - Dec 03------101-----51-------------0
Dec 04 - Dec 10------74-------73-------------4
Dec 11 - Dec 17------35-------75-------------3
Dec 18 - Dec 24------2--------5---------------1

Total-------------------618-----279-------------8
 
ECAS is showing my application is in progress as of Dec 18, 2017. Please update the spreadsheet.

ID: readhp
Line 469 of the global spreadsheet

Thank you!
 
Summary (by Date Delivered) of October 2017 applicants as per Google spreadsheet:

Date Delivered- #AOR- #Delivered- %AOR--- #Awaiting AOR- #In-Process-%In-Process
2-Oct-17-------4-------4-----------100.0%-----0--------------4-------------100%
3-Oct-17-------2-------2-----------100.0%-----0--------------2-------------100%
4-Oct-17-------1-------1-----------100.0%-----0--------------1-------------100%
5-Oct-17-------2-------2-----------100.0%-----0--------------2-------------100%
6-Oct-17-------7-------7-----------100.0%-----0--------------5-------------71.4%
10-Oct-17------6-------6-----------100.0%-----0--------------4-------------66.7%
12-Oct-17------22-----22----------100.0%----0--------------13------------59.1%
13-Oct-17------80-----87----------92.0%------7--------------49------------56.3%
16-Oct-17------235---254--------92.5%------19-------------118----------46.5%
17-Oct-17------40-----48----------83.3%------8--------------18------------37.5%
18-Oct-17------47-----51----------92.2%------4--------------14------------27.5%
19-Oct-17------64-----83----------77.1%------19-------------21-----------25.3%
20-Oct-17------37-----54----------68.5%------17-------------14-----------25.9%
23-Oct-17------16-----30----------53.3%------14-------------5-------------16.7%
24-Oct-17------2-------5-----------40.0%------3---------------0-------------0.0%
25-Oct-17------11-----17----------64.7%------6--------------3-------------17.6%
26-Oct-17------20-----28----------71.4%------8--------------4-------------14.3%
27-Oct-17------7-------11---------63.6%------4---------------2-------------18.2%
30-Oct-17------11-----15---------73.3%------4---------------0-------------0.0%
31-Oct-17------4-------8-----------50.0%------4--------------0--------------0.0%

Total-----------618----735--------84.1%------117----------279-----------38.0%


Weekly Summary of October 2017 applicants as per Google spreadsheet:

Week of (Mon-Sun)-- #AORs-- #In-Proccess-- #Test invites
Oct 23 - Oct 29-------13-------0--------------0
Oct 30 - Nov 05-------62-------1--------------0
Nov 06 - Nov 12------76-------1--------------0
Nov 13 - Nov 19------109-----21-------------0
Nov 20 - Nov 26------146-----52-------------0
Nov 27 - Dec 03------101-----51-------------0
Dec 04 - Dec 10------74-------73-------------4
Dec 11 - Dec 17------35-------75-------------3
Dec 18 - Dec 24------2--------5---------------1

Total-------------------618-----279-------------8

Can we get stats for RQ's as well? They seem to be quite a few
 
I just received QA (RQ) letter, good timing though have a week between Xmas and new year's eve off from my company to prepare the copies and docs.
Good luck,
Hope it won't be much of a hassle to gather all the required docs!
 
Does the QA request the updated employment letters or the employment letter can belong to the past?
I mean if I worked somewhere in 2013 and if I have an employment letter signed and dated in 2013, can I still use that?
 
Hi Chi2van,

I'm a new user. Would you mind adding me to the October sheet as well?

Id: Alex_H
App type: Single
Physical Presence Days: 1500+
Location: Toronto
Sent: Oct 11, 2017
Received: Oct 13, 2017
AoR: Nov 9, 2017
IP: Dec 08, 2017

I've been thinking about this... the spreadsheet functioned very well until the October 3/5 crush. As there isn't going to be a mad rush for next year I think we can get away with creating a fresh 2018 spreadsheet. I'm hesitant to start creating spreadsheets for each month as it's hard enough to keep linkages within one spreadsheet working properly.
 
In process Dec 19th please update the sheet