Hi,
Here is the link of the updated data :
docs.google.com/spreadsheets/d/1gXQxNj7q7uYuFS9wtxyDM5wCvlUbiUkmzC5W1JG5Phg/edit?pli=1#gid=1133734000
The file includes new Columns : ISSUED, REFUSED, AP, READY and TRANSFER. That's because when case status is ISSUED, derrivative can be refused, ready or somthing else.
Totals are calculated this way :
Here is the link of the updated data :
docs.google.com/spreadsheets/d/1gXQxNj7q7uYuFS9wtxyDM5wCvlUbiUkmzC5W1JG5Phg/edit?pli=1#gid=1133734000
The file includes new Columns : ISSUED, REFUSED, AP, READY and TRANSFER. That's because when case status is ISSUED, derrivative can be refused, ready or somthing else.
Totals are calculated this way :
- When the case is ISSUED, only ISSUED column is considered.
- When the case is REFUSED, All family members should be the same (it s not the case in CEAC Website) + Refused derrivative from ISSUED,
- When the case is AP, all family members are considered + AP derrivative from ISSUED cases.
- When the case is READY or TRANSFER, all family members are considered + derrivative in the same state from ISSUED cases.
Last edited: