Signalcrest
← Back to feed
stackoverflowdevtools

Excel COM AutoFilter fails with 1004 on valid relative Field (range $AV$5:$ER$1501, Field=101) after PivotTable refresh (Python win32com)

Excel automation bug

Steady

10

signal score

🔗 3

sources · python

↓ Cooling

7-day est. ~2

ShareLinkedInOpen source ↗

Why this scored 10

every term, weighted
Velocity+0.3 / 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+5.6 / 25 max

How many independent communities are talking about the same entity

Recency+5.4 / 10 max

Decays to zero over 14 days

Saturation penalty−1.6 / 30 max

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

Composite9.7

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

~2

range 0–6

14-day

~0

range 0–4

30-day

~0

range 0–5

Signal history

7-day window (free)

— — projected trajectory (estimate, not a guarantee)

Entities

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

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