Signalcrest
← Back to feed
stackoverflowdevtools

Dynamic Array to stack blocks of calculations

New excel formula feature

Steady

7

signal score

Steady

7-day est. ~17

Why this scored 7

every term, weighted
Velocity+3.0 / 40 max

Engagement per hour, normalized against the fastest item on its own source

Acceleration+0.0 / 25 max

Whether that velocity is itself speeding up, as a per-hour rate

Cross-source spread+0.0 / 25 max

How many independent communities are talking about the same entity

Recency+6.3 / 10 max

Decays to zero over 14 days

Saturation penalty2.5 / 30 max

Subtracted once something is big and old — we rank what's next, not what's peaked

Composite6.8

Weights are hand-tuned, not learned — we're calibrating them against realized trends as history accumulates. On a topic's first sighting there's no previous reading to compare against, so acceleration starts from a neutral prior rather than a measurement. Full methodology

Outlook

low confidence · estimate, not a guarantee

7-day

~17

range 925

14-day

~16

range 726

30-day

~16

range 328

Signal history

7-day window (free)

— — projected trajectory (estimate, not a guarantee)

Entities

exceldynamic arrays
Embed a live signal badge
Signalcrest signal badge
[![Signalcrest signal](https://www.signalcrest.app/api/badge/so%3A79983924)](https://www.signalcrest.app/topic/so%3A79983924)

Drop this in a README or blog post — it updates automatically as the score moves.