Thanks to all who replied regarding my spreadsheet to test Distance + Path
based scoring options. There appears to be some interest in a method like
this. I've made several changes to it.
http://www.n0hr.com/n0hr_dxtest_scoring.xls
Thanks to Bob, K0RC, for adding some mods including sort buttons.
Here's what's new with the latest version:
1) Bi directional sort buttons
2) Side-by-side regional comparison worksheet (2nd tab). Use this to compare
3 regions (ie West Coast, Mid West, New England).
3) Report of # entities in each "bin" of points. For example, "42 entities
between 1 and 2 points" for a QTH.
4) Formatting tweaks
This version will require you to enable macros (security thing) when you
open the spreadsheet.
Previous caveats remain.
73
Pat N0HR
http://www.n0hr.com
On Fri, Jul 1, 2011 at 9:04 PM, Guy Molinari <guy_molinari@hotmail.com>wrote:
> Nice work Pat. I spun it up with my lat/long. It "feels" right to me
> as I scroll through the entities and guage the relative level of difficulty.
>
> Seems pretty simple to me. The only change I would make is to create
> different factors for the low bands similar to WPX.
>
> 73,
> Guy, N7ZG
>
> > Date: Fri, 1 Jul 2011 14:44:50 -0500
> > From: pat@n0hr.com
>
> > To: cq-contest@contesting.com
> > Subject: [CQ-Contest] Distance + Path DX contest scoring method (Excel
> proof of concept)
> >
> > After reading many posts on this, I decided to create a scoring system
> that
> > would incorporate both distance and polar path. To do this, I simply used
> > Excel with the data from the CTY.DAT file to get lat/lon and then
> calculate
> > distance from a known point and the polar path. Users can test it with
> their
> > own QTH and tweak the effect of distance and polar path as they wish.
> >
> > The default scoring method gives a score of:
> >
> > QSO points = 1 + distance points + polar path points
> >
> > where distance points = point to point distance in km / 5000
> > and polar path points = 3 * (max latitude of the path/90) (for QSOs where
> > the longitude differs by more than 90 degrees)
> >
> > A bit complex? Perhaps.
> >
> > http://www.n0hr.com/n0hr_dxtest_scoring.xls
> >
> >
> > If you have MS Excel, please take a look at this and see if you think
> this
> > would make sense. Before you complain about it, note my comments at the
> top
> > of the sheet.
> >
> > 73
> > Pat N0HR
> > http://www.n0hr.com
> > _______________________________________________
> > CQ-Contest mailing list
> > CQ-Contest@contesting.com
> > http://lists.contesting.com/mailman/listinfo/cq-contest
>
_______________________________________________
CQ-Contest mailing list
CQ-Contest@contesting.com
http://lists.contesting.com/mailman/listinfo/cq-contest
|