{"product_id":"salary-band-builder","title":"Salary Band Builder","description":"\u003cp\u003eTurn market pay data into a working salary structure. Set one anchor, a progression, and a spread, and the workbook builds every grade’s minimum, midpoint, and maximum, then shows where each of your people sits against their range.\u003c\/p\u003e\u003ch3\u003eOne Excel workbook that turns market data into salary bands\u003c\/h3\u003e\u003cp\u003eA working structure, not a blank grid. You set three numbers, the workbook builds the grades, and your people get placed against real ranges. It opens on a filled-in eight-grade example so the math is clear before you change anything.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSalary Band Builder.\u003c\/strong\u003e Set the Grade 1 midpoint from your market data, the midpoint progression between grades, and the range spread from minimum to maximum. The grade table builds itself: every grade gets a minimum, midpoint, and maximum, with range width, the progression step, and the overlap against the grade below shown per row. On the Employee Placement tab, enter each person’s grade and current salary, and their compa-ratio, range penetration, and Below min, In range, or Above max status fill in from the structure.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSummary, benchmarks, and the formulas in plain English.\u003c\/strong\u003e The Summary rolls everything onto one page: the structure’s shape, how many people sit within, below, or above their range, and the average compa-ratio. The Benchmark tab lists typical range spreads and midpoint progressions by job level, summarized from published compensation guidance, so your settings have a reference point. The Notes tab documents how every number is built, including the overlap identity, and explains how to read the placement metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThree steps from market data to a structure\u003c\/h3\u003e\u003cp\u003eYou set the anchor and two settings, the workbook builds the grades, and the placements tell you where pay needs attention.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSet three inputs.\u003c\/strong\u003e The Grade 1 midpoint from your salary survey, the midpoint progression between grades, and the range spread. The eight-grade table builds on its own.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePlace your people.\u003c\/strong\u003e Enter each person’s grade and current salary. Compa-ratio, range penetration, and an in-or-out-of-range status compute from the structure.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead it and adjust.\u003c\/strong\u003e The Summary shows who sits below, within, or above range. Change the progression or the spread and the whole structure rebuilds, so you can test settings before you commit.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eA structure built the way comp teams build them\u003c\/h3\u003e\u003cp\u003eSalary bands only hold up if the math behind them is the standard math and the settings have a reference point, so the workbook keeps both on the surface.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStandard pay-structure formulas.\u003c\/strong\u003e Midpoints step up by your progression, the minimum sits half the spread below the midpoint, and the maximum a full spread above the minimum. The Notes tab documents every calculation, including the overlap identity behind the last column.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBenchmarks with a stated source.\u003c\/strong\u003e Typical spreads and progressions by job level, summarized from published compensation guidance from WorldatWork, Mercer, and ERI, listed as reference points rather than rules.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA worked example to start from.\u003c\/strong\u003e The file opens on an eight-grade structure with five people placed, so you can see the formulas working end to end before you replace the inputs with your own.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWho it is built for\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eBuilt for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAn HR lead or owner formalizing pay for the first time, who needs real grades and ranges instead of one-off offers.\u003c\/li\u003e\n\u003cli\u003eA comp or HR team refreshing an existing structure, testing a new progression or spread before rolling it out.\u003c\/li\u003e\n\u003cli\u003eA consultant or fractional HR lead who builds pay structures for clients and wants the math documented and defensible.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eIf you are looking for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA decision on one person’s raise or promotion, not a structure. The Merit Increase Matrix turns performance and range position into an increase, and the Promotion and Internal Equity calculator pressure-tests a single move.\u003c\/li\u003e\n\u003cli\u003eWhat a hire costs all-in, not what the role should pay. The Employee Cost Calculator turns a salary into the fully loaded annual cost.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eBefore you buy\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eWhat format is it and can I edit it?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep. Duplicate it to test a second structure or to keep one per business unit.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThere are free salary band templates online. Why pay for this one?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eMost free templates are a grid you type ranges into, which leaves the hard part to you. This workbook builds the structure: you set an anchor, a progression, and a spread, and every grade’s minimum, midpoint, and maximum compute on the standard formulas. It then places your people against the ranges, ships benchmark settings with a stated source, and documents every calculation on the Notes tab, so the result holds up when someone asks how the ranges were built.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it include salary survey data?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNo. The workbook builds the structure around the market anchor you set, and its Benchmark tab covers structure settings, meaning spreads and progressions by level rather than pay rates by job. Pull the Grade 1 midpoint from a current salary survey at the percentile you target, usually the market median, and refresh it at least once a year.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow many grades does it build and can the design flex?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThe table builds eight grades; use as many as your structure needs and leave the rest. It applies one progression and one spread across the structure, which is the common setup for a small or mid-size organization. If your senior levels need wider ranges, the Notes tab walks through building them as a second structure with their own spread.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat is the refund policy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eDigital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat happens after I buy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCheckout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets and start with the three inputs on the Band Builder tab. If a file gives you trouble, email support@truestephr.com.\u003c\/p\u003e\u003cp\u003ePlanning estimates and general business information, not legal or tax advice. The structure is only as good as its market anchor, and pay changes carry legal and equity weight, so confirm current market data and review sensitive decisions with a qualified professional. Last reviewed June 2026.\u003c\/p\u003e","brand":"TrueStep HR","offers":[{"title":"Default Title","offer_id":52641503019284,"sku":"TSHR-018","price":39.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1013\/9048\/3732\/files\/TSHR-018__salary-band-builder-hero.jpg?v=1780979063","url":"https:\/\/shop.truestephr.com\/products\/salary-band-builder","provider":"TrueStep HR","version":"1.0","type":"link"}