; (ii) in clause (ii), by striking the analysis conducted under section 2(e) of the Border Patrol Agent Pay Reform Act of 2014 and inserting in its place a written staffing analysis ; and (iii) by adding at the end the following: (iv) Exclusion of certain employees In applying any percentage limit under clause (i) or (ii) to a location population, U.S. Customs and Border Protection shall exclude from such population any border patrol agent who is assigned a basic border patrol rate of pay under subparagraph (D)(iii) or (D)(iv) or who would reach the premium pay cap under section 5547 if assigned a level 1 border patrol rate of pay. (v) Application frequency The 10 percent limit under clause (i) or an alternative percentage limit under a waiver under clause (ii) shall be applied at the beginning of the first pay period beginning on or after January 1 each year. ; and (E) by striking subparagraph (G); (3) in subsection (b)(2)— (A) by amending subparagraph (C)(i) to read as follows: (i) any compensation under this section or any other provision of law in addition to the compensation provided under subparagraph (B); or ; (B) in subparagraph (E)— (i) by striking paid leave and inserting leave ; and (ii) by striking absent from work and inserting excused from work ; (C) in subparagraph (F)(ii), by striking and ; (D) by amending subparagraph (G) to read as follows: (G) if the border patrol agent participates in a full day of advanced training but does not perform the entire required amount of scheduled overtime work under subparagraph (A)(ii) on that day, the border patrol agent shall be deemed to have performed scheduled overtime work during nonwork periods to the extent necessary to reach the required amount, but such deemed credit may be applied to no more than 180 hours in a calendar year; otherwise, the agent shall accrue a debt of hours for scheduled overtime not worked on such a day; and