I made this a long time ago, but it completely slipped my mind to post it until recently. This workbook is an Excel version I made for my office at NYU of the online work authorization calculator that I posted earlier.
The idea is the same: enter a student’s previous work authorization to see how much optional practical training (OPT) is remaining. If you enter the student’s completion date, it will tell you when the student can apply for (and use) post-completion OPT. To use it, you’ll need to download the workbook and enable content and macros.
As always, feedback is welcome.