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

EXPRESS ENTRY SPREADSHEET - Please Discuss here !!!!

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
so64 said:
Please delete duplicate entries from spreadsheet. I think I have one.
done .. thanks
 

idefix

Champion Member
Oct 1, 2014
1,242
272
Hey srbhrn,

Great job on the SS again! +1 to you.

Now that the system is open, what do you think about creating a few more columns?

- Eligible programs: FSW, PNP, CEC, FST (maybe with option Y/N for each);
- Overall Score (real on EE site);
- EE Effective Date (preferred to first eligible draw - because we'll probably have two draws per month)
 

shrinivas1980

Hero Member
Oct 1, 2013
438
15
Category........
Visa Office......
NDVO
NOC Code......
2211
Job Offer........
Pre-Assessed..
srbhrn said:
You can now see your standing from top.. I have put a column that calculates at what percentage you are.. Hope it helps..
srbhrn, can you kindly delete one of my entries that I have mentioned in the spreadsheet. Please delete the profile named skothekar2010 with 367 points. This profile is in the 59th position in the spreadsheet. The date of creation of this entry is 12/4/2014.

I tried but don't know how to delete.

Thanks in advance.
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
shrinivas1980 said:
srbhrn, can you kindly delete one of my entries that I have mentioned in the spreadsheet. Please delete the profile named skothekar2010 with 367 points. This profile is in the 59th position in the spreadsheet. The date of creation of this entry is 12/4/2014.

I tried but don't know how to delete.

Thanks in advance.
Deleted
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
expressTarun said:
delete my duplicate entry too buddy!
I only see one entry by EXPRESSTARUN.. can you please share the ROW number..
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
idefix said:
Hey srbhrn,

Great job on the SS again! +1 to you.

Now that the system is open, what do you think about creating a few more columns?

- Eligible programs: FSW, PNP, CEC, FST (maybe with option Y/N for each);
- Overall Score (real on EE site);
- EE Effective Date (preferred to first eligible draw - because we'll probably have two draws per month)
+1 to you too.. I see that you are helping a lot of EE applicants around even though you are an FSW applicant as well.. +1 to you too ..

Thanks for teh suggestions. Here is how I have taken care of them:
1. Added the checkbox field
2. Dont want to introduce two fields of self calculated point and EE profile points.. maybe I should just mention that if EE profile has been created tehn put points from there. What do you think?
3. I thought so too.. When the time comes, I will make it like this:
Feb 1st draw
Feb 2nd Draw
Mar 1st Draw
Mar 2nd Draw

and so on .. am not sure how useful would it be to capture dates here. Suggest.
 

talktoudaykumar

Hero Member
Sep 18, 2013
352
84
Ontario
Category........
CEC
Visa Office......
OTTAWA
NOC Code......
2174
Job Offer........
Yes
App. Filed.......
11-03-2021
Nomination.....
ITA 14-02-2021
AOR Received.
11-03-2021
Med's Done....
25-03-2021
VISA ISSUED...
31-10-2021
Hi


Can you explain the 'standing from TOP' cloumn? got bit confused of it.
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
talktoudaykumar said:
Hi


Can you explain the 'standing from TOP' cloumn? got bit confused of it.
I think I need to explain it somewhere ..

What that Column shows you is your standing from top ..

So if you have 47% in that column against your name, it means that in a group of 100 people, you are 47th from top (highest score in this scenario) ...
 

whzqsun

Member
Dec 23, 2014
19
0
Category........
Visa Office......
Hongkong
NOC Code......
2172
Job Offer........
Pre-Assessed..
App. Filed.......
19-02-2016
Doc's Request.
22-02-2016 04-05-2016
Nomination.....
07-01-2016
AOR Received.
19-02-2016
Med's Done....
17-02-2016
Passport Req..
19-08-2016
Hi.
EE points less than 100 should be deleted from the worksheet.
 

idefix

Champion Member
Oct 1, 2014
1,242
272
srbhrn said:
+1 to you too.. I see that you are helping a lot of EE applicants around even though you are an FSW applicant as well.. +1 to you too ..

Thanks for teh suggestions. Here is how I have taken care of them:
1. Added the checkbox field
2. Dont want to introduce two fields of self calculated point and EE profile points.. maybe I should just mention that if EE profile has been created tehn put points from there. What do you think?
3. I thought so too.. When the time comes, I will make it like this:
Feb 1st draw
Feb 2nd Draw
Mar 1st Draw
Mar 2nd Draw

and so on .. am not sure how useful would it be to capture dates here. Suggest.
Thanks! But I've also created my profile on EE - I'm not sure yet if I'll get my PER, don't want to miss any chances.

Nice job, the SS looks nice.

Good suggestion on the point 2.

Once the ITA comes, we will have a lot more things to look into:
- when the ITA came;
- when the forms / docs were submitted;
- how long it actually took to get an answer;
.. and so forth.

We'll be able to help people predict when they should get an answer, and if that is related to the Visa Office as well.

If I understood things correctly, we'll get one Ministerial Instruction per draw - so it will be nice to have a page containing the base rules.
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
whzqsun said:
Hi.
EE points less than 100 should be deleted from the worksheet.
There were two such entries.. Looked inaccurate and incomplete.. DELETED them
 

talktoudaykumar

Hero Member
Sep 18, 2013
352
84
Ontario
Category........
CEC
Visa Office......
OTTAWA
NOC Code......
2174
Job Offer........
Yes
App. Filed.......
11-03-2021
Nomination.....
ITA 14-02-2021
AOR Received.
11-03-2021
Med's Done....
25-03-2021
VISA ISSUED...
31-10-2021
Hi

How to edit the entry in excel sheet. I got 350 points when i created the EE profile. But i entered 340 in the excel sheet.
 

srbhrn

Hero Member
Aug 14, 2014
431
42
New Delhi
Category........
Visa Office......
New Delhi
NOC Code......
2171
Job Offer........
Pre-Assessed..
App. Filed.......
01-01-2015
IELTS Request
Entered in EE Profile
talktoudaykumar said:
Hi

How to edit the entry in excel sheet. I got 350 points when i created the EE profile. But i entered 340 in the excel sheet.
If you saved the edit link then you can change it as many times as you want .. otherwise mention the row number and the new values you want to put.. I will do it for you ..