Express Entry 2016 - Master spreadsheet : One spreadsheet for all AORs

[JoacRy]

Hi joelmath, the spreadsheet looks really good and wanted to fill out today but was busy at work. Will fill out tomorrow and provide feedback.

Top marks for your initiative.

 

[munjal]

Hi Munjal,

Thank you for the feedback. By country of origin do you mean nationality/citizenship? It will of-course provide a nationality-wise breakdown of Inland entries that have selected Canada as country of residence. I am failing to visualize how that would help in understanding/analysing processing time calculations. Can you clarify a bit more?

@Other forum members do you have further suggestions for the spreadsheet. As Munjal pointed out the spreadsheet is still in its early stages and at this point we can play around with the data points without much impact.

Hi Joelmath,

yes, you got it correct, I mean to say... Country of nationality/citizenship...

Because applicants applying from within Canada will all mention as "inland applicant".. and country of residence will be Canada for them, same may be true for people living in country different than their nationality.. for ex, there are many Indians working in middle-east countries. The same will hold true for them also.
If you can add a separate column of "Country of nationality/citizenship, then it will exactly give the number of applicants applying country-wise based on their nationality/citizenship..
It is very much similar to the mid-year report of CIC.
You can check it here: http://www.cic.gc.ca/english/resources/reports/ee-midyear-2015.asp

Few more things have came up in my mind... just wanted to share it with you... I am sure you are open for feedbacks/suggestions, thats why I am sharing it here with you..

A single NOC carries many job titles, so if another column for " designation/job title of primary NOC" can be added, this will give more clarity about NOC-wise and designation-wise distribution of applicants.

I think you have made a fantastic effort while preparing this spreadsheet/s and I am sure it will serve as a comprehensive data pool for we,applicants to refer for each and every draw.

Also, you can add one column for "date EE profile created".

 

[joelmath]

Hi Joelmath,

yes, you got it correct, I mean to say... Country of nationality/citizenship...

Because applicants applying from within Canada will all mention as "inland applicant".. and country of residence will be Canada for them, same may be true for people living in country different than their nationality.. for ex, there are many Indians working in middle-east countries. The same will hold true for them also.
If you can add a separate column of "Country of nationality/citizenship, then it will exactly give the number of applicants applying country-wise based on their nationality/citizenship..
It is very much similar to the mid-year report of CIC.
You can check it here: http://www.cic.gc.ca/english/resources/reports/ee-midyear-2015.asp

Few more things have came up in my mind... just wanted to share it with you... I am sure you are open for feedbacks/suggestions, thats why I am sharing it here with you..

A single NOC carries many job titles, so if another column for " designation/job title of primary NOC" can be added, this will give more clarity about NOC-wise and designation-wise distribution of applicants.

I think you have made a fantastic effort while preparing this spreadsheet/s and I am sure it will serve as a comprehensive data pool for we,applicants to refer for each and every draw.

Also, you can add one column for "date EE profile created".

Thank you @munjal for the suggestions. The designation/Job title column seems like going into too much detail at the moment. I have added new sections for Nationality and Date of EE profile creation to the data collection form.

Keep them coming

 

[munjal]

Thank you @munjal for the suggestions. The designation/Job title column seems like going into too much detail at the moment. I have added new sections for Nationality and Date of EE profile creation to the data collection form.

Keep them coming

I appreciate your proactive approach..
will share more if any comes in mind..

thanks..

 

[JoacRy]

Hi joelmath, is it possible to modify the spreadsheet for applicants waiting for an ITA? It seems this is only for people in the post ITA stage.

 

[joelmath]

Hi joelmath, is it possible to modify the spreadsheet for applicants waiting for an ITA? It seems this is only for people in the post ITA stage.

Hi JoacRy, yes this spreadsheet is for post ITA processing. There was a spreadsheet on this forum that was created for those waiting for ITA. There are 2 issues with such a spreadsheet:

1) People with 600 points from PNP or arranged employment would rarely update their entries as they are almost guaranteed to be selected with couple of draws.
2) The second issue was that there was nothing much that could be captured apart from waiting time for ITA. In this spreadsheet Profile creation date and ITA date will capture that average waiting time.

 

[joelmath]

@JoacRy regarding this reply that I believe you mistakenly posted on another thread : http://www.canadavisa.com/canada-immigration-discussion-board/mycic-is-down-for-5-days-help-t390673.0.html

"Hi joelmath, just to let you know when I click on the links it says '...the page does not exist...'

Just trying to update my details. Just thought you should know in case others are trying and unsuccessful.

Quick update: Managed to access the spreadsheet after changing browser to Google Chrome. However I am not being allowed to type details in the spreadsheet. Look for your guidance."


Editing spreadsheet is disabled. The data needs to be filled into the form [Add your details here : https://goo.gl/03ozE6]. Once you fill up the form, you will find your entry as new row in the spreadsheet. This is to prevent others from editing data that does not belong to them or accidentally deleting content. It also ensures that everyone enters their data in correct format and irregularities within the spreadsheet can be reduced e.g different date formats or typos etc.

Collectively this will result in better analysis when there are enough entries in the spreadsheet.

 

[caddr]

Good work Joelmath...but can i make one suggestion that can you please arrange the entries in order of app submission as that will give a more clearer picture

 

[joelmath]

Good work Joelmath...but can i make one suggestion that can you please arrange the entries in order of app submission as that will give a more clearer picture

Good suggestion @caddr, it does make it easier for people to find other applicants with closer AOR dates. It cannot be fixed as its one of the limitations of google spreadsheet. A new entry is always added to a new row based on Timestamp. With that said, all users can very easily sort the entries based on app submission dates. Simply select the Sort A-Z from the dropdown on "J" column. The same applies to any other column within the spreadsheet.

Note : I have sorted the current entries based on app submission dates. I will repeat the same 3-4 times everyday.

 

[kvr007]

Hi,

Can you make username and category columns freeze. If I go far right in the spread sheet it makes difficult to compare certain things with other applicants.

Thanks

 

[joelmath]

Hi,

Can you make username and category columns freeze. If I go far right in the spread sheet it makes difficult to compare certain things with other applicants.

Thanks

@kvr007 . Its done. Thank you for the suggestion

 

[munjal]

@kvr007 . Its done. Thank you for the suggestion

Just out of curiosity, if you need my help in maintaining this spreadsheet... I will be more than happy to do it..
you can count me on it..

 

[joelmath]

Just out of curiosity, if you need my help in maintaining this spreadsheet... I will be more than happy to do it..
you can count me on it..

Sure.. PM me ur email..

 

[ppahuja]

+1 for the initiative Joelmath.

 

[munjal]

Sure.. PM me ur email..

thanks bro..
check your inbox