Tool for 180 day Continuous stay calculation

The Jan 2018 changes in immigration rules revised how the 180 day absence was calculated.
This has made it complex for applicants to determine if they are compliant with the 180 day absence.
I create an excel sheet to try and help determine if an applicant would violate the 180 day absence.
You can find it at https://1drv.ms/x/s!Aq7gSza4ER7CmP01mJt0s9dX8ontdQ
Instructions to use it are in the file itself.
Essentially, you enter the travel dates (you need a password which is included in the file) and where there is a problem, a red NOK will show up.
I have tried to check different scenarios and it works in most cases.
But it is not perfect - it does show NOK in small cases when it is actually ok - so you should double check the result.
I welcome further feedback on how useful it is and any errors that you can spot.

Dear Marcnath,

This tool looks good and may help me to calculate my absence for more than 180 days in any 12 months. I saved this in my computer but its password protected. What password you are referring to included in the sheet? Please advise.

Cheers

Hadi2008 wrote: ↑

Mon Apr 16, 2018 6:22 am

Dear Marcnath,

This tool looks good and may help me to calculate my absence for more than 180 days in any 12 months. I saved this in my computer but its password protected. What password you are referring to included in the sheet? Please advise.

Cheers

When you try to enter the dates, it should ask for a password. The password ("unlock") is in the instructions at the bottom of the sheet.

marcnath wrote: ↑

Mon Apr 16, 2018 6:33 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 6:22 am

Dear Marcnath,

This tool looks good and may help me to calculate my absence for more than 180 days in any 12 months. I saved this in my computer but its password protected. What password you are referring to included in the sheet? Please advise.

Cheers

When you try to enter the dates, it should ask for a password. The password ("unlock") is in the instructions at the bottom of the sheet.

Thank you. I will get back to you if I find any problem. I hope not finger crossed

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

BTW, NO red NOK appeared

Your date format is showing MM/DD/YYYY. whereas in the file it looks like DD/MM/YYYY. Maybe I have missed something, Marcnath could confirm.

Hadi2008 wrote: ↑

Mon Apr 16, 2018 9:23 am

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

The following dates are as per MM/DD/YYYY Format. Let me know what results you are getting

Departure Arrival

02/10/2014 - 05/10/2014
06/23/2014 - 08/20/2014
12/08/2014 - 01/10/2015
02/23/2015 - 03/03/2015
05/21/2015 - 05/29/2015
09/10/2015 - 09/22/2015
02/17/2017 - 03/04/2017
03/03/2018 - 03/11/2018

Thanks

Hadi2008 wrote: ↑

Mon Apr 16, 2018 9:23 am

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

Not sure what you mean by half the information - if you are talking about some blank cells in the top rows that is as expected.

But, as you said, it does not show any NOK, so that should mean you are ok. And looking at your travel manually, yes it is ok

marcnath wrote: ↑

Mon Apr 16, 2018 10:24 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 9:23 am

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

Not sure what you mean by half the information - if you are talking about some blank cells in the top rows that is as expected.

But, as you said, it does not show any NOK, so that should mean you are ok. And looking at your travel manually, yes it is ok

Sorry, I may have confused you. I mean in column F (Travel Days) it calculates upto 4 rows only, however, I have 8 rows to fill and therefore not getting for the last 4 travel dates.

Hadi2008 wrote: ↑

Mon Apr 16, 2018 10:28 am

marcnath wrote: ↑

Mon Apr 16, 2018 10:24 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 9:23 am

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

Not sure what you mean by half the information - if you are talking about some blank cells in the top rows that is as expected.

But, as you said, it does not show any NOK, so that should mean you are ok. And looking at your travel manually, yes it is ok

Sorry, I may have confused you. I mean in column F (Travel Days) it calculates upto 4 rows only, however, I have 8 rows to fill and therefore not getting for the last 4 travel dates.

That is also as designed - once it crosses 180 days, the tool does not calculate any further but just checks that the 180 days is not within 12 months. Column H then calculates for the next set of travel and so on.

