Average Points Per Expedition - Calculation Method

Does the calculation for “Avg. points per Expedition” that is shown on the Activator Results page (Activator Roll of Honor) include or exclude activations for which the activator received zero points?

For example, a new activator activates a 10-point summit but only makes 2 QSOs. He is awarded zero points for the activation. A week later he goes back to the same summit, makes 7 QSOs and is awarded 10 points. Is his Avg. points per Expedition value equal to 5 or 10?

73,

Eric KU6J

===========================================
Free SOTA Spot Monitor Software:
http://www.ku6j.com

In reply to KU6J:

I’d never considered how this was done till you asked Eric.

For each user:

avg = (sum(points) + sum(bonuspoints)) / count(activations)

So that means it does include non-scoring activations in the calculation.

Andy, MM0FMF
Database Manager

In reply to MM0FMF:

Thanks Andy, I was just curious as to how that worked. I’d say you are doing the calculation correctly based on how that value is labeled and described: each case is a valid activation or expedition whether points are awarded or not. Therefore they should all be counted.

I suppose the only possible downside is that if an activator’s personal goal is to keep their average high, it would discourage them from doing a quick activation of a summit where they only expect to be able to hand out a QSO or two, or to activate the same summit again in the same year. Excluding such activations from the calculation would remove those disincentives.

No worries, there are always tradeoffs and this probably isn’t anything worth worrying about.

73,

Eric KU6J

===========================================
Free SOTA Spot Monitor Software:
http://www.ku6j.com