Spreadsheet: 128ced94-24c9-4264-b7c4-1736fb0e2494
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | Date Calculators for Immigration Processing (version 3-1)
 |  | CLICK ON A WORKSHEET TAB BELOW TO OPEN THE CALCULATOR OF YOUR CHOICE  The calculators in this file have been developed as tools to help international student and scholar advisors determine time used and time remaining for various types of immigration eligibility.  The Days From and Days Prior calculators can also be used in a variety of ways such determining the earliest or latest date an application can be submitted.  No doubt, you will find a number of different uses not anticipated in the development.  After entering the data, you can print the result for your files, should that be of use.  Both the OPT-CPT calculator, AT, and "H, J, Other" calculator use a "+1" calculation in the date formulas so that authorizations are inclusive of the start and end dates.  For example, if you enter 12/10/2007 to 12/11/2007 without the "+1" in the formula, the result is "1", implying there was only one day of authorization when, in fact, you must count both days when subtracting from overall eligibility.  With the "+1" in the formula, both days are included and the result correctly states that the individual was authorized for two ("2") days of employment.
 |  | About the Calculators:
 |  | OPT-CPT Calculator:  Use this calculator to determine how much Curricular Practical Training (CPT) has been used by a student in F-1 status and to determine if the student is still eligible for Optional Practical Training (OPT).  The calculator can also be used to determine remaining OPT eligibility at the same educational level without entering any CPT information.  Entering a start date returns the exact end date for that student's authorization given the remaining eligibility.
 |  | OPT-CPT Calculator (Long):  Occasionally, a student will be authorized for many separate periods of CPT (or even OPT).  This calculator is the same as the "short" version except that it has rows for up to 20 part-time authorizations and 8 full-time authorizations in both CPT and OPT.   The short version is easier, visually, to use and to print, but it seemed necessary to include the long version for those rare students with a great deal of CPT or OPT.
 |  | AT Calculator:  Use this calculator to determine how much [NAME] time has been used and how much eligibility remains. Entering a start date returns the exact end date for that student's authorization given the remaining eligibility.
 |  | AT Calculator (Long):  Occasionally, a student in J-1 status will be authorized for many separate periods of [NAME] (AT).  This version is the same as the "short" version except that it has rows for up to 20 authorizations.  The short version is easier, visually, to use and to print, but it seemed necessary to include the long version for those rare students with a great deal of AT.  Use this calculator to determine how much [NAME] time has been used and how much eligibility remains. Entering a start date returns the exact end date for that student's authorization given the remaining eligibility.
 |  | OPT STEM Calculator:  This tool helps international student advisors determine the "validation report" deadlines for students in F-1 status who have been granted a 17-month extension of their Optional Practical Training employment authorization.  This type of extension is available to students in the STEM fields (science, technology, engineering and mathematics) under a rule promulgated on April 8, 2008.  [8 CFR § 214.2 (f)(10)(ii)(C); 68 Federal Register 73 (April 8, 2008) pp. 18944-18956]
 |  | Days FROM:  This calculator helps you figure out the date that falls a certain number of days after the date you enter into the calculator.  It can be useful for determining SEVIS reporting deadlines, employment authorization end dates (when you don't have to factor in previous authorizations), and other useful dates.
 |  | Days PRIOR:  Use this calculator to determine the date that is a certain number of days before (prior to) the date you enter into the calculator.  This is useful when trying to figure out, for example, what is the earliest date a student can apply for OPT if they can only submit an application 90 days prior to meeting the one academic year minimum.
 |  | 240 Days:  Rules governing employment authorization and Form I-9 (Employment Eligibility Verification) allow an employer to employ an individual for up to 240 days, in certain circumstances, if an extension application/petition has been filed to extend the individual's current employment authorization [8 CFR § 274a.12(b)(20)].  This calculator allows you to figure out the last day the individual can work under the 240 day rule given the start date you enter.
 |  | H, J, Other:  This calculator is useful for determining the period to request when submitting an I-129 or to enter into SEVIS in order to produce a DS-2019 when there is a specific limit to the period of time the individual may be authorized for a given status.  It can be used for any status -- or calculation of any type -- that includes a time restriction.  Since most restrictions are in terms of years, the calculator uses 365 days -- and multiples thereof -- as its base calculation and expects you to enter years, rather than days, of eligibility.  However, you can enter a six-month restriction (for [NAME]-term scholars, for example) by entering ".5" (half of one year).
 |  | H, J, Other (Long):  This calculator functions exactly the same way as the regular "H, J, Other" calculator, but provides more rows for entering periods of time to be re-couped.
 |  | Two-year Home Residence (212e) Calculator:  [NAME] and students who are subject to the two-year home residence requirement under J-1 Exchange Visitor regulations sometimes attempt to argue that they have met the requirement in the aggregate by spending time in their home country for several shorter periods of time over a number of years.  This tool helps to determine if the periods spent in the home country add up to two years or more.  At the discretion of the international student/scholar advisor, a printout of this calculator (with all of the dates filled in), might be included in an application for a benefit such as change of status, or presented to a consular official to help make the case that 212e has been satisfied.
 |  | Note that the calculator defines "two years" as 365 days times two.  It is possible, though unlikely, that a USCIS or DOS official could define it differently.  For example, if you enter 8/25/2006 to 8/24/2008 in the calculator, the calculator tells you that the individual was home for 730 days and, therefore "YES" the requirement has been met.  A consular officer might say that the individual needed to be home on or past 8/25/2008 to meet the requirement according to what the officer considers the two-year mark to be.  Again, this is unlikely, but it is important to point consider that "two years" can be defined differently.
 |  | PERM Special Handling:   This calculator allows you determine the latest date PERM must be filed if the case is being filed under "Special Handling."  It also helps you determine what the earliest date is that you can file PERM based on the last day of the "posting notice" (i.e., the 10th day of the 10 day posting requirement).  Finally, it is a place to record how long the Prevailing Wage Determination is valid.  The results can be printed to be kept with the case file, if needed.  For this reason, we have included a place to enter the beneficiary's name.
 |  | PERM Deadlines:   This calculator assists with regular PERM cases (i.e., not Special Handling) and allows you determine various key dates in the process.  It is also a place to record how long the Prevailing Wage Determination is valid.  The results can be printed to keep with the case file, if needed.  For this reason, we have included a place to enter the beneficiary's name.
 |  | CSPA Age Calculator:   With this tool, you can decide if an applicant for certain benefits may retain classification as a “child” even if he or she has reached the age of 21, as permitted under the Child Status Protection Act (CSPA).
 |  | Most of the calculators in this tool were developed by [NAME], Associate Director of Boston University's International Students & Scholars Office.  The PERM calculators were developed by [NAME], Director of International Students & Scholar Services at the University of Colorado at Boulder.  [NAME] of The University of Tennessee Health Science Center's Office of International Affairs suggested the CSPA calculator.  Should you have any suggestions or find any errors, please email [NAME].  IMPORTANT NOTE:  This tool does not imply legal advice or authority in any way.  Use of the calculators in this tool is at your own discretion and risk.
 |  | Changes and Updates
 |  | Notes on Version 2-3 (5/14/2007):  Three important changes/additions have been made since the original version that was distributed through NAFSA's web site in April 2007.    1.  The addition of the CSPA calculator.  2.  The addtion of the "Time Recouped" section of the H, J, Other Calculator  3.  A correction to the H, J, Other calculator:  in the original version, the "+1" calculation was used as it is used in the OPT and AT calculators (see description above).  However, the purpose of this calculator is to determine a date in the future and not to count the number of days of work/activity.  As originally written, the calculator "shorted" one day in each period of previous status calculated.  The "+1" has been removed from this version.  (IMPORTANT: The "+1" was reintroduced in Version 3-1.  See notes below).  --------------------  Notes on Version 2-4 (5/21/2007):  After version 2-3 was posted to the NAFSA web site, new rules from the Department of Labor regarding Labor Certification submissions were published that created the need for 180-day calculations.  So, these were added to the PERM calculators as well as the Days FROM and the Days PRIOR calculators.
 |  | --------------------  Notes on Version 2-5 (2/15/2008):  A very minor text adjustment was made on the OPT-CPT calculators to make it clear that total days of eligibilty related to OPT specifically.  Also, minor adjustments were made to the AT caclulators so they show "months remaining" without requiring a start date.  --------------------  Notes on Version 2-6 (9/10/2008):  At the suggestion of a consular officer in Sydney, the CSPA Age Calculator was adjusted by adding #8 in the calculator itself and by adding additional language in the "In addition..." text under the section titled "Who is Eligible for the Child Status Protection Act (CSPA)?".  The text is taken from a worksheet found on the web site of the U.S. Consulate in Seoul, as was the rest of the text found in that section of the calculator.  The web site address for the worksheet is found in the footnotes of the CSPA calculator.  In addition, footnote #2 of the AT Calculators was reworded to more clearly describe how the actual months used and months of eligibility are converted to days to determine an exact end date.  --------------------
 |  | Notes on Version 2-7 (12/12/2008):  Added the "212e" (Exchange Visitor two-year home residence) calculator.  --------------------  Notes on Version 3-0 (2/6/2009):  NAFSA's Knowledge Community for International Student and Scholar Services (KC-ISSS) suggested the addition of an OPT STEM calculator which has now been developed and added to this version.  The long version of the "H, J, Other" calculator was added to accommodate scholars with a large number of periods of time spent outside the U.S.  A quirk in the OPT-CPT Calculators was fixed.  The "Total Full-time Days Used" cell was including the Total Part-time Days Used which was not necessary.  The final tally to determine OPT eligibility had not been affected by this error.  The error has been fixed and the cell now only sums the full-time OPT periods.  Boxes were added in several of the calculators to include the student's or scholar's name in case the advisor wants to print the calculator for the student or scholar, or for inclusion in an application for petition.  ----------------------
 |  | Notes on Version 3-1 (9/20/2010):  OPT STEM calculator was changed to subtract one day from the OPT STEM End Date because it has become the pattern of practice of the USCIS to grant the 17-month extension to the day that is one day less than the start date in the end-date month.  For example, USCIS will grant an extension from 10/16/2010 through 3/15/2012 even though Excel calculates 3/16/2010 as the end date of the full 17 months.  Also, the "+1" calculation was reintroduced to the "H, J, Other" calculators in the sections that calculate days used.  The previous version was not counting the start date of each of approval/authorization period.  This now returns a date in "...may work until" date field that is one "day" less than the original authorization start date.  For example, an orginal approval period that began on 1/20/2006 would calculate 6 years later to end on 1/19/2012.  In addition to this being the pattern that USCIS seems to employ in their calculations, previous versions that did not include the "+1" method occasionally produced a "...may work until" date that was one or more days too long (e.g., 6/12/2010 instead of 6/10/2010).  Note that leap years are counted as 366 days in the period of approval and in the recouped time.  Since the "...may work until" date is calculated by adding the number of days of eligibility remaining to the proposed start date, the resulting date will fall one day short if it falls in any month after February of leap year.  For example, the calculator may suggest 5/14/2012 as the "...may work until" when you expected 5/15/2012.