[Fixed] 2014 Citizenship Spreadsheet

[pradeepkumar_v]

Thanks Paco! Great work.

Hi all,

As you probably know, since couple of time (look like starting august), the 2014 spreadsheet became unreliable because people used a partial filter, so it messed up the columns between 'Test date' and 'Notes'.

I just spend couple of hours fixing the whole thing (dates, functions, filter...).

For Test/Oath dates, I did a grunt work by searching for every single nickname of the people who where in yellow (test date) or green (oath date) in their last posts in the forum.

I was able to recover 40 test dates (out of 108) and 25 oath dates (out of 42).

It's not perfect but at least now the spreadsheet is 100% reliable.

So please update your row if necessary, especially if you passed the Test or attended to Oath ceremony recentely:

https://docs.google.com/spreadsheet/ccc?key=0Au02r_J_VN90dHdrcDJyaWZYYW55d0hJMzJDNUFRaHc

Good luck to everyone !

 

[Paco]

Many updates for the Global Spreadsheet:

- Now it include 2015 applicants as well =)
- New short url : http://bit.ly/citizenship-ca
- Refreshed against different sources : individual spreadsheets and last members' posts.
- Added write protection for functions, labels,...etc.
- New detailed statistics, by local office !

We reached a total of 648 applicants, 189 Test dates and 99 Oath dates ! ;D

Please update your timeline, and insert the short url in your signature (Profil > Modify Profil > Forum Profile Information):

Citizenship Global Spreadsheet
http://bit.ly/citizenship-ca

Also any suggestion is welcome.

Good luck to all !

 

[alexdive]

Keep up the good work!
Thanks,

 

[kumbu.bumbu]

Good work! Thanks for doing this!

Is there a way to pin the top column that tells us what the column is for? It helps those of us who have to scroll all the way to the bottom/later months, since we can see what the column refers to as we scroll down.

Thanks!

Check now.

And great job Paco. That is really lot of work.

 

[Paco]

You're welcome =)

Update:

I added a copy of the 100 completed applications on a dedicated (and protected) spreadsheet in the same Workbook: Timelines-Completed.

This one is sorted by Local Office then by Received Date.

As usual:

Please update your timeline, and insert the short url in your signature (Profil > Modify Profil > Forum Profile Information):

Citizenship Global Spreadsheet
http://bit.ly/citizenship-ca

Do not forget also to mention your location/local office, as the delay are not the same for every CIC local office.

Hope this helps,

 

[u4g5]

Thanks

 

[Paco]

Here is the last stats you can see in the spreadsheet 'Statistics', based on 101 completed applications (2014/2015):