May 17, 2021
Innovation saves 37 work-hours using spreadsheet
ALI AL SALEM AIR BASE, Kuwait —
In a deployed environment, unit travel representatives (UTR) have to find an extra 40 hours to complete the duties required of them within a five-day span. On top of the typical 12-hour shifts, six days a week they spend on their primary duties, UTRs are responsible for tracking unit members’ travel back home.
U.S. Air Force Tech. Sgt. Caleb Jones, 386th Expeditionary Force Support Squadron manpower analyst, created a macro, a recorded series of instructions, with a spreadsheet that cuts the 40 hours of work into three hours or less by automating about 90% of a UTR’s duty when it comes to a data scrub, a process used to determine redeployment dates.