How to set up a leveling sheet that doesn't lie to you

A leveling sheet fails when its structure hides exclusions. You've seen it: three vendors quote the same RTU package and two of them quietly exclude freight, rigging, startup, and the curb adapter. The leveled number reads $180K, $182K, $211K, you pick the cheapest, and you eat $14K in scope six weeks later when the GC's PM asks why you don't have a crane scheduled for the lift.

The fix is structural, not cosmetic. No amount of highlighting the numbers in the PDF summary is going to catch an exclusion that's buried on page three of the vendor's proposal. What catches it is a leveling layout that forces every quote to answer the same questions before it gets compared on price.

The columns that matter

A leveling sheet with half the columns below is not a leveling sheet. It's a price list with extra formatting.

• Scope line. The specific item being compared (RTU-1, 40-ton, 460V/3ph). One row per item, not one row per vendor.
• Base price. What the vendor quoted for that item.
• Freight. Included or excluded. If excluded, a field where you enter the carried amount.
• Rigging and delivery. Same. Excluded means you carry it.
• Startup and commissioning. Same. Startup exclusions on rooftops get expensive fast.
• Curb, transition, accessories. Same. This is where half the scope gaps live. A $3,800 curb adapter is small money until two vendors quote without it.
• Lead time. In weeks. The cheapest number with a 32-week lead on a job that closes in eight months is not actually the cheapest number.
• Inclusions. Freeform. What's in the base price that another vendor might carry separately.
• Exclusions. Freeform. What the vendor isn't carrying.
• Adjusted total. Base plus carried freight, plus carried rigging, plus carried startup, plus carried accessories. This is the number you level against.

What not to do

Don't put the adjusted total next to the base price in the same column. Different columns, different rows on the review. If the base price is the lowest and the adjusted total is the highest, that's what you want to see when you scan the row, not to have to compute it in your head.

Don't accept a quote without all the inclusion and exclusion lines filled in. "See attached" is a red flag - the attached document is where the exclusions live. Make the vendor put the three most important exclusions on the face of the leveling sheet.

Don't level packages across vendors without normalizing scope. A package from vendor A with three units, a curb adapter, and startup is not the same bid as vendor B's two-unit package with no curbs. Break it down by component before you compare.

We ship this layout by default

The leveling view in designwinds has the columns above. You can add your own and customize the scope-line taxonomy per trade. But the skeleton is there because we've seen too many shops get bitten by the "lowest price minus freight" problem, and the skeleton is what makes it stop happening.

You can rebuild this in a spreadsheet. The shape of the grid matters more than the tool. If you're running leveling sheets without the adjusted-total column in a separate lane, start there this week regardless of what software you're in. A few hours of restructuring saves you a change order every six weeks.