Branch 2184

Wayne County, MI

ODL Tracking Overview

New 2022 ODL Tracking Template


This video series will guide you through the new 2022 ODL Tracking Template.

With features like Tracking Hours, Number of Opportunities, Missed Opportunities, Make up Hours from previous Quarter. Also with Options on Equitable level and filters to sort information by Name, NS Day or Total hours lowest to highest.


       You cannot download directly to a postal computer due to postal internet security, it deletes the coding that is in this template and makes it not functional. It should work on any computer that has Microsoft Excel on it. Download here.


      The Postal Service currently does not have the capability of accurately tracking all overtime worked according to the new contract (2019-2023) provision in Article 8.5.C.2. and is wide open to range of errors and manipulation.


      Now more than ever we should be tracking the overtime on a regular basis even if management has good intentions they are probably going to mess it up.


1. Setting up and saving your template. (3 minutes)


2. Creating and personalizing the spreadsheet for you office (2minute 40 seconds)

3. Getting started inputing data and understanding some of the basic functions.