ABHereICome
Hero Member
- Jun 10, 2013
- 24
- Category........
- Visa Office......
- Sao Paulo
- NOC Code......
- 2132
- Job Offer........
- Pre-Assessed..
- App. Filed.......
- 2013-05-31<br>Fees Charged.: 2013-08-13<br>PER Received.: 2013-08-21<br>AOR Received.: 2013-09-18<br>MR received...: 2013-10-24<br>MEDs done.....: 2013-11-26<br>MEDs received: 2013-12-20<br>PPT & RPRF....: 2014-01-16<br>Passport sent.: 2014-01-17<br>Visa issued.....: 2014-01-23<br><img src="http://www.crossed-flag-pins.com/animated-flag-gif/gifs/Canada_240-animated-flag-gifs.gif"><br><b>FAQ:</b><br>http://fswp2013.wordpress.com/<br><b>Spreadsheet:</b><br>http://tinyurl.com/mrqj5yc<br><b>Chit Chat:</b><br>http://tinyurl.com/k8499r3<br><b>Share your own data:</b><br>http://tinyurl.com/add-entry-fswp2013<hr><img src="http://developer.linkedin.com/sites/default/files/LinkedIn_Logo30px.png">Join our Linkedin group. <b><a href="http://www.canadavisa.com/canada-immigration-discussion-board/index.php?action=pm;sa=send;u=467008">PM me</a></b> for more details.
Dear admins, sorry to bother again, but if you add a line to the header of the "Applications Received by NOC" with the formula =max(filter(Tracking!$D:$D,Tracking!$B:$B=D2,not(isblank(Tracking!$V:$V)),Tracking!$V:$V<>"N/A")) we could in one place track the dates of arrival that CIC is processing for each NOC. On the last column, with totals, you can supress the condition 'Tracking!$B:$B=??2' to show the most recent date processed, regardless the NOC code.
Thanks.
Thanks.