[Dx4win] CQ DX Marathon

[Kostas sv1dpi]

Well, its not perfect but maybe a way for this
first of all create the missed dxcc countries and use this cty file just for 
the cq
Do a search (f8) from 1/1/06 to 31/12/06
In Logbook window create a report with the fields you want. Include the 
country prefix and put it first
Right click and a ad1c2006.csv file. Rename this file to ad1c2006.txt
open excel and open txt files. Then import the ad1c2006.txt with the fields 
seperated with ,
Choose all data and sort them by the prefix.
Manual delete the rows with the same prefix.
Sorry but i can't find a more automated way.
Best 73 and HNY
Kostas sv1dpi

----- Original Message ----- 
From: "Jim Reisert AD1C" <jjreisert at alum.mit.edu>
To: <dx4win at mailman.qth.net>
Sent: Sunday, December 31, 2006 7:20 PM
Subject: [Dx4win] CQ DX Marathon


> Is anyone else participating in the CQ DX Marathon?
>
> http://dxmarathon.com/
>
> I am trying to figure out the easiest way to merge my DX4WIN data into the 
> official submission form.
>
> There are three problems:
>
> - Need a list of countries worked in 2006, with callsigns, date, time, 
> band and mode.
>   DX4WIN doesn't provide this kind of listing directly.  My approach will 
> be to clear
>   any DXCC submitted/checked flags, mark all QSOs as confirmed, then 
> generate
>   a DXCC Submission Report (mixed-mode only) and save it to a file.  And 
> make
>   sure I don't ever save this log!
>
>   Of course the CQ list is sorted by entity name, not prefix. I should be 
> able to do
>   that with the DXCC submission report.  And the submission report does 
> not have
>   times in it.
>
> - Need a way to take that data and merge it into the spreadsheet.  I'm no 
> Excel wizard.
>   I'll probably just cut/paste.
>
>  - the CQ list contains a half-dozen entities which are not on the DXCC 
> list:
>
> 4U1VIC
> GM/Shetlands
> IH9-IG9/African Italy
> IT9/Sicily
> JW/Bear Island
> TA1/European Turkey
>
>   So I'll have to pull out those QSOs manually.
>
> - Repeat the same thing for the 40 CQ Zones.  I may try just 
> cutting/pasting the DXCC
>   info except for those countries with multiple zones (USA, Canada, 
> Russia, Australia).
>
> 73 - Jim AD1C
>
> -- 
> Jim Reisert AD1C, 7 Charlemont Court, North Chelmsford, MA 01863
> USA +978-251-9933, <jjreisert at alum.mit.edu>, http://www.ad1c.us
>
> _______________________________________________
> Dx4win mailing list
> Dx4win at mailman.qth.net
> http://mailman.qth.net/mailman/listinfo/dx4win
>
>