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.Here is SS god @Chi2Van.
I second this. One spreadsheet with data flowing is a good idea. Thanks for your help Chi2Van and other admins for the great work!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.
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.Test invite is it an email or change online on status or both ??
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.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.
Can we get stats for RQ's as well? They seem to be quite a fewSummary (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
Good luck,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.
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.