Free TimeTrex resource
Put a base pay figure in context. Compare it with your approved salary range, see its position within the range, and model a target ratio without turning the result into a pay recommendation.
Use one currency and the same pay basis and work schedule for all four amounts. Example values are illustrative.
A 100% ratio means pay equals the midpoint you entered. It is not proof of market alignment, legal compliance or pay equity. A negative scenario change means a lower target, not a recommendation to reduce pay.
Compa ratio = base pay / midpoint × 100. Range penetration = (base pay − minimum) / (maximum − minimum) × 100. Scenario base pay = midpoint × scenario ratio / 100. Signed change = scenario pay − current pay.
With base pay of 60,000 and a 50,000 / 65,000 / 80,000 range, compa ratio is 92.31% and range penetration is 33.33%. A 100% target gives 65,000, a change of +5,000.
The minimum must be lower than the midpoint, and the midpoint lower than the maximum. Pay may fall outside the range: negative penetration and values above 100% remain visible. Zero pay is accepted as a mathematical boundary, not validated as lawful pay. Input amounts allow at most two decimal places. Ratios are rounded for display only.
It describes a pay figure relative to a selected reference range. It cannot identify discrimination, determine an appropriate salary, or replace job evaluation. The midpoint is supplied by you; this page contains no salary survey, imported market rates or recommended ratio bands.
Copy this CSV if your browser blocks the download.
General planning worksheet. Primary sources reviewed October 19, 2026. Examples and formulas are explained above; no market benchmarks or legal rules are imported.
Disclaimer: This worksheet describes salary positioning using your inputs. It does not determine fair pay, market competitiveness, pay equity or a required increase. Validate job scope, pay policy, currency and work schedule before making compensation decisions.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.