marcnath wrote: ↑

Mon Apr 16, 2018 10:55 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 10:28 am

marcnath wrote: ↑

Mon Apr 16, 2018 10:24 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 9:23 am

Marcnath,

I input my travel dates listed below by using your tool, but provides me half of the information that confuses me. Please could you help me see what result you may get and kindly let me know if I am all ok and under 180 days requirement?

Departure - Arrival

2/10/2014 - 5/10/2014
6/23/2014 - 8/20/2014
12/8/2014 - 1/10/2015
2/23/2015 - 3/3/2015
5/21/2015 - 5/29/2015
9/10/2015 - 9/22/2015
2/17/2017 - 3/4/2017
3/3/2018 - 3/11/2018

Thank you

Not sure what you mean by half the information - if you are talking about some blank cells in the top rows that is as expected.

But, as you said, it does not show any NOK, so that should mean you are ok. And looking at your travel manually, yes it is ok

Sorry, I may have confused you. I mean in column F (Travel Days) it calculates upto 4 rows only, however, I have 8 rows to fill and therefore not getting for the last 4 travel dates.

That is also as designed - once it crosses 180 days, the tool does not calculate any further but just checks that the 180 days is not within 12 months. Column H then calculates for the next set of travel and so on.

Thank you for the brief. So according to your calculation/observation and as per the travel dates provided, do I meet the requirement and have not exceeded 180 days each year?

Hi Marcnath,
As regards T1E dependent, I understand from below from their guide that my dependent's absences before January 2018 will not be counted, is this true? Me & my wife got T1E visa on 5/09/12, entered UK on 21/9/12
and got extension on 17/11/16
PBS dependants
You must not include any absence from the UK during periods of leave granted
under the Rules in place before 11 January 2018 towards the 180 days allowable
absences. For example, if a dependant’s qualifying period includes initial leave
granted from 1 January 2015 to 31 December 2017, and an extension granted from
1 January 2018 to 31 December 2019, you must not count any absences before 1
January 2018.

Hadi2008 wrote: ↑

Mon Apr 16, 2018 12:11 pm

marcnath wrote: ↑

Mon Apr 16, 2018 10:55 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 10:28 am

marcnath wrote: ↑

Mon Apr 16, 2018 10:24 am

Not sure what you mean by half the information - if you are talking about some blank cells in the top rows that is as expected.

But, as you said, it does not show any NOK, so that should mean you are ok. And looking at your travel manually, yes it is ok

Sorry, I may have confused you. I mean in column F (Travel Days) it calculates upto 4 rows only, however, I have 8 rows to fill and therefore not getting for the last 4 travel dates.

That is also as designed - once it crosses 180 days, the tool does not calculate any further but just checks that the 180 days is not within 12 months. Column H then calculates for the next set of travel and so on.

Thank you for the brief. So according to your calculation/observation and as per the travel dates provided, do I meet the requirement and have not exceeded 180 days each year?

Correct. You got quite close - 177 days.. but not 180. If you had left on the 7th Feb 2015 instead of 23rd Feb, you would not have met the requirement.

marcnath wrote: ↑

Mon Apr 16, 2018 2:06 pm

Hadi2008 wrote: ↑

Mon Apr 16, 2018 12:11 pm

marcnath wrote: ↑

Mon Apr 16, 2018 10:55 am

Hadi2008 wrote: ↑

Mon Apr 16, 2018 10:28 am

Sorry, I may have confused you. I mean in column F (Travel Days) it calculates upto 4 rows only, however, I have 8 rows to fill and therefore not getting for the last 4 travel dates.

That is also as designed - once it crosses 180 days, the tool does not calculate any further but just checks that the 180 days is not within 12 months. Column H then calculates for the next set of travel and so on.

Thank you for the brief. So according to your calculation/observation and as per the travel dates provided, do I meet the requirement and have not exceeded 180 days each year?

Correct. You got quite close - 177 days.. but not 180. If you had left on the 7th Feb 2015 instead of 23rd Feb, you would not have met the requirement.

WOW, lucky me. I was indeed closed. Thank you for helping me out with the calculation.

Hi Marcnath,

Thanks for this great tool.Can you please clarify Under tier 1E route total absence in each one year is 180 days? which is for 5 years 900 days ? or is total 180 days for complete 5 years to qualify for ILR.

And what about 10 years long residence , which is according to my knowledge is total 18 months(540 days) and each year no more than 180 days absence.
My scenario is as under

mm/yyyy---- mm/yy-------Absence
09/2009-----10/2009--------26
11/2011-----12/2011 -------33
10/2012-----12/2012 -------65
04/2015-----05/2015 -------31
07/2015-----10/2015--------77
04/2016-----07/2016--------82
11/2016-----02/2017 -------92
07/2017----- 07/2017--------5
12/2017-----02/2018 --------74
Total ======485 days

Total absence is 485 days in 9.5 years
Total absence during Tier 1E is 361 days


Please let me know if i am ok Under both scenarios ( 5 year ilr n 10 Year Ilr)

Many thanks

qkiyani wrote: ↑

Wed Apr 18, 2018 1:34 am

Thanks for this great tool.Can you please clarify Under tier 1E route total absence in each one year is 180 days? which is for 5 years 900 days ? or is total 180 days for complete 5 years to qualify for ILR.

It is neither of those. It is just 180 days in ANY 12 month period, so there is no total absence.

qkiyani wrote: ↑

Wed Apr 18, 2018 1:34 am

And what about 10 years long residence , which is according to my knowledge is total 18 months(540 days) and each year no more than 180 days absence.

I'll admit I am not totally familiar with LR but that sounds about right.

qkiyani wrote: ↑

Wed Apr 18, 2018 1:34 am

My scenario is as under

mm/yyyy---- mm/yy-------Absence
09/2009-----10/2009--------26
11/2011-----12/2011 -------33
10/2012-----12/2012 -------65
04/2015-----05/2015 -------31
07/2015-----10/2015--------77
04/2016-----07/2016--------82
11/2016-----02/2017 -------92
07/2017----- 07/2017--------5
12/2017-----02/2018 --------74
Total ======485 days

Total absence is 485 days in 9.5 years
Total absence during Tier 1E is 361 days


Please let me know if i am ok Under both scenarios ( 5 year ilr n 10 Year Ilr)

The tool should tell you if it is ok for 5 year but just looking at it here, it does seem ok for both.

Hi

Your program is great.

Could you have a look at my travels? Obviously it says NOK.
If the calcuation would be from 28.11.13 to 28.11.14 is it less than 180 days, but your program looks like calculating from 28.11.13 to 31.11.14. Could you advise how HO would calculate with the revised rule please?

18.9.13 4.10.13
16.10.13 22.10.13
28.11.13 17.12.13 <<
12.1.14 28.1.14
19.2.14 7.3.14
31.3.14 18.4.14
14.5.14 12.6.14
9.7.14 29.7.14
23.8.14 17.9.14
10.10.14 29.10.14
27.11.14 31.12.14<<

esrsx wrote: ↑

Mon Apr 30, 2018 3:34 pm

Hi

Your program is great.

Could you have a look at my travels? Obviously it says NOK.
If the calcuation would be from 28.11.13 to 28.11.14 is it less than 180 days, but your program looks like calculating from 28.11.13 to 31.11.14. Could you advise how HO would calculate with the revised rule please?

18.9.13 4.10.13
16.10.13 22.10.13
28.11.13 17.12.13 <<
12.1.14 28.1.14
19.2.14 7.3.14
31.3.14 18.4.14
14.5.14 12.6.14
9.7.14 29.7.14
23.8.14 17.9.14
10.10.14 29.10.14
27.11.14 31.12.14<<

You are right.
As I had mentioned, it is not perfect but meant to help make your assessment.
So, the NOK is more of a risk pointer.

Your travel pattern will help me improve it, but you seem to be ok. Your worst case is possibly between 16.12.13 and 15.12.14 where you get to about 150 days of travel.