70cm Database Oddity

On 28-May-2026 on G/NP-028 I had 6 QSOs with 5 different callsigns on 70cm FM. If I look at the Activator Roll of Honour for All G/2026/433MHz/FM
image
it shows I have no points.
image
Is this a bug or have I misunderstood what this is showing me?

My scanning electron microscope is away for service so it was difficult to see the text but…

It all looks 100% OK to me. What did you expect it to show you?

Hi Richard, You have activated this summit several times this year and got 1 point for it on 16th January 2026. You won’t get any points for the summit again until 2027.

Is it the scoring for the challenge - that you are looking for? Rather than under the Honour Rolls - you would need to look under the Challenges tab:

That looks somewhat better!

73 Ed.

1 Like

Ctrl + zooms in on my browser.

That the >= 4 70cm contacts on one activation this year were enough to get one point.

This is the only time I have activated it on 70cm this year.

No I’m not! I was just curious how many others had got points for 70cm and was surprised to see no points against my callsign.

If I have misunderstood please explain what it is meant to show.

You have activated NP-028 many times this year and received a point on 16-01-2026. You have had the activator points for the summit for 2026 and all further activations in 2026 earn 0 points.

I should have tried the ctrl+ (and ctrl-), a bit slow today. Works nice with ctrl and rolling the mouse wheel.

1 Like

That’s something useful I have learned today! :grinning_face:

Hi Richard,

The problem is that the database awards points without any reference to the band. There is no separate points score table per band. The activation on 16 January earned you the only point you’ll get for the summit this year, no matter what bands or modes you use. You didn’t use 433 mhz that activation but the standard reports are limited to the points earned across the spectrum and for all modes.

If you want to accumulate points per band you will have to do it in your own spreadsheet. I did that to assess my activations for a CW-only score. I had to look for the activations where I made at least 4 contacts and discount any repeat activations of each summit.

Hope this helps…

73 Andrew VK1DA/VK2DA

2 Likes

Yes and no! I’m not sure what the exact algorithm is and whether it’s useful or not. I guess if that had been the first time I’d activated the summit this year I would have got the point. Does it require 4 contacts on a band to give credit or just one? I’d experiment but the Activator Roll of Honour has locked up for me.

Richard,

The first activation of the year where you make at least 4 contacts (irrespective of band and mode) gets the points for the summit. Subsequent activations of that summit (irrespective of band and mode) get 0 points.
It’s the activation that gets the points, not any band. If you look at the activator log and turn on the analysis option, you will see what bands and modes you made contacts, but the points are associated with the activation and not with a specific band or mode.

If you want to earn your points all on a specific band, make those contacts on that band only, or use that mode first then once you have at least 4 contacts on that band you can stray away to other bands.

Eg.. on the first activation of a given summit in each year, make 4 or more contacts on 433 fm. You’ll be awarded the points for that summit, but only once per year.

By the way, I’ve activated that summit on HF. But it’s my only G summit activated.
73 Andrew VK1DA/VK2DA

2 Likes

Points are stored per activation as they are calculated at upload. The algorithm for calculating scores is sufficiently complex due to the four QSO requirements and correlating across all activations for the year that we generally don’t want to calculate it on the fly, particularly for folks who do repeat summits and have lots of QSOs (side-eyes Tom on the Cloud :slight_smile: )

2 Likes

A basic rule in SOTA is that once a summit is qualified (i.e., activated with a minimum of 4 contacts - on any mix of bands) it does not earn any more points for the activator until the next calendar year. Points earned in the currently running 2m/70cm challenge do continue to accrue, however, for each contact, but these points do not add to your normal SOTA points total.

73 Ed.

1 Like

I’m well aware how SOTA points work and this has nothing to do with the current challenge. The issue is with what the honour roll is showing.

My expectation was that if you selected 70cm FM it would work out your activator score only looking at contacts on that band/mode but that isn’t what it does. I understand why it doesn’t as calculating everybody’s score on the fly would be too demanding on the database. It appears to select all activations where you have at least one QSO on that band/mode and add the points for that activation to the running total. So it doesn’t actually give accurate scores at all for a specific band/mode.

This all seems to be moot since I can’t get the honour roll to load anymore.

The filters select properties of which “thing” you are looking at.

For the activation honour roll, the filters select activation properties: association, date, band, mode. Filters are additive.

If you select association = W1 then only activations by participants who have set their home association to W1 are selected. This effectively excludes all non W1 activations because home associations are exclusive, you cannot be in 2 associations.

If you select date=2025 then the activation must have 2025 in the date. This effectively excludes all activations where the activation date is not 2025.

If you select band = 144MHz then activations where at least one QSO was on 2m will be included. If an activation is included then all of its QSOs are included.

If you select mode = FM then activations where at least one QSO was FM will be included. If an activation is included then all of its QSOs are included.

Thus selecting All G, 2026, 433MHz, FM will search every activation logged in any UK association (G,GW,GM,GD,GI,GJ,GU) that took place in 2026 where at least one QSO per activation was on 70cm FM. It takes a good few seconds to perform this because whilst we maintain a SQL Index of activation vs year to minimise table reads, all the other requirements involve reading the table of activation QSO and matching the search criteria, several GB of data. The time is spent in the DB search which is running on a dual core 2.5GHz Xeon, so you can see it is a heavy workload. That is on our dedicated DB server and web servers. The result is a list of users and # of activations that match your requirements.

Scoring is done as Andrew says when an activation is logged. It’s not done on the fly. This is to minimise load.

We do have a special app that Barry uses that can specifically search the DB to answer questions “check for MG award for All Activations qualified on 2m SSB alone” or "ALL 70cm FM ". But we don’t make it available generally as it would have a noticeable affect on the performance of the system.

Your request was All UK activations on 70cm FM in 2026 and it showed you a list including your single activation with 70cm FM QSOs. You scored 0 points for that as it was a repeat activation and the honour roll results showed that.

2 Likes