Britsimon
Super Moderator
I deleted the values of the cells containing the subtotals, i taught the values were placed there after your calculations. i didn't know they contained formulas but i made use of it when checking the Feb 25, 2015 data file (progress of Ghana). It worked perfectly.
View attachment 402
Feb 18, 2015 data file (progress of Ghana)
View attachment 403
Please why is it that almost a week after the 2NL were released, the family members total still stands at 623. Does that mean those who got the 2NL details have not been updated? If so, then whose duty is it to update it, KCC or the embassy?
The reason I put the totals on top this time was so they would always be right there in front of the user that doesn't use spreadsheets much. Whatever works for you though...
I do believe Accra are not updating CEAC correctly. I don't believe the 623 number - and actually don't believe any of the Accra numbers. AF region has 830 cases "in Transit" - which are "unclaimed" cases. That is about 1400 selectees - I am sure some of them belong to Accra. I also know that there are cases that are issued/refused etc still at ready, not just at Accra. So - whilst the CEAC data ended the year very accurately last year, I think the flurry of updates I saw in September was partly embassies catching up with status updates.