Review shared risk across commercial HVAC opportunities

Identify dependencies with evidence

Start with a dated opportunity snapshot containing distinct project IDs, approved quote amounts, buyer entities, procurement programs, stage evidence and known decision dependencies. Build a concentration sheet with group ID, included opportunities, gross quoted amount, documented shared dependency and unresolved relationships. Keep currencies and reporting periods consistent.

Do not merge records merely because their names resemble one another. A property manager may represent separate owners with independent approvals, while different site names may belong to one centrally funded program. Ask AI to suggest relationships only when supported by the supplied records, marking uncertain links for the account owner.

Work through a fictional portfolio

A fictional pipeline contains three $40,000 opportunities at different sites in the same buyer-approved replacement program and one independent $30,000 opportunity. Gross quoted value is $150,000. The three-site group represents $120,000, or 80% of that total, and depends on one documented funding decision. Four records do not mean four independent approval events.

If a manager supplies a hypothetical all-or-nothing scenario for that group, the worksheet can show $30,000 outside the group and $150,000 including it. These are scenario boundaries, not a revenue forecast. Do not multiply each record by a guessed win probability or claim a statistically valid confidence range from the concentration percentage.

Turn the sheet into an account question

Review duplicate proposals, mutually exclusive options and repeated project amounts before totaling. A base bid and alternate can be two documents for one opportunity rather than additive pipeline. Preserve a separate count of opportunities, approval groups and open scope alternatives.

Use the review to ask who controls the shared decision and what evidence will change its status. Do not infer budget failure or buying intent from silence. Link the sheet to the existing stage-evidence process, with a dated owner review. NIST supports checking generated claims against context; it does not supply the fictional grouping or a commercial forecasting model. Track wrong group assignments and double counts during a bounded pilot before describing improved forecast accuracy.

Review checklist

• Use evidence for shared buyer or funding dependencies.
• Exclude duplicate proposals and non-additive alternatives.
• Separate gross value, scenarios and forecasts.
• Keep uncertain relationships with the account owner.

Source context and limits

This original concentration worksheet is a commercial review aid, not a statistical forecasting model or investment recommendation. NIST is cited for general generated-information review, not as evidence that the fictional pipeline method predicts wins.