Track My Pay - TMP

Track My Pay - TMPTrack My Pay - TMPTrack My Pay - TMP

Track My Pay - TMP

Track My Pay - TMPTrack My Pay - TMPTrack My Pay - TMP
  • Home
  • TMP Spreadsheet Updates
  • FAQ's

Download Current Version

TMP V4.5 (xlsx)Download
TMP V4.4 (xlsx)Download

TMP Known Issues

BELOW IS A LIST OF IMPROVEMENTS WHICH WILL BE ADDRESSED IN FUTURE TMP VERSIONS

  • Working on an instructional video to visually display how the TMP Spreadsheet works and demonstrate how powerful the data aggregation is. I've received many video requests and feel it would be an instrumental tool for flattening the TMP user learning curve. My apologies for the delay and hope to have the instructional video posted here on the TMP website by the end of September. Thank you all for your patience!


  • RSV Guarantee is not accurately calculated in the TMP spreadsheet due to it's immense complexity and changing monthly values. For now, pilots on RSV will need to manually input their RSV Guarantee in order to capture the highest levels of spreadsheet accuracy. 


  • MBCBP 401k roll-over contributions (DC) are currently not accounted for. All excess DC money (once 401k is maxed) shows up as flight pay in the TMP spreadsheet. Working on building in a fix for MBCBP participants to account for excess DC beyond the max 401k limit. This will allow for a much easier way to cross-check annual MBCBP contribution totals and verify proper payment.


  • Jan/Feb 2023 Pay Rates - Currently, only two pay scales are used for 2023 calculations. Jan-Sept pay uses the new rates from March 1st 2023 PWA and Oct-Dec pay uses the UAL snap-up rates implemented in October 2023. This creates a discrepancy for Jan/Feb 2023 when comparing PAS to PS. The complexity of creating equations to account for the non-pay-banded fleets and different pay scales would require many hours of work to correct. For now, unprotect the sheet and manually enter the correct pay rate(s) for Jan/Feb 2023 if you want the PAS to calculate correctly.


  • 401k DC Crosscheck - Future TMP versions will include a crosscheck of estimated versus actual 401k DC.


  • Profit Sharing Calculator - Will estimate PS payout based on prior year eligible earnings and user input PS %.

Your feedback has been instrumental in perfecting the TMP Spreadsheet. Please keep it coming!

TMP Update History

BELOW IS A HISTORY OF THE UPDATES MADE TO THE SPREADSHEET

Quickly copy/paste your data from old TMP versions into newer versions to take advantage of updates without having to painstakingly repopulate your data.


UPDATED HISTORY:


Current

v4.5 (4.9.24)

- Removed Reserve Guarantee equation due to uncalculatable variables, now both time and pay inputs required to increase accuracy.

  

v4.4 (4.2.24)

- Fixed International Override equation

- Minor formatting changes


v4.3 (3.28.24)

- Corrected formatting and equation issues stemming from the FSB addition


v4.2 (3.27.24)

- Added the Full Service Bank (FSB) to the PAS section


v4.1 (3.21.24)

- Added 3 more "Other" rows (4 total) to cover unaccounted for PAS pay codes

- Fixed pay equations for 2025/2026

- Fixed International Override pay issue for all years


v4.0 (3.15.24)

- Adjusted Jan/Feb 2023 PAS "Total Gross Pay" down by 18% to roughly account for the higher payrates used to calculate Jan-Sept 2023 data. PAS vs PS comparison will not be as accurate as the rest of the year, but this is a patch for now until I can build in the old un-banded pay scales and adapt  the equations.

- Added equation to PS "Net Pay" enabling auto-population of data

- Equation streamlining in the PS section


v3.9 (3.14.24)

- Corrected error in PAS/PS file saving instructions in the "Welcome" sheet

- Updated the "longevity" equation 


v3.8 (3.13.24)

- Updated "Welcome" page for easier to understand instructions

- Fixed pay and time formatting in several sections

- Fixed equation for averaging totals to only account for months worked


v3.7 (3.12.24)

- Fixed "Total Annual Gross Earnings" equation error


v3.6 (3.10.24)

- Corrected formula issue in AVG PAY/DAY row preventing data to be displayed

- Expanded charts to include AVG and TOTAL data


v3.5 (3.9.24)

- Fixed Training, RSV Guarantee and Vacation pay formulas

- Added AC selection box guidance


v3.4 (3.8.24)

- Fixed pay scale calculation issue for AC2

- Corrected charts not displaying correct data

- Formatting changes for PS section


v3.3 (3.6.24)

- Unlocked Per Diem pay rate cells making them editable

- Reformatted monthly Per Diem cells for time values

- Other formatting changes


v3.2 (3.5.24)

- Unlocked "Other" cell and associated time cells

- Expanded International Override fix to all years.


v3.1 (3.2.24)

- Fixed time formatting issue in D183-O183

- Fixed International Override to correctly reflect CA/FO rates

- Redesigned Per Diem section to allow for annual changes to Per Diem rates


v3.0 (3.1.24)

- Overhauled hourly pay calculation equations


v2.1

- Added "Other" section to PAS section to capture missing PAS codes times


v2.0

- Added PS section

- Many format changes


v1.0

- Original TMP spreadsheet

- Only captured PAS data, did not include PS section

Copyright © 2024 Track My Pay - All Rights Reserved.

Powered by GoDaddy

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept