What This Calculator Measures
A plain trendline projects a value forward using a single fixed slope, treating every past period as equally informative. A weighted trendline "tilts" that projection by letting you dial up or down how much extra confidence you place on recent momentum versus the raw slope alone — useful when you suspect the trend has been accelerating or decelerating and want your projection to lean into that recent behavior without fully abandoning the longer-run slope.
This calculator takes a baseline value, a trend slope (change per period), a recent-weight dial from 0 to 1, and a number of periods to project forward, then optionally clamps the result to a realistic minimum and maximum so a projection can't run away to an implausible extreme.
How to Use This Well
- Enter baseline value and slope.
- Set recent weight and periods.
- Add clamp bounds.
- Review projected value.
- Adjust slope as needed.
Formula Breakdown
Weighted Slope = Trend Slope × (0.5 + Recent Weight ÷ 2)The (0.5 + Recent Weight ÷ 2) multiplier always stays between 0.5 (at Recent Weight = 0, half the raw slope) and 1.0 (at Recent Weight = 1, the full raw slope) — it never amplifies the slope beyond its original value, only dampens it toward half-strength when you assign less weight to recent behavior.
Worked Example
Baseline Value = 120, Trend Slope = 2.4, Recent Weight = 0.6, Periods = 6, Clamp Min = 100, Clamp Max = 150.
- Weighted slope: 2.4 × (0.5 + 0.6 ÷ 2) = 2.4 × 0.8 = 1.92
- Projected change: 1.92 × 6 = 11.52
- Projected value: 120 + 11.52 = 131.52
- Clamped value: 131.52 is already within the 100-150 range, so it's unchanged at 131.52
Interpretation Guide
| Result | Meaning | Action |
|---|---|---|
| Within clamp range | Projection is stable and plausible given your bounds. | Use the projection as-is. |
| Near clamp maximum | Projection is close to your upper limit. | Consider lowering the slope or recent weight to pull it back. |
| Near clamp minimum | Projection is close to your lower limit. | Consider raising the slope or recent weight for more headroom. |
| Outside clamp range | The raw projected value exceeds your bounds and has been capped. | Review whether the bounds or the slope assumption need revisiting. |
Common Mistakes to Avoid
- Assuming Recent Weight can amplify the slope. The formula only ranges from 0.5x to 1.0x of the raw slope — it dampens toward a more conservative half-slope at low weight, it never multiplies the slope beyond its original value even at Recent Weight = 1.
- Ignoring a negative slope. A negative Trend Slope produces a negative weighted slope and a declining projection — that's expected, not an error; check the sign of your slope input if you expected growth but got a falling projection.
- Setting clamp bounds too tight. If Clamp Min and Clamp Max are close together, almost any meaningful slope will project outside them and get capped, making the "Clamped Value" identical across very different slope assumptions — widen the bounds if you want the projection to actually reflect the slope.
- Using too many periods on a short-term slope. A slope measured from recent short-term data projected many periods into the future compounds any measurement noise — cross-check long-horizon projections against a longer historical baseline if one is available.
Measurement Notes
Treat this calculator as a directional planning instrument. Output quality improves when your inputs are anchored to recent real data instead of one-off assumptions.
Run multiple scenarios, document what changed, and keep the decision tied to trends, not a single result snapshot.
Related Calculators
- Exponential Smoothing Step Calculator — smooth a data series with a different recency-weighting method.
- Piecewise Linear Blend Calculator — blend multiple linear segments instead of a single tilted slope.
- Ratio Rebalance Optimizer Calculator — rebalance proportions toward a target instead of projecting a trend